UBB.threads PHP Forum Software Community Forums Thread Like Summary - IP Addresses Of Users

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.

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:


As where "3" is that would be the users identification number, yours is most likely 2.

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.

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:

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

Or check the user User Last Login IP: