Kol9n99
Ученик
Не сохраняются данные в mysql.
Вот код:
А вот логи:
Вот код:
PHP:
stock SaveAccounts(playerid)
{
new temp[128];
mysql_format(DATABASE, QUERY, sizeof(QUERY), "UPDATE `"TABLE_ACCOUNTS"` SET ");
format(temp,sizeof(temp),"`Skin`= '%i',",User[playerid][Skin]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Sex`= '%i',",User[playerid][Sex]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Cash`= '%i',",User[playerid][Cash]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Level`= '%i',",User[playerid][Level]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`PayDay`= '%i',",User[playerid][PayDay]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Exp`= '%i',",User[playerid][Exp]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Bank`= '%i',",User[playerid][Bank]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Leader`= '%i',",User[playerid][Leader]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Member`= '%i',",User[playerid][Member]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Model`= '%i',",User[playerid][Model]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Kills`= '%i',",User[playerid][Kills]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Deaths`= '%i',",User[playerid][Deaths]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Wanted`= '%i',",User[playerid][Wanted]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Rank`= '%i',",User[playerid][Rank]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`JailTime`= '%i',",User[playerid][JailTime]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`MestoJail`= '%i',",User[playerid][MestoJail]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Arrested`= '%i',",User[playerid][Arested]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Mute`= '%i'",User[playerid][Mute]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Lics`= '%s'",User[playerid][Lics]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Phones`= '%s'",User[playerid][Phones]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Texts`= '%s'",User[playerid][Text]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Lottery`= '%i'",User[playerid][Lottery]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Health`= '%f'",User[playerid][Health]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Crimes`= '%i'",User[playerid][Crimes]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Locked`= '%i'",User[playerid][Locked]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Warns`= '%s'",User[playerid][Warns]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Drugs`= '%s'",User[playerid][Drugs]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Upgrades`= '%s'",User[playerid][Upgrades]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`GunSkills`= '%s'",User[playerid][GunSkills]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`PayDayCash`= '%i'",User[playerid][PayDayCash]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Addiction`= '%i'",User[playerid][Addiction][0]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Addiction2`= '%i'",User[playerid][Addiction][1]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`WantedDeaths`= '%i'",User[playerid][WantedDeaths]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Mats`= '%i'",User[playerid][Mats]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Job`= '%i'",User[playerid][Job]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Debt`= '%i'",User[playerid][Debt][0]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Debt2`= '%i'",User[playerid][Debt][1]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Obedience`= '%i'",User[playerid][Obedience]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Referal`= '%s'",User[playerid][Referal]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Station`= '%i'",User[playerid][Station]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`TaxiSkill`= '%i'",User[playerid][TaxiSkill][0]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`TaxiSkill2`= '%i'",User[playerid][TaxiSkill][1]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Weapons`= '%s'",User[playerid][Weapon]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Ammos`= '%s'",User[playerid][Ammo]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Satiety`= '%i'",User[playerid][Satiety]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`Married`= '%s'",User[playerid][Married]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`MemGroup`= '%i'",User[playerid][MemGroup]);strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp)," WHERE ID = '%i'",User[playerid][UID]);strcat(QUERY,temp,sizeof(QUERY));
mysql_function_query(DATABASE, QUERY, true, "", "");
printf("%s", temp);
return true;
}
PHP:
----------
Loaded log file: "server_log.txt".
----------
SA-MP Dedicated Server
----------------------
v0.3z, (C)2005-2014 SA-MP Team
[12:38:05] filterscripts = "" (string)
[12:38:05]
[12:38:05] Server Plugins
[12:38:05] --------------
[12:38:05] Loading plugin: streamer
[12:38:05]
*** Streamer Plugin v2.6.1 by Incognito loaded ***
[12:38:05] Loaded.
[12:38:05] Loading plugin: sscanf
[12:38:05]
[12:38:05] ===============================
[12:38:05] sscanf plugin loaded.
[12:38:05] Version: 2.8.1
[12:38:05] (c) 2012 Alex "Y_Less" Cole
[12:38:05] ===============================
[12:38:05] Loaded.
[12:38:05] Loading plugin: mysql
[12:38:05] >> plugin.mysql: running on 1 thread.
[12:38:05] >> plugin.mysql: R31 successfully loaded.
[12:38:05] Loaded.
[12:38:05] Loading plugin: dc_cmd
[12:38:05] Daniel's CMD plugin v2.8
[12:38:05] (c) 2014 Daniel_Cortez
[12:38:05] www.*********.ru
[12:38:05] Loaded.
[12:38:05] Loading plugin: CVector
[12:38:05] -------------------------------------------------------
[12:38:05] - -
[12:38:05] - Vectoral Pawn v1.0 Loaded -
[12:38:05] - by Skyline. -
[12:38:05] - -
[12:38:05] -------------------------------------------------------
[12:38:05] Loaded.
[12:38:05] Loaded 5 plugins.
[12:38:05]
[12:38:05] Filterscripts
[12:38:05] ---------------
[12:38:05] Loaded 0 filterscripts.
[12:38:05] ----------------------------------------------------------
[12:38:05] Blalblalbalblal
[12:38:05] ----------------------------------------------------------
[12:38:05] Number of vehicle models: 0
[12:38:05] [Загружено фракций]: <21>. Потрачено: <2 мс>
[12:38:05] [Загружено домашних автомобилей]: <3>. Потрачено: <0 мс>.
[12:38:05] [Загружено другое]: <->. Потрачено: <0 мс>.
[12:38:05] [Загружено входов]: <58>. Потрачено: <6 мс>.
[12:38:05] [Загружено бизнесов]: <83>. Потрачено: <8 мс>.
[12:38:05] [Загружено домов]: <478>. Потрачено: <32 мс>.
[12:38:05] [Загружено орг/раб. автомобилей]: <356>. Потрачено: <16 мс>.
[12:38:05] [Загружено ганг зон]: <132>. Потрачено: <2 мс>.
[12:38:05] [Загружено банкоматов]: <16>. Потрачено: <0 мс>.
[12:38:05] [Загружено зеленых зон]: <7>. Потрачено: <0 мс>.
[12:38:05] [Загружено GPS]: <25>. Потрачено: <0 мс>.
[12:38:05] [Загружено автомастерских]: <1>. Потрачено: <0 мс>.
[12:38:05] [Загружено складов]: <5>. Потрачено: <0 мс>.
[12:38:23] Incoming connection: 25.24.64.53:4783
[12:38:23] [join] Kolyan_Slezenko has joined the server (0:25.24.64.53)
[12:39:32] WHERE ID = '3'
[12:39:32] [part] Kolyan_Slezenko has left the server (0:1)
[12:39:37] --- Server Shutting Down.
[12:39:37] UPDATE `storage` SET `stID`= '1', `stValue`= '0', `stX`= '2360.320068', `stY`= '-647.916992', `stZ`= '128.233002', `stV`= '0', `stI`= '0', `stName`= 'На лесопилке' WHERE stID = '1'
[12:39:37] UPDATE `storage` SET `stID`= '2', `stValue`= '24', `stX`= '1853.550049', `stY`= '-1144.180054', `stZ`= '27.150000', `stV`= '0', `stI`= '0', `stName`= 'Дерева' WHERE stID = '2'
[12:39:37] UPDATE `storage` SET `stID`= '3', `stValue`= '23', `stX`= '1853.550049', `stY`= '-1144.180054', `stZ`= '26.799999', `stV`= '0', `stI`= '0', `stName`= 'Бумаги' WHERE stID = '3'
[12:39:37] UPDATE `storage` SET `stID`= '4', `stValue`= '24', `stX`= '2565.500000', `stY`= '-1292.800049', `stZ`= '1045.349976', `stV`= '2', `stI`= '0', `stName`= 'Дерева' WHERE stID = '4'
[12:39:37] UPDATE `storage` SET `stID`= '5', `stValue`= '23', `stX`= '2565.500000', `stY`= '-1292.800049', `stZ`= '1045.069946', `stV`= '2', `stI`= '0', `stName`= 'Бумаги' WHERE stID = '5'
PHP:
[12:38:32] [ERROR] cache_get_field_content_int - invalid data type
[12:39:32] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`Lics`= '2, 1'`Phones`= '1, 181892, 1'`Texts`= ''`Lottery`= '14'`Health`= '97.00' at line 1
[12:39:32] [ERROR] CMySQLQuery::Execute[()] - (error #1054) Unknown column 'JobTime' in 'field list'