Bicas

Untitled

Jan 3rd, 2015
183
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C++ 2.32 KB | None | 0 0
  1. MYSQL::LoadVehicles(playerid)
  2. {
  3.     new name[MAX_PLAYER_NAME],query[200], fetch[120];
  4.     GetPlayerName(playerid,name,sizeof(name));
  5.     mysql_real_escape_string(name,name);
  6.     format(query,sizeof(query),"SELECT * FROM vehicles WHERE Savininkas = '%s'",name);
  7.     mysql_query(query);
  8.     mysql_store_result();
  9.    
  10.     for(new i = 0; i < MAX_PLAYER_VEHICLES; i++)
  11.     {
  12.         if(mysql_fetch_row(query))
  13.         {
  14.             SQLfetch_field_row(fetch, "id");            VEHICLE::SQLID(playerid::i) = strval(fetch);
  15.             SQLfetch_field_row(VEHICLE::Savininkas(playerid::i), "Savininkas");
  16.             SQLfetch_field_row(fetch, "Modelis");       VEHICLE::Modelis(playerid::i) = strval(fetch);
  17.             SQLfetch_field_row(fetch, "X");             VEHICLE::PosX(playerid::i) = floatstr(fetch);
  18.             SQLfetch_field_row(fetch, "Y");             VEHICLE::PosY(playerid::i) = floatstr(fetch);
  19.             SQLfetch_field_row(fetch, "Z");             VEHICLE::PosZ(playerid::i) = floatstr(fetch);
  20.             SQLfetch_field_row(fetch, "Angle");         VEHICLE::Angle(playerid::i) = floatstr(fetch);
  21.             SQLfetch_field_row(fetch, "Spalva1");       VEHICLE::Spalva1(playerid::i) = strval(fetch);
  22.             SQLfetch_field_row(fetch, "Spalva2");       VEHICLE::Spalva2(playerid::i) = strval(fetch);
  23.             SQLfetch_field_row(fetch, "ShopKaina");     VEHICLE::ShopPrice(playerid::i) = strval(fetch);
  24.             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);
  25.             SQLfetch_field_row(fetch, "Degalai");       VehicleGas[VEHICLE::VehID(playerid::i)] = strval(fetch);
  26.             SQLfetch_field_row(fetch, "Degalu_Tipas");  VehicleGasType[VEHICLE::VehID(playerid::i)] = strval(fetch);
  27.             SQLfetch_field_row(fetch, "Rida");          VehicleMileage[VEHICLE::VehID(playerid::i)] = floatstr(fetch);
  28.             SQLfetch_field_row(fetch, "Uzraktas");
  29.            
  30.             if(strval(fetch) == 1)
  31.             {  
  32.                 Uzraktas[VEHICLE::VehID(playerid::i)] = true;
  33.             }
  34.             else if(strval(fetch) == 0)
  35.             {
  36.                 Uzraktas[VEHICLE::VehID(playerid::i)] = false;
  37.             }
  38.         }
  39.         else VEHICLE::VehID(playerid::i) = INVALID_VEHICLE_ID;
  40.     }
  41.  
  42.     for(new i = 0; i < MAX_PLAYER_VEHICLES; i++)
  43.     {
  44.         if(VEHICLE::VehID(playerid::i) == INVALID_VEHICLE_ID) continue;
  45.         LoadVehicleComponents(VEHICLE::SQLID(playerid::i), VEHICLE::VehID(playerid::i));
  46.     }
  47.     mysql_free_result();
  48.     return 1;
  49. }
Advertisement
Add Comment
Please, Sign In to add comment