Problema upbload baza de date

Master18 · August 28, 2015

Nu stiu de ce imi da asa http://i.imgur.com/PoRpsub.png

Ma puteti ajuta varog mult

EquiNoxAdv · August 30, 2015

Try now.

-- phpMyAdmin SQL Dump
-- version 4.1.14.5
-- http://www.phpmyadmin.net
--
-- Host: 93.119.26.250:3306
-- Generation Time: 14 Noi 2014 la 14:49
-- Server version: 5.5.39-36.0-log
-- PHP Version: 5.4.32
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 */;
--
-- Baza de date: `zp_hid9114`
--
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `adminlog`
--
CREATE TABLE IF NOT EXISTS `adminlog` (
`entryID` int(11) NOT NULL AUTO_INCREMENT,
`value` varchar(255) NOT NULL,
`entryTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`tickcount` int(12) NOT NULL DEFAULT '0',
PRIMARY KEY (`entryID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
--
-- Salvarea datelor din tabel `adminlog`
--
INSERT INTO `adminlog` (`entryID`, `value`, `entryTime`, `tickcount`) VALUES
(1, 'FloriynScr has cleared the chat.', '2014-12-20 19:35:20', 24469769),
(2, 'Admin FloriynScr has spawned FloriynScr.', '2014-12-21 11:18:47', 4960235),
(3, 'Admin FloriynScr has spawned FloriynScr.', '2014-12-21 11:23:26', 5237988),
(4, 'Admin FloriynScr has spawned FloriynScr.', '2014-12-21 11:23:28', 5240175),
(5, 'Admin FloriynScr has spawned FloriynScr.', '2014-12-21 11:23:29', 5241222),
(6, 'FloriynScr has cleared the chat.', '2014-12-21 12:53:58', 10655916),
(7, 'FloriynScr has cleared the chat.', '2014-12-21 12:54:23', 10681322),
(8, 'FloriynScr has cleared the chat.', '2014-12-21 12:54:25', 10683488),
(9, 'Admin FloriynScr has spawned FloriynScr.', '2014-12-22 08:04:38', 6571039),
(10, 'Admin FloriynScr has spawned FloriynScr.', '2014-12-22 08:28:05', 7974710),
(11, 'Admin FloriynScr has spawned FloriynScr.', '2014-12-22 08:32:16', 8224302),
(12, 'Admin FloriynScr has spawned FloriynScr.', '2014-12-22 09:15:49', 10831396),
(13, 'Admin FloriynScr has spawned FloriynScr.', '2014-12-23 10:04:16', 10586068),
(14, 'Admin BogdanScr. has spawned BogdanScr..', '2015-01-06 13:13:24', 1725213);
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `aplications`
--
CREATE TABLE IF NOT EXISTS `aplications` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`intrebarea1` text NOT NULL,
`status` int(69) NOT NULL DEFAULT '0',
`factionid` int(69) NOT NULL DEFAULT '0',
`playerid` int(69) NOT NULL,
`intrebarea2` text NOT NULL,
`intrebarea3` text NOT NULL,
`intrebarea4` text NOT NULL,
`intrebarea5` text NOT NULL,
`intrebarea6` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `assets`
--
CREATE TABLE IF NOT EXISTS `assets` (
`assetID` int(6) NOT NULL AUTO_INCREMENT,
`assetName` varchar(255) NOT NULL DEFAULT '(null)',
`assetValue` varchar(255) NOT NULL DEFAULT '(null)',
`Status` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`assetID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `atms`
--
CREATE TABLE IF NOT EXISTS `atms` (
`atmId` int(11) NOT NULL AUTO_INCREMENT,
`atmPosX` varchar(128) NOT NULL,
`atmPosY` varchar(128) NOT NULL,
`atmPosZ` varchar(128) NOT NULL,
`atmPosRotX` varchar(128) NOT NULL,
`atmPosRotY` varchar(128) NOT NULL,
`atmPosRotZ` varchar(128) NOT NULL,
PRIMARY KEY (`atmId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;
--
-- Salvarea datelor din tabel `atms`
--
INSERT INTO `atms` (`atmId`, `atmPosX`, `atmPosY`, `atmPosZ`, `atmPosRotX`, `atmPosRotY`, `atmPosRotZ`) VALUES
(1, '2228.39', '-1707.78', '13.25', '0', '0', '270.0'),
(2, '2228.39', '-1707.78', '13.25', '0', '0', '270.0'),
(3, '1275.7958984375', '368.31481933594', '19.19758605957', '0', '0', '73.759948730469'),
(4, '1260.8796386719', '209.30152893066', '19.19758605957', '0', '0', '65.504638671875'),
(5, '2303.4577636719', '-13.539554595947', '26.12727355957', '0', '0', '272.43542480469'),
(6, '2316.1015625', '-88.522567749023', '26.12727355957', '0', '0', '0'),
(7, '1155.6235351563', '-1464.9141845703', '15.44321346283', '0', '0', '290.21020507813'),
(8, '387.16552734375', '-1816.0512695313', '7.4834146499634', '0', '0', '272.48046875'),
(9, '-24.385023117065', '-92.001075744629', '1003.1897583008', '0', '0', '180.54052734375'),
(10, '-31.811220169067', '-58.106018066406', '1003.1897583008', '0', '0', '181.21594238281'),
(11, '1212.7785644531', '2.451762676239', '1000.5647583008', '0', '0', '0'),
(12, '2324.4028320313', '-1644.9445800781', '14.469946861267', '0', '0', '0'),
(13, '651.19305419922', '-520.48815917969', '15.978837013245', '0', '0', '0'),
(14, '691.08215332031', '-618.5625', '15.978837013245', '0', '0', '268.69067382813'),
(15, '45.78035736084', '-291.80926513672', '1.5024013519287', '0', '0', '182.93444824219'),
(16, '173.23471069336', '-155.07606506348', '1.2210245132446', '0', '0', '89.730041503906'),
(17, '294.80', '-84.01', '1001.0', '0.00000000', '0.00000000', '90.00000000'),
(18, '2065.439453125', '-1897.5510253906', '13.19670009613', '0', '0', '0'),
(19, '1497.7467041016', '-1749.8747558594', '15.088212013245', '0', '0', '177.38134765625'),
(20, '2093.5124511719', '-1359.5474853516', '23.62727355957', '0', '0', '0'),
(21, '2139.4487304688', '-1164.0811767578', '23.63508605957', '0', '0', '91.309509277344'),
(22, '1482.7761230469', '-1010.3353881836', '26.48664855957', '0', '0', '0'),
(23, '-1835.60144043', '63.24560547', '1054.83203125', '0.00000000', '0.00000000', '270.00000000'),
(24, '-1835.59985352', '64.59873199', '1054.83203125', '0.00000000', '0.00000000', '270.00000000');
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `banksuspensions`
--
CREATE TABLE IF NOT EXISTS `banksuspensions` (
`transactionID` int(32) NOT NULL AUTO_INCREMENT,
`suspendeeID` int(32) NOT NULL,
`playerID` int(32) NOT NULL,
`suspensionReason` varchar(128) NOT NULL,
PRIMARY KEY (`transactionID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `bans`
--
CREATE TABLE IF NOT EXISTS `bans` (
`banID` int(12) NOT NULL AUTO_INCREMENT,
`playerNameBanned` varchar(24) NOT NULL,
`playerBanReason` varchar(512) NOT NULL,
`playerBanDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`IPBanned` varchar(32) NOT NULL,
`playerBannedBy` varchar(24) NOT NULL DEFAULT 'System',
PRIMARY KEY (`banID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `bugs`
--
CREATE TABLE IF NOT EXISTS `bugs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`playerid` int(11) NOT NULL DEFAULT '0',
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`type` int(11) NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `bugscomments`
--
CREATE TABLE IF NOT EXISTS `bugscomments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`bugid` int(11) NOT NULL,
`playerid` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `businesses`
--
CREATE TABLE IF NOT EXISTS `businesses` (
`businessID` int(6) NOT NULL AUTO_INCREMENT,
`businessName` varchar(32) NOT NULL DEFAULT '(null)',
`businessOwner` varchar(24) NOT NULL DEFAULT 'Nobody',
`businessType` int(6) NOT NULL DEFAULT '0',
`businessExteriorX` varchar(255) NOT NULL DEFAULT '0',
`businessExteriorY` varchar(255) NOT NULL DEFAULT '0',
`businessExteriorZ` varchar(255) NOT NULL DEFAULT '0',
`businessInteriorX` varchar(255) NOT NULL DEFAULT '0',
`businessInteriorY` varchar(255) NOT NULL DEFAULT '0',
`businessInteriorZ` varchar(255) NOT NULL DEFAULT '0',
`businessInterior` int(6) NOT NULL DEFAULT '0',
`businessLock` int(6) NOT NULL DEFAULT '1',
`businessPrice` int(12) NOT NULL DEFAULT '0',
`businessVault` int(12) NOT NULL DEFAULT '0',
`businessMiscX` varchar(255) NOT NULL DEFAULT '0.0',
`businessMiscY` varchar(255) NOT NULL DEFAULT '0.0',
`businessMiscZ` varchar(255) NOT NULL DEFAULT '0.0',
`businessEnterPrice` int(12) NOT NULL DEFAULT '1',
`businessLevel` int(6) NOT NULL DEFAULT '0',
PRIMARY KEY (`businessID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;
--
-- Salvarea datelor din tabel `businesses`
--
INSERT INTO `businesses` (`businessID`, `businessName`, `businessOwner`, `businessType`, `businessExteriorX`, `businessExteriorY`, `businessExteriorZ`, `businessInteriorX`, `businessInteriorY`, `businessInteriorZ`, `businessInterior`, `businessLock`, `businessPrice`, `businessVault`, `businessMiscX`, `businessMiscY`, `businessMiscZ`, `businessEnterPrice`, `businessLevel`) VALUES
(1, '24/7 Fish', 'Nobody', 1, '1352.411', '-1759.253', '13.508', '-27.725', '-31.311', '1003.557', 4, 0, 450000, 6, '0.0', '0.0', '0.0', 6, 7),
(2, '24/7 business.', 'Nobody', 1, '1833.084', '-1842.775', '13.578', '-26.037', '-188.013', '1003.547', 17, 0, 450000, 1, '0.0', '0.0', '0.0', 1, 7),
(3, 'Business', 'Nobody', 2, '2244.323', '-1664.979', '15.477', '207.731', '-110.747', '1005.133', 15, 0, 320000, 10, '0.0', '0.0', '0.0', 10, 5),
(4, 'Business', 'Nobody', 7, '810.501', '-1616.247', '13.547', '362.858', '-75.151', '1001.508', 10, 0, 380000, 0, '0.0', '0.0', '0.0', 1, 5),
(5, 'Club BAMBO', 'Nobody', 3, '1837.039', '-1682.38', '13.323', '493.422', '-24.824', '1000.68', 17, 0, 310000, 0, '0.0', '0.0', '0.0', 1, 4),
(22, 'Business 24/7', 'Nobody', 1, '-792.172', '1627.795', '27.156', '-26.017', '-187.491', '1003.547', 17, 0, 350000, 0, '0.0', '0.0', '0.0', 1, 5),
(6, 'Banca Los Santos', 'Nobody', 8, '1457.092', '-1009.924', '26.844', '2305.546', '-16.009', '26.75', 0, 0, 550000, 0, '0.0', '0.0', '0.0', 400, 8),
(7, 'GYM los santos', 'Nobody', 6, '2230.003', '-1721.358', '13.562', '772.036', '-4.949', '1000.728', 5, 0, 350000, 2, '0.0', '0.0', '0.0', 1, 3),
(8, 'Business', 'Nobody', 4, '1087.832', '-922.49', '43.391', '-100.552', '-24.674', '1000.719', 3, 0, 290000, 0, '0.0', '0.0', '0.0', 1, 3),
(9, 'De vanzare!', 'Nobody', 7, '1199.253', '-918.155', '43.123', '362.87', '-75.167', '1001.508', 10, 0, 360000, 0, '0.0', '0.0', '0.0', 1, 5),
(10, 'CNN Los Santos SRL', 'Nobody', 9, '1170.91', '-1489.198', '22.755', '-959.532', '1956.162', '9.0', 17, 0, 600000, 0, '0.0', '0.0', '0.0', 200, 9),
(11, 'OMV CENTRAL MONEY', 'Nobody', 10, '1102.413', '-1440.322', '15.797', '965.092', '2108.646', '1011.03', 1, 0, 400000, 1, '0.0', '0.0', '0.0', 1, 5),
(12, 'Business', 'Nobody', 2, '2101.893', '2257.456', '11.023', '-2240.469', '137.06', '1035.414', 6, 0, 330000, 0, '0.0', '0.0', '0.0', 1, 4),
(13, 'Business', 'Nobody', 7, '2101.901', '2228.819', '11.023', '364.997', '-11.841', '1001.852', 9, 0, 310000, 0, '0.0', '0.0', '0.0', 1, 4),
(14, 'Business', 'Nobody', 1, '2637.258', '1129.678', '11.18', '6.074', '-31.612', '1003.549', 10, 0, 350000, 0, '0.0', '0.0', '0.0', 1, 4),
(16, 'Fish 24/7', 'Nobody', 1, '1000.401', '-919.979', '42.328', '-27.291', '-58.268', '1003.547', 6, 0, 400000, 0, '0.0', '0.0', '0.0', 10, 6),
(15, 'PNS Central LS.', 'Nobody', 12, '1034.459', '-1027.773', '32.102', '964.638', '2107.615', '1011.03', 1, 0, 500000, 0, '0.0', '0.0', '0.0', 1, 6),
(18, 'Business', 'Nobody', 14, '517.489', '-1296.523', '17.242', '1420.084', '3.703', '1002.391', 1, 0, 310000, 0, '0.0', '0.0', '0.0', 1, 5),
(17, 'Business', 'Nobody', 13, '1791.851', '-1163.124', '23.828', '315.768', '-143.611', '999.602', 7, 0, 450000, 0, '0.0', '0.0', '0.0', 450, 7),
(19, 'ARENA PENTRU EVENT ', 'Nobody', 0, '1511.831', '-1061.18', '25.063', '-1443.884', '930.281', '1036.483', 15, 0, 1000000, 0, '0.0', '0.0', '0.0', 1, 10),
(20, 'Business', 'Nobody', 3, '2310.073', '-1643.526', '14.827', '502.045', '-68.375', '998.758', 11, 0, 340000, 0, '0.0', '0.0', '0.0', 1, 5),
(21, 'Business', 'Nobody', 3, '2421.5', '-1219.242', '25.562', '501.969', '-67.568', '998.758', 11, 0, 300000, 0, '0.0', '0.0', '0.0', 1, 3),
(23, 'Binco', 'Nobody', 2, '-818.123', '1551.222', '27.117', '207.271', '-139.582', '1003.508', 3, 0, 300000, 0, '0.0', '0.0', '0.0', 1, 4),
(24, 'Banca LB', 'Nobody', 8, '-828.139', '1504.054', '19.829', '2304.946', '-16.275', '26.742', 0, 0, 400000, 0, '0.0', '0.0', '0.0', 1, 6),
(25, 'KFC', 'Nobody', 0, '-857.945', '1535.347', '22.587', '372.91', '-133.493', '1001.492', 5, 0, 250000, 0, '0.0', '0.0', '0.0', 1, 3),
(26, 'Nothing', 'Nobody', 8, '2196.776', '1677.137', '12.367', '2315.731', '-0.305', '26.742', 0, 0, 350000, 0, '0.0', '0.0', '0.0', 1, 4),
(27, 'Business', 'Nobody', 2, '-823.422', '1481.095', '19.649', '-100.132', '-25.033', '1000.719', 3, 0, 300000, 0, '0.0', '0.0', '0.0', 1, 4),
(28, 'Farmer', 'Nobody', 7, '417.896', '-1728.93', '9.261', '-27.725', '-31.311', '1003.557', 4, 0, 400000, 50, '0.0', '0.0', '0.0', 50, 5),
(29, 'Four Dragon Casino', 'Nobody', 10, '2019.778', '1007.669', '10.82', '2018.817', '1017.788', '996.875', 10, 0, 350000, 0, '0.0', '0.0', '0.0', 1, 5);
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `businessitems`
--
CREATE TABLE IF NOT EXISTS `businessitems` (
`itemId` int(6) NOT NULL AUTO_INCREMENT,
`itemBusinessId` int(6) NOT NULL DEFAULT '0',
`itemTypeId` int(6) NOT NULL DEFAULT '0',
`itemPrice` int(6) NOT NULL DEFAULT '10',
`itemName` varchar(64) NOT NULL DEFAULT 'Undefined',
PRIMARY KEY (`itemId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=115 ;
--
-- Salvarea datelor din tabel `businessitems`
--
INSERT INTO `businessitems` (`itemId`, `itemBusinessId`, `itemTypeId`, `itemPrice`, `itemName`) VALUES
(18, 8, 9, 10, 'Purple Dildo'),
(19, 8, 10, 15, 'Small White Vibrator'),
(20, 8, 11, 20, 'Large White Vibrator'),
(21, 8, 12, 15, 'Silver Vibrator'),
(22, 8, 13, 10, 'Flowers'),
(24, 2, 1, 5, 'Nothing yet'),
(25, 2, 2, 15, 'Walkie Talkie'),
(26, 2, 3, 10, 'Phone Book'),
(27, 2, 4, 10, 'Phone Credit'),
(28, 2, 5, 10, 'Mobile Phone'),
(29, 4, 6, 5, 'Box Meal 1'),
(30, 4, 7, 10, 'Box Meal 2'),
(31, 4, 8, 20, 'Box Meal 3'),
(32, 9, 6, 5, 'Box Meal 1'),
(33, 9, 7, 10, 'Box Meal 2'),
(34, 9, 8, 20, 'Box Meal 3'),
(35, 12, 18, 50, 'All Skins'),
(36, 13, 6, 5, 'Box Meal 1'),
(37, 13, 7, 10, 'Box Meal 2'),
(38, 13, 8, 20, 'Box Meal 3'),
(39, 16, 1, 5, 'Nothing yet'),
(40, 16, 2, 15, 'Walkie Talkie'),
(41, 16, 3, 10, 'Phone Book'),
(42, 16, 4, 10, 'Phone Credit'),
(43, 16, 5, 10, 'Mobile Phone'),
(53, 20, 14, 4, 'Cigar'),
(54, 20, 15, 1, 'Sprunk'),
(55, 20, 16, 10, 'Wine'),
(56, 20, 17, 3, 'Beer'),
(62, 21, 14, 4, 'Cigar'),
(63, 21, 15, 1, 'Sprunk'),
(64, 21, 16, 10, 'Wine'),
(65, 21, 17, 3, 'Beer'),
(71, 5, 14, 4, 'Cigar'),
(72, 5, 15, 1, 'Sprunk'),
(73, 5, 16, 10, 'Wine'),
(74, 5, 17, 3, 'Beer'),
(75, 14, 1, 5, 'Nothing yet'),
(76, 14, 2, 15, 'Walkie Talkie'),
(77, 14, 3, 10, 'Phone Book'),
(78, 14, 4, 10, 'Phone Credit'),
(79, 14, 5, 10, 'Mobile Phone'),
(84, 3, 18, 50, 'All Skins'),
(85, 22, 1, 5, 'Nothing yet'),
(86, 22, 2, 15, 'Walkie Talkie'),
(87, 22, 3, 10, 'Phone Book'),
(88, 22, 4, 10, 'Phone Credit'),
(89, 22, 5, 10, 'Mobile Phone'),
(100, 23, 18, 50, 'All Skins'),
(101, 27, 18, 50, 'All Skins'),
(107, 28, 6, 5, 'Box Meal 1'),
(108, 28, 7, 10, 'Box Meal 2'),
(109, 28, 8, 20, 'Box Meal 3'),
(110, 1, 1, 5, 'Nothing yet'),
(111, 1, 2, 15, 'Walkie Talkie'),
(112, 1, 3, 10, 'Phone Book'),
(113, 1, 4, 10, 'Phone Credit'),
(114, 1, 5, 10, 'Mobile Phone');
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `chat`
--
CREATE TABLE IF NOT EXISTS `chat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`playerid` int(11) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `clans`
--
CREATE TABLE IF NOT EXISTS `clans` (
`clanID` int(12) NOT NULL AUTO_INCREMENT,
`clanName` varchar(255) NOT NULL,
`clanMOTD` varchar(128) NOT NULL,
`clanTag` varchar(255) NOT NULL DEFAULT '[NONE]',
`clanRankName7` varchar(32) NOT NULL DEFAULT '[7] Owner',
`clanRankName1` varchar(32) NOT NULL DEFAULT '[1] Newbie',
`clanRankName2` varchar(32) DEFAULT '[2] Member',
`clanRankName3` varchar(32) NOT NULL DEFAULT '[3] Advanced',
`clanRankName4` varchar(32) NOT NULL DEFAULT '[4] Expert',
`clanRankName5` varchar(32) NOT NULL DEFAULT '[5] Legend',
`clanRankName6` varchar(32) NOT NULL DEFAULT '[6] Manager',
`description` text NOT NULL,
`clanColor` varchar(255) NOT NULL DEFAULT '0x4dad2b2b',
PRIMARY KEY (`clanID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `complaints`
--
CREATE TABLE IF NOT EXISTS `complaints` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`detalii` text NOT NULL,
`time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`creatorid` int(11) NOT NULL,
`againstid` int(11) NOT NULL,
`motiv` text NOT NULL,
`dovezi` text NOT NULL,
`status` int(11) NOT NULL DEFAULT '0',
`type` int(11) NOT NULL,
`factionid` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `complaintscomments`
--
CREATE TABLE IF NOT EXISTS `complaintscomments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`complaintid` int(11) NOT NULL,
`text` text NOT NULL,
`name` varchar(50) NOT NULL,
`playerid` int(11) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `dealer`
--
CREATE TABLE IF NOT EXISTS `dealer` (
`carID` int(11) NOT NULL,
`stock` int(11) NOT NULL DEFAULT '0',
`price` int(11) NOT NULL DEFAULT '0',
`Pprice` int(11) NOT NULL,
`name` varchar(100) NOT NULL,
PRIMARY KEY (`carID`),
UNIQUE KEY `carID` (`carID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Salvarea datelor din tabel `dealer`
--
INSERT INTO `dealer` (`carID`, `stock`, `price`, `Pprice`, `name`) VALUES
(400, 3, 50000, 0, 'Landstalker'),
(401, 2, 76000, 0, 'Bravura'),
(402, 3, 340000, 0, 'Buffalo'),
(404, 3, 500000, 0, 'Perrenial'),
(407, 3, 50000000, 0, 'Firetruck'),
(411, 4, 980000, 0, 'Infernus'),
(415, 3, 700000, 0, 'Cheetah'),
(418, 2, 70000, 0, 'Moonbeam'),
(426, 3, 215000, 0, 'Premier'),
(429, 3, 742000, 0, 'Banshee'),
(434, 3, 140000, 0, 'Hotknife'),
(439, 3, 130000, 0, 'Stallion'),
(451, 3, 850000, 0, 'Turismo'),
(461, 3, 248000, 0, 'PCJ-600'),
(462, 3, 35000, 0, 'Faggio'),
(463, 3, 245000, 0, 'Freeway'),
(468, 3, 228000, 0, 'Sanchez'),
(469, 3, 0, 100, 'Sparrow (100 PP)'),
(471, 3, 98000, 0, 'Quad'),
(474, 3, 90000, 0, 'Hermes'),
(480, 3, 305000, 0, 'Comet'),
(481, 3, 0, 200, 'BMX (200 PP)'),
(482, 3, 115000, 0, 'Buritto'),
(487, 2, 0, 100, 'Maverick (100 PP)'),
(489, 3, 237000, 0, 'Rancher'),
(494, 3, 0, 100, 'Hotring Racer (100 PP)'),
(495, 3, 295000, 0, 'Sandking'),
(496, 3, 187000, 0, 'Blista Compact'),
(500, 3, 125000, 0, 'Mesa'),
(510, 3, 0, 200, 'Mountain Bike (200 PP)'),
(521, 3, 263000, 0, 'FCR-900'),
(522, 3, 800000, 0, 'NRG-500'),
(535, 3, 200000, 0, 'Slamvan'),
(539, 3, 0, 100, 'Vortex (100 PP)'),
(541, 3, 915000, 0, 'Bullet'),
(543, 2, 60000, 0, 'Sadler'),
(545, 3, 210000, 0, 'Hustler'),
(550, 3, 100000, 0, 'Sunrise'),
(558, 3, 280000, 0, 'Uranus'),
(559, 3, 430000, 0, 'Jester'),
(560, 3, 725000, 0, 'Sultan'),
(561, 3, 230000, 0, 'Stratum'),
(562, 3, 415000, 0, 'Elegy'),
(565, 2, 265000, 0, 'Flash'),
(567, 3, 195000, 0, 'Savanna'),
(579, 3, 313000, 0, 'Huntley'),
(586, 3, 215000, 0, 'Wayfarer'),
(587, 3, 245000, 0, 'Euros'),
(603, 3, 228000, 0, 'Phoenix');
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `email`
--
CREATE TABLE IF NOT EXISTS `email` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`playerid` int(11) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`creator` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `faction_logs`
--
CREATE TABLE IF NOT EXISTS `faction_logs` (
`Id` int(255) NOT NULL AUTO_INCREMENT,
`Text` text CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`playerID` int(255) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`type` int(11) NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Salvarea datelor din tabel `faction_logs`
--
INSERT INTO `faction_logs` (`Id`, `Text`, `playerID`, `time`, `type`) VALUES
(1, 'BogdanScr. is now the leader of faction Los Santos Police Department.', 2, '2015-01-06 13:12:53', 0);
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `flogs`
--
CREATE TABLE IF NOT EXISTS `flogs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`playerID` int(255) NOT NULL,
`name` varchar(255) NOT NULL,
`faction` int(25) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Salvarea datelor din tabel `flogs`
--
INSERT INTO `flogs` (`id`, `text`, `playerID`, `name`, `faction`, `time`) VALUES
(1, 'BogdanScr. is now the leader of faction Los Santos Police Department.', 2, '', 1, '2015-01-06 13:12:53');
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `groups`
--
CREATE TABLE IF NOT EXISTS `groups` (
`groupID` int(12) NOT NULL AUTO_INCREMENT,
`groupRankName1` varchar(32) NOT NULL DEFAULT '(null)',
`groupRankName2` varchar(32) NOT NULL DEFAULT '(null)',
`groupRankName3` varchar(32) NOT NULL DEFAULT '(null)',
`groupRankName4` varchar(32) NOT NULL DEFAULT '(null)',
`groupRankName5` varchar(32) NOT NULL DEFAULT '(null)',
`groupRankName6` varchar(32) NOT NULL DEFAULT '(null)',
`groupRankName7` varchar(32) NOT NULL,
`grup` varchar(32) DEFAULT NULL,
`groupName` varchar(255) NOT NULL DEFAULT 'None',
`groupHQExteriorPosX` varchar(255) NOT NULL DEFAULT '0',
`groupHQExteriorPosY` varchar(255) NOT NULL DEFAULT '0',
`groupHQExteriorPosZ` varchar(255) NOT NULL DEFAULT '0',
`groupHQInteriorPosX` varchar(255) NOT NULL DEFAULT '0',
`groupHQInteriorPosY` varchar(255) NOT NULL DEFAULT '0',
`groupHQInteriorPosZ` varchar(255) NOT NULL DEFAULT '0',
`groupHQInteriorID` int(4) NOT NULL DEFAULT '0',
`groupHQLockStatus` int(2) NOT NULL DEFAULT '1',
`groupMOTD` varchar(128) NOT NULL DEFAULT '(null)',
`groupSafePosX` varchar(255) NOT NULL DEFAULT '0',
`groupSafePosY` varchar(255) NOT NULL DEFAULT '0',
`groupSafePosZ` varchar(255) NOT NULL DEFAULT '0',
`groupType` int(12) NOT NULL DEFAULT '0',
`groupSafeMoney` int(6) NOT NULL DEFAULT '1',
`groupSafeMats` int(6) NOT NULL DEFAULT '1',
`groupSafeDrugs` int(6) NOT NULL DEFAULT '1',
`groupMembers` int(6) NOT NULL DEFAULT '0',
`groupLeader` varchar(23) NOT NULL DEFAULT 'None',
`groupAplication` int(11) NOT NULL DEFAULT '0',
`groupSlots` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`groupID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=112 ;
--
-- Salvarea datelor din tabel `groups`
--
INSERT INTO `groups` (`groupID`, `groupRankName1`, `groupRankName2`, `groupRankName3`, `groupRankName4`, `groupRankName5`, `groupRankName6`, `groupRankName7`, `grup`, `groupName`, `groupHQExteriorPosX`, `groupHQExteriorPosY`, `groupHQExteriorPosZ`, `groupHQInteriorPosX`, `groupHQInteriorPosY`, `groupHQInteriorPosZ`, `groupHQInteriorID`, `groupHQLockStatus`, `groupMOTD`, `groupSafePosX`, `groupSafePosY`, `groupSafePosZ`, `groupType`, `groupSafeMoney`, `groupSafeMats`, `groupSafeDrugs`, `groupMembers`, `groupLeader`, `groupAplication`, `groupSlots`) VALUES
(1, 'LS Officer', 'LS Inspector', 'LS Cadet', 'LS Captain', 'LS General', 'Sub-Chestor LSPD', 'Chestor LSPD', NULL, 'Los Santos Police Department', '242.258', '66.395', '1003.641', '288.765', '167.185', '1007.172', 3, 1, 'Bun venit!', '300.817', '187.792', '1007.172', 1, 0, 0, 0, 0, 'None', 1, 10),
(2, '[1] F.B.I Secretar', '[2] F.B.I Agent Pietonal', '[3] F.B.I Agent Omucideri', '[4] F.B.I Agent de Marina', '[5] F.B.I Agent Secret', '[6] Co-Lider F.B.I', 'Director', NULL, 'Federal Bureau of Investigation', '626.965', '-571.779', '17.921', '246.317', '107.3', '1003.219', 10, 1, '.', '258.344', '108.256', '1003.219', 1, 0, 0, 0, 0, 'None', 1, 10),
(3, 'Soldat NG', 'Plutonier NG', 'Caporal NG', 'Capitan NG', 'Maior NG', 'Locotenent NG', 'General NG', NULL, 'National Guard', '200.998', '1869.536', '13.147', '288.746', '167.215', '1007.172', 3, 1, '', '300.598', '186.917', '1007.172', 1, 0, 0, 0, 0, 'None', 1, 10),
(4, 'Medic Incepãtor.', '(2) Medic Rezident', '(3) Medic Specialist', '(4) Medic Primar', '(5) Chirurg / Responsabil ', '(6) Vice - Director', '(7) Director', NULL, 'Paramedic Departament', '1172.081', '-1323.326', '15.403', '288.765', '167.185', '1007.172', 3, 1, '', '301.114', '187.941', '1007.172', 2, 0, 0, 0, 0, 'None', 1, 10),
(5, 'Secretar', 'Bodyguard', 'LV Inspector', 'Vice Premier', 'Premier', 'Vice Primar', 'Primar', NULL, 'Gouvernment', '1481.13', '-1772.179', '18.796', '390.386', '174.031', '1008.383', 3, 1, '', '354.371', '173.773', '1008.383', 1, 0, 0, 0, 0, 'None', 1, 10),
(6, '(1)Codat cu clasa', '(2)Avansat', '(3)Rus', '(4)Manager', '(5)Legenda', 'Russian Aimer', 'Leader', NULL, 'The Russian Mafia', '1123.017', '-2037.009', '69.894', '2544.451', '-1304.766', '1054.641', 2, 0, '', '2548.221', '-1281.795', '1060.984', 6, 0, 0, 0, 0, 'None', 1, 10),
(7, 'Little gangsta', '[2]Gangster', '[3]Gangsta', '[4]Killer', '[5] Veteran', '[6]Capone', 'Padrino', NULL, 'Grove Street', '2495.464', '-1690.579', '14.766', '2544.738', '-1304.877', '1054.641', 2, 1, '', '2546.98', '-1281.026', '1060.984', 7, 0, 0, 0, 0, 'None', 1, 10),
(9, 'Incepator', 'Aimer ', 'Rambo', 'Foarte Bun', 'Boss', '#Valoare', '#Lord', NULL, 'The Rifa', '1022.395', '-1121.421', '23.87', '2544.676', '-1304.907', '1054.641', 2, 1, '', '2546.348', '-1293.012', '1054.641', 9, 0, 0, 0, 0, 'None', 1, 10),
(10, '[1] Little Gangsta', '[2] Gangsta', '[3] Original Gangsta', '[4] Pro Killer', '[5] Professional Gangsta', '[6] Salieri Prince', 'Lord of Balla`s ', NULL, 'Ballas', '2233.568', '-1332.256', '23.981', '2544.845', '-1305.074', '1054.641', 2, 1, '', '2546.824', '-1280.949', '1060.984', 10, 0, 0, 0, 0, 'None', 1, 10),
(12, '(1)RaMb0', '(2)AsSasSin', '(3)Sheriff', '(4)Specialist', 'Contract Killer', 'Veteran Hitman', 'King of San Andreas.', NULL, 'Hitman Agency', '1080.952', '-345.403', '73.984', '774.15', '-48.952', '1000.586', 6, 1, 'Hitman Agency | Bine ati venit !', '755.641', '-48.394', '1000.78', 12, 0, 0, 0, 0, 'None', 1, 10),
(13, 'Elev', 'Student', 'Instructor', 'Instructor Experimentat', 'Instructor Profesionist', 'Director-Adjunct Instructors', 'Leader', NULL, 'School Instructors', '1154.997', '-1181.036', '32.819', '1700.534', '-1667.797', '20.219', 18, 1, 'School Instructor | Sedinta Duminica ora 20:30', '1709.728', '-1642.873', '20.219', 13, 0, 0, 0, 0, 'None', 1, 10),
(14, 'LS Trainee', 'LS Taxi Rookie', 'LS Experienced Driver', 'LS Dispatcher', 'Shift Spervizor', 'Vice-Director', 'Director', NULL, 'Taxi Cab Company', '1752.803', '-1903.004', '13.563', '1700.534', '-1667.799', '20.219', 18, 1, '.', '1700.948', '-1648.206', '20.219', 14, 0, 0, 0, 0, 'None', 0, 10),
(15, '[1] Rookie reporter', '[2] Trainee reporter', '[3] Experienced reporter', '[4] Journalist', '[5] Reporter national', 'Co-leader', 'Leader', NULL, 'News Reporters', '-329.689', '1537.041', '76.612', '288.765', '167.185', '1007.172', 3, 1, 'Bine ati venit în News Reporters! Prima sedintã va fi sâmbãtã la ora 19:30. Raportul nu este obligatoriu.', '300.781', '187.928', '1007.172', 15, 0, 0, 0, 0, 'None', 1, 10),
(8, 'Chicano', 'Guero', 'Soldado', 'Hermano', 'Vato', 'Derecha Mano', 'El Jefe', NULL, 'Los Aztecas', '1870.756', '-2021.351', '13.547', '2544.794', '-1305.054', '1054.641', 2, 1, '', '2546.805', '-1280.943', '1060.984', 8, 0, 0, 0, 0, 'None', 1, 10),
(11, '#Incepator.', '#Avansat.', '#Soldato.', '#Aimer.', 'Valoros.', '#Don.', '(7) Al capone', NULL, 'Los Vagos', '725.623', '-1440.4', '13.532', '2545.037', '-1304.96', '1054.641', 2, 1, '', '2546.805', '-1280.944', '1060.984', 11, 0, 0, 0, 0, 'None', 1, 10);
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `helperlogs`
--
CREATE TABLE IF NOT EXISTS `helperlogs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`playerid` int(11) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`text2` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `houses`
--
CREATE TABLE IF NOT EXISTS `houses` (
`houseID` int(12) NOT NULL AUTO_INCREMENT,
`houseExteriorPosX` varchar(255) NOT NULL DEFAULT '0',
`houseExteriorPosY` varchar(255) NOT NULL DEFAULT '0',
`houseExteriorPosZ` varchar(255) NOT NULL DEFAULT '0',
`houseInteriorPosX` varchar(255) NOT NULL DEFAULT '0',
`houseInteriorPosY` varchar(255) NOT NULL DEFAULT '0',
`houseInteriorPosZ` varchar(255) NOT NULL DEFAULT '0',
`houseInteriorID` int(4) NOT NULL DEFAULT '0',
`houseExteriorID` int(4) NOT NULL DEFAULT '0',
`houseOwner` varchar(24) NOT NULL DEFAULT 'Nobody',
`housePrice` int(12) NOT NULL DEFAULT '0',
`houseLocked` int(2) NOT NULL DEFAULT '1',
`houseMoney` int(12) NOT NULL DEFAULT '0',
`houseWeapon1` int(12) NOT NULL DEFAULT '0',
`houseWeapon2` int(12) NOT NULL DEFAULT '0',
`houseWeapon3` int(12) NOT NULL DEFAULT '0',
`houseRent` int(12) NOT NULL DEFAULT '0',
`houseLevel` int(6) NOT NULL DEFAULT '0',
PRIMARY KEY (`houseID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=68 ;
--
-- Salvarea datelor din tabel `houses`
--
INSERT INTO `houses` (`houseID`, `houseExteriorPosX`, `houseExteriorPosY`, `houseExteriorPosZ`, `houseInteriorPosX`, `houseInteriorPosY`, `houseInteriorPosZ`, `houseInteriorID`, `houseExteriorID`, `houseOwner`, `housePrice`, `houseLocked`, `houseMoney`, `houseWeapon1`, `houseWeapon2`, `houseWeapon3`, `houseRent`, `houseLevel`) VALUES
(1, '980.411987', '-677.296875', '121.976257', '140.169998', '1366.069946', '1083.859375', 5, 0, 'Nobody', 700000, 1, 0, 0, 0, 0, 400, 8),
(2, '1468.578979', '-905.851013', '54.835998', '223.360000', '1287.078979', '1082.140991', 1, 0, 'Nobody', 500000, 1, 0, 0, 0, 0, 1, 5),
(3, '1535.035034', '-799.991027', '72.848999', '234.235412', '1063.721435', '1084.212280', 6, 0, 'Nobody', 400000, 1, 0, 0, 0, 0, 10, 5),
(4, '1535.796020', '-885.328002', '57.657001', '327.746002', '1478.082031', '1084.437988', 15, 0, 'Nobody', 400000, 1, 0, 0, 0, 0, 200, 5),
(5, '1540.305053', '-851.388977', '64.335998', '226.300003', '1114.239990', '1080.993041', 5, 0, 'Nobody', 400000, 1, 0, 0, 0, 0, 10, 5),
(6, '1527.832031', '-772.596008', '80.578002', '2270.382080', '-1210.088989', '1047.562988', 10, 0, 'Nobody', 400000, 1, 0, 0, 0, 0, 1, 5),
(7, '1496.980957', '-687.892028', '95.563003', '234.190002', '1063.729980', '1084.212036', 6, 0, 'Nobody', 800000, 1, 0, 0, 0, 0, 1000, 10),
(8, '1442.582031', '-629.072998', '95.719001', '-283.585998', '1471.116943', '1084.375000', 15, 0, 'Nobody', 300000, 1, 0, 0, 0, 0, 1, 5),
(9, '1112.571044', '-742.054992', '100.133003', '140.378005', '1366.234008', '1083.859008', 5, 0, 'Nobody', 400000, 1, 0, 0, 0, 0, 69, 6),
(10, '1093.891967', '-807.091979', '107.419998', '376.959991', '1417.152954', '1081.328002', 15, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 0, 5),
(11, '-814.397277', '1425.866943', '13.945302', '234.048202', '1063.715698', '1084.212280', 6, 0, 'Nobody', 150000, 1, 0, 0, 0, 0, 1, 3),
(12, '-799.325012', '1425.572998', '13.945302', '299.779998', '309.890014', '1003.304687', 4, 0, 'Nobody', 150000, 1, 0, 0, 0, 0, 500, 3),
(13, '-786.173156', '1425.739868', '13.945302', '2283.307617', '-1140.239746', '1050.898437', 11, 0, 'Nobody', 150000, 1, 0, 0, 0, 0, 69, 3),
(14, '-775.913940', '1448.194335', '13.945302', '299.779998', '309.890014', '1003.304687', 4, 0, 'Nobody', 150000, 1, 0, 0, 0, 0, 69, 3),
(15, '-788.334045', '1448.371093', '13.945302', '2233.639892', '-1115.260009', '1050.882812', 5, 0, 'Nobody', 150000, 1, 0, 0, 0, 0, 69, 3),
(16, '-773.383117', '1425.435546', '13.945302', '299.782623', '309.833190', '1003.304687', 4, 0, 'Nobody', 150000, 1, 0, 0, 0, 0, 69, 3),
(17, '-802.993164', '1448.686157', '13.945302', '343.809997', '304.859985', '999.148437', 6, 0, 'Nobody', 150000, 1, 0, 0, 0, 0, 2000, 3),
(18, '-816.665771', '1448.810424', '13.945302', '2259.379882', '-1135.770019', '1050.640258', 10, 0, 'Nobody', 150000, 1, 0, 0, 0, 0, 1, 3),
(19, '692.880737', '-1602.771484', '15.046875', '2196.850097', '-1204.250000', '1049.023437', 6, 0, 'Nobody', 300000, 1, 0, 0, 0, 0, 1, 4),
(20, '300.354492', '-1154.561401', '81.391258', '140.169998', '1366.069946', '1083.859375', 5, 0, 'Nobody', 750000, 1, 0, 0, 0, 0, 69, 10),
(21, '251.479904', '-1220.177612', '76.102371', '225.679992', '1021.450012', '1084.017700', 7, 0, 'Nobody', 700000, 1, 0, 0, 0, 0, 1, 8),
(22, '252.930679', '-1269.998535', '74.359741', '234.190002', '1063.729980', '1084.212280', 6, 0, 'Nobody', 700000, 1, 0, 0, 0, 0, 0, 7),
(27, '657.224731', '-1652.700927', '15.406250', '2218.399902', '-1076.180053', '1050.484375', 1, 0, 'Nobody', 300000, 1, 0, 0, 0, 0, 1, 3),
(23, '937.875488', '-848.711242', '93.577178', '2283.040039', '-1140.280029', '1050.898437', 11, 0, 'Nobody', 400000, 1, 0, 0, 0, 0, 5000, 4),
(24, '835.783508', '-894.737060', '68.768898', '2495.979980', '-1692.079956', '1014.742187', 3, 0, 'Nobody', 600000, 1, 0, 0, 0, 0, 1000, 6),
(25, '298.598480', '-1338.681152', '53.441444', '24.040000', '1340.170043', '1084.375000', 10, 0, 'Nobody', 600000, 1, 0, 0, 0, 0, 1, 8),
(26, '254.381179', '-1367.128906', '53.109375', '-260.489990', '1456.750000', '1084.367187', 4, 0, 'Nobody', 600000, 1, 0, 0, 0, 0, 25000, 8),
(28, '653.411010', '-1714.253051', '14.764795', '2259.379882', '-1135.770019', '1050.640258', 10, 0, 'Nobody', 300000, 1, 0, 0, 0, 0, 1, 3),
(29, '652.473510', '-1693.810302', '14.555191', '2259.379882', '-1135.770019', '1050.640258', 10, 0, 'Nobody', 300000, 1, 0, 0, 0, 0, 1, 3),
(30, '824.616210', '-1424.202636', '14.498847', '140.169998', '1366.069946', '1083.859375', 5, 0, 'Nobody', 380000, 1, 0, 0, 0, 0, 69, 4),
(32, '219.218154', '-1249.816772', '78.336540', '225.679992', '1021.450012', '1084.017700', 7, 0, 'Nobody', 550000, 1, 0, 0, 0, 0, 69, 6),
(31, '795.164611', '-506.690155', '18.012922', '234.190002', '1063.729980', '1084.212280', 6, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 1, 4),
(42, '768.200988', '-503.480895', '18.012926', '266.667144', '305.108642', '999.148437', 2, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 0, 4),
(33, '2018.242309', '-1703.314331', '14.234375', '223.199996', '1287.079956', '1082.140625', 1, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 100, 4),
(34, '2016.198730', '-1717.002563', '14.125000', '2283.040039', '-1140.280029', '1050.898437', 11, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 0, 4),
(35, '2015.168579', '-1732.653320', '14.234375', '2233.639892', '-1115.260009', '1050.882812', 5, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 1000, 4),
(36, '315.806823', '-1769.429931', '4.621726', '2218.399902', '-1076.180053', '1050.484375', 1, 0, 'Nobody', 550000, 1, 0, 0, 0, 0, 1, 6),
(39, '2013.571289', '-1656.424316', '14.136316', '223.199996', '1287.079956', '1082.140625', 1, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 0, 4),
(37, '1980.380371', '-1718.839599', '17.030199', '24.040000', '1340.170043', '1084.375000', 10, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 69, 4),
(38, '1980.992187', '-1682.815429', '17.053705', '83.029998', '1322.280029', '1083.866210', 9, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 10, 4),
(49, '1094.854614', '-647.912902', '113.648437', '24.040000', '1340.170043', '1084.375000', 10, 0, 'Nobody', 550000, 1, 0, 0, 0, 0, 1000, 0),
(40, '2016.542358', '-1641.839965', '14.112874', '2218.399902', '-1076.180053', '1050.484375', 1, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 0, 4),
(41, '743.251525', '-509.322814', '18.012922', '2218.170166', '-1075.956054', '1050.484375', 1, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 0, 4),
(43, '818.209655', '-509.318054', '18.012922', '2283.040039', '-1140.280029', '1050.898437', 11, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 0, 4),
(45, '1183.476196', '-1099.072631', '28.257812', '235.339996', '1186.680053', '1080.257812', 3, 0, 'Nobody', 250000, 1, 0, 0, 0, 0, 0, 3),
(44, '1142.122192', '-1092.734985', '28.187500', '234.190002', '1063.729980', '1084.212280', 6, 0, 'Nobody', 250000, 1, 0, 0, 0, 0, 1000, 3),
(46, '1183.469482', '-1076.294555', '31.678918', '24.040000', '1340.170043', '1084.375000', 10, 0, 'Nobody', 250000, 1, 0, 0, 0, 0, 1, 3),
(47, '1141.971801', '-1069.912353', '31.765625', '2807.479980', '-1174.760009', '1025.570312', 8, 0, 'Nobody', 250000, 1, 0, 0, 0, 0, 0, 3),
(58, '827.778076', '-858.005737', '70.330810', '140.169998', '1366.069946', '1083.859375', 5, 0, 'Nobody', 230000, 1, 0, 0, 0, 0, 69, 0),
(48, '167.897857', '-1308.392333', '70.351257', '234.190002', '1063.729980', '1084.212280', 6, 0, 'Nobody', 650000, 1, 0, 0, 0, 0, 20000, 0),
(50, '-881.416931', '1562.424072', '25.911380', '223.211746', '1287.390625', '1082.140625', 1, 0, 'Nobody', 100000, 1, 0, 0, 0, 0, 5, 0),
(51, '-883.982238', '1552.736328', '26.062364', '2309.074462', '-1212.524169', '1049.023437', 6, 0, 'Nobody', 100000, 1, 0, 0, 0, 0, 2500, 0),
(52, '-879.675598', '1538.678955', '26.031114', '2218.151855', '-1076.009277', '1050.484375', 1, 0, 'Nobody', 100000, 1, 0, 0, 0, 0, 2500, 0),
(53, '-881.782775', '1531.739379', '26.062364', '2259.651123', '-1136.380004', '1050.632812', 10, 0, 'Nobody', 100000, 1, 0, 0, 0, 0, 100, 0),
(54, '-886.458251', '1514.096801', '26.031114', '266.697692', '304.337554', '999.148437', 2, 0, 'Nobody', 100000, 1, 0, 0, 0, 0, 1, 0),
(55, '-905.445739', '1528.577758', '26.077989', '243.846282', '305.162475', '999.148437', 1, 0, 'Nobody', 100000, 1, 0, 0, 0, 0, 5000, 0),
(56, '-906.400390', '1514.627197', '26.316806', '2233.412109', '-1115.044677', '1050.882812', 5, 0, 'Nobody', 100000, 1, 0, 0, 0, 0, 69, 0),
(57, '-905.540466', '1542.803588', '26.062364', '-42.834991', '1405.777709', '1084.429687', 8, 0, 'Nobody', 100000, 1, 0, 0, 0, 0, 100, 0),
(59, '1332.251953', '-633.455505', '109.134902', '2270.419189', '-1210.253417', '1047.562500', 10, 0, 'Nobody', 530000, 1, 0, 0, 0, 0, 69, 0),
(60, '1298.423339', '-798.059753', '84.140625', '2324.429443', '-1149.547241', '1050.710083', 12, 0, 'Nobody', 800000, 1, 0, 0, 0, 0, 0, 0),
(64, '1421.052490', '-886.229980', '50.685749', '1421.531372', '-886.221008', '50.685768', 0, 0, 'Nobody', 10000, 1, 0, 0, 0, 0, 1, 0);
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `jobs`
--
CREATE TABLE IF NOT EXISTS `jobs` (
`jobID` int(12) NOT NULL AUTO_INCREMENT,
`jobType` int(12) NOT NULL DEFAULT '0',
`jobPositionX` varchar(255) NOT NULL,
`jobPositionY` varchar(255) NOT NULL,
`jobPositionZ` varchar(255) NOT NULL,
`jobName` varchar(255) NOT NULL,
PRIMARY KEY (`jobID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;
--
-- Salvarea datelor din tabel `jobs`
--
INSERT INTO `jobs` (`jobID`, `jobType`, `jobPositionX`, `jobPositionY`, `jobPositionZ`, `jobName`) VALUES
(1, 1, '1366.959960', '-1291.690551', '13.546875', 'Arms Dealer'),
(2, 2, '606.585144', '-1438.753540', '14.052495', 'Detective'),
(3, 3, '921.1014', '-1298.2474', '14.0938', 'Mechanic'),
(4, 4, '376.1711', '-2071.6523', '7.8359', 'Fisherman'),
(5, 5, '2140.5608', '-1707.3037', '15.0859', 'Drugs Dealer'),
(6, 6, '2105.4358', '-1806.3704', '13.5547', 'Pizza Boy'),
(7, 7, '-382.5722', '-1438.9875', '25.9466', 'Farmer'),
(8, 8, '2813.8323', '891.1882', '10.7578', 'Car Jacker'),
(9, 9, '-77.4390', '-1136.3721', '1.0781', 'Trucker');
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `lastpunish`
--
CREATE TABLE IF NOT EXISTS `lastpunish` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`playerID` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `namechanges`
--
CREATE TABLE IF NOT EXISTS `namechanges` (
`namechangeid` int(6) NOT NULL AUTO_INCREMENT,
`userid` int(6) NOT NULL,
`oldname` varchar(24) NOT NULL,
`newname` varchar(24) NOT NULL,
`adminid` int(6) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`namechangeid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `phonelogs`
--
CREATE TABLE IF NOT EXISTS `phonelogs` (
`logID` int(32) NOT NULL AUTO_INCREMENT,
`phoneNumber` int(32) NOT NULL,
`phoneName` varchar(24) NOT NULL,
`phoneAction` varchar(768) NOT NULL,
PRIMARY KEY (`logID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `playeraccounts`
--
CREATE TABLE IF NOT EXISTS `playeraccounts` (
`playerID` int(12) NOT NULL AUTO_INCREMENT,
`playerPhone` int(15) DEFAULT '0',
`playerLevel` int(6) NOT NULL DEFAULT '1',
`playerName` varchar(24) NOT NULL,
`playerPassword` varchar(129) NOT NULL,
`playerEmail` varchar(255) NOT NULL,
`playerMoney` int(16) NOT NULL DEFAULT '100',
`playerPublicProfile` int(2) NOT NULL,
`playerAdminLevel` int(6) NOT NULL DEFAULT '0',
`playerRegistrationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`playerSkin` int(6) NOT NULL DEFAULT '60',
`playerPosX` varchar(255) NOT NULL DEFAULT '1794.213256',
`playerPosY` varchar(255) NOT NULL DEFAULT '-1862.133666',
`playerPosZ` varchar(255) NOT NULL DEFAULT '13.576666',
`playerBankMoney` int(16) NOT NULL DEFAULT '250',
`playerHealth` varchar(255) NOT NULL DEFAULT '100',
`playerArmour` int(255) NOT NULL DEFAULT '0',
`playerSeconds` int(5) NOT NULL DEFAULT '0',
`playerInterior` int(6) NOT NULL DEFAULT '0',
`playerVirtualWorld` int(6) NOT NULL DEFAULT '0',
`playerJob` int(3) NOT NULL DEFAULT '0',
`playerWeapon0` int(6) NOT NULL DEFAULT '0',
`playerWeapon1` int(6) NOT NULL DEFAULT '0',
`playerWeapon2` int(6) NOT NULL DEFAULT '0',
`playerWeapon3` int(6) NOT NULL DEFAULT '0',
`playerWeapon4` int(6) NOT NULL DEFAULT '0',
`playerWeapon5` int(6) NOT NULL DEFAULT '0',
`playerWeapon6` int(6) NOT NULL DEFAULT '0',
`playerWeapon7` int(6) NOT NULL DEFAULT '0',
`playerWeapon8` int(6) NOT NULL DEFAULT '0',
`playerWeapon9` int(6) NOT NULL DEFAULT '0',
`playerWeapon10` int(6) NOT NULL DEFAULT '0',
`playerWeapon11` int(6) NOT NULL DEFAULT '0',
`playerWeapon12` int(6) NOT NULL DEFAULT '0',
`playerJobSkill2` int(6) NOT NULL DEFAULT '0',
`playerMaterials` int(12) NOT NULL DEFAULT '0',
`playerGroup` int(6) NOT NULL DEFAULT '0',
`playerGroupRank` int(6) NOT NULL DEFAULT '0',
`playerHours` int(12) NOT NULL DEFAULT '0',
`playerWarning1` varchar(32) NOT NULL DEFAULT '(null)',
`playerWarning2` varchar(32) NOT NULL DEFAULT '(null)',
`playerWarning3` varchar(32) NOT NULL DEFAULT '(null)',
`playerHospitalized` int(3) NOT NULL DEFAULT '0',
`playerAdminName` varchar(24) NOT NULL,
`playerFirstLogin` int(2) NOT NULL DEFAULT '1',
`playerGender` int(2) NOT NULL DEFAULT '0',
`playerPrisonID` int(2) NOT NULL DEFAULT '0',
`playerPrisonTime` int(6) NOT NULL DEFAULT '0',
`playerPhoneNumber` int(12) NOT NULL DEFAULT '-1',
`playerPhoneBook` int(2) NOT NULL DEFAULT '0',
`playerIP` varchar(32) NOT NULL DEFAULT '0.0.0.0',
`playerHelperLevel` int(6) NOT NULL DEFAULT '0',
`playerDropCarTimeout` int(12) NOT NULL DEFAULT '0',
`playerRope` int(6) NOT NULL DEFAULT '0',
`playerAdminDuty` int(6) NOT NULL,
`playerCrimes` int(12) NOT NULL DEFAULT '0',
`playerArrests` int(12) NOT NULL DEFAULT '0',
`playerWarrants` int(12) NOT NULL DEFAULT '0',
`playerCarModel` int(6) NOT NULL DEFAULT '0',
`playerCarModel2` int(6) NOT NULL DEFAULT '0',
`playerCarModel3` int(6) NOT NULL DEFAULT '0',
`playerCarModel4` int(6) NOT NULL DEFAULT '0',
`playerCarMod0` int(6) NOT NULL DEFAULT '0',
`playerCarMod1` int(6) NOT NULL DEFAULT '0',
`playerCarMod2` int(6) NOT NULL DEFAULT '0',
`playerCarMod3` int(6) NOT NULL DEFAULT '0',
`playerCarMod4` int(6) NOT NULL DEFAULT '0',
`playerCarMod5` int(6) NOT NULL DEFAULT '0',
`playerCarMod6` int(6) NOT NULL DEFAULT '0',
`playerCarMod7` int(6) NOT NULL DEFAULT '0',
`playerCarMod8` int(6) NOT NULL DEFAULT '0',
`playerCarMod9` int(6) NOT NULL DEFAULT '0',
`playerCarMod10` int(6) NOT NULL DEFAULT '0',
`playerCarMod11` int(6) NOT NULL DEFAULT '0',
`playerCarMod12` int(6) NOT NULL DEFAULT '0',
`playerCarMod20` int(6) NOT NULL DEFAULT '0',
`playerCarMod21` int(6) NOT NULL DEFAULT '0',
`playerCarMod22` int(6) NOT NULL DEFAULT '0',
`playerCarMod23` int(6) NOT NULL DEFAULT '0',
`playerCarMod24` int(6) NOT NULL DEFAULT '0',
`playerCarMod25` int(6) NOT NULL DEFAULT '0',
`playerCarMod26` int(6) NOT NULL DEFAULT '0',
`playerCarMod27` int(6) NOT NULL DEFAULT '0',
`playerCarMod28` int(6) NOT NULL DEFAULT '0',
`playerCarMod29` int(6) NOT NULL DEFAULT '0',
`playerCarMod30` int(6) NOT NULL DEFAULT '0',
`playerCarMod31` int(6) NOT NULL DEFAULT '0',
`playerCarMod32` int(6) NOT NULL DEFAULT '0',
`playerCarPosX` varchar(255) NOT NULL DEFAULT '0.0',
`playerCarPosY` varchar(255) NOT NULL DEFAULT '0.0',
`playerCarPosZ` varchar(255) NOT NULL DEFAULT '0.0',
`playerCarPosZAngle` varchar(255) NOT NULL DEFAULT '0.0',
`playerCarPosX2` varchar(255) NOT NULL DEFAULT '0.0',
`playerCarPosY2` varchar(255) NOT NULL DEFAULT '0.0',
`playerCarPosZ2` varchar(255) NOT NULL DEFAULT '0.0',
`playerCarPosZAngle2` varchar(255) NOT NULL DEFAULT '0.0',
`playerCarColour1` int(6) NOT NULL DEFAULT '-1',
`playerCarColour2` int(6) NOT NULL DEFAULT '-1',
`playerCarColour21` int(6) NOT NULL DEFAULT '-1',
`playerCarColour22` int(6) NOT NULL DEFAULT '-1',
`playerAge` int(6) NOT NULL DEFAULT '0',
`playerCarPaintJob` int(6) NOT NULL DEFAULT '-1',
`playerCarLock` int(6) NOT NULL DEFAULT '0',
`playerCarPaintJob2` int(6) NOT NULL DEFAULT '-1',
`playerCarLock2` int(6) NOT NULL DEFAULT '0',
`playerCarLicensePlate2` varchar(32) NOT NULL DEFAULT '3S53D',
`playerFightStyle` int(6) NOT NULL DEFAULT '0',
`playerVIP` int(6) NOT NULL DEFAULT '0',
`playerCarWeapon1` int(12) NOT NULL DEFAULT '0',
`playerCarWeapon2` int(12) NOT NULL DEFAULT '0',
`playerCarWeapon3` int(12) NOT NULL DEFAULT '0',
`playerCarWeapon4` int(12) NOT NULL DEFAULT '0',
`playerCarWeapon5` int(12) NOT NULL DEFAULT '0',
`playerCarTrunk1` int(12) NOT NULL DEFAULT '0',
`playerCarTrunk2` int(12) NOT NULL DEFAULT '0',
`playerCarKM2` int(12) NOT NULL DEFAULT '0',
`playerPhoneCredit` int(12) NOT NULL DEFAULT '0',
`playerWalkieTalkie` int(12) NOT NULL DEFAULT '-1',
`playerAdminTitle` varchar(255) NOT NULL DEFAULT '(null)',
`playerCarLicensePlate` varchar(32) NOT NULL DEFAULT '3VF4 TW0',
`playerAdminPIN` int(4) NOT NULL DEFAULT '0',
`playerHouseRented` int(6) NOT NULL DEFAULT '0',
`playerCarLock3` int(6) NOT NULL DEFAULT '0',
`playerCarLock4` int(6) NOT NULL DEFAULT '0',
`playerCarKM3` int(6) NOT NULL DEFAULT '0',
`playerCarKM4` int(6) NOT NULL DEFAULT '0',
`playerCarColor31` int(6) NOT NULL DEFAULT '-1',
`playerCarColor32` int(6) NOT NULL DEFAULT '-1',
`playerCarColor41` int(6) NOT NULL DEFAULT '-1',
`playerCarColor42` int(6) NOT NULL DEFAULT '-1',
`playerCarPosX3` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
`playerCarPosY3` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
`playerCarPosZ3` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
`playerCarPosZAngle3` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
`playerCarPosX4` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
`playerCarPosY4` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
`playerCarPosZ4` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
`playerCarPosZAngle4` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
`playerCarPaintJob3` int(6) NOT NULL DEFAULT '-1',
`playerCarPaintJob4` int(6) NOT NULL DEFAULT '-1',
`playerCarMod60` int(6) NOT NULL DEFAULT '0',
`playerCarMod61` int(6) NOT NULL DEFAULT '0',
`playerCarMod62` int(6) NOT NULL DEFAULT '0',
`playerCarMod63` int(6) NOT NULL DEFAULT '0',
`playerCarMod64` int(6) NOT NULL DEFAULT '0',
`playerCarMod65` int(6) NOT NULL DEFAULT '0',
`playerCarMod66` int(6) NOT NULL DEFAULT '0',
`playerCarMod67` int(6) NOT NULL DEFAULT '0',
`playerCarMod68` int(6) NOT NULL DEFAULT '0',
`playerCarMod69` int(6) NOT NULL DEFAULT '0',
`playerCarMod70` int(6) NOT NULL DEFAULT '0',
`playerCarMod71` int(6) NOT NULL DEFAULT '0',
`playerCarMod72` int(6) NOT NULL DEFAULT '0',
`playerCarMod90` int(6) NOT NULL DEFAULT '0',
`playerCarMod80` int(6) NOT NULL DEFAULT '0',
`playerCarMod81` int(6) NOT NULL DEFAULT '0',
`playerCarMod82` int(6) NOT NULL DEFAULT '0',
`playerCarMod83` int(6) NOT NULL DEFAULT '0',
`playerCarMod84` int(6) NOT NULL DEFAULT '0',
`playerCarMod85` int(6) NOT NULL DEFAULT '0',
`playerCarMod86` int(6) NOT NULL DEFAULT '0',
`playerCarMod87` int(6) NOT NULL DEFAULT '0',
`playerCarMod88` int(6) NOT NULL DEFAULT '0',
`playerCarMod89` int(6) NOT NULL DEFAULT '0',
`playerCarMod91` int(6) DEFAULT '0',
`playerCarMod92` int(6) NOT NULL DEFAULT '0',
`playerAge1` int(6) NOT NULL DEFAULT '0',
`playerFlyLic` int(6) NOT NULL DEFAULT '0',
`playerGunLic` int(6) NOT NULL DEFAULT '0',
`playerClan` int(6) NOT NULL DEFAULT '0',
`playerClanRank` int(6) NOT NULL DEFAULT '0',
`playerLastLogin` varchar(20) NOT NULL,
`playerColor` int(11) NOT NULL DEFAULT '0',
`playerAplicationID` int(11) NOT NULL DEFAULT '0',
`playerManager` int(69) NOT NULL DEFAULT '0',
`playerClanTagType` int(69) NOT NULL DEFAULT '0',
`playerHelpedPlayers` int(100) NOT NULL DEFAULT '0',
`playerHelperTokens` int(225) NOT NULL DEFAULT '0',
`playerGlasses` int(50) NOT NULL DEFAULT '0',
`rpgon` int(10) NOT NULL DEFAULT '0',
`playerBoatLic` int(150) NOT NULL DEFAULT '0',
`playerHud` int(69) NOT NULL DEFAULT '0',
`playerHouse` int(100) NOT NULL DEFAULT '0',
`playerBusiness` int(100) NOT NULL,
`playerDays` int(255) NOT NULL DEFAULT '0',
`playerStatus` int(69) NOT NULL DEFAULT '0',
`Aproove` int(69) NOT NULL DEFAULT '0',
`Request` int(69) NOT NULL DEFAULT '0',
`newemail` int(69) NOT NULL DEFAULT '0',
`deconnect` int(11) NOT NULL DEFAULT '0',
`playerGiftHours` int(11) NOT NULL DEFAULT '0',
`playerClanDays` int(11) NOT NULL DEFAULT '0',
`playerCar1Days` int(11) NOT NULL DEFAULT '0',
`playerCar2Days` int(11) NOT NULL DEFAULT '0',
`playerCar3Days` int(11) NOT NULL DEFAULT '0',
`playerCar4Days` int(11) NOT NULL DEFAULT '0',
`text` varchar(255) NOT NULL,
`text2` int(11) NOT NULL DEFAULT '0',
`playerBanned` int(11) NOT NULL DEFAULT '0',
`playerInsurance` int(12) NOT NULL,
`playerInsurance2` int(12) NOT NULL,
`playerInsurance3` int(12) NOT NULL,
`playerInsurance4` int(12) NOT NULL,
`playerInsurancePoints` int(12) NOT NULL,
`playerInsurancePoints2` int(12) NOT NULL,
`playerInsurancePoints3` int(12) NOT NULL,
`playerInsurancePoints4` int(12) NOT NULL,
`playerFishSkill` int(6) NOT NULL DEFAULT '1',
`playerTimesFished` int(6) NOT NULL DEFAULT '0',
`playerRobSkill` int(6) NOT NULL DEFAULT '1',
`playerTimesRobbed` int(6) NOT NULL DEFAULT '0',
`playerFireWork` int(12) NOT NULL DEFAULT '0',
PRIMARY KEY (`playerID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=3 ;
--
-- Salvarea datelor din tabel `playeraccounts`
--
INSERT INTO `playeraccounts` (`playerID`, `playerPhone`, `playerLevel`, `playerName`, `playerPassword`, `playerEmail`, `playerMoney`, `playerPublicProfile`, `playerAdminLevel`, `playerRegistrationDate`, `playerSkin`, `playerPosX`, `playerPosY`, `playerPosZ`, `playerBankMoney`, `playerHealth`, `playerArmour`, `playerSeconds`, `playerInterior`, `playerVirtualWorld`, `playerJob`, `playerWeapon0`, `playerWeapon1`, `playerWeapon2`, `playerWeapon3`, `playerWeapon4`, `playerWeapon5`, `playerWeapon6`, `playerWeapon7`, `playerWeapon8`, `playerWeapon9`, `playerWeapon10`, `playerWeapon11`, `playerWeapon12`, `playerJobSkill2`, `playerMaterials`, `playerGroup`, `playerGroupRank`, `playerHours`, `playerWarning1`, `playerWarning2`, `playerWarning3`, `playerHospitalized`, `playerAdminName`, `playerFirstLogin`, `playerGender`, `playerPrisonID`, `playerPrisonTime`, `playerPhoneNumber`, `playerPhoneBook`, `playerIP`, `playerHelperLevel`, `playerDropCarTimeout`, `playerRope`, `playerAdminDuty`, `playerCrimes`, `playerArrests`, `playerWarrants`, `playerCarModel`, `playerCarModel2`, `playerCarModel3`, `playerCarModel4`, `playerCarMod0`, `playerCarMod1`, `playerCarMod2`, `playerCarMod3`, `playerCarMod4`, `playerCarMod5`, `playerCarMod6`, `playerCarMod7`, `playerCarMod8`, `playerCarMod9`, `playerCarMod10`, `playerCarMod11`, `playerCarMod12`, `playerCarMod20`, `playerCarMod21`, `playerCarMod22`, `playerCarMod23`, `playerCarMod24`, `playerCarMod25`, `playerCarMod26`, `playerCarMod27`, `playerCarMod28`, `playerCarMod29`, `playerCarMod30`, `playerCarMod31`, `playerCarMod32`, `playerCarPosX`, `playerCarPosY`, `playerCarPosZ`, `playerCarPosZAngle`, `playerCarPosX2`, `playerCarPosY2`, `playerCarPosZ2`, `playerCarPosZAngle2`, `playerCarColour1`, `playerCarColour2`, `playerCarColour21`, `playerCarColour22`, `playerAge`, `playerCarPaintJob`, `playerCarLock`, `playerCarPaintJob2`, `playerCarLock2`, `playerCarLicensePlate2`, `playerFightStyle`, `playerVIP`, `playerCarWeapon1`, `playerCarWeapon2`, `playerCarWeapon3`, `playerCarWeapon4`, `playerCarWeapon5`, `playerCarTrunk1`, `playerCarTrunk2`, `playerCarKM2`, `playerPhoneCredit`, `playerWalkieTalkie`, `playerAdminTitle`, `playerCarLicensePlate`, `playerAdminPIN`, `playerHouseRented`, `playerCarLock3`, `playerCarLock4`, `playerCarKM3`, `playerCarKM4`, `playerCarColor31`, `playerCarColor32`, `playerCarColor41`, `playerCarColor42`, `playerCarPosX3`, `playerCarPosY3`, `playerCarPosZ3`, `playerCarPosZAngle3`, `playerCarPosX4`, `playerCarPosY4`, `playerCarPosZ4`, `playerCarPosZAngle4`, `playerCarPaintJob3`, `playerCarPaintJob4`, `playerCarMod60`, `playerCarMod61`, `playerCarMod62`, `playerCarMod63`, `playerCarMod64`, `playerCarMod65`, `playerCarMod66`, `playerCarMod67`, `playerCarMod68`, `playerCarMod69`, `playerCarMod70`, `playerCarMod71`, `playerCarMod72`, `playerCarMod90`, `playerCarMod80`, `playerCarMod81`, `playerCarMod82`, `playerCarMod83`, `playerCarMod84`, `playerCarMod85`, `playerCarMod86`, `playerCarMod87`, `playerCarMod88`, `playerCarMod89`, `playerCarMod91`, `playerCarMod92`, `playerAge1`, `playerFlyLic`, `playerGunLic`, `playerClan`, `playerClanRank`, `playerLastLogin`, `playerColor`, `playerAplicationID`, `playerManager`, `playerClanTagType`, `playerHelpedPlayers`, `playerHelperTokens`, `playerGlasses`, `rpgon`, `playerBoatLic`, `playerHud`, `playerHouse`, `playerBusiness`, `playerDays`, `playerStatus`, `Aproove`, `Request`, `newemail`, `deconnect`, `playerGiftHours`, `playerClanDays`, `playerCar1Days`, `playerCar2Days`, `playerCar3Days`, `playerCar4Days`, `text`, `text2`, `playerBanned`, `playerInsurance`, `playerInsurance2`, `playerInsurance3`, `playerInsurance4`, `playerInsurancePoints`, `playerInsurancePoints2`, `playerInsurancePoints3`, `playerInsurancePoints4`, `playerFishSkill`, `playerTimesFished`, `playerRobSkill`, `playerTimesRobbed`, `playerFireWork`) VALUES
(1, 0, 6, 'FloriynScr', '123', '[email protected]', 1338895, 0, 7, '2014-12-20 19:08:10', 60, '1794.213256', '-1862.133666', '13.576666', 994, '100.000000', 0, 0, 0, 0, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, '', '', '', 0, '', 0, 0, 0, 0, -1, 0, '0.0.0.0', 0, 0, 240, 10, 0, 0, 0, 411, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '1645.916625', '-2253.707031', '13.062336', '205.680664', '0.0', '0.0', '0.0', '0.0', 87, 74, -1, -1, 23, -1, 0, -1, 0, 'LGY RPG', 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, -1, '(null)', '3VF4 TW0', 0, 0, 0, 0, 0, 0, -1, -1, -1, -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,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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16, 149, 149, 0, 0, '06.01.2015 15:25', 0, 0, 0, 0, 0, 0, 0, 0, 149, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, '', 0, 0, 100, 0, 0, 0, 12, 0, 0, 0, 1, 0, 1, 0, 2),
(2, 2, 2, 'BogdanScr.', 'asdasd', '[email protected]', 50, 0, 7, '2015-01-06 12:45:49', 281, '1794.213256', '-1862.133666', '13.576666', 330, '100.000000', 0, 1616, 0, 0, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 7, 0, '', '', '', 0, '', 0, 0, 0, 0, 8519, 0, '0.0.0.0', 0, 0, 100, 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, 0, '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', -1, -1, -1, -1, 1, -1, 0, -1, 0, '3S53D', 0, 0, 0, 0, 0, 0, 23, 0, 0, 0, 0, -1, '(null)', '3VF4 TW0', 0, 0, 0, 0, 0, 0, -1, -1, -1, -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,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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21, 0, 0, 0, 0, '06.01.2015 15:51', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 8);
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `ticketcomments`
--
CREATE TABLE IF NOT EXISTS `ticketcomments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ticketid` int(11) NOT NULL,
`text` text NOT NULL,
`name` varchar(50) NOT NULL,
`playerid` int(11) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `tickets`
--
CREATE TABLE IF NOT EXISTS `tickets` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`text` text NOT NULL,
`status` int(69) NOT NULL DEFAULT '0',
`playerid` int(11) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `turfs`
--
CREATE TABLE IF NOT EXISTS `turfs` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`Owned` int(2) NOT NULL,
`Time` int(3) NOT NULL,
`MinX` varchar(16) NOT NULL,
`MinY` varchar(16) NOT NULL,
`MaxX` varchar(16) NOT NULL,
`MaxY` varchar(16) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ;
--
-- Salvarea datelor din tabel `turfs`
--
INSERT INTO `turfs` (`ID`, `Owned`, `Time`, `MinX`, `MinY`, `MaxX`, `MaxY`) VALUES
(1, 11, 0, '626.916', '-1572.63', '789.268', '-1412.95'),
(2, 11, 0, '627.73', '-1410.94', '790.206', '-1238.05'),
(3, 11, 0, '790.815', '-1573.29', '916.731', '-1332.36'),
(4, 11, 0, '790.396', '-1332.35', '1056.23', '-1238.83'),
(5, 11, 0, '627.967', '-1236.28', '791.099', '-1061.05'),
(6, 11, 0, '792.017', '-1237.8', '1057.73', '-1061.39'),
(7, 11, 0, '917.403', '-1574.39', '1057.43', '-1333.96'),
(8, 11, 0, '628.74', '-1059.46', '1058.49', '-955.947'),
(9, 11, 0, '1057.22', '-1574.22', '1211.22', '-1224.22'),
(10, 7, 0, '1056.5', '-1225.06', '1211.98', '-956.114'),
(11, 11, 0, '628.331', '-1791.8', '918.803', '-1573.66'),
(12, 11, 0, '918.312', '-1791.53', '1210.97', '-1571.98'),
(13, 11, 0, '1210.34', '-1791.52', '1364.4', '-1414.2'),
(14, 11, 0, '1210.47', '-1413.87', '1364.53', '-1147.54'),
(15, 11, 0, '1210.6', '-1147.21', '1531.8', '-956.594'),
(16, 10, 0, '1363.77', '-1320.93', '1717.53', '-1147.79'),
(17, 11, 0, '1364.54', '-1595.89', '1504.64', '-1319.9'),
(18, 11, 0, '1364.36', '-1791.41', '1717.75', '-1596.89'),
(19, 10, 0, '1504.55', '-1597.3', '1644.29', '-1321.18'),
(20, 10, 0, '1531.66', '-1147.14', '1882.12', '-956.649'),
(21, 8, 0, '1644.18', '-1597.46', '1882', '-1444.44'),
(22, 7, 0, '1644.09', '-1444.13', '1882.29', '-1319.52'),
(23, 7, 0, '1717.41', '-1320.25', '1882.33', '-1147.91'),
(24, 8, 0, '1717.51', '-1791.08', '1882.25', '-1597.26'),
(25, 8, 0, '1882.27', '-1278.48', '2022.42', '-957.47'),
(26, 8, 0, '1882.55', '-1605.11', '2022.16', '-1278.08'),
(27, 8, 0, '1881.71', '-1791.87', '2327.57', '-1605.32'),
(28, 8, 0, '2022.53', '-1606.06', '2327.73', '-1420.24'),
(29, 8, 0, '2021.63', '-1419.87', '2190.28', '-1165.03'),
(30, 8, 0, '2189.11', '-1420.38', '2329.27', '-1163.46'),
(31, 10, 0, '2023.19', '-1164.47', '2330.02', '-957.524'),
(32, 8, 0, '2327.66', '-1791.07', '2634.45', '-1606.67'),
(33, 8, 0, '2328.03', '-1606.34', '2496.03', '-1340'),
(34, 8, 0, '2496', '-1607.41', '2634.1', '-1340.79'),
(35, 10, 0, '2330.15', '-1340.94', '2634.76', '-1155.8'),
(36, 10, 0, '2327.66', '-1155.83', '2632.72', '-956.658'),
(37, 8, 0, '1741.33', '-2105.2', '1894.59', '-1790.72'),
(38, 8, 0, '1894.3', '-2105.29', '2074.71', '-1792.05'),
(39, 8, 0, '2073.27', '-1957.38', '2325.4', '-1792.17'),
(40, 8, 0, '2074.28', '-2105.92', '2325.38', '-1957.51'),
(41, 11, 0, '1350.1', '-1959.09', '1742.57', '-1790.92'),
(42, 8, 0, '1349.44', '-2105.47', '1742.45', '-1957.4');
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `unbancomments`
--
CREATE TABLE IF NOT EXISTS `unbancomments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`unbanid` int(69) NOT NULL,
`text` text NOT NULL,
`name` varchar(50) NOT NULL,
`playerid` int(69) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `unbans`
--
CREATE TABLE IF NOT EXISTS `unbans` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`status` int(69) NOT NULL DEFAULT '0',
`text` text NOT NULL,
`playerid` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `vehicles`
--
CREATE TABLE IF NOT EXISTS `vehicles` (
`vehicleID` int(11) NOT NULL AUTO_INCREMENT,
`vehicleModelID` int(11) NOT NULL DEFAULT '0',
`vehiclePosX` varchar(255) NOT NULL DEFAULT '0',
`vehiclePosY` varchar(255) NOT NULL DEFAULT '0',
`vehiclePosZ` varchar(255) NOT NULL DEFAULT '0',
`vehiclePosRotation` varchar(255) NOT NULL DEFAULT '0',
`vehicleGroup` int(12) NOT NULL DEFAULT '0',
`vehicleGroupRank` int(6) DEFAULT '0',
`vehicleJob` int(12) NOT NULL DEFAULT '0',
`vehicleCol1` int(4) NOT NULL DEFAULT '-1',
`vehicleCol2` int(4) NOT NULL DEFAULT '-1',
`vehicleNumberPlate` varchar(255) NOT NULL DEFAULT 'LGY-RP',
PRIMARY KEY (`vehicleID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=249 ;
--
-- Salvarea datelor din tabel `vehicles`
--
INSERT INTO `vehicles` (`vehicleID`, `vehicleModelID`, `vehiclePosX`, `vehiclePosY`, `vehiclePosZ`, `vehiclePosRotation`, `vehicleGroup`, `vehicleGroupRank`, `vehicleJob`, `vehicleCol1`, `vehicleCol2`, `vehicleNumberPlate`) VALUES
(1, 547, '1198.310180', '-1835.903198', '13.135808', '269.611572', 0, 0, 0, 7, 7, 'LGY-RP'),
(2, 547, '1198.348632', '-1832.648681', '13.137253', '267.868560', 0, 0, 0, 7, 7, 'LGY-RP'),
(3, 547, '1198.463623', '-1829.555419', '13.139369', '269.452178', 0, 0, 0, 7, 7, 'LGY-RP'),
(4, 547, '1225.439697', '-1828.497924', '13.141233', '180.206542', 0, 0, 0, 7, 7, 'LGY-RP'),
(5, 596, '636.876831', '-554.128723', '15.981917', '0.881578', 2, 0, 0, 1, 7, 'LGY-RP'),
(6, 411, '2292.753173', '2434.440429', '2.999930', '116.046875', 2, 5, 0, 1, 1, 'LGY-RP'),
(7, 490, '636.371826', '-609.925354', '16.414344', '358.876190', 2, 2, 0, 0, 0, 'LGY-RP'),
(8, 528, '612.017272', '-597.414489', '17.270967', '268.474517', 2, 2, 0, 66, 102, 'LGY-RP'),
(9, 596, '637.012084', '-562.614318', '15.982011', '0.351052', 2, 0, 0, 1, 7, 'LGY-RP'),
(10, 411, '623.051940', '-605.839233', '16.783426', '272.191345', 2, 3, 0, 1, 7, 'LGY-RP'),
(11, 596, '637.064086', '-575.498962', '15.981768', '0.992000', 2, 0, 0, 1, 7, 'LGY-RP'),
(12, 497, '665.781921', '-614.941467', '16.490442', '92.123336', 2, 4, 0, 7, 1, 'LGY-RP'),
(13, 411, '221.773498', '1853.653686', '12.558401', '2.711836', 3, 1, 0, 1, 1, 'LGY-RP'),
(14, 411, '214.021392', '1853.432983', '12.546299', '0.400114', 3, 1, 0, 1, 1, 'LGY-RP'),
(15, 598, '195.150680', '1919.700195', '17.402709', '178.634963', 3, 1, 0, 0, 1, 'LGY-RP'),
(16, 598, '220.685256', '1919.830810', '17.403896', '181.731781', 3, 1, 0, 0, 1, 'LGY-RP'),
(17, 599, '223.481674', '1862.230468', '13.383355', '89.653465', 3, 1, 0, 0, 1, 'LGY-RP'),
(18, 563, '1562.939575', '-1706.484252', '29.105745', '90.051376', 1, 1, 0, 79, 1, 'LGY-RP'),
(19, 596, '1566.692626', '-1605.955932', '13.037806', '181.282211', 1, 1, 0, 0, 1, 'LGY-RP'),
(20, 596, '1574.727783', '-1606.054565', '13.132248', '175.876464', 1, 1, 0, 0, 1, 'LGY-RP'),
(21, 427, '1561.715820', '-1607.314819', '13.537670', '177.714843', 1, 2, 0, 0, 1, 'LGY-RP'),
(22, 598, '202.579284', '1919.818237', '17.403881', '180.115356', 3, 1, 0, 0, 1, 'LGY-RP'),
(23, 520, '-2374.996093', '1548.024536', '32.580429', '52.138469', 3, 1, 0, 10, 46, 'LGY-RP'),
(24, 599, '223.477844', '1866.818481', '13.362006', '90.787086', 3, 1, 0, 0, 1, 'LGY-RP'),
(25, 598, '213.145217', '1919.882690', '17.406965', '179.100860', 3, 1, 0, 0, 1, 'LGY-RP'),
(26, 407, '1187.699096', '-1300.218017', '13.707109', '179.487762', 4, 4, 0, 3, 3, 'LGY-RP'),
(27, 531, '-383.382080', '-1412.825683', '25.692266', '4.728504', 0, 0, 7, 222, 222, 'LGY-RP'),
(28, 416, '1181.923706', '-1338.924316', '13.755855', '271.476043', 4, 1, 0, 1, 3, 'LGY-RP'),
(29, 416, '1187.929931', '-1358.245483', '13.614495', '0.165812', 4, 1, 0, 1, 3, 'LGY-RP'),
(30, 425, '226.219421', '1885.617187', '18.219427', '358.869842', 3, 1, 0, 93, 83, 'LGY-RP'),
(31, 410, '779.458312', '-584.419860', '16.013557', '274.718078', 0, 0, 0, -1, -1, 'LGY-RP'),
(32, 599, '1177.360473', '-1313.443603', '14.274971', '270.160797', 4, 3, 0, 1, 3, 'LGY-RP'),
(33, 599, '1177.456909', '-1334.367919', '14.271764', '270.244232', 4, 3, 0, 1, 3, 'LGY-RP'),
(34, 522, '1477.255615', '-1770.845947', '18.371112', '5.139236', 5, 0, 0, 0, 0, 'LGY-RP'),
(35, 560, '1491.419067', '-1737.437988', '13.129186', '269.446472', 5, 0, 0, 0, 0, 'LGY-RP'),
(36, 409, '1473.597900', '-1737.486206', '13.261100', '267.195465', 5, 1, 0, 0, 0, 'LGY-RP'),
(37, 523, '1503.324707', '-1747.599243', '13.107806', '358.530548', 5, 0, 0, 0, 0, 'LGY-RP'),
(38, 523, '1458.407104', '-1748.344604', '13.115719', '3.628769', 5, 0, 0, 113, 21, 'LGY-RP'),
(39, 411, '1455.401855', '-1749.518676', '13.254681', '358.159057', 5, 2, 0, 0, 0, 'LGY-RP'),
(40, 411, '1507.640502', '-1748.590698', '13.241543', '357.792572', 5, 2, 0, 0, 0, 'LGY-RP'),
(41, 482, '1139.603881', '-2020.526855', '69.123336', '272.756011', 6, 1, 0, 0, 0, 'LGY-RP'),
(42, 560, '1152.391235', '-2045.429565', '68.676574', '71.823791', 6, 5, 0, 0, 0, 'LGY-RP'),
(43, 461, '1128.438842', '-2045.876220', '68.584472', '270.422241', 6, 1, 0, 0, 0, 'LGY-RP'),
(44, 409, '1139.959716', '-2041.582763', '68.778556', '269.663635', 6, 1, 0, 0, 0, 'LGY-RP'),
(45, 426, '1140.208740', '-2026.657592', '68.728561', '271.404357', 6, 1, 0, 0, 0, 'LGY-RP'),
(46, 487, '1157.191650', '-2037.036987', '69.214263', '270.307434', 6, 5, 0, 0, 0, 'LGY-RP'),
(47, 401, '1560.546875', '-2244.504882', '13.326198', '89.297309', 0, 0, 0, 110, 50, 'LGY-RP'),
(48, 401, '1560.592529', '-2257.614257', '13.322057', '90.635070', 0, 0, 0, -1, -1, 'LGY-RP'),
(49, 401, '1560.718505', '-2251.123291', '13.327308', '90.120262', 0, 0, 0, -1, -1, 'LGY-RP'),
(50, 401, '1560.636840', '-2264.122070', '13.296892', '88.567947', 0, 0, 0, -1, -1, 'LGY-RP'),
(51, 458, '1967.146606', '-1835.771118', '13.305604', '357.668395', 0, 0, 0, -1, -1, 'LGY-RP'),
(52, 560, '1021.841', '-1135.57', '23.439', '269.075', 9, 1, 0, 130, 130, 'Rifa Sultan'),
(53, 566, '1891.454223', '-2020.658813', '13.325956', '89.131607', 8, 1, 0, 135, 135, 'LGY-RP'),
(54, 482, '1007.416', '-1127.586', '23.987', '230.307', 9, 1, 0, 130, 130, 'LGY-RP'),
(55, 426, '1012.044', '-1119.619', '23.642', '177.746', 9, 1, 0, 130, 130, 'LGY-RP'),
(56, 487, '1030.819213', '-1131.479003', '24.000854', '179.254913', 9, 0, 0, 130, 130, 'LGY-RP'),
(57, 482, '2216.573242', '-1327.832641', '24.074768', '181.173706', 10, 1, 0, 233, 233, 'LGY-RP'),
(58, 426, '2226.934082', '-1366.632202', '23.758182', '2.124837', 10, 1, 0, 233, 233, 'LGY-RP'),
(59, 560, '2230.336914', '-1338.426391', '23.624250', '91.708503', 10, 1, 0, 233, 233, 'LGY-RP'),
(60, 461, '2214.166503', '-1348.323608', '23.555391', '238.096954', 10, 1, 0, 233, 233, 'LGY-RP'),
(61, 487, '2243.505859', '-1315.708374', '24.135986', '359.494079', 10, 5, 0, 233, 233, 'LGY-RP'),
(62, 468, '371.582855', '-2048.723632', '7.505012', '357.514770', 0, 0, 4, 0, 0, 'LGY-RP'),
(63, 469, '1018.892700', '-350.753631', '73.943237', '271.624084', 12, 1, 0, 93, 95, 'LGY-RP'),
(64, 468, '363.021514', '-2048.281250', '7.505108', '327.550720', 0, 0, 4, 0, 0, 'LGY-RP'),
(65, 468, '374.584747', '-2048.794433', '7.499139', '16.174043', 0, 0, 4, 0, 0, 'LGY-RP'),
(66, 468, '368.790130', '-2048.745117', '7.504919', '359.188446', 0, 0, 4, 0, 0, 'LGY-RP'),
(67, 462, '1841.071777', '-1871.298217', '12.989321', '1.237526', 0, 0, 0, 1, 1, 'Faggio'),
(68, 415, '1074.009033', '-293.225311', '73.717590', '179.890747', 12, 1, 0, 74, 1, 'LGY-RP'),
(69, 415, '1067.067504', '-293.241149', '73.718933', '178.539352', 12, 2, 0, 74, 1, 'LGY-RP'),
(70, 452, '728.129272', '-1493.830200', '-0.526360', '181.436080', 0, 0, 0, -1, -1, 'LGY-RP'),
(71, 473, '718.719787', '-1492.688842', '-0.391828', '181.919418', 0, 0, 0, -1, -1, 'LGY-RP'),
(72, 461, '1063.249389', '-299.322143', '73.575767', '196.802078', 12, 1, 0, 74, 1, 'LGY-RP'),
(73, 410, '665.805358', '-621.363220', '16.004051', '273.985504', 0, 0, 0, -1, -1, 'LGY-RP'),
(74, 596, '1570.535278', '-1605.901245', '13.109769', '180.031341', 1, 1, 0, 0, 1, 'LGY-RP'),
(75, 596, '1578.934936', '-1606.238769', '13.124501', '176.422058', 1, 1, 0, 0, 1, 'LGY-RP'),
(76, 497, '1564.330566', '-1650.472290', '28.533887', '93.389564', 1, 1, 0, 2, 1, 'LGY-RP'),
(77, 426, '538.763671', '-1290.384155', '16.985336', '358.967315', 0, 0, 0, 29, 11, 'LGY-RP'),
(78, 560, '1083.447021', '-297.897918', '73.661247', '162.482635', 12, 2, 0, 74, 1, 'LGY-RP'),
(79, 469, '1017.297607', '-334.606323', '74.025283', '276.687194', 12, 1, 0, 0, 0, 'LGY-RP'),
(80, 469, '1017.764343', '-343.415405', '74.032684', '178.066848', 12, 1, 0, 45, 11, 'LGY-RP'),
(81, 601, '1584.931762', '-1667.441284', '5.694205', '269.739379', 1, 5, 0, 114, 80, 'LGY-RP'),
(82, 528, '1602.633178', '-1684.208984', '5.860267', '90.416587', 1, 3, 0, 58, 123, 'LGY-RP'),
(83, 528, '612.244445', '-601.913574', '17.279455', '274.045837', 2, 2, 0, 117, 69, 'LGY-RP'),
(84, 528, '1602.478881', '-1688.078125', '5.851233', '89.740539', 1, 4, 0, 73, 41, 'LGY-RP'),
(85, 522, '1484.902587', '-1770.612182', '18.369907', '356.815856', 5, 0, 0, 0, 0, 'LGY-RP'),
(86, 427, '1548.939697', '-1697.840942', '13.703846', '89.309570', 1, 2, 0, 0, 1, 'LGY-RP'),
(87, 596, '1587.363891', '-1606.223632', '13.112287', '179.535766', 1, 1, 0, 0, 1, 'LGY-RP'),
(88, 531, '-372.920989', '-1419.807250', '25.692777', '356.449371', 0, 0, 7, 3, 3, 'LGY-RP'),
(89, 566, '2047.274902', '-1130.184082', '23.859603', '269.242675', 0, 0, 0, -1, -1, 'LGY-RP'),
(90, 531, '-364.821899', '-1439.898681', '25.688907', '90.760787', 0, 0, 7, 194, 194, 'LGY-RP'),
(91, 448, '2096.049', '-1800.328', '12.984', '88.012', 0, 0, 6, 11, 106, 'LGY-RP'),
(92, 531, '-366.108642', '-1412.944458', '25.690317', '66.621368', 0, 0, 7, 155, 155, 'LGY-RP'),
(93, 531, '-372.383087', '-1414.140136', '25.690359', '358.093688', 0, 0, 7, 200, 200, 'LGY-RP'),
(94, 448, '2095.559', '-1793.033', '12.987', '86.208', 0, 0, 6, 65, 76, 'LGY-RP'),
(95, 560, '1097.984130', '-1218.627441', '17.503547', '2.459191', 13, 1, 0, 154, 1, 'LGY-RP'),
(96, 405, '1102.588134', '-1218.370361', '17.679687', '359.859405', 13, 1, 0, 154, 1, 'LGY-RP'),
(97, 560, '1092.917358', '-1218.652343', '17.501621', '1.938484', 13, 1, 0, 154, 1, 'LGY-RP'),
(98, 405, '1107.993652', '-1218.451416', '17.679672', '0.076616', 13, 3, 0, 154, 1, 'LGY-RP'),
(99, 487, '1134.104736', '-1170.911010', '32.220951', '179.289489', 13, 3, 0, 154, 1, 'LGY-RP'),
(100, 487, '1144.522705', '-1170.206054', '32.224224', '180.682708', 13, 3, 0, 154, 1, 'LGY-RP'),
(101, 487, '1552.277465', '-1350.022216', '329.650451', '111.027709', 12, 3, 0, 43, 43, 'LGY-RP'),
(102, 410, '840.087768', '-1135.691772', '23.417531', '277.746734', 0, 0, 0, -1, -1, 'LGY-RP'),
(103, 402, '1070.849731', '-293.676483', '73.752510', '179.120849', 12, 1, 0, 43, 0, 'LGY-RP'),
(104, 492, '2510.045166', '-1674.910522', '13.245689', '60.717319', 7, 1, 0, 187, 187, 'LGY-RP'),
(105, 521, '1016.884', '-1123.923', '23.43', '170.215', 9, 2, 0, 130, 130, 'LGY-RP'),
(106, 579, '1034.495605', '-1119.471557', '23.663715', '178.125610', 9, 1, 0, 130, 130, 'LGY-RP'),
(107, 405, '1883.002929', '-2003.487792', '13.421804', '180.527862', 8, 1, 0, 135, 135, 'LGY-RP'),
(108, 461, '1027.519', '-1123.549', '23.465', '179.322', 9, 1, 0, 130, 130, 'LGY-RP'),
(109, 575, '2428.582031', '-1243.364624', '23.743181', '357.442718', 0, 0, 0, -1, -1, 'LGY-RP'),
(110, 582, '-303.332458', '1832.752319', '42.346565', '315.098785', 15, 0, 0, 29, 5, 'LGY-RP'),
(111, 582, '-320.812011', '1515.662597', '75.417198', '359.756896', 15, 1, 0, 1, 49, 'LGY-RP'),
(112, 410, '666.033569', '-1538.716796', '14.493157', '268.467285', 0, 0, 0, -1, -1, 'LGY-RP'),
(113, 582, '-327.388275', '1515.801391', '75.461692', '1.748215', 15, 1, 0, 122, 5, 'LGY-RP'),
(114, 589, '531.583984', '-1289.741455', '16.985603', '359.290863', 0, 0, 0, 3, 48, 'LGY-RP'),
(115, 582, '-333.308868', '1514.924316', '75.422492', '357.035308', 15, 1, 0, 94, 34, 'LGY-RP'),
(116, 550, '545.554321', '-1290.751953', '17.084180', '358.742370', 0, 0, 0, 94, 106, 'LGY-RP'),
(117, 542, '2570.943115', '-1490.339721', '23.759757', '265.611328', 0, 0, 0, -1, -1, 'LGY-RP'),
(118, 482, '2511.543457', '-1669.245727', '13.587042', '86.512283', 7, 1, 0, 187, 1, 'LGY-RP'),
(119, 461, '2489.490478', '-1686.006103', '13.104640', '359.943450', 7, 1, 0, 187, 1, 'LGY-RP'),
(120, 410, '399.209747', '-1373.389160', '14.499610', '301.991882', 0, 0, 0, -1, -1, 'LGY-RP'),
(121, 531, '-382.986358', '-1417.885009', '25.689567', '290.230651', 0, 0, 7, 229, 229, 'LGY-RP'),
(122, 496, '551.548461', '-1290.810058', '16.931085', '352.287445', 0, 0, 0, 187, 1, 'LGY-RP'),
(123, 531, '-378.199096', '-1450.825927', '25.690685', '0.079130', 0, 0, 7, 151, 151, 'LGY-RP'),
(124, 521, '2491.655761', '-1685.870727', '13.075943', '0.883098', 7, 0, 0, 187, 1, 'LGY-RP'),
(125, 407, '1188.152343', '-1348.607666', '13.730781', '358.341705', 4, 4, 0, 3, 1, 'LGY-RP'),
(126, 550, '1323.911987', '-1459.679077', '13.378744', '270.090759', 0, 0, 0, -1, -1, 'LGY-RP'),
(127, 567, '2508.500488', '-1660.170043', '13.386986', '122.571006', 7, 1, 0, 187, 1, 'LGY-RP'),
(128, 560, '2507.113037', '-1679.709228', '13.170280', '43.955913', 7, 1, 0, 187, 1, 'LGY-RP'),
(129, 426, '2480.991210', '-1654.607910', '13.130502', '90.501976', 7, 1, 0, 187, 1, 'LGY-RP'),
(130, 488, '-292.506378', '1537.177368', '75.769248', '248.189926', 15, 2, 0, 9, 8, 'LGY-RP'),
(131, 487, '2526.999267', '-1677.912719', '20.114021', '86.421356', 7, 0, 0, 187, 187, 'LGY-RP'),
(132, 515, '-76.408386', '-1108.019775', '2.094731', '161.749542', 0, 0, 9, 81, 89, 'LGY-RP'),
(133, 446, '-650.150451', '868.102722', '-0.541339', '228.585037', 0, 0, 0, 211, 226, 'Green Best.'),
(134, 515, '-64.117706', '-1112.762817', '2.094029', '156.754302', 0, 0, 9, 64, 123, 'LGY-RP'),
(135, 522, '2296.029785', '-1631.400512', '14.266880', '86.525787', 0, 0, 0, 67, 24, 'LGY-RP'),
(136, 468, '361.833831', '-2044.268554', '7.501624', '268.421051', 0, 0, 4, 0, 0, 'LGY-RP'),
(137, 602, '2159.134765', '-1805.201782', '13.184434', '89.954452', 0, 0, 0, -1, -1, 'LGY-RP'),
(138, 448, '2095.411', '-1820.311', '12.98', '91.097', 0, 0, 6, 99, 87, 'LGY-RP'),
(139, 515, '-69.969070', '-1110.161010', '2.094589', '159.017868', 0, 0, 9, 102, 115, 'LGY-RP'),
(140, 521, '1135.510986', '-2013.280395', '68.564575', '351.318542', 6, 1, 0, 0, 0, 'LGY-RP'),
(141, 468, '366.073608', '-2048.714355', '7.504929', '359.213653', 0, 0, 4, 0, 0, 'LGY-RP'),
(142, 462, '1844.142333', '-1871.337280', '12.989290', '359.193725', 0, 0, 0, 1, 1, 'LGY-RP'),
(143, 435, '-43.383689', '-1155.037719', '1.728225', '64.851669', 0, 0, 9, 6, 6, 'LGY-RP'),
(144, 448, '2095.208', '-1815.361', '12.982', '87.651', 0, 0, 6, 125, 31, 'LGY-RP'),
(145, 420, '1786.247436', '-1932.822631', '13.191637', '3.812190', 14, 2, 0, 6, 6, 'LGY-RP'),
(146, 468, '361.868713', '-2042.090087', '7.504942', '271.673919', 0, 0, 4, 0, 0, 'LGY-RP'),
(147, 515, '-49.827548', '-1117.484497', '2.140136', '160.653518', 0, 0, 9, 118, 23, 'LGY-RP'),
(148, 438, '1804.460083', '-1918.478759', '13.381947', '90.978271', 14, 1, 0, 6, 6, 'LGY-RP'),
(149, 435, '-38.067466', '-1144.845947', '1.710403', '62.359184', 0, 0, 9, 6, 6, 'LGY-RP'),
(150, 402, '1077.564208', '-293.608489', '73.752639', '176.113479', 12, 1, 0, 43, 43, 'LGY-RP'),
(151, 567, '1140.116455', '-2054.278320', '68.887939', '270.067749', 6, 1, 0, 0, 0, 'LGY-RP'),
(152, 405, '1140.522216', '-2048.763183', '68.873725', '279.570556', 6, 2, 0, 0, 0, 'LGY-RP'),
(153, 520, '201.591064', '1891.223754', '18.369132', '354.524566', 3, 2, 0, 6, 6, 'LGY-RP'),
(154, 487, '1963.766845', '-2647.876708', '13.714962', '358.484558', 0, 0, 0, -1, -1, 'LGY-RP'),
(155, 487, '1973.071777', '-2647.945800', '13.717036', '352.316680', 0, 0, 0, -1, -1, 'LGY-RP'),
(156, 525, '864.007812', '-1255.789672', '14.745947', '267.284606', 0, 0, 0, 109, 14, 'LGY-RP'),
(157, 468, '361.852447', '-2046.147216', '7.499322', '267.819641', 0, 0, 4, 0, 0, 'LGY-RP'),
(158, 577, '1933.041748', '-2377.893798', '13.439205', '176.714843', 0, 0, 0, 101, 112, 'LGY-RP'),
(159, 519, '1890.380004', '-2627.763671', '14.451828', '358.420501', 0, 0, 0, -1, -1, 'LGY-RP'),
(160, 401, '892.717102', '-1669.139648', '13.330414', '359.212677', 0, 0, 0, 5, 5, 'LGY-RP'),
(161, 462, '1835.009155', '-1871.216064', '12.989219', '0.770780', 0, 0, 0, 1, 1, 'LGY-RP'),
(162, 511, '1684.139892', '-2628.005615', '14.921717', '0.000000', 0, 0, 0, -1, -1, 'LGY-RP'),
(163, 485, '1655.062988', '-2538.219726', '13.203288', '88.035346', 0, 0, 0, -1, -1, 'LGY-RP'),
(164, 485, '1652.384277', '-2547.680908', '13.201418', '88.283134', 0, 0, 0, -1, -1, 'LGY-RP'),
(165, 435, '-35.697303', '-1140.494995', '1.712750', '60.601913', 0, 0, 9, 6, 6, 'LGY-RP'),
(166, 435, '-40.793857', '-1149.991577', '1.714925', '62.594215', 0, 0, 9, 6, 6, 'LGY-RP'),
(167, 582, '-339.993377', '1515.486328', '75.404479', '0.726874', 15, 1, 0, 46, 43, 'LGY-RP'),
(168, 582, '-346.128387', '1514.992309', '75.351348', '2.079033', 15, 1, 0, 50, 22, 'LGY-RP'),
(169, 525, '909.745056', '-1207.685302', '16.859603', '197.486114', 0, 0, 3, 31, 98, 'LGY-RP'),
(170, 416, '1181.578491', '-1308.761962', '13.697491', '270.376525', 4, 1, 0, 1, 3, 'LGY-RP'),
(171, 438, '1777.114013', '-1914.521728', '13.443995', '269.483825', 14, 1, 0, 6, 6, 'LGY-RP'),
(172, 420, '1801.033203', '-1932.433105', '13.166593', '359.703277', 14, 2, 0, 6, 6, 'LGY-RP'),
(173, 438, '1776.804565', '-1908.218261', '13.451959', '273.895050', 14, 1, 0, 6, 6, 'LGY-RP'),
(174, 438, '1777.054565', '-1921.168579', '13.443326', '269.493286', 14, 1, 0, 6, 6, 'LGY-RP'),
(175, 438, '1776.927124', '-1928.216552', '13.453701', '269.539001', 14, 1, 0, 6, 6, 'LGY-RP'),
(176, 560, '1804.727294', '-1913.525024', '13.100573', '90.387313', 14, 3, 0, 6, 6, 'LGY-RP'),
(177, 560, '1804.548217', '-1908.828002', '13.078456', '88.640220', 14, 5, 0, 6, 6, 'LGY-RP'),
(178, 420, '1791.263183', '-1932.714111', '13.165579', '1.916643', 14, 2, 0, 6, 6, 'LGY-RP'),
(179, 410, '1920.082641', '768.319702', '10.397954', '270.162994', 0, 0, 0, 62, 50, 'LGY-RP'),
(180, 420, '1796.096557', '-1932.580566', '13.197487', '359.999908', 14, 2, 0, 6, 6, 'LGY-RP'),
(181, 604, '1303.373901', '-1249.778930', '13.291378', '181.637954', 0, 0, 0, -1, -1, 'LGY-RP'),
(182, 531, '-381.534362', '-1450.808837', '25.692184', '0.044235', 0, 0, 7, 211, 211, 'LGY-RP'),
(183, 469, '1017.251831', '-326.074188', '74.021759', '270.292602', 12, 1, 0, 32, 88, 'LGY-RP'),
(184, 435, '-1883.501220', '-1740.955566', '21.465568', '24.041904', 0, 0, 0, 18, 86, 'LGY-RP'),
(185, 550, '2154.414550', '2287.003417', '10.652217', '331.367614', 0, 0, 0, 1, 1, 'LGY-RP'),
(186, 531, '-371.072723', '-1447.306030', '25.687398', '1.865961', 0, 0, 7, 226, 226, 'LGY-RP'),
(187, 468, '362.019714', '-2041.654174', '7.502812', '271.424499', 0, 0, 4, 0, 50, 'LGY-RP'),
(188, 462, '1832.225219', '-1871.270996', '12.982564', '359.430755', 0, 0, 0, 1, 1, '69'),
(189, 525, '867.358825', '-1207.767089', '16.845207', '180.429077', 0, 0, 3, 21, 106, 'LGY-RP'),
(190, 490, '641.678161', '-609.968505', '16.408372', '356.824523', 2, 2, 0, 0, 0, 'LGY-RP'),
(191, 596, '637.350891', '-581.358642', '15.985299', '0.669322', 2, 0, 0, 1, 7, 'LGY-RP'),
(192, 411, '622.812133', '-610.699829', '16.831209', '267.578613', 2, 3, 0, 1, 7, 'FBI'),
(193, 468, '361.939941', '-2039.607299', '7.501790', '272.110168', 0, 0, 4, 0, 0, 'LGY-RP'),
(194, 468, '204.255432', '1859.478393', '12.801395', '265.903320', 3, 1, 0, 226, 226, 'LGY-RP'),
(195, 596, '1536.009643', '-1667.107910', '13.103435', '180.151962', 1, 1, 0, 0, 1, 'LGY-RP'),
(196, 596, '1582.866455', '-1606.087524', '13.110598', '177.078216', 1, 1, 0, 0, 1, 'LGY-RP'),
(197, 411, '1604.639160', '-1625.186767', '13.242486', '91.487075', 1, 6, 0, 1, 1, 'LGY-RP'),
(198, 411, '1604.824340', '-1628.482421', '13.244470', '92.975158', 1, 3, 0, 1, 1, 'LGY-RP'),
(199, 599, '1604.333862', '-1621.380004', '13.584363', '91.410209', 1, 1, 0, 0, 1, 'LGY-RP'),
(200, 599, '1604.291137', '-1616.857177', '13.759970', '90.415290', 1, 2, 0, 0, 1, 'LGY-RP'),
(201, 523, '1544.999755', '-1611.396118', '12.951971', '274.110046', 1, 1, 0, 0, 0, 'LGY-RP'),
(202, 468, '204.089935', '1861.432495', '12.805898', '270.071960', 3, 1, 0, 226, 266, 'LGY-RP'),
(203, 523, '1544.848266', '-1609.261474', '12.948449', '268.876464', 1, 1, 0, 0, 0, 'LGY-RP'),
(204, 523, '1548.881347', '-1680.979003', '13.124260', '74.915351', 1, 2, 0, 0, 0, 'LGY-RP'),
(205, 523, '1549.749877', '-1670.374511', '13.137615', '92.311454', 1, 2, 0, 0, 0, 'LGY-RP'),
(206, 523, '611.448242', '-586.765686', '16.784387', '272.561370', 2, 0, 0, 0, 0, 'LGY-RP'),
(207, 596, '1536.023925', '-1678.256225', '13.104019', '358.525115', 1, 2, 0, 0, 1, 'LGY-RP'),
(208, 405, '2607.853515', '-2199.597900', '13.421837', '179.172424', 0, 0, 0, -1, -1, 'LGY-RP'),
(209, 404, '126.929542', '-1724.885253', '7.730700', '214.006896', 0, 0, 0, -1, -1, 'LGY-RP'),
(210, 521, '2214.177246', '-1347.132568', '23.552923', '272.174865', 10, 1, 0, 233, 233, 'LGY-RP'),
(211, 566, '2231.185058', '-1366.601684', '23.796449', '0.318983', 10, 1, 0, 233, 233, 'LGY-RP'),
(212, 470, '236.843856', '1905.578979', '17.668943', '93.039596', 3, 0, 0, 96, 3, 'LGY-RP'),
(213, 525, '864.559936', '-1245.135498', '14.494702', '274.209381', 0, 0, 3, 92, 39, 'LGY-RP'),
(214, 579, '2229.326904', '-1343.303588', '23.857576', '89.742080', 10, 1, 0, 233, 233, 'LGY-RP'),
(215, 502, '2757.459472', '-1876.182373', '9.594129', '178.667373', 0, 0, 0, -1, -1, 'LGY-RP'),
(216, 602, '2776.788574', '-1840.178222', '9.587071', '19.632228', 0, 0, 0, -1, -1, 'LGY-RP'),
(217, 531, '-364.901397', '-1442.798828', '25.693155', '88.870803', 0, 0, 7, 181, 181, 'LGY-RP'),
(218, 603, '523.803710', '-1289.223632', '17.038848', '358.521697', 0, 0, 0, 104, 87, 'LGY-RP'),
(219, 561, '856.994934', '-1365.049560', '13.336494', '180.474197', 0, 0, 0, -1, -1, 'LGY-RP'),
(220, 567, '2214.374023', '-1358.833007', '23.889568', '180.736541', 10, 1, 0, 233, 233, 'LGY-RP'),
(221, 461, '2214.227050', '-1349.809326', '23.569465', '271.887939', 10, 1, 0, 233, 233, 'LGY-RP'),
(222, 453, '338.139556', '-2161.123046', '-0.208551', '146.548873', 0, 0, 0, -1, -1, 'LGY-RP'),
(223, 608, '1936.943359', '-2397.021240', '14.071707', '85.179031', 0, 0, 0, -1, -1, 'LGY-RP'),
(224, 515, '-57.380794', '-1114.509277', '2.139424', '158.131317', 0, 0, 9, 51, 115, 'LGY-RP'),
(225, 531, '-361.835815', '-1409.894775', '25.690982', '90.777030', 0, 0, 7, 233, 233, 'LGY-RP'),
(226, 563, '1158.884277', '-1372.435913', '27.366823', '266.991638', 4, 3, 0, 3, 1, 'LGY-RP'),
(227, 462, '1838.278686', '-1871.225952', '12.988386', '1.324307', 0, 0, 0, 1, 1, 'LGY-RP'),
(228, 560, '1867.691894', '-2031.133300', '13.251774', '270.796600', 8, 1, 0, 135, 135, 'LGY-RP'),
(229, 579, '1895.163085', '-2037.728881', '13.477427', '90.223442', 8, 1, 0, 135, 135, 'LGY-RP'),
(230, 521, '1870.686889', '-2034.595825', '13.117939', '270.396118', 8, 0, 0, 135, 135, 'LGY-RP'),
(231, 487, '1899.782348', '-2024.568603', '18.984470', '88.240791', 8, 0, 0, 135, 135, 'LGY-RP'),
(232, 461, '1870.946533', '-2038.161254', '13.120438', '268.233520', 8, 0, 0, 135, 135, 'LGY-RP'),
(233, 560, '720.308959', '-1432.845092', '13.192288', '86.177566', 11, 0, 0, 6, 6, 'LGY-RP'),
(234, 521, '703.191223', '-1420.469726', '13.105791', '0.327479', 11, 1, 0, 6, 6, 'LGY-RP'),
(235, 405, '713.139160', '-1426.542236', '13.438203', '3.561102', 11, 1, 0, 6, 6, 'LGY-RP'),
(236, 487, '717.379150', '-1443.501464', '17.858652', '2.938129', 11, 1, 0, 6, 6, 'LGY-RP'),
(237, 461, '703.405456', '-1426.652343', '13.116523', '0.747424', 11, 1, 0, 6, 6, 'LGY-RP'),
(238, 579, '703.172058', '-1437.276245', '13.446467', '285.213195', 11, 1, 0, 6, 6, 'LGY-RP'),
(239, 547, '1216.188354', '-1828.613525', '13.143385', '182.191833', 0, 0, 0, 7, 7, 'LGY-RP'),
(240, 547, '1219.030517', '-1828.537963', '13.142826', '182.436920', 0, 0, 0, 7, 7, 'LGY-RP'),
(241, 547, '1228.632812', '-1828.432495', '13.141334', '181.421752', 0, 0, 0, 7, 7, 'LGY-RP'),
(242, 547, '1221.980834', '-1828.520263', '13.143394', '181.165496', 0, 0, 0, 7, 7, 'LGY-RP'),
(243, 435, '2480.627929', '-2116.180908', '14.181365', '357.768463', 0, 0, 0, -1, -1, 'FG'),
(244, 435, '2464.615966', '-2116.684570', '14.184091', '6.568890', 0, 0, 0, -1, -1, 'FG'),
(245, 435, '2456.430664', '-2116.031494', '14.185961', '359.931457', 0, 0, 0, -1, -1, 'FG'),
(246, 435, '2473.649902', '-2116.341796', '14.204502', '1.565792', 0, 0, 0, -1, -1, 'FG'),
(247, 435, '2487.777099', '-2115.985351', '14.205719', '358.817535', 0, 0, 0, -1, -1, 'FG'),
(248, 435, '2495.696533', '-2116.152099', '14.205096', '358.468322', 0, 0, 0, -1, -1, 'FG');
/*!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 */;

EquiNoxAdv · August 29, 2015

Arata-mi linia 1--2

Master18 · August 29, 2015

Arata-mi linia 1--2

-- phpMyAdmin SQL Dump
-- version 3.4.11.1deb2

EquiNoxAdv · August 29, 2015

Posteaza toata baza daca nu te deranjeaza.

Master18 · August 29, 2015

Posteaza toata baza daca nu te deranjeaza.

-- phpMyAdmin SQL Dump
-- version 3.4.11.1deb2
-- http://www.phpmyadmin.net
--
-- Gazda: localhost
-- Timp de generare: 03 Iul 2015 la 19:30
-- Versiune server: 5.5.31
-- Versiune PHP: 5.4.4-14+deb7u5
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 */;
--
-- Baza de date: `zp_hid9114`
--
CREATE DATABASE `zp_hid9114` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `zp_hid9114`;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `adminlog`
--
CREATE TABLE IF NOT EXISTS `adminlog` (
`entryID` int(11) NOT NULL AUTO_INCREMENT,
`value` varchar(255) NOT NULL,
`entryTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`tickcount` int(12) NOT NULL DEFAULT '0',
PRIMARY KEY (`entryID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;
--
-- Salvarea datelor din tabel `adminlog`
--
INSERT INTO `adminlog` (`entryID`, `value`, `entryTime`, `tickcount`) VALUES
(1, 'FloriynScr has cleared the chat.', '2014-12-20 19:35:20', 24469769),
(2, 'Admin FloriynScr has spawned FloriynScr.', '2014-12-21 11:18:47', 4960235),
(3, 'Admin FloriynScr has spawned FloriynScr.', '2014-12-21 11:23:26', 5237988),
(4, 'Admin FloriynScr has spawned FloriynScr.', '2014-12-21 11:23:28', 5240175),
(5, 'Admin FloriynScr has spawned FloriynScr.', '2014-12-21 11:23:29', 5241222),
(6, 'FloriynScr has cleared the chat.', '2014-12-21 12:53:58', 10655916),
(7, 'FloriynScr has cleared the chat.', '2014-12-21 12:54:23', 10681322),
(8, 'FloriynScr has cleared the chat.', '2014-12-21 12:54:25', 10683488),
(9, 'Admin FloriynScr has spawned FloriynScr.', '2014-12-22 08:04:38', 6571039),
(10, 'Admin FloriynScr has spawned FloriynScr.', '2014-12-22 08:28:05', 7974710),
(11, 'Admin FloriynScr has spawned FloriynScr.', '2014-12-22 08:32:16', 8224302),
(12, 'Admin FloriynScr has spawned FloriynScr.', '2014-12-22 09:15:49', 10831396),
(13, 'Admin FloriynScr has spawned FloriynScr.', '2014-12-23 10:04:16', 10586068),
(14, 'Admin BogdanScr. has spawned BogdanScr..', '2015-01-06 13:13:24', 1725213);
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `aplications`
--
CREATE TABLE IF NOT EXISTS `aplications` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`intrebarea1` text NOT NULL,
`status` int(69) NOT NULL DEFAULT '0',
`factionid` int(69) NOT NULL DEFAULT '0',
`playerid` int(69) NOT NULL,
`intrebarea2` text NOT NULL,
`intrebarea3` text NOT NULL,
`intrebarea4` text NOT NULL,
`intrebarea5` text NOT NULL,
`intrebarea6` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `assets`
--
CREATE TABLE IF NOT EXISTS `assets` (
`assetID` int(6) NOT NULL AUTO_INCREMENT,
`assetName` varchar(255) NOT NULL DEFAULT '(null)',
`assetValue` varchar(255) NOT NULL DEFAULT '(null)',
`Status` int(10) NOT NULL DEFAULT '0',
PRIMARY KEY (`assetID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `atms`
--
CREATE TABLE IF NOT EXISTS `atms` (
`atmId` int(11) NOT NULL AUTO_INCREMENT,
`atmPosX` varchar(128) NOT NULL,
`atmPosY` varchar(128) NOT NULL,
`atmPosZ` varchar(128) NOT NULL,
`atmPosRotX` varchar(128) NOT NULL,
`atmPosRotY` varchar(128) NOT NULL,
`atmPosRotZ` varchar(128) NOT NULL,
PRIMARY KEY (`atmId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=25 ;
--
-- Salvarea datelor din tabel `atms`
--
INSERT INTO `atms` (`atmId`, `atmPosX`, `atmPosY`, `atmPosZ`, `atmPosRotX`, `atmPosRotY`, `atmPosRotZ`) VALUES
(1, '2228.39', '-1707.78', '13.25', '0', '0', '270.0'),
(2, '2228.39', '-1707.78', '13.25', '0', '0', '270.0'),
(3, '1275.7958984375', '368.31481933594', '19.19758605957', '0', '0', '73.759948730469'),
(4, '1260.8796386719', '209.30152893066', '19.19758605957', '0', '0', '65.504638671875'),
(5, '2303.4577636719', '-13.539554595947', '26.12727355957', '0', '0', '272.43542480469'),
(6, '2316.1015625', '-88.522567749023', '26.12727355957', '0', '0', '0'),
(7, '1155.6235351563', '-1464.9141845703', '15.44321346283', '0', '0', '290.21020507813'),
(8, '387.16552734375', '-1816.0512695313', '7.4834146499634', '0', '0', '272.48046875'),
(9, '-24.385023117065', '-92.001075744629', '1003.1897583008', '0', '0', '180.54052734375'),
(10, '-31.811220169067', '-58.106018066406', '1003.1897583008', '0', '0', '181.21594238281'),
(11, '1212.7785644531', '2.451762676239', '1000.5647583008', '0', '0', '0'),
(12, '2324.4028320313', '-1644.9445800781', '14.469946861267', '0', '0', '0'),
(13, '651.19305419922', '-520.48815917969', '15.978837013245', '0', '0', '0'),
(14, '691.08215332031', '-618.5625', '15.978837013245', '0', '0', '268.69067382813'),
(15, '45.78035736084', '-291.80926513672', '1.5024013519287', '0', '0', '182.93444824219'),
(16, '173.23471069336', '-155.07606506348', '1.2210245132446', '0', '0', '89.730041503906'),
(17, '294.80', '-84.01', '1001.0', '0.00000000', '0.00000000', '90.00000000'),
(18, '2065.439453125', '-1897.5510253906', '13.19670009613', '0', '0', '0'),
(19, '1497.7467041016', '-1749.8747558594', '15.088212013245', '0', '0', '177.38134765625'),
(20, '2093.5124511719', '-1359.5474853516', '23.62727355957', '0', '0', '0'),
(21, '2139.4487304688', '-1164.0811767578', '23.63508605957', '0', '0', '91.309509277344'),
(22, '1482.7761230469', '-1010.3353881836', '26.48664855957', '0', '0', '0'),
(23, '-1835.60144043', '63.24560547', '1054.83203125', '0.00000000', '0.00000000', '270.00000000'),
(24, '-1835.59985352', '64.59873199', '1054.83203125', '0.00000000', '0.00000000', '270.00000000');
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `banksuspensions`
--
CREATE TABLE IF NOT EXISTS `banksuspensions` (
`transactionID` int(32) NOT NULL AUTO_INCREMENT,
`suspendeeID` int(32) NOT NULL,
`playerID` int(32) NOT NULL,
`suspensionReason` varchar(128) NOT NULL,
PRIMARY KEY (`transactionID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `bans`
--
CREATE TABLE IF NOT EXISTS `bans` (
`banID` int(12) NOT NULL AUTO_INCREMENT,
`playerNameBanned` varchar(24) NOT NULL,
`playerBanReason` varchar(512) NOT NULL,
`playerBanDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`IPBanned` varchar(32) NOT NULL,
`playerBannedBy` varchar(24) NOT NULL DEFAULT 'System',
PRIMARY KEY (`banID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `bugs`
--
CREATE TABLE IF NOT EXISTS `bugs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`playerid` int(11) NOT NULL DEFAULT '0',
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`type` int(11) NOT NULL DEFAULT '0',
`title` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `bugscomments`
--
CREATE TABLE IF NOT EXISTS `bugscomments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`bugid` int(11) NOT NULL,
`playerid` int(11) NOT NULL,
`name` varchar(255) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `businesses`
--
CREATE TABLE IF NOT EXISTS `businesses` (
`businessID` int(6) NOT NULL AUTO_INCREMENT,
`businessName` varchar(32) NOT NULL DEFAULT '(null)',
`businessOwner` varchar(24) NOT NULL DEFAULT 'Nobody',
`businessType` int(6) NOT NULL DEFAULT '0',
`businessExteriorX` varchar(255) NOT NULL DEFAULT '0',
`businessExteriorY` varchar(255) NOT NULL DEFAULT '0',
`businessExteriorZ` varchar(255) NOT NULL DEFAULT '0',
`businessInteriorX` varchar(255) NOT NULL DEFAULT '0',
`businessInteriorY` varchar(255) NOT NULL DEFAULT '0',
`businessInteriorZ` varchar(255) NOT NULL DEFAULT '0',
`businessInterior` int(6) NOT NULL DEFAULT '0',
`businessLock` int(6) NOT NULL DEFAULT '1',
`businessPrice` int(12) NOT NULL DEFAULT '0',
`businessVault` int(12) NOT NULL DEFAULT '0',
`businessMiscX` varchar(255) NOT NULL DEFAULT '0.0',
`businessMiscY` varchar(255) NOT NULL DEFAULT '0.0',
`businessMiscZ` varchar(255) NOT NULL DEFAULT '0.0',
`businessEnterPrice` int(12) NOT NULL DEFAULT '1',
`businessLevel` int(6) NOT NULL DEFAULT '0',
PRIMARY KEY (`businessID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=30 ;
--
-- Salvarea datelor din tabel `businesses`
--
INSERT INTO `businesses` (`businessID`, `businessName`, `businessOwner`, `businessType`, `businessExteriorX`, `businessExteriorY`, `businessExteriorZ`, `businessInteriorX`, `businessInteriorY`, `businessInteriorZ`, `businessInterior`, `businessLock`, `businessPrice`, `businessVault`, `businessMiscX`, `businessMiscY`, `businessMiscZ`, `businessEnterPrice`, `businessLevel`) VALUES
(1, '24/7 Fish', 'Nobody', 1, '1352.411', '-1759.253', '13.508', '-27.725', '-31.311', '1003.557', 4, 0, 450000, 6, '0.0', '0.0', '0.0', 6, 7),
(2, '24/7 business.', 'Nobody', 1, '1833.084', '-1842.775', '13.578', '-26.037', '-188.013', '1003.547', 17, 0, 450000, 1, '0.0', '0.0', '0.0', 1, 7),
(3, 'Business', 'Nobody', 2, '2244.323', '-1664.979', '15.477', '207.731', '-110.747', '1005.133', 15, 0, 320000, 10, '0.0', '0.0', '0.0', 10, 5),
(4, 'Business', 'Nobody', 7, '810.501', '-1616.247', '13.547', '362.858', '-75.151', '1001.508', 10, 0, 380000, 0, '0.0', '0.0', '0.0', 1, 5),
(5, 'Club BAMBO', 'Nobody', 3, '1837.039', '-1682.38', '13.323', '493.422', '-24.824', '1000.68', 17, 0, 310000, 0, '0.0', '0.0', '0.0', 1, 4),
(22, 'Business 24/7', 'Nobody', 1, '-792.172', '1627.795', '27.156', '-26.017', '-187.491', '1003.547', 17, 0, 350000, 0, '0.0', '0.0', '0.0', 1, 5),
(6, 'Banca Los Santos', 'Nobody', 8, '1457.092', '-1009.924', '26.844', '2305.546', '-16.009', '26.75', 0, 0, 550000, 0, '0.0', '0.0', '0.0', 400, 8),
(7, 'GYM los santos', 'Nobody', 6, '2230.003', '-1721.358', '13.562', '772.036', '-4.949', '1000.728', 5, 0, 350000, 2, '0.0', '0.0', '0.0', 1, 3),
(8, 'Business', 'Nobody', 4, '1087.832', '-922.49', '43.391', '-100.552', '-24.674', '1000.719', 3, 0, 290000, 0, '0.0', '0.0', '0.0', 1, 3),
(9, 'De vanzare!', 'Nobody', 7, '1199.253', '-918.155', '43.123', '362.87', '-75.167', '1001.508', 10, 0, 360000, 0, '0.0', '0.0', '0.0', 1, 5),
(10, 'CNN Los Santos SRL', 'Nobody', 9, '1170.91', '-1489.198', '22.755', '-959.532', '1956.162', '9.0', 17, 0, 600000, 0, '0.0', '0.0', '0.0', 200, 9),
(11, 'OMV CENTRAL MONEY', 'Nobody', 10, '1102.413', '-1440.322', '15.797', '965.092', '2108.646', '1011.03', 1, 0, 400000, 1, '0.0', '0.0', '0.0', 1, 5),
(12, 'Business', 'Nobody', 2, '2101.893', '2257.456', '11.023', '-2240.469', '137.06', '1035.414', 6, 0, 330000, 0, '0.0', '0.0', '0.0', 1, 4),
(13, 'Business', 'Nobody', 7, '2101.901', '2228.819', '11.023', '364.997', '-11.841', '1001.852', 9, 0, 310000, 0, '0.0', '0.0', '0.0', 1, 4),
(14, 'Business', 'Nobody', 1, '2637.258', '1129.678', '11.18', '6.074', '-31.612', '1003.549', 10, 0, 350000, 0, '0.0', '0.0', '0.0', 1, 4),
(16, 'Fish 24/7', 'Nobody', 1, '1000.401', '-919.979', '42.328', '-27.291', '-58.268', '1003.547', 6, 0, 400000, 0, '0.0', '0.0', '0.0', 10, 6),
(15, 'PNS Central LS.', 'Nobody', 12, '1034.459', '-1027.773', '32.102', '964.638', '2107.615', '1011.03', 1, 0, 500000, 0, '0.0', '0.0', '0.0', 1, 6),
(18, 'Business', 'Nobody', 14, '517.489', '-1296.523', '17.242', '1420.084', '3.703', '1002.391', 1, 0, 310000, 0, '0.0', '0.0', '0.0', 1, 5),
(17, 'Business', 'Nobody', 13, '1791.851', '-1163.124', '23.828', '315.768', '-143.611', '999.602', 7, 0, 450000, 0, '0.0', '0.0', '0.0', 450, 7),
(19, 'ARENA PENTRU EVENT ', 'Nobody', 0, '1511.831', '-1061.18', '25.063', '-1443.884', '930.281', '1036.483', 15, 0, 1000000, 0, '0.0', '0.0', '0.0', 1, 10),
(20, 'Business', 'Nobody', 3, '2310.073', '-1643.526', '14.827', '502.045', '-68.375', '998.758', 11, 0, 340000, 0, '0.0', '0.0', '0.0', 1, 5),
(21, 'Business', 'Nobody', 3, '2421.5', '-1219.242', '25.562', '501.969', '-67.568', '998.758', 11, 0, 300000, 0, '0.0', '0.0', '0.0', 1, 3),
(23, 'Binco', 'Nobody', 2, '-818.123', '1551.222', '27.117', '207.271', '-139.582', '1003.508', 3, 0, 300000, 0, '0.0', '0.0', '0.0', 1, 4),
(24, 'Banca LB', 'Nobody', 8, '-828.139', '1504.054', '19.829', '2304.946', '-16.275', '26.742', 0, 0, 400000, 0, '0.0', '0.0', '0.0', 1, 6),
(25, 'KFC', 'Nobody', 0, '-857.945', '1535.347', '22.587', '372.91', '-133.493', '1001.492', 5, 0, 250000, 0, '0.0', '0.0', '0.0', 1, 3),
(26, 'Nothing', 'Nobody', 8, '2196.776', '1677.137', '12.367', '2315.731', '-0.305', '26.742', 0, 0, 350000, 0, '0.0', '0.0', '0.0', 1, 4),
(27, 'Business', 'Nobody', 2, '-823.422', '1481.095', '19.649', '-100.132', '-25.033', '1000.719', 3, 0, 300000, 0, '0.0', '0.0', '0.0', 1, 4),
(28, 'Farmer', 'Nobody', 7, '417.896', '-1728.93', '9.261', '-27.725', '-31.311', '1003.557', 4, 0, 400000, 50, '0.0', '0.0', '0.0', 50, 5),
(29, 'Four Dragon Casino', 'Nobody', 10, '2019.778', '1007.669', '10.82', '2018.817', '1017.788', '996.875', 10, 0, 350000, 0, '0.0', '0.0', '0.0', 1, 5);
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `businessitems`
--
CREATE TABLE IF NOT EXISTS `businessitems` (
`itemId` int(6) NOT NULL AUTO_INCREMENT,
`itemBusinessId` int(6) NOT NULL DEFAULT '0',
`itemTypeId` int(6) NOT NULL DEFAULT '0',
`itemPrice` int(6) NOT NULL DEFAULT '10',
`itemName` varchar(64) NOT NULL DEFAULT 'Undefined',
PRIMARY KEY (`itemId`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=115 ;
--
-- Salvarea datelor din tabel `businessitems`
--
INSERT INTO `businessitems` (`itemId`, `itemBusinessId`, `itemTypeId`, `itemPrice`, `itemName`) VALUES
(18, 8, 9, 10, 'Purple Dildo'),
(19, 8, 10, 15, 'Small White Vibrator'),
(20, 8, 11, 20, 'Large White Vibrator'),
(21, 8, 12, 15, 'Silver Vibrator'),
(22, 8, 13, 10, 'Flowers'),
(24, 2, 1, 5, 'Nothing yet'),
(25, 2, 2, 15, 'Walkie Talkie'),
(26, 2, 3, 10, 'Phone Book'),
(27, 2, 4, 10, 'Phone Credit'),
(28, 2, 5, 10, 'Mobile Phone'),
(29, 4, 6, 5, 'Box Meal 1'),
(30, 4, 7, 10, 'Box Meal 2'),
(31, 4, 8, 20, 'Box Meal 3'),
(32, 9, 6, 5, 'Box Meal 1'),
(33, 9, 7, 10, 'Box Meal 2'),
(34, 9, 8, 20, 'Box Meal 3'),
(35, 12, 18, 50, 'All Skins'),
(36, 13, 6, 5, 'Box Meal 1'),
(37, 13, 7, 10, 'Box Meal 2'),
(38, 13, 8, 20, 'Box Meal 3'),
(39, 16, 1, 5, 'Nothing yet'),
(40, 16, 2, 15, 'Walkie Talkie'),
(41, 16, 3, 10, 'Phone Book'),
(42, 16, 4, 10, 'Phone Credit'),
(43, 16, 5, 10, 'Mobile Phone'),
(53, 20, 14, 4, 'Cigar'),
(54, 20, 15, 1, 'Sprunk'),
(55, 20, 16, 10, 'Wine'),
(56, 20, 17, 3, 'Beer'),
(62, 21, 14, 4, 'Cigar'),
(63, 21, 15, 1, 'Sprunk'),
(64, 21, 16, 10, 'Wine'),
(65, 21, 17, 3, 'Beer'),
(71, 5, 14, 4, 'Cigar'),
(72, 5, 15, 1, 'Sprunk'),
(73, 5, 16, 10, 'Wine'),
(74, 5, 17, 3, 'Beer'),
(75, 14, 1, 5, 'Nothing yet'),
(76, 14, 2, 15, 'Walkie Talkie'),
(77, 14, 3, 10, 'Phone Book'),
(78, 14, 4, 10, 'Phone Credit'),
(79, 14, 5, 10, 'Mobile Phone'),
(84, 3, 18, 50, 'All Skins'),
(85, 22, 1, 5, 'Nothing yet'),
(86, 22, 2, 15, 'Walkie Talkie'),
(87, 22, 3, 10, 'Phone Book'),
(88, 22, 4, 10, 'Phone Credit'),
(89, 22, 5, 10, 'Mobile Phone'),
(100, 23, 18, 50, 'All Skins'),
(101, 27, 18, 50, 'All Skins'),
(107, 28, 6, 5, 'Box Meal 1'),
(108, 28, 7, 10, 'Box Meal 2'),
(109, 28, 8, 20, 'Box Meal 3'),
(110, 1, 1, 5, 'Nothing yet'),
(111, 1, 2, 15, 'Walkie Talkie'),
(112, 1, 3, 10, 'Phone Book'),
(113, 1, 4, 10, 'Phone Credit'),
(114, 1, 5, 10, 'Mobile Phone');
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `chat`
--
CREATE TABLE IF NOT EXISTS `chat` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`playerid` int(11) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `clans`
--
CREATE TABLE IF NOT EXISTS `clans` (
`clanID` int(12) NOT NULL AUTO_INCREMENT,
`clanName` varchar(255) NOT NULL,
`clanMOTD` varchar(128) NOT NULL,
`clanTag` varchar(255) NOT NULL DEFAULT '[NONE]',
`clanRankName7` varchar(32) NOT NULL DEFAULT '[7] Owner',
`clanRankName1` varchar(32) NOT NULL DEFAULT '[1] Newbie',
`clanRankName2` varchar(32) DEFAULT '[2] Member',
`clanRankName3` varchar(32) NOT NULL DEFAULT '[3] Advanced',
`clanRankName4` varchar(32) NOT NULL DEFAULT '[4] Expert',
`clanRankName5` varchar(32) NOT NULL DEFAULT '[5] Legend',
`clanRankName6` varchar(32) NOT NULL DEFAULT '[6] Manager',
`description` text NOT NULL,
`clanColor` varchar(255) NOT NULL DEFAULT '0x4dad2b2b',
PRIMARY KEY (`clanID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `complaints`
--
CREATE TABLE IF NOT EXISTS `complaints` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`detalii` text NOT NULL,
`time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
`creatorid` int(11) NOT NULL,
`againstid` int(11) NOT NULL,
`motiv` text NOT NULL,
`dovezi` text NOT NULL,
`status` int(11) NOT NULL DEFAULT '0',
`type` int(11) NOT NULL,
`factionid` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `complaintscomments`
--
CREATE TABLE IF NOT EXISTS `complaintscomments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`complaintid` int(11) NOT NULL,
`text` text NOT NULL,
`name` varchar(50) NOT NULL,
`playerid` int(11) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `dealer`
--
CREATE TABLE IF NOT EXISTS `dealer` (
`carID` int(11) NOT NULL,
`stock` int(11) NOT NULL DEFAULT '0',
`price` int(11) NOT NULL DEFAULT '0',
`Pprice` int(11) NOT NULL,
`name` varchar(100) NOT NULL,
PRIMARY KEY (`carID`),
UNIQUE KEY `carID` (`carID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Salvarea datelor din tabel `dealer`
--
INSERT INTO `dealer` (`carID`, `stock`, `price`, `Pprice`, `name`) VALUES
(400, 3, 50000, 0, 'Landstalker'),
(401, 2, 76000, 0, 'Bravura'),
(402, 3, 340000, 0, 'Buffalo'),
(404, 3, 500000, 0, 'Perrenial'),
(407, 3, 50000000, 0, 'Firetruck'),
(411, 4, 980000, 0, 'Infernus'),
(415, 3, 700000, 0, 'Cheetah'),
(418, 2, 70000, 0, 'Moonbeam'),
(426, 3, 215000, 0, 'Premier'),
(429, 3, 742000, 0, 'Banshee'),
(434, 3, 140000, 0, 'Hotknife'),
(439, 3, 130000, 0, 'Stallion'),
(451, 3, 850000, 0, 'Turismo'),
(461, 3, 248000, 0, 'PCJ-600'),
(462, 3, 35000, 0, 'Faggio'),
(463, 3, 245000, 0, 'Freeway'),
(468, 3, 228000, 0, 'Sanchez'),
(469, 3, 0, 100, 'Sparrow (100 PP)'),
(471, 3, 98000, 0, 'Quad'),
(474, 3, 90000, 0, 'Hermes'),
(480, 3, 305000, 0, 'Comet'),
(481, 3, 0, 200, 'BMX (200 PP)'),
(482, 3, 115000, 0, 'Buritto'),
(487, 2, 0, 100, 'Maverick (100 PP)'),
(489, 3, 237000, 0, 'Rancher'),
(494, 3, 0, 100, 'Hotring Racer (100 PP)'),
(495, 3, 295000, 0, 'Sandking'),
(496, 3, 187000, 0, 'Blista Compact'),
(500, 3, 125000, 0, 'Mesa'),
(510, 3, 0, 200, 'Mountain Bike (200 PP)'),
(521, 3, 263000, 0, 'FCR-900'),
(522, 3, 800000, 0, 'NRG-500'),
(535, 3, 200000, 0, 'Slamvan'),
(539, 3, 0, 100, 'Vortex (100 PP)'),
(541, 3, 915000, 0, 'Bullet'),
(543, 2, 60000, 0, 'Sadler'),
(545, 3, 210000, 0, 'Hustler'),
(550, 3, 100000, 0, 'Sunrise'),
(558, 3, 280000, 0, 'Uranus'),
(559, 3, 430000, 0, 'Jester'),
(560, 3, 725000, 0, 'Sultan'),
(561, 3, 230000, 0, 'Stratum'),
(562, 3, 415000, 0, 'Elegy'),
(565, 2, 265000, 0, 'Flash'),
(567, 3, 195000, 0, 'Savanna'),
(579, 3, 313000, 0, 'Huntley'),
(586, 3, 215000, 0, 'Wayfarer'),
(587, 3, 245000, 0, 'Euros'),
(603, 3, 228000, 0, 'Phoenix');
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `email`
--
CREATE TABLE IF NOT EXISTS `email` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`playerid` int(11) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`creator` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `faction_logs`
--
CREATE TABLE IF NOT EXISTS `faction_logs` (
`Id` int(255) NOT NULL AUTO_INCREMENT,
`Text` text CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
`playerID` int(255) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`type` int(11) NOT NULL,
PRIMARY KEY (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Salvarea datelor din tabel `faction_logs`
--
INSERT INTO `faction_logs` (`Id`, `Text`, `playerID`, `time`, `type`) VALUES
(1, 'BogdanScr. is now the leader of faction Los Santos Police Department.', 2, '2015-01-06 13:12:53', 0);
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `flogs`
--
CREATE TABLE IF NOT EXISTS `flogs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`playerID` int(255) NOT NULL,
`name` varchar(255) NOT NULL,
`faction` int(25) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Salvarea datelor din tabel `flogs`
--
INSERT INTO `flogs` (`id`, `text`, `playerID`, `name`, `faction`, `time`) VALUES
(1, 'BogdanScr. is now the leader of faction Los Santos Police Department.', 2, '', 1, '2015-01-06 13:12:53');
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `groups`
--
CREATE TABLE IF NOT EXISTS `groups` (
`groupID` int(12) NOT NULL AUTO_INCREMENT,
`groupRankName1` varchar(32) NOT NULL DEFAULT '(null)',
`groupRankName2` varchar(32) NOT NULL DEFAULT '(null)',
`groupRankName3` varchar(32) NOT NULL DEFAULT '(null)',
`groupRankName4` varchar(32) NOT NULL DEFAULT '(null)',
`groupRankName5` varchar(32) NOT NULL DEFAULT '(null)',
`groupRankName6` varchar(32) NOT NULL DEFAULT '(null)',
`groupRankName7` varchar(32) NOT NULL,
`grup` varchar(32) DEFAULT NULL,
`groupName` varchar(255) NOT NULL DEFAULT 'None',
`groupHQExteriorPosX` varchar(255) NOT NULL DEFAULT '0',
`groupHQExteriorPosY` varchar(255) NOT NULL DEFAULT '0',
`groupHQExteriorPosZ` varchar(255) NOT NULL DEFAULT '0',
`groupHQInteriorPosX` varchar(255) NOT NULL DEFAULT '0',
`groupHQInteriorPosY` varchar(255) NOT NULL DEFAULT '0',
`groupHQInteriorPosZ` varchar(255) NOT NULL DEFAULT '0',
`groupHQInteriorID` int(4) NOT NULL DEFAULT '0',
`groupHQLockStatus` int(2) NOT NULL DEFAULT '1',
`groupMOTD` varchar(128) NOT NULL DEFAULT '(null)',
`groupSafePosX` varchar(255) NOT NULL DEFAULT '0',
`groupSafePosY` varchar(255) NOT NULL DEFAULT '0',
`groupSafePosZ` varchar(255) NOT NULL DEFAULT '0',
`groupType` int(12) NOT NULL DEFAULT '0',
`groupSafeMoney` int(6) NOT NULL DEFAULT '1',
`groupSafeMats` int(6) NOT NULL DEFAULT '1',
`groupSafeDrugs` int(6) NOT NULL DEFAULT '1',
`groupMembers` int(6) NOT NULL DEFAULT '0',
`groupLeader` varchar(23) NOT NULL DEFAULT 'None',
`groupAplication` int(11) NOT NULL DEFAULT '0',
`groupSlots` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`groupID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=112 ;
--
-- Salvarea datelor din tabel `groups`
--
INSERT INTO `groups` (`groupID`, `groupRankName1`, `groupRankName2`, `groupRankName3`, `groupRankName4`, `groupRankName5`, `groupRankName6`, `groupRankName7`, `grup`, `groupName`, `groupHQExteriorPosX`, `groupHQExteriorPosY`, `groupHQExteriorPosZ`, `groupHQInteriorPosX`, `groupHQInteriorPosY`, `groupHQInteriorPosZ`, `groupHQInteriorID`, `groupHQLockStatus`, `groupMOTD`, `groupSafePosX`, `groupSafePosY`, `groupSafePosZ`, `groupType`, `groupSafeMoney`, `groupSafeMats`, `groupSafeDrugs`, `groupMembers`, `groupLeader`, `groupAplication`, `groupSlots`) VALUES
(1, 'LS Officer', 'LS Inspector', 'LS Cadet', 'LS Captain', 'LS General', 'Sub-Chestor LSPD', 'Chestor LSPD', NULL, 'Los Santos Police Department', '242.258', '66.395', '1003.641', '288.765', '167.185', '1007.172', 3, 1, 'Bun venit!', '300.817', '187.792', '1007.172', 1, 0, 0, 0, 0, 'None', 1, 10),
(2, '[1] F.B.I Secretar', '[2] F.B.I Agent Pietonal', '[3] F.B.I Agent Omucideri', '[4] F.B.I Agent de Marina', '[5] F.B.I Agent Secret', '[6] Co-Lider F.B.I', 'Director', NULL, 'Federal Bureau of Investigation', '626.965', '-571.779', '17.921', '246.317', '107.3', '1003.219', 10, 1, '.', '258.344', '108.256', '1003.219', 1, 0, 0, 0, 0, 'None', 1, 10),
(3, 'Soldat NG', 'Plutonier NG', 'Caporal NG', 'Capitan NG', 'Maior NG', 'Locotenent NG', 'General NG', NULL, 'National Guard', '200.998', '1869.536', '13.147', '288.746', '167.215', '1007.172', 3, 1, '', '300.598', '186.917', '1007.172', 1, 0, 0, 0, 0, 'None', 1, 10),
(4, 'Medic Incepãtor.', '(2) Medic Rezident', '(3) Medic Specialist', '(4) Medic Primar', '(5) Chirurg / Responsabil ', '(6) Vice - Director', '(7) Director', NULL, 'Paramedic Departament', '1172.081', '-1323.326', '15.403', '288.765', '167.185', '1007.172', 3, 1, '', '301.114', '187.941', '1007.172', 2, 0, 0, 0, 0, 'None', 1, 10),
(5, 'Secretar', 'Bodyguard', 'LV Inspector', 'Vice Premier', 'Premier', 'Vice Primar', 'Primar', NULL, 'Gouvernment', '1481.13', '-1772.179', '18.796', '390.386', '174.031', '1008.383', 3, 1, '', '354.371', '173.773', '1008.383', 1, 0, 0, 0, 0, 'None', 1, 10),
(6, '(1)Codat cu clasa', '(2)Avansat', '(3)Rus', '(4)Manager', '(5)Legenda', 'Russian Aimer', 'Leader', NULL, 'The Russian Mafia', '1123.017', '-2037.009', '69.894', '2544.451', '-1304.766', '1054.641', 2, 0, '', '2548.221', '-1281.795', '1060.984', 6, 0, 0, 0, 0, 'None', 1, 10),
(7, 'Little gangsta', '[2]Gangster', '[3]Gangsta', '[4]Killer', '[5] Veteran', '[6]Capone', 'Padrino', NULL, 'Grove Street', '2495.464', '-1690.579', '14.766', '2544.738', '-1304.877', '1054.641', 2, 1, '', '2546.98', '-1281.026', '1060.984', 7, 0, 0, 0, 0, 'None', 1, 10),
(9, 'Incepator', 'Aimer ', 'Rambo', 'Foarte Bun', 'Boss', '#Valoare', '#Lord', NULL, 'The Rifa', '1022.395', '-1121.421', '23.87', '2544.676', '-1304.907', '1054.641', 2, 1, '', '2546.348', '-1293.012', '1054.641', 9, 0, 0, 0, 0, 'None', 1, 10),
(10, '[1] Little Gangsta', '[2] Gangsta', '[3] Original Gangsta', '[4] Pro Killer', '[5] Professional Gangsta', '[6] Salieri Prince', 'Lord of Balla`s ', NULL, 'Ballas', '2233.568', '-1332.256', '23.981', '2544.845', '-1305.074', '1054.641', 2, 1, '', '2546.824', '-1280.949', '1060.984', 10, 0, 0, 0, 0, 'None', 1, 10),
(12, '(1)RaMb0', '(2)AsSasSin', '(3)Sheriff', '(4)Specialist', 'Contract Killer', 'Veteran Hitman', 'King of San Andreas.', NULL, 'Hitman Agency', '1080.952', '-345.403', '73.984', '774.15', '-48.952', '1000.586', 6, 1, 'Hitman Agency | Bine ati venit !', '755.641', '-48.394', '1000.78', 12, 0, 0, 0, 0, 'None', 1, 10),
(13, 'Elev', 'Student', 'Instructor', 'Instructor Experimentat', 'Instructor Profesionist', 'Director-Adjunct Instructors', 'Leader', NULL, 'School Instructors', '1154.997', '-1181.036', '32.819', '1700.534', '-1667.797', '20.219', 18, 1, 'School Instructor | Sedinta Duminica ora 20:30', '1709.728', '-1642.873', '20.219', 13, 0, 0, 0, 0, 'None', 1, 10),
(14, 'LS Trainee', 'LS Taxi Rookie', 'LS Experienced Driver', 'LS Dispatcher', 'Shift Spervizor', 'Vice-Director', 'Director', NULL, 'Taxi Cab Company', '1752.803', '-1903.004', '13.563', '1700.534', '-1667.799', '20.219', 18, 1, '.', '1700.948', '-1648.206', '20.219', 14, 0, 0, 0, 0, 'None', 0, 10),
(15, '[1] Rookie reporter', '[2] Trainee reporter', '[3] Experienced reporter', '[4] Journalist', '[5] Reporter national', 'Co-leader', 'Leader', NULL, 'News Reporters', '-329.689', '1537.041', '76.612', '288.765', '167.185', '1007.172', 3, 1, 'Bine ati venit în News Reporters! Prima sedintã va fi sâmbãtã la ora 19:30. Raportul nu este obligatoriu.', '300.781', '187.928', '1007.172', 15, 0, 0, 0, 0, 'None', 1, 10),
(8, 'Chicano', 'Guero', 'Soldado', 'Hermano', 'Vato', 'Derecha Mano', 'El Jefe', NULL, 'Los Aztecas', '1870.756', '-2021.351', '13.547', '2544.794', '-1305.054', '1054.641', 2, 1, '', '2546.805', '-1280.943', '1060.984', 8, 0, 0, 0, 0, 'None', 1, 10),
(11, '#Incepator.', '#Avansat.', '#Soldato.', '#Aimer.', 'Valoros.', '#Don.', '(7) Al capone', NULL, 'Los Vagos', '725.623', '-1440.4', '13.532', '2545.037', '-1304.96', '1054.641', 2, 1, '', '2546.805', '-1280.944', '1060.984', 11, 0, 0, 0, 0, 'None', 1, 10);
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `helperlogs`
--
CREATE TABLE IF NOT EXISTS `helperlogs` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`playerid` int(11) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`text2` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `houses`
--
CREATE TABLE IF NOT EXISTS `houses` (
`houseID` int(12) NOT NULL AUTO_INCREMENT,
`houseExteriorPosX` varchar(255) NOT NULL DEFAULT '0',
`houseExteriorPosY` varchar(255) NOT NULL DEFAULT '0',
`houseExteriorPosZ` varchar(255) NOT NULL DEFAULT '0',
`houseInteriorPosX` varchar(255) NOT NULL DEFAULT '0',
`houseInteriorPosY` varchar(255) NOT NULL DEFAULT '0',
`houseInteriorPosZ` varchar(255) NOT NULL DEFAULT '0',
`houseInteriorID` int(4) NOT NULL DEFAULT '0',
`houseExteriorID` int(4) NOT NULL DEFAULT '0',
`houseOwner` varchar(24) NOT NULL DEFAULT 'Nobody',
`housePrice` int(12) NOT NULL DEFAULT '0',
`houseLocked` int(2) NOT NULL DEFAULT '1',
`houseMoney` int(12) NOT NULL DEFAULT '0',
`houseWeapon1` int(12) NOT NULL DEFAULT '0',
`houseWeapon2` int(12) NOT NULL DEFAULT '0',
`houseWeapon3` int(12) NOT NULL DEFAULT '0',
`houseRent` int(12) NOT NULL DEFAULT '0',
`houseLevel` int(6) NOT NULL DEFAULT '0',
PRIMARY KEY (`houseID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=68 ;
--
-- Salvarea datelor din tabel `houses`
--
INSERT INTO `houses` (`houseID`, `houseExteriorPosX`, `houseExteriorPosY`, `houseExteriorPosZ`, `houseInteriorPosX`, `houseInteriorPosY`, `houseInteriorPosZ`, `houseInteriorID`, `houseExteriorID`, `houseOwner`, `housePrice`, `houseLocked`, `houseMoney`, `houseWeapon1`, `houseWeapon2`, `houseWeapon3`, `houseRent`, `houseLevel`) VALUES
(1, '980.411987', '-677.296875', '121.976257', '140.169998', '1366.069946', '1083.859375', 5, 0, 'Nobody', 700000, 1, 0, 0, 0, 0, 400, 8),
(2, '1468.578979', '-905.851013', '54.835998', '223.360000', '1287.078979', '1082.140991', 1, 0, 'Nobody', 500000, 1, 0, 0, 0, 0, 1, 5),
(3, '1535.035034', '-799.991027', '72.848999', '234.235412', '1063.721435', '1084.212280', 6, 0, 'Nobody', 400000, 1, 0, 0, 0, 0, 10, 5),
(4, '1535.796020', '-885.328002', '57.657001', '327.746002', '1478.082031', '1084.437988', 15, 0, 'Nobody', 400000, 1, 0, 0, 0, 0, 200, 5),
(5, '1540.305053', '-851.388977', '64.335998', '226.300003', '1114.239990', '1080.993041', 5, 0, 'Nobody', 400000, 1, 0, 0, 0, 0, 10, 5),
(6, '1527.832031', '-772.596008', '80.578002', '2270.382080', '-1210.088989', '1047.562988', 10, 0, 'Nobody', 400000, 1, 0, 0, 0, 0, 1, 5),
(7, '1496.980957', '-687.892028', '95.563003', '234.190002', '1063.729980', '1084.212036', 6, 0, 'Nobody', 800000, 1, 0, 0, 0, 0, 1000, 10),
(8, '1442.582031', '-629.072998', '95.719001', '-283.585998', '1471.116943', '1084.375000', 15, 0, 'Nobody', 300000, 1, 0, 0, 0, 0, 1, 5),
(9, '1112.571044', '-742.054992', '100.133003', '140.378005', '1366.234008', '1083.859008', 5, 0, 'Nobody', 400000, 1, 0, 0, 0, 0, 69, 6),
(10, '1093.891967', '-807.091979', '107.419998', '376.959991', '1417.152954', '1081.328002', 15, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 0, 5),
(11, '-814.397277', '1425.866943', '13.945302', '234.048202', '1063.715698', '1084.212280', 6, 0, 'Nobody', 150000, 1, 0, 0, 0, 0, 1, 3),
(12, '-799.325012', '1425.572998', '13.945302', '299.779998', '309.890014', '1003.304687', 4, 0, 'Nobody', 150000, 1, 0, 0, 0, 0, 500, 3),
(13, '-786.173156', '1425.739868', '13.945302', '2283.307617', '-1140.239746', '1050.898437', 11, 0, 'Nobody', 150000, 1, 0, 0, 0, 0, 69, 3),
(14, '-775.913940', '1448.194335', '13.945302', '299.779998', '309.890014', '1003.304687', 4, 0, 'Nobody', 150000, 1, 0, 0, 0, 0, 69, 3),
(15, '-788.334045', '1448.371093', '13.945302', '2233.639892', '-1115.260009', '1050.882812', 5, 0, 'Nobody', 150000, 1, 0, 0, 0, 0, 69, 3),
(16, '-773.383117', '1425.435546', '13.945302', '299.782623', '309.833190', '1003.304687', 4, 0, 'Nobody', 150000, 1, 0, 0, 0, 0, 69, 3),
(17, '-802.993164', '1448.686157', '13.945302', '343.809997', '304.859985', '999.148437', 6, 0, 'Nobody', 150000, 1, 0, 0, 0, 0, 2000, 3),
(18, '-816.665771', '1448.810424', '13.945302', '2259.379882', '-1135.770019', '1050.640258', 10, 0, 'Nobody', 150000, 1, 0, 0, 0, 0, 1, 3),
(19, '692.880737', '-1602.771484', '15.046875', '2196.850097', '-1204.250000', '1049.023437', 6, 0, 'Nobody', 300000, 1, 0, 0, 0, 0, 1, 4),
(20, '300.354492', '-1154.561401', '81.391258', '140.169998', '1366.069946', '1083.859375', 5, 0, 'Nobody', 750000, 1, 0, 0, 0, 0, 69, 10),
(21, '251.479904', '-1220.177612', '76.102371', '225.679992', '1021.450012', '1084.017700', 7, 0, 'Nobody', 700000, 1, 0, 0, 0, 0, 1, 8),
(22, '252.930679', '-1269.998535', '74.359741', '234.190002', '1063.729980', '1084.212280', 6, 0, 'Nobody', 700000, 1, 0, 0, 0, 0, 0, 7),
(27, '657.224731', '-1652.700927', '15.406250', '2218.399902', '-1076.180053', '1050.484375', 1, 0, 'Nobody', 300000, 1, 0, 0, 0, 0, 1, 3),
(23, '937.875488', '-848.711242', '93.577178', '2283.040039', '-1140.280029', '1050.898437', 11, 0, 'Nobody', 400000, 1, 0, 0, 0, 0, 5000, 4),
(24, '835.783508', '-894.737060', '68.768898', '2495.979980', '-1692.079956', '1014.742187', 3, 0, 'Nobody', 600000, 1, 0, 0, 0, 0, 1000, 6),
(25, '298.598480', '-1338.681152', '53.441444', '24.040000', '1340.170043', '1084.375000', 10, 0, 'Nobody', 600000, 1, 0, 0, 0, 0, 1, 8),
(26, '254.381179', '-1367.128906', '53.109375', '-260.489990', '1456.750000', '1084.367187', 4, 0, 'Nobody', 600000, 1, 0, 0, 0, 0, 25000, 8),
(28, '653.411010', '-1714.253051', '14.764795', '2259.379882', '-1135.770019', '1050.640258', 10, 0, 'Nobody', 300000, 1, 0, 0, 0, 0, 1, 3),
(29, '652.473510', '-1693.810302', '14.555191', '2259.379882', '-1135.770019', '1050.640258', 10, 0, 'Nobody', 300000, 1, 0, 0, 0, 0, 1, 3),
(30, '824.616210', '-1424.202636', '14.498847', '140.169998', '1366.069946', '1083.859375', 5, 0, 'Nobody', 380000, 1, 0, 0, 0, 0, 69, 4),
(32, '219.218154', '-1249.816772', '78.336540', '225.679992', '1021.450012', '1084.017700', 7, 0, 'Nobody', 550000, 1, 0, 0, 0, 0, 69, 6),
(31, '795.164611', '-506.690155', '18.012922', '234.190002', '1063.729980', '1084.212280', 6, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 1, 4),
(42, '768.200988', '-503.480895', '18.012926', '266.667144', '305.108642', '999.148437', 2, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 0, 4),
(33, '2018.242309', '-1703.314331', '14.234375', '223.199996', '1287.079956', '1082.140625', 1, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 100, 4),
(34, '2016.198730', '-1717.002563', '14.125000', '2283.040039', '-1140.280029', '1050.898437', 11, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 0, 4),
(35, '2015.168579', '-1732.653320', '14.234375', '2233.639892', '-1115.260009', '1050.882812', 5, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 1000, 4),
(36, '315.806823', '-1769.429931', '4.621726', '2218.399902', '-1076.180053', '1050.484375', 1, 0, 'Nobody', 550000, 1, 0, 0, 0, 0, 1, 6),
(39, '2013.571289', '-1656.424316', '14.136316', '223.199996', '1287.079956', '1082.140625', 1, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 0, 4),
(37, '1980.380371', '-1718.839599', '17.030199', '24.040000', '1340.170043', '1084.375000', 10, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 69, 4),
(38, '1980.992187', '-1682.815429', '17.053705', '83.029998', '1322.280029', '1083.866210', 9, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 10, 4),
(49, '1094.854614', '-647.912902', '113.648437', '24.040000', '1340.170043', '1084.375000', 10, 0, 'Nobody', 550000, 1, 0, 0, 0, 0, 1000, 0),
(40, '2016.542358', '-1641.839965', '14.112874', '2218.399902', '-1076.180053', '1050.484375', 1, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 0, 4),
(41, '743.251525', '-509.322814', '18.012922', '2218.170166', '-1075.956054', '1050.484375', 1, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 0, 4),
(43, '818.209655', '-509.318054', '18.012922', '2283.040039', '-1140.280029', '1050.898437', 11, 0, 'Nobody', 350000, 1, 0, 0, 0, 0, 0, 4),
(45, '1183.476196', '-1099.072631', '28.257812', '235.339996', '1186.680053', '1080.257812', 3, 0, 'Nobody', 250000, 1, 0, 0, 0, 0, 0, 3),
(44, '1142.122192', '-1092.734985', '28.187500', '234.190002', '1063.729980', '1084.212280', 6, 0, 'Nobody', 250000, 1, 0, 0, 0, 0, 1000, 3),
(46, '1183.469482', '-1076.294555', '31.678918', '24.040000', '1340.170043', '1084.375000', 10, 0, 'Nobody', 250000, 1, 0, 0, 0, 0, 1, 3),
(47, '1141.971801', '-1069.912353', '31.765625', '2807.479980', '-1174.760009', '1025.570312', 8, 0, 'Nobody', 250000, 1, 0, 0, 0, 0, 0, 3),
(58, '827.778076', '-858.005737', '70.330810', '140.169998', '1366.069946', '1083.859375', 5, 0, 'Nobody', 230000, 1, 0, 0, 0, 0, 69, 0),
(48, '167.897857', '-1308.392333', '70.351257', '234.190002', '1063.729980', '1084.212280', 6, 0, 'Nobody', 650000, 1, 0, 0, 0, 0, 20000, 0),
(50, '-881.416931', '1562.424072', '25.911380', '223.211746', '1287.390625', '1082.140625', 1, 0, 'Nobody', 100000, 1, 0, 0, 0, 0, 5, 0),
(51, '-883.982238', '1552.736328', '26.062364', '2309.074462', '-1212.524169', '1049.023437', 6, 0, 'Nobody', 100000, 1, 0, 0, 0, 0, 2500, 0),
(52, '-879.675598', '1538.678955', '26.031114', '2218.151855', '-1076.009277', '1050.484375', 1, 0, 'Nobody', 100000, 1, 0, 0, 0, 0, 2500, 0),
(53, '-881.782775', '1531.739379', '26.062364', '2259.651123', '-1136.380004', '1050.632812', 10, 0, 'Nobody', 100000, 1, 0, 0, 0, 0, 100, 0),
(54, '-886.458251', '1514.096801', '26.031114', '266.697692', '304.337554', '999.148437', 2, 0, 'Nobody', 100000, 1, 0, 0, 0, 0, 1, 0),
(55, '-905.445739', '1528.577758', '26.077989', '243.846282', '305.162475', '999.148437', 1, 0, 'Nobody', 100000, 1, 0, 0, 0, 0, 5000, 0),
(56, '-906.400390', '1514.627197', '26.316806', '2233.412109', '-1115.044677', '1050.882812', 5, 0, 'Nobody', 100000, 1, 0, 0, 0, 0, 69, 0),
(57, '-905.540466', '1542.803588', '26.062364', '-42.834991', '1405.777709', '1084.429687', 8, 0, 'Nobody', 100000, 1, 0, 0, 0, 0, 100, 0),
(59, '1332.251953', '-633.455505', '109.134902', '2270.419189', '-1210.253417', '1047.562500', 10, 0, 'Nobody', 530000, 1, 0, 0, 0, 0, 69, 0),
(60, '1298.423339', '-798.059753', '84.140625', '2324.429443', '-1149.547241', '1050.710083', 12, 0, 'Nobody', 800000, 1, 0, 0, 0, 0, 0, 0),
(64, '1421.052490', '-886.229980', '50.685749', '1421.531372', '-886.221008', '50.685768', 0, 0, 'Nobody', 10000, 1, 0, 0, 0, 0, 1, 0);
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `jobs`
--
CREATE TABLE IF NOT EXISTS `jobs` (
`jobID` int(12) NOT NULL AUTO_INCREMENT,
`jobType` int(12) NOT NULL DEFAULT '0',
`jobPositionX` varchar(255) NOT NULL,
`jobPositionY` varchar(255) NOT NULL,
`jobPositionZ` varchar(255) NOT NULL,
`jobName` varchar(255) NOT NULL,
PRIMARY KEY (`jobID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;
--
-- Salvarea datelor din tabel `jobs`
--
INSERT INTO `jobs` (`jobID`, `jobType`, `jobPositionX`, `jobPositionY`, `jobPositionZ`, `jobName`) VALUES
(1, 1, '1366.959960', '-1291.690551', '13.546875', 'Arms Dealer'),
(2, 2, '606.585144', '-1438.753540', '14.052495', 'Detective'),
(3, 3, '921.1014', '-1298.2474', '14.0938', 'Mechanic'),
(4, 4, '376.1711', '-2071.6523', '7.8359', 'Fisherman'),
(5, 5, '2140.5608', '-1707.3037', '15.0859', 'Drugs Dealer'),
(6, 6, '2105.4358', '-1806.3704', '13.5547', 'Pizza Boy'),
(7, 7, '-382.5722', '-1438.9875', '25.9466', 'Farmer'),
(8, 8, '2813.8323', '891.1882', '10.7578', 'Car Jacker'),
(9, 9, '-77.4390', '-1136.3721', '1.0781', 'Trucker');
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `lastpunish`
--
CREATE TABLE IF NOT EXISTS `lastpunish` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`text` text NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`playerID` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `namechanges`
--
CREATE TABLE IF NOT EXISTS `namechanges` (
`namechangeid` int(6) NOT NULL AUTO_INCREMENT,
`userid` int(6) NOT NULL,
`oldname` varchar(24) NOT NULL,
`newname` varchar(24) NOT NULL,
`adminid` int(6) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`namechangeid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `phonelogs`
--
CREATE TABLE IF NOT EXISTS `phonelogs` (
`logID` int(32) NOT NULL AUTO_INCREMENT,
`phoneNumber` int(32) NOT NULL,
`phoneName` varchar(24) NOT NULL,
`phoneAction` varchar(768) NOT NULL,
PRIMARY KEY (`logID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `playeraccounts`
--
CREATE TABLE IF NOT EXISTS `playeraccounts` (
`playerID` int(12) NOT NULL AUTO_INCREMENT,
`playerPhone` int(15) DEFAULT '0',
`playerLevel` int(6) NOT NULL DEFAULT '1',
`playerName` varchar(24) NOT NULL,
`playerPassword` varchar(129) NOT NULL,
`playerEmail` varchar(255) NOT NULL,
`playerMoney` int(16) NOT NULL DEFAULT '100',
`playerPublicProfile` int(2) NOT NULL,
`playerAdminLevel` int(6) NOT NULL DEFAULT '0',
`playerRegistrationDate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`playerSkin` int(6) NOT NULL DEFAULT '60',
`playerPosX` varchar(255) NOT NULL DEFAULT '1794.213256',
`playerPosY` varchar(255) NOT NULL DEFAULT '-1862.133666',
`playerPosZ` varchar(255) NOT NULL DEFAULT '13.576666',
`playerBankMoney` int(16) NOT NULL DEFAULT '250',
`playerHealth` varchar(255) NOT NULL DEFAULT '100',
`playerArmour` int(255) NOT NULL DEFAULT '0',
`playerSeconds` int(5) NOT NULL DEFAULT '0',
`playerInterior` int(6) NOT NULL DEFAULT '0',
`playerVirtualWorld` int(6) NOT NULL DEFAULT '0',
`playerJob` int(3) NOT NULL DEFAULT '0',
`playerWeapon0` int(6) NOT NULL DEFAULT '0',
`playerWeapon1` int(6) NOT NULL DEFAULT '0',
`playerWeapon2` int(6) NOT NULL DEFAULT '0',
`playerWeapon3` int(6) NOT NULL DEFAULT '0',
`playerWeapon4` int(6) NOT NULL DEFAULT '0',
`playerWeapon5` int(6) NOT NULL DEFAULT '0',
`playerWeapon6` int(6) NOT NULL DEFAULT '0',
`playerWeapon7` int(6) NOT NULL DEFAULT '0',
`playerWeapon8` int(6) NOT NULL DEFAULT '0',
`playerWeapon9` int(6) NOT NULL DEFAULT '0',
`playerWeapon10` int(6) NOT NULL DEFAULT '0',
`playerWeapon11` int(6) NOT NULL DEFAULT '0',
`playerWeapon12` int(6) NOT NULL DEFAULT '0',
`playerJobSkill2` int(6) NOT NULL DEFAULT '0',
`playerMaterials` int(12) NOT NULL DEFAULT '0',
`playerGroup` int(6) NOT NULL DEFAULT '0',
`playerGroupRank` int(6) NOT NULL DEFAULT '0',
`playerHours` int(12) NOT NULL DEFAULT '0',
`playerWarning1` varchar(32) NOT NULL DEFAULT '(null)',
`playerWarning2` varchar(32) NOT NULL DEFAULT '(null)',
`playerWarning3` varchar(32) NOT NULL DEFAULT '(null)',
`playerHospitalized` int(3) NOT NULL DEFAULT '0',
`playerAdminName` varchar(24) NOT NULL,
`playerFirstLogin` int(2) NOT NULL DEFAULT '1',
`playerGender` int(2) NOT NULL DEFAULT '0',
`playerPrisonID` int(2) NOT NULL DEFAULT '0',
`playerPrisonTime` int(6) NOT NULL DEFAULT '0',
`playerPhoneNumber` int(12) NOT NULL DEFAULT '-1',
`playerPhoneBook` int(2) NOT NULL DEFAULT '0',
`playerIP` varchar(32) NOT NULL DEFAULT '0.0.0.0',
`playerHelperLevel` int(6) NOT NULL DEFAULT '0',
`playerDropCarTimeout` int(12) NOT NULL DEFAULT '0',
`playerRope` int(6) NOT NULL DEFAULT '0',
`playerAdminDuty` int(6) NOT NULL,
`playerCrimes` int(12) NOT NULL DEFAULT '0',
`playerArrests` int(12) NOT NULL DEFAULT '0',
`playerWarrants` int(12) NOT NULL DEFAULT '0',
`playerCarModel` int(6) NOT NULL DEFAULT '0',
`playerCarModel2` int(6) NOT NULL DEFAULT '0',
`playerCarModel3` int(6) NOT NULL DEFAULT '0',
`playerCarModel4` int(6) NOT NULL DEFAULT '0',
`playerCarMod0` int(6) NOT NULL DEFAULT '0',
`playerCarMod1` int(6) NOT NULL DEFAULT '0',
`playerCarMod2` int(6) NOT NULL DEFAULT '0',
`playerCarMod3` int(6) NOT NULL DEFAULT '0',
`playerCarMod4` int(6) NOT NULL DEFAULT '0',
`playerCarMod5` int(6) NOT NULL DEFAULT '0',
`playerCarMod6` int(6) NOT NULL DEFAULT '0',
`playerCarMod7` int(6) NOT NULL DEFAULT '0',
`playerCarMod8` int(6) NOT NULL DEFAULT '0',
`playerCarMod9` int(6) NOT NULL DEFAULT '0',
`playerCarMod10` int(6) NOT NULL DEFAULT '0',
`playerCarMod11` int(6) NOT NULL DEFAULT '0',
`playerCarMod12` int(6) NOT NULL DEFAULT '0',
`playerCarMod20` int(6) NOT NULL DEFAULT '0',
`playerCarMod21` int(6) NOT NULL DEFAULT '0',
`playerCarMod22` int(6) NOT NULL DEFAULT '0',
`playerCarMod23` int(6) NOT NULL DEFAULT '0',
`playerCarMod24` int(6) NOT NULL DEFAULT '0',
`playerCarMod25` int(6) NOT NULL DEFAULT '0',
`playerCarMod26` int(6) NOT NULL DEFAULT '0',
`playerCarMod27` int(6) NOT NULL DEFAULT '0',
`playerCarMod28` int(6) NOT NULL DEFAULT '0',
`playerCarMod29` int(6) NOT NULL DEFAULT '0',
`playerCarMod30` int(6) NOT NULL DEFAULT '0',
`playerCarMod31` int(6) NOT NULL DEFAULT '0',
`playerCarMod32` int(6) NOT NULL DEFAULT '0',
`playerCarPosX` varchar(255) NOT NULL DEFAULT '0.0',
`playerCarPosY` varchar(255) NOT NULL DEFAULT '0.0',
`playerCarPosZ` varchar(255) NOT NULL DEFAULT '0.0',
`playerCarPosZAngle` varchar(255) NOT NULL DEFAULT '0.0',
`playerCarPosX2` varchar(255) NOT NULL DEFAULT '0.0',
`playerCarPosY2` varchar(255) NOT NULL DEFAULT '0.0',
`playerCarPosZ2` varchar(255) NOT NULL DEFAULT '0.0',
`playerCarPosZAngle2` varchar(255) NOT NULL DEFAULT '0.0',
`playerCarColour1` int(6) NOT NULL DEFAULT '-1',
`playerCarColour2` int(6) NOT NULL DEFAULT '-1',
`playerCarColour21` int(6) NOT NULL DEFAULT '-1',
`playerCarColour22` int(6) NOT NULL DEFAULT '-1',
`playerAge` int(6) NOT NULL DEFAULT '0',
`playerCarPaintJob` int(6) NOT NULL DEFAULT '-1',
`playerCarLock` int(6) NOT NULL DEFAULT '0',
`playerCarPaintJob2` int(6) NOT NULL DEFAULT '-1',
`playerCarLock2` int(6) NOT NULL DEFAULT '0',
`playerCarLicensePlate2` varchar(32) NOT NULL DEFAULT '3S53D',
`playerFightStyle` int(6) NOT NULL DEFAULT '0',
`playerVIP` int(6) NOT NULL DEFAULT '0',
`playerCarWeapon1` int(12) NOT NULL DEFAULT '0',
`playerCarWeapon2` int(12) NOT NULL DEFAULT '0',
`playerCarWeapon3` int(12) NOT NULL DEFAULT '0',
`playerCarWeapon4` int(12) NOT NULL DEFAULT '0',
`playerCarWeapon5` int(12) NOT NULL DEFAULT '0',
`playerCarTrunk1` int(12) NOT NULL DEFAULT '0',
`playerCarTrunk2` int(12) NOT NULL DEFAULT '0',
`playerCarKM2` int(12) NOT NULL DEFAULT '0',
`playerPhoneCredit` int(12) NOT NULL DEFAULT '0',
`playerWalkieTalkie` int(12) NOT NULL DEFAULT '-1',
`playerAdminTitle` varchar(255) NOT NULL DEFAULT '(null)',
`playerCarLicensePlate` varchar(32) NOT NULL DEFAULT '3VF4 TW0',
`playerAdminPIN` int(4) NOT NULL DEFAULT '0',
`playerHouseRented` int(6) NOT NULL DEFAULT '0',
`playerCarLock3` int(6) NOT NULL DEFAULT '0',
`playerCarLock4` int(6) NOT NULL DEFAULT '0',
`playerCarKM3` int(6) NOT NULL DEFAULT '0',
`playerCarKM4` int(6) NOT NULL DEFAULT '0',
`playerCarColor31` int(6) NOT NULL DEFAULT '-1',
`playerCarColor32` int(6) NOT NULL DEFAULT '-1',
`playerCarColor41` int(6) NOT NULL DEFAULT '-1',
`playerCarColor42` int(6) NOT NULL DEFAULT '-1',
`playerCarPosX3` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
`playerCarPosY3` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
`playerCarPosZ3` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
`playerCarPosZAngle3` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
`playerCarPosX4` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
`playerCarPosY4` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
`playerCarPosZ4` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
`playerCarPosZAngle4` varchar(255) NOT NULL DEFAULT '0.0,0.0,0.0',
`playerCarPaintJob3` int(6) NOT NULL DEFAULT '-1',
`playerCarPaintJob4` int(6) NOT NULL DEFAULT '-1',
`playerCarMod60` int(6) NOT NULL DEFAULT '0',
`playerCarMod61` int(6) NOT NULL DEFAULT '0',
`playerCarMod62` int(6) NOT NULL DEFAULT '0',
`playerCarMod63` int(6) NOT NULL DEFAULT '0',
`playerCarMod64` int(6) NOT NULL DEFAULT '0',
`playerCarMod65` int(6) NOT NULL DEFAULT '0',
`playerCarMod66` int(6) NOT NULL DEFAULT '0',
`playerCarMod67` int(6) NOT NULL DEFAULT '0',
`playerCarMod68` int(6) NOT NULL DEFAULT '0',
`playerCarMod69` int(6) NOT NULL DEFAULT '0',
`playerCarMod70` int(6) NOT NULL DEFAULT '0',
`playerCarMod71` int(6) NOT NULL DEFAULT '0',
`playerCarMod72` int(6) NOT NULL DEFAULT '0',
`playerCarMod90` int(6) NOT NULL DEFAULT '0',
`playerCarMod80` int(6) NOT NULL DEFAULT '0',
`playerCarMod81` int(6) NOT NULL DEFAULT '0',
`playerCarMod82` int(6) NOT NULL DEFAULT '0',
`playerCarMod83` int(6) NOT NULL DEFAULT '0',
`playerCarMod84` int(6) NOT NULL DEFAULT '0',
`playerCarMod85` int(6) NOT NULL DEFAULT '0',
`playerCarMod86` int(6) NOT NULL DEFAULT '0',
`playerCarMod87` int(6) NOT NULL DEFAULT '0',
`playerCarMod88` int(6) NOT NULL DEFAULT '0',
`playerCarMod89` int(6) NOT NULL DEFAULT '0',
`playerCarMod91` int(6) DEFAULT '0',
`playerCarMod92` int(6) NOT NULL DEFAULT '0',
`playerAge1` int(6) NOT NULL DEFAULT '0',
`playerFlyLic` int(6) NOT NULL DEFAULT '0',
`playerGunLic` int(6) NOT NULL DEFAULT '0',
`playerClan` int(6) NOT NULL DEFAULT '0',
`playerClanRank` int(6) NOT NULL DEFAULT '0',
`playerLastLogin` varchar(20) NOT NULL,
`playerColor` int(11) NOT NULL DEFAULT '0',
`playerAplicationID` int(11) NOT NULL DEFAULT '0',
`playerManager` int(69) NOT NULL DEFAULT '0',
`playerClanTagType` int(69) NOT NULL DEFAULT '0',
`playerHelpedPlayers` int(100) NOT NULL DEFAULT '0',
`playerHelperTokens` int(225) NOT NULL DEFAULT '0',
`playerGlasses` int(50) NOT NULL DEFAULT '0',
`rpgon` int(10) NOT NULL DEFAULT '0',
`playerBoatLic` int(150) NOT NULL DEFAULT '0',
`playerHud` int(69) NOT NULL DEFAULT '0',
`playerHouse` int(100) NOT NULL DEFAULT '0',
`playerBusiness` int(100) NOT NULL,
`playerDays` int(255) NOT NULL DEFAULT '0',
`playerStatus` int(69) NOT NULL DEFAULT '0',
`Aproove` int(69) NOT NULL DEFAULT '0',
`Request` int(69) NOT NULL DEFAULT '0',
`newemail` int(69) NOT NULL DEFAULT '0',
`deconnect` int(11) NOT NULL DEFAULT '0',
`playerGiftHours` int(11) NOT NULL DEFAULT '0',
`playerClanDays` int(11) NOT NULL DEFAULT '0',
`playerCar1Days` int(11) NOT NULL DEFAULT '0',
`playerCar2Days` int(11) NOT NULL DEFAULT '0',
`playerCar3Days` int(11) NOT NULL DEFAULT '0',
`playerCar4Days` int(11) NOT NULL DEFAULT '0',
`text` varchar(255) NOT NULL,
`text2` int(11) NOT NULL DEFAULT '0',
`playerBanned` int(11) NOT NULL DEFAULT '0',
`playerInsurance` int(12) NOT NULL,
`playerInsurance2` int(12) NOT NULL,
`playerInsurance3` int(12) NOT NULL,
`playerInsurance4` int(12) NOT NULL,
`playerInsurancePoints` int(12) NOT NULL,
`playerInsurancePoints2` int(12) NOT NULL,
`playerInsurancePoints3` int(12) NOT NULL,
`playerInsurancePoints4` int(12) NOT NULL,
`playerFishSkill` int(6) NOT NULL DEFAULT '1',
`playerTimesFished` int(6) NOT NULL DEFAULT '0',
`playerRobSkill` int(6) NOT NULL DEFAULT '1',
`playerTimesRobbed` int(6) NOT NULL DEFAULT '0',
`playerFireWork` int(12) NOT NULL DEFAULT '0',
PRIMARY KEY (`playerID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=3 ;
--
-- Salvarea datelor din tabel `playeraccounts`
--
INSERT INTO `playeraccounts` (`playerID`, `playerPhone`, `playerLevel`, `playerName`, `playerPassword`, `playerEmail`, `playerMoney`, `playerPublicProfile`, `playerAdminLevel`, `playerRegistrationDate`, `playerSkin`, `playerPosX`, `playerPosY`, `playerPosZ`, `playerBankMoney`, `playerHealth`, `playerArmour`, `playerSeconds`, `playerInterior`, `playerVirtualWorld`, `playerJob`, `playerWeapon0`, `playerWeapon1`, `playerWeapon2`, `playerWeapon3`, `playerWeapon4`, `playerWeapon5`, `playerWeapon6`, `playerWeapon7`, `playerWeapon8`, `playerWeapon9`, `playerWeapon10`, `playerWeapon11`, `playerWeapon12`, `playerJobSkill2`, `playerMaterials`, `playerGroup`, `playerGroupRank`, `playerHours`, `playerWarning1`, `playerWarning2`, `playerWarning3`, `playerHospitalized`, `playerAdminName`, `playerFirstLogin`, `playerGender`, `playerPrisonID`, `playerPrisonTime`, `playerPhoneNumber`, `playerPhoneBook`, `playerIP`, `playerHelperLevel`, `playerDropCarTimeout`, `playerRope`, `playerAdminDuty`, `playerCrimes`, `playerArrests`, `playerWarrants`, `playerCarModel`, `playerCarModel2`, `playerCarModel3`, `playerCarModel4`, `playerCarMod0`, `playerCarMod1`, `playerCarMod2`, `playerCarMod3`, `playerCarMod4`, `playerCarMod5`, `playerCarMod6`, `playerCarMod7`, `playerCarMod8`, `playerCarMod9`, `playerCarMod10`, `playerCarMod11`, `playerCarMod12`, `playerCarMod20`, `playerCarMod21`, `playerCarMod22`, `playerCarMod23`, `playerCarMod24`, `playerCarMod25`, `playerCarMod26`, `playerCarMod27`, `playerCarMod28`, `playerCarMod29`, `playerCarMod30`, `playerCarMod31`, `playerCarMod32`, `playerCarPosX`, `playerCarPosY`, `playerCarPosZ`, `playerCarPosZAngle`, `playerCarPosX2`, `playerCarPosY2`, `playerCarPosZ2`, `playerCarPosZAngle2`, `playerCarColour1`, `playerCarColour2`, `playerCarColour21`, `playerCarColour22`, `playerAge`, `playerCarPaintJob`, `playerCarLock`, `playerCarPaintJob2`, `playerCarLock2`, `playerCarLicensePlate2`, `playerFightStyle`, `playerVIP`, `playerCarWeapon1`, `playerCarWeapon2`, `playerCarWeapon3`, `playerCarWeapon4`, `playerCarWeapon5`, `playerCarTrunk1`, `playerCarTrunk2`, `playerCarKM2`, `playerPhoneCredit`, `playerWalkieTalkie`, `playerAdminTitle`, `playerCarLicensePlate`, `playerAdminPIN`, `playerHouseRented`, `playerCarLock3`, `playerCarLock4`, `playerCarKM3`, `playerCarKM4`, `playerCarColor31`, `playerCarColor32`, `playerCarColor41`, `playerCarColor42`, `playerCarPosX3`, `playerCarPosY3`, `playerCarPosZ3`, `playerCarPosZAngle3`, `playerCarPosX4`, `playerCarPosY4`, `playerCarPosZ4`, `playerCarPosZAngle4`, `playerCarPaintJob3`, `playerCarPaintJob4`, `playerCarMod60`, `playerCarMod61`, `playerCarMod62`, `playerCarMod63`, `playerCarMod64`, `playerCarMod65`, `playerCarMod66`, `playerCarMod67`, `playerCarMod68`, `playerCarMod69`, `playerCarMod70`, `playerCarMod71`, `playerCarMod72`, `playerCarMod90`, `playerCarMod80`, `playerCarMod81`, `playerCarMod82`, `playerCarMod83`, `playerCarMod84`, `playerCarMod85`, `playerCarMod86`, `playerCarMod87`, `playerCarMod88`, `playerCarMod89`, `playerCarMod91`, `playerCarMod92`, `playerAge1`, `playerFlyLic`, `playerGunLic`, `playerClan`, `playerClanRank`, `playerLastLogin`, `playerColor`, `playerAplicationID`, `playerManager`, `playerClanTagType`, `playerHelpedPlayers`, `playerHelperTokens`, `playerGlasses`, `rpgon`, `playerBoatLic`, `playerHud`, `playerHouse`, `playerBusiness`, `playerDays`, `playerStatus`, `Aproove`, `Request`, `newemail`, `deconnect`, `playerGiftHours`, `playerClanDays`, `playerCar1Days`, `playerCar2Days`, `playerCar3Days`, `playerCar4Days`, `text`, `text2`, `playerBanned`, `playerInsurance`, `playerInsurance2`, `playerInsurance3`, `playerInsurance4`, `playerInsurancePoints`, `playerInsurancePoints2`, `playerInsurancePoints3`, `playerInsurancePoints4`, `playerFishSkill`, `playerTimesFished`, `playerRobSkill`, `playerTimesRobbed`, `playerFireWork`) VALUES
(1, 0, 6, 'FloriynScr', '123', '[email protected]', 1338895, 0, 7, '2014-12-20 19:08:10', 60, '1794.213256', '-1862.133666', '13.576666', 994, '100.000000', 0, 0, 0, 0, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, '', '', '', 0, '', 0, 0, 0, 0, -1, 0, '0.0.0.0', 0, 0, 240, 10, 0, 0, 0, 411, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '1645.916625', '-2253.707031', '13.062336', '205.680664', '0.0', '0.0', '0.0', '0.0', 87, 74, -1, -1, 23, -1, 0, -1, 0, 'LGY RPG', 0, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, -1, '(null)', '3VF4 TW0', 0, 0, 0, 0, 0, 0, -1, -1, -1, -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,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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 16, 149, 149, 0, 0, '06.01.2015 15:25', 0, 0, 0, 0, 0, 0, 0, 0, 149, 0, 0, 0, 0, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, '', 0, 0, 100, 0, 0, 0, 12, 0, 0, 0, 1, 0, 1, 0, 2),
(2, 2, 2, 'BogdanScr.', 'asdasd', '[email protected]', 50, 0, 7, '2015-01-06 12:45:49', 281, '1794.213256', '-1862.133666', '13.576666', 330, '100.000000', 0, 1616, 0, 0, 9, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 7, 0, '', '', '', 0, '', 0, 0, 0, 0, 8519, 0, '0.0.0.0', 0, 0, 100, 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, 0, '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', '0.0', -1, -1, -1, -1, 1, -1, 0, -1, 0, '3S53D', 0, 0, 0, 0, 0, 0, 23, 0, 0, 0, 0, -1, '(null)', '3VF4 TW0', 0, 0, 0, 0, 0, 0, -1, -1, -1, -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,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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 21, 0, 0, 0, 0, '06.01.2015 15:51', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 1, 0, 8);
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `ticketcomments`
--
CREATE TABLE IF NOT EXISTS `ticketcomments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`ticketid` int(11) NOT NULL,
`text` text NOT NULL,
`name` varchar(50) NOT NULL,
`playerid` int(11) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `tickets`
--
CREATE TABLE IF NOT EXISTS `tickets` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(100) NOT NULL,
`text` text NOT NULL,
`status` int(69) NOT NULL DEFAULT '0',
`playerid` int(11) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `turfs`
--
CREATE TABLE IF NOT EXISTS `turfs` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`Owned` int(2) NOT NULL,
`Time` int(3) NOT NULL,
`MinX` varchar(16) NOT NULL,
`MinY` varchar(16) NOT NULL,
`MaxX` varchar(16) NOT NULL,
`MaxY` varchar(16) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=43 ;
--
-- Salvarea datelor din tabel `turfs`
--
INSERT INTO `turfs` (`ID`, `Owned`, `Time`, `MinX`, `MinY`, `MaxX`, `MaxY`) VALUES
(1, 11, 0, '626.916', '-1572.63', '789.268', '-1412.95'),
(2, 11, 0, '627.73', '-1410.94', '790.206', '-1238.05'),
(3, 11, 0, '790.815', '-1573.29', '916.731', '-1332.36'),
(4, 11, 0, '790.396', '-1332.35', '1056.23', '-1238.83'),
(5, 11, 0, '627.967', '-1236.28', '791.099', '-1061.05'),
(6, 11, 0, '792.017', '-1237.8', '1057.73', '-1061.39'),
(7, 11, 0, '917.403', '-1574.39', '1057.43', '-1333.96'),
(8, 11, 0, '628.74', '-1059.46', '1058.49', '-955.947'),
(9, 11, 0, '1057.22', '-1574.22', '1211.22', '-1224.22'),
(10, 7, 0, '1056.5', '-1225.06', '1211.98', '-956.114'),
(11, 11, 0, '628.331', '-1791.8', '918.803', '-1573.66'),
(12, 11, 0, '918.312', '-1791.53', '1210.97', '-1571.98'),
(13, 11, 0, '1210.34', '-1791.52', '1364.4', '-1414.2'),
(14, 11, 0, '1210.47', '-1413.87', '1364.53', '-1147.54'),
(15, 11, 0, '1210.6', '-1147.21', '1531.8', '-956.594'),
(16, 10, 0, '1363.77', '-1320.93', '1717.53', '-1147.79'),
(17, 11, 0, '1364.54', '-1595.89', '1504.64', '-1319.9'),
(18, 11, 0, '1364.36', '-1791.41', '1717.75', '-1596.89'),
(19, 10, 0, '1504.55', '-1597.3', '1644.29', '-1321.18'),
(20, 10, 0, '1531.66', '-1147.14', '1882.12', '-956.649'),
(21, 8, 0, '1644.18', '-1597.46', '1882', '-1444.44'),
(22, 7, 0, '1644.09', '-1444.13', '1882.29', '-1319.52'),
(23, 7, 0, '1717.41', '-1320.25', '1882.33', '-1147.91'),
(24, 8, 0, '1717.51', '-1791.08', '1882.25', '-1597.26'),
(25, 8, 0, '1882.27', '-1278.48', '2022.42', '-957.47'),
(26, 8, 0, '1882.55', '-1605.11', '2022.16', '-1278.08'),
(27, 8, 0, '1881.71', '-1791.87', '2327.57', '-1605.32'),
(28, 8, 0, '2022.53', '-1606.06', '2327.73', '-1420.24'),
(29, 8, 0, '2021.63', '-1419.87', '2190.28', '-1165.03'),
(30, 8, 0, '2189.11', '-1420.38', '2329.27', '-1163.46'),
(31, 10, 0, '2023.19', '-1164.47', '2330.02', '-957.524'),
(32, 8, 0, '2327.66', '-1791.07', '2634.45', '-1606.67'),
(33, 8, 0, '2328.03', '-1606.34', '2496.03', '-1340'),
(34, 8, 0, '2496', '-1607.41', '2634.1', '-1340.79'),
(35, 10, 0, '2330.15', '-1340.94', '2634.76', '-1155.8'),
(36, 10, 0, '2327.66', '-1155.83', '2632.72', '-956.658'),
(37, 8, 0, '1741.33', '-2105.2', '1894.59', '-1790.72'),
(38, 8, 0, '1894.3', '-2105.29', '2074.71', '-1792.05'),
(39, 8, 0, '2073.27', '-1957.38', '2325.4', '-1792.17'),
(40, 8, 0, '2074.28', '-2105.92', '2325.38', '-1957.51'),
(41, 11, 0, '1350.1', '-1959.09', '1742.57', '-1790.92'),
(42, 8, 0, '1349.44', '-2105.47', '1742.45', '-1957.4');
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `unbancomments`
--
CREATE TABLE IF NOT EXISTS `unbancomments` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`unbanid` int(69) NOT NULL,
`text` text NOT NULL,
`name` varchar(50) NOT NULL,
`playerid` int(69) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `unbans`
--
CREATE TABLE IF NOT EXISTS `unbans` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`status` int(69) NOT NULL DEFAULT '0',
`text` text NOT NULL,
`playerid` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
-- --------------------------------------------------------
--
-- Structura de tabel pentru tabelul `vehicles`
--
CREATE TABLE IF NOT EXISTS `vehicles` (
`vehicleID` int(11) NOT NULL AUTO_INCREMENT,
`vehicleModelID` int(11) NOT NULL DEFAULT '0',
`vehiclePosX` varchar(255) NOT NULL DEFAULT '0',
`vehiclePosY` varchar(255) NOT NULL DEFAULT '0',
`vehiclePosZ` varchar(255) NOT NULL DEFAULT '0',
`vehiclePosRotation` varchar(255) NOT NULL DEFAULT '0',
`vehicleGroup` int(12) NOT NULL DEFAULT '0',
`vehicleGroupRank` int(6) DEFAULT '0',
`vehicleJob` int(12) NOT NULL DEFAULT '0',
`vehicleCol1` int(4) NOT NULL DEFAULT '-1',
`vehicleCol2` int(4) NOT NULL DEFAULT '-1',
`vehicleNumberPlate` varchar(255) NOT NULL DEFAULT 'LGY-RP',
PRIMARY KEY (`vehicleID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=249 ;
--
-- Salvarea datelor din tabel `vehicles`
--
INSERT INTO `vehicles` (`vehicleID`, `vehicleModelID`, `vehiclePosX`, `vehiclePosY`, `vehiclePosZ`, `vehiclePosRotation`, `vehicleGroup`, `vehicleGroupRank`, `vehicleJob`, `vehicleCol1`, `vehicleCol2`, `vehicleNumberPlate`) VALUES
(1, 547, '1198.310180', '-1835.903198', '13.135808', '269.611572', 0, 0, 0, 7, 7, 'LGY-RP'),
(2, 547, '1198.348632', '-1832.648681', '13.137253', '267.868560', 0, 0, 0, 7, 7, 'LGY-RP'),
(3, 547, '1198.463623', '-1829.555419', '13.139369', '269.452178', 0, 0, 0, 7, 7, 'LGY-RP'),
(4, 547, '1225.439697', '-1828.497924', '13.141233', '180.206542', 0, 0, 0, 7, 7, 'LGY-RP'),
(5, 596, '636.876831', '-554.128723', '15.981917', '0.881578', 2, 0, 0, 1, 7, 'LGY-RP'),
(6, 411, '2292.753173', '2434.440429', '2.999930', '116.046875', 2, 5, 0, 1, 1, 'LGY-RP'),
(7, 490, '636.371826', '-609.925354', '16.414344', '358.876190', 2, 2, 0, 0, 0, 'LGY-RP'),
(8, 528, '612.017272', '-597.414489', '17.270967', '268.474517', 2, 2, 0, 66, 102, 'LGY-RP'),
(9, 596, '637.012084', '-562.614318', '15.982011', '0.351052', 2, 0, 0, 1, 7, 'LGY-RP'),
(10, 411, '623.051940', '-605.839233', '16.783426', '272.191345', 2, 3, 0, 1, 7, 'LGY-RP'),
(11, 596, '637.064086', '-575.498962', '15.981768', '0.992000', 2, 0, 0, 1, 7, 'LGY-RP'),
(12, 497, '665.781921', '-614.941467', '16.490442', '92.123336', 2, 4, 0, 7, 1, 'LGY-RP'),
(13, 411, '221.773498', '1853.653686', '12.558401', '2.711836', 3, 1, 0, 1, 1, 'LGY-RP'),
(14, 411, '214.021392', '1853.432983', '12.546299', '0.400114', 3, 1, 0, 1, 1, 'LGY-RP'),
(15, 598, '195.150680', '1919.700195', '17.402709', '178.634963', 3, 1, 0, 0, 1, 'LGY-RP'),
(16, 598, '220.685256', '1919.830810', '17.403896', '181.731781', 3, 1, 0, 0, 1, 'LGY-RP'),
(17, 599, '223.481674', '1862.230468', '13.383355', '89.653465', 3, 1, 0, 0, 1, 'LGY-RP'),
(18, 563, '1562.939575', '-1706.484252', '29.105745', '90.051376', 1, 1, 0, 79, 1, 'LGY-RP'),
(19, 596, '1566.692626', '-1605.955932', '13.037806', '181.282211', 1, 1, 0, 0, 1, 'LGY-RP'),
(20, 596, '1574.727783', '-1606.054565', '13.132248', '175.876464', 1, 1, 0, 0, 1, 'LGY-RP'),
(21, 427, '1561.715820', '-1607.314819', '13.537670', '177.714843', 1, 2, 0, 0, 1, 'LGY-RP'),
(22, 598, '202.579284', '1919.818237', '17.403881', '180.115356', 3, 1, 0, 0, 1, 'LGY-RP'),
(23, 520, '-2374.996093', '1548.024536', '32.580429', '52.138469', 3, 1, 0, 10, 46, 'LGY-RP'),
(24, 599, '223.477844', '1866.818481', '13.362006', '90.787086', 3, 1, 0, 0, 1, 'LGY-RP'),
(25, 598, '213.145217', '1919.882690', '17.406965', '179.100860', 3, 1, 0, 0, 1, 'LGY-RP'),
(26, 407, '1187.699096', '-1300.218017', '13.707109', '179.487762', 4, 4, 0, 3, 3, 'LGY-RP'),
(27, 531, '-383.382080', '-1412.825683', '25.692266', '4.728504', 0, 0, 7, 222, 222, 'LGY-RP'),
(28, 416, '1181.923706', '-1338.924316', '13.755855', '271.476043', 4, 1, 0, 1, 3, 'LGY-RP'),
(29, 416, '1187.929931', '-1358.245483', '13.614495', '0.165812', 4, 1, 0, 1, 3, 'LGY-RP'),
(30, 425, '226.219421', '1885.617187', '18.219427', '358.869842', 3, 1, 0, 93, 83, 'LGY-RP'),
(31, 410, '779.458312', '-584.419860', '16.013557', '274.718078', 0, 0, 0, -1, -1, 'LGY-RP'),
(32, 599, '1177.360473', '-1313.443603', '14.274971', '270.160797', 4, 3, 0, 1, 3, 'LGY-RP'),
(33, 599, '1177.456909', '-1334.367919', '14.271764', '270.244232', 4, 3, 0, 1, 3, 'LGY-RP'),
(34, 522, '1477.255615', '-1770.845947', '18.371112', '5.139236', 5, 0, 0, 0, 0, 'LGY-RP'),
(35, 560, '1491.419067', '-1737.437988', '13.129186', '269.446472', 5, 0, 0, 0, 0, 'LGY-RP'),
(36, 409, '1473.597900', '-1737.486206', '13.261100', '267.195465', 5, 1, 0, 0, 0, 'LGY-RP'),
(37, 523, '1503.324707', '-1747.599243', '13.107806', '358.530548', 5, 0, 0, 0, 0, 'LGY-RP'),
(38, 523, '1458.407104', '-1748.344604', '13.115719', '3.628769', 5, 0, 0, 113, 21, 'LGY-RP'),
(39, 411, '1455.401855', '-1749.518676', '13.254681', '358.159057', 5, 2, 0, 0, 0, 'LGY-RP'),
(40, 411, '1507.640502', '-1748.590698', '13.241543', '357.792572', 5, 2, 0, 0, 0, 'LGY-RP'),
(41, 482, '1139.603881', '-2020.526855', '69.123336', '272.756011', 6, 1, 0, 0, 0, 'LGY-RP'),
(42, 560, '1152.391235', '-2045.429565', '68.676574', '71.823791', 6, 5, 0, 0, 0, 'LGY-RP'),
(43, 461, '1128.438842', '-2045.876220', '68.584472', '270.422241', 6, 1, 0, 0, 0, 'LGY-RP'),
(44, 409, '1139.959716', '-2041.582763', '68.778556', '269.663635', 6, 1, 0, 0, 0, 'LGY-RP'),
(45, 426, '1140.208740', '-2026.657592', '68.728561', '271.404357', 6, 1, 0, 0, 0, 'LGY-RP'),
(46, 487, '1157.191650', '-2037.036987', '69.214263', '270.307434', 6, 5, 0, 0, 0, 'LGY-RP'),
(47, 401, '1560.546875', '-2244.504882', '13.326198', '89.297309', 0, 0, 0, 110, 50, 'LGY-RP'),
(48, 401, '1560.592529', '-2257.614257', '13.322057', '90.635070', 0, 0, 0, -1, -1, 'LGY-RP'),
(49, 401, '1560.718505', '-2251.123291', '13.327308', '90.120262', 0, 0, 0, -1, -1, 'LGY-RP'),
(50, 401, '1560.636840', '-2264.122070', '13.296892', '88.567947', 0, 0, 0, -1, -1, 'LGY-RP'),
(51, 458, '1967.146606', '-1835.771118', '13.305604', '357.668395', 0, 0, 0, -1, -1, 'LGY-RP'),
(52, 560, '1021.841', '-1135.57', '23.439', '269.075', 9, 1, 0, 130, 130, 'Rifa Sultan'),
(53, 566, '1891.454223', '-2020.658813', '13.325956', '89.131607', 8, 1, 0, 135, 135, 'LGY-RP'),
(54, 482, '1007.416', '-1127.586', '23.987', '230.307', 9, 1, 0, 130, 130, 'LGY-RP'),
(55, 426, '1012.044', '-1119.619', '23.642', '177.746', 9, 1, 0, 130, 130, 'LGY-RP'),
(56, 487, '1030.819213', '-1131.479003', '24.000854', '179.254913', 9, 0, 0, 130, 130, 'LGY-RP'),
(57, 482, '2216.573242', '-1327.832641', '24.074768', '181.173706', 10, 1, 0, 233, 233, 'LGY-RP'),
(58, 426, '2226.934082', '-1366.632202', '23.758182', '2.124837', 10, 1, 0, 233, 233, 'LGY-RP'),
(59, 560, '2230.336914', '-1338.426391', '23.624250', '91.708503', 10, 1, 0, 233, 233, 'LGY-RP'),
(60, 461, '2214.166503', '-1348.323608', '23.555391', '238.096954', 10, 1, 0, 233, 233, 'LGY-RP'),
(61, 487, '2243.505859', '-1315.708374', '24.135986', '359.494079', 10, 5, 0, 233, 233, 'LGY-RP'),
(62, 468, '371.582855', '-2048.723632', '7.505012', '357.514770', 0, 0, 4, 0, 0, 'LGY-RP'),
(63, 469, '1018.892700', '-350.753631', '73.943237', '271.624084', 12, 1, 0, 93, 95, 'LGY-RP'),
(64, 468, '363.021514', '-2048.281250', '7.505108', '327.550720', 0, 0, 4, 0, 0, 'LGY-RP'),
(65, 468, '374.584747', '-2048.794433', '7.499139', '16.174043', 0, 0, 4, 0, 0, 'LGY-RP'),
(66, 468, '368.790130', '-2048.745117', '7.504919', '359.188446', 0, 0, 4, 0, 0, 'LGY-RP'),
(67, 462, '1841.071777', '-1871.298217', '12.989321', '1.237526', 0, 0, 0, 1, 1, 'Faggio'),
(68, 415, '1074.009033', '-293.225311', '73.717590', '179.890747', 12, 1, 0, 74, 1, 'LGY-RP'),
(69, 415, '1067.067504', '-293.241149', '73.718933', '178.539352', 12, 2, 0, 74, 1, 'LGY-RP'),
(70, 452, '728.129272', '-1493.830200', '-0.526360', '181.436080', 0, 0, 0, -1, -1, 'LGY-RP'),
(71, 473, '718.719787', '-1492.688842', '-0.391828', '181.919418', 0, 0, 0, -1, -1, 'LGY-RP'),
(72, 461, '1063.249389', '-299.322143', '73.575767', '196.802078', 12, 1, 0, 74, 1, 'LGY-RP'),
(73, 410, '665.805358', '-621.363220', '16.004051', '273.985504', 0, 0, 0, -1, -1, 'LGY-RP'),
(74, 596, '1570.535278', '-1605.901245', '13.109769', '180.031341', 1, 1, 0, 0, 1, 'LGY-RP'),
(75, 596, '1578.934936', '-1606.238769', '13.124501', '176.422058', 1, 1, 0, 0, 1, 'LGY-RP'),
(76, 497, '1564.330566', '-1650.472290', '28.533887', '93.389564', 1, 1, 0, 2, 1, 'LGY-RP'),
(77, 426, '538.763671', '-1290.384155', '16.985336', '358.967315', 0, 0, 0, 29, 11, 'LGY-RP'),
(78, 560, '1083.447021', '-297.897918', '73.661247', '162.482635', 12, 2, 0, 74, 1, 'LGY-RP'),
(79, 469, '1017.297607', '-334.606323', '74.025283', '276.687194', 12, 1, 0, 0, 0, 'LGY-RP'),
(80, 469, '1017.764343', '-343.415405', '74.032684', '178.066848', 12, 1, 0, 45, 11, 'LGY-RP'),
(81, 601, '1584.931762', '-1667.441284', '5.694205', '269.739379', 1, 5, 0, 114, 80, 'LGY-RP'),
(82, 528, '1602.633178', '-1684.208984', '5.860267', '90.416587', 1, 3, 0, 58, 123, 'LGY-RP'),
(83, 528, '612.244445', '-601.913574', '17.279455', '274.045837', 2, 2, 0, 117, 69, 'LGY-RP'),
(84, 528, '1602.478881', '-1688.078125', '5.851233', '89.740539', 1, 4, 0, 73, 41, 'LGY-RP'),
(85, 522, '1484.902587', '-1770.612182', '18.369907', '356.815856', 5, 0, 0, 0, 0, 'LGY-RP'),
(86, 427, '1548.939697', '-1697.840942', '13.703846', '89.309570', 1, 2, 0, 0, 1, 'LGY-RP'),
(87, 596, '1587.363891', '-1606.223632', '13.112287', '179.535766', 1, 1, 0, 0, 1, 'LGY-RP'),
(88, 531, '-372.920989', '-1419.807250', '25.692777', '356.449371', 0, 0, 7, 3, 3, 'LGY-RP'),
(89, 566, '2047.274902', '-1130.184082', '23.859603', '269.242675', 0, 0, 0, -1, -1, 'LGY-RP'),
(90, 531, '-364.821899', '-1439.898681', '25.688907', '90.760787', 0, 0, 7, 194, 194, 'LGY-RP'),
(91, 448, '2096.049', '-1800.328', '12.984', '88.012', 0, 0, 6, 11, 106, 'LGY-RP'),
(92, 531, '-366.108642', '-1412.944458', '25.690317', '66.621368', 0, 0, 7, 155, 155, 'LGY-RP'),
(93, 531, '-372.383087', '-1414.140136', '25.690359', '358.093688', 0, 0, 7, 200, 200, 'LGY-RP'),
(94, 448, '2095.559', '-1793.033', '12.987', '86.208', 0, 0, 6, 65, 76, 'LGY-RP'),
(95, 560, '1097.984130', '-1218.627441', '17.503547', '2.459191', 13, 1, 0, 154, 1, 'LGY-RP'),
(96, 405, '1102.588134', '-1218.370361', '17.679687', '359.859405', 13, 1, 0, 154, 1, 'LGY-RP'),
(97, 560, '1092.917358', '-1218.652343', '17.501621', '1.938484', 13, 1, 0, 154, 1, 'LGY-RP'),
(98, 405, '1107.993652', '-1218.451416', '17.679672', '0.076616', 13, 3, 0, 154, 1, 'LGY-RP'),
(99, 487, '1134.104736', '-1170.911010', '32.220951', '179.289489', 13, 3, 0, 154, 1, 'LGY-RP'),
(100, 487, '1144.522705', '-1170.206054', '32.224224', '180.682708', 13, 3, 0, 154, 1, 'LGY-RP'),
(101, 487, '1552.277465', '-1350.022216', '329.650451', '111.027709', 12, 3, 0, 43, 43, 'LGY-RP'),
(102, 410, '840.087768', '-1135.691772', '23.417531', '277.746734', 0, 0, 0, -1, -1, 'LGY-RP'),
(103, 402, '1070.849731', '-293.676483', '73.752510', '179.120849', 12, 1, 0, 43, 0, 'LGY-RP'),
(104, 492, '2510.045166', '-1674.910522', '13.245689', '60.717319', 7, 1, 0, 187, 187, 'LGY-RP'),
(105, 521, '1016.884', '-1123.923', '23.43', '170.215', 9, 2, 0, 130, 130, 'LGY-RP'),
(106, 579, '1034.495605', '-1119.471557', '23.663715', '178.125610', 9, 1, 0, 130, 130, 'LGY-RP'),
(107, 405, '1883.002929', '-2003.487792', '13.421804', '180.527862', 8, 1, 0, 135, 135, 'LGY-RP'),
(108, 461, '1027.519', '-1123.549', '23.465', '179.322', 9, 1, 0, 130, 130, 'LGY-RP'),
(109, 575, '2428.582031', '-1243.364624', '23.743181', '357.442718', 0, 0, 0, -1, -1, 'LGY-RP'),
(110, 582, '-303.332458', '1832.752319', '42.346565', '315.098785', 15, 0, 0, 29, 5, 'LGY-RP'),
(111, 582, '-320.812011', '1515.662597', '75.417198', '359.756896', 15, 1, 0, 1, 49, 'LGY-RP'),
(112, 410, '666.033569', '-1538.716796', '14.493157', '268.467285', 0, 0, 0, -1, -1, 'LGY-RP'),
(113, 582, '-327.388275', '1515.801391', '75.461692', '1.748215', 15, 1, 0, 122, 5, 'LGY-RP'),
(114, 589, '531.583984', '-1289.741455', '16.985603', '359.290863', 0, 0, 0, 3, 48, 'LGY-RP'),
(115, 582, '-333.308868', '1514.924316', '75.422492', '357.035308', 15, 1, 0, 94, 34, 'LGY-RP'),
(116, 550, '545.554321', '-1290.751953', '17.084180', '358.742370', 0, 0, 0, 94, 106, 'LGY-RP'),
(117, 542, '2570.943115', '-1490.339721', '23.759757', '265.611328', 0, 0, 0, -1, -1, 'LGY-RP'),
(118, 482, '2511.543457', '-1669.245727', '13.587042', '86.512283', 7, 1, 0, 187, 1, 'LGY-RP'),
(119, 461, '2489.490478', '-1686.006103', '13.104640', '359.943450', 7, 1, 0, 187, 1, 'LGY-RP'),
(120, 410, '399.209747', '-1373.389160', '14.499610', '301.991882', 0, 0, 0, -1, -1, 'LGY-RP'),
(121, 531, '-382.986358', '-1417.885009', '25.689567', '290.230651', 0, 0, 7, 229, 229, 'LGY-RP'),
(122, 496, '551.548461', '-1290.810058', '16.931085', '352.287445', 0, 0, 0, 187, 1, 'LGY-RP'),
(123, 531, '-378.199096', '-1450.825927', '25.690685', '0.079130', 0, 0, 7, 151, 151, 'LGY-RP'),
(124, 521, '2491.655761', '-1685.870727', '13.075943', '0.883098', 7, 0, 0, 187, 1, 'LGY-RP'),
(125, 407, '1188.152343', '-1348.607666', '13.730781', '358.341705', 4, 4, 0, 3, 1, 'LGY-RP'),
(126, 550, '1323.911987', '-1459.679077', '13.378744', '270.090759', 0, 0, 0, -1, -1, 'LGY-RP'),
(127, 567, '2508.500488', '-1660.170043', '13.386986', '122.571006', 7, 1, 0, 187, 1, 'LGY-RP'),
(128, 560, '2507.113037', '-1679.709228', '13.170280', '43.955913', 7, 1, 0, 187, 1, 'LGY-RP'),
(129, 426, '2480.991210', '-1654.607910', '13.130502', '90.501976', 7, 1, 0, 187, 1, 'LGY-RP'),
(130, 488, '-292.506378', '1537.177368', '75.769248', '248.189926', 15, 2, 0, 9, 8, 'LGY-RP'),
(131, 487, '2526.999267', '-1677.912719', '20.114021', '86.421356', 7, 0, 0, 187, 187, 'LGY-RP'),
(132, 515, '-76.408386', '-1108.019775', '2.094731', '161.749542', 0, 0, 9, 81, 89, 'LGY-RP'),
(133, 446, '-650.150451', '868.102722', '-0.541339', '228.585037', 0, 0, 0, 211, 226, 'Green Best.'),
(134, 515, '-64.117706', '-1112.762817', '2.094029', '156.754302', 0, 0, 9, 64, 123, 'LGY-RP'),
(135, 522, '2296.029785', '-1631.400512', '14.266880', '86.525787', 0, 0, 0, 67, 24, 'LGY-RP'),
(136, 468, '361.833831', '-2044.268554', '7.501624', '268.421051', 0, 0, 4, 0, 0, 'LGY-RP'),
(137, 602, '2159.134765', '-1805.201782', '13.184434', '89.954452', 0, 0, 0, -1, -1, 'LGY-RP'),
(138, 448, '2095.411', '-1820.311', '12.98', '91.097', 0, 0, 6, 99, 87, 'LGY-RP'),
(139, 515, '-69.969070', '-1110.161010', '2.094589', '159.017868', 0, 0, 9, 102, 115, 'LGY-RP'),
(140, 521, '1135.510986', '-2013.280395', '68.564575', '351.318542', 6, 1, 0, 0, 0, 'LGY-RP'),
(141, 468, '366.073608', '-2048.714355', '7.504929', '359.213653', 0, 0, 4, 0, 0, 'LGY-RP'),
(142, 462, '1844.142333', '-1871.337280', '12.989290', '359.193725', 0, 0, 0, 1, 1, 'LGY-RP'),
(143, 435, '-43.383689', '-1155.037719', '1.728225', '64.851669', 0, 0, 9, 6, 6, 'LGY-RP'),
(144, 448, '2095.208', '-1815.361', '12.982', '87.651', 0, 0, 6, 125, 31, 'LGY-RP'),
(145, 420, '1786.247436', '-1932.822631', '13.191637', '3.812190', 14, 2, 0, 6, 6, 'LGY-RP'),
(146, 468, '361.868713', '-2042.090087', '7.504942', '271.673919', 0, 0, 4, 0, 0, 'LGY-RP'),
(147, 515, '-49.827548', '-1117.484497', '2.140136', '160.653518', 0, 0, 9, 118, 23, 'LGY-RP'),
(148, 438, '1804.460083', '-1918.478759', '13.381947', '90.978271', 14, 1, 0, 6, 6, 'LGY-RP'),
(149, 435, '-38.067466', '-1144.845947', '1.710403', '62.359184', 0, 0, 9, 6, 6, 'LGY-RP'),
(150, 402, '1077.564208', '-293.608489', '73.752639', '176.113479', 12, 1, 0, 43, 43, 'LGY-RP'),
(151, 567, '1140.116455', '-2054.278320', '68.887939', '270.067749', 6, 1, 0, 0, 0, 'LGY-RP'),
(152, 405, '1140.522216', '-2048.763183', '68.873725', '279.570556', 6, 2, 0, 0, 0, 'LGY-RP'),
(153, 520, '201.591064', '1891.223754', '18.369132', '354.524566', 3, 2, 0, 6, 6, 'LGY-RP'),
(154, 487, '1963.766845', '-2647.876708', '13.714962', '358.484558', 0, 0, 0, -1, -1, 'LGY-RP'),
(155, 487, '1973.071777', '-2647.945800', '13.717036', '352.316680', 0, 0, 0, -1, -1, 'LGY-RP'),
(156, 525, '864.007812', '-1255.789672', '14.745947', '267.284606', 0, 0, 0, 109, 14, 'LGY-RP'),
(157, 468, '361.852447', '-2046.147216', '7.499322', '267.819641', 0, 0, 4, 0, 0, 'LGY-RP'),
(158, 577, '1933.041748', '-2377.893798', '13.439205', '176.714843', 0, 0, 0, 101, 112, 'LGY-RP'),
(159, 519, '1890.380004', '-2627.763671', '14.451828', '358.420501', 0, 0, 0, -1, -1, 'LGY-RP'),
(160, 401, '892.717102', '-1669.139648', '13.330414', '359.212677', 0, 0, 0, 5, 5, 'LGY-RP'),
(161, 462, '1835.009155', '-1871.216064', '12.989219', '0.770780', 0, 0, 0, 1, 1, 'LGY-RP'),
(162, 511, '1684.139892', '-2628.005615', '14.921717', '0.000000', 0, 0, 0, -1, -1, 'LGY-RP'),
(163, 485, '1655.062988', '-2538.219726', '13.203288', '88.035346', 0, 0, 0, -1, -1, 'LGY-RP'),
(164, 485, '1652.384277', '-2547.680908', '13.201418', '88.283134', 0, 0, 0, -1, -1, 'LGY-RP'),
(165, 435, '-35.697303', '-1140.494995', '1.712750', '60.601913', 0, 0, 9, 6, 6, 'LGY-RP'),
(166, 435, '-40.793857', '-1149.991577', '1.714925', '62.594215', 0, 0, 9, 6, 6, 'LGY-RP'),
(167, 582, '-339.993377', '1515.486328', '75.404479', '0.726874', 15, 1, 0, 46, 43, 'LGY-RP'),
(168, 582, '-346.128387', '1514.992309', '75.351348', '2.079033', 15, 1, 0, 50, 22, 'LGY-RP'),
(169, 525, '909.745056', '-1207.685302', '16.859603', '197.486114', 0, 0, 3, 31, 98, 'LGY-RP'),
(170, 416, '1181.578491', '-1308.761962', '13.697491', '270.376525', 4, 1, 0, 1, 3, 'LGY-RP'),
(171, 438, '1777.114013', '-1914.521728', '13.443995', '269.483825', 14, 1, 0, 6, 6, 'LGY-RP'),
(172, 420, '1801.033203', '-1932.433105', '13.166593', '359.703277', 14, 2, 0, 6, 6, 'LGY-RP'),
(173, 438, '1776.804565', '-1908.218261', '13.451959', '273.895050', 14, 1, 0, 6, 6, 'LGY-RP'),
(174, 438, '1777.054565', '-1921.168579', '13.443326', '269.493286', 14, 1, 0, 6, 6, 'LGY-RP'),
(175, 438, '1776.927124', '-1928.216552', '13.453701', '269.539001', 14, 1, 0, 6, 6, 'LGY-RP'),
(176, 560, '1804.727294', '-1913.525024', '13.100573', '90.387313', 14, 3, 0, 6, 6, 'LGY-RP'),
(177, 560, '1804.548217', '-1908.828002', '13.078456', '88.640220', 14, 5, 0, 6, 6, 'LGY-RP'),
(178, 420, '1791.263183', '-1932.714111', '13.165579', '1.916643', 14, 2, 0, 6, 6, 'LGY-RP'),
(179, 410, '1920.082641', '768.319702', '10.397954', '270.162994', 0, 0, 0, 62, 50, 'LGY-RP'),
(180, 420, '1796.096557', '-1932.580566', '13.197487', '359.999908', 14, 2, 0, 6, 6, 'LGY-RP'),
(181, 604, '1303.373901', '-1249.778930', '13.291378', '181.637954', 0, 0, 0, -1, -1, 'LGY-RP'),
(182, 531, '-381.534362', '-1450.808837', '25.692184', '0.044235', 0, 0, 7, 211, 211, 'LGY-RP'),
(183, 469, '1017.251831', '-326.074188', '74.021759', '270.292602', 12, 1, 0, 32, 88, 'LGY-RP'),
(184, 435, '-1883.501220', '-1740.955566', '21.465568', '24.041904', 0, 0, 0, 18, 86, 'LGY-RP'),
(185, 550, '2154.414550', '2287.003417', '10.652217', '331.367614', 0, 0, 0, 1, 1, 'LGY-RP'),
(186, 531, '-371.072723', '-1447.306030', '25.687398', '1.865961', 0, 0, 7, 226, 226, 'LGY-RP'),
(187, 468, '362.019714', '-2041.654174', '7.502812', '271.424499', 0, 0, 4, 0, 50, 'LGY-RP'),
(188, 462, '1832.225219', '-1871.270996', '12.982564', '359.430755', 0, 0, 0, 1, 1, '69'),
(189, 525, '867.358825', '-1207.767089', '16.845207', '180.429077', 0, 0, 3, 21, 106, 'LGY-RP'),
(190, 490, '641.678161', '-609.968505', '16.408372', '356.824523', 2, 2, 0, 0, 0, 'LGY-RP'),
(191, 596, '637.350891', '-581.358642', '15.985299', '0.669322', 2, 0, 0, 1, 7, 'LGY-RP'),
(192, 411, '622.812133', '-610.699829', '16.831209', '267.578613', 2, 3, 0, 1, 7, 'FBI'),
(193, 468, '361.939941', '-2039.607299', '7.501790', '272.110168', 0, 0, 4, 0, 0, 'LGY-RP'),
(194, 468, '204.255432', '1859.478393', '12.801395', '265.903320', 3, 1, 0, 226, 226, 'LGY-RP'),
(195, 596, '1536.009643', '-1667.107910', '13.103435', '180.151962', 1, 1, 0, 0, 1, 'LGY-RP'),
(196, 596, '1582.866455', '-1606.087524', '13.110598', '177.078216', 1, 1, 0, 0, 1, 'LGY-RP'),
(197, 411, '1604.639160', '-1625.186767', '13.242486', '91.487075', 1, 6, 0, 1, 1, 'LGY-RP'),
(198, 411, '1604.824340', '-1628.482421', '13.244470', '92.975158', 1, 3, 0, 1, 1, 'LGY-RP'),
(199, 599, '1604.333862', '-1621.380004', '13.584363', '91.410209', 1, 1, 0, 0, 1, 'LGY-RP'),
(200, 599, '1604.291137', '-1616.857177', '13.759970', '90.415290', 1, 2, 0, 0, 1, 'LGY-RP'),
(201, 523, '1544.999755', '-1611.396118', '12.951971', '274.110046', 1, 1, 0, 0, 0, 'LGY-RP'),
(202, 468, '204.089935', '1861.432495', '12.805898', '270.071960', 3, 1, 0, 226, 266, 'LGY-RP'),
(203, 523, '1544.848266', '-1609.261474', '12.948449', '268.876464', 1, 1, 0, 0, 0, 'LGY-RP'),
(204, 523, '1548.881347', '-1680.979003', '13.124260', '74.915351', 1, 2, 0, 0, 0, 'LGY-RP'),
(205, 523, '1549.749877', '-1670.374511', '13.137615', '92.311454', 1, 2, 0, 0, 0, 'LGY-RP'),
(206, 523, '611.448242', '-586.765686', '16.784387', '272.561370', 2, 0, 0, 0, 0, 'LGY-RP'),
(207, 596, '1536.023925', '-1678.256225', '13.104019', '358.525115', 1, 2, 0, 0, 1, 'LGY-RP'),
(208, 405, '2607.853515', '-2199.597900', '13.421837', '179.172424', 0, 0, 0, -1, -1, 'LGY-RP'),
(209, 404, '126.929542', '-1724.885253', '7.730700', '214.006896', 0, 0, 0, -1, -1, 'LGY-RP'),
(210, 521, '2214.177246', '-1347.132568', '23.552923', '272.174865', 10, 1, 0, 233, 233, 'LGY-RP'),
(211, 566, '2231.185058', '-1366.601684', '23.796449', '0.318983', 10, 1, 0, 233, 233, 'LGY-RP'),
(212, 470, '236.843856', '1905.578979', '17.668943', '93.039596', 3, 0, 0, 96, 3, 'LGY-RP'),
(213, 525, '864.559936', '-1245.135498', '14.494702', '274.209381', 0, 0, 3, 92, 39, 'LGY-RP'),
(214, 579, '2229.326904', '-1343.303588', '23.857576', '89.742080', 10, 1, 0, 233, 233, 'LGY-RP'),
(215, 502, '2757.459472', '-1876.182373', '9.594129', '178.667373', 0, 0, 0, -1, -1, 'LGY-RP'),
(216, 602, '2776.788574', '-1840.178222', '9.587071', '19.632228', 0, 0, 0, -1, -1, 'LGY-RP'),
(217, 531, '-364.901397', '-1442.798828', '25.693155', '88.870803', 0, 0, 7, 181, 181, 'LGY-RP'),
(218, 603, '523.803710', '-1289.223632', '17.038848', '358.521697', 0, 0, 0, 104, 87, 'LGY-RP'),
(219, 561, '856.994934', '-1365.049560', '13.336494', '180.474197', 0, 0, 0, -1, -1, 'LGY-RP'),
(220, 567, '2214.374023', '-1358.833007', '23.889568', '180.736541', 10, 1, 0, 233, 233, 'LGY-RP'),
(221, 461, '2214.227050', '-1349.809326', '23.569465', '271.887939', 10, 1, 0, 233, 233, 'LGY-RP'),
(222, 453, '338.139556', '-2161.123046', '-0.208551', '146.548873', 0, 0, 0, -1, -1, 'LGY-RP'),
(223, 608, '1936.943359', '-2397.021240', '14.071707', '85.179031', 0, 0, 0, -1, -1, 'LGY-RP'),
(224, 515, '-57.380794', '-1114.509277', '2.139424', '158.131317', 0, 0, 9, 51, 115, 'LGY-RP'),
(225, 531, '-361.835815', '-1409.894775', '25.690982', '90.777030', 0, 0, 7, 233, 233, 'LGY-RP'),
(226, 563, '1158.884277', '-1372.435913', '27.366823', '266.991638', 4, 3, 0, 3, 1, 'LGY-RP'),
(227, 462, '1838.278686', '-1871.225952', '12.988386', '1.324307', 0, 0, 0, 1, 1, 'LGY-RP'),
(228, 560, '1867.691894', '-2031.133300', '13.251774', '270.796600', 8, 1, 0, 135, 135, 'LGY-RP'),
(229, 579, '1895.163085', '-2037.728881', '13.477427', '90.223442', 8, 1, 0, 135, 135, 'LGY-RP'),
(230, 521, '1870.686889', '-2034.595825', '13.117939', '270.396118', 8, 0, 0, 135, 135, 'LGY-RP'),
(231, 487, '1899.782348', '-2024.568603', '18.984470', '88.240791', 8, 0, 0, 135, 135, 'LGY-RP'),
(232, 461, '1870.946533', '-2038.161254', '13.120438', '268.233520', 8, 0, 0, 135, 135, 'LGY-RP'),
(233, 560, '720.308959', '-1432.845092', '13.192288', '86.177566', 11, 0, 0, 6, 6, 'LGY-RP'),
(234, 521, '703.191223', '-1420.469726', '13.105791', '0.327479', 11, 1, 0, 6, 6, 'LGY-RP'),
(235, 405, '713.139160', '-1426.542236', '13.438203', '3.561102', 11, 1, 0, 6, 6, 'LGY-RP'),
(236, 487, '717.379150', '-1443.501464', '17.858652', '2.938129', 11, 1, 0, 6, 6, 'LGY-RP'),
(237, 461, '703.405456', '-1426.652343', '13.116523', '0.747424', 11, 1, 0, 6, 6, 'LGY-RP'),
(238, 579, '703.172058', '-1437.276245', '13.446467', '285.213195', 11, 1, 0, 6, 6, 'LGY-RP'),
(239, 547, '1216.188354', '-1828.613525', '13.143385', '182.191833', 0, 0, 0, 7, 7, 'LGY-RP'),
(240, 547, '1219.030517', '-1828.537963', '13.142826', '182.436920', 0, 0, 0, 7, 7, 'LGY-RP'),
(241, 547, '1228.632812', '-1828.432495', '13.141334', '181.421752', 0, 0, 0, 7, 7, 'LGY-RP'),
(242, 547, '1221.980834', '-1828.520263', '13.143394', '181.165496', 0, 0, 0, 7, 7, 'LGY-RP'),
(243, 435, '2480.627929', '-2116.180908', '14.181365', '357.768463', 0, 0, 0, -1, -1, 'FG'),
(244, 435, '2464.615966', '-2116.684570', '14.184091', '6.568890', 0, 0, 0, -1, -1, 'FG'),
(245, 435, '2456.430664', '-2116.031494', '14.185961', '359.931457', 0, 0, 0, -1, -1, 'FG'),
(246, 435, '2473.649902', '-2116.341796', '14.204502', '1.565792', 0, 0, 0, -1, -1, 'FG'),
(247, 435, '2487.777099', '-2115.985351', '14.205719', '358.817535', 0, 0, 0, -1, -1, 'FG'),
(248, 435, '2495.696533', '-2116.152099', '14.205096', '358.468322', 0, 0, 0, -1, -1, 'FG');
/*!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 */;

Master18 · August 30, 2015

tot aceasi eroare da

Sign In

Problema upbload baza de date

Question

Master18

6 answers to this question

Recommended Posts

EquiNoxAdv

EquiNoxAdv

Master18

EquiNoxAdv

Master18

Master18

Create an account or sign in to comment

Create an account

Sign in

Similar Content

Caut scripter pentru un sv pe baza de launcher, Contra cost!

Cum fac sa trimita o singura data mesajul jucatorului care intra in raza Aero LS?

Problema RemovePlayerMapIcon

Actualizare textdraw (speedometer) la secunda (problema)

Problema billboards (la expirarea billboard-ului nu seteaza variabila Billboard 0 jucatorului offline)

Recently Browsing 0 members

Browse

Activity

Important Information