If I want go to Step 4, I havning little problem...
Please help me
Fatal error: Uncaught exception 'E_OTS_NotLoaded' in C:\xampp\htdocs\tiscal\pot\OTS_Player.php:416 Stack trace: #0 C:\xampp\htdocs\tiscal\characters.php(74): OTS_Player->getComment() #1 C:\xampp\htdocs\tiscal\index.php(94): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\tiscal\pot\OTS_Player.php on line 416
It was in acc. maker for TFS 0.2 :>PHP:Fatal error: Uncaught exception 'E_OTS_NotLoaded' in C:\xampp\htdocs\tiscal\pot\OTS_Player.php:416 Stack trace: #0 C:\xampp\htdocs\tiscal\characters.php(74): OTS_Player->getComment() #1 C:\xampp\htdocs\tiscal\index.php(94): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\tiscal\pot\OTS_Player.php on line 416
i use befor TFS 0.2 and now im using TFS 0.3 and i get this error when i use Search Character, anyone know how to update database to from 0.2 to 0.3 i mean acc maker database
ALTER TABLE `players` ADD `comment` TEXT NOT NULL;
try { $SQL->query("ALTER TABLE `accounts` ADD `key` VARCHAR( 20 ) NOT NULL DEFAULT '0';"); } catch(PDOException $error) {}
try { $SQL->query("ALTER TABLE `accounts` ADD `page_lastday` INT( 11 ) NOT NULL;"); } catch(PDOException $error) {}
try { $SQL->query("ALTER TABLE `accounts` ADD `email_new` VARCHAR( 255 ) NOT NULL;"); } catch(PDOException $error) {}
try { $SQL->query("ALTER TABLE `accounts` ADD `email_new_time` INT( 15 ) NOT NULL;"); } catch(PDOException $error) {}
try { $SQL->query("ALTER TABLE `accounts` ADD `created` INT( 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` INT( 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` INT( 11 ) NOT NULL DEFAULT '0';"); } catch(PDOException $error) {}
try { $SQL->query("ALTER TABLE `accounts` ADD `premium_points` INT( 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` INT( 11 ) NOT NULL DEFAULT '0';"); } catch(PDOException $error) {}
try { $SQL->query("ALTER TABLE `players` ADD `created` INT( 11 ) NOT NULL DEFAULT '0';"); } catch(PDOException $error) {}
try { $SQL->query("ALTER TABLE `players` ADD `nick_verify` INT( 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` INT( 11 ) NOT NULL DEFAULT '0';"); } catch(PDOException $error) {}
try { $SQL->query("ALTER TABLE `players` ADD `comment` TEXT NOT NULL;"); } catch(PDOException $error) {}
echo "Added columns to table <b>players</b><br/>";
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;"); } catch(PDOException $error) {}
echo "Added table <b>z_news_big</b> (news).<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 "Added table <b>z_news_tickers</b> (tickers).<br/>"; } catch(PDOException $error) {}
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` 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;'); } catch(PDOException $error) {}
public function getComment()
{
if( !isset($this->data['comment']) )
{
throw new E_OTS_NotLoaded();
}
return $this->data['comment'];
}
@2x up
I have no idea :| Put your config.ini here
@up
If you have both 1.7.0 and 1.6.6a at same time on your PC, it will use 1.7.0 PHP and MYSQL Services (and I guess it is issued by newest mysql)
It was in acc. maker for TFS 0.2 :>
Rest of queries from install.php:PHP:ALTER TABLE `players` ADD `comment` TEXT NOT NULL;
Step 3 of installation should execute this code.PHP:try { $SQL->query("ALTER TABLE `accounts` ADD `key` VARCHAR( 20 ) NOT NULL DEFAULT '0';"); } catch(PDOException $error) {} try { $SQL->query("ALTER TABLE `accounts` ADD `page_lastday` INT( 11 ) NOT NULL;"); } catch(PDOException $error) {} try { $SQL->query("ALTER TABLE `accounts` ADD `email_new` VARCHAR( 255 ) NOT NULL;"); } catch(PDOException $error) {} try { $SQL->query("ALTER TABLE `accounts` ADD `email_new_time` INT( 15 ) NOT NULL;"); } catch(PDOException $error) {} try { $SQL->query("ALTER TABLE `accounts` ADD `created` INT( 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` INT( 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` INT( 11 ) NOT NULL DEFAULT '0';"); } catch(PDOException $error) {} try { $SQL->query("ALTER TABLE `accounts` ADD `premium_points` INT( 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` INT( 11 ) NOT NULL DEFAULT '0';"); } catch(PDOException $error) {} try { $SQL->query("ALTER TABLE `players` ADD `created` INT( 11 ) NOT NULL DEFAULT '0';"); } catch(PDOException $error) {} try { $SQL->query("ALTER TABLE `players` ADD `nick_verify` INT( 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` INT( 11 ) NOT NULL DEFAULT '0';"); } catch(PDOException $error) {} try { $SQL->query("ALTER TABLE `players` ADD `comment` TEXT NOT NULL;"); } catch(PDOException $error) {} echo "Added columns to table <b>players</b><br/>"; 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;"); } catch(PDOException $error) {} echo "Added table <b>z_news_big</b> (news).<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 "Added table <b>z_news_tickers</b> (tickers).<br/>"; } catch(PDOException $error) {} 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` 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;'); } catch(PDOException $error) {}
In pot/OTS_Player.php:
(zainstalowales wszystko od zera po zmianie na 0.3?)PHP:public function getComment() { if( !isset($this->data['comment']) ) { throw new E_OTS_NotLoaded(); } return $this->data['comment']; }
install = "no"
server_path = "C:/server/"
@Zikerus
btw. I had a older version acc maker and work good
Maybe tommorow I'll post version with multi-world system, not 100%, but enought to make servers with multi-world:
- Account Management - show world on characters from account list
- Create character - select world (if more then 1 world in config) [other character samples for each world]
- Search player - show world in player description and on characters from account list
- Highscores - user select world (if more then 1 world in config)
- Houses - user select world (if more then 1 world in config)
---------------------------------
Spells and monsters list loaded from only one server.
Maybe tommorow I'll post version with multi-world system, not 100%, but enought to make servers with multi-world:
- Account Management - show world on characters from account list
- Create character - select world (if more then 1 world in config) [other character samples for each world]
- Search player - show world in player description and on characters from account list
- Highscores - user select world (if more then 1 world in config)
- Houses - user select world (if more then 1 world in config)
---------------------------------
Spells and monsters list loaded from only one server.
just got my dedicated server. apache keeps crashing when I try to add samples to db. if I skip install and use my old installation, apacha crashes when I enter aac in browser... whats wrong? I dled latest xampp i think.