You are using a browser which is not compatible with CSS (for more information, see Tara's tutorial). Because of this, it is possible that our website may not appear correctly in your browser. We apologise for the inconvenience, and recommend you upgrade your browser to one which is compatible with CSS. For more information, please visit our Browser Upgrade page.

4WebHelp

Online Tools: phpBB IP Converter

To save on database space, phpBB encodes IPs before inserting them into the database. This means that when you are viewing the "posts" table in your database, you will not be able to directly know which IP the user posted from. This script will convert a phpBB encoded IP to a standard IP, and provide a hostname where available.

Convert phpBB encoded IP to standard IP:
phpBB encoded IP: (example: 500d7ef7)

Convert standard IP to phpBB encoded IP:
Standard IP: (example: 127.0.0.1)


Latest comments
Name: DNEmail none
Thanks for all the years you have kept this tool on-line.  It is the go-to resource for this issue, and you will be happy to know that it is being mentioned:

http://www.advicenators.com/qview.php?q=598053
Name: wripEmail none
SELECT username, CONCAT(CONV(substring(session_ip, 1,2),16,10),'.',CONV(substring(session_ip, 3,2),16,10),'.',CONV(substring(session_ip, 5,2),16,10),'.',CONV(substring(session_ip, 7,2),16,10)) as IP FROM phpbb_sessions INNER JOIN phpbb_users on phpbb_sessions.session_user_id = phpbb_users.user_id ORDER BY phpbb_users.username, IP

This does in fact work
Name: alanEmail none
Is there a way to accomplish this hex to IP conversion in MySQL?
Name: GloriaEmail none
SELECT username, CONCAT(CONV(substring(session_ip, 1,2),16,10),'.',CONV(substring(session_ip, 3,2),16,10),'.',CONV(substring(session_ip, 5,2),16,10),'.',CONV(substring(session_ip, 7,2),16,10)) as IP FROM phpbb_sessions INNER JOIN phpbb_users on phpbb_sessions.session_user_id = phpbb_users.user_id ORDER BY phpbb_users.username, IP

Works
Name: eustyEmail none
Just thought I'd say thanks Smile
Name: agarrenloEmail none
thx man ^^ this is really helpful. now im looking for a tutorial on that conv() function hehe xDD
Name: MufasaEmail none
OK took me a bit since I have barely used MySQL and typically use Microsoft SQL 2k instead...  This is the query I was looking to make.  It lets me see the sessions table showing all user names and their IP.  Enjoy!

SELECT username, CONCAT(CONV(substring(session_ip, 1,2),16,10),'.',CONV(substring(session_ip, 3,2),16,10),'.',CONV(substring(session_ip, 5,2),16,10),'.',CONV(substring(session_ip, 7,2),16,10)) as IP FROM phpbb_sessions INNER JOIN phpbb_users on phpbb_sessions.session_user_id = phpbb_users.user_id ORDER BY phpbb_users.username, IP
Name: MufasaEmail none
Is there a way to accomplish this hex to IP conversion in MySQL?  I figured you could via a combination of SUBSTRING and CASTing AS UNSIGNED you could, but of course on my installation, the casting example on http://dev.mysql.com/doc/refman/4.1/en/hexadecimal-values.html doesn't yield anything but 0s.  Sad
Name: ZillionEmail none
Great tx
Name: PaulEmail pmm001 at yahoo dot com
I spent hours searching the phpbb forum and docs looking fot that info.

Thanks
Name: The DudeEmail none
Awesome!

There's another pbpbb ip conversion tool here
http://www.w3clubs.com/phpBB2/phpbbip.php
It also has some other options like resolving the IP address and decoding multiple IPs at once.
The source is available.
Name: fserhjqajEmail none
****

Add a new comment

This page is © Copyright 2002-2017, 4WebHelp. It may not be reproduced without 4WebHelp's prior permission.