30.04.2013, 17:39
Well i did split them up, like this:
But then a new problem occoured!
pawn Код:
strcat(Query,"UPDATE playerdb SET Teises=%d, Pickup=%d, Ikalintas=%d, Bilietas=%d, Admin=%d, Uniformd=%d, Kills=%d, Liga=%d,");
strcat(Query,"LigosLygis=%d, Telefonas=%d, Checkpoint=%d, Banke=%d, Namuose=%d,Textas=%d, Narkotikai=%d, Specialybe=%d, KalejimoLaikas=%d, Draudimas=%d,");
strcat(Query,"Biznis=%d, Pcar=%d, Lytis=%d, Drabuziai=%d, Uniforma=%d, Mobsas=%d, PLead=%d, CBuilding=%d,Pinigai=%d, XP=%d, PosX='%f', PosY='%f',");
strcat(Query,"PosZ='%f', Interior=%d, WantedLevel=%d, VirtualWorld=%d, Ginklas0=%d, Ammo0=%d,Ginklas1=%d, Ammo1=%d, Ginklas2=%d, Ammo2=%d, Ginklas3=%d, ");
strcat(Query,"Ammo3=%d, Ginklas4=%d, Ammo4=%d, Ginklas5=%d, Ammo5=%d, Ginklas6=%d, Ammo6=%d, Ginklas7=%d, Ammo7=%d, Ginklas8=%d, Ammo8=%d, Ginklas9=%d, ");
strcat(Query,"Ammo9=%d, Ginklas10=%d, Ammo10=%d, Ginklas11=%d, Ammo11=%d, pgang=%d, glead=%d WHERE Username='%s',");
strcat(Query,"booltoint(playerDB[playerid][teises],booltoint(playerDB[playerid][pickup]),booltoint(playerDB[playerid][ikalintas]),");
strcat(Query,"booltoint(playerDB[playerid][bilietas]),playerDB[playerid][admin],booltoint(playerDB[playerid][uniformd]),playerDB[playerid][kills],");
strcat(Query,"playerDB[playerid][liga],playerDB[playerid][ligoslygis],playerDB[playerid][telefonas],playerDB[playerid][checkpoint],");
strcat(Query,"playerDB[playerid][banke],playerDB[playerid][namuose],playerDB[playerid][textas],playerDB[playerid][narkotikai],");
strcat(Query,"playerDB[playerid][specialybe],playerDB[playerid][kalejimo_laikas],playerDB[playerid][draudimas],playerDB[playerid][biznis],");
strcat(Query,"playerDB[playerid][pcar],playerDB[playerid][lytis],playerDB[playerid][drabuziai],playerDB[playerid][uniforma],playerDB[playerid][mobsas],");
strcat(Query,"playerDB[playerid][plead],playerDB[playerid][cbuilding],playerDB[playerid][pinigai],playerDB[playerid][XP],Pos[0],Pos[1],Pos[2],");
strcat(Query,"GetPlayerInterior(playerid),GetPlayerWantedLevel(playerid),GetPlayerVirtualWorld(playerid),weps[0][0],weps[1][0],weps[0][1],");
strcat(Query,"weps[1][1],weps[0][2],weps[1][2],weps[0][3],weps[1][3],weps[0][4],weps[1][4],weps[0][5],weps[1][5],weps[0][6],weps[1][6],");
strcat(Query,"weps[0][7],weps[1][7],weps[0][8],weps[1][8],weps[0][9],weps[1][9],weps[0][10],weps[1][10],weps[0][11],weps[1][11],");
strcat(Query,"playerDB[playerid][pgang],playerDB[plead],name);");
pawn Код:
[17:53:42] EID: 1064 | Error: 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 '%d, Pickup=%d, Ikalintas=%d, Bilietas=%d, Admin=%d, Uniformd=%d, Kills=%d, Liga=' at line 1 | Query: UPDATE playerdb SET Teises=%d, Pickup=%d, Ikalintas=%d, Bilietas=%d, Admin=%d, Uniformd=%d, Kills=%d, Liga=%d,LigosLygis=%d, Telefonas=%d, Checkpoint=%d, Banke=%d, Namuose=%d,Textas=%d, Narkotikai=%d, Specialybe=%d, KalejimoLaikas=%d, Draudimas=%d,Biznis=%d, Pcar=%d, Lytis=%d, Drabuziai=%d, Uniforma=%d, Mobsas=%d, PLead=%d, CBuilding=%d,Pinigai=%d, XP=%d, PosX='%f', PosY='%f',PosZ='%f', Interior=%d, WantedLevel=%d, VirtualWorld=%d, Ginklas0=%d, Ammo0=%d,Ginklas1=%d, Ammo1=%d, Ginklas2=%d, Ammo2=%d, Ginklas3=%d, Ammo3=%d, Ginklas4=%d, Ammo4=%d, Ginklas5=%d, Ammo5=%d, Ginklas6=%d, Ammo6=%d, Ginklas7=%d, Ammo7=%d, Ginklas8=%d, Ammo8=%d, Ginklas9=%d, Ammo9=%d, Ginklas10=%d, Ammo10=%d, Ginklas11=%d, Ammo11=%d, pgang=%d, glead=%d WHERE Username='%s',booltoint(playerDB[playerid][teises],booltoin