· 8 years ago · May 06, 2018, 10:24 PM
1Install base server https://wiki.fivem.net/wiki/Running_FXServer
2Install mysql-async https://github.com/brouznouf/fivem-mysql-async/releases/tag/v2.1.1
3Install EssentialMode base 5 (search page for: esplugin_mysql) https://forum.fivem.net/t/release-essentialmode-base/3665 -- https://essentialmode.com/
4 esentialmode
5 es_admin2
6
7
8Run the user sql
9 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10 /*!40101 SET NAMES utf8 */;
11 /*!50503 SET NAMES utf8mb4 */;
12 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
13 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
14
15 -- Dumping structure for table essentialmode.users
16 CREATE TABLE IF NOT EXISTS `users` (
17 `identifier` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
18 `license` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL,
19 `money` int(11) DEFAULT NULL,
20 `bank` int(11) DEFAULT NULL,
21 `permission_level` int(11) DEFAULT NULL,
22 `group` varchar(50) COLLATE utf8mb4_bin DEFAULT NULL
23 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;
24
25 -- Data exporting was unselected.
26 /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
27 /*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
28 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
29
30
31
32Install esplugin_mysql https://forum.fivem.net/t/release-essentialmode-base/3665 (from previous step)
33Install async https://github.com/ESX-Org/async/tree/1.0.1
34Install es_extended https://github.com/ESX-Org/es_extended
35
36Change [ESSENTIAL]\es_extended\config.lua to use a local of en and And comment out french line and uncomment english line
37
38Run the SQL
39 ALTER TABLE `users`
40 ADD COLUMN `name` VARCHAR(255) NULL DEFAULT '' AFTER `money`,
41 ADD COLUMN `skin` LONGTEXT NULL AFTER `name`,
42 ADD COLUMN `job` varchar(255) NULL DEFAULT 'unemployed' AFTER `skin`,
43 ADD COLUMN `job_grade` INT NULL DEFAULT 0 AFTER `job`,
44 ADD COLUMN `loadout` LONGTEXT NULL AFTER `job_grade`,
45 ADD COLUMN `position` VARCHAR(255) NULL AFTER `loadout`
46 ;
47
48 CREATE TABLE `items` (
49
50 `id` int(11) NOT NULL AUTO_INCREMENT,
51 `name` varchar(255) NOT NULL,
52 `label` varchar(255) NOT NULL,
53 `limit` int(11) NOT NULL DEFAULT '-1',
54 `rare` int(11) NOT NULL DEFAULT '0',
55 `can_remove` int(11) NOT NULL DEFAULT '1',
56
57 PRIMARY KEY (`id`)
58 );
59
60 CREATE TABLE `job_grades` (
61
62 `id` int(11) NOT NULL AUTO_INCREMENT,
63 `job_name` varchar(255) DEFAULT NULL,
64 `grade` int(11) NOT NULL,
65 `name` varchar(255) NOT NULL,
66 `label` varchar(255) NOT NULL,
67 `salary` int(11) NOT NULL,
68 `skin_male` longtext NOT NULL,
69 `skin_female` longtext NOT NULL,
70
71 PRIMARY KEY (`id`)
72 );
73
74 INSERT INTO `job_grades` VALUES (1,'unemployed',0,'rsa','RSA',200,'{}','{}');
75
76 CREATE TABLE `jobs` (
77
78 `id` int(11) NOT NULL AUTO_INCREMENT,
79 `name` varchar(255) NOT NULL,
80 `label` varchar(255) DEFAULT NULL,
81
82 PRIMARY KEY (`id`)
83 );
84
85 INSERT INTO `jobs` VALUES (1,'unemployed','Unemployed');
86
87 CREATE TABLE `user_accounts` (
88
89 `id` int(11) NOT NULL AUTO_INCREMENT,
90 `identifier` varchar(255) NOT NULL,
91 `name` varchar(255) NOT NULL,
92 `money` double NOT NULL DEFAULT '0',
93
94 PRIMARY KEY (`id`)
95 );
96
97 CREATE TABLE `user_inventory` (
98
99 `id` int(11) NOT NULL AUTO_INCREMENT,
100 `identifier` varchar(255) NOT NULL,
101 `item` varchar(255) NOT NULL,
102 `count` int(11) NOT NULL,
103
104 PRIMARY KEY (`id`)
105 );
106
107
108Install esx_addonaccount https://github.com/ESX-Org/esx_addonaccount
109
110Run the sql
111
112 CREATE TABLE `addon_account` (
113 `id` int(11) NOT NULL AUTO_INCREMENT,
114 `name` varchar(255) NOT NULL,
115 `label` varchar(255) NOT NULL,
116 `shared` int(11) NOT NULL,
117 PRIMARY KEY (`id`)
118 );
119
120 CREATE TABLE `addon_account_data` (
121 `id` int(11) NOT NULL AUTO_INCREMENT,
122 `account_name` varchar(255) DEFAULT NULL,
123 `money` double NOT NULL,
124 `owner` varchar(255) DEFAULT NULL,
125 PRIMARY KEY (`id`)
126 );
127
128Install esx_jobs
129
130Run the sql
131
132 INSERT INTO `addon_account` (name, label, shared) VALUES
133 ('caution', 'Caution', 0)
134 ;
135
136 INSERT INTO `jobs` (name, label) VALUES
137 ('slaughterer', 'Hunter'),
138 ('fisherman', 'Fisherman'),
139 ('miner', 'Mineur'),
140 ('lumberjack', 'Lumberjack'),
141 ('fueler', 'Refiner'),
142 ('reporter', 'Reporter'),
143 ('tailor', 'Tailor')
144 ;
145
146 INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
147 ('lumberjack', 0, 'interim', 'Employee', 0, '{}', '{}'),
148 ('fisherman', 0, 'interim', 'Employee', 0, '{}', '{}'),
149 ('fueler', 0, 'interim', 'Employee', 0, '{}', '{}'),
150 ('reporter', 0, 'employee', 'Employee', 0, '{}', '{}'),
151 ('tailor',0,'interim','Employee',0,'{\"mask_1\":0,\"arms\":1,\"glasses_1\":0,\"hair_color_2\":4,\"makeup_1\":0,\"face\":19,\"glasses\":0,\"mask_2\":0,\"makeup_3\":0,\"skin\":29,\"helmet_2\":0,\"lipstick_4\":0,\"sex\":0,\"torso_1\":24,\"makeup_2\":0,\"bags_2\":0,\"chain_2\":0,\"ears_1\":-1,\"bags_1\":0,\"bproof_1\":0,\"shoes_2\":0,\"lipstick_2\":0,\"chain_1\":0,\"tshirt_1\":0,\"eyebrows_3\":0,\"pants_2\":0,\"beard_4\":0,\"torso_2\":0,\"beard_2\":6,\"ears_2\":0,\"hair_2\":0,\"shoes_1\":36,\"tshirt_2\":0,\"beard_3\":0,\"hair_1\":2,\"hair_color_1\":0,\"pants_1\":48,\"helmet_1\":-1,\"bproof_2\":0,\"eyebrows_4\":0,\"eyebrows_2\":0,\"decals_1\":0,\"age_2\":0,\"beard_1\":5,\"shoes\":10,\"lipstick_1\":0,\"eyebrows_1\":0,\"glasses_2\":0,\"makeup_4\":0,\"decals_2\":0,\"lipstick_3\":0,\"age_1\":0}','{\"mask_1\":0,\"arms\":5,\"glasses_1\":5,\"hair_color_2\":4,\"makeup_1\":0,\"face\":19,\"glasses\":0,\"mask_2\":0,\"makeup_3\":0,\"skin\":29,\"helmet_2\":0,\"lipstick_4\":0,\"sex\":1,\"torso_1\":52,\"makeup_2\":0,\"bags_2\":0,\"chain_2\":0,\"ears_1\":-1,\"bags_1\":0,\"bproof_1\":0,\"shoes_2\":1,\"lipstick_2\":0,\"chain_1\":0,\"tshirt_1\":23,\"eyebrows_3\":0,\"pants_2\":0,\"beard_4\":0,\"torso_2\":0,\"beard_2\":6,\"ears_2\":0,\"hair_2\":0,\"shoes_1\":42,\"tshirt_2\":4,\"beard_3\":0,\"hair_1\":2,\"hair_color_1\":0,\"pants_1\":36,\"helmet_1\":-1,\"bproof_2\":0,\"eyebrows_4\":0,\"eyebrows_2\":0,\"decals_1\":0,\"age_2\":0,\"beard_1\":5,\"shoes\":10,\"lipstick_1\":0,\"eyebrows_1\":0,\"glasses_2\":0,\"makeup_4\":0,\"decals_2\":0,\"lipstick_3\":0,\"age_1\":0}'),
152 ('miner', 0, 'interim', 'Employee', 0, '{"tshirt_2":1,"ears_1":8,"glasses_1":15,"torso_2":0,"ears_2":2,"glasses_2":3,"shoes_2":1,"pants_1":75,"shoes_1":51,"bags_1":0,"helmet_2":0,"pants_2":7,"torso_1":71,"tshirt_1":59,"arms":2,"bags_2":0,"helmet_1":0}', '{}'),
153 ('slaughterer',0,'interim','Employee',0,'{\"age_1\":0,\"glasses_2\":0,\"beard_1\":5,\"decals_2\":0,\"beard_4\":0,\"shoes_2\":0,\"tshirt_2\":0,\"lipstick_2\":0,\"hair_2\":0,\"arms\":67,\"pants_1\":36,\"skin\":29,\"eyebrows_2\":0,\"shoes\":10,\"helmet_1\":-1,\"lipstick_1\":0,\"helmet_2\":0,\"hair_color_1\":0,\"glasses\":0,\"makeup_4\":0,\"makeup_1\":0,\"hair_1\":2,\"bproof_1\":0,\"bags_1\":0,\"mask_1\":0,\"lipstick_3\":0,\"chain_1\":0,\"eyebrows_4\":0,\"sex\":0,\"torso_1\":56,\"beard_2\":6,\"shoes_1\":12,\"decals_1\":0,\"face\":19,\"lipstick_4\":0,\"tshirt_1\":15,\"mask_2\":0,\"age_2\":0,\"eyebrows_3\":0,\"chain_2\":0,\"glasses_1\":0,\"ears_1\":-1,\"bags_2\":0,\"ears_2\":0,\"torso_2\":0,\"bproof_2\":0,\"makeup_2\":0,\"eyebrows_1\":0,\"makeup_3\":0,\"pants_2\":0,\"beard_3\":0,\"hair_color_2\":4}','{\"age_1\":0,\"glasses_2\":0,\"beard_1\":5,\"decals_2\":0,\"beard_4\":0,\"shoes_2\":0,\"tshirt_2\":0,\"lipstick_2\":0,\"hair_2\":0,\"arms\":72,\"pants_1\":45,\"skin\":29,\"eyebrows_2\":0,\"shoes\":10,\"helmet_1\":-1,\"lipstick_1\":0,\"helmet_2\":0,\"hair_color_1\":0,\"glasses\":0,\"makeup_4\":0,\"makeup_1\":0,\"hair_1\":2,\"bproof_1\":0,\"bags_1\":0,\"mask_1\":0,\"lipstick_3\":0,\"chain_1\":0,\"eyebrows_4\":0,\"sex\":1,\"torso_1\":49,\"beard_2\":6,\"shoes_1\":24,\"decals_1\":0,\"face\":19,\"lipstick_4\":0,\"tshirt_1\":9,\"mask_2\":0,\"age_2\":0,\"eyebrows_3\":0,\"chain_2\":0,\"glasses_1\":5,\"ears_1\":-1,\"bags_2\":0,\"ears_2\":0,\"torso_2\":0,\"bproof_2\":0,\"makeup_2\":0,\"eyebrows_1\":0,\"makeup_3\":0,\"pants_2\":0,\"beard_3\":0,\"hair_color_2\":4}')
154 ;
155
156 INSERT INTO `items` (`name`, `label`, `limit`) VALUES
157 ('alive_chicken', 'Live Chicken', 20),
158 ('slaughtered_chicken', 'Slaughtered Chicken', 20),
159 ('packaged_chicken', 'Chicken Breast', 100),
160 ('fish', 'Fish', 100),
161 ('stone', 'Stone', 7),
162 ('washed_stone', 'Washed Stone', 7),
163 ('copper', 'Copper', 56),
164 ('iron', 'Iron', 42),
165 ('gold', 'Gold', 21),
166 ('diamond', 'Diamon', 50),
167 ('wood', 'Wood', 20),
168 ('cutted_wood', 'Chopped Wood', 20),
169 ('packaged_plank', 'Pack of Planks', 100),
170 ('petrol', 'Oil', 24),
171 ('petrol_raffin', 'Refined Oil', 24),
172 ('essence', 'Essence', 24),
173 ('whool', 'Wool', 40),
174 ('fabric', 'Fabric', 80),
175 ('clothe', 'Cloth', 40)
176 ;
177
178Install instance https://github.com/ESX-Org/instance
179
180
181Install esx_garages https://github.com/ESX-Org/esx_garage
182
183Update config.lua to change locale to en
184
185Run the sql
186 CREATE TABLE `user_parkings` (
187
188 `id` int(11) NOT NULL AUTO_INCREMENT,
189 `identifier` varchar(60) DEFAULT NULL,
190 `garage` varchar(60) DEFAULT NULL,
191 `zone` int(11) NOT NULL,
192 `vehicle` longtext,
193
194 PRIMARY KEY (`id`)
195 );
196
197Install esx_skinchanger https://github.com/ESX-Org/skinchanger
198
199
200Install esx_skin https://github.com/ESX-Org/esx_skin
201
202Update config.lua to change locale to en
203
204Install esx_clothingshop
205
206Install esx_billing https://github.com/ESX-Org/esx_billing
207
208Run the sql
209
210 CREATE TABLE `billing` (
211
212 `id` int(11) NOT NULL AUTO_INCREMENT,
213 `identifier` varchar(255) NOT NULL,
214 `sender` varchar(255) NOT NULL,
215 `target_type` varchar(50) NOT NULL,
216 `target` varchar(255) NOT NULL,
217 `label` varchar(255) NOT NULL,
218 `amount` int(11) NOT NULL,
219
220 PRIMARY KEY (`id`)
221 );
222
223Install cron https://github.com/ESX-Org/cron
224
225
226Install esx_addonaccount https://github.com/ESX-Org/esx_addonaccount
227
228Run the sql
229
230 CREATE TABLE `addon_account` (
231 `id` int(11) NOT NULL AUTO_INCREMENT,
232 `name` varchar(255) NOT NULL,
233 `label` varchar(255) NOT NULL,
234 `shared` int(11) NOT NULL,
235 PRIMARY KEY (`id`)
236 );
237
238 CREATE TABLE `addon_account_data` (
239 `id` int(11) NOT NULL AUTO_INCREMENT,
240 `account_name` varchar(255) DEFAULT NULL,
241 `money` double NOT NULL,
242 `owner` varchar(255) DEFAULT NULL,
243 PRIMARY KEY (`id`)
244 );
245
246Install esx_addoninventory https://github.com/ESX-Org/esx_addoninventory
247
248Run the sql
249
250 CREATE TABLE `addon_inventory` (
251 `id` int(11) NOT NULL AUTO_INCREMENT,
252 `name` varchar(255) NOT NULL,
253 `label` varchar(255) NOT NULL,
254 `shared` int(11) NOT NULL,
255 PRIMARY KEY (`id`)
256 );
257
258 CREATE TABLE `addon_inventory_items` (
259 `id` int(11) NOT NULL AUTO_INCREMENT,
260 `inventory_name` varchar(255) NOT NULL,
261 `name` varchar(255) NOT NULL,
262 `count` int(11) NOT NULL,
263 `owner` varchar(60) DEFAULT NULL,
264 PRIMARY KEY (`id`)
265 );
266
267
268
269Install esx_society https://github.com/ESX-Org/esx_society
270
271Run the sql
272
273 CREATE TABLE `society_moneywash` (
274
275 `id` int(11) NOT NULL AUTO_INCREMENT,
276 `identifier` varchar(60) NOT NULL,
277 `society` varchar(60) NOT NULL,
278 `amount` int(11) NOT NULL,
279
280 PRIMARY KEY (`id`)
281 );
282
283Install esx_datastore https://github.com/ESX-Org/esx_datastore
284
285Run the sql
286
287 CREATE TABLE `datastore` (
288 `id` int(11) NOT NULL AUTO_INCREMENT,
289 `name` varchar(255) NOT NULL,
290 `label` varchar(255) NOT NULL,
291 `shared` int(11) NOT NULL,
292 PRIMARY KEY (`id`)
293 );
294
295 CREATE TABLE `datastore_data` (
296 `id` int(11) NOT NULL AUTO_INCREMENT,
297 `name` varchar(255) NOT NULL,
298 `owner` varchar(255),
299 `data` longtext,
300 PRIMARY KEY (`id`)
301 );
302
303
304
305Install esx_identity
306
307Run the sql
308
309 ALTER TABLE `users`
310 ADD COLUMN `firstname` VARCHAR(50) NULL DEFAULT '',
311 ADD COLUMN `lastname` VARCHAR(50) NULL DEFAULT '',
312 ADD COLUMN `dateofbirth` VARCHAR(25) NULL DEFAULT '',
313 ADD COLUMN `sex` VARCHAR(10) NULL DEFAULT '',
314 ADD COLUMN `height` VARCHAR(5) NULL DEFAULT ''
315 ;
316
317 CREATE TABLE `characters` (
318 `id` int(11) NOT NULL AUTO_INCREMENT,
319 `identifier` varchar(255) NOT NULL,
320 `firstname` varchar(255) NOT NULL,
321 `lastname` varchar(255) NOT NULL,
322 `dateofbirth` varchar(255) NOT NULL,
323 `sex` varchar(1) NOT NULL DEFAULT 'f',
324 `height` varchar(128) NOT NULL,
325
326 PRIMARY KEY (`id`)
327 );
328
329
330
331Install esx_policejob https://github.com/ESX-Org/esx_policejob
332
333Copy en versions of config to base directory
334
335
336Run the sql
337
338 INSERT INTO `addon_account` (name, label, shared) VALUES
339 ('society_police','Police',1)
340 ;
341
342 INSERT INTO `datastore` (name, label, shared) VALUES
343 ('society_police','Police',1)
344 ;
345
346 INSERT INTO `addon_inventory` (name, label, shared) VALUES
347 ('society_police', 'Police', 1)
348 ;
349
350 INSERT INTO `jobs` (name, label) VALUES
351 ('police','LSPD')
352 ;
353
354 INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
355 ('police',0,'recruit','Recruit',20,'{\"tshirt_1\":57,\"torso_1\":55,\"arms\":0,\"pants_1\":35,\"glasses\":0,\"decals_2\":0,\"hair_color_2\":0,\"helmet_2\":0,\"hair_color_1\":5,\"face\":19,\"glasses_2\":1,\"torso_2\":0,\"shoes\":24,\"hair_1\":2,\"skin\":34,\"sex\":0,\"glasses_1\":0,\"pants_2\":0,\"hair_2\":0,\"decals_1\":0,\"tshirt_2\":0,\"helmet_1\":8}','{\"tshirt_1\":34,\"torso_1\":48,\"shoes\":24,\"pants_1\":34,\"torso_2\":0,\"decals_2\":0,\"hair_color_2\":0,\"glasses\":0,\"helmet_2\":0,\"hair_2\":3,\"face\":21,\"decals_1\":0,\"glasses_2\":1,\"hair_1\":11,\"skin\":34,\"sex\":1,\"glasses_1\":5,\"pants_2\":0,\"arms\":14,\"hair_color_1\":10,\"tshirt_2\":0,\"helmet_1\":57}'),
356 ('police',1,'sergeant','Sergeant',40,'{\"tshirt_1\":58,\"torso_1\":55,\"shoes\":24,\"pants_1\":35,\"pants_2\":0,\"decals_2\":1,\"hair_color_2\":0,\"face\":19,\"helmet_2\":0,\"hair_2\":0,\"arms\":0,\"decals_1\":8,\"torso_2\":0,\"hair_1\":2,\"skin\":34,\"sex\":0,\"glasses_1\":0,\"glasses_2\":1,\"hair_color_1\":5,\"glasses\":0,\"tshirt_2\":0,\"helmet_1\":11}','{\"tshirt_1\":35,\"torso_1\":48,\"arms\":14,\"pants_1\":34,\"pants_2\":0,\"decals_2\":1,\"hair_color_2\":0,\"shoes\":24,\"helmet_2\":0,\"hair_2\":3,\"decals_1\":7,\"torso_2\":0,\"face\":21,\"hair_1\":11,\"skin\":34,\"sex\":1,\"glasses_1\":5,\"glasses_2\":1,\"hair_color_1\":10,\"glasses\":0,\"tshirt_2\":0,\"helmet_1\":57}'),
357 ('police',2,'lieutenant','Lieutenant',65,'{\"tshirt_1\":58,\"torso_1\":55,\"shoes\":24,\"pants_1\":35,\"pants_2\":0,\"decals_2\":2,\"hair_color_2\":0,\"face\":19,\"helmet_2\":0,\"hair_2\":0,\"glasses\":0,\"decals_1\":8,\"hair_color_1\":5,\"hair_1\":2,\"skin\":34,\"sex\":0,\"glasses_1\":0,\"glasses_2\":1,\"torso_2\":0,\"arms\":41,\"tshirt_2\":0,\"helmet_1\":11}','{\"tshirt_1\":35,\"torso_1\":48,\"arms\":44,\"pants_1\":34,\"hair_2\":3,\"decals_2\":2,\"hair_color_2\":0,\"hair_color_1\":10,\"helmet_2\":0,\"face\":21,\"shoes\":24,\"torso_2\":0,\"glasses_2\":1,\"hair_1\":11,\"skin\":34,\"sex\":1,\"glasses_1\":5,\"pants_2\":0,\"decals_1\":7,\"glasses\":0,\"tshirt_2\":0,\"helmet_1\":57}'),
358 ('police',3,'boss','Chief',80,'{\"tshirt_1\":58,\"torso_1\":55,\"shoes\":24,\"pants_1\":35,\"pants_2\":0,\"decals_2\":3,\"hair_color_2\":0,\"face\":19,\"helmet_2\":0,\"hair_2\":0,\"arms\":41,\"torso_2\":0,\"hair_color_1\":5,\"hair_1\":2,\"skin\":34,\"sex\":0,\"glasses_1\":0,\"glasses_2\":1,\"decals_1\":8,\"glasses\":0,\"tshirt_2\":0,\"helmet_1\":11}','{\"tshirt_1\":35,\"torso_1\":48,\"arms\":44,\"pants_1\":34,\"pants_2\":0,\"decals_2\":3,\"hair_color_2\":0,\"face\":21,\"helmet_2\":0,\"hair_2\":3,\"decals_1\":7,\"torso_2\":0,\"hair_color_1\":10,\"hair_1\":11,\"skin\":34,\"sex\":1,\"glasses_1\":5,\"glasses_2\":1,\"shoes\":24,\"glasses\":0,\"tshirt_2\":0,\"helmet_1\":57}')
359 ;
360
361 CREATE TABLE `fine_types` (
362
363 `id` int(11) NOT NULL AUTO_INCREMENT,
364 `label` varchar(255) DEFAULT NULL,
365 `amount` int(11) DEFAULT NULL,
366 `category` int(11) DEFAULT NULL,
367
368 PRIMARY KEY (`id`)
369 );
370
371 INSERT INTO `fine_types` (label, amount, category) VALUES
372 ('Misuse of a horn', 30, 0),
373 ('Illegally Crossing a continuous Line', 40, 0),
374 ('Driving on the wrong side of the road', 250, 0),
375 ('Illegal U-Turn', 250, 0),
376 ('Illegally Driving Off-road', 170, 0),
377 ('Refusing a Lawful Command', 30, 0),
378 ('Illegally Stoped of a Vehicle', 150, 0),
379 ('Illegal Parking', 70, 0),
380 ('Failing to Yield to the right', 70, 0),
381 ('Failure to comply with Vehicle Information', 90, 0),
382 ('Failing to stop at a Stop Sign ', 105, 0),
383 ('Failing to stop at a Red Light', 130, 0),
384 ('Illegal Passing', 100, 0),
385 ('Driving an illegal Vehicle', 100, 0),
386 ('Driving without a License', 1500, 0),
387 ('Hit and Run', 800, 0),
388 ('Exceeding Speeds Over < 5 mph', 90, 0),
389 ('Exceeding Speeds Over 5-15 mph', 120, 0),
390 ('Exceeding Speeds Over 15-30 mph', 180, 0),
391 ('Exceeding Speeds Over > 30 mph', 300, 0),
392 ('Impeding traffic flow', 110, 1),
393 ('Public Intoxication', 90, 1),
394 ('Disorderly conduct', 90, 1),
395 ('Obstruction of Justice', 130, 1),
396 ('Insults towards Civilans', 75, 1),
397 ('Disrespecting of an LEO', 110, 1),
398 ('Verbal Threat towards a Civilan', 90, 1),
399 ('Verbal Threat towards an LEO', 150, 1),
400 ('Providing False Information', 250, 1),
401 ('Attempt of Corruption', 1500, 1),
402 ('Brandishing a weapon in city Limits', 120, 2),
403 ('Brandishing a Lethal Weapon in city Limits', 300, 2),
404 ('No Firearms License', 600, 2),
405 ('Possession of an Illegal Weapon', 700, 2),
406 ('Possession of Burglary Tools', 300, 2),
407 ('Grand Theft Auto', 1800, 2),
408 ('Intent to Sell/Distrube of an illegal Substance', 1500, 2),
409 ('Frabrication of an Illegal Substance', 1500, 2),
410 ('Possession of an Illegal Substance ', 650, 2),
411 ('Kidnapping of a Civilan', 1500, 2),
412 ('Kidnapping of an LEO', 2000, 2),
413 ('Robbery', 650, 2),
414 ('Armed Robbery of a Store', 650, 2),
415 ('Armed Robbery of a Bank', 1500, 2),
416 ('Assault on a Civilian', 2000, 3),
417 ('Assault of an LEO', 2500, 3),
418 ('Attempt of Murder of a Civilian', 3000, 3),
419 ('Attempt of Murder of an LEO', 5000, 3),
420 ('Murder of a Civilian', 10000, 3),
421 ('Murder of an LEO', 30000, 3),
422 ('Involuntary manslaughter', 1800, 3),
423 ('Fraud', 2000, 2);
424 ;
425
426
427
428
429Install esx_property https://forum.fivem.net/t/release-esx-properties/41266
430
431Run the sql
432
433
434 ALTER TABLE `users`
435 ADD COLUMN `last_property` VARCHAR(255) NULL
436 ;
437
438 INSERT INTO `addon_account` (name, label, shared) VALUES
439 ('property_black_money','Money Sale Property',0)
440 ;
441
442 INSERT INTO `addon_inventory` (name, label, shared) VALUES
443 ('property','Property',0)
444 ;
445
446 INSERT INTO `datastore` (name, label, shared) VALUES
447 ('property','Property',0)
448 ;
449
450 CREATE TABLE `owned_properties` (
451
452 `id` int(11) NOT NULL AUTO_INCREMENT,
453 `name` varchar(255) NOT NULL,
454 `price` double NOT NULL,
455 `rented` int(11) NOT NULL,
456 `owner` varchar(60) NOT NULL,
457
458 PRIMARY KEY (`id`)
459 );
460
461 CREATE TABLE `properties` (
462
463 `id` int(11) NOT NULL AUTO_INCREMENT,
464 `name` varchar(255) DEFAULT NULL,
465 `label` varchar(255) DEFAULT NULL,
466 `entering` varchar(255) DEFAULT NULL,
467 `exit` varchar(255) DEFAULT NULL,
468 `inside` varchar(255) DEFAULT NULL,
469 `outside` varchar(255) DEFAULT NULL,
470 `ipls` varchar(255) DEFAULT '[]',
471 `gateway` varchar(255) DEFAULT NULL,
472 `is_single` int(11) DEFAULT NULL,
473 `is_room` int(11) DEFAULT NULL,
474 `is_gateway` int(11) DEFAULT NULL,
475 `room_menu` varchar(255) DEFAULT NULL,
476 `price` int(11) NOT NULL,
477
478 PRIMARY KEY (`id`)
479 );
480
481 INSERT INTO `properties` VALUES
482 (1,'WhispymoundDrive','2677 Whispymound Drive','{\"y\":564.89,\"z\":182.959,\"x\":119.384}','{\"x\":117.347,\"y\":559.506,\"z\":183.304}','{\"y\":557.032,\"z\":183.301,\"x\":118.037}','{\"y\":567.798,\"z\":182.131,\"x\":119.249}','[]',NULL,1,1,0,'{\"x\":118.748,\"y\":566.573,\"z\":175.697}',1500000),
483 (2,'NorthConkerAvenue2045','2045 North Conker Avenue','{\"x\":372.796,\"y\":428.327,\"z\":144.685}','{\"x\":373.548,\"y\":422.982,\"z\":144.907},','{\"y\":420.075,\"z\":145.904,\"x\":372.161}','{\"x\":372.454,\"y\":432.886,\"z\":143.443}','[]',NULL,1,1,0,'{\"x\":377.349,\"y\":429.422,\"z\":137.3}',1500000),
484 (3,'RichardMajesticApt2','Richard Majestic, Apt 2','{\"y\":-379.165,\"z\":37.961,\"x\":-936.363}','{\"y\":-365.476,\"z\":113.274,\"x\":-913.097}','{\"y\":-367.637,\"z\":113.274,\"x\":-918.022}','{\"y\":-382.023,\"z\":37.961,\"x\":-943.626}','[]',NULL,1,1,0,'{\"x\":-927.554,\"y\":-377.744,\"z\":112.674}',1700000),
485 (4,'NorthConkerAvenue2044','2044 North Conker Avenue','{\"y\":440.8,\"z\":146.702,\"x\":346.964}','{\"y\":437.456,\"z\":148.394,\"x\":341.683}','{\"y\":435.626,\"z\":148.394,\"x\":339.595}','{\"x\":350.535,\"y\":443.329,\"z\":145.764}','[]',NULL,1,1,0,'{\"x\":337.726,\"y\":436.985,\"z\":140.77}',1500000),
486 (5,'WildOatsDrive','3655 Wild Oats Drive','{\"y\":502.696,\"z\":136.421,\"x\":-176.003}','{\"y\":497.817,\"z\":136.653,\"x\":-174.349}','{\"y\":495.069,\"z\":136.666,\"x\":-173.331}','{\"y\":506.412,\"z\":135.0664,\"x\":-177.927}','[]',NULL,1,1,0,'{\"x\":-174.725,\"y\":493.095,\"z\":129.043}',1500000),
487 (6,'HillcrestAvenue2862','2862 Hillcrest Avenue','{\"y\":596.58,\"z\":142.641,\"x\":-686.554}','{\"y\":591.988,\"z\":144.392,\"x\":-681.728}','{\"y\":590.608,\"z\":144.392,\"x\":-680.124}','{\"y\":599.019,\"z\":142.059,\"x\":-689.492}','[]',NULL,1,1,0,'{\"x\":-680.46,\"y\":588.6,\"z\":136.769}',1500000),
488 (7,'LowEndApartment','Basic apartment','{\"y\":-1078.735,\"z\":28.4031,\"x\":292.528}','{\"y\":-1007.152,\"z\":-102.002,\"x\":265.845}','{\"y\":-1002.802,\"z\":-100.008,\"x\":265.307}','{\"y\":-1078.669,\"z\":28.401,\"x\":296.738}','[]',NULL,1,1,0,'{\"x\":265.916,\"y\":-999.38,\"z\":-100.008}',562500),
489 (8,'MadWayneThunder','2113 Mad Wayne Thunder','{\"y\":454.955,\"z\":96.462,\"x\":-1294.433}','{"x":-1289.917,"y":449.541,"z":96.902}','{\"y\":446.322,\"z\":96.899,\"x\":-1289.642}','{\"y\":455.453,\"z\":96.517,\"x\":-1298.851}','[]',NULL,1,1,0,'{\"x\":-1287.306,\"y\":455.901,\"z\":89.294}',1500000),
490 (9,'HillcrestAvenue2874','2874 Hillcrest Avenue','{\"x\":-853.346,\"y\":696.678,\"z\":147.782}','{\"y\":690.875,\"z\":151.86,\"x\":-859.961}','{\"y\":688.361,\"z\":151.857,\"x\":-859.395}','{\"y\":701.628,\"z\":147.773,\"x\":-855.007}','[]',NULL,1,1,0,'{\"x\":-858.543,\"y\":697.514,\"z\":144.253}',1500000),
491 (10,'HillcrestAvenue2868','2868 Hillcrest Avenue','{\"y\":620.494,\"z\":141.588,\"x\":-752.82}','{\"y\":618.62,\"z\":143.153,\"x\":-759.317}','{\"y\":617.629,\"z\":143.153,\"x\":-760.789}','{\"y\":621.281,\"z\":141.254,\"x\":-750.919}','[]',NULL,1,1,0,'{\"x\":-762.504,\"y\":618.992,\"z\":135.53}',1500000),
492 (11,'TinselTowersApt12','Tinsel Towers, Apt 42','{\"y\":37.025,\"z\":42.58,\"x\":-618.299}','{\"y\":58.898,\"z\":97.2,\"x\":-603.301}','{\"y\":58.941,\"z\":97.2,\"x\":-608.741}','{\"y\":30.603,\"z\":42.524,\"x\":-620.017}','[]',NULL,1,1,0,'{\"x\":-622.173,\"y\":54.585,\"z\":96.599}',1700000),
493 (12,'MiltonDrive','Milton Drive','{\"x\":-775.17,\"y\":312.01,\"z\":84.658}',NULL,NULL,'{\"x\":-775.346,\"y\":306.776,\"z\":84.7}','[]',NULL,0,0,1,NULL,0),
494 (13,'Modern1Apartment','Modern Apartment 1',NULL,'{\"x\":-784.194,\"y\":323.636,\"z\":210.997}','{\"x\":-779.751,\"y\":323.385,\"z\":210.997}',NULL,'[\"apa_v_mp_h_01_a\"]','MiltonDrive',0,1,0,'{\"x\":-766.661,\"y\":327.672,\"z\":210.396}',1300000),
495 (14,'Modern2Apartment','Modern Apartment 2',NULL,'{\"x\":-786.8663,\"y\":315.764,\"z\":186.913}','{\"x\":-781.808,\"y\":315.866,\"z\":186.913}',NULL,'[\"apa_v_mp_h_01_c\"]','MiltonDrive',0,1,0,'{\"x\":-795.735,\"y\":326.757,\"z\":186.313}',1300000),
496 (15,'Modern3Apartment','Modern Apartment 3',NULL,'{\"x\":-774.012,\"y\":342.042,\"z\":195.686}','{\"x\":-779.057,\"y\":342.063,\"z\":195.686}',NULL,'[\"apa_v_mp_h_01_b\"]','MiltonDrive',0,1,0,'{\"x\":-765.386,\"y\":330.782,\"z\":195.08}',1300000),
497 (16,'Mody1Apartment','Mody Apartment 1',NULL,'{\"x\":-784.194,\"y\":323.636,\"z\":210.997}','{\"x\":-779.751,\"y\":323.385,\"z\":210.997}',NULL,'[\"apa_v_mp_h_02_a\"]','MiltonDrive',0,1,0,'{\"x\":-766.615,\"y\":327.878,\"z\":210.396}',1300000),
498 (17,'Mody2Apartment','Mody Apartment 2',NULL,'{\"x\":-786.8663,\"y\":315.764,\"z\":186.913}','{\"x\":-781.808,\"y\":315.866,\"z\":186.913}',NULL,'[\"apa_v_mp_h_02_c\"]','MiltonDrive',0,1,0,'{\"x\":-795.297,\"y\":327.092,\"z\":186.313}',1300000),
499 (18,'Mody3Apartment','Mody Apartment 3',NULL,'{\"x\":-774.012,\"y\":342.042,\"z\":195.686}','{\"x\":-779.057,\"y\":342.063,\"z\":195.686}',NULL,'[\"apa_v_mp_h_02_b\"]','MiltonDrive',0,1,0,'{\"x\":-765.303,\"y\":330.932,\"z\":195.085}',1300000),
500 (19,'Vibrant1Apartment','Vibrant Apartment 1',NULL,'{\"x\":-784.194,\"y\":323.636,\"z\":210.997}','{\"x\":-779.751,\"y\":323.385,\"z\":210.997}',NULL,'[\"apa_v_mp_h_03_a\"]','MiltonDrive',0,1,0,'{\"x\":-765.885,\"y\":327.641,\"z\":210.396}',1300000),
501 (20,'Vibrant2Apartment','Vibrant Apartment 2',NULL,'{\"x\":-786.8663,\"y\":315.764,\"z\":186.913}','{\"x\":-781.808,\"y\":315.866,\"z\":186.913}',NULL,'[\"apa_v_mp_h_03_c\"]','MiltonDrive',0,1,0,'{\"x\":-795.607,\"y\":327.344,\"z\":186.313}',1300000),
502 (21,'Vibrant3Apartment','Vibrant Apartment 3',NULL,'{\"x\":-774.012,\"y\":342.042,\"z\":195.686}','{\"x\":-779.057,\"y\":342.063,\"z\":195.686}',NULL,'[\"apa_v_mp_h_03_b\"]','MiltonDrive',0,1,0,'{\"x\":-765.525,\"y\":330.851,\"z\":195.085}',1300000),
503 (22,'Sharp1Apartment','Sharp Apartment 1',NULL,'{\"x\":-784.194,\"y\":323.636,\"z\":210.997}','{\"x\":-779.751,\"y\":323.385,\"z\":210.997}',NULL,'[\"apa_v_mp_h_04_a\"]','MiltonDrive',0,1,0,'{\"x\":-766.527,\"y\":327.89,\"z\":210.396}',1300000),
504 (23,'Sharp2Apartment','Sharp Apartment 2',NULL,'{\"x\":-786.8663,\"y\":315.764,\"z\":186.913}','{\"x\":-781.808,\"y\":315.866,\"z\":186.913}',NULL,'[\"apa_v_mp_h_04_c\"]','MiltonDrive',0,1,0,'{\"x\":-795.642,\"y\":326.497,\"z\":186.313}',1300000),
505 (24,'Sharp3Apartment','Sharp Apartment 3',NULL,'{\"x\":-774.012,\"y\":342.042,\"z\":195.686}','{\"x\":-779.057,\"y\":342.063,\"z\":195.686}',NULL,'[\"apa_v_mp_h_04_b\"]','MiltonDrive',0,1,0,'{\"x\":-765.503,\"y\":331.318,\"z\":195.085}',1300000),
506 (25,'Monochrome1Apartment','Monochrome Apartment 1',NULL,'{\"x\":-784.194,\"y\":323.636,\"z\":210.997}','{\"x\":-779.751,\"y\":323.385,\"z\":210.997}',NULL,'[\"apa_v_mp_h_05_a\"]','MiltonDrive',0,1,0,'{\"x\":-766.289,\"y\":328.086,\"z\":210.396}',1300000),
507 (26,'Monochrome2Apartment','Monochrome Apartment 2',NULL,'{\"x\":-786.8663,\"y\":315.764,\"z\":186.913}','{\"x\":-781.808,\"y\":315.866,\"z\":186.913}',NULL,'[\"apa_v_mp_h_05_c\"]','MiltonDrive',0,1,0,'{\"x\":-795.692,\"y\":326.762,\"z\":186.313}',1300000),
508 (27,'Monochrome3Apartment','Monochrome Apartment 3',NULL,'{\"x\":-774.012,\"y\":342.042,\"z\":195.686}','{\"x\":-779.057,\"y\":342.063,\"z\":195.686}',NULL,'[\"apa_v_mp_h_05_b\"]','MiltonDrive',0,1,0,'{\"x\":-765.094,\"y\":330.976,\"z\":195.085}',1300000),
509 (28,'Seductive1Apartment','Seductive Apartment 1',NULL,'{\"x\":-784.194,\"y\":323.636,\"z\":210.997}','{\"x\":-779.751,\"y\":323.385,\"z\":210.997}',NULL,'[\"apa_v_mp_h_06_a\"]','MiltonDrive',0,1,0,'{\"x\":-766.263,\"y\":328.104,\"z\":210.396}',1300000),
510 (29,'Seductive2Apartment','Seductive Apartment 2',NULL,'{\"x\":-786.8663,\"y\":315.764,\"z\":186.913}','{\"x\":-781.808,\"y\":315.866,\"z\":186.913}',NULL,'[\"apa_v_mp_h_06_c\"]','MiltonDrive',0,1,0,'{\"x\":-795.655,\"y\":326.611,\"z\":186.313}',1300000),
511 (30,'Seductive3Apartment','Seductive Apartment 3',NULL,'{\"x\":-774.012,\"y\":342.042,\"z\":195.686}','{\"x\":-779.057,\"y\":342.063,\"z\":195.686}',NULL,'[\"apa_v_mp_h_06_b\"]','MiltonDrive',0,1,0,'{\"x\":-765.3,\"y\":331.414,\"z\":195.085}',1300000),
512 (31,'Regal1Apartment','Regal Apartment 1',NULL,'{\"x\":-784.194,\"y\":323.636,\"z\":210.997}','{\"x\":-779.751,\"y\":323.385,\"z\":210.997}',NULL,'[\"apa_v_mp_h_07_a\"]','MiltonDrive',0,1,0,'{\"x\":-765.956,\"y\":328.257,\"z\":210.396}',1300000),
513 (32,'Regal2Apartment','Regal Apartment 2',NULL,'{\"x\":-786.8663,\"y\":315.764,\"z\":186.913}','{\"x\":-781.808,\"y\":315.866,\"z\":186.913}',NULL,'[\"apa_v_mp_h_07_c\"]','MiltonDrive',0,1,0,'{\"x\":-795.545,\"y\":326.659,\"z\":186.313}',1300000),
514 (33,'Regal3Apartment','Regal Apartment 3',NULL,'{\"x\":-774.012,\"y\":342.042,\"z\":195.686}','{\"x\":-779.057,\"y\":342.063,\"z\":195.686}',NULL,'[\"apa_v_mp_h_07_b\"]','MiltonDrive',0,1,0,'{\"x\":-765.087,\"y\":331.429,\"z\":195.123}',1300000),
515 (34,'Aqua1Apartment','Aqua Apartment 1',NULL,'{\"x\":-784.194,\"y\":323.636,\"z\":210.997}','{\"x\":-779.751,\"y\":323.385,\"z\":210.997}',NULL,'[\"apa_v_mp_h_08_a\"]','MiltonDrive',0,1,0,'{\"x\":-766.187,\"y\":328.47,\"z\":210.396}',1300000),
516 (35,'Aqua2Apartment','Aqua Apartment 2',NULL,'{\"x\":-786.8663,\"y\":315.764,\"z\":186.913}','{\"x\":-781.808,\"y\":315.866,\"z\":186.913}',NULL,'[\"apa_v_mp_h_08_c\"]','MiltonDrive',0,1,0,'{\"x\":-795.658,\"y\":326.563,\"z\":186.313}',1300000),
517 (36,'Aqua3Apartment','Aqua Apartment 3',NULL,'{\"x\":-774.012,\"y\":342.042,\"z\":195.686}','{\"x\":-779.057,\"y\":342.063,\"z\":195.686}',NULL,'[\"apa_v_mp_h_08_b\"]','MiltonDrive',0,1,0,'{\"x\":-765.287,\"y\":331.084,\"z\":195.086}',1300000),
518 (37,'IntegrityWay','4 Integrity Way','{\"x\":-47.804,\"y\":-585.867,\"z\":36.956}',NULL,NULL,'{\"x\":-54.178,\"y\":-583.762,\"z\":35.798}','[]',NULL,0,0,1,NULL,0),
519 (38,'IntegrityWay28','4 Integrity Way - Apt 28',NULL,'{\"x\":-31.409,\"y\":-594.927,\"z\":79.03}','{\"x\":-26.098,\"y\":-596.909,\"z\":79.03}',NULL,'[]','IntegrityWay',0,1,0,'{\"x\":-11.923,\"y\":-597.083,\"z\":78.43}',1700000),
520 (39,'IntegrityWay30','4 Integrity Way - Apt 30',NULL,'{\"x\":-17.702,\"y\":-588.524,\"z\":89.114}','{\"x\":-16.21,\"y\":-582.569,\"z\":89.114}',NULL,'[]','IntegrityWay',0,1,0,'{\"x\":-26.327,\"y\":-588.384,\"z\":89.123}',1700000),
521 (40,'DellPerroHeights','Dell Perro Heights','{\"x\":-1447.06,\"y\":-538.28,\"z\":33.74}',NULL,NULL,'{\"x\":-1440.022,\"y\":-548.696,\"z\":33.74}','[]',NULL,0,0,1,NULL,0),
522 (41,'DellPerroHeightst4','Dell Perro Heights - Apt 28',NULL,'{\"x\":-1452.125,\"y\":-540.591,\"z\":73.044}','{\"x\":-1455.435,\"y\":-535.79,\"z\":73.044}',NULL,'[]','DellPerroHeights',0,1,0,'{\"x\":-1467.058,\"y\":-527.571,\"z\":72.443}',1700000),
523 (42,'DellPerroHeightst7','Dell Perro Heights - Apt 30',NULL,'{\"x\":-1451.562,\"y\":-523.535,\"z\":55.928}','{\"x\":-1456.02,\"y\":-519.209,\"z\":55.929}',NULL,'[]','DellPerroHeights',0,1,0,'{\"x\":-1457.026,\"y\":-530.219,\"z\":55.937}',1700000)
524 ;
525
526
527 INSERT INTO `properties` VALUES
528 (43, 'MazeBankBuilding', 'Maze Bank Building', '{\"x\":-79.18,\"y\":-795.92,\"z\":43.35}', NULL, NULL, '{\"x\":-72.50,\"y\":-786.92,\"z\":43.40}', '[]', NULL, 0, 0, 1, NULL, 0),
529 (44, 'OldSpiceWarm', 'Old Spice Warm', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_01a\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-71.81,\"y\":-814.34,\"z\":242.39}', 5000000),
530 (45, 'OldSpiceClassical', 'Old Spice Classical', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_01b\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-71.81,\"y\":-814.34,\"z\":242.39}', 5000000),
531 (46, 'OldSpiceVintage', 'Old Spice Vintage', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_01c\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-71.81,\"y\":-814.34,\"z\":242.39}', 5000000),
532 (47, 'ExecutiveRich', 'Executive Rich', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_02b\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-71.81,\"y\":-814.34,\"z\":242.39}', 5000000),
533 (48, 'ExecutiveCool', 'Executive Cool', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_02c\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-71.81,\"y\":-814.34,\"z\":242.39}', 5000000),
534 (49, 'ExecutiveContrast', 'Executive Contrast', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_02a\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-71.81,\"y\":-814.34,\"z\":242.39}', 5000000),
535 (50, 'PowerBrokerIce', 'Power Broker Ice', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_03a\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-71.81,\"y\":-814.34,\"z\":242.39}', 5000000),
536 (51, 'PowerBrokerConservative', 'Power Broker Conservative', NULL, '', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_03b\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-71.81,\"y\":-814.34,\"z\":242.39}', 5000000),
537 (52, 'PowerBrokerPolished', 'Power Broker Polished', NULL, '{\"x\":-75.69,\"y\":-827.08,\"z\":242.43}', '{\"x\":-75.51,\"y\":-823.90,\"z\":242.43}', NULL, '[\"ex_dt1_11_office_03c\"]', 'MazeBankBuilding', 0, 1, 0, '{\"x\":-71.81,\"y\":-814.34,\"z\":242.39}', 5000000),
538 (53, 'LomBank', 'Lom Bank', '{\"x\":-1581.36,\"y\":-558.23,\"z\":34.07}', NULL, NULL, '{\"x\":-1583.60,\"y\":-555.12,\"z\":34.07}', '[]', NULL, 0, 0, 1, NULL, 0),
539 (54, 'LBOldSpiceWarm', 'LB Old Spice Warm', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_01a\"]', 'LomBank', 0, 1, 0, '{\"x\":-1571.26,\"y\":-575.76,\"z\":107.52}', 3500000),
540 (55, 'LBOldSpiceClassical', 'LB Old Spice Classical', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_01b\"]', 'LomBank', 0, 1, 0, '{\"x\":-1571.26,\"y\":-575.76,\"z\":107.52}', 3500000),
541 (56, 'LBOldSpiceVintage', 'LB Old Spice Vintage', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_01c\"]', 'LomBank', 0, 1, 0, '{\"x\":-1571.26,\"y\":-575.76,\"z\":107.52}', 3500000),
542 (57, 'LBExecutiveRich', 'LB Executive Rich', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_02b\"]', 'LomBank', 0, 1, 0, '{\"x\":-1571.26,\"y\":-575.76,\"z\":107.52}', 3500000),
543 (58, 'LBExecutiveCool', 'LB Executive Cool', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_02c\"]', 'LomBank', 0, 1, 0, '{\"x\":-1571.26,\"y\":-575.76,\"z\":107.52}', 3500000),
544 (59, 'LBExecutiveContrast', 'LB Executive Contrast', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_02a\"]', 'LomBank', 0, 1, 0, '{\"x\":-1571.26,\"y\":-575.76,\"z\":107.52}', 3500000),
545 (60, 'LBPowerBrokerIce', 'LB Power Broker Ice', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_03a\"]', 'LomBank', 0, 1, 0, '{\"x\":-1571.26,\"y\":-575.76,\"z\":107.52}', 3500000),
546 (61, 'LBPowerBrokerConservative', 'LB Power Broker Conservative', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_03b\"]', 'LomBank', 0, 1, 0, '{\"x\":-1571.26,\"y\":-575.76,\"z\":107.52}', 3500000),
547 (62, 'LBPowerBrokerPolished', 'LB Power Broker Polished', NULL, '{\"x\":-1579.53,\"y\":-564.89,\"z\":107.62}', '{\"x\":-1576.42,\"y\":-567.57,\"z\":107.62}', NULL, '[\"ex_sm_13_office_03c\"]', 'LomBank', 0, 1, 0, '{\"x\":-1571.26,\"y\":-575.76,\"z\":107.52}', 3500000),
548 (63, 'MazeBankWest', 'Maze Bank West', '{\"x\":-1379.58,\"y\":-499.63,\"z\":32.22}', NULL, NULL, '{\"x\":-1378.95,\"y\":-502.82,\"z\":32.22}', '[]', NULL, 0, 0, 1, NULL, 0),
549 (64, 'MBWOldSpiceWarm', 'MBW Old Spice Warm', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_01a\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
550 (65, 'MBWOldSpiceClassical', 'MBW Old Spice Classical', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_01b\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
551 (66, 'MBWOldSpiceVintage', 'MBW Old Spice Vintage', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_01c\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
552 (67, 'MBWExecutiveRich', 'MBW Executive Rich', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_02b\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
553 (68, 'MBWExecutiveCool', 'MBW Executive Cool', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_02c\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
554 (69, 'MBWExecutive Contrast', 'MBW Executive Contrast', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_02a\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
555 (70, 'MBWPowerBrokerIce', 'MBW Power Broker Ice', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_03a\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
556 (71, 'MBWPowerBrokerConvservative', 'MBW Power Broker Convservative', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_03b\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000),
557 (72, 'MBWPowerBrokerPolished', 'MBW Power Broker Polished', NULL, '{\"x\":-1392.74,\"y\":-480.18,\"z\":71.14}', '{\"x\":-1389.43,\"y\":-479.01,\"z\":71.14}', NULL, '[\"ex_sm_15_office_03c\"]', 'MazeBankWest', 0, 1, 0, '{\"x\":-1390.76,\"y\":-479.22,\"z\":72.04}', 2700000);
558 ;
559
560
561
562Install esx_drugs https://forum.fivem.net/t/release-esx-drugs/42637
563
564Run the sql
565
566 INSERT INTO `items` (name, label, `limit`) VALUES
567 ('weed', 'Weed', 50),
568 ('weed_pooch', 'Bag of weed', 10),
569 ('coke', 'Cocaine', 50),
570 ('coke_pooch', 'Bag of cocaine', 10),
571 ('meth', 'Meth', 50),
572 ('meth_pooch', 'Bag of meth', 10),
573 ('opium', 'Opium', 50),
574 ('opium_pooch', 'Bag of opium', 10)
575 ;
576
577Install esx_ambulancejob https://github.com/ESX-Org/esx_ambulancejob
578
579
580Run the sql
581
582 INSERT INTO `addon_account` (name, label, shared) VALUES
583 ('society_ambulance', 'Ambulance', 1)
584 ;
585
586 INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
587 ('ambulance',0,'ambulance','Ambulance',20,'{\"tshirt_2\":0,\"hair_color_1\":5,\"glasses_2\":3,\"shoes\":9,\"torso_2\":3,\"hair_color_2\":0,\"pants_1\":24,\"glasses_1\":4,\"hair_1\":2,\"sex\":0,\"decals_2\":0,\"tshirt_1\":15,\"helmet_1\":8,\"helmet_2\":0,\"arms\":92,\"face\":19,\"decals_1\":60,\"torso_1\":13,\"hair_2\":0,\"skin\":34,\"pants_2\":5}','{\"tshirt_2\":3,\"decals_2\":0,\"glasses\":0,\"hair_1\":2,\"torso_1\":73,\"shoes\":1,\"hair_color_2\":0,\"glasses_1\":19,\"skin\":13,\"face\":6,\"pants_2\":5,\"tshirt_1\":75,\"pants_1\":37,\"helmet_1\":57,\"torso_2\":0,\"arms\":14,\"sex\":1,\"glasses_2\":0,\"decals_1\":0,\"hair_2\":0,\"helmet_2\":0,\"hair_color_1\":0}'),
588 ('ambulance',1,'doctor','Doctor',40,'{\"tshirt_2\":0,\"hair_color_1\":5,\"glasses_2\":3,\"shoes\":9,\"torso_2\":3,\"hair_color_2\":0,\"pants_1\":24,\"glasses_1\":4,\"hair_1\":2,\"sex\":0,\"decals_2\":0,\"tshirt_1\":15,\"helmet_1\":8,\"helmet_2\":0,\"arms\":92,\"face\":19,\"decals_1\":60,\"torso_1\":13,\"hair_2\":0,\"skin\":34,\"pants_2\":5}','{\"tshirt_2\":3,\"decals_2\":0,\"glasses\":0,\"hair_1\":2,\"torso_1\":73,\"shoes\":1,\"hair_color_2\":0,\"glasses_1\":19,\"skin\":13,\"face\":6,\"pants_2\":5,\"tshirt_1\":75,\"pants_1\":37,\"helmet_1\":57,\"torso_2\":0,\"arms\":14,\"sex\":1,\"glasses_2\":0,\"decals_1\":0,\"hair_2\":0,\"helmet_2\":0,\"hair_color_1\":0}'),
589 ('ambulance',2,'chief_doctor','Chief doctor',60,'{\"tshirt_2\":0,\"hair_color_1\":5,\"glasses_2\":3,\"shoes\":9,\"torso_2\":3,\"hair_color_2\":0,\"pants_1\":24,\"glasses_1\":4,\"hair_1\":2,\"sex\":0,\"decals_2\":0,\"tshirt_1\":15,\"helmet_1\":8,\"helmet_2\":0,\"arms\":92,\"face\":19,\"decals_1\":60,\"torso_1\":13,\"hair_2\":0,\"skin\":34,\"pants_2\":5}','{\"tshirt_2\":3,\"decals_2\":0,\"glasses\":0,\"hair_1\":2,\"torso_1\":73,\"shoes\":1,\"hair_color_2\":0,\"glasses_1\":19,\"skin\":13,\"face\":6,\"pants_2\":5,\"tshirt_1\":75,\"pants_1\":37,\"helmet_1\":57,\"torso_2\":0,\"arms\":14,\"sex\":1,\"glasses_2\":0,\"decals_1\":0,\"hair_2\":0,\"helmet_2\":0,\"hair_color_1\":0}'),
590 ('ambulance',3,'boss','Surgeon',80,'{\"tshirt_2\":0,\"hair_color_1\":5,\"glasses_2\":3,\"shoes\":9,\"torso_2\":3,\"hair_color_2\":0,\"pants_1\":24,\"glasses_1\":4,\"hair_1\":2,\"sex\":0,\"decals_2\":0,\"tshirt_1\":15,\"helmet_1\":8,\"helmet_2\":0,\"arms\":92,\"face\":19,\"decals_1\":60,\"torso_1\":13,\"hair_2\":0,\"skin\":34,\"pants_2\":5}','{\"tshirt_2\":3,\"decals_2\":0,\"glasses\":0,\"hair_1\":2,\"torso_1\":73,\"shoes\":1,\"hair_color_2\":0,\"glasses_1\":19,\"skin\":13,\"face\":6,\"pants_2\":5,\"tshirt_1\":75,\"pants_1\":37,\"helmet_1\":57,\"torso_2\":0,\"arms\":14,\"sex\":1,\"glasses_2\":0,\"decals_1\":0,\"hair_2\":0,\"helmet_2\":0,\"hair_color_1\":0}')
591 ;
592
593 INSERT INTO `jobs` (name, label) VALUES
594 ('ambulance','Ambulance')
595 ;
596
597 INSERT INTO `items` (name, label, `limit`) VALUES
598 ('bandage','Bandage', 20),
599 ('medikit','Medikit', 5)
600 ;
601
602 ALTER TABLE `users` ADD `isDead` BIT(1) DEFAULT b'0'
603
604
605Install escx_mecanojob https://github.com/ESX-Org/esx_mecanojob/
606
607Run the sql
608
609
610 INSERT INTO `addon_account` (name, label, shared) VALUES
611 ('society_mecano', 'Mechanic', 1)
612 ;
613
614 INSERT INTO `addon_inventory` (name, label, shared) VALUES
615 ('society_mecano', 'Mechanic', 1)
616 ;
617
618 INSERT INTO `jobs` (name, label) VALUES
619 ('mecano', 'Mechanic')
620 ;
621
622 INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
623 ('mecano',0,'recrue','Recruit',12,'{}','{}'),
624 ('mecano',1,'novice','Novice',24,'{}','{}'),
625 ('mecano',2,'experimente','Experienced',36,'{}','{}'),
626 ('mecano',3,'chief','Leader',48,'{}','{}'),
627 ('mecano',4,'boss','Boss',0,'{}','{}')
628 ;
629
630 INSERT INTO `items` (name, label, `limit`) VALUES
631 ('gazbottle', 'Gas Bottle', 11),
632 ('fixtool', 'Repair Tools', 6),
633 ('carotool', 'Tools', 4),
634 ('blowpipe', 'Blowtorch', 10),
635 ('fixkit', 'Repair Kit', 5),
636 ('carokit', 'Body Kit', 3)
637 ;
638
639
640Install esx_vehicleshop https://github.com/ESX-Org/esx_vehicleshop
641
642
643Run the sql
644
645
646 INSERT INTO `addon_account` (name, label, shared) VALUES
647 ('society_cardealer','Concessionnaire',1)
648 ;
649
650 INSERT INTO `addon_inventory` (name, label, shared) VALUES
651 ('society_cardealer','Concesionnaire',1)
652 ;
653
654 INSERT INTO `jobs` (name, label) VALUES
655 ('cardealer','Concessionnaire')
656 ;
657
658 INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES
659 ('cardealer',0,'recruit','Recrue',10,'{}','{}'),
660 ('cardealer',1,'novice','Novice',25,'{}','{}'),
661 ('cardealer',2,'experienced','Experimente',40,'{}','{}'),
662 ('cardealer',3,'boss','Patron',0,'{}','{}')
663 ;
664
665 CREATE TABLE `cardealer_vehicles` (
666 `id` int(11) NOT NULL AUTO_INCREMENT,
667 `vehicle` varchar(255) NOT NULL,
668 `price` int(11) NOT NULL,
669 PRIMARY KEY (`id`)
670 );
671
672 CREATE TABLE `owned_vehicles` (
673
674 `id` int(11) NOT NULL AUTO_INCREMENT,
675 `vehicle` longtext NOT NULL,
676 `owner` varchar(60) NOT NULL,
677
678 PRIMARY KEY (`id`)
679 );
680
681 CREATE TABLE `rented_vehicles` (
682
683 `id` int(11) NOT NULL AUTO_INCREMENT,
684 `vehicle` varchar(60) NOT NULL,
685 `plate` varchar(10) NOT NULL,
686 `player_name` varchar(255) NOT NULL,
687 `base_price` int(11) NOT NULL,
688 `rent_price` int(11) NOT NULL,
689 `owner` varchar(255) NOT NULL,
690
691 PRIMARY KEY (`id`)
692 );
693
694 CREATE TABLE `vehicle_categories` (
695
696 `id` int(11) NOT NULL AUTO_INCREMENT,
697 `name` varchar(60) NOT NULL,
698 `label` varchar(60) NOT NULL,
699
700 PRIMARY KEY (`id`)
701 );
702
703 INSERT INTO `vehicle_categories` (name, label) VALUES
704 ('compacts','Compacts'),
705 ('coupes','Coupés'),
706 ('sedans','Sedans'),
707 ('sports','Sports'),
708 ('sportsclassics','Sports Classics'),
709 ('super','Super'),
710 ('muscle','Muscle'),
711 ('offroad','Off Road'),
712 ('suvs','SUVs'),
713 ('vans','Vans'),
714 ('motorcycles','Motos')
715 ;
716
717 CREATE TABLE `vehicles` (
718 `name` varchar(60) NOT NULL,
719 `model` varchar(60) NOT NULL,
720 `price` int(11) NOT NULL,
721 `category` varchar(60) DEFAULT NULL,
722 PRIMARY KEY (`model`)
723 );
724
725 INSERT INTO `vehicles` (name, model, price, category) VALUES
726 ('Blade','blade',15000,'muscle'),
727 ('Buccaneer','buccaneer',18000,'muscle'),
728 ('Buccaneer Rider','buccaneer2',24000,'muscle'),
729 ('Chino','chino',15000,'muscle'),
730 ('Chino Luxe','chino2',19000,'muscle'),
731 ('Coquette BlackFin','coquette3',55000,'muscle'),
732 ('Dominator','dominator',35000,'muscle'),
733 ('Dukes','dukes',28000,'muscle'),
734 ('Gauntlet','gauntlet',30000,'muscle'),
735 ('Hotknife','hotknife',125000,'muscle'),
736 ('Faction','faction',20000,'muscle'),
737 ('Faction Rider','faction2',30000,'muscle'),
738 ('Faction XL','faction3',40000,'muscle'),
739 ('Nightshade','nightshade',65000,'muscle'),
740 ('Phoenix','phoenix',12500,'muscle'),
741 ('Picador','picador',18000,'muscle'),
742 ('Sabre Turbo','sabregt',20000,'muscle'),
743 ('Sabre GT','sabregt2',25000,'muscle'),
744 ('Slam Van','slamvan3',11500,'muscle'),
745 ('Tampa','tampa',16000,'muscle'),
746 ('Virgo','virgo',14000,'muscle'),
747 ('Vigero','vigero',12500,'muscle'),
748 ('Voodoo','voodoo',7200,'muscle'),
749 ('Blista','blista',8000,'compacts'),
750 ('Brioso R/A','brioso',18000,'compacts'),
751 ('Issi','issi2',10000,'compacts'),
752 ('Panto','panto',10000,'compacts'),
753 ('Prairie','prairie',12000,'compacts'),
754 ('Bison','bison',45000,'vans'),
755 ('Bobcat XL','bobcatxl',32000,'vans'),
756 ('Burrito','burrito3',19000,'vans'),
757 ('Burrito','gburrito2',29000,'vans'),
758 ('Camper','camper',42000,'vans'),
759 ('Gang Burrito','gburrito',45000,'vans'),
760 ('Journey','journey',6500,'vans'),
761 ('Minivan','minivan',13000,'vans'),
762 ('Moonbeam','moonbeam',18000,'vans'),
763 ('Moonbeam Rider','moonbeam2',35000,'vans'),
764 ('Paradise','paradise',19000,'vans'),
765 ('Rumpo','rumpo',15000,'vans'),
766 ('Rumpo Trail','rumpo3',19500,'vans'),
767 ('Surfer','surfer',12000,'vans'),
768 ('Youga','youga',10800,'vans'),
769 ('Youga Luxuary','youga2',14500,'vans'),
770 ('Asea','asea',5500,'sedans'),
771 ('Cognoscenti','cognoscenti',55000,'sedans'),
772 ('Emperor','emperor',8500,'sedans'),
773 ('Fugitive','fugitive',12000,'sedans'),
774 ('Glendale','glendale',6500,'sedans'),
775 ('Intruder','intruder',7500,'sedans'),
776 ('Premier','premier',8000,'sedans'),
777 ('Primo Custom','primo2',14000,'sedans'),
778 ('Regina','regina',5000,'sedans'),
779 ('Schafter','schafter2',25000,'sedans'),
780 ('Stretch','stretch',90000,'sedans'),
781 ('Super Diamond','superd',130000,'sedans'),
782 ('Tailgater','tailgater',30000,'sedans'),
783 ('Warrener','warrener',4000,'sedans'),
784 ('Washington','washington',9000,'sedans'),
785 ('Baller','baller2',40000,'suvs'),
786 ('Baller Sport','baller3',60000,'suvs'),
787 ('Cavalcade','cavalcade2',55000,'suvs'),
788 ('Contender','contender',70000,'suvs'),
789 ('Dubsta','dubsta',45000,'suvs'),
790 ('Dubsta Luxuary','dubsta2',60000,'suvs'),
791 ('Fhantom','fq2',17000,'suvs'),
792 ('Grabger','granger',50000,'suvs'),
793 ('Gresley','gresley',47500,'suvs'),
794 ('Huntley S','huntley',40000,'suvs'),
795 ('Landstalker','landstalker',35000,'suvs'),
796 ('Mesa','mesa',16000,'suvs'),
797 ('Mesa Trail','mesa3',40000,'suvs'),
798 ('Patriot','patriot',55000,'suvs'),
799 ('Radius','radi',29000,'suvs'),
800 ('Rocoto','rocoto',45000,'suvs'),
801 ('Seminole','seminole',25000,'suvs'),
802 ('XLS','xls',32000,'suvs'),
803 ('Btype','btype',62000,'sportsclassics'),
804 ('Btype Luxe','btype3',85000,'sportsclassics'),
805 ('Btype Hotroad','btype2',155000,'sportsclassics'),
806 ('Casco','casco',30000,'sportsclassics'),
807 ('Coquette Classic','coquette2',40000,'sportsclassics'),
808 ('Manana','manana',12800,'sportsclassics'),
809 ('Monroe','monroe',55000,'sportsclassics'),
810 ('Pigalle','pigalle',20000,'sportsclassics'),
811 ('Stinger','stinger',80000,'sportsclassics'),
812 ('Stinger GT','stingergt',75000,'sportsclassics'),
813 ('Stirling GT','feltzer3',65000,'sportsclassics'),
814 ('Z-Type','ztype',220000,'sportsclassics'),
815 ('Bifta','bifta',12000,'offroad'),
816 ('Bf Injection','bfinjection',16000,'offroad'),
817 ('Blazer','blazer',6500,'offroad'),
818 ('Blazer Sport','blazer4',8500,'offroad'),
819 ('Brawler','brawler',45000,'offroad'),
820 ('Bubsta 6x6','dubsta3',120000,'offroad'),
821 ('Dune Buggy','dune',8000,'offroad'),
822 ('Guardian','guardian',45000,'offroad'),
823 ('Rebel','rebel2',35000,'offroad'),
824 ('Sandking','sandking',55000,'offroad'),
825 ('The Liberator','monster',210000,'offroad'),
826 ('Trophy Truck','trophytruck',60000,'offroad'),
827 ('Trophy Truck Limited','trophytruck2',80000,'offroad'),
828 ('Cognoscenti Cabrio','cogcabrio',55000,'coupes'),
829 ('Exemplar','exemplar',32000,'coupes'),
830 ('F620','f620',40000,'coupes'),
831 ('Felon','felon',42000,'coupes'),
832 ('Felon GT','felon2',55000,'coupes'),
833 ('Jackal','jackal',38000,'coupes'),
834 ('Oracle XS','oracle2',35000,'coupes'),
835 ('Sentinel','sentinel',32000,'coupes'),
836 ('Sentinel XS','sentinel2',40000,'coupes'),
837 ('Windsor','windsor',95000,'coupes'),
838 ('Windsor Drop','windsor2',125000,'coupes'),
839 ('Zion','zion',36000,'coupes'),
840 ('Zion Cabrio','zion2',45000,'coupes'),
841 ('9F','ninef',65000,'sports'),
842 ('9F Cabrio','ninef2',80000,'sports'),
843 ('Alpha','alpha',60000,'sports'),
844 ('Banshee','banshee',70000,'sports'),
845 ('Bestia GTS','bestiagts',55000,'sports'),
846 ('Buffalo','buffalo',12000,'sports'),
847 ('Buffalo S','buffalo2',20000,'sports'),
848 ('Carbonizzare','carbonizzare',75000,'sports'),
849 ('Comet','comet2',65000,'sports'),
850 ('Coquette','coquette',65000,'sports'),
851 ('Drift Tampa','tampa2',80000,'sports'),
852 ('Elegy','elegy2',38500,'sports'),
853 ('Feltzer','feltzer2',55000,'sports'),
854 ('Furore GT','furoregt',45000,'sports'),
855 ('Fusilade','fusilade',40000,'sports'),
856 ('Jester','jester',65000,'sports'),
857 ('Jester(Racecar)','jester2',135000,'sports'),
858 ('Khamelion','khamelion',38000,'sports'),
859 ('Kuruma','kuruma',30000,'sports'),
860 ('Lynx','lynx',40000,'sports'),
861 ('Mamba','mamba',70000,'sports'),
862 ('Massacro','massacro',65000,'sports'),
863 ('Massacro(Racecar)','massacro2',130000,'sports'),
864 ('Omnis','omnis',35000,'sports'),
865 ('Penumbra','penumbra',28000,'sports'),
866 ('Rapid GT','rapidgt',35000,'sports'),
867 ('Rapid GT Convertible','rapidgt2',45000,'sports'),
868 ('Schafter V12','schafter3',50000,'sports'),
869 ('Seven 70','seven70',39500,'sports'),
870 ('Sultan','sultan',15000,'sports'),
871 ('Surano','surano',50000,'sports'),
872 ('Tropos','tropos',40000,'sports'),
873 ('Verlierer','verlierer2',70000,'sports'),
874 ('Adder','adder',900000,'super'),
875 ('Banshee 900R','banshee2',255000,'super'),
876 ('Bullet','bullet',90000,'super'),
877 ('Cheetah','cheetah',375000,'super'),
878 ('Entity XF','entityxf',425000,'super'),
879 ('ETR1','sheava',220000,'super'),
880 ('FMJ','fmj',185000,'super'),
881 ('Infernus','infernus',180000,'super'),
882 ('Osiris','osiris',160000,'super'),
883 ('Pfister','pfister811',85000,'super'),
884 ('RE-7B','le7b',325000,'super'),
885 ('Reaper','reaper',150000,'super'),
886 ('Sultan RS','sultanrs',65000,'super'),
887 ('T20','t20',300000,'super'),
888 ('Turismo R','turismor',350000,'super'),
889 ('Tyrus','tyrus',600000,'super'),
890 ('Vacca','vacca',120000,'super'),
891 ('Voltic','voltic',90000,'super'),
892 ('X80 Proto','prototipo',2500000,'super'),
893 ('Zentorno','zentorno',1500000,'super'),
894 ('Akuma','AKUMA',7500,'motorcycles'),
895 ('Avarus','avarus',18000,'motorcycles'),
896 ('Bagger','bagger',13500,'motorcycles'),
897 ('Bati 801','bati',12000,'motorcycles'),
898 ('Bati 801RR','bati2',19000,'motorcycles'),
899 ('BF400','bf400',6500,'motorcycles'),
900 ('BMX (velo)','bmx',160,'motorcycles'),
901 ('Carbon RS','carbonrs',18000,'motorcycles'),
902 ('Chimera','chimera',38000,'motorcycles'),
903 ('Cliffhanger','cliffhanger',9500,'motorcycles'),
904 ('Cruiser (velo)','cruiser',510,'motorcycles'),
905 ('Daemon','daemon',11500,'motorcycles'),
906 ('Daemon High','daemon2',13500,'motorcycles'),
907 ('Defiler','defiler',9800,'motorcycles'),
908 ('Double T','double',28000,'motorcycles'),
909 ('Enduro','enduro',5500,'motorcycles'),
910 ('Esskey','esskey',4200,'motorcycles'),
911 ('Faggio','faggio',1900,'motorcycles'),
912 ('Vespa','faggio2',2800,'motorcycles'),
913 ('Fixter (velo)','fixter',225,'motorcycles'),
914 ('Gargoyle','gargoyle',16500,'motorcycles'),
915 ('Hakuchou','hakuchou',31000,'motorcycles'),
916 ('Hakuchou Sport','hakuchou2',55000,'motorcycles'),
917 ('Hexer','hexer',12000,'motorcycles'),
918 ('Innovation','innovation',23500,'motorcycles'),
919 ('Manchez','manchez',5300,'motorcycles'),
920 ('Nemesis','nemesis',5800,'motorcycles'),
921 ('Nightblade','nightblade',35000,'motorcycles'),
922 ('PCJ-600','pcj',6200,'motorcycles'),
923 ('Ruffian','ruffian',6800,'motorcycles'),
924 ('Sanchez','sanchez',5300,'motorcycles'),
925 ('Sanchez Sport','sanchez2',5300,'motorcycles'),
926 ('Sanctus','sanctus',25000,'motorcycles'),
927 ('Scorcher (velo)','scorcher',280,'motorcycles'),
928 ('Sovereign','sovereign',22000,'motorcycles'),
929 ('Shotaro Concept','shotaro',320000,'motorcycles'),
930 ('Thrust','thrust',24000,'motorcycles'),
931 ('Tri bike (velo)','tribike3',520,'motorcycles'),
932 ('Vader','vader',7200,'motorcycles'),
933 ('Vortex','vortex',9800,'motorcycles'),
934 ('Woflsbane','wolfsbane',9000,'motorcycles'),
935 ('Zombie','zombiea',9500,'motorcycles'),
936 ('Zombie Luxuary','zombieb',12000,'motorcycles'),
937 ('blazer5', 'blazer5', 1755600, 'offroad'),
938 ('Ruiner 2', 'ruiner2', 5745600, 'muscle'),
939 ('Voltic 2', 'voltic2', 3830400, 'super'),
940 ('Ardent', 'ardent', 1150000, 'sportsclassics'),
941 ('Oppressor', 'oppressor', 3524500, 'super'),
942 ('Visione', 'visione', 2250000, 'super'),
943 ('Retinue', 'retinue', 615000, 'sportsclassics'),
944 ('Cyclone', 'cyclone', 1890000, 'super'),
945 ('Rapid GT3', 'rapidgt3', 885000, 'sportsclassics'),
946 ('raiden', 'raiden', 1375000, 'sports'),
947 ('Yosemite', 'yosemite', 485000, 'muscle'),
948 ('Deluxo', 'deluxo', 4721500, 'sportsclassics'),
949 ('Pariah', 'pariah', 1420000, 'sports'),
950 ('Stromberg', 'stromberg', 3185350, 'sports'),
951 ('SC 1', 'sc1', 1603000, 'super'),
952 ('riata', 'riata', 380000, 'offroad'),
953 ('Hermes', 'hermes', 535000, 'muscle'),
954 ('Savestra', 'savestra', 990000, 'sportsclassics'),
955 ('Streiter', 'streiter', 500000, 'sports'),
956 ('Kamacho', 'kamacho', 345000, 'offroad'),
957 ('GT 500', 'gt500', 785000, 'sportsclassics'),
958 ('Z190', 'z190', 900000, 'sportsclassics'),
959 ('Viseris', 'viseris', 875000, 'sportsclassics'),
960 ('Autarch', 'autarch', 1955000, 'super'),
961 ('Comet 5', 'comet5', 1145000, 'sports'),
962 ('Neon', 'neon', 1500000, 'sports'),
963 ('Revolter', 'revolter', 1610000, 'sports'),
964 ('Sentinel3', 'sentinel3', 650000, 'sports'),
965 ('Hustler', 'hustler', 625000, 'muscle')
966 ;