Miscellaneous Hacks - Sidebar Lastest Threads

First thanks to F0xy for a great idea!

Description:
If your forum using sidebar, you want to give Lastest Threads out this sidebar, this Mod will do it.

Info:
Plugins: 3
Phrases: 16
Templates: 2
Settings: 5

Install:

1. Import Product via Manage Products
ACP >> Plugins & Products >> Manage Products >> [Add/Import Product]

2. Edit Template:
Add in your sidebar template:

$template_hook[sidebar_lastest_threads]

where you want show "Lastest Threads"

3. Settings:
ACP >> vBulletin Options >> Sidebar Lastest Threads Settings

History:
v3.8.001 : First Release
v3.8.002 : nothing special, just add default forumids

PS: Work fine with 3.7.x (Tested)

Similar MOD:
Sidebar Column
Sidebar Poll

[napy8gen]

how to trim the long title text?

[obetyance]

Can we have a separate block per Board/Forum ID?

Ex:

Lastest Threads on FORUM ID 1, 2 & 3 (GEN COMMUNITY)

Lastest Threads on FORUM ID 5, 6 & 7 ( FOR SALE SECTION)

Lastest Threads on FORUM ID 8 & 9 (TECH SUPPORT)

Thanks!

[edward hamilton]

After having trouble with this mod I uninstalled it and used this code to get a list of recent posts. Nothing fancy but it works by making a plugin. If you don't know how to do it there are other threads about that.
I used cache_templates as the Hook Location. You can call it anything you want to.

PHP Code:

$numposts='5';


    $thrdqry = $vbulletin->db->query_read("
        SELECT forumid,threadid, title, dateline, lastpost, visible, open, lastposter      
        FROM " . TABLE_PREFIX . "thread
                WHERE forumid NOT IN (100,200,300)  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];
            

$lastposted .=<<<EOD
<tr><td class="smallfont">

<b><a href="showthread.php?p=$pstid#post$pstid">$thrds[title] </a></b></td><tr>
<tr><td>$thrds[lastposter]<hr> </td></tr>
EOD;
            
    }
        $db->free_result($thrds);
                $db->free_result($psts); 


I put $lastposted in my Ultimate Side Column block after adding a heading called Recent Posts.

I hope this helps someone.

[Silmarillion]

How to delete/change the "Latest Threads" text?

[MagicThemeParks]

Originally Posted by Silmarillion

How to delete/change the "Latest Threads" text?

Did a quick search and this may be your answer. https://vborg.vbsupport.ru/showpost....4&postcount=35

[Silmarillion]

What do i have to change to show the last poster in every thread?

Original-Code:

<tr>
    <td class="$class">
        <div class="smallfont"><a href="showthread.php?$session[sessionurl]t=$+++++++_slt[threadid]"><strong>$+++++++_slt[title]</strong></a></div>
<div class="smallfont">- von <a href="member.php?$session[sessionurl]u=$+++++++_slt[postuserid]">$+++++++_slt[postusername]</a></div>
    </td>
</tr>

[Silmarillion]

No one?

[angeljs]

Hi, is there any way to show attachments with this, instead of the title?

[Sukubis]

That works perfect, thank you =)

[WebCraker]

thnx alot man for this mod ..
Attached the mod translated into arabic
الموضوع والمنتج مترجم بتصرف باللغة العربية هنا