Need a way to convert .csv files into .s...

Today we had a need to convert the City and State returned from the MaxMind GEOIP database into a ZipCode. Which, as they mention on their site is not entirely accurate using their own database and recommend to go with the iBegin Free ZIPCode database to compare the GEOIP results with to find our zipcode....

Back from Summer Vacation? Need to mass ...

So, you just came back from summer vacation and now you have 10,000 comments spread across your blogs. What do you do? Instead of paginating through 20 at a time, and taking hours to delete your comments that you’re sure are not legit anyway, you can mass delete them from phpmyadmin or from the...

Uploading Prosper202 GEOIP Database remo...

Like me, you may be hosting your Prosper 202 installation on a cheap hosting account. This may lead to issues if you want to import the GEOIP database so you can track by country. Many hosts won’t allow a file this large (20 something megabytes) via phpmyadmin. So, how do you get around this? In...