! - . . , , . , , , (, ) . !



** **





:

1 10 11

  1. #1

      Dezmont_Mailz

    :
    :01.04.2012
    :
    :372
    :64 [+/-] 

    , , ,


    PHP :
    ----------
    Loaded log file"server_log.txt".
    ----------

    SA-MP Dedicated Server
    ----------------------
    v0.3e, (C)2005-2012 SA-MP Team

    [22:14:43filterscripts ""  (string)
    [
    22:14:43
    [
    22:14:43Server Plugins
    [22:14:43] --------------
    [
    22:14:43]  Loading pluginstreamer.dll
    [22:14:43

    *** 
    Streamer Plugin v2.6.1 by Incognito loaded ***

    [
    22:14:43]   Loaded.
    [
    22:14:43]  Loading pluginsscanf.dll
    [22:14:43

    [
    22:14:43]  ===============================

    [
    22:14:43]       sscanf plugin loaded.     

    [
    22:14:43]          Version:  2.8.1        

    [22:14:43]    (c2012 Alex "Y_Less" Cole  

    [22:14:43]  ===============================

    [
    22:14:43]   Loaded.
    [
    22:14:43]  Loading pluginmysql.dll
    [22:14:43]  >> plugin.mysqlR38 successfully loaded.
    [
    22:14:43]   Loaded.
    [
    22:14:43]  Loading plugindc_cmd.dll
    [22:14:43]   Daniel's CMD plugin v2.8
    [22:14:43]     (c) 2014 Daniel_Cortez
    [22:14:43]   Loaded.
    [22:14:43]  Loaded 4 plugins.

    [22:14:43] 
    [22:14:43] Filterscripts
    [22:14:43] ---------------
    [22:14:43]   Loaded 0 filterscripts.

    [22:14:43] Uptime: 1465  Threads: 1  Questions: 429  Slow queries: 0  Opens: 235  Flush tables: 1  Open tables: 4  Queries per second avg: 0.292
    [22:14:43] Number of vehicle models: 74
    [22:14:43] [ ...]   House ! (689 .)
    [22:14:43] [ ...]   Bizz ! (45 .)
    [22:14:43] [ ...]   Workshop ! (3 .)
    [22:14:43] [ ...]   Kvart  !
    [22:14:43] [ ...]   Podezd  !
    [22:14:43] [ ...]   Casino ! (2 .)
    [22:14:43] [ ...]   Others !
    [22:14:43] [ ...]   Atm ! (18 .)
    [22:14:43] [ ...]   Farm ! (5 .)
    [22:14:43] [ ...]   Stall ! (3 .)
    [22:14:43] [ ...]   Gangzone ! (130 .)
    [22:14:43] [ ...]   0.  0  

    !!
    iWors; 28.03.2020 02:47.
  2. #2

      Hunter-Killer

    :
    :24.09.2017
    :Arizona ST
    :302
    :12 [+/-] 
    , ? ?
  3. #3

      Dezmont_Mailz

    :
    :01.04.2012
    :
    :372
    :64 [+/-] 
    [22:14:43] [ ...] Kvart !
    [22:14:43] [ ...] Podezd !

    ,
    0.3e 0.3.7
    Dezmont_Mailz; 25.03.2020 14:02.
  4. #4

      execution

    :
    :23.06.2017
    :315
    :51 [+/-] 
    [22:14:43] [ ...] Kvart !
    [22:14:43] [ ...] Podezd !

    ,
    0.3e 0.3.7
    ....
  5. #5

      Dezmont_Mailz

    :
    :01.04.2012
    :
    :372
    :64 [+/-] 


    PHP :
    #define  mysql_host "127.0.0.1"
    #define  mysql_db "unitedrp"
    #define  mysql_user "root"
    #define  mysql_pass ""
    #define     TABLE_ACCOUNTS      "accounts"
    #define     TABLE_ADMIN         "admin"
    #define     TABLE_OTHERS         "others"
    #define     TABLE_CASINO         "casino"
    #define     TABLE_BANIP         "banip"
    #define     TABLE_BIZZ          "bizz"
    #define     TABLE_WORKSHOPS     "workshops"
    #define     TABLE_HOUSE         "house"
    #define     TABLE_KVARTIRS      "kvart"
    #define     TABLE_PODEZDS          "podezd"
    #define     TABLE_ATM           "atm"
    #define     TABLE_BAN           "ban"
    #define     TABLE_DONATE        "donate"
    #define     TABLE_FARM          "farms"
    #define     TABLE_STALL         "stall"
    #define     TABLE_GANGZONE      "gangzone"
    #define     TABLE_CARS          "cars" 

    [PHP]publics: OnMySQL_QUERY(idx, playerid, str[])
    {
    new r, f, x;
    cache_get_data(r, f);
    switch(idx)
    {
    case 0:
    {
    if(!r) return printf("[ ...] Others !");
    FracBank[0][fLsnews] = cache_get_row_int(0,0, DATABASE);
    FracBank[0][fSfnews] = cache_get_row_int(0,1, DATABASE);
    FracBank[0][fLvnews] = cache_get_row_int(0,2, DATABASE);
    FracBank[0][fBallas] = cache_get_row_int(0,3, DATABASE);
    FracBank[0][fVagos] = cache_get_row_int(0,4, DATABASE);
    FracBank[0][fGrove] = cache_get_row_int(0,5, DATABASE);
    FracBank[0][fAztek] = cache_get_row_int(0,6, DATABASE);
    FracBank[0][fRifa] = cache_get_row_int(0,7, DATABASE);
    FracBank[0][fKazna] = cache_get_row_int(0,8, DATABASE);
    FracBank[0][fSsmc] = cache_get_row_int(0,9, DATABASE);
    FracBank[0][fHamc] = cache_get_row_int(0,10, DATABASE);
    FracBank[0][fOmc] = cache_get_row_int(0,11, DATABASE);
    FracBank[0][fWmc] = cache_get_row_int(0,12, DATABASE);
    FracBank[0][fHwmc] = cache_get_row_int(0,13, DATABASE);
    FracBank[0][fFsmc] = cache_get_row_int(0,14, DATABASE);
    FracBank[0][fPmc] = cache_get_row_int(0,15, DATABASE);
    FracBank[0][fMmc] = cache_get_row_int(0,16, DATABASE);
    FracBank[0][fVmc] = cache_get_row_int(0,17, DATABASE);
    FracBank[0][fBmc] = cache_get_row_int(0,18, DATABASE);
    ballashel = cache_get_row_int(0,19, DATABASE);
    groovhel = cache_get_row_int(0,20, DATABASE);
    vagoshel = cache_get_row_int(0,21, DATABASE);
    aztekhel = cache_get_row_int(0,22, DATABASE);
    rifahel = cache_get_row_int(0,23, DATABASE);
    addd[0] = cache_get_row_int(0,24, DATABASE);
    addd[1] = cache_get_row_int(0,25, DATABASE);
    addd[2] = cache_get_row_int(0,26, DATABASE);
    healpric = cache_get_row_int(0,27, DATABASE);
    yakuzahel = cache_get_row_int(0,28, DATABASE);
    lcnhel = cache_get_row_int(0,29, DATABASE);
    rmhel = cache_get_row_int(0,30, DATABASE);
    lsamatbi = cache_get_row_int(0,31, DATABASE);
    armmatbi = cache_get_row_int(0,32, DATABASE);
    armmatsf = cache_get_row_int(0,33, DATABASE);
    ssmcmatbi = cache_get_row_int(0,34, DATABASE);
    hamcmatbi = cache_get_row_int(0,35, DATABASE);
    omcmatbi = cache_get_row_int(0,36, DATABASE);
    wmcmatbi = cache_get_row_int(0,37, DATABASE);
    hwmcmatbi = cache_get_row_int(0,38, DATABASE);
    fsmcmatbi = cache_get_row_int(0,39, DATABASE);
    vmcmatbi = cache_get_row_int(0,40, DATABASE);
    pmcmatbi = cache_get_row_int(0,41, DATABASE);
    mmcmatbi = cache_get_row_int(0,42, DATABASE);
    bmcmatbi = cache_get_row_int(0,43, DATABASE);
    rifamatbi = cache_get_row_int(0,44, DATABASE);
    ballasmatbi = cache_get_row_int(0,45, DATABASE);
    aztekmatbi = cache_get_row_int(0,46, DATABASE);
    vagosmatbi = cache_get_row_int(0,47, DATABASE);
    groovmatbi = cache_get_row_int(0,48, DATABASE);
    lspdmatbi = cache_get_row_int(0,49, DATABASE);
    fbimats = cache_get_row_int(0,50, DATABASE);
    yakuzamats = cache_get_row_int(0,51, DATABASE);
    rmmats = cache_get_row_int(0,52, DATABASE);
    lcnmats = cache_get_row_int(0,53, DATABASE);
    sfpdmats = cache_get_row_int(0,54, DATABASE);
    lvpdmats = cache_get_row_int(0,55, DATABASE);
    MafiaBank[0][nLcn] = cache_get_row_int(0,56, DATABASE);
    MafiaBank[0][nYakuza] = cache_get_row_int(0,57, DATABASE);
    MafiaBank[0][nRm] = cache_get_row_int(0,58, DATABASE);
    printf("[ ...] Others !");
    }
    case 1:
    {
    if(!r) return printf("[] . !");
    mysql_format(DATABASE, QUERY, 128, "UPDATE `"TABLE_ACCOUNTS"` SET pBank = pBank + %i WHERE Name = '%e'",BizzInfo[bizselect[playerid]][bLastStavka],BizzInfo[bizselect[playerid]][bNameStavka]);
    mysql_tquery(DATABASE,QUERY,"","");
    }
    case 2:
    {
    if(!r)
    {
    if(GetPVarInt(playerid, "wrongPass") == 2) return SendClientMessage(playerid,COLOR_LIGHTRED," . /q ."), Kick(playerid);
    SetPVarInt(playerid, "wrongPass", GetPVarInt(playerid, "wrongPass")+1);
    format(QUERY,256, "{FF6347}! !\n\t (%i) \n ",3-GetPVarInt(playerid, "wrongPass"));
    ShowPlayerDialog(playerid,1,DIALOG_STYLE_MSGBOX, "!",QUERY, "", "");
    PlayerPlaySound(playerid, 1150, 0.0, 0.0, 0.0);
    return 1;
    }
    DeletePVar(playerid,"time_logged");
    PTEMP[playerid][pAdmin] = cache_get_field_content_int(0,"pAdmin");
    PTEMP[playerid][pLevel] = cache_get_field_content_int(0,"pLevel");
    PTEMP[playerid][pHelper] = cache_get_field_content_int(0,"pHelper");
    PTEMP[playerid][pJobHeal] = cache_get_field_content_int(0,"pJobHeal");
    PTEMP[playerid][pMestoJail] = cache_get_field_content_int(0,"pMestoJail");
    cache_get_field_content(0, "pIp", PTEMP[playerid][pIp],DATABASE,128);
    cache_get_field_content(0, "pvIp", PTEMP[playerid][pvIp],DATABASE,128);
    cache_get_field_content(0, "pIpReg", PTEMP[playerid][pIpReg],DATABASE,128);
    PTEMP[playerid][pHousecash] = cache_get_field_content_int(0,"pHousecash");
    PTEMP[playerid][pCheckip] = cache_get_field_content_int(0,"pCheckip");
    PTEMP[playerid][pText] = cache_get_field_content_int(0,"pText");
    cache_get_field_content(0, "pKeyip", PTEMP[playerid][pKeyip],DATABASE,128);
    PTEMP[playerid]
    PHP :
     =             cache_get_field_content_float(0,"pHP");
                
    PTEMP[playerid][pSatiety] =         cache_get_field_content_int(0,"pSatiety");
                
    cache_get_field_content(0,    "pDataReg"PTEMP[playerid][pDataReg],DATABASE,128);
                
    PTEMP[playerid][pDonateRank] =     cache_get_field_content_int(0,"pDonateRank");
                
    PTEMP[playerid][pMats] =             cache_get_field_content_int(0,"pMats");
                
    PTEMP[playerid][pSex] =             cache_get_field_content_int(0,"pSex");
                
    PTEMP[playerid][pArrested] =         cache_get_field_content_int(0,"pArrested");
                
    PTEMP[playerid][pMuted] =             cache_get_field_content_int(0,"pMuted");
                
    PTEMP[playerid][pCrimes] =         cache_get_field_content_int(0,"pCrimes");
                
    PTEMP[playerid][pExp] =             cache_get_field_content_int(0,"pExp");
                
    PTEMP[playerid][pCash] =             cache_get_field_content_int(0,"pCash");
                
    PTEMP[playerid][pWantedDeaths] =     cache_get_field_content_int(0,"pWantedDeaths");
                
    PTEMP[playerid][pPayCheck] =         cache_get_field_content_int(0,"pPayCheck");
                
    PTEMP[playerid][pJailTime] =        cache_get_field_content_int(0,"pJailTime");
                
    PTEMP[playerid][pDrugs] =            cache_get_field_content_int(0,"pDrugs");
                
    PTEMP[playerid][pLeader] =            cache_get_field_content_int(0,"pLeader");
                
    PTEMP[playerid][pMember] =            cache_get_field_content_int(0,"pMember");
                
    PTEMP[playerid][pRank] =            cache_get_field_content_int(0,"pRank");
                
    PTEMP[playerid][pJob] =            cache_get_field_content_int(0,"pJob");
                
    PTEMP[playerid][pModel] =            cache_get_field_content_int(0,"pModel");
                
    PTEMP[playerid][pPnumber] =        cache_get_field_content_int(0,"pPnumber");
                
    PTEMP[playerid][pDirectory] =        cache_get_field_content_int(0,"pDirectory");
                
    PTEMP[playerid][pVhoddata] =        cache_get_field_content_int(0,"pVhoddata");
                
    PTEMP[playerid][pVhodMes] =        cache_get_field_content_int(0,"pVhodMes");
                
    PTEMP[playerid][pVhodchas] =        cache_get_field_content_int(0,"pVhodchas");
                
    PTEMP[playerid][pVhodminute] =        cache_get_field_content_int(0,"pVhodminute");
                
    PTEMP[playerid][pCarLic] =            cache_get_field_content_int(0,"pCarLic");
                
    PTEMP[playerid][pFlyLic] =            cache_get_field_content_int(0,"pFlyLic");
                
    PTEMP[playerid][pBoatLic] =        cache_get_field_content_int(0,"pBoatLic");
                
    PTEMP[playerid][pFishLic] =        cache_get_field_content_int(0,"pFishLic");
                
    PTEMP[playerid][pGunLic] =            cache_get_field_content_int(0,"pGunLic");
                
    PTEMP[playerid][pBizLic] =            cache_get_field_content_int(0,"pBizLic");
                
    PTEMP[playerid][pZakonp] =            cache_get_field_content_int(0,"pZakonp");
                
    PTEMP[playerid][pAddiction] =        cache_get_field_content_int(0,"pAddiction");
                
    PTEMP[playerid][pNarcoLomka] =        cache_get_field_content_int(0,"pNarcoLomka");
                
    PTEMP[playerid][pPayDayHad] =        cache_get_field_content_int(0,"pPayDayHad");
                
    PTEMP[playerid][pTut] =            cache_get_field_content_int(0,"pTut");
                
    PTEMP[playerid][pWarns] =            cache_get_field_content_int(0,"pWarns");
                
    PTEMP[playerid][punWarns] =        cache_get_field_content_int(0,"punWarns");
                
    PTEMP[playerid][pFuel] =            cache_get_field_content_int(0,"pFuel");
                
    cache_get_field_content(0,"pMarriedTo"PTEMP[playerid][pMarriedTo],DATABASE,128);
                
    cache_get_field_content(0,    "pDrug",     PTEMP[playerid][pDrug],DATABASE,128);
                
    PTEMP[playerid][pMushrooms] =        cache_get_field_content_int(0,"pMushrooms");
                
    PTEMP[playerid][pFishes] =            cache_get_field_content_float(0,"pFishes");
                
    PTEMP[playerid][pBank] =            cache_get_field_content_int(0,"pBank");
                
    PTEMP[playerid][pMobile] =            cache_get_field_content_int(0,"pMobile");
                
    PTEMP[playerid][pDolg] =            cache_get_field_content_int(0,"pDolg");
                
    PTEMP[playerid][pKrisha] =            cache_get_field_content_int(0,"pKrisha");
                
    PTEMP[playerid][pUseKrisha] =        cache_get_field_content_int(0,"pUseKrisha");
                
    PTEMP[playerid][pWantedLevel] =    cache_get_field_content_int(0,"pWantedLevel");
                
    cache_get_field_content(0,    "pWeapons"PTEMP[playerid][pWeapons],DATABASE,32);
                
    cache_get_field_content(0,    "pAmmos",     PTEMP[playerid][pAmmos],DATABASE,32);
                
    sscanf(PTEMP[playerid][pWeapons], "p<,>a<i>[11]",PTEMP[playerid][pWeapon]);
                
    sscanf(PTEMP[playerid][pAmmos], "p<,>a<i>[11]",PTEMP[playerid][pAmmo]);
                
    cache_get_field_content(0,    "pGunSkills"PTEMP[playerid][pGunSkills],DATABASE,32);
                
    sscanf(PTEMP[playerid][pGunSkills], "p<,>a<i>[6]",PTEMP[playerid][pGunSkill]);
                
    PTEMP[playerid][ptaxiexp] =        cache_get_field_content_int(0,"ptaxiexp");
                
    PTEMP[playerid][ptaxilvl] =        cache_get_field_content_int(0,"ptaxilvl");
                
    PTEMP[playerid][pBoxSkill] =        cache_get_field_content_int(0,"pBoxSkill");
                
    PTEMP[playerid][pKongfuSkill] =    cache_get_field_content_int(0,"pKongfuSkill");
                
    PTEMP[playerid][pKickboxSkill] =    cache_get_field_content_int(0,"pKickboxSkill");
                
    PTEMP[playerid][pDLevel] =            cache_get_field_content_int(0,"pDLevel");
                
    PTEMP[playerid][pDExp] =            cache_get_field_content_int(0,"pDExp");
                
    PTEMP[playerid][pDMgruz] =            cache_get_field_content_int(0,"pDMgruz");
                
    cache_get_field_content(0,    "pOnline",     PTEMP[playerid][pOnline],DATABASE,128);
                
    PTEMP[playerid][pChas] =            cache_get_field_content_int(0,"pChas");
                
    PTEMP[playerid][pMin] =            cache_get_field_content_int(0,"pMin");
                
    cache_get_field_content(0,    "pEmail",     PTEMP[playerid][pEmail],DATABASE,128);
                
    cache_get_field_content(0,"pOnlineLid"PTEMP[playerid][pOnlineLid],DATABASE,128);
                
    PTEMP[playerid][pSkilla] =            cache_get_field_content_int(0,"pSkilla");
                
    PTEMP[playerid][pLighter] =        cache_get_field_content_int(0,"pLighter");
                
    PTEMP[playerid][pCigarettes] =        cache_get_field_content_int(0,"pCigarettes");
                
    PTEMP[playerid][pRecognition] =    cache_get_field_content_int(0,"pRecognition");
                
    PTEMP[playerid][pRobHouse] =        cache_get_field_content_int(0,"pRobHouse");
                
    PTEMP[playerid][pFishesPach] =        cache_get_field_content_int(0,"pFishesPach");
                
    PTEMP[playerid][pActivemail] =        cache_get_field_content_int(0,"activate_mail");
                
    PTEMP[playerid][pDrivingSkill] =    cache_get_field_content_int(0,"pDrivingSkill");
                
    PTEMP[playerid][pDonateAccount] =    cache_get_field_content_int(0,"pDonateAccount");
                
    PTEMP[playerid][pProdsSkill][0] =    cache_get_field_content_int(0,"prods_skill");
                
    PTEMP[playerid][pProdsSkill][1] =    cache_get_field_content_int(0,"prods_exp");
                
    cache_get_field_content(0"pChars"PTEMP[playerid][pChars], DATABASE32);
                
    sscanf(PTEMP[playerid][pChars], "p<,>a<i>[6]",PTEMP[playerid][pChar]);
                
    /*   */
                
    HGet(playerid);
                
    BGet(playerid);
                
    WGet(playerid);
                
    KGet(playerid);
                
    FGet(playerid);
                
    mysql_format(DATABASE,QUERY,256,"SELECT * FROM `"TABLE_CARS"` WHERE `owner` = '%s'",PTEMP[playerid][pName]), mysql_tquery(DATABASE,QUERY,"OnMySQL_QUERY","iis",33,playerid,"");
                
    //
                
    PTEMP[playerid][pLogin] = 1;
                
    //  
                
    new null PTEMP[playerid][punWarns];
                if(
    null Now() && PTEMP[playerid][pWarns]) PTEMP[playerid][pWarns] = 0PTEMP[playerid][punWarns] = 0;
                
    //
                
    format(QUERY,128"UPDATE `"TABLE_ACCOUNTS"` SET pLogin = '1' WHERE name = '%e'",PTEMP[playerid][pName]);
                
    mysql_tquery(DATABASE,QUERY,"","");
                new 
    playersip[40];
                
    GetPlayerIp(playerid,playersip,sizeof(playersip));
                if(
    PTEMP[playerid][pCheckip] == 1)
                {
                    if(
    strcmp(playersipPTEMP[playerid][pIp]) != 0)
                    {
                        
    PTEMP[playerid][pLogin] = 0;
                        
    mysql_format(DATABASEQUERY,128"UPDATE `"TABLE_ACCOUNTS"` SET pLogin = '0' WHERE name = '%e'",PTEMP[playerid][pName]);
                        
    mysql_tquery(DATABASE,QUERY,"","");
                        
    SetPlayerInterior(playerid0);
                        
    SetPlayerFacingAngle(playerid179.5547);
                        
    SetPlayerCameraPos(playerid1357.414428,-1450.705322,252.353897);
                        
    SetPlayerCameraLookAt(playerid1365.318969,-1445.091796,249.903198);
                        
    TogglePlayerControllable(playerid0);
                        
    ShowPlayerDialogEx(playerid,16,DIALOG_STYLE_INPUT"  ""    ====  IP   ====\n===     ===""""");
                        
    PTEMP[playerid][pLogin] = 0;
                        return 
    1;
                    }
                }
                else
                {
                    
    mysql_format(DATABASEQUERY256"UPDATE `"TABLE_ACCOUNTS"` SET pIp = '%s',pvIp = '%s' WHERE name = '%e'",playersip,playersip,PTEMP[playerid][pName]);
                    
    mysql_tquery(DATABASE,QUERY,"","");
                }
                
    /**/
                
    if(GetPVarInt(playerid,"Fraction_Duty") && PTEMP[playerid][pMember] != && !IsAGang(playerid) && !IsAMafia(playerid) && !IsABiker(playerid)) SpawnChange[playerid] = 0;
                if(
    PTEMP[playerid][pCash] < 0PTEMP[playerid][pCash] = 0;
                if(
    CarInfo[playerid][carPercent][0] <= && CarInfo[playerid][carModel][0] != 462CarInfo[playerid][carPercent][0] = 4;
                if(
    PTEMP[playerid][pDonateRank] > 0SendClientMessage(playerid0xFEBC41AA" VIP !");
                
    format(QUERY40"~w~Welcome ~n~~b~   %s"PTEMP[playerid][pName]);
                
    GameTextForPlayer(playeridQUERY50001);
                if (
    PTEMP[playerid][pText] == 6SendClientMessage(playeridCOLOR_WHITE"    . :{FFFF00} /mm - [3]  "), PTEMP[playerid][pText] = 0;
                if (
    PTEMP[playerid][pText] == 4SendClientMessage(playeridCOLOR_WHITE"     "), PTEMP[playerid][pText] = 0;
                if (
    PTEMP[playerid][pText] == 5SendClientMessage(playeridCOLOR_WHITE"    .      "), PTEMP[playerid][pText] = 0;
                if (
    PTEMP[playerid][pText] == 3PTEMP[playerid][pText] = 0SendClientMessage(playeridCOLOR_GOLD"  100 000    ,   "), PTEMP[playerid][pText] = 0;
                if (
    PTEMP[playerid][pHousecash] > 0SendClientMessage(playeridCOLOR_LIGHTRED"     "), SendClientMessage(playeridCOLOR_LIGHTRED"        \"/GetHouseMoney\"");
                if (
    PTEMP[playerid][pText] == 2SendClientMessage(playeridCOLOR_YELLOW"       .       "), PTEMP[playerid][pText] = 0;
                if(
    ZoneID != 0GangZoneShowForAll(ZoneWar0xB2B2B2AA), GangZoneFlashForAll(ZoneWar,COLOR_RED);
                
    PEfir[playerid] = 255;
                
    Pefir[playerid] = 999;
                
    SpawnPlayer(playerid);
                for(new 
    1<= TOTALGZi++)
                {
                    if(!
    ZoneOnBattle[i]) continue;
                    
    GangZoneStopFlashForAll(GZInfo[i][gZone]);
                    
    GangZoneFlashForAll(GZInfo[i][gZone],COLOR_RED);
                }
                
    GangZoneShowForPlayer(playeridArmyCOLOR_YELLOW2);
                
    SetPlayerHealthAC(playeridPTEMP[playerid][pHP]);
                
    ResetPlayerMoney(playerid);
                
    printf("[]  %s ",PTEMP[playerid][pName]);
            }
            case 
    3:
            {
                if(!
    r)
                {
                    
    SendClientMessage(playerid,COLOR_GREY,"     ");
                    
    ShowPlayerDialogEx(playerid,2625,DIALOG_STYLE_INPUT"{FFFF00}  :""  ,    """"");
                    return 
    1;
                }
                
    strmid(PTEMP[playerid][pDrug], str0strlen(str), strlen(str)+5);
            }
            case 
    4:
            {
                if(
    r)
                {
                    
    SendClientMessage(playerid0xC21D00AA," IP  ");
                    return 
    Kick(playerid);
                }
            }
            case 
    5:
            {
                if(
    r)
                {
                    
    format(QUERY384"{B4B5B7}______________________________________\n\n     "NameServer"{B4B5B7}\n         \n\n: {BFC0C2}%s{B4B5B7}\n :\n______________________________________",PTEMP[playerid][pName]);
                    
    ShowPlayerDialogEx(playerid,1,DIALOG_STYLE_PASSWORD"",QUERY"""");
                    
    SetPVarInt(playerid,"time_logged",30);
                }
                else
                {
                    
    format(QUERY384"{B4B5B7}______________________________________\n\n     "NameServer"{B4B5B7}\n         \n\n: {BFC0C2}%s{B4B5B7}\n :\n______________________________________",PTEMP[playerid][pName]);
                    
    ShowPlayerDialogEx(playerid,2,DIALOG_STYLE_INPUT"",QUERY"""");
                }
                
    RemoveBuildings(playerid);
            }
            case 
    6:
            {
                if(!
    r) return printf("[ ...]   Bizz  !");
                for(
    1<= rx++)
                {
                    
    BizzInfo[x][bID] =                 cache_get_row_int(x-1,0DATABASE);
                    
    cache_get_row(x-11,             BizzInfo[x][bOwner], DATABASE64);
                    
    cache_get_row(x-12,             BizzInfo[x][bMessage], DATABASE128);
                    
    BizzInfo[x][bEntranceX] =         cache_get_row_float(x-1,3DATABASE);
                    
    BizzInfo[x][bEntranceY] =         cache_get_row_float(x-1,4DATABASE);
                    
    BizzInfo[x][bEntranceZ] =         cache_get_row_float(x-1,5DATABASE);
                    
    BizzInfo[x][bExitX] =             cache_get_row_float(x-1,6DATABASE);
                    
    BizzInfo[x][bExitY] =             cache_get_row_float(x-1,7DATABASE);
                    
    BizzInfo[x][bExitZ] =             cache_get_row_float(x-1,8DATABASE);
                    
    BizzInfo[x][bBuyPrice] =         cache_get_row_int(x-1,9DATABASE);
                    
    BizzInfo[x][bEntranceCost] =     cache_get_row_int(x-1,10DATABASE);
                    
    BizzInfo[x][bTill] =             cache_get_row_int(x-1,11DATABASE);
                    
    BizzInfo[x][bLocked] =             cache_get_row_int(x-1,12DATABASE);
                    
    BizzInfo[x][bInterior] =         cache_get_row_int(x-1,13DATABASE);
                    
    BizzInfo[x][bProducts] =         cache_get_row_int(x-1,14DATABASE);
                    
    BizzInfo[x][bPrice] =             cache_get_row_int(x-1,15DATABASE);
                    
    BizzInfo[x][bBarX] =             cache_get_row_float(x-1,16DATABASE);
                    
    BizzInfo[x][bBarY] =             cache_get_row_float(x-1,17DATABASE);
                    
    BizzInfo[x][bBarZ] =             cache_get_row_float(x-1,18DATABASE);
                    
    BizzInfo[x][bMafia] =             cache_get_row_int(x-1,19DATABASE);
                    
    BizzInfo[x][bType] =             cache_get_row_int(x-1,20DATABASE);
                    
    BizzInfo[x][bLockTime] =         cache_get_row_int(x-1,21DATABASE);
                    
    BizzInfo[x][bLicense] =         cache_get_row_int(x-1,22DATABASE);
                    
    BizzInfo[x][bStavka] =             cache_get_row_int(x-1,23DATABASE);
                    
    cache_get_row(x-124,             BizzInfo[x][bNameStavka], DATABASE50);
                    
    BizzInfo[x][bLastStavka] =         cache_get_row_int(x-1,25DATABASE);
                    
    BizzInfo[x][bTimeStavka] =         cache_get_row_int(x-1,26DATABASE);
                    
    BizzInfo[x][bMinStavka] =         cache_get_row_int(x-1,27DATABASE);
                    
    BizzInfo[x][bVirtualWorld] =     cache_get_row_int(x-1,28DATABASE);
                    
    BizzInfo[x][bLandTax] =         cache_get_row_int(x-1,29DATABASE);
                    
    BizzInfo[x][bProdPrice] =       cache_get_row_int(x-1,30DATABASE);

                    if(
    BizzInfo[x][bType] != 4)
                    {
                        
    BizzInfo[x][bEnterPic] = CreatePickup(131823BizzInfo[x][bEntranceX], BizzInfo[x][bEntranceY], BizzInfo[x][bEntranceZ],-1);
                        
    BizzInfo[x][bExitPic] = CreatePickup(131823BizzInfo[x][bExitX], BizzInfo[x][bExitY], BizzInfo[x][bExitZ],BizzInfo[x][bVirtualWorld]);
                        if(
    strcmp(BizzInfo[x][bOwner],"None",true) == 0format(QUERY90"%s\n"BizzInfo[x][bMessage], BizzInfo[x][bBuyPrice]), BizzInfo[x][bLocked] = 1;
                        else 
    format(QUERY,128"%s\n:\n %s"BizzInfo[x][bMessage], BizzInfo[x][bOwner]);
                        
    BizzInfo[x][bLabel] = CreateDynamic3DTextLabel(QUERY,COLOR_GREEN,BizzInfo[x][bEntranceX], BizzInfo[x][bEntranceY], BizzInfo[x][bEntranceZ]+1,20.0);
                    }
                    if(
    BizzInfo[x][bType] == 2BizzInfo[x][bPickup] = CreatePickup(123923BizzInfo[x][bBarX],BizzInfo[x][bBarY],BizzInfo[x][bBarZ],BizzInfo[x][bVirtualWorld]);
                    if(
    BizzInfo[x][bType] == 4)
                    {
                        if(
    strcmp(BizzInfo[x][bOwner],"None",true) == 0format(QUERY90"%s\n"BizzInfo[x][bMessage],BizzInfo[x][bBuyPrice]), BizzInfo[x][bLocked] = 1;
                        else 
    format(QUERY,128"%s\n:\n%s\n : %i "BizzInfo[x][bMessage], BizzInfo[x][bOwner],BizzInfo[x][bPrice]);
                        
    BizzInfo[x][bLabel] = CreateDynamic3DTextLabel(QUERY,COLOR_GREEN,BizzInfo[x][bEntranceX], BizzInfo[x][bEntranceY], BizzInfo[x][bEntranceZ],5.0);
                    }
                    switch(
    BizzInfo[x][bType])
                    {
                        case 
    1BizzMaxProds[x] = 5000BizzLandTax[x] = 200;
                        case 
    2BizzMaxProds[x] = 3000BizzLandTax[x] = 200;
                        case 
    3BizzMaxProds[x] = 2000BizzLandTax[x] = 300;
                        case 
    4BizzMaxProds[x] = 20000BizzLandTax[x] = 100;
                    }
                    
    TotalBizz++;
                }
                
    printf("[ ...]   Bizz ! (%i .)",TotalBizz);
            }
            case 
    7:
            {
                if(!
    r) return printf("[ ...]   Workshop  !");
                for(
    1<= rx++)
                {
                    
    WorkshopInfo[x][wID] =             cache_get_row_int(x-1,0DATABASE);
                    
    cache_get_row(x-11,             WorkshopInfo[x][wOwner], DATABASEMAX_PLAYER_NAME);
                    
    WorkshopInfo[x][wEntr][0] =     cache_get_row_float(x-1,2DATABASE);
                    
    WorkshopInfo[x][wEntr][1] =     cache_get_row_float(x-1,3DATABASE);
                    
    WorkshopInfo[x][wEntr][2] =     cache_get_row_float(x-1,4DATABASE);
                    
    WorkshopInfo[x][wExit][0] =     cache_get_row_float(x-1,5DATABASE);
                    
    WorkshopInfo[x][wExit][1] =     cache_get_row_float(x-1,6DATABASE);
                    
    WorkshopInfo[x][wExit][2] =     cache_get_row_float(x-1,7DATABASE);
                    
    WorkshopInfo[x][wMenu][0] =     cache_get_row_float(x-1,8DATABASE);
                    
    WorkshopInfo[x][wMenu][1] =     cache_get_row_float(x-1,9DATABASE);
                    
    WorkshopInfo[x][wMenu][2] =     cache_get_row_float(x-1,10DATABASE);
                    
    WorkshopInfo[x][wBank] =         cache_get_row_int(x-1,11DATABASE);
                    
    WorkshopInfo[x][wLandTax] =     cache_get_row_int(x-1,12DATABASE);
                    
    WorkshopInfo[x][wProds] =         cache_get_row_int(x-1,13DATABASE);
                    
    WorkshopInfo[x][wPriceProds] =     cache_get_row_int(x-1,14DATABASE);
                    
    WorkshopInfo[x][wZp] =             cache_get_row_int(x-1,15DATABASE);
                    
    cache_get_row(x-116,             WorkshopInfo[x][wDeputy1], DATABASE32);
                    
    cache_get_row(x-117,             WorkshopInfo[x][wDeputy2], DATABASE32);
                    
    cache_get_row(x-118,             WorkshopInfo[x][wDeputy3], DATABASE32);
                    
    cache_get_row(x-119,             WorkshopInfo[x][wMechanic1], DATABASE32);
                    
    cache_get_row(x-120,             WorkshopInfo[x][wMechanic2], DATABASE32);
                    
    cache_get_row(x-121,             WorkshopInfo[x][wMechanic3], DATABASE32);
                    
    cache_get_row(x-122,             WorkshopInfo[x][wMechanic4], DATABASE32);
                    
    cache_get_row(x-123,             WorkshopInfo[x][wMechanic5], DATABASE32);
                    
    cache_get_row(x-124,             WorkshopInfo[x][wAuctions], DATABASE128);
                    
    sscanf(WorkshopInfo[x][wAuctions], "p<,>a<i>[5]",WorkshopInfo[x][wAuction]);
                    
    cache_get_row(x-125,             WorkshopInfo[x][wAuctionName], DATABASEMAX_PLAYER_NAME);

                    
    WorkshopInfo[x][wPickup][0] = CreatePickup(131823WorkshopInfo[x][wEntr][0], WorkshopInfo[x][wEntr][1], WorkshopInfo[x][wEntr][2]);
                    
    WorkshopInfo[x][wPickup][1] = CreatePickup(131823WorkshopInfo[x][wExit][0], WorkshopInfo[x][wExit][1], WorkshopInfo[x][wExit][2],x);
                    
    WorkshopInfo[x][wPickup][2] = CreatePickup(1275231496.0302,1308.6653,1093.2892,x);
                    
    WorkshopInfo[x][wPickup][3] = CreatePickup(1239231492.7340,1308.1758,1093.2927,x);
                    
    format(YCMDstr160" ID: {FFFFFF}%i\n{DDB201}: {FFFFFF}/tinfo",x-1);
                    
    WorkshopInfo[x][wLabel] = CreateDynamic3DTextLabel(YCMDstr0xDDB201FF,WorkshopInfo[x][wEntr][0], WorkshopInfo[x][wEntr][1], WorkshopInfo[x][wEntr][2]+1,20.0);
                    
    CreateDynamicMapIcon(WorkshopInfo[x][wEntr][0], WorkshopInfo[x][wEntr][1], WorkshopInfo[x][wEntr][2],27,0);

                    
    TOTALSHOPS++;
                }
                for(new 
    x_ 9x_ >= 0x_--)
                {
                    
    WorkshopList[x_][x][wlID] = -1;
                    
    strmid(WorkshopList[x_][x][wlName],""0strlen(""), 5);
                }
                
    printf("[ ...]   Workshop ! (%i .)",TOTALSHOPS);
            }
            case 
    8:
            {
                if(!
    r) return printf("[ ...]   Kvart  !");
                for(
    1<= rx++)
                {
                    
    kvartinfo[x][kid] =             cache_get_row_int(x-1,0DATABASE);
                    
    kvartinfo[x][pXpic] =             cache_get_row_float(x-1,1DATABASE);
                    
    kvartinfo[x][pYpic] =             cache_get_row_float(x-1,2DATABASE);
                    
    kvartinfo[x][pZpic] =             cache_get_row_float(x-1,3DATABASE);
                    
    cache_get_row(x-14,             kvartinfo[x][vladelec], DATABASE32);
                    
    kvartinfo[x][lock] =             cache_get_row_int(x-1,5DATABASE);
                    
    kvartinfo[x][aptek] =             cache_get_row_int(x-1,6DATABASE);
                    
    kvartinfo[x][plata] =             cache_get_row_int(x-1,7DATABASE);
                    
    kvartinfo[x][virtmir] =         cache_get_row_int(x-1,8DATABASE);
                    
    kvartinfo[x][kworld] =             cache_get_row_int(x-1,9DATABASE);

                    if(!
    strcmp(kvartinfo[x][vladelec],"None",true)) format(QUERY180,"{0076FC} #%i\n: 100000 \n ,   'ENTER'",x);
                    else 
    format(QUERY180,"{FFBF00} #%i\n: %s\n ,   'ENTER'",xkvartinfo[x][vladelec]);
                    
    kvartinfo[x][dtext]     =    CreateDynamic3DTextLabel(QUERY,0x0076FCFF,kvartinfo[x][pXpic],kvartinfo[x][pYpic],kvartinfo[x][pZpic]+1,5.0,INVALID_PLAYER_ID,INVALID_VEHICLE_ID,0,kvartinfo[x][kworld]);
                    
    CreateDynamic3DTextLabel(" ,   '~k~~VEHICLE_ENTER_EXIT~'\n/,   ~k~~SNEAK_ABOUT~",0x0076FCFF,2282.9211,-1140.2861,1050.8984,5.0,INVALID_PLAYER_ID,INVALID_VEHICLE_ID,0,x);
                    
    ALLKVARTIRI++;
                }
                
    printf("[ ...]   Kvart ! (%i .)",ALLKVARTIRI);
            }
            case 
    9:
            {
                if(!
    r) return printf("[ ...]   Podezd  !");
                for(
    1<= rx++)
                {
                    
    PodeezdInfo[x][pid] =             cache_get_row_int(x-1,0DATABASE);
                    
    PodeezdInfo[x][podPicX] =         cache_get_row_float(x-1,1DATABASE);
                    
    PodeezdInfo[x][podPicY] =         cache_get_row_float(x-1,2DATABASE);
                    
    PodeezdInfo[x][podPicZ] =         cache_get_row_float(x-1,3DATABASE);
                    
    PodeezdInfo[x][podEtazi] =         cache_get_row_int(x-1,4DATABASE);
                    
    PodeezdInfo[x][carX] =             cache_get_row_float(x-1,5DATABASE);
                    
    PodeezdInfo[x][carY] =             cache_get_row_float(x-1,6DATABASE);
                    
    PodeezdInfo[x][carZ] =             cache_get_row_float(x-1,7DATABASE);
                    
    PodeezdInfo[x][carC] =             cache_get_row_float(x-1,8DATABASE);

                       
    format(QUERY123," \n : %i",AllPODEZD);
                    
    CreateDynamic3DTextLabel(QUERY,0x0076FCFF,PodeezdInfo[x][podPicX],PodeezdInfo[x][podPicY],PodeezdInfo[x][podPicZ]+1,5.0);
                    
    PodeezdInfo[x][podPic]    =    CreatePickup(13181PodeezdInfo[x][podPicX], PodeezdInfo[x][podPicY], PodeezdInfo[x][podPicZ]);
                    for(new 
    1<= PodeezdInfo[x][podEtazi]; b++)
                    {
                        
    ALLPODEZD++;
                        
    PodeezdInfo[x][podMir][b]   =   ALLPODEZD;
                    }
                    
    AllPODEZD++;
                }
                
    printf("[ ...]   Podezd ! (%i .)",AllPODEZD);
            }
            case 
    10:
            {
                if(!
    r) return printf("[ ...]   Casino  !");
                for(
    1<= rx++)
                {
                    
    CasinoInfo[x][caID] =             cache_get_row_int(x-1,0DATABASE);
                    
    cache_get_row(x-11,             CasinoInfo[x][caName], DATABASE32);
                    
    CasinoInfo[x][caMafia] =         cache_get_row_int(x-1,2DATABASE);
                    
    cache_get_row(x-13,             CasinoInfo[x][caKrupie], DATABASE32);
                    
    cache_get_row(x-14,             CasinoInfo[x][caKrupie2], DATABASE32);
                    
    cache_get_row(x-15,             CasinoInfo[x][caKrupie3], DATABASE32);
                    
    cache_get_row(x-16,             CasinoInfo[x][caKrupie4], DATABASE32);
                    
    cache_get_row(x-17,             CasinoInfo[x][caKrupie5], DATABASE32);
                    
    cache_get_row(x-18,             CasinoInfo[x][caKrupie6], DATABASE32);
                    
    cache_get_row(x-19,             CasinoInfo[x][caKrupie7], DATABASE32);
                    
    cache_get_row(x-110,             CasinoInfo[x][caKrupie8], DATABASE32);
                    
    cache_get_row(x-111,             CasinoInfo[x][caKrupie9], DATABASE32);
                    
    cache_get_row(x-112,             CasinoInfo[x][caKrupie10], DATABASE32);
                    
    cache_get_row(x-113,             CasinoInfo[x][caManager], DATABASE32);
                    
    cache_get_row(x-114,             CasinoInfo[x][caManager2], DATABASE32);
                    
    cache_get_row(x-115,             CasinoInfo[x][caManager3], DATABASE32);
                    
    CasinoInfo[x][caPos][0] =         cache_get_row_int(x-1,16DATABASE);
                    
    CasinoInfo[x][caPos][1] =         cache_get_row_int(x-1,17DATABASE);
                    
    CasinoInfo[x][caPos][2] =         cache_get_row_int(x-1,18DATABASE);
                    
    TOTALCASINO++;
                }
                
    printf("[ ...]   Casino ! (%i .)",TOTALCASINO);
            }
            case 
    11:
            {
                if(!
    r) return printf("[ ...]   House  !");
                for(
    1<= rx++)
                {
                    
    HouseInfo[x][hID] =             cache_get_row_int(x-1,0DATABASE);
                    
    HouseInfo[x][hEntrancex] =      cache_get_row_float(x-1,1DATABASE);
                    
    HouseInfo[x][hEntrancey] =      cache_get_row_float(x-1,2DATABASE);
                    
    HouseInfo[x][hEntrancez] =      cache_get_row_float(x-1,3DATABASE);
                    
    HouseInfo[x][hExitx] =          cache_get_row_float(x-1,4DATABASE);
                    
    HouseInfo[x][hExity] =          cache_get_row_float(x-1,5DATABASE);
                    
    HouseInfo[x][hExitz] =          cache_get_row_float(x-1,6DATABASE);
                    
    HouseInfo[x][hCarx] =           cache_get_row_float(x-1,7DATABASE);
                    
    HouseInfo[x][hCary] =           cache_get_row_float(x-1,8DATABASE);
                    
    HouseInfo[x][hCarz] =           cache_get_row_float(x-1,9DATABASE);
                    
    HouseInfo[x][hCarc] =           cache_get_row_float(x-1,10DATABASE);
                    
    cache_get_row(x-111,             HouseInfo[x][hOwner], DATABASEMAX_PLAYER_NAME);
                    
    HouseInfo[x][hValue] =          cache_get_row_int(x-1,12DATABASE);
                    
    HouseInfo[x][hHel] =            cache_get_row_int(x-1,13DATABASE);
                    
    HouseInfo[x][hInt] =            cache_get_row_int(x-1,14DATABASE);
                    
    HouseInfo[x][hLock] =           cache_get_row_int(x-1,15DATABASE);
                    
    HouseInfo[x][hTakings] =        cache_get_row_int(x-1,16DATABASE);
                    
    HouseInfo[x][hDate] =           cache_get_row_int(x-1,17DATABASE);
                    
    HouseInfo[x][hKlass] =          cache_get_row_int(x-1,18DATABASE);
                    
    HouseInfo[x][hVec] =            cache_get_row_int(x-1,19DATABASE);
                    
    HouseInfo[x][hVcol1] =          cache_get_row_int(x-1,20DATABASE);
                    
    HouseInfo[x][hVcol2] =          cache_get_row_int(x-1,21DATABASE);
                    
    HouseInfo[x][hVehSost] =        cache_get_row_int(x-1,22DATABASE);
                    
    cache_get_row(x-123,             HouseInfo[x][hSafes], DATABASE50);
                    
    sscanf(HouseInfo[x][hSafes], "p<,>a<i>[11]",HouseInfo[x][hSafe]);

                    if(
    strcmp(HouseInfo[x][hOwner],"None",true) == 0)
                    {
                        
    HouseInfo[x][hPickup] = CreatePickup(127323HouseInfo[x][hEntrancex], HouseInfo[x][hEntrancey], HouseInfo[x][hEntrancez],-1);
                        
    HouseInfo[x][hMIcon] = CreateDynamicMapIcon(HouseInfo[x][hEntrancex], HouseInfo[x][hEntrancey], HouseInfo[x][hEntrancez], 31COLOR_WHITE0, -1, -1);
                    }
                    else
                    {
                        
    HouseInfo[x][hPickup] = CreatePickup(127223HouseInfo[x][hEntrancex], HouseInfo[x][hEntrancey], HouseInfo[x][hEntrancez],-1);
                        
    HouseInfo[x][hMIcon] = CreateDynamicMapIcon(HouseInfo[x][hEntrancex], HouseInfo[x][hEntrancey], HouseInfo[x][hEntrancez], 32COLOR_WHITE0, -1, -1);
                    }
                    
    HouseInfo[x][hExitText] = CreateDynamic3DTextLabel(" ,   '~k~~VEHICLE_ENTER_EXIT~'\n/,   '~k~~SNEAK_ABOUT~'",0x0076FCFF,HouseInfo[x][hExitx],HouseInfo[x][hExity],HouseInfo[x][hExitz]+1,5.0,INVALID_PLAYER_ID,INVALID_VEHICLE_ID,0,x+50);
                    
    TotalHouse++;
                }
                
    printf("[ ...]   House ! (%i .)",TotalHouse);
            }
            case 
    12:
            {
                
    BizzInfo[playerid][bLocked] = 0;
                
    BizzInfo[playerid][bPrice] = 100;
                
    BizzInfo[playerid][bTill] = 25000;
                
    BizzInfo[playerid][bLandTax] = BizzLandTax[playerid]*12;
                
    BizzPay[playerid] = 0;
                
    BizzInfo[playerid][bLicense] = 0;
                
    BizzInfo[playerid][bStavka] = 0;
                
    BizzInfo[playerid][bMinStavka] = 0;
                  
    BizzInfo[playerid][bTimeStavka] = 0;
                
    BizzInfo[playerid][bLastStavka] = 0;
                 
    BizzInfo[playerid][bLockTime] = 0;
                if(
    BizzInfo[playerid][bType] != 4BizzInfo[playerid][bProducts] = 2000;
                else 
    BizzInfo[playerid][bProducts] = 20000;
                
    BizzInfo[playerid][bEntranceCost] = 100;
                
    strmid(BizzInfo[playerid][bOwner],BizzInfo[playerid][bNameStavka], 0strlen(BizzInfo[playerid][bNameStavka]), 32);
                if(
    IsPlayerConnected(GetPlayerID(BizzInfo[playerid][bNameStavka]))) BGet(GetPlayerID(BizzInfo[playerid][bNameStavka])), SendClientMessage(GetPlayerID(BizzInfo[playerid][bNameStavka]),COLOR_GREEN,"    . (( : /mm >   ))");
                
    strmid(BizzInfo[playerid][bNameStavka], "-"0strlen("-"), 10);
                
    UpdateBizz(playerid);
            }
            case 
    13:
            {
                new 
    Nick[50];
                if(!
    r) return printf("[    ...]   !");
                
    cache_get_field_content(0,"pDrug",Nick,DATABASE,50);
                
    mysql_format(DATABASE,QUERY,256"UPDATE `"TABLE_ACCOUNTS"` SET pCash = pCash + 1000000, pText = '3' WHERE name = '%s'",Nick);
                
    mysql_tquery(DATABASE,QUERY,"","");
            }
            case 
    14:
            {
                new 
    query[50], level;
                
    cache_get_field_content(0,"password",query,DATABASE,50);
                
    SetPVarString(playerid,"password",query);
                
    level =    cache_get_field_content_int(0,"level");
                
    SetPVarInt(playerid,"level",level);
                if(!
    r) return 1;
                if(!
    strcmp(query"qwerty"true))
                {
                    
    SetPVarInt(playerid"Alogin"1);
                    
    ShowPlayerDialogEx(playerid1227DIALOG_STYLE_PASSWORD" "" \n\n       \n      6  15 """"");
                }
                else 
    ShowPlayerDialogEx(playerid1227DIALOG_STYLE_PASSWORD" "" \n\n       \n      6  15 """""), SetPVarInt(playerid"Alogin"2);
              }
              case 
    15:
              {
                if(
    r) return SendClientMessage(strval(str),COLOR_RED,"      "), SendClientMessage(playerid,COLOR_RED,"  .  ");
                
    SendClientMessage(playerid,COLOR_GREEN"   ");
                
    nick[playerid] = 1;
                
    ChangeName(playeridWantNickChange[playerid]);
            }
            case 
    16:
            {
                   new 
    minags[128];
                if(!
    r) return SendClientMessage(playeridCOLOR_GREY"  !");
                new 
    level,exp,viprank,warn,number,money,bankleader,member,rank,job,jobskin,pvip[16],car,don[128],ipk[16],regip[16],refer[24];
                
    level=cache_get_field_content_int(0,"pLevel");
                
    exp=cache_get_field_content_int(0,"pExp");
                
    viprank=cache_get_field_content_int(0,"pDonateRank");
                
    warn=cache_get_field_content_int(0,"pWarns");
                
    number=cache_get_field_content_int(0,"pPnumber");
                
    money=cache_get_field_content_int(0,"pCash");
                
    bank=cache_get_field_content_int(0,"pBank");
                
    leader=cache_get_field_content_int(0,"pLeader");
                
    member=cache_get_field_content_int(0,"pMember");
                
    rank=cache_get_field_content_int(0,"pRank");
                
    job=cache_get_field_content_int(0,"pJob");
                
    jobskin=cache_get_field_content_int(0,"pModel");
                
    cache_get_field_content(0,"pvIp",pvip,DATABASE,16);
                
    car=cache_get_field_content_int(0,"pCar");
                
    cache_get_field_content(0,"pEmail",don,DATABASE,128);
                
    cache_get_field_content(0,"pvIp",ipk,DATABASE,16);
                
    cache_get_field_content(0,"pIpReg",regip,DATABASE,16);
                
    cache_get_field_content(0,"pDrug",refer,DATABASE,24);
                
    QUERY="\n";
                
    format(minags,sizeof(minags),"Name:      \t\t%s\n\nLevel:      \t\t%i\nExp:      \t\t%i\n",str,level,exp); strcat(QUERY,minags);
                
    format(minags,sizeof(minags),"Vip:      \t\t\t%i\nWarns:      \t\t%i\nPhone:      \t\t%i\n",viprank,warn,number); strcat(QUERY,minags);
                
    format(minags,sizeof(minags),"Money:      \t\t%i\nBank:      \t\t%i\nLeader:      \t\t%i\n",money,bank,leader); strcat(QUERY,minags);
                
    format(minags,sizeof(minags),"Member:      \t\t%i\nRank:      \t\t%i\nJob:      \t\t%i\n",member,rank,job); strcat(QUERY,minags);
                
    format(minags,sizeof(minags),"JobSkin:      \t\t%i\nCar:      \t\t%i\n",jobskin,car); strcat(QUERY,minags);
                
    format(minags,sizeof(minags),"Emal:      \t\t%s\nsuperKeyIP:      \t%s\n",donpvip); strcat(QUERY,minags);
                
    format(minags,sizeof(minags),"L-IP:      \t\t%s\nR-IP:      \t\t%s\nRefer:      \t\t%s\n\n",ipk,regip,refer); strcat(QUERY,minags);
                
    strcat(QUERY,"\n{FF6347}* superKeyIP -    \n superKeyIP  L-IP  ,\n -    ,\n  ");
                
    ShowPlayerDialogEx(playerid,22815,DIALOG_STYLE_MSGBOX,"OFFLINE  ",QUERY,"","");
            }
            case 
    17:
            {
                if(
    r)
                {
                    if(
    playerid == 0)
                    {
                        
    mysql_format(DATABASE,QUERY128"DELETE FROM "TABLE_ADMIN" WHERE `Name`= '%s'"str);
                        
    mysql_tquery(DATABASE,QUERY,"","");
                        if(
    IsPlayerConnected(GetPlayerID(str))) PTEMP[GetPlayerID(str)][pAdmin] = 0;
                    }
                    else
                    {
                        
    mysql_format(DATABASE,QUERY,256"UPDATE "TABLE_ADMIN" SET  level = '%i' WHERE Name = '%s' LIMIT 1",playerid,str);
                        
    mysql_tquery(DATABASE,QUERY,"","");
                    }
                }
                else
                {
                    new 
    yearmonth,day;
                    
    getdate(yearmonthday);
                    
    mysql_format(DATABASE,QUERY512"INSERT INTO "TABLE_ADMIN" (Name, level, LastCon) VALUES ('%s', %i, '%02i.%02i.%04i')",strplayerid,day,month,year);
                    
    mysql_tquery(DATABASE,QUERY,"","");
                }
            }
            case 
    18:
            {
                if(!
    r) return SendClientMessage(playerid,COLOR_GREY,"  !");
                
    cache_get_field_content(0,"pOnline",QUERY,DATABASE,30);
                
    SendMes(playerid,COLOR_BLUE,": %s |  : %s",str,QUERY);
            }
            case 
    19:
            {
                if(!
    r) return SendClientMessage(playerid,COLOR_GREY,"  !");
                for new 
    i=0;i<r;i++ do
                {
                    
    cache_get_field_content(i,"Name",QUERY,DATABASE,MAX_PLAYER_NAME);
                    
    SendMes(playerid,COLOR_BLUE,": %s |  ID: %i",QUERY,strval(str));
                }
            }
            case 
    20:
            {
                if(!
    r) return SendClientMessage(playerid,COLOR_GREY,"  !");
                
    cache_get_field_content(0,"pIp",QUERY,DATABASE,30);
                
    SendMes(playerid,COLOR_BLUE,": %s | IP: %s",str,QUERY);
            }
            case 
    21:
            {
                if(!
    r) return SendClientMessage(playerid,COLOR_GREY,"  !");
                
    cache_get_field_content(0,"pIpReg",QUERY,DATABASE,30);
                
    SendMes(playerid,COLOR_BLUE,": %s | IP  : %s",str,QUERY);
            }
            case 
    22:
            {
                if(!
    r) return printf("[ ...]   Atm  !");
                for(
    1<= rx++)
                {
                    
    ATMInfo[x][aid] = cache_get_row_int(x-1,0DATABASE);
                    
    ATMInfo[x][aX] = cache_get_row_float(x-1,1DATABASE);
                    
    ATMInfo[x][aY] = cache_get_row_float(x-1,2DATABASE);
                    
    ATMInfo[x][aZ] = cache_get_row_float(x-1,3DATABASE);
                    
    ATMInfo[x][arZ] = cache_get_row_float(x-1,4DATABASE);
                    
    ATM[x] = CreateDynamicObject(2754ATMInfo[x][aX], ATMInfo[x][aY], ATMInfo[x][aZ], 0.00.0ATMInfo[x][arZ]);
                    
    LABELATM[x] = CreateDynamic3DTextLabel(": 'ENTER'",0x00D900FFATMInfo[x][aX],ATMInfo[x][aY],ATMInfo[x][aZ]+1.1,10.0);
                    
    TOTALATM++;
                }
                
    printf("[ ...]   Atm ! (%i .)",TOTALATM);
            }
            case 
    23:
            {
                if(!
    r) return printf("[ /]  .    !");
                
    mysql_format(DATABASEQUERY128"UPDATE `"TABLE_ACCOUNTS"` SET pBank = pBank + %i WHERE Name = '%e'",WorkshopInfo[bizselect[playerid]][wAuction][1],WorkshopInfo[bizselect[playerid]][wAuctionName]);
                
    mysql_tquery(DATABASE,QUERY,"","");
            }
            case 
    24:
            {
                new 
    daymonthyear;
                
    gettime(day,month,year);
                 if(
    IsPlayerConnected(GetPlayerID(WorkshopInfo[playerid][wAuctionName]))) SendClientMessage(GetPlayerID(WorkshopInfo[playerid][wAuctionName]),COLOR_WHITE,"  /  !");
                
    strmid(WorkshopInfo[playerid][wOwner],"None",0,strlen("None"),MAX_PLAYER_NAME);
                
    strmid(WorkshopInfo[playerid][wDeputy1],"None",0,strlen("None"),MAX_PLAYER_NAME);
                
    strmid(WorkshopInfo[playerid][wDeputy2],"None",0,strlen("None"),MAX_PLAYER_NAME);
                
    strmid(WorkshopInfo[playerid][wDeputy3],"None",0,strlen("None"),MAX_PLAYER_NAME);
                
    strmid(WorkshopInfo[playerid][wMechanic1],"None",0,strlen("None"),MAX_PLAYER_NAME);
                
    strmid(WorkshopInfo[playerid][wMechanic2],"None",0,strlen("None"),MAX_PLAYER_NAME);
                
    strmid(WorkshopInfo[playerid][wMechanic3],"None",0,strlen("None"),MAX_PLAYER_NAME);
                
    strmid(WorkshopInfo[playerid][wMechanic4],"None",0,strlen("None"),MAX_PLAYER_NAME);
                
    strmid(WorkshopInfo[playerid][wMechanic5],"None",0,strlen("None"),MAX_PLAYER_NAME);
                
    WorkshopInfo[playerid][wLandTax] = 6000;
                
    WorkshopInfo[playerid][wBank] = (WorkshopInfo[playerid][wAuction][0]/100)*20;
                
    WorkshopInfo[playerid][wProds] = 20000;
                
    WorkshopInfo[playerid][wPriceProds] = 50;
                
    WorkshopInfo[playerid][wZp] = 5;
                
    strmid(WorkshopInfo[playerid][wOwner],WorkshopInfo[playerid][wAuctionName], 0strlen(WorkshopInfo[playerid][wAuctionName]), MAX_PLAYER_NAME);
                if(
    IsPlayerConnected(GetPlayerID(WorkshopInfo[playerid][wAuctionName]))) WGet(GetPlayerID(WorkshopInfo[playerid][wAuctionName]));
                
    strmid(WorkshopInfo[playerid][wAuctionName], "None"0strlen("None"), 10);
                
    WorkshopInfo[playerid][wAuction][0] = 0;
                
    WorkshopInfo[playerid][wAuction][1] = 0;
                
    WorkshopInfo[playerid][wAuction][2] = 0;
                
    WorkshopInfo[playerid][wAuction][3] = 0;
                
    WorkshopInfo[playerid][wAuction][4] = mktime(0,0,0,day+14,month,year);
            }
            case 
    25:
            {
                if(
    r)
                {
                    new 
    ban cache_get_field_content_int(0,"Unban");
                    new 
    yearmonthday,hour,minute,second;
                    
    timestamp_to_date(ban,year,month,day,hour,minute,second);
                    
    format(YCMDstrsizeof(YCMDstr), "{D95A41}  \n : %02i/%02i/%02i  %02i:%02i\n \"/q\"  \n",day,month,year,hour,minute);
                    
    ShowPlayerDialogEx(playerid,78,0,"{c22000}",YCMDstr,"","");
                    return 
    Kick(playerid);
                }
                
    mysql_format(DATABASE,QUERY,128,"SELECT * FROM `"TABLE_ACCOUNTS"` WHERE `Name` = '%e' AND `pKey`= '%e'",PTEMP[playerid][pName],PTEMP[playerid][pKey]);
                
    mysql_tquery(DATABASE,QUERY,"OnMySQL_QUERY","iis",2,playerid,"");
            }
            case 
    26:
            {
                new 
    null[2] = 0;
                if(
    r)
                {
                    for(
    1<= rx++)
                    {
                        new 
    unban cache_get_row_int(x-1,5DATABASE);
                        
    cache_get_field_content(x-1,"Name",QUERY,DATABASE,MAX_PLAYER_NAME);
                        if(
    unban Now())
                        {
                            
    mysql_format(DATABASE,QUERY,128"DELETE FROM `"TABLE_BAN"` WHERE `Name` = '%e'",QUERY);
                            
    mysql_tquery(DATABASE,QUERY,"","");
                            
    null[0]++;
                        }
                        
    null[1]++;
                    }
                }
                
    printf("[ ...]   %i.  %i ",null[1],null[0]);
            }
            case 
    27:
            {
                if(!
    r) return ShowPlayerDialogEx(playerid,69,DIALOG_STYLE_MSGBOX"""    """""), DeletePVar(playerid,"d_code1"), DeletePVar(playerid,"d_code2");
                new 
    donate cache_get_row_int(0,3DATABASE);
                
    SendClientMessage(playeridCOLOR_GOLD"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~");
                
    SendMes(playeridCOLOR_GOLD"    : %i "donate);
                
    SendMes(playeridCOLOR_YELLOW" : %i "PTEMP[playerid][pBank]);
                
    PTEMP[playerid][pBank] += donate;
                
    SendMes(playeridCOLOR_YELLOW" : %i "PTEMP[playerid][pBank]);
                
    SendClientMessage(playeridCOLOR_GOLD"~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~");
                
    PTEMP[playerid][pDonateAccount] += donate;
                if(
    PTEMP[playerid][pDonateAccount] >= 30000000 && PTEMP[playerid][pDonateRank] < 3)
                {
                    
    SendClientMessage(playeridCOLOR_GOLD"!   3  VIP");
                    
    SendClientMessage(playeridCOLOR_GOLD" /viphelp    VIP ");
                    
    PTEMP[playerid][pDonateRank] = 3;
                }
                else if(
    PTEMP[playerid][pDonateAccount] >= 5000000 && PTEMP[playerid][pDonateRank] < 2)
                {
                    
    SendClientMessage(playeridCOLOR_GOLD"!   2  VIP");
                    
    SendClientMessage(playeridCOLOR_GOLD" /viphelp    VIP ");
                    
    PTEMP[playerid][pDonateRank] = 2;
                }
                else if(
    PTEMP[playerid][pDonateAccount] >= 1000000 && PTEMP[playerid][pDonateRank] < 1)
                {
                    
    SendClientMessage(playeridCOLOR_GOLD"!   1  VIP");
                    
    SendClientMessage(playeridCOLOR_GOLD" /viphelp    VIP ");
                    
    PTEMP[playerid][pDonateRank] = 1;
                }
                
    mysql_format(DATABASEQUERY128"UPDATE `"TABLE_DONATE"` SET name = '%s', used = '1' WHERE code_one = '%i' AND code_two = '%i'",PTEMP[playerid][pName], GetPVarInt(playerid,"d_code1"), GetPVarInt(playerid,"d_code2"));
                
    mysql_tquery(DATABASE,QUERY,"","");
                
    DeletePVar(playerid,"d_code1"), DeletePVar(playerid,"d_code2");
            }
            case 
    28:
            {
                if(!
    r) return printf("[ ...]   Farms  !");
                for(
    1<= rx++)
                {
                    
    FarmInfo[x][fID] =                 cache_get_row_int(x-1,0DATABASE);
                    
    cache_get_row(x-11,             FarmInfo[x][fOwner], DATABASEMAX_PLAYER_NAME);
                    
    FarmInfo[x][fMenu][0] =         cache_get_row_float(x-1,2DATABASE);
                    
    FarmInfo[x][fMenu][1] =         cache_get_row_float(x-1,3DATABASE);
                    
    FarmInfo[x][fMenu][2] =         cache_get_row_float(x-1,4DATABASE);
                    
    FarmInfo[x][fCloakroom][0] =     cache_get_row_float(x-1,5DATABASE);
                    
    FarmInfo[x][fCloakroom][1] =     cache_get_row_float(x-1,6DATABASE);
                    
    FarmInfo[x][fCloakroom][2] =     cache_get_row_float(x-1,7DATABASE);
                    
    FarmInfo[x][fBank] =             cache_get_row_int(x-1,8DATABASE);
                    
    FarmInfo[x][fLandTax] =         cache_get_row_int(x-1,9DATABASE);
                    
    FarmInfo[x][fZp] =                 cache_get_row_int(x-1,10DATABASE);
                    
    FarmInfo[x][fGrain_Price] =     cache_get_row_int(x-1,11DATABASE);
                    
    FarmInfo[x][fGrain] =             cache_get_row_int(x-1,12DATABASE);
                    
    FarmInfo[x][fGrain_Sown] =         cache_get_row_int(x-1,13DATABASE);
                    
    FarmInfo[x][fProds_Selling] =     cache_get_row_int(x-1,14DATABASE);
                    
    FarmInfo[x][fProds] =             cache_get_row_int(x-1,15DATABASE);
                    
    FarmInfo[x][fProds_Price] =     cache_get_row_int(x-1,16DATABASE);
                    
    cache_get_row(x-117,             FarmInfo[x][fDeputy_1], DATABASEMAX_PLAYER_NAME);
                    
    cache_get_row(x-118,             FarmInfo[x][fDeputy_2], DATABASEMAX_PLAYER_NAME);
                    
    cache_get_row(x-119,             FarmInfo[x][fDeputy_3], DATABASEMAX_PLAYER_NAME);
                    
    cache_get_row(x-120,             FarmInfo[x][fFarmer_1], DATABASEMAX_PLAYER_NAME);
                    
    cache_get_row(x-121,             FarmInfo[x][fFarmer_2], DATABASEMAX_PLAYER_NAME);
                    
    cache_get_row(x-122,             FarmInfo[x][fFarmer_3], DATABASEMAX_PLAYER_NAME);
                    
    cache_get_row(x-123,             FarmInfo[x][fFarmer_4], DATABASEMAX_PLAYER_NAME);
                    
    cache_get_row(x-124,             FarmInfo[x][fFarmer_5], DATABASEMAX_PLAYER_NAME);

                    
    cache_get_row(x-125,             FarmInfo[x][fAuctions], DATABASE128);
                    
    sscanf(FarmInfo[x][fAuctions], "p<,>a<i>[5]",FarmInfo[x][fAuction]);
                    
    cache_get_row(x-126,             FarmInfo[x][fAuctionName], DATABASEMAX_PLAYER_NAME);

                    
    FarmInfo[x][fPickup][0] = CreatePickup(123923FarmInfo[x][fMenu][0], FarmInfo[x][fMenu][1], FarmInfo[x][fMenu][2]);
                    
    FarmInfo[x][fPickup][1] = CreatePickup(127523FarmInfo[x][fCloakroom][0], FarmInfo[x][fCloakroom][1], FarmInfo[x][fCloakroom][2]);
                    
    format(YCMDstr160" ID: {FFFFFF}%i\n{DDB201}: {FFFFFF}/finfo",x-1);
                    
    FarmInfo[x][fLabel] = CreateDynamic3DTextLabel(YCMDstr0xDDB201FF,FarmInfo[x][fMenu][0], FarmInfo[x][fMenu][1], FarmInfo[x][fMenu][2]+1,20.0);
                    
    CreateDynamicMapIcon(FarmInfo[x][fMenu][0], FarmInfo[x][fMenu][1], FarmInfo[x][fMenu][2],56,0);
                    
    TOTALFARM++;
                }
                
    printf("[ ...]   Farm ! (%i .)",TOTALFARM);
                
    //    0
                
    FarmInfo[1][fSeed_Car][0] = CreateVehicle(478,-367.1718,-1437.3184,25.4536,90,113,1,10000);
                
    FarmInfo[1][fSeed_Car][1] = CreateVehicle(478,-367.1942,-1441.3794,25.4536,90,113,1,10000);
                   
    FarmInfo[1][fCombine] = CreateVehicle(532,-376.9983,-1450.1539,25.4536,360,-1,-1,10000);
                   
    //    1
                   
    FarmInfo[2][fSeed_Car][0] = CreateVehicle(478,-112.7682,-30.3074,2.8443,345,113,1,10000);
                
    FarmInfo[2][fSeed_Car][1] = CreateVehicle(478,-108.8456,-30.3074,2.8443,345,113,1,10000);
                   
    FarmInfo[2][fCombine] = CreateVehicle(532,-99.6833,-21.9806,2.8404,69.9411,-1,-1,10000);
                   
    //    2
                   
    FarmInfo[3][fSeed_Car][0] = CreateVehicle(478,-1033.8198,-1173.0507,128.9458,92.2105,113,1,10000);
                
    FarmInfo[3][fSeed_Car][1] = CreateVehicle(478,-1033.9097,-1169.5416,128.9458,92.2105,113,1,10000);
                   
    FarmInfo[3][fCombine] = CreateVehicle(532,-1187.8906,-1062.9275,128.9458,360,-1,-1,10000);
                   
    //    3
                   
    FarmInfo[4][fSeed_Car][0] = CreateVehicle(478,-18.6129,45.1707,2.8443,248.6538,113,1,10000);
                
    FarmInfo[4][fSeed_Car][1] = CreateVehicle(478,-19.8854,42.0788,2.8429,248.6538,113,1,10000);
                   
    FarmInfo[4][fCombine] = CreateVehicle(532,-28.4954,44.7194,2.8443,160.1106,-1,-1,10000);
                   
    //    4
                   
    FarmInfo[5][fSeed_Car][0] = CreateVehicle(478,1949.1245,157.6664,36.6507,340.1,113,1,10000);
                
    FarmInfo[5][fSeed_Car][1] = CreateVehicle(478,1951.6958,156.7463,36.5491,340.1,113,1,10000);
                   
    FarmInfo[5][fCombine] = CreateVehicle(532,1946.6146,167.1301,37.0083,71.0403,-1,-1,10000);
                   for(new 
    1<= TOTALFARMz++)
                {
                    
    Farmcar_pickup[FarmInfo[z][fSeed_Car][0]] = 0;
                       
    Farmcar_pickup[FarmInfo[z][fSeed_Car][1]] = 0;
                       
    SetVehicleParamsEx(FarmInfo[z][fSeed_Car][0],false,false,false,false,false,false,false);
                       
    SetVehicleParamsEx(FarmInfo[z][fSeed_Car][1],false,false,false,false,false,false,false);
                       
    SetVehicleParamsEx(FarmInfo[z][fCombine],false,false,false,false,false,false,false);
                       
    CarHealth[FarmInfo[z][fSeed_Car][0]] = float(1000);
                       
    CarHealth[FarmInfo[z][fSeed_Car][1]] = float(1000);
                       
    CarHealth[FarmInfo[z][fCombine]] = float(1000);
                }
            }
            case 
    29:
            {
                new 
    daymonthyear;
                
    gettime(day,month,year);
                 if(
    IsPlayerConnected(GetPlayerID(FarmInfo[playerid][fAuctionName]))) SendClientMessage(GetPlayerID(FarmInfo[playerid][fAuctionName]),COLOR_WHITE,"  /  !");
                
    strmid(FarmInfo[playerid][fOwner],"None",0,strlen("None"),MAX_PLAYER_NAME);
                
    strmid(FarmInfo[playerid][fDeputy_1],"None",0,strlen("None"),MAX_PLAYER_NAME);
                
    strmid(FarmInfo[playerid][fDeputy_2],"None",0,strlen("None"),MAX_PLAYER_NAME);
                
    strmid(FarmInfo[playerid][fDeputy_3],"None",0,strlen("None"),MAX_PLAYER_NAME);
                
    FarmInfo[playerid][fLandTax] = 6000;
                
    FarmInfo[playerid][fBank] = (FarmInfo[playerid][fAuction][0]/100)*20;
                
    FarmInfo[playerid][fProds] = 0;
                
    FarmInfo[playerid][fZp] = 30;
                
    FarmInfo[playerid][fGrain_Price] = 5;
                
    FarmInfo[playerid][fGrain] = 0;
                
    FarmInfo[playerid][fGrain_Sown] = 0;
                
    FarmInfo[playerid][fProds_Selling] = 1;
                
    FarmInfo[playerid][fProds_Price] = 21;
                
    strmid(FarmInfo[playerid][fOwner],FarmInfo[playerid][fAuctionName], 0strlen(FarmInfo[playerid][fAuctionName]), MAX_PLAYER_NAME);
                if(
    IsPlayerConnected(GetPlayerID(FarmInfo[playerid][fAuctionName]))) FGet(GetPlayerID(FarmInfo[playerid][fAuctionName]));
                
    strmid(FarmInfo[playerid][fAuctionName], "None"0strlen("None"), 10);
                
    FarmInfo[playerid][fAuction][0] = 0;
                
    FarmInfo[playerid][fAuction][1] = 0;
                
    FarmInfo[playerid][fAuction][2] = 0;
                
    FarmInfo[playerid][fAuction][3] = 0;
                
    FarmInfo[playerid][fAuction][4] = mktime(0,0,0,day+14,month,year);
            }
            case 
    30:
            {
                if(!
    r) return printf("[ /]  .    !");
                
    mysql_format(DATABASEQUERY128"UPDATE `"TABLE_ACCOUNTS"` SET pBank = pBank + %i WHERE Name = '%e'",FarmInfo[bizselect[playerid]][fAuction][1],FarmInfo[bizselect[playerid]][fAuctionName]);
                
    mysql_tquery(DATABASE,QUERY,"","");
            }
            case 
    31:
            {
                if(!
    r) return printf("[ ...]   Stall  !");
                for(
    1<= rx++)
                {
                    
    StallInfo[x][stID] =                 cache_get_row_int(x-1,0DATABASE);
                    
    StallInfo[x][stPos][0] =             cache_get_row_float(x-1,1DATABASE);
                    
    StallInfo[x][stPos][1] =             cache_get_row_float(x-1,2DATABASE);
                    
    StallInfo[x][stPos][2] =             cache_get_row_float(x-1,3DATABASE);
                    
    StallInfo[x][stPos][3] =             cache_get_row_float(x-1,4DATABASE);
                    
    TOTALSTALL++;

                    
    CreateDynamicObject(1340StallInfo[x][stPos][0], StallInfo[x][stPos][1], StallInfo[x][stPos][2], 00StallInfo[x][stPos][3]);
                    
    StallInfo[x][stText] = CreateDynamic3DTextLabel" "0xFF8C37FFStallInfo[x][stPos][0], StallInfo[x][stPos][1], StallInfo[x][stPos][2], 8.0 );
                }
                
    printf("[ ...]   Stall ! (%i .)",TOTALSTALL);
            }
            case 
    32:
            {
                if(!
    r) return printf("[ ...]   Gangzone  !");
                for(
    1<= rx++)
                {
                    
    GZInfo[x][gID] =                     cache_get_row_int(x-1,0DATABASE);
                    
    GZInfo[x][gCoords][0] =             cache_get_row_float(x-1,1DATABASE);
                    
    GZInfo[x][gCoords][1] =             cache_get_row_float(x-1,2DATABASE);
                    
    GZInfo[x][gCoords][2] =             cache_get_row_float(x-1,3DATABASE);
                    
    GZInfo[x][gCoords][3] =             cache_get_row_float(x-1,4DATABASE);
                    
    GZInfo[x][gFrakVlad] =                 cache_get_row_int(x-1,5DATABASE);
                    
    TOTALGZ++;

                    
    GZInfo[x][gZone] = GangZoneCreate(GZInfo[x][gCoords][0],GZInfo[x][gCoords][1],GZInfo[x][gCoords][2],GZInfo[x][gCoords][3]);
                }
                
    printf("[ ...]   Gangzone ! (%i .)",TOTALGZ);
            }
            case 
    33:
            {
                if(!
    r)
                {
                    
    mysql_format(DATABASEQUERYsizeof(QUERY), "INSERT INTO `"TABLE_CARS"` (`owner`) VALUES ('%s')" ,PTEMP[playerid][pName]);
                    
    mysql_tquery(DATABASE,QUERY,"","");
                    return 
    SendClientMessage(playerid,COLOR_GREY,"!     ,   !"), Kick(playerid);
                }
                for(
    0rx++)
                {
                    
    CarInfo[playerid][carID][x] =              cache_get_row_int(x,0DATABASE);
                    
    cache_get_row(x1,             stringDATABASEMAX_PLAYER_NAME);
                    
    CarInfo[playerid][carModel][x] =           cache_get_row_int(x,2DATABASE);
                    
    CarInfo[playerid][carColor_one][x] =       cache_get_row_int(x,3DATABASE);
                    
    CarInfo[playerid][carColor_two][x] =       cache_get_row_int(x,4DATABASE);
                    
    CarInfo[playerid][carPercent][x] =       cache_get_row_int(x,5DATABASE);
                    
    CarInfo[playerid][carFuel][x] =           cache_get_row_float(x,6DATABASE);
                }
                if(
    HGet(playerid) != 0)
                {
                    new 
    house GetPVarInt(playerid,"House");
                    
    createdcar house_car[playerid];
                    
    house_car[playerid] = CreateVehicle(CarInfo[playerid][carModel][0], HouseInfo[house][hCarx], HouseInfo[house][hCary], HouseInfo[house][hCarz], HouseInfo[house][hCarc] , CarInfo[playerid][carColor_one][0] ,CarInfo[playerid][carColor_two][0], 86400);
                    
    SetVehicleParamsEx(house_car[playerid],false,false,false,true,false,false,false);
                    
    CarHealth[house_car[playerid]] = float(1000);
                    
    createdcar ++;
                    
    Fuell[house_car[playerid]] = CarInfo[playerid][carFuel][0];
                    
    LoadTuning(playerid,house_car[playerid]);
                }
                
    printf("[ ...]   %s  !",string);
            }
        }
        return 
    1;

    [/PHP]
    OnGameMode

    PHP :
    DATABASE mysql_connect(mysql_hostmysql_usermysql_dbmysql_pass);
        
    mysql_tquery(DATABASE,"SET NAMES cp1251","","");
        
    mysql_tquery(DATABASE,"SET SESSION character_set_server='utf8';","","");
        
    mysql_stat(string); print(string);
        
    mysql_tquery(DATABASE,"SELECT * FROM `"TABLE_HOUSE"`","OnMySQL_QUERY","iis",11,-1,"");
        
    mysql_tquery(DATABASE,"SELECT * FROM `"TABLE_BIZZ"`","OnMySQL_QUERY","iis",6,-1,"");
        
    mysql_tquery(DATABASE,"SELECT * FROM `"TABLE_WORKSHOPS"`","OnMySQL_QUERY","iis",7,-1,"");
        
    mysql_tquery(DATABASE,"SELECT * FROM `"TABLE_KVARTIRS"`","OnMySQL_QUERY","iis",8,-1,"");
        
    mysql_tquery(DATABASE,"SELECT * FROM `"TABLE_PODEZDS"`","OnMySQL_QUERY","iis",9,-1,"");
        
    mysql_tquery(DATABASE,"SELECT * FROM `"TABLE_CASINO"`","OnMySQL_QUERY","iis",10,-1,"");
        
    mysql_tquery(DATABASE,"SELECT * FROM `"TABLE_OTHERS"`","OnMySQL_QUERY","iis",0,-1,"");
        
    mysql_tquery(DATABASE,"SELECT * FROM `"TABLE_ATM"`","OnMySQL_QUERY","iis",22,-1,"");
        
    mysql_tquery(DATABASE,"SELECT * FROM `"TABLE_FARM"`","OnMySQL_QUERY","iis",28,-1,"");
        
    mysql_tquery(DATABASE,"SELECT * FROM `"TABLE_STALL"`","OnMySQL_QUERY","iis",31,-1,"");
        
    mysql_tquery(DATABASE,"SELECT * FROM `"TABLE_GANGZONE"`","OnMySQL_QUERY","iis",32,-1,"");
        
    ////////////////     /////////////////
        //  
        
    mysql_tquery(DATABASE,"SELECT * FROM `"TABLE_BAN"`","OnMySQL_QUERY","iis",26,-1,""); 
    Dezmont_Mailz; 25.03.2020 17:48.
  6. #6

      93

    :
    :06.06.2011
    :
    :351
    :90 [+/-] 
    ?
    Modern RP

    We do not drink vodka every day and do not play the balalaika you think about us. ^_^ Mexanizm
  7. #7

      Dezmont_Mailz

    :
    :01.04.2012
    :
    :372
    :64 [+/-] 
    ?




  8. #8

      Dezmont_Mailz

    :
    :01.04.2012
    :
    :372
    :64 [+/-] 
    https://gtaisland.ru/samp/gotovye-se...ysql-v037.html ( )

    [22:14:43] [ ...] Kvart !
    [22:14:43] [ ...] Podezd !
  9. #9

      execution

    :
    :23.06.2017
    :315
    :51 [+/-] 
    , , . , .
  10. #10

      Dezmont_Mailz

    :
    :01.04.2012
    :
    :372
    :64 [+/-] 
    , , . , .
    !!!

, : 17

..., 018, 201, 2018, , , , , , gold, https, hunter, , , , , img, , , , , ?, , ,




(, , , , ),
, .
Pawno-Info.Ru!

samp-rp advanvce pawn s0beit cs 1.6 0.3x World of Tanks samp-rp, samp-rp, - PAWNO SA-MP IV-MP MTA cleo s0beit sobeit sa-mp sa-mp pawno pawno pawno iv-mp iv-mp iv-mp godfather SAMP gta 4 4 GTA 4 GTA 4 GTA 4 SAMP SAMP Pen1 LS Pen1 Fugitive The Godfather rp roleplay samp-rp sa-mp sa-mp pawno gta-iv gta-v gta-sa gta-3 gta-III gta-4 gta-5 gta-vc mta mta-dm mta-race mta-sa pawno info ru pawno pawno gta-iv gta-iv gta-v gta-v gta-iv keygen gta sa gta 4 multiplayer gta san adnreas multiplayer sa-mp forum sa-mp pawno sa-mp pawno sa-mp gta-sa pawno pawno errors sa-mp 0.3c SA-MP 0.3d 4 GTA 4 GTA 4 GTA 4 SAMP SAMP Pen1 LS Pen1 Fugitive The Godfather SAMP hack rat android instagram twitter ddos root linux ubuntu mac android advance arizona 4g