• 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!

UNNAMED acc. maker 0.3.2 beta for TFS

Status
Not open for further replies.
Zikerus... i know..

but see this
2s8ivq8.jpg
 
@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)
 
one more problem

Hello I know maybe its simple but...
xxz.png

What is it the shit? To this day worked but not yet.:confused:
 
Last edited:
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
 
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
It was in acc. maker for TFS 0.2 :>
PHP:
ALTER TABLE `players` ADD `comment` TEXT NOT NULL;
Rest of queries from install.php:
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) {}
Step 3 of installation should execute this code.
In pot/OTS_Player.php:
PHP:
    public function getComment()
    {
        if( !isset($this->data['comment']) )
        {
            throw new E_OTS_NotLoaded();
        }

        return $this->data['comment'];
    }
(zainstalowales wszystko od zera po zmianie na 0.3?)
 
@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)

no, now i ahve only 1.6.6 installed, ill try to install 1.6.6a upgrade but i think it wont work, please, help !


[link to problem again:]
a593f4db981934cb.jpg
 
It was in acc. maker for TFS 0.2 :>
PHP:
ALTER TABLE `players` ADD `comment` TEXT NOT NULL;
Rest of queries from install.php:
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) {}
Step 3 of installation should execute this code.
In pot/OTS_Player.php:
PHP:
    public function getComment()
    {
        if( !isset($this->data['comment']) )
        {
            throw new E_OTS_NotLoaded();
        }

        return $this->data['comment'];
    }
(zainstalowales wszystko od zera po zmianie na 0.3?)

Yes i installed again the acc maker 0.3 ;p
 
ajaj, it did it! and 0 effect's. Zukerus meybe you know! I have problem Houses in my ots cleaning one of xtime. and i dont know what i must do!
 
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.

And please fix tickers
 
I agree that the tickers should be brought back.!!

Also maybe make a archive news system.. like tibia's.. where more than a curtain days old or amount on main website goes there..


Also in the highscores how do you get ride of the sample's??
 
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.
 
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.

Ye gesior, you doing very well job here in otland , like i said many times you rox ! and your web... fix adminpanel shiet (so i can like config it on install.php also like they said tickers!


Thanks,Ates!
 
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.

i got my dedicated too and.... well... i cant connect to mySQL (i used 1.6.6a XAMPP because it is the one supported i think so) on Gesior xD but im working on it xD
 
Status
Not open for further replies.
Back
Top