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]

I'm not sure Michael. I haven't used the mod in some time.

[futuredood]

hey michael did you get this to work on 3.5.4? i'd like to use it if it works..

[Aislinn]

It does work on 3.5.4 I have it installed on mine.

It worked perfectly until I changed this as you said we could above.:

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

WHERE dateline > $datecut

to
Code:

WHERE lastpost > $datecut

Now that Ive changed it it works and looks fine except for one thing. In the table border on top of it, it used to say Hot Topics, now its just a blank strip of color. Any idea on what might have done it?

That was the only thing I changed and then I reimported teh file and overwrite the old one.

Edit//

Ok now this is really weird. I changed the file back the way it way, reimported. Still not showing the title. So I redownloaded the zip file, imported the new never edited file from the zip and still no title.

So now Ive changed it back to the lastpost instead of dateline and have no idea how to get the title up. I can see the <title></title> in the file but I dont know why its not reading it.

I have boofo's changes in place as well.

[karlm]

Originally Posted by Jnifoo

3. create a $vbphrase[hottopics] translation to the system language system (english & your own language if required)
(-> let's translate it into, for example, 'This Week's Hot Topics')

Hi Jnifoo, the help you supplied in post 108 is great and i now have it showing just underneath the forum statistics.
However, I'm stuck on the above quotes. could someone guide me in creating a $vbphrase/translation ?

[Jnifoo]

Hello Karlm, sorry didn't notice your question till I search for plugin update
Use the admin pannel dedicated for language & expressions:
YOURURI/YOURADMINPANEL/phrase.php?do=modify&fieldname=global
See the exemples provided for the syntax, then clic on "add new expression"

Hope this help for you or someone else

[Al-Fateh]

hmmmm

not working

can this work for 3.6.x?

[macgyvers]

Hi all,
Can this work on 3.6.5 ?

thanks

[smapdi]

Thanks - I was really looking for this something like this. Just got done installing & tweaking. I've seen it asked a few times so FYI I was able to get this to work globally and in a left column ... things I changed were hookname to global_start - also I prefaced most of the variables with "ht_" e.g. $forumchoice became $ht_forumchoice ... when I went global there must have been some variable crashes as my forum navigation got all wacky ... oh - also I changed the table to a <ul> and hot threads to <li>s. So far seems to work nice in 3.6.4. Thanks again.

[pelican]

is there a 3.7.0 version?

[caliman]

Originally Posted by pelican

is there a 3.7.0 version?

I haven't been able to get it to work since I upgraded to 3.7.1 from 3.6.8.