subscribe thread sql?

[sifuhall]

Hi guys, just checked out the new forum, two thumbs up!


What is the sql (or even just the requirements) for a subscribed thread?

For example, I'm trying to display all the subscribed threads for a given user, but it appears I'm missing something.

I tried select thread.title
from thread, subscribethread
where userid=$userid
and subscribethread.threadid = thread.threadid
and thread.visible=1
and thread.open = 1

but what it returned was a lot different from the subscribed thread display in the user cp.

:confused:

[Admin]

Take a look at usercp.php, this part:
// ############################### start new subscribed to threads ###############################