UBB.Developers Forums UBB.threads 7 Development How Do I? searching for users by IP?

I have a new user, who is acting like a troll. I was to simply search for a range of IPs, like

24.100.*.*

and see all results. I have tried in the admin area, and even when using the user's original IP, nothing comes up.

sorry, didn't see the thread just below mine where it has this query:

select * from w3t_Posts where B_IP = 'XXX.XXX.XXX.XXX'

I just used that and found our troll Thanks anyway

SELECT U_Username,U_RegIP
FROM w3t_Users
WHERE U_RegIP LIKE '24.%.%.%'

will show you all the users that have registered in that IP range. Is that what you're looking for?

Bill

Never mind