Esempio n. 1
0
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);
    }
}
Esempio n. 2
0
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);
}