[Info] SMF Component & Multiple Forum

Based on this forum :

Code:

http://www.simplemachines.org/community/index.php?topic=64492.0

Run multiple forums from :
1 database, 1 directory, 1 installation.

At first, I thought that the tricks will only work with Orstio's SMF component. However, I have been falling in love with Wolverine's SMF component and tried the tricks to his SMF component. The result is SUCCESS !!!
I can run Multiple forums only with 1 installation of SMF in 1 directory and only need 1 database.

For Information, I use :
* Joomla 1.0.10
* SMF 1.1 RC2
* Wolverine's JSMF Component v. 1.1.4.2 (The latest)

Here are the steps :
1. Run this in phpMyAdmin
Code:

Code:

CREATE TABLE IF NOT EXISTS `smf_forums` (
`forumName` text NOT NULL,
`catList` varchar(128) NOT NULL default ''
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

2. Browse the tables you create and add your fields like the example below. forumName is the name you'll be passing in, catList are the category id's you want to display for that forum.

forumName catList
computer 1,2,3,4,5
electronics 1,2,6,7,8
entertainment 1,2,9,10,11
and so on... (unlimited forum)

3. Go to your smf forum directory and search in Sources directory

In Load.php

Find:
Code:

Code:

$user_info['query_see_board'] = '(FIND_IN_SET(' . implode(', b.memberGroups) OR FIND_IN_SET(', $user_info['groups']) . ', b.memberGroups))';

Add After:
Code:

Code:

// Added for the multiple forum mod
if(!empty($_REQUEST['forum']) && !isset($_REQUEST['action']) && !isset($_REQUEST['board']) &&!isset($_REQUEST['topic'])){
$forumList = db_query("SELECT catList FROM {$db_prefix}forums WHERE forumName = '$_REQUEST[forum]'", __FILE__, __LINE__);
$row_forumList = mysql_fetch_assoc($forumList);
$user_info['query_see_board'] .= ' AND FIND_IN_SET(c.ID_CAT, "' . $row_forumList['catList'] . '")';
}

4. In BoardIndex.php (in Sources dir)

Find:
Code:

Code:

AND b.childLevel <= 1" : ''), __FILE__, __LINE__);

Replace with:

Code:

AND b.childLevel <= 1" : '') . " ORDER BY c.catOrder, b.boardOrder ASC" , __FILE__, __LINE__);

5. The following fix thanks to Kingconnor

Open "your_smf_forum_dir/Sources/BoardIndex.php" and find the following code

Code:

$result_boards = db_query (around line 71)

Add above that the following code (might look familiar)

Code:

// Added for the multiple forum mod
if(!empty($_REQUEST['forum']) && !isset($_REQUEST['board']) &&!isset($_REQUEST['topic'])){
$forumList = db_query("SELECT catList FROM {$db_prefix}forums WHERE forumName = '$_REQUEST[forum]'", __FILE__, __LINE__);
$row_forumList = mysql_fetch_assoc($forumList);
$user_info['query_see_board'] .= ' AND FIND_IN_SET(c.ID_CAT, "' . $row_forumList['catList'] . '")';
}