Pagina 1 van 1
error ip logger...
Geplaatst: 27 jan 2006, 13:46
door gies
Ik heb een ip logger geinstalleerd:
Maar krijg de volgende error:
Code: Selecteer alles
Warning: fopen(data.php): failed to open stream: Permission denied in /usr/home/domains/mordox.org/public_html/includes/page_header.php on line 105
Warning: gethostbyaddr(): Address is not a valid IPv4 or IPv6 address in /usr/home/domains/mordox.org/public_html/includes/page_header.php on line 106
Warning: fwrite(): supplied argument is not a valid stream resource in /usr/home/domains/mordox.org/public_html/includes/page_header.php on line 108
Warning: fclose(): supplied argument is not a valid stream resource in /usr/home/domains/mordox.org/public_html/includes/page_header.php on line 109
Warning: Cannot modify header information - headers already sent by (output started at /usr/home/domains/mordox.org/public_html/includes/page_header.php:105) in /usr/home/domains/mordox.org/public_html/includes/page_header.php on line 907
Warning: Cannot modify header information - headers already sent by (output started at /usr/home/domains/mordox.org/public_html/includes/page_header.php:105) in /usr/home/domains/mordox.org/public_html/includes/page_header.php on line 909
Warning: Cannot modify header information - headers already sent by (output started at /usr/home/domains/mordox.org/public_html/includes/page_header.php:105) in /usr/home/domains/mordox.org/public_html/includes/page_header.php on line 910
wat is er fout ?
Geplaatst: 27 jan 2006, 13:47
door Paul
chmod data.php naar 777
Geplaatst: 27 jan 2006, 15:00
door gies
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")
{
Geplaatst: 27 jan 2006, 15:17
door Paul
constants.php niet aangepast.
Geplaatst: 27 jan 2006, 15:28
door gies
dom dom dom ...
had 'm wel aangepast maar niet geupload...
Maar nu registreerd hij wel de naam, en de tijd ... maar ik zie geen ip adres & host name.
En ik kan het alleen zien in mijn database maar niet via de admin panel ..
Waar zou dat aan kunnen liggen ?
************* EDIT **************
het schijnt dat ie niet werkt na 2.0.8 ....
jammer!
Geplaatst: 27 jan 2006, 17:53
door Bas
Ik heb een aanpassing zodat hij wel werkt
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");
$REMOTE_ADDR = $_SERVER['REMOTE_ADDR'];
$HTTP_REFERER = $_SERVER['HTTP_REFERER'];
$PHP_SELF = $_SERVER['PHP_SELF'];
$HTTP_USER_AGENT = $_SERVER['HTTP_USER_AGENT'];
$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