chamilo / chamilo-lms

     * @param   int     Category id

     * @return  bool    True if it success

     */

    public function store_edit_course_category($title, $category_id)

    {

        // protect data

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

        $category_id = intval($category_id);

        $result = false;

        $tucc = Database::get_main_table(TABLE_USER_COURSE_CATEGORY);

        $sql = "UPDATE $tucc

                SET title='".api_htmlentities($title, ENT_QUOTES, api_get_system_encoding())."'

                WHERE id='" . $category_id."'";

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

        if (Database::affected_rows($resultQuery)) {

            $result = true;

        }

        return $result;

    }

    /**

     * deletes a course category and moves all the courses that were in this category to main category

     * @param int $session_id

     * @return array|bool

     */

    public static function get_user_status_in_course_session($user_id, $courseId, $session_id)

    {

        $tbl_session_rel_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);

        $tbl_user = Database::get_main_table(TABLE_MAIN_USER);

        $sql = "SELECT session_rcru.status

                FROM $tbl_session_rel_course_rel_user session_rcru, $tbl_user user

                WHERE

                    session_rcru.user_id = user.user_id AND

                    session_rcru.session_id = '".intval($session_id)."' AND

                    session_rcru.c_id ='" . intval($courseId)."' AND

                    user.user_id = " . intval($user_id);

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

        $status = false;

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

            $status = Database::fetch_row($result);

            $status = $status['0'];

        }

        return $status;

    }

    /**

     * Gets user status within a session