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

[BlackJacket]

Thanks. About to install! Is there a way to only show admins and mods?

[ry215]

Originally Posted by NittoMOD

Thanks. About to install! Is there a way to only show admins and mods?

yes, but next version

[Blackhat]

finaly something for the sidebar. Good job!

[F0xy]

thanking you! Awesome work as always

whoops, i got this error

Database error in vBulletin 3.7.3:

Invalid SQL:

			SELECT threadid, title, dateline, lastpost, visible, open, postusername, postuserid	  
			FROM thread AS thread
			WHERE NOT ISNULL(threadid) AND forumid IN () AND visible = '1' AND open!='10'
			ORDER BY dateline DESC
			
			LIMIT 0, 5;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND visible = '1' AND open!='10'
			ORDER BY dateline DESC
			
			LIMIT 0, ' at line 3
Error Number  : 1064
Request Date  : Sunday, February 8th 2009 @ 02:06:26 PM
Error Date    : Sunday, February 8th 2009 @ 02:06:26 PM
Script        : http://whatsyourview.net/forum/
Referrer      : 
IP Address    :  
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.67-community

[lasto]

can confirm does not work as it is on 3.8.1

i got exact same error as above

[ry215]

Originally Posted by F0xy

thanking you! Awesome work as always

whoops, i got this error

Originally Posted by lasto

can confirm does not work as it is on 3.8.1

i got exact same error as above

You must enter forumids, where you want show lastest threads

[lasto]

opps lOL

now i must admit i never done that

[lazydesis]

can this be done in similar way to the one in this site on home page?

where they have latest threads from each forum .. instead of latest posts from all forums at one place?

[PakFuse]

it might be a stupid question, but how can I enable side bar in my forum, if it is not using one?

I mean as I understood, this works only when side bar is enabled... right?