CydandClaude Opus 4.8
b6e6feca32
The pod query result was never fetched, so $pod01..16 (and their $_SESSION copies) read a stale row - silent on PHP 5, noisy warnings on PHP 8. Add the missing mysqli_fetch_array. Behavior otherwise unchanged. Co-Authored-By: Claude Opus 4.8 <noreply@anthropic.com>
55 lines
1.7 KiB
PHP
55 lines
1.7 KiB
PHP
<?php
|
|
|
|
$link = mysqli_connect('localhost', 'pqs', 'pqs') or die('Could not connect: ' . mysqli_connect_error());
|
|
mysqli_select_db($link, 'pqs') or die('Could not select database');
|
|
$query = 'SELECT * FROM pqs_gameconfig';
|
|
$result = mysqli_query($link, $query) or die('Query failed: ' . mysqli_error($link));
|
|
while ($line = mysqli_fetch_array($result)) {
|
|
$numpods[$line[0]] = $line[1];
|
|
$timepergame[$line[0]] = $line[2];
|
|
$timetoreset[$line[0]] = $line[3];
|
|
$groupAvalible[$line[0]] = $line[23];
|
|
}
|
|
$query = 'SELECT * FROM pqs_pods';
|
|
$result = mysqli_query($link, $query) or die('Query failed: ' . mysqli_error($link));
|
|
$line = mysqli_fetch_array($result); // was missing: pod vars below read a stale row
|
|
$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];
|
|
|
|
mysqli_free_result($result);
|
|
mysqli_close($link);
|
|
$_SESSION['mechpods'] = $numpods[1];
|
|
$_SESSION['timepergame'] = $timepergame[1];
|
|
$_SESSION['timetoreset'] = $timetoreset[1];
|
|
$_SESSION['pod01'] = $pod01;
|
|
$_SESSION['pod02'] = $pod02;
|
|
$_SESSION['pod03'] = $pod03;
|
|
$_SESSION['pod04'] = $pod04;
|
|
$_SESSION['pod05'] = $pod05;
|
|
$_SESSION['pod06'] = $pod06;
|
|
$_SESSION['pod07'] = $pod07;
|
|
$_SESSION['pod08'] = $pod08;
|
|
$_SESSION['pod09'] = $pod09;
|
|
$_SESSION['pod10'] = $pod10;
|
|
$_SESSION['pod11'] = $pod11;
|
|
$_SESSION['pod12'] = $pod12;
|
|
$_SESSION['pod13'] = $pod13;
|
|
$_SESSION['pod14'] = $pod14;
|
|
$_SESSION['pod15'] = $pod15;
|
|
$_SESSION['pod16'] = $pod16;
|
|
$_SESSION['groupAvalible'] = $groupAvalible[1];
|
|
?>
|