Query to get a list of all public/available forums

[Erpenator]

Hi all,

For a website we try to integrate some parts of the vBulletin forum into the CMS. Like shared login and add links to forum on news items.

We came across a problem with authorisation / forum access. We would like to produce a full list of all public/ available forums, but we are not able to filter the forums which you are not authorized to see based on forum userid. In our CMS we need to implement a list of all forums where you have acess so it can be added to a news item.

In the file includes\function_forumlist.php are several functions which show all sorts of list of forums but are very hard to implement in our main code.

Could someone explain how to filter available forums from the database on which you have access to bassed on the userid of the forum?

Just to make sure everybody understand what I mean: I am looking for a PHP sollution or SQL query which gives me a list of all public/available forums, exactly as a regular forum browser would see, without any additional rights

[Erpenator]

Is there anyone who can help me with this problem?

[harmor19]

I wrote what you want a while ago.

$count = 0;
$getposts = $db->query_read("
SELECT DISTINCT thread.title AS title, thread.threadid AS threadid, forum.forumid AS forumid
FROM " . TABLE_PREFIX . "post AS post
LEFT JOIN " . TABLE_PREFIX . "thread AS thread
ON post.threadid = thread.threadid
LEFT JOIN " . TABLE_PREFIX . "forum AS forum
ON thread.forumid = forum.forumid
ORDER BY postid DESC");
while($post = $db->fetch_array($getposts))
{

$forumperms = fetch_permissions($post['forumid']);
if (($forumperms & $vbulletin->bf_ugp_forumpermissions['canview']) OR ($forumperms & $vbulletin->bf_ugp_forumpermissions['canviewthreads']))
{
if($count <= 5)
{
$latestthreads2 .= "<b>Title</b>: <a href='showthread.php?t=$post[threadid]'>".$post['title']."</a><br />";

}

$count++;

}
}