MySQL input line too long - Printable Version
+- SA-MP Forums Archive (
https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (
https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (
https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL input line too long (
/showthread.php?tid=416249)
MySQL input line too long -
dusk - 16.02.2013
pawn Код:
stock SaveStats(playerid)
{
new query[256];
format(query,sizeof(query),"UPDATE users SET alevel = '%d', Items = '%s', Money = '%d', level = '%d', Job = '%d', Mechanic = '%d', SkinID = '%d', Mseeds = '%d', Marijuana = '%d', \ //THIS IS LINE 191
Police = '%d' WHERE username = '%s'",PlayerInfo[playerid][alevel],PlayerInfo[playerid][items],PlayerInfo[playerid][money],PlayerInfo[playerid][level],PlayerInfo[playerid][job],PlayerInfo[playerid][Mechanic],PlayerInfo[playerid][SkinID],PlayerInfo[playerid][Mseeds],PlayerInfo[playerid][Marijuana],PlayerInfo[playerid][Police],Name);
mysql_query(query);
return 1;
}
pawn Код:
C:\Users\Justas\Desktop\testserver 0.3x\gamemodes\rp.pwn(191) : error 075: input line too long (after substitutions)
C:\Users\Justas\Desktop\testserver 0.3x\gamemodes\rp.pwn(192) : error 017: undefined symbol "Na"
C:\Users\Justas\Desktop\testserver 0.3x\gamemodes\rp.pwn(193) : warning 217: loose indentation
C:\Users\Justas\Desktop\testserver 0.3x\gamemodes\rp.pwn(193) : error 017: undefined symbol "me"
C:\Users\Justas\Desktop\testserver 0.3x\gamemodes\rp.pwn(193) : error 029: invalid expression, assumed zero
C:\Users\Justas\Desktop\testserver 0.3x\gamemodes\rp.pwn(193) : warning 215: expression has no effect
C:\Users\Justas\Desktop\testserver 0.3x\gamemodes\rp.pwn(194) : warning 217: loose indentation
Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase
Re: MySQL input line too long -
DaRk_RaiN - 16.02.2013
pawn Код:
stock SaveStats(playerid)
{
new query[256];
format(query,sizeof(query),"UPDATE users SET alevel = '%d', Items = '%s', Money = '%d', level = '%d', Job = '%d', Mechanic = '%d', SkinID = '%d', Mseeds = '%d', Marijuana = '%d', \ //THIS IS LINE 191
Police = '%d' WHERE username = '%s',
PlayerInfo[playerid][alevel],PlayerInfo[playerid][items],
PlayerInfo[playerid][money],PlayerInfo[playerid][level],PlayerInfo[playerid][job],
PlayerInfo[playerid][Mechanic],PlayerInfo[playerid][SkinID],PlayerInfo[playerid][Mseeds],
PlayerInfo[playerid][Marijuana],PlayerInfo[playerid][Police],Name);
mysql_query(query);
return 1;
}
Re: MySQL input line too long -
dusk - 16.02.2013
Well that helped,can you tell me WHY? Cuz i see no logic in this