· 5 years ago · May 16, 2020, 11:08 AM
1-- --------------------------------------------------------
2-- Host: 127.0.0.1
3-- Server version: 10.4.7-MariaDB - mariadb.org binary distribution
4-- Server OS: Win64
5-- HeidiSQL Version: 11.0.0.5919
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8 */;
10/*!50503 SET NAMES utf8mb4 */;
11/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
12/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
13
14
15-- Dumping database structure for takistan-life
16CREATE DATABASE IF NOT EXISTS `takistan-life` /*!40100 DEFAULT CHARACTER SET utf8 */;
17USE `takistan-life`;
18
19-- Dumping structure for table takistan-life.citations
20CREATE TABLE IF NOT EXISTS `citations` (
21 `id` int(11) NOT NULL AUTO_INCREMENT,
22 `uid` varchar(50) DEFAULT NULL,
23 `officer` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
24 `civilian` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
25 `reason` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
26 `price` int(11) DEFAULT 0,
27 PRIMARY KEY (`id`)
28) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
29
30-- Dumping data for table takistan-life.citations: ~2 rows (approximately)
31/*!40000 ALTER TABLE `citations` DISABLE KEYS */;
32INSERT IGNORE INTO `citations` (`id`, `uid`, `officer`, `civilian`, `reason`, `price`) VALUES
33 (1, '76561198427415147', 'ONTL_Player_1', 'ONTL_Player', 'Testing Testing', 10);
34/*!40000 ALTER TABLE `citations` ENABLE KEYS */;
35
36-- Dumping structure for procedure takistan-life.deleteDeadVehicles
37DELIMITER //
38CREATE PROCEDURE `deleteDeadVehicles`()
39BEGIN
40 DELETE FROM `vehicles` WHERE `destroyed` = 1;
41END//
42DELIMITER ;
43
44-- Dumping structure for procedure takistan-life.deleteOldGangs
45DELIMITER //
46CREATE PROCEDURE `deleteOldGangs`()
47BEGIN
48 DELETE FROM `gangs` WHERE `active` = 0;
49END//
50DELIMITER ;
51
52-- Dumping structure for table takistan-life.gangs
53CREATE TABLE IF NOT EXISTS `gangs` (
54 `id` int(11) NOT NULL AUTO_INCREMENT,
55 `owner` varchar(17) NOT NULL,
56 `name` varchar(32) DEFAULT NULL,
57 `members` text DEFAULT NULL,
58 `maxmembers` int(11) DEFAULT 8,
59 `bank` int(11) DEFAULT 0,
60 `active` tinyint(4) NOT NULL DEFAULT 1,
61 `insert_time` timestamp NOT NULL DEFAULT current_timestamp(),
62 PRIMARY KEY (`id`),
63 UNIQUE KEY `unique_name` (`name`)
64) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
65
66-- Dumping data for table takistan-life.gangs: ~0 rows (approximately)
67/*!40000 ALTER TABLE `gangs` DISABLE KEYS */;
68/*!40000 ALTER TABLE `gangs` ENABLE KEYS */;
69
70-- Dumping structure for table takistan-life.government
71CREATE TABLE IF NOT EXISTS `government` (
72 `id` int(11) NOT NULL AUTO_INCREMENT,
73 `president_uid` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '0',
74 `president_name` int(11) DEFAULT NULL,
75 `president_laws` mediumtext CHARACTER SET utf8 DEFAULT NULL,
76 PRIMARY KEY (`id`),
77 KEY `governor` (`president_uid`) USING BTREE
78) ENGINE=InnoDB DEFAULT CHARSET=latin1;
79
80-- Dumping data for table takistan-life.government: ~0 rows (approximately)
81/*!40000 ALTER TABLE `government` DISABLE KEYS */;
82/*!40000 ALTER TABLE `government` ENABLE KEYS */;
83
84-- Dumping structure for table takistan-life.messages
85CREATE TABLE IF NOT EXISTS `messages` (
86 `id` int(11) NOT NULL AUTO_INCREMENT,
87 `uid` varchar(50) DEFAULT NULL,
88 `subject` varchar(50) DEFAULT NULL,
89 `sender` varchar(50) DEFAULT NULL,
90 `message` varchar(50) DEFAULT NULL,
91 `time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
92 PRIMARY KEY (`id`),
93 KEY `uid` (`uid`)
94) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
95
96-- Dumping data for table takistan-life.messages: ~13 rows (approximately)
97/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
98INSERT IGNORE INTO `messages` (`id`, `uid`, `subject`, `sender`, `message`, `time`) VALUES
99 (1, '76561198011619688', 'BOSS', 'Wyn Haldeman', 'Hi boss', '2020-05-15 20:34:59'),
100 (2, '76561198059005778', 'Yo', '[NATO] Cpt. A. Kenyatta', 'Hello sir', '2020-05-15 20:35:59'),
101 (3, '76561198116643767', 'Apex', 'Jacob Spreezy', 'come here (face palm)', '2020-05-15 21:08:37'),
102 (4, '76561198427415147', 'Hi', '[NATO] Cpt. A. Kenyatta', 'At red cross hq', '2020-05-15 21:09:20'),
103 (5, '76561198116643767', 'a', 'Jacob Spreezy', 'tp to me ', '2020-05-15 21:09:50'),
104 (6, '76561198427415147', 'Hi', '[NATO] Cpt. A. Kenyatta', 'On as NATO atm', '2020-05-15 21:10:15'),
105 (7, '76561198116643767', 'what should i do', 'Jacob Spreezy', '.', '2020-05-15 21:13:24'),
106 (8, '76561198059005778', 'Yall need a new dev', 'Xon Yoyo Nguyen', 'Yall need new dev', '2020-05-15 21:18:37'),
107 (9, '76561198157328172', 'xD', '[NATO] Gen. N. Turner', 'Xd', '2020-05-15 21:19:06'),
108 (10, '76561198116643767', 'tfr', 'Jacob Spreezy', 'DFD', '2020-05-15 23:19:39'),
109 (11, '76561198427415147', 'pussy', 'Lucas Ossas', 'That izzy bird must have a tight snatch ', '2020-05-15 23:20:11'),
110 (12, '76561198427415147', 'tfr', '[NATO] Cpt. A. Kenyatta', 'Give me a couple of things currently', '2020-05-15 23:20:28'),
111 (13, '76561198116643767', 'roleplay', 'Lucas Ossas', 'hands up', '2020-05-15 23:21:23');
112/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
113
114-- Dumping structure for table takistan-life.players
115CREATE TABLE IF NOT EXISTS `players` (
116 `id` int(11) NOT NULL AUTO_INCREMENT,
117 `uid` varchar(50) DEFAULT NULL,
118 `all_names` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
119 `last_name` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
120 `cash` int(11) DEFAULT NULL,
121 `bank` int(11) DEFAULT NULL,
122 `dirty` int(11) DEFAULT NULL,
123 `xp` int(11) DEFAULT NULL,
124 `level` int(11) DEFAULT NULL,
125 `talents` mediumtext CHARACTER SET utf8 DEFAULT NULL,
126 `mytransactions` mediumtext CHARACTER SET utf8 DEFAULT NULL,
127 `gear` text CHARACTER SET utf8 DEFAULT NULL,
128 `licenses` text CHARACTER SET utf8 DEFAULT NULL,
129 `NATO_rank` enum('0','1','2','3','4','5','6','7','8','9','10','11','12') CHARACTER SET utf8 DEFAULT '0',
130 `RC_rank` enum('0','1','2','3','4','5','6','7') CHARACTER SET utf8 DEFAULT '0',
131 `alive` int(1) DEFAULT NULL,
132 `jailed` text CHARACTER SET utf8 DEFAULT NULL,
133 `adminlevel` enum('0','1','2','3') CHARACTER SET utf8 DEFAULT '0',
134 PRIMARY KEY (`id`),
135 KEY `uid` (`uid`)
136) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
137
138-- Dumping data for table takistan-life.players: ~12 rows (approximately)
139/*!40000 ALTER TABLE `players` DISABLE KEYS */;
140INSERT IGNORE INTO `players` (`id`, `uid`, `all_names`, `last_name`, `cash`, `bank`, `dirty`, `xp`, `level`, `talents`, `mytransactions`, `gear`, `licenses`, `NATO_rank`, `RC_rank`, `alive`, `jailed`, `adminlevel`) VALUES
141 (1, '76561198059005778', '[NATO] Gen. N. Turner', '"[`[NATO] Gen. N. Turner`]"', 0, 10000, 0, 9, 0, '"[`Athlete``]"', '"[[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`]]"', '"[[`rhs_weap_m4a1_blockII_grip`,``,``,`rhsusf_acc_compm4`,[`rhs_mag_30Rnd_556x45_M855A1_Stanag`,30],[],`rhsusf_acc_kac_grip`],[],[`taser`,``,``,``,[`vvv_np_magazine_taser`,1],[],``],[`rhs_uniform_FROG01_d`,[[`ItemCompass`,1],[`rhs_mag_30Rnd_556x45_M855A1_Stanag`,3,30]]],[`TRYK_V_ArmorVest_AOR1`,[[`rhs_mag_30Rnd_556x45_M855A1_Stanag`,7,30],[`vvv_np_magazine_taser`,6,1]]],[`invisible_backpack`,[[`FirstAidKit`,6],[`vvv_np_magazine_taser`,9,1]]],`H_Beret_Colonel`,``,[],[`ItemMap`,`ItemGPS`,`tf_anprc152_1`,`ItemCompass`,``,``]]"', '"[]"', '12', '7', 0, '"[[false,`N/A`,0,``,false]]"', '3'),
142 (2, '76561198116643767', '[NATO] Cpt. A. Kenyatta', '"[`[NATO] Cpt. A. Kenyatta`]"', 0, 0, 0, 503, 3, '"[`Athlete`,`XP Boost 1`,`XP Boost 2`]"', '"[[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`withdrawal $5,000`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`withdrawal $100`],[`-`,`Clothing Purchase $615`],[`-`,`Drivers License $100`],[`-`,`withdrawal $300`],[`-`,`withdrawal $300`],[`-`,`withdrawal $1,000`],[`-`,`withdrawal $1,000`],[`-`,`withdrawal $1,000`],[`-`,`withdrawal $1,000`],[`-`,`Firearms License $300`],[`-`,`withdrawal $1,445`],[`-`,`Terrorist Training $100,000`],[`-`,`Bank Transfer $16,556`],[`-`,`Explosives Training $50,000`]]"', '"[[],[],[],[`mgsr_robe`,[]],[],[],``,``,[],[``,``,``,``,``,``]]"', '"[`driver`,`fl`,`terrorist`,`bomber`]"', '5', '5', 0, '"[[false,`N/A`,0,``,false]]"', '3'),
143 (3, '76561198088804487', 'Ayrton Mead', '"[`Ayrton Mead`]"', 0, 410000, 0, 3, 0, '"[]"', '"[[`-`,`Bank Transfer $50,000`],[`-`,`withdrawal $50,000`],[`-`,`Drivers License $100`],[`-`,`Passport $300`]]"', '"[[`rhs_weap_mg42`,``,``,``,[`rhsgref_50Rnd_792x57_SmE_drum`,50],[],``],[],[`rhs_weap_pb_6p9`,`rhs_acc_6p9_suppressor`,``,``,[`rhs_mag_9x18_8_57N181S`,8],[],``],[`U_Tank_green_F`,[[`FirstAidKit`,1],[`rhsgref_50Rnd_792x57_SmE_drum`,1,50]]],[`V_BandollierB_blk`,[[`MiniGrenade`,1,1],[`rhsgref_50Rnd_792x57_SmE_drum`,2,50],[`rhs_mag_9x18_8_57N181S`,3,8]]],[],``,``,[],[`ItemMap`,``,`tf_anprc152_19`,`ItemCompass`,`Itemwatch`,``]]"', '"[`driver`,`passport`]"', '8', '7', 0, '"[[false,`N/A`,0,``,false]]"', '3'),
144 (4, '76561198011619688', 'Max Conway', '"[`Max Conway`]"', 0, 57300, 0, 0, 0, '"[]"', '"[[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`+`,`Bank Transfer $`],[`-`,`Drivers License $100`],[`-`,`Passport $300`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`withdrawal $100`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`]]"', '"[[],[],[`RH_gsh18`,``,``,``,[`RH_18Rnd_9x19_gsh`,0],[],``],[`U_C_Paramedic_01_F`,[[`FirstAidKit`,3]]],[`TRYK_V_ArmorVest_AOR1`,[]],[`invisible_backpack`,[[`Medikit`,1],[`NP_PoliceBarrierL`,4,1],[`NP_PoliceBarrierS`,5,1]]],`H_Beret_02`,`G_Respirator_blue_F`,[`Rangefinder`,``,``,``,[],[],``],[`ItemMap`,`ItemGPS`,`tf_anprc152_8`,`ItemCompass`,`Itemwatch`,``]]"', '"[`driver`,`passport`]"', '0', '7', 0, '"[[false,`N/A`,0,``,false]]"', '0'),
145 (5, '76561198037666754', 'Troy', '"[`Troy`]"', 0, 0, 0, 0, 0, '"[]"', '"[]"', '"[[],[],[],[`U_B_CombatUniform_mcam`,[]],[],[],``,``,[],[``,``,``,``,`tf_microdagr`,``]]"', '"[]"', '0', '0', 0, '"[[false,`N/A`,0,``,false]]"', '0'),
146 (6, '76561198203705364', '[NATO] Sgt. A. Saints', '"[`[NATO] Sgt. A. Saints`]"', 0, 9900, 0, 0, 0, '"[]"', '"[[`-`,`withdrawal $100`],[`-`,`Drivers License $100`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`]]"', '"[[`TRU_weap_M4A1CQBR_grip3`,``,`CUP_acc_Flashlight_desert`,`CUP_optic_HensoldtZO_RDS_coyote_PIP`,[`rhs_mag_30Rnd_556x45_M855A1_Stanag`,30],[],`rhsusf_acc_kac_grip`],[],[`taser`,``,``,``,[`vvv_np_magazine_taser`,1],[],``],[`rhs_uniform_FROG01_d`,[[`SmokeShellYellow`,2,1],[`vvv_np_magazine_taser`,1,1],[`CG_Spikes_Collapsed`,2,1],[`rhs_mag_30Rnd_556x45_M855A1_Stanag`,2,30]]],[`TRYK_V_ArmorVest_AOR1`,[[`rhs_mag_30Rnd_556x45_M855A1_Stanag`,3,30],[`vvv_np_magazine_taser`,3,1],[`SmokeShellYellow`,3,1]]],[`invisible_backpack`,[[`FirstAidKit`,6],[`NP_PoliceBarrierL`,3,1]]],`rhsusf_lwh_helmet_marpatd_headset`,``,[],[`ItemMap`,`ItemGPS`,``,`ItemCompass`,``,``]]"', '"[`driver`]"', '4', '0', 0, '"[[false,`N/A`,0,``,false]]"', '0'),
147 (7, '76561198093864253', 'Michael Johnson', '"[`Michael Johnson`]"', 0, 10000, 0, 0, 0, '"[]"', '"[]"', '"[[`CUP_srifle_m110_kac_black`,``,``,`rhsusf_acc_LEUPOLDMK4_2_mrds`,[`CUP_20Rnd_762x51_B_M110`,20],[],``],[],[`rhsusf_weap_glock17g4`,``,``,``,[],[],``],[`rhs_uniform_FROG01_d`,[[`CUP_20Rnd_762x51_B_M110`,1,20],[`rhsusf_mag_17Rnd_9x19_FMJ`,2,17],[[`rhsusf_weap_glock17g4`,``,``,``,[],[],``],1]]],[`TRYK_V_ArmorVest_AOR1`,[[`CUP_20Rnd_762x51_B_M110`,8,20],[`vvv_np_magazine_taser`,1,1]]],[`invisible_backpack`,[[`CUP_20Rnd_762x51_B_M110`,6,20],[`vvv_np_magazine_taser`,10,1],[`rhsusf_mag_17Rnd_9x19_FMJ`,12,17],[[`taser`,``,``,``,[],[],``],1]]],`H_Beret_02`,``,[],[`ItemMap`,``,``,`ItemCompass`,``,``]]"', '"[]"', '8', '0', 0, '"[[false,`N/A`,0,``,false]]"', '0'),
148 (8, '76561198096084846', 'Stringtheory', '"[`Stringtheory`]"', 0, 10000, 0, 0, 0, '"[]"', '"[]"', '"[[],[],[],[`CUP_U_C_Citizen_04`,[]],[],[],``,``,[],[`ItemMap`,``,``,`ItemCompass`,`tf_microdagr`,``]]"', '"[]"', '0', '0', 0, '"[[false,`N/A`,0,``,false]]"', '0'),
149 (9, '76561198095786770', 'Baba Yaga', '"[`Baba Yaga`]"', 0, 4900, 0, 0, 0, '"[]"', '"[[`-`,`withdrawal $100`],[`-`,`Drivers License $100`],[`-`,`withdrawal $5,000`],[`-`,`Vehicle Purchase $5,000`],[`-`,`Passport $300`],[`-`,`Vehicle Rental $0`],[`-`,`Vehicle Rental $0`]]"', '"[[],[],[],[`U_B_CombatUniform_mcam`,[]],[],[],``,``,[],[``,``,``,``,`tf_microdagr`,``]]"', '"[`driver`,`passport`]"', '0', '3', 0, '"[[false,`N/A`,0,``,false]]"', '0'),
150 (10, '76561198427415147', 'Jacob Spreezy', '"[`Jacob Spreezy`]"', 0, 2853760, 0, 12, 2, '"[`Athlete`]"', '"[[`-`,`withdrawal $10,011`],[`-`,`withdrawal $1,001`],[`-`,`withdrawal $1,001`],[`-`,`Drivers License $100`],[`-`,`Clothing Purchase $615`],[`-`,`Vehicle Purchase $10,000`],[`-`,`withdrawal $1,001`],[`-`,`withdrawal $1,001`],[`-`,`withdrawal $1,001`],[`-`,`withdrawal $1,001`],[`-`,`withdrawal $1,001`],[`-`,`withdrawal $1,001`],[`-`,`withdrawal $1,001`],[`-`,`withdrawal $1,001`],[`-`,`withdrawal $1,001`],[`-`,`Firearms License $300`],[`-`,`Terrorist Training $100,000`],[`-`,`Explosives Training $50,000`],[`-`,`Clothing Purchase $150,015`],[`-`,`Clothing Purchase $15`],[`-`,`Clothing Purchase $30,000`],[`+`,`Bank Transfer $`],[`-`,`withdrawal $100,111`],[`-`,`Clothing Purchase $150,000`],[`-`,`withdrawal $10,011`],[`-`,`withdrawal $10,011`],[`-`,`withdrawal $10,011`],[`-`,`withdrawal $10,011`],[`-`,`withdrawal $10,011`],[`-`,`withdrawal $100,111`],[`-`,`withdrawal $100,111`],[`-`,`withdrawal $100,111`],[`-`,`withdrawal $100,111`],[`-`,`withdrawal $100,111`],[`-`,`withdrawal $100,111`],[`-`,`withdrawal $100,111`],[`-`,`withdrawal $100,111`],[`-`,`withdrawal $100,111`],[`-`,`withdrawal $100,111`],[`-`,`withdrawal $100,111`],[`-`,`withdrawal $100,111`],[`-`,`withdrawal $100,111`],[`-`,`withdrawal $100,111`],[`-`,`withdrawal $100,111`],[`-`,`withdrawal $100,111`],[`-`,`withdrawal $100,111`],[`-`,`withdrawal $100,111`],[`-`,`Vehicle Purchase $10,000`],[`-`,`Vehicle Purchase $25,000`],[`-`,`Vehicle Purchase $150,000`],[`-`,`Vehicle Purchase $1,400,000`],[`-`,`withdrawal $10,011`],[`-`,`withdrawal $10,011`],[`-`,`withdrawal $10,011`],[`-`,`withdrawal $10,011`],[`-`,`withdrawal $10,011`],[`-`,`Vehicle retrieval $9,905`]]"', '"[[],[],[],[`CUP_U_C_Woodlander_01`,[]],[],[],``,``,[],[`ItemMap`,``,``,`ItemCompass`,`Itemwatch`,``]]"', '"[`driver`,`fl`,`terrorist`,`bomber`]"', '0', '0', 0, '"[[false,`N/A`,0,``,false]]"', '0'),
151 (11, '76561198157328172', 'Xon Yoyo Nguyen', '"[`Xon Yoyo Nguyen`]"', 0, 10000, 0, 0, 0, '"[`Athlete`,`Athlete`]"', '"[[`-`,`Vehicle Rental $0`]]"', '"[[`rhs_weap_mk17_STD`,``,``,`CUP_optic_HensoldtZO_RDS_coyote_PIP`,[`rhs_mag_20Rnd_SCAR_762x51_m80_ball`,18],[],``],[],[],[`rhs_uniform_FROG01_d`,[[`rhs_mag_20Rnd_SCAR_762x51_m80_ball`,1,15]]],[`TRYK_V_ArmorVest_AOR1`,[[`rhsusf_acc_kac_grip`,3],[`rhs_mag_20Rnd_SCAR_762x51_m80_ball`,1,4],[`rhs_mag_20Rnd_SCAR_762x51_m80_ball`,1,15]]],[`invisible_backpack`,[[`FirstAidKit`,4]]],`H_Beret_02`,``,[],[`ItemMap`,`ItemGPS`,`tf_anprc152_12`,`ItemCompass`,``,``]]"', '"[]"', '11', '0', 0, '"[[false,`N/A`,0,``,false]]"', '0'),
152 (12, '76561198842733654', 'Lucas Ossas', '"[`Lucas Ossas`]"', 0, 841111, 0, 0, 2, '"[]"', '"[[`-`,`withdrawal $100`],[`-`,`withdrawal $9,900`],[`-`,`Vehicle Purchase $10,000`],[`-`,`Clothing Purchase $15`],[`-`,`Clothing Purchase $600`],[`-`,`Firearms License $300`],[`-`,`Terrorist Training $100,000`],[`-`,`Explosives Training $50,000`],[`-`,`Clothing Purchase $150,015`],[`-`,`Clothing Purchase $15`],[`-`,`Vehicle Purchase $20,000`],[`-`,`withdrawal $10,000`],[`-`,`withdrawal $10,000`],[`-`,`Vehicle Purchase $20,000`],[`-`,`Clothing Purchase $15`],[`-`,`Clothing Purchase $150,000`],[`-`,`Clothing Purchase $1,000`],[`-`,`Clothing Purchase $30,000`],[`-`,`withdrawal $100,000`]]"', '"[[`rhs_weap_mg42`,``,``,``,[`rhsgref_50Rnd_792x57_SmE_drum`,50],[],``],[`rhs_weap_rshg2_used`,``,``,``,[],[],``],[],[`CUP_U_B_CZ_DST_Ghillie`,[[`FirstAidKit`,2],[`D_Ziptie_i`,2,1],[`rhsgref_50Rnd_792x57_SmE_drum`,1,50],[`rhsgref_50Rnd_792x57_SmE_drum`,1,29]]],[`SuicideVest_olive`,[]],[`invisible_backpack`,[[`rhsgref_50Rnd_792x57_SmE_drum`,1,50],[`CUP_HandGrenade_RGD5`,4,1],[[`rhs_weap_rshg2`,``,``,``,[],[],``],1],[[`rhs_weap_rshg2`,``,``,``,[],[],``],1]]],``,``,[`Binocular`,``,``,``,[],[],``],[`ItemMap`,``,``,`ItemCompass`,`Itemwatch`,`NVGoggles_OPFOR`]]"', '"[`fl`,`terrorist`,`bomber`]"', '0', '0', 0, '"[[false,`N/A`,0,``,false]]"', '0');
153/*!40000 ALTER TABLE `players` ENABLE KEYS */;
154
155-- Dumping structure for procedure takistan-life.resetLifeVehicles
156DELIMITER //
157CREATE PROCEDURE `resetLifeVehicles`()
158BEGIN
159 UPDATE `vehicles` SET `active`= 0;
160END//
161DELIMITER ;
162
163-- Dumping structure for table takistan-life.vehicles
164CREATE TABLE IF NOT EXISTS `vehicles` (
165 `id` int(11) NOT NULL AUTO_INCREMENT,
166 `owner` varchar(50) DEFAULT NULL,
167 `classname` varchar(50) NOT NULL DEFAULT '',
168 `inventory` text DEFAULT NULL,
169 `status` text DEFAULT NULL,
170 `color` int(11) DEFAULT NULL,
171 `active` int(1) DEFAULT 1,
172 `impounded` int(1) DEFAULT 0,
173 `destroyed` int(1) DEFAULT 0,
174 `garage` varchar(50) DEFAULT NULL,
175 PRIMARY KEY (`id`)
176) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
177
178-- Dumping data for table takistan-life.vehicles: ~9 rows (approximately)
179/*!40000 ALTER TABLE `vehicles` DISABLE KEYS */;
180INSERT IGNORE INTO `vehicles` (`id`, `owner`, `classname`, `inventory`, `status`, `color`, `active`, `impounded`, `destroyed`, `garage`) VALUES
181 (1, '76561198427415147', 'ivory_gti', '"[[[],[]],[[],[]],[[],[]],[[],[]]]"', '"[[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,-1]"', -1, 0, 0, 0, 'garage_4'),
182 (2, '76561198095786770', 'ivory_cv', '"[[[],[]],[[],[]],[[],[]],[[],[]]]"', '"[[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,-1]"', -1, 0, 0, 0, 'garage_4'),
183 (3, '76561198842733654', 'ivory_gti', '"[[[],[]],[[],[]],[[],[]],[[],[]]]"', '"[[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,-1]"', -1, 0, 0, 0, 'garage_4'),
184 (4, '76561198842733654', 'ivory_e36', '"[[[],[]],[[],[]],[[],[]],[[],[]]]"', '"[[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,-1]"', -1, 0, 0, 0, 'garage_2'),
185 (5, '76561198842733654', 'ivory_e36', '"[[[],[]],[[],[]],[[],[]],[[],[]]]"', '"[[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,-1]"', -1, 0, 0, 0, 'garage_1'),
186 (6, '76561198427415147', 'ivory_prius', '"[[[],[]],[[],[]],[[],[]],[[],[]]]"', '"[[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,-1]"', -1, 0, 0, 0, 'garage_1'),
187 (7, '76561198427415147', 'ivory_charger', '"[[[],[]],[[],[]],[[],[]],[[],[]]]"', '"[[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,-1]"', -1, 1, 0, 0, 'garage_1'),
188 (8, '76561198427415147', 'ivory_ccx', '"[[[],[]],[[],[]],[[],[]],[[],[]]]"', '"[[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,-1]"', -1, 0, 0, 0, 'garage_1'),
189 (9, '76561198427415147', 'ivory_rev', '"[[[],[]],[[],[]],[[],[]],[[],[]]]"', '"[[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,-1]"', -1, 0, 0, 0, 'garage_1');
190/*!40000 ALTER TABLE `vehicles` ENABLE KEYS */;
191
192/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
193/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
194/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;