Search posts by IP address?
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=28040
Printed Date: 02 April 2026 at 7:58am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Search posts by IP address?
Posted By: RadioActiveLamb
Subject: Search posts by IP address?
Date Posted: 17 November 2009 at 6:54pm
| Is there any way for me as an administrator to search for posts or members by IP address? I suspect that a user is using a second account to stir things up, and want to find which (if any) other user names are posting from their IP address. |
Replies:
Posted By: Shaun
Date Posted: 18 November 2009 at 12:16am
| Only by querying your DB at source (or remotely). There's nothing in the actual forum software that will do this for you. |
Posted By: WebWiz-Bruce
Date Posted: 18 November 2009 at 9:34am
|
This is on the 'todo' list to add to the search page for admins and moderators.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: WebWiz-Bruce
Date Posted: 18 November 2009 at 10:53am
|
This has now been added to the next release 9.64. On the search form admins and moderators will find a new option in the Keyword Search drop down to search for an IP address. The admin or moderator would simply enter the IP address, or part of the IP address as the keyword and select IP Address from the drop down. The search will then return all posts under that IP address for the criteria given. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: 123Simples
Date Posted: 18 November 2009 at 11:29am
This sounds like an excellent addition Bruce  ------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
WebWiz-Bruce wrote:Posted By: billd3
Date Posted: 18 November 2009 at 1:08pm
|
WOW! VERY nice! Thanks! We had an issue where a member was using an alter-ego - signed up as two people. As one he played really dumb and a bit goofy, as the other, he played a slightly different role, and we found in real life, he's a conniving lawyer and liked to cause trouble in our hobby........ but we had to look up a lot of messages and start comparing addresses. This would have taken us only seconds with this option. Thanks. ------------- BillD http://theamcpages.com http://theamcforum.com |
Posted By: madpakke
Date Posted: 20 November 2009 at 8:31am
Bruce: Yeah it sound like a great extra feature in the script.. 
|
Posted By: WebWiz-Bruce
Date Posted: 20 November 2009 at 12:44pm
|
This new Search By IP Address for Posts is now available in version 9.64 released today.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Nick-V
Date Posted: 20 November 2009 at 1:24pm
|
We had to developed a very simple asp list some years back because members sometimes came back under a different name etc... We wanted one box into which we entered a part IP or part nickname and it reports all matching IPs with nicknames used in posts (getting the nickname) from the author record. Ours does not link to the post but I am wondering if a small enhancement of your new facility to do part IPs and/or part nicknames would be useful... I think this was the code Recordset1.Source = "SELECT dbo.tblAuthor.Username, dbo.tblThread.IP_addr FROM dbo.tblAuthor INNER JOIN dbo.tblThread ON dbo.tblAuthor.Author_ID=dbo.tblThread.Author_ID GROUP BY dbo.tblAuthor.Username, dbo.tblThread.IP_addr HAVING (dbo.tblThread.IP_addr) Is Not Null and ((dbo.tblAuthor.Username) Like '%" + Replace(Recordset1__nick, "'", "''") + "%' or (dbo.tblThread.IP_addr) Like '%" + Replace(Recordset1__nick, "'", "''") + "%') ORDER BY dbo.tblAuthor.Username;" |
Posted By: WebWiz-Bruce
Date Posted: 20 November 2009 at 1:27pm
|
The new IP Address search can do both part IP Address and there is still the option to search on part username. You are also able to combine the two so you can search on part IP and part Username. You also still have other options avaiable such as show results as Topics, Posts, select date range, select forum, etc. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: Nick-V
Date Posted: 20 November 2009 at 1:42pm
| Excellent thanks - I'll review then perhaps bin ours ! |
Posted By: RadioActiveLamb
Date Posted: 20 November 2009 at 4:51pm
|
Fantastic!
It's upgrade-day.
 |
Posted By: RadioActiveLamb
Date Posted: 20 November 2009 at 6:06pm
Installed and loving it! The only thing better would be an admin-only button next to the IP address of a poster to search that IP. Maybe someone handy in ASP code could whip it together (hint hint  )
On a related note, here's a great site for investigating IP addresses. Country of origin and subnet. It helps me block entire subnets from ISPs with spammers:
http://centralops.net/co/DomainDossier.aspx" rel="nofollow - http://centralops.net/co/DomainDossier.aspx
Plug-in the IP address and check "network whois".
|
Posted By: Järnvägsövergång
Date Posted: 23 November 2009 at 8:45am
| Just a little warning: I haven't checked 9.64, but in 9.63 and earlier the IP address of a post is changed when the post is edited. That means that if a moderator is editing a post made by User1 and a post made by User2, both posts will show the IP address of the moderator. Therefore it will falsely look like User1 and User2 is using the same IP address. |
Posted By: slog
Date Posted: 30 November 2009 at 1:18pm
| Is this feature available in this new version 9.64? I can't find it... :-( |
Posted By: WebWiz-Bruce
Date Posted: 30 November 2009 at 1:31pm
|
Yes it is in 9.64. You need to be logged into the forum as an admin or moderator and when you go to the advanced search page you type in the IP or part of the IP as the keyword and in the drop down box next to it select to search for an IP address. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: 123Simples
Date Posted: 30 November 2009 at 1:36pm
   ------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design |
Posted By: slog
Date Posted: 30 November 2009 at 11:35pm
Many thanks Bruce and Mr TWS. I didn't see it, sorry. 
|