chamilo / chamilo-lms

	 * @param String $full_text

	 * @param Integer $blog_id

	 */

	public static function edit_post($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 it's comments

	 * @param Integer $blog_id

	 * @param Integer $user_id

	 */

	public static function set_user_unsubscribed($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)