baubELTV

1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Apr 26, 2016 at 07:21 AM
7-- Server version: 5.6.17
8-- PHP Version: 5.5.12
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Database: `paneltenache`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `aplications`
27--
28
29CREATE TABLE IF NOT EXISTS `aplications` (
30  `id` int(11) NOT NULL AUTO_INCREMENT,
31  `name` varchar(50) NOT NULL,
32  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
33  `intrebarea1` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
34  `introducere` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
35  `status` int(69) NOT NULL DEFAULT '0',
36  `factionid` int(69) NOT NULL DEFAULT '0',
37  `intrebarea2` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
38  `intrebarea3` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
39  `intrebarea4` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
40  `intrebarea5` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
41  `intrebarea6` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
42  `Views` int(11) NOT NULL DEFAULT '0',
43  PRIMARY KEY (`id`)
44) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
45
46--
47-- Dumping data for table `aplications`
48--
49
50INSERT INTO `aplications` (`id`, `name`, `time`, `intrebarea1`, `introducere`, `status`, `factionid`, `intrebarea2`, `intrebarea3`, `intrebarea4`, `intrebarea5`, `intrebarea6`, `Views`) VALUES
51(1, 'Hurdock', '2016-04-13 10:52:18', '123', '<p>123</p>', 0, 0, '123', '123', '132', '123', '123', 0),
52(3, 'Hurdock', '2016-04-13 10:53:54', '123', '<p>12312</p>', 2, 1, '3123123', '123123', '123123', '12312321', '312', 0),
53(4, 'Hurdock', '2016-04-13 10:54:09', '123', '<p>123</p>', 2, 1, '213', '1313', '13131', '23123132', '132123', 0),
54(5, 'Hurdock', '2016-04-13 10:54:20', '131', '<p>123123</p>', 2, 1, '3131', '13131', '12313', '123123', '123', 0),
55(6, 'Hurdock', '2016-04-13 11:20:29', 'Varsta', '<p>Introducere</p>', 2, 1, '13 ore', 'Da sunt de acord sa stau 14 zile', 'Nu, n-am mafost', 'Imi place', 'Nu am alte precizari', 0);
56
57-- --------------------------------------------------------
58
59--
60-- Table structure for table `bans`
61--
62
63CREATE TABLE IF NOT EXISTS `bans` (
64  `ID` int(11) NOT NULL AUTO_INCREMENT,
65  `PlayerName` varchar(30) NOT NULL,
66  `AdminName` varchar(30) NOT NULL,
67  `Reason` varchar(128) NOT NULL,
68  `IP` varchar(16) NOT NULL,
69  `Days` int(11) NOT NULL,
70  `IPBan` int(11) NOT NULL,
71  `Permanent` int(11) NOT NULL,
72  `Time` int(15) NOT NULL,
73  `BanTimeDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
74  `Active` int(11) NOT NULL,
75  PRIMARY KEY (`ID`)
76) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
77
78--
79-- Dumping data for table `bans`
80--
81
82INSERT INTO `bans` (`ID`, `PlayerName`, `AdminName`, `Reason`, `IP`, `Days`, `IPBan`, `Permanent`, `Time`, `BanTimeDate`, `Active`) VALUES
83(1, 'Hurdock', 'test', '123', '', 0, 0, 0, 0, '2016-04-15 23:42:36', 1);
84
85-- --------------------------------------------------------
86
87--
88-- Table structure for table `bizz`
89--
90
91CREATE TABLE IF NOT EXISTS `bizz` (
92  `ID` int(11) NOT NULL AUTO_INCREMENT,
93  `Owned` int(2) NOT NULL,
94  `Owner` varchar(25) NOT NULL DEFAULT 'The State',
95  `Message` varchar(50) NOT NULL,
96  `EntranceX` float NOT NULL,
97  `EntranceY` float NOT NULL,
98  `EntranceZ` float NOT NULL,
99  `ExitX` float NOT NULL,
100  `ExitY` float NOT NULL,
101  `ExitZ` float NOT NULL,
102  `LevelNeeded` int(11) NOT NULL DEFAULT '15',
103  `BuyPrice` int(11) NOT NULL DEFAULT '20000000',
104  `EntranceCost` int(11) NOT NULL DEFAULT '5',
105  `Till` int(11) NOT NULL,
106  `Sbiz` int(2) NOT NULL,
107  `Type` int(3) NOT NULL,
108  `Locked` int(11) NOT NULL,
109  `Interior` int(11) NOT NULL,
110  `Virtual` int(11) NOT NULL,
111  PRIMARY KEY (`ID`)
112) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=55 ;
113
114--
115-- Dumping data for table `bizz`
116--
117
118INSERT INTO `bizz` (`ID`, `Owned`, `Owner`, `Message`, `EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `EntranceCost`, `Till`, `Sbiz`, `Type`, `Locked`, `Interior`, `Virtual`) VALUES
119(1, 0, 'The State', 'Banca LS', 1462.49, -1012.63, 26.8438, 2306, -16, 27, 15, 20000000, 500, 0, 0, 1, 0, 0, 0),
120(2, 0, 'The State', 'Gun Shop LS', 1367.99, -1279.75, 13.5469, 316, -142, 1000, 15, 20000000, 500, 0, 0, 2, 0, 7, 0),
121(3, 0, 'The State', 'Alhambra', 1836.09, -1682.5, 13.3624, 493.46, -24.0736, 1000.68, 15, 20000000, 500, 0, 0, 3, 0, 17, 0),
122(4, 0, 'The State', 'Cluckin Bell', 2102.38, 2228.72, 11.0234, 364.942, -11.0787, 1001.85, 15, 20000000, 500, 0, 0, 14, 0, 9, 0),
123(5, 0, 'The State', 'Bar ', 2421.41, -1220.3, 25.4937, 1204.83, -13.4011, 1000.92, 15, 20000000, 500, 0, 0, 3, 0, 2, 0),
124(6, 0, 'The State', 'CLUB ', 2309.85, -1643.54, 14.827, -794.942, 490.782, 1376.2, 15, 20000000, 500, 0, 0, 3, 0, 1, 0),
125(7, 0, 'The State', 'Sex Shop', 1087.63, -923.003, 43.3906, -100.403, -24.3921, 1000.72, 15, 20000000, 500, 0, 0, 4, 0, 3, 0),
126(8, 0, 'The State', 'Casino LV', 2019.6, 1007.68, 10.8203, 2015.45, 1017.09, 996.875, 15, 20000000, 500, 0, 0, 5, 0, 10, 1),
127(9, 0, 'The State', 'GunShop LS', 1791.71, -1163.6, 23.8281, 316, -142, 1000, 15, 20000000, 500, 0, 0, 2, 0, 7, 1),
128(10, 0, 'The State', '24/7', 1352.16, -1759.17, 13.5078, -31.0246, -91.3283, 1003.55, 15, 20000000, 500, 0, 0, 6, 0, 18, 0),
129(11, 0, 'The State', '24/7', 999.932, -919.889, 42.3281, -31.0246, -91.3283, 1003.55, 15, 20000000, 500, 0, 0, 6, 0, 18, 1),
130(12, 0, 'The State', '24/7', 1833.14, -1842.5, 13.5781, -31.0246, -91.3283, 1003.55, 15, 20000000, 500, 0, 0, 6, 0, 18, 2),
131(13, 0, 'The State', '24/7', 1929.37, -1776.14, 13.5469, -31.0246, -91.3283, 1003.55, 15, 20000000, 500, 0, 0, 6, 0, 18, 3),
132(14, 0, 'The State', '24/7', 1315.7, -898.097, 39.5781, -31.0246, -91.3283, 1003.55, 15, 20000000, 500, 0, 0, 6, 0, 18, 4),
133(15, 0, 'The State', 'Burger Shot', 1199.38, -919.098, 43.1152, 363.134, -74.8469, 1001.51, 15, 20000000, 500, 0, 0, 7, 0, 10, 0),
134(16, 0, 'The State', 'Burger Shot', 810.737, -1616.19, 13.5469, 363.134, -74.8469, 1001.51, 15, 20000000, 500, 0, 0, 7, 0, 10, 1),
135(17, 0, 'The State', 'Burger Shot', 2472.79, 2034.26, 11.0625, 363.134, -74.8469, 1001.51, 15, 20000000, 500, 0, 0, 7, 0, 10, 2),
136(18, 0, 'The State', 'Burger Shot', 1158.14, 2072.27, 11.0625, 363.134, -74.8469, 1001.51, 15, 20000000, 500, 0, 0, 7, 0, 10, 3),
137(19, 0, 'The State', 'Burger Shot', 2170.06, 2795.64, 10.8203, 363.134, -74.8469, 1001.51, 15, 20000000, 500, 0, 0, 7, 0, 10, 4),
138(20, 0, 'The State', 'Burger Shot', 1872.71, 2071.67, 11.0625, 363.134, -74.8469, 1001.51, 15, 20000000, 500, 0, 0, 7, 0, 10, 5),
139(21, 0, 'The State', 'Banca LV', 2194.99, 1676.89, 12.3672, 2306, -16, 27, 15, 20000000, 500, 0, 0, 1, 0, 0, 1),
140(22, 0, 'The State', 'GunShop LV', 2556.62, 2063.98, 11.0995, 316, -142, 1000, 15, 20000000, 500, 0, 0, 2, 0, 7, 2),
141(23, 0, 'The State', 'Sex Shop LV', 2515.95, 2297.69, 10.8203, -100.403, -24.3921, 1000.72, 15, 20000000, 500, 0, 0, 4, 0, 3, 1),
142(24, 0, 'The State', '24/7', 2637.61, 1129.28, 11.1797, -31.0246, -91.3283, 1003.55, 15, 20000000, 500, 0, 0, 6, 0, 18, 5),
143(25, 0, 'The State', 'Gym LS', 2229.22, -1721.89, 13.5671, 772.112, -3.89865, 1000.73, 15, 20000000, 500, 0, 0, 8, 0, 5, 0),
144(26, 0, 'The State', 'Pizza', 2104.57, -1806.67, 13.5547, 372.54, -133.009, 1001.49, 15, 20000000, 500, 0, 0, 9, 0, 5, 6),
145(27, 0, 'The State', 'Banca LS', 1102.91, -1440.13, 15.7969, 2306, -16, 27, 15, 20000000, 500, 0, 0, 1, 0, 0, 2),
146(28, 0, 'The State', 'Tasteaza [/ad] LvL 5', 1168.43, -1489.36, 22.757, 0, 0, 0, 15, 20000000, 500, 0, 1, 15, 1, 0, 0),
147(29, 0, 'The State', 'Binco', 2102.56, 2257.37, 11.0234, 207.738, -109.02, 1005.13, 15, 20000000, 500, 0, 0, 11, 0, 15, 2),
148(30, 0, 'The State', 'Zip', 499.936, -1359.74, 16.2911, 161.391, -93.1592, 1001.8, 15, 20000000, 500, 0, 0, 11, 0, 18, 0),
149(31, 0, 'The State', 'Rent Car', 563.145, -1289.79, 17.2482, 0, 0, 0, 15, 20000000, 500, 0, 1, 10, 1, 0, 0),
150(32, 0, 'The State', 'Zip', 1456.98, -1138.04, 23.9778, 161.391, -93.1592, 1001.8, 15, 20000000, 500, 0, 0, 11, 0, 18, 1),
151(33, 0, 'The State', 'Gas Station', 1941.6, -1764.74, 13.6406, 0, 0, 0, 15, 20000000, 500, 0, 1, 12, 1, 0, 0),
152(34, 0, 'The State', 'PNS', 723.409, -463.627, 16.3359, 0, 0, 0, 15, 20000000, 500, 0, 1, 13, 1, 0, 0),
153(35, 0, 'The State', 'PNS', 2072.57, -1828.03, 13.5469, 0, 0, 0, 15, 20000000, 500, 0, 1, 13, 1, 0, 0),
154(36, 0, 'The State', 'PNS', 1034.7, -1028.1, 32.1016, 0, 0, 0, 15, 20000000, 500, 0, 1, 13, 1, 0, 0),
155(37, 0, 'The State', 'PNS', 485.37, -1733.32, 11.094, 0, 0, 0, 15, 20000000, 500, 0, 1, 13, 1, 0, 0),
156(38, 0, 'The State', 'Mod Shop', 1037.11, -1025.04, 32.1016, 0, 0, 0, 15, 20000000, 500, 0, 1, 16, 1, 0, 0),
157(39, 0, 'The State', 'Mod Shop', 2650.33, -2021.76, 14.1766, 0, 0, 0, 15, 20000000, 500, 0, 1, 16, 1, 0, 0),
158(40, 0, 'The State', 'PNS', 1966.45, 2156.36, 10.8203, 0, 0, 0, 15, 20000000, 500, 0, 1, 13, 1, 0, 0),
159(41, 0, 'The State', 'PNS', -94.1097, 1109.86, 19.7422, 0, 0, 0, 15, 20000000, 500, 0, 1, 13, 1, 0, 0),
160(42, 0, 'The State', 'Gas Station', 1012.9, -935.545, 42.1797, 0, 0, 0, 15, 20000000, 500, 0, 1, 12, 1, 0, 0),
161(43, 0, 'The State', 'Gas Station', 701.554, -567.347, 16.1459, 0, 0, 0, 15, 20000000, 500, 0, 1, 12, 1, 0, 0),
162(44, 0, 'The State', 'Gas Station', -78.6301, -1169.16, 2.1491, 0, 0, 0, 15, 20000000, 500, 0, 1, 12, 1, 0, 0),
163(45, 0, 'The State', 'Gas Station', 2646.33, 1101.31, 10.9609, 0, 0, 0, 15, 20000000, 500, 0, 1, 12, 1, 0, 0),
164(46, 0, 'The State', 'Gas Station', 2139.81, 2753.5, 10.8203, 0, 0, 0, 15, 20000000, 500, 0, 1, 12, 1, 0, 0),
165(47, 0, 'The State', 'Gas Station', 2207.51, 2482.56, 10.8203, 0, 0, 0, 15, 20000000, 500, 0, 1, 12, 1, 0, 0),
166(48, 0, 'The State', 'Gas Station', 1604.09, 2204.47, 10.8203, 0, 0, 0, 15, 20000000, 500, 0, 1, 12, 1, 0, 0),
167(49, 0, 'The State', 'Gas Station', 2122.56, 914.539, 10.8203, 0, 0, 0, 15, 20000000, 500, 0, 1, 12, 1, 0, 0),
168(50, 0, 'The State', 'Gas Station', 638.368, 1683.78, 7.1875, 0, 0, 0, 15, 20000000, 500, 0, 1, 12, 1, 0, 0),
169(51, 0, 'The State', 'Mod Shop', 2392.17, 1042.01, 10.8203, 0, 0, 0, 15, 20000000, 500, 0, 1, 16, 1, 0, 0),
170(52, 0, 'The State', 'CNN LV', 2079.2, 2045.07, 11.0579, 0, 0, 0, 15, 20000000, 500, 0, 1, 15, 0, 0, 0),
171(53, 0, 'The State', 'Binco', 2244.38, -1665.16, 15.4766, 207.738, -109.02, 1005.13, 15, 20000000, 500, 0, 0, 11, 0, 15, 1),
172(54, 0, 'The State', 'Cluckin Bell', 172.527, 1176.09, 14.7645, 364.942, -11.0787, 1001.85, 15, 20000000, 500, 0, 0, 14, 0, 9, 1);
173
174-- --------------------------------------------------------
175
176--
177-- Table structure for table `cars`
178--
179
180CREATE TABLE IF NOT EXISTS `cars` (
181  `ID` int(11) NOT NULL AUTO_INCREMENT,
182  `Model` int(11) NOT NULL,
183  `Locationx` float NOT NULL,
184  `Locationy` float NOT NULL,
185  `Locationz` float NOT NULL,
186  `Angle` float NOT NULL,
187  `ColorOne` int(11) NOT NULL,
188  `ColorTwo` int(11) NOT NULL,
189  `Owner` varchar(25) NOT NULL DEFAULT 'Dealership',
190  `Value` int(20) NOT NULL,
191  `License` varchar(14) NOT NULL DEFAULT 'NewCar',
192  `Description` varchar(50) NOT NULL,
193  `Lockk` int(3) NOT NULL,
194  `Timed` int(11) NOT NULL,
195  `Inscarprice` int(11) NOT NULL,
196  `Insurancecar` int(11) NOT NULL,
197  `KM` float NOT NULL,
198  `HP` float NOT NULL DEFAULT '1000',
199  `Gas` int(3) NOT NULL DEFAULT '100',
200  `Damage1` int(11) NOT NULL DEFAULT '0',
201  `Damage2` int(11) NOT NULL DEFAULT '0',
202  `Damage3` int(11) NOT NULL DEFAULT '0',
203  `Damage4` int(11) NOT NULL DEFAULT '0',
204  `Owned` int(11) NOT NULL,
205  `Spawned` int(11) NOT NULL,
206  `Sell` int(11) NOT NULL,
207  `mod1` int(24) NOT NULL,
208  `mod2` int(24) NOT NULL,
209  `mod3` int(24) NOT NULL,
210  `mod4` int(24) NOT NULL,
211  `mod5` int(24) NOT NULL,
212  `mod6` int(24) NOT NULL,
213  `mod7` int(24) NOT NULL,
214  `mod8` int(24) NOT NULL,
215  `mod9` int(24) NOT NULL,
216  `mod10` int(24) NOT NULL,
217  `mod11` int(24) NOT NULL,
218  `mod12` int(24) NOT NULL,
219  `mod13` int(24) NOT NULL,
220  `mod14` int(24) NOT NULL,
221  `mod15` int(24) NOT NULL,
222  `mod16` int(24) NOT NULL,
223  `mod17` int(24) NOT NULL,
224  `PaintJ` int(24) NOT NULL DEFAULT '6',
225  `days` int(11) NOT NULL DEFAULT '0',
226  `CarHP` int(11) NOT NULL DEFAULT '1000',
227  `CarFuel` int(11) NOT NULL DEFAULT '100',
228  PRIMARY KEY (`ID`)
229) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
230
231--
232-- Dumping data for table `cars`
233--
234
235INSERT INTO `cars` (`ID`, `Model`, `Locationx`, `Locationy`, `Locationz`, `Angle`, `ColorOne`, `ColorTwo`, `Owner`, `Value`, `License`, `Description`, `Lockk`, `Timed`, `Inscarprice`, `Insurancecar`, `KM`, `HP`, `Gas`, `Damage1`, `Damage2`, `Damage3`, `Damage4`, `Owned`, `Spawned`, `Sell`, `mod1`, `mod2`, `mod3`, `mod4`, `mod5`, `mod6`, `mod7`, `mod8`, `mod9`, `mod10`, `mod11`, `mod12`, `mod13`, `mod14`, `mod15`, `mod16`, `mod17`, `PaintJ`, `days`, `CarHP`, `CarFuel`) VALUES
236(1, 522, 0, 0, 0, 0, 3, 3, 'Hurdock', 3232, 'NewCar', '', 0, 0, 0, 0, 0, 1000, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 4324432, 1000, 100);
237
238-- --------------------------------------------------------
239
240--
241-- Table structure for table `changemail`
242--
243
244CREATE TABLE IF NOT EXISTS `changemail` (
245  `ChangeMailKey` varchar(255) NOT NULL DEFAULT '',
246  `name` varchar(255) DEFAULT NULL,
247  `email` varchar(255) DEFAULT NULL,
248  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
249  PRIMARY KEY (`ChangeMailKey`)
250) ENGINE=MyISAM DEFAULT CHARSET=latin1;
251
252-- --------------------------------------------------------
253
254--
255-- Table structure for table `chat_logs`
256--
257
258CREATE TABLE IF NOT EXISTS `chat_logs` (
259  `ID` int(11) NOT NULL AUTO_INCREMENT,
260  `playerid` int(11) NOT NULL,
261  `text` varchar(128) NOT NULL,
262  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
263  PRIMARY KEY (`ID`)
264) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
265
266-- --------------------------------------------------------
267
268--
269-- Table structure for table `clans`
270--
271
272CREATE TABLE IF NOT EXISTS `clans` (
273  `clanID` int(12) NOT NULL AUTO_INCREMENT,
274  `clanName` varchar(255) NOT NULL,
275  `clanMOTD` varchar(128) NOT NULL,
276  `clanTag` varchar(255) NOT NULL DEFAULT '[NONE]',
277  `clanRankName7` varchar(32) NOT NULL DEFAULT 'Owner',
278  `clanRankName1` varchar(32) NOT NULL DEFAULT 'Newbie',
279  `clanRankName2` varchar(32) NOT NULL DEFAULT 'Member',
280  `clanRankName3` varchar(32) NOT NULL DEFAULT 'Advanced',
281  `clanRankName4` varchar(32) NOT NULL DEFAULT 'Expert',
282  `clanRankName5` varchar(32) NOT NULL DEFAULT 'Legend',
283  `clanRankName6` varchar(32) NOT NULL DEFAULT 'Manager',
284  `clanSlots` int(11) NOT NULL DEFAULT '15',
285  `clanExpire` int(11) NOT NULL,
286  `clanActive` int(11) NOT NULL DEFAULT '1',
287  `clanColor` varchar(10) NOT NULL DEFAULT 'FFCC99',
288  `clanDescription` text NOT NULL,
289  `clanForum` varchar(50) NOT NULL,
290  PRIMARY KEY (`clanID`)
291) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
292
293-- --------------------------------------------------------
294
295--
296-- Table structure for table `clan_logs`
297--
298
299CREATE TABLE IF NOT EXISTS `clan_logs` (
300  `id` int(11) NOT NULL AUTO_INCREMENT,
301  `clanid` int(11) NOT NULL,
302  `action` varchar(128) NOT NULL,
303  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
304  PRIMARY KEY (`id`)
305) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
306
307-- --------------------------------------------------------
308
309--
310-- Table structure for table `complaints`
311--
312
313CREATE TABLE IF NOT EXISTS `complaints` (
314  `id` int(11) NOT NULL AUTO_INCREMENT,
315  `createdby` varchar(30) NOT NULL,
316  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
317  `status` int(11) NOT NULL,
318  `reason` varchar(25) CHARACTER SET utf8 COLLATE utf8_romanian_ci NOT NULL,
319  `evidence` text CHARACTER SET utf8 COLLATE utf8_romanian_ci NOT NULL,
320  `details` text CHARACTER SET utf8 COLLATE utf8_romanian_ci NOT NULL,
321  `ip` varchar(20) NOT NULL,
322  `against` text NOT NULL,
323  `Views` int(11) NOT NULL,
324  PRIMARY KEY (`id`)
325) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ;
326
327--
328-- Dumping data for table `complaints`
329--
330
331INSERT INTO `complaints` (`id`, `createdby`, `time`, `status`, `reason`, `evidence`, `details`, `ip`, `against`, `Views`) VALUES
332(1, 'Hurdock', '2016-04-12 08:47:32', 1, '1', 'continut', 'qwe', '12', 'Hurdock', 0),
333(4, 'Hurdock', '2016-04-12 12:00:02', 1, 'DM SPAWN', 'Aici', '<p>da</p>', '', 'Hurdock', 1),
334(8, 'Hurdock', '2016-04-12 12:21:01', 1, 'asa', '123', '<p>123</p>', '', 'Hurdock', 1),
335(15, 'Hurdock', '2016-04-13 00:26:19', 0, 'Deathmach Spawn', 'www.youtube.com', '<p>Sper sa luati masuri!</p>', '', 'Hurdock', 11),
336(17, 'Hurdock', '2016-04-13 08:28:38', 0, 'as', 'da', '<p>qwe</p>', '', 'Hurdock', 57),
337(18, 'Hurdock2', '2016-04-13 11:45:34', 0, 'Deathmatch', 'www.imgur.com', '<div class="bootstrap-tabs" data-tab-set-title="Dovada"><ul class="nav nav-tabs" role="tablist"><!-- add tabs here --><li role="presentation"><a class="tab-link" href="#dovada-tab-1" aria-controls="dovada-tab-1" role="tab" data-toggle="tab">Dovada1</a></li><li role="presentation" class="active"><a class="tab-link" href="#dovada-tab-2" aria-controls="dovada-tab-2" role="tab" data-toggle="tab">Dovada2</a></li></ul><div class="tab-content"><!-- add tab panels here --><div role="tabpanel" class="tab-pane" id="dovada-tab-1"><div class="tab-pane-content">Tab 1 Content</div></div><div role="tabpanel" class="tab-pane active" id="dovada-tab-2"><div class="tab-pane-content">Tab 2 Content</div><div class="tab-pane-content">&nbsp;</div><ul><li class="tab-pane-content">Aranjament frumos.</li><li class="tab-pane-content">Aranjament atractiv.</li></ul></div></div></div><p>&nbsp;</p>', '', 'Hurdock', 33),
338(19, 'Hurdock2', '2016-04-15 23:34:42', 0, 'Face DM la Spawn', 'www.imgur.com blal', '<p>Traversam linistit si dintr-o data m-a lovit acest jucator, vreau admin 1338.</p>', '', 'Hurdock', 2);
339
340-- --------------------------------------------------------
341
342--
343-- Table structure for table `complaintsanswers`
344--
345
346CREATE TABLE IF NOT EXISTS `complaintsanswers` (
347  `idcomplain` int(11) NOT NULL,
348  `creator` text NOT NULL,
349  `mesaj` text CHARACTER SET utf8 COLLATE utf8_romanian_ci NOT NULL,
350  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
351) ENGINE=InnoDB DEFAULT CHARSET=latin1;
352
353--
354-- Dumping data for table `complaintsanswers`
355--
356
357INSERT INTO `complaintsanswers` (`idcomplain`, `creator`, `mesaj`, `time`) VALUES
358(1, 'Hurdock', '<p>Acesta este un raspuns.</p>', '2016-04-12 11:13:26'),
359(1, 'Hurdock', '<ul><li>da</li><li>da</li><li>da</li><li>nu</li></ul>', '2016-04-12 11:24:13'),
360(15, 'Hurdock', '<p>ets</p>', '2016-04-13 00:53:07'),
361(17, 'Hurdock', '<p>qw<span style="font-size:9px">qweqwewqe</span></p>', '2016-04-13 08:37:36'),
362(17, 'Hurdock', '<p>qweqweqwewqe</p>', '2016-04-13 08:37:42'),
363(17, 'Hurdock', '<p>qwe</p>', '2016-04-13 08:39:20'),
364(17, 'Hurdock', '<p>daw</p>', '2016-04-13 08:40:34'),
365(17, 'Hurdock', '<p>test</p>', '2016-04-13 08:41:54'),
366(17, 'Hurdock', '<p>test</p>', '2016-04-13 08:43:02'),
367(17, 'Hurdock', '<p>qwe</p>', '2016-04-13 08:43:12'),
368(17, 'Hurdock', '<p>qwe</p>', '2016-04-13 08:43:22'),
369(17, 'Hurdock', '<p>qwe</p>', '2016-04-13 08:43:27'),
370(17, 'Hurdock', '<p>qwe</p>', '2016-04-13 08:44:11'),
371(17, 'Hurdock', '<p>qwe</p>', '2016-04-13 08:46:12'),
372(17, 'Hurdock', '<p>qwe</p>', '2016-04-13 08:46:42'),
373(17, 'Hurdock', '<p>qwe</p>', '2016-04-13 08:46:53'),
374(17, 'Hurdock', '<p>test</p>', '2016-04-13 08:48:12'),
375(17, 'Hurdock', '<p>test</p>', '2016-04-13 08:59:45'),
376(18, 'Hurdock2', '<p>Vreau sa ii dati ban!</p>', '2016-04-13 11:47:44'),
377(18, 'Hurdock', '<p>Vom vedea.</p>', '2016-04-13 11:48:42'),
378(18, 'Hurdock', '<p>Jucatorul se exprima mult mai frumos cu ajutorul acestui editor, pe celalte panele o sa vezi doar o casuta, aici ai si optiuni exemplu:</p><ul><li>randu 1</li><li>randu 2</li></ul><p>fara bold&nbsp;<strong>cu bold</strong></p><blockquote><p>Blabla</p></blockquote>', '2016-04-15 23:24:40'),
379(18, 'Hurdock', '<p>Admin&nbsp;<strong>Ma-ta</strong>&nbsp;muted&nbsp;<strong>Gheorghe</strong>&nbsp;for 30 minutes.</p><p>Blabla.</p><p>Poate e doar text?</p>', '2016-04-15 23:27:47'),
380(18, '', 'Acest jucator a primit <b>Warning</b> in urma acestei reclamatii.', '2016-04-15 23:31:17'),
381(18, '', 'Acest jucator a primit <b>Warning</b> in urma acestei reclamatii.', '2016-04-15 23:32:13'),
382(18, '', 'Acest jucator a primit Waring in urma acestei reclamatii.', '2016-04-15 23:32:46'),
383(18, '', 'Acest jucator a primit Waring in urma acestei reclamatii.', '2016-04-15 23:32:49'),
384(18, 'Hurdock', 'Acest jucator a primit <b>Warn</b> in urma acestei reclamatii.', '2016-04-15 23:33:18');
385
386-- --------------------------------------------------------
387
388--
389-- Table structure for table `donations`
390--
391
392CREATE TABLE IF NOT EXISTS `donations` (
393  `donateID` int(11) NOT NULL AUTO_INCREMENT,
394  `donateName` varchar(30) NOT NULL,
395  `donatePIN` varchar(19) NOT NULL,
396  `donateSUM` varchar(3) NOT NULL,
397  `donateStatus` int(11) NOT NULL,
398  `donateTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
399  `donateAdminAction` text NOT NULL,
400  PRIMARY KEY (`donateID`)
401) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
402
403-- --------------------------------------------------------
404
405--
406-- Table structure for table `emails`
407--
408
409CREATE TABLE IF NOT EXISTS `emails` (
410  `ID` int(11) NOT NULL AUTO_INCREMENT,
411  `playerid` int(11) NOT NULL,
412  `giverid` int(11) NOT NULL,
413  `Message` varchar(500) NOT NULL,
414  `EmailRead` int(11) NOT NULL DEFAULT '1',
415  `LinkPanel` text NOT NULL,
416  `Time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
417  PRIMARY KEY (`ID`)
418) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
419
420-- --------------------------------------------------------
421
422--
423-- Table structure for table `factionlist`
424--
425
426CREATE TABLE IF NOT EXISTS `factionlist` (
427  `id` int(11) NOT NULL AUTO_INCREMENT,
428  `Nume` text NOT NULL,
429  `Aplicatii` int(11) DEFAULT '0',
430  `Level` int(11) NOT NULL DEFAULT '3',
431  `LimitaMembrii` int(11) NOT NULL,
432  PRIMARY KEY (`id`)
433) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
434
435--
436-- Dumping data for table `factionlist`
437--
438
439INSERT INTO `factionlist` (`id`, `Nume`, `Aplicatii`, `Level`, `LimitaMembrii`) VALUES
440(1, 'Los Santos Police Department', 1, 4, 21);
441
442-- --------------------------------------------------------
443
444--
445-- Table structure for table `factionlog`
446--
447
448CREATE TABLE IF NOT EXISTS `factionlog` (
449  `ID` int(11) NOT NULL AUTO_INCREMENT,
450  `factionid` int(11) NOT NULL,
451  `player` varchar(64) NOT NULL,
452  `leader` int(11) NOT NULL,
453  `action` varchar(64) NOT NULL,
454  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
455  PRIMARY KEY (`ID`)
456) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
457
458-- --------------------------------------------------------
459
460--
461-- Table structure for table `factions`
462--
463
464CREATE TABLE IF NOT EXISTS `factions` (
465  `ID` int(11) NOT NULL AUTO_INCREMENT,
466  `Name` varchar(50) NOT NULL,
467  `X` float NOT NULL,
468  `Y` float NOT NULL,
469  `Z` float NOT NULL,
470  `Mats` int(11) NOT NULL,
471  `Drugs` int(11) NOT NULL,
472  `Bank` int(11) NOT NULL,
473  `Anunt` varchar(128) NOT NULL,
474  `Win` int(11) NOT NULL DEFAULT '0',
475  `Lost` int(11) NOT NULL DEFAULT '0',
476  `MaxMembers` int(11) NOT NULL DEFAULT '10',
477  `MinLevel` int(3) NOT NULL DEFAULT '5',
478  `Application` int(11) NOT NULL DEFAULT '0',
479  `PaydayMoney` int(11) NOT NULL,
480  `q1` varchar(128) NOT NULL,
481  `q2` varchar(128) NOT NULL,
482  `q3` varchar(128) NOT NULL,
483  `q4` varchar(128) NOT NULL,
484  `q5` varchar(128) NOT NULL,
485  `q6` varchar(128) NOT NULL,
486  `q7` varchar(128) NOT NULL,
487  `q8` varchar(128) NOT NULL,
488  `q9` varchar(128) NOT NULL,
489  `q10` varchar(128) NOT NULL,
490  `q11` varchar(128) NOT NULL,
491  `q12` varchar(128) NOT NULL,
492  `q13` varchar(128) NOT NULL,
493  `q14` varchar(128) NOT NULL,
494  `q15` varchar(128) NOT NULL,
495  `Rank1` varchar(64) NOT NULL DEFAULT 'Rank1',
496  `Rank2` varchar(64) NOT NULL DEFAULT 'Rank2',
497  `Rank3` varchar(64) NOT NULL DEFAULT 'Rank3',
498  `Rank4` varchar(64) NOT NULL DEFAULT 'Rank4',
499  `Rank5` varchar(64) NOT NULL DEFAULT 'Rank5',
500  `Rank6` varchar(64) NOT NULL DEFAULT 'Rank6',
501  `Rank7` varchar(64) NOT NULL DEFAULT 'Rank7',
502  PRIMARY KEY (`ID`)
503) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
504
505--
506-- Dumping data for table `factions`
507--
508
509INSERT INTO `factions` (`ID`, `Name`, `X`, `Y`, `Z`, `Mats`, `Drugs`, `Bank`, `Anunt`, `Win`, `Lost`, `MaxMembers`, `MinLevel`, `Application`, `PaydayMoney`, `q1`, `q2`, `q3`, `q4`, `q5`, `q6`, `q7`, `q8`, `q9`, `q10`, `q11`, `q12`, `q13`, `q14`, `q15`, `Rank1`, `Rank2`, `Rank3`, `Rank4`, `Rank5`, `Rank6`, `Rank7`) VALUES
510(1, 'Los Santos Police Department', 246.773, 65.1425, 1003.64, 0, 0, 1718000, 'Sedinta, astazi- 27.03.2016; ora 20:00. Cine nu este ON la sedinta va primii 1FW.', 0, 0, 15, 7, 1, 3000, 'Nume real:', 'Varsta reala:', 'Poza [/stats]:', 'Ultima factiune si motivul iesirii din ea:\r\n', 'De ce doresti sa intri in Los Santos Police Department?:', 'Ce este Los Santos Police Department si cu ce se ocupa?:', 'Esti pregaitit din punct de vedere al Regulamentului, Wanted List-ului si a Comenzilor?:', 'Ai avut vreo problema cu unul/ unii agenti din Los Santos Police Department?:', 'Esti constient ca trebuie sa stai in Los Santos Police Department pentru 14 zile, fara a nu mai primi FactionPunish?:', 'Vei respecta Liderul si Agentii cu Rank mai mare?:', 'Esti pe Black List-ul unei factiuni?:', 'Cat stai pe server(ore), fara AFK? ', 'Cum te-ai descrie?(minim 20 de cuvinte):', 'Alte precizari:', '', 'Cadet', 'Officer', 'Sergeant', 'Inspector', 'Captain', 'Deputy Chief', 'Chief'),
511(2, 'FBI', 230.069, 165.165, 1003.02, 0, 0, 18006, 'Sedinta la HQ la ora 15:00 Duminica !', 0, 0, 15, 7, 1, 3000, 'De ce doresti sa intri in Federal Bureau of Investigations ?', 'Cu ce se ocupa FBI ?', 'Cum te-ai descrie ? [minim 15 cuvinte]', 'Varsta reala ?', 'Sunteti pe black-listu vreunei factiuni ?Daca da ai fi dispus sa platesti sa fii scos ?', 'Ai primit ban/warn/jail ? Daca da de ce ?', 'Esti de acord sa stai 14 zile in FBI ?', 'Care a fost cea mai mare realizare pe acest server ?', 'Vei respecta lideri/co-lideri acestei factiuni ?', '', '', '', '', '', '', 'Agent', 'Special Agent', 'Senior Special Agent', 'Special Agent-in-Charge', 'Assistant Director', 'Deputy Director', 'Director'),
512(3, 'National Guard', 213.815, 1866.68, 13.1406, 0, 0, 1013001, 'Salut! Eu sunt noul lider, sper ca o sa ne intelegem.Sambata ora 20:00 sedinta.', 0, 0, 15, 7, 1, 3000, 'Nume real:', 'Varsta reala:', 'De cat timp joci pe server de tip RPG:', 'Ai fost banat vreodata? Daca da, spune si motivul: ', 'Cate ore acorzi jocului pe zi? :', 'Ai citit si esti de acord cu regulamentul intern cat si cel general? : ', 'Ai posibilitatea de a folosi programe de filmat precum Fraps, Bandicam?:', 'Biografia ta reala:', 'De ce doresti sa faci parte din departamentul National Guard?:', 'Esti pe blacklist-ul unei factiuni? Daca da, esti de acord sa platesti?:', 'Ii vei respecta pe cei cu rank mai mare?:', 'Ai avut tangente cu cineva din National Guard?:', 'Esti dispus sa stai minim 14 zile in aceasta factiune?:', 'Alte precizari?:', '', 'Corporal', 'Sergeant', 'Lieutenant', 'Major', 'Captain', 'Colonel', 'General'),
513(4, 'Los Aztecas', 774.214, -48.9243, 1000.59, 209880, 0, 585502, 'Minim 50.000 materiale depozitate pe zii de war pentru a nu primi FW.', 0, 0, 15, 6, 1, 3000, 'Nickname', 'Level', 'Nume real', 'Varsta', 'Ore jucate', 'Descrierea personala in 20-30 cuvinte', 'Cu ce se ocupa aceasta factiune?', 'De ce ai ales aceasta factiune?', 'Ai citit regulamentul factiunii?', 'Esti de acord sa fi sanctionat pentru incalcarea acestuia?', 'Alte precizari?', '', '', '', '', 'Kaikei', 'Shatei', 'Kyodai', 'Saiko-Komon', 'Shateigashira', 'Wakagashira', 'Oyabun'),
514(5, 'Grove Street', 2496.05, -1695.24, 1014.74, 169037, 52, 2845766, 'Faceti materiale si droguri pentru war.', 0, 0, 15, 5, 1, 3000, 'Nickname : ', 'Level : ', 'Varsta reala : ', 'Ai fost banat vreodata pe acest server? Daca da, de ce?', 'Ai mai avut si alte nickname-uri ?Daca da care sunt acelea ?:', 'Cu ce se ocupa Grove Street?', 'De ce doresti sa te alaturi mafiei?', 'Consideri ca poti fi prezent Luni ,Miercuri , Vineri si Duminca intre orele 20:00 - 22:00 la war-uri?', 'Ai primit warns , daca da de ce ? ', 'Enumera 3 motive pentru care ai putea lua ban in mafii:', 'Esti constient ca daca nu vei veni la war, vei primi FW?', 'Intervalul de timp in care joci pe server:', 'Esti pe blacklist-ul unei factiuni?:', 'Cat de bine crezi ca tragi cu arma?( low/medium/high ):', 'Autocaracterizare (minim 10-15 cuvinte)', 'Piciotto', 'Sgarrista', 'Caporegime', 'Consigiliere', 'Capo di Capi', 'Capo Crimini', 'Capo di tutti'),
515(6, 'Los Vagos', 2324.42, -1145.57, 1050.71, 531087, 44, 1938503, 'Sa faceti minim 5k mats zilnic!', 0, 0, 15, 6, 1, 3000, 'Level:', 'Varsta reala:', 'De ce vrei sa intri in Los Vagos?:', 'Ai mai fost intr-o mafie?:\r\n', 'Cat de bine tragi cu armelele(slab/bine/foarte bine)?:', 'Cu ce se ocupa Los Vagos?:', 'Vei fi prezent la war-uri(Luni,miercuri,vineri,duminica;Orele:20-22)?:', 'Esti deacord sa stai 2 saptamani(Adica 14 zile):', 'Auto-caracterizare(10-20 cuvinte):', 'Ai fost banat vreo data pe acest server?Daca da,de ce?:', 'Esti pe blacklist-ul unei factiuni?:', 'Cate ore joci pe server?:', 'Care este intervalul in care joci pe server?:', 'Ai avut vreo data u warn pe acest server?/Daca da,de ce?:', 'De ce vrei sa te alaturi mafie Los Vagos?:\r\n', 'Associate', 'Solider', 'Promovate', 'Caporegime', 'Consigiliere', 'Underboss', 'Boss'),
516(7, 'None', 0, 0, 0, 0, 0, 0, 'None', 0, 0, 15, 0, 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'Rank1', 'Rank2', 'Rank3', 'Rank4', 'Rank5', 'Rank6', 'Rank7'),
517(8, 'Las Venturas Police Department', 246.773, 65.1425, 1003.64, 0, 0, 6002738, 'Drive By este interzis. Se pedepseste cu Faction Warn. Atunci cand tragi cu arma de pe motor este DB.', 0, 0, 15, 7, 1, 3000, 'De ce vrei sa intri in Las Venturas Police Departament(minim 20 de cuvinte):', 'Motivul iesirii din ultima factiune:', 'Numarul de warnuri si motivul pentru care le-ai primit:', 'Ati mai facut parte dintr-un departament?Daca da , de ce l-ati parasit?:', 'Ai mai fost in Las Venturas Police Departament?:', 'Daca da, de ce ai iesit?:', 'Cat timp petreci pe SA:MP fara AFK(ore):', 'Esti de acord sa stai in Las Venturas Police Departament minim 14zile?:', 'Ati avut / aveti probleme cu cineva din factiunea Las Venturas Police Departament?:', 'Vei respecta liderul si membrii cu rank mai mare din Las Venturas Police Departament?:', 'Prin ce te-ai remarcat pe server pana acum?:', 'Cum te-ai descrie(minim 20 de cuvinte)?:', 'Nume real:', 'Varsta reala:', '', 'Cadet', 'Officer', 'Sergeant', 'Inspector', 'Captain', 'Deputy Chief', 'Chief'),
518(9, 'News Reporters', -2027.05, -104.521, 1035.17, 0, 0, 663001, 'None', 0, 0, 15, 5, 1, 3000, 'Nume real', 'Varsta', 'Cate ore acordati serverului pe zi?', 'Ultima factiune, rank-ul avut si motivul iesirii din aceasta?', 'De ce doresti sa intrii in News Reporters? (minim 20 de cuvinte)', 'Cu ce crezi ca poti ajuta factiunea?', 'Esti capabil sa lucrezi in echipa si sa comunici decent si corect?', 'Cum te descurci cu Limba Romana si cu gramatica?', 'Esti de acord cu faptul ca trebuie sa respecti liderul si membrii cu rank mai mare?', 'Esti constient ca daca nu stai minim 14 zile in factiune, vei lua FP?', 'Esti pe blacklist-ul vreunei factiuni?', 'Ai mai fost in factiunea News Reporters?', 'Auto-descriere (minim 30 de cuvinte)', 'Alte precizari?:', '', 'Reporter', 'Journalist', 'Editor', 'Redactor', 'Manager', 'Vice-Director', 'Director'),
519(10, 'Ballas', 964.107, -53.2055, 1001.12, 94490, 0, 718110, 'Bine ati venit in Ballas Gang ! .', 0, 0, 15, 6, 1, 3000, 'Nickname:', 'Nickname-uri anterioare:', 'Level:', 'Varsta reala:', 'De cat timp joci pe Rpg.bigzone.ro', 'Warns:', 'Ai fost banat vreodata pe acest server? Daca da, de ce?:', 'Ai mai fost in Ballas Gang?: ', 'Cu ce se ocupa Ballas Gang ?:', 'De ce doresti sa te alaturi mafiei Ballas Gang ?:', 'Consideri ca poti fi prezent Luni ,Miercuri , Vineri si Duminca intre orele 20:00 - 22:00 la war-uri?:', 'Esti constient ca daca nu vei veni la war, vei primi FW?:', 'Intervalul de timp in care joci pe server::', 'Esti pe blacklist-ul unei factiuni?:', 'O scurta descriere a ta: ', 'Shestyorka', 'Byki', 'Torpedo', 'Bovevik', 'Kassir', 'Sovietnik', 'Pakhan'),
520(11, 'Hitman', 2324, -1148.05, 1050.71, 0, 0, 30000, 'Sedinta Sambata 26.03.2016 Ora 20:00', 0, 0, 15, 7, 1, 3000, 'Ce varsta ai?', 'Descrie-te in 2-3 fraze:', 'De ce doresti sa te alaturi agentiei?', 'Cu ce crezi ca se ocupa membrii agentiei?', 'Ai mai facut parte din agentie? Daca da, de ce ai iesit?', 'Esti pe BlackList-ul unei factiuni?', 'Prin ce te-ai remarcat pana acum pe server?', 'Ai citit regulamentul general al factiunii?', 'Crezi ca meriti sa intri in acesta factiune ? ', 'Esti constient ca daca nu vei sta 7 zile in factiune , vei primi remove ? ', 'Ai fost vreodata banat ? Daca da , de ce ? ', 'Care e rank-ul cel mai mare pe care l-ai avut intr-o factiune ? ', 'Cu ce crezi ca poti ajuta aceasta factiune?', 'Cat ti-ai propus sa stai in aceasta agentie?', 'Esti de acord ca trebuie sa respecti cuvantul liderului / co-liderului sau a unui rank mai mare? ', 'Assasin', 'Contract Killer', 'Serial Killer', 'Proffesional Killer', 'Manager', 'Vice-Director', 'Director'),
521(12, 'School Instructors', 1494.33, 1304.94, 1093.29, 0, 0, 863004, 'Duminca,ora 18 sedinta cu prezenta obligatorie!Preturi licente schimbate,detalii pe forum.', 0, 0, 15, 5, 1, 3000, 'Varsta reala', 'Numele real', 'Ce este Dm-ul si cu ce se pedepseste ?', 'Descriera ta (minim 20 cuvine)', 'De ce vrei sa intrii in School Instructors ?', 'Te afli pe BlackList-ul unei factiuni ?', 'Ai vreun conflict cu un membru School intructors ?', 'Ai citit regulament-ul School Instructors ?\r\n', 'Alte precizari:', '', '', '', '', '', '', 'Trainee', 'Instructor', 'Advanced Instructor', 'Supervisor', 'Manager', 'Vice-Director', 'Director'),
522(13, 'Taxi', 1700.98, -1667.89, 20.2188, 0, 0, 2663087, 'Sedinta Duminica 20:00 ', 0, 0, 15, 5, 1, 3000, 'De ce doresti sa faci parte din Taxi Los Santos?', 'De ce crezi ca Taxi Los Santos este potrivita pentru tine?', 'Ce varsta ai?', 'Descrie-te in minim 20 de cuvinte', 'Ce alte jocuri mai joci inafara de SA:MP', 'Cate ore petreci zilnic pe server (fara AFK / sleep)?', 'Ai mai facut parte din Taxi Los Santos pana acum?', 'Cu ce crezi ca poti ajuta aceasta factiune?', 'Cat ti-ai propus sa stai in aceasta companie?', 'Cunosti toate locatiile importante de pe server?', 'Esti de acord ca trebuie sa respecti cuvantul liderului / co-liderului sau a unui rank mai mare?', 'Esti de acord ca pentru un comportament neadecvat fata de cei care conduc factiunea poate fi pedepsita cu uninvite?', ' Ai verificat daca esti pe Black Listul factiunii Los Santos Taxi Company, deoarece daca te aflii esti respins automat! ', 'Care este cea mai mare realizare a ta pe acest server?', 'In caz ca ve-ti incalca regulamentul, sunteti de acord sa platiti amenda in functie de gravitate?', 'Novice Driver', 'Driver', 'Proffesional Driver', 'Legend Driver', 'Manager', 'Vice-Director', 'Director'),
523(14, 'Paramedic', 1494.28, 1304.34, 1093.29, 0, 0, 663000, 'Sedinta este sambata la ora 18:00, prezenta obligatorie + raportul terminat. Succes!', 0, 0, 15, 5, 0, 3000, 'Ce varsta ai?', 'O scurta auto-descriere. (minim 20 de cuvinte).', 'De ce doresti sa intri in aceasta factiune? (Argumenteaza in minim 20 cuvinte)', 'Ce iti place la aceasta factiune? (minim 15 cuvinte)', 'Cu ce se ocupa Paramedic Departament?', 'Esti de acord ca daca nu ramai 14 zile in factiune vei primii 20 Faction Punish?', 'Alte precizari?', '', '', '', '', '', '', '', '', 'Paramedic Stagiar', 'Paramedic Rezident', 'Paramedic Chirurg', 'Paramedic Specialist', 'Paramedic Primar', 'Deputy Chief Paramedic', 'Chief Paramedic');
524
525-- --------------------------------------------------------
526
527--
528-- Table structure for table `faction_logs`
529--
530
531CREATE TABLE IF NOT EXISTS `faction_logs` (
532  `id` int(11) NOT NULL AUTO_INCREMENT,
533  `player` int(11) NOT NULL,
534  `leader` int(11) NOT NULL,
535  `Text` text NOT NULL,
536  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
537  `factionid` int(11) NOT NULL,
538  PRIMARY KEY (`id`)
539) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
540
541--
542-- Dumping data for table `faction_logs`
543--
544
545INSERT INTO `faction_logs` (`id`, `player`, `leader`, `Text`, `time`, `factionid`) VALUES
546(1, 1, 1, 'has joined the group LSPD (invited by Hurdock).', '2016-04-13 09:42:12', 1);
547
548-- --------------------------------------------------------
549
550--
551-- Table structure for table `friends`
552--
553
554CREATE TABLE IF NOT EXISTS `friends` (
555  `ID` int(11) NOT NULL AUTO_INCREMENT,
556  `PlayerID` int(11) NOT NULL,
557  `FriendID` int(11) NOT NULL,
558  `FriendName` varchar(30) NOT NULL,
559  `Status` int(11) NOT NULL DEFAULT '1',
560  PRIMARY KEY (`ID`)
561) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
562
563-- --------------------------------------------------------
564
565--
566-- Table structure for table `giftbox_logs`
567--
568
569CREATE TABLE IF NOT EXISTS `giftbox_logs` (
570  `id` int(11) NOT NULL AUTO_INCREMENT,
571  `text` varchar(256) NOT NULL,
572  `PlayerID` int(11) NOT NULL,
573  `time` varchar(64) NOT NULL DEFAULT '0',
574  `giftid` int(11) NOT NULL,
575  PRIMARY KEY (`id`)
576) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
577
578-- --------------------------------------------------------
579
580--
581-- Table structure for table `houses`
582--
583
584CREATE TABLE IF NOT EXISTS `houses` (
585  `ID` int(11) NOT NULL AUTO_INCREMENT,
586  `Entrancex` float NOT NULL,
587  `Entrancey` float NOT NULL,
588  `Entrancez` float NOT NULL,
589  `Exitx` float NOT NULL,
590  `Exity` float NOT NULL,
591  `Exitz` float NOT NULL,
592  `Owner` varchar(25) NOT NULL DEFAULT 'The State',
593  `Discription` varchar(50) NOT NULL DEFAULT 'House',
594  `Value` int(20) NOT NULL DEFAULT '10000000',
595  `Hel` int(11) NOT NULL,
596  `Arm` int(11) NOT NULL,
597  `Interior` int(11) NOT NULL,
598  `Lockk` int(11) NOT NULL,
599  `Owned` int(11) NOT NULL,
600  `Rent` int(11) NOT NULL,
601  `Rentabil` int(11) NOT NULL,
602  `Takings` int(11) NOT NULL,
603  `Level` int(11) NOT NULL DEFAULT '10',
604  `Virtual` int(11) NOT NULL,
605  PRIMARY KEY (`ID`)
606) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=101 ;
607
608--
609-- Dumping data for table `houses`
610--
611
612INSERT INTO `houses` (`ID`, `Entrancex`, `Entrancey`, `Entrancez`, `Exitx`, `Exity`, `Exitz`, `Owner`, `Discription`, `Value`, `Hel`, `Arm`, `Interior`, `Lockk`, `Owned`, `Rent`, `Rentabil`, `Takings`, `Level`, `Virtual`) VALUES
613(1, 1421.85, -885.64, 50.6647, 343.721, 305.059, 999.148, 'The State', 'House', 10000000, 0, 0, 6, 0, 0, 5, 1, 0, 10, 0),
614(2, 1468.62, -904.898, 54.8359, 2259.38, -1135.87, 1050.64, 'The State', 'House', 10000000, 0, 0, 10, 0, 0, 5, 1, 0, 10, 1),
615(3, 1540.46, -851.409, 64.3361, 260.852, 1237.23, 1084.26, 'The State', 'House', 10000000, 0, 0, 9, 0, 0, 5, 1, 0, 10, 2),
616(4, 1534.06, -800.188, 72.8495, 491.203, 1399.24, 1080.26, 'The State', 'House', 10000000, 0, 0, 2, 0, 0, 5, 1, 0, 10, 3),
617(5, 1527.3, -773.188, 80.5781, 491.203, 1399.24, 1080.26, 'The State', 'House', 10000000, 0, 0, 2, 0, 0, 5, 1, 0, 10, 4),
618(6, 1497.06, -688.239, 95.5086, 1262.14, -785.331, 1091.91, 'The State', 'House', 10000000, 1, 0, 5, 0, 0, 5, 1, 0, 10, 5),
619(7, 1112.11, -742.075, 100.133, 227.021, 1114.34, 1081, 'The State', 'House', 10000000, 0, 0, 5, 0, 0, 5, 1, 0, 10, 6),
620(8, 1093.9, -806.597, 107.419, 2196.12, -1204.33, 1049.02, 'The State', 'House', 10000000, 0, 0, 6, 0, 0, 5, 1, 0, 10, 7),
621(9, 1034.74, -812.627, 101.852, 447.043, 1397.9, 1084.3, 'The State', 'House', 10000000, 0, 0, 2, 0, 0, 5, 1, 0, 10, 8),
622(10, 1094.91, -647.068, 113.648, 22.9734, 1404.15, 1084.43, 'The State', 'House', 10000000, 0, 0, 5, 0, 0, 5, 1, 0, 10, 9),
623(11, 980.352, -676.742, 121.976, 140.17, 1366.07, 1083.65, 'The State', 'House', 10000000, 0, 0, 5, 0, 0, 5, 1, 0, 10, 10),
624(12, 990.004, -828.547, 95.4686, 1262.14, -785.331, 1091.91, 'The State', 'House', 10000000, 1, 1, 5, 0, 0, 5, 1, 0, 10, 11),
625(13, 937.327, -847.405, 93.7796, 223.005, 1287.6, 1082.14, 'The State', 'House', 10000000, 0, 0, 1, 0, 0, 5, 1, 0, 10, 12),
626(14, 836.166, -894.341, 68.7689, 386.402, 1471.7, 1080.19, 'The State', 'House', 10000000, 0, 0, 15, 0, 0, 5, 1, 0, 10, 13),
627(15, 827.889, -858.718, 70.3308, 376.136, 1417.34, 1081.33, 'The State', 'House', 10000000, 0, 0, 15, 0, 0, 5, 1, 0, 10, 14),
628(16, 1981.29, -1718.79, 17.0301, 2495.74, -1692.82, 1014.74, 'The State', 'House', 10000000, 0, 0, 3, 0, 0, 5, 1, 0, 10, 15),
629(17, 2413.86, -1646.79, 14.0119, 2496.05, -1692.73, 1014.74, 'The State', 'House', 10000000, 0, 0, 3, 0, 0, 5, 1, 0, 10, 16),
630(18, 1854.1, -1914.87, 15.2568, 2259.74, -1135.83, 1050.63, 'The State', 'House', 10000000, 0, 0, 10, 0, 0, 5, 1, 0, 10, 17),
631(19, 1872.32, -1912.36, 15.2568, 2259.86, -1135.86, 1050.63, 'The State', 'House', 10000000, 0, 0, 10, 0, 0, 5, 1, 0, 10, 18),
632(20, 1891.93, -1914.4, 15.2568, 2308.74, -1212.61, 1049.02, 'The State', 'House', 10000000, 0, 0, 6, 0, 0, 5, 1, 0, 10, 19),
633(21, 1913.51, -1911.9, 15.2568, 24.0261, 1340.52, 1084.38, 'The State', 'House', 10000000, 0, 0, 10, 0, 0, 5, 1, 0, 10, 20),
634(22, 1928.52, -1915.96, 15.2568, -42.5426, 1406.23, 1084.43, 'The State', 'House', 10000000, 0, 0, 8, 0, 0, 5, 1, 0, 10, 21),
635(23, 2152.22, -1446.52, 26.1051, 2233.57, -1114.62, 1050.88, 'The State', 'House', 10000000, 0, 0, 5, 0, 0, 5, 1, 0, 10, 22),
636(24, 2147.98, -1484.88, 26.6241, 235.228, 1187.86, 1080.26, 'The State', 'House', 10000000, 0, 0, 3, 0, 0, 5, 1, 0, 10, 23),
637(25, 2149.85, -1433.68, 26.0703, 446.534, 507.182, 1001.42, 'The State', 'House', 10000000, 0, 0, 12, 0, 0, 5, 1, 0, 10, 24),
638(26, 1111.6, -976.003, 42.7656, 225.721, 1022.18, 1084.02, 'The State', 'House', 10000000, 0, 0, 7, 0, 0, 5, 1, 0, 10, 25),
639(27, 2150.92, -1419.01, 25.9219, 2237.52, -1081.16, 1049.02, 'The State', 'House', 10000000, 0, 0, 2, 0, 0, 5, 1, 0, 10, 26),
640(28, 2151.18, -1400.68, 26.1285, 2365.32, -1134.59, 1050.88, 'The State', 'House', 10000000, 0, 0, 8, 0, 0, 5, 1, 0, 10, 27),
641(29, 315.85, -1769.75, 4.631, 2196, -1204.32, 1049.02, 'The State', 'House', 10000000, 1, 1, 6, 0, 0, 5, 1, 0, 10, 28),
642(30, 295.251, -1764.12, 4.8701, 223.072, 1288.01, 1082.14, 'The State', 'House', 10000000, 0, 0, 1, 0, 0, 5, 1, 0, 10, 29),
643(31, 946.289, -710.712, 122.62, 223.021, 1287.73, 1082.14, 'The State', 'House', 10000000, 0, 0, 1, 0, 0, 5, 1, 0, 10, 30),
644(32, 1331.87, -632.87, 109.135, 2317.82, -1026.4, 1050.22, 'The State', 'House', 10000000, 1, 0, 9, 0, 0, 5, 1, 0, 10, 31),
645(33, 300.255, -1154.46, 81.391, 140.075, 1367.21, 1083.86, 'The State', 'House', 10000000, 1, 0, 5, 0, 0, 5, 1, 0, 10, 32),
646(34, 977.377, -770.917, 112.203, -42.5781, 1405.96, 1084.43, 'The State', 'House', 10000000, 0, 0, 8, 0, 0, 5, 1, 0, 10, 33),
647(35, 897.94, -677.092, 116.89, 2233.79, -1114.59, 1050.88, 'The State', 'House', 10000000, 0, 0, 5, 0, 0, 5, 1, 0, 10, 34),
648(36, 891.252, -783.131, 101.314, 2217.68, -1076.33, 1050.48, 'The State', 'House', 10000000, 0, 0, 1, 0, 0, 5, 1, 0, 10, 35),
649(37, 952.289, -909.99, 45.7656, 234.166, 1064.05, 1084.21, 'The State', 'House', 10000000, 1, 0, 6, 0, 0, 5, 1, 0, 10, 36),
650(38, 1378.71, -1753.22, 14.1406, 2196.09, -1204.05, 1049.02, 'The State', 'House', 10000000, 1, 0, 6, 1, 0, 5, 1, 0, 10, 37),
651(39, 1981.84, -1682.86, 17.0538, 83.0945, 1322.78, 1083.87, 'The State', 'House', 10000000, 0, 0, 9, 0, 0, 5, 1, 0, 10, 38),
652(40, 2015.35, -1732.58, 14.2344, 2495.98, -1692.08, 1014.74, 'The State', 'House', 10000000, 0, 0, 3, 0, 0, 5, 1, 0, 10, 39),
653(41, 1258.7, -785.379, 92.0302, 1262.14, -785.331, 1091.91, 'The State', 'House', 10000000, 0, 0, 5, 0, 0, 5, 1, 0, 10, 40),
654(42, 2393.2, -1646.26, 13.9051, 140.325, 1366.66, 1083.86, 'The State', 'House', 10000000, 0, 0, 5, 0, 0, 5, 1, 0, 10, 41),
655(43, 2409.12, -1674.94, 14.375, 2496.05, -1692.73, 1014.74, 'The State', 'House', 10000000, 0, 0, 3, 0, 0, 5, 1, 0, 10, 42),
656(44, 2362.77, -1643.74, 14.0649, 225.721, 1022.18, 1084.02, 'The State', 'House', 10000000, 0, 0, 7, 0, 0, 5, 1, 0, 10, 43),
657(45, 254.887, -1366.69, 53.1094, 234.19, 1063.73, 1084.21, 'The State', 'House', 10000000, 0, 0, 6, 0, 0, 5, 1, 0, 10, 44),
658(46, 189.638, -1308.32, 70.2492, 225.68, 1021.45, 1084.02, 'The State', 'House', 10000000, 1, 0, 7, 1, 0, 5, 1, 0, 10, 45),
659(47, 251.765, -1220.67, 75.9508, 235.34, 1186.68, 1080.26, 'The State', 'House', 10000000, 1, 0, 3, 0, 0, 5, 1, 0, 10, 46),
660(48, 416.651, -1154.24, 76.6876, 491.07, 1398.5, 1080.26, 'The State', 'House', 10000000, 0, 0, 2, 0, 0, 5, 1, 0, 10, 47),
661(49, 2384.6, -1675.31, 14.9152, 260.85, 1237.24, 1084.26, 'The State', 'House', 10000000, 0, 0, 9, 0, 0, 5, 1, 0, 10, 48),
662(50, 2368.22, -1675.34, 14.1682, 260.85, 1237.24, 1084.26, 'The State', 'House', 10000000, 0, 0, 9, 0, 0, 5, 1, 0, 10, 49),
663(51, 1442.69, -629.352, 95.7186, 225.68, 1021.45, 1084.02, 'The State', 'House', 10000000, 1, 0, 7, 0, 0, 5, 1, 0, 10, 50),
664(52, 253.206, -1270, 74.4307, 140.075, 1367.21, 1083.86, 'The State', 'House', 10000000, 1, 0, 5, 0, 0, 5, 1, 0, 10, 51),
665(53, 298.488, -1338.02, 53.4415, 235.34, 1186.68, 1080.26, 'The State', 'House', 10000000, 1, 0, 3, 0, 0, 5, 1, 0, 10, 52),
666(54, 2016.2, -1716.98, 14.125, 1262.14, -785.331, 1091.91, 'The State', 'House', 10000000, 0, 0, 5, 0, 0, 5, 1, 0, 10, 53),
667(55, 2018.24, -1703.23, 14.2344, 140.17, 1366.07, 1083.65, 'The State', 'House', 10000000, 0, 0, 5, 0, 0, 5, 1, 0, 10, 54),
668(56, 2013.58, -1656.3, 14.1363, 226.3, 1114.24, 1080.99, 'The State', 'House', 10000000, 0, 0, 5, 1, 0, 5, 1, 0, 10, 55),
669(57, 2016.54, -1641.64, 14.1129, 24.0406, 1340.79, 1084.38, 'The State', 'House', 10000000, 0, 0, 10, 0, 0, 5, 1, 0, 10, 56),
670(58, 471.069, -1164.3, 67.1984, 2317.85, -1026.36, 1050.22, 'The State', 'House', 10000000, 0, 0, 9, 0, 0, 5, 1, 0, 10, 57),
671(59, 281.054, -1768.5, 4.5229, 1262.14, -785.331, 1091.91, 'The State', 'House', 10000000, 1, 0, 5, 0, 0, 5, 1, 0, 10, 58),
672(60, 2018.05, -1629.95, 14.0426, 1262.14, -785.331, 1091.91, 'The State', 'House', 10000000, 0, 0, 5, 0, 0, 5, 1, 0, 10, 59),
673(61, 1023.98, -982.643, 42.6393, 1262.14, -785.331, 1091.91, 'The State', 'House', 10000000, 0, 0, 5, 0, 0, 5, 1, 0, 10, 60),
674(62, 219.756, -1250.46, 78.3323, 235.193, 1187.26, 1080.26, 'The State', 'House', 10000000, 1, 0, 3, 0, 0, 5, 1, 0, 10, 61),
675(63, 699.385, -1059.7, 49.4217, 225.721, 1022.18, 1084.02, 'The State', 'House', 10000000, 0, 0, 7, 0, 0, 5, 1, 0, 10, 62),
676(64, 2065.69, -1703.49, 14.1484, 222.969, 1287.63, 1082.14, 'The State', 'House', 10000000, 0, 0, 1, 0, 0, 5, 1, 0, 10, 63),
677(65, 725.146, -998.934, 52.7344, 226.3, 1114.24, 1080.99, 'The State', 'House', 10000000, 1, 0, 5, 1, 0, 5, 1, 0, 10, 64),
678(66, 2066.24, -1717.02, 14.1363, 235.34, 1186.68, 1080.26, 'The State', 'House', 10000000, 0, 0, 3, 0, 0, 5, 1, 0, 10, 65),
679(67, 1411.24, -920.882, 38.4219, 140.325, 1366.66, 1083.86, 'The State', 'House', 10000000, 1, 0, 5, 1, 0, 5, 1, 0, 10, 66),
680(68, 2067.05, -1731.6, 14.2066, -283.44, 1470.93, 1084.38, 'The State', 'House', 10000000, 0, 0, 15, 0, 0, 5, 1, 0, 10, 67),
681(69, 1081.18, -1697.05, 13.5469, 234.19, 1063.73, 1084.21, 'The State', 'House', 10000000, 0, 0, 6, 0, 0, 5, 1, 0, 10, 68),
682(70, 1846.29, 661.361, 11.4609, 2324.53, -1149.54, 1050.71, 'The State', 'House', 10000000, 0, 0, 12, 0, 0, 5, 1, 0, 10, 69),
683(71, 1845.44, 741.339, 11.4609, 2259.38, -1135.87, 1050.64, 'The State', 'House', 10000000, 0, 0, 10, 0, 0, 5, 1, 0, 10, 70),
684(72, 1844, 718.717, 11.4683, 266.505, 305.029, 999.148, 'The State', 'House', 10000000, 0, 0, 2, 0, 0, 5, 1, 0, 10, 71),
685(73, 1844.53, 690.411, 11.4531, 243.723, 304.995, 999.148, 'The State', 'House', 10000000, 0, 0, 1, 0, 0, 5, 1, 0, 10, 72),
686(74, 2014.04, 650.406, 11.4609, 2218.4, -1076.28, 1050.48, 'The State', 'House', 10000000, 0, 0, 1, 0, 0, 5, 1, 0, 10, 74),
687(75, 2011.59, 695.189, 11.4609, 2233.74, -1115.26, 1050.88, 'The State', 'House', 10000000, 0, 0, 5, 0, 0, 5, 1, 0, 10, 75),
688(76, 2065.69, 649.864, 11.4683, 2308.79, -1212.94, 1049.02, 'The State', 'House', 10000000, 0, 0, 6, 0, 0, 5, 1, 0, 10, 76),
689(77, 2069.06, 696.629, 11.4683, -42.7103, 1405.47, 1084.43, 'The State', 'House', 10000000, 0, 0, 8, 0, 0, 5, 1, 0, 10, 77),
690(78, 2120.38, 696.093, 11.4531, 223.071, 1287.08, 1082.14, 'The State', 'House', 10000000, 0, 0, 1, 0, 0, 5, 1, 0, 10, 78),
691(79, 2123.25, 651.313, 11.4609, 327.91, 1477.73, 1084.44, 'The State', 'House', 10000000, 0, 0, 15, 0, 0, 5, 1, 0, 10, 79),
692(80, 2122.46, 731.351, 11.4609, 2282.83, -1140.27, 1050.9, 'The State', 'House', 10000000, 0, 0, 11, 0, 0, 5, 1, 0, 10, 80),
693(81, 2123.39, 776.102, 11.4453, 223.022, 1287.08, 1082.14, 'The State', 'House', 10000000, 0, 0, 1, 0, 0, 5, 1, 0, 10, 81),
694(82, 2065.09, 729.824, 11.4683, 2259.38, -1135.87, 1050.64, 'The State', 'House', 10000000, 0, 0, 10, 0, 0, 5, 1, 0, 10, 82),
695(83, 2071.61, 776.634, 11.4605, 243.723, 304.995, 999.148, 'The State', 'House', 10000000, 0, 0, 1, 0, 0, 5, 1, 0, 10, 83),
696(84, 2013.24, 730.358, 11.4531, 266.505, 305.029, 999.148, 'The State', 'House', 15000000, 0, 0, 2, 0, 0, 5, 1, 0, 10, 84),
697(85, 2014.09, 774.998, 11.4609, 2218.4, -1076.28, 1050.48, 'The State', 'House', 10000000, 0, 0, 1, 0, 0, 5, 1, 0, 10, 85),
698(86, 2169.18, 772.292, 11.4609, 2233.74, -1115.26, 1050.88, 'The State', 'House', 10000000, 0, 0, 5, 0, 0, 5, 1, 0, 10, 86),
699(87, 2177.24, 690.472, 11.4609, 2308.77, -1212.94, 1049.02, 'The State', 'House', 10000000, 0, 0, 6, 0, 0, 5, 1, 0, 10, 87),
700(88, 2177.67, 736.103, 11.4609, -42.7103, 1405.47, 1084.43, 'The State', 'House', 10000000, 0, 0, 8, 0, 0, 5, 1, 0, 10, 88),
701(89, 2228.59, 689.811, 11.4605, 223.071, 1287.08, 1082.14, 'The State', 'House', 10000000, 0, 0, 1, 0, 0, 5, 1, 0, 10, 89),
702(90, 2228.34, 734.983, 11.4609, 327.91, 1477.73, 1084.44, 'The State', 'House', 10000000, 0, 0, 15, 0, 0, 5, 1, 0, 10, 90),
703(91, 2317.16, 690.351, 11.4609, 2282.83, -1140.27, 1050.9, 'The State', 'House', 10000000, 0, 0, 11, 0, 0, 5, 1, 0, 10, 91),
704(92, 2368.59, 689.8, 11.4605, 223.022, 1287.08, 1082.14, 'The State', 'House', 10000000, 0, 0, 1, 0, 0, 5, 1, 0, 10, 92),
705(93, 2369.18, 735.197, 11.4609, 2259.38, -1135.87, 1050.64, 'The State', 'House', 10000000, 0, 0, 10, 0, 0, 5, 1, 0, 10, 93),
706(94, 2450.27, 742.661, 11.4609, 243.723, 304.995, 999.148, 'The State', 'House', 10000000, 0, 0, 1, 0, 0, 5, 1, 0, 10, 94),
707(95, 2449.23, 689.898, 11.4609, 266.505, 305.029, 999.148, 'The State', 'House', 10000000, 0, 0, 2, 0, 0, 5, 1, 0, 10, 95),
708(96, 2178.11, 655.993, 11.4609, 2218.4, -1076.28, 1050.48, 'The State', 'House', 10000000, 0, 0, 1, 0, 0, 5, 1, 0, 10, 96),
709(97, 2228.88, 655.003, 11.4609, 2233.74, -1115.26, 1050.88, 'The State', 'House', 10000000, 0, 0, 5, 0, 0, 5, 1, 0, 10, 97),
710(98, 2317.92, 656.101, 11.4531, 2308.77, -1212.94, 1049.02, 'The State', 'House', 10000000, 0, 0, 6, 0, 0, 5, 1, 0, 10, 98),
711(99, 2368.4, 655.211, 11.4609, -42.7103, 1405.47, 1084.43, 'The State', 'House', 10000000, 0, 0, 8, 0, 0, 5, 1, 0, 10, 99),
712(100, 2301.86, 1285.74, 67.4688, 234.282, 1063.72, 1084.21, 'The State', 'House', 10000000, 1, 0, 6, 0, 0, 5, 1, 0, 10, 100);
713
714-- --------------------------------------------------------
715
716--
717-- Table structure for table `iplogs`
718--
719
720CREATE TABLE IF NOT EXISTS `iplogs` (
721  `ID` int(11) NOT NULL AUTO_INCREMENT,
722  `ip` varchar(64) NOT NULL,
723  `playerid` int(24) NOT NULL,
724  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
725  PRIMARY KEY (`ID`)
726) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
727
728-- --------------------------------------------------------
729
730--
731-- Table structure for table `jobs`
732--
733
734CREATE TABLE IF NOT EXISTS `jobs` (
735  `id` int(11) NOT NULL,
736  `jobName` varchar(30) NOT NULL,
737  `times` varchar(10) NOT NULL,
738  PRIMARY KEY (`id`)
739) ENGINE=InnoDB DEFAULT CHARSET=latin1;
740
741--
742-- Dumping data for table `jobs`
743--
744
745INSERT INTO `jobs` (`id`, `jobName`, `times`) VALUES
746(5, 'Pizza Boy', 'PizzaTimes'),
747(6, 'Farmer', 'FarmTimes'),
748(7, 'Bus Driver', 'BusTimes'),
749(9, 'Arms Dealer', 'ArmsTimes'),
750(13, 'Fisher', 'FishTimes'),
751(14, 'Trucker', 'TruckTimes');
752
753-- --------------------------------------------------------
754
755--
756-- Table structure for table `kicklogs`
757--
758
759CREATE TABLE IF NOT EXISTS `kicklogs` (
760  `id` int(11) NOT NULL AUTO_INCREMENT,
761  `playerid` int(11) NOT NULL,
762  `giverid` int(11) NOT NULL,
763  `playername` varchar(30) NOT NULL,
764  `givername` varchar(30) NOT NULL,
765  `reason` varchar(128) NOT NULL,
766  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
767  PRIMARY KEY (`id`)
768) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
769
770-- --------------------------------------------------------
771
772--
773-- Table structure for table `kill_logs`
774--
775
776CREATE TABLE IF NOT EXISTS `kill_logs` (
777  `ID` int(11) NOT NULL AUTO_INCREMENT,
778  `playerid` int(11) NOT NULL,
779  `killerid` int(11) NOT NULL,
780  `playername` varchar(30) NOT NULL,
781  `killername` varchar(30) NOT NULL,
782  `reason` int(11) NOT NULL,
783  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
784  PRIMARY KEY (`ID`)
785) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
786
787-- --------------------------------------------------------
788
789--
790-- Table structure for table `log_admin`
791--
792
793CREATE TABLE IF NOT EXISTS `log_admin` (
794  `id` int(11) NOT NULL AUTO_INCREMENT,
795  `log` varchar(256) NOT NULL,
796  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
797  PRIMARY KEY (`id`)
798) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
799
800-- --------------------------------------------------------
801
802--
803-- Table structure for table `notifications`
804--
805
806CREATE TABLE IF NOT EXISTS `notifications` (
807  `id` int(11) NOT NULL AUTO_INCREMENT,
808  `mesaj` text CHARACTER SET utf8 COLLATE utf8_romanian_ci NOT NULL,
809  `readed` int(11) NOT NULL DEFAULT '0',
810  `pentru` text NOT NULL,
811  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
812  PRIMARY KEY (`id`)
813) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=46 ;
814
815--
816-- Dumping data for table `notifications`
817--
818
819INSERT INTO `notifications` (`id`, `mesaj`, `readed`, `pentru`, `time`) VALUES
820(38, 'Hurdock a scris in reclamația <b>Deathmatch</b>', 0, 'Hurdock2', '2016-04-13 11:48:42'),
821(41, 'Hurdock a scris in reclamația <b>Deathmatch</b>', 0, 'Hurdock2', '2016-04-15 23:24:40'),
822(42, 'Hurdock a scris in reclamația <b>Deathmatch</b>', 1, 'Hurdock', '2016-04-15 23:24:40'),
823(43, 'Hurdock a scris in reclamația <b>Deathmatch</b>', 0, 'Hurdock2', '2016-04-15 23:27:47'),
824(44, 'Hurdock a scris in reclamația <b>Deathmatch</b>', 1, 'Hurdock', '2016-04-15 23:27:47'),
825(45, 'Hurdock2 ți-a făcut o reclamație pentru Face DM la Spawn.', 1, 'Hurdock', '2016-04-15 23:34:42');
826
827-- --------------------------------------------------------
828
829--
830-- Table structure for table `panelactions`
831--
832
833CREATE TABLE IF NOT EXISTS `panelactions` (
834  `id` int(11) NOT NULL AUTO_INCREMENT,
835  `actionid` int(11) NOT NULL,
836  `actiontime` int(11) NOT NULL DEFAULT '0',
837  `complaintid` int(11) NOT NULL DEFAULT '0',
838  `playerid` int(11) NOT NULL,
839  `giverid` int(11) NOT NULL,
840  `playername` varchar(64) NOT NULL,
841  `givername` varchar(64) NOT NULL,
842  `reason` varchar(128) NOT NULL,
843  `dm` int(3) NOT NULL DEFAULT '0',
844  PRIMARY KEY (`id`)
845) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
846
847-- --------------------------------------------------------
848
849--
850-- Table structure for table `panel_restrict`
851--
852
853CREATE TABLE IF NOT EXISTS `panel_restrict` (
854  `ID` int(11) NOT NULL AUTO_INCREMENT,
855  `PlayerName` varchar(20) NOT NULL,
856  `AdminName` varchar(20) NOT NULL,
857  `Reason` text NOT NULL,
858  `Time` int(15) NOT NULL,
859  `Days` int(11) NOT NULL,
860  `Permanent` int(11) NOT NULL,
861  `BanTimeDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
862  PRIMARY KEY (`ID`)
863) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
864
865-- --------------------------------------------------------
866
867--
868-- Table structure for table `playerlogs`
869--
870
871CREATE TABLE IF NOT EXISTS `playerlogs` (
872  `ID` int(11) NOT NULL AUTO_INCREMENT,
873  `playerid` int(11) NOT NULL,
874  `giverid` int(11) NOT NULL,
875  `action` varchar(128) NOT NULL,
876  `time` varchar(64) NOT NULL,
877  PRIMARY KEY (`ID`)
878) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
879
880-- --------------------------------------------------------
881
882--
883-- Table structure for table `punishlogs`
884--
885
886CREATE TABLE IF NOT EXISTS `punishlogs` (
887  `id` int(11) NOT NULL AUTO_INCREMENT,
888  `playerid` int(11) NOT NULL,
889  `giverid` int(11) NOT NULL,
890  `playername` varchar(30) NOT NULL,
891  `givername` varchar(30) NOT NULL,
892  `complaintid` int(11) NOT NULL DEFAULT '0',
893  `actionid` int(11) NOT NULL,
894  `actiontime` int(11) NOT NULL DEFAULT '0',
895  `reason` varchar(128) NOT NULL,
896  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
897  PRIMARY KEY (`id`)
898) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
899
900-- --------------------------------------------------------
901
902--
903-- Table structure for table `recover`
904--
905
906CREATE TABLE IF NOT EXISTS `recover` (
907  `RecoverKey` varchar(255) NOT NULL DEFAULT '',
908  `name` varchar(20) DEFAULT NULL,
909  `email` varchar(255) DEFAULT NULL,
910  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
911  PRIMARY KEY (`RecoverKey`)
912) ENGINE=MyISAM DEFAULT CHARSET=latin1;
913
914-- --------------------------------------------------------
915
916--
917-- Table structure for table `shop_logs`
918--
919
920CREATE TABLE IF NOT EXISTS `shop_logs` (
921  `id` int(11) NOT NULL AUTO_INCREMENT,
922  `Shop` varchar(128) NOT NULL,
923  `playerid` int(11) NOT NULL,
924  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
925  PRIMARY KEY (`id`)
926) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
927
928-- --------------------------------------------------------
929
930--
931-- Table structure for table `staff_logs`
932--
933
934CREATE TABLE IF NOT EXISTS `staff_logs` (
935  `ID` int(11) NOT NULL AUTO_INCREMENT,
936  `text` varchar(128) NOT NULL,
937  PRIMARY KEY (`ID`)
938) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
939
940--
941-- Dumping data for table `staff_logs`
942--
943
944INSERT INTO `staff_logs` (`ID`, `text`) VALUES
945(1, '* Admin Hurdock set Test''s helper level to 3.'),
946(2, '* Admin Hurdock set Test''s helper level to 3.');
947
948-- --------------------------------------------------------
949
950--
951-- Table structure for table `stock`
952--
953
954CREATE TABLE IF NOT EXISTS `stock` (
955  `ID` int(11) NOT NULL AUTO_INCREMENT,
956  `Stock` int(11) NOT NULL,
957  `Price` int(20) NOT NULL,
958  `Car` varchar(50) NOT NULL,
959  `vid` int(11) NOT NULL,
960  `speed` int(11) NOT NULL,
961  PRIMARY KEY (`ID`)
962) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=101 ;
963
964--
965-- Dumping data for table `stock`
966--
967
968INSERT INTO `stock` (`ID`, `Stock`, `Price`, `Car`, `vid`, `speed`) VALUES
969(0, 30, 250000, 'Bike', 509, 93),
970(1, 24, 500000, 'Faggio', 462, 99),
971(2, 7, 550000, 'Benson', 499, 109),
972(3, 14, 750000, 'Perennial', 404, 118),
973(4, 9, 930000, 'Rumpo', 440, 121),
974(5, 11, 930000, 'Pony', 413, 98),
975(6, 9, 1200000, 'Camper', 483, 109),
976(7, 26, 1100000, 'Moonbeam', 418, 102),
977(8, 27, 1300000, 'Sadler', 543, 134),
978(9, 26, 1250000, 'Walton', 478, 104),
979(10, 27, 1300000, 'Regina', 479, 124),
980(11, 26, 1450000, 'Oceanic', 467, 125),
981(12, 26, 1470000, 'Glendale', 466, 130),
982(13, 28, 1570000, 'Bravura', 401, 130),
983(14, 27, 1700000, 'Hermes', 474, 132),
984(15, 27, 1750000, 'Manana', 410, 115),
985(16, 30, 2000000, 'Intruder', 546, 132),
986(17, 29, 2100000, 'Berkley''s RC Van', 459, 121),
987(18, 30, 2500000, 'Sunrise', 550, 128),
988(19, 29, 2500000, 'Previon', 436, 132),
989(20, 30, 2400000, 'Fortune', 526, 140),
990(21, 29, 2600000, 'Primo', 547, 127),
991(22, 30, 2500000, 'Majestic', 517, 140),
992(23, 30, 2450000, 'Virgo', 491, 132),
993(24, 29, 2500000, 'Bobcat', 422, 124),
994(25, 30, 2900000, 'Quad', 471, 98),
995(26, 29, 3500000, 'Burrito', 482, 139),
996(27, 27, 3500000, 'Solair', 458, 140),
997(28, 30, 3200000, 'Cadrona', 527, 132),
998(29, 30, 3350000, 'Mesa', 500, 125),
999(30, 30, 3550000, 'Journey', 508, 96),
1000(31, 30, 3550000, 'Merit', 551, 140),
1001(32, 30, 3850000, 'Landstalker', 400, 140),
1002(33, 29, 4500000, 'Nebula', 516, 140),
1003(34, 30, 4300000, 'Emperor', 585, 136),
1004(35, 30, 4400000, 'Esperanto', 419, 132),
1005(36, 30, 4300000, 'Willard', 529, 132),
1006(37, 30, 4500000, 'Stallion', 439, 150),
1007(38, 29, 4500000, 'Clover', 542, 146),
1008(39, 30, 4500000, 'Stafford', 580, 136),
1009(40, 30, 4500000, 'Tampa', 549, 136),
1010(41, 30, 4700000, 'Picador', 600, 134),
1011(42, 30, 4800000, 'Hustler', 545, 130),
1012(43, 29, 5000000, 'Greenwood', 492, 125),
1013(44, 30, 5000000, 'Hotknife', 434, 148),
1014(45, 29, 5000000, 'Stratum', 561, 137),
1015(46, 29, 5000000, 'Vincent', 540, 132),
1016(47, 28, 5200000, 'Elegant', 507, 147),
1017(48, 29, 5200000, 'Washington', 421, 136),
1018(49, 30, 5400000, 'Broadway', 575, 140),
1019(50, 30, 5700000, 'Tahoma', 566, 142),
1020(51, 30, 5800000, 'Savanna', 567, 153),
1021(52, 29, 6000000, 'Blista Compact', 496, 144),
1022(53, 30, 6500000, 'Slamvan', 535, 140),
1023(54, 29, 6600000, 'Tornado', 576, 140),
1024(55, 30, 6500000, 'Buccaneer', 518, 146),
1025(56, 30, 7000000, 'Yosemite', 554, 128),
1026(57, 29, 7200000, 'Windsor', 555, 140),
1027(58, 30, 7300000, 'Remington', 534, 150),
1028(59, 29, 7500000, 'Wayfarer', 586, 127),
1029(60, 30, 8000000, 'Bloodring Banger', 504, 153),
1030(61, 30, 8300000, 'Premier', 426, 154),
1031(62, 28, 8500000, 'Club', 589, 144),
1032(63, 30, 9000000, 'Phoenix', 603, 152),
1033(64, 29, 10000000, 'Freeway', 463, 130),
1034(65, 27, 11000000, 'Sabre', 475, 153),
1035(66, 25, 11000000, 'Rancher', 489, 124),
1036(67, 30, 12000000, 'Blade', 536, 153),
1037(68, 29, 12000000, 'Sentinel', 405, 145),
1038(69, 30, 12000000, 'Euros', 587, 146),
1039(70, 30, 12500000, 'Feltzer', 533, 148),
1040(71, 30, 12500000, 'Admiral', 445, 145),
1041(72, 30, 13000000, 'Voodoo', 412, 150),
1042(73, 30, 14000000, 'Sanchez', 468, 128),
1043(74, 30, 14000000, 'Alpha', 602, 150),
1044(75, 30, 14800000, 'Huntley', 579, 140),
1045(76, 30, 15000000, 'Flash', 565, 146),
1046(77, 30, 15000000, 'Uranus', 558, 138),
1047(78, 29, 16000000, 'Comet', 480, 163),
1048(79, 29, 16000000, 'BF-400', 581, 134),
1049(80, 30, 17000000, 'Super GT', 506, 159),
1050(81, 30, 19000000, 'PCJ-600', 461, 143),
1051(82, 30, 20000000, 'FCR-900', 521, 141),
1052(83, 30, 21000000, 'Sandking', 495, 156),
1053(84, 26, 21000000, 'ZR-350', 477, 165),
1054(85, 30, 22500000, 'Jester', 559, 158),
1055(86, 30, 22500000, 'Elegy', 562, 150),
1056(87, 30, 22500000, 'Buffalo', 402, 165),
1057(88, 30, 25000000, 'Cheetah', 415, 171),
1058(89, 30, 24500000, 'Banshee', 429, 179),
1059(90, 29, 26000000, 'Sultan', 560, 150),
1060(91, 28, 28000000, 'Turismo', 451, 172),
1061(92, 27, 35000000, 'NRG-500', 522, 156),
1062(93, 27, 38000000, 'Bullet', 541, 180),
1063(94, 28, 45000000, 'Infernus', 411, 197),
1064(95, 26, 900000000, 'Sparrow', 469, 77),
1065(96, 30, 90000000, 'Hotring Racer', 494, 191),
1066(97, 30, 68000000, 'Vortex', 539, 88),
1067(98, 30, 80000000, 'Hotring Racer A', 502, 191),
1068(99, 30, 80000000, 'Hotring Racer B', 503, 191),
1069(100, 30, 80000000, 'Maverick', 487, 150);
1070
1071-- --------------------------------------------------------
1072
1073--
1074-- Table structure for table `su_logs`
1075--
1076
1077CREATE TABLE IF NOT EXISTS `su_logs` (
1078  `ID` int(11) NOT NULL AUTO_INCREMENT,
1079  `playerid` int(11) NOT NULL,
1080  `giverid` int(11) NOT NULL,
1081  `reason` varchar(128) NOT NULL,
1082  `sumessage` varchar(256) NOT NULL,
1083  `time` varchar(64) NOT NULL,
1084  PRIMARY KEY (`ID`)
1085) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1086
1087-- --------------------------------------------------------
1088
1089--
1090-- Table structure for table `tickets`
1091--
1092
1093CREATE TABLE IF NOT EXISTS `tickets` (
1094  `id` int(11) NOT NULL AUTO_INCREMENT,
1095  `titlu` varchar(40) CHARACTER SET utf8 COLLATE utf8_romanian_ci NOT NULL,
1096  `continut` text CHARACTER SET utf8 COLLATE utf8_romanian_ci NOT NULL,
1097  `ultimulraspuns` text NOT NULL,
1098  `creat` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1099  `creatraspuns` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
1100  `categorie` int(11) NOT NULL,
1101  `creator` text NOT NULL,
1102  `status` int(11) NOT NULL,
1103  PRIMARY KEY (`id`)
1104) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=11 ;
1105
1106--
1107-- Dumping data for table `tickets`
1108--
1109
1110INSERT INTO `tickets` (`id`, `titlu`, `continut`, `ultimulraspuns`, `creat`, `creatraspuns`, `categorie`, `creator`, `status`) VALUES
1111(7, 'QWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQE', '<p>QWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQEQWEQE</p>', 'Hurdock', '2016-04-13 00:42:52', '2016-04-13 00:42:52', 1, 'Hurdock', 1),
1112(9, 'test', '<p>123</p>', 'Nimeni', '2016-04-13 10:44:14', '2016-04-13 10:44:14', 2, 'Hurdock', 0),
1113(10, 'De unde cumpar o masina?', '<p>Vreau sa-mi cumpar una din modelele urmatoare</p><ul><li>NRG</li><li>Sultan</li><li>Infernus</li><li>Blablabla..</li></ul>', 'Hurdock', '2016-04-13 11:50:11', '2016-04-13 11:50:11', 1, 'Hurdock', 0);
1114
1115-- --------------------------------------------------------
1116
1117--
1118-- Table structure for table `ticketsanswers`
1119--
1120
1121CREATE TABLE IF NOT EXISTS `ticketsanswers` (
1122  `idticket` int(11) NOT NULL,
1123  `creator` text NOT NULL,
1124  `mesaj` text CHARACTER SET utf8 COLLATE utf8_romanian_ci NOT NULL,
1125  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
1126) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1127
1128--
1129-- Dumping data for table `ticketsanswers`
1130--
1131
1132INSERT INTO `ticketsanswers` (`idticket`, `creator`, `mesaj`, `time`) VALUES
1133(7, 'Hurdock', '<p>Buna idee!</p>', '2016-04-13 00:56:11'),
1134(7, 'Hurdock', '<p>Sunt de aceasi parere desigur.</p><p>Insă</p><ul><li>Să adăugăm ceva nou.</li><li>Să facem x,y,z.</li></ul>', '2016-04-13 00:57:51'),
1135(7, 'Hurdock', '<p>da?</p>', '2016-04-13 00:59:22'),
1136(10, 'Hurdock2', '<p>Du-te la dealership.</p>', '2016-04-13 11:50:40'),
1137(10, 'Hurdock', '<p>Mersii..</p>', '2016-04-13 11:51:59');
1138
1139-- --------------------------------------------------------
1140
1141--
1142-- Table structure for table `turfs`
1143--
1144
1145CREATE TABLE IF NOT EXISTS `turfs` (
1146  `ID` int(11) NOT NULL AUTO_INCREMENT,
1147  `Owned` int(11) NOT NULL,
1148  `MinX` float NOT NULL,
1149  `MinY` float NOT NULL,
1150  `MaxX` float NOT NULL,
1151  `MaxY` float NOT NULL,
1152  PRIMARY KEY (`ID`)
1153) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=49 ;
1154
1155--
1156-- Dumping data for table `turfs`
1157--
1158
1159INSERT INTO `turfs` (`ID`, `Owned`, `MinX`, `MinY`, `MaxX`, `MaxY`) VALUES
1160(1, 6, 114.21, -1364.93, 506.54, -912.91),
1161(2, 6, 506.54, -1364.93, 899.25, -912.91),
1162(3, 6, 899.25, -1313.7, 1313.58, -912.91),
1163(4, 6, 1313.58, -1364.93, 1727.49, -912.91),
1164(5, 6, 1727.49, -1364.93, 2108.13, -912.91),
1165(6, 5, 2108.13, -1364.93, 2499.38, -912.91),
1166(7, 5, 2499.38, -1313.7, 2916.17, -912.91),
1167(8, 6, 114.21, -1821.03, 506.54, -1364.93),
1168(9, 6, 506.54, -1821.03, 899.25, -1364.93),
1169(10, 6, 899.25, -1721.9, 1313.58, -1313.7),
1170(11, 6, 1313.58, -1821.03, 1727.49, -1364.93),
1171(12, 5, 1727.49, -1821.03, 2108.13, -1364.93),
1172(13, 5, 2108.13, -1821.03, 2499.38, -1364.93),
1173(14, 5, 2499.38, -1737.65, 2916.17, -1313.7),
1174(15, 6, 899.25, -2131.32, 1313.58, -1721.9),
1175(16, 6, 899.25, -2489.99, 1313.58, -2131.32),
1176(17, 6, 1313.58, -2250.92, 1727.49, -1821.03),
1177(18, 5, 1727.49, -2250.92, 2108.13, -1821.03),
1178(19, 5, 2108.13, -2250.92, 2499.38, -1821.03),
1179(20, 5, 2499.38, -2172.41, 2916.17, -1737.65),
1180(21, 5, 1313.58, -2690.47, 1727.49, -2250.92),
1181(22, 5, 1727.49, -2690.47, 2108.13, -2250.92),
1182(23, 5, 2108.13, -2690.47, 2499.38, -2250.92),
1183(24, 5, 2499.38, -2567.91, 2916.17, -2172.41),
1184(25, 4, 1114.47, 2444.49, 1478.16, 2901.03),
1185(26, 4, 1478.16, 2444.49, 1828.16, 2901.03),
1186(27, 4, 2150.16, 2444.49, 2528.16, 2901.03),
1187(28, 4, 1828.16, 2444.49, 2150.16, 2901.03),
1188(29, 4, 2528.16, 2444.49, 2878.16, 2901.03),
1189(30, 4, 901.16, 1980.34, 1307.16, 2444.49),
1190(31, 4, 1307.16, 1980.34, 1677.16, 2444.49),
1191(32, 4, 1677.16, 1980.34, 2076.16, 2444.49),
1192(33, 4, 2076.16, 1980.34, 2482, 2444.49),
1193(34, 4, 2482, 1980.34, 2878.16, 2444.49),
1194(35, 4, 901.16, 1528.09, 1307.16, 1980.34),
1195(36, 4, 1307.16, 1528.09, 1677.16, 1980.34),
1196(37, 10, 1677.16, 1528.09, 2076.16, 1980.34),
1197(38, 10, 2076.16, 1528.09, 2482, 1980.34),
1198(39, 10, 2482, 1528.09, 2878.16, 1980.34),
1199(40, 10, 901.16, 1074.9, 1307.16, 1528.09),
1200(41, 10, 1307.16, 1074.9, 1677.16, 1528.09),
1201(42, 10, 1677.16, 1074.9, 2076.16, 1528.09),
1202(43, 10, 2076.16, 1074.9, 2482, 1528.09),
1203(44, 10, 2482, 1074.9, 2878.16, 1528.09),
1204(45, 10, 1307.16, 663.83, 1677.16, 1074.9),
1205(46, 10, 1677.16, 663.83, 2076.16, 1074.9),
1206(47, 10, 2076.16, 663.83, 2482, 1074.9),
1207(48, 10, 2482, 663.83, 2878.16, 1074.9);
1208
1209-- --------------------------------------------------------
1210
1211--
1212-- Table structure for table `updates`
1213--
1214
1215CREATE TABLE IF NOT EXISTS `updates` (
1216  `id` int(11) NOT NULL AUTO_INCREMENT,
1217  `text` text NOT NULL,
1218  `date` text NOT NULL,
1219  `byAdmin` text NOT NULL,
1220  `For` int(11) NOT NULL,
1221  PRIMARY KEY (`id`)
1222) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1223
1224-- --------------------------------------------------------
1225
1226--
1227-- Table structure for table `users`
1228--
1229
1230CREATE TABLE IF NOT EXISTS `users` (
1231  `id` int(11) NOT NULL AUTO_INCREMENT,
1232  `name` varchar(25) NOT NULL,
1233  `password` varchar(50) NOT NULL,
1234  `Level` int(3) NOT NULL DEFAULT '0',
1235  `Admin` int(2) NOT NULL DEFAULT '0',
1236  `Helper` int(2) NOT NULL DEFAULT '0',
1237  `IP` varchar(20) NOT NULL,
1238  `Premium` int(2) NOT NULL DEFAULT '0',
1239  `Beta` int(2) NOT NULL DEFAULT '0',
1240  `Support` int(3) NOT NULL DEFAULT '0',
1241  `ConnectedTime` int(11) NOT NULL DEFAULT '0',
1242  `Registered` int(2) NOT NULL DEFAULT '0',
1243  `Sex` int(2) NOT NULL DEFAULT '0',
1244  `Age` int(3) NOT NULL DEFAULT '0',
1245  `Origin` int(2) NOT NULL DEFAULT '1',
1246  `Muted` int(2) NOT NULL DEFAULT '0',
1247  `MuteTime` int(11) NOT NULL DEFAULT '0',
1248  `Respect` int(11) NOT NULL DEFAULT '0',
1249  `Money` int(11) NOT NULL DEFAULT '0',
1250  `Bank` int(11) NOT NULL DEFAULT '0',
1251  `Crimes` int(11) NOT NULL DEFAULT '0',
1252  `Kills` int(11) NOT NULL DEFAULT '0',
1253  `Deaths` int(11) NOT NULL DEFAULT '0',
1254  `Arrested` int(11) NOT NULL DEFAULT '0',
1255  `WantedDeaths` int(11) NOT NULL DEFAULT '0',
1256  `Phonebook` int(2) NOT NULL DEFAULT '0',
1257  `WantedLevel` int(11) NOT NULL DEFAULT '0',
1258  `Fishes` int(3) NOT NULL DEFAULT '0',
1259  `Job` int(3) NOT NULL DEFAULT '0',
1260  `Paycheck` int(11) NOT NULL DEFAULT '0',
1261  `HeadValue` int(11) NOT NULL DEFAULT '0',
1262  `Jailed` int(2) NOT NULL DEFAULT '0',
1263  `JailTime` int(11) NOT NULL DEFAULT '0',
1264  `dm` int(3) NOT NULL DEFAULT '0',
1265  `dmp` int(3) NOT NULL DEFAULT '0',
1266  `Materials` int(11) NOT NULL DEFAULT '0',
1267  `Drugs` int(11) NOT NULL DEFAULT '0',
1268  `Leader` int(3) NOT NULL DEFAULT '0',
1269  `Member` int(3) NOT NULL DEFAULT '0',
1270  `Rank` int(2) NOT NULL DEFAULT '0',
1271  `FWarn` int(2) NOT NULL DEFAULT '0',
1272  `FPunish` int(4) NOT NULL DEFAULT '0',
1273  `Acceptpoints` int(2) NOT NULL DEFAULT '0',
1274  `pHealth` float NOT NULL,
1275  `Inter` int(3) NOT NULL DEFAULT '0',
1276  `Local` int(11) NOT NULL DEFAULT '0',
1277  `Team` int(3) NOT NULL DEFAULT '0',
1278  `Model` int(11) NOT NULL,
1279  `PhoneNr` int(5) NOT NULL DEFAULT '0',
1280  `PhoneCredits` int(4) NOT NULL DEFAULT '0',
1281  `House` int(11) NOT NULL DEFAULT '0',
1282  `Bizz` int(11) NOT NULL DEFAULT '0',
1283  `Pos_x` float NOT NULL,
1284  `Pos_y` float NOT NULL,
1285  `Pos_z` float NOT NULL,
1286  `Rob` int(11) NOT NULL DEFAULT '0',
1287  `GunLicSuspend` int(3) NOT NULL DEFAULT '0',
1288  `CarLicSuspend` int(3) NOT NULL DEFAULT '0',
1289  `CarLicT` int(11) NOT NULL DEFAULT '0',
1290  `CarLic` int(2) NOT NULL DEFAULT '0',
1291  `FlyLicT` int(11) NOT NULL DEFAULT '0',
1292  `FlyLic` int(2) NOT NULL DEFAULT '0',
1293  `BoatLicT` int(11) NOT NULL DEFAULT '0',
1294  `BoatLic` int(2) NOT NULL DEFAULT '0',
1295  `FishLicT` int(11) NOT NULL DEFAULT '0',
1296  `FishLic` int(2) NOT NULL DEFAULT '0',
1297  `GunLicT` int(11) NOT NULL DEFAULT '0',
1298  `GunLic` int(2) NOT NULL DEFAULT '0',
1299  `PayDay` int(20) NOT NULL DEFAULT '0',
1300  `PayDayHad` int(20) NOT NULL DEFAULT '0',
1301  `Tutorial` int(2) NOT NULL DEFAULT '0',
1302  `Warnings` int(2) NOT NULL DEFAULT '0',
1303  `Rented` int(111) NOT NULL DEFAULT '0',
1304  `Fuel` int(11) NOT NULL DEFAULT '0',
1305  `WTalkie` int(2) NOT NULL DEFAULT '0',
1306  `Tow` int(20) NOT NULL DEFAULT '0',
1307  `Email` varchar(50) NOT NULL DEFAULT 'email@yahoo.com',
1308  `RegisterDate` varchar(50) NOT NULL DEFAULT '00-00-0000 00:00:00',
1309  `lastOn` varchar(50) NOT NULL DEFAULT '00-00-0000 00:00:00',
1310  `Victim` varchar(64) NOT NULL,
1311  `Status` int(11) NOT NULL DEFAULT '0',
1312  `HitT` int(20) NOT NULL DEFAULT '0',
1313  `Phone` int(11) NOT NULL DEFAULT '0',
1314  `Carkey` int(11) NOT NULL DEFAULT '0',
1315  `motokey` int(11) NOT NULL DEFAULT '0',
1316  `helikey` int(11) NOT NULL DEFAULT '0',
1317  `prcarkey` int(11) NOT NULL DEFAULT '0',
1318  `Accused` varchar(64) NOT NULL DEFAULT '********',
1319  `Crime1` varchar(184) NOT NULL DEFAULT 'Fara',
1320  `Crime2` varchar(184) NOT NULL DEFAULT 'Fara',
1321  `Crime3` varchar(184) NOT NULL DEFAULT 'Fara',
1322  `Fakea` int(11) NOT NULL DEFAULT '0',
1323  `ALeader` int(11) NOT NULL DEFAULT '0',
1324  `HPoints` int(11) NOT NULL DEFAULT '0',
1325  `Language` int(2) NOT NULL DEFAULT '0',
1326  `rpgon` int(11) NOT NULL DEFAULT '0',
1327  `PremiumPoints` int(11) NOT NULL DEFAULT '0',
1328  `FWorks` int(11) NOT NULL DEFAULT '0',
1329  `prcarkey2` int(11) NOT NULL DEFAULT '0',
1330  `pluscarkey` int(11) NOT NULL DEFAULT '0',
1331  `pluscarkey2` int(11) NOT NULL DEFAULT '0',
1332  `pluscarkey3` int(11) NOT NULL DEFAULT '0',
1333  `PlusSlot1` int(11) NOT NULL DEFAULT '0',
1334  `PlusSlot2` int(11) NOT NULL DEFAULT '0',
1335  `VirtualPD` int(11) NOT NULL DEFAULT '0',
1336  `Glasses` int(11) NOT NULL DEFAULT '0',
1337  `Hats` int(11) NOT NULL DEFAULT '0',
1338  `GiftBoxTime` int(11) NOT NULL DEFAULT '0',
1339  `SpawnChange` int(11) NOT NULL DEFAULT '0',
1340  `RobSkill` int(11) NOT NULL DEFAULT '1',
1341  `RobTimes` int(11) NOT NULL DEFAULT '0',
1342  `RobRem` int(11) NOT NULL DEFAULT '26',
1343  `FishSkill` int(11) NOT NULL DEFAULT '1',
1344  `FishTimes` int(11) NOT NULL DEFAULT '0',
1345  `FishRem` int(11) NOT NULL DEFAULT '26',
1346  `TruckSkill` int(11) NOT NULL DEFAULT '1',
1347  `TruckTimes` int(11) NOT NULL DEFAULT '0',
1348  `TruckRem` int(11) NOT NULL DEFAULT '26',
1349  `FarmSkill` int(11) NOT NULL DEFAULT '1',
1350  `FarmTimes` int(11) NOT NULL DEFAULT '0',
1351  `FarmRem` int(11) NOT NULL DEFAULT '26',
1352  `PizzaSkill` int(2) NOT NULL DEFAULT '1',
1353  `PizzaRem` int(5) NOT NULL DEFAULT '26',
1354  `PizzaTimes` int(11) NOT NULL DEFAULT '0',
1355  `ArmsSkill` int(2) NOT NULL DEFAULT '1',
1356  `ArmsRem` int(5) NOT NULL DEFAULT '26',
1357  `ArmsTimes` int(11) NOT NULL DEFAULT '0',
1358  `BusSkill` int(2) NOT NULL DEFAULT '1',
1359  `BusRem` int(5) NOT NULL DEFAULT '26',
1360  `BusTimes` int(11) NOT NULL DEFAULT '0',
1361  `Gifti` int(11) NOT NULL,
1362  `FactionTime` int(11) NOT NULL,
1363  `CreditsF` int(11) NOT NULL,
1364  `NMuted` int(11) NOT NULL DEFAULT '0',
1365  `HelpedPlayers` int(11) NOT NULL DEFAULT '0',
1366  `HiddenColor` int(11) NOT NULL DEFAULT '0',
1367  `GiftTime` int(11) NOT NULL DEFAULT '0',
1368  `PhoneBlock` int(11) NOT NULL DEFAULT '0',
1369  `Host` int(11) NOT NULL DEFAULT '0',
1370  `FightStyle` int(11) NOT NULL DEFAULT '0',
1371  `HUD1` int(11) NOT NULL DEFAULT '0',
1372  `HUD2` int(11) NOT NULL DEFAULT '0',
1373  `HUD3` int(11) NOT NULL DEFAULT '0',
1374  `Clan` int(4) NOT NULL DEFAULT '0',
1375  `CRank` int(2) NOT NULL DEFAULT '0',
1376  `ClanTag` int(2) NOT NULL DEFAULT '0',
1377  `ClanTime` int(11) NOT NULL DEFAULT '0',
1378  `ClanJoin` varchar(64) NOT NULL DEFAULT '0',
1379  `FactionJoin` varchar(64) NOT NULL DEFAULT '0',
1380  `ClanWarns` int(2) NOT NULL DEFAULT '0',
1381  `OnlineToday` int(2) NOT NULL DEFAULT '0',
1382  `OnlineThisWeek` int(2) NOT NULL DEFAULT '0',
1383  `OnlineLastWeek` int(2) NOT NULL DEFAULT '0',
1384  `LastIP` varchar(20) NOT NULL DEFAULT '0',
1385  `GasCan` int(2) NOT NULL DEFAULT '0',
1386  `Quest0` int(1) NOT NULL DEFAULT '0',
1387  `Quest1` int(1) NOT NULL DEFAULT '0',
1388  `Quest2` int(1) NOT NULL DEFAULT '0',
1389  `Quest3` int(1) NOT NULL DEFAULT '0',
1390  `Quest4` int(1) NOT NULL DEFAULT '0',
1391  `Quest5` int(1) NOT NULL DEFAULT '0',
1392  `Quest6` int(1) NOT NULL DEFAULT '0',
1393  `Quest7` int(1) NOT NULL DEFAULT '0',
1394  `Quest8` int(1) NOT NULL DEFAULT '0',
1395  `Quest9` int(1) NOT NULL DEFAULT '0',
1396  `Quest10` int(1) NOT NULL DEFAULT '0',
1397  `Quest11` int(1) NOT NULL DEFAULT '0',
1398  `Quest12` int(1) NOT NULL DEFAULT '0',
1399  `Quest13` int(1) NOT NULL DEFAULT '0',
1400  `Quest14` int(1) NOT NULL DEFAULT '0',
1401  `Quest15` int(1) NOT NULL DEFAULT '0',
1402  `Quest16` int(1) NOT NULL DEFAULT '0',
1403  `Quest17` int(1) NOT NULL DEFAULT '0',
1404  `Quest18` int(1) NOT NULL DEFAULT '0',
1405  `Quest19` int(1) NOT NULL DEFAULT '0',
1406  `Quest20` int(1) NOT NULL DEFAULT '0',
1407  `Quest21` int(1) NOT NULL DEFAULT '0',
1408  `Quest22` int(1) NOT NULL DEFAULT '0',
1409  `Quest23` int(1) NOT NULL DEFAULT '0',
1410  `Quest24` int(1) NOT NULL DEFAULT '0',
1411  `Quest25` int(1) NOT NULL DEFAULT '0',
1412  `Quest26` int(1) NOT NULL DEFAULT '0',
1413  `Quest27` int(1) NOT NULL DEFAULT '0',
1414  `Quest28` int(1) NOT NULL DEFAULT '0',
1415  `Quest29` int(1) NOT NULL DEFAULT '0',
1416  `Quest30` int(1) NOT NULL DEFAULT '0',
1417  `Quest31` int(1) NOT NULL DEFAULT '0',
1418  `Quest32` int(1) NOT NULL DEFAULT '0',
1419  `Quest33` int(1) NOT NULL DEFAULT '0',
1420  `Quest34` int(1) NOT NULL DEFAULT '0',
1421  `Quest35` int(1) NOT NULL DEFAULT '0',
1422  `Quest36` int(1) NOT NULL DEFAULT '0',
1423  `Quest37` int(1) NOT NULL DEFAULT '0',
1424  `Quest38` int(1) NOT NULL DEFAULT '0',
1425  `Quest39` int(1) NOT NULL DEFAULT '0',
1426  `Quest40` int(1) NOT NULL DEFAULT '0',
1427  `Quest41` int(1) NOT NULL DEFAULT '0',
1428  `Quest42` int(1) NOT NULL DEFAULT '0',
1429  `Quest43` int(1) NOT NULL DEFAULT '0',
1430  `Quest44` int(1) NOT NULL DEFAULT '0',
1431  `Quest45` int(1) NOT NULL DEFAULT '0',
1432  `Quest46` int(1) NOT NULL DEFAULT '0',
1433  `Quest47` int(1) NOT NULL DEFAULT '0',
1434  `Quest48` int(1) NOT NULL DEFAULT '0',
1435  `Quest49` int(1) NOT NULL DEFAULT '0',
1436  PRIMARY KEY (`id`)
1437) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
1438
1439--
1440-- Dumping data for table `users`
1441--
1442
1443INSERT INTO `users` (`id`, `name`, `password`, `Level`, `Admin`, `Helper`, `IP`, `Premium`, `Beta`, `Support`, `ConnectedTime`, `Registered`, `Sex`, `Age`, `Origin`, `Muted`, `MuteTime`, `Respect`, `Money`, `Bank`, `Crimes`, `Kills`, `Deaths`, `Arrested`, `WantedDeaths`, `Phonebook`, `WantedLevel`, `Fishes`, `Job`, `Paycheck`, `HeadValue`, `Jailed`, `JailTime`, `dm`, `dmp`, `Materials`, `Drugs`, `Leader`, `Member`, `Rank`, `FWarn`, `FPunish`, `Acceptpoints`, `pHealth`, `Inter`, `Local`, `Team`, `Model`, `PhoneNr`, `PhoneCredits`, `House`, `Bizz`, `Pos_x`, `Pos_y`, `Pos_z`, `Rob`, `GunLicSuspend`, `CarLicSuspend`, `CarLicT`, `CarLic`, `FlyLicT`, `FlyLic`, `BoatLicT`, `BoatLic`, `FishLicT`, `FishLic`, `GunLicT`, `GunLic`, `PayDay`, `PayDayHad`, `Tutorial`, `Warnings`, `Rented`, `Fuel`, `WTalkie`, `Tow`, `Email`, `RegisterDate`, `lastOn`, `Victim`, `Status`, `HitT`, `Phone`, `Carkey`, `motokey`, `helikey`, `prcarkey`, `Accused`, `Crime1`, `Crime2`, `Crime3`, `Fakea`, `ALeader`, `HPoints`, `Language`, `rpgon`, `PremiumPoints`, `FWorks`, `prcarkey2`, `pluscarkey`, `pluscarkey2`, `pluscarkey3`, `PlusSlot1`, `PlusSlot2`, `VirtualPD`, `Glasses`, `Hats`, `GiftBoxTime`, `SpawnChange`, `RobSkill`, `RobTimes`, `RobRem`, `FishSkill`, `FishTimes`, `FishRem`, `TruckSkill`, `TruckTimes`, `TruckRem`, `FarmSkill`, `FarmTimes`, `FarmRem`, `PizzaSkill`, `PizzaRem`, `PizzaTimes`, `ArmsSkill`, `ArmsRem`, `ArmsTimes`, `BusSkill`, `BusRem`, `BusTimes`, `Gifti`, `FactionTime`, `CreditsF`, `NMuted`, `HelpedPlayers`, `HiddenColor`, `GiftTime`, `PhoneBlock`, `Host`, `FightStyle`, `HUD1`, `HUD2`, `HUD3`, `Clan`, `CRank`, `ClanTag`, `ClanTime`, `ClanJoin`, `FactionJoin`, `ClanWarns`, `OnlineToday`, `OnlineThisWeek`, `OnlineLastWeek`, `LastIP`, `GasCan`, `Quest0`, `Quest1`, `Quest2`, `Quest3`, `Quest4`, `Quest5`, `Quest6`, `Quest7`, `Quest8`, `Quest9`, `Quest10`, `Quest11`, `Quest12`, `Quest13`, `Quest14`, `Quest15`, `Quest16`, `Quest17`, `Quest18`, `Quest19`, `Quest20`, `Quest21`, `Quest22`, `Quest23`, `Quest24`, `Quest25`, `Quest26`, `Quest27`, `Quest28`, `Quest29`, `Quest30`, `Quest31`, `Quest32`, `Quest33`, `Quest34`, `Quest35`, `Quest36`, `Quest37`, `Quest38`, `Quest39`, `Quest40`, `Quest41`, `Quest42`, `Quest43`, `Quest44`, `Quest45`, `Quest46`, `Quest47`, `Quest48`, `Quest49`) VALUES
1444(1, 'Hurdock', 'test', 4, 5, 0, '', 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 'email@yahoo.com', '00-00-0000 00:00:00', '00-00-0000 00:00:00', '', 0, 0, 0, 0, 0, 0, 0, '********', 'Fara', 'Fara', 'Fara', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 26, 1, 0, 26, 1, 0, 26, 1, 0, 26, 1, 26, 0, 1, 26, 0, 1, 26, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
1445(2, 'Hurdock2', '123', 4, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 1, 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, 3, 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, 'email@yahoo.com', '00-00-0000 00:00:00', '00-00-0000 00:00:00', '', 0, 0, 0, 0, 0, 0, 0, '********', 'Fara', 'Fara', 'Fara', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 26, 1, 0, 26, 1, 0, 26, 1, 0, 26, 1, 26, 0, 1, 26, 0, 1, 26, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
1446
1447-- --------------------------------------------------------
1448
1449--
1450-- Table structure for table `warlogs`
1451--
1452
1453CREATE TABLE IF NOT EXISTS `warlogs` (
1454  `id` int(11) NOT NULL AUTO_INCREMENT,
1455  `PlayerID` int(11) NOT NULL,
1456  `WarID` int(11) NOT NULL,
1457  `Kills` int(11) NOT NULL,
1458  `Deaths` int(11) NOT NULL,
1459  `Faction` int(11) NOT NULL,
1460  PRIMARY KEY (`id`)
1461) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1462
1463-- --------------------------------------------------------
1464
1465--
1466-- Table structure for table `wars`
1467--
1468
1469CREATE TABLE IF NOT EXISTS `wars` (
1470  `id` int(11) NOT NULL AUTO_INCREMENT,
1471  `Time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1472  `Attacker` int(11) NOT NULL,
1473  `Defender` int(11) NOT NULL,
1474  `Atscore` int(11) NOT NULL,
1475  `Defscore` int(11) NOT NULL,
1476  `Result` int(11) NOT NULL,
1477  PRIMARY KEY (`id`)
1478) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
1479
1480/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1481/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1482/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;