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

OTForum 2.0

Norix

Norix

Hosting Service !
Joined
Jan 18, 2008
Messages
544
Reaction score
8
Location
Germany
Since i had time in holidays, i took the Forum Script of Paxton and modified it abit. Now here is the release.

Link: forum.rar

Changes:
  • Made it more Rl Forum Board Style
  • Added Edit Function
  • Added some other small things
  • Shortened script abit
Installation:

Go to index.php in your ACC Folder and find this line
PHP: 
case "forum":
        $topic = "Forum";
        $subtopic = "forum";
        include("forum.php");
    break;

Replace it with:
PHP: 
case "forum":
        $topic = "Forum";
        $subtopic = "forum";
        include("forum/forum.php");
    break;

Then add these lines under it:
PHP: 
    case "board";
        $subtopic = "board";
        $topic = "Forum";
        include("forum/board.php");
    break;
    
    case "thread";
        $subtopic = "thread";
        $topic = "Forum";
        include("forum/thread.php");
    break;
Then go to layouts.php file and search for this:
PHP: 
       <div id='forum_Submenu' class='Submenu'>
          <a href='?subtopic=forum'>
           <div id='submenu_forum' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'>
             <div class='LeftChain' style='background-image:url(".$layout_name."/images/general/chain.gif);'></div>
             <div id='ActiveSubmenuItemIcon_forum' class='ActiveSubmenuItemIcon' style='background-image:url(".$layout_name."/images/menu/icon-activesubmenu.gif);'></div>
             <div class='SubmenuitemLabel'>Server Forum</div>
             <div class='RightChain' style='background-image:url(".$layout_name."/images/general/chain.gif);'></div>
           </div>
          </a>
        </div>

Replace it with this:
PHP: 
        <div id='forum_Submenu' class='Submenu'>
          <a href='?subtopic=forum'>
           <div id='submenu_forum' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'>
             <div class='LeftChain' style='background-image:url(".$layout_name."/images/general/chain.gif);'></div>
             <div id='ActiveSubmenuItemIcon_forum' class='ActiveSubmenuItemIcon' style='background-image:url(".$layout_name."/images/menu/icon-activesubmenu.gif);'></div>
	     <div id='ActiveSubmenuItemIcon_board' class='ActiveSubmenuItemIcon' style='background-image:url(".$layout_name."/images/menu/icon-activesubmenu.gif);'></div>
   	     <div id='ActiveSubmenuItemIcon_thread' class='ActiveSubmenuItemIcon' style='background-image:url(".$layout_name."/images/menu/icon-activesubmenu.gif);'></div>
             <div class='SubmenuitemLabel'>Server Forum</div>
             <div class='RightChain' style='background-image:url(".$layout_name."/images/general/chain.gif);'></div>
           </div>
	     <div id='submenu_board' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'>
	     <div class='LeftChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div>
	  </div>
	    <div id='submenu_thread' class='Submenuitem' onMouseOver='MouseOverSubmenuItem(this)' onMouseOut='MouseOutSubmenuItem(this)'>
  	    <div class='LeftChain' style='background-image:url(<?PHP echo $layout_name; ?>/images/general/chain.gif);'></div>
	  </div>
          </a>
        </div>
Then go to phpmyadmin and execute this:
PHP: 
CREATE TABLE IF NOT EXISTS `posts` (
  `id` int(11) NOT NULL auto_increment,
  `subject` 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,
  `edited` int(5) NOT NULL,
  `edit_date` varchar(45) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=64 ;

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,
  `guild_id` int(5) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;


INSERT INTO `forums` (`id`, `name`, `description`, `closed`, `access`, `guild_id`) VALUES
(1, 'First forum.', 'This is your first forum.', 0, 0, 0);
ToDo:
  • Quote Button
  • Forum Functions (e.g. [.player],[.url]...)
  • Guild Board
  • Admin Panel

Credits goes to Paxton and me.

Please rep ++ !!

Your's Norix
 
Last edited:
2 st VNice :>

Błąd

zapytanie SQL:

INSERT INTO `forums` ( `id` , `name` , `description` , `closed` , `access` , `guild_id` )
VALUES ( 2, 'First forum.', 'This is your first forum.', 0, 0, 0 )

MySQL zwrócił komunikat:
#1054 - Unknown column 'guild_id' in 'field list'
Click to expand...

How to fix? :eek:
 
Last edited by a moderator:
Fix error in post.
PHP: 
    case "thread";
        $subtopic = "thread";
        $topic = "Forum";
        include("forum/thread.php");
    break;
my error:
PHP: 
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'otserv.forums' doesn't exist' in C:\xampp\htdocs\web\forum\forum.php:39 Stack trace: #0 C:\xampp\htdocs\web\forum\forum.php(39): PDO->query('SELECT * FROM `...') #1 C:\xampp\htdocs\web\index.php(160): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\web\forum\forum.php on line 39

The table exists in the database.


Nice Work. =p
 
Last edited:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'subject' in 'field list'' in C:\xampp\htdocs\forum\board.php:119 Stack trace: #0 C:\xampp\htdocs\forum\board.php(119): PDO->query('INSERT INTO `po...') #1 C:\xampp\htdocs\index.php(281): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\forum\board.php on line 119
Click to expand...

When open thead

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'subject' in 'field list'' in C:\xampp\htdocs\forum\thread.php:63 Stack trace: #0 C:\xampp\htdocs\forum\thread.php(63): PDO->query('INSERT INTO `po...') #1 C:\xampp\htdocs\index.php(287): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\forum\thread.php on line 63
Click to expand...

When post reply

Buged version :s
 
Ehh Norix.

It should be completly rewritten, because OTForum actually suck :S

When I will get some time I will rewrite it.
 
Code: 
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'subject' in 'field list'' in C:\xampp\htdocs\forum\board.php:119 Stack trace: #0 C:\xampp\htdocs\forum\board.php(119): PDO->query('INSERT INTO `po...') #1 C:\xampp\htdocs\index.php(197): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\forum\board.php on line 119

Same errors as the other guys I guess and good work on the look of forum, it looks alot better
 
May i see any preview?
__________________
klekSu.png

You are welcome on kleksoria.com!
Please visit new open tibia forum with it's own ots list. otservers.net!
 
Last edited:
No shit :eek: i love it :eek: probably going to use :eek:
__________________
klekSu.png

You are welcome on kleksoria.com!
Please visit new open tibia forum with it's own ots list. otservers.net!
 
Last edited:
It would be possible to add these BBCode?

PHP: 
[URL="http://www.otland.net"]Otland[/URL]
[IMG]http://otland.net/images/galaxy/header/logo.gif[/IMG]
YouTube Movie? [url=http://www.youtube.com/watch?v=rfr40TDfmM0]YouTube - Benny Benassi - Who's Your Daddy[/url]
 
These things are already on my ToDO List. I hope i will get it to work soon...
 

Similar threads

Hokku
  • Question
Featured article problem with db
Replies
2
Views
306
Hokku
Hokku
J
  • Question
PHP castle war widget
Replies
3
Views
519
jel
J
V
  • Question
AAC reset system geisor
Replies
0
Views
290
vitorelias1
V
blokerzinha
  • Question
Problem with the wrong player appearing as top even though he is not. Znote
Replies
1
Views
335
blokerzinha
blokerzinha
Back
Top