Changing the IP address in the database ?

The 2.0.x discussion forum has been locked; this will remain read-only. The 3.0.x discussion forum has been renamed phpBB Discussion.
Locked
olaamigos
Registered User
Posts: 2
Joined: Mon Jul 28, 2008 2:42 am

Changing the IP address in the database ?

Post by olaamigos » Mon Jul 28, 2008 3:32 am

Hello,

I'm wondering is it possible to change the IP address of one user in the database or not? Does anyone knows?
Let's say, what if the admin has 2 usernames and he doesn't want any Moderators or Super Moderators know that user is the same as the other user by the look up IP address of that post in the forum. So I'm wondering is it possible to change the saving IP address of that post in the database or not? Any knows? Thanks a lot :)

User avatar
drathbun
Former Team Member
Posts: 12204
Joined: Thu Jun 06, 2002 3:51 pm
Location: TOPICS_TABLE
Contact:

Re: Changing the IP address in the database ?

Post by drathbun » Mon Jul 28, 2008 4:43 am

The IP address in a standard phpBB2 database is only stored on the post table (phpbb_posts) in the poster_ip column. The value is encoded... essentially converted to hex and the dots dropped so that it's exactly 8 characters long. You could run an update script to reset the IP address to something different if you wanted.

When we pre-loaded our board some years back with the archives of a mailing list we set the IP address to "7F000001" which is 127.0.0.1 or the "home" IP address. So it's certainly possible. :)
I blog about phpBB: phpBBDoctor blog
Still using phpbb2? So am I! Click below for details
Image

User avatar
Lumpy Burgertushie
Registered User
Posts: 64700
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Changing the IP address in the database ?

Post by Lumpy Burgertushie » Mon Jul 28, 2008 6:42 am

however, there can be many, many people with the same IP address at any given time.

most people get a new IP every time they go online.

heck, AOL users get new IPs at random while they are online.

Just don't worry about IP addresses, they don't tell you anything useful at all.

robert
I am available for custom work on a donation basis. Please send me a PM with your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

OK, so what's the speed of dark?

User avatar
drathbun
Former Team Member
Posts: 12204
Joined: Thu Jun 06, 2002 3:51 pm
Location: TOPICS_TABLE
Contact:

Re: Changing the IP address in the database ?

Post by drathbun » Mon Jul 28, 2008 8:19 am

They can be enough of an indicator that I understand the reason for the question. ;-) The issue is, one admin with two accounts doesn't want someone to figure out if they're they same person. By IP address this is quite easy to do, especially if that person posts primarily from a small subset of addresses.
I blog about phpBB: phpBBDoctor blog
Still using phpbb2? So am I! Click below for details
Image

Locked

Return to “2.0.x Discussion”

Who is online

Users browsing this forum: No registered users and 10 guests

cron