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
Cooking Utensils
Our Portable Ice Maker Machine for Countertop can produce up to 26 lbs of ice in just 24 hours! <a href="https://incookingspace.com/" rel="nofollow title''>https://incookingspace.com/</a> <a href="https://incookingspace.com/" rel="nofollow title''>cooking utensils</a>
Florync
Adverse Event Epoprostenol n 56 Conventional Therapy n 55 Cardiovascular Flushing 23 0 Hypotension 13 0 Gastrointestinal Anorexia 66 47 Nausea vomiting 41 16 Diarrhea 50 5 Musculoskeletal Jaw pain 75 0 Pain neck pain arthralgia 84 65 Neurological Headache 46 5 Skin and Appendages Skin ulcer 39 24 Eczema rash urticaria 25 4 <a href=http://propecia.mom>buy propecia 5mg usa</a>
DN
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
wrip
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
alan
Is there a way to accomplish this hex to IP conversion in MySQL?
Gloria
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
eusty
Just thought I'd say thanks Smile
agarrenlo
thx man ^^ this is really helpful. now im looking for a tutorial on that conv() function hehe xDD
Mufasa
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
Mufasa
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
Zillion
Great tx
Paul
I spent hours searching the phpbb forum and docs looking fot that info.

Thanks
The Dude
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.
fserhjqaj
****

Add a new comment

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