The main page is located at cse.unl.edu/~upe/contest/index.php You can login by going to cse.unl.edu/~upe/contest/login.php Admin's are able to edit anything on the site (username test, password test) Site login's are only able to edit their own site (username unl, password unl) Passwords are transmitted and stored in the database somewhat securely (only the SHA2(x, 512) hash of the password is used... there might be a better way, but better than plain-text). If the page does not load right, it might be helpful to check the error log: grep upe /var/log/apache2/error_log admin.php : Stores the admin page admin_update.php : Updates the database based on the forms filled out header.php : Default header, initializes the database connection footer.php : Default footer, closes the database connection header_admin.php : The admin header, checks login information. login.php : Login form logout.php : Logs the user out of the system The view is: CREATE VIEW contest_results_latest AS SELECT * FROM contest_results WHERE rid IN (SELECT DISTINCT MAX(rid) FROM contest_results GROUP BY tid,pid)