SQL Query code to get members Name & IP address

[93Corvette]

How do you display the User Name and IP address of all members on your forum?
I want to see which countries my members are coming from.

I know I can go to each members profile and see their user name and IP address, but I want to just Execute SQL Query (but don't know who to code it) and have it pull all of them. Then I will place this info in an Excel database and use this website to see which countries the user is from:
http://software77.net/geo-ip/multi-lookup/

I know you can get the member by using this SQL query, but how do you add the IP address next to them?
(Also this list only members in group 2, how so you get everyone?)
SELECT username FROM user WHERE usergroupid = 2 ORDER BY username

Thanks....

[Simon Lloyd]

Why not check how it's done in the WOL? as admin you can see their names and IP

[kh99]

Originally Posted by 93Corvette

I know you can get the member by using this SQL query, but how do you add the IP address next to them?
(Also this list only members in group 2, how so you get everyone?)
SELECT username FROM user WHERE usergroupid = 2 ORDER BY username

Thanks....

Try

SELECT username, ipaddress FROM user ORDER BY username

[93Corvette]

Thank you....