@@ 363-367 (lines=5) @@ | ||
360 | if ($isModAdmin) { |
|
361 | $query = "SELECT $result_db.id, $result_db.quiz_id, $result_db.uid, $result_db.score, $result_db.timestamp, $result_db.comment, $users_db.uname, $users_db.name FROM $result_db, $users_db WHERE $result_db.uid = $users_db.uid AND $result_db.quiz_id = $artid ORDER BY " |
|
362 | . $sort_key; |
|
363 | } elseif ($xoopsUser) { |
|
364 | $uid = $xoopsUser->getVar('uid'); |
|
365 | $query = "SELECT $result_db.id, $result_db.quiz_id, $result_db.uid, $result_db.score, $result_db.timestamp, $result_db.comment, $users_db.uname, $users_db.name FROM $result_db, $users_db WHERE $result_db.uid = $uid AND $result_db.uid = $users_db.uid AND $result_db.quiz_id = $artid ORDER BY " |
|
366 | . $sort_key; |
|
367 | } |
|
368 | $result = $xoopsDB->query($query); |
|
369 | ||
370 | echo "<div style='text-align: center;'>"; |
|
@@ 441-444 (lines=4) @@ | ||
438 | if ($isModAdmin) { |
|
439 | $query = "SELECT $result_db.id, $result_db.quiz_id, $result_db.uid, $result_db.score, $result_db.start_time, $result_db.end_time, $result_db.timestamp, $result_db.host, $result_db.ip, $result_db.comment, $users_db.uname, $users_db.name FROM $result_db, $users_db WHERE $result_db.uid = $users_db.uid AND $result_db.quiz_id = $artid ORDER BY " |
|
440 | . $sort_key; |
|
441 | } elseif ($xoopsUser) { |
|
442 | $query = "SELECT $result_db.id, $result_db.quiz_id, $result_db.uid, $result_db.score, $result_db.start_time, $result_db.end_time, $result_db.timestamp, $result_db.host, $result_db.ip, $result_db.comment, $users_db.uname, $users_db.name FROM $result_db, $users_db WHERE $result_db.uid = $uid AND $result_db.uid = $users_db.uid AND $result_db.quiz_id = $artid ORDER BY " |
|
443 | . $sort_key; |
|
444 | } |
|
445 | $result = $xoopsDB->query($query); |
|
446 | ||
447 | echo "<div style='text-align: center;'>"; |