| '.FormatPlayerName($r_multis[country], $r_multis[pid], $r_pname, $gid, $gamename).' |
', ($sql_firstblood['firstblood'] == $r_multis['pid'] ? "Yes": ""), ' |
'.$r_multis[spree_double].' |
'.$r_multis[spree_multi].' |
'.$r_multis[spree_ultra].' |
'.$r_multis[spree_monster].' |
'.$r_multis[spree_kill].' |
'.$r_multis[spree_rampage].' |
'.$r_multis[spree_dom].' |
'.$r_multis[spree_uns].' |
'.$r_multis[spree_god].' |
';
}
// No items in insta matches or lms
if ((strpos($gamename, '(insta)') === false) && (strpos($gamename, "Last Man Standing") === false) && (strpos($gamename, "iCTF") === false) && (strpos($gamename, "iTDM") === false) && (strpos($gamename, "iDM") === false) && (strpos($gamename, "iDOM") === false)) {
$anyPickups = false;
$contentTable = "";
$sql_pickups = "SELECT p.pid, pi.name, p.country, SUM(p.pu_pads) AS pu_pads, SUM(p.pu_armour) AS pu_armour, SUM(p.pu_keg) AS pu_keg,
SUM(p.pu_invis) AS pu_invis, SUM(p.pu_belt) AS pu_belt, SUM(p.pu_amp) AS pu_amp, SUM(p.pu_boots) AS pu_boots
FROM uts_player as p, uts_pinfo AS pi
WHERE p.pid = pi.id AND pi.banned <> 'Y' AND matchid = $mid
GROUP BY pid, p.country
ORDER BY name ASC";
$q_pickups = mysql_query($sql_pickups) or die(mysql_error());
$i = 0;
while ($r_pickups = zero_out(mysql_fetch_array($q_pickups))) {
$i++;
$class = ($i % 2) ? 'grey' : 'grey2';
$r_pname = $r_pickups[name];
$myurl = urlencode($r_pname);
if(!$anyPickups && ($r_pickups[pu_pads] > 0 || $r_pickups[pu_armour] > 0 || $r_pickups[pu_keg] > 0 || $r_pickups[pu_invis] > 0 || $r_pickups[pu_belt] > 0 || $r_pickups[pu_amp] > 0 || $r_pickups[pu_boots] > 0))
$anyPickups = true;
$contentTable .= '
