/* * 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); }