Jump to content
  • 0

[PROBLEMA]Register

CozminKenny

Asked by CozminKenny,

 Share

Question

7 answers to this question

Recommended Posts

  • 0
Punct. Proficient

Punct.

Posted
Posted

Da:

1. Ce gamemode folosesti?

2. Posteaza OnPlayerRegister / OnPlayerLogIn ( sau cum le ai 'tu' in gamemode )

Nu mai deschideti in pu*a mea servere de SA:MP !

Jucati-va pe cele care sunt !   Sunt suficiente !

Reguli de bun simt:

1. Nu faceti reclama unde nu trebuie !

2. Nu injurati ca la usa cortului !

3. Daca esti analfabeti, taci din gura !

4. Nu abuza de 'scuze', 'din greseala' !

 

My work ::: http://pastebin.com/VRNRcaAs

Link to comment
Share on other sites
  • 0
MeNyX Collaborator

MeNyX

Posted
Posted

Este MySQL ?

Y!M: menyx.official

Skype: menyx.official

 

 

Inainte de a critica o persoana indiferent de etnie/varsta/inteligenta ei uita-te la tine si nu uita ca toti suntem Oameni si ca nu are sens sa incerci sa pari diferit!Daca esti mai prost/destept decat cel scos/aflat in discutie incearca sa nu faci pe "MR. Inteligent" TACI si FACI!

Respecta membrii acestei comunitati daca ai pretentia sa fi respectat si tratat(a) ca pe o fiinta umana!

 

Nu fac nimic remarcabil, dar ceea ce fac este esenţial.•

 

Link to comment
Share on other sites
  • 0
CozminKenny Rookie

CozminKenny

Posted
  • Author
Posted (edited)

Gamemode-ul lui Equinox, rRaport edit.

Si da, este pe MySQL .

 
				new tmppass[64];
				strmid(tmppass, inputtext, 0, sizeof ( tmppass ), 255);
				OnPlayerLogin(playerid,tmppass);
			}
			else
			{
				new loginstring[128];
				new loginname[64];
				GetPlayerName(playerid,loginname,sizeof(loginname));
				format(loginstring,sizeof(loginstring),"PAROLA GRESITAnTe Rog Baga Parola Corecta:",loginname);
				ShowPlayerDialog(playerid,12347,DIALOG_STYLE_PASSWORD,"Login",loginstring,"Login","Exit");
				gPlayerLogTries[playerid] += 1;
				if(gPlayerLogTries[playerid] == 3) { Kick(playerid); }
			}
		}
		else
		{
			new loginstring[128];
			new loginname[64];
			GetPlayerName(playerid,loginname,sizeof(loginname));
			format(loginstring,sizeof(loginstring),"PAROLA GRESITAnTe Rog Baga Parola Corecta:",loginname);
			ShowPlayerDialog(playerid,12347,DIALOG_STYLE_PASSWORD,"Login",loginstring,"Login","Exit");
			gPlayerLogTries[playerid] += 1;
			if(gPlayerLogTries[playerid] == 3) { Kick(playerid); }

		}
	}
	if(dialogid == 12345)
	{
		if(!response)
		{
			Kick(playerid);
			return 1;
		}
		if(strlen(inputtext))
		{
			GetPlayerName(playerid, sendername, sizeof(sendername));
			new sqlaccountexists = MySQLCheckAccount(sendername);
			if (sqlaccountexists != 0)
			{
				SendClientMessage(playerid, COLOR_YELLOW, "Acel nume este deja luat, te rog alege altul.");
				return 1;
			}
			new tmppass[64];
			//if(strfind(inputtext, "|", true) != -1)
			new ok = 1;
			for(new i=0;i<strlen(inputtext);i++)
			{
				if(!IsALetter(inputtext))
					ok = 0;
			}
			if(ok == 0)
			{
				gPlayerAccount[playerid] = 0;
				new regstring[512];
				new regname[64];
				GetPlayerName(playerid,regname,sizeof(regname));
				format(regstring,sizeof(regstring),"{FFFFFF}Bine ai venit {8CBBF2}%s {FFFFFF}!nnVa rugam sa introduceti o parola in casuta pentru inregistrare !",regname);
				ShowPlayerDialog(playerid,12345,DIALOG_STYLE_PASSWORD,"Inregistrare",regstring,"Register","Iesire");
			}
			else
			{
				strmid(tmppass, inputtext, 0, strlen(inputtext), 255);
				OnPlayerRegister(playerid,tmppass);
			}
		}
		else
		{
			new regstring[512];
			new regname[64];
			GetPlayerName(playerid,regname,sizeof(regname));
			format(regstring,sizeof(regstring),"{FFFFFF}Bine ai venit {8CBBF2}%s {FFFFFF}!nnVa rugam sa introduceti o parola in casuta pentru inregistrare !",regname);
			ShowPlayerDialog(playerid,12345,DIALOG_STYLE_PASSWORD,"Inregistrare",regstring,"Register","Iesire");
		}
	}
	if(dialogid == 2)
	{
		if(!response)
		{

 

 

EDIT : Se poate sa fie si de la baza de date ?


-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Gazda: localhost
-- Timp de generare: 24 Feb 2014 la 02:12
-- Versiune server: 5.1.41
-- Versiune PHP: 5.3.1

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";


/*!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: `samp`
--

-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `admincmdslog`
--

CREATE TABLE IF NOT EXISTS `admincmdslog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Text` varchar(256) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=464 ;

--
-- Salvarea datelor din tabel `admincmdslog`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `adminmoneylog`
--

CREATE TABLE IF NOT EXISTS `adminmoneylog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Text` varchar(256) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=51 ;

--
-- Salvarea datelor din tabel `adminmoneylog`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `advertiseundercoverlog`
--

CREATE TABLE IF NOT EXISTS `advertiseundercoverlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Text` varchar(256) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1240 ;

--
-- Salvarea datelor din tabel `advertiseundercoverlog`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `banclass`
--

CREATE TABLE IF NOT EXISTS `banclass` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `iP` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '255.255',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Salvarea datelor din tabel `banclass`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `banuri`
--

CREATE TABLE IF NOT EXISTS `banuri` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idd` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Nume` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
  `BanzD` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `BanzP` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `BanlD` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `BanlP` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `BanaD` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `BanaP` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `BanoD` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `BanoP` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `BanmD` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `BanmP` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `AdminBan` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'No-One',
  `BanReason` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'No-One',
  `PlayerIP` varchar(20) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `TIP` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=159 ;

--
-- Salvarea datelor din tabel `banuri`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `bizz`
--

CREATE TABLE IF NOT EXISTS `bizz` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Owner` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'NoOne',
  `Message` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'NoOne',
  `Extortion` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'NoOne',
  `Owned` int(11) NOT NULL DEFAULT '0',
  `EntranceX` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `EntranceY` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `EntranceZ` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `ExitX` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `ExitY` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `ExitZ` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `LevelNeeded` int(11) NOT NULL DEFAULT '5',
  `BuyPrice` int(11) NOT NULL DEFAULT '5000000',
  `EntranceCost` int(11) NOT NULL DEFAULT '0',
  `Till` int(11) NOT NULL DEFAULT '0',
  `Locked` int(11) NOT NULL DEFAULT '0',
  `Interior` int(11) NOT NULL DEFAULT '0',
  `Products` int(11) NOT NULL DEFAULT '0',
  `MaxProducts` int(11) NOT NULL DEFAULT '500',
  `PriceProd` int(11) NOT NULL DEFAULT '1',
  `GunPrice` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ;

--
-- Salvarea datelor din tabel `bizz`
--

INSERT INTO `bizz` (`id`, `Owner`, `Message`, `Extortion`, `Owned`, `EntranceX`, `EntranceY`, `EntranceZ`, `ExitX`, `ExitY`, `ExitZ`, `LevelNeeded`, `BuyPrice`, `EntranceCost`, `Till`, `Locked`, `Interior`, `Products`, `MaxProducts`, `PriceProd`, `GunPrice`) VALUES
(1, 'The State', 'Gun Shop LS', 'No-one', 0, '1791.212036', '-1164.631713', '23.828100', '315.7100', '-142.7915', '999.6016', 6, 800000, 2000, 381437, 0, 7, 377, 500, 1, 100),
(2, 'The State', 'Arme Ieftine', 'Nimeni', 0, '1154.666503', '-1440.184082', '15.796875', '286.148986', '-40.644397', '1001.515625 ', 5, 900000, 1000, 3000, 0, 1, 482, 500, 50, 150),
(3, 'The State', 'Restaurant Blue Moon', 'No-one', 0, '1498.4156', '-1582.0658', '13.5498', '377.1464', '-192.4845', '1000.9328', 11, 790000, 5000, 800, 1, 17, 187, 500, 1000, 0),
(4, 'The State', 'Police Armoury', 'No-one', 0, '1568.625122', '-1690.535766', '5.890600', '246.376007', '109.246002', '1003.218811', 99, 5000, 0, 0, 0, 10, 329, 500, 1, 0),
(5, 'The State', 'Banca LS', 'No-one', 0, '1467.357666', '-1010.789794', '26.843750', '2305.688964', '-16.088100', '26.749599', 5, 1000000, 3000, 19992, 0, 0, 500, 500, 1, 0),
(6, 'The State', 'Hotel Los Santos', 'No-one', 0, '870.974914', '-2100.910156', '12.990797', '2226.867675', '-1150.288818', '1025.796875', 5, 500000, 5000, 2000, 1, 15, 478, 500, 300, 1000),
(7, 'The State', 'Las Venturas Bank', 'No-one', 0, '2127.5903', '2378.4482', '10.8203', '-2159.122802', '641.517517', '1052.381713', 9, 970000, 500, 1, 1, 1, 90, 500, 1, 50),
(8, 'The State', 'Mall Bank', 'No-one', 0, '1102.728759', '-1440.170410', '15.796875', '833.269775', '10.588416', '1004.179687', 5, 500000, 1000, 3000, 0, 3, 495, 500, 100, 0),
(9, 'The State', 'Gun Shop Las Venturas', 'No-one', 0, '2538.6570', '2083.9907', '10.8203', '316.52499', '-167.706985', '999.593750', 12, 930000, 500, 1000, 0, 6, 251, 500, 1, 30);

-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `cars`
--

CREATE TABLE IF NOT EXISTS `cars` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Model` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Locationx` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `Locationy` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `Locationz` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `Angle` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `SaLocationx` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `SaLocationy` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `SaLocationz` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `SaAngle` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `ColorOne` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `ColorTwo` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Owner` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'Dealership',
  `Description` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'No-one',
  `Value` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `License` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Owned` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Lockk` int(11) NOT NULL DEFAULT '0',
  `Exploded` varchar(50) DEFAULT NULL,
  `Num` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'AF-SCHOOL',
  `Component00` varchar(16) DEFAULT NULL,
  `Component01` varchar(16) DEFAULT NULL,
  `Component02` varchar(16) DEFAULT NULL,
  `Component03` varchar(16) DEFAULT NULL,
  `Component04` varchar(16) DEFAULT NULL,
  `Component05` varchar(16) DEFAULT NULL,
  `Component06` varchar(16) DEFAULT NULL,
  `Component07` varchar(16) DEFAULT NULL,
  `Component08` varchar(16) DEFAULT NULL,
  `Component09` varchar(16) DEFAULT NULL,
  `Component10` varchar(16) DEFAULT NULL,
  `Component11` varchar(16) DEFAULT NULL,
  `Component12` varchar(16) DEFAULT NULL,
  `Component13` varchar(16) DEFAULT NULL,
  `KM` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `PaintJob` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=127 ;

--
-- Salvarea datelor din tabel `cars`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `connectlog`
--

CREATE TABLE IF NOT EXISTS `connectlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Nume` varchar(256) NOT NULL,
  `Data` varchar(50) NOT NULL,
  `IP` varchar(255) NOT NULL,
  `Tip` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2244 ;

--
-- Salvarea datelor din tabel `connectlog`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `faction`
--

CREATE TABLE IF NOT EXISTS `faction` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Faction` int(11) NOT NULL DEFAULT '0',
  `Alianta` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Salvarea datelor din tabel `faction`
--

INSERT INTO `faction` (`Id`, `Faction`, `Alianta`) VALUES
(1, 11, 1),
(2, 12, 2),
(3, 13, 2),
(4, 14, 2),
(5, 15, 1),
(6, 16, 1);

-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `gunlog`
--

CREATE TABLE IF NOT EXISTS `gunlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Text` varchar(256) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=880 ;

--
-- Salvarea datelor din tabel `gunlog`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `hacklog`
--

CREATE TABLE IF NOT EXISTS `hacklog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Text` varchar(256) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1573 ;

--
-- Salvarea datelor din tabel `hacklog`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `houses`
--

CREATE TABLE IF NOT EXISTS `houses` (
  `id` int(11) NOT NULL,
  `Owner` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'The State',
  `Discription` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'NoOne',
  `Entrancex` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `Entrancey` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `Entrancez` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `Exitx` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `Exity` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `Exitz` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `Healthx` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Healthy` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Healthz` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Armourx` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Armoury` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Armourz` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Value` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Hel` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Arm` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Int` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Lockk` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Owned` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Rooms` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Rent` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Rentabil` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Takings` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Date` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Level` int(11) NOT NULL DEFAULT '0',
  `World` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '0',
  `Music` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Bani` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Materiale` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Droguri` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Salvarea datelor din tabel `houses`
--

INSERT INTO `houses` (`id`, `Owner`, `Discription`, `Entrancex`, `Entrancey`, `Entrancez`, `Exitx`, `Exity`, `Exitz`, `Healthx`, `Healthy`, `Healthz`, `Armourx`, `Armoury`, `Armourz`, `Value`, `Hel`, `Arm`, `Int`, `Lockk`, `Owned`, `Rooms`, `Rent`, `Rentabil`, `Takings`, `Date`, `Level`, `World`, `Music`, `Bani`, `Materiale`, `Droguri`) VALUES
(1, 'The State', 'Trailer', '-2639.734375', '168.677398', '7.195300', '1.200000', '-3.400000', '999.40002', '0', '0', '0', '0', '0', '0', '100000', '0', '0', '2', '0', '0', '0', '1', '0', '0', '44', 3, '', '', '', '', ''),
(2, 'The State', 'Bedsit', '2066.600097', '-1703.500000', '14.100000', '244.500000', '305.000000', '999.099975', '0', '0', '0', '0', '0', '0', '550000', '0', '0', '1', '0', '0', '1', '1', '1', '11', '111', 3, '', '', '', '', ''),
(3, 'The State', 'Bedsit', '1407.3167', '-1676.8221', '13.5677', '267.100006', '305.000000', '999.099975', '0', '0', '0', '0', '0', '0', '750000', '0', '0', '2', '0', '0', '1', '500', '0', '0', '338', 3, '', '', '', '', ''),
(4, 'The State', 'Bedsit', '1087.610107', '-922.832031', '43.390625', '301.299987', '306.299987', '1003.50000', '0', '0', '0', '0', '0', '0', '650000', '0', '0', '4', '0', '0', '1', '1000', '1', '0', '194', 3, '', '', '', '', ''),
(5, 'The State', 'Bedsit', '1093.860839', '-806.357788', '107.419006', '344.299987', '305.200012', '999.099975', '0', '0', '0', '0', '0', '0', '500000', '0', '0', '6', '1', '0', '0', '10', '1', '0', '128', 7, '', '', '', '', ''),
(6, 'The State', '2 Room Apartment', '2652.800048', '-1991.09997', '13.500000', '446.100006', '507.899993', '1001.400024', '0', '0', '0', '0', '0', '0', '550000', '0', '0', '12', '0', '0', '1', '500', '1', '0', '35', 3, '', '', '', '', ''),
(7, 'The State', '3 Room Apartment', '1405.0045', '-1701.9241', '13.5572', '-42.400001', '1408.199951', '1084.400024', '0', '0', '0', '0', '0', '0', '810000', '0', '0', '8', '1', '0', '1', '1', '1', '0', '128', 3, '', '', '', '', ''),
(8, 'The State', '3 Room Apartment', '1905.900024', '-1113.699951', '26.600000', '2464.100097', '-1698.599975', '1013.50000', '0', '0', '0', '0', '0', '0', '580000', '0', '0', '2', '1', '0', '1', '500', '1', '0', '164', 4, '', '', '', '', ''),
(9, 'The State', '3 Room Apartment', '836.299987', '-894.299987', '68.699996', '386.100006', '1471.800048', '1080.099975', '0', '0', '0', '0', '0', '0', '1000000', '0', '0', '15', '1', '0', '0', '1', '1', '24', '139', 7, '', '', '', '', ''),
(10, 'The State', '3 Room Apartment', '1059.202514', '-1105.846801', '28.045097', '221.600006', '1143.599975', '1082.599975', '0', '0', '0', '0', '0', '0', '550000', '0', '0', '4', '1', '0', '0', '1', '1', '0', '140', 4, '', '', '', '', ''),
(11, 'The State', '4 Room Apartment', '768.099975', '-1696.500000', '5.099997', '260.600006', '1238.800048', '1084.199951', '0', '0', '0', '0', '0', '0', '700000', '0', '0', '9', '1', '0', '0', '100', '10000', '0', '75', 4, '', '', '', '', ''),
(12, 'The State', '4 Room House', '652.099975', '-1619.900024', '15.000000', '261.000000', '1286.000000', '1080.199951', '0', '0', '0', '0', '0', '0', '600000', '0', '0', '4', '1', '0', '0', '100', '1', '0', '361', 3, '', '', '', '', ''),
(13, 'The State', '4 Room Apartment', '1527.2026', '-773.0822', '80.5781', '745.299987', '1437.699951', '1102.699951', '0', '0', '0', '0', '0', '0', '250000', '0', '0', '6', '0', '0', '0', '1000', '1', '0', '27', 3, '', '', '', '', ''),
(14, 'The State', '4 Room Apartment', '-2655.336425', '986.743225', '64.991302', '376.299987', '1417.199951', '1081.300048', '0', '0', '0', '0', '0', '0', '300000', '0', '0', '15', '1', '0', '1', '10000', '1', '0', '53', 3, '', '', '', '', ''),
(15, 'The State', '4 Room House', '812.700012', '-1456.599975', '13.699995', '27.100000', '1341.099975', '1084.300048', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '10', '1', '0', '1', '1500', '1', '36000', '243', 6, '', '', '', '', ''),
(16, 'The State', '4 Room Bedsit', '2434.899902', '-1320.800048', '24.799999', '2526.399902', '-1679.000000', '1015.400024', '0', '0', '0', '0', '0', '0', '450000', '0', '0', '1', '1', '0', '1', '1', '1', '90111', '0', 3, '', '', '', '', ''),
(17, 'The State', '4 Room Apartment', '2847.800048', '-1309.599975', '14.699995', '222.800003', '1288.69995', '1082.099975', '0', '0', '0', '0', '0', '0', '700000', '0', '0', '1', '0', '0', '1', '1', '1', '0', '263', 4, '', '', '', '', ''),
(18, 'The State', '4 Room House', '2144.399902', '-1803.099975', '16.100000', '23.000000', '1405.599975', '1084.400024', '0', '0', '0', '0', '0', '0', '500000', '0', '0', '5', '0', '0', '1', '1', '1', '40', '43', 7, '', '', '', '', ''),
(19, 'The State', '4 Room House', '1358.5518', '-1640.6714', '13.6203', '235.300003', '1189.199951', '1080.199951', '0', '0', '0', '0', '0', '0', '300000', '0', '0', '3', '0', '0', '1', '10', '1', '0', '227', 3, '', '', '', '', ''),
(20, 'The State', '5 Room Apartment', '1361.6210', '-1658.9053', '13.6254', '447.000000', '1400.300048', '1084.300048', '0', '0', '0', '0', '0', '0', '930000', '0', '0', '2', '0', '0', '1', '1', '1', '0', '265', 3, '', '', '', '', ''),
(21, 'The State', 'd', '1497.003784', '-688.370483', '95.450141', '234.199996', '1064.900024', '1084.199951', '0', '0', '0', '0', '0', '0', '4000000', '0', '0', '6', '0', '0', '1', '1', '0', '8', '117', 5, '', '', '', '', ''),
(22, 'The State', '5 Room Slum', '1539.499389', '-851.444763', '64.336059', '327.899993', '1478.300048', '1084.400024', '0', '0', '0', '0', '0', '0', '650000', '0', '0', '15', '1', '0', '1', '1000', '1', '0', '234', 5, '', '', '', '', ''),
(23, 'The State', '5 Room Apartment', '827.900024', '-858.500000', '70.300003', '295.399993', '1473.199951', '1080.199951', '0', '0', '0', '0', '0', '0', '680000', '0', '0', '15', '1', '0', '1', '150', '1', '43100', '117', 5, '', '', '', '', ''),
(24, 'The State', '6 Room House', '979.599975', '-676.000000', '121.900001', '140.399993', '1370.300048', '1083.800048', '0', '0', '0', '0', '0', '0', '570000', '0', '0', '5', '0', '0', '1', '1', '1', '5', '117', 3, '', '', '', '', ''),
(25, 'The State', '6 Room Luxury', '1111.500000', '-741.900024', '100.099998', '489.700012', '1402.500000', '1080.199951', '0', '0', '0', '0', '0', '0', '550000', '0', '0', '2', '1', '0', '1', '1', '1', '2', '236', 7, '', '', '', '', ''),
(26, 'The State', '6 Room House', '251.600006', '-1220.900024', '75.800003', '83.300003', '1324.699951', '1083.800048', '0', '0', '0', '0', '0', '0', '600000', '0', '0', '9', '1', '0', '1', '1', '1', '1', '108', 5, '', '', '', '', ''),
(27, 'The State', '7 Room Luxury', '1468.400024', '-903.700012', '54.799999', '231.399993', '1114.099975', '1080.900024', '0', '0', '0', '0', '0', '0', '800000', '0', '0', '5', '1', '0', '1', '10000', '1', '0', '119', 5, '', '', '', '', ''),
(28, 'The State', '8 Room Luxury,', '1421.800048', '-884.599975', '50.599998', '225.600006', '1023.500000', '1084.000000', '0', '0', '0', '0', '0', '0', '750000', '0', '0', '7', '0', '0', '1', '1', '1', '1', '118', 9, '', '', '', '', ''),
(29, 'The State', '4 Room Luxury', '1111.5577', '-975.4391', '42.7656', '-285.899993', '1470.800048', '1084.300048', '0', '0', '0', '0', '0', '0', '780000', '0', '0', '15', '0', '0', '1', '10000', '1', '0', '29', 3, '', '', '', '', ''),
(30, 'The State', '3 Room Luxury', '1325.582763', '2567.866943', '10.820312', '-262.700012', '1456.599975', '1084.300048', '0', '0', '0', '0', '0', '0', '300000', '0', '0', '4', '0', '0', '1', '10000', '0', '0', '92', 3, '', '', '', '', ''),
(31, 'The State', '2 Room Luxury', '2017.4475', '-1629.8678', '13.7121', '-68.800003', '1354.699951', '1080.199951', '0', '0', '0', '0', '0', '0', '370000', '0', '0', '6', '1', '0', '1', '100', '2', '0', '201', 3, '', '', '', '', ''),
(32, 'The State', '2 Room Luxury', '1516.806762', '-1453.009155', '14.203125', '2254.300048', '-1140.000000', '1050.599975', '0', '0', '0', '0', '0', '0', '540000', '0', '0', '9', '0', '0', '1', '10', '1', '0', '362', 4, '', '', '', '', ''),
(33, 'The State', '3 Room Luxury', '1519.524291', '-1452.632202', '14.203125', '2261.300048', '-1135.900024', '1050.599975', '0', '0', '0', '0', '0', '0', '540000', '0', '0', '10', '0', '0', '1', '1', '1', '0', '47', 4, '', '', '', '', ''),
(34, 'The State', '8 Room Luxury', '1103.401733', '-1092.431030', '28.468750', '2324.399902', '-1147.500000', '1050.699951', '0', '0', '0', '0', '0', '0', '590000', '0', '0', '12', '0', '0', '1', '1', '1', '28', '103', 4, '', '', '', '', ''),
(35, 'The State', 'Jouken Personalizate', '1284.6450', '-1066.3296', '31.6789', '2196.195068', '-1204.463745', '1049.023437', '0', '0', '0', '0', '0', '0', '890000', '0', '0', '6', '0', '0', '1', '500', '1', '0', '22', 3, '', '', '', '', ''),
(36, 'The State', '9 Room Luxury', '1298.5575', '-799.1378', '84.1406', '2351.5027', '-1180.9465', '1027.98', '0', '0', '0', '0', '0', '0', '820000', '0', '0', '5', '1', '0', '1', '100', '1', '2400', '115', 5, '', '', '', '', ''),
(37, 'The State', '9 Room Luxury', '255.010101', '-1366.694458', '53.109401', '491.213989', '1399.849853', '1080.264526', '0', '0', '0', '0', '0', '0', '900000', '0', '0', '2', '0', '0', '1', '100', '1', '4200', '364', 5, '', '', '', '', ''),
(38, 'The State', 'NoOne', '2015.8276', '1183.2162', '10.8203', '1299.14', '-794.77', '1084.00', '0', '0', '0', '0', '0', '0', '400000', '0', '0', '5', '1', '0', '0', '12', '1', '0', '66', 3, '', '', '', '', ''),
(39, 'The State', 'NoOne', '1847.0461', '740.9756', '11.4609', '-2169.9966', '638.5493', '1052.3750', '0', '0', '0', '0', '0', '0', '1', '0', '0', '1', '0', '0', '', '1000', '1', '0', '106', 3, '', '', '', '', ''),
(40, 'The State', 'NoOne', '2064.8347', '731.2178', '11.4683', '2217.54', '-1076.29', '1049.72', '0', '0', '0', '0', '0', '0', '500000', '0', '0', '1', '1', '0', '', '10000', '0', '0', '74', 3, '', '', '', '', ''),
(41, 'The State', 'NoOne', '2368.5146', '733.0474 ', '11.4609', '1043.3923', '10.0720', '1001.2845', '0', '0', '0', '0', '0', '0', '400000', '0', '0', '3', '1', '0', '', '1', '1', '0', '66', 3, '', '', '', '', ''),
(42, 'The State', 'NoOne', '1027.7633', '2005.5179', '11.4609', '225.756989', '1240.000000', '1082.149902', '0', '0', '0', '0', '0', '0', '350000', '0', '0', '2', '0', '0', '', '1', '15', '0', '336', 3, '', '', '', '', ''),
(43, 'The State', 'NoOne', '986.6437', '2314.1958', '11.4609', '1531.3724', '-7.6605', '1002.0971', '0', '0', '0', '0', '0', '0', '200000', '0', '0', '3', '1', '0', '', '1000', '100', '0', '147', 3, '', '', '', '', ''),
(44, 'The State', 'NoOne', '798.2460', '-1729.4363', '13.5469', '2495.8591', '-1692.3749', '1014.74', '0', '0', '0', '0', '0', '0', '740000', '0', '0', '3', '0', '0', '', '10000', '1', '0', '91', 9, '', '', '', '', ''),
(45, 'The State', 'NoOne', '1118.0498', '-1022.8296', '34.9922', '2233.8 ', '-1115.36', '1050.11', '0', '0', '0', '0', '0', '0', '850000', '0', '0', '5', '0', '0', '', '10000', '1', '0', '71', 10, '', '', '', '', ''),
(46, 'The State', 'NoOne', '2559.8149', '1561.6083', '10.8203', '2333.11', ' -1077.1', '1048.44', '0', '0', '0', '0', '0', '0', '200000', '0', '0', '6', '0', '0', '', '10000', '1', '0', '239', 3, '', '', '', '', ''),
(47, 'The State', 'NoOne', '893.644226', '-1635.880249', '14.929687', '2308.79', '-1212.88', '1048.23', '0', '0', '0', '0', '0', '0', '500000', '0', '0', '6', '0', '0', '', '200', '1', '0', '334', 5, '', '', '', '', ''),
(48, 'The State', 'NoOne', '865.238891', '-1634.172485', '14.929687', '2807.6616', '-1173.8026', '1025.57', '0', '0', '0', '0', '0', '0', '550000', '0', '0', '8', '0', '0', '', '100', '1', '0', '187', 4, '', '', '', '', ''),
(49, 'The State', 'NoOne', '2451.0227', '1301.0344', '10.8203', '419.8936', '2537.1155', '1.200', '0', '0', '0', '0', '0', '0', '1', '0', '0', '10', '', '0', '', '', '', '0', '178', 999, '', '', '', '', ''),
(50, 'The State', 'NoOne', '280.883544', '-1767.948852', '4.535346', '2237.59', '-1080.87 ', '1048.37', '0', '0', '0', '0', '0', '0', '750000', '0', '0', '2', '0', '0', '', '1', '1', '6', '132', 4, '', '', '', '', ''),
(51, 'The State', 'NoOne', '1863.7931', '-1598.6931', '14.2535', '318.565', '1115.210', '1083.18', '0', '0', '0', '0', '0', '0', '870000', '0', '0', '5', '0', '0', '', '750', '1', '0', '29', 5, '', '', '', '', ''),
(52, 'The State', 'NoOne', '791.5347', '-1754.4989', '13.4294', '2496.0024', '-1693.4324', '1014.7422', '0', '0', '0', '0', '0', '0', '550000', '0', '0', '3', '0', '0', '', '10', '1', '0', '64', 4, '', '', '', '', ''),
(53, 'The State', '5 Room Luxury', '987.330139', '-1624.309814', '14.929687', '2269.3672', '-1210.4067', '1047.5625', '0', '0', '0', '0', '0', '0', '450000', '0', '0', '10', '0', '0', '', '10000', '1', '0', '121', 4, '', '', '', '', ''),
(54, 'The State', 'NoOne', '2000.1165', '-1114.7057', '27.1250', '2365.0828', '-1134.7723', '1050.88', '0', '0', '0', '0', '0', '0', '720000', '0', '0', '8', '0', '0', '', '10', '1', '0', '29', 4, '', '', '', '', ''),
(55, 'The State', 'NoOne', '2032.2080', '2161.8755', '10.8203', '2317.82', '-1026.75', '1049.21', '0', '0', '0', '0', '0', '0', '550000', '0', '0', '9', '0', '0', '', '1', '1', '0', '137', 3, '', '', '', '', ''),
(56, 'The State', 'Casa Mare', '952.461120', '-910.045471', '45.765625', '225.623901', '1022.029296', '1084.015991', '0', '0', '0', '0', '0', '0', '1000000', '0', '0', '7', '1', '0', '1', '250', '1', '250', '134', 5, '55', '', '', '', ''),
(57, 'The State', 'Apartament', '1051.0742', '-1057.9991', '34.7969', '226.277801', '1240.130615', '1082.140625', '0', '0', '0', '0', '0', '0', '910000', '0', '0', '2', '0', '0', '1', '10000', '20000', '0', '4', 6, '56', '', '', '', ''),
(58, 'The State', 'Apartament', '901.0770', '-1447.2141', '14.1120', '226.277801', '1240.130615', '1082.140625', '0', '0', '0', '0', '0', '0', '880000', '0', '0', '2', '1', '0', '1', '10000', '1', '0', '146', 3, '57', '', '', '', ''),
(59, 'The State', 'Apartament', '1326.9183', '-1091.7751', '27.9766', '226.277801', '1240.130615', '1082.140625', '0', '0', '0', '0', '0', '0', '860000', '0', '0', '2', '1', '0', '1', '500', '1', '7000', '109', 7, '58', '', '', '', ''),
(60, 'The State', 'Apartament', '988.040954', '-1356.778076', '13.571376', '226.277801', '1240.130615', '1082.140625', '0', '0', '0', '0', '0', '0', '200000', '0', '0', '2', '1', '0', '1', '1000', '1', '0', '112', 3, '59', '', '', '', ''),
(61, 'The State', 'Apartament', '972.042419', '-1386.254272', '13.552158', '226.277801', '1240.130615', '1082.140625', '0', '0', '0', '0', '0', '0', '200000', '0', '0', '2', '0', '0', '1', '3500', '1', '20400', '106', 3, '60', '', '', '', ''),
(62, 'The State', 'Casa Mare', '1797.796997', '-1578.872558', '14.090000', '225.623901', '1022.029296', '1084.015991', '0', '0', '0', '0', '0', '0', '790000', '0', '0', '7', '1', '0', '1', '1', '1', '125', '115', 5, '61', '', '', '', ''),
(63, 'The State', 'Apartament', '1180.307617', '-1261.044067', '18.898437', '226.277801', '1240.130615', '1082.140625', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '2', '1', '0', '1', '2000', '1', '4076', '111', 3, '62', '', '', '', ''),
(64, 'The State', 'Apartament', '1187.186523', '-1254.607788', '18.890762', '226.277801', '1240.130615', '1082.140625', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '2', '1', '0', '1', '5000', '1', '26000', '116', 3, '63', '', '', '', ''),
(65, 'The State', 'Apartament', '1180.469360', '-1254.699951', '15.179687', '226.277801', '1240.130615', '1082.140625', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '2', '0', '0', '1', '200', '1', '400', '117', 3, '64', '', '', '', ''),
(66, 'The State', 'Apartament', '1180.410888', '-1227.148681', '18.554687', '226.277801', '1240.130615', '1082.140625', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '2', '1', '0', '1', '100', '1', '400', '132', 3, '65', '', '', '', ''),
(67, 'The State', 'Apartament', '1187.358642', '-1226.948608', '22.132949', '226.277801', '1240.130615', '1082.140625', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '2', '0', '0', '1', '10000', '1', '40000', '', 3, '66', '', '', '', ''),
(68, 'The State', 'Apartament', '1180.010131', '-1233.409301', '22.140625', '226.277801', '1240.130615', '1082.140625', '0', '0', '0', '0', '0', '0', '150000', '0', '0', '2', '0', '0', '1', '1', '1', '17', '115', 3, '67', '', '', '', ''),
(69, 'The State', 'Casa Mare', '1034.807250', '-812.646545', '101.851562', '225.623901', '1022.029296', '1084.015991', '0', '0', '0', '0', '0', '0', '550000', '0', '0', '7', '1', '0', '1', '1', '1', '0', '82', 4, '68', '', '', '', ''),
(70, 'The State', 'Casa Mare', '219.499511', '-1250.039062', '78.334495', '225.623901', '1022.029296', '1084.015991', '0', '0', '0', '0', '0', '0', '720000', '0', '0', '7', '0', '0', '1', '500', '1', '0', '118', 5, '69', '', '', '', ''),
(71, 'The State', 'Casa Mare', '300.228454', '-1154.436035', '81.390869', '225.623901', '1022.029296', '1084.015991', '0', '0', '0', '0', '0', '0', '1', '0', '0', '7', '1', '0', '1', '1', '1', '232', '116', 10, '70', '', '', '', ''),
(74, 'The State', 'Casa Medie', '1440.572265', '-926.123168', '39.647666', '2496.031250', '-1692.483886', '1014.742187', '0', '0', '0', '0', '0', '0', '580000', '0', '0', '3', '1', '0', '1', '1000', '1', '0', '119', 8, '73', '', '', '', ''),
(72, 'The State', 'Casa Mare', '1411.048828', '-920.853088', '38.421875', '225.623901', '1022.029296', '1084.015991', '0', '0', '0', '0', '0', '0', '670000', '0', '0', '7', '0', '0', '1', '1000', '1', '0', '138', 5, '71', '', '', '', ''),
(73, 'The State', 'Casa Medie', '808.710754', '-759.240478', '76.531364', '2496.031250', '-1692.483886', '1014.742187', '0', '0', '0', '0', '0', '0', '600000', '0', '0', '3', '0', '0', '1', '1', '1', '0', '338', 4, '72', '', '', '', ''),
(76, 'The State', 'Casa Mare', '492.407257', '-1511.298095', '20.506084', '225.623901', '1022.029296', '1084.015991', '0', '0', '0', '0', '0', '0', '660000', '0', '0', '7', '1', '0', '1', '10', '1', '0', '139', 4, '75', '', '', '', ''),
(75, 'The State', 'Casa Medie', '512.407775', '-1486.797119', '14.504134', '2496.031250', '-1692.483886', '1014.742187', '0', '0', '0', '0', '0', '0', '550000', '0', '0', '3', '0', '0', '1', '1', '1', '0', '67', 4, '74', '', '', '', ''),
(77, 'The State', 'Casa Mare', '476.506652', '-1496.479492', '20.430942', '225.623901', '1022.029296', '1084.015991', '0', '0', '0', '0', '0', '0', '660000', '0', '0', '7', '0', '0', '1', '10000', '1', '0', '19', 4, '76', '', '', '', '');

-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `killlog`
--

CREATE TABLE IF NOT EXISTS `killlog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Text` varchar(256) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1544 ;

--
-- Salvarea datelor din tabel `killlog`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `logarabianmafia`
--

CREATE TABLE IF NOT EXISTS `logarabianmafia` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` text CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=32 ;

--
-- Salvarea datelor din tabel `logarabianmafia`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `logballas`
--

CREATE TABLE IF NOT EXISTS `logballas` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` text CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=26 ;

--
-- Salvarea datelor din tabel `logballas`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `logfbi`
--

CREATE TABLE IF NOT EXISTS `logfbi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` text CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=29 ;

--
-- Salvarea datelor din tabel `logfbi`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `loggrovestreet`
--

CREATE TABLE IF NOT EXISTS `loggrovestreet` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` text CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=38 ;

--
-- Salvarea datelor din tabel `loggrovestreet`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `loghitman`
--

CREATE TABLE IF NOT EXISTS `loghitman` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` text CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=42 ;

--
-- Salvarea datelor din tabel `loghitman`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `loginstructor`
--

CREATE TABLE IF NOT EXISTS `loginstructor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` text CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 ;

--
-- Salvarea datelor din tabel `loginstructor`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `lognationalguard`
--

CREATE TABLE IF NOT EXISTS `lognationalguard` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` varchar(500) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=22 ;

--
-- Salvarea datelor din tabel `lognationalguard`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `logparamedicdepartment`
--

CREATE TABLE IF NOT EXISTS `logparamedicdepartment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` text CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Salvarea datelor din tabel `logparamedicdepartment`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `logpolicedepartament`
--

CREATE TABLE IF NOT EXISTS `logpolicedepartament` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` text CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Salvarea datelor din tabel `logpolicedepartament`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `logreporter`
--

CREATE TABLE IF NOT EXISTS `logreporter` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` text CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15 ;

--
-- Salvarea datelor din tabel `logreporter`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `logromanianmafia`
--

CREATE TABLE IF NOT EXISTS `logromanianmafia` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` text CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=54 ;

--
-- Salvarea datelor din tabel `logromanianmafia`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `logtaxi`
--

CREATE TABLE IF NOT EXISTS `logtaxi` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `text` text CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;

--
-- Salvarea datelor din tabel `logtaxi`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `paylog`
--

CREATE TABLE IF NOT EXISTS `paylog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Text` varchar(256) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9146 ;

--
-- Salvarea datelor din tabel `paylog`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `players`
--

CREATE TABLE IF NOT EXISTS `players` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `Password` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `PlayerLevel` int(11) NOT NULL DEFAULT '1',
  `AdminLevel` int(11) NOT NULL DEFAULT '0',
  `Wipe` int(11) NOT NULL DEFAULT '0',
  `DonateRank` int(11) NOT NULL DEFAULT '0',
  `UpgradePoints` int(11) NOT NULL DEFAULT '0',
  `ConnectedTime` int(11) NOT NULL DEFAULT '1',
  `Registered` int(11) NOT NULL DEFAULT '0',
  `Sex` int(11) NOT NULL DEFAULT '1',
  `Age` int(11) NOT NULL DEFAULT '0',
  `Origin` int(11) NOT NULL DEFAULT '1',
  `CK` int(11) NOT NULL DEFAULT '0',
  `Muted` int(11) NOT NULL DEFAULT '0',
  `MuteTime` int(11) NOT NULL DEFAULT '0',
  `Respect` int(11) NOT NULL DEFAULT '0',
  `Money` bigint(20) NOT NULL DEFAULT '19000',
  `Bank` int(11) NOT NULL DEFAULT '0',
  `Crimes` int(11) NOT NULL DEFAULT '0',
  `Kills` int(11) NOT NULL DEFAULT '0',
  `Deaths` int(11) NOT NULL DEFAULT '0',
  `Arrested` int(11) NOT NULL DEFAULT '0',
  `WantedLevel` int(11) NOT NULL DEFAULT '0',
  `WantedPoints` int(11) NOT NULL DEFAULT '0',
  `WantedDeaths` int(11) NOT NULL DEFAULT '0',
  `Phonebook` int(11) NOT NULL DEFAULT '0',
  `LottoNr` int(11) NOT NULL DEFAULT '0',
  `Fishes` int(11) NOT NULL DEFAULT '0',
  `BiggestFish` int(11) NOT NULL DEFAULT '0',
  `Sticle` int(11) NOT NULL DEFAULT '0',
  `Job` int(11) NOT NULL DEFAULT '0',
  `Paycheck` int(11) NOT NULL DEFAULT '0',
  `HeadValue` int(11) NOT NULL DEFAULT '0',
  `Jailed` int(11) NOT NULL DEFAULT '0',
  `JailTime` int(11) NOT NULL DEFAULT '0',
  `Materials` int(11) NOT NULL DEFAULT '0',
  `Drugs` int(11) NOT NULL DEFAULT '0',
  `Leader` int(11) NOT NULL DEFAULT '0',
  `Member` int(11) NOT NULL DEFAULT '0',
  `FMember` int(11) NOT NULL DEFAULT '255',
  `Rank` int(11) NOT NULL DEFAULT '0',
  `Chara` int(11) NOT NULL DEFAULT '0',
  `ContractTime` int(11) NOT NULL DEFAULT '0',
  `DetSkill` int(11) NOT NULL DEFAULT '0',
  `SexSkill` int(11) NOT NULL DEFAULT '0',
  `BoxSkill` int(11) NOT NULL DEFAULT '0',
  `LawSkill` int(11) NOT NULL DEFAULT '0',
  `MechSkill` int(11) NOT NULL DEFAULT '0',
  `JackSkill` int(11) NOT NULL DEFAULT '0',
  `CarSkill` int(11) NOT NULL DEFAULT '0',
  `NewsSkill` int(11) NOT NULL DEFAULT '0',
  `DrugsSkill` int(11) NOT NULL DEFAULT '0',
  `CookSkill` int(11) NOT NULL DEFAULT '0',
  `FishSkill` int(11) NOT NULL DEFAULT '0',
  `Passport` int(11) NOT NULL DEFAULT '0',
  `Inte` int(11) NOT NULL DEFAULT '0',
  `Local` int(11) NOT NULL DEFAULT '255',
  `Team` int(11) NOT NULL DEFAULT '3',
  `Model` int(11) NOT NULL DEFAULT '264',
  `PhoneNr` int(11) NOT NULL DEFAULT '0',
  `House` int(11) NOT NULL DEFAULT '255',
  `Car` int(11) NOT NULL DEFAULT '999',
  `Car1` int(11) NOT NULL DEFAULT '999',
  `Bizz` int(11) NOT NULL DEFAULT '255',
  `CarLic` int(11) NOT NULL DEFAULT '0',
  `PunctePen` int(11) NOT NULL DEFAULT '15',
  `FlyLic` int(11) NOT NULL DEFAULT '0',
  `BoatLic` int(11) NOT NULL DEFAULT '0',
  `FishLic` int(11) NOT NULL DEFAULT '0',
  `GunLic` int(11) NOT NULL DEFAULT '0',
  `MatsLic` int(11) NOT NULL DEFAULT '0',
  `CarLicTime` int(11) NOT NULL DEFAULT '0',
  `FlyLicTime` int(11) NOT NULL DEFAULT '0',
  `BoatLicTime` int(11) NOT NULL DEFAULT '0',
  `FishLicTime` int(11) NOT NULL DEFAULT '0',
  `GunLicTime` int(11) NOT NULL DEFAULT '0',
  `MatsLicTime` int(11) NOT NULL DEFAULT '0',
  `Gun1` int(11) NOT NULL DEFAULT '0',
  `Gun2` int(11) NOT NULL DEFAULT '0',
  `Gun3` int(11) NOT NULL DEFAULT '0',
  `Gun4` int(11) NOT NULL DEFAULT '0',
  `Gun5` int(11) NOT NULL DEFAULT '0',
  `Gun6` int(11) NOT NULL DEFAULT '0',
  `Ammo1` int(11) NOT NULL DEFAULT '0',
  `Ammo2` int(11) NOT NULL DEFAULT '0',
  `Ammo3` int(11) NOT NULL DEFAULT '0',
  `Ammo4` int(11) NOT NULL DEFAULT '0',
  `Ammo5` int(11) NOT NULL DEFAULT '0',
  `Ammo6` int(11) NOT NULL DEFAULT '0',
  `CarTime` int(11) NOT NULL DEFAULT '0',
  `CGunoiTime` int(11) NOT NULL DEFAULT '0',
  `PayDay` int(11) NOT NULL DEFAULT '0',
  `PayDayHad` int(11) NOT NULL DEFAULT '0',
  `CDPlayer` int(11) NOT NULL DEFAULT '0',
  `Canistra` int(11) NOT NULL DEFAULT '0',
  `Watch` int(11) NOT NULL DEFAULT '0',
  `Frec` int(11) NOT NULL DEFAULT '0',
  `Walkie` int(11) NOT NULL DEFAULT '0',
  `Cigars` int(11) NOT NULL DEFAULT '0',
  `Matches` int(11) NOT NULL DEFAULT '0',
  `FTools` int(11) NOT NULL DEFAULT '0',
  `Wins` int(11) NOT NULL DEFAULT '0',
  `Loses` int(11) NOT NULL DEFAULT '0',
  `AlcoholPerk` int(11) NOT NULL DEFAULT '0',
  `DrugPerk` int(11) NOT NULL DEFAULT '0',
  `MiserPerk` int(11) NOT NULL DEFAULT '0',
  `PainPerk` int(11) NOT NULL DEFAULT '0',
  `TraderPerk` int(11) NOT NULL DEFAULT '0',
  `Tutorial` int(11) NOT NULL DEFAULT '0',
  `Mission` int(11) NOT NULL DEFAULT '0',
  `Warnings` int(11) NOT NULL DEFAULT '0',
  `FWarns` int(11) NOT NULL DEFAULT '0',
  `Fpunish` int(11) NOT NULL DEFAULT '0',
  `Adjustable` int(11) NOT NULL DEFAULT '0',
  `Fuel` int(11) NOT NULL DEFAULT '0',
  `Married` int(11) NOT NULL DEFAULT '0',
  `RequestingBackup` int(11) NOT NULL DEFAULT '0',
  `Alawyer` int(11) NOT NULL DEFAULT '0',
  `Limba` int(11) NOT NULL DEFAULT '0',
  `RobSkill` int(11) NOT NULL DEFAULT '0',
  `Sf` int(11) NOT NULL DEFAULT '0',
  `SpawnChange` int(11) NOT NULL DEFAULT '0',
  `Rob` int(11) NOT NULL DEFAULT '0',
  `Locked` tinyint(2) NOT NULL DEFAULT '0',
  `Car2` int(11) NOT NULL,
  `Car3` int(11) NOT NULL,
  `Imprumut` int(11) NOT NULL,
  `ImpPayDay` int(11) NOT NULL DEFAULT '0',
  `Agent` int(11) NOT NULL DEFAULT '0',
  `Alowed` int(11) NOT NULL DEFAULT '0',
  `Frate` int(11) NOT NULL DEFAULT '0',
  `Updates08` int(11) NOT NULL DEFAULT '0',
  `Updates09` int(11) NOT NULL DEFAULT '0',
  `Updates10` int(11) NOT NULL DEFAULT '0',
  `Updates11` int(11) NOT NULL DEFAULT '0',
  `Updates12` int(11) NOT NULL DEFAULT '0',
  `Updates13` int(11) NOT NULL DEFAULT '0',
  `Updates14` int(11) NOT NULL DEFAULT '0',
  `Updates15` int(11) NOT NULL DEFAULT '0',
  `MarriedTo` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT 'No-one',
  `DateReg` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT 'No-one',
  `UltLog` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT 'No-one',
  `Email` varchar(64) COLLATE latin1_general_ci NOT NULL DEFAULT 'Niciunul',
  `Pos_x` varchar(16) COLLATE latin1_general_ci NOT NULL DEFAULT '1742.6400',
  `Pos_y` varchar(16) COLLATE latin1_general_ci NOT NULL DEFAULT '-1862.6600',
  `Pos_z` varchar(16) COLLATE latin1_general_ci NOT NULL DEFAULT '13.5800',
  `pSHealth` varchar(16) COLLATE latin1_general_ci NOT NULL DEFAULT '50.0',
  `pHealth` varchar(16) COLLATE latin1_general_ci NOT NULL DEFAULT '50.0',
  `pArmour` varchar(16) COLLATE latin1_general_ci NOT NULL DEFAULT '0.0',
  `Status` int(11) NOT NULL DEFAULT '0',
  `rpgon` int(11) NOT NULL DEFAULT '0',
  `Allow` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `Name_2` (`Name`),
  KEY `name` (`Name`),
  KEY `level` (`PlayerLevel`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1301 ;

--
-- Salvarea datelor din tabel `players`
--

INSERT INTO `players` (`id`, `Name`, `Password`, `PlayerLevel`, `AdminLevel`, `Wipe`, `DonateRank`, `UpgradePoints`, `ConnectedTime`, `Registered`, `Sex`, `Age`, `Origin`, `CK`, `Muted`, `MuteTime`, `Respect`, `Money`, `Bank`, `Crimes`, `Kills`, `Deaths`, `Arrested`, `WantedLevel`, `WantedPoints`, `WantedDeaths`, `Phonebook`, `LottoNr`, `Fishes`, `BiggestFish`, `Sticle`, `Job`, `Paycheck`, `HeadValue`, `Jailed`, `JailTime`, `Materials`, `Drugs`, `Leader`, `Member`, `FMember`, `Rank`, `Chara`, `ContractTime`, `DetSkill`, `SexSkill`, `BoxSkill`, `LawSkill`, `MechSkill`, `JackSkill`, `CarSkill`, `NewsSkill`, `DrugsSkill`, `CookSkill`, `FishSkill`, `Passport`, `Inte`, `Local`, `Team`, `Model`, `PhoneNr`, `House`, `Car`, `Car1`, `Bizz`, `CarLic`, `PunctePen`, `FlyLic`, `BoatLic`, `FishLic`, `GunLic`, `MatsLic`, `CarLicTime`, `FlyLicTime`, `BoatLicTime`, `FishLicTime`, `GunLicTime`, `MatsLicTime`, `Gun1`, `Gun2`, `Gun3`, `Gun4`, `Gun5`, `Gun6`, `Ammo1`, `Ammo2`, `Ammo3`, `Ammo4`, `Ammo5`, `Ammo6`, `CarTime`, `CGunoiTime`, `PayDay`, `PayDayHad`, `CDPlayer`, `Canistra`, `Watch`, `Frec`, `Walkie`, `Cigars`, `Matches`, `FTools`, `Wins`, `Loses`, `AlcoholPerk`, `DrugPerk`, `MiserPerk`, `PainPerk`, `TraderPerk`, `Tutorial`, `Mission`, `Warnings`, `FWarns`, `Fpunish`, `Adjustable`, `Fuel`, `Married`, `RequestingBackup`, `Alawyer`, `Limba`, `RobSkill`, `Sf`, `SpawnChange`, `Rob`, `Locked`, `Car2`, `Car3`, `Imprumut`, `ImpPayDay`, `Agent`, `Alowed`, `Frate`, `Updates08`, `Updates09`, `Updates10`, `Updates11`, `Updates12`, `Updates13`, `Updates14`, `Updates15`, `MarriedTo`, `DateReg`, `UltLog`, `Email`, `Pos_x`, `Pos_y`, `Pos_z`, `pSHealth`, `pHealth`, `pArmour`, `Status`, `rpgon`, `Allow`) VALUES

-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `players_old`
--

CREATE TABLE IF NOT EXISTS `players_old` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Name` varchar(50) COLLATE latin1_general_ci NOT NULL,
  `Password` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `PlayerLevel` int(11) NOT NULL DEFAULT '1',
  `AdminLevel` int(11) NOT NULL DEFAULT '0',
  `Wipe` int(11) NOT NULL DEFAULT '0',
  `DonateRank` int(11) NOT NULL DEFAULT '0',
  `UpgradePoints` int(11) NOT NULL DEFAULT '0',
  `ConnectedTime` int(11) NOT NULL DEFAULT '1',
  `Registered` int(11) NOT NULL DEFAULT '0',
  `Sex` int(11) NOT NULL DEFAULT '1',
  `Age` int(11) NOT NULL DEFAULT '0',
  `Origin` int(11) NOT NULL DEFAULT '1',
  `CK` int(11) NOT NULL DEFAULT '0',
  `Muted` int(11) NOT NULL DEFAULT '0',
  `MuteTime` int(11) NOT NULL DEFAULT '0',
  `Respect` int(11) NOT NULL DEFAULT '0',
  `Money` bigint(20) NOT NULL DEFAULT '1000',
  `Bank` int(11) NOT NULL DEFAULT '5000',
  `Crimes` int(11) NOT NULL DEFAULT '0',
  `Kills` int(11) NOT NULL DEFAULT '0',
  `Deaths` int(11) NOT NULL DEFAULT '0',
  `Arrested` int(11) NOT NULL DEFAULT '0',
  `WantedLevel` int(11) NOT NULL DEFAULT '0',
  `WantedPoints` int(11) NOT NULL DEFAULT '0',
  `WantedDeaths` int(11) NOT NULL DEFAULT '0',
  `Phonebook` int(11) NOT NULL DEFAULT '0',
  `LottoNr` int(11) NOT NULL DEFAULT '0',
  `Fishes` int(11) NOT NULL DEFAULT '0',
  `BiggestFish` int(11) NOT NULL DEFAULT '0',
  `Job` int(11) NOT NULL DEFAULT '0',
  `Paycheck` int(11) NOT NULL DEFAULT '0',
  `HeadValue` int(11) NOT NULL DEFAULT '0',
  `Jailed` int(11) NOT NULL DEFAULT '0',
  `JailTime` int(11) NOT NULL DEFAULT '0',
  `Materials` int(11) NOT NULL DEFAULT '0',
  `Drugs` int(11) NOT NULL DEFAULT '0',
  `Leader` int(11) NOT NULL DEFAULT '0',
  `Member` int(11) NOT NULL DEFAULT '0',
  `FMember` int(11) NOT NULL DEFAULT '255',
  `Rank` int(11) NOT NULL DEFAULT '0',
  `Chara` int(11) NOT NULL DEFAULT '0',
  `ContractTime` int(11) NOT NULL DEFAULT '0',
  `DetSkill` int(11) NOT NULL DEFAULT '0',
  `SexSkill` int(11) NOT NULL DEFAULT '0',
  `BoxSkill` int(11) NOT NULL DEFAULT '0',
  `LawSkill` int(11) NOT NULL DEFAULT '0',
  `MechSkill` int(11) NOT NULL DEFAULT '0',
  `JackSkill` int(11) NOT NULL DEFAULT '0',
  `CarSkill` int(11) NOT NULL DEFAULT '0',
  `NewsSkill` int(11) NOT NULL DEFAULT '0',
  `DrugsSkill` int(11) NOT NULL DEFAULT '0',
  `CookSkill` int(11) NOT NULL DEFAULT '0',
  `FishSkill` int(11) NOT NULL DEFAULT '0',
  `Passport` int(11) NOT NULL DEFAULT '0',
  `Inte` int(11) NOT NULL DEFAULT '0',
  `Local` int(11) NOT NULL DEFAULT '255',
  `Team` int(11) NOT NULL DEFAULT '3',
  `Model` int(11) NOT NULL DEFAULT '264',
  `PhoneNr` int(11) NOT NULL DEFAULT '0',
  `House` int(11) NOT NULL DEFAULT '255',
  `Car` int(11) NOT NULL DEFAULT '999',
  `Bizz` int(11) NOT NULL DEFAULT '255',
  `CarLic` int(11) NOT NULL DEFAULT '0',
  `PunctePen` int(11) NOT NULL DEFAULT '15',
  `FlyLic` int(11) NOT NULL DEFAULT '0',
  `BoatLic` int(11) NOT NULL DEFAULT '0',
  `FishLic` int(11) NOT NULL DEFAULT '0',
  `GunLic` int(11) NOT NULL DEFAULT '0',
  `MatsLic` int(11) NOT NULL DEFAULT '0',
  `Gun1` int(11) NOT NULL DEFAULT '0',
  `Gun2` int(11) NOT NULL DEFAULT '0',
  `Gun3` int(11) NOT NULL DEFAULT '0',
  `Gun4` int(11) NOT NULL DEFAULT '0',
  `Ammo1` int(11) NOT NULL DEFAULT '0',
  `Ammo2` int(11) NOT NULL DEFAULT '0',
  `Ammo3` int(11) NOT NULL DEFAULT '0',
  `Ammo4` int(11) NOT NULL DEFAULT '0',
  `CarTime` int(11) NOT NULL DEFAULT '0',
  `PayDay` int(11) NOT NULL DEFAULT '0',
  `PayDayHad` int(11) NOT NULL DEFAULT '0',
  `CDPlayer` int(11) NOT NULL DEFAULT '0',
  `Watch` int(11) NOT NULL DEFAULT '0',
  `Frec` int(11) NOT NULL DEFAULT '0',
  `Walkie` int(11) NOT NULL DEFAULT '0',
  `Cigars` int(11) NOT NULL DEFAULT '0',
  `Matches` int(11) NOT NULL DEFAULT '0',
  `FTools` int(11) NOT NULL DEFAULT '0',
  `Wins` int(11) NOT NULL DEFAULT '0',
  `Loses` int(11) NOT NULL DEFAULT '0',
  `AlcoholPerk` int(11) NOT NULL DEFAULT '0',
  `DrugPerk` int(11) NOT NULL DEFAULT '0',
  `MiserPerk` int(11) NOT NULL DEFAULT '0',
  `PainPerk` int(11) NOT NULL DEFAULT '0',
  `TraderPerk` int(11) NOT NULL DEFAULT '0',
  `Tutorial` int(11) NOT NULL DEFAULT '0',
  `Mission` int(11) NOT NULL DEFAULT '0',
  `Warnings` int(11) NOT NULL DEFAULT '0',
  `FWarns` int(11) NOT NULL DEFAULT '0',
  `Fpunish` int(11) NOT NULL DEFAULT '0',
  `Adjustable` int(11) NOT NULL DEFAULT '0',
  `Fuel` int(11) NOT NULL DEFAULT '0',
  `Married` int(11) NOT NULL DEFAULT '0',
  `RequestingBackup` int(11) NOT NULL DEFAULT '0',
  `Alawyer` int(11) NOT NULL DEFAULT '0',
  `Limba` int(11) NOT NULL DEFAULT '0',
  `RobSkill` int(11) NOT NULL DEFAULT '0',
  `Tow` int(11) NOT NULL DEFAULT '0',
  `Sf` int(11) NOT NULL DEFAULT '0',
  `SpawnChange` int(11) NOT NULL DEFAULT '0',
  `Rob` int(11) NOT NULL DEFAULT '0',
  `Locked` tinyint(1) NOT NULL DEFAULT '0',
  `Car2` int(11) NOT NULL,
  `Car3` int(11) NOT NULL,
  `Imprumut` int(11) NOT NULL,
  `ImpPayDay` int(11) NOT NULL DEFAULT '0',
  `Agent` int(11) NOT NULL DEFAULT '0',
  `Alowed` int(11) NOT NULL DEFAULT '0',
  `Updates07` int(11) NOT NULL DEFAULT '0',
  `Updates08` int(11) NOT NULL DEFAULT '0',
  `Updates09` int(11) NOT NULL DEFAULT '0',
  `Updates10` int(11) NOT NULL DEFAULT '0',
  `Updates11` int(11) NOT NULL DEFAULT '0',
  `Updates12` int(11) NOT NULL DEFAULT '0',
  `Updates13` int(11) NOT NULL DEFAULT '0',
  `Updates14` int(11) NOT NULL DEFAULT '0',
  `Updates15` int(11) NOT NULL DEFAULT '0',
  `MarriedTo` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT 'No-one',
  `DateReg` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT 'No-one',
  `UltLog` varchar(50) COLLATE latin1_general_ci NOT NULL DEFAULT 'No-one',
  `Email` varchar(64) COLLATE latin1_general_ci NOT NULL DEFAULT 'Niciunul',
  `Pos_x` varchar(16) COLLATE latin1_general_ci NOT NULL DEFAULT '1742.6400',
  `Pos_y` varchar(16) COLLATE latin1_general_ci NOT NULL DEFAULT '-1862.6600',
  `Pos_z` varchar(16) COLLATE latin1_general_ci NOT NULL DEFAULT '13.5800',
  `pSHealth` varchar(16) COLLATE latin1_general_ci NOT NULL DEFAULT '50.0',
  `pHealth` varchar(16) COLLATE latin1_general_ci NOT NULL DEFAULT '50.0',
  `pArmour` varchar(16) COLLATE latin1_general_ci NOT NULL DEFAULT '0.0',
  PRIMARY KEY (`id`),
  KEY `name` (`Name`),
  KEY `level` (`PlayerLevel`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;

--
-- Salvarea datelor din tabel `players_old`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `propertylog`
--

CREATE TABLE IF NOT EXISTS `propertylog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Text` varchar(256) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=719 ;

--
-- Salvarea datelor din tabel `propertylog`
--

INSERT INTO `propertylog` (`id`, `Text`) VALUES
(576, '[WARNING]: Norton a vandut casa id 1.'),
(577, '[WARNING]: Norton a vandut casa id 2.'),
(578, '[WARNING]: Norton a vandut casa id 3.'),
(579, '[WARNING]: Norton a vandut casa id 4.'),
(580, '[WARNING]: Norton a vandut casa id 5.'),
(581, '[WARNING]: Norton a vandut casa id 6.'),
(582, '[WARNING]: Norton a vandut casa id 7.'),
(583, '[WARNING]: Norton a vandut casa id 8.'),
(584, '[WARNING]: Norton a vandut casa id 9.'),
(585, '[WARNING]: Norton a vandut casa id 10.'),
(586, '[WARNING]: Norton a vandut casa id 11.'),
(587, '[WARNING]: Norton a vandut casa id 12.'),
(588, '[WARNING]: Norton a vandut casa id 13.'),
(589, '[WARNING]: Norton a vandut casa id 14.'),
(590, '[WARNING]: Norton a vandut casa id 15.'),
(591, '[WARNING]: Norton a vandut casa id 16.'),
(592, '[WARNING]: Norton a vandut casa id 17.'),
(593, '[WARNING]: Norton a vandut casa id 18.'),
(594, '[WARNING]: Norton a vandut casa id 19.'),
(595, '[WARNING]: Norton a vandut casa id 20.'),
(596, '[WARNING]: Norton a vandut casa id 21.'),
(597, '[WARNING]: Norton a vandut casa id 22.'),
(598, '[WARNING]: Norton a vandut casa id 23.'),
(599, '[WARNING]: Norton a vandut casa id 24.'),
(600, '[WARNING]: Norton a vandut casa id 25.'),
(601, '[WARNING]: Norton a vandut casa id 26.'),
(602, '[WARNING]: Norton a vandut casa id 2.'),
(603, '[WARNING]: Norton a vandut casa id 27.'),
(604, '[WARNING]: Norton a vandut casa id 28.'),
(605, '[WARNING]: Norton a vandut casa id 29.'),
(606, '[WARNING]: Norton a vandut casa id 30.'),
(607, '[WARNING]: Norton a vandut casa id 31.'),
(608, '[WARNING]: Norton a vandut casa id 32.'),
(609, '[WARNING]: Norton a vandut casa id 33.'),
(610, '[WARNING]: Norton a vandut casa id 34.'),
(611, '[WARNING]: Norton a vandut casa id 35.'),
(612, '[WARNING]: Norton a vandut casa id 36.'),
(613, '[WARNING]: Norton a vandut casa id 37.'),
(614, '[WARNING]: Norton a vandut casa id 38.'),
(615, '[WARNING]: Norton a vandut casa id 39.'),
(616, '[WARNING]: Norton a vandut casa id 40.'),
(617, '[WARNING]: Norton a vandut casa id 41.'),
(618, '[WARNING]: Norton a vandut casa id 42.'),
(619, '[WARNING]: Norton a vandut casa id 43.'),
(620, '[WARNING]: Norton a vandut casa id 44.'),
(621, '[WARNING]: Norton a vandut casa id 45.'),
(622, '[WARNING]: Norton a vandut casa id 46.'),
(623, '[WARNING]: Norton a vandut casa id 47.'),
(624, '[WARNING]: Norton a vandut casa id 48.'),
(625, '[WARNING]: Norton a vandut casa id 49.'),
(626, '[WARNING]: Norton a vandut casa id 50.'),
(627, '[WARNING]: Norton a vandut casa id 51.'),
(628, '[WARNING]: Norton a vandut casa id 52.'),
(629, '[WARNING]: Norton a vandut casa id 53.'),
(630, '[WARNING]: Norton a vandut casa id 54.'),
(631, '[WARNING]: Norton a vandut casa id 55.'),
(632, '[WARNING]: Norton a vandut casa id 56.'),
(633, '[WARNING]: Norton a vandut casa id 57.'),
(634, '[WARNING]: Norton a vandut casa id 58.'),
(635, '[WARNING]: Norton a vandut casa id 59.'),
(636, '[WARNING]: Norton a vandut casa id 60.'),
(637, '[WARNING]: Norton a vandut casa id 61.'),
(638, '[WARNING]: Norton a vandut casa id 62.'),
(639, '[WARNING]: Norton a vandut casa id 63.'),
(640, '[WARNING]: Norton a vandut casa id 64.'),
(641, '[WARNING]: Norton a vandut casa id 65.'),
(642, '[WARNING]: Norton a vandut casa id 66.'),
(643, '[WARNING]: Norton a vandut casa id 67.'),
(644, '[WARNING]: Norton a vandut casa id 68.'),
(645, '[WARNING]: Norton a vandut casa id 69.'),
(646, '[WARNING]: Norton a vandut casa id 70.'),
(647, '[WARNING]: Norton a vandut casa id 71.'),
(648, '[WARNING]: Norton a vandut casa id 72.'),
(649, '[WARNING]: Norton a vandut casa id 73.'),
(650, '[WARNING]: Norton a vandut casa id 74.'),
(651, '[WARNING]: Norton a vandut casa id 75.'),
(652, '[WARNING]: Norton a vandut casa id 76.'),
(653, '[WARNING]: Norton a vandut casa id 77.'),
(654, '[WARNING]: Norton a vandut casa id 78.'),
(655, '[WARNING]: Norton a vandut casa id 79.'),
(656, '[WARNING]: Norton a vandut casa id 80.'),
(657, '[WARNING]: Norton a vandut casa id 81.'),
(658, '[WARNING]: Norton a vandut casa id 82.'),
(659, '[WARNING]: Norton a vandut casa id 83.'),
(660, '[WARNING]: Norton a vandut casa id 84.'),
(661, '[WARNING]: Norton a vandut casa id 85.'),
(662, '[WARNING]: Norton a vandut casa id 86.'),
(663, '[WARNING]: Norton a vandut casa id 87.'),
(664, '[WARNING]: Norton a vandut casa id 88.'),
(665, '[WARNING]: Norton a vandut casa id 89.'),
(666, '[WARNING]: Norton a vandut casa id 90.'),
(667, '[WARNING]: Norton a vandut casa id 91.'),
(668, '[WARNING]: Norton a vandut casa id 92.'),
(669, '[WARNING]: Norton a vandut casa id 93.'),
(670, '[WARNING]: Norton a vandut casa id 94.'),
(671, '[WARNING]: Norton a vandut casa id 95.'),
(672, '[WARNING]: Norton a vandut casa id 96.'),
(673, '[WARNING]: Norton a vandut casa id 97.'),
(674, '[WARNING]: Norton a vandut casa id 98.'),
(675, '[WARNING]: Norton a vandut casa id 99.'),
(676, '[WARNING]: Norton a vandut casa id 100.'),
(677, '[WARNING]: Norton a vandut casa id 2 cu 250000 in (29/1/2014) .'),
(678, '[WARNING]: Norton a vandut casa id 2 cu 250000 in (29/1/2014) .'),
(679, '[WARNING]: Norton a vandut casa id 6 cu 350000 in (29/1/2014) .'),
(680, '[WARNING]: Norton a vandut casa id 6 cu 350000 in (29/1/2014) .'),
(681, '[WARNING]: Norton a vandut casa id 12 cu 250000 in (29/1/2014) .'),
(682, '[WARNING]: Norton a vandut casa id 12 cu 250000 in (29/1/2014) .'),
(683, '[WARNING]: Norton a vandut casa id 18 cu 300000 in (29/1/2014) .'),
(684, '[WARNING]: Norton a vandut casa id 18 cu 300000 in (29/1/2014) .'),
(685, '[WARNING]: Norton a vandut casa id 6 cu 810000 in (29/1/2014) .'),
(686, '[WARNING]: Norton a vandut casa id 6 cu 810000 in (29/1/2014) .'),
(687, '[WARNING]: Norton a vandut casa id 2 cu 750000 in (29/1/2014) .'),
(688, '[WARNING]: Norton a vandut casa id 2 cu 750000 in (29/1/2014) .'),
(689, '[WARNING]: Norton a vandut casa id 19 cu 290000 in (29/1/2014) .'),
(690, '[WARNING]: Norton a vandut casa id 19 cu 290000 in (29/1/2014) .'),
(691, '[WARNING]: Norton a vandut casa id 28 cu 350000 in (29/1/2014) .'),
(692, '[WARNING]: Norton a vandut casa id 28 cu 350000 in (29/1/2014) .'),
(693, '[WARNING]: Norton a vandut casa id 30 cu 370000 in (29/1/2014) .'),
(694, '[WARNING]: Norton a vandut casa id 30 cu 370000 in (29/1/2014) .'),
(695, '[WARNING]: Norton a vandut casa id 34 cu 340000 in (29/1/2014) .'),
(696, '[WARNING]: Norton a vandut casa id 34 cu 340000 in (29/1/2014) .'),
(697, '[WARNING]: Norton a vandut casa id 50 cu 870000 in (29/1/2014) .'),
(698, '[WARNING]: Norton a vandut casa id 50 cu 870000 in (29/1/2014) .'),
(699, '[WARNING]: Norton a vandut casa id 51 cu 550000 in (29/1/2014) .'),
(700, '[WARNING]: Norton a vandut casa id 51 cu 550000 in (29/1/2014) .'),
(701, '[WARNING]: Norton a vandut casa id 53 cu 520000 in (29/1/2014) .'),
(702, '[WARNING]: Norton a vandut casa id 53 cu 520000 in (29/1/2014) .'),
(703, '[WARNING]: Norton a vandut casa id 56 cu 200000 in (29/1/2014) .'),
(704, '[WARNING]: Norton a vandut casa id 56 cu 200000 in (29/1/2014) .'),
(705, '[WARNING]: Norton a vandut casa id 57 cu 200000 in (29/1/2014) .'),
(706, '[WARNING]: Norton a vandut casa id 57 cu 200000 in (29/1/2014) .'),
(707, '[WARNING]: Norton a vandut casa id 58 cu 200000 in (29/1/2014) .'),
(708, '[WARNING]: Norton a vandut casa id 58 cu 860000 in (29/1/2014) .'),
(709, '[WARNING]: Norton a vandut casa id 6 cu 810000 in (29/1/2014) .'),
(710, '[WARNING]: Norton a vandut casa id 6 cu 810000 in (29/1/2014) .'),
(711, '[WARNING]: Norton a vandut casa id 2 cu 750000 in (29/1/2014) .'),
(712, '[WARNING]: Norton a vandut casa id 2 cu 750000 in (29/1/2014) .'),
(713, '[WARNING]: Norton a vandut casa id 19 cu 930000 in (29/1/2014) .'),
(714, '[WARNING]: Norton a vandut casa id 19 cu 930000 in (29/1/2014) .'),
(715, '[WARNING]: Norton a vandut casa id 18 cu 300000 in (29/1/2014) .'),
(716, '[WARNING]: Norton a vandut casa id 18 cu 300000 in (29/1/2014) .'),
(717, '[WARNING]: Norton a vandut casa id 28 cu 780000 in (29/1/2014) .'),
(718, '[WARNING]: Norton a vandut casa id 28 cu 780000 in (29/1/2014) .');

-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `rpgips`
--

CREATE TABLE IF NOT EXISTS `rpgips` (
  `logged_ip` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '0',
  `ip` varchar(32) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Salvarea datelor din tabel `rpgips`
--


-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `sbizz`
--

CREATE TABLE IF NOT EXISTS `sbizz` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Owner` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'NoOne',
  `Message` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'NoOne',
  `Extortion` varchar(50) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT 'No-One',
  `Owned` int(11) NOT NULL DEFAULT '0',
  `EntranceX` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `EntranceY` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `EntranceZ` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `LevelNeeded` int(11) NOT NULL DEFAULT '5',
  `BuyPrice` int(11) NOT NULL DEFAULT '5000000',
  `EntranceCost` int(11) NOT NULL DEFAULT '0',
  `Till` int(11) NOT NULL DEFAULT '0',
  `Locked` int(11) NOT NULL DEFAULT '0',
  `Interior` int(11) NOT NULL DEFAULT '0',
  `Products` int(11) NOT NULL DEFAULT '0',
  `MaxProducts` int(11) NOT NULL DEFAULT '500',
  `PriceProd` int(11) NOT NULL DEFAULT '1',
  `GunPrice` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Salvarea datelor din tabel `sbizz`
--

INSERT INTO `sbizz` (`id`, `Owner`, `Message`, `Extortion`, `Owned`, `EntranceX`, `EntranceY`, `EntranceZ`, `LevelNeeded`, `BuyPrice`, `EntranceCost`, `Till`, `Locked`, `Interior`, `Products`, `MaxProducts`, `PriceProd`, `GunPrice`) VALUES
(1, 'The State', 'Rent Car Los Santos', 'Nimeni', 0, '562.405029', '-1289.995483', '17.248199', 7, 843000, 5000, 148000, 0, 0, 350, 500, 1, 5000),
(2, 'The State', 'Rent Car Las Venturas', 'No-one', 0, '-1968.559814', '296.269592', '35.171901', 5, 690000, 4000, 16000, 0, 0, 484, 500, 1, 1),
(3, 'The State', 'Compania de telefoane', 'No-one', 0, '1777.8619', '-1663.5798', '14.4352', 8, 990000, 0, 60356, 0, 0, 500, 500, 1, 50),
(4, 'The State', 'Petrom', 'No-one', 0, '1048.6896', '2909.6455', '47.8231', 13, 1200000, 200, 40400, 0, 0, 500, 500, 1, 10),
(5, 'The State', 'Sc.Electrica-BN.SRL', 'No-one', 0, '2194.0520', '1991.0134', '12.2969', 6, 750000, 100, 1000, 0, 0, 500, 500, 1, 5),
(6, 'The State', 'la mafiotu', 'No-one', 0, '1102.415649', '-1458.091552', '15.796875', 5, 500000, 20, 0, 0, 0, 450, 500, 1, 0),
(7, 'The State', 'SC.Flux-CompanyIS.SRL', 'Nimeni', 0, '2351.455078', '-1412.284912', '23.992416', 5, 900000, 5000, 88500, 0, 0, 475, 500, 1, 12312),
(8, 'The State', 'CNN Los Santos', 'No-one', 0, '845.007446', '-1046.207397', '25.010288', 5, 1500000, 0, 159900, 1, 0, 500, 500, 2000, 0),
(9, 'The State', 'Tow Car Company', 'No-one', 0, '2510.600097', '-1468.199951', '24.023899', 5, 1300000, 0, 114000, 1, 0, 325, 500, 1, 0),
(10, 'The State', 'Shop 24/7', 'No-one', 0, '999.7089', '-919.8665', '42.3281', 6, 830000, 5000, 10000, 0, 0, 500, 500, 1, 0),
(11, 'The State', 'PaintBall LS', 'No-one', 0, '1310.126586', '-1367.812255', '13.540800', 5, 700000, 600, 10951, 0, 0, 478, 500, 1, 0),
(12, 'The State', 'Rent Kart', 'No-one', 0, '2281.5386', '-2364.6279', '13.5469', 7, 700000, 1000, 50000, 0, 0, 373, 500, 1, 12);

-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `seif`
--

CREATE TABLE IF NOT EXISTS `seif` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Password` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Locationx` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `Locationy` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `Locationz` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `Money` int(11) NOT NULL DEFAULT '0',
  `Drugs` int(11) NOT NULL DEFAULT '0',
  `Mats` int(11) NOT NULL DEFAULT '0',
  `Updates` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=88 ;

--
-- Salvarea datelor din tabel `seif`
--

INSERT INTO `seif` (`id`, `Password`, `Locationx`, `Locationy`, `Locationz`, `Money`, `Drugs`, `Mats`, `Updates`) VALUES
(1, 'police', '1525.550537', '-1677.849365', '5.890625', 1000, 0, 0, 0),
(2, 'fbi', '229.247619', '168.808486', '1003.023437', 1000, 0, 0, 0),
(3, 'armata', '-1371.401489', '499.414947', '11.195305', 1000, 0, 0, 0),
(4, 'medics', '340.467926', '170.200866', '1019.991210', 1000, 0, 0, 0),
(5, 'rromi', '508.693420', '-88.100921', '998.968261', 0, 0, 0, 0),
(6, 'xxl.', '-218.474121', '1402.553955', '27.773437', 0, 0, 0, 0),
(7, 'school', '-2029.797241', '-119.013107', '1035.171875', 1000, 0, 0, 0),
(8, 'hitman', '2204.405029', '1551.674438', '1008.720153', 1000, 0, 0, 0),
(9, '12345', '-2038.175415', '450.371643', '35.172294', 1000, 0, 0, 0),
(10, 'm4', '948.402465', '2104.777343', '1011.023437', 50000, 0, 0, 0),
(11, 'grove', '2318.9031', '-1141.2015', '1050.4922', 1000, 0, 0, 0),
(12, 'ballas', '956.955566', '-53.824592', '1001.117187', 1000, 0, 0, 0),
(13, 'romanian', '1714.141723', '-1641.947509', '27.210319', 1000, 0, 0, 0),
(14, 'clanulcorsicanu', '1091.686157', '2119.944824', '15.350400', 56000, 0, 0, 0),
(15, 'mafia', '-779.588439', '496.572784', '1371.749023', 1000, 0, 0, 0),
(16, 'camataru', '2131.459716', '-2284.340332', '20.671875', 144499, 0, 0, 0),
(22, 'publicma', '1113.010253', '-1520.041503', '15.796875', 0, 0, 0, 0);

-- --------------------------------------------------------

--
-- Structura de tabel pentru tabelul `teritorii`
--

CREATE TABLE IF NOT EXISTS `teritorii` (
  `Id` int(11) NOT NULL AUTO_INCREMENT,
  `Owner` varchar(50) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `Owned` int(11) NOT NULL DEFAULT '0',
  `Time` int(11) NOT NULL DEFAULT '0',
  `PozX1` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `PozY1` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `PozX2` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `PozY2` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `PozX3` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `PozY3` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  `PozZ3` varchar(16) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL DEFAULT '0',
  PRIMARY KEY (`Id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=54 ;

--
-- Salvarea datelor din tabel `teritorii`
--

INSERT INTO `teritorii` (`Id`, `Owner`, `Owned`, `Time`, `PozX1`, `PozY1`, `PozX2`, `PozY2`, `PozX3`, `PozY3`, `PozZ3`) VALUES
(1, '', 11, 16, '163.0400', '-1880.1450', '737.3487', '-1760.6980', '455.9352', '-1828.3522', '5.0931'),
(2, '', 11, 16, '736.9282', '-1759.7719', '933.0042', '-1507.4467', '840.4400', '-1625.7998', '13.5469'),
(3, '', 15, 16, '933.5905', '-1506.8439', '1111.4851', '-1320.6239', '1025.3662', '-1413.9054', '13.1983'),
(4, '', 12, 16, '1114.9269', '-1319.5537', '1339.2557', '-1250.1549', '1236.6138', '-1293.5890', '13.3811'),
(5, '', 12, 16, '1343.3741', '-1245.0864', '1525.5844', '-1118.8281', '1437.5604', '-1169.4203', '23.8233'),
(6, '', 12, 16, '931.7918', '-1749.7734', '1111.1753', '-1502.4296', '1029.8575', '-1624.6360', '13.5545'),
(7, '', 13, 16, '165.5893', '-1761.9724', '403.7011', '-1477.0059', '288.0165', '-1629.7767', '33.3328'),
(8, '', 11, 16, '404.9477', '-1756.8795', '734.7313', '-1514.0535', '552.8819', '-1641.7622', '17.7357'),
(9, '', 12, 16, '1114.1710', '-1743.1848', '1478.4146', '-1504.9559', '1289.8778', '-1630.5051', '13.5469'),
(10, '', 12, 16, '1442.6987', '-1496.8384', '1736.8784', '-1241.5574', '1595.2394', '-1363.1782', '15.6346'),
(11, '', 11, 16, '1115.4885', '-1505.7244', '1337.4388', '-1316.7234', '1226.2299', '-1413.7814', '13.2987'),
(12, '', 12, 16, '1335.8145', '-1502.6924', '1443.2617', '-1250.3501', '1396.2755', '-1389.7827', '13.5547'),
(13, '', 12, 16, '1483.0841', '-1739.5078', '2001.0739', '-1501.5098', '1740.1978', '-1605.9250', '13.5469'),
(14, '', 11, 16, '408.3095', '-1514.0892', '632.6430', '-1206.0892', '521.2031', '-1360.9821', '16.1328'),
(15, '', 15, 16, '637.4127', '-1509.5848', '931.7449', '-1145.6276', '810.1332', '-1338.7557', '13.5394'),
(16, '', 15, 16, '934.5386', '-1317.3862', '1116.7981', '-953.1761', '1041.1298', '-1132.6304', '23.8203'),
(17, '', 13, 16, '1735.8916', '-1497.6073', '2072.1785', '-1103.6862', '1911.4745', '-1268.0631', '14.2378'),
(18, '', 13, 16, '1118.7158', '-1251.8785', '1342.7725', '-958.2072', '1220.6019', '-1097.0184', '25.4280'),
(19, '', 12, 16, '167.0726', '-1473.8569', '409.9028', '-1206.5942', '296.2883', '-1367.4764', '14.0689'),
(20, '', 13, 16, '1346.6598', '-1115.8237', '1542.8467', '-961.5474', '1446.7562', '-1046.5959', '23.8281'),
(21, '', 12, 16, '1140.4087', '-2130.0105', '1452.4508', '-1740.0950', '1298.0092', '-1930.0837', '27.1137'),
(22, '', 11, 16, '978.7590', '857.5315', '1515.7550', '1221.9385', '1244.8314', '1038.1680', '8.3279'),
(23, '', 12, 16, '977.1696', '1214.6228', '1483.1697', '1840.3572', '1250.8322', '1522.9919', '9.5331'),
(24, '', 13, 16, '1519.8223', '864.2476', '2364.5881', '1227.1016', '1951.1855', '1080.8027', '10.8203'),
(25, '', 11, 16, '981.7139', '1842.2311', '1919.9349', '2566.5667', '1483.4138', '2200.1626', '11.0234'),
(26, '', 12, 16, '1485.3845', '1225.5774', '1922.1421', '1841.7742', '1723.3268', '1539.1040', '10.8203'),
(27, '', 11, 16, '1924.2404', '1228.4807', '2370.3345', '2551.1567', '2139.0789', '1886.9655', '10.8227');

/*!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 */;
Edited by CozminKenny
Link to comment
Share on other sites
  • 0
EquiNoxAdv Mentor

EquiNoxAdv

Posted
Posted

Eu nu inteleg. La mine de ce merge totul perfect? Poate am uitat eu ceva si daia n-am mai folosit GameMode. Dar cand am facut pozele totul mergea perfect. In fine , te rog sa verifici toate datele MySqL si din PhpMyAdmin. Uitete atent , ai gresit tu ceva.

j3V8Znq.png

5IGyOAw.png

Link to comment
Share on other sites
  • 0
CozminKenny Rookie

CozminKenny

Posted
  • Author
Posted (edited)

Nu ai conectat server-ul la baza de date, trebuie sa-l conectezi . Urci baza de date in phpmyadmin apoi in gamemode ii faci setarile bazei de date .

Eu cred ca tu nu ai citit ce am scris eu mai sus, am conectat deja serverul la baza de date.

 

 

EDIT : Cer T/C , am rezolvat problema. Va multumesc mult pentru cei care ati incercat macar sa ma ajutati !

Edited by CozminKenny
Link to comment
Share on other sites
Guest
This topic is now closed to further replies.
 Share
Go to question listing
×
×
  • Create New...

Important Information

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