The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
I need help making this plugin,..
I'd like to be able to display the (postdate/time, username, thread title, and post content) for the latest 5/10 threads from a specific forum/s?
Is there anyway to make a plug-in so I could put a variable where it's needed. Similiar to this here (which only displays 10 latest post - showing only the thread title and username): Code:
$numposts='10'; $thrdqry = $vbulletin->db->query_read(" SELECT forumid,threadid, title, dateline, lastpost, visible, open, lastposter FROM " . TABLE_PREFIX . "thread WHERE forumid IN (1, 2, 3) AND visible = '1' ORDER BY lastpost DESC LIMIT 0, $numposts "); while ($thrds = mysql_fetch_array($thrdqry)) { $ttid = $thrds[threadid]; $pstqry = $vbulletin->db->query_read(" SELECT postid FROM " . TABLE_PREFIX . "post WHERE threadid= $ttid ORDER BY postid DESC"); $psts = mysql_fetch_array($pstqry); $pstid = $psts[postid]; $homepage_recentpost .=<<<EOD $thrds[title] $thrds[lastposter] EOD; } $db->free_result($thrds); $db->free_result($psts); the I just post $homepage_recentpost into a template and vB does the rest, some help would be greatly appreciated,.. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|