Subversion Repositories VORC

my $day = $dt->day_name;

my $day = $dt->day_name;

my $date = $dt->date;

my $date = $dt->date;

$ENV{SERVER_NAME} = "volunteers.rollercon.com";

$ENV{SERVER_NAME} = "volunteers.rollercon.com";

my $sth1 = $dbh->prepare("select distinct RCid from (select distinct RCId from v_shift where date = date(now()) union select distinct RCid from v_shift_announcer where date = date(now()) union select distinct RCid from v_shift_officiating where date = date(now())) t1  where RCid != '' order by RCid");

my $sth1 = $dbh->prepare("select distinct RCid from (select distinct RCId from v_shift where date = date(now()) union select distinct RCid from v_shift_announcer where date = date(now()) union select distinct RCid from v_shift_officiating where date = date(now())) t1 where RCid != '' order by cast(RCid as UNSIGNED)");

my $sth2 = $dbh->prepare("select * from (select id, date, dayofweek, location, time, role, '' as teams, type from v_shift where RCid = ? union select id, date, dayofweek, track as location, time, role, teams, gtype as type from v_shift_announcer where RCid = ? union select id, date, dayofweek, track as location, time, role, teams, gtype as type from v_shift_officiating where RCid = ?) temp where date = date(now()) order by date, time");

my $sth2 = $dbh->prepare("select * from (select id, date, dayofweek, location, time, role, '' as teams, type from v_shift where RCid = ? union select id, date, dayofweek, track as location, time, role, teams, gtype as type from v_shift_announcer where RCid = ? union select id, date, dayofweek, track as location, time, role, teams, gtype as type from v_shift_officiating where RCid = ?) temp where date = date(now()) order by date, time");

$sth1->execute();

$sth1->execute();

Here is your RollerCon Volunteer (and MVP Class) schedule for today, $day, $date.

Here is your RollerCon Volunteer (and MVP Class) schedule for today, $day, $date.

Please note that it is very important to fulfill your assigned shifts.  It is too late to drop today's shifts in the scheduling tool.  If you find you are unable to work a shift, please notify an On Duty Lead from the department you are scheduled to work (or VCI) at least 30 minutes before your shift.  Anyone who "No Show; No Calls" is at risk of losing the rest of their assigned shifts, being barred from volunteering for the rest of this year and/or beyond, and even possibly losing their badge.  (That's how big of a deal it is!)  But of course we know a lovely person such as yourself would never do that.  Right?

PLEASE DO NOT REPLY TO THIS EMAIL (unless you have actual VORC system issues).  This is an automated message, and the only person who sees replies is a system admin, not the person you probably want to message.