Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- publics:MysqlType(playerid, type, name[], parametr)
- {
- new f,g;
- cache_get_data(f,g);
- switch(type)
- {
- case 1:
- {
- if(f)
- {
- new string[128];
- format(string, sizeof(string), "UPDATE accounts SET pBank = pBank + %d WHERE name = '%s'",BizzInfo[bizselect[playerid]][bLastStavka],BizzInfo[bizselect[playerid]][bNameStavka]);
- mysql_empty(connects,string);
- }
- }
- case 2:
- {
- if(!f)
- {
- SendClientMessage(playerid,COLOR_GREY,"Àêêàóíò íå íàéäåí");
- ShowPlayerDialogEx(playerid,2625,DIALOG_STYLE_INPUT, "Ïî ïðèãëàøåíèþ îò:", "Ââåäèòå íèê èãðîêà, ïðèãëàñèâøèãî âàñ íà ñåðâåð", "Äàëåå", "Ïðîïóñê");
- return 1;
- }
- strmid(PlayerInfo[playerid][pDrug], name, 0, strlen(name), strlen(name)+5);
- }
- case 3:
- {
- new tmp2[256], string[500];
- new playername2[MAX_PLAYER_NAME];
- if(f)
- {
- BaseGetInt("pID", PlayerIDs[playerid]); BaseGetInt("pLevel", PlayerInfo[playerid][pLevel]); BaseGetInt("pPhousekey", PlayerInfo[playerid][pPhousekey]);
- BaseGetInt("pPbiskey", PlayerInfo[playerid][pPbiskey]); BaseGetInt("pAdmin", PlayerInfo[playerid][pAdmin]); BaseGetInt("pHelper", PlayerInfo[playerid][pHelper]);
- BaseGetInt("pForma", PlayerInfo[playerid][pForma]); BaseGetInt("pJobHeal", PlayerInfo[playerid][pJobHeal]); BaseGetInt("pJobHealLeader", PlayerInfo[playerid][pJobHealLeader]);
- BaseGetFloat("pFuelcar", PlayerInfo[playerid][pFuelcar]); BaseGetInt("pText", PlayerInfo[playerid][pText]); BaseGetInt("pPodarok1", PlayerInfo[playerid][pPodarok][0]);
- BaseGetInt("pPodarok2", PlayerInfo[playerid][pPodarok][1]); BaseGetInt("pHP", PlayerInfo[playerid][pHP]); BaseGetInt("pSatiety", PlayerInfo[playerid][pSatiety]);
- BaseGet("pKeyip", PlayerInfo[playerid][pKeyip]); BaseGet("pEmail", PlayerInfo[playerid][pEmail]); BaseGetInt("pCheckip", PlayerInfo[playerid][pCheckip]);
- BaseGetInt("pReg", PlayerInfo[playerid][pReg]); BaseGetInt("pTut", PlayerInfo[playerid][pTut]); BaseGetInt("pGod", PlayerInfo[playerid][pGod]);
- BaseGetInt("pMes", PlayerInfo[playerid][pMes]); BaseGet("pDataReg", PlayerInfo[playerid][pDataReg]); BaseGetInt("pVhoddata", PlayerInfo[playerid][pVhoddata]);
- BaseGetInt("pVhodMes", PlayerInfo[playerid][pVhodMes]); BaseGetInt("pVhodchas", PlayerInfo[playerid][pVhodchas]); BaseGetInt("pVhodminute", PlayerInfo[playerid][pVhodminute]);
- BaseGetInt("pPhoneBook", PlayerInfo[playerid][pPhoneBook]); BaseGetInt("pDirectory", PlayerInfo[playerid][pDirectory]); BaseGetInt("pIphone", PlayerInfo[playerid][pIphone]);
- BaseGetInt("pGrant", PlayerInfo[playerid][pGrant]); BaseGetInt("pKvestTeach", PlayerInfo[playerid][pKvestTeach]); BaseGetInt("pDoneKvestTeach", PlayerInfo[playerid][pDoneKvestTeach]); BaseGetInt("pAlcoholPerk", PlayerInfo[playerid][pAlcoholPerk]);
- BaseGet("pIp", PlayerInfo[playerid][pIp]); BaseGet("pvIp", PlayerInfo[playerid][pvIp]); BaseGet("pIpReg", PlayerInfo[playerid][pIpReg]);
- BaseGetInt("pCar", PlayerInfo[playerid][pCar]); BaseGetInt("pDonatechet", PlayerInfo[playerid][pDonatechet]); BaseGetInt("pDonatemoney", PlayerInfo[playerid][pDonatemoney]);
- BaseGetInt("pDonateRank", PlayerInfo[playerid][pDonateRank]); BaseGetInt("pSex", PlayerInfo[playerid][pSex]); BaseGetInt("pArrested", PlayerInfo[playerid][pArrested]);
- BaseGetInt("pMuted", PlayerInfo[playerid][pMuted]); BaseGetInt("pCrimes", PlayerInfo[playerid][pCrimes]); BaseGetInt("pExp", PlayerInfo[playerid][pExp]);
- BaseGetInt("pCash", PlayerInfo[playerid][pCash]); BaseGetInt("pKills", PlayerInfo[playerid][pKills]); BaseGetInt("pDeaths", PlayerInfo[playerid][pDeaths]);
- BaseGetInt("pPayCheck", PlayerInfo[playerid][pPayCheck]); BaseGetInt("pJailed", PlayerInfo[playerid][pJailed]); BaseGetInt("pCheat", PlayerInfo[playerid][pCheat]);
- BaseGetInt("pJailTime", PlayerInfo[playerid][pJailTime]); BaseGetInt("pMats", PlayerInfo[playerid][pMats]); BaseGetInt("pDrugs", PlayerInfo[playerid][pDrugs]);
- BaseGetInt("pLeader", PlayerInfo[playerid][pLeader]); BaseGetInt("pMember", PlayerInfo[playerid][pMember]); BaseGetInt("pRank", PlayerInfo[playerid][pRank]);
- BaseGetInt("pJob", PlayerInfo[playerid][pJob]); BaseGetInt("pCarLic", PlayerInfo[playerid][pCarLic]); BaseGetInt("pBizLic", PlayerInfo[playerid][pBizLic]);
- BaseGetInt("pFlyLic", PlayerInfo[playerid][pFlyLic]); BaseGetInt("pBoatLic", PlayerInfo[playerid][pBoatLic]); BaseGetInt("pFishLic", PlayerInfo[playerid][pFishLic]);
- BaseGetInt("pGunLic", PlayerInfo[playerid][pGunLic]); BaseGetInt("pSlot1", PlayerInfo[playerid][pSlot1]); BaseGetInt("pSlot2", PlayerInfo[playerid][pSlot2]);
- BaseGetInt("pSlot3", PlayerInfo[playerid][pSlot3]); BaseGetInt("pSlot4", PlayerInfo[playerid][pSlot4]); BaseGetInt("pSlot5", PlayerInfo[playerid][pSlot5]);
- BaseGetInt("pSlot6", PlayerInfo[playerid][pSlot6]); BaseGetInt("pSlot7", PlayerInfo[playerid][pSlot7]); BaseGetInt("pSlot8", PlayerInfo[playerid][pSlot8]);
- BaseGetInt("pSlot9", PlayerInfo[playerid][pSlot9]); BaseGetInt("pSlot10", PlayerInfo[playerid][pSlot10]); BaseGetInt("pSlot11", PlayerInfo[playerid][pSlot11]);
- BaseGetInt("pSlotammo1", PlayerInfo[playerid][pSlotammo1]); BaseGetInt("pSlotammo2", PlayerInfo[playerid][pSlotammo2]); BaseGetInt("pSlotammo3", PlayerInfo[playerid][pSlotammo3]);
- BaseGetInt("pSlotammo4", PlayerInfo[playerid][pSlotammo4]); BaseGetInt("pSlotammo5", PlayerInfo[playerid][pSlotammo5]); BaseGetInt("pSlotammo6", PlayerInfo[playerid][pSlotammo6]);
- BaseGetInt("pSlotammo7", PlayerInfo[playerid][pSlotammo7]); BaseGetInt("pSlotammo8", PlayerInfo[playerid][pSlotammo8]); BaseGetInt("pSlotammo9", PlayerInfo[playerid][pSlotammo9]);
- BaseGetInt("pSlotammo10", PlayerInfo[playerid][pSlotammo10]); BaseGetInt("pSlotammo11", PlayerInfo[playerid][pSlotammo11]); BaseGetInt("pGunSkill1", PlayerInfo[playerid][pGunSkill][0]);
- BaseGetInt("pGunSkill2", PlayerInfo[playerid][pGunSkill][1]); BaseGetInt("pGunSkill3", PlayerInfo[playerid][pGunSkill][2]); BaseGetInt("pGunSkill4", PlayerInfo[playerid][pGunSkill][3]);
- BaseGetInt("pGunSkill5", PlayerInfo[playerid][pGunSkill][4]); BaseGetInt("pGunSkill6", PlayerInfo[playerid][pGunSkill][5]); BaseGetInt("ptaxiexp", PlayerInfo[playerid][ptaxiexp]);
- BaseGetInt("ptaxilvl", PlayerInfo[playerid][ptaxilvl]); BaseGetInt("pDLevel", PlayerInfo[playerid][pDLevel]); BaseGetInt("pDExp", PlayerInfo[playerid][pDExp]);
- BaseGetInt("pDMgruz", PlayerInfo[playerid][pDMgruz]); BaseGetInt("pDgruz", PlayerInfo[playerid][pDgruz]); BaseGetInt("pKazpay", PlayerInfo[playerid][pKazpay]);
- BaseGetInt("pChar", PlayerInfo[playerid][pChar][0]); BaseGetInt("pChar1", PlayerInfo[playerid][pChar][1]); BaseGetInt("pChar2", PlayerInfo[playerid][pChar][2]);
- BaseGetInt("pViborChar", PlayerInfo[playerid][pViborChar]); BaseGetFloat("pSHealth", PlayerInfo[playerid][pSHealth]); BaseGetFloat("pHealth", PlayerInfo[playerid][pHealth]);
- BaseGetInt("pInt", PlayerInfo[playerid][pInt]); BaseGetInt("pLocal", PlayerInfo[playerid][pLocal]); BaseGetInt("pModel", PlayerInfo[playerid][pModel]);
- BaseGetInt("pPnumber", PlayerInfo[playerid][pPnumber]); BaseGetInt("pPayDay", PlayerInfo[playerid][pPayDay]); BaseGetInt("pPayDayHad", PlayerInfo[playerid][pPayDayHad]);
- BaseGetInt("pWarns", PlayerInfo[playerid][pWarns]); BaseGetInt("punWarns", PlayerInfo[playerid][punWarns]); BaseGetInt("punWarnstime", PlayerInfo[playerid][punWarnstime]);
- BaseGetInt("pFuel", PlayerInfo[playerid][pFuel]); BaseGetInt("pMarried", PlayerInfo[playerid][pMarried]); BaseGet("pDrug", PlayerInfo[playerid][pDrug]);
- BaseGet("pMarriedTo", PlayerInfo[playerid][pMarriedTo]); BaseGetInt("pMushrooms", PlayerInfo[playerid][pMushrooms]); BaseGetInt("pMuteTime", PlayerInfo[playerid][pMuteTime]);
- BaseGetInt("pMobile", PlayerInfo[playerid][pMobile]); BaseGetInt("pBank", PlayerInfo[playerid][pBank]); BaseGetInt("pLocked", PlayerInfo[playerid][pLocked]);
- BaseGetInt("pBanDay", PlayerInfo[playerid][pBanDay]); BaseGetInt("pBanMounth", PlayerInfo[playerid][pBanMounth]); BaseGetInt("pDolg", PlayerInfo[playerid][pDolg]);
- BaseGetInt("pKrisha", PlayerInfo[playerid][pKrisha]); BaseGetInt("pUseKrisha", PlayerInfo[playerid][pUseKrisha]); BaseGetInt("pBoxSkill", PlayerInfo[playerid][pBoxSkill]);
- BaseGetInt("pKongfuSkill", PlayerInfo[playerid][pKongfuSkill]); BaseGetInt("pKickboxSkill", PlayerInfo[playerid][pKickboxSkill]); BaseGet("pDostup", PlayerInfo[playerid][pDostup]);
- BaseGetFloat("pFishes", PlayerInfo[playerid][pFishes]); BaseGetInt("pZakonp", PlayerInfo[playerid][pZakonp]); BaseGetInt("pAddiction", PlayerInfo[playerid][pAddiction]);
- BaseGetInt("pNarcoLomka", PlayerInfo[playerid][pNarcoLomka]); BaseGetInt("pProcents", PlayerInfo[playerid][pProcents]); BaseGetInt("pWheels", PlayerInfo[playerid][pWheels]);
- BaseGetInt("pPaintJob", PlayerInfo[playerid][pPaintJob]); BaseGetInt("pSpoiler", PlayerInfo[playerid][pSpoiler]); BaseGetInt("pBumper1", PlayerInfo[playerid][pBumper1]);
- BaseGetInt("pBumper2", PlayerInfo[playerid][pBumper2]); BaseGetInt("pColor1", PlayerInfo[playerid][pColor][0]); BaseGetInt("pColor2", PlayerInfo[playerid][pColor][1]);
- BaseGetInt("pNitro", PlayerInfo[playerid][pNitro]); BaseGetInt("pHydrawlic", PlayerInfo[playerid][pHydrawlic]); BaseGetInt("pAvtomas", PlayerInfo[playerid][pAvtomas]);
- BaseGetInt("pMestoJail", PlayerInfo[playerid][pMestoJail]); BaseGetInt("pSong", PlayerInfo[playerid][pSong]); BaseGetInt("pHousecash", PlayerInfo[playerid][pHousecash]);
- BaseGetInt("pKvartiraKey", PlayerInfo[playerid][pKvartirakey]); BaseGetInt("pWantedLevel", PlayerInfo[playerid][pWantedLevel]); BaseGetInt("pChas", PlayerInfo[playerid][pChas]);
- BaseGetInt("pMin", PlayerInfo[playerid][pMin]); BaseGetInt("pSkilla", PlayerInfo[playerid][pSkilla]); BaseGetInt("pLighter", PlayerInfo[playerid][pLighter]);
- BaseGetInt("pCigarettes", PlayerInfo[playerid][pCigarettes]); BaseGetInt("pRecognition", PlayerInfo[playerid][pRecognition]);
- BaseGetInt("pRobHouse", PlayerInfo[playerid][pRobHouse]);
- BaseGetInt("pRobCar", PlayerInfo[playerid][pRobCar]); BaseGetInt("activate_mail", PlayerInfo[playerid][pActivemail]); BaseGetInt("pFishesPach", PlayerInfo[playerid][pFishesPach]);
- }
- PlayerInfo[playerid][pLogin] = 1;
- format(string, sizeof(string), "UPDATE accounts SET pLogin = '%d' WHERE name = '%s'",PlayerInfo[playerid][pLogin],Name(playerid));
- mysql_empty(connects,string);
- new current = getdate();
- if(PlayerInfo[playerid][pBanMounth] > current && PlayerInfo[playerid][pLocked] == 1)
- {
- format(string, sizeof(string), "{d95841}Ýòîò àêêàóíò çàáëîêèðîâàí\nÐàçáàí ÷åðåç %d äíåé\n\nÂâåäèòå ''/q'' ÷òîáû âûéòè",PlayerInfo[playerid][pBanMounth]-current);
- ShowPlayerDialogEx(playerid,78,0,"{c22000}Âíèìàíèå",string,"Çàêðûòü","");
- Kick(playerid);
- return 1;
- }
- else if(PlayerInfo[playerid][pBanMounth] <= current && PlayerInfo[playerid][pLocked] == 1)
- {
- PlayerInfo[playerid][pLocked] = 0;
- PlayerInfo[playerid][pBanMounth] = 0;
- PlayerInfo[playerid][pBanDay] = 0;
- }
- new playersip[40];
- GetPlayerIp(playerid,playersip,sizeof(playersip));
- if(PlayerInfo[playerid][pCheckip] == 1)
- {
- if(strcmp(playersip, PlayerInfo[playerid][pIp]) != 0)
- {
- PlayerInfo[playerid][pLogin] = 0;
- format(string, sizeof(string), "UPDATE accounts SET pLogin = '%d' WHERE name = '%s'",PlayerInfo[playerid][pLogin],Name(playerid));
- mysql_empty(connects,string);
- SetPlayerInterior(playerid, 0);
- SetPlayerFacingAngle(playerid, 179.5547);
- SetPlayerCameraPos(playerid, 1357.414428,-1450.705322,252.353897);
- SetPlayerCameraLookAt(playerid, 1365.318969,-1445.091796,249.903198);
- TogglePlayerControllable(playerid, 0);
- ShowPlayerDialogEx(playerid,16,DIALOG_STYLE_INPUT, "Ââåäèòå êëþ÷ áåçîïàñíîñòè", " ==== Âàø IP àäðåñ ñìåíèëñÿ ====\n=== Ââåäèòå Âàø êëþ÷ áåçîïàñíîñòè ===", "Ãîòîâî", "Îòìåíà");
- PlayerInfo[playerid][pLogin] = 0;
- return true;
- }
- }
- if(PlayerInfo[playerid][pCheckip] == 1)
- {
- PlayerInfo[playerid][pLogin] = 1;
- format(string, sizeof(string), "UPDATE accounts SET pLogin = '%d',pvIp = '%s' WHERE name = '%s'",PlayerInfo[playerid][pLogin],playersip,Name(playerid));
- mysql_empty(connects,string);
- }
- if(PlayerInfo[playerid][pCheckip] == 0)
- {
- GetPlayerIp(playerid,playersip,sizeof(playersip));
- PlayerInfo[playerid][pLogin] = 1;
- format(string, sizeof(string), "UPDATE accounts SET pLogin = '%d',pIp = '%s',pvIp = '%s' WHERE name = '%s'",PlayerInfo[playerid][pLogin],playersip,playersip,Name(playerid));
- mysql_empty(connects,string);
- }
- FormaFrac[playerid] = PlayerInfo[playerid][pForma];
- if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 2) PlayerInfo[playerid][pKvestTeach] = 1;
- if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 5) PlayerInfo[playerid][pKvestTeach] = 4;
- if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 8) PlayerInfo[playerid][pKvestTeach] = 7;
- if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 11) PlayerInfo[playerid][pKvestTeach] = 10;
- if(FormaFrac[playerid] != 0 && !IsAGang(playerid) && !IsAMafia(playerid)) SpawnChange[playerid] = 0;
- if(PlayerInfo[playerid][pCash] < 0) PlayerInfo[playerid][pCash] = 0;
- if(PlayerInfo[playerid][pProcents] <= 3) PlayerInfo[playerid][pProcents] = 4;
- if(PlayerInfo[playerid][pChar][PlayerInfo[playerid][pViborChar]] == 0) PlayerInfo[playerid][pChar][PlayerInfo[playerid][pViborChar]] = 230;
- if(PlayerInfo[playerid][pAdmin] <= 0) PlayerInfo[playerid][pDostup] = 521957921;
- if(PlayerInfo[playerid][pDonateRank] > 0) SendClientMessage(playerid, 0xFEBC41AA, "Çäðàâñòâóéòå VIP èãðîê!"), format(tmp2, sizeof(tmp2), "~w~Welcome ~n~~b~ %s", playername2);
- else format(tmp2, sizeof(tmp2), "~w~Welcome ~n~~b~ %s", playername2);
- GameTextForPlayer(playerid, tmp2, 5000, 1);
- if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 0) SetPlayerCheckpoint(playerid, -1510.5208,921.0080,7.1875, 0.3);
- if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 1) SetPlayerCheckpoint(playerid, 616.5748,1191.5874,11.7188, 0.3);
- if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 3) SetPlayerCheckpoint(playerid, 616.5748,1191.5874,11.7188, 0.3);
- if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 4) SetPlayerCheckpoint(playerid, 662.6733,844.0513,-42.9609, 0.3);
- if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 6) SetPlayerCheckpoint(playerid, 662.6733,844.0513,-42.9609, 0.3);
- if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 7) SetPlayerCheckpoint(playerid, 2477.0745,1957.6842,10.6088, 0.3);
- if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 9) SetPlayerCheckpoint(playerid, 2477.0745,1957.6842,10.6088, 0.3);
- if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 10) SetPlayerCheckpoint(playerid, -2038.1396,-103.9433,35.1719, 0.3);
- if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 12) SetPlayerCheckpoint(playerid, -2038.1396,-103.9433,35.1719, 0.3);
- //if(!PlayerInfo[playerid][pActivemail]) SendClientMessage(playerid,COLOR_WHITE,"Ó âàñ íå ïîäòâåðæäåí {FFFF00}E-mail{ffffff} àäðåñ. Ïîäòâåðäèòü {FFFF00}E-mail{ffffff} âû ìîæåòå íà ñàéòå: {FFFF00}"NameSite"");
- if (PlayerInfo[playerid][pText] == 6) SendClientMessage(playerid, COLOR_WHITE, "Âû ïðèîáðåëè áèçíåñ ñ àóêöèîíà. Óïðàâëåíèå:{FFFF00} /mm - [3] Êîìàíäû ñåðâåðà"), PlayerInfo[playerid][pText] = 0;
- if (PlayerInfo[playerid][pText] == 4) SendClientMessage(playerid, COLOR_WHITE, "Ñ Âàñ áûëà ñíÿòà ëèäåðêà îðãàíèçàöèè"), PlayerInfo[playerid][pText] = 0;
- if (PlayerInfo[playerid][pText] == 5) SendClientMessage(playerid, COLOR_WHITE, "Âàøà àâòîìàñòåðñêàÿ áûëà ïðîäàíà ãîñóäàðñòâó. Ïîëîâèíà ñòîèìîñòè çà÷èñëåíà íà âàø ñ÷åò"), PlayerInfo[playerid][pText] = 0;
- if (PlayerInfo[playerid][pText] == 3) PlayerInfo[playerid][pText] = 0, SendClientMessage(playerid, COLOR_WHITE, "Âû ïîëó÷èëè 100 000 âèðò íà áàíêîâñêèé ñ÷åò, çà ïðèãëàø¸ííîãî äðóãà");
- if (PlayerInfo[playerid][pText] == 1) SendClientMessage(playerid, COLOR_LIGHTRED, "Âû áûëè âûñåëåíû çà íåóïëàòó êâàðòïëàòû"), SendClientMessage(playerid, COLOR_LIGHTRED, "Äåíüãè çà äîì âû ìîæåòå ïîëó÷èòü â áàíêå \"/GetHouseMoney\"");
- if (PlayerInfo[playerid][pText] == 2) SendClientMessage(playerid, COLOR_YELLOW, "Âàø áèçíåñ áûë ïðîäàí ãîñóäàðñòâó çà ïðîñòîé ãîñóäàðñòâó. Ïîëîâèíà ñòîèìîñòè çà÷èñëåíà íà âàø áàíêîâñêèé ñ÷åò"), PlayerInfo[playerid][pText] = 0;
- if(PlayerInfo[playerid][pPhousekey] != 999)
- {
- new house = PlayerInfo[playerid][pPhousekey];
- createdcar = caridhouse[playerid];
- caridhouse[playerid] = CreateVehicle(PlayerInfo[playerid][pCar], HouseInfo[house][hCarx], HouseInfo[house][hCary], HouseInfo[house][hCarz], HouseInfo[house][hCarc] , PlayerInfo[playerid][pColor][0] ,PlayerInfo[playerid][pColor][1], 86400);
- createdcar ++;
- LockCar(caridhouse[playerid]);
- Fuell[caridhouse[playerid]] = PlayerInfo[playerid][pFuelcar];
- CompVeh(playerid,caridhouse[playerid]);
- }
- PEfir[playerid] = 255;
- Pefir[playerid] = 999;
- SpawnPlayer(playerid);
- InitLockDoors(playerid);
- GangZoneShowForPlayer(playerid, Army, COLOR_YELLOW2);
- SetPlayerHealthAC(playerid, PlayerInfo[playerid][pHP]);
- ResetPlayerMoney(playerid);
- OnPlayerUpdateAc(playerid);
- printf("Login");
- if(PlayerInfo[playerid][pAdmin] >= 1) SendClientMessage(playerid,COLOR_WHITE,"Âû âîøëè êàê àäìèíèñòðàòîð. Äëÿ àâòîðèçàöèè, ââåäèòå {FFFF00}\"/alogin\""), SendClientMessage(playerid,COLOR_WHITE,"Ïîêà âû íå àâòîðèçîâàíû, âû íå ìîæåòå ïîëüçîâàòüñÿ ïðèâåëåãèÿìè.");
- if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 1) SendClientMessage(playerid, COLOR_YELLOW, "Âû íå çàêîí÷èëè öåïî÷êó îáó÷àþùåãî êâåñòà, Âû ìîæåòå ïðîäîëæèòü åãî, îòïðàâèâøèñü íà êðàñíûé ìàðêåð!");
- if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 3) SendClientMessage(playerid, COLOR_YELLOW, "Âû íå çàêîí÷èëè öåïî÷êó îáó÷àþùåãî êâåñòà, Âû ìîæåòå ïðîäîëæèòü åãî, îòïðàâèâøèñü íà êðàñíûé ìàðêåð!");
- if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 4) SendClientMessage(playerid, COLOR_YELLOW, "Âû íå çàêîí÷èëè öåïî÷êó îáó÷àþùåãî êâåñòà, Âû ìîæåòå ïðîäîëæèòü åãî, îòïðàâèâøèñü íà êðàñíûé ìàðêåð!");
- if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 6) SendClientMessage(playerid, COLOR_YELLOW, "Âû íå çàêîí÷èëè öåïî÷êó îáó÷àþùåãî êâåñòà, Âû ìîæåòå ïðîäîëæèòü åãî, îòïðàâèâøèñü íà êðàñíûé ìàðêåð!");
- if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 7) SendClientMessage(playerid, COLOR_YELLOW, "Âû íå çàêîí÷èëè öåïî÷êó îáó÷àþùåãî êâåñòà, Âû ìîæåòå ïðîäîëæèòü åãî, îòïðàâèâøèñü íà êðàñíûé ìàðêåð!");
- if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 9) SendClientMessage(playerid, COLOR_YELLOW, "Âû íå çàêîí÷èëè öåïî÷êó îáó÷àþùåãî êâåñòà, Âû ìîæåòå ïðîäîëæèòü åãî, îòïðàâèâøèñü íà êðàñíûé ìàðêåð!");
- if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 10) SendClientMessage(playerid, COLOR_YELLOW, "Âû íå çàêîí÷èëè öåïî÷êó îáó÷àþùåãî êâåñòà, Âû ìîæåòå ïðîäîëæèòü åãî, îòïðàâèâøèñü íà êðàñíûé ìàðêåð!");
- if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 12) SendClientMessage(playerid, COLOR_YELLOW, "Âû íå çàêîí÷èëè öåïî÷êó îáó÷àþùåãî êâåñòà, Âû ìîæåòå ïðîäîëæèòü åãî, îòïðàâèâøèñü íà êðàñíûé ìàðêåð!");
- }
- case 4:
- {
- if(!f) return SendClientMessage(playerid, COLOR_SYSTEM, "[ MySQL ] Àêêàóíò íå íàéäåí â áàçå äàííûõ.");
- new str[1024], minags[128];
- new level,exp,viprank,warn,number,money,bank, leader,member,rank,job,jobskin,skin[3],pvip[16],house, car,biz,masterskaya,ipk[16],regip[16],refer[24];
- BaseGetInt("pLevel", level); BaseGetInt("pExp", exp); BaseGetInt("pDonateRank", viprank); BaseGetInt("pWarns", warn);
- BaseGetInt("pPnumber", number); BaseGetInt("pCash", money); BaseGetInt("pBank", bank); BaseGetInt("pLeader", leader); BaseGetInt("pMember", member);
- BaseGetInt("pRank", rank); BaseGetInt("pJob", job); BaseGetInt("pChar", skin[0]); BaseGetInt("pChar1", skin[1]); BaseGetInt("pChar2", skin[2]);
- BaseGetInt("pModel", jobskin); BaseGet("pvIp", pvip); BaseGetInt("pPhousekey", house); BaseGetInt("pCar", car); BaseGetInt("pPbiskey", biz); BaseGetInt("pAvtomas", masterskaya);
- BaseGet("pvIp", ipk); BaseGet("pvIp", ipk); BaseGet("pIpReg", regip); BaseGet("pDrug", refer);
- str="\n";
- format(minags,sizeof(minags),"Name: \t\t%s\n\nLevel: \t\t%d\nExp: \t\t%d\n",name,level,exp); strcat(str,minags);
- format(minags,sizeof(minags),"Vip: \t\t\t%d\nWarns: \t\t%d\nPhone: \t\t%d\n",viprank,warn,number); strcat(str,minags);
- format(minags,sizeof(minags),"Money: \t\t%d\nBank: \t\t%d\nLeader: \t\t%d\n",money,bank,leader); strcat(str,minags);
- format(minags,sizeof(minags),"Member: \t\t%d\nRank: \t\t%d\nJob: \t\t%d\n",member,rank,job); strcat(str,minags);
- format(minags,sizeof(minags),"Skin 1: \t\t%d\nSkin 2: \t\t%d\nSkin 3: \t\t%d\n",skin[0],skin[1],skin[2]); strcat(str,minags);
- format(minags,sizeof(minags),"JobSkin: \t\t%d\nHouse: \t\t%d\nCar: \t\t%d\n",jobskin,house,car); strcat(str,minags);
- format(minags,sizeof(minags),"Biz: \t\t\t%d\nTune: \t\t%d\nsuperKeyIP: \t%s\n",biz, masterskaya, pvip); strcat(str,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(str,minags);
- strcat(str,"\n{FF6347}* superKeyIP - ê êîòîðîìó ïðèâÿçàí àêê\nÅñëè superKeyIP è L-IP íå ðàâíû,\nòî êòî-òî ïûòàëñÿ âîéòè â àêêàóíò,\níåçíàÿ ñóïåð êëþ÷à");
- ShowPlayerDialogEx(playerid,22815,DIALOG_STYLE_MSGBOX,"OFFLINE Ñòàòèñòèêà ïåðñîíàæà",str,"Ãîòîâî","");
- }
- case 5:
- {
- new data[32], query[132];
- if(f)
- {
- if(parametr == 0)
- {
- format(query, sizeof(query), "DELETE FROM "TABLE_ADMIN" WHERE `Name`='%s'", name);
- mysql_empty(connects,query);
- format(query, sizeof(query), "UPDATE accounts SET pAdmin = '0' WHERE name = '%s'", name);
- mysql_empty(connects,query);
- SendMes(playerid, COLOR_YELLOW, "Âû óñïåøíî óäàëèëè %s èç ñïèñêà ìîäåðàòîðîâ", name);
- }
- else
- {
- format(query, sizeof(query), "UPDATE "TABLE_ADMIN" SET level = '%d' WHERE Name = '%s' LIMIT 1", parametr,name);
- mysql_empty(connects,query);
- SendMes(playerid, COLOR_YELLOW, "Âû èçìåíèëè ìîäåðàòîðà %s íà óðîâåíü %d", name, parametr);
- }
- }
- else
- {
- new year, month,day;
- getdate(year, month, day);
- format(data, 32, "%02d.%02d.%04d", year, month, day);
- format(query, 512, "INSERT INTO "TABLE_ADMIN" (Name, level, LastCon) VALUES ('%s', %d, '%s')", name, parametr, data);
- mysql_empty(connects,query);
- SendMes(playerid, COLOR_YELLOW, "Â ñïèñîê ìîäåðàòîðîâ óñïåøíî äîáàâëåí %s, óðîâåíü ìîäåðèðîâàíèÿ %d", name, parametr);
- }
- }
- case 6:
- {
- if(f)
- {
- new geton[62];
- BaseGet("pOnline",geton);
- format(YCMDstr, sizeof(YCMDstr), "Íèê: %s | Ïîñëåäíèé âõîä: %s",name,geton);
- SendClientMessage(playerid, 0x6495EDFF, YCMDstr);
- }
- else SendClientMessage(playerid, COLOR_GRAD1,"Àêêàóíò íå íàéäåí â áàçå äàííûõ");
- }
- case 7:
- {
- new Names[MAX_PLAYER_NAME];
- if(f)
- {
- BaseGet("Name",Names);
- format(YCMDstr, sizeof(YCMDstr), "Íèê: %s | Ôðàêöèÿ ID: %d",Names,parametr);
- SendClientMessage(playerid, 0x6495EDFF, YCMDstr);
- }
- else SendClientMessage(playerid, COLOR_GRAD1,"Íå íàéäåíî ñîâïàäåíèé");
- }
- case 8:
- {
- if(!f)
- {
- SendClientMessage(playerid, COLOR_WHITE, "Âû íå àäìèíèñòðàòîð!");
- if(PlayerInfo[playerid][pAdmin] > 0) PlayerInfo[playerid][pAdmin] = 0;
- return 1;
- }
- new Password[32];
- cache_get_field_content(0, "password", Password, connects);
- if(!strcmp(Password,"qwerty",true)) SetPVarInt(playerid, "aLogin", 1), ShowPlayerDialogEx(playerid,1227,DIALOG_STYLE_PASSWORD, "{FF6F00}Àäìèí ðåãèñòðàöèÿ", "{FFFFFF}Ââåäèòå ïàðîëü\n\nÏàðîëü äîëæåí ñîñòîÿòü èç ëàòèíñêèõ áóêâ è öèôð\n ðàçìåðîì îò 6 äî 15 ñèìâîëîâ", "Âõîä", "Îòìåíà");
- else SetPVarInt(playerid, "aLogin", 2), ShowPlayerDialogEx(playerid,1227,DIALOG_STYLE_PASSWORD, "{FF6F00}Àäìèí àâòîðèçàöèÿ", "{FFFFFF}Ââåäèòå ïàðîëü\n\nÏàðîëü äîëæåí ñîñòîÿòü èç ëàòèíñêèõ áóêâ è öèôð\n ðàçìåðîì îò 6 äî 15 ñèìâîëîâ", "Âõîä", "Îòìåíà");
- }
- case 9:
- {
- if(f)
- {
- new ipp[32];
- BaseGet("pIp",ipp);
- format(YCMDstr, sizeof(YCMDstr), "Íèê: %s | IP: %s",name,ipp);
- SendClientMessage(playerid, 0x6495EDFF, YCMDstr);
- }
- else SendClientMessage(playerid, COLOR_GRAD1, "Àêêàóíò íå íàéäåí â áàçå äàííûõ");
- }
- case 10:
- {
- if(f)
- {
- new ipp[32];
- BaseGet("pIpReg",ipp);
- format(YCMDstr, sizeof(YCMDstr), "Íèê: %s | IP ïðè ðåãèñòðàöèè: %s",name,ipp);
- SendClientMessage(playerid, 0x6495EDFF, YCMDstr);
- }
- else SendClientMessage(playerid, COLOR_GRAD1, "Àêêàóíò íå íàéäåí â áàçå äàííûõ");
- }
- case 11:
- {
- new Names[MAX_PLAYER_NAME];
- new OffMembers;
- new Rank;
- new Vxod[32];
- new OnlineLid[32];
- if(f)
- {
- BaseGet("Name",Names);
- BaseGetInt("pLogin",OffMembers);
- BaseGetInt("pRank",Rank);
- BaseGet("pOnline",Vxod);
- BaseGet("pOnlineLid",OnlineLid);
- if(OffMembers == 0)
- {
- format(YCMDstr, sizeof(YCMDstr), "[%s] [%d] [%s] [%s]",Names,Rank,Vxod,OnlineLid);
- SendClientMessage(playerid, 0x059BD3FF, YCMDstr);
- }
- }
- else SendClientMessage(playerid, COLOR_GRAD1,"Íå íàéäåíî ñîâïàäåíèé");
- }
- case 12:
- {
- if(f)
- {
- new OffMembers;
- BaseGetInt("pMember",OffMembers);
- if(OffMembers == PlayerInfo[playerid][pLeader])
- {
- format(YCMDstr, sizeof(YCMDstr), "UPDATE accounts SET pLeader = '0',pMember = '0',pRank = '0',pJobHealLeader = '0',pJobHeal = '0' WHERE name = '%s'",name);
- mysql_empty(connects,YCMDstr);
- SendClientMessage(playerid,COLOR_GREY,"Èãðîê áûë óâîëåí (Åñëè èãðîê áûë îíëàéí, óâîëüíåíèÿ íå ïðîèçîéäåò)");
- return true;
- }
- else return SendClientMessage(playerid,COLOR_GREY,"Èãðîê íå ñîñòîèò â âàøåé îðãàíèçàöèè");
- }
- else SendClientMessage(playerid, COLOR_GRAD1,"Íå íàéäåíî ñîâïàäåíèé");
- }
- case 13:
- {
- if(f)
- {
- format(YCMDstr, sizeof(YCMDstr), "{B4B5B7}______________________________________\n\n Äîáðî ïîæàëîâàòü íà ñåðâåð "NameServer"{B4B5B7}\n Ýòîò àêêàóíò çàðåãåñòðèðîâàí\n\nËîãèí: {BFC0C2}%s{B4B5B7}\nÂâåäèòå ïàðîëü:\n______________________________________",Name(playerid));
- ShowPlayerDialogEx(playerid,1,DIALOG_STYLE_PASSWORD, "Àâòîðèçàöèÿ",YCMDstr, "Âîéòè", "Îòìåíà");
- }
- else
- {
- format(YCMDstr, sizeof(YCMDstr), "{B4B5B7}______________________________________\n\n Äîáðî ïîæàëîâàòü íà ñåðâåð "NameServer"{B4B5B7}\n Ðåãèñòðàöèÿ íîâîãî ïåðñîíàæà\n\nËîãèí: {BFC0C2}%s{B4B5B7}\nÂâåäèòå ïàðîëü:\n______________________________________",Name(playerid));
- ShowPlayerDialogEx(playerid,2,DIALOG_STYLE_INPUT, "Ðåãèñòðàöèÿ",YCMDstr, "Ãîòîâî", "Îòìåíà");
- }
- }
- case 14:
- {
- if(f) return SendClientMessage(parametr,COLOR_RED,"Äàííûé íèê óæå åñòü â áàçå äàííûõ"), SendClientMessage(playerid,COLOR_RED,"Íåâîçìîæíî ñìåíèòü íèê. Íèê çàíÿò");
- SendClientMessage(parametr,COLOR_GREEN, "Âàø íèê áûë îäîáðåí");
- nick[parametr] = 1;
- ChangeName(parametr, WantNickChange[parametr]);
- }
- case 15:
- {
- if(f)
- {
- #define i parametr
- new string[144];
- if(IsPlayerConnected(GetPlayerID(BizzInfo[i][bNameStavka]))) PlayerInfo[GetPlayerID(BizzInfo[i][bNameStavka])][pPbiskey] = i, SendClientMessage(GetPlayerID(BizzInfo[i][bNameStavka]),COLOR_WHITE,"Âû ïðèîáðåëè áèçíåñ ñ àóêöèîíà. Óïðàâëåíèå: /mm => Êîìàíäû");
- else format(string, sizeof(string), "UPDATE accounts SET pPbiskey = %d, pText = 6 WHERE name = '%s'",i,BizzInfo[i][bNameStavka]), mysql_empty(connects,string);
- BizzInfo[i][bOwned] = 1;
- BizzInfo[i][bLocked] = 0;
- BizzInfo[i][bPrice] = 100;
- BizzInfo[i][bTill] = BizzInfo[i][bMinStavka];
- BizzInfo[i][b2Till] = 0;
- BizzInfo[i][bLicense] = 0;
- BizzInfo[i][bStavka] = 0;
- BizzInfo[i][bMinStavka] = 0;
- BizzInfo[i][bTimeStavka] = 0;
- BizzInfo[i][bLastStavka] = 0;
- if(BizzInfo[i][bType] != 4) BizzInfo[i][bProducts] = 2000;
- else BizzInfo[i][bProducts] = 20000;
- BizzInfo[i][bEntranceCost] = 100;
- strmid(BizzInfo[i][bOwner],BizzInfo[i][bNameStavka], 0, strlen(BizzInfo[i][bNameStavka]), 32);
- strmid(BizzInfo[i][bNameStavka], "-", 0, strlen("-"), 10);
- if(BizzInfo[i][bType] != 4) format(string,sizeof(string), "%s\nÂëàäåëåö: %s", BizzInfo[i][bMessage], BizzInfo[i][bOwner]);
- else format(string,sizeof(string), "%s\nÂëàäåëåö:\n %s\nÖåíà çà 1 ëèòð: %d âèðò", BizzInfo[i][bMessage], BizzInfo[i][bOwner], BizzInfo[i][bPrice]);
- Update3DTextLabelText(BizzInfo[i][bLabel], 0x00D900FF, string);
- SaveBizz(i);
- #undef i
- }
- }
- case 16:
- {
- if(f)
- {
- new Nick[50];
- BaseGet("pDrug",Nick);
- format(YCMDstr, sizeof(YCMDstr), "UPDATE accounts SET pCash = pCash + 100000, pText = '3' WHERE name = '%s'",Nick);
- mysql_empty(connects,YCMDstr);
- }
- }
- case dWrongPass:
- {
- if(f) return OnPlayerLoginToServer(playerid);
- new string[144];
- if(GetPVarInt(playerid, "wrongPass") == 3) return SendClientMessage(playerid,COLOR_LIGHTRED,"Íåâåðíûé ïàðîëü. Èñïîëüçóéòå /q äëÿ âûõîäà."), Kick(playerid);
- SetPVarInt(playerid, "wrongPass", GetPVarInt(playerid, "wrongPass")+1);
- format(string,sizeof(string), "{FF6347}Âíèìàíèå!Âû ââåëè íåâåðíûé ïàðîëü!\n\tÓ âàñ îñòàëîñü(%d) ïîïûòêè\nÏîñëå âû áóäåòå íà âðåìÿ çàáàíåíû",3-GetPVarInt(playerid, "wrongPass"));
- ShowPlayerDialogEx(playerid,1,DIALOG_STYLE_MSGBOX, "Îøèáêà!",string, "Ïîâòîð", "Âûéòè");
- }
- case 18:
- {
- if(!f) return 1;
- #define i parametr
- AvtoInfo[i][abID] = cache_get_field_content_int(i, "abID", connects);
- AvtoInfo[i][abEntranceX] = cache_get_field_content_float(i, "abEntranceX", connects);
- AvtoInfo[i][abEntranceY] = cache_get_field_content_float(i, "abEntranceY", connects);
- AvtoInfo[i][abEntranceZ] = cache_get_field_content_float(i, "abEntranceZ", connects);
- cache_get_field_content(i, "abOwner", AvtoInfo[i][abOwner], connects, strlen(AvtoInfo[i][abOwner]));
- AvtoInfo[i][abOwned] = cache_get_field_content_int(i, "abOwned", connects);
- AvtoInfo[i][abPriceProds] = cache_get_field_content_int(i, "abPriceProds", connects);
- cache_get_field_content(i, "abZam1", AvtoInfo[i][abZam1], connects, strlen(AvtoInfo[i][abZam1]));
- cache_get_field_content(i, "abZam2", AvtoInfo[i][abZam2], connects, strlen(AvtoInfo[i][abZam2]));
- cache_get_field_content(i, "abZam3", AvtoInfo[i][abZam3], connects, strlen(AvtoInfo[i][abZam3]));
- cache_get_field_content(i, "abMechanic1", AvtoInfo[i][abMechanic1], connects, strlen(AvtoInfo[i][abMechanic1]));
- cache_get_field_content(i, "abMechanic2", AvtoInfo[i][abMechanic2], connects, strlen(AvtoInfo[i][abMechanic2]));
- cache_get_field_content(i, "abMechanic3", AvtoInfo[i][abMechanic3], connects, strlen(AvtoInfo[i][abMechanic3]));
- cache_get_field_content(i, "abMechanic4", AvtoInfo[i][abMechanic4], connects, strlen(AvtoInfo[i][abMechanic4]));
- cache_get_field_content(i, "abMechanic5", AvtoInfo[i][abMechanic5], connects, strlen(AvtoInfo[i][abMechanic5]));
- AvtoInfo[i][abZp] = cache_get_field_content_int(i, "abZp", connects);
- AvtoInfo[i][abProds] = cache_get_field_content_int(i, "abProds", connects);
- AvtoInfo[i][abLandTax] = cache_get_field_content_int(i, "abLandTax", connects);
- AvtoInfo[i][abBank] = cache_get_field_content_int(i, "abBank", connects);
- AvtoInfo[i][abWorld] = cache_get_field_content_int(i, "abWorld", connects);
- #undef i
- }
- default: return 1;
- }
- return 1;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement