CydandClaude Opus 4.8
7658db0641
Both now use db.php helpers with bound params: history's mission index (was injectable via $_GET[index]) and the callsign LIKE search. Loops switched to associative fetches. Verified: history shows the committed mission + players + merc count; search finds a queued callsign. Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>
76 lines
3.3 KiB
PHP
76 lines
3.3 KiB
PHP
<html>
|
|
<head>
|
|
<title>PQS - History</title>
|
|
<link href="css/main.css" rel="stylesheet" type="text/css">
|
|
</head>
|
|
<body style='background: #000;'>
|
|
<?php
|
|
|
|
require_once("includes/db.php");
|
|
|
|
$minmission = (int) pqs_val("SELECT MIN(missionid) FROM pqs_pastmissions");
|
|
$maxmission = (int) pqs_val("SELECT MAX(missionid) FROM pqs_pastmissions");
|
|
$index = $maxmission;
|
|
$fl = "";
|
|
|
|
if (isset($_GET['prev']) && isset($_GET['index'])) {
|
|
$index = (int)$_GET['index'] - 1;
|
|
if ($index < $minmission) { $index = $maxmission; }
|
|
}
|
|
if (isset($_GET['next']) && isset($_GET['index'])) {
|
|
$index = (int)$_GET['index'] + 1;
|
|
if ($index > $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 "<br><center><div class='consolehist'><table width='400' align='center'>";
|
|
}
|
|
} else {
|
|
echo "<br><center><div class='queuediv'><table width='650' align='center'>";
|
|
}
|
|
echo "<tr><td colspan='2' class='queuedisplayhead'><font size='6'>Mission #$index</font> <font size='4'>$fl</font></td></tr>";
|
|
echo "<tr><td class='queuedisplayhead' width='34%'>Callsign</td><td class='queuedisplayhead' width='34%'>Mech</td></tr>";
|
|
|
|
foreach ($rows as $line) {
|
|
echo "<tr><td class='queuedisplay'>$line[callsign]</td><td class='queuedisplay'>$line[mech]</td></tr>";
|
|
$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 "<tr><td align='center' colspan='2' class='queuedisplay'> </td>";
|
|
echo "<tr><td align='center' colspan='2' class='queuedisplay'><font color='#FEAE01'># Pods:</font> $pods | <font color='#FEAE01'># Players:</font> $numplayers | <font color='#FEAE01'># Mercs:</font> $mercs</td>";
|
|
echo "<tr><td align='center' colspan='2' class='queuedisplay'><font color='#FEAE01'>Mission Date:</font> $mdate - $mtime</td>";
|
|
echo "</table></div>";
|
|
if (isset($_GET['launch'])) {
|
|
if ($_GET['launch'] == 'console') {
|
|
echo "<table width='400' align='center'>";
|
|
}
|
|
} else {
|
|
echo "<table width='650' align='center'>";
|
|
}
|
|
echo "<tr><td align='center'><a class='queuedisplayhead' href='history.php?prev=1&index=$index'>Prev</a></td>";
|
|
echo "<td align='center'><a class='queuedisplayhead' href='#' onclick='window.close()'>Close</a></td><td align='center'><a class='queuedisplayhead' href='history.php?next=1&index=$index'>Next</a></td></tr></table>";
|
|
echo "</body></html>";
|
|
?>
|
|
|