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

[Gesior AAC] 0.3.4 (beta4) fixed v5

bugs


Modified characters.php file with equipment shower,... (by me)


charcters have 0 hp

Warning: Division by zero in C:\xampp\htdocs\characters.php on line 177

Bug takes a stand as form has 1 lvl and man 0
 
If you wanna have news system take my layout.php and my latestnews.php then the tickers should work...
 
e 1' in C:\xampp\htdocs\latestnews.php:7 Stack trace: #0 C:\xampp\htdocs\latestnews.php(7): PDO->query('SELECT * FROM `...') #1 C:\xampp\htdocs\index.php(70): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\latestnews.php on line 7



not not not mmm please add
News-Ticker System
TO UNNAMED acc. maker 0.3.2 beta for TFS
 
Hello
I going to test but one question it show statistic about more server under monster logo?? like (002/34) or not?
 
import this on ur database

for change log use,
Code: 
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 ;

for poll system use,

Code: 
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 ;

:)
 
ops

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 ;

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;

ALTER TABLE `accounts` ADD `vote` INT( 11 ) NOT NULL ;
Click to expand...
 
when pressing at "shop offer" i got error.

Code: 
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'tibia2.z_shop_offer' doesn't exist' in C:\xampp\xampp\htdocs\shopsystem.php:90 Stack trace: #0 C:\xampp\xampp\htdocs\shopsystem.php(90): PDO->query('SELECT * FROM `...') #1 C:\xampp\xampp\htdocs\shopsystem.php(174): getOfferArray() #2 C:\xampp\xampp\htdocs\index.php(202): include('C:\xampp\xampp\...') #3 {main} thrown in C:\xampp\xampp\htdocs\shopsystem.php on line 90
and when i press at trans. history i got this error

Code: 
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'tibia2.z_shop_history_item' doesn't exist' in C:\xampp\xampp\htdocs\shopsystem.php:739 Stack trace: #0 C:\xampp\xampp\htdocs\shopsystem.php(739): PDO->query('SELECT * FROM `...') #1 C:\xampp\xampp\htdocs\index.php(202): include('C:\xampp\xampp\...') #2 {main} thrown in C:\xampp\xampp\htdocs\shopsystem.php on line 739

can someone help me
 
Insert this in DB:
PHP: 
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;

PHP: 
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,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

PHP: 
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;

PHP: 
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;
 
STEP 5
Set Admin Account

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'field list'' in C:\Program Files (x86)\VertrigoServ\www\pot\OTS_Account.php:229 Stack trace: #0 C:\Program Files (x86)\VertrigoServ\www\pot\OTS_Account.php(229): PDO->query('SELECT `id`, `n...') #1 C:\Program Files (x86)\VertrigoServ\www\install.php(468): OTS_Account->load(1) #2 {main} thrown in C:\Program Files (x86)\VertrigoServ\www\pot\OTS_Account.php on line 229
 
tavlon said:
STEP 5
Set Admin Account

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'field list'' in C:\Program Files (x86)\VertrigoServ\www\pot\OTS_Account.php:229 Stack trace: #0 C:\Program Files (x86)\VertrigoServ\www\pot\OTS_Account.php(229): PDO->query('SELECT `id`, `n...') #1 C:\Program Files (x86)\VertrigoServ\www\install.php(468): OTS_Account->load(1) #2 {main} thrown in C:\Program Files (x86)\VertrigoServ\www\pot\OTS_Account.php on line 229
Click to expand...


Help
 
sorry for dubble post but cant edit the first post.

every time i am trying to make a char in this version it gives me error
i am using 0.3.4 pl2
Code: 
Player with this name already exist.

so maby got an idea?
 

Similar threads

F
  • Question
Unable to load items.otb
Replies
3
Views
277
Mateus Robeerto
Mateus Robeerto
tibera
  • Question
Lua after SS, server offline in otservlist
Replies
2
Views
372
Jeyci
J
S
  • Question
TFS exe not launching
Replies
7
Views
317
Codinablack
Codinablack
E
  • Solved
TFS 0.X 8.60 0.4 MOD MYSQL THERE IS HOW TO DO IT SQLITE
Replies
13
Views
441
Enderlop
E
Michcol94
  • Question
TFS 1.X+ TTFS 1.5 by Nekiro problem pvp
Replies
2
Views
394
Michcol94
Michcol94
Codinablack
Black Tek Server Pre-Release
Replies
18
Views
1K
johnsamir
johnsamir
S
  • Question
Error during engine compilation
Replies
9
Views
507
shioon
S
Back
Top