require_once "MakeLog.php"; ?> <div class="entries"> <div class="entries_inner"> <?php /** * get system-specific log */ $esc_logsys_name = $mysqli->real_escape_string($logsystem); $query = " SELECT user_log.id, user_log.station_id, user_log.system_name, user_log.log_entry, user_log.stardate,\n user_log.pinned, user_log.type, user_log.title, user_log.audio,\n edtb_stations.name AS station_name\n FROM user_log\n LEFT JOIN edtb_stations ON edtb_stations.id = user_log.station_id\n WHERE user_log.system_id = '{$logsystem_id}'\n OR user_log.system_name = '{$esc_logsys_name}'\n ORDER BY -user_log.pinned, user_log.weight, user_log.stardate DESC"; $result = $mysqli->query($query) or write_log($mysqli->error, __FILE__, __LINE__); $num = $result->num_rows; if ($num > 0) { $log = new MakeLog(); $log->time_difference = $system_time; echo $log->make_log_entries($result, "log"); } else { echo '<h2>No log entries for ' . $logsystem . '</h2><br />'; echo '<a href="javascript:void(0)" id="toggle" onclick="toggle_log(\'' . addslashes($logsystem) . '\')" title="Add log entry" style="color:inherit">'; echo 'Click here to add one</a>'; } $result->close(); ?> </div> </div> <?php /** * initiate page footer */ $footer = new Footer(); /**
$log_res = $mysqli->query($query) or write_log($mysqli->error, __FILE__, __LINE__); $num = $log_res->num_rows; if ($num > 0) { $logs = new MakeLog(); $logs->time_difference = $system_time; $logdata .= $logs->make_log_entries($log_res, "system"); } $log_res->close(); } /** * General log */ $sort = "DESC"; if (isset($_GET["glog_sort"]) && $_GET["glog_sort"] != "undefined") { if ($_GET["glog_sort"] == "asc") { $sort = "ASC"; } if ($_GET["glog_sort"] == "desc") { $sort = "DESC"; } } $query = " SELECT SQL_CACHE\n id, log_entry, stardate, pinned, title, audio\n FROM user_log WHERE system_id = '' AND system_name = ''\n ORDER BY -pinned, weight, stardate " . $sort . "\n LIMIT 5"; $glog_res = $mysqli->query($query) or write_log($mysqli->error, __FILE__, __LINE__); $gnum = $glog_res->num_rows; if ($gnum > 0) { $general_logs = new MakeLog(); $general_logs->time_difference = $system_time; $logdata .= $general_logs->make_log_entries($glog_res, "general"); } $glog_res->close(); $data["log_data"] = $logdata;