Subversion Repositories ORC

Rev

Rev 8 | Rev 17 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 8 Rev 16
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 {