Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- stock SavePlayerData(playerid)
- {
- if (GetPVarInt(playerid, "Spawned") == 1)
- {
- mysql_format(1,QueryString,
- "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'",
- PlayerData[playerid][Score], PlayerData[playerid][Cash], PlayerData[playerid][Admin], PlayerData[playerid][Radio],
- 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],
- 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],
- PlayerData[playerid][PremiumVIPSlot],PlayerData[playerid][PremiumBusinessUpgrades],PlayerData[playerid][PremiumHouseUpgrades],PlayerData[playerid][LastFined], PlayerName(playerid));
- mysql_function_query(1,QueryString,false,"SomeNotExistingCallback","","");
- for (new i=0;i<MAX_OWNED_VEHICLES;i++)
- {
- new form[18][20];
- format(form[0],20,"CarModel%d", i);
- if (PlayerData[playerid][CarModel][i] > 0)
- {
- format(form[1],20,"CarNitro%d", i);
- format(form[2],20,"CarWheels%d", i);
- format(form[3],20,"CarSpoiler%d", i);
- format(form[4],20,"CarLamps%d", i);
- format(form[5],20,"CarSideSkirt%d", i);
- format(form[6],20,"CarHydraulics%d", i);
- format(form[7],20,"CarColor1%d", i);
- format(form[8],20,"CarColor2%d", i);
- format(form[9],20,"CarHood%d", i);
- format(form[10],20,"CarRoof%d", i);
- format(form[11],20,"CarExhaust%d", i);
- format(form[12],20,"CarRearbumper%d", i);
- format(form[13],20,"CarFrontbumper%d", i);
- format(form[14],20,"CarVentleft%d", i);
- format(form[15],20,"CarVentright%d", i);
- format(form[16],20,"CarPaintjob%d", i);
- format(form[17],20,"CarAngle%d", i);
- }
- 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'",
- 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],
- 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],
- 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));
- mysql_function_query(1,QueryString,false,"SomeNotExistingCallback","","");
- if (PlayerData[playerid][CarModel][i] > 0)
- {
- new Float:X,Float:Y,Float:Z,Float:angle;
- GetVehiclePos(PlayerData[playerid][Car][i],X,Y,Z);
- PlayerData[playerid][CPX][i] = floatround(X);
- PlayerData[playerid][CPY][i] = floatround(Y);
- PlayerData[playerid][CPZ][i] = floatround(Z);
- GetVehicleZAngle(PlayerData[playerid][Car][i],angle);
- PlayerData[playerid][CarAngle][i] = angle;
- format(form[0],20,"CPX%d", i);
- format(form[1],20,"CPY%d", i);
- format(form[2],20,"CPZ%d", i);
- format(form[3],20,"CarAngle%d", i);
- format(form[4],20,"CarPlate%d", i);
- 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));
- mysql_function_query(1,QueryString,false,"SomeNotExistingCallback","","");
- }
- }
- new string[50];
- strcat(QueryString,"UPDATE `PlayerData` SET ");
- for (new a=1;a<ClassCount+1;a++)
- {
- if(a == 1) format(string,sizeof(string),"`%s` = %d",GetClassName(a),PlayerData[playerid][ClassRank][a]);
- else format(string,sizeof(string),", `%s` = %d",GetClassName(a),PlayerData[playerid][ClassRank][a]);
- strcat(QueryString,string);
- }
- new form2[15];
- format(QueryString,sizeof(QueryString),"%s","UPDATE `PlayerData` SET ");
- for (new b=0;b<MAX_EVENT_OBJECTS;b++)
- {
- format(form2,sizeof(form2),"EventObject%d", b);
- format(string,sizeof(string),", `%s` = %d",form2,PlayerData[playerid][EventObjects][b]);
- strcat(QueryString,string);
- }
- format(string,sizeof(string)," WHERE `PlayerName` = '%s'",PlayerName(playerid));
- strcat(QueryString,string);
- mysql_function_query(1,QueryString,false,"SomeNotExistingCallback","","");
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment