Heb een ander gepakt .... die de logs in de database bijhoudt.
Code: Selecteer alles
#################################################################
## Mod Title: Enhanced IP Logger DB Based
## Mod Version: 5.0.2
## Author: Dimitri Seitz < dwing@weingarten-net.de > - http://www.dseitz.de
## Description: The Hack loggs all possible Usersettings
##
## IP, Host, Browser, Username, Date, Forumid, Referrer
##
## Installation Level: easy/moderate
## Installation Time: 5-10 Minutes
## Files To Edit: 1
## Included Files: Files: admin_ip_logger.php
##
#################################################################
##
## Author Note:
##
## This will fix all probs caused by filewriting.
## !!! To Upgrade from 5.0.0 do not run the SQL Command !!!
##
##
#################################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
#################################################################
##
##
## Files to Upload:
##
## admin_ip_logger.php into phpBB/Admin Folder
##
##
##
##
##################################################################
#
#-----[ OPEN ]------------------------------------------
#
includes/constants.php
#
#-----[ FIND ]------------------------------------------
#
define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');
#
#-----[ ADD, AFTER ]------------------------------------------
#
define('IP_TABLE', $table_prefix.'ip');
#
#-----[ OPEN ]------------------------------------------
#
includes/page_header.php
#
#-----[ FIND ]------------------------------------------
#
header('Content-Encoding: gzip');
}
}
}
}
#
#-----[ ADD, AFTER ]------------------------------------------
#
//
// Enhanced IP Logger 5.0
//
// Config
$x = @date("D-M-y - H:i:s");
$host = @gethostbyaddr("$REMOTE_ADDR");
// SQL Query
$sql = "INSERT INTO " . IP_TABLE . " (host, ip, date, username, referrer, forum,browser)
VALUES ('$host','$REMOTE_ADDR','$x','$userdata[username]','$HTTP_REFERER','$PHP_SELF','$HTTP_USER_AGENT')";
// Query Database
if( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not query categories list', '', __LINE__, __FILE__, $sql);
}
// End Logger
#
#-----[ ADD SQL ]------------------------------------------
#
DROP TABLE IF EXISTS `phpbb_ip`;
CREATE TABLE `phpbb2_ip` (
`id` tinyint(4) NOT NULL auto_increment,
`ip` varchar(200) NOT NULL default '0',
`host` varchar(200) NOT NULL default '0',
`date` varchar(200) NOT NULL default '0',
`username` varchar(200) NOT NULL default '0',
`referrer` varchar(200) NOT NULL default '0',
`forum` varchar(200) NOT NULL default '0',
`browser` varchar(200) NOT NULL default '0',
KEY `id` (`id`)
) TYPE=MyISAM;
#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
# EoM
Als ik via admin de log wil bekijken zegt ie:
Code: Selecteer alles
Could not query logged IPs
DEBUG MODE
SQL Error : 1146 Table 'deb_nl_1.IP_TABLE' doesn't exist
SELECT * FROM phpbb2_ranks_config ORDER BY cfg_mode ASC;
Line : 100
File : admin_ip_logger.php
dit is ongeveer regel 100:
Code: Selecteer alles
$ip = "SELECT * FROM " . IP_TABLE . "";
if( !($result = $db->sql_query($ip)) )
{
message_die(GENERAL_ERROR, 'Could not query logged IPs', '', __LINE__, __FILE__, $sql);
}
}
if($mode == "show")
{
