'; $sql_firstblood = small_query("SELECT firstblood FROM uts_match WHERE id = $mid"); $sql_multis = "SELECT p.pid, pi.name, p.country, SUM(spree_double) AS spree_double, SUM(spree_multi) AS spree_multi, SUM(spree_ultra) AS spree_ultra, SUM(spree_monster) AS spree_monster, SUM(spree_kill) AS spree_kill, SUM(spree_rampage) AS spree_rampage, SUM(spree_dom) AS spree_dom, SUM(spree_uns) AS spree_uns, SUM(spree_god) AS spree_god FROM uts_player as p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND matchid = $mid GROUP BY pid ORDER BY name ASC"; $q_multis = mysql_query($sql_multis) or die(mysql_error()); $i = 0; while ($r_multis = zero_out(mysql_fetch_array($q_multis))) { $i++; $class = ($i % 2) ? 'grey' : 'grey2'; $r_pname = $r_multis[name]; $myurl = urlencode($r_pname); echo' '; } // No items in insta matches or lms if ((strpos($gamename, '(insta)') === false) && (strpos($gamename, "Last Man Standing") === false)) { echo'

Special Events
Player	First Blood	Multis				Sprees
		Dbl	Multi	Ultra	Mons	Kill	Ram	Dom	Uns	God
'.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].'

'; $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 FROM uts_player as p, uts_pinfo AS pi WHERE p.pid = pi.id AND pi.banned <> 'Y' AND matchid = $mid GROUP BY pid 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); echo' '; } } echo'

Pickups Summary
Player	Pads	Armour	Keg	Invisibility	Shield Belt	Damage Amp
'.FormatPlayerName($r_pickups[country], $r_pickups[pid], $r_pname, $gid, $gamename).'	'.$r_pickups[pu_pads].'	'.$r_pickups[pu_armour].'	'.$r_pickups[pu_keg].'	'.$r_pickups[pu_invis].'	'.$r_pickups[pu_belt].'	'.$r_pickups[pu_amp].'

'; /* $sql_firstblood = small_query("SELECT pi.name, pi.country, m.firstblood FROM uts_match AS m, uts_pinfo AS pi WHERE m.firstblood = pi.id AND m.id = $mid"); if (!$sql_firstblood) $sql_firstblood = array('country' => '', 'name' => '(unknown)', 'firstblood' => NULL); echo'

First Blood

'.FormatPlayerName($sql_firstblood[country], $sql_firstblood[firstblood], $sql_firstblood[name], $gid, $gamename).'

'; */ ?>