Sidebar Lastest Threads

[ry215]

First thanks to F0xy (https://vborg.vbsupport.ru/member.php?u=245012) 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 (https://vborg.vbsupport.ru/showthread.php?t=204773)
Sidebar Poll (https://vborg.vbsupport.ru/showthread.php?t=204586)

[BlackJacket]

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

[ry215]

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

yes, but next version :D

[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]

thanking you! Awesome work as always

whoops, i got this error


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 :D

[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?

[F0xy]

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?

there is no way to enable sidebar, it must be coded into your skin or use the sidebar mod available from here.

[Forum Lover]

Tagged. wish there is lastest poll too. :) I mean all in one. :)

[dmknights]

there is no way to enable sidebar, it must be coded into your skin or use the sidebar mod available from here.

Where do i find it?

[dmknights]

does not work for 3.8.1

[lasto]

u done one for new threads m8 can u also do one for new posts plz ?

[PakFuse]

there is no way to enable sidebar, it must be coded into your skin or use the sidebar mod available from here.
You mean there is a MOD that actually creates sidebar?

[ry215]

u done one for new threads m8 can u also do one for new posts plz ?

At the option "Order by?", you should choose" Lastpost".

[ry215]

You mean there is a MOD that actually creates sidebar?

here is your :)
https://vborg.vbsupport.ru/showthread.php?t=204773

[dmknights]

any chance of updating this to work for 3.8.1?

I have tested this mod on my 3.8.1 board & it doesnt work

[ry215]

any chance of updating this to work for 3.8.1?

I have tested this mod on my 3.8.1 board & it doesnt work

Hello, I used vBulletin 3.8.1 to code this mod.

Please read the replies above.

[dmknights]

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

[ry215]

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

OK, it DOESNT WORK! :D

[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
forumid IN (".ACTUAL BOARD AND SUBBORD IDs.")
instead of
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?

[tercede]

This is actually a pretty sweet mod. Now where the heck do I change the title of it..

*edit* found it thereafter!

[manguish]

Installed and working BUT it doesn't reflect the actual forum posts?

Any ideas why it doesn't refresh?

www.minimotoclub.co.uk for the example.

[BlackRanger3d]

Great mod.

This is actually a pretty sweet mod. Now where the heck do I change the title of it..


*edit* found it thereafter!

How did you change it?

Um yeah......I just found it too. Edit the sidebar template

[RTMdotORG]

anyway to add forum name?

[DarthCoder]

where do i put $template_hook[sidebar_lastest_threads]

i dont have any "sidebar" template. I want it to be shown on the left side.

[Zaki Shafqat]

where do i put $template_hook[sidebar_lastest_threads]

i dont have any "sidebar" template. I want it to be shown on the left side.

yes i have a same question

waiting until tomorrow or will uninstall it :mad:

i got another tempelate Sidebar Column now but want 2 :D

[sebaldus]

Doesn't work. :mad:
Uinstalled.
Sebaldus..

[Zaki Shafqat]

where do i put $template_hook[sidebar_lastest_threads]

i dont have any "sidebar" template. I want it to be shown on the left side.

i have added the second column as well :D

What i actually did is i first installed this plug-in

https://vborg.vbsupport.ru/showthread.php?t=204773

then hide all the un-necassary things and it was working just like this "Sidebar Lastest Threads"

i also installed this plugin "Sidebar Lastest Threads" so after both plugins were installed

what i did is i added this code $template_hook[sidebar_lastest_threads] provided in a first post in "Side Column templates (sc_latest_threads) found in Style & Manager>>>Edit Manager>>>Sidebar Column Template>>>sc_latest_threads and it was working fine

Now i got 2 siderbar columns installed on my site :D

[Zaki Shafqat]

Now i have one question only

How do i edit the title of this plugin from Lastest Threads to (Latest Videos)

Please help me edit this

Thanks

[RTMdotORG]

First off, thanks for this mod...
Secondly... im looking for a mod like this, but i want this mod like 4 times, so i can use each for a different forum.... anyway of doing this?

[Zaki Shafqat]

First off, thanks for this mod...
Secondly... im looking for a mod like this, but i want this mod like 4 times, so i can use each for a different forum.... anyway of doing this?

good thinking i got 2 already and it will be nice if we get get upto 4 :D

for the second mod install Sidebar Column and hide everything except latest threads

So you will have 2 different sidebars this way

----------

where is Sidebar Template????? i am unable to find it from Style Manager>>>Edit Templates>>>Sidebar Lastest Threads i even tried to search from all templates but nothing progress

[RTMdotORG]

good thinking i got 2 already and it will be nice if we get get upto 4 :D

for the second mod install Sidebar Column and hide everything except latest threads

So you will have 2 different sidebars this way

----------

where is Sidebar Template????? i am unable to find it from Style Manager>>>Edit Templates>>>Sidebar Lastest Threads i even tried to search from all templates but nothing progress

Sidebar Column Template is where it should be at.

[futuredood]

does this work with 3.6.8?

[futuredood]

Hmm, I have over 40 individual forums, is there any way to set this option to all?

ForumID.
Forums included from sidebar (List IDs, separate with commas)

I tried on 3.6.8 by the way it doesn't work.

[MagicThemeParks]

Is there something like this mod but to use with an RSS feed rather than feeding from a forum?

[MagicThemeParks]

Instead of pulling from the forums, can this be made to pull from an RSS feed? I have the Video Directory Remixed mod and I want to show the 'latest videos' in a sidebar. Any suggestions?

[ElForro]

I would like to use this MOD to display the latest threads from ALL my forums... The problem is I have +150 forums...

Is there any way I can modify this Mod in order to "exclude" Forums IDs rather than "include" Forums IDs?

Thanks!

[Bubble #5]

What would cause this?

https://vborg.vbsupport.ru/

There are no such threads so we can't delete them.

How should we clear all of the 'undefined' out, and where would we do this at? :confused:

Thanks :)

[MagicThemeParks]

Worked great in some custom pages that I'm setting up! :up:

Thanks! :)

[ahmedipa]

very good thank you my brother

[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.

$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]

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

Did a quick search and this may be your answer. https://vborg.vbsupport.ru/showpost.php?p=1782814&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
الموضوع والمنتج مترجم بتصرف باللغة العربية هنا (http://www.support-ar.com/vb/showthread.php?t=113639)

[webnsn]

It is not showing anything.

where I need to add? $template_hook[sidebar_lastest_threads]

I am using 3.7.1

[blind-eddie]

:up:It is not showing anything.

where I need to add? $template_hook[sidebar_lastest_threads]

I am using 3.7.1

I installed vbadvanced (http://www.vbadvanced.com/) a long time ago and can add right side column, left side column, top or bottom columns, each with their own content to any vbulletin page with very little effort.

Follow this link (http://www.vbadvanced.com/) to learn more.

[webnsn]

:up:

I installed vbadvanced (http://www.vbadvanced.com/) a long time ago and can add right side column, left side column, top or bottom columns, each with their own content to any vbulletin page with very little effort.

Follow this link (http://www.vbadvanced.com/) to learn more.

Sorry I am not using new version.

I am using 3.7.1 and your DEMO is showing advanced module.

Anyway I have installed SIDEBAR and here the example www.wikinewforum.com

NOW I need your help to get below,

1. SIDEBAR threads should show SUB-FORUM wise, example if I see a article from SUBFORUM 5 then thereads should in the sidebar Latest threads fom subforum 5 only.

And I also wanted to add a ADSENSE above sidebar so that first adsence and below latst thereads for that subforum

And I also want one SIDEBAR (RIGHT side) with Threads which I select example If I select 10 threads which I want to show in RIGHT SIDEBAR.

[blind-eddie]

The link I provided to you is to the site you would download vBadvanced from.
Simply go here: http://www.vbadvanced.com/products.php?do=productinfo&productid=4

Click [Download / Additional Services], follow instructions, on the Download Options page, click the dropdown and select 3.2.3 (vB 3.6 - vB 3.8) - Released 01-26-2012. This will be the one you need to work with your current version of vbulletin.
Good luck.

[webnsn]

The link I provided to you is to the site you would download vBadvanced from.
Simply go here: http://www.vbadvanced.com/products.php?do=productinfo&productid=4

Click [Download / Additional Services], follow instructions, on the Download Options page, click the dropdown and select 3.2.3 (vB 3.6 - vB 3.8) - Released 01-26-2012. This will be the one you need to work with your current version of vbulletin.
Good luck.

4 types I tried to register and it is saying same

'The answer given for the random question was incorrect.'