MegaEvo Edit by Help3R =)

[Ashario12]

Odp: MegaEvo Edit by Help3R =)

jak odpalic ten silnik?

 

[Help3R]

Odp: MegaEvo Edit by Help3R =)

jak odpalic ten silnik?

Witaj! Nie jest to silnik trudny do odpalenia. Je?eli jeste? pocz?tkuj?c? osob? w stawianiu serwer?w sql poczytaj sobie poradniki, na kt?rych nawet ja zaczyna?em stawia? pierwsze ots'y.
?ap poradniki, dzi?ki nim z pewno?ci? odpalisz serwer.

• http://tibia.net.pl/konfiguracja/66...heforgottenserver-i-gesior-account-maker.html
• http://tibia.net.pl/konfiguracja/45...czac-theforgottenserver-xampp-phpmyadmin.html

jak to naprawi??

mysql_real_query(): DELETE FROM `guild_wars` WHERE `status` = 0 AND `begin` < 1331559375; - MYSQL ERROR: Table 'theforgottenserver.guild_wars' doesn't exist (1146)
mysql_real_query(): UPDATE `guild_wars` SET `status` = 5, `end` = 1331732175 WHERE `status` = 1 AND `end` > 0 AND `end` < 1331732175; - MYSQL ERROR: Table 'theforgottenserver.guild_wars' doesn't exist (1146)

B??d z guild_wars naprawiasz w bazie danych dodaj?c zapytania sql:

CREATE TABLE IF NOT EXISTS `guild_wars` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `guild_id` INT NOT NULL,
  `enemy_id` INT NOT NULL,
  `begin` BIGINT NOT NULL DEFAULT '0',
  `end` BIGINT NOT NULL DEFAULT '0',
  `frags` INT UNSIGNED NOT NULL DEFAULT '0',
  `payment` BIGINT UNSIGNED NOT NULL DEFAULT '0',
  `guild_kills` INT UNSIGNED NOT NULL DEFAULT '0',
  `enemy_kills` INT UNSIGNED NOT NULL DEFAULT '0',
  `status` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `status` (`status`),
  KEY `guild_id` (`guild_id`),
  KEY `enemy_id` (`enemy_id`)
) ENGINE=InnoDB;

ALTER TABLE `guild_wars`
  ADD CONSTRAINT `guild_wars_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `guild_wars_ibfk_2` FOREIGN KEY (`enemy_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;

ALTER TABLE `guilds` ADD `balance` BIGINT UNSIGNED NOT NULL AFTER `motd`;

CREATE TABLE IF NOT EXISTS `guild_kills` (
  `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
  `guild_id` INT NOT NULL,
  `war_id` INT NOT NULL,
  `death_id` INT NOT NULL
) ENGINE = InnoDB;

ALTER TABLE `guild_kills`
  ADD CONSTRAINT `guild_kills_ibfk_1` FOREIGN KEY (`war_id`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `guild_kills_ibfk_2` FOREIGN KEY (`death_id`) REFERENCES `player_deaths` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `guild_kills_ibfk_3` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;

ALTER TABLE `killers` ADD `war` INT NOT NULL DEFAULT 0;

Je?eli kto? z was ma problem z Cannot find "monster" polega on na tym, ?e nie mo?e znale?? monster?w lub npc. Ten b??d mo?na naprawi? otwieraj?c map? i importuj?c ka?dego potwora / NPC z silnika do map edytora.
Pozdrawiam, Help3R.

 

[maximilian100]

Odp: MegaEvo Edit by Help3R =)

Nie mo?e odczyta? items.otb co zrobic?
[Error - Items::loadFromOtb] Another (client) version of items.otb is required.

[18:55:59.118] > ERROR: Unable to load items (OTB)!
heforgottenserver: /usr/include/boost/thread/pthread/condition_variable_fwd.hpp:38: boost::condition_variable::~condition_variable(): Assertion `!pthread_cond_destroy(&cond)' failed.

 

[Tsuna]

Odp: MegaEvo Edit by Help3R =)

wi?kszego spamu w ?yciu nie widzia?em

Notka moderatorska:

Ja r?wnie?. //wujush

 

[emqq]

Odp: MegaEvo Edit by Help3R =)

dzi?ki Help3R wszystko dzia?a

 

[Ashario12]

Odp: MegaEvo Edit by Help3R =)

?wietny silnik i acc Help3r, postawi?em juz swoj ots, teraz mysle nad dedykiem
Forgotten 8.60 - Newsy <= twoja acc, tylko obrazki inne

 

[Maly Simon]

Odp: MegaEvo Edit by Help3R =)

Dzi?kuje bardzo mi si? przyda? tw?j silnik 10/10

 

[Ronnix]

Odp: MegaEvo Edit by Help3R =)

sa pliki source do tego ots juz? jak sa to mozna wstawke??;P

 

[Ronnix]

Odp: MegaEvo Edit by Help3R =)

Sorry za spam.
Wywala mi taki blad podczas tworzenia bazy danych. Silnik mam stad, korzystam z poradnika zamieszczonego wyzej. Wie ktos o co tu chodzi?

B??d

zapytanie SQL:

CREATE TABLE `z_ots_comunication` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`name` varchar( 255 ) NOT NULL ,
`type` varchar( 255 ) NOT NULL ,
`action` varchar( 255 ) NOT NULL ,
`param1` varchar( 255 ) NOT NULL ,
`param2` varchar( 255 ) NOT NULL ,
`param3` varchar( 255 ) NOT NULL ,
`param4` varchar( 255 ) NOT NULL ,
`param5` varchar( 255 ) NOT NULL ,
`param6` varchar( 255 ) NOT NULL ,
`param7` varchar( 255 ) NOT NULL ,
`delete_it` int( 2 ) NOT NULL default '1',
PRIMARY KEY ( `id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1;

MySQL zwr?ci? komunikat: Dokumentacja
#1105 - MyISAM table 'z_ots_comunication' is in use (most likely by a MERGE table). Try FLUSH TABLES.

 

[fujinraizo]

Odp: MegaEvo Edit by Help3R =)

Mapa ma duzo nie dociagniec oraz kilka bled?w

 

[Grecky]

Odp: MegaEvo Edit by Help3R =)

tak tylko wirusy sa. po miechu mi rozwalil kompa a lagi...

 

[Help3R]

Odp: MegaEvo Edit by Help3R =)

tak tylko wirusy sa. po miechu mi rozwalil kompa a lagi...

Przeskanuj i wrzu? skan, nie moja wina, ?e pobierasz inne pliki przez kt?re masz problemy.

 

[kamilojox]

Odp: MegaEvo Edit by Help3R =)

Poprostu full wypas...Zrub nowa aktualizacje i dodaj moze system reb albo co? nowego i fajniejszego..A silniczek 10/10

 

[drakon000]

witam jak mog? naprawi? b??d z acc makerem
Notice: Undefined index: page in C:\xampp\htdocs\install.php on line 40

Notice: Undefined index: page in C:\xampp\htdocs\install.php on line 53

Notice: Undefined index: page in C:\xampp\htdocs\install.php on line 69

czy ten acc maker nie dzia?a czy co je?eli kto? wie to prosi?bym o odpowied? dodaje ca?y install php w razie czego dzi?ki z g?ry.

<?PHP
$config['site'] = parse_ini_file('config/config.ini');
session_start();
//save config in ini file
function saveconfig_ini($config) {
$file = fopen("config/config.ini", "w");
foreach($config as $param => $data) {
$file_data .= $param.' = "'.str_replace('"', '', $data).'"
';
}
rewind($file);
fwrite($file, $file_data);
fclose($file);
}

function check_password($pass)
{
  $temp = strspn("$pass", "qwertyuiopasdfghjklzxcvbnmQWERTYUIOPASDFGHJKLZXCVBNM1234567890");
  if ($temp != strlen($pass)) {
  return false;
  }
  else
  {
  $ok = "/[a-zA-Z0-9]{1,40}/";
  return (preg_match($ok, $pass))? true: false;
  }
}

function password_ency($password)
{
	$ency = $GLOBALS['passwordency'];
	if($ency == 'sha1')
		return sha1($password);
	elseif($ency == 'md5')
		return md5($password);
	elseif($ency == '')
		return $password;
}

if($_REQUEST['page'] == '' && !isset($_REQUEST['step'])) {
echo '<html>
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-2" />
	<title>Instalacja Menadzera Kont</title>
</head>
<frameset cols="230,*">
	<frame name="menu" src="install.php?page=menu" />
	<frame name="step" src="install.php?page=step&step=0" />
	<noframes><body>Twoja przegladarka nie obsluguje ramek</body></noframes>
</frameset>
</html>';
}
if($_REQUEST['page'] == 'menu') {
echo '<h2>MENU</h2><br>
<b>Jezeli nie zainstalowany:</b><br>
<a href="install.php?page=step&step=start" target="step">0. Informacje</a><br>
<a href="install.php?page=step&step=1" target="step">1. Wskaz miejsce silnika OTS</a><br>
<a href="install.php?page=step&step=2" target="step">2. Sprawdz polaczenie z baza danych</a><br>
<a href="install.php?page=step&step=3&server_conf=yes" target="step">3. Dodaj kolumny i tabele do bazy danych</a><br>
<a href="install.php?page=step&step=4&server_conf=yes" target="step">4. Dodaj ustawienia domyslne do bazy danych</a><br>
<a href="install.php?page=step&step=5&server_conf=yes" target="step">5. Ustaw konto administratora</a><br>
<b>Dla Administracji:</b><br>
<a href="index.php?subtopic=adminpanel&action=install_monsters" target="step">6. Zaladuj -monsters- z twojego OTSa</a><br>
<a href="index.php?subtopic=adminpanel&action=install_spells" target="step">7. Zaladuj -spells- z twojego OTSa</a><br>
<a href="auctionsystem/instalacja.htm" target="_blank">8. Dokoncz konfiguracje systemu aukcji</a><br>
<a href="text.htm" target="_blank">8. Stw?rz napis na logo! po stworzeniu, zapisz go i zamie? z images/napis.png!!</a><br>';

}
if($_REQUEST['page'] == 'step') {
if($config['site']['install'] != "no") {
if($_REQUEST['server_conf'] == 'yes' || ($_REQUEST['step'] > 2 && $_REQUEST['step'] < 6)) {
//load server config
$config['server'] = parse_ini_file($config['site']['server_path'].'config.lua');
if(isset($config['server']['mysqlHost'])) {
//new (0.2.6+) ots config.lua file
$mysqlhost = $config['server']['mysqlHost'];
$mysqluser = $config['server']['mysqlUser'];
$mysqlpass = $config['server']['mysqlPass'];
$mysqldatabase = $config['server']['mysqlDatabase'];
}
elseif(isset($config['server']['sqlHost'])) {
//old (0.2.4) ots config.lua file
$mysqlhost = $config['server']['sqlHost'];
$mysqluser = $config['server']['sqlUser'];
$mysqlpass = $config['server']['sqlPass'];
$mysqldatabase = $config['server']['sqlDatabase'];
}
$sqlitefile = $config['server']['sqliteDatabase'];
$passwordency = '';
if(strtolower($config['server']['useMD5Passwords']) == 'yes' || strtolower($config['server']['passwordType']) == 'md5') {
	$passwordency = 'md5';
}
if(strtolower($config['server']['passwordType']) == 'sha1') {
	$passwordency = 'sha1';
}
// loads #####POT mainfile#####
include('pot/OTS.php');
// PDO and POT connects to database
$ots = POT::getInstance();
if(strtolower($config['server']['sqlType']) == "mysql")
{
	//connect to MySQL database
	try
	{
		$ots->connect(POT::DB_MYSQL, array('host' => $mysqlhost, 'user' => $mysqluser, 'password' => $mysqlpass, 'database' => $mysqldatabase) );
	}
	catch(PDOException $error)
	{
	    echo 'Nie mozna polaczyc sie z baza danych MySql, mozliwe powody:<br>1. MySQL nie jest uruchomiony.<br>2. MySQL nie jest skonfigurowany w: <b>'.$config['site']['server_path'].'config.lua</b> .<br>3. MySQL uzytkownik, haslo lub host nie sa poprawne.';
		exit;
	}
}
elseif(strtolower($config['server']['sqlType']) == "sqlite")
{
	//connect to SQLite database
	$link_to_sqlitedatabase = $config['site']['server_path'].$sqlitefile;
	try
	{
		$ots->connect(POT::DB_SQLITE, array('database' => $link_to_sqlitedatabase));
	}
	catch(PDOException $error)
	{
	    echo 'Nie mozna otworzyc bazy danych SqlLite, mozliwe powody:<br><b>'.$link_to_sqlitedatabase.'</b> - plik jest nie wlasciwy lub uszkodzony.<br><b>'.$link_to_sqlitedatabase.'</b> - lub nie istnieje.';
		exit;
	}
}
else
{
	echo 'Nie znany typ bazy danych w <b>'.$config['site']['server_path'].'config.lua</b> . Musi byc: "<b>mysql</b>" lub "<b>sqlite</b>". Teraz jest: "<b>'.strtolower($config['server']['sqlType']).'"</b>';
	exit;
}
$SQL = POT::getInstance()->getDBHandle();
}
$step = $_REQUEST['step'];
if(empty($step)) {
$step = $config['site']['install'];
}
if($step == 'start') {
echo '<h1>Stan: '.$step.'</h1>Informacje<br>';
echo 'Witaj w konfiguracji mendazera. <b>Przeprowadzimy cie przez caly kreator Kliknij Krok 1.</b>';
}
if($step == '1') {
if(isset($_REQUEST['server_path'])) {
	echo '<h1>Stan: '.$step.'</h1>Sprawdzanie konfiguracji servera<br>';
	$config['site']['server_path'] = $_REQUEST['server_path'];
	$config['site']['server_path'] = trim($config['site']['server_path'])."\\";
	$config['site']['server_path'] = str_replace("\\\\", "/", $config['site']['server_path']);
	$config['site']['server_path'] = str_replace("\\", "/", $config['site']['server_path']);
	$config['site']['server_path'] = str_replace("//", "/", $config['site']['server_path']);
	saveconfig_ini($config['site']);
	if(file_exists($config['site']['server_path'].'config.lua')) {
		$config['server'] = parse_ini_file($config['site']['server_path'].'config.lua');
		if(isset($config['server']['sqlType'])) {
			$config['site']['install'] = 2;
			saveconfig_ini($config['site']);
			echo 'Plik <b>config.lua</b> zaladowany z <font color="red"><i>'.$config['site']['server_path'].'config.lua</i></font> pomyslnie. Teraz mozesz przejsc do sprawdzania polaczenia z baza danych('.$config['server']['sqlType'].') : <a href="install.php?page=step&step=2">Przejdz Dalej</a>';
		}
		else
		{
			echo 'Plik <b>config.lua</b> zaladowany z <font color="red"><i>'.$config['site']['server_path'].'config.lua</i></font> nie jest poprawnym TFS config.lua. <a href="install.php?page=step&step=1">Wroc by wybrac inny katalog</a> Mozliwe, ze uzywasz mocno edytowanego TFSa.';
		}
	}
	else
	{
		echo 'Nie mozna zaladowac <b>config.lua</b> z <font color="red"><i>'.$config['site']['server_path'].'config.lua</i></font> Nie mozna odnalesc pliku. <a href="install.php?page=step&step=1">Wroc by wybrac inny katalog.</a>';
	}
}
else
{
echo 'Wpisz adres silnika TFS naprzyklad: <i>C:\Documents and Settings\xxx\Desktop\TFS 0.2.9\</i><form action="install.php">
<input type="text" name="server_path" size="90" value="'.$config['site']['server_path'].'" /><input type="hidden" name="page" value="step" /><input type="hidden" name="step" value="1" /><input type="submit" value="Ustaw miejsce silnika" />
</form>';
}
}
if($step == '2') {
echo '<h1>Stan '.$step.'</h1>Sprawdzanie polaczenia z baza danych<br>';
echo 'Jezeli nie widzisz bledow kliknij <a href="install.php?page=step&step=3&server_conf=yes">Przejdz dalej</a>. Jezeli widzisz bledy znaczy, ze masz zle skonfigurowany OTS.';
//load server config
$config['server'] = parse_ini_file($config['site']['server_path'].'config.lua');
if(isset($config['server']['mysqlHost'])) {
//new (0.2.6+) ots config.lua file
$mysqlhost = $config['server']['mysqlHost'];
$mysqluser = $config['server']['mysqlUser'];
$mysqlpass = $config['server']['mysqlPass'];
$mysqldatabase = $config['server']['mysqlDatabase'];
}
elseif(isset($config['server']['sqlHost'])) {
//old (0.2.4) ots config.lua file
$mysqlhost = $config['server']['sqlHost'];
$mysqluser = $config['server']['sqlUser'];
$mysqlpass = $config['server']['sqlPass'];
$mysqldatabase = $config['server']['sqlDatabase'];
}
$sqlitefile = $config['server']['sqliteDatabase'];
$passwordency = '';
if(strtolower($config['server']['useMD5Passwords']) == 'yes' || strtolower($config['server']['passwordType']) == 'md5') {
	$passwordency = 'md5';
}
if(strtolower($config['server']['passwordType']) == 'sha1') {
	$passwordency = 'sha1';
}
// loads #####POT mainfile#####
include('pot/OTS.php');
// PDO and POT connects to database
$ots = POT::getInstance();
if(strtolower($config['server']['sqlType']) == "mysql")
{
	//connect to MySQL database
	try
	{
		$ots->connect(POT::DB_MYSQL, array('host' => $mysqlhost, 'user' => $mysqluser, 'password' => $mysqlpass, 'database' => $mysqldatabase) );
	}
	catch(PDOException $error)
	{
	    echo 'Nie mozna polaczyc sie z baza danych MySql, mozliwe powody:<br>1. MySQL nie jest uruchomiony.<br>2. MySQL nie jest skonfigurowany w: <b>'.$config['site']['server_path'].'config.lua</b> .<br>3. MySQL uzytkownik, haslo lub host nie sa poprawne.';
		exit;
	}
}
elseif(strtolower($config['server']['sqlType']) == "sqlite")
{
	//connect to SQLite database
	$link_to_sqlitedatabase = $config['site']['server_path'].$sqlitefile;
	try
	{
		$ots->connect(POT::DB_SQLITE, array('database' => $link_to_sqlitedatabase));
	}
	catch(PDOException $error)
	{
	    echo 'Nie mozna otworzyc bazy danych SqlLite, mozliwe powody:<br><b>'.$link_to_sqlitedatabase.'</b> - plik jest nie wlasciwy lub uszkodzony.<br><b>'.$link_to_sqlitedatabase.'</b> - lub nie istnieje.';
		exit;
	}
}
else
{
	echo 'Nie znany typ bazy danych w <b>'.$config['site']['server_path'].'config.lua</b> . Musi byc: "<b>mysql</b>" lub "<b>sqlite</b>". Teraz jest: "<b>'.strtolower($config['server']['sqlType']).'"</b>';
	exit;
}
$SQL = POT::getInstance()->getDBHandle();
$config['site']['install'] = 3;
saveconfig_ini($config['site']);
}
if($step == '3') {
echo '<h1>Stan '.$step.'</h1>Dodawanie kolumn i tablic do bazy danych<br>';
echo 'Instalator sprobuje dodac nowe tablice i kolumny do bazy danych.<br>';
		$config['server'] = parse_ini_file($config['site']['server_path'].'config.lua');
		if($config['server']['sqlType'] == "sqlite") {
			//if sqlite
			try { $SQL->query('ALTER TABLE accounts ADD "key" VARCHAR(255) NOT NULL DEFAULT "";'); } catch(PDOException $error) {}
			try { $SQL->query('ALTER TABLE accounts ADD "page_lastday" INTEGER(11) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}
			try { $SQL->query('ALTER TABLE accounts ADD "email_new" VARCHAR(255) NOT NULL DEFAULT "";'); } catch(PDOException $error) {}
			try { $SQL->query('ALTER TABLE accounts ADD "email_new_time" INTEGER(15) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}
			try { $SQL->query('ALTER TABLE accounts ADD "created" INTEGER(11) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}
			try { $SQL->query('ALTER TABLE accounts ADD "rlname" VARCHAR(255) NOT NULL DEFAULT "";'); } catch(PDOException $error) {}
			try { $SQL->query('ALTER TABLE accounts ADD "location" VARCHAR(255) NOT NULL DEFAULT "";'); } catch(PDOException $error) {}
			try { $SQL->query('ALTER TABLE accounts ADD "page_access" INTEGER(11) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}

			try { $SQL->query('ALTER TABLE accounts ADD "email_code" VARCHAR(255) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}
			try { $SQL->query('ALTER TABLE accounts ADD "next_email" INTEGER(11) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}
			try { $SQL->query('ALTER TABLE accounts ADD "premium_points" INTEGER(11) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}
			echo "Added columns to table <b>accounts</b>.<br/>";
			try { $SQL->query('ALTER TABLE guilds ADD "description" TEXT NOT NULL DEFAULT "";'); } catch(PDOException $error) {}
			try { $SQL->query('ALTER TABLE guilds ADD "logo_gfx_name" VARCHAR(255) NOT NULL DEFAULT "";'); } catch(PDOException $error) {}
			echo "Added columns to table <b>guilds</b>.<br/>";
			try { $SQL->query('ALTER TABLE players ADD "online" INTEGER(11) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}
			try { $SQL->query('ALTER TABLE players ADD "created" INTEGER(11) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}
			try { $SQL->query('ALTER TABLE players ADD "nick_verify" INTEGER(11) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}
			try { $SQL->query('ALTER TABLE players ADD "old_name" VARCHAR(255) NOT NULL DEFAULT "";'); } catch(PDOException $error) {}
			try { $SQL->query('ALTER TABLE players ADD "hide_char" INTEGER(11) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}
			try { $SQL->query('ALTER TABLE players ADD "comment" TEXT NOT NULL DEFAULT "";'); } catch(PDOException $error) {}
			try { $SQL->query('ALTER TABLE players ADD "auction_balance" INTEGER(11) NOT NULL DEFAULT 0;'); } catch(PDOException $error) {}
			echo "Dodawanie kolumn do <b>players</b>.<br/>";
			try { $SQL->query('CREATE TABLE "z_news_big" (
						"hide_news" INTEGER NOT NULL DEFAULT 0,
						"date" INTEGER NOT NULL,
						"author" VARCHAR(255) NOT NULL,
						"author_id" INTEGER NOT NULL,
						"image_id" INTEGER NOT NULL DEFAULT 0,
						"topic" VARCHAR(255) NOT NULL,
						"text" TEXT NOT NULL);'); } catch(PDOException $error) {}
			echo "Dodawanie tablic <b>z_news_big</b> (news).<br/>";
			try { $SQL->query('CREATE TABLE "z_news_tickers" (
						"date" INTEGER NOT NULL,
						"author" INTEGER NOT NULL,
						"image_id" INTEGER NOT NULL DEFAULT 0,
						"text" TEXT NOT NULL,
						"hide_ticker" INTEGER NOT NULL DEFAULT 0);'); } catch(PDOException $error) {}
			echo "Dodawanie tablic <b>z_news_tickers</b> (tickers).<br/>";
			try { $SQL->query('CREATE TABLE "z_spells" (
						"name" VARCHAR(255) NOT NULL,
						"spell" VARCHAR(255) NOT NULL,
						"spell_type" VARCHAR(255) NOT NULL,
						"mana" INTEGER NOT NULL DEFAULT 0,
						"lvl" INTEGER NOT NULL DEFAULT 0,
						"mlvl" INTEGER NOT NULL DEFAULT 0,
						"soul" INTEGER NOT NULL DEFAULT 0,
						"pacc" VARCHAR(255) NOT NULL,
						"vocations" VARCHAR(255) NOT NULL,
						"conj_count" INTEGER NOT NULL DEFAULT 0,
						"hide_spell" INTEGER NOT NULL DEFAULT 0);'); } catch(PDOException $error) {}
			echo "Dodawanie tablic <b>z_spells</b> (spells list).<br/>";
			try { $SQL->query('CREATE TABLE "z_monsters" (
			  "hide_creature" INTEGER NOT NULL DEFAULT 0,
			  "name" VARCHAR(255) NOT NULL,
			  "mana" INTEGER NOT NULL,
			  "exp" INTEGER NOT NULL,
			  "health" INTEGER NOT NULL,
			  "speed_lvl" INTEGER NOT NULL DEFAULT 1,
			  "use_haste" INTEGER NOT NULL,
			  "voices" text NOT NULL,
			  "immunities" VARCHAR(255) NOT NULL,
			  "summonable" INTEGER NOT NULL,
			  "convinceable" INTEGER NOT NULL,
			  "race" VARCHAR(255) NOT NULL,
			  "gfx_name" VARCHAR(255) NOT NULL)'); } catch(PDOException $error) {}
			echo "Dodawanie tablic <b>z_monsters</b> (monsters list).<br/>";
		}
		elseif($config['server']['sqlType'] == "mysql")
		{
			//if mysql
			echo "<h3>Dodawanie kolumn <b>accounts</b></h3>";
			try { $SQL->query("ALTER TABLE `accounts` ADD `key` VARCHAR( 20 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>key</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>key</b> to table <b>accounts</b>, already exist?<br/>";}
			try { $SQL->query("ALTER TABLE `accounts` ADD `page_lastday` INT( 11 ) NOT NULL;"); echo "<font color=\"green\">Added column</font> <b>page_lastday</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>page_lastday</b> to table <b>accounts</b>, already exist?<br/>";}
			try { $SQL->query("ALTER TABLE `accounts` ADD `email_new` VARCHAR( 255 ) NOT NULL;"); echo "<font color=\"green\">Added column</font> <b>email_new</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>email_new</b> to table <b>accounts</b>, already exist?<br/>";}
			try { $SQL->query("ALTER TABLE `accounts` ADD `email_new_time` INT( 15 ) NOT NULL;"); echo "<font color=\"green\">Added column</font> <b>email_new_time</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>email_new_time</b> to table <b>accounts</b>, already exist?<br/>";}
			try { $SQL->query("ALTER TABLE `accounts` ADD `created` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>created</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>created</b> to table <b>accounts</b>, already exist?<br/>";}
			try { $SQL->query("ALTER TABLE `accounts` ADD `rlname` VARCHAR( 255 ) NOT NULL DEFAULT '';"); echo "<font color=\"green\">Added column</font> <b>rlname</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>rlname</b> to table <b>accounts</b>, already exist?<br/>";}
			try { $SQL->query("ALTER TABLE `accounts` ADD `location` VARCHAR( 255 ) NOT NULL DEFAULT '';"); echo "<font color=\"green\">Added column</font> <b>location</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>location</b> to table <b>accounts</b>, already exist?<br/>";}
			try { $SQL->query("ALTER TABLE `accounts` ADD `page_access` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>page_access</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>page_access</b> to table <b>accounts</b>, already exist?<br/>";}
			try { $SQL->query("ALTER TABLE `accounts` ADD `email_code` VARCHAR( 255 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>email_code</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>email_code</b> to table <b>accounts</b>, already exist?<br/>";}
			try { $SQL->query("ALTER TABLE `accounts` ADD `next_email` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>next_email</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>next_email</b> to table <b>accounts</b>, already exist?<br/>";}
			try { $SQL->query("ALTER TABLE `accounts` ADD `premium_points` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>premium_points</b> to table <b>accounts</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>premium_points</b> to table <b>accounts</b>, already exist?<br/>";}
			echo "<h3>Add columns to table <b>guilds</b></h3>";
			try { $SQL->query('ALTER TABLE `guilds` ADD `description` TEXT NOT NULL DEFAULT "";'); echo "<font color=\"green\">Added column</font> <b>description</b> to table <b>guilds</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>description</b> to table <b>guilds</b>, already exist?<br/>";}
			try { $SQL->query('ALTER TABLE `guilds` ADD `logo_gfx_name` VARCHAR( 255 ) NOT NULL DEFAULT "";'); echo "<font color=\"green\">Added column</font> <b>logo_gfx_name</b> to table <b>guilds</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>logo_gfx_name</b> to table <b>guilds</b>, already exist?<br/>";}
			echo "<h3>Add columns to table <b>players</b></h3>";
			try { $SQL->query("ALTER TABLE `players` ADD `online` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>online</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>online</b> to table <b>players</b>, already exist?<br/>";}
			try { $SQL->query("ALTER TABLE `players` ADD `created` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>created</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>created</b> to table <b>players</b>, already exist?<br/>";}
			try { $SQL->query("ALTER TABLE `players` ADD `nick_verify` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>nick_verify</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>nick_verify</b> to table <b>players</b>, already exist?<br/>";}
			try { $SQL->query("ALTER TABLE `players` ADD `old_name` VARCHAR( 255 ) NOT NULL DEFAULT '';"); echo "<font color=\"green\">Added column</font> <b>old_name</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>old_name</b> to table <b>players</b>, already exist?<br/>";}
			try { $SQL->query("ALTER TABLE `players` ADD `hide_char` INT( 11 ) NOT NULL DEFAULT '0';"); echo "<font color=\"green\">Added column</font> <b>hide_char</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>hide_char</b> to table <b>players</b>, already exist?<br/>";}
			try { $SQL->query("ALTER TABLE `players` ADD `comment` TEXT NOT NULL;"); echo "<font color=\"green\">Added column</font> <b>comment</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>comment</b> to table <b>players</b>, already exist?<br/>";}
			try { $SQL->query("ALTER TABLE `accounts` ADD `vote` INT( 11 ) NOT NULL;"); echo "<font color=\"green\">Added column</font> <b>vote</b> to table <b>players</b><br />";} catch(PDOException $error) { echo "<font color=\"red\">Can't add column</font> <b>vote</b> to table <b>players</b>, already exist?<br/>";}
			echo "<h3>Dodawanie nowych tablic</h3>";
			try { $SQL->query("CREATE TABLE `z_news_big` (
						`hide_news` tinyint(1) NOT NULL DEFAULT '0',
						`date` int(11) NOT NULL DEFAULT '0',
						`author` varchar(255) NOT NULL,
						`author_id` int(11) NOT NULL,
						`image_id` int(3) NOT NULL DEFAULT '0',
						`topic` varchar(255) NOT NULL,
						`text` text NOT NULL
						) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
						echo '<font color=\"green\">Added table <b>z_news_big</b></font><br/>';
					} catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_news_big</b> not added.</font> Already exist?<br/>";}
			try { $SQL->query("CREATE TABLE `auction_system` (
						`id` int(11) NOT NULL auto_increment,
						`player` int(11) NOT NULL,
						`item_id` int(11) NOT NULL,
						`item_name` varchar(255) NOT NULL,
						`count` int(11) NOT NULL,
						`cost` int(11) NOT NULL,
						`date` int(11) NOT NULL,
						PRIMARY KEY  (`id`)
						) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;");
			echo "<font color=\"gren\">Added table <b>auction_system</b> (system aukcji).<br/>";
			 } catch(PDOException $error) {echo "<font color=\"red\">Table <b>auction_system</b> not added.</font> Already exist?<br/>";}
			try { $SQL->query("CREATE TABLE `z_news_tickers` (
						`date` int(11) NOT NULL default '1',
						`author` int(11) NOT NULL,
						`image_id` int(3) NOT NULL default '0',
						`text` text NOT NULL,
						`hide_ticker` tinyint(1) NOT NULL
						) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
						echo '<font color=\"green\">Added table <b>z_news_tickers</b></font><br/>';
					} catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_news_tickers</b> not added.</font> Already exist?<br/>";}
			try { $SQL->query('CREATE TABLE `z_spells` (
						`name` VARCHAR(255) NOT NULL,
						`spell` VARCHAR(255) NOT NULL,
						`spell_type` VARCHAR(255) NOT NULL,
						`mana` INTEGER NOT NULL DEFAULT 0,
						`lvl` INTEGER NOT NULL DEFAULT 0,
						`mlvl` INTEGER NOT NULL DEFAULT 0,
						`soul` INTEGER NOT NULL DEFAULT 0,
						`pacc` VARCHAR(255) NOT NULL,
						`vocations` VARCHAR(255) NOT NULL,
						`conj_count` INTEGER NOT NULL DEFAULT 0,
						`hide_spell` INTEGER NOT NULL DEFAULT 0);');
					echo '<font color=\"green\">Added table <b>z_spells</b></font><br/>';
					} catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_spells</b> not added.</font> Already exist?<br/>";}
			try { $SQL->query('CREATE TABLE `z_monsters` (
			  `hide_creature` tinyint(1) NOT NULL default \'0\',
			  `name` varchar(255) NOT NULL,
			  `mana` int(11) NOT NULL,
			  `exp` int(11) NOT NULL,
			  `health` int(11) NOT NULL,
			  `speed_lvl` int(11) NOT NULL default \'1\',
			  `use_haste` tinyint(1) NOT NULL,
			  `voices` text NOT NULL,
			  `immunities` varchar(255) NOT NULL,
			  `summonable` tinyint(1) NOT NULL,
			  `convinceable` tinyint(1) NOT NULL,
			  `race` varchar(255) NOT NULL,
			  `gfx_name` varchar(255) NOT NULL
			) ENGINE=MyISAM DEFAULT CHARSET=latin1;'); 
			echo"<font color=\"green\">Added table <b>z_monsters</b></font><br/>";
			} catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_monsters</b> not added.</font> Already exist?<br/>";}
			try { $SQL->query("CREATE TABLE `z_ots_comunication` (
 					      `id` int(11) NOT NULL auto_increment,
 					      `name` varchar(255) NOT NULL,
  					      `type` varchar(255) NOT NULL,
 					      `action` varchar(255) NOT NULL,
  					      `param1` varchar(255) NOT NULL,
 					      `param2` varchar(255) NOT NULL,
 					      `param3` varchar(255) NOT NULL,
 					      `param4` varchar(255) NOT NULL,
 					      `param5` varchar(255) NOT NULL,
 					      `param6` varchar(255) NOT NULL,
 					      `param7` varchar(255) NOT NULL,
 					      `delete_it` int(2) NOT NULL default '1',
  					       PRIMARY KEY  (`id`)
 					    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;");
			echo "<font color=\"green\">Added table <b>z_ots_comunication</b> (shopsystem).<br/></font>";
			}
			catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_ots_comunication</b> not added.</font> Already exist?<br/>";}
			try { $SQL->query("CREATE TABLE `z_shop_offer` (
 					      `id` int(11) NOT NULL auto_increment,
 					      `points` int(11) NOT NULL default '0',
 					      `itemid1` int(11) NOT NULL default '0',
 					      `count1` int(11) NOT NULL default '0',
 					      `itemid2` int(11) NOT NULL default '0',
 					      `count2` int(11) NOT NULL default '0',
 					      `offer_type` varchar(255) default NULL,
 					      `offer_description` text NOT NULL,
 					      `offer_name` varchar(255) NOT NULL,
 					      `pid` INT(11) NOT NULL DEFAULT '0',  
 					      PRIMARY KEY  (`id`)
 					    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;");
			echo "<font color=\"green\">Added table <b>z_shop_offer</b> (shopsystem).<br/></font>";
			}
			catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_shop_offer</b> not added.</font> Already exist?<br/>";}
			try { $SQL->query("CREATE TABLE `z_shop_history_item` (
 					      `id` int(11) NOT NULL auto_increment,
 					      `to_name` varchar(255) NOT NULL default '0',
    					      `to_account` int(11) NOT NULL default '0',
   					      `from_nick` varchar(255) NOT NULL,
 					      `from_account` int(11) NOT NULL default '0',
 					      `price` int(11) NOT NULL default '0',
 					      `offer_id` int(11) NOT NULL default '0',
 					      `trans_state` varchar(255) NOT NULL,
 					      `trans_start` int(11) NOT NULL default '0',
 					      `trans_real` int(11) NOT NULL default '0',
 					      PRIMARY KEY  (`id`)
 					    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;");
			echo "<font color=\"green\">Added table <b>z_shop_history_item</b> (shopsystem).<br/></font>";
			}
			catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_shop_history_item</b> not added.</font> Already exist?<br/>";}
			try { $SQL->query("CREATE TABLE `z_shop_history_pacc` (
 					      `id` int(11) NOT NULL auto_increment,
 					      `to_name` varchar(255) NOT NULL default '0',
 					      `to_account` int(11) NOT NULL default '0',
 					      `from_nick` varchar(255) NOT NULL,
 					      `from_account` int(11) NOT NULL default '0',
 					      `price` int(11) NOT NULL default '0',
 					      `pacc_days` int(11) NOT NULL default '0',
 					      `trans_state` varchar(255) NOT NULL,
 					      `trans_start` int(11) NOT NULL default '0',
 					      `trans_real` int(11) NOT NULL default '0',
 					      PRIMARY KEY  (`id`)
 					    ) ENGINE=MyISAM  DEFAULT CHARSET=latin1;"); 
			echo "<font color=\"green\">Added table <b>z_shop_history_pacc</b> (shopsystem).<br/></font>";
			}
			catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_shop_history_pacc</b> not added.</font> Already exist?<br/>";}
			try { $SQL->query("CREATE TABLE IF NOT EXISTS `z_changelog` (
 					      `id` int(11) NOT NULL auto_increment,
 					      `type` varchar(255) NOT NULL default '',
 					      `where` varchar(255) NOT NULL default '',
 					      `date` int(11) NOT NULL default '0',
 					      `description` varchar(255) NOT NULL,
 					       PRIMARY KEY  (`id`)
 					    ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=0 ;"); 
			echo "<font color=\"green\">Added table <b>z_changelog</b> (changelog).<br/></font>";
			}
			catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_changelog</b> not added.</font> Already exist?<br/>";}
			try { $SQL->query("CREATE TABLE `z_polls` (
 					      `id` int(11) NOT NULL auto_increment,
 					      `question` varchar(255) NOT NULL,
 					      `end` int(11) NOT NULL,
 					      `start` int(11) NOT NULL,
 					      `answers` int(11) NOT NULL,
 					      `votes_all` int(11) NOT NULL,
 					      PRIMARY KEY  (`id`)
 					    ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;");
 			echo "<font color=\"green\">Added table <b>z_polls</b> (poll-system).<br/></font>";
			}
			catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_polls</b> not added.</font> Already exist?<br/>";}
			try { $SQL->query("CREATE TABLE `z_polls_answers` (
 					      `poll_id` int(11) NOT NULL,
 					      `answer_id` int(11) NOT NULL,
 					      `answer` varchar(255) NOT NULL,
 					      `votes` int(11) NOT NULL
 					    ) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
			echo "<font color=\"green\">Added table <b>z_polls_answers</b> (poll-system).<br/></font>";
			}
			catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_polls_answers</b> not added.</font> Already exist?<br/>";}
			try { $SQL->query("CREATE TABLE `z_bug_tracker` (
					      `account` varchar(255) NOT NULL,
					      `type` int(11) NOT NULL,
					      `status` int(11) NOT NULL,
					      `text` text NOT NULL,
					      `id` int(11) NOT NULL,
					      `subject` varchar(255) NOT NULL,
					      `reply` int(11) NOT NULL,
					      `who` int(11) NOT NULL,
					      `uid` int(11) NOT NULL auto_increment,
					      `tag` int(11) NOT NULL,
					      PRIMARY KEY  (`uid`)
					      ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ;");
			echo "<font color=\"green\">Added table <b>z_bug_tracker</b> (bug tracker).<br/></font>";
			}
			catch(PDOException $error) { echo "<font color=\"red\">Table <b>z_bug_tracker</b> not added.</font> Already exist?<br/>";
                  }
                  try { $SQL->query("CREATE TABLE IF NOT EXISTS `posts` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `icon` int(5) default NULL,
  `date` varchar(45) default NULL,
  `time` varchar(30) default NULL,
  `author` varchar(30) default NULL,
  `board` int(5) default NULL,
  `thread` int(20) default NULL,
  `post` text,
  `signature` int(5) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `threads` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) default NULL,
  `icon` int(5) default NULL,
  `closed` int(5) default NULL,
  `stick` int(5) NOT NULL,
  `date` varchar(45) default NULL,
  `time` varchar(30) default NULL,
  `author` varchar(30) default NULL,
  `board` int(5) default NULL,
  `views` int(20) default NULL,
  `last` int(40) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

CREATE TABLE IF NOT EXISTS `forums` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255),
  `description` text,
  `closed` int(5) default NULL,
  `access` int(5) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Zrzut danych tabeli `forums`
--

INSERT INTO `forums` (`id`, `name`, `description`, `closed`, `access`) VALUES
(2, 'First forum.', 'This is your first forum.', 0, 0);");
			echo "<font color=\"green\">Added <b>forum tables</b> (forum).<br/></font>";
			}
			catch(PDOException $error) { echo "<font color=\"red\">Tables <b>forum</b> not added.</font> Already exist?<br/>";}
		}
		$config['site']['install'] = 4;
		saveconfig_ini($config['site']);
	echo 'Tablice i kolumny dodane do bazy danych.<br>Idz dalej <a href="install.php?page=step&step=4&server_conf=yes">Przejdz dalej</a>';
}
if($step == '4') {
echo '<h1>Stan '.$step.'</h1>Dodawanie do bazy danych:<br>';
$check_news_ticker = $SQL->query('SELECT * FROM z_news_tickers WHERE image_id = 1 AND author = 1 AND hide_ticker = 0 LIMIT 1 OFFSET 0')->fetch();
if(!isset($check_news_ticker['author'])) {
$SQL->query('INSERT INTO z_news_tickers (date, author, image_id, text, hide_ticker) VALUES ('.time().', 1, 1, "Witam, konfiguracja przebiegla pomyslnie", 0)');
echo "Dodano.<br/>";
} else {
echo "Ten wpis juz jest w bazie danych.<br/>";
}
$check_news = $SQL->query('SELECT * FROM z_news_big WHERE author = "MaCrOs" LIMIT 1 OFFSET 0')->fetch();
if(!isset($check_news['author'])) {
$SQL->query('INSERT INTO z_news_big (hide_news, date, author, author_id, image_id, topic, text) VALUES (0, '.time().', "Gesior", 1, 0, "New account manager!", "Gesior account manager 0.32beta2 installed. All options should work fine. Report bugs in acc. maker thread");');
echo "Dodano.<br/>";
} else {
echo "Ten wpis juz jest w bazie danych.<br/>";
}
$check_voc_0 = $SQL->query('SELECT * FROM players WHERE name = "Rook Sample" LIMIT 1 OFFSET 0')->fetch();
if(!isset($check_voc_0['name'])) {
$SQL->query('INSERT INTO players (name, group_id, account_id, sex, vocation, experience, level, maglevel, health, healthmax, mana, manamax, manaspent, soul, direction, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, posx, posy, posz, cap, lastlogin, lastip, save, conditions, skulltime, skull, guildnick, rank_id, town_id, loss_experience, loss_mana, loss_skills, lastlogout, blessings, premend, online, comment, created, hide_char, nick_verify) VALUES ("Rook Sample", 1, 1, 1, 0, 0, 1, 0, 185, 185, 35, 35, 0, 100,"", 44, 44, 44, 44, 128, 0, 0, 0, 0, 420, "", "", 1,"","","","","","1","","","","","","","","",'.time().',1,1)');
echo "Dodano 'Rook Sample' Postac.<br/>";
} else {
echo "Postac 'Rook Sample' jest juz w bazie.<br/>";
}
$check_voc_1 = $SQL->query('SELECT * FROM players WHERE name = "Sorcerer Sample" LIMIT 1 OFFSET 0')->fetch();
if(!isset($check_voc_1['name'])) {
$SQL->query('INSERT INTO players (name, group_id, account_id, sex, vocation, experience, level, maglevel, health, healthmax, mana, manamax, manaspent, soul, direction, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, posx, posy, posz, cap, lastlogin, lastip, save, conditions, skulltime, skull, guildnick, rank_id, town_id, loss_experience, loss_mana, loss_skills, lastlogout, blessings, premend, online, comment, created, hide_char, nick_verify) VALUES ("Sorcerer Sample", 1, 1, 1, 1, 0, 1, 0, 185, 185, 35, 35, 0, 100,"", 44, 44, 44, 44, 128, 0, 0, 0, 0, 420, "", "", 1,"","","","","","1","","","","","","","","",'.time().',1,1)');
echo "Dodano 'Sorcerer Sample' Postac.<br/>";
} else {
echo "Postac 'Sorcerer Sample' jest juz w bazie.<br/>";
}
$check_voc_2 = $SQL->query('SELECT * FROM players WHERE name = "Druid Sample" LIMIT 1 OFFSET 0')->fetch();
if(!isset($check_voc_2['name'])) {
$SQL->query('INSERT INTO players (name, group_id, account_id, sex, vocation, experience, level, maglevel, health, healthmax, mana, manamax, manaspent, soul, direction, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, posx, posy, posz, cap, lastlogin, lastip, save, conditions, skulltime, skull, guildnick, rank_id, town_id, loss_experience, loss_mana, loss_skills, lastlogout, blessings, premend, online, comment, created, hide_char, nick_verify) VALUES ("Druid Sample", 1, 1, 1, 2, 0, 1, 0, 185, 185, 35, 35, 0, 100,"", 44, 44, 44, 44, 128, 0, 0, 0, 0, 420, "", "", 1,"","","","","","1","","","","","","","","",'.time().',1,1)');
echo "Dodano 'Druid Sample' Postac.<br/>";
} else {
echo "Postac 'Druid Sample' jest juz w bazie.<br/>";
}
$check_voc_3 = $SQL->query('SELECT * FROM players WHERE name = "Paladin Sample" LIMIT 1 OFFSET 0')->fetch();
if(!isset($check_voc_3['name'])) {
$SQL->query('INSERT INTO players (name, group_id, account_id, sex, vocation, experience, level, maglevel, health, healthmax, mana, manamax, manaspent, soul, direction, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, posx, posy, posz, cap, lastlogin, lastip, save, conditions, skulltime, skull, guildnick, rank_id, town_id, loss_experience, loss_mana, loss_skills, lastlogout, blessings, premend, online, comment, created, hide_char, nick_verify) VALUES ("Paladin Sample", 1, 1, 1, 3, 0, 1, 0, 185, 185, 35, 35, 0, 100,"", 44, 44, 44, 44, 128, 0, 0, 0, 0, 420, "", "", 1,"","","","","","1","","","","","","","","",'.time().',1,1)');
echo "Dodano 'Paladin Sample' Postac.<br/>";
} else {
echo "Postac 'Paladin Sample' jest juz w bazie.<br/>";
}
$check_voc_4 = $SQL->query('SELECT * FROM players WHERE name = "Knight Sample" LIMIT 1 OFFSET 0')->fetch();
if(!isset($check_voc_4['name'])) {
$SQL->query('INSERT INTO players (name, group_id, account_id, sex, vocation, experience, level, maglevel, health, healthmax, mana, manamax, manaspent, soul, direction, lookbody, lookfeet, lookhead, looklegs, looktype, lookaddons, posx, posy, posz, cap, lastlogin, lastip, save, conditions, skulltime, skull, guildnick, rank_id, town_id, loss_experience, loss_mana, loss_skills, lastlogout, blessings, premend, online, comment, created, hide_char, nick_verify) VALUES ("Knight Sample", 1, 1, 1, 4, 0, 1, 0, 185, 185, 35, 35, 0, 100,"", 44, 44, 44, 44, 128, 0, 0, 0, 0, 420, "", "", 1,"","","","","","1","","","","","","","","",'.time().',1,1)');
echo "Dodano 'Knight Sample' postac.<br/>";
} else {
echo "Postac 'Knight Sample' jest juz w bazie.<br/>";
$config['site']['install'] = 5;
saveconfig_ini($config['site']);
echo 'Wszystko przebieglo pomyslnie. Mozesz teraz <a href="install.php?page=step&step=5&server_conf=yes">Przejsc dalej</a><br/>';
}
}
if($step == '5') {
echo '<h1>Stan '.$step.'</h1>Ustawienia konta administratora<br>';
$config['server'] = parse_ini_file($config['site']['server_path'].'config.lua');
if(empty($_REQUEST['saveaccpassword'])) {
	echo 'Nazwa Konta: <b>1</b><br/>Ustaw nowe haslo do tego konta.<br>';
	echo 'Nowe haslo: <form action="install.php" method=POST><input type="text" name="newpass" size="35">(Nie podawaj go nikomu!)';
	echo '<input type="hidden" name="saveaccpassword" value="yes"><input type="hidden" name="page" value="step"><input type="hidden" name="step" value="5"><input type="submit" value="SET"></form><br>Instalator zrobi nowy konto i ustawi haslo lub zmieni obecne.';
	} else {
	$newpass = $_POST['newpass'];
	if(!check_password($newpass))
		echo 'Haslo zawiera nie dozwolone znaki. <a href="install.php?page=step&step=5&server_conf=yes">WR??</a> i wpisz inne haslo.';
	else
	{
		$newpass_to_db = password_ency($newpass);
		//ustawienie/stworzenie konta admina
		$account = new OTS_Account();
		$account->load(1);
		if($account->isLoaded())
		{
			//set password
			$account->setPassword($newpass_to_db);
			$account->save();
			$account->setCustomField("page_access", 3);
		}
		else
		{
			//create account
			$number = $account->create(1,1,1);
			$account->setPassword($newpass_to_db);
			$account->unblock();
			$account->save();
			$account->setCustomField("page_access", 3);
		}
		$_SESSION['account'] = 1;
		$_SESSION['password'] = $newpass;
		$logged = TRUE;
		$account->setCustomField("page_lastday", time());
		echo '<h1>Nazwa konta administratora: 1<br>Haslo administratora: '.$_POST['newpass'].'</h1><br/><h5>Aby dokonczyc konfiguracje systemu aukcji <a href="http://localhost/auctionsystem/instalacja.htm">KLIKNIJ TUTAJ</a>, lub wejdz w folder auctionsystem i uruchom plik instalacja.html<br><br>Jezeli w punktach 6+ masz problem wejdz w folder Xampp\apache\bin znajdz plik PHP.INI i zmien w nim extension=php_domxml.dll na ;extension=php_domxml.dll<br><br>Od tej pory instalacja jest zablokowana mozesz to zmienic w config.ini!<br>Teraz wybierz z menu wszystkie punkty 6+.</h5>'; 
		$config['site']['install'] = 'no';
		saveconfig_ini($config['site']);
	}
	}
}
}
else
{
echo "Instalcja zakonczona mozesz to zmienic w folderze config pliku config.ini:<br/><b>install = \"no\"</b><br/>na:</br><b>install = \"start\"</b><br/> po czym wejsc na ta strone jeszcze raz.";
}
}
?>

czy ten acc maker nie dzia?a czy co je?eli kto? wie to prosi?bym o odpowied? dzi?ki z g?ry.

Notka moderatorska:

Posty po??czone i zedytowane dla lepszej przejrzysto?ci :d

 

[navi966]

Odp: MegaEvo Edit by Help3R =)

super silnik oraz acc, widac, ze sie napracowales. Jeszcze jakbyscie powiedzieli jak dodac item do shopu

 

[Milkeway]

Odp: MegaEvo Edit by Help3R =)

Mam ma?y problem.. problem z pocz?tkuj?cym po?orzeniem..pr?bowa?em z tradycyjymi wsp??rz?dnymi <1000,1000,7> ale nie dzia?a te co s? przy liku te? nie dzia?aj?..prosz? o dobre wsp??rz?dne

 

[Pawlak093]

Odp: MegaEvo Edit by Help3R =)

Jaka jest pozycja pocz?tkowej wysky gdzie mog? znale?? oracle?

 

[sebasebase]

Odp: MegaEvo Edit by Help3R =)

Witam, zrobi?em sobie ten serwer na pocz?tek na localhost, chcia?em tylko sprawdzi? jak na nim wszystko wygl?da.
Ale od razu wszed?em i co? mi si? chyba zepsu?o.
1. To co mia?em dosta? na start to le?a?o podemn? i nie mog?em tego wzi??
2. Nie ma opis?w item?w
3. Nie dzia?aj? teleporty
Mo?na to jako? naprawi? czy to po prostu moja wina?

 

[zal2010]

Odp: MegaEvo Edit by Help3R =)

Witam, jako i? dopiero zaczynam moj? zabawe z Ots lecz potrafi? postawi? server SQL.
Jak chc? importowa? baze danych to wyskakuje mi nast?puj?cy b??d:

Serwer: localhost Baza danych: theforgottenserver
B??d
Istnieje szansa, ?e w?a?nie znaleziono b??d w analizatorze sk?adni SQL. Prosz? zbada? bli?ej swoje zapytanie i sprawdzi?, czy cudzys?owy s? poprawne i dobrze sparowane. Inn? mo?liw? przyczyn? niepowodzenia mo?e by? wysy?anie pliku ze znakami binarnymi poza obszarem tekstu uj?tego w cudzys?owy. Mo?na r?wnie? sprawdzi? zapytanie SQL poprzez lini? polece? MySQL-a. W znalezieniu przyczyny problemu mo?e pom?c tak?e - je?li si? pojawi - poni?szy opis b??du serwera MySQL. Je?li nadal wyst?puj? z problemy lub analizator sk?adni zg?asza usterk? a linia polece? - nie, ogranicz sekwencj? zapyta? SQL do pojedynczego, kt?re powoduje problemy i zg?o? b??d, do??czaj?c fragment danych zawarty w poni?szej sekcji TNIJ:
----TNIJ ST?D----
eNrtfU9wFMX7d/d2kk0WKkFIskgINSl/+iWVANkE5CeU9RIw8IuEhBAQed/DOuwOyVRmZ/admQCx
CgsS8V+VVepBL170YJXlQQ7qwYsH9WBZpYVcuHjxglIepMoCS63ifXpmNzsz2c1M581GzD6fnX12
O9PP/Onu58lsf7r7GTpxYuzEPulQSjrUL40Mje6TUnuk1ONS/+P9ff/dl5g4CTtJIjHxDOz5r+Hs
Psn6v1peNi3F3KmpZ3fmp/JSKtWX2iv19/Xt3ZHq39GfklL/vQ+23bv/t6QpuSek/0ocm50YH9kn
7dnZt3NPKnFq4oQ0NtErDR4ZGj3ZKz0zBKc4rerS8JD03zv7EsePDe6T+nemUjt3J47/z3G+v3ds
gmv379wjnR4eHT2ZGBkcPbJPyms7ZuxzO/474RwdhGor0jnDzMm2NEDqCKXkgCQRQo4QPw7Cm3rS
lEREPby3Mpt/nWB/sbvsDvuV3WI/sR/ZTXaDfce+YV+xL9jn7FN2jX3EPmDvsXfZO+wt9jp7hc2z
F9isq1wtXPk/9fHkf/5D52Zs+aymQC2dV8y0qWQMM+tLNBw6MTR4ckg6OXhwZEh67P/OGPZ+Xwb3
T9L2RJP7zffX4dGTQ0eGTkijYyel0VMjI73FXBcMU8um1Ur5pKeGDg+eGjkp9S1o2GpOsWw5l698
6FOjw+OnhqTtiy+kVyp32uJfA4fuTnQ/0dCQPPYfSlQ9q1yEhgztJS3P2IaTTvvuP53yJeNXDrF4
8pFH6Nwxb8nmDDvr+VpXuVT57mCZqtUoT+WiXch9cujZk4uz/uc/i4pUXbI4odz21DUkhx8JKTd+
hwulxhP1V/6Luq0x7i2zjKGfUyd9iVjlcnMzBEvO99dnBk8c+p9BaP0nngExfgrE8QkQY8dBjI6C
OHYUxMgwiKPcFTw9BGL4EAhH7chjk/Z++Dy8D8RTe0Ec2s2dxAAIvisFn3t7QfRvB7HzERDd3Ks8
Bk1rfyd86doCYls7iM2tIB5qAZFoAtHUkODehf1GYEMgEGsczZR10ezZNLguSzX0pGv/dwhsCARi
zTsAn/1T1/5vEtgQCMQagfPsT+soPUbJaUXLGDlFsg3p5JQiHTbMScO2FV2acH7CdLk+4A8CGwKB
qBHEwT1QSgrPAPcIbAgEokbMnz8ecGbBtf+7BDYEAlETaKqnrvk7//9JHZYIAlGL4PbfQBsJbaQf
09uxa7Fb7Gv2d22VAR+YsKp08IntA3u6K7DfbsbzsjajRB114D0DH0gQizCQwNVZoMTdJMOBBMsY
SIDDWqo0rIX7JkZOE3Ka3mPfs+vsumuv86ca48nOTvrSJVue74zHk93d9Gqg9POGaVv+VGOh/Jeh
UrbKnByhrf34ieFjgyfOSEeHzvx/VFlek2fhpEIqhnVRKPesUO7nV669lVFxSzfcxIu55awVevBE
t7fhQM3LmYwxo9tW8XNdmdou7hOp58U2qss5JfAfoH+P519AqWBly7pQMvqQzKaSy8qzVvRi1WTL
Bo3oCkpOVrWlLqZcdUwrs0GVvnIafSWVs5qRmVaKt31wbGxkaHB0qQu7IJu6qk8K3PukaczkI1hQ
apH7K9Ue+LNdTQ3JQ52V/FmxuaRTxW/r3R6WXwhsCARiraKNriMtLYwmWiilqRS5f5/0kSLD8ieB
DYFA1AzqWQtNFez/ZQIbAoH4Z3CB7iY9nPWgsRgNIFH8SwLedd4dg+5TvHRM1uVJxSQOa/I2vDj0
wqH7++P0jdKZ1te3P0eyHAs9rJTdJrAhEIi1+wOgDhzMIo8BOzZE7oVYyFfoPoiQU1POK1qUTo0C
s2BkZFs19OgdJ1OKrNlToWfoC2rk5IsiSsrFvGKqip5RBPqzDGP6rJGdDT+PT+WcotiCKnBLWUEV
TQnvngqo2LP50LtPDTzu05GzWUMX6AfLyZORmoxXQ5dFapLnF6x8rmLlFd2OflWWMSNwD7ZxQY9g
TA9Op3nG0LMqN9Ri1R4cGTu4+IIzskCvuqVcFOsr1oxJVRdS4X7QVkWuST6vhHX7lryXNT2jCdS6
k53TDwLMg6xPR2gokzOqltXVzLRo53ihWI0ZgabOWSpLrLf7rKzJQq6UEzRqBDvfk+rv41hQzKqm
konyH6Xf47YsKx3d33sdhaMq6pAcJWta1TRLWA3s0JZVXTHFVVVbyQlpcUJH0QU4PkPX4NKKNNnw
6BnQWdqTm6YKjyUCTss0cobY80JW0RRbhMvJKlbGVPOes0SwpkoUTZGJ9l1FNygcHjsxNHxk1CHo
tpd/yOqWTgwdHjoxNHpoaKIC/+dn/7oT3c4AGnKZkMvUnXdzKvZh7Gf2pZsi2+AF6HmoIfm/Hq7E
GjnOxEqn3M/klWebHYJ6btqhKSc1A6w5bdmGCVXnT7UuUJZvJhPxZEcHfb/eUXIJY6vwkSjDbBZ2
rRKxGZXyhrJq2bGuITnYUamwCtedThW+NM+Nr48ne3roi2e8rG76vJrXVPBq/uTGyhxvMUuwRKI/
iq88r7+ooQcvplcqe6CqNfjyxw2effFhA61tkRk9mWhIjveE0KrFGlpgV4t/2LQskym1AH+OYAMo
8dkrWPPeEV4h7q5vsb9buKSKo5n2tzQkx7orehzfDYPn8aXbcFQwAlG7QPtHIND+EQgE2j8CgUD7
RyAQaP8IBGJt23892UHIDvoq/Sx2gzWT7vI521rjc2c2xJMPP0yvJlzuxSExXdlejmtx9qzSvNnI
/KRxQVfMcIYvYyrO6LmsbMtheT2T4VeAzw4QPOV5ON9dLIOFE6Kp57ZsdCa+z1ulek+r+nlQsnyJ
hyu1gmKGYGOIwIr6jhKZPQ0cuFcqd5gqcZzljxo49eKD+s1lUY09sWmp6fW+Ui5UXDG55YrR6iz2
MP+op/748CfL87WjYt05u5dlxuG1Jmi8S41nrE6x4wMSAoE/kBAIBNo/AoFA+0cgEGj/CARibdt/
jO4idBe7QX6HVw1gz+al1sedMmYsJc0n41jplCchcUd5tavNoYhe63S6mp3dliu3lulgdvesxkLC
DmESOilcFjmk+MqUfEpwQasKzBaf+S4wDVh9Xmh2qCoyx9gUmuCfNQxTZMazkrVE1qTVFJHFQzkd
EDaj9fDgyMRQiSrUFNmMqiK4VHVP+1I8nWs+BSu0OvFZBYHA3yoIBKI27b+OHiD0QOxS7BP2bcxd
meIHeP2LsX9ifAQee6RzhpmTbWkAPByl5IDEf28cCeQ9CG/qSdOoJ6mH91Zm868T7C92l91hv7Jb
7Cf2I7vJbrDv2DfsK/YF+5x9yq6xj9gH7D32LnuHvcVeZ6+wefYCm3WVqwWMPVKt2CMYCWcZkXBW
M4YStP4Tz4AYPwXi+ASIseMgRkdBHDsKYmQYxFHuCp4eAjF8CISjduSxSXs/fB7eB+KpvSAO7eZO
YgAE35WCz729IPq3g9j5CIhu7lUct9kJX7q2gNjWDmJzK4iHWriTbQLR1OAu9vobgQ2BQKxxNFPW
RbNn0+C6LNXQk6793yGwIRCINe8AfPZfCPZwk8CGQCDWCNylPesoPUbJaUXLGDlFsg3p5JQiHTbM
ScO2FV2acH7CdLk+4A8CGwKBqBHEncgxxYBv9whsCASiRszfiRxFigGf7hLYEAhETaCpnrrmT3G8
BQJRu3AigtBGQhvpx/R27FrsFvua/V1bZcAHJqwqHXxi+0BI4CVvwIXQUQfeM/CBBLEIAwlcnQVK
3E0yHEiwjIEEOKylSsNauG9i5DQhp+k99j27zq679jp/qjGe7OykL12y5fnOuBNL5Wqg9POGaVv+
VGOh/JehUrbKnByrtDRY2CJT5SP4PSDRAcPaW9nJF7x0w028mFuOMJ0i0e1tOKXgS1bxc13lcEur
FXkqL1vWhZLRh2Q2lVxWnhWcvAMa0RWUnKxqolEDSyGIFlT6KoYKKgYNNDLTImHYxCcuhQSz9cVv
rLS+HfizXU0NyUOdIbGfrIWgT9Z6t4flFwIbAoFYq2ij60hLC6OJFkppKkXu3yd9pMiw/ElgQyAQ
NYN61kJTBft/mcCGQCD+GVygu0kPZz1oLEYDSBT/koB3nXfHoPsULx2TdXlSMYnDmrwNLw69cOj+
/jh9o3Sm9fXtz5Esx0IPK2W3CWwIBGLt/gCoAwezyGPAjg2ReyF6xeN4L7WeuK9To8AsGBnZE7w+
QsfJlCJr9lToGfqCGjn5ooiScjGvmKqii6zRohnG9FkjOxt+Hp/KOUWxBVXglrKCKpoS3j0VULFn
86F3nxp43KcjZ7OGLtAPlpMnIzUZr4Yui9Qkzy9Y+VzFygutuGMZMwL3wBcWimBMD06necbQsyo3
1GLVHhwZO1gmxocs0KtuKRfF+oo1Y1LVhVS4H7RVkWuSzyth3b4l72VNz2gCte5k5/SDAPMg69NR
g3noamZatHO8UKzGjEBT5yyVJdbbfVbWZCFXygkaNYKd70n193GUVr5STSUT5T9Kv8dtWVY6ur/3
OgpHVdQhOUrWtKpplrAa2KEtq7piiquqtpIT0uKEjqKLrAina3BpRZpsePQM6CztyU1ThccSkUXT
jJwh9ryQVTTFFuFysoqVMdW85ywrEILIdxUV4tkEH7LKhFYJ8n9lg6s0kMuEXKbuvJtTsQ9jP7Mv
3RTZBi+AUKyiK882OwT13LQb60YzwJrTlm2YUHX+VOsCZflmMhFPdnTQ9+sdpUJ4n8JHogyzGQgA
VGViMyrlDWXVsmNdQ3Kwo1JhFa47nSp8aZ4bXx9P9vTQF894Wd30eTXP13QMJDdW5niLWYIlEv1R
fOV5/UUNPXgxvVL5gE/VavDVCTeV6H4y0ZAc7wmhVYs1tMCuFv+waVkm4wkS5csRbAAlPnsFa947
wivE3fUt9ncLl1RxNNP+lobkWHdFj+O7YfA8vnQbjgpGIGoXaP8IBNo/AoFA+0cgEGj/CAQC7R+B
QKxt+68nOwjZQV+ln8VusGbSXT5nW2t87swGJ17a1YTLvTgkpivby3Etzp5VmjcbmZ90YquFM3wZ
U3FGz2VlWw7L65kMvwJ8doDgKc/D+e5iGSycEE09t2WjM/F93irVe1rVz4OS5Us8XKkVFDMEG0ME
VtR3lMjsaeDAvVK5w1SJ4yx/1MCpFx/Uby6LauyJTUtNr/eVcqHiisktV4xWZ7GH+Uc99ceHP1me
rx0V687ZvSwzDq81QeNdajxjdYodH5AQCPyBhEAg0P4RCATaPwKBQPtHIBBr2/5jdBehu9gN8ju8
agB7Ni+1Pu6UMWMpaT4Zx0qnPAmJO8qrXW0ORfRap9PV7Oy2XLm1TAezu2c1FhJ2CJPQSeGyyCHF
V6bkU4ILWlVgtvjMd4FpwOrzQrNDVZE5xqbQBP+sYZgiM56VrCWyJq2miCweyumAsBmthwdHJoZK
VKGmyGZUFcGlqnval+LpXPMpWKHVic8qCAT+VkEgELVp/3X0AKEHYpdin7BvY+7KFD/A61+M/RPj
I/DYI50zzJxsSwPg4SglByT+e+NIIO9BeFNPmkY9ST28tzKbf51gf7G77A77ld1iP7Ef2U12g33H
vmFfsS/Y5+xTdo19xD5g77F32TvsLfY6e4XNsxfYrKtcLWDskWrFHsFIOMuIhLOaMZSg9Z94BsT4
KRDHJ0CMHQcxOgri2FEQI8MgjnJX8PQQiOFDIBy1I49N2vvh8/A+EE/tBXFoN3cSAyD4rhR87u0F
0b8dxM5HQHRzr+K4zU740rUFxLZ2EJtbQTzUwp1sE4imBnex198IbAgEYo2jmbIumj2bBtdlqYae
dO3/DoENgUCseQfgs/9CsIebBDYEArFG4C7tWUfpMUpOK1rGyCmSbUgnpxTpsGFOGrat6NKE8xOm
y/UBfxDYEAhEjSDuRI4pBny7R2BDIBA1Yv5O5ChSDPh0l8CGQCBqAk311DV/iuMtEIjahRMRhDYS
2kg/prdj12K32Nfs79oqAz4wYVXp4BPbB0ICL3kDLoSOOvCegQ8kiEUYSODqLFDibpLhQIJlDCTA
YS1VGtbCfRMjpwk5Te+x79l1dt211/lTjfFkZyd96ZItz3fGnVgqVwOlnzdM2/KnGgvlvwyVslXm
5FilpcHCFpkqH8HvAYkOGNbeyk6+4KUbbuLF3HKE6RSJbm/DKQVfsoqf6yqHW1qtyFN52bIulIw+
JLOp5LLyrODkHdCIrqDkZFUTjRpYCkG0oNJXMVRQMWigkZkWCcMmPnEpJJitL35jpfXtwJ/tampI
HuoMif1kLQR9sta7PSy/ENgQCMRaRRtdR1paGE20UEpTKXL/PukjRYblTwIbAoGoGdSzFpoq2P/L
BDYEAvHP4ALdTXo460FjMRpAoviXBLzrvDsG3ad46Zisy5OKSRzW5G14ceiFQ/f3x+kbpTOtr29/
jmQ5FnpYKbtNYEMgEGv3B0AdOJhFHgN2bIjcC9ErHsd7qfXEfZ0aBWbByMie4PUROk6mFFmzp0LP
0BfUyMkXRZSUi3nFVBVdZI0WzTCmzxrZ2fDz+FTOKYotqAK3lBVU0ZTw7qmAij2bD7371MDjPh05
mzV0gX6wnDwZqcl4NXRZpCZ5fsHK5ypWXmjFHcuYEbgHvrBQBGN6cDrNM4aeVbmhFqv24MjYwTIx
PmSBXnVLuSjWV6wZk6oupML9oK2KXJN8Xgnr9i15L2t6RhOodSc7px8EmAdZn44azENXM9OineOF
YjVmBJo6Z6kssd7us7ImC7lSTtCoEex8T6q/j6O08pVqKpko/1H6PW7LstLR/b3XUTiqog7JUbKm
VU2zhNXADm1Z1RVTXFW1lZyQFid0FF1kRThdg0sr0mTDo2dAZ2lPbpoqPJaILJpm5Ayx54Wsoim2
CJeTVayMqeY9Z1mBEES+q6gQzyb4kFUmtEqQ/ysbXKWBXCbkMnXn3ZyKfRj7mX3ppsg2eAGEYhVd
ebbZIajnpt1YN5oB1py2bMOEqvOnWhcoyzeTiXiyo4O+X+8oFcL7FD4SZZjNQACgKhObUSlvKKuW
HesakoMdlQqrcN3pVOFL89z4+niyp4e+eMbL6qbPq3m+pmMgubEyx1vMEiyR6I/iK8/rL2rowYvp
lcoHfKpWg69OuKlE95OJhuR4TwitWqyhBXa1+IdNyzIZT5AoX45gAyjx2StY894RXiHurm+xv1u4
pIqjmfa3NCTHuit6HN8Ng+fxpdtwVDACUbtA+0cg0P4RCATaPwKBQPtHIBBo/wgEYm3bfz3ZQcgO
+ir9LHaDNZPu8jnbWuNzZzY48dKuJlzuxSExXdlejmtx9qzSvNnI/KQTWy2c4cuYijN6Livbclhe
z2T4FeCzAwRPeR7OdxfLYOGEaOq5LRudie/zVqne06p+HpQsX+LhSq2gmCHYGCKwor6jRGZPAwfu
lcodpkocZ/mjBk69+KB+c1lUY09sWmp6va+UCxVXTG65YrQ6iz3MP+qpPz78yfJ87ahYd87uZZlx
eK0JGu9S4xmrU+z4gIRA4A8kBAKB9o9AIND+EQgE2j8CgVjb9h+juwjdxW6Q3+FVA9izean1caeM
GUtJ88k4VjrlSUjcUV7tanMootc6na5mZ7flyq1lOpjdPauxkLBDmIROCpdFDim+MiWfElzQqgKz
xWe+C0wDVp8Xmh2qiswxNoUm+GcNwxSZ8axkLZE1aTVFZPFQTgeEzWg9PDgyMVSiCjVFNqOqCC5V
3dO+FE/nmk/BCq1OfFZBIPC3CgKBqE37r6MHCD0QuxT7hH0bc1em+AFe/2Lsnxgfgcce6Zxh5mRb
GgAPRyk5IPHfG0cCeQ/Cm3rSNOpJ6uG9ldn86wT7i91ld9iv7Bb7if3IbrIb7Dv2DfuKfcE+Z5+y
a+wj9gF7j73L3mFvsdfZK2yevcBmXeVqAWOPVCv2CEbCWUYknNWMoQSt/8QzIMZPgTg+AWLsOIjR
URDHjoIYGQZxlLuCp4dADB8C4agdeWzS3g+fh/eBeGoviEO7uZMYAMF3peBzby+I/u0gdj4Copt7
FcdtdsKXri0gtrWD2NwK4qEW7mSbQDQ1uIu9/kZgQyAQaxzNlHXR7Nk0uC5LNfSka/93CGwIBGLN
OwCf/ReCPdwksCEQiDUCd2nPOkqPUXJa0TJGTpFsQzo5pUiHDXPSsG1FlyacnzBdrg/4g8CGQCBq
BHEnckwx4Ns9AhsCgagR83ciR5FiwKe7BDYEAlETaKqnrvlTHG+BQNQunIggtJHQRvoxvR27FrvF
vmZ/11YZ8IEJq0oHn9g+EBJ4yRtwIXTUgfcMfCBBLMJAAldngRJ3kwwHEixjIAEOa6nSsBbumxg5
Tchpeo99z66z6669zp9qjCc7O+lLl2x5vjPuxFK5Gij9vGHalj/VWCj/ZaiUrTInxyotDRa2yFT5
CH4PSHTAsPZWdvIFL91wEy/mliNMp0h0extOKfiSVfxcVznc0mpFnsrLlnWhZPQhmU0ll5VnBSfv
gEZ0BSUnq5po1MBSCKIFlb6KoYKKQQONzLRIGDbxiUshwWx98RsrrW8H/mxXU0PyUGdI7CdrIeiT
td7tYfmFwIZAINYq2ug60tLCaKKFUppKkfv3SR8pMix/EtgQCETNoJ610FTB/l8msCEQiH8GF+hu
0sNZDxqL0QASxb8k4F3n3THoPsVLx2RdnlRM4rAmb8OLQy8cur8/Tt8onWl9fftzJMux0MNK2W0C
GwKBWLs/AOrAwSzyGLBjQ+ReiF7xON5LrSfu69QoMAtGRvYEr4/QcTKlyJo9FXqGvqBGTr4ooqRc
zCumqugia7RohjF91sjOhp/Hp3JOUWxBFbilrKCKpoR3TwVU7Nl86N2nBh736cjZrKEL9IPl5MlI
TcarocsiNcnzC1Y+V7HyQivuWMaMwD3whYUiGNOD02meMfSsyg21WLUHR8YOlonxIQv0qlvKRbG+
Ys2YVHUhFe4HbVXkmuTzSli3b8l7WdMzmkCtO9k5/SDAPMj6dNRgHrqamRbtHC8UqzEj0NQ5S2WJ
9XaflTVZyJVygkaNYOd7Uv19HKWVr1RTyUT5j9LvcVuWlY7u772OwlEVdUiOkjWtapolrAZ2aMuq
rpjiqqqt5IS0OKGj6CIrwukaXFqRJhsePQM6S3ty01ThsURk0TQjZ4g9L2QVTbFFuJysYmVMNe85
ywqEIPJdRYV4NsGHrDKhVYL8X9ngKg3kMiGXqTvv5lTsw9jP7Es3RbbBCyAUq+jKs80OQT037ca6
0Qyw5rRlGyZUnT/VukBZvplMxJMdHfT9ekepEN6n8JEow2wGAgBVmdiMSnlDWbXsWNeQHOyoVFiF
606nCl+a58bXx5M9PfTFM15WN31ezfM1HQPJjZU53mKWYIlEfxRfeV5/UUMPXkyvVD7gU7UafHXC
TSW6n0w0JMd7QmjVYg0tsKvFP2xalsl4gkT5cgQbQInPXsGa947wCnF3fYv93cIlVRzNtL+lITnW
XdHj+G4YPI8v3YajghGI2gXaPwKB9o9AIND+EQgE2j8CgUD7RyAQa9v+68kOQnbQV+lnsRusmXSX
z9nWGp87s8GJl3Y14XIvDonpyvZyXIuzZ5XmzUbmJ53YauEMX8ZUnNFzWdmWw/J6JsOvAJ8dIHjK
83C+u1gGCydEU89t2ehMfJ+3SvWeVvXzoGT5Eg9XagXFDMHGEIEV9R0lMnsaOHCvVO4wVeI4yx81
cOrFB/Wby6Iae2LTUtPrfaVcqLhicssVo9VZ7GH+UU/98eFPludrR8W6c3Yvy4zDa03QeJcaz1id
YscHJAQCfyAhEAi0fwQCgfaPQCDQ/hEIxNq2/xjdRegudoP8Dq8awJ7NS62PO2XMWEqaT8ax0ilP
QuKO8mpXm0MRvdbpdDU7uy1Xbi3TwezuWY2FhB3CJHRSuCxySPGVKfmU4IJWFZgtPvNdYBqw+rzQ
7FBVZI6xKTTBP2sYpsiMZyVriaxJqykii4dyOiBsRuvhwZGJoRJVqCmyGVVFcKnqnvaleDrXfApW
aHXiswoCgb9VEAhEbdp/HT1A6IHYpdgn7NuYuzLFD/D6F2P/xPgIPPZI5wwzJ9vSAHg4SskBif/e
OBLIexDe1JOmUU9SD++tzOZfJ9hf7C67w35lt9hP7Ed2k91g37Fv2FfsC/Y5+5RdYx+xD9h77F32
DnuLvc5eYfPsBTbrKlcLGHukWrFHMBLOMiLhrGYMJWj9J54BMX4KxPEJEGPHQYyOgjh2FMTIMIij
3BU8PQRi+BAIR+3IY5P2fvg8vA/EU3tBHNrNncQACL4rBZ97e0H0bwex8xEQ3dyrOG6zE750bQGx
rR3E5lYQD7VwJ9sEoqnBXez1NwIbAoFY42imrItmz6bBdVmqoSdd+79DYEMgEGveAfjsvxDs4SaB
DYFArBG4S3vWUXqMktOKljFyimQb0skpRTpsmJOGbSu6NOH8hOlyfcAfBDYEAlEjiDuRY4oB3+4R
2BAIRI2YvxM5ihQDPt0lsCEQiJpAUz11zZ/ieAsEonbhRAShjYQ20o/p7di12C32Nfu7tsqAD0xY
VTr4xPaBkMBL3oALoaMOvGfgAwliEQYSuDoLlLibZDiQYBkDCXBYS5WGtXDfxMhpQk7Te+x7dp1d
d+11/lRjPNnZSV+6ZMvznXEnlsrVQOnnDdO2/KnGQvkvQ6VslTk5VmlpsLBFpspH8HtAogOGtbey
ky946YabeDG3HGE6RaLb23BKwZes4ue6yuGWVivyVF62rAslow/JbCq5rDwrOHkHNKIrKDlZ1USj
BpZCEC2o9FUMFVQMGmhkpkXCsIlPXAoJZuuL31hpfTvwZ7uaGpKHOkNiP1kLQZ+s9W4Pyy8ENgQC
sVbRRteRlhZGEy2U0lSK3L9P+kiRYfmTwIZAIGoG9ayFpgr2/zKBDYFA/DO4QHeTHs560FiMBpAo
/iUB7zrvjkH3KV46JuvypGIShzV5G14ceuHQ/f1x+kbpTOvr258jWY6FHlbKbhPYEAjE2v0BUAcO
ZpHHgB0bIvdC9IrH8V5qPXFfp0aBWTAysid4fYSOkylF1uyp0DP0BTVy8kURJeViXjFVRRdZo0Uz
jOmzRnY2/Dw+lXOKYguqwC1lBVU0Jbx7KqBiz+ZD7z418LhPR85mDV2gHywnT0ZqMl4NXRapSZ5f
sPK5ipUXWnHHMmYE7oEvLBTBmB6cTvOMoWdVbqjFqj04MnawTIwPWaBX3VIuivUVa8akqgupcD9o
qyLXJJ9Xwrp9S97Lmp7RBGrdyc7pBwHmQdanowbz0NXMtGjneKFYjRmBps5ZKkust/usrMlCrpQT
NGoEO9+T6u/jKK18pZpKJsp/lH6P27KsdHR/73UUjqqoQ3KUrGlV0yxhNbBDW1Z1xRRXVW0lJ6TF
CR1FF1kRTtfg0oo02fDoGdBZ2pObpgqPJSKLphk5Q+x5Iatoii3C5WQVK2Oqec9ZViAEke8qKsSz
CT5klQmtEuT/ygZXaSCXCblM3Xk3p2Ifxn5mX7opsg1eAKFYRVeebXYI6rlpN9aNZoA1py3bMKHq
/KnWBcryzWQinuzooO/XO0qF8D6Fj0QZZjMQAKjKxGZUyhvKqmXHuobkYEelwipcdzpV+NI8N74+
nuzpoS+e8bK66fNqnq/pGEhurMzxFrMESyT6o/jK8/qLGnrwYnql8gGfqtXgqxNuKtH9ZKIhOd4T
QqsWa2iBXS3+YdOyTMYTJMqXI9gASnz2Cta8d4RXiLvrW+zvFi6p4mim/S0NybHuih7Hd8PgeXzp
NhwVjEDULtD+EQi0fwQCgfaPQCDQ/hEIBNo/AoFY2/ZfT3YQsoO+Sj+L3WDNpLt8zrbW+NyZDU68
tKsJl3txSExXtpfjWpw9qzRvNjI/6cRWC2f4MqbijJ7LyrYcltczGX4F+OwAwVOeh/PdxTJYOCGa
em7LRmfi+7xVqve0qp8HJcuXeLhSKyhmCDaGCKyo7yiR2dPAgXulcoepEsdZ/qiBUy8+qN9cFtXY
E5uWml7vK+VCxRWTW64Yrc5iD/OPeuqPD3+yPF87Ktads3tZZhxea4LGu9R4xuoUOz4gIRD4AwmB
QKD9IxAItH8EAoH2j0Ag1rb9x+guQnexG+R3eNUA9mxean3cKWPGUtJ8Mo6VTnkSEneUV7vaHIro
tU6nq9nZbblya5kOZnfPaiwk7BAmoZPCZZFDiq9MyacEF7SqwGzxme8C04DV54Vmh6oic4xNoQn+
WcMwRWY8K1lLZE1aTRFZPJTTAWEzWg8PjkwMlahCTZHNqCqCS1X3tC/F07nmU7BCqxOfVRAI/K2C
QCBq0/7r6AFCD8QuxT5h38bclSl+gNe/GPsnxkfgsUc6Z5g52ZYGwMNRSg5I/PfGkUDeg/CmnjSN
epJ6eG9lNv86wf5id9kd9iu7xX5iP7Kb7Ab7jn3DvmJfsM/Zp+wa+4h9wN5j77J32FvsdfYKm2cv
sFlXuVrA2CPVij2CkXCWEQlnNWMoQes/8QyI8VMgjk+AGDsOYnQUxLGjIEaGQRzlruDpIRDDh0A4
akcem7T3w+fhfSCe2gvi0G7uJAZA8F0p+NzbC6J/O4idj4Do5l7FcZud8KVrC4ht7SA2t4J4qIU7
2SYQTQ3uYq+/EdgQCMQaRzNlXTR7Ng2uy1INPena/x0CGwKBWPMOwGf/hWAPNwlsCARijcBd2rOO
0mOUnFa0jJFTJNuQTk4p0mHDnDRsW9GlCecnTJfrA/4gsCEQiBpB3IkcUwz4do/AhkAgasT8nchR
pBjw6S6BDYFA1ASa6qlr/hTHWyAQtQsnIghtJLSRfkxvx67FbrGv2d+1VQZ8YMKq0sEntg+EBF7y
BlwIHXXgPQMfSBCLMJDA1VmgxN0kw4EEyxhIgMNaqjSshfsmRk4TcpreY9+z6+y6a6/zpxrjyc5O
+tIlW57vjDuxVK4GSj9vmLblTzUWyn8ZKmWrzMmxSkuDhS0yVT6C3wMSHTCsvZWdfMFLN9zEi7nl
CNMpEt3ehlMKvmQVP9dVDre0WpGn8rJlXSgZfUhmU8ll5VnByTugEV1BycmqJho1sBSCaEGlr2Ko
oGLQQCMzLRKGTXziUkgwW1/8xkrr24E/29XUkDzUGRL7yVoI+mStd3tYfiGwIRCItYo2uo60tDCa
aKGUplLk/n3SR4oMy58ENgQCUTOoZy00VbD/lwlsCATin8EFupv0cNaDxmI0gETxLwl413l3DLpP
8dIxWZcnFZM4rMnb8OLQC4fu74/TN0pnWl/f/hzJciz0sFJ2m8CGQCDW7g+AOnAwizwG7NgQuRei
VzyO91Lrifs6NQrMgpGRPcHrI3ScTCmyZk+FnqEvqJGTL4ooKRfziqkqusgaLZphTJ81srPh5/Gp
nFMUW1AFbikrqKIp4d1TARV7Nh9696mBx306cjZr6AL9YDl5MlKT8WroskhN8vyClc9VrLzQijuW
MSNwD3xhoQjG9OB0mmcMPatyQy1W7cGRsYNlYnzIAr3qlnJRrK9YMyZVXUiF+0FbFbkm+bwS1u1b
8l7W9IwmUOtOdk4/CDAPsj4dNZiHrmamRTvHC8VqzAg0dc5SWWK93WdlTRZypZygUSPY+Z5Ufx9H
aeUr1VQyUf6j9HvclmWlo/t7r6NwVEUdkqNkTauaZgmrgR3asqorpriqais5IS1O6Ci6yIpwugaX
VqTJhkfPgM7Sntw0VXgsEVk0zcgZYs8LWUVTbBEuJ6tYGVPNe86yAiGIfFdRIZ5N8CGrTGiVIP9X
NrhKA7lMyGXqzrs5Ffsw9jP70k2RbfACCMUquvJss0NQz027sW40A6w5bdmGCVXnT7UuUJZvJhPx
ZEcHfb/eUSqE9yl8JMowm4EAQFUmNqNS3lBWLTvWNSQHOyoVVuG606nCl+a58fXxZE8PffGMl9VN
n1fzfE3HQHJjZY63mCVYItEfxVee11/U0IMX0yuVD/hUrQZfnXBTie4nEw3J8Z4QWrVYQwvsavEP
m5ZlMp4gUb4cwQZQ4rNXsOa9I7xC3F3fYn+3cEkVRzPtb2lIjnVX9Di+GwbP40u34ahgBKJ2gfaP
QKD9IxAItH8EAoH2j0Ag0P4RCMTatv96soOQHfRV+lnsBmsm3eVztrXG585scOKlXU243ItDYrqy
vRzX4uxZpXmzkflJJ7ZaOMOXMRVn9FxWtuWwvJ7J8CvAZwcInvI8nO8ulsHCCdHUc1s2OhPf561S
vadV/TwoWb7Ew5VaQTFDsDFEYEV9R4nMngYO3CuVO0yVOM7yRw2cevFB/eayqMae2LTU9HpfKRcq
rpjccsVodRZ7mH/UU398+JPl+dpRse6c3csy4/BaEzTepcYzVqfY8QEJgcAfSAgEAu0fgUCg/SMQ
CLR/BAKxtu0/RncRuovdIL/DqwawZ/NS6+NOGTOWkuaTcax0ypOQuKO82tXmUESvdTpdzc5uy5Vb
y3Qwu3tWYyFhhzAJnRQuixxSfGVKPiW4oFUFZovPfBeYBqw+LzQ7VBWZY2wKTfDPGoYpMuNZyVoi
a9JqisjioZwOCJvRenhwZGKoRBVqimxGVRFcqrqnfSmezjWfghVanfisgkDgbxUEAlGb9l9HDxB6
IHYp9gn7NuauTPEDvP7F2D8xPgKPPdI5w8zJtjQAHo5SckDivzeOBPIehDf1pGnUk9TDeyuz+dcJ
9he7y+6wX9kt9hP7kd1kN9h37Bv2FfuCfc4+ZdfYR+wD9h57l73D3mKvs1fYPHuBzbrK1QLGHqlW
7BGMhLOMSDirGUMJWv+JZ0CMnwJxfALE2HEQo6Mgjh0FMTIM4ih3BU8PgRg+BMJRO/LYpL0fPg/v
A/HUXhCHdnMnMQCC70rB595eEP3bQex8BEQ39yqO2+yEL11bQGxrB7G5FcRDLdzJNoFoanAXe/2N
wIZAINY4minrotmzaXBdlmroSdf+7xDYEAjEmncAPvsvBHu4SWBDIBBrBO7SnnWUHqPktKJljJwi
2YZ0ckqRDhvmpGHbii5NOD9hulwf8AeBDYFA1AjiTuSYYsC3ewQ2BAJRI+bvRI4ixYBPdwlsCASi
JtBUT13zpzjeAoGoXTgRQWgjoY30Y3o7di12i33N/q6tMuADE1aVDj6xfSAk8JI34ELoqAPvGfhA
gliEgQSuzgIl7iYZDiRYxkACHNZSpWEt3DcxcpqQ0/Qe+55dZ9dde50/1RhPdnbSly7Z8nxn3Iml
cjVQ+nnDtC1/qrFQ/stQKVtlTo5VWhosbJGp8hH8HpDogGHtrezkC1664SZezC1HmE6R6PY2nFLw
Jav4ua5yuKXVijyVly3rQsnoQzKbSi4rzwpO3gGN6ApKTlY10aiBpRBECyp9FUMFFYMGGplpkTBs
4hOXQoLZ+uI3VlrfDvzZrqaG5KHOkNhP1kLQJ2u928PyC4ENgUCsVbTRdaSlhdFEC6U0lSL375M+
UmRY/iSwIRCImkE9a6Gpgv2/TGBDIBD/DC7Q3aSHsx40FqMBJIp/ScC7zrtj0H2Kl47JujypmMRh
Td6GF4deOHR/f5y+UTrT+vr250iWY6GHlbLbBDYEArF2fwDUgYNZ5DFgx4bIvRC94nG8l1pP3Nep
UWAWjIzsCV4foeNkSpE1eyr0DH1BjZx8UURJuZhXTFXRRdZo0Qxj+qyRnQ0/j0/lnKLYgipwS1lB
FU0J754KqNiz+dC7Tw087tORs1lDF+gHy8mTkZqMV0OXRWqS5xesfK5i5YVW3LGMGYF74AsLRTCm
B6fTPGPoWZUbarFqD46MHSwT40MW6FW3lItifcWaManqQircD9qqyDXJ55Wwbt+S97KmZzSBWney
c/pBgHmQ9emowTx0NTMt2jleKFZjRqCpc5bKEuvtPitrspAr5QSNGsHO96T6+zhKK1+pppKJ8h+l
3+O2LCsd3d97HYWjKuqQHCVrWtU0S1gN7NCWVV0xxVVVW8kJaXFCR9FFVoTTNbi0Ik02PHoGdJb2
5KapwmOJyKJpRs4Qe17IKppii3A5WcXKmGrec5YVCEHku4oK8WyCD1llQqsE+b+ywVUayGVCLlN3
3s2p2Iexn9mXbopsgxdAKFbRlWebHYJ6btqNdaMZYM1pyzZMqDp/qnWBsnwzmYgnOzro+/WOUiG8
T+EjUYbZDAQAqjKxGZXyhrJq2bGuITnYUamwCtedThW+NM+Nr48ne3roi2e8rG76vJrnazoGkhsr
c7zFLMESif4ovvK8/qKGHryYXql8wKdqNfjqhJtKdD+ZaEiO94TQqsUaWmBXi3/YtCyT8QSJ8uUI
NoASn72CNe8d4RXi7voW+7uFS6o4mml/S0NyrLuix/HdMHgeX7oNRwUjELULtH8EAu0fgUCg/SMQ
CLR/BAKB9o9AINa2/deTHYTsoK/Sz2I3WDPpLp+zrTU+d2aDEy/tasLlXhwS05Xt5bgWZ88qzZuN
zE86sdXCGb6MqTij57KyLYfl9UyGXwE+O0DwlOfhfHexDBZOiKae27LRmfg+b5XqPa3q50HJ8iUe
rtQKihmCjSECK+o7SmT2NHDgXqncYarEcZY/auDUiw/qN5dFNfbEpqWm1/tKuVBxxeSWK0ars9jD
/KOe+uPDnyzP146KdefsXpYZh9eaoPEuNZ6xOsWOD0gIBP5AQiAQaP8IBALtH4FAoP0jEIi1bf8x
uovQXewG+R1eNYA9m5daH3fKmLGUNJ+MY6VTnoTEHeXVrjaHInqt0+lqdnZbrtxapoPZ3bMaCwk7
hEnopHBZ5JDiK1PyKcEFrSowW3zmu8A0YPV5odmhqsgcY1Nogn/WMEyRGc9K1hJZk1ZTRBYP5XRA
2IzWw4MjE0MlqlBTZDOqiuBS1T3tS/F0rvkUrNDqxGcVBAJ/qyAQiNq0/zp6gNADsUuxT9i3MXdl
ih/g9S/G/onxEXjskc4ZZk62pQHwcJSSAxL/vXEkkPcgvKknTaOepB7eW5nNv06wv9hddof9ym6x
n9iP7Ca7wb5j37Cv2Bfsc/Ypu8Y+Yh+w99i77B32FnudvcLm2Qts1lWuFjD2SLVij2AknGVEwlnN
GErQ+k88A2L8FIjjEyDGjoMYHQVx7CiIkWEQR7kreHoIxPAhEI7akccm7f3weXgfiKf2gji0mzuJ
ARB8Vwo+9/aC6N8OYucjILq5V3HcZid86doCYls7iM2tIB5q4U62CURTg7vY628ENgQCscbRTFkX
zZ5Ng+uyVENPuvZ/h8CGQCDWvAPw2X8h2MNNAhsCgVgjcJf2rKP0GCWnFS1j5BTJNqSTU4p02DAn
DdtWdGnC+QnT5fqAPwhsCASiRhB3IscUA77dI7AhEIgaMX8nchQpBny6S2BDIBA1gaZ66po/xfEW
CETtwokIQhsJbaQf09uxa7Fb7Gv2d22VAR+YsKp08IntAyGBl7wBF0JHHXjPwAcSxCIMJHB1Fihx
N8lwIMEyBhLgsJYqDWvhvomR04ScpvfY9+w6u+7a6/ypxniys5O+dMmW5zvjTiyVq4HSzxumbflT
jYXyX4ZK2SpzcqzS0mBhi0yVj+D3gEQHDGtvZSdf8NINN/FibjnCdIpEt7fhlIIvWcXPdZXDLa1W
5Km8bFkXSkYfktlUcll5VnDyDmhEV1BysqqJRg0shSBaUOmrGCqoGDTQyEyLhGETn7gUEszWF7+x
0vp24M92NTUkD3WGxH6yFoI+WevdHpZfCGwIBGKtoo2uIy0tjCZaKKWpFLl/n/SRIsPyJ4ENgUDU
DOpZC00V7P9lAhsCgfhncIHuJj2c9aCxGA0gUfxLAt513h2D7lO8dEzW5UnFJA5r8ja8OPTCofv7
4/SN0pnW17c/R7IcCz2slN0msCEQiLX7A6AOHMwijwE7NkTuhegVj+O91Hrivk6NArNgZGRP8PoI
HSdTiqzZU6Fn6Atq5OSLIkrKxbxiqoouskaLZhjTZ43sbPh5fCrnFMUWVIFbygqqaEp491RAxZ7N
h959auBxn46czRq6QD9YTp6M1GS8GrosUpM8v2DlcxUrL7TijmXMCNwDX1gogjE9OJ3mGUPPqtxQ
i1V7cGTsYJkYH7JAr7qlXBTrK9aMSVUXUuF+0FZFrkk+r4R1+5a8lzU9ownUupOd0w8CzIOsT0cN
5qGrmWnRzvFCsRozAk2ds1SWWG/3WVmThVwpJ2jUCHa+J9Xfx1Fa+Uo1lUyU/yj9HrdlWeno/t7r
KBxVUYfkKFnTqqZZwmpgh7as6ooprqraSk5IixM6ii6yIpyuwaUVabLh0TOgs7QnN00VHktEFk0z
cobY80JW0RRbhMvJKlbGVPOes6xACCLfVVSIZxN8yCoTWiXI/5UNrtJALhNymbrzbk7FPoz9zL50
U2QbvABCsYquPNvsENRz026sG80Aa05btmFC1flTrQuU5ZvJRDzZ0UHfr3eUCuF9Ch+JMsxmIABQ
lYnNqJQ3lFXLjnUNycGOSoVVuO50qvCleW58fTzZ00NfPONlddPn1Txf0zGQ3FiZ4y1mCZZI9Efx
lef1FzX04MX0SuUDPlWrwVcn3FSi+8lEQ3K8J4RWLdbQArta/MOmZZmMJ0iUL0ewAZT47BWsee8I
rxB317fY3y1cUsXRTPtbGpJj3RU9ju+GwfP40m04KhiBqF2g/SMQaP8IBALtH4FAoP0jEAi0fwQC
sbbtv57sIGQHfZV+FrvBmkl3+ZxtrfG5MxuceGlXEy734pCYrmwvx7U4e1Zp3mxkftKJrRbO8GVM
xRk9l5VtOSyvZzL8CvDZAYKnPA/nu4tlsHBCNPXclo3OxPd5q1TvaVU/D0qWL/FwpVZQzBBsDBFY
Ud9RIrOngQP3SuUOUyWOs/xRA6defFC/uSyqsSc2LTW93lfKhYorJrdcMVqdxR7mH/XUHx/+ZHm+
dlSsO2f3ssw4vNYEjXep8YzVKXZ8QEIg8AcSAoFA+0cgEGj/CAQC7R+BQKxt+4/RXYTuYjfI7/Cq
AezZvNT6uFPGjKWk+WQcK53yJCTuKK92tTkU0WudTlezs9ty5dYyHczuntVYSNghTEInhcsihxRf
mZJPCS5oVYHZ4jPfBaYBq88LzQ5VReYYm0IT/LOGYYrMeFaylsiatJoisngopwPCZrQeHhyZGCpR
hZoim1FVBJeq7mlfiqdzzadghVYnPqsgEPhbBYFA1Kb919EDhB6IXYp9wr6NuStT/ACvfzH2/z+z
CIMC
----TNIJ DOT?D----
----SUROWE DANE ST?D----

ERROR: C1 C2 LEN: 15 16 262080
STR:

SVN: $Id: sqlparser.lib.php 11017 2007-12-21 18:18:44Z lem9 $
MySQL: 5.0.51
USR OS, AGENT, VER: Win IE 8.0
PMA: 2.11.4
PHP VER,OS: 5.2.5 WINNT
LANG: pl-utf-8
SQL: SQLite format 3

@ GB

tS�������������������������~yt�[''
�utableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'
indexsqlite_autoindex_server_record_1server_record�C##
�Mtableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#
indexsqlite_autoindex_server_motd_1server_motd�$
''
�tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHARVQUPSOPNNMKLIKGJEICHAG>F7C4B3>17,2(.#) &!


��
!
db_version

��!
db_version


��&


M
Welcome to The Forgotten Server!

��






��





�� 









�
������[�$
''
�tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'
indexsqlite_autoindex_server_config_1server_config�C##
�Mtableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#
indexsqlite_autoindex_server_motd_1server_motd�[''
�utableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'
indexsqlite_autoindex_server_record_1server_record
WW
�����U
�}ta�))
�utableserver_reportsserver_reportsCREATE �))
�utableserver_reportsserver_reportsCREATE TABLE "server_reports" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL DEFAULT 0,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL DEFAULT 0,
"report" TEXT NOT NULL DEFAULT '',
"reads" INTEGER NOT NULL DEFAULT 0
)�U
�}tableaccountsaccountsCREATE TABLE "accounts" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"password" VARCHAR(255) NOT NULL,
"premdays" INTEGER NOT NULL DEFAULT 0,
"lastday" INTEGER NOT NULL DEFAULT 0,
"email" VARCHAR(255) NOT NULL DEFAULT '',
"key" VARCHAR(20) NOT NULL DEFAULT '0',
"blocked" BOOLEAN NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL DEFAULT 1,
UNIQUE ("name")
)/ C
indexsqlite_autoindex_accounts_1accounts

��





11��0


��
1


��w
4+












































Account Manager


��n22
�`ddddd

��+

Account Manager
0,
"group_id" INTEGER NOT NULL,
"account_id" INTEGER NOT NULL,
"level" INTEGER NOT NULL DEFAULT 1,
"vocation" INTEGER NOT NULL DEFAULT 0,
"health" INTEGER NOT NULL DEFAULT 100,
"healthmax" INTEGER NOT NULL DEFAULT 100,
"experience" INTEGER NOT NULL DEFAULT 0,
"lookbody" INTEGER NOT NULL DEFAULT 10,
"lookfeet" INTEGER NOT NULL DEFAULT 10,
"lookhead" INTEGER NOT NULL DEFAULT 10,
"looklegs" INTEGER NOT NULL DEFAULT 10,
"looktype" INTEGER NOT NULL DEFAULT 136,
"lookaddons" INTEGER NOT NULL DEFAULT 0,
"maglevel" INTEGER NOT NULL DEFAULT 0,
"mana" INTEGER NOT NULL DEFAULT 100,
"manamax" INTEGER NOT NULL DEFAULT 100,
"manaspent" INTEGER NOT NULL DEFAULT 0,
"soul" INTEGER NOT NULL DEFAULT 0,
"town_id" INTEGER NOT NULL,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"conditions" BLOB NOT NULL,
"cap" INTEGER NOT NULL DEFAULT 0,
"sex" INTEGER NOT NULL DEFAULT 0,
"lastlogin" INTEGER NOT NULL DEFAULT 0,
"lastip" INTEGER NOT NULL DEFAULT 0,
"save" BOOLEAN NOT NULL DEFAULT 1,
"skull" INTEGER NOT NULL DEFAULT 0,
"skulltime" INTEGER NOT NULL DEFAULT 0,
"rank_id" INTEGER NOT NULL,
"guildnick" VARCHAR(255) NOT NULL DEFAULT '',
"lastlogout" INTEGER NOT NULL DEFAULT 0,
"blessings" INTEGER NOT NULL DEFAULT 0,
"balance" INTEGER NOT NULL DEFAULT 0,
"stamina" INTEGER NOT NULL DEFAULT 151200000,
"direction" INTEGER NOT NULL DEFAULT 2,
"loss_experience" INTEGER NOT NULL DEFAULT 100,
"loss_mana" INTEGER NOT NULL DEFAULT 100,
"loss_skills" INTEGER NOT NULL DEFAULT 100,
"loss_containers" INTEGER NOT NULL DEFAULT 100,
"loss_items" INTEGER NOT NULL DEFAULT 100,
"premend" INTEGER NOT NULL DEFAULT 0,
"online" TINYINT NOT NULL DEFAULT 0,
"marriage" INTEGER NOT NULL DEFAULT 0,
"promotion" INTEGER NOT NULL DEFAULT 0,
"deleted" BOOLEAN NOT NULL DEFAULT 0,
"description" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "deleted"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")
)
��
&
U���
&+?
indexsqlite_autoindex_guilds_1guilds�X))
�ktableglobal_storageglobal_storageCREATE TA�

�tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT -A
indexsqlite_autoindex_players_1players�Q++
�Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (
"account_id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL,
UNIQUE ("account_id", "player_id"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)=
Q+
indexsqlite_autoindex_account_viplist_1account_viplist�X))
�ktableglobal_storageglobal_storageCREATE TABLE "global_storage" (
"key" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"value" VARCHAR(255) NOT NULL DEFAULT '0',
UNIQUE ("key", "world_id")
);O)
indexsqlite_autoindex_global_storage_1global_storage






--
�
��)�Y
�
tableguildsguildsCREATE TABLE "guilds" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"ownerid" INTEGER NOT NULL,
"creationdata" INTEGER NOT NULL,
"motd" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "world_id"),
FOREIGN KEY ("ownerid") REFERENCES "players" ("id")
)+?
indexsqlite_autoindex_guilds_1guilds�''
�stableguild_invitesguild_invitesCREATE TABLE "guild_invites" (
"player_id" INTEGER NOT NULL,
"guild_id" INTEGER NOT NULL,
UNIQUE ("player_id", "guild_id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id"),
FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")
)9M'
indexsqlite_autoindex_guild_invites_1guild_invites�o##
�%tableguild_ranksguild_ranksCREATE TABLE "guild_ranks" (
"id" INTEGER PRIMARY KEY,
"guild_id" INTEGER NOT NULL,
"name" VARCHAR(255) NOT NULL,
"level" INTEGER NOT NULL,
FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")
)






/
/���5I#
indexsqlite_autoindex_house_lists_1house_lists �!
�tablehouseshousesCREATE TABLE "houses" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"owner" INTEGER NOT NULL,
"paid" INTEGER NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"lastwarning" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"town" INTEGER NOT NULL DEFAULT 0,
"size" INTEGER NOT NULL DEFAULT 0,
"price" INTEGER NOT NULL DEFAULT 0,
"rent" INTEGER NOT NULL DEFAULT 0,
"doors" INTEGER NOT NULL DEFAULT 0,
"beds" INTEGER NOT NULL DEFAULT 0,
"tiles" INTEGER NOT NULL DEFAULT 0,
"guild" BOOLEAN NOT NULL DEFAULT FALSE,
"clear" BOOLEAN NOT NULL DEFAULT FALSE,
UNIQUE ("id", "world_id")
)+?
indexsqlite_autoindex_houses_1houses



@
@}��&��;SQLite format 3

@ GB

tS�������������������������~yt�[''
�utableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'
indexsqlite_autoindex_server_record_1server_record�C##
�Mtableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#
indexsqlite_autoindex_server_motd_1server_motd�$
''
�tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHARVQUPSOPNNMKLIKGJEICHAG>F7C4B3>17,2(.#) &!


��
!
db_version

��!
db_version


��&


M
Welcome to The Forgotten Server!

��






��





�� 









�
������[�$
''
�tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'
indexsqlite_autoindex_server_config_1server_config�C##
�Mtableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#
indexsqlite_autoindex_server_motd_1server_motd�[''
�utableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'
indexsqlite_autoindex_server_record_1server_record
WW
�����U
�}ta�))
�utableserver_reportsserver_reportsCREATE �))
�utableserver_reportsserver_reportsCREATE TABLE "server_reports" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL DEFAULT 0,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL DEFAULT 0,
"report" TEXT NOT NULL DEFAULT '',
"reads" INTEGER NOT NULL DEFAULT 0
)�U
�}tableaccountsaccountsCREATE TABLE "accounts" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"password" VARCHAR(255) NOT NULL,
"premdays" INTEGER NOT NULL DEFAULT 0,
"lastday" INTEGER NOT NULL DEFAULT 0,
"email" VARCHAR(255) NOT NULL DEFAULT '',
"key" VARCHAR(20) NOT NULL DEFAULT '0',
"blocked" BOOLEAN NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL DEFAULT 1,
UNIQUE ("name")
)/ C
indexsqlite_autoindex_accounts_1accounts

��





11��0


��
1


��w
4+












































Account Manager


��n22
�`ddddd

��+

Account Manager
0,
"group_id" INTEGER NOT NULL,
"account_id" INTEGER NOT NULL,
"level" INTEGER NOT NULL DEFAULT 1,
"vocation" INTEGER NOT NULL DEFAULT 0,
"health" INTEGER NOT NULL DEFAULT 100,
"healthmax" INTEGER NOT NULL DEFAULT 100,
"experience" INTEGER NOT NULL DEFAULT 0,
"lookbody" INTEGER NOT NULL DEFAULT 10,
"lookfeet" INTEGER NOT NULL DEFAULT 10,
"lookhead" INTEGER NOT NULL DEFAULT 10,
"looklegs" INTEGER NOT NULL DEFAULT 10,
"looktype" INTEGER NOT NULL DEFAULT 136,
"lookaddons" INTEGER NOT NULL DEFAULT 0,
"maglevel" INTEGER NOT NULL DEFAULT 0,
"mana" INTEGER NOT NULL DEFAULT 100,
"manamax" INTEGER NOT NULL DEFAULT 100,
"manaspent" INTEGER NOT NULL DEFAULT 0,
"soul" INTEGER NOT NULL DEFAULT 0,
"town_id" INTEGER NOT NULL,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"conditions" BLOB NOT NULL,
"cap" INTEGER NOT NULL DEFAULT 0,
"sex" INTEGER NOT NULL DEFAULT 0,
"lastlogin" INTEGER NOT NULL DEFAULT 0,
"lastip" INTEGER NOT NULL DEFAULT 0,
"save" BOOLEAN NOT NULL DEFAULT 1,
"skull" INTEGER NOT NULL DEFAULT 0,
"skulltime" INTEGER NOT NULL DEFAULT 0,
"rank_id" INTEGER NOT NULL,
"guildnick" VARCHAR(255) NOT NULL DEFAULT '',
"lastlogout" INTEGER NOT NULL DEFAULT 0,
"blessings" INTEGER NOT NULL DEFAULT 0,
"balance" INTEGER NOT NULL DEFAULT 0,
"stamina" INTEGER NOT NULL DEFAULT 151200000,
"direction" INTEGER NOT NULL DEFAULT 2,
"loss_experience" INTEGER NOT NULL DEFAULT 100,
"loss_mana" INTEGER NOT NULL DEFAULT 100,
"loss_skills" INTEGER NOT NULL DEFAULT 100,
"loss_containers" INTEGER NOT NULL DEFAULT 100,
"loss_items" INTEGER NOT NULL DEFAULT 100,
"premend" INTEGER NOT NULL DEFAULT 0,
"online" TINYINT NOT NULL DEFAULT 0,
"marriage" INTEGER NOT NULL DEFAULT 0,
"promotion" INTEGER NOT NULL DEFAULT 0,
"deleted" BOOLEAN NOT NULL DEFAULT 0,
"description" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "deleted"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")
)
��
&
U���
&+?
indexsqlite_autoindex_guilds_1guilds�X))
�ktableglobal_storageglobal_storageCREATE TA�

�tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT -A
indexsqlite_autoindex_players_1players�Q++
�Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (
"account_id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL,
UNIQUE ("account_id", "player_id"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)=
Q+
indexsqlite_autoindex_account_viplist_1account_viplist�X))
�ktableglobal_storageglobal_storageCREATE TABLE "global_storage" (
"key" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"value" VARCHAR(255) NOT NULL DEFAULT '0',
UNIQUE ("key", "world_id")
);O)
indexsqlite_autoindex_global_storage_1global_storage






--
�
��)�Y
�
tableguildsguildsCREATE TABLE "guilds" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"ownerid" INTEGER NOT NULL,
"creationdata" INTEGER NOT NULL,
"motd" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "world_id"),
FOREIGN KEY ("ownerid") REFERENCES "players" ("id")
)+?
indexsqlite_autoindex_guilds_1guilds�''
�stableguild_invitesguild_invitesCREATE TABLE "guild_invites" (
"player_id" INTEGER NOT NULL,
"guild_id" INTEGER NOT NULL,
UNIQUE ("player_id", "guild_id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id"),
FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")
)9M'
indexsqlite_autoindex_guild_invites_1guild_invites�o##
�%tableguild_ranksguild_ranksCREATE TABLE "guild_ranks" (
"id" INTEGER PRIMARY KEY,
"guild_id" INTEGER NOT NULL,
"name" VARCHAR(255) NOT NULL,
"level" INTEGER NOT NULL,
FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")
)






/
/���5I#
indexsqlite_autoindex_house_lists_1house_lists �!
�tablehouseshousesCREATE TABLE "houses" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"owner" INTEGER NOT NULL,
"paid" INTEGER NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"lastwarning" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"town" INTEGER NOT NULL DEFAULT 0,
"size" INTEGER NOT NULL DEFAULT 0,
"price" INTEGER NOT NULL DEFAULT 0,
"rent" INTEGER NOT NULL DEFAULT 0,
"doors" INTEGER NOT NULL DEFAULT 0,
"beds" INTEGER NOT NULL DEFAULT 0,
"tiles" INTEGER NOT NULL DEFAULT 0,
"guild" BOOLEAN NOT NULL DEFAULT FALSE,
"clear" BOOLEAN NOT NULL DEFAULT FALSE,
UNIQUE ("id", "world_id")
)+?
indexsqlite_autoindex_houses_1houses



@
@}��&��;SQLite format 3

@ GB

tS�������������������������~yt�[''
�utableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'
indexsqlite_autoindex_server_record_1server_record�C##
�Mtableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#
indexsqlite_autoindex_server_motd_1server_motd�$
''
�tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHARVQUPSOPNNMKLIKGJEICHAG>F7C4B3>17,2(.#) &!


��
!
db_version

��!
db_version


��&


M
Welcome to The Forgotten Server!

��






��





�� 









�
������[�$
''
�tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'
indexsqlite_autoindex_server_config_1server_config�C##
�Mtableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#
indexsqlite_autoindex_server_motd_1server_motd�[''
�utableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'
indexsqlite_autoindex_server_record_1server_record
WW
�����U
�}ta�))
�utableserver_reportsserver_reportsCREATE �))
�utableserver_reportsserver_reportsCREATE TABLE "server_reports" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL DEFAULT 0,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL DEFAULT 0,
"report" TEXT NOT NULL DEFAULT '',
"reads" INTEGER NOT NULL DEFAULT 0
)�U
�}tableaccountsaccountsCREATE TABLE "accounts" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"password" VARCHAR(255) NOT NULL,
"premdays" INTEGER NOT NULL DEFAULT 0,
"lastday" INTEGER NOT NULL DEFAULT 0,
"email" VARCHAR(255) NOT NULL DEFAULT '',
"key" VARCHAR(20) NOT NULL DEFAULT '0',
"blocked" BOOLEAN NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL DEFAULT 1,
UNIQUE ("name")
)/ C
indexsqlite_autoindex_accounts_1accounts

��





11��0


��
1


��w
4+












































Account Manager


��n22
�`ddddd

��+

Account Manager
0,
"group_id" INTEGER NOT NULL,
"account_id" INTEGER NOT NULL,
"level" INTEGER NOT NULL DEFAULT 1,
"vocation" INTEGER NOT NULL DEFAULT 0,
"health" INTEGER NOT NULL DEFAULT 100,
"healthmax" INTEGER NOT NULL DEFAULT 100,
"experience" INTEGER NOT NULL DEFAULT 0,
"lookbody" INTEGER NOT NULL DEFAULT 10,
"lookfeet" INTEGER NOT NULL DEFAULT 10,
"lookhead" INTEGER NOT NULL DEFAULT 10,
"looklegs" INTEGER NOT NULL DEFAULT 10,
"looktype" INTEGER NOT NULL DEFAULT 136,
"lookaddons" INTEGER NOT NULL DEFAULT 0,
"maglevel" INTEGER NOT NULL DEFAULT 0,
"mana" INTEGER NOT NULL DEFAULT 100,
"manamax" INTEGER NOT NULL DEFAULT 100,
"manaspent" INTEGER NOT NULL DEFAULT 0,
"soul" INTEGER NOT NULL DEFAULT 0,
"town_id" INTEGER NOT NULL,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"conditions" BLOB NOT NULL,
"cap" INTEGER NOT NULL DEFAULT 0,
"sex" INTEGER NOT NULL DEFAULT 0,
"lastlogin" INTEGER NOT NULL DEFAULT 0,
"lastip" INTEGER NOT NULL DEFAULT 0,
"save" BOOLEAN NOT NULL DEFAULT 1,
"skull" INTEGER NOT NULL DEFAULT 0,
"skulltime" INTEGER NOT NULL DEFAULT 0,
"rank_id" INTEGER NOT NULL,
"guildnick" VARCHAR(255) NOT NULL DEFAULT '',
"lastlogout" INTEGER NOT NULL DEFAULT 0,
"blessings" INTEGER NOT NULL DEFAULT 0,
"balance" INTEGER NOT NULL DEFAULT 0,
"stamina" INTEGER NOT NULL DEFAULT 151200000,
"direction" INTEGER NOT NULL DEFAULT 2,
"loss_experience" INTEGER NOT NULL DEFAULT 100,
"loss_mana" INTEGER NOT NULL DEFAULT 100,
"loss_skills" INTEGER NOT NULL DEFAULT 100,
"loss_containers" INTEGER NOT NULL DEFAULT 100,
"loss_items" INTEGER NOT NULL DEFAULT 100,
"premend" INTEGER NOT NULL DEFAULT 0,
"online" TINYINT NOT NULL DEFAULT 0,
"marriage" INTEGER NOT NULL DEFAULT 0,
"promotion" INTEGER NOT NULL DEFAULT 0,
"deleted" BOOLEAN NOT NULL DEFAULT 0,
"description" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "deleted"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")
)
��
&
U���
&+?
indexsqlite_autoindex_guilds_1guilds�X))
�ktableglobal_storageglobal_storageCREATE TA�

�tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT -A
indexsqlite_autoindex_players_1players�Q++
�Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (
"account_id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL,
UNIQUE ("account_id", "player_id"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)=
Q+
indexsqlite_autoindex_account_viplist_1account_viplist�X))
�ktableglobal_storageglobal_storageCREATE TABLE "global_storage" (
"key" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"value" VARCHAR(255) NOT NULL DEFAULT '0',
UNIQUE ("key", "world_id")
);O)
indexsqlite_autoindex_global_storage_1global_storage






--
�
��)�Y
�
tableguildsguildsCREATE TABLE "guilds" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"ownerid" INTEGER NOT NULL,
"creationdata" INTEGER NOT NULL,
"motd" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "world_id"),
FOREIGN KEY ("ownerid") REFERENCES "players" ("id")
)+?
indexsqlite_autoindex_guilds_1guilds�''
�stableguild_invitesguild_invitesCREATE TABLE "guild_invites" (
"player_id" INTEGER NOT NULL,
"guild_id" INTEGER NOT NULL,
UNIQUE ("player_id", "guild_id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id"),
FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")
)9M'
indexsqlite_autoindex_guild_invites_1guild_invites�o##
�%tableguild_ranksguild_ranksCREATE TABLE "guild_ranks" (
"id" INTEGER PRIMARY KEY,
"guild_id" INTEGER NOT NULL,
"name" VARCHAR(255) NOT NULL,
"level" INTEGER NOT NULL,
FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")
)






/
/���5I#
indexsqlite_autoindex_house_lists_1house_lists �!
�tablehouseshousesCREATE TABLE "houses" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"owner" INTEGER NOT NULL,
"paid" INTEGER NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"lastwarning" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"town" INTEGER NOT NULL DEFAULT 0,
"size" INTEGER NOT NULL DEFAULT 0,
"price" INTEGER NOT NULL DEFAULT 0,
"rent" INTEGER NOT NULL DEFAULT 0,
"doors" INTEGER NOT NULL DEFAULT 0,
"beds" INTEGER NOT NULL DEFAULT 0,
"tiles" INTEGER NOT NULL DEFAULT 0,
"guild" BOOLEAN NOT NULL DEFAULT FALSE,
"clear" BOOLEAN NOT NULL DEFAULT FALSE,
UNIQUE ("id", "world_id")
)+?
indexsqlite_autoindex_houses_1houses



@
@}��&��;SQLite format 3

@ GB

tS�������������������������~yt�[''
�utableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'
indexsqlite_autoindex_server_record_1server_record�C##
�Mtableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#
indexsqlite_autoindex_server_motd_1server_motd�$
''
�tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHARVQUPSOPNNMKLIKGJEICHAG>F7C4B3>17,2(.#) &!


��
!
db_version

��!
db_version


��&


M
Welcome to The Forgotten Server!

��






��





�� 









�
������[�$
''
�tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'
indexsqlite_autoindex_server_config_1server_config�C##
�Mtableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#
indexsqlite_autoindex_server_motd_1server_motd�[''
�utableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'
indexsqlite_autoindex_server_record_1server_record
WW
�����U
�}ta�))
�utableserver_reportsserver_reportsCREATE �))
�utableserver_reportsserver_reportsCREATE TABLE "server_reports" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL DEFAULT 0,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL DEFAULT 0,
"report" TEXT NOT NULL DEFAULT '',
"reads" INTEGER NOT NULL DEFAULT 0
)�U
�}tableaccountsaccountsCREATE TABLE "accounts" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"password" VARCHAR(255) NOT NULL,
"premdays" INTEGER NOT NULL DEFAULT 0,
"lastday" INTEGER NOT NULL DEFAULT 0,
"email" VARCHAR(255) NOT NULL DEFAULT '',
"key" VARCHAR(20) NOT NULL DEFAULT '0',
"blocked" BOOLEAN NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL DEFAULT 1,
UNIQUE ("name")
)/ C
indexsqlite_autoindex_accounts_1accounts

��





11��0


��
1


��w
4+












































Account Manager


��n22
�`ddddd

��+

Account Manager
0,
"group_id" INTEGER NOT NULL,
"account_id" INTEGER NOT NULL,
"level" INTEGER NOT NULL DEFAULT 1,
"vocation" INTEGER NOT NULL DEFAULT 0,
"health" INTEGER NOT NULL DEFAULT 100,
"healthmax" INTEGER NOT NULL DEFAULT 100,
"experience" INTEGER NOT NULL DEFAULT 0,
"lookbody" INTEGER NOT NULL DEFAULT 10,
"lookfeet" INTEGER NOT NULL DEFAULT 10,
"lookhead" INTEGER NOT NULL DEFAULT 10,
"looklegs" INTEGER NOT NULL DEFAULT 10,
"looktype" INTEGER NOT NULL DEFAULT 136,
"lookaddons" INTEGER NOT NULL DEFAULT 0,
"maglevel" INTEGER NOT NULL DEFAULT 0,
"mana" INTEGER NOT NULL DEFAULT 100,
"manamax" INTEGER NOT NULL DEFAULT 100,
"manaspent" INTEGER NOT NULL DEFAULT 0,
"soul" INTEGER NOT NULL DEFAULT 0,
"town_id" INTEGER NOT NULL,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"conditions" BLOB NOT NULL,
"cap" INTEGER NOT NULL DEFAULT 0,
"sex" INTEGER NOT NULL DEFAULT 0,
"lastlogin" INTEGER NOT NULL DEFAULT 0,
"lastip" INTEGER NOT NULL DEFAULT 0,
"save" BOOLEAN NOT NULL DEFAULT 1,
"skull" INTEGER NOT NULL DEFAULT 0,
"skulltime" INTEGER NOT NULL DEFAULT 0,
"rank_id" INTEGER NOT NULL,
"guildnick" VARCHAR(255) NOT NULL DEFAULT '',
"lastlogout" INTEGER NOT NULL DEFAULT 0,
"blessings" INTEGER NOT NULL DEFAULT 0,
"balance" INTEGER NOT NULL DEFAULT 0,
"stamina" INTEGER NOT NULL DEFAULT 151200000,
"direction" INTEGER NOT NULL DEFAULT 2,
"loss_experience" INTEGER NOT NULL DEFAULT 100,
"loss_mana" INTEGER NOT NULL DEFAULT 100,
"loss_skills" INTEGER NOT NULL DEFAULT 100,
"loss_containers" INTEGER NOT NULL DEFAULT 100,
"loss_items" INTEGER NOT NULL DEFAULT 100,
"premend" INTEGER NOT NULL DEFAULT 0,
"online" TINYINT NOT NULL DEFAULT 0,
"marriage" INTEGER NOT NULL DEFAULT 0,
"promotion" INTEGER NOT NULL DEFAULT 0,
"deleted" BOOLEAN NOT NULL DEFAULT 0,
"description" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "deleted"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")
)
��
&
U���
&+?
indexsqlite_autoindex_guilds_1guilds�X))
�ktableglobal_storageglobal_storageCREATE TA�

�tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT -A
indexsqlite_autoindex_players_1players�Q++
�Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (
"account_id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL,
UNIQUE ("account_id", "player_id"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)=
Q+
indexsqlite_autoindex_account_viplist_1account_viplist�X))
�ktableglobal_storageglobal_storageCREATE TABLE "global_storage" (
"key" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"value" VARCHAR(255) NOT NULL DEFAULT '0',
UNIQUE ("key", "world_id")
);O)
indexsqlite_autoindex_global_storage_1global_storage






--
�
��)�Y
�
tableguildsguildsCREATE TABLE "guilds" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"ownerid" INTEGER NOT NULL,
"creationdata" INTEGER NOT NULL,
"motd" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "world_id"),
FOREIGN KEY ("ownerid") REFERENCES "players" ("id")
)+?
indexsqlite_autoindex_guilds_1guilds�''
�stableguild_invitesguild_invitesCREATE TABLE "guild_invites" (
"player_id" INTEGER NOT NULL,
"guild_id" INTEGER NOT NULL,
UNIQUE ("player_id", "guild_id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id"),
FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")
)9M'
indexsqlite_autoindex_guild_invites_1guild_invites�o##
�%tableguild_ranksguild_ranksCREATE TABLE "guild_ranks" (
"id" INTEGER PRIMARY KEY,
"guild_id" INTEGER NOT NULL,
"name" VARCHAR(255) NOT NULL,
"level" INTEGER NOT NULL,
FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")
)






/
/���5I#
indexsqlite_autoindex_house_lists_1house_lists �!
�tablehouseshousesCREATE TABLE "houses" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"owner" INTEGER NOT NULL,
"paid" INTEGER NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"lastwarning" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"town" INTEGER NOT NULL DEFAULT 0,
"size" INTEGER NOT NULL DEFAULT 0,
"price" INTEGER NOT NULL DEFAULT 0,
"rent" INTEGER NOT NULL DEFAULT 0,
"doors" INTEGER NOT NULL DEFAULT 0,
"beds" INTEGER NOT NULL DEFAULT 0,
"tiles" INTEGER NOT NULL DEFAULT 0,
"guild" BOOLEAN NOT NULL DEFAULT FALSE,
"clear" BOOLEAN NOT NULL DEFAULT FALSE,
UNIQUE ("id", "world_id")
)+?
indexsqlite_autoindex_houses_1houses



@
@}��&��;SQLite format 3

@ GB

tS�������������������������~yt�[''
�utableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'
indexsqlite_autoindex_server_record_1server_record�C##
�Mtableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#
indexsqlite_autoindex_server_motd_1server_motd�$
''
�tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHARVQUPSOPNNMKLIKGJEICHAG>F7C4B3>17,2(.#) &!


��
!
db_version

��!
db_version


��&


M
Welcome to The Forgotten Server!

��






��





�� 









�
������[�$
''
�tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'
indexsqlite_autoindex_server_config_1server_config�C##
�Mtableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#
indexsqlite_autoindex_server_motd_1server_motd�[''
�utableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'
indexsqlite_autoindex_server_record_1server_record
WW
�����U
�}ta�))
�utableserver_reportsserver_reportsCREATE �))
�utableserver_reportsserver_reportsCREATE TABLE "server_reports" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL DEFAULT 0,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL DEFAULT 0,
"report" TEXT NOT NULL DEFAULT '',
"reads" INTEGER NOT NULL DEFAULT 0
)�U
�}tableaccountsaccountsCREATE TABLE "accounts" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"password" VARCHAR(255) NOT NULL,
"premdays" INTEGER NOT NULL DEFAULT 0,
"lastday" INTEGER NOT NULL DEFAULT 0,
"email" VARCHAR(255) NOT NULL DEFAULT '',
"key" VARCHAR(20) NOT NULL DEFAULT '0',
"blocked" BOOLEAN NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL DEFAULT 1,
UNIQUE ("name")
)/ C
indexsqlite_autoindex_accounts_1accounts

��





11��0


��
1


��w
4+












































Account Manager


��n22
�`ddddd

��+

Account Manager
0,
"group_id" INTEGER NOT NULL,
"account_id" INTEGER NOT NULL,
"level" INTEGER NOT NULL DEFAULT 1,
"vocation" INTEGER NOT NULL DEFAULT 0,
"health" INTEGER NOT NULL DEFAULT 100,
"healthmax" INTEGER NOT NULL DEFAULT 100,
"experience" INTEGER NOT NULL DEFAULT 0,
"lookbody" INTEGER NOT NULL DEFAULT 10,
"lookfeet" INTEGER NOT NULL DEFAULT 10,
"lookhead" INTEGER NOT NULL DEFAULT 10,
"looklegs" INTEGER NOT NULL DEFAULT 10,
"looktype" INTEGER NOT NULL DEFAULT 136,
"lookaddons" INTEGER NOT NULL DEFAULT 0,
"maglevel" INTEGER NOT NULL DEFAULT 0,
"mana" INTEGER NOT NULL DEFAULT 100,
"manamax" INTEGER NOT NULL DEFAULT 100,
"manaspent" INTEGER NOT NULL DEFAULT 0,
"soul" INTEGER NOT NULL DEFAULT 0,
"town_id" INTEGER NOT NULL,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"conditions" BLOB NOT NULL,
"cap" INTEGER NOT NULL DEFAULT 0,
"sex" INTEGER NOT NULL DEFAULT 0,
"lastlogin" INTEGER NOT NULL DEFAULT 0,
"lastip" INTEGER NOT NULL DEFAULT 0,
"save" BOOLEAN NOT NULL DEFAULT 1,
"skull" INTEGER NOT NULL DEFAULT 0,
"skulltime" INTEGER NOT NULL DEFAULT 0,
"rank_id" INTEGER NOT NULL,
"guildnick" VARCHAR(255) NOT NULL DEFAULT '',
"lastlogout" INTEGER NOT NULL DEFAULT 0,
"blessings" INTEGER NOT NULL DEFAULT 0,
"balance" INTEGER NOT NULL DEFAULT 0,
"stamina" INTEGER NOT NULL DEFAULT 151200000,
"direction" INTEGER NOT NULL DEFAULT 2,
"loss_experience" INTEGER NOT NULL DEFAULT 100,
"loss_mana" INTEGER NOT NULL DEFAULT 100,
"loss_skills" INTEGER NOT NULL DEFAULT 100,
"loss_containers" INTEGER NOT NULL DEFAULT 100,
"loss_items" INTEGER NOT NULL DEFAULT 100,
"premend" INTEGER NOT NULL DEFAULT 0,
"online" TINYINT NOT NULL DEFAULT 0,
"marriage" INTEGER NOT NULL DEFAULT 0,
"promotion" INTEGER NOT NULL DEFAULT 0,
"deleted" BOOLEAN NOT NULL DEFAULT 0,
"description" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "deleted"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")
)
��
&
U���
&+?
indexsqlite_autoindex_guilds_1guilds�X))
�ktableglobal_storageglobal_storageCREATE TA�

�tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT -A
indexsqlite_autoindex_players_1players�Q++
�Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (
"account_id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL,
UNIQUE ("account_id", "player_id"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)=
Q+
indexsqlite_autoindex_account_viplist_1account_viplist�X))
�ktableglobal_storageglobal_storageCREATE TABLE "global_storage" (
"key" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"value" VARCHAR(255) NOT NULL DEFAULT '0',
UNIQUE ("key", "world_id")
);O)
indexsqlite_autoindex_global_storage_1global_storage






--
�
��)�Y
�
tableguildsguildsCREATE TABLE "guilds" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"ownerid" INTEGER NOT NULL,
"creationdata" INTEGER NOT NULL,
"motd" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "world_id"),
FOREIGN KEY ("ownerid") REFERENCES "players" ("id")
)+?
indexsqlite_autoindex_guilds_1guilds�''
�stableguild_invitesguild_invitesCREATE TABLE "guild_invites" (
"player_id" INTEGER NOT NULL,
"guild_id" INTEGER NOT NULL,
UNIQUE ("player_id", "guild_id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id"),
FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")
)9M'
indexsqlite_autoindex_guild_invites_1guild_invites�o##
�%tableguild_ranksguild_ranksCREATE TABLE "guild_ranks" (
"id" INTEGER PRIMARY KEY,
"guild_id" INTEGER NOT NULL,
"name" VARCHAR(255) NOT NULL,
"level" INTEGER NOT NULL,
FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")
)






/
/���5I#
indexsqlite_autoindex_house_lists_1house_lists �!
�tablehouseshousesCREATE TABLE "houses" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"owner" INTEGER NOT NULL,
"paid" INTEGER NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"lastwarning" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"town" INTEGER NOT NULL DEFAULT 0,
"size" INTEGER NOT NULL DEFAULT 0,
"price" INTEGER NOT NULL DEFAULT 0,
"rent" INTEGER NOT NULL DEFAULT 0,
"doors" INTEGER NOT NULL DEFAULT 0,
"beds" INTEGER NOT NULL DEFAULT 0,
"tiles" INTEGER NOT NULL DEFAULT 0,
"guild" BOOLEAN NOT NULL DEFAULT FALSE,
"clear" BOOLEAN NOT NULL DEFAULT FALSE,
UNIQUE ("id", "world_id")
)+?
indexsqlite_autoindex_houses_1houses



@
@}��&��;SQLite format 3

@ GB

tS�������������������������~yt�[''
�utableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'
indexsqlite_autoindex_server_record_1server_record�C##
�Mtableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#
indexsqlite_autoindex_server_motd_1server_motd�$
''
�tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHARVQUPSOPNNMKLIKGJEICHAG>F7C4B3>17,2(.#) &!


��
!
db_version

��!
db_version


��&


M
Welcome to The Forgotten Server!

��






��





�� 









�
������[�$
''
�tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'
indexsqlite_autoindex_server_config_1server_config�C##
�Mtableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#
indexsqlite_autoindex_server_motd_1server_motd�[''
�utableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'
indexsqlite_autoindex_server_record_1server_record
WW
�����U
�}ta�))
�utableserver_reportsserver_reportsCREATE �))
�utableserver_reportsserver_reportsCREATE TABLE "server_reports" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL DEFAULT 0,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL DEFAULT 0,
"report" TEXT NOT NULL DEFAULT '',
"reads" INTEGER NOT NULL DEFAULT 0
)�U
�}tableaccountsaccountsCREATE TABLE "accounts" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"password" VARCHAR(255) NOT NULL,
"premdays" INTEGER NOT NULL DEFAULT 0,
"lastday" INTEGER NOT NULL DEFAULT 0,
"email" VARCHAR(255) NOT NULL DEFAULT '',
"key" VARCHAR(20) NOT NULL DEFAULT '0',
"blocked" BOOLEAN NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL DEFAULT 1,
UNIQUE ("name")
)/ C
indexsqlite_autoindex_accounts_1accounts

��





11��0


��
1


��w
4+












































Account Manager


��n22
�`ddddd

��+

Account Manager
0,
"group_id" INTEGER NOT NULL,
"account_id" INTEGER NOT NULL,
"level" INTEGER NOT NULL DEFAULT 1,
"vocation" INTEGER NOT NULL DEFAULT 0,
"health" INTEGER NOT NULL DEFAULT 100,
"healthmax" INTEGER NOT NULL DEFAULT 100,
"experience" INTEGER NOT NULL DEFAULT 0,
"lookbody" INTEGER NOT NULL DEFAULT 10,
"lookfeet" INTEGER NOT NULL DEFAULT 10,
"lookhead" INTEGER NOT NULL DEFAULT 10,
"looklegs" INTEGER NOT NULL DEFAULT 10,
"looktype" INTEGER NOT NULL DEFAULT 136,
"lookaddons" INTEGER NOT NULL DEFAULT 0,
"maglevel" INTEGER NOT NULL DEFAULT 0,
"mana" INTEGER NOT NULL DEFAULT 100,
"manamax" INTEGER NOT NULL DEFAULT 100,
"manaspent" INTEGER NOT NULL DEFAULT 0,
"soul" INTEGER NOT NULL DEFAULT 0,
"town_id" INTEGER NOT NULL,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"conditions" BLOB NOT NULL,
"cap" INTEGER NOT NULL DEFAULT 0,
"sex" INTEGER NOT NULL DEFAULT 0,
"lastlogin" INTEGER NOT NULL DEFAULT 0,
"lastip" INTEGER NOT NULL DEFAULT 0,
"save" BOOLEAN NOT NULL DEFAULT 1,
"skull" INTEGER NOT NULL DEFAULT 0,
"skulltime" INTEGER NOT NULL DEFAULT 0,
"rank_id" INTEGER NOT NULL,
"guildnick" VARCHAR(255) NOT NULL DEFAULT '',
"lastlogout" INTEGER NOT NULL DEFAULT 0,
"blessings" INTEGER NOT NULL DEFAULT 0,
"balance" INTEGER NOT NULL DEFAULT 0,
"stamina" INTEGER NOT NULL DEFAULT 151200000,
"direction" INTEGER NOT NULL DEFAULT 2,
"loss_experience" INTEGER NOT NULL DEFAULT 100,
"loss_mana" INTEGER NOT NULL DEFAULT 100,
"loss_skills" INTEGER NOT NULL DEFAULT 100,
"loss_containers" INTEGER NOT NULL DEFAULT 100,
"loss_items" INTEGER NOT NULL DEFAULT 100,
"premend" INTEGER NOT NULL DEFAULT 0,
"online" TINYINT NOT NULL DEFAULT 0,
"marriage" INTEGER NOT NULL DEFAULT 0,
"promotion" INTEGER NOT NULL DEFAULT 0,
"deleted" BOOLEAN NOT NULL DEFAULT 0,
"description" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "deleted"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")
)
��
&
U���
&+?
indexsqlite_autoindex_guilds_1guilds�X))
�ktableglobal_storageglobal_storageCREATE TA�

�tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT -A
indexsqlite_autoindex_players_1players�Q++
�Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (
"account_id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL,
UNIQUE ("account_id", "player_id"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)=
Q+
indexsqlite_autoindex_account_viplist_1account_viplist�X))
�ktableglobal_storageglobal_storageCREATE TABLE "global_storage" (
"key" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"value" VARCHAR(255) NOT NULL DEFAULT '0',
UNIQUE ("key", "world_id")
);O)
indexsqlite_autoindex_global_storage_1global_storage






--
�
��)�Y
�
tableguildsguildsCREATE TABLE "guilds" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"ownerid" INTEGER NOT NULL,
"creationdata" INTEGER NOT NULL,
"motd" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "world_id"),
FOREIGN KEY ("ownerid") REFERENCES "players" ("id")
)+?
indexsqlite_autoindex_guilds_1guilds�''
�stableguild_invitesguild_invitesCREATE TABLE "guild_invites" (
"player_id" INTEGER NOT NULL,
"guild_id" INTEGER NOT NULL,
UNIQUE ("player_id", "guild_id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id"),
FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")
)9M'
indexsqlite_autoindex_guild_invites_1guild_invites�o##
�%tableguild_ranksguild_ranksCREATE TABLE "guild_ranks" (
"id" INTEGER PRIMARY KEY,
"guild_id" INTEGER NOT NULL,
"name" VARCHAR(255) NOT NULL,
"level" INTEGER NOT NULL,
FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")
)






/
/���5I#
indexsqlite_autoindex_house_lists_1house_lists �!
�tablehouseshousesCREATE TABLE "houses" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"owner" INTEGER NOT NULL,
"paid" INTEGER NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"lastwarning" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"town" INTEGER NOT NULL DEFAULT 0,
"size" INTEGER NOT NULL DEFAULT 0,
"price" INTEGER NOT NULL DEFAULT 0,
"rent" INTEGER NOT NULL DEFAULT 0,
"doors" INTEGER NOT NULL DEFAULT 0,
"beds" INTEGER NOT NULL DEFAULT 0,
"tiles" INTEGER NOT NULL DEFAULT 0,
"guild" BOOLEAN NOT NULL DEFAULT FALSE,
"clear" BOOLEAN NOT NULL DEFAULT FALSE,
UNIQUE ("id", "world_id")
)+?
indexsqlite_autoindex_houses_1houses



@
@}��&��;SQLite format 3

@ GB

tS�������������������������~yt�[''
�utableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'
indexsqlite_autoindex_server_record_1server_record�C##
�Mtableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#
indexsqlite_autoindex_server_motd_1server_motd�$
''
�tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHARVQUPSOPNNMKLIKGJEICHAG>F7C4B3>17,2(.#) &!


��
!
db_version

��!
db_version


��&


M
Welcome to The Forgotten Server!

��






��





�� 









�
������[�$
''
�tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'
indexsqlite_autoindex_server_config_1server_config�C##
�Mtableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#
indexsqlite_autoindex_server_motd_1server_motd�[''
�utableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'
indexsqlite_autoindex_server_record_1server_record
WW
�����U
�}ta�))
�utableserver_reportsserver_reportsCREATE �))
�utableserver_reportsserver_reportsCREATE TABLE "server_reports" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL DEFAULT 0,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL DEFAULT 0,
"report" TEXT NOT NULL DEFAULT '',
"reads" INTEGER NOT NULL DEFAULT 0
)�U
�}tableaccountsaccountsCREATE TABLE "accounts" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"password" VARCHAR(255) NOT NULL,
"premdays" INTEGER NOT NULL DEFAULT 0,
"lastday" INTEGER NOT NULL DEFAULT 0,
"email" VARCHAR(255) NOT NULL DEFAULT '',
"key" VARCHAR(20) NOT NULL DEFAULT '0',
"blocked" BOOLEAN NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL DEFAULT 1,
UNIQUE ("name")
)/ C
indexsqlite_autoindex_accounts_1accounts

��





11��0


��
1


��w
4+












































Account Manager


��n22
�`ddddd

��+

Account Manager
0,
"group_id" INTEGER NOT NULL,
"account_id" INTEGER NOT NULL,
"level" INTEGER NOT NULL DEFAULT 1,
"vocation" INTEGER NOT NULL DEFAULT 0,
"health" INTEGER NOT NULL DEFAULT 100,
"healthmax" INTEGER NOT NULL DEFAULT 100,
"experience" INTEGER NOT NULL DEFAULT 0,
"lookbody" INTEGER NOT NULL DEFAULT 10,
"lookfeet" INTEGER NOT NULL DEFAULT 10,
"lookhead" INTEGER NOT NULL DEFAULT 10,
"looklegs" INTEGER NOT NULL DEFAULT 10,
"looktype" INTEGER NOT NULL DEFAULT 136,
"lookaddons" INTEGER NOT NULL DEFAULT 0,
"maglevel" INTEGER NOT NULL DEFAULT 0,
"mana" INTEGER NOT NULL DEFAULT 100,
"manamax" INTEGER NOT NULL DEFAULT 100,
"manaspent" INTEGER NOT NULL DEFAULT 0,
"soul" INTEGER NOT NULL DEFAULT 0,
"town_id" INTEGER NOT NULL,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"conditions" BLOB NOT NULL,
"cap" INTEGER NOT NULL DEFAULT 0,
"sex" INTEGER NOT NULL DEFAULT 0,
"lastlogin" INTEGER NOT NULL DEFAULT 0,
"lastip" INTEGER NOT NULL DEFAULT 0,
"save" BOOLEAN NOT NULL DEFAULT 1,
"skull" INTEGER NOT NULL DEFAULT 0,
"skulltime" INTEGER NOT NULL DEFAULT 0,
"rank_id" INTEGER NOT NULL,
"guildnick" VARCHAR(255) NOT NULL DEFAULT '',
"lastlogout" INTEGER NOT NULL DEFAULT 0,
"blessings" INTEGER NOT NULL DEFAULT 0,
"balance" INTEGER NOT NULL DEFAULT 0,
"stamina" INTEGER NOT NULL DEFAULT 151200000,
"direction" INTEGER NOT NULL DEFAULT 2,
"loss_experience" INTEGER NOT NULL DEFAULT 100,
"loss_mana" INTEGER NOT NULL DEFAULT 100,
"loss_skills" INTEGER NOT NULL DEFAULT 100,
"loss_containers" INTEGER NOT NULL DEFAULT 100,
"loss_items" INTEGER NOT NULL DEFAULT 100,
"premend" INTEGER NOT NULL DEFAULT 0,
"online" TINYINT NOT NULL DEFAULT 0,
"marriage" INTEGER NOT NULL DEFAULT 0,
"promotion" INTEGER NOT NULL DEFAULT 0,
"deleted" BOOLEAN NOT NULL DEFAULT 0,
"description" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "deleted"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")
)
��
&
U���
&+?
indexsqlite_autoindex_guilds_1guilds�X))
�ktableglobal_storageglobal_storageCREATE TA�

�tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT -A
indexsqlite_autoindex_players_1players�Q++
�Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (
"account_id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL,
UNIQUE ("account_id", "player_id"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)=
Q+
indexsqlite_autoindex_account_viplist_1account_viplist�X))
�ktableglobal_storageglobal_storageCREATE TABLE "global_storage" (
"key" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"value" VARCHAR(255) NOT NULL DEFAULT '0',
UNIQUE ("key", "world_id")
);O)
indexsqlite_autoindex_global_storage_1global_storage






--
�
��)�Y
�
tableguildsguildsCREATE TABLE "guilds" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"ownerid" INTEGER NOT NULL,
"creationdata" INTEGER NOT NULL,
"motd" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "world_id"),
FOREIGN KEY ("ownerid") REFERENCES "players" ("id")
)+?
indexsqlite_autoindex_guilds_1guilds�''
�stableguild_invitesguild_invitesCREATE TABLE "guild_invites" (
"player_id" INTEGER NOT NULL,
"guild_id" INTEGER NOT NULL,
UNIQUE ("player_id", "guild_id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id"),
FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")
)9M'
indexsqlite_autoindex_guild_invites_1guild_invites�o##
�%tableguild_ranksguild_ranksCREATE TABLE "guild_ranks" (
"id" INTEGER PRIMARY KEY,
"guild_id" INTEGER NOT NULL,
"name" VARCHAR(255) NOT NULL,
"level" INTEGER NOT NULL,
FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")
)






/
/���5I#
indexsqlite_autoindex_house_lists_1house_lists �!
�tablehouseshousesCREATE TABLE "houses" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"owner" INTEGER NOT NULL,
"paid" INTEGER NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"lastwarning" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"town" INTEGER NOT NULL DEFAULT 0,
"size" INTEGER NOT NULL DEFAULT 0,
"price" INTEGER NOT NULL DEFAULT 0,
"rent" INTEGER NOT NULL DEFAULT 0,
"doors" INTEGER NOT NULL DEFAULT 0,
"beds" INTEGER NOT NULL DEFAULT 0,
"tiles" INTEGER NOT NULL DEFAULT 0,
"guild" BOOLEAN NOT NULL DEFAULT FALSE,
"clear" BOOLEAN NOT NULL DEFAULT FALSE,
UNIQUE ("id", "world_id")
)+?
indexsqlite_autoindex_houses_1houses



@
@}��&��;SQLite format 3

@ GB

tS�������������������������~yt�[''
�utableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'
indexsqlite_autoindex_server_record_1server_record�C##
�Mtableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#
indexsqlite_autoindex_server_motd_1server_motd�$
''
�tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHARVQUPSOPNNMKLIKGJEICHAG>F7C4B3>17,2(.#) &!


��
!
db_version

��!
db_version


��&


M
Welcome to The Forgotten Server!

��






��





�� 









�
������[�$
''
�tableserver_configserver_configCREATE TABLE "server_config" (
"config" VARCHAR(35) NOT NULL DEFAULT '',
"value" INTEGER NOT NULL,
UNIQUE ("config")
)9M'
indexsqlite_autoindex_server_config_1server_config�C##
�Mtableserver_motdserver_motdCREATE TABLE "server_motd" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"text" TEXT NOT NULL DEFAULT '',
UNIQUE ("id", "world_id")
)5I#
indexsqlite_autoindex_server_motd_1server_motd�[''
�utableserver_recordserver_recordCREATE TABLE "server_record" (
"record" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL,
UNIQUE ("record", "world_id", "timestamp")
)9M'
indexsqlite_autoindex_server_record_1server_record
WW
�����U
�}ta�))
�utableserver_reportsserver_reportsCREATE �))
�utableserver_reportsserver_reportsCREATE TABLE "server_reports" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL DEFAULT 0,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"timestamp" INTEGER NOT NULL DEFAULT 0,
"report" TEXT NOT NULL DEFAULT '',
"reads" INTEGER NOT NULL DEFAULT 0
)�U
�}tableaccountsaccountsCREATE TABLE "accounts" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"password" VARCHAR(255) NOT NULL,
"premdays" INTEGER NOT NULL DEFAULT 0,
"lastday" INTEGER NOT NULL DEFAULT 0,
"email" VARCHAR(255) NOT NULL DEFAULT '',
"key" VARCHAR(20) NOT NULL DEFAULT '0',
"blocked" BOOLEAN NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"group_id" INTEGER NOT NULL DEFAULT 1,
UNIQUE ("name")
)/ C
indexsqlite_autoindex_accounts_1accounts

��





11��0


��
1


��w
4+












































Account Manager


��n22
�`ddddd

��+

Account Manager
0,
"group_id" INTEGER NOT NULL,
"account_id" INTEGER NOT NULL,
"level" INTEGER NOT NULL DEFAULT 1,
"vocation" INTEGER NOT NULL DEFAULT 0,
"health" INTEGER NOT NULL DEFAULT 100,
"healthmax" INTEGER NOT NULL DEFAULT 100,
"experience" INTEGER NOT NULL DEFAULT 0,
"lookbody" INTEGER NOT NULL DEFAULT 10,
"lookfeet" INTEGER NOT NULL DEFAULT 10,
"lookhead" INTEGER NOT NULL DEFAULT 10,
"looklegs" INTEGER NOT NULL DEFAULT 10,
"looktype" INTEGER NOT NULL DEFAULT 136,
"lookaddons" INTEGER NOT NULL DEFAULT 0,
"maglevel" INTEGER NOT NULL DEFAULT 0,
"mana" INTEGER NOT NULL DEFAULT 100,
"manamax" INTEGER NOT NULL DEFAULT 100,
"manaspent" INTEGER NOT NULL DEFAULT 0,
"soul" INTEGER NOT NULL DEFAULT 0,
"town_id" INTEGER NOT NULL,
"posx" INTEGER NOT NULL DEFAULT 0,
"posy" INTEGER NOT NULL DEFAULT 0,
"posz" INTEGER NOT NULL DEFAULT 0,
"conditions" BLOB NOT NULL,
"cap" INTEGER NOT NULL DEFAULT 0,
"sex" INTEGER NOT NULL DEFAULT 0,
"lastlogin" INTEGER NOT NULL DEFAULT 0,
"lastip" INTEGER NOT NULL DEFAULT 0,
"save" BOOLEAN NOT NULL DEFAULT 1,
"skull" INTEGER NOT NULL DEFAULT 0,
"skulltime" INTEGER NOT NULL DEFAULT 0,
"rank_id" INTEGER NOT NULL,
"guildnick" VARCHAR(255) NOT NULL DEFAULT '',
"lastlogout" INTEGER NOT NULL DEFAULT 0,
"blessings" INTEGER NOT NULL DEFAULT 0,
"balance" INTEGER NOT NULL DEFAULT 0,
"stamina" INTEGER NOT NULL DEFAULT 151200000,
"direction" INTEGER NOT NULL DEFAULT 2,
"loss_experience" INTEGER NOT NULL DEFAULT 100,
"loss_mana" INTEGER NOT NULL DEFAULT 100,
"loss_skills" INTEGER NOT NULL DEFAULT 100,
"loss_containers" INTEGER NOT NULL DEFAULT 100,
"loss_items" INTEGER NOT NULL DEFAULT 100,
"premend" INTEGER NOT NULL DEFAULT 0,
"online" TINYINT NOT NULL DEFAULT 0,
"marriage" INTEGER NOT NULL DEFAULT 0,
"promotion" INTEGER NOT NULL DEFAULT 0,
"deleted" BOOLEAN NOT NULL DEFAULT 0,
"description" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "deleted"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id")
)
��
&
U���
&+?
indexsqlite_autoindex_guilds_1guilds�X))
�ktableglobal_storageglobal_storageCREATE TA�

�tableplayersplayers
CREATE TABLE "players" (
"id" INTEGER PRIMARY KEY NOT NULL,
"name" VARCHAR(255) NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT -A
indexsqlite_autoindex_players_1players�Q++
�Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" (
"account_id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"player_id" INTEGER NOT NULL,
UNIQUE ("account_id", "player_id"),
FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id")
)=
Q+
indexsqlite_autoindex_account_viplist_1account_viplist�X))
�ktableglobal_storageglobal_storageCREATE TABLE "global_storage" (
"key" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"value" VARCHAR(255) NOT NULL DEFAULT '0',
UNIQUE ("key", "world_id")
);O)
indexsqlite_autoindex_global_storage_1global_storage






--
�
��)�Y
�
tableguildsguildsCREATE TABLE "guilds" (
"id" INTEGER PRIMARY KEY,
"world_id" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"ownerid" INTEGER NOT NULL,
"creationdata" INTEGER NOT NULL,
"motd" VARCHAR(255) NOT NULL DEFAULT '',
UNIQUE ("name", "world_id"),
FOREIGN KEY ("ownerid") REFERENCES "players" ("id")
)+?
indexsqlite_autoindex_guilds_1guilds�''
�stableguild_invitesguild_invitesCREATE TABLE "guild_invites" (
"player_id" INTEGER NOT NULL,
"guild_id" INTEGER NOT NULL,
UNIQUE ("player_id", "guild_id"),
FOREIGN KEY ("player_id") REFERENCES "players" ("id"),
FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")
)9M'
indexsqlite_autoindex_guild_invites_1guild_invites�o##
�%tableguild_ranksguild_ranksCREATE TABLE "guild_ranks" (
"id" INTEGER PRIMARY KEY,
"guild_id" INTEGER NOT NULL,
"name" VARCHAR(255) NOT NULL,
"level" INTEGER NOT NULL,
FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id")
)






/
/���5I#
indexsqlite_autoindex_house_lists_1house_lists �!
�tablehouseshousesCREATE TABLE "houses" (
"id" INTEGER NOT NULL,
"world_id" INTEGER NOT NULL DEFAULT 0,
"owner" INTEGER NOT NULL,
"paid" INTEGER NOT NULL DEFAULT 0,
"warnings" INTEGER NOT NULL DEFAULT 0,
"lastwarning" INTEGER NOT NULL DEFAULT 0,
"name" VARCHAR(255) NOT NULL,
"town" INTEGER NOT NULL DEFAULT 0,
"size" INTEGER NOT NULL DEFAULT 0,
"price" INTEGER NOT NULL DEFAULT 0,
"rent" INTEGER NOT NULL DEFAULT 0,
"doors" INTEGER NOT NULL DEFAULT 0,
"beds" INTEGER NOT NULL DEFAULT 0,
"tiles" INTEGER NOT NULL DEFAULT 0,
"guild" BOOLEAN NOT NULL DEFAULT FALSE,
"clear" BOOLEAN NOT NULL DEFAULT FALSE,
UNIQUE ("id", "world_id")
)+?
indexsqlite_autoindex_houses_1houses



@
@}��&��;----SUROWE DANE DOT?D----


zapytanie SQL:

SQLite format 3

@ GB

tS�������������������������~yt�[''
�utableserver_recordserver_recordCREATE TABLE "server_record" ( "record" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "timestamp" INTEGER NOT NULL, UNIQUE ("record", "world_id", "timestamp") )9M'
indexsqlite_autoindex_server_record_1server_record�C##
�Mtableserver_motdserver_motdCREATE TABLE "server_motd" ( "id" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "text" TEXT NOT NULL DEFAULT '', UNIQUE ("id", "world_id") )5I#
indexsqlite_autoindex_server_motd_1server_motd�$
''
�tableserver_configserver_configCREATE TABLE "server_config" ( "config" VARCHARVQUPSOPNNMKLIKGJEICHAG>F7C4B3>17,2(.#) &! 
��
!
db_version
��!
db_version

��&


M
Welcome to The Forgotten Server!
��





��




�� 




 


�
������[�$
''
�tableserver_configserver_configCREATE TABLE "server_config" ( "config" VARCHAR(35) NOT NULL DEFAULT '', "value" INTEGER NOT NULL, UNIQUE ("config") )9M'
indexsqlite_autoindex_server_config_1server_config�C##
�Mtableserver_motdserver_motdCREATE TABLE "server_motd" ( "id" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "text" TEXT NOT NULL DEFAULT '', UNIQUE ("id", "world_id") )5I#
indexsqlite_autoindex_server_motd_1server_motd�[''
�utableserver_recordserver_recordCREATE TABLE "server_record" ( "record" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "timestamp" INTEGER NOT NULL, UNIQUE ("record", "world_id", "timestamp") )9M'
indexsqlite_autoindex_server_record_1server_record WW
�����U
�}ta�))
�utableserver_reportsserver_reportsCREATE �))
�utableserver_reportsserver_reportsCREATE TABLE "server_reports" ( "id" INTEGER PRIMARY KEY, "world_id" INTEGER NOT NULL DEFAULT 0, "player_id" INTEGER NOT NULL DEFAULT 0, "posx" INTEGER NOT NULL DEFAULT 0, "posy" INTEGER NOT NULL DEFAULT 0, "posz" INTEGER NOT NULL DEFAULT 0, "timestamp" INTEGER NOT NULL DEFAULT 0, "report" TEXT NOT NULL DEFAULT '', "reads" INTEGER NOT NULL DEFAULT 0 )�U
�}tableaccountsaccounts CREATE TABLE "accounts" ( "id" INTEGER PRIMARY KEY NOT NULL, "name" VARCHAR(255) NOT NULL, "password" VARCHAR(255) NOT NULL, "premdays" INTEGER NOT NULL DEFAULT 0, "lastday" INTEGER NOT NULL DEFAULT 0, "email" VARCHAR(255) NOT NULL DEFAULT '', "key" VARCHAR(20) NOT NULL DEFAULT '0', "blocked" BOOLEAN NOT NULL DEFAULT 0, "warnings" INTEGER NOT NULL DEFAULT 0, "group_id" INTEGER NOT NULL DEFAULT 1, UNIQUE ("name") )/ C
indexsqlite_autoindex_accounts_1accounts
��




11��0

��
1

��w
4+









































Account Manager


��n22
� `ddddd
��+

Account Manager
0, "group_id" INTEGER NOT NULL, "account_id" INTEGER NOT NULL, "level" INTEGER NOT NULL DEFAULT 1, "vocation" INTEGER NOT NULL DEFAULT 0, "health" INTEGER NOT NULL DEFAULT 100, "healthmax" INTEGER NOT NULL DEFAULT 100, "experience" INTEGER NOT NULL DEFAULT 0, "lookbody" INTEGER NOT NULL DEFAULT 10, "lookfeet" INTEGER NOT NULL DEFAULT 10, "lookhead" INTEGER NOT NULL DEFAULT 10, "looklegs" INTEGER NOT NULL DEFAULT 10, "looktype" INTEGER NOT NULL DEFAULT 136, "lookaddons" INTEGER NOT NULL DEFAULT 0, "maglevel" INTEGER NOT NULL DEFAULT 0, "mana" INTEGER NOT NULL DEFAULT 100, "manamax" INTEGER NOT NULL DEFAULT 100, "manaspent" INTEGER NOT NULL DEFAULT 0, "soul" INTEGER NOT NULL DEFAULT 0, "town_id" INTEGER NOT NULL, "posx" INTEGER NOT NULL DEFAULT 0, "posy" INTEGER NOT NULL DEFAULT 0, "posz" INTEGER NOT NULL DEFAULT 0, "conditions" BLOB NOT NULL, "cap" INTEGER NOT NULL DEFAULT 0, "sex" INTEGER NOT NULL DEFAULT 0, "lastlogin" INTEGER NOT NULL DEFAULT 0, "lastip" INTEGER NOT NULL DEFAULT 0, "save" BOOLEAN NOT NULL DEFAULT 1, "skull" INTEGER NOT NULL DEFAULT 0, "skulltime" INTEGER NOT NULL DEFAULT 0, "rank_id" INTEGER NOT NULL, "guildnick" VARCHAR(255) NOT NULL DEFAULT '', "lastlogout" INTEGER NOT NULL DEFAULT 0, "blessings" INTEGER NOT NULL DEFAULT 0, "balance" INTEGER NOT NULL DEFAULT 0, "stamina" INTEGER NOT NULL DEFAULT 151200000, "direction" INTEGER NOT NULL DEFAULT 2, "loss_experience" INTEGER NOT NULL DEFAULT 100, "loss_mana" INTEGER NOT NULL DEFAULT 100, "loss_skills" INTEGER NOT NULL DEFAULT 100, "loss_containers" INTEGER NOT NULL DEFAULT 100, "loss_items" INTEGER NOT NULL DEFAULT 100, "premend" INTEGER NOT NULL DEFAULT 0, "online" TINYINT NOT NULL DEFAULT 0, "marriage" INTEGER NOT NULL DEFAULT 0, "promotion" INTEGER NOT NULL DEFAULT 0, "deleted" BOOLEAN NOT NULL DEFAULT 0, "description" VARCHAR(255) NOT NULL DEFAULT '', UNIQUE ("name", "deleted"), FOREIGN KEY ("account_id") REFERENCES "accounts" ("id") ) ��
&
U���
&+?
indexsqlite_autoindex_guilds_1guilds�X))
�ktableglobal_storageglobal_storageCREATE TA� 
�tableplayersplayers CREATE TABLE "players" ( "id" INTEGER PRIMARY KEY NOT NULL, "name" VARCHAR(255) NOT NULL, "world_id" INTEGER NOT NULL DEFAULT - A
indexsqlite_autoindex_players_1players�Q ++
�Ytableaccount_viplistaccount_viplistCREATE TABLE "account_viplist" ( "account_id" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "player_id" INTEGER NOT NULL, UNIQUE ("account_id", "player_id"), FOREIGN KEY ("account_id") REFERENCES "accounts" ("id"), FOREIGN KEY ("player_id") REFERENCES "players" ("id") )= Q+
indexsqlite_autoindex_account_viplist_1account_viplist�X))
�ktableglobal_storageglobal_storageCREATE TABLE "global_storage" ( "key" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "value" VARCHAR(255) NOT NULL DEFAULT '0', UNIQUE ("key", "world_id") );O)
indexsqlite_autoindex_global_storage_1global_storage       --
�
��)�Y
� tableguildsguildsCREATE TABLE "guilds" ( "id" INTEGER PRIMARY KEY, "world_id" INTEGER NOT NULL DEFAULT 0, "name" VARCHAR(255) NOT NULL, "ownerid" INTEGER NOT NULL, "creationdata" INTEGER NOT NULL, "motd" VARCHAR(255) NOT NULL DEFAULT '', UNIQUE ("name", "world_id"), FOREIGN KEY ("ownerid") REFERENCES "players" ("id") )+?
indexsqlite_autoindex_guilds_1guilds�''
�stableguild_invitesguild_invitesCREATE TABLE "guild_invites" ( "player_id" INTEGER NOT NULL, "guild_id" INTEGER NOT NULL, UNIQUE ("player_id", "guild_id"), FOREIGN KEY ("player_id") REFERENCES "players" ("id"), FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") )9M'
indexsqlite_autoindex_guild_invites_1guild_invites�o##
�%tableguild_ranksguild_ranksCREATE TABLE "guild_ranks" ( "id" INTEGER PRIMARY KEY, "guild_id" INTEGER NOT NULL, "name" VARCHAR(255) NOT NULL, "level" INTEGER NOT NULL, FOREIGN KEY ("guild_id") REFERENCES "guilds" ("id") )      
/
/���5I#
indexsqlite_autoindex_house_lists_1house_lists �!
�tablehouseshousesCREATE TABLE "houses" ( "id" INTEGER NOT NULL, "world_id" INTEGER NOT NULL DEFAULT 0, "owner" INTEGER NOT NULL, "paid" INTEGER NOT NULL DEFAULT 0, "warnings" INTEGER NOT NULL DEFAULT 0, "lastwarning" INTEGER NOT NULL DEFAULT 0, "name" VARCHAR(255) NOT NULL, "town" INTEGER NOT NULL DEFAULT 0, "size" INTEGER NOT NULL DEFAULT 0, "price" INTEGER NOT NULL DEFAULT 0, "rent" INTEGER NOT NULL DEFAULT 0, "doors" INTEGER NOT NULL DEFAULT 0, "beds" INTEGER NOT NULL DEFAULT 0, "tiles" INTEGER NOT NULL DEFAULT 0, "guild" BOOLEAN NOT NULL DEFAULT FALSE, "clear" BOOLEAN NOT NULL DEFAULT FALSE, UNIQUE ("id", "world_id") )+?
indexsqlite_autoindex_houses_1houses   
@
@}��&��;

MySQL zwr?ci? komunikat:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SQLite format 3' at line 1

[ Powr?t ]

Co na to poradzi???

 

[zal2010]

Odp: MegaEvo Edit by Help3R =)

Witam, jestem osob? pocz?tkuj?c? je?eli chodzi o ots i mam ma?y problem,
Gdy chc? importowa? baze danych to wyskakuje mi taki b??d:

Istnieje szansa, ?e w?a?nie znaleziono b??d w analizatorze sk?adni SQL. Prosz? zbada? bli?ej swoje zapytanie i sprawdzi?, czy cudzys?owy s? poprawne i dobrze sparowane. Inn? mo?liw? przyczyn? niepowodzenia mo?e by? wysy?anie pliku ze znakami binarnymi poza obszarem tekstu uj?tego w cudzys?owy. Mo?na r?wnie? sprawdzi? zapytanie SQL poprzez lini? polece? MySQL-a. W znalezieniu przyczyny problemu mo?e pom?c tak?e - je?li si? pojawi - poni?szy opis b??du serwera MySQL. Je?li nadal wyst?puj? z problemy lub analizator sk?adni zg?asza usterk? a linia polece? - nie, ogranicz sekwencj? zapyta? SQL do pojedynczego, kt?re powoduje problemy i zg?o? b??d, do??czaj?c fragment danych zawarty w poni?szej sekcji TNIJ:
----TNIJ ST?D----
eNrtfU9wFMX7d/d2kk0WKkFIskgINSl/+iWVANkE5CeU9RIw8IuEhBAQed/DOuwOyVRmZ/admQCx
CgsS8V+VVepBL170YJXlQQ7qwYsH9WBZpYVcuHjxglIepMoCS63ifXpmNzsz2c1M581GzD6fnX12
O9PP/Onu58lsf7r7GTpxYuzEPulQSjrUL40Mje6TUnuk1ONS/+P9ff/dl5g4CTtJIjHxDOz5r+Hs

Co na to poradzi???