my_stats.php

<?php
//    Improved Stats written by Tom Lightspeed (tomlightspeed@gmail.com + http://facebook.com/tomlightspeed)
//    Developed Socially for http://ozco.in
//    If you liked my work, want changes/etc please contact me or donate 16p56JHwLna29dFhTRcTAurj4Zc2eScxTD.
//    Special thanks to WAYNO, GRAET & YCROS from #ozcoin on freenode.net for their help :-)
//    May the force be with you.

$pageTitle = "- My Stats";
include ("includes/header.php");

//DELETE
error_reporting(E_ALL);
ini_set('display_errors', '1');

echo "<div id=\"stats_wrap\">";

if( !$cookieValid ){
	echo "<div id=\"new_user_message\"><p>Welcome to <a href=\"/\">Simplecoin.us</a>! Please login or <a href=\"register.php\">join us</a> to get detailed stats and graphs relating to your hashing!</p></div>";
}
else
{
	// SHOW USER TOTAL PAID  *************************************************************************************************************************

	echo "<table class=\"money_table server_width\">";
	echo "<tr><th scope=\"col\" colspan=\"2\">Total BTC Earned</th></tr><tr class=\"moneyheader\"><td class=\"bitcoin_image\"><img class=\"earned_coin\" src=\"/images/bitcoin.png\" /></td><td class=\"bitcoins\">";

	$result = mysql_query_cache("SELECT paid + balance as amount_earned  FROM accountBalance WHERE userid = $userInfo->id");
	if ($resultrow = $result[0]) {
		echo $resultrow->amount_earned;
	}

	echo "</td></tr></table>";

	// USER HASHRATE LAST HOUR/TIME GRAPH *************************************************************************************************************************
	// http://www.filamentgroup.com/lab/update_to_jquery_visualize_accessible_charts_with_html5_from_designing_with/
	// table is hidden, graph follows

//	echo "<table id=\"user_hashrate_lasthour\" class=\"hide\">";
//	echo "<caption>" . $userInfo->username . "'s Hashrate over the Last Hour</caption>";
//	echo "<thead><tr><td></td>";
//
//	$query = "SELECT DISTINCT DATE_FORMAT(timestamp, '%h:%i') as time, hashrate FROM userHashrates WHERE timestamp > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 HOUR) AND userId = $userInfo->id";
//	$result = mysql_query($query);
//
//	while($resultrow = mysql_fetch_object($result)) {
//		echo "<th scope=\"col\">" . $resultrow->time . "</th>";
//	}
//
//	echo "</thead><tbody><tr><th scope=\"row\">" . $userInfo->username . "'s Hashrate</th>";
//
//	// re-iterate through results
//	if (mysql_num_rows($result) > 0)
//		mysql_data_seek($result, 0);
//
//	while($resultrow = mysql_fetch_object($result)) {
//		echo "<td>" . $resultrow->hashrate . "</td>";
//	}
//
//	echo "</tbody></table>";

	//echo "</div><div class=\"clear\"></div><div id=\"stats_wrap_3\" class=\"top_spacing\">";

	// USER HASHRATE LAST 24 HOURS/TIME GRAPH *************************************************************************************************************************
	// http://www.filamentgroup.com/lab/update_to_jquery_visualize_accessible_charts_with_html5_from_designing_with/
	// table is hidden, graph follows

	echo "<table id=\"user_hashrate_last24\" class=\"hide\">";
	echo "<caption>" . $userInfo->username . "'s Hashrate over the Last 24 Hours</caption>";
	echo "<thead><tr><td></td>";

	$query = "SELECT DATE_FORMAT(timestamp, '%l:%i') as time, hashrate FROM userHashrates WHERE timestamp > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 24 HOUR) AND userId = $userInfo->id";
	$query .= " GROUP BY EXTRACT(DAY FROM timestamp), EXTRACT(HOUR FROM timestamp)";

	$result = mysql_query_cache($query);
	
	foreach ($result as $resultrow) {
		echo "<th scope=\"col\">" . $resultrow->time . "</th>";
	}

	echo "</thead><tbody><tr><th scope=\"row\">".$userInfo->username."'s Hashrate</th>";

	// re-iterate through results
	//if (mysql_num_rows($result) > 0)
	//	mysql_data_seek($result, 0);

	foreach ($result as $resultrow) {
		echo "<td>".$resultrow->hashrate."</td>";
	}

	echo "</tbody></table>";

	//echo "</div><div class=\"clear\"></div><div id=\"stats_wrap_4\" class=\"top_spacing\">";

	// USER HASHRATE OVER LAST MONTH GRAPH *************************************************************************************************************************
	// http://www.filamentgroup.com/lab/update_to_jquery_visualize_accessible_charts_with_html5_from_designing_with/
	// table is hidden, graph follows

	echo "<table id=\"user_hashrate_lastmonth\" class=\"hide\">";
	echo "<caption>" . $userInfo->username . "'s Hashrate over the Last Month</caption>";
	echo "<thead><tr><td></td>";

	$query = "SELECT DATE_FORMAT(timestamp, '%b %e') as day, hashrate FROM userHashrates WHERE timestamp > DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 MONTH) AND userId = " . $userInfo->id;
	$query .= " GROUP BY EXTRACT(MONTH FROM timestamp), EXTRACT(DAY FROM timestamp)";

	$result = mysql_query_cache($query);

	foreach ($result as $resultrow) {
		echo "<th scope=\"col\">" . $resultrow->day . "</th>";
	}

	echo "</thead><tbody><tr><th scope=\"row\">" . $userInfo->username . "'s Hashrate</th>";

	// re-iterate through results
	//if (mysql_num_rows($result) > 0)
	//	mysql_data_seek($result, 0);

	foreach ($result as $resultrow) {
		echo "<td>" . $resultrow->hashrate . "</td>";
	}

	echo "</tbody></table>";

	//echo "</div><div class=\"clear\"></div><div id=\"stats_wrap_5\" class=\"top_spacing\">";
}

echo "<div class=\"clear\"></div></div>";

include("includes/footer.php");

?>