IP #'s

[BettorsTalk.com]

Is there any way to pull all of the IP #'s for registered users from a Vbulletin board?

[Marco van Herwaarden]

Please explain what you mean by "pull all"

[BettorsTalk.com]

In other words download all of the IP#'s for all registered users so they can be gone through.

[Marco van Herwaarden]

You could do this by running a query on the post table (this will not show the IP's used when registering).

[sql]SELECT username, ipaddress, count(*) from post group by 1,2;[/sql]
Above will show the ip's used on posting for each member, and how many posts made using each IP.

[BettorsTalk.com]

Is there any way to print this out? Meaning mines pulling up over 1900 pages.

[BettorsTalk.com]

Also this isn't pulling all of the IP #'s for all of my members as I have over 7,000 members.

Also is there a way to find which of my members are from a particular State? In other words a way to go about searching for the State Wisconsin without having to try and go through over 7,000 members 1 at a time.

[Dan]

Originally Posted by BettorsTalk.com

Also this isn't pulling all of the IP #'s for all of my members as I have over 7,000 members.

Also is there a way to find which of my members are from a particular State? In other words a way to go about searching for the State Wisconsin without having to try and go through over 7,000 members 1 at a time.

The only way to know this is if you read their host mask, and IF their hostmask tells you where they are you will know.

[BettorsTalk.com]

Originally Posted by Dan

The only way to know this is if you read their host mask, and IF their hostmask tells you where they are you will know.

So basically I would have to go through over 7,000 members 1 at a time?

[Marco van Herwaarden]

You would have to start to make a list of all the IP ranges all ISP in Wisconsin are using, plus the IP's of companies/universities in that state.