How to setup Multi-Forums? :: Archived

alyssa · Diamond Supporter Offline Joined: Nov 15, 2004 Posts: 773

run0 wrote:

I disagree. It would then have to be updated every time the forum files are changed, and all you have to do is change two words in one file.

Out of idle curiousity and to be the devils advocate here - would not the update button in the Module Admin update those same files? So then would it not be merely the click of a button to update them? If so, it would be great to have them zipped up into a separate module.

My point being - it's way easy as well to do a replace all for the entire directory to change anything called Forums2 to whatever they choose to call their secondary forums. This is not the case for replacing all cases of Forums in the directory. You change every case of the word forums in that mod and the thing won't work.

But anything called Forums2 changed to something ought to work fine and seems like it would be way easy to do for those that aren't so programming friendly.

In other words, I'm thinking of beginners having an easy way to get DF to do what they want without having to change code line by line, or at least being able to have a program do it quickly and easily for them.

Just some thoughts.

alyssa · Diamond Supporter Offline Joined: Nov 15, 2004 Posts: 773

OKay here's something odd.

I had double forums before - with quite a bit of data.

I successfully was able to install the second forum. All the data in the database seems to be showing in the database itself. However the Forums2 is showing on the user side as having no boards. Cleared server and browser caches, same thing.

Plus on the Admin panel side, the second Forums seems to have overwritten the original Forums Admin link.

So ah any idea what I did wrong?

alyssa · Diamond Supporter Offline Joined: Nov 15, 2004 Posts: 773

OKay, fixed the admin panel, now both are showing.

But its so weird that the data is there and the site isn't pulling from it.

I've deleted all caches and temp internet files and sever cache and nada. *whine* Naughty forums!

winock · Posted: Wed Aug 03, 2005 5:58 pm Post subject: Re: How to setup Multi-Forums?

[quote="DJMaze"]Also the admin section has to be modified.

Copy "admin/modules/forums.php" to "<modulename>.php" where <modulename> is case-sensitive

i dont find these data (forum.php in my dragonfly 9.0.5.0

ilamos · Nice poster Offline Joined: Dec 27, 2004 Posts: 82

I fallowed all the instructions and everything works fine except when i try to post it has this error.

includes/db/db.php

CMS Warning line 51: On /Forums2/posting.html While executing query "INSERT INTO cms_bb2posts (topic_id, forum_id, poster_id, post_username, post_time, poster_ip, enable_bbcode, enable_html, enable_smilies, enable_sig) VALUES (4, 1, 2, '', 1123124787, '411b48a7', 1, 0, 1, 0)" the following error occured: Unknown column 'enable_bbcode' in 'field list' In: /home/ilamos/public_html/includes/phpBB/functions_post.php on line: 150

ilamos · Nice poster Offline Joined: Dec 27, 2004 Posts: 82

any help?

run0 · Supporter Offline Joined: Jun 28, 2004 Posts: 1559

not sure if this will solve your problem but you should upgrade to the latest dragonfly (9.0.5) and make sure you go to admin->modules->Forums2, click edit, then upgrade to whatever version it says. you seem to be missing tables or something

ilamos · Nice poster Offline Joined: Dec 27, 2004 Posts: 82

I did upgrade and it did not solve anything. thnx for the reply tho. Will someone please help me with this problem?

xfsunoles · Posted: Thu Aug 04, 2005 6:21 pm Post subject: Re: How to setup Multi-Forums?

enable_bbcode is missing field in cms_bb2posts

ilamos · Nice poster Offline Joined: Dec 27, 2004 Posts: 82

That field is there.

ilamos · Nice poster Offline Joined: Dec 27, 2004 Posts: 82

I deleted all the tables and did them again so everything works fine now.

ilamos · Nice poster Offline Joined: Dec 27, 2004 Posts: 82

I am working on a forum scroll block for Forums2 so I changed all the table names so they are _bb2 instead of _bb. The block displays the topics but when I click on a topic it says this topic does not exist so what else needs to be changed??

Code::

<?php

/*********************************************
  CPG-NUKE: Advanced Content Management System
  ********************************************
  A highly modified version of PHP-Nuke 6.5
  which is Copyright (c) 2002 by Francisco Burzi
  http://phpnuke.org

  Under the GNU General Public License version 2

*********************************************/

if (!defined('CPG_NUKE')) {
    die("You can't access this file directly...");
}

global $cookie, $db, $group_id, $prefix, $sitename, $user, $user_prefix;

$ThemeSel = get_theme();

$iconpath = '';

if (file_exists("themes/$ThemeSel/forums/images/icon_mini_message.gif")) {
    $iconpath = "themes/$ThemeSel/forums/images";
} else {
    $iconpath = "modules/Forums/templates/subSilver/images";
}

$content = '<marquee behavior="scroll" align="center" direction="up" height="220" scrollamount="2" scrolldelay="70" onmouseover=\'this.stop()\' onmouseout=\'this.start()\'>'
          .'<center><font color="#666666" style="text-decoration: none"><strong>Last 5 Forum Messages</strong></font></center><br />';

$result = $db->sql_query("SELECT
 t.topic_id, t.topic_last_post_id, t.topic_title,
 f.forum_name, f.forum_id,
 u.username, u.user_id,
 p.poster_id, FROM_UNIXTIME(p.post_time,'%b %d, %Y at %T') as post_time
 FROM ".$prefix."_bb2topics t, ".$prefix."_bb2forums f
 LEFT JOIN ".$prefix."_bb2posts p ON (p.post_id = t.topic_last_post_id)
 LEFT JOIN ".$user_prefix."_users u ON (u.user_id = p.poster_id)
 WHERE t.forum_id=f.forum_id AND f.auth_view=0
 ORDER BY t.topic_last_post_id DESC
 LIMIT 05");

while (list($topic_id, $topic_last_post_id, $topic_title, $forum_name, $forum_id, $username, $user_id, $poster_id, $post_time) = $db->sql_fetchrow($result)) {
    $content .= "<img src=\"$iconpath/icon_mini_message.gif\" border=\"0\" alt=\"\" />\n"
               ."<a href=\"".getlink("Forums&amp;file=viewtopic&amp;p=$topic_last_post_id#$topic_last_post_id")."\" style=\"text-decoration: none\">\n"
               ."<strong> $topic_title </strong></a>\n"
               ."<br />\n"
               ."<font color=\"#666666\">\n"
               ."<i>Last post by <a href=\"".getlink("Your_Account&amp;op=userinfo&amp;username=$username")."\" style=\"text-decoration: none\">$username</a>\n"
               ."in <a href=\"".getlink("Forums&amp;file=viewforum&amp;f=$forum_id")."\">$forum_name</a>\n"
               ."on $post_time</i>\n"
               ."</font>\n"
               ."<br /><br />\n";
}

$content .= "</marquee>";

?>

run0 · Supporter Offline Joined: Jun 28, 2004 Posts: 1559

Try this:

Code::

<?php

/*********************************************
  CPG-NUKE: Advanced Content Management System
  ********************************************
  A highly modified version of PHP-Nuke 6.5
  which is Copyright (c) 2002 by Francisco Burzi
  http://phpnuke.org

  Under the GNU General Public License version 2

*********************************************/

if (!defined('CPG_NUKE')) {
    die("You can't access this file directly...");
}

global $cookie, $db, $group_id, $prefix, $sitename, $user, $user_prefix;

$ThemeSel = get_theme();

$iconpath = '';

if (file_exists("themes/$ThemeSel/forums/images/icon_mini_message.gif")) {
    $iconpath = "themes/$ThemeSel/forums/images";
} else {
    $iconpath = "modules/Forums/templates/subSilver/images";
}

$content = '<marquee behavior="scroll" align="center" direction="up" height="220" scrollamount="2" scrolldelay="70" onmouseover=\'this.stop()\' onmouseout=\'this.start()\'>'
          .'<center><font color="#666666" style="text-decoration: none"><strong>Last 5 Forum Messages</strong></font></center><br />';

$result = $db->sql_query("SELECT
 t.topic_id, t.topic_last_post_id, t.topic_title,
 f.forum_name, f.forum_id,
 u.username, u.user_id,
 p.poster_id, FROM_UNIXTIME(p.post_time,'%b %d, %Y at %T') as post_time
 FROM ".$prefix."_forums2_topics t, ".$prefix."_forums2_forums f
 LEFT JOIN ".$prefix."_forums2_posts p ON (p.post_id = t.topic_last_post_id)
 LEFT JOIN ".$user_prefix."_users u ON (u.user_id = p.poster_id)
 WHERE t.forum_id=f.forum_id AND f.auth_view=0
 ORDER BY t.topic_last_post_id DESC
 LIMIT 05");

while (list($topic_id, $topic_last_post_id, $topic_title, $forum_name, $forum_id, $username, $user_id, $poster_id, $post_time) = $db->sql_fetchrow($result)) {
    $content .= "<img src=\"$iconpath/icon_mini_message.gif\" border=\"0\" alt=\"\" />\n"
               ."<a href=\"".getlink("Forums2&amp;file=viewtopic&amp;p=$topic_last_post_id#$topic_last_post_id")."\" style=\"text-decoration: none\">\n"
               ."<strong> $topic_title </strong></a>\n"
               ."<br />\n"
               ."<font color=\"#666666\">\n"
               ."<i>Last post by <a href=\"".getlink("Your_Account&amp;op=userinfo&amp;username=$username")."\" style=\"text-decoration: none\">$username</a>\n"
               ."in <a href=\"".getlink("Forums&amp;file=viewforum&amp;f=$forum_id")."\">$forum_name</a>\n"
               ."on $post_time</i>\n"
               ."</font>\n"
               ."<br /><br />\n";
}

$content .= "</marquee>";

?>

ilamos · Nice poster Offline Joined: Dec 27, 2004 Posts: 82

that just gave me a bunch of errors. like forums2topics_topics doesn't exist. isn't it suppose to be bb2topics_topics?

run0 · Supporter Offline Joined: Jun 28, 2004 Posts: 1559

depends how you setup the second forums. did you do it exactly like this?

Nikolaich wrote:

I take away the words back.
It was convinced, that the separate module is not necessary.
It is necessary to take simply in public_html/modules folder Forums to rename her(it) in Forums2
Then:
1. To copy her(it) in a directory your site/modules.
2. To open in a notebook: your site/modules/Forums2/cpg_inst.php
3. A line 18

Code::

class Forums {

To replace on

Code::

class Forums2 {

4. A line 27

Code::

function Forums () {

To replace on

Code::

function Forums2 () {

5. To keep a file cpg_inst.php
To proceed(pass) in the administrator menus/modules and in the appeared line: Forums2 CPG Bulletin Board by CPG-Nuke Dev Team and based on phpBB 2.0.x which is released under the GNU GPLInstallTo pressInstall.
6. After end of process of installation to press Edit and to rename Forums2 in what you want.
6. To make active a new forum.
And all science...