Custom Triggers for PHP ADDT Project

Looking for someone to help provide some finishing scripting for use on school course registration site that was developed using Adobe's ADDT (aka Interakt's Kollection3). Specifically I require: A 'Custom Before Trigger' on course registration form: Compares the course ID of the selected course with the total number of existing registrations for that course in the DB. Take the returned value and subtract the value from another field in a second table. If the value returned is greater than 0, the form can be submitted and the user can register for the course. Confirm agreement on submit form: Before the form is submitted, display (using greybox if possible) an 'agreement'. User must agree or disagree. If agree, continue to submit form. If disagree, return to form with a notice. Count available registrations on course list page: Basically the same as above only on a list. Take the course ID from an array, count the existing registrations and subtract the value from a field in a second table. Display result. I will supply access to all existing pages, tables etc. ## Deliverables The scripts must be completed and emailed to me no later than Monday, February 23rd.