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