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

[Neal-UK]

Originally Posted by Boofo

I forgot to post my version of the hottopics template. Sorry about that. Here it is and the icon you need to change is in there.

<tr>
<td class="alt2"><img src="$stylevar[imgdir_misc]/calendar.gif" border="0" /></td>
<td class="alt1" width="100%"><div class="smallfont">$topicstring</div></td>
</td>
</tr>

Amy, you might want to add this, too.

cheers boofo, thought i was going mad!

[Boofo]

Sometimes, I forget the little things. It must be old age.

The reason I used the calender icon is because it is supposed to be the Week's Hot Topics and a calendar has some weeks in it (I think).

[Kusadasi-Guy]

I have a question, how can i call the hottopics?
i can call usernames ...etc ( $vbphrase[logged_in_user]: $bbuserinfo[username] -> Logged in user: User Name). But i cant call this...

[Boofo]

$hottopics

[Kusadasi-Guy]

no, it doesnt work

[Boofo]

Where are you trying to call it from and do you have the plug-in installed?

[Kusadasi-Guy]

Originally Posted by Boofo

Where are you trying to call it from and do you have the plug-in installed?

Yes, the plugin is installed.
and i am tryin this on a custom VB page, like this;
<?php

// ####################### SET PHP ENVIRONMENT ###########################
error_reporting(E_ALL & ~E_NOTICE);

// #################### DEFINE IMPORTANT CONSTANTS #######################
define('THIS_SCRIPT', 'bugs');
define('NO_REGISTER_GLOBALS', 0);

// ################### PRE-CACHE TEMPLATES AND DATA ######################
// get special phrase groups
$phrasegroups = array();

// get special data templates from the datastore
$specialtemplates = array(
);

// pre-cache templates used by all actions
$globaltemplates = array(
'shell_blank'
);

// pre-cache templates used by specific actions
$actiontemplates = array();

// ######################### REQUIRE BACK-END ############################
require_once('./global.php');

echo $hottopics ;
$html = <<< HTML
<!-- html starts here -->
$hottopics
<!-- html ends here -->
HTML;

$navbits["mycookies2.php"] = 'Photo Gallery';
$navbits = construct_navbits($navbits);
eval('$navbar = "' . fetch_template('navbar') . '";');
eval('$hottopics = "' . fetch_template('hottopics') . '";');

$pagetitle = "Photo Gallery";
eval('print_output("' . fetch_template('shell_blank') . '");');

?>

[Boofo]

Since they are on the forumhome, I'm not sure how you would call them from another page.

[Rich]

Hello,

Hi Amy, me again! lol How could I modify this to only call from certain forums? I have a few private forums for my staff, and I would like to keep them private and not on that list if possible.

Not sure if it does or not, but even with userpermissions set so that only staff can see the forum,. I would just like to remove those forums entirely from this.

[amykhar]

The easiest way would be to remove the ones you don't want in the $forumchoice array.