Log IP's on Registration

Hulp nodig bij een modificaties of op zoek naar een MOD? Bekijk ons archief. Support wordt helaas niet meer verleend.
Forumregels

Sinds 1 januari 2009 wordt phpBB2 niet meer ondersteund.
Onderstaande informatie is verouderd en dient uitsluitend als archief.
phpBB2.0.x
Gesloten
Russ
Berichten: 118
Lid geworden op: 07 dec 2003, 13:17

Log IP's on Registration

Bericht door Russ » 24 mei 2004, 20:49

Ik probeerde deze mod te installeren maar het ging mis:
#################################################################
## Mod Title: Log IP's on Registration
## Mod Version: 1.1.1
## Author: Woody <woody@scoobler.com>
## Description: This will log a users IP when they register.
## From the admin panel, you can search for a user
## you will be displayed with the username you
## searched for, the IP they registered at, their
## email address and any other username's that
## registered from that IP address.
##
## Installation Level: Easy
## Installation Time: 5-8 Minutes
## Files To Edit: includes/usercp_register.php
## Included Files: templates/subSilver/admin/user_ip_list.tpl
## admin/admin_reg_ip.php
#################################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
#################################################################


#
#-----[ SQL / RUN ]---------------------------
#

ALTER TABLE `phpbb2_users`
ADD `user_reg_ip` TEXT NULL,
ADD `user_reg_host` TEXT NULL;

#
#-----[ COPY ]---------------------------
#

templates/xxxx/admin/user_ip_list.tpl

#
#-----[ COPY ]---------------------------
Ik ben naar de mijn phpBB database gegaan in phpMyAdmin en heb toen geklikt op "SQL". Vervolgens heb ik dit ingevoerd:
ALTER TABLE `phpbb2_users`
ADD `user_reg_ip` TEXT NULL,
ADD `user_reg_host` TEXT NULL;
Ik kreeg toen de volgende melding:
Error

SQL-query :

ALTER TABLE `phpbb2_users` ADD `user_reg_ip` TEXT NULL ,
ADD `user_reg_host` TEXT NULL

MySQL said:


#1146 - Table 'aonline_phpBB.phpbb2_users' doesn't exist
Kan ik dit probleem verhelpen of moet ik een back-up gaan runnen?

cartoontje
Berichten: 1518
Lid geworden op: 29 jun 2003, 10:57
Locatie: Home Sweet Home
Contacteer:

Bericht door cartoontje » 24 mei 2004, 21:02

De standaard prefix voor phpBB is phpbb_, dus waarschijnlijk had de maker van de mod wat anders. De error betekent dat de tabel niet bestaat (wat ook klopt).

Maak er dit van:

Code: Selecteer alles

ALTER TABLE `phpbb_users` 
ADD `user_reg_ip` TEXT NULL, 
ADD `user_reg_host` TEXT NULL;
Dit moet werken! :)

Russ
Berichten: 118
Lid geworden op: 07 dec 2003, 13:17

Bericht door Russ » 25 mei 2004, 06:41

Hij werkt, bedankt :bier:

coolviper
Berichten: 16
Lid geworden op: 13 jan 2004, 16:41

Bericht door coolviper » 14 okt 2004, 12:06

oke , daar heb geen last van.
maar ik krijg de volgende melding :

Parse error: parse error in /data/members/free/tripod/nl/c/o/o/coolviper/htdocs/includes/usercp_register.php on line 571
en ik krijg het niet gevonden wat oorzaak is.
en wat ik kan hier aan doen.

gr coolviper. :bier:

dit is het http://members.lycos.nl/coolviper/

Gebruikersavatar
Stef
Berichten: 9080
Lid geworden op: 04 jun 2003, 20:47

Bericht door Stef » 14 okt 2004, 12:25

Wat zegt de foutmelding?

De foutmelding zegt dat er een fout is op lijn 571.

Wat je nu het beste kan doen?

Kijken wat er op lijn 751 staat.

Ik zie het staan en dan?

Kijk in je mod install wat je verkeerd hebt geplakt.

coolviper
Berichten: 16
Lid geworden op: 13 jan 2004, 16:41

Bericht door coolviper » 14 okt 2004, 13:15

dat is juist het probleem : ik heb gedaan wat men in install.txt schrijft en toch krijg ik deze melding :

de install.txt

#################################################################
## Mod Title: Log IP's on Registration
## Mod Version: 1.1.2
## Author: Woody <scoobler@gmail.com>
## Description: This will log a users IP when they register.
## From the admin panel, you can search for a user
## you will be displayed with the username you
## searched for, the IP they registered at, their
## email address and any other username's that
## registered from that IP address.
##
## Installation Level: Easy
##
## Installation Time: 2-3 Minutes
##
## Files To Edit: includes/usercp_register.php
##
## Included Files: templates/subSilver/admin/user_ip_list.tpl
## admin/admin_reg_ip.php
##
#################################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
#################################################################
##
## Change Log:
##
## 30/09/04:
## Changed the code to work with 2.0.10.
## Amended the code to try and get round people who use
## proxy servers, so the IP you get is the users not the
## proxy box (With thanks to pootergeist from http://board.php-princess.net/).
##
#################################################################

#
#-----[ SQL / RUN ]---------------------------
#

ALTER TABLE `phpbb2_users`
ADD `user_reg_ip` TEXT NULL,
ADD `user_reg_host` TEXT NULL;

#
#-----[ COPY ]---------------------------
#

templates/xxxx/admin/user_ip_list.tpl

#
#-----[ COPY ]---------------------------
#

admin/admin_reg_ip.php

#
#-----[ OPEN ]------------------------------
#

includes/usercp_register.php

#
#-----[ FIND ]------------------------------------------
#

$user_id = $row['total'] + 1;

#
#-----[ AFTER ADD ]---------
#

//
// BEGIN - Registration IP Hack
//
if (isSet($_SERVER))
{
if (isSet($_SERVER["HTTP_X_FORWARDED_FOR"]))
{
$realip = $_SERVER["HTTP_X_FORWARDED_FOR"];
}
elseif (isSet($_SERVER["HTTP_CLIENT_IP"]))
{
$realip = $_SERVER["HTTP_CLIENT_IP"];
}
else
{
$realip = $_SERVER["REMOTE_ADDR"];
}
}
else
{
if ( getenv( 'HTTP_X_FORWARDED_FOR' ) )
{
$realip = getenv( 'HTTP_X_FORWARDED_FOR' );
}
elseif ( getenv( 'HTTP_CLIENT_IP' ) )
{
$realip = getenv( 'HTTP_CLIENT_IP' );
}
else
{
$realip = getenv( 'REMOTE_ADDR' );
}
}
$user_reg_id = $realip;
$user_reg_host = gethostbyaddr($realip);
//
// END - Registration IP Hack
//


#
#-----[ FIND ]--------------------
#

$sql = "INSERT INTO " . USERS_TABLE . " (

#
#-----[ IN-LINE AFTER ADD ]------------------------------------------
#
user_reg_ip, user_reg_host,

#
#-----[ FIND (next line down) ]------------------------------------
#

VALUES (

#
#-----[ IN-LINE AFTER ADD ]------------------------------
#

'" . str_replace("\'", "''", $user_reg_id) . "', '" . str_replace("\'", "''", $user_reg_host) . "',

#
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------
#
#



en dit is de regel die nu op het forum actief is :

$sql = "INSERT INTO " . USERS_TABLE . " (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_reg_ip, user_reg_host, user_actkey)
VALUES ($user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $new_password) . "', '" . str_replace("\'", "''", $email) . "', '" . str_replace("\'", "''", $icq) . "', '" . str_replace("\'", "''", $website) . "', '" . str_replace("\'", "''", $occupation) . "', '" . str_replace("\'", "''", $location) . "', '" . str_replace("\'", "''", $interests) . "', '" . str_replace("\'", "''", $signature) . "', '$signature_bbcode_uid', $avatar_sql, $viewemail, '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', '" . str_replace("\'", "''", $yim) . "', '" . str_replace("\'", "''", $msn) . "', $attachsig, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $popup_pm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, 0, 1, "; '" . str_replace("\'", "''", $user_reg_id) . "', '" .("\'", "''", $user_reg_host) . "',
if ( $board_config['require_activation'] == USER_ACTIVATION_SELF || $board_config['require_activation'] == USER_ACTIVATION_ADMIN || $coppa )
{

Gesloten