Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- MYSQL::LoadVehicles(playerid)
- {
- new name[MAX_PLAYER_NAME],query[200], fetch[120];
- GetPlayerName(playerid,name,sizeof(name));
- mysql_real_escape_string(name,name);
- format(query,sizeof(query),"SELECT * FROM vehicles WHERE Savininkas = '%s'",name);
- mysql_query(query);
- mysql_store_result();
- for(new i = 0; i < MAX_PLAYER_VEHICLES; i++)
- {
- if(mysql_fetch_row(query))
- {
- SQLfetch_field_row(fetch, "id"); VEHICLE::SQLID(playerid::i) = strval(fetch);
- SQLfetch_field_row(VEHICLE::Savininkas(playerid::i), "Savininkas");
- SQLfetch_field_row(fetch, "Modelis"); VEHICLE::Modelis(playerid::i) = strval(fetch);
- SQLfetch_field_row(fetch, "X"); VEHICLE::PosX(playerid::i) = floatstr(fetch);
- SQLfetch_field_row(fetch, "Y"); VEHICLE::PosY(playerid::i) = floatstr(fetch);
- SQLfetch_field_row(fetch, "Z"); VEHICLE::PosZ(playerid::i) = floatstr(fetch);
- SQLfetch_field_row(fetch, "Angle"); VEHICLE::Angle(playerid::i) = floatstr(fetch);
- SQLfetch_field_row(fetch, "Spalva1"); VEHICLE::Spalva1(playerid::i) = strval(fetch);
- SQLfetch_field_row(fetch, "Spalva2"); VEHICLE::Spalva2(playerid::i) = strval(fetch);
- SQLfetch_field_row(fetch, "ShopKaina"); VEHICLE::ShopPrice(playerid::i) = strval(fetch);
- VEHICLE::VehID(playerid::i) = CreateVehicle(VEHICLE::Modelis(playerid::i), VEHICLE::PosX(playerid::i), VEHICLE::PosY(playerid::i), VEHICLE::PosZ(playerid::i), VEHICLE::Angle(playerid::i), VEHICLE::Spalva1(playerid::i), VEHICLE::Spalva2(playerid::i),-1);
- SQLfetch_field_row(fetch, "Degalai"); VehicleGas[VEHICLE::VehID(playerid::i)] = strval(fetch);
- SQLfetch_field_row(fetch, "Degalu_Tipas"); VehicleGasType[VEHICLE::VehID(playerid::i)] = strval(fetch);
- SQLfetch_field_row(fetch, "Rida"); VehicleMileage[VEHICLE::VehID(playerid::i)] = floatstr(fetch);
- SQLfetch_field_row(fetch, "Uzraktas");
- if(strval(fetch) == 1)
- {
- Uzraktas[VEHICLE::VehID(playerid::i)] = true;
- }
- else if(strval(fetch) == 0)
- {
- Uzraktas[VEHICLE::VehID(playerid::i)] = false;
- }
- }
- else VEHICLE::VehID(playerid::i) = INVALID_VEHICLE_ID;
- }
- for(new i = 0; i < MAX_PLAYER_VEHICLES; i++)
- {
- if(VEHICLE::VehID(playerid::i) == INVALID_VEHICLE_ID) continue;
- LoadVehicleComponents(VEHICLE::SQLID(playerid::i), VEHICLE::VehID(playerid::i));
- }
- mysql_free_result();
- return 1;
- }
Advertisement
Add Comment
Please, Sign In to add comment