SA-MP Forums Archive
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