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;

        }

                    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'];

            $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;

    }

    $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;

}