Advertisement
Guest User

Untitled

a guest
Oct 30th, 2016
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.50 KB | None | 0 0
  1. stock SpeichereSpieler(playerid)
  2. {
  3. if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid) && PlayerInfo[playerid][pOnline] == 1)
  4. {
  5. new squery[6000], pName[MAX_PLAYER_NAME], mainquery[7000];
  6.  
  7. format(squery,sizeof(squery),"UPDATE accounts SET `Level` = '%d', `Admin` = '%d', `Ptankekey` = '%d', `DonateRank` = '%d', `Pupgrade` = '%d', `Reg` = '%d', `Sex` = '%d', `Age` = '%d', `Origin` = '%d', `Muted` = '%d', `Exp` = '%d', `Cash` = '%d', `Account` = '%d', `PlayerKreditDauer` = '%d', `PlayerKredit` = '%d', `Crimes` = '%d', `Kills` = '%d', `Deaths` = '%d', `Arrested` = '%d', `ConnectTime` = '%d',",
  8. PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pPtankekey],PlayerInfo[playerid][pDonateRank],PlayerInfo[playerid][pUpgrade],PlayerInfo[playerid][pReg],PlayerInfo[playerid][pSex],PlayerInfo[playerid][pAge],PlayerInfo[playerid][pOrigin],PlayerInfo[playerid][pMuted],PlayerInfo[playerid][pRespekt],GetPlayerMoney(playerid),PlayerInfo[playerid][pAccount],
  9. PlayerInfo[playerid][pPlayerKreditDauer],PlayerInfo[playerid][pPlayerKredit],PlayerInfo[playerid][pCrimes],PlayerInfo[playerid][pKills],PlayerInfo[playerid][pDeaths],PlayerInfo[playerid][pArrested],PlayerInfo[playerid][pConnectTime]);
  10. strcat(mainquery, squery);
  11. strdel(squery, 0, sizeof(squery));
  12.  
  13. format(squery,sizeof(squery),"`WantedDeaths` = '%d', `PhoneBook` = '%d', `LottoNr` = '%d', `Fishes` = '%d', `BiggestFish` = '%d', `Job` = '%d', `Paycheck` = '%d', `Rest` = '%d', `Jailed` = '%d', `JailTime` = '%d', `GangJailed` = '%d', `Mauled` = '%d', `Mats` = '%d', `Drugs` = '%d', `Leader` = '%d', `Punkte` = '%d', `Member` = '%d', `Rank` = '%d', `ContractTime` = '%d', `DetSkill` = '%d',",
  14. squery,PlayerInfo[playerid][pWantedDeaths],PlayerInfo[playerid][pPhoneBook],PlayerInfo[playerid][pLottoNr],PlayerInfo[playerid][pFishes],PlayerInfo[playerid][pBiggestFish],PlayerInfo[playerid][pJob],PlayerInfo[playerid][pPayCheck],PlayerInfo[playerid][pRest], PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][pGangJailed],
  15. PlayerInfo[playerid][pMauled],PlayerInfo[playerid][pMats],PlayerInfo[playerid][pDrugs],PlayerInfo[playerid][pLeader],PlayerInfo[playerid][pPunkte], PlayerInfo[playerid][pMember],PlayerInfo[playerid][pRank],PlayerInfo[playerid][pContractTime], PlayerInfo[playerid][pDetSkill]);
  16. strcat(mainquery, squery);
  17. strdel(squery, 0, sizeof(squery));
  18.  
  19. format(query,sizeof(query),"`SexSkill` = '%d', `BoxSkill` = '%d', `LawSkill` = '%d', `MechSkill` = '%d', `JackSkill` = '%d', `CarSkill` = '%d', `NewsSkill` = '%d', `DrugsSkill` = '%d', `CookSkill` = '%d', `FishSkill` = '%d', `pHealth` = '%.2f', `pSHealth` = '%.2f', `Local` = '%d', `Team` = '%d', `Model` = '%d', `Pnumber` = '%d', `Phousekey` = '%d', `Pbiskey` = '%d', `Pos_x` = '%.2f', `Pos_y` = '%.2f', `Pos_z` = '%.2f' WHERE Name = '%s'",
  20. PlayerInfo[playerid][pSexSkill],PlayerInfo[playerid][pBoxSkill],PlayerInfo[playerid][pLawSkill],PlayerInfo[playerid][pMechSkill],PlayerInfo[playerid][pJackSkill],PlayerInfo[playerid][pCarSkill],PlayerInfo[playerid][pNewsSkill],PlayerInfo[playerid][pDrugsSkill],PlayerInfo[playerid][pCookSkill],PlayerInfo[playerid][pFishSkill],PlayerInfo[playerid][pHealth],
  21. PlayerInfo[playerid][pSHealth],PlayerInfo[playerid][pLocal],PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pModel],PlayerInfo[playerid][pPhoneNumber],PlayerInfo[playerid][pHouseKey],PlayerInfo[playerid][pBizKey],PlayerInfo[playerid][pPos_x], PlayerInfo[playerid][pPos_y],PlayerInfo[playerid][pPos_z], pName);
  22. strcat(mainquery, squery);
  23. strdel(squery, 0, sizeof(squery));
  24.  
  25. mysql_function_query(dbHandle, mainquery, false, "", "");
  26. strdel(mainquery, 0, sizeof(mainquery));
  27.  
  28. //=======: Query 2 :=======//
  29. format(query,sizeof(query),"UPDATE accounts SET `CarLic` = '%d', `FlyLic` = '%d', `BoatLic` = '%d', `FishLic` = '%d', `GunLic` = '%d', `LKWLic` = '%d', `RollerLic` = '%d', `MotoLic` = '%d', `Zig` = '%d', `Kekse` = '%d', `ZigSucht` = '%d', `CarTime` = '%d',",
  30. PlayerInfo[playerid][pCarLic],PlayerInfo[playerid][pFlyLic], PlayerInfo[playerid][pBoatLic],PlayerInfo[playerid][pFishLic],PlayerInfo[playerid][pGunLic],PlayerInfo[playerid][pTruckLic],PlayerInfo[playerid][pMotoLic],PlayerInfo[playerid][pRollerLic],PlayerInfo[playerid][pZig],PlayerInfo[playerid][pKekse],PlayerInfo[playerid][pZigSucht],PlayerInfo[playerid][pCarTime]);
  31. strcat(mainquery, squery);
  32. strdel(squery, 0, sizeof(squery));
  33. format(query,sizeof(query),"`Plastiksprengstoff` = '%d', `PayDay` = '%d', `PayDayHad` = '%d', `CDPlayer` = '%d', `Loses` = '%d', `DrugPerk` = '%d', `MiserPerk` = '%d', `PainPerk` = '%d', `AlcoholPerk` = '%d', `TraderPerk` = '%d', `Warns` = '%d', `GWD` = '%d', `Fuel` = '%d', `Married` = '%d', `MarriedTo` = '%s', `InvDrugs` = '%d', `InvMats` = '%d', `FlugTime` = '%d',",
  34. PlayerInfo[playerid][pPlastikSprengstoff],PlayerInfo[playerid][pPayDay],PlayerInfo[playerid][pPayDayHad],PlayerInfo[playerid][pCDPlayer],PlayerInfo[playerid][pLoses],PlayerInfo[playerid][pDrugPerk],PlayerInfo[playerid][pMiserPerk],PlayerInfo[playerid][pPainPerk],PlayerInfo[playerid][pAlcoholPerk],PlayerInfo[playerid][pTraderPerk],
  35. PlayerInfo[playerid][pWarns],PlayerInfo[playerid][pGWD], PlayerInfo[playerid][pFuel],PlayerInfo[playerid][pMarried],PlayerInfo[playerid][pMarriedTo],PlayerInfo[playerid][pInvDrugs],PlayerInfo[playerid][pInvMats],PlayerInfo[playerid][pFlugTime]);
  36. strcat(mainquery, squery);
  37. strdel(squery, 0, sizeof(squery));
  38. format(query,sizeof(query),"`ErntTimer` = '%d', `InvadeTime` = '%d', `Roadblock` = '%d', `PlayMinutes` = '%d', `GesamtMinutes` = '%d', `MinutesSinceLogin` = '%d', `MinutesSinceAn` = '%d', `SFPASS` = '%d', `LVPASS` = '%d', `HandyGeld` = '%d', `HandyVer` = '%d', `UhrID` = '%d', `HandyID` = '%d', `OwnPerso` = '%d', `Tx` = '%.2f', `Ty` = '%.2f', `Tz` = '%.2f',",
  39. PlayerInfo[playerid][pErntTimer],PlayerInfo[playerid][pInvadeTime],PlayerInfo[playerid][pRoadblock],PlayerInfo[playerid][pPlayMinutes],PlayerInfo[playerid][pGesamtMinutes],PlayerInfo[playerid][pMinutesSinceLogin],PlayerInfo[playerid][pMinutesSinceAn],PlayerInfo[playerid][pSFPASS],PlayerInfo[playerid][pLVPASS],PlayerInfo[playerid][pHandyGeld],PlayerInfo[playerid][pHandyVer], PlayerInfo[playerid][pUhrID],
  40. PlayerInfo[playerid][pHandyID], PlayerInfo[playerid][pOwnPerso],PlayerInfo[playerid][pTx],PlayerInfo[playerid][pTy],PlayerInfo[playerid][pTz],pName);
  41. strcat(mainquery, squery);
  42. strdel(squery, 0, sizeof(squery));
  43. format(query,sizeof(query),"`Gehalt` = '%d',`FrakSperre` = '%d',`BoxMats` = '%d',`BoxDrugs` = '%d',`ban` = '%d',`Tot` = '%d',`FarmTime` = '%d',`GDeaths` = '%d',`GKills` = '%d',`Meldung` = '%d',`EXP` = '%d',`Akku` = '%d',`Fahrzeuge` = '%d',`Online` = '0',`Fahndungslevel` = '%d',`AcceptTickets` = '%d' WHERE `Name` = '%s'",
  44. PlayerInfo[playerid][pGehalt],PlayerInfo[playerid][pFrakSperre],PlayerInfo[playerid][pBoxMats],PlayerInfo[playerid][pBoxDrugs],PlayerInfo[playerid][pban],PlayerInfo[playerid][pTot],PlayerInfo[playerid][pFarmTime],PlayerInfo[playerid][pGDeaths],PlayerInfo[playerid][pGKills],PlayerInfo[playerid][pMeldung],PlayerInfo[playerid][pRespekt],PlayerInfo[playerid][pHandyAkku],PlayerInfo[playerid][pVehicles],WantedLevel[playerid],PlayerInfo[playerid][AcceptTickets],pName);
  45. strcat(mainquery, squery);
  46. strdel(squery, 0, sizeof(squery));
  47. mysql_function_query(dbHandle, mainquery, false, "", "");
  48. strdel(mainquery, 0, sizeof(mainquery));
  49.  
  50. format(query,sizeof(query),"SELECT * FROM `vehicles` WHERE `besitzer` = '%s'", pName);
  51. mysql_function_query(dbHandle, query, true, "SaveVehicles", "i", playerid);
  52. }
  53. return true;
  54. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement