Advertisement
Guest User

Untitled

a guest
Apr 30th, 2017
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.30 KB | None | 0 0
  1. protected sql_OnPlayerRegister(playerid)
  2. {
  3. PI[playerid][pID] = cache_insert_id();
  4. SavePlayer(playerid);
  5. return 1;
  6. }
  7. SavePlayer(playerid) {
  8. static query[4000];
  9.  
  10. mysql_format(SQL, query, sizeof query, "UPDATE `korisnici` SET `Ime`= '%s', `Sifra`= '%d', `Email`= '%s', `Nivo`= '%d', `Banovan`= '%d', `Admin`= '%d', `GM`= '%d', `Donator`= '%d'",
  11. GetName(playerid), PI[playerid][Sifra], PI[playerid][Email], PI[playerid][Nivo], PI[playerid][Banovan], PI[playerid][Admin], PI[playerid][GM], PI[playerid][Donator]);
  12.  
  13. mysql_format(SQL, query, sizeof query, "%s, `Novac`= '%d', `Banka`= '%d', `Iskustvo`= '%d', `SatiIgre`= '%d', `Poreklo`= '%s', `Godine`= '%d', `Pol`= '%d', `Skin`= '%d', `Clan`= '%d'",
  14. query, PI[playerid][Novac], PI[playerid][Banka], PI[playerid][Iskustvo], PI[playerid][SatiIgre], PI[playerid][Poreklo], PI[playerid][Godine], PI[playerid][Pol], PI[playerid][Skin],
  15. PI[playerid][Clan]);
  16.  
  17. mysql_format(SQL, query, sizeof query, "%s, `Lider`= '%d', `Rank`= '%d', `Kuca`= '%d', `Stan`= '%d', `Vikendica`= '%d', `Firma`= '%d', `Firma2`= '%d', `Firma3`= '%d', `Garaza`= '%d'",
  18. query, PI[playerid][Lider], PI[playerid][Rank], PI[playerid][Kuca], PI[playerid][Stan], PI[playerid][Vikendica], PI[playerid][Firma], PI[playerid][Firma2], PI[playerid][Firma3],
  19. PI[playerid][Garaza]);
  20.  
  21. mysql_format(SQL, query, sizeof query, "%s, `Hotel`= '%d', `Auto1`= '%d', `Auto2`= '%d', `Auto3`= '%d', `Auto4`= '%d', `Auto5`= '%d', `Zatvoren`= '%d', `ZatvorenVreme`= '%d', `Utisan`= '%d'",
  22. query, PI[playerid][Hotel], PI[playerid][Auto1], PI[playerid][Auto2], PI[playerid][Auto3], PI[playerid][Auto4], PI[playerid][Auto5], PI[playerid][Zatvoren], PI[playerid][ZatvorenVreme],
  23. PI[playerid][Utisan]);
  24.  
  25. mysql_format(SQL, query, sizeof query, "%s, `Opomenut`= '%d', `KaznjenPuta`= '%d', `Telefon`= '%d', `Mobilni`= '%d', `KreditMobilni`= '%d', `SakrivanjeBroja`= '%d', `MozeDaGasiMobilni`= '%d', `MozeDaGasiSapat`= '%d', `MozeDaGasiFamily`= '%d'",
  26. query, PI[playerid][Opomenut], PI[playerid][KaznjenPuta], PI[playerid][Telefon], PI[playerid][Mobilni], PI[playerid][KreditMobilni], PI[playerid][SakrivanjeBroja], PI[playerid][MozeDaGasiMobilni], PI[playerid][MozeDaGasiSapat],
  27. PI[playerid][MozeDaGasiFamily]);
  28.  
  29. mysql_format(SQL, query, sizeof query, "%s, `DozvolaOruzje`= '%d', `VozackaDozvola`= '%d', `DozvolaPlovidba`= '%d', `DozvolaLetenje`= '%d', `Kokain`= '%d', `Cannabis`= '%d', `SemeCannabis`= '%d', `SemeKokain`= '%d', `IznosRate`= '%d'",
  30. query, PI[playerid][DozvolaOruzje], PI[playerid][VozackaDozvola], PI[playerid][DozvolaPlovidba], PI[playerid][DozvolaLetenje], PI[playerid][Kokain], PI[playerid][Cannabis], PI[playerid][SemeCannabis], PI[playerid][SemeKokain],
  31. PI[playerid][IznosRate]);
  32.  
  33. mysql_format(SQL, query, sizeof query, "%s, `IznosKredita`= '%d', `PreostaloZaOtplatu`= '%d', `Posao`= '%d', `IRCAdmin`= '%d', `IRCSoba`= '%d', `IRCSobaAdmin`= '%d', `PayDayPoeni`= '%d', `TimUgovor`= '%d', `KaznaUgovor`= '%d'",
  34. query, PI[playerid][IznosKredita], PI[playerid][PreostaloZaOtplatu], PI[playerid][Posao], PI[playerid][IRCAdmin], PI[playerid][IRCSoba], PI[playerid][IRCSobaAdmin], PI[playerid][PayDayPoeni], PI[playerid][TimUgovor],
  35. PI[playerid][KaznaUgovor]);
  36.  
  37. mysql_format(SQL, query, sizeof query, "%s, `UBraku`= '%d', `UBrakuSa`= '%s', `Ubistava`= '%d', `Smrti`= '%d', `Zlocini`= '%d', `UhapsenPuta`= '%d', `TrazeniNivo`= '%d', `Dolazak`= '%d', `Religija`= '%s'",
  38. query, PI[playerid][UBraku], PI[playerid][UBrakuSa], PI[playerid][Ubistava], PI[playerid][Smrti], PI[playerid][Zlocini], PI[playerid][UhapsenPuta], PI[playerid][TrazeniNivo], PI[playerid][Dolazak],
  39. PI[playerid][Religija]);
  40.  
  41. mysql_format(SQL, query, sizeof query, "%s, `Kartica`= '%s', `StariPosao`= '%s', `Spawn`= '%d', `Zavezan`= '%d', `PosaoUgovor`= '%d', `MehanicarOdvoz`= '%d', `DzeparosVreme`= '%d', `KradljivacVreme`= '%d', `DeeJay`= '%d'",
  42. query, PI[playerid][Kartica], PI[playerid][StariPosao], PI[playerid][Spawn], PI[playerid][Zavezan], PI[playerid][PosaoUgovor], PI[playerid][MehanicarOdvoz], PI[playerid][DzeparosVreme], PI[playerid][KradljivacVreme],
  43. PI[playerid][DeeJay]);
  44.  
  45. mysql_format(SQL, query, sizeof query, "%s, `Ucena`= '%d', `DatumRegistracije`= '%s', `PoslednjaAktivnost`= '%s', `MestoUOrg`= '%d', `Renta`= '%d', `RentaHotel`= '%d', `RegProces`= '%d', `Frizura`= '%d', `BorbeniStil`= '%d'",
  46. query, PI[playerid][Ucena], PI[playerid][DatumRegistracije], PI[playerid][PoslednjaAktivnost], PI[playerid][MestoUOrg], PI[playerid][Renta], PI[playerid][RentaHotel], PI[playerid][RegProces], PI[playerid][Frizura],
  47. PI[playerid][BorbeniStil]);
  48.  
  49. mysql_format(SQL, query, sizeof query, "%s, `KarticaPin`= '%d', `MobilniMarka`= '%s', `MobilniMreza`= '%s', `AlatZaObijanje`= '%d', `Kaciga`= '%d', `Double`= '%d', `xBoombox`= '%d', `Lotto`= '%d', `Kazna`= '%d'",
  50. query, PI[playerid][KarticaPin], PI[playerid][MobilniMarka], PI[playerid][MobilniMreza], PI[playerid][AlatZaObijanje], PI[playerid][Kaciga], PI[playerid][Double], PI[playerid][xBoombox], PI[playerid][Lotto],
  51. PI[playerid][Kazna]);
  52.  
  53. mysql_format(SQL, query, sizeof query, "%s, `FlashVrijem`= '%d', `StaffPin`= '%d', `Promoter`= '%d', `VIP`= '%d', `RPPoeni`= '%d', `SnimanjeRacuna`= '%d', `AdminID`= '%d', `GameMasterID`= '%d', `StaffSlot`= '%d'",
  54. query, PI[playerid][FlashVrijem], PI[playerid][StaffPin], PI[playerid][Promoter], PI[playerid][VIP], PI[playerid][RPPoeni], PI[playerid][SnimanjeRacuna], PI[playerid][AdminID], PI[playerid][GameMasterID],
  55. PI[playerid][StaffSlot]);
  56.  
  57. mysql_format(SQL, query, sizeof query, "%s, `DonatorSlot4`= '%d', `DonatorSlot5`= '%d', `RobTime`= '%d', `Event1Mesto`= '%d', `Event2Mesto`= '%d', `Event3Mesto`= '%d', `MaskID`= '%d', `LiderSati`= '%d', `Trafika_ID`= '%d'",
  58. query, PI[playerid][DonatorSlot4], PI[playerid][DonatorSlot5], PI[playerid][RobTime], PI[playerid][Event1Mesto], PI[playerid][Event2Mesto], PI[playerid][Event3Mesto], PI[playerid][MaskID], PI[playerid][LiderSati],
  59. PI[playerid][Trafika_ID]);
  60.  
  61. mysql_format(SQL, query, sizeof query, "%s, `Bilbord`= '%d', `LicnaKarta`= '%d', `Zdravstvena`= '%d', `Pasos`= '%d', `pOruzje1`= '%d', `pMunicija1`= '%d', `pOruzje2`= '%d', `pMunicija2`= '%d', `pOruzje3`= '%d'",
  62. query, PI[playerid][Bilbord], PI[playerid][LicnaKarta], PI[playerid][Zdravstvena], PI[playerid][Pasos], PI[playerid][pOruzje1], PI[playerid][pMunicija1], PI[playerid][pOruzje2], PI[playerid][pMunicija2],
  63. PI[playerid][pOruzje3]);
  64.  
  65. mysql_format(SQL, query, sizeof query, "%s, `pMunicija3`= '%d', `IzbacenRazlog`= '%s', `AreaRazlog`= '%s', `SOpomena`= '%d', `LiderOpomena`= '%d', `VipVreme`= '%d', `VipGunTime`= '%d', `PromoterAdmin`= '%d', `PromoterSlot`= '%d'",
  66. query, PI[playerid][pMunicija3], PI[playerid][IzbacenRazlog], PI[playerid][AreaRazlog], PI[playerid][SOpomena], PI[playerid][LiderOpomena], PI[playerid][VipVreme], PI[playerid][VipGunTime], PI[playerid][PromoterAdmin],
  67. PI[playerid][PromoterSlot]);
  68.  
  69. mysql_format(SQL, query, sizeof query, "%s, `xDinamit`= '%d', `xLaptop`= '%d', `Zlato`= '%d', `AdminVreme`= '%d', `GMVreme`= '%d', `Materijali`= '%d', `PlatniRacun`= '%d'",
  70. query, PI[playerid][xDinamit], PI[playerid][xLaptop], PI[playerid][Zlato], PI[playerid][AdminVreme], PI[playerid][GMVreme], PI[playerid][Materijali], PI[playerid][PlatniRacun]);
  71.  
  72. mysql_format(SQL, query, sizeof query, "%s, WHERE `ID` = '%d' LIMIT 1",
  73. query,
  74. PI[playerid][pID]
  75. );
  76.  
  77. mysql_tquery(SQL, query, "");
  78.  
  79. return 1;
  80. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement