Query to view topics created by user?

[zorab]

Hi, can anyone help me with this please (hope its ok to link from VB.com!)

http://www.vbulletin.com/forum/showthread.php?p=851132#post851132

Cheers

[tnguy3n]

You can use this following query:

SELECT * FROM " . TABLE_PREFIX . "thread
WHERE dateline > (TIMENOW - 30*86400)

[Marco van Herwaarden]

Keep in mind that this query will only give new Threads, not Posts.