Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Way to look up Members IP as in the phpbb boards.  (Read 7430 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.017 seconds with 19 queries.