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).

SELECT username, ipaddress, count(*) from post group by 1,2;
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]

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]

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.