Top xx Posters List

This modification is no longer available or supported.

The 3.5 version of my Top (10) Posters hack.

This has now been re-vamped for the release of version 3.xx - the hack no longer uses a seperate topposters.php file.

This hack displays a page with the Top Forum Posters for a given set of periods. Two periods are fixed ('This Month' & 'Overall') but can be turned off in the options. The other three periods are user definable (in days) - the default values are 1 day (24 hours), 7 days & 28 days. These three columns cannot be turned off.

The number of posters to be shown can also be set, the default is the top 10 posters. You can also select which usergroups are included in the count, so members in banned groups etc are not shown.

To upgrade (if you want to) uninstall version 2.xx and re-install this version. Note the url to display the page has changed.


History:

v3.01 - First public version 3
v3.02 - Fixed display error reported in post 59
v3.03 - Fixed display error reported in post 84
v3.11 - Series of additions, upgrades and settings added.
v3.12 - Updated install code to check for existing index.
v3.13 - Fixed uncached templates added in v3.11
v3.14 : Changes to display layout.
v3.15 : Minor changes, no update necessary.
v3.16 : Fixed bug in monthly totals caculation.

[Paul M]

Feel free to click on install

[chriszep]

hello
just an idea
is it possible to show near the name his avatar (small) ?

[Paul M]

If you edited the plugin, and the template, then probably - but I'm afraid it's not something I intend to do.

[chriszep]

Originally Posted by Paul M

If you edited the plugin, and the template, then probably - but I'm afraid it's not something I intend to do.

yes I was thinking it's possible but I'm not a coder :cross-eyed:

[ar2]

This is my navbar, I've pasted code but i can't see top users on my forum :cross-eyed: forum.hdtv.com.pl

<script type="text/javascript">
<!--
function log_out()
{
	ht = document.getElementsByTagName("html");
	ht[0].style.filter = "progid:DXImageTransform.Microsoft.BasicImage(grayscale=1)";
	if (confirm('$vbphrase[sure_you_want_to_log_out]'))
	{
		return true;
	}
	else
	{
		ht[0].style.filter = "";
		return false;
	}
}
//-->
</script>

<br />







 <!-- top category table setup -->
<table width="100%" style="background-image:url($stylevar[imgdir_misc]/cat_back.gif)" border="0" cellpadding="0" cellspacing="0">
  <tr>
    <td width="140" height="27" align="left" valign="top"><img src="$stylevar[imgdir_misc]/cat_top_ls.gif" width="140" height="27" alt=" " border="0" /></td>
    <td width="100%" style="background-image:url($stylevar[imgdir_misc]/cat_back.gif)" valign="middle">&nbsp;</td>
     <td width="140" height="27" align="right" valign="top"><img src="$stylevar[imgdir_misc]/cat_top_rs.gif" width="140" height="27" alt=" " border="0" /></td>
  </tr>
</table>
        <!-- End top category table setup -->

<!-- breadcrumb, login, pm info -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
<tr>
	<td class="alt1" width="100%">
		<if condition="is_array($navbits)">
			<table cellpadding="0" cellspacing="0" border="0">
			<tr valign="bottom">
				<td><a href="#" onclick="history.back(1)"><img src="$stylevar[imgdir_misc]/navbits_start.gif" alt="$vbphrase[go_back]" border="0" /></a></td>
				<td>&nbsp;</td>
				<td width="100%"><span class="navbar"><a href="$vboptions[forumhome].php?$session[sessionurl]">$vboptions[bbtitle]</a></span> $navbits[breadcrumb]</td>
			</tr>
			<tr>
				<td class="navbar" style="font-size:10pt; padding-top:1px" colspan="3"><a href="$scriptpath"><img class="inlineimg" src="$stylevar[imgdir_misc]/navbits_finallink.gif" alt="$vbphrase[reload_this_page]" border="0" /></a> <strong>$navbits[lastelement]</strong></td>
			</tr>
			</table>			
		<else />
			<div class="navbar" style="font-size:10pt"><a href="$vboptions[forumhome].php?$session[sessionurl]"><img class="inlineimg" src="$stylevar[imgdir_misc]/navbits_start.gif" alt="" border="0" /></a> <strong>$vboptions[bbtitle]</strong></div>
		</if>
	</td>	
	
	<if condition="$bbuserinfo['userid']">
	
		<td class="alt2" valign="top" nowrap="nowrap">
		<div class="smallfont">
			<!--<span style="float:$stylevar[right]">[<a href="login.php?$session[sessionurl]do=logout" onclick="return log_out()">$vbphrase[log_out]</a>]</span>-->
			<strong><phrase 1="$bbuserinfo[username]">$vbphrase[welcome_x]</phrase></strong><br />
			<phrase 1="$pmbox[lastvisitdate]" 2="$pmbox[lastvisittime]">$vbphrase[last_visited_x_at_y]</phrase>
			<if condition="$show['pmstats']"><br /><phrase 1="$vbphrase[unread_x_nav_compiled]" 2="$vbphrase[total_x_nav_compiled]" 3="$session[sessionurl]">$vbphrase[private_messages_nav]</phrase></if>
		</div>
		</td>
		
	<else />
		
		<td class="alt2" nowrap="nowrap" style="padding:0px">
			
		<!-- login form -->
		<form action="login.php" method="post" onsubmit="md5hash(vb_login_password,vb_login_md5password)">
		<script type="text/javascript" src="clientscript/vbulletin_md5.js"></script>
		<table cellpadding="0" cellspacing="$stylevar[formspacer]" border="0">
		<tr>
			<td class="smallfont">$vbphrase[username]</td>
			<td><input type="text" class="button" name="vb_login_username" id="navbar_username" size="10" accesskey="u" tabindex="1" value="$vbphrase[username]" onfocus="if (this.value == '$vbphrase[username]') this.value = '';" /></td>
			<td class="smallfont" colspan="2" nowrap="nowrap"><label for="cb_cookieuser_navbar"><input type="checkbox" name="cookieuser" value="1" tabindex="3" id="cb_cookieuser_navbar" accesskey="c" checked="checked" />$vbphrase[remember_me]</label></td>
		</tr>
		<tr>
			<td class="smallfont">$vbphrase[password]</td>
			<td><input type="password" class="button" name="vb_login_password" size="10" accesskey="p" tabindex="2" /></td>
			<td><input type="submit" class="button" value="$vbphrase[log_in]" tabindex="4" title="$vbphrase[enter_username_to_login_or_register]" accesskey="s" /></td>
		</tr>
		</table>
		<input type="hidden" name="s" value="$session[sessionhash]" />
		<input type="hidden" name="do" value="login" />
		<input type="hidden" name="forceredirect" value="1" />			
		<input type="hidden" name="vb_login_md5password" />
		</form>
		<!-- / login form -->
			
		</td>
		
	</if>	
	
</tr>
</table>
<!-- / breadcrumb, login, pm info -->








  <!-- bottom table setup -->
    <table width="100%" border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td width="70" align="left" valign="top"><img src="$stylevar[imgdir_misc]/ls_main_table_bottom.gif" width="70" height="14" alt=" " border="0" /></td>
        <td  width="100%" style="background-image:url($stylevar[imgdir_misc]/extended_main_table_bottom.gif)"><img src="$stylevar[imgdir_misc]/clear.gif" width="100%" height="14" alt=" " border="0" /></td>
        <td width="70" align="right" valign="top"><img src="$stylevar[imgdir_misc]/rs_main_table_bottom.gif" width="70" height="14" alt=" " border="0" /></td>
      </tr>
    </table>
   <!-- End bottom table setup -->




   	<if condition="$show['guest']">
	<br />
	<!-- guest welcome message -->
	   <table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">

	<tr>
		<td class="tcat" colspan="6"><phrase 1="$vboptions[bbtitle]">$vbphrase[welcome_to_the_x]</phrase></td>
	</tr>
	<tr>
		<td class="alt1" colspan="6">
			<phrase 1="faq.php?$session[sessionurl]" 2="register.php?$session[sessionurl]">$vbphrase[first_visit_message]</phrase>
		</td>
	</tr></table>
	<!-- / guest welcome message -->
	</if>


<br />
<br />








<if condition="$show['popups']">
<!-- NAVBAR POPUP MENUS -->
	
	<if condition="$show['searchbuttons']">
	<!-- header quick search form -->
	<div class="vbmenu_popup" id="navbar_search_menu" style="display:none">
		<table cellpadding="4" cellspacing="1" border="0">
		<tr>
			<td class="thead">$vbphrase[search_forums]</td>
		</tr>
		<tr>
			<td class="vbmenu_option" title="nohilite">
			<form action="search.php" method="post">
				<input type="hidden" name="do" value="process" />
				<input type="hidden" name="showposts" value="0" />
				<input type="text" class="bginput" name="query" size="20" />$gobutton<br />
			</form>
			</td>
		</tr>
		<tr>
			<td class="vbmenu_option"><a href="search.php?$session[sessionurl]">$vbphrase[advanced_search]</a></td>
		</tr>
		</table>
	</div>
	<!-- / header quick search form -->
	</if>

	<if condition="$show['member']">
	<!-- user cp tools menu -->
	<div class="vbmenu_popup" id="usercptools_menu" style="display:none">
		<table cellpadding="4" cellspacing="1" border="0">
		
		<tr><td class="thead">$vbphrase[quick_links]</td></tr>		
		<tr><td class="vbmenu_option"><a href="search.php?$session[sessionurl]do=getnew">$vbphrase[new_posts_nav]</a></td></tr>
		<tr><td class="vbmenu_option"><a href="forumdisplay.php?$session[sessionurl]do=markread">$vbphrase[mark_forums_read]</a></td></tr>
		<tr><td class="vbmenu_option"><a href="#" onclick="window.open('misc.php?$session[sessionurl]do=buddylist&amp;focus=1','buddylist','statusbar=no,menubar=no,toolbar=no,scrollbars=yes,resizable=yes,width=250,height=300'); return false;">$vbphrase[open_buddy_list]</a></td></tr>
				
		<tr><td class="thead"><a href="usercp.php?$session[sessionurl]">$vbphrase[user_control_panel]</a></td></tr>
		<if condition="$show['siglink']"><tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editsignature">$vbphrase[edit_signature]</a></td></tr></if>
		<if condition="$show['avatarlink']"><tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editavatar">$vbphrase[edit_avatar]</a></td></tr></if>
		<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editprofile">$vbphrase[edit_profile]</a></td></tr>
		<tr><td class="vbmenu_option"><a href="profile.php?$session[sessionurl]do=editoptions">$vbphrase[edit_options]</a></td></tr>
		
		<tr><td class="thead">$vbphrase[miscellaneous]</td></tr>
		<if condition="$show['pmstats']"><tr><td class="vbmenu_option"><a href="private.php?$session[sessionurl]">$vbphrase[private_messages]</a></td></tr></if>

<tr><td class="vbmenu_option"><a href="misc.php?$session[sessionurl]do=topposters">Display Top Posters</a></td></tr>


		<tr><td class="vbmenu_option"><a href="subscription.php?$session[sessionurl]">$vbphrase[subscribed_threads]</a></td></tr>
		<tr><td class="vbmenu_option"><a href="member.php?$session[sessionurl]u=$bbuserinfo[userid]">$vbphrase[my_profile]</a></td></tr>
		<if condition="$show['wollink']"><tr><td class="vbmenu_option"><a href="online.php?$session[sessionurl]">$vbphrase[whos_online]</a></td></tr></if>
		
		</table>
	</div>
	<!-- / user cp tools menu -->
	</if>
<!-- / NAVBAR POPUP MENUS -->
</if>

[Dr.Viggy]

*installed

[thelittleguy]

I keep gettin this error message Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT COUNT(post.dateline) AS postcount, post.userid, user.username
FROM post AS post
LEFT JOIN user AS user ON (post.userid = user.userid)
WHERE dateline > 1148052957 AND user.usergroupid IN (2,3,4,)
GROUP BY userid ORDER BY postcount DESC LIMIT 10;

MySQL Error : You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ')
GROUP BY userid ORDER BY postcount DESC LIMIT 10' at lin
Error Number : 1064
Date : Saturday, May 20th 2006 @ 08:35:57 AM
Script : http://mywebsiteaddress/forums/misc.php?do=topposters

[Paul M]

Check your usergroups allowed setting, you may have a stray space or comma at the end of the list.

[Snake]

Paul, could you make this hack as a seperate file and URL just like the other top threads/topics hack?

[Paul M]

Originally Posted by Lil Ripsta

Paul, could you make this hack as a seperate file and URL just like the other top threads/topics hack?

Sorry, but no, that would be a backwards step IMO.