API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Oct 28th, 2016
129
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.41 KB | None | 0 0
raw download clone embed print report
  1. stock SavePlayer(playerid)
  2. {
  3. if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
  4. {
  5. new mainQuery[2046], secondQuery[512];
  6. format(secondQuery, sizeof(secondQuery), "UPDATE `script_accounts` SET `Level`='%d', `Admin`='%d', `SpawnHealth`='%f', `PayDay`='%d', `Exp`='%d', `Fraktion`='%d', ",
  7. Spieler[playerid][pLevel], Spieler[playerid][pAdmin], Spieler[playerid][pSpawnHealth],
  8. Spieler[playerid][pPayDay], Spieler[playerid][pExp], Spieler[playerid][pFraktion]);
  9. strcat(mainQuery, secondQuery);
  10.  
  11. format(secondQuery, sizeof(secondQuery), "`Tutorial`='%d', `Skin`='%d', `FrakSkin`='%d', `Geschlecht`='%d', `Perso`='%d', `CarLicense`='%d', `CarLicensePoints`='%d', `Wanteds`='%d', ",
  12. Spieler[playerid][pTutorial], Spieler[playerid][pSkin], Spieler[playerid][pFrakSkin],
  13. Spieler[playerid][pGeschlecht], Spieler[playerid][pPerso],
  14. Spieler[playerid][pCarLicense], Spieler[playerid][pCarLicensePoints],
  15. Spieler[playerid][pWanteds], GetName(playerid));
  16. strcat(mainQuery, secondQuery);
  17.  
  18. format(secondQuery, sizeof(secondQuery), "`JobMoney`='%d', `JobCount`='%d', `BusSkill`='%d', `BusSkillEXP`='%d', `Tot`='%d', `TotUnix`='%d', `TotX`='%f', `TotY`='%f', `TotZ`='%f', `Kills`='%d', `Deaths`='%d', `Jailed`='%d', `JailTime`='%d', ",
  19. Spieler[playerid][pJobMoney], Spieler[playerid][pJobCount], Spieler[playerid][pBusSkill], Spieler[playerid][pBusSkillEXP],
  20. Spieler[playerid][pTot], Spieler[playerid][pTotUnix], Spieler[playerid][pTotX], Spieler[playerid][pTotY], Spieler[playerid][pTotZ],
  21. Spieler[playerid][pKills], Spieler[playerid][pDeaths], Spieler[playerid][pJailed], Spieler[playerid][pJailTime]);
  22. strcat(mainQuery, secondQuery);
  23.  
  24. format(secondQuery, sizeof(secondQuery), "`Rank`='%d', `Verbrechen`='%d', `JailType`='%d', `Banned`='%d', `BanReason`='%s', `BanAdmin`='%s', `Erstehilfe`='%d', ",
  25. Spieler[playerid][pRank], Spieler[playerid][pVerbrechen], Spieler[playerid][pJailType], Spieler[playerid][pBanned], Spieler[playerid][pBanReason], Spieler[playerid][pBanAdmin],
  26. Spieler[playerid][pErstehilfe]);
  27. strcat(mainQuery, secondQuery);
  28.  
  29. format(secondQuery, sizeof(secondQuery), "`Number`='%d', `Handy`='%d', `HandyStatus`='%d', `HandyGuthaben`='%d', `Akku`='%f', `DetektivSkill`='%d', `DetektivSkillEXP`='%d', ",
  30. Spieler[playerid][pNumber], Spieler[playerid][pHandy], Spieler[playerid][pHandyStatus], Spieler[playerid][pHandyGuthaben], Spieler[playerid][pAkku], Spieler[playerid][pDetektivSkill], Spieler[playerid][pDetektivSkillEXP]);
  31. strcat(mainQuery, secondQuery);
  32.  
  33. format(secondQuery, sizeof(secondQuery), "`PlayTime`='%d', `Warns`='%d', `Crimes`='%d', `JailVisits`='%d', `Eisen`='%d', `EisenSafe`='%d', `Marihuana`='%d', ",
  34. Spieler[playerid][pPlayTime], Spieler[playerid][pWarns], Spieler[playerid][pCrimes], Spieler[playerid][pJailVisits], Spieler[playerid][pEisen], Spieler[playerid][pEisenSafe], Spieler[playerid][pMarihuana]);
  35. strcat(mainQuery, secondQuery);
  36.  
  37. format(secondQuery, sizeof(secondQuery), "`MarihuanaSafe`='%d', `Kanister`='%d', `Verheiratet`='%d', `VerheiratetName`='%s', `Bank`='%d', `Premium`='%d', `SkillPoints`='%d', ",
  38. Spieler[playerid][pMarihuanaSafe], Spieler[playerid][pKanister], Spieler[playerid][pVerheiratet], Spieler[playerid][pVerheiratetName], Spieler[playerid][pBank], Spieler[playerid][pPremium], Spieler[playerid][pSkillPoints]);
  39. strcat(mainQuery, secondQuery);
  40.  
  41. format(secondQuery, sizeof(secondQuery), "`FlyLicense`='%d', `BoatLicense`='%d', `FishLicense`='%d', `GunLicense`='%d', `Zollpass`='%d', `Job`='%d', `Money`='%d', `QuitJob`='%d' WHERE `Name`='%s'",
  42. Spieler[playerid][pFlyLicense], Spieler[playerid][pBoatLicense], Spieler[playerid][pFishLicense],
  43. Spieler[playerid][pGunLicense], Spieler[playerid][pZollpass], Spieler[playerid][pJob], GetMoney(playerid), Spieler[playerid][pQuitJob], GetName(playerid));
  44. strcat(mainQuery, secondQuery);
  45.  
  46. mysql_function_query(myCon, mainQuery, false, "", "");
  47. strdel(mainQuery, 0, sizeof(mainQuery));
  48. strdel(secondQuery, 0, sizeof(secondQuery));
  49.  
  50.  
  51. // Neuer Query für Save
  52. format(secondQuery, sizeof(secondQuery), "UPDATE `script_accounts` SET `Muted`='%d', `MuteReason`='%s', `TruckSkill`='%d', `TruckSkillEXP`='%d', `SpawnChange`='%d', `PremiumZeit`='%d', ",
  53. Spieler[playerid][pMuted], Spieler[playerid][pMuteReason], Spieler[playerid][pTruckSkill], Spieler[playerid][pTruckSkillEXP], Spieler[playerid][pSpawnChange], Spieler[playerid][pPremiumZeit]);
  54. strcat(mainQuery, secondQuery);
  55.  
  56. format(secondQuery, sizeof(secondQuery), "`FishSkill`='%d', `FishSkillEXP`='%d', `OrgMember`='%d', `Contract`='%d', `ContractCount`='%d', `LastLogin`='%d', `IsEhrenhaft`='%d', ",
  57. Spieler[playerid][pFishSkill], Spieler[playerid][pFishSkillEXP], Spieler[playerid][pOrgMember], Spieler[playerid][pContract], Spieler[playerid][pContractCount], gettime(), Spieler[playerid][pIsEhrenhaft]);
  58. strcat(mainQuery, secondQuery);
  59.  
  60. format(secondQuery, sizeof(secondQuery), "`HouseKey`='%d', `TotWorld`='%d', `Hitsound`='%d', `Messages`='%d', `Fished`='%d', `FishTime`='%d', `FishSperre`='%d', `SkillDrug`='%f' WHERE `Name`='%s'",
  61. Spieler[playerid][pHouseKey], Spieler[playerid][pTotWorld], Spieler[playerid][pHitsound], Spieler[playerid][pMessages], Spieler[playerid][pFished], Spieler[playerid][pFishTime], Spieler[playerid][pFishSperre], Spieler[playerid][pSkillDrug], GetName(playerid));
  62. strcat(mainQuery, secondQuery);
  63.  
  64. mysql_function_query(myCon, mainQuery, false, "", "");
  65. strdel(mainQuery, 0, sizeof(mainQuery));
  66. strdel(secondQuery, 0, sizeof(secondQuery));
  67.  
  68. // Fish
  69. format(secondQuery, sizeof(secondQuery), "UPDATE `script_accounts` SET `FishID1`='%d', `FishID2`='%d', `FishID3`='%d', `FishID4`='%d', `FishID5`='%d',",
  70. Spieler[playerid][pFishID][1], Spieler[playerid][pFishID][2], Spieler[playerid][pFishID][3], Spieler[playerid][pFishID][4], Spieler[playerid][pFishID][5]);
  71. strcat(mainQuery, secondQuery);
  72. format(secondQuery, sizeof(secondQuery), " `Fishweight1`='%d', `Fishweight2`='%d', `Fishweight3`='%d', `Fishweight4`='%d', `Fishweight5`='%d' WHERE `Name`='%s'",
  73. Spieler[playerid][pFishweight][1], Spieler[playerid][pFishweight][2], Spieler[playerid][pFishweight][3], Spieler[playerid][pFishweight][4], Spieler[playerid][pFishweight][5], GetName(playerid));
  74. strcat(mainQuery, secondQuery);
  75.  
  76. mysql_function_query(myCon, mainQuery, false, "", "");
  77. strdel(mainQuery, 0, sizeof(mainQuery));
  78. strdel(secondQuery, 0, sizeof(secondQuery));
  79.  
  80. format(secondQuery, sizeof(secondQuery), "UPDATE `script_accounts` SET `CookID1`='%d', `CookID2`='%d', `CookID3`='%d', `CookID4`='%d', `CookID5`='%d',",
  81. Spieler[playerid][pCookID][1], Spieler[playerid][pCookID][2], Spieler[playerid][pCookID][3], Spieler[playerid][pCookID][4], Spieler[playerid][pCookID][5]);
  82. strcat(mainQuery, secondQuery);
  83. format(secondQuery, sizeof(secondQuery), " `CookHP1`='%d', `CookHP1`='%d', `CookHP1`='%d', `CookHP1`='%d', `CookHP1`='%d' WHERE `Name`='%s'",
  84. Spieler[playerid][pCookHP][1], Spieler[playerid][pCookHP][2], Spieler[playerid][pCookHP][3], Spieler[playerid][pCookHP][4], Spieler[playerid][pCookHP][5], GetName(playerid));
  85. strcat(mainQuery, secondQuery);
  86.  
  87. mysql_function_query(myCon, mainQuery, false, "", "");
  88. strdel(mainQuery, 0, sizeof(mainQuery));
  89. strdel(secondQuery, 0, sizeof(secondQuery));
  90.  
  91. for(new vehSlot=0;vehSlot<MAX_PLAYER_VEHICLES;vehSlot++)
  92. {
  93. if(!strcmp(GetName(playerid), PrivateVehicle[playerid][vehSlot][vehBesitzer], true))
  94. {
  95. if(PrivateVehicle[playerid][vehSlot][modelid] != 0)
  96. {
  97. format(secondQuery, sizeof(secondQuery), "UPDATE `script_vehicles` SET `modelid`='%d', `vehPosX`='%f', `vehPosY`='%f', `vehPosZ`='%f', `vehPosA`='%f', `vehHealth`='%f', ",
  98. PrivateVehicle[playerid][vehSlot][modelid],
  99. PrivateVehicle[playerid][vehSlot][vehPosX],
  100. PrivateVehicle[playerid][vehSlot][vehPosY],
  101. PrivateVehicle[playerid][vehSlot][vehPosZ],
  102. PrivateVehicle[playerid][vehSlot][vehPosA],
  103. PrivateVehicle[playerid][vehSlot][vehHealth]);
  104. strcat(mainQuery, secondQuery);
  105. format(secondQuery, sizeof(secondQuery), "`vehColor1`='%d', `vehColor2`='%d', `vehPaintjob`='%d', `vehSpoiler`='%d', `vehHood`='%d', ",
  106. PrivateVehicle[playerid][vehSlot][vehColor1],
  107. PrivateVehicle[playerid][vehSlot][vehColor2],
  108. PrivateVehicle[playerid][vehSlot][vehPaintjob],
  109. PrivateVehicle[playerid][vehSlot][vehSpoiler],
  110. PrivateVehicle[playerid][vehSlot][vehHood]);
  111. strcat(mainQuery, secondQuery);
  112. format(secondQuery, sizeof(secondQuery), "`vehRoof`='%d', `vehSideskirt`='%d', `vehLamps`='%d', `vehNitro`='%d', `vehExhaust`='%d', ",
  113. PrivateVehicle[playerid][vehSlot][vehRoof],
  114. PrivateVehicle[playerid][vehSlot][vehSideskirt],
  115. PrivateVehicle[playerid][vehSlot][vehLamps],
  116. PrivateVehicle[playerid][vehSlot][vehNitro],
  117. PrivateVehicle[playerid][vehSlot][vehExhaust]);
  118. strcat(mainQuery, secondQuery);
  119. format(secondQuery, sizeof(secondQuery), "`vehWheels`='%d', `vehStereo`='%d', `vehHydraulics`='%d', `vehFrontBumper`='%d', `vehRearBumper`='%d', ",
  120. PrivateVehicle[playerid][vehSlot][vehWheels],
  121. PrivateVehicle[playerid][vehSlot][vehStereo],
  122. PrivateVehicle[playerid][vehSlot][vehHydraulics],
  123. PrivateVehicle[playerid][vehSlot][vehFrontBumper],
  124. PrivateVehicle[playerid][vehSlot][vehRearBumper]);
  125. strcat(mainQuery, secondQuery);
  126. format(secondQuery, sizeof(secondQuery), "`vehVentRight`='%d', `vehVentLeft`='%d', `vehPreis`='%d', `vehNeonID`='%d', `vehNumberPlate`='%s', `vehFuel`='%f', ",
  127. PrivateVehicle[playerid][vehSlot][vehVentRight],
  128. PrivateVehicle[playerid][vehSlot][vehVentLeft],
  129. PrivateVehicle[playerid][vehSlot][vehPreis],
  130. PrivateVehicle[playerid][vehSlot][vehNeonID],
  131. PrivateVehicle[playerid][vehSlot][vehNumberPlate],
  132. Vehicle[PrivateVehicle[playerid][vehSlot][vehID]][vehFuel]);
  133. strcat(mainQuery, secondQuery);
  134. format(secondQuery, sizeof(secondQuery), "`vehKMStand`='%f', `vehInterior`='%d', `vehWorld`='%d' WHERE `vehBesitzer`='%s' AND `Slot`='%d'",
  135. Vehicle[PrivateVehicle[playerid][vehSlot][vehID]][vehKMStand],
  136. PrivateVehicle[playerid][vehSlot][vehInterior],
  137. PrivateVehicle[playerid][vehSlot][vehWorld],
  138. PrivateVehicle[playerid][vehSlot][vehBesitzer],
  139. vehSlot);
  140. strcat(mainQuery, secondQuery);
  141. mysql_function_query(myCon, mainQuery, false, "", "");
  142. strdel(mainQuery, 0, sizeof(mainQuery));
  143. strdel(secondQuery, 0, sizeof(secondQuery));
  144. }
  145. }
  146. }
  147. }
  148. return 1;
  149. }
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!