API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 23rd, 2015
116
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 30.92 KB | None | 0 0
raw download clone embed print report
  1. stock ClearReconnect()
  2. {
  3. for(new i=0; i<MAX_PLAYERS; i++) strmid(ExitInfo[i][ExitIP],"None", 0, strlen("None"), 32), ExitInfo[i][ExitTime] = 0;
  4. return 1;
  5. }
  6.  
  7. stock SaveMySQL(idx, i = 0)
  8. {
  9. new temp[0x9e];
  10. switch(idx)
  11. {
  12. case 0:
  13. {
  14. mysql_format(DATABASE, QUERY, sizeof(QUERY), "UPDATE `"TABLE_OTHERS"` SET ");
  15. format(temp,sizeof(temp),"`bank_lsnews`= '%i',",FracBank[0][fLsnews]), strcat(QUERY,temp,sizeof(QUERY));
  16. format(temp,sizeof(temp),"`bank_sfnews`= '%i',",FracBank[0][fSfnews]), strcat(QUERY,temp,sizeof(QUERY));
  17. format(temp,sizeof(temp),"`bank_lvnews`= '%i',",FracBank[0][fLvnews]), strcat(QUERY,temp,sizeof(QUERY));
  18. format(temp,sizeof(temp),"`bank_ballas`= '%i',",FracBank[0][fBallas]), strcat(QUERY,temp,sizeof(QUERY));
  19. format(temp,sizeof(temp),"`bank_vagos`= '%i',",FracBank[0][fVagos]), strcat(QUERY,temp,sizeof(QUERY));
  20. format(temp,sizeof(temp),"`bank_grove`= '%i',",FracBank[0][fGrove]), strcat(QUERY,temp,sizeof(QUERY));
  21. format(temp,sizeof(temp),"`bank_aztec`= '%i',",FracBank[0][fAztek]), strcat(QUERY,temp,sizeof(QUERY));
  22. format(temp,sizeof(temp),"`bank_exchequer`= '%i',",FracBank[0][fKazna]), strcat(QUERY,temp,sizeof(QUERY));
  23. format(temp,sizeof(temp),"`bank_ssmc`= '%i',",FracBank[0][fSsmc]), strcat(QUERY,temp,sizeof(QUERY));
  24. format(temp,sizeof(temp),"`bank_hamc`= '%i',",FracBank[0][fHamc]), strcat(QUERY,temp,sizeof(QUERY));
  25. format(temp,sizeof(temp),"`bank_omc`= '%i',",FracBank[0][fOmc]), strcat(QUERY,temp,sizeof(QUERY));
  26. format(temp,sizeof(temp),"`bank_wmc`= '%i',",FracBank[0][fWmc]), strcat(QUERY,temp,sizeof(QUERY));
  27. format(temp,sizeof(temp),"`bank_hwmc`= '%i',",FracBank[0][fHwmc]), strcat(QUERY,temp,sizeof(QUERY));
  28. format(temp,sizeof(temp),"`bank_fsmc`= '%i',",FracBank[0][fFsmc]), strcat(QUERY,temp,sizeof(QUERY));
  29. format(temp,sizeof(temp),"`bank_pmc`= '%i',",FracBank[0][fPmc]), strcat(QUERY,temp,sizeof(QUERY));
  30. format(temp,sizeof(temp),"`bank_mmc`= '%i',",FracBank[0][fMmc]), strcat(QUERY,temp,sizeof(QUERY));
  31. format(temp,sizeof(temp),"`bank_vmc`= '%i',",FracBank[0][fVmc]), strcat(QUERY,temp,sizeof(QUERY));
  32. format(temp,sizeof(temp),"`bank_bmc`= '%i',",FracBank[0][fBmc]), strcat(QUERY,temp,sizeof(QUERY));
  33. format(temp,sizeof(temp),"`heal_ballas`= '%i',",ballashel), strcat(QUERY,temp,sizeof(QUERY));
  34. format(temp,sizeof(temp),"`heal_grove`= '%i',",groovhel), strcat(QUERY,temp,sizeof(QUERY));
  35. format(temp,sizeof(temp),"`heal_vagos`= '%i',",vagoshel), strcat(QUERY,temp,sizeof(QUERY));
  36. format(temp,sizeof(temp),"`heal_aztec`= '%i',",aztekhel), strcat(QUERY,temp,sizeof(QUERY));
  37. format(temp,sizeof(temp),"`heal_rifa`= '%i',",rifahel), strcat(QUERY,temp,sizeof(QUERY));
  38. format(temp,sizeof(temp),"`adprice_ls`= '%i',",addd[0]), strcat(QUERY,temp,sizeof(QUERY));
  39. format(temp,sizeof(temp),"`adprice_sf`= '%i',",addd[1]), strcat(QUERY,temp,sizeof(QUERY));
  40. format(temp,sizeof(temp),"`adprice_lv`= '%i',",addd[2]), strcat(QUERY,temp,sizeof(QUERY));
  41. format(temp,sizeof(temp),"`healprice`= '%i',",healpric), strcat(QUERY,temp,sizeof(QUERY));
  42. format(temp,sizeof(temp),"`heal_yakuza`= '%i',",yakuzahel), strcat(QUERY,temp,sizeof(QUERY));
  43. format(temp,sizeof(temp),"`heal_lcn`= '%i',",lcnhel), strcat(QUERY,temp,sizeof(QUERY));
  44. format(temp,sizeof(temp),"`heal_rm`= '%i',",rmhel), strcat(QUERY,temp,sizeof(QUERY));
  45. format(temp,sizeof(temp),"`mats_lsa`= '%i',",lsamatbi), strcat(QUERY,temp,sizeof(QUERY));
  46. format(temp,sizeof(temp),"`mats_lva`= '%i',",armmatbi), strcat(QUERY,temp,sizeof(QUERY));
  47. format(temp,sizeof(temp),"`mats_sfa`= '%i',",armmatsf), strcat(QUERY,temp,sizeof(QUERY));
  48. format(temp,sizeof(temp),"`mats_ssmc`= '%i',",ssmcmatbi), strcat(QUERY,temp,sizeof(QUERY));
  49. format(temp,sizeof(temp),"`mats_hamc`= '%i',",hamcmatbi), strcat(QUERY,temp,sizeof(QUERY));
  50. format(temp,sizeof(temp),"`mats_omc`= '%i',",omcmatbi), strcat(QUERY,temp,sizeof(QUERY));
  51. format(temp,sizeof(temp),"`mats_wmc`= '%i',",wmcmatbi), strcat(QUERY,temp,sizeof(QUERY));
  52. format(temp,sizeof(temp),"`mats_hwmc`= '%i',",hwmcmatbi), strcat(QUERY,temp,sizeof(QUERY));
  53. format(temp,sizeof(temp),"`mats_fsmc`= '%i',",fsmcmatbi), strcat(QUERY,temp,sizeof(QUERY));
  54. format(temp,sizeof(temp),"`mats_vmc`= '%i',",vmcmatbi), strcat(QUERY,temp,sizeof(QUERY));
  55. format(temp,sizeof(temp),"`mats_pmc`= '%i',",pmcmatbi), strcat(QUERY,temp,sizeof(QUERY));
  56. format(temp,sizeof(temp),"`mats_mmc`= '%i',",mmcmatbi), strcat(QUERY,temp,sizeof(QUERY));
  57. format(temp,sizeof(temp),"`mats_bmc`= '%i',",bmcmatbi), strcat(QUERY,temp,sizeof(QUERY));
  58. format(temp,sizeof(temp),"`mats_rifa`= '%i',",rifamatbi), strcat(QUERY,temp,sizeof(QUERY));
  59. format(temp,sizeof(temp),"`mats_ballas`= '%i',",ballasmatbi), strcat(QUERY,temp,sizeof(QUERY));
  60. format(temp,sizeof(temp),"`mats_aztec`= '%i',",aztekmatbi), strcat(QUERY,temp,sizeof(QUERY));
  61. format(temp,sizeof(temp),"`mats_vagos`= '%i',",vagosmatbi), strcat(QUERY,temp,sizeof(QUERY));
  62. format(temp,sizeof(temp),"`mats_grove`= '%i',",groovmatbi), strcat(QUERY,temp,sizeof(QUERY));
  63. format(temp,sizeof(temp),"`mats_lspd`= '%i',",lspdmatbi), strcat(QUERY,temp,sizeof(QUERY));
  64. format(temp,sizeof(temp),"`mats_fbi`= '%i',",fbimats), strcat(QUERY,temp,sizeof(QUERY));
  65. format(temp,sizeof(temp),"`mats_yakuza`= '%i',",yakuzamats), strcat(QUERY,temp,sizeof(QUERY));
  66. format(temp,sizeof(temp),"`mats_rm`= '%i',",rmmats), strcat(QUERY,temp,sizeof(QUERY));
  67. format(temp,sizeof(temp),"`mats_lcn`= '%i',",lcnmats), strcat(QUERY,temp,sizeof(QUERY));
  68. format(temp,sizeof(temp),"`mats_sfpd`= '%i',",sfpdmats), strcat(QUERY,temp,sizeof(QUERY));
  69. format(temp,sizeof(temp),"`mats_lvpd`= '%i',",lvpdmats), strcat(QUERY,temp,sizeof(QUERY));
  70. format(temp,sizeof(temp),"`bank_lcn`= '%i',",MafiaBank[0][nLcn]), strcat(QUERY,temp,sizeof(QUERY));
  71. format(temp,sizeof(temp),"`bank_yakuza`= '%i',",MafiaBank[0][nYakuza]), strcat(QUERY,temp,sizeof(QUERY));
  72. format(temp,sizeof(temp),"`bank_rm`= '%i'",MafiaBank[0][nRm]), strcat(QUERY,temp,sizeof(QUERY));
  73. mysql_function_query(DATABASE, QUERY, true, "", "");
  74. }
  75. case 1:
  76. {
  77. mysql_format(DATABASE, QUERY, sizeof(QUERY), "UPDATE `"TABLE_CASINO"` SET ");
  78. format(temp,sizeof(temp),"`ID`= '%i',",CasinoInfo[i][caID]), strcat(QUERY,temp,sizeof(QUERY));
  79. format(temp,sizeof(temp),"`Name`= '%s',",CasinoInfo[i][caName]), strcat(QUERY,temp,sizeof(QUERY));
  80. format(temp,sizeof(temp),"`Mafia`= '%i',",CasinoInfo[i][caMafia]), strcat(QUERY,temp,sizeof(QUERY));
  81. format(temp,sizeof(temp),"`Manager`= '%s',",CasinoInfo[i][caManager]), strcat(QUERY,temp,sizeof(QUERY));
  82. format(temp,sizeof(temp),"`Manager2`= '%s',",CasinoInfo[i][caManager2]), strcat(QUERY,temp,sizeof(QUERY));
  83. format(temp,sizeof(temp),"`Manager3`= '%s',",CasinoInfo[i][caManager3]), strcat(QUERY,temp,sizeof(QUERY));
  84. format(temp,sizeof(temp),"`Krupie`= '%s',",CasinoInfo[i][caKrupie]), strcat(QUERY,temp,sizeof(QUERY));
  85. format(temp,sizeof(temp),"`Krupie2`= '%s',",CasinoInfo[i][caKrupie2]), strcat(QUERY,temp,sizeof(QUERY));
  86. format(temp,sizeof(temp),"`Krupie3`= '%s',",CasinoInfo[i][caKrupie3]), strcat(QUERY,temp,sizeof(QUERY));
  87. format(temp,sizeof(temp),"`Krupie4`= '%s',",CasinoInfo[i][caKrupie4]), strcat(QUERY,temp,sizeof(QUERY));
  88. format(temp,sizeof(temp),"`Krupie5`= '%s',",CasinoInfo[i][caKrupie5]), strcat(QUERY,temp,sizeof(QUERY));
  89. format(temp,sizeof(temp),"`Krupie6`= '%s',",CasinoInfo[i][caKrupie6]), strcat(QUERY,temp,sizeof(QUERY));
  90. format(temp,sizeof(temp),"`Krupie7`= '%s',",CasinoInfo[i][caKrupie7]), strcat(QUERY,temp,sizeof(QUERY));
  91. format(temp,sizeof(temp),"`Krupie8`= '%s',",CasinoInfo[i][caKrupie8]), strcat(QUERY,temp,sizeof(QUERY));
  92. format(temp,sizeof(temp),"`Krupie9`= '%s',",CasinoInfo[i][caKrupie9]), strcat(QUERY,temp,sizeof(QUERY));
  93. format(temp,sizeof(temp),"`Krupie10`= '%s'",CasinoInfo[i][caKrupie10]), strcat(QUERY,temp,sizeof(QUERY));
  94. format(temp,sizeof(temp)," WHERE ID = '%i'",CasinoInfo[i][caID]), strcat(QUERY,temp,sizeof(QUERY));
  95. mysql_function_query(DATABASE, QUERY, true, "", "");
  96. }
  97. case 2:
  98. {
  99. if(GetPVarInt(i,"player_save") || !PTEMP[i][pLogin]) return true;
  100. SetPVarInt(i,"player_save",1);
  101. new year, month, day;
  102. getdate(year, month, day);
  103. for(new x = 1; x < 11; x++) GetPlayerWeaponData(i,x,PTEMP[i][pWeapon][x-1],PTEMP[i][pAmmo][x-1]);
  104. format(PTEMP[i][pWeapons],32,"%i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i",PTEMP[i][pWeapon][0], PTEMP[i][pWeapon][1], PTEMP[i][pWeapon][2], PTEMP[i][pWeapon][3],
  105. PTEMP[i][pWeapon][4], PTEMP[i][pWeapon][5], PTEMP[i][pWeapon][6], PTEMP[i][pWeapon][7], PTEMP[i][pWeapon][8], PTEMP[i][pWeapon][9], PTEMP[i][pWeapon][10]);
  106. format(PTEMP[i][pAmmos],32,"%i, %i, %i, %i, %i, %i, %i, %i, %i, %i, %i",PTEMP[i][pAmmo][0], PTEMP[i][pAmmo][1], PTEMP[i][pAmmo][2], PTEMP[i][pAmmo][3],
  107. PTEMP[i][pAmmo][4], PTEMP[i][pAmmo][5], PTEMP[i][pAmmo][6], PTEMP[i][pAmmo][7], PTEMP[i][pAmmo][8], PTEMP[i][pAmmo][9], PTEMP[i][pAmmo][10]);
  108. format(PTEMP[i][pGunSkills],30,"%i, %i, %i, %i, %i ,%i",PTEMP[i][pGunSkill][0],PTEMP[i][pGunSkill][1],PTEMP[i][pGunSkill][2],PTEMP[i][pGunSkill][3],PTEMP[i][pGunSkill][4],PTEMP[i][pGunSkill][5]);
  109. format(PTEMP[i][pChars],30,"%i, %i, %i, %i, %i ,%i",PTEMP[i][pChar][0],PTEMP[i][pChar][1],PTEMP[i][pChar][2],PTEMP[i][pChar][3],PTEMP[i][pChar][4],PTEMP[i][pChar][5]);
  110.  
  111. mysql_format(DATABASE, QUERY, sizeof(QUERY), "UPDATE `"TABLE_ACCOUNTS"` SET `pLevel` = '%i', `pHelper` = '%i', `pJobHeal` = '%i', `pMestoJail` = '%i', `pHousecash` = '%i', `pCheckip` = '%i'",
  112. PTEMP[i][pLevel], PTEMP[i][pHelper], PTEMP[i][pJobHeal], PTEMP[i][pMestoJail], PTEMP[i][pHousecash], PTEMP[i][pCheckip]);
  113.  
  114. mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s, `pHP` = '%f', `pSatiety` = '%i', `pDonateRank` = '%i', `pMats` = '%i', `pSex` = '%i', `pArrested` = '%i'",
  115. QUERY, PTEMP[i][pHP], PTEMP[i][pSatiety], PTEMP[i][pDonateRank], PTEMP[i][pMats], PTEMP[i][pSex], PTEMP[i][pArrested]);
  116.  
  117. mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s, `pMuted` = '%i', `pCrimes` = '%i', `pExp` = '%i', `pCash` = '%i', `pWantedDeaths` = '%i', `pPayCheck` = '%i', `pJailTime` = '%i', `pDrugs` = '%i', `pLeader` = '%i', `pMember` = '%i'",
  118. QUERY, PTEMP[i][pMuted], PTEMP[i][pCrimes], PTEMP[i][pExp], PTEMP[i][pCash], PTEMP[i][pWantedDeaths], PTEMP[i][pPayCheck], PTEMP[i][pJailTime], PTEMP[i][pDrugs], PTEMP[i][pLeader], PTEMP[i][pMember]);
  119.  
  120. mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s, `pRank` = '%i', `pChars` = '%s', `pJob` = '%i', `pModel` = '%i', `pPnumber` = '%i', `pDirectory` = '%i', `pVhoddata` = '%i', `pVhodMes` = '%i', `pVhodchas` = '%i', `pVhodminute` = '%i'",
  121. QUERY, PTEMP[i][pRank], PTEMP[i][pChars], PTEMP[i][pJob], PTEMP[i][pModel], PTEMP[i][pPnumber], PTEMP[i][pDirectory], PTEMP[i][pVhoddata], PTEMP[i][pVhodMes], PTEMP[i][pVhodchas], PTEMP[i][pVhodminute]);
  122.  
  123. mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s, `pCarLic` = '%i', `pFlyLic` = '%i', `pBoatLic` = '%i', `pFishLic` = '%i', `pGunLic` = '%i', `pBizLic` = '%i', `pZakonp` = '%i', `pText` = '%i'",
  124. QUERY, PTEMP[i][pCarLic], PTEMP[i][pFlyLic], PTEMP[i][pBoatLic], PTEMP[i][pFishLic], PTEMP[i][pGunLic], PTEMP[i][pBizLic], PTEMP[i][pZakonp], PTEMP[i][pText]);
  125.  
  126. mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s, `pAddiction` = '%i', `pNarcoLomka` = '%i', `pPayDayHad` = '%i', `pTut` = '%i', `pWarns` = '%i', `punWarns` = '%i', `pFuel` = '%i', `pMarriedTo` = '%s', `pMushrooms` = '%i'",
  127. QUERY, PTEMP[i][pAddiction], PTEMP[i][pNarcoLomka], PTEMP[i][pPayDayHad], PTEMP[i][pTut], PTEMP[i][pWarns], PTEMP[i][punWarns], PTEMP[i][pFuel], PTEMP[i][pMarriedTo], PTEMP[i][pMushrooms]);
  128.  
  129. mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s, `pFishes` = '%f', `pBank` = '%i', `pMobile` = '%i', `pDolg` = '%i', `pKrisha` = '%i', `pUseKrisha` = '%i', `pWantedLevel` = '%i'",
  130. QUERY, PTEMP[i][pFishes], PTEMP[i][pBank], PTEMP[i][pMobile], PTEMP[i][pDolg], PTEMP[i][pKrisha], PTEMP[i][pUseKrisha], PTEMP[i][pWantedLevel]);
  131.  
  132. mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s, `pWeapons` = '%s', `pAmmos` = '%s', `pGunSkills` = '%s', `ptaxiexp` = '%i', `ptaxilvl` = '%i', `pBoxSkill` = '%i', `pKongfuSkill` = '%i', `pKickboxSkill` = '%i', `pDLevel` = '%i', `pDExp` = '%i'",
  133. QUERY, PTEMP[i][pWeapons], PTEMP[i][pAmmos], PTEMP[i][pGunSkills], PTEMP[i][ptaxiexp], PTEMP[i][ptaxilvl], PTEMP[i][pBoxSkill], PTEMP[i][pKongfuSkill], PTEMP[i][pKickboxSkill], PTEMP[i][pDLevel], PTEMP[i][pDExp]);
  134.  
  135. mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s, `pDMgruz` = '%i', `pDonateAccount` = '%i'",
  136. QUERY, PTEMP[i][pDMgruz], PTEMP[i][pDonateAccount]);
  137.  
  138. mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s, `pOnline` = '%02i/%02i/%02i', `pChas` = '%i', `pMin` = '%i', `pOnlineLid` = '%02i:%02i', `pSkilla` = '%i', `prods_skill` = '%i', `prods_exp` = '%i'",
  139. QUERY, day, month, year, PTEMP[i][pChas], PTEMP[i][pMin], PTEMP[i][pChas], PTEMP[i][pMin], PTEMP[i][pSkilla], PTEMP[i][pProdsSkill][0], PTEMP[i][pProdsSkill][1]);
  140.  
  141. mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s, `pLighter` = '%i', `pCigarettes` = '%i', `pRecognition` = '%i', `pRobHouse` = '%i', `pFishesPach` = '%i', `pDrivingSkill` = '%i'",
  142. QUERY, PTEMP[i][pLighter], PTEMP[i][pCigarettes], PTEMP[i][pRecognition], PTEMP[i][pRobHouse], PTEMP[i][pFishesPach], PTEMP[i][pDrivingSkill]);
  143.  
  144. mysql_format(DATABASE, QUERY, sizeof(QUERY), "%s WHERE `Name` = '%e'", QUERY, PTEMP[i][pName]);
  145. mysql_function_query(DATABASE, QUERY, false, "", "");
  146. DeletePVar(i, "player_save");
  147. }
  148. case 3:
  149. {
  150. format(WorkshopInfo[i][wAuctions],128,"%i, %i, %i, %i, %i",WorkshopInfo[i][wAuction][0], WorkshopInfo[i][wAuction][1], WorkshopInfo[i][wAuction][2], WorkshopInfo[i][wAuction][3], WorkshopInfo[i][wAuction][4]);
  151. mysql_format(DATABASE, QUERY, sizeof(QUERY), "UPDATE `"TABLE_WORKSHOPS"` SET ");
  152. format(temp,sizeof(temp),"`owner`= '%s',",WorkshopInfo[i][wOwner]), strcat(QUERY,temp,sizeof(QUERY));
  153. format(temp,sizeof(temp),"`bank`= '%i',",WorkshopInfo[i][wBank]), strcat(QUERY,temp,sizeof(QUERY));
  154. format(temp,sizeof(temp),"`landtax`= '%i',",WorkshopInfo[i][wLandTax]), strcat(QUERY,temp,sizeof(QUERY));
  155. format(temp,sizeof(temp),"`prods`= '%i',",WorkshopInfo[i][wProds]), strcat(QUERY,temp,sizeof(QUERY));
  156. format(temp,sizeof(temp),"`priceprods`= '%i',",WorkshopInfo[i][wPriceProds]), strcat(QUERY,temp,sizeof(QUERY));
  157. format(temp,sizeof(temp),"`zp`= '%i',",WorkshopInfo[i][wZp]), strcat(QUERY,temp,sizeof(QUERY));
  158. format(temp,sizeof(temp),"`deputy_one`= '%s',",WorkshopInfo[i][wDeputy1]), strcat(QUERY,temp,sizeof(QUERY));
  159. format(temp,sizeof(temp),"`deputy_two`= '%s',",WorkshopInfo[i][wDeputy2]), strcat(QUERY,temp,sizeof(QUERY));
  160. format(temp,sizeof(temp),"`deputy_three`= '%s',",WorkshopInfo[i][wDeputy3]), strcat(QUERY,temp,sizeof(QUERY));
  161. format(temp,sizeof(temp),"`mechanic_one`= '%s',",WorkshopInfo[i][wMechanic1]), strcat(QUERY,temp,sizeof(QUERY));
  162. format(temp,sizeof(temp),"`mechanic_two`= '%s',",WorkshopInfo[i][wMechanic2]), strcat(QUERY,temp,sizeof(QUERY));
  163. format(temp,sizeof(temp),"`mechanic_three`= '%s',",WorkshopInfo[i][wMechanic3]), strcat(QUERY,temp,sizeof(QUERY));
  164. format(temp,sizeof(temp),"`mechanic_four`= '%s',",WorkshopInfo[i][wMechanic4]), strcat(QUERY,temp,sizeof(QUERY));
  165. format(temp,sizeof(temp),"`mechanic_five`= '%s',",WorkshopInfo[i][wMechanic5]), strcat(QUERY,temp,sizeof(QUERY));
  166. format(temp,sizeof(temp),"`auctions`= '%s',",WorkshopInfo[i][wAuctions]), strcat(QUERY,temp,sizeof(QUERY));
  167. format(temp,sizeof(temp),"`auction_name`= '%s'",WorkshopInfo[i][wAuctionName]), strcat(QUERY,temp,sizeof(QUERY));
  168. format(temp,sizeof(temp)," WHERE id = '%i'",WorkshopInfo[i][wID]), strcat(QUERY,temp,sizeof(QUERY));
  169. mysql_function_query(DATABASE, QUERY, true, "", "");
  170. }
  171. case 4:
  172. {
  173. mysql_format(DATABASE, QUERY, sizeof(QUERY), "UPDATE `"TABLE_BIZZ"` SET ");
  174. format(temp,sizeof(temp),"`bOwner`= '%s',",BizzInfo[i][bOwner]), strcat(QUERY,temp,sizeof(QUERY));
  175. format(temp,sizeof(temp),"`bMessage`= '%s',",BizzInfo[i][bMessage]), strcat(QUERY,temp,sizeof(QUERY));
  176. format(temp,sizeof(temp),"`bEntranceX`= '%f',",BizzInfo[i][bEntranceX]), strcat(QUERY,temp,sizeof(QUERY));
  177. format(temp,sizeof(temp),"`bEntranceY`= '%f',",BizzInfo[i][bEntranceY]), strcat(QUERY,temp,sizeof(QUERY));
  178. format(temp,sizeof(temp),"`bEntranceZ`= '%f',",BizzInfo[i][bEntranceZ]), strcat(QUERY,temp,sizeof(QUERY));
  179. format(temp,sizeof(temp),"`bExitX`= '%f',",BizzInfo[i][bExitX]), strcat(QUERY,temp,sizeof(QUERY));
  180. format(temp,sizeof(temp),"`bExitY`= '%f',",BizzInfo[i][bExitY]), strcat(QUERY,temp,sizeof(QUERY));
  181. format(temp,sizeof(temp),"`bExitZ`= '%f',",BizzInfo[i][bExitZ]), strcat(QUERY,temp,sizeof(QUERY));
  182. format(temp,sizeof(temp),"`bBuyPrice`= '%i',",BizzInfo[i][bBuyPrice]), strcat(QUERY,temp,sizeof(QUERY));
  183. format(temp,sizeof(temp),"`bEntranceCost`= '%i',",BizzInfo[i][bEntranceCost]), strcat(QUERY,temp,sizeof(QUERY));
  184. format(temp,sizeof(temp),"`bTill`= '%i',",BizzInfo[i][bTill]), strcat(QUERY,temp,sizeof(QUERY));
  185. format(temp,sizeof(temp),"`bLocked`= '%i',",BizzInfo[i][bLocked]), strcat(QUERY,temp,sizeof(QUERY));
  186. format(temp,sizeof(temp),"`bInterior`= '%i',",BizzInfo[i][bInterior]), strcat(QUERY,temp,sizeof(QUERY));
  187. format(temp,sizeof(temp),"`bProducts`= '%i',",BizzInfo[i][bProducts]), strcat(QUERY,temp,sizeof(QUERY));
  188. format(temp,sizeof(temp),"`bPrice`= '%i',",BizzInfo[i][bPrice]), strcat(QUERY,temp,sizeof(QUERY));
  189. format(temp,sizeof(temp),"`bBarX`= '%f',",BizzInfo[i][bBarX]), strcat(QUERY,temp,sizeof(QUERY));
  190. format(temp,sizeof(temp),"`bBarY`= '%f',",BizzInfo[i][bBarY]), strcat(QUERY,temp,sizeof(QUERY));
  191. format(temp,sizeof(temp),"`bBarZ`= '%f',",BizzInfo[i][bBarZ]), strcat(QUERY,temp,sizeof(QUERY));
  192. format(temp,sizeof(temp),"`bMafia`= '%i',",BizzInfo[i][bMafia]), strcat(QUERY,temp,sizeof(QUERY));
  193. format(temp,sizeof(temp),"`bType`= '%i',",BizzInfo[i][bType]), strcat(QUERY,temp,sizeof(QUERY));
  194. format(temp,sizeof(temp),"`bLockTime`= '%i',",BizzInfo[i][bLockTime]), strcat(QUERY,temp,sizeof(QUERY));
  195. format(temp,sizeof(temp),"`bLicense`= '%i',",BizzInfo[i][bLicense]), strcat(QUERY,temp,sizeof(QUERY));
  196. format(temp,sizeof(temp),"`bStavka`= '%i',",BizzInfo[i][bStavka]), strcat(QUERY,temp,sizeof(QUERY));
  197. format(temp,sizeof(temp),"`bNameStavka`= '%s',",BizzInfo[i][bNameStavka]), strcat(QUERY,temp,sizeof(QUERY));
  198. format(temp,sizeof(temp),"`bLastStavka`= '%i',",BizzInfo[i][bLastStavka]), strcat(QUERY,temp,sizeof(QUERY));
  199. format(temp,sizeof(temp),"`bTimeStavka`= '%i',",BizzInfo[i][bTimeStavka]), strcat(QUERY,temp,sizeof(QUERY));
  200. format(temp,sizeof(temp),"`bMinStavka`= '%i',",BizzInfo[i][bMinStavka]), strcat(QUERY,temp,sizeof(QUERY));
  201. format(temp,sizeof(temp),"`bVirtualWorld`= '%i',",BizzInfo[i][bVirtualWorld]), strcat(QUERY,temp,sizeof(QUERY));
  202. format(temp,sizeof(temp),"`bLandTax`= '%i',",BizzInfo[i][bLandTax]), strcat(QUERY,temp,sizeof(QUERY));
  203. format(temp,sizeof(temp),"`bProdPrice`= '%i'",BizzInfo[i][bProdPrice]), strcat(QUERY,temp,sizeof(QUERY));
  204. format(temp,sizeof(temp)," WHERE bID = '%i'",BizzInfo[i][bID]), strcat(QUERY,temp,sizeof(QUERY));
  205. mysql_function_query(DATABASE, QUERY, true, "", "");
  206. }
  207. case 5:
  208. {
  209. format(HouseInfo[i][hSafes],50,"%i, %i, %i, %i, %i ,%i, %i, %i, %i, %i, %i",
  210. HouseInfo[i][hSafe][0], HouseInfo[i][hSafe][1], HouseInfo[i][hSafe][2], HouseInfo[i][hSafe][3], HouseInfo[i][hSafe][4],
  211. HouseInfo[i][hSafe][5], HouseInfo[i][hSafe][6], HouseInfo[i][hSafe][7], HouseInfo[i][hSafe][8], HouseInfo[i][hSafe][9], HouseInfo[i][hSafe][10]);
  212. mysql_format(DATABASE, QUERY, sizeof(QUERY), "UPDATE `"TABLE_HOUSE"` SET ");
  213. format(temp,sizeof(temp),"`hEntrancex`= '%f',",HouseInfo[i][hEntrancex]), strcat(QUERY,temp,sizeof(QUERY));
  214. format(temp,sizeof(temp),"`hEntrancey`= '%f',",HouseInfo[i][hEntrancey]), strcat(QUERY,temp,sizeof(QUERY));
  215. format(temp,sizeof(temp),"`hEntrancez`= '%f',",HouseInfo[i][hEntrancez]), strcat(QUERY,temp,sizeof(QUERY));
  216. format(temp,sizeof(temp),"`hExitx`= '%f',",HouseInfo[i][hExitx]), strcat(QUERY,temp,sizeof(QUERY));
  217. format(temp,sizeof(temp),"`hExity`= '%f',",HouseInfo[i][hExity]), strcat(QUERY,temp,sizeof(QUERY));
  218. format(temp,sizeof(temp),"`hExitz`= '%f',",HouseInfo[i][hExitz]), strcat(QUERY,temp,sizeof(QUERY));
  219. format(temp,sizeof(temp),"`hOwner`= '%s',",HouseInfo[i][hOwner]), strcat(QUERY,temp,sizeof(QUERY));
  220. format(temp,sizeof(temp),"`hValue`= '%i',",HouseInfo[i][hValue]), strcat(QUERY,temp,sizeof(QUERY));
  221. format(temp,sizeof(temp),"`hTakings`= '%i',",HouseInfo[i][hTakings]), strcat(QUERY,temp,sizeof(QUERY));
  222. format(temp,sizeof(temp),"`hHel`= '%i',",HouseInfo[i][hHel]), strcat(QUERY,temp,sizeof(QUERY));
  223. format(temp,sizeof(temp),"`hInt`= '%i',",HouseInfo[i][hInt]), strcat(QUERY,temp,sizeof(QUERY));
  224. format(temp,sizeof(temp),"`hLock`= '%i',",HouseInfo[i][hLock]), strcat(QUERY,temp,sizeof(QUERY));
  225. format(temp,sizeof(temp),"`hVec`= '%i',",HouseInfo[i][hVec]), strcat(QUERY,temp,sizeof(QUERY));
  226. format(temp,sizeof(temp),"`hVcol1`= '%i',",HouseInfo[i][hVcol1]), strcat(QUERY,temp,sizeof(QUERY));
  227. format(temp,sizeof(temp),"`hVcol2`= '%i',",HouseInfo[i][hVcol2]), strcat(QUERY,temp,sizeof(QUERY));
  228. format(temp,sizeof(temp),"`hKlass`= '%i',",HouseInfo[i][hKlass]), strcat(QUERY,temp,sizeof(QUERY));
  229. format(temp,sizeof(temp),"`hVehSost`= '%i',",HouseInfo[i][hVehSost]), strcat(QUERY,temp,sizeof(QUERY));
  230. format(temp,sizeof(temp),"`hCarx`= '%f',",HouseInfo[i][hCarx]), strcat(QUERY,temp,sizeof(QUERY));
  231. format(temp,sizeof(temp),"`hCary`= '%f',",HouseInfo[i][hCary]), strcat(QUERY,temp,sizeof(QUERY));
  232. format(temp,sizeof(temp),"`hCarz`= '%f',",HouseInfo[i][hCarz]), strcat(QUERY,temp,sizeof(QUERY));
  233. format(temp,sizeof(temp),"`hCarc`= '%f',",HouseInfo[i][hCarc]), strcat(QUERY,temp,sizeof(QUERY));
  234. format(temp,sizeof(temp),"`hSafes`= '%s'",HouseInfo[i][hSafes]), strcat(QUERY,temp,sizeof(QUERY));
  235. format(temp,sizeof(temp)," WHERE hID = '%i'",HouseInfo[i][hID]), strcat(QUERY,temp,sizeof(QUERY));
  236. mysql_function_query(DATABASE, QUERY, true, "", "");
  237. }
  238. case 6:
  239. {
  240. mysql_format(DATABASE, QUERY, sizeof(QUERY), "UPDATE `"TABLE_KVARTIRS"` SET ");
  241. format(temp,sizeof(temp),"`pXpic`= '%f',",kvartinfo[i][pXpic]), strcat(QUERY,temp,sizeof(QUERY));
  242. format(temp,sizeof(temp),"`pYpic`= '%f',",kvartinfo[i][pYpic]), strcat(QUERY,temp,sizeof(QUERY));
  243. format(temp,sizeof(temp),"`pZpic`= '%f',",kvartinfo[i][pZpic]), strcat(QUERY,temp,sizeof(QUERY));
  244. format(temp,sizeof(temp),"`vladelec`= '%s',",kvartinfo[i][vladelec]), strcat(QUERY,temp,sizeof(QUERY));
  245. format(temp,sizeof(temp),"`lock`= '%i',",kvartinfo[i][lock]), strcat(QUERY,temp,sizeof(QUERY));
  246. format(temp,sizeof(temp),"`kworld`= '%i',",kvartinfo[i][kworld]), strcat(QUERY,temp,sizeof(QUERY));
  247. format(temp,sizeof(temp),"`aptek`= '%i',",kvartinfo[i][aptek]), strcat(QUERY,temp,sizeof(QUERY));
  248. format(temp,sizeof(temp),"`plata`= '%i',",kvartinfo[i][plata]), strcat(QUERY,temp,sizeof(QUERY));
  249. format(temp,sizeof(temp),"`virtmir`= '%i'",kvartinfo[i][virtmir]), strcat(QUERY,temp,sizeof(QUERY));
  250. format(temp,sizeof(temp)," WHERE kid = '%i'",kvartinfo[i][kid]), strcat(QUERY,temp,sizeof(QUERY));
  251. mysql_function_query(DATABASE, QUERY, true, "", "");
  252. }
  253. case 7:
  254. {
  255. mysql_format(DATABASE, QUERY, sizeof(QUERY), "UPDATE `"TABLE_PODEZDS"` SET ");
  256. format(temp,sizeof(temp),"`podPicX`= '%f',",PodeezdInfo[i][podPicX]), strcat(QUERY,temp,sizeof(QUERY));
  257. format(temp,sizeof(temp),"`podPicY`= '%f',",PodeezdInfo[i][podPicY]), strcat(QUERY,temp,sizeof(QUERY));
  258. format(temp,sizeof(temp),"`podPicZ`= '%f',",PodeezdInfo[i][podPicZ]), strcat(QUERY,temp,sizeof(QUERY));
  259. format(temp,sizeof(temp),"`podEtazi`= '%i',",PodeezdInfo[i][podEtazi]), strcat(QUERY,temp,sizeof(QUERY));
  260. format(temp,sizeof(temp),"`carX`= '%f',",PodeezdInfo[i][carX]), strcat(QUERY,temp,sizeof(QUERY));
  261. format(temp,sizeof(temp),"`carY`= '%f',",PodeezdInfo[i][carY]), strcat(QUERY,temp,sizeof(QUERY));
  262. format(temp,sizeof(temp),"`carZ`= '%f',",PodeezdInfo[i][carZ]), strcat(QUERY,temp,sizeof(QUERY));
  263. format(temp,sizeof(temp),"`carC`= '%f'",PodeezdInfo[i][carC]), strcat(QUERY,temp,sizeof(QUERY));
  264. format(temp,sizeof(temp)," WHERE pid = '%i'",PodeezdInfo[i][pid]), strcat(QUERY,temp,sizeof(QUERY));
  265. mysql_function_query(DATABASE, QUERY, true, "", "");
  266. }
  267. case 8:
  268. {
  269. mysql_format(DATABASE,QUERY, 500, "UPDATE "TABLE_ATM" SET `id` = '%i', `ax` = '%f', `ay` = '%f', `az` = '%f', `arz` = '%f' WHERE id = %i",
  270. ATMInfo[i][aid], ATMInfo[i][aX],ATMInfo[i][aY],ATMInfo[i][aZ],ATMInfo[i][arZ], ATMInfo[i][aid]);
  271. mysql_function_query(DATABASE, QUERY, true, "", "");
  272. }
  273. case 9:
  274. {
  275. format(FarmInfo[i][fAuctions],64,"%i, %i, %i, %i, %i",FarmInfo[i][fAuction][0], FarmInfo[i][fAuction][1], FarmInfo[i][fAuction][2], FarmInfo[i][fAuction][3], FarmInfo[i][fAuction][4]);
  276. mysql_format(DATABASE, QUERY, sizeof(QUERY), "UPDATE `"TABLE_FARM"` SET ");
  277. format(temp,sizeof(temp),"`owner`= '%s',",FarmInfo[i][fOwner]), strcat(QUERY,temp,sizeof(QUERY));
  278. format(temp,sizeof(temp),"`bank`= '%i',",FarmInfo[i][fBank]), strcat(QUERY,temp,sizeof(QUERY));
  279. format(temp,sizeof(temp),"`landtax`= '%i',",FarmInfo[i][fLandTax]), strcat(QUERY,temp,sizeof(QUERY));
  280. format(temp,sizeof(temp),"`zp`= '%i',",FarmInfo[i][fZp]), strcat(QUERY,temp,sizeof(QUERY));
  281. format(temp,sizeof(temp),"`grain_price`= '%i',",FarmInfo[i][fGrain_Price]), strcat(QUERY,temp,sizeof(QUERY));
  282. format(temp,sizeof(temp),"`grain`= '%i',",FarmInfo[i][fGrain]), strcat(QUERY,temp,sizeof(QUERY));
  283. format(temp,sizeof(temp),"`grain_sown`= '%i',",FarmInfo[i][fGrain_Sown]), strcat(QUERY,temp,sizeof(QUERY));
  284. format(temp,sizeof(temp),"`prods_selling`= '%i',",FarmInfo[i][fProds_Selling]), strcat(QUERY,temp,sizeof(QUERY));
  285. format(temp,sizeof(temp),"`prods`= '%i',",FarmInfo[i][fProds]), strcat(QUERY,temp,sizeof(QUERY));
  286. format(temp,sizeof(temp),"`prods_price`= '%i',",FarmInfo[i][fProds_Price]), strcat(QUERY,temp,sizeof(QUERY));
  287. format(temp,sizeof(temp),"`deputy_1`= '%s',",FarmInfo[i][fDeputy_1]), strcat(QUERY,temp,sizeof(QUERY));
  288. format(temp,sizeof(temp),"`deputy_2`= '%s',",FarmInfo[i][fDeputy_2]), strcat(QUERY,temp,sizeof(QUERY));
  289. format(temp,sizeof(temp),"`deputy_3`= '%s',",FarmInfo[i][fDeputy_3]), strcat(QUERY,temp,sizeof(QUERY));
  290. format(temp,sizeof(temp),"`farmer_1`= '%s',",FarmInfo[i][fFarmer_1]), strcat(QUERY,temp,sizeof(QUERY));
  291. format(temp,sizeof(temp),"`farmer_2`= '%s',",FarmInfo[i][fFarmer_2]), strcat(QUERY,temp,sizeof(QUERY));
  292. format(temp,sizeof(temp),"`farmer_3`= '%s',",FarmInfo[i][fFarmer_3]), strcat(QUERY,temp,sizeof(QUERY));
  293. format(temp,sizeof(temp),"`farmer_4`= '%s',",FarmInfo[i][fFarmer_4]), strcat(QUERY,temp,sizeof(QUERY));
  294. format(temp,sizeof(temp),"`farmer_5`= '%s',",FarmInfo[i][fFarmer_5]), strcat(QUERY,temp,sizeof(QUERY));
  295. format(temp,sizeof(temp),"`auctions`= '%s',",FarmInfo[i][fAuctions]), strcat(QUERY,temp,sizeof(QUERY));
  296. format(temp,sizeof(temp),"`auction_name`= '%s'",FarmInfo[i][fAuctionName]), strcat(QUERY,temp,sizeof(QUERY));
  297. format(temp,sizeof(temp)," WHERE id = '%i'",FarmInfo[i][fID]), strcat(QUERY,temp,sizeof(QUERY));
  298. mysql_function_query(DATABASE, QUERY, true, "", "");
  299. }
  300. case 10:
  301. {
  302. mysql_format(DATABASE, QUERY, sizeof(QUERY), "UPDATE `"TABLE_CARS"` SET ");
  303. format(temp,sizeof(temp),"`model`= '%i',",CarInfo[i][carModel][0]), strcat(QUERY,temp,sizeof(QUERY));
  304. format(temp,sizeof(temp),"`color_one`= '%i',",CarInfo[i][carColor_one][0]), strcat(QUERY,temp,sizeof(QUERY));
  305. format(temp,sizeof(temp),"`color_two`= '%i',",CarInfo[i][carColor_two][0]), strcat(QUERY,temp,sizeof(QUERY));
  306. format(temp,sizeof(temp),"`percent`= '%i',",CarInfo[i][carPercent][0]), strcat(QUERY,temp,sizeof(QUERY));
  307. format(temp,sizeof(temp),"`fuel`= '%f',",CarInfo[i][carFuel][0]), strcat(QUERY,temp,sizeof(QUERY));
  308. format(temp,sizeof(temp),"`vehcom_1`= '%i',",CarInfo[i][carVehcom_1][0]), strcat(QUERY,temp,sizeof(QUERY));
  309. format(temp,sizeof(temp),"`vehcom_2`= '%i',",CarInfo[i][carVehcom_2][0]), strcat(QUERY,temp,sizeof(QUERY));
  310. format(temp,sizeof(temp),"`vehcom_3`= '%i',",CarInfo[i][carVehcom_3][0]), strcat(QUERY,temp,sizeof(QUERY));
  311. format(temp,sizeof(temp),"`vehcom_4`= '%i',",CarInfo[i][carVehcom_4][0]), strcat(QUERY,temp,sizeof(QUERY));
  312. format(temp,sizeof(temp),"`vehcom_5`= '%i',",CarInfo[i][carVehcom_5][0]), strcat(QUERY,temp,sizeof(QUERY));
  313. format(temp,sizeof(temp),"`vehcom_6`= '%i',",CarInfo[i][carVehcom_6][0]), strcat(QUERY,temp,sizeof(QUERY));
  314. format(temp,sizeof(temp),"`vehcom_7`= '%i',",CarInfo[i][carVehcom_7][0]), strcat(QUERY,temp,sizeof(QUERY));
  315. format(temp,sizeof(temp),"`vehcom_8`= '%i',",CarInfo[i][carVehcom_8][0]), strcat(QUERY,temp,sizeof(QUERY));
  316. format(temp,sizeof(temp),"`vehcom_9`= '%i',",CarInfo[i][carVehcom_9][0]), strcat(QUERY,temp,sizeof(QUERY));
  317. format(temp,sizeof(temp),"`vehcom_10`= '%i',",CarInfo[i][carVehcom_10][0]), strcat(QUERY,temp,sizeof(QUERY));
  318. format(temp,sizeof(temp),"`vehcom_11`= '%i',",CarInfo[i][carVehcom_11][0]), strcat(QUERY,temp,sizeof(QUERY));
  319. format(temp,sizeof(temp),"`vehcom_12`= '%i',",CarInfo[i][carVehcom_12][0]), strcat(QUERY,temp,sizeof(QUERY));
  320. format(temp,sizeof(temp),"`vehcom_13`= '%i',",CarInfo[i][carVehcom_13][0]), strcat(QUERY,temp,sizeof(QUERY));
  321. format(temp,sizeof(temp),"`vehcom_14`= '%i'",CarInfo[i][carVehcom_14][0]), strcat(QUERY,temp,sizeof(QUERY));
  322. format(temp,sizeof(temp)," WHERE id = '%i'",CarInfo[i][carID][0]), strcat(QUERY,temp,sizeof(QUERY));
  323. mysql_function_query(DATABASE, QUERY, true, "", "");
  324. }
  325. }
  326. return true;
  327. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!