How to Display Recent Thread and Most Reply?

[jauhari]

Can anybody help me, how to display Recent Thread and Most Reply thread with custom query?

I will place this query on the header on my vBulletin forum.

Please Help me

[Jake Bunce]

Most recent thread:

SELECT * FROM thread
ORDER BY dateline
DESC
LIMIT 0, 1

Most replies:

SELECT * FROM thread
ORDER BY replycount
DESC
LIMIT 0, 1

[jauhari]

Most recent thread:

SELECT * FROM thread
ORDER BY dateline
DESC
LIMIT 0, 1

Most replies:

SELECT * FROM thread
ORDER BY replycount
DESC
LIMIT 0, 1

This code only SQL query right? How to integrated into vBulletin, that I mean real example

Regards

Jauhari

[Jake Bunce]

If you have some coding ability then you can post on www.vbulletin.org for help with this.