Example #1
0
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 {
Example #2
0
             $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']);