02.02.2014, 20:06
This is the query that gives me error:
Getting input line too long, possibly non terminated string at the format(query.
What's wrong? Seems the query is correctly written :/
pawn Код:
format(query, sizeof(query), "UPDATE `playerdata` SET Scores='%d', Cash='%d', Admin='%d', Deaths='%d', Nopm='%d', Muted='%d', Vip='%d', Warn='%d', RegisterDate='%d', Jailed='%d', AdminActions='%d', Cookies='%d', Rank='%d', VipTime='%d', Class='%d', PrototypesStolen='%d', Exp='%d', Duty='%d', KillAsUsaTeam='%d', KillAsGermanyTeam='%d', KillAsItalyTeam='%d', KillAsJapanTeam='%d', KillAsMercTeam='%d', KillAsMexicoTeam='%d', DaysAlive='%d', Banned='%d', PlayersBanned='%d', PlayersKicked='%d' WHERE user='%s'",
score,
money,
PlayerInfo[playerid][Admin],
PlayerInfo[playerid][Deaths],
PlayerInfo[playerid][Nopm],
PlayerInfo[playerid][Muted],
PlayerInfo[playerid][Vip],
PlayerInfo[playerid][Warn],
PlayerInfo[playerid][RegisterDate],
PlayerInfo[playerid][Jailed],
PlayerInfo[playerid][AdminActions],
PlayerInfo[playerid][Cookies],
PlayerInfo[playerid][Rank],
PlayerInfo[playerid][VipTime],
PlayerInfo[playerid][Class],
PlayerInfo[playerid][PrototypesStolen],
PlayerInfo[playerid][Exp],
PlayerInfo[playerid][Duty],
PlayerInfo[playerid][KillAsUsaTeam],
PlayerInfo[playerid][KillAsGermanyTeam],
PlayerInfo[playerid][KillAsItalyTeam],
PlayerInfo[playerid][KillAsJapanTeam],
PlayerInfo[playerid][KillAsMercTeam],
PlayerInfo[playerid][KillAsMexicoTeam],
PlayerInfo[playerid][DaysAlive],
PlayerInfo[playerid][Banned],
PlayerInfo[playerid][PlayersBanned],
PlayerInfo[playerid][PlayersKicked],
pname
);
mysql_tquery(mysqlc, query, "", "");
What's wrong? Seems the query is correctly written :/