| Your Watchlist |
|
|
';
return;
}
echo '
| Player Name |
Last Match |
Matches |
Score |
Frags |
Kills |
Deaths |
Suicides |
Eff |
Acc |
TTL |
Hours |
';
$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 '';
echo '| ';
echo FormatPlayerName($r_players['country'], $r_players['pid'], $r_players['name']);
echo ' | ';
echo '';;
if ($new) echo "";
echo date("Y-m-d H:i", mtimestamp($r_players['time']));
if ($new) echo "";
echo '
|
'.$r_pinfo['games'].' |
'.$r_pinfo['gamescore'].' |
'.$r_pinfo['frags'].' |
'.$r_pinfo['kills'].' |
'.$r_pinfo['deaths'].' |
'.$r_pinfo['suicides'].' |
'.get_dp($r_pinfo['eff']).' |
'.get_dp($r_pinfo['accuracy']).' |
'.GetMinutes($r_pinfo['ttl']).' |
'.sec2hour($r_pinfo['gametime']).' |
';
}
}
echo '';
?>