No authentication entries found!'); } else { $string = generate_box_open($vars['header']); // Entries have been returned. Print the table. $string .= '' . PHP_EOL; $cols = [ [ 'date' => 'Date', 'style' => 'width: 150px;' ], 'user' => [ 'user' => 'User' ], [ 'from' => 'From' ], [ 'ua' => 'User-Agent', 'style' => 'width: 200px;' ], [ 'Action' ], ]; if ($vars['page'] == 'preferences') { unset($cols['user']); } $string .= generate_table_header($cols); //, $vars); // Currently sorting is not available $string .= '' . PHP_EOL; foreach ($authlog['entries'] as $entry) { if (!safe_empty($entry['user_agent'])) { $entry['detect_browser'] = detect_browser($entry['user_agent']); //r($entry['detect_browser']); $entry['user_agent'] = get_icon($entry['detect_browser']['icon']) . ' ' . $entry['detect_browser']['browser_full']; if ($entry['detect_browser']['platform']) { $entry['user_agent'] .= ' (' . $entry['detect_browser']['platform'] . ')'; } } if (str_icontains_array($entry['result'], 'fail')) { $class = " class=\"error\""; } else { $class = ""; } $string .= ' '; if (isset($cols['user'])) { $string .= ' '; } $string .= ' ' . PHP_EOL; } $string .= ' ' . PHP_EOL; $string .= '

' . $entry['datetime'] . '

' . escape_html($entry['user']) . '

' . ($_SESSION['userlevel'] > 5 ? generate_popup_link('ip', $entry['address']) : preg_replace('/^\d+/', '*', $entry['address'])) . '

' . $entry['user_agent'] . '

' . $entry['result'] . '

'; $string .= generate_box_close(); // Add pagination header if ($authlog['pagination_html']) { $string = $authlog['pagination_html'] . $string . $authlog['pagination_html']; } // Print authlog echo $string; } } // DOCME needs phpdoc block function get_authlog_array($vars) { $array = []; // Short authlog? (no pagination, small out) $array['short'] = (isset($vars['short']) && $vars['short']); if ($array['short']) { // For short, always limit to last 10 entries $start = 0; $pagesize = 10; } else { // With pagination? (display page numbers in header) $array['pagination'] = (isset($vars['pagination']) && $vars['pagination']); pagination($vars, 0, TRUE); // Get default pagesize/pageno $array['pageno'] = $vars['pageno']; $array['pagesize'] = $vars['pagesize']; $start = $array['pagesize'] * $array['pageno'] - $array['pagesize']; $pagesize = $array['pagesize']; } $query = " FROM `authlog`" . generate_authlog_where($vars); $query_count = 'SELECT COUNT(`id`) ' . $query; $query_updated = 'SELECT MAX(`datetime`) ' . $query; $where = $query = 'SELECT * ' . $query; $query .= ' ORDER BY `datetime` DESC '; $query .= "LIMIT $start,$pagesize"; // Query authlog $array['entries'] = dbFetchRows($query, $param); // Query authlog count if ($array['pagination'] && !$array['short']) { $array['count'] = dbFetchCell($query_count, $param); $array['pagination_html'] = pagination($vars, $array['count']); } else { $array['count'] = safe_count($array['entries']); } // Query for last timestamp $array['updated'] = dbFetchCell($query_updated, $param); return $array; } function generate_authlog_where($vars) { $sql = ''; // Build query foreach ($vars as $var => $value) { switch ($var) { case "user_id": if ($value == '') { continue 2; } $value = auth_username_by_id($value); //break; case "user": case "username": if ($value == '') { continue 2; } $sql .= generate_query_values_and($value, 'user'); break; case "address": case "ip": if ($value == '') { continue 2; } $sql .= generate_query_values_and($value, 'address', '%LIKE%'); break; case "useragent": case "user_agent": $sql .= generate_query_values_and($value, 'user_agent', '%LIKE%'); break; case "result": //case "action": $sql .= generate_query_values_and($value, 'result', 'LIKE%'); break; } } if (strlen($sql)) { $sql = ' WHERE 1' . $sql; } elseif ($_SESSION['userlevel'] != 10) { // Complete hide for non-priveleged users $sql = ' WHERE 0'; } return $sql; } // EOF