INSTALLATION


Part 1: Database Setup
1. In order to import the large amount of data you now have, we have included our Quick Import tool. 
   The first thing you need to do is start uploading the UNCOMPRESSED csv files into the /import/data/ folder. 
   If you have access and experience you can upload the files as a .gz and use gzip to uncompress them once they are uploaded.
2. Create your database.
3. Run the included sql query (sql.txt) to set up your tables and fields

Part 2: Setting Up The Import Scripts
1. Edit the /import/importus.php file: 
Line 6 edit DB_USER and DB_PASSWORD; 
Line 7 edit DB_NAME
2. Edit the /import/index.php file:
create your user name  $user = "";
create your password  $pass = "";

Once your csv files are uploaded go to yourdomain.com/import/index.php

Enter your csv file name and the table you want it imported into.
Do this for all 51 files.


Part 3: Map script
1. Open map.php and edit line 252. You need a key for your particular domain name. Go to http://code.google.com/apis/maps/signup.html to get your key

Part 4: Database Connection
1. Edit db.php to match your database parameters

Part 5: Google AdSense Code
1. Open the following files and replace the existing Google AdSense code to match your account; 
- bp.php 
- c.php
- city.php
- citycategories.php
- index.php
- s.php
- state.php
- statecategories.php
- search.php

Part 5: Editing The Code
Open the following files. You will do a simple 'find and replace' on these files.
- c.php
- city.php
- citycategories.php
- s.php
- state.php
- statecategories.php
- search.php

1. Find http://ohioyp.com and replace with your domain name


Part 6: Create a new banner
1. Create a banner and name it bd.jpg. Overwrite the existing file.

Part 7: Upload the files
1. Upload maintaining the folder structure






END