<?php
/***************************************************************************
 * File: admin_logs_system.php
 * CCIP Version: 0.4.0
 * copyright: (C) 2002 - 2005 The CodeCrush Brothers
 * Author: kris@codecrush.com
 * begin: Monday, May 6, 2002
 * Note: CodeCrush Log System - based on CodeCrush IP Log mod
 ***************************************************************************
/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 ***************************************************************************/

define('IN_PHPBB', 1);

if( !empty($setmodules) )
{
	$file = basename(__FILE__);
	$module['Logs']['Admin_Log'] = $file . '?db=4';
	$module['Logs']['Moderator_log'] = $file . '?db=5';
	$module['Logs']['Visits_log'] = $file . '?db=1';
	$module['Logs']['Warning_log'] = $file . '?db=2';
	$module['Logs']['Error_log'] = $file . '?db=3';
	return;
}

//
// Load default header
//
$phpbb_root_path = "../";
require($phpbb_root_path . 'extension.inc');
require('pagestart.' . $phpEx);
include($phpbb_root_path . 'includes/functions_admin.'.$phpEx);
//include_once($phpbb_root_path . 'includes/functions_log.'.$phpEx);
include($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_logs.' . $phpEx);

if( $userdata['user_level'] != ADMIN )
{
	Header("Location: " . $phpbb_root_path . "login.php");
	exit;  /* Make sure that code below does not get executed when we redirect. */
}



//
// Load Logs configuration
//
$log_config = get_log_config(CCLOG_CONFIG, 0); // returns array: name->value


// Variables
$ip_list = array(); // some other mods aparently use this var! make sure we initiate it! (thanx to Marie)
$mode = '';
$user_batch = '';
$ip_batch = '';
$log_db = 1;
$per_page = $log_config['per_page'];
$start = 0; //default - start is a record value - we need to convert jump_page to record later on
$jump_page = 1; // default to first page


if( isset($HTTP_GET_VARS['mode']) || isset($HTTP_POST_VARS['mode']) )
{
	$mode = ($HTTP_GET_VARS['mode']) ? htmlspecialchars($HTTP_GET_VARS['mode']) : htmlspecialchars($HTTP_POST_VARS['mode']);
}

$params = array('mode' => 'mode', 'sort_key' => 'sk', 'sort_order' => 'sd', 'user_batch' => 'ub', 'ip_batch' => 'ipb');
while( list($var, $param) = @each($params) )
{
	if ( !empty($HTTP_POST_VARS[$param]) || !empty($HTTP_GET_VARS[$param]) )
    {
		$$var = ( !empty($HTTP_POST_VARS[$param]) ) ? htmlspecialchars($HTTP_POST_VARS[$param]) : htmlspecialchars($HTTP_GET_VARS[$param]);
    }
    else
    {
		$$var = '';
    }
}

$params = array('log_db' => 'db', 'per_page' => 'pp', 'dayspan' => 'st', 'jump_page' => 'jump_page');
while( list($var, $param) = @each($params) )
{
	if ( !empty($HTTP_POST_VARS[$param]) || !empty($HTTP_GET_VARS[$param]) )
    {
		$$var = ( !empty($HTTP_POST_VARS[$param]) ) ? intval($HTTP_POST_VARS[$param]) : intval($HTTP_GET_VARS[$param]);
    }
    else
    {
		$$var = 0;
    }
}

$use_timespan = (!empty($HTTP_POST_VARS['use_timespan'])) ? 'checked=checked' : '';

// some defaults
$sort_key = ($sort_key == '') ? 't' : $sort_key;
$sort_order = ($sort_order == '') ? 'd' : $sort_order;
$jump_page = ($jump_page == 0) ? 1 : $jump_page;

//dump_ary($HTTP_POST_VARS);

// Remember which log/db-table we're viewing
$template->assign_vars(array(
	'U_LOG_DB' => $log_db,
	'U_SEARCH_USER' => $phpbb_root_path . 'cc_select.' . $phpEx . '?sid=' .
	$userdata['session_id'] . '&mode=ccip&db=' . $log_db,
	'U_SEARCH_IP' => $phpbb_root_path . 'cc_select.' . $phpEx . '?sid=' .
    $userdata['session_id'] . '&mode=ccip2&db=' . $log_db,
	'S_LOG_ACTION' => append_sid("admin_logs_system.$phpEx")
));

// We need the numeric log_db value for URLs etc
$log_db_num = $log_db;

// Which DB-table/log is this?
switch($log_db) {
	case 1:
		$log_db = CCLOG_VISIT;
		$lang_log_title = $lang['Log_Title1'];
		$lang_log_text = $lang['Log_Text1'];
		break;
	case 2:
		$log_db = CCLOG_WARNING;
		$lang_log_title = $lang['Log_Title2'];
		$lang_log_text = $lang['Log_Text2'];
		break;
	case 3:
		$log_db = CCLOG_ERROR;
		$lang_log_title = $lang['Log_Title3'];
		$lang_log_text = $lang['Log_Text3'];
		break;
	case 4:
		$log_db = CCLOG_ADMIN;
		$lang_log_title = $lang['Log_Title4'];
		$lang_log_text = $lang['Log_Text4'];
		break;
	case 5:
		$log_db = CCLOG_MOD;
		$lang_log_title = $lang['Log_Title5'];
		$lang_log_text = $lang['Log_Text5'];
		break;
	default:
		$log_db = CCLOG_VISIT;
		$lang_log_title = $lang['Log_Title1'];
		$lang_log_text = $lang['Log_Text1'];
}


$ip_pattern = "/[0-9]+\.[0-9]+\.[0-9]+\.[0-9]+/";
$ip_pattern_match = "/([0-9]+)\.([0-9]+)\.([0-9]+)\.([0-9]+)/";
$ip_pattern_replace = "/([0-9]+\.[0-9]+\.[0-9]+\.[0-9]+)/";


//
// Check if user did or did not confirm
//
if ( isset($HTTP_POST_VARS['cancel']) )
{
	$mode = 'gen';
}

//
// (Semi-)Auto Pruning - v.0.3.1 -
//
$cc_pruned_rows = 0;
if( ($log_config['auto_prune'] == 1) )
{
	// "automagicly" delete records from the db older than $log_config['auto_prune_age'] days.
	$cc_xdays_ago = date("YmdHis",
						 mktime(0,0,0,date("m"),date("d")-$log_config['auto_prune_age'],date("Y")));
	//printf("TS xdays: %s<br>", $cc_xdays_ago);
	$sql = "DELETE FROM $log_db WHERE logged < $cc_xdays_ago";
	if ( !$db->sql_query($sql) )
	{
    	message_die(GENERAL_ERROR, 'Could not prune entries', '', __LINE__, __FILE__, $sql);
    }
	$cc_pruned_rows = $db->sql_affectedrows();
}



if($mode == 'delete') {

	//
	// Admin check
	//
	if($log_config['cc_log_admins'] != '')
	{
		$cc_log_admins = array();
		$cc_log_admins = explode(",", $log_config['cc_log_admins']);
		if(!in_array($userdata['session_user_id'], $cc_log_admins)) {
			message_die(GENERAL_ERROR, 'Not allowed to administer logs', '', __LINE__, __FILE__, $userdata['username']);
			exit;
		}
		unset($cc_log_admins);
	}

	$confirm = ( $HTTP_POST_VARS['confirm'] ) ? TRUE : 0;
    $delete = ( isset($HTTP_POST_VARS['delete']) ) ? TRUE : FALSE;

    if ( $confirm )
	{
    	if ( empty($HTTP_POST_VARS['entry_id_list']) )
		{
			message_die(GENERAL_MESSAGE, $lang['None_selected']);
		}
		$entries = $HTTP_POST_VARS['entry_id_list'];

		$entry_id_sql = '';
		for($i = 0; $i < count($entries); $i++)
		{
			$entry_id_sql .= ( ( $entry_id_sql != '' ) ? ', ' : '' ) . intval($entries[$i]);
		}

        $sql = "DELETE FROM $log_db
				WHERE log_id IN ($entry_id_sql)";
		if ( !$db->sql_query($sql) )
		{
			message_die(GENERAL_ERROR, 'Could not delete entries', '', __LINE__, __FILE__, $sql);
		}

		$redirect_page = "admin_logs_system.{$phpEx}?db={$log_db_num}&sid=" . $userdata['session_id'];
		$l_redirect = sprintf($lang['Click_return_ip'], '<a href="' . $redirect_page . '">', '</a>');

		$template->assign_vars(array(
			'META' => '<meta http-equiv="refresh" content="3;url=' . $redirect_page . '">')
		);

		message_die(GENERAL_MESSAGE, $lang['Entries_Removed'] . '<br /><br />' . $l_redirect);

    }
	else
	{
		// Not confirmed, show confirmation message
		if ( empty($HTTP_POST_VARS['entry_id_list']) )
		{
			message_die(GENERAL_MESSAGE, $lang['None_selected']);
		}

		$hidden_fields = '<input type="hidden" name="sid" value="' . $userdata['session_id'] . '" /><input type="hidden" name="mode" value="' . $mode . '" /><input type="hidden" name="db" value="' . $log_db_num . '" />';

		if ( isset($HTTP_POST_VARS['entry_id_list']) )
		{
			$entries = $HTTP_POST_VARS['entry_id_list'];
			for($i = 0; $i < count($entries); $i++)
			{
				$hidden_fields .= '<input type="hidden" name="entry_id_list[]" value="' . intval($entries[$i]) . '" />';
			}
		}

		//
		// Set template files
		//
		$template->set_filenames(array(
			'body' => 'admin/adm_confirm_body.tpl'
        ));

		$template->assign_vars(array(
			'MESSAGE_TITLE' => $lang['Confirm'],
			'MESSAGE_TEXT' => $lang['Confirm_delete_entries'],
			'L_YES' => $lang['Yes'],
			'L_NO' => $lang['No'],
			'S_CONFIRM_ACTION' => append_sid("admin_logs_system.$phpEx"),
			'S_HIDDEN_FIELDS' => $hidden_fields)
		);
	}
}
else //if( $mode == 'gen' || $mode == 'simple')
{
    //
    // 0.3.0 - batch jobs
    //
	$user_batch_ary   = array();
    $ip_batch_ary   = array();
    $sql_user = '';
    $sql_span_start = '';
    $sql_span_end = '';

    if(!empty($user_batch))
    {
        // Clean up the batch and prepare a string for url pagination
        $user_batch_ary = explode(";", $user_batch);

		foreach($user_batch_ary as $key => $value)
        {
        	//strip leading whitespace (incase someone types like: dar; kris; someone..)
            $value = ltrim($value);
            if(!empty($value))
            {
                // add wildcards
				$sql_user .= ( ( empty($sql_user) ) ? '' : ' OR ' ) . "username LIKE '" . preg_replace('/\*/', '%', $value) ."'";
            }
		}
    }
    if(!empty($ip_batch))
    {
        //$word2 = preg_replace("$ip_pattern", "$1 <br>", $word);
        preg_match_all($ip_pattern, $ip_batch, $matches);
        $ip_batch_ary = $matches[0];
        unset($matches);

        // Include C- and B- net matches?
        if( isset($HTTP_POST_VARS['ip_cnet']) || isset($HTTP_GET_VARS['ip_cnet']) || isset($HTTP_POST_VARS['ip_bnet']) || isset($HTTP_GET_VARS['ip_bnet']) )
        {
        	foreach($ip_batch_ary as $i => $value)
        	{
        		// If we include B-net matches then there's no need to test for full-IP or C-net matches
				if(isset($HTTP_POST_VARS['ip_bnet']) || isset($HTTP_GET_VARS['ip_bnet']))
				{
					// remember setting - B-net matching implies C-net matching
					$template->assign_vars(array(
						'S_IP_BNET' => 'checked="checked"',
						'S_IP_CNET' => 'checked="checked"'
					));
					$ip_batch_ary[$i] = preg_replace($ip_pattern_match, "$1.$2.%.%", $value);
				} else {
					// remember setting
					$template->assign_var('S_IP_CNET', 'checked="checked"'); // assign 1 var
					$ip_batch_ary[$i] = preg_replace($ip_pattern_match, "$1.$2.$3.%", $value);
				}
			}
        }
	}

	//
	// Olympus style Select-boxes
	//
	$s_limit_days = $s_sort_key = $s_sort_order = $s_ip_per_page = '';

	$limit_days = array(0 => $lang['ALL_ENTRIES'], 1 => $lang['1_DAY'], 7 => $lang['7_DAYS'], 14 => $lang['2_WEEKS'], 30 => $lang['1_MONTH'], 90 => $lang['3_MONTHS'], 180 => $lang['6_MONTHS'], 365 => $lang['1_YEAR']);
    $sort_by_text = array('u' => $lang['SORT_USERNAME'], 't' => $lang['SORT_DATE'], 'i' => $lang['SORT_IP'], 'o' => $lang['SORT_ACTION']);
    $sort_by_sql = array('u' => 'username', 't' => 'logged', 'i' => 'user_ip', 'o' => 'log_code');

	$s_limit_days = n7_gen_select_box($limit_days, 'st', $dayspan);
	$s_sort_key = n7_gen_select_box($sort_by_text, 'sk', $sort_key);
	$s_sort_order = n7_gen_select_box(array('a' => $lang['Ascending'], 'd' => $lang['Descending']), 'sd', $sort_order);

   	//
   	// Build the per-page select-box
   	//
   	$s_ip_per_page = n7_gen_select_box(array($log_config['per_page'] => $log_config['per_page'], 50 => 50, 100 => 100, 200 => 200, 400 => 400), 'pp', $per_page);
   	// override config per_page
   	$log_config['per_page'] = ($per_page > 0) ? $per_page : $log_config['per_page'];


   	//
   	// Get/Set the datespan (taken from admin_ip_stats)
   	//
   	$sql_start = "SELECT logged FROM $log_db ORDER BY log_id ASC LIMIT 1";
   	$sql_end = "SELECT logged FROM $log_db ORDER BY log_id DESC LIMIT 1";
   	$sql_span_start = $sql_span_end = '';

   	//
   	// Get the log start date
   	//
   	if ( !($result = $db->sql_query($sql_start)) )
   	{
		message_die(GENERAL_ERROR, 'Could not get the start date', '', __LINE__, __FILE__, $sql_start);
   	}
   	$first_row = $db->sql_fetchrow($result); //get first row
   	$start_date = $first_row['logged']; // some db configurations don't populate the numerical array
	$db->sql_freeresult($result);

   	//
   	// Get the log end date
   	//
   	if ( !($result = $db->sql_query($sql_end)) )
   	{
    	message_die(GENERAL_ERROR, 'Could not get the end date', '', __LINE__, __FILE__, $sql_end);
   	}
   	$first_row = $db->sql_fetchrow($result); //get first row
	$end_date = $first_row['logged']; // see start_date comment
   	$db->sql_freeresult($result);

	if($use_timespan)
	{
    	if( isset($HTTP_GET_VARS['span_start']) || isset($HTTP_POST_VARS['span_start']) )
      	{
        	$sql_span_start = ($HTTP_GET_VARS['span_start']) ? intval(preg_replace('/\//', '', $HTTP_GET_VARS['span_start'])) : intval(preg_replace('/\//', '', $HTTP_POST_VARS['span_start']));
      	} else {
        	$sql_span_start = substr($start_date, 0, 8);
      	}
      	if( isset($HTTP_GET_VARS['span_end']) || isset($HTTP_POST_VARS['span_end']) )
      	{
        	$sql_span_end = ($HTTP_GET_VARS['span_end']) ? intval(preg_replace('/\//', '', $HTTP_GET_VARS['span_end'])) : intval(preg_replace('/\//', '', $HTTP_POST_VARS['span_end']));
      	} else {
        	$sql_span_end = substr($end_date, 0, 8);
      	}
      	$sql_span_start .= '000000';
      	$sql_span_end .= '235959';
	}
	elseif($dayspan > 0)
	{
		// Use dayspan
		// end is today
		$sql_span_end = date("YmdHis");
		// start is x days ago
		$sql_span_start = date("YmdHis", mktime(0, 0, 0, date("m"), date("d")-$dayspan, date("Y")));
	}

    //
    // Prepare sql
    //
    $sql_ipdec = '';
	$ip_debug_listing = ''; // mainly for debugging
    if(!empty($ip_batch_ary))
    {
		//foreach($ip_batch_ary as $ip => $iphex)
		foreach($ip_batch_ary as $i => $ip)
        {
			// listings mainly for debugging
			$ip_debug_listing .= ( ( !empty($ip_debug_listing) ) ? '; ' : '' ) . $ip;

            $sql_ipdec .= ( (empty($sql_ipdec)) ? '':' OR ' ) . "user_ip LIKE '" . $ip . "' OR env_x_forwarded_for LIKE '%" . $ip . "%'";
        }
        // unfortunately the IN () clause doesn't understand wildcards (%) - going back to LIKE
		// 'user_ip IN (' . $sql_iphex . ') OR proxy_ip IN (' . $sql_ipdec . ')';
    }



    // the main call - users with newer mysql servers could benefit by using SELECT SQL_BUFFER_RESULT * FROM cc_ip_log
    $sql = "SELECT * FROM $log_db";
    $sql_span = (empty($sql_span_start) || empty($sql_span_end)) ? '' : " WHERE logged >= $sql_span_start AND logged <= $sql_span_end";
    //$sql_db = " WHERE logged >= $sql_span_start AND logged <= $sql_span_end";

	$sql_ipuser = '';
	if(!empty($sql_ipdec)) {
		$sql_ipuser = $sql_ipdec;
	}
	if(!empty($sql_user)) {
    	$sql_ipuser .= ( ( $sql_ipuser != '' ) ? ' OR ' : ' ' ) . $sql_user;
    }

    if($sql_ipuser != '') {
    	$sql .= ($sql_span != '') ? $sql_span . ' AND ' . $sql_ipuser : ' WHERE ' . $sql_ipuser;
    } else {
    	$sql .= $sql_span;
    }

    // TODO: add Sorting - sort_key, sort_order
    if(!empty($sort_key)) {
		$sql .= " ORDER BY " . $sort_by_sql[$sort_key];
		$sql .= ($sort_order == 'd') ? ' DESC' : ' ASC';
    }



    // selecting "logged" so we can get the date-range - deprecated - already gotten date-range
    //$sql_records = "SELECT logged FROM $cc_db_name" . $sql . ' ORDER BY log_nr ASC';
	$sql_records = "SELECT count(log_id) as record_count FROM $log_db"; // should be faster

   	//
	// Get the number of records
	//
	if ( !($result = $db->sql_query($sql_records)) )
	{
		message_die(GENERAL_ERROR, 'Could not get the number of records', '', __LINE__, __FILE__, $sql_records);
	}
	$row = $db->sql_fetchrow($result);
   	$record_count = $row['record_count'];
	//$record_count = $db->sql_numrows($result);
	$db->sql_freeresult($result);

   	//
   	// Consider jump_page
   	//
  	$total_pages = ceil($record_count/$log_config['per_page']);
	// printf("JUMP: %s<br>", $jump_page);
  	if ( isset($HTTP_POST_VARS['next']) ) {
		$jump_page = intval($HTTP_POST_VARS['current_page']); // first override jump_page field
  		$jump_page++;
  	} elseif ( isset($HTTP_POST_VARS['previous']) ) {
		$jump_page = intval($HTTP_POST_VARS['current_page']); // first override jump_page field
  	   	$jump_page--;
  	}
	// printf("JUMP: %s<br>", $jump_page);
  	if ( $jump_page > 1 ) {
  	   	$start = ($jump_page - 1) * $log_config['per_page'];
  	}
  	$on_page = floor($start / $log_config['per_page']) + 1;

	//
	//	Hide / show the prev/next buttons
	//
	if( $on_page > 1 )
	{
		$template->assign_block_vars('previous_btn', array());
	}
	if( $total_pages > $on_page )
	{
		$template->assign_block_vars('next_btn', array());
	}


    //
    // LIMIT the result based on $start and $log_config['per_page']
    //
	$sql .= " LIMIT $start, " . $log_config['per_page'];

	//printf("SQL: %s<br />", $sql);


	//
	// Start page proper
	//
	$template->set_filenames(array(
		'body' => 'admin/logs_body.tpl')
    );


	//
	// Execute the main SQL call - populate ip_rows()
	//
	$ip_rows = array();
	$error_log = array();
	$error_id_str = '';
	$error_count = 0;
	if( !$result = $db->sql_query($sql) )
	{
		message_die(GENERAL_ERROR, "Couldn't get IP Log information", "", __LINE__, __FILE__, $sql);
	}
	$ip_count = $db->sql_numrows($result);
	//$ip_rows = $db->sql_fetchrowset($result);
	while ( $row = $db->sql_fetchrow($result) )
	{
		$ip_rows[] = $row;
		if($row['error_log'] > 0){
			$error_id_str .= ( ( $error_id_str != '' ) ? ', ' : '' ) . $row['error_log'];
			$error_count++;
		}
	}
	$db->sql_freeresult($result);

	// Fetch error details
	if(!empty($error_id_str))
	{
		$sql = "SELECT * FROM " . CCLOG_ERROR . " WHERE log_id IN ({$error_id_str}) LIMIT {$error_count}";
		if( !$result = $db->sql_query($sql) )
		{
			message_die(GENERAL_ERROR, "Couldn't get IP Log Error information", "", __LINE__, __FILE__, $sql);
		}
		while ( $row = $db->sql_fetchrow($result) )
		{
			$error_log[$row['log_id']] = $row;
		}
		$db->sql_freeresult($result);
	}



	$template->assign_vars(array(
		'S_IP_PER_PAGE' => $s_ip_per_page,
		'S_SELECT_DAYS' => $s_limit_days,
		'L_DISPLAY_FROM_DAYS' => $lang['Display_from_days'],
		'S_SELECT_SORT' => $s_sort_key,
		'L_SORT_BY' => $lang['Sort_by'],
		'S_SELECT_ORDER' => $s_sort_order,
		'S_IP_USER_BATCH' => $user_batch,
		'S_IP_IP_BATCH' => $ip_batch,
		'L_PROBE_PROXY' => $lang['CCIP_probe'],
      	'LOOKUP_URL' => $log_config['ip_lookup_url'],
      	'S_IP_SPAN_START' => preg_replace('/(\d{4})(\d{2})(\d{2})/', "\\1/\\2/\\3", substr($sql_span_start, 0, 8)),
      	'S_IP_SPAN_END' => preg_replace('/(\d{4})(\d{2})(\d{2})/', "\\1/\\2/\\3", substr($sql_span_end, 0, 8))
	));




	//
	// Main Output Loop
	//
	for($i=0; $i < $ip_count; $i++)
	{
		$row = $ip_rows[$i];
    	$log_id = $ip_rows[$i]['log_id'];

		// Request method
		switch($row['req_method'])
		{
			case 'u':
				$row['req_method'] = 'PUT';
				break;
			case 'p':
				$row['req_method'] = 'POST';
				break;
			case 'g':
				$row['req_method'] = 'GET';
				break;
			case 'h':
				$row['req_method'] = 'HEAD';
				break;
			default:

		}


		$ip_date = create_date($log_config['log_dateformat'], n7_bigint_to_timestamp($ip_rows[$i]['logged']), $board_config['board_timezone']);
        $ip_full_date = create_date('H:i:s', n7_bigint_to_timestamp($ip_rows[$i]['logged']), $board_config['board_timezone']);

        $ip_ip = ($ip_rows[$i]['user_ip']) ? $ip_rows[$i]['user_ip'] : ''; // this is the one to ban
        $bb_ip = ($ip_rows[$i]['bb_ip']) ? $ip_rows[$i]['bb_ip'] : '';

		$ip_browser = $ip_rows[$i]['env_agent'];
		$ip_user_link = (intval($ip_rows[$i]['user_id']) > 0) ? '<a href="' . append_sid("admin_users.$phpEx?u=" .
            intval($ip_rows[$i]['user_id']) . "&mode=edit")  . '">' . $ip_rows[$i]['username'] . '</a>' : $ip_rows[$i]['username'];

		// replace referer urls with links
		$ip_referer_link = ereg_replace("[[:alpha:]]+://[^<>[:space:]]+[[:alnum:]/]", "<a href=\"\\0\">\\0</a>", $ip_rows[$i]['env_referer']);

		// New
		// Determine proxy usage: env_x_forwarded_for, env_remote_ip,	env_via, env_proxy_connection
		$proxy_lnk = '-';
		$ip_proxy_str = '';
		$ip_proxies = '';
		$ip_proxy_ary = array();
		if( !empty($ip_rows[$i]['env_x_forwarded_for']) || !empty($ip_rows[$i]['env_via']) || !empty($ip_rows[$i]['env_proxy_connection']) ) {
			$proxy_lnk = sprintf('<a href="javascript:handleClick(\'px%s\');">%s</a>', $log_id, $lang['Yes']);

			// proxy ip handling changed v.0.3.0 - the db field is now a text/blob that may contain several IPs
			// extract IPs and create ip lookup links
			/*
			$ip_pattern = "/[0-9]+\.[0-9]+\.[0-9]+\.[0-9]+/";
			$ip_pattern_match = "/([0-9]+)\.([0-9]+)\.([0-9]+)\.([0-9]+)/";
			$ip_pattern_replace = "/([0-9]+\.[0-9]+\.[0-9]+\.[0-9]+)/";
			* */
			//$replacement = '<a href="' . $log_config['ip_lookup_url'] . '$1" target="_phpbbwhois">$1</a>';
			//$ip_rows[$i]['env_x_forwarded_for'] = preg_replace($ip_pattern_replace, $replacement, $ip_rows[$i]['env_x_forwarded_for']);
		}

		// TODO: determine bots??

		// Country Flag
		$country_flag = '';
		$row['ip_country'] = strtolower($row['ip_country']);
		if( $row['ip_country'] != '' && file_exists($phpbb_root_path . 'images/flags/' . $row['ip_country'] . '.gif') ) {
			// Check if image exists
			$country_flag = sprintf('<img src="%s" alt="%s" title="%s" />', $phpbb_root_path . 'images/flags/' . $row['ip_country'] . '.gif', $row['ip_country'], $row['ip_country']);
		}

		// Page
		if( !empty($ip_rows[$i]['page_name']) ) {
			$page_name = ( ( $ip_rows[$i]['page_dir'] != '' ) ? $ip_rows[$i]['page_dir'].'/' : '' ) . $ip_rows[$i]['page_name'];
		}

		// error
		$error_msg = ($ip_rows[$i]['error_log']) ? sprintf('<a href="javascript:handleClick(\'er%s\');">%s</a>', $log_id, $ip_rows[$i]['error_log']) : '-';

		// Log code msg
		//if(isset($cc_lang[$row['log_code']])){
			//eval("\$row['log_msg'] = \$cc_lang[\$row['log_code']];");
			// continue
			$row['page'] = $phpbb_root_path . $page_name;
			//eval('$row["log_msg"] = sprintf("<a href=\"%s\">%s</a>", \$row[\'page\'], \$row[\'page_name\']);');
			switch($row['log_code'])
			{
				case 'CODE_PAGEREQ':
					$row['log_msg_short'] = sprintf('(%s) <a href="%s">%s</a> ', $row['req_method'], $row['page'], $page_name);
					$row['log_msg'] = $row['req_method'] . ' -&gt; ' . $page_name;
					break;
				default:
					$row['log_msg'] = htmlspecialchars($row['log_msg']);
					$row['log_msg_short'] = htmlspecialchars(substr($row['log_msg'],0,20));
			}
		//}


		$row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
		$row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];

      $template->assign_block_vars("ip", array(
         'ROW_COLOR' => "#" . $row_color,
         'ROW_CLASS' => $row_class,
         'LOG_ID' => $log_id,
         'DATE' => $ip_date,
         'UNAME' => $ip_user_link,
         'USERNAME' => $ip_rows[$i]['username'],
         'USER_IP' => $ip_ip,
         'LOG_ACTION' => $ip_rows[$i]['log_code'],
         //'LOG_MSG' => $ip_rows[$i]['log_msg'],
         'LOG_MSG' => $row['log_msg'],
         'LOG_MSG_SHORT' => $row['log_msg_short'],
		 		'COUNTRY' => $country_flag,
		 		'RESOLVED' => $row['ip_resolved'],
		 		'ERROR_LNK' => $error_msg,
		 		'ERROR' => $ip_rows[$i]['error_log'],
		 		'BROWSER' => $ip_browser,
		 		'REFERER' => $ip_referer_link,
		 		'PAGE' => $page_name,
		 		'PAGE_QSTR' => htmlspecialchars($ip_rows[$i]['page_query_str']),
		 		'PAGE_QSTR_SHORT' => htmlspecialchars(substr($ip_rows[$i]['page_query_str'],0,30)),
         'IP_PROXY_LNK' => $proxy_lnk,
         'X_FORW_FOR' => $ip_rows[$i]['env_x_forwarded_for'],
				'PROBE_PROXY_URL' => append_sid("admin_ip_proxy.$phpEx?ip=" . $ip_rows[$i]['user_ip'])
      ));

	if( !empty($ip_rows[$i]['env_x_forwarded_for']) || !empty($ip_rows[$i]['env_via']) || !empty($ip_rows[$i]['env_proxy_connection']) )
	{
		$replacement = '<a href="' . $log_config['ip_lookup_url'] . '$1" target="_phpbbwhois">$1</a> [<a href="javascript:banip(\'$1\');" title="' . $lang['Ban_IP'] . '">B</a>] [<a href="javascript:excip(\'$1\');" title="' . $lang['Exc_IP'] . '">E</a>]';

		$template->assign_block_vars("ip.proxy", array(
			'REMOTE_IP' => preg_replace($ip_pattern_replace, $replacement, $ip_rows[$i]['env_remote_ip']),
			'X_FORW_FOR' => preg_replace($ip_pattern_replace, $replacement, $ip_rows[$i]['env_x_forwarded_for']),
			'VIA' => preg_replace($ip_pattern_replace, $replacement, $ip_rows[$i]['env_via']),
			'PROXY_CONNECTION' => preg_replace($ip_pattern_replace, $replacement, $ip_rows[$i]['env_proxy_connection'])
		));
     }

	// error_log is empty or 0
	if($ip_rows[$i]['error_log'])
	{
      $template->assign_block_vars("ip.error", array(
		'ERROR_CODE' => $ip_rows[$i]['error_code'],
		'ERROR' => $error_log[$ip_rows[$i]['error_log']]['log_msg']
      ));
	}
	}

	// Pagination - as of 0.3.0 handled by forms
}


// Assign general language and template variables
$template->assign_vars(array(
	'L_LOG_TITLE' => $lang_log_title,
	'L_LOG_TEXT' => $lang_log_text,
	'L_LOG_USER' => $lang['User'],
	'L_LOG_ID' => $lang['ID'],
	'L_LOG_IP' => $lang['IP'],
	'L_LOG_TIME' => $lang['Time'],
	'L_LOG_ACTION' => $lang['Action'],
	'L_LOG_PROXY' => $lang['Proxy'],
	'L_LOG_COUNTRY' => $lang['Country'],
	'L_LOG_ERROR' => $lang['Error'],
	'L_LOG_BROWSER' => $lang['Browser'],
	'L_REFERER' => $lang['Referer'],
	'L_PAGE' => $lang['Page'],

	'L_LOG_BAN' => $lang['Ban'],
	'L_USERS' => $lang['Ban_Users'],
	'L_BAN_USER' => $lang['Ban_User'],
	'L_IPS' => $lang['Ban_IPs'],
	'L_BAN_IP' => $lang['Ban_IP'],
	'L_EXC_USER' => $lang['Exclude_User'],
	'L_EXC_IP' => $lang['Exclude_IP'],
	'L_EXC_BROWSER' => $lang['Exclude_Browser'],

	'L_IP_USER_BATCH' => $lang['CCIP_ip_user_batch'],
    'L_USER_BATCH' => $lang['CCIP_user_batch'],
    'L_IP_BATCH' => $lang['CCIP_ip_batch'],
    'L_IP_INCLUDE' => $lang['CCIP_include'],
    'L_IP_CNET' => $lang['CCIP_cnet'],
    'L_IP_BNET' => $lang['CCIP_bnet'],
    'L_USER_OR_IP' => $lang['CCIP_OR'],
    'L_MORE_OPTIONS' => $lang['More_Options'],

	'L_FIND_USERNAME' => $lang['Find_Users'],
	'L_FIND_IPS' => $lang['Find_IPs'],

	'L_IP_PREVIOUS' => $lang['CCIP_previous'],
	'L_IP_NEXT' => $lang['CCIP_next'],
	'L_SUBMIT' => $lang['Submit'],
	'L_RESET' => $lang['Reset'],
	'L_IP_PER_PAGE' => $lang['CCIP_per_page'],
    'L_PROXY' => $lang['Proxy'],
    'L_REMOTE_IP' => $lang['REMOTE_ADDR'],
    'L_VIA' => $lang['HTTP_VIA'],
    'L_X_FORW_FOR' => $lang['HTTP_X_FORWARDED_FOR'],
    'L_PROXY_CONNECTION' => $lang['HTTP_PROXY_CONNECTION'],
    'L_REFERER' => $lang['HTTP_REFERER'],

    'L_ERROR_CODE' => $lang['Error_code'],
    'L_ERROR' => $lang['Error'],
    'L_PAGE_QSTR' => $lang['Page_query_str'],

    'L_PROXY_WINDOW' => $lang['CCIP_probe_proxy'],

    'L_LOG_EXCLUDE' => $lang['IP_exc_title'],
    'L_EXCLUDE' => $lang['Exclude'],

    'L_IP_DATESPAN' => $lang['CCIP_datespan'],
    'L_IP_JUMP_PAGE' => $lang['CCIP_jump_page'],
	'L_IP_PAGE' => $lang['CCIP_page'],
	'L_IP_JUMP' => $lang['CCIP_jump'],
    'L_IP_TO' => $lang['CCIP_to'],
	'L_IP_PRUNE_ON' => ($log_config['cc_auto_prune'] == 1) ? $lang['CCIP_Prune_is_on'] : $lang['CCIP_Prune_is_off'],
	'U_IP_PRUNED' => sprintf($lang['CCIP_Pruned_rows'], $cc_pruned_rows),

	'L_IP_CURRENT_PAGE' => $lang['IP_current_page'],
	'S_IP_CURRENT_PAGE' => $on_page,
	'S_IP_ONPAGE' => '<b>'.$on_page . '</b>/' . $total_pages,
	'S_IP_JUMP_PAGE' => $on_page + 1,
	'S_IP_CONF_PER_PAGE' => $log_config['per_page'],
	'S_DAYSPAN' => $dayspan,
	'S_SORT_ORDER' => $sort_order,
	'S_SORT_KEY' => $sort_key,
	'S_TIMESPAN_CHK' => $use_timespan,
	'S_TIMESPAN_DISABLED' => ((empty($use_timespan)) ? 'disabled' : ''),
	'S_BAN_ACTION' => append_sid("admin_user_ban.$phpEx?submit=true"),
	'S_EXCLUDE_ACTION' => append_sid($phpbb_root_path . 'admin/admin_logs_exclude.' . $phpEx),
	'PHPBB_ROOT' => $phpbb_root_path
));


$template->pparse("body");

include('page_footer_admin.'.$phpEx);
?>