@@ -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)) { |