* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA */ /** @require functions */ require_once $_SERVER["DOCUMENT_ROOT"] . "/source/functions.php"; /** @require config */ require_once $_SERVER["DOCUMENT_ROOT"] . "/source/config.inc.php"; if (isset($_GET["nowplaying"])) { // VLC contents supercedes file contents if enabled. $nowplaying = ""; if (isset($settings["nowplaying_file"]) && $settings["nowplaying_file"] != "") { $nowplaying = file_get_contents($settings["nowplaying_file"]); } if (isset($settings["nowplaying_vlc_password"]) && $settings["nowplaying_vlc_password"] != "") { $username = ""; $password = $settings["nowplaying_vlc_password"]; $url = $settings["nowplaying_vlc_url"]; $opts = array('http' => array('method' => "GET", 'header' => "Authorization: Basic " . base64_encode("{$username}:{$password}"))); $context = stream_context_create($opts); if (!($result = file_get_contents($url, false, $context))) { $error = error_get_last(); write_log("Error: " . $error["message"], __FILE__, __LINE__); } $json_data = json_decode($result, true); $nowplaying = $json_data["information"]["category"]["meta"]["now_playing"]; } if (empty($nowplaying)) { $nowplaying = "Not playing"; } echo tts_override($nowplaying); exit; }
$rm_id = $arr["id"]; $rm_text = $arr["text"]; echo $rm_text; mysqli_query($GLOBALS["___mysqli_ston"], "\tUPDATE edtb_musings\n\t\t\t\t\t\t\t\t\t\t\t\tSET used = '1'\n\t\t\t\t\t\t\t\t\t\t\t\tWHERE id = '" . $rm_id . "'\n\t\t\t\t\t\t\t\t\t\t\t\tLIMIT 1") or write_log(mysqli_error($GLOBALS["___mysqli_ston"]), __FILE__, __LINE__); is_null($___mysqli_res = mysqli_close($link)) ? false : $___mysqli_res; exit; } /* * current system short */ if (isset($_GET["sys_short"])) { $va_text .= "unknown"; if (!empty($curSys["name"])) { $va_text = $curSys["name"]; } echo tts_override($va_text); exit; } /* * distance to X */ if (isset($_GET["dist"])) { $to = $_GET["dist"]; $distance = ""; //write_log($to); $to = str_replace("system", "", $to); if (system_exists($to)) { if (valid_coordinates($curSys["x"], $curSys["y"], $curSys["z"])) { $res = mysqli_query($GLOBALS["___mysqli_ston"], "\tSELECT\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tsqrt(pow((IFNULL(edtb_systems.x, user_systems_own.x)-(" . $curSys["x"] . ")),2)+pow((IFNULL(edtb_systems.y, user_systems_own.y)-(" . $curSys["y"] . ")),2)+pow((IFNULL(edtb_systems.z, user_systems_own.z)-(" . $curSys["z"] . ")),2))\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAS distance\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM edtb_systems\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN user_systems_own ON edtb_systems.name = user_systems_own.name\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE edtb_systems.name = '" . mysqli_real_escape_string($GLOBALS["___mysqli_ston"], $to) . "'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tLIMIT 1") or write_log(mysqli_error($GLOBALS["___mysqli_ston"]), __FILE__, __LINE__); $arr = mysqli_fetch_assoc($res); $distance = number_format($arr["distance"], 1);
$arr = mysqli_fetch_assoc($res); $rm_id = $arr["id"]; $rm_text = $arr["text"]; echo $rm_text; mysqli_query($GLOBALS["___mysqli_ston"], "\tUPDATE edtb_musings\n\t\t\t\t\t\t\t\t\t\t\t\tSET used = '1'\n\t\t\t\t\t\t\t\t\t\t\t\tWHERE id = '" . $rm_id . "'\n\t\t\t\t\t\t\t\t\t\t\t\tLIMIT 1") or write_log(mysqli_error($GLOBALS["___mysqli_ston"]), __FILE__, __LINE__); exit; } /** * current system short */ if (isset($_GET["sys_short"])) { $sys_short = "unknown"; if (!empty($curSys["name"])) { $sys_short = $curSys["name"]; } echo tts_override($sys_short); exit; } /** * distance to X */ if (isset($_GET["dist"])) { $to = $_GET["dist"]; $distance = ""; $to = str_replace("system", "", $to); if (!valid_coordinates($curSys["x"], $curSys["y"], $curSys["z"])) { $distance = "How can I calculate distances if I don't even know where we are?"; } else { if (system_exists($to)) { $res = mysqli_query($GLOBALS["___mysqli_ston"], "\tSELECT\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tsqrt(pow((IFNULL(edtb_systems.x, user_systems_own.x)-(" . $curSys["x"] . ")),2)+pow((IFNULL(edtb_systems.y, user_systems_own.y)-(" . $curSys["y"] . ")),2)+pow((IFNULL(edtb_systems.z, user_systems_own.z)-(" . $curSys["z"] . ")),2))\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tAS distance\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tFROM edtb_systems\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN user_systems_own ON edtb_systems.name = user_systems_own.name\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE edtb_systems.name = '" . mysqli_real_escape_string($GLOBALS["___mysqli_ston"], $to) . "'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\tLIMIT 1") or write_log(mysqli_error($GLOBALS["___mysqli_ston"]), __FILE__, __LINE__); $arr = mysqli_fetch_assoc($res);