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

[Kusadasi-Guy]

Amycar, this is a great plugin!
is there a chance to put this on a vb-powered custom page?

[amykhar]

Kusadasi-Guy, you could lift the code out of the plugin and use it anywhere that global.php is included. It's a straightforward query. You will need to restructure your template though.

Amy

[Kusadasi-Guy]

i am really sorry to being noob, but i couldnt. Can you create a small example? This is really too important for me becuase i want to create my VB-powered custom page.

i tried this, and of course it doesnt work;

<?php

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

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

// ################### 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');


$html = <<< HTML
<!-- html starts here -->
require_once('./global.php');
$forumchoice = array();

foreach (array_keys($vbulletin->forumcache) AS $forumid)
{
$forumid = intval($forumid);
$forumperms =& $vbulletin->userinfo['forumpermissions']["$forumid"];

if (isset($vbulletin->forumcache["$forumid"]) AND ($forumperms & $vbulletin->bf_ugp_forumpermissions['canview']) AND ($forumperms & $vbulletin->bf_ugp_forumpermissions['canviewothers']) AND verify_forum_password($forumid, $vbulletin->forumcache["$forumid"]['password'], false))
{
$forumchoice[] = $forumid;
}
}
$datecut = TIMENOW - (7*24*60*60);
$hottopics = $db->query_read("SELECT * FROM ".TABLE_PREFIX."thread WHERE dateline > $datecut AND forumid IN (". implode(',', $forumchoice) . ") AND open=1 ORDER BY replycount DESC LIMIT 10");
$topicstring = "";
while($hottopic = $db->fetch_array($hottopics))
{
$topicstring.="<b>&raquo;</b> <a href='showthread.php?t=".$hottopic[threadid]."'>".$hottopic[title]."</a> - $hottopic[replycount] replies<br />";
}
eval('$hottopics = "' . fetch_template('hottopics') . '";');
<!-- html ends here -->
HTML;

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

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

?>

[Boofo]

For anyone that is intested, I made a slight change to the xml file. It will now say:

No replies for 0 replies
1 reply (for 1 reply)
12 replies (for multiple replies)

If anyone is interested. let me know, and if Amy oks it, I will post the change here.

[amykhar]

Go for it. I'll even add you as co-author and put it in the original post with your template mod.

[Boofo]

In the xml file for this mod

Find:

PHP Code:

while($hottopic = $db->fetch_array($hottopics))
{
$topicstring.="<a href='showthread.php?t=".$hottopic[threadid]."'>".$hottopic[title]."</a> - ($hottopic[replycount] replies)<br />";
} 


REPLACE it with:

PHP Code:

 while($hottopic = $db->fetch_array($hottopics))
{
if ($hottopic[replycount] == 1)
{
$topicstring.="<a href='showthread.php?t=".$hottopic[threadid]."'>".$hottopic[title]."</a> - ($hottopic[replycount] reply)<br />";
}
else if ($hottopic[replycount] == 0)
{
$topicstring.="<a href='showthread.php?t=".$hottopic[threadid]."'>".$hottopic[title]."</a> - (No replies)<br />";
}
else
{
$topicstring.="<a href='showthread.php?t=".$hottopic[threadid]."'>".$hottopic[title]."</a> - ($hottopic[replycount] replies)<br />";
}
} 


I know it's crude, but it works.

[amykhar]

I updated the zip and added your name Bob. I am forced to use wordpad cause I'm here at work without my editor of choice. Somebody please make sure the zip file imports ok.

[Boofo]

Thanks, Amy.

You want an updated pic for it?

[amykhar]

Sure. Why not. I'm no longer using this plugin on my site cause I moved the content to my side-bar.

[Neal-UK]

I've done the re-install of the updated version but you will need to add the phrases manually again (See start of this thread).

I still can't get it to look like the rest of the 'What's going on' though.......