Here is the MOD f rom PHPBB.
I encluded the text and the sql instructions below.
Anyone intrested in converting this mod to Coppermine e-mail me and I will send you the two files.
phpBB IP Lookup
## Mod Author: Stargazer
http://www.stargazer-hosting.info## Mod Version: 2.00
## Mod Description: Records and displays IP of registered users in Admin CP.
##
## For support or comments and suggestions visit:
##
http://www.stargazer-hosting.info/hosting/modules.php?name=Forums (sorry this link is no longer valaid)
##
#################################################################
## Mod Title: phpBB IP Lookup
## Mod Author: Stargazer http://www.stargazer-hosting.info
## Mod Version: 2.00
## Mod Description: Records and displays IP of registered users in Admin CP.
##
## For support or comments and suggestions visit:
## http://www.stargazer-hosting.info/hosting/modules.php?name=Forums
##
## Installation Level: Easy
## Installation Time: ~3 Minutes
## New Features:
##
## 2.00
## Added Last Visit, Registration Date, and number of posts
##
##
## 1.20
## Compatibility bug fixed
## Templates merged for simplicity (all info viewed on 1 page)
## Reduced amount of files to edit for simplicity
##
## 1.10
## Updates IP when user edits profile.
##
## 1.01
## Admin control panel for easy IP lookup
##
## Files To Edit: 1
## includes/usercp_register.php
##
##
## Included Files: 2
## admin/admin_ip_lookup.php
## templates/subSilver/admin/user_ip_lookup.tpl
##
##
#################################################################
#
#-----[ SQL ]------------------------------------------
#
#
ALTER TABLE phpbb_users ADD user_ipadd varchar(25) AFTER user_from
#
#-----[ COPY ] ---------------------------
#
copy admin/admin_ip_lookup.php to admin/admin_ip_lookup.php
copy templates/subSilver/admin/user_ip_lookup.tpl to templates/subSilver/admin/user_ip_lookup.tpl
#
#-----[ OPEN ]------------------------------------------
#
includes/usercp_register.php
#
#-----[ FIND ]------------------------------------------
#
# this is a partial lookup
//
// Get current date
//
$sql = "INSERT INTO " . USERS_TABLE . "
#
#-----[ IN-LINE FIND ]---------------------------------
#
user_website, user_occ, user_from,
#
#-----[ IN-LINE AFTER, ADD ]---------------------------------
#
user_ipadd,
#
#-----[ FIND ]------------------------------------------
#
VALUES ($user_id, '" . str_replace("\'", "''", $username)
#
#-----[ IN-LINE FIND ]---------------------------------
#
'" . str_replace("\'", "''", $location) . "',
#
#-----[ IN-LINE AFTER, ADD ]---------------------------------
#
'$user_ip',
#
#-----[ FIND ]------------------------------------------
#
SET " . $username_sql . $passwd_sql . "user_email = '" . str_replace("\'", "''", $email) ."',
#
#-----[ IN-LINE FIND ]---------------------------------
#
user_from = '" . str_replace("\'", "''", $location) . "',
#
#-----[ IN-LINE AFTER, ADD ]---------------------------------
#
user_ipadd = '" . $user_ip . "',
#
# Be sure to copy the template files to all templates you have installed.
#
#
#-----[ SAVE/CLOSE ALL FILES ]---------------------------------
#
# EoM
SQL:
ALTER TABLE phpbb_users ADD user_ipadd varchar(25) AFTER user_from