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 !!!

[codemonkey]

Originally Posted by codemonkey

Hi, no i meant in the template with the name 'header' so that the stats box will be shown on every site of the forums!

can anybody help me?

[Codeman05]

Great Mod!!
I got the stats box/table to display, but the stats are not displaying in it. Any ideas?

BTW...This is probably the issue but I'm not sure:
This line: forumhome_subforumseparator_post'
was not in my index.php

so I added the following anyway

'forumhome_subforumseparator_post',
'forumhome_stats_poster',
'forumhome_stats_member',
'forumhome_stats_thread',

Like in the instructions, but no go


EDIT:
NM I'm an idiot, forgot my "index" is no longer index.php

[codemonkey]

Is there nobody, who can say me how to edit my php files so that the Stats Box will work in my header template?

please help me!

[anabolicedge]

why does it say [old] by my newest replies??

http://www.anabolicedge.net/forum/

[bspiller82]

Originally Posted by codemonkey

Is there nobody, who can say me how to edit my php files so that the Stats Box will work in my header template?

please help me!

What you need help with exactly?

[rinkrat]

I'd like to see top five reputations, can that be done?

[trinitym]

I too have a similar request to codemonkey's. I'd love to be able to get this to work in another template other than FORUMHOME. Ideally, I want to have the stats show up in the sidebar template of Dark_Wizard's left sidebar hack.

Can some one point me in the right direction if this is possible?

[alzibub]

Nice hack !!
Simple to install and works fine as far as I can see !!

I know someone else asked this - but is there a way to exclude forums from the newest replies ?

Like it
*clicks install*

[Codeman05]

I was wondering if anyone had gotten this hack to work correctly in the "Showthread" template.

Basically I'd like the stats to show up on the thread listing pages...I can get the table to show up, but none of the stats work. Has anyone been able to do this, or is it even possible?

[InfiniteWebby]

to get this to work in the header or footer templates

Add to the phpinclude_start template:

PHP Code:

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


And add to the header or footer where you want the stats:

<!-- top statistics box -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<thead>
	<tr>
		<td class="tcat" colspan="3">
			<a style="float:$stylevar[right]" href="#top" onclick="return toggle_collapse('forumhome_statistics')"><img id="collapseimg_forumhome_statistics" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_forumhome_statistics].gif" alt="" border="0" /></a>
			Statistics - Top $displayrecords</td>
	</tr>
</thead>
<tbody id="collapseobj_forumhome_statistics" style="$vbcollapse[collapseobj_forumhome_statistics]">
	<tr>
		<td class="thead" width="23%" align="$stylevar[left]" nowrap>Top Posters</td>
		<td class="thead" width="22%" align="$stylevar[left]" nowrap>Newest Members</td>
		<td class="thead" width="55%" nowrap>Newest Replies
		</td>
	</tr>
	<tr>
		<td class="alt2" width="23%" valign="top">
		<table>
			<tr>
				<td class="smallfont" width="100%">Member:</td>
				<td class="smallfont" align="right" nowrap>Posts:</td>
			</tr>
			$stats_posters
		</table>
		</td>
		<td class="alt1" width="22%" valign="top">
		<table>
			<tr>
				<td class="smallfont" width="100%" nowrap>Member:</td>
				<td class="smallfont" align="right" nowrap>Posts:</td>
			</tr>
			$stats_members
		</table>
		</td>
		<td class="alt2" width="55%" valign="top">
		<table>
			<tr>
				<td class="smallfont" width="70%" nowrap>Thread:</td>
				<td class="smallfont" width="30%" nowrap>Last Poster:</td>
				<td class="smallfont" align="right" nowrap>Views:</td>
				<td class="smallfont" align="right" nowrap>Replies:</td>


			</tr>
			$stats_threads
		</table>
		</td>
	</tr>
</tbody>
</table>
<br />
<br />
<!-- end top statistics box -->

then add all the extra templates as instructed.

THIS HAS NOT BEEN TESTED BUT SHOULD WORK NICELY.

As for showthread instead of adding the above codes to phpinclude and the head or footer add them to showthread.php and the showthread template where you want them. i am not completely sure as to where but trial and error is always the best way to learn.

DO THESE AT YOUR OWN RISK AS I WILL BE PROVIDING LIMITED SUPPORT.