24.04.2014, 04:46
PHP код:
[12:25:48] [INFO] Now logging: errors
[12:25:48] [ERROR] >> cache_get_row_float(...) - An error occured during the datatype conversion.
[12:25:48] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:25:48] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:25:48] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:25:48] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:25:48] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:25:48] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:27:00] [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)
[12:31:55] [INFO] Now logging: errors
[12:31:55] [ERROR] >> cache_get_row_float(...) - An error occured during the datatype conversion.
[12:31:55] [ERROR] >> cache_get_row_float(...) - An error occured during the datatype conversion.
[12:31:55] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:31:55] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:31:55] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:31:55] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:31:55] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:31:55] [ERROR] >> cache_get_row_int(...) - An error occured during the datatype conversion.
[12:32:56] [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)
Код:
//========================================================================================================= format(query, sizeof(query), "UPDATE `users` SET `note3` = '%s', `note3s` = %d, `attributes` = '%s', `paycheck` = %d, `paycheckmoney` = %d, `chequecode` = %d, `chequeID` = %d, `Online` = %d WHERE `name` = '%s'", PlayerInfo[playerid][pNote3], PlayerInfo[playerid][pNote3s], PlayerInfo[playerid][pAttributes], PlayerInfo[playerid][pPayCheckMade], PlayerInfo[playerid][pPayCheckMoney], PlayerInfo[playerid][pChequeCode], PlayerInfo[playerid][pChequeID], PlayerInfo[playerid][pOnline], GetName(playerid)); mysql_function_query(dbHandle, query, false, "", ""); //========================================================================================================= format(query, sizeof(query), "UPDATE `users` SET `upgrade` = %d, `paydaytime` = %d, `spawnhealth` = %.1f, `cellphone` = %d, `number` = %d, `savings` = %d, `housekey` = %d, `bizkey` = %d, `veh1` = '%s', `veh2` = '%s', `veh3` = '%s' `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, "", "");