• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Windows Gesior AAC crashing apache?

R

Rhydin

New Member
Joined
Jul 21, 2008
Messages
56
Reaction score
2
So yeah, whenever I am trying to install Gesior AAC, my apache crashes for no reason whatsoever, anyone know how to fix this? :/
 
Sort by date Sort by votes
Cykotitan said:
Try using an older version of Xampp (perhaps 1.6.6a?)
Click to expand...

tried with 1.6.6 now and it gives me this error message:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'redskulltime' in 'field list'' in C:\xampp\htdocs\aac\install.php:528 Stack trace: #0 C:\xampp\htdocs\aac\install.php(528): PDO->query('INSERT INTO pla...') #1 {main} thrown in C:\xampp\htdocs\aac\install.php on line 528
 
Upvote 0 Downvote
cykotitan said:
what's the version of your server (tfs distribution)?
Click to expand...

0.3.5.2576

now it's giving me this instead...


Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1' in C:\xampp\htdocs\aac\install.php:528 Stack trace: #0 C:\xampp\htdocs\aac\install.php(528): PDO->query('INSERT INTO pla...') #1 {main} thrown in C:\xampp\htdocs\aac\install.php on line 528

seems to be problems adding the sample characters? :/
 
Last edited:
Upvote 0 Downvote
Rhydin said:
0.3.5.2576

now it's giving me this instead...


Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[21S01]: Insert value list does not match column list: 1136 Column count doesn't match value count at row 1' in C:\xampp\htdocs\aac\install.php:528 Stack trace: #0 C:\xampp\htdocs\aac\install.php(528): PDO->query('INSERT INTO pla...') #1 {main} thrown in C:\xampp\htdocs\aac\install.php on line 528

seems to be problems adding the sample characters? :/
Click to expand...
Just as I thought. The database structure used by your version of Gesior AAC isn't compatible with your server's db structure.

You should use this one: http://otland.net/f118/gesior-aac-0-3-5-fixed-v6-44018/
 
Upvote 0 Downvote
Cykotitan said:
Just as I thought. The database structure used by your version of Gesior AAC isn't compatible with your server's db structure.

You should use this one: http://otland.net/f118/gesior-aac-0-3-5-fixed-v6-44018/
Click to expand...


That's the Gesior AAC I am using.

edit: hmm, seems as if it's working fine now just that I don't get all the options I see on other peoples' screens, can't edit the samples, vocations and so on :/
 
Upvote 0 Downvote
Upload the right version database and make sure its the schema.mysql and that you've set the right database settings in ur config file.

If you get any more errors type em here.
 
Upvote 0 Downvote
Linna said:
Upload the right version database and make sure its the schema.mysql and that you've set the right database settings in ur config file.

If you get any more errors type em here.
Click to expand...

Where do I get the right version of the database then? I am using the database I got with the server under the schema folder.

"mysql.sql"
 
Upvote 0 Downvote
It obviously has something to do with column changes in several tables, like players (skulltime instead of redskulltime and new columns).
Post your aac\install.php ? Too lazy to download.
 
Upvote 0 Downvote
Cykotitan said:
It obviously has something to do with column changes in several tables, like players (skulltime instead of redskulltime and new columns).
Post your aac\install.php ? Too lazy to download.
Click to expand...

Code: 
<?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>Installation of account maker</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>Frames don\'t work. Install Firefox :P</body></noframes>
</frameset>
</html>';
}
if($_REQUEST['page'] == 'menu') {
echo '<h2>MENU</h2><br>
<b>IF NOT INSTALLED:</b><br>
<a href="install.php?page=step&step=start" target="step">0. Informations</a><br>
<a href="install.php?page=step&step=1" target="step">1. Set server path</a><br>
<a href="install.php?page=step&step=2" target="step">2. Check DataBase connection</a><br>
<a href="install.php?page=step&step=3&server_conf=yes" target="step">3. Add tables and columns to DB</a><br>
<a href="install.php?page=step&step=4&server_conf=yes" target="step">4. Add samples to DB</a><br>
<a href="install.php?page=step&step=5&server_conf=yes" target="step">5. Set Admin Account</a><br>
<b>FOR ADMINS:</b><br>
<a href="index.php?subtopic=adminpanel&action=install_monsters" target="step">6. Load Monsters from OTS</a><br>
<a href="index.php?subtopic=adminpanel&action=install_spells" target="step">7. Load Spells from OTS</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 'Database error - can\'t connect to MySQL database. Possible reasons:<br>1. MySQL server is not running on host.<br>2. MySQL user, password, database or host isn\'t configured in: <b>'.$config['site']['server_path'].'config.lua</b> .<br>3. MySQL user, password, database or host is wrong.';
		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 'Database error - can\'t open SQLite database. Possible reasons:<br><b>'.$link_to_sqlitedatabase.'</b> - file isn\'t valid SQLite database.<br><b>'.$link_to_sqlitedatabase.'</b> - doesn\'t exist.';
		exit;
	}
}
else
{
	echo 'Database error. Unknown database type in <b>'.$config['site']['server_path'].'config.lua</b> . Must be equal to: "<b>mysql</b>" or "<b>sqlite</b>". Now is: "<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>STEP '.$step.'</h1>Informations<br>';
echo 'Welcome to Gesior Account Maker installer. <b>First do steps 1-5 one by one, later (when you will be logged on admin account) press on links to steps 6-11 to load configuration from OTS.</b>';
}
if($step == '1') {
if(isset($_REQUEST['server_path'])) {
	echo '<h1>STEP '.$step.'</h1>Check server configuration<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 'File <b>config.lua</b> loaded from <font color="red"><i>'.$config['site']['server_path'].'config.lua</i></font> and looks like fine server config file. Now you can check database('.$config['server']['sqlType'].') connection: <a href="install.php?page=step&step=2">STEP 2 - check database connection</a>';
		}
		else
		{
			echo 'File <b>config.lua</b> loaded from <font color="red"><i>'.$config['site']['server_path'].'config.lua</i></font> and it\'s not valid TFS config.lua file. <a href="install.php?page=step&step=1">Go to STEP 1 - select other directory.</a> If it\'s your config.lua file from TFS contact with acc. maker author.';
		}
	}
	else
	{
		echo 'Can\'t load file <b>config.lua</b> from <font color="red"><i>'.$config['site']['server_path'].'config.lua</i></font> File doesn\'t exist in selected directory. <a href="install.php?page=step&step=1">Go to STEP 1 - select other directory.</a>';
	}
}
else
{
echo 'Please write you TFS directory below. Like: <i>C:\Documents and Settings\Gesior\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="Set server path" />
</form>';
}
}
if($step == '2') {
echo '<h1>STEP '.$step.'</h1>Check database connection<br>';
echo 'If you don\'t see any errors press <a href="install.php?page=step&step=3&server_conf=yes">link to STEP 3 - Add tables and columns to DB</a>. If you see some errors it mean server has wrong configuration. Check FAQ or ask author of acc. maker.';
//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 'Database error - can\'t connect to MySQL database. Possible reasons:<br>1. MySQL server is not running on host.<br>2. MySQL user, password, database or host isn\'t configured in: <b>'.$config['site']['server_path'].'config.lua</b> .<br>3. MySQL user, password, database or host is wrong.';
		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 'Database error - can\'t open SQLite database. Possible reasons:<br><b>'.$link_to_sqlitedatabase.'</b> - file isn\'t valid SQLite database.<br><b>'.$link_to_sqlitedatabase.'</b> - doesn\'t exist.';
		exit;
	}
}
else
{
	echo 'Database error. Unknown database type in <b>'.$config['site']['server_path'].'config.lua</b> . Must be equal to: "<b>mysql</b>" or "<b>sqlite</b>". Now is: "<b>'.strtolower($config['server']['sqlType']).'"</b>';
	exit;
}
$SQL = POT::getInstance()->getDBHandle();
$config['site']['install'] = 3;
saveconfig_ini($config['site']);
}
if($step == '3') {
echo '<h1>STEP '.$step.'</h1>Add tables and columns to DB<br>';
echo 'Installer try to add new tables and columns to database.<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) {}
			echo "Added columns to table <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 "Added table <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 "Added table <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 "Added table <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 "Added table <b>z_monsters</b> (monsters list).<br/>";
		}
		elseif($config['server']['sqlType'] == "mysql")
		{
			//if mysql
			echo "<h3>Add columns to table <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>Add new tables to database</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 `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/>";}
		}
		$config['site']['install'] = 4;
		saveconfig_ini($config['site']);
	echo 'Tables and columns added to database.<br>Go to <a href="install.php?page=step&step=4&server_conf=yes">STEP 4 - Add samples</a>';
}
if($step == '4') {
echo '<h1>STEP '.$step.'</h1>Add samples to DB:<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, "Hello! Gesior account manager 0.32beta2 installed. Report bugs to [email protected]", 0)');
echo "Added first news ticker.<br/>";
} else {
echo "News ticker sample is already in database. New sample is not needed.<br/>";
}
$check_news = $SQL->query('SELECT * FROM z_news_big WHERE author = "Gesior" 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 "Added first news.<br/>";
} else {
echo "News sample is already in database. New sample is not needed.<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, redskulltime, redskull, 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 "Added 'Rook Sample' character.<br/>";
} else {
echo "Character 'Rook Sample' already in database.<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, redskulltime, redskull, 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 "Added 'Sorcerer Sample' character.<br/>";
} else {
echo "Character 'Sorcerer Sample' already in database.<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, redskulltime, redskull, 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 "Added 'Druid Sample' character.<br/>";
} else {
echo "Character 'Druid Sample' already in database.<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, redskulltime, redskull, 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 "Added 'Paladin Sample' character.<br/>";
} else {
echo "Character 'Paladin Sample' already in database.<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, redskulltime, redskull, 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 "Added 'Knight Sample' character.<br/>";
} else {
echo "Character 'Knight Sample' already in database.<br/>";
$config['site']['install'] = 5;
saveconfig_ini($config['site']);
echo 'All samples added to database. Now you can go to <a href="install.php?page=step&step=5&server_conf=yes">STEP 5 - Set Admin Account</a><br/>';
}
}
if($step == '5') {
echo '<h1>STEP '.$step.'</h1>Set Admin Account<br>';
$config['server'] = parse_ini_file($config['site']['server_path'].'config.lua');
if(empty($_REQUEST['saveaccpassword'])) {
	echo 'Admin account number is: <b>1</b><br/>Set new password to this account.<br>';
	echo 'New password: <form action="install.php" method=POST><input type="text" name="newpass" size="35">(Don\'t give it password to anyone!)';
	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>If account with number 1 doesn\'t exist installator will create it and set your password.';
	} else {
	$newpass = $_POST['newpass'];
	if(!check_password($newpass))
		echo 'Password contains illegal characters. Please use only a-Z and 0-9. <a href="install.php?page=step&step=5&server_conf=yes">GO BACK</a> and write other password.';
	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>Admin account number: 1<br>Admin account password: '.$_POST['newpass'].'</h1><br/><h3>It\'s end of first part of installation. Installation is blocked. From now don\'t modify file config.ini!<br>Press links to STEPs 6-9 in menu.</h3>'; 
		$config['site']['install'] = 'no';
		saveconfig_ini($config['site']);
	}
	}
}
}
else
{
echo "Account maker is already installed! To reinstall open file 'config.ini' in directory 'config' and change:<br/><b>install = \"no\"</b><br/>to:</br><b>install = \"start\"</b><br/>and enter this site again.";
}
}
?>
 
Upvote 0 Downvote
You need to modify the queries in this file which start with "INSERT INTO players ... " to match your databases's column count and order.

Comparison:
(install.php)
PHP: 
$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)');
(from mysql sample file)
PHP: 
CREATE TABLE `players`
(
	`id` INT NOT NULL AUTO_INCREMENT,
	`name` VARCHAR(255) NOT NULL,
	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
	`group_id` INT NOT NULL DEFAULT 1,
	`account_id` INT NOT NULL DEFAULT 0,
	`level` INT NOT NULL DEFAULT 1,
	`vocation` INT NOT NULL DEFAULT 0,
	`health` INT NOT NULL DEFAULT 150,
	`healthmax` INT NOT NULL DEFAULT 150,
	`experience` BIGINT NOT NULL DEFAULT 0,
	`lookbody` INT NOT NULL DEFAULT 0,
	`lookfeet` INT NOT NULL DEFAULT 0,
	`lookhead` INT NOT NULL DEFAULT 0,
	`looklegs` INT NOT NULL DEFAULT 0,
	`looktype` INT NOT NULL DEFAULT 136,
	`lookaddons` INT NOT NULL DEFAULT 0,
	`maglevel` INT NOT NULL DEFAULT 0,
	`mana` INT NOT NULL DEFAULT 0,
	`manamax` INT NOT NULL DEFAULT 0,
	`manaspent` INT NOT NULL DEFAULT 0,
	`soul` INT UNSIGNED NOT NULL DEFAULT 0,
	`town_id` INT NOT NULL DEFAULT 0,
	`posx` INT NOT NULL DEFAULT 0,
	`posy` INT NOT NULL DEFAULT 0,
	`posz` INT NOT NULL DEFAULT 0,
	`conditions` BLOB NOT NULL,
	`cap` INT NOT NULL DEFAULT 0,
	`sex` INT NOT NULL DEFAULT 0,
	`lastlogin` BIGINT UNSIGNED NOT NULL DEFAULT 0,
	`lastip` INT UNSIGNED NOT NULL DEFAULT 0,
	`save` TINYINT(1) NOT NULL DEFAULT 1,
	`skull` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
	`skulltime` INT NOT NULL DEFAULT 0,
	`rank_id` INT NOT NULL DEFAULT 0,
	`guildnick` VARCHAR(255) NOT NULL DEFAULT '',
	`lastlogout` BIGINT UNSIGNED NOT NULL DEFAULT 0,
	`blessings` TINYINT(2) NOT NULL DEFAULT 0,
	`balance` BIGINT NOT NULL DEFAULT 0,
	`stamina` BIGINT NOT NULL DEFAULT 151200000 COMMENT 'stored in miliseconds',
	`direction` INT NOT NULL DEFAULT 2,
	`loss_experience` INT NOT NULL DEFAULT 100,
	`loss_mana` INT NOT NULL DEFAULT 100,
	`loss_skills` INT NOT NULL DEFAULT 100,
	`loss_containers` INT NOT NULL DEFAULT 100,
	`loss_items` INT NOT NULL DEFAULT 100,
	`premend` INT NOT NULL DEFAULT 0 COMMENT 'NOT IN USE BY THE SERVER',
	`online` TINYINT(1) NOT NULL DEFAULT 0,
	`marriage` INT UNSIGNED NOT NULL DEFAULT 0,
	`promotion` INT NOT NULL DEFAULT 0,
	`deleted` TINYINT(1) NOT NULL DEFAULT FALSE,
	`description` VARCHAR(255) NOT NULL DEFAULT '',
	PRIMARY KEY (`id`), UNIQUE (`name`, `deleted`),
	KEY (`account_id`), KEY (`group_id`),
	KEY (`online`), KEY (`deleted`),
	FOREIGN KEY (`account_id`) REFERENCES `accounts`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

INSERT INTO `players` VALUES (1, 'Account Manager', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '');

Keep in mind that Gesior AAC has added some additional columns to that table so you'll need them in the query too.
 
Upvote 0 Downvote
This is just freaking me out.. now I finally get it working properly without any errors or anything and I can't find step 8-11 on the menu. :S

lolcatsd.jpg
 
Upvote 0 Downvote
It's a typo, there are none. At least not in the newest version of Gesior AAC. In older versions the last step (8th) would be "Load Vocations" or something.
 
Upvote 0 Downvote

Similar threads

L
  • Question
AAC gesior aac 2012 empty page
Replies
1
Views
288
Adorius Black
Adorius Black
E
  • Question
Myaac - Gesior Shop Plugin gifts.php error 500
Replies
6
Views
195
elitehox
E
Adorius Black
  • Question
AAC Xampp Linux
Replies
7
Views
375
Adorius Black
Adorius Black
K
  • Question
AAC No access to Gesior ACC 1.5
Replies
0
Views
246
kibo433
K
alelu541
  • Question
AAC AAC not connecting with my SQL
Replies
1
Views
339
slaw
slaw
H
  • Question
TFS 1.2 item related crash
Replies
4
Views
385
henkas
H
Tbol
  • Solved
Xampp got aids and it ruined phpmyadmin
Replies
8
Views
344
Codinablack
Codinablack
B
  • Question
Gesior acc - cache - edit file/dir access for PHP problem.
Replies
1
Views
172
Adorius Black
Adorius Black
falkyon
  • Question
AAC MyAAC v0.8.16 - cannot access admin page after installing gesior plugin
Replies
9
Views
506
falkyon
falkyon
rashid07
  • Question
Error installing Gesior (2019) + TFS 0.4 on Ubuntu22
Replies
2
Views
402
diegoknight95
D
Back
Top