· 7 years ago · Oct 12, 2018, 04:16 AM
1-- MySQL Administrator dump 1.4
2--
3-- ------------------------------------------------------
4-- Server version 5.1.41
5
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11
12/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
13/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
14/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
15
16
17--
18-- Create schema egame_db
19--
20
21CREATE DATABASE IF NOT EXISTS egame_db;
22USE egame_db;
23
24--
25-- Definition of table `admin_log`
26--
27
28DROP TABLE IF EXISTS `admin_log`;
29CREATE TABLE `admin_log` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `action1` varchar(40) NOT NULL,
32 `description` varchar(40) NOT NULL,
33 `type` varchar(45) NOT NULL,
34 PRIMARY KEY (`id`)
35) ENGINE=MyISAM AUTO_INCREMENT=285 DEFAULT CHARSET=latin1;
36
37--
38-- Dumping data for table `admin_log`
39--
40
41/*!40000 ALTER TABLE `admin_log` DISABLE KEYS */;
42INSERT INTO `admin_log` (`id`,`action1`,`description`,`type`) VALUES
43 (284,'Jonathan Dell [49]','0 (49) to 1 (67) as 240','Skin'),
44 (283,'Jonathan Dell [49]','Aggiornato il giocatore 1 (67) al rank 5','SetRank'),
45 (282,'Jonathan Dell [49]','Venduto il building 2','Sell building'),
46 (281,'Jonathan Dell [49]','Aggiornato il giocatore 0 (67) al rank 5','SetRank'),
47 (280,'Jonathan Dell [49]','Aggiornato il giocatore 0 (67) al rank 5','SetRank'),
48 (279,'Jonathan Dell [49]','Aggiornato il giocatore 0 (67) al rank 5','SetRank');
49/*!40000 ALTER TABLE `admin_log` ENABLE KEYS */;
50
51
52--
53-- Definition of table `buildings`
54--
55
56DROP TABLE IF EXISTS `buildings`;
57CREATE TABLE `buildings` (
58 `ID` int(11) NOT NULL AUTO_INCREMENT,
59 `Name` varchar(36) NOT NULL,
60 `EnterX` float NOT NULL,
61 `EnterY` float NOT NULL,
62 `EnterZ` float NOT NULL,
63 `EntranceFee` int(11) NOT NULL,
64 `EnterWorld` int(11) NOT NULL,
65 `EnterInterior` int(11) NOT NULL,
66 `EnterAngle` float NOT NULL,
67 `ExitX` float NOT NULL,
68 `ExitY` float NOT NULL,
69 `ExitZ` float NOT NULL,
70 `ExitInterior` int(11) NOT NULL,
71 `ExitAngle` float NOT NULL,
72 `Locked` int(11) NOT NULL,
73 `PickupID` int(11) NOT NULL,
74 `Ownable` int(11) NOT NULL,
75 `Owned` int(11) NOT NULL,
76 `Owner` varchar(128) NOT NULL DEFAULT 'None',
77 `Till` int(11) NOT NULL,
78 `Price` int(11) NOT NULL,
79 `Type` int(11) NOT NULL,
80 PRIMARY KEY (`ID`)
81) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=latin1;
82
83--
84-- Dumping data for table `buildings`
85--
86
87/*!40000 ALTER TABLE `buildings` DISABLE KEYS */;
88INSERT INTO `buildings` (`ID`,`Name`,`EnterX`,`EnterY`,`EnterZ`,`EntranceFee`,`EnterWorld`,`EnterInterior`,`EnterAngle`,`ExitX`,`ExitY`,`ExitZ`,`ExitInterior`,`ExitAngle`,`Locked`,`PickupID`,`Ownable`,`Owned`,`Owner`,`Till`,`Price`,`Type`) VALUES
89 (1,'Dipartimento di Polizia',-217.838,979.351,19.5044,0,0,0,277.17,1473.6,-1749.29,3285.29,0,0,0,1,0,0,'',0,0,0),
90 (2,'TuaZiainBikini Liquor',-180.742,1034.84,19.7422,10,0,0,187.19,1448.62,-987.65,1639.78,0,347.94,0,2,1,0,'',20,1,0),
91 (3,'Banca',-179.192,1133.31,19.7422,0,0,0,0,1414.8,-988.91,1639.78,0,0,0,3,0,0,'',0,0,0),
92 (4,'Armeria',-205.515,1120.35,19.8538,0,0,0,0,0,0,0,0,0,0,0,1,0,'',0,50000,0),
93 (5,'Palestra',-206.177,1062.34,19.7422,0,0,0,0,772.329,-5.51573,1000.73,5,0,0,0,0,0,'',0,0,0),
94 (6,'Supasave 24/7',-206.023,1053.25,19.7344,0,0,0,0,198.33,-121.925,966.991,0,0,0,0,1,1,'Jonathan Dell',975,8000,0),
95 (7,'SubUrban',-180.522,1063.41,19.7422,0,0,0,0,0,0,0,0,0,0,0,1,0,'',0,7000,0),
96 (8,'Ristorante Gnocchi',-176.265,1112.21,19.7422,0,0,0,0,0,0,0,0,0,0,0,1,0,'',0,40000,0),
97 (9,'Bar Cactus',-179.782,1087.48,19.7422,0,0,0,0,0,0,0,0,0,0,0,1,1,'Mark Sanchez',0,0,0),
98 (10,'Carson Motel',-206.657,1086.94,19.7422,0,0,0,0,0,0,0,0,0,0,0,1,0,'',0,43000,0),
99 (11,'UniEuro',-206.244,1137.61,19.7422,0,0,0,0,0,0,0,0,0,0,0,1,0,'',0,0,0),
100 (12,'King Ring',-143.992,1225.21,19.8992,0,0,0,0,0,0,0,0,0,0,0,1,0,'',0,13500,0),
101 (13,'Ospedale',-320.139,1048.24,20.3403,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0),
102 (14,'The Bowling Spot',-92.3547,1188.44,19.7422,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0),
103 (15,'Dinner Restaurant',-53.8698,1188.75,19.3594,0,0,0,0,0,0,0,0,0,0,0,1,0,'',0,23000,0),
104 (16,'Easy Fastfood',-19.0248,1175.24,19.5634,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0),
105 (17,'',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0),
106 (18,'',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0),
107 (19,'',0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,0,0);
108/*!40000 ALTER TABLE `buildings` ENABLE KEYS */;
109
110
111--
112-- Definition of table `cashes`
113--
114
115DROP TABLE IF EXISTS `cashes`;
116CREATE TABLE `cashes` (
117 `ID` int(11) NOT NULL AUTO_INCREMENT,
118 `PosX` float NOT NULL,
119 `PosY` float NOT NULL,
120 `PosZ` float NOT NULL,
121 PRIMARY KEY (`ID`)
122) ENGINE=MyISAM AUTO_INCREMENT=101 DEFAULT CHARSET=latin1;
123
124--
125-- Dumping data for table `cashes`
126--
127
128/*!40000 ALTER TABLE `cashes` DISABLE KEYS */;
129INSERT INTO `cashes` (`ID`,`PosX`,`PosY`,`PosZ`) VALUES
130 (1,1417.7,-981.138,1639.78),
131 (2,1421.21,-981.113,1639.78),
132 (3,1424.77,-981.191,1639.78),
133 (4,-211.13,1089.46,19.7422),
134 (5,-54.1646,1178.94,19.3883),
135 (6,0,0,0),
136 (7,0,0,0),
137 (8,0,0,0),
138 (9,0,0,0),
139 (10,0,0,0),
140 (11,0,0,0),
141 (12,0,0,0),
142 (13,0,0,0),
143 (14,0,0,0),
144 (15,0,0,0),
145 (17,0,0,0),
146 (19,0,0,0),
147 (20,0,0,0),
148 (21,0,0,0),
149 (22,0,0,0),
150 (23,0,0,0);
151/*!40000 ALTER TABLE `cashes` ENABLE KEYS */;
152
153
154--
155-- Definition of table `playervehicles`
156--
157
158DROP TABLE IF EXISTS `playervehicles`;
159CREATE TABLE `playervehicles` (
160 `ID` int(11) NOT NULL AUTO_INCREMENT,
161 `vModel` int(11) NOT NULL,
162 `vOwner` varchar(24) NOT NULL,
163 `vColor1` int(11) NOT NULL,
164 `vColor2` int(11) NOT NULL,
165 `vPaintjob` int(11) NOT NULL DEFAULT '-1',
166 `vLocked` int(11) NOT NULL,
167 `vInsuranced` int(11) NOT NULL,
168 `vPlate` varchar(16) NOT NULL,
169 `vX` float NOT NULL,
170 `vY` float NOT NULL,
171 `vZ` float NOT NULL,
172 `vA` float NOT NULL,
173 `vMod1` int(11) NOT NULL,
174 `vMod2` int(11) NOT NULL,
175 `vMod3` int(11) NOT NULL,
176 `vMod4` int(11) NOT NULL,
177 `vMod5` int(11) NOT NULL,
178 `vMod6` int(11) NOT NULL,
179 `vMod7` int(11) NOT NULL,
180 `vMod8` int(11) NOT NULL,
181 `vMod9` int(11) NOT NULL,
182 `vMod10` int(11) NOT NULL,
183 `vMod11` int(11) NOT NULL,
184 `vMod12` int(11) NOT NULL,
185 `vMod13` int(11) NOT NULL,
186 `vMod14` int(11) NOT NULL,
187 `vHealth` float NOT NULL DEFAULT '1000',
188 `vFuel` float NOT NULL DEFAULT '100',
189 `vTrunkDrug` int(11) NOT NULL,
190 `vTrunkMats` int(11) NOT NULL,
191 `vTrunkArmour` float NOT NULL,
192 `vTrunkWep1` int(11) NOT NULL,
193 `vTrunkAmmo1` int(11) NOT NULL,
194 `vTrunkWep2` int(11) NOT NULL,
195 `vTrunkAmmo2` int(11) NOT NULL,
196 `vTrunkWep3` int(11) NOT NULL,
197 `vTrunkAmmo3` int(11) NOT NULL,
198 `vEngine` int(11) NOT NULL,
199 `vSpawned` int(11) NOT NULL,
200 `vCurrentX` float NOT NULL,
201 `vCurrentY` float NOT NULL,
202 `vCurrentZ` float NOT NULL,
203 `vCurrentA` float NOT NULL,
204 `vCurrentInt` int(11) NOT NULL,
205 `vPanelsDmg` int(11) NOT NULL,
206 `vDoorsDmg` int(11) NOT NULL,
207 `vLightsDmg` int(11) NOT NULL,
208 `vTiresDmg` int(11) NOT NULL,
209 `Cambio` int(11) NOT NULL,
210 `GPS` int(11) NOT NULL,
211 PRIMARY KEY (`ID`)
212) ENGINE=MyISAM AUTO_INCREMENT=33301 DEFAULT CHARSET=latin1;
213
214--
215-- Dumping data for table `playervehicles`
216--
217
218/*!40000 ALTER TABLE `playervehicles` DISABLE KEYS */;
219/*!40000 ALTER TABLE `playervehicles` ENABLE KEYS */;
220
221
222--
223-- Definition of table `privateveh`
224--
225
226DROP TABLE IF EXISTS `privateveh`;
227CREATE TABLE `privateveh` (
228 `vID` int(11) NOT NULL,
229 `vModel` int(4) NOT NULL,
230 `vColor1` int(3) NOT NULL,
231 `vColor2` int(11) NOT NULL,
232 `vPrice` int(11) NOT NULL,
233 `vOwner` varchar(24) CHARACTER SET latin1 COLLATE latin1_general_cs NOT NULL,
234 `vPosX` float NOT NULL,
235 `vPosY` float NOT NULL,
236 `vPosZ` float NOT NULL,
237 `vPosA` float NOT NULL,
238 `vPlate` varchar(32) NOT NULL,
239 `vPaintJ` int(1) NOT NULL,
240 `vMod1` int(4) NOT NULL,
241 `vMod2` int(4) NOT NULL,
242 `vMod3` int(4) NOT NULL,
243 `vMod4` int(4) NOT NULL,
244 `vMod5` int(4) NOT NULL,
245 `vMod6` int(4) NOT NULL,
246 `vMod7` int(4) NOT NULL,
247 `vMod8` int(4) NOT NULL,
248 `vMod9` int(4) NOT NULL,
249 `vMod10` int(4) NOT NULL,
250 `vMod11` int(4) NOT NULL,
251 `vMod12` int(4) NOT NULL,
252 `Locked` int(2) NOT NULL,
253 UNIQUE KEY `vID` (`vID`)
254) ENGINE=MyISAM DEFAULT CHARSET=latin1;
255
256--
257-- Dumping data for table `privateveh`
258--
259
260/*!40000 ALTER TABLE `privateveh` DISABLE KEYS */;
261INSERT INTO `privateveh` (`vID`,`vModel`,`vColor1`,`vColor2`,`vPrice`,`vOwner`,`vPosX`,`vPosY`,`vPosZ`,`vPosA`,`vPlate`,`vPaintJ`,`vMod1`,`vMod2`,`vMod3`,`vMod4`,`vMod5`,`vMod6`,`vMod7`,`vMod8`,`vMod9`,`vMod10`,`vMod11`,`vMod12`,`Locked`) VALUES
262 (1,451,3,3,500,'Jonathan Dell',-190.892,990.073,19.4074,328.94,'Jonathan Dell',0,0,0,0,0,0,0,0,0,0,0,0,0,1);
263/*!40000 ALTER TABLE `privateveh` ENABLE KEYS */;
264
265
266--
267-- Definition of table `settings`
268--
269
270DROP TABLE IF EXISTS `settings`;
271CREATE TABLE `settings` (
272 `id` int(11) NOT NULL AUTO_INCREMENT,
273 `username` varchar(24) NOT NULL,
274 `hostname` varchar(60) NOT NULL,
275 `gmtext` varchar(60) NOT NULL,
276 `mapname` varchar(60) NOT NULL,
277 `weburl` varchar(60) NOT NULL,
278 `password` varchar(30) NOT NULL,
279 `name` varchar(45) NOT NULL,
280 PRIMARY KEY (`id`)
281) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
282
283--
284-- Dumping data for table `settings`
285--
286
287/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
288INSERT INTO `settings` (`id`,`username`,`hostname`,`gmtext`,`mapname`,`weburl`,`password`,`name`) VALUES
289 (1,'iMithril','» East Beach [RolePlay]','» Butterfly [0.1]','» Las Venturas','eastbeachrp.forumfree.it','•','0');
290/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
291
292
293--
294-- Definition of table `utenti`
295--
296
297DROP TABLE IF EXISTS `utenti`;
298CREATE TABLE `utenti` (
299 `id` int(11) NOT NULL AUTO_INCREMENT,
300 `username` varchar(24) NOT NULL,
301 `password` varchar(15) NOT NULL,
302 `soldi` int(11) NOT NULL,
303 `rank` int(11) NOT NULL,
304 `livello` int(11) NOT NULL,
305 `exp` int(11) NOT NULL,
306 `maxexp` int(11) NOT NULL,
307 `tutorial` int(11) NOT NULL DEFAULT '0',
308 `CX` float NOT NULL,
309 `CY` float NOT NULL,
310 `CZ` float NOT NULL,
311 `skin` int(11) NOT NULL,
312 `ban` int(11) NOT NULL,
313 `mutato` int(11) NOT NULL,
314 `sesso` int(11) NOT NULL,
315 `anni` int(11) NOT NULL,
316 `biz1` int(11) NOT NULL,
317 `banca` int(11) NOT NULL,
318 `codice` int(11) NOT NULL,
319 `gps` int(11) NOT NULL,
320 `cint` int(11) NOT NULL,
321 `virtualworld` int(11) NOT NULL,
322 `forza` int(11) NOT NULL,
323 `gelato` int(11) NOT NULL,
324 `occhiali` int(11) NOT NULL,
325 `occhiali_id` int(11) NOT NULL,
326 `hp` float NOT NULL,
327 `armatura` float NOT NULL,
328 `credito` int(11) NOT NULL,
329 PRIMARY KEY (`id`)
330) ENGINE=MyISAM AUTO_INCREMENT=70 DEFAULT CHARSET=latin1;
331
332--
333-- Dumping data for table `utenti`
334--
335
336/*!40000 ALTER TABLE `utenti` DISABLE KEYS */;
337INSERT INTO `utenti` (`id`,`username`,`password`,`soldi`,`rank`,`livello`,`exp`,`maxexp`,`tutorial`,`CX`,`CY`,`CZ`,`skin`,`ban`,`mutato`,`sesso`,`anni`,`biz1`,`banca`,`codice`,`gps`,`cint`,`virtualworld`,`forza`,`gelato`,`occhiali`,`occhiali_id`,`hp`,`armatura`,`credito`) VALUES
338 (66,'Jonathan Dellxa','cic',500,0,0,0,0,1,2.8583,28.6425,1199.59,26,0,0,0,0,999,0,0,0,1,1,0,0,0,0,0,0,0),
339 (49,'Jonathan Dell','database10',54947,5,0,0,0,1,0,0,0,292,0,0,0,0,999,0,1940,1,0,0,22,0,0,0,0,0,0),
340 (65,'Guida RP','fifo',500,0,0,0,0,1,983.116,38.9573,157.409,26,0,0,0,0,999,0,0,0,0,0,0,0,0,0,0,0,0),
341 (62,'John Lean','a1b2c3d4',500,0,0,0,0,1,0,0,0,26,0,0,0,0,999,0,0,0,0,0,0,0,0,0,0,0,0),
342 (63,'Axel Fleos','1n25a3',550,5,0,0,0,1,0,0,0,26,0,0,0,0,999,0,0,0,0,0,17,0,0,0,0,0,0),
343 (61,'Fabio Divo','202830',500,0,0,0,0,1,0,0,0,26,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
344 (64,'Jonathan Smith','ciao',500,0,0,0,0,1,1778.86,-1131.73,97.0082,26,0,0,0,0,999,0,0,0,0,0,1,0,0,0,0,0,0),
345 (67,'Mark Sanchez','sizetor',16,0,0,0,0,1,0,0,0,26,0,0,0,0,999,0,0,1,0,0,4,0,0,0,0,0,0),
346 (68,'Jonathan Dell','database10',500,0,0,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0),
347 (69,'Marco Sanciezzio','sizetor',500,0,0,0,0,1,988.217,-1364.14,16.6855,26,0,0,0,0,999,0,0,0,0,0,0,0,0,0,0,0,0);
348/*!40000 ALTER TABLE `utenti` ENABLE KEYS */;
349
350
351
352
353/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
354/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
355/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
356/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
357/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
358/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
359/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;