@@ -53,7 +53,7 @@ |
||
| 53 | 53 | $statusMessage = 'Sent successfully'; |
| 54 | 54 | } else { |
| 55 | 55 | foreach ($sent as $errorMessage) { |
| 56 | - $statusMessage .= '<p>'.$errorMessage.'</p>'; |
|
| 56 | + $statusMessage .= '<p>' . $errorMessage . '</p>'; |
|
| 57 | 57 | } |
| 58 | 58 | } |
| 59 | 59 | |
@@ -33,7 +33,7 @@ discard block |
||
| 33 | 33 | } else { |
| 34 | 34 | $notificationId = getQueryStringForKey('id'); |
| 35 | 35 | $referer = getQueryStringForKey('click'); |
| 36 | - $_SESSION['redirectUrl'] = siteSettings()->getSiteUrl().'/notification.php?id='.$notificationId.'&click='.$referer; |
|
| 36 | + $_SESSION['redirectUrl'] = siteSettings()->getSiteUrl() . '/notification.php?id=' . $notificationId . '&click=' . $referer; |
|
| 37 | 37 | header('Location: login.php'); |
| 38 | 38 | exit; |
| 39 | 39 | } |
@@ -60,7 +60,7 @@ discard block |
||
| 60 | 60 | // redir if notification has URL |
| 61 | 61 | $redir = notificationLink($notificationId); |
| 62 | 62 | if (!empty($redir)) { |
| 63 | - header('Location: '.$redir); |
|
| 63 | + header('Location: ' . $redir); |
|
| 64 | 64 | } |
| 65 | 65 | |
| 66 | 66 | // find notification |
@@ -111,7 +111,7 @@ discard block |
||
| 111 | 111 | FROM cr_eventTypes et |
| 112 | 112 | WHERE id IN (SELECT e.type |
| 113 | 113 | FROM cr_events e |
| 114 | - WHERE '.$whereTwoMonth.' |
|
| 114 | + WHERE '.$whereTwoMonth . ' |
|
| 115 | 115 | AND e.removed = 0) |
| 116 | 116 | ORDER BY name'; |
| 117 | 117 | $result = mysqli_query(db(), $filter_sql) or die(mysqli_error(db())); |
@@ -132,7 +132,7 @@ discard block |
||
| 132 | 132 | <tr> |
| 133 | 133 | <td ><strong>Event</strong></td> |
| 134 | 134 | <?php |
| 135 | - $sql = 'SELECT * FROM cr_groups g ORDER BY '.$group_sorting_name; |
|
| 135 | + $sql = 'SELECT * FROM cr_groups g ORDER BY ' . $group_sorting_name; |
|
| 136 | 136 | $result = mysqli_query(db(), $sql) or die(mysqli_error(db())); |
| 137 | 137 | |
| 138 | 138 | while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
@@ -163,7 +163,7 @@ discard block |
||
| 163 | 163 | |
| 164 | 164 | if ($filter == '') { |
| 165 | 165 | $sql .= ' |
| 166 | - AND '.$whereTwoMonth.' |
|
| 166 | + AND '.$whereTwoMonth . ' |
|
| 167 | 167 | ORDER BY |
| 168 | 168 | e.date'; |
| 169 | 169 | } elseif ($filter == 'all') { |
@@ -173,7 +173,7 @@ discard block |
||
| 173 | 173 | } elseif ($filter != '') { |
| 174 | 174 | $sql .= " |
| 175 | 175 | AND e.type = '$filter' |
| 176 | - AND ".$whereTwoMonth.' |
|
| 176 | + AND " . $whereTwoMonth . ' |
|
| 177 | 177 | ORDER BY |
| 178 | 178 | e.date'; |
| 179 | 179 | } |
@@ -188,34 +188,34 @@ discard block |
||
| 188 | 188 | echo '<tr>'; |
| 189 | 189 | echo '<td >'; |
| 190 | 190 | setlocale(LC_TIME, $lang_locale); //de_DE |
| 191 | - echo '<a href="event.php?id='.$row['id'].'">'; |
|
| 191 | + echo '<a href="event.php?id=' . $row['id'] . '">'; |
|
| 192 | 192 | echo strftime($time_format_short, strtotime($row['sundayDate'])); // %a, <strong>%e. %b</strong>, KW%V |
| 193 | 193 | echo '</a>'; |
| 194 | 194 | |
| 195 | 195 | //$row['sundayDate'] |
| 196 | 196 | if (!empty($row['eventType'])) { |
| 197 | - echo '<br /><em> '.$row['eventType'].'</em>'; |
|
| 197 | + echo '<br /><em> ' . $row['eventType'] . '</em>'; |
|
| 198 | 198 | } |
| 199 | 199 | if (!empty($row['eventSubType'])) { |
| 200 | - echo ' - <em>'.$row['eventSubType'].'</em>'; |
|
| 200 | + echo ' - <em>' . $row['eventSubType'] . '</em>'; |
|
| 201 | 201 | } |
| 202 | 202 | if (!empty($row['eventLocation'])) { |
| 203 | - echo '<br /><em> '.$row['eventLocation'].'</em>'; |
|
| 203 | + echo '<br /><em> ' . $row['eventLocation'] . '</em>'; |
|
| 204 | 204 | } |
| 205 | 205 | if (!empty($row['name'])) { |
| 206 | - echo '<br /><em> '.$row['name'].'</em>'; |
|
| 206 | + echo '<br /><em> ' . $row['name'] . '</em>'; |
|
| 207 | 207 | } |
| 208 | 208 | if (!empty($row['eventGroup'])) { |
| 209 | - echo '<br /><strong> '.$row['eventGroup'].'</strong>'; |
|
| 209 | + echo '<br /><strong> ' . $row['eventGroup'] . '</strong>'; |
|
| 210 | 210 | } |
| 211 | 211 | if (!empty($row['sermonTitle'])) { |
| 212 | - echo ': '.$row['sermonTitle']; |
|
| 212 | + echo ': ' . $row['sermonTitle']; |
|
| 213 | 213 | } |
| 214 | 214 | if (!empty($row['bibleVerse'])) { |
| 215 | - echo ' <em>('.$row['bibleVerse'].')</em>'; |
|
| 215 | + echo ' <em>(' . $row['bibleVerse'] . ')</em>'; |
|
| 216 | 216 | } |
| 217 | 217 | if (!empty($row['comment'])) { |
| 218 | - echo '<br /><em> ('.$row['comment'].')</em>'; |
|
| 218 | + echo '<br /><em> (' . $row['comment'] . ')</em>'; |
|
| 219 | 219 | } |
| 220 | 220 | echo '</td>'; |
| 221 | 221 | |
@@ -247,16 +247,16 @@ discard block |
||
| 247 | 247 | if ($previousName == '') { |
| 248 | 248 | // new name |
| 249 | 249 | echo ($viewPeople['userId'] == $sessionUserId) ? '<strong class="me">' : ''; |
| 250 | - echo $name.' <em>('.$viewPeople['role']; |
|
| 250 | + echo $name . ' <em>(' . $viewPeople['role']; |
|
| 251 | 251 | } elseif ($previousName != $name) { |
| 252 | 252 | echo ')</em>'; |
| 253 | 253 | echo ($viewPeople['userId'] != $sessionUserId) ? '</strong>' : ''; |
| 254 | 254 | echo '<br />'; // line break from previous name |
| 255 | 255 | // new name |
| 256 | 256 | echo ($viewPeople['userId'] == $sessionUserId) ? '<strong class="me">' : ''; |
| 257 | - echo $name.' <em>('.$viewPeople['role']; |
|
| 257 | + echo $name . ' <em>(' . $viewPeople['role']; |
|
| 258 | 258 | } else { |
| 259 | - echo ', '.$viewPeople['role']; |
|
| 259 | + echo ', ' . $viewPeople['role']; |
|
| 260 | 260 | } |
| 261 | 261 | |
| 262 | 262 | $peopleInEvent = true; |
@@ -39,18 +39,18 @@ discard block |
||
| 39 | 39 | $sql = "UPDATE cr_documents SET title = '$resourcename', description = '$resourcedescription', link = '$resourcelink' WHERE id = '$id'"; |
| 40 | 40 | |
| 41 | 41 | if (!mysqli_query(db(), $sql)) { |
| 42 | - die('Error: '.mysqli_error(db())); |
|
| 42 | + die('Error: ' . mysqli_error(db())); |
|
| 43 | 43 | } |
| 44 | 44 | } else { |
| 45 | 45 | if ($_FILES['resourcefile']['tmp_name'] == 'none') { |
| 46 | 46 | } else { |
| 47 | 47 | $filename = $_FILES['resourcefile']['name']; |
| 48 | - copy($_FILES['resourcefile']['tmp_name'], './documents/'.$_FILES['resourcefile']['name']); |
|
| 48 | + copy($_FILES['resourcefile']['tmp_name'], './documents/' . $_FILES['resourcefile']['name']); |
|
| 49 | 49 | } |
| 50 | 50 | |
| 51 | 51 | $sql = ("INSERT INTO cr_documents (title, description, url, link) VALUES ('$resourcename', '$resourcedescription', '$filename', '$resourcelink')"); |
| 52 | 52 | if (!mysqli_query(db(), $sql)) { |
| 53 | - die('Error: '.mysqli_error(db())); |
|
| 53 | + die('Error: ' . mysqli_error(db())); |
|
| 54 | 54 | } |
| 55 | 55 | // After we have inserted the data, we want to head back to the main page |
| 56 | 56 | } |
@@ -83,7 +83,7 @@ discard block |
||
| 83 | 83 | if ($action == 'new') { |
| 84 | 84 | $actionlink = 'resources.php?action=newsent'; |
| 85 | 85 | } else { |
| 86 | - $actionlink = 'resources.php?action=editsent&id='.$id; |
|
| 86 | + $actionlink = 'resources.php?action=editsent&id=' . $id; |
|
| 87 | 87 | $sql = "SELECT * FROM cr_documents WHERE id = '$id'"; |
| 88 | 88 | $result = mysqli_query(db(), $sql) or die(mysqli_error(db())); |
| 89 | 89 | |
@@ -206,7 +206,7 @@ discard block |
||
| 206 | 206 | <?php echo $Parsedown->text(htmlspecialchars($row['description'])); ?> |
| 207 | 207 | </div> |
| 208 | 208 | <div class="box-footer"> |
| 209 | - <a class="btn btn-primary" href="<?php echo ($row['url'] != '') ? 'documents/'.$row['url'] : '#' ?>">Download</a> |
|
| 209 | + <a class="btn btn-primary" href="<?php echo ($row['url'] != '') ? 'documents/' . $row['url'] : '#' ?>">Download</a> |
|
| 210 | 210 | <?php if (isAdmin()): ?> |
| 211 | 211 | <a class="btn btn-warning" href='resources.php?action=edit&id=<?php echo $resourceID; ?>'><i class='fa fa-pencil'></i> Edit</a> |
| 212 | 212 | <button type="button" class='btn btn-danger' data-toggle='modal' data-target='#deleteModal<?php echo $resourceID; ?>'><i class='fa fa-times'></i> Remove</a> |
@@ -105,7 +105,7 @@ |
||
| 105 | 105 | <label class="fa fa-lock" for="login__password"><span class="hidden">Password</span></label> |
| 106 | 106 | <input name="password" id="login__password" type="password" class="form__input" placeholder="Password" required> |
| 107 | 107 | </div> |
| 108 | - <?php if (!empty($message)): echo '<p>'.$message.'</p>'; endif; ?> |
|
| 108 | + <?php if (!empty($message)): echo '<p>' . $message . '</p>'; endif; ?> |
|
| 109 | 109 | <div class="form__field"> |
| 110 | 110 | <input type="submit" value="Sign In"> |
| 111 | 111 | </div> |
@@ -41,10 +41,10 @@ discard block |
||
| 41 | 41 | // Returns a `Facebook\FacebookResponse` object |
| 42 | 42 | $response = $fb->get('/me?fields=id,name,email', $accessToken); |
| 43 | 43 | } catch (Facebook\Exceptions\FacebookResponseException $e) { |
| 44 | - echo 'Graph returned an error: '.$e->getMessage(); |
|
| 44 | + echo 'Graph returned an error: ' . $e->getMessage(); |
|
| 45 | 45 | exit; |
| 46 | 46 | } catch (Facebook\Exceptions\FacebookSDKException $e) { |
| 47 | - echo 'Facebook SDK returned an error: '.$e->getMessage(); |
|
| 47 | + echo 'Facebook SDK returned an error: ' . $e->getMessage(); |
|
| 48 | 48 | exit; |
| 49 | 49 | } |
| 50 | 50 | |
@@ -91,7 +91,7 @@ discard block |
||
| 91 | 91 | <label class="fa fa-envelope-o" for="email"><span class="hidden">Email address</span></label> |
| 92 | 92 | <input name="email" id="email" type="text" class="form__input" placeholder="Email address" value="<?php echo $user->getEmail(); ?>" required> |
| 93 | 93 | </div> |
| 94 | - <?php if (!empty($message)): echo '<p>'.$message.'</p>'; endif; ?> |
|
| 94 | + <?php if (!empty($message)): echo '<p>' . $message . '</p>'; endif; ?> |
|
| 95 | 95 | <div class="form__field"> |
| 96 | 96 | <input type="submit" value="Request access"> |
| 97 | 97 | </div> |
@@ -33,7 +33,7 @@ discard block |
||
| 33 | 33 | exit; |
| 34 | 34 | } |
| 35 | 35 | if (!isAdmin()) { |
| 36 | - header('Location: error.php?no=100&page='.basename($_SERVER['SCRIPT_FILENAME'])); |
|
| 36 | + header('Location: error.php?no=100&page=' . basename($_SERVER['SCRIPT_FILENAME'])); |
|
| 37 | 37 | exit; |
| 38 | 38 | } |
| 39 | 39 | |
@@ -56,7 +56,7 @@ discard block |
||
| 56 | 56 | $bandName = $_POST['bandname']; |
| 57 | 57 | $sql = ("INSERT INTO cr_bands (bandLeader) VALUES ('$bandName')"); |
| 58 | 58 | if (!mysqli_query(db(), $sql)) { |
| 59 | - die('Error: '.mysqli_error(db())); |
|
| 59 | + die('Error: ' . mysqli_error(db())); |
|
| 60 | 60 | } |
| 61 | 61 | } else { |
| 62 | 62 | $editbandID = $_GET['band']; |
@@ -64,7 +64,7 @@ discard block |
||
| 64 | 64 | |
| 65 | 65 | $sql = ("INSERT INTO cr_bandMembers (bandID, skillID) VALUES ('$editbandID', '$editskillID')"); |
| 66 | 66 | if (!mysqli_query(db(), $sql)) { |
| 67 | - die('Error: '.mysqli_error(db())); |
|
| 67 | + die('Error: ' . mysqli_error(db())); |
|
| 68 | 68 | } |
| 69 | 69 | } |
| 70 | 70 | // After we have inserted the data, we want to head back to the main page |
@@ -99,8 +99,8 @@ discard block |
||
| 99 | 99 | <div class="elementBackground"> |
| 100 | 100 | <h2><a name="section<?php echo $row['bandID']; ?>"><?php echo $row['bandLeader']; ?></a> <?php if (isAdmin()) { |
| 101 | 101 | echo " |
| 102 | - <a href='editBand.php?id=".$bandid."'><img src='graphics/tool.png' /></a> |
|
| 103 | - <a href='viewBands.php?skillremove=true&bandid=".$bandid."'><img src='graphics/close.png' /></a>"; |
|
| 102 | + <a href='editBand.php?id=".$bandid . "'><img src='graphics/tool.png' /></a> |
|
| 103 | + <a href='viewBands.php?skillremove=true&bandid=".$bandid . "'><img src='graphics/close.png' /></a>"; |
|
| 104 | 104 | } ?></h2> |
| 105 | 105 | |
| 106 | 106 | <?php |
@@ -120,8 +120,8 @@ discard block |
||
| 120 | 120 | while ($rowskills = mysqli_fetch_array($resultskills, MYSQLI_ASSOC)) { |
| 121 | 121 | $bandMembersID = $bandMember['bandMembersID']; |
| 122 | 122 | $sqlusers = ''; |
| 123 | - echo '<strong>'.$rowskills['name'].'</strong> '; |
|
| 124 | - echo '<em> '.$rowskills['skill'].'</em>'." <a href='viewBands.php?skillremove=true&bandMembersID=".$bandMembersID."'><img src='graphics/close.png' /></a><br />"; |
|
| 123 | + echo '<strong>' . $rowskills['name'] . '</strong> '; |
|
| 124 | + echo '<em> ' . $rowskills['skill'] . '</em>' . " <a href='viewBands.php?skillremove=true&bandMembersID=" . $bandMembersID . "'><img src='graphics/close.png' /></a><br />"; |
|
| 125 | 125 | } |
| 126 | 126 | } |
| 127 | 127 | } |
@@ -136,8 +136,8 @@ discard block |
||
| 136 | 136 | <label for="name">Add members:</label> |
| 137 | 137 | <select name="name" id="name"> |
| 138 | 138 | <?php while ($addMember = mysqli_fetch_array($resultaddMembers, MYSQLI_ASSOC)) { |
| 139 | - echo "<option value='".$addMember['skillID']."'>"; |
|
| 140 | - echo $addMember['name'].' - '.$addMember['skill']; |
|
| 139 | + echo "<option value='" . $addMember['skillID'] . "'>"; |
|
| 140 | + echo $addMember['name'] . ' - ' . $addMember['skill']; |
|
| 141 | 141 | echo '</option>'; |
| 142 | 142 | } ?> |
| 143 | 143 | </select> |
@@ -14,7 +14,7 @@ discard block |
||
| 14 | 14 | exit; |
| 15 | 15 | } |
| 16 | 16 | if (!isAdmin()) { |
| 17 | - header('Location: error.php?no=100&page='.basename($_SERVER['SCRIPT_FILENAME'])); |
|
| 17 | + header('Location: error.php?no=100&page=' . basename($_SERVER['SCRIPT_FILENAME'])); |
|
| 18 | 18 | exit; |
| 19 | 19 | } |
| 20 | 20 | |
@@ -26,28 +26,28 @@ discard block |
||
| 26 | 26 | if ($method == 'truncate') { |
| 27 | 27 | $sql = "CREATE TABLE tmp_system_statistics as SELECT * from cr_statistics WHERE type='system'"; |
| 28 | 28 | if (!mysqli_query(db(), $sql)) { |
| 29 | - die('Error: '.mysqli_error(db())); |
|
| 29 | + die('Error: ' . mysqli_error(db())); |
|
| 30 | 30 | } |
| 31 | 31 | |
| 32 | 32 | $sql = ('TRUNCATE TABLE cr_statistics'); |
| 33 | 33 | if (!mysqli_query(db(), $sql)) { |
| 34 | - die('Error: '.mysqli_error(db())); |
|
| 34 | + die('Error: ' . mysqli_error(db())); |
|
| 35 | 35 | } |
| 36 | 36 | |
| 37 | 37 | $sql = ('ALTER TABLE cr_statistics AUTO_INCREMENT = 50'); |
| 38 | 38 | if (!mysqli_query(db(), $sql)) { |
| 39 | - die('Error: '.mysqli_error(db())); |
|
| 39 | + die('Error: ' . mysqli_error(db())); |
|
| 40 | 40 | } |
| 41 | 41 | |
| 42 | 42 | $sql = 'INSERT INTO cr_statistics (userid,date,type,detail1,detail2,detail3,script) '; |
| 43 | - $sql = $sql.'SELECT userid,date,type,detail1,detail2,detail3,script from tmp_system_statistics order by date'; |
|
| 43 | + $sql = $sql . 'SELECT userid,date,type,detail1,detail2,detail3,script from tmp_system_statistics order by date'; |
|
| 44 | 44 | if (!mysqli_query(db(), $sql)) { |
| 45 | - die('Error: '.mysqli_error(db())); |
|
| 45 | + die('Error: ' . mysqli_error(db())); |
|
| 46 | 46 | } |
| 47 | 47 | |
| 48 | 48 | $sql = 'DROP TABLE tmp_system_statistics'; |
| 49 | 49 | if (!mysqli_query(db(), $sql)) { |
| 50 | - die('Error: '.mysqli_error(db())); |
|
| 50 | + die('Error: ' . mysqli_error(db())); |
|
| 51 | 51 | } |
| 52 | 52 | |
| 53 | 53 | insertStatistics('system', __FILE__, 'statistics deleted'); |
@@ -103,22 +103,22 @@ discard block |
||
| 103 | 103 | <?php |
| 104 | 104 | |
| 105 | 105 | $sql = 'SELECT VERSION( ) AS mysqli_version'; |
| 106 | - $result = mysqli_query(db(), $sql) or die('MySQL-Error: '.mysqli_error(db())); |
|
| 106 | + $result = mysqli_query(db(), $sql) or die('MySQL-Error: ' . mysqli_error(db())); |
|
| 107 | 107 | $dbv = mysqli_fetch_array($result, MYSQLI_ASSOC); |
| 108 | 108 | $mysqli_version = $dbv['mysqli_version']; |
| 109 | 109 | |
| 110 | 110 | if (substr($mysqli_version, 0, 1) == 5) { |
| 111 | - $sql = "SELECT getBrowserInfo(detail3) as browser,count(*) as count from cr_statistics where detail1 like 'login%' and detail3!='' group by getBrowserInfo(detail3) order by count desc ".$browserLimit; |
|
| 111 | + $sql = "SELECT getBrowserInfo(detail3) as browser,count(*) as count from cr_statistics where detail1 like 'login%' and detail3!='' group by getBrowserInfo(detail3) order by count desc " . $browserLimit; |
|
| 112 | 112 | } else { |
| 113 | - $sql = "SELECT detail3 as browser,count(*) as count from cr_statistics where detail1 like 'login%' and detail3!='' group by detail3 order by count desc ".$browserLimit; |
|
| 113 | + $sql = "SELECT detail3 as browser,count(*) as count from cr_statistics where detail1 like 'login%' and detail3!='' group by detail3 order by count desc " . $browserLimit; |
|
| 114 | 114 | } |
| 115 | 115 | |
| 116 | 116 | $result = mysqli_query(db(), $sql) or die(mysqli_error(db())); |
| 117 | 117 | while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
| 118 | 118 | extract($row); |
| 119 | 119 | echo '<tr>'; |
| 120 | - echo '<td>'.$browser.'</td>'; |
|
| 121 | - echo '<td>'.$count.'</td>'; |
|
| 120 | + echo '<td>' . $browser . '</td>'; |
|
| 121 | + echo '<td>' . $count . '</td>'; |
|
| 122 | 122 | echo '</tr>'; |
| 123 | 123 | } ?> |
| 124 | 124 | |
@@ -145,16 +145,16 @@ discard block |
||
| 145 | 145 | $sql .= " AND s.type = 'system'"; |
| 146 | 146 | } |
| 147 | 147 | } |
| 148 | - $sql .= ' ORDER BY date desc '.$limit; |
|
| 148 | + $sql .= ' ORDER BY date desc ' . $limit; |
|
| 149 | 149 | $result = mysqli_query(db(), $sql) or die(mysqli_error(db())); |
| 150 | 150 | while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
| 151 | 151 | extract($row); |
| 152 | 152 | echo '<tr>'; |
| 153 | - echo '<td>'.$date.'</td>'; |
|
| 154 | - echo '<td>'.$name.'</td>'; |
|
| 155 | - echo '<td>'.$type.'</td>'; |
|
| 156 | - echo '<td>'.$detail1.'</td>'; |
|
| 157 | - echo '<td>'.$detail2.'</td>'; |
|
| 153 | + echo '<td>' . $date . '</td>'; |
|
| 154 | + echo '<td>' . $name . '</td>'; |
|
| 155 | + echo '<td>' . $type . '</td>'; |
|
| 156 | + echo '<td>' . $detail1 . '</td>'; |
|
| 157 | + echo '<td>' . $detail2 . '</td>'; |
|
| 158 | 158 | //echo "<td>".$detail3."</td>"; |
| 159 | 159 | echo '</tr>'; |
| 160 | 160 | } |
@@ -45,7 +45,7 @@ discard block |
||
| 45 | 45 | if (($userisBandAdmin) || ($userisEventEditor) || (isAdmin())) { |
| 46 | 46 | // Just continue the code |
| 47 | 47 | } else { |
| 48 | - header('Location: error.php?no=100&page='.basename($_SERVER['SCRIPT_FILENAME'])); |
|
| 48 | + header('Location: error.php?no=100&page=' . basename($_SERVER['SCRIPT_FILENAME'])); |
|
| 49 | 49 | } |
| 50 | 50 | |
| 51 | 51 | if ($userisBandAdmin) { |
@@ -82,7 +82,7 @@ discard block |
||
| 82 | 82 | $location = $row['location']; |
| 83 | 83 | $locationname = $row['locationname']; |
| 84 | 84 | if ($action == 'edit') { |
| 85 | - $formaction = '?action=edit&id='.$id; |
|
| 85 | + $formaction = '?action=edit&id=' . $id; |
|
| 86 | 86 | } else { |
| 87 | 87 | $formaction = ''; |
| 88 | 88 | } |
@@ -139,8 +139,8 @@ discard block |
||
| 139 | 139 | |
| 140 | 140 | // convert format of date |
| 141 | 141 | $date = str_replace('/', '-', $date); // ensure it isn't read as mm/dd/yyyy |
| 142 | - $date = strftime('%Y-%m-%d', strtotime($date.' 00:00:00')); |
|
| 143 | - $date = $date.' '.$time.':00'; |
|
| 142 | + $date = strftime('%Y-%m-%d', strtotime($date . ' 00:00:00')); |
|
| 143 | + $date = $date . ' ' . $time . ':00'; |
|
| 144 | 144 | $date = mysqli_real_escape_string(db(), $date); |
| 145 | 145 | |
| 146 | 146 | if ($action == 'edit') { |
@@ -210,10 +210,10 @@ discard block |
||
| 210 | 210 | //if ($userisBandAdmin) $delete_all_sql = $delete_all_sql . " and skillID in (select skillID from cr_skills where groupid=2)"; |
| 211 | 211 | //if ($userisEventEditor) $delete_all_sql = $delete_all_sql . " and skillID in (select skillID from cr_skills where groupid!=2)"; |
| 212 | 212 | if ($userisBandAdmin) { |
| 213 | - $delete_all_sql = $delete_all_sql.' and skillID in (select skillID from cr_skills where groupid in (2,3,4))'; |
|
| 213 | + $delete_all_sql = $delete_all_sql . ' and skillID in (select skillID from cr_skills where groupid in (2,3,4))'; |
|
| 214 | 214 | } |
| 215 | 215 | if ($userisEventEditor) { |
| 216 | - $delete_all_sql = $delete_all_sql.' and skillID in (select skillID from cr_skills where not (groupid in (2,3,4)))'; |
|
| 216 | + $delete_all_sql = $delete_all_sql . ' and skillID in (select skillID from cr_skills where not (groupid in (2,3,4)))'; |
|
| 217 | 217 | } |
| 218 | 218 | mysqli_query(db(), $delete_all_sql) or die(mysqli_error(db())); |
| 219 | 219 | } |
@@ -221,9 +221,9 @@ discard block |
||
| 221 | 221 | // redirect |
| 222 | 222 | if (isset($_SESSION['lastEventsFilter'])) { |
| 223 | 223 | $type = $_SESSION['lastEventsFilter']; |
| 224 | - header('Location: events.php?view=all&filter='.$type.'#event'.$eventID); |
|
| 224 | + header('Location: events.php?view=all&filter=' . $type . '#event' . $eventID); |
|
| 225 | 225 | } else { |
| 226 | - header('Location: events.php?view=all#event'.$eventID); |
|
| 226 | + header('Location: events.php?view=all#event' . $eventID); |
|
| 227 | 227 | } |
| 228 | 228 | exit; |
| 229 | 229 | } |
@@ -300,7 +300,7 @@ discard block |
||
| 300 | 300 | while ($ob = mysqli_fetch_object($result)) { |
| 301 | 301 | if (!(isset($type) && $ob->id == $type)) { |
| 302 | 302 | $defaultTime = strftime('%H:%M', strtotime($ob->defaultTime)); |
| 303 | - echo "<option value='".$ob->id."' title='".$ob->description."' data-time='".($defaultTime == '00:00' ? '' : $defaultTime)."' data-location='".(is_null($ob->defaultLocationId) ? '' : $ob->defaultLocationId)."'>".$ob->name.'</option>'; |
|
| 303 | + echo "<option value='" . $ob->id . "' title='" . $ob->description . "' data-time='" . ($defaultTime == '00:00' ? '' : $defaultTime) . "' data-location='" . (is_null($ob->defaultLocationId) ? '' : $ob->defaultLocationId) . "'>" . $ob->name . '</option>'; |
|
| 304 | 304 | } |
| 305 | 305 | } ?> |
| 306 | 306 | </select> |
@@ -326,7 +326,7 @@ discard block |
||
| 326 | 326 | while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
| 327 | 327 | if (isset($subtype) && $row['id'] == $subtype) { |
| 328 | 328 | } else { |
| 329 | - echo "<option value='".$row['id']."' title='".$row['description']."'>".$row['name'].'</option>'; |
|
| 329 | + echo "<option value='" . $row['id'] . "' title='" . $row['description'] . "'>" . $row['name'] . '</option>'; |
|
| 330 | 330 | } |
| 331 | 331 | } ?> |
| 332 | 332 | </select> |
@@ -354,7 +354,7 @@ discard block |
||
| 354 | 354 | while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
| 355 | 355 | if (isset($location) && $row['id'] == $location) { |
| 356 | 356 | } else { |
| 357 | - echo "<option value='".$row['id']."'>".$row['name'].'</option>'; |
|
| 357 | + echo "<option value='" . $row['id'] . "'>" . $row['name'] . '</option>'; |
|
| 358 | 358 | } |
| 359 | 359 | } ?> |
| 360 | 360 | </select> |
@@ -497,7 +497,7 @@ discard block |
||
| 497 | 497 | while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
| 498 | 498 | if (isset($type) && $row['id'] == $type) { |
| 499 | 499 | } else { |
| 500 | - echo "<option value='".$row['id']."' title='".$row['description']."'>".$row['name'].'</option>'; |
|
| 500 | + echo "<option value='" . $row['id'] . "' title='" . $row['description'] . "'>" . $row['name'] . '</option>'; |
|
| 501 | 501 | } |
| 502 | 502 | } ?> |
| 503 | 503 | </select> |
@@ -566,8 +566,8 @@ discard block |
||
| 566 | 566 | <?php foreach ($role->getUserRoles() as $userRole): ?> |
| 567 | 567 | <?php if (!$userRole->getReserve()): ?> |
| 568 | 568 | <?php $isInEvent = in_array($userRole->getId(), $usersInEvent) ?> |
| 569 | - <option value="<?php echo $userRole->getId() ?>" <?php echo $isInEvent ? 'selected="selected"' : '' ?>><?php echo $userRole->getUser()->getFirstName().' '.$userRole->getUser()->getLastName() ?></option> |
|
| 570 | - <?php else: ?> |
|
| 569 | + <option value="<?php echo $userRole->getId() ?>" <?php echo $isInEvent ? 'selected="selected"' : '' ?>><?php echo $userRole->getUser()->getFirstName() . ' ' . $userRole->getUser()->getLastName() ?></option> |
|
| 570 | + <?php else : ?> |
|
| 571 | 571 | <?php $countReserve += 1 ?> |
| 572 | 572 | <?php endif //!userRole->getReserve?> |
| 573 | 573 | <?php endforeach //users?> |
@@ -577,7 +577,7 @@ discard block |
||
| 577 | 577 | <?php foreach ($role->getUserRoles() as $userRole): ?> |
| 578 | 578 | <?php if ($userRole->getReserve()): ?> |
| 579 | 579 | <?php $isInEvent = in_array($userRole->getId(), $usersInEvent) ?> |
| 580 | - <option value="<?php echo $userRole->getId() ?>" <?php echo $isInEvent ? 'selected="selected"' : '' ?>><?php echo $userRole->getUser()->getFirstName().' '.$userRole->getUser()->getLastName() ?></option> |
|
| 580 | + <option value="<?php echo $userRole->getId() ?>" <?php echo $isInEvent ? 'selected="selected"' : '' ?>><?php echo $userRole->getUser()->getFirstName() . ' ' . $userRole->getUser()->getLastName() ?></option> |
|
| 581 | 581 | <?php endif ?> |
| 582 | 582 | <?php endforeach //users?> |
| 583 | 583 | </optgroup> |