Convert phpBB IP Addresses

Home » MySQL » Convert phpBB IP Addresses

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).

Why does perl consume my entire CPU?
I use a perl script to convert an Excel file to CSV on an Ubuntu...
Really freakin’ simple mysql virtual hosting pure-ftpd
This article will guide you through installing pure-ftpd configured for virtual hosts using mysql as...
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...
iCalendar Generation
One of my clients requested that the CRM applicationI wrote should interact with Outlook Calender....
Mini WHMCS SagePay Terminal Mod
We have a few customers that phone and pay WHMCS generated invoices over the phone...

Tagged as: CONV, IP Leave a comment

Comments (7) 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?
HogpHigreeRiz
September 21st, 2011 - 13:15

Man .. Excellent .. Amazing .. I’ll bookmark your web site and take the feeds additionallyI am glad to find a lot of useful info here within the publish, we need develop more strategies in this regard, thank you for sharing. . . . . .
toingeJet
September 23rd, 2011 - 04:04

Hello! what about ?

…

!!
?

Kieran Barnes

Independent PHP, WordPress and CubeCart programmer and consultant in Manchester, UK.
I can offer programming and consultancy for your next WordPress, Ecommerce or PHP web application.

About Kieran

Kieran is a PHP developer with 15 years commercial experience. He has a niche for all things WordPress, CubeCart and other open sourcery. With expertise in most areas of Linux and Windows wrangling makes him a good choice for supporting and consulting your next web application.

Get in Touch

97%* of customers happy with the outcome of their service ( 1,269 clients reviewed)

Sitemap (HTML)
Sitemap (XML)
Google

kieranbarnes Independent PHP, WordPress & CubeCart Programmer