chamilo / chamilo-lms

 </script>';

function get_courses_list_by_user_id_based_in_exercises($user_id) {

    $TABLETRACK_EXERCICES = Database::get_main_table(TABLE_STATISTIC_TRACK_E_EXERCISES);

    $user_id = intval($user_id);

    $sql = "SELECT DISTINCT exe_user_id, c_id, session_id

            FROM $TABLETRACK_EXERCICES

            WHERE exe_user_id = $user_id

            ORDER by exe_user_id, c_id ASC";

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

    $course_list = array();

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

        $course_list []= $row;

    }

    return $course_list;

}

Display::display_header(get_lang('MoveUserStats'));

* The function that retrieves all the possible settings for a certain config setting

* @author Patrick Cool <[email protected]>, Ghent University

*/

function api_get_settings_options($var) {

    $table_settings_options = Database :: get_main_table(TABLE_MAIN_SETTINGS_OPTIONS);

    $var = Database::escape_string($var);

    $sql = "SELECT * FROM $table_settings_options

            WHERE variable = '$var'

            ORDER BY id";

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

    $settings_options_array = array();

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

        $settings_options_array[] = $row;

    }

    return $settings_options_array;

}

/**

 * @param array $params

 * @param    string    Comment to set

 * @return   Doctrine\DBAL\Driver\Statement|null    Result of the database operation (Database::query will output some message directly on error anyway)

 */

function SetComment($path, $comment)

{

    $dbTable = Database::get_course_table(TABLE_DOCUMENT);

    $path = Database::escape_string($path);

    $comment = Database::escape_string($comment);

    $course_id = api_get_course_int_id();

    $query = "UPDATE $dbTable SET comment='$comment'

              WHERE $course_id AND path='$path'";

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

    return $result;

}

/**

 * Reads the file contents into a string.

     * @param string $course_code The course (default = current course)

     * @return array

     */

    public static function get_categories($course_code = null)

    {

        $course_info = api_get_course_info($course_code);

        $course_id     = $course_info['real_id'];

        $table_group_cat = Database :: get_course_table(TABLE_GROUP_CATEGORY);

        $sql = "SELECT * FROM $table_group_cat

                WHERE c_id = $course_id

                ORDER BY display_order";

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

        $cats = array ();

        while ($cat = Database::fetch_array($res)) {

            $cats[] = $cat;

        }

        return $cats;

    }

    /**

     * Get a group category

     * @param string $course_code The course (default = current course)

     * @return array

     */

    public static function get_category($id, $course_code = null)

    {

        if (empty($id)) {

            return array();

        }

        $course_info = api_get_course_info($course_code);

        $course_id = $course_info['real_id'];

        $id = intval($id);

        $table_group_cat = Database :: get_course_table(TABLE_GROUP_CATEGORY);

        $sql = "SELECT * FROM $table_group_cat

                WHERE c_id = $course_id AND id = $id

                LIMIT 1";

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

        return Database::fetch_array($res);

    }

    /**

     * @author Patrick Cool <[email protected]>, Ghent University

     * @version September 2007

     */

    public static function get_invitations($survey_code)

    {

        $course_id = api_get_course_int_id();

        // Database table definition

        $table_survey_invitation 	= Database :: get_course_table(TABLE_SURVEY_INVITATION);

        $sql = "SELECT * FROM $table_survey_invitation

		        WHERE

		            c_id = $course_id AND

		            survey_code = '".Database::escape_string($survey_code)."'";

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

        $return = array();

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

            $return[$row['user']] = $row;

        }

        return $return;

    }

    /**

     * This function displays the form for searching a survey

     *

     * @return array

     */

    public static function get_all_exercises_from_lp($lp_id, $course_id)

    {

        $lp_item_table = Database :: get_course_table(TABLE_LP_ITEM);

        $course_id = intval($course_id);

        $lp_id = intval($lp_id);

        $sql = "SELECT * FROM $lp_item_table

                WHERE

                    c_id = $course_id AND

                    lp_id = '".$lp_id."' AND

                    item_type = 'quiz'

                ORDER BY parent_item_id, display_order";

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

        $my_exercise_list = array();

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

            $my_exercise_list[] = $row;

        }

        return $my_exercise_list;

    }

    /**

     * This function gets the comments of an exercise

     * @param int $courseId

     * @return bool

     */

    public static function hasCourseSetting($variable, $courseId)

    {

        $courseSetting = Database::get_course_table(TABLE_COURSE_SETTING);

        $courseId = intval($courseId);

        $variable = Database::escape_string($variable);

        $sql = "SELECT variable FROM $courseSetting

                WHERE c_id = $courseId AND variable = '$variable'";

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

        return Database::num_rows($result) > 0;

    }

    /**

     * @param $courseId

     * @return array

     */

    public static function getCourseSettings($courseId)

    {

        $settingTable = Database::get_course_table(TABLE_COURSE_SETTING);

        $courseId = intval($courseId);

        $sql = "SELECT * FROM $settingTable WHERE c_id = $courseId";

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

        $settings = array();

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

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

                $settings[$row['variable']] = $row;

            }

        }

        return $settings;

    }

    /**

     * this function gets all the users of the course,

 * @author Patrick Cool <[email protected]>, Ghent University

 * @version february 2006, dokeos 1.8

 */

function get_unaproved_messages($forum_id)

{

    $table_posts = Database :: get_course_table(TABLE_FORUM_POST);

    $course_id = api_get_course_int_id();

    $return_array = array();

    $sql = "SELECT DISTINCT thread_id FROM $table_posts

            WHERE 

                c_id = $course_id AND 

                forum_id='".Database::escape_string($forum_id)."' AND 

                visible='0' ";

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

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

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

    }

    return $return_array;

}

     *

     * @return array

     */

    public static function getCoursesInSession($sessionId)

    {

        if (empty($sessionId)) {

            return [];

        }

        $tblSessionRelCourse = Database::get_main_table(TABLE_MAIN_SESSION_COURSE);

        $tblCourse = Database::get_main_table(TABLE_MAIN_COURSE);

        // list of course in this session

        $sql = "SELECT session_id, c.id

                FROM $tblSessionRelCourse src

                LEFT JOIN $tblCourse c

                ON c.id = src.c_id

                WHERE session_id = ".intval($sessionId);

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

        $listResultsCourseId = array();

        while ($data = Database::fetch_assoc($res)) {

            $listResultsCourseId[] = $data['id'];

        }

        return $listResultsCourseId;

    }

    /**

     * Return an array of courses in session for user