Why this not working?
#2

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.



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);
You might aswell want to check your MySQL logs and see what's really going on there and what is triggering the error.
Reply


Messages In This Thread
Why this not working? - by MBilal - 18.08.2015, 19:36
Re: Why this not working? - by DaniceMcHarley - 18.08.2015, 20:04
Re: Why this not working? - by MBilal - 18.08.2015, 20:15
Re : Why this not working? - by Dutheil - 18.08.2015, 20:19

Forum Jump:


Users browsing this thread: 1 Guest(s)