API tools faq
paste
Guest User

Untitled

a guest
Jul 31st, 2017
137
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.00 KB | None | 0 0
raw download clone embed print report
  1. stock LoadPlayerVehicle(playerid)
  2.  
  3. {
  4.  
  5. if(!IsPlayerConnected(playerid)) return 1;
  6.  
  7. new Vardas[MAX_PLAYER_NAME];
  8.  
  9. GetPlayerName(playerid, Vardas, sizeof(Vardas));
  10.  
  11. new Query[500], String[500], Modelis, Float: Health, Float: vPos[4], Color[2];
  12.  
  13. format(Query, sizeof(Query), "SELECT * FROM `vehicles` WHERE `Transportas` = '%s'", Vardas);
  14.  
  15. mysql_query(Query);
  16.  
  17. mysql_store_result();
  18.  
  19. if(mysql_num_rows() != 0)
  20.  
  21. {
  22.  
  23. mysql_fetch_row(String);
  24.  
  25. mysql_fetch_field_row(Query, "Model"); Modelis = strval(Query);
  26.  
  27. mysql_fetch_field_row(Query, "Pos_X"); vPos[0] = floatstr(Query);
  28.  
  29. mysql_fetch_field_row(Query, "Pos_Y"); vPos[1] = floatstr(Query);
  30.  
  31. mysql_fetch_field_row(Query, "Pos_Z"); vPos[2] = floatstr(Query);
  32.  
  33. mysql_fetch_field_row(Query, "Pos_A"); vPos[3] = floatstr(Query);
  34.  
  35. mysql_fetch_field_row(Query, "Color1"); Color[0] = strval(Query);
  36.  
  37. mysql_fetch_field_row(Query, "Color2"); Color[1] = strval(Query);
  38.  
  39. mysql_fetch_field_row(Query, "Health"); Health = floatstr(Query);
  40.  
  41. new vehicleid = CreateVehicle(Modelis, vPos[0], vPos[1], vPos[2] + 3, vPos[3], Color[0], Color[1], -1);
  42.  
  43. SetVehicleHealth(vehicleid, Health);
  44.  
  45. mysql_fetch_field_row(Query, "Pos_X"); vehicleDB[vehicleid][vLastPos][0] = floatstr(Query);
  46.  
  47. mysql_fetch_field_row(Query, "Pos_Y"); vehicleDB[vehicleid][vLastPos][1] = floatstr(Query);
  48.  
  49. mysql_fetch_field_row(Query, "Pos_Z"); vehicleDB[vehicleid][vLastPos][2] = floatstr(Query);
  50.  
  51. mysql_fetch_field_row(Query, "Pos_A"); vehicleDB[vehicleid][vLastPos][3] = floatstr(Query);
  52.  
  53. mysql_fetch_field_row(Query, "Rida"); vehicleDB[vehicleid][Rida] = floatstr(Query);
  54.  
  55. mysql_fetch_field_row(Query, "Fuel"); vehicleDB[vehicleid][gas] = strval(Query);
  56.  
  57. mysql_fetch_field_row(Query, "Paintjob"); vehicleDB[vehicleid][vPaintjob] = strval(Query);
  58.  
  59. mysql_fetch_field_row(Query, "Tune0"); vehicleDB[vehicleid][vTune][0] = strval(Query);
  60.  
  61. mysql_fetch_field_row(Query, "Tune1"); vehicleDB[vehicleid][vTune][1] = strval(Query);
  62.  
  63. mysql_fetch_field_row(Query, "Tune2"); vehicleDB[vehicleid][vTune][2] = strval(Query);
  64.  
  65. mysql_fetch_field_row(Query, "Tune3"); vehicleDB[vehicleid][vTune][3] = strval(Query);
  66.  
  67. mysql_fetch_field_row(Query, "Tune4"); vehicleDB[vehicleid][vTune][4] = strval(Query);
  68.  
  69. mysql_fetch_field_row(Query, "Tune5"); vehicleDB[vehicleid][vTune][5] = strval(Query);
  70.  
  71. mysql_fetch_field_row(Query, "Tune6"); vehicleDB[vehicleid][vTune][6] = strval(Query);
  72.  
  73. mysql_fetch_field_row(Query, "Tune7"); vehicleDB[vehicleid][vTune][7] = strval(Query);
  74.  
  75. mysql_fetch_field_row(Query, "Tune8"); vehicleDB[vehicleid][vTune][8] = strval(Query);
  76.  
  77. mysql_fetch_field_row(Query, "Tune9"); vehicleDB[vehicleid][vTune][9] = strval(Query);
  78.  
  79. mysql_fetch_field_row(Query, "Tune10"); vehicleDB[vehicleid][vTune][10] = strval(Query);
  80.  
  81. mysql_fetch_field_row(Query, "Tune11"); vehicleDB[vehicleid][vTune][11] = strval(Query);
  82.  
  83. mysql_fetch_field_row(Query, "Tune12"); vehicleDB[vehicleid][vTune][12] = strval(Query);
  84.  
  85. mysql_fetch_field_row(Query, "Locked"); vehicleDB[vehicleid][vLocked] = !!strval(Query);
  86.  
  87. mysql_fetch_field_row(Query, "NumberPlate"); format(vehicleDB[vehicleid][vNumberPlate], 8, "%s", Query);
  88.  
  89. format(vehicleDB[vehicleid][vOwner], 21, "%s", GetPlayerNameEx(playerid));
  90.  
  91. SetVehicleNumberPlate(vehicleid, vehicleDB[vehicleid][vNumberPlate]);
  92.  
  93. Color[0] = vehicleDB[vehicleid][vColor][0];
  94.  
  95. Color[1] = vehicleDB[vehicleid][vColor][1];
  96.  
  97. vehicleDB[vehicleid][vOwned] = true;
  98.  
  99. playerDB[playerid][vCarID] = vehicleid;
  100.  
  101. SetVehicleToRespawn(vehicleid);
  102.  
  103. }
  104.  
  105. mysql_free_result();
  106.  
  107. return 1;
  108.  
  109. }
  110.  
  111. stock LoadPlayerVehicle2(playerid)
  112.  
  113. {
  114.  
  115. if(!IsPlayerConnected(playerid)) return 1;
  116.  
  117. new Vardas[MAX_PLAYER_NAME];
  118.  
  119. GetPlayerName(playerid, Vardas, sizeof(Vardas));
  120.  
  121. new Query[500], String[500], Modelis, Float: Health, Float: vPos[4], Color[2];
  122.  
  123. format(Query, sizeof(Query), "SELECT * FROM `vehicles` WHERE `Transportas` = '%s2'", Vardas);
  124.  
  125. mysql_query(Query);
  126.  
  127. mysql_store_result();
  128.  
  129. if(mysql_num_rows() != 0)
  130.  
  131. {
  132.  
  133. mysql_fetch_row(String);
  134.  
  135. mysql_fetch_field_row(Query, "Model"); Modelis = strval(Query);
  136.  
  137. mysql_fetch_field_row(Query, "Pos_X"); vPos[0] = floatstr(Query);
  138.  
  139. mysql_fetch_field_row(Query, "Pos_Y"); vPos[1] = floatstr(Query);
  140.  
  141. mysql_fetch_field_row(Query, "Pos_Z"); vPos[2] = floatstr(Query);
  142.  
  143. mysql_fetch_field_row(Query, "Pos_A"); vPos[3] = floatstr(Query);
  144.  
  145. mysql_fetch_field_row(Query, "Color1"); Color[0] = strval(Query);
  146.  
  147. mysql_fetch_field_row(Query, "Color2"); Color[1] = strval(Query);
  148.  
  149. mysql_fetch_field_row(Query, "Health"); Health = floatstr(Query);
  150.  
  151. new vehicleid = CreateVehicle(Modelis, vPos[0], vPos[1], vPos[2] + 3, vPos[3], Color[0], Color[1], -1);
  152.  
  153. SetVehicleHealth(vehicleid, Health);
  154.  
  155. mysql_fetch_field_row(Query, "Pos_X"); vehicleDB[vehicleid][vLastPos][0] = floatstr(Query);
  156.  
  157. mysql_fetch_field_row(Query, "Pos_Y"); vehicleDB[vehicleid][vLastPos][1] = floatstr(Query);
  158.  
  159. mysql_fetch_field_row(Query, "Pos_Z"); vehicleDB[vehicleid][vLastPos][2] = floatstr(Query);
  160.  
  161. mysql_fetch_field_row(Query, "Pos_A"); vehicleDB[vehicleid][vLastPos][3] = floatstr(Query);
  162.  
  163. mysql_fetch_field_row(Query, "Rida"); vehicleDB[vehicleid][Rida] = floatstr(Query);
  164.  
  165. mysql_fetch_field_row(Query, "Fuel"); vehicleDB[vehicleid][gas] = strval(Query);
  166.  
  167. mysql_fetch_field_row(Query, "Paintjob"); vehicleDB[vehicleid][vPaintjob] = strval(Query);
  168.  
  169. mysql_fetch_field_row(Query, "Tune0"); vehicleDB[vehicleid][vTune][0] = strval(Query);
  170.  
  171. mysql_fetch_field_row(Query, "Tune1"); vehicleDB[vehicleid][vTune][1] = strval(Query);
  172.  
  173. mysql_fetch_field_row(Query, "Tune2"); vehicleDB[vehicleid][vTune][2] = strval(Query);
  174.  
  175. mysql_fetch_field_row(Query, "Tune3"); vehicleDB[vehicleid][vTune][3] = strval(Query);
  176.  
  177. mysql_fetch_field_row(Query, "Tune4"); vehicleDB[vehicleid][vTune][4] = strval(Query);
  178.  
  179. mysql_fetch_field_row(Query, "Tune5"); vehicleDB[vehicleid][vTune][5] = strval(Query);
  180.  
  181. mysql_fetch_field_row(Query, "Tune6"); vehicleDB[vehicleid][vTune][6] = strval(Query);
  182.  
  183. mysql_fetch_field_row(Query, "Tune7"); vehicleDB[vehicleid][vTune][7] = strval(Query);
  184.  
  185. mysql_fetch_field_row(Query, "Tune8"); vehicleDB[vehicleid][vTune][8] = strval(Query);
  186.  
  187. mysql_fetch_field_row(Query, "Tune9"); vehicleDB[vehicleid][vTune][9] = strval(Query);
  188.  
  189. mysql_fetch_field_row(Query, "Tune10"); vehicleDB[vehicleid][vTune][10] = strval(Query);
  190.  
  191. mysql_fetch_field_row(Query, "Tune11"); vehicleDB[vehicleid][vTune][11] = strval(Query);
  192.  
  193. mysql_fetch_field_row(Query, "Tune12"); vehicleDB[vehicleid][vTune][12] = strval(Query);
  194.  
  195. mysql_fetch_field_row(Query, "Locked"); vehicleDB[vehicleid][vLocked] = !!strval(Query);
  196.  
  197. mysql_fetch_field_row(Query, "NumberPlate"); format(vehicleDB[vehicleid][vNumberPlate], 8, "%s", Query);
  198.  
  199. format(vehicleDB[vehicleid][vOwner], 21, "%s", GetPlayerNameEx(playerid));
  200.  
  201. SetVehicleNumberPlate(vehicleid, vehicleDB[vehicleid][vNumberPlate]);
  202.  
  203. Color[0] = vehicleDB[vehicleid][vColor][0];
  204.  
  205. Color[1] = vehicleDB[vehicleid][vColor][1];
  206.  
  207. vehicleDB[vehicleid][vOwned] = true;
  208.  
  209. playerDB[playerid][vCarID2] = vehicleid;
  210.  
  211. SetVehicleToRespawn(vehicleid);
  212.  
  213. }
  214.  
  215. mysql_free_result();
  216.  
  217. return 1;
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!