Previous Thread
Next Thread
Print Thread
Hop To
Joined: Oct 2006
Posts: 37
G
newbie
newbie
G Offline
Joined: Oct 2006
Posts: 37
I want to get a list of IP addresses a user has used.

There used to be something you could click on in the admin search results but for the life of me, I can't find how to do this now. I'm on UBB.threads 7.5.2.

Joined: Dec 2003
Posts: 6,562
Likes: 78
Joined: Dec 2003
Posts: 6,562
Likes: 78
Not sure on this but in the control panel cp>>Membermanagement you can view the last used ip address or now you can get a PM on multiple accounts using the same IP.
Or if you goto CP>> member management /Advanced Search Options.
You can search for registration or last post IP


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Feb 2007
Posts: 1,294
Likes: 2
Veteran
Veteran
Joined: Feb 2007
Posts: 1,294
Likes: 2
In UBB.Classic when you viewed all the users post's it would tell you the IP address that the user had used for that post.

In UBB.Threads this little area was never carried over. The information is there and accessed when you look at all the users post's but not displayed on the screen. I'm sure that the powers to be have decided that this much needed little perk was not worth putting in the UBB.Threads even though it was mentioned quite a few times over the years.

Joined: Dec 2003
Posts: 6,562
Likes: 78
Joined: Dec 2003
Posts: 6,562
Likes: 78
Probably thought it was to much overhead.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Oct 2006
Posts: 37
G
newbie
newbie
G Offline
Joined: Oct 2006
Posts: 37
Maybe it was in UBB.classic, but there used to be a link in the search results you could click on that would just list all the IP addresses that person had used (that's how I remember it, anyway).

That's very useful when you're trying to see if a banned person has returned under a new name! Only seeing the registration and last-used IP is not as good. Oh well. Thought I'd ask.

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
For now you can run the following SQL query. Substitute # with the user id in question:

select distinct(POST_POSTER_IP) from ubbt_POSTS where USER_ID='#'


Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Bots
by Outdoorking - 04/13/2024 5:08 PM
Can you add html to language files?
by Baldeagle - 04/07/2024 2:41 PM
Do I need to rebuild my database?
by Baldeagle - 04/07/2024 2:58 AM
This is not a bug, but a suggestion
by Baldeagle - 04/05/2024 11:25 PM
Is UBB.threads still going?
by Aaron101 - 04/01/2022 8:18 AM
Who's Online Now
0 members (), 868 guests, and 221 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)