PQS - Registration Console

query("TRUNCATE TABLE pqs_currentmission"); } if (isset($_GET['lock'])) { if (isset($_GET['missionid'])) { $missionid = (int)$_GET['missionid']; } else { $missionid = (int) pqs_val("SELECT MIN(MissionID) FROM pqs_queue"); } if ($missionid > 0) { pqs_exec("UPDATE pqs_mission SET locked=1 WHERE MissionID=?", 'i', array($missionid)); } } if (isset($_POST['edit'])) { $playerid = (int)($_POST['playerid'] ?? 0); $callsign = isset($_POST['callsign']) ? $_POST['callsign'] : ''; $mech = isset($_POST['mech']) ? $_POST['mech'] : ''; pqs_exec("UPDATE pqs_queue SET Callsign=?, mech=?, Updated=1 WHERE id=?", 'ssi', array($callsign, $mech, $playerid)); } if (isset($_POST['add'])) { // Add one player to the next N missions after $missionid (atomic). require_once("includes/queue.php"); $callsign = isset($_POST['callsign']) ? $_POST['callsign'] : ''; $mech = isset($_POST['mech']) ? $_POST['mech'] : ''; $merc = isset($_POST['merc']) ? (int)$_POST['merc'] : 0; $startmission = isset($_POST['missionid']) ? (int)$_POST['missionid'] : 0; $nummissions = isset($_POST['nummissions']) ? (int)$_POST['nummissions'] : 0; pqs_add_player_to_missions($startmission, $nummissions, $callsign, $mech, $merc); } if (isset($_POST['new'])) { // Add one player to a specific mission (atomic). require_once("includes/queue.php"); $callsign = isset($_POST['callsign']) ? $_POST['callsign'] : ''; if ($callsign === '') { $callsign = 'empty'; } $mech = isset($_POST['mech']) ? $_POST['mech'] : ''; $missionid = isset($_POST['missionid']) ? (int)$_POST['missionid'] : 0; pqs_add_player_to_mission($missionid, $callsign, $mech); } if (isset($_POST['editgame'])) { $newtype = (int)($_POST['newtype'] ?? 0); $newmap = (int)($_POST['newmap'] ?? 0); $missionid = (int)($_GET['missionid'] ?? 0); pqs_exec("UPDATE pqs_mission SET GameType=?, map=? WHERE MissionID=?", 'iii', array($newtype, $newmap, $missionid)); } if (isset($_GET['action'])) { $action = $_GET['action']; $playerid = (int)($_GET['playerid'] ?? 0); $missionid = (int)($_GET['missionid'] ?? 0); $mech = $_GET['mech'] ?? ''; $oldmap = (int)($_GET['oldmap'] ?? 0); $oldtype = (int)($_GET['oldtype'] ?? 0); $callsign = ""; $nextmission = $missionid + 1; switch ($action) { case "edit": $row = pqs_row("SELECT * FROM pqs_queue WHERE ID = ?", 'i', array($playerid)); $callsign = $row['CallSign'] ?? ''; $mech = $row['Mech'] ?? ''; echo ""; break; case "delete": pqs_remove_player($playerid); break; case "add": $row = pqs_row("SELECT * FROM pqs_queue WHERE ID = ?", 'i', array($playerid)); $callsign = str_replace("'", "'", $row['CallSign'] ?? ''); $mech = $row['Mech'] ?? ''; $merc = $row['Merc'] ?? 0; $missionid = (int)($row['MissionID'] ?? 0); echo ""; break; case "editgame": echo ""; break; } } echo ""; echo ""; echo ""; // add player form if($missionid==0){ $missionid = (int) pqs_val('SELECT MIN(MissionID) FROM pqs_queue'); } echo ""; echo "

Clear Current Queue | "; echo "Open History Window | "; echo "Lock Mission | "; echo "Back to Current Queue"; echo "

"; echo "

"; echo ""; echo ""; echo "

Back to Current

M: $missionid

CS:

"; echo "

"; // search form echo "

"; echo "

"; // create missions echo "

"; echo "

"; // search results // if(isset($_GET['search'])){ $cs = isset($_GET['callsign']) ? str_replace("'", "&;", $_GET['callsign']) : ''; if($cs == ''){$cs = 'unknown';} echo "

"; echo ""; echo ""; // get last commit time and mission id $rs2 = pqs_row("SELECT max(MissionID) AS m, max(UNIX_TIMESTAMP(ctime)) AS t FROM pqs_pastmissions"); $lastmission = (int)($rs2['m'] ?? 0); $lastCommitTime = $rs2['t'] ?? null; if(is_null($lastCommitTime)){$lastCommitTime = time();} // get time per game // $cfg = pqs_row("SELECT timepergame, timetoreset FROM pqs_gameconfig"); $tpg = (int)$cfg['timepergame'] + (int)$cfg['timetoreset']; foreach (pqs_rows("SELECT * FROM pqs_queue WHERE CallSign LIKE ? ORDER BY MissionID", 's', array($cs)) as $line) { $mtd = ($line['MissionID'] - $lastmission) * $tpg; $d=strtotime("+$mtd Minutes",$lastCommitTime); $etd = date("h:i", $d); $c = $line['CallSign']; $mid = $line['MissionID']; $pid = $line['ID']; $mch = $line['Mech']; echo ""; } echo ""; echo "

Mission(s) : $cs
CallSign	Mission	ETD	Mech	Edit/Delete
$c	$mid	$etd	$mch	"; echo " "; echo " "; echo "

"; } echo ""; ?>