From 3a58cb2802c8be14f78015105afe759b1c7ce692 Mon Sep 17 00:00:00 2001 From: Matthijs Kuiper Date: Tue, 9 Jan 2018 00:43:43 +0100 Subject: Implement design for pages and update includes --- html/pages/match_info_other.php | 206 +++++++++++++++++++++------------------- 1 file changed, 110 insertions(+), 96 deletions(-) (limited to 'html/pages/match_info_other.php') diff --git a/html/pages/match_info_other.php b/html/pages/match_info_other.php index 21dfca4..7f9cf18 100755 --- a/html/pages/match_info_other.php +++ b/html/pages/match_info_other.php @@ -1,124 +1,138 @@ - - - - +echo '
+
Special Events
+ - - - - + + + + + + + - - - - - - - - - + + + + + + + + + '; $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, p.country -ORDER BY name ASC"; + 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, p.country + 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); + $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'
PlayerFirst BloodMultisSpreesSpecial Events
First BloodMultisSprees
DblMultiUltraMonsKillRamDomUnsGodDblMultiUltraMonsKillRamDomUnsGod
'.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].'
'.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, p.country - ORDER BY name ASC"; +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; - $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' - - - - - - - - - '; - } + 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 .= ' + + + + + + + + + + '; + } + + if ($anyPickups) { + echo '
Pickups Summary
PlayerPadsArmourKegInvisibilityShield
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].'
'.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].''.$r_pickups[pu_boots].'

+ + + + + + + + + + + + + + '; + + echo $contentTable; + } } + echo'
Pickups Summary
PadsArmourKegInvisibilityShield
Belt		Damage AmpAntigrav Boots
'; -/* $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); +/* +// To add when forum widget is available + +echo ' +
+ +
'; +*/ -echo' -
- - - - - - - - -
First Blood
'.FormatPlayerName($sql_firstblood[country], $sql_firstblood[firstblood], $sql_firstblood[name], $gid, $gamename).'
'; */ ?> -- cgit