kieranbarnes do you know where your towel is?

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:
  • Print
  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Mixx
  • Google Bookmarks
  • Blogplay

Related posts:

  1. Really freakin’ simple mysql virtual hosting pure-ftpd
    This article will guide you through installing pure-ftpd configured for virtual hosts using mysql as...
  2. Why does perl consume my entire CPU?
    I use a perl script to convert an Excel file to CSV on an Ubuntu...
  3. 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...
  4. [Snippet] Manually reset a Wordpress password
    Wordpress stores user passwords in MD5 checksums, so using your SQL admin tool of choice...
  5. 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)
  1. 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.

  2. Hi my name is Joanna.
    I am 24 years old.
    I come from United Kingdom
    London

  3. I heard from several sources that people didnt recieve the product they bought from amazon
    is this true?

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

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


Leave a comment


No trackbacks yet.