· 9 years ago · Apr 06, 2017, 01:26 PM
1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: 2017 m. Kov 05 d. 09:47
7-- Server version: 5.6.17
8-- PHP Version: 5.5.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `lsplay`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Sukurta duomenų struktūra lentelei `baudos`
27--
28
29CREATE TABLE IF NOT EXISTS `baudos` (
30 `bauda_ID` int(11) NOT NULL AUTO_INCREMENT,
31 `bauda_pID` int(11) NOT NULL,
32 `bauda_Money` int(9) NOT NULL,
33 `bauda_Reason` varchar(50) NOT NULL,
34 PRIMARY KEY (`bauda_ID`)
35) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
36
37-- --------------------------------------------------------
38
39--
40-- Sukurta duomenų struktūra lentelei `business`
41--
42
43CREATE TABLE IF NOT EXISTS `business` (
44 `bID` int(11) NOT NULL AUTO_INCREMENT,
45 `bOwnerID` int(11) NOT NULL,
46 `bName` varchar(50) NOT NULL,
47 `bPosX` float NOT NULL,
48 `bPosY` float NOT NULL,
49 `bPosZ` float NOT NULL,
50 `bcInterior` int(5) NOT NULL,
51 `bcPosX` float NOT NULL,
52 `bcPosY` float NOT NULL,
53 `bcPosZ` float NOT NULL,
54 `bkPosX` float NOT NULL,
55 `bkPosY` float NOT NULL,
56 `bkPosZ` float NOT NULL,
57 `bIsBuyable` int(1) NOT NULL,
58 `bPrice` int(11) NOT NULL,
59 `bType` int(1) NOT NULL,
60 `bExtra0` int(11) NOT NULL,
61 `bEarnings` int(11) NOT NULL,
62 PRIMARY KEY (`bID`)
63) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
64
65--
66-- Sukurta duomenų kopija lentelei `business`
67--
68
69INSERT INTO `business` (`bID`, `bOwnerID`, `bName`, `bPosX`, `bPosY`, `bPosZ`, `bcInterior`, `bcPosX`, `bcPosY`, `bcPosZ`, `bkPosX`, `bkPosY`, `bkPosZ`, `bIsBuyable`, `bPrice`, `bType`, `bExtra0`, `bEarnings`) VALUES
70(4, 19, 'Lukoil', 1930.31, -1785.81, 13.547, 0, 1930.21, -1779.51, 13.547, 1922.57, -1790.8, 13.383, 0, 1250000, 1, 15, 0),
71(5, -1, 'be pavadinimo', 1194.22, -917.189, 43.164, 0, 0, 0, 0, 0, 0, 0, 1, 2500000, 0, 0, 0),
72(6, 1, 'Baldyla', 1115.54, -1371.03, 13.991, 0, 0, 0, 0, 0, 0, 0, 1, 0, 3, 0, 0),
73(7, 53, 'Gintarinë vaistinë', 2249.86, 52.814, 26.667, 0, 2254.9, 45.893, 26.336, 2245.59, 49.435, 26.484, 0, 100000, 4, 0, 0);
74
75-- --------------------------------------------------------
76
77--
78-- Sukurta duomenų struktūra lentelei `gangs`
79--
80
81CREATE TABLE IF NOT EXISTS `gangs` (
82 `gangID` int(11) NOT NULL AUTO_INCREMENT,
83 `gangName` varchar(30) NOT NULL,
84 `gangLeadID` int(11) NOT NULL,
85 `gangRep` int(11) NOT NULL,
86 `gangColor` int(11) NOT NULL,
87 `gangX` float NOT NULL,
88 `gangY` float NOT NULL,
89 `gangZ` float NOT NULL,
90 PRIMARY KEY (`gangID`)
91) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
92
93--
94-- Sukurta duomenų kopija lentelei `gangs`
95--
96
97INSERT INTO `gangs` (`gangID`, `gangName`, `gangLeadID`, `gangRep`, `gangColor`, `gangX`, `gangY`, `gangZ`) VALUES
98(1, 'ðuo', 22, 15, 0, 2492.17, -1692.1, 14.7656),
99(2, 'Pakaraka', 14, 9000, 0, 1967.54, -1176.65, 20.0307);
100
101-- --------------------------------------------------------
102
103--
104-- Sukurta duomenų struktūra lentelei `garages`
105--
106
107CREATE TABLE IF NOT EXISTS `garages` (
108 `gID` int(11) NOT NULL AUTO_INCREMENT,
109 `gOwnerID` int(11) NOT NULL,
110 `gPrice` int(11) NOT NULL,
111 `gGalioja` int(11) NOT NULL,
112 `gBuyable` int(1) NOT NULL,
113 `gPosX` float NOT NULL,
114 `gPosY` float NOT NULL,
115 `gPosZ` float NOT NULL,
116 `gVartaiID` int(4) NOT NULL,
117 PRIMARY KEY (`gID`)
118) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
119
120-- --------------------------------------------------------
121
122--
123-- Sukurta duomenų struktūra lentelei `gps`
124--
125
126CREATE TABLE IF NOT EXISTS `gps` (
127 `gpsID` int(11) NOT NULL AUTO_INCREMENT,
128 `gpsName` varchar(40) NOT NULL,
129 `gpsX` float NOT NULL,
130 `gpsY` float NOT NULL,
131 `gpsZ` float NOT NULL,
132 `gpsType` int(2) NOT NULL,
133 `gpsMap` varchar(3) NOT NULL,
134 PRIMARY KEY (`gpsID`)
135) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;
136
137--
138-- Sukurta duomenų kopija lentelei `gps`
139--
140
141INSERT INTO `gps` (`gpsID`, `gpsName`, `gpsX`, `gpsY`, `gpsZ`, `gpsType`, `gpsMap`) VALUES
142(6, 'LS - Transporto turgus', 2267.85, -1974.65, 13.362, 2, 'ls'),
143(9, 'LS - Degalinë', 1941.88, -1759.77, 13.14, 2, 'ls'),
144(10, 'LS - Policija', 1530.44, -1675.22, 13.383, 0, 'ls'),
145(11, 'LS - Ligoninë', 1996, -1452.45, 13.325, 2, 'ls'),
146(12, 'LS - Bankas', 1722.14, -1292.76, 13.547, 2, 'ls'),
147(13, 'LS - Tune', 1040.53, -1032.42, 31.997, 2, 'ls'),
148(14, 'LS - Oro uostas', 1923.74, -2409.43, 13.197, 2, 'ls'),
149(15, 'SF - Tune (WAA)', -2690.47, 210.164, 4.328, 2, 'sf'),
150(16, 'LS - Fûristai', 2760.57, -2459.21, 13.56, 0, 'ls'),
151(17, 'LS - Taksi', 1814.12, -1871.19, 13.57, 0, 'ls'),
152(18, 'Atsiradimo vieta', 634.72, -1451.06, 14.183, 2, 'ls'),
153(19, 'LS - 2 Ligoninë', 1200.97, -1327.59, 13.398, 2, 'ls'),
154(20, 'LS - Autoservisas', 1667.19, -1826.79, 13.554, 0, 'ls'),
155(21, 'LS - Taksi', 2480.65, -1739.54, 13.547, 0, 'ls'),
156(22, 'Degalø gamykla', 2483.94, -2111.03, 13.5469, 5, 'ls'),
157(23, 'testinglel 2', 1820.66, -1308.36, 131.734, 2, 'ls'),
158(24, 'PC - Bankas', 2301.29, -6.81, 26.484, 2, 'km'),
159(25, 'VM', 681.914, -638.983, 16.188, 2, 'km'),
160(26, 'Dillimore degalinë', 699.959, -565.85, 16.329, 3, 'km');
161
162-- --------------------------------------------------------
163
164--
165-- Sukurta duomenų struktūra lentelei `gzones`
166--
167
168CREATE TABLE IF NOT EXISTS `gzones` (
169 `gID` int(2) NOT NULL AUTO_INCREMENT,
170 `gminX` float NOT NULL,
171 `gminY` float NOT NULL,
172 `gmaxX` float NOT NULL,
173 `gmaxY` float NOT NULL,
174 `gOwners` int(11) NOT NULL,
175 PRIMARY KEY (`gID`)
176) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
177
178-- --------------------------------------------------------
179
180--
181-- Sukurta duomenų struktūra lentelei `houses`
182--
183
184CREATE TABLE IF NOT EXISTS `houses` (
185 `hID` int(11) NOT NULL AUTO_INCREMENT,
186 `hOwnerID` int(11) NOT NULL,
187 `hLocked` int(1) NOT NULL,
188 `hInterior` int(11) NOT NULL,
189 `hIsBuyable` int(1) NOT NULL,
190 `hoPosX` float NOT NULL,
191 `hoPosY` float NOT NULL,
192 `hoPosZ` float NOT NULL,
193 `hiPosX` float NOT NULL,
194 `hiPosY` float NOT NULL,
195 `hiPosZ` float NOT NULL,
196 `hPrice` int(11) NOT NULL,
197 `hAlarm` int(2) NOT NULL,
198 `hCamera` int(2) NOT NULL,
199 `hDoors` int(2) NOT NULL,
200 `hIntUpgrade` int(11) NOT NULL,
201 `hSignalizacija` int(2) NOT NULL,
202 `hStreet` varchar(30) NOT NULL,
203 `hNumber` int(11) NOT NULL,
204 `hMap` varchar(3) NOT NULL,
205 PRIMARY KEY (`hID`)
206) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=132 ;
207
208--
209-- Sukurta duomenų kopija lentelei `houses`
210--
211
212INSERT INTO `houses` (`hID`, `hOwnerID`, `hLocked`, `hInterior`, `hIsBuyable`, `hoPosX`, `hoPosY`, `hoPosZ`, `hiPosX`, `hiPosY`, `hiPosZ`, `hPrice`, `hAlarm`, `hCamera`, `hDoors`, `hIntUpgrade`, `hSignalizacija`, `hStreet`, `hNumber`, `hMap`) VALUES
213(4, -1, 1, 0, 1, 2459.48, -1691.06, 13.545, 0, 0, 0, 564521, 0, 0, 0, 0, 0, 'Jotvingiø', 1, 'ls'),
214(5, -1, 1, 0, 1, 2514.17, -1691.61, 14.046, 0, 0, 0, 458642, 0, 0, 0, 0, 0, 'Jotvingiø', 2, 'ls'),
215(6, -1, 1, 0, 1, 2523.27, -1679.4, 15.497, 0, 0, 0, 581976, 0, 0, 0, 0, 0, 'Jotvingiø', 3, 'ls'),
216(7, -1, 1, 0, 1, 2524.71, -1658.75, 15.824, 0, 0, 0, 488514, 0, 0, 0, 0, 0, 'Jotvingiø', 4, 'ls'),
217(8, 15, 1, 0, 0, 2513.75, -1650.28, 14.356, 0, 0, 0, 487355, 0, 0, 0, 0, 0, 'Jotvingiø', 5, 'ls'),
218(9, -1, 1, 0, 1, 2498.45, -1642.64, 13.783, 0, 0, 0, 423165, 0, 0, 0, 0, 0, 'Jotvingiø', 6, 'ls'),
219(10, -1, 1, 0, 1, 2486.48, -1644.54, 14.077, 0, 0, 0, 581584, 0, 0, 0, 0, 0, 'Jotvingiø', 7, 'ls'),
220(11, -1, 1, 0, 1, 2469.54, -1646.35, 13.78, 0, 0, 0, 465497, 0, 0, 0, 0, 0, 'Jotvingiø', 8, 'ls'),
221(12, -1, 1, 0, 1, 2451.9, -1641.41, 14.066, 0, 0, 0, 456479, 0, 0, 0, 0, 0, 'Jotvingiø', 9, 'ls'),
222(13, -1, 1, 0, 1, 2413.84, -1646.79, 14.012, 0, 0, 0, 473345, 0, 0, 0, 0, 0, 'Jotvingiø', 10, 'ls'),
223(14, -1, 1, 0, 1, 2409.02, -1674.87, 14.375, 0, 0, 0, 473345, 0, 0, 0, 0, 0, 'Jotvingiø', 11, 'ls'),
224(15, -1, 1, 0, 1, 2384.64, -1675.84, 15.246, 0, 0, 0, 508269, 0, 0, 0, 0, 0, 'Jotvingiø', 13, 'ls'),
225(16, 15, 1, 0, 0, 2368.27, -1675.16, 14.168, 0, 0, 0, 532798, 0, 0, 0, 0, 0, 'Jotvingiø', 15, 'ls'),
226(17, -1, 1, 0, 1, 2393.32, -1646.04, 13.905, 0, 0, 0, 532798, 0, 0, 0, 0, 0, 'Jotvingiø', 12, 'ls'),
227(18, -1, 1, 0, 1, 2362.79, -1643.24, 14.352, 0, 0, 0, 467608, 0, 0, 0, 0, 0, 'Jotvingiø', 14, 'ls'),
228(19, -1, 1, 0, 1, 2327.08, -1681.87, 14.93, 0, 0, 0, 466106, 0, 0, 0, 0, 0, 'Jotvingiø', 16, 'ls'),
229(20, -1, 1, 0, 1, 2385.52, -1711.8, 14.242, 0, 0, 0, 545768, 0, 0, 0, 0, 0, 'Jotvingiø', 17, 'ls'),
230(21, -1, 1, 0, 1, 2522.46, -2018.92, 14.074, 0, 0, 0, 545768, 0, 0, 0, 0, 0, 'Laisvës', 1, 'ls'),
231(22, -1, 1, 0, 1, 2524.33, -1998.28, 14.113, 0, 0, 0, 466106, 0, 0, 0, 0, 0, 'Laisvës', 2, 'ls'),
232(23, -1, 1, 0, 1, 2507.79, -2021.05, 14.21, 0, 0, 0, 466106, 0, 0, 0, 0, 0, 'Laisvës', 3, 'ls'),
233(24, -1, 1, 0, 1, 2508.21, -1998.53, 13.903, 0, 0, 0, 504782, 0, 0, 0, 0, 0, 'Laisvës', 4, 'ls'),
234(25, -1, 1, 0, 1, 2486.45, -2021.55, 13.999, 0, 0, 0, 544660, 0, 0, 0, 0, 0, 'Laisvës', 5, 'ls'),
235(26, -1, 1, 0, 1, 2465.4, -2020.79, 14.124, 0, 0, 0, 464064, 0, 0, 0, 0, 0, 'Laisvës', 7, 'ls'),
236(27, -1, 1, 0, 1, 2437.92, -2020.84, 13.903, 0, 0, 0, 505413, 0, 0, 0, 0, 0, 'Laisvës', 9, 'ls'),
237(28, -1, 1, 0, 1, 2483.59, -1995.54, 13.834, 0, 0, 0, 540262, 0, 0, 0, 0, 0, 'Laisvës', 6, 'ls'),
238(29, 25, 1, 0, 0, 2465.02, -1995.75, 14.019, 0, 0, 0, 502568, 0, 0, 0, 0, 0, 'Laisvës', 8, 'ls'),
239(30, -1, 1, 0, 1, 2637.16, -1991.63, 14.324, 0, 0, 0, 466013, 0, 0, 0, 0, 0, 'Naujakuriø', 1, 'ls'),
240(31, -1, 1, 0, 1, 2635.51, -2012.77, 14.144, 0, 0, 0, 512437, 0, 0, 0, 0, 0, 'Naujakuriø', 2, 'ls'),
241(32, -1, 1, 0, 1, 2652.77, -1989.45, 13.999, 0, 0, 0, 519659, 0, 0, 0, 0, 0, 'Naujakuriø', 3, 'ls'),
242(33, -1, 1, 0, 1, 2672.8, -1989.47, 14.324, 0, 0, 0, 502551, 0, 0, 0, 0, 0, 'Naujakuriø', 5, 'ls'),
243(34, -1, 1, 0, 1, 2696.55, -1990.5, 14.223, 0, 0, 0, 497790, 0, 0, 0, 0, 0, 'Naujakuriø', 7, 'ls'),
244(35, -1, 1, 0, 1, 2650.7, -2021.92, 14.177, 0, 0, 0, 544213, 0, 0, 0, 0, 0, 'Naujakuriø', 4, 'ls'),
245(36, -1, 1, 0, 1, 2673.33, -2020.29, 14.168, 0, 0, 0, 504611, 0, 0, 0, 0, 0, 'Naujakuriø', 6, 'ls'),
246(37, -1, 1, 0, 1, 2695.41, -2020.55, 14.022, 0, 0, 0, 508801, 0, 0, 0, 0, 0, 'Naujakuriø', 8, 'ls'),
247(38, -1, 1, 0, 1, 315.949, -1769.61, 4.628, 0, 0, 0, 630541, 0, 0, 0, 0, 0, 'Uosto', 1, 'ls'),
248(39, -1, 1, 0, 1, 305.424, -1770.26, 4.538, 0, 0, 0, 684645, 0, 0, 0, 0, 0, 'Uosto', 2, 'ls'),
249(40, -1, 1, 0, 1, 295.241, -1764.12, 4.868, 0, 0, 0, 615744, 0, 0, 0, 0, 0, 'Uosto', 3, 'ls'),
250(41, -1, 1, 0, 1, 280.874, -1767.28, 4.551, 0, 0, 0, 676548, 0, 0, 0, 0, 0, 'Uosto', 4, 'ls'),
251(42, -1, 1, 0, 1, 206.794, -1768.9, 4.368, 0, 0, 0, 671021, 0, 0, 0, 0, 0, 'Uosto', 5, 'ls'),
252(43, -1, 1, 0, 1, 192.783, -1769.39, 4.329, 0, 0, 0, 675288, 0, 0, 0, 0, 0, 'Uosto', 6, 'ls'),
253(44, -1, 1, 0, 1, 168.306, -1768.41, 4.487, 0, 0, 0, 634214, 0, 0, 0, 0, 0, 'Uosto', 7, 'ls'),
254(45, -1, 1, 0, 1, 653.594, -1713.88, 14.765, 0, 0, 0, 542231, 0, 0, 0, 0, 0, 'Þvejø', 1, 'ls'),
255(46, -1, 1, 0, 1, 652.666, -1693.97, 14.55, 0, 0, 0, 487059, 0, 0, 0, 0, 0, 'Þvejø', 2, 'ls'),
256(47, -1, 1, 0, 1, 693.545, -1705.72, 3.819, 0, 0, 0, 486809, 0, 0, 0, 0, 0, 'Þvejø', 3, 'ls'),
257(48, -1, 1, 0, 1, 694.883, -1690.73, 4.346, 0, 0, 0, 455158, 0, 0, 0, 0, 0, 'Þvejø', 4, 'ls'),
258(49, -1, 1, 0, 1, 693.758, -1645.88, 4.094, 0, 0, 0, 539935, 0, 0, 0, 0, 0, 'Þvejø', 5, 'ls'),
259(50, -1, 1, 0, 1, 697.28, -1626.96, 3.749, 0, 0, 0, 487434, 0, 0, 0, 0, 0, 'Þvejø', 6, 'ls'),
260(51, -1, 1, 0, 1, 657.226, -1652.67, 15.406, 0, 0, 0, 508370, 0, 0, 0, 0, 0, 'Þvejø', 7, 'ls'),
261(52, -1, 1, 0, 1, 656.089, -1635.87, 15.862, 0, 0, 0, 500724, 0, 0, 0, 0, 0, 'Þvejø', 8, 'ls'),
262(53, -1, 1, 0, 1, 653.112, -1619.83, 15, 0, 0, 0, 495916, 0, 0, 0, 0, 0, 'Þvejø', 9, 'ls'),
263(54, -1, 1, 0, 1, 692.981, -1602.77, 15.047, 0, 0, 0, 483939, 0, 0, 0, 0, 0, 'Þvejø', 10, 'ls'),
264(55, -1, 1, 0, 1, 766.923, -1605.88, 13.804, 0, 0, 0, 469979, 0, 0, 0, 0, 0, 'Þvejø', 11, 'ls'),
265(56, -1, 1, 0, 1, 768.08, -1655.86, 5.609, 0, 0, 0, 538002, 0, 0, 0, 0, 0, 'Þvejø', 12, 'ls'),
266(57, -1, 1, 0, 1, 769.229, -1696.62, 5.155, 0, 0, 0, 536814, 0, 0, 0, 0, 0, 'Þvejø', 13, 'ls'),
267(58, -1, 1, 0, 1, 769.029, -1726.23, 13.432, 0, 0, 0, 472360, 0, 0, 0, 0, 0, 'Þvejø', 14, 'ls'),
268(59, -1, 1, 0, 1, 769.227, -1746.04, 13.077, 0, 0, 0, 483150, 0, 0, 0, 0, 0, 'Þvejø', 15, 'ls'),
269(60, -1, 1, 0, 1, 791.449, -1753.37, 13.457, 0, 0, 0, 509271, 0, 0, 0, 0, 0, 'Þvejø', 16, 'ls'),
270(61, -1, 1, 0, 1, 797.234, -1729.11, 13.547, 0, 0, 0, 538391, 0, 0, 0, 0, 0, 'Þvejø', 17, 'ls'),
271(62, -1, 1, 0, 1, 793.979, -1707.56, 14.038, 0, 0, 0, 527762, 0, 0, 0, 0, 0, 'Þvejø', 18, 'ls'),
272(63, -1, 1, 0, 1, 794.762, -1692.09, 14.463, 0, 0, 0, 460847, 0, 0, 0, 0, 0, 'Þvejø', 19, 'ls'),
273(64, -1, 1, 0, 1, 790.812, -1661.34, 13.484, 0, 0, 0, 482451, 0, 0, 0, 0, 0, 'Þvejø', 20, 'ls'),
274(65, -1, 1, 0, 1, 1421.83, -886.16, 50.684, 0, 0, 0, 1351603, 0, 0, 0, 0, 0, 'Mosëdþio', 1, 'ls'),
275(66, -1, 1, 0, 1, 1468.5, -906.166, 54.836, 0, 0, 0, 1126943, 0, 0, 0, 0, 0, 'Mosëdþio', 2, 'ls'),
276(67, -1, 1, 0, 1, 1535.86, -885.387, 57.657, 0, 0, 0, 1414994, 0, 0, 0, 0, 0, 'Mosëdþio', 3, 'ls'),
277(68, -1, 1, 0, 1, 1540.33, -851.367, 64.336, 0, 0, 0, 1210430, 0, 0, 0, 0, 0, 'Mosëdþio', 4, 'ls'),
278(69, -1, 1, 0, 1, 1535.04, -800.186, 72.849, 0, 0, 0, 1384614, 0, 0, 0, 0, 0, 'Mosëdþio', 5, 'ls'),
279(70, -1, 1, 0, 1, 1527.89, -772.65, 80.578, 0, 0, 0, 1431438, 0, 0, 0, 0, 0, 'Mosëdþio', 6, 'ls'),
280(71, -1, 1, 0, 1, 1298.45, -797.983, 84.141, 0, 0, 0, 1412326, 0, 0, 0, 0, 0, 'Mosëdþio', 7, 'ls'),
281(72, -1, 1, 0, 1, 1093.78, -806.866, 107.42, 0, 0, 0, 1031659, 0, 0, 0, 0, 0, 'Mosëdþio', 8, 'ls'),
282(73, -1, 1, 0, 1, 1034.9, -812.999, 101.852, 0, 0, 0, 1339354, 0, 0, 0, 0, 0, 'Mosëdþio', 9, 'ls'),
283(74, -1, 1, 0, 1, 1017.03, -763.359, 112.563, 0, 0, 0, 1012196, 0, 0, 0, 0, 0, 'Mosëdþio', 10, 'ls'),
284(75, -1, 1, 0, 1, 989.838, -828.637, 95.469, 0, 0, 0, 1087136, 0, 0, 0, 0, 0, 'Mosëdþio', 11, 'ls'),
285(76, -1, 1, 0, 1, 937.822, -848.476, 93.611, 0, 0, 0, 1355025, 0, 0, 0, 0, 0, 'Mosëdþio', 12, 'ls'),
286(77, -1, 1, 0, 1, 910.427, -817.522, 103.126, 0, 0, 0, 1026123, 0, 0, 0, 0, 0, 'Mosëdþio', 13, 'ls'),
287(78, -1, 1, 0, 1, 923.939, -853.232, 93.457, 0, 0, 0, 1088622, 0, 0, 0, 0, 0, 'Mosëdþio', 14, 'ls'),
288(79, -1, 1, 0, 1, 836.171, -894.791, 68.769, 0, 0, 0, 1206596, 0, 0, 0, 0, 0, 'Mosëdþio', 15, 'ls'),
289(80, -1, 1, 0, 1, 827.943, -857.943, 70.331, 0, 0, 0, 1124618, 0, 0, 0, 0, 0, 'Mosëdþio', 16, 'ls'),
290(81, -1, 1, 0, 1, 1442.66, -629.098, 95.719, 0, 0, 0, 1239413, 0, 0, 0, 0, 0, 'Eidintø', 1, 'ls'),
291(82, 14, 1, 0, 0, 1332.07, -633.317, 109.135, 0, 0, 0, 1057146, 0, 0, 0, 0, 0, 'Eidintø', 2, 'ls'),
292(83, -1, 1, 0, 1, 1095.09, -647.915, 113.648, 0, 0, 0, 1421163, 0, 0, 0, 0, 0, 'Eidintø', 3, 'ls'),
293(84, -1, 1, 0, 1, 1045.18, -642.936, 120.117, 0, 0, 0, 1003870, 0, 0, 0, 0, 0, 'Eidintø', 4, 'ls'),
294(85, -1, 1, 0, 1, 980.449, -677.28, 121.976, 0, 0, 0, 1323132, 0, 0, 0, 0, 0, 'Eidintø', 5, 'ls'),
295(86, -1, 1, 0, 1, 946.27, -710.719, 122.62, 0, 0, 0, 1397065, 0, 0, 0, 0, 0, 'Eidintø', 6, 'ls'),
296(87, -1, 1, 0, 1, 898.597, -676.528, 116.89, 0, 0, 0, 1298028, 0, 0, 0, 0, 0, 'Eidintø', 7, 'ls'),
297(88, -1, 1, 0, 1, 977.295, -771.709, 112.203, 0, 0, 0, 1230772, 0, 0, 0, 0, 0, 'Eidintø', 8, 'ls'),
298(89, -1, 1, 0, 1, 891.177, -783.16, 101.314, 0, 0, 0, 1475357, 0, 0, 0, 0, 0, 'Eidintø', 9, 'ls'),
299(90, -1, 1, 0, 1, 867.548, -717.605, 105.68, 0, 0, 0, 1335953, 0, 0, 0, 0, 0, 'Eidintø', 10, 'ls'),
300(91, -1, 1, 0, 1, 847.961, -745.474, 94.969, 0, 0, 0, 1338475, 0, 0, 0, 0, 0, 'Eidintø', 11, 'ls'),
301(92, -1, 1, 0, 1, 808.285, -759.464, 76.531, 0, 0, 0, 1044932, 0, 0, 0, 0, 0, 'Eidintø', 12, 'ls'),
302(93, -1, 1, 0, 1, 785.98, -828.58, 70.29, 0, 0, 0, 1028794, 0, 0, 0, 0, 0, 'Eidintø', 13, 'ls'),
303(94, -1, 1, 0, 1, 724.689, -999.371, 52.734, 0, 0, 0, 1258596, 0, 0, 0, 0, 0, 'Girios', 1, 'ls'),
304(95, -1, 1, 0, 1, 672.791, -1020.74, 55.76, 0, 0, 0, 1312005, 0, 0, 0, 0, 0, 'Girios', 2, 'ls'),
305(96, -1, 1, 0, 1, 700.25, -1060.34, 49.422, 0, 0, 0, 1192582, 0, 0, 0, 0, 0, 'Girios', 3, 'ls'),
306(97, -1, 1, 0, 1, 648.076, -1059, 52.58, 0, 0, 0, 1078935, 0, 0, 0, 0, 0, 'Girios', 4, 'ls'),
307(98, -1, 1, 0, 1, 646.026, -1117.38, 44.207, 0, 0, 0, 1380854, 0, 0, 0, 0, 0, 'Girios', 5, 'ls'),
308(99, -1, 1, 0, 1, 612.137, -1085.94, 58.827, 0, 0, 0, 1201493, 0, 0, 0, 0, 0, 'Girios', 6, 'ls'),
309(100, -1, 1, 0, 1, 553.032, -1200.25, 44.832, 0, 0, 0, 1317091, 0, 0, 0, 0, 0, 'Girios', 7, 'ls'),
310(101, -1, 1, 0, 1, 432.122, -1253.93, 51.581, 0, 0, 0, 1291030, 0, 0, 0, 0, 0, 'Girios', 8, 'ls'),
311(102, -1, 1, 0, 1, 397.983, -1271.45, 50.02, 0, 0, 0, 1072223, 0, 0, 0, 0, 0, 'Girios', 9, 'ls'),
312(103, -1, 1, 0, 1, 355.235, -1281.11, 53.704, 0, 0, 0, 1350877, 0, 0, 0, 0, 0, 'Girios', 10, 'ls'),
313(109, -1, 1, 0, 1, 298.629, -1338.41, 53.441, 0, 0, 0, 1161805, 0, 0, 0, 0, 0, 'Girios', 12, 'ls'),
314(110, -1, 1, 0, 1, 254.56, -1366.97, 53.109, 0, 0, 0, 1137254, 0, 0, 0, 0, 0, 'Girios', 13, 'ls'),
315(111, -1, 1, 0, 1, 227.969, -1405.44, 51.609, 0, 0, 0, 1251448, 0, 0, 0, 0, 0, 'Girios', 14, 'ls'),
316(112, -1, 1, 0, 1, 189.64, -1308.28, 70.249, 0, 0, 0, 1387716, 0, 0, 0, 0, 0, 'Girios', 15, 'ls'),
317(113, -1, 1, 0, 1, 580.637, -1149.7, 53.18, 0, 0, 0, 1137893, 0, 0, 0, 0, 0, 'Girios', 16, 'ls'),
318(114, -1, 1, 0, 1, 558.907, -1161.01, 54.43, 0, 0, 0, 1281940, 0, 0, 0, 0, 0, 'Girios', 18, 'ls'),
319(115, -1, 1, 0, 1, 534.966, -1173.74, 58.81, 0, 0, 0, 1298151, 0, 0, 0, 0, 0, 'Girios', 19, 'ls'),
320(116, -1, 1, 0, 1, 470.868, -1163.92, 67.215, 0, 0, 0, 1032119, 0, 0, 0, 0, 0, 'Girios', 17, 'ls'),
321(117, -1, 1, 0, 1, 416.775, -1154.13, 76.688, 0, 0, 0, 1007701, 0, 0, 0, 0, 0, 'Girios', 20, 'ls'),
322(118, -1, 1, 0, 1, 352.395, -1197.94, 76.516, 0, 0, 0, 1258835, 0, 0, 0, 0, 0, 'Girios', 21, 'ls'),
323(119, -1, 1, 0, 1, 300.234, -1154.45, 81.389, 0, 0, 0, 1018177, 0, 0, 0, 0, 0, 'Girios', 22, 'ls'),
324(120, -1, 1, 0, 1, 251.353, -1220.27, 76.102, 0, 0, 0, 1124568, 0, 0, 0, 0, 0, 'Girios', 23, 'ls'),
325(121, -1, 1, 0, 1, 253.247, -1269.97, 74.429, 0, 0, 0, 1446538, 0, 0, 0, 0, 0, 'Girios', 24, 'ls'),
326(122, -1, 1, 0, 1, 219.216, -1249.82, 78.337, 0, 0, 0, 1346442, 0, 0, 0, 0, 0, 'Girios', 25, 'ls'),
327(123, -1, 1, 0, 1, 161.608, -1455.74, 32.845, 0, 0, 0, 1177543, 0, 0, 0, 0, 0, 'Girios', 26, 'ls'),
328(124, -1, 1, 0, 1, 142.578, -1470.14, 25.211, 0, 0, 0, 1059774, 0, 0, 0, 0, 0, 'Girios', 27, 'ls'),
329(125, -1, 1, 0, 1, 1112.24, -742.078, 100.133, 0, 0, 0, 1354047, 0, 0, 0, 0, 0, 'Girios', 28, 'ls'),
330(126, -1, 1, 0, 1, 2326.78, -1716.71, 14.238, 0, 0, 0, 469557, 0, 0, 0, 0, 0, 'Jotvingiø', 18, 'ls'),
331(127, -1, 1, 0, 1, 2308.87, -1714.33, 14.98, 0, 0, 0, 502631, 0, 0, 0, 0, 0, 'Jotvingiø', 19, 'ls'),
332(128, -1, 1, 0, 1, 2306.94, -1679.07, 14.332, 0, 0, 0, 506341, 0, 0, 0, 0, 0, 'Jotvingiø', 20, 'ls'),
333(129, -1, 1, 0, 1, 2282.31, -1641.38, 15.89, 0, 0, 0, 464442, 0, 0, 0, 0, 0, 'Jotvingiø', 21, 'ls'),
334(130, -1, 1, 0, 1, 2257.27, -1643.97, 15.808, 0, 0, 0, 455940, 0, 0, 0, 0, 0, 'Jotvingiø', 22, 'ls'),
335(131, -1, 1, 0, 1, 2244.41, -1637.61, 16.238, 0, 0, 0, 460427, 0, 0, 0, 0, 0, 'Jotvingiø', 23, 'ls');
336
337-- --------------------------------------------------------
338
339--
340-- Sukurta duomenų struktūra lentelei `mapicons`
341--
342
343CREATE TABLE IF NOT EXISTS `mapicons` (
344 `mi_ID` int(11) NOT NULL AUTO_INCREMENT,
345 `mi_Name` varchar(30) NOT NULL,
346 `mi_PosX` float NOT NULL,
347 `mi_PosY` float NOT NULL,
348 `mi_PosZ` float NOT NULL,
349 `mi_Type` int(2) NOT NULL,
350 `mi_VW` int(11) NOT NULL,
351 `mi_Interior` int(11) NOT NULL,
352 `mi_Streamdistance` float NOT NULL,
353 `mi_Show` int(1) NOT NULL,
354 `mi_Map` varchar(3) NOT NULL,
355 PRIMARY KEY (`mi_ID`)
356) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;
357
358--
359-- Sukurta duomenų kopija lentelei `mapicons`
360--
361
362INSERT INTO `mapicons` (`mi_ID`, `mi_Name`, `mi_PosX`, `mi_PosY`, `mi_PosZ`, `mi_Type`, `mi_VW`, `mi_Interior`, `mi_Streamdistance`, `mi_Show`, `mi_Map`) VALUES
363(1, 'Bankas', 1734.84, -1266.76, 13.543, 52, 0, 0, 2000, 0, 'ls'),
364(2, 'Idlewood parduotuve', 2129.81, -1761.15, 13.5625, 38, 0, 0, 2000, 0, 'ls'),
365(3, 'Ganton parduotuve', 2423.66, -1742.44, 13.5469, 38, 0, 0, 2000, 0, 'ls'),
366(4, 'East Beach parduotuve', 2751.63, -1468.24, 30.4531, 38, 0, 0, 2000, 0, 'ls'),
367(5, 'Jefferson parduotuve', 2139.72, -1191.97, 23.9922, 38, 0, 0, 2000, 0, 'ls'),
368(6, 'Downtown parduotuve', 1582.35, -1170.37, 24.0781, 38, 0, 0, 2000, 0, 'ls'),
369(8, 'LSPD', 1531.41, -1674.8, 13.3828, 30, 0, 0, 2000, 0, 'ls'),
370(9, 'LSMD', 1995.36, -1452.89, 13.5547, 22, 0, 0, 2000, 0, 'ls'),
371(16, 'Tiuningas', 1024.63, -1033.07, 31.841, 27, 0, 0, 2000, 0, 'ls'),
372(18, 'Garažas1', 1189.95, -1013.27, 32.547, 55, 0, 0, 2000, 0, 'ls'),
373(19, 'Orouostas', 1923.74, -2409.43, 13.539, 5, 0, 0, 2000, 0, 'ls'),
374(20, 'Tune SF (WAA)', -2690.47, 210.164, 4.328, 27, 0, 0, 2000, 0, 'ls'),
375(21, 'MocoMisija', 1360.95, -1659.3, 14.766, 33, 0, 0, 2000, 1, 'ls'),
376(22, 'Vieðbutis', 1653.95, -1656.31, 22.516, 31, 0, 0, 2000, 1, 'ls'),
377(23, 'KM-Bankas', 2313.42, -6.787, 26.485, 52, 0, 0, 1000, 1, 'km'),
378(24, 'Daugiabuèiai1', 2440.75, 21.639, 26.459, 31, 0, 0, 1000, 1, 'km'),
379(25, 'Picerija', 1365.73, 250.772, 19.388, 29, 0, 0, 1000, 1, 'km'),
380(26, 'race', -490.514, -211.25, 79.497, 53, 0, 0, 1000, 1, 'km'),
381(27, 'picerija-bb', 212.533, -202.515, 1.578, 29, 0, 0, 1000, 1, 'km'),
382(28, 'dill_deg', 699.959, -565.85, 16.329, 24, 0, 0, 1000, 1, 'km'),
383(29, 'dill_deg2', 655.615, -564.964, 16.336, 24, 0, 0, 1000, 1, 'km'),
384(30, 'daugiabutis2', 2498.12, 76.107, 26.459, 31, 0, 0, 1000, 1, 'km'),
385(31, 'medprek', 2242.61, 52.725, 26.667, 21, 0, 0, 1000, 1, 'km');
386
387-- --------------------------------------------------------
388
389--
390-- Sukurta duomenų struktūra lentelei `objects`
391--
392
393CREATE TABLE IF NOT EXISTS `objects` (
394 `ID` int(11) NOT NULL AUTO_INCREMENT,
395 `Model` int(11) NOT NULL,
396 `X` float NOT NULL,
397 `Y` float NOT NULL,
398 `Z` float NOT NULL,
399 `rX` float NOT NULL,
400 `rY` float NOT NULL,
401 `rZ` float NOT NULL,
402 `Int` int(11) NOT NULL,
403 `vw` int(11) NOT NULL,
404 `e1` int(11) NOT NULL COMMENT 'none, vehicle, player etc',
405 `e2` int(11) NOT NULL COMMENT 'none, vehSQL, plrSQL, etc',
406 PRIMARY KEY (`ID`)
407) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
408
409-- --------------------------------------------------------
410
411--
412-- Sukurta duomenų struktūra lentelei `offmsg`
413--
414
415CREATE TABLE IF NOT EXISTS `offmsg` (
416 `ID` int(11) NOT NULL AUTO_INCREMENT,
417 `Type` int(1) NOT NULL,
418 `GiverID` int(6) NOT NULL,
419 `SenderID` int(6) NOT NULL,
420 `Msg` varchar(120) NOT NULL,
421 `Time` int(11) NOT NULL,
422 PRIMARY KEY (`ID`)
423) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
424
425-- --------------------------------------------------------
426
427--
428-- Sukurta duomenų struktūra lentelei `playeritems`
429--
430
431CREATE TABLE IF NOT EXISTS `playeritems` (
432 `i_ID` int(11) NOT NULL AUTO_INCREMENT,
433 `i_Type` int(1) NOT NULL,
434 `i_Owner` int(11) NOT NULL,
435 `i_ItemID` int(11) NOT NULL,
436 `i_Quantity` int(11) NOT NULL,
437 `i_Price` int(11) NOT NULL,
438 `i_Show` int(1) NOT NULL,
439 `i_Extra0` int(11) NOT NULL,
440 `i_Extra1` int(11) NOT NULL,
441 `i_Extra2` int(11) NOT NULL,
442 `i_Extra3` float NOT NULL,
443 `i_Extra4` int(1) NOT NULL,
444 `i_Weight` float NOT NULL,
445 PRIMARY KEY (`i_ID`)
446) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
447
448--
449-- Sukurta duomenų kopija lentelei `playeritems`
450--
451
452INSERT INTO `playeritems` (`i_ID`, `i_Type`, `i_Owner`, `i_ItemID`, `i_Quantity`, `i_Price`, `i_Show`, `i_Extra0`, `i_Extra1`, `i_Extra2`, `i_Extra3`, `i_Extra4`, `i_Weight`) VALUES
453(1, 1, 14, 4, 1, 0, 0, 11, 82, 0, 0, 0, 0),
454(2, 1, 15, 4, 1, 0, 0, 11, 16, 0, 0, 0, 0),
455(3, 3, 2, 6, 2383, 2, 1, 0, 0, 0, 0, 0, 0),
456(4, 3, 1, 2881, 2552, 3, 1, 0, 0, 0, 0, 0, 0),
457(5, 1, 15, 4, 1, 0, 0, 11, 8, 0, 0, 0, 0),
458(6, 1, 15, 7, 1, 0, 0, 0, 0, 0, 0, 1, 0),
459(7, 1, 14, 7, 1, 0, 0, 0, 0, 0, 0, 1, 0),
460(8, 1, 25, 4, 1, 0, 0, 11, 29, 0, 0, 0, 0),
461(9, 3, 3, 11738, 2322, 50, 1, 0, 0, 0, 0, 0, 0),
462(10, 3, 3, 11736, 2530, 15, 1, 0, 0, 0, 0, 0, 0),
463(11, 3, 3, 19570, 2159, 10, 1, 0, 0, 0, 0, 0, 0),
464(12, 6, 7, 11738, 50, 5, 0, 0, 0, 0, 0, 0, 0);
465
466-- --------------------------------------------------------
467
468--
469-- Sukurta duomenų struktūra lentelei `players`
470--
471
472CREATE TABLE IF NOT EXISTS `players` (
473 `pID` int(11) NOT NULL AUTO_INCREMENT,
474 `pName` varchar(24) NOT NULL,
475 `pPass` varchar(130) NOT NULL,
476 `pRegTime` int(20) NOT NULL,
477 `pRegIP` varchar(17) NOT NULL,
478 `pLastIP` varchar(17) NOT NULL,
479 `pLastTime` int(20) NOT NULL,
480 `vvpPass` varchar(150) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL,
481 `vvpActive` varchar(255) NOT NULL,
482 `pEmail` varchar(100) NOT NULL,
483 `pPosX` float NOT NULL,
484 `pPosY` float NOT NULL,
485 `pPosZ` float NOT NULL,
486 `pPosA` float NOT NULL,
487 `pDrabuziai` int(3) NOT NULL,
488 `pMoney` int(11) NOT NULL,
489 `pScore` int(11) NOT NULL,
490 `pAdmin` int(1) NOT NULL,
491 `pAod` int(1) NOT NULL,
492 `pVip` int(1) NOT NULL,
493 `pContract` int(11) NOT NULL,
494 `pJobSkin` int(3) NOT NULL,
495 `pGangID` int(2) NOT NULL,
496 `pGangSkin` int(1) NOT NULL,
497 `pGangSkinID` int(3) NOT NULL,
498 `pGangLead` int(11) NOT NULL,
499 `pJobID` int(2) NOT NULL,
500 `pJobSkinID` int(3) NOT NULL,
501 `pJobLead` int(2) NOT NULL,
502 `pJobDeputy` int(3) NOT NULL,
503 `pInterior` int(4) NOT NULL,
504 `pVW` int(11) NOT NULL,
505 `pBankoSaskaita` int(11) NOT NULL,
506 `pBMoney` int(11) NOT NULL,
507 `pRangas` int(2) NOT NULL,
508 `pGRangas` int(11) NOT NULL,
509 `pWanted` int(5) NOT NULL,
510 `pBauda` int(11) NOT NULL,
511 `pJailed` int(1) NOT NULL,
512 `pCuff` int(1) NOT NULL,
513 `pLevel` int(11) NOT NULL,
514 `pMask` int(1) NOT NULL,
515 `pOnline` int(1) NOT NULL,
516 `pGender` int(1) NOT NULL,
517 `pApmokymuStep` int(3) NOT NULL,
518 `pGuns` varchar(100) NOT NULL,
519 `pGunLic` int(1) NOT NULL,
520 `pCanLogin` int(11) NOT NULL,
521 `pCanLoginReason` varchar(50) NOT NULL,
522 `pCanLoginType` int(1) NOT NULL,
523 `pLastRaceTime` int(11) NOT NULL,
524 `pTimeSpent` int(11) NOT NULL,
525 `pAlga` int(11) NOT NULL,
526 `pMuted` int(11) NOT NULL,
527 `pDead` int(1) NOT NULL,
528 `pDviratis` int(1) NOT NULL,
529 `pDviratisX` float NOT NULL,
530 `pDviratisY` float NOT NULL,
531 `pDviratisZ` float NOT NULL,
532 `pSettings` varchar(20) NOT NULL,
533 `pLastTimeTakeGun` int(11) NOT NULL,
534 `pLastTimeEgun` int(11) NOT NULL,
535 `pNamuose` int(11) NOT NULL,
536 `pBankPin` int(4) NOT NULL,
537 PRIMARY KEY (`pID`)
538) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=55 ;
539
540--
541-- Sukurta duomenų kopija lentelei `players`
542--
543
544INSERT INTO `players` (`pID`, `pName`, `pPass`, `pRegTime`, `pRegIP`, `pLastIP`, `pLastTime`, `vvpPass`, `vvpActive`, `pEmail`, `pPosX`, `pPosY`, `pPosZ`, `pPosA`, `pDrabuziai`, `pMoney`, `pScore`, `pAdmin`, `pAod`, `pVip`, `pContract`, `pJobSkin`, `pGangID`, `pGangSkin`, `pGangSkinID`, `pGangLead`, `pJobID`, `pJobSkinID`, `pJobLead`, `pJobDeputy`, `pInterior`, `pVW`, `pBankoSaskaita`, `pBMoney`, `pRangas`, `pGRangas`, `pWanted`, `pBauda`, `pJailed`, `pCuff`, `pLevel`, `pMask`, `pOnline`, `pGender`, `pApmokymuStep`, `pGuns`, `pGunLic`, `pCanLogin`, `pCanLoginReason`, `pCanLoginType`, `pLastRaceTime`, `pTimeSpent`, `pAlga`, `pMuted`, `pDead`, `pDviratis`, `pDviratisX`, `pDviratisY`, `pDviratisZ`, `pSettings`, `pLastTimeTakeGun`, `pLastTimeEgun`, `pNamuose`, `pBankPin`) VALUES
545(14, 'Yawas', 'asdasd', 0, '', '', 1468668311, '', '', 'asd@asd.lt', 1955.51, -1205.35, 17.532, 125.277, 7, 50000, 200, 2, 0, 0, 1456331887, 0, 2, 0, 0, 2, 5, 0, 1, 0, 0, 0, 1, 3172, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, '0 0 0 0 24 50100 25 50000 32 5000050 30 10015 0 0 38 1849258976 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 1468571601, 42570, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 1234),
546(23, 'Aine_Sportt', '864225821', 1454771884, '78.63.21.18', '', 1454772144, '', '', 'ainorasp@gmail.com', 1489.91, -1765.49, 14.381, 311.428, 22, 10246, 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, 0, 0, 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', 0, 0, '', 0, 0, 227, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
547(25, 'John_Elite', '123456', 1468170631, '78.63.97.210', '', 1469045289, '', '', 'asdasd@gmail.com', -429.747, -1729.6, 2089.01, 349.93, 7, -20, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0, 69, 0, 1, 62804107, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, '21 1 0 0 24 101 25 101 32 5000000 0 0 34 1 0 0 0 0 0 0 15 1 0 0 0 0', 0, 0, '', 0, 0, 17157, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 1234),
548(29, 'John_Elites', '123456', 1468354011, '78.63.97.210', '', 1468355075, '', '', 'asdasdsd@gmail.com', 1342.38, -1622.78, 17.734, 356.428, 93, 1500, 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, 0, 1, 3, '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', 0, 0, '', 0, 0, 971, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
549(39, 'dovydas', 'asdasd', 1468408988, '127.0.0.1', '', 1468409436, '', '', '', 1276.93, -1544.35, 13.547, 338.271, 20, 10770, 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, 0, 0, 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', 0, 0, '', 0, 1468409060, 172, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
550(40, 'Test', 'asdasd', 1468409882, '127.0.0.1', '', 0, '', '', '', 1341.93, -1662.85, 17.7266, 0, 7, 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, 0, 0, 0, 3, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0),
551(41, 'Testasa', 'sadasd', 1468410725, '127.0.0.1', '', 1468410838, '', '', '', 1356.89, -1668.46, 13.608, 67.681, 22, 10000, 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, 0, 0, 3, '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', 0, 0, '', 0, 0, 19, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
552(42, 'Testasakiu', 'asdasd', 1468411270, '127.0.0.1', '', 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0),
553(43, 'askbsdkbd', 'asdasd', 1468411558, '127.0.0.1', '', 1468411594, '', '', '', 1341.84, -1681.88, 17.719, 180.458, 7, 10000, 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, 0, 0, 3, '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', 0, 0, '', 0, 0, 6, 0, 0, 0, 1, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
554(44, 'Sudas_Susas', '123456', 1468423951, '78.63.97.210', '', 0, '', '', 'asdasd@gmail.com', 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, 0, 0, 0, 0, 0, 0, 0, 0, 2, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0),
555(45, 'Pimpalasas', '123456', 1468424191, '78.63.97.210', '', 0, '', '', 'asdasd@gmail.com', 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, 0, 0, 0, 0, 0, 0, 0, 0, 2, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0),
556(46, 'tasdasd', 'asdasd', 1468424201, '127.0.0.1', '', 1468429663, '', '', '', 1348.98, -1681.7, 13.604, 341.139, 7, 0, 0, 2, 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, 3, '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', 0, 0, '', 0, 0, 2111, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
557(47, 'Tuduchas', '123456', 1468424581, '78.63.97.210', '', 1468425360, '', '', '', 1785.98, -1393.6, 15.758, 25.295, 7, 1493, 0, 2, 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, 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', 0, 0, '', 0, 1468424805, 683, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
558(48, 'TESTASDA', 'asdasd', 1468429802, '127.0.0.1', '', 1468432832, '', '', '', 1422.43, -1317.68, 13.555, 26.634, 7, 10000, 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, 0, 0, 3, '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', 0, 0, '', 0, 0, 1111, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
559(49, 'asdffghjkl', 'asdasd', 1468440517, '127.0.0.1', '', 1468440688, '', '', '', 1343.59, -1680.37, 13.585, 133.458, 20, 10000, 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, 0, 0, 3, '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', 0, 0, '', 0, 0, 153, 0, 0, 0, 1, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
560(50, 'Memius', '123456', 1468445361, '78.63.97.210', '', 1468445532, '', '', '', 1886.36, -1757.08, 13.179, 245.247, 7, 1500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, '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', 0, 0, '', 0, 0, 150, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
561(51, 'John_Juske', '147852', 1468587312, '86.38.226.143', '', 1468946360, '', '', '14725a@gmail.com', 639.024, -531.624, 15.915, 251.632, 7, 1500, 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, 0, 0, 3, '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', 0, 0, '', 0, 0, 5252, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
562(52, 'Pimpis', '123456', 1468592611, '78.63.97.210', '', 1468594003, '', '', '', -1036.42, -591.987, 32.2, 132.977, 20, 1500, 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, 0, 0, 3, '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', 0, 0, '', 0, 0, 1262, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
563(53, 'Yawukas', 'asdasd', 1468672971, '127.0.0.1', '', 1470558939, '', '', '', -427.408, -1727.97, 2244.36, 251.825, 22, 6380, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 69, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 3, '21 500000 6 500000 22 500000 25 500000 29 500000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 0, 35125, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
564(54, 'Andrew_Extazy', 'tavomama', 1468701418, '78.58.49.91', '', 1468703126, '', '', 'tavomama@tavomama.com', 1372.42, 287.818, 19.112, 81.078, 7, 1500, 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, 0, 0, 3, '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', 0, 0, '', 0, 0, 825, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0);
565
566-- --------------------------------------------------------
567
568--
569-- Sukurta duomenų struktūra lentelei `rangai`
570--
571
572CREATE TABLE IF NOT EXISTS `rangai` (
573 `rang_ID` int(5) NOT NULL AUTO_INCREMENT,
574 `rang_Name` varchar(50) NOT NULL,
575 `rang_IDinJob` int(5) NOT NULL,
576 `rang_JobID` int(5) NOT NULL,
577 `rang_SkinVID` int(3) NOT NULL,
578 `rang_SkinMID` int(3) NOT NULL,
579 PRIMARY KEY (`rang_ID`)
580) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
581
582--
583-- Sukurta duomenų kopija lentelei `rangai`
584--
585
586INSERT INTO `rangai` (`rang_ID`, `rang_Name`, `rang_IDinJob`, `rang_JobID`, `rang_SkinVID`, `rang_SkinMID`) VALUES
587(1, 'Abrikosai', 1, 2, 0, 0);
588
589-- --------------------------------------------------------
590
591--
592-- Sukurta duomenų struktūra lentelei `vehicles`
593--
594
595CREATE TABLE IF NOT EXISTS `vehicles` (
596 `vID` int(11) NOT NULL AUTO_INCREMENT,
597 `vOwnerType` int(1) NOT NULL,
598 `vOwnerID` int(11) NOT NULL,
599 `vModel` int(3) NOT NULL,
600 `vPosX` float NOT NULL,
601 `vPosY` float NOT NULL,
602 `vPosZ` float NOT NULL,
603 `vPosA` float NOT NULL,
604 `vHealth` float NOT NULL,
605 `vFuel` float NOT NULL,
606 `vFuelType` int(1) NOT NULL,
607 `vRida` float NOT NULL,
608 `vEngine` int(1) NOT NULL,
609 `vLights` int(1) NOT NULL,
610 `vAlarm` int(1) NOT NULL,
611 `vBonnet` int(1) NOT NULL,
612 `vBoot` int(1) NOT NULL,
613 `vObjective` int(1) NOT NULL,
614 `vLocked` int(1) NOT NULL,
615 `vColor1` int(3) NOT NULL,
616 `vColor2` int(3) NOT NULL,
617 `vPaintjob` int(1) NOT NULL,
618 `vMods` varchar(70) NOT NULL,
619 `vRangas` int(5) NOT NULL,
620 `vPanelsDamage` int(11) NOT NULL,
621 `vDoorsDamage` int(11) NOT NULL,
622 `vLightsDamage` int(11) NOT NULL,
623 `vTiresDamage` int(11) NOT NULL,
624 `vUp_Speed` float NOT NULL,
625 `vUp_Brake` float NOT NULL,
626 PRIMARY KEY (`vID`)
627) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
628
629/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
630/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
631/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;