chamilo / chamilo-lms

     * @param string $full_text The full post text

     * @param int $blog_id The internal ID of the blog in which the post is located

     */

    public static function editPost($post_id, $title, $full_text, $blog_id)

    {

        $tbl_blogs_posts = Database::get_course_table(TABLE_BLOGS_POSTS);

        $course_id = api_get_course_int_id();

        // Create the post

        $sql = "UPDATE $tbl_blogs_posts SET

                title = '".Database::escape_string($title)."',

                full_text = '".Database::escape_string($full_text)."'

                WHERE c_id = $course_id AND post_id ='".(int) $post_id."' AND blog_id ='".(int) $blog_id."'

                LIMIT 1 ";

        Database::query($sql);

    }

    /**

     * Deletes an article and its comments

     * @param Integer $blog_id

     * @param Integer $user_id

     */

    public static function unsubscribeUser($blog_id, $user_id)

    {

		// Init

        $tbl_blogs_rel_user = Database::get_course_table(TABLE_BLOGS_REL_USER);

        $tbl_user_permissions = Database::get_course_table(TABLE_PERMISSION_USER);

        // Unsubscribe the user

        $sql = "DELETE FROM $tbl_blogs_rel_user

                WHERE blog_id = '".(int) $blog_id."' AND user_id = '".(int) $user_id."'";

        Database::query($sql);

        // Remove this user's permissions.

        $sql = "DELETE FROM $tbl_user_permissions

                WHERE user_id = '".(int) $user_id."'";

        Database::query($sql);

    }

    /**

     * Displays the form to register users in a blog (in a course)