Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 4.1.14
- -- http://www.phpmyadmin.net
- --
- -- Host: 127.0.0.1
- -- Generation Time: 2017 m. Kov 05 d. 09:47
- -- Server version: 5.6.17
- -- PHP Version: 5.5.12
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- --
- -- Database: `lsplay`
- --
- -- --------------------------------------------------------
- --
- -- Sukurta duomenų struktūra lentelei `baudos`
- --
- CREATE TABLE IF NOT EXISTS `baudos` (
- `bauda_ID` int(11) NOT NULL AUTO_INCREMENT,
- `bauda_pID` int(11) NOT NULL,
- `bauda_Money` int(9) NOT NULL,
- `bauda_Reason` varchar(50) NOT NULL,
- PRIMARY KEY (`bauda_ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Sukurta duomenų struktūra lentelei `business`
- --
- CREATE TABLE IF NOT EXISTS `business` (
- `bID` int(11) NOT NULL AUTO_INCREMENT,
- `bOwnerID` int(11) NOT NULL,
- `bName` varchar(50) NOT NULL,
- `bPosX` float NOT NULL,
- `bPosY` float NOT NULL,
- `bPosZ` float NOT NULL,
- `bcInterior` int(5) NOT NULL,
- `bcPosX` float NOT NULL,
- `bcPosY` float NOT NULL,
- `bcPosZ` float NOT NULL,
- `bkPosX` float NOT NULL,
- `bkPosY` float NOT NULL,
- `bkPosZ` float NOT NULL,
- `bIsBuyable` int(1) NOT NULL,
- `bPrice` int(11) NOT NULL,
- `bType` int(1) NOT NULL,
- `bExtra0` int(11) NOT NULL,
- `bEarnings` int(11) NOT NULL,
- PRIMARY KEY (`bID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
- --
- -- Sukurta duomenų kopija lentelei `business`
- --
- INSERT INTO `business` (`bID`, `bOwnerID`, `bName`, `bPosX`, `bPosY`, `bPosZ`, `bcInterior`, `bcPosX`, `bcPosY`, `bcPosZ`, `bkPosX`, `bkPosY`, `bkPosZ`, `bIsBuyable`, `bPrice`, `bType`, `bExtra0`, `bEarnings`) VALUES
- (4, 19, 'Lukoil', 1930.31, -1785.81, 13.547, 0, 1930.21, -1779.51, 13.547, 1922.57, -1790.8, 13.383, 0, 1250000, 1, 15, 0),
- (5, -1, 'be pavadinimo', 1194.22, -917.189, 43.164, 0, 0, 0, 0, 0, 0, 0, 1, 2500000, 0, 0, 0),
- (6, 1, 'Baldyla', 1115.54, -1371.03, 13.991, 0, 0, 0, 0, 0, 0, 0, 1, 0, 3, 0, 0),
- (7, 53, 'Gintarinë vaistinë', 2249.86, 52.814, 26.667, 0, 2254.9, 45.893, 26.336, 2245.59, 49.435, 26.484, 0, 100000, 4, 0, 0);
- -- --------------------------------------------------------
- --
- -- Sukurta duomenų struktūra lentelei `gangs`
- --
- CREATE TABLE IF NOT EXISTS `gangs` (
- `gangID` int(11) NOT NULL AUTO_INCREMENT,
- `gangName` varchar(30) NOT NULL,
- `gangLeadID` int(11) NOT NULL,
- `gangRep` int(11) NOT NULL,
- `gangColor` int(11) NOT NULL,
- `gangX` float NOT NULL,
- `gangY` float NOT NULL,
- `gangZ` float NOT NULL,
- PRIMARY KEY (`gangID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;
- --
- -- Sukurta duomenų kopija lentelei `gangs`
- --
- INSERT INTO `gangs` (`gangID`, `gangName`, `gangLeadID`, `gangRep`, `gangColor`, `gangX`, `gangY`, `gangZ`) VALUES
- (1, 'ðuo', 22, 15, 0, 2492.17, -1692.1, 14.7656),
- (2, 'Pakaraka', 14, 9000, 0, 1967.54, -1176.65, 20.0307);
- -- --------------------------------------------------------
- --
- -- Sukurta duomenų struktūra lentelei `garages`
- --
- CREATE TABLE IF NOT EXISTS `garages` (
- `gID` int(11) NOT NULL AUTO_INCREMENT,
- `gOwnerID` int(11) NOT NULL,
- `gPrice` int(11) NOT NULL,
- `gGalioja` int(11) NOT NULL,
- `gBuyable` int(1) NOT NULL,
- `gPosX` float NOT NULL,
- `gPosY` float NOT NULL,
- `gPosZ` float NOT NULL,
- `gVartaiID` int(4) NOT NULL,
- PRIMARY KEY (`gID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Sukurta duomenų struktūra lentelei `gps`
- --
- CREATE TABLE IF NOT EXISTS `gps` (
- `gpsID` int(11) NOT NULL AUTO_INCREMENT,
- `gpsName` varchar(40) NOT NULL,
- `gpsX` float NOT NULL,
- `gpsY` float NOT NULL,
- `gpsZ` float NOT NULL,
- `gpsType` int(2) NOT NULL,
- `gpsMap` varchar(3) NOT NULL,
- PRIMARY KEY (`gpsID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=27 ;
- --
- -- Sukurta duomenų kopija lentelei `gps`
- --
- INSERT INTO `gps` (`gpsID`, `gpsName`, `gpsX`, `gpsY`, `gpsZ`, `gpsType`, `gpsMap`) VALUES
- (6, 'LS - Transporto turgus', 2267.85, -1974.65, 13.362, 2, 'ls'),
- (9, 'LS - Degalinë', 1941.88, -1759.77, 13.14, 2, 'ls'),
- (10, 'LS - Policija', 1530.44, -1675.22, 13.383, 0, 'ls'),
- (11, 'LS - Ligoninë', 1996, -1452.45, 13.325, 2, 'ls'),
- (12, 'LS - Bankas', 1722.14, -1292.76, 13.547, 2, 'ls'),
- (13, 'LS - Tune', 1040.53, -1032.42, 31.997, 2, 'ls'),
- (14, 'LS - Oro uostas', 1923.74, -2409.43, 13.197, 2, 'ls'),
- (15, 'SF - Tune (WAA)', -2690.47, 210.164, 4.328, 2, 'sf'),
- (16, 'LS - Fûristai', 2760.57, -2459.21, 13.56, 0, 'ls'),
- (17, 'LS - Taksi', 1814.12, -1871.19, 13.57, 0, 'ls'),
- (18, 'Atsiradimo vieta', 634.72, -1451.06, 14.183, 2, 'ls'),
- (19, 'LS - 2 Ligoninë', 1200.97, -1327.59, 13.398, 2, 'ls'),
- (20, 'LS - Autoservisas', 1667.19, -1826.79, 13.554, 0, 'ls'),
- (21, 'LS - Taksi', 2480.65, -1739.54, 13.547, 0, 'ls'),
- (22, 'Degalø gamykla', 2483.94, -2111.03, 13.5469, 5, 'ls'),
- (23, 'testinglel 2', 1820.66, -1308.36, 131.734, 2, 'ls'),
- (24, 'PC - Bankas', 2301.29, -6.81, 26.484, 2, 'km'),
- (25, 'VM', 681.914, -638.983, 16.188, 2, 'km'),
- (26, 'Dillimore degalinë', 699.959, -565.85, 16.329, 3, 'km');
- -- --------------------------------------------------------
- --
- -- Sukurta duomenų struktūra lentelei `gzones`
- --
- CREATE TABLE IF NOT EXISTS `gzones` (
- `gID` int(2) NOT NULL AUTO_INCREMENT,
- `gminX` float NOT NULL,
- `gminY` float NOT NULL,
- `gmaxX` float NOT NULL,
- `gmaxY` float NOT NULL,
- `gOwners` int(11) NOT NULL,
- PRIMARY KEY (`gID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Sukurta duomenų struktūra lentelei `houses`
- --
- CREATE TABLE IF NOT EXISTS `houses` (
- `hID` int(11) NOT NULL AUTO_INCREMENT,
- `hOwnerID` int(11) NOT NULL,
- `hLocked` int(1) NOT NULL,
- `hInterior` int(11) NOT NULL,
- `hIsBuyable` int(1) NOT NULL,
- `hoPosX` float NOT NULL,
- `hoPosY` float NOT NULL,
- `hoPosZ` float NOT NULL,
- `hiPosX` float NOT NULL,
- `hiPosY` float NOT NULL,
- `hiPosZ` float NOT NULL,
- `hPrice` int(11) NOT NULL,
- `hAlarm` int(2) NOT NULL,
- `hCamera` int(2) NOT NULL,
- `hDoors` int(2) NOT NULL,
- `hIntUpgrade` int(11) NOT NULL,
- `hSignalizacija` int(2) NOT NULL,
- `hStreet` varchar(30) NOT NULL,
- `hNumber` int(11) NOT NULL,
- `hMap` varchar(3) NOT NULL,
- PRIMARY KEY (`hID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=132 ;
- --
- -- Sukurta duomenų kopija lentelei `houses`
- --
- INSERT INTO `houses` (`hID`, `hOwnerID`, `hLocked`, `hInterior`, `hIsBuyable`, `hoPosX`, `hoPosY`, `hoPosZ`, `hiPosX`, `hiPosY`, `hiPosZ`, `hPrice`, `hAlarm`, `hCamera`, `hDoors`, `hIntUpgrade`, `hSignalizacija`, `hStreet`, `hNumber`, `hMap`) VALUES
- (4, -1, 1, 0, 1, 2459.48, -1691.06, 13.545, 0, 0, 0, 564521, 0, 0, 0, 0, 0, 'Jotvingiø', 1, 'ls'),
- (5, -1, 1, 0, 1, 2514.17, -1691.61, 14.046, 0, 0, 0, 458642, 0, 0, 0, 0, 0, 'Jotvingiø', 2, 'ls'),
- (6, -1, 1, 0, 1, 2523.27, -1679.4, 15.497, 0, 0, 0, 581976, 0, 0, 0, 0, 0, 'Jotvingiø', 3, 'ls'),
- (7, -1, 1, 0, 1, 2524.71, -1658.75, 15.824, 0, 0, 0, 488514, 0, 0, 0, 0, 0, 'Jotvingiø', 4, 'ls'),
- (8, 15, 1, 0, 0, 2513.75, -1650.28, 14.356, 0, 0, 0, 487355, 0, 0, 0, 0, 0, 'Jotvingiø', 5, 'ls'),
- (9, -1, 1, 0, 1, 2498.45, -1642.64, 13.783, 0, 0, 0, 423165, 0, 0, 0, 0, 0, 'Jotvingiø', 6, 'ls'),
- (10, -1, 1, 0, 1, 2486.48, -1644.54, 14.077, 0, 0, 0, 581584, 0, 0, 0, 0, 0, 'Jotvingiø', 7, 'ls'),
- (11, -1, 1, 0, 1, 2469.54, -1646.35, 13.78, 0, 0, 0, 465497, 0, 0, 0, 0, 0, 'Jotvingiø', 8, 'ls'),
- (12, -1, 1, 0, 1, 2451.9, -1641.41, 14.066, 0, 0, 0, 456479, 0, 0, 0, 0, 0, 'Jotvingiø', 9, 'ls'),
- (13, -1, 1, 0, 1, 2413.84, -1646.79, 14.012, 0, 0, 0, 473345, 0, 0, 0, 0, 0, 'Jotvingiø', 10, 'ls'),
- (14, -1, 1, 0, 1, 2409.02, -1674.87, 14.375, 0, 0, 0, 473345, 0, 0, 0, 0, 0, 'Jotvingiø', 11, 'ls'),
- (15, -1, 1, 0, 1, 2384.64, -1675.84, 15.246, 0, 0, 0, 508269, 0, 0, 0, 0, 0, 'Jotvingiø', 13, 'ls'),
- (16, 15, 1, 0, 0, 2368.27, -1675.16, 14.168, 0, 0, 0, 532798, 0, 0, 0, 0, 0, 'Jotvingiø', 15, 'ls'),
- (17, -1, 1, 0, 1, 2393.32, -1646.04, 13.905, 0, 0, 0, 532798, 0, 0, 0, 0, 0, 'Jotvingiø', 12, 'ls'),
- (18, -1, 1, 0, 1, 2362.79, -1643.24, 14.352, 0, 0, 0, 467608, 0, 0, 0, 0, 0, 'Jotvingiø', 14, 'ls'),
- (19, -1, 1, 0, 1, 2327.08, -1681.87, 14.93, 0, 0, 0, 466106, 0, 0, 0, 0, 0, 'Jotvingiø', 16, 'ls'),
- (20, -1, 1, 0, 1, 2385.52, -1711.8, 14.242, 0, 0, 0, 545768, 0, 0, 0, 0, 0, 'Jotvingiø', 17, 'ls'),
- (21, -1, 1, 0, 1, 2522.46, -2018.92, 14.074, 0, 0, 0, 545768, 0, 0, 0, 0, 0, 'Laisvës', 1, 'ls'),
- (22, -1, 1, 0, 1, 2524.33, -1998.28, 14.113, 0, 0, 0, 466106, 0, 0, 0, 0, 0, 'Laisvës', 2, 'ls'),
- (23, -1, 1, 0, 1, 2507.79, -2021.05, 14.21, 0, 0, 0, 466106, 0, 0, 0, 0, 0, 'Laisvës', 3, 'ls'),
- (24, -1, 1, 0, 1, 2508.21, -1998.53, 13.903, 0, 0, 0, 504782, 0, 0, 0, 0, 0, 'Laisvës', 4, 'ls'),
- (25, -1, 1, 0, 1, 2486.45, -2021.55, 13.999, 0, 0, 0, 544660, 0, 0, 0, 0, 0, 'Laisvës', 5, 'ls'),
- (26, -1, 1, 0, 1, 2465.4, -2020.79, 14.124, 0, 0, 0, 464064, 0, 0, 0, 0, 0, 'Laisvës', 7, 'ls'),
- (27, -1, 1, 0, 1, 2437.92, -2020.84, 13.903, 0, 0, 0, 505413, 0, 0, 0, 0, 0, 'Laisvës', 9, 'ls'),
- (28, -1, 1, 0, 1, 2483.59, -1995.54, 13.834, 0, 0, 0, 540262, 0, 0, 0, 0, 0, 'Laisvës', 6, 'ls'),
- (29, 25, 1, 0, 0, 2465.02, -1995.75, 14.019, 0, 0, 0, 502568, 0, 0, 0, 0, 0, 'Laisvës', 8, 'ls'),
- (30, -1, 1, 0, 1, 2637.16, -1991.63, 14.324, 0, 0, 0, 466013, 0, 0, 0, 0, 0, 'Naujakuriø', 1, 'ls'),
- (31, -1, 1, 0, 1, 2635.51, -2012.77, 14.144, 0, 0, 0, 512437, 0, 0, 0, 0, 0, 'Naujakuriø', 2, 'ls'),
- (32, -1, 1, 0, 1, 2652.77, -1989.45, 13.999, 0, 0, 0, 519659, 0, 0, 0, 0, 0, 'Naujakuriø', 3, 'ls'),
- (33, -1, 1, 0, 1, 2672.8, -1989.47, 14.324, 0, 0, 0, 502551, 0, 0, 0, 0, 0, 'Naujakuriø', 5, 'ls'),
- (34, -1, 1, 0, 1, 2696.55, -1990.5, 14.223, 0, 0, 0, 497790, 0, 0, 0, 0, 0, 'Naujakuriø', 7, 'ls'),
- (35, -1, 1, 0, 1, 2650.7, -2021.92, 14.177, 0, 0, 0, 544213, 0, 0, 0, 0, 0, 'Naujakuriø', 4, 'ls'),
- (36, -1, 1, 0, 1, 2673.33, -2020.29, 14.168, 0, 0, 0, 504611, 0, 0, 0, 0, 0, 'Naujakuriø', 6, 'ls'),
- (37, -1, 1, 0, 1, 2695.41, -2020.55, 14.022, 0, 0, 0, 508801, 0, 0, 0, 0, 0, 'Naujakuriø', 8, 'ls'),
- (38, -1, 1, 0, 1, 315.949, -1769.61, 4.628, 0, 0, 0, 630541, 0, 0, 0, 0, 0, 'Uosto', 1, 'ls'),
- (39, -1, 1, 0, 1, 305.424, -1770.26, 4.538, 0, 0, 0, 684645, 0, 0, 0, 0, 0, 'Uosto', 2, 'ls'),
- (40, -1, 1, 0, 1, 295.241, -1764.12, 4.868, 0, 0, 0, 615744, 0, 0, 0, 0, 0, 'Uosto', 3, 'ls'),
- (41, -1, 1, 0, 1, 280.874, -1767.28, 4.551, 0, 0, 0, 676548, 0, 0, 0, 0, 0, 'Uosto', 4, 'ls'),
- (42, -1, 1, 0, 1, 206.794, -1768.9, 4.368, 0, 0, 0, 671021, 0, 0, 0, 0, 0, 'Uosto', 5, 'ls'),
- (43, -1, 1, 0, 1, 192.783, -1769.39, 4.329, 0, 0, 0, 675288, 0, 0, 0, 0, 0, 'Uosto', 6, 'ls'),
- (44, -1, 1, 0, 1, 168.306, -1768.41, 4.487, 0, 0, 0, 634214, 0, 0, 0, 0, 0, 'Uosto', 7, 'ls'),
- (45, -1, 1, 0, 1, 653.594, -1713.88, 14.765, 0, 0, 0, 542231, 0, 0, 0, 0, 0, 'Þvejø', 1, 'ls'),
- (46, -1, 1, 0, 1, 652.666, -1693.97, 14.55, 0, 0, 0, 487059, 0, 0, 0, 0, 0, 'Þvejø', 2, 'ls'),
- (47, -1, 1, 0, 1, 693.545, -1705.72, 3.819, 0, 0, 0, 486809, 0, 0, 0, 0, 0, 'Þvejø', 3, 'ls'),
- (48, -1, 1, 0, 1, 694.883, -1690.73, 4.346, 0, 0, 0, 455158, 0, 0, 0, 0, 0, 'Þvejø', 4, 'ls'),
- (49, -1, 1, 0, 1, 693.758, -1645.88, 4.094, 0, 0, 0, 539935, 0, 0, 0, 0, 0, 'Þvejø', 5, 'ls'),
- (50, -1, 1, 0, 1, 697.28, -1626.96, 3.749, 0, 0, 0, 487434, 0, 0, 0, 0, 0, 'Þvejø', 6, 'ls'),
- (51, -1, 1, 0, 1, 657.226, -1652.67, 15.406, 0, 0, 0, 508370, 0, 0, 0, 0, 0, 'Þvejø', 7, 'ls'),
- (52, -1, 1, 0, 1, 656.089, -1635.87, 15.862, 0, 0, 0, 500724, 0, 0, 0, 0, 0, 'Þvejø', 8, 'ls'),
- (53, -1, 1, 0, 1, 653.112, -1619.83, 15, 0, 0, 0, 495916, 0, 0, 0, 0, 0, 'Þvejø', 9, 'ls'),
- (54, -1, 1, 0, 1, 692.981, -1602.77, 15.047, 0, 0, 0, 483939, 0, 0, 0, 0, 0, 'Þvejø', 10, 'ls'),
- (55, -1, 1, 0, 1, 766.923, -1605.88, 13.804, 0, 0, 0, 469979, 0, 0, 0, 0, 0, 'Þvejø', 11, 'ls'),
- (56, -1, 1, 0, 1, 768.08, -1655.86, 5.609, 0, 0, 0, 538002, 0, 0, 0, 0, 0, 'Þvejø', 12, 'ls'),
- (57, -1, 1, 0, 1, 769.229, -1696.62, 5.155, 0, 0, 0, 536814, 0, 0, 0, 0, 0, 'Þvejø', 13, 'ls'),
- (58, -1, 1, 0, 1, 769.029, -1726.23, 13.432, 0, 0, 0, 472360, 0, 0, 0, 0, 0, 'Þvejø', 14, 'ls'),
- (59, -1, 1, 0, 1, 769.227, -1746.04, 13.077, 0, 0, 0, 483150, 0, 0, 0, 0, 0, 'Þvejø', 15, 'ls'),
- (60, -1, 1, 0, 1, 791.449, -1753.37, 13.457, 0, 0, 0, 509271, 0, 0, 0, 0, 0, 'Þvejø', 16, 'ls'),
- (61, -1, 1, 0, 1, 797.234, -1729.11, 13.547, 0, 0, 0, 538391, 0, 0, 0, 0, 0, 'Þvejø', 17, 'ls'),
- (62, -1, 1, 0, 1, 793.979, -1707.56, 14.038, 0, 0, 0, 527762, 0, 0, 0, 0, 0, 'Þvejø', 18, 'ls'),
- (63, -1, 1, 0, 1, 794.762, -1692.09, 14.463, 0, 0, 0, 460847, 0, 0, 0, 0, 0, 'Þvejø', 19, 'ls'),
- (64, -1, 1, 0, 1, 790.812, -1661.34, 13.484, 0, 0, 0, 482451, 0, 0, 0, 0, 0, 'Þvejø', 20, 'ls'),
- (65, -1, 1, 0, 1, 1421.83, -886.16, 50.684, 0, 0, 0, 1351603, 0, 0, 0, 0, 0, 'Mosëdþio', 1, 'ls'),
- (66, -1, 1, 0, 1, 1468.5, -906.166, 54.836, 0, 0, 0, 1126943, 0, 0, 0, 0, 0, 'Mosëdþio', 2, 'ls'),
- (67, -1, 1, 0, 1, 1535.86, -885.387, 57.657, 0, 0, 0, 1414994, 0, 0, 0, 0, 0, 'Mosëdþio', 3, 'ls'),
- (68, -1, 1, 0, 1, 1540.33, -851.367, 64.336, 0, 0, 0, 1210430, 0, 0, 0, 0, 0, 'Mosëdþio', 4, 'ls'),
- (69, -1, 1, 0, 1, 1535.04, -800.186, 72.849, 0, 0, 0, 1384614, 0, 0, 0, 0, 0, 'Mosëdþio', 5, 'ls'),
- (70, -1, 1, 0, 1, 1527.89, -772.65, 80.578, 0, 0, 0, 1431438, 0, 0, 0, 0, 0, 'Mosëdþio', 6, 'ls'),
- (71, -1, 1, 0, 1, 1298.45, -797.983, 84.141, 0, 0, 0, 1412326, 0, 0, 0, 0, 0, 'Mosëdþio', 7, 'ls'),
- (72, -1, 1, 0, 1, 1093.78, -806.866, 107.42, 0, 0, 0, 1031659, 0, 0, 0, 0, 0, 'Mosëdþio', 8, 'ls'),
- (73, -1, 1, 0, 1, 1034.9, -812.999, 101.852, 0, 0, 0, 1339354, 0, 0, 0, 0, 0, 'Mosëdþio', 9, 'ls'),
- (74, -1, 1, 0, 1, 1017.03, -763.359, 112.563, 0, 0, 0, 1012196, 0, 0, 0, 0, 0, 'Mosëdþio', 10, 'ls'),
- (75, -1, 1, 0, 1, 989.838, -828.637, 95.469, 0, 0, 0, 1087136, 0, 0, 0, 0, 0, 'Mosëdþio', 11, 'ls'),
- (76, -1, 1, 0, 1, 937.822, -848.476, 93.611, 0, 0, 0, 1355025, 0, 0, 0, 0, 0, 'Mosëdþio', 12, 'ls'),
- (77, -1, 1, 0, 1, 910.427, -817.522, 103.126, 0, 0, 0, 1026123, 0, 0, 0, 0, 0, 'Mosëdþio', 13, 'ls'),
- (78, -1, 1, 0, 1, 923.939, -853.232, 93.457, 0, 0, 0, 1088622, 0, 0, 0, 0, 0, 'Mosëdþio', 14, 'ls'),
- (79, -1, 1, 0, 1, 836.171, -894.791, 68.769, 0, 0, 0, 1206596, 0, 0, 0, 0, 0, 'Mosëdþio', 15, 'ls'),
- (80, -1, 1, 0, 1, 827.943, -857.943, 70.331, 0, 0, 0, 1124618, 0, 0, 0, 0, 0, 'Mosëdþio', 16, 'ls'),
- (81, -1, 1, 0, 1, 1442.66, -629.098, 95.719, 0, 0, 0, 1239413, 0, 0, 0, 0, 0, 'Eidintø', 1, 'ls'),
- (82, 14, 1, 0, 0, 1332.07, -633.317, 109.135, 0, 0, 0, 1057146, 0, 0, 0, 0, 0, 'Eidintø', 2, 'ls'),
- (83, -1, 1, 0, 1, 1095.09, -647.915, 113.648, 0, 0, 0, 1421163, 0, 0, 0, 0, 0, 'Eidintø', 3, 'ls'),
- (84, -1, 1, 0, 1, 1045.18, -642.936, 120.117, 0, 0, 0, 1003870, 0, 0, 0, 0, 0, 'Eidintø', 4, 'ls'),
- (85, -1, 1, 0, 1, 980.449, -677.28, 121.976, 0, 0, 0, 1323132, 0, 0, 0, 0, 0, 'Eidintø', 5, 'ls'),
- (86, -1, 1, 0, 1, 946.27, -710.719, 122.62, 0, 0, 0, 1397065, 0, 0, 0, 0, 0, 'Eidintø', 6, 'ls'),
- (87, -1, 1, 0, 1, 898.597, -676.528, 116.89, 0, 0, 0, 1298028, 0, 0, 0, 0, 0, 'Eidintø', 7, 'ls'),
- (88, -1, 1, 0, 1, 977.295, -771.709, 112.203, 0, 0, 0, 1230772, 0, 0, 0, 0, 0, 'Eidintø', 8, 'ls'),
- (89, -1, 1, 0, 1, 891.177, -783.16, 101.314, 0, 0, 0, 1475357, 0, 0, 0, 0, 0, 'Eidintø', 9, 'ls'),
- (90, -1, 1, 0, 1, 867.548, -717.605, 105.68, 0, 0, 0, 1335953, 0, 0, 0, 0, 0, 'Eidintø', 10, 'ls'),
- (91, -1, 1, 0, 1, 847.961, -745.474, 94.969, 0, 0, 0, 1338475, 0, 0, 0, 0, 0, 'Eidintø', 11, 'ls'),
- (92, -1, 1, 0, 1, 808.285, -759.464, 76.531, 0, 0, 0, 1044932, 0, 0, 0, 0, 0, 'Eidintø', 12, 'ls'),
- (93, -1, 1, 0, 1, 785.98, -828.58, 70.29, 0, 0, 0, 1028794, 0, 0, 0, 0, 0, 'Eidintø', 13, 'ls'),
- (94, -1, 1, 0, 1, 724.689, -999.371, 52.734, 0, 0, 0, 1258596, 0, 0, 0, 0, 0, 'Girios', 1, 'ls'),
- (95, -1, 1, 0, 1, 672.791, -1020.74, 55.76, 0, 0, 0, 1312005, 0, 0, 0, 0, 0, 'Girios', 2, 'ls'),
- (96, -1, 1, 0, 1, 700.25, -1060.34, 49.422, 0, 0, 0, 1192582, 0, 0, 0, 0, 0, 'Girios', 3, 'ls'),
- (97, -1, 1, 0, 1, 648.076, -1059, 52.58, 0, 0, 0, 1078935, 0, 0, 0, 0, 0, 'Girios', 4, 'ls'),
- (98, -1, 1, 0, 1, 646.026, -1117.38, 44.207, 0, 0, 0, 1380854, 0, 0, 0, 0, 0, 'Girios', 5, 'ls'),
- (99, -1, 1, 0, 1, 612.137, -1085.94, 58.827, 0, 0, 0, 1201493, 0, 0, 0, 0, 0, 'Girios', 6, 'ls'),
- (100, -1, 1, 0, 1, 553.032, -1200.25, 44.832, 0, 0, 0, 1317091, 0, 0, 0, 0, 0, 'Girios', 7, 'ls'),
- (101, -1, 1, 0, 1, 432.122, -1253.93, 51.581, 0, 0, 0, 1291030, 0, 0, 0, 0, 0, 'Girios', 8, 'ls'),
- (102, -1, 1, 0, 1, 397.983, -1271.45, 50.02, 0, 0, 0, 1072223, 0, 0, 0, 0, 0, 'Girios', 9, 'ls'),
- (103, -1, 1, 0, 1, 355.235, -1281.11, 53.704, 0, 0, 0, 1350877, 0, 0, 0, 0, 0, 'Girios', 10, 'ls'),
- (109, -1, 1, 0, 1, 298.629, -1338.41, 53.441, 0, 0, 0, 1161805, 0, 0, 0, 0, 0, 'Girios', 12, 'ls'),
- (110, -1, 1, 0, 1, 254.56, -1366.97, 53.109, 0, 0, 0, 1137254, 0, 0, 0, 0, 0, 'Girios', 13, 'ls'),
- (111, -1, 1, 0, 1, 227.969, -1405.44, 51.609, 0, 0, 0, 1251448, 0, 0, 0, 0, 0, 'Girios', 14, 'ls'),
- (112, -1, 1, 0, 1, 189.64, -1308.28, 70.249, 0, 0, 0, 1387716, 0, 0, 0, 0, 0, 'Girios', 15, 'ls'),
- (113, -1, 1, 0, 1, 580.637, -1149.7, 53.18, 0, 0, 0, 1137893, 0, 0, 0, 0, 0, 'Girios', 16, 'ls'),
- (114, -1, 1, 0, 1, 558.907, -1161.01, 54.43, 0, 0, 0, 1281940, 0, 0, 0, 0, 0, 'Girios', 18, 'ls'),
- (115, -1, 1, 0, 1, 534.966, -1173.74, 58.81, 0, 0, 0, 1298151, 0, 0, 0, 0, 0, 'Girios', 19, 'ls'),
- (116, -1, 1, 0, 1, 470.868, -1163.92, 67.215, 0, 0, 0, 1032119, 0, 0, 0, 0, 0, 'Girios', 17, 'ls'),
- (117, -1, 1, 0, 1, 416.775, -1154.13, 76.688, 0, 0, 0, 1007701, 0, 0, 0, 0, 0, 'Girios', 20, 'ls'),
- (118, -1, 1, 0, 1, 352.395, -1197.94, 76.516, 0, 0, 0, 1258835, 0, 0, 0, 0, 0, 'Girios', 21, 'ls'),
- (119, -1, 1, 0, 1, 300.234, -1154.45, 81.389, 0, 0, 0, 1018177, 0, 0, 0, 0, 0, 'Girios', 22, 'ls'),
- (120, -1, 1, 0, 1, 251.353, -1220.27, 76.102, 0, 0, 0, 1124568, 0, 0, 0, 0, 0, 'Girios', 23, 'ls'),
- (121, -1, 1, 0, 1, 253.247, -1269.97, 74.429, 0, 0, 0, 1446538, 0, 0, 0, 0, 0, 'Girios', 24, 'ls'),
- (122, -1, 1, 0, 1, 219.216, -1249.82, 78.337, 0, 0, 0, 1346442, 0, 0, 0, 0, 0, 'Girios', 25, 'ls'),
- (123, -1, 1, 0, 1, 161.608, -1455.74, 32.845, 0, 0, 0, 1177543, 0, 0, 0, 0, 0, 'Girios', 26, 'ls'),
- (124, -1, 1, 0, 1, 142.578, -1470.14, 25.211, 0, 0, 0, 1059774, 0, 0, 0, 0, 0, 'Girios', 27, 'ls'),
- (125, -1, 1, 0, 1, 1112.24, -742.078, 100.133, 0, 0, 0, 1354047, 0, 0, 0, 0, 0, 'Girios', 28, 'ls'),
- (126, -1, 1, 0, 1, 2326.78, -1716.71, 14.238, 0, 0, 0, 469557, 0, 0, 0, 0, 0, 'Jotvingiø', 18, 'ls'),
- (127, -1, 1, 0, 1, 2308.87, -1714.33, 14.98, 0, 0, 0, 502631, 0, 0, 0, 0, 0, 'Jotvingiø', 19, 'ls'),
- (128, -1, 1, 0, 1, 2306.94, -1679.07, 14.332, 0, 0, 0, 506341, 0, 0, 0, 0, 0, 'Jotvingiø', 20, 'ls'),
- (129, -1, 1, 0, 1, 2282.31, -1641.38, 15.89, 0, 0, 0, 464442, 0, 0, 0, 0, 0, 'Jotvingiø', 21, 'ls'),
- (130, -1, 1, 0, 1, 2257.27, -1643.97, 15.808, 0, 0, 0, 455940, 0, 0, 0, 0, 0, 'Jotvingiø', 22, 'ls'),
- (131, -1, 1, 0, 1, 2244.41, -1637.61, 16.238, 0, 0, 0, 460427, 0, 0, 0, 0, 0, 'Jotvingiø', 23, 'ls');
- -- --------------------------------------------------------
- --
- -- Sukurta duomenų struktūra lentelei `mapicons`
- --
- CREATE TABLE IF NOT EXISTS `mapicons` (
- `mi_ID` int(11) NOT NULL AUTO_INCREMENT,
- `mi_Name` varchar(30) NOT NULL,
- `mi_PosX` float NOT NULL,
- `mi_PosY` float NOT NULL,
- `mi_PosZ` float NOT NULL,
- `mi_Type` int(2) NOT NULL,
- `mi_VW` int(11) NOT NULL,
- `mi_Interior` int(11) NOT NULL,
- `mi_Streamdistance` float NOT NULL,
- `mi_Show` int(1) NOT NULL,
- `mi_Map` varchar(3) NOT NULL,
- PRIMARY KEY (`mi_ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;
- --
- -- Sukurta duomenų kopija lentelei `mapicons`
- --
- INSERT INTO `mapicons` (`mi_ID`, `mi_Name`, `mi_PosX`, `mi_PosY`, `mi_PosZ`, `mi_Type`, `mi_VW`, `mi_Interior`, `mi_Streamdistance`, `mi_Show`, `mi_Map`) VALUES
- (1, 'Bankas', 1734.84, -1266.76, 13.543, 52, 0, 0, 2000, 0, 'ls'),
- (2, 'Idlewood parduotuve', 2129.81, -1761.15, 13.5625, 38, 0, 0, 2000, 0, 'ls'),
- (3, 'Ganton parduotuve', 2423.66, -1742.44, 13.5469, 38, 0, 0, 2000, 0, 'ls'),
- (4, 'East Beach parduotuve', 2751.63, -1468.24, 30.4531, 38, 0, 0, 2000, 0, 'ls'),
- (5, 'Jefferson parduotuve', 2139.72, -1191.97, 23.9922, 38, 0, 0, 2000, 0, 'ls'),
- (6, 'Downtown parduotuve', 1582.35, -1170.37, 24.0781, 38, 0, 0, 2000, 0, 'ls'),
- (8, 'LSPD', 1531.41, -1674.8, 13.3828, 30, 0, 0, 2000, 0, 'ls'),
- (9, 'LSMD', 1995.36, -1452.89, 13.5547, 22, 0, 0, 2000, 0, 'ls'),
- (16, 'Tiuningas', 1024.63, -1033.07, 31.841, 27, 0, 0, 2000, 0, 'ls'),
- (18, 'Garažas1', 1189.95, -1013.27, 32.547, 55, 0, 0, 2000, 0, 'ls'),
- (19, 'Orouostas', 1923.74, -2409.43, 13.539, 5, 0, 0, 2000, 0, 'ls'),
- (20, 'Tune SF (WAA)', -2690.47, 210.164, 4.328, 27, 0, 0, 2000, 0, 'ls'),
- (21, 'MocoMisija', 1360.95, -1659.3, 14.766, 33, 0, 0, 2000, 1, 'ls'),
- (22, 'Vieðbutis', 1653.95, -1656.31, 22.516, 31, 0, 0, 2000, 1, 'ls'),
- (23, 'KM-Bankas', 2313.42, -6.787, 26.485, 52, 0, 0, 1000, 1, 'km'),
- (24, 'Daugiabuèiai1', 2440.75, 21.639, 26.459, 31, 0, 0, 1000, 1, 'km'),
- (25, 'Picerija', 1365.73, 250.772, 19.388, 29, 0, 0, 1000, 1, 'km'),
- (26, 'race', -490.514, -211.25, 79.497, 53, 0, 0, 1000, 1, 'km'),
- (27, 'picerija-bb', 212.533, -202.515, 1.578, 29, 0, 0, 1000, 1, 'km'),
- (28, 'dill_deg', 699.959, -565.85, 16.329, 24, 0, 0, 1000, 1, 'km'),
- (29, 'dill_deg2', 655.615, -564.964, 16.336, 24, 0, 0, 1000, 1, 'km'),
- (30, 'daugiabutis2', 2498.12, 76.107, 26.459, 31, 0, 0, 1000, 1, 'km'),
- (31, 'medprek', 2242.61, 52.725, 26.667, 21, 0, 0, 1000, 1, 'km');
- -- --------------------------------------------------------
- --
- -- Sukurta duomenų struktūra lentelei `objects`
- --
- CREATE TABLE IF NOT EXISTS `objects` (
- `ID` int(11) NOT NULL AUTO_INCREMENT,
- `Model` int(11) NOT NULL,
- `X` float NOT NULL,
- `Y` float NOT NULL,
- `Z` float NOT NULL,
- `rX` float NOT NULL,
- `rY` float NOT NULL,
- `rZ` float NOT NULL,
- `Int` int(11) NOT NULL,
- `vw` int(11) NOT NULL,
- `e1` int(11) NOT NULL COMMENT 'none, vehicle, player etc',
- `e2` int(11) NOT NULL COMMENT 'none, vehSQL, plrSQL, etc',
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Sukurta duomenų struktūra lentelei `offmsg`
- --
- CREATE TABLE IF NOT EXISTS `offmsg` (
- `ID` int(11) NOT NULL AUTO_INCREMENT,
- `Type` int(1) NOT NULL,
- `GiverID` int(6) NOT NULL,
- `SenderID` int(6) NOT NULL,
- `Msg` varchar(120) NOT NULL,
- `Time` int(11) NOT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- -- --------------------------------------------------------
- --
- -- Sukurta duomenų struktūra lentelei `playeritems`
- --
- CREATE TABLE IF NOT EXISTS `playeritems` (
- `i_ID` int(11) NOT NULL AUTO_INCREMENT,
- `i_Type` int(1) NOT NULL,
- `i_Owner` int(11) NOT NULL,
- `i_ItemID` int(11) NOT NULL,
- `i_Quantity` int(11) NOT NULL,
- `i_Price` int(11) NOT NULL,
- `i_Show` int(1) NOT NULL,
- `i_Extra0` int(11) NOT NULL,
- `i_Extra1` int(11) NOT NULL,
- `i_Extra2` int(11) NOT NULL,
- `i_Extra3` float NOT NULL,
- `i_Extra4` int(1) NOT NULL,
- `i_Weight` float NOT NULL,
- PRIMARY KEY (`i_ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;
- --
- -- Sukurta duomenų kopija lentelei `playeritems`
- --
- INSERT INTO `playeritems` (`i_ID`, `i_Type`, `i_Owner`, `i_ItemID`, `i_Quantity`, `i_Price`, `i_Show`, `i_Extra0`, `i_Extra1`, `i_Extra2`, `i_Extra3`, `i_Extra4`, `i_Weight`) VALUES
- (1, 1, 14, 4, 1, 0, 0, 11, 82, 0, 0, 0, 0),
- (2, 1, 15, 4, 1, 0, 0, 11, 16, 0, 0, 0, 0),
- (3, 3, 2, 6, 2383, 2, 1, 0, 0, 0, 0, 0, 0),
- (4, 3, 1, 2881, 2552, 3, 1, 0, 0, 0, 0, 0, 0),
- (5, 1, 15, 4, 1, 0, 0, 11, 8, 0, 0, 0, 0),
- (6, 1, 15, 7, 1, 0, 0, 0, 0, 0, 0, 1, 0),
- (7, 1, 14, 7, 1, 0, 0, 0, 0, 0, 0, 1, 0),
- (8, 1, 25, 4, 1, 0, 0, 11, 29, 0, 0, 0, 0),
- (9, 3, 3, 11738, 2322, 50, 1, 0, 0, 0, 0, 0, 0),
- (10, 3, 3, 11736, 2530, 15, 1, 0, 0, 0, 0, 0, 0),
- (11, 3, 3, 19570, 2159, 10, 1, 0, 0, 0, 0, 0, 0),
- (12, 6, 7, 11738, 50, 5, 0, 0, 0, 0, 0, 0, 0);
- -- --------------------------------------------------------
- --
- -- Sukurta duomenų struktūra lentelei `players`
- --
- CREATE TABLE IF NOT EXISTS `players` (
- `pID` int(11) NOT NULL AUTO_INCREMENT,
- `pName` varchar(24) NOT NULL,
- `pPass` varchar(130) NOT NULL,
- `pRegTime` int(20) NOT NULL,
- `pRegIP` varchar(17) NOT NULL,
- `pLastIP` varchar(17) NOT NULL,
- `pLastTime` int(20) NOT NULL,
- `vvpPass` varchar(150) CHARACTER SET utf8 COLLATE utf8_lithuanian_ci NOT NULL,
- `vvpActive` varchar(255) NOT NULL,
- `pEmail` varchar(100) NOT NULL,
- `pPosX` float NOT NULL,
- `pPosY` float NOT NULL,
- `pPosZ` float NOT NULL,
- `pPosA` float NOT NULL,
- `pDrabuziai` int(3) NOT NULL,
- `pMoney` int(11) NOT NULL,
- `pScore` int(11) NOT NULL,
- `pAdmin` int(1) NOT NULL,
- `pAod` int(1) NOT NULL,
- `pVip` int(1) NOT NULL,
- `pContract` int(11) NOT NULL,
- `pJobSkin` int(3) NOT NULL,
- `pGangID` int(2) NOT NULL,
- `pGangSkin` int(1) NOT NULL,
- `pGangSkinID` int(3) NOT NULL,
- `pGangLead` int(11) NOT NULL,
- `pJobID` int(2) NOT NULL,
- `pJobSkinID` int(3) NOT NULL,
- `pJobLead` int(2) NOT NULL,
- `pJobDeputy` int(3) NOT NULL,
- `pInterior` int(4) NOT NULL,
- `pVW` int(11) NOT NULL,
- `pBankoSaskaita` int(11) NOT NULL,
- `pBMoney` int(11) NOT NULL,
- `pRangas` int(2) NOT NULL,
- `pGRangas` int(11) NOT NULL,
- `pWanted` int(5) NOT NULL,
- `pBauda` int(11) NOT NULL,
- `pJailed` int(1) NOT NULL,
- `pCuff` int(1) NOT NULL,
- `pLevel` int(11) NOT NULL,
- `pMask` int(1) NOT NULL,
- `pOnline` int(1) NOT NULL,
- `pGender` int(1) NOT NULL,
- `pApmokymuStep` int(3) NOT NULL,
- `pGuns` varchar(100) NOT NULL,
- `pGunLic` int(1) NOT NULL,
- `pCanLogin` int(11) NOT NULL,
- `pCanLoginReason` varchar(50) NOT NULL,
- `pCanLoginType` int(1) NOT NULL,
- `pLastRaceTime` int(11) NOT NULL,
- `pTimeSpent` int(11) NOT NULL,
- `pAlga` int(11) NOT NULL,
- `pMuted` int(11) NOT NULL,
- `pDead` int(1) NOT NULL,
- `pDviratis` int(1) NOT NULL,
- `pDviratisX` float NOT NULL,
- `pDviratisY` float NOT NULL,
- `pDviratisZ` float NOT NULL,
- `pSettings` varchar(20) NOT NULL,
- `pLastTimeTakeGun` int(11) NOT NULL,
- `pLastTimeEgun` int(11) NOT NULL,
- `pNamuose` int(11) NOT NULL,
- `pBankPin` int(4) NOT NULL,
- PRIMARY KEY (`pID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=55 ;
- --
- -- Sukurta duomenų kopija lentelei `players`
- --
- INSERT INTO `players` (`pID`, `pName`, `pPass`, `pRegTime`, `pRegIP`, `pLastIP`, `pLastTime`, `vvpPass`, `vvpActive`, `pEmail`, `pPosX`, `pPosY`, `pPosZ`, `pPosA`, `pDrabuziai`, `pMoney`, `pScore`, `pAdmin`, `pAod`, `pVip`, `pContract`, `pJobSkin`, `pGangID`, `pGangSkin`, `pGangSkinID`, `pGangLead`, `pJobID`, `pJobSkinID`, `pJobLead`, `pJobDeputy`, `pInterior`, `pVW`, `pBankoSaskaita`, `pBMoney`, `pRangas`, `pGRangas`, `pWanted`, `pBauda`, `pJailed`, `pCuff`, `pLevel`, `pMask`, `pOnline`, `pGender`, `pApmokymuStep`, `pGuns`, `pGunLic`, `pCanLogin`, `pCanLoginReason`, `pCanLoginType`, `pLastRaceTime`, `pTimeSpent`, `pAlga`, `pMuted`, `pDead`, `pDviratis`, `pDviratisX`, `pDviratisY`, `pDviratisZ`, `pSettings`, `pLastTimeTakeGun`, `pLastTimeEgun`, `pNamuose`, `pBankPin`) VALUES
- (14, 'Yawas', 'asdasd', 0, '', '', 1468668311, '', '', 'asd@asd.lt', 1955.51, -1205.35, 17.532, 125.277, 7, 50000, 200, 2, 0, 0, 1456331887, 0, 2, 0, 0, 2, 5, 0, 1, 0, 0, 0, 1, 3172, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 5, '0 0 0 0 24 50100 25 50000 32 5000050 30 10015 0 0 38 1849258976 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 1468571601, 42570, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 1234),
- (23, 'Aine_Sportt', '864225821', 1454771884, '78.63.21.18', '', 1454772144, '', '', 'ainorasp@gmail.com', 1489.91, -1765.49, 14.381, 311.428, 22, 10246, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 0, 227, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
- (25, 'John_Elite', '123456', 1468170631, '78.63.97.210', '', 1469045289, '', '', 'asdasd@gmail.com', -429.747, -1729.6, 2089.01, 349.93, 7, -20, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 5, 0, 0, 0, 69, 0, 1, 62804107, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, '21 1 0 0 24 101 25 101 32 5000000 0 0 34 1 0 0 0 0 0 0 15 1 0 0 0 0', 0, 0, '', 0, 0, 17157, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 1234),
- (29, 'John_Elites', '123456', 1468354011, '78.63.97.210', '', 1468355075, '', '', 'asdasdsd@gmail.com', 1342.38, -1622.78, 17.734, 356.428, 93, 1500, 0, 0, 0, 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, 3, '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 0, 971, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
- (39, 'dovydas', 'asdasd', 1468408988, '127.0.0.1', '', 1468409436, '', '', '', 1276.93, -1544.35, 13.547, 338.271, 20, 10770, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 1468409060, 172, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
- (40, 'Test', 'asdasd', 1468409882, '127.0.0.1', '', 0, '', '', '', 1341.93, -1662.85, 17.7266, 0, 7, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0),
- (41, 'Testasa', 'sadasd', 1468410725, '127.0.0.1', '', 1468410838, '', '', '', 1356.89, -1668.46, 13.608, 67.681, 22, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 0, 19, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
- (42, 'Testasakiu', 'asdasd', 1468411270, '127.0.0.1', '', 0, '', '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 2, '', 0, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0),
- (43, 'askbsdkbd', 'asdasd', 1468411558, '127.0.0.1', '', 1468411594, '', '', '', 1341.84, -1681.88, 17.719, 180.458, 7, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 0, 6, 0, 0, 0, 1, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
- (44, 'Sudas_Susas', '123456', 1468423951, '78.63.97.210', '', 0, '', '', 'asdasd@gmail.com', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 0),
- (45, 'Pimpalasas', '123456', 1468424191, '78.63.97.210', '', 0, '', '', 'asdasd@gmail.com', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 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, 0),
- (46, 'tasdasd', 'asdasd', 1468424201, '127.0.0.1', '', 1468429663, '', '', '', 1348.98, -1681.7, 13.604, 341.139, 7, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 0, 2111, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
- (47, 'Tuduchas', '123456', 1468424581, '78.63.97.210', '', 1468425360, '', '', '', 1785.98, -1393.6, 15.758, 25.295, 7, 1493, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 4, '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 1468424805, 683, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
- (48, 'TESTASDA', 'asdasd', 1468429802, '127.0.0.1', '', 1468432832, '', '', '', 1422.43, -1317.68, 13.555, 26.634, 7, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 0, 1111, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
- (49, 'asdffghjkl', 'asdasd', 1468440517, '127.0.0.1', '', 1468440688, '', '', '', 1343.59, -1680.37, 13.585, 133.458, 20, 10000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 0, 153, 0, 0, 0, 1, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
- (50, 'Memius', '123456', 1468445361, '78.63.97.210', '', 1468445532, '', '', '', 1886.36, -1757.08, 13.179, 245.247, 7, 1500, 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, 3, '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 0, 150, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
- (51, 'John_Juske', '147852', 1468587312, '86.38.226.143', '', 1468946360, '', '', '14725a@gmail.com', 639.024, -531.624, 15.915, 251.632, 7, 1500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 0, 5252, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
- (52, 'Pimpis', '123456', 1468592611, '78.63.97.210', '', 1468594003, '', '', '', -1036.42, -591.987, 32.2, 132.977, 20, 1500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 0, 1262, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
- (53, 'Yawukas', 'asdasd', 1468672971, '127.0.0.1', '', 1470558939, '', '', '', -427.408, -1727.97, 2244.36, 251.825, 22, 6380, 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 69, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 3, '21 500000 6 500000 22 500000 25 500000 29 500000 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 0, 35125, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0),
- (54, 'Andrew_Extazy', 'tavomama', 1468701418, '78.58.49.91', '', 1468703126, '', '', 'tavomama@tavomama.com', 1372.42, 287.818, 19.112, 81.078, 7, 1500, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 3, '0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0', 0, 0, '', 0, 0, 825, 0, 0, 0, 0, 0, 0, 0, '1 1 1', 0, 0, 0, 0);
- -- --------------------------------------------------------
- --
- -- Sukurta duomenų struktūra lentelei `rangai`
- --
- CREATE TABLE IF NOT EXISTS `rangai` (
- `rang_ID` int(5) NOT NULL AUTO_INCREMENT,
- `rang_Name` varchar(50) NOT NULL,
- `rang_IDinJob` int(5) NOT NULL,
- `rang_JobID` int(5) NOT NULL,
- `rang_SkinVID` int(3) NOT NULL,
- `rang_SkinMID` int(3) NOT NULL,
- PRIMARY KEY (`rang_ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
- --
- -- Sukurta duomenų kopija lentelei `rangai`
- --
- INSERT INTO `rangai` (`rang_ID`, `rang_Name`, `rang_IDinJob`, `rang_JobID`, `rang_SkinVID`, `rang_SkinMID`) VALUES
- (1, 'Abrikosai', 1, 2, 0, 0);
- -- --------------------------------------------------------
- --
- -- Sukurta duomenų struktūra lentelei `vehicles`
- --
- CREATE TABLE IF NOT EXISTS `vehicles` (
- `vID` int(11) NOT NULL AUTO_INCREMENT,
- `vOwnerType` int(1) NOT NULL,
- `vOwnerID` int(11) NOT NULL,
- `vModel` int(3) NOT NULL,
- `vPosX` float NOT NULL,
- `vPosY` float NOT NULL,
- `vPosZ` float NOT NULL,
- `vPosA` float NOT NULL,
- `vHealth` float NOT NULL,
- `vFuel` float NOT NULL,
- `vFuelType` int(1) NOT NULL,
- `vRida` float NOT NULL,
- `vEngine` int(1) NOT NULL,
- `vLights` int(1) NOT NULL,
- `vAlarm` int(1) NOT NULL,
- `vBonnet` int(1) NOT NULL,
- `vBoot` int(1) NOT NULL,
- `vObjective` int(1) NOT NULL,
- `vLocked` int(1) NOT NULL,
- `vColor1` int(3) NOT NULL,
- `vColor2` int(3) NOT NULL,
- `vPaintjob` int(1) NOT NULL,
- `vMods` varchar(70) NOT NULL,
- `vRangas` int(5) NOT NULL,
- `vPanelsDamage` int(11) NOT NULL,
- `vDoorsDamage` int(11) NOT NULL,
- `vLightsDamage` int(11) NOT NULL,
- `vTiresDamage` int(11) NOT NULL,
- `vUp_Speed` float NOT NULL,
- `vUp_Brake` float NOT NULL,
- PRIMARY KEY (`vID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
- /*!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 */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement