1) We created OARS to meet our needs. We share it openly with you to do with as you will. It may not meet your needs, but we hope it is of some value to you. 2) OARS was coded by a novice programmer who recognizes the code is far from perfect and could be overhauled to be cleaner and more efficient. THINGS YOU NEED TO DO 1) Unpack the oars tar file. 2) Place the oars directory in a web accessible directory on your server. We strongly urge you to locate this in a secure area of your web site. 3) Ensure your system has accessible: a) MySQL (we are running 5.0.95-log Source distribution) Other versions may cause the queries to result in errors. If errors occur, troubleshooting /proc/defInsert.php would be the place to start. b) PHP (we are running 5.3.3) c) PDO (included in later versions of PHP) 4) Make local customizations for OARS to work: a) Configure MySQL i) Create a user and password in MySQL for the use of OARS. Ensure this user and password are included in oars/proc/defInsert.php at the beginning where a note tells you to add your user name and password. ii) Ensure the host specification in oars/proc/defInsert.php reflects your system configuration. iii) Import the included dumpfile (oars/info/oarsdump.sql) to MySQL. mysql> CREATE DATABASE oars; $ mysql -u admin -p oars < oarsdump.sql iv) Grant permissions to the user you created to insert, update, and delete in the 'oars' database tables 'bib' and 'weights'. b) Access to your OARS Web site will be relative to the location where you place it: path-to-location-of-oars-folder/oars/web/entrez.php