How to search for posts made from a specific IP

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
Maggan22
Registered User
Posts: 53
Joined: Tue Sep 15, 2009 1:32 pm

How to search for posts made from a specific IP

Post by Maggan22 »

janus_zonstraal wrote: Thu Nov 26, 2020 7:56 am When you click on the (i) information button in a post you will see who else post from the same IP address, I think that is good enough?
no, it isn't.

Some posts by deleted Users have "Anonymous" at "Username" my board exists since 2004 the older Posts by deleted Users have nearly all Anonymous at Username - that is confusing if in one Topic nearly all Usernames "Anonymous". I know nearly all old Usernames, but i can not all Posts assign to the Usernames. The IP's can help.

By the way - "SELECT post_id from phpbb_posts WHERE poster_ip = 'xxx.xxx.xxx.xxx';" - does not show anything. I replaced of course xxx with the right ip

Can u help please?
Greets Maggan22
User avatar
janus_zonstraal
Registered User
Posts: 6414
Joined: Sat Aug 30, 2014 1:30 pm

Re: How to search for posts made from a specific IP

Post by janus_zonstraal »

By the way - "SELECT post_id from phpbb_posts WHERE poster_ip = 'xxx.xxx.xxx.xxx';" - does not show anything. I replaced of course xxx with the right ip
Just tested it and it is working on my board.
Did you edit the table prefix?
Sorry! My English is bat ;) !!!
Maggan22
Registered User
Posts: 53
Joined: Tue Sep 15, 2009 1:32 pm

Re: How to search for posts made from a specific IP

Post by Maggan22 »

yes, i did
Greets Maggan22
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52767
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: How to search for posts made from a specific IP

Post by stevemaury »

Any error message? It does work.
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
Maggan22
Registered User
Posts: 53
Joined: Tue Sep 15, 2009 1:32 pm

Re: How to search for posts made from a specific IP

Post by Maggan22 »

No, but i tryed it again, it works now. Thank you.
But an funktion in phpbb what search (same) IPs would very useful
Greets Maggan22
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52767
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: How to search for posts made from a specific IP

Post by stevemaury »

What information do you think you can get from an IP?
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
Post Reply

Return to “[3.2.x] Support Forum”