Dragonfly CMS v9 ⇒ CPG-BB (forum) :: Archives ⇒ How to setup Multi-Forums? :: Archived ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum Index Modules & Blocks CPG-BB (forum) ⇒ Archives

Archived ⇒ How to setup Multi-Forums?


yep I have it just like that but here is the error


Table 'ilamos_cpg7.cms_forums2_topics' doesn't exist In: /home/ilamos/public_html/blocks/block-Forums_scroll_Last_posts.php on line: 43

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
RedHat 9 i686/Apache 1.3.33 (Unix)/MySQL 4.0.24-standard/Dragonfly 9.0.3.0


do you have all these tables?

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/1.3.33 (Unix)/4.0.22-standard/4.3.9/DF 9.x


no here it is just like djmaze said.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
RedHat 9 i686/Apache 1.3.33 (Unix)/MySQL 4.0.24-standard/Dragonfly 9.0.3.0


I modified two forums overview blocks and they work fine so if anyone wants it here is one of them.

<?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 10 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 10"); 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("Forums2&amp;file=viewforum&amp;f=$forum_id")."\">$forum_name</a>\n" ."on $post_time</i>\n" ."</font>\n" ."<br /><br />\n"; } $content .= "</marquee>"; ?>

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
RedHat 9 i686/Apache 1.3.33 (Unix)/MySQL 4.0.24-standard/Dragonfly 9.0.3.0


*sigh* Is there nothing I can look at or check to get the second forums to read the data that exists?

I keep combing over it and it looks perfectly fine to me.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
[ Linux / Apache 2.2.8 / MySQL 5.0.45 / PHP 5.2.6 / CPG 8.2b - 9.3.4.1]


ilamos the way you have posted above is the old way, no longer in use, those tables need to be renamed to match the format run0 posted above.

NEMINI.org, NEMINI.us, NEMINI.info, NYMINI.org

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
1.3.34 (Unix)/4.1.18-standard/4.4.2 /9.1.0.8 CVS


yea follow the post that I quoted earlier

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/1.3.33 (Unix)/4.0.22-standard/4.3.9/DF 9.x


alyssa wrote
*sigh* Is there nothing I can look at or check to get the second forums to read the data that exists?

I keep combing over it and it looks perfectly fine to me.


which screenshot do your tables look like, mine or the one ilamos posted?

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/1.3.33 (Unix)/4.0.22-standard/4.3.9/DF 9.x


Oooh was that for my benefit? Geez I can be such a dunce. lol

Ummm it looks like ilamos, and matches the first forum which works perfectly with all the original data.

Should it be forums2 instead?

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
[ Linux / Apache 2.2.8 / MySQL 5.0.45 / PHP 5.2.6 / CPG 8.2b - 9.3.4.1]


I have a question, I set up a second set of forums
using the latest cpgdragonfly (I just copied the
folders and made the changes to Class forums()
and function forums(). The method worked like a dream!
Now my follow up question is how do I either set up
search to return results from both forums OR get a
second search to work with the second forum?

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
(Test Server Specs) CMS Version 9.0.6.1 / PHP Version 5.0.5 / MySQL Version 4.1.14-nt apache 2.0.54-win32-x86-no_ssl


When I go to my Forum2 and click search it searches the topics in Forum2. Is this the Search you are asking about?

XJBikes.com

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Linux/Apache=1.3.41/MySQL=5.0.87-community/PHP=5.2.6/DFCMS=9.2.1


SnoSheriff wrote
When I go to my Forum2 and click
search it searches the topics in Forum2. Is this the
Search you are asking about?



Embarassed I meant the one in the main menu. lol I just
realized I can add a link to it though through the
admin panel. (Can you tell I'm very new to
CPGDragonfly) Thank you for the reply though. Cool

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
(Test Server Specs) CMS Version 9.0.6.1 / PHP Version 5.0.5 / MySQL Version 4.1.14-nt apache 2.0.54-win32-x86-no_ssl


Is there a fairly simple way to combine the search to search both forums?

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
(Test Server Specs) CMS Version 9.0.6.1 / PHP Version 5.0.5 / MySQL Version 4.1.14-nt apache 2.0.54-win32-x86-no_ssl


i have making a separate mod for a multi forums is there anywhere a change to made after i have upgrade to 9.0.6.0 and after that to 9.0.6.1?

i have notice a few differences with the code in common.php...
in example:

in the normal forum:

define('AUTH_ACCESS_TABLE', $this_prefix.'auth_access');
define('CATEGORIES_TABLE', $this_prefix.'categories');
define('FORUMS_TABLE', $this_prefix.'forums');
define('POSTS_TABLE', $this_prefix.'posts');
define('POSTS_TEXT_TABLE', $this_prefix.'posts_text');
define('PRUNE_TABLE', $this_prefix.'forum_prune');
define('SEARCH_WORD_TABLE', $this_prefix.'search_wordlist');
define('SEARCH_MATCH_TABLE', $this_prefix.'search_wordmatch');
define('TOPICS_TABLE', $this_prefix.'topics');
define('TOPICS_WATCH_TABLE', $this_prefix.'topics_watch');
define('VOTE_DESC_TABLE', $this_prefix.'vote_desc');
define('VOTE_RESULTS_TABLE', $this_prefix.'vote_results');
define('VOTE_USERS_TABLE', $this_prefix.'vote_voters');
define('ATTACHMENTS_DESC_TABLE', $this_prefix.'attachments_desc');
define('ATTACHMENTS_TABLE', $this_prefix.'attachments');
define('TOPIC_ICONS_TABLE', $this_prefix.'topic_icons');

in my second forum

define('AUTH_ACCESS_TABLE', $prefix.'_bb2auth_access');
define('CATEGORIES_TABLE', $prefix.'_bb2categories');
define('FORUMS_TABLE', $prefix.'_bb2forums');
define('POSTS_TABLE', $prefix.'_bb2posts');
define('POSTS_TEXT_TABLE', $prefix.'_bb2posts_text');
define('PRUNE_TABLE', $prefix.'_bb2forum_prune');
define('SEARCH_WORD_TABLE', $prefix.'_bb2search_wordlist');
define('SEARCH_MATCH_TABLE', $prefix.'_bb2search_wordmatch');
define('TOPICS_TABLE', $prefix.'_bb2topics');
define('TOPICS_WATCH_TABLE', $prefix.'_bb2topics_watch');
define('VOTE_DESC_TABLE', $prefix.'_bb2vote_desc');
define('VOTE_RESULTS_TABLE', $prefix.'_bb2vote_results');
define('VOTE_USERS_TABLE', $prefix.'_bb2vote_voters');
define('ATTACHMENTS_DESC_TABLE', $prefix . '_bb2attachments_desc');
define('ATTACHMENTS_TABLE', $prefix . '_bb2attachments');
define('TOPIC_ICONS_TABLE', $prefix . '_bb2topic_icons');


the difference $this_prefix and $prefix, only in the lines who i have the adjust for the second forum..

please help

Never be afraid to try something new. Remember, amateurs built the ark; professionals built the Titanic.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
xp apache2triad 123


in my second forum i found a line with code in folowing files:

In Common.php

on line 25: $this_prefix = $prefix.'_'.(($this_base == 'Forums') ? 'bb' : strtolower($this_base).'_');

line 102: if (!Cache::array_load('attach_config', 'Forums', true)) {
$result = $db->sql_query('SELE

line 108: Cache::array_save('attach_config', 'Forums', $attach_config);

IN cpg_inst.php

line 35: $this->prefix = ($this->base == 'Forums') ? 'bb' : strtolower($this->base).'_';

line 43: if ($this->base == 'Forums') {

line 165: if ($this->base == 'Forums') {

line 398: if ($this->base == 'Forums') {

line 434: $installer->add_query('INSERT', $this->prefix.'attachments_config', "'upload_dir','uploads/forums'");


do i have to change in this code Forums into Forums2?
please need help on this

Never be afraid to try something new. Remember, amateurs built the ark; professionals built the Titanic.

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
xp apache2triad 123

All times are UTC