I created this to work with Linux. I use .htaccess files for some small amount of security. I would not recommend using this on a windows server (although your millage may vary). This has been tested with PHP5, and MySQL5 on Linux. You also need to have the GD image libs installed for profile and listing images to work. Make sure register_globals is off. Use at your own risk.

Download the current package for Open Auto Classifieds from Sourceforge. http://sourceforge.net/project/showfiles.php?group_id=213525 Find the file openauto_full_x.x.x.zip, where x.x.x is the current latest version.

• Unpack the files onto your local hard drive.
• Upload all the files into your public html folder on your web host except the DOCS folder.
• Set your referrers by editing the file Includes/configs/env.inc.php (most likely your domain name).
• You may need to set permissions for 6 folders Depending on your PHP and Apache setup:
  • chmod 777 admin/templates/templates_c
  • chmod 777 admin/templates/cache
  • chmod 777 templates/templates_c
  • chmod 777 templates/cache
  • chmod 777 images/users
  • chmod 777 images/listings

• Change the permissions on the error text .txt if needed.
  • chmod 666 error.txt

Once all of your files have finished uploading proceed to the install directory on your site.

• Create a database using cpanel or whichever control panel you use on your server.
• Go to http://yoursite.com/install/
• Follow the instructions.

Use this install method if you have problems with the web based installer script.

• Create a database using cpanel or whichever control panel you use on your server.
• Use the sql file located in the /install/SQL/install folder named openauto_auto.sql.
• Edit the db.inc.php file located in the /Includes/configs/ folder change the database configuration variables.

There are 6 files in the /SQL/install/ directory which contain SQL statements intended for a MySQL database (though they should work just fine for any SQL database untested). The zip code database consists of over 40,000 records which would be too large a file for many configurations of phpMyAdmin. Therefore, the data is broken into multiple files each consisting of 10,000 records, resulting in 5 data files.

You MUST import the 'openauto_auto.sql' file first if you have not already done so, then each of the data files.

• openauto_auto.sql
• zip_data_1.sql
• zip_data_2.sql
• zip_data_3.sql
• zip_data_4.sql
• zip_data_5.sql

• From phpMyAdmin, you can import these 6 files 1 at a time using the 'Import' tab.
• From the Command Line, you can import these 6 files 1 at a time following the instructions below.
• Create the database using MySQL commands from within the MySQL CLI. If you're looking for a primer on MySQL, this probably isn't the place.
  • CREATE DATABASE open_auto_db;
  • mysql open_auto_db < openauto_auto.sql (without the quotes, of course) do this for each .sql file.

If you decide to use the automated cron script you have to setup a cron job. Use one of these commands to fire off your cron once a day.

• lynx -dump http://example.com/admin/Includes/Crons/master_cron.php?access_key=<key_goes_here>
• wget -q http://example.com/admin/Includes/Crons/master_cron.php?access_key=<key_goes_here>

You need to replace example.com with your url and change the path accordingly if OAC is installed in a directory other than the root directory of your server. You need to setup an access key for the cron in the settings section when logged in as an admin and replace the <key_goes_here> with your access key.

• If you have successfully used the web based installer login with the details you provided during the install.
• If you manually setup the DB Login with default username and password and click “Edit Account” to set your email address. Next, change the default username and password. If you do not you run a risk of getting your site sacked.
  • username == admin
  • password == password

• Once logged in go to the site settings section and edit your configuration.
• You should also take the time to setup a default seller account you will be prompted to do so when adding a listing for the first time.

As of version v1.3.0b I have added in a zip code search using an existing opensource class from Micah Carrick http://www.micahcarrick.com/04-19-2005/php-zip-code-range-and-distance-calculation.html In the existing package there are some instructions to be followed I have modified them slightly to work seamlessly with my script.

If you already have a previous version installed and wish to upgrade your old version to the current version read the Upgrade Documentation.