Content last updated in May 2015.
prepare (qq{ SELECT IF(workshop_no>0,'Individual','Full') FROM registrants WHERE meeting_no=? AND member_id=? AND cancelled IS NULL AND workshop_no=0 LIMIT 1 }); $cursor->execute($meeting_no, $userID); $registration_type = $cursor->fetchrow(); $cursor->finish(); if (!$registration_type) { $cursor = $main::dbh->prepare (qq{ SELECT IF(workshop_no>0,'Individual','Full') FROM registrants WHERE meeting_no=? AND member_id=? AND cancelled IS NULL ORDER BY workshop_no DESC LIMIT 1 }); $cursor->execute($meeting_no, $userID); $registration_type = $cursor->fetchrow(); $cursor->finish(); } if ($registration_type) { SWITCH: for ($registration_type) { /Full/ && do { showAllCourses(); last SWITCH; }; /Individual/ && do { showMyCourses(); last SWITCH; }; } } sub showAllCourses { print "Wow! You have registered for the full course. Good for you.
"; $cursor = $main::dbh->prepare (qq{ SELECT workshop_no,name,speaker,description FROM meeting WHERE meeting_no=? AND workshop_no>0 ORDER BY name ASC }); $cursor->execute($meeting_no); while (@fields = $cursor->fetchrow_array()) { !>| Video: | Stream Video Now | Download Video File |
|---|---|---|
| Audio: | Stream Audio Now | Download Audio File |
| PDF: | View PDF | Download PDF File |
finish(); } sub showMyCourses { print "
You have registered for the following individual lectures. Each lecture contains a video, audio, and slide presentation. You can register for additional individual lectures at anytime by click here.
"; $cursor = $main::dbh->prepare (qq{ SELECT t1.workshop_no,name,speaker,description FROM meeting t1, registrants t2 WHERE t1.meeting_no=t2.meeting_no AND t1.workshop_no=t2.workshop_no AND t2.meeting_no=? AND t2.member_id=? ORDER BY name ASC }); $cursor->execute($meeting_no, $userID); while (@fields = $cursor->fetchrow_array()) { !>| Video: | Stream Video Now | Download Video File |
|---|---|---|
| Audio: | Stream Audio Now | Download Audio File |
| PDF: | View PDF | Download PDF File |
finish(); } !> #include ../../footer_include.iphtml