diff options
| author | Matthijs Kuiper <info@matthijskuiper.nl> | 2017-02-04 16:05:45 +0100 |
|---|---|---|
| committer | Matthijs Kuiper <info@matthijskuiper.nl> | 2017-02-04 16:05:45 +0100 |
| commit | 40dfa7d5c0dc8e4cb2c95e403b6b4b2c4bf70644 (patch) | |
| tree | 6ac6279ac26749ffe7ca0ae9603fbcae2e757e6e /html/pages/watchlist.php | |
Original UTStats beta 4.2.84.2.8
Diffstat (limited to 'html/pages/watchlist.php')
| -rwxr-xr-x | html/pages/watchlist.php | 106 |
1 files changed, 106 insertions, 0 deletions
diff --git a/html/pages/watchlist.php b/html/pages/watchlist.php new file mode 100755 index 0000000..bfc8512 --- /dev/null +++ b/html/pages/watchlist.php @@ -0,0 +1,106 @@ +<?php
+global $s_lastvisit;
+echo'
+<table class = "box" border="0" cellpadding="1" cellspacing="2" width="720">
+ <tbody><tr>
+ <td class="heading" align="center">Your Watchlist</td>
+ </tr>
+</tbody></table>';
+echo '<br><br><br>';
+
+
+$watchlist = GetCurrentWatchlist();
+if (count($watchlist) > 25) $watchlist = array_slice($watchlist, 0, 25);
+if (count($watchlist) == 0) {
+ echo "<p class='pages'>Your watchlist is empty!<br><br>You can add players to your watchlist by clicking the appropriate icon on the header of their career summary page.</p>";
+ return;
+}
+
+echo '
+<table class="box" border="0" cellpadding="1" cellspacing="1" width="625">
+ <tbody>
+ <tr>
+ <td class="smheading" align="center" width="150">Player Name</td>
+ <td class="smheading" align="center">Last Match</td>
+ <td class="smheading" align="center">Matches</td>
+ <td class="smheading" align="center">Score</td>
+ <td class="smheading" align="center">Frags</td>
+ <td class="smheading" align="center">Kills</td>
+ <td class="smheading" align="center">Deaths</td>
+ <td class="smheading" align="center">Suicides</td>
+ <td class="smheading" align="center">Eff</td>
+ <td class="smheading" align="center">Acc</td>
+ <td class="smheading" align="center">TTL</td>
+ <td class="smheading" align="center">Hours</td>
+ </tr>';
+
+
+$i = 0;
+foreach($watchlist as $pid) {
+ $sql_players = "SELECT pi.id AS pid,
+ pi.name,
+ pi.country,
+ m.time,
+ m.id AS mid
+ FROM uts_pinfo pi,
+ uts_match m,
+ uts_player p
+ WHERE pi.id = '$pid'
+ AND p.matchid = m.id
+ AND p.pid = pi.id
+ ORDER BY m.time DESC
+ LIMIT 0,1
+ ";
+
+ $sql_pinfo = " SELECT COUNT(*) AS games,
+ SUM(p.gamescore) as gamescore,
+ SUM(p.frags) AS frags,
+ SUM(p.kills) AS kills,
+ SUM(p.deaths) AS deaths,
+ SUM(p.suicides) as suicides,
+ AVG(p.eff) AS eff,
+ AVG(p.accuracy) AS accuracy,
+ AVG(p.ttl) AS ttl,
+ SUM(gametime) as gametime
+ FROM uts_player AS p
+ WHERE p.pid = '$pid'
+ GROUP BY p.pid";
+ $r_pinfo = small_query($sql_pinfo);
+
+ $q_players = mysql_query($sql_players) or die(mysql_error());
+
+
+ while ($r_players = mysql_fetch_array($q_players)) {
+ $i++;
+ $new = (mtimestamp($r_players['time']) > $s_lastvisit) ? true : false;
+ $class = ($i % 2) ? 'grey' : 'grey2';
+ echo '<tr>';
+ echo '<td class="dark"><a class="darkhuman" href="?p=pinfo&pid='. $r_players['pid'] .'">';
+ echo FormatPlayerName($r_players['country'], $r_players['pid'], $r_players['name']);
+ echo '</a></td>';
+ echo '<td class="'.$class.'" align="center"><a class="'.$class.'" href="?p=match&mid='. $r_players['mid'] .'">';;
+ if ($new) echo "<strong>";
+ echo date("Y-m-d H:i", mtimestamp($r_players['time']));
+ if ($new) echo "</strong>";
+ echo '</a></td>';
+
+ echo '
+ <td class="'.$class.'" align="center">'.$r_pinfo['games'].'</td>
+ <td class="'.$class.'" align="center">'.$r_pinfo['gamescore'].'</td>
+ <td class="'.$class.'" align="center">'.$r_pinfo['frags'].'</td>
+ <td class="'.$class.'" align="center">'.$r_pinfo['kills'].'</td>
+ <td class="'.$class.'" align="center">'.$r_pinfo['deaths'].'</td>
+ <td class="'.$class.'" align="center">'.$r_pinfo['suicides'].'</td>
+ <td class="'.$class.'" align="center">'.get_dp($r_pinfo['eff']).'</td>
+ <td class="'.$class.'" align="center">'.get_dp($r_pinfo['accuracy']).'</td>
+ <td class="'.$class.'" align="center">'.GetMinutes($r_pinfo['ttl']).'</td>
+ <td class="'.$class.'" align="center">'.sec2hour($r_pinfo['gametime']).'</td>';
+
+ echo '</tr>';
+ }
+}
+
+echo '</tbody></table>';
+
+
+?>
|