SQLite not writing to database
#5

I take that back..its still not saving, though it loads the info now.

OnPlayerDisconnect:
pawn Код:
public OnPlayerDisconnect(playerid)
    {
    new
        Query[ 200 ],
        name[ MAX_PLAYER_NAME ]
    ;
    GetPlayerName(playerid, name, sizeof(name));
    format(Query, sizeof(Query), "UPDATE `ACCOUNTS` SET LEVEL = '%d', CASH = '%d', ADMINLEVEL = '%d', HOURS = '%d', JOB = '%d', BANNED = '%d', SPAWN = '%d', BANK = '%d', FOOD = '%d', WATER = '%d', SKIN = '%d', FACTION = '%d', FACTION LEVEL = '%d' COLLATE NOCASE", PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pCash], PlayerInfo[playerid][pAdmin],
    PlayerInfo[playerid][pHours], PlayerInfo[playerid][pJob], PlayerInfo[playerid][pBanned], PlayerInfo[playerid][pSpawn], PlayerInfo[playerid][pBank], PlayerInfo[playerid][pFood], PlayerInfo[playerid][pWater], PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pFaction], PlayerInfo[playerid][pFlevel]);
    db_query(survival, Query);
    return 1;
    }
Reply


Messages In This Thread
SQLite not writing to database - by Mattakil - 29.09.2013, 21:09
Re: SQLite not writing to database - by Jefff - 29.09.2013, 21:14
Re: SQLite not writing to database - by Konstantinos - 29.09.2013, 21:16
Re: SQLite not writing to database - by Mattakil - 29.09.2013, 21:28
Re: SQLite not writing to database - by Mattakil - 29.09.2013, 21:39
Re: SQLite not writing to database - by Jefff - 29.09.2013, 22:07
Re: SQLite not writing to database - by Mattakil - 29.09.2013, 22:13

Forum Jump:


Users browsing this thread: 2 Guest(s)