Top 'X' Stats

This hack adds the top 'x' stats (top posters, newest members, newest replies) to your forumhome.

The original idea was nanoentities but he will not be releasing his hack for vB3. Basically this is the same idea, all new coding, all new templates.

This hack also shows a 'New' or 'Old' text if the thread was posted after your lastvisit or marking all forums as read. Also it posts the deleted message for those who can see it and can be set to exclude forums.

I am currently working on a seperate page where the user can set the number of stats he wishes to show.

Live demo at: *removed* (dow the bottom)

vB 3.5 version available at https://vborg.vbsupport.ru/showthrea...846#post743846 !!!

[mike3k]

here is a pic of the templates can you see if there in the rite place plz

i've checked everything 10 times to be sure it wasnt me

uploaded and redone the index.php loads of times to be sure also

thanks for your reply mate

[1nf3rn0]

well if you can see the top x stats on your forum home, then the templates should be right...the dispalying of the actual stats has to do with the index.php...maybe copy and paste your index.php so we can take alook at it may help us help you more..

[Sleepyk]

<a href="http://thebattledome.com" target="_blank">http://thebattledome.com</a>

i havin lil prob with % on top poster thread person, etc

[King Kovifor]

Is there a way to exclude HIDDEN Forums to the groups that can't see it.

[1nf3rn0]

yes sir..ask and ye shall receive bud!

look for:

PHP Code:

$excludedforums = "13"; // forums to be excluded from latest threads. Format "0,5,7" 


and just add the forum id's you want excluded!

[1nf3rn0]

Originally Posted by Sleepyk

http://thebattledome.com

i havin lil prob with % on top poster thread person, etc

shoot us a screen shot...dont know if we need a login to view it at your site bud

[mike3k]

ok i have pasted some of the code here

all the code that has been alered.

// ### BOARD STATISTICS #################################################

// get total threads & posts from the forumcache
$totalthreads = 0;
$totalposts = 0;
if (is_array($forumcache))
{
	foreach ($forumcache AS $forum)
	{
		$totalthreads += $forum['threadcount'];
		$totalposts += $forum['replycount'];
	}
}
$totalthreads = vb_number_format($totalthreads);
$totalposts = vb_number_format($totalposts);

// get total members and newest member from template
$userstats = unserialize($datastore['userstats']);
$numbermembers = vb_number_format($userstats['numbermembers']);
$newusername = $userstats['newusername'];
$newuserid = $userstats['newuserid'];

// ### TOP 5 STATS BY ANIMEWEBBY ###########################################
$displayrecords = "5"; // how many records should we show?
$excludedforums = "13"; // forums to be excluded from latest threads. Format "0,5,7"
$threadchars = "30"; // number of characters in thread title before '...' is added

$getstats_posters = $DB_site->query("SELECT userid, username, posts FROM " . TABLE_PREFIX . "user ORDER BY posts DESC LIMIT 0, $displayrecords");
while ($getstats_poster = $DB_site->fetch_array($getstats_posters))
{
		eval('$stats_posters .= "' . fetch_template('forumhome_stats_poster') . '";');
}

$getstats_members = $DB_site->query("SELECT userid, username, posts, joindate FROM " . TABLE_PREFIX . "user ORDER BY joindate DESC LIMIT 0, $displayrecords");
while ($getstats_member = $DB_site->fetch_array($getstats_members))
{
		eval('$stats_members .= "' . fetch_template('forumhome_stats_member') . '";');
}

// filter out deletion notices if can't be seen
$forumperms = fetch_permissions($forumid);
if (!($permissions['forumpermissions'] & CANSEEDELNOTICE))
{
	$delquery = ", NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason";
	$delthreadlimit = "AND deletionlog.primaryid IS NULL";
	$deljoin = "LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')";
}
else
{
	$delquery = ", NOT ISNULL(deletionlog.primaryid) AS isdeleted, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason";
	$delthreadlimit = "";
	$deljoin = "LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')";
}

$getstats_threads = $DB_site->query("
SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.lastposter, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, thread.visible, user.username, user.userid 
$delquery
		FROM " . TABLE_PREFIX . "thread AS thread
		LEFT JOIN  " . TABLE_PREFIX . "user AS user ON (user.username = thread.lastposter)
$deljoin
WHERE thread.forumid NOT IN ($excludedforums)
$delthreadlimit
ORDER BY thread.lastpost DESC LIMIT 0, $displayrecords");

while ($getstats_thread = $DB_site->fetch_array($getstats_threads))
{
	$getstats_thread[title] = unhtmlspecialchars($getstats_thread[title]);
	if (strlen($getstats_thread[title]) > $threadchars)
	{		
		$getstats_thread[titletrimmed] = substr($getstats_thread[title], 0, strrpos(substr($getstats_thread[title], 0, $threadchars), ' ')) . '...';
	}
	else
	{
		$getstats_thread[titletrimmed] = $getstats_thread[title];
	}
	if ($getstats_thread[lastpost] > $bbuserinfo[lastvisit])
	{
		$getstats_thread[newpost] = true;
	}
	if ($getstats_thread[isdeleted])
	{
		$getstats_thread[isdeleted] = true;
	}
	eval('$stats_threads .= "' . fetch_template('forumhome_stats_thread') . '";');
}

// ### ALL DONE! SPIT OUT THE HTML AND LET'S GET OUTA HERE... ###

eval('$navbar = "' . fetch_template('navbar') . '";');
eval('print_output("' . fetch_template('FORUMHOME') . '");');

[mike3k]

oh and templates but as you said this works.

// pre-cache templates used by all actions
$globaltemplates = array(
	'FORUMHOME',
	'forumhome_event',
	'forumhome_forumbit_level1_nopost',
	'forumhome_forumbit_level1_post',
	'forumhome_forumbit_level2_nopost',
	'forumhome_forumbit_level2_post',
	'forumhome_lastpostby',
	'forumhome_loggedinuser',
	'forumhome_moderator',
	'forumhome_pmloggedin',
	'forumhome_subforumbit_nopost',
	'forumhome_subforumbit_post',
	'forumhome_subforumseparator_nopost',
	'forumhome_subforumseparator_post',
	'forumhome_stats_poster',
	'forumhome_stats_member',
	'forumhome_stats_thread',

[1nf3rn0]

yes, but did you add the templates in your admincp?...the index.php calls to the templates to give you your stats therefore you need to ad templates in your admincp witht the content stated in the instructions

forumhome_stats_member
forumhome_stats_poster
forumhome_stats_thread

[soniceffect]

OK .. lookin like a few have asked this question but can`t seem to see a reply ... I have the RSS feed hack installed, and although I can exclude the feeds forum, I dunno how to excude the user that I`m using as the bot from my top 5 posters

Anyone?