Jump to content

EquiNoxAdv

V.I.P
  • Posts

    720
  • Joined

  • Last visited

  • Days Won

    35

Posts posted by EquiNoxAdv

  1. Faci in felul urmator :D

    forward	ComandaTimer();
    
    //--------- Comanda Exepmlu
    CMD:comanda(playerid, params[]) 
    {
    	if(IsPlayerConnected(playerid))
    	{
    		SendClientMessage(playerid, -1, "Comanda va fi executata in 5 secunde");
    		SetTimer("ComandaTimer", 500 * 10, 0);
    	}
    	return 1;
    }
    //-- Si dupa adaugi
    
    public ComandaTimer()
    {
    	//Comanda....
    	}
    	return 1;
    }

     

    • Upvote 1
  2. @Adrian Petre este gresit cum ai spus tu.

    Poti face in felul urmator.

    Te duci la 

    stock DestroyPlayerVehicle

    Si mai jos adaugi 

    mysql_format(handle,szMessage, 256,"UPDATE playeraccounts SET playerCar1Days = 0 WHERE playerID = %d", playerVariables[playerid][pInternalID]);

    Asta este pentru masina de pe Slot-ul 1. Pentru restu iei model si faci cum ti-am zis.

    • Upvote 1
  3. Comenzi ascunse? Parola de la phpmyadmin? Taci ba ...

    Foloseste sql-injection, de care @Jimmi nu are protective.

    KnowN , eu i-am zis ce s-ar putea sa fie , comanda aia nu este vulnerabila. Poate are alte comenzi , nu stiu , el s-a jucat pe acolo.

  4. Nu cred ca este posibila chestia asta. Ori are ala parola de la phpmyadmin , ori ai tu comenzi ascunse in gamemode si nu sti , ori are parola de la contul tau.  Comanda aia am analizat-o si nu are vulnerabilitate SQL. Verifica ce ti-am spus mai sus , si pune log-uri pe comenzi.

  5. Incearca asta.

     

    CMD:hwithdraw(playerid, params[]) {
    	new
    	    houseID = getPlayerHouseID(playerid); // So we don't have to loop every single time... It's worth the 4 bytes!
    
    	if(getPlayerHouseID(playerid) >= 1) {
    	    if(GetPlayerVirtualWorld(playerid) == HOUSE_VIRTUAL_WORLD+houseID) {
    			new
    			    amount,
    
    			    houseOperation[72]; // For formatting afterwards.
    
    			if(sscanf(params, "s[32]d", houseOperation, amount))
    			    return SendClientMessage(playerid, COLOR_GREY, SYNTAX_MESSAGE"/hwithdraw [mone] [amount]");
    
    		    if(!strcmp(houseOperation, "money", true)) {
    		        if(houseVariables[houseID][hMoney] >= amount) {
    		            if(amount >= 1 && amount < 60000000) {
    		                houseVariables[houseID][hMoney] -= amount;
    		                playerVariables[playerid][pMoney] += amount;
    
    		                if(houseVariables[houseID][hMoney] < 1)
    							houseVariables[houseID][hMoney] = 0;
    
    		                if(playerVariables[playerid][pMoney] < 1)
    							playerVariables[playerid][pMoney] = 0;
    
    		                format(houseOperation, sizeof(houseOperation), "You have withdrawn $%d from your safe.", amount);
    		                SendClientMessage(playerid, COLOR_WHITE, houseOperation);
    
    						GetPlayerName(playerid, szPlayerName, MAX_PLAYER_NAME);
    						format(houseOperation, sizeof(houseOperation), "* %s withdraws $%d from their safe.", szPlayerName, amount);
    						nearByMessage(playerid, COLOR_PURPLE, houseOperation);
    		            }
    					else {
    						SendClientMessage(playerid, COLOR_GREY, "You can't withdraw a negative amount from a house safe. (01x03)");
    						printf("[error] 01x03, %d", playerid);
    					}
    		        }
    		    }
    		    else {
    				return SendClientMessage(playerid, COLOR_GREY, SYNTAX_MESSAGE"/hwithdraw [money/materials] [amount]");
    			}
    		}
        }
        else {
    		return SendClientMessage(playerid, COLOR_GREY, "You're not inside your house.");
    	}
    	return 1;
    }

     

  6. 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 */;

  7. Drifter , Ciorditor , Mecanic (Fa-l mai interesant stiu ca poti :P ) , Constructor - Incearca sa interactionezi cu obiectele. s.a.m.d , sunt multe , doar ca trebuie sa le `lingusesti` nitel ;) 

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.