MySQL error
#6

Aha, okay, it worked but can you help me on the saving/disconnecting part?:

(6452) : error 075: input line too long (after substitutions)
(6453) : error 037: invalid string (possibly non-terminated string)
(6453) : error 017: undefined symbol "UPDATE"
(6453) : error 017: undefined symbol "cash"
(6453) : fatal error 107: too many error messages on one line

pawn Код:
public OnPlayerDisconnect(playerid, reason)
{
    if(Logged[playerid] == 1)
    {
        GetPlayerPos(playerid, PlayerInfo[playerid][pPos_x], PlayerInfo[playerid][pPos_y], PlayerInfo[playerid][pPos_z]);
        GetPlayerFacingAngle(playerid, PlayerInfo[playerid][pPos_a]);
        new score = GetPlayerScore(playerid);
        new money = GetPlayerMoney(playerid);
        new query[814], pname[24];
        GetPlayerName(playerid, pname, 24);
        format(query, sizeof(query), "UPDATE cash=%d, deposit=%d, payday=%d, paycheck=%d, connecttime=%d, age=%d, sex=%d, level=%d, number=%d, phonebook=%d, job=%d, skin=%d, team=%d, accent=%d, admin=%d, spectate=%d, banned=%d, muted=%d, reportmuted=%d, \
        experiance=%d, vip=%d, vipmuted=%d, jailed=%d, jailtime=%d, toggedvipchat=%d, housekey=%d, warns=%d, posx=%f, posy=%f, posz=%f, posa=%f, health=%f, armor=%f, materials=%d, cocaine=%d, packages=%d, interior=%d, virtualworld=%d, dice=%d, \ // (6452) : error 075: input line too long (after substitutions)
        weapon1=%d, weapon1a=%d, weapon2=%d, weapon2a=%d, weapon3=%d, weapon3a=%d, weapon4=%d, weapon4a=%d,"
); //(6453) : error 037: invalid string (possibly non-terminated string)
        format(query, sizeof(query), "%s weapon5=%d, weapon5a=%d, weapon6=%d, weapon6a=%d, weapon7=%d, weapon7a=%d, weapon8=%d, weapon8a=%d, weapon9=%d, weapon9a=%d, weapon10=%d, \
        weapon10a=%d, weapon11=%d, weapon11a=%d, weapon12=%d, weapon12a=%d, killlog0=%d, killlog1=%d, killlog2=%d, killlog3=%d, killlog4=%d, killlog5=%d, killlog6=%d, killlog7=%d, killlog8=%d, killlog9=%d, deaths=%d, faction=%d, rank=%d, leader=%d, \
        duty=%d, crimes=%d, wantedlevel=%d, radio=%d, radiofreq=%d, spam=%d, dashboard=%d WHERE user = '%s'"
,
        PlayerInfo[playerid][pCash],
        PlayerInfo[playerid][pDeposit],...
Reply


Messages In This Thread
MySQL error - by ryansheilds - 02.03.2012, 22:21
Re: MySQL error - by Pooh7 - 02.03.2012, 22:30
Re: MySQL error - by yvoms - 02.03.2012, 22:36
Re: MySQL error - by iTorran - 02.03.2012, 22:42
Re: MySQL error - by Pooh7 - 02.03.2012, 22:43
Re: MySQL error - by ryansheilds - 02.03.2012, 22:50
Re: MySQL error - by Pooh7 - 02.03.2012, 22:53
Re: MySQL error - by ryansheilds - 02.03.2012, 23:12
Re: MySQL error - by Ricop522 - 03.03.2012, 00:32

Forum Jump:


Users browsing this thread: 1 Guest(s)