The Arcive of Official vBulletin Modifications Site.

About Developer · **Released**: 02-01-2001

If any one is interested I incorporated the list of top posters for the last 24 hours and the top 25 all time posters into the forum itself (in the five links template)

http://tuffsports.com/forum

If anybody wants that let me know - it is not for everyone, but if you want it I will post all the code here

#2 02-02-2001, 01:37 AM

me want! me want!

#3 02-02-2001, 01:53 AM

Ooo Ooo me me

#4 02-02-2001, 10:30 AM

Actually not much of a hack and can be done in about one minute

Copy these two filed to your text editor and upload them. Call the first one dayposters.php and the second one top25.php

dayposters.php

Code:

<body bgcolor="#ffffff">
<?
$rank=1;
require("global.php3");
echo "<center>Top Ten Last 24 Hours<br><br></center>";
$posters = $DB_site->query("SELECT user.username, COUNT(post.postid) AS cnt FROM user, post WHERE post.userid = user.userid AND post.dateline > '".(time()-3600*24)."' GROUP BY user.userid ORDER BY cnt DESC LIMIT 10");
while ($poster = $DB_site->fetch_array($posters)) {


print "<font size=3><b>$rank $poster[0] with $poster[1] posts</li>\n</font></b><br>";

$rank=($rank+1);
}
?>

top25.php

Code:

<body bgcolor="#ffffff">
<center>Top 25 Posters</center><br>
<?php 
// Set this to the max number top posters to display 
$num = 25; 
$rank = 1;

$db=mysql_connect("localhost","USERNAME","PASSWORD"); 
mysql_select_db("DATABASENAME"); 
$query = "SELECT * FROM user ORDER BY posts DESC LIMIT $num"; 
$resultlatest = mysql_query($query,$db); 
while ($latest_array = mysql_fetch_array($resultlatest)) { 
echo "<b><FONT COLOR=\"#000080\" SIZE=\"2\" FACE=\"Arial\">  $rank
$latest_array[username] </FONT><font color=#ff0000 size=1 face=arial>  with  $latest_array[posts]</font></b><BR>";
$rank = ($rank+1);
} 

?>

I just put them in the forum directory for ease of use, once you have them uploaded you can look at them as seperate pages to make sure they work (credit for the code in both of those goes elsewhere, not to me)

Then to put it on the forum in the fivelinks spot go and open up the five links template.

You have to move the links that are in there somewhere - like I did by moving them to the top of the forum. To put them their just cut and paste what is in the five links to the header and remove the one "break" that is in there.

Once you have five links empty just put this code in there

Code:

<iframe src="dayposters.php3" width=200 height=78 name=framea></iframe>
<iframe src="top25.php3" width=210 height=78 name=frameb></iframe>

Once that is in you are done

Note - Netscape does not support iframe and a Netscape user will just see blank space in its place, I have looked and it looks ok on Netscape.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.03439 seconds Memory Usage 2,216KB Queries Executed 17 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (3)bbcode_code (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (4)post_thanks_box (4)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (4)post_thanks_postbit_info (3)postbit (4)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!