query list of a user's subscribed forums

[jsboyd]

The subject line pretty much sums it up. Once a user logs in I'd like to query the database for a list of that user's subscribed forums. I'm trying to add some FTP functionality based on forum names.

thanks,
john

Cc: johnsboyd@mindspring.com (if you'd be so kind)

[Steve Machol]

Please follow the instructions in the last line of my sig to show you are a licensed customer. Thanks!

[jsboyd]

Hmmm... How can I be more clear..?

The vBulletin Administrator has the authority to allow certain users access (membership) to specific forums. So, is there a mySQL query that can return a list of the forum names that the logged in "user" can access (or is a member of)?
The query needs to run as any user who happens to login.


>Darren,
>
>I'm not quite sure what it is you're asking. If >you're looking for a MySQL query, then the best >place would be to post in the MySQL forum on >http://www.vbulletin.com/forum/
>
>Be sure to be more explicit about the query you >want. For instance, I'm not clear what you mean >by "a user's member forum names ".
>
>All the best,
>Steve Machol
>Support Team, vBulletin

[jsboyd]

Here's a clue:

A similar query call is made in the admin control panel under:

Users
Find
List All Users
Edit Access Masks (in user options)


The radio buttons are set to Yes/No/Default depending on whether the user is a member of a particular forum. This is most likely doing the query to the database that I need. Anybody know what/where that query is?


thx