| double listing for IP addresses [message #273708] |
Thu, 11 October 2007 08:05  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
|
I have noticed when clicking on many members' IP address, a single member is listed twice. It seems to be occurring on new newer members or members with few messages.
|
|
|
|
|
|
|
|
| Re: double listing for IP addresses [message #274861 is a reply to message #273806] |
Wed, 17 October 2007 07:55  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
|
I don't know if this helps, but I tried to scan another IP address today and there was a big list of users with this IP address but only one of them was duplicated (the last one?), so it looks as if maybe it started duplicating as of a certain date (maybe since the new changes were implemented?)
|
|
|
|
| Re: double listing for IP addresses [message #274938 is a reply to message #274861] |
Wed, 17 October 2007 14:53 |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
| Quote: |
...only one of them was duplicated (the last one?)
|
Look like this is a feature - not a bug. The first set of IPs are from the messages table (IPs used while posting); the last IP is the user's registration IP.
The logic is:
SELECT DISTINCT(ip_address) FROM messages WHERE user_id = ...
SELECT registration_ip FROM users WHERE user_id = ...
Hence, the last IP may be listed twice.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
