Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // Created by NRJ53 (samp forims)
- // Gavin_Cole (on most RP servers)
- // Enjoy :D
- #include <a_samp>
- #include <mysql>
- #define COLOR_WHITE 0xFFFFFFAA
- forward GetOwnedCarMods(playerid);
- forward LoadPlayerCars(playerid);
- forward SavePlayerCar(playerid, slotid);
- enum PlayerCars
- {
- LockedCar,
- LockedCar2,
- LockedCar3,
- Float: CarX,
- Float: CarY,
- Float: CarZ,
- Float: Car2X,
- Float: Car2Y,
- Float: Car2Z,
- Float: Car3X,
- Float: Car3Y,
- Float: Car3Z,
- PlayerCarModel,
- PlayerCarModel2,
- PlayerCarModel3,
- Float: CarZAngle,
- Float: Car2ZAngle,
- Float: Car3ZAngle,
- CarCol1,
- CarCol2,
- Car2Col1,
- Car2Col2,
- Car3Col1,
- Car3Col2,
- CarPaintJobID,
- Car2PaintJobID,
- Car3PaintJobID,
- OwnedCarModSlot0,
- OwnedCarModSlot1,
- OwnedCarModSlot2,
- OwnedCarModSlot3,
- OwnedCarModSlot4,
- OwnedCarModSlot5,
- OwnedCarModSlot6,
- OwnedCarModSlot7,
- OwnedCarModSlot8,
- OwnedCarModSlot9,
- OwnedCarModSlot10,
- OwnedCarModSlot11,
- OwnedCarModSlot12,
- OwnedCarModSlot13,
- Car2OwnedCarModSlot0,
- Car2OwnedCarModSlot1,
- Car2OwnedCarModSlot2,
- Car2OwnedCarModSlot3,
- Car2OwnedCarModSlot4,
- Car2OwnedCarModSlot5,
- Car2OwnedCarModSlot6,
- Car2OwnedCarModSlot7,
- Car2OwnedCarModSlot8,
- Car2OwnedCarModSlot9,
- Car2OwnedCarModSlot10,
- Car2OwnedCarModSlot11,
- Car2OwnedCarModSlot12,
- Car2OwnedCarModSlot13,
- Car3OwnedCarModSlot0,
- Car3OwnedCarModSlot1,
- Car3OwnedCarModSlot2,
- Car3OwnedCarModSlot3,
- Car3OwnedCarModSlot4,
- Car3OwnedCarModSlot5,
- Car3OwnedCarModSlot6,
- Car3OwnedCarModSlot7,
- Car3OwnedCarModSlot8,
- Car3OwnedCarModSlot9,
- Car3OwnedCarModSlot10,
- Car3OwnedCarModSlot11,
- Car3OwnedCarModSlot12,
- Car3OwnedCarModSlot13,
- CarLinkID,
- Car2LinkID,
- Car3LinkID
- }
- new PlayerCar[MAX_PLAYERS][PlayerCars];
- public OnFilterScriptInit()
- {
- mysql_init(0);
- mysql_connect("host", "user", "pass", "db");
- return 1;
- }
- public OnFilterScriptExit()
- {
- return 1;
- }
- public OnPlayerDisconnect(playerid, reason)
- {
- GetOwnedCarMods(playerid);
- SavePlayerCar(playerid, 1);
- SavePlayerCar(playerid, 2);
- SavePlayerCar(playerid, 3);
- return 1;
- }
- public OnVehicleMod(playerid, vehicleid, componentid)
- {
- SavePlayerCar(playerid, 1);
- SavePlayerCar(playerid, 2);
- SavePlayerCar(playerid, 3);
- return 1;
- }
- public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
- {
- SavePlayerCar(playerid, 1);
- SavePlayerCar(playerid, 2);
- SavePlayerCar(playerid, 3);
- return 1;
- }
- public OnVehicleRespray(playerid, vehicleid, color1, color2)
- {
- SavePlayerCar(playerid, 1);
- SavePlayerCar(playerid, 2);
- SavePlayerCar(playerid, 3);
- return 1;
- }
- public LoadPlayerCars(playerid)
- {
- new cartempname[250], data[600], query[500];
- GetPlayerName(playerid, cartempname, sizeof(cartempname));
- format(query, sizeof(query), "SELECT * FROM `playercars` WHERE `name` = '%s'", cartempname);
- mysql_query(query);
- mysql_store_result();
- while(mysql_fetch_row(data,"|"))
- {
- mysql_fetch_field("LockedCar", data); PlayerCar[playerid][LockedCar] = strval(data);
- mysql_fetch_field("LockedCar2", data); PlayerCar[playerid][LockedCar2] = strval(data);
- mysql_fetch_field("LockedCar3", data); PlayerCar[playerid][LockedCar3] = strval(data);
- mysql_fetch_field("CarX", data); PlayerCar[playerid][CarX] = strval(data);
- mysql_fetch_field("CarY", data); PlayerCar[playerid][CarY] = strval(data);
- mysql_fetch_field("CarZ", data); PlayerCar[playerid][CarZ] = strval(data);
- mysql_fetch_field("Car2X", data); PlayerCar[playerid][Car2X] = strval(data);
- mysql_fetch_field("Car2Y", data); PlayerCar[playerid][Car2Y] = strval(data);
- mysql_fetch_field("Car2Z", data); PlayerCar[playerid][Car2Z] = strval(data);
- mysql_fetch_field("Car3X", data); PlayerCar[playerid][Car3X] = strval(data);
- mysql_fetch_field("Car3Y", data); PlayerCar[playerid][Car3Y] = strval(data);
- mysql_fetch_field("Car3Z", data); PlayerCar[playerid][Car3Z] = strval(data);
- mysql_fetch_field("CarZAngle", data); PlayerCar[playerid][CarZAngle] = strval(data);
- mysql_fetch_field("Car2ZAngle", data); PlayerCar[playerid][Car2ZAngle] = strval(data);
- mysql_fetch_field("Car3ZAngle", data); PlayerCar[playerid][Car3ZAngle] = strval(data);
- mysql_fetch_field("CarModel", data); PlayerCar[playerid][PlayerCarModel] = strval(data);
- mysql_fetch_field("Car2Model", data); PlayerCar[playerid][PlayerCarModel2] = strval(data);
- mysql_fetch_field("Car3Model", data); PlayerCar[playerid][PlayerCarModel3] = strval(data);
- mysql_fetch_field("CarCol1", data); PlayerCar[playerid][CarCol1] = strval(data);
- mysql_fetch_field("CarCol2", data); PlayerCar[playerid][CarCol2] = strval(data);
- mysql_fetch_field("Car2Col1", data); PlayerCar[playerid][Car2Col1] = strval(data);
- mysql_fetch_field("Car2Col2", data); PlayerCar[playerid][Car2Col2] = strval(data);
- mysql_fetch_field("Car3Col1", data); PlayerCar[playerid][Car3Col1] = strval(data);
- mysql_fetch_field("Car3Col2", data); PlayerCar[playerid][Car3Col2] = strval(data);
- mysql_fetch_field("CarPaintJobID", data); PlayerCar[playerid][CarPaintJobID] = strval(data);
- mysql_fetch_field("Car2PaintJobID", data); PlayerCar[playerid][Car2PaintJobID] = strval(data);
- mysql_fetch_field("Car3PaintJobID", data); PlayerCar[playerid][Car3PaintJobID] = strval(data);
- mysql_fetch_field("OwnedCarModSlot0", data); PlayerCar[playerid][OwnedCarModSlot0] = strval(data);
- mysql_fetch_field("OwnedCarModSlot1", data); PlayerCar[playerid][OwnedCarModSlot1] = strval(data);
- mysql_fetch_field("OwnedCarModSlot2", data); PlayerCar[playerid][OwnedCarModSlot2] = strval(data);
- mysql_fetch_field("OwnedCarModSlot3", data); PlayerCar[playerid][OwnedCarModSlot3] = strval(data);
- mysql_fetch_field("OwnedCarModSlot4", data); PlayerCar[playerid][OwnedCarModSlot4] = strval(data);
- mysql_fetch_field("OwnedCarModSlot5", data); PlayerCar[playerid][OwnedCarModSlot5] = strval(data);
- mysql_fetch_field("OwnedCarModSlot6", data); PlayerCar[playerid][OwnedCarModSlot6] = strval(data);
- mysql_fetch_field("OwnedCarModSlot7", data); PlayerCar[playerid][OwnedCarModSlot7] = strval(data);
- mysql_fetch_field("OwnedCarModSlot8", data); PlayerCar[playerid][OwnedCarModSlot8] = strval(data);
- mysql_fetch_field("OwnedCarModSlot9", data); PlayerCar[playerid][OwnedCarModSlot9] = strval(data);
- mysql_fetch_field("OwnedCarModSlot10", data); PlayerCar[playerid][OwnedCarModSlot10] = strval(data);
- mysql_fetch_field("OwnedCarModSlot11", data); PlayerCar[playerid][OwnedCarModSlot11] = strval(data);
- mysql_fetch_field("OwnedCarModSlot12", data); PlayerCar[playerid][OwnedCarModSlot12] = strval(data);
- mysql_fetch_field("OwnedCarModSlot13", data); PlayerCar[playerid][OwnedCarModSlot13] = strval(data);
- mysql_fetch_field("OwnedCar2ModSlot0", data); PlayerCar[playerid][Car2OwnedCarModSlot0] = strval(data);
- mysql_fetch_field("OwnedCar2ModSlot1", data); PlayerCar[playerid][Car2OwnedCarModSlot1] = strval(data);
- mysql_fetch_field("OwnedCar2ModSlot2", data); PlayerCar[playerid][Car2OwnedCarModSlot2] = strval(data);
- mysql_fetch_field("OwnedCar2ModSlot3", data); PlayerCar[playerid][Car2OwnedCarModSlot3] = strval(data);
- mysql_fetch_field("OwnedCar2ModSlot4", data); PlayerCar[playerid][Car2OwnedCarModSlot4] = strval(data);
- mysql_fetch_field("OwnedCar2ModSlot5", data); PlayerCar[playerid][Car2OwnedCarModSlot5] = strval(data);
- mysql_fetch_field("OwnedCar2ModSlot6", data); PlayerCar[playerid][Car2OwnedCarModSlot6] = strval(data);
- mysql_fetch_field("OwnedCar2ModSlot7", data); PlayerCar[playerid][Car2OwnedCarModSlot7] = strval(data);
- mysql_fetch_field("OwnedCar2ModSlot8", data); PlayerCar[playerid][Car2OwnedCarModSlot8] = strval(data);
- mysql_fetch_field("OwnedCar2ModSlot9", data); PlayerCar[playerid][Car2OwnedCarModSlot9] = strval(data);
- mysql_fetch_field("OwnedCar2ModSlot10", data); PlayerCar[playerid][Car2OwnedCarModSlot10] = strval(data);
- mysql_fetch_field("OwnedCar2ModSlot11", data); PlayerCar[playerid][Car2OwnedCarModSlot11] = strval(data);
- mysql_fetch_field("OwnedCar2ModSlot12", data); PlayerCar[playerid][Car2OwnedCarModSlot12] = strval(data);
- mysql_fetch_field("OwnedCar2ModSlot13", data); PlayerCar[playerid][Car2OwnedCarModSlot13] = strval(data);
- mysql_fetch_field("OwnedCar3ModSlot0", data); PlayerCar[playerid][Car3OwnedCarModSlot0] = strval(data);
- mysql_fetch_field("OwnedCar3ModSlot1", data); PlayerCar[playerid][Car3OwnedCarModSlot1] = strval(data);
- mysql_fetch_field("OwnedCar3ModSlot2", data); PlayerCar[playerid][Car3OwnedCarModSlot2] = strval(data);
- mysql_fetch_field("OwnedCar3ModSlot3", data); PlayerCar[playerid][Car3OwnedCarModSlot3] = strval(data);
- mysql_fetch_field("OwnedCar3ModSlot4", data); PlayerCar[playerid][Car3OwnedCarModSlot4] = strval(data);
- mysql_fetch_field("OwnedCar3ModSlot5", data); PlayerCar[playerid][Car3OwnedCarModSlot5] = strval(data);
- mysql_fetch_field("OwnedCar3ModSlot6", data); PlayerCar[playerid][Car3OwnedCarModSlot6] = strval(data);
- mysql_fetch_field("OwnedCar3ModSlot7", data); PlayerCar[playerid][Car3OwnedCarModSlot7] = strval(data);
- mysql_fetch_field("OwnedCar3ModSlot8", data); PlayerCar[playerid][Car3OwnedCarModSlot8] = strval(data);
- mysql_fetch_field("OwnedCar3ModSlot9", data); PlayerCar[playerid][Car3OwnedCarModSlot9] = strval(data);
- mysql_fetch_field("OwnedCar3ModSlot10", data); PlayerCar[playerid][Car3OwnedCarModSlot10] = strval(data);
- mysql_fetch_field("OwnedCar3ModSlot11", data); PlayerCar[playerid][Car3OwnedCarModSlot11] = strval(data);
- mysql_fetch_field("OwnedCar3ModSlot12", data); PlayerCar[playerid][Car3OwnedCarModSlot12] = strval(data);
- mysql_fetch_field("OwnedCar3ModSlot13", data); PlayerCar[playerid][Car3OwnedCarModSlot13] = strval(data);
- }
- SpawnOwnedCar(playerid, 3);
- SpawnOwnedCar(playerid, 2);
- SpawnOwnedCar(playerid, 1);
- return 1;
- }
- public GetOwnedCarMods(playerid)
- {
- PlayerCar[playerid][OwnedCarModSlot0] = GetVehicleComponentInSlot(PlayerCar[playerid][CarLinkID], 0);
- PlayerCar[playerid][OwnedCarModSlot1] = GetVehicleComponentInSlot(PlayerCar[playerid][CarLinkID], 1);
- PlayerCar[playerid][OwnedCarModSlot2] = GetVehicleComponentInSlot(PlayerCar[playerid][CarLinkID], 2);
- PlayerCar[playerid][OwnedCarModSlot3] = GetVehicleComponentInSlot(PlayerCar[playerid][CarLinkID], 3);
- PlayerCar[playerid][OwnedCarModSlot4] = GetVehicleComponentInSlot(PlayerCar[playerid][CarLinkID], 4);
- PlayerCar[playerid][OwnedCarModSlot5] = GetVehicleComponentInSlot(PlayerCar[playerid][CarLinkID], 5);
- PlayerCar[playerid][OwnedCarModSlot6] = GetVehicleComponentInSlot(PlayerCar[playerid][CarLinkID], 6);
- PlayerCar[playerid][OwnedCarModSlot7] = GetVehicleComponentInSlot(PlayerCar[playerid][CarLinkID], 7);
- PlayerCar[playerid][OwnedCarModSlot8] = GetVehicleComponentInSlot(PlayerCar[playerid][CarLinkID], 8);
- PlayerCar[playerid][OwnedCarModSlot9] = GetVehicleComponentInSlot(PlayerCar[playerid][CarLinkID], 9);
- PlayerCar[playerid][OwnedCarModSlot10] = GetVehicleComponentInSlot(PlayerCar[playerid][CarLinkID], 10);
- PlayerCar[playerid][OwnedCarModSlot11] = GetVehicleComponentInSlot(PlayerCar[playerid][CarLinkID], 11);
- PlayerCar[playerid][OwnedCarModSlot12] = GetVehicleComponentInSlot(PlayerCar[playerid][CarLinkID], 12);
- PlayerCar[playerid][OwnedCarModSlot13] = GetVehicleComponentInSlot(PlayerCar[playerid][CarLinkID], 13);
- PlayerCar[playerid][Car2OwnedCarModSlot0] = GetVehicleComponentInSlot(PlayerCar[playerid][Car2LinkID], 0);
- PlayerCar[playerid][Car2OwnedCarModSlot1] = GetVehicleComponentInSlot(PlayerCar[playerid][Car2LinkID], 1);
- PlayerCar[playerid][Car2OwnedCarModSlot2] = GetVehicleComponentInSlot(PlayerCar[playerid][Car2LinkID], 2);
- PlayerCar[playerid][Car2OwnedCarModSlot3] = GetVehicleComponentInSlot(PlayerCar[playerid][Car2LinkID], 3);
- PlayerCar[playerid][Car2OwnedCarModSlot4] = GetVehicleComponentInSlot(PlayerCar[playerid][Car2LinkID], 4);
- PlayerCar[playerid][Car2OwnedCarModSlot5] = GetVehicleComponentInSlot(PlayerCar[playerid][Car2LinkID], 5);
- PlayerCar[playerid][Car2OwnedCarModSlot6] = GetVehicleComponentInSlot(PlayerCar[playerid][Car2LinkID], 6);
- PlayerCar[playerid][Car2OwnedCarModSlot7] = GetVehicleComponentInSlot(PlayerCar[playerid][Car2LinkID], 7);
- PlayerCar[playerid][Car2OwnedCarModSlot8] = GetVehicleComponentInSlot(PlayerCar[playerid][Car2LinkID], 8);
- PlayerCar[playerid][Car2OwnedCarModSlot9] = GetVehicleComponentInSlot(PlayerCar[playerid][Car2LinkID], 9);
- PlayerCar[playerid][Car2OwnedCarModSlot10] = GetVehicleComponentInSlot(PlayerCar[playerid][Car2LinkID], 10);
- PlayerCar[playerid][Car2OwnedCarModSlot11] = GetVehicleComponentInSlot(PlayerCar[playerid][Car2LinkID], 11);
- PlayerCar[playerid][Car2OwnedCarModSlot12] = GetVehicleComponentInSlot(PlayerCar[playerid][Car2LinkID], 12);
- PlayerCar[playerid][Car2OwnedCarModSlot13] = GetVehicleComponentInSlot(PlayerCar[playerid][Car2LinkID], 13);
- PlayerCar[playerid][Car3OwnedCarModSlot0] = GetVehicleComponentInSlot(PlayerCar[playerid][Car3LinkID], 0);
- PlayerCar[playerid][Car3OwnedCarModSlot1] = GetVehicleComponentInSlot(PlayerCar[playerid][Car3LinkID], 1);
- PlayerCar[playerid][Car3OwnedCarModSlot2] = GetVehicleComponentInSlot(PlayerCar[playerid][Car3LinkID], 2);
- PlayerCar[playerid][Car3OwnedCarModSlot3] = GetVehicleComponentInSlot(PlayerCar[playerid][Car3LinkID], 3);
- PlayerCar[playerid][Car3OwnedCarModSlot4] = GetVehicleComponentInSlot(PlayerCar[playerid][Car3LinkID], 4);
- PlayerCar[playerid][Car3OwnedCarModSlot5] = GetVehicleComponentInSlot(PlayerCar[playerid][Car3LinkID], 5);
- PlayerCar[playerid][Car3OwnedCarModSlot6] = GetVehicleComponentInSlot(PlayerCar[playerid][Car3LinkID], 6);
- PlayerCar[playerid][Car3OwnedCarModSlot7] = GetVehicleComponentInSlot(PlayerCar[playerid][Car3LinkID], 7);
- PlayerCar[playerid][Car3OwnedCarModSlot8] = GetVehicleComponentInSlot(PlayerCar[playerid][Car3LinkID], 8);
- PlayerCar[playerid][Car3OwnedCarModSlot9] = GetVehicleComponentInSlot(PlayerCar[playerid][Car3LinkID], 9);
- PlayerCar[playerid][Car3OwnedCarModSlot10] = GetVehicleComponentInSlot(PlayerCar[playerid][Car3LinkID], 10);
- PlayerCar[playerid][Car3OwnedCarModSlot11] = GetVehicleComponentInSlot(PlayerCar[playerid][Car3LinkID], 11);
- PlayerCar[playerid][Car3OwnedCarModSlot12] = GetVehicleComponentInSlot(PlayerCar[playerid][Car3LinkID], 12);
- PlayerCar[playerid][Car3OwnedCarModSlot13] = GetVehicleComponentInSlot(PlayerCar[playerid][Car3LinkID], 13);
- return 1;
- }
- stock SpawnOwnedCar(playerid, slotid)
- {
- if(IsPlayerConnectedEx(playerid))
- {
- switch(slotid)
- {
- case 1:
- {
- if(PlayerCar[playerid][PlayerCarModel] >= 1)
- {
- if(PlayerCar[playerid][CarLinkID] >= 1)
- {
- DestroyVehicle(PlayerCar[playerid][CarLinkID]);
- PlayerCar[playerid][CarLinkID] = 0;
- }
- PlayerCar[playerid][CarLinkID] = CreateVehicle(PlayerCar[playerid][PlayerCarModel], PlayerCar[playerid][CarX], PlayerCar[playerid][CarY], PlayerCar[playerid][CarZ], PlayerCar[playerid][CarZAngle], PlayerCar[playerid][CarCol1], PlayerCar[playerid][CarCol2], -1);
- SendClientMessage(playerid, COLOR_WHITE, "Your first owned vehicle has been spawned. If you can't find it, please use the /callcar command.");
- if(GetVehicleModel(PlayerCar[playerid][CarLinkID]) != PlayerCar[playerid][PlayerCarModel])
- {
- DestroyVehicle(PlayerCar[playerid][CarLinkID]);
- PlayerCar[playerid][CarLinkID] = 0;
- PlayerCar[playerid][CarLinkID] = CreateVehicle(PlayerCar[playerid][PlayerCarModel], PlayerCar[playerid][CarX], PlayerCar[playerid][CarY], PlayerCar[playerid][CarZ], PlayerCar[playerid][CarZAngle], PlayerCar[playerid][CarCol1], PlayerCar[playerid][CarCol2], -1);
- }
- ChangeVehiclePaintjob(PlayerCar[playerid][CarLinkID], PlayerCar[playerid][CarPaintJobID]);
- if(PlayerCar[playerid][OwnedCarModSlot0] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][CarLinkID], PlayerCar[playerid][OwnedCarModSlot0]);
- }
- if(PlayerCar[playerid][OwnedCarModSlot1] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][CarLinkID], PlayerCar[playerid][OwnedCarModSlot1]);
- }
- if(PlayerCar[playerid][OwnedCarModSlot2] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][CarLinkID], PlayerCar[playerid][OwnedCarModSlot2]);
- }
- if(PlayerCar[playerid][OwnedCarModSlot3] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][CarLinkID], PlayerCar[playerid][OwnedCarModSlot3]);
- }
- if(PlayerCar[playerid][OwnedCarModSlot4] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][CarLinkID], PlayerCar[playerid][OwnedCarModSlot4]);
- }
- if(PlayerCar[playerid][OwnedCarModSlot5] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][CarLinkID], PlayerCar[playerid][OwnedCarModSlot5]);
- }
- if(PlayerCar[playerid][OwnedCarModSlot6] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][CarLinkID], PlayerCar[playerid][OwnedCarModSlot6]);
- }
- if(PlayerCar[playerid][OwnedCarModSlot7] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][CarLinkID], PlayerCar[playerid][OwnedCarModSlot7]);
- }
- if(PlayerCar[playerid][OwnedCarModSlot9] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][CarLinkID], PlayerCar[playerid][OwnedCarModSlot9]);
- }
- if(PlayerCar[playerid][OwnedCarModSlot10] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][CarLinkID], PlayerCar[playerid][OwnedCarModSlot10]);
- }
- if(PlayerCar[playerid][OwnedCarModSlot11] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][CarLinkID], PlayerCar[playerid][OwnedCarModSlot11]);
- }
- if(PlayerCar[playerid][OwnedCarModSlot12] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][CarLinkID], PlayerCar[playerid][OwnedCarModSlot12]);
- }
- if(PlayerCar[playerid][OwnedCarModSlot13] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][CarLinkID], PlayerCar[playerid][OwnedCarModSlot13]);
- }
- }
- }
- case 2:
- {
- if(PlayerCar[playerid][PlayerCarModel2] >= 1)
- {
- if(PlayerCar[playerid][Car2LinkID] >= 1)
- {
- DestroyVehicle(PlayerCar[playerid][Car2LinkID]);
- PlayerCar[playerid][Car2LinkID] = 0;
- }
- PlayerCar[playerid][Car2LinkID] = CreateVehicle(PlayerCar[playerid][PlayerCarModel2], PlayerCar[playerid][Car2X], PlayerCar[playerid][Car2Y], PlayerCar[playerid][Car2Z], PlayerCar[playerid][Car2ZAngle], PlayerCar[playerid][Car2Col1], PlayerCar[playerid][Car2Col2], -1);
- SendClientMessage(playerid, COLOR_WHITE, "Your second owned vehicle has been spawned. If you can't find it, please use the /callcar command.");
- if(GetVehicleModel(PlayerCar[playerid][Car2LinkID]) != PlayerCar[playerid][PlayerCarModel2])
- {
- DestroyVehicle(PlayerCar[playerid][Car2LinkID]);
- PlayerCar[playerid][Car2LinkID] = 0;
- PlayerCar[playerid][Car2LinkID] = CreateVehicle(PlayerCar[playerid][PlayerCarModel2], PlayerCar[playerid][Car2X], PlayerCar[playerid][Car2Y], PlayerCar[playerid][Car2Z], PlayerCar[playerid][Car2ZAngle], PlayerCar[playerid][Car2Col1], PlayerCar[playerid][Car2Col2], -1);
- }
- ChangeVehiclePaintjob(PlayerCar[playerid][Car2LinkID], PlayerCar[playerid][Car2PaintJobID]);
- if(PlayerCar[playerid][Car2OwnedCarModSlot0] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car2LinkID], PlayerCar[playerid][Car2OwnedCarModSlot0]);
- }
- if(PlayerCar[playerid][Car2OwnedCarModSlot1] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car2LinkID], PlayerCar[playerid][Car2OwnedCarModSlot1]);
- }
- if(PlayerCar[playerid][Car2OwnedCarModSlot2] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car2LinkID], PlayerCar[playerid][Car2OwnedCarModSlot2]);
- }
- if(PlayerCar[playerid][Car2OwnedCarModSlot3] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car2LinkID], PlayerCar[playerid][Car2OwnedCarModSlot3]);
- }
- if(PlayerCar[playerid][Car2OwnedCarModSlot4] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car2LinkID], PlayerCar[playerid][Car2OwnedCarModSlot4]);
- }
- if(PlayerCar[playerid][Car2OwnedCarModSlot5] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car2LinkID], PlayerCar[playerid][Car2OwnedCarModSlot5]);
- }
- if(PlayerCar[playerid][Car2OwnedCarModSlot6] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car2LinkID], PlayerCar[playerid][Car2OwnedCarModSlot6]);
- }
- if(PlayerCar[playerid][Car2OwnedCarModSlot7] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car2LinkID], PlayerCar[playerid][Car2OwnedCarModSlot7]);
- }
- if(PlayerCar[playerid][Car2OwnedCarModSlot9] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car2LinkID], PlayerCar[playerid][Car2OwnedCarModSlot9]);
- }
- if(PlayerCar[playerid][Car2OwnedCarModSlot10] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car2LinkID], PlayerCar[playerid][Car2OwnedCarModSlot10]);
- }
- if(PlayerCar[playerid][Car2OwnedCarModSlot11] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car2LinkID], PlayerCar[playerid][Car2OwnedCarModSlot11]);
- }
- if(PlayerCar[playerid][Car2OwnedCarModSlot12] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car2LinkID], PlayerCar[playerid][Car2OwnedCarModSlot12]);
- }
- if(PlayerCar[playerid][Car2OwnedCarModSlot13] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car2LinkID], PlayerCar[playerid][Car2OwnedCarModSlot13]);
- }
- }
- }
- case 3:
- {
- if(PlayerCar[playerid][PlayerCarModel3] >= 1)
- {
- PlayerCar[playerid][Car3LinkID] = CreateVehicle(PlayerCar[playerid][PlayerCarModel3], PlayerCar[playerid][Car3X], PlayerCar[playerid][Car3Y], PlayerCar[playerid][Car3Z], PlayerCar[playerid][Car3ZAngle], PlayerCar[playerid][Car3Col1], PlayerCar[playerid][Car3Col2], -1);
- SendClientMessage(playerid, COLOR_WHITE, "Your third owned vehicle has been spawned. If you can't find it, please use the /callcar command.");
- if(GetVehicleModel(PlayerCar[playerid][Car3LinkID]) != PlayerCar[playerid][PlayerCarModel3])
- {
- DestroyVehicle(PlayerCar[playerid][Car3LinkID]);
- PlayerCar[playerid][Car3LinkID] = 0;
- PlayerCar[playerid][Car3LinkID] = CreateVehicle(PlayerCar[playerid][PlayerCarModel3], PlayerCar[playerid][Car3X], PlayerCar[playerid][Car3Y], PlayerCar[playerid][Car3Z], PlayerCar[playerid][Car3ZAngle], PlayerCar[playerid][Car3Col1], PlayerCar[playerid][Car3Col2], -1);
- }
- ChangeVehiclePaintjob(PlayerCar[playerid][Car3LinkID], PlayerCar[playerid][Car3PaintJobID]);
- if(PlayerCar[playerid][Car3OwnedCarModSlot0] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car3LinkID], PlayerCar[playerid][Car3OwnedCarModSlot0]);
- }
- if(PlayerCar[playerid][Car3OwnedCarModSlot1] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car3LinkID], PlayerCar[playerid][Car3OwnedCarModSlot1]);
- }
- if(PlayerCar[playerid][Car3OwnedCarModSlot2] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car3LinkID], PlayerCar[playerid][Car3OwnedCarModSlot2]);
- }
- if(PlayerCar[playerid][Car3OwnedCarModSlot3] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car3LinkID], PlayerCar[playerid][Car3OwnedCarModSlot3]);
- }
- if(PlayerCar[playerid][Car3OwnedCarModSlot4] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car3LinkID], PlayerCar[playerid][Car3OwnedCarModSlot4]);
- }
- if(PlayerCar[playerid][Car3OwnedCarModSlot5] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car3LinkID], PlayerCar[playerid][Car3OwnedCarModSlot5]);
- }
- if(PlayerCar[playerid][Car3OwnedCarModSlot6] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car3LinkID], PlayerCar[playerid][Car3OwnedCarModSlot6]);
- }
- if(PlayerCar[playerid][Car3OwnedCarModSlot7] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car3LinkID], PlayerCar[playerid][Car3OwnedCarModSlot7]);
- }
- if(PlayerCar[playerid][Car3OwnedCarModSlot9] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car3LinkID], PlayerCar[playerid][Car3OwnedCarModSlot9]);
- }
- if(PlayerCar[playerid][Car3OwnedCarModSlot10] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car3LinkID], PlayerCar[playerid][Car3OwnedCarModSlot10]);
- }
- if(PlayerCar[playerid][Car3OwnedCarModSlot11] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car3LinkID], PlayerCar[playerid][Car3OwnedCarModSlot11]);
- }
- if(PlayerCar[playerid][Car3OwnedCarModSlot12] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car3LinkID], PlayerCar[playerid][Car3OwnedCarModSlot12]);
- }
- if(PlayerCar[playerid][Car3OwnedCarModSlot13] > 0)
- {
- AddVehicleComponent(PlayerCar[playerid][Car3LinkID], PlayerCar[playerid][Car3OwnedCarModSlot13]);
- }
- }
- }
- }
- }
- }
- stock IsPlayerConnectedEx(playerid)
- {
- if(IsPlayerConnected(playerid))
- {
- return 1;
- }
- else
- {
- return 0;
- }
- }
- public SavePlayerCar(playerid, slotid)
- {
- new savename[MAX_PLAYER_NAME];
- new query[500];
- GetPlayerName(playerid, savename, sizeof(savename));
- switch(slotid)
- {
- case 1:
- {
- // car 1
- format(query, sizeof(query), "UPDATE `playercars` SET `OwnedCarModSlot0` = '%d', `OwnedCarModSlot1` = '%d', `OwnedCarModSlot2` = '%d', `OwnedCarModSlot3` = '%d', `OwnedCarModSlot4` = '%d' WHERE `name` = '%s'", PlayerCar[playerid][OwnedCarModSlot0], PlayerCar[playerid][OwnedCarModSlot1], PlayerCar[playerid][OwnedCarModSlot2], PlayerCar[playerid][OwnedCarModSlot3], PlayerCar[playerid][OwnedCarModSlot4], savename);
- mysql_query(query);
- format(query, sizeof(query), "UPDATE `playercars` SET `OwnedCarModSlot5` = '%d', `OwnedCarModSlot6` = '%d', `OwnedCarModSlot7` = '%d', `OwnedCarModSlot8` = '%d' WHERE `name` = '%s'", PlayerCar[playerid][OwnedCarModSlot5], PlayerCar[playerid][OwnedCarModSlot6], PlayerCar[playerid][OwnedCarModSlot7], PlayerCar[playerid][OwnedCarModSlot8], savename);
- mysql_query(query);
- format(query, sizeof(query), "UPDATE `playercars` SET `OwnedCarModSlot9` = '%d', `OwnedCarModSlot10` = '%d', `OwnedCarModSlot11` = '%d', `OwnedCarModSlot12` = '%d' WHERE `name` = '%s'", PlayerCar[playerid][OwnedCarModSlot9], PlayerCar[playerid][OwnedCarModSlot10], PlayerCar[playerid][OwnedCarModSlot11], PlayerCar[playerid][OwnedCarModSlot12], savename);
- mysql_query(query);
- format(query, sizeof(query), "UPDATE `playercars` SET `OwnedCarModSlot13` = '%d', `PlayerCarModel2` = '%d', `CarZAngle` = '%f' WHERE `name` = '%s'", PlayerCar[playerid][OwnedCarModSlot13], PlayerCar[playerid][PlayerCarModel2], PlayerCar[playerid][CarZAngle], savename);
- mysql_query(query);
- format(query, sizeof(query), "UPDATE `playercars` SET `CarX` = '%f', `CarY` = '%f', `CarZ` = '%f' WHERE `name` = '%s'", PlayerCar[playerid][CarX], PlayerCar[playerid][CarY], PlayerCar[playerid][CarZ], savename);
- mysql_query(query);
- format(query, sizeof(query), "UPDATE `playercars` SET `CarCol1` = '%d', `CarCol2` = '%d', `CarPaintJobID` = '%d' WHERE `name` = '%s'", PlayerCar[playerid][CarCol1], PlayerCar[playerid][CarCol2], PlayerCar[playerid][CarPaintJobID], savename);
- mysql_query(query);
- }
- case 2:
- {
- // car 2
- format(query, sizeof(query), "UPDATE `playercars` SET `OwnedCar2ModSlot0` = '%d', `OwnedCar2ModSlot1` = '%d', `OwnedCar2ModSlot2` = '%d', `OwnedCar2ModSlot3` = '%d', `OwnedCar2ModSlot4` = '%d' WHERE `name` = '%s'", PlayerCar[playerid][Car2OwnedCarModSlot0], PlayerCar[playerid][Car2OwnedCarModSlot1], PlayerCar[playerid][Car2OwnedCarModSlot2], PlayerCar[playerid][Car2OwnedCarModSlot3], PlayerCar[playerid][Car2OwnedCarModSlot4], savename);
- mysql_query(query);
- format(query, sizeof(query), "UPDATE `playercars` SET `OwnedCar2ModSlot5` = '%d', `OwnedCar2ModSlot6` = '%d', `OwnedCar2ModSlot7` = '%d', `OwnedCar2ModSlot8` = '%d' WHERE `name` = '%s'", PlayerCar[playerid][Car2OwnedCarModSlot5], PlayerCar[playerid][Car2OwnedCarModSlot6], PlayerCar[playerid][Car2OwnedCarModSlot7], PlayerCar[playerid][Car2OwnedCarModSlot8], savename);
- mysql_query(query);
- format(query, sizeof(query), "UPDATE `playercars` SET `OwnedCar2ModSlot9` = '%d', `OwnedCar2ModSlot10` = '%d', `OwnedCar2ModSlot11` = '%d', `OwnedCar2ModSlot12` = '%d' WHERE `name` = '%s'", PlayerCar[playerid][Car2OwnedCarModSlot9], PlayerCar[playerid][Car2OwnedCarModSlot10], PlayerCar[playerid][Car2OwnedCarModSlot11], PlayerCar[playerid][Car2OwnedCarModSlot12], savename);
- mysql_query(query);
- format(query, sizeof(query), "UPDATE `playercars` SET `OwnedCar2ModSlot13` = '%d', `PlayerCarModel2` = '%d', `Car2ZAngle` = '%f' WHERE `name` = '%s'", PlayerCar[playerid][Car2OwnedCarModSlot3], PlayerCar[playerid][PlayerCarModel2], PlayerCar[playerid][Car2ZAngle], savename);
- mysql_query(query);
- format(query, sizeof(query), "UPDATE `playercars` SET `Car2X` = '%f', `Car2Y` = '%f', `Car2Z` = '%f' WHERE `name` = '%s'", PlayerCar[playerid][Car2X], PlayerCar[playerid][Car2Y], PlayerCar[playerid][Car2Z], savename);
- mysql_query(query);
- format(query, sizeof(query), "UPDATE `playercars` SET `Car2Col1` = '%d', `Car2Col2` = '%d', `Car2PaintJobID` = '%d' WHERE `name` = '%s'", PlayerCar[playerid][Car2Col1], PlayerCar[playerid][Car2Col2], PlayerCar[playerid][Car2PaintJobID], savename);
- mysql_query(query);
- }
- case 3:
- {
- // car 3
- format(query, sizeof(query), "UPDATE `playercars` SET `OwnedCar3ModSlot0` = '%d', `OwnedCar3ModSlot1` = '%d', `OwnedCar3ModSlot2` = '%d', `OwnedCar3ModSlot3` = '%d', `OwnedCar3ModSlot4` = '%d' WHERE `name` = '%s'", PlayerCar[playerid][Car3OwnedCarModSlot0], PlayerCar[playerid][Car3OwnedCarModSlot1], PlayerCar[playerid][Car3OwnedCarModSlot2], PlayerCar[playerid][Car3OwnedCarModSlot3], PlayerCar[playerid][Car3OwnedCarModSlot4], savename);
- mysql_query(query);
- format(query, sizeof(query), "UPDATE `playercars` SET `OwnedCar3ModSlot5` = '%d', `OwnedCar3ModSlot6` = '%d', `OwnedCar3ModSlot7` = '%d', `OwnedCar3ModSlot8` = '%d' WHERE `name` = '%s'", PlayerCar[playerid][Car3OwnedCarModSlot5], PlayerCar[playerid][Car3OwnedCarModSlot6], PlayerCar[playerid][Car3OwnedCarModSlot7], PlayerCar[playerid][Car3OwnedCarModSlot8], savename);
- mysql_query(query);
- format(query, sizeof(query), "UPDATE `playercars` SET `OwnedCar3ModSlot9` = '%d', `OwnedCar3ModSlot10` = '%d', `OwnedCar3ModSlot11` = '%d', `OwnedCar3ModSlot12` = '%d' WHERE `name` = '%s'", PlayerCar[playerid][Car3OwnedCarModSlot9], PlayerCar[playerid][Car3OwnedCarModSlot10], PlayerCar[playerid][Car3OwnedCarModSlot11], PlayerCar[playerid][Car3OwnedCarModSlot12], savename);
- mysql_query(query);
- format(query, sizeof(query), "UPDATE `playercars` SET `OwnedCar3ModSlot13` = '%d', `PlayerCarModel2` = '%d', `Car3ZAngle` = '%f' WHERE `name` = '%s'", PlayerCar[playerid][Car3OwnedCarModSlot3], PlayerCar[playerid][PlayerCarModel2], PlayerCar[playerid][Car3ZAngle], savename);
- mysql_query(query);
- format(query, sizeof(query), "UPDATE `playercars` SET `Car3X` = '%f', `Car3Y` = '%f', `Car3Z` = '%f' WHERE `name` = '%s'", PlayerCar[playerid][Car3X], PlayerCar[playerid][Car3Y], PlayerCar[playerid][Car3Z], savename);
- mysql_query(query);
- format(query, sizeof(query), "UPDATE `playercars` SET `Car3Col1` = '%d', `Car3Col2` = '%d', `Car3PaintJobID` = '%d' WHERE `name` = '%s'", PlayerCar[playerid][Car3Col1], PlayerCar[playerid][Car3Col2], PlayerCar[playerid][Car3PaintJobID], savename);
- mysql_query(query);
- }
- }
- return 1;
- }
- /* Database
- CREATE TABLE IF NOT EXISTS `playercars` (
- `id` int(255) NOT NULL AUTO_INCREMENT,
- `name` varchar(255) NOT NULL,
- `LockedCar` int(1) NOT NULL DEFAULT '0',
- `LockedCar2` int(1) NOT NULL DEFAULT '0',
- `LockedCar3` int(1) NOT NULL DEFAULT '0',
- `CarX` float NOT NULL,
- `CarY` float NOT NULL,
- `CarZ` float NOT NULL,
- `Car2X` float NOT NULL,
- `Car2Y` float NOT NULL,
- `Car2Z` float NOT NULL,
- `Car3X` float NOT NULL,
- `Car3Y` float NOT NULL,
- `Car3Z` float NOT NULL,
- `CarZAngle` float NOT NULL,
- `Car2ZAngle` float NOT NULL,
- `Car3ZAngle` float NOT NULL,
- `CarModel` int(11) NOT NULL DEFAULT '0',
- `Car2Model` int(11) NOT NULL DEFAULT '0',
- `Car3Model` int(11) NOT NULL DEFAULT '0',
- `CarCol1` int(11) NOT NULL DEFAULT '0',
- `CarCol2` int(11) NOT NULL DEFAULT '0',
- `Car2Col1` int(11) NOT NULL DEFAULT '0',
- `Car2Col2` int(11) NOT NULL DEFAULT '0',
- `Car3Col1` int(11) NOT NULL DEFAULT '0',
- `Car3Col2` int(11) NOT NULL DEFAULT '0',
- `CarPaintJobID` int(11) NOT NULL DEFAULT '0',
- `Car2PaintJobID` int(11) NOT NULL DEFAULT '0',
- `Car3PaintJobID` int(11) NOT NULL DEFAULT '0',
- `OwnedCarModSlot0` int(11) NOT NULL DEFAULT '0',
- `OwnedCarModSlot1` int(11) NOT NULL DEFAULT '0',
- `OwnedCarModSlot2` int(11) NOT NULL DEFAULT '0',
- `OwnedCarModSlot3` int(11) NOT NULL DEFAULT '0',
- `OwnedCarModSlot4` int(11) NOT NULL DEFAULT '0',
- `OwnedCarModSlot5` int(11) NOT NULL DEFAULT '0',
- `OwnedCarModSlot6` int(11) NOT NULL DEFAULT '0',
- `OwnedCarModSlot7` int(11) NOT NULL DEFAULT '0',
- `OwnedCarModSlot8` int(11) NOT NULL DEFAULT '0',
- `OwnedCarModSlot9` int(11) NOT NULL DEFAULT '0',
- `OwnedCarModSlot10` int(11) NOT NULL DEFAULT '0',
- `OwnedCarModSlot11` int(11) NOT NULL DEFAULT '0',
- `OwnedCarModSlot12` int(11) NOT NULL DEFAULT '0',
- `OwnedCarModSlot13` int(11) NOT NULL DEFAULT '0',
- `OwnedCar2ModSlot0` int(11) NOT NULL DEFAULT '0',
- `OwnedCar2ModSlot1` int(11) NOT NULL DEFAULT '0',
- `OwnedCar2ModSlot2` int(11) NOT NULL DEFAULT '0',
- `OwnedCar2ModSlot3` int(11) NOT NULL DEFAULT '0',
- `OwnedCar2ModSlot4` int(11) NOT NULL DEFAULT '0',
- `OwnedCar2ModSlot5` int(11) NOT NULL DEFAULT '0',
- `OwnedCar2ModSlot6` int(11) NOT NULL DEFAULT '0',
- `OwnedCar2ModSlot7` int(11) NOT NULL DEFAULT '0',
- `OwnedCar2ModSlot8` int(11) NOT NULL DEFAULT '0',
- `OwnedCar2ModSlot9` int(11) NOT NULL DEFAULT '0',
- `OwnedCar2ModSlot10` int(11) NOT NULL DEFAULT '0',
- `OwnedCar2ModSlot11` int(11) NOT NULL DEFAULT '0',
- `OwnedCar2ModSlot12` int(11) NOT NULL DEFAULT '0',
- `OwnedCar2ModSlot13` int(11) NOT NULL DEFAULT '0',
- `OwnedCar3ModSlot0` int(11) NOT NULL DEFAULT '0',
- `OwnedCar3ModSlot1` int(11) NOT NULL DEFAULT '0',
- `OwnedCar3ModSlot2` int(11) NOT NULL DEFAULT '0',
- `OwnedCar3ModSlot3` int(11) NOT NULL DEFAULT '0',
- `OwnedCar3ModSlot4` int(11) NOT NULL DEFAULT '0',
- `OwnedCar3ModSlot5` int(11) NOT NULL DEFAULT '0',
- `OwnedCar3ModSlot6` int(11) NOT NULL DEFAULT '0',
- `OwnedCar3ModSlot7` int(11) NOT NULL DEFAULT '0',
- `OwnedCar3ModSlot8` int(11) NOT NULL DEFAULT '0',
- `OwnedCar3ModSlot9` int(11) NOT NULL DEFAULT '0',
- `OwnedCar3ModSlot10` int(11) NOT NULL DEFAULT '0',
- `OwnedCar3ModSlot11` int(11) NOT NULL DEFAULT '0',
- `OwnedCar3ModSlot12` int(11) NOT NULL DEFAULT '0',
- `OwnedCar3ModSlot13` int(11) NOT NULL DEFAULT '0',
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- */
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement