function admin_get_visitor_log($page = 1)
{
if (!($db = db::get())) {
return false;
}
if (!is_numeric($page) || $page < 1) {
$page = 0;
}
$offset = calculate_page_offset($page, 10);
if (!($table_prefix = get_table_prefix())) {
return false;
}
if (!($forum_fid = get_forum_fid())) {
return false;
}
$users_get_recent_array = array();
$uid = session::get_value('UID');
$sql = "SELECT SQL_CALC_FOUND_ROWS VISITOR_LOG.UID, USER.LOGON, ";
$sql .= "USER.NICKNAME, USER_PEER.PEER_NICKNAME, ";
$sql .= "UNIX_TIMESTAMP(VISITOR_LOG.LAST_LOGON) AS LAST_LOGON, ";
$sql .= "VISITOR_LOG.IPADDRESS, VISITOR_LOG.REFERER, ";
$sql .= "SEB.SID, SEB.NAME, SEB.URL FROM VISITOR_LOG VISITOR_LOG ";
$sql .= "LEFT JOIN USER USER ON (USER.UID = VISITOR_LOG.UID) ";
$sql .= "LEFT JOIN `{$table_prefix}USER_PEER` USER_PEER ";
$sql .= "ON (USER_PEER.PEER_UID = USER.UID AND USER_PEER.UID = '{$uid}') ";
$sql .= "LEFT JOIN SEARCH_ENGINE_BOTS SEB ";
$sql .= "ON (SEB.SID = VISITOR_LOG.SID) ";
$sql .= "WHERE VISITOR_LOG.LAST_LOGON IS NOT NULL AND VISITOR_LOG.LAST_LOGON > 0 ";
$sql .= "AND VISITOR_LOG.FORUM = '{$forum_fid}' ";
$sql .= "ORDER BY VISITOR_LOG.LAST_LOGON DESC LIMIT {$offset}, 10";
if (!($result = $db->query($sql))) {
return false;
}
$sql = "SELECT FOUND_ROWS() AS ROW_COUNT";
if (!($result_count = $db->query($sql))) {
return false;
}
list($users_get_recent_count) = $result_count->fetch_row();
if ($result->num_rows == 0 && $users_get_recent_count > 0 && $page > 1) {
return admin_get_visitor_log($page - 1);
}
while ($visitor_array = $result->fetch_assoc()) {
if (isset($visitor_array['LOGON']) && isset($visitor_array['PEER_NICKNAME'])) {
if (!is_null($visitor_array['PEER_NICKNAME']) && strlen($visitor_array['PEER_NICKNAME']) > 0) {
$visitor_array['NICKNAME'] = $visitor_array['PEER_NICKNAME'];
}
}
if ($visitor_array['UID'] == 0) {
$visitor_array['LOGON'] = gettext("Guest");
$visitor_array['NICKNAME'] = gettext("Guest");
} else {
if (!isset($visitor_array['LOGON']) || is_null($visitor_array['LOGON'])) {
$visitor_array['LOGON'] = gettext("Unknown user");
$visitor_array['NICKNAME'] = "";
}
}
if (isset($visitor_array['REFERER']) && strlen(trim($visitor_array['REFERER'])) > 0) {
$forum_uri_preg = preg_quote(html_get_forum_uri(), '/');
if (preg_match("/^{$forum_uri_preg}/iu", trim($visitor_array['REFERER'])) > 0) {
$visitor_array['REFERER'] = "";
}
} else {
$visitor_array['REFERER'] = "";
}
$users_get_recent_array[] = $visitor_array;
}
return array('user_count' => $users_get_recent_count, 'user_array' => $users_get_recent_array);
}
function admin_get_visitor_log($page = 1, $group_by = ADMIN_VISITOR_LOG_GROUP_NONE, $sort_by = 'LAST_LOGON', $sort_dir = 'DESC')
{
if (!($db = db::get())) {
return false;
}
if (!is_numeric($page) || $page < 1) {
$page = 0;
}
if (!($table_prefix = get_table_prefix())) {
return false;
}
if (!($forum_fid = get_forum_fid())) {
return false;
}
if (!isset($_SESSION['UID']) || !is_numeric($_SESSION['UID'])) {
return false;
}
$offset = calculate_page_offset($page, 10);
$group_by_array = array(ADMIN_VISITOR_LOG_GROUP_NONE => 'VISITOR_LOG.VID', ADMIN_VISITOR_LOG_GROUP_IP => 'VISITOR_LOG.IPADDRESS', ADMIN_VISITOR_LOG_GROUP_REFERER => 'VISITOR_LOG.REFERER', ADMIN_VISITOR_LOG_GROUP_USER_AGENT => 'VISITOR_LOG.USER_AGENT');
if (!isset($group_by_array[$group_by])) {
$group_by = ADMIN_LOG_GROUP_NONE;
}
switch ($group_by) {
case ADMIN_VISITOR_LOG_GROUP_IP:
$sort_by_array = array('LOGON' => 'LOGON_COUNT', 'LAST_LOGON' => 'LOGON_COUNT', 'IPADDRESS' => 'VISITOR_LOG.IPADDRESS', 'REFERER' => 'REFERER_COUNT', 'USER_AGENT' => 'USER_AGENT_COUNT');
break;
case ADMIN_VISITOR_LOG_GROUP_REFERER:
$sort_by_array = array('LOGON' => 'LOGON_COUNT', 'LAST_LOGON' => 'LOGON_COUNT', 'IPADDRESS' => 'IPADDRESS_COUNT', 'REFERER' => 'VISITOR_LOG.REFERER', 'USER_AGENT' => 'USER_AGENT_COUNT');
break;
case ADMIN_VISITOR_LOG_GROUP_USER_AGENT:
$sort_by_array = array('LOGON' => 'LOGON_COUNT', 'LAST_LOGON' => 'LOGON_COUNT', 'IPADDRESS' => 'IPADDRESS_COUNT', 'REFERER' => 'REFERER_COUNT', 'USER_AGENT' => 'VISITOR_LOG.USER_AGENT');
break;
default:
$sort_by_array = array('LOGON' => 'USER.LOGON', 'LAST_LOGON' => 'VISITOR_LOG.LAST_LOGON', 'IPADDRESS' => 'VISITOR_LOG.IPADDRESS', 'REFERER' => 'VISITOR_LOG.REFERER', 'USER_AGENT' => 'VISITOR_LOG.USER_AGENT');
break;
}
$sort_dir_array = array('ASC', 'DESC');
if (!isset($sort_by_array[$sort_by])) {
$sort_by = 'LAST_LOGON';
}
if (!in_array($sort_dir, $sort_dir_array)) {
$sort_dir = 'DESC';
}
$users_get_recent_array = array();
$sql = "SELECT SQL_CALC_FOUND_ROWS VISITOR_LOG.UID, USER.LOGON, USER.NICKNAME, ";
$sql .= "USER_PEER.PEER_NICKNAME, UNIX_TIMESTAMP(MAX(VISITOR_LOG.LAST_LOGON)) AS LAST_LOGON, ";
$sql .= "VISITOR_LOG.IPADDRESS, VISITOR_LOG.REFERER, VISITOR_LOG.USER_AGENT, ";
$sql .= "{$group_by_array[$group_by]} AS GROUP_BY, COUNT(*) AS LOGON_COUNT, ";
$sql .= "COUNT(DISTINCT VISITOR_LOG.IPADDRESS) AS IPADDRESS_COUNT, ";
$sql .= "COUNT(DISTINCT VISITOR_LOG.REFERER) AS REFERER_COUNT, ";
$sql .= "COUNT(DISTINCT VISITOR_LOG.USER_AGENT) AS USER_AGENT_COUNT, ";
$sql .= "SEB.SID, SEB.NAME, SEB.URL FROM VISITOR_LOG VISITOR_LOG ";
$sql .= "LEFT JOIN USER USER ON (USER.UID = VISITOR_LOG.UID) ";
$sql .= "LEFT JOIN `{$table_prefix}USER_PEER` USER_PEER ";
$sql .= "ON (USER_PEER.PEER_UID = USER.UID AND USER_PEER.UID = '{$_SESSION['UID']}') ";
$sql .= "LEFT JOIN SEARCH_ENGINE_BOTS SEB ON (SEB.SID = VISITOR_LOG.SID) ";
$sql .= "WHERE VISITOR_LOG.LAST_LOGON IS NOT NULL AND VISITOR_LOG.LAST_LOGON > 0 ";
$sql .= "AND VISITOR_LOG.FORUM = '{$forum_fid}' GROUP BY GROUP_BY ";
$sql .= "ORDER BY {$sort_by_array[$sort_by]} {$sort_dir} ";
$sql .= "LIMIT {$offset}, 10";
if (!($result = $db->query($sql))) {
return false;
}
$sql = "SELECT FOUND_ROWS() AS ROW_COUNT";
if (!($result_count = $db->query($sql))) {
return false;
}
list($users_get_recent_count) = $result_count->fetch_row();
if ($result->num_rows == 0 && $users_get_recent_count > 0 && $page > 1) {
return admin_get_visitor_log($page - 1, $group_by, $sort_by);
}
while (($visitor_array = $result->fetch_assoc()) !== null) {
if (isset($visitor_array['LOGON']) && isset($visitor_array['PEER_NICKNAME'])) {
if (!is_null($visitor_array['PEER_NICKNAME']) && strlen($visitor_array['PEER_NICKNAME']) > 0) {
$visitor_array['NICKNAME'] = $visitor_array['PEER_NICKNAME'];
}
}
if ($visitor_array['UID'] == 0) {
$visitor_array['LOGON'] = gettext("Guest");
$visitor_array['NICKNAME'] = gettext("Guest");
} else {
if (!isset($visitor_array['LOGON']) || is_null($visitor_array['LOGON'])) {
$visitor_array['LOGON'] = gettext("Unknown user");
$visitor_array['NICKNAME'] = "";
}
}
if (!isset($visitor_array['REFERER']) || strlen(trim($visitor_array['REFERER'])) == 0) {
$visitor_array['REFERER'] = "";
}
$users_get_recent_array[] = $visitor_array;
}
return array('user_count' => $users_get_recent_count, 'user_array' => $users_get_recent_array);
}
$remove_days = $_POST['remove_days'];
} else {
$remove_days = 0;
}
if ($valid) {
if (admin_prune_visitor_log($remove_days)) {
header_redirect("admin_visitor_log.php?webtag={$webtag}&pruned=true");
exit;
} else {
$error_msg_array[] = gettext("Failed To Prune Visitor Log");
$valid = false;
}
}
}
html_draw_top(sprintf('title=%s', gettext("Admin - Visitor Log")), 'class=window_title');
$admin_visitor_log_array = admin_get_visitor_log($page);
echo "<h1>", gettext("Admin"), "<img src=\"", html_style_image('separator.png'), "\" alt=\"\" border=\"0\" />", gettext("Visitor Log"), "</h1>\n";
if (isset($error_msg_array) && sizeof($error_msg_array) > 0) {
html_display_error_array($error_msg_array, '86%', 'center');
} else {
if (isset($_GET['pruned'])) {
html_display_success_msg(gettext("Successfully Pruned Visitor Log"), '86%', 'center');
} else {
if (sizeof($admin_visitor_log_array['user_array']) < 1) {
html_display_warning_msg(gettext("No Visitors Logged"), '86%', 'center');
}
}
}
echo "<br />\n";
echo "<div align=\"center\">\n";
echo " <table cellpadding=\"0\" cellspacing=\"0\" width=\"86%\">\n";
$remove_days = $_POST['remove_days'];
} else {
$remove_days = 0;
}
if ($valid) {
if (admin_prune_visitor_log($remove_days)) {
header_redirect("admin_visitor_log.php?webtag={$webtag}&group_by={$group_by}&pruned=true");
exit;
} else {
$error_msg_array[] = gettext("Failed To Prune Visitor Log");
$valid = false;
}
}
}
html_draw_top(array('title' => gettext('Admin - Visitor Log'), 'class' => 'window_title', 'main_css' => 'admin.css'));
$admin_visitor_log_array = admin_get_visitor_log($page, $group_by, $sort_by, $sort_dir);
echo "<h1>", gettext("Admin"), html_style_image('separator'), gettext("Visitor Log"), "</h1>\n";
if (isset($error_msg_array) && sizeof($error_msg_array) > 0) {
html_display_error_array($error_msg_array, '86%', 'center');
} else {
if (isset($_GET['pruned'])) {
html_display_success_msg(gettext("Successfully Pruned Visitor Log"), '86%', 'center');
} else {
if (sizeof($admin_visitor_log_array['user_array']) < 1) {
html_display_warning_msg(gettext("No Visitors Logged"), '86%', 'center');
}
}
}
echo "<br />\n";
echo "<div align=\"center\">\n";
echo " <table cellpadding=\"0\" cellspacing=\"0\" width=\"86%\">\n";
