· 6 years ago · Jul 09, 2019, 02:36 PM
1-- --------------------------------------------------------
2-- Host: 74.91.114.97
3-- Server version: 10.1.38-MariaDB - mariadb.org binary distribution
4-- Server OS: Win64
5-- HeidiSQL Version: 10.1.0.5464
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 armalife
16CREATE DATABASE IF NOT EXISTS `armalife` /*!40100 DEFAULT CHARACTER SET utf8mb4 */;
17USE `armalife`;
18
19-- Dumping structure for table armalife.armalife_phonemessages
20CREATE TABLE IF NOT EXISTS `armalife_phonemessages` (
21 `sender` varchar(50) DEFAULT NULL,
22 `receiver` varchar(50) DEFAULT NULL,
23 `message` text,
24 `timesent` timestamp NULL DEFAULT CURRENT_TIMESTAMP
25) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
26
27-- Dumping data for table armalife.armalife_phonemessages: ~0 rows (approximately)
28/*!40000 ALTER TABLE `armalife_phonemessages` DISABLE KEYS */;
29/*!40000 ALTER TABLE `armalife_phonemessages` ENABLE KEYS */;
30
31-- Dumping structure for table armalife.armalife_phonenumbers
32CREATE TABLE IF NOT EXISTS `armalife_phonenumbers` (
33 `number` varchar(50) DEFAULT NULL,
34 `uid` varchar(50) DEFAULT NULL
35) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
36
37-- Dumping data for table armalife.armalife_phonenumbers: ~0 rows (approximately)
38/*!40000 ALTER TABLE `armalife_phonenumbers` DISABLE KEYS */;
39INSERT INTO `armalife_phonenumbers` (`number`, `uid`) VALUES
40 ('7186010929', '76561198207240099'),
41 ('7465819678', '76561198137248966');
42/*!40000 ALTER TABLE `armalife_phonenumbers` ENABLE KEYS */;
43
44-- Dumping structure for table armalife.containers
45CREATE TABLE IF NOT EXISTS `containers` (
46 `id` int(6) NOT NULL AUTO_INCREMENT,
47 `pid` varchar(17) NOT NULL,
48 `classname` varchar(32) NOT NULL,
49 `pos` varchar(64) DEFAULT NULL,
50 `inventory` text NOT NULL,
51 `gear` text NOT NULL,
52 `dir` varchar(128) DEFAULT NULL,
53 `active` tinyint(1) NOT NULL DEFAULT '0',
54 `owned` tinyint(1) DEFAULT '0',
55 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
56 PRIMARY KEY (`id`,`pid`) USING BTREE
57) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
58
59-- Dumping data for table armalife.containers: ~0 rows (approximately)
60/*!40000 ALTER TABLE `containers` DISABLE KEYS */;
61/*!40000 ALTER TABLE `containers` ENABLE KEYS */;
62
63-- Dumping structure for procedure armalife.deleteDeadVehicles
64DELIMITER //
65CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteDeadVehicles`()
66BEGIN
67 DELETE FROM `vehicles` WHERE `alive` = 0;
68END//
69DELIMITER ;
70
71-- Dumping structure for procedure armalife.deleteOldContainers
72DELIMITER //
73CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldContainers`()
74BEGIN
75 DELETE FROM `containers` WHERE `owned` = 0;
76END//
77DELIMITER ;
78
79-- Dumping structure for procedure armalife.deleteOldGangs
80DELIMITER //
81CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldGangs`()
82BEGIN
83 DELETE FROM `gangs` WHERE `active` = 0;
84END//
85DELIMITER ;
86
87-- Dumping structure for procedure armalife.deleteOldHouses
88DELIMITER //
89CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteOldHouses`()
90BEGIN
91 DELETE FROM `houses` WHERE `owned` = 0;
92END//
93DELIMITER ;
94
95-- Dumping structure for procedure armalife.deleteUnpaidHouses
96DELIMITER //
97CREATE DEFINER=`root`@`localhost` PROCEDURE `deleteUnpaidHouses`()
98BEGIN
99 DELETE FROM `houses` WHERE `property_tax` = 0;
100END//
101DELIMITER ;
102
103-- Dumping structure for table armalife.gangs
104CREATE TABLE IF NOT EXISTS `gangs` (
105 `id` int(6) NOT NULL AUTO_INCREMENT,
106 `owner` varchar(32) DEFAULT NULL,
107 `name` varchar(32) DEFAULT NULL,
108 `members` text,
109 `maxmembers` int(3) DEFAULT '50',
110 `bank` int(100) DEFAULT '0',
111 `active` tinyint(1) DEFAULT '1',
112 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
113 `tasks` text,
114 PRIMARY KEY (`id`) USING BTREE,
115 UNIQUE KEY `name_UNIQUE` (`name`) USING BTREE
116) ENGINE=InnoDB AUTO_INCREMENT=133 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
117
118-- Dumping data for table armalife.gangs: ~0 rows (approximately)
119/*!40000 ALTER TABLE `gangs` DISABLE KEYS */;
120INSERT INTO `gangs` (`id`, `owner`, `name`, `members`, `maxmembers`, `bank`, `active`, `insert_time`, `tasks`) VALUES
121 (132, '76561198319377968', 'The Monkarellos', '"[[`Lewie Petrewie`,`76561198319377968`,4]]"', 50, 0, 1, '2019-04-23 19:49:10', '[1,[0,0,0,0,0,0]]');
122/*!40000 ALTER TABLE `gangs` ENABLE KEYS */;
123
124-- Dumping structure for table armalife.houses
125CREATE TABLE IF NOT EXISTS `houses` (
126 `id` int(6) NOT NULL AUTO_INCREMENT,
127 `pid` varchar(17) NOT NULL,
128 `pos` varchar(64) DEFAULT NULL,
129 `owned` tinyint(1) DEFAULT '0',
130 `garage` tinyint(1) NOT NULL DEFAULT '0',
131 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
132 `property_tax` int(1) NOT NULL DEFAULT '7',
133 PRIMARY KEY (`id`,`pid`) USING BTREE
134) ENGINE=InnoDB AUTO_INCREMENT=123 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
135
136-- Dumping data for table armalife.houses: ~0 rows (approximately)
137/*!40000 ALTER TABLE `houses` DISABLE KEYS */;
138INSERT INTO `houses` (`id`, `pid`, `pos`, `owned`, `garage`, `insert_time`, `property_tax`) VALUES
139 (122, '76561198319377968', '[2733.19,9789.1,0]', 1, 0, '2019-04-23 19:38:00', 7);
140/*!40000 ALTER TABLE `houses` ENABLE KEYS */;
141
142-- Dumping structure for table armalife.log
143CREATE TABLE IF NOT EXISTS `log` (
144 `logid` int(11) NOT NULL AUTO_INCREMENT,
145 `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
146 `user` varchar(64) DEFAULT NULL,
147 `action` varchar(255) DEFAULT NULL,
148 `level` int(11) NOT NULL,
149 PRIMARY KEY (`logid`),
150 UNIQUE KEY `logid` (`logid`),
151 KEY `logid_2` (`logid`)
152) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
153
154-- Dumping data for table armalife.log: ~1 rows (approximately)
155/*!40000 ALTER TABLE `log` DISABLE KEYS */;
156INSERT INTO `log` (`logid`, `date_time`, `user`, `action`, `level`) VALUES
157 (1, '2019-04-23 16:28:28', 'elitepsi', 'Admin elitepsi has sent a global message (test)', 1),
158 (2, '2019-04-23 17:32:21', 'elitepsi', 'Admin elitepsi has sent a global message (test)', 1),
159 (3, '2019-04-23 17:33:04', 'elitepsi', 'Admin elitepsi has sent a global message (tes)', 1);
160/*!40000 ALTER TABLE `log` ENABLE KEYS */;
161
162-- Dumping structure for table armalife.messages
163CREATE TABLE IF NOT EXISTS `messages` (
164 `uid` int(12) NOT NULL AUTO_INCREMENT,
165 `fromID` varchar(50) NOT NULL,
166 `toID` varchar(50) NOT NULL,
167 `message` text,
168 `fromName` varchar(32) NOT NULL,
169 `toName` varchar(32) NOT NULL,
170 `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
171 PRIMARY KEY (`uid`) USING BTREE
172) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=COMPACT;
173
174-- Dumping data for table armalife.messages: ~0 rows (approximately)
175/*!40000 ALTER TABLE `messages` DISABLE KEYS */;
176/*!40000 ALTER TABLE `messages` ENABLE KEYS */;
177
178-- Dumping structure for table armalife.notes
179CREATE TABLE IF NOT EXISTS `notes` (
180 `note_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'auto incrementing note_id of each user, unique index',
181 `uid` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
182 `staff_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
183 `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
184 `alias` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
185 `note_text` varchar(255) NOT NULL,
186 `warning` enum('1','2','3','4') NOT NULL,
187 `note_updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
188 PRIMARY KEY (`note_id`),
189 UNIQUE KEY `note_id` (`note_id`)
190) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
191
192-- Dumping data for table armalife.notes: ~0 rows (approximately)
193/*!40000 ALTER TABLE `notes` DISABLE KEYS */;
194/*!40000 ALTER TABLE `notes` ENABLE KEYS */;
195
196-- Dumping structure for table armalife.players
197CREATE TABLE IF NOT EXISTS `players` (
198 `uid` int(6) NOT NULL AUTO_INCREMENT,
199 `name` varchar(32) NOT NULL,
200 `aliases` text NOT NULL,
201 `pid` varchar(17) NOT NULL,
202 `exp_total` int(11) NOT NULL DEFAULT '0',
203 `exp_level` int(11) NOT NULL DEFAULT '0',
204 `cash` int(100) NOT NULL DEFAULT '20',
205 `bankacc` int(100) NOT NULL DEFAULT '0',
206 `wealth_tax` int(11) NOT NULL,
207 `last_wealth` int(100) NOT NULL DEFAULT '0',
208 `taxamount` int(100) NOT NULL DEFAULT '0',
209 `adminlevel` enum('0','1','2') NOT NULL DEFAULT '0',
210 `coplevel` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
211 `copdept` enum('0','1','2','3','4','5','6','7') NOT NULL DEFAULT '0',
212 `mediclevel` enum('0','1','2','3','4','5','6','7','8','9') NOT NULL DEFAULT '0',
213 `medicdept` enum('0','1','2') NOT NULL DEFAULT '0',
214 `donorlevel` enum('0','1') NOT NULL DEFAULT '0',
215 `civ_licenses` text NOT NULL,
216 `cop_licenses` text NOT NULL,
217 `med_licenses` text NOT NULL,
218 `civ_gear` text NOT NULL,
219 `cop_gear` text NOT NULL,
220 `med_gear` text NOT NULL,
221 `civ_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
222 `cop_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
223 `med_stats` varchar(32) NOT NULL DEFAULT '"[100,100,0]"',
224 `arrested` tinyint(1) NOT NULL DEFAULT '0',
225 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
226 `civ_alive` tinyint(1) NOT NULL DEFAULT '0',
227 `civ_position` varchar(64) NOT NULL DEFAULT '"[]"',
228 `playtime` varchar(32) NOT NULL DEFAULT '"[0,0,0]"',
229 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
230 `last_seen` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
231 `exp_perkPoints` int(11) NOT NULL DEFAULT '0',
232 `exp_perks` text,
233 `jail_time` int(11) NOT NULL DEFAULT '0',
234 PRIMARY KEY (`uid`) USING BTREE,
235 UNIQUE KEY `pid` (`pid`) USING BTREE,
236 KEY `name` (`name`) USING BTREE,
237 KEY `blacklist` (`blacklist`) USING BTREE
238) ENGINE=InnoDB AUTO_INCREMENT=2652 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
239
240-- Dumping data for table armalife.players: ~2 rows (approximately)
241/*!40000 ALTER TABLE `players` DISABLE KEYS */;
242INSERT INTO `players` (`uid`, `name`, `aliases`, `pid`, `exp_total`, `exp_level`, `cash`, `bankacc`, `wealth_tax`, `last_wealth`, `taxamount`, `adminlevel`, `coplevel`, `copdept`, `mediclevel`, `medicdept`, `donorlevel`, `civ_licenses`, `cop_licenses`, `med_licenses`, `civ_gear`, `cop_gear`, `med_gear`, `civ_stats`, `cop_stats`, `med_stats`, `arrested`, `blacklist`, `civ_alive`, `civ_position`, `playtime`, `insert_time`, `last_seen`, `exp_perkPoints`, `exp_perks`, `jail_time`) VALUES
243 (2646, 'Lewie Petrewie', '"[`Lewis Wheels`]"', '76561198319377968', 90000, 50, 0, 9035289, 0, 0, 0, '2', '7', '7', '0', '0', '1', '"[[`license_civ_driver`,1],[`license_civ_boat`,1],[`license_civ_trucking`,1],[`license_civ_gun`,1],[`license_civ_dive`,0],[`license_civ_home`,0]]"', '"[]"', '"[]"', '"[[[`hlc_rifle_SAMR`,``,``,`optic_Hamr`,[`hlc_30rnd_556x45_EPR`,30],[],``],[],[`hlc_Pistol_M11A1D`,``,``,`HLC_optic228_ATT`,[`hlc_15Rnd_9x19_B_P226`,15],[],``],[`TRYK_U_B_BLKTAN_CombatUniform`,[[`hlc_15Rnd_9x19_B_P226`,6,15]]],[`AL_CivHeavyVest4`,[[`hlc_15Rnd_9x19_B_P226`,6,15],[`SMA_30Rnd_556x45_Mk262`,11,30],[`hlc_30rnd_556x45_EPR`,12,30],[`hlc_30rnd_556x45_EPR`,1,25],[`hlc_30rnd_556x45_EPR`,1,22]]],[`travis_InvisibeCarryall`,[]],`d3s_CAP_Headgear`,`d3s_Glasses_scarf2_e`,[],[`ItemMap`,`ItemGPS`,`RoleplayRadio_6`,`ItemCompass`,``,``]],[[`redgull`,9],[`tbacon`,5],[`cprKit`,1],[`bandage`,5],[`toolkit`,1]]]"', '"[[[`SMA_MK18MOE_SM`,``,``,`optic_Hamr`,[`SMA_30Rnd_556x45_Mk262`,30],[],``],[],[`taser`,``,``,``,[`vvv_np_magazine_taser`,1],[],``],[`AL_Corrections2`,[[`vvv_np_magazine_taser`,2,1],[``,1,0]]],[`AL_PoliceHeavyVest`,[[`vvv_np_magazine_taser`,7,1],[`SMA_30Rnd_556x45_Mk262`,12,30]]],[`AL_PoliceBelt`,[]],`AL_PoliceHat`,``,[],[`ItemMap`,`ItemGPS`,`RoleplayRadio_5`,`ItemCompass`,``,``]],[[`gpstracker`,2],[`keyCard`,1],[`waterBottle`,2],[`donuts`,2],[`panicbutton`,5],[`toolkit`,1]]]"', '"[[],[]]"', '"[70,60]"', '"[100,90]"', '"[100,100,0]"', 0, 0, 1, '"[9890.94,11552.2,46.7137]"', '"[0,0,0]"', '2019-04-23 16:33:07', '2019-04-23 20:00:46', 723, '[[["perk_civilian_master",1],[[["perk_processing_1",1],[[["perk_processing_2",1],[[["perk_processing_3",1],[[["perk_processing_4",1],[[["perk_processing_5",1],[["perk_processing_6",1]]]]]]]]]]],["functions_air_1",1],["functions_home_1",1],["functions_north",1]]],[["perk_police_master",1],[[["functions_impoundSpeed_1",1],[["functions_impoundSpeed_2",1]]]]],[["perk_global_master",1],[["kill_feed",1],[["perk_evidence_1",1],[["perk_evidence_2",1]]],[["perk_paycheck_1",1],[[["perk_paycheck_2",1],[[["perk_paycheck_3",1],[[["perk_paycheck_4",1],[["perk_paycheck_5",1]]]]]]]]],[["functions_repairSpeed_1",1],[["functions_repairSpeed_2",1]]],["functions_stamina_1",1]]],[["perk_medical",1],[[["perk_cpr_1",1],[[["perk_cpr_2",1],[["perk_cpr_full",1]]]]],[["perk_stabalizeLength_1",1],[["perk_stabalizeLength_2",1]]]]],[["perk_gunsspecialist_master",1],[[["perk_gunsspecialist_lessRecoil_1",1],[[["perk_gunsspecialist_lessRecoil_2",1],[[["perk_gunsspecialist_lessRecoil_3",1],[[["perk_gunsspecialist_lessRecoil_4",1],[["perk_gunsspecialist_lessRecoil_5",1]]]]]]]]],[["perk_weaponSway_1",1],[[["perk_weaponSway_2",1],[[["perk_weaponSway_3",1],[["perk_weaponSway_4",1]]]]]]]]],[["perk_illegal_master",1],[[["perk_lsd_1",1],[["functions_uranium_1",1]]],[["perk_locksmith_1",1],[[["perk_locksmith_2",1],[[["perk_locksmith_3",1],[[["perk_locksmith_4",1],[["perk_locksmith_5",1]]]]]]]]],["perk_rebel_1",1],["perk_gasrobbery_1",1],["perk_policecheck_1",1]]],[["functions_quests",1],[[["functions_relicReward",0],[[["functions_relicReward2",0],[["functions_satellite",0]]]]]]]]', 0),
244 (2647, 'Austin Marino', '"[`Austin Marino`]"', '76561198137248966', 3150, 6, 0, 189869, 0, 0, 0, '0', '0', '0', '1', '2', '0', '"[[`license_civ_driver`,0],[`license_civ_boat`,0],[`license_civ_trucking`,0],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,0]]"', '"[]"', '"[]"', '"[[[],[],[],[`kojixus_spawnclothing`,[]],[],[],`d3s_CAP_christmas_head3_b`,``,[],[`ItemMap`,`ItemGPS`,``,`ItemCompass`,``,``]],[]]"', '"[[],[]]"', '"[[[],[],[],[`travis_emstraineeuniform`,[]],[],[`travis_InvisibeCarryall`,[]],`H_Cap_blu`,`G_I_Diving`,[],[`ItemMap`,``,`RoleplayRadio_8`,`ItemCompass`,``,``]],[[`redgull`,4],[`waterBottle`,5],[`peach`,3],[`tbacon`,5],[`cprKit`,1],[`bandage`,5],[`stabilizer`,4],[`toolkit`,1]]]"', '"[100,100]"', '"[100,100,0]"', '"[100,100]"', 0, 0, 0, '"[9888.79,11553.1,47.0344]"', '"[0,0,0]"', '2019-04-23 16:53:43', '2019-04-23 20:41:43', 14, '[[["perk_civilian_master",0],[[["perk_processing_1",0],[[["perk_processing_2",0],[[["perk_processing_3",0],[[["perk_processing_4",0],[[["perk_processing_5",0],[["perk_processing_6",0]]]]]]]]]]],["functions_air_1",0],["functions_home_1",0],["functions_north",0]]],[["perk_police_master",0],[[["functions_impoundSpeed_1",0],[["functions_impoundSpeed_2",0]]]]],[["perk_global_master",0],[["kill_feed",0],[["perk_evidence_1",0],[["perk_evidence_2",0]]],[["perk_paycheck_1",0],[[["perk_paycheck_2",0],[[["perk_paycheck_3",0],[[["perk_paycheck_4",0],[["perk_paycheck_5",0]]]]]]]]],[["functions_repairSpeed_1",0],[["functions_repairSpeed_2",0]]],["functions_stamina_1",0]]],[["perk_medical",0],[[["perk_cpr_1",0],[[["perk_cpr_2",0],[["perk_cpr_full",0]]]]],[["perk_stabalizeLength_1",0],[["perk_stabalizeLength_2",0]]]]],[["perk_gunsspecialist_master",0],[[["perk_gunsspecialist_lessRecoil_1",0],[[["perk_gunsspecialist_lessRecoil_2",0],[[["perk_gunsspecialist_lessRecoil_3",0],[[["perk_gunsspecialist_lessRecoil_4",0],[["perk_gunsspecialist_lessRecoil_5",0]]]]]]]]],[["perk_weaponSway_1",0],[[["perk_weaponSway_2",0],[[["perk_weaponSway_3",0],[["perk_weaponSway_4",0]]]]]]]]],[["perk_illegal_master",0],[[["perk_lsd_1",0],[["functions_uranium_1",0]]],[["perk_locksmith_1",0],[[["perk_locksmith_2",0],[[["perk_locksmith_3",0],[[["perk_locksmith_4",0],[["perk_locksmith_5",0]]]]]]]]],["perk_rebel_1",0],["perk_gasrobbery_1",0],["perk_policecheck_1",0]]],[["functions_quests",0],[[["functions_relicReward",0],[[["functions_relicReward2",0],[["functions_satellite",0]]]]]]]]', 0),
245 (2648, 'Liam McGarrett', '"[`Liam McGarrett`]"', '76561198194737469', 3450, 6, 7354, 775767, 0, 0, 0, '2', '0', '0', '9', '2', '0', '"[]"', '"[]"', '"[]"', '"[[],[]]"', '"[[],[]]"', '"[[[],[],[],[`US_FireFighter_CombatUniformblack`,[[`US_FireFighter_ARI_Drager_Mask`,8],[``,1,0]]],[],[`travis_InvisibeCarryall`,[[`US_FireFighter_HelmetWhite`,1],[`Medikit`,1],[`hlc_15Rnd_9x19_B_P226`,2,15],[[`hlc_pistol_Mk25D`,``,``,``,[`hlc_15Rnd_9x19_B_P226`,13],[],``],1],[`US_FireFighter_ARI_Drager`,true],[`US_FireFighter_ARI_Drager`,true]]],`H_Cap_marshal`,`d3s_p_eyes_000_a`,[`Binocular`,``,``,``,[],[],``],[`ItemMap`,`ItemGPS`,`RoleplayRadio_1`,`ItemCompass`,``,``]],[[`waterBottle`,9],[`tbacon`,10],[`cprKit`,2],[`bandage`,10],[`stabilizer`,3],[`toolkit`,2]]]"', '"[100,100,0]"', '"[100,100,0]"', '"[100,100]"', 0, 0, 0, '"[]"', '"[0,0,0]"', '2019-04-23 17:17:41', '2019-04-23 20:38:12', 11, '[[["perk_civilian_master",0],[[["perk_processing_1",0],[[["perk_processing_2",0],[[["perk_processing_3",0],[[["perk_processing_4",0],[[["perk_processing_5",0],[["perk_processing_6",0]]]]]]]]]]],["functions_air_1",0],["functions_home_1",0],["functions_north",0]]],[["perk_police_master",0],[[["functions_impoundSpeed_1",0],[["functions_impoundSpeed_2",0]]]]],[["perk_global_master",1],[["kill_feed",0],[["perk_evidence_1",0],[["perk_evidence_2",0]]],[["perk_paycheck_1",1],[[["perk_paycheck_2",0],[[["perk_paycheck_3",0],[[["perk_paycheck_4",0],[["perk_paycheck_5",0]]]]]]]]],[["functions_repairSpeed_1",0],[["functions_repairSpeed_2",0]]],["functions_stamina_1",0]]],[["perk_medical",0],[[["perk_cpr_1",0],[[["perk_cpr_2",0],[["perk_cpr_full",0]]]]],[["perk_stabalizeLength_1",0],[["perk_stabalizeLength_2",0]]]]],[["perk_gunsspecialist_master",0],[[["perk_gunsspecialist_lessRecoil_1",0],[[["perk_gunsspecialist_lessRecoil_2",0],[[["perk_gunsspecialist_lessRecoil_3",0],[[["perk_gunsspecialist_lessRecoil_4",0],[["perk_gunsspecialist_lessRecoil_5",0]]]]]]]]],[["perk_weaponSway_1",0],[[["perk_weaponSway_2",0],[[["perk_weaponSway_3",0],[["perk_weaponSway_4",0]]]]]]]]],[["perk_illegal_master",0],[[["perk_lsd_1",0],[["functions_uranium_1",0]]],[["perk_locksmith_1",0],[[["perk_locksmith_2",0],[[["perk_locksmith_3",0],[[["perk_locksmith_4",0],[["perk_locksmith_5",0]]]]]]]]],["perk_rebel_1",0],["perk_gasrobbery_1",0],["perk_policecheck_1",0]]],[["functions_quests",0],[[["functions_relicReward",0],[[["functions_relicReward2",0],[["functions_satellite",0]]]]]]]]', 0),
246 (2649, 'Tristen Billiot', '"[`Tristen Billiot`]"', '76561198207240099', 1550, 4, 0, 2375, 0, 0, 0, '2', '7', '7', '0', '0', '0', '"[[`license_civ_driver`,0],[`license_civ_boat`,0],[`license_civ_trucking`,0],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,0]]"', '"[]"', '"[]"', '"[[[],[],[],[`kojixus_spawnclothing`,[]],[],[],`d3s_CAP_beanie_1_m`,``,[],[`ItemMap`,`ItemGPS`,`RoleplayRadio`,`ItemCompass`,``,``]],[]]"', '"[[[],[],[`hlc_pistol_P226WestGerman`,``,``,``,[`hlc_15Rnd_9x19_B_P226`,11],[],``],[`kojixus_picklerick`,[]],[],[`AL_PoliceBelt`,[[`G_Lady_Dark`,1],[`AL_BOIBeret`,1],[`30Rnd_556x45_Stanag`,6,30],[`vvv_np_magazine_taser`,3,1],[`hlc_15Rnd_9x19_B_P226`,2,15],[`HandGrenade_Stone`,1,1],[[`hlc_rifle_M4`,``,``,``,[`30Rnd_556x45_Stanag`,30],[],``],1],[[`taser`,``,``,``,[],[],``],1],[`AL_BOIJacketBlack`,false],[`AL_CIDHeavyVest`,false]]],`d3s_CAP_p_head_000_j`,`G_Aviator`,[`Binocular`,``,``,``,[],[],``],[`ItemMap`,`ItemGPS`,`RoleplayRadio_3`,`ItemCompass`,``,``]],[[`gpstracker`,2],[`keyCard`,1],[`redgull`,2],[`waterBottle`,1],[`donuts`,2],[`bandage`,4],[`toolkit`,1],[`spikeStrip`,3]]]"', '"[[],[]]"', '"[100,100]"', '"[90,90]"', '"[100,100,0]"', 0, 0, 0, '"[9890.94,11552.2,46.7137]"', '"[0,0,0]"', '2019-04-23 17:21:26', '2019-04-23 19:56:40', 8, '[[["perk_civilian_master",0],[[["perk_processing_1",0],[[["perk_processing_2",0],[[["perk_processing_3",0],[[["perk_processing_4",0],[[["perk_processing_5",0],[["perk_processing_6",0]]]]]]]]]]],["functions_air_1",0],["functions_home_1",0],["functions_north",0]]],[["perk_police_master",0],[[["functions_impoundSpeed_1",0],[["functions_impoundSpeed_2",0]]]]],[["perk_global_master",0],[["kill_feed",0],[["perk_evidence_1",0],[["perk_evidence_2",0]]],[["perk_paycheck_1",0],[[["perk_paycheck_2",0],[[["perk_paycheck_3",0],[[["perk_paycheck_4",0],[["perk_paycheck_5",0]]]]]]]]],[["functions_repairSpeed_1",0],[["functions_repairSpeed_2",0]]],["functions_stamina_1",0]]],[["perk_medical",0],[[["perk_cpr_1",0],[[["perk_cpr_2",0],[["perk_cpr_full",0]]]]],[["perk_stabalizeLength_1",0],[["perk_stabalizeLength_2",0]]]]],[["perk_gunsspecialist_master",0],[[["perk_gunsspecialist_lessRecoil_1",0],[[["perk_gunsspecialist_lessRecoil_2",0],[[["perk_gunsspecialist_lessRecoil_3",0],[[["perk_gunsspecialist_lessRecoil_4",0],[["perk_gunsspecialist_lessRecoil_5",0]]]]]]]]],[["perk_weaponSway_1",0],[[["perk_weaponSway_2",0],[[["perk_weaponSway_3",0],[["perk_weaponSway_4",0]]]]]]]]],[["perk_illegal_master",0],[[["perk_lsd_1",0],[["functions_uranium_1",0]]],[["perk_locksmith_1",0],[[["perk_locksmith_2",0],[[["perk_locksmith_3",0],[[["perk_locksmith_4",0],[["perk_locksmith_5",0]]]]]]]]],["perk_rebel_1",0],["perk_gasrobbery_1",0],["perk_policecheck_1",0]]],[["functions_quests",0],[[["functions_relicReward",0],[[["functions_relicReward2",0],[["functions_satellite",0]]]]]]]]', 0),
247 (2650, 'Noah Narco', '"[`Noah Narco`]"', '76561198157662259', 1700, 40, 64702, 38925408, 0, 0, 0, '2', '7', '7', '8', '2', '1', '"[[`license_civ_driver`,0],[`license_civ_boat`,0],[`license_civ_trucking`,0],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,0]]"', '"[]"', '"[]"', '"[[[],[],[],[`kojixus_spawnclothing`,[]],[],[],`d3s_CAP_beanie_1_m`,``,[],[`ItemMap`,`ItemGPS`,`RoleplayRadio_2`,`ItemCompass`,``,``]],[]]"', '"[[[],[],[],[],[],[],``,``,[`Binocular`,``,``,``,[],[],``],[`ItemMap`,`ItemGPS`,`RoleplayRadio_7`,`ItemCompass`,``,``]],[[`keyCard`,1],[`waterBottle`,2],[`donuts`,2],[`toolkit`,1],[`spikeStrip`,1]]]"', '"[[[],[],[],[`US_FireFighter_CombatUniformblack`,[[`US_FireFighter_ARI_Drager_Mask`,1]]],[],[`travis_InvisibeCarryall`,[[`Medikit`,1]]],`US_FireFighter_Helmet`,``,[`Binocular`,``,``,``,[],[],``],[`ItemMap`,`ItemGPS`,`RoleplayRadio_4`,`ItemCompass`,``,``]],[[`redgull`,4],[`waterBottle`,2],[`donuts`,2],[`cprKit`,2],[`splint`,8],[`morphine`,8],[`bandage`,8],[`stabilizer`,8],[`toolkit`,2]]]"', '"[100,100]"', '"[100,100]"', '"[90,90]"', 0, 0, 1, '"[8560.13,6580.17,0.176692]"', '"[0,0,0]"', '2019-04-23 18:28:40', '2019-04-23 20:31:33', 36498, '[[["perk_civilian_master",0],[[["perk_processing_1",0],[[["perk_processing_2",0],[[["perk_processing_3",0],[[["perk_processing_4",0],[[["perk_processing_5",0],[["perk_processing_6",0]]]]]]]]]]],["functions_air_1",0],["functions_home_1",0],["functions_north",0]]],[["perk_police_master",1],[[["functions_impoundSpeed_1",1],[["functions_impoundSpeed_2",1]]]]],[["perk_global_master",1],[["kill_feed",1],[["perk_evidence_1",1],[["perk_evidence_2",1]]],[["perk_paycheck_1",1],[[["perk_paycheck_2",1],[[["perk_paycheck_3",1],[[["perk_paycheck_4",1],[["perk_paycheck_5",1]]]]]]]]],[["functions_repairSpeed_1",1],[["functions_repairSpeed_2",1]]],["functions_stamina_1",1]]],[["perk_medical",1],[[["perk_cpr_1",1],[[["perk_cpr_2",1],[["perk_cpr_full",1]]]]],[["perk_stabalizeLength_1",1],[["perk_stabalizeLength_2",1]]]]],[["perk_gunsspecialist_master",1],[[["perk_gunsspecialist_lessRecoil_1",1],[[["perk_gunsspecialist_lessRecoil_2",1],[[["perk_gunsspecialist_lessRecoil_3",1],[[["perk_gunsspecialist_lessRecoil_4",1],[["perk_gunsspecialist_lessRecoil_5",1]]]]]]]]],[["perk_weaponSway_1",1],[[["perk_weaponSway_2",1],[[["perk_weaponSway_3",1],[["perk_weaponSway_4",1]]]]]]]]],[["perk_illegal_master",0],[[["perk_lsd_1",0],[["functions_uranium_1",0]]],[["perk_locksmith_1",0],[[["perk_locksmith_2",0],[[["perk_locksmith_3",0],[[["perk_locksmith_4",0],[["perk_locksmith_5",0]]]]]]]]],["perk_rebel_1",0],["perk_gasrobbery_1",0],["perk_policecheck_1",0]]],[["functions_quests",1],[[["functions_relicReward",1],[[["functions_relicReward2",1],[["functions_satellite",1]]]]]]]]', 0),
248 (2651, 'Anthony jackson', '"[`Anthony jackson`]"', '76561198387632825', 0, 0, 0, 40000, 0, 0, 0, '0', '0', '0', '0', '0', '0', '"[[`license_civ_driver`,0],[`license_civ_boat`,0],[`license_civ_trucking`,0],[`license_civ_gun`,0],[`license_civ_dive`,0],[`license_civ_home`,0]]"', '"[]"', '"[]"', '"[[[],[],[],[`kojixus_spawnclothing`,[]],[],[],`d3s_CAP_beanie_1_h`,``,[],[`ItemMap`,`ItemGPS`,`RoleplayRadio`,`ItemCompass`,``,``]],[]]"', '"[[],[]]"', '"[[],[]]"', '"[100,100]"', '"[100,100,0]"', '"[100,100,0]"', 0, 0, 1, '"[9890.94,11552.2,46.7137]"', '"[0,0,0]"', '2019-04-23 20:37:51', '2019-04-23 20:37:53', 0, NULL, 0);
249/*!40000 ALTER TABLE `players` ENABLE KEYS */;
250
251-- Dumping structure for event armalife.property_tax
252DELIMITER //
253CREATE DEFINER=`root`@`localhost` EVENT `property_tax` ON SCHEDULE EVERY 24 HOUR STARTS '2018-12-14 01:46:15' ON COMPLETION NOT PRESERVE ENABLE DO UPDATE houses SET property_tax = property_tax - 1//
254DELIMITER ;
255
256-- Dumping structure for table armalife.reimbursement_log
257CREATE TABLE IF NOT EXISTS `reimbursement_log` (
258 `reimbursement_id` int(11) NOT NULL AUTO_INCREMENT,
259 `playerid` varchar(50) NOT NULL,
260 `comp` int(100) NOT NULL DEFAULT '0',
261 `reason` varchar(255) NOT NULL,
262 `staff_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
263 `timestamp` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
264 PRIMARY KEY (`reimbursement_id`),
265 UNIQUE KEY `reimbursement_id` (`reimbursement_id`)
266) ENGINE=InnoDB DEFAULT CHARSET=latin1;
267
268-- Dumping data for table armalife.reimbursement_log: ~0 rows (approximately)
269/*!40000 ALTER TABLE `reimbursement_log` DISABLE KEYS */;
270/*!40000 ALTER TABLE `reimbursement_log` ENABLE KEYS */;
271
272-- Dumping structure for procedure armalife.resetLifeVehicles
273DELIMITER //
274CREATE DEFINER=`root`@`localhost` PROCEDURE `resetLifeVehicles`()
275BEGIN
276 UPDATE `vehicles` SET `active`= 0;
277END//
278DELIMITER ;
279
280-- Dumping structure for table armalife.users
281CREATE TABLE IF NOT EXISTS `users` (
282 `ID` mediumint(9) NOT NULL AUTO_INCREMENT,
283 `username` varchar(60) NOT NULL,
284 `password` varchar(80) NOT NULL,
285 `permissions` text NOT NULL,
286 PRIMARY KEY (`ID`)
287) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
288
289-- Dumping data for table armalife.users: ~1 rows (approximately)
290/*!40000 ALTER TABLE `users` DISABLE KEYS */;
291INSERT INTO `users` (`ID`, `username`, `password`, `permissions`) VALUES
292 (2, 'elitepsi', '693795900eb23121cf089fb07e1d299e7cec2ac25294dfbf834ef20440181a10', '"[[`notes`,1],[`cop`,1],[`medic`,1],[`money`,1],[`IG-Admin`,1],[`editPlayer`,1],[`housing`,1],[`gangs`,1],[`vehicles`,1],[`logs`,1],[`steamView`,1],[`ban`,1],[`kick`,1],[`unban`,1],[`globalMessage`,1],[`restartServer`,1],[`stopServer`,1],[`superUser`,1]]"');
293/*!40000 ALTER TABLE `users` ENABLE KEYS */;
294
295-- Dumping structure for table armalife.vehicles
296CREATE TABLE IF NOT EXISTS `vehicles` (
297 `id` int(6) NOT NULL AUTO_INCREMENT,
298 `side` varchar(16) NOT NULL,
299 `classname` varchar(64) NOT NULL,
300 `type` varchar(16) NOT NULL,
301 `pid` varchar(17) NOT NULL,
302 `alive` tinyint(1) NOT NULL DEFAULT '1',
303 `blacklist` tinyint(1) NOT NULL DEFAULT '0',
304 `active` tinyint(1) NOT NULL DEFAULT '0',
305 `plate` int(20) NOT NULL,
306 `color` text NOT NULL,
307 `inventory` text NOT NULL,
308 `gear` text NOT NULL,
309 `fuel` double NOT NULL DEFAULT '1',
310 `damage` varchar(256) NOT NULL,
311 `insert_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
312 `impound` int(1) NOT NULL DEFAULT '0',
313 `insured` int(1) NOT NULL DEFAULT '0',
314 PRIMARY KEY (`id`) USING BTREE,
315 KEY `side` (`side`) USING BTREE,
316 KEY `pid` (`pid`) USING BTREE,
317 KEY `type` (`type`) USING BTREE
318) ENGINE=InnoDB AUTO_INCREMENT=15291 DEFAULT CHARSET=utf8mb4 ROW_FORMAT=COMPACT;
319
320-- Dumping data for table armalife.vehicles: ~0 rows (approximately)
321/*!40000 ALTER TABLE `vehicles` DISABLE KEYS */;
322INSERT INTO `vehicles` (`id`, `side`, `classname`, `type`, `pid`, `alive`, `blacklist`, `active`, `plate`, `color`, `inventory`, `gear`, `fuel`, `damage`, `insert_time`, `impound`, `insured`) VALUES
323 (15270, 'cop', 'GM_SIO_CTSV', 'Car', '76561198155073249', 1, 0, 0, 94905, '[[1,1,1],[1,1,1],0.5]', '"[[],0]"', '"[]"', 0.999802, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2019-03-14 13:18:44', 0, 1),
324 (15271, 'med', 'Fox_ArrowXTLadder', 'Car', '76561198194737469', 1, 0, 1, 59102, '[[1,1,1],[1,1,1],0.5]', '"[[],0]"', '"[]"', 1, '"[]"', '2019-04-23 17:29:45', 0, 1),
325 (15272, 'med', 'Fox_Firetruck', 'Car', '76561198194737469', 1, 0, 1, 967505, '[[1,1,1],[1,1,1],0.5]', '"[[],0]"', '"[]"', 1, '"[]"', '2019-04-23 17:33:15', 0, 1),
326 (15273, 'cop', 'GM_SIO_BMW', 'Car', '76561198319377968', 1, 0, 0, 722451, '[[1,1,1],[1,1,1],0.5]', '"[[],0]"', '"[]"', 0.986701, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2019-04-23 17:51:25', 0, 0),
327 (15274, 'cop', 'd3s_raptor_UNM_17', 'Car', '76561198207240099', 1, 0, 0, 173731, '[[1,1,1],[1,1,1],0.5]', '"[[],0]"', '"[]"', 0.961711, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2019-04-23 17:51:56', 0, 1),
328 (15275, 'med', 'Fox_HeavyRescue2', 'Car', '76561198194737469', 1, 0, 1, 242848, '[[1,1,1],[1,1,1],0.5]', '"[[],0]"', '"[]"', 1, '"[]"', '2019-04-23 18:18:43', 0, 1),
329 (15276, 'cop', 'NB_SWAT_asterion', 'Car', '76561198319377968', 1, 0, 0, 922497, '[[1,1,1],[1,1,1],0.5]', '"[[],0]"', '"[]"', 0.999063, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2019-04-23 18:20:07', 0, 0),
330 (15277, 'cop', 'NB_SWAT_BMWSUV', 'Car', '76561198319377968', 1, 0, 0, 187815, '[[1,1,1],[1,1,1],0.5]', '"[[],0]"', '"[]"', 1, '"[]"', '2019-04-23 18:21:16', 0, 0),
331 (15278, 'med', 'Fox_ArrowXTLadder', 'Car', '76561198194737469', 1, 0, 0, 364388, '[[1,1,1],[1,1,1],0.5]', '"[[],0]"', '"[]"', 1, '"[]"', '2019-04-23 18:21:45', 0, 1),
332 (15279, 'med', 'al_EMS_BMW_BR', 'Car', '76561198194737469', 1, 0, 1, 378909, '[[1,1,1],[1,1,1],0.5]', '"[[],0]"', '"[]"', 1, '"[]"', '2019-04-23 18:28:44', 0, 1),
333 (15280, 'med', 'Jonzie_Ambulance', 'Car', '76561198194737469', 1, 0, 1, 410011, '[[1,1,1],[1,1,1],0.5]', '"[[],0]"', '"[]"', 1, '"[]"', '2019-04-23 18:31:54', 0, 1),
334 (15281, 'med', 'Fox_HeavyRescue', 'Car', '76561198194737469', 1, 0, 1, 915712, '[[1,1,1],[1,1,1],0.5]', '"[[],0]"', '"[]"', 1, '"[]"', '2019-04-23 18:35:41', 0, 1),
335 (15282, 'med', 'al_CHARGER_CAPTAIN', 'Car', '76561198157662259', 1, 0, 1, 593420, '[[1,1,1],[1,1,1],0.5]', '"[[],0]"', '"[]"', 1, '"[]"', '2019-04-23 18:35:56', 0, 1),
336 (15283, 'civ', 'd3s_gl63amg_12_LT', 'Car', '76561198319377968', 1, 0, 0, 311763, '[[1,1,1],[1,1,1],0.5]', '"[[],0]"', '"[]"', 0.984484, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2019-04-23 18:49:07', 1, 0),
337 (15284, 'civ', 'd3s_levante_s_17_EX', 'Car', '76561198319377968', 1, 0, 0, 456652, '[[1,1,1],[1,1,1],0.5]', '"[[],0]"', '"[]"', 0.999723, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2019-04-23 19:01:56', 1, 0),
338 (15285, 'cop', 'd3s_srthellcat_15_UNM', 'Car', '76561198157662259', 1, 0, 0, 949256, '[[1,1,1],[1,1,1],0.5]', '"[[],0]"', '"[]"', 0.986784, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2019-04-23 19:20:40', 0, 1),
339 (15286, 'civ', 'd3s_rapide_10_AMR', 'Car', '76561198319377968', 1, 0, 1, 284770, '[[1,1,1],[1,1,1],0.5]', '"[[],0]"', '"[]"', 1, '"[]"', '2019-04-23 19:20:55', 0, 0),
340 (15287, 'med', 'Jonzie_Ambulance', 'Car', '76561198194737469', 1, 0, 0, 623940, '[[1,1,1],[1,1,1],0.5]', '"[[],0]"', '"[]"', 0.667596, '"[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]"', '2019-04-23 19:20:59', 1, 1),
341 (15288, 'med', 'Jonzie_Ambulance', 'Car', '76561198137248966', 1, 0, 1, 523752, '[[1,1,1],[1,1,1],0.5]', '"[[],0]"', '"[]"', 1, '"[]"', '2019-04-23 19:23:01', 0, 1),
342 (15289, 'cop', 'M_AS350_SHERIFF', 'Air', '76561198207240099', 1, 0, 0, 933473, '[[1,1,1],[1,1,1],0.5]', '"[[],0]"', '"[]"', 1, '"[]"', '2019-04-23 19:30:54', 0, 0),
343 (15290, 'civ', 'd3s_levante_s_17_EX', 'Car', '76561198319377968', 1, 0, 1, 559768, '[[1,1,1],[1,1,1],0.5]', '"[[],0]"', '"[]"', 1, '"[]"', '2019-04-23 19:43:39', 0, 0);
344/*!40000 ALTER TABLE `vehicles` ENABLE KEYS */;
345
346-- Dumping structure for table armalife.warrants
347CREATE TABLE IF NOT EXISTS `warrants` (
348 `id` int(11) NOT NULL AUTO_INCREMENT,
349 `pid` varchar(17) NOT NULL,
350 `crime_id` int(11) NOT NULL,
351 `insert_datetime` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
352 PRIMARY KEY (`id`)
353) ENGINE=InnoDB AUTO_INCREMENT=1348 DEFAULT CHARSET=latin1;
354
355-- Dumping data for table armalife.warrants: ~0 rows (approximately)
356/*!40000 ALTER TABLE `warrants` DISABLE KEYS */;
357/*!40000 ALTER TABLE `warrants` ENABLE KEYS */;
358
359-- Dumping structure for event armalife.wealth tax
360DELIMITER //
361CREATE DEFINER=`root`@`localhost` EVENT `wealth tax` ON SCHEDULE EVERY 24 HOUR STARTS '2018-12-19 00:00:30' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN
362UPDATE `players` SET `wealth_tax`=round((bankacc+cash)-round((bankacc+cash)/100 * 98)) WHERE (bankacc+cash) > 1000000;
363
364UPDATE `players` SET `bankacc`=round(((bankacc+cash)/100 * 98) - cash) WHERE (bankacc+cash) > 1000000;
365
366UPDATE `players` SET `taxamount`=taxamount+GREATEST(((bankacc+cash)-last_wealth),0);
367UPDATE `players` SET `last_wealth`=(bankacc+cash);
368END//
369DELIMITER ;
370
371-- Dumping structure for table armalife.whitelist
372CREATE TABLE IF NOT EXISTS `whitelist` (
373 `id` int(11) NOT NULL AUTO_INCREMENT,
374 `date_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
375 `user` varchar(64) DEFAULT NULL,
376 `guid` varchar(64) DEFAULT NULL,
377 `uid` varchar(64) DEFAULT NULL,
378 PRIMARY KEY (`id`)
379) ENGINE=InnoDB DEFAULT CHARSET=latin1;
380
381-- Dumping data for table armalife.whitelist: ~0 rows (approximately)
382/*!40000 ALTER TABLE `whitelist` DISABLE KEYS */;
383/*!40000 ALTER TABLE `whitelist` ENABLE KEYS */;
384
385/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
386/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
387/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;