TEGNhHSp

1CREATE TABLE IF NOT EXISTS `accounts` (
2  `id` mediumint(6) NOT NULL AUTO_INCREMENT,
3  `Name` varchar(24) NOT NULL,
4  `Admin` smallint(1) NOT NULL,
5  `IP` varchar(16) NOT NULL,
6  `Auto` tinyint(1) NOT NULL,
7  `Serial` varchar(50) NOT NULL,
8  `Password` varchar(92) NOT NULL,
9  `LastSeen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
10  PRIMARY KEY (`id`)
11) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;
12
13--
14-- Dati tabulai `accounts`
15--
16
17INSERT INTO `accounts` (`id`, `Name`, `Admin`, `IP`, `Auto`, `Serial`, `Password`, `LastSeen`) VALUES
18(4, 'Jimmy_Lake', 0, '127.0.0.1', 0, '499940405980D9984CCC8E89E8D8CD4480484008', '76dde6e06585343e8b710dab00b0d72a56e60406', '0000-00-00 00:00:00'),
19(24, 'Tian_Otori', 0, '5.89.53.172', 0, '4FE554DE4D0E0D859CC8CCED4FD59CD4008848E9', '7c4a8d09ca3762af61e59520943dc26494f8941b', '2011-09-10 18:42:08');
20
21-- --------------------------------------------------------
22
23--
24-- Tabulas struktūra tabulai `business`
25--
26
27CREATE TABLE IF NOT EXISTS `business` (
28  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
29  `owner` mediumint(9) NOT NULL,
30  `baseprice` mediumint(9) NOT NULL,
31  `name` varchar(48) NOT NULL,
32  `X` float NOT NULL,
33  `Y` float NOT NULL,
34  `Z` float NOT NULL,
35  `Bank` int(11) NOT NULL,
36  `interior` smallint(6) NOT NULL,
37  `description` varchar(90) NOT NULL DEFAULT 'none',
38  `Door` tinyint(4) NOT NULL,
39  PRIMARY KEY (`id`)
40) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=17 ;
41
42--
43-- Dati tabulai `business`
44--
45
46INSERT INTO `business` (`id`, `owner`, `baseprice`, `name`, `X`, `Y`, `Z`, `Bank`, `interior`, `description`, `Door`) VALUES
47(15, 0, 10, 'jaja', -96.8594, -1127.35, 1.08594, 0, 3, 'haha', 0),
48(16, 4, 1000, 'haha', 2386.89, -2013.73, 13.5537, 0, 65, 'haha', 0);
49
50-- --------------------------------------------------------
51
52--
53-- Tabulas struktūra tabulai `business_products`
54--
55
56CREATE TABLE IF NOT EXISTS `business_products` (
57  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
58  `price` mediumint(9) NOT NULL,
59  `pid` mediumint(9) NOT NULL,
60  `name` varchar(48) NOT NULL,
61  `value` mediumint(9) NOT NULL,
62  `extravalue` mediumint(9) NOT NULL,
63  `weight` float NOT NULL,
64  `business` int(11) NOT NULL,
65  PRIMARY KEY (`id`)
66) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;
67
68--
69-- Dati tabulai `business_products`
70--
71
72
73-- --------------------------------------------------------
74
75--
76-- Tabulas struktūra tabulai `cellphone_numbers`
77--
78
79CREATE TABLE IF NOT EXISTS `cellphone_numbers` (
80  `number` mediumint(9) NOT NULL AUTO_INCREMENT,
81  `id` mediumint(9) NOT NULL,
82  PRIMARY KEY (`number`)
83) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5166 ;
84
85--
86-- Dati tabulai `cellphone_numbers`
87--
88
89INSERT INTO `cellphone_numbers` (`number`, `id`) VALUES
90(5000, 4),
91(5001, 4),
92(5002, 4),
93(5003, 4),
94(5004, 4),
95(5005, 4),
96(5006, 4),
97(5007, 4),
98(5008, 4),
99(5009, 4),
100(5010, 4),
101(5011, 4),
102(5012, 4),
103(5013, 4),
104(5014, 4),
105(5015, 4),
106(5016, 4),
107(5017, 4),
108(5018, 4),
109(5019, 4),
110(5020, 4),
111(5021, 4),
112(5022, 4),
113(5023, 4),
114(5024, 4),
115(5025, 4),
116(5026, 4),
117(5027, 4),
118(5028, 4),
119(5029, 4),
120(5030, 4),
121(5031, 4),
122(5032, 4),
123(5033, 4),
124(5034, 4),
125(5035, 4),
126(5036, 4),
127(5037, 4),
128(5038, 4),
129(5039, 4),
130(5040, 4),
131(5041, 4),
132(5042, 4),
133(5043, 4),
134(5044, 4),
135(5045, 4),
136(5046, 4),
137(5047, 4),
138(5048, 4),
139(5049, 4),
140(5050, 4),
141(5051, 4),
142(5052, 4),
143(5053, 4),
144(5054, 4),
145(5055, 4),
146(5056, 4),
147(5057, 4),
148(5058, 4),
149(5059, 4),
150(5060, 4),
151(5061, 4),
152(5062, 4),
153(5063, 4),
154(5064, 4),
155(5065, 4),
156(5066, 4),
157(5067, 4),
158(5068, 4),
159(5069, 4),
160(5070, 4),
161(5071, 4),
162(5072, 4),
163(5073, 4),
164(5074, 4),
165(5075, 4),
166(5076, 4),
167(5077, 4),
168(5078, 4),
169(5079, 4),
170(5080, 4),
171(5081, 4),
172(5082, 4),
173(5083, 4),
174(5084, 4),
175(5085, 4),
176(5086, 4),
177(5087, 4),
178(5088, 4),
179(5089, 4),
180(5090, 4),
181(5091, 4),
182(5092, 4),
183(5093, 4),
184(5094, 4),
185(5095, 4),
186(5096, 4),
187(5097, 4),
188(5098, 4),
189(5099, 4),
190(5100, 4),
191(5101, 4),
192(5102, 4),
193(5103, 4),
194(5104, 4),
195(5105, 4),
196(5106, 4),
197(5107, 4),
198(5108, 4),
199(5109, 4),
200(5110, 4),
201(5111, 4),
202(5112, 4),
203(5113, 4),
204(5114, 4),
205(5115, 4),
206(5116, 4),
207(5117, 4),
208(5118, 4),
209(5119, 4),
210(5120, 4),
211(5121, 4),
212(5122, 4),
213(5123, 4),
214(5124, 4),
215(5125, 4),
216(5126, 4),
217(5127, 4),
218(5128, 4),
219(5129, 4),
220(5130, 4),
221(5131, 4),
222(5132, 4),
223(5133, 4),
224(5134, 4),
225(5135, 4),
226(5136, 4),
227(5137, 4),
228(5138, 4),
229(5139, 4),
230(5140, 4),
231(5141, 4),
232(5142, 4),
233(5143, 4),
234(5144, 4),
235(5145, 4),
236(5146, 4),
237(5147, 4),
238(5148, 4),
239(5149, 4),
240(5150, 4),
241(5151, 4),
242(5152, 4),
243(5153, 4),
244(5154, 4),
245(5155, 4),
246(5156, 4),
247(5157, 20),
248(5158, 19),
249(5159, 4),
250(5160, 4),
251(5161, 4),
252(5162, 4),
253(5163, 4),
254(5164, 4),
255(5165, 4);
256
257-- --------------------------------------------------------
258
259--
260-- Tabulas struktūra tabulai `characters`
261--
262
263CREATE TABLE IF NOT EXISTS `characters` (
264  `id` mediumint(6) NOT NULL,
265  `X` float NOT NULL,
266  `Y` float NOT NULL,
267  `Z` float NOT NULL,
268  `A` float NOT NULL,
269  `Health` float NOT NULL DEFAULT '70',
270  `Armour` float NOT NULL DEFAULT '0',
271  `Money` mediumint(9) NOT NULL DEFAULT '500',
272  `Skin` mediumint(3) NOT NULL,
273  `location` tinyint(4) NOT NULL DEFAULT '0',
274  `kills` mediumint(9) NOT NULL DEFAULT '0',
275  `deaths` smallint(6) NOT NULL DEFAULT '0',
276  `house` mediumint(9) NOT NULL,
277  `interior` tinyint(4) NOT NULL,
278  `virtualworld` mediumint(9) NOT NULL,
279  `bank` int(11) NOT NULL,
280  `business` smallint(6) NOT NULL,
281  `faction` smallint(6) NOT NULL,
282  `factionrank` smallint(6) NOT NULL,
283  `factionsalary` mediumint(9) NOT NULL,
284  `Name` varchar(24) NOT NULL,
285  `LastSeen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
286  `addictlevel` smallint(3) NOT NULL,
287  `addictedfrom` tinyint(1) NOT NULL,
288  `addictstage` tinyint(4) NOT NULL,
289  `government` tinyint(4) NOT NULL,
290  `marijuana_skill` smallint(4) NOT NULL,
291  `job` tinyint(4) NOT NULL,
292  `playercontract` smallint(6) NOT NULL,
293  `playerpaycheck` mediumint(9) NOT NULL,
294  `playerpaychecktime` tinyint(2) NOT NULL,
295  `playerhoursonline` mediumint(9) NOT NULL,
296  `weapon_skill` mediumint(9) NOT NULL,
297  `fishing_skill` mediumint(9) NOT NULL,
298  `ArrestTime` mediumint(9) NOT NULL,
299  `vehicle` mediumint(9) NOT NULL,
300  `seat` smallint(6) NOT NULL,
301  `mechanic_skill` mediumint(9) NOT NULL,
302  `playerLanguage` tinyint(4) NOT NULL DEFAULT '1'
303) ENGINE=MyISAM DEFAULT CHARSET=utf8;
304
305--
306-- Dati tabulai `characters`
307--
308
309INSERT INTO `characters` (`id`, `X`, `Y`, `Z`, `A`, `Health`, `Armour`, `Money`, `Skin`, `location`, `kills`, `deaths`, `house`, `interior`, `virtualworld`, `bank`, `business`, `faction`, `factionrank`, `factionsalary`, `Name`, `LastSeen`, `addictlevel`, `addictedfrom`, `addictstage`, `government`, `marijuana_skill`, `job`, `playercontract`, `playerpaycheck`, `playerpaychecktime`, `playerhoursonline`, `weapon_skill`, `fishing_skill`, `ArrestTime`, `vehicle`, `seat`, `mechanic_skill`, `playerLanguage`) VALUES
310(4, 304.602, -1859.36, 3.07148, 291.804, 100, 0, 4165, 59, 1, 1, 21, 0, 0, 0, 112, 0, 1, 1, 0, 'Jimmy Lake', '2011-09-10 18:54:15', 0, 0, 1, 0, 0, 6, 99, 0, 37, 3, 0, 0, 0, 0, -1, 0, 0),
311(21, 261.242, -1881.18, 1.66563, 138.514, 90, 0, 27, 1, 1, 0, 4, 0, 0, 0, 0, 0, 1, 3, 0, 'Tian_Otori', '2011-09-03 13:35:29', 5597, 0, 1, 0, 0, 0, 108, 0, 47, 1, 0, 0, 0, 0, 0, 0, 0),
312(22, 0, 0, 0, 0, 70, 0, 500, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Janis_Rapapovs', '2011-07-19 11:40:22', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
313(23, 1299.33, -1847.05, 14.7088, 7.22165, 60, 0, 90000, 2, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Saw_Saw', '2011-07-26 11:54:02', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
314(24, 254.341, -1839.96, 3.4727, 213.158, 81, 0, 500, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Tian_Otori', '2011-09-10 19:16:06', 0, 0, 0, 0, 0, 0, 4, 0, 4, 0, 0, 0, 0, 0, -1, 0, 1);
315
316-- --------------------------------------------------------
317
318--
319-- Tabulas struktūra tabulai `contacts`
320--
321
322CREATE TABLE IF NOT EXISTS `contacts` (
323  `sqlid` int(11) NOT NULL AUTO_INCREMENT,
324  `phone` mediumint(9) NOT NULL,
325  `contact` varchar(128) NOT NULL,
326  `myphone` int(11) NOT NULL,
327  PRIMARY KEY (`sqlid`)
328) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
329
330--
331-- Dati tabulai `contacts`
332--
333
334INSERT INTO `contacts` (`sqlid`, `phone`, `contact`, `myphone`) VALUES
335(5, 5111, 'Jimmy Lake', 5161);
336
337-- --------------------------------------------------------
338
339--
340-- Tabulas struktūra tabulai `dealerships`
341--
342
343CREATE TABLE IF NOT EXISTS `dealerships` (
344  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
345  `owner` mediumint(9) NOT NULL,
346  `price` int(11) NOT NULL,
347  `name` varchar(48) NOT NULL,
348  `X` float NOT NULL,
349  `Y` float NOT NULL,
350  `Z` float NOT NULL,
351  `AreaX` float NOT NULL,
352  `AreaY` float NOT NULL,
353  `AreaX2` float NOT NULL,
354  `AreaY2` float NOT NULL,
355  `bank` int(11) NOT NULL,
356  `storage` mediumint(9) NOT NULL,
357  PRIMARY KEY (`id`)
358) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=18 ;
359
360--
361-- Dati tabulai `dealerships`
362--
363
364INSERT INTO `dealerships` (`id`, `owner`, `price`, `name`, `X`, `Y`, `Z`, `AreaX`, `AreaY`, `AreaX2`, `AreaY2`, `bank`, `storage`) VALUES
365(9, 0, 5, 'Jimmys Auto''s', 2420.89, -1220.12, 25.5073, 0, 0, 0, 0, 0, 0),
366(8, 0, 10, 'Adam''s greatest autos', 2808.09, -1324.47, 33.7587, 0, 0, 0, 0, 0, 0),
367(7, 0, 10, 'Jim''s autos', 1286.5, -1329.12, 13.5535, 0, 0, 0, 0, 0, 0),
368(10, 0, 1000, 'Wang cars', -1967.63, 294.03, 35.1719, 2153.1, -1104.49, 2138.86, -1125.23, 0, 0),
369(11, 0, 1000, 'Dustin''s vehicles', -1859.56, -580.004, 22.607, 2137.53, -1113.64, 2140.49, -1126.75, 0, 0),
370(12, 19, 100, 'Manss maðînu korpuss lol', 2131.79, -1151.32, 24.0605, 2114.65, -1160.25, 2138.85, -1125.43, 0, 0),
371(13, 0, 100, 'Jaaaaaaaaa piemmmmm', 1832.55, -1860.84, 13.3828, 0, 0, 0, 0, 0, 0),
372(14, 0, 10, 'Jojo manas masinas', 1704.3, -1716.57, 13.5171, 0, 0, 0, 0, 0, 0),
373(15, 4, 10000, 'Pieies pie taa', 2110.48, -1786.56, 13.5608, 2100.51, -1785.53, 2123.26, -1763.96, 0, 0),
374(16, 4, 0, 'masinas', 1295.79, -1877.23, 13.5525, 1289.1, -1876.44, 1304.36, -1863.45, 0, 0),
375(17, 4, 1, 'Jaja man', 1054.66, 2147.89, 10.8203, 1019.03, 2120.3, 1054.63, 2144.19, 0, 0);
376
377-- --------------------------------------------------------
378
379--
380-- Tabulas struktūra tabulai `dropped_items`
381--
382
383CREATE TABLE IF NOT EXISTS `dropped_items` (
384  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
385  `iid` smallint(6) NOT NULL,
386  `value` mediumint(9) NOT NULL,
387  `extravalue` mediumint(9) NOT NULL,
388  `Itemname` varchar(32) NOT NULL,
389  `weight` float NOT NULL,
390  `dModel` mediumint(9) NOT NULL,
391  `X` float NOT NULL,
392  `Y` float NOT NULL,
393  `Z` float NOT NULL,
394  `Pickup` mediumint(9) NOT NULL,
395  `Itemnoname` varchar(32) NOT NULL,
396  `VirtualWorld` smallint(6) NOT NULL,
397  PRIMARY KEY (`id`)
398) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=199 ;
399
400--
401-- Dati tabulai `dropped_items`
402--
403
404INSERT INTO `dropped_items` (`id`, `iid`, `value`, `extravalue`, `Itemname`, `weight`, `dModel`, `X`, `Y`, `Z`, `Pickup`, `Itemnoname`, `VirtualWorld`) VALUES
405(85, 6, 139, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 1307.73, -1839.84, 13.3828, 0, 'Transportlidzekla atslegas', 0),
406(84, 6, 141, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 1306.64, -1842.55, 13.5469, 0, 'Transportlidzekla atslegas', 0),
407(83, 6, 141, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 1306.64, -1842.55, 13.5469, 0, 'Transportlidzekla atslegas', 0),
408(82, 5, 15, 0, 'Degvielas tvertne', 0.5, 1650, 1306.42, -1844.72, 13.3828, 0, 'Degvielas tvertne', 0),
409(76, 5, 0, 0, 'Degvielas tvertne', 0.5, 1650, 1813.71, -1863.45, 13.5704, 0, 'Degvielas tvertne', 0),
410(69, 5, 0, 0, 'Degvielas tvertne', 0.5, 1650, 938.776, -11.3529, 1000.93, 0, 'Degvielas tvertne', 2),
411(68, 5, 0, 0, 'Degvielas tvertne', 0.5, 1650, 945.121, -12.6628, 1000.93, 0, 'Degvielas tvertne', 1),
412(86, 6, 139, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 1308.32, -1842.68, 13.3828, 0, 'Transportlidzekla atslegas', 0),
413(91, 5, 15, 0, 'Degvielas tvertne', 0.5, 1650, 1736.56, -1738.23, 13.5469, 0, 'Degvielas tvertne', 0),
414(90, 6, 137, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 1737.77, -1740.85, 13.5469, 0, 'Transportlidzekla atslegas', 0),
415(89, 6, 139, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 1739.53, -1743.62, 13.5492, 0, 'Transportlidzekla atslegas', 0),
416(92, 6, 137, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 1732.55, -1738.05, 13.5469, 0, 'Transportlidzekla atslegas', 0),
417(93, 6, 148, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 1490.91, -1725.23, 13.0655, 0, 'Transportlidzekla atslegas', 0),
418(94, 6, 154, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 418.124, -1723.43, 9.17847, 0, 'Transportlidzekla atslegas', 0),
419(95, 6, 146, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 417.073, -1723.35, 9.13732, 0, 'Transportlidzekla atslegas', 0),
420(96, 6, 151, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 417.073, -1723.35, 9.13732, 0, 'Transportlidzekla atslegas', 0),
421(97, 6, 150, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 417.073, -1723.35, 9.13732, 0, 'Transportlidzekla atslegas', 0),
422(98, 6, 153, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 417.073, -1723.35, 9.13732, 0, 'Transportlidzekla atslegas', 0),
423(99, 6, 149, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 417.073, -1723.35, 9.13732, 0, 'Transportlidzekla atslegas', 0),
424(100, 6, 147, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 417.073, -1723.35, 9.13732, 0, 'Transportlidzekla atslegas', 0),
425(101, 6, 157, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 1320.21, -976.503, 148.644, 0, 'Transportlidzekla atslegas', 0),
426(102, 6, 148, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 1317.86, -976.391, 148.644, 0, 'Transportlidzekla atslegas', 0),
427(103, 6, 148, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 1317.98, -974.403, 148.644, 0, 'Transportlidzekla atslegas', 0),
428(104, 6, 156, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 1319.14, -974.588, 148.644, 0, 'Transportlidzekla atslegas', 0),
429(105, 6, 156, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 1319.14, -974.588, 148.644, 0, 'Transportlidzekla atslegas', 0),
430(106, 6, 157, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 1319.14, -974.588, 148.644, 0, 'Transportlidzekla atslegas', 0),
431(107, 6, 186, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 1567.62, 962.626, 10.6797, 0, 'Transportlidzekla atslegas', 0),
432(108, 4, 1, 0, 'Marihuâna', 0, 1279, -1268.82, 2303.04, 132.534, 0, 'Marihuana', 0),
433(109, 4, 1, 0, 'Marihuâna', 0, 1279, -1268.82, 2303.04, 132.534, 0, 'Marihuana', 0),
434(110, 4, 1, 0, 'Marihuâna', 0, 1279, -1268.82, 2303.04, 132.534, 0, 'Marihuana', 0),
435(111, 4, 1, 0, 'Marihuâna', 0, 1279, -1262.23, 2299.29, 132.316, 0, 'Marihuana', 0),
436(112, 6, 188, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 132.735, -84.2472, 1.9894, 0, 'Transportlidzekla atslegas', 0),
437(142, 16, 0, 0, 'Lâpsta', 1, 337, -886.981, -1235.8, 267.864, 0, 'Lapsta', 0),
438(114, 6, 192, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 2761.98, -2438.78, 13.5089, 0, 'Transportlidzekla atslegas', 0),
439(115, 4, 2, 0, 'Marihuâna', 0, 1279, 2754.68, -2439.23, 13.6484, 0, 'Marihuana', 0),
440(116, 4, 3, 0, 'Marihuâna', 0, 1279, 2754.13, -2444.03, 13.6432, 0, 'Marihuana', 0),
441(117, 4, 4, 0, 'Marihuâna', 0, 1279, 2754.84, -2449.63, 13.6432, 0, 'Marihuana', 0),
442(118, 4, 2, 0, 'Marihuâna', 0, 1279, 2752.06, -2448.07, 13.6432, 0, 'Marihuana', 0),
443(119, 4, 3, 0, 'Marihuâna', 0, 1279, 2752.92, -2442.92, 13.6432, 0, 'Marihuana', 0),
444(120, 2, 2, 0, 'Zivis', 0, 330, 2760.02, -2436.97, 13.5164, 0, 'Zivis', 0),
445(121, 2, 1, 0, 'Zivis', 0, 330, 2757.34, -2434.73, 13.485, 0, 'Zivis', 0),
446(122, 2, 1, 0, 'Zivis', 0, 330, 2759.51, -2434.61, 13.5109, 0, 'Zivis', 0),
447(123, 2, 3, 0, 'Zivis', 0, 330, 2753.1, -2438.01, 13.6484, 0, 'Zivis', 0),
448(124, 2, 6, 0, 'Zivis', 0, 330, 2740.09, -2428.71, 13.6307, 0, 'Zivis', 0),
449(125, 2, 4, 0, 'Zivis', 0, 330, 2739.26, -2424.15, 13.6551, 0, 'Zivis', 0),
450(126, 2, 2, 0, 'Zivis', 0, 330, 2737.52, -2420.04, 13.6286, 0, 'Zivis', 0),
451(127, 2, 2, 0, 'Zivis', 0, 330, 2733.55, -2416.44, 13.6277, 0, 'Zivis', 0),
452(128, 2, 1, 0, 'Zivis', 0, 330, 2729.54, -2414.73, 13.6328, 0, 'Zivis', 0),
453(129, 2, 3, 0, 'Zivis', 0, 330, 2754.21, -2430.04, 13.6432, 0, 'Zivis', 0),
454(130, 2, 5, 0, 'Zivis', 0, 330, 2754.21, -2430.04, 13.6432, 0, 'Zivis', 0),
455(131, 2, 1, 0, 'Zivis', 0, 330, 2754.21, -2430.04, 13.6432, 0, 'Zivis', 0),
456(132, 2, 1, 0, 'Zivis', 0, 330, 2754.21, -2430.04, 13.6432, 0, 'Zivis', 0),
457(133, 2, 1, 0, 'Zivis', 0, 330, 2754.21, -2430.04, 13.6432, 0, 'Zivis', 0),
458(135, 8, 24, 0, 'Zivis', 0, 1600, 27.8284, -1920.75, 1.1757, 0, 'Zivis', 0),
459(136, 9, 4, 0, 'Transportl. vadîtâja apliecîba ', 0, 1581, 2377.82, -2007.91, 16.4266, 0, 'Transportl. vaditaja aplieciba ', 0),
460(147, 16, 0, 0, 'Lâpsta', 1, 337, 1614.8, -629.573, 70.613, 0, 'Lapsta', 0),
461(148, 6, 148, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 1857.13, -2813.77, 64.7587, 0, 'Transportlidzekla atslegas', 0),
462(145, 16, 0, 0, 'Lâpsta', 1, 337, 1539.49, -1676.04, 14.9194, 0, 'Lapsta', 0),
463(149, 13, 22, 0, 'Colt 45 materiâli', 0, 3052, 203.704, -101.998, 1005.26, 0, 'Colt 45 materiali', 0),
464(150, 18, 56, 0, 'Apìçrbs', 0, 266, 209.419, -103.833, 1005.26, 0, 'Apgerbs', 0),
465(198, 20, 0, 0, 'Vodka', 1, 1543, 2227.13, -2414.76, 13.5469, 0, 'Vodka', 0),
466(194, 4, 1, 0, 'Marihuâna', 0, 1279, 2403.22, -2009.19, 13.5537, 0, 'Marihuana', 0),
467(196, 13, 22, 0, 'Colt 45 materiâli', 0, 3052, 2392.54, -2011.3, 13.5537, 0, 'Colt 45 materiali', 0),
468(189, 6, 148, 0, 'Transportlîdzekïa atslçgas', 0, 1279, 1943.24, -1783.86, 13.3906, 0, 'Transportlidzekla atslegas', 0),
469(157, 13, 22, 0, 'Colt 45 materiâli', 0, 3052, 2251.25, -1660.68, 15.2825, 0, 'Colt 45 materiali', 0),
470(177, 16, 0, 0, 'Lâpsta', 1, 337, 2251.96, -1653.82, 15.2372, 0, 'Lapsta', 0),
471(159, 13, 22, 0, 'Colt 45 materiâli', 0, 3052, 2257.01, -1654.39, 15.1758, 0, 'Colt 45 materiali', 0),
472(160, 13, 22, 0, 'Colt 45 materiâli', 0, 3052, 2259.6, -1657.05, 15.2099, 0, 'Colt 45 materiali', 0),
473(161, 13, 22, 0, 'Colt 45 materiâli', 0, 3052, 2259.45, -1658.4, 15.2452, 0, 'Colt 45 materiali', 0),
474(163, 13, 22, 0, 'Colt 45 materiâli', 0, 3052, 2258.31, -1660.73, 15.2711, 0, 'Colt 45 materiali', 0),
475(164, 13, 22, 0, 'Colt 45 materiâli', 0, 3052, 2257.28, -1661.49, 15.2776, 0, 'Colt 45 materiali', 0),
476(165, 13, 22, 0, 'Colt 45 materiâli', 0, 3052, 2253.53, -1664.26, 15.469, 0, 'Colt 45 materiali', 0),
477(166, 13, 22, 0, 'Colt 45 materiâli', 0, 3052, 2252.78, -1664.17, 15.469, 0, 'Colt 45 materiali', 0),
478(167, 13, 22, 0, 'Colt 45 materiâli', 0, 3052, 2250.15, -1663.28, 15.469, 0, 'Colt 45 materiali', 0),
479(168, 13, 22, 0, 'Colt 45 materiâli', 0, 3052, 2248.75, -1662.73, 15.469, 0, 'Colt 45 materiali', 0),
480(169, 13, 22, 0, 'Colt 45 materiâli', 0, 3052, 2246.49, -1661.88, 15.469, 0, 'Colt 45 materiali', 0),
481(170, 13, 22, 0, 'Colt 45 materiâli', 0, 3052, 2244.11, -1660.86, 15.469, 0, 'Colt 45 materiali', 0),
482(171, 13, 22, 0, 'Colt 45 materiâli', 0, 3052, 2241.68, -1659.22, 15.2895, 0, 'Colt 45 materiali', 0),
483(172, 13, 22, 0, 'Colt 45 materiâli', 0, 3052, 2239.35, -1658.65, 15.2912, 0, 'Colt 45 materiali', 0),
484(173, 13, 22, 0, 'Colt 45 materiâli', 0, 3052, 2237.24, -1658.44, 15.2919, 0, 'Colt 45 materiali', 0),
485(174, 13, 22, 0, 'Colt 45 materiâli', 0, 3052, 2234.25, -1657.71, 15.2963, 0, 'Colt 45 materiali', 0),
486(176, 13, 22, 0, 'Colt 45 materiâli', 0, 3052, 2250.03, -1656.43, 15.2834, 0, 'Colt 45 materiali', 0),
487(178, 13, 22, 0, 'Colt 45 materiâli', 0, 3052, 2253.25, -1656.64, 15.281, 0, 'Colt 45 materiali', 0),
488(179, 13, 22, 0, 'Colt 45 materiâli', 0, 3052, 2253.96, -1658.97, 15.2805, 0, 'Colt 45 materiali', 0);
489
490-- --------------------------------------------------------
491
492--
493-- Tabulas struktūra tabulai `factions`
494--
495
496CREATE TABLE IF NOT EXISTS `factions` (
497  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
498  `name` varchar(90) NOT NULL,
499  `noname` varchar(90) NOT NULL,
500  `group` mediumint(9) DEFAULT NULL,
501  `bank` mediumint(9) NOT NULL,
502  PRIMARY KEY (`id`)
503) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
504
505--
506-- Dati tabulai `factions`
507--
508
509INSERT INTO `factions` (`id`, `name`, `noname`, `group`, `bank`) VALUES
510(1, 'Los Santos policija', 'Los santos policija', 2, 210);
511
512-- --------------------------------------------------------
513
514--
515-- Tabulas struktūra tabulai `faction_ranks`
516--
517
518CREATE TABLE IF NOT EXISTS `faction_ranks` (
519  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
520  `Name` varchar(90) NOT NULL,
521  `Noname` varchar(90) NOT NULL,
522  `Lead` int(11) NOT NULL,
523  `fid` smallint(4) NOT NULL,
524  PRIMARY KEY (`id`)
525) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;
526
527--
528-- Dati tabulai `faction_ranks`
529--
530
531INSERT INTO `faction_ranks` (`id`, `Name`, `Noname`, `Lead`, `fid`) VALUES
532(6, 'Ðeriffs', 'Seriffs', 1, 1),
533(7, 'Co Ðeriffs', 'Co Seriffs', 0, 1),
534(8, 'Kadets', 'Kadets', 0, 1);
535
536-- --------------------------------------------------------
537
538--
539-- Tabulas struktūra tabulai `factory_prices`
540--
541
542CREATE TABLE IF NOT EXISTS `factory_prices` (
543  `modelid` smallint(4) NOT NULL AUTO_INCREMENT COMMENT 'Transportlīdzekļa modelis kurš būs pieejams rūpnīcā.',
544  `tires` int(8) NOT NULL COMMENT 'cik riepas būs nepieciešamas.',
545  `windows` int(8) NOT NULL COMMENT 'cik kilogramu stikla būs nepieciešams.',
546  `metal` int(8) NOT NULL COMMENT 'cik kilogramu metālā būs nepieciešams.',
547  `price` int(11) NOT NULL COMMENT 'cena.',
548  PRIMARY KEY (`modelid`)
549) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=412 ;
550
551--
552-- Dati tabulai `factory_prices`
553--
554
555INSERT INTO `factory_prices` (`modelid`, `tires`, `windows`, `metal`, `price`) VALUES
556(411, 4, 3, 700, 50012);
557
558-- --------------------------------------------------------
559
560--
561-- Tabulas struktūra tabulai `factory_stock`
562--
563
564CREATE TABLE IF NOT EXISTS `factory_stock` (
565  `model` smallint(6) NOT NULL AUTO_INCREMENT,
566  `price` mediumint(9) NOT NULL,
567  `amount` smallint(6) NOT NULL DEFAULT '1',
568  PRIMARY KEY (`model`)
569) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=412 ;
570
571--
572-- Dati tabulai `factory_stock`
573--
574
575INSERT INTO `factory_stock` (`model`, `price`, `amount`) VALUES
576(411, 33, 148);
577
578-- --------------------------------------------------------
579
580--
581-- Tabulas struktūra tabulai `groups`
582--
583
584CREATE TABLE IF NOT EXISTS `groups` (
585  `id` smallint(6) NOT NULL AUTO_INCREMENT,
586  `name` varchar(24) NOT NULL,
587  PRIMARY KEY (`id`)
588) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;
589
590--
591-- Dati tabulai `groups`
592--
593
594INSERT INTO `groups` (`id`, `name`) VALUES
595(1, 'Lead Administrator'),
596(2, 'Policija');
597
598-- --------------------------------------------------------
599
600--
601-- Tabulas struktūra tabulai `group_permissions`
602--
603
604CREATE TABLE IF NOT EXISTS `group_permissions` (
605  `permissionid` smallint(4) NOT NULL,
606  `gid` smallint(4) NOT NULL
607) ENGINE=MyISAM DEFAULT CHARSET=utf8;
608
609--
610-- Dati tabulai `group_permissions`
611--
612
613INSERT INTO `group_permissions` (`permissionid`, `gid`) VALUES
614(7, 1),
615(6, 1),
616(5, 1),
617(3, 1),
618(4, 1),
619(2, 1),
620(1, 1),
621(8, 1),
622(9, 1),
623(10, 1),
624(11, 1),
625(12, 1),
626(13, 1),
627(14, 1),
628(15, 1),
629(16, 1),
630(17, 1),
631(18, 1),
632(19, 1),
633(29, 2),
634(30, 2),
635(31, 2),
636(34, 2),
637(35, 2),
638(33, 2);
639
640-- --------------------------------------------------------
641
642--
643-- Tabulas struktūra tabulai `houses`
644--
645
646CREATE TABLE IF NOT EXISTS `houses` (
647  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
648  `ownerid` mediumint(9) NOT NULL,
649  `baseprice` mediumint(9) NOT NULL,
650  `interior` tinyint(4) NOT NULL,
651  `rent` mediumint(9) NOT NULL,
652  `doors` tinyint(4) NOT NULL,
653  `x` float NOT NULL,
654  `y` float NOT NULL,
655  `z` float NOT NULL,
656  `Description` varchar(48) NOT NULL,
657  PRIMARY KEY (`id`)
658) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=29 ;
659
660--
661-- Dati tabulai `houses`
662--
663
664INSERT INTO `houses` (`id`, `ownerid`, `baseprice`, `interior`, `rent`, `doors`, `x`, `y`, `z`, `Description`) VALUES
665(28, 0, 1, 106, 0, 0, 1493.67, -1739.42, 13.5469, '1');
666
667-- --------------------------------------------------------
668
669--
670-- Tabulas struktūra tabulai `interiors`
671--
672
673CREATE TABLE IF NOT EXISTS `interiors` (
674  `id` int(11) NOT NULL AUTO_INCREMENT,
675  `universeid` int(11) NOT NULL,
676  `name` varchar(48) COLLATE latin1_general_ci NOT NULL,
677  `x` float NOT NULL,
678  `y` float NOT NULL,
679  `z` float NOT NULL,
680  PRIMARY KEY (`id`)
681) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=147 ;
682
683--
684-- Dati tabulai `interiors`
685--
686
687INSERT INTO `interiors` (`id`, `universeid`, `name`, `x`, `y`, `z`) VALUES
688(1, 5, 'LS GYM', 771.832, -4.1811, 1000.73),
689(2, 3, 'Brothel 1 Front Door', 940.852, -18.0859, 1000.93),
690(3, 3, 'Brothel 1 Back Door', 974.553, -8.6292, 1001.15),
691(4, 3, 'Brothel 2', 966.307, -53.1088, 1001.12),
692(5, 3, 'Purple NightClub', 1211.91, -26.9968, 1000.95),
693(6, 18, 'Warehouse with Columns', 1249.71, 7.33733, 1008.26),
694(7, 1, 'Warehouse without Columns', 1415.43, 3.5266, 1000.93),
695(8, 3, 'ArchAngels', 610.974, -120.372, 998),
696(9, 3, 'OJ Loc House oneroom', 516.945, -14.8167, 1001.57),
697(10, 17, 'Donut Shop', 377.18, -192.603, 1000.63),
698(11, 7, 'Ammunation', 315.802, -143.665, 999.602),
699(12, 2, 'Loco Low Tuner', 620.273, -71.6872, 997.992),
700(13, 7, 'LV Gym small', 773.752, -78.7292, 1000.66),
701(14, 7, 'Transfenders', 773.851, -76.7676, 1000.65),
702(15, 1, 'Simple Bedroom', 244.183, 305.004, 999.148),
703(16, 5, 'Sheriff''s Office', 322.109, 302.363, 999.148),
704(17, 2, 'PigPen', 1205.17, -12.687, 1000.92),
705(18, 2, 'Ryder''s House', 2467.77, -1698.24, 1013.51),
706(19, 10, 'Paintball Arena', -1132.79, 1057.7, 1346.41),
707(20, 2, 'Elegant Bedroom', 267.18, 304.994, 999.148),
708(21, 1, 'Horse betting two floors', -2158.89, 642.423, 1052.38),
709(22, 14, 'Dressing Room', 254.673, -41.7179, 1002.02),
710(23, 12, 'Small Casino in LV', 1132.86, -14.2766, 1000.68),
711(24, 5, 'Hotel Room', 2233.63, -1114.19, 1050.88),
712(25, 9, 'Small Luxury House', 1133.14, -15.8331, 1000.68),
713(26, 10, 'Average House', 1727.05, -1637.83, 20.2229),
714(27, 17, 'Sherman Dam', -944.24, 1886.15, 5.0051),
715(28, 1, 'Shamal', 1.5499, 23.6238, 1199.59),
716(29, 1, 'Welcome Pump', 681.62, -452.512, -25.6172),
717(30, 3, 'High Class House', 235.4, 1188.07, 1080.26),
718(31, 2, 'small 1 floor House', 1726.97, -1638.8, 20.2234),
719(32, 1, 'small 1floor House2', 223.002, 1287.84, 1082.14),
720(33, 5, 'High Class House2', 227.953, 1114.16, 1080.99),
721(34, 15, 'Middle Class House', 295.236, 1473.31, 1080.26),
722(35, 12, 'Low Class House', 446.544, 507.265, 1001.42),
723(36, 18, 'Lil'' Probe Inn', -228.333, 1401.31, 27.7656),
724(37, 2, 'High Class Int', 447.003, 1397.98, 1084.3),
725(38, 4, 'Small House', 261.03, 1286.52, 1080.26),
726(39, 4, 'Cafeteria', 459.394, -88.3425, 999.555),
727(40, 4, 'Two Story House', 309.467, 312.134, 1003.3),
728(41, 10, 'House Medium Class', 24.137, 1341.15, 1084.38),
729(42, 1, 'Meat Factory', 932.654, 2130.6, 1011.02),
730(43, 4, 'House Normal', 221.825, 1142.32, 1082.61),
731(44, 17, 'Large 24 7', -26.2003, -187.896, 1003.55),
732(45, 6, 'Kay''s Kinky House', 344.469, 304.938, 999.148),
733(46, 4, 'Decent Mansion', -262.427, 1456.62, 1084.37),
734(47, 5, 'House Average', 22.7083, 1403.99, 1084.43),
735(48, 5, 'Luxurious House', 140.368, 1367.88, 1083.86),
736(49, 3, 'Bike School interior', 1494.58, 1303.81, 1093.29),
737(50, 6, 'Luxurious House', 234.142, 1063.72, 1084.21),
738(51, 6, 'House Medium', -69.14, 1351.2, 1080.21),
739(52, 6, 'Bright House ', -68.7646, 1353.36, 1080.21),
740(53, 6, 'Fanny Batter''s Whore House', 745.087, 1437.52, 1102.7),
741(54, 8, 'Colonel Furhberger''s', 2807.61, -1172.75, 1025.57),
742(55, 1, 'Hotel Room Elegant', 2218.4, -1076.31, 1050.48),
743(56, 2, 'Hotel Room Elegant2', 2237.42, -1079.55, 1049.02),
744(57, 8, 'House', 2365.3, -1132.92, 1050.88),
745(58, 8, 'House Level2', -42.4104, 1407.23, 1084.43),
746(59, 9, 'House Level3', 83.0358, 1324.09, 1083.86),
747(60, 9, 'House Level3', 260.554, 1238.66, 1084.26),
748(61, 10, 'SF Police Department', 228.837, 114.606, 999.016),
749(62, 9, 'Cluckin'' Bell', 364.973, -10.3642, 1001.85),
750(63, 17, '24/7 1', -25.8734, -188.019, 1003.55),
751(64, 10, '24/7 2', 6.30856, -31.7581, 1003.55),
752(65, 18, '24/7 3', -31.0137, -92.0078, 1003.55),
753(66, 16, '24/7 4', -25.4657, -141.414, 1003.55),
754(67, 4, '24/7 5', -27.3123, -29.2776, 1003.55),
755(68, 6, '24/7 6', -27.2106, -58.1305, 1003.55),
756(69, 9, 'Andromada cargo hold', 315.856, 1024.5, 1949.8),
757(70, 18, 'Atrium', 1726.18, -1641, 20.23),
758(71, 2, 'Big Smoke''s Crack Palace', 2523.37, -1285.71, 1054.64),
759(72, 15, 'Bloodbowl Stadium', -1417.89, 932.44, 1041.53),
760(73, 3, 'Driving School', -2029.54, -119.625, 1035.17),
761(74, 15, 'Jefferson Motel', 2214.38, -1150.6, 1025.8),
762(75, 14, 'Kickstart Stadium', -1420.42, 1616.92, 1052.53),
763(76, 1, 'Vice Restaurant interior', -794.89, 489.9, 1376.2),
764(77, 3, 'Pleasures Dome/Jizzy''s', -2636.89, 1403.12, 906.461),
765(78, 10, 'SF Police Department', 246.564, 107.971, 1003.22),
766(79, 2, 'Court', 2522.79, -1301.89, 1048.29),
767(80, 4, 'House', -260.486, 1456.52, 1084.37),
768(81, 3, 'Planning Department', 390.769, 173.953, 1008.38),
769(82, 5, 'Madd Doggs Mansion', 1298.82, -797.013, 1084.01),
770(85, 3, 'CJ House', 2496.05, -1692.93, 1014.74),
771(83, 3, 'Bank', 833.638, 7.4303, 1004.18),
772(84, 5, 'Crack Den', 318.602, 1116.26, 1083.88),
773(86, 6, 'Zero RC and Electronics', -2240.78, 137.195, 1035.41),
774(87, 5, 'Record Studio', 1259.67, -804.204, 1084.02),
775(88, 6, 'Los Santos Police Dept', 246.788, 62.3298, 1003.64),
776(89, 3, 'Sex Shop', -100.26, -22.93, 1000.71),
777(90, 6, 'Los Santos Police Dept', -1391.65, -155.768, 1051.16),
778(91, 7, '8 Track Stadium', -1403.01, -250.45, 1043.53),
779(92, 0, 'Shooting Range', 299.945, -141.888, 1004.06),
780(93, 17, 'Club', 493.501, -24.9615, 1000.67),
781(94, 10, 'Burger Shot', 366.02, -73.347, 1001.5),
782(95, 11, 'Bar', 501.721, -67.5659, 998.758),
783(96, 3, 'LVPD', 288.472, 170.064, 1007.18),
784(99, 2, 'Old Venteras Strip Casino', 2236.69, -1078.95, 1047.02),
785(100, 1, 'WuZiMus', -2171.26, 645.157, 1057.59),
786(101, 3, 'Barber Shop', 418.46, -80.45, 1001.8),
787(102, 5, 'Pizza Stack', 372.556, -131.36, 1001.49),
788(103, 3, 'Tattoo Parlor', 201.22, -43.246, 1002.27),
789(104, 10, 'AC Tower', 419.89, 2537.11, 10),
790(105, 6, 'Cobra Gym', 773.88, -47.769, 1000.59),
791(107, 1, 'Caligulas Casino', 2233.93, 1711.8, 1011.63),
792(108, 12, 'Red Sands West Casino', 1133.88, -15.8326, 1000.68),
793(109, 10, 'Four Dragons Casino', 2016.11, 1017.15, 996.875),
794(110, 0, 'Real Bank', 2305.39, -16.2727, 26.7496);
795
796-- --------------------------------------------------------
797
798--
799-- Tabulas struktūra tabulai `mdc`
800--
801
802CREATE TABLE IF NOT EXISTS `mdc` (
803  `id` mediumint(9) NOT NULL,
804  `Name` varchar(24) NOT NULL,
805  `Commited_Crime` varchar(128) NOT NULL,
806  `Submited_By` varchar(24) NOT NULL,
807  `Date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
808  `Served` smallint(6) NOT NULL,
809  `crimID` mediumint(9) NOT NULL AUTO_INCREMENT,
810  PRIMARY KEY (`crimID`)
811) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
812
813--
814-- Dati tabulai `mdc`
815--
816
817INSERT INTO `mdc` (`id`, `Name`, `Commited_Crime`, `Submited_By`, `Date`, `Served`, `crimID`) VALUES
818(21, 'Tian_Otori', 'DSDGSFHSDFH', 'Jimmy Lake', '2011-08-18 03:49:27', 1, 12),
819(21, 'Tian_Otori', 'Jaaaaaaa', 'Jimmy Lake', '2011-08-18 03:49:27', 1, 11),
820(4, 'Jimmy Lake', 'JAJAJAJJAJA taaaaaaaaaaa', 'Jimmy Lake', '2011-08-18 03:51:00', 1, 10),
821(4, 'Jimmy Lake', 'WTF?!!??! KASGFASDGDAHD', 'Jimmy Lake', '2011-08-18 03:51:00', 1, 9),
822(4, 'Jimmy Lake', 'Wtff is this?', 'Jimmy Lake', '2011-08-18 03:51:00', 1, 8);
823
824-- --------------------------------------------------------
825
826--
827-- Tabulas struktūra tabulai `permissionslist`
828--
829
830CREATE TABLE IF NOT EXISTS `permissionslist` (
831  `Permission` varchar(24) NOT NULL,
832  `id` smallint(6) NOT NULL
833) ENGINE=MyISAM DEFAULT CHARSET=utf8;
834
835--
836-- Dati tabulai `permissionslist`
837--
838
839INSERT INTO `permissionslist` (`Permission`, `id`) VALUES
840('CREATEHOUSE', 1),
841('ADDPLAYERPERMISSION', 2),
842('MONEY', 3),
843('SETMONEY', 4),
844('CREATEGROUP', 5),
845('ADDGROUPPERMISSION', 6),
846('ADDPLAYERTOGROUP', 7),
847('SETPLAYERBANK', 8),
848('CREATEVEHICLE', 9),
849('CREATEDEALERSHIP', 10),
850('SETDEALERSHIPXY', 11),
851('SETDEALERSHIPXY2', 12),
852('CREATEPARKVEHICLE', 13),
853('SETWEATHER', 15),
854('SETWORLDTIME', 16),
855('SAVESERVER', 14),
856('GETHERE', 17),
857('GOTO', 18),
858('CREATEBUSINESS', 19),
859('DISABLEOOC', 20),
860('ENABLEOOC', 21),
861('CREATEFACTION', 22),
862('SETPLAYERFACTION', 23),
863('SETFACTIONGROUP', 24),
864('ADDFACTIONRANK', 25),
865('GETKEYS', 26),
866('SEYPLAYERPRESIDENT', 27),
867('SETPLAYERJOB', 28),
868('MDC', 29),
869('ARREST', 30),
870('CUFF', 31),
871('DETAIN', 32),
872('TICKET', 33),
873('FRISK', 34),
874('ADDPLAYERLANGUAGE', 35);
875
876-- --------------------------------------------------------
877
878--
879-- Tabulas struktūra tabulai `player_bans`
880--
881
882CREATE TABLE IF NOT EXISTS `player_bans` (
883  `IP` varchar(15) NOT NULL,
884  `day` smallint(3) NOT NULL,
885  `month` smallint(3) NOT NULL,
886  `year` smallint(5) NOT NULL,
887  `reason` text NOT NULL,
888  `bandate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
889  `playername` varchar(24) NOT NULL,
890  `By` varchar(24) NOT NULL
891) ENGINE=MyISAM DEFAULT CHARSET=latin1;
892
893--
894-- Dati tabulai `player_bans`
895--
896
897INSERT INTO `player_bans` (`IP`, `day`, `month`, `year`, `reason`, `bandate`, `playername`, `By`) VALUES
898('10.0.1.129', 27, 7, 2011, 'Money Hacks', '2011-06-27 08:03:48', 'Jimmy_Lake', 'Anticheat');
899
900-- --------------------------------------------------------
901
902--
903-- Tabulas struktūra tabulai `player_groups`
904--
905
906CREATE TABLE IF NOT EXISTS `player_groups` (
907  `id` int(11) NOT NULL,
908  `group` int(11) NOT NULL
909) ENGINE=MyISAM DEFAULT CHARSET=utf8;
910
911--
912-- Dati tabulai `player_groups`
913--
914
915INSERT INTO `player_groups` (`id`, `group`) VALUES
916(4, 1),
917(12, 1);
918
919-- --------------------------------------------------------
920
921--
922-- Tabulas struktūra tabulai `player_items`
923--
924
925CREATE TABLE IF NOT EXISTS `player_items` (
926  `id` mediumint(9) NOT NULL,
927  `itemid` smallint(11) NOT NULL,
928  `value` mediumint(11) NOT NULL,
929  `extravalue` mediumint(11) NOT NULL,
930  `Itemname` varchar(32) NOT NULL,
931  `weight` float NOT NULL,
932  `Itemnoname` varchar(32) NOT NULL,
933  `sqlid` int(11) NOT NULL AUTO_INCREMENT,
934  PRIMARY KEY (`sqlid`)
935) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=320 ;
936
937--
938-- Dati tabulai `player_items`
939--
940
941INSERT INTO `player_items` (`id`, `itemid`, `value`, `extravalue`, `Itemname`, `weight`, `Itemnoname`, `sqlid`) VALUES
942(4, 18, 59, 0, 'Apìçrbs', 0, 'Apgerbs', 309),
943(4, 17, 0, 0, 'Nazis', 1, 'Nazis', 310),
944(21, 1, 22, 0, 'Colt 45', 0, 'Colt 45', 316),
945(4, 1, 22, 0, 'Colt 45', 0, 'Colt 45', 317),
946(21, 24, 5, 0, 'Detaïas', 0, 'Detalas', 319),
947(21, 1, 22, 0, 'Colt 45', 0, 'Colt 45', 247),
948(4, 6, 254, 0, 'Transportlîdzekïa atslçgas', 0, 'Transportlidzekla atslegas', 311),
949(4, 6, 258, 0, 'Transportlîdzekïa atslçgas', 0, 'Transportlidzekla atslegas', 312),
950(21, 13, 22, 0, 'Colt 45 materiâli', 0, 'Colt 45 materiali', 253),
951(21, 8, 5, 0, 'Zivis', 0, 'Zivis', 225),
952(21, 16, 0, 0, 'Lâpsta', 1, 'Lapsta', 300),
953(21, 12, 4, 0, 'Vadîtâja apliecîba (D)', 0, 'Transportl. vaditaja aplieciba ', 293),
954(21, 18, 1, 0, 'Apìçrbs', 0, 'Apgerbs', 252),
955(4, 24, 15, 0, 'Detaïas', 0, 'Detalas', 318),
956(21, 23, 0, 0, 'Cigarete', 1, 'Cigarete', 308),
957(21, 2, 5164, 0, 'Mobilais telefons', 0.1, 'Mobilais telefons', 269),
958(21, 13, 22, 0, 'Colt 45 materiâli', 0, 'Colt 45 materiali', 263),
959(21, 13, 22, 0, 'Colt 45 materiâli', 0, 'Colt 45 materiali', 264),
960(21, 13, 22, 0, 'Colt 45 materiâli', 0, 'Colt 45 materiali', 265),
961(21, 13, 22, 0, 'Colt 45 materiâli', 0, 'Colt 45 materiali', 266),
962(4, 2, 5165, 0, 'Mobilais telefons', 0.1, 'Mobilais telefons', 267),
963(21, 5, 1, 0, 'Degvielas tvertne', 1.5, 'Degvielas tvertne', 282),
964(21, 18, 211, 0, 'Apìçrbs', 0, 'Apgerbs', 286),
965(4, 6, 149, 0, 'Transportlîdzekïa atslçgas', 0, 'Transportlidzekla atslegas', 289),
966(21, 16, 0, 0, 'Lâpsta', 1, 'Lapsta', 287),
967(21, 12, 4, 0, 'Vadîtâja apliecîba (D)', 0, 'Transportl. vaditaja aplieciba ', 283),
968(21, 1, 22, 0, 'Colt 45', 0, 'Colt 45', 284),
969(4, 6, 148, 0, 'Transportlîdzekïa atslçgas', 0, 'Transportlidzekla atslegas', 288),
970(21, 6, 150, 0, 'Transportlîdzekïa atslçgas', 0, 'Transportlidzekla atslegas', 290);
971
972-- --------------------------------------------------------
973
974--
975-- Tabulas struktūra tabulai `player_languages`
976--
977
978CREATE TABLE IF NOT EXISTS `player_languages` (
979  `lid` smallint(3) NOT NULL,
980  `id` smallint(8) NOT NULL,
981  `progress` smallint(6) NOT NULL
982) ENGINE=MyISAM DEFAULT CHARSET=utf8;
983
984--
985-- Dati tabulai `player_languages`
986--
987
988INSERT INTO `player_languages` (`lid`, `id`, `progress`) VALUES
989(1, 4, 100),
990(2, 4, 100),
991(3, 4, 100),
992(1, 24, 100),
993(2, 24, 100),
994(3, 24, 100),
995(8, 4, 100),
996(8, 24, 100),
997(5, 4, 100);
998
999-- --------------------------------------------------------
1000
1001--
1002-- Tabulas struktūra tabulai `player_permissions`
1003--
1004
1005CREATE TABLE IF NOT EXISTS `player_permissions` (
1006  `pid` smallint(6) NOT NULL,
1007  `id` smallint(6) NOT NULL
1008) ENGINE=MyISAM DEFAULT CHARSET=utf8;
1009
1010--
1011-- Dati tabulai `player_permissions`
1012--
1013
1014INSERT INTO `player_permissions` (`pid`, `id`) VALUES
1015(1, 4),
1016(2, 4),
1017(3, 4),
1018(4, 4),
1019(5, 4),
1020(6, 4),
1021(7, 4),
1022(8, 4),
1023(10, 4),
1024(9, 4),
1025(11, 4),
1026(12, 4),
1027(13, 4),
1028(15, 4),
1029(16, 4),
1030(19, 4),
1031(18, 4),
1032(1, 7),
1033(2, 7),
1034(3, 7),
1035(4, 7),
1036(22, 4),
1037(5, 10),
1038(18, 20);
1039
1040-- --------------------------------------------------------
1041
1042--
1043-- Tabulas struktūra tabulai `player_weapons`
1044--
1045
1046CREATE TABLE IF NOT EXISTS `player_weapons` (
1047  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
1048  `wep1` smallint(6) NOT NULL,
1049  `wep1_ammo` smallint(6) NOT NULL,
1050  `wep2` smallint(6) NOT NULL,
1051  `wep2_ammo` smallint(6) NOT NULL,
1052  `wep3` smallint(6) NOT NULL,
1053  `wep3_ammo` smallint(6) NOT NULL,
1054  `wep4` smallint(6) NOT NULL,
1055  `wep4_ammo` smallint(6) NOT NULL,
1056  `wep5` smallint(6) NOT NULL,
1057  `wep5_ammo` smallint(6) NOT NULL,
1058  `wep6` smallint(6) NOT NULL,
1059  `wep6_ammo` smallint(6) NOT NULL,
1060  `wep7` smallint(6) NOT NULL,
1061  `wep7_ammo` smallint(6) NOT NULL,
1062  `wep8` smallint(6) NOT NULL,
1063  `wep8_ammo` smallint(6) NOT NULL,
1064  `wep9` smallint(6) NOT NULL,
1065  `wep9_ammo` smallint(6) NOT NULL,
1066  `wep10` smallint(6) NOT NULL,
1067  `wep10_ammo` smallint(6) NOT NULL,
1068  `wep11` smallint(6) NOT NULL,
1069  `wep11_ammo` smallint(6) NOT NULL,
1070  `wep12` smallint(6) NOT NULL,
1071  `wep12_ammo` smallint(6) NOT NULL,
1072  `wep13` smallint(6) NOT NULL,
1073  `wep13_ammo` smallint(6) NOT NULL,
1074  PRIMARY KEY (`id`)
1075) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=25 ;
1076
1077--
1078-- Dati tabulai `player_weapons`
1079--
1080
1081INSERT INTO `player_weapons` (`id`, `wep1`, `wep1_ammo`, `wep2`, `wep2_ammo`, `wep3`, `wep3_ammo`, `wep4`, `wep4_ammo`, `wep5`, `wep5_ammo`, `wep6`, `wep6_ammo`, `wep7`, `wep7_ammo`, `wep8`, `wep8_ammo`, `wep9`, `wep9_ammo`, `wep10`, `wep10_ammo`, `wep11`, `wep11_ammo`, `wep12`, `wep12_ammo`, `wep13`, `wep13_ammo`) VALUES
1082(4, 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, 0),
1083(24, 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, 0);
1084
1085-- --------------------------------------------------------
1086
1087--
1088-- Tabulas struktūra tabulai `sms`
1089--
1090
1091CREATE TABLE IF NOT EXISTS `sms` (
1092  `phone` mediumint(9) NOT NULL,
1093  `sqlid` int(11) NOT NULL AUTO_INCREMENT,
1094  `sms` varchar(128) NOT NULL,
1095  PRIMARY KEY (`sqlid`)
1096) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
1097
1098--
1099-- Dati tabulai `sms`
1100--
1101
1102
1103-- --------------------------------------------------------
1104
1105--
1106-- Tabulas struktūra tabulai `vehicles`
1107--
1108
1109CREATE TABLE IF NOT EXISTS `vehicles` (
1110  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
1111  `modelid` smallint(6) NOT NULL,
1112  `X` float NOT NULL,
1113  `Y` float NOT NULL,
1114  `Z` float NOT NULL,
1115  `A` float NOT NULL,
1116  `Mod1` smallint(6) NOT NULL,
1117  `Mod2` smallint(6) NOT NULL,
1118  `Mod3` smallint(6) NOT NULL,
1119  `Mod4` smallint(6) NOT NULL,
1120  `Mod5` smallint(6) NOT NULL,
1121  `Mod6` smallint(6) NOT NULL,
1122  `Mod7` smallint(6) NOT NULL,
1123  `Mod8` smallint(6) NOT NULL,
1124  `Mod9` smallint(6) NOT NULL,
1125  `Mod10` smallint(6) NOT NULL,
1126  `Mod11` smallint(6) NOT NULL,
1127  `Mod12` smallint(6) NOT NULL,
1128  `Mod13` smallint(6) NOT NULL,
1129  `Mod14` smallint(6) NOT NULL,
1130  `Mod15` smallint(6) NOT NULL,
1131  `Mod16` smallint(6) NOT NULL,
1132  `Mod17` smallint(6) NOT NULL,
1133  `Health` float NOT NULL DEFAULT '1000',
1134  `owner` mediumint(9) NOT NULL,
1135  `job` smallint(6) NOT NULL,
1136  `linkedto` smallint(6) NOT NULL,
1137  `fuel` tinyint(4) NOT NULL DEFAULT '50',
1138  `lock` tinyint(4) NOT NULL,
1139  `color1` tinyint(4) NOT NULL,
1140  `color2` tinyint(4) NOT NULL,
1141  `price` mediumint(9) NOT NULL,
1142  `resources` smallint(6) NOT NULL,
1143  `IsSell` tinyint(1) NOT NULL,
1144  `IsPark` tinyint(1) NOT NULL,
1145  `Real_X` float NOT NULL,
1146  `Real_Y` float NOT NULL,
1147  `Real_Z` float NOT NULL,
1148  `Real_A` float NOT NULL,
1149  `Trunk` tinyint(1) NOT NULL,
1150  `engine` tinyint(1) NOT NULL,
1151  `lights` tinyint(1) NOT NULL,
1152  `bonnet` tinyint(1) NOT NULL,
1153  `plate` varchar(30) NOT NULL,
1154  PRIMARY KEY (`id`)
1155) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=264 ;
1156
1157--
1158-- Dati tabulai `vehicles`
1159--
1160
1161INSERT INTO `vehicles` (`id`, `modelid`, `X`, `Y`, `Z`, `A`, `Mod1`, `Mod2`, `Mod3`, `Mod4`, `Mod5`, `Mod6`, `Mod7`, `Mod8`, `Mod9`, `Mod10`, `Mod11`, `Mod12`, `Mod13`, `Mod14`, `Mod15`, `Mod16`, `Mod17`, `Health`, `owner`, `job`, `linkedto`, `fuel`, `lock`, `color1`, `color2`, `price`, `resources`, `IsSell`, `IsPark`, `Real_X`, `Real_Y`, `Real_Z`, `Real_A`, `Trunk`, `engine`, `lights`, `bonnet`, `plate`) VALUES
1162(259, 411, 2019.24, -1225.73, 21.8324, 100.746, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, -1, 0, 50, 0, 97, 67, 0, 0, 0, 0, 2019.24, -1225.73, 21.8324, 100.746, 0, 0, 0, 0, 'JSSTHD'),
1163(260, 411, 261.495, -1876.02, 2.0954, 72.558, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, -1, 0, 50, 0, 68, 80, 0, 0, 0, 0, 261.495, -1876.02, 2.0954, 72.558, 0, 0, 0, 0, 'PJVISD'),
1164(261, 411, 1892.55, -1857.9, 13.5739, 348.036, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, -1, 0, 50, 0, 75, 27, 0, 0, 0, 0, 1892.55, -1857.9, 13.5739, 348.036, 0, 0, 0, 0, 'CZO8OP'),
1165(262, 411, 2509.08, -2466.4, 13.6314, 219.975, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, -1, 0, 50, 0, 79, 48, 0, 0, 0, 0, 2509.08, -2466.4, 13.6314, 219.975, 0, 0, 0, 0, '59OALA'),
1166(263, 411, 1019.96, 457.743, 19.942, 158.909, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 0, -1, 0, 50, 0, 87, 69, 0, 0, 0, 0, 1019.96, 457.743, 19.942, 158.909, 0, 0, 0, 0, '2C2WFP'),
1167(258, 411, 1999.88, -1218.26, 20.0307, 315.115, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 315.002, 0, 0, 0, 50, 0, 59, 64, 0, 0, 0, 0, 2030.36, -1225.49, 21.9797, 119.897, 0, 0, 1, -1, 'JAHJVW');
1168
1169-- --------------------------------------------------------
1170
1171--
1172-- Tabulas struktūra tabulai `vehicle_trunk`
1173--
1174
1175CREATE TABLE IF NOT EXISTS `vehicle_trunk` (
1176  `trunk` mediumint(9) NOT NULL,
1177  `sqlid` mediumint(9) NOT NULL AUTO_INCREMENT,
1178  `id` mediumint(9) NOT NULL,
1179  `value` int(11) NOT NULL,
1180  `extravalue` int(11) NOT NULL,
1181  `Itemname` varchar(32) NOT NULL,
1182  `NoName` varchar(32) NOT NULL,
1183  PRIMARY KEY (`sqlid`)
1184) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;
1185
1186--
1187-- Dati tabulai `vehicle_trunk`
1188--
1189
1190INSERT INTO `vehicle_trunk` (`trunk`, `sqlid`, `id`, `value`, `extravalue`, `Itemname`, `NoName`) VALUES
1191(148, 3, 6, 152, 0, 'Transportlîdzekïa atslçgas', 'Transportlidzekla atslegas'),
1192(148, 4, 3, 3, 0, 'Marihuânas sçklas', 'Mari huanas seklas'),
1193(148, 5, 4, 2, 0, 'Marihuâna', 'Marihuana'),
1194(148, 6, 8, 5, 0, 'Zivis', 'Zivis');
1195
1196-- --------------------------------------------------------
1197
1198--
1199-- Tabulas struktūra tabulai `weed`
1200--
1201
1202CREATE TABLE IF NOT EXISTS `weed` (
1203  `id` mediumint(9) NOT NULL AUTO_INCREMENT,
1204  `planter` mediumint(9) NOT NULL,
1205  `X` float NOT NULL,
1206  `Y` float NOT NULL,
1207  `Z` float NOT NULL,
1208  `growth` int(11) NOT NULL,
1209  PRIMARY KEY (`id`)
1210) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=71 ;
1211
1212--
1213-- Dati tabulai `weed`
1214--
1215
1216INSERT INTO `weed` (`id`, `planter`, `X`, `Y`, `Z`, `growth`) VALUES
1217(54, 4, -519.807, -1535.74, 8.71255, 0),
1218(43, 21, -522.993, -1520.34, 9.84247, 0);