1;"; //echo $query . "
"; $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); echo ""; $row = mysql_fetch_array($result); echo ""; echo ""; echo ""; $query = "SELECT * FROM minecraft.payouts WHERE player='$player';"; //echo $query . "
"; $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); $row = mysql_fetch_array($result); echo ""; echo ""; $btcaddr = $row['btcaddy']; $query = "SELECT SUM(paid) AS total_blocks, SUM(btc_paid) AS total_btc FROM minecraft.payouts_h WHERE player='$player';"; //echo $query . "
"; $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); $row = mysql_fetch_array($result); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $query = "SELECT * FROM minecraft.player_ranks WHERE player='$player';"; //echo $query . "
"; $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); $row = mysql_fetch_array($result); echo ""; echo ""; $rank = $row['rank']; if ($rank == "VIP" || $rank == "VIP+" || $rank == "Sponsor" || $rank == 'Level 2 Moderator' || $rank == 'Level 1 Moderator' || $rank == 'Level 3 Moderator' || $rank == "Admin") { echo ""; echo ""; // Doors opened: $query = "SELECT COUNT(*) AS doors FROM minecraft.hawkeye JOIN minecraft.hk_players ON hawkeye.player_id = hk_players.player_id WHERE action=11 AND player='$player';"; //echo $query . "
"; $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); $row = mysql_fetch_array($result); echo ""; echo ""; // Chests opened: $query = "SELECT COUNT(*) AS chests FROM minecraft.hawkeye JOIN minecraft.hk_players ON hawkeye.player_id = hk_players.player_id WHERE action=10 AND player='$player';"; //echo $query . "
"; $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); $row = mysql_fetch_array($result); echo ""; echo ""; // Diamonds mined: $query = "SELECT COUNT(*) AS diamonds FROM minecraft.hawkeye JOIN minecraft.hk_players ON hawkeye.player_id = hk_players.player_id WHERE action=0 AND data='56' AND player='$player';"; //echo $query . "
"; $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); $row = mysql_fetch_array($result); echo ""; echo ""; // Total verifiable playtime = COMPLEX (5 = join, 6 = quit) $query = "SELECT * FROM minecraft.hawkeye JOIN minecraft.hk_players ON hawkeye.player_id = hk_players.player_id WHERE (action=5 OR action=6) AND player='$player' ORDER BY data_id"; $result = mysql_query($query) or die ("Error in query: $query. ".mysql_error()); while ($row = mysql_fetch_array($result)) { $date = strtotime($row['date']); $type = $row['action']; if ($type == 6 && $prevtype == 5 && $date - $prevdate < 5 * 60 * 60) { //echo "
date - prevdate = ".$date - $prevdate; $playtime += $date - $prevdate; } $prevdate = $date; $prevtype = $type; } echo ""; echo ""; } echo "
".$row['player']."Player Stats
Blocks to be paid".$row['total']."
Total blocks modified".$row['blockspaid']."
Blocks paid".$row['total_blocks']."
BTC paid".$row['total_btc']."
Current BTC payout address".$btcaddr."
Rank".$row['rank']."
ADVANCED STATS
Doors opened".$row['doors']."
Chests opened".$row['chests']."
Diamonds mined".$row['diamonds']."
Verifiable playtime".round($playtime/60/60,2) ." hours
"; } else { ?>
Player:
NOTES (5/28/13):
Diamond mined = diamond ores mined. Verifiable playtime is total time between each join and corresponding disconnect event.
Server restarts do NOT record a disconnect event, so this is not a true representation of total playtime.
NOTES (5/27/13):
Total blocks modified includes blocks that may have been skipped over before you provided a BTC payout address.
Blocks unpaid should update every 15 minutes.
BTC paid only includes payouts from 5/21/13 going forward.
Stats are not 100% accurate, as at least one payout was NOT recorded properly.
Stats should be 100% accurate going forward.