forum.coppermine-gallery.net

No Support => Feature requests => Topic started by: webfairy on August 28, 2006, 04:24:10 am

Title: Way to look up Members IP as in the phpbb boards.
Post by: webfairy on August 28, 2006, 04:24:10 am
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)
##

Code: [Select]
#################################################################
## 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



Title: Re: Way to look up Members IP as in the phpbb boards.
Post by: Joachim Müller on August 28, 2006, 09:30:38 am
Not being considered.
Title: Re: Way to look up Members IP as in the phpbb boards.
Post by: webfairy on August 28, 2006, 10:01:43 pm
Not being considered.

Thank you.  maybe someone out there who is familuar with Mods might take this on on a personal basis.  I would if i knew how to write php and understood what I needed to do.  But alass I just know enough to be dangerous.  LOL