· 9 years ago · Oct 27, 2016, 11:10 PM
1/*
2Navicat MySQL Data Transfer
3
4Source Server : GamingD - Lakeside
5Source Server Version : 50624
6Source Host : 81.19.208.3:3306
7Source Database : BenJ-14072
8
9Target Server Type : MYSQL
10Target Server Version : 50624
11File Encoding : 65001
12
13Date: 2016-10-27 23:23:39
14*/
15
16SET FOREIGN_KEY_CHECKS=0;
17
18-- Dumping database structure for life
19CREATE DATABASE IF NOT EXISTS `BenJ-14072` /*!40100 DEFAULT CHARACTER SET utf8 */;
20USE `BenJ-14072`;
21
22-- ----------------------------
23-- Table structure for `bans`
24-- ----------------------------
25DROP TABLE IF EXISTS `bans`;
26CREATE TABLE `bans` (
27 `id` int(11) NOT NULL AUTO_INCREMENT,
28 `banuid` varchar(50) NOT NULL DEFAULT '',
29 `adminuid` varchar(50) NOT NULL DEFAULT '',
30 `isperm` int(11) NOT NULL DEFAULT '0',
31 `added` varchar(50) NOT NULL DEFAULT '0',
32 `time` int(11) NOT NULL DEFAULT '0',
33 `reason` varchar(500) NOT NULL DEFAULT '',
34 UNIQUE KEY `id` (`id`)
35) ENGINE=InnoDB DEFAULT CHARSET=utf8;
36
37-- ----------------------------
38-- Records of bans
39-- ----------------------------
40
41-- ----------------------------
42-- Table structure for `gangs`
43-- ----------------------------
44DROP TABLE IF EXISTS `gangs`;
45CREATE TABLE `gangs` (
46 `id` int(11) NOT NULL AUTO_INCREMENT,
47 `owner` varchar(32) DEFAULT NULL,
48 `name` varchar(32) DEFAULT NULL,
49 `members` text,
50 `maxmembers` int(2) DEFAULT '8',
51 `bank` int(100) DEFAULT '0',
52 `active` tinyint(4) DEFAULT '1',
53 PRIMARY KEY (`id`),
54 UNIQUE KEY `name_UNIQUE` (`name`)
55) ENGINE=InnoDB DEFAULT CHARSET=latin1;
56
57-- ----------------------------
58-- Records of gangs
59-- ----------------------------
60
61-- ----------------------------
62-- Table structure for `houses`
63-- ----------------------------
64DROP TABLE IF EXISTS `houses`;
65CREATE TABLE `houses` (
66 `id` int(11) NOT NULL AUTO_INCREMENT,
67 `pid` varchar(32) NOT NULL,
68 `pos` varchar(64) DEFAULT NULL,
69 `inventory` text,
70 `containers` text,
71 `owned` tinyint(4) DEFAULT '0',
72 `shared1` text,
73 `shared2` text,
74 `shared3` text,
75 `shared4` text,
76 `shared5` text,
77 PRIMARY KEY (`id`,`pid`)
78) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
79
80-- ----------------------------
81-- Records of houses
82-- ----------------------------
83INSERT INTO `houses` VALUES ('1', '76561198065459302', '[8709.28,6387.63,-0.0022831]', '\"[[],0]\"', '\"[]\"', '1', '', '', '', '', '');
84
85-- ----------------------------
86-- Table structure for `launcher`
87-- ----------------------------
88DROP TABLE IF EXISTS `launcher`;
89CREATE TABLE `launcher` (
90 `server_ip` varchar(15) DEFAULT NULL,
91 `launcher_path` varchar(255) DEFAULT NULL,
92 `ts3_plugin_path` varchar(255) DEFAULT NULL,
93 `mod_path` varchar(255) DEFAULT NULL,
94 `ftp_userid` varchar(255) DEFAULT NULL,
95 `ftp_pass` varchar(255) DEFAULT NULL,
96 `hashes_path` varchar(255) DEFAULT NULL,
97 `servers_path` varchar(255) DEFAULT NULL
98) ENGINE=InnoDB DEFAULT CHARSET=utf8;
99
100-- ----------------------------
101-- Records of launcher
102-- ----------------------------
103
104-- ----------------------------
105-- Table structure for `panellog`
106-- ----------------------------
107DROP TABLE IF EXISTS `panellog`;
108CREATE TABLE `panellog` (
109 `uid` int(12) NOT NULL AUTO_INCREMENT,
110 `date` varchar(32) NOT NULL,
111 `author` varchar(32) NOT NULL,
112 `pname` varchar(32) NOT NULL,
113 `pid` varchar(50) NOT NULL,
114 `bankacc` int(100) NOT NULL DEFAULT '0',
115 `cash` int(100) NOT NULL DEFAULT '0',
116 `obankacc` int(100) NOT NULL DEFAULT '0',
117 `ocash` int(100) NOT NULL DEFAULT '0',
118 `coplevel` enum('0','1','2','3','4','5','6','7') DEFAULT '0',
119 `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
120 PRIMARY KEY (`uid`),
121 KEY `pname` (`pname`),
122 KEY `author` (`author`)
123) ENGINE=InnoDB DEFAULT CHARSET=latin1;
124
125-- ----------------------------
126-- Records of panellog
127-- ----------------------------
128
129-- ----------------------------
130-- Table structure for `players`
131-- ----------------------------
132DROP TABLE IF EXISTS `players`;
133CREATE TABLE `players` (
134 `uid` int(12) NOT NULL AUTO_INCREMENT,
135 `name` varchar(32) NOT NULL,
136 `playerid` varchar(50) NOT NULL,
137 `cash` int(100) NOT NULL DEFAULT '0',
138 `bankacc` int(100) NOT NULL DEFAULT '0',
139 `coplevel` enum('0','1','2','3','4','5','6','7','8','9','10','11','12','13','14','15') DEFAULT '0',
140 `cop_licenses` text,
141 `civ_licenses` text,
142 `med_licenses` text,
143 `cop_gear` text NOT NULL,
144 `mediclevel` enum('0','1','2','3','4','5') NOT NULL DEFAULT '0',
145 `arrested` tinyint(1) NOT NULL DEFAULT '0',
146 `aliases` text NOT NULL,
147 `adminlevel` enum('0','1','2','3') NOT NULL DEFAULT '0',
148 `donatorlvl` int(100) NOT NULL DEFAULT '0',
149 `civ_gear` text NOT NULL,
150 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
151 `admin_user` varchar(50) DEFAULT NULL,
152 `admin_pass` varchar(50) DEFAULT NULL,
153 `timeupdated` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
154 `timejoined` datetime DEFAULT NULL,
155 `med_gear` text NOT NULL,
156 `issupport` enum('0','1') NOT NULL DEFAULT '0',
157 `jailtime` int(11) NOT NULL DEFAULT '0',
158 `arrestreason` varchar(150) NOT NULL,
159 `streamSaftey` tinyint(1) NOT NULL DEFAULT '0',
160 PRIMARY KEY (`uid`),
161 UNIQUE KEY `playerid` (`playerid`),
162 KEY `name` (`name`),
163 KEY `blacklist` (`blacklist`)
164) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=latin1;
165
166-- ----------------------------
167-- Records of players
168-- ----------------------------
169INSERT INTO `players` VALUES ('5', '[109] Cpt. B. Jones', '76561198065459302', '0', '21889800', '7', '\"[[`license_cop_air`,1],[`license_cop_swat`,0],[`license_cop_cg`,0]]\"', '\"[[`license_civ_MDMA`,0],[`license_civ_meth`,0],[`license_civ_coke`,0],[`license_civ_driver`,0],[`license_civ_air`,1],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_gang`,0],[`license_civ_boat`,1],[`license_civ_oil`,0],[`license_civ_dive`,0],[`license_civ_truck`,0],[`license_civ_gun`,0],[`license_civ_rebel`,1],[`license_civ_diamond`,0],[`license_civ_copper`,0],[`license_civ_iron`,0],[`license_civ_sand`,0],[`license_civ_salt`,0],[`license_civ_cement`,0],[`license_civ_home`,1],[`license_civ_rifle`,0]]\"', '\"[]\"', '\"[`herpSERT3`,`kaelvest_sert2_Fix`,`AM_PoliceBelt`,`G_Bandanna_blk`,`TRYK_H_PASGT_BLK`,[`ItemMap`,`ItemCompass`,`Itemwatch`,`tf_anprc152_3`,`Rangefinder`],`RH_M4A6`,`Taser_26`,[],[`26_cartridge`,`SmokeShellYellow`,`SmokeShellYellow`],[],[],[],[`RH_30Rnd_68x43_Match`,`RH_30Rnd_68x43_Match`,`RH_30Rnd_68x43_Match`,`RH_30Rnd_68x43_Match`,`SmokeShellYellow`,`CG_ATF_Handcuffs_i`,`CG_ATF_Handcuffs_i`,`CG_ATF_Handcuffs_i`,`RH_30Rnd_68x43_Match`,`RH_30Rnd_68x43_Match`,`26_cartridge`],[``,`acc_flashlight`,`optic_Hamr`,``],[``,``,``,``],[`life_inv_medkit`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_RoadBlockWood`,`life_inv_RoadConeStrip`],``,[``,``,``,``]]\"', '0', '0', '\"[`B. Jones`,`[109] Cpt. B. Jones`]\"', '0', '1077', '\"[`A3LShirt`,``,`B_AssaultPack_cbr`,``,``,[`ItemMap`,`ItemCompass`],`RH_M4_ris`,``,[],[`RH_30Rnd_556x45_M855A1`],[],[],[],[],[``,``,`RH_eotech553mag`,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 22:46:09', '2016-10-26 21:45:42', '\"[]\"', '0', '0', 'none', '0');
170INSERT INTO `players` VALUES ('7', '[204] Cpt B.Smith', '76561198081705058', '0', '1031530', '7', '\"[[`license_cop_air`,1],[`license_cop_swat`,0],[`license_cop_cg`,1]]\"', '\"[[`license_civ_MDMA`,0],[`license_civ_meth`,0],[`license_civ_coke`,0],[`license_civ_driver`,0],[`license_civ_air`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_gang`,0],[`license_civ_boat`,0],[`license_civ_oil`,0],[`license_civ_dive`,0],[`license_civ_truck`,0],[`license_civ_gun`,0],[`license_civ_rebel`,1],[`license_civ_diamond`,0],[`license_civ_copper`,0],[`license_civ_iron`,0],[`license_civ_sand`,0],[`license_civ_salt`,0],[`license_civ_cement`,0],[`license_civ_home`,0],[`license_civ_rifle`,1]]\"', '\"[]\"', '\"[`RF_ASU_2`,`cg_policevest1_Fix`,`AM_PoliceBelt`,`Mask_M40`,`Campaign_Hat_Dark`,[`ItemMap`,`ItemCompass`,`tf_anprc152_4`,`ItemGPS`,`Rangefinder`],`RH_M27IAR`,`Taser_26`,[],[`RH_60Rnd_556x45_M855A1`,`RH_60Rnd_556x45_M855A1`,`RH_60Rnd_556x45_M855A1`,`RH_60Rnd_556x45_M855A1`,`RH_60Rnd_556x45_M855A1`,`RH_60Rnd_556x45_M855A1`,`RH_60Rnd_556x45_M855A1`,`RH_60Rnd_556x45_M855A1`,`RH_60Rnd_556x45_M855A1`,`RH_60Rnd_556x45_M855A1`],[`ToolKit`],[`SmokeShellYellow`,`RH_60Rnd_556x45_M855A1`],[`muzzle_snds_M`,`RH_eotech553mag`],[`26_cartridge`,`26_cartridge`,`26_cartridge`,`CG_ATF_Handcuffs_i`,`CG_ATF_Handcuffs_i`,`26_cartridge`,`nonlethal_swing`],[``,``,`optic_LRPS`,``],[``,``,``,``],[`life_inv_medkit`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_RoadBlockWood`,`life_inv_RoadBlockWood`,`life_inv_RoadBlockWood`,`life_inv_RoadConeStripB`,`life_inv_RoadConeStripB`,`life_inv_RoadConeStripB`],`CG_TELBAT`,[``,``,``,``]]\"', '0', '0', '\"[`Smith`,`[204] Cpt B.Smith`]\"', '0', '-1781', '\"[`A3LShirt`,``,`TRYK_B_Kitbag_Base_JSDF`,`TRYK_Beard_BW4`,`kio_skl_msk_fran`,[`cg_tabletd_2`],``,`RH_fn57`,[],[`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_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`],[`RH_compM2`,`SG553_CQB`],[`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`30Rnd_556x45_Stanag`,`RH_20Rnd_57x28_FN`,`RH_20Rnd_57x28_FN`,`RH_20Rnd_57x28_FN`,`RH_20Rnd_57x28_FN`,`RH_20Rnd_57x28_FN`,`RH_20Rnd_57x28_FN`,`RH_20Rnd_57x28_FN`],[],[],[``,``,``,``],[``,``,``,``],[`life_inv_bec`,`life_inv_bec`,`life_inv_bec`,`life_inv_bec`,`life_inv_bec`,`life_inv_medkit`,`life_inv_tierope`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 22:50:22', '2016-10-26 21:47:14', '\"[]\"', '0', '0', 'none', '0');
171INSERT INTO `players` VALUES ('8', '[LSSD-201] Ass G.Bedford', '76561198077234366', '79', '1199860', '6', '\"[]\"', '\"[]\"', '\"[]\"', '\"[`U_B_CombatUniform_mcam`,`V_PlateCarrier1_rgr`,``,``,`H_HelmetB`,[`ItemMap`,`ItemCompass`,`Itemwatch`,`tf_anprc152_5`,`NVGoggles`],``,``,[`FirstAidKit`],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', '0', '\"[`[LSSD201] Ass G.Bedford`,`[LSSD-201] Ass G.Bedford`]\"', '0', '-384', '\"[`A3LShirt`,``,`B_AssaultPack_cbr`,``,``,[`ItemMap`,`ItemCompass`,`cg_tabletd_4`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 22:50:17', '2016-10-26 21:54:42', '\"[]\"', '0', '0', 'none', '0');
172INSERT INTO `players` VALUES ('9', '[103] Cpl. B. OBrockly', '76561198183443506', '0', '123999', '5', '\"[]\"', '\"[[`license_civ_MDMA`,0],[`license_civ_meth`,0],[`license_civ_coke`,0],[`license_civ_driver`,0],[`license_civ_air`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_gang`,0],[`license_civ_boat`,0],[`license_civ_oil`,0],[`license_civ_dive`,0],[`license_civ_truck`,0],[`license_civ_gun`,0],[`license_civ_rebel`,1],[`license_civ_diamond`,0],[`license_civ_copper`,0],[`license_civ_iron`,0],[`license_civ_sand`,0],[`license_civ_salt`,0],[`license_civ_cement`,0],[`license_civ_home`,0],[`license_civ_rifle`,0]]\"', '\"[]\"', '\"[`TCG_PDO`,`HighThreatVestPolice2_Fix`,`AM_PoliceBelt`,``,`max_police_Hat`,[`ItemCompass`,`Itemwatch`,`tf_anprc152_13`,`ItemGPS`],`RH_M4_moe_g`,`RH_g19`,[],[`26_cartridge`,`26_cartridge`,`26_cartridge`,`26_cartridge`,`26_cartridge`,`RH_30Rnd_556x45_M855A1`],[`ToolKit`,`CG_sert_H3`,`G_Bandanna_blk`],[],[],[`RH_30Rnd_556x45_M855A1`,`RH_30Rnd_556x45_M855A1`,`RH_30Rnd_556x45_M855A1`,`RH_30Rnd_556x45_M855A1`,`RH_30Rnd_556x45_M855A1`,`RH_30Rnd_556x45_M855A1`,`RH_30Rnd_556x45_M855A1`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_30Rnd_556x45_M855A1`,`RH_17Rnd_9x19_g17`],[``,``,`FHQ_optic_AIM`,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', '0', '\"[`[103] Cpl. B. OBrockly`]\"', '0', '-466', '\"[`A3LShirt`,``,`B_AssaultPack_cbr`,``,``,[`ItemMap`,`ItemCompass`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 22:47:34', '2016-10-26 22:01:05', '\"[]\"', '0', '0', 'none', '0');
173INSERT INTO `players` VALUES ('10', 'Mario Benitez', '76561198162599111', '-8', '197966', '0', '\"[]\"', '\"[[`license_civ_MDMA`,0],[`license_civ_meth`,0],[`license_civ_coke`,0],[`license_civ_driver`,1],[`license_civ_air`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_gang`,0],[`license_civ_boat`,0],[`license_civ_oil`,0],[`license_civ_dive`,0],[`license_civ_truck`,0],[`license_civ_gun`,1],[`license_civ_rebel`,1],[`license_civ_diamond`,0],[`license_civ_copper`,0],[`license_civ_iron`,0],[`license_civ_sand`,0],[`license_civ_salt`,0],[`license_civ_cement`,0],[`license_civ_home`,0],[`license_civ_rifle`,0]]\"', '\"[]\"', '\"[]\"', '0', '0', '\"[`Mario Benitez`]\"', '0', '170', '\"[]\"', '0', null, null, '2016-10-27 21:48:53', '2016-10-26 22:05:09', '\"[]\"', '0', '0', 'none', '0');
174INSERT INTO `players` VALUES ('11', 'Jack Little', '76561198141702703', '14939', '1856210', '0', '\"[]\"', '\"[[`license_civ_MDMA`,0],[`license_civ_meth`,0],[`license_civ_coke`,0],[`license_civ_driver`,0],[`license_civ_air`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_gang`,0],[`license_civ_boat`,0],[`license_civ_oil`,0],[`license_civ_dive`,0],[`license_civ_truck`,0],[`license_civ_gun`,0],[`license_civ_rebel`,1],[`license_civ_diamond`,0],[`license_civ_copper`,0],[`license_civ_iron`,0],[`license_civ_sand`,0],[`license_civ_salt`,0],[`license_civ_cement`,0],[`license_civ_home`,0],[`license_civ_rifle`,0]]\"', '\"[]\"', '\"[]\"', '0', '0', '\"[`Jack Little`]\"', '0', '15', '\"[]\"', '0', null, null, '2016-10-27 01:32:16', '2016-10-26 22:08:33', '\"[]\"', '0', '0', 'none', '0');
175INSERT INTO `players` VALUES ('12', 'Warden. John Brown', '76561198242934548', '4130', '87367', '6', '\"[]\"', '\"[]\"', '\"[]\"', '\"[`doc_uniform_co`,`DOC_Vest_Threat_Fix`,`AM_PoliceBelt`,`G_Aviator`,`corrections_cap`,[`tf_anprc152_3`,`ItemGPS`],`RH_M4_moe_g`,`RH_p226s`,[],[`CG_ATF_Handcuffs_i`,`CG_ATF_Handcuffs_i`,`CG_ATF_Handcuffs_i`,`CG_ATF_Handcuffs_i`,`CG_ATF_Handcuffs_i`,`CG_Spikes_Collapsed`,`CG_Spikes_Collapsed`,`RH_15Rnd_9x19_SIG`,`RH_15Rnd_9x19_SIG`,`RH_15Rnd_9x19_SIG`,`RH_15Rnd_9x19_SIG`],[],[`RH_30Rnd_556x45_M855A1`,`RH_30Rnd_556x45_M855A1`,`RH_30Rnd_556x45_M855A1`,`RH_30Rnd_556x45_M855A1`],[],[`RH_30Rnd_556x45_M855A1`,`RH_15Rnd_9x19_SIG`],[``,``,`RH_compM2`,``],[``,``,``,``],[`life_inv_medkit`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_RoadBlockWood`,`life_inv_RoadBlockWood`,`life_inv_RoadConeStripB`,`life_inv_RoadConeStripB`],``,[``,``,``,``]]\"', '0', '0', '\"[`Cdt. John Brown`,`Warden. John Brown`]\"', '0', '64', '\"[`A3LShirt`,``,`B_AssaultPack_cbr`,``,``,[`ItemMap`,`ItemCompass`,`cg_tabletd_1`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 03:47:42', '2016-10-26 22:29:01', '\"[]\"', '0', '0', 'none', '0');
176INSERT INTO `players` VALUES ('13', 'Meow Mang', '76561198170036942', '6400', '29351', '2', '\"[]\"', '\"[[`license_civ_MDMA`,0],[`license_civ_meth`,0],[`license_civ_coke`,0],[`license_civ_driver`,1],[`license_civ_air`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_gang`,0],[`license_civ_boat`,0],[`license_civ_oil`,0],[`license_civ_dive`,0],[`license_civ_truck`,0],[`license_civ_gun`,0],[`license_civ_rebel`,1],[`license_civ_diamond`,0],[`license_civ_copper`,0],[`license_civ_iron`,0],[`license_civ_sand`,0],[`license_civ_salt`,0],[`license_civ_cement`,0],[`license_civ_home`,0],[`license_civ_rifle`,0]]\"', '\"[]\"', '\"[]\"', '0', '0', '\"[`Meow Mang`]\"', '0', '19', '\"[`TRYK_U_B_PCUHsW2`,``,`koilbp_17`,``,``,[`ItemMap`,`ItemCompass`,`cg_tabletd_7`],`hlc_rifle_ak47`,``,[],[`hlc_30Rnd_762x39_b_ak`],[`A3LShirt`],[`hlc_30Rnd_762x39_b_ak`,`RH_20Rnd_57x28_FN`,`RH_20Rnd_57x28_FN`,`hlc_30Rnd_762x39_b_ak`,`hlc_30Rnd_762x39_b_ak`,`hlc_30Rnd_762x39_b_ak`],[],[],[``,``,``,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 22:15:41', '2016-10-26 22:49:06', '\"[]\"', '0', '0', 'none', '0');
177INSERT INTO `players` VALUES ('14', 'Sid Welsh', '76561198267516609', '930', '151488', '2', '\"[[`license_cop_air`,1],[`license_cop_swat`,0],[`license_cop_cg`,1]]\"', '\"[]\"', '\"[]\"', '\"[`doc_uniform_sgt`,`DOC_Vest_Threat_Fix`,`AM_PoliceBelt`,`G_Bandanna_blk`,`Campaign_Hat_Light`,[`ItemCompass`,`Itemwatch`,`tf_anprc152_16`,`ItemGPS`],`arifle_mas_m4`,``,[],[`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`],[],[],[],[`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`],[``,``,`optic_mas_acog`,``],[``,``,``,``],[`life_inv_medkit`,`life_inv_medkit`],``,[``,``,``,``]]\"', '0', '0', '\"[`Sid Welsh`]\"', '0', '70', '\"[`A3LShirt`,``,`B_AssaultPack_cbr`,``,``,[`ItemMap`,`ItemCompass`,`cg_tabletd_2`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 20:15:10', '2016-10-26 23:01:49', '\"[]\"', '0', '0', 'none', '0');
178INSERT INTO `players` VALUES ('15', 'J.Wood', '76561198121596213', '300', '91167', '2', '\"[]\"', '\"[[`license_civ_MDMA`,0],[`license_civ_meth`,0],[`license_civ_coke`,0],[`license_civ_driver`,1],[`license_civ_air`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_gang`,0],[`license_civ_boat`,0],[`license_civ_oil`,0],[`license_civ_dive`,0],[`license_civ_truck`,0],[`license_civ_gun`,0],[`license_civ_rebel`,0],[`license_civ_diamond`,0],[`license_civ_copper`,0],[`license_civ_iron`,0],[`license_civ_sand`,0],[`license_civ_salt`,0],[`license_civ_cement`,0],[`license_civ_home`,0],[`license_civ_rifle`,0]]\"', '\"[]\"', '\"[`doc_uniform_co`,`DOC_Vest_Tac_Fix`,`AM_PoliceBelt`,`G_Bandanna_blk`,`Campaign_Hat_Light`,[`ItemMap`,`ItemCompass`,`Itemwatch`,`tf_anprc152_23`],`RH_M4_moe_g`,`Taser_26`,[],[`RH_18Rnd_9x19_VP`,`CG_ATF_Handcuffs_i`,`CG_ATF_Handcuffs_i`,`CG_ATF_Handcuffs_i`,`CG_ATF_Handcuffs_i`,`26_cartridge`,`26_cartridge`,`26_cartridge`],[`ToolKit`,`ToolKit`],[`RH_30Rnd_556x45_M855A1`,`RH_30Rnd_556x45_M855A1`,`RH_30Rnd_556x45_M855A1`],[],[`26_cartridge`,`26_cartridge`,`RH_30Rnd_556x45_M855A1`,`RH_30Rnd_556x45_M855A1`,`RH_30Rnd_556x45_M855A1`,`RH_30Rnd_556x45_M855A1`,`26_cartridge`],[``,``,`FHQ_optic_AIM`,``],[``,``,``,``],[`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`],``,[``,``,``,``]]\"', '2', '0', '\"[`J.Wood`]\"', '0', '257', '\"[`A3LShirt`,``,`B_AssaultPack_cbr`,``,``,[`ItemMap`,`ItemCompass`,`cg_tabletd_1`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 23:05:16', '2016-10-27 00:30:05', '\"[`RF_EMS_1`,``,``,``,`TCG_pdav_helmet`,[`ItemMap`,`ItemCompass`,`tf_microdagr`,`tf_anprc154_1`],`A3L_Extinguisher`,``,[],[`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`30Rnd_test_mag_Tracer`,`30Rnd_test_mag_Tracer`,`30Rnd_test_mag_Tracer`,`30Rnd_test_mag_Tracer`,`30Rnd_test_mag_Tracer`,`30Rnd_test_mag_Tracer`,`30Rnd_test_mag_Tracer`],[],[],[],[],[``,``,``,``],[``,``,``,``],[`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`],``,[``,``,``,``]]\"', '0', '0', 'none', '0');
179INSERT INTO `players` VALUES ('16', 'Ofc. Kitten Mang 412', '76561198245422302', '-2', '100000', '0', '\"[]\"', '\"[]\"', '\"[]\"', '\"[]\"', '0', '0', '\"[`Ofc. Kitten Mang 412`]\"', '0', '4', '\"[`A3LShirt`,``,`B_AssaultPack_cbr`,``,``,[`ItemMap`,`ItemCompass`,`cg_tabletd_7`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 02:15:05', '2016-10-27 01:21:21', '\"[]\"', '0', '0', 'none', '0');
180INSERT INTO `players` VALUES ('17', 'Filip.', '76561198065960406', '0', '276500', '0', '\"[]\"', '\"[[`license_civ_MDMA`,0],[`license_civ_meth`,0],[`license_civ_coke`,0],[`license_civ_driver`,1],[`license_civ_air`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_gang`,0],[`license_civ_boat`,1],[`license_civ_oil`,0],[`license_civ_dive`,0],[`license_civ_truck`,0],[`license_civ_gun`,1],[`license_civ_rebel`,1],[`license_civ_diamond`,0],[`license_civ_copper`,0],[`license_civ_iron`,0],[`license_civ_sand`,0],[`license_civ_salt`,0],[`license_civ_cement`,0],[`license_civ_home`,0],[`license_civ_rifle`,0]]\"', '\"[]\"', '\"[]\"', '0', '0', '\"[`Filip.`]\"', '0', '164', '\"[`A3LShirt`,``,`B_AssaultPack_cbr`,``,``,[`ItemMap`,`ItemCompass`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[`life_inv_tierope`,`life_inv_tbacon`,`life_inv_tbacon`,`life_inv_tbacon`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 21:52:43', '2016-10-27 10:25:06', '\"[]\"', '0', '0', 'none', '0');
181INSERT INTO `players` VALUES ('18', 'TipsyTigerr', '76561198043529465', '649', '136793', '7', '\"[]\"', '\"[[`license_civ_MDMA`,0],[`license_civ_meth`,0],[`license_civ_coke`,0],[`license_civ_driver`,0],[`license_civ_air`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_gang`,0],[`license_civ_boat`,0],[`license_civ_oil`,0],[`license_civ_dive`,0],[`license_civ_truck`,0],[`license_civ_gun`,1],[`license_civ_rebel`,0],[`license_civ_diamond`,0],[`license_civ_copper`,0],[`license_civ_iron`,0],[`license_civ_sand`,0],[`license_civ_salt`,0],[`license_civ_cement`,0],[`license_civ_home`,0],[`license_civ_rifle`,0]]\"', '\"[]\"', '\"[`CG_SERT3`,`kaelvest_sert2_Fix`,`AM_PoliceBelt`,`Mask_M40`,`CG_sert_H3`,[`ItemMap`,`tf_anprc152_15`,`ItemGPS`,`Rangefinder`],`arifle_mas_m4`,`Taser_26`,[],[],[`ToolKit`],[],[],[`30Rnd_mas_556x45_Stanag`,`CG_Spikes_Collapsed`,`CG_ATF_Handcuffs_i`,`Chemlight_red`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`26_cartridge`,`26_cartridge`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`26_cartridge`],[``,``,`optic_mas_aim`,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', '0', '\"[`TipsyTigerr`]\"', '0', '-2435', '\"[`cg_jounie1`,``,`koileagle`,`Masque_Chirurgical`,`Gorb_KnittedHat1`,[`ItemMap`,`ItemCompass`,`cg_tabletd_5`,`ItemGPS`],``,`RH_g17`,[],[`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`],[`ToolKit`],[],[],[],[``,``,``,``],[``,``,``,``],[`life_inv_medkit`,`life_inv_tierope`,`life_inv_apple`,`life_inv_apple`,`life_inv_apple`,`life_inv_apple`,`life_inv_apple`,`life_inv_apple`,`life_inv_apple`,`life_inv_apple`,`life_inv_apple`,`life_inv_apple`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 21:49:44', '2016-10-27 10:37:22', '\"[]\"', '0', '0', 'none', '0');
182INSERT INTO `players` VALUES ('19', '[Trainee]Bailey [108]', '76561198089026089', '0', '168059', '0', '\"[]\"', '\"[]\"', '\"[]\"', '\"[]\"', '1', '0', '\"[`Bailey`,`[Trainee]Bailey [108]`]\"', '0', '84', '\"[`A3LShirt`,``,`B_AssaultPack_cbr`,``,``,[],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 22:59:05', '2016-10-27 10:41:25', '\"[`CG_EMS1`,``,``,``,``,[`ItemMap`,`ItemCompass`,`tf_microdagr`,`tf_anprc148jem_2`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[`life_inv_bec`,`life_inv_bec`,`life_inv_bec`],``,[``,``,``,``]]\"', '0', '0', 'none', '0');
183INSERT INTO `players` VALUES ('20', 'Connor Thompson', '76561198206113264', '0', '100000', '0', '\"[]\"', '\"[]\"', '\"[]\"', '\"[]\"', '0', '0', '\"[`Connor Thompson`]\"', '0', '0', '\"[`A3LShirt`,``,`B_AssaultPack_cbr`,``,``,[`ItemMap`,`ItemCompass`,`cg_tabletd_5`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 10:48:10', '2016-10-27 10:42:40', '\"[]\"', '0', '0', 'none', '0');
184INSERT INTO `players` VALUES ('21', 'C.Quality', '76561198114353171', '0', '157802', '2', '\"[]\"', '\"[[`license_civ_MDMA`,0],[`license_civ_meth`,0],[`license_civ_coke`,0],[`license_civ_driver`,1],[`license_civ_air`,1],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_gang`,0],[`license_civ_boat`,1],[`license_civ_oil`,0],[`license_civ_dive`,0],[`license_civ_truck`,1],[`license_civ_gun`,0],[`license_civ_rebel`,1],[`license_civ_diamond`,0],[`license_civ_copper`,0],[`license_civ_iron`,0],[`license_civ_sand`,0],[`license_civ_salt`,0],[`license_civ_cement`,0],[`license_civ_home`,1],[`license_civ_rifle`,0]]\"', '\"[]\"', '\"[`CG_SO3`,`SCommand_Vest_Fix`,`AM_PoliceBelt`,``,`Campaign_Hat_Light`,[`ItemMap`,`ItemCompass`,`tf_anprc152_13`,`ItemGPS`],`arifle_mas_m4`,`Taser_26`,[`cg_tabletd_9`],[`CG_ATF_Handcuffs_i`,`CG_ATF_Handcuffs_i`,`CG_ATF_Handcuffs_i`],[`KAEL_SUITS_BR_Judge`,`ToolKit`,`RH_m9`],[],[`Mask_M40`],[`RH_15Rnd_9x19_M9`,`RH_15Rnd_9x19_M9`,`RH_15Rnd_9x19_M9`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`RH_15Rnd_9x19_M9`,`CG_ATF_Handcuffs_i`,`30Rnd_mas_556x45_Stanag`,`RH_15Rnd_9x19_M9`,`26_cartridge`,`26_cartridge`,`26_cartridge`,`30Rnd_mas_556x45_Stanag`,`26_cartridge`],[``,``,``,``],[``,``,``,``],[`life_inv_medkit`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_apple`,`life_inv_apple`,`life_inv_apple`,`life_inv_apple`,`life_inv_apple`,`life_inv_apple`,`life_inv_apple`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_fuelF`,`life_inv_fuelF`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_redgull`],``,[``,``,``,``]]\"', '5', '0', '\"[`C.Quality`]\"', '0', '236', '\"[`OrangePlaid_uni`,`k_nhrebel_6`,`B_TacticalPack_oli`,``,`kio_vfv_mask`,[`ItemMap`,`ItemCompass`,`cg_tabletd_2`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[`life_inv_medkit`,`life_inv_medkit`,`life_inv_medkit`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_tbacon`,`life_inv_tbacon`,`life_inv_tbacon`,`life_inv_tbacon`,`life_inv_tbacon`,`life_inv_tbacon`,`life_inv_tbacon`,`life_inv_tbacon`],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 23:09:37', '2016-10-27 12:15:58', '\"[`CG_EMS1`,`SERTvest2`,`cg_invisbp`,``,`A3L_medic_helmet`,[`ItemMap`,`ItemCompass`,`tf_microdagr`,`tf_anprc148jem_1`],`A3L_Extinguisher`,``,[],[`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`],[`ToolKit`],[],[],[`30Rnd_test_mag_Tracer`],[``,``,``,``],[``,``,``,``],[`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_apple`,`life_inv_apple`,`life_inv_apple`,`life_inv_apple`,`life_inv_apple`,`life_inv_apple`,`life_inv_apple`,`life_inv_apple`,`life_inv_apple`,`life_inv_apple`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_airkit`,`life_inv_airkit`,`life_inv_airkit`,`life_inv_airkit`,`life_inv_airkit`,`life_inv_airkit`,`life_inv_airkit`,`life_inv_airkit`,`life_inv_airkit`,`life_inv_condom`,`life_inv_condom`,`life_inv_condom`],``,[``,``,``,``]]\"', '0', '0', 'none', '0');
185INSERT INTO `players` VALUES ('22', 'Cpt.Jamie', '76561198144600256', '1534', '125025', '2', '\"[]\"', '\"[]\"', '\"[]\"', '\"[`doc_uniform_cmd`,`DOC_Vest_Threat_Fix`,`AM_PoliceBelt`,``,`corrections_cap`,[`tf_anprc152_2`],`arifle_mas_m4`,`RH_m9`,[],[`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`],[`ToolKit`],[`RH_15Rnd_9x19_M9`,`RH_15Rnd_9x19_M9`,`RH_15Rnd_9x19_M9`],[],[`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`RH_15Rnd_9x19_M9`,`RH_15Rnd_9x19_M9`,`RH_15Rnd_9x19_M9`,`RH_15Rnd_9x19_M9`,`RH_15Rnd_9x19_M9`,`RH_15Rnd_9x19_M9`,`30Rnd_mas_556x45_Stanag`,`RH_15Rnd_9x19_M9`],[``,``,``,``],[``,``,``,``],[`life_inv_medkit`,`life_inv_panicbutton`],``,[``,``,``,``]]\"', '2', '0', '\"[`Jamie Wood`,`Jamie Woody`,`Cpt . Jamie Wood `,`Cpt.Jamie Wood `,`Cpt.Jamie`]\"', '0', '125', '\"[`A3LShirt`,``,`B_AssaultPack_cbr`,``,``,[`ItemMap`,`ItemCompass`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 22:56:07', '2016-10-27 12:47:56', '\"[]\"', '0', '0', 'none', '0');
186INSERT INTO `players` VALUES ('23', 'Johnson Gold', '76561198171743210', '0', '161986', '2', '\"[]\"', '\"[]\"', '\"[]\"', '\"[`CG_SERT5`,`kaelvest_sert5_Fix`,`AM_PoliceBelt`,`Mask_M40`,`CG_sert_H5`,[`ItemMap`,`ItemCompass`,`tf_anprc152_20`,`ItemGPS`],`RH_hb_b`,``,[],[],[],[],[],[`29rnd_300BLK_STANAG_T`,`29rnd_300BLK_STANAG_T`,`29rnd_300BLK_STANAG_T`,`29rnd_300BLK_STANAG_T`,`29rnd_300BLK_STANAG_T`,`29rnd_300BLK_STANAG_T`,`29rnd_300BLK_STANAG_T`,`29rnd_300BLK_STANAG_T`,`29rnd_300BLK_STANAG_T`,`29rnd_300BLK_STANAG_T`,`29rnd_300BLK_STANAG_T`,`29rnd_300BLK_STANAG_T`,`29rnd_300BLK_STANAG_T`,`CG_ATF_Handcuffs_i`,`CG_ATF_Handcuffs_i`,`CG_ATF_Handcuffs_i`,`CG_ATF_Handcuffs_i`,`CG_ATF_Handcuffs_i`],[``,``,`FHQ_optic_AIM`,``],[``,``,``,``],[`life_inv_medkit`,`life_inv_panicbutton`],``,[``,``,``,``]]\"', '0', '0', '\"[`Johnson Gold`]\"', '0', '125', '\"[`A3LShirt`,``,`B_AssaultPack_cbr`,``,``,[`ItemMap`,`ItemCompass`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 22:15:25', '2016-10-27 13:35:07', '\"[]\"', '0', '0', 'none', '0');
187INSERT INTO `players` VALUES ('24', 'Snr . Jack', '76561198253468195', '31397', '20425', '2', '\"[]\"', '\"[]\"', '\"[]\"', '\"[`KAEL_SUITS_BR_F3`,`cg_policevest2_Fix`,`AM_PoliceBelt`,`G_Aviator`,`corrections_cap`,[`ItemMap`,`ItemCompass`,`tf_anprc152_7`,`ItemGPS`],`RH_M4_moe_g`,``,[],[],[`Taser_26`,`RH_m9`],[`RH_30Rnd_556x45_M855A1`,`RH_30Rnd_556x45_M855A1`,`RH_30Rnd_556x45_M855A1`],[],[`RH_30Rnd_556x45_M855A1`,`RH_30Rnd_556x45_M855A1`,`RH_30Rnd_556x45_M855A1`,`RH_30Rnd_556x45_M855A1`,`RH_30Rnd_556x45_M855A1`],[``,``,`FHQ_optic_AIM`,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', '0', '\"[`Snr . Jack`,`(-R-) J1ack`]\"', '0', '0', '\"[`KAEL_SUITS_BR_F4`,`hk_rebel_17`,`koilbp_12`,``,`cg_horsehead_pnk`,[`ItemMap`,`ItemCompass`,`cg_tabletd_15`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 19:16:34', '2016-10-27 13:50:56', '\"[]\"', '0', '0', 'none', '0');
188INSERT INTO `players` VALUES ('25', '[chief]W. OBrockly', '76561198236867766', '478', '124340', '0', '\"[]\"', '\"[[`license_civ_MDMA`,0],[`license_civ_meth`,0],[`license_civ_coke`,0],[`license_civ_driver`,1],[`license_civ_air`,1],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_gang`,0],[`license_civ_boat`,1],[`license_civ_oil`,0],[`license_civ_dive`,0],[`license_civ_truck`,0],[`license_civ_gun`,1],[`license_civ_rebel`,0],[`license_civ_diamond`,0],[`license_civ_copper`,0],[`license_civ_iron`,0],[`license_civ_sand`,0],[`license_civ_salt`,0],[`license_civ_cement`,0],[`license_civ_home`,0],[`license_civ_rifle`,0]]\"', '\"[[`license_med_air`,1]]\"', '\"[]\"', '5', '0', '\"[`[chief]W. OBrockly`]\"', '0', '146', '\"[`A3LShirt`,``,`B_AssaultPack_cbr`,``,``,[`ItemMap`,`ItemCompass`,`cg_tabletd_1`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 21:37:31', '2016-10-27 14:31:37', '\"[`CG_EMS8`,`SERTvest2`,`cg_invisbp`,`Masque_Chirurgical`,`TCG_pdav_helmet`,[`ItemMap`,`ItemCompass`,`tf_microdagr`,`tf_anprc148jem_4`,`ItemGPS`],`A3L_Extinguisher`,``,[`ItemCompass`,`ItemCompass`,`acc_flashlight`],[`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`,`CG_ATF_Drug_Bottle_01_i`],[`ToolKit`,`ItemCompass`,`ItemCompass`,`ItemCompass`,`A3L_Shovel`],[],[],[],[``,``,``,``],[``,``,``,``],[`life_inv_panicbutton`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_water`,`life_inv_tbacon`,`life_inv_tbacon`,`life_inv_tbacon`,`life_inv_tbacon`,`life_inv_tbacon`,`life_inv_RoadConeStrip`,`life_inv_RoadConeStripB`],`cg_torch`,[``,`cg_torchbattery`,``,``]]\"', '0', '0', 'none', '0');
189INSERT INTO `players` VALUES ('26', 'UnderSheriff O. Ericsson', '76561198103882123', '1709', '98605', '7', '\"[[`license_cop_air`,1],[`license_cop_swat`,0],[`license_cop_cg`,1]]\"', '\"[]\"', '\"[]\"', '\"[`CG_SO3`,`SCommand_Vest_Fix`,`AM_PoliceBelt`,`G_Aviator`,`Campaign_Hat_Washedout`,[`ItemMap`,`ItemCompass`,`tf_anprc152_38`,`ItemGPS`],`srifle_mas_hk417`,`Taser_26`,[`RH_eotech553`],[`CG_Spikes_Collapsed`,`CG_ATF_Handcuffs_i`,`CG_Spikes_Collapsed`,`CG_Spikes_Collapsed`,`CG_Spikes_Collapsed`,`CG_Spikes_Collapsed`,`CG_Spikes_Collapsed`,`20Rnd_mas_762x51_Stanag`,`20Rnd_mas_762x51_Stanag`],[`optic_Hamr`,`ToolKit`],[`26_cartridge`,`26_cartridge`,`26_cartridge`,`26_cartridge`,`26_cartridge`,`26_cartridge`,`26_cartridge`],[],[`20Rnd_mas_762x51_Stanag`,`26_cartridge`,`20Rnd_mas_762x51_Stanag`,`26_cartridge`,`20Rnd_mas_762x51_Stanag`,`26_cartridge`,`20Rnd_mas_762x51_Stanag`,`26_cartridge`,`20Rnd_mas_762x51_Stanag`],[`muzzle_snds_B`,``,`optic_MRCO`,``],[``,``,``,``],[`life_inv_medkit`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_RoadBlockWood`,`life_inv_RoadBlockWood`,`life_inv_RoadBlockWood`,`life_inv_RoadBlockWood`,`life_inv_RoadBlockWood`,`life_inv_RoadBlockWood`,`life_inv_RoadBlockWood`,`life_inv_RoadBlockWood`,`life_inv_RoadBlockWood`,`life_inv_RoadBlockWood`,`life_inv_RoadBlockWood`,`life_inv_RoadBlockWood`],``,[``,``,``,``]]\"', '0', '0', '\"[`UnderSheriff O. Ericsson`]\"', '0', '54', '\"[`A3LShirt`,``,`B_AssaultPack_cbr`,``,``,[`ItemMap`,`ItemCompass`,`cg_tabletd_19`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 17:07:23', '2016-10-27 14:37:37', '\"[]\"', '0', '0', 'none', '0');
190INSERT INTO `players` VALUES ('27', 'Archie Lewis', '76561198095190108', '999', '6821400', '0', '\"[]\"', '\"[]\"', '\"[]\"', '\"[]\"', '0', '0', '\"[`Archie Lewis`]\"', '0', '17', '\"[`A3LShirt`,``,`B_AssaultPack_cbr`,``,``,[`ItemMap`,`ItemCompass`],``,``,[`A3L_CZ550Scope`],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 17:13:25', '2016-10-27 15:08:08', '\"[]\"', '0', '0', 'none', '0');
191INSERT INTO `players` VALUES ('28', 'Liam Green', '76561198212507832', '2333', '101299', '2', '\"[]\"', '\"[[`license_civ_MDMA`,0],[`license_civ_meth`,0],[`license_civ_coke`,0],[`license_civ_driver`,0],[`license_civ_air`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_gang`,0],[`license_civ_boat`,0],[`license_civ_oil`,0],[`license_civ_dive`,0],[`license_civ_truck`,0],[`license_civ_gun`,1],[`license_civ_rebel`,0],[`license_civ_diamond`,0],[`license_civ_copper`,0],[`license_civ_iron`,0],[`license_civ_sand`,0],[`license_civ_salt`,0],[`license_civ_cement`,0],[`license_civ_home`,0],[`license_civ_rifle`,0]]\"', '\"[]\"', '\"[`CG_SO1`,`cg_policevest2_Fix`,`AM_PoliceBelt`,`G_Aviator`,`Campaign_Hat_Light`,[`ItemMap`,`ItemCompass`,`tf_anprc152_35`,`ItemGPS`],``,`Taser_26`,[],[`CG_ATF_Handcuffs_i`,`CG_ATF_Handcuffs_i`,`CG_Spikes_Collapsed`,`CG_Spikes_Collapsed`,`CG_Spikes_Collapsed`,`CG_Spikes_Collapsed`],[`ToolKit`,`RH_g19`],[`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`],[],[`26_cartridge`,`26_cartridge`,`26_cartridge`,`26_cartridge`,`26_cartridge`,`26_cartridge`],[``,``,``,``],[``,``,``,``],[`life_inv_medkit`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`],``,[``,``,``,``]]\"', '0', '0', '\"[`Liam Green`]\"', '0', '25', '\"[`KAEL_SUITS_BR_F12`,`k_hrebel_5`,`TRYK_B_Coyotebackpack_BLK`,`TRYK_Beard_Gr4`,`TRYK_r_cap_blk_Glasses`,[`ItemMap`,`ItemCompass`,`cg_tabletd_23`],``,`RH_g19`,[],[],[],[`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`,`RH_17Rnd_9x19_g17`],[],[`RH_17Rnd_9x19_g17`],[``,``,``,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 17:19:08', '2016-10-27 15:53:26', '\"[]\"', '0', '0', 'none', '0');
192INSERT INTO `players` VALUES ('29', 'Sheriff S. Stenquist', '76561198079703753', '65', '120438', '6', '\"[]\"', '\"[[`license_civ_MDMA`,0],[`license_civ_meth`,0],[`license_civ_coke`,0],[`license_civ_driver`,1],[`license_civ_air`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_gang`,0],[`license_civ_boat`,0],[`license_civ_oil`,0],[`license_civ_dive`,0],[`license_civ_truck`,0],[`license_civ_gun`,0],[`license_civ_rebel`,1],[`license_civ_diamond`,0],[`license_civ_copper`,0],[`license_civ_iron`,0],[`license_civ_sand`,0],[`license_civ_salt`,0],[`license_civ_cement`,0],[`license_civ_home`,0],[`license_civ_rifle`,0]]\"', '\"[]\"', '\"[`CG_SO3`,`highthreatvesttan_Fix`,`AM_PoliceBelt`,`G_Aviator`,`max_sheriff_Hat`,[],``,`Radar_Gun`,[],[`RH_7Rnd_45cal_m1911`,`RH_7Rnd_45cal_m1911`,`RH_7Rnd_45cal_m1911`,`RH_7Rnd_45cal_m1911`,`26_cartridge`,`26_cartridge`],[],[],[],[`26_cartridge`,`26_cartridge`,`26_cartridge`],[``,``,``,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', '0', '\"[`S. Stenquist`,`Sheriff S. Stenquist`]\"', '0', '76', '\"[`A3L_Zombie`,`CG_HC_Vests`,`cg_invisbp`,``,`a3l_hardhat`,[`ItemMap`,`cg_tabletd_44`,`BH_ImpNVChip`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[],`cg_hatchet`,[``,``,``,``]]\"', '0', null, null, '2016-10-27 19:40:54', '2016-10-27 16:21:06', '\"[]\"', '0', '0', 'none', '0');
193INSERT INTO `players` VALUES ('30', 'Kieran Barton', '76561198273429885', '79000', '24800', '0', '\"[]\"', '\"[]\"', '\"[]\"', '\"[]\"', '0', '0', '\"[`Kieran Barton`]\"', '0', '0', '\"[]\"', '0', null, null, '2016-10-27 16:36:57', '2016-10-27 16:22:09', '\"[]\"', '0', '0', 'none', '0');
194INSERT INTO `players` VALUES ('31', 'Raymond', '76561198130463603', '0', '420357', '0', '\"[]\"', '\"[[`license_civ_MDMA`,0],[`license_civ_meth`,0],[`license_civ_coke`,0],[`license_civ_driver`,0],[`license_civ_air`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_gang`,0],[`license_civ_boat`,0],[`license_civ_oil`,0],[`license_civ_dive`,0],[`license_civ_truck`,0],[`license_civ_gun`,1],[`license_civ_rebel`,1],[`license_civ_diamond`,0],[`license_civ_copper`,0],[`license_civ_iron`,0],[`license_civ_sand`,0],[`license_civ_salt`,0],[`license_civ_cement`,0],[`license_civ_home`,0],[`license_civ_rifle`,0]]\"', '\"[]\"', '\"[]\"', '0', '0', '\"[`Raymond`]\"', '0', '-13', '\"[`A3LShirt`,``,`B_AssaultPack_cbr`,``,``,[`ItemMap`,`ItemCompass`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[`life_inv_tierope`,`life_inv_tierope`,`life_inv_tbacon`,`life_inv_tbacon`,`life_inv_tbacon`,`life_inv_lockpick`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 22:39:43', '2016-10-27 16:29:40', '\"[]\"', '0', '0', 'none', '0');
195INSERT INTO `players` VALUES ('32', 'Lt. R. OBrockly', '76561198130020241', '2027', '40850', '7', '\"[[`license_cop_air`,0],[`license_cop_swat`,0],[`license_cop_cg`,1]]\"', '\"[[`license_civ_MDMA`,0],[`license_civ_meth`,0],[`license_civ_coke`,0],[`license_civ_driver`,1],[`license_civ_air`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_gang`,0],[`license_civ_boat`,0],[`license_civ_oil`,0],[`license_civ_dive`,0],[`license_civ_truck`,0],[`license_civ_gun`,1],[`license_civ_rebel`,0],[`license_civ_diamond`,0],[`license_civ_copper`,0],[`license_civ_iron`,0],[`license_civ_sand`,0],[`license_civ_salt`,0],[`license_civ_cement`,0],[`license_civ_home`,0],[`license_civ_rifle`,0]]\"', '\"[]\"', '\"[`TRYK_U_denim_hood_blk`,`kaelvest_sert2_Fix`,`AM_PoliceBelt`,`Mask_M40`,`TRYK_H_PASGT_OD`,[`ItemMap`,`ItemCompass`,`tf_anprc152_18`,`ItemGPS`],`arifle_mas_m4`,`RH_kimber_nw`,[],[`26_cartridge`,`26_cartridge`,`26_cartridge`,`26_cartridge`,`26_cartridge`],[`Taser_26`],[`26_cartridge`,`26_cartridge`,`RH_7Rnd_45cal_m1911`,`RH_7Rnd_45cal_m1911`,`RH_7Rnd_45cal_m1911`,`RH_7Rnd_45cal_m1911`,`RH_7Rnd_45cal_m1911`,`RH_7Rnd_45cal_m1911`,`30Rnd_mas_556x45_Stanag`,`RH_7Rnd_45cal_m1911`],[],[`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`30Rnd_mas_556x45_Stanag`,`CG_Spikes_Collapsed`,`CG_Spikes_Collapsed`,`26_cartridge`,`26_cartridge`,`CG_ATF_Handcuffs_i`,`CG_ATF_Handcuffs_i`,`CG_ATF_Handcuffs_i`,`CG_ATF_Handcuffs_i`,`CG_ATF_Handcuffs_i`,`CG_ATF_Handcuffs_i`],[``,``,``,``],[``,``,``,``],[`life_inv_medkit`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_panicbutton`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`,`life_inv_bandage`],``,[``,``,``,``]]\"', '0', '0', '\"[`Lt. R. OBrockly`]\"', '0', '8', '\"[`KAEL_SUITS_BR_F16`,`k_hrebel_7`,`TRYK_B_Coyotebackpack_BLK`,`Masque_Chirurgical`,`H_Cap_red`,[`ItemMap`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[`life_inv_bec`,`life_inv_bec`,`life_inv_medkit`,`life_inv_tierope`,`life_inv_tierope`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_redgull`,`life_inv_bandage`],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 21:45:11', '2016-10-27 17:54:04', '\"[]\"', '0', '0', 'none', '0');
196INSERT INTO `players` VALUES ('33', 'Nordan Johnston', '76561198109583767', '0', '100000', '0', '\"[]\"', '\"[]\"', '\"[]\"', '\"[]\"', '0', '0', '\"[`Nordan Johnston`]\"', '0', '0', '\"[`A3LShirt`,``,`B_AssaultPack_cbr`,``,``,[`ItemMap`,`ItemCompass`,`cg_tabletd_3`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 18:03:43', '2016-10-27 17:58:18', '\"[]\"', '0', '0', 'none', '0');
197INSERT INTO `players` VALUES ('34', 'Tomas Alves', '76561198314881745', '0', '100000', '1', '\"[]\"', '\"[]\"', '\"[]\"', '\"[`A3L_Sheriff_Uniform`,``,`AM_PoliceBelt`,``,``,[`ItemMap`,`ItemCompass`,`tf_rf7800str_8`,`ItemGPS`],``,`Taser_26`,[],[`26_cartridge`,`26_cartridge`,`26_cartridge`,`26_cartridge`,`26_cartridge`,`26_cartridge`],[],[],[],[],[``,``,``,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', '0', '\"[`Tomas Alves`]\"', '0', '0', '\"[]\"', '0', null, null, '2016-10-27 19:13:21', '2016-10-27 18:30:36', '\"[]\"', '0', '0', 'none', '0');
198INSERT INTO `players` VALUES ('35', 'ST CPT C.Silver 146', '76561198128331349', '0', '100000', '0', '\"[]\"', '\"[]\"', '\"[]\"', '\"[`A3L_Sheriff_Uniform`,``,`AM_PoliceBelt`,``,``,[`ItemMap`,`ItemCompass`,`tf_anprc152_14`,`ItemGPS`],``,`Taser_26`,[],[`26_cartridge`,`26_cartridge`,`26_cartridge`,`26_cartridge`],[],[],[],[],[``,``,``,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', '0', '\"[`ST CPT C.Silver 146`]\"', '0', '0', '\"[]\"', '0', null, null, '2016-10-27 19:38:39', '2016-10-27 19:28:32', '\"[]\"', '0', '0', 'none', '0');
199INSERT INTO `players` VALUES ('36', 'Jord Kent', '76561198103851318', '200', '99000', '0', '\"[]\"', '\"[[`license_civ_MDMA`,0],[`license_civ_meth`,0],[`license_civ_coke`,0],[`license_civ_driver`,1],[`license_civ_air`,0],[`license_civ_heroin`,0],[`license_civ_marijuana`,0],[`license_civ_gang`,0],[`license_civ_boat`,0],[`license_civ_oil`,0],[`license_civ_dive`,0],[`license_civ_truck`,0],[`license_civ_gun`,0],[`license_civ_rebel`,0],[`license_civ_diamond`,0],[`license_civ_copper`,0],[`license_civ_iron`,0],[`license_civ_sand`,0],[`license_civ_salt`,0],[`license_civ_cement`,0],[`license_civ_home`,0],[`license_civ_rifle`,0]]\"', '\"[]\"', '\"[]\"', '0', '0', '\"[`Jord Kent`]\"', '0', '8', '\"[``,``,`B_AssaultPack_cbr`,``,``,[`ItemMap`,`ItemCompass`,`cg_tabletd_10`],``,``,[],[],[],[],[],[],[``,``,``,``],[``,``,``,``],[],``,[``,``,``,``]]\"', '0', null, null, '2016-10-27 22:10:32', '2016-10-27 21:44:41', '\"[]\"', '0', '0', 'none', '0');
200
201-- ----------------------------
202-- Table structure for `servers`
203-- ----------------------------
204DROP TABLE IF EXISTS `servers`;
205CREATE TABLE `servers` (
206 `id` int(11) NOT NULL AUTO_INCREMENT,
207 `name` varchar(255) DEFAULT NULL,
208 `ip` varchar(55) DEFAULT NULL,
209 `port` varchar(10) DEFAULT NULL,
210 `password` varchar(255) DEFAULT NULL,
211 `status` varchar(5) DEFAULT NULL,
212 PRIMARY KEY (`id`)
213) ENGINE=InnoDB DEFAULT CHARSET=utf8;
214
215-- ----------------------------
216-- Records of servers
217-- ----------------------------
218
219-- ----------------------------
220-- Table structure for `users`
221-- ----------------------------
222DROP TABLE IF EXISTS `users`;
223CREATE TABLE `users` (
224 `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'auto incrementing user_id of each user, unique index',
225 `user_name` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'user''s name, unique',
226 `user_password_hash` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'user''s password in salted and hashed format',
227 `user_email` varchar(64) COLLATE utf8_unicode_ci NOT NULL COMMENT 'user''s email, unique',
228 `playerid` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
229 `user_level` enum('1','2') COLLATE utf8_unicode_ci NOT NULL DEFAULT '1',
230 PRIMARY KEY (`user_id`),
231 UNIQUE KEY `user_name` (`user_name`),
232 UNIQUE KEY `user_email` (`user_email`)
233) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='user data';
234
235-- ----------------------------
236-- Records of users
237-- ----------------------------
238
239-- ----------------------------
240-- Table structure for `vehicles`
241-- ----------------------------
242DROP TABLE IF EXISTS `vehicles`;
243CREATE TABLE `vehicles` (
244 `id` int(12) NOT NULL AUTO_INCREMENT,
245 `side` varchar(15) NOT NULL,
246 `classname` varchar(32) NOT NULL,
247 `type` varchar(12) NOT NULL,
248 `pid` varchar(32) NOT NULL,
249 `alive` tinyint(1) NOT NULL DEFAULT '1',
250 `active` tinyint(1) NOT NULL DEFAULT '0',
251 `plate` int(20) NOT NULL,
252 `color` int(20) NOT NULL,
253 `inventory` varchar(500) NOT NULL,
254 PRIMARY KEY (`id`),
255 KEY `side` (`side`),
256 KEY `pid` (`pid`),
257 KEY `type` (`type`)
258) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=latin1;
259
260-- ----------------------------
261-- Records of vehicles
262-- ----------------------------
263INSERT INTO `vehicles` VALUES ('1', 'cop', 'cg_evoSERT1', 'Car', '76561198065459302', '1', '0', '789447', '0', '\"[]\"');
264INSERT INTO `vehicles` VALUES ('2', 'cop', 'C_Heli_Light_01_civil_F', 'Air', '76561198065459302', '1', '0', '474269', '0', '\"[]\"');
265INSERT INTO `vehicles` VALUES ('3', 'cop', 'cg_evoss1', 'Car', '76561198081705058', '1', '0', '922425', '0', '\"[]\"');
266INSERT INTO `vehicles` VALUES ('4', 'cop', 'charger_sh_skinned', 'Car', '76561198081705058', '1', '0', '513955', '0', '\"[]\"');
267INSERT INTO `vehicles` VALUES ('5', 'cop', 'cg_ss2', 'Car', '76561198081705058', '1', '0', '589996', '0', '\"[]\"');
268INSERT INTO `vehicles` VALUES ('6', 'cop', 'charger_sh_skinned', 'Car', '76561198242934548', '1', '0', '465357', '0', '\"[]\"');
269INSERT INTO `vehicles` VALUES ('7', 'cop', 'MELB_H6M', 'Air', '76561198081705058', '0', '0', '133269', '0', '\"[]\"');
270INSERT INTO `vehicles` VALUES ('8', 'cop', 'cg_evoblack', 'Car', '76561198077234366', '0', '0', '675546', '0', '\"[]\"');
271INSERT INTO `vehicles` VALUES ('9', 'cop', 'charger_sh_skinned', 'Car', '76561198242934548', '1', '0', '700939', '0', '\"[]\"');
272INSERT INTO `vehicles` VALUES ('10', 'cop', 'cg_evoblack', 'Car', '76561198081705058', '1', '0', '719700', '0', '\"[]\"');
273INSERT INTO `vehicles` VALUES ('11', 'cop', 'DAR_ExplorerSheriff', 'Car', '76561198242934548', '1', '0', '510629', '0', '\"[]\"');
274INSERT INTO `vehicles` VALUES ('12', 'cop', 'charger_sh_skinned', 'Car', '76561198242934548', '1', '0', '724983', '0', '\"[]\"');
275INSERT INTO `vehicles` VALUES ('13', 'cop', 'A3L_ChargerUC', 'Car', '76561198081705058', '1', '0', '585338', '0', '\"[]\"');
276INSERT INTO `vehicles` VALUES ('14', 'cop', 'A3L_TaurusUCWhite', 'Car', '76561198081705058', '1', '0', '671146', '0', '\"[]\"');
277INSERT INTO `vehicles` VALUES ('15', 'cop', 'cg_evocor1', 'Car', '76561198121596213', '1', '0', '22250', '0', '\"[]\"');
278INSERT INTO `vehicles` VALUES ('16', 'cop', 'cg_evocor1', 'Car', '76561198121596213', '0', '0', '484258', '0', '\"[]\"');
279INSERT INTO `vehicles` VALUES ('17', 'cop', 'A3L_SuburbanDOC', 'Car', '76561198242934548', '1', '0', '229194', '0', '\"[]\"');
280INSERT INTO `vehicles` VALUES ('18', 'cop', 'cg_taurustrooperf', 'Car', '76561198242934548', '1', '0', '230453', '0', '\"[]\"');
281INSERT INTO `vehicles` VALUES ('19', 'cop', 'A3L_jailBus', 'Car', '76561198242934548', '1', '0', '901020', '0', '\"[]\"');
282INSERT INTO `vehicles` VALUES ('20', 'cop', 'charger_cor_skinned', 'Car', '76561198242934548', '1', '0', '216290', '0', '\"[]\"');
283INSERT INTO `vehicles` VALUES ('21', 'civ', 'Jonzie_STI', 'Car', '76561198081705058', '1', '0', '19138', '0', '\"[]\"');
284INSERT INTO `vehicles` VALUES ('22', 'civ', 'Jonzie_Raptor', 'Car', '76561198081705058', '1', '0', '235826', '0', '\"[]\"');
285INSERT INTO `vehicles` VALUES ('23', 'cop', 'A3L_CVPIUCBlack', 'Car', '76561198242934548', '1', '0', '834607', '0', '\"[]\"');
286INSERT INTO `vehicles` VALUES ('24', 'civ', 'CG_Taxi', 'Car', '76561198162599111', '1', '0', '157913', '0', '\"[]\"');
287INSERT INTO `vehicles` VALUES ('25', 'civ', 'CG_Taxi', 'Car', '76561198065960406', '0', '0', '666149', '0', '\"[]\"');
288INSERT INTO `vehicles` VALUES ('26', 'cop', 'cg_CVPIFPBPD', 'Car', '76561198043529465', '1', '0', '924751', '0', '\"[]\"');
289INSERT INTO `vehicles` VALUES ('27', 'cop', 'A3L_CVPIUCBlack', 'Car', '76561198043529465', '1', '0', '451581', '0', '\"[]\"');
290INSERT INTO `vehicles` VALUES ('28', 'cop', 'A3L_CVPIUCBlack', 'Car', '76561198043529465', '1', '0', '543286', '0', '\"[]\"');
291INSERT INTO `vehicles` VALUES ('29', 'cop', 'B_Heli_Light_01_F', 'Air', '76561198043529465', '1', '0', '764979', '0', '\"[]\"');
292INSERT INTO `vehicles` VALUES ('30', 'cop', 'charger_sert', 'Car', '76561198043529465', '1', '0', '323104', '0', '\"[]\"');
293INSERT INTO `vehicles` VALUES ('31', 'civ', 'CG_Taxi', 'Car', '76561198114353171', '1', '0', '111460', '0', '\"[]\"');
294INSERT INTO `vehicles` VALUES ('32', 'civ', 'tcg_hrly', 'Car', '76561198114353171', '1', '0', '766687', '0', '\"[]\"');
295INSERT INTO `vehicles` VALUES ('33', 'civ', 'A3L_Towtruck', 'Car', '76561198114353171', '1', '0', '841083', '0', '\"[]\"');
296INSERT INTO `vehicles` VALUES ('34', 'cop', 'AM_Holden_UM', 'Car', '76561198065459302', '1', '0', '4044', '0', '\"[]\"');
297INSERT INTO `vehicles` VALUES ('35', 'civ', 'cg_peugeot_508_civ_rouge', 'Car', '76561198114353171', '1', '0', '569949', '0', '\"[]\"');
298INSERT INTO `vehicles` VALUES ('36', 'civ', 'ivory_rev', 'Car', '76561198144600256', '0', '0', '117997', '0', '\"[]\"');
299INSERT INTO `vehicles` VALUES ('37', 'civ', 'CG_Taxi', 'Car', '76561198065960406', '1', '0', '866875', '0', '\"[]\"');
300INSERT INTO `vehicles` VALUES ('38', 'cop', 'cg_CVPISH', 'Car', '76561198114353171', '1', '0', '405219', '0', '\"[]\"');
301INSERT INTO `vehicles` VALUES ('39', 'civ', 'CG_Taxi', 'Car', '76561198065960406', '1', '0', '257546', '0', '\"[]\"');
302INSERT INTO `vehicles` VALUES ('40', 'cop', 'cg_evoblack', 'Car', '76561198267516609', '1', '0', '61301', '0', '\"[]\"');
303INSERT INTO `vehicles` VALUES ('41', 'cop', 'AM_Holden_SO', 'Car', '76561198114353171', '1', '0', '642123', '0', '\"[]\"');
304INSERT INTO `vehicles` VALUES ('42', 'cop', 'cg_evocor1', 'Car', '76561198121596213', '1', '0', '756631', '0', '\"[]\"');
305INSERT INTO `vehicles` VALUES ('43', 'cop', 'DAR_ExplorerSheriff', 'Car', '76561198267516609', '1', '0', '166393', '0', '\"[]\"');
306INSERT INTO `vehicles` VALUES ('44', 'civ', 'CG_Taxi', 'Car', '76561198162599111', '1', '0', '520681', '0', '\"[]\"');
307INSERT INTO `vehicles` VALUES ('45', 'cop', 'A3L_SuburbanDOC', 'Car', '76561198121596213', '1', '0', '94823', '0', '\"[]\"');
308INSERT INTO `vehicles` VALUES ('46', 'civ', 'tcg_hrly_orig1', 'Car', '76561198253468195', '1', '0', '998945', '0', '\"[]\"');
309INSERT INTO `vehicles` VALUES ('47', 'cop', 'cg_CVPISH', 'Car', '76561198114353171', '0', '0', '731077', '0', '\"[]\"');
310INSERT INTO `vehicles` VALUES ('48', 'civ', 'CG_Taxi', 'Car', '76561198065960406', '1', '0', '548471', '0', '\"[]\"');
311INSERT INTO `vehicles` VALUES ('49', 'civ', 'Jonzie_Escalade', 'Car', '76561198081705058', '1', '0', '347129', '0', '\"[]\"');
312INSERT INTO `vehicles` VALUES ('50', 'cop', 'charger_cor_skinned', 'Car', '76561198144600256', '1', '0', '687285', '0', '\"[]\"');
313INSERT INTO `vehicles` VALUES ('51', 'civ', 'Sab_sea4_An2', 'Air', '76561198081705058', '0', '0', '199929', '0', '\"[]\"');
314INSERT INTO `vehicles` VALUES ('52', 'civ', 'CG_Taxi', 'Car', '76561198236867766', '1', '0', '510123', '0', '\"[]\"');
315INSERT INTO `vehicles` VALUES ('53', 'cop', 'cg_h2_sert', 'Car', '76561198171743210', '1', '0', '235152', '0', '\"[]\"');
316INSERT INTO `vehicles` VALUES ('54', 'cop', 'charger_sh', 'Car', '76561198103882123', '1', '0', '491924', '0', '\"[]\"');
317INSERT INTO `vehicles` VALUES ('55', 'civ', 'ivory_rev', 'Car', '76561198114353171', '1', '0', '616468', '10', '\"[]\"');
318INSERT INTO `vehicles` VALUES ('56', 'cop', 'charger_pd_skinned', 'Car', '76561198121596213', '0', '0', '647883', '0', '\"[]\"');
319INSERT INTO `vehicles` VALUES ('57', 'cop', 'cg_evoSERT1', 'Car', '76561198103882123', '1', '0', '684208', '0', '\"[]\"');
320INSERT INTO `vehicles` VALUES ('58', 'civ', 'S_Rangerover_Blue', 'Car', '76561198236867766', '1', '0', '95504', '0', '\"[]\"');
321INSERT INTO `vehicles` VALUES ('59', 'civ', 'ivory_b206', 'Air', '76561198236867766', '1', '0', '80211', '0', '\"[]\"');
322INSERT INTO `vehicles` VALUES ('60', 'cop', 'cg_h2_sert', 'Car', '76561198171743210', '1', '0', '549777', '0', '\"[]\"');
323INSERT INTO `vehicles` VALUES ('61', 'civ', 'CG_Taxi', 'Car', '76561198212507832', '1', '0', '427282', '0', '\"[]\"');
324INSERT INTO `vehicles` VALUES ('62', 'cop', 'A3L_ChargerUC', 'Car', '76561198103882123', '1', '0', '682663', '0', '\"[]\"');
325INSERT INTO `vehicles` VALUES ('63', 'cop', 'charger_cor_skinned', 'Car', '76561198121596213', '1', '0', '255260', '0', '\"[]\"');
326INSERT INTO `vehicles` VALUES ('64', 'civ', 'tcg_hrly_skeleton', 'Car', '76561198081705058', '1', '0', '165987', '0', '\"[]\"');
327INSERT INTO `vehicles` VALUES ('65', 'civ', 'tcg_hrly_skeleton', 'Car', '76561198079703753', '1', '0', '837865', '0', '\"[]\"');
328INSERT INTO `vehicles` VALUES ('66', 'cop', 'cg_ss2', 'Car', '76561198212507832', '1', '0', '241464', '0', '\"[]\"');
329INSERT INTO `vehicles` VALUES ('67', 'civ', 'A3L_EvoXrally_green', 'Car', '76561198095190108', '1', '0', '550386', '0', '\"[]\"');
330INSERT INTO `vehicles` VALUES ('68', 'civ', 'CG_Taxi', 'Car', '76561198162599111', '1', '0', '79082', '0', '\"[]\"');
331INSERT INTO `vehicles` VALUES ('69', 'cop', 'charger_cor_skinned', 'Car', '76561198144600256', '1', '0', '509857', '0', '\"[]\"');
332INSERT INTO `vehicles` VALUES ('70', 'cop', 'cg_CVPISH', 'Car', '76561198077234366', '0', '0', '397542', '0', '\"[]\"');
333INSERT INTO `vehicles` VALUES ('71', 'civ', 'critgamin_smart_vert', 'Car', '76561198079703753', '1', '0', '371279', '0', '\"[]\"');
334INSERT INTO `vehicles` VALUES ('72', 'civ', 'CG_Taxi', 'Car', '76561198065960406', '1', '0', '73693', '0', '\"[]\"');
335INSERT INTO `vehicles` VALUES ('73', 'med', 'DAR_TahoeEMS', 'Car', '76561198114353171', '1', '0', '823435', '0', '\"[]\"');
336INSERT INTO `vehicles` VALUES ('74', 'med', 'O_Heli_Transport_04_medevac_F', 'Air', '76561198236867766', '1', '0', '186321', '0', '\"[]\"');
337INSERT INTO `vehicles` VALUES ('75', 'cop', 'A3L_CVPIUCBlack', 'Car', '76561198130020241', '0', '0', '777248', '0', '\"[]\"');
338INSERT INTO `vehicles` VALUES ('76', 'cop', 'charger_sh_skinned', 'Car', '76561198079703753', '1', '0', '457701', '0', '\"[]\"');
339INSERT INTO `vehicles` VALUES ('77', 'med', 'cg_ambulanceexpansion', 'Car', '76561198236867766', '1', '0', '147750', '0', '\"[]\"');
340INSERT INTO `vehicles` VALUES ('78', 'cop', 'A3L_CVPIUCBlack', 'Car', '76561198130020241', '1', '0', '613927', '0', '\"[]\"');
341INSERT INTO `vehicles` VALUES ('79', 'med', 'EMS_Orca', 'Air', '76561198236867766', '0', '0', '178425', '0', '\"[]\"');
342INSERT INTO `vehicles` VALUES ('80', 'civ', 'AM_2015C_Black', 'Car', '76561198253468195', '1', '0', '570242', '0', '\"[]\"');
343INSERT INTO `vehicles` VALUES ('81', 'med', 'cg_evoems3', 'Car', '76561198236867766', '1', '0', '630452', '0', '\"[]\"');
344INSERT INTO `vehicles` VALUES ('82', 'cop', 'AM_Holden_UM', 'Car', '76561198077234366', '1', '1', '13222', '0', '\"[]\"');
345INSERT INTO `vehicles` VALUES ('83', 'cop', 'cg_evoss1', 'Car', '76561198079703753', '1', '0', '876228', '0', '\"[]\"');
346INSERT INTO `vehicles` VALUES ('84', 'cop', 'A3L_CVPIUCBlack', 'Car', '76561198253468195', '1', '0', '764266', '0', '\"[]\"');
347INSERT INTO `vehicles` VALUES ('85', 'med', 'EMS_Chopper', 'Air', '76561198236867766', '1', '0', '215691', '0', '\"[]\"');
348INSERT INTO `vehicles` VALUES ('86', 'civ', 'CG_Taxi', 'Car', '76561198089026089', '1', '0', '834872', '0', '\"[]\"');
349INSERT INTO `vehicles` VALUES ('87', 'civ', 'CG_Taxi', 'Car', '76561198121596213', '1', '0', '710168', '0', '\"[]\"');
350INSERT INTO `vehicles` VALUES ('88', 'civ', 'ivory_rev', 'Car', '76561198121596213', '1', '1', '585398', '0', '\"[]\"');
351INSERT INTO `vehicles` VALUES ('89', 'civ', 'critgamin_smart_civ', 'Car', '76561198043529465', '1', '0', '529431', '0', '\"[]\"');
352INSERT INTO `vehicles` VALUES ('90', 'civ', 'cg_peugeot_508_civ_rouge', 'Car', '76561198089026089', '1', '0', '129931', '0', '\"[]\"');
353INSERT INTO `vehicles` VALUES ('91', 'civ', 'AM_Holden_Black', 'Car', '76561198130020241', '0', '0', '723141', '0', '\"[]\"');
354INSERT INTO `vehicles` VALUES ('92', 'civ', 'critgamin_smart_violet', 'Car', '76561198089026089', '1', '0', '238590', '0', '\"[]\"');
355INSERT INTO `vehicles` VALUES ('93', 'med', 'DAR_TahoeEMS', 'Car', '76561198089026089', '1', '1', '796229', '0', '\"[]\"');
356INSERT INTO `vehicles` VALUES ('94', 'civ', 'A3L_EvoXrally_white', 'Car', '76561198065459302', '1', '0', '209245', '0', '\"[]\"');
357INSERT INTO `vehicles` VALUES ('95', 'civ', 'CG_Lamborghini_Aventador_Purple', 'Car', '76561198065459302', '1', '0', '673187', '0', '\"[]\"');
358INSERT INTO `vehicles` VALUES ('96', 'cop', 'cg_evopol1', 'Car', '76561198183443506', '1', '0', '397397', '0', '\"[]\"');
359INSERT INTO `vehicles` VALUES ('97', 'civ', 'Jonzie_XB', 'Car', '76561198065459302', '1', '0', '458066', '0', '\"[]\"');
360INSERT INTO `vehicles` VALUES ('98', 'cop', 'A3L_TaurusCO2', 'Car', '76561198077234366', '1', '0', '721216', '0', '\"[]\"');
361INSERT INTO `vehicles` VALUES ('99', 'cop', 'charger_pd_skinned', 'Car', '76561198077234366', '1', '1', '877577', '0', '\"[]\"');
362INSERT INTO `vehicles` VALUES ('100', 'med', 'A3L_CVPILBFD', 'Car', '76561198089026089', '1', '1', '364653', '0', '\"[]\"');
363INSERT INTO `vehicles` VALUES ('101', 'cop', 'A3L_CVPIUCPink', 'Car', '76561198130020241', '1', '0', '119523', '0', '\"[]\"');
364INSERT INTO `vehicles` VALUES ('102', 'civ', 'CG_Taxi', 'Car', '76561198170036942', '1', '0', '883555', '0', '\"[]\"');
365INSERT INTO `vehicles` VALUES ('103', 'civ', 'S_Rangerover_White', 'Car', '76561198170036942', '1', '0', '496691', '0', '\"[]\"');
366INSERT INTO `vehicles` VALUES ('104', 'cop', 'A3L_SuburbanCSO', 'Car', '76561198081705058', '1', '1', '221431', '0', '\"[]\"');
367INSERT INTO `vehicles` VALUES ('105', 'cop', 'cg_evoss1', 'Car', '76561198081705058', '1', '0', '581615', '0', '\"[]\"');
368INSERT INTO `vehicles` VALUES ('106', 'civ', 'S_Rangerover_Purple', 'Car', '76561198103851318', '1', '0', '446952', '0', '\"[]\"');
369INSERT INTO `vehicles` VALUES ('107', 'civ', 'A3L_Camaro', 'Car', '76561198103851318', '1', '0', '54405', '0', '\"[]\"');
370INSERT INTO `vehicles` VALUES ('108', 'med', 'EMS_Chopper2', 'Air', '76561198121596213', '1', '0', '700134', '0', '\"[]\"');
371INSERT INTO `vehicles` VALUES ('109', 'civ', 'Jonzie_Quattroporte', 'Car', '76561198065459302', '1', '1', '152342', '0', '\"[]\"');
372INSERT INTO `vehicles` VALUES ('110', 'cop', 'MELB_H6M', 'Air', '76561198144600256', '1', '0', '758045', '0', '\"[]\"');
373INSERT INTO `vehicles` VALUES ('111', 'cop', 'DAR_ExplorerPoliceStealth', 'Car', '76561198081705058', '1', '1', '629407', '0', '\"[]\"');
374INSERT INTO `vehicles` VALUES ('112', 'civ', 'B_Heli_Light_01_F', 'Air', '76561198114353171', '1', '1', '798987', '13', '\"[]\"');
375
376-- ----------------------------
377-- Procedure structure for `deleteOldContainers`
378-- ----------------------------
379DROP PROCEDURE IF EXISTS `deleteOldContainers`;
380DELIMITER ;;
381CREATE DEFINER=`BenJ`@`%` PROCEDURE `deleteOldContainers`()
382BEGIN
383 DELETE FROM `containers` WHERE `owned` = 0;
384END
385;;
386DELIMITER ;
387
388-- ----------------------------
389-- Procedure structure for `deleteOldGangs`
390-- ----------------------------
391DROP PROCEDURE IF EXISTS `deleteOldGangs`;
392DELIMITER ;;
393CREATE DEFINER=`BenJ`@`%` PROCEDURE `deleteOldGangs`()
394BEGIN
395 DELETE FROM `gangs` WHERE `active` = 0;
396END
397;;
398DELIMITER ;
399
400-- ----------------------------
401-- Procedure structure for `deleteOldHouses`
402-- ----------------------------
403DROP PROCEDURE IF EXISTS `deleteOldHouses`;
404DELIMITER ;;
405CREATE DEFINER=`BenJ`@`%` PROCEDURE `deleteOldHouses`()
406BEGIN
407 DELETE FROM `houses` WHERE `owned` = 0;
408END
409;;
410DELIMITER ;
411
412-- ----------------------------
413-- Procedure structure for `resetLifeVehicles`
414-- ----------------------------
415DROP PROCEDURE IF EXISTS `resetLifeVehicles`;
416DELIMITER ;;
417CREATE DEFINER=`BenJ`@`%` PROCEDURE `resetLifeVehicles`()
418BEGIN
419 UPDATE `vehicles` SET `active`= 0;
420END
421;;
422DELIMITER ;
423DROP TRIGGER IF EXISTS `player_create`;
424DELIMITER ;;
425CREATE TRIGGER `player_create` BEFORE INSERT ON `players` FOR EACH ROW SET NEW.timejoined = NOW()
426;;
427DELIMITER ;