MySQL Update error
#1

this is the error

Код:
[11:58:03] Error in mysql_query: 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 'Int=0,VirWorld=0,Local=255,Team=3 WHERE id=25' at line 1
the error spamming my server log.

this is my onplayerupdate:

Код:
public OnPlayerUpdate(playerid)
{
	if(IsPlayerConnected(playerid))
	{
	if(IsPlayerNPC(playerid)){return 1;}
		if(gPlayerLogged[playerid])
		{
			MySQLCheckConnection();
			new query[MAX_STRING];
			format(query, MAX_STRING, "UPDATE players SET ");
			MySQLUpdatePlayerStr(query, PlayerInfo[playerid][pSQLID], "Password", PlayerInfo[playerid][pKey]);
			PlayerInfo[playerid][pCash] = GetCash(playerid);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Level", PlayerInfo[playerid][pLevel]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Admin", PlayerInfo[playerid][pAdmin]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "DonateRank", PlayerInfo[playerid][pDonateRank]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "UpgradePoints", PlayerInfo[playerid][gPupgrade]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Registered", PlayerInfo[playerid][pReg]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Sex", PlayerInfo[playerid][pSex]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Age", PlayerInfo[playerid][pAge]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "CK", PlayerInfo[playerid][pCK]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Cash", PlayerInfo[playerid][pCash]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Bank", PlayerInfo[playerid][pAccount]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Crimes", PlayerInfo[playerid][pCrimes]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Mute", PlayerInfo[playerid][pMuted]);
 			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Warn", PlayerInfo[playerid][pWarns]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Skin", PlayerInfo[playerid][pChar]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Int", PlayerInfo[playerid][pInt]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "VirWorld", PlayerInfo[playerid][pVirWorld]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Local", PlayerInfo[playerid][pLocal]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Team", PlayerInfo[playerid][pTeam]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Model", PlayerInfo[playerid][pModel]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Arrested", PlayerInfo[playerid][pArrested]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "WantedDeaths", PlayerInfo[playerid][pWantedDeaths]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Phonebook", PlayerInfo[playerid][pPhoneBook]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "WalkiTalki",PlayerInfo[playerid][pWT]);
 			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "GPS",PlayerInfo[playerid][pGPS]);
 			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Cards",PlayerInfo[playerid][pCards]);
 			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Flop1",PlayerInfo[playerid][pFlop1]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Flop2",PlayerInfo[playerid][pFlop2]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Flop3",PlayerInfo[playerid][pFlop3]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "River",PlayerInfo[playerid][pRiver]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Turn",PlayerInfo[playerid][pTurn]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Dealer",PlayerInfo[playerid][pDealer]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "LottoNr", PlayerInfo[playerid][pLottoNr]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Fishes", PlayerInfo[playerid][pFishes]);
			MySQLUpdatePlayerFlo(query, PlayerInfo[playerid][pSQLID], "SHealth", PlayerInfo[playerid][pSHealth]);
			GetPlayerHealth(playerid,PlayerInfo[playerid][pHealth]);
			MySQLUpdatePlayerFlo(query, PlayerInfo[playerid][pSQLID], "Health", PlayerInfo[playerid][pHealth]);
			GetPlayerArmourAC(playerid,PlayerInfo[playerid][pArmour]);
			MySQLUpdatePlayerFlo(query, PlayerInfo[playerid][pSQLID], "Armour",PlayerInfo[playerid][pArmour]);
			if ((PlayerInfo[playerid][pPosX]==0.0 && PlayerInfo[playerid][pPosY]==0.0 && PlayerInfo[playerid][pPosZ]==0.0))
			{
				PlayerInfo[playerid][pPosX] = 1684.9;
				PlayerInfo[playerid][pPosY] = -2244.5;
				PlayerInfo[playerid][pPosZ] = 13.5;
			}
			if(Spectate[playerid] != 255)
			{
				PlayerInfo[playerid][pPosX] = Unspec[playerid][sPx];
				PlayerInfo[playerid][pPosY] = Unspec[playerid][sPy];
				PlayerInfo[playerid][pPosZ] = Unspec[playerid][sPz];
				PlayerInfo[playerid][pInt] = Unspec[playerid][sPint];
				PlayerInfo[playerid][pLocal] = Unspec[playerid][sLocal];
			}
			MySQLUpdatePlayerFlo(query, PlayerInfo[playerid][pSQLID], "PosX", PlayerInfo[playerid][pPosX]);
			MySQLUpdatePlayerFlo(query, PlayerInfo[playerid][pSQLID], "PosY", PlayerInfo[playerid][pPosY]);
			MySQLUpdatePlayerFlo(query, PlayerInfo[playerid][pSQLID], "PosZ", PlayerInfo[playerid][pPosZ]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Crashed", PlayerInfo[playerid][pCrashed]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "PhNumber", PlayerInfo[playerid][pPnumber]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "PlayHours", PlayerInfo[playerid][pConnectTime]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Exp", PlayerInfo[playerid][pExp]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "HouseKey", PlayerInfo[playerid][pPhousekey]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "BizzKey", PlayerInfo[playerid][pPbiskey]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "CarKey", PlayerInfo[playerid][pPcarkey]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "CarKey2",PlayerInfo[playerid][pPcarkey2]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "CarKey3",PlayerInfo[playerid][pPcarkey3]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Job", PlayerInfo[playerid][pJob]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Faction", PlayerInfo[playerid][pFaction]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Paycheck", PlayerInfo[playerid][pPayCheck]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "HeadValue", PlayerInfo[playerid][pHeadValue]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Jailed", PlayerInfo[playerid][pJailed]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "JailTime", PlayerInfo[playerid][pJailTime]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Materials", PlayerInfo[playerid][pMats]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Drugs", PlayerInfo[playerid][pDrugs]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Weed",PlayerInfo[playerid][pWeed]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Lsd",PlayerInfo[playerid][pLsd]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Heroin",PlayerInfo[playerid][pHeroin]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Cocaine",PlayerInfo[playerid][pCocaine]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Morphine",PlayerInfo[playerid][pMorphine]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Leader", PlayerInfo[playerid][pLeader]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Member", PlayerInfo[playerid][pMember]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "FMember", PlayerInfo[playerid][pFMember]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "FRank", PlayerInfo[playerid][pRank]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "PayDay", PlayerInfo[playerid][pPayDay]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "PayDayHad", PlayerInfo[playerid][pPayDayHad]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "PayDayPU",PlayerInfo[playerid][pPayDayPU]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Deaths", PlayerInfo[playerid][pDeaths]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Gun1", PlayerInfo[playerid][pGun1]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Gun2", PlayerInfo[playerid][pGun2]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Gun3", PlayerInfo[playerid][pGun3]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Gun4", PlayerInfo[playerid][pGun4]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Ammo1", PlayerInfo[playerid][pAmmo1]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Ammo2", PlayerInfo[playerid][pAmmo2]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Ammo3", PlayerInfo[playerid][pAmmo3]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Ammo4", PlayerInfo[playerid][pAmmo4]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "CarTime", PlayerInfo[playerid][pCarTime]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Watch", PlayerInfo[playerid][pWatch]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Wins", PlayerInfo[playerid][pWins]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Loses", PlayerInfo[playerid][pLoses]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Tutorial", PlayerInfo[playerid][pTut]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Teory",PlayerInfo[playerid][pTeory]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "DrivingLic", PlayerInfo[playerid][pCarLic]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "FlyingLic", PlayerInfo[playerid][pFlyLic]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "BoatLic", PlayerInfo[playerid][pBoatLic]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "FishLic", PlayerInfo[playerid][pFishLic]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "WeaponLic", PlayerInfo[playerid][pGunLic]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Contract", PlayerInfo[playerid][pContractTime]);
			if(PlayerInfo[playerid][pDonateRank] < 1) { PlayerInfo[playerid][pFuel] = 0; }
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Fuel", PlayerInfo[playerid][pFuel]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Married", PlayerInfo[playerid][pMarried]);
			MySQLUpdatePlayerStr(query, PlayerInfo[playerid][pSQLID], "MarriedTo", PlayerInfo[playerid][pMarriedTo]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "FishTool",PlayerInfo[playerid][pFishTool]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "InvWeapon",PlayerInfo[playerid][pInvWeapon]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "InvAmmo",PlayerInfo[playerid][pInvAmmo]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "InvDrugs",PlayerInfo[playerid][pInvDrugs]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "InvDrugsName",PlayerInfo[playerid][pInvDrugsName]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Lighter",PlayerInfo[playerid][pLighter]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Cigarettes",PlayerInfo[playerid][pCigarettes]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Lang1",PlayerInfo[playerid][pLang1]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Lang2",PlayerInfo[playerid][pLang2]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "HaveLock",PlayerInfo[playerid][pLockH]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "HaveAlarm",PlayerInfo[playerid][pAlarmH]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "EngineLevel",PlayerInfo[playerid][pImo]);
            MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "DiseaseLevel",PlayerInfo[playerid][pDiseaseRank]);
            MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Disease",PlayerInfo[playerid][pDisease]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "AcceptDeath",PlayerInfo[playerid][pDie]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "FishCount",PlayerInfo[playerid][pFishCount]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Bag",PlayerInfo[playerid][pBag]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "LegalFaction",PlayerInfo[playerid][pLegalF]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Duty",PlayerInfo[playerid][pDuty]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "CrashSkin",PlayerInfo[playerid][pModelx]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "ResponseAdmins",PlayerInfo[playerid][pHAdmin]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "AdminWarns",PlayerInfo[playerid][pAdminWarns]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "LicensePoints",PlayerInfo[playerid][pLicensePoints]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "FightStyle", PlayerInfo[playerid][pFighting]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "DetSkill", PlayerInfo[playerid][pDetSkill]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "SexSkill", PlayerInfo[playerid][pSexSkill]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "BoxSkill", PlayerInfo[playerid][pBoxSkill]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "LawSkill", PlayerInfo[playerid][pLawSkill]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "MechSkill", PlayerInfo[playerid][pMechSkill]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "JackSkill", PlayerInfo[playerid][pJackSkill]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "CarSkill", PlayerInfo[playerid][pCarSkill]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "NewsSkill", PlayerInfo[playerid][pNewsSkill]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "DrugsSkill", PlayerInfo[playerid][pDrugsSkill]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "CookSkill", PlayerInfo[playerid][pCookSkill]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "FishSkill", PlayerInfo[playerid][pFishSkill]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "AlcoholPerk", PlayerInfo[playerid][pAlcoholPerk]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "DrugPerk", PlayerInfo[playerid][pDrugPerk]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "MiserPerk", PlayerInfo[playerid][pMiserPerk]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "PainPerk", PlayerInfo[playerid][pPainPerk]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "TraderPerk", PlayerInfo[playerid][pTraderPerk]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "InGame",PlayerInfo[playerid][pInGame]);
			MySQLUpdatePlayerInt(query, PlayerInfo[playerid][pSQLID], "Locked", PlayerInfo[playerid][pLocked]);
  	        MySQLUpdateFinish(query, PlayerInfo[playerid][pSQLID]);
}
	}
	return 1;
}
Thanks thanks thanks for who are helping
Reply
#2

Quote:
Originally Posted by Script
Посмотреть сообщение
the error spamming my server log.
Ofcourse .. It is called up to 30 times per second, per player.
Read this first: http://forum.sa-mp.com/showthread.ph...onplayerupdate

And I can't tell where the error in the syntax is, because you have a custom function for it.
Reply
#3

Quote:
Originally Posted by Vince
Посмотреть сообщение
Ofcourse .. It is called up to 30 times per second, per player.
Read this first: http://forum.sa-mp.com/showthread.ph...onplayerupdate

And I can't tell where the error in the syntax is, because you have a custom function for it.
Yes i know why the spam is...
but i didn't find any query wrong that give me the error.
Reply
#4

Print the query before executing it
Reply
#5

Quote:
Originally Posted by dice7
Посмотреть сообщение
Print the query before executing it
can you explain me a bit more ? thanks
Reply
#6

onplayerupdate should be in the same sequence as the mysql database. Sorry for bad English
Reply
#7

It is.....
Reply
#8

Quote:
Originally Posted by Script
Посмотреть сообщение
It is.....
It shouldn't be, your script/server won't be capable of handling more than a couple of players without severe lag or crashes.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)