|
@@ 334-338 (lines=5) @@
|
| 331 |
|
$query = |
| 332 |
|
"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 " |
| 333 |
|
. $sort_key; |
| 334 |
|
} elseif ($xoopsUser) { |
| 335 |
|
$uid = $xoopsUser->getVar('uid'); |
| 336 |
|
$query = |
| 337 |
|
"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 " |
| 338 |
|
. $sort_key; |
| 339 |
|
} |
| 340 |
|
$result = $xoopsDB->query($query); |
| 341 |
|
|
|
@@ 411-414 (lines=4) @@
|
| 408 |
|
$query = |
| 409 |
|
"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 " |
| 410 |
|
. $sort_key; |
| 411 |
|
} elseif ($xoopsUser) { |
| 412 |
|
$query = |
| 413 |
|
"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 " |
| 414 |
|
. $sort_key; |
| 415 |
|
} |
| 416 |
|
$result = $xoopsDB->query($query); |
| 417 |
|
|
XoopsModules25x /
xoopshp
