NOTES: activate.php - Activates a new user’s account via email response. addpi.php - Add's a PI given a oid and user input. Requires activation by admin. addrating.php - Add's a rating given a pid. Requires activation by admin. checklogin.php - Checks the current session and cookie for login variables. Creates $login boolean as flag. db.php - Connects to and stores all database information. debug.php - Outputs all variables in $GLOBALS. delete.sql - Deletes all SQL tables. forgot_pass.php - Resets a forgotten password. login.php - This script is responsible for verifying a users login credentials. logout.php - Logs a user out of the application and terminates session. mailtest.php - Tests PHPmailer code to send email. main.php - Main page seen by user. numgen.php - Generates a verification code for the login form. register.php - Adds new users to the site. search.php - Handles organization and PI searches. selectpi.php - Show all PIs given an organization. setup.sql - Creates SQL tables and inserts default data. showratings.php - Shows all ratings given a PI. utils.php - Contains validation, email, and captcha functions. oid - organization id pid - PI id rid - rating id uid - user id QUESTIONS: - What if a PI belongs to multiple organizations? - Allow users to add organizations? TO DO: - remove image upload x - change authorization code x - login with email x - update captcha x - login/logout each pg x - use cookies x - fix password x - add pi w/ and w/o oid active/inactive x - move header code up x - create addrating.php x - add character counter x - ratings active/inactive x - admin page to review ratings and PIs x - add PI and user entry dates x - change all input tags to use < /> x - change organization search to dropdown x - fix forget_pass x - fix logout x - reset ukey upon login x - dynamic form validation for register pg - set password max > 6 chars x - flags for bad ratings - sorting of search results - use page system - add change profile/password section FUTURE: - download NED data - create maintenance page - make old ratings editable