SA-MP Forums Archive
Error 075: input line too long (after substitutions) - 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: Error 075: input line too long (after substitutions) (/showthread.php?tid=577836)


Error 075: input line too long (after substitutions) - nezo2001 - 14.06.2015

What should I do with this
PHP код:
format(update,sizeof(update),"UPDATE users SET pMoney='%i', pAdmin='%i', pSkin='%i', pScore='%i', pPolice='%i', pGang='%i', pHorseshoes='%i', pDealer='%i', pWarnings='%i', pJob='%i', pHouseID='%i' WHERE pName = '%s'",GetPlayerMoney(playerid), PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pSkin], GetPlayerScore(playerid), PlayerInfo[playerid][pPolice], PlayerInfo[playerid][pGang], PlayerInfo[playerid][pHorseshoes], PlayerInfo[playerid][pDealer], PlayerInfo[playerid][pWarnings],PlayerInfo[playerid][pJob], PlayerInfo[playerid][pHouseID], PlayerName(playerid)); 


Re: Error 075: input line too long (after substitutions) - b3nz - 14.06.2015

Delete, my bad.

Re: Error 075: input line too long (after substitutions) - b3nz - 14.06.2015

Split it to two queries. Or, you can do this:

pawn Код:
format (update, sizeof (update), "UPDATE users SET pMoney = '%i' ......, pHorseshoes = '%i'", ...);
format (update, sizeof (update), "%s, pDealer = '%i'....., ", update, ...);


Re: Error 075: input line too long (after substitutions) - zeth98 - 14.06.2015

Try this

PHP код:
format(update,sizeof(update),"UPDATE users SET pMoney='%i', pAdmin='%i', pSkin='%i', pScore='%i', pPolice='%i', pGang='%i', pHorseshoes='%i', pDealer='%i', pWarnings='%i', pJob='%i', pHouseID='%i' WHERE pName = '%s'",
    GetPlayerMoney(playerid), PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pSkin], GetPlayerScore(playerid), PlayerInfo[playerid][pPolice], PlayerInfo[playerid][pGang], PlayerInfo[playerid][pHorseshoes], PlayerInfo[playerid][pDealer], PlayerInfo[playerid][pWarnings],PlayerInfo[playerid][pJob], PlayerInfo[playerid][pHouseID], PlayerName(playerid));