Scripts
PayFlow Pro POST Fields Encoding
Submitted by adam on Mon, 2008-10-06 22:27.PayPal PayFlow Pro is picky and requires application/x-www-form-urlencoded as the encoding + a cURL tip
Shell Script Install Public Key
Submitted by adam on Tue, 2008-02-26 16:46.I hate installing public keys. Here's a shell script to speed up the process.
MySQL Table Size Ranker
Submitted by adam on Tue, 2008-01-15 07:20.Script for calculating table size and outputting csv results in order of largest to smallest.
Reload httpd via PHP (sorta)
Submitted by adam on Fri, 2006-10-27 10:27.The problem:
Apache forked processes (PHP, CGI, etc) runs as a different user (usually www or some variant) which doesn't have permission to restart Apache. To further compound the problem, PHP doesn't allow you to sudo to a user that does have the privileges (they call this a "security feature"). Also, if it did have the privileges, it cannot reload httpd directly because that's it's parent process.
Simple MySQL database backup
Submitted by adam on Thu, 2006-10-26 15:42.I made this script after I decided it was easier for me to do it myself than find one online. It takes a backup as often as you'd like (I set a cron for doing it hourly). The backups are saved until their modification time is 7 days old. Note, I said modification time not creation time.
