Jochemd

Untitled

Dec 30th, 2012
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Pawn 5.23 KB | None | 0 0
  1. stock SavePlayerData(playerid)
  2. {
  3.     if (GetPVarInt(playerid, "Spawned") == 1)
  4.     {
  5.  
  6.         mysql_format(1,QueryString,
  7.             "UPDATE `PlayerData` SET Score = %d, Cash = %d, Admin = %d, Radio = %d, Warnings = %d, Ban = %d, VIP = %d, OwnSkin = %d, AbleToChangeSkin = %d, LastActive = %d, TicketID = %d, Taskbook = %d,  AdminSince = '%s', Distance = %f, TurboMode = %d, DonationPoints = %d, Insurance = %d, Wanted = %d, Trusted = %d, BlockPolice = %d, CouponUsed = %d, PremiumVIP = %d, PremiumVIPSlot = %d, PremiumBusinessUpgrades = %d, PremiumHouseUpgrades = %d, LastFined = %d WHERE `PlayerName` = '%s'",
  8.             PlayerData[playerid][Score], PlayerData[playerid][Cash], PlayerData[playerid][Admin], PlayerData[playerid][ListeningTo],
  9.             PlayerData[playerid][Warnings],PlayerData[playerid][BanTime], PlayerData[playerid][VIP],PlayerData[playerid][OwnSkin],PlayerData[playerid][AbleToChangeSkin],PlayerData[playerid][LastActive],PlayerData[playerid][TicketID],PlayerData[playerid][Taskbook],PlayerData[playerid][AdminSince],
  10.             PlayerData[playerid][Dist],PlayerData[playerid][TurboMode],PlayerData[playerid][DonationPoints],PlayerData[playerid][VehInsurance],GetPlayerWantedLevel(playerid),PlayerData[playerid][Trusted],PlayerData[playerid][BlockPolice],PlayerData[playerid][CouponUsed],PlayerData[playerid][PremiumVIP],
  11.             PlayerData[playerid][PremiumVIPSlot],PlayerData[playerid][PremiumBusinessUpgrades],PlayerData[playerid][PremiumHouseUpgrades],  PlayerName(playerid));
  12.         mysql_function_query(1,QueryString,false,"SomeNotExistingCallback","","");
  13.  
  14.  
  15.  
  16.         for (new i=0;i<MAX_OWNED_VEHICLES;i++)
  17.         {
  18.             new form[18][20];
  19.             format(form[0],20,"CarModel%d", i);
  20.             if (PlayerData[playerid][CarModel][i] > 0)
  21.             {
  22.                 format(form[1],20,"CarNitro%d", i);
  23.                 format(form[2],20,"CarWheels%d", i);
  24.                 format(form[3],20,"CarSpoiler%d", i);
  25.                 format(form[4],20,"CarLamps%d", i);
  26.                 format(form[5],20,"CarSideSkirt%d", i);
  27.                 format(form[6],20,"CarHydraulics%d", i);
  28.                 format(form[7],20,"CarColor1%d", i);
  29.                 format(form[8],20,"CarColor2%d", i);
  30.                 format(form[9],20,"CarHood%d", i);
  31.                 format(form[10],20,"CarRoof%d", i);
  32.                 format(form[11],20,"CarExhaust%d", i);
  33.                 format(form[12],20,"CarRearbumper%d", i);
  34.                 format(form[13],20,"CarFrontbumper%d", i);
  35.                 format(form[14],20,"CarVentleft%d", i);
  36.                 format(form[15],20,"CarVentright%d", i);
  37.                 format(form[16],20,"CarPaintjob%d", i);
  38.                 format(form[17],20,"CarAngle%d", i);
  39.             }
  40.  
  41.             mysql_format(1,QueryString,"UPDATE `PlayerData` SET `%s` = %d, `%s` = %d, `%s` = %d, `%s` = %d, `%s` = %d, `%s` = %d, `%s` = %d, `%s` = %d, `%s` = %d, `%s` = %d, `%s` = %d, `%s` = %d, `%s` = %d, `%s` = %d, `%s` = %d, `%s` = %d, `%s` = %d, `%s` = %f WHERE `PlayerName` = '%s'",
  42.             form[0],PlayerData[playerid][CarModel][i],form[1],PlayerData[playerid][CarNitro][i],form[2],PlayerData[playerid][CarWheels][i],form[3],PlayerData[playerid][CarSpoiler][i],form[4],PlayerData[playerid][CarLamps][i],form[5],PlayerData[playerid][CarSideSkirt][i],form[6],PlayerData[playerid][CarHydraulics][i],
  43.             form[7],PlayerData[playerid][CarColor1][i],form[8],PlayerData[playerid][CarColor2][i],form[9],PlayerData[playerid][CarHood][i],form[10],PlayerData[playerid][CarRoof][i],form[11],PlayerData[playerid][CarExhaust][i],form[12],PlayerData[playerid][CarRearbumper][i],form[13],PlayerData[playerid][CarFrontbumper][i],
  44.             form[14],PlayerData[playerid][CarVentleft][i],form[15],PlayerData[playerid][CarVentright][i],form[16],PlayerData[playerid][CarPaintjob][i],form[17],PlayerData[playerid][CarAngle][i],PlayerName(playerid));
  45.             mysql_function_query(1,QueryString,false,"SomeNotExistingCallback","","");
  46.  
  47.             if (PlayerData[playerid][CarModel][i] > 0)
  48.             {
  49.                 new Float:X,Float:Y,Float:Z,Float:angle;
  50.                 GetVehiclePos(PlayerData[playerid][Car][i],X,Y,Z);
  51.                 PlayerData[playerid][CPX][i] = floatround(X);
  52.                 PlayerData[playerid][CPY][i] = floatround(Y);
  53.                 PlayerData[playerid][CPZ][i] = floatround(Z);
  54.                 GetVehicleZAngle(PlayerData[playerid][Car][i],angle);
  55.                 PlayerData[playerid][CarAngle][i] = angle;
  56.                 format(form[0],20,"CPX%d", i);
  57.                 format(form[1],20,"CPY%d", i);
  58.                 format(form[2],20,"CPZ%d", i);
  59.                 format(form[3],20,"CarAngle%d", i);
  60.                 format(form[4],20,"CarPlate%d", i);
  61.                 mysql_format(1,QueryString,"UPDATE `PlayerData` SET `%s` = %d, `%s` = %d, `%s` = %d, `%s` = %f, `%s` = '%s' WHERE `PlayerName` = '%s'",form[0],PlayerData[playerid][CPX][i],form[1],PlayerData[playerid][CPY][i],form[2],PlayerData[playerid][CPZ][i],form[3],PlayerData[playerid][CarAngle][i],form[4], CarPlate[playerid][i],PlayerName(playerid));
  62.                 mysql_function_query(1,QueryString,false,"SomeNotExistingCallback","","");
  63.             }
  64.         }
  65.  
  66.         new string[50];
  67.         strcat(QueryString,"UPDATE `PlayerData` SET ");
  68.         for (new a=1;a<ClassCount+1;a++)
  69.         {
  70.             format(string,sizeof(string),"`%s` = %d",GetClassName(a),PlayerData[playerid][ClassRank][a]);
  71.             strcat(QueryString,string);
  72.         }
  73.         format(string,sizeof(string),"WHERE `PlayerName` = '%s'",PlayerName(playerid));
  74.         strcat(QueryString,string);
  75.         mysql_function_query(1,QueryString,false,"SomeNotExistingCallback","","");
  76.  
  77.         for (new b=0;b<MAX_EVENT_OBJECTS;b++)
  78.         {
  79.             new form2[20];
  80.             format(form2,sizeof(form2),"EventObject%d", b);
  81.             INI_WriteInt(ini, form2, PlayerData[playerid][EventObjects][b]);
  82.         }
  83.  
  84.  
  85.     }
  86.  
  87. }
Advertisement
Add Comment
Please, Sign In to add comment