$maxmission) { $index = $minmission; } } if ($index == $maxmission) { $fl = "(Last Mission)"; } if ($index == $minmission) { $fl = "(First Mission)"; } $rows = pqs_rows("SELECT callsign, mech, pqs_pastmissions.missionid, missiondate, nummercs, missionsize, numplayers, missiontime FROM pqs_pastmissions inner join pqs_mission where pqs_pastmissions.missionid = pqs_mission.missionid HAVING pqs_pastmissions.missionid = ?", 'i', array($index)); if (isset($_GET['launch'])) { if ($_GET['launch'] == 'console') { echo "
"; } } else { echo "
"; } echo "
Mission #$index
$fl
"; echo "
Callsign
Mech
"; foreach ($rows as $line) { echo "
$line[callsign]
$line[mech]
"; $cfull = $line['missiondate']; $cyear = substr($cfull,0,4); $cmonth = substr($cfull,4,2); $cday = substr($cfull,6); $mdate = date("l, F jS, o", mktime(0,0,0, $cmonth,$cday,$cyear)); $mercs = $line['nummercs']; $pods = $line['missionsize']; $numplayers = $line['numplayers']; if (strlen($line['missiontime']) == 3) { $mtime = substr($line['missiontime'], 0, 1); $mtime = $mtime . ":"; $mtime = $mtime . (substr($line['missiontime'], 1,2)); } else { $mtime = substr($line['missiontime'], 0, 2); $mtime = $mtime . ":"; $mtime = $mtime . (substr($line['missiontime'], 2,2)); } } echo "
"; echo "
# Pods:
$pods |
# Players:
$numplayers |
# Mercs:
$mercs
"; echo "
Mission Date:
$mdate - $mtime
"; echo "
"; if (isset($_GET['launch'])) { if ($_GET['launch'] == 'console') { echo "
"; } } else { echo "
"; } echo "
Prev
"; echo "
Close
Next
"; echo "