@@ -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> |
@@ -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 | } |
@@ -87,23 +87,23 @@ |
||
| 87 | 87 | WHERE |
| 88 | 88 | date >= CURDATE() |
| 89 | 89 | AND date_format( date , "%y-%m-%d" ) |
| 90 | - <= date_format( DATE_ADD(now(), INTERVAL '.$daysAlert.' DAY ) , "%y-%m-%d" )'; |
|
| 90 | + <= date_format( DATE_ADD(now(), INTERVAL '.$daysAlert . ' DAY ) , "%y-%m-%d" )'; |
|
| 91 | 91 | $resultEvents = mysqli_query(db(), $sqlEvents) or die(mysqli_error(db())); |
| 92 | 92 | $i = 0; |
| 93 | 93 | while ($rowEvents = mysqli_fetch_array($resultEvents, MYSQLI_ASSOC)) { |
| 94 | 94 | $usersNotified = notifyEveryoneForEvent($rowEvents['id']); |
| 95 | 95 | if (count($usersNotified) > 0) { |
| 96 | - $out = $out.'Automatic notifications sent to users ('.implode(', ', $usersNotified).') for event '.$rowEvents['id'].' on '.$rowEvents['date'].".<br>\r\n"; |
|
| 96 | + $out = $out . 'Automatic notifications sent to users (' . implode(', ', $usersNotified) . ') for event ' . $rowEvents['id'] . ' on ' . $rowEvents['date'] . ".<br>\r\n"; |
|
| 97 | 97 | } else { |
| 98 | - $out = $out.'No notifications sent for event '.$rowEvents['id'].' on '.$rowEvents['date'].".<br>\r\n"; |
|
| 98 | + $out = $out . 'No notifications sent for event ' . $rowEvents['id'] . ' on ' . $rowEvents['date'] . ".<br>\r\n"; |
|
| 99 | 99 | } |
| 100 | 100 | $i = $i + 1; |
| 101 | 101 | } |
| 102 | 102 | if ($i == 0) { |
| 103 | - $out = $out.'No events found to automatically notify for.'; |
|
| 103 | + $out = $out . 'No events found to automatically notify for.'; |
|
| 104 | 104 | } |
| 105 | 105 | } else { |
| 106 | - $out = $out.'Automatic notifications are disabled.'; |
|
| 106 | + $out = $out . 'Automatic notifications are disabled.'; |
|
| 107 | 107 | } ?> |
| 108 | 108 | <html> |
| 109 | 109 | <body> |
@@ -34,7 +34,7 @@ |
||
| 34 | 34 | } |
| 35 | 35 | |
| 36 | 36 | if (!isAdmin()) { |
| 37 | - header('Location: error.php?no=100&page='.basename($_SERVER['SCRIPT_FILENAME'])); |
|
| 37 | + header('Location: error.php?no=100&page=' . basename($_SERVER['SCRIPT_FILENAME'])); |
|
| 38 | 38 | exit; |
| 39 | 39 | } |
| 40 | 40 | |
@@ -11,7 +11,7 @@ discard block |
||
| 11 | 11 | if (isset($_SESSION['is_logged_in']) || $_SESSION['db_is_logged_in'] == true) { |
| 12 | 12 | // Just continue the code |
| 13 | 13 | } else { |
| 14 | - $_SESSION['redirectUrl'] = siteSettings()->getSiteUrl().'/event.php?id='.$eventId; |
|
| 14 | + $_SESSION['redirectUrl'] = siteSettings()->getSiteUrl() . '/event.php?id=' . $eventId; |
|
| 15 | 15 | header('Location: login.php'); |
| 16 | 16 | exit; |
| 17 | 17 | } |
@@ -60,7 +60,7 @@ discard block |
||
| 60 | 60 | <h2 class="box-title">Event Details</h2> |
| 61 | 61 | </div> |
| 62 | 62 | <div class="box-body"> |
| 63 | - <?php echo !empty($event->getName()) ? '<p><strong>Name:</strong> '.$event->getName().'</p>' : '' ?> |
|
| 63 | + <?php echo !empty($event->getName()) ? '<p><strong>Name:</strong> ' . $event->getName() . '</p>' : '' ?> |
|
| 64 | 64 | <p><strong>Date:</strong> <?php echo $event->getDate('d/m/y'); ?></p> |
| 65 | 65 | <p><strong>Location:</strong> <?php echo $event->getLocation()->getName() ?></p> |
| 66 | 66 | <p><strong>Type:</strong> <?php echo $event->getEventType()->getName() ?></p> |
@@ -160,16 +160,16 @@ discard block |
||
| 160 | 160 | } else { |
| 161 | 161 | echo '</ul>'; |
| 162 | 162 | } |
| 163 | - echo '<p><strong>'.$groupName.'</strong></p>'; |
|
| 163 | + echo '<p><strong>' . $groupName . '</strong></p>'; |
|
| 164 | 164 | echo '<ul>'; |
| 165 | 165 | } |
| 166 | 166 | |
| 167 | 167 | echo '<li>'; |
| 168 | - echo (isset($viewPeople->swap)) ? "<s><a class='text-danger' href='swap.php?swap=".$viewPeople->swap."'>" : ''; |
|
| 168 | + echo (isset($viewPeople->swap)) ? "<s><a class='text-danger' href='swap.php?swap=" . $viewPeople->swap . "'>" : ''; |
|
| 169 | 169 | echo $viewPeople->name; |
| 170 | 170 | |
| 171 | 171 | if ($viewPeople->rolename != '') { |
| 172 | - echo ' - <em>'.$viewPeople->rolename.'</em>'; |
|
| 172 | + echo ' - <em>' . $viewPeople->rolename . '</em>'; |
|
| 173 | 173 | } else { |
| 174 | 174 | // If there is no skill, we don't need to mention this. |
| 175 | 175 | } |
@@ -14,7 +14,7 @@ |
||
| 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 | |
@@ -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 | |
@@ -40,7 +40,7 @@ discard block |
||
| 40 | 40 | $sql = "UPDATE cr_eventGroups SET name = '$name', description = '$description' WHERE id = '$editid'"; |
| 41 | 41 | } |
| 42 | 42 | if (!mysqli_query(db(), $sql)) { |
| 43 | - die('Error: '.mysqli_error(db())); |
|
| 43 | + die('Error: ' . mysqli_error(db())); |
|
| 44 | 44 | } |
| 45 | 45 | } else { |
| 46 | 46 | $name = $_POST['seriesName']; |
@@ -54,7 +54,7 @@ discard block |
||
| 54 | 54 | } else { |
| 55 | 55 | $sql = ("INSERT INTO cr_eventGroups (name, description) VALUES ('$name', '$description')"); |
| 56 | 56 | if (!mysqli_query(db(), $sql)) { |
| 57 | - die('Error: '.mysqli_error(db())); |
|
| 57 | + die('Error: ' . mysqli_error(db())); |
|
| 58 | 58 | } |
| 59 | 59 | |
| 60 | 60 | // After we have inserted the data, we want to head back to the main users page |
@@ -97,9 +97,9 @@ discard block |
||
| 97 | 97 | |
| 98 | 98 | while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
| 99 | 99 | $seriesId = $row['id']; |
| 100 | - echo "<span id='".$seriesId."' class='edit'><strong>".$row['name'].'</strong></span>'; |
|
| 101 | - echo " <a href='series.php?method=remove&series=".$seriesId."'><i class='fa fa-close'></i></a><br />"; |
|
| 102 | - echo "<p id='".$seriesId."' class='edit'>".$row['description'].'</p>'; |
|
| 100 | + echo "<span id='" . $seriesId . "' class='edit'><strong>" . $row['name'] . '</strong></span>'; |
|
| 101 | + echo " <a href='series.php?method=remove&series=" . $seriesId . "'><i class='fa fa-close'></i></a><br />"; |
|
| 102 | + echo "<p id='" . $seriesId . "' class='edit'>" . $row['description'] . '</p>'; |
|
| 103 | 103 | echo '<hr />'; |
| 104 | 104 | } ?> |
| 105 | 105 | </div><!-- /.box-body --> |
@@ -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 | |
@@ -31,14 +31,14 @@ discard block |
||
| 31 | 31 | case 'approve': |
| 32 | 32 | $userId = approvePendingUser($id); |
| 33 | 33 | mailNewUser($userId); |
| 34 | - header('Location: addUser.php?action=edit&user='.$userId); |
|
| 34 | + header('Location: addUser.php?action=edit&user=' . $userId); |
|
| 35 | 35 | break; |
| 36 | 36 | case 'merge': |
| 37 | 37 | $existingUserId = $_POST['existingUser']; |
| 38 | 38 | $existingUserId = filter_var($existingUserId, FILTER_SANITIZE_NUMBER_INT); |
| 39 | 39 | mergePendingUserWithUserId($id, $existingUserId); |
| 40 | 40 | mailNewUser($existingUserId); |
| 41 | - header('Location: addUser.php?action=edit&user='.$existingUserId); |
|
| 41 | + header('Location: addUser.php?action=edit&user=' . $existingUserId); |
|
| 42 | 42 | break; |
| 43 | 43 | case 'decline': |
| 44 | 44 | declinePendingUser($id); |
@@ -90,7 +90,7 @@ discard block |
||
| 90 | 90 | <div class="box box-primary"> |
| 91 | 91 | <div class="box-header"> |
| 92 | 92 | <h2 class="box-title"> |
| 93 | - <?php echo $user->approved ? 'Approved' : ($user->declined ? 'Declined' : 'Pending') ?>: <?php echo $user->firstName.' '.$user->lastName ?> |
|
| 93 | + <?php echo $user->approved ? 'Approved' : ($user->declined ? 'Declined' : 'Pending') ?>: <?php echo $user->firstName . ' ' . $user->lastName ?> |
|
| 94 | 94 | </h2> |
| 95 | 95 | </div> |
| 96 | 96 | <div class="box-body"> |
@@ -131,7 +131,7 @@ discard block |
||
| 131 | 131 | <?php |
| 132 | 132 | $users = allUsersNames(); |
| 133 | 133 | foreach ($users as $existingUser): ?> |
| 134 | - <option value="<?php echo $existingUser->id?>" <?php echo($existingUser->firstName == $user->firstName) && ($existingUser->lastName == $user->lastName) ? "selected='selected'" : '' ?>><?php echo $existingUser->firstName.' '.$existingUser->lastName ?></option> |
|
| 134 | + <option value="<?php echo $existingUser->id?>" <?php echo($existingUser->firstName == $user->firstName) && ($existingUser->lastName == $user->lastName) ? "selected='selected'" : '' ?>><?php echo $existingUser->firstName . ' ' . $existingUser->lastName ?></option> |
|
| 135 | 135 | <?php endforeach; ?> |
| 136 | 136 | </select> |
| 137 | 137 | </div> |