chamilo / chamilo-lms

        $result = Database::query($sql);

        $questions_exists = true;

        if (Database::num_rows($result)) {

            while ($row = Database::fetch_array($result)) {

                if ($row['type'] == 'pagebreak') {

                    $counter++;

                } else {

                    $paged_questions[$counter][] = $row['question_id'];

                }

            }

        } else {

            $questions_exists = false;

        }

    $result = Database::query($sql);

    $list = array();

    $alreadyAdded = array();

    while ($row = Database::fetch_array($result, 'ASSOC')) {

        if (in_array($row['thread_id'], $alreadyAdded)) {

            continue;

        }

        $list[] = $row;

        $alreadyAdded[] = $row['thread_id'];

    }

    return $list;

}

        $result = Database::query($sql);

        if (Database::num_rows($result)) {

            while ($row = Database::fetch_array($result, 'ASSOC')) {

                if (!empty($skipCourseList)) {

                    if (in_array($row['real_id'], $skipCourseList)) {

                        continue;

                    }

                }

                $course_list[] = $row;

                $codes[] = $row['real_id'];

            }

        }

        if ($include_sessions === true) {

            $sql = "SELECT * FROM $table_track_attempt

                    WHERE exe_id = {$row['exe_id']}";

            $res_question = Database::query($sql);

            while ($row_q = Database::fetch_array($res_question, 'ASSOC')) {

                $list[$row['exe_id']]['question_list'][$row_q['question_id']][] = $row_q;

            }

        }

        return $list;

    }

                    WHERE c_id = $course_id AND survey_id = '".intval($survey_invitation['survey_id'])."'

                    ORDER BY sort ASC";

            $result = Database::query($sql);

            while ($row = Database::fetch_array($result, 'ASSOC')) {

                if ($row['type'] == 'pagebreak') {

                    $counter++;

                } else {

                    // ids from question of the current survey

                    $paged_questions[$counter][] = $row['question_id'];

                }

            }

            $_SESSION['paged_questions'] = $paged_questions;

        } else {

            $paged_questions = $_SESSION['paged_questions'];