· 6 years ago · Nov 27, 2019, 07:18 PM
1-- --------------------------------------------------------
2-- Vært: 127.0.0.1
3-- Server-version: 10.1.37-MariaDB - mariadb.org binary distribution
4-- ServerOS: Win32
5-- HeidiSQL Version: 10.2.0.5599
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 cglife
16CREATE DATABASE IF NOT EXISTS `cglife` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
17USE `cglife`;
18
19-- Dumping structure for tabel cglife.containers
20CREATE TABLE IF NOT EXISTS `containers` (
21 `id` int(11) NOT NULL AUTO_INCREMENT,
22 `pid` varchar(17) NOT NULL,
23 `classname` varchar(32) NOT NULL,
24 `pos` varchar(32) DEFAULT NULL,
25 `inventory` text NOT NULL,
26 `gear` text NOT NULL,
27 `dir` varchar(128) DEFAULT NULL,
28 `active` tinyint(4) NOT NULL DEFAULT '0',
29 `owned` tinyint(4) NOT NULL DEFAULT '0',
30 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
31 PRIMARY KEY (`id`),
32 KEY `fkIdx_players_containers` (`pid`),
33 CONSTRAINT `FK_players_containers` FOREIGN KEY (`pid`) REFERENCES `players` (`pid`) ON DELETE CASCADE ON UPDATE CASCADE
34) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4;
35
36-- Dumping data for table cglife.containers: ~4 rows (approximately)
37/*!40000 ALTER TABLE `containers` DISABLE KEYS */;
38INSERT INTO `containers` (`id`, `pid`, `classname`, `pos`, `inventory`, `gear`, `dir`, `active`, `owned`, `insert_time`) VALUES
39 (1, '76561198019683075', 'B_supplyCrate_F', '[5374.35,3046.49,1.29606]', '"[[],0]"', '"[[[],[]],[[],[]],[[],[]],[[],[]]]"', '[[-0.163757,-0.986501,0],[0,0,1]]', 0, 1, '2019-10-22 13:16:34'),
40 (2, '76561198019683075', 'B_supplyCrate_F', '[5374.1,3048.41,0.596059]', '"[[],0]"', '"[[[],[]],[[],[]],[[],[]],[[],[]]]"', '[[-0.247925,-0.968779,0],[0,0,1]]', 0, 1, '2019-10-22 13:16:40'),
41 (3, '76561198019683075', 'B_supplyCrate_F', '[5377.88,3049.7,1.29606]', '"[[],0]"', '"[[[],[]],[[],[]],[[],[]],[[],[]]]"', '[[0.00537109,0.999986,0],[0,0,1]]', 0, 1, '2019-10-22 13:36:52'),
42 (4, '76561198014534906', 'B_supplyCrate_F', '[5343.21,3021.86,1.13667]', '"[[],0]"', '"[[[],[]],[[],[]],[[],[]],[[],[]]]"', '[[0.874695,0.484674,0],[0,0,1]]', 0, 1, '2019-11-23 09:20:38'),
43 (5, '76561198014534906', 'B_supplyCrate_F', '[5343.15,3019.62,1.13675]', '"[[],0]"', '"[[[],[]],[[],[]],[[],[]],[[],[]]]"', '[[0.960449,-0.278455,0],[0,0,1]]', 0, 1, '2019-11-23 09:20:43');
44/*!40000 ALTER TABLE `containers` ENABLE KEYS */;
45
46-- Dumping structure for procedure cglife.deleteDeadVehicles
47DELIMITER //
48CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteDeadVehicles`()
49BEGIN
50 DELETE FROM `vehicles` WHERE `alive` = 0;
51END//
52DELIMITER ;
53
54-- Dumping structure for procedure cglife.deleteOldContainers
55DELIMITER //
56CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldContainers`()
57BEGIN
58 DELETE FROM `containers` WHERE `owned` = 0;
59END//
60DELIMITER ;
61
62-- Dumping structure for procedure cglife.deleteOldGangs
63DELIMITER //
64CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldGangs`()
65BEGIN
66 DELETE FROM `gangs` WHERE `active` = 0;
67END//
68DELIMITER ;
69
70-- Dumping structure for procedure cglife.deleteOldHouses
71DELIMITER //
72CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldHouses`()
73BEGIN
74 DELETE FROM `houses` WHERE `owned` = 0;
75END//
76DELIMITER ;
77
78-- Dumping structure for procedure cglife.deleteOldWanted
79DELIMITER //
80CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldWanted`()
81BEGIN
82 DELETE FROM `wanted` WHERE `active` = 0;
83END//
84DELIMITER ;
85
86-- Dumping structure for tabel cglife.efterlysning
87CREATE TABLE IF NOT EXISTS `efterlysning` (
88 `id` int(6) NOT NULL AUTO_INCREMENT,
89 `wantedID` varchar(64) NOT NULL,
90 `wantedName` varchar(32) NOT NULL,
91 `wantedCrimes` varchar(500) NOT NULL DEFAULT '',
92 `wantedBounty` int(100) NOT NULL,
93 `active` tinyint(1) NOT NULL DEFAULT '0',
94 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
95 PRIMARY KEY (`id`)
96) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;
97
98-- Dumping data for table cglife.efterlysning: ~6 rows (approximately)
99/*!40000 ALTER TABLE `efterlysning` DISABLE KEYS */;
100INSERT INTO `efterlysning` (`id`, `wantedID`, `wantedName`, `wantedCrimes`, `wantedBounty`, `active`, `insert_time`) VALUES
101 (4, '76561198019683075', 'Kimse Lamors', 'asdasdasd| tilføjet af Kimse Lamors', 5000, 1, '2019-11-23 22:41:14'),
102 (5, '76561198019683075', 'Kimse Lamors', 'asdasdasdas| tilføjet af Kimse Lamors', 5000, 1, '2019-11-24 09:05:47'),
103 (6, '76561198019683075', 'Kimse Lamors', 'asdasdasd tilføjet af Kimse Lamors', 5000, 1, '2019-11-24 09:48:28'),
104 (7, '76561198014534906', 'Mads "LH" West', 'Mads LH West har røvet Kimse Lamors for $50000 D. ', 10000, 1, '2019-11-24 13:55:44'),
105 (8, '76561198014534906', 'Mads "LH" West', 'Mads LH West har røvet Kimse Lamors for $50000 D. 24112019 kl 14114', 10000, 1, '2019-11-24 14:02:19'),
106 (9, '76561198019683075', 'Kimse Lamors', 'Kimse Lamors har røvet Mads "LH" West for $500,000 D. 24-11-2019 kl 14:12:52', 10000, 1, '2019-11-24 14:13:20');
107/*!40000 ALTER TABLE `efterlysning` ENABLE KEYS */;
108
109-- Dumping structure for tabel cglife.gangs
110CREATE TABLE IF NOT EXISTS `gangs` (
111 `id` int(11) NOT NULL AUTO_INCREMENT,
112 `owner` varchar(17) NOT NULL,
113 `name` varchar(32) DEFAULT NULL,
114 `members` text,
115 `maxmembers` int(11) DEFAULT '8',
116 `bank` int(11) DEFAULT '0',
117 `active` tinyint(4) NOT NULL DEFAULT '1',
118 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
119 PRIMARY KEY (`id`),
120 UNIQUE KEY `unique_name` (`name`),
121 KEY `fkIdx_players_gangs` (`owner`),
122 CONSTRAINT `FK_players_gangs` FOREIGN KEY (`owner`) REFERENCES `players` (`pid`) ON DELETE CASCADE ON UPDATE CASCADE
123) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
124
125-- Dumping data for table cglife.gangs: ~0 rows (approximately)
126/*!40000 ALTER TABLE `gangs` DISABLE KEYS */;
127/*!40000 ALTER TABLE `gangs` ENABLE KEYS */;
128
129-- Dumping structure for tabel cglife.houses
130CREATE TABLE IF NOT EXISTS `houses` (
131 `id` int(11) NOT NULL AUTO_INCREMENT,
132 `pid` varchar(32) NOT NULL,
133 `pos` varchar(64) DEFAULT NULL,
134 `inventory` text,
135 `containers` text,
136 `owned` tinyint(4) DEFAULT '0',
137 `shared1` text,
138 `shared2` text,
139 `shared3` text,
140 `shared4` text,
141 `shared5` text,
142 PRIMARY KEY (`id`,`pid`)
143) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
144
145-- Dumping data for table cglife.houses: ~2 rows (approximately)
146/*!40000 ALTER TABLE `houses` DISABLE KEYS */;
147INSERT INTO `houses` (`id`, `pid`, `pos`, `inventory`, `containers`, `owned`, `shared1`, `shared2`, `shared3`, `shared4`, `shared5`) VALUES
148 (1, '76561198019683075', '[5376.33,3047.64,0.32872]', '"[[[`storagebig`,11]],110]"', '"[[`B_supplyCrate_F`,[[[],[]],[[],[]],[[],[]],[[],[]]]],[`B_supplyCrate_F`,[[[],[]],[[],[]],[[],[]],[[],[]]]]]"', 1, '', '', '', '', ''),
149 (2, '76561198019683075', '[5340.36,3064.23,0.326447]', '"[[],0]"', '"[]"', 1, '', '', '', '', ''),
150 (3, '76561198014534906', '[5340.23,3019.33,0.828879]', '"[[],0]"', '"[]"', 1, '', '', '', '', '');
151/*!40000 ALTER TABLE `houses` ENABLE KEYS */;
152
153-- Dumping structure for tabel cglife.players
154CREATE TABLE IF NOT EXISTS `players` (
155 `uid` int(11) NOT NULL AUTO_INCREMENT,
156 `pid` varchar(17) NOT NULL,
157 `name` varchar(32) NOT NULL,
158 `aliases` text NOT NULL,
159 `cash` int(11) NOT NULL DEFAULT '0',
160 `bankacc` int(11) NOT NULL DEFAULT '0',
161 `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
162 `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
163 `civ_licenses` text NOT NULL,
164 `cop_licenses` text NOT NULL,
165 `med_licenses` text NOT NULL,
166 `civ_gear` text NOT NULL,
167 `cop_gear` text NOT NULL,
168 `med_gear` text NOT NULL,
169 `civ_stats` varchar(25) NOT NULL DEFAULT '"[100,100,0]"',
170 `cop_stats` varchar(25) NOT NULL DEFAULT '"[100,100,0]"',
171 `med_stats` varchar(25) NOT NULL DEFAULT '"[100,100,0]"',
172 `arrested` tinyint(4) NOT NULL DEFAULT '0',
173 `adminlevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
174 `donorlevel` int(11) NOT NULL DEFAULT '0',
175 `blacklist` tinyint(4) NOT NULL DEFAULT '0',
176 `civ_alive` tinyint(4) NOT NULL DEFAULT '0',
177 `civ_position` varchar(32) NOT NULL DEFAULT '"[]"',
178 `playtime` varchar(32) NOT NULL DEFAULT '"[0,0,0]"',
179 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
180 `last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
181 PRIMARY KEY (`pid`),
182 UNIQUE KEY `unique_uid` (`uid`),
183 KEY `index_name` (`name`),
184 KEY `index_blacklist` (`blacklist`)
185) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;
186
187-- Dumping data for table cglife.players: ~6 rows (approximately)
188/*!40000 ALTER TABLE `players` DISABLE KEYS */;
189INSERT INTO `players` (`uid`, `pid`, `name`, `aliases`, `cash`, `bankacc`, `coplevel`, `mediclevel`, `civ_licenses`, `cop_licenses`, `med_licenses`, `civ_gear`, `cop_gear`, `med_gear`, `civ_stats`, `cop_stats`, `med_stats`, `arrested`, `adminlevel`, `donorlevel`, `blacklist`, `civ_alive`, `civ_position`, `playtime`, `insert_time`, `last_seen`) VALUES
190 (3, '76561198014534906', 'Mads LH West', '"[`Mads West`]"', 3999996, 133850, '0', '5', '"[[`license_civ_driver`,1],[`license_civ_boat`,0],[`license_civ_pilot`,0],[`license_civ_trucking`,0],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,1],[`license_civ_oil`,0],[`license_civ_diamond`,0],[`license_civ_salt`,0],[`license_civ_sand`,0],[`license_civ_iron`,0],[`license_civ_copper`,0],[`license_civ_cement`,0],[`license_civ_medmarijuana`,0],[`license_civ_cocaine`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_rebel`,1]]"', '"[[`license_cop_cAir`,0],[`license_cop_cg`,0]]"', '"[[`license_med_mAir`,0]]"', '"[`CG_SERT3`,`SCommand_Vest_Fix`,`cg_invisbp`,`A3L_Balaclava`,`CG_sert_H2`,[`cg_tabletd_4`,`O_UavTerminal`,`d3s_p_eyes_001_NV`],`hlc_rifle_416N`,``,[],[],[],[`hlc_30rnd_556x45_EPR`,`hlc_30rnd_556x45_EPR`,`hlc_30rnd_556x45_EPR`,`hlc_30rnd_556x45_EPR`,`hlc_30rnd_556x45_EPR`,`hlc_30rnd_556x45_EPR`,`hlc_30rnd_556x45_EPR`,`hlc_30rnd_556x45_EPR`,`hlc_30rnd_556x45_EPR`,`hlc_30rnd_556x45_EPR`],[],[`hlc_30rnd_556x45_EPR`],[`hlc_muzzle_556NATO_M42000`,`RH_peq15`,`RH_ta31rmr`,`HLC_ISOPOD`],[``,``,``,``],[[`storageBig`,3],[`redgull`,7],[`toolkit`,1]]]"', '"[`U_O_GhillieSuit`,`V_TacVest_blk_POLICE`,`B_Carryall_khk`,`G_Bandanna_beast`,`H_HelmetSpecO_ocamo`,[`ItemMap`,`ItemCompass`,`Itemwatch`,`tf_anprc152_2`,`ItemGPS`,`NVGoggles_INDEP`,`Rangefinder`],`srifle_DMR_01_F`,``,[`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`,`FirstAidKit`],[`HandGrenade`,`SmokeShell`],[`ToolKit`],[`10Rnd_762x54_Mag`,`10Rnd_762x54_Mag`,`10Rnd_762x54_Mag`,`10Rnd_762x54_Mag`,`10Rnd_762x54_Mag`,`10Rnd_762x54_Mag`,`10Rnd_762x54_Mag`,`10Rnd_762x54_Mag`,`10Rnd_762x54_Mag`,`10Rnd_762x54_Mag`,`10Rnd_762x54_Mag`,`10Rnd_762x54_Mag`,`10Rnd_762x54_Mag`,`10Rnd_762x54_Mag`,`10Rnd_762x54_Mag`,`10Rnd_762x54_Mag`],[`FirstAidKit`,`FirstAidKit`],[`HandGrenade`,`SmokeShell`,`10Rnd_762x54_Mag`],[``,``,`optic_DMS`,`bipod_01_F_snd`],[``,``,``,``],[]]"', '"[`U_B_CBRN_Suit_01_Tropic_F`,`V_TacVest_blk`,``,`G_RegulatorMask_F`,``,[`ItemMap`,`ItemCompass`,`Itemwatch`,`tf_anprc148jem_1`],[],[],[],[`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`],[],[],[],[`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`],[``,``,``,``],[``,``,``,``],[]]"', '"[100,100,0,102]"', '"[100,100,0]"', '"[100,100,0]"', 0, '0', 102, 0, 1, '"[3406.74,7613.16,3.53051]"', '"[36,5,247]"', '2019-09-25 19:37:02', '2019-11-24 15:36:12'),
191 (1, '76561198019683075', 'Kimse Lamors', '"[`Kimse Lamors`]"', 500000, 135342496, '7', '5', '"[[`license_civ_driver`,1],[`license_civ_boat`,1],[`license_civ_pilot`,1],[`license_civ_trucking`,1],[`license_civ_gun`,1],[`license_civ_dive`,0],[`license_civ_home`,1],[`license_civ_oil`,0],[`license_civ_diamond`,1],[`license_civ_salt`,0],[`license_civ_sand`,0],[`license_civ_iron`,0],[`license_civ_copper`,1],[`license_civ_cement`,0],[`license_civ_medmarijuana`,0],[`license_civ_cocaine`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_rebel`,1]]"', '"[[`license_cop_cAir`,0],[`license_cop_cg`,0]]"', '"[]"', '"[`U_C_Commoner1_1`,`V_TacVest_oli`,`cg_invisbp`,``,``,[`ItemMap`,`ItemCompass`,`Itemwatch`,`cg_tabletd_2`,`ItemGPS`],`hlc_rifle_saiga12k`,`RH_g18`,[],[],[],[`hlc_10rnd_12g_slug_S12`,`hlc_10rnd_12g_slug_S12`,`hlc_10rnd_12g_slug_S12`,`hlc_10rnd_12g_slug_S12`,`hlc_10rnd_12g_slug_S12`,`hlc_10rnd_12g_slug_S12`,`hlc_10rnd_12g_buck_S12`,`hlc_10rnd_12g_slug_S12`,`hlc_10rnd_12g_slug_S12`],[],[`RH_33Rnd_9x19_g18`,`RH_33Rnd_9x19_g18`,`RH_33Rnd_9x19_g18`,`RH_33Rnd_9x19_g18`,`hlc_10rnd_12g_buck_S12`,`hlc_10rnd_12g_buck_S12`,`hlc_10rnd_12g_slug_S12`,`RH_33Rnd_9x19_g18`,`hlc_10rnd_12g_buck_S12`,`RH_33Rnd_9x19_g18`],[``,``,``,``],[``,``,``,``],[[`lockpick`,24]]]"', '"[`cg_arsenal1`,`V_Rangemaster_belt`,`d3s_backpack_a`,``,``,[`ItemMap`,`ItemCompass`,`Itemwatch`,`tf_anprc152_3`,`ItemGPS`],`hlc_rifle_416D145`,`taser`,[`muzzle_snds_L`],[`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`hlc_30rnd_556x45_EPR`,`vvv_np_magazine_taser`],[],[`vvv_np_magazine_taser`,`vvv_np_magazine_taser`,`vvv_np_magazine_taser`,`vvv_np_magazine_taser`],[],[`vvv_np_magazine_taser`,`vvv_np_magazine_taser`,`vvv_np_magazine_taser`,`30Rnd_556x45_Stanag`,`vvv_np_magazine_taser`],[``,``,``,``],[``,``,``,``],[]]"', '"[`U_B_CBRN_Suit_01_Tropic_F`,`V_TacVest_blk`,``,`G_RegulatorMask_F`,``,[`ItemMap`,`ItemCompass`,`Itemwatch`,`tf_anprc148jem_2`],[],[],[],[`RH_7Rnd_50_AE`],[],[],[],[`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`],[``,``,``,``],[`RH_demz`,``,``,``],[]]"', '"[100,100,0,1285]"', '"[100,100,0,1381]"', '"[100,100,0]"', 0, '0', 1379, 0, 1, '"[5357.47,3036.8,0.00143909]"', '"[505,0,526]"', '2019-08-18 12:24:48', '2019-11-24 15:28:44'),
192 (6, '76561198032955028', 'sakom', '"[`sakom`]"', 24044, 154600, '0', '0', '"[[`license_civ_driver`,1],[`license_civ_boat`,0],[`license_civ_pilot`,0],[`license_civ_trucking`,0],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,0],[`license_civ_oil`,0],[`license_civ_diamond`,0],[`license_civ_salt`,0],[`license_civ_sand`,0],[`license_civ_iron`,0],[`license_civ_copper`,0],[`license_civ_cement`,0],[`license_civ_medmarijuana`,0],[`license_civ_cocaine`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_rebel`,0]]"', '"[]"', '"[]"', '"[`U_IG_Guerilla3_1`,`V_BandollierB_cbr`,`B_Carryall_oli`,`G_Sport_Blackred`,`H_Beret_02`,[`ItemMap`,`ItemCompass`,`Itemwatch`,`cg_tabletd_1`,`ItemGPS`,`NVGoggles`,`Rangefinder`],``,`hgun_P07_F`,[],[`30Rnd_556x45_Stanag`],[`FirstAidKit`,`FirstAidKit`],[`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_9x21_Mag`,`30Rnd_9x21_Mag`,`30Rnd_9x21_Mag`,`30Rnd_9x21_Mag`,`30Rnd_9x21_Mag`,`30Rnd_9x21_Mag`,`30Rnd_9x21_Mag`,`HandGrenade`,`HandGrenade`,`30Rnd_9x21_Mag`,`30Rnd_9x21_Mag`],[],[`30Rnd_9x21_Mag`],[``,``,``,``],[`muzzle_snds_L`,``,``,``],[[`pickaxe`,1]]]"', '"[]"', '"[]"', '"[100,100,0,63]"', '"[100,100,0]"', '"[100,100,0]"', 0, '0', 59, 0, 1, '"[4307.08,6303.84,0.0443411]"', '"[0,0,174]"', '2019-11-23 14:03:38', '2019-11-24 15:36:24'),
193 (5, '76561198084850411', 'Børge Frimann', '"[`Børge Frimann`]"', 3829, 567314, '0', '5', '"[[`license_civ_driver`,0],[`license_civ_boat`,0],[`license_civ_pilot`,0],[`license_civ_trucking`,0],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,0],[`license_civ_oil`,0],[`license_civ_diamond`,0],[`license_civ_salt`,0],[`license_civ_sand`,0],[`license_civ_iron`,0],[`license_civ_copper`,0],[`license_civ_cement`,0],[`license_civ_medmarijuana`,0],[`license_civ_cocaine`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_rebel`,0]]"', '"[]"', '"[[`license_med_mAir`,0]]"', '"[`CG_SERT3`,`SCommand_Vest_Fix`,`cg_invisbp`,`A3L_Balaclava`,`CG_sert_H2`,[`cg_tabletd_2`,`ItemGPS`,`d3s_p_eyes_001_NV`],`hlc_rifle_416N`,``,[],[],[],[`hlc_30rnd_556x45_EPR`,`hlc_30rnd_556x45_EPR`,`hlc_30rnd_556x45_EPR`,`hlc_30rnd_556x45_EPR`,`hlc_30rnd_556x45_EPR`,`hlc_30rnd_556x45_EPR`,`hlc_30rnd_556x45_EPR`],[],[`hlc_30rnd_556x45_EPR`],[`hlc_muzzle_556NATO_M42000`,`RH_peq15`,`RH_ta31rmr`,`HLC_ISOPOD`],[``,``,``,``],[]]"', '"[]"', '"[`U_Rangemaster`,`V_Rangemaster_belt`,``,`G_Aviator`,`H_Cap_headphones`,[`ItemMap`,`ItemCompass`,`tf_microdagr`,`tf_anprc148jem_2`],[],[],[`FirstAidKit`],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[[`defibrillator`,1]]]"', '"[100,100,0,67]"', '"[100,100,0]"', '"[100,100,0,65]"', 0, '0', 65, 0, 1, '"[4326.38,6264.56,6.10915]"', '"[0,15,157]"', '2019-11-23 13:50:58', '2019-11-24 15:34:50'),
194 (4, '76561198104752384', 'Sebastian Uni', '"[`Sebastian Uni`]"', 0, 410400, '0', '0', '"[[`license_civ_driver`,0],[`license_civ_boat`,0],[`license_civ_pilot`,0],[`license_civ_trucking`,0],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,0],[`license_civ_oil`,0],[`license_civ_diamond`,0],[`license_civ_salt`,0],[`license_civ_sand`,0],[`license_civ_iron`,0],[`license_civ_copper`,0],[`license_civ_cement`,0],[`license_civ_medmarijuana`,0],[`license_civ_cocaine`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_rebel`,0]]"', '"[]"', '"[]"', '"[`U_O_GhillieSuit`,`V_BandollierB_cbr`,`B_Carryall_oli`,`G_Sport_Blackred`,`H_Beret_02`,[`ItemMap`,`ItemCompass`,`Itemwatch`,`ItemGPS`,`NVGoggles`,`Rangefinder`],[],[],[],[`5Rnd_127x108_Mag`],[`FirstAidKit`,`FirstAidKit`],[`5Rnd_127x108_Mag`,`5Rnd_127x108_Mag`,`5Rnd_127x108_Mag`,`5Rnd_127x108_Mag`,`5Rnd_127x108_Mag`,`5Rnd_127x108_Mag`,`5Rnd_127x108_Mag`,`5Rnd_127x108_Mag`,`5Rnd_127x108_Mag`,`30Rnd_9x21_Mag`,`30Rnd_9x21_Mag`,`30Rnd_9x21_Mag`,`30Rnd_9x21_Mag`,`30Rnd_9x21_Mag`,`30Rnd_9x21_Mag`,`30Rnd_9x21_Mag`,`30Rnd_9x21_Mag`,`HandGrenade`,`HandGrenade`],[],[`30Rnd_9x21_Mag`],[``,``,``,``],[``,``,``,``],[]]"', '"[]"', '"[]"', '"[100,100,0]"', '"[100,100,0]"', '"[100,100,0]"', 0, '0', 6, 0, 1, '"[8690.47,6669.45,0.0964394]"', '"[0,0,4]"', '2019-10-11 16:54:07', '2019-10-11 18:06:38'),
195 (2, '76561198152473475', 'Andreas Castle #Æ Knægt', '"[`Andreas Castle`]"', 99900, 4249515, '7', '5', '"[[`license_civ_driver`,0],[`license_civ_boat`,0],[`license_civ_pilot`,0],[`license_civ_trucking`,0],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,0],[`license_civ_oil`,0],[`license_civ_diamond`,0],[`license_civ_salt`,0],[`license_civ_sand`,0],[`license_civ_iron`,0],[`license_civ_copper`,0],[`license_civ_cement`,0],[`license_civ_medmarijuana`,0],[`license_civ_cocaine`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_rebel`,0]]"', '"[[`license_cop_cAir`,0],[`license_cop_cg`,0]]"', '"[[`license_med_mAir`,0]]"', '"[`A3L_Zombie`,`accs_diff_000`,`cg_invisbp`,``,`A3L_mexicanhat`,[`ItemMap`,`ItemCompass`,`Itemwatch`,`cg_tabletd_1`,`d3s_p_eyes_001_NV`],``,`taser`,[],[`sharp_swing`,`sharp_swing`],[],[],[],[],[``,``,``,``],[``,``,``,``],[]]"', '"[`cg_arsenal1`,`V_Rangemaster_belt`,`d3s_backpack_a`,``,``,[`ItemMap`,`ItemCompass`,`Itemwatch`,`tf_anprc152_2`,`ItemGPS`],`hlc_rifle_saiga12k`,`taser`,[],[`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`hlc_10rnd_12g_buck_S12`,`hlc_10rnd_12g_buck_S12`,`hlc_10rnd_12g_buck_S12`],[],[`vvv_np_magazine_taser`,`vvv_np_magazine_taser`,`vvv_np_magazine_taser`,`vvv_np_magazine_taser`,`vvv_np_magazine_taser`,`vvv_np_magazine_taser`,`vvv_np_magazine_taser`,`vvv_np_magazine_taser`,`vvv_np_magazine_taser`,`vvv_np_magazine_taser`,`vvv_np_magazine_taser`,`vvv_np_magazine_taser`,`vvv_np_magazine_taser`,`vvv_np_magazine_taser`,`vvv_np_magazine_taser`,`vvv_np_magazine_taser`,`vvv_np_magazine_taser`],[],[`hlc_10rnd_12g_buck_S12`,`vvv_np_magazine_taser`],[``,``,``,``],[`muzzle_snds_L`,``,``,``],[]]"', '"[`U_B_CBRN_Suit_01_Tropic_F`,`V_TacVest_blk`,``,`G_RegulatorMask_F`,``,[`ItemMap`,`ItemCompass`,`Itemwatch`,`tf_anprc148jem_2`],[],[],[],[`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`],[],[],[],[`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`,`RH_7Rnd_50_AE`],[``,``,``,``],[``,``,``,``],[]]"', '"[100,100,0]"', '"[100,100,0,79]"', '"[100,100,0]"', 0, '0', 73, 0, 1, '"[5362.83,3041.29,0.00143909]"', '"[133,14,36]"', '2019-09-25 17:31:34', '2019-11-23 18:53:22');
196/*!40000 ALTER TABLE `players` ENABLE KEYS */;
197
198-- Dumping structure for procedure cglife.resetLifeVehicles
199DELIMITER //
200CREATE DEFINER=`root`@`localhost` PROCEDURE `resetLifeVehicles`()
201BEGIN
202 UPDATE `vehicles` SET `active`= 0;
203END//
204DELIMITER ;
205
206-- Dumping structure for tabel cglife.vehicles
207CREATE TABLE IF NOT EXISTS `vehicles` (
208 `id` int(11) NOT NULL AUTO_INCREMENT,
209 `pid` varchar(17) NOT NULL,
210 `side` varchar(10) NOT NULL,
211 `classname` varchar(64) NOT NULL,
212 `type` varchar(16) NOT NULL,
213 `alive` tinyint(4) NOT NULL DEFAULT '1',
214 `blacklist` tinyint(4) NOT NULL DEFAULT '0',
215 `active` tinyint(4) NOT NULL DEFAULT '0',
216 `plate` varchar(32) NOT NULL DEFAULT '0',
217 `color` int(11) NOT NULL,
218 `inventory` text NOT NULL,
219 `gear` text NOT NULL,
220 `fuel` double NOT NULL DEFAULT '1',
221 `damage` varchar(256) NOT NULL,
222 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
223 `insured` int(1) NOT NULL DEFAULT '0',
224 PRIMARY KEY (`id`),
225 KEY `fkIdx_players_vehicles` (`pid`),
226 KEY `index_side` (`side`),
227 KEY `index_type` (`type`),
228 CONSTRAINT `FK_players_vehicles` FOREIGN KEY (`pid`) REFERENCES `players` (`pid`) ON DELETE CASCADE ON UPDATE CASCADE
229) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4;
230
231-- Dumping data for table cglife.vehicles: ~15 rows (approximately)
232/*!40000 ALTER TABLE `vehicles` DISABLE KEYS */;
233INSERT INTO `vehicles` (`id`, `pid`, `side`, `classname`, `type`, `alive`, `blacklist`, `active`, `plate`, `color`, `inventory`, `gear`, `fuel`, `damage`, `insert_time`, `insured`) VALUES
234 (2, '76561198152473475', 'med', 'C_Offroad_01_F', 'Car', 1, 0, 0, '999222', 0, '"[[],0]"', '"[]"', 1, '"[]"', '2019-09-28 16:41:49', 0),
235 (4, '76561198014534906', 'med', 'C_Offroad_01_F', 'Car', 1, 0, 0, '512960', 0, '"[[],0]"', '"[]"', 1, '"[]"', '2019-09-28 18:07:44', 0),
236 (5, '76561198019683075', 'civ', 'd3s_amazing_ACS8_17', 'Car', 1, 0, 0, '1234567', 0, '"[[],0]"', '"[]"', 1, '"[]"', '2019-10-07 12:12:24', 0),
237 (6, '76561198019683075', 'civ', 'd3s_amazing_ACS8_17', 'Car', 1, 0, 0, 'asdasd1', 0, '"[[],0]"', '"[]"', 1, '"[]"', '2019-10-07 12:13:48', 0),
238 (7, '76561198019683075', 'civ', 'd3s_amazing_ACS8_17', 'Car', 1, 0, 0, 'gnubbie', 0, '"[[],0]"', '"[]"', 1, '"[]"', '2019-10-07 12:54:58', 0),
239 (8, '76561198019683075', 'civ', 'd3s_amazing_ACS8_17', 'Car', 1, 0, 0, 'FokFace', 0, '"[[],0]"', '"[]"', 1, '"[]"', '2019-10-08 13:55:20', 0),
240 (9, '76561198152473475', 'civ', 'd3s_amazing_ACS8_17', 'Car', 1, 0, 0, 'Kimsesmor', 0, '"[[],0]"', '"[]"', 1, '"[]"', '2019-10-08 13:56:39', 0),
241 (10, '76561198019683075', 'civ', 'd3s_amazing_ACS8_17', 'Car', 1, 0, 0, 'fuckyou', 0, '"[[],0]"', '"[]"', 1, '"[]"', '2019-10-08 14:03:38', 0),
242 (13, '76561198019683075', 'civ', 'd3s_amazing_ACS8_17', 'Car', 1, 0, 0, '123asdf', 0, '"[[],0]"', '"[]"', 1, '"[]"', '2019-10-08 14:20:27', 0),
243 (14, '76561198152473475', 'civ', 'd3s_amazing_ACS8_17', 'Car', 1, 0, 0, 'gopv882', 0, '"[[],0]"', '"[]"', 1, '"[]"', '2019-10-08 14:21:23', 0),
244 (15, '76561198019683075', 'civ', 'd3s_amazing_ACS8_17', 'Car', 1, 0, 0, 'nqgu600', 0, '"[[],0]"', '"[]"', 1, '"[]"', '2019-10-17 18:17:28', 0),
245 (16, '76561198019683075', 'civ', 'd3s_amazing_ACS8_17', 'Car', 1, 0, 0, 'pfks585', 0, '"[[],0]"', '"[]"', 1, '"[]"', '2019-10-17 18:28:20', 0),
246 (17, '76561198019683075', 'civ', 'd3s_amazing_ACS8_17', 'Car', 1, 0, 0, 'yihg513', 0, '"[[],0]"', '"[]"', 1, '"[]"', '2019-10-17 18:33:39', 0),
247 (18, '76561198019683075', 'civ', 'd3s_amazing_ACS8_17', 'Car', 1, 0, 0, 'SakoFis', 0, '"[[],0]"', '"[]"', 1, '"[]"', '2019-10-18 12:50:40', 0),
248 (19, '76561198032955028', 'civ', 'd3s_amazing_ACS8_17', 'Car', 1, 0, 0, 'exma545', 0, '"[[],0]"', '"[]"', 1, '"[]"', '2019-11-23 14:16:48', 1);
249/*!40000 ALTER TABLE `vehicles` ENABLE KEYS */;
250
251-- Dumping structure for tabel cglife.wanted
252CREATE TABLE IF NOT EXISTS `wanted` (
253 `wantedID` varchar(17) NOT NULL,
254 `wantedName` varchar(32) NOT NULL,
255 `wantedCrimes` text NOT NULL,
256 `wantedBounty` int(11) NOT NULL,
257 `active` tinyint(4) NOT NULL DEFAULT '0',
258 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
259 PRIMARY KEY (`wantedID`),
260 CONSTRAINT `FK_players_wanted` FOREIGN KEY (`wantedID`) REFERENCES `players` (`pid`) ON DELETE CASCADE ON UPDATE CASCADE
261) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
262
263-- Dumping data for table cglife.wanted: ~3 rows (approximately)
264/*!40000 ALTER TABLE `wanted` DISABLE KEYS */;
265INSERT INTO `wanted` (`wantedID`, `wantedName`, `wantedCrimes`, `wantedBounty`, `active`, `insert_time`) VALUES
266 ('76561198014534906', 'Mads West', '"[`211`,`211`,`211`]"', 300, 1, '2019-09-28 18:25:18'),
267 ('76561198019683075', 'Kimse Lamors', '"[`211`,`459`,`459`,`459`,`211`]"', 2150, 1, '2019-09-28 18:26:11'),
268 ('76561198084850411', 'Børge Frimann', '[]', 0, 0, '2019-11-23 14:03:14');
269/*!40000 ALTER TABLE `wanted` ENABLE KEYS */;
270
271/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
272/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
273/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;