SQLite Errors
#2

Try this:
pawn Код:
public OnPlayerConnect(playerid)
{
    new
        Query[ 1300 ],
        Queryban[1300],
        DBResult: rBan,
        DBResult: Result,
        banname[MAX_PLAYER_NAME],
        name[ MAX_PLAYER_NAME ]
    ;
    GetPlayerName(playerid, name, sizeof(name));

    Bit1_Set(g_PlayerLogged, playerid, false);
    format(Queryban, sizeof(Queryban), "SELECT `BENNED` FROM `USERS` WHERE `BANNED` = '%d'", DB_Escape(banname));
    rBan = db_query(Database, Queryban);
   
    if(Bit1_Get(g_PlayerBanned, playerid)) return Ban(playerid);

    format(Query, sizeof(Query), "SELECT `NAME` FROM `USERS` WHERE `NAME` = '%s'", DB_Escape(name));
   
    Result = db_query(Database, Query);

    if(db_num_rows(Result))
    {

        format(Query, sizeof(Query), "{FFFFFF}Welcome %s(%d){FFFFFF} to the server, you're registered\n\nPlease log in by typing your password.", name, playerid);

        ShowPlayerDialog(playerid, 1, DIALOG_STYLE_PASSWORD, "{FFFFFF}Server", Query, "Login", "Leave");
    }
    else
    {
       
        format(Query, sizeof(Query), "{FFFFFF}Welcome %s(%d){FFFFFF} to the server, you're not{FFFFFF} registered\n\nPlease log in by typing your password.", name, playerid);
   
        ShowPlayerDialog(playerid, 0, DIALOG_STYLE_PASSWORD, "{FFFFFF}Server", Query, "Register", "Leave");
    }
    db_free_result(Result);

    return 1;
}
Reply


Messages In This Thread
SQLite Errors - by [HK]Ryder[AN] - 13.09.2012, 14:17
Re: SQLite Errors - by Roach_ - 13.09.2012, 14:20
Re: SQLite Errors - by [HK]Ryder[AN] - 13.09.2012, 14:23
Re: SQLite Errors - by Roach_ - 13.09.2012, 14:26
Re: SQLite Errors - by [HK]Ryder[AN] - 13.09.2012, 14:28
AW: SQLite Errors - by BiosMarcel - 13.09.2012, 14:30
Re: SQLite Errors - by [HK]Ryder[AN] - 13.09.2012, 14:31
Re: SQLite Errors - by Roach_ - 13.09.2012, 14:32
Re: SQLite Errors - by [HK]Ryder[AN] - 13.09.2012, 14:33
Re: SQLite Errors - by [HK]Ryder[AN] - 13.09.2012, 14:53

Forum Jump:


Users browsing this thread: 2 Guest(s)