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

[dmknights]

As ive said, i have tested this on my 3.8.1 board & it DOESNT WORK!

[ry215]

Originally Posted by dmknights

As ive said, i have tested this on my 3.8.1 board & it DOESNT WORK!

OK, it DOESNT WORK!

[Big-K]

I just tried this on 3.8.1 using Ultimate side columns and nothing shows up.

[jorgejgm]

All time received this message:

Database error in vBulletin 3.8.1:

Invalid SQL:

SELECT count(*)as cnt,max(dateline) as lastupdate
FROM vbulletin_groupmessage
WHERE groupid='1';

MySQL Error : Unknown column 'groupid' in 'where clause'
Error Number : 1054
Request Date : Monday, February 16th 2009 @ 03:59:14 PM
Error Date : Monday, February 16th 2009 @ 03:59:14 PM
Script : http://www.XXXXXXXXX/cron.php?rand=xxxx
Referrer : http://www.XXXXXXXXX/xxxxxx.php?do=xxxx
IP Address : XXXXXXXXX
Username : No Registrado
Classname : vB_Database

[itsheinz]

$template_hook[sidebar_lastest_threads]

i dont get this part..i already have it in my template.
and also this one:

where you want show "Lastest Threads"

can you explain further what to do or additonal editing..coz i already installed the xml and yet the latest threads in side bar is not showing.

[Nimrod.]

Actually, I have this enabled on my board and it works great. I am running 3.8.1

[LanciaStratos]

Thanks very much for this hack! Are the results of the 'latest topics' cached in some way? Otherwise, I imagine this additional additional query on each page load of a busy site could introduce a significant overhead.

[Befragen]

I can't get it to show I'm on 3.8.1

How do I add it?

[keez]

IF it's working on 3.8.1...
is there a way to get this thing grap something like

PHP Code:

forumid IN (".ACTUAL BOARD AND SUBBORD IDs.") 


instead of

PHP Code:

forumid IN (".$vbulletin->options['+++++++_slt_forumid'].") 


I want it to show the latest posts/threads out of the board you're visiting... I think above is the right place for the missing piece of "the auto-generated IDs", but i'm quite new on vB, so that I don't know how to do this yet^^?

[Daryn]

Great mod, I just wish there was an easier way to pick which forums you want to show. I had to look up and enter over 50 forum IDs.

Also, for the next version could you possibly change it so that if you have it set to show LastPost, it will take you to the latest post in that thread instead of taking you to the first?