aqHp0Gt5

1DROP TABLE IF EXISTS `duty_allowed`;
2CREATE TABLE IF NOT EXISTS `duty_allowed` (
3  `id` int(11) NOT NULL AUTO_INCREMENT,
4  `faction` int(11) NOT NULL,
5  `itemID` int(11) NOT NULL,
6  `itemValue` varchar(45) NOT NULL DEFAULT '1',
7  PRIMARY KEY (`id`),
8  UNIQUE KEY `id_UNIQUE` (`id`)
9) ENGINE=InnoDB AUTO_INCREMENT=120 DEFAULT CHARSET=latin1 COMMENT='Used for an admin allow list.';
10
11-- Dumping data for table mta.duty_allowed: ~101 rows (approximately)
12/*!40000 ALTER TABLE `duty_allowed` DISABLE KEYS */;
13INSERT INTO `duty_allowed` (`id`, `faction`, `itemID`, `itemValue`) VALUES
14	(1, 1, 45, '1'),
15	(2, 1, 1, '1'),
16	(3, 1, 26, '1'),
17	(5, 4, -41, '50000'),
18	(6, 4, -43, '500'),
19	(8, 4, 46, ''),
20	(9, 4, 57, '500'),
21	(11, 4, 126, 'Rapid'),
22	(12, 4, 183, ''),
23	(13, 4, 118, ''),
24	(15, 11, -41, '1500'),
25	(16, 11, -43, '250'),
26	(17, 1, -31, '250'),
27	(18, 1, -24, '35'),
28	(19, 1, -29, '150'),
29	(20, 1, -34, '10'),
30	(21, 1, -33, '10'),
31	(22, 1, -23, '68'),
32	(23, 1, -25, '50'),
33	(24, 1, -27, '35'),
34	(25, 1, -43, '50'),
35	(26, 1, -44, '1'),
36	(27, 1, -45, '1'),
37	(28, 1, -46, '1'),
38	(29, 1, -17, '5'),
39	(30, 1, -3, '1'),
40	(31, 1, 126, '1'),
41	(33, 1, 137, '1'),
42	(34, 1, 13, ''),
43	(35, 1, 83, ''),
44	(36, 1, 29, ''),
45	(37, 1, 56, ''),
46	(38, 1, -4, '1'),
47	(39, 11, 26, '1'),
48	(40, 11, 27, '1'),
49	(41, 11, 45, '1'),
50	(43, 11, 137, '1'),
51	(46, 11, 177, '1'),
52	(47, 11, 113, '5'),
53	(48, 11, 126, '1'),
54	(50, 11, -3, '1'),
55	(51, 11, -25, '20'),
56	(52, 11, -27, '30'),
57	(53, 11, -29, '90'),
58	(55, 11, -23, '68'),
59	(56, 11, -24, '50'),
60	(57, 11, -31, '250'),
61	(59, 11, -34, '20'),
62	(60, 11, -33, '40'),
63	(61, 11, -17, '2'),
64	(62, 11, -42, '2000'),
65	(63, 11, -44, '1'),
66	(64, 11, -46, '1'),
67	(65, 11, -45, '1'),
68	(66, 11, 80, 'Recording Device'),
69	(67, 11, 0, '100'),
70	(68, 1, 27, '4'),
71	(69, 1, -100, '100'),
72	(73, 11, -100, '200'),
73	(74, 1, 120, ''),
74	(75, 4, 96, ''),
75	(76, 7, 126, 'FAA'),
76	(77, 7, 163, 'FAA'),
77	(78, 7, 174, 'FAA'),
78	(79, 7, -41, '500'),
79	(80, 7, -100, '200'),
80	(82, 7, -24, '50'),
81	(83, 7, -31, '100'),
82	(84, 7, -43, '100'),
83	(85, 7, 45, 'FAA'),
84	(86, 8, -31, '250'),
85	(87, 8, -24, '50'),
86	(88, 8, -29, '200'),
87	(89, 8, -27, '150'),
88	(90, 8, -23, '50'),
89	(91, 8, -43, '50'),
90	(92, 8, -34, '20'),
91	(93, 8, -17, '5'),
92	(94, 8, -100, '100'),
93	(95, 8, 66, ''),
94	(96, 8, 45, ''),
95	(97, 8, 137, ''),
96	(98, 8, 29, ''),
97	(99, 8, 27, ''),
98	(100, 8, 26, ''),
99	(101, 8, 56, ''),
100	(102, 8, 76, ''),
101	(103, 8, 120, ''),
102	(104, 8, 163, ''),
103	(105, 12, -42, '500'),
104	(106, 12, -43, '1'),
105	(107, 12, -9, '1'),
106	(110, 12, 141, '1'),
107	(112, 2, -42, '1000'),
108	(113, 2, -9, '0'),
109	(114, 2, 26, 'Gas Mask'),
110	(115, 2, 70, 'BLS Kit'),
111	(116, 2, 113, 'Glowsticks'),
112	(117, 2, 120, 'Scuba Gear'),
113	(118, 2, 145, 'Flashlight'),
114	(119, 2, 164, '');
115/*!40000 ALTER TABLE `duty_allowed` ENABLE KEYS */;
116
117-- Dumping structure for table mta.duty_custom
118DROP TABLE IF EXISTS `duty_custom`;
119CREATE TABLE IF NOT EXISTS `duty_custom` (
120  `id` int(11) NOT NULL AUTO_INCREMENT,
121  `factionid` int(11) NOT NULL,
122  `name` text NOT NULL,
123  `skins` text NOT NULL,
124  `locations` text NOT NULL,
125  `items` text NOT NULL,
126  PRIMARY KEY (`id`),
127  UNIQUE KEY `id_UNIQUE` (`id`)
128) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=latin1 COMMENT='Used for custom duties.';
129
130-- Dumping data for table mta.duty_custom: ~54 rows (approximately)
131/*!40000 ALTER TABLE `duty_custom` DISABLE KEYS */;
132INSERT INTO `duty_custom` (`id`, `factionid`, `name`, `skins`, `locations`, `items`) VALUES
133	(1, 4, 'Driver', '[ [ [ "305", "839" ], [ "211", "341" ] ] ]', '[ { "3": "Driver Loadout" } ]', '[ { "9": [ "9", 57, "500" ], "8": [ "8", 46, "" ], "5": [ "5", -41, 50000, "50000" ], "75": [ "75", 96, "" ], "13": [ "13", 118, "" ], "12": [ "12", 183, "" ], "11": [ "11", 126, "Rapid" ], "6": [ "6", -43, 500, "500" ] } ]'),
134	(8, 50, 'Undercover gear', '[ [ [ 286, "N\\/A" ], [ "266", "2097" ], [ "280", "2098" ], [ "280", "2099" ], [ "186", "2100" ], [ "186", "2101" ], [ "186", "2102" ], [ "186", "2103" ], [ "186", "2104" ] ] ]', '[ { "87": "VEHICLE", "95": "VEHICLE", "96": "VEHICLE", "97": "VEHICLE", "93": "VEHICLE", "92": "VEHICLE", "91": "VEHICLE", "90": "VEHICLE", "88": "VEHICLE", "98": "VEHICLE", "102": "VEHICLE", "101": "VEHICLE", "89": "VEHICLE", "109": "VEHICLE", "99": "VEHICLE", "100": "VEHICLE", "104": "VEHICLE", "20": "VEHICLE", "21": "DLE HQ - Lockers", "94": "VEHICLE", "103": "VEHICLE" } ]', ''),
135	(14, 59, 'Patrol', '[ [ [ "71", "1656" ], [ "61", "1655" ], [ "286", "1657" ], [ 211, "N\\/A" ], [ "284", "1667" ], [ "284", "1668" ], [ "265", "1665" ], [ "266", "1664" ], [ "280", "1661" ], [ "288", "1659" ], [ "282", "1660" ], [ "267", "1672" ], [ "281", "1673" ], [ "283", "1658" ] ] ]', '[ { "116": "SADC", "24": "Training Grounds", "22": "HQ", "23": "SIU" } ]', '[ { "142": [ 142, -43, 50, "50" ], "152": [ 152, -33, 40, "40" ], "123": [ 123, 47, "1" ], "137": [ 137, 113, "5" ], "147": [ 147, -3, 1, "1" ], "157": [ 157, 177, "" ], "159": [ 159, -41, 1000, "1000" ], "149": [ 149, -100, 100, "100" ], "139": [ 139, 126, "1" ], "134": [ 134, 53, "1" ], "154": [ 154, 45, "1" ], "128": [ 128, 83, "1" ], "140": [ 140, -25, 30, "30" ], "150": [ 150, -24, 49, "49" ], "127": [ 127, 13, "1" ], "153": [ 153, -29, 150, "150" ], "120": [ 120, 45, "1" ] } ]'),
136	(16, 59, 'Emergency Response Team', '[ [ [ "285", "1671" ], [ "285", "1670" ], [ "285", "1669" ], [ "71", "1656" ], [ "61", "1655" ], [ "286", "1657" ], [ 211, "N\\/A" ], [ "284", "1667" ], [ "284", "1668" ], [ "265", "1665" ], [ "266", "1664" ], [ "280", "1661" ], [ "288", "1659" ], [ "282", "1660" ], [ "267", "1672" ], [ "281", "1673" ], [ "283", "1658" ] ] ]', '[ { "36": "VEHICLE", "34": "VEHICLE", "24": "Training Grounds", "27": "VEHICLE", "26": "VEHICLE", "19": "VEHICLE", "28": "VEHICLE", "22": "HQ", "23": "SIU" } ]', '[ { "142": [ 142, 29, "1" ], "123": [ 123, 47, "1" ], "137": [ 137, 113, "5" ], "147": [ 147, 120, "1" ], "157": [ 157, -33, 40, "40" ], "143": [ 143, -44, 1, "1" ], "153": [ 153, -31, 300, "300" ], "160": [ 160, -27, 35, "35" ], "149": [ 149, 27, "1" ], "140": [ 140, 137, "1" ], "154": [ 154, -24, 49, "49" ], "139": [ 139, 126, "1" ], "134": [ 134, 53, "1" ], "141": [ 141, 26, "1" ], "155": [ 155, -29, 150, "150" ], "165": [ 165, -17, 5, "5" ], "131": [ 131, 27, "1" ], "148": [ 148, 56, "1" ], "158": [ 158, -23, 68, "68" ], "159": [ 159, -25, 30, "30" ], "145": [ 145, -46, 1, "1" ], "150": [ 150, -100, 100, "100" ], "166": [ 166, -3, 1, "1" ], "144": [ 144, -45, 1, "1" ], "120": [ 120, 45, "1" ] } ]'),
137	(18, 59, 'Detective', '[ [ [ 98, "N\\/A" ], [ 211, "N\\/A" ], [ 2, "N\\/A" ], [ 5, "N\\/A" ] ] ]', '[ { "36": "VEHICLE", "24": "Training Grounds", "22": "HQ", "23": "SIU" } ]', '[ { "149": [ 149, -100, 50, "100" ], "127": [ 127, 13, "1" ], "134": [ 134, 53, "1" ], "123": [ 123, 47, "1" ], "142": [ 142, -43, 50, "50" ], "137": [ 137, 113, "5" ], "147": [ 147, -3, 1, "1" ], "128": [ 128, 83, "1" ], "156": [ 156, -100, 100, "100" ], "139": [ 139, 126, "1" ], "154": [ 154, -24, 49, "49" ], "157": [ 157, 177, "" ], "120": [ 120, 45, "1" ] } ]'),
138	(23, 59, 'Civilian Staff', '[ [ [ "71", "1656" ], [ "286", "1657" ], [ "61", "1655" ], [ 211, "N\\/A" ] ] ]', '[ { "22": "HQ", "24": "Training Grounds" } ]', '[ { "146": [ 146, 1, "1" ], "149": [ 149, -100, 100, "100" ], "142": [ 142, -43, 50, "50" ], "134": [ 134, 53, "1" ], "123": [ 123, 47, "1" ], "137": [ 137, 113, "5" ], "147": [ 147, -3, 1, "1" ], "157": [ 157, 177, "" ], "159": [ 159, -41, 1000, "1000" ], "139": [ 139, 126, "1" ], "154": [ 154, 45, "1" ], "120": [ 120, 45, "1" ] } ]'),
139	(24, 1, 'Captain Lancaster', '[ [ [ "211", "2085" ] ] ]', '[ { "33": "VEHICLE", "25": "LSPD Locker Room" } ]', '[ [ ] ]'),
140	(25, 59, 'Auxiliary Staff', '[ [ [ "61", "1655" ], [ "71", "1656" ], [ "286", "1657" ], [ 211, "N\\/A" ] ] ]', '[ { "24": "Training Grounds", "22": "HQ", "116": "SADC" } ]', '[ { "146": [ 146, 1, "1" ], "149": [ 149, -100, 100, "100" ], "142": [ 142, -43, 50, "50" ], "134": [ 134, 53, "1" ], "123": [ 123, 47, "1" ], "137": [ 137, 113, "5" ], "147": [ 147, -3, 1, "1" ], "157": [ 157, 177, "" ], "139": [ 139, 126, "1" ], "154": [ 154, 45, "1" ], "120": [ 120, 45, "1" ] } ]'),
141	(27, 1, 'Ass. Chief Thor Assland', '[ [ [ "280", "2435" ], [ "280", "2436" ], [ "285", "1696" ] ] ]', '[ { "25": "LSPD Locker Room", "37": "VEHICLE" } ]', '[ [ ] ]'),
142	(28, 1, 'CPT Haldane', '[ [ [ "280", "1815" ] ] ]', '[ { "42": "VEHICLE", "43": "VEHICLE", "40": "VEHICLE", "41": "VEHICLE", "47": "VEHICLE", "46": "VEHICLE", "45": "VEHICLE", "44": "VEHICLE", "48": "VEHICLE", "25": "LSPD Locker Room", "39": "VEHICLE", "38": "VEHICLE", "31": "LSPD Metro 2", "30": "LSPD Metro 1", "29": "LSPD Glen Park", "32": "LSPD DB" } ]', ''),
143	(29, 1, 'Captain Almeida', '[ [ [ "280", "2372" ], [ "280", "2373" ], [ "280", "2437" ], [ "285", "1696" ], [ 240, "N\\/A" ], [ "186", "1739" ] ] ]', '[ { "25": "LSPD Locker Room", "35": "VEHICLE", "29": "LSPD Glen Park", "31": "LSPD Metro 2", "30": "LSPD Metro 1", "32": "LSPD DB", "113": "LSPD - Metro Training Ground" } ]', '[ { "3": [ "3", 26, "1" ], "36": [ "36", 29, "" ], "18": [ "18", -24, 35, "35" ], "34": [ "34", 13, "" ], "23": [ "23", -25, 20, "50" ], "68": [ "68", 27, "4" ], "17": [ "17", -31, 250, "250" ], "27": [ "27", -45, 1, "1" ], "29": [ "29", -17, 5, "5" ], "28": [ "28", -46, 1, "1" ], "37": [ "37", 56, "" ], "33": [ "33", 137, "1" ], "69": [ "69", -100, 100, "100" ] } ]'),
144	(30, 1, 'LSPD Academy', '[ [ [ 280, "N\\/A" ], [ 281, "N\\/A" ], [ 265, "N\\/A" ], [ 266, "N\\/A" ], [ 267, "N\\/A" ], [ 211, "N\\/A" ] ] ]', '[ { "25": "LSPD Locker Room", "29": "LSPD Glen Park", "31": "LSPD Metro 2", "30": "LSPD Metro 1", "32": "LSPD DB" } ]', '[ { "31": [ "31", 126, "1" ], "18": [ "18", -24, 21, "35" ], "23": [ "23", -25, 10, "50" ], "69": [ "69", -100, 100, "100" ] } ]'),
145	(31, 1, 'LSPD Patrol', '[ [ [ 280, "N\\/A" ], [ 281, "N\\/A" ], [ 265, "N\\/A" ], [ 266, "N\\/A" ], [ 267, "N\\/A" ], [ 211, "N\\/A" ] ] ]', '[ { "42": "VEHICLE", "43": "VEHICLE", "40": "VEHICLE", "41": "VEHICLE", "47": "VEHICLE", "37": "VEHICLE", "45": "VEHICLE", "113": "LSPD - Metro Training Ground", "48": "VEHICLE", "39": "VEHICLE", "38": "VEHICLE", "29": "LSPD Glen Park", "46": "VEHICLE", "123": "VEHICLE", "110": "VEHICLE", "129": "VEHICLE", "127": "VEHICLE", "44": "VEHICLE", "121": "VEHICLE", "119": "VEHICLE", "25": "LSPD Locker Room", "124": "VEHICLE", "128": "VEHICLE", "52": "VEHICLE", "31": "LSPD Metro 2", "30": "LSPD Metro 1", "33": "VEHICLE", "32": "LSPD DB" } ]', '[ { "1": [ "1", 45, "1" ], "23": [ "23", -25, 20, "50" ], "19": [ "19", -29, 150, "150" ], "30": [ "30", -3, 1, "1" ], "31": [ "31", 126, "1" ], "18": [ "18", -24, 35, "35" ], "25": [ "25", -43, 1, "50" ], "69": [ "69", -100, 100, "100" ] } ]'),
146	(32, 1, 'LSPD Detectives', '[ [ [ 280, "N\\/A" ], [ 281, "N\\/A" ], [ 265, "N\\/A" ], [ 266, "N\\/A" ], [ 267, "N\\/A" ], [ 211, "N\\/A" ] ] ]', '[ { "25": "LSPD Locker Room", "29": "LSPD Glen Park", "31": "LSPD Metro 2", "30": "LSPD Metro 1", "32": "LSPD DB" } ]', '[ { "1": [ "1", 45, "1" ], "19": [ "19", -29, 150, "150" ], "37": [ "37", 56, "" ], "25": [ "25", -43, 1, "50" ], "23": [ "23", -25, 20, "50" ], "38": [ "38", -4, 1, "1" ], "31": [ "31", 126, "1" ], "30": [ "30", -3, 1, "1" ], "18": [ "18", -24, 35, "35" ], "69": [ "69", -100, 50, "100" ] } ]'),
147	(33, 1, 'LSPD SWAT', '[ [ [ 280, "N\\/A" ], [ 281, "N\\/A" ], [ 265, "N\\/A" ], [ 266, "N\\/A" ], [ 267, "N\\/A" ], [ 211, "N\\/A" ], [ "285", "1696" ], [ "285", "1697" ] ] ]', '[ { "42": "VEHICLE", "43": "VEHICLE", "40": "VEHICLE", "41": "VEHICLE", "47": "VEHICLE", "37": "VEHICLE", "45": "VEHICLE", "35": "VEHICLE", "48": "VEHICLE", "39": "VEHICLE", "29": "LSPD Glen Park", "44": "VEHICLE", "25": "LSPD Locker Room", "38": "VEHICLE", "113": "LSPD - Metro Training Ground", "46": "VEHICLE", "31": "LSPD Metro 2", "30": "LSPD Metro 1", "33": "VEHICLE", "32": "LSPD DB" } ]', '[ { "74": [ "74", 120, "" ], "36": [ "36", 29, "" ], "37": [ "37", 56, "" ], "28": [ "28", -46, 1, "1" ], "29": [ "29", -17, 5, "5" ], "68": [ "68", 27, "4" ], "69": [ "69", -100, 100, "100" ], "1": [ "1", 45, "1" ], "3": [ "3", 26, "1" ], "19": [ "19", -29, 150, "150" ], "18": [ "18", -24, 35, "35" ], "17": [ "17", -31, 250, "250" ], "22": [ "22", -23, 68, "68" ], "24": [ "24", -27, 35, "35" ], "27": [ "27", -45, 1, "1" ], "26": [ "26", -44, 1, "1" ], "20": [ "20", -34, 10, "10" ], "21": [ "21", -33, 10, "10" ], "33": [ "33", 137, "1" ], "23": [ "23", -25, 30, "50" ] } ]'),
148	(34, 1, 'LT Cortez', '[ [ [ "285", "1696" ] ] ]', '[ { "31": "LSPD Metro 2", "30": "LSPD Metro 1" } ]', ''),
149	(36, 1, 'DB: Gangs & Narcotics Division', '[ [ [ 280, "N\\/A" ], [ 211, "N\\/A" ] ] ]', '[ { "25": "LSPD Locker Room", "52": "VEHICLE", "127": "VEHICLE", "128": "VEHICLE", "32": "LSPD DB" } ]', '[ { "36": [ "36", 29, "" ], "34": [ "34", 13, "" ], "35": [ "35", 83, "" ], "38": [ "38", -4, 1, "1" ], "68": [ "68", 27, "4" ], "69": [ "69", -100, 100, "100" ], "1": [ "1", 45, "1" ], "3": [ "3", 26, "1" ], "19": [ "19", -29, 150, "150" ], "18": [ "18", -24, 35, "35" ], "25": [ "25", -43, 1, "50" ], "29": [ "29", -17, 3, "5" ], "17": [ "17", -31, 150, "250" ], "20": [ "20", -34, 1, "10" ], "31": [ "31", 126, "1" ], "22": [ "22", -23, 68, "68" ], "23": [ "23", -25, 25, "50" ] } ]'),
150	(44, 47, 'Instructor Student', '[ [ [ 61, "N\\/A" ] ] ]', '[ { "58": "Gate Cabin" } ]', '[ { "125": [ 125, 174, "FAA" ], "127": [ 127, -24, 5, "50" ], "123": [ 123, 45, "FAA" ], "133": [ 133, -100, 75, "200" ], "121": [ 121, 163, "FAA" ], "131": [ 131, -43, 30, "30" ], "126": [ 126, -3, 1, "1" ], "122": [ 122, 45, "FAA" ], "120": [ 120, 126, "FAA" ] } ]'),
151	(45, 47, 'Instructor I', '[ [ [ "211", "808" ], [ "61", "107" ] ] ]', '[ { "58": "Gate Cabin" } ]', '[ { "125": [ 125, 174, "FAA" ], "132": [ 132, -46, 1, "1" ] } ]'),
152	(46, 47, 'Instructor II', '[ [ [ "211", "808" ], [ "61", "109" ] ] ]', '[ { "58": "Gate Cabin" } ]', '[ { "132": [ 132, -46, 1, "1" ], "125": [ 125, 174, "FAA" ] } ]'),
153	(47, 47, 'Instructor III', '[ [ [ "211", "808" ], [ "61", "110" ] ] ]', '[ { "58": "Gate Cabin" } ]', '[ { "132": [ 132, -46, 1, "1" ], "125": [ 125, 174, "FAA" ] } ]'),
154	(48, 47, 'Head Instructor', '[ [ [ "211", "808" ], [ "61", "111" ] ] ]', '[ { "58": "Gate Cabin" } ]', '[ { "125": [ 125, 174, "FAA" ], "131": [ 131, -43, 30, "30" ], "127": [ 127, -24, 20, "50" ], "132": [ 132, -46, 1, "1" ], "123": [ 123, 45, "FAA" ], "122": [ 122, 45, "FAA" ], "133": [ 133, -100, 100, "200" ], "120": [ 120, 126, "FAA" ] } ]'),
155	(49, 47, 'Security Guard', '[ [ [ "280", "809" ] ] ]', '[ { "58": "Gate Cabin" } ]', '[ { "125": [ 125, 174, "FAA" ], "127": [ 127, -24, 5, "50" ], "126": [ 126, -3, 1, "1" ], "133": [ 133, -100, 100, "200" ], "122": [ 122, 45, "FAA" ], "120": [ 120, 126, "FAA" ] } ]'),
156	(50, 47, 'Agent', '[ [ [ "286", "377" ], [ "211", "808" ] ] ]', '[ { "58": "Gate Cabin" } ]', '[ { "125": [ 125, 174, "FAA" ], "127": [ 127, -24, 50, "50" ], "123": [ 123, 45, "FAA" ], "133": [ 133, -100, 100, "200" ], "131": [ 131, -43, 30, "30" ], "126": [ 126, -3, 1, "1" ], "132": [ 132, -46, 1, "1" ], "122": [ 122, 45, "FAA" ], "120": [ 120, 126, "FAA" ] } ]'),
157	(51, 47, 'Special Agent', '[ [ [ "286", "377" ], [ "211", "808" ] ] ]', '[ { "58": "Gate Cabin" } ]', '[ { "125": [ 125, 174, "FAA" ], "131": [ 131, -43, 30, "30" ], "127": [ 127, -24, 50, "50" ], "126": [ 126, -3, 1, "1" ], "123": [ 123, 45, "FAA" ], "122": [ 122, 45, "FAA" ], "133": [ 133, -100, 100, "200" ], "120": [ 120, 126, "FAA" ] } ]'),
158	(52, 47, 'Air National Guard', '[ [ [ 287, "N\\/A" ], [ 285, "N\\/A" ], [ 179, "N\\/A" ], [ 121, "N\\/A" ], [ 73, "N\\/A" ] ] ]', '[ { "60": "VEHICLE", "61": "VEHICLE", "62": "VEHICLE", "68": "Area69", "59": "VEHICLE" } ]', '[ { "125": [ 125, 174, "FAA" ], "127": [ 127, -24, 50, "50" ], "129": [ 129, -29, 50, "50" ], "123": [ 123, 45, "FAA" ], "133": [ 133, -100, 200, "200" ], "121": [ 121, 163, "FAA" ], "131": [ 131, -43, 30, "30" ], "124": [ 124, 145, "FAA" ], "126": [ 126, -3, 1, "1" ], "132": [ 132, -46, 1, "1" ], "122": [ 122, 45, "FAA" ], "130": [ 130, -31, 100, "100" ], "120": [ 120, 126, "FAA" ] } ]'),
159	(53, 47, 'Air Traffic Control', '[ [ [ "211", "808" ], [ "71", "106" ] ] ]', '[ { "58": "Gate Cabin" } ]', '[ { "125": [ 125, 174, "FAA" ], "131": [ 131, -43, 30, "30" ], "132": [ 132, -46, 1, "1" ], "120": [ 120, 126, "FAA" ] } ]'),
160	(58, 47, 'D. Quint', '[ [ [ 61, "N\\/A" ], [ 287, "N\\/A" ], [ "46", "36" ] ] ]', '[ { "58": "Gate Cabin" } ]', '[ { "125": [ 125, 174, "FAA" ], "131": [ 131, -43, 20, "30" ], "127": [ 127, -24, 20, "50" ], "132": [ 132, -46, 1, "1" ], "123": [ 123, 45, "FAA" ], "122": [ 122, 45, "FAA" ], "133": [ 133, -100, 100, "200" ], "120": [ 120, 126, "FAA" ] } ]'),
161	(60, 4, 'Sales', '[ [ [ 217, "N\\/A" ], [ 264, "N\\/A" ] ] ]', '[ { "3": "Dressing Room", "69": "Dealership Office" } ]', '[ { "5": [ "5", -41, 50000, "50000" ], "12": [ "12", 183, "" ], "75": [ "75", 96, "" ] } ]'),
162	(61, 50, 'Special Operations Team', '[ [ [ "280", "2098" ], [ "285", "2107" ], [ "285", "2106" ] ] ]', '[ { "94": "VEHICLE", "95": "VEHICLE", "96": "VEHICLE", "97": "VEHICLE", "93": "VEHICLE", "92": "VEHICLE", "91": "VEHICLE", "90": "VEHICLE", "99": "VEHICLE", "98": "VEHICLE", "102": "VEHICLE", "101": "VEHICLE", "88": "VEHICLE", "109": "VEHICLE", "87": "VEHICLE", "21": "DLE HQ - Lockers", "104": "VEHICLE", "20": "VEHICLE", "100": "VEHICLE", "103": "VEHICLE", "89": "VEHICLE" } ]', ''),
163	(66, 1, 'Detective Quinn', '[ [ [ 280, "N\\/A" ], [ "186", "647" ], [ "186", "646" ], [ "186", "1739" ] ] ]', '[ { "25": "LSPD Locker Room", "29": "LSPD Glen Park", "110": "VEHICLE", "30": "LSPD Metro 1", "31": "LSPD Metro 2", "32": "LSPD DB" } ]', ''),
164	(67, 2, 'Firefighter/EMT', '[ [ [ "274", "1833" ], [ "276", "1832" ], [ 277, "N\\/A" ], [ 278, "N\\/A" ], [ 279, "N\\/A" ], [ "211", "2681" ], [ "124", "2682" ], [ "61", "2683" ], [ "211", "2660" ] ] ]', '[ { "111": "LSFD HQ DUTY" } ]', '[ { "118": [ "118", 145, "Flashlight" ], "119": [ "119", 164, "" ], "161": [ 161, 126, "" ], "115": [ "115", 70, "BLS Kit" ], "114": [ "114", 26, "Gas Mask" ] } ]'),
165	(68, 2, 'Academy Student', '[ [ [ "211", "2262" ], [ "124", "20" ] ] ]', '[ { "111": "LSFD HQ DUTY" } ]', '[ { "119": [ "119", 164, "" ], "115": [ "115", 70, "BLS Kit" ], "161": [ 161, 126, "" ] } ]'),
166	(69, 2, 'Firefighter/Paramedic', '[ [ [ "276", "1832" ], [ "274", "1833" ], [ 277, "N\\/A" ], [ 278, "N\\/A" ], [ 279, "N\\/A" ], [ "211", "2681" ], [ "124", "2682" ], [ "61", "2683" ], [ "211", "2660" ] ] ]', '[ { "111": "LSFD HQ DUTY" } ]', '[ { "162": [ 162, 46, "" ], "115": [ "115", 70, "BLS Kit" ], "161": [ 161, 126, "" ], "114": [ "114", 26, "Gas Mask" ], "119": [ "119", 164, "" ], "118": [ "118", 145, "Flashlight" ] } ]'),
167	(70, 2, 'Fire Chief/Female', '[ [ [ "211", "2259" ], [ "211", "2681" ] ] ]', '[ { "111": "LSFD HQ DUTY" } ]', '[ { "118": [ "118", 145, "Flashlight" ], "115": [ "115", 70, "BLS Kit" ], "117": [ "117", 120, "Scuba Gear" ], "113": [ "113", -9, 0, "0" ], "114": [ "114", 26, "Gas Mask" ], "119": [ "119", 164, "" ], "116": [ "116", 113, "Glowsticks" ], "161": [ 161, 126, "" ], "112": [ "112", -42, 1000, "1000" ], "162": [ 162, 46, "" ] } ]'),
168	(71, 2, 'SaR/Member', '[ [ [ "285", "1901" ] ] ]', '[ { "111": "LSFD HQ DUTY" } ]', '[ { "118": [ "118", 145, "Flashlight" ], "115": [ "115", 70, "BLS Kit" ], "117": [ "117", 120, "Scuba Gear" ], "113": [ "113", -9, 0, 0 ], "114": [ "114", 26, "Gas Mask" ], "119": [ "119", 164, "" ], "116": [ "116", 113, "Glowsticks" ], "161": [ 161, 126, "" ], "112": [ "112", -42, 1000, 1000 ], "162": [ 162, 46, "" ] } ]'),
169	(72, 2, 'Fire Inspector', '[ [ [ "276", "1832" ], [ 211, "N\\/A" ] ] ]', '[ { "111": "LSFD HQ DUTY" } ]', '[ { "114": [ "114", 26, "Gas Mask" ], "118": [ "118", 145, "Flashlight" ], "161": [ 161, 126, "" ] } ]'),
170	(76, 20, 'LSN Camera Equipment', '[ [ ] ]', '[ [ ] ]', ''),
171	(78, 59, 'Detention Officer ', '[ [ [ "285", "1670" ], [ "282", "1660" ], [ "71", "1656" ] ] ]', '[ { "116": "SADC" } ]', '[ { "125": [ 125, 26, "1" ], "150": [ 150, -24, 49, "49" ], "131": [ 131, 27, "1" ], "155": [ 155, 27, "" ], "147": [ 147, -3, 1, "1" ], "149": [ 149, -100, 100, "100" ], "140": [ 140, -25, 30, "30" ], "130": [ 130, 56, "1" ], "146": [ 146, -17, 5, "5" ] } ]'),
172	(79, 1, 'Sheriff Young', '[ [ [ 240, "N\\/A" ], [ 280, "N\\/A" ], [ 281, "N\\/A" ] ] ]', '[ { "140": "VEHICLE", "139": "VEHICLE", "113": "LSPD - Metro Training Ground", "137": "VEHICLE", "138": "VEHICLE", "135": "VEHICLE", "29": "LSPD Glen Park", "31": "LSPD Metro 2", "30": "LSPD Metro 1", "25": "LSPD Locker Room", "32": "LSPD DB" } ]', '[ { "1": [ "1", 45, "1" ], "2": [ "2", 1, "1" ], "36": [ "36", 29, "" ], "18": [ "18", -24, 35, "35" ], "34": [ "34", 13, "" ], "35": [ "35", 83, "" ], "27": [ "27", -45, 1, "1" ], "17": [ "17", -31, 250, "250" ], "31": [ "31", 126, "1" ], "30": [ "30", -3, 1, "1" ], "26": [ "26", -44, 1, "1" ], "69": [ "69", -100, 100, "100" ] } ]'),
173	(80, 64, 'M&ER Team', '[ [ [ 309, "N\\/A" ] ] ]', '[ { "117": "Duty Room" } ]', ''),
174	(81, 64, 'Bus Team', '[ [ [ "255", "2073" ] ] ]', '[ { "117": "Duty Room" } ]', ''),
175	(82, 64, 'Taxi Team', '[ [ [ "255", "2073" ] ] ]', '[ { "117": "Duty Room" } ]', ''),
176	(83, 47, 'Security Student', '[ [ [ "280", "809" ] ] ]', '[ { "58": "Gate Cabin" } ]', '[ { "125": [ 125, 174, "FAA" ], "131": [ 131, -43, 30, "30" ], "126": [ 126, -3, 1, "1" ], "123": [ 123, 45, "FAA" ], "122": [ 122, 45, "FAA" ], "133": [ 133, -100, 100, "200" ], "120": [ 120, 126, "FAA" ] } ]'),
177	(84, 3, 'Security Guard', '[ [ [ 163, "N\\/A" ], [ 164, "N\\/A" ], [ 165, "N\\/A" ], [ 166, "N\\/A" ] ] ]', '[ { "120": "Security Guard" } ]', '[ { "160": [ 160, -100, 100, "100" ] } ]'),
178	(85, 56, 'Delivery Driver', '[ [ [ 112, "N\\/A" ] ] ]', '[ { "49": "CARGO GROUP DB", "51": "VEHICLE", "50": "VEHICLE", "64": "VEHICLE", "63": "VEHICLE" } ]', ''),
179	(86, 56, 'Managers', '[ [ [ "186", "646" ] ] ]', '[ { "49": "CARGO GROUP DB", "51": "VEHICLE", "50": "VEHICLE", "64": "VEHICLE", "63": "VEHICLE" } ]', ''),
180	(88, 47, 'T. Williams', '[ [ [ "286", "377" ], [ "185", "1711" ] ] ]', '[ { "58": "Gate Cabin" } ]', '[ { "125": [ 125, 174, "FAA" ], "131": [ 131, -43, 20, "30" ], "127": [ 127, -24, 20, "50" ], "126": [ 126, -3, 1, "1" ], "133": [ 133, -100, 100, "200" ], "122": [ 122, 45, "FAA" ], "121": [ 121, 163, "FAA" ], "120": [ 120, 126, "FAA" ] } ]'),
181	(90, 47, 'D.Bryant', '[ [ [ "188", "1401" ], [ "286", "1403" ] ] ]', '[ { "126": "VEHICLE", "58": "Gate Cabin" } ]', '[ { "125": [ 125, 174, "FAA" ], "127": [ 127, -24, 50, "50" ], "133": [ 133, -100, 100, "200" ], "131": [ 131, -43, 30, "30" ], "124": [ 124, 145, "FAA" ], "126": [ 126, -3, 1, "1" ], "132": [ 132, -46, 1, "1" ], "122": [ 122, 45, "FAA" ], "120": [ 120, 126, "FAA" ] } ]'),
182	(91, 4, 'Probationary', '[ [ [ "305", "839" ], [ "211", "341" ] ] ]', '[ { "3": "Dressing Room" } ]', '[ { "5": [ "5", -41, 1000, "50000" ], "6": [ "6", -43, 100, "500" ] } ]'),
183	(93, 1, 'Lt. Samuel Dunston', '[ [ [ 281, "N\\/A" ] ] ]', '[ { "121": "VEHICLE", "124": "VEHICLE" } ]', '[ { "1": [ "1", 45, "1" ], "17": [ "17", -31, 50, "250" ], "69": [ "69", -100, 100, "100" ], "30": [ "30", -3, 1, "1" ], "18": [ "18", -24, 35, "35" ], "23": [ "23", -25, 50, "50" ] } ]'),
184	(94, 1, 'Lt Mendoza', '[ [ [ "115", "2267" ] ] ]', '[ { "31": "LSPD Metro 2", "30": "LSPD Metro 1", "25": "LSPD Locker Room", "32": "LSPD DB" } ]', '[ { "1": [ "1", 45, "1" ], "27": [ "27", -45, 1, "1" ], "17": [ "17", -31, 250, "250" ], "36": [ "36", 29, "" ], "18": [ "18", -24, 35, "35" ], "69": [ "69", -100, 100, "100" ] } ]'),
185	(95, 2, 'New Skins WIP ', '[ [ [ "124", "2682" ], [ "61", "2683" ], [ "211", "2681" ] ] ]', '[ { "111": "LSFD HQ DUTY" } ]', '[ [ ] ]'),
186	(96, 10, 'lel', '[ [ ] ]', '[ [ ] ]', '[ { "120": [ 120, -16, 3, 50 ] } ]'),
187	(97, 7, 'Unarmed Armor', '[ [ ] ]', '[ [ ] ]', '[ { "76": [ "76", 126, "FAA" ], "77": [ "77", 163, "FAA" ], "85": [ "85", 45, "FAA" ], "80": [ "80", -100, 100, "200" ], "78": [ "78", 174, "FAA" ] } ]'),
188	(98, 7, 'Special Agent', '[ [ ] ]', '[ [ ] ]', '[ { "76": [ "76", 126, "FAA" ], "77": [ "77", 163, "FAA" ], "85": [ "85", 45, "FAA" ], "84": [ "84", -43, 100, "100" ], "82": [ "82", -24, 50, "50" ], "83": [ "83", -31, 100, "100" ], "80": [ "80", -100, 200, "200" ], "78": [ "78", 174, "FAA" ] } ]');
189/*!40000 ALTER TABLE `duty_custom` ENABLE KEYS */;
190
191-- Dumping structure for table mta.duty_locations
192DROP TABLE IF EXISTS `duty_locations`;
193CREATE TABLE IF NOT EXISTS `duty_locations` (
194  `id` int(11) NOT NULL AUTO_INCREMENT,
195  `factionid` int(11) NOT NULL,
196  `name` text NOT NULL,
197  `x` int(11) DEFAULT NULL,
198  `y` int(11) DEFAULT NULL,
199  `z` int(11) DEFAULT NULL,
200  `radius` int(11) DEFAULT NULL,
201  `dimension` int(11) DEFAULT 0,
202  `interior` int(11) DEFAULT 0,
203  `vehicleid` int(11) DEFAULT NULL,
204  `model` int(11) DEFAULT NULL,
205  PRIMARY KEY (`id`),
206  UNIQUE KEY `id_UNIQUE` (`id`)
207) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=latin1 COMMENT='Used for custom duty locations.';
208
209-- Dumping data for table mta.duty_locations: ~64 rows (approximately)
210/*!40000 ALTER TABLE `duty_locations` DISABLE KEYS */;
211INSERT INTO `duty_locations` (`id`, `factionid`, `name`, `x`, `y`, `z`, `radius`, `dimension`, `interior`, `vehicleid`, `model`) VALUES
212	(3, 4, 'Dressing Room', 2051, -1470, 142, 4, 381, 10, NULL, NULL),
213	(19, 59, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 6749, 427),
214	(21, 50, 'DLE HQ - Lockers', 1570, -1684, 64, 5, 2249, 7, NULL, NULL),
215	(22, 59, 'HQ', 1905, -2450, 16, 9, 18, 10, NULL, NULL),
216	(23, 59, 'SIU', 447, 182, 1028, 10, 2380, 5, NULL, NULL),
217	(24, 59, 'Training Grounds', -120, 106, 998, 10, 1614, 3, NULL, NULL),
218	(25, 1, 'LSPD Locker Room', 266, 119, 1005, 10, 1158, 10, NULL, NULL),
219	(26, 59, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 9905, 417),
220	(27, 59, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 7982, 427),
221	(28, 59, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 8820, 601),
222	(29, 1, 'LSPD Glen Park', 1393, 1811, 13, 10, 624, 6, NULL, NULL),
223	(30, 1, 'LSPD Metro 1', 1751, -2521, 16, 10, 1529, 23, NULL, NULL),
224	(31, 1, 'LSPD Metro 2', 1775, -2522, 16, 10, 1529, 23, NULL, NULL),
225	(32, 1, 'LSPD DB', 1426, 1385, 13, 10, 785, 2, NULL, NULL),
226	(34, 59, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 7047, 430),
227	(36, 59, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 6748, 528),
228	(49, 56, 'CARGO GROUP DB', 1391, 1777, 12, 6, 17, 18, NULL, NULL),
229	(50, 56, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 7060, 456),
230	(51, 56, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 7061, 456),
231	(55, 69, 'Ship', -1588, 50, 17, 10, 0, 0, NULL, NULL),
232	(56, 69, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 13223, 443),
233	(57, 69, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 12755, 443),
234	(58, 47, 'Gate Cabin', 1954, -2184, 14, 5, 0, 0, NULL, NULL),
235	(59, 47, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 12523, 433),
236	(60, 47, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 12525, 470),
237	(61, 47, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 12524, 470),
238	(62, 47, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 12995, 470),
239	(63, 56, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 5275, 482),
240	(64, 56, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 8488, 418),
241	(68, 47, 'Area69', 214, 1868, 13, 10, 0, 0, NULL, NULL),
242	(69, 4, 'Dealership Office', 2125, -2443, 14, 5, 1637, 56, NULL, NULL),
243	(71, 4, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 11055, 525),
244	(72, 4, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 6269, 552),
245	(73, 4, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 4224, 525),
246	(74, 4, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 4223, 525),
247	(75, 4, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 1319, 525),
248	(76, 4, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 3838, 525),
249	(77, 4, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 1322, 525),
250	(79, 4, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 1313, 525),
251	(80, 4, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 1311, 525),
252	(81, 4, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 7613, 611),
253	(82, 4, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 2033, 525),
254	(83, 4, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 1316, 525),
255	(84, 4, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 8377, 578),
256	(86, 4, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 3983, 578),
257	(87, 50, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 13893, 427),
258	(88, 50, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 13844, 582),
259	(89, 50, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 12219, 609),
260	(90, 50, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 11904, 470),
261	(105, 69, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 13191, 578),
262	(111, 2, 'LSFD HQ DUTY', 1532, 1355, 14, 10, 617, 1, NULL, NULL),
263	(113, 1, 'LSPD - Metro Training Ground', -1283, -22, 14, 10, 389, 3, NULL, NULL),
264	(116, 59, 'SADC', 1497, 1544, 12, 10, 812, 3, NULL, NULL),
265	(117, 64, 'Duty Room', 1488, 1370, 17, 3, 1883, 24, NULL, NULL),
266	(118, 64, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 8007, 579),
267	(120, 3, 'Security Guard', 1545, 1468, 29, 5, 2695, 21, NULL, NULL),
268	(122, 50, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 13883, 405),
269	(125, 64, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 8836, 578),
270	(126, 47, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 10024, 560),
271	(130, 4, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 17, 525),
272	(131, 10, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 104, 490),
273	(133, 4, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 17, 525),
274	(134, 7, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 122, 560),
275	(135, 1, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 77, 560),
276	(136, 2, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 282, 490),
277	(137, 1, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 67, 598),
278	(138, 1, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 1, 510),
279	(139, 1, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 3, 508),
280	(140, 1, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 36, 489),
281	(141, 1, 'VEHICLE', NULL, NULL, NULL, NULL, 0, 0, 50, 502);
282/*!40000 ALTER TABLE `duty_locations` ENABLE KEYS */;