Tony |
2nd August 2009 18:12 |
simply rename the forums.php to forums_old.php and copy and paste the tbdev basic forum file into the root and thats it really ..
oh and just open your stdhead.php from within your themes folder and just edit the forum link so it directs to forums.php
if you dont already have the needed tables for the basic tbdev forum (even though its included in v4) then here you go
Code:
CREATE TABLE `forums` (
`sort` tinyint(3) unsigned NOT NULL default '0',
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(60) character set latin1 collate latin1_general_ci NOT NULL default '',
`description` varchar(200) character set latin1 collate latin1_general_ci default NULL,
`minclassread` tinyint(3) unsigned NOT NULL default '0',
`minclasswrite` tinyint(3) unsigned NOT NULL default '0',
`postcount` int(10) unsigned NOT NULL default '0',
`topiccount` int(10) unsigned NOT NULL default '0',
`minclasscreate` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Code:
CREATE TABLE `topics` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`subject` varchar(40) character set latin1 collate latin1_general_ci default NULL,
`locked` enum('yes','no') character set latin1 collate latin1_general_ci NOT NULL default 'no',
`forumid` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`sticky` enum('yes','no') character set latin1 collate latin1_general_ci NOT NULL default 'no',
`views` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `userid` (`userid`),
KEY `subject` (`subject`),
KEY `lastpost` (`lastpost`),
KEY `locked_sticky` (`locked`,`sticky`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
CREATE TABLE `topics` (
`id` int(10) unsigned NOT NULL auto_increment,
`userid` int(10) unsigned NOT NULL default '0',
`subject` varchar(40) character set latin1 collate latin1_general_ci default NULL,
`locked` enum('yes','no') character set latin1 collate latin1_general_ci NOT NULL default 'no',
`forumid` int(10) unsigned NOT NULL default '0',
`lastpost` int(10) unsigned NOT NULL default '0',
`sticky` enum('yes','no') character set latin1 collate latin1_general_ci NOT NULL default 'no',
`views` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `userid` (`userid`),
KEY `subject` (`subject`),
KEY `lastpost` (`lastpost`),
KEY `locked_sticky` (`locked`,`sticky`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
|