· 8 years ago · Apr 18, 2018, 07:50 PM
1SET NAMES utf8;
2SET time_zone = '+00:00';
3SET foreign_key_checks = 0;
4SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
5
6DROP TABLE IF EXISTS `ajail_logs`;
7CREATE TABLE `ajail_logs` (
8 `id` int(11) NOT NULL AUTO_INCREMENT,
9 `JailedDBID` int(11) NOT NULL,
10 `JailedName` varchar(32) NOT NULL,
11 `Reason` varchar(128) NOT NULL,
12 `Date` varchar(90) NOT NULL,
13 `JailedBy` varchar(32) NOT NULL,
14 `Time` int(11) NOT NULL,
15 PRIMARY KEY (`id`)
16) ENGINE=InnoDB DEFAULT CHARSET=latin1;
17
18INSERT INTO `ajail_logs` (`id`, `JailedDBID`, `JailedName`, `Reason`, `Date`, `JailedBy`, `Time`) VALUES
19(12, 3, 'James_Corcoran', 'gay hair', 'March 24, 2018 22:37:24', 'James_Corcoran', 1),
20(13, 3, 'James_Corcoran', 'gay hair part 2', 'March 24, 2018 22:38:31', 'James_Corcoran', 1),
21(14, 6, 'Abram_Goraya', 'test', 'March 25, 2018 06:20:52', 'Abram_Goraya', 1),
22(15, 6, 'Abram_Goraya', '123', 'March 25, 2018 06:57:20', 'Abram_Goraya', 123),
23(16, 15, 'Charles_Ewing', 'dm', 'March 28, 2018 20:10:56', 'Bane_Soprano', 1),
24(17, 25, 'Ay_Lmao', '1', 'March 29, 2018 23:08:58', 'Ay_Lmao', 1);
25
26DROP TABLE IF EXISTS `bannedlist`;
27CREATE TABLE `bannedlist` (
28 `id` int(11) NOT NULL AUTO_INCREMENT,
29 `CharacterDBID` int(11) NOT NULL,
30 `MasterDBID` int(11) NOT NULL,
31 `CharacterName` varchar(32) NOT NULL,
32 `Reason` varchar(128) NOT NULL,
33 `Date` varchar(90) NOT NULL,
34 `BannedBy` varchar(32) NOT NULL,
35 `IpAddress` varchar(60) NOT NULL,
36 PRIMARY KEY (`id`)
37) ENGINE=InnoDB DEFAULT CHARSET=latin1;
38
39
40DROP TABLE IF EXISTS `ban_logs`;
41CREATE TABLE `ban_logs` (
42 `id` int(11) NOT NULL AUTO_INCREMENT,
43 `CharacterDBID` int(11) NOT NULL,
44 `MasterDBID` int(11) NOT NULL,
45 `CharacterName` varchar(32) NOT NULL,
46 `Reason` varchar(128) NOT NULL,
47 `BannedBy` varchar(32) NOT NULL,
48 `Date` varchar(90) NOT NULL,
49 PRIMARY KEY (`id`)
50) ENGINE=InnoDB DEFAULT CHARSET=latin1;
51
52
53DROP TABLE IF EXISTS `businesses`;
54CREATE TABLE `businesses` (
55 `BusinessDBID` int(11) NOT NULL AUTO_INCREMENT,
56 `BusinessOwnerDBID` int(11) NOT NULL DEFAULT '0',
57 `BusinessInteriorX` float NOT NULL,
58 `BusinessInteriorY` float NOT NULL,
59 `BusinessInteriorZ` float NOT NULL,
60 `BusinessInteriorWorld` int(11) NOT NULL,
61 `BusinessInteriorIntID` int(11) NOT NULL,
62 `BusinessEntranceX` float NOT NULL,
63 `BusinessEntranceY` float NOT NULL,
64 `BusinessEntranceZ` float NOT NULL,
65 `BusinessName` varchar(90) NOT NULL DEFAULT 'Nameless',
66 `BusinessType` int(11) NOT NULL DEFAULT '0',
67 `BusinessLocked` tinyint(1) NOT NULL DEFAULT '0',
68 `BusinessEntranceFee` int(11) NOT NULL DEFAULT '1',
69 `BusinessLevel` int(11) NOT NULL,
70 `BusinessMarketPrice` int(11) NOT NULL DEFAULT '5000',
71 `BusinessCashbox` int(11) NOT NULL DEFAULT '0',
72 `BusinessProducts` int(11) NOT NULL DEFAULT '0',
73 `BusinessBankPickupLocX` float NOT NULL,
74 `BusinessBankPickupLocY` float NOT NULL,
75 `BusinessBankPickupLocZ` float NOT NULL,
76 `BusinessBankPickupWorld` int(11) NOT NULL,
77 PRIMARY KEY (`BusinessDBID`)
78) ENGINE=InnoDB DEFAULT CHARSET=latin1;
79
80INSERT INTO `businesses` (`BusinessDBID`, `BusinessOwnerDBID`, `BusinessInteriorX`, `BusinessInteriorY`, `BusinessInteriorZ`, `BusinessInteriorWorld`, `BusinessInteriorIntID`, `BusinessEntranceX`, `BusinessEntranceY`, `BusinessEntranceZ`, `BusinessName`, `BusinessType`, `BusinessLocked`, `BusinessEntranceFee`, `BusinessLevel`, `BusinessMarketPrice`, `BusinessCashbox`, `BusinessProducts`, `BusinessBankPickupLocX`, `BusinessBankPickupLocY`, `BusinessBankPickupLocZ`, `BusinessBankPickupWorld`) VALUES
81(2, 0, 316.315, -169.818, 999.601, 388, 6, -4284.88, -595.587, 14.931, 'Cacarino\'s EMpyre', 2, 0, 0, 0, 23, 0, 0, 0, 0, 0, 0),
82(3, 0, 316.378, -169.516, 999.601, 7167, 6, 943.879, -190.768, 496.706, 'WPWW', 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
83(4, 0, 286.149, -40.644, 1001.52, 3155, 1, -4284.58, -568.653, 15.16, 'carrucha Car ))machina))', 7, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0),
84(5, 0, -975.976, 1060.98, 1345.67, 8416, 10, 944.261, -154.183, 496.935, 'CARPACCIO', 6, 0, 0, 1, 100, 0, 0, 0, 0, 0, 0),
85(6, 0, 2305.23, -16.157, 26.742, 18839, 0, 915.854, -495.559, 496.706, '~r~Bank of Liberty ~w~Portland Chinatown', 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
86(7, 0, -227.028, 1401.23, 27.766, 12633, 18, 777.952, -81.202, 486.883, 'Big Al\'s Liquor', 3, 0, 0, 1, 1000000, 0, 0, 0, 0, 0, 0),
87(8, 0, 460.024, -88.51, 999.555, 16053, 4, 821.75, -143.922, 491.706, 'Cheap Shitty Foods', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
88(9, 0, -794.864, 490.093, 1376.19, 18262, 1, 1197.69, -248.202, 536.264, 'St. Mark\'s Bistro', 3, 0, 0, 0, 5000000, 0, 0, 0, 0, 0, 0),
89(10, 0, 0, 0, 0, 0, 0, 1278.25, -826.128, 493.552, '', 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
90(11, 0, -100.213, -24.192, 1000.72, 12566, 3, 867.905, -237.401, 496.856, 'la maria si ion', 5, 0, 69, 1, 0, 138, 0, 0, 0, 0, 0),
91(12, 0, 1525.73, -10.755, 1002.1, 15507, 3, 2247.28, -1156.93, 1029.8, '', 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
92(13, 0, 681.451, -451.448, -25.617, 3087, 1, 740.062, -781.796, 486.986, 'Greasy Joe\'s Diner & Restaurant', 1, 0, 0, 0, 1000000, 0, 0, 0, 0, 0, 0),
93(14, 0, 870.552, -197.98, 496.599, 3828, 0, 870.609, -197.928, 496.592, 'bank', 4, 0, 0, 0, 500000, 0, 0, 0, 0, 0, 0),
94(15, 0, 0, 0, 0, 0, 0, 1323.42, 11.415, 537.394, '', 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
95(16, 0, 0, 0, 0, 0, 0, -4286.23, -678.328, 14.931, '', 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
96
97DROP TABLE IF EXISTS `characters`;
98CREATE TABLE `characters` (
99 `master_dbid` int(11) NOT NULL,
100 `char_dbid` int(11) NOT NULL AUTO_INCREMENT,
101 `char_name` varchar(32) NOT NULL,
102 `create_date` varchar(60) NOT NULL,
103 `create_ip` varchar(60) NOT NULL,
104 `pLastSkin` int(11) NOT NULL DEFAULT '264',
105 `pLastPosX` float NOT NULL DEFAULT '1642.02',
106 `pLastPosY` float NOT NULL DEFAULT '-2334.05',
107 `pLastPosZ` float NOT NULL DEFAULT '13.5469',
108 `pLastInterior` int(11) NOT NULL DEFAULT '0',
109 `pLastWorld` int(11) NOT NULL DEFAULT '0',
110 `pLevel` int(11) NOT NULL DEFAULT '1',
111 `pEXP` int(11) NOT NULL DEFAULT '0',
112 `pAge` varchar(20) NOT NULL DEFAULT 'Invalid',
113 `pOrigin` varchar(60) NOT NULL DEFAULT 'Invalid',
114 `pStory` varchar(90) NOT NULL DEFAULT 'Nothing',
115 `pStoryTwo` varchar(90) NOT NULL DEFAULT 'Nothing',
116 `pMoney` int(11) NOT NULL DEFAULT '5000',
117 `pBank` int(11) NOT NULL DEFAULT '15000',
118 `pPaycheck` int(11) NOT NULL DEFAULT '5000',
119 `pPhone` int(11) NOT NULL,
120 `pLastOnline` varchar(90) NOT NULL,
121 `pLastOnlineTime` int(11) NOT NULL,
122 `pAdminjailed` tinyint(1) NOT NULL,
123 `pAdminjailTime` int(11) NOT NULL,
124 `pOfflinejailed` tinyint(1) NOT NULL DEFAULT '0',
125 `pOfflinejailedReason` varchar(128) NOT NULL,
126 `pFaction` int(11) NOT NULL DEFAULT '0',
127 `pFactionRank` int(11) NOT NULL DEFAULT '0',
128 `pOwnedVehicles1` int(11) NOT NULL DEFAULT '0',
129 `pOwnedVehicles2` int(11) NOT NULL DEFAULT '0',
130 `pOwnedVehicles3` int(11) NOT NULL DEFAULT '0',
131 `pOwnedVehicles4` int(11) NOT NULL DEFAULT '0',
132 `pOwnedVehicles5` int(11) NOT NULL DEFAULT '0',
133 `pVehicleSpawned` tinyint(1) NOT NULL DEFAULT '0',
134 `pVehicleSpawnedID` int(11) NOT NULL DEFAULT '0',
135 `pWeapons0` tinyint(4) NOT NULL DEFAULT '0',
136 `pWeapons1` tinyint(4) NOT NULL DEFAULT '0',
137 `pWeapons2` tinyint(4) NOT NULL DEFAULT '0',
138 `pWeapons3` tinyint(4) NOT NULL DEFAULT '0',
139 `pWeaponsAmmo0` smallint(6) NOT NULL DEFAULT '0',
140 `pWeaponsAmmo1` smallint(6) NOT NULL DEFAULT '0',
141 `pWeaponsAmmo2` smallint(6) NOT NULL DEFAULT '0',
142 `pWeaponsAmmo3` smallint(6) NOT NULL DEFAULT '0',
143 `pTimeplayed` int(11) NOT NULL DEFAULT '0',
144 `pMaskID` int(11) NOT NULL,
145 `pMaskIDEx` int(11) NOT NULL,
146 `pInProperty` int(11) NOT NULL DEFAULT '0',
147 `pInBusiness` int(11) NOT NULL DEFAULT '0',
148 `pHasRadio` tinyint(1) NOT NULL DEFAULT '0',
149 `pRadio1` int(11) NOT NULL DEFAULT '0',
150 `pRadio2` int(11) NOT NULL DEFAULT '0',
151 `pMainSlot` int(11) NOT NULL DEFAULT '1',
152 `pGascan` int(11) NOT NULL DEFAULT '0',
153 `pSpawnPoint` int(11) NOT NULL DEFAULT '0',
154 `pSpawnPointHouse` int(11) NOT NULL DEFAULT '0',
155 `pWeaponsLicense` int(11) NOT NULL DEFAULT '0',
156 `pDriversLicense` int(11) NOT NULL DEFAULT '0',
157 `pActiveListings` int(11) NOT NULL DEFAULT '0',
158 `pPrisonTimes` int(11) NOT NULL DEFAULT '0',
159 `pJailTimes` int(11) NOT NULL DEFAULT '0',
160 PRIMARY KEY (`char_dbid`)
161) ENGINE=InnoDB DEFAULT CHARSET=latin1;
162
163INSERT INTO `characters` (`master_dbid`, `char_dbid`, `char_name`, `create_date`, `create_ip`, `pLastSkin`, `pLastPosX`, `pLastPosY`, `pLastPosZ`, `pLastInterior`, `pLastWorld`, `pLevel`, `pEXP`, `pAge`, `pOrigin`, `pStory`, `pStoryTwo`, `pMoney`, `pBank`, `pPaycheck`, `pPhone`, `pLastOnline`, `pLastOnlineTime`, `pAdminjailed`, `pAdminjailTime`, `pOfflinejailed`, `pOfflinejailedReason`, `pFaction`, `pFactionRank`, `pOwnedVehicles1`, `pOwnedVehicles2`, `pOwnedVehicles3`, `pOwnedVehicles4`, `pOwnedVehicles5`, `pVehicleSpawned`, `pVehicleSpawnedID`, `pWeapons0`, `pWeapons1`, `pWeapons2`, `pWeapons3`, `pWeaponsAmmo0`, `pWeaponsAmmo1`, `pWeaponsAmmo2`, `pWeaponsAmmo3`, `pTimeplayed`, `pMaskID`, `pMaskIDEx`, `pInProperty`, `pInBusiness`, `pHasRadio`, `pRadio1`, `pRadio2`, `pMainSlot`, `pGascan`, `pSpawnPoint`, `pSpawnPointHouse`, `pWeaponsLicense`, `pDriversLicense`, `pActiveListings`, `pPrisonTimes`, `pJailTimes`) VALUES
164(1, 1, 'Carmine_Giola', 'March 24, 2018 19:35:30', '98.117.169.109', 111, -4331.15, -675.787, 14.89, 0, 0, 1, 1, '03/21/1963', 'Liberty City', '', '', 204800, 14815, 7000, 97231, 'April 18, 2018 20:48:38', 3, 0, 0, 0, '', 0, 0, 14, 0, 0, 0, 0, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 1, 358208, 92, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
165(2, 2, 'Fred_Szczesniak', 'March 24, 2018 19:51:12', '86.123.29.41', 264, -4313.29, -639.9, 14.931, 0, 0, 1, 0, '10/11/1985', 'United States of America', '', '', 5000, 15000, 5000, 98857, 'March 24, 2018 19:54:18', 4, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 216772, 66, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
166(4, 3, 'James_Corcoran', 'March 24, 2018 20:30:44', '82.47.119.100', 72, 827.904, -130.624, 491.558, 0, 0, 1, 15, '11/11/1971', 'United States of America', '', '', 300, 14913, 35000, 94174, 'March 26, 2018 22:44:45', 24, 0, 0, 0, '', 1, 0, 1, 3, 0, 0, 0, 0, 65535, 3, 0, 24, 0, 1, 0, 79, 0, 15, 212283, 81, 0, 0, 0, 0, 0, 1, 0, 2, 0, 0, 0, 1, 0, 0),
167(5, 4, 'John_Cacarino', 'March 24, 2018 22:07:08', '89.42.193.56', 254, 940.477, -28.014, 486.711, 0, 0, 2, 2, '11/09/2001', 'Cadia', 'Enemies of the Imperium, hear me. You have come here to die. The Immortal Emperor is with', '', 75465375, -300, 34000, 95019, 'March 28, 2018 21:36:09', 16, 0, 0, 0, '', 4, 1, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 15, 395442, 41, 0, 0, 0, 0, 0, 1, 0, 2, 4, 1, 0, 1, 0, 0),
168(6, 5, 'George_Stone', 'March 24, 2018 23:39:39', '188.129.163.74', 264, -4287.92, -578.253, 14.641, 0, 0, 1, 0, '08/12/2017', 'Saudi Arabia', '', '', 5000, 15000, 5000, 99645, 'March 24, 2018 23:55:37', 3, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 208905, 91, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
169(7, 6, 'Abram_Goraya', 'March 25, 2018 00:36:07', '98.117.169.109', 50, 1453.09, -19.224, 534.977, 0, 0, 99, 5, '08/12/2017', 'United States of America', '', '', 5018932, 123457, 1, 94093, 'March 30, 2018 02:18:27', 19, 0, 0, 0, '', 1, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, 398167, 70, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0),
170(8, 7, 'Wise_Guy', 'March 25, 2018 07:12:14', '75.157.15.54', 264, -4332.97, -658.519, 14.782, 0, 0, 1, 1, '24/01/2001', 'United States of Israel', '', '', 5000, 14815, 7000, 99324, 'March 25, 2018 08:39:02', 27, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 305268, 73, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
171(9, 8, 'Joey_Banucceli', 'March 25, 2018 07:26:09', '92.86.51.12', 264, -4314.02, -648.877, 14.814, 0, 0, 1, 0, '10/10/1067', 'USA', '', '', 5000, 15000, 5000, 96240, 'March 25, 2018 07:26:36', 1, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 397069, 88, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
172(12, 10, 'Bernard_Greene', 'March 25, 2018 16:11:46', '93.85.145.144', 165, -4331.36, -675.133, 14.885, 0, 0, 1, 0, '12/06/1977', 'United States of America', '', '', 4600, 15000, 5000, 99498, 'March 25, 2018 22:40:21', 3, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 350663, 64, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
173(13, 11, 'Massimo_Bonamici', 'March 25, 2018 16:22:40', '178.117.233.10', 286, -4369.38, -437.691, 4.935, 0, 0, 1, 1, '28/09/1958', 'United States of America', '', '', 5000, 14815, 7000, 97521, 'March 25, 2018 18:07:16', 2, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 285926, 49, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
174(16, 12, 'Pive_Pive', 'March 25, 2018 22:34:44', '87.95.38.148', 264, -4422.83, -348.779, 4.932, 0, 0, 1, 0, '01/01/1981', 'usa', '', '', 5000, 15000, 5000, 96861, 'March 25, 2018 22:46:58', 7, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 203378, 87, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
175(17, 13, 'Firstname_Lastname', 'March 26, 2018 08:24:01', '64.180.13.70', 264, 1172.27, -77.889, 519.235, 0, 0, 1, 1, '00/00/0000', 'Khazaria', '', '', 5000, 14815, 7000, 94713, 'March 27, 2018 23:36:42', 5, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 276042, 76, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
176(18, 14, 'Steven_Cerza', 'March 26, 2018 15:34:07', '94.15.55.11', 264, 221.752, -161.479, 1.578, 0, 0, 1, 1, '01/12/1990', 'Palermo', '', '', 5000, 14815, 7000, 97108, 'March 26, 2018 16:03:13', 30, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 379752, 44, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
177(19, 15, 'Charles_Ewing', 'March 26, 2018 17:56:12', '213.168.10.81', 37, -99.04, -9.39, 10.65, 0, 0, 1, 12, '04/08/1970', 'LA, CA, United States of America', '', '', 203011124, 12768, 29000, 94020, 'March 28, 2018 20:18:43', 34, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 17, 0, 31, 0, 9996, 0, 9785, 12, 297052, 51, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0),
178(5, 16, 'Lee_BertyCity', 'March 26, 2018 21:47:48', '82.137.11.129', 264, -4325.35, -672.06, -0.223, 0, 0, 1, 0, '90/09/2002', 'rasputin', '', '', 4900, 15000, 5000, 94072, 'March 27, 2018 15:32:33', 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 360101, 89, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
179(20, 17, 'Philip_Rescigno', 'March 26, 2018 21:49:48', '213.168.10.81', 264, -4325.04, -672.517, -0.737, 0, 0, 1, 0, '05/03/1990', 'United states...', '', '', 5000, 15000, 5000, 94551, 'March 26, 2018 21:50:04', 1, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 399427, 43, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
180(21, 18, 'Garland_Riggs', 'March 26, 2018 23:33:39', '46.10.220.4', 295, 1137.34, 96.421, 496.664, 2, 0, 1, 1, '01/01/1976', 'United States of America', '', '', 5420, 14815, 7000, 99221, 'March 27, 2018 14:31:29', 11, 0, 0, 0, '', 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 24, 0, 0, 0, 65, 0, 1, 372077, 92, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
181(22, 19, 'Ronald_Madder', 'March 27, 2018 13:24:45', '86.124.193.41', 300, 919.396, -506.623, 496.706, 0, 0, 1, 2, '07/12/1967', 'USA', 'sip', '', 1005000, 14630, 9000, 99872, 'April 1, 2018 15:56:48', 11, 0, 0, 0, '', 1, 0, 9, 10, 12, 0, 0, 0, 6, 0, 15, 0, 25, 0, 1, 0, 1, 2, 311325, 64, 0, 0, 0, 0, 0, 1, 0, 2, 0, 0, 0, 0, 0, 0),
182(23, 20, 'Jackie_Dumps', 'March 27, 2018 16:13:12', '67.82.190.49', 299, 745.014, -99.481, 490.022, 0, 0, 1, 2, '02/12/1989', 'United States of America', '', '', 5000, 14630, 9000, 95533, 'March 28, 2018 17:25:11', 29, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 332673, 79, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
183(25, 21, 'Tigran_Ghazaryan', 'March 27, 2018 22:24:10', '188.173.102.57', 292, 944.201, -224.727, 496.935, 0, 0, 1, 0, '02/04/1987', 'Armenia', '', '', 62092096, 15000, 5000, 96155, 'March 30, 2018 00:56:50', 2, 0, 0, 0, '', 1, 0, 13, 0, 0, 0, 0, 1, 8, 0, 0, 0, 0, 0, 0, 0, 0, 0, 279555, 92, 0, 0, 0, 0, 0, 1, 0, 2, 0, 0, 0, 0, 0, 0),
184(27, 22, 'Bane_Soprano', 'March 28, 2018 20:05:32', '109.92.83.231', 145, 1539.96, -1674.26, 14.15, 0, 0, 1, 4, '12/12/1958', 'Island', '', '', 4800, 14259, 13000, 98575, 'March 28, 2018 20:17:23', 9, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 383463, 48, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
185(28, 23, 'David_Ohara', 'March 28, 2018 23:24:42', '176.252.129.217', 264, -4326, -671.05, -2.314, 0, 0, 1, 0, '02/08/1965', 'United States of America', '', '', 5000, 15000, 5000, 100393, 'March 28, 2018 23:24:50', 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 283177, 97, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
186(29, 24, 'Michael_Brennan', 'March 29, 2018 10:43:22', '122.151.148.235', 124, -4325.97, -671.022, -2.491, 0, 0, 1, 2, '03/12/1986', 'United States of America', '', '', 4931, 14630, 9000, 98801, 'March 30, 2018 08:47:34', 27, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 291379, 56, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
187(31, 25, 'Ay_Lmao', 'March 29, 2018 21:26:17', '90.220.149.246', 112, 788.732, -147.87, 491.926, 0, 0, 1, 0, '09/12/1955', 'Arabia', 'kip', '', 342294280, 15000, 5000, 100976, 'April 2, 2018 12:22:22', 4, 0, 0, 0, '', 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 248108, 70, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
188(32, 26, 'Malaka_Farowan', 'March 31, 2018 08:49:19', '5.13.189.170', 264, -3447.25, -747.681, -0.289, 0, 0, 1, 0, '29/12/1971', 'Arabia', '', '', 5000, 15000, 5000, 98287, 'March 31, 2018 08:56:13', 8, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 298208, 41, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
189(34, 27, 'Luke_Pentecost', 'April 1, 2018 20:53:21', '31.5.216.16', 264, -4323.36, -675.891, -0.149, 0, 0, 1, 0, '14/02/1995', 'Romania', '', '', 5000, 15000, 5000, 100752, 'April 1, 2018 21:00:35', 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 239975, 56, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
190(35, 28, 'ASGOOD_ASGOOD', 'April 1, 2018 21:07:40', '92.86.38.132', 264, -4306.83, -635.905, -0.352, 0, 0, 1, 0, '20/07/2003', 'Romania', '', '', 5000, 15000, 5000, 95754, 'April 1, 2018 21:09:42', 3, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 302318, 85, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0),
191(9, 29, 'Bundy_Giuffrida', 'April 12, 2018 17:28:43', '92.86.55.189', 256, -4311.35, -556.125, 14.931, 0, 0, 1, 1, '27/04/1979', 'USA', '', '', 4600, 14815, 7000, 98019, 'April 14, 2018 07:56:12', 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 387198, 79, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0);
192
193DROP TABLE IF EXISTS `criminal_record`;
194CREATE TABLE `criminal_record` (
195 `idx` int(11) NOT NULL AUTO_INCREMENT,
196 `player_name` varchar(32) NOT NULL,
197 `charge_reason` varchar(128) NOT NULL,
198 `add_date` varchar(90) NOT NULL,
199 PRIMARY KEY (`idx`)
200) ENGINE=InnoDB DEFAULT CHARSET=latin1;
201
202INSERT INTO `criminal_record` (`idx`, `player_name`, `charge_reason`, `add_date`) VALUES
203(12, 'Abram_Goraya', 'test', 'March 25, 2018 20:44:27'),
204(13, 'James_Corcoran', 'cretin', 'March 26, 2018 22:26:30'),
205(14, 'John_Cacarino', 'bou', 'March 27, 2018 16:09:57');
206
207DROP TABLE IF EXISTS `factions`;
208CREATE TABLE `factions` (
209 `DBID` int(11) NOT NULL AUTO_INCREMENT,
210 `FactionName` varchar(90) NOT NULL,
211 `FactionAbbrev` varchar(30) NOT NULL,
212 `FactionSpawnX` float NOT NULL,
213 `FactionSpawnY` float NOT NULL,
214 `FactionSpawnZ` float NOT NULL,
215 `FactionInterior` int(11) NOT NULL DEFAULT '0',
216 `FactionWorld` int(11) NOT NULL DEFAULT '0',
217 `FactionJoinRank` int(11) NOT NULL,
218 `FactionAlterRank` int(11) NOT NULL,
219 `FactionChatRank` int(11) NOT NULL,
220 `FactionTowRank` int(11) NOT NULL,
221 `FactionChatColor` int(11) NOT NULL,
222 `FactionType` tinyint(4) NOT NULL,
223 PRIMARY KEY (`DBID`)
224) ENGINE=InnoDB DEFAULT CHARSET=latin1;
225
226INSERT INTO `factions` (`DBID`, `FactionName`, `FactionAbbrev`, `FactionSpawnX`, `FactionSpawnY`, `FactionSpawnZ`, `FactionInterior`, `FactionWorld`, `FactionJoinRank`, `FactionAlterRank`, `FactionChatRank`, `FactionTowRank`, `FactionChatColor`, `FactionType`) VALUES
227(2, 'Liberty City Police Department', 'LCPD', 916.206, -225.69, 496.706, 0, 0, 0, 0, 0, 0, -1920073729, 2),
228(3, '', '´', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
229(4, 'Government of Liberty City', 'GOVT', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
230(5, 'PODMC', 'PODMC', 827.267, -128.713, 491.706, 0, 0, 1, 2, 1, 0, 1048575, 2),
231(6, 'Ì|', '|', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
232(7, 'Å’|', '|', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
233(8, 'ì|', '|', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
234
235DROP TABLE IF EXISTS `faction_ranks`;
236CREATE TABLE `faction_ranks` (
237 `factionid` int(11) NOT NULL AUTO_INCREMENT,
238 `FactionRank1` varchar(60) NOT NULL DEFAULT 'NotSet',
239 `FactionRank2` varchar(60) NOT NULL DEFAULT 'NotSet',
240 `FactionRank3` varchar(60) NOT NULL DEFAULT 'NotSet',
241 `FactionRank4` varchar(60) NOT NULL DEFAULT 'NotSet',
242 `FactionRank5` varchar(60) NOT NULL DEFAULT 'NotSet',
243 `FactionRank6` varchar(60) NOT NULL DEFAULT 'NotSet',
244 `FactionRank7` varchar(60) NOT NULL DEFAULT 'NotSet',
245 `FactionRank8` varchar(60) NOT NULL DEFAULT 'NotSet',
246 `FactionRank9` varchar(60) NOT NULL DEFAULT 'NotSet',
247 `FactionRank10` varchar(60) NOT NULL DEFAULT 'NotSet',
248 `FactionRank11` varchar(60) NOT NULL DEFAULT 'NotSet',
249 `FactionRank12` varchar(60) NOT NULL DEFAULT 'NotSet',
250 `FactionRank13` varchar(60) NOT NULL DEFAULT 'NotSet',
251 `FactionRank14` varchar(60) NOT NULL DEFAULT 'NotSet',
252 `FactionRank15` varchar(60) NOT NULL DEFAULT 'NotSet',
253 `FactionRank16` varchar(60) NOT NULL DEFAULT 'NotSet',
254 `FactionRank17` varchar(60) NOT NULL DEFAULT 'NotSet',
255 `FactionRank18` varchar(60) NOT NULL DEFAULT 'NotSet',
256 `FactionRank19` varchar(60) NOT NULL DEFAULT 'NotSet',
257 `FactionRank20` varchar(60) NOT NULL DEFAULT 'NotSet',
258 PRIMARY KEY (`factionid`),
259 UNIQUE KEY `factionid` (`factionid`)
260) ENGINE=InnoDB DEFAULT CHARSET=latin1;
261
262INSERT INTO `faction_ranks` (`factionid`, `FactionRank1`, `FactionRank2`, `FactionRank3`, `FactionRank4`, `FactionRank5`, `FactionRank6`, `FactionRank7`, `FactionRank8`, `FactionRank9`, `FactionRank10`, `FactionRank11`, `FactionRank12`, `FactionRank13`, `FactionRank14`, `FactionRank15`, `FactionRank16`, `FactionRank17`, `FactionRank18`, `FactionRank19`, `FactionRank20`) VALUES
263(2, 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet'),
264(3, 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet'),
265(4, 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet'),
266(5, 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet'),
267(6, 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet'),
268(7, 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet'),
269(8, 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet', 'NotSet');
270
271DROP TABLE IF EXISTS `kick_logs`;
272CREATE TABLE `kick_logs` (
273 `id` int(11) NOT NULL AUTO_INCREMENT,
274 `KickedDBID` int(11) NOT NULL,
275 `KickedName` varchar(32) NOT NULL,
276 `Reason` varchar(128) NOT NULL,
277 `KickedBy` varchar(32) NOT NULL,
278 `Date` varchar(90) NOT NULL,
279 PRIMARY KEY (`id`)
280) ENGINE=InnoDB DEFAULT CHARSET=latin1;
281
282INSERT INTO `kick_logs` (`id`, `KickedDBID`, `KickedName`, `Reason`, `KickedBy`, `Date`) VALUES
283(2, 1, 'James_Corcoran', 'faggot', 'Carmine_Giola', 'March 24, 2018 23:37:41'),
284(3, 6, 'Abram_Goraya', 'test', 'Abram_Goraya', 'March 25, 2018 06:25:31'),
285(4, 6, 'Abram_Goraya', '123', 'Abram_Goraya', 'March 25, 2018 06:28:47'),
286(5, 6, 'Abram_Goraya', '0000000', 'Abram_Goraya', 'March 29, 2018 22:14:03');
287
288DROP TABLE IF EXISTS `masters`;
289CREATE TABLE `masters` (
290 `acc_dbid` int(11) NOT NULL AUTO_INCREMENT,
291 `acc_name` varchar(32) NOT NULL,
292 `acc_pass` varchar(128) NOT NULL,
293 `secret_word` varchar(128) NOT NULL,
294 `forum_name` varchar(60) NOT NULL DEFAULT 'Null',
295 `register_date` varchar(90) NOT NULL,
296 `register_ip` varchar(60) NOT NULL,
297 `active_ip` varchar(60) NOT NULL,
298 `mAdmin` int(11) NOT NULL DEFAULT '0',
299 PRIMARY KEY (`acc_dbid`)
300) ENGINE=InnoDB DEFAULT CHARSET=latin1;
301
302INSERT INTO `masters` (`acc_dbid`, `acc_name`, `acc_pass`, `secret_word`, `forum_name`, `register_date`, `register_ip`, `active_ip`, `mAdmin`) VALUES
303(1, 'Psychological', '03bbf2281f09dc3261df76540bb354841bdbac8e', '7288edd0fc3ffcbe93a0cf06e3568e28521687bc', 'Psychological', 'March 24, 2018 19:34:30', '98.117.169.109', '98.117.169.109', 4),
304(2, 'taylor', 'cf0e42476a86c3224e44a785ca66fc2043502dd8', '3b0f06eedb577b2630562d40fad1e213238c7e04', 'taylor', 'March 24, 2018 19:48:03', '86.123.29.41', '86.123.29.41', 4),
305(4, 'Grandmaster', 'c6e2f87cd267e57abe33757a76ca1097ba62d648', '460b8dde3c375c9f9b87e3ab44ffce3fa1305744', 'Grandmaster', 'March 24, 2018 20:30:11', '82.47.119.100', '82.47.119.100', 4),
306(5, 'Ruskie', '4038f61cdab02496eb5809547a95c39bedd35156', '7f7efd585b108ee0ab15ab51dc50502ea9e17a55', 'Ruskie', 'March 24, 2018 22:06:24', '89.42.193.56', '89.42.193.56', 4),
307(6, 'george', '4038f61cdab02496eb5809547a95c39bedd35156', 'bf17e404dd90cd538b5bdd5cdc289c4d74238921', 'George', 'March 24, 2018 23:36:35', '188.129.163.74', '188.129.163.74', 4),
308(7, 'mattmocz', '27fdc1c5faecf6790b65c47a187324dcfd5d51c0', '71ab5a35551e8cf7db0f1c694353d2414946133c', 'mattmocz', 'March 25, 2018 00:35:26', '98.117.169.109', '98.117.169.109', 4),
309(8, 'Powerglide', 'f3f6793c6dc3b4a6a32dd14eb90f96ddea3c8209', '0f43e224015f47d20aa13a5fe2cfa54809cda982', 'Null', 'March 25, 2018 07:08:32', '75.157.15.54', '98.117.169.109', 4),
310(9, 'socrates', '4038f61cdab02496eb5809547a95c39bedd35156', '4038f61cdab02496eb5809547a95c39bedd35156', 'Null', 'March 25, 2018 07:25:03', '92.86.51.12', '92.86.51.144', 4),
311(12, 'fidel_gastro', 'ff5e68af433caf73f55dd4c9b1365155a07480f9', '80b2a219ba35f12e05ddab919e43200244f00584', 'Fidel Gastro', 'March 25, 2018 16:10:29', '93.85.145.144', '5.13.189.170', 4),
312(13, 'pelle', '39b4176895d52f71540c13b4167ceca619eeac15', '4038f61cdab02496eb5809547a95c39bedd35156', 'IlSanPellegrino', 'March 25, 2018 16:12:48', '178.117.233.10', '178.117.233.10', 4),
313(14, 'Bernard_Greene', 'ff5e68af433caf73f55dd4c9b1365155a07480f9', '80b2a219ba35f12e05ddab919e43200244f00584', 'Null', 'March 25, 2018 17:02:23', '93.85.145.144', '93.85.145.144', 4),
314(15, 'Massimo_Bonamici', '39b4176895d52f71540c13b4167ceca619eeac15', '4038f61cdab02496eb5809547a95c39bedd35156', 'Null', 'March 25, 2018 18:00:49', '178.117.233.10', '93.85.145.144', 4),
315(16, 'Pive', '8d04e01dd0c6a360e9bfa51409769ff68a2351b6', '8d04e01dd0c6a360e9bfa51409769ff68a2351b6', 'Null', 'March 25, 2018 22:33:50', '87.95.38.148', '87.95.38.148', 4),
316(17, 'Minion', '7c4a8d09ca3762af61e59520943dc26494f8941b', '7c4a8d09ca3762af61e59520943dc26494f8941b', 'Null', 'March 26, 2018 08:23:06', '64.180.13.70', '64.180.13.70', 4),
317(18, 'Anthony_Navarra', '6e5134e163bf280f41e9d871cb782fd8e1fce75b', '4b3e96ef5da36ea7e81f7ecf2e63a41f741f9522', 'Null', 'March 26, 2018 15:32:37', '94.15.55.11', '188.25.232.56', 4),
318(19, 'Philip_Rescigno', '84f4c8bb73f2ee7e30328bfadca2f5ab1a26bf5e', 'dabc9ac6ebbbaeb74fb6cdf3e9c19d8b9647f5ad', 'Duster', 'March 26, 2018 17:53:27', '213.168.10.81', '213.168.10.81', 4),
319(20, 'Charles_Ewing', '84f4c8bb73f2ee7e30328bfadca2f5ab1a26bf5e', 'dabc9ac6ebbbaeb74fb6cdf3e9c19d8b9647f5ad', 'Null', 'March 26, 2018 21:49:02', '213.168.10.81', '213.168.10.81', 4),
320(21, 'Riggs', '9e5bc9e1793134e284ec946a6ab5671c99fea3d1', '805688cb64d5b35072bc8fc370c8157896e9fbf1', 'Null', 'March 26, 2018 23:31:33', '46.10.220.4', '46.10.220.4', 4),
321(22, 'Sharkster', '4038f61cdab02496eb5809547a95c39bedd35156', '84f72cb42a1381a69cb9d0e977fa1153d913d0c7', 'Ruskie', 'March 27, 2018 13:23:01', '86.124.193.41', '188.25.156.70', 4),
322(23, 'John_Dempsey', '25c1962582e6fc165e240588eca04069c9a46ddd', 'c9799ec466ddbdba11337b3f7ff5598584196820', 'Jack', 'March 27, 2018 16:10:46', '67.82.190.49', '67.82.190.49', 4),
323(25, 'dogman', 'bd2211cd787fb741618cebc9c5532ff0888eced9', '9b821e97ef76f4e6443468023b62f1bdf8d370fe', 'dogman', 'March 27, 2018 22:18:19', '188.173.102.57', '188.173.102.57', 4),
324(27, 'Bane_Moltisanti', '524cdd5cbf79e72e173a4b7f2b5ec5883ceee513', '524cdd5cbf79e72e173a4b7f2b5ec5883ceee513', 'Null', 'March 28, 2018 20:02:52', '109.92.83.231', '109.92.83.231', 4),
325(28, 'Fabian', 'abdf1123faff29fa5c73a65dea9a5daf6533a183', '6df0be1b44a5693c2243526e55d63f791d986bda', 'Null', 'March 28, 2018 23:24:07', '176.252.129.217', '188.25.232.56', 4),
326(29, 'Peter_Brennan', '5371edeedaedde111073d1d2f2bfe778f4d76155', '556e9c1b52c174eb29ff6a15b90917a9a31e0d5f', 'Larry Doom', 'March 29, 2018 10:40:13', '122.151.148.235', '122.151.148.235', 4),
327(30, 'Steven_Cerza', '6e5134e163bf280f41e9d871cb782fd8e1fce75b', '4b3e96ef5da36ea7e81f7ecf2e63a41f741f9522', 'Null', 'March 29, 2018 21:17:33', '90.220.149.246', '188.25.232.56', 4),
328(31, 'Bader', '6e5134e163bf280f41e9d871cb782fd8e1fce75b', '4b3e96ef5da36ea7e81f7ecf2e63a41f741f9522', 'Null', 'March 29, 2018 21:25:13', '90.220.149.246', '90.220.149.246', 4),
329(32, 'Andrew_Charsew', '974c6fd19aa82b099c66ed7c16e62c61c5e14268', '974c6fd19aa82b099c66ed7c16e62c61c5e14268', 'Null', 'March 31, 2018 08:48:16', '5.13.189.170', '5.13.189.170', 4),
330(34, 'Webster', 'f7c3bc1d808e04732adf679965ccc34ca7ae3441', '201d12fe92cd19a910fb7160863736e09f1a7cb2', 'Webster', 'April 1, 2018 20:52:36', '31.5.216.16', '31.5.216.16', 4),
331(35, 'ASGOOD_Iulian', 'b41aab4813c9f0381a6ea8c98b8abaf5f80915f9', 'b41aab4813c9f0381a6ea8c98b8abaf5f80915f9', 'Null', 'April 1, 2018 21:06:47', '92.86.38.132', '92.86.38.132', 4);
332
333DROP TABLE IF EXISTS `properties`;
334CREATE TABLE `properties` (
335 `PropertyDBID` int(11) NOT NULL AUTO_INCREMENT,
336 `PropertyOwnerDBID` int(11) NOT NULL DEFAULT '0',
337 `PropertyType` int(11) NOT NULL,
338 `PropertyFaction` int(11) NOT NULL DEFAULT '0',
339 `PropertyEntranceX` float NOT NULL,
340 `PropertyEntranceY` float NOT NULL,
341 `PropertyEntranceZ` float NOT NULL,
342 `PropertyEntranceInterior` int(11) NOT NULL,
343 `PropertyEntranceWorld` int(11) NOT NULL,
344 `PropertyInteriorX` int(11) NOT NULL,
345 `PropertyInteriorY` int(11) NOT NULL,
346 `PropertyInteriorZ` int(11) NOT NULL,
347 `PropertyInteriorIntID` int(11) NOT NULL,
348 `PropertyInteriorWorld` int(11) NOT NULL,
349 `PropertyMarketPrice` int(11) NOT NULL DEFAULT '1000',
350 `PropertyLevel` int(11) NOT NULL DEFAULT '1',
351 `PropertyLocked` tinyint(1) NOT NULL DEFAULT '0',
352 `PropertyCashbox` int(11) NOT NULL DEFAULT '0',
353 `PropertyPlacePosX` float NOT NULL,
354 `PropertyPlacePosY` float NOT NULL,
355 `PropertyPlacePosZ` float NOT NULL,
356 `PropertyWeapon1` int(11) NOT NULL DEFAULT '0',
357 `PropertyWeapon2` int(11) NOT NULL DEFAULT '0',
358 `PropertyWeapon3` int(11) NOT NULL DEFAULT '0',
359 `PropertyWeapon4` int(11) NOT NULL DEFAULT '0',
360 `PropertyWeapon5` int(11) NOT NULL DEFAULT '0',
361 `PropertyWeapon6` int(11) NOT NULL DEFAULT '0',
362 `PropertyWeapon7` int(11) NOT NULL DEFAULT '0',
363 `PropertyWeapon8` int(11) NOT NULL DEFAULT '0',
364 `PropertyWeapon9` int(11) NOT NULL DEFAULT '0',
365 `PropertyWeapon10` int(11) NOT NULL DEFAULT '0',
366 `PropertyWeapon11` int(11) NOT NULL DEFAULT '0',
367 `PropertyWeapon12` int(11) NOT NULL DEFAULT '0',
368 `PropertyWeapon13` int(11) NOT NULL DEFAULT '0',
369 `PropertyWeapon14` int(11) NOT NULL DEFAULT '0',
370 `PropertyWeapon15` int(11) NOT NULL DEFAULT '0',
371 `PropertyWeapon16` int(11) NOT NULL DEFAULT '0',
372 `PropertyWeapon17` int(11) NOT NULL DEFAULT '0',
373 `PropertyWeapon18` int(11) NOT NULL DEFAULT '0',
374 `PropertyWeapon19` int(11) NOT NULL DEFAULT '0',
375 `PropertyWeapon20` int(11) NOT NULL DEFAULT '0',
376 `PropertyWeaponAmmo1` int(11) NOT NULL DEFAULT '0',
377 `PropertyWeaponAmmo2` int(11) NOT NULL DEFAULT '0',
378 `PropertyWeaponAmmo3` int(11) NOT NULL DEFAULT '0',
379 `PropertyWeaponAmmo4` int(11) NOT NULL DEFAULT '0',
380 `PropertyWeaponAmmo5` int(11) NOT NULL DEFAULT '0',
381 `PropertyWeaponAmmo6` int(11) NOT NULL DEFAULT '0',
382 `PropertyWeaponAmmo7` int(11) NOT NULL DEFAULT '0',
383 `PropertyWeaponAmmo8` int(11) NOT NULL DEFAULT '0',
384 `PropertyWeaponAmmo9` int(11) NOT NULL DEFAULT '0',
385 `PropertyWeaponAmmo10` int(11) NOT NULL DEFAULT '0',
386 `PropertyWeaponAmmo11` int(11) NOT NULL DEFAULT '0',
387 `PropertyWeaponAmmo12` int(11) NOT NULL DEFAULT '0',
388 `PropertyWeaponAmmo13` int(11) NOT NULL DEFAULT '0',
389 `PropertyWeaponAmmo14` int(11) NOT NULL DEFAULT '0',
390 `PropertyWeaponAmmo15` int(11) NOT NULL DEFAULT '0',
391 `PropertyWeaponAmmo16` int(11) NOT NULL DEFAULT '0',
392 `PropertyWeaponAmmo17` int(11) NOT NULL DEFAULT '0',
393 `PropertyWeaponAmmo18` int(11) NOT NULL DEFAULT '0',
394 `PropertyWeaponAmmo19` int(11) NOT NULL DEFAULT '0',
395 `PropertyWeaponAmmo20` int(11) NOT NULL DEFAULT '0',
396 `PropertyHasBoombox` tinyint(1) NOT NULL DEFAULT '0',
397 `PropertyBoomboxPosX` float NOT NULL,
398 `PropertyBoomboxPosY` float NOT NULL,
399 `PropertyBoomboxPosZ` float NOT NULL,
400 `PropertyBoomboxRotX` float NOT NULL,
401 `PropertyBoomboxRotY` float NOT NULL,
402 `PropertyBoomboxRotZ` float NOT NULL,
403 PRIMARY KEY (`PropertyDBID`)
404) ENGINE=InnoDB DEFAULT CHARSET=latin1;
405
406INSERT INTO `properties` (`PropertyDBID`, `PropertyOwnerDBID`, `PropertyType`, `PropertyFaction`, `PropertyEntranceX`, `PropertyEntranceY`, `PropertyEntranceZ`, `PropertyEntranceInterior`, `PropertyEntranceWorld`, `PropertyInteriorX`, `PropertyInteriorY`, `PropertyInteriorZ`, `PropertyInteriorIntID`, `PropertyInteriorWorld`, `PropertyMarketPrice`, `PropertyLevel`, `PropertyLocked`, `PropertyCashbox`, `PropertyPlacePosX`, `PropertyPlacePosY`, `PropertyPlacePosZ`, `PropertyWeapon1`, `PropertyWeapon2`, `PropertyWeapon3`, `PropertyWeapon4`, `PropertyWeapon5`, `PropertyWeapon6`, `PropertyWeapon7`, `PropertyWeapon8`, `PropertyWeapon9`, `PropertyWeapon10`, `PropertyWeapon11`, `PropertyWeapon12`, `PropertyWeapon13`, `PropertyWeapon14`, `PropertyWeapon15`, `PropertyWeapon16`, `PropertyWeapon17`, `PropertyWeapon18`, `PropertyWeapon19`, `PropertyWeapon20`, `PropertyWeaponAmmo1`, `PropertyWeaponAmmo2`, `PropertyWeaponAmmo3`, `PropertyWeaponAmmo4`, `PropertyWeaponAmmo5`, `PropertyWeaponAmmo6`, `PropertyWeaponAmmo7`, `PropertyWeaponAmmo8`, `PropertyWeaponAmmo9`, `PropertyWeaponAmmo10`, `PropertyWeaponAmmo11`, `PropertyWeaponAmmo12`, `PropertyWeaponAmmo13`, `PropertyWeaponAmmo14`, `PropertyWeaponAmmo15`, `PropertyWeaponAmmo16`, `PropertyWeaponAmmo17`, `PropertyWeaponAmmo18`, `PropertyWeaponAmmo19`, `PropertyWeaponAmmo20`, `PropertyHasBoombox`, `PropertyBoomboxPosX`, `PropertyBoomboxPosY`, `PropertyBoomboxPosZ`, `PropertyBoomboxRotX`, `PropertyBoomboxRotY`, `PropertyBoomboxRotZ`) VALUES
407(1, 6, 1, 0, 1689.63, -1494.67, 13.547, 0, 0, 1690, -1495, 14, 0, 31200, 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, 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, 0, 0),
408(2, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 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, 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, 0),
409(3, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1000, 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, 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, 0),
410(4, 4, 1, 0, 1165.2, 24.35, 515.134, 0, 0, 1524, -48, 1002, 2, 18744, 0, 0, 0, 0, 1526.44, -44.789, 1002.13, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
411(5, 4, 2, 0, 846.495, -239.621, 496.917, 0, 0, 2215, -1150, 1026, 15, 23008, 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, 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, 0, 0),
412(6, 4, 3, 0, 2228.26, -1150.19, 1025.8, 15, 23008, 2169, 1619, 1000, 1, 39621, 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, 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, 0, 0),
413(7, 0, 2, 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, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
414
415DROP TABLE IF EXISTS `vehicles`;
416CREATE TABLE `vehicles` (
417 `VehicleDBID` int(11) NOT NULL AUTO_INCREMENT,
418 `VehicleOwnerDBID` int(11) NOT NULL,
419 `VehicleFaction` int(11) NOT NULL DEFAULT '0',
420 `VehicleModel` int(11) NOT NULL,
421 `VehicleColor1` int(11) NOT NULL DEFAULT '0',
422 `VehicleColor2` int(11) NOT NULL DEFAULT '0',
423 `VehiclePaintjob` int(11) NOT NULL DEFAULT '-1',
424 `VehicleParkPosX` float NOT NULL,
425 `VehicleParkPosY` float NOT NULL,
426 `VehicleParkPosZ` float NOT NULL,
427 `VehicleParkPosA` float NOT NULL,
428 `VehicleParkInterior` int(11) NOT NULL DEFAULT '0',
429 `VehicleParkWorld` int(11) NOT NULL DEFAULT '0',
430 `VehiclePlates` varchar(32) NOT NULL,
431 `VehicleLocked` int(11) NOT NULL,
432 `VehicleImpounded` tinyint(1) NOT NULL DEFAULT '0',
433 `VehicleImpoundPosX` float NOT NULL,
434 `VehicleImpoundPosY` float NOT NULL,
435 `VehicleImpoundPosZ` float NOT NULL,
436 `VehicleImpoundPosA` float NOT NULL,
437 `VehicleSirens` int(11) NOT NULL DEFAULT '0',
438 `VehicleFuel` int(11) NOT NULL DEFAULT '100',
439 `VehicleWeapons1` int(11) NOT NULL DEFAULT '0',
440 `VehicleWeapons2` int(11) NOT NULL DEFAULT '0',
441 `VehicleWeapons3` int(11) NOT NULL DEFAULT '0',
442 `VehicleWeapons4` int(11) NOT NULL DEFAULT '0',
443 `VehicleWeapons5` int(11) NOT NULL DEFAULT '0',
444 `VehicleWeaponsAmmo1` int(11) NOT NULL DEFAULT '0',
445 `VehicleWeaponsAmmo2` int(11) NOT NULL DEFAULT '0',
446 `VehicleWeaponsAmmo3` int(11) NOT NULL DEFAULT '0',
447 `VehicleWeaponsAmmo4` int(11) NOT NULL DEFAULT '0',
448 `VehicleWeaponsAmmo5` int(11) NOT NULL DEFAULT '0',
449 `VehicleLastDrivers1` int(11) NOT NULL DEFAULT '0',
450 `VehicleLastDrivers2` int(11) NOT NULL DEFAULT '0',
451 `VehicleLastDrivers3` int(11) NOT NULL DEFAULT '0',
452 `VehicleLastDrivers4` int(11) NOT NULL DEFAULT '0',
453 `VehicleLastPassengers1` int(11) NOT NULL DEFAULT '0',
454 `VehicleLastPassengers2` int(11) NOT NULL DEFAULT '0',
455 `VehicleLastPassengers3` int(11) NOT NULL DEFAULT '0',
456 `VehicleLastPassengers4` int(11) NOT NULL DEFAULT '0',
457 `VehicleBattery` float NOT NULL DEFAULT '100',
458 `VehicleEngine` float NOT NULL DEFAULT '100',
459 `VehicleTimesDestroyed` int(11) NOT NULL DEFAULT '0',
460 `VehicleXMR` tinyint(1) NOT NULL DEFAULT '0',
461 `VehicleAlarmLevel` int(11) NOT NULL DEFAULT '0',
462 `VehicleLockLevel` int(11) NOT NULL DEFAULT '0',
463 `VehicleImmobLevel` int(11) NOT NULL DEFAULT '1',
464 PRIMARY KEY (`VehicleDBID`)
465) ENGINE=InnoDB DEFAULT CHARSET=latin1;
466
467INSERT INTO `vehicles` (`VehicleDBID`, `VehicleOwnerDBID`, `VehicleFaction`, `VehicleModel`, `VehicleColor1`, `VehicleColor2`, `VehiclePaintjob`, `VehicleParkPosX`, `VehicleParkPosY`, `VehicleParkPosZ`, `VehicleParkPosA`, `VehicleParkInterior`, `VehicleParkWorld`, `VehiclePlates`, `VehicleLocked`, `VehicleImpounded`, `VehicleImpoundPosX`, `VehicleImpoundPosY`, `VehicleImpoundPosZ`, `VehicleImpoundPosA`, `VehicleSirens`, `VehicleFuel`, `VehicleWeapons1`, `VehicleWeapons2`, `VehicleWeapons3`, `VehicleWeapons4`, `VehicleWeapons5`, `VehicleWeaponsAmmo1`, `VehicleWeaponsAmmo2`, `VehicleWeaponsAmmo3`, `VehicleWeaponsAmmo4`, `VehicleWeaponsAmmo5`, `VehicleLastDrivers1`, `VehicleLastDrivers2`, `VehicleLastDrivers3`, `VehicleLastDrivers4`, `VehicleLastPassengers1`, `VehicleLastPassengers2`, `VehicleLastPassengers3`, `VehicleLastPassengers4`, `VehicleBattery`, `VehicleEngine`, `VehicleTimesDestroyed`, `VehicleXMR`, `VehicleAlarmLevel`, `VehicleLockLevel`, `VehicleImmobLevel`) VALUES
468(5, 6, 0, 412, 5, 5, -1, 1345.32, -1752.88, 13.197, 181.064, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 100, 0, 0, 0, 0, 1),
469(9, 19, 0, 482, 0, 0, -1, 0, 0, 0, 0, 0, 0, '2WLT73', 0, 0, 0, 0, 0, 0, 0, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 100, 0, 0, 0, 0, 1),
470(10, 19, 1, 596, 0, 1, -1, 1705.42, -1485.91, 13.383, 87.51, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 100, 0, 0, 0, 0, 1),
471(12, 19, 0, 599, 0, 1, -1, 1705.42, -1485.91, 13.3828, 87.5097, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 100, 0, 0, 0, 0, 1),
472(13, 21, 0, 444, 0, 0, -1, 1705.42, -1485.91, 13.3828, 87.5097, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 100, 0, 0, 0, 0, 1),
473(14, 1, 0, 419, 0, 0, -1, 0, 0, 0, 0, 0, 0, '2FNI06', 0, 0, 0, 0, 0, 0, 0, 50, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 100, 0, 0, 0, 0, 1);
474
475DROP TABLE IF EXISTS `xmr_categories`;
476CREATE TABLE `xmr_categories` (
477 `XMRDBID` int(11) NOT NULL AUTO_INCREMENT,
478 `XMRCategoryName` varchar(90) NOT NULL,
479 PRIMARY KEY (`XMRDBID`)
480) ENGINE=InnoDB DEFAULT CHARSET=latin1;
481
482
483DROP TABLE IF EXISTS `xmr_stations`;
484CREATE TABLE `xmr_stations` (
485 `XMRStationDBID` int(11) NOT NULL AUTO_INCREMENT,
486 `XMRCategory` int(11) NOT NULL,
487 `XMRStationName` varchar(90) NOT NULL,
488 `XMRStationURL` varchar(128) NOT NULL,
489 PRIMARY KEY (`XMRStationDBID`)
490) ENGINE=InnoDB DEFAULT CHARSET=latin1;
491
492
493-- 2018-04-18 19:48:50