Convert phpBB IP Addresses
Thursday, October 9th, 2008
phpBB stores its IP addresses in a funky format. They’re useless to the human eye!
Convert them to normal IPs with the following code
SELECT CONCAT( CONV( substring( poster_ip, 1, 2 ) , 16, 10 ) , '.', CONV( substring( poster_ip, 3, 2 ) , 16, 10 ) , '.', CONV( substring( poster_ip, 5, 2 ) , 16, 10 ) , '.', CONV( substring( poster_ip, 7, 2 ) , 16, 10 ) ) AS IP FROM phpbb_posts WHERE `poster_id` = USERID LIMIT 0 , 30
This code will convert all know IPs from a selected user (In my case 51).
| Bookmark it del.icio.us | Reddit | Slashdot | Digg | Facebook | Technorati | Google | StumbleUpon | Window Live | Tailrank | Furl | Propeller | Yahoo |