@@ -49,7 +49,7 @@ discard block |
||
| 49 | 49 | $swapId = filter_var($swapId, FILTER_SANITIZE_NUMBER_INT); |
| 50 | 50 | |
| 51 | 51 | switch ($action) { |
| 52 | - case 'swap': |
|
| 52 | + case 'swap': |
|
| 53 | 53 | if ($_SERVER['REQUEST_METHOD'] == 'POST') { |
| 54 | 54 | $eventPersonId = $_POST['eventPerson']; |
| 55 | 55 | $newUserRoleId = $_POST['newUserRole']; |
@@ -63,48 +63,48 @@ discard block |
||
| 63 | 63 | $err = 'Swap details incorrect, please try again.'; |
| 64 | 64 | } |
| 65 | 65 | break; |
| 66 | - case 'accept': |
|
| 66 | + case 'accept': |
|
| 67 | 67 | if (canAcceptSwap($swapId) || $verify == verificationCodeForSwap($swapId)) { |
| 68 | 68 | switch (acceptSwap($swapId)) { |
| 69 | 69 | case '1': |
| 70 | 70 | $message = 'Swap Successful'; |
| 71 | - break; |
|
| 71 | + break; |
|
| 72 | 72 | case '2': |
| 73 | 73 | $message = 'Swap already accepted.'; |
| 74 | - break; |
|
| 74 | + break; |
|
| 75 | 75 | case '3': |
| 76 | 76 | $message = 'Swap already declined.'; |
| 77 | - break; |
|
| 77 | + break; |
|
| 78 | 78 | case '4': |
| 79 | 79 | $message = 'Swap already reverted.'; |
| 80 | - break; |
|
| 80 | + break; |
|
| 81 | 81 | default: |
| 82 | 82 | $err = 'Technical issue - please inform system administrator'; |
| 83 | - break; |
|
| 84 | - } |
|
| 83 | + break; |
|
| 84 | + } |
|
| 85 | 85 | } else { |
| 86 | 86 | $err = 'Swap Already Actioned or Verification Code Invalid'; |
| 87 | 87 | } |
| 88 | 88 | break; |
| 89 | - case 'decline': |
|
| 89 | + case 'decline': |
|
| 90 | 90 | if (canDeclineSwap($swapId) || $verify == verificationCodeForSwap($swapId)) { |
| 91 | 91 | switch (declineSwap($swapId)) { |
| 92 | 92 | case '1': |
| 93 | 93 | $message = 'Swap declined'; |
| 94 | - break; |
|
| 94 | + break; |
|
| 95 | 95 | case '2': |
| 96 | 96 | $message = 'Swap already declined.'; |
| 97 | - break; |
|
| 97 | + break; |
|
| 98 | 98 | default: |
| 99 | 99 | $err = 'Technical issue - please inform system administrator'; |
| 100 | - break; |
|
| 100 | + break; |
|
| 101 | 101 | } |
| 102 | 102 | } else { |
| 103 | 103 | $err = 'Swap Already Actioned or Verification Code Invalid'; |
| 104 | 104 | } |
| 105 | 105 | break; |
| 106 | 106 | |
| 107 | - default: |
|
| 107 | + default: |
|
| 108 | 108 | // code... |
| 109 | 109 | break; |
| 110 | 110 | } |
@@ -165,7 +165,7 @@ discard block |
||
| 165 | 165 | <section class="content"> |
| 166 | 166 | |
| 167 | 167 | <?php |
| 168 | - if (isset($message)) { ?> |
|
| 168 | + if (isset($message)) { ?> |
|
| 169 | 169 | |
| 170 | 170 | <p><?php echo $message ?></p> |
| 171 | 171 | |
@@ -226,19 +226,19 @@ discard block |
||
| 226 | 226 | <label for="newUserRole">Swap To:</label> |
| 227 | 227 | <select name="newUserRole" class="form-control"> |
| 228 | 228 | <?php |
| 229 | - if (roleCanSwapToOtherRoleInGroup($role->roleId)) { |
|
| 230 | - $whereAnd = 'r.groupId = '.groupIdWithRole($role->roleId).' AND r.allowRoleSwaps IS NOT FALSE'; |
|
| 231 | - } else { |
|
| 232 | - $whereAnd = 'r.id = '.$role->roleId; |
|
| 233 | - } |
|
| 234 | - $sql = 'SELECT ur.id, u.firstName, u.lastName, r.name FROM users u INNER JOIN userRoles ur ON ur.userId = u.id INNER JOIN roles r ON r.id = ur.roleId WHERE u.id <> '.$role->userId.' AND '.$whereAnd.' ORDER BY lastName, firstName, r.name'; |
|
| 235 | - $result = mysqli_query(db(), $sql) or exit(mysqli_error(db())); |
|
| 236 | - |
|
| 237 | - while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
|
| 238 | - ?> |
|
| 229 | + if (roleCanSwapToOtherRoleInGroup($role->roleId)) { |
|
| 230 | + $whereAnd = 'r.groupId = '.groupIdWithRole($role->roleId).' AND r.allowRoleSwaps IS NOT FALSE'; |
|
| 231 | + } else { |
|
| 232 | + $whereAnd = 'r.id = '.$role->roleId; |
|
| 233 | + } |
|
| 234 | + $sql = 'SELECT ur.id, u.firstName, u.lastName, r.name FROM users u INNER JOIN userRoles ur ON ur.userId = u.id INNER JOIN roles r ON r.id = ur.roleId WHERE u.id <> '.$role->userId.' AND '.$whereAnd.' ORDER BY lastName, firstName, r.name'; |
|
| 235 | + $result = mysqli_query(db(), $sql) or exit(mysqli_error(db())); |
|
| 236 | + |
|
| 237 | + while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |
|
| 238 | + ?> |
|
| 239 | 239 | <option value='<?php echo $row['id']; ?>'><?php echo $row['firstName'].' '.$row['lastName'].' ('.$row['name'].')'; ?></option> |
| 240 | 240 | <?php |
| 241 | - } ?> |
|
| 241 | + } ?> |
|
| 242 | 242 | </select> |
| 243 | 243 | </div> |
| 244 | 244 | </div> |
@@ -179,10 +179,10 @@ discard block |
||
| 179 | 179 | <div class="col-sm-8 col-md-8 col-lg-6"> |
| 180 | 180 | |
| 181 | 181 | <?php |
| 182 | - // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
|
| 183 | - // ~~~~~~~~ Events this week ~~~~~~~~ |
|
| 184 | - // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
|
| 185 | - ?> |
|
| 182 | + // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
|
| 183 | + // ~~~~~~~~ Events this week ~~~~~~~~ |
|
| 184 | + // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
|
| 185 | + ?> |
|
| 186 | 186 | |
| 187 | 187 | <h2>Events this week:</h2> |
| 188 | 188 | |
@@ -206,17 +206,17 @@ discard block |
||
| 206 | 206 | <div class="timeline-header"> |
| 207 | 207 | <a href="event.php?id=<?php echo $event->getId() ?>"> |
| 208 | 208 | <h4><?php |
| 209 | - echo $event->getDate('jS: '); |
|
| 210 | - $eventPeople = EventPersonQuery::create()->filterByEvent($event)->find(); |
|
| 211 | - $roles = []; |
|
| 212 | - foreach ($eventPeople as $eventPerson) { |
|
| 213 | - if ($eventPerson->getUserRole()->getUserId() == $user->getId()) { |
|
| 214 | - $roles[] = $eventPerson->getUserRole()->getRole()->getName(); |
|
| 215 | - } |
|
| 216 | - } |
|
| 217 | - $roles = implode(', ', $roles); |
|
| 218 | - echo $roles != '' ? $roles : 'No involvement'; |
|
| 219 | - ?> |
|
| 209 | + echo $event->getDate('jS: '); |
|
| 210 | + $eventPeople = EventPersonQuery::create()->filterByEvent($event)->find(); |
|
| 211 | + $roles = []; |
|
| 212 | + foreach ($eventPeople as $eventPerson) { |
|
| 213 | + if ($eventPerson->getUserRole()->getUserId() == $user->getId()) { |
|
| 214 | + $roles[] = $eventPerson->getUserRole()->getRole()->getName(); |
|
| 215 | + } |
|
| 216 | + } |
|
| 217 | + $roles = implode(', ', $roles); |
|
| 218 | + echo $roles != '' ? $roles : 'No involvement'; |
|
| 219 | + ?> |
|
| 220 | 220 | </h4> |
| 221 | 221 | </a> |
| 222 | 222 | <a class="label label-default" href="events.php?view=all&filter=<?php echo $event->getEventTypeId() ?>"><?php echo $event->getEventType()->getName() ?></a> |
@@ -271,7 +271,7 @@ discard block |
||
| 271 | 271 | <div class="modal-body"> |
| 272 | 272 | <?php |
| 273 | 273 | |
| 274 | - $sqlPeople = "SELECT |
|
| 274 | + $sqlPeople = "SELECT |
|
| 275 | 275 | CONCAT(u.firstname, ' ', u.lastname) AS `name`, |
| 276 | 276 | r.name AS `rolename`, |
| 277 | 277 | ep.notified AS `notified`, |
@@ -287,47 +287,47 @@ discard block |
||
| 287 | 287 | AND ep.removed = 0 |
| 288 | 288 | ORDER BY g.name, r.name"; |
| 289 | 289 | |
| 290 | - $resultPeople = mysqli_query(db(), $sqlPeople) or exit(mysqli_error(db())); |
|
| 291 | - $groupName = ''; |
|
| 292 | - $groupId = 0; |
|
| 293 | - $identifier = '1'; |
|
| 294 | - $firstTime = true; |
|
| 290 | + $resultPeople = mysqli_query(db(), $sqlPeople) or exit(mysqli_error(db())); |
|
| 291 | + $groupName = ''; |
|
| 292 | + $groupId = 0; |
|
| 293 | + $identifier = '1'; |
|
| 294 | + $firstTime = true; |
|
| 295 | 295 | |
| 296 | - if (mysqli_num_rows($resultPeople) > 0) { |
|
| 297 | - ?> |
|
| 296 | + if (mysqli_num_rows($resultPeople) > 0) { |
|
| 297 | + ?> |
|
| 298 | 298 | <?php while ($viewPeople = mysqli_fetch_object($resultPeople)) { |
| 299 | - if ($viewPeople->group == $groupId) { |
|
| 300 | - // Do nothing, because they are all in the same group |
|
| 301 | - } else { |
|
| 302 | - // Update the group heading |
|
| 303 | - $groupId = $viewPeople->group; |
|
| 304 | - $groupName = $viewPeople->groupName; |
|
| 305 | - if ($firstTime) { |
|
| 306 | - $firstTime = false; |
|
| 307 | - } else { |
|
| 308 | - echo '</ul>'; |
|
| 309 | - } |
|
| 310 | - echo '<p><strong>'.$groupName.'</strong></p>'; |
|
| 311 | - echo '<ul>'; |
|
| 312 | - } |
|
| 313 | - |
|
| 314 | - echo '<li>'; |
|
| 315 | - echo (isset($viewPeople->swap)) ? "<s><a class='text-danger' href='swap.php?swap=".$viewPeople->swap."'>" : ''; |
|
| 316 | - echo $viewPeople->name; |
|
| 317 | - |
|
| 318 | - if ($viewPeople->rolename != '') { |
|
| 319 | - echo ' - <em>'.$viewPeople->rolename.'</em>'; |
|
| 320 | - } else { |
|
| 321 | - // If there is no skill, we don't need to mention this. |
|
| 322 | - } |
|
| 323 | - echo (isset($viewPeople->swap)) ? '</a></s>' : ''; |
|
| 324 | - |
|
| 325 | - echo '</li>'; |
|
| 326 | - } |
|
| 327 | - echo '</ul>'; |
|
| 328 | - } else { |
|
| 329 | - echo '<p>No roles assigned to this event.'; |
|
| 330 | - } |
|
| 299 | + if ($viewPeople->group == $groupId) { |
|
| 300 | + // Do nothing, because they are all in the same group |
|
| 301 | + } else { |
|
| 302 | + // Update the group heading |
|
| 303 | + $groupId = $viewPeople->group; |
|
| 304 | + $groupName = $viewPeople->groupName; |
|
| 305 | + if ($firstTime) { |
|
| 306 | + $firstTime = false; |
|
| 307 | + } else { |
|
| 308 | + echo '</ul>'; |
|
| 309 | + } |
|
| 310 | + echo '<p><strong>'.$groupName.'</strong></p>'; |
|
| 311 | + echo '<ul>'; |
|
| 312 | + } |
|
| 313 | + |
|
| 314 | + echo '<li>'; |
|
| 315 | + echo (isset($viewPeople->swap)) ? "<s><a class='text-danger' href='swap.php?swap=".$viewPeople->swap."'>" : ''; |
|
| 316 | + echo $viewPeople->name; |
|
| 317 | + |
|
| 318 | + if ($viewPeople->rolename != '') { |
|
| 319 | + echo ' - <em>'.$viewPeople->rolename.'</em>'; |
|
| 320 | + } else { |
|
| 321 | + // If there is no skill, we don't need to mention this. |
|
| 322 | + } |
|
| 323 | + echo (isset($viewPeople->swap)) ? '</a></s>' : ''; |
|
| 324 | + |
|
| 325 | + echo '</li>'; |
|
| 326 | + } |
|
| 327 | + echo '</ul>'; |
|
| 328 | + } else { |
|
| 329 | + echo '<p>No roles assigned to this event.'; |
|
| 330 | + } |
|
| 331 | 331 | ?> |
| 332 | 332 | </div> |
| 333 | 333 | <div class="modal-footer"> |
@@ -361,10 +361,10 @@ discard block |
||
| 361 | 361 | |
| 362 | 362 | |
| 363 | 363 | <?php |
| 364 | - // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
|
| 365 | - // ~~~~~~~~~ User's events ~~~~~~~~~~ |
|
| 366 | - // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
|
| 367 | - ?> |
|
| 364 | + // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
|
| 365 | + // ~~~~~~~~~ User's events ~~~~~~~~~~ |
|
| 366 | + // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
|
| 367 | + ?> |
|
| 368 | 368 | |
| 369 | 369 | <h2>My events:</h2> |
| 370 | 370 | |
@@ -389,9 +389,9 @@ discard block |
||
| 389 | 389 | <div class="timeline-header"> |
| 390 | 390 | <a href="event.php?id=<?php echo $event->id ?>"> |
| 391 | 391 | <h4><?php |
| 392 | - echo date('jS: ', strtotime($event->date)); |
|
| 393 | - echo $event->roles; |
|
| 394 | - ?> |
|
| 392 | + echo date('jS: ', strtotime($event->date)); |
|
| 393 | + echo $event->roles; |
|
| 394 | + ?> |
|
| 395 | 395 | </h4> |
| 396 | 396 | </a> |
| 397 | 397 | <a class="label label-default" href="events.php?view=all&filter=<?php echo $event->eventTypeId ?>"><?php echo $event->eventType ?></a> |
@@ -447,7 +447,7 @@ discard block |
||
| 447 | 447 | <div class="modal-body"> |
| 448 | 448 | <?php |
| 449 | 449 | |
| 450 | - $sqlPeople = "SELECT |
|
| 450 | + $sqlPeople = "SELECT |
|
| 451 | 451 | CONCAT(u.firstname, ' ', u.lastname) AS `name`, |
| 452 | 452 | r.name AS `rolename`, |
| 453 | 453 | ep.notified AS `notified`, |
@@ -463,47 +463,47 @@ discard block |
||
| 463 | 463 | AND ep.removed = 0 |
| 464 | 464 | ORDER BY g.name, r.name"; |
| 465 | 465 | |
| 466 | - $resultPeople = mysqli_query(db(), $sqlPeople) or exit(mysqli_error(db())); |
|
| 467 | - $groupName = ''; |
|
| 468 | - $groupId = 0; |
|
| 469 | - $identifier = '1'; |
|
| 470 | - $firstTime = true; |
|
| 466 | + $resultPeople = mysqli_query(db(), $sqlPeople) or exit(mysqli_error(db())); |
|
| 467 | + $groupName = ''; |
|
| 468 | + $groupId = 0; |
|
| 469 | + $identifier = '1'; |
|
| 470 | + $firstTime = true; |
|
| 471 | 471 | |
| 472 | - if (mysqli_num_rows($resultPeople) > 0) { |
|
| 473 | - ?> |
|
| 472 | + if (mysqli_num_rows($resultPeople) > 0) { |
|
| 473 | + ?> |
|
| 474 | 474 | <?php while ($viewPeople = mysqli_fetch_object($resultPeople)) { |
| 475 | - if ($viewPeople->group == $groupId) { |
|
| 476 | - // Do nothing, because they are all in the same group |
|
| 477 | - } else { |
|
| 478 | - // Update the group heading |
|
| 479 | - $groupId = $viewPeople->group; |
|
| 480 | - $groupName = $viewPeople->groupName; |
|
| 481 | - if ($firstTime) { |
|
| 482 | - $firstTime = false; |
|
| 483 | - } else { |
|
| 484 | - echo '</ul>'; |
|
| 485 | - } |
|
| 486 | - echo '<p><strong>'.$groupName.'</strong></p>'; |
|
| 487 | - echo '<ul>'; |
|
| 488 | - } |
|
| 489 | - |
|
| 490 | - echo '<li>'; |
|
| 491 | - echo (isset($viewPeople->swap)) ? "<s><a class='text-danger' href='swap.php?swap=".$viewPeople->swap."'>" : ''; |
|
| 492 | - echo $viewPeople->name; |
|
| 493 | - |
|
| 494 | - if ($viewPeople->rolename != '') { |
|
| 495 | - echo ' - <em>'.$viewPeople->rolename.'</em>'; |
|
| 496 | - } else { |
|
| 497 | - // If there is no skill, we don't need to mention this. |
|
| 498 | - } |
|
| 499 | - echo (isset($viewPeople->swap)) ? '</a></s>' : ''; |
|
| 500 | - |
|
| 501 | - echo '</li>'; |
|
| 502 | - } |
|
| 503 | - echo '</ul>'; |
|
| 504 | - } else { |
|
| 505 | - echo '<p>No roles assigned to this event.'; |
|
| 506 | - } |
|
| 475 | + if ($viewPeople->group == $groupId) { |
|
| 476 | + // Do nothing, because they are all in the same group |
|
| 477 | + } else { |
|
| 478 | + // Update the group heading |
|
| 479 | + $groupId = $viewPeople->group; |
|
| 480 | + $groupName = $viewPeople->groupName; |
|
| 481 | + if ($firstTime) { |
|
| 482 | + $firstTime = false; |
|
| 483 | + } else { |
|
| 484 | + echo '</ul>'; |
|
| 485 | + } |
|
| 486 | + echo '<p><strong>'.$groupName.'</strong></p>'; |
|
| 487 | + echo '<ul>'; |
|
| 488 | + } |
|
| 489 | + |
|
| 490 | + echo '<li>'; |
|
| 491 | + echo (isset($viewPeople->swap)) ? "<s><a class='text-danger' href='swap.php?swap=".$viewPeople->swap."'>" : ''; |
|
| 492 | + echo $viewPeople->name; |
|
| 493 | + |
|
| 494 | + if ($viewPeople->rolename != '') { |
|
| 495 | + echo ' - <em>'.$viewPeople->rolename.'</em>'; |
|
| 496 | + } else { |
|
| 497 | + // If there is no skill, we don't need to mention this. |
|
| 498 | + } |
|
| 499 | + echo (isset($viewPeople->swap)) ? '</a></s>' : ''; |
|
| 500 | + |
|
| 501 | + echo '</li>'; |
|
| 502 | + } |
|
| 503 | + echo '</ul>'; |
|
| 504 | + } else { |
|
| 505 | + echo '<p>No roles assigned to this event.'; |
|
| 506 | + } |
|
| 507 | 507 | ?> |
| 508 | 508 | </div> |
| 509 | 509 | <div class="modal-footer"> |
@@ -538,10 +538,10 @@ discard block |
||
| 538 | 538 | <div class="col-sm-4 col-md-4 col-lg-6"> |
| 539 | 539 | |
| 540 | 540 | <?php |
| 541 | - // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
|
| 542 | - // ~~~~~~~ Remaining events ~~~~~~~~~ |
|
| 543 | - // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
|
| 544 | - ?> |
|
| 541 | + // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
|
| 542 | + // ~~~~~~~ Remaining events ~~~~~~~~~ |
|
| 543 | + // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
|
| 544 | + ?> |
|
| 545 | 545 | <?php if (isset($remainingEventsInGroups)) { ?> |
| 546 | 546 | |
| 547 | 547 | <div class="row"> |
@@ -617,10 +617,10 @@ discard block |
||
| 617 | 617 | |
| 618 | 618 | |
| 619 | 619 | <?php |
| 620 | - // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
|
| 621 | - // ~~~~~~~~~ User details ~~~~~~~~~~~ |
|
| 622 | - // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
|
| 623 | - ?> |
|
| 620 | + // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
|
| 621 | + // ~~~~~~~~~ User details ~~~~~~~~~~~ |
|
| 622 | + // ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
|
| 623 | + ?> |
|
| 624 | 624 | |
| 625 | 625 | <div class="box box-widget widget-user-2"> |
| 626 | 626 | <div class="widget-user-header bg-yellow"> |
@@ -342,17 +342,17 @@ |
||
| 342 | 342 | <label for="skin">Application skin:</label> |
| 343 | 343 | <select name="skin" id="skin" class="form-control"> |
| 344 | 344 | <?php $skinOptions = ['skin-blue-light' => 'Blue & Light', |
| 345 | - 'skin-blue' => 'Blue & Dark', |
|
| 346 | - 'skin-yellow-light' => 'Yellow & Light', |
|
| 347 | - 'skin-yellow' => 'Yellow & Dark', |
|
| 348 | - 'skin-green-light' => 'Green & Light', |
|
| 349 | - 'skin-green' => 'Green & Dark', |
|
| 350 | - 'skin-purple-light' => 'Purple & Light', |
|
| 351 | - 'skin-purple' => 'Purple & Dark', |
|
| 352 | - 'skin-red-light' => 'Red & Light', |
|
| 353 | - 'skin-red' => 'Red & Dark', |
|
| 354 | - 'skin-black-light' => 'Black & Light', |
|
| 355 | - 'skin-black' => 'Black & Dark', ]; |
|
| 345 | + 'skin-blue' => 'Blue & Dark', |
|
| 346 | + 'skin-yellow-light' => 'Yellow & Light', |
|
| 347 | + 'skin-yellow' => 'Yellow & Dark', |
|
| 348 | + 'skin-green-light' => 'Green & Light', |
|
| 349 | + 'skin-green' => 'Green & Dark', |
|
| 350 | + 'skin-purple-light' => 'Purple & Light', |
|
| 351 | + 'skin-purple' => 'Purple & Dark', |
|
| 352 | + 'skin-red-light' => 'Red & Light', |
|
| 353 | + 'skin-red' => 'Red & Dark', |
|
| 354 | + 'skin-black-light' => 'Black & Light', |
|
| 355 | + 'skin-black' => 'Black & Dark', ]; |
|
| 356 | 356 | |
| 357 | 357 | foreach ($skinOptions as $skinName => $skinDescription) { ?> |
| 358 | 358 | <option value="<?php echo $skinName ?>" <?php echo ($skinName == $row['skin']) ? 'selected' : '' ?>><?php echo $skinDescription ?></option> |
@@ -66,10 +66,10 @@ |
||
| 66 | 66 | $tokenMetadata = $oAuth2Client->debugToken($accessToken); |
| 67 | 67 | |
| 68 | 68 | // Validation (these will throw FacebookSDKException's when they fail) |
| 69 | - $tokenMetadata->validateAppId($config['auth']['facebook']['appId']); // Replace {app-id} with your app id |
|
| 70 | - // If you know the user ID this access token belongs to, you can validate it here |
|
| 71 | - //$tokenMetadata->validateUserId('123'); |
|
| 72 | - $tokenMetadata->validateExpiration(); |
|
| 69 | + $tokenMetadata->validateAppId($config['auth']['facebook']['appId']); // Replace {app-id} with your app id |
|
| 70 | + // If you know the user ID this access token belongs to, you can validate it here |
|
| 71 | + //$tokenMetadata->validateUserId('123'); |
|
| 72 | + $tokenMetadata->validateExpiration(); |
|
| 73 | 73 | |
| 74 | 74 | if (!$accessToken->isLongLived()) { |
| 75 | 75 | // Exchanges a short-lived access token for a long-lived one |
@@ -141,12 +141,12 @@ |
||
| 141 | 141 | <tbody> |
| 142 | 142 | <?php |
| 143 | 143 | $sql = "SELECT s.date,s.detail1,s.detail2,s.detail3,s.type,trim(concat(u.firstName,' ',u.lastName)) AS name FROM statistics s INNER JOIN users u ON u.id = s.userid"; |
| 144 | - if (!isAdmin()) { |
|
| 145 | - $sql .= 'WHERE u.ID=s.userID'; |
|
| 146 | - if (!$debug) { |
|
| 147 | - $sql .= " AND s.type = 'system'"; |
|
| 148 | - } |
|
| 149 | - } |
|
| 144 | + if (!isAdmin()) { |
|
| 145 | + $sql .= 'WHERE u.ID=s.userID'; |
|
| 146 | + if (!$debug) { |
|
| 147 | + $sql .= " AND s.type = 'system'"; |
|
| 148 | + } |
|
| 149 | + } |
|
| 150 | 150 | $sql .= ' ORDER BY date desc '.$limit; |
| 151 | 151 | $result = mysqli_query(db(), $sql) or exit(mysqli_error(db())); |
| 152 | 152 | while ($row = mysqli_fetch_array($result, MYSQLI_ASSOC)) { |