Код:
[11:50:19] [INFO] Now logging: errors
[11:50:19] [ERROR] >> cache_get_row_float(...) - An error occured during the datatype conversion.
[11:50:19] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[11:50:19] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[11:50:19] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[04:38:45] [INFO] Now logging: errors
[04:38:45] [ERROR] >> cache_get_row_float(...) - An error occured during the datatype conversion.
[04:38:46] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[04:38:46] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[04:38:46] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[04:40:46] [ERROR] ProcessQueryThread() - 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 '`melee` = 0, `wep1`= 0, `wep2` = 0, `ammo1` = 0, `ammo2`= 0 WHERE `name` = 'Casp' at line 1 (error ID: 1064)
[04:41:09] [ERROR] ProcessQueryThread() - 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 '`melee` = 0, `wep1`= 0, `wep2` = 0, `ammo1` = 0, `ammo2`= 0 WHERE `name` = 'Casp' at line 1 (error ID: 1064)
[04:42:08] [INFO] Now logging: errors
[04:42:09] [ERROR] >> cache_get_row_float(...) - An error occured during the datatype conversion.
[04:42:09] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[04:42:09] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[04:42:09] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
Код HTML:
format(query, sizeof(query), "UPDATE `users` SET `upgrade` = %d, `paydaytime` = %d, `spawnhealth` = %.1f, `cellphone` = %d, `number` = %d, `savings` = %d, `housekey` = %d, `bizkey` = %d, `veh1` = %d, `veh2` = %d, `veh3` = %d `melee` = %d, `wep1`= %d, `wep2` = %d, `ammo1` = %d, `ammo2`= %d WHERE `name` = '%s'",
PlayerInfo[playerid][pUpgrade],
PlayerInfo[playerid][pPayDayTime],
PlayerInfo[playerid][pSHealth],
PlayerInfo[playerid][pCellPhone],
PlayerInfo[playerid][pNumber],
PlayerInfo[playerid][pSavings],
PlayerInfo[playerid][pHouseKey],
PlayerInfo[playerid][pBizKey],
PlayerVehicle[playerid][pVeh1],
PlayerVehicle[playerid][pVeh2],
PlayerVehicle[playerid][pVeh3],
PlayerInfo[playerid][pMeleeWep],
GetPrimaryWeapon(playerid),
GetSecondaryWeapon(playerid),
GetWeaponAmmo(playerid, PlayerInfo[playerid][pPerm1]),
GetWeaponAmmo(playerid, PlayerInfo[playerid][pPerm2]),
GetName(playerid));
mysql_function_query(dbHandle, query, false, "", "");
I can't save and load something like House's info "Like written something that can be use in 3DText by an admin and i can't save interior and exit position " and a part of Player Info, why?