Code for "Recent Topics"

[doraj]

Hello,

I create some blocks/columns on the right of my forum.
I would add in a block, recent 5 topics of forum...What code must I insert for show it?

Thanks ;-)

[Dismounted]

[sql]SELECT threadid, title, lastposter
FROM " . TABLE_PREFIX . "thread
WHERE visible = 1
ORDER BY dateline DESC
LIMIT 5[/sql]

[doraj]

Hello,

I try that code but I receive an error 1064 in ACP vBulletin, Execute SQL Query

[Lynne]

You can't put it in just like that. You need to write it using the vbulletin way. ie. $vbulletin->db>query_read etc.

Perhaps let us see the php code you have currently written for this.

[Opserty]

<a href="http://www.vbulletin.com/forum/showthread.php?t=158887" target="_blank">http://www.vbulletin.com/forum/showthread.php?t=158887</a>

Might work on 3.6.x

[Dismounted]

Originally Posted by doraj

Hello,

I try that code but I receive an error 1064 in ACP vBulletin, Execute SQL Query

You need to have the table prefix in there.