27.03.2016, 13:31
Quote:
|
Originally Posted by Konstantinos
 It may be that from the machine you exported the database it has newer version and you're trying to import it to an older version. You better update to the latest version to both if possible.
Back then, it was reported as "NUL symbols added to the end of database dump file" so try opening the file in notepad++ and check for invalid text. |
PHP код:
-- phpMyAdmin SQL Dump
-- version 4.1.14.8
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: Aug 07, 2015 at 10:34 AM
-- Server version: 5.6.17
-- PHP Version: 5.5.12
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `beGold`
--
-- --------------------------------------------------------
--
-- Table structure for table `bans`
--
CREATE TABLE IF NOT EXISTS `bans` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(25) NOT NULL DEFAULT 'name',
`IP` varchar(16) NOT NULL DEFAULT '000.000.000.000',
`Admin` varchar(25) NOT NULL DEFAULT 'admin',
`Reason` varchar(64) NOT NULL DEFAULT 'reason',
`BanY` int(5) NOT NULL DEFAULT '0',
`BanM` int(5) NOT NULL DEFAULT '0',
`BanD` int(5) NOT NULL DEFAULT '0',
`BanH` int(5) NOT NULL DEFAULT '0',
`UnbanY` int(5) NOT NULL DEFAULT '0',
`UnbanM` int(5) NOT NULL DEFAULT '0',
`UnbanD` int(5) NOT NULL DEFAULT '0',
`UnbanH` int(5) NOT NULL DEFAULT '0',
`Days` int(5) NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`),
UNIQUE KEY `Name` (`Name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `business`
--
CREATE TABLE IF NOT EXISTS `business` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`EntranceX` float NOT NULL,
`EntranceY` float NOT NULL,
`EntranceZ` float NOT NULL,
`ExitX` float NOT NULL,
`ExitY` float NOT NULL,
`ExitZ` float NOT NULL,
`Interior` int(11) NOT NULL,
`Owned` int(11) NOT NULL,
`Owner` varchar(24) NOT NULL,
`Name` varchar(48) NOT NULL,
`Level` int(11) NOT NULL,
`Price` int(11) NOT NULL,
`EntranceCost` int(11) NOT NULL,
`ItemPrice` int(11) NOT NULL,
`Safe` int(11) NOT NULL,
`Locked` int(11) NOT NULL,
`SBiz` int(11) NOT NULL,
`Discription` varchar(65) NOT NULL DEFAULT 'Business Name',
`Virtual` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;
--
-- Dumping data for table `business`
--
INSERT INTO `business` (`ID`, `EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `Interior`, `Owned`, `Owner`, `Name`, `Level`, `Price`, `EntranceCost`, `ItemPrice`, `Safe`, `Locked`, `SBiz`, `Discription`, `Virtual`) VALUES
(1, 1368.36, -1279.82, 13.5469, 314.821, -141.432, 999.602, 7, 0, 'The State', 'Gun Shop Los Santos', 10, 5000000, 3000, 10, 14067201, 0, 0, 'Business Name', 0),
(2, 1461.65, -1011.39, 26.8438, 2935.27, -1803.74, 1191.07, 0, 0, 'The State', 'Bank Los Santos', 10, 5000000, 4000, 10, 462000, 0, 0, 'Banca Los Santos!', 0),
(3, 1000.18, -919.99, 42.3281, -27.2973, -30.5104, 1003.56, 4, 0, 'The State', '24/7 VineWood', 7, 2500000, 5000, 3, 1295510, 0, 0, 'Business Name', 0),
(4, 1833.11, -1842.56, 13.5781, 6.09118, -29.2719, 1003.55, 10, 0, 'The State', '24/7 Taxi', 7, 2500000, 3000, 1, 728313, 0, 0, 'Business Name', 0),
(5, 835.763, -1385.41, 13.5516, 0, 0, 0, 0, 0, 'The State', 'Hot Dog Company', 5, 2000000, 5000, 10, 2300, 1, 1, '<<FULLVIUSS HOTDOG>>', 0),
(6, 564.08, -1293.21, 17.2482, 0, 0, 0, 0, 0, 'The State', 'Rent Car Los Santos', 7, 2500000, 5000, 0, 40000, 1, 1, 'Business Name', 0),
(7, 844.656, -1045.56, 25.4301, 0, 0, 0, 0, 0, 'The State', 'CNN Los Santos', 15, 7000000, 3000, 0, 208000, 1, 1, 'Business Name', 0),
(8, 1509.6, -1060.35, 25.0625, 0, 0, 0, 0, 0, 'The State', 'Phone Company', 15, 7000000, 3000, 10, 1260950, 1, 1, 'Business Name', 0),
(9, 921.751, -1298.76, 14.0938, 0, 0, 0, 0, 0, 'The State', 'Vehicle Tow Company', 25, 6000000, 1, 0, 893, 1, 1, 'Business Name', 0),
(10, 1024.84, -1030.51, 32.0454, 0, 0, 0, 0, 0, 'The State', 'Pay ''N Spray', 7, 3500000, 2000, 0, 180000, 1, 1, 'Business Name', 0),
(11, 2072.74, -1831.4, 13.5469, 0, 0, 0, 0, 0, 'The State', 'Pay ''N Spray', 7, 2500000, 2000, 0, 2000, 1, 1, 'Business Name', 0),
(12, 488.535, -1733.87, 11.1803, 0, 0, 0, 0, 0, 'The State', 'Pay ''N Spray', 7, 2500000, 5000, 0, 365000, 1, 1, 'Business Name', 0),
(13, 1457.43, -1137.64, 23.9772, 161.38, -96.1595, 1001.8, 18, 0, 'The State', 'ZIP', 5, 2000000, 5000, 0, 205000, 0, 0, 'Business Name', 0),
(14, 1025.26, -946.644, 42.4563, 0, 0, 0, 0, 0, 'The State', 'Gas Station', 7, 14000000, 3000, 0, 96810, 1, 1, 'Business Name', 0),
(15, 1928.82, -1776.28, 13.5469, 0, 0, 0, 0, 0, 'The State', 'Gas Station', 10, 3000000, 1, 0, 5, 1, 1, 'Business Name', 0),
(16, -78.9478, -1169.66, 2.1507, 0, 0, 0, 0, 0, 'The State', 'Gas Station', 10, 3000000, 1, 0, 0, 1, 1, 'Business Name', 0),
(17, 1836.55, -1682.49, 13.343, 493.391, -22.7228, 1000.68, 17, 0, 'The State', 'Alhambra Night Club', 5, 2500000, 3000, 0, 213700, 0, 0, 'Business Name', 0),
(18, 1172.73, -1323.29, 15.4015, 0, 0, 0, 0, 0, 'The State', 'Los Santos Hospital', 10, 5000000, 1000, 0, 743500, 1, 1, 'Spitalul Judetean LS', 0),
(19, 1310.07, -1367.32, 13.5286, 0, 0, 0, 0, 0, 'The State', 'PaintBall Los Santos', 8, 4000000, 3000, 0, 12000, 0, 1, 'Doar pentru Campioni', 0),
(20, 1035.01, -1028.12, 32.1016, 0, 0, 0, 0, 0, 'The State', 'Transfender Los Santos', 7, 3000000, 10000, 0, 905000, 1, 1, 'Business Name', 0),
(21, 2650.37, -2021.85, 14.1766, 0, 0, 0, 0, 0, 'The State', 'Loco Low Los Santos', 7, 2500000, 1, 0, 3, 1, 1, 'Business Name', 0),
(22, 1607.42, -1560.3, 14.1787, 0, 0, 0, 0, 0, 'The State', 'Vehicle Color', 10, 5000000, 10000, 0, 2570000, 1, 1, 'Business Name', 0),
(23, 1471.06, -1177.85, 23.9209, 0, 0, 0, 0, 0, 'The State', 'Insurance and Vehicle Registrations', 10, 5000000, 10000, 0, 11760, 1, 1, 'Business Name', 0),
(24, 1498.42, -1581.28, 13.5498, -794.981, 490.535, 1376.2, 1, 0, 'The State', 'Restaurant LS', 5, 3000000, 1, 0, 0, 1, 0, 'Business Name', 0),
(25, 2695.72, -1704.75, 11.844, 0, 0, 0, 7, 1, '4nDrEi95[GF]', 'Racing Arena', 10, 10000000, 3000, 0, 0, 1, 1, 'Curse cu masini.', 0),
(26, 1631.85, -1172.57, 24.0843, -2158.85, 642.589, 1052.38, 1, 0, 'The State', 'Inside Betting', 99, 5000000, 0, 1, 0, 0, 0, 'Business Name', 0),
(27, 660.988, -573.418, 16.3359, -27.2973, -30.5104, 1003.56, 4, 0, 'The State', '24/7 Dillimore', 7, 7000000, 1, 1, 509, 0, 0, 'Business Name', 1),
(28, 720.089, -464.703, 16.3359, 0, 0, 0, 0, 0, 'The State', 'Pay ''N Spray', 7, 7000000, 0, 1, 0, 0, 0, 'Business Name', 0),
(29, 655.789, -564.87, 16.336, 0, 0, 0, 0, 0, 'The State', 'Gas Station ', 7, 10000000, 5000, 1, 0, 0, 1, 'Mall Romania', 0);
-- --------------------------------------------------------
--
-- Table structure for table `clans`
--
CREATE TABLE IF NOT EXISTS `clans` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`Tag` varchar(24) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`TagType` int(11) NOT NULL DEFAULT '0',
`Slots` int(11) NOT NULL DEFAULT '0',
`HQType` int(11) NOT NULL DEFAULT '0',
`HouseHQ` int(11) NOT NULL DEFAULT '0',
`News` varchar(128) NOT NULL DEFAULT '0',
`WWars` int(11) NOT NULL DEFAULT '0',
`Best` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `clans`
--
INSERT INTO `clans` (`ID`, `Name`, `Tag`, `TagType`, `Slots`, `HQType`, `HouseHQ`, `News`, `WWars`, `Best`) VALUES
(1, 'asd', '[asd]', 0, 12, 0, 0, '0', 0, 0),
(2, 'Gangster''s Family', '[GF]', 1, 20, 0, 0, '0', 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `dealer1`
--
CREATE TABLE IF NOT EXISTS `dealer1` (
`Model` int(11) NOT NULL DEFAULT '0',
`Price` int(11) NOT NULL DEFAULT '0',
`Stock` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`Model`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `dealer1`
--
INSERT INTO `dealer1` (`Model`, `Price`, `Stock`) VALUES
(400, 1000000, 2),
(401, 500000, 1),
(410, 300000, 3),
(436, 350000, 1),
(507, 800000, 2),
(555, 500000, 1),
(587, 2000000, 2);
-- --------------------------------------------------------
--
-- Table structure for table `dealer2`
--
CREATE TABLE IF NOT EXISTS `dealer2` (
`Model` int(11) NOT NULL DEFAULT '0',
`Price` int(11) NOT NULL DEFAULT '0',
`Stock` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`Model`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `dealer2`
--
INSERT INTO `dealer2` (`Model`, `Price`, `Stock`) VALUES
(426, 1700000, 2),
(439, 1000000, 1),
(475, 1500000, 0),
(477, 2700000, 2),
(506, 2500000, 1),
(533, 1500000, 2),
(579, 3200000, 0),
(589, 1500000, 1),
(602, 1750000, 1),
(603, 1000000, 0);
-- --------------------------------------------------------
--
-- Table structure for table `dealer3`
--
CREATE TABLE IF NOT EXISTS `dealer3` (
`Model` int(11) NOT NULL DEFAULT '0',
`Price` int(11) NOT NULL DEFAULT '0',
`Stock` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`Model`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `dealer3`
--
INSERT INTO `dealer3` (`Model`, `Price`, `Stock`) VALUES
(402, 3700000, 0),
(411, 10000000, 0),
(415, 6500000, 1),
(429, 6700000, 0),
(444, 30000000, 0),
(451, 7000000, 0),
(480, 3500000, 3),
(494, 25000000, 0),
(495, 5000000, 0),
(541, 8000000, 0),
(559, 3300000, 1),
(560, 5300000, 0),
(562, 3000000, 2);
-- --------------------------------------------------------
--
-- Table structure for table `dealer4`
--
CREATE TABLE IF NOT EXISTS `dealer4` (
`Model` int(11) NOT NULL DEFAULT '0',
`Price` int(11) NOT NULL DEFAULT '0',
`Stock` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`Model`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `dealer4`
--
INSERT INTO `dealer4` (`Model`, `Price`, `Stock`) VALUES
(461, 2000000, 2),
(468, 1500000, 2),
(471, 1200000, 2),
(481, 300000, 5),
(510, 350000, 2),
(522, 7000000, 0),
(581, 1500000, 2),
(586, 1000000, 2);
-- --------------------------------------------------------
--
-- Table structure for table `dealer5`
--
CREATE TABLE IF NOT EXISTS `dealer5` (
`Model` int(11) NOT NULL DEFAULT '0',
`Price` int(11) NOT NULL DEFAULT '0',
`Stock` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`Model`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `dealer5`
--
INSERT INTO `dealer5` (`Model`, `Price`, `Stock`) VALUES
(469, 7500000, 1),
(487, 14000000, 0);
-- --------------------------------------------------------
--
-- Table structure for table `factionlogs`
--
CREATE TABLE IF NOT EXISTS `factionlogs` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`FactionID` int(11) NOT NULL DEFAULT '0',
`Leader` int(11) NOT NULL DEFAULT '0',
`Player` int(11) NOT NULL DEFAULT '0',
`Text` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
`Date` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Table structure for table `feed`
--
CREATE TABLE IF NOT EXISTS `feed` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`time` bigint(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Dumping data for table `feed`
--
INSERT INTO `feed` (`id`, `text`, `time`) VALUES
(1, '~3~ has been kicked from the server by ~1~,reason: ihh', 1425759412),
(2, '~2~ has been permanently banned by ~1~', 1425760215),
(3, '~3~ was kicked by admin ~5~, reason: e', 1426102605);
-- --------------------------------------------------------
--
-- Table structure for table `houses`
--
CREATE TABLE IF NOT EXISTS `houses` (
`ID` int(11) NOT NULL,
`EntranceX` float NOT NULL,
`EntranceY` float NOT NULL,
`EntranceZ` float NOT NULL,
`ExitX` float NOT NULL,
`ExitY` float NOT NULL,
`ExitZ` float NOT NULL,
`Owner` varchar(24) NOT NULL,
`Value` int(11) NOT NULL,
`Interior` int(11) NOT NULL,
`Lock` int(11) NOT NULL,
`Owned` int(11) NOT NULL,
`Rent` int(11) NOT NULL,
`Rentable` int(11) NOT NULL,
`Safe` int(11) NOT NULL,
`Level` int(11) NOT NULL,
`World` int(11) NOT NULL,
`SellPrice` int(8) NOT NULL DEFAULT '0',
`Type` int(11) NOT NULL,
`Name` varchar(64) NOT NULL DEFAULT 'House Name',
PRIMARY KEY (`ID`),
UNIQUE KEY `ID` (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `houses`
--
INSERT INTO `houses` (`ID`, `EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `Owner`, `Value`, `Interior`, `Lock`, `Owned`, `Rent`, `Rentable`, `Safe`, `Level`, `World`, `SellPrice`, `Type`, `Name`) VALUES
(1, 1475.04, -2174.21, 14.2855, 2270.38, -1210.35, 1047.56, 'The State', 700000, 10, 1, 0, 1, 1, 0, 7, 1, 0, 0, 'House Name'),
(2, 1505.94, -2174.38, 14.2855, 2270.38, -1210.35, 1047.56, 'The State', 700000, 10, 0, 0, 1, 1, 2658, 7, 2, 3000000, 0, 'Casa magnatilor!'),
(3, 1536.84, -2174.43, 14.2855, 2270.38, -1210.35, 1047.56, 'The State', 700000, 10, 1, 0, 1, 1, 718, 7, 3, 0, 0, 'House Name'),
(4, 1565.09, -2177.54, 14.7616, 261.12, 1284.3, 1080.26, 'The State', 500000, 4, 1, 0, 1, 1, 104, 5, 4, 0, 0, 'House Name'),
(5, 1589.7, -2177.71, 14.7616, 261.12, 1284.3, 1080.26, 'The State', 500000, 4, 1, 0, 1, 1, 894, 5, 5, 0, 0, 'House Name'),
(6, 1614.36, -2177.55, 14.7616, 261.12, 1284.3, 1080.26, 'The State', 500000, 4, 1, 0, 1000, 1, 11000, 5, 6, 0, 0, 'House Name'),
(7, 1638.92, -2177.47, 14.7616, 261.12, 1284.3, 1080.26, 'The State', 500000, 4, 1, 0, 1000, 1, 3000, 5, 7, 0, 0, 'House Name'),
(8, 1421.91, -886.231, 50.6864, 2365.31, -1135.6, 1050.88, 'The State', 1000000, 8, 0, 0, 1, 1, 897, 10, 8, 13000000, 0, 'AlexuTzu''s house!'),
(9, 1468.56, -906.184, 54.8359, 2365.31, -1135.6, 1050.88, 'The State', 1000000, 8, 0, 0, 1000, 1, 146000, 10, 9, 0, 0, 'House Name'),
(10, 1540.47, -851.482, 64.3361, 225.68, 1021.45, 1084.02, 'The State', 1200000, 7, 0, 0, 1, 1, 9, 12, 10, 0, 0, 'House Name'),
(11, 1535.04, -800.332, 72.8495, 2196.85, -1204.25, 1049.02, 'The State', 80000, 6, 0, 0, 1, 1, 91, 8, 11, 0, 0, 'House Name'),
(12, 1527.89, -772.661, 80.5781, 2196.85, -1204.25, 1049.02, 'The State', 80000, 6, 0, 0, 1, 1, 224, 8, 12, 3000000, 0, 'House Name'),
(13, 1496.98, -687.894, 95.5633, 140.17, 1366.07, 1083.65, 'The State', 12000000, 5, 0, 0, 1, 1, 242, 20, 13, 0, 0, 'House Name'),
(14, 1111.49, -976.443, 42.7656, 221.92, 1140.2, 1082.61, 'The State', 600000, 4, 0, 0, 1000, 1, 7000, 5, 14, 2150000, 0, 'House Name'),
(15, 1050.97, -1059.3, 34.7966, 2270.38, -1210.35, 1047.56, 'The State', 700000, 10, 0, 0, 100, 1, 300, 7, 15, 0, 0, 'House Name'),
(16, 865.246, -1633.88, 14.9297, 2270.38, -1210.35, 1047.56, 'The State', 700000, 10, 1, 0, 1000, 1, 0, 7, 16, 0, 0, 'House Name'),
(17, 936.936, -1612.72, 14.9374, 2270.38, -1210.35, 1047.56, 'The State', 700000, 10, 1, 0, 1, 1, 1049, 7, 17, 0, 0, 'Cuba , Cuba!!'),
(18, 965.184, -1612.61, 14.9409, 2270.38, -1210.35, 1047.56, 'The State', 700000, 10, 1, 0, 1, 0, 0, 7, 18, 0, 0, 'House Name'),
(19, 987.498, -1624.49, 14.9297, 2270.38, -1210.35, 1047.56, 'The State', 700000, 10, 1, 0, 1, 1, 0, 7, 19, 0, 0, 'House Name'),
(20, 893.721, -1635.7, 14.9297, 2270.38, -1210.35, 1047.56, 'The State', 700000, 10, 0, 0, 100, 1, 1652, 7, 20, 0, 0, 'House Name'),
(21, 2250.32, -1280.05, 25.4766, 2237.59, -1081.64, 1049.02, 'The State', 500000, 2, 1, 0, 100, 1, 110, 5, 21, 0, 0, 'House Name'),
(22, 2191.58, -1275.6, 25.1562, 2237.59, -1081.64, 1049.02, 'The State', 500000, 2, 0, 0, 500, 1, 6795, 5, 22, 0, 0, 'House Name'),
(23, 2132.36, -1280.05, 25.8906, 2237.59, -1081.64, 1049.02, 'The State', 500000, 2, 1, 0, 1, 1, 41, 5, 23, 0, 0, 'House Name'),
(24, 2100.85, -1321.89, 25.9531, 2237.59, -1081.64, 1049.02, 'The State', 500000, 2, 0, 0, 200, 1, 207, 5, 24, 0, 0, 'House Name'),
(25, 2126.73, -1320.87, 26.6241, 24.04, 1340.17, 1084.38, 'The State', 1800000, 10, 1, 0, 1, 1, 0, 8, 25, 0, 0, 'House Name'),
(26, 1854.03, -1914.54, 15.2568, 2365.31, -1135.6, 1050.88, 'The State', 300000, 8, 1, 0, 155, 1, 28226, 3, 26, 0, 0, 'House Name'),
(27, 1872.23, -1912.13, 15.2568, 2365.31, -1135.6, 1050.88, 'The State', 300000, 8, 0, 0, 1, 1, 63, 3, 27, 0, 0, 'House Name'),
(28, 1891.9, -1914.69, 15.2568, 2365.31, -1135.6, 1050.88, 'The State', 300000, 8, 1, 0, 1, 1, 205, 3, 28, 0, 0, 'House Name'),
(29, 1913.46, -1911.99, 15.2568, 2365.31, -1135.6, 1050.88, 'The State', 300000, 8, 1, 0, 1, 1, 2, 3, 29, 0, 0, 'House Name'),
(30, 1928.63, -1916.12, 15.2568, 2365.31, -1135.6, 1050.88, 'The State', 300000, 8, 0, 0, 1, 1, 3, 3, 30, 0, 0, 'House Name'),
(31, 1938.48, -1911.31, 15.2568, 2365.31, -1135.6, 1050.88, 'The State', 300000, 8, 1, 0, 500, 1, 6000, 3, 31, 0, 0, 'House Name'),
(32, 952.554, -909.608, 45.7656, 225.68, 1021.45, 1084.02, 'The State', 1500000, 7, 1, 0, 1, 1, 1800, 15, 32, 0, 0, 'House Name'),
(33, 1804.22, -2124.9, 13.9424, 2196.85, -1204.25, 1049.02, 'The State', 150000, 6, 0, 0, 100, 1, 5593, 3, 33, 0, 0, 'House Name'),
(34, 1801.98, -2098.94, 14.021, 2196.85, -1204.25, 1049.02, 'The State', 150000, 6, 1, 0, 1, 1, 64, 3, 34, 0, 0, 'House Name'),
(35, 2065.19, -1703.48, 14.1484, 2196.85, -1204.25, 1049.02, 'The State', 500000, 6, 1, 0, 1, 0, 42, 5, 35, 0, 0, 'House Name'),
(36, 2018.24, -1703.32, 14.234, 2196.85, -1204.25, 1049.02, 'The State', 500000, 6, 1, 0, 69, 1, 7828, 3, 36, 0, 0, 'House Name'),
(37, 2015.35, -1732.65, 14.234, 2196.85, -1204.25, 1049.02, 'The State', 500000, 6, 1, 0, 10, 1, 1196, 3, 37, 5000000, 0, 'House Name'),
(38, 2150.92, -1419.19, 25.922, 377.15, 1417.41, 1081.33, 'The State', 1000000, 15, 1, 0, 1000, 1, 51314, 5, 38, 2500000, 0, 'House Name'),
(39, 2090.99, -1277.83, 26.18, 446.99, 1397.07, 1084.3, 'The State', 1000000, 2, 1, 0, 10, 1, 1600, 25, 39, 0, 0, 'House Name'),
(40, 2250, -1238.91, 25.898, 377.15, 1417.41, 1081.33, 'The State', 1000000, 15, 1, 0, 1, 1, 0, 5, 40, 0, 0, 'House Name'),
(41, 854.525, -604.362, 18.422, 2317.89, -1026.76, 1050.22, 'The State', 1000000, 9, 1, 0, 1, 1, 27, 55, 41, 0, 0, 'House Name'),
(42, 1284.35, -904.031, 46.633, 2196.85, -1204.25, 1049.02, 'The State', 1000000, 6, 1, 0, 1, 1, 10, 5, 42, 0, 0, 'House Name'),
(43, 1291.84, -903.059, 46.633, 2196.85, -1204.25, 1049.02, 'The State', 1000000, 6, 1, 0, 1, 1, 15, 5, 43, 0, 0, 'House Name'),
(44, 1291.02, -896.863, 46.625, 2196.85, -1204.25, 1049.02, 'The State', 1000000, 6, 0, 0, 1, 1, 11, 5, 44, 0, 0, 'House Name'),
(45, 1283.53, -897.823, 46.625, 2196.85, -1204.25, 1049.02, 'The State', 1000000, 6, 1, 0, 1, 1, 140, 5, 45, 0, 0, 'House Name'),
(46, 1245.4, -902.815, 46.594, 2196.85, -1204.25, 1049.02, 'The State', 1000000, 6, 1, 0, 1, 0, 0, 5, 46, 0, 0, 'House Name'),
(47, 1252.9, -901.895, 46.594, 2196.85, -1204.25, 1049.02, 'The State', 1000000, 6, 1, 0, 1, 0, 0, 5, 47, 0, 0, 'House Name'),
(48, 1253.71, -908.071, 46.602, 2196.85, -1204.25, 1049.02, 'The State', 1000000, 6, 1, 0, 1, 0, 0, 5, 48, 0, 0, 'House Name'),
(49, 1246.21, -909.005, 46.602, 2196.85, -1204.25, 1049.02, 'The State', 1000000, 6, 0, 0, 1, 1, 0, 5, 49, 0, 0, 'House Name'),
(50, 2756.31, -1182.81, 69.403, 2196.85, -1204.25, 1049.02, 'The State', 500000, 6, 0, 0, 1000, 1, 12000, 3, 50, 0, 0, 'House Name'),
(51, 1111.96, -742.271, 100.133, 225.68, 1021.45, 1084.02, 'The State', 20000000, 7, 0, 0, 1000, 1, 22001, 9, 51, 0, 0, 'House Name'),
(52, 1094.01, -806.757, 107.419, 2365.31, -1135.6, 1050.88, 'The State', 4500000, 8, 1, 0, 1, 1, 4, 9, 52, 0, 0, 'House Name'),
(53, 836.073, -894.782, 68.769, 226.3, 1114.24, 1080.99, 'The State', 9200000, 5, 0, 0, 69, 1, 5530, 9, 53, 0, 0, 'House Name'),
(54, 1034.69, -812.567, 101.852, 2196.85, -1204.25, 1049.02, 'The State', 2500000, 6, 0, 0, 1000, 1, 47000, 7, 54, 0, 0, 'House Name'),
(55, 989.578, -828.264, 95.469, 2196.85, -1204.25, 1049.02, 'The State', 2500000, 6, 0, 0, 1000, 1, 17000, 7, 55, 0, 0, 'House Name'),
(56, 653.593, -1714.09, 14.765, 261.12, 1284.3, 1080.26, 'The State', 2500000, 4, 1, 0, 1, 0, 0, 6, 56, 0, 0, 'House Name'),
(57, 657.228, -1652.69, 15.406, 261.12, 1284.3, 1080.26, 'The State', 1500000, 4, 1, 0, 69, 1, 552, 5, 57, 0, 0, 'House Name'),
(58, 652.876, -1619.85, 15, -42.59, 1405.47, 1084.43, 'The State', 2500000, 8, 1, 0, 69, 1, 6348, 6, 58, 2500000, 0, 'House Name'),
(59, 692.884, -1602.78, 15.047, -42.59, 1405.47, 1084.43, 'The State', 1500000, 8, 1, 0, 200, 1, 0, 5, 59, 0, 0, 'House Name'),
(60, 2148.9, -1484.94, 26.624, 235.34, 1186.68, 1080.26, 'The State', 2200000, 3, 1, 0, 1000, 1, 19031, 7, 60, 0, 0, 'House Name'),
(61, 2146.28, -1470.53, 25.712, 2468.84, -1698.24, 1013.51, 'The State', 1500000, 2, 1, 0, 1, 0, 0, 5, 61, 0, 0, 'House Name'),
(62, 2149.56, -1433.73, 25.975, 2468.84, -1698.24, 1013.51, 'The State', 1500000, 2, 1, 0, 1000, 1, 0, 5, 62, 0, 0, 'House Name'),
(63, 1442.69, -628.832, 95.719, 235.34, 1186.68, 1080.26, 'The State', 3500000, 3, 1, 0, 350, 1, 25220, 8, 63, 0, 0, 'House Name'),
(64, 827.759, -858.005, 70.331, 446.99, 1397.07, 1084.3, 'The State', 5000000, 2, 1, 0, 1, 1, 0, 9, 64, 9000000, 0, 'Like a FeaR'),
(65, 980.305, -677.376, 121.976, 140.17, 1366.07, 1083.65, 'The State', 1, 5, 0, 0, 1000, 0, 0, 99, 65, 0, 0, 'House Name'),
(66, 251.48, -1220.39, 76.102, 2317.89, -1026.76, 1050.22, 'The State', 23200000, 9, 0, 0, 1000, 1, 1000, 12, 66, 0, 0, 'House Name'),
(67, 1094.94, -647.562, 113.648, 226.3, 1114.24, 1080.99, 'The State', 17500000, 5, 1, 0, 1, 1, 63, 10, 67, 0, 0, 'House Name');
-- --------------------------------------------------------
--
-- Table structure for table `lostpass`
--
CREATE TABLE IF NOT EXISTS `lostpass` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL,
`email` varchar(255) NOT NULL,
`ip` varchar(50) NOT NULL,
`token` varchar(255) NOT NULL,
`time` bigint(20) NOT NULL,
`expire` bigint(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `lostpass`
--
INSERT INTO `lostpass` (`id`, `userid`, `email`, `ip`, `token`, `time`, `expire`) VALUES
(1, 5, 'hulea.andrei95@yahoo.com', '176.223.8.244', '1e03777509cd5cf1ce922db148e5ff4042c41cbe', 1426099978, 1426186378);
-- --------------------------------------------------------
--
-- Table structure for table `mdc`
--
CREATE TABLE IF NOT EXISTS `mdc` (
`ID` int(11) NOT NULL,
`Crime1` varchar(32) NOT NULL DEFAULT 'None',
`Crime1W` int(11) NOT NULL DEFAULT '0',
`Crime2` varchar(32) NOT NULL DEFAULT 'None',
`Crime2W` int(11) NOT NULL DEFAULT '0',
`Crime3` varchar(32) NOT NULL DEFAULT 'None',
`Crime3W` int(11) NOT NULL DEFAULT '0',
`Crime4` varchar(32) NOT NULL DEFAULT 'None',
`Crime4W` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Dumping data for table `mdc`
--
INSERT INTO `mdc` (`ID`, `Crime1`, `Crime1W`, `Crime2`, `Crime2W`, `Crime3`, `Crime3W`, `Crime4`, `Crime4W`) VALUES
(1, 'None', 0, 'None', 0, 'None', 0, 'None', 0),
(3, 'None', 0, 'None', 0, 'None', 0, 'None', 0),
(5, 'None', 0, 'None', 0, 'None', 0, 'None', 0),
(6, 'None', 0, 'None', 0, 'None', 0, 'None', 0),
(8, 'None', 0, 'None', 0, 'None', 0, 'None', 0),
(9, 'None', 0, 'None', 0, 'None', 0, 'None', 0);
-- --------------------------------------------------------
--
-- Table structure for table `newss`
--
CREATE TABLE IF NOT EXISTS `newss` (
`message` varchar(250) NOT NULL,
`author` varchar(21) NOT NULL,
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `newss`
--
INSERT INTO `newss` (`message`, `author`, `date`) VALUES
('Valoare d-aia mare.', 'CoZmIn', '0000-00-00 00:00:00'),
('06.03.2015', 'CoZmIn', '2015-03-04 22:31:02');
-- --------------------------------------------------------
--
-- Table structure for table `notifications`
--
CREATE TABLE IF NOT EXISTS `notifications` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userid` int(11) NOT NULL,
`text` text NOT NULL,
`time` bigint(20) NOT NULL,
`seen` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
--
-- Dumping data for table `notifications`
--
INSERT INTO `notifications` (`id`, `userid`, `text`, `time`, `seen`) VALUES
(1, 1, 'You have been promoted to admin level 2 by admin ~3~.', 1425847313, 1),
(2, 1, 'You have been promoted to helper by admin ~3~', 1425847653, 1);
-- --------------------------------------------------------
--
-- Table structure for table `others`
--
CREATE TABLE IF NOT EXISTS `others` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`Charity` int(11) NOT NULL DEFAULT '0',
`Tax` int(11) NOT NULL DEFAULT '1',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `others`
--
INSERT INTO `others` (`ID`, `Charity`, `Tax`) VALUES
(1, 39322329, 100);
-- --------------------------------------------------------
--
-- Table structure for table `players`
--
CREATE TABLE IF NOT EXISTS `players` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`Name` varchar(25) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'name',
`AName` varchar(25) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'aname',
`Password` varchar(64) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'password',
`Level` int(11) NOT NULL DEFAULT '1',
`AdminLevel` int(11) NOT NULL DEFAULT '0',
`HelperLevel` int(11) NOT NULL DEFAULT '0',
`Cash` int(24) NOT NULL DEFAULT '25000',
`Account` int(24) NOT NULL DEFAULT '50000',
`Email` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'email@default.com',
`Registred` int(11) NOT NULL DEFAULT '0',
`Tutorial` int(11) NOT NULL DEFAULT '0',
`Sex` int(11) NOT NULL DEFAULT '0',
`Age` int(11) NOT NULL DEFAULT '0',
`PhoneNumber` int(11) NOT NULL DEFAULT '0',
`PhoneBook` int(11) NOT NULL DEFAULT '0',
`WalkieTalkie` int(11) NOT NULL DEFAULT '0',
`Lighter` int(11) NOT NULL DEFAULT '0',
`Cigarettes` int(11) NOT NULL DEFAULT '0',
`PremiumAccount` int(11) NOT NULL DEFAULT '0',
`Respect` int(11) NOT NULL DEFAULT '0',
`PayCheck` int(11) NOT NULL DEFAULT '0',
`PayDay` int(11) NOT NULL DEFAULT '0',
`PayDayHad` int(11) NOT NULL DEFAULT '0',
`HoursPlayed` int(11) NOT NULL DEFAULT '0',
`Leader` int(11) NOT NULL DEFAULT '0',
`Member` int(11) NOT NULL DEFAULT '0',
`Rank` int(11) NOT NULL DEFAULT '0',
`Skin` int(11) NOT NULL DEFAULT '299',
`FWarns` int(11) NOT NULL DEFAULT '0',
`FPunish` int(11) NOT NULL DEFAULT '0',
`Warns` int(11) NOT NULL DEFAULT '0',
`Muted` int(11) NOT NULL DEFAULT '0',
`MuteTime` int(24) NOT NULL DEFAULT '0',
`DrivingLic` int(11) NOT NULL DEFAULT '0',
`FlyingLic` int(11) NOT NULL DEFAULT '0',
`GunLic` int(11) NOT NULL DEFAULT '0',
`SailLic` int(11) NOT NULL DEFAULT '0',
`FishingLic` int(11) NOT NULL DEFAULT '0',
`BiggestFish` int(11) NOT NULL DEFAULT '0',
`Job` int(11) NOT NULL DEFAULT '0',
`StockPile` int(11) NOT NULL DEFAULT '0',
`Wanted` int(11) NOT NULL DEFAULT '0',
`WantedLost` int(11) NOT NULL DEFAULT '1800',
`Jailed` int(11) NOT NULL DEFAULT '0',
`JailTime` int(11) NOT NULL DEFAULT '0',
`Bail` int(11) NOT NULL DEFAULT '0',
`Materials` int(11) NOT NULL DEFAULT '0',
`Drugs` int(11) NOT NULL DEFAULT '0',
`HouseKey` int(11) NOT NULL DEFAULT '0',
`RentKey` int(11) NOT NULL DEFAULT '0',
`BizzKey` int(11) NOT NULL DEFAULT '0',
`HeadValue` int(24) NOT NULL DEFAULT '0',
`Contracted` int(11) NOT NULL DEFAULT '0',
`Contract` varchar(25) CHARACTER SET latin1 COLLATE latin1_general_ci DEFAULT 'No-one',
`ContractTime` int(24) NOT NULL DEFAULT '0',
`TowPoints` int(11) NOT NULL DEFAULT '0',
`SpawnChange` int(11) NOT NULL DEFAULT '1',
`AJailed` int(11) NOT NULL DEFAULT '0',
`AJailTime` int(11) NOT NULL DEFAULT '0',
`Referral` int(11) NOT NULL DEFAULT '-1',
`Rob` int(11) NOT NULL DEFAULT '0',
`FreePoints` int(11) NOT NULL DEFAULT '0',
`CLeader` int(11) NOT NULL DEFAULT '0',
`CMember` int(11) NOT NULL DEFAULT '0',
`CRank` int(11) NOT NULL DEFAULT '0',
`Kills` int(11) NOT NULL DEFAULT '0',
`Deaths` int(11) NOT NULL DEFAULT '0',
`Crimes` int(11) NOT NULL DEFAULT '0',
`Arrests` int(11) NOT NULL DEFAULT '0',
`WantedDeaths` int(11) NOT NULL DEFAULT '0',
`VehicleSlots` int(11) NOT NULL DEFAULT '3',
`TruckerSkill` int(11) NOT NULL DEFAULT '0',
`GarbageSkill` int(11) NOT NULL DEFAULT '0',
`RobSkill` int(11) NOT NULL DEFAULT '0',
`MechanicSkill` int(11) NOT NULL DEFAULT '0',
`FarmerSkill` int(11) NOT NULL DEFAULT '0',
`WoodSkill` int(11) NOT NULL DEFAULT '0',
`PizzaSkill` int(11) NOT NULL DEFAULT '0',
`TReferralRespect` int(11) NOT NULL DEFAULT '0',
`TReferralMoney` int(11) NOT NULL DEFAULT '0',
`ReferralRespect` int(11) NOT NULL DEFAULT '0',
`ReferralMoney` int(11) NOT NULL DEFAULT '0',
`PlayerPickups` varchar(256) NOT NULL DEFAULT '0',
`Achievements` varchar(128) NOT NULL DEFAULT '0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0',
`Coins` int(11) NOT NULL DEFAULT '0',
`MoneyBoost` int(11) NOT NULL DEFAULT '0',
`RPBoost` int(11) NOT NULL DEFAULT '0',
`TutVeh` int(11) NOT NULL DEFAULT '0',
`Fuel` int(11) NOT NULL DEFAULT '0',
`Status` int(11) NOT NULL DEFAULT '0',
`RegisteredDate` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '01/01/2013 00:00',
`LastLogin` varchar(128) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '01/01/2013 00:00',
`Gift` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `players`
--
INSERT INTO `players` (`ID`, `Name`, `AName`, `Password`, `Level`, `AdminLevel`, `HelperLevel`, `Cash`, `Account`, `Email`, `Registred`, `Tutorial`, `Sex`, `Age`, `PhoneNumber`, `PhoneBook`, `WalkieTalkie`, `Lighter`, `Cigarettes`, `PremiumAccount`, `Respect`, `PayCheck`, `PayDay`, `PayDayHad`, `HoursPlayed`, `Leader`, `Member`, `Rank`, `Skin`, `FWarns`, `FPunish`, `Warns`, `Muted`, `MuteTime`, `DrivingLic`, `FlyingLic`, `GunLic`, `SailLic`, `FishingLic`, `BiggestFish`, `Job`, `StockPile`, `Wanted`, `WantedLost`, `Jailed`, `JailTime`, `Bail`, `Materials`, `Drugs`, `HouseKey`, `RentKey`, `BizzKey`, `HeadValue`, `Contracted`, `Contract`, `ContractTime`, `TowPoints`, `SpawnChange`, `AJailed`, `AJailTime`, `Referral`, `Rob`, `FreePoints`, `CLeader`, `CMember`, `CRank`, `Kills`, `Deaths`, `Crimes`, `Arrests`, `WantedDeaths`, `VehicleSlots`, `TruckerSkill`, `GarbageSkill`, `RobSkill`, `MechanicSkill`, `FarmerSkill`, `WoodSkill`, `PizzaSkill`, `TReferralRespect`, `TReferralMoney`, `ReferralRespect`, `ReferralMoney`, `PlayerPickups`, `Achievements`, `Coins`, `MoneyBoost`, `RPBoost`, `TutVeh`, `Fuel`, `Status`, `RegisteredDate`, `LastLogin`, `Gift`) VALUES
(1, 'sprites', 'aname', '8677DB5F1D63BB3C8D981ACF327244A0', 10, 7, 1, 8038960, 64150, 'spritesbzone@yahoo.com', 1, 1, 1, 20, 8503598, 0, 0, 0, 0, 1, 1, 5100, 17, 1, 1, 1, 0, 7, 60, 0, 0, 0, 0, 0, 99, 99, 99, 99, 1, 0, 0, 0, 0, 1800, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'No-one', 0, 0, 2, 0, 0, 0, 1, 1, 1, 0, 6, 4, 1, 0, 0, 0, 3, 0, 0, 0, 0, 0, 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|1|0|0|1', 300, 0, 0, 1, 0, 0, '05/03/2015 - 23:11:21', '06/03/2015 - 14:23:40', 0),
(2, '[asd]spritesm', 'spritesm', '8677DB5F1D63BB3C8D981ACF327244A0', 2, 3, 1, 25000, 50000, 'asd@yahoo.com', 1, 1, 1, 20, 8503596, 0, 0, 0, 0, 1, 0, 600, 3, 0, 0, 0, 0, 0, 60, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1800, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'No-one', 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 3, 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|0|0|0|0|0|0|0|0|0|1', 100, 0, 0, 0, 0, 0, '05/03/2015 - 23:11:21', '05/03/2015 - 23:10:59', 0),
(3, '[asd]Calvin.', 'Calvin.', '4297f44b13955235245b2497399d7a93', 10, 6, 0, 1897251, 119091, 'email@default.com', 1, 1, 1, 19, 0, 0, 0, 0, 0, 0, 4, 7800, 26, 0, 4, 0, 1, 4, 217, 0, 0, 0, 0, 0, 96, 96, 96, 96, 1, 0, 6, 0, 0, 1800, 0, 0, 0, 202, 0, 0, 0, 0, 0, 0, 'No-one', 0, 0, 1, 0, 0, -1, 4, 3, 0, 1, 4, 1, 7, 0, 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0|0|1|0|0|0|0|0|0|0|1|0|0|0|0|0|1|0|0|0|0|0|0|0|0|1', 400, 0, 0, 1, 0, 0, '01/01/2013 00:00', '06/08/2015 - 12:59:27', 0),
(4, 'infinity.', 'aname', '26CAE7718C32180A7A0F8E19D6D40A59', 1, 0, 0, 25000, 50000, 'infinity289@yahoo.com', 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 299, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1800, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'No-one', 0, 0, 1, 0, 0, 1, 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|0|0|0|0|0|0|0|0|0|0', 0, 0, 0, 0, 0, 0, '01/01/2013 00:00', '01/01/2013 00:00', 0),
(5, '4nDrEi95[GF]', '4nDrEi95', '202CB962AC59075B964B07152D234B70', 10, 8, 3, 6245031, 127578, 'hulea.andrei95@yahoo.com', 1, 1, 1, 18, 0, 0, 0, 0, 0, 0, 9, 16500, 55, 0, 8, 11, 0, 7, 217, 0, 0, 1, 0, 0, 992, 992, 992, 992, 1, 146, 9, 0, 0, 1800, 0, 0, 0, -202, 0, 0, 0, 25, 0, 0, 'No-one', 0, 0, 1, 0, 0, 0, 8, 0, 2, 0, 0, 2, 2, 0, 0, 0, 5, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', '0|0|1|1|1|0|0|0|0|1|1|1|0|0|0|0|1|0|0|0|0|0|0|0|0|1', 800, 0, 0, 1, 0, 1, '08/03/2015 - 20:22:04', '07/08/2015 - 11:27:16', 0),
(6, 'Omega', 'aname', 'E9E41ADEDDD1AE4E1AF25354A4EBD051', 1, 6, 0, 25000, 50000, 'fwef@yahoo.com', 1, 1, 1, 8, 0, 0, 0, 0, 0, 0, 0, 7500, 15, 0, 0, 1, 0, 7, 217, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1800, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'No-one', 0, 0, 1, 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|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1', 200, 0, 0, 0, 0, 0, '08/03/2015 - 20:24:40', '08/03/2015 - 20:35:51', 0),
(7, '[GF]Vlad', 'aname', 'FA8A5434B34FF417C871D0423AD17D82', 1, 0, 0, 25000, 50000, 'email@default.com', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 299, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1800, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'No-one', 0, 0, 1, 0, 0, -1, 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|0|0|0|0|0|0|0|0|0|0', 0, 0, 0, 0, 0, 0, '01/01/2013 00:00', '01/01/2013 00:00', 0),
(8, '[GF]Vlad.', '[GF]Vlad.', '42B0188AB59213B8B570E6D3B7B4222B', 3, 7, 1, 50000, 58350, 'vladutz_vladutzz6@yahoo.com', 1, 1, 1, 18, 9540630, 0, 0, 0, 0, 0, 1, 4600, 23, 0, 1, 11, 0, 7, 113, 0, 0, 0, 0, 0, 0, 0, 99, 0, 1, 0, 0, 0, 0, 1800, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'No-one', 0, 0, 1, 0, 0, 0, 1, 0, 0, 0, 0, 0, 1, 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|1|1|1|0|0|0|0|0|0|0|0|0|1|0|0|0|1', 500, 0, 0, 1, 0, 1, '05/08/2015 - 14:11:11', '07/08/2015 - 11:27:19', 0),
(9, 'Hover', 'aname', '425601542ED8174666919CF54348CEC4', 2, 4, 0, 38000, 50000, 'over_hover@yahoo.com', 1, 1, 1, 15, 7074354, 0, 0, 0, 0, 0, 1, 2400, 12, 0, 0, 8, 0, 7, 217, 0, 0, 0, 0, 0, 1000, 1000, 1000, 1000, 1, 0, 0, 0, 0, 1800, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'No-one', 0, 0, 1, 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|1|1|0|0|0|0|0|0|0|0|0|0|0|0|0|1', 300, 0, 0, 1, 0, 0, '06/08/2015 - 17:22:43', '06/08/2015 - 17:38:58', 0);
-- --------------------------------------------------------
--
-- Table structure for table `safes`
--
CREATE TABLE IF NOT EXISTS `safes` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`PosX` float NOT NULL DEFAULT '0',
`PosY` float NOT NULL DEFAULT '0',
`PosZ` float NOT NULL DEFAULT '0',
`Money` int(11) NOT NULL DEFAULT '0',
`Drugs` int(11) NOT NULL DEFAULT '0',
`Materials` int(11) NOT NULL DEFAULT '0',
`News` varchar(128) NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;
--
-- Dumping data for table `safes`
--
INSERT INTO `safes` (`ID`, `PosX`, `PosY`, `PosZ`, `Money`, `Drugs`, `Materials`, `News`) VALUES
(1, 226.858, 81.5722, 1005.04, 0, 0, 0, '0'),
(2, 292.829, 188.262, 1007.17, 0, 0, 0, '0'),
(3, 0, 0, 0, 0, 0, 0, '0'),
(4, 1492.11, 1304.44, 1093.3, 0, 0, 0, '0'),
(5, -2025.93, -114.18, 1035.17, 0, 0, 0, '0'),
(6, -1226.3, -90.616, 14.4761, 0, 0, 0, '0'),
(7, 2195.45, 1610.83, 999.968, 0, 0, 0, '0'),
(8, 1723.06, -1673.16, 20.2232, 0, 0, 0, '0'),
(9, 970.355, -43.3238, 1001.12, 0, 0, 0, '0'),
(10, 2315.28, -1135, 1054.3, 0, 0, 0, '0'),
(11, 1260.9, -772.721, 1091.91, 0, 0, 0, '0');
-- --------------------------------------------------------
--
-- Table structure for table `vehicles`
--
CREATE TABLE IF NOT EXISTS `vehicles` (
`CarID` int(10) unsigned NOT NULL AUTO_INCREMENT,
`Model` int(24) NOT NULL DEFAULT '410',
`Color1` int(24) NOT NULL DEFAULT '0',
`Color2` int(24) NOT NULL DEFAULT '0',
`Price` int(24) NOT NULL DEFAULT '0',
`Owner` varchar(24) NOT NULL DEFAULT 'Unbought',
`vPosX` float NOT NULL DEFAULT '0',
`vPosY` float NOT NULL DEFAULT '0',
`vPosZ` float NOT NULL DEFAULT '0',
`vPosA` float NOT NULL DEFAULT '0',
`Plate` varchar(24) NOT NULL DEFAULT 'AG:RP',
`PaintJ` int(24) NOT NULL DEFAULT '6',
`Locked` int(24) NOT NULL DEFAULT '0',
`Spawned` int(24) NOT NULL DEFAULT '0',
`Destroyed` int(24) NOT NULL DEFAULT '0',
`Km` float NOT NULL DEFAULT '0',
`Neon` int(24) NOT NULL DEFAULT '0',
`Fuel` int(11) NOT NULL DEFAULT '100',
`Type` int(11) NOT NULL DEFAULT '0',
`vMod1` int(24) NOT NULL DEFAULT '0',
`vMod2` int(24) NOT NULL DEFAULT '0',
`vMod3` int(24) NOT NULL DEFAULT '0',
`vMod4` int(24) NOT NULL DEFAULT '0',
`vMod5` int(24) NOT NULL DEFAULT '0',
`vMod6` int(24) NOT NULL DEFAULT '0',
`vMod7` int(24) NOT NULL DEFAULT '0',
`vMod8` int(24) NOT NULL DEFAULT '0',
`vMod9` int(24) NOT NULL DEFAULT '0',
`vMod10` int(24) NOT NULL DEFAULT '0',
`vMod11` int(24) NOT NULL DEFAULT '0',
`vMod12` int(24) NOT NULL DEFAULT '0',
`vMod13` int(24) NOT NULL DEFAULT '0',
`vMod14` int(24) NOT NULL DEFAULT '0',
`vMod15` int(24) NOT NULL DEFAULT '0',
`vMod16` int(24) NOT NULL DEFAULT '0',
`vMod17` int(24) NOT NULL DEFAULT '0',
PRIMARY KEY (`CarID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;
--
-- Dumping data for table `vehicles`
--
INSERT INTO `vehicles` (`CarID`, `Model`, `Color1`, `Color2`, `Price`, `Owner`, `vPosX`, `vPosY`, `vPosZ`, `vPosA`, `Plate`, `PaintJ`, `Locked`, `Spawned`, `Destroyed`, `Km`, `Neon`, `Fuel`, `Type`, `vMod1`, `vMod2`, `vMod3`, `vMod4`, `vMod5`, `vMod6`, `vMod7`, `vMod8`, `vMod9`, `vMod10`, `vMod11`, `vMod12`, `vMod13`, `vMod14`, `vMod15`, `vMod16`, `vMod17`) VALUES
(1, 411, 0, 0, 0, 'sprites', 0, 0, 0, 0, 'AG:RP', 6, 0, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(2, 462, 0, 0, 0, 'sprites', 1542.84, -2210.94, 13.154, 180.792, 'New Car', 6, 1, 1, 0, 0, 0, 100, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(3, 462, 0, 0, 0, 'Calvin.', 1560.72, -2257.47, 13.146, 91.607, 'New Car', 6, 1, 1, 0, 0, 0, 100, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(4, 462, 0, 0, 0, '4nDrEi95[GF]', 1505.44, -2362.1, 13.149, 0.485, 'New Car', 6, 1, 1, 0, 0, 0, 100, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(5, 410, 0, 0, 300000, '4nDrEi95[GF]', 303.503, -1486.05, 24.321, 235.125, 'New Car', 6, 1, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(6, 436, 0, 0, 350000, '4nDrEi95[GF]', 303.503, -1486.05, 24.321, 235.125, 'New Car', 6, 1, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(7, 401, 0, 0, 500000, '4nDrEi95[GF]', 303.503, -1486.05, 24.321, 235.125, 'New Car', 6, 1, 0, 0, 0, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(8, 462, 0, 0, 0, '[GF]Vlad.', 1546.09, -2361.7, 13.154, 359.001, 'New Car', 6, 1, 1, 0, 0, 0, 100, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(9, 462, 0, 0, 0, 'Hover', 1505.52, -2211.4, 13.151, 181.269, 'New Car', 6, 1, 1, 0, 0, 0, 100, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `zones`
--
CREATE TABLE IF NOT EXISTS `zones` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`MinX` float NOT NULL DEFAULT '0',
`MinY` float NOT NULL DEFAULT '0',
`MaxX` float NOT NULL DEFAULT '0',
`MaxY` float NOT NULL DEFAULT '0',
`Team` int(11) NOT NULL DEFAULT '0',
`Hours` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;
--
-- Dumping data for table `zones`
--
INSERT INTO `zones` (`ID`, `MinX`, `MinY`, `MaxX`, `MaxY`, `Team`, `Hours`) VALUES
(1, 114.21, -1364.93, 506.54, -912.91, 11, 0),
(2, 506.54, -1364.93, 899.25, -912.91, 11, 0),
(3, 899.25, -1313.7, 1313.58, -912.91, 11, 0),
(4, 1313.58, -1364.93, 1727.49, -912.91, 10, 0),
(5, 1727.49, -1364.93, 2108.13, -912.91, 9, 0),
(6, 2108.13, -1364.93, 2499.38, -912.91, 9, 0),
(7, 2499.38, -1313.7, 2916.17, -912.91, 9, 0),
(8, 114.21, -1821.03, 506.54, -1364.93, 11, 0),
(9, 506.54, -1821.03, 899.25, -1364.93, 11, 0),
(10, 899.25, -1721.9, 1313.58, -1313.7, 11, 0),
(11, 1313.58, -1821.03, 1727.49, -1364.93, 10, 0),
(12, 1727.49, -1821.03, 2108.13, -1364.93, 8, 0),
(13, 2108.13, -1821.03, 2499.38, -1364.93, 8, 0),
(14, 2499.38, -1737.65, 2916.17, -1313.7, 9, 0),
(15, 899.25, -2131.32, 1313.58, -1721.9, 10, 0),
(16, 899.25, -2489.99, 1313.58, -2131.32, 10, 0),
(17, 1313.58, -2250.92, 1727.49, -1821.03, 10, 0),
(18, 1727.49, -2250.92, 2108.13, -1821.03, 8, 0),
(19, 2108.13, -2250.92, 2499.38, -1821.03, 8, 0),
(20, 2499.38, -2172.41, 2916.17, -1737.65, 9, 0),
(21, 1313.58, -2690.47, 1727.49, -2250.92, 10, 0),
(22, 1727.49, -2690.47, 2108.13, -2250.92, 8, 0),
(23, 2108.13, -2690.47, 2499.38, -2250.92, 8, 0),
(24, 2499.38, -2567.91, 2916.17, -2172.41, 9, 0);
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;