forked from opencaching/opencaching-pl
-
Notifications
You must be signed in to change notification settings - Fork 0
/
t_solved.php
70 lines (57 loc) · 2.53 KB
/
t_solved.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
<?php
global $lang, $rootpath;
if (!isset($rootpath))
$rootpath = './';
//include template handling
require_once($rootpath . 'lib/common.inc.php');
setlocale(LC_TIME, 'pl_SE.UTF-8');
$rsU = sql('SELECT COUNT(*) `count` FROM (SELECT COUNT(cache_logs.user_id) FROM `cache_logs` WHERE type=9 AND `deleted`=0 AND `hidden`=0 GROUP BY `user_id`) `users_with_founds`');
$fC = sql('SELECT COUNT(*) `count` FROM `cache_logs` WHERE type=9 AND `deleted`=0 AND `hidden`=0');
$rsUs = mysql_fetch_array($rsU);
$fCt = mysql_fetch_array($fC);
echo '<center><table width="97%" border="0"><tr><td align="center"><center><b>' . tr('ranking_by_number_of_solved') . '</b><br />' . tr('number_of_users_who_has_solved') . ':';
echo $rsUs[count];
echo ' .::. ' . tr('number_of_solved') . ':';
echo $fCt[count];
echo '</center></td></tr>';
echo '</table>';
echo '<table border="1" bgcolor="white" width="97%" style="font-size:11px; line-height:1.6em;">' . "\n";
$a = "SELECT COUNT(*) count, username, stat_ban, user.user_id FROM cache_logs, user " .
"WHERE `cache_logs`.`deleted`=0 AND `cache_logs`.`hidden`=0 AND cache_logs.user_id=user.user_id AND cache_logs.type=9 " .
"GROUP BY user.user_id " .
"ORDER BY 1 DESC, user.username ASC";
echo "<br />";
$r = mysql_query($a) or die(mysql_error());
echo '<tr class="bgcolor2">' .
'<td align="center"> <b>' . tr('ranking') . '</b> </td>' .
'<td align="center"><b>' . tr('number_of_solved') . '</b></td>' .
'<td align="center"> <b>' . tr('username') . '</b> </td></tr><tr><td>';
$l2 = ""; // number of users within the same rank
$position = 1; // position ex aequo; incremented by number of users in each rank
while ($line = mysql_fetch_array($r)) {
$color = "black";
$banned = "";
if ($usr['admin'] || $line['stat_ban'] == 0) {
if ($line['stat_ban']) {
$color = "gray";
$banned = " (BAN)";
}
$l1 = $line[count];
if ($l2 != $l1) {
echo '</td></tr>';
echo '<tr class="bgcolor2">' .
'<td align="right"> <b>' . $position . '</b> </td>' .
'<td align="right"> <b>' . $l1 . '</b> </td>' .
'<td>';
$l2 = $l1;
} else {
echo ', ';
}
echo '<a style="color:' . $color . '" href="viewprofile.php?userid=' . $line[user_id] . '">' . htmlspecialchars($line[username]) . $banned . '</a>';
$position++;
}
}
// end table
//echo "</td></tr>";
echo "</table>\n";
?>