API tools faq
paste
Advertisement
Guest User

Tank / Auto etc System von Pierre in Mysql

a guest
Oct 31st, 2014
195
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 17.97 KB | None | 0 0
raw download clone embed print report
  1. #include <a_samp>
  2. #include <a_mysql>
  3.  
  4. #define error 0xC30000FF
  5. #define info 0x00C000FF
  6. #define FILTERSCRIPT
  7. #define dcmd(%1,%2,%3) if ((strcmp((%3)[1], #%1, true, (%2)) == 0) && ((((%3)[(%2) + 1] == 0) && (dcmd_%1(playerid, "")))||(((%3)[(%2) + 1] == 32) && (dcmd_%1(playerid, (%3)[(%2) + 2]))))) return 1
  8.  
  9. #define PREIS 4 // Preis Pro liter
  10. #define MAXFULL 30 // Maximale Literanzahl für jedes Fahrzeug.
  11. #define SECONDS 60 // Nach wieviele Sekunden verbraucht ein Fahrzeug zusätzlich 0.1 Liter.
  12. #define TANKDAUER 300 // Wielange dauert das Tanken PRO Liter. (0 = Sofort voll) (Millisekunden)
  13. #define STANDARD 10 // StandarD Menge (Standard 10)
  14. #define START_MOTOR_KEY 132 // Taste bei dem der Motor startet (http://wiki.sa-mp.com/wiki/Keys) | Zeile entfernen oder auskommentieren um Funktion zu deaktivieren.
  15. #define MOTOR_OFF_KMH 50 // Ab diese km/h Anzahl kann der Spieler den Motor !NICHT! mehr ausschalten, sondern muss langsamer werden.
  16. #define LITER_PRO_KM 2 // Literverbrauch (für alle Autos) pro gefahrener Kilometer
  17.  
  18.  
  19. /////////////////// DATENBANK ////////////////
  20. #define MYSQL_HOST "000.00.00.0"
  21. #define MYSQL_USER "TEST"
  22. #define MYSQL_PASS "test123"
  23. #define MYSQL_DATABASE "datenbank"
  24. //////////////////////////////////////////////
  25.  
  26.  
  27. forward Speedometer(playerid);
  28. forward FillGas(i, playerid,price);
  29. forward Gas();
  30. forward checkGas();
  31. forward IsAtGasStation(playerid);
  32. forward loadCar(carid);
  33. forward saveCar(carid);
  34. forward CreateMYSQLTable();
  35. forward toggleMotor(playerid);
  36.  
  37. enum vehicleData {
  38. vehicleSpawnID,
  39. vehicleColor1,
  40. vehicleColor2,
  41. Float:vehicleKm,
  42. vehicleTank,
  43. Float:vLastX,
  44. Float:vLastY,
  45. Float:vLastZ
  46. };
  47. new mysqlconnect,
  48. vehicles[MAX_VEHICLES][vehicleData],
  49. Text:Tacho[MAX_PLAYERS],
  50. timer[MAX_PLAYERS],
  51. Float:Tank[MAX_VEHICLES],
  52. engine,lights,alarm,doors,bonnet,boot,objective,
  53. bool:Motor[MAX_VEHICLES]=false;
  54.  
  55. new PlayerVehicle[212][] = {
  56. "Landstalker", "Bravura", "Buffalo", "Linerunner", "Perrenial", "Sentinel", "Dumper", "Firetruck", "Trashmaster", "Stretch", "Manana",
  57. "Infernus", "Voodoo", "Pony", "Mule", "Cheetah", "Ambulance", "Leviathan", "Moonbeam", "Esperanto", "Taxi", "Washington", "Bobcat",
  58. "Whoopee", "BF Injection", "Hunter", "Premier", "Enforcer", "Securicar", "Banshee", "Predator", "Bus", "Rhino", "Barracks", "Hotknife",
  59. "Trailer 1", "Previon", "Coach", "Cabbie", "Stallion", "Rumpo", "RC Bandit", "Romero", "Packer", "Monster", "Admiral", "Squalo",
  60. "Seasparrow", "Pizzaboy", "Tram", "Trailer 2", "Turismo", "Speeder", "Reefer", "Tropic", "Flatbed", "Yankee", "Caddy", "Solair",
  61. "Berkley's RC Van", "Skimmer", "PCJ-600", "Faggio", "Freeway", "RC Baron", "RC Raider", "Glendale", "Oceanic", "Sanchez", "Sparrow",
  62. "Patriot", "Quad", "Coastguard", "Dinghy", "Hermes", "Sabre", "Rustler", "ZR-350", "Walton", "Regina", "Comet", "BMX", "Burrito",
  63. "Camper", "Marquis", "Baggage", "Dozer", "Maverick", "News Chopper", "Rancher", "FBI Rancher", "Virgo", "Greenwood", "Jetmax", "Hotring",
  64. "Sandking", "Blista Compact", "Police Maverick", "Boxvillde", "Benson", "Mesa", "RC Goblin", "Hotring Racer A", "Hotring Racer B",
  65. "Bloodring Banger", "Rancher", "Super GT", "Elegant", "Journey", "Bike", "Mountain Bike", "Beagle", "Cropduster","Stunt", "Tanker",
  66. "Roadtrain", "Nebula", "Majestic", "Buccaneer", "Shamal", "Hydra", "FCR-900", "NRG-500", "HPV1000", "Cement Truck", "Tow Truck", "Fortune",
  67. "Cadrona", "FBI Truck", "Willard", "Forklift", "Tractor", "Combine", "Feltzer", "Remington", "Slamvan", "Blade", "Freight", "Streak",
  68. "Vortex", "Vincent", "Bullet", "Clover", "Sadler", "Firetruck LA", "Hustler", "Intruder", "Primo", "Cargobob", "Tampa", "Sunrise", "Merit",
  69. "Utility", "Nevada", "Yosemite", "Windsor", "Monster A", "Monster B", "Uranus", "Jester", "Sultan", "Stratum", "Elegy", "Raindance",
  70. "RC Tiger", "Flash", "Tahoma", "Savanna", "Bandito", "Freight Flat", "Streak Carriage", "Kart", "Mower", "Dune", "Sweeper", "Broadway",
  71. "Tornado", "AT-400", "DFT-30", "Huntley", "Stafford", "BF-400", "News Van", "Tug", "Trailer 3", "Emperor", "Wayfarer", "Euros", "Hotdog",
  72. "Club", "Freight Carriage", "Trailer 4", "Andromada", "Dodo", "RC Cam", "Launch", "Police Car (LSPD)", "Police Car (SFPD)",
  73. "Police Car (LVPD)", "Police Ranger", "Picador", "S.W.A.T", "Alpha", "Phoenix", "Glendale", "Sadler", "Luggage Trailer A",
  74. "Luggage Trailer B", "Stairs", "Boxville", "Tiller", "Utility Trailer"
  75. };
  76.  
  77. public OnFilterScriptInit()
  78. {
  79. new query[150];
  80. mysqlconnect = mysql_connect(MYSQL_HOST,MYSQL_USER,MYSQL_DATABASE,MYSQL_PASS);
  81. if(mysql_errno() == 0)
  82. {
  83. print("Datenbank Verbindung erfolgreich hergestellt!");
  84. }
  85. else
  86. {
  87. mysqlconnect = mysql_connect(MYSQL_HOST,MYSQL_USER,MYSQL_DATABASE,MYSQL_PASS);
  88. if(mysql_errno() == 0)
  89. {
  90. print("Es konnte keine Datenbank Verbindung gefunden werden!");
  91. return true;
  92. }
  93. else
  94. {
  95. print("Es konnte keine Datenbank Verbindung gefunden werden!");
  96. SendRconCommand("exit");
  97. return true;
  98. }
  99. }
  100. CreateMYSQLTable();
  101. ManualVehicleEngineAndLights();
  102. for(new i =0; i<MAX_VEHICLES;i++) {
  103. Tank[i] = STANDARD;
  104. format(query,sizeof(query),"SELECT * FROM pcar WHERE carid = '%d'",i);
  105. mysql_function_query(mysqlconnect,query,true,"loadCar","i",i);
  106. Motor[i]=false;
  107. GetVehicleParamsEx(i,engine,lights,alarm,doors,bonnet,boot,objective);
  108. SetVehicleParamsEx(i,VEHICLE_PARAMS_OFF,lights,alarm,doors,bonnet,boot,objective);
  109. }
  110. timer[1] = SetTimer("Speedometer",1000, 1);
  111. timer[2] = SetTimer("Gas", SECONDS * 1000, 1);
  112. print("\n---------------------------------------------");
  113. print(" Tank, Motor und Tacho System bei pierre65 ");
  114. for (new i=0; i<MAX_PLAYERS; i++) {
  115. Tacho[i] = TextDrawCreate(460.000000, 381.500000, " ");
  116. TextDrawBackgroundColor(Tacho[i], 255);
  117. TextDrawFont(Tacho[i], 1);
  118. TextDrawLetterSize(Tacho[i], 0.32, 0.97);
  119. TextDrawColor(Tacho[i], -1);
  120. TextDrawSetOutline(Tacho[i], 0);
  121. TextDrawSetProportional(Tacho[i], 1);
  122. TextDrawSetShadow(Tacho[i], 1);
  123. TextDrawHideForAll(Tacho[i]);
  124. }
  125. return 1;
  126. }
  127.  
  128. public OnFilterScriptExit()
  129. {
  130. for (new i=0; i<MAX_PLAYERS; i++) { TextDrawDestroy(Tacho[i]); }
  131. for (new i=0; i<MAX_VEHICLES; i++) {
  132. saveCar(i);
  133. }
  134. return 1;
  135. }
  136.  
  137. public OnVehicleSpawn(vehicleid)
  138. {
  139. GetVehicleParamsEx(vehicleid,engine,lights,alarm,doors,bonnet,boot,objective);
  140. SetVehicleParamsEx(vehicleid,VEHICLE_PARAMS_OFF,lights,alarm,doors,bonnet,boot,objective);
  141. Motor[vehicleid] = false;
  142. return 0;
  143. }
  144.  
  145. #if defined START_MOTOR_KEY
  146. public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
  147. {
  148. if ( newkeys == (START_MOTOR_KEY) ) { toggleMotor(playerid); }
  149. return 1;
  150. }
  151. #endif
  152.  
  153. public OnPlayerConnect(playerid)
  154. {
  155. timer[playerid] = SetTimerEx("Speedometer",1000, 1,"i",playerid);
  156. return 1;
  157. }
  158. public OnPlayerCommandText(playerid, cmdtext[])
  159. {
  160. dcmd(tanken,6,cmdtext);
  161. dcmd(motor, 5,cmdtext);
  162. return 0;
  163. }
  164. dcmd_motor(playerid, params[])
  165. {
  166. #pragma unused params
  167. toggleMotor(playerid);
  168. return 1;
  169. }
  170. dcmd_tanken(playerid,params[])
  171. {
  172. #pragma unused params
  173. if(IsPlayerInAnyVehicle(playerid)) {
  174. if(IsAtGasStation(playerid)) {
  175. new vehicle = GetPlayerVehicleID(playerid);
  176. new liter = MAXFULL;
  177. liter -= floatround(Tank[vehicle],floatround_floor);
  178. if ( Motor[vehicle] == true ) { SendClientMessage(playerid, error, "Schalte den Motor vor dem Tanken bitte aus."); }
  179. else {
  180. if(GetPlayerMoney(playerid) > liter*PREIS) {
  181. TogglePlayerControllable(playerid, 1);
  182. SetTimerEx("FillGas", 1000, 0, "iii", vehicle, playerid,0);
  183. GameTextForPlayer(playerid, "~w~~n~~n~~n~~n~~n~~n~~n~~n~Dein Fahrzeug wird betankt...",TANKDAUER,3);
  184. }
  185. else { SendClientMessage(playerid, error, "Du hast nicht genug Geld."); }
  186. }
  187. }
  188. else { SendClientMessage(playerid, error, "Du bist an keiner Tankstelle."); }
  189. }
  190. return 1;
  191. }
  192. public OnPlayerDisconnect(playerid, reason)
  193. {
  194. KillTimer(timer[playerid]);
  195. return 1;
  196. }
  197.  
  198. public Speedometer(playerid)
  199. {
  200. TextDrawHideForPlayer(playerid, Tacho[playerid]);
  201. if ( IsPlayerConnected(playerid) ) {
  202. if( IsPlayerInAnyVehicle(playerid) ) {
  203. new Float:chealth, speed_string[255], kmh, vehicleid = GetPlayerVehicleID(playerid), modelid = GetVehicleModel(vehicleid),
  204. Float:x2, Float:y2, Float:z2, Float:output,
  205. Float:rtank = output / 1000 * LITER_PRO_KM;
  206. TextDrawShowForPlayer(playerid, Tacho[playerid]);
  207. GetVehicleHealth(vehicleid, chealth);
  208. kmh = getKmh(playerid, true);
  209. if ( GetPlayerState(playerid) == PLAYER_STATE_DRIVER )
  210. {
  211. GetVehiclePos(vehicleid, x2, y2, z2);
  212. output = floatsqroot(floatpower(floatabs(floatsub(x2, vehicles[vehicleid][vLastX])), 2)+floatpower(floatabs(floatsub(y2, vehicles[vehicleid][vLastY])), 2)+floatpower(floatabs(floatsub(z2, vehicles[vehicleid][vLastZ])), 2));
  213. Tank[vehicleid] -= rtank;
  214. vehicles[vehicleid][vehicleKm] += output;
  215. vehicles[vehicleid][vLastX] = x2; vehicles[vehicleid][vLastY] = y2; vehicles[vehicleid][vLastZ] = z2;
  216. }
  217. format(speed_string,255,"~b~%s: ~w~%d%%~n~~b~Km/h: ~w~%d km/h~n~~b~Motor: %s~n~~b~Kilometer:~w~ %.2f~n~~b~Benzin: ~w~%.1f/%dl", PlayerVehicle[modelid - 400], floatround(chealth, floatround_round)/10,kmh, Motor[vehicleid]?("~g~An"):("~r~Aus"),(vehicles[vehicleid][vehicleKm]/1000), Tank[vehicleid], MAXFULL);
  218. TextDrawSetString(Tacho[playerid], speed_string);
  219. }
  220. }
  221. return 1;
  222. }
  223.  
  224. public Gas()
  225. {
  226. new vehicleid;
  227. for (new i=0; i < MAX_VEHICLES;i++) {
  228. for ( new p=0; p < MAX_PLAYERS; p++ ) {
  229. if ( IsPlayerConnected(p) ) {
  230. vehicleid = GetPlayerVehicleID(p);
  231. vehicleid = GetPlayerVehicleID(p);
  232. if ( vehicleid == i ) {
  233. if( Tank[i] <= 4 && Tank[i] >= 1 ) { PlayerPlaySound(p, 1085, 0.0, 0.0, 0.0); }
  234. }
  235. }
  236. }
  237. if ( Motor[i] == true ) {
  238. Tank[i] -= 0.1;
  239. if ( Tank[i] <= 0 ) { Motor[i] = false; SetVehicleParamsEx(i, VEHICLE_PARAMS_OFF, lights,alarm,doors,bonnet,boot,objective); }
  240. }
  241. }
  242. return 1;
  243. }
  244.  
  245. public OnPlayerStateChange(playerid, newstate, oldstate)
  246. {
  247. if( newstate == PLAYER_STATE_DRIVER) {
  248. new vehicle = GetPlayerVehicleID(playerid);
  249. GetVehicleParamsEx(vehicle,engine,lights,alarm,doors,bonnet,boot,objective);
  250. if(GetVehicleModel(vehicle) == 509 || GetVehicleModel(vehicle) == 481 || GetVehicleModel(vehicle) == 510) { SetVehicleParamsEx(vehicle,VEHICLE_PARAMS_ON,lights,alarm,doors,bonnet,boot,objective); }
  251. else { SendClientMessage(playerid, info, "Schalte den Motor mit an oder aus."); }
  252. if ( Motor[vehicle]==false ) { SetVehicleParamsEx(vehicle,VEHICLE_PARAMS_OFF,lights,alarm,doors,bonnet,boot,objective); }
  253. if( Tank[vehicle] <= 0 ) {
  254. Motor[vehicle]=false;
  255. Tank[vehicle] = 0;
  256. SetVehicleParamsEx(vehicle,VEHICLE_PARAMS_OFF,lights,alarm,doors,bonnet,boot,objective);
  257. GameTextForPlayer(playerid,"~r~~n~~n~~n~~n~~n~~n~~n~~n~Der Tank ist leer!",3000,3);
  258. }
  259. }
  260. return 1;
  261. }
  262.  
  263. public IsAtGasStation(playerid)
  264. {
  265. if(IsPlayerConnected(playerid))
  266. {
  267. if(IsPlayerInRangeOfPoint(playerid,15.0,1004.0070,-939.3102,42.1797) || IsPlayerInRangeOfPoint(playerid,15.0,1944.3260,-1772.9254,13.3906)) { return 1; }
  268. else if(IsPlayerInRangeOfPoint(playerid,15.0,-90.5515,-1169.4578,2.4079) || IsPlayerInRangeOfPoint(playerid,15.0,-1609.7958,-2718.2048,48.5391)) { return 1; }
  269. else if(IsPlayerInRangeOfPoint(playerid,15.0,-2029.4968,156.4366,28.9498) || IsPlayerInRangeOfPoint(playerid,15.0,-2408.7590,976.0934,45.4175)) { return 1; }
  270. else if(IsPlayerInRangeOfPoint(playerid,15.0,-2243.9629,-2560.6477,31.8841) || IsPlayerInRangeOfPoint(playerid,6.0,-1676.6323,414.0262,6.9484)) { return 1; }
  271. else if(IsPlayerInRangeOfPoint(playerid,15.0,2202.2349,2474.3494,10.5258) || IsPlayerInRangeOfPoint(playerid,15.0,614.9333,1689.7418,6.6968)) { return 1; }
  272. else if(IsPlayerInRangeOfPoint(playerid,15.0,-1328.8250,2677.2173,49.7665) || IsPlayerInRangeOfPoint(playerid,15.0,70.3882,1218.6783,18.5165)) { return 1; }
  273. else if(IsPlayerInRangeOfPoint(playerid,15.0,2113.7390,920.1079,10.5255) || IsPlayerInRangeOfPoint(playerid,15.0,-1327.7218,2678.8723,50.0625)) { return 1; }
  274. else if(IsPlayerInRangeOfPoint(playerid,15.0,2146.6143,2748.4758,10.3852)||IsPlayerInRangeOfPoint(playerid,15.0,2639.0022,1108.0353,10.3852)) { return 1; }
  275. else if(IsPlayerInRangeOfPoint(playerid,15.0,1598.2035,2198.6448,10.3856)) { return 1; }
  276. }
  277. return 0;
  278. }
  279.  
  280. stock getKmh(playerid,bool:kmh)
  281. {
  282. new Float:x,Float:y,Float:z,Float:rtn;
  283. if(IsPlayerInAnyVehicle(playerid)) GetVehicleVelocity(GetPlayerVehicleID(playerid),x,y,z); else GetPlayerVelocity(playerid,x,y,z);
  284. rtn = floatsqroot((x*x)+(y*y)+(z*z));
  285. return kmh?floatround(rtn * 85 * 1.61):floatround(rtn * 50);
  286. }
  287.  
  288. public FillGas(i, playerid,price)
  289. {
  290. new str[50];
  291. if ( floatround(Tank[i],floatround_ceil) < MAXFULL ) {
  292. if (IsAtGasStation(playerid) && Motor[i] == false ) {
  293. format(str, sizeof str, "Du hast nicht genug Geld für ein weiteren Liter. (Kosten: %d$)", PREIS);
  294. if ( GetPlayerMoney(playerid) >= PREIS ) {
  295. Tank[i] ++;
  296. SetTimerEx("FillGas", TANKDAUER * 1, 0, "iii", i, playerid,price + PREIS);
  297. GivePlayerMoney(playerid, -PREIS);
  298. GameTextForPlayer(playerid, "~w~~n~~n~~n~~n~~n~~n~~n~~n~Dein Fahrzeug wird betankt...",TANKDAUER,3);
  299. }
  300. else { SendClientMessage(playerid,error, str); }
  301. }
  302. else { format(str, sizeof str, "Das Tanken wurde beendet."); SendClientMessage(playerid,error, str); }
  303. }
  304. else { format(str, sizeof str, "Dein Fahrzeug wurde für %d$ betankt!",price); SendClientMessage(playerid, info, str); }
  305. return 1;
  306. }
  307. public loadCar(carid)
  308. {
  309. new result[25],rows,fields,Float:Pos[4], model = 0;
  310. cache_get_data(rows,fields);
  311. if(rows)
  312. {
  313. cache_get_field_content(0,"model",result);
  314. model = strval(result);
  315.  
  316. cache_get_field_content(0,"km",result);
  317. vehicles[carid][vehicleKm] = floatstr(result);
  318.  
  319. cache_get_field_content(0,"color1",result);
  320. vehicles[carid][vehicleColor1] = strval(result);
  321.  
  322. cache_get_field_content(0,"color2",result);
  323. vehicles[carid][vehicleColor2] = strval(result);
  324.  
  325. cache_get_field_content(0,"tank",result);
  326. Tank[carid] = floatstr(result);
  327.  
  328. cache_get_field_content(0,"float_x",result);
  329. Pos[0] = floatstr(result);
  330.  
  331. cache_get_field_content(0,"float_y",result);
  332. Pos[1] = floatstr(result);
  333.  
  334. cache_get_field_content(0,"float_z",result);
  335. Pos[2] = floatstr(result);
  336.  
  337. cache_get_field_content(0,"float_r",result);
  338. Pos[3] = floatstr(result);
  339.  
  340. vehicles[carid][vehicleSpawnID] = CreateVehicle(model,Pos[0],Pos[1],Pos[2],Pos[3],vehicles[carid][vehicleColor1],vehicles[carid][vehicleColor2],0);
  341. GetVehiclePos(vehicles[carid][vehicleSpawnID],Pos[0],Pos[1],Pos[2]);
  342. vehicles[carid][vLastX] = Pos[0]; vehicles[carid][vLastY] = Pos[1]; vehicles[carid][vLastZ] = Pos[2];
  343. }
  344. return true;
  345. }
  346. public saveCar(carid)
  347. {
  348. new query[175],Float:Pos[4];
  349. if(GetVehicleModel(carid) < 1) return true;
  350. GetVehiclePos(carid,Pos[0],Pos[1],Pos[2]);
  351. GetVehicleZAngle(carid,Pos[3]);
  352. format(query,sizeof(query),"UPDATE pcar SET model = '%d' , color1 = '%d' , color2 = '%d' , tank = '%f' , km = '%f' , float_x = '%f' , float_y = '%f' , float_z = '%f' , float_r = '%f' WHERE carid = '%d'",
  353. GetVehicleModel(carid),vehicles[carid][vehicleColor1],vehicles[carid][vehicleColor2],Tank[carid],vehicles[carid][vehicleKm],Pos[0],Pos[1],Pos[2],Pos[3],carid);
  354. mysql_function_query(mysqlconnect,query,false,"","");
  355. DestroyVehicle(carid);
  356. return true;
  357. }
  358. public toggleMotor(playerid)
  359. {
  360. if(GetPlayerVehicleSeat(playerid) == 0)
  361. {
  362. new car = GetPlayerVehicleID(playerid);
  363. if(GetVehicleModel(car) == 509 || GetVehicleModel(car) == 481 || GetVehicleModel(car) == 510) { SendClientMessage(playerid, error, "Ein Fahrrad hat kein Motor."); }
  364. else if (Motor[car] == false) {
  365. GetVehicleParamsEx(car,engine,lights,alarm,doors,bonnet,boot,objective);
  366. if ( Tank[car] >= 1 ) { Motor[car] = true; SetVehicleParamsEx(car,VEHICLE_PARAMS_ON,lights,alarm,doors,bonnet,boot,objective); }
  367. else { Motor[car] = false; SetVehicleParamsEx(car,VEHICLE_PARAMS_OFF,lights,alarm,doors,bonnet,boot,objective); GameTextForPlayer(playerid,"~w~~n~~n~~n~~n~~n~~n~~n~~n~Der Tank ist leer!",3000,3); }
  368. }
  369. else {
  370. #if defined MOTOR_OFF_KMH
  371. if ( getKmh(playerid,true) > MOTOR_OFF_KMH ) { return SendClientMessage(playerid, error, "Du fährst zu schnell um den Motor abzuschalten."); }
  372. #endif
  373. GetVehicleParamsEx(car,engine,lights,alarm,doors,bonnet,boot,objective);
  374. SetVehicleParamsEx(car,VEHICLE_PARAMS_OFF,lights,alarm,doors,bonnet,boot,objective);
  375. Motor[car] = false;
  376. }
  377. }
  378. return 1;
  379. }
  380. public CreateMYSQLTable()
  381. {
  382. new query[250];
  383. strcat(query,"CREATE TABLE IF NOT EXISTS pcar (`id` int(11) NOT NULL AUTO_INCREMENT,`carid` int(10) NOT NULL,`model` int(8) NOT NULL,`color1` int(3) NOT NULL,`color2` int(3) NOT NULL,`tank` float(10,4) NOT NULL,`km` float(10,4) NOT NULL,");
  384. strcat(query,"`float_x` float(10,4) NOT NULL,`float_y` float(10,4) NOT NULL,`float_z` float(10,4) NOT NULL,`float_r` float(10,4) NOT NULL,PRIMARY KEY (`id`))");
  385. mysql_function_query(mysqlconnect,query,false,"","");
  386. strdel(query,0,sizeof(query));
  387. return true;
  388. }
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!