vb.org Archive - Incorporation of a two hacks into the forum itself

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.01152 seconds Memory Usage 1,718KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (4)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: