How to export list of users and IP's? (using SQL)
Posted: Sat May 15, 2010 9:33 am
Firstly, I will point out that I am fully aware that members IP's that are logged in phpBB3 does not give clear indication that this is the real IP. They could be using proxies, dynamic IP's, and so on. I'm just experimenting with exporting SQL data.
I'm trying to export a list (as PDF) of usernames and all the IP's these users have posted from. However, when I run the SQL query below, it's showing all the post IP's but not every username. In fact, out of the 254 registered members, it's only showing around 5 usernames.
I can run this SQL query and of course it'll display a list of usernames and IP's they registered with:
So what query do I need to run so it includes the username and every IP the user has posted from?
Many thanks in advance for any assistance.
I'm trying to export a list (as PDF) of usernames and all the IP's these users have posted from. However, when I run the SQL query below, it's showing all the post IP's but not every username. In fact, out of the 254 registered members, it's only showing around 5 usernames.
Code: Select all
SELECT `poster_id` , `poster_ip` , `post_username`
FROM `quahappy_phpb2`.`phpbb_posts`
Code: Select all
SELECT `user_id` , `user_ip` , `username`
FROM `quahappy_phpb2`.`phpbb_users`
Many thanks in advance for any assistance.