· 4 years ago · Jan 10, 2021, 01:12 AM
1
2
3SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
4
5
6
7CREATE TABLE IF NOT EXISTS `achievments` (
8
9`UID` int(4) NOT NULL,
10
11`SchlaflosInSA` varchar(50) NOT NULL DEFAULT '0',
12
13`Waffenschieber` varchar(50) NOT NULL DEFAULT '0',
14
15`Angler` varchar(50) NOT NULL DEFAULT '0',
16
17`Lizensen` varchar(50) NOT NULL DEFAULT '0',
18
19`Fahrzeugwahn` varchar(50) NOT NULL DEFAULT '0',
20
21`EigeneFuesse` varchar(50) NOT NULL DEFAULT '0',
22
23`KingOfTheHill` varchar(50) NOT NULL DEFAULT '0',
24
25`ReallifeWTF` varchar(50) NOT NULL DEFAULT '0',
26
27`DerSammler` varchar(50) NOT NULL DEFAULT '0',
28
29`TheTruthIsOutThere` varchar(50) NOT NULL DEFAULT '0',
30
31`SilentAssasin` varchar(50) NOT NULL DEFAULT '0',
32
33`HighwayToHell` varchar(50) NOT NULL DEFAULT '0',
34
35`LookoutsA` varchar(20) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0|',
36
37`Hufeisen` varchar(50) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|',
38
39`Revolverheld` int(1) NOT NULL DEFAULT '0',
40
41`ChickenDinner` int(1) NOT NULL DEFAULT '0',
42
43`NichtGehtMehr` int(1) NOT NULL DEFAULT '0',
44
45`highscore` tinyint(1) NOT NULL DEFAULT '0',
46
47PRIMARY KEY (`UID`)
48) ENGINE=MyISAM DEFAULT CHARSET=latin1;
49
50
51
52
53CREATE TABLE IF NOT EXISTS `ban` (
54
55`UID` int(4) NOT NULL,
56
57`AdminUID` int(4) NOT NULL,
58
59`Grund` varchar(50) NOT NULL,
60
61`Datum` varchar(50) NOT NULL,
62
63`IP` varchar(50) NOT NULL DEFAULT '0',
64
65`Serial` varchar(50) NOT NULL,
66
67`Eintragsdatum` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
68
69`STime` int(11) NOT NULL DEFAULT '0'
70,
71PRIMARY KEY (`UID`),
72KEY `IP` (`IP`),
73KEY `Serial` (`Serial`),
74KEY `STime` (`STime`)
75) ENGINE=MyISAM DEFAULT CHARSET=latin1;
76
77
78
79
80
81
82CREATE TABLE IF NOT EXISTS `biz` (
83
84`ID` int(2) NOT NULL,
85
86`Biz` varchar(50) NOT NULL,
87
88`UID` int(4) NOT NULL,
89
90`Kasse` int(11) NOT NULL,
91
92`Name` varchar(50) NOT NULL,
93
94`Preis` int(11) NOT NULL,
95PRIMARY KEY (`ID`)
96) ENGINE=MyISAM DEFAULT CHARSET=latin1;
97
98
99INSERT INTO `biz` (`ID`, `Biz`, `UID`, `Kasse`, `Name`, `Preis`) VALUES
100
101(1, 'PaynSprayWangcars', 0, 0, 'Pay n Spray WC', 350000),
102(2, 'PaynSprayJuniper', 0, 0, 'Pay n Spray', 350000),
103(3, 'Sprunk', 0, 0, 'Sprunk Fabrik', 475000),
104
105(4, 'WellStackedPizza', 0, 0, 'Well Stacked Pizza Co.', 999999999),
106
107(5, 'MistysBar', 0, 0, 'Mistys Bar', 350000),
108
109(6, 'Visage', 0, 0, 'Visage Hotel', 10000000),
110
111(7, 'VankHoff', 0, 0, 'Vank Hoff Hotel', 3000000),
112
113(8, 'TankstelleNord', 0, 0, 'Tankstelle North', 200000),
114(9, 'TankstelleSued', 0, 0, 'Tankstelle South', 750000),
115(10, 'TankstellePine', 0, 0, 'Tankstelle Pine', 650000),
116
117(11, 'PaynSprayLV', 0, 0, 'Pay n Spray LV', 500000),
118
119(12, 'PaynSprayLS', 0, 0, 'Pay n Spray LS', 500000);
120
121
122
123
124
125
126CREATE TABLE IF NOT EXISTS `blacklist` (
127
128`id` int(11) NOT NULL,
129
130`UID` int(4) NOT NULL,
131
132`EintraegerUID` int(4) NOT NULL,
133
134`Fraktion` int(2) NOT NULL,
135
136`Grund` text NOT NULL,
137
138`Eintragungsdatum` int(50) NOT NULL,
139
140PRIMARY KEY (`id`)
141) ENGINE=MyISAM DEFAULT CHARSET=latin1;
142
143
144
145
146
147
148CREATE TABLE IF NOT EXISTS `blocks` (
149
150`UID` int(4) NOT NULL,
151
152`Punkte` int(11) NOT NULL,
153PRIMARY KEY (`UID`)
154) ENGINE=MyISAM DEFAULT CHARSET=latin1;
155
156
157
158
159
160
161CREATE TABLE IF NOT EXISTS `bonustable` (
162
163`UID` int(4) NOT NULL,
164
165`Lungenvolumen` varchar(50) NOT NULL,
166
167`Muskeln` varchar(50) NOT NULL,
168
169`Kondition` varchar(50) NOT NULL,
170
171`Boxen` varchar(50) NOT NULL,
172
173`KungFu` varchar(50) NOT NULL,
174
175`Streetfighting` varchar(50) NOT NULL,
176
177`CurStyle` varchar(50) NOT NULL,
178
179`PistolenSkill` varchar(50) NOT NULL,
180
181`DeagleSkill` varchar(50) NOT NULL,
182
183`ShotgunSkill` varchar(50) NOT NULL,
184
185`AssaultSkill` varchar(50) NOT NULL,
186
187`Vortex` varchar(50) NOT NULL DEFAULT 'none',
188
189`MP5Skills` varchar(50) NOT NULL DEFAULT 'none',
190
191`Quad` varchar(50) NOT NULL DEFAULT 'none',
192
193`CarslotUpgrades` varchar(50) NOT NULL DEFAULT 'none',
194
195`PremiumUntilDay` int(50) NOT NULL DEFAULT '0',
196
197`PremiumUntilYear` varchar(50) NOT NULL DEFAULT '0',
198
199`BonusSkin1` varchar(50) NOT NULL DEFAULT 'none',
200
201`CarslotUpdate2` int(11) NOT NULL DEFAULT '0',
202
203`CarslotUpdate3` int(11) NOT NULL DEFAULT '0',
204
205`CarslotUpdate4` int(11) NOT NULL DEFAULT '0',
206
207`CarslotUpdate5` int(11) NOT NULL DEFAULT '0',
208
209`Skimmer` int(1) NOT NULL DEFAULT '0',
210
211`Leichenwagen` int(1) NOT NULL DEFAULT '0',
212
213`Schach` varchar(1) NOT NULL DEFAULT '0',
214
215`Caddy` varchar(1) NOT NULL DEFAULT '0',
216
217`fglass` varchar(3) NOT NULL DEFAULT '0',
218
219`uzi` varchar(3) NOT NULL DEFAULT '0',
220PRIMARY KEY (`UID`)
221) ENGINE=MyISAM DEFAULT CHARSET=latin1;
222
223
224
225
226
227
228CREATE TABLE IF NOT EXISTS `buyit` (
229
230`ID` int(50) NOT NULL,
231
232`Typ` varchar(50) NOT NULL,
233
234`AnbieterUID` int(4) NOT NULL,
235
236`HoechstbietenderUID` int(4) NOT NULL,
237
238`Hoechstgebot` int(50) NOT NULL,
239
240`LaeuftBis` int(50) NOT NULL,
241
242`Beschreibung` varchar(200) NOT NULL DEFAULT '',
243
244`OptischesDatum` varchar(50) NOT NULL,
245
246`Anzahl` varchar(50) NOT NULL DEFAULT '',
247PRIMARY KEY (`ID`)
248) ENGINE=MyISAM DEFAULT CHARSET=latin1;
249
250
251
252
253
254CREATE TABLE IF NOT EXISTS `carhouses_icons` (
255
256`Name` varchar(50) NOT NULL,
257
258`ID` int(3) NOT NULL AUTO_INCREMENT,
259
260`X` double NOT NULL,
261
262`Y` double NOT NULL,
263
264`Z` double NOT NULL,
265
266`SpawnX` float NOT NULL,
267
268`SpawnY` float NOT NULL,
269
270`SpawnZ` float NOT NULL,
271
272`SpawnRX` float NOT NULL,
273
274`SpawnRY` float NOT NULL,
275
276`SpawnRZ` float NOT NULL
277,
278PRIMARY KEY (`ID`)
279) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
280
281
282
283INSERT INTO `carhouses_icons` (`Name`, `ID`, `X`, `Y`, `Z`, `SpawnX`, `SpawnY`, `SpawnZ`, `SpawnRX`, `SpawnRY`, `SpawnRZ`) VALUES
284('San Fierro\nAirport', 1, -1544.4420166016, -440.82772827148, 6, -1224.29, -7.50679, 15.0342, 0, 0, 0),
285
286('Wang Cars', 2, -1966.1179199219, 293.97113037109, 35.46875, -1932.04, 268.793, 41.1455, 0, 0, 180),
287('Otto''s Autos', 3, -1649.9169921875, 1209.8126220703, 7.25, -1637.07, 1208.94, 7.07969, 0, 0, 224),
288
289('Bayside Boats', 4, -2185.0559082031, 2413.1411132813, 5.15625, -2215.62, 2438.35, 0, 0, 0, 314),
290
291('Las Venturas\nAirport', 5, 1714.8116455078, 1616.1896972656, 10.09, 1346.85, 1341.25, 12.3362, 0, 0, 268),
292
293('$HODY USED\nAUTOS', 6, 1689.0015869141, 1850.7039794922, 11.219537734985, 1692.42, 1865.62, 10.7203, 0, 0, 270),
294
295('Auto Bahn', 7, 2200.86, 1394.32, 10.9, 2200.93, 1386.6, 10.55, 0, 0, 90),
296
297('Bonusfahrzeuge\n( See )', 8, -911.11560058594, 2686.1909179688, 42.817291259766, -962.246, 2671.21, 40.3628, 0, 0, 135),
298
299('Bonusfahrzeuge\n( Land )', 9, -902.84930419922, 2681.6420898438, 42.734336853027, -898.47, 2715.61, 45.9974, 0, 0, 97),
300
301('Auto Bahn', 10, 1948.6752929688, 2068.84, 11.466958999634, 1940.2, 2068.54, 10.8203, 0, 0, 0),
302
303('Kleinstadt-\\nhaendler', 11, -2088.97, -2262.41, 30.32, -2088.42, -2267.6, 30.5, 0, 0, 45);
304
305
306
307
308
309CREATE TABLE IF NOT EXISTS `carhouses_vehicles` (
310
311`AutohausID` int(50) NOT NULL,
312
313`X` double NOT NULL,
314
315`Y` double NOT NULL,
316
317`Z` double NOT NULL,
318
319`RX` double NOT NULL,
320
321`RY` double NOT NULL,
322
323`RZ` double NOT NULL,
324
325`Preis` int(11) NOT NULL,
326
327`Typ` int(50) NOT NULL,
328
329`Info` varchar(50) NOT NULL,
330
331`Comment` varchar(999) NOT NULL DEFAULT '',
332
333`ID` int(11) NOT NULL AUTO_INCREMENT,
334PRIMARY KEY (`ID`)
335) ENGINE=MyISAM AUTO_INCREMENT=71 DEFAULT CHARSET=latin1;
336
337
338
339
340INSERT INTO `carhouses_vehicles` (`AutohausID`, `X`, `Y`, `Z`, `RX`, `RY`, `RZ`, `Preis`, `Typ`, `Info`, `Comment`, `ID`) VALUES
341
342(1, -1188.5283203125, 32.646484375, 15.034187316895, 0, 0, 0, 129000, 568, 'Helikoper mit\n2 Sitzplaetzen', 'Raindance', 1),
343
344(1, -1187.7210693359, 15.780174255371, 14.24843788147, 0, 0, 16, 31900, 469, 'Helikoper mit\n2 Sitzplaetzen', 'Sparrow', 2),
345
346(1, -1175.3992919922, 29.118057250977, 14.413437843323, 0, 0, 50, 74900, 487, 'Helikoper mit\n4 Sitzplaetzen', 'Maverick', 3),
347
348(2, -1949.3812255859, 263.57504272461, 40.867080688477, 0, 0, 68, 12900, 426, 'Viertuerer', 'Premier', 4),
349
350(2, -1948.7930908203, 272.47186279297, 41.003414154053, 0, 0, 106, 7500, 507, 'Viertuerer', 'Elegant', 5),
351
352(2, -1956.0469970703, 291.77319335938, 40.877082824707, 0, 0, 130, 11500, 404, 'Viertuerer', 'Perennial', 6),
353
354(2, -1959.2907714844, 258.83361816406, 35.168510437012, 0, 0, 18, 1800, 581, 'Motorrad', 'BF-400', 7),
355
356(2, -1949.6003417969, 261.25247192383, 35.330226898193, 0, 0, 26, 1200, 549, 'Billigkarre', 'Tampa', 8),
357
358(2, -1948.7517089844, 270.49761962891, 35.423927307129, 0, 0, 112, 14500, 412, 'Viertuerer', 'Vodoo', 9),
359
360(2, -1956.056640625, 296.3076171875, 35.567386627197, 0, 0, 132, 17800, 579, 'SUV', 'Huntley', 10),
361
362(3, -1660.5234375, 1213.8901367188, 6.9103775024414, 0, 0, 326, 32500, 522, 'Rennmotorad', 'NRG-500', 11),
363
364(3, -1654.2049560547, 1213.8233642578, 13.371874809265, 0, 0, 14, 47900, 541, 'Sportwagen', 'Bullet', 12),
365
366(3, -1660.8762207031, 1216.0104980469, 13.463988304138, 0, 0, 332, 42500, 506, 'Sportwagen', 'Super GT', 13),
367
368(3, -1673.5727539063, 1206.7923583984, 21.005771636963, 0, 0, 248, 48900, 415, 'Sportwagen', 'Cheetah', 14),
369
370(3, -1657, 1211, 7.04, 0, 0, 318, 84900, 411, 'Sportwagen', 'Infernus', 15),
371
372(3, -1650.2810058594, 1208.2152099609, 20.898662567139, 0, 0, 10.25, 54900, 429, 'Sportcabrio', 'Banshee', 16),
373
374(3, -1663.4768066406, 1219.8461914063, 20.966249465942, 0, 0, 250, 39500, 587, 'Sportwagen', 'Euros', 17),
375
376(4, -2213.1484375, 2411.6689453125, 0, 0, 0, 42, 179900, 484, 'Segelyacht\n( Mit Koje )', 'Marquis', 18),
377
378(4, -2223.1516113281, 2400.8994140625, 0, 0, 0, 46, 129900, 454, 'Motoryacht\n( Mit Koje )', 'Tropic', 19),
379
380(4, -2231.357421875, 2390.7587890625, 0, 0, 0, 44, 27900, 446, 'Speedboot', 'Squalo', 20),
381
382(4, -2258.015691406, 2419.2734375, 0, 0, 0, 224, 19900, 452, 'Speedboot', 'Speeder', 21),
383
384(4, -2249.8605957031, 2423.9106445313, 0, 0, 0, 224, 7900, 473, 'Schlauchboot', 'Dinghy', 22),
385
386(4, -2239.6242675781, 2440.6728515625, 0, 0, 0, 226, 42500, 493, 'Speedboot', 'Jetmax', 23),
387
388(5, 1296.4821777344, 1324.9904785156, 11.370494842529, 0, 0, 270, 32500, 593, 'Propeller-\nmaschiene\n(2 Sitzplaetze)', 'Dodo', 24),
389
390(5, 1295.6755371094, 1361.3303222656, 12.271298408508, 12, 0, 270, 54900, 553, 'Alte Propeller-\nmaschiene', 'Nevada', 25),
391
392(5, 1291.8493652344, 1389.7900390625, 11.820384979248, 0, 0, 270, 149900, 519, 'Privatjet', 'Shamal', 26),
393
394(5, 1296.9296875, 1340.884765625, 11.605069160461, 0, 0, 270, 34900, 513, 'Stuntflugzeug', 'Stuntplane', 27),
395
396(5, 1350.5347900391, 1281.189453125, 12.336210250854, 0, 0, 0, 24900, 511, 'Propellerflug-\nzeug ( 2 Sitze )', 'Beagle', 28),
397
398(6, 1728.9261474609, 2019.6724853516, 10.690312385559, 0, 0, 90, 17950, 467, 'Viertuerer', 'Oceanic', 29),
399
400(6, 1728.9013671875, 2009.2183837891, 10.82, 0, 0, 90, 74950, 603, 'Muscle-Car', 'Phoenix', 30),
401
402(6, 1728.9013671875, 2003, 10.72, 0, 0, 90, 21000, 475, 'Muscle-Car', 'Sabre', 31),
403
404(6, 1728.2746582031, 1991.4293212891, 10.96, 0, 0, 90, 84000, 434, 'Hotrod', 'Hotknife', 32),
405
406(6, 1729, 1985.2177734375, 10.75, 0, 0, 90, 49000, 419, 'Lowrider', 'Esperanto', 33),
407
408(6, 1729.08, 1979.41, 10.667, 0, 0, 90, 26000, 424, 'Strandbuggy', 'BF Injection', 34),
409
410(6, 1742.11, 2019.2, 10.49, 0, 0, 0, 490, 462, 'Roller', 'Faggio', 35),
411(6, 1744.46, 2013.42, 10.77, 0, 0, 90, 15000, 412, 'Lowrider', 'Voodoo', 36),
412
413(6, 1744, 2006.88, 10.57, 0, 0, 90, 35000, 559, 'Muscle-Car', 'Jester', 37),
414
415(6, 1745.725, 1993.88, 10.6, 0, 0, 90, 54500, 555, 'Cabrio', 'Windsor', 38),
416
417(6, 1746.39, 1985.35, 11.18, 0, 0, 90, 28750, 489, 'Jeep', 'Rancher', 39),
418
419(7, 2148.72, 1397.41, 10.75, 0, 0, 0, 47800, 402, 'Sportwagen', 'Buffalo', 40),
420
421(6, 1745.65, 1972.61, 10.51, 0, 0, 90, 34500, 565, 'Zweituerer', 'Flash', 41),
422
423(7, 2142.47, 1395.71, 10.75, 0, 0, 0, 89500, 409, 'Limousine', 'Stretch', 42),
424
425(7, 2139.501953125, 1396.9553222656, 10.76, 0, 0, 0, 19500, 545, 'Muscle-Car', 'Hustler', 43),
426
427(7, 2132.72, 1396.93, 10.79, 0, 0, 0, 24500, 568, 'Buggy', 'Bandito', 44),
428
429(7, 2126.37, 1397.1, 10.73, 0, 0, 0, 45000, 561, 'SUV', 'Stratum', 45),
430
431(7, 2120.1, 1397.43, 10.61, 0, 0, 0, 43000, 560, 'Viertuerer', 'Sultan', 46),
432
433(7, 2123.05, 1397.17, 10.65, 0, 0, 0, 24950, 535, 'Lowrider', 'Slamvan', 47),
434
435(7, 2113.57, 1397.91, 10.58, 0, 0, 0, 17800, 468, 'Cross\nMotorad', 'Sanchez', 48),
436
437(7, 2148.62, 1409.58, 10.74, 0, 0, 180, 27850, 550, 'Vierteurer', 'Sunrise', 49),
438
439(7, 2139.1, 1410.19, 10.53, 0, 0, 180, 19500, 589, 'Zweituerer', 'Club', 50),
440
441(7, 2132.6291503906, 1409.98, 10.67, 0, 0, 180, 29800, 536, 'Lowrider-\nCabrio', 'Blade', 51),
442
443(7, 2129.5183105, 1411.01, 10.72, 0, 0, 180, 12500, 479, 'SUV', 'Regina', 52),
444
445(8, -942.18560791016, 2648.8591308594, 42.386817932129, 0, 0, 135, 74500, 460, 'Wasserflug-\nzeug', 'Skimmer', 53),
446
447(8, -912.12268066406, 2695.1982421875, 42.017189025879, 0, 0, 135, 45000, 539, 'Hovercraft', 'Vortex', 54),
448
449(9, -887.50402832031, 2697.2333984375, 41.945262908936, 0, 0, 315, 24500, 471, 'Quad', 'Quadbike', 55),
450
451(9, -893.67626953125, 2700.0336914063, 42.320129394531, 0, 0, 315, 39500, 442, 'Leichen-\nwagen', 'Romero', 56),
452
453(9, -902.78149414063, 2699.6669921875, 42.096534729004, 0, 0, 0, 23500, 457, 'Golf-\nwagen', 'Caddy', 57),
454
455(10, 1994.6566162109, 2059.0798339844, 10.62031269, 0, 0, 0, 37500, 533, 'Cabrio', 'Feltzer', 58),
456
457(10, 1991.0211181641, 2058.85, 10.57, 0, 0, 0, 64780, 562, 'Sportwagen', 'Elegy', 59),
458
459(10, 1987.41, 2058.85, 10.72, 0, 0, 0, 24000, 491, 'Zweituerer', 'Virgo', 60),
460
461(10, 1983.7, 2058.7, 10.79, 0, 0, 0, 32700, 567, 'Lowrider', 'Savanna', 61),
462
463(10, 1979.65, 2058.69, 10.52, 0, 0, 0, 80000, 541, 'Sportwagen', 'Bullet', 62),
464
465(10, 1994.71, 2035.77, 10.8, 0, 0, 180, 34500, 445, 'Viertuerer', 'Admiral', 63),
466
467(10, 1990.63, 2035.77, 10.94, 0, 0, 180, 47500, 400, 'Jeep', 'Landstalker', 64),
468
469(10, 1986.39, 2036.29, 10.68, 0, 0, 180, 24000, 401, 'Zweituerer', 'Bravura', 65),
470
471(10, 1982.29, 2035.91, 10.51, 0, 0, 180, 65000, 558, 'Sportwagen', 'Uranus', 66),
472
473(11, -2089.78, -2242.6, 30.82, 359, 359, 45, 11950, 543, 'Pickup', 'Sadler', 67),
474
475(11, -2098.32, -2255, 30.7, 0, 0, 0, 9500, 478, 'Pickup', 'Walton', 68),
476
477(11, -2112.39, -2241.16, 30.4, 0, 0, 0, 19500, 518, 'Zweitruerer', 'Buccaneer', 69),
478
479(11, -2099.4, -2225.87, 30.46, 0, 0, 45, 2900, 542, 'Zweitruerer', 'Clover', 70);
480
481
482
483
484
485CREATE TABLE IF NOT EXISTS `cars_ai` (
486
487`ID` int(11) NOT NULL AUTO_INCREMENT,
488
489`Model` int(11) NOT NULL,
490
491`Preis` int(11) NOT NULL,
492
493`Name` varchar(50) NOT NULL,
494PRIMARY KEY (`ID`)
495) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1;
496
497
498
499
500
501INSERT INTO `cars_ai` (`ID`, `Model`, `Preis`, `Name`) VALUES
502
503(1, 496, 28000, 'Blista Compact'),
504
505(2, 580, 175000, 'Stafford'),
506
507(3, 534, 54500, 'Remington'),
508
509(4, 480, 95000, 'Comet'),
510
511(5, 451, 249500, 'Turismo'),
512
513(6, 558, 124500, 'Uranus'),
514
515(7, 477, 200000, 'ZR-350'),
516
517(8, 521, 79500, 'FCR-900'),
518
519(9, 507, 50000, 'Elegant'),
520
521(10, 531, 149500, 'Tractor'),
522
523(11, 483, 175000, 'Camper');
524
525
526
527
528
529
530CREATE TABLE IF NOT EXISTS `cars_peds_ai` (
531
532`ID` int(11) NOT NULL AUTO_INCREMENT,
533
534`VehX` float NOT NULL,
535
536`VehY` float NOT NULL,
537
538`VehZ` float NOT NULL,
539
540`VehRX` float NOT NULL,
541
542`VehRY` float NOT NULL,
543
544`VehRZ` float NOT NULL,
545
546`PedX` float NOT NULL,
547
548`PedY` float NOT NULL,
549
550`PedZ` float NOT NULL,
551
552`PedR` float NOT NULL,
553PRIMARY KEY (`ID`)
554) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
555
556INSERT INTO `cars_peds_ai` (`ID`, `VehX`, `VehY`, `VehZ`, `VehRX`, `VehRY`, `VehRZ`, `PedX`, `PedY`, `PedZ`, `PedR`) VALUES
557
558(1, -2099.44, -9.94, 35.32, 0, 0, 260, -2099.93, -11.63, 34.32, 190),
559
560(2, -2693.58, 1228.74, 55.56, 0, 0, 0, -2691.69, 1227.19, 54.56, 220),
561
562(3, -2804.4, -252.72, 7.17, 0, 0, 0, -2805.06, -249.59, 6.03, 0),
563
564(4, -1446.24, 920.05, 7.18, 0, 0, 0, -1444.79, 919.6, 6.18, 270),
565
566(5, -1959.31, 1227.51, 31.64, 0, 0, 18, -1958.05, 1227.93, 30.64, 285),
567
568(6, -2706.82, 1304.78, 7.04, 0, 0, 190, -2705.09, 1304.53, 6.05, 240);
569
570
571
572CREATE TABLE IF NOT EXISTS `email` (
573
574`EmpfaengerUID` int(4) NOT NULL,
575
576`Text` varchar(500) NOT NULL,
577
578`Yearday` int(11) NOT NULL,
579
580`Year` int(11) NOT NULL,
581`ID` int(11) NOT NULL AUTO_INCREMENT,
582
583PRIMARY KEY (`ID`)
584) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
585
586
587
588
589
590
591CREATE TABLE IF NOT EXISTS `fraktionen` (
592
593`Name` varchar(50) NOT NULL,
594
595`ID` int(2) NOT NULL,
596
597`FKasse` varchar(50) NOT NULL,
598
599`DepotGeld` varchar(50) NOT NULL DEFAULT '0',
600
601`DepotDrogen` varchar(50) NOT NULL DEFAULT '0',
602
603`DepotMaterials` varchar(50) NOT NULL DEFAULT '0'
604,
605PRIMARY KEY (`ID`)
606) ENGINE=MyISAM DEFAULT CHARSET=latin1;
607
608
609
610
611
612INSERT INTO `fraktionen` (`Name`, `ID`, `FKasse`, `DepotGeld`, `DepotDrogen`, `DepotMaterials`) VALUES
613
614('SFPD', 1, '0', '0', '0', '0'),
615('Mafia', 2, '0', '0', '0', '10000'),
616
617('Triaden', 3, '0', '0', '0', '10000'),
618
619('Terroristen', 4, '0', '0', '0', '10000'),
620
621('Reporter', 5, '0', '20000', '0', '0'),
622('FBI', 6, '0', '0', '0', '0'),
623
624('Aztecas', 7, '0', '0', '0', '10000'),
625
626('Biker', 9, '0', '0', '0', '10000'),
627
628('MechMedic', 10, '0', '0', '0', '0'),
629('Ballas', 12, '0', '0', '0', '10000'),
630('Grove', 13, '0', '0', '0', '10000');
631
632
633CREATE TABLE IF NOT EXISTS `gangs` (
634
635`ID` int(2) NOT NULL AUTO_INCREMENT,
636
637`X1` varchar(50) NOT NULL,
638
639`Y1` varchar(50) NOT NULL,
640
641`X2` varchar(50) NOT NULL,
642
643`Y2` varchar(50) NOT NULL,
644
645`X3` varchar(50) NOT NULL,
646
647`Y3` varchar(50) NOT NULL,
648
649`Z3` varchar(50) NOT NULL,
650
651`BesitzerFraktion` int(2) NOT NULL,
652
653`Einnahmen` int(5) NOT NULL COMMENT 'Geld'
654,
655
656`Name` text NOT NULL,
657
658`Aktiviert` int(1) NOT NULL DEFAULT '1' COMMENT 'Ob es Ingame aktiviert oder deaktiviert ist'
659
660,
661PRIMARY KEY (`ID`)
662) ENGINE=MyISAM AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;
663
664
665
666
667
668INSERT INTO `gangs` (`ID`, `X1`, `Y1`, `X2`, `Y2`, `X3`, `Y3`, `Z3`, `BesitzerFraktion`, `Einnahmen`, `Name`, `Aktiviert`) VALUES
669
670(1, '-2758.99', '1310.52', '-2573.75', '1528.54', '-2631.68', '1357.41', '6.75', 2, 10, 'Jizzys', 0),
671
672(2, '743.70001220703', '-1684.5', '862.59997558594', '-1574.4000244141', '786.09997558594', '-1632.4000244141', '13.39999961853', 9, 8, 'Burgershot LS', 1),
673
674(3, '-2201.72', '-280.57', '-2096.76', '-80.93', '-2136.24', '-181.63', '34.96', 9, 1, 'Drogenlabor', 1),
675
676(4, '-2215.40', '-950.06', '-2025', '-700', '-2115.4033203125', '-893.06', '31.67', 7, 7, 'SF Uni', 1),
677
678(5, '-2811.12', '-413.97', '-2634.36', '-261.18', '-2719.86', '-317.43', '7.5', 9, 8, 'Tennisplatz', 1),
679
680(6, '-2293.56', '2226.63', '-2237.42', '2473.87', '-2261.91', '2317.41', '4.46', 7, 4, 'Bayside', 1),
681
682(7, '-87.404563903809', '2420.3674316406', '458.44122314453', '2575.6437988281', '317.39999389648', '2437.6999511719', '16.5', 7, 7, 'Flugzeugfriedhof', 1),
683(8, '2558.8000488281', '2242.6999511719', '2677.3000488281', '2474.5', '2606', '2302.8999023438', '10.800000190735', 7, 10, 'Rock Hotel', 1),
684
685(9, '2777.1000976563', '833.29998779297', '2895.1000976563', '1023.299987793', '2862.1999511719', '919.09997558594', '10.800000190735', 7, 9, 'Linden Side', 1),
686
687(10, '111.78970', '1336.29541', '287.11746', '1484.41968', '191.09195', '1434.08276', '10.58594', 9, 4, 'Raffinerie', 1),
688
689(11, '974.55304', '948.50726', '1177.29517', '1166.17798', '1087.21240', '1074.30579', '10.83816', 9, 6, 'LV Uni', 1),
690
691(12, '1577.68152', '943.66669', '1756.69226', '1122.69128', '1667.1455078125', '1013.2158203125', '10.8203125', 13, 5, 'Depot', 1),
692
693(13, '1300.3671875', '2102.9736328125', '1397.1962890625', '2198.951171875', '1358.8984375', '2160.513671875', '11.015625', 9, 4, 'Baseballstadion', 1),
694
695(14, '-624.1655273438', '-564.07165527344', '-467.08432006836', '-467.08432006836', '-485.64794921875', '-505.75033569336', '25.517845153809', 7, 4, 'SF Lagerhalle', 1),
696
697(15, '2437.3999023438', '1083.1999511719', '2597.3999023438', '1183.3000488281', '2527.3999023438', '1137.0999755859', '10.699999809265', 2, 9, 'Streets', 0),
698
699(16, '-593.20001220703', '-200.19999694824', '-422.29998779297', '-31.700000762939', '-511.39999389648', '-85.300003051758', '62.200000762939', 9, 10, 'Holzfaeller', 1),
700
701(17, '1860.7937011719', '-1452.2199707031', '1979.2247314453', '-1350.2930908203', '1918.2982177734', '-1400.6328125', '13.5703125', 7, 5, 'Skaterpark', 1),
702
703(18, '807.40002441406', '-1130.0999755859', '952.59997558594', '-1055.5999755859', '862.70001220703', '-1101.9000244141', '24.299999237061', 9, 10, 'Friedhof', 1),
704
705(19, '2371.8000488281', '1783.1999511719', '2497.3999023438', '1963.1999511719', '2420.3000488281', '1925.6999511719', '6', 7, 6, 'Baustelle', 1),
706
707(20, '2497.1999511719', '2617.1000976563', '2749.1999511719', '2857.6000976563', '2554.8999023438', '2753.3000488281', '10.800000190735', 7, 7, 'Pissgebiet', 1),
708
709(21, '2127.1000976563', '-2345', '2267.8000488281', '-2218.8999023438', '2167.1000976563', '-2274.3999023438', '13.39999961853', 2, 6, 'LS Lagerhalle', 0),
710
711(22, '-2361.49', '-183.31', '-2269.87', '-80.65', '-2308.15', '-123.21', '34.96', 3, 6, 'Burgershot SF', 0),
712(23, '-2201.72', '-280.57', '-2096.76', '-80.93', '-2136.24', '-181.63', '34.96', 3, 3, 'Fabrik SF', 0),
713
714(24, '1858.28', '1473.03', '2010.69', '1691', '1908.77', '1518.43', '13.62', 2, 5, 'Piratenschiff', 0),
715(25, '-1340.56787', '2464.59717', '-1261.05640', '2564.95508', '-1302.33545', '2512.67139', '87.04205', 3, 5, 'Ruine', 0),
716
717(26, '1046.3127441406', '-1704.1940917969', '1142.6439208984', '-1578.559623828', '1071.7454833984', '-1619.3309326172', '20.458673477173', 3, 4, 'Verona Center', 0),
718
719(27, '-462.16015625', '2169.0122070313', '-339.23330688477', '2290.5751953125', '-404.68014526367', '2233.251953125', '42.4296875', 2, 10, 'Ghosttown', 0),
720
721(28, '1277', '903.09997558594', '1497.4000244141', '1183.5999755859', '1398.4000244141', '1097.1999511719', '10.800000190735', 7, 5, 'LV Lagerhalle', 1),
722
723(29, '1358.9000244141', '-2368.8000488281', '1833.9000244141', '-2204.5', '1682.8000488281', '-2285.1000976563', '13.5', 2, 6, 'LS Airport', 1),
724
725(30, '1856.9000244141', '-1255.8000488281', '2061.8000488281', '-1141', '1969.5999755859', '-1187.5999755859', '25.8', 7, 7, 'Glen Park', 1);
726
727
728
729
730
731
732CREATE TABLE IF NOT EXISTS `gang_basic` (
733
734`ID` int(11) NOT NULL AUTO_INCREMENT,
735
736`Name` varchar(50) NOT NULL DEFAULT 'Gang',
737
738`LeaderMSG` varchar(50) NOT NULL DEFAULT '',
739
740`Waffe` int(2) NOT NULL DEFAULT '0',
741
742`Skin` int(3) NOT NULL DEFAULT '7',
743
744`HausID` int(4) NOT NULL DEFAULT '0',
745
746`Rang1` varchar(50) NOT NULL DEFAULT 'Anfaenger',
747
748`Rang2` varchar(50) NOT NULL DEFAULT 'Mitglied',
749
750`Rang3` varchar(50) NOT NULL DEFAULT 'Anfuehrer',
751
752`MaxMembers` int(4) NOT NULL DEFAULT '8',
753
754`Drugs` int(10) NOT NULL DEFAULT '0',
755
756`Mats` int(10) NOT NULL DEFAULT '0'
757,
758PRIMARY KEY (`ID`)
759) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
760
761
762
763
764
765CREATE TABLE IF NOT EXISTS `gang_members` (
766
767`UID` int(4) NOT NULL,
768
769`Gang` int(4) NOT NULL DEFAULT '0',
770
771`Rang` int(2) NOT NULL DEFAULT '1',
772
773`Founder` tinyint(1) NOT NULL DEFAULT '0',
774PRIMARY KEY (`UID`)
775) ENGINE=MyISAM DEFAULT CHARSET=latin1;
776
777
778
779
780CREATE TABLE IF NOT EXISTS `gang_vehicles` (
781
782`ID` int(11) NOT NULL AUTO_INCREMENT,
783
784`GangID` int(4) NOT NULL,
785
786`Typ` int(3) NOT NULL DEFAULT '500',
787
788`Tuning` varchar(50) NOT NULL DEFAULT '|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|',
789
790`Spawnpos_X` double NOT NULL DEFAULT '0',
791
792`Spawnpos_Y` double NOT NULL DEFAULT '0',
793
794`Spawnpos_Z` double NOT NULL DEFAULT '0',
795
796`Spawnrot_X` double NOT NULL DEFAULT '0',
797
798`Spawnrot_Y` double NOT NULL DEFAULT '0',
799
800`Spawnrot_Z` double NOT NULL DEFAULT '0',
801
802`Farbe` varchar(50) NOT NULL DEFAULT '|0|0|0|0|',
803
804`Paintjob` int(4) NOT NULL DEFAULT '3',
805
806`Lights` varchar(13) NOT NULL DEFAULT '|255|255|255|',
807PRIMARY KEY (`ID`)
808) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
809
810
811
812
813
814CREATE TABLE IF NOT EXISTS `houses` (
815
816`ID` int(11) NOT NULL AUTO_INCREMENT,
817
818`SymbolX` double NOT NULL,
819
820`SymbolY` double NOT NULL,
821
822`SymbolZ` double NOT NULL,
823
824`UID` int(4) NOT NULL,
825
826`Preis` int(11) NOT NULL,
827
828`CurrentInterior` int(11) NOT NULL,
829
830`Kasse` int(11) NOT NULL,
831
832`Miete` int(11) NOT NULL,
833PRIMARY KEY (`ID`)
834) ENGINE=MyISAM AUTO_INCREMENT=158 DEFAULT CHARSET=latin1;
835
836
837
838
839
840INSERT INTO `houses` (`ID`, `SymbolX`, `SymbolY`, `SymbolZ`, `UID`, `Preis`, `CurrentInterior`, `Kasse`, `Miete`) VALUES
841
842(109, -2172.4609375, 642.9287109375, 49.4375, 0, 20000, 5, 0, 0),
843
844(108, -2178.2060546875, -2307.9951171875, 30.625, 0, 20000, 5, 0, 0),
845
846(107, -1351.5322265625, 2499.5732421875, 87.849250793457, 0, 20000, 5, 0, 0),
847
848(106, -1347.75390625, 2475.0517578125, 87.849250793457, 0, 20000, 5, 0, 0),
849
850(105, -621.90795898438, 962.34161376953, 10.748706817627, 0, 20000, 5, 0, 0),
851
852(104, -758.9267578125, 907.416015625, 12.822581291199, 0, 20000, 5, 0, 0),
853
854(103, -2071.8571777344, 1414.4110107422, 7.7489624023438, 0, 250000, 11, 0, 0),
855
856(102, -2075.4743652344, 1377.5810546875, 7.5927696228027, 0, 250000, 11, 0, 0),
857
858(101, -2173.5791015625, 992.8349609375, 80, 0, 120000, 9, 0, 0),
859
860(100, -2634.9091796875, 239.568359375, 4.5588436126709, 0, 120000, 9, 0, 0),
861
862(99, -2689, 197.8330078125, 7.203125, 0, 120000, 9, 0, 0),
863
864(98, -2623.4306640625, -99.3818359375, 7.203125, 0, 120000, 9, 0, 0),
865
866(97, -2687.9052734375, 137.1318359375, 4.3425788879395, 0, 120000, 9, 0, 0),
867
868(96, -2723.2578125, -17.2978515625, 7.203125, 0, 120000, 9, 0, 0),
869
870(95, -2688.3876953125, -89.4287109375, 4.3359375, 0, 120000, 9, 0, 0),
871
872(94, -2725.7470703125, -92.5595703125, 7.203125, 0, 120000, 9, 0, 0),
873
874(93, -2686.828125, -188.076171875, 7.203125, 0, 120000, 9, 0, 0),
875
876(92, -2724.6630859375, -191.30078125, 4.3359375, 0, 120000, 9, 0, 0),
877
878(91, -2791.6103515625, 218.583984375, 7.859375, 0, 100000, 9, 0, 0),
879
880(90, -2789.1845703125, 183.6083984375, 10.0625, 0, 100000, 9, 0, 0),
881
882(89, -2791.71875, 143.244140625, 10.0546875, 0, 100000, 9, 0, 0),
883
884(88, -2790.2470703125, 126.935546875, 7.2019538879395, 0, 100000, 9, 0, 0),
885
886(87, -2791.5849609375, 92.1005859375, 7.859375, 0, 100000, 9, 0, 0),
887
888(86, -2790.26171875, 7.2080078125, 7.1953125, 0, 100000, 9, 0, 0),
889
890(85, -2791.5849609375, -17.693359375, 7.859375, 0, 100000, 9, 0, 0),
891
892(84, -2791.583984375, -145.9228515625, 7.859375, 0, 100000, 9, 0, 0),
893
894(83, -2790.279296875, -111.08984375, 7.2019538879395, 0, 100000, 9, 0, 0),
895
896(82, -2790.2626953125, -82.5576171875, 7.1953125, 0, 100000, 9, 0, 0),
897
898(81, -2790.2578125, 69.748046875, 7.1953125, 0, 120000, 9, 0, 0),
899
900(80, -2789.17578125, -52.7041015625, 10.0625, 0, 120000, 9, 0, 0),
901
902(79, -2789.1787109375, -181.392578125, 10.0625, 0, 120000, 9, 0, 0),
903
904(78, -2662.0693359375, 876.33203125, 79.773796081543, 0, 300000, 30, 0, 0),
905
906(77, -2573.90625, 1152.1513671875, 55.7265625, 0, 90000, 4, 0, 0),
907
908(76, -2548.9267578125, 1145.7041015625, 55.7265625, 0, 90000, 4, 0, 0),
909
910(75, -2517, 1142.41796875, 55.7265625, 0, 90000, 4, 0, 0),
911
912(74, -2478.8564453125, 1141.986328125, 55.7265625, 0, 90000, 4, 0, 0),
913
914(73, -2451.08203125, 1141.7626953125, 55.733276367188, 0, 90000, 4, 0, 0),
915
916(72, -2413.53125, 1137.4755859375, 55.7265625, 0, 90000, 4, 0, 0),
917
918(71, -2383.8046875, 1128.1474609375, 55.7265625, 0, 90000, 4, 0, 0),
919
920(70, -2358.92578125, 1118.0869140625, 55.7265625, 0, 90000, 4, 0, 0),
921
922(69, -2737.5546875, 866.3173828125, 64.6328125, 0, 50000, 4, 0, 0),
923
924(68, -2737.8427734375, 836.84765625, 56.25394821167, 0, 50000, 4, 0, 0),
925
926(67, -2738.314453125, 801.615234375, 53.0625, 0, 50000, 4, 0, 0),
927
928(66, -2738.3154296875, 789.0146484375, 54.3828125, 0, 50000, 4, 0, 0),
929
930(65, -2738.3134765625, 771.544921875, 54.3828125, 0, 50000, 4, 0, 0),
931
932(64, -2738.3232421875, 758.6748046875, 54.3828125, 0, 50000, 4, 0, 0),
933
934(63, -2738.3154296875, 746.31640625, 49.187034606934, 0, 50000, 4, 0, 0),
935
936(62, -2731.5361328125, 723.703125, 41.2734375, 0, 50000, 4, 0, 0),
937
938(61, -2706.7939453125, 722.857421875, 37.5390625, 0, 50000, 4, 0, 0),
939
940(60, -2677.94921875, 722.25390625, 28.595994949341, 0, 50000, 4, 0, 0),
941
942(59, -2661.5029296875, 722.2529296875, 27.962381362915, 0, 50000, 4, 0, 0),
943
944(58, -2640.294921875, 730.84765625, 30.075717926025, 0, 75000, 4, 0, 0),
945
946(57, -2397.634765625, -28.208984375, 35.984142303467, 0, 200000, 7, 0, 0),
947
948(56, -2625.48046875, 733.2900390625, 28.010688781738, 0, 60000, 4, 0, 0),
949
950(55, -2622.521484375, 749.744140625, 31.421875, 0, 50000, 4, 0, 0),
951
952(54, -2622.521484375, 766.3291015625, 36.8359375, 0, 50000, 4, 0, 0),
953
954(53, -2622.51953125, 782.626953125, 44.859375, 0, 50000, 4, 0, 0),
955
956(52, -2621.677734375, 802.9755859375, 49.984375, 0, 50000, 4, 0, 0),
957
958(51, -2657.3779296875, 848.6103515625, 64.0078125, 0, 160000, 3, 0, 0),
959
960(50, -2620.01953125, 874.8076171875, 58.921875, 0, 50000, 4, 0, 0),
961
962(49, -2619.7373046875, 845.3515625, 50.598487854004, 0, 50000, 4, 0, 0),
963
964(48, -2586.0087890625, 794.1748046875, 49.423362731934, 0, 50000, 4, 0, 0),
965
966(47, -2550.8408203125, 794.1748046875, 49.423389434814, 0, 50000, 4, 0, 0),
967
968(46, -2548.59765625, 819.794921875, 49.984375, 0, 50000, 4, 0, 0),
969
970(45, -2559.255859375, 819.7998046875, 49.984375, 0, 60000, 4, 0, 0),
971
972(44, -2565.87109375, 819.7958984375, 49.991027832031, 0, 60000, 4, 0, 0),
973
974(43, -2590.966796875, 819.791015625, 49.991027832031, 0, 50000, 4, 0, 0),
975
976(42, -2673.9111328125, 830.1787109375, 49.984375, 0, 75000, 4, 0, 0),
977
978(41, -2666.7490234375, 820.31640625, 49.984375, 0, 60000, 4, 0, 0),
979
980(40, -2700.33203125, 820.8623046875, 49.984375, 0, 60000, 4, 0, 0),
981
982(39, -2737.322265625, 822.9921875, 53.730987548828, 0, 60000, 4, 0, 0),
983
984(38, -2709.8447265625, 803.0810546875, 49.9765625, 0, 60000, 4, 0, 0),
985
986(37, -2677.23828125, 803.080078125, 49.9765625, 0, 60000, 4, 0, 0),
987
988(36, -2670.6923828125, 803.083984375, 49.9765625, 0, 60000, 4, 0, 0),
989
990(35, -2645.5693359375, 803.08984375, 49.9765625, 0, 60000, 4, 0, 0),
991
992(34, -2641.9873046875, 820.314453125, 49.984375, 0, 75000, 4, 0, 0),
993
994(33, -2618.7509765625, 831.078125, 49.984375, 0, 75000, 4, 0, 0),
995
996(32, -2592.8115234375, 832.8203125, 52.09375, 0, 60000, 4, 0, 0),
997
998(31, -2592.736328125, 855.0263671875, 53.594135284424, 0, 50000, 4, 0, 0),
999
1000(30, -2593.208984375, 883.0546875, 63.25, 0, 50000, 4, 0, 0),
1001
1002(29, -2580.962890625, 920.375, 64.984375, 0, 50000, 4, 0, 0),
1003
1004(28, -2961.6103515625, 476.7529296875, 4.9097900390625, 0, 400000, 12, 0, 0),
1005
1006(27, -2569.8173828125, 920.3779296875, 64.984375, 0, 60000, 4, 0, 0),
1007
1008(26, -2562.3212890625, 920.3798828125, 64.984375, 0, 60000, 4, 0, 0),
1009
1010(25, -2543.576171875, 922.2333984375, 67.09375, 0, 60000, 4, 0, 0),
1011
1012(24, -2340.037109375, 820.0361328125, 41.982936859131, 0, 50000, 4, 0, 0),
1013
1014(23, -2303.3173828125, 820.0361328125, 48.700397491455, 0, 50000, 4, 0, 0),
1015
1016(22, -2321.8115234375, 796.7578125, 45.344985961914, 0, 50000, 4, 0, 0),
1017
1018(21, -2358.642578125, 796.755859375, 38.323360443115, 0, 50000, 4, 0, 0),
1019
1020(20, -2320.1611328125, 580.0361328125, 31.070611953735, 0, 50000, 4, 0, 0),
1021
1022(19, -2356.8037109375, 580.0322265625, 24.890625, 0, 50000, 4, 0, 0),
1023
1024(18, -2372.5263671875, 614.0927734375, 30.936983108521, 0, 50000, 4, 0, 0),
1025
1026(17, -2372.5263671875, 643.98828125, 35.171875, 0, 50000, 4, 0, 0),
1027
1028(16, -2368.818359375, 763.5537109375, 35.151725769043, 0, 70000, 4, 0, 0),
1029
1030(15, -2504.5029296875, 821.306640625, 45.987236022949, 0, 50000, 4, 0, 0),
1031
1032(14, -2583.681640625, 896.2568359375, 64.984375, 0, 50000, 4, 0, 0),
1033
1034(13, -2566.5712890625, 896.6416015625, 64.984375, 0, 50000, 4, 0, 0),
1035
1036(12, -2541.58984375, 896.638671875, 64.984375, 0, 60000, 4, 0, 0),
1037
1038(11, -2540.099609375, 883.1826171875, 63.25, 0, 50000, 4, 0, 0),
1039
1040(10, -2540.6826171875, 855.1171875, 53.1796875, 0, 50000, 4, 0, 0),
1041
1042(9, -2538.73046875, 830.083984375, 49.984375, 0, 50000, 4, 0, 0),
1043
1044(8, -2513.505859375, 885.755859375, 62.778087615967, 0, 50000, 4, 0, 0),
1045
1046(7, -2513.50390625, 867.521484375, 57.7421875, 0, 50000, 4, 0, 0),
1047
1048(6, -2513.5078125, 830.822265625, 49.998344421387, 0, 50000, 4, 0, 0),
1049
1050(5, -2594.1875, 785.0849609375, 46.221897125244, 0, 50000, 4, 0, 0),
1051
1052(4, -2594.1904296875, 750.8564453125, 33.700843811035, 0, 50000, 4, 0, 0),
1053
1054(3, -2368.8193359375, 740.6796875, 35.151634216309, 0, 70000, 4, 0, 0),
1055
1056(2, -2372.529296875, 784.1201171875, 35.114852905273, 0, 50000, 4, 0, 0),
1057
1058(1, -2372.67578125, 692.650390625, 35.1640625, 0, 50000, 4, 0, 0),
1059
1060(110, -2034.89453125, 148.5302734375, 28.8359375, 0, 2000000, 20, 0, 0),
1061
1062(111, 1298.5087890625, -797.9853515625, 84.140625, 0, 2000000, 20, 0, 0),
1063
1064(112, -2390.938232, -45.126759, 37.204144, 0, 75000, 3, 0, 0),
1065
1066(113, -2391.184326, -21.314453, 37.204144, 0, 75000, 3, 0, 0),
1067
1068(114, -2390.60791, -0.113867, 37.204144, 0, 75000, 3, 0, 0),
1069
1070(115, -2390.89502, 24.048828, 37.204144, 0, 75000, 3, 0, 0),
1071
1072(116, -2127.009766, 443.791016, 35.171875, 0, 250000, 10, 0, 0),
1073
1074(117, -2107.111328, 463.871094, 35.171875, 0, 250000, 10, 0, 0),
1075
1076(118, -2087.014648, 483.78418, 35.171875, 0, 250000, 10, 0, 0),
1077
1078(119, -2027.850586, -40.604492, 38.804688, 0, 90000, 3, 0, 0),
1079
1080(120, -1051.389648, 1549.77832, 33.437611, 0, 35000, 1, 0, 0),
1081
1082(121, -2904.347656, 1178.96582, 13.664062, 0, 55000, 9, 0, 0),
1083
1084(122, -2905.169922, 1164.814453, 13.664062, 0, 55000, 9, 0, 0),
1085
1086(123, -2904.697266, 1118.751953, 27.070312, 0, 55000, 9, 0, 0),
1087
1088(124, -2904.47168, 1101.116211, 27.070312, 0, 55000, 9, 0, 0),
1089
1090(125, -2900.716797, 1080.936523, 32.132812, 0, 55000, 9, 0, 0),
1091
1092(126, -2900.712891, 1066.890625, 32.132812, 0, 55000, 9, 0, 0),
1093
1094(127, -2900.455078, 1056.894531, 32.132812, 0, 55000, 9, 0, 0),
1095
1096(128, -2901.662109, 1033.612305, 36.828125, 0, 55000, 9, 0, 0),
1097
1098(129, -2895.5625, 1016.867188, 36.828125, 0, 55000, 9, 0, 0),
1099
1100(130, -2899.106445, 1026.84375, 36.828125, 0, 55000, 9, 0, 0),
1101
1102(131, -2888.036133, 1001.768555, 40.71875, 0, 55000, 9, 0, 0),
1103
1104(132, -2881.033203, 989.631836, 40.71875, 0, 55000, 9, 0, 0),
1105
1106(133, -2875.985352, 980.888672, 40.72596, 0, 55000, 9, 0, 0),
1107
1108(134, -2860.537109, 963.823242, 44.054688, 0, 55000, 9, 0, 0),
1109
1110(135, -2857.637695, 956.966797, 44.054688, 0, 55000, 9, 0, 0),
1111
1112(136, -2853.197266, 947.452148, 44.054688, 0, 55000, 9, 0, 0),
1113(137, -2845.308594, 928.443359, 44.054688, 0, 55000, 9, 0, 0),
1114
1115(138, -2844.089844, 914.423828, 44.054688, 0, 55000, 9, 0, 0),
1116
1117(139, -2843.214844, 904.429688, 44.054688, 0, 55000, 9, 0, 0),
1118
1119(140, -2840.227539, 884.605469, 44.054688, 0, 55000, 9, 0, 0),
1120
1121(141, -2840.223633, 866.917969, 44.054688, 0, 55000, 9, 0, 0),
1122
1123(142, -2856.664062, 841.943359, 39.649616, 0, 55000, 9, 0, 0),
1124
1125(143, -2863.667969, 829.803711, 39.53997, 0, 55000, 9, 0, 0),
1126
1127(144, -2868.735352, 821.013672, 39.460468, 0, 55000, 9, 0, 0),
1128
1129(145, -2880.266602, 797.630859, 35.29818, 0, 55000, 9, 0, 0),
1130
1131(146, -2882.260742, 779.995117, 35.089928, 0, 55000, 9, 0, 0),
1132
1133(147, -2884.796875, 750.744141, 29.201218, 0, 55000, 9, 0, 0),
1134
1135(148, -2884.168945, 743.575195, 29.217739, 0, 55000, 9, 0, 0),
1136
1137(149, -2883.579102, 736.842773, 29.211348, 0, 55000, 9, 0, 0),
1138
1139(150, -2882.349609, 726.676758, 29.196587, 0, 55000, 9, 0, 0),
1140
1141(151, -2872.40625, 697.395508, 23.462742, 0, 55000, 9, 0, 0),
1142
1143(152, -2869.395508, 690.944336, 23.4617, 0, 55000, 9, 0, 0),
1144
1145(153, -2864.962891, 681.462891, 23.460388, 0, 55000, 9, 0, 0),
1146
1147(155, -1440.779297, -948.81427, 201.371246, 0, 100000, 3, 0, 0),
1148
1149(156, -1429.484741, -936.557129, 202.388275, 0, 100000, 3, 0, 0),
1150
1151(157, -1430.284668, -959.369629, 201.440735, 0, 100000, 3, 0, 0);
1152
1153
1154
1155
1156CREATE TABLE IF NOT EXISTS `idcounter` (
1157
1158`id` int(50) NOT NULL DEFAULT '1'
1159,
1160PRIMARY KEY (`id`)
1161) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1162
1163
1164
1165
1166INSERT INTO `idcounter` (`id`) VALUES
1167(1);
1168
1169
1170
1171
1172
1173
1174CREATE TABLE IF NOT EXISTS `inventar` (
1175
1176`UID` int(4) NOT NULL,
1177
1178`Wuerfel` tinyint(1) NOT NULL DEFAULT '0',
1179
1180`Blumensamen` int(11) NOT NULL DEFAULT '0',
1181
1182`Lottoschein` varchar(50) NOT NULL DEFAULT '0|0|0|0|0|0',
1183
1184`Essensslot1` int(2) NOT NULL DEFAULT '0',
1185
1186`Essensslot2` int(2) NOT NULL DEFAULT '0',
1187
1188`Essensslot3` int(2) NOT NULL DEFAULT '0',
1189
1190`Waffenslot1` varchar(50) NOT NULL DEFAULT '0|0',
1191
1192`Waffenslot2` varchar(50) NOT NULL DEFAULT '0|0',
1193
1194`Waffenslot3` varchar(50) NOT NULL DEFAULT '0|0',
1195
1196`Zigaretten` int(5) NOT NULL DEFAULT '0',
1197
1198`Materials` int(10) NOT NULL DEFAULT '0',
1199
1200`Benzinkanister` int(10) NOT NULL DEFAULT '0',
1201
1202`FruitNotebook` tinyint(1) NOT NULL DEFAULT '1',
1203
1204`Gameboy` int(1) NOT NULL DEFAULT '0',
1205
1206`Objekt` int(10) NOT NULL DEFAULT '0',
1207
1208`Chips` int(50) NOT NULL DEFAULT '0',
1209
1210`Geschenke` int(50) NOT NULL DEFAULT '0',
1211
1212`fishing` varchar(39) NOT NULL DEFAULT '0|0|0|0;0|0;0|0;0',
1213
1214`fglass` tinyint(1) NOT NULL DEFAULT '0',
1215
1216`Medikit` int(10) NOT NULL DEFAULT '0',
1217
1218`Spezial` varchar(50) NOT NULL DEFAULT '0|0|0|0|0|0',
1219
1220`Repairkit` int(10) DEFAULT '0',
1221PRIMARY KEY (`UID`)
1222) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1223
1224
1225
1226
1227CREATE TABLE IF NOT EXISTS `loggedin` (
1228
1229`UID` int(4) NOT NULL,
1230
1231`Serial` varchar(32) NOT NULL DEFAULT 'ABCD1234ABCD1234',
1232
1233`IP` varchar(50) NOT NULL DEFAULT '0.0.0.0',
1234
1235`Loggedin` tinyint(1) NOT NULL DEFAULT '0',
1236PRIMARY KEY (`UID`)
1237) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1238
1239
1240
1241
1242
1243
1244CREATE TABLE IF NOT EXISTS `logout` (
1245
1246`UID` int(4) NOT NULL,
1247
1248`Position` varchar(50) NOT NULL,
1249
1250`Waffen` varchar(50) NOT NULL,
1251PRIMARY KEY (`UID`)
1252) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1253
1254
1255
1256
1257
1258
1259CREATE TABLE IF NOT EXISTS `logs` (
1260
1261`ID` int(11) NOT NULL AUTO_INCREMENT,
1262
1263`Typ` int(2) NOT NULL,
1264
1265`Text` varchar(255) NOT NULL,
1266
1267`Timestamp` int(50) NOT NULL
1268,
1269PRIMARY KEY (`ID`)
1270) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
1271
1272
1273
1274
1275
1276
1277CREATE TABLE IF NOT EXISTS `lotto` (
1278
1279`id` int(10) NOT NULL AUTO_INCREMENT,
1280
1281`UID` int(4) NOT NULL,
1282
1283`z1` int(2) NOT NULL DEFAULT '0',
1284
1285`z2` int(2) NOT NULL DEFAULT '0',
1286
1287`z3` int(2) NOT NULL DEFAULT '0'
1288,
1289PRIMARY KEY (`id`)
1290) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
1291
1292
1293
1294
1295CREATE TABLE IF NOT EXISTS `object` (
1296
1297`UID` int(4) NOT NULL,
1298
1299`id` int(10) NOT NULL AUTO_INCREMENT,
1300
1301`model` int(6) NOT NULL,
1302
1303`x` float NOT NULL,
1304
1305`y` float NOT NULL,
1306
1307`z` float NOT NULL,
1308
1309`rx` float NOT NULL,
1310
1311`taken` tinyint(1) NOT NULL DEFAULT '0',
1312
1313`placer` varchar(50) NOT NULL,
1314
1315`deleteTime` int(15) NOT NULL
1316,
1317PRIMARY KEY (`id`)
1318) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
1319
1320
1321
1322
1323
1324CREATE TABLE IF NOT EXISTS `packages` (
1325
1326`UID` int(4) NOT NULL,
1327
1328`Paket1` int(11) NOT NULL,
1329
1330`Paket2` int(11) NOT NULL,
1331
1332`Paket3` int(11) NOT NULL,
1333
1334`Paket4` int(11) NOT NULL,
1335
1336`Paket5` int(11) NOT NULL,
1337
1338`Paket6` int(11) NOT NULL,
1339
1340`Paket7` int(11) NOT NULL,
1341
1342`Paket8` int(11) NOT NULL,
1343
1344`Paket9` int(11) NOT NULL,
1345
1346`Paket10` int(11) NOT NULL,
1347
1348`Paket11` int(11) NOT NULL,
1349
1350`Paket12` int(11) NOT NULL,
1351
1352`Paket13` int(11) NOT NULL,
1353
1354`Paket14` int(11) NOT NULL,
1355
1356`Paket15` int(11) NOT NULL,
1357
1358`Paket16` int(11) NOT NULL,
1359
1360`Paket17` int(11) NOT NULL,
1361
1362`Paket18` int(11) NOT NULL,
1363
1364`Paket19` int(11) NOT NULL,
1365
1366`Paket20` int(11) NOT NULL,
1367
1368`Paket21` int(11) NOT NULL,
1369
1370`Paket22` int(11) NOT NULL,
1371
1372`Paket23` int(11) NOT NULL,
1373
1374`Paket24` int(11) NOT NULL,
1375
1376`Paket25` int(11) NOT NULL
1377,
1378PRIMARY KEY (`UID`)
1379) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1380
1381
1382
1383
1384
1385CREATE TABLE IF NOT EXISTS `players` (
1386
1387`UID` int(4) NOT NULL,
1388
1389`Name` varchar(50) NOT NULL,
1390
1391`Serial` varchar(50) NOT NULL,
1392
1393`IP` varchar(50) NOT NULL,
1394
1395`Last_login` varchar(50) NOT NULL,
1396
1397`Geburtsdatum_Tag` int(11) NOT NULL,
1398
1399`Geburtsdatum_Monat` int(11) NOT NULL,
1400
1401`Geburtsdatum_Jahr` int(4) NOT NULL,
1402
1403`Passwort` text NOT NULL,
1404
1405`Geschlecht` int(50) NOT NULL,
1406
1407`RegisterDatum` varchar(50) NOT NULL,
1408
1409`LastLogin` int(50) NOT NULL DEFAULT '1',
1410
1411`Erlaubnis` int(1) NOT NULL DEFAULT '0' COMMENT 'fuer das Spielen mit mehreren Accs an einem PC'
1412,
1413PRIMARY KEY (`UID`)
1414) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1415
1416
1417
1418
1419CREATE TABLE IF NOT EXISTS `playingtime` (
1420
1421`UID` int(4) NOT NULL,
1422
1423`Time` int(4) NOT NULL DEFAULT '0',
1424PRIMARY KEY (`UID`)
1425) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1426
1427
1428
1429
1430
1431CREATE TABLE IF NOT EXISTS `pm` (
1432
1433`Sender` varchar(50) NOT NULL,
1434
1435`EmpfaengerUID` int(4) NOT NULL,
1436
1437`Text` varchar(500) NOT NULL,
1438
1439`Datum` varchar(50) NOT NULL,
1440
1441`ids` int(50) NOT NULL AUTO_INCREMENT,
1442PRIMARY KEY (`ids`)
1443) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
1444
1445
1446
1447
1448
1449CREATE TABLE IF NOT EXISTS `prestige` (
1450
1451`ID` int(10) NOT NULL AUTO_INCREMENT,
1452
1453`X` float NOT NULL,
1454
1455`Y` float NOT NULL,
1456
1457`Z` float NOT NULL,
1458
1459`Besitzer` varchar(50) NOT NULL,
1460
1461`UID` int(11) NOT NULL,
1462
1463`Preis` int(7) NOT NULL,
1464
1465`Beschreibung` varchar(100) NOT NULL,
1466PRIMARY KEY (`ID`)
1467) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;
1468
1469
1470
1471
1472
1473INSERT INTO `prestige` (`ID`, `X`, `Y`, `Z`, `Besitzer`, `UID`, `Preis`, `Beschreibung`) VALUES
1474
1475(1, -2154.5, 461.22, 34.82, 'none', 0, 250000, 'Glockenturm'),
1476
1477(2, -1494.54, 920.17, 6.83, 'none', 0, 500000, 'Glockenturm-Geb?ude ( SFPD )'),
1478
1479(3, -1937.04, 883.32, 38.16, 'none', 0, 100000, 'Statue'),
1480
1481(4, -1989.04, 1117.92, 54.12, 'none', 0, 250000, 'Kirche'),
1482
1483(5, -2520.94, -623.43, 132.42, 'none', 0, 175000, 'EWerk'),
1484
1485(6, -2157.94, -399.43, 34.98, 'none', 0, 75000, 'Football'),
1486
1487(7, -2594.15, -41.08, 3.97, 'none', 0, 300000, 'Gedenkstaette'),
1488
1489(8, -2818.16, 1145.8, 20.01, 'none', 0, 250000, 'Park'),
1490
1491(9, -1503.91, 1373.92, 3.43, 'none', 0, 250000, 'Insel'),
1492
1493(10, -2533.16, 1221.05, 37.07, 'none', 0, 125000, 'Diner'),
1494
1495(11, 2490.67, 918.43, 10.67, 'none', 0, 150000, 'Kirche'),
1496
1497(12, 2000.82, 1523.16, 16.71, 'none', 0, 245000, 'Piratenschiff'),
1498
1499(13, 2226.35, 1838.65, 10.46, 'none', 0, 150000, 'Clown-Casino'),
1500
1501(14, -236.84, 2656.15, 62.29, 'none', 0, 75000, 'Riesenhuehnchen');
1502
1503
1504
1505
1506
1507
1508CREATE TABLE IF NOT EXISTS `racing` (
1509
1510`UID` int(4) NOT NULL,
1511
1512`Name` varchar(50) NOT NULL,
1513
1514`MilliSekunden` int(1) NOT NULL,
1515
1516`Sekunden` int(2) NOT NULL,
1517
1518`Minuten` int(5) NOT NULL,
1519
1520`Platz` int(11) NOT NULL,
1521PRIMARY KEY (`UID`)
1522) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1523
1524
1525
1526CREATE TABLE IF NOT EXISTS `skills` (
1527
1528`UID` int(4) NOT NULL,
1529
1530`fishing` int(5) NOT NULL DEFAULT '0',
1531
1532`repair` int(5) NOT NULL DEFAULT '0',
1533
1534`gamble` int(10) NOT NULL DEFAULT '0',
1535
1536`cook` int(5) NOT NULL DEFAULT '0'
1537,
1538PRIMARY KEY (`UID`)
1539) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1540
1541
1542
1543
1544
1545CREATE TABLE IF NOT EXISTS `state_files` (
1546
1547`UID` int(4) NOT NULL,
1548
1549`text` varchar(1000) NOT NULL,
1550
1551`editor` varchar(50) NOT NULL,
1552
1553`faction` int(2) NOT NULL DEFAULT '0'
1554,
1555PRIMARY KEY (`UID`)
1556) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1557
1558
1559
1560
1561
1562CREATE TABLE IF NOT EXISTS `statistics` (
1563
1564`UID` int(4) NOT NULL,
1565
1566`AnzahlEingeknastet` int(11) NOT NULL DEFAULT '0',
1567
1568`AnzahlImKnast` int(11) NOT NULL DEFAULT '0',
1569
1570`AnzahlGangwars` int(11) NOT NULL DEFAULT '0',
1571
1572`AnzahlGangwarsGewonnen` int(11) NOT NULL DEFAULT '0',
1573
1574`AnzahlGangwarsVerloren` int(11) NOT NULL DEFAULT '0',
1575
1576`Kills` int(11) NOT NULL DEFAULT '0',
1577
1578`Tode` int(11) NOT NULL DEFAULT '0',
1579
1580`GangwarKills` int(11) NOT NULL DEFAULT '0',
1581
1582`GangwarTode` int(11) NOT NULL DEFAULT '0',
1583
1584`HaeuserGekauft` int(11) NOT NULL DEFAULT '0',
1585
1586`FahrzeugeGekauft` int(11) NOT NULL DEFAULT '0',
1587
1588`FahrzeugeVerkauft` int(11) NOT NULL DEFAULT '0',
1589
1590`DamageGemacht` int(11) NOT NULL DEFAULT '0',
1591
1592`DamageBekommen` int(11) NOT NULL DEFAULT '0',
1593
1594`GangwarDamageGemacht` int(11) NOT NULL DEFAULT '0',
1595
1596`GangwarDamageBekommen` int(11) NOT NULL DEFAULT '0',
1597
1598`FraktionenBetreten` int(11) NOT NULL DEFAULT '0',
1599
1600`FraktionenVerlassen` int(11) NOT NULL DEFAULT '0',
1601
1602`Eingeloggt` int(11) NOT NULL DEFAULT '0',
1603
1604`MontagSpielzeit` int(11) NOT NULL DEFAULT '0',
1605
1606`DienstagSpielzeit` int(11) NOT NULL DEFAULT '0',
1607
1608`MittwochSpielzeit` int(11) NOT NULL DEFAULT '0',
1609
1610`DonnerstagSpielzeit` int(11) NOT NULL DEFAULT '0',
1611
1612`FreitagSpielzeit` int(11) NOT NULL DEFAULT '0',
1613
1614`SamstagSpielzeit` int(11) NOT NULL DEFAULT '0',
1615
1616`SonntagSpielzeit` int(11) NOT NULL DEFAULT '0',
1617
1618`LetzteWocheSpielzeit` int(11) NOT NULL DEFAULT '0',
1619PRIMARY KEY (`UID`)
1620) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1621
1622
1623
1624
1625
1626CREATE TABLE IF NOT EXISTS `ticketsystem` (
1627
1628`id` int(11) NOT NULL AUTO_INCREMENT,
1629
1630`UID` int(4) NOT NULL,
1631
1632`reason` text NOT NULL,
1633
1634`text` text NOT NULL,
1635
1636`date` text NOT NULL,
1637
1638`category` text NOT NULL,
1639
1640`state` text NOT NULL
1641,
1642PRIMARY KEY (`id`)
1643) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
1644
1645
1646
1647
1648
1649CREATE TABLE IF NOT EXISTS `ticket_answeres` (
1650
1651`id` int(11) NOT NULL AUTO_INCREMENT,
1652
1653`UID` int(4) NOT NULL,
1654
1655`adminUID` int(4) NOT NULL,
1656
1657`text` text NOT NULL,
1658PRIMARY KEY (`id`)
1659) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
1660
1661
1662
1663
1664CREATE TABLE IF NOT EXISTS `userdata` (
1665
1666`UID` int(4) NOT NULL,
1667
1668`Name` varchar(50) NOT NULL,
1669
1670`Geld` double NOT NULL DEFAULT '350',
1671
1672`Spawnpos_X` varchar(50) NOT NULL DEFAULT '-2458.288085',
1673
1674`Spawnpos_Y` varchar(50) NOT NULL DEFAULT '774.354492',
1675
1676`Spawnpos_Z` varchar(50) NOT NULL DEFAULT '35.171875',
1677
1678`Spawnrot_X` varchar(50) NOT NULL DEFAULT '52.94',
1679
1680`SpawnInterior` double NOT NULL DEFAULT '0',
1681
1682`SpawnDimension` double NOT NULL DEFAULT '0',
1683
1684`Fraktion` double NOT NULL DEFAULT '0',
1685
1686`FraktionsRang` double NOT NULL DEFAULT '0',
1687
1688`Adminlevel` int(10) NOT NULL DEFAULT '0',
1689
1690`Spielzeit` double NOT NULL DEFAULT '0',
1691
1692`Hitglocke` int(1) NOT NULL DEFAULT '0',
1693
1694`CurrentCars` double NOT NULL DEFAULT '0',
1695
1696`MaximumCars` double NOT NULL DEFAULT '5',
1697
1698`Knastzeit` double NOT NULL DEFAULT '0',
1699
1700`Prison` double NOT NULL DEFAULT '0',
1701
1702`Kaution` int(4) NOT NULL DEFAULT '0',
1703
1704`Himmelszeit` double NOT NULL DEFAULT '0',
1705
1706`Hausschluessel` int(50) NOT NULL DEFAULT '0',
1707
1708`Bizschluessel` int(50) NOT NULL DEFAULT '0',
1709
1710`Bankgeld` double NOT NULL DEFAULT '35000',
1711
1712`Drogen` double NOT NULL DEFAULT '0',
1713
1714`Skinid` int(3) NOT NULL DEFAULT '0',
1715
1716`Autofuehrerschein` int(1) NOT NULL DEFAULT '0',
1717
1718`Motorradtfuehrerschein` int(1) NOT NULL DEFAULT '0',
1719
1720`LKWfuehrerschein` int(1) NOT NULL DEFAULT '0',
1721
1722`Helikopterfuehrerschein` int(1) NOT NULL DEFAULT '0',
1723
1724`FlugscheinKlasseA` int(1) NOT NULL DEFAULT '0',
1725
1726`FlugscheinKlasseB` int(1) NOT NULL DEFAULT '0',
1727
1728`Motorbootschein` int(1) NOT NULL DEFAULT '0',
1729
1730`Segelschein` int(1) NOT NULL DEFAULT '0',
1731
1732`Angelschein` int(1) NOT NULL DEFAULT '0',
1733
1734`Wanteds` int(1) NOT NULL DEFAULT '0',
1735
1736`StvoPunkte` int(2) NOT NULL DEFAULT '0',
1737
1738`Waffenschein` int(1) NOT NULL DEFAULT '0',
1739
1740`Perso` int(1) NOT NULL DEFAULT '0',
1741
1742`Boni` double NOT NULL DEFAULT '0',
1743
1744`PdayIncome` double NOT NULL DEFAULT '0',
1745
1746`Telefonnr` int(6) NOT NULL DEFAULT '0',
1747
1748`Warns` int(50) NOT NULL DEFAULT '0',
1749
1750`Gunbox1` varchar(50) NOT NULL DEFAULT '0|0',
1751
1752`Gunbox2` varchar(50) NOT NULL DEFAULT '0|0',
1753
1754`Gunbox3` varchar(50) NOT NULL DEFAULT '0|0',
1755
1756`Job` varchar(50) NOT NULL DEFAULT 'none',
1757
1758`Jobtime` double NOT NULL DEFAULT '0',
1759
1760`Club` varchar(50) NOT NULL DEFAULT 'none',
1761
1762`FavRadio` varchar(50) NOT NULL DEFAULT '0',
1763
1764`Bonuspunkte` int(11) NOT NULL DEFAULT '0',
1765
1766`Truckerskill` varchar(50) NOT NULL DEFAULT 'none',
1767
1768`AirportLevel` varchar(50) NOT NULL DEFAULT '1',
1769
1770`farmerLVL` int(10) NOT NULL DEFAULT '0',
1771
1772`bauarbeiterLVL` int(10) NOT NULL DEFAULT '0',
1773
1774`Contract` int(7) NOT NULL DEFAULT '0',
1775
1776`ArmyPermissions` varchar(50) NOT NULL DEFAULT '|0|0|0|0|0|0|0|0|0|',
1777
1778`SocialState` varchar(50) NOT NULL DEFAULT 'Ultimate',
1779
1780`fversicherung` int(11) NOT NULL DEFAULT '0',
1781
1782`LastFactionChange` varchar(50) NOT NULL DEFAULT '-',
1783
1784`StreetCleanPoints` int(11) NOT NULL DEFAULT '0',
1785
1786`Handy` varchar(50) NOT NULL DEFAULT '|1|0|',
1787
1788`Rausch` varchar(50) NOT NULL DEFAULT '0|0|0|',
1789
1790`Sucht` varchar(50) NOT NULL DEFAULT '0|0|0|',
1791
1792`pred` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Ob das Promt-Fenster gelesen wurde',
1793
1794`Buslevel` int(11) NOT NULL DEFAULT '0',
1795
1796`Coins` int(11) NOT NULL DEFAULT '0',
1797PRIMARY KEY (`UID`)
1798) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1799
1800
1801
1802
1803
1804CREATE TABLE IF NOT EXISTS `vehicles` (
1805
1806`UID` int(4) NOT NULL,
1807
1808`id` int(11) NOT NULL AUTO_INCREMENT,
1809
1810`Kofferraum` varchar(50) NOT NULL DEFAULT '0|0|0|0|',
1811
1812`Typ` int(11) NOT NULL,
1813
1814`Tuning` varchar(255) NOT NULL,
1815
1816`Spawnpos_X` varchar(50) NOT NULL,
1817
1818`Spawnpos_Y` varchar(50) NOT NULL,
1819
1820`Spawnpos_Z` varchar(50) NOT NULL,
1821
1822`Spawnrot_X` varchar(50) NOT NULL,
1823
1824`Spawnrot_Y` varchar(50) NOT NULL,
1825
1826`Spawnrot_Z` varchar(50) NOT NULL,
1827
1828`Farbe` varchar(50) NOT NULL,
1829
1830`Paintjob` varchar(50) NOT NULL DEFAULT '3',
1831
1832`Benzin` varchar(50) NOT NULL DEFAULT '100',
1833
1834`Slot` float NOT NULL,
1835
1836`Special` int(11) NOT NULL DEFAULT '0',
1837
1838`Lights` varchar(50) NOT NULL DEFAULT '|255|255|255|',
1839
1840`Distance` double NOT NULL DEFAULT '0',
1841
1842`STuning` varchar(50) NOT NULL DEFAULT '0|0|0|0|0|0|',
1843
1844`AuktionsID` int(10) NOT NULL DEFAULT '0',
1845
1846`GangVehicle` tinyint(1) NOT NULL DEFAULT '0',
1847
1848`rc` int(1) NOT NULL DEFAULT '0',
1849
1850`spezcolor` varchar(50) NOT NULL DEFAULT '|0|0|0|0|0|0|',
1851
1852`Sportmotor` int(1) NOT NULL DEFAULT '0',
1853
1854`Bremse` varchar(1) NOT NULL DEFAULT '0',
1855
1856`Antrieb` varchar(10) NOT NULL,
1857
1858`plate` varchar(50) NOT NULL DEFAULT 'BonusBaba',
1859PRIMARY KEY (`id`)
1860) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
1861
1862
1863
1864
1865CREATE TABLE IF NOT EXISTS `warns` (
1866
1867`UID` int(4) NOT NULL,
1868
1869`id` int(11) NOT NULL AUTO_INCREMENT,
1870
1871`adminUID` int(4) NOT NULL,
1872
1873`reason` text NOT NULL,
1874
1875`extends` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1876
1877`extends_o` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
1878
1879`date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
1880,
1881PRIMARY KEY (`id`)
1882) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
1883
1884
1885
1886
1887CREATE TABLE IF NOT EXISTS `weed` (
1888
1889`id` int(11) NOT NULL AUTO_INCREMENT,
1890
1891`x` int(20) NOT NULL,
1892
1893`y` int(20) NOT NULL,
1894
1895`z` int(20) NOT NULL,
1896
1897`time` int(50) NOT NULL,
1898
1899`UID` int(4) NOT NULL,
1900PRIMARY KEY (`id`)
1901) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
1902
1903