@@ 373-377 (lines=5) @@ | ||
370 | if ($isModAdmin) { |
|
371 | $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 " |
|
372 | . $sort_key; |
|
373 | } elseif ($xoopsUser) { |
|
374 | $uid = $xoopsUser->getVar('uid'); |
|
375 | $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 " |
|
376 | . $sort_key; |
|
377 | } |
|
378 | $result = $xoopsDB->query($query); |
|
379 | ||
380 | echo "<div style='text-align: center;'>"; |
|
@@ 455-458 (lines=4) @@ | ||
452 | if ($isModAdmin) { |
|
453 | $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 " |
|
454 | . $sort_key; |
|
455 | } elseif ($xoopsUser) { |
|
456 | $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 " |
|
457 | . $sort_key; |
|
458 | } |
|
459 | $result = $xoopsDB->query($query); |
|
460 | ||
461 | echo "<div style='text-align: center;'>"; |