1. Unzip the files from the .zip file.
2. Using your database administration application, execute the SQL query command found in "setup_sql.txt". This will create tables titled "keywords", "pd_users", and "pd_users_tracking" on your MySQL database. "Keywords" stores your keyword statistics data. The other two store username, password and login data. Your default username, password and email address are admin, admin and you@yoursite.com, respectively. You can change them once PageDrill is installed.
3. Upload the folder "protect" and the files config_sql.php, getkw.php, s.php, small_logo.jpg all to your root directory.
4. Modify config_sql.php with your server name, MySQL database password, MySQL database password, and database name. (Leave the table name as "keywords" since this is the name of the table created in Step 2.) Change the CHMOD permission of config_sql.php to 644.
5. Change the following parameters in /protect/functions.php: database username, database password, database host (server) and database name. Enter your site name, domain, email address and full URL to s.php.
6. Fill in your domain in the code href="http://yoursite.com/s.php" in /protect/index.php near the top of code.
7. Change the CHMOD permissions of directory /protect/ and files getkw.php and s.php to 755.
8. Add the following line of code to the end of each .php page you want to track search referrals for:
include ("getkw.php");
9. Installation is complete. PageDrill will begin logging search referral data to the database table.
10. To retrieve search history data, login to s.php with username "admin" and password "admin". (You should change the username and password to your own with the control panel.) View the
online manual for more details.
