Incorporation of a two hacks into the forum itself [Archive]

Zecherieh

02-01-2001, 02:03 PM

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

02-02-2001, 01:37 AM

me want! me want!

02-02-2001, 01:53 AM

Ooo Ooo me me :)

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

<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

<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

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