| Line 148... |
Line 148... |
| 148 |
logit ($F->{RCid}, "DB ERROR: Updating Self Details: $ERRMSG");
|
148 |
logit ($F->{RCid}, "DB ERROR: Updating Self Details: $ERRMSG");
|
| 149 |
} else {
|
149 |
} else {
|
| 150 |
logit ($F->{RCid}, "Updated User Details");
|
150 |
logit ($F->{RCid}, "Updated User Details");
|
| 151 |
}
|
151 |
}
|
| 152 |
} elsif ($AL > 1) { # A lead or higher is updating someone else's record
|
152 |
} elsif ($AL > 1) { # A lead or higher is updating someone else's record
|
| - |
|
153 |
|
| - |
|
154 |
use List::Util qw/sum/;
|
| - |
|
155 |
if (sum (values %{ convertDepartments ($F->{department}) }) > 0 and $F->{access} == 0) {
|
| - |
|
156 |
# activating a user for the first time...
|
| - |
|
157 |
$F->{access} = 1;
|
| - |
|
158 |
sendEMail ("Activate", $F);
|
| - |
|
159 |
}
|
| - |
|
160 |
|
| 153 |
if ($FORM->{password}) {
|
161 |
if ($FORM->{password}) {
|
| 154 |
# my $sth = $dbh->prepare ("replace into official (RCid, email, password, derby_name, real_name, phone, level, type, access, department, clinic_pass) values (?, ?, password(?), ?, ?, ?, ?, ?, ?, ?, ?)");
|
162 |
# my $sth = $dbh->prepare ("replace into official (RCid, email, password, derby_name, real_name, phone, level, type, access, department, clinic_pass) values (?, ?, password(?), ?, ?, ?, ?, ?, ?, ?, ?)");
|
| 155 |
# $sth->execute ($F->{RCid}, $F->{email}, $F->{password}, $F->{derby_name}, $F->{real_name}, $F->{phone}, $F->{level}, $F->{type}, $F->{access}, $F->{department}, $F->{clinic_pass})
|
163 |
# $sth->execute ($F->{RCid}, $F->{email}, $F->{password}, $F->{derby_name}, $F->{real_name}, $F->{phone}, $F->{level}, $F->{type}, $F->{access}, $F->{department}, $F->{clinic_pass})
|
| 156 |
my $sth = $dbh->prepare ("replace into official (RCid, email, password, derby_name, real_name, pronouns, tshirt, phone, access, department, added, last_login) values (?, ?, password(?), ?, ?, ?, ?, ?, ?, ?, ?, ?)");
|
164 |
my $sth = $dbh->prepare ("replace into official (RCid, email, password, derby_name, real_name, pronouns, tshirt, phone, access, department, added, last_login) values (?, ?, password(?), ?, ?, ?, ?, ?, ?, ?, ?, ?)");
|
| 157 |
$sth->execute ($F->{RCid}, $F->{email}, $F->{password}, $F->{derby_name}, $F->{real_name}, $F->{pronouns}, $F->{tshirt}, $F->{phone}, $F->{access}, $F->{department}, getUser($F->{email})->{added}, getUser($F->{email})->{last_login})
|
165 |
$sth->execute ($F->{RCid}, $F->{email}, $F->{password}, $F->{derby_name}, $F->{real_name}, $F->{pronouns}, $F->{tshirt}, $F->{phone}, $F->{access}, $F->{department}, getUser($F->{email})->{added}, getUser($F->{email})->{last_login})
|
| Line 397... |
Line 405... |
| 397 |
my $data = shift;
|
405 |
my $data = shift;
|
| 398 |
use RCMailer;
|
406 |
use RCMailer;
|
| Line 399... |
Line 407... |
| 399 |
|
407 |
|
| 400 |
my $email = $data->{email};
|
408 |
my $email = $data->{email};
|
| - |
|
409 |
my $subject = 'Officiating RollerCon Schedule Manager - New User Request';
|
| - |
|
410 |
my $body;
|
| 401 |
my $subject = 'Officiating RollerCon Schedule Manager - New User Request';
|
411 |
if ($context eq "New User") {
|
| Line 402... |
Line 412... |
| 402 |
my $body = "Greetings,
|
412 |
$body = "Greetings,
|
| Line 403... |
Line 413... |
| 403 |
|
413 |
|
| 404 |
It appears as though you've registered a new account to Officiate at RollerCon with the following information:
|
414 |
It appears as though you've registered a new account to Officiate at RollerCon with the following information:
|
| Line 414... |
Line 424... |
| 414 |
|
424 |
|
| Line 415... |
Line 425... |
| 415 |
YOU WILL NOT BE ABLE TO LOG IN UNTIL YOU RECEIVE ANOTHER EMAIL STATING YOUR ACCOUNT REQUEST HAS BEEN APPROVED!
|
425 |
YOU WILL NOT BE ABLE TO LOG IN UNTIL YOU RECEIVE ANOTHER EMAIL STATING YOUR ACCOUNT REQUEST HAS BEEN APPROVED!
|
| Line 416... |
Line 426... |
| 416 |
|
426 |
|
| - |
|
427 |
Once approved, you'll be able to log in and view the schedule and sign up for shifts. Please be considerate of others and don't hogger all of the shifts. If you do, we will find you and randomly drop your shifts.
|
| - |
|
428 |
|
| - |
|
429 |
http://volunteers.rollercon.com/schedule/
|
| - |
|
430 |
|
| Line 417... |
Line 431... |
| 417 |
Once approved, you'll be able to log in and view the schedule and sign up for shifts. Please be considerate of others and don't hogger all of the shifts. If you do, we will find you and randomly drop your shifts.
|
431 |
If you're new to using vORC, you may want to read this:
|
| Line -... |
Line 432... |
| - |
|
432 |
|
| - |
|
433 |
https://volunteers.rollercon.com/info.html
|
| - |
|
434 |
|
| - |
|
435 |
If you didn't make this request, well, you're still the only one who received this email, and you now have an account request. You should probably let us know that someone is messing with you.
|
| - |
|
436 |
|
| - |
|
437 |
-RollerCon Management
|
| - |
|
438 |
";
|
| - |
|
439 |
} elsif ($context eq "Activate") {
|
| - |
|
440 |
my $tempDepartments = convertDepartments ($data->{department});
|
| - |
|
441 |
my $printableDepartments = join "\n", map { $depts->{$_}.": ".$AccessLevel->{$tempDepartments->{$_}} } sort keys %{$tempDepartments};
|
| - |
|
442 |
$body = "Greetings again,
|
| - |
|
443 |
|
| - |
|
444 |
You have been approved to volunteer at RollerCon in the following departments:
|
| - |
|
445 |
|
| - |
|
446 |
$printableDepartments
|
| 418 |
|
447 |
|
| - |
|
448 |
You may log into vORC and begin signing up for shifts. Please be considerate of others and don't hogger all of the shifts. If you do, we will find you and randomly drop your shifts.
|
| - |
|
449 |
|
| - |
|
450 |
https://volunteers.rollercon.com/schedule/
|
| - |
|
451 |
|
| - |
|
452 |
Please note that you are limited to signing up to a limnited number of shifts per day. (Meaning, once you sign up for X shifts, you'll have to wait until tomorrow to sign up for more.) Please understand, while you are a nice, concientious, and good-looking person yourself, who knows how to share, there are others out there that will hogger up all of the shifts. As time goes by and we get closer to the event, we may lift the limit. Who knows?
|
| - |
|
453 |
|
| - |
|
454 |
If you've already signed up for your daily limit of shifts, and another shift REALLY strikes your fancy, try dropping one of your shifts. That should allow you to pick up a different one.
|
| - |
|
455 |
|
| - |
|
456 |
We'll be adding shifts over time, again to throttle how fast some people (not you, mind you) gobble up the shifts. Check back, maybe even daily.
|
| - |
|
457 |
|
| - |
|
458 |
If you're new to using vORC, you may want to read this:
|
| - |
|
459 |
|
| 419 |
http://officials.rollercon.com/schedule/
|
460 |
https://volunteers.rollercon.com/info.html
|
| - |
|
461 |
|
| - |
|
462 |
If you didn't make this request, well, you're still the only one who received this email, and you now have an active account. You should probably let us know that someone is messing with you.
|
| - |
|
463 |
|
| 420 |
|
464 |
-RollerCon Management
|
| 421 |
If you didn't make this request, well, you're still the only one who received this email, and you now have an account request. You should probably let us know that someone is messing with you.
|
465 |
";
|
| Line 422... |
Line 466... |
| 422 |
|
466 |
} else {
|