bjstats.php

<?php
//$_NO_COMPRESS = true; //== For pdq's improvements mods
ob_start("ob_gzhandler");
require_once "include/bittorrent.php";

dbconn(false);
loggedinorreturn();
global $CURUSER;

//$lang = array_merge( load_language('global') );

if ($CURUSER['class'] < UC_USER) {
    stderr("抱歉...", "你的等级必须高于USER.");
    exit;
}

function begin_table2($fullwidth = false, $padding = 5)
{
    $width = "";

    if ($fullwidth)
        $width .= " width=50%";
    return ("<table class=\"main" . $width . "\" border=\"1\" cellspacing=\"0\" cellpadding=\"" . $padding . "\">");
}

function end_table2()
{
    return ("</table>\n");
}


function begin_frame2($caption = "", $center = false, $padding = 10, $width = "100%", $caption_center = "left")
{
    $tdextra = "";

    if ($center)
        $tdextra .= " align=\"center\"";

    return (($caption ? "<h2 align=\"" . $caption_center . "\">" . $caption . "</h2>" : "") . "<table width=\"" . $width . "\" border=\"1\" cellspacing=\"0\" cellpadding=\"" . $padding . "\">" . "<tr><td class=\"text\" $tdextra>\n");

}

function end_frame2()
{
    return ("</td></tr></table>\n");
}


function bjtable($res, $frame_caption)
{
    $htmlout = '';
    $htmlout .= begin_frame2($frame_caption, true);
    $htmlout .= begin_table2();
    $htmlout .= "<tr>
        <td class='colhead'>名次</td>
        <td class='colhead' align='left'>用户名</td>
        <td class='colhead' align='right'>赢局</td>
        <td class='colhead' align='right'>输局</td>
        <td class='colhead' align='right'>总局数</td>
        <td class='colhead' align='right'>胜率</td>
        <td class='colhead' align='right'>得失</td>
        </tr>";

    $num = 0;
    while ($a = mysql_fetch_assoc($res)) {
        ++$num;
        //==Calculate Win %
        $win_perc = number_format(($a['wins'] / $a['games']) * 100, 1);
        //==Add a user's +/- statistic
        $plus_minus = 0.9 * $a['wins'] - $a['losses'];
        if ($plus_minus >= 0) {
            $plus_minus = (0.9 * $a['wins'] - $a['losses']) * 100;
        } else {
            $plus_minus = "-";
            $plus_minus .= ($a['losses'] - 0.9 * $a['wins']) * 100;
        }

        $htmlout .= "<tr><td>$num</td><td align='left'>" .
            "<b><a href='userdetails.php?id=" . $a['id'] . "'>" . get_username($a["id"]) . "</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'>" . round($plus_minus) . "</td>" .
            "</tr>\n";
    }
    $htmlout .= end_table2();
    $htmlout .= end_frame2();
    return $htmlout;
}


$cachefile = "cache/bjstats.txt";
$cachetime = 60 * 30; // 30 minutes
//$cachetime = 10 * 3;
$Cache->new_page('bjstats', $cachetime, true);
if (!$Cache->get_page()) {
    $Cache->add_whole_row();

    $mingames = 100;
    $HTMLOUT = '';
    $HTMLOUT .= "<h1>21点游戏排行榜</h1>";
    $arr = mysql_fetch_assoc(sql_query("SELECT sum(bjwins + bjlosses) AS games FROM users WHERE 1 ")) or sqlerr(__FILE__, __LINE__);
    $game = $arr['games'] / 2;
    $HTMLOUT .= "<p>排名数据每30分钟更新一次，只有游戏局数至少为${mingames}的用户才会被收入榜单。</p>截至" . date("Y-m-d H:i:s") . "，系统共进行游戏" . $game . "局。<br/>(已删除用户数据将不纳入统计，出现\"半局\"不要惊讶。)";
    $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 20") or sqlerr(__FILE__, __LINE__);
    $HTMLOUT .= bjtable($res, "游戏次数排名");
    $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 20") or sqlerr(__FILE__, __LINE__);
    $HTMLOUT .= bjtable($res, "胜率排名");
    $HTMLOUT .= "<br /><br />";
//==Highest Win %
//==Most Credit Won
    $res = sql_query("SELECT id, username, bjwins AS wins, bjlosses AS losses, bjwins + bjlosses AS games, 0.9*bjwins - bjlosses AS winnings FROM users WHERE bjwins + bjlosses >= $mingames ORDER BY winnings DESC LIMIT 20") or sqlerr(__FILE__, __LINE__);
    $HTMLOUT .= bjtable($res, "赢家排名");
    $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 - 0.9*bjwins AS losings FROM users WHERE bjwins + bjlosses >= $mingames ORDER BY losings DESC LIMIT 20") or sqlerr(__FILE__, __LINE__);
    $HTMLOUT .= bjtable($res, "输家排名");
//==Most Credit Lost
    $HTMLOUT .= "<br /><b><div align=\"center\"><a href=\"blackjack.php\">返回游戏</a></div></b>";
    $HTMLOUT .= "<br />";
    print  $HTMLOUT;


    $Cache->end_whole_row();
    $Cache->cache_page();
}


stdhead('21点游戏排行榜');
echo $Cache->next_row();
stdfoot();