· 9 years ago · Nov 13, 2016, 07:32 AM
1-- phpMyAdmin SQL Dump
2-- version 4.2.10.1
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Generation Time: Oct 29, 2016 at 01:00 PM
7-- Server version: 5.5.50-MariaDB
8-- PHP Version: 5.4.16
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: `Real-GameDB`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `banlog`
27--
28
29CREATE TABLE IF NOT EXISTS `banlog` (
30`ID` int(11) NOT NULL,
31 `ip` varchar(25) NOT NULL,
32 `player` varchar(25) NOT NULL,
33 `admin` varchar(25) NOT NULL,
34 `reason` varchar(60) NOT NULL,
35 `time` varchar(60) NOT NULL
36) ENGINE=MyISAM DEFAULT CHARSET=latin1;
37
38-- --------------------------------------------------------
39
40--
41-- Table structure for table `bizz`
42--
43
44CREATE TABLE IF NOT EXISTS `bizz` (
45`ID` int(11) NOT NULL,
46 `Owned` int(11) NOT NULL,
47 `Owner` varchar(25) NOT NULL DEFAULT 'AdmBot',
48 `Message` varchar(50) NOT NULL,
49 `EntranceX` float NOT NULL,
50 `EntranceY` float NOT NULL,
51 `EntranceZ` float NOT NULL,
52 `ExitX` float NOT NULL,
53 `ExitY` float NOT NULL,
54 `ExitZ` float NOT NULL,
55 `LevelNeeded` int(11) NOT NULL,
56 `BuyPrice` int(11) NOT NULL,
57 `EntranceCost` int(11) NOT NULL,
58 `Till` int(11) NOT NULL,
59 `Locked` int(11) NOT NULL,
60 `Interior` int(11) NOT NULL,
61 `Products` int(11) NOT NULL,
62 `MaxProducts` int(11) NOT NULL,
63 `PriceProd` int(11) NOT NULL,
64 `Virtual` int(11) NOT NULL
65) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
66
67--
68-- Dumping data for table `bizz`
69--
70
71INSERT INTO `bizz` (`ID`, `Owned`, `Owner`, `Message`, `EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `EntranceCost`, `Till`, `Locked`, `Interior`, `Products`, `MaxProducts`, `PriceProd`, `Virtual`) VALUES
72(1, 1, 'AdmBot', 'LS Bank', 1462.49, -1012.63, 26.8438, 2306, -16, 27, 10, 500000, 1000, 5331172, 0, 0, 8408, 10000, 100, 0),
73(2, 1, 'AdmBot', 'B4L Gun Shop Los Santos', 1791.52, -1164.86, 23.8281, 316, -142, 1000, 9, 500000, 5000, 1746695, 0, 7, 9502, 10000, 100, 0),
74(3, 1, 'AdmBot', '*** Club ***', 1836.09, -1682.5, 13.3624, 493.46, -24.0736, 1000.68, 4, 500000, 5000, 173257, 0, 17, 9968, 10000, 100, 0),
75(4, 1, 'AdmBot', 'KRYSTAL', 2129.86, -1761.46, 13.5625, -228.27, 1401.07, 27.7656, 3, 500000, 15000, 119777, 0, 18, 9996, 10000, 100, 0),
76(5, 1, 'AdmBot', '*** Strip Club ***', 2421.41, -1220.3, 25.4937, 1204.83, -13.4011, 1000.92, 3, 500000, 5000, 358374, 0, 2, 9880, 10000, 100, 0),
77(6, 1, 'AdmBot', 'CASA ADAM', 1498.5, -1581.31, 13.5498, -794.942, 490.782, 1376.2, 6, 500000, 15000, 0, 0, 1, 562, 1000, 100, 0),
78(7, 1, 'AdmBot', 'Sex Shop ', 1098.8, -1473.6, 15.7969, -100.403, -24.3921, 1000.72, 5, 500000, 15000, 60080, 0, 3, 9992, 10000, 100, 0),
79(8, 1, 'AdmBot', 'Radio Bussines', 1112.43, -1520.66, 15.7969, 1259.39, -804.104, 1084.02, 5, 500000, 5000, 35000, 0, 5, 9851, 10000, 100, 1);
80
81-- --------------------------------------------------------
82
83--
84-- Table structure for table `cars`
85--
86
87CREATE TABLE IF NOT EXISTS `cars` (
88`ID` int(11) NOT NULL,
89 `Model` int(11) NOT NULL,
90 `Locationx` float NOT NULL,
91 `Locationy` float NOT NULL,
92 `Locationz` float NOT NULL,
93 `Angle` float NOT NULL,
94 `ColorOne` int(11) NOT NULL,
95 `ColorTwo` int(11) NOT NULL,
96 `Owner` varchar(25) NOT NULL DEFAULT 'Dealership',
97 `Value` int(20) NOT NULL,
98 `License` varchar(14) NOT NULL DEFAULT 'NewCar',
99 `Description` varchar(50) NOT NULL,
100 `Lockk` int(3) NOT NULL,
101 `Timed` int(11) NOT NULL,
102 `Inscarprice` int(11) NOT NULL,
103 `Insurancecar` int(11) NOT NULL,
104 `KM` float NOT NULL,
105 `Owned` int(11) NOT NULL,
106 `Spawned` int(11) NOT NULL,
107 `Sell` int(11) NOT NULL,
108 `mod1` int(24) NOT NULL,
109 `mod2` int(24) NOT NULL,
110 `mod3` int(24) NOT NULL,
111 `mod4` int(24) NOT NULL,
112 `mod5` int(24) NOT NULL,
113 `mod6` int(24) NOT NULL,
114 `mod7` int(24) NOT NULL,
115 `mod8` int(24) NOT NULL,
116 `mod9` int(24) NOT NULL,
117 `mod10` int(24) NOT NULL,
118 `mod11` int(24) NOT NULL,
119 `mod12` int(24) NOT NULL,
120 `mod13` int(24) NOT NULL,
121 `mod14` int(24) NOT NULL,
122 `mod15` int(24) NOT NULL,
123 `mod16` int(24) NOT NULL,
124 `mod17` int(24) NOT NULL,
125 `PaintJ` int(24) NOT NULL DEFAULT '6'
126) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
127
128-- --------------------------------------------------------
129
130--
131-- Table structure for table `charity`
132--
133
134CREATE TABLE IF NOT EXISTS `charity` (
135`ID` int(11) NOT NULL,
136 `CharityMoney` int(20) NOT NULL
137) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
138
139-- --------------------------------------------------------
140
141--
142-- Table structure for table `factionlog`
143--
144
145CREATE TABLE IF NOT EXISTS `factionlog` (
146`ID` int(11) NOT NULL,
147 `factionid` int(11) NOT NULL,
148 `player` varchar(64) NOT NULL,
149 `action` varchar(64) NOT NULL,
150 `time` varchar(64) NOT NULL
151) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;
152
153-- --------------------------------------------------------
154
155--
156-- Table structure for table `factions`
157--
158
159CREATE TABLE IF NOT EXISTS `factions` (
160`ID` int(11) NOT NULL,
161 `Name` varchar(50) NOT NULL,
162 `X` float NOT NULL,
163 `Y` float NOT NULL,
164 `Z` float NOT NULL,
165 `Mats` int(11) NOT NULL,
166 `Drugs` int(11) NOT NULL,
167 `Bank` int(11) NOT NULL
168) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
169
170--
171-- Dumping data for table `factions`
172--
173
174INSERT INTO `factions` (`ID`, `Name`, `X`, `Y`, `Z`, `Mats`, `Drugs`, `Bank`) VALUES
175(1, 'pd', 0, 0, 0, 0, 0, 0),
176(2, 'fbi', 0, 0, 0, 0, 0, 0),
177(3, 'ng', 0, 0, 0, 0, 0, 0),
178(4, 'Triad', 774.214, -48.9243, 1000.59, 1, 22224, 2441401),
179(5, 'Porrello', 1702.38, -1667.68, 20.2188, 103, 4850, 545109),
180(6, 'Sicillian', 2316.21, -1143.7, 1054.3, 0, -111100, 1705006),
181(7, 'guv', 0, 0, 0, 0, 0, 0),
182(8, 'ttc', 0, 0, 0, 0, 0, 0),
183(9, 'nr', 0, 0, 0, 0, 0, 0),
184(10, 'Rusian', 956.566, -53.9777, 1001.12, 0, 0, 2365001);
185
186-- --------------------------------------------------------
187
188--
189-- Table structure for table `houses`
190--
191
192CREATE TABLE IF NOT EXISTS `houses` (
193`ID` int(11) NOT NULL,
194 `Entrancex` float NOT NULL,
195 `Entrancey` float NOT NULL,
196 `Entrancez` float NOT NULL,
197 `Exitx` float NOT NULL,
198 `Exity` float NOT NULL,
199 `Exitz` float NOT NULL,
200 `Owner` varchar(25) NOT NULL DEFAULT 'The State',
201 `Discription` varchar(50) NOT NULL,
202 `Value` int(20) NOT NULL,
203 `Hel` int(11) NOT NULL,
204 `Arm` int(11) NOT NULL,
205 `Interior` int(11) NOT NULL,
206 `Lockk` int(11) NOT NULL,
207 `Owned` int(11) NOT NULL,
208 `Rent` int(11) NOT NULL,
209 `Rentabil` int(11) NOT NULL,
210 `Takings` int(11) NOT NULL,
211 `Level` int(11) NOT NULL,
212 `Virtual` int(11) NOT NULL
213) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=latin1;
214
215--
216-- Dumping data for table `houses`
217--
218
219INSERT INTO `houses` (`ID`, `Entrancex`, `Entrancey`, `Entrancez`, `Exitx`, `Exity`, `Exitz`, `Owner`, `Discription`, `Value`, `Hel`, `Arm`, `Interior`, `Lockk`, `Owned`, `Rent`, `Rentabil`, `Takings`, `Level`, `Virtual`) VALUES
220(1, 1421.85, -885.64, 50.6647, 225.94, 1022.69, 1084.01, 'AdmBot', 'Vinewood', 3500000, 1, 0, 7, 0, 1, 1, 1, 230, 8, 0),
221(2, 1468.62, -904.898, 54.8359, 225.88, 1022.95, 1084.01, 'AdmBot', 'Nu este de vanzare', 3000000, 1, 0, 7, 1, 1, 1, 1, 717, 8, 1),
222(3, 1539.26, -851.508, 64.3361, 235.188, 1187.54, 1080.26, 'AdmBot', 'Barlogul Lupilor', 1, 1, 0, 3, 0, 1, 1, 1, 15265, 7, 2),
223(4, 1534.06, -800.188, 72.8495, 491.203, 1399.24, 1080.26, 'AdmBot', 'Network Director House', 2000000, 1, 0, 2, 0, 1, 1, 0, 15, 6, 3),
224(5, 1527.3, -773.188, 80.5781, 491.203, 1399.24, 1080.26, 'AdmBot', '.', 2000000, 1, 0, 2, 1, 1, 1, 0, 75363, 6, 4),
225(6, 1497.06, -688.239, 95.5086, 140.325, 1366.66, 1083.86, 'AdmBot', 'Welcome!', 5000000, 1, 0, 5, 1, 1, 0, 1, 0, 20, 5),
226(7, 1112.11, -742.075, 100.133, 227.021, 1114.34, 1081, 'AdmBot', '.', 2500000, 1, 0, 5, 1, 1, 14, 1, 1867, 8, 6),
227(8, 1093.9, -806.597, 107.419, 2196.12, -1204.33, 1049.02, 'AdmBot', 'OZN', 3000000, 0, 0, 6, 0, 1, 1, 1, 53, 6, 7),
228(9, 1034.74, -812.627, 101.852, 447.043, 1397.9, 1084.3, 'AdmBot', 'Lautari', 19000000, 0, 0, 2, 0, 1, 1, 1, 457220, 7, 8),
229(10, 1094.91, -647.068, 113.648, 22.9734, 1404.15, 1084.43, 'AdmBot', 'Vinewood', 4000000, 0, 0, 5, 0, 1, 1, 1, 242, 10, 9),
230(11, 980.352, -676.742, 121.976, 140.17, 1366.07, 1083.65, 'AdmBot', 'The King Club', 20000000, 1, 0, 5, 1, 1, 1, 1, 677, 15, 10),
231(12, 990.004, -828.547, 95.4686, 223.005, 1287.6, 1082.14, 'AdmBot', '. . .', 63000000, 0, 0, 1, 1, 1, 1, 0, 156, 5, 11),
232(13, 937.327, -847.405, 93.7796, 223.005, 1287.6, 1082.14, 'AdmBot', 'MAGNAT', 1500000, 0, 0, 1, 0, 1, 1, 1, 190, 5, 12),
233(14, 836.166, -894.341, 68.7689, 386.402, 1471.7, 1080.19, 'AdmBot', 'MaRiUS. House', 3000000, 1, 0, 15, 0, 1, 1, 1, 369, 7, 13),
234(15, 827.889, -858.718, 70.3308, 376.136, 1417.34, 1081.33, 'AdmBot', 'IMPARAT', 2500000, 1, 0, 15, 1, 1, 1, 1, 128, 6, 14),
235(16, 1981.29, -1718.79, 17.0301, 2495.74, -1692.82, 1014.74, 'AdmBot', 'Casa Manelelor', 3500000, 1, 1, 3, 1, 1, 100, 0, 63191, 6, 15),
236(17, 2495.35, -1690.12, 14.7656, 2496.05, -1692.73, 1014.74, 'AdmBot', 'THE MENTALIST', 2000000, 1, 0, 3, 1, 1, 1, 1, 71, 14, 16),
237(18, 1854.1, -1914.87, 15.2568, 2259.74, -1135.83, 1050.63, 'AdmBot', 'No name', 900000, 1, 0, 10, 1, 1, 1, 1, 60195, 3, 17),
238(19, 1872.32, -1912.36, 15.2568, 2259.86, -1135.86, 1050.63, 'AdmBot', 'Marijuana House.', 5000000, 1, 0, 10, 1, 1, 1, 0, 165, 4, 18),
239(20, 2672.72, -1990.09, 13.9935, 2308.74, -1212.61, 1049.02, 'AdmBot', 'Willowfield', 500000, 1, 0, 6, 0, 1, 1000, 1, 15000, 4, 19),
240(21, 2808, -1176.59, 25.3797, 24.0261, 1340.52, 1084.38, 'AdmBot', 'Nu intra, RISTI BAN ![JR]', 1000000, 1, 0, 10, 0, 1, 1, 1, 17, 9, 20),
241(22, 2519.42, -1112.92, 56.5926, -42.5426, 1406.23, 1084.43, 'AdmBot', 'Las Colinas', 1, 1, 0, 8, 0, 1, 1000, 1, 22000, 5, 21),
242(23, 2191.42, -1276.37, 25.1563, 2233.57, -1114.62, 1050.88, 'AdmBot', 'Tow Truck Company POWA', 900000, 1, 0, 5, 0, 1, 1, 1, 319, 6, 22),
243(24, 2147.98, -1484.88, 26.6241, 235.228, 1187.86, 1080.26, 'AdmBot', 'Vila de Magnati', 1000000, 1, 0, 3, 0, 1, 1, 1, 2145, 6, 23),
244(25, 1905.88, -1113.42, 26.6641, 446.534, 507.182, 1001.42, 'AdmBot', 'VEX`s Residence', 600000, 1, 0, 12, 0, 1, 1, 1, 55, 5, 24),
245(26, 1111.6, -976.003, 42.7656, 300.745, 310.174, 1003.3, 'AdmBot', 'Los Santos', 1500000, 1, 0, 4, 0, 1, 1, 1, 1936, 7, 25),
246(27, 1050.96, -1057.95, 34.7969, 2237.52, -1081.16, 1049.02, 'AdmBot', 'BGS HQ', 950000, 1, 0, 2, 1, 1, 1, 1, 269, 5, 26),
247(28, 850.313, -1520.14, 14.1739, 2365.32, -1134.59, 1050.88, 'AdmBot', '*** Vicious House ***', 2000000, 1, 0, 8, 0, 1, 1, 1, 131, 7, 27),
248(29, 315.85, -1769.75, 4.631, 2196, -1204.32, 1049.02, 'AdmBot', 'Summer Club', 2500000, 1, 1, 6, 0, 1, 1, 0, 51, 10, 28),
249(30, 1804.11, -2124.18, 13.9424, 223.072, 1288.01, 1082.14, 'AdmBot', 'Casa de Bagnati', 1, 1, 1, 1, 1, 1, 15000, 1, 15014, 5, 29),
250(31, 1684.83, -2098.62, 13.8343, 223.021, 1287.73, 1082.14, 'AdmBot', 'Corona House', 4000000, 1, 0, 1, 1, 1, 1, 1, 247, 6, 30),
251(32, 1331.87, -632.87, 109.135, 2317.82, -1026.4, 1050.22, 'AdmBot', 'ZEW', 20500000, 1, 0, 9, 1, 1, 0, 1, 0, 13, 31),
252(33, 300.255, -1154.46, 81.391, 140.075, 1367.21, 1083.86, 'AdmBot', 'Nimic.', 20000000, 1, 0, 5, 1, 1, 1, 1, 14123, 15, 32),
253(34, 977.377, -770.917, 112.203, -42.5781, 1405.96, 1084.43, 'AdmBot', 'SkyFlame SEF', 3000000, 0, 0, 8, 1, 1, 15000, 1, 135000, 7, 33),
254(35, 1247.08, -908.934, 46.6016, 2233.79, -1114.59, 1050.88, 'AdmBot', 'HOUSE DE MAGNATI', 1, 1, 0, 5, 1, 1, 2, 1, 278, 5, 34),
255(36, 1285.05, -904.014, 46.6328, 2217.68, -1076.33, 1050.48, 'AdmBot', '[OC]Kovac Propriety', 1, 1, 0, 1, 1, 1, 1, 0, 183, 5, 35),
256(37, 952.289, -909.99, 45.7656, 234.166, 1064.05, 1084.21, 'AdmBot', '*** Vicious H.Q. ***', 1, 1, 0, 6, 0, 1, 1, 1, 878, 12, 36),
257(38, 1378.71, -1753.22, 14.1406, 2196.09, -1204.05, 1049.02, 'AdmBot', 'Dance Dance Revolution', 10000000, 1, 1, 6, 1, 1, 1, 1, 197, 7, 37),
258(39, 1981.84, -1682.86, 17.0538, 83.0945, 1322.78, 1083.87, 'AdmBot', '4nDrEi95 SafeHouse', 3000000, 1, 1, 9, 1, 1, 1, 0, 102, 6, 38),
259(40, 2385.39, -1712.06, 14.2422, 2495.98, -1692.08, 1014.74, 'AdmBot', 'Camatarii', 25000000, 1, 0, 3, 0, 1, 1, 1, 104, 13, 39),
260(41, 1258.7, -785.379, 92.0302, 225.68, 1021.45, 1084.02, 'AdmBot', 'Semper Superiores', 30000000, 1, 0, 7, 0, 1, 16, 1, 9941, 16, 40),
261(42, 2393.2, -1646.26, 13.9051, 140.325, 1366.66, 1083.86, 'AdmBot', 'MAYBE STAFF', 5000000, 1, 0, 5, 0, 1, 0, 0, 0, 10, 41),
262(43, 2486.52, -1645.6, 14.0772, 2496.05, -1692.73, 1014.74, 'AdmBot', '[¬ ZEW HeadQuarters ¬]', 100000000, 1, 1, 3, 1, 1, 1, 0, 632, 12, 42),
263(44, 2362.77, -1643.74, 14.0649, 225.721, 1022.18, 1084.02, 'AdmBot', 'STAFF', 10000000, 0, 0, 7, 0, 1, 1, 1, 584, 12, 43),
264(45, 254.887, -1366.69, 53.1094, 234.19, 1063.73, 1084.21, 'AdmBot', '*** Vicious House ***', 10000000, 1, 1, 6, 1, 1, 1, 1, 40, 14, 44),
265(46, 189.638, -1308.32, 70.2492, 225.68, 1021.45, 1084.02, 'AdmBot', 'OLD CREW', 20000000, 1, 0, 7, 1, 1, 1, 1, 687, 15, 45),
266(47, 251.765, -1220.67, 75.9508, 235.34, 1186.68, 1080.26, 'AdmBot', 'Agent 47', 15000000, 1, 0, 3, 1, 1, 1, 0, 15745, 14, 46),
267(48, 416.651, -1154.24, 76.6876, 491.07, 1398.5, 1080.26, 'AdmBot', 'Semper Superiores', 7000000, 1, 0, 2, 1, 1, 1, 1, 3333, 10, 47),
268(49, 2384.6, -1675.31, 14.9152, 260.85, 1237.24, 1084.26, 'AdmBot', '||| Steam Name: supermataa ||| ', 5000000, 0, 0, 9, 0, 1, 0, 1, 0, 13, 48),
269(50, 2327.62, -1681.99, 14.9297, 260.85, 1237.24, 1084.26, 'AdmBot', 'Am numa valuta', 6000000, 0, 0, 9, 0, 1, 0, 1, 0, 15, 49),
270(51, 1442.69, -629.352, 95.7186, 225.68, 1021.45, 1084.02, 'AdmBot', 'Cine citeste, pl o beleste', 10000000, 1, 0, 7, 0, 1, 0, 1, 0, 20, 50),
271(52, 253.206, -1270, 74.4307, 140.075, 1367.21, 1083.86, 'AdmBot', 'Casa de Magnati!', 10000000, 1, 0, 5, 1, 1, 0, 1, 0, 15, 51),
272(53, 298.488, -1338.02, 53.4415, 235.34, 1186.68, 1080.26, 'AdmBot', 'Casa De Magnat <3', 15000000, 0, 0, 3, 0, 1, 1, 1, 1589, 15, 52),
273(54, 795.161, -506.891, 18.0129, 1262.14, -785.331, 1091.91, 'AdmBot', 'â„¢MAYOR HOUSEâ„¢ ARMOUR + HEAL', 25000000, 1, 0, 5, 1, 1, 0, 1, 0, 25, 53),
274(55, 854.511, -604.539, 18.4219, 140.17, 1366.07, 1083.65, 'AdmBot', 'Vicious Special', 20000000, 1, 0, 5, 0, 1, 1, 1, 102, 20, 54),
275(56, -691.853, 939.666, 13.6328, 226.3, 1114.24, 1080.99, 'AdmBot', 'C@S@ C|_| V@L0@R3', 15000000, 1, 0, 5, 0, 1, 1, 1, 66, 15, 55);
276
277-- --------------------------------------------------------
278
279--
280-- Table structure for table `iplogs`
281--
282
283CREATE TABLE IF NOT EXISTS `iplogs` (
284`ID` int(11) NOT NULL,
285 `Log` varchar(128) NOT NULL,
286 `time` varchar(64) NOT NULL
287) ENGINE=MyISAM DEFAULT CHARSET=latin1;
288
289-- --------------------------------------------------------
290
291--
292-- Table structure for table `jaillog`
293--
294
295CREATE TABLE IF NOT EXISTS `jaillog` (
296`ID` int(11) NOT NULL,
297 `ip` varchar(25) NOT NULL,
298 `player` varchar(25) NOT NULL,
299 `admin` varchar(25) NOT NULL,
300 `reason` varchar(60) NOT NULL,
301 `min` int(11) NOT NULL,
302 `time` varchar(60) NOT NULL
303) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
304
305-- --------------------------------------------------------
306
307--
308-- Table structure for table `log_admin`
309--
310
311CREATE TABLE IF NOT EXISTS `log_admin` (
312`id` int(11) NOT NULL,
313 `log` varchar(256) NOT NULL,
314 `time` varchar(256) NOT NULL
315) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=latin1;
316
317-- --------------------------------------------------------
318
319--
320-- Table structure for table `papers`
321--
322
323CREATE TABLE IF NOT EXISTS `papers` (
324`ID` int(11) NOT NULL,
325 `PaperUsed` int(11) NOT NULL,
326 `PaperMaker` varchar(40) NOT NULL,
327 `PaperTitle` varchar(40) NOT NULL,
328 `PaperText1` varchar(40) NOT NULL,
329 `PaperText2` varchar(40) NOT NULL,
330 `PaperText3` varchar(40) NOT NULL,
331 `PaperText4` varchar(40) NOT NULL,
332 `PaperText5` varchar(40) NOT NULL,
333 `PaperText6` varchar(40) NOT NULL,
334 `PaperText7` varchar(40) NOT NULL
335) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=latin1;
336
337-- --------------------------------------------------------
338
339--
340-- Table structure for table `sbizz`
341--
342
343CREATE TABLE IF NOT EXISTS `sbizz` (
344`ID` int(11) NOT NULL,
345 `EntranceX` float NOT NULL,
346 `EntranceY` float NOT NULL,
347 `EntranceZ` float NOT NULL,
348 `Owner` varchar(25) NOT NULL,
349 `Discription` varchar(50) NOT NULL,
350 `Owned` int(11) NOT NULL,
351 `LevelNeeded` int(11) NOT NULL,
352 `BuyPrice` int(11) NOT NULL,
353 `EntranceCost` int(11) NOT NULL,
354 `Till` int(11) NOT NULL,
355 `Locked` int(11) NOT NULL,
356 `Interior` int(11) NOT NULL,
357 `Products` int(11) NOT NULL,
358 `MaxProducts` int(11) NOT NULL,
359 `PriceProd` int(11) NOT NULL
360) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=latin1;
361
362--
363-- Dumping data for table `sbizz`
364--
365
366INSERT INTO `sbizz` (`ID`, `EntranceX`, `EntranceY`, `EntranceZ`, `Owner`, `Discription`, `Owned`, `LevelNeeded`, `BuyPrice`, `EntranceCost`, `Till`, `Locked`, `Interior`, `Products`, `MaxProducts`, `PriceProd`) VALUES
367(1, 1116.1, -923.542, 43.3906, 'AdmBot', 'CNN Los Santos, [/ad].', 1, 15, 500000, 5, 3378980, 0, 0, 8446, 10000, 100),
368(2, 1847.46, -1871.76, 13.5781, 'AdmBot', 'The Russian Mafia Property', 1, 5, 500000, 20000, 1079400, 0, 0, 9978, 10000, 100),
369(3, 1868.07, -1394.48, 13.507, 'AdmBot', 'Biciclete Vicious', 1, 3, 500000, 15000, 165000, 0, 0, 9979, 10000, 100),
370(4, 1310.16, -1368.18, 13.5457, 'AdmBot', 'PaintBall Arena', 1, 5, 500000, 5000, 4525000, 0, 0, 7581, 10000, 100),
371(5, 725.604, -1450.44, 17.6953, 'AdmBot', 'Inchiriaza o barca.', 1, 4, 500000, 15000, 60000, 0, 0, 9942, 10000, 100),
372(6, 563.145, -1289.79, 17.2482, 'AdmBot', 'Rent Car', 1, 5, 500000, 15000, 749900, 0, 0, 9972, 10000, 100),
373(7, 1738.19, -1270.06, 13.5438, 'AdmBot', 'Phone Company', 1, 7, 500000, 200, 2100800, 0, 0, 10000, 10000, 100),
374(8, 1766.64, -1363.75, 15.7578, 'AdmBot', 'General Store 24/7', 1, 6, 500000, 750, 3652750, 0, 0, 3725, 10000, 100),
375(9, 1452.2, -1143.22, 24.0332, 'AdmBot', 'General Clothes', 1, 4, 500000, 15000, 1719000, 0, 0, 9974, 10000, 100),
376(10, 2508.27, -1470.36, 24.034, 'AdmBot', 'Tow Car', 1, 6, 500000, 1000, 7404200, 0, 0, 8096, 10000, 100),
377(11, 1702.71, -1470.21, 13.5469, 'AdmBot', 'Triads POWER', 1, 3, 500000, 1000, 444000, 0, 0, 9223, 10000, 100),
378(12, 1412.43, -1700.16, 13.5395, 'AdmBot', '*** Vicious hotdogs ***', 1, 5, 500000, 500000, 66100, 0, 0, 8491, 10000, 100),
379(13, 1941.6, -1764.74, 13.6406, 'AdmBot', 'Gas Company', 1, 5, 500000, 15000, 1381900, 0, 0, 10000, 10000, 100),
380(14, 1422.19, -1487.52, 20.4323, 'AdmBot', 'Electricity Company', 1, 5, 500000, 50000, 685500, 0, 0, 10000, 10000, 100),
381(15, 1173.97, -1361.48, 13.9823, 'AdmBot', 'The Agency - Hospital Los Santos', 1, 9, 500000, 250, 3197800, 0, 0, 10000, 0, 100),
382(16, 1782.14, -1721.43, 13.5474, 'AdmBot', '* Vicious General Eat *', 1, 5, 500000, 15000, 67500, 0, 0, 775, 1000, 100),
383(17, 2074.87, -1831.28, 13.5545, 'AdmBot', 'Pay & Spray', 1, 6, 500000, 1, 9394, 0, 0, 9921, 10000, 100),
384(18, 1025.17, -1032.01, 31.9402, 'AdmBot', 'Pay & Spray', 1, 6, 500000, 3500, 2075300, 0, 0, 9706, 10000, 100),
385(19, 488.382, -1733.06, 11.1752, 'AdmBot', '007', 1, 6, 500000, 5000, 1059900, 0, 0, 9911, 10000, 100),
386(20, 1034.88, -1028.13, 32.1016, 'AdmBot', 'Vicious Tuning', 1, 7, 500000, 15000, 2669800, 0, 0, 9853, 10000, 100),
387(21, 2650.33, -2021.76, 14.1766, 'AdmBot', 'Antonel69', 1, 7, 500000, 15000, 30000, 0, 0, 9997, 10000, 100),
388(22, 2281.49, -2364.65, 13.5469, 'AdmBot', 'Kart Los Santos', 1, 5, 500000, 100, 300, 0, 0, 9997, 10000, 100);
389
390-- --------------------------------------------------------
391
392--
393-- Table structure for table `stock`
394--
395
396CREATE TABLE IF NOT EXISTS `stock` (
397`ID` int(11) NOT NULL,
398 `Stock` int(11) NOT NULL,
399 `Price` int(20) NOT NULL,
400 `Car` varchar(50) NOT NULL
401) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;
402
403--
404-- Dumping data for table `stock`
405--
406
407INSERT INTO `stock` (`ID`, `Stock`, `Price`, `Car`) VALUES
408(1, 30, 45000000, 'Infernus'),
409(2, 30, 3000000, 'Bravura'),
410(3, 30, 30000000, 'Banshee'),
411(4, 30, 10000000, 'Admiral'),
412(5, 30, 30000000, 'Turismo'),
413(6, 30, 15000000, 'Sabre'),
414(7, 30, 20000000, 'Zr-350'),
415(8, 30, 22000000, 'Comet'),
416(9, 30, 15000000, 'Sandking'),
417(10, 30, 8000000, 'NRG'),
418(11, 30, 5000000, 'Fcr-900'),
419(12, 30, 40000000, 'Bullet'),
420(13, 30, 10000000, 'Sultan'),
421(14, 30, 25000000, 'Cheetach'),
422(15, 30, 18000000, 'Elegy'),
423(16, 30, 60000000, 'Hotring'),
424(17, 30, 13000000, 'Savana'),
425(18, 30, 15000000, 'Premier'),
426(19, 30, 50000000, 'Maverick'),
427(20, 30, 40000000, 'sparrow'),
428(21, 30, 5000000, 'Landstalker'),
429(22, 30, 2500000, 'Perenniel'),
430(23, 30, 2800000, 'Bobcat'),
431(24, 30, 3000000, 'Regina'),
432(25, 30, 3100000, 'Burrito'),
433(26, 30, 4000000, 'Intruder'),
434(27, 30, 13000000, 'Slamvan'),
435(28, 30, 20000000, 'Blade'),
436(29, 30, 25000000, 'Hustler'),
437(30, 30, 23000000, 'Merit'),
438(31, 30, 26000000, 'Windsor'),
439(32, 30, 16000000, 'Tahoma'),
440(33, 30, 30000000, 'Huntley'),
441(34, 30, 25000000, 'Buffalo'),
442(35, 30, 21000000, 'Super GT'),
443(36, 30, 19000000, 'Jester'),
444(37, 30, 17000000, 'Flash'),
445(38, 30, 15000000, 'Phoenix'),
446(39, 30, 2000000, 'Faggio'),
447(40, 30, 6000000, 'Freeway'),
448(41, 30, 4000000, 'Sanchez'),
449(42, 30, 3000000, 'Quad'),
450(43, 30, 4500000, 'Wayfarer'),
451(44, 30, 150000000, 'Hotknife'),
452(45, 30, 250000000, 'Monster Truck');
453
454-- --------------------------------------------------------
455
456--
457-- Table structure for table `stuff`
458--
459
460CREATE TABLE IF NOT EXISTS `stuff` (
461`ID` int(11) NOT NULL,
462 `Jackpot` int(20) NOT NULL,
463 `Tax` int(20) NOT NULL,
464 `TaxValue` int(20) NOT NULL,
465 `Security` int(3) NOT NULL
466) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
467
468-- --------------------------------------------------------
469
470--
471-- Table structure for table `turfs`
472--
473
474CREATE TABLE IF NOT EXISTS `turfs` (
475`ID` int(11) NOT NULL,
476 `Owned` int(11) NOT NULL,
477 `Time` int(11) NOT NULL,
478 `MinX` float NOT NULL,
479 `MinY` float NOT NULL,
480 `MaxX` float NOT NULL,
481 `MaxY` float NOT NULL
482) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;
483
484--
485-- Dumping data for table `turfs`
486--
487
488INSERT INTO `turfs` (`ID`, `Owned`, `Time`, `MinX`, `MinY`, `MaxX`, `MaxY`) VALUES
489(1, 10, 0, 114.21, -1364.93, 506.54, -912.91),
490(2, 4, 0, 506.54, -1364.93, 899.25, -912.91),
491(3, 4, 0, 899.25, -1313.7, 1313.58, -912.91),
492(4, 10, 0, 1313.58, -1364.93, 1727.49, -912.91),
493(5, 4, 0, 1727.49, -1364.93, 2108.13, -912.91),
494(6, 4, 0, 2108.13, -1364.93, 2499.38, -912.91),
495(7, 4, 0, 2499.38, -1313.7, 2916.17, -912.91),
496(8, 10, 0, 114.21, -1821.03, 506.54, -1364.93),
497(9, 10, 0, 506.54, -1821.03, 899.25, -1364.93),
498(10, 6, 0, 899.25, -1721.9, 1313.58, -1313.7),
499(11, 4, 0, 1313.58, -1821.03, 1727.49, -1364.93),
500(12, 4, 0, 1727.49, -1821.03, 2108.13, -1364.93),
501(13, 4, 0, 2108.13, -1821.03, 2499.38, -1364.93),
502(14, 4, 0, 2499.38, -1737.65, 2916.17, -1313.7),
503(15, 6, 0, 899.25, -2131.32, 1313.58, -1721.9),
504(16, 6, 0, 899.25, -2489.99, 1313.58, -2131.32),
505(17, 6, 0, 1313.58, -2250.92, 1727.49, -1821.03),
506(18, 4, 0, 1727.49, -2250.92, 2108.13, -1821.03),
507(19, 4, 0, 2108.13, -2250.92, 2499.38, -1821.03),
508(20, 4, 0, 2499.38, -2172.41, 2916.17, -1737.65),
509(21, 4, 0, 1313.58, -2690.47, 1727.49, -2250.92),
510(22, 4, 0, 1727.49, -2690.47, 2108.13, -2250.92),
511(23, 4, 0, 2108.13, -2690.47, 2499.38, -2250.92),
512(24, 4, 0, 2499.38, -2567.91, 2916.17, -2172.41);
513
514-- --------------------------------------------------------
515
516--
517-- Table structure for table `users`
518--
519
520CREATE TABLE IF NOT EXISTS `users` (
521`id` int(11) NOT NULL,
522 `name` varchar(25) NOT NULL,
523 `password` varchar(50) NOT NULL,
524 `Level` int(3) NOT NULL DEFAULT '0',
525 `Admin` int(2) NOT NULL DEFAULT '0',
526 `Helper` int(2) NOT NULL DEFAULT '0',
527 `Premium` int(2) NOT NULL DEFAULT '0',
528 `ConnectedTime` int(11) NOT NULL DEFAULT '0',
529 `Registered` int(2) NOT NULL DEFAULT '0',
530 `Sex` int(2) NOT NULL DEFAULT '0',
531 `Age` int(3) NOT NULL DEFAULT '0',
532 `Origin` int(2) NOT NULL DEFAULT '1',
533 `Muted` int(2) NOT NULL DEFAULT '0',
534 `MuteTime` int(11) NOT NULL DEFAULT '0',
535 `Respect` int(11) NOT NULL DEFAULT '0',
536 `Money` int(11) NOT NULL DEFAULT '0',
537 `Bank` int(11) NOT NULL DEFAULT '0',
538 `Crimes` int(11) NOT NULL DEFAULT '0',
539 `Kills` int(11) NOT NULL DEFAULT '0',
540 `Deaths` int(11) NOT NULL DEFAULT '0',
541 `Arrested` int(11) NOT NULL DEFAULT '0',
542 `WantedDeaths` int(11) NOT NULL DEFAULT '0',
543 `Phonebook` int(2) NOT NULL DEFAULT '0',
544 `LottoNr` int(5) NOT NULL DEFAULT '0',
545 `WantedLevel` int(11) NOT NULL DEFAULT '0',
546 `Fishes` int(3) NOT NULL DEFAULT '0',
547 `RFishes` int(2) NOT NULL DEFAULT '0',
548 `Job` int(3) NOT NULL DEFAULT '0',
549 `Paycheck` int(11) NOT NULL DEFAULT '0',
550 `HeadValue` int(11) NOT NULL DEFAULT '0',
551 `Jailed` int(2) NOT NULL DEFAULT '0',
552 `JailTime` int(11) NOT NULL DEFAULT '0',
553 `Materials` int(11) NOT NULL DEFAULT '0',
554 `Drugs` int(11) NOT NULL DEFAULT '0',
555 `Leader` int(3) NOT NULL DEFAULT '0',
556 `Member` int(3) NOT NULL DEFAULT '0',
557 `Rank` int(2) NOT NULL DEFAULT '0',
558 `CChar` int(11) NOT NULL,
559 `FWarn` int(2) NOT NULL DEFAULT '0',
560 `FPunish` int(4) NOT NULL DEFAULT '0',
561 `Acceptpoints` int(2) NOT NULL DEFAULT '0',
562 `SexSkill` int(11) NOT NULL DEFAULT '0',
563 `LawSkill` int(11) NOT NULL DEFAULT '0',
564 `MechSkill` int(11) NOT NULL DEFAULT '0',
565 `NewsSkill` int(11) NOT NULL DEFAULT '0',
566 `DrugsSkill` int(11) NOT NULL DEFAULT '0',
567 `FishSkill` int(11) NOT NULL DEFAULT '0',
568 `MatSkill` int(11) NOT NULL DEFAULT '0',
569 `RobSkill` int(11) NOT NULL DEFAULT '0',
570 `pHealth` float NOT NULL,
571 `Inter` int(3) NOT NULL DEFAULT '0',
572 `Local` int(11) NOT NULL DEFAULT '0',
573 `Team` int(3) NOT NULL DEFAULT '0',
574 `Model` int(11) NOT NULL,
575 `PhoneNr` int(5) NOT NULL DEFAULT '0',
576 `PhoneCredits` int(4) NOT NULL DEFAULT '0',
577 `House` int(11) NOT NULL DEFAULT '0',
578 `Bizz` int(11) NOT NULL DEFAULT '0',
579 `Radio` int(2) NOT NULL DEFAULT '0',
580 `Pos_x` float NOT NULL,
581 `Pos_y` float NOT NULL,
582 `Pos_z` float NOT NULL,
583 `Rob` int(11) NOT NULL DEFAULT '0',
584 `CarLicT` int(11) NOT NULL DEFAULT '0',
585 `CarLic` int(2) NOT NULL DEFAULT '0',
586 `FlyLicT` int(11) NOT NULL DEFAULT '0',
587 `FlyLic` int(2) NOT NULL DEFAULT '0',
588 `BoatLicT` int(11) NOT NULL DEFAULT '0',
589 `BoatLic` int(2) NOT NULL DEFAULT '0',
590 `FishLicT` int(11) NOT NULL DEFAULT '0',
591 `FishLic` int(2) NOT NULL DEFAULT '0',
592 `GunLicT` int(11) NOT NULL DEFAULT '0',
593 `GunLic` int(2) NOT NULL DEFAULT '0',
594 `PayDay` int(20) NOT NULL DEFAULT '0',
595 `PayDayHad` int(20) NOT NULL DEFAULT '0',
596 `Tutorial` int(2) NOT NULL DEFAULT '0',
597 `Warnings` int(2) NOT NULL DEFAULT '0',
598 `Rented` int(111) NOT NULL DEFAULT '0',
599 `Fuel` int(11) NOT NULL DEFAULT '0',
600 `Married` int(2) NOT NULL DEFAULT '0',
601 `MarriedTo` varchar(25) NOT NULL,
602 `WTalkie` int(2) NOT NULL DEFAULT '0',
603 `Lighter` int(2) NOT NULL DEFAULT '0',
604 `Cigarettes` int(2) NOT NULL DEFAULT '0',
605 `Tow` int(20) NOT NULL DEFAULT '0',
606 `Email` varchar(50) NOT NULL DEFAULT 'email@yahoo.com',
607 `RegisterDate` varchar(50) NOT NULL DEFAULT '01/01/1970 01:01:01',
608 `lastOn` varchar(50) NOT NULL DEFAULT '01/01/1970 01:01:01',
609 `Banned` int(3) NOT NULL DEFAULT '0',
610 `Accusedof` varchar(124) NOT NULL,
611 `Accusing` varchar(64) NOT NULL,
612 `Victim` varchar(64) NOT NULL,
613 `Bplayer` varchar(64) NOT NULL,
614 `ClanTag` varchar(64) NOT NULL,
615 `Clan` int(11) NOT NULL DEFAULT '0',
616 `Radio2` int(2) NOT NULL DEFAULT '0',
617 `Status` int(11) NOT NULL DEFAULT '0',
618 `HitT` int(20) NOT NULL DEFAULT '0',
619 `CRank` int(11) NOT NULL DEFAULT '0',
620 `Phone` int(11) NOT NULL DEFAULT '0',
621 `referral` int(20) NOT NULL DEFAULT '0',
622 `referralp` int(20) NOT NULL DEFAULT '0',
623 `Carkey` int(11) NOT NULL DEFAULT '0',
624 `motokey` int(11) NOT NULL DEFAULT '0',
625 `helikey` int(11) NOT NULL DEFAULT '0',
626 `prcarkey` int(11) NOT NULL DEFAULT '0',
627 `Laptop` int(11) NOT NULL DEFAULT '0'
628) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
629
630--
631-- Dumping data for table `users`
632--
633
634INSERT INTO `users` (`id`, `name`, `password`, `Level`, `Admin`, `Helper`, `Premium`, `ConnectedTime`, `Registered`, `Sex`, `Age`, `Origin`, `Muted`, `MuteTime`, `Respect`, `Money`, `Bank`, `Crimes`, `Kills`, `Deaths`, `Arrested`, `WantedDeaths`, `Phonebook`, `LottoNr`, `WantedLevel`, `Fishes`, `RFishes`, `Job`, `Paycheck`, `HeadValue`, `Jailed`, `JailTime`, `Materials`, `Drugs`, `Leader`, `Member`, `Rank`, `CChar`, `FWarn`, `FPunish`, `Acceptpoints`, `SexSkill`, `LawSkill`, `MechSkill`, `NewsSkill`, `DrugsSkill`, `FishSkill`, `MatSkill`, `RobSkill`, `pHealth`, `Inter`, `Local`, `Team`, `Model`, `PhoneNr`, `PhoneCredits`, `House`, `Bizz`, `Radio`, `Pos_x`, `Pos_y`, `Pos_z`, `Rob`, `CarLicT`, `CarLic`, `FlyLicT`, `FlyLic`, `BoatLicT`, `BoatLic`, `FishLicT`, `FishLic`, `GunLicT`, `GunLic`, `PayDay`, `PayDayHad`, `Tutorial`, `Warnings`, `Rented`, `Fuel`, `Married`, `MarriedTo`, `WTalkie`, `Lighter`, `Cigarettes`, `Tow`, `Email`, `RegisterDate`, `lastOn`, `Banned`, `Accusedof`, `Accusing`, `Victim`, `Bplayer`, `ClanTag`, `Clan`, `Radio2`, `Status`, `HitT`, `CRank`, `Phone`, `referral`, `referralp`, `Carkey`, `motokey`, `helikey`, `prcarkey`, `Laptop`) VALUES
635(1, 'VunKoL', 'stoenesti2002', 10, 1338, 3, 1, 1, 1, 1, 23, 1, 0, 0, 22, 907454763, 9918, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 13, 19254, 0, 0, 0, 0, 0, 4, 4, 7, 296, 0, 0, 0, 0, 0, 0, 0, 0, 3, 0, 0, 100, 0, 0, 5, 250, 16022, 0, 999, 255, 1, 0, 0, 0, 1, 99, 1, 0, 0, 0, 0, 0, 0, 99, 1, 6, 0, 1, 0, 0, 0, 0, '', 1, 10, 10, 0, '@yahoo.com', '28/10/2016 21:43:14', '29 octombrie 2016, ora 15:55', 0, '', '', '', '', '', 0, 0, 0, 0, 0, 2, 0, 0, 2, 0, 0, 3, 1),
636(2, 'Farsky', 'frisca', 60, 6, 3, 1, 1, 1, 1, 25, 1, 0, 0, 2, 1032074162, 9918, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 16536, 0, 0, 0, 0, 0, 11, 11, 7, 294, 0, 0, 0, 0, 0, 0, 3, 0, 0, 0, 0, 100, 0, 0, 11, 294, 5891, 0, 999, 255, 1, 0, 0, 0, 1, 99, 1, 99, 1, 0, 0, 0, 0, 99, 1, 5, 0, 1, 0, 0, 0, 0, '', 0, 0, 0, 0, 'farskyhd32@gmail.com', '28/10/2016 21:43:31', '29 octombrie 2016, ora 15:23', 0, '', '', 'Unknown', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0),
637(3, 'TheArcticFox', 'Tigonul36', 6, 3, 0, 0, 0, 1, 1, 21, 1, 0, 0, 0, 18240, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 5302, 25000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 3, 250, 1908, 0, 999, 255, 1, 0, 0, 0, 0, 100, 1, 100, 1, 0, 0, 0, 0, 100, 1, 4, 0, 1, 0, 0, 0, 0, '', 0, 0, 0, 0, 'cosmin.bungeac02@yahoo.com', '28/10/2016 21:54:0', '28 octombrie 2016, ora 22:22', 0, '', '', '********', '', '', 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0),
638(4, 'Zen.', 'romania', 11, 6, 0, 1, 1, 1, 1, 13, 1, 0, 0, 3, 27016675, 9918, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 14144, 0, 0, 0, 0, 0, 1, 1, 7, 281, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0, 0, 2, 250, 9760, 0, 999, 255, 1, 0, 0, 0, 1, 99, 1, 0, 0, 0, 0, 0, 0, 100, 1, 6, 0, 1, 0, 0, 0, 0, '', 0, 0, 0, 0, 'zen.zew@gmail.com', '29/10/2016 14:1:47', '29 octombrie 2016, ora 15:55', 0, '', '', '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 5, 4, 0, 0, 0);
639
640-- --------------------------------------------------------
641
642--
643-- Table structure for table `warnlog`
644--
645
646CREATE TABLE IF NOT EXISTS `warnlog` (
647`ID` int(11) NOT NULL,
648 `ip` varchar(25) NOT NULL,
649 `player` varchar(25) NOT NULL,
650 `admin` varchar(25) NOT NULL,
651 `reason` varchar(60) NOT NULL,
652 `time` varchar(60) NOT NULL
653) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
654
655--
656-- Indexes for dumped tables
657--
658
659--
660-- Indexes for table `banlog`
661--
662ALTER TABLE `banlog`
663 ADD PRIMARY KEY (`ID`);
664
665--
666-- Indexes for table `bizz`
667--
668ALTER TABLE `bizz`
669 ADD PRIMARY KEY (`ID`);
670
671--
672-- Indexes for table `cars`
673--
674ALTER TABLE `cars`
675 ADD PRIMARY KEY (`ID`);
676
677--
678-- Indexes for table `charity`
679--
680ALTER TABLE `charity`
681 ADD PRIMARY KEY (`ID`);
682
683--
684-- Indexes for table `factionlog`
685--
686ALTER TABLE `factionlog`
687 ADD PRIMARY KEY (`ID`);
688
689--
690-- Indexes for table `factions`
691--
692ALTER TABLE `factions`
693 ADD PRIMARY KEY (`ID`);
694
695--
696-- Indexes for table `houses`
697--
698ALTER TABLE `houses`
699 ADD PRIMARY KEY (`ID`);
700
701--
702-- Indexes for table `iplogs`
703--
704ALTER TABLE `iplogs`
705 ADD PRIMARY KEY (`ID`);
706
707--
708-- Indexes for table `jaillog`
709--
710ALTER TABLE `jaillog`
711 ADD PRIMARY KEY (`ID`);
712
713--
714-- Indexes for table `log_admin`
715--
716ALTER TABLE `log_admin`
717 ADD PRIMARY KEY (`id`);
718
719--
720-- Indexes for table `papers`
721--
722ALTER TABLE `papers`
723 ADD PRIMARY KEY (`ID`);
724
725--
726-- Indexes for table `sbizz`
727--
728ALTER TABLE `sbizz`
729 ADD PRIMARY KEY (`ID`);
730
731--
732-- Indexes for table `stock`
733--
734ALTER TABLE `stock`
735 ADD PRIMARY KEY (`ID`);
736
737--
738-- Indexes for table `stuff`
739--
740ALTER TABLE `stuff`
741 ADD PRIMARY KEY (`ID`);
742
743--
744-- Indexes for table `turfs`
745--
746ALTER TABLE `turfs`
747 ADD PRIMARY KEY (`ID`);
748
749--
750-- Indexes for table `users`
751--
752ALTER TABLE `users`
753 ADD PRIMARY KEY (`id`), ADD UNIQUE KEY `id_2` (`id`), ADD KEY `id` (`id`);
754
755--
756-- Indexes for table `warnlog`
757--
758ALTER TABLE `warnlog`
759 ADD PRIMARY KEY (`ID`);
760
761--
762-- AUTO_INCREMENT for dumped tables
763--
764
765--
766-- AUTO_INCREMENT for table `banlog`
767--
768ALTER TABLE `banlog`
769MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
770--
771-- AUTO_INCREMENT for table `bizz`
772--
773ALTER TABLE `bizz`
774MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=9;
775--
776-- AUTO_INCREMENT for table `cars`
777--
778ALTER TABLE `cars`
779MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=6;
780--
781-- AUTO_INCREMENT for table `charity`
782--
783ALTER TABLE `charity`
784MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
785--
786-- AUTO_INCREMENT for table `factionlog`
787--
788ALTER TABLE `factionlog`
789MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=20;
790--
791-- AUTO_INCREMENT for table `factions`
792--
793ALTER TABLE `factions`
794MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=11;
795--
796-- AUTO_INCREMENT for table `houses`
797--
798ALTER TABLE `houses`
799MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=58;
800--
801-- AUTO_INCREMENT for table `iplogs`
802--
803ALTER TABLE `iplogs`
804MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT;
805--
806-- AUTO_INCREMENT for table `jaillog`
807--
808ALTER TABLE `jaillog`
809MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
810--
811-- AUTO_INCREMENT for table `log_admin`
812--
813ALTER TABLE `log_admin`
814MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=42;
815--
816-- AUTO_INCREMENT for table `papers`
817--
818ALTER TABLE `papers`
819MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=10;
820--
821-- AUTO_INCREMENT for table `sbizz`
822--
823ALTER TABLE `sbizz`
824MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=24;
825--
826-- AUTO_INCREMENT for table `stock`
827--
828ALTER TABLE `stock`
829MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=46;
830--
831-- AUTO_INCREMENT for table `stuff`
832--
833ALTER TABLE `stuff`
834MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
835--
836-- AUTO_INCREMENT for table `turfs`
837--
838ALTER TABLE `turfs`
839MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=25;
840--
841-- AUTO_INCREMENT for table `users`
842--
843ALTER TABLE `users`
844MODIFY `id` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
845--
846-- AUTO_INCREMENT for table `warnlog`
847--
848ALTER TABLE `warnlog`
849MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=2;
850/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
851/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
852/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;