18.08.2015, 20:04
First of all why are you using strcat if the cells aren't full yet?
Secondly, why are you using mysql_format if you have nothing to escape than numbers? Could simply do it with a standard format.
You might aswell want to check your MySQL logs and see what's really going on there and what is triggering the error.
Secondly, why are you using mysql_format if you have nothing to escape than numbers? Could simply do it with a standard format.
pawn Код:
new query[540];
format(query,sizeof(query),"UPDATE `players` SET `Admin`=%d, `VIP`=%d, `Ban`=%d, `Kills`=%d ,`Deaths`=%d, `Score`=%d,`Cash`=%d,`Skin`=%d,`Jail`=%d,`Headshots`=%d,`Bombs`=%d,`Veh1`=%d,`Veh2`=%d,`Veh3`=%d,`Veh4`=%d,`Veh5`=%d,`Veh6`=%d,`Veh7`=%d,`Veh8`=%d,`Veh9`=%d,`Veh10`=%d,`Lock`=%d,`Cloths`=%d,`Helper`=%d,`AK47`=%d,`M4`=%d,`SP`=%d,`Balance`=%d,`Duelwon`=%d,`Duellose`=%d,`Kick`=%d,`Warns`=%d,`Mathwin`=%d,`Moneybag`=%d WHERE `ID`=%d "
pInfo[playerid][pLevel] ,pInfo[playerid][Donator],pInfo[playerid][Banned],pInfo[playerid][Kills],pInfo[playerid][Deaths], GetPlayerScore(playerid), GetPlayerCash(playerid),pInfo[playerid][Skin],
pInfo[playerid][Jailed],pInfo[playerid][Headshot],pInfo[playerid][Bomb],pInfo[playerid][pVeh][0], pInfo[playerid][pVeh][1], pInfo[playerid][pVeh][2], pInfo[playerid][pVeh][4],
pInfo[playerid][pVeh][5], pInfo[playerid][pVeh][6], pInfo[playerid][pVeh][7], pInfo[playerid][pVeh][8], pInfo[playerid][pVeh][9], pInfo[playerid][pLock], pInfo[playerid][pclothes],
pInfo[playerid][pHelper], pInfo[playerid][pAk47], pInfo[playerid][pM4], pInfo[playerid][pSp], pInfo[playerid][pBankAccount], pInfo[playerid][pDuelsWon], pInfo[playerid][pDuelsLost],
pInfo[playerid][pKick], pInfo[playerid][Warnings], pInfo[playerid][Mathwin], pInfo[playerid][Moneybag], pInfo[playerid][PDID]);
mysql_tquery(mysql, query);
print(query);