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

 * @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	int	   attendance id

	 * @return 	int	   number of done attendances

	 */

	public static function get_done_attendance_calendar($attendance_id)

	{

		$tbl_attendance_calendar = Database::get_course_table(TABLE_ATTENDANCE_CALENDAR);

		$attendance_id = intval($attendance_id);

		$course_id = api_get_course_int_id();

		$sql = "SELECT count(done_attendance) as count

                FROM $tbl_attendance_calendar

                WHERE

                    c_id = $course_id AND

                    attendance_id = '$attendance_id' AND

                    done_attendance = 1

                ";

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

		$row = Database::fetch_array($rs);

		$count = $row['count'];

		return $count;

	}

	/**

	 * Get results of faults (absents) by user

     * retrieves the user defined course categories

     * @return array containing all the IDs of the user defined courses categories, sorted by the "sort" field

     */

    public function get_user_course_categories()

    {

        $user_id = api_get_user_id();

        $table_category = Database::get_main_table(TABLE_USER_COURSE_CATEGORY);

        $sql = "SELECT * FROM " . $table_category . "

                WHERE user_id=$user_id

                ORDER BY sort ASC";

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

        $output = array();

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

            $output[] = $row;

        }

        return $output;

    }

    /**

     * This function get all the courses in the particular user category;

     * @param string $course_code

     * @return array An array with all classes (keys: 'id','code','name')

     */

    public static function get_classes_in_course($course_code) {

        $table_class = Database :: get_main_table(TABLE_MAIN_CLASS);

        $table_course_class = Database :: get_main_table(TABLE_MAIN_COURSE_CLASS);

        $sql = "SELECT cl.* FROM $table_class cl, $table_course_class cc WHERE cc.course_code = '".Database::escape_string($course_code)."' AND cc.class_id = cl.id";

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

        $classes = array ();

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

            $classes[] = $class;

        }

        return $classes;

    }

}

     * @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 $officialCode

     * @return array

     */

    public static function getUsersByOfficialCode($officialCode)

    {

        $user = Database::get_main_table(TABLE_MAIN_USER);

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

        $sql = "SELECT DISTINCT id

                FROM $user

                WHERE official_code = '$officialCode'

                ";

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

        $users = array();

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

            $users[] = $row['id'];

        }

        return $users;

    }

    /**

     * Calc the expended time (in seconds) by a user in a course

     * @param int $sessionId

     * @return array

     */

    public static function getCoachesBySession($sessionId)

    {

        $table = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);

        $sessionId = intval($sessionId);

        $sql = "SELECT DISTINCT user_id

                FROM $table

                WHERE session_id = '$sessionId' AND status = 2";

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

        $coaches = array();

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

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

                $coaches[] = $row['user_id'];

            }

        }

        return $coaches;

    }

    /**

     * @param int $userId

     * @param int $sessionId The session id

     * @return array

     */

    public static function getTotalUserCoursesInSession($sessionId)

    {

        $tableUser = Database::get_main_table(TABLE_MAIN_USER);

        $tableSessionRelCourseRelUser = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);

        $sql = "SELECT COUNT(1) as count, u.id, scu.status status_in_session, u.status user_status

                FROM $tableSessionRelCourseRelUser scu

                INNER JOIN $tableUser u ON scu.user_id = u.id

                WHERE scu.session_id = " . intval($sessionId) ."

                GROUP BY u.id";

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

        $list = array();

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

            $list[] = $data;

        }

        return $list;

    }

    /**

     *

     * @return array

     */

    public static function getCoursesInSession($sessionId)

    {

        $listResultsCourseId = array();

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

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

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

        }

        return $listResultsCourseId;

    }

    /**

     * Return an array of courses in session for user

* 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

     * @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

     * @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;

}

/**

 * This function sends the notification mails to everybody who stated that they wanted to be informed when a new post