Thank you!
fetch-right.php and fetch-plan.php as well please.
It’s complaining about mysqli which is how php connects to the database.
fetch-right.php
<?php
session_start();
ob_start();
include('functions/config/config.php');
$user = DB_USER;
$password = DB_PASS;
$dbname = DB_NAME;
$servername = DB_HOST;
$navdbname = "kermou5_nav";
if (!isset($_SESSION['username'])) {
header('Location: ' . DOMAIN . '/login.php');
exit;
} else {
}
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $user, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
// Check if User has not been manually logged out.
try {
$stmt = $conn->prepare('SELECT * FROM credentials WHERE discordID = :discordID AND logged = :logged');
$stmt->bindParam('discordID', $_SESSION['discordID'], PDO::PARAM_STR);
$stmt->execute(
array(
'discordID' => $_SESSION['discordID'],
'logged' => 'Yes'
)
);
$count = $stmt->rowCount();
if ($count > 0) {
} else {
header('Location: ' . DOMAIN . '/logout.php');
}
} catch (PDOException $e) {
echo 'Error: ' . $e->getMessage();
}
$conn2 = mysqli_connect($servername, $user, $password, $dbname);
if (!$conn2) {
die("Connection failed: " . mysqli_connect_error());
}
$conn_nav = mysqli_connect($servername, $user, $password, $navdbname);
if (!$conn_nav) {
die('Connection failed: ' . mysqli_connect_error());
}
// Enable Tooltips
?>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous">
</script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous">
</script>
<!-- Tooltips-->
<script>
$(document).ready(function() {
$('.tooltip').remove();
$('[data-toggle="tip"]').tooltip('enable');
});
</script>
<?php if (!isset($_SESSION['supuser'])) { ?>
<!-- Live Edit Snippet -->
<script type="text/javascript">
$(document).ready(function() {
// Add Class
$('.edit').click(function(e) {
e.preventDefault();
$(this).addClass('editMode');
});
// Save data
$(".edit").focusout(function(e) {
e.preventDefault();
$(this).removeClass("editMode");
var id = this.id;
var split_id = id.split("/");
var field_name = split_id[0];
var edit_id = split_id[1];
var value = $(this).text();
jQuery.ajax({
type: 'POST',
url: 'update.php',
data: {
field: field_name,
value: value,
id: edit_id,
},
dataType: "text",
success: function(data) {
location.reload();
},
error(data) {
alert("Error");
}
});
});
});
</script>
<?php } ?>
<?php
// END
$result2 = ("SELECT * FROM inputflightstrips WHERE CB='$_SESSION[username]' OR CB='$_SESSION[supuser]' ORDER BY position_order");
// selecting data through mysql_query()
$count2 = mysqli_query($conn2, $result2);
while ($data2 = mysqli_fetch_array($count2)) {
// Setting Variables for Easy Use
$id = strip_tags($data2['id']);
// Airline Mini-Translator
$callsign = $data2['Callsign'];
$cleaned = $callsign[0] . $callsign[1] . $callsign[2];
// Label/Color Translator
if ($data2['Arrival'] === $data2['Departure'] && $data2['Departure'] === $_SESSION['airport']) {
$tag = "Locally Controlled";
$color = "#013220";
$class = 'table table-bordered';
} else if ($data2['Arrival'] !== $data2['Departure'] && $data2['Departure'] === $_SESSION['airport']) {
$tag = "Departure";
$color = "#170132";
$class = 'table table-bordered';
} else if ($data2['Departure'] !== $_SESSION['airport'] && $data2['Arrival'] !== $_SESSION['airport']) {
$tag = "Overflight";
$color = "#321701";
$class = 'table table-bordered';
} else if ($data2['Arrival'] !== $data2['Departure'] && $data2['Arrival'] === $_SESSION['airport']) {
$tag = "Arrival";
$color = "#320801";
$class = 'table table-bordered';
}
if ($data2['Header'] != '') {
$tag = "Header";
$color = "#101010";
$class = 'table';
}
// Label/Color Translator END
// Setting Table
echo "<table id='item-" . $data2['id'] . "' class='" . $class . "' style='margin-bottom: 15px; background-color: $color; margin-right: 12px;'>";
echo "<tbody>";
if ($data2['Header'] == '') {
// First Row
echo "<tr style='padding: 1px; min-height: 20px;'>";
// Airline ICAO Lookup in Navigation Database START
$result_count = ("SELECT COUNT(*) AS 'total' FROM airlines WHERE icao='$cleaned' OR iata='$cleaned' LIMIT 1");
$count_count = mysqli_query($conn_nav, $result_count);
while ($data_count = mysqli_fetch_array($count_count)) {
if ($data_count['total'] > 0) {
$result_airlines = ("SELECT * FROM airlines WHERE icao='$cleaned' OR iata='$cleaned' LIMIT 1");
$count_airlines = mysqli_query($conn_nav, $result_airlines);
while ($data_airlines = mysqli_fetch_array($count_airlines)) {
echo "<td width='170' data-toggle='tip' data-placement='top' title='" . strtoupper($data_airlines['callsign']) . "'><div contentEditable='true' class='edit' maxlength='8' id='Callsign/$id'>" . $data2['Callsign'] . '</div></td>';
}
} else {
echo "<td width='170' data-toggle='tip' data-placement='top' title='Unknown'><div contentEditable='true' class='edit' maxlength='8' id='Callsign/$id'>" . $data2['Callsign'] . '</div></td>';
}
}
// Airline ICAO Lookup in Navigation Database END
echo "<td width='100' data-toggle='tip' data-placement='top' title='Squawk Code'>" . $data2['Squawk'] . " <a href='functions/randomsquawk.php?id=" . $data2['id'] . '&flight_rules=' . $data2['Flight_Rules'] . "'><span class='badge badge-dark'>R</span></a> <a href='functions/randomsquawk.php?id=" . $data2['id'] . '&flight_rules=' . $data2['Flight_Rules'] . "&v=Yes'><span class='badge badge-dark'>V</span></a> <a data-target='#squawkModal' data-toggle='modal' data-id='" . $data2['id'] . "' data-squawk='" . $data2['Squawk'] . "'><span class='badge badge-dark'>E</span></a></td>";
// Departure Airfield ICAO Lookup in Navigation Database
$result_dep_icao = ("SELECT * FROM airports WHERE icao='$data2[Departure]' OR iata='$data2[Departure]' LIMIT 1");
$count_dep_icao = mysqli_query($conn_nav, $result_dep_icao);
while ($data_dep_icao = mysqli_fetch_array($count_dep_icao)) {
echo "<td width='100' data-toggle='tip' data-placement='top' title='" . $data_dep_icao['name'] . "'><div contentEditable='true' id='Departure/$id' class='edit' maxlength='4'>" . $data2['Departure'] . '</div></td>';
}
echo "<td width='390' rowspan='2' data-toggle='tip' data-placement='top' title='Route' style='max-width: 390px; font-size: 13px;'>
<div contentEditable='true' id='Routes/$id' class='edit' maxlength='275'>" . $data2['Routes'] . "</div>
<a href='https://skyvector.com/?fpl=" . $data2['Departure'] . "%20" . $data2['Routes'] . "%20" . $data2['Arrival'] . "' target='_blank'><span class='badge badge-dark'>View</span></a>
</td>";
// Annotations 1/2/3
echo '<td width="70" style="font-size: 13px; max-width: 70px;" data-toggle="tip" data-placement="top" title="Departure Runway"><div class="dropdown"><button class="btn btn-outline-light btn-sm dropdown-toggle" style="max-width: 70px;" type="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
' . $data2['annotation_1'] . '
</button>
<div class="dropdown-menu" aria-labelledby="dropdownMenuButton">';
$result_dep = ("SELECT * FROM runways WHERE airport_ident='$data2[Departure]' AND (he_ident!='$data2[annotation_1]' OR le_ident!='$data2[annotation_1]')");
$count_dep = mysqli_query($conn_nav, $result_dep);
while ($data_dep = mysqli_fetch_array($count_dep)) {
echo '<a class="dropdown-item" href="functions/annotate.php?id=' . $id . '&annotate=1&value=' . $data_dep['he_ident'] . '">' . $data_dep['he_ident'] . '</a>';
echo '<a class="dropdown-item" href="functions/annotate.php?id=' . $id . '&annotate=1&value=' . $data_dep['le_ident'] . '">' . $data_dep['le_ident'] . '</a>';
}
echo '</div></div></td>';
echo '<td width="70" style="font-size: 13px; max-width: 70px;" data-toggle="tip" data-placement="top" title="Clearance Given"><div class="dropdown"><button class="btn btn-outline-light btn-sm dropdown-toggle" style="max-width: 70px;" type="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
' . $data2['annotation_2'] . '
</button>
<div class="dropdown-menu" aria-labelledby="dropdownMenuButton">';
if ($data2['annotation_2'] == "YES") {
echo '<a class="dropdown-item" href="functions/annotate.php?id=' . $id . '&annotate=2&value=NO">No</a>';
} else {
echo '<a class="dropdown-item" href="functions/annotate.php?id=' . $id . '&annotate=2&value=YES">Yes</a>';
}
echo '</div></div></td>';
echo "<td width='70' style='font-size: 13px; max-width: 70px;'' data-toggle='tip' data-placement='top' title='Departure Heading'><div contentEditable='true' id='annotation_3/$id' class='edit' maxlength='6'>" . $data2['annotation_3'] . '</div></td>';
echo '</tr>';
// closing table row
echo "<tr style='padding: 1px; min-height: 20px;'>";
// Aircraft ICAO Lookup in Navigation Database
$result_ac_icao = ("SELECT * FROM aircraft WHERE icao='$data2[Aircraft]' OR iata='$data2[Aircraft]' LIMIT 1");
$count_ac_icao = mysqli_query($conn_nav, $result_ac_icao);
while ($data_ac_icao = mysqli_fetch_array($count_ac_icao)) {
echo "<td width='100' data-toggle='tip' data-placement='top' data-html='true' title='<b>Model Name:</b> " . $data_ac_icao['name'] . "<br><hr><b>Manufacturer:</b> " . $data_ac_icao['ManufacturerCode'] . "<br><b>Engine Type:</b> " . $data_ac_icao['EngineType'] . "<br><b>Classification:</b> " . $data_ac_icao['WTC'] . "'><div contentEditable='true' id='Aircraft/$id' class='edit' maxlength='4'>" . $data2['Aircraft'] . '</div></td>';
}
echo "<td width='100' data-toggle='tip' data-placement='top' title='Temporary Altitude'><div contentEditable='true' id='TempAltitude/$id' class='edit' maxlength='8'>" . $data2['TempAltitude'] . '</div></td>';
// Arrival Airfield ICAO Lookup in Navigation Database
$result_arr_icao = ("SELECT * FROM airports WHERE icao='$data2[Arrival]' OR iata='$data2[Arrival]' LIMIT 1");
$count_arr_icao = mysqli_query($conn_nav, $result_arr_icao);
while ($data_arr_icao = mysqli_fetch_array($count_arr_icao)) {
echo "<td width='100' data-toggle='tip' data-placement='top' title='" . $data_arr_icao['name'] . "'><div contentEditable='true' id='Arrival/$id' class='edit' maxlength='4'>" . $data2['Arrival'] . '</div></td>';
}
echo '<td width="70" data-toggle="tip" data-placement="top" title="Move Strip" class="handle" style="text-align: center;">☰☰</td>';
echo "<td width='70'><a class='link' href='?a=" . $data2['Departure'] . "' style='font-size: 12px;'>" . $data2['Departure'] . " PROC</a></td>";
echo "<td width='70'><a class='link' href='?a=" . $data2['Departure'] . "' id='procButton' style='font-size: 12px;'>" . $data2['Arrival'] . " PROC</a></td>";
echo '</tr>';
// closing table row
echo "<tr style='padding: 1px; min-height: 20px;'>";
echo '<td width="100" style="font-size: 13px; max-width: 70px;" data-toggle="tip" data-placement="top" title="Flight Rules"><div class="dropdown"><button class="btn btn-outline-light btn-sm dropdown-toggle" style="max-width: 100px;" type="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
' . $data2['Flight_Rules'] . '
</button>
<div class="dropdown-menu" aria-labelledby="dropdownMenuButton">';
if ($data2['Flight_Rules'] == "VFR") {
echo '<a class="dropdown-item" href="functions/annotate.php?id=' . $id . '&annotate=FR&value=IFR">IFR</a>';
echo '<a class="dropdown-item" href="functions/annotate.php?id=' . $id . '&annotate=FR&value=SVFR">SVFR</a>';
}
if ($data2['Flight_Rules'] == "SVFR") {
echo '<a class="dropdown-item" href="functions/annotate.php?id=' . $id . '&annotate=FR&value=IFR">IFR</a>';
echo '<a class="dropdown-item" href="functions/annotate.php?id=' . $id . '&annotate=FR&value=VFR">VFR</a>';
}
if ($data2['Flight_Rules'] == "IFR") {
echo '<a class="dropdown-item" href="functions/annotate.php?id=' . $id . '&annotate=FR&value=VFR">VFR</a>';
echo '<a class="dropdown-item" href="functions/annotate.php?id=' . $id . '&annotate=FR&value=SVFR">SVFR</a>';
}
echo '</div></div></td>';
echo "<td width='100' data-toggle='tip' data-placement='top' title='Altitude Clearance'><div contentEditable='true' id='Altitude/$id' class='edit' maxlength='8'>" . $data2['Altitude'] . '</div></td>';
echo "<td width='100' data-toggle='tip' data-placement='top' title='Scratchpad'><div contentEditable='true' id='scratchpad/$id' class='edit' maxlength='5'>" . $data2['scratchpad'] . '</div></td>';
echo "<td width='390' data-toggle='tip' data-placement='top' title='Pilot Remarks'>" . $data2['remarks'] . '</td>';
// Annotations 7/8/9
echo '<td width="70" style="font-size: 13px; max-width: 70px;" data-toggle="tip" data-placement="top" title="Arrival Runway"><div class="dropdown"><button class="btn btn-outline-light btn-sm dropdown-toggle" style="max-width: 70px;" type="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
' . $data2['annotation_7'] . '
</button>
<div class="dropdown-menu" aria-labelledby="dropdownMenuButton">';
$result_arr = ("SELECT * FROM runways WHERE airport_ident='$data2[Arrival]' AND (he_ident!='$data2[annotation_7]' OR le_ident!='$data2[annotation_7]')");
$count_arr = mysqli_query($conn_nav, $result_arr);
while ($data_arr = mysqli_fetch_array($count_arr)) {
echo '<a class="dropdown-item" href="functions/annotate.php?id=' . $id . '&annotate=7&value=' . $data_arr['he_ident'] . '">' . $data_arr['he_ident'] . '</a>';
echo '<a class="dropdown-item" href="functions/annotate.php?id=' . $id . '&annotate=7&value=' . $data_arr['le_ident'] . '">' . $data_arr['le_ident'] . '</a>';
}
echo '</div></div></td>';
echo '<td width="70" style="font-size: 13px; max-width: 70px;" data-toggle="tip" data-placement="top" title="Type of Arrival"><div class="dropdown"><button class="btn btn-outline-light btn-sm dropdown-toggle" style="max-width: 70px;" type="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
' . $data2['annotation_8'] . '
</button>
<div class="dropdown-menu" aria-labelledby="dropdownMenuButton">';
$result_arr_type = ("SELECT * FROM arrivals WHERE ident!='$data2[annotation_8]'");
$count_arr_type = mysqli_query($conn_nav, $result_arr_type);
while ($data_arr_type = mysqli_fetch_array($count_arr_type)) {
echo '<a class="dropdown-item" href="functions/annotate.php?id=' . $id . '&annotate=8&value=' . $data_arr_type['ident'] . '">' . $data_arr_type['ident'] . '</a>';
}
echo '</div></div></td>';
if (!isset($_SESSION['supuser'])) {
echo "<td width='70'><a class='link' href='?i=" . $data2['id'] . "'>Actions</a></td>";
} else {
echo "<td width='70'></td>";
}
echo '</tr>';
echo '</tbody>';
echo '</table>';
} else {
echo "<tr style='padding: 1px; min-height: 20px;'>";
echo "<td style='width: 75%;'><div contentEditable='true' class='edit' style='width: 50%;' id='Header/$id'>" . $data2['Header'] . '</div></td>';
echo '<td style="width: 15%;" data-toggle="tip" class="handle" style="text-align: center;">☰☰</td>';
echo "<td style='width: 10%;' data-toggle='tip'><a class='link' href='functions/delete.php?id=" . $data2['id'] . "'><b>✖</b></a></td>";
echo '</tr>';
}
}
?>
fetch-plan.php
<?php
session_start();
ob_start();
include('functions/config/config.php');
$user = DB_USER;
$password = DB_PASS;
$dbname = DB_NAME;
$servername = DB_HOST;
$navdbname = "kermou5_nav";
if (!isset($_SESSION['planID'])) {
header('Location: ' . DOMAIN . '/index.php');
exit;
} else {
}
$conn = new PDO( "mysql:host=$servername;dbname=$dbname", $user, $password );
$conn->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
$conn2 = mysqli_connect($servername, $user, $password, $dbname);
if (!$conn2) {
die("Connection failed: " . mysqli_connect_error());
}
$conn_nav = mysqli_connect( $servername, $user, $password, $navdbname );
if ( !$conn_nav ) {
die( 'Connection failed: ' . mysqli_connect_error() );
}
// Check if Data Still Exists
$result_count = ("SELECT COUNT(*) AS 'count' FROM inputflightstrips WHERE id=$id");
$count_count = mysqli_query($conn2, $result_count);
while ($data_count = mysqli_fetch_array($count_count)) {
if ($data_count['count'] > 0) {
} else {
unset($_SESSION['planID']);
header('Location: ' . DOMAIN . '/index.php');
exit;
}
}
// Enable Tooltips
?>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js"
integrity="sha384-ApNbgh9B+Y1QKtv3Rn7W3mgPxhU9K/ScQsAP7hUibX39j7fakFPskvXusvfa0b4Q" crossorigin="anonymous">
</script>
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js"
integrity="sha384-JZR6Spejh4U02d8jOt6vLEHfe/JQGiRRSQQxSfFWpi1MquVdAyjUar5+76PVCmYl" crossorigin="anonymous">
</script>
<!-- Tooltips-->
<script>
$(document).ready(function() {
$('[data-toggle="tip"]').tooltip('hide');
$('[data-toggle="tip"]').tooltip();
});
</script>
<?php
// END
$id = strip_tags($_SESSION['planID']);
$result = ("SELECT * FROM inputflightstrips WHERE id=$id");
$count = mysqli_query($conn2, $result);
while ($data = mysqli_fetch_array($count)) {
echo '<h6><b>Callsign</b></h6>';
echo '<p>'.$data['Callsign'].'</p><hr>';
echo '<h6><b>Aircraft ICAO</b></h6>';
echo '<p>'.$data['Aircraft'].'</p><hr>';
echo '<h6><b>Flight Rules</b></h6>';
echo '<p>'.$data['Flight_Rules'].'</p><hr>';
echo '<h6><b>Departure Airfield ICAO</b></h6>';
echo '<p>'.$data['Departure'].'</p><hr>';
echo '<h6><b>Arrival Airfield ICAO</b></h6>';
echo '<p>'.$data['Arrival'].'</p><hr>';
echo '<h6><b>Route</b></h6>';
echo '<p>'.$data['Routes'].'</p><hr>';
echo '<h5>Controller Assigned Information</h5><hr>';
echo '<h6><b>Squawk Code</b></h6>';
echo '<p>'.$data['Squawk'].'</p><hr>';
echo '<h6><b>Temporary Altitude</b></h6>';
echo '<p>'.$data['TempAltitude'].'</p><hr>';
if ($data['annotation_1'] != "") {
echo '<h6><b>Departure Runway</b></h6>';
echo '<p>'.$data['annotation_1'].'</p><hr>';
}
if ($data['annotation_7'] != "") {
echo '<h6><b>Arrival Runway</b></h6>';
echo '<p>'.$data['annotation_7'].'</p><hr>';
}
}
Thanks, this is going to be a lot to chew on for the moment.
Just keep in mind the website makes these errors constantly even when connected to the remote database so I am not sure how helpful that is, here is the log from right now while its working fine on the remote database,
[Tue Jun 02 12:11:32.935397 2020] [php7:notice] [pid 5683] [client 108.26.179.123:55096] PHP Notice: Undefined variable: id in /var/www/strips/fetch-plan.php on line 38, referer: https://strips.fsatc.us/plan.php
[Tue Jun 02 12:11:33.010632 2020] [php7:warn] [pid 5683] [client 108.26.179.123:55096] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /var/www/strips/fetch-plan.php on line 41, referer: https://strips.fsatc.us/plan.php
[Tue Jun 02 12:11:37.386781 2020] [php7:notice] [pid 2943] [client 148.75.44.83:62906] PHP Notice: Undefined index: supuser in /var/www/strips/fetch-right.php on line 129, referer: https://strips.fsatc.us/controller.php
[Tue Jun 02 12:11:39.217099 2020] [php7:notice] [pid 2958] [client 73.35.169.45:59734] PHP Notice: Undefined index: supuser in /var/www/strips/fetch-right.php on line 129, referer: https://strips.fsatc.us/controller.php?i=25323
[Tue Jun 02 12:11:40.191282 2020] [php7:notice] [pid 4925] [client 184.207.189.43:41486] PHP Notice: Undefined index: supuser in /var/www/strips/fetch-right.php on line 129, referer: https://strips.fsatc.us/controller.php
[Tue Jun 02 12:11:45.371048 2020] [php7:notice] [pid 5920] [client 148.75.44.83:63132] PHP Notice: Undefined index: supuser in /var/www/strips/fetch-right.php on line 129, referer: https://strips.fsatc.us/controller.php
[Tue Jun 02 12:11:47.208932 2020] [php7:notice] [pid 6057] [client 73.35.169.45:59735] PHP Notice: Undefined index: supuser in /var/www/strips/fetch-right.php on line 129, referer: https://strips.fsatc.us/controller.php?i=25323
[Tue Jun 02 12:11:47.943830 2020] [php7:notice] [pid 5551] [client 108.26.179.123:55104] PHP Notice: Undefined variable: id in /var/www/strips/fetch-plan.php on line 38, referer: https://strips.fsatc.us/plan.php
[Tue Jun 02 12:11:48.017182 2020] [php7:warn] [pid 5551] [client 108.26.179.123:55104] PHP Warning: mysqli_fetch_array() expects parameter 1 to be mysqli_result, bool given in /var/www/strips/fetch-plan.php on line 41, referer: https://strips.fsatc.us/plan.php
[Tue Jun 02 12:11:48.269974 2020] [php7:notice] [pid 5442] [client 184.207.189.43:40820] PHP Notice: Undefined index: supuser in /var/www/strips/fetch-right.php on line 129, referer: https://strips.fsatc.us/controller.php