[Mavis100]

[07:55:39] [INFO] Now logging: errors


What is this?

[Mattakil]

That would be a plugin in your script that is checking for any issues, it will report them..Most likely CrashDetect or something similar, nothing to worry about

[Mavis100]

Quote:

Originally Posted by Mattakil That would be a plugin in your script that is checking for any issues, it will report them..Most likely CrashDetect or something similar, nothing to worry about

I got this


[07:58:57] [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)
[07:59: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 `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, "", "");

[Mattakil]

pawn Код:

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, "", "");

Try that, the vehicles were set to a string, I assume they should be set to a int, for the vehicleid

[Mavis100]

Quote:

Originally Posted by Mattakil pawn Код: 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, "", ""); Try that, the vehicles were set to a string, I assume they should be set to a int, for the vehicleid

Thank you, i'll try