Previous Thread
Next Thread
Print Thread
Rate Thread
Search by IP #220348 07/02/2002 9:08 AM
Joined: Jan 2002
Posts: 218
WrÅith Offline OP
Enthusiast
OP Offline
Enthusiast
Joined: Jan 2002
Posts: 218
There was a hack some time ago for v5.5 that provided Admins & Moderators (configurable) with the ability to search by IP address and/or search by username and have all of the IP addresses displayed. The actual SQL code is quite simple really, but with the way the HTML has been moved out of the code files, I'm not sure how to go about making this work.

I've attached the instructions for the original hack if anyone would like to take a shot at "upgrading" it for v6.0

Attached Files
51696-SearchByIP.zip (0 Bytes, 9 downloads)
Sponsored Links
Re: Search by IP [Re: SDS] #220349 07/06/2002 12:05 AM
Joined: May 1999
Posts: 149
Max Fisch Offline
Enthusiast
Offline
Enthusiast
Joined: May 1999
Posts: 149
I would love to see this one as well.
An additional idea if someone is into it: In addition to displaying all IPs used by a specific user, list all other users sharing those IP addresses. This would be helpful to find people logging in with multiple usernames.

Other approaches for identifying multiple usernames might also be helpful - eg an administrator-viewable cookie showing all usernames used by that computer.

Max

Re: Search by IP [Re: SDS] #220350 07/06/2002 12:33 AM
Joined: Jun 2001
Posts: 3,273
JustDave Offline
That 70's Guy
Offline
That 70's Guy
Joined: Jun 2001
Posts: 3,273
The actual sql query to do such a check would be easy enough to do. I could add some more code to the search page and make a small script to display the results. Users that have the same IP address will not always signify that they are one person. If they both share the same ISP and are on dial up they may have some IP addresses in common at one time or another. Those behind proxies will also look to be only one person if viewed by IP address.

Re: Search by IP [Re: sjsaunders] #220351 07/06/2002 2:27 PM
Joined: Jan 2002
Posts: 218
WrÅith Offline OP
Enthusiast
OP Offline
Enthusiast
Joined: Jan 2002
Posts: 218
Here are the two queries that you would need. I've just been executing these from the SQL Command option in the Admin Control Panel:

code:
SELECT DISTINCT B_IP
FROM w3t_Posts
WHERE B_Username='<username>'

Replace <username> with the username of the poster you're investigating. This will show you all of the IP addresses used by an individual poster. Make sure it's spelled exactly the same.

code:
SELECT B_Username
FROM w3t_Posts
WHERE B_IP='XXX.XXX.XXX.XXX'

Replace XXX.XXX.XXX.XXX with the appropriate IP address. This is good for seeing if two usernames are using the same IP address.


Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Nettomo
Nettomo
Germany, Bremen
Posts: 417
Joined: November 2001
Forum Statistics
Forums63
Topics37,523
Posts293,714
Members13,832
Most Online5,166
Sep 15th, 2019
Top Posters(All Time)
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,789
Greg Hard 4,625
Top Posters(30 Days)
isaac 12
Gizmo 2
Today's Statistics
Currently Online 97
Topics Created 0
Posts Made 1
Users Online 2
Birthdays 12
Top Likes Received (All Time)
isaac 27
Brett 7
Morgan 2
DCPhil 1
Slaz 1
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2019 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20191201.dev)
Responsive Width:

PHP: 5.4.45 Page Time: 0.043s Queries: 24 (0.015s) Memory: 3.2451 MB (Peak: 3.4433 MB) Data Comp: Zlib Server Time: 2019-12-12 18:36:57 UTC
Valid HTML 5 and Valid CSS