@@ -35,7 +35,7 @@ discard block |
||
35 | 35 | exit; |
36 | 36 | } |
37 | 37 | if (!isAdmin()) { |
38 | - header('Location: error.php?no=100&page='.basename($_SERVER['SCRIPT_FILENAME'])); |
|
38 | + header('Location: error.php?no=100&page=' . basename($_SERVER['SCRIPT_FILENAME'])); |
|
39 | 39 | exit; |
40 | 40 | } |
41 | 41 | |
@@ -71,7 +71,7 @@ discard block |
||
71 | 71 | if ($editskillID != '') { |
72 | 72 | $sql = ("INSERT INTO eventPeople (eventID, skillID) VALUES ('$editeventID', '$editskillID')"); |
73 | 73 | if (!mysqli_query(db(), $sql)) { |
74 | - exit('Error: '.mysqli_error(db())); |
|
74 | + exit('Error: ' . mysqli_error(db())); |
|
75 | 75 | } |
76 | 76 | |
77 | 77 | // After we have inserted the data, we want to head back to the main page |
@@ -88,7 +88,7 @@ discard block |
||
88 | 88 | |
89 | 89 | $sql = ("INSERT INTO eventPeople (eventID, skillID) VALUES ('$editeventID', '$editskillID')"); |
90 | 90 | if (!mysqli_query(db(), $sql)) { |
91 | - exit('Error: '.mysqli_error(db())); |
|
91 | + exit('Error: ' . mysqli_error(db())); |
|
92 | 92 | } |
93 | 93 | } |
94 | 94 |
@@ -27,12 +27,12 @@ discard block |
||
27 | 27 | { |
28 | 28 | $dbMailId = mailToDb($to, $subject, $message, $from, $bcc); |
29 | 29 | |
30 | - $subject = '[rota] '.$subject; |
|
30 | + $subject = '[rota] ' . $subject; |
|
31 | 31 | |
32 | 32 | $message .= "\n\n"; |
33 | - $message .= siteSettings()->getOwner()."\n"; |
|
34 | - $message .= 'Mail generated with ChurchRota V.'.siteSettings()->getVersion()."\n"; |
|
35 | - $message .= siteSettings()->getSiteUrl()."\n"; |
|
33 | + $message .= siteSettings()->getOwner() . "\n"; |
|
34 | + $message .= 'Mail generated with ChurchRota V.' . siteSettings()->getVersion() . "\n"; |
|
35 | + $message .= siteSettings()->getSiteUrl() . "\n"; |
|
36 | 36 | |
37 | 37 | $mailSentOk = false; |
38 | 38 | |
@@ -76,14 +76,14 @@ discard block |
||
76 | 76 | //rfc sais \r\n, but this makes trouble in outlook. several spaces plus \n works fine in outlook and thunderbird. |
77 | 77 | //spaces to suppress automatic removal of "unnecessary linefeeds" in outlook 2003 |
78 | 78 | $crlf = " \n"; |
79 | - $message = str_replace("\r\n", $crlf, $message); //replace crlf's |
|
79 | + $message = str_replace("\r\n", $crlf, $message); //replace crlf's |
|
80 | 80 | |
81 | 81 | //-------------------------------------------------------------------------------- |
82 | - $headers = 'From: '.$from.$crlf. |
|
83 | - 'Reply-To: '.$from.$crlf. |
|
84 | - 'Mime-Version: 1.0'.$crlf. |
|
85 | - 'Content-Type: text/plain; charset=ISO-8859-1'.$crlf; |
|
86 | - 'Content-Transfer-Encoding: quoted-printable'.$crlf; |
|
82 | + $headers = 'From: ' . $from . $crlf . |
|
83 | + 'Reply-To: ' . $from . $crlf . |
|
84 | + 'Mime-Version: 1.0' . $crlf . |
|
85 | + 'Content-Type: text/plain; charset=ISO-8859-1' . $crlf; |
|
86 | + 'Content-Transfer-Encoding: quoted-printable' . $crlf; |
|
87 | 87 | $headerSimple = $headers; |
88 | 88 | |
89 | 89 | //-------------------------------------------------------------------------------- |
@@ -92,8 +92,8 @@ discard block |
||
92 | 92 | $to = str_replace(';', ',', $to); |
93 | 93 | |
94 | 94 | if ($mail_dbg) { |
95 | - $subject = ' - Mail Debug: '.$subject; //debug output |
|
96 | - $message .= $crlf.'To: '.$to.$crlf; //debug move to to end of message |
|
95 | + $subject = ' - Mail Debug: ' . $subject; //debug output |
|
96 | + $message .= $crlf . 'To: ' . $to . $crlf; //debug move to to end of message |
|
97 | 97 | } |
98 | 98 | |
99 | 99 | //-------------------------------------------------------------------------------- |
@@ -105,13 +105,13 @@ discard block |
||
105 | 105 | foreach ($teile as $adr) { |
106 | 106 | if (preg_replace("/([a-zA-Z0-9._%+-]+)(@)([a-zA-Z0-9.-]+)(\.)([a-zA-Z]+)/i", '# # #', trim($adr)) == '# # #') { |
107 | 107 | if ($mail_dbg) { |
108 | - $message .= 'Bcc: '.trim($adr).$crlf; |
|
108 | + $message .= 'Bcc: ' . trim($adr) . $crlf; |
|
109 | 109 | } else { |
110 | - $headers .= 'Bcc: '.trim($adr).$crlf; |
|
110 | + $headers .= 'Bcc: ' . trim($adr) . $crlf; |
|
111 | 111 | } |
112 | 112 | $i = $i + 1; |
113 | 113 | } else { |
114 | - $bcc_err .= $adr.$crlf; |
|
114 | + $bcc_err .= $adr . $crlf; |
|
115 | 115 | $err .= +1; |
116 | 116 | } |
117 | 117 | } |
@@ -144,10 +144,10 @@ discard block |
||
144 | 144 | if ($mailOk) { |
145 | 145 | //mail($from, "[ChurchRota] Mail status - OK", "address ok: " . $i, $headerSimple); |
146 | 146 | } else { |
147 | - mail($from, '[Rota] Mail status - ERROR', 'to: '.$to.$crlf.'address ok: '.$i.$crlf.'address errors: '.$err.$crlf.$bcc_err, $headerSimple); |
|
147 | + mail($from, '[Rota] Mail status - ERROR', 'to: ' . $to . $crlf . 'address ok: ' . $i . $crlf . 'address errors: ' . $err . $crlf . $bcc_err, $headerSimple); |
|
148 | 148 | |
149 | 149 | return false; |
150 | - logFailedMailWithId($dbMailId, 'address ok: '.$i.$crlf.'address errors: '.$err.$crlf.$bcc_err, $headerSimple); |
|
150 | + logFailedMailWithId($dbMailId, 'address ok: ' . $i . $crlf . 'address errors: ' . $err . $crlf . $bcc_err, $headerSimple); |
|
151 | 151 | } |
152 | 152 | } |
153 | 153 | |
@@ -204,9 +204,9 @@ discard block |
||
204 | 204 | } |
205 | 205 | $categoryname = $row['categoryname']; |
206 | 206 | $to = $row['email']; |
207 | - $subject = 'New post: '.$objectname; |
|
207 | + $subject = 'New post: ' . $objectname; |
|
208 | 208 | |
209 | - $finalmessage = 'Dear '.$postname."\n \n".$message.$objectname."\n \n". |
|
209 | + $finalmessage = 'Dear ' . $postname . "\n \n" . $message . $objectname . "\n \n" . |
|
210 | 210 | 'To see the post, please login using your username and password'; |
211 | 211 | |
212 | 212 | sendMail($to, $subject, $finalmessage, $row['siteadmin']); |
@@ -226,19 +226,19 @@ discard block |
||
226 | 226 | |
227 | 227 | $message = siteSettings()->getNewUserMessage(); |
228 | 228 | |
229 | - $name = $user->firstName.' '.$user->lastName; |
|
229 | + $name = $user->firstName . ' ' . $user->lastName; |
|
230 | 230 | $message = str_replace('[name]', $name, $message); |
231 | 231 | $message = str_replace('[username]', $user->username, $message); |
232 | 232 | $message = str_replace('[password]', $password, $message); |
233 | 233 | $message = str_replace('[siteurl]', siteSettings()->getSiteUrl(), $message); |
234 | 234 | |
235 | - $subject = 'Account created for '.$name; |
|
235 | + $subject = 'Account created for ' . $name; |
|
236 | 236 | |
237 | - $to = $name.' <'.$user->email.'>'; |
|
238 | - $from = siteSettings()->getOwner().' <'.siteSettings()->getAdminEmailAddress().'>'; |
|
237 | + $to = $name . ' <' . $user->email . '>'; |
|
238 | + $from = siteSettings()->getOwner() . ' <' . siteSettings()->getAdminEmailAddress() . '>'; |
|
239 | 239 | |
240 | 240 | sendMail($to, $subject, $message, $from); |
241 | - sendMail($from, 'ADMIN COPY: '.$subject, $message, $from); |
|
241 | + sendMail($from, 'ADMIN COPY: ' . $subject, $message, $from); |
|
242 | 242 | } |
243 | 243 | |
244 | 244 | function parseEmailTemplate($message, $values) |
@@ -249,7 +249,7 @@ discard block |
||
249 | 249 | $values['siteemail'] = siteSettings()->getAdminEmailAddress(); |
250 | 250 | |
251 | 251 | foreach ($values as $template_field => $value) { |
252 | - $message = str_ireplace('['.$template_field.']', trim($value), $message); |
|
252 | + $message = str_ireplace('[' . $template_field . ']', trim($value), $message); |
|
253 | 253 | } |
254 | 254 | $message = trim($message); |
255 | 255 | |
@@ -265,7 +265,7 @@ discard block |
||
265 | 265 | $message = str_replace('[rehearsal]', $rehearsal, $message); |
266 | 266 | if (is_array($rotaoutput)) { |
267 | 267 | foreach ($rotaoutput as $key => $skill) { |
268 | - $skillfinal = $skillfinal.$skill.' '; |
|
268 | + $skillfinal = $skillfinal . $skill . ' '; |
|
269 | 269 | } |
270 | 270 | } else { |
271 | 271 | $skillfinal = $rotaoutput; |
@@ -284,7 +284,7 @@ discard block |
||
284 | 284 | function notifyIndividual($userID, $eventID, $skillID) |
285 | 285 | { |
286 | 286 | notifyEveryoneForEvent($eventID, $skillID, $userID); |
287 | - $eventID = 0; //disables following code through empty sql result |
|
287 | + $eventID = 0; //disables following code through empty sql result |
|
288 | 288 | |
289 | 289 | $sql = "SELECT *, |
290 | 290 | (SELECT CONCAT(`firstname`, ' ', `lastname`) FROM users WHERE `users`.id = `skills`.`userID` ORDER BY `users`.firstname) AS `name`, |
@@ -325,13 +325,13 @@ discard block |
||
325 | 325 | if (($row['eventRehearsal'] == '0') or ($row['eventRehearsalChange'] == '1')) { |
326 | 326 | $rehearsal = $row['norehearsalemail']; |
327 | 327 | } else { |
328 | - $rehearsal = $row['yesrehearsal'].' on '.$rehearsaldate.' at '.$location; |
|
328 | + $rehearsal = $row['yesrehearsal'] . ' on ' . $rehearsaldate . ' at ' . $location; |
|
329 | 329 | } |
330 | 330 | } |
331 | 331 | |
332 | 332 | $skill = $row['category']; |
333 | 333 | if ($row['joinedskill'] != '') { |
334 | - $skill = $skill.' - '.$row['joinedskill']; |
|
334 | + $skill = $skill . ' - ' . $row['joinedskill']; |
|
335 | 335 | } else { |
336 | 336 | // If there is no skill, then we don't need to mention this fact. |
337 | 337 | } |
@@ -347,7 +347,7 @@ discard block |
||
347 | 347 | $location = $row['eventLocationFormatted']; |
348 | 348 | $rotaoutput = $skill; |
349 | 349 | $to = $row['email']; |
350 | - $subject = 'Rota reminder: '.$date; |
|
350 | + $subject = 'Rota reminder: ' . $date; |
|
351 | 351 | |
352 | 352 | $message = emailTemplate($message, $name, $date, $location, $rehearsal, $rotaoutput, $username, $siteurl); |
353 | 353 | |
@@ -418,9 +418,9 @@ discard block |
||
418 | 418 | |
419 | 419 | $type = $ob->eventType; |
420 | 420 | |
421 | - $eventdetails = $eventrow['eventGroup'].': '.$eventrow['sermonTitle']; |
|
421 | + $eventdetails = $eventrow['eventGroup'] . ': ' . $eventrow['sermonTitle']; |
|
422 | 422 | if (!empty($eventrow['bibleVerse'])) { |
423 | - $eventdetails .= ' ('.$eventrow['bibleVerse'].')'; |
|
423 | + $eventdetails .= ' (' . $eventrow['bibleVerse'] . ')'; |
|
424 | 424 | } |
425 | 425 | } |
426 | 426 | |
@@ -444,7 +444,7 @@ discard block |
||
444 | 444 | if (($roleRow['name'] == '') || ($roleRow['name'] == $roleRow['description'])) { |
445 | 445 | $roles[] = $roleRow['description']; |
446 | 446 | } else { |
447 | - $roles[] = $roleRow['description'].' - '.$roleRow['name']; |
|
447 | + $roles[] = $roleRow['description'] . ' - ' . $roleRow['name']; |
|
448 | 448 | } |
449 | 449 | } |
450 | 450 | |
@@ -464,11 +464,11 @@ discard block |
||
464 | 464 | $message = siteSettings()->getNotificationEmail(); |
465 | 465 | $rotaoutput = implode(', ', $roles); |
466 | 466 | |
467 | - $to = $ob->name.' <'.$ob->email.'>'; |
|
468 | - $from = siteSettings()->getOwner().' <'.siteSettings()->getAdminEmailAddress().'>'; |
|
467 | + $to = $ob->name . ' <' . $ob->email . '>'; |
|
468 | + $from = siteSettings()->getOwner() . ' <' . siteSettings()->getAdminEmailAddress() . '>'; |
|
469 | 469 | |
470 | 470 | //$subject = "Rota reminder: " . $date; |
471 | - $subject = 'Reminder: '.implode(', ', $roles).' - '.$type.': '.$date; |
|
471 | + $subject = 'Reminder: ' . implode(', ', $roles) . ' - ' . $type . ': ' . $date; |
|
472 | 472 | |
473 | 473 | $rotadetails = getEventDetails($eventId, "\r\n", 0, false, "\t"); |
474 | 474 | |
@@ -503,7 +503,7 @@ discard block |
||
503 | 503 | ep.notified = 1 |
504 | 504 | WHERE |
505 | 505 | ep.eventId = '$eventId' |
506 | - AND ur.userId IN (".implode(', ', $countarray).')'; |
|
506 | + AND ur.userId IN (" . implode(', ', $countarray) . ')'; |
|
507 | 507 | |
508 | 508 | mysqli_query(db(), $sql) or exit(mysqli_error(db())); |
509 | 509 | } |
@@ -532,14 +532,14 @@ discard block |
||
532 | 532 | $user = mysqli_fetch_object($result); |
533 | 533 | |
534 | 534 | if (!$user->email) { |
535 | - return 'No email address present for '.$user->firstName.' '.$user->lastName; |
|
535 | + return 'No email address present for ' . $user->firstName . ' ' . $user->lastName; |
|
536 | 536 | } |
537 | 537 | |
538 | 538 | if (!$user->recieveReminderEmails) { |
539 | - return $user->firstName.' '.$user->lastName.' opted not to recieve reminder emails'; |
|
539 | + return $user->firstName . ' ' . $user->lastName . ' opted not to recieve reminder emails'; |
|
540 | 540 | } |
541 | 541 | |
542 | - $name = $user->firstName.' '.$user->lastName; |
|
542 | + $name = $user->firstName . ' ' . $user->lastName; |
|
543 | 543 | |
544 | 544 | //line seperator for mails |
545 | 545 | //rfc sais \r\n, but this makes trouble in outlook. several spaces plus \n works fine in outlook and thunderbird. |
@@ -572,7 +572,7 @@ discard block |
||
572 | 572 | $eventDetails .= ' - '; |
573 | 573 | $eventDetails .= "\r\n"; |
574 | 574 | $eventDetails .= $event->type; |
575 | - $eventDetails .= $event->eventGroup.': '.$event->sermonTitle.' ('.$event->bibleVerse.')'; |
|
575 | + $eventDetails .= $event->eventGroup . ': ' . $event->sermonTitle . ' (' . $event->bibleVerse . ')'; |
|
576 | 576 | $eventDetails .= "\r\n"; |
577 | 577 | $eventDetails .= "\r\n"; |
578 | 578 | |
@@ -596,7 +596,7 @@ discard block |
||
596 | 596 | 'event.type' => $event->type, |
597 | 597 | 'event.location' => $event->location, |
598 | 598 | |
599 | - 'event.sermon' => $event->eventGroup.': '.$event->sermonTitle.' ('.$event->bibleVerse.')', |
|
599 | + 'event.sermon' => $event->eventGroup . ': ' . $event->sermonTitle . ' (' . $event->bibleVerse . ')', |
|
600 | 600 | 'event.sermon.name' => $event->sermonTitle, |
601 | 601 | 'event.sermon.series' => $event->eventGroup, |
602 | 602 | 'event.sermon.verse' => $event->bibleVerse, |
@@ -610,8 +610,8 @@ discard block |
||
610 | 610 | |
611 | 611 | //$message = str_replace("\r\n",$crlf,$message); |
612 | 612 | |
613 | - $to = $name.' <'.$user->email.'>'; |
|
614 | - $from = siteSettings()->getOwner().' <'.$siteSettings()->getAdminEmailAddress().'>'; |
|
613 | + $to = $name . ' <' . $user->email . '>'; |
|
614 | + $from = siteSettings()->getOwner() . ' <' . $siteSettings()->getAdminEmailAddress() . '>'; |
|
615 | 615 | |
616 | 616 | $sent = false; |
617 | 617 | $sent = sendMail($to, $subject, $message, $from); |
@@ -619,10 +619,10 @@ discard block |
||
619 | 619 | if ($sent == true) { |
620 | 620 | return true; |
621 | 621 | } else { |
622 | - return 'Error while sending mail to '.$user->firstName.' '.$user->lastName; |
|
622 | + return 'Error while sending mail to ' . $user->firstName . ' ' . $user->lastName; |
|
623 | 623 | } |
624 | 624 | |
625 | - return 'Unknown error for '.$user->firstName.' '.$user->lastName; |
|
625 | + return 'Unknown error for ' . $user->firstName . ' ' . $user->lastName; |
|
626 | 626 | } |
627 | 627 | |
628 | 628 | function getEventEmailSubject($eventId) |
@@ -669,16 +669,16 @@ discard block |
||
669 | 669 | $result = mysqli_query(db(), $sql) or exit(mysqli_error(db())); |
670 | 670 | $groupNames = ''; |
671 | 671 | while ($group = mysqli_fetch_object($result)) { |
672 | - $groupNames .= $group->name.', '; |
|
672 | + $groupNames .= $group->name . ', '; |
|
673 | 673 | } |
674 | 674 | |
675 | 675 | if (isset($errors)) { |
676 | - createNotificationForUser($_SESSION['userid'], 'Email sent with warnings', 'Email sent to '.$groupNames.' groups with errors: '.implode(', ', $errors), 'email'); |
|
676 | + createNotificationForUser($_SESSION['userid'], 'Email sent with warnings', 'Email sent to ' . $groupNames . ' groups with errors: ' . implode(', ', $errors), 'email'); |
|
677 | 677 | |
678 | 678 | return $errors; |
679 | 679 | } |
680 | 680 | |
681 | - createNotificationForUser($_SESSION['userid'], 'Group email sent', 'Email sent successfully to '.$groupNames, 'email'); |
|
681 | + createNotificationForUser($_SESSION['userid'], 'Group email sent', 'Email sent successfully to ' . $groupNames, 'email'); |
|
682 | 682 | |
683 | 683 | return $true; |
684 | 684 | } |
@@ -730,16 +730,16 @@ discard block |
||
730 | 730 | $result = mysqli_query(db(), $sql) or exit(mysqli_error(db())); |
731 | 731 | $groupNames = ''; |
732 | 732 | while ($group = mysqli_fetch_object($result)) { |
733 | - $groupNames .= $group->name.', '; |
|
733 | + $groupNames .= $group->name . ', '; |
|
734 | 734 | } |
735 | 735 | |
736 | 736 | if (isset($errors)) { |
737 | - createNotificationForUser($_SESSION['userid'], 'Email sent with warnings', 'Email sent to '.$groupNames." groups with errors: \n- ".implode("\n- ", $errors), 'email'); |
|
737 | + createNotificationForUser($_SESSION['userid'], 'Email sent with warnings', 'Email sent to ' . $groupNames . " groups with errors: \n- " . implode("\n- ", $errors), 'email'); |
|
738 | 738 | |
739 | 739 | return $errors; |
740 | 740 | } |
741 | 741 | |
742 | - createNotificationForUser($_SESSION['userid'], 'Group email sent', 'Email sent successfully to '.$groupNames, 'email'); |
|
742 | + createNotificationForUser($_SESSION['userid'], 'Group email sent', 'Email sent successfully to ' . $groupNames, 'email'); |
|
743 | 743 | |
744 | 744 | return $true; |
745 | 745 | } |
@@ -755,14 +755,14 @@ discard block |
||
755 | 755 | $user = mysqli_fetch_object($result); |
756 | 756 | |
757 | 757 | if (!$user->email) { |
758 | - return 'No email address present for '.$user->firstName.' '.$user->lastName; |
|
758 | + return 'No email address present for ' . $user->firstName . ' ' . $user->lastName; |
|
759 | 759 | } |
760 | 760 | |
761 | 761 | if (!$user->isOverviewRecipient) { |
762 | - return $user->firstName.' '.$user->lastName.' opted not to recieve group emails'; |
|
762 | + return $user->firstName . ' ' . $user->lastName . ' opted not to recieve group emails'; |
|
763 | 763 | } |
764 | 764 | |
765 | - $name = $user->firstName.' '.$user->lastName; |
|
765 | + $name = $user->firstName . ' ' . $user->lastName; |
|
766 | 766 | |
767 | 767 | //line seperator for mails |
768 | 768 | //rfc sais \r\n, but this makes trouble in outlook. several spaces plus \n works fine in outlook and thunderbird. |
@@ -825,8 +825,8 @@ discard block |
||
825 | 825 | |
826 | 826 | //$message = str_replace("\r\n",$crlf,$message); |
827 | 827 | |
828 | - $to = $name.' <'.$user->email.'>'; |
|
829 | - $from = siteSettings()->getOwner().' <'.$siteadmin.'>'; |
|
828 | + $to = $name . ' <' . $user->email . '>'; |
|
829 | + $from = siteSettings()->getOwner() . ' <' . $siteadmin . '>'; |
|
830 | 830 | |
831 | 831 | $sent = false; |
832 | 832 | $sent = sendMail($to, $subject, $message, $from); |
@@ -834,10 +834,10 @@ discard block |
||
834 | 834 | if ($sent == true) { |
835 | 835 | return true; |
836 | 836 | } else { |
837 | - return 'Error while sending mail to '.$user->firstName.' '.$user->lastName; |
|
837 | + return 'Error while sending mail to ' . $user->firstName . ' ' . $user->lastName; |
|
838 | 838 | } |
839 | 839 | |
840 | - return 'Unknown error for '.$user->firstName.' '.$user->lastName; |
|
840 | + return 'Unknown error for ' . $user->firstName . ' ' . $user->lastName; |
|
841 | 841 | } |
842 | 842 | |
843 | 843 | // returns either true, or error message string |
@@ -850,14 +850,14 @@ discard block |
||
850 | 850 | $user = mysqli_fetch_object($result); |
851 | 851 | |
852 | 852 | if (!$user->email) { |
853 | - return 'No email address present for '.$user->firstName.' '.$user->lastName; |
|
853 | + return 'No email address present for ' . $user->firstName . ' ' . $user->lastName; |
|
854 | 854 | } |
855 | 855 | |
856 | 856 | if (!$user->isOverviewRecipient) { |
857 | - return $user->firstName.' '.$user->lastName.' opted not to recieve group emails'; |
|
857 | + return $user->firstName . ' ' . $user->lastName . ' opted not to recieve group emails'; |
|
858 | 858 | } |
859 | 859 | |
860 | - $name = $user->firstName.' '.$user->lastName; |
|
860 | + $name = $user->firstName . ' ' . $user->lastName; |
|
861 | 861 | |
862 | 862 | //line seperator for mails |
863 | 863 | //rfc sais \r\n, but this makes trouble in outlook. several spaces plus \n works fine in outlook and thunderbird. |
@@ -890,7 +890,7 @@ discard block |
||
890 | 890 | } |
891 | 891 | |
892 | 892 | if (!isset($events)) { |
893 | - return $name.' has no events in the upcoming rota'; |
|
893 | + return $name . ' has no events in the upcoming rota'; |
|
894 | 894 | } |
895 | 895 | |
896 | 896 | $events = implode(', ', $events); |
@@ -943,7 +943,7 @@ discard block |
||
943 | 943 | |
944 | 944 | $eventDetails .= $row['joinedskills']; |
945 | 945 | $eventDetails .= "\r\n"; |
946 | - $eventDetails .= 'Notes: '.$row['comment']; |
|
946 | + $eventDetails .= 'Notes: ' . $row['comment']; |
|
947 | 947 | $eventDetails .= "\r\n"; |
948 | 948 | $eventDetails .= "\r\n"; |
949 | 949 | } |
@@ -959,8 +959,8 @@ discard block |
||
959 | 959 | |
960 | 960 | //$message = str_replace("\r\n",$crlf,$message); |
961 | 961 | |
962 | - $to = $name.' <'.$user->email.'>'; |
|
963 | - $from = siteSettings()->getOwner().' <'.$siteadmin.'>'; |
|
962 | + $to = $name . ' <' . $user->email . '>'; |
|
963 | + $from = siteSettings()->getOwner() . ' <' . $siteadmin . '>'; |
|
964 | 964 | |
965 | 965 | $sent = false; |
966 | 966 | $sent = sendMail($to, $subject, $message, $from); |
@@ -968,10 +968,10 @@ discard block |
||
968 | 968 | if ($sent == true) { |
969 | 969 | return true; |
970 | 970 | } else { |
971 | - return 'Error while sending mail to '.$user->firstName.' '.$user->lastName; |
|
971 | + return 'Error while sending mail to ' . $user->firstName . ' ' . $user->lastName; |
|
972 | 972 | } |
973 | 973 | |
974 | - return 'Unknown error for '.$user->firstName.' '.$user->lastName; |
|
974 | + return 'Unknown error for ' . $user->firstName . ' ' . $user->lastName; |
|
975 | 975 | } |
976 | 976 | |
977 | 977 | function notifyAttack($fileName, $attackType, $attackerID) |
@@ -986,10 +986,10 @@ discard block |
||
986 | 986 | |
987 | 987 | while ($row = mysqli_fetch_array($userresult, MYSQLI_ASSOC)) { |
988 | 988 | $subject = 'SECURITY-ALERT - Attack blocked successfully'; |
989 | - $message = "Type:\t\t ".$attackType."<br>\r\n". |
|
990 | - "Attacker:\t ".$row[name]."<br>\r\n". |
|
991 | - "Date:\t\t ".date('Y-m-d H:i:s')."<br>\r\n". |
|
992 | - "Script:\t\t ".$fileName."\r\n "."<br>\r\n"; |
|
989 | + $message = "Type:\t\t " . $attackType . "<br>\r\n" . |
|
990 | + "Attacker:\t " . $row[name] . "<br>\r\n" . |
|
991 | + "Date:\t\t " . date('Y-m-d H:i:s') . "<br>\r\n" . |
|
992 | + "Script:\t\t " . $fileName . "\r\n " . "<br>\r\n"; |
|
993 | 993 | |
994 | 994 | //$headers = 'From: ' . $row['siteadmin'] . "\r\n" . |
995 | 995 | //'Reply-To: ' . $row['siteadmin'] . "\r\n"; |
@@ -999,8 +999,8 @@ discard block |
||
999 | 999 | //mail($to, $subject, strip_tags($message), $headers); |
1000 | 1000 | sendMail($to, $subject, strip_tags($message), $to); |
1001 | 1001 | |
1002 | - echo $subject.'<br><br>'; |
|
1003 | - echo $message.'<br>'; |
|
1002 | + echo $subject . '<br><br>'; |
|
1003 | + echo $message . '<br>'; |
|
1004 | 1004 | echo 'An email about this incident was sent to administrator!'; |
1005 | 1005 | } |
1006 | 1006 | } |
@@ -1015,11 +1015,11 @@ discard block |
||
1015 | 1015 | $userresult = mysqli_query(db(), $sql) or exit(mysqli_error(db())); |
1016 | 1016 | |
1017 | 1017 | while ($row = mysqli_fetch_array($userresult, MYSQLI_ASSOC)) { |
1018 | - $subject = 'Info - '.$infoMsg.' - '.$row[name]; |
|
1019 | - $message = "Type:\t\t ".$infoMsg."<br>\r\n". |
|
1020 | - "User:\t\t ".$row[name]."<br>\r\n". |
|
1021 | - "Date:\t\t ".date('Y-m-d H:i:s')."<br>\r\n". |
|
1022 | - "Script:\t\t ".$fileName."\r\n "."<br>\r\n"; |
|
1018 | + $subject = 'Info - ' . $infoMsg . ' - ' . $row[name]; |
|
1019 | + $message = "Type:\t\t " . $infoMsg . "<br>\r\n" . |
|
1020 | + "User:\t\t " . $row[name] . "<br>\r\n" . |
|
1021 | + "Date:\t\t " . date('Y-m-d H:i:s') . "<br>\r\n" . |
|
1022 | + "Script:\t\t " . $fileName . "\r\n " . "<br>\r\n"; |
|
1023 | 1023 | |
1024 | 1024 | //$headers = 'From: ' . $row['siteadmin'] . "\r\n" . |
1025 | 1025 | //'Reply-To: ' . $row['siteadmin'] . "\r\n"; |
@@ -1036,7 +1036,7 @@ discard block |
||
1036 | 1036 | if (preg_match("/(\{\{)((.)+){1}(\}\})/", $message, $matches) == 1) { |
1037 | 1037 | $defaultSubject = $matches[2]; |
1038 | 1038 | //$subject = str_replace(array("{{","}}"),"",$matches[0]); |
1039 | - $message = str_replace($matches[1].$matches[2].$matches[4], '', $message); |
|
1039 | + $message = str_replace($matches[1] . $matches[2] . $matches[4], '', $message); |
|
1040 | 1040 | //$message = $matches[4]; |
1041 | 1041 | |
1042 | 1042 | //$message = $message . "\r\n\r\n"; |
@@ -2,10 +2,10 @@ discard block |
||
2 | 2 | |
3 | 3 | namespace TechWilk\Rota; |
4 | 4 | |
5 | -include __DIR__.'/../../../config/database.php'; |
|
6 | -include __DIR__.'/../../../config/auth.php'; |
|
7 | -include __DIR__.'/../../../config/email.php'; |
|
8 | -include __DIR__.'/../../../config/recording.php'; |
|
5 | +include __DIR__ . '/../../../config/database.php'; |
|
6 | +include __DIR__ . '/../../../config/auth.php'; |
|
7 | +include __DIR__ . '/../../../config/email.php'; |
|
8 | +include __DIR__ . '/../../../config/recording.php'; |
|
9 | 9 | |
10 | 10 | // -- Setup database -- |
11 | 11 | |
@@ -17,10 +17,10 @@ discard block |
||
17 | 17 | } |
18 | 18 | |
19 | 19 | // Connect to the database server |
20 | -$dbh = @mysqli_connect($config['db']['host'], $config['db']['user'], $config['db']['pass']) or exit('Connection to '.$config['db']['host']." with login '".$config['db']['user']."'/'$pwdMasked' failed."); |
|
20 | +$dbh = @mysqli_connect($config['db']['host'], $config['db']['user'], $config['db']['pass']) or exit('Connection to ' . $config['db']['host'] . " with login '" . $config['db']['user'] . "'/'$pwdMasked' failed."); |
|
21 | 21 | |
22 | 22 | // Choose the right database |
23 | -$db = @mysqli_select_db($dbh, $config['db']['dbname']) or exit("Connection made, but database '".$config['db']['dbname']."' was not found."); |
|
23 | +$db = @mysqli_select_db($dbh, $config['db']['dbname']) or exit("Connection made, but database '" . $config['db']['dbname'] . "' was not found."); |
|
24 | 24 | |
25 | 25 | // allow config to be fetched in functions |
26 | 26 |
@@ -23,9 +23,9 @@ discard block |
||
23 | 23 | // Start of API |
24 | 24 | // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
25 | 25 | |
26 | - require_once __DIR__.'/../../../vendor/autoload.php'; |
|
26 | + require_once __DIR__ . '/../../../vendor/autoload.php'; |
|
27 | 27 | |
28 | - require_once __DIR__.'/../../../generated-conf/config.php'; |
|
28 | + require_once __DIR__ . '/../../../generated-conf/config.php'; |
|
29 | 29 | |
30 | 30 | // Create and configure Slim app |
31 | 31 | $app = new \Slim\App(['settings' => $config]); |
@@ -36,7 +36,7 @@ discard block |
||
36 | 36 | |
37 | 37 | $container = $app->getContainer(); |
38 | 38 | |
39 | - $container['db'] = function ($c) { |
|
39 | + $container['db'] = function($c) { |
|
40 | 40 | $db_config = $c['settings']['db']; |
41 | 41 | $db = new Database($db_config); |
42 | 42 | |
@@ -49,7 +49,7 @@ discard block |
||
49 | 49 | |
50 | 50 | // ~~~~~~~~~~~~~~~ Series ~~~~~~~~~~~~~~~ |
51 | 51 | |
52 | - $app->post('/series', function ($request, $response, $args) { |
|
52 | + $app->post('/series', function($request, $response, $args) { |
|
53 | 53 | $postData = $request->getParsedBody(); |
54 | 54 | |
55 | 55 | $name = filter_var($postData['name'], FILTER_SANITIZE_STRING); |
@@ -1,6 +1,6 @@ discard block |
||
1 | 1 | <?php |
2 | 2 | |
3 | -require __DIR__.'/../config/database.php'; |
|
3 | +require __DIR__ . '/../config/database.php'; |
|
4 | 4 | $serviceContainer = \Propel\Runtime\Propel::getServiceContainer(); |
5 | 5 | $serviceContainer->checkVersion('2.0.0-dev'); |
6 | 6 | |
@@ -8,7 +8,7 @@ discard block |
||
8 | 8 | $manager = new \Propel\Runtime\Connection\ConnectionManagerSingle(); |
9 | 9 | $manager->setConfiguration([ |
10 | 10 | 'classname' => 'Propel\\Runtime\\Connection\\ConnectionWrapper', |
11 | - 'dsn' => 'mysql:host='.$config['db']['host'].';dbname='.$config['db']['dbname'], |
|
11 | + 'dsn' => 'mysql:host=' . $config['db']['host'] . ';dbname=' . $config['db']['dbname'], |
|
12 | 12 | 'user' => $config['db']['user'], |
13 | 13 | 'password' => $config['db']['pass'], |
14 | 14 | 'attributes' => [ |
@@ -114,7 +114,7 @@ discard block |
||
114 | 114 | */ |
115 | 115 | public function getName() |
116 | 116 | { |
117 | - return $this->firstname.' '.$this->lastname; |
|
117 | + return $this->firstname . ' ' . $this->lastname; |
|
118 | 118 | } |
119 | 119 | |
120 | 120 | /** |
@@ -133,16 +133,16 @@ discard block |
||
133 | 133 | if ($socialAuth->getPlatform() == 'facebook') { |
134 | 134 | switch ($size) { |
135 | 135 | case 'small': // 50px x 50px |
136 | - return '//graph.facebook.com/'.$socialAuth->getSocialId().'/picture?type=square'; |
|
136 | + return '//graph.facebook.com/' . $socialAuth->getSocialId() . '/picture?type=square'; |
|
137 | 137 | break; |
138 | 138 | case 'medium': // 200px x 200px |
139 | - return '//graph.facebook.com/'.$socialAuth->getSocialId().'/picture?type=large'; |
|
139 | + return '//graph.facebook.com/' . $socialAuth->getSocialId() . '/picture?type=large'; |
|
140 | 140 | break; |
141 | 141 | case 'large': // 200px x 200px |
142 | - return '//graph.facebook.com/'.$socialAuth->getSocialId().'/picture?type=large'; |
|
142 | + return '//graph.facebook.com/' . $socialAuth->getSocialId() . '/picture?type=large'; |
|
143 | 143 | break; |
144 | 144 | default: |
145 | - return '//graph.facebook.com/'.$socialAuth->getSocialId().'/picture'; |
|
145 | + return '//graph.facebook.com/' . $socialAuth->getSocialId() . '/picture'; |
|
146 | 146 | break; |
147 | 147 | } |
148 | 148 | } elseif ($socialAuth->getPlatform() == 'onebody') { |
@@ -155,16 +155,16 @@ discard block |
||
155 | 155 | $extension = pathinfo($socialAuth->getMeta()['photo-file-name'], PATHINFO_EXTENSION); |
156 | 156 | switch ($size) { |
157 | 157 | case 'small': // 50px x 50px |
158 | - return $baseUrl.'/system/production/people/photos/'.$socialAuth->getSocialId().'/tn/'.$photoFingerprint.'.'.$extension; |
|
158 | + return $baseUrl . '/system/production/people/photos/' . $socialAuth->getSocialId() . '/tn/' . $photoFingerprint . '.' . $extension; |
|
159 | 159 | break; |
160 | 160 | case 'medium': // 150px x 150px |
161 | - return $baseUrl.'/system/production/people/photos/'.$socialAuth->getSocialId().'/small/'.$photoFingerprint.'.'.$extension; |
|
161 | + return $baseUrl . '/system/production/people/photos/' . $socialAuth->getSocialId() . '/small/' . $photoFingerprint . '.' . $extension; |
|
162 | 162 | break; |
163 | 163 | case 'large': // 500px x 500px |
164 | - return $baseUrl.'/system/production/people/photos/'.$socialAuth->getSocialId().'/medium/'.$photoFingerprint.'.'.$extension; |
|
164 | + return $baseUrl . '/system/production/people/photos/' . $socialAuth->getSocialId() . '/medium/' . $photoFingerprint . '.' . $extension; |
|
165 | 165 | break; |
166 | 166 | default: |
167 | - return $baseUrl.'/system/production/people/photos/'.$socialAuth->getSocialId().'/tn/'.$photoFingerprint.'.'.$extension; |
|
167 | + return $baseUrl . '/system/production/people/photos/' . $socialAuth->getSocialId() . '/tn/' . $photoFingerprint . '.' . $extension; |
|
168 | 168 | break; |
169 | 169 | } |
170 | 170 | } |
@@ -173,16 +173,16 @@ discard block |
||
173 | 173 | |
174 | 174 | switch ($size) { |
175 | 175 | case 'small': // 50px x 50px |
176 | - return '//www.gravatar.com/avatar/'.md5(strtolower(trim($this->email))).'?s=50&d=mm'; |
|
176 | + return '//www.gravatar.com/avatar/' . md5(strtolower(trim($this->email))) . '?s=50&d=mm'; |
|
177 | 177 | break; |
178 | 178 | case 'medium': // 200px x 200px |
179 | - return '//www.gravatar.com/avatar/'.md5(strtolower(trim($this->email))).'?s=200&d=mm'; |
|
179 | + return '//www.gravatar.com/avatar/' . md5(strtolower(trim($this->email))) . '?s=200&d=mm'; |
|
180 | 180 | break; |
181 | 181 | case 'large': // 500px x 500px |
182 | - return '//www.gravatar.com/avatar/'.md5(strtolower(trim($this->email))).'?s=500&d=mm'; |
|
182 | + return '//www.gravatar.com/avatar/' . md5(strtolower(trim($this->email))) . '?s=500&d=mm'; |
|
183 | 183 | break; |
184 | 184 | default: |
185 | - return '//www.gravatar.com/avatar/'.md5(strtolower(trim($this->email))).'?s=50&d=mm'; |
|
185 | + return '//www.gravatar.com/avatar/' . md5(strtolower(trim($this->email))) . '?s=50&d=mm'; |
|
186 | 186 | break; |
187 | 187 | } |
188 | 188 | } |
@@ -67,8 +67,8 @@ |
||
67 | 67 | |
68 | 68 | // Validation (these will throw FacebookSDKException's when they fail) |
69 | 69 | $tokenMetadata->validateAppId($config['auth']['facebook']['appId']); // Replace {app-id} with your app id |
70 | - // If you know the user ID this access token belongs to, you can validate it here |
|
71 | - //$tokenMetadata->validateUserId('123'); |
|
70 | + // If you know the user ID this access token belongs to, you can validate it here |
|
71 | + //$tokenMetadata->validateUserId('123'); |
|
72 | 72 | $tokenMetadata->validateExpiration(); |
73 | 73 | |
74 | 74 | if (!$accessToken->isLongLived()) { |
@@ -16,7 +16,7 @@ discard block |
||
16 | 16 | mysqli_stmt_bind_param($stmt, 'ii', $eventId, $userRoleId); |
17 | 17 | |
18 | 18 | if (!mysqli_stmt_execute($stmt)) { |
19 | - exit('Error: '.mysqli_error(db())); |
|
19 | + exit('Error: ' . mysqli_error(db())); |
|
20 | 20 | } |
21 | 21 | mysqli_stmt_close($stmt); |
22 | 22 | } |
@@ -35,7 +35,7 @@ discard block |
||
35 | 35 | mysqli_stmt_bind_param($stmt, 'ii', $id, $userRoleId); |
36 | 36 | |
37 | 37 | if (!mysqli_stmt_execute($stmt)) { |
38 | - exit('Error: '.mysqli_error(db())); |
|
38 | + exit('Error: ' . mysqli_error(db())); |
|
39 | 39 | } |
40 | 40 | mysqli_stmt_close($stmt); |
41 | 41 | } |
@@ -185,40 +185,40 @@ discard block |
||
185 | 185 | |
186 | 186 | $verificationCode = verificationCodeForSwap($swapId); |
187 | 187 | |
188 | - $subject = 'Swap requested: '.$ob->newUserName.' - '.$ob->eventDate; |
|
189 | - $message = "Date:\t\t ".strftime($ob->time_format_long, strtotime($ob->eventDate))."\r\n". |
|
190 | - "Requested by:\t\t ".$ob->requestedBy."\r\n". |
|
191 | - "Swap from:\t\t ".$ob->oldUserName.' - '.$ob->oldRole."\r\n". |
|
192 | - "Swap to:\t\t ".$ob->newUserName.' - '.$ob->newRole."\r\n". |
|
193 | - "Accept:\t\t ".$ob->siteurl.'/swap.php?action='.'accept&swap='.$swapId.'&verify='.$verificationCode."\r\n "."\r\n". |
|
194 | - "Decline:\t\t ".$ob->siteurl.'/swap.php?action='.'decline&swap='.$swapId.'&verify='.$verificationCode."\r\n "."\r\n"; |
|
188 | + $subject = 'Swap requested: ' . $ob->newUserName . ' - ' . $ob->eventDate; |
|
189 | + $message = "Date:\t\t " . strftime($ob->time_format_long, strtotime($ob->eventDate)) . "\r\n" . |
|
190 | + "Requested by:\t\t " . $ob->requestedBy . "\r\n" . |
|
191 | + "Swap from:\t\t " . $ob->oldUserName . ' - ' . $ob->oldRole . "\r\n" . |
|
192 | + "Swap to:\t\t " . $ob->newUserName . ' - ' . $ob->newRole . "\r\n" . |
|
193 | + "Accept:\t\t " . $ob->siteurl . '/swap.php?action=' . 'accept&swap=' . $swapId . '&verify=' . $verificationCode . "\r\n " . "\r\n" . |
|
194 | + "Decline:\t\t " . $ob->siteurl . '/swap.php?action=' . 'decline&swap=' . $swapId . '&verify=' . $verificationCode . "\r\n " . "\r\n"; |
|
195 | 195 | |
196 | 196 | $from = $ob->siteadmin; |
197 | 197 | |
198 | - $linkToSwap = 'swap.php?swap='.$swapId; |
|
198 | + $linkToSwap = 'swap.php?swap=' . $swapId; |
|
199 | 199 | |
200 | 200 | $sessionUserId = $_SESSION['userid']; |
201 | 201 | |
202 | 202 | if ($sessionUserId == $ob->oldUserId) { // if old user requests swap |
203 | 203 | // notify new user |
204 | - $notificationMessage = $ob->oldUserFirstName.' requested a swap'; |
|
204 | + $notificationMessage = $ob->oldUserFirstName . ' requested a swap'; |
|
205 | 205 | $notificationId = createNotificationForUser($ob->newUserId, $notificationMessage, $message, 'swap', $linkToSwap); |
206 | - createFacebookNotificationForUser($ob->newUserId, 'notification.php?id='.$notificationId, $notificationMessage); |
|
206 | + createFacebookNotificationForUser($ob->newUserId, 'notification.php?id=' . $notificationId, $notificationMessage); |
|
207 | 207 | sendMail(getEmailWithId($ob->newUserId), $subject, $message, $from); |
208 | 208 | } elseif ($sessionUserId == $ob->newUserId) { // if new user requests swap |
209 | 209 | // notify old user |
210 | - $notificationMessage = $ob->newUserFirstName.' requested a swap'; |
|
210 | + $notificationMessage = $ob->newUserFirstName . ' requested a swap'; |
|
211 | 211 | $notificationId = createNotificationForUser($ob->oldUserId, $notificationMessage, $message, 'swap', $linkToSwap); |
212 | - createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id='.$notificationId, $notificationMessage); |
|
212 | + createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id=' . $notificationId, $notificationMessage); |
|
213 | 213 | sendMail(getEmailWithId($ob->oldUserId), $subject, $message, $from); |
214 | 214 | } else { // notify both users |
215 | 215 | $sessionUserFirstName = getFirstNameWithId($sessionUserId); |
216 | - $notificationMessageOldUser = $sessionUserFirstName.' requested a swap for '.$ob->newUserFirstName; |
|
217 | - $notificationMessageNewUser = $sessionUserFirstName.' requested a swap for '.$ob->oldUserFirstName; |
|
216 | + $notificationMessageOldUser = $sessionUserFirstName . ' requested a swap for ' . $ob->newUserFirstName; |
|
217 | + $notificationMessageNewUser = $sessionUserFirstName . ' requested a swap for ' . $ob->oldUserFirstName; |
|
218 | 218 | $notificationIdOldUser = createNotificationForUser($ob->oldUserId, $notificationMessageOldUser, $message, 'swap', $linkToSwap); |
219 | 219 | $notificationIdNewUser = createNotificationForUser($ob->newUserId, $notificationMessageNewUser, $message, 'swap', $linkToSwap); |
220 | - createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id='.$notificationIdOldUser, $notificationMessageOldUser); |
|
221 | - createFacebookNotificationForUser($ob->newUserId, 'notification.php?id='.$notificationIdNewUser, $notificationMessageNewUser); |
|
220 | + createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id=' . $notificationIdOldUser, $notificationMessageOldUser); |
|
221 | + createFacebookNotificationForUser($ob->newUserId, 'notification.php?id=' . $notificationIdNewUser, $notificationMessageNewUser); |
|
222 | 222 | sendMail(getEmailWithId($ob->oldUserId), $subject, $message, $from); |
223 | 223 | sendMail(getEmailWithId($ob->newUserId), $subject, $message, $from); |
224 | 224 | } |
@@ -251,60 +251,60 @@ discard block |
||
251 | 251 | |
252 | 252 | $verificationCode = verificationCodeForSwap($swapId); |
253 | 253 | |
254 | - $subject = 'Swap accepted: '.$ob->newUserName.' - '.$ob->eventDate; |
|
255 | - $message = "The following swap has been accepted\r\n\r\n". |
|
256 | - "Date:\t\t ".strftime($ob->time_format_long, strtotime($ob->eventDate))."\r\n". |
|
257 | - "Requested by:\t\t ".$ob->requestedBy."\r\n". |
|
258 | - "Swap from:\t\t ".$ob->oldUserName.' - '.$ob->oldRole."\r\n". |
|
259 | - "Swap to:\t\t ".$ob->newUserName.' - '.$ob->newRole."\r\n"; |
|
254 | + $subject = 'Swap accepted: ' . $ob->newUserName . ' - ' . $ob->eventDate; |
|
255 | + $message = "The following swap has been accepted\r\n\r\n" . |
|
256 | + "Date:\t\t " . strftime($ob->time_format_long, strtotime($ob->eventDate)) . "\r\n" . |
|
257 | + "Requested by:\t\t " . $ob->requestedBy . "\r\n" . |
|
258 | + "Swap from:\t\t " . $ob->oldUserName . ' - ' . $ob->oldRole . "\r\n" . |
|
259 | + "Swap to:\t\t " . $ob->newUserName . ' - ' . $ob->newRole . "\r\n"; |
|
260 | 260 | $from = $ob->siteadmin; |
261 | 261 | |
262 | - $linkToSwap = 'swap.php?swap='.$swapId; |
|
262 | + $linkToSwap = 'swap.php?swap=' . $swapId; |
|
263 | 263 | |
264 | 264 | $sessionUserId = $_SESSION['userid']; |
265 | 265 | |
266 | 266 | if ($sessionUserId == $ob->oldUserId) { // if old user accepted swap |
267 | 267 | // notify new user |
268 | - $notificationMessage = $ob->oldUserFirstName.' accepted a swap'; |
|
268 | + $notificationMessage = $ob->oldUserFirstName . ' accepted a swap'; |
|
269 | 269 | $notificationId = createNotificationForUser($ob->newUserId, $notificationMessage, $message, 'swap', $linkToSwap); |
270 | - createFacebookNotificationForUser($ob->newUserId, 'notification.php?id='.$notificationId, $notificationMessage); |
|
270 | + createFacebookNotificationForUser($ob->newUserId, 'notification.php?id=' . $notificationId, $notificationMessage); |
|
271 | 271 | sendMail(getEmailWithId($ob->newUserId), $subject, $message, $from); |
272 | 272 | } elseif ($sessionUserId == $ob->newUserId) { // if new user accepted swap |
273 | 273 | // notify old user |
274 | - $notificationMessage = $ob->newUserFirstName.' accepted a swap'; |
|
274 | + $notificationMessage = $ob->newUserFirstName . ' accepted a swap'; |
|
275 | 275 | $notificationId = createNotificationForUser($ob->oldUserId, $notificationMessage, $message, 'swap', $linkToSwap); |
276 | - createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id='.$notificationId, $notificationMessage); |
|
276 | + createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id=' . $notificationId, $notificationMessage); |
|
277 | 277 | sendMail(getEmailWithId($ob->oldUserId), $subject, $message, $from); |
278 | 278 | } elseif (isset($_GET['token'])) { // if accepted by email URL with token |
279 | 279 | // notify whoever requested swap |
280 | 280 | if ($ob->newUserId == $ob->requestedBy) { |
281 | - $notificationMessage = 'Swap accepted with '.$ob->oldUserFirstName; |
|
281 | + $notificationMessage = 'Swap accepted with ' . $ob->oldUserFirstName; |
|
282 | 282 | $notificationId = createNotificationForUser($ob->newUserId, $notificationMessage, $message, 'swap', $linkToSwap); |
283 | - createFacebookNotificationForUser($ob->newUserId, 'notification.php?id='.$notificationId, $notificationMessage); |
|
283 | + createFacebookNotificationForUser($ob->newUserId, 'notification.php?id=' . $notificationId, $notificationMessage); |
|
284 | 284 | sendMail(getEmailWithId($ob->newUserId), $subject, $message, $from); |
285 | 285 | } elseif ($ob->oldUserId == $ob->requestedBy) { |
286 | - $notificationMessage = 'Swap accepted with '.$ob->newUserFirstName; |
|
286 | + $notificationMessage = 'Swap accepted with ' . $ob->newUserFirstName; |
|
287 | 287 | $notificationId = createNotificationForUser($ob->oldUserId, $notificationMessage, $message, 'swap', $linkToSwap); |
288 | - createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id='.$notificationId, $notificationMessage); |
|
288 | + createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id=' . $notificationId, $notificationMessage); |
|
289 | 289 | sendMail(getEmailWithId($ob->oldUserId), $subject, $message, $from); |
290 | 290 | } else { // notify both |
291 | - $notificationMessageOldUser = 'Swap accepted with '.$ob->newUserFirstName; |
|
292 | - $notificationMessageNewUser = 'Swap accepted with '.$ob->oldUserFirstName; |
|
291 | + $notificationMessageOldUser = 'Swap accepted with ' . $ob->newUserFirstName; |
|
292 | + $notificationMessageNewUser = 'Swap accepted with ' . $ob->oldUserFirstName; |
|
293 | 293 | $notificationIdOldUser = createNotificationForUser($ob->oldUserId, $notificationMessageOldUser, $message, 'swap', $linkToSwap); |
294 | 294 | $notificationIdNewUser = createNotificationForUser($ob->newUserId, $notificationMessageNewUser, $message, 'swap', $linkToSwap); |
295 | - createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id='.$notificationIdOldUser, $notificationMessage); |
|
296 | - createFacebookNotificationForUser($ob->newUserId, 'notification.php?id='.$notificationIdNewUser, $notificationMessage); |
|
295 | + createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id=' . $notificationIdOldUser, $notificationMessage); |
|
296 | + createFacebookNotificationForUser($ob->newUserId, 'notification.php?id=' . $notificationIdNewUser, $notificationMessage); |
|
297 | 297 | sendMail(getEmailWithId($ob->oldUserId), $subject, $message, $from); |
298 | 298 | sendMail(getEmailWithId($ob->newUserId), $subject, $message, $from); |
299 | 299 | } |
300 | 300 | } else { // notify both users |
301 | 301 | $sessionUserFirstName = getFirstNameWithId($sessionUserId); |
302 | - $notificationMessageOldUser = $sessionUserFirstName.' accepted a swap for '.$ob->newUserFirstName; |
|
303 | - $notificationMessageNewUser = $sessionUserFirstName.' accepted a swap for '.$ob->oldUserFirstName; |
|
302 | + $notificationMessageOldUser = $sessionUserFirstName . ' accepted a swap for ' . $ob->newUserFirstName; |
|
303 | + $notificationMessageNewUser = $sessionUserFirstName . ' accepted a swap for ' . $ob->oldUserFirstName; |
|
304 | 304 | $notificationIdOldUser = createNotificationForUser($ob->oldUserId, $notificationMessageOldUser, $message, 'swap', $linkToSwap); |
305 | 305 | $notificationIdNewUser = createNotificationForUser($ob->newUserId, $notificationMessageNewUser, $message, 'swap', $linkToSwap); |
306 | - createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id='.$notificationIdOldUser, $notificationMessage); |
|
307 | - createFacebookNotificationForUser($ob->newUserId, 'notification.php?id='.$notificationIdNewUser, $notificationMessage); |
|
306 | + createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id=' . $notificationIdOldUser, $notificationMessage); |
|
307 | + createFacebookNotificationForUser($ob->newUserId, 'notification.php?id=' . $notificationIdNewUser, $notificationMessage); |
|
308 | 308 | sendMail(getEmailWithId($ob->oldUserId), $subject, $message, $from); |
309 | 309 | sendMail(getEmailWithId($ob->newUserId), $subject, $message, $from); |
310 | 310 | } |
@@ -336,39 +336,39 @@ discard block |
||
336 | 336 | |
337 | 337 | $verificationCode = verificationCodeForSwap($swapId); |
338 | 338 | |
339 | - $subject = 'Swap declined: '.$ob->newUserName.' - '.$ob->eventDate; |
|
340 | - $message = "The following swap has been declined\r\n\r\n". |
|
341 | - "Date:\t\t ".strftime($ob->time_format_long, strtotime($ob->eventDate))."\r\n". |
|
342 | - "Requested by:\t\t ".$ob->requestedBy."\r\n". |
|
343 | - "Swap from:\t\t ".$ob->oldUserName.' - '.$ob->oldRole."\r\n". |
|
344 | - "Swap to:\t\t ".$ob->newUserName.' - '.$ob->newRole."\r\n"; |
|
339 | + $subject = 'Swap declined: ' . $ob->newUserName . ' - ' . $ob->eventDate; |
|
340 | + $message = "The following swap has been declined\r\n\r\n" . |
|
341 | + "Date:\t\t " . strftime($ob->time_format_long, strtotime($ob->eventDate)) . "\r\n" . |
|
342 | + "Requested by:\t\t " . $ob->requestedBy . "\r\n" . |
|
343 | + "Swap from:\t\t " . $ob->oldUserName . ' - ' . $ob->oldRole . "\r\n" . |
|
344 | + "Swap to:\t\t " . $ob->newUserName . ' - ' . $ob->newRole . "\r\n"; |
|
345 | 345 | |
346 | 346 | $from = $ob->siteadmin; |
347 | 347 | |
348 | - $linkToSwap = 'swap.php?swap='.$swapId; |
|
348 | + $linkToSwap = 'swap.php?swap=' . $swapId; |
|
349 | 349 | |
350 | 350 | $sessionUserId = $_SESSION['userid']; |
351 | 351 | |
352 | 352 | if ($sessionUserId == $ob->oldUserId) { // if old user declines swap |
353 | 353 | // notify new user |
354 | - $notificationMessage = $ob->oldUserFirstName.' declined a swap'; |
|
354 | + $notificationMessage = $ob->oldUserFirstName . ' declined a swap'; |
|
355 | 355 | $notificationId = createNotificationForUser($ob->newUserId, $notificationMessage, $message, 'swap', $linkToSwap); |
356 | - createFacebookNotificationForUser($ob->newUserId, 'notification.php?id='.$notificationId, $notificationMessage); |
|
356 | + createFacebookNotificationForUser($ob->newUserId, 'notification.php?id=' . $notificationId, $notificationMessage); |
|
357 | 357 | sendMail(getEmailWithId($ob->newUserId), $subject, $message, $from); |
358 | 358 | } elseif ($sessionUserId == $ob->newUserId) { // if new user declines swap |
359 | 359 | // notify old user |
360 | - $notificationMessage = $ob->newUserFirstName.' declined a swap'; |
|
360 | + $notificationMessage = $ob->newUserFirstName . ' declined a swap'; |
|
361 | 361 | $notificationId = createNotificationForUser($ob->oldUserId, $notificationMessage, $message, 'swap', $linkToSwap); |
362 | - createFacebookNotificationForUser($ob->newUserId, 'notification.php?id='.$notificationId, $notificationMessage); |
|
362 | + createFacebookNotificationForUser($ob->newUserId, 'notification.php?id=' . $notificationId, $notificationMessage); |
|
363 | 363 | sendMail(getEmailWithId($ob->oldUserId), $subject, $message, $from); |
364 | 364 | } else { // notify both users |
365 | 365 | $sessionUserFirstName = getFirstNameWithId($sessionUserId); |
366 | - $notificationMessageOldUser = $sessionUserFirstName.' declined a swap for '.$ob->newUserFirstName; |
|
367 | - $notificationMessageNewUser = $sessionUserFirstName.' declined a swap for '.$ob->oldUserFirstName; |
|
366 | + $notificationMessageOldUser = $sessionUserFirstName . ' declined a swap for ' . $ob->newUserFirstName; |
|
367 | + $notificationMessageNewUser = $sessionUserFirstName . ' declined a swap for ' . $ob->oldUserFirstName; |
|
368 | 368 | $notificationIdOldUser = createNotificationForUser($ob->oldUserId, $notificationMessageOldUser, $message, 'swap', $linkToSwap); |
369 | 369 | $notificationIdNewUser = createNotificationForUser($ob->newUserId, $notificationMessageNewUser, $message, 'swap', $linkToSwap); |
370 | - createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id='.$notificationIdOldUser, $notificationMessage); |
|
371 | - createFacebookNotificationForUser($ob->newUserId, 'notification.php?id='.$notificationIdNewUser, $notificationMessage); |
|
370 | + createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id=' . $notificationIdOldUser, $notificationMessage); |
|
371 | + createFacebookNotificationForUser($ob->newUserId, 'notification.php?id=' . $notificationIdNewUser, $notificationMessage); |
|
372 | 372 | sendMail(getEmailWithId($ob->newUserId), $subject, $message, $from); |
373 | 373 | sendMail(getEmailWithId($ob->oldUserId), $subject, $message, $from); |
374 | 374 | } |
@@ -543,7 +543,7 @@ discard block |
||
543 | 543 | $stmt = mysqli_prepare(db(), $sql); |
544 | 544 | mysqli_stmt_bind_param($stmt, 'i', $seriesId); |
545 | 545 | if (!mysqli_stmt_execute($stmt)) { |
546 | - exit('Error: '.mysqli_error(db())); |
|
546 | + exit('Error: ' . mysqli_error(db())); |
|
547 | 547 | } |
548 | 548 | mysqli_stmt_close($stmt); |
549 | 549 | } |
@@ -555,14 +555,14 @@ discard block |
||
555 | 555 | mysqli_stmt_bind_param($stmt, 'ii', $bandId, $userRoleId); |
556 | 556 | |
557 | 557 | if (!mysqli_stmt_execute($stmt)) { |
558 | - exit('Error: '.mysqli_error(db())); |
|
558 | + exit('Error: ' . mysqli_error(db())); |
|
559 | 559 | } |
560 | 560 | mysqli_stmt_close($stmt); |
561 | 561 | } |
562 | 562 | |
563 | 563 | function getEventUrl($eventId) |
564 | 564 | { |
565 | - return 'event.php?id='.$eventId; |
|
565 | + return 'event.php?id=' . $eventId; |
|
566 | 566 | } |
567 | 567 | |
568 | 568 | function getEventDetails($eventID, $separator, $type = 4, $apprev_description = true, $prefix = '') |
@@ -601,9 +601,9 @@ discard block |
||
601 | 601 | e.id = ? '; |
602 | 602 | |
603 | 603 | if ($type == 1) { |
604 | - $sql = $sql."AND ((g.id in (10,11)) OR (g.id=2 and u.firstname='Team')) "; |
|
604 | + $sql = $sql . "AND ((g.id in (10,11)) OR (g.id=2 and u.firstname='Team')) "; |
|
605 | 605 | } |
606 | - $sql = $sql.'ORDER BY e.id, g.id desc, role, firstname, lastname '; |
|
606 | + $sql = $sql . 'ORDER BY e.id, g.id desc, role, firstname, lastname '; |
|
607 | 607 | |
608 | 608 | $stmt = mysqli_prepare(db(), $sql); |
609 | 609 | mysqli_stmt_bind_param($stmt, 'i', $eventID); |
@@ -624,32 +624,32 @@ discard block |
||
624 | 624 | |
625 | 625 | $firstname = $row['firstname']; |
626 | 626 | if ($firstname != 'Team') { |
627 | - $firstname = ltrim(substr($firstname, 0, 1).'.', '.'); |
|
627 | + $firstname = ltrim(substr($firstname, 0, 1) . '.', '.'); |
|
628 | 628 | } |
629 | 629 | |
630 | 630 | $lastname = $row['lastname']; |
631 | 631 | |
632 | - $returnValue = $returnValue.$separator; |
|
632 | + $returnValue = $returnValue . $separator; |
|
633 | 633 | switch ($type) { |
634 | 634 | case 0: |
635 | 635 | //all persons of event |
636 | 636 | //break; -> no special handling, fallthrough to case 1 |
637 | 637 | case 1: |
638 | 638 | //only persons with groupID in 10,11,2 -> handled in sql query |
639 | - $returnValue = $returnValue.$prefix.ltrim($group.': '); |
|
640 | - $returnValue = $returnValue.trim($firstname.' '.$lastname); |
|
639 | + $returnValue = $returnValue . $prefix . ltrim($group . ': '); |
|
640 | + $returnValue = $returnValue . trim($firstname . ' ' . $lastname); |
|
641 | 641 | break; |
642 | 642 | case 2: |
643 | 643 | //only event date and event type |
644 | - $returnValue = $returnValue.strftime($time_format_normal, strtotime($eventDate)); |
|
645 | - $returnValue = $returnValue.$separator; |
|
646 | - $returnValue = $returnValue.$eventType; |
|
644 | + $returnValue = $returnValue . strftime($time_format_normal, strtotime($eventDate)); |
|
645 | + $returnValue = $returnValue . $separator; |
|
646 | + $returnValue = $returnValue . $eventType; |
|
647 | 647 | |
648 | 648 | return trim(substr($returnValue, strlen($separator) - 1)); //ends while loop |
649 | 649 | break; |
650 | 650 | case 4: |
651 | 651 | //only event type |
652 | - $returnValue = $returnValue.$eventType; |
|
652 | + $returnValue = $returnValue . $eventType; |
|
653 | 653 | |
654 | 654 | return trim(substr($returnValue, strlen($separator) - 1)); //ends while loop |
655 | 655 | break; |
@@ -35,7 +35,7 @@ discard block |
||
35 | 35 | } |
36 | 36 | |
37 | 37 | // create username and remove all whitespace |
38 | - $username = $firstNameLower.'.'.$lastNameLower; |
|
38 | + $username = $firstNameLower . '.' . $lastNameLower; |
|
39 | 39 | $username = preg_replace('/\s+/', '', $username); |
40 | 40 | |
41 | 41 | $sql = "INSERT INTO users (firstName, lastName, username, email, mobile, password, created, updated) |
@@ -48,12 +48,12 @@ discard block |
||
48 | 48 | $id = mysqli_insert_id(db()); |
49 | 49 | |
50 | 50 | $notificationMessage = "Welcome to your new account on the rota system.\n |
51 | -If you have any issues, please get in touch with us [".siteSettings()->getAdminEmailAddress().'](mailto:'.siteSettings()->getAdminEmailAddress().").\n |
|
51 | +If you have any issues, please get in touch with us [".siteSettings()->getAdminEmailAddress() . '](mailto:' . siteSettings()->getAdminEmailAddress() . ").\n |
|
52 | 52 | ---\n |
53 | 53 | **Sync to digital calendar**\n |
54 | 54 | You may wish to link the rota to your digital calendar on your computer and phone. To do so, generate a [calendar token](calendarTokens.php) which will present you with your unique URL. Follow instructions from your digital calendar provider for exact details on how import an iCal feed, or get in touch and we may be able to help.\n"; |
55 | 55 | |
56 | - createNotificationForUser($id, 'Welcome '.$firstName, $notificationMessage, 'feature'); |
|
56 | + createNotificationForUser($id, 'Welcome ' . $firstName, $notificationMessage, 'feature'); |
|
57 | 57 | createNotificationForUser($id, 'Change your password', 'Please change your password to something unique and memorable.', 'account', 'editPassword.php'); |
58 | 58 | |
59 | 59 | return $id; |
@@ -150,7 +150,7 @@ discard block |
||
150 | 150 | $result = mysqli_stmt_get_result($stmt); |
151 | 151 | $ob = mysqli_fetch_object($result); |
152 | 152 | mysqli_stmt_close($stmt); |
153 | - $name = $ob->firstName.' '.$ob->lastName; |
|
153 | + $name = $ob->firstName . ' ' . $ob->lastName; |
|
154 | 154 | |
155 | 155 | return $name; |
156 | 156 | } |
@@ -242,7 +242,7 @@ discard block |
||
242 | 242 | mysqli_stmt_bind_param($stmt, 'ssi', $hashedPassword, $currentTimestamp, $userId); |
243 | 243 | mysqli_stmt_execute($stmt) or exit(mysqli_error(db())); |
244 | 244 | mysqli_stmt_close($stmt); |
245 | - insertStatistics('user', __FILE__, 'password force changed for user '.getNameWithId($userId), null, $_SERVER['HTTP_USER_AGENT']); |
|
245 | + insertStatistics('user', __FILE__, 'password force changed for user ' . getNameWithId($userId), null, $_SERVER['HTTP_USER_AGENT']); |
|
246 | 246 | } |
247 | 247 | |
248 | 248 | function hashPassword($plainTextPassword) |
@@ -288,7 +288,7 @@ discard block |
||
288 | 288 | if ($loginFailures < $numberOfAllowedAttempts) { |
289 | 289 | return true; |
290 | 290 | } else { |
291 | - insertStatistics('user', __FILE__, 'Login attempts exceeded for username: '.$username, $ipAddress, $_SERVER['HTTP_USER_AGENT']); |
|
291 | + insertStatistics('user', __FILE__, 'Login attempts exceeded for username: ' . $username, $ipAddress, $_SERVER['HTTP_USER_AGENT']); |
|
292 | 292 | |
293 | 293 | return false; |
294 | 294 | } |
@@ -376,11 +376,11 @@ discard block |
||
376 | 376 | $pendingId = mysqli_insert_id(db()); |
377 | 377 | mysqli_stmt_close($stmt); |
378 | 378 | |
379 | - $linkToApprove = 'pendingAccounts.php?id='.$pendingId; |
|
379 | + $linkToApprove = 'pendingAccounts.php?id=' . $pendingId; |
|
380 | 380 | |
381 | - $email = siteSettings()->getOwner().'<'.siteSettings()->getAdminEmailAddress().'>'; |
|
382 | - $subject = $firstName.' requested an account'; |
|
383 | - $message = $subject.' through '.$source.".\nApprove or decline: ".siteSettings()->getSiteUrl().'/'.$linkToApprove; |
|
381 | + $email = siteSettings()->getOwner() . '<' . siteSettings()->getAdminEmailAddress() . '>'; |
|
382 | + $subject = $firstName . ' requested an account'; |
|
383 | + $message = $subject . ' through ' . $source . ".\nApprove or decline: " . siteSettings()->getSiteUrl() . '/' . $linkToApprove; |
|
384 | 384 | |
385 | 385 | sendMail($email, $subject, $message, $email); |
386 | 386 | |
@@ -472,7 +472,7 @@ discard block |
||
472 | 472 | addSocialAuthToUserWithId($userId, $pendingUser->socialId, $pendingUser->source); |
473 | 473 | updateUser($userId, $pendingUser->firstName, $pendingUser->lastName, $pendingUser->email, null); |
474 | 474 | |
475 | - createNotificationForUser($userId, 'Social Login added: '.$pendingUser->source, 'Your social media login details for '.$pendingUser->source.' have been added to your existing account', 'account'); |
|
475 | + createNotificationForUser($userId, 'Social Login added: ' . $pendingUser->source, 'Your social media login details for ' . $pendingUser->source . ' have been added to your existing account', 'account'); |
|
476 | 476 | createFacebookNotificationForUser($userId, 'login.php', 'Your account request has been approved. You can now login via Facebook.'); |
477 | 477 | |
478 | 478 | return true; |
@@ -587,25 +587,25 @@ discard block |
||
587 | 587 | if ($user->socialId) { |
588 | 588 | switch ($size) { |
589 | 589 | case 'small': // 50px x 50px |
590 | - return '//graph.facebook.com/'.$user->socialId.'/picture?type=square'; |
|
590 | + return '//graph.facebook.com/' . $user->socialId . '/picture?type=square'; |
|
591 | 591 | break; |
592 | 592 | case 'large': // 200px x 200px |
593 | - return '//graph.facebook.com/'.$user->socialId.'/picture?type=large'; |
|
593 | + return '//graph.facebook.com/' . $user->socialId . '/picture?type=large'; |
|
594 | 594 | break; |
595 | 595 | default: |
596 | - return '//graph.facebook.com/'.$user->socialId.'/picture'; |
|
596 | + return '//graph.facebook.com/' . $user->socialId . '/picture'; |
|
597 | 597 | break; |
598 | 598 | } |
599 | 599 | } else { |
600 | 600 | switch ($size) { |
601 | 601 | case 'small': // 50px x 50px |
602 | - return '//www.gravatar.com/avatar/'.md5(strtolower(trim($user->email))).'?s=50&d=mm'; |
|
602 | + return '//www.gravatar.com/avatar/' . md5(strtolower(trim($user->email))) . '?s=50&d=mm'; |
|
603 | 603 | break; |
604 | 604 | case 'large': // 200px x 200px |
605 | - return '//www.gravatar.com/avatar/'.md5(strtolower(trim($user->email))).'?s=200&d=mm'; |
|
605 | + return '//www.gravatar.com/avatar/' . md5(strtolower(trim($user->email))) . '?s=200&d=mm'; |
|
606 | 606 | break; |
607 | 607 | default: |
608 | - return '//www.gravatar.com/avatar/'.md5(strtolower(trim($user->email))).'?s=50&d=mm'; |
|
608 | + return '//www.gravatar.com/avatar/' . md5(strtolower(trim($user->email))) . '?s=50&d=mm'; |
|
609 | 609 | break; |
610 | 610 | } |
611 | 611 | } |