Convert phpBB IP Addresses
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).
Using WordPress header and footers externally
I needed to integrate a WordPress header (header.php) and footer (footer.php) into an external application.
There are quite a few ways round this, but none are really ideal. For example, if you want to include an external page in WordPress for whatever reason, you could use the Exec-PHP plugin. Simple, hey? No.
How to move WordPress directory or server – properly
I ran into an annoying, but easily avoided problem the other day. When moving a clients WordPress site from the development/staging area to it's live domain, I did the usual update "WordPress address" and "Blog address" in the WordPress settings.
Thats all you need to do, right? No.
WP-O-Matic Bug Fixes Round Up
I've run into quite a few issues in the latest 1.0RC3-7 release of WP-O-Matic. Here's a round up of the bug fixes and addons you need to actually this potentially useful product useful!
Also, it includes a well known MySQL bug fix.
WordPress WP-O-Matic Duplicate Posts Fix
Got a problem with WP-O-Matic creating duplicate posts? Or just WordPress in general. Me too.
I wrote a script to run on a regular basis so sort this problem out.
WP-o-Matic Upgrade Fix
So I rolled out some WP-o-Matic upgrades recently. I was all excited that version 1.0RC3-7 had been released. One upgrade went fine, one freaked out - it would run the cron fine, an improvement on the previous version, but it wouldn't process campaigns. The problem turns out to be the getCampaigns function in wpomatic.php
WP-O-Matic Cron Hangs
Does your WP-O-Matic hang sometimes when processing feeds? It's probably trying to a ping back to the original post. Chances are you don't even want it pinging back, depending on the purpose of your blog.
Crawl Rate Tracker Plugin for WordPress25
Patrick Altoft has updated the Crawl Rate Tracker Plugin for WordPress 2.5. A previous post of mine documents the plugin has major issues creating its database table on WordPress 2.5, unfortunately, it would report success causing many sites to throw some major, undetectable errors.
I'm glad to see it's been updated eventually!
Free CC Mods
Estelle has released a few CubeCart 4 modifications free of charge. Very nice of her.
She has an excellent record of releasing top quality CubeCart modifications. Her store is a must-visit for any CubeCart developer.
