##################################### # # # Database Statistics # # Scripting By # # Howard Fenter # # # ##################################### mysql_connect("localhost", "nobody", "oct1497") or die("Unable to connect to database."); mysql_select_db("wt_client") or die("Unable to select the database"); function count_records ($name, $querystr) {// $result = mysql_query("SELECT COUNT(1) as num FROM $querystr"); // $num = mysql_result($result,0,"num"); echo "
".$name."
".$num."
SORRY - THIS PAGE OFFLINE - JEZ - look at www.wildtangent.com/~jez/stats.phtml
DO NOT CONTINUALLY REFRESH THIS PAGE!!! IT HITS THE DB VERY HARD... I AM CURRENTLY PROGRAMMING A BETTER SOLUTION...
|
//How many years has it been since 1999
$yearspan = (date("Y")) - 1999;
//How many months has it been since 6/99
$monthspan = (date("m")) + ($yearspan * 12) - 5;
//Print All the Months
$i = 1;
while ($i <= $monthspan):
$newdate2 = mktime(0,0,0,date("m") +1 - $monthspan + $i,date("t", (date("m") - $monthspan + $i)), date("Y"));
$monthname = date("F", $newdate2) ;
print "".$monthname." "; $i++; endwhile; ?> |
By Date
Date | Downloads | New Users | Audio Visualizers |
".$i." | "; count_daily("Player_Table WHERE MONTH(date) = $month AND YEAR(date) = $year AND DAYOFMONTH(date) = $i" ); echo " | "; count_daily("User_Table WHERE MONTH(date) = $month AND YEAR(date) = $year AND DAYOFMONTH(date) = $i"); echo " | "; count_daily("Player_Table WHERE MONTH(date) = $month AND YEAR(date) = $year AND DAYOFMONTH(date) = $i AND LEFT(player_source,2) = \"AV\""); echo" |