Top XX Posters

LAST UPDATED: 3.26.01 2:10 AM Eastern

I put together a little thing to show the top XX posters on your board. It can be used on a non-vB page. The username is a link to the member's profile.



Hack version: 0.0.4

Changes from version 0.0.1: Fixed a small bug with the path.
Changes from version 0.0.2: Added option to exclude admins from list of posters.
Changes from version 0.0.3: Fixed alternating colors so they are horizontal, not vertical. Changed $path to $url and $path2 to $path to make variables easier. Added a seperate header row color.

For version: 2.0.0 beta 3 (possibly also beta 1 and beta 2, but it is untested with those versions).

Files needed: topposters.php (see attached zip file below).

Files to edit: topposters.php (see instructions below).

Possible file locations: Anywhere, so long as the $path is set correctly.

Instructions

• Unzip the file topposters.php from topposters004.zip to your hard drive.
• Open topposters.php in an ASCII text editor, such as Notepad (Windows), SimpleText (Mac), EditPlus, UltraEdit, TextPad, etc. (DO NOT use WYSIWYG HTML editors such as FrontPage, HotDog, DreamWeaver, etc. They will in all likelyhood screw up the file! I will not be able to support you if you edit the file in one of these programs.)
• Edit the variables at the top. These are:
  ---$maxposters > This is the number of posters you want to show.
  ---$hc > Set this to the color you want the header row to be.
  ---$bc1 and $bc2 > These are the first and second alternating colors. Look at the picture in the vbulletin.com thread and you'll see what I mean.
  ---$text and $link > Set the colors of the main text and the color of the links. Make sure this color is visible on both alternating colors, set in step 3b.
  ---$font > This is the font(s) to use for display. You can set specific fonts (e.g. Verdana, Arial, etc.) or general font-families (e.g. sans-serif, serif).
  ---$fontsize > Set a point size for your font. Size 8 is about equivelant to <font size=1>. Anything below about 6 will basically be undreadable, so be careful.
  ---$url > This is the path to your board files, such as index.php, members.php, etc. This is *not* the path to config.php (e.g. don't include the /admin part of the URL)!
  ---$path > This is the path to config.php - normally in the /admin directory. Do not add a trailing slash. It may need a leading slash.
  ---$admins > If you want admins included on the list of posters, set this to 1. If you do *not* want admins included, set this to 0.
• Upload it to your website. You can include it as follows. To include it on a PHP-parsed page (.php, .php3, .phtml, etc.):
  

  <? include("topposters.php"); ?>

  To include it on a server-parsed page (.shtml, .shtm, .ssi, etc.):
  

  <!--#include file="topposters.php"-->

Instructions are included in the zip file (topposters.txt) and brief instructions are also in the topposters.php file itself.

FEEDBACK WANTED! Likes/dislikes/modification requests, please.

[tubedogg]

Try
./admin/config.php

Nope, that didn't work. I'll show you everything I have in my topposters.php file that is in my forum directory:

<?php

//..........Top X Posters v0.0.4..........\\
//......by Kevin (kevin@tubescan.com)......\\

// For vBulletin version 2, beta 3
// (c) 2001 Jelsoft Enterprises, Ltd.

// vBulletin.com thread: http://www.vbulletin.com/forum/showthread.php?threadid=12067

///////////// CHANGE LOG /////////////
//
// New in version 0.0.4
// -- Fixed alternating colors so they are horizontal, not vertical
// -- Changed $path to $url and $path2 to $path to make variables easier
// -- Added a seperate header row color
//
// New in version 0.0.3
// -- Added option to exclude admins from list of posters
//
// New in version 0.0.2
// -- Fixed a small bug with the path.
//
// New in version 0.0.1
// -- Released!
//
/////////// END CHANGE LOG ///////////

//////// CONFIG EXPLANATION //////////
//
// a] $maxposters > This is the number of posters you want to show.
// b] $hc > The head row color.
// c] $bc1 and $bc2 > These are the first and second alternating color.
// d] $text and $link > Set the colors of the main text and the color of the links. Make sure this color is visible on both alternating colors.
// e] $font > This is the font(s) to use for display. You can set specific fonts (e.g. Verdana, Arial, etc.) or general font-families (e.g. sans-serif, serif).
// f] $fontsize > Set a point size for your font. Size 8 is about equivelant to <font size=1>. Anything below about 6 will basically be undreadable, so be careful.
// g] $url > This is the URL to your board directory. This is not the path to config.php! Do not put a trailing slash, either.
// h] $path > This *is* the path to your config.php file. This should include the /admin part. NO TRAILING SLASH! (May need a leading slash)
// i] $admins > Set this to "1" to show admins on the list of top posters. Set this to "0" to NOT show admins on the list.
//
////// END CONFIG EXPLANATION ////////

/////////////// CONFIG ///////////////
//
$maxposters = "3"; // change this to the number of posters you want to show. for a top 10 listing, set it to 10, etc.
$hc = "#999999"; // change to head row color.
$bc1 = "#696969"; // change to first alternating color.
$bc2 = "#5C5C5C"; // change to second alternating color.
$text = "#FFFFFF"; // change to text color.
$link = "#EEEEEE"; // change to link color.
$font = "Verdana,Helvetica,sans-serif"; // change to fonts you want. use serif or sans-serif for general, or use specific fonts names.
$fontsize = "8pt"; // change to font size you want. 8 is about the minimum; go up from there. 1 will not even show up.
$url = "http://216.10.11.101/forum/index.php"; // path to your board files. (e.g. index.php, member.php, etc.) may need a starting slash. *do not* put an ending slash on!
$path = "./admin/config.php"; // path to your config.php file. may need a starting slash. *do not* put an ending slash on!
$admins = "0"; // change this to "0" to leave admins off the list of top posters.
//
///////////// END CONFIG /////////////

require("$path/config.php");
$db=mysql_connect($servername,$dbusername,$dbpassw ord) or die("Unable to connect to database");
mysql_select_db($dbname) or die("Unable to select database $dbname");

if ($admins == "1") {
$exq = mysql_query("SELECT usergroupid FROM usergroup WHERE cancontrolpanel='1'");
$exr = mysql_result($exq,0,0);
$exn = "WHERE usergroupid<>$exr";
}

echo("<table border=0 cellpadding=4 cellspacing=0><tr><td align=\"center\" bgcolor=\"$hc\"><b style=\"color: $text; font-family: $font; font-size: $fontsize\"><i>Username</i></b></td><td align=\"center\" bgcolor=\"$hc\"><b style=\"color: $text; font-family: $font; font-size: $fontsize\"><i>Posts</i></b></td></tr>");

$postsresult = mysql_query("SELECT username,posts,userid FROM user $exn ORDER BY posts desc LIMIT 0,$maxposters") or die("Unable to complete query");
while ($topposters = mysql_fetch_array($postsresult)):
if (($counter++ % 2) != 0) {
$bc=$bc1;
} else {
$bc=$bc2;
}
echo("<tr><td align=\"center\" bgcolor=\"$bc\" style=\"color: $text; font-family: $font; font-size: $fontsize\"><a href=\"$path/member.php?&action=getinfo&userid=$topposters[userid]\" style=\"color: $link\">$topposters[username]</a></td><td align=\"center\" bgcolor=\"$bc\" style=\"color: $text; font-family: $font; font-size: $fontsize\">$topposters[posts]</td></tr>");
endwhile;
echo("</table>");

?>

When I goto the 216.10.11.101/forum/topposters.php I get the same message:

"Fatal error: Failed opening required './admin/config.php/config.php' (include_path='.:/usr/local/lib/php') in /home/onlinega/public_html/forum/topposters.php on line 59"

I haven't included it in my main forum page yet but that's because I can't get this single topposters.php to work correctly. Have you ever encountered this error? Do you have any more ideas?

Please help?

[tubedogg]

doh sorry try just
./admin

YES IT WORKED! I love you so much!

You are the man, man!

But in all serious now, I really do appriciate the personal help you gave me there. It's working great and it's a beutiful peace of code!

I only have one last problem now, I can't seem to get it to show up on the forum pages.

I add the code into the header section in the styles menu of the admin control pannel. I place it right below the control buttons where people can log into their user cp, register, calendar, member, etc...

Any ideas?

[tubedogg]

PHP isn't parsed in any of the templates, so it won't show up if you just put it in the header template. Really I wrote this for an external (to vB) page, but it could work inside it.

In your phpinclude template, put
$topposters = implode('',file('path/to/topposters.php'));
and then put $topposters where you want the list to appear.

[floleb7]

you don't need to use this inside vb there is also the feature
http://161.58.84.213/forum/memberlis...ers&perpage=10

Has anyone set this up to run in a vBportal block? If so, would you be willing to share your method?

[Admin]

Ok, I got this error:
"Unable to select database"
So the problem is on:

PHP Code:

mysql_select_db($dbname) or die("Unable to select database $dbname"); 


The forum works fine, so the config.php is ok.

What's the problem?!

Fixed.

Okay I uploaded it and when I directly visit the page it gives me the following message -

CGI Error
The specified CGI application misbehaved by not returning a complete set of HTTP headers. The headers it did return are:



Thats all it gives



EDIT - I am very dumb lol I uploaded it to the wrong folder. The site root rather than the forum folder. Really need to get a decent FTP client rather than a web based one Nice hack. Like other hacks this requires error_reporting(7); to be added to the scirpt to get rid of those nasty error messages.