Accessing vBulletin's thread table directly

[EEssam]

Hi,

I'm coding a script that is accessing vBulletin's thread table directly... I'm wondering what my MySQL WHERE Clause should include to exclude any post that is deleted/on pending list/or any other thing that I may be not aware of? e.g. not publicly displayed.

For now, my SQL statement looks like this:

SELECT * FROM thread WHERE visible = 1 AND forumid NOT IN(excluded forum ids)

Anything missing?

Your help Would be greatly appreciated.
Reply With Quote