input line too long (after substitutions)
#1

pawn Код:
new query[1024];

mysql_format(con, query, sizeof(query),
        "UPDATE `players` SET `lastwep0` = '%d', `lastammo0` = '%d', \
        `lastwep1` = '%d', `lastammo1` = '%d', `lastwep2` = '%d', `lastammo2` = '%d', \
        `lastwep3` = '%d', `lastammo3` = '%d', `lastwep4` = '%d', `lastammo4` = '%d', \
        `lastwep5` = '%d', `lastammo5` = '%d', `lastwep6` = '%d', `lastammo6` = '%d', \
        `lastwep7` = '%d', `lastammo7` = '%d', `lastwep8` = '%d', `lastammo8` = '%d', \
        `lastwep9` = '%d', `lastammo9` = '%d', `lastwep10` = '%d', `lastammo10` = '%d', \
        `lastwep11` = '%d', `lastammo11` = '%d', `lastwep12` = '%d', `lastammo12` = '%d', \
        `lastwep13` = '%d', `lastammo13` = '%d'     WHERE `id` = '%d' LIMIT 1"
,
        PlayerInfo[playerid][LastWep0], PlayerInfo[playerid][LastAmmo0],
        PlayerInfo[playerid][LastWep1], PlayerInfo[playerid][LastAmmo1],
        PlayerInfo[playerid][LastWep2], PlayerInfo[playerid][LastAmmo2],
        PlayerInfo[playerid][LastWep3], PlayerInfo[playerid][LastAmmo3],
        PlayerInfo[playerid][LastWep4], PlayerInfo[playerid][LastAmmo4],
        PlayerInfo[playerid][LastWep5], PlayerInfo[playerid][LastAmmo5],
        PlayerInfo[playerid][LastWep6], PlayerInfo[playerid][LastAmmo6],
        PlayerInfo[playerid][LastWep7], PlayerInfo[playerid][LastAmmo7],
        PlayerInfo[playerid][LastWep8], PlayerInfo[playerid][LastAmmo8],
        PlayerInfo[playerid][LastWep9], PlayerInfo[playerid][LastAmmo9],
        PlayerInfo[playerid][LastWep10], PlayerInfo[playerid][LastAmmo10],
        PlayerInfo[playerid][LastWep11], PlayerInfo[playerid][LastAmmo11],
        PlayerInfo[playerid][LastWep12], PlayerInfo[playerid][LastAmmo12],
        PlayerInfo[playerid][LastWep13], PlayerInfo[playerid][LastAmmo13],
        PlayerInfo[playerid][ID]
    );
    mysql_query(con, query);
If I remove LastWep9 through LastWep13, it compiles no problem. The problem is that I copy-pasted that line from above, the lines that actually work. They're the same, and I can't find the problem. Can you?
Reply
#2

why should so much?
try another way using the loop
Reply
#3

use strcat and try to apply it as a string to the mysql_format.

https://sampwiki.blast.hk/wiki/Strcat
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)