if ($gus_ip_collect_data == '0') { DB_query("INSERT IGNORE INTO {$_TABLES['gus_ignore_ip']} VALUES ( '{$ip_addr}' )", 1); } else { if ($gus_ip_collect_data == '1') { DB_query("DELETE FROM {$_TABLES['gus_ignore_ip']} WHERE ip = '{$ip_addr}' LIMIT 1", 1); } } // check for the Ban plugin and which table structure to use if (function_exists('BAN_for_plugins_check_access') and BAN_for_plugins_check_access()) { if ($gus_ip_ban == '0') { // Delete BAN_for_plugins_ban_ip($ip_addr, 'gus', false); } else { if ($gus_ip_ban == '1') { // Insert BAN_for_plugins_ban_ip($ip_addr, 'gus'); } } } // main SQL query $date_compare = GUS_get_date_comparison('date', $year, $month, $day); $date_format = $day == 0 ? 'CONCAT( DATE_FORMAT( date, \'%d %b - \' ), TIME_FORMAT( time, \'%H:%i\' ) )' : 'TIME_FORMAT( time, \'%H:%i\' )'; $order_by = GUS_get_order_by($sort); $sql = "SELECT page, uid, username, ip, host, referer, query_string, date, time, request,\n\t\t{$date_format} AS date_formatted \n\t\tFROM {$_TABLES['gus_userstats']} \n\t\tWHERE {$date_compare} AND ip='{$ip_addr}' {$order_by}"; // create navigation_URLs AND set urls $totalrec = DB_query($sql); $totalrows = DB_numRows($totalrec); $num_pages = ceil($totalrows / $_GUS_limit); if (!isset($_GET['page']) or empty($_GET['page'])) { $curpage = 1; } else {
$display .= alertMessage($alertmessage, $LANG_GF02['msg182'], $promptform); } } } elseif ($modfunction == 'banip' and forum_modPermission($forum, $_USER['uid'], 'mod_ban') and $fortopicid != 0 and (function_exists('BAN_for_plugins_check_access') and BAN_for_plugins_check_access())) { $iptobansql = DB_query("SELECT ip FROM {$_TABLES['forum_topic']} WHERE id='{$fortopicid}'"); $forumpostipnum = DB_fetchArray($iptobansql); if ($forumpostipnum['ip'] == '') { $display .= alertMessage($LANG_GF02['msg174']); exit; } $ip_address = $forumpostipnum['ip']; if (BAN_for_plugins_ban_found($ip_address)) { BAN_for_plugins_ban_ip($ip_address, 'forum', false); $display = COM_refresh($_CONF['site_url'] . "/forum/viewtopic.php?msg=11&showtopic={$msgpid}"); } else { BAN_for_plugins_ban_ip($ip_address, 'forum'); $display = COM_refresh($_CONF['site_url'] . "/forum/viewtopic.php?msg=10&showtopic={$msgpid}"); } COM_output($display); exit; } elseif ($modfunction == 'banippost' and forum_modPermission($forum, $_USER['uid'], 'mod_ban') and $fortopicid != 0) { $iptobansql = DB_query("SELECT ip FROM {$_TABLES['forum_topic']} WHERE id='{$fortopicid}'"); $forumpostipnum = DB_fetchArray($iptobansql); if ($forumpostipnum['ip'] == '') { $display .= alertMessage($LANG_GF02['msg174']); exit; } $alertmessage = $LANG_GF02['msg68']; $ip_address = $forumpostipnum['ip']; if (!empty($_CONF['ip_lookup'])) { $iplookup = str_replace('*', $ip_address, $_CONF['ip_lookup']);