CydandClaude Opus 4.8
061291c951
- includes/db.php: shared mysqli connection + parameterized query helpers (pqs_db/pqs_exec/pqs_rows/pqs_row/pqs_val), targets PHP 7.4+. - Replace 11 mysql_error() calls (undefined function on PHP 7+) with mysqli_error($link) / mysqli_connect_error() across getFSgame, getFSplayers, config, callsign, console. Only affected already-failed error paths. Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>
54 lines
3.3 KiB
PHP
54 lines
3.3 KiB
PHP
<?php
|
|
// vars
|
|
$missionid=0;
|
|
$numplayers = 0;
|
|
// db setup
|
|
$link = mysqli_connect('localhost', 'pqs', 'pqs') or die('Could not connect: ' . mysqli_error($link));
|
|
mysqli_select_db($link, 'pqs') or die('Could not select database');
|
|
// get current pods
|
|
$query = 'SELECT * FROM pqs_pods';
|
|
$result = mysqli_query($link, $query) or die('Query failed: ' . mysqli_error($link));
|
|
$line = mysqli_fetch_array($result);
|
|
$pod01 = $line[0];
|
|
$pod02 = $line[1];
|
|
$pod03 = $line[2];
|
|
$pod04 = $line[3];
|
|
$pod05 = $line[4];
|
|
$pod06 = $line[5];
|
|
$pod07 = $line[6];
|
|
$pod08 = $line[7];
|
|
$pod09 = $line[8];
|
|
$pod10 = $line[9];
|
|
$pod11 = $line[10];
|
|
$pod12 = $line[11];
|
|
$pod13 = $line[12];
|
|
$pod14 = $line[13];
|
|
$pod15 = $line[14];
|
|
$pod16 = $line[15];
|
|
|
|
// locate next mission in queue
|
|
$sql = "SELECT MIN(MissionID) FROM pqs_queue";
|
|
$getid = mysqli_query($link, $sql) or die('Query failed getqueue line 20: ' . mysqli_error($link));
|
|
$rs = mysqli_fetch_array($getid);
|
|
$missionid = $rs[0];
|
|
// select callsigns and mech roster numbers
|
|
$query = "SELECT CallSign,roster,team,unit,ID FROM pqs_queue LEFT JOIN pqs_mechinfo on pqs_queue.Mech=pqs_mechinfo.MechName WHERE MissionID = $missionid ORDER by ID ASC";
|
|
$result = mysqli_query($link, $query) or die('Query failed: ' . mysqli_error($link));
|
|
if($pod01==0){echo"0,0,0,0,0\n";}else{$line = mysqli_fetch_array($result);echo"$pod01,$line[0],$line[1],$line[2],$line[3]\n";}
|
|
if($pod02==0){echo"0,0,0,0,0\n";}else{$line = mysqli_fetch_array($result);echo"$pod02,$line[0],$line[1],$line[2],$line[3]\n";}
|
|
if($pod03==0){echo"0,0,0,0,0\n";}else{$line = mysqli_fetch_array($result);echo"$pod03,$line[0],$line[1],$line[2],$line[3]\n";}
|
|
if($pod04==0){echo"0,0,0,0,0\n";}else{$line = mysqli_fetch_array($result);echo"$pod04,$line[0],$line[1],$line[2],$line[3]\n";}
|
|
if($pod05==0){echo"0,0,0,0,0\n";}else{$line = mysqli_fetch_array($result);echo"$pod05,$line[0],$line[1],$line[2],$line[3]\n";}
|
|
if($pod06==0){echo"0,0,0,0,0\n";}else{$line = mysqli_fetch_array($result);echo"$pod06,$line[0],$line[1],$line[2],$line[3]\n";}
|
|
if($pod07==0){echo"0,0,0,0,0\n";}else{$line = mysqli_fetch_array($result);echo"$pod07,$line[0],$line[1],$line[2],$line[3]\n";}
|
|
if($pod08==0){echo"0,0,0,0,0\n";}else{$line = mysqli_fetch_array($result);echo"$pod08,$line[0],$line[1],$line[2],$line[3]\n";}
|
|
if($pod09==0){echo"0,0,0,0,0\n";}else{$line = mysqli_fetch_array($result);echo"$pod09,$line[0],$line[1],$line[2],$line[3]\n";}
|
|
if($pod10==0){echo"0,0,0,0,0\n";}else{$line = mysqli_fetch_array($result);echo"$pod10,$line[0],$line[1],$line[2],$line[3]\n";}
|
|
if($pod11==0){echo"0,0,0,0,0\n";}else{$line = mysqli_fetch_array($result);echo"$pod11,$line[0],$line[1],$line[2],$line[3]\n";}
|
|
if($pod12==0){echo"0,0,0,0,0\n";}else{$line = mysqli_fetch_array($result);echo"$pod12,$line[0],$line[1],$line[2],$line[3]\n";}
|
|
if($pod13==0){echo"0,0,0,0,0\n";}else{$line = mysqli_fetch_array($result);echo"$pod13,$line[0],$line[1],$line[2],$line[3]\n";}
|
|
if($pod14==0){echo"0,0,0,0,0\n";}else{$line = mysqli_fetch_array($result);echo"$pod14,$line[0],$line[1],$line[2],$line[3]\n";}
|
|
if($pod15==0){echo"0,0,0,0,0\n";}else{$line = mysqli_fetch_array($result);echo"$pod15,$line[0],$line[1],$line[2],$line[3]\n";}
|
|
if($pod16==0){echo"0,0,0,0,0\n";}else{$line = mysqli_fetch_array($result);echo"$pod16,$line[0],$line[1],$line[2],$line[3]\n";}
|
|
|
|
mysqli_close($link);?>
|