function displayTestQueue($uid) { $puzzles = getInTestAdminQueue($uid); $puzzles = sortByLastCommentDate($puzzles); if (!$puzzles) { echo '<h3>No Puzzles Currently In Queue</h3>'; } else { displayQueue($uid, $puzzles, "notes answer summary testers", FALSE); } }
function getAvailablePuzzlesToFFCForUser($uid) { $sql = sprintf("SELECT puzzle_idea.id FROM puzzle_idea INNER JOIN pstatus ON puzzle_idea.pstatus=pstatus.id WHERE pstatus.finalFactcheck='1' AND NOT EXISTS (SELECT 1 FROM factcheck_queue WHERE factcheck_queue.pid=puzzle_idea.id) AND %s AND %s AND %s", sqlUserNotRelatedClause('spoiled', $uid), sqlUserNotRelatedClause('test_queue', $uid), sqlUserNotRelatedClause('doneTesting', $uid)); $puzzles = get_elements($sql); return sortByLastCommentDate($puzzles); }