Thread Like Summary
Gizmo, isaac
Total Likes: 3
Original Post (Thread Starter)
#264555 01/03/2021 8:07 PM
by tinker123
I'm running a web board on UBB 7.5.7.

I'm having trouble with a troll(s), possibly using multiple accounts.

Is it possible for me see what their IP address was at the time of their latest post AND what their IP address was when they created their account?

If so, can I see the IP address for each post in their history?

Thanks for any info.
Liked Replies
#264571 Jan 12th a 06:32 PM
You can run a SQL Command and see every IP address that user ever posted with.

Go to your site's control panel and select "Database Tools" then the tab "SQL Command". In "Query" box put in the command below:

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

As where "3" is that would be the users identification number, yours is most likely 2.
1 member likes this
#264572 Jan 12th a 06:47 PM
by isaac
Also a few things to be aware of -
Proper IPv6 support in UBB.threads was first introduced in version 7.6.0. If you are running an older version, features such as IP address lookup, searches, logging will be incomplete or broken. Only the first few digits of the IP address will be stored. If you are on an older hosting server and/or obsolete version of PHP, you might only be collecting IPv4 data -- which may be collecting proxy addresses, your webhost IP addresses, IPv4 routing server addresses, or nothing at all.
1 member likes this
#264574 Jan 13th a 11:46 PM
by Gizmo
As long as you're running on a version which supports the logging of IPv6 addresses (v7.6+) you can check the database for a snapshot of how many users have logged in from unique IPv6 addresses with the following queries.

You can get a snapshot of how many posts are made by unique IPv6 users by running:
SQL Query

Likewise you can see who has registered from an IPv6 address with:
SQL Query

Or check the user User Last Login IP:
SQL Query
1 member likes this
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Better moderator notification answer
by Morgan - 07/24/2021 7:29 AM
well this sucks..
by Bad Frog - 07/21/2021 6:15 PM
What does it mean?
by Morgan - 07/14/2021 3:21 AM
Who's Online Now
0 members (), 53 guests, and 91 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
gallery test
gallery test
by Mors, September 23
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Powered by UBB.threads™ PHP Forum Software 7.7.5