// Most Games Played
$res = mysql_query("SELECT id, username, bjwins AS wins, bjlosses AS losses, bjwins + bjlosses AS games FROM users WHERE bjwins + bjlosses > {$mingames} ORDER BY games DESC LIMIT 10") or sqlerr(__FILE__, __LINE__);
bjtable($res, "<center>Most Games Played</center>", "Users");
print "<br /><br />";
// /Most Games Played
// Highest Win %
$res = mysql_query("SELECT id, username, bjwins AS wins, bjlosses AS losses, bjwins + bjlosses AS games, bjwins / (bjwins + bjlosses) AS winperc FROM users WHERE bjwins + bjlosses > {$mingames} ORDER BY winperc DESC LIMIT 10") or sqlerr(__FILE__, __LINE__);
bjtable($res, "<center>Highest Win Percentage</center>", "Users");
print "<br /><br />";
// /Highest Win %
// Most Credit Won
$res = mysql_query("SELECT id, username, bjwins AS wins, bjlosses AS losses, bjwins + bjlosses AS games, bjwins - bjlosses AS winnings FROM users WHERE bjwins + bjlosses > {$mingames} ORDER BY winnings DESC LIMIT 10") or sqlerr(__FILE__, __LINE__);
bjtable($res, "<center>Most Credit Won</center>", "Users");
print "<br /><br />";
// /Most Credit Won
// Most Credit Lost
$res = mysql_query("SELECT id, username, bjwins AS wins, bjlosses AS losses, bjwins + bjlosses AS games, bjlosses - bjwins AS losings FROM users WHERE bjwins + bjlosses > {$mingames} ORDER BY losings DESC LIMIT 10") or sqlerr(__FILE__, __LINE__);
bjtable($res, "<center>Most Credit Lost</center>", "Users");
// /Most Credit Lost
// CACHE END ////////////////////////////////////////////////////////////
// open the cache file for writing
$fp = fopen($cachefile, 'w');
// save the contents of output buffer to the file
fwrite($fp, ob_get_contents());
// close the file
fclose($fp);
// Send the output to the browser
ob_end_flush();
/////////////////////////////////////////////////////////////////////////
print "<br /><br />";
stdfoot();
}
$htmlout .= end_table();
$htmlout .= end_frame();
return $htmlout;
}
$HTMLOUT = '';
$mingames = 10;
//$HTMLOUT .="<p>Stats are cached and updated every 30 minutes. You need to play at least $mingames games to be included.</p>";
$HTMLOUT .= "<br />";
//==Most Games Played
$res = sql_query("SELECT id, username, bjwins AS wins, bjlosses AS losses, bjwins + bjlosses AS games FROM users WHERE bjwins + bjlosses > {$mingames} ORDER BY games DESC LIMIT 10") or sqlerr(__FILE__, __LINE__);
$HTMLOUT .= bjtable($res, "Most Games Played", "Users");
$HTMLOUT .= "<br /><br />";
//==Most Games Played
//==Highest Win %
$res = sql_query("SELECT id, username, bjwins AS wins, bjlosses AS losses, bjwins + bjlosses AS games, bjwins / (bjwins + bjlosses) AS winperc FROM users WHERE bjwins + bjlosses > {$mingames} ORDER BY winperc DESC LIMIT 10") or sqlerr(__FILE__, __LINE__);
$HTMLOUT .= bjtable($res, "Highest Win Percentage", "Users");
$HTMLOUT .= "<br /><br />";
//==Highest Win %
//==Most Credit Won
$res = sql_query("SELECT id, username, bjwins AS wins, bjlosses AS losses, bjwins + bjlosses AS games, bjwins - bjlosses AS winnings FROM users WHERE bjwins + bjlosses > {$mingames} ORDER BY winnings DESC LIMIT 10") or sqlerr(__FILE__, __LINE__);
$HTMLOUT .= bjtable($res, "Most Credit Won", "Users");
$HTMLOUT .= "<br /><br />";
//==Most Credit Won
//==Most Credit Lost
$res = sql_query("SELECT id, username, bjwins AS wins, bjlosses AS losses, bjwins + bjlosses AS games, bjlosses - bjwins AS losings FROM users WHERE bjwins + bjlosses > {$mingames} ORDER BY losings DESC LIMIT 10") or sqlerr(__FILE__, __LINE__);
$HTMLOUT .= bjtable($res, "Most Credit Lost", "Users");
//==Most Credit Lost
$HTMLOUT .= "<br /><br />";
// open the cache file for writing
echo stdhead('Blackjack Stats') . $HTMLOUT . stdfoot();
$plus_minus = $a['wins'] - $a['losses'];
if ($plus_minus >= 0) {
$plus_minus = mksize(($a['wins'] - $a['losses']) * 100 * 1024 * 1024);
} else {
$plus_minus = "-";
$plus_minus .= mksize(($a['losses'] - $a['wins']) * 100 * 1024 * 1024);
}
$htmlout .= "<tr><td>{$num}</td><td align='left'>" . "<b><a href='userdetails.php?id=" . (int) $a['id'] . "'>" . htmlsafechars($a['username']) . "</a></b></td>" . "<td align='right'>" . number_format($a['wins'], 0) . "</td>" . "<td align='right'>" . number_format($a['losses'], 0) . "</td>" . "<td align='right'>" . number_format($a['games'], 0) . "</td>" . "<td align='right'>{$win_perc}</td>" . "<td align='right'>{$plus_minus}</td>" . "</tr>\n";
}
$htmlout .= end_table();
$htmlout .= end_frame();
return $htmlout;
}
$HTMLOUT = '';
$mingames = 10;
$HTMLOUT .= "<br />";
$res = sql_query("SELECT id, username, bjwins AS wins, bjlosses AS losses, bjwins + bjlosses AS games FROM users WHERE bjwins + bjlosses > " . sqlesc($mingames) . " ORDER BY games DESC LIMIT 10") or sqlerr(__FILE__, __LINE__);
$HTMLOUT .= bjtable($res, "{$lang['bj_most']} {$lang['bj_games_played']}", "Users");
$HTMLOUT .= "<br /><br />";
//==Highest Win %
$res = sql_query("SELECT id, username, bjwins AS wins, bjlosses AS losses, bjwins + bjlosses AS games, bjwins / (bjwins + bjlosses) AS winperc FROM users WHERE bjwins + bjlosses > " . sqlesc($mingames) . " ORDER BY winperc DESC LIMIT 10") or sqlerr(__FILE__, __LINE__);
$HTMLOUT .= bjtable($res, "{$lang['bj_highest_win_per']}", "Users");
$HTMLOUT .= "<br /><br />";
//==Highest Win %
$res = sql_query("SELECT id, username, bjwins AS wins, bjlosses AS losses, bjwins + bjlosses AS games, bjwins - bjlosses AS winnings FROM users WHERE bjwins + bjlosses > " . sqlesc($mingames) . " ORDER BY winnings DESC LIMIT 10") or sqlerr(__FILE__, __LINE__);
$HTMLOUT .= bjtable($res, "{$lang['bj_most_credit_won']}", "Users");
$HTMLOUT .= "<br /><br />";
$res = sql_query("SELECT id, username, bjwins AS wins, bjlosses AS losses, bjwins + bjlosses AS games, bjlosses - bjwins AS losings FROM users WHERE bjwins + bjlosses > " . sqlesc($mingames) . " ORDER BY losings DESC LIMIT 10") or sqlerr(__FILE__, __LINE__);
$HTMLOUT .= bjtable($res, "{$lang['bj_most_credit_loss']}", "Users");
$HTMLOUT .= "<br /><br />";
echo stdhead($lang['bj_blackjack_stats']) . $HTMLOUT . stdfoot();