13.09.2012, 14:20
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;
}