EK Metalsmiths' Guild Scheduler

EK Metalsmiths' Guild Shield
(BACK)
This page is to allow people to sign up for teaching classes at a symposium or a schola, and similarly to schedule themselves for taking classes. Questions, suggestions, or problems using this tool should be directed to the maintainer, Lord Corwyn Ravenwing, who can be reached at webminister@ekmg.eastkingdom.org.

Events whose classes are scheduled using this tool:

\n"; $qEvent = mysql_query($sql) or die(mysql_error()); while ($rEvent = mysql_fetch_array($qEvent)) { ?>
Event Description Location Status Can Teachers
Create Classes?
Can Students
Join Classes?
 (details)


If you would like to use this tool to schedule classes for an upcoming event, please contact the Webminister.

CLASSES

Sign up to take a class!

If you see a class (or several classes) that you'd like to take in the list below, please send an email to the chancellors at to register for them. But make sure to send in your reservation for the event itself as soon as possible: unfortunately signing up for a class doesn't automatically reserve space for you at the event!
See the official event announcement for more information about the event itself.

Sign up to take a class!

It's too late to sign up on-line to take classes: be sure to come to the Class Coordinator table when you get to the event to see what changes have been made that aren't shown on this page, as well as to sign up for classes.

Volunteer to teach a class!

If you are willing to teach any subject relevant to the event theme, please click here and take a moment to fill out the form to register your class.

Volunteer to teach a class!

It's too late to sign up on-line to teach classes: come to the Class Coordinator table when you get to the event and sign up there.

Please note:
* More classes will be added Friday night as people arrive and volunteer to teach something.
* If you would like any changes to a class you are scheduled to teach, please contact us and we will correct it as soon as possible.
* Teachers, please consider bringing extra handouts for people who want to take both your course and another that conflicts with it.
* Also, teachers, if your class is scheduled opposite a class you would like to take, please tell us as soon as possible and we'll try to adjust it.
* Anyone can sign up for classes, naturally, but please be aware that teachers will be given scheduling priority for classes they want to take.
* Teachers, if you are NOT signed up for feast, and you plan on doing so, please drop the event planners a note right away so there are no surprises.
* See you there!

Class List section

\n"; $qClass = mysql_query($sql) or die(mysql_error()); while ($rClass = mysql_fetch_array($qClass)) { $locations_list = ""; $datetimes_list = ""; $sql2 = "SELECT * FROM schedule LEFT JOIN days ON (schedule.day=days.day_num) LEFT JOIN timeslots ON (schedule.day=timeslots.day_num AND schedule.start_time=timeslots.start_time) WHERE schedule.event_id = '$event_id' AND days.event_id = '$event_id' AND timeslots.event_id = '$event_id' AND class_short_name = '$rClass[class_name]' "; echo "\n"; $qSched = mysql_query($sql2) or die(mysql_error()); while ($rSched = mysql_fetch_array($qSched) ) { if ($locations_list != "") { $locations_list .= "
\n"; } if ($datetimes_list != "") { $datetimes_list .= "
\n"; } $locations_list .= str_replace(" ", " ", $rSched['location'] ); $datetimes_list .= str_replace(" ", " ", $rSched['day_abbr'] . " " . $rSched['english'] ); if ($user == "admin") { $datetimes_list .= " " . "" . "(*)" . "" . "\n"; } // endif $user } // wend rSched if ($locations_list == "") { $locations_list .= "--\n"; } if ($datetimes_list == "") { $datetimes_list .= "--\n"; } ?>
Class Name Level Teacher Length Limit Cost Location Day/Time
               
Description:
Bring with you to class:
Blank Signup Sheet Blank Schedule Sheet Class List Only  

Class Schedule section

\n"; $qLoc = mysql_query($sql) or die(mysql_error()); while ($rLoc = mysql_fetch_array($qLoc)) { $locations++; $loc_label[$locations] = $rLoc['location']; } // wend $rLoc if (! $locations) { // no list of locations means no schedule. ?>

No schedule has been created yet for the preceeding classes. Please come back when the schedule shakes itself out. Thanks.

\n"; $qDays = mysql_query($sql) or die(mysql_error()); while($rDays = mysql_fetch_array($qDays)) { $timeslots = 0; $all_loc = ""; $sql = "SELECT * FROM timeslots WHERE event_id = '$event_id' AND day_num = $rDays[day_num] "; echo "\n"; $qTime = mysql_query($sql) or die(mysql_error()); while ($rTime = mysql_fetch_array($qTime)) { $timeslots++; $time_number[$timeslots] = $rTime['start_time']; $time_label[$timeslots] = $rTime['english']; $sql = "SELECT * FROM schedule WHERE event_id = '$event_id' AND day = $rDays[day_num] AND start_time = $rTime[start_time] AND location = '*' "; $qAllLoc = mysql_query($sql) or die(mysql_error()); if ($rAllLoc = mysql_fetch_array($qAllLoc)) { $all_loc[$timeslots] = $rAllLoc['class_short_name']; } else { $all_loc[$timeslots] = ""; } } // wend $rTime ?> "; } else { ?> \n"; $qSched = mysql_query($sql) or die(mysql_error()); if ($rSched = mysql_fetch_array($qSched)) { $len = $rSched['class_length']; if ($len <= 0) { echo "\n"; $len = 1; } ?> 1) { echo "\n"; $j += $len - 1; } } else { echo "\n"; } // endif $rSched } // endif $all_loc } // next $j ?>

 
 
Error: no event named '$event' found in the database. Please contact the Webminister about this error.\n"; } // endif rEvent } // endif event blank ?>