-
Notifications
You must be signed in to change notification settings - Fork 10
/
bjstats.php
82 lines (81 loc) · 4.01 KB
/
bjstats.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
<?php
/**
* ------- U-232 Codename Trinity ----------*
* ---------------------------------------------*
* -------- @authors U-232 Team --------------*
* ---------------------------------------------*
* ----- @site https://u-232.duckdns.org/ ----*
* ---------------------------------------------*
* ----- @copyright 2020 U-232 Team ----------*
* ---------------------------------------------*
* ------------ @version V6 ------------------*
*/
require_once(__DIR__.DIRECTORY_SEPARATOR.'include'.DIRECTORY_SEPARATOR.'bittorrent.php');
require_once(INCL_DIR.'user_functions.php');
require_once(INCL_DIR.'html_functions.php');
dbconn(false);
loggedinorreturn();
$lang = array_merge(load_language('global'), load_language('blackjack'));
if ($CURUSER['class'] < UC_POWER_USER) {
stderr($lang['bj_sorry'], $lang['bj_you_must_be_pu']);
exit;
}
function bjtable($res, $frame_caption)
{
global $lang, $CURUSER;
$htmlout = '';
$htmlout .= begin_frame($frame_caption, true);
$htmlout .= begin_table();
$htmlout .= "<tr>
<td class='colhead'>Rank</td>
<td class='colhead' align='left'>{$lang['bj_user']}</td>
<td class='colhead' align='right'>{$lang['bj_wins']}</td>
<td class='colhead' align='right'>{$lang['bj_losses']}</td>
<td class='colhead' align='right'>{$lang['bj_games']}</td>
<td class='colhead' align='right'>{$lang['bj_percentage']}</td>
<td class='colhead' align='right'>{$lang['bj_win_loss']}</td>
</tr>";
$num = 0;
while ($a = $res->fetch_assoc()) {
++$num;
//==Calculate Win %
$win_perc = number_format(($a['wins'] / $a['games']) * 100, 1);
//==Add a user's +/- statistic
$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")) || 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")) || 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")) || 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")) || sqlerr(__FILE__,
__LINE__);
$HTMLOUT .= bjtable($res, "{$lang['bj_most_credit_loss']}", "Users");
$HTMLOUT .= "<br><br>";
echo stdhead($lang['bj_blackjack_stats']).$HTMLOUT.stdfoot();
?>