@@ -26,14 +26,14 @@ discard block |
||
| 26 | 26 | function executeDbSql($sql) |
| 27 | 27 | { |
| 28 | 28 | if (!mysqli_query(db(), $sql)) { |
| 29 | - die('Error: '.mysqli_error(db()).', SQL: '.$sql); |
|
| 29 | + die('Error: ' . mysqli_error(db()) . ', SQL: ' . $sql); |
|
| 30 | 30 | } |
| 31 | 31 | } |
| 32 | 32 | |
| 33 | 33 | function updateDatabase() |
| 34 | 34 | { |
| 35 | 35 | $sql = 'SELECT VERSION( ) AS mysqli_version'; |
| 36 | - $result = mysqli_query(db(), $sql) or die('MySQL-Error: '.mysqli_error(db())); |
|
| 36 | + $result = mysqli_query(db(), $sql) or die('MySQL-Error: ' . mysqli_error(db())); |
|
| 37 | 37 | $dbv = mysqli_fetch_array($result, MYSQLI_ASSOC); |
| 38 | 38 | $mysqli_version = $dbv['mysqli_version']; |
| 39 | 39 | //echo $mysqli_version."<br>"; |
@@ -87,41 +87,41 @@ discard block |
||
| 87 | 87 | executeDbSql("alter table users add(isOverviewRecipient char(2) NOT NULL DEFAULT '0')"); |
| 88 | 88 | executeDbSql('alter table groups add(short_name char(2))'); |
| 89 | 89 | |
| 90 | - executeDbSql("update settings set lang_locale = 'en_GB'"); // de_DE |
|
| 90 | + executeDbSql("update settings set lang_locale = 'en_GB'"); // de_DE |
|
| 91 | 91 | executeDbSql('update settings set event_sorting_latest = 0'); |
| 92 | 92 | executeDbSql('update settings set snapshot_show_two_month = 0'); |
| 93 | 93 | executeDbSql('update settings set snapshot_reduce_skills_by_group = 0'); |
| 94 | 94 | executeDbSql('update settings set logged_in_show_snapshot_button = 0'); |
| 95 | 95 | executeDbSql("update settings set time_format_long = '%A, %B %e @ %I:%M %p'"); // de_DE: %A, %e. %B %Y, %R Uhr, KW%V |
| 96 | 96 | executeDbSql("update settings set time_format_normal = '%m/%d/%y %I:%M %p'"); // de_DE: %d.%m.%Y %H:%M |
| 97 | - executeDbSql("update settings set time_format_short = '%a, <strong>%b %e</strong>, %I:%M %p'"); // de_DE: %a, <strong>%e. %b</strong>, KW%V |
|
| 97 | + executeDbSql("update settings set time_format_short = '%a, <strong>%b %e</strong>, %I:%M %p'"); // de_DE: %a, <strong>%e. %b</strong>, KW%V |
|
| 98 | 98 | executeDbSql("update settings set version = '2.1.0'"); |
| 99 | 99 | executeDbSql('update settings set users_start_with_myevents = 0'); |
| 100 | 100 | executeDbSql("update settings set time_zone = 'Europe/London'"); //de_DE: Europe/Berlin |
| 101 | 101 | executeDbSql("update settings set google_group_calendar = ''"); |
| 102 | 102 | executeDbSql("update settings set overviewemail = 'Hello,\r\n\r\nIn this email you find the Rota for [MONTH] [YEAR].\r\n\r\n[OVERVIEW]\r\n\r\nPlease inform us as soon as possible, if you are not able to serve as scheduled.\r\n\r\nBe blessed.\r\nChurch Support Stuff'"); |
| 103 | 103 | |
| 104 | - notifyInfo(__FILE__, 'db-update='.$version.'->2.1.0', $_SESSION['userid']); |
|
| 104 | + notifyInfo(__FILE__, 'db-update=' . $version . '->2.1.0', $_SESSION['userid']); |
|
| 105 | 105 | case '2.1.0': |
| 106 | 106 | executeDbSql('create table settings_bkp2_1_0 as select * from settings'); |
| 107 | 107 | executeDbSql('alter table settings add(group_sorting_name int(1))'); |
| 108 | 108 | executeDbSql("update settings set version = '2.1.1'"); |
| 109 | - notifyInfo(__FILE__, 'db-update='.$version.'->2.1.1', $_SESSION['userid']); |
|
| 109 | + notifyInfo(__FILE__, 'db-update=' . $version . '->2.1.1', $_SESSION['userid']); |
|
| 110 | 110 | case '2.1.1': |
| 111 | 111 | executeDbSql("update settings set version = '2.1.2'"); |
| 112 | - notifyInfo(__FILE__, 'db-update='.$version.'->2.1.2', $_SESSION['userid']); |
|
| 112 | + notifyInfo(__FILE__, 'db-update=' . $version . '->2.1.2', $_SESSION['userid']); |
|
| 113 | 113 | case '2.1.2': |
| 114 | 114 | executeDbSql("alter table settings add(debug_mode int(1) DEFAULT '0')"); |
| 115 | - executeDbSql('update settings set group_sorting_name = 0'); //was a workaround, fixed in V2.2.1 |
|
| 115 | + executeDbSql('update settings set group_sorting_name = 0'); //was a workaround, fixed in V2.2.1 |
|
| 116 | 116 | |
| 117 | 117 | executeDbSql("update settings set version = '2.2.0'"); |
| 118 | - notifyInfo(__FILE__, 'db-update='.$version.'->2.2.0', $_SESSION['userid']); |
|
| 118 | + notifyInfo(__FILE__, 'db-update=' . $version . '->2.2.0', $_SESSION['userid']); |
|
| 119 | 119 | case '2.2.0': |
| 120 | 120 | executeDbSql("alter table users add(isBandAdmin char(2) NOT NULL DEFAULT '0')"); |
| 121 | 121 | executeDbSql('update settings set group_sorting_name = 0'); //due to an error reset it again |
| 122 | 122 | |
| 123 | 123 | executeDbSql("update settings set version = '2.2.1'"); |
| 124 | - notifyInfo(__FILE__, 'db-update='.$version.'->2.2.1', $_SESSION['userid']); |
|
| 124 | + notifyInfo(__FILE__, 'db-update=' . $version . '->2.2.1', $_SESSION['userid']); |
|
| 125 | 125 | case '2.2.1': |
| 126 | 126 | $sql = "CREATE TABLE IF NOT EXISTS `statistics` ( |
| 127 | 127 | `id` int(11) NOT NULL AUTO_INCREMENT, |
@@ -137,21 +137,21 @@ discard block |
||
| 137 | 137 | executeDbSql($sql); |
| 138 | 138 | |
| 139 | 139 | executeDbSql("update settings set version = '2.3.0'"); |
| 140 | - notifyInfo(__FILE__, 'db-update='.$version.'->2.3.0', $_SESSION['userid']); |
|
| 140 | + notifyInfo(__FILE__, 'db-update=' . $version . '->2.3.0', $_SESSION['userid']); |
|
| 141 | 141 | insertStatistics('system', __FILE__, 'db-update', '2.3.0', $version); |
| 142 | 142 | case '2.3.0': |
| 143 | 143 | executeDbSql("alter table users add(isEventEditor char(2) NOT NULL DEFAULT '0')"); |
| 144 | 144 | |
| 145 | 145 | executeDbSql("update settings set version = '2.3.1'"); |
| 146 | - notifyInfo(__FILE__, 'db-update='.$version.'->2.3.1', $_SESSION['userid']); |
|
| 146 | + notifyInfo(__FILE__, 'db-update=' . $version . '->2.3.1', $_SESSION['userid']); |
|
| 147 | 147 | insertStatistics('system', __FILE__, 'db-update', '2.3.1', $version); |
| 148 | 148 | case '2.3.1': |
| 149 | 149 | executeDbSql("update settings set version = '2.3.2'"); |
| 150 | - notifyInfo(__FILE__, 'db-update='.$version.'->2.3.2', $_SESSION['userid']); |
|
| 150 | + notifyInfo(__FILE__, 'db-update=' . $version . '->2.3.2', $_SESSION['userid']); |
|
| 151 | 151 | insertStatistics('system', __FILE__, 'db-update', '2.3.2', $version); |
| 152 | 152 | case '2.3.2': |
| 153 | 153 | executeDbSql("update settings set version = '2.3.3'"); |
| 154 | - notifyInfo(__FILE__, 'db-update='.$version.'->2.3.3', $_SESSION['userid']); |
|
| 154 | + notifyInfo(__FILE__, 'db-update=' . $version . '->2.3.3', $_SESSION['userid']); |
|
| 155 | 155 | insertStatistics('system', __FILE__, 'db-update', '2.3.3', $version); |
| 156 | 156 | case '2.3.3': |
| 157 | 157 | if (substr($mysqli_version, 0, 1) == 5) { |
@@ -199,33 +199,33 @@ discard block |
||
| 199 | 199 | ); |
| 200 | 200 | } |
| 201 | 201 | executeDbSql("update settings set version = '2.3.4'"); |
| 202 | - notifyInfo(__FILE__, 'db-update='.$version.'->2.3.4', $_SESSION['userid']); |
|
| 202 | + notifyInfo(__FILE__, 'db-update=' . $version . '->2.3.4', $_SESSION['userid']); |
|
| 203 | 203 | insertStatistics('system', __FILE__, 'db-update', '2.3.4', $version); |
| 204 | 204 | case '2.3.4': |
| 205 | 205 | executeDbSql("update settings set version = '2.3.5'"); |
| 206 | - notifyInfo(__FILE__, 'db-update='.$version.'->2.3.5', $_SESSION['userid']); |
|
| 206 | + notifyInfo(__FILE__, 'db-update=' . $version . '->2.3.5', $_SESSION['userid']); |
|
| 207 | 207 | insertStatistics('system', __FILE__, 'db-update', '2.3.5', $version); |
| 208 | 208 | case '2.3.5': |
| 209 | 209 | executeDbSql("update settings set version = '2.4.0'"); |
| 210 | - notifyInfo(__FILE__, 'db-update='.$version.'->2.4.0', $_SESSION['userid']); |
|
| 210 | + notifyInfo(__FILE__, 'db-update=' . $version . '->2.4.0', $_SESSION['userid']); |
|
| 211 | 211 | insertStatistics('system', __FILE__, 'db-update', '2.4.0', $version); |
| 212 | 212 | case '2.4.0': |
| 213 | 213 | executeDbSql("update settings set version = '2.4.1'"); |
| 214 | - notifyInfo(__FILE__, 'db-update='.$version.'->2.4.1', $_SESSION['userid']); |
|
| 214 | + notifyInfo(__FILE__, 'db-update=' . $version . '->2.4.1', $_SESSION['userid']); |
|
| 215 | 215 | insertStatistics('system', __FILE__, 'db-update', '2.4.1', $version); |
| 216 | 216 | case '2.4.1': |
| 217 | 217 | executeDbSql('alter table settings add(days_to_alert int(2) DEFAULT 5) '); |
| 218 | 218 | executeDbSql("alter table settings add(token varchar(100) DEFAULT '') "); |
| 219 | 219 | executeDbSql("update settings set version = '2.4.2'"); |
| 220 | - notifyInfo(__FILE__, 'db-update='.$version.'->2.4.2', $_SESSION['userid']); |
|
| 220 | + notifyInfo(__FILE__, 'db-update=' . $version . '->2.4.2', $_SESSION['userid']); |
|
| 221 | 221 | insertStatistics('system', __FILE__, 'db-update', '2.4.2', $version); |
| 222 | 222 | case '2.4.2': |
| 223 | 223 | executeDbSql("update settings set version = '2.4.3'"); |
| 224 | - notifyInfo(__FILE__, 'db-update='.$version.'->2.4.3', $_SESSION['userid']); |
|
| 224 | + notifyInfo(__FILE__, 'db-update=' . $version . '->2.4.3', $_SESSION['userid']); |
|
| 225 | 225 | insertStatistics('system', __FILE__, 'db-update', '2.4.3', $version); |
| 226 | 226 | case '2.4.3': |
| 227 | 227 | executeDbSql("update settings set version = '2.4.4'"); |
| 228 | - notifyInfo(__FILE__, 'db-update='.$version.'->2.4.4', $_SESSION['userid']); |
|
| 228 | + notifyInfo(__FILE__, 'db-update=' . $version . '->2.4.4', $_SESSION['userid']); |
|
| 229 | 229 | insertStatistics('system', __FILE__, 'db-update', '2.4.4', $version); |
| 230 | 230 | case '2.4.4': |
| 231 | 231 | if (substr($mysqli_version, 0, 1) == 5) { |
@@ -274,27 +274,27 @@ discard block |
||
| 274 | 274 | ); |
| 275 | 275 | } |
| 276 | 276 | executeDbSql("update settings set version = '2.4.5'"); |
| 277 | - notifyInfo(__FILE__, 'db-update='.$version.'->2.4.5', $_SESSION['userid']); |
|
| 277 | + notifyInfo(__FILE__, 'db-update=' . $version . '->2.4.5', $_SESSION['userid']); |
|
| 278 | 278 | insertStatistics('system', __FILE__, 'db-update', '2.4.5', $version); |
| 279 | 279 | case '2.4.5': |
| 280 | 280 | executeDbSql("update settings set version = '2.5.0'"); |
| 281 | - notifyInfo(__FILE__, 'db-update='.$version.'->2.5.0', $_SESSION['userid']); |
|
| 281 | + notifyInfo(__FILE__, 'db-update=' . $version . '->2.5.0', $_SESSION['userid']); |
|
| 282 | 282 | insertStatistics('system', __FILE__, 'db-update', '2.5.0', $version); |
| 283 | 283 | case '2.5.0': |
| 284 | 284 | executeDbSql("update settings set version = '2.5.1'"); |
| 285 | - notifyInfo(__FILE__, 'db-update='.$version.'->2.5.1', $_SESSION['userid']); |
|
| 285 | + notifyInfo(__FILE__, 'db-update=' . $version . '->2.5.1', $_SESSION['userid']); |
|
| 286 | 286 | insertStatistics('system', __FILE__, 'db-update', '2.5.1', $version); |
| 287 | 287 | case '2.5.1': |
| 288 | 288 | executeDbSql("update settings set version = '2.5.2'"); |
| 289 | - notifyInfo(__FILE__, 'db-update='.$version.'->2.5.2', $_SESSION['userid']); |
|
| 289 | + notifyInfo(__FILE__, 'db-update=' . $version . '->2.5.2', $_SESSION['userid']); |
|
| 290 | 290 | insertStatistics('system', __FILE__, 'db-update', '2.5.2', $version); |
| 291 | 291 | case '2.5.2': |
| 292 | 292 | executeDbSql("update settings set version = '2.5.3'"); |
| 293 | - notifyInfo(__FILE__, 'db-update='.$version.'->2.5.3', $_SESSION['userid']); |
|
| 293 | + notifyInfo(__FILE__, 'db-update=' . $version . '->2.5.3', $_SESSION['userid']); |
|
| 294 | 294 | insertStatistics('system', __FILE__, 'db-update', '2.5.3', $version); |
| 295 | 295 | case '2.5.3': |
| 296 | 296 | executeDbSql("update settings set version = '2.6.0'"); |
| 297 | - notifyInfo(__FILE__, 'db-update='.$version.'->2.6.0', $_SESSION['userid']); |
|
| 297 | + notifyInfo(__FILE__, 'db-update=' . $version . '->2.6.0', $_SESSION['userid']); |
|
| 298 | 298 | insertStatistics('system', __FILE__, 'db-update', '2.6.0', $version); |
| 299 | 299 | case '2.6.0': |
| 300 | 300 | $sql = "ALTER TABLE users |
@@ -370,7 +370,7 @@ discard block |
||
| 370 | 370 | executeDbSql($sql); |
| 371 | 371 | executeDbSql("update settings set version = '3.0.0-pre1'"); |
| 372 | 372 | |
| 373 | - notifyInfo(__FILE__, 'db-update='.$version.'->3.0.0-pre1', $_SESSION['userid']); |
|
| 373 | + notifyInfo(__FILE__, 'db-update=' . $version . '->3.0.0-pre1', $_SESSION['userid']); |
|
| 374 | 374 | insertStatistics('system', __FILE__, 'db-update', '3.0.0-pre1', $version); |
| 375 | 375 | case '3.0.0-pre1': |
| 376 | 376 | $sql = "CREATE TABLE IF NOT EXISTS notifications ( |
@@ -14,7 +14,7 @@ discard block |
||
| 14 | 14 | $sql = ("INSERT INTO eventPeople (eventId, userRoleId) VALUES ('$eventId', '$userRoleId')"); |
| 15 | 15 | |
| 16 | 16 | if (!mysqli_query(db(), $sql)) { |
| 17 | - die('Error: '.mysqli_error(db())); |
|
| 17 | + die('Error: ' . mysqli_error(db())); |
|
| 18 | 18 | } |
| 19 | 19 | } |
| 20 | 20 | |
@@ -29,7 +29,7 @@ discard block |
||
| 29 | 29 | { |
| 30 | 30 | $sql = "DELETE FROM eventPeople WHERE eventId = '$id' AND userRoleId = '$userRoleId'"; |
| 31 | 31 | if (!mysqli_query(db(), $sql)) { |
| 32 | - die('Error: '.mysqli_error(db())); |
|
| 32 | + die('Error: ' . mysqli_error(db())); |
|
| 33 | 33 | } |
| 34 | 34 | } |
| 35 | 35 | |
@@ -170,40 +170,40 @@ discard block |
||
| 170 | 170 | |
| 171 | 171 | $ob = mysqli_fetch_object($result); |
| 172 | 172 | |
| 173 | - $subject = 'Swap requested: '.$ob->newUserName.' - '.$ob->eventDate; |
|
| 174 | - $message = "Date:\t\t ".strftime($ob->time_format_long, strtotime($ob->eventDate))."\r\n". |
|
| 175 | - "Requested by:\t\t ".$ob->requestedBy."\r\n". |
|
| 176 | - "Swap from:\t\t ".$ob->oldUserName.' - '.$ob->oldRole."\r\n". |
|
| 177 | - "Swap to:\t\t ".$ob->newUserName.' - '.$ob->newRole."\r\n". |
|
| 178 | - "Accept:\t\t ".$ob->siteurl.'/swap.php?action='.'accept&swap='.$swapId.'&verify='.$verificationCode."\r\n "."\r\n". |
|
| 179 | - "Decline:\t\t ".$ob->siteurl.'/swap.php?action='.'decline&swap='.$swapId.'&verify='.$verificationCode."\r\n "."\r\n"; |
|
| 173 | + $subject = 'Swap requested: ' . $ob->newUserName . ' - ' . $ob->eventDate; |
|
| 174 | + $message = "Date:\t\t " . strftime($ob->time_format_long, strtotime($ob->eventDate)) . "\r\n" . |
|
| 175 | + "Requested by:\t\t " . $ob->requestedBy . "\r\n" . |
|
| 176 | + "Swap from:\t\t " . $ob->oldUserName . ' - ' . $ob->oldRole . "\r\n" . |
|
| 177 | + "Swap to:\t\t " . $ob->newUserName . ' - ' . $ob->newRole . "\r\n" . |
|
| 178 | + "Accept:\t\t " . $ob->siteurl . '/swap.php?action=' . 'accept&swap=' . $swapId . '&verify=' . $verificationCode . "\r\n " . "\r\n" . |
|
| 179 | + "Decline:\t\t " . $ob->siteurl . '/swap.php?action=' . 'decline&swap=' . $swapId . '&verify=' . $verificationCode . "\r\n " . "\r\n"; |
|
| 180 | 180 | |
| 181 | 181 | $from = $ob->siteadmin; |
| 182 | 182 | |
| 183 | - $linkToSwap = 'swap.php?swap='.$swapId; |
|
| 183 | + $linkToSwap = 'swap.php?swap=' . $swapId; |
|
| 184 | 184 | |
| 185 | 185 | $sessionUserId = $_SESSION['userid']; |
| 186 | 186 | |
| 187 | 187 | if ($sessionUserId == $ob->oldUserId) { // if old user requests swap |
| 188 | 188 | // notify new user |
| 189 | - $notificationMessage = $ob->oldUserFirstName.' requested a swap'; |
|
| 189 | + $notificationMessage = $ob->oldUserFirstName . ' requested a swap'; |
|
| 190 | 190 | $notificationId = createNotificationForUser($ob->newUserId, $notificationMessage, $message, 'swap', $linkToSwap); |
| 191 | - createFacebookNotificationForUser($ob->newUserId, 'notification.php?id='.$notificationId, $notificationMessage); |
|
| 191 | + createFacebookNotificationForUser($ob->newUserId, 'notification.php?id=' . $notificationId, $notificationMessage); |
|
| 192 | 192 | sendMail(getEmailWithId($ob->newUserId), $subject, $message, $from); |
| 193 | 193 | } elseif ($sessionUserId == $ob->newUserId) { // if new user requests swap |
| 194 | 194 | // notify old user |
| 195 | - $notificationMessage = $ob->newUserFirstName.' requested a swap'; |
|
| 195 | + $notificationMessage = $ob->newUserFirstName . ' requested a swap'; |
|
| 196 | 196 | $notificationId = createNotificationForUser($ob->oldUserId, $notificationMessage, $message, 'swap', $linkToSwap); |
| 197 | - createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id='.$notificationId, $notificationMessage); |
|
| 197 | + createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id=' . $notificationId, $notificationMessage); |
|
| 198 | 198 | sendMail(getEmailWithId($ob->oldUserId), $subject, $message, $from); |
| 199 | 199 | } else { // notify both users |
| 200 | 200 | $sessionUserFirstName = getFirstNameWithId($sessionUserId); |
| 201 | - $notificationMessageOldUser = $sessionUserFirstName.' requested a swap for '.$ob->newUserFirstName; |
|
| 202 | - $notificationMessageNewUser = $sessionUserFirstName.' requested a swap for '.$ob->oldUserFirstName; |
|
| 201 | + $notificationMessageOldUser = $sessionUserFirstName . ' requested a swap for ' . $ob->newUserFirstName; |
|
| 202 | + $notificationMessageNewUser = $sessionUserFirstName . ' requested a swap for ' . $ob->oldUserFirstName; |
|
| 203 | 203 | $notificationIdOldUser = createNotificationForUser($ob->oldUserId, $notificationMessageOldUser, $message, 'swap', $linkToSwap); |
| 204 | 204 | $notificationIdNewUser = createNotificationForUser($ob->newUserId, $notificationMessageNewUser, $message, 'swap', $linkToSwap); |
| 205 | - createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id='.$notificationIdOldUser, $notificationMessageOldUser); |
|
| 206 | - createFacebookNotificationForUser($ob->newUserId, 'notification.php?id='.$notificationIdNewUser, $notificationMessageNewUser); |
|
| 205 | + createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id=' . $notificationIdOldUser, $notificationMessageOldUser); |
|
| 206 | + createFacebookNotificationForUser($ob->newUserId, 'notification.php?id=' . $notificationIdNewUser, $notificationMessageNewUser); |
|
| 207 | 207 | sendMail(getEmailWithId($ob->oldUserId), $subject, $message, $from); |
| 208 | 208 | sendMail(getEmailWithId($ob->newUserId), $subject, $message, $from); |
| 209 | 209 | } |
@@ -233,60 +233,60 @@ discard block |
||
| 233 | 233 | |
| 234 | 234 | $ob = mysqli_fetch_object($result); |
| 235 | 235 | |
| 236 | - $subject = 'Swap accepted: '.$ob->newUserName.' - '.$ob->eventDate; |
|
| 237 | - $message = "The following swap has been accepted\r\n\r\n". |
|
| 238 | - "Date:\t\t ".strftime($ob->time_format_long, strtotime($ob->eventDate))."\r\n". |
|
| 239 | - "Requested by:\t\t ".$ob->requestedBy."\r\n". |
|
| 240 | - "Swap from:\t\t ".$ob->oldUserName.' - '.$ob->oldRole."\r\n". |
|
| 241 | - "Swap to:\t\t ".$ob->newUserName.' - '.$ob->newRole."\r\n"; |
|
| 236 | + $subject = 'Swap accepted: ' . $ob->newUserName . ' - ' . $ob->eventDate; |
|
| 237 | + $message = "The following swap has been accepted\r\n\r\n" . |
|
| 238 | + "Date:\t\t " . strftime($ob->time_format_long, strtotime($ob->eventDate)) . "\r\n" . |
|
| 239 | + "Requested by:\t\t " . $ob->requestedBy . "\r\n" . |
|
| 240 | + "Swap from:\t\t " . $ob->oldUserName . ' - ' . $ob->oldRole . "\r\n" . |
|
| 241 | + "Swap to:\t\t " . $ob->newUserName . ' - ' . $ob->newRole . "\r\n"; |
|
| 242 | 242 | $from = $ob->siteadmin; |
| 243 | 243 | |
| 244 | - $linkToSwap = 'swap.php?swap='.$swapId; |
|
| 244 | + $linkToSwap = 'swap.php?swap=' . $swapId; |
|
| 245 | 245 | |
| 246 | 246 | $sessionUserId = $_SESSION['userid']; |
| 247 | 247 | |
| 248 | 248 | if ($sessionUserId == $ob->oldUserId) { // if old user accepted swap |
| 249 | 249 | // notify new user |
| 250 | - $notificationMessage = $ob->oldUserFirstName.' accepted a swap'; |
|
| 250 | + $notificationMessage = $ob->oldUserFirstName . ' accepted a swap'; |
|
| 251 | 251 | $notificationId = createNotificationForUser($ob->newUserId, $notificationMessage, $message, 'swap', $linkToSwap); |
| 252 | - createFacebookNotificationForUser($ob->newUserId, 'notification.php?id='.$notificationId, $notificationMessage); |
|
| 252 | + createFacebookNotificationForUser($ob->newUserId, 'notification.php?id=' . $notificationId, $notificationMessage); |
|
| 253 | 253 | sendMail(getEmailWithId($ob->newUserId), $subject, $message, $from); |
| 254 | 254 | } elseif ($sessionUserId == $ob->newUserId) { // if new user accepted swap |
| 255 | 255 | // notify old user |
| 256 | - $notificationMessage = $ob->newUserFirstName.' accepted a swap'; |
|
| 256 | + $notificationMessage = $ob->newUserFirstName . ' accepted a swap'; |
|
| 257 | 257 | $notificationId = createNotificationForUser($ob->oldUserId, $notificationMessage, $message, 'swap', $linkToSwap); |
| 258 | - createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id='.$notificationId, $notificationMessage); |
|
| 258 | + createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id=' . $notificationId, $notificationMessage); |
|
| 259 | 259 | sendMail(getEmailWithId($ob->oldUserId), $subject, $message, $from); |
| 260 | 260 | } elseif (isset($_GET['token'])) { // if accepted by email URL with token |
| 261 | 261 | // notify whoever requested swap |
| 262 | 262 | if ($ob->newUserId == $ob->requestedBy) { |
| 263 | - $notificationMessage = 'Swap accepted with '.$ob->oldUserFirstName; |
|
| 263 | + $notificationMessage = 'Swap accepted with ' . $ob->oldUserFirstName; |
|
| 264 | 264 | $notificationId = createNotificationForUser($ob->newUserId, $notificationMessage, $message, 'swap', $linkToSwap); |
| 265 | - createFacebookNotificationForUser($ob->newUserId, 'notification.php?id='.$notificationId, $notificationMessage); |
|
| 265 | + createFacebookNotificationForUser($ob->newUserId, 'notification.php?id=' . $notificationId, $notificationMessage); |
|
| 266 | 266 | sendMail(getEmailWithId($ob->newUserId), $subject, $message, $from); |
| 267 | 267 | } elseif ($ob->oldUserId == $ob->requestedBy) { |
| 268 | - $notificationMessage = 'Swap accepted with '.$ob->newUserFirstName; |
|
| 268 | + $notificationMessage = 'Swap accepted with ' . $ob->newUserFirstName; |
|
| 269 | 269 | $notificationId = createNotificationForUser($ob->oldUserId, $notificationMessage, $message, 'swap', $linkToSwap); |
| 270 | - createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id='.$notificationId, $notificationMessage); |
|
| 270 | + createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id=' . $notificationId, $notificationMessage); |
|
| 271 | 271 | sendMail(getEmailWithId($ob->oldUserId), $subject, $message, $from); |
| 272 | 272 | } else { // notify both |
| 273 | - $notificationMessageOldUser = 'Swap accepted with '.$ob->newUserFirstName; |
|
| 274 | - $notificationMessageNewUser = 'Swap accepted with '.$ob->oldUserFirstName; |
|
| 273 | + $notificationMessageOldUser = 'Swap accepted with ' . $ob->newUserFirstName; |
|
| 274 | + $notificationMessageNewUser = 'Swap accepted with ' . $ob->oldUserFirstName; |
|
| 275 | 275 | $notificationIdOldUser = createNotificationForUser($ob->oldUserId, $notificationMessageOldUser, $message, 'swap', $linkToSwap); |
| 276 | 276 | $notificationIdNewUser = createNotificationForUser($ob->newUserId, $notificationMessageNewUser, $message, 'swap', $linkToSwap); |
| 277 | - createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id='.$notificationIdOldUser, $notificationMessage); |
|
| 278 | - createFacebookNotificationForUser($ob->newUserId, 'notification.php?id='.$notificationIdNewUser, $notificationMessage); |
|
| 277 | + createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id=' . $notificationIdOldUser, $notificationMessage); |
|
| 278 | + createFacebookNotificationForUser($ob->newUserId, 'notification.php?id=' . $notificationIdNewUser, $notificationMessage); |
|
| 279 | 279 | sendMail(getEmailWithId($ob->oldUserId), $subject, $message, $from); |
| 280 | 280 | sendMail(getEmailWithId($ob->newUserId), $subject, $message, $from); |
| 281 | 281 | } |
| 282 | 282 | } else { // notify both users |
| 283 | 283 | $sessionUserFirstName = getFirstNameWithId($sessionUserId); |
| 284 | - $notificationMessageOldUser = $sessionUserFirstName.' accepted a swap for '.$ob->newUserFirstName; |
|
| 285 | - $notificationMessageNewUser = $sessionUserFirstName.' accepted a swap for '.$ob->oldUserFirstName; |
|
| 284 | + $notificationMessageOldUser = $sessionUserFirstName . ' accepted a swap for ' . $ob->newUserFirstName; |
|
| 285 | + $notificationMessageNewUser = $sessionUserFirstName . ' accepted a swap for ' . $ob->oldUserFirstName; |
|
| 286 | 286 | $notificationIdOldUser = createNotificationForUser($ob->oldUserId, $notificationMessageOldUser, $message, 'swap', $linkToSwap); |
| 287 | 287 | $notificationIdNewUser = createNotificationForUser($ob->newUserId, $notificationMessageNewUser, $message, 'swap', $linkToSwap); |
| 288 | - createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id='.$notificationIdOldUser, $notificationMessage); |
|
| 289 | - createFacebookNotificationForUser($ob->newUserId, 'notification.php?id='.$notificationIdNewUser, $notificationMessage); |
|
| 288 | + createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id=' . $notificationIdOldUser, $notificationMessage); |
|
| 289 | + createFacebookNotificationForUser($ob->newUserId, 'notification.php?id=' . $notificationIdNewUser, $notificationMessage); |
|
| 290 | 290 | sendMail(getEmailWithId($ob->oldUserId), $subject, $message, $from); |
| 291 | 291 | sendMail(getEmailWithId($ob->newUserId), $subject, $message, $from); |
| 292 | 292 | } |
@@ -315,39 +315,39 @@ discard block |
||
| 315 | 315 | |
| 316 | 316 | $ob = mysqli_fetch_object($result); |
| 317 | 317 | |
| 318 | - $subject = 'Swap declined: '.$ob->newUserName.' - '.$ob->eventDate; |
|
| 319 | - $message = "The following swap has been declined\r\n\r\n". |
|
| 320 | - "Date:\t\t ".strftime($ob->time_format_long, strtotime($ob->eventDate))."\r\n". |
|
| 321 | - "Requested by:\t\t ".$ob->requestedBy."\r\n". |
|
| 322 | - "Swap from:\t\t ".$ob->oldUserName.' - '.$ob->oldRole."\r\n". |
|
| 323 | - "Swap to:\t\t ".$ob->newUserName.' - '.$ob->newRole."\r\n"; |
|
| 318 | + $subject = 'Swap declined: ' . $ob->newUserName . ' - ' . $ob->eventDate; |
|
| 319 | + $message = "The following swap has been declined\r\n\r\n" . |
|
| 320 | + "Date:\t\t " . strftime($ob->time_format_long, strtotime($ob->eventDate)) . "\r\n" . |
|
| 321 | + "Requested by:\t\t " . $ob->requestedBy . "\r\n" . |
|
| 322 | + "Swap from:\t\t " . $ob->oldUserName . ' - ' . $ob->oldRole . "\r\n" . |
|
| 323 | + "Swap to:\t\t " . $ob->newUserName . ' - ' . $ob->newRole . "\r\n"; |
|
| 324 | 324 | |
| 325 | 325 | $from = $ob->siteadmin; |
| 326 | 326 | |
| 327 | - $linkToSwap = 'swap.php?swap='.$swapId; |
|
| 327 | + $linkToSwap = 'swap.php?swap=' . $swapId; |
|
| 328 | 328 | |
| 329 | 329 | $sessionUserId = $_SESSION['userid']; |
| 330 | 330 | |
| 331 | 331 | if ($sessionUserId == $ob->oldUserId) { // if old user declines swap |
| 332 | 332 | // notify new user |
| 333 | - $notificationMessage = $ob->oldUserFirstName.' declined a swap'; |
|
| 333 | + $notificationMessage = $ob->oldUserFirstName . ' declined a swap'; |
|
| 334 | 334 | $notificationId = createNotificationForUser($ob->newUserId, $notificationMessage, $message, 'swap', $linkToSwap); |
| 335 | - createFacebookNotificationForUser($ob->newUserId, 'notification.php?id='.$notificationId, $notificationMessage); |
|
| 335 | + createFacebookNotificationForUser($ob->newUserId, 'notification.php?id=' . $notificationId, $notificationMessage); |
|
| 336 | 336 | sendMail(getEmailWithId($ob->newUserId), $subject, $message, $from); |
| 337 | 337 | } elseif ($sessionUserId == $ob->newUserId) { // if new user declines swap |
| 338 | 338 | // notify old user |
| 339 | - $notificationMessage = $ob->newUserFirstName.' declined a swap'; |
|
| 339 | + $notificationMessage = $ob->newUserFirstName . ' declined a swap'; |
|
| 340 | 340 | $notificationId = createNotificationForUser($ob->oldUserId, $notificationMessage, $message, 'swap', $linkToSwap); |
| 341 | - createFacebookNotificationForUser($ob->newUserId, 'notification.php?id='.$notificationId, $notificationMessage); |
|
| 341 | + createFacebookNotificationForUser($ob->newUserId, 'notification.php?id=' . $notificationId, $notificationMessage); |
|
| 342 | 342 | sendMail(getEmailWithId($ob->oldUserId), $subject, $message, $from); |
| 343 | 343 | } else { // notify both users |
| 344 | 344 | $sessionUserFirstName = getFirstNameWithId($sessionUserId); |
| 345 | - $notificationMessageOldUser = $sessionUserFirstName.' declined a swap for '.$ob->newUserFirstName; |
|
| 346 | - $notificationMessageNewUser = $sessionUserFirstName.' declined a swap for '.$ob->oldUserFirstName; |
|
| 345 | + $notificationMessageOldUser = $sessionUserFirstName . ' declined a swap for ' . $ob->newUserFirstName; |
|
| 346 | + $notificationMessageNewUser = $sessionUserFirstName . ' declined a swap for ' . $ob->oldUserFirstName; |
|
| 347 | 347 | $notificationIdOldUser = createNotificationForUser($ob->oldUserId, $notificationMessageOldUser, $message, 'swap', $linkToSwap); |
| 348 | 348 | $notificationIdNewUser = createNotificationForUser($ob->newUserId, $notificationMessageNewUser, $message, 'swap', $linkToSwap); |
| 349 | - createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id='.$notificationIdOldUser, $notificationMessage); |
|
| 350 | - createFacebookNotificationForUser($ob->newUserId, 'notification.php?id='.$notificationIdNewUser, $notificationMessage); |
|
| 349 | + createFacebookNotificationForUser($ob->oldUserId, 'notification.php?id=' . $notificationIdOldUser, $notificationMessage); |
|
| 350 | + createFacebookNotificationForUser($ob->newUserId, 'notification.php?id=' . $notificationIdNewUser, $notificationMessage); |
|
| 351 | 351 | sendMail(getEmailWithId($ob->newUserId), $subject, $message, $from); |
| 352 | 352 | sendMail(getEmailWithId($ob->oldUserId), $subject, $message, $from); |
| 353 | 353 | } |
@@ -496,7 +496,7 @@ discard block |
||
| 496 | 496 | |
| 497 | 497 | $sql = "UPDATE eventGroups SET archived = true WHERE id = '$seriesId'"; |
| 498 | 498 | if (!mysqli_query(db(), $sql)) { |
| 499 | - die('Error: '.mysqli_error(db())); |
|
| 499 | + die('Error: ' . mysqli_error(db())); |
|
| 500 | 500 | } |
| 501 | 501 | } |
| 502 | 502 | |
@@ -505,13 +505,13 @@ discard block |
||
| 505 | 505 | $sql = "INSERT INTO bandMembers (bandId, userRoleId) VALUES ('$bandId', '$userRoleId')"; |
| 506 | 506 | |
| 507 | 507 | if (!mysqli_query(db(), $sql)) { |
| 508 | - die('Error: '.mysqli_error(db())); |
|
| 508 | + die('Error: ' . mysqli_error(db())); |
|
| 509 | 509 | } |
| 510 | 510 | } |
| 511 | 511 | |
| 512 | 512 | function getEventUrl($eventId) |
| 513 | 513 | { |
| 514 | - return 'event.php?id='.$eventId; |
|
| 514 | + return 'event.php?id=' . $eventId; |
|
| 515 | 515 | } |
| 516 | 516 | |
| 517 | 517 | function getEventDetails($eventID, $separator, $type = 4, $apprev_description = true, $prefix = '') |
@@ -551,9 +551,9 @@ discard block |
||
| 551 | 551 | e.id = $eventID "; |
| 552 | 552 | |
| 553 | 553 | if ($type == 1) { |
| 554 | - $sql = $sql."AND ((g.id in (10,11)) OR (g.id=2 and u.firstname='Team')) "; |
|
| 554 | + $sql = $sql . "AND ((g.id in (10,11)) OR (g.id=2 and u.firstname='Team')) "; |
|
| 555 | 555 | } |
| 556 | - $sql = $sql.'ORDER BY e.id, g.id desc, role, firstname, lastname '; |
|
| 556 | + $sql = $sql . 'ORDER BY e.id, g.id desc, role, firstname, lastname '; |
|
| 557 | 557 | |
| 558 | 558 | $result = mysqli_query(db(), $sql) or die(mysqli_error(db())); |
| 559 | 559 | |
@@ -571,32 +571,32 @@ discard block |
||
| 571 | 571 | |
| 572 | 572 | $firstname = $row['firstname']; |
| 573 | 573 | if ($firstname != 'Team') { |
| 574 | - $firstname = ltrim(substr($firstname, 0, 1).'.', '.'); |
|
| 574 | + $firstname = ltrim(substr($firstname, 0, 1) . '.', '.'); |
|
| 575 | 575 | } |
| 576 | 576 | |
| 577 | 577 | $lastname = $row['lastname']; |
| 578 | 578 | |
| 579 | - $returnValue = $returnValue.$separator; |
|
| 579 | + $returnValue = $returnValue . $separator; |
|
| 580 | 580 | switch ($type) { |
| 581 | 581 | case 0: |
| 582 | 582 | //all persons of event |
| 583 | 583 | //break; -> no special handling, fallthrough to case 1 |
| 584 | 584 | case 1: |
| 585 | 585 | //only persons with groupID in 10,11,2 -> handled in sql query |
| 586 | - $returnValue = $returnValue.$prefix.ltrim($group.': '); |
|
| 587 | - $returnValue = $returnValue.trim($firstname.' '.$lastname); |
|
| 586 | + $returnValue = $returnValue . $prefix . ltrim($group . ': '); |
|
| 587 | + $returnValue = $returnValue . trim($firstname . ' ' . $lastname); |
|
| 588 | 588 | break; |
| 589 | 589 | case 2: |
| 590 | 590 | //only event date and event type |
| 591 | - $returnValue = $returnValue.strftime($time_format_normal, strtotime($eventDate)); |
|
| 592 | - $returnValue = $returnValue.$separator; |
|
| 593 | - $returnValue = $returnValue.$eventType; |
|
| 591 | + $returnValue = $returnValue . strftime($time_format_normal, strtotime($eventDate)); |
|
| 592 | + $returnValue = $returnValue . $separator; |
|
| 593 | + $returnValue = $returnValue . $eventType; |
|
| 594 | 594 | |
| 595 | 595 | return trim(substr($returnValue, strlen($separator) - 1)); //ends while loop |
| 596 | 596 | break; |
| 597 | 597 | case 4: |
| 598 | 598 | //only event type |
| 599 | - $returnValue = $returnValue.$eventType; |
|
| 599 | + $returnValue = $returnValue . $eventType; |
|
| 600 | 600 | |
| 601 | 601 | return trim(substr($returnValue, strlen($separator) - 1)); //ends while loop |
| 602 | 602 | break; |
@@ -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 | |
@@ -167,7 +167,7 @@ discard block |
||
| 167 | 167 | skin='$skin'"; |
| 168 | 168 | |
| 169 | 169 | if (!mysqli_query(db(), $sql)) { |
| 170 | - die('Error: '.mysqli_error(db())); |
|
| 170 | + die('Error: ' . mysqli_error(db())); |
|
| 171 | 171 | } |
| 172 | 172 | header('Location: settings.php'); |
| 173 | 173 | } |
@@ -194,7 +194,7 @@ discard block |
||
| 194 | 194 | <!-- Content Header (Page header) --> |
| 195 | 195 | <section class="content-header"> |
| 196 | 196 | <h1>Settings |
| 197 | - <?php echo '<small>v'.$row['version'].'</small>'; ?> |
|
| 197 | + <?php echo '<small>v' . $row['version'] . '</small>'; ?> |
|
| 198 | 198 | </h1> |
| 199 | 199 | <ol class="breadcrumb"> |
| 200 | 200 | <li><a href="<?php echo siteSettings()->getSiteUrl() ?>"><i class="fa fa-dashboard"></i> Home</a></li> |
@@ -21,7 +21,7 @@ discard block |
||
| 21 | 21 | $container = $app->getContainer(); |
| 22 | 22 | |
| 23 | 23 | // TWIG view renderer |
| 24 | -$container['view'] = function ($c) { |
|
| 24 | +$container['view'] = function($c) { |
|
| 25 | 25 | $settings = $c->get('settings')['renderer']; |
| 26 | 26 | $view = new Twig($settings['template_path'], [ |
| 27 | 27 | 'cache' => false, // or 'path/to/cache' |
@@ -46,7 +46,7 @@ discard block |
||
| 46 | 46 | $env = $view->getEnvironment(); |
| 47 | 47 | $env->addGlobal('site', new Site()); |
| 48 | 48 | $env->addGlobal('currenturl', $c->get('request')->getUri()); |
| 49 | - $env->addGlobal('currentpath', $c->get('request')->getUri()->getBasePath().'/'.$c->get('request')->getUri()->getPath()); |
|
| 49 | + $env->addGlobal('currentpath', $c->get('request')->getUri()->getBasePath() . '/' . $c->get('request')->getUri()->getPath()); |
|
| 50 | 50 | |
| 51 | 51 | if (isset($_SESSION['userId'])) { |
| 52 | 52 | $u = UserQuery::create()->findPk($_SESSION['userId']); |
@@ -59,7 +59,7 @@ discard block |
||
| 59 | 59 | }; |
| 60 | 60 | |
| 61 | 61 | // monolog |
| 62 | -$container['logger'] = function ($c) { |
|
| 62 | +$container['logger'] = function($c) { |
|
| 63 | 63 | $settings = $c->get('settings')['logger']; |
| 64 | 64 | $logger = new Monolog\Logger($settings['name']); |
| 65 | 65 | $logger->pushProcessor(new Monolog\Processor\UidProcessor()); |
@@ -68,7 +68,7 @@ discard block |
||
| 68 | 68 | return $logger; |
| 69 | 69 | }; |
| 70 | 70 | |
| 71 | -$container['auth'] = function ($c) { |
|
| 71 | +$container['auth'] = function($c) { |
|
| 72 | 72 | $authConfig = getConfig()['auth']; |
| 73 | 73 | |
| 74 | 74 | // full domain e.g. https://example.com |
@@ -86,7 +86,7 @@ discard block |
||
| 86 | 86 | break; |
| 87 | 87 | |
| 88 | 88 | case 'onebody': |
| 89 | - $url = $authConfig['onebody']['url'].'/'; |
|
| 89 | + $url = $authConfig['onebody']['url'] . '/'; |
|
| 90 | 90 | $email = new EmailAddress($authConfig['onebody']['email']); |
| 91 | 91 | $apiKey = $authConfig['onebody']['apiKey']; |
| 92 | 92 | |
@@ -116,6 +116,6 @@ discard block |
||
| 116 | 116 | return new Authentication($c, $authProvider, $allowedRoutes); |
| 117 | 117 | }; |
| 118 | 118 | |
| 119 | -$container['csrf'] = function ($c) { |
|
| 119 | +$container['csrf'] = function($c) { |
|
| 120 | 120 | return new Guard(); |
| 121 | 121 | }; |
@@ -8,7 +8,7 @@ |
||
| 8 | 8 | // Application middleware |
| 9 | 9 | |
| 10 | 10 | // 4) add route information to twig |
| 11 | -$app->add(function (Request $request, Response $response, callable $next) { |
|
| 11 | +$app->add(function(Request $request, Response $response, callable $next) { |
|
| 12 | 12 | $route = $request->getAttribute('route'); |
| 13 | 13 | |
| 14 | 14 | // return NotFound for non existent route |
@@ -24,12 +24,12 @@ discard block |
||
| 24 | 24 | |
| 25 | 25 | $stage = 1; |
| 26 | 26 | |
| 27 | - $configPath = __DIR__.'/../../../config'; |
|
| 27 | + $configPath = __DIR__ . '/../../../config'; |
|
| 28 | 28 | if ( |
| 29 | - file_exists($configPath.'/auth.php') |
|
| 30 | - && file_exists($configPath.'/database.php') |
|
| 31 | - && file_exists($configPath.'/email.php') |
|
| 32 | - && file_exists($configPath.'/recording.php') |
|
| 29 | + file_exists($configPath . '/auth.php') |
|
| 30 | + && file_exists($configPath . '/database.php') |
|
| 31 | + && file_exists($configPath . '/email.php') |
|
| 32 | + && file_exists($configPath . '/recording.php') |
|
| 33 | 33 | ) { |
| 34 | 34 | $stage = 2; |
| 35 | 35 | } |
@@ -77,17 +77,17 @@ discard block |
||
| 77 | 77 | 'command' => 'sql:build', |
| 78 | 78 | '-vvv' => true, |
| 79 | 79 | '--overwrite' => true, |
| 80 | - '--config-dir' => __DIR__.'/../../../generated-conf', |
|
| 81 | - '--schema-dir' => __DIR__.'/../../../', |
|
| 82 | - '--output-dir' => __DIR__.'/../../../build/sql', |
|
| 80 | + '--config-dir' => __DIR__ . '/../../../generated-conf', |
|
| 81 | + '--schema-dir' => __DIR__ . '/../../../', |
|
| 82 | + '--output-dir' => __DIR__ . '/../../../build/sql', |
|
| 83 | 83 | ]); |
| 84 | 84 | $propelGenerator->run($input, $output); |
| 85 | 85 | |
| 86 | 86 | $input = new ArrayInput([ |
| 87 | 87 | 'command' => 'sql:insert', |
| 88 | 88 | '-vvv' => true, |
| 89 | - '--config-dir' => __DIR__.'/../../../generated-conf', |
|
| 90 | - '--sql-dir' => __DIR__.'/../../../build/sql', |
|
| 89 | + '--config-dir' => __DIR__ . '/../../../generated-conf', |
|
| 90 | + '--sql-dir' => __DIR__ . '/../../../build/sql', |
|
| 91 | 91 | ]); |
| 92 | 92 | $propelGenerator->run($input, $output); |
| 93 | 93 | |
@@ -99,7 +99,7 @@ discard block |
||
| 99 | 99 | $existingUserCount = UserQuery::create()->count(); |
| 100 | 100 | } catch (\Propel\Runtime\Exception\PropelException $e) { |
| 101 | 101 | if ($e->getPrevious()->getCode() === '42S02') { |
| 102 | - return $response->getBody()->write('Error installing database:'."\n".$outputString); |
|
| 102 | + return $response->getBody()->write('Error installing database:' . "\n" . $outputString); |
|
| 103 | 103 | } |
| 104 | 104 | } |
| 105 | 105 | |
@@ -152,7 +152,7 @@ discard block |
||
| 152 | 152 | |
| 153 | 153 | return $this->view->render($response, 'login-credentials.twig', [ |
| 154 | 154 | 'username' => $user->getEmail(), |
| 155 | - 'message' => 'Your password is: '.$password.' Copy it somewhere safe as it will not be displayed again. You can change it once you\'ve logged in.', |
|
| 155 | + 'message' => 'Your password is: ' . $password . ' Copy it somewhere safe as it will not be displayed again. You can change it once you\'ve logged in.', |
|
| 156 | 156 | ]); |
| 157 | 157 | } |
| 158 | 158 | |
@@ -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 | |
| 5 | 5 | return [ |
| 6 | 6 | 'propel' => [ |
@@ -9,7 +9,7 @@ discard block |
||
| 9 | 9 | 'default' => [ |
| 10 | 10 | 'adapter' => 'mysql', |
| 11 | 11 | 'classname' => 'Propel\Runtime\Connection\ConnectionWrapper', |
| 12 | - 'dsn' => 'mysql:host='.$config['db']['host'].';dbname='.$config['db']['dbname'], |
|
| 12 | + 'dsn' => 'mysql:host=' . $config['db']['host'] . ';dbname=' . $config['db']['dbname'], |
|
| 13 | 13 | 'user' => $config['db']['user'], |
| 14 | 14 | 'password' => $config['db']['pass'], |
| 15 | 15 | 'attributes' => [], |
@@ -6,7 +6,7 @@ |
||
| 6 | 6 | } |
| 7 | 7 | |
| 8 | 8 | if (isset($_GET['filter'])) { |
| 9 | - header('Location: ../events/type/'.(int) $_GET['filter']); |
|
| 9 | + header('Location: ../events/type/' . (int) $_GET['filter']); |
|
| 10 | 10 | exit; |
| 11 | 11 | } |
| 12 | 12 | |
@@ -22,35 +22,35 @@ discard block |
||
| 22 | 22 | // USER |
| 23 | 23 | // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| 24 | 24 | |
| 25 | -$app->group('/user', function () { |
|
| 26 | - $this->get('s', UserController::class.':getAllUsers')->setName('users'); |
|
| 25 | +$app->group('/user', function() { |
|
| 26 | + $this->get('s', UserController::class . ':getAllUsers')->setName('users'); |
|
| 27 | 27 | |
| 28 | - $this->get('/{id}/widget-only', UserController::class.':getUserWidgetOnly')->setName('user-widget-only'); |
|
| 28 | + $this->get('/{id}/widget-only', UserController::class . ':getUserWidgetOnly')->setName('user-widget-only'); |
|
| 29 | 29 | |
| 30 | - $this->get('/new', UserController::class.':getNewUserForm')->setName('user-new'); |
|
| 31 | - $this->get('/{id}/edit', UserController::class.':getUserEditForm')->setName('user-edit'); |
|
| 32 | - $this->get('/{id}/password', UserController::class.':getUserPasswordForm')->setName('user-password'); |
|
| 30 | + $this->get('/new', UserController::class . ':getNewUserForm')->setName('user-new'); |
|
| 31 | + $this->get('/{id}/edit', UserController::class . ':getUserEditForm')->setName('user-edit'); |
|
| 32 | + $this->get('/{id}/password', UserController::class . ':getUserPasswordForm')->setName('user-password'); |
|
| 33 | 33 | |
| 34 | - $this->get('/me', UserController::class.':getCurrentUser')->setName('user-me'); |
|
| 35 | - $this->get('/{id}', UserController::class.':getUser')->setName('user'); |
|
| 34 | + $this->get('/me', UserController::class . ':getCurrentUser')->setName('user-me'); |
|
| 35 | + $this->get('/{id}', UserController::class . ':getUser')->setName('user'); |
|
| 36 | 36 | |
| 37 | - $this->post('[/{id}]', UserController::class.':postUser')->setName('user-post'); |
|
| 38 | - $this->post('/{id}/password', UserController::class.':postUserPasswordChange')->setName('user-password-post'); |
|
| 37 | + $this->post('[/{id}]', UserController::class . ':postUser')->setName('user-post'); |
|
| 38 | + $this->post('/{id}/password', UserController::class . ':postUserPasswordChange')->setName('user-password-post'); |
|
| 39 | 39 | |
| 40 | 40 | // roles |
| 41 | - $this->get('/{id}/roles', RoleController::class.':getAssignRolesForm')->setName('user-roles'); |
|
| 42 | - $this->post('/{id}/roles', RoleController::class.':postUserAssignRoles')->setName('user-assign-post'); |
|
| 41 | + $this->get('/{id}/roles', RoleController::class . ':getAssignRolesForm')->setName('user-roles'); |
|
| 42 | + $this->post('/{id}/roles', RoleController::class . ':postUserAssignRoles')->setName('user-assign-post'); |
|
| 43 | 43 | |
| 44 | 44 | // availability |
| 45 | - $this->get('/{id}/availability', AvailabilityController::class.':getAvailabilityForm')->setName('user-availability'); |
|
| 46 | - $this->post('/{id}/availability', AvailabilityController::class.':postAvailability')->setName('user-availability-post'); |
|
| 45 | + $this->get('/{id}/availability', AvailabilityController::class . ':getAvailabilityForm')->setName('user-availability'); |
|
| 46 | + $this->post('/{id}/availability', AvailabilityController::class . ':postAvailability')->setName('user-availability-post'); |
|
| 47 | 47 | |
| 48 | 48 | // calendar |
| 49 | - $this->group('/me/calendar', function () { |
|
| 50 | - $this->get('s', CalendarController::class.':getCalendarTokens')->setName('user-calendars'); |
|
| 51 | - $this->get('/new', CalendarController::class.':getNewCalendarForm')->setName('user-calendars'); |
|
| 52 | - $this->get('/{id}/revoke', CalendarController::class.':getRevokeCalendar')->setName('user-calendar-revoke'); |
|
| 53 | - $this->post('/new', CalendarController::class.':postNewCalendar')->setName('user-calendar-new-post'); |
|
| 49 | + $this->group('/me/calendar', function() { |
|
| 50 | + $this->get('s', CalendarController::class . ':getCalendarTokens')->setName('user-calendars'); |
|
| 51 | + $this->get('/new', CalendarController::class . ':getNewCalendarForm')->setName('user-calendars'); |
|
| 52 | + $this->get('/{id}/revoke', CalendarController::class . ':getRevokeCalendar')->setName('user-calendar-revoke'); |
|
| 53 | + $this->post('/new', CalendarController::class . ':postNewCalendar')->setName('user-calendar-new-post'); |
|
| 54 | 54 | }); |
| 55 | 55 | }); |
| 56 | 56 | |
@@ -58,104 +58,104 @@ discard block |
||
| 58 | 58 | // EVENT |
| 59 | 59 | // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| 60 | 60 | |
| 61 | -$app->group('/event', function () { |
|
| 62 | - $this->get('s', EventController::class.':getAllEvents')->setName('events'); |
|
| 63 | - $this->get('s/type/{id}', EventController::class.':getAllEventsWithType')->setName('events-eventtype'); |
|
| 64 | - $this->get('s/subtype/{id}', EventController::class.':getAllEventsWithSubType')->setName('events-eventsubtype'); |
|
| 61 | +$app->group('/event', function() { |
|
| 62 | + $this->get('s', EventController::class . ':getAllEvents')->setName('events'); |
|
| 63 | + $this->get('s/type/{id}', EventController::class . ':getAllEventsWithType')->setName('events-eventtype'); |
|
| 64 | + $this->get('s/subtype/{id}', EventController::class . ':getAllEventsWithSubType')->setName('events-eventsubtype'); |
|
| 65 | 65 | |
| 66 | - $this->get('s/print/info', EventController::class.':getAllEventInfoToPrint')->setName('events-print-info'); |
|
| 66 | + $this->get('s/print/info', EventController::class . ':getAllEventInfoToPrint')->setName('events-print-info'); |
|
| 67 | 67 | |
| 68 | - $this->get('/new', EventController::class.':getNewEventForm')->setName('event-new'); |
|
| 69 | - $this->get('/{id}/edit', EventController::class.':getEventEditForm')->setName('event-edit'); |
|
| 70 | - $this->get('/{id}/copy', EventController::class.':getEventCopyForm')->setName('event-copy'); |
|
| 71 | - $this->get('/{id}/assign', EventController::class.':getEventAssignForm')->setName('event-assign'); |
|
| 68 | + $this->get('/new', EventController::class . ':getNewEventForm')->setName('event-new'); |
|
| 69 | + $this->get('/{id}/edit', EventController::class . ':getEventEditForm')->setName('event-edit'); |
|
| 70 | + $this->get('/{id}/copy', EventController::class . ':getEventCopyForm')->setName('event-copy'); |
|
| 71 | + $this->get('/{id}/assign', EventController::class . ':getEventAssignForm')->setName('event-assign'); |
|
| 72 | 72 | |
| 73 | - $this->get('/{id}', EventController::class.':getEvent')->setName('event'); |
|
| 73 | + $this->get('/{id}', EventController::class . ':getEvent')->setName('event'); |
|
| 74 | 74 | |
| 75 | - $this->post('[/{id}]', EventController::class.':postEvent')->setName('event-post'); |
|
| 76 | - $this->post('/{id}/assign', EventController::class.':postEventAssign')->setName('event-assign-post'); |
|
| 77 | - $this->post('/{id}/comment', EventController::class.':postEventComment')->setName('event-comment-post'); |
|
| 75 | + $this->post('[/{id}]', EventController::class . ':postEvent')->setName('event-post'); |
|
| 76 | + $this->post('/{id}/assign', EventController::class . ':postEventAssign')->setName('event-assign-post'); |
|
| 77 | + $this->post('/{id}/comment', EventController::class . ':postEventComment')->setName('event-comment-post'); |
|
| 78 | 78 | }); |
| 79 | 79 | |
| 80 | 80 | // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| 81 | 81 | // RESOURCE |
| 82 | 82 | // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| 83 | 83 | |
| 84 | -$app->group('/resource', function () { |
|
| 85 | - $this->get('s', ResourceController::class.':getAllResources')->setName('resources'); |
|
| 84 | +$app->group('/resource', function() { |
|
| 85 | + $this->get('s', ResourceController::class . ':getAllResources')->setName('resources'); |
|
| 86 | 86 | |
| 87 | - $this->get('[/new]', ResourceController::class.':getNewResourceForm')->setName('resource-new'); |
|
| 88 | - $this->get('/{id}/edit', ResourceController::class.':getResourceEditForm')->setName('resource-edit'); |
|
| 87 | + $this->get('[/new]', ResourceController::class . ':getNewResourceForm')->setName('resource-new'); |
|
| 88 | + $this->get('/{id}/edit', ResourceController::class . ':getResourceEditForm')->setName('resource-edit'); |
|
| 89 | 89 | |
| 90 | - $this->get('/{id}', ResourceController::class.':getResourceFile')->setName('resource'); |
|
| 90 | + $this->get('/{id}', ResourceController::class . ':getResourceFile')->setName('resource'); |
|
| 91 | 91 | |
| 92 | - $this->post('[/{id}]', ResourceController::class.':postResource')->setName('resource-post'); |
|
| 92 | + $this->post('[/{id}]', ResourceController::class . ':postResource')->setName('resource-post'); |
|
| 93 | 93 | }); |
| 94 | 94 | |
| 95 | 95 | // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| 96 | 96 | // ROLES & GROUPS |
| 97 | 97 | // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| 98 | 98 | |
| 99 | -$app->group('/group', function () { |
|
| 100 | - $this->get('/{id}', GroupController::class.':getGroup')->setName('group'); |
|
| 101 | - $this->get('/{id}/roles', GroupController::class.':getGroupRoles')->setName('group-roles'); |
|
| 102 | - $this->post('/{id}/roles', GroupController::class.':postGroupRoles')->setName('group-roles-post'); |
|
| 99 | +$app->group('/group', function() { |
|
| 100 | + $this->get('/{id}', GroupController::class . ':getGroup')->setName('group'); |
|
| 101 | + $this->get('/{id}/roles', GroupController::class . ':getGroupRoles')->setName('group-roles'); |
|
| 102 | + $this->post('/{id}/roles', GroupController::class . ':postGroupRoles')->setName('group-roles-post'); |
|
| 103 | 103 | |
| 104 | - $this->get('/{id}/events', EventController::class.':getAllEventsToPrintForGroup')->setName('group-events-print'); |
|
| 104 | + $this->get('/{id}/events', EventController::class . ':getAllEventsToPrintForGroup')->setName('group-events-print'); |
|
| 105 | 105 | |
| 106 | - $this->post('[/{id}]', GroupController::class.':postGroup')->setName('group-post'); |
|
| 106 | + $this->post('[/{id}]', GroupController::class . ':postGroup')->setName('group-post'); |
|
| 107 | 107 | }); |
| 108 | 108 | |
| 109 | 109 | // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| 110 | 110 | // AUTH |
| 111 | 111 | // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| 112 | 112 | |
| 113 | -$app->get('/login', AuthController::class.':getLoginForm')->setName('login'); |
|
| 113 | +$app->get('/login', AuthController::class . ':getLoginForm')->setName('login'); |
|
| 114 | 114 | |
| 115 | -$app->get('/login/{provider}', AuthController::class.':getLoginAuth')->setName('login-auth'); |
|
| 116 | -$app->get('/login/{provider}/callback', AuthController::class.':getLoginCallback')->setName('login-callback'); |
|
| 117 | -$app->get('/signup', PendingUserController::class.':getSignUpForm')->setName('sign-up'); |
|
| 118 | -$app->get('/signup/cancel', PendingUserController::class.':getSignUpCancel')->setName('sign-up-cancel'); |
|
| 115 | +$app->get('/login/{provider}', AuthController::class . ':getLoginAuth')->setName('login-auth'); |
|
| 116 | +$app->get('/login/{provider}/callback', AuthController::class . ':getLoginCallback')->setName('login-callback'); |
|
| 117 | +$app->get('/signup', PendingUserController::class . ':getSignUpForm')->setName('sign-up'); |
|
| 118 | +$app->get('/signup/cancel', PendingUserController::class . ':getSignUpCancel')->setName('sign-up-cancel'); |
|
| 119 | 119 | |
| 120 | -$app->get('/logout', AuthController::class.':getLogout')->setName('logout'); |
|
| 120 | +$app->get('/logout', AuthController::class . ':getLogout')->setName('logout'); |
|
| 121 | 121 | |
| 122 | -$app->post('/login', AuthController::class.':postLogin')->setName('login-post'); |
|
| 123 | -$app->post('/signup', PendingUserController::class.':postSignUp')->setName('sign-up-post'); |
|
| 122 | +$app->post('/login', AuthController::class . ':postLogin')->setName('login-post'); |
|
| 123 | +$app->post('/signup', PendingUserController::class . ':postSignUp')->setName('sign-up-post'); |
|
| 124 | 124 | |
| 125 | 125 | // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| 126 | 126 | // NOTIFICATIONS |
| 127 | 127 | // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| 128 | 128 | |
| 129 | -$app->get('/notification/{id}[/{referrer}]', NotificationController::class.':getNotificationClick')->setName('notification'); |
|
| 129 | +$app->get('/notification/{id}[/{referrer}]', NotificationController::class . ':getNotificationClick')->setName('notification'); |
|
| 130 | 130 | |
| 131 | 131 | // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| 132 | 132 | // CALENDAR |
| 133 | 133 | // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| 134 | 134 | |
| 135 | -$app->get('/calendar/{token}.{format}', CalendarController::class.':getRenderedCalendar')->setName('user-calendar'); |
|
| 135 | +$app->get('/calendar/{token}.{format}', CalendarController::class . ':getRenderedCalendar')->setName('user-calendar'); |
|
| 136 | 136 | |
| 137 | 137 | // legacy |
| 138 | -$app->get('/calendar.php', CalendarController::class.':getLegacyRenderedCalendar')->setName('user-calendar'); |
|
| 138 | +$app->get('/calendar.php', CalendarController::class . ':getLegacyRenderedCalendar')->setName('user-calendar'); |
|
| 139 | 139 | |
| 140 | 140 | // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| 141 | 141 | // OTHER |
| 142 | 142 | // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| 143 | 143 | |
| 144 | -$app->get('/settings', function ($request, $response, $args) { |
|
| 144 | +$app->get('/settings', function($request, $response, $args) { |
|
| 145 | 145 | // Sample log message |
| 146 | 146 | $this->logger->info("Fetch settings GET '/settings'"); |
| 147 | 147 | |
| 148 | - $url = $this->router->pathFor('home').'old/settings.php'; |
|
| 148 | + $url = $this->router->pathFor('home') . 'old/settings.php'; |
|
| 149 | 149 | |
| 150 | 150 | return $response->withStatus(303)->withHeader('Location', $url); |
| 151 | 151 | //return $this->view->render($response, 'settings.twig', []); |
| 152 | 152 | })->setName('settings'); |
| 153 | 153 | |
| 154 | -$app->get('/token', function ($request, $response, $args) { |
|
| 154 | +$app->get('/token', function($request, $response, $args) { |
|
| 155 | 155 | return $response->getBody()->write(Crypt::generateToken(30)); |
| 156 | 156 | })->setName('token'); |
| 157 | 157 | |
| 158 | -$app->get('/', function ($request, $response, $args) { |
|
| 158 | +$app->get('/', function($request, $response, $args) { |
|
| 159 | 159 | // Sample log message |
| 160 | 160 | $this->logger->info("Fetch home GET '/'"); |
| 161 | 161 | |
@@ -175,21 +175,21 @@ discard block |
||
| 175 | 175 | // INSTALL |
| 176 | 176 | // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| 177 | 177 | |
| 178 | -$app->group('/install', function () { |
|
| 179 | - $this->get('', InstallController::class.':getInstall')->setName('install'); |
|
| 178 | +$app->group('/install', function() { |
|
| 179 | + $this->get('', InstallController::class . ':getInstall')->setName('install'); |
|
| 180 | 180 | |
| 181 | - $this->get('/database', InstallController::class.':getInstallDatabase')->setName('install-database'); |
|
| 181 | + $this->get('/database', InstallController::class . ':getInstallDatabase')->setName('install-database'); |
|
| 182 | 182 | |
| 183 | - $this->get('/user', InstallController::class.':getFirstUserForm')->setName('install-user'); |
|
| 184 | - $this->post('/user', InstallController::class.':postFirstUserForm')->setName('install-user-post'); |
|
| 183 | + $this->get('/user', InstallController::class . ':getFirstUserForm')->setName('install-user'); |
|
| 184 | + $this->post('/user', InstallController::class . ':postFirstUserForm')->setName('install-user-post'); |
|
| 185 | 185 | }); |
| 186 | 186 | |
| 187 | 187 | // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| 188 | 188 | // JOBS |
| 189 | 189 | // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
| 190 | 190 | |
| 191 | -$app->group('/job', function () { |
|
| 192 | - $this->get('/daily/{token}', JobController::class.':getDaily')->setName('job-daily'); |
|
| 191 | +$app->group('/job', function() { |
|
| 192 | + $this->get('/daily/{token}', JobController::class . ':getDaily')->setName('job-daily'); |
|
| 193 | 193 | }); |
| 194 | 194 | |
| 195 | -require_once __DIR__.'/routes-legacy.php'; |
|
| 195 | +require_once __DIR__ . '/routes-legacy.php'; |
|