API tools faq
paste
Advertisement
Guest User

MYSQL R5 Autohaus (c) by Fabi.SatR

a guest
Dec 25th, 2012
211
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Pawn 30.93 KB | None | 0 0
raw download clone embed print report
  1. /*MYSQL Autohaus (c) by Fabi.StaR*/
  2. /*Das weiter verkaufen ist verbotten!*/
  3.  
  4. #include <a_samp>
  5. #include <ocmd>
  6. #include <a_mysql>
  7.  
  8. main(){print("Autohaus made by Fabi.StaR");}
  9.  
  10. #define Gelb  0xFFFF00AA
  11. #define Gruen 0x33AA33AA
  12. #define Rot   0xFF0000FF
  13.  
  14. //////////////////////////////////
  15. //////MYSQL//////////////////////
  16. ////////////////////////////////
  17. #define SQL_HOST   "localhost" //horst eingeben
  18. #define SQL_USER   "root" //deine User namen
  19. #define SQL_PASS   "" //dein User password
  20. #define SQL_DATA   "gta" //dein Datenbank namen vo die Tabelle ist
  21. /////////////////////////
  22. /////////Enum///////////
  23. ///////////////////////
  24. enum ahSpawn
  25. {
  26.     Float:pos_x,
  27.     Float:pos_y,
  28.     Float:pos_z,
  29.     Float:z_angle,
  30. };
  31. new Autospawns[2][ahSpawn] = {
  32.     {739.7457,-1343.8668,13.2828,270.2592},
  33.     {-1640.8845,1198.1356,6.9160,268.8890}
  34. };
  35.  
  36. enum autoverkaufInfo
  37. {
  38.     Autohaus,
  39.     FahrzeugName[128],
  40.     ModelID,
  41.     CarPreis,
  42.     RepPreis,
  43.     Float:AUTOPoS_X,
  44.     Float:AUTOPoS_Y,
  45.     Float:AUTOPoS_Z,
  46.     Float:AUTOPoS_A,
  47.     VEHID
  48. }
  49. new autokauf[38][autoverkaufInfo] = {
  50.     {0,"ZR-350",477,750000,2000,741.2859,-1333.7813,13.3365,209.3625,-1},
  51.     {0,"Banshee",429,1000000,5500,746.0001,-1333.0009,13.2095,211.0988,-1},
  52.     {0,"Alpha",602,23000,2000,750.9999,-1333.0048,13.3561,211.1028,-1},
  53.     {0,"Tampa",549,100000,1000,756.0007,-1333.0009,13.2672,211.1014,-1},
  54.     {0,"Glendale Shit",604,5000,50,761.0410,-1333.0162,13.3218,210.5058,-1},
  55.     {0,"Sultan",560,1500000,10000,766.0532,-1333.0228,13.1912,211.2380,-1},
  56.     {0,"Flash",565,1500000,7000,770.1692,-1333.5298,13.1734,209.6754,-1},
  57.     {0,"Cadrona",527,80000,800,782.9988,-1334.9996,13.2555,121.1070,-1},
  58.     {0,"Feltzer",533,500000,3000,783.0123,-1340.0615,13.2713,119.7727,-1},
  59.     {0,"Buccaneer",518,580000,5800,783.0063,-1345.0187,13.2394,120.6961,-1},
  60.     {0,"Bobcat",422,260000,2600,783.0119,-1350.0835,13.5442,121.3923,-1},
  61.     {0,"Remington",534,500000,3000,783.0036,-1355.0020,13.2813,120.9581,-1},
  62.     {0,"Savanna",567,350000,3000,783.0142,-1360.0333,13.4096,120.6085,-1},
  63.     {0,"Slamvan",535,500000,5000,783.0092,-1365.0315,13.3097,120.1563,-1},
  64.     {0,"Landstalker",400,250000,2500,783.0126,-1370.0470,13.6409,119.0777,-1},
  65.     {0,"Huntley",579,200000,1000,782.9914,-1375.0028,13.5639,121.1103,-1},
  66.     {0,"Stratum",561,1500000,15000,783.0280,-1380.0638,13.4564,118.4855,-1},
  67.     {0,"Picador",600,200000,2000,765.0041,-1379.9939,13.3950,301.0952,-1},
  68.     {0,"Patriot",470,650000,6500,764.9874,-1374.9368,13.5543,299.7244,-1},
  69.     {0,"Elegy",562,1500000,10000,765.0035,-1369.9968,13.1293,301.0979,-1},
  70.     {0,"Elegant",507,40000,650,765.0021,-1364.9957,13.3855,300.9562,-1},
  71.     {0,"Clover",542,35000,500,764.5659,-1359.4191,13.2437,301.4634,-1},
  72.     {0,"Sanchez",468,100000,2000,750.7290,-1358.3871,13.1730,273.7726,-1},
  73.     {0,"Freeway",463,200000,10000,744.0961,-1358.6742,13.0390,269.9220,-1},
  74.     {1,"Faggio",462,10000,100,-1674.3512,1216.8027,6.8678,288.0854,-1},
  75.     {1,"Washington",421,4500000,45000,-1660.7256,1217.6407,13.5392,283.1553,-1},
  76.     {1,"Club",589,70000,750,-1665.7789,1222.4406,13.3043,279.6459,-1},
  77.     {1,"Infernus",411,1700000,7000,-1651.4218,1209.5952,13.3990,274.0950,-1},
  78.     {1,"Cheetah",415,115000,10000,-1677.3560,1207.8099,13.4461,208.2602,-1},
  79.     {1,"Jester",559,1500000,10000,-1676.0139,1207.1642,20.8412,261.5085,-1},
  80.     {1,"Phönix",603,600000,4000,-1664.4376,1206.8243,20.9268,332.6265,-1},
  81.     {1,"SUPER-GT",506,12500000,20000,-1651.6368,1208.2538,20.8447,305.1017,-1},
  82.     {1,"Premier",426,750000,18000,-1654.3116,1214.8104,20.9259,173.5713,-1},
  83.     {1,"Uranus",558,85000,10000,-1661.1927,1217.9641,20.8001,286.1666,-1},
  84.     {1,"Turismo",451,13000000,20000,-1665.1251,1222.7295,21.1744,268.0075,-1},
  85.     {1,"Buffalo",402,500000,3000,-1663.6698,1215.2883,7.0461,274.9876,-1},
  86.     {1,"Bullet",541,7500000,17500,-1651.3835,1210.3475,6.8957,281.3334,-1},
  87.     {1,"Blista Compact",496,350000,2500,-1668.6449,1207.0300,6.9655,309.3837,-1}
  88. };
  89.  
  90. enum sAutoInfo
  91. {
  92.     ModelID,sName[64],Preis,
  93.     Carid,pKey,Float:pAUTOPoS_X,
  94.     Float:pAUTOPoS_Y,Float:pAUTOPoS_Z,
  95.     Float:pAUTOPoS_A,Farbe1,Farbe2,Status,
  96.     spaintjobid,modspoiler,modnitro,modwheels,
  97.     modlights,modhood,modexhaust,modhydrau,reppreis,
  98.     modroof,modstereo,modfrontbumper,modrearfumper,
  99.     modventsr,modventsl,modsideskirtr,modsideskirtl,
  100.     modbullbar,modrearbullbars,modfrontbullbars,
  101.     modbullbars
  102. }
  103. new pAutoInfo[MAX_PLAYERS][sAutoInfo];
  104.  
  105. public OnGameModeInit()
  106. {
  107.     SetGameModeText("Autohaus");
  108.     Connect_To_Database();
  109.     AddPlayerClass(0, 1107.3007,-1796.3503,16.5938, 92.1999, 0, 0, 0, 0, 0, 0);
  110.  
  111.     for(new i=0; i<sizeof(autokauf); i++)
  112.     {
  113.         autokauf[i][VEHID]=CreateVehicle(autokauf[i][ModelID],autokauf[i][AUTOPoS_X],autokauf[i][AUTOPoS_Y],autokauf[i][AUTOPoS_Z],autokauf[i][AUTOPoS_A],-1,-1,5000);
  114.     }
  115.     return 1;
  116. }
  117. ///////////////////
  118.  
  119. public OnGameModeExit()
  120. {
  121.     for(new i=0; i<MAX_PLAYERS; i++){SaveAuto(i);}
  122.     return 1;
  123. }
  124.  
  125. public OnPlayerRequestClass(playerid, classid)
  126. {
  127.     SetPlayerPos(playerid, 1958.3783, 1343.1572, 15.3746);
  128.     SetPlayerCameraPos(playerid, 1958.3783, 1343.1572, 15.3746);
  129.     SetPlayerCameraLookAt(playerid, 1958.3783, 1343.1572, 15.3746);
  130.     return 1;
  131. }
  132.  
  133. public OnPlayerConnect(playerid)
  134. {
  135.     if(mysql_CheckCar(playerid) == 1)
  136.     {
  137.         loadCar(playerid);
  138.     }
  139.     else{return 1;}
  140.     return 1;
  141. }
  142.  
  143. public OnPlayerDisconnect(playerid, reason)
  144. {
  145.     SaveAuto(playerid);
  146.     DestroyVehicle(pAutoInfo[playerid][Carid]);
  147.     return 1;
  148. }
  149.  
  150. public OnPlayerSpawn(playerid)
  151. {
  152.     return 1;
  153. }
  154.  
  155. public OnVehicleSpawn(vehicleid)
  156. {
  157.     return 1;
  158. }
  159.  
  160. public OnVehicleDeath(vehicleid, killerid)
  161. {
  162.     for(new i=0; i<MAX_PLAYERS; i++)
  163.     {
  164.         if(pAutoInfo[i][Carid]==vehicleid)
  165.         {
  166.             SetTimerEx("DelayDestroyCar",3000,0,"i",i);
  167.             return 1;
  168.         }
  169.     }
  170.     return 1;
  171. }
  172.  
  173. ocmd:fixcar(playerid, params[])
  174. {
  175.     if(pAutoInfo[playerid][pKey] == 1)
  176.     {
  177.         if(pAutoInfo[playerid][Status]==0)
  178.         {
  179.             new string[128];
  180.             new reparatur = pAutoInfo[playerid][reppreis];
  181.             if(reparatur <= GetPlayerMoney(playerid))
  182.             {
  183.                 pAutoInfo[playerid][Status]=1;
  184.                 loadCar(playerid);
  185.                 GivePlayerMoney(playerid, - reparatur);
  186.                 format(string, 128, "Du hast dein Auto für $%i reparieren lassen! Es steht nun am letzten Parkpunkt für dich bereit.", reparatur);
  187.                 SendClientMessage(playerid, Gruen, string);
  188.             }
  189.             else {format(string,Gruen,"Du hast nicht genug Geld für die Reparatur (benötigt: $%i)!", reparatur); SendClientMessage(playerid, Gelb, string); }
  190.         }
  191.         else { SendClientMessage(playerid, Rot, "Dein Auto benötigt keine Reparatur!"); }
  192.     }
  193.     else { SendClientMessage(playerid, Rot,"Du besitzt kein Auto!"); }
  194.     return 1;
  195. }
  196. ocmd:exitcar(playerid, params[])
  197. {
  198.     for(new i=0; i<sizeof(autokauf); i++)
  199.     {
  200.         if(autokauf[i][VEHID]==GetPlayerVehicleID(playerid))
  201.         {
  202.             TogglePlayerControllable(playerid,1);
  203.             RemovePlayerFromVehicle(playerid);
  204.             return 1;
  205.         }
  206.     }
  207.     return 1;
  208. }
  209. ocmd:park(playerid, params[])
  210. {
  211.     if(pAutoInfo[playerid][Carid]==GetPlayerVehicleID(playerid))
  212.     {
  213.         new Float:X,Float:Z,Float:Y,Float:A;
  214.         GetVehiclePos(pAutoInfo[playerid][Carid],X,Y,Z);
  215.         GetVehicleZAngle(pAutoInfo[playerid][Carid],A);
  216.         pAutoInfo[playerid][pAUTOPoS_X] = X;
  217.         pAutoInfo[playerid][pAUTOPoS_Y] = Y;
  218.         pAutoInfo[playerid][pAUTOPoS_Z] = Z;
  219.         pAutoInfo[playerid][pAUTOPoS_A] = A;
  220.         SendClientMessage(playerid, Gruen, "Fahrzeug geparkt!");
  221.         SaveAuto(playerid);
  222.     }else{SendClientMessage(playerid,Rot,"Dieses Fahrzeug gehört dir nicht!");}
  223.     return 1;
  224. }
  225. ocmd:autosf(playerid, params[])
  226. {
  227.     SetPlayerPos(playerid,-1640.8053,1203.3352,7.2406);
  228.     SetPlayerFacingAngle(playerid,71.2314);
  229.     return 1;
  230. }
  231. ocmd:autols(playerid, params[])
  232. {
  233.     SetPlayerPos(playerid,764.5224,-1344.7325,13.5165);
  234.     SetPlayerFacingAngle(playerid,65.7222);
  235.     return 1;
  236. }
  237. ocmd:geld(playerid, params[])
  238. {
  239.     GivePlayerMoney(playerid,600000000);
  240.     return 1;
  241. }
  242. ocmd:giveauto(playerid,params[])
  243. {
  244.     new Float:X,Float:Y,Float:Z,Float:A;
  245.     GetPlayerPos(playerid,X,Y,Z);
  246.     GetPlayerFacingAngle(playerid,A);
  247.     new carid = CreateVehicle(462,X,Y,Z,A,-1,-1,-1);
  248.     AddVehicleComponent(carid,1010);
  249.     AddVehicleComponent(carid,1081);
  250.     SetVehicleNumberPlate(carid,"~>Admin<~");
  251.     PutPlayerInVehicle(playerid, carid, 0);
  252.     return 1;
  253. }
  254. ocmd:sellcar(playerid, params[])
  255. {
  256.     if(pAutoInfo[playerid][Carid])
  257.     {
  258.         if(pAutoInfo[playerid][pKey] > 0)
  259.         {
  260.             new str[128];
  261.             new vkpreis = pAutoInfo[playerid][Preis];
  262.             GivePlayerMoney(playerid,vkpreis);
  263.             format(str,sizeof(str),"Du hast denn Fahrzeug erfolgreich für %i verkauft.",vkpreis);
  264.             SendClientMessage(playerid,Gruen,str);
  265.             DestroyVehicle(pAutoInfo[playerid][Carid]);
  266.             pAutoInfo[playerid][pKey]=0;
  267.             DeleteCar(playerid);
  268.             return 1;
  269.         }else{SendClientMessage(playerid,Rot,"** Du besitzt kein Fahrzeug!");}
  270.     }
  271.     return 1;
  272. }
  273. ocmd:buycar(playerid, params[])
  274. {
  275.     if(GetPlayerState(playerid) == PLAYER_STATE_DRIVER)
  276.     {
  277.         for(new i=0; i<sizeof(autokauf); i++)
  278.         {
  279.             new cpreis =autokauf[i][CarPreis];
  280.             new str[128];
  281.             format(str,sizeof(str),"Du besitzt zuwenig geld du benötigst %i", cpreis);
  282.             new autohaus=autokauf[i][Autohaus];
  283.             if(pAutoInfo[playerid][pKey] < 1)
  284.             {
  285.                 if(autokauf[i][VEHID]==GetPlayerVehicleID(playerid))
  286.                 {
  287.                     if(cpreis <= GetPlayerMoney(playerid))
  288.                     {
  289.                         GivePlayerMoney(playerid,-cpreis);
  290.                         pAutoInfo[playerid][pAUTOPoS_X]=Autospawns[autohaus][pos_x];
  291.                         pAutoInfo[playerid][pAUTOPoS_Y]=Autospawns[autohaus][pos_y];
  292.                         pAutoInfo[playerid][pAUTOPoS_Z]=Autospawns[autohaus][pos_z];
  293.                         pAutoInfo[playerid][pAUTOPoS_A]=Autospawns[autohaus][z_angle];
  294.                         pAutoInfo[playerid][Preis]=cpreis/2;
  295.                         pAutoInfo[playerid][ModelID]=autokauf[i][ModelID];
  296.                         pAutoInfo[playerid][reppreis]=autokauf[i][RepPreis];
  297.                         fahrzeugtun(playerid);
  298.                         pAutoInfo[playerid][pKey]=1;
  299.                         pAutoInfo[playerid][Carid] = AddStaticVehicle(pAutoInfo[playerid][ModelID],pAutoInfo[playerid][pAUTOPoS_X],pAutoInfo[playerid][pAUTOPoS_Y],pAutoInfo[playerid][pAUTOPoS_Z],pAutoInfo[playerid][pAUTOPoS_A],-1,-1);
  300.                         SendClientMessage(playerid, Gruen, "Mit /carlock kannst du dein Fahrzeug für andere Leute freigeben oder abschließen.");
  301.                         SendClientMessage(playerid, Gelb, "Dein Auto steht am Ausgabepunkt bereit! Viel Spaß beim Fahren! Und Beachte die StVo!");
  302.                         TogglePlayerControllable(playerid,1);
  303.                         RemovePlayerFromVehicle(playerid);
  304.                         CreateCar(playerid);
  305.                         SaveAuto(playerid);
  306.                         break;
  307.                     }
  308.                     else{SendClientMessage(playerid,Rot,str);}
  309.                 }
  310.             }
  311.             else{SendClientMessage(playerid,Rot,"** Du besitzt doch schon ein Fahrzeug."); return 1;}
  312.         }
  313.     }
  314.     else{SendClientMessage(playerid,Rot,"Du bist in keinem Autohaus Auto!"); return 1;}
  315.     return 1;
  316. }
  317.  
  318. public OnPlayerStateChange(playerid, newstate, oldstate)
  319. {
  320.     if(newstate == PLAYER_STATE_DRIVER)
  321.     {
  322.         for(new i=0; i<sizeof(autokauf); i++)
  323.         {
  324.             if(GetPlayerVehicleID(playerid)==autokauf[i][VEHID])
  325.             {
  326.                 new string[128];
  327.                 TogglePlayerControllable(playerid,0);
  328.                 SendClientMessage(playerid, Gelb, "~*~ Autohaus ~*~");
  329.                 format(string,128,"Name: %s",autokauf[i][FahrzeugName]);
  330.                 SendClientMessage(playerid, Gelb, string);
  331.                 format(string,128,"Preis: $%i",autokauf[i][CarPreis]);
  332.                 SendClientMessage(playerid, Gelb, string);
  333.                 format(string,128,"Reparaturkosten: $%i",autokauf[i][RepPreis]);
  334.                 SendClientMessage(playerid, Gelb, string);
  335.                 SendClientMessage(playerid, Gruen, "Um es zu kaufen, benutze: /buycar");
  336.                 SendClientMessage(playerid, Gruen, "Um das Fahrzeug zu verlassen, benutze: /exitcar");
  337.             }
  338.         }
  339.     }
  340.     return 1;
  341. }
  342.  
  343. public OnVehicleMod(playerid,vehicleid,componentid)
  344. {
  345.     if(pAutoInfo[playerid][Carid]==GetPlayerVehicleID(playerid))
  346.     {
  347.         new mod=GetModType(componentid);
  348.         switch(mod)
  349.         {
  350.             case 1: {pAutoInfo[playerid][modspoiler]=componentid;}
  351.             case 2: {pAutoInfo[playerid][modnitro]=componentid;}
  352.             case 3: {pAutoInfo[playerid][modwheels]=componentid;}
  353.             case 4: {pAutoInfo[playerid][modlights]=componentid;}
  354.             case 5: {pAutoInfo[playerid][modhood]=componentid;}
  355.             case 6: {pAutoInfo[playerid][modexhaust]=componentid;}
  356.             case 7: {pAutoInfo[playerid][modhydrau]=componentid;}
  357.             case 8: {pAutoInfo[playerid][modroof]=componentid;}
  358.             case 9: {pAutoInfo[playerid][modstereo]=componentid;}
  359.             case 10: {pAutoInfo[playerid][modfrontbumper]=componentid;}
  360.             case 11: {pAutoInfo[playerid][modrearfumper]=componentid;}
  361.             case 12: {pAutoInfo[playerid][modventsr]=componentid;}
  362.             case 13: {pAutoInfo[playerid][modventsl]=componentid;}
  363.             case 14: {pAutoInfo[playerid][modsideskirtr]=componentid;}
  364.             case 15: {pAutoInfo[playerid][modsideskirtl]=componentid;}
  365.             case 16: {pAutoInfo[playerid][modbullbar]=componentid;}
  366.             case 17: {pAutoInfo[playerid][modrearbullbars]=componentid;}
  367.             case 18: {pAutoInfo[playerid][modfrontbullbars]=componentid;}
  368.             case 19: {pAutoInfo[playerid][modbullbars]=componentid;}
  369.             default: { new string[128]; format(string,128,"Unbekannte Komponentenid: %i",componentid); print(string); }
  370.         }
  371.         SaveAuto(playerid);
  372.     }
  373.     return 1;
  374. }
  375.  
  376. public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
  377. {
  378.     if(pAutoInfo[playerid][Carid]==GetPlayerVehicleID(playerid))
  379.     {
  380.         pAutoInfo[playerid][spaintjobid]=paintjobid;
  381.         SaveAuto(playerid);
  382.     }
  383.     return 1;
  384. }
  385.  
  386. public OnVehicleRespray(playerid,vehicleid, color1, color2)
  387. {
  388.     if(pAutoInfo[playerid][Carid]==GetPlayerVehicleID(playerid))
  389.     {
  390.         pAutoInfo[playerid][Farbe1]=color1;
  391.         pAutoInfo[playerid][Farbe2]=color2;
  392.         SaveAuto(playerid);
  393.     }
  394.     return 1;
  395. }
  396.  
  397. public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
  398. {
  399.     return 1;
  400. }
  401.  
  402. stock Connect_To_Database()
  403. {
  404.     mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
  405.     if(mysql_ping() == 1)
  406.     {
  407.         print("<-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt!");
  408.         return true;
  409.     }
  410.     else
  411.     {
  412.         print("<-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!");
  413.         print("<-| [MYSQL] Es wird erneut versucht eine Verbindung zur Datenbank herzustellen!");
  414.         mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
  415.         if(mysql_ping() == 1)
  416.         {
  417.             print("<-| [MYSQL] Es konnte im 2 Versuch eine Verbindung hergestellt werden!");
  418.             return true;
  419.         }
  420.         else
  421.         {
  422.             print("<-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!");
  423.             print("<-| [MYSQL] Der Server wird nun beendet!");
  424.             SendRconCommand("exit");
  425.             return true;
  426.         }
  427.     }
  428. }
  429. stock mysql_CheckCar(playerid)
  430. {
  431.     new Query[128],Name[MAX_PLAYER_NAME],count;
  432.     GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
  433.     mysql_real_escape_string(Name, Name);
  434.     format(Query, sizeof(Query), "SELECT * FROM `cars` WHERE `Name` = '%s'", Name);
  435.     mysql_query(Query);
  436.     mysql_store_result();
  437.     count = mysql_num_rows();
  438.     mysql_free_result();
  439.     return count;
  440. }
  441. stock CreateCar(playerid)
  442. {
  443.     new query[256],Name[MAX_PLAYER_NAME];
  444.     GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
  445.     mysql_real_escape_string(Name,Name);
  446.     format(query, sizeof(query), "INSERT INTO `cars` (`Name`) VALUES ('%s')", Name);
  447.     mysql_query(query);
  448.     return true;
  449. }
  450. stock DeleteCar(playerid)
  451. {
  452.    new query[256],Name[MAX_PLAYER_NAME];
  453.    GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
  454.    format(query, sizeof(query), "DELETE  FROM `cars` WHERE `Name`='%s'", Name);
  455.    mysql_query(query);
  456.    return 1;
  457. }
  458.  
  459. stock loadCar(playerid)
  460. {
  461.     GetPlayerName(playerid, pAutoInfo[playerid][sName], MAX_PLAYER_NAME);
  462.     pAutoInfo[playerid][pKey] = mysql_GetInt("cars", "Key", "Name", pAutoInfo[playerid][sName]);
  463.     pAutoInfo[playerid][pAUTOPoS_X] = mysql_GetFloat("cars", "AutoX", "Name", pAutoInfo[playerid][sName]);
  464.     pAutoInfo[playerid][pAUTOPoS_Y] = mysql_GetFloat("cars", "AutoY", "Name", pAutoInfo[playerid][sName]);
  465.     pAutoInfo[playerid][pAUTOPoS_Z] = mysql_GetFloat("cars", "AutoZ", "Name", pAutoInfo[playerid][sName]);
  466.     pAutoInfo[playerid][pAUTOPoS_A] = mysql_GetFloat("cars", "AutoA", "Name", pAutoInfo[playerid][sName]);
  467.     pAutoInfo[playerid][ModelID] = mysql_GetInt("cars", "ModelID", "Name", pAutoInfo[playerid][sName]);
  468.     pAutoInfo[playerid][Farbe1] = mysql_GetInt("cars", "Farbe1", "Name", pAutoInfo[playerid][sName]);
  469.     pAutoInfo[playerid][Farbe2] = mysql_GetInt("cars", "Farbe2", "Name", pAutoInfo[playerid][sName]);
  470.     pAutoInfo[playerid][Preis] = mysql_GetInt("cars", "VKPreis", "Name", pAutoInfo[playerid][sName]);
  471.     pAutoInfo[playerid][reppreis] = mysql_GetInt("cars", "ReparaturPreis", "Name", pAutoInfo[playerid][sName]);
  472.     pAutoInfo[playerid][spaintjobid] = mysql_GetInt("cars", "PaintJob", "Name", pAutoInfo[playerid][sName]);
  473.     pAutoInfo[playerid][modspoiler] = mysql_GetInt("cars", "Spoiler", "Name", pAutoInfo[playerid][sName]);
  474.     pAutoInfo[playerid][modnitro] = mysql_GetInt("cars", "Nitro", "Name", pAutoInfo[playerid][sName]);
  475.     pAutoInfo[playerid][modwheels] = mysql_GetInt("cars", "Wheels", "Name", pAutoInfo[playerid][sName]);
  476.     pAutoInfo[playerid][modlights] = mysql_GetInt("cars", "Lights", "Name", pAutoInfo[playerid][sName]);
  477.     pAutoInfo[playerid][modhood] = mysql_GetInt("cars", "MotorHaube", "Name", pAutoInfo[playerid][sName]);
  478.     pAutoInfo[playerid][modexhaust] = mysql_GetInt("cars", "Auspuff", "Name", pAutoInfo[playerid][sName]);
  479.     pAutoInfo[playerid][modhydrau] = mysql_GetInt("cars", "Hydraulic", "Name", pAutoInfo[playerid][sName]);
  480.     pAutoInfo[playerid][modroof] = mysql_GetInt("cars", "AutoDach", "Name", pAutoInfo[playerid][sName]);
  481.     pAutoInfo[playerid][modstereo] = mysql_GetInt("cars", "Stereo", "Name", pAutoInfo[playerid][sName]);
  482.     pAutoInfo[playerid][modfrontbumper] = mysql_GetInt("cars","Frontstossstange", "Name", pAutoInfo[playerid][sName]);
  483.     pAutoInfo[playerid][modrearfumper] = mysql_GetInt("cars","Heckstossstange", "Name", pAutoInfo[playerid][sName]);
  484.     pAutoInfo[playerid][modventsl] = mysql_GetInt("cars","VentsLinks", "Name", pAutoInfo[playerid][sName]);
  485.     pAutoInfo[playerid][modventsr] = mysql_GetInt("cars","VentsRechts", "Name", pAutoInfo[playerid][sName]);
  486.     pAutoInfo[playerid][modsideskirtr] = mysql_GetInt("cars","SchwellerleistenRechts", "Name", pAutoInfo[playerid][sName]);
  487.     pAutoInfo[playerid][modsideskirtl] = mysql_GetInt("cars","SchwellerleistenLinks", "Name", pAutoInfo[playerid][sName]);
  488.     pAutoInfo[playerid][modbullbar] = mysql_GetInt("cars","BullBar", "Name", pAutoInfo[playerid][sName]);
  489.     pAutoInfo[playerid][modrearbullbars] = mysql_GetInt("cars","rearbullbars", "Name", pAutoInfo[playerid][sName]);
  490.     pAutoInfo[playerid][modfrontbullbars] = mysql_GetInt("cars","frontbullbars", "Name", pAutoInfo[playerid][sName]);
  491.     pAutoInfo[playerid][modbullbars] = mysql_GetInt("cars","Stossstangen", "Name", pAutoInfo[playerid][sName]);
  492.     pAutoInfo[playerid][Carid] = CreateVehicle(pAutoInfo[playerid][ModelID],pAutoInfo[playerid][pAUTOPoS_X],pAutoInfo[playerid][pAUTOPoS_Y],pAutoInfo[playerid][pAUTOPoS_Z],pAutoInfo[playerid][pAUTOPoS_A],pAutoInfo[playerid][Farbe1],pAutoInfo[playerid][Farbe2],-1);
  493.     ChangeVehiclePaintjob(pAutoInfo[playerid][Carid],pAutoInfo[playerid][spaintjobid]);
  494.     AddVehicleComponent(pAutoInfo[playerid][Carid],pAutoInfo[playerid][modspoiler]);
  495.     AddVehicleComponent(pAutoInfo[playerid][Carid],pAutoInfo[playerid][modnitro]);
  496.     AddVehicleComponent(pAutoInfo[playerid][Carid],pAutoInfo[playerid][modwheels]);
  497.     AddVehicleComponent(pAutoInfo[playerid][Carid],pAutoInfo[playerid][modlights]);
  498.     AddVehicleComponent(pAutoInfo[playerid][Carid],pAutoInfo[playerid][modhood]);
  499.     AddVehicleComponent(pAutoInfo[playerid][Carid],pAutoInfo[playerid][modexhaust]);
  500.     AddVehicleComponent(pAutoInfo[playerid][Carid],pAutoInfo[playerid][modhydrau]);
  501.     AddVehicleComponent(pAutoInfo[playerid][Carid],pAutoInfo[playerid][modroof]);
  502.     AddVehicleComponent(pAutoInfo[playerid][Carid],pAutoInfo[playerid][modstereo]);
  503.     AddVehicleComponent(pAutoInfo[playerid][Carid],pAutoInfo[playerid][modfrontbumper]);
  504.     AddVehicleComponent(pAutoInfo[playerid][Carid],pAutoInfo[playerid][modrearfumper]);
  505.     AddVehicleComponent(pAutoInfo[playerid][Carid],pAutoInfo[playerid][modventsl]);
  506.     AddVehicleComponent(pAutoInfo[playerid][Carid],pAutoInfo[playerid][modventsr]);
  507.     AddVehicleComponent(pAutoInfo[playerid][Carid],pAutoInfo[playerid][modsideskirtr]);
  508.     AddVehicleComponent(pAutoInfo[playerid][Carid],pAutoInfo[playerid][modsideskirtl]);
  509.     AddVehicleComponent(pAutoInfo[playerid][Carid],pAutoInfo[playerid][modbullbar]);
  510.     AddVehicleComponent(pAutoInfo[playerid][Carid],pAutoInfo[playerid][modrearbullbars]);
  511.     AddVehicleComponent(pAutoInfo[playerid][Carid],pAutoInfo[playerid][modfrontbullbars]);
  512.     AddVehicleComponent(pAutoInfo[playerid][Carid],pAutoInfo[playerid][modbullbars]);
  513.     printf("--> Das Fahrzeug von %s wurde erfolgreich von der MySQL Datenbak geladen.", pAutoInfo[playerid][sName]);
  514.     return 1;
  515. }
  516. stock SaveAuto(playerid)
  517. {
  518.     GetPlayerName(playerid, pAutoInfo[playerid][sName], MAX_PLAYER_NAME);
  519.     mysql_SetInt("cars", "Key",pAutoInfo[playerid][pKey], "Name", pAutoInfo[playerid][sName]);
  520.     mysql_SetInt("cars","VKPreis",pAutoInfo[playerid][Preis], "Name", pAutoInfo[playerid][sName]);
  521.     mysql_SetInt("cars", "ReparaturPreis",pAutoInfo[playerid][reppreis], "Name", pAutoInfo[playerid][sName]);
  522.     mysql_SetInt("cars","ModelID",pAutoInfo[playerid][ModelID], "Name",pAutoInfo[playerid][sName]);
  523.     mysql_SetInt("cars","Farbe1",pAutoInfo[playerid][Farbe1], "Name", pAutoInfo[playerid][sName]);
  524.     mysql_SetInt("cars","Farbe2",pAutoInfo[playerid][Farbe2], "Name", pAutoInfo[playerid][sName]);
  525.     mysql_SetInt("cars","Spoiler",pAutoInfo[playerid][modspoiler], "Name", pAutoInfo[playerid][sName]);
  526.     mysql_SetInt("cars","Nitro",pAutoInfo[playerid][modnitro], "Name", pAutoInfo[playerid][sName]);
  527.     mysql_SetInt("cars","Wheels",pAutoInfo[playerid][modwheels], "Name", pAutoInfo[playerid][sName]);
  528.     mysql_SetInt("cars","Lights",pAutoInfo[playerid][modlights], "Name", pAutoInfo[playerid][sName]);
  529.     mysql_SetInt("cars","MotorHaube",pAutoInfo[playerid][modhood], "Name", pAutoInfo[playerid][sName]);
  530.     mysql_SetInt("cars","Auspuff",pAutoInfo[playerid][modexhaust], "Name", pAutoInfo[playerid][sName]);
  531.     mysql_SetInt("cars","Hydraulic",pAutoInfo[playerid][modhydrau], "Name", pAutoInfo[playerid][sName]);
  532.     mysql_SetInt("cars","AutoDach",pAutoInfo[playerid][modroof], "Name", pAutoInfo[playerid][sName]);
  533.     mysql_SetInt("cars","Stereo",pAutoInfo[playerid][modstereo], "Name", pAutoInfo[playerid][sName]);
  534.     mysql_SetInt("cars","Frontstossstange",pAutoInfo[playerid][modfrontbumper], "Name", pAutoInfo[playerid][sName]);
  535.     mysql_SetInt("cars","Heckstossstange",pAutoInfo[playerid][modrearfumper], "Name", pAutoInfo[playerid][sName]);
  536.     mysql_SetInt("cars","VentsLinks",pAutoInfo[playerid][modventsl], "Name", pAutoInfo[playerid][sName]);
  537.     mysql_SetInt("cars","VentsRechts",pAutoInfo[playerid][modventsr], "Name", pAutoInfo[playerid][sName]);
  538.     mysql_SetInt("cars","SchwellerleistenRechts",pAutoInfo[playerid][modsideskirtr], "Name", pAutoInfo[playerid][sName]);
  539.     mysql_SetInt("cars","SchwellerleistenLinks",pAutoInfo[playerid][modsideskirtl], "Name", pAutoInfo[playerid][sName]);
  540.     mysql_SetInt("cars","BullBar",pAutoInfo[playerid][modbullbar], "Name", pAutoInfo[playerid][sName]);
  541.     mysql_SetInt("cars","rearbullbars",pAutoInfo[playerid][modrearbullbars], "Name", pAutoInfo[playerid][sName]);
  542.     mysql_SetInt("cars","frontbullbars",pAutoInfo[playerid][modfrontbullbars], "Name", pAutoInfo[playerid][sName]);
  543.     mysql_SetInt("cars","Stossstangen",pAutoInfo[playerid][modbullbars], "Name", pAutoInfo[playerid][sName]);
  544.     mysql_SetInt("cars","PaintJob",pAutoInfo[playerid][spaintjobid], "Name",pAutoInfo[playerid][sName]);
  545.     mysql_SetFloat("cars", "AutoX",pAutoInfo[playerid][pAUTOPoS_X], "Name", pAutoInfo[playerid][sName]);
  546.     mysql_SetFloat("cars", "AutoY",pAutoInfo[playerid][pAUTOPoS_Y], "Name", pAutoInfo[playerid][sName]);
  547.     mysql_SetFloat("cars", "AutoZ",pAutoInfo[playerid][pAUTOPoS_Z], "Name", pAutoInfo[playerid][sName]);
  548.     mysql_SetFloat("cars", "AutoA",pAutoInfo[playerid][pAUTOPoS_A], "Name", pAutoInfo[playerid][sName]);
  549.     printf("--> Das Fahrzeug von %s wurde erfolgreich in der MySQL Datenbak gespeichert.", pAutoInfo[playerid][sName]);
  550.     return 1;
  551. }
  552. stock mysql_GetString(Table[], Field[], Where[], Is[])
  553. {
  554.     new query[128], Get[128];
  555.     mysql_real_escape_string(Table, Table);
  556.     mysql_real_escape_string(Field, Field);
  557.     mysql_real_escape_string(Where, Where);
  558.     mysql_real_escape_string(Is, Is);
  559.     format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
  560.     mysql_query(query);
  561.     mysql_store_result();
  562.     mysql_fetch_row(Get);
  563.     mysql_free_result();
  564.     return Get;
  565. }
  566. stock mysql_GetInt(Table[], Field[], Where[], Is[])
  567. {
  568.     new query[128];
  569.     mysql_real_escape_string(Table, Table);
  570.     mysql_real_escape_string(Field, Field);
  571.     mysql_real_escape_string(Where, Where);
  572.     mysql_real_escape_string(Is, Is);
  573.     format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
  574.     mysql_query(query);
  575.     mysql_store_result();
  576.     new sqlint = mysql_fetch_int();
  577.     mysql_free_result();
  578.     return sqlint;
  579. }
  580. forward Float:mysql_GetFloat(Table[], Field[], Where[], Is[]);
  581. stock Float:mysql_GetFloat(Table[], Field[], Where[], Is[])
  582. {
  583.     new query[128], Float:sqlfloat;
  584.     mysql_real_escape_string(Table, Table);
  585.     mysql_real_escape_string(Field, Field);
  586.     mysql_real_escape_string(Where, Where);
  587.     mysql_real_escape_string(Is, Is);
  588.     format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
  589.     mysql_query(query);
  590.     mysql_store_result();
  591.     mysql_fetch_float(sqlfloat);
  592.     mysql_free_result();
  593.     return sqlfloat;
  594. }
  595. stock mysql_SetInt(Table[], Field[], To, Where[], Where2[])
  596. {
  597.     new query[128];
  598.     mysql_real_escape_string(Table, Table);
  599.     mysql_real_escape_string(Field, Field);
  600.     mysql_real_escape_string(Where, Where);
  601.     mysql_real_escape_string(Where2, Where2);
  602.     format(query, 128, "UPDATE `%s` SET `%s` = '%d' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
  603.     mysql_query(query);
  604.     return true;
  605. }
  606. stock mysql_SetString(Table[], Field[], To[], Where[], Where2[])
  607. {
  608.     new query[128];
  609.     mysql_real_escape_string(Table, Table);
  610.     mysql_real_escape_string(Field, Field);
  611.     mysql_real_escape_string(To, To);
  612.     mysql_real_escape_string(Where, Where);
  613.     mysql_real_escape_string(Where2, Where2);
  614.     format(query, 128, "UPDATE `%s` SET `%s` = '%s' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
  615.     mysql_query(query);
  616.     return true;
  617. }
  618. stock mysql_SetFloat(Table[], Field[], Float:To, Where[], Where2[])
  619. {
  620.     new query[128];
  621.     mysql_real_escape_string(Table, Table);
  622.     mysql_real_escape_string(Field, Field);
  623.     mysql_real_escape_string(Where, Where);
  624.     mysql_real_escape_string(Where2, Where2);
  625.     format(query, 128, "UPDATE `%s` SET `%s` = '%f' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
  626.     mysql_query(query);
  627.     return true;
  628. }
  629.  
  630. // Tuning Stocks //
  631. new wheels[17][0] = {
  632.     {1025},{1073},{1074},{1075},{1076},{1077},{1078},{1079},{1080},{1081},{1082},{1083},
  633.     {1084},{1085},{1096},{1097},{1098}
  634. };
  635. new spoiler[20][0] = {
  636.     {1000},{1001},{1002},{1003},{1014},{1015},{1016},{1023},{1058},{1060},{1049},{1050},
  637.     {1138},{1139},{1146},{1147},{1158},{1162},{1163},{1164}
  638. };
  639. new nitro[3][0] = {
  640.     {1008},{1009},{1010}
  641. };
  642. new lights[2][0] = {
  643.     {1013},{1024}
  644. };
  645. new Hood[4][0] = {
  646.     {1004},{1005},{1011},{1012}
  647. };
  648. new exhaust[30][0] = {
  649.     {1018},{1019},{1020},{1021},{1022},{1028},{1029},{1034},
  650.     {1037},{1043},{1044},{1045},{1046},{1059},{1063},{1064},
  651.     {1065},{1066},{1089},{1092},{1104},{1105},{1113},{1114},
  652.     {1126},{1127},{1129},{1132},{1135},{1136}
  653. };
  654. new hydrau[1][0] = {{1087}};
  655. new stereo[1][0] = {{1086}};
  656. new Bullbar[1][0] = {{1100}};
  657. new roof[17][0] = {
  658.     {1006},{1032},{1033},
  659.     {1035},{1038},{1053},
  660.     {1054},{1055},{1061},
  661.     {1067},{1068},{1088},
  662.     {1091},{1103},{1128},
  663.     {1130},{1131}
  664. };
  665. new FrontBumper[23][0] = {
  666.     {1117},{1152},{1153},
  667.     {1155},{1157},{1160},
  668.     {1165},{1166},{1169},
  669.     {1170},{1171},{1172},
  670.     {1173},{1174},{1175},
  671.     {1179},{1181},{1182},
  672.     {1185},{1188},{1189},
  673.     {1190},{1191}
  674. };
  675. new RearBumper[22][0] = {
  676.     {1140},{1141},{1148},
  677.     {1149},{1150},{1151},
  678.     {1154},{1156},{1159},
  679.     {1161},{1167},{1168},
  680.     {1176},{1177},{1178},
  681.     {1180},{1183},{1184},
  682.     {1186},{1187},{1192},
  683.     {1193}
  684. };
  685. new RearBullbars[2][0] = {{1109},{1110}};
  686. new FrontBullbars[2][0] = {{1115},{1116}};
  687. new VentsR[2][0] = {{1143},{1445}};
  688. new VentsL[2][0] = {{1142},{1144}};
  689. new Bullbars[2][0] ={{1123},{1125}};
  690. new SideskirtR[22][0] = {
  691.     {1007},{1026},{1031},
  692.     {1036},{1041},{1042},
  693.     {1047},{1048},{1056},
  694.     {1057},{1069},{1070},
  695.     {1090},{1093},{1095},
  696.     {1106},{1108},{1118},
  697.     {1119},{1122},{1133},
  698.     {1134}
  699. };
  700. new SideskirtL[20][0] = {
  701.     {1017},{1027},{1030},
  702.     {1039},{1040},{1051},
  703.     {1052},{1062},{1063},
  704.     {1071},{1072},{1094},
  705.     {1099},{1101},{1102},
  706.     {1107},{1120},{1121},
  707.     {1124},{1137}
  708. };
  709. GetModType(componentid)
  710. {
  711.     for(new i=0; i<20; i++){if(spoiler[i][0]==componentid){ return 1; }}
  712.     for(new i=0; i<3; i++){if(nitro[i][0]==componentid){ return 2; }}
  713.     for(new i=0; i<17; i++){if(wheels[i][0]==componentid){ return 3; }}
  714.     for(new i=0; i<2; i++){if(lights[i][0]==componentid){ return 4; }}
  715.     for(new i=0; i<4; i++){if(Hood[i][0]==componentid) { return 5; }}
  716.     for(new i=0; i<30; i++){if(exhaust[i][0]==componentid) { return 6; }}
  717.     for(new i=0; i<1; i++){if(hydrau[i][0]==componentid) { return 7; }}
  718.     for(new i=0; i<17; i++){if(roof[i][0]==componentid) { return 8; }}
  719.     for(new i=0; i<1; i++){if(stereo[i][0]==componentid) { return 9; }}
  720.     for(new i=0; i<23; i++){if(FrontBumper[i][0]==componentid) { return 10; }}
  721.     for(new i=0; i<22; i++){if(RearBumper[i][0]==componentid) { return 11; }}
  722.     for(new i=0; i<2; i++){if(VentsR[i][0]==componentid) { return 12; }}
  723.     for(new i=0; i<2; i++){if(VentsL[i][0]==componentid) { return 13; }}
  724.     for(new i=0; i<20; i++){if(SideskirtL[i][0]==componentid) { return 14; }}
  725.     for(new i=0; i<22; i++){if(SideskirtR[i][0]==componentid) { return 15; }}
  726.     for(new i=0; i<1; i++){if(Bullbar[i][0]==componentid) { return 16; }}
  727.     for(new i=0; i<2; i++){if(RearBullbars[i][0]==componentid) { return 17; }}
  728.     for(new i=0; i<2; i++){if(FrontBullbars[i][0]==componentid) { return 18; }}
  729.     for(new i=0; i<2; i++){if(Bullbars[i][0]==componentid) { return 19; }}
  730.     return 0;
  731. }
  732. // Sonstige //
  733. stock fahrzeugtun(playerid)
  734. {
  735.     pAutoInfo[playerid][Farbe1]=-1;
  736.     pAutoInfo[playerid][Farbe2]=-1;
  737.     pAutoInfo[playerid][spaintjobid]=-1;
  738.     pAutoInfo[playerid][modspoiler]=0;
  739.     pAutoInfo[playerid][modnitro]=0;
  740.     pAutoInfo[playerid][modwheels]=0;
  741.     pAutoInfo[playerid][modlights]=0;
  742.     pAutoInfo[playerid][modhood]=0;
  743.     pAutoInfo[playerid][modexhaust]=0;
  744.     pAutoInfo[playerid][modhydrau]=0;
  745.     pAutoInfo[playerid][modroof]=0;
  746.     pAutoInfo[playerid][modstereo]=0;
  747.     pAutoInfo[playerid][modfrontbumper]=0;
  748.     pAutoInfo[playerid][modrearfumper]=0;
  749.     pAutoInfo[playerid][modventsr]=0;
  750.     pAutoInfo[playerid][modventsl]=0;
  751.     pAutoInfo[playerid][modsideskirtr]=0;
  752.     pAutoInfo[playerid][modsideskirtl]=0;
  753.     pAutoInfo[playerid][modrearbullbars]=0;
  754.     pAutoInfo[playerid][modfrontbullbars]=0;
  755.     pAutoInfo[playerid][modbullbars]=0;
  756.     return 1;
  757. }
  758. // TIMER //
  759. forward DelayDestroyCar(playerid);
  760. public DelayDestroyCar(playerid)
  761. {
  762.     DestroyVehicle(pAutoInfo[playerid][Carid]);
  763.     pAutoInfo[playerid][Status]=0;
  764.     pAutoInfo[playerid][Carid]=-1;
  765.     return 1;
  766. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!