function get_mach_name($i) { $u = get_mach($i); if ($u != -1) { return $u["name"]; } return -1; }
if ($link[$i][1] == $log_sort_dir) { $link[$i][1] = "asc"; } } $link[$i][3] = '<a href="index.php?' . $MACRO_LOG_SORT_COLUMN . '=' . $link[$i][0] . '&' . $MACRO_LOG_SORT_DIR . '=' . $link[$i][1] . '#log">' . $link[$i][2] . '</a>'; } $o_log = ""; $stmt = $db->prepare('SELECT * FROM log ORDER BY `' . $log_sort_column . '` ' . $log_sort_dir . ' ' . $sql_limit); $stmt->execute(); foreach ($stmt as $row) { $u_out = "-"; $m_out = "-"; $l_out = "-"; $extra = "-"; if ($row["machine_id"] > 0) { $m = get_mach($row["machine_id"]); if ($m != -1) { $m_out = $m["name"]; } else { $m_out = "db hickup"; } } if ($row["user_id"] > 0) { $u = get_user($row["user_id"]); if ($u != -1) { $u_out = $u["name"]; } else { $u_out = "db hickup"; } } // extra info