Thread Like Summary
Gizmo, isaac
Total Likes: 3
Original Post (Thread Starter)
#264555 01/03/2021 8:07 PM
by tinker123
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
by JAISP
JAISP
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:

Code
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
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
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
SELECT COUNT(DISTINCT `POST_POSTER_IP`) FROM `ubbt_POSTS` WHERE `POST_POSTER_IP` LIKE '%:%'

Likewise you can see who has registered from an IPv6 address with:
SQL Query
SELECT COUNT(DISTINCT `USER_REGISTRATION_IP`) FROM `ubbt_USERS` WHERE `USER_REGISTRATION_IP` LIKE '%:%'

Or check the user User Last Login IP:
SQL Query
SELECT COUNT(DISTINCT `USER_LAST_IP`) FROM `ubbt_USER_DATA` WHERE `USER_LAST_IP` LIKE '%:%'
1 member likes this
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Cannot redeclare class Admin
by Antoine20 - 03/05/2021 11:36 AM
legend for admin log operation names?
by Ruben - 03/04/2021 3:14 PM
active text
by isaac - 03/02/2021 6:48 AM
How to delete all PM's for one user
by Ruben - 02/27/2021 7:10 AM
Active links corrupts image links/urls
by Morgan - 02/24/2021 1:03 PM
Who's Online Now
2 members (Ruben, 1 invisible), 56 guests, and 52 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