/*
* LMT/Backstage/Autocomplete.php
* LHS Math Club Website
*
* Powers autocomplete results in the search boxes
*
* term: the term to search for
* School: search school names
* Team: search team names
* Coach: search coach email addresses
* Individual: search all individual names
* Unaffiliated:search unaffiliated individual names
*/
require_once '../../.lib/lmt-functions.php';
backstage_access();
generate_results();
/*
* generate_results()
*
* Fetches, parses and presents the data for Autocomplete.
*/
function generate_results()
{
if ($_GET['term'] == '') {
die;
}
$query = mysqli_real_escape_string(DB::get(), $_GET['term']);
$query = str_replace(" ", "%", $query);
$comma = "";
echo "[";
if (isset($_GET['Individual'])) {
$plugindetails .= '<b>Version:</b> ' . $pversion . '<br><br>';
}
echo $plugindetails;
?>
</td>
</tr>
<?php
$result1->MoveNext();
}
echo "</table>";
echo "</div>";
}
$resultp->MoveNext();
}
echo "</center>";
}
$ips_inrange = array();
switch ($disp) {
case "html":
generate_results($output);
break;
default:
generate_results($output);
break;
}
echo "<br>";
$dbconn->close();
?>
<br/><br/><br/>
</body>
</html>
<?php
require 'DB/mysqli.php';
$db = mysqli_connect("localhost", "ResultReader", "results", "testserver");
if (mysqli_connect_errno($db)) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$query = "SELECT * FROM servers";
$data = generate_results($db, $query);
echo json_encode($data, JSON_PRETTY_PRINT);
function generate_results($db, $query)
{
if (!($fetch_result = mysqli_query($db, $query))) {
die("ERROR: " . mysql_error());
}
$data = array();
while ($row = mysqli_fetch_assoc($fetch_result)) {
$success = false;
if ($test_run_result = mysqli_query($db, sprintf("SELECT id FROM test_runs WHERE test_runs.server_id = %d ORDER BY id DESC LIMIT 1", $row['id']))) {
if ($test_run_row = mysqli_fetch_assoc($test_run_result)) {
$latest_test_run = $test_run_row['id'];
if ($test_run_result = mysqli_query($db, sprintf("\r\n SELECT (SELECT success FROM rendering_results WHERE rendering_results.test_run_id=%d AND success='N' LIMIT 1) IS NULL AS rendering_success,\r\n (SELECT success FROM custom_results WHERE custom_results.test_run_id=%d AND success='N' LIMIT 1) IS NULL AS custom_success,\r\n (SELECT success FROM console_results WHERE console_results.test_run_id=%d AND success='N' LIMIT 1) IS NULL AS console_success,\r\n (SELECT COUNT(error_results.id) FROM error_results WHERE error_results.test_run_id=%d LIMIT 1)=0 AS exec_success", $latest_test_run, $latest_test_run, $latest_test_run, $latest_test_run))) {
if ($test_run_row = mysqli_fetch_assoc($test_run_result)) {
$success = $test_run_row['rendering_success'] && $test_run_row['custom_success'] && $test_run_row['console_success'] && $test_run_row['exec_success'];
}
}
}
}
$server = array("id" => $row['id'], "name" => $row['server_name'], "success" => $success);
array_push($data, $server);
}
