new query[128];
    new name[24];
    GetPlayerName(playerid, name, sizeof(name));
    new IP[16];
    GetPlayerIp(playerid, IP, 16);
    mysql_format(mysql, query, sizeof(query),"SELECT * FROM `playerdata` WHERE `user` = '%e' LIMIT 1", name);
    mysql_tquery(mysql, query, "OnAccountCheck", "i", playerid);

    new rows, fields;
    cache_get_data(rows, fields, mysql);
    if(rows)
    {
        cache_get_row(0, 2, PlayerInfo[playerid][Password], mysql, 129);
        PlayerInfo[playerid][pAccountID] = cache_get_row_int(0, 0);
        printf("%s", PlayerInfo[playerid][Password]);
        ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, "Login", "In order to play, you need to login", "Login", "Quit");
    }
    else
    {
        ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, "Register", "In order to play, you need to register.", "Register", "Quit");
    }

public OnAccountCheck(playerid)
{
    new rows, fields;
    cache_get_data(rows, fields, mysql);
    if(rows)
    {
        cache_get_row(0, 2, PlayerInfo[playerid][Password], mysql, 129);
        PlayerInfo[playerid][pAccountID] = cache_get_row_int(0, 0);
        printf("%s", PlayerInfo[playerid][Password]);
        ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, "Login", "In order to play, you need to login", "Login", "Quit");
    }
    else 
    {
        ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, "Register", "In order to play, you need to register.", "Register", "Quit");
    }
    return 1;
}

new query[1000];
    if(dialogid == DIALOG_REGISTER)
    {
        if(response)
        {
            new pname[24];
            GetPlayerName(playerid, pname, sizeof(pname));
            new IP[16];
            GetPlayerIp(playerid, IP, sizeof(IP));
            if(CheckInput(inputtext)) return SendClientMessage(playerid, 0x0000ff, "You cannot use this password.");
            if(strlen(inputtext) < 4 || strlen(inputtext) > 20) return ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, "Register", "In order to play, you need to register.\nYour password must be at least min 4 characters and max 20.", "Register", "Quit");
            WP_Hash(PlayerInfo[playerid][Password], 129, inputtext);
            mysql_format(mysql, query, sizeof(query), "INSERT INTO playerdata (user, password, Scores, Cash, Admin, Deaths, Nopm, Muted, Vip, Warn, RegisterDate, Jailed, AdminActions, Cookies, Rank, VipTime, Class, PrototypesStolen, KillAsUsaTeam, KillAsGermanyTeam, KillAsItalyTeam, KillAsJapanTeam, KillAsMercTeam, KillAsMexicoTeam, IP, DaysAlive) VALUES('%s', '%s', 0, 0, 0, 0, 0, 0, 0, 0, '%s', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '%s', '0')", pname, PlayerInfo[Password], InsertTimeStamp(), IP);
            mysql_tquery(mysql, query, "", "");
            new Bannedby[20];
            format(Bannedby, 20, "Not Banned");
            Logged[playerid] = 1;
            new stats[128];
            format(stats, sizeof(stats), "UPDATE ServerStats SET TotalAccounts = TotalAccounts + 1");
            mysql_function_query(mConnectionHandle, stats, false, "", "");
            WindowForPlayer(playerid, "You are now ~r~registered ~w~to Battlefield War Heroes! Enjoy playing!");
            WelcomeDialog(playerid);
            new echo[130];
            new kname[24];
            GetPlayerName(playerid, kname, 24);
            format(echo,sizeof(echo),"0,3** System: %s (%d) (IP: %s) has registered a new account",pname,playerid,IP);
            IRC_GroupSay(gGroupID, IRC_ACHANNEL, echo);
            new admin[128];
            format(admin,sizeof(admin),"** System: %s (%d) (%s) has registered a new account.",pname,playerid,IP);
            SendStaffMessage(LIGHTBLUE,admin);
            new txd[128];
            format(txd,sizeof(txd),"%s (%d) (IP: %s) registered a new account",pname,playerid,IP);
            TextDrawSetString(RegTxd, txd);
            new welcome[130];
            format(welcome, sizeof(welcome), "Welcome to Battlefield War Heroes, ~r~%s! Type ~r~/rules ~w~and ~r~/cmds ~w~for server info.",pname);
            GameTextForPlayer(playerid,welcome,6000,4);
        }
        if(!response)
        {
        SendClientMessage(playerid, COLOR_RED, "** To play you must be registered or logged in.");
        KickTimer[playerid] = SetTimerEx("KickPlayer",200,false,"d",playerid);
        }
    }

public OnPlayerConnect(playerid)
{
    IsPlayerBanned(playerid);
    new query[128];
    new name[24];
    GetPlayerName(playerid, name, sizeof(name));
    new IP[16];
    GetPlayerIp(playerid, IP, 16);
    mysql_format(mysql, query, sizeof(query),"SELECT * FROM `playerdata` WHERE `user` = '%e' LIMIT 1", name);
    mysql_tquery(mysql, query, "OnAccountCheck", "i", playerid);
    
    MoneyGiven[playerid] = -1;
    JustLogged[playerid] = 0;
    
    SendDeathMessage(INVALID_PLAYER_ID,playerid, 200);
    SetPVarInt(playerid, "spawned", 0);
    
    StealingA69Prot[playerid] = 0;
    CapturingABAP[playerid] = 0;
    CapturingA69[playerid] = 0;
    CapturingHQ[playerid] = 0;
    CapturingBS[playerid] = 0;
    CapturingSFB[playerid] = 0;
    SpeedWarnings[playerid] = 0;
    ArmourWarnings[playerid] = 0;
    pAlive[playerid] = 0;
    pCheck[playerid] = 0;
    IsTakingOverTurf[playerid] = 0;
    RhinoKills[playerid] = 0;
    HydraKills[playerid] = 0;
    HunterKills[playerid] = 0;
    SeaSparrowKills[playerid] = 0;
    RustlerKills[playerid] = 0;
    cowit[playerid] = 0;
    killstreak[playerid] = 0;
    
    //==============Map Icons================================
    SetPlayerMapIcon(playerid,6, 388.7785,2481.7974,16.4844, 5, 0, MAPICON_GLOBAL); //Abandoned Airport
    SetPlayerMapIcon(playerid,7, 160.7681,1903.1256,18.7615, 6, 0, MAPICON_GLOBAL); //Area69
    SetPlayerMapIcon(playerid,8, 397.7717,858.3791,20.0455, 11, 0, MAPICON_GLOBAL); //Hunter Quarry
    SetPlayerMapIcon(playerid,9, -2498.7642,2359.2964,14.1182, 18, 0, MAPICON_GLOBAL); //Bayside
    SetPlayerMapIcon(playerid,10, -1400.9016,660.2661,34.5781, 20, 0, MAPICON_GLOBAL); //Red Gant Bridge
    SetPlayerMapIcon(playerid,12, 1602.0250,1435.7529,10.8261, 21, 0, MAPICON_GLOBAL); //LV Airport
    
    GangZoneShowForPlayer(playerid, Zone[AbandonedAp], 0xC0C0C075);
    GangZoneShowForPlayer(playerid, Zone[Area69], 0xC0C0C075);
    GangZoneShowForPlayer(playerid, Zone[HunterQuarry], 0xC0C0C075);
    GangZoneShowForPlayer(playerid, Zone[Bayside], 0xC0C0C075);
    GangZoneShowForPlayer(playerid, Zone[SFBridge], 0xC0C0C075);
    GangZoneShowForPlayer(playerid, Zone[LVAirport], 0xC0C0C075);

    TextDrawSetString(Sprite0, Sprites[random(sizeof(Sprites))]);
    TextDrawShowForPlayer(playerid,Sprite0);
    
    TextDrawShowForPlayer(playerid, WebSiteTxd);
    TextDrawShowForPlayer(playerid, LogoTxd);

    new joinMsg[110], lname[24];
    GetPlayerName(playerid, lname, sizeof(lname));
    format(joinMsg, sizeof(joinMsg), "3[%d]3 +++ %s has joined the server.", playerid, lname);
    IRC_GroupSay(gGroupID, IRC_CHANNEL, joinMsg);

    new ipschan[150];
    new IPP[40];
    GetPlayerIp(playerid, IPP, sizeof(IPP));
    format(ipschan, sizeof(ipschan), "** %s (%d) IP: %s - %s", name,playerid,IPP,InsertTimeStamp());
    dini_Set("/Logs/playerips.txt",name,IPP);
    JoinsLog(ipschan);
    IRC_GroupSay(gGroupID, IRC_IPCHANNEL, ipschan);
    
    new stats[128];
    format(stats, sizeof(stats), "UPDATE ServerStats SET TotalJoins = TotalJoins + 1");
    mysql_function_query(mConnectionHandle, stats, false, "", "");

    for( new i = 0; i <= 50; i ++ ) SCM(playerid,-1, "" );
    new welcome[250];
    format(welcome,sizeof(welcome),"{53C506}** {FFFFFF}Welcome to {F70505}%s - Please read /rules and /cmds {FFFFFF}for server info.",BUILD);
    SCM(playerid, -1, welcome);
    SCM(playerid,0xFF8080FF, "** Earn Battlefield Achievements (BA) to get extra score and money! Check /acinfo for more");
    SCM(playerid,0xFF8080FF, "** NOTICE: If you see anyone hacking please report it using /report [id] [reason]");
    return 1;
}

//If you don't need number of fields, then:
new rows, fields;
cache_get_data(rows, fields, mysql);
if(rows)
//can be substitued with
if(cache_num_rows(mConnectionHandle))

mysql_format(mConnectionHandle, query, sizeof(query), "INSERT INTO playerdata (user, password, Scores, Cash, Admin, Deaths, Nopm, Muted, Vip, Warn, RegisterDate, Jailed, AdminActions, Cookies, Rank, VipTime, Class, PrototypesStolen, KillAsUsaTeam, KillAsGermanyTeam, KillAsItalyTeam, KillAsJapanTeam, KillAsMercTeam, KillAsMexicoTeam, IP, DaysAlive) VALUES('%s', '%s', 0, 0, 0, 0, 0, 0, 0, 0, '%s', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '%s', '0')", pname, PlayerInfo[Password], InsertTimeStamp(), IP);
            mysql_tquery(mConnectionHandle, query, "", "");