Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Way to look up Members IP as in the phpbb boards.  (Read 6925 times)

0 Members and 1 Guest are viewing this topic.

webfairy

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 42
Way to look up Members IP as in the phpbb boards.
« 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



« Last Edit: August 28, 2006, 09:30:53 am by GauGau »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Way to look up Members IP as in the phpbb boards.
« Reply #1 on: August 28, 2006, 09:30:38 am »

Not being considered.
Logged

webfairy

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 42
Re: Way to look up Members IP as in the phpbb boards.
« Reply #2 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
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 21 queries.