Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public CreateCar(modelid, Float:PosX, Float:PosY, Float:PosZ, Float:PosA, color1, color2, respawn_delay, rent)
- {
- new gameid, uid;
- mysql_query_format("INSERT INTO `frp_cars` (car_model, car_name, car_posx, car_posy, car_posz, car_posa, car_color1, car_color2, car_fuel, car_rent) VALUES ('%d', '%s', '%f', '%f', '%f', '%f', '%d', '%d', '%d', '%d')", modelid, VehicleData[modelid-400][vName], PosX, PosY, PosZ, PosA, color1, color2, GetVehicleMaxFuel(modelid), rent);
- uid = mysql_insert_id();
- gameid = CreateVehicle(modelid, PosX, PosY, PosZ, PosA, color1, color2, respawn_delay);
- LoadVehicle(gameid, uid);
- CarInfo[gameid][cSpawned] = true;
- CarInfo[gameid][cTowedVeh] = INVALID_VEHICLE_ID;
- SetVehicleNumberPlate(gameid, "_");
- strmid(CarInfo[gameid][cAudioURL], "", 0, 0, 0);
- return gameid;
- }
- public LoadVehicle(gameid, uid)
- {
- new data[256], visual[32];
- mysql_query_format("SELECT * FROM `frp_cars` WHERE car_uid = '%d' ", uid);
- print("[load] Rozpoczynam proces wczytywania statystyk pojazdu...");
- mysql_store_result();
- if(mysql_fetch_row_format(data, "|"))
- {
- sscanf(data, "p<|>dds[24]ffffddddddfs[32]fddffddddd",
- CarInfo[gameid][cUID],
- CarInfo[gameid][cModel],
- CarInfo[gameid][cName],
- CarInfo[gameid][cPosX],
- CarInfo[gameid][cPosY],
- CarInfo[gameid][cPosZ],
- CarInfo[gameid][cPosA],
- CarInfo[gameid][cInteriorID],
- CarInfo[gameid][cWorldID],
- CarInfo[gameid][cColor1],
- CarInfo[gameid][cColor2],
- CarInfo[gameid][cOwner],
- CarInfo[gameid][cOwnerType],
- CarInfo[gameid][cHealth],
- visual,
- CarInfo[gameid][cFuel],
- CarInfo[gameid][cFuelType],
- CarInfo[gameid][cRent],
- CarInfo[gameid][cEnergy],
- CarInfo[gameid][cMileage],
- CarInfo[gameid][cLocked],
- CarInfo[gameid][cPaintJob],
- CarInfo[gameid][cWheelBlock],
- CarInfo[gameid][cAccess],
- CarInfo[gameid][cRegister]);
- sscanf(visual, "p<,>dddd", CarInfo[gameid][cVisual][0], CarInfo[gameid][cVisual][1], CarInfo[gameid][cVisual][2], CarInfo[gameid][cVisual][3]);
- SetVehicleHealth(gameid, CarInfo[gameid][cHealth]);
- UpdateVehicleDamageStatus(gameid, CarInfo[gameid][cVisual][0], CarInfo[gameid][cVisual][1], CarInfo[gameid][cVisual][2], CarInfo[gameid][cVisual][3]);
- SetVehicleVirtualWorld(gameid, CarInfo[gameid][cWorldID]);
- LinkVehicleToInterior(gameid, CarInfo[gameid][cInteriorID]);
- if(CarInfo[gameid][cModel] == 509 || CarInfo[gameid][cModel] == 510 || CarInfo[gameid][cModel] == 481)
- {
- CarInfo[gameid][cLocked] = false;
- CarInfo[gameid][cEngineTogged] = true;
- }
- else
- {
- CarInfo[gameid][cLocked] = true;
- CarInfo[gameid][cEngineTogged] = false;
- }
- SetVehicleLock(gameid, CarInfo[gameid][cLocked]);
- ChangeVehicleEngineStatus(gameid, CarInfo[gameid][cEngineTogged]);
- }
- mysql_free_result();
- printf("[load] Wczytano statystyki pojazdu %s (SampID: %d, UID: %d) pomyślnie.", CarInfo[gameid][cName], gameid, CarInfo[gameid][cUID]);
- return uid;
- }
- public SaveVehicle(gameid, what)
- {
- new main_query[512], query[256];
- format(main_query, sizeof(main_query), "UPDATE `frp_cars` SET");
- if(what & SAVE_VEH_POS)
- {
- // Pozycja pojazdu
- format(query, sizeof(query), " car_posx = '%f', car_posy = '%f', car_posz = '%f', car_posa = '%f', car_interior = '%d', car_world = '%d'",
- CarInfo[gameid][cPosX],
- CarInfo[gameid][cPosY],
- CarInfo[gameid][cPosZ],
- CarInfo[gameid][cPosA],
- CarInfo[gameid][cInteriorID],
- CarInfo[gameid][cWorldID]);
- if(strlen(main_query) > 32)
- {
- strcat(main_query, ",", sizeof(main_query));
- }
- strcat(main_query, query, sizeof(main_query));
- }
- if(what & SAVE_VEH_ACCESS)
- {
- // Akcesoria pojazdu (kolory, rodzaj paliwa, paintjob, blokada na koło, akcesoria)
- format(query, sizeof(query), " car_color1 = '%d', car_color2 = '%d', car_fueltype = '%d', car_paintjob = '%d', car_blockwheel = '%d', car_access = '%d'",
- CarInfo[gameid][cColor1],
- CarInfo[gameid][cColor2],
- CarInfo[gameid][cFuelType],
- CarInfo[gameid][cPaintJob],
- CarInfo[gameid][cWheelBlock],
- CarInfo[gameid][cAccess]);
- if(strlen(main_query) > 32)
- {
- strcat(main_query, ",", sizeof(main_query));
- }
- strcat(main_query, query, sizeof(main_query));
- }
- if(what & SAVE_VEH_COUNT)
- {
- // Liczniki (paliwo, przebieg, uszkodzenie techniczne, uszkodzenie wizualne, akumulator)
- format(query, sizeof(query), " car_health = '%f', car_fuel = '%f', car_mileage = '%f', car_visual = '%d,%d,%d,%d', car_energy = '%f'",
- CarInfo[gameid][cHealth],
- CarInfo[gameid][cFuel],
- CarInfo[gameid][cMileage],
- CarInfo[gameid][cVisual][0],
- CarInfo[gameid][cVisual][1],
- CarInfo[gameid][cVisual][2],
- CarInfo[gameid][cVisual][3],
- CarInfo[gameid][cEnergy]);
- if(strlen(main_query) > 32)
- {
- strcat(main_query, ",", sizeof(main_query));
- }
- strcat(main_query, query, sizeof(main_query));
- }
- if(what & SAVE_VEH_THINGS)
- {
- // Pozostałe (właściciel, model, nazwa)
- format(query, sizeof(query), " car_owner = '%d', car_ownertype = '%d', car_model = '%d', car_name = '%s', car_register = '%d'",
- CarInfo[gameid][cOwner],
- CarInfo[gameid][cOwnerType],
- CarInfo[gameid][cModel],
- CarInfo[gameid][cName],
- CarInfo[gameid][cRegister]);
- if(strlen(main_query) > 32)
- {
- strcat(main_query, ",", sizeof(main_query));
- }
- strcat(main_query, query, sizeof(main_query));
- }
- if(what & SAVE_VEH_LOCK)
- {
- // Zamknięcie pojazdu
- format(query, sizeof(query), " car_lock = '%d'",
- CarInfo[gameid][cLocked]);
- if(strlen(main_query) > 32)
- {
- strcat(main_query, ",", sizeof(main_query));
- }
- strcat(main_query, query, sizeof(main_query));
- }
- format(query, sizeof(query), " WHERE car_uid = '%d' LIMIT 1", CarInfo[gameid][cUID]);
- strcat(main_query, query, sizeof(main_query));
- mysql_query(main_query);
- OnVehicleSave[gameid] = 0;
- return 1;
- }
- public DeleteVehicle(gameid)
- {
- mysql_query_format("DELETE FROM `frp_cars` WHERE car_uid = '%d'", CarInfo[gameid][cUID]);
- if(CarInfo[gameid][cOwnerType] == OWNER_PLAYER)
- {
- new giveplayer_id = GetPlayerID(CarInfo[gameid][cOwner]);
- if(giveplayer_id == INVALID_PLAYER_ID)
- {
- return 1;
- }
- if(!Logged[giveplayer_id])
- {
- return 1;
- }
- PlayerCache[giveplayer_id][pCarSpawned] --;
- }
- CarInfo[gameid][cUID] = 0;
- CarInfo[gameid][cModel] = 0;
- CarInfo[gameid][cPosX] = 0.0;
- CarInfo[gameid][cPosY] = 0.0;
- CarInfo[gameid][cPosZ] = 0.0;
- CarInfo[gameid][cPosA] = 0.0;
- CarInfo[gameid][cInteriorID] = 0;
- CarInfo[gameid][cWorldID] = 0;
- CarInfo[gameid][cColor1] = 0;
- CarInfo[gameid][cColor2] = 0;
- CarInfo[gameid][cOwner] = 0;
- CarInfo[gameid][cOwnerType] = 0;
- CarInfo[gameid][cHealth] = 0.0;
- CarInfo[gameid][cVisual][0] = 0;
- CarInfo[gameid][cVisual][1] = 0;
- CarInfo[gameid][cVisual][2] = 0;
- CarInfo[gameid][cVisual][3] = 0;
- CarInfo[gameid][cFuel] = 0.0;
- CarInfo[gameid][cMileage] = 0.0;
- CarInfo[gameid][cFuelType] = 0;
- CarInfo[gameid][cWheelBlock] = 0;
- CarInfo[gameid][cEngineTogged] = false;
- CarInfo[gameid][cLocked] = false;
- CarInfo[gameid][cSpawned] = false;
- CarInfo[gameid][cTowedVeh] = INVALID_VEHICLE_ID;
- CarInfo[gameid][cCompLoaded] = false;
- CarInfo[gameid][cPaintJob] = 0;
- CarInfo[gameid][cAccess] = 0;
- strmid(CarInfo[gameid][cAudioURL], "", 0, 0, 0);
- DestroyVehicle(gameid);
- return 1;
- }
- public LoadVehicles()
- {
- new gameid, data[256], visual[32];
- mysql_query("SELECT * FROM `frp_cars` WHERE car_ownertype <> '1'");
- print("[load] Rozpoczynam proces wczytywania pojazdów z bazy danych...");
- // Wczytaj do tablic
- mysql_store_result();
- while(mysql_fetch_row_format(data, "|"))
- {
- gameid++;
- sscanf(data, "p<|>dds[24]ffffddddddfs[32]fddffddddd",
- CarInfo[gameid][cUID],
- CarInfo[gameid][cModel],
- CarInfo[gameid][cName],
- CarInfo[gameid][cPosX],
- CarInfo[gameid][cPosY],
- CarInfo[gameid][cPosZ],
- CarInfo[gameid][cPosA],
- CarInfo[gameid][cInteriorID],
- CarInfo[gameid][cWorldID],
- CarInfo[gameid][cColor1],
- CarInfo[gameid][cColor2],
- CarInfo[gameid][cOwner],
- CarInfo[gameid][cOwnerType],
- CarInfo[gameid][cHealth],
- visual,
- CarInfo[gameid][cFuel],
- CarInfo[gameid][cFuelType],
- CarInfo[gameid][cRent],
- CarInfo[gameid][cEnergy],
- CarInfo[gameid][cMileage],
- CarInfo[gameid][cLocked],
- CarInfo[gameid][cPaintJob],
- CarInfo[gameid][cWheelBlock],
- CarInfo[gameid][cAccess],
- CarInfo[gameid][cRegister]);
- sscanf(visual, "p<,>dddd", CarInfo[gameid][cVisual][0], CarInfo[gameid][cVisual][1], CarInfo[gameid][cVisual][2], CarInfo[gameid][cVisual][3]);
- CreateVehicle(CarInfo[gameid][cModel], CarInfo[gameid][cPosX], CarInfo[gameid][cPosY], CarInfo[gameid][cPosZ], CarInfo[gameid][cPosA], CarInfo[gameid][cColor1], CarInfo[gameid][cColor2], 7200);
- SetVehicleHealth(gameid, CarInfo[gameid][cHealth]);
- UpdateVehicleDamageStatus(gameid, CarInfo[gameid][cVisual][0], CarInfo[gameid][cVisual][1], CarInfo[gameid][cVisual][2], CarInfo[gameid][cVisual][3]);
- SetVehicleVirtualWorld(gameid, CarInfo[gameid][cWorldID]);
- LinkVehicleToInterior(gameid, CarInfo[gameid][cInteriorID]);
- CarInfo[gameid][cSpawned] = true;
- CarInfo[gameid][cTowedVeh] = INVALID_VEHICLE_ID;
- if(CarInfo[gameid][cModel] == 509 || CarInfo[gameid][cModel] == 510 || CarInfo[gameid][cModel] == 481)
- {
- CarInfo[gameid][cLocked] = false;
- CarInfo[gameid][cEngineTogged] = true;
- }
- else
- {
- CarInfo[gameid][cLocked] = true;
- CarInfo[gameid][cEngineTogged] = false;
- }
- SetVehicleLock(gameid, CarInfo[gameid][cLocked]);
- ChangeVehicleEngineStatus(gameid, CarInfo[gameid][cEngineTogged]);
- strmid(CarInfo[gameid][cAudioURL], "", 0, 0, 0);
- CarInfo[gameid][cPoliceSiren] = INVALID_OBJECT_ID;
- if(CarInfo[gameid][cRegister])
- {
- new string[32];
- format(string, sizeof(string), "LS%d", CarInfo[gameid][cUID]);
- SetVehicleNumberPlate(gameid, string);
- }
- else
- {
- SetVehicleNumberPlate(gameid, "_");
- }
- }
- mysql_free_result();
- printf("[load] Wczytano %d pojazdy/ów z bazy danych.", gameid);
- return 1;
- }
Advertisement
Add Comment
Please, Sign In to add comment