Top 5 "Hot" Topics on Forum Home Page

This little one puts a list of the five threads with the most replies that have been active in the past 7 days on your forum home page.

You can change the query to make it 10 topics with most views or whatever suits your needs.

Things you may want to change:

To get the top 10, 20 or whatever topics instead of 5, change

LIMIT 5

to the number of your choice.

To get the top topics based on views instead of replies, change

ORDER BY replycount

to

ORDER BY views

To keep track of the top threads that are currently active, no matter when they were started, change

WHERE dateline > $datecut

to

WHERE lastpost > $datecut

[amykhar]

Can't think of anything off the top of my head unless maybe you edited the forumhome in the wrong style and not the one you are checking?

[yoyoyoyo]

Originally Posted by amykhar

Can't think of anything off the top of my head unless maybe you edited the forumhome in the wrong style and not the one you are checking?

no- just using the forum default, and it is on a somewhat virgin install. I checked the edits and they are there. Here they are, and also the few lines before and after:

</tbody>
<tbody id="collapseobj_forumhome_events" style="$vbcollapse[collapseobj_forumhome_events]">
	<tr>
		<td class="alt2"><a href="calendar.php$session[sessionurl_q]"><img src="$stylevar[imgdir_misc]/calendar.gif" alt="$vbphrase[calendar]" border="0" /></a></td>
		<td class="alt1" width="100%"><div class="smallfont">$upcomingevents</div></td>
	</tr>
<!-- This Week's Hot Topics -->
<tbody>
<tr>
<td class="thead" colspan="2">
<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_hottopics')"><img id="collapseimg_forumhome_hottopics" src="$stylevar[imgdir_button]/collapse_thead$vbcollapse[collapseimg_forumhome_hottopics].gif" alt="" border="0" /></a><span class="smallfont"><strong>$vbphrase[hottopics]</strong><span>
</td>
</tr>
</tbody>
<tbody id="collapseobj_forumhome_hottopics" style="$vbcollapse[collapseobj_forumhome_hottopics]">
$hottopics
</tbody>
<!-- end This Week's Hot Topics -->  
</tbody>
</if>
</table>
<br />
<!-- end what's going on box -->

<!-- icons and login code -->
<table cellpadding="0" cellspacing="2" border="0" width="100%">
<tr valign="bottom">
	<td>
		<table cellpadding="2" cellspacing="0" border="0">

see screenshots, also.

[amykhar]

I'm assuming that the box the hottopics are supposed to be in is showing, just not the list itself?

[yoyoyoyo]

Originally Posted by amykhar

I'm assuming that the box the hottopics are supposed to be in is showing, just not the list itself?

nope - the box is not showing either- do you want me to PM you admin login info so you can check it out?

Granted tehre are only 2 threads and 5 posts, since it is a somewhat virgin install, as I said, but that should pull up SOMETHING for a "HOT TOPIC," right?

[amykhar]

See, this is the reason for my confusion. The template mods you made to forumhome should show whether you have the plugin installed or not. Sure, go ahead and PM me the info.

Amy

[yoyoyoyo]

just so everyone knows- I had some weird buggy install of RC2... amy could not log in, and when I tried logging in as her I got the same error - then when I tired logging in as myself I got the same error- and it thought I was still trying to log in as amy! I don't even know what to report as a bug to vbulletin... I am going to try to reinstall since the hack was obviously not causing the error I was experiencing, but rather a bad install of vbulletin... or gremlins.

[ohgenki]

erm, is there anyway to show the latest threads on the right panel ? together with this ? for a start, i can't even show the latest threads on the panel, it just doesn't display, any idea what's wrong ?

[amykhar]

Ohgenki, to display data on a template, you have to get it in scope for the template. There are too many possibilities of dynamic data in the sidebars for me to support them all. Sorry.

Amy

[ohgenki]

erm, actually the problem, i beleive is this, check this out, whenever there's an attachment, the table will stretch the whole page, which is what makes the scroll bar at the bottom appear, any idea how to solve that ?

and regarding the latest threads, say i just want to display your 5 hot topics on the right panel, how do i do that ? i can't seem to get it to work just by simply putting the code in.

[IFor[You]]

ok i tink i'm getting the gist of it,
can i change the hook location so i can call it from anywhere besides forumhome?