Today we had a need to convert the City and State returned from the MaxMind GEOIP1 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[2] to compare the GEOIP results with to find our zipcode. Fancy. Since we had to import the ZipCode’s into a MySQL database from a CSV file we had to figure out how to do this, and we’re archiving it here for you and for our own purposes....

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 mysql command line instead. Just login to phpmyadmin, or select the database you want to use via the cli (use databasename;)...

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 my case, it was pretty simple. I went to the control panel for my hosting, added a new database user that was allowed to connect from anywhere....

If you’re a long time follower, you probably remember my review of WFReview on my old site, Optimizing Advertising. I’ve since got rid of that god awful domain and have moved on to this wicked cool one. I’ve been using WFReview since pretty much the minute it came out. I’m running a bunch of local directory sites using it, and while I haven’t seen a million dollars in profit yet, I’ve been steadily ranking higher and higher for my niches and getting lots of legit comments to the sites and traffic is steadily increasing....

So, as you can see from my diary entry, a lot was accomplished at Affiliate Summit 2009 in New York City. While it may look like all we did was drink, which is probably pretty true, there was a lot of business conducted at the same time. And not to mention a helluva lot of networking opportunities. I met with a number of people from Wicked Fire, and a bunch of other network owners, affiliates, other people in related industries and a whole tonne of affiliate managers....