I'm back again to share some more. Sombody wanted a list of forums that a user can view, based on their usergroup permissions.
I'm doing exactly the same thing at our site, but, i'm outputting formatted links. The request was for a dropdown box... so, here is the gumph for a DD box.
Again, here is the function... you can place this in your 'functions.php' or 'global.php' if you wish :
PHP Code:
function getForumPermissions($usergroupID) {
global $DB_forum;
$forumsCannotView_strList = "";
$forumCatPerm_result = $DB_forum->query("SELECT forumid FROM forumpermission WHERE canview=0 AND usergroupid=$usergroupID");
if (!$num_rows = $DB_forum->num_rows($forumCatPerm_result) <=0) {
$arrayIndex = 0;
while ($row = $DB_forum->fetch_array($forumCatPerm_result, $DB_content->ASSOC)) {
$forumCatPerm_array[$arrayIndex++] = $row[forumid];
}
$forumsCannotView_strList .= implode(",", $forumCatPerm_array) . ",";
if (isset($forumCatPerm_array)) {
$forumsCannotView_result = $DB_forum->query("SELECT forumid,parentlist FROM forum WHERE active=1");
if (!$num_rows = $DB_forum->num_rows($forumsCannotView_result) <=0) {
$arrayIndex = 0;
while ($row = $DB_forum->fetch_array($forumsCannotView_result, $DB_content->ASSOC)) {
$forumParentList_temp = explode(',', $row[parentlist]);
if ($forumParentList_temp[1] != -1) {
if (in_array($forumParentList_temp[1], $forumCatPerm_array)) {
$forumsCannotView_array[$arrayIndex++] = $forumParentList_temp[0];
}
}
}
$forumsCannotView_strList .= implode(",", $forumsCannotView_array);
}
}
}
return $forumsCannotView_strList;
}
In a page where you want to list forums a user can view, call the function to get a string list, and then setup the variable WHERE clause, like this :
PHP Code:
$forumsCannotView_strList = getForumPermissions($bbuserinfo[usergroupid]);
$whereClause_permissions = ($forumsCannotView_strList != "") ? ("(forumid NOT IN ($forumsCannotView_strList)) AND") : ("");
Then, fill a multi-dimensional array with all the details of each viewable forum :
PHP Code:
$mainLinks_result = $DB_forum->query("SELECT forumid,title,description,parentlist FROM forum WHERE $whereClause_permissions active=1 ORDER BY parentid,displayorder ASC");
if (!$num_rows = $DB_forum->num_rows($mainLinks_result) <=0) {
// ####### Main Links Multi Dimensional Array Layout #######
// this commented out code is just the a visible structure of the multi-array that is used in the actual code following. ;-)
/*
$mainLinks_multiArray = array(array( "catID" => ""
,"catTitle" => ""
,"forums_array" => array(array( "forumID" => ""
,"forumTitle" => ""
,"description" => ""))));
*/
// ####### end of Main Links Multi Dimensional Array Layout #######
while ($row = $DB_forum->fetch_array($mainLinks_result, MYSQL_ASSOC)) {
$forumParentList_temp = explode(',', $row[parentlist]);
$thisCatKey = $forumParentList_temp[1];
$thisForumID = $forumParentList_temp[0];
if ($thisCatKey == "-1") {
$mainLinks_multiArray[$thisForumID][catID] = $thisForumID;
$mainLinks_multiArray[$thisForumID][catTitle] = $row[title];
} else {
$mainLinks_multiArray[$thisCatKey][forums_array][$thisForumID][forumID] = $thisForumID;
$mainLinks_multiArray[$thisCatKey][forums_array][$thisForumID][forumTitle] = $row[title];
}
}
$forumLinksStatus = 1;
}
// null the main links, to start from fresh
$mainLinks = "";
... if you wish, you can make that into a function, and also place that into your 'functions.php' or 'global.php'. If so, don't forget to describe the global variables.... especially the 'global $DB_site;'.
Then using all the collected data, you can create a drop down box, with this :
PHP Code:
$mainLinks .= "<select name=\"viewable_forums\">";
foreach ($mainLinks_multiArray as $key => $value) {
$title = $mainLinks_multiArray[$key][catTitle];
$mainLinks .= "<option value=\"null\">$title</option>";
foreach ($mainLinks_multiArray[$key][forums_array] as $key2 => $value2) {
$forumID = $mainLinks_multiArray[$key][forums_array][$key2][forumID];
$title = $mainLinks_multiArray[$key][forums_array][$key2][forumTitle];
$mainLinks .= "<option value=\"$forumID\"> --- $title</option>";
}
}
$mainLinks .= "</select>";
You then have the HTML code for a drop down box, stored inside the variable '$mainLinks', which you can use inside any of your templates.
Do remember that this does not support permissions where Access Masks are used. I reckon the majority of boards don't use Access Masks anyway.
Also, i'm using a multi database connection system on our site, where this thing is used, and I have changed the SQL object to a different name.
Just replace all occurances of '$DB_forum' with '$DB_site', and you'll be ok.
Hope it helps you, and I hope you can get it working.
More Information