SQLite Problems
#4

Yes, it does.
Код:
public OnPlayerDisconnect(playerid, reason)
{
    new
        Query[ 200 ], 
        name[ MAX_PLAYER_NAME ] 
    ;
    GetPlayerName(playerid, name, sizeof(name)); 

    if(Bit1_Get(g_PlayerLogged, playerid) == 1)
    {
        
        format(Query,sizeof(Query),"UPDATE `USERS` SET SCORE = '%d', CASH = '%d', ADMINLEVEL = '%d', KILLS = '%d', DEATHS = '%d', RESPECT = '%d', SKIN = '%d' WHERE `NAME` = '%s' COLLATE NOCASE",
                                                                                        GetPlayerScore(playerid), 
                                                                                        GetPlayerMoney(playerid), 
                                                                                        Bit16_Get(g_AdminLevel, playerid),
                                                                                        Bit16_Get(g_Kills, playerid),
                                                                                        Bit16_Get(g_Deaths, playerid),
                                                                                        Bit16_Get(g_Respect, playerid),
                                                                                        GetPlayerSkin(playerid),
                                                                                        DB_Escape(name)); 
        db_query(Database, Query);
        Bit1_Set(g_PlayerLogged, playerid, false);
    }
    return 1;
}
Reply


Messages In This Thread
SQLite Problems - by preda98 - 21.08.2012, 21:28
Re: SQLite Problems - by preda98 - 22.08.2012, 12:37
Re: SQLite Problems - by [DOG]irinel1996 - 22.08.2012, 12:45
Re: SQLite Problems - by preda98 - 22.08.2012, 12:46
Re: SQLite Problems - by Vince - 22.08.2012, 12:51
Re: SQLite Problems - by preda98 - 22.08.2012, 12:52
Re: SQLite Problems - by [DOG]irinel1996 - 22.08.2012, 12:53
Re: SQLite Problems - by preda98 - 22.08.2012, 12:54
Re: SQLite Problems - by [DOG]irinel1996 - 22.08.2012, 13:00
Re: SQLite Problems - by preda98 - 22.08.2012, 13:04

Forum Jump:


Users browsing this thread: 1 Guest(s)