Convert phpBB IP Addresses

Posted on October 9, 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).

Share and Enjoy:

Really freakin’ simple mysql virtual hosting pure-ftpd
This article will guide you through installing pure-ftpd configured for virtual hosts using mysql as...
Why does perl consume my entire CPU?
I use a perl script to convert an Excel file to CSV on an Ubuntu...
mod_geoip Revisted including stopping spam in phpBB 2
I've recently moved a client's forum onto a new cPanel server, previously it was on...
[Snippet] Manually reset a Wordpress password
Wordpress stores user passwords in MD5 checksums, so using your SQL admin tool of choice...
Event ID 10015 Source DCOM
Got a locked down Active Directory? Or just a messy one? Getting The machine wide...

What this article useful to you?

Let me know, buy me a beer!
Alternatively, if you're feeling impecunious, you may like to subscribe to my RSS feed, or see other articles in the MySQL, PHP category.

Filed under: MySQL, PHP Leave a comment

Comments (5) Trackbacks (0) ( subscribe to comments on this post )

PraraWaph
January 22nd, 2009 - 01:02

Nothing seems to be easier than seeing someone whom you can help but not helping.
I suggest we start giving it a try. Give love to the ones that need it.
God will appreciate it.
joannahopkin
April 21st, 2009 - 19:28

Hi my name is Joanna.
I am 24 years old.
I come from United Kingdom
London
FrankFN
June 15th, 2009 - 17:10

I heard from several sources that people didnt recieve the product they bought from amazon
is this true?
Barbadosusa
October 30th, 2009 - 07:47

Hi.
Where are You
[url=http://tramadols.yuku.com/topic/5453]Tramadol same day delivery[/url]
Tramadol same day delivery
http://tramadols.yuku.com/topic/5453
[url=http://tramadols.yuku.com/topic/5452]Tramadol generic cheapest[/url]
Tramadol generic cheapest
http://tramadols.yuku.com/topic/5452
[url=http://tramadols.yuku.com/topic/5451]Tramadol no physician approval[/url]
Tramadol no physician approval
http://tramadols.yuku.com/topic/5451
[url=http://tramadols.yuku.com/topic/5450]How to get a tramadol prescription[/url]
How to get a tramadol prescription
http://tramadols.yuku.com/topic/5450
[url=http://tramadols.yuku.com/topic/5449]Tramadol online no perscription[/url]
Tramadol online no perscription
http://tramadols.yuku.com/topic/5449
[url=http://tramadols.yuku.com/topic/5448]Pharmacy tramadol no prescrption[/url]
Pharmacy tramadol no prescrption
http://tramadols.yuku.com/topic/5448
[url=http://tramadols.yuku.com/topic/5447]Tramadol with no prescriptions[/url]
Tramadol with no prescriptions
http://tramadols.yuku.com/topic/5447
[url=http://tramadols.yuku.com/topic/5446]Overnight delivery of tramadol[/url]
Overnight delivery of tramadol
http://tramadols.yuku.com/topic/5446
[url=http://tramadols.yuku.com/topic/5445]Tramadol no prescription overnight[/url]
Tramadol no prescription overnight
http://tramadols.yuku.com/topic/5445
[url=http://tramadols.yuku.com/topic/5444]Tramadol without prescription shipped overnight express[/url]
Tramadol without prescription shipped overnight express
http://tramadols.yuku.com/topic/5444
[url=http://tramadols.yuku.com/topic/5443]Overnight tramadol C.O.D[/url]
Overnight tramadol C.O.D
http://tramadols.yuku.com/topic/5443
[url=http://tramadols.yuku.com/topic/5442]Buy tramadol online consultation us[/url]
Buy tramadol online consultation us
http://tramadols.yuku.com/topic/5442
[url=http://tramadols.yuku.com/topic/5441]Buy tramadol 120 tabs[/url]
Buy tramadol 120 tabs
http://tramadols.yuku.com/topic/5441
[url=http://tramadols.yuku.com/topic/5440]U.S. pharmacies for tramadol without rx[/url]
U.S. pharmacies for tramadol without rx
http://tramadols.yuku.com/topic/5440
[url=http://tramadols.yuku.com/topic/5439]Tramadol next day cash on delivery[/url]
Tramadol next day cash on delivery
http://tramadols.yuku.com/topic/5439
[url=http://tramadols.yuku.com/topic/5438]Online tramadol COD pharmacy[/url]
Online tramadol COD pharmacy
http://tramadols.yuku.com/topic/5438
[url=http://tramadols.yuku.com/topic/5437]Purchase discount tramadol no rx[/url]
Purchase discount tramadol no rx
http://tramadols.yuku.com/topic/5437
[url=http://tramadols.yuku.com/topic/5436]Us tramadol fedex[/url]
Us tramadol fedex
http://tramadols.yuku.com/topic/5436
[url=http://tramadols.yuku.com/topic/5435]Tramadol fed ex[/url]
Tramadol fed ex
http://tramadols.yuku.com/topic/5435
[url=http://tramadols.yuku.com/topic/5434]No prescription needed tramadol[/url]
No prescription needed tramadol
http://tramadols.yuku.com/topic/5434
[url=http://tramadols.yuku.com/topic/5433]Tramadol no prescription cod[/url]
Tramadol no prescription cod
http://tramadols.yuku.com/topic/5433
[url=http://tramadols.yuku.com/topic/5432]Tramadol overnight without prescription[/url]
Tramadol overnight without prescription
http://tramadols.yuku.com/topic/5432
[url=http://tramadols.yuku.com/topic/5431]Buy tramadol overnight delivery[/url]
Buy tramadol overnight delivery
http://tramadols.yuku.com/topic/5431
[url=http://tramadols.yuku.com/topic/5430]Buy tramadol no rx cheap[/url]
Buy tramadol no rx cheap
http://tramadols.yuku.com/topic/5430
[url=http://tramadols.yuku.com/topic/5429]Tramadol no script[/url]
Tramadol no script
http://tramadols.yuku.com/topic/5429
[url=http://tramadols.yuku.com/topic/5428]Generic tramadol fedex[/url]
Generic tramadol fedex
http://tramadols.yuku.com/topic/5428
[url=http://tramadols.yuku.com/topic/5427]Cheap tramadol cash on delivery[/url]
Cheap tramadol cash on delivery
http://tramadols.yuku.com/topic/5427
[url=http://tramadols.yuku.com/topic/5426]Tramadol no dr[/url]
Tramadol no dr
http://tramadols.yuku.com/topic/5426
[url=http://tramadols.yuku.com/topic/5425]Buy tramadol on line no prescription[/url]
Buy tramadol on line no prescription
http://tramadols.yuku.com/topic/5425
[url=http://tramadols.yuku.com/topic/5424]Tramadol no prescriptions needed COD[/url]
Tramadol no prescriptions needed COD
http://tramadols.yuku.com/topic/5424
So long
MarcusTeaf
December 31st, 2009 - 07:48

Hi how do you guys plan to start the new year?

No trackbacks yet.

« Block Countries in Apache Using Wordpress header and footers externally »

Hi, I’m Kieran.

I'm a PHP programmer. I specalise in CubeCart, Wordpress, phpBB as well as custom projects.
I'm a techie, I work at Mesh Internet.

Lifestream

Graciela Miranda commented on your photo.

— 7h ago via Facebook
Christophor Rick commented on your photo.

— August 31st via Facebook
Vix Lucas commented on your photo.

— August 30th via Facebook
Stuart King commented on your photo.

— August 29th via Facebook
Stuart King and Laura Pennington ッ commented on your status.

— August 29th via Facebook
Andy Wildcard Peglion also commented on his photo.

— August 28th via Facebook
Michelle Sarky Symonds also commented on her photo.

— August 25th via Facebook
Michelle Sarky Symonds also commented on her photo.

— August 25th via Facebook
Vix Lucas commented on a photo of you.

— August 25th via Facebook
Vix Lucas commented on a photo of you.

— August 25th via Facebook

kieranbarnes do you know where your towel is?