[Johnson_Brooks]

pawn Код:

public OnPlayerConnect(playerid)
{
    SetPlayerMapIcon( playerid, 12, -2462.4688,132.2999,35.1719, 52, 0, MAPICON_LOCAL );
    IsAfk[playerid] = 0; // When the player joins, he is not afk , OF COURSE!
    new string[64];
    new Name[MAX_PLAYER_NAME];
    GetPlayerName(playerid,Name,MAX_PLAYER_NAME);
    format(string,sizeof string,"[{00FF00}JOIN{EEEEEE}]%s has joined the server.",Name);
    SendClientMessageToAll(COLOR_WHITE,string);
    SendDeathMessage(-1, playerid, 200);
    ResetVars(playerid);
    new Query[300], rows, fields, string1[128];
    mysql_format(dbHandle,Query, sizeof(Query), "SELECT * FROM `PlayerData` WHERE `Username` = '%e'",Name(playerid));
    mysql_query(dbHandle,Query);
    cache_get_data(rows, fields);
    if(rows)
    {
        format(string1,sizeof(string1),"{EEEEEE}Welcome back %s\n{EEEEEE}Please login to continue playing",Name(playerid));
        ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD,"Login",string1,"Login","Quit");
    }
    else if(!rows)
    {
        format(string1,sizeof(string1),"{EEEEEE}Welcome %s\n{EEEEEE}Please enter a password to register your account",Name(playerid));
        ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD,"Register",string1,"Register","Quit");
    }
    return 1;
}

Here's the full onplayerconnect