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