Advertisement
Guest User

Untitled

a guest
Feb 9th, 2016
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 34.22 KB | None | 0 0
  1. publics:MysqlType(playerid, type, name[], parametr)
  2. {
  3. new f,g;
  4. cache_get_data(f,g);
  5. switch(type)
  6. {
  7. case 1:
  8. {
  9. if(f)
  10. {
  11. new string[128];
  12. format(string, sizeof(string), "UPDATE accounts SET pBank = pBank + %d WHERE name = '%s'",BizzInfo[bizselect[playerid]][bLastStavka],BizzInfo[bizselect[playerid]][bNameStavka]);
  13. mysql_empty(connects,string);
  14. }
  15. }
  16. case 2:
  17. {
  18. if(!f)
  19. {
  20. SendClientMessage(playerid,COLOR_GREY,"Àêêàóíò íå íàéäåí");
  21. ShowPlayerDialogEx(playerid,2625,DIALOG_STYLE_INPUT, "Ïî ïðèãëàøåíèþ îò:", "Ââåäèòå íèê èãðîêà, ïðèãëàñèâøèãî âàñ íà ñåðâåð", "Äàëåå", "Ïðîïóñê");
  22. return 1;
  23. }
  24. strmid(PlayerInfo[playerid][pDrug], name, 0, strlen(name), strlen(name)+5);
  25. }
  26. case 3:
  27. {
  28. new tmp2[256], string[500];
  29. new playername2[MAX_PLAYER_NAME];
  30. if(f)
  31. {
  32. BaseGetInt("pID", PlayerIDs[playerid]); BaseGetInt("pLevel", PlayerInfo[playerid][pLevel]); BaseGetInt("pPhousekey", PlayerInfo[playerid][pPhousekey]);
  33. BaseGetInt("pPbiskey", PlayerInfo[playerid][pPbiskey]); BaseGetInt("pAdmin", PlayerInfo[playerid][pAdmin]); BaseGetInt("pHelper", PlayerInfo[playerid][pHelper]);
  34. BaseGetInt("pForma", PlayerInfo[playerid][pForma]); BaseGetInt("pJobHeal", PlayerInfo[playerid][pJobHeal]); BaseGetInt("pJobHealLeader", PlayerInfo[playerid][pJobHealLeader]);
  35. BaseGetFloat("pFuelcar", PlayerInfo[playerid][pFuelcar]); BaseGetInt("pText", PlayerInfo[playerid][pText]); BaseGetInt("pPodarok1", PlayerInfo[playerid][pPodarok][0]);
  36. BaseGetInt("pPodarok2", PlayerInfo[playerid][pPodarok][1]); BaseGetInt("pHP", PlayerInfo[playerid][pHP]); BaseGetInt("pSatiety", PlayerInfo[playerid][pSatiety]);
  37. BaseGet("pKeyip", PlayerInfo[playerid][pKeyip]); BaseGet("pEmail", PlayerInfo[playerid][pEmail]); BaseGetInt("pCheckip", PlayerInfo[playerid][pCheckip]);
  38. BaseGetInt("pReg", PlayerInfo[playerid][pReg]); BaseGetInt("pTut", PlayerInfo[playerid][pTut]); BaseGetInt("pGod", PlayerInfo[playerid][pGod]);
  39. BaseGetInt("pMes", PlayerInfo[playerid][pMes]); BaseGet("pDataReg", PlayerInfo[playerid][pDataReg]); BaseGetInt("pVhoddata", PlayerInfo[playerid][pVhoddata]);
  40. BaseGetInt("pVhodMes", PlayerInfo[playerid][pVhodMes]); BaseGetInt("pVhodchas", PlayerInfo[playerid][pVhodchas]); BaseGetInt("pVhodminute", PlayerInfo[playerid][pVhodminute]);
  41. BaseGetInt("pPhoneBook", PlayerInfo[playerid][pPhoneBook]); BaseGetInt("pDirectory", PlayerInfo[playerid][pDirectory]); BaseGetInt("pIphone", PlayerInfo[playerid][pIphone]);
  42. BaseGetInt("pGrant", PlayerInfo[playerid][pGrant]); BaseGetInt("pKvestTeach", PlayerInfo[playerid][pKvestTeach]); BaseGetInt("pDoneKvestTeach", PlayerInfo[playerid][pDoneKvestTeach]); BaseGetInt("pAlcoholPerk", PlayerInfo[playerid][pAlcoholPerk]);
  43. BaseGet("pIp", PlayerInfo[playerid][pIp]); BaseGet("pvIp", PlayerInfo[playerid][pvIp]); BaseGet("pIpReg", PlayerInfo[playerid][pIpReg]);
  44. BaseGetInt("pCar", PlayerInfo[playerid][pCar]); BaseGetInt("pDonatechet", PlayerInfo[playerid][pDonatechet]); BaseGetInt("pDonatemoney", PlayerInfo[playerid][pDonatemoney]);
  45. BaseGetInt("pDonateRank", PlayerInfo[playerid][pDonateRank]); BaseGetInt("pSex", PlayerInfo[playerid][pSex]); BaseGetInt("pArrested", PlayerInfo[playerid][pArrested]);
  46. BaseGetInt("pMuted", PlayerInfo[playerid][pMuted]); BaseGetInt("pCrimes", PlayerInfo[playerid][pCrimes]); BaseGetInt("pExp", PlayerInfo[playerid][pExp]);
  47. BaseGetInt("pCash", PlayerInfo[playerid][pCash]); BaseGetInt("pKills", PlayerInfo[playerid][pKills]); BaseGetInt("pDeaths", PlayerInfo[playerid][pDeaths]);
  48. BaseGetInt("pPayCheck", PlayerInfo[playerid][pPayCheck]); BaseGetInt("pJailed", PlayerInfo[playerid][pJailed]); BaseGetInt("pCheat", PlayerInfo[playerid][pCheat]);
  49. BaseGetInt("pJailTime", PlayerInfo[playerid][pJailTime]); BaseGetInt("pMats", PlayerInfo[playerid][pMats]); BaseGetInt("pDrugs", PlayerInfo[playerid][pDrugs]);
  50. BaseGetInt("pLeader", PlayerInfo[playerid][pLeader]); BaseGetInt("pMember", PlayerInfo[playerid][pMember]); BaseGetInt("pRank", PlayerInfo[playerid][pRank]);
  51. BaseGetInt("pJob", PlayerInfo[playerid][pJob]); BaseGetInt("pCarLic", PlayerInfo[playerid][pCarLic]); BaseGetInt("pBizLic", PlayerInfo[playerid][pBizLic]);
  52. BaseGetInt("pFlyLic", PlayerInfo[playerid][pFlyLic]); BaseGetInt("pBoatLic", PlayerInfo[playerid][pBoatLic]); BaseGetInt("pFishLic", PlayerInfo[playerid][pFishLic]);
  53. BaseGetInt("pGunLic", PlayerInfo[playerid][pGunLic]); BaseGetInt("pSlot1", PlayerInfo[playerid][pSlot1]); BaseGetInt("pSlot2", PlayerInfo[playerid][pSlot2]);
  54. BaseGetInt("pSlot3", PlayerInfo[playerid][pSlot3]); BaseGetInt("pSlot4", PlayerInfo[playerid][pSlot4]); BaseGetInt("pSlot5", PlayerInfo[playerid][pSlot5]);
  55. BaseGetInt("pSlot6", PlayerInfo[playerid][pSlot6]); BaseGetInt("pSlot7", PlayerInfo[playerid][pSlot7]); BaseGetInt("pSlot8", PlayerInfo[playerid][pSlot8]);
  56. BaseGetInt("pSlot9", PlayerInfo[playerid][pSlot9]); BaseGetInt("pSlot10", PlayerInfo[playerid][pSlot10]); BaseGetInt("pSlot11", PlayerInfo[playerid][pSlot11]);
  57. BaseGetInt("pSlotammo1", PlayerInfo[playerid][pSlotammo1]); BaseGetInt("pSlotammo2", PlayerInfo[playerid][pSlotammo2]); BaseGetInt("pSlotammo3", PlayerInfo[playerid][pSlotammo3]);
  58. BaseGetInt("pSlotammo4", PlayerInfo[playerid][pSlotammo4]); BaseGetInt("pSlotammo5", PlayerInfo[playerid][pSlotammo5]); BaseGetInt("pSlotammo6", PlayerInfo[playerid][pSlotammo6]);
  59. BaseGetInt("pSlotammo7", PlayerInfo[playerid][pSlotammo7]); BaseGetInt("pSlotammo8", PlayerInfo[playerid][pSlotammo8]); BaseGetInt("pSlotammo9", PlayerInfo[playerid][pSlotammo9]);
  60. BaseGetInt("pSlotammo10", PlayerInfo[playerid][pSlotammo10]); BaseGetInt("pSlotammo11", PlayerInfo[playerid][pSlotammo11]); BaseGetInt("pGunSkill1", PlayerInfo[playerid][pGunSkill][0]);
  61. BaseGetInt("pGunSkill2", PlayerInfo[playerid][pGunSkill][1]); BaseGetInt("pGunSkill3", PlayerInfo[playerid][pGunSkill][2]); BaseGetInt("pGunSkill4", PlayerInfo[playerid][pGunSkill][3]);
  62. BaseGetInt("pGunSkill5", PlayerInfo[playerid][pGunSkill][4]); BaseGetInt("pGunSkill6", PlayerInfo[playerid][pGunSkill][5]); BaseGetInt("ptaxiexp", PlayerInfo[playerid][ptaxiexp]);
  63. BaseGetInt("ptaxilvl", PlayerInfo[playerid][ptaxilvl]); BaseGetInt("pDLevel", PlayerInfo[playerid][pDLevel]); BaseGetInt("pDExp", PlayerInfo[playerid][pDExp]);
  64. BaseGetInt("pDMgruz", PlayerInfo[playerid][pDMgruz]); BaseGetInt("pDgruz", PlayerInfo[playerid][pDgruz]); BaseGetInt("pKazpay", PlayerInfo[playerid][pKazpay]);
  65. BaseGetInt("pChar", PlayerInfo[playerid][pChar][0]); BaseGetInt("pChar1", PlayerInfo[playerid][pChar][1]); BaseGetInt("pChar2", PlayerInfo[playerid][pChar][2]);
  66. BaseGetInt("pViborChar", PlayerInfo[playerid][pViborChar]); BaseGetFloat("pSHealth", PlayerInfo[playerid][pSHealth]); BaseGetFloat("pHealth", PlayerInfo[playerid][pHealth]);
  67. BaseGetInt("pInt", PlayerInfo[playerid][pInt]); BaseGetInt("pLocal", PlayerInfo[playerid][pLocal]); BaseGetInt("pModel", PlayerInfo[playerid][pModel]);
  68. BaseGetInt("pPnumber", PlayerInfo[playerid][pPnumber]); BaseGetInt("pPayDay", PlayerInfo[playerid][pPayDay]); BaseGetInt("pPayDayHad", PlayerInfo[playerid][pPayDayHad]);
  69. BaseGetInt("pWarns", PlayerInfo[playerid][pWarns]); BaseGetInt("punWarns", PlayerInfo[playerid][punWarns]); BaseGetInt("punWarnstime", PlayerInfo[playerid][punWarnstime]);
  70. BaseGetInt("pFuel", PlayerInfo[playerid][pFuel]); BaseGetInt("pMarried", PlayerInfo[playerid][pMarried]); BaseGet("pDrug", PlayerInfo[playerid][pDrug]);
  71. BaseGet("pMarriedTo", PlayerInfo[playerid][pMarriedTo]); BaseGetInt("pMushrooms", PlayerInfo[playerid][pMushrooms]); BaseGetInt("pMuteTime", PlayerInfo[playerid][pMuteTime]);
  72. BaseGetInt("pMobile", PlayerInfo[playerid][pMobile]); BaseGetInt("pBank", PlayerInfo[playerid][pBank]); BaseGetInt("pLocked", PlayerInfo[playerid][pLocked]);
  73. BaseGetInt("pBanDay", PlayerInfo[playerid][pBanDay]); BaseGetInt("pBanMounth", PlayerInfo[playerid][pBanMounth]); BaseGetInt("pDolg", PlayerInfo[playerid][pDolg]);
  74. BaseGetInt("pKrisha", PlayerInfo[playerid][pKrisha]); BaseGetInt("pUseKrisha", PlayerInfo[playerid][pUseKrisha]); BaseGetInt("pBoxSkill", PlayerInfo[playerid][pBoxSkill]);
  75. BaseGetInt("pKongfuSkill", PlayerInfo[playerid][pKongfuSkill]); BaseGetInt("pKickboxSkill", PlayerInfo[playerid][pKickboxSkill]); BaseGet("pDostup", PlayerInfo[playerid][pDostup]);
  76. BaseGetFloat("pFishes", PlayerInfo[playerid][pFishes]); BaseGetInt("pZakonp", PlayerInfo[playerid][pZakonp]); BaseGetInt("pAddiction", PlayerInfo[playerid][pAddiction]);
  77. BaseGetInt("pNarcoLomka", PlayerInfo[playerid][pNarcoLomka]); BaseGetInt("pProcents", PlayerInfo[playerid][pProcents]); BaseGetInt("pWheels", PlayerInfo[playerid][pWheels]);
  78. BaseGetInt("pPaintJob", PlayerInfo[playerid][pPaintJob]); BaseGetInt("pSpoiler", PlayerInfo[playerid][pSpoiler]); BaseGetInt("pBumper1", PlayerInfo[playerid][pBumper1]);
  79. BaseGetInt("pBumper2", PlayerInfo[playerid][pBumper2]); BaseGetInt("pColor1", PlayerInfo[playerid][pColor][0]); BaseGetInt("pColor2", PlayerInfo[playerid][pColor][1]);
  80. BaseGetInt("pNitro", PlayerInfo[playerid][pNitro]); BaseGetInt("pHydrawlic", PlayerInfo[playerid][pHydrawlic]); BaseGetInt("pAvtomas", PlayerInfo[playerid][pAvtomas]);
  81. BaseGetInt("pMestoJail", PlayerInfo[playerid][pMestoJail]); BaseGetInt("pSong", PlayerInfo[playerid][pSong]); BaseGetInt("pHousecash", PlayerInfo[playerid][pHousecash]);
  82. BaseGetInt("pKvartiraKey", PlayerInfo[playerid][pKvartirakey]); BaseGetInt("pWantedLevel", PlayerInfo[playerid][pWantedLevel]); BaseGetInt("pChas", PlayerInfo[playerid][pChas]);
  83. BaseGetInt("pMin", PlayerInfo[playerid][pMin]); BaseGetInt("pSkilla", PlayerInfo[playerid][pSkilla]); BaseGetInt("pLighter", PlayerInfo[playerid][pLighter]);
  84. BaseGetInt("pCigarettes", PlayerInfo[playerid][pCigarettes]); BaseGetInt("pRecognition", PlayerInfo[playerid][pRecognition]);
  85. BaseGetInt("pRobHouse", PlayerInfo[playerid][pRobHouse]);
  86. BaseGetInt("pRobCar", PlayerInfo[playerid][pRobCar]); BaseGetInt("activate_mail", PlayerInfo[playerid][pActivemail]); BaseGetInt("pFishesPach", PlayerInfo[playerid][pFishesPach]);
  87. }
  88. PlayerInfo[playerid][pLogin] = 1;
  89. format(string, sizeof(string), "UPDATE accounts SET pLogin = '%d' WHERE name = '%s'",PlayerInfo[playerid][pLogin],Name(playerid));
  90. mysql_empty(connects,string);
  91. new current = getdate();
  92. if(PlayerInfo[playerid][pBanMounth] > current && PlayerInfo[playerid][pLocked] == 1)
  93. {
  94. format(string, sizeof(string), "{d95841}Ýòîò àêêàóíò çàáëîêèðîâàí\nÐàçáàí ÷åðåç %d äíåé\n\nÂâåäèòå ''/q'' ÷òîáû âûéòè",PlayerInfo[playerid][pBanMounth]-current);
  95. ShowPlayerDialogEx(playerid,78,0,"{c22000}Âíèìàíèå",string,"Çàêðûòü","");
  96. Kick(playerid);
  97. return 1;
  98. }
  99. else if(PlayerInfo[playerid][pBanMounth] <= current && PlayerInfo[playerid][pLocked] == 1)
  100. {
  101. PlayerInfo[playerid][pLocked] = 0;
  102. PlayerInfo[playerid][pBanMounth] = 0;
  103. PlayerInfo[playerid][pBanDay] = 0;
  104. }
  105. new playersip[40];
  106. GetPlayerIp(playerid,playersip,sizeof(playersip));
  107. if(PlayerInfo[playerid][pCheckip] == 1)
  108. {
  109. if(strcmp(playersip, PlayerInfo[playerid][pIp]) != 0)
  110. {
  111. PlayerInfo[playerid][pLogin] = 0;
  112. format(string, sizeof(string), "UPDATE accounts SET pLogin = '%d' WHERE name = '%s'",PlayerInfo[playerid][pLogin],Name(playerid));
  113. mysql_empty(connects,string);
  114. SetPlayerInterior(playerid, 0);
  115. SetPlayerFacingAngle(playerid, 179.5547);
  116. SetPlayerCameraPos(playerid, 1357.414428,-1450.705322,252.353897);
  117. SetPlayerCameraLookAt(playerid, 1365.318969,-1445.091796,249.903198);
  118. TogglePlayerControllable(playerid, 0);
  119. ShowPlayerDialogEx(playerid,16,DIALOG_STYLE_INPUT, "Ââåäèòå êëþ÷ áåçîïàñíîñòè", " ==== Âàø IP àäðåñ ñìåíèëñÿ ====\n=== Ââåäèòå Âàø êëþ÷ áåçîïàñíîñòè ===", "Ãîòîâî", "Îòìåíà");
  120. PlayerInfo[playerid][pLogin] = 0;
  121. return true;
  122. }
  123. }
  124. if(PlayerInfo[playerid][pCheckip] == 1)
  125. {
  126. PlayerInfo[playerid][pLogin] = 1;
  127. format(string, sizeof(string), "UPDATE accounts SET pLogin = '%d',pvIp = '%s' WHERE name = '%s'",PlayerInfo[playerid][pLogin],playersip,Name(playerid));
  128. mysql_empty(connects,string);
  129. }
  130. if(PlayerInfo[playerid][pCheckip] == 0)
  131. {
  132. GetPlayerIp(playerid,playersip,sizeof(playersip));
  133. PlayerInfo[playerid][pLogin] = 1;
  134. format(string, sizeof(string), "UPDATE accounts SET pLogin = '%d',pIp = '%s',pvIp = '%s' WHERE name = '%s'",PlayerInfo[playerid][pLogin],playersip,playersip,Name(playerid));
  135. mysql_empty(connects,string);
  136. }
  137. FormaFrac[playerid] = PlayerInfo[playerid][pForma];
  138. if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 2) PlayerInfo[playerid][pKvestTeach] = 1;
  139. if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 5) PlayerInfo[playerid][pKvestTeach] = 4;
  140. if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 8) PlayerInfo[playerid][pKvestTeach] = 7;
  141. if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 11) PlayerInfo[playerid][pKvestTeach] = 10;
  142. if(FormaFrac[playerid] != 0 && !IsAGang(playerid) && !IsAMafia(playerid)) SpawnChange[playerid] = 0;
  143. if(PlayerInfo[playerid][pCash] < 0) PlayerInfo[playerid][pCash] = 0;
  144. if(PlayerInfo[playerid][pProcents] <= 3) PlayerInfo[playerid][pProcents] = 4;
  145. if(PlayerInfo[playerid][pChar][PlayerInfo[playerid][pViborChar]] == 0) PlayerInfo[playerid][pChar][PlayerInfo[playerid][pViborChar]] = 230;
  146. if(PlayerInfo[playerid][pAdmin] <= 0) PlayerInfo[playerid][pDostup] = 521957921;
  147. if(PlayerInfo[playerid][pDonateRank] > 0) SendClientMessage(playerid, 0xFEBC41AA, "Çäðàâñòâóéòå VIP èãðîê!"), format(tmp2, sizeof(tmp2), "~w~Welcome ~n~~b~ %s", playername2);
  148. else format(tmp2, sizeof(tmp2), "~w~Welcome ~n~~b~ %s", playername2);
  149. GameTextForPlayer(playerid, tmp2, 5000, 1);
  150. if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 0) SetPlayerCheckpoint(playerid, -1510.5208,921.0080,7.1875, 0.3);
  151. if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 1) SetPlayerCheckpoint(playerid, 616.5748,1191.5874,11.7188, 0.3);
  152. if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 3) SetPlayerCheckpoint(playerid, 616.5748,1191.5874,11.7188, 0.3);
  153. if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 4) SetPlayerCheckpoint(playerid, 662.6733,844.0513,-42.9609, 0.3);
  154. if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 6) SetPlayerCheckpoint(playerid, 662.6733,844.0513,-42.9609, 0.3);
  155. if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 7) SetPlayerCheckpoint(playerid, 2477.0745,1957.6842,10.6088, 0.3);
  156. if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 9) SetPlayerCheckpoint(playerid, 2477.0745,1957.6842,10.6088, 0.3);
  157. if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 10) SetPlayerCheckpoint(playerid, -2038.1396,-103.9433,35.1719, 0.3);
  158. if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 12) SetPlayerCheckpoint(playerid, -2038.1396,-103.9433,35.1719, 0.3);
  159. //if(!PlayerInfo[playerid][pActivemail]) SendClientMessage(playerid,COLOR_WHITE,"Ó âàñ íå ïîäòâåðæäåí {FFFF00}E-mail{ffffff} àäðåñ. Ïîäòâåðäèòü {FFFF00}E-mail{ffffff} âû ìîæåòå íà ñàéòå: {FFFF00}"NameSite"");
  160. if (PlayerInfo[playerid][pText] == 6) SendClientMessage(playerid, COLOR_WHITE, "Âû ïðèîáðåëè áèçíåñ ñ àóêöèîíà. Óïðàâëåíèå:{FFFF00} /mm - [3] Êîìàíäû ñåðâåðà"), PlayerInfo[playerid][pText] = 0;
  161. if (PlayerInfo[playerid][pText] == 4) SendClientMessage(playerid, COLOR_WHITE, "Ñ Âàñ áûëà ñíÿòà ëèäåðêà îðãàíèçàöèè"), PlayerInfo[playerid][pText] = 0;
  162. if (PlayerInfo[playerid][pText] == 5) SendClientMessage(playerid, COLOR_WHITE, "Âàøà àâòîìàñòåðñêàÿ áûëà ïðîäàíà ãîñóäàðñòâó. Ïîëîâèíà ñòîèìîñòè çà÷èñëåíà íà âàø ñ÷åò"), PlayerInfo[playerid][pText] = 0;
  163. if (PlayerInfo[playerid][pText] == 3) PlayerInfo[playerid][pText] = 0, SendClientMessage(playerid, COLOR_WHITE, "Âû ïîëó÷èëè 100 000 âèðò íà áàíêîâñêèé ñ÷åò, çà ïðèãëàø¸ííîãî äðóãà");
  164. if (PlayerInfo[playerid][pText] == 1) SendClientMessage(playerid, COLOR_LIGHTRED, "Âû áûëè âûñåëåíû çà íåóïëàòó êâàðòïëàòû"), SendClientMessage(playerid, COLOR_LIGHTRED, "Äåíüãè çà äîì âû ìîæåòå ïîëó÷èòü â áàíêå \"/GetHouseMoney\"");
  165. if (PlayerInfo[playerid][pText] == 2) SendClientMessage(playerid, COLOR_YELLOW, "Âàø áèçíåñ áûë ïðîäàí ãîñóäàðñòâó çà ïðîñòîé ãîñóäàðñòâó. Ïîëîâèíà ñòîèìîñòè çà÷èñëåíà íà âàø áàíêîâñêèé ñ÷åò"), PlayerInfo[playerid][pText] = 0;
  166. if(PlayerInfo[playerid][pPhousekey] != 999)
  167. {
  168. new house = PlayerInfo[playerid][pPhousekey];
  169. createdcar = caridhouse[playerid];
  170. 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);
  171. createdcar ++;
  172. LockCar(caridhouse[playerid]);
  173. Fuell[caridhouse[playerid]] = PlayerInfo[playerid][pFuelcar];
  174. CompVeh(playerid,caridhouse[playerid]);
  175. }
  176. PEfir[playerid] = 255;
  177. Pefir[playerid] = 999;
  178. SpawnPlayer(playerid);
  179. InitLockDoors(playerid);
  180. GangZoneShowForPlayer(playerid, Army, COLOR_YELLOW2);
  181. SetPlayerHealthAC(playerid, PlayerInfo[playerid][pHP]);
  182. ResetPlayerMoney(playerid);
  183. OnPlayerUpdateAc(playerid);
  184. printf("Login");
  185. if(PlayerInfo[playerid][pAdmin] >= 1) SendClientMessage(playerid,COLOR_WHITE,"Âû âîøëè êàê àäìèíèñòðàòîð. Äëÿ àâòîðèçàöèè, ââåäèòå {FFFF00}\"/alogin\""), SendClientMessage(playerid,COLOR_WHITE,"Ïîêà âû íå àâòîðèçîâàíû, âû íå ìîæåòå ïîëüçîâàòüñÿ ïðèâåëåãèÿìè.");
  186. if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 1) SendClientMessage(playerid, COLOR_YELLOW, "Âû íå çàêîí÷èëè öåïî÷êó îáó÷àþùåãî êâåñòà, Âû ìîæåòå ïðîäîëæèòü åãî, îòïðàâèâøèñü íà êðàñíûé ìàðêåð!");
  187. if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 3) SendClientMessage(playerid, COLOR_YELLOW, "Âû íå çàêîí÷èëè öåïî÷êó îáó÷àþùåãî êâåñòà, Âû ìîæåòå ïðîäîëæèòü åãî, îòïðàâèâøèñü íà êðàñíûé ìàðêåð!");
  188. if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 4) SendClientMessage(playerid, COLOR_YELLOW, "Âû íå çàêîí÷èëè öåïî÷êó îáó÷àþùåãî êâåñòà, Âû ìîæåòå ïðîäîëæèòü åãî, îòïðàâèâøèñü íà êðàñíûé ìàðêåð!");
  189. if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 6) SendClientMessage(playerid, COLOR_YELLOW, "Âû íå çàêîí÷èëè öåïî÷êó îáó÷àþùåãî êâåñòà, Âû ìîæåòå ïðîäîëæèòü åãî, îòïðàâèâøèñü íà êðàñíûé ìàðêåð!");
  190. if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 7) SendClientMessage(playerid, COLOR_YELLOW, "Âû íå çàêîí÷èëè öåïî÷êó îáó÷àþùåãî êâåñòà, Âû ìîæåòå ïðîäîëæèòü åãî, îòïðàâèâøèñü íà êðàñíûé ìàðêåð!");
  191. if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 9) SendClientMessage(playerid, COLOR_YELLOW, "Âû íå çàêîí÷èëè öåïî÷êó îáó÷àþùåãî êâåñòà, Âû ìîæåòå ïðîäîëæèòü åãî, îòïðàâèâøèñü íà êðàñíûé ìàðêåð!");
  192. if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 10) SendClientMessage(playerid, COLOR_YELLOW, "Âû íå çàêîí÷èëè öåïî÷êó îáó÷àþùåãî êâåñòà, Âû ìîæåòå ïðîäîëæèòü åãî, îòïðàâèâøèñü íà êðàñíûé ìàðêåð!");
  193. if(PlayerInfo[playerid][pLevel] < 2 && PlayerInfo[playerid][pKvestTeach] == 12) SendClientMessage(playerid, COLOR_YELLOW, "Âû íå çàêîí÷èëè öåïî÷êó îáó÷àþùåãî êâåñòà, Âû ìîæåòå ïðîäîëæèòü åãî, îòïðàâèâøèñü íà êðàñíûé ìàðêåð!");
  194. }
  195. case 4:
  196. {
  197. if(!f) return SendClientMessage(playerid, COLOR_SYSTEM, "[ MySQL ] Àêêàóíò íå íàéäåí â áàçå äàííûõ.");
  198. new str[1024], minags[128];
  199. 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];
  200. BaseGetInt("pLevel", level); BaseGetInt("pExp", exp); BaseGetInt("pDonateRank", viprank); BaseGetInt("pWarns", warn);
  201. BaseGetInt("pPnumber", number); BaseGetInt("pCash", money); BaseGetInt("pBank", bank); BaseGetInt("pLeader", leader); BaseGetInt("pMember", member);
  202. BaseGetInt("pRank", rank); BaseGetInt("pJob", job); BaseGetInt("pChar", skin[0]); BaseGetInt("pChar1", skin[1]); BaseGetInt("pChar2", skin[2]);
  203. BaseGetInt("pModel", jobskin); BaseGet("pvIp", pvip); BaseGetInt("pPhousekey", house); BaseGetInt("pCar", car); BaseGetInt("pPbiskey", biz); BaseGetInt("pAvtomas", masterskaya);
  204. BaseGet("pvIp", ipk); BaseGet("pvIp", ipk); BaseGet("pIpReg", regip); BaseGet("pDrug", refer);
  205. str="\n";
  206. format(minags,sizeof(minags),"Name: \t\t%s\n\nLevel: \t\t%d\nExp: \t\t%d\n",name,level,exp); strcat(str,minags);
  207. format(minags,sizeof(minags),"Vip: \t\t\t%d\nWarns: \t\t%d\nPhone: \t\t%d\n",viprank,warn,number); strcat(str,minags);
  208. format(minags,sizeof(minags),"Money: \t\t%d\nBank: \t\t%d\nLeader: \t\t%d\n",money,bank,leader); strcat(str,minags);
  209. format(minags,sizeof(minags),"Member: \t\t%d\nRank: \t\t%d\nJob: \t\t%d\n",member,rank,job); strcat(str,minags);
  210. 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);
  211. format(minags,sizeof(minags),"JobSkin: \t\t%d\nHouse: \t\t%d\nCar: \t\t%d\n",jobskin,house,car); strcat(str,minags);
  212. format(minags,sizeof(minags),"Biz: \t\t\t%d\nTune: \t\t%d\nsuperKeyIP: \t%s\n",biz, masterskaya, pvip); strcat(str,minags);
  213. 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);
  214. strcat(str,"\n{FF6347}* superKeyIP - ê êîòîðîìó ïðèâÿçàí àêê\nÅñëè superKeyIP è L-IP íå ðàâíû,\nòî êòî-òî ïûòàëñÿ âîéòè â àêêàóíò,\níåçíàÿ ñóïåð êëþ÷à");
  215. ShowPlayerDialogEx(playerid,22815,DIALOG_STYLE_MSGBOX,"OFFLINE Ñòàòèñòèêà ïåðñîíàæà",str,"Ãîòîâî","");
  216. }
  217. case 5:
  218. {
  219. new data[32], query[132];
  220. if(f)
  221. {
  222. if(parametr == 0)
  223. {
  224. format(query, sizeof(query), "DELETE FROM "TABLE_ADMIN" WHERE `Name`='%s'", name);
  225. mysql_empty(connects,query);
  226. format(query, sizeof(query), "UPDATE accounts SET pAdmin = '0' WHERE name = '%s'", name);
  227. mysql_empty(connects,query);
  228. SendMes(playerid, COLOR_YELLOW, "Âû óñïåøíî óäàëèëè %s èç ñïèñêà ìîäåðàòîðîâ", name);
  229. }
  230. else
  231. {
  232. format(query, sizeof(query), "UPDATE "TABLE_ADMIN" SET level = '%d' WHERE Name = '%s' LIMIT 1", parametr,name);
  233. mysql_empty(connects,query);
  234. SendMes(playerid, COLOR_YELLOW, "Âû èçìåíèëè ìîäåðàòîðà %s íà óðîâåíü %d", name, parametr);
  235. }
  236. }
  237. else
  238. {
  239. new year, month,day;
  240. getdate(year, month, day);
  241. format(data, 32, "%02d.%02d.%04d", year, month, day);
  242. format(query, 512, "INSERT INTO "TABLE_ADMIN" (Name, level, LastCon) VALUES ('%s', %d, '%s')", name, parametr, data);
  243. mysql_empty(connects,query);
  244. SendMes(playerid, COLOR_YELLOW, "Â ñïèñîê ìîäåðàòîðîâ óñïåøíî äîáàâëåí %s, óðîâåíü ìîäåðèðîâàíèÿ %d", name, parametr);
  245. }
  246. }
  247. case 6:
  248. {
  249. if(f)
  250. {
  251. new geton[62];
  252. BaseGet("pOnline",geton);
  253. format(YCMDstr, sizeof(YCMDstr), "Íèê: %s | Ïîñëåäíèé âõîä: %s",name,geton);
  254. SendClientMessage(playerid, 0x6495EDFF, YCMDstr);
  255. }
  256. else SendClientMessage(playerid, COLOR_GRAD1,"Àêêàóíò íå íàéäåí â áàçå äàííûõ");
  257. }
  258. case 7:
  259. {
  260. new Names[MAX_PLAYER_NAME];
  261. if(f)
  262. {
  263. BaseGet("Name",Names);
  264. format(YCMDstr, sizeof(YCMDstr), "Íèê: %s | Ôðàêöèÿ ID: %d",Names,parametr);
  265. SendClientMessage(playerid, 0x6495EDFF, YCMDstr);
  266. }
  267. else SendClientMessage(playerid, COLOR_GRAD1,"Íå íàéäåíî ñîâïàäåíèé");
  268. }
  269. case 8:
  270. {
  271. if(!f)
  272. {
  273. SendClientMessage(playerid, COLOR_WHITE, "Âû íå àäìèíèñòðàòîð!");
  274. if(PlayerInfo[playerid][pAdmin] > 0) PlayerInfo[playerid][pAdmin] = 0;
  275. return 1;
  276. }
  277. new Password[32];
  278. cache_get_field_content(0, "password", Password, connects);
  279. if(!strcmp(Password,"qwerty",true)) SetPVarInt(playerid, "aLogin", 1), ShowPlayerDialogEx(playerid,1227,DIALOG_STYLE_PASSWORD, "{FF6F00}Àäìèí ðåãèñòðàöèÿ", "{FFFFFF}Ââåäèòå ïàðîëü\n\nÏàðîëü äîëæåí ñîñòîÿòü èç ëàòèíñêèõ áóêâ è öèôð\n ðàçìåðîì îò 6 äî 15 ñèìâîëîâ", "Âõîä", "Îòìåíà");
  280. else SetPVarInt(playerid, "aLogin", 2), ShowPlayerDialogEx(playerid,1227,DIALOG_STYLE_PASSWORD, "{FF6F00}Àäìèí àâòîðèçàöèÿ", "{FFFFFF}Ââåäèòå ïàðîëü\n\nÏàðîëü äîëæåí ñîñòîÿòü èç ëàòèíñêèõ áóêâ è öèôð\n ðàçìåðîì îò 6 äî 15 ñèìâîëîâ", "Âõîä", "Îòìåíà");
  281. }
  282. case 9:
  283. {
  284. if(f)
  285. {
  286. new ipp[32];
  287. BaseGet("pIp",ipp);
  288. format(YCMDstr, sizeof(YCMDstr), "Íèê: %s | IP: %s",name,ipp);
  289. SendClientMessage(playerid, 0x6495EDFF, YCMDstr);
  290. }
  291. else SendClientMessage(playerid, COLOR_GRAD1, "Àêêàóíò íå íàéäåí â áàçå äàííûõ");
  292. }
  293. case 10:
  294. {
  295. if(f)
  296. {
  297. new ipp[32];
  298. BaseGet("pIpReg",ipp);
  299. format(YCMDstr, sizeof(YCMDstr), "Íèê: %s | IP ïðè ðåãèñòðàöèè: %s",name,ipp);
  300. SendClientMessage(playerid, 0x6495EDFF, YCMDstr);
  301. }
  302. else SendClientMessage(playerid, COLOR_GRAD1, "Àêêàóíò íå íàéäåí â áàçå äàííûõ");
  303. }
  304. case 11:
  305. {
  306. new Names[MAX_PLAYER_NAME];
  307. new OffMembers;
  308. new Rank;
  309. new Vxod[32];
  310. new OnlineLid[32];
  311. if(f)
  312. {
  313. BaseGet("Name",Names);
  314. BaseGetInt("pLogin",OffMembers);
  315. BaseGetInt("pRank",Rank);
  316. BaseGet("pOnline",Vxod);
  317. BaseGet("pOnlineLid",OnlineLid);
  318. if(OffMembers == 0)
  319. {
  320. format(YCMDstr, sizeof(YCMDstr), "[%s] [%d] [%s] [%s]",Names,Rank,Vxod,OnlineLid);
  321. SendClientMessage(playerid, 0x059BD3FF, YCMDstr);
  322. }
  323. }
  324. else SendClientMessage(playerid, COLOR_GRAD1,"Íå íàéäåíî ñîâïàäåíèé");
  325. }
  326. case 12:
  327. {
  328. if(f)
  329. {
  330. new OffMembers;
  331. BaseGetInt("pMember",OffMembers);
  332. if(OffMembers == PlayerInfo[playerid][pLeader])
  333. {
  334. format(YCMDstr, sizeof(YCMDstr), "UPDATE accounts SET pLeader = '0',pMember = '0',pRank = '0',pJobHealLeader = '0',pJobHeal = '0' WHERE name = '%s'",name);
  335. mysql_empty(connects,YCMDstr);
  336. SendClientMessage(playerid,COLOR_GREY,"Èãðîê áûë óâîëåí (Åñëè èãðîê áûë îíëàéí, óâîëüíåíèÿ íå ïðîèçîéäåò)");
  337. return true;
  338. }
  339. else return SendClientMessage(playerid,COLOR_GREY,"Èãðîê íå ñîñòîèò â âàøåé îðãàíèçàöèè");
  340. }
  341. else SendClientMessage(playerid, COLOR_GRAD1,"Íå íàéäåíî ñîâïàäåíèé");
  342. }
  343. case 13:
  344. {
  345. if(f)
  346. {
  347. format(YCMDstr, sizeof(YCMDstr), "{B4B5B7}______________________________________\n\n Äîáðî ïîæàëîâàòü íà ñåðâåð "NameServer"{B4B5B7}\n Ýòîò àêêàóíò çàðåãåñòðèðîâàí\n\nËîãèí: {BFC0C2}%s{B4B5B7}\nÂâåäèòå ïàðîëü:\n______________________________________",Name(playerid));
  348. ShowPlayerDialogEx(playerid,1,DIALOG_STYLE_PASSWORD, "Àâòîðèçàöèÿ",YCMDstr, "Âîéòè", "Îòìåíà");
  349. }
  350. else
  351. {
  352. format(YCMDstr, sizeof(YCMDstr), "{B4B5B7}______________________________________\n\n Äîáðî ïîæàëîâàòü íà ñåðâåð "NameServer"{B4B5B7}\n Ðåãèñòðàöèÿ íîâîãî ïåðñîíàæà\n\nËîãèí: {BFC0C2}%s{B4B5B7}\nÂâåäèòå ïàðîëü:\n______________________________________",Name(playerid));
  353. ShowPlayerDialogEx(playerid,2,DIALOG_STYLE_INPUT, "Ðåãèñòðàöèÿ",YCMDstr, "Ãîòîâî", "Îòìåíà");
  354. }
  355. }
  356. case 14:
  357. {
  358. if(f) return SendClientMessage(parametr,COLOR_RED,"Äàííûé íèê óæå åñòü â áàçå äàííûõ"), SendClientMessage(playerid,COLOR_RED,"Íåâîçìîæíî ñìåíèòü íèê. Íèê çàíÿò");
  359. SendClientMessage(parametr,COLOR_GREEN, "Âàø íèê áûë îäîáðåí");
  360. nick[parametr] = 1;
  361. ChangeName(parametr, WantNickChange[parametr]);
  362. }
  363. case 15:
  364. {
  365. if(f)
  366. {
  367. #define i parametr
  368. new string[144];
  369. if(IsPlayerConnected(GetPlayerID(BizzInfo[i][bNameStavka]))) PlayerInfo[GetPlayerID(BizzInfo[i][bNameStavka])][pPbiskey] = i, SendClientMessage(GetPlayerID(BizzInfo[i][bNameStavka]),COLOR_WHITE,"Âû ïðèîáðåëè áèçíåñ ñ àóêöèîíà. Óïðàâëåíèå: /mm => Êîìàíäû");
  370. else format(string, sizeof(string), "UPDATE accounts SET pPbiskey = %d, pText = 6 WHERE name = '%s'",i,BizzInfo[i][bNameStavka]), mysql_empty(connects,string);
  371. BizzInfo[i][bOwned] = 1;
  372. BizzInfo[i][bLocked] = 0;
  373. BizzInfo[i][bPrice] = 100;
  374. BizzInfo[i][bTill] = BizzInfo[i][bMinStavka];
  375. BizzInfo[i][b2Till] = 0;
  376. BizzInfo[i][bLicense] = 0;
  377. BizzInfo[i][bStavka] = 0;
  378. BizzInfo[i][bMinStavka] = 0;
  379. BizzInfo[i][bTimeStavka] = 0;
  380. BizzInfo[i][bLastStavka] = 0;
  381. if(BizzInfo[i][bType] != 4) BizzInfo[i][bProducts] = 2000;
  382. else BizzInfo[i][bProducts] = 20000;
  383. BizzInfo[i][bEntranceCost] = 100;
  384. strmid(BizzInfo[i][bOwner],BizzInfo[i][bNameStavka], 0, strlen(BizzInfo[i][bNameStavka]), 32);
  385. strmid(BizzInfo[i][bNameStavka], "-", 0, strlen("-"), 10);
  386. if(BizzInfo[i][bType] != 4) format(string,sizeof(string), "%s\nÂëàäåëåö: %s", BizzInfo[i][bMessage], BizzInfo[i][bOwner]);
  387. else format(string,sizeof(string), "%s\nÂëàäåëåö:\n %s\nÖåíà çà 1 ëèòð: %d âèðò", BizzInfo[i][bMessage], BizzInfo[i][bOwner], BizzInfo[i][bPrice]);
  388. Update3DTextLabelText(BizzInfo[i][bLabel], 0x00D900FF, string);
  389. SaveBizz(i);
  390. #undef i
  391. }
  392. }
  393. case 16:
  394. {
  395. if(f)
  396. {
  397. new Nick[50];
  398. BaseGet("pDrug",Nick);
  399. format(YCMDstr, sizeof(YCMDstr), "UPDATE accounts SET pCash = pCash + 100000, pText = '3' WHERE name = '%s'",Nick);
  400. mysql_empty(connects,YCMDstr);
  401. }
  402. }
  403. case dWrongPass:
  404. {
  405. if(f) return OnPlayerLoginToServer(playerid);
  406. new string[144];
  407. if(GetPVarInt(playerid, "wrongPass") == 3) return SendClientMessage(playerid,COLOR_LIGHTRED,"Íåâåðíûé ïàðîëü. Èñïîëüçóéòå /q äëÿ âûõîäà."), Kick(playerid);
  408. SetPVarInt(playerid, "wrongPass", GetPVarInt(playerid, "wrongPass")+1);
  409. format(string,sizeof(string), "{FF6347}Âíèìàíèå!Âû ââåëè íåâåðíûé ïàðîëü!\n\tÓ âàñ îñòàëîñü(%d) ïîïûòêè\nÏîñëå âû áóäåòå íà âðåìÿ çàáàíåíû",3-GetPVarInt(playerid, "wrongPass"));
  410. ShowPlayerDialogEx(playerid,1,DIALOG_STYLE_MSGBOX, "Îøèáêà!",string, "Ïîâòîð", "Âûéòè");
  411. }
  412. case 18:
  413. {
  414. if(!f) return 1;
  415. #define i parametr
  416. AvtoInfo[i][abID] = cache_get_field_content_int(i, "abID", connects);
  417. AvtoInfo[i][abEntranceX] = cache_get_field_content_float(i, "abEntranceX", connects);
  418. AvtoInfo[i][abEntranceY] = cache_get_field_content_float(i, "abEntranceY", connects);
  419. AvtoInfo[i][abEntranceZ] = cache_get_field_content_float(i, "abEntranceZ", connects);
  420. cache_get_field_content(i, "abOwner", AvtoInfo[i][abOwner], connects, strlen(AvtoInfo[i][abOwner]));
  421. AvtoInfo[i][abOwned] = cache_get_field_content_int(i, "abOwned", connects);
  422. AvtoInfo[i][abPriceProds] = cache_get_field_content_int(i, "abPriceProds", connects);
  423. cache_get_field_content(i, "abZam1", AvtoInfo[i][abZam1], connects, strlen(AvtoInfo[i][abZam1]));
  424. cache_get_field_content(i, "abZam2", AvtoInfo[i][abZam2], connects, strlen(AvtoInfo[i][abZam2]));
  425. cache_get_field_content(i, "abZam3", AvtoInfo[i][abZam3], connects, strlen(AvtoInfo[i][abZam3]));
  426. cache_get_field_content(i, "abMechanic1", AvtoInfo[i][abMechanic1], connects, strlen(AvtoInfo[i][abMechanic1]));
  427. cache_get_field_content(i, "abMechanic2", AvtoInfo[i][abMechanic2], connects, strlen(AvtoInfo[i][abMechanic2]));
  428. cache_get_field_content(i, "abMechanic3", AvtoInfo[i][abMechanic3], connects, strlen(AvtoInfo[i][abMechanic3]));
  429. cache_get_field_content(i, "abMechanic4", AvtoInfo[i][abMechanic4], connects, strlen(AvtoInfo[i][abMechanic4]));
  430. cache_get_field_content(i, "abMechanic5", AvtoInfo[i][abMechanic5], connects, strlen(AvtoInfo[i][abMechanic5]));
  431. AvtoInfo[i][abZp] = cache_get_field_content_int(i, "abZp", connects);
  432. AvtoInfo[i][abProds] = cache_get_field_content_int(i, "abProds", connects);
  433. AvtoInfo[i][abLandTax] = cache_get_field_content_int(i, "abLandTax", connects);
  434. AvtoInfo[i][abBank] = cache_get_field_content_int(i, "abBank", connects);
  435. AvtoInfo[i][abWorld] = cache_get_field_content_int(i, "abWorld", connects);
  436. #undef i
  437. }
  438. default: return 1;
  439. }
  440. return 1;
  441. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement