[JaKe Elite]

pawn Код:

public OnPlayerConnect(playerid)
{
    new string[71];
    format(string, sizeof(string), "SELECT `IP` FROM `banned` WHERE `IP` = '%s'", PlayerIP(playerid));
    mysql_query(string);
    mysql_store_result();
    if(mysql_num_rows())
    {
        new BannedUsername[24], Bannedby[24], BannedReason[128];
        mysql_fetch_field("Username", BannedUsername, Connection);
        mysql_fetch_field("Banner", Bannedby, Connection);
        mysql_fetch_field("Reason", BannedReason, Connection);

        new mysqlString[412];
        format(mysqlString, sizeof(mysqlString), "\n{FFFFFF}If you think your ban is unfair, please visit {FF0000}%s {FFFFFF}and make an unban appeal \n\n\n\n{267F00}Banned name: \t{BA1400}%s \n{267F00}Banned by: \t{BA1400}%s \n{267F00}Reason: \t{BA1400}%s", SERVER_WEBSITE, BannedUsername, Bannedby, BannedReason);
        ShowPlayerDialog(playerid, 1337, DIALOG_STYLE_MSGBOX, "{FF0000}You are banned from this server!", mysqlString, "Close", "");
        TextDrawShowForPlayer(playerid, Credits);
        Kick(playerid);
    }
    else
    {
        format(string, sizeof(string), "SELECT * FROM `accounts` WHERE `Username` = '%s'", PlayerName(playerid));
        mysql_query(string);

        mysql_store_result();
        if(mysql_num_rows())
        {
            LoginDialog(playerid);
        }
        else RegisterDialog(playerid);
        TextDrawHideForPlayer(playerid, Credits);
        mysql_free_result();
    }
    mysql_free_result();
    SetPlayerMapIcon(playerid,1,-2626.1843,211.5102,4.6097,6,0);                //Ammunation
    SetPlayerMapIcon(playerid,2,-2099.6882,899.1699,76.7109,24,0);              //CaltonHeightsDH
    SetPlayerMapIcon(playerid,3,-2779.9194,0.3026,10.0625,24,0);                //OceanFlatsDH
    SetPlayerMapIcon(playerid,4,-2576.4824,818.9226,49.9844,24,0);              //ParadisoDH
    SetPlayerMapIcon(playerid,5,-2433.7866,1281.6011,23.7422,24,0);             //JuniperHollowDH
    SetPlayerMapIcon(playerid,6,-1547.4066,123.6555,3.5547,9,0);                //ShipYard
    SetPlayerMapIcon(playerid,7,-1657.7573,1210.2754,7.2500,55,0);              //Otto'sCars
    SetPlayerMapIcon(playerid,8,-1923.3926,303.6380,41.0469,8,0);               //BombShop
    SetPlayerMapIcon(playerid,9,-2331.8582,-164.2207,35.5547,10,0);             //BurgerShotGarcia
    SetPlayerMapIcon(playerid,10,-2671.5444,260.9214,4.6328,10,0);              //BurgerShotOcean
    SetPlayerMapIcon(playerid,11,370.7744,-6.5378,1001.8589,14,0);              //CluckinBellOcean
    SetPlayerMapIcon(playerid,12,-2553.8923,193.2280,6.1560,49,0);              //GayDarStation
    SetPlayerMapIcon(playerid,13,-2241.8118,131.9901,35.3203,47,0);             //Zero's
    SetPlayerMapIcon(playerid,14,-2242.2817,-85.7698,35.3203,49,0);             //Misty's
    SetPlayerMapIcon(playerid,15,-1951.9911,300.2070,35.4688,55,0);             //WangCars
    SetPlayerMapIcon(playerid,16,-2658.3201,639.5060,14.4531,22,0);             //Hospital
    SetPlayerMapIcon(playerid,17,-2568.8982,243.9241,10.2489,7,0);              //Barbers
    SetPlayerMapIcon(playerid,18,-2270.1182,-152.8132,35.3203,54,0);            //GYM
    SetPlayerMapIcon(playerid,19,-2029.2903,-102.0118,35.1641,36,0);            //DrivingSchool
    SetPlayerMapIcon(playerid,20,-1979.9883,138.0498,27.6875,42,0);             //TrainStation
    SetPlayerMapIcon(playerid,21,-1911.2001,829.2663,35.1719,10,0);             //BurgerShotDowntown
    SetPlayerMapIcon(playerid,22,-1886.2000,862.4730,35.1719,45,0);             //DowntownZip
    SetPlayerMapIcon(playerid,23,-1806.8252,947.8553,24.8906,29,0);             //FinancialPizza
    SetPlayerMapIcon(playerid,24,-1748.4784,963.3699,24.8828,30,0);             //FBI
    SetPlayerMapIcon(playerid,25,-1692.5487,949.6002,24.8906,45,0);             //DowntownVictim
    SetPlayerMapIcon(playerid,26,-1496.8027,919.8218,7.1875,52,0);              //Bank
    SetPlayerMapIcon(playerid,27,-1609.2813,712.9857,13.7334,30,0);             //SFPD
    SetPlayerMapIcon(playerid,28,-1719.8079,1356.6371,7.1875,29,0);             //EsplanadePizza
    SetPlayerMapIcon(playerid,29,-2622.5164,1412.6412,7.0938,49,0);             //Jizzy's
    SetPlayerMapIcon(playerid,30,-2356.0327,1004.7512,50.8984,10,0);            //BurgerShotJuniperHollow
    SetPlayerMapIcon(playerid,31,-2374.1877,908.1357,45.4371,45,0);             //JuniperHillBinco
    SetPlayerMapIcon(playerid,32,-2446.3350,752.2393,35.1719,62,0);             //SupaSave
    SetPlayerMapIcon(playerid,33,-1814.2487,617.8710,35.1719,14,0);             //DowntownCluckin
    return 1;
}