<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head profile="http://internetalchemy.org/2003/02/profile">
<link rel="foaf" type="application/rdf+xml" title="FOAF" href="http://www.openlinksw.com/dataspace/uda/about.rdf" />
<link rel="schema.dc" href="http://purl.org/dc/elements/1.1/" />
<meta name="dc.title" content="12. Web Application Development" />
<meta name="dc.subject" content="12. Web Application Development" />
<meta name="dc.creator" content="OpenLink Software Documentation Team ; " />
<meta name="dc.copyright" content="OpenLink Software, 1999 - 2009" />
<link rel="top" href="index.html" title="OpenLink Virtuoso Universal Server: Documentation" />
<link rel="search" href="/doc/adv_search.vspx" title="Search OpenLink Virtuoso Universal Server: Documentation" />
<link rel="parent" href="webappdevelopment.html" title="Chapter Contents" />
<link rel="prev" href="asmxhosting.html" title="ASMX Web Service Hosting" />
<link rel="next" href="servphpext.html" title="Deploying PHP Applications" />
<link rel="shortcut icon" href="../images/misc/favicon.ico" type="image/x-icon" />
<link rel="stylesheet" type="text/css" href="doc.css" />
<link rel="stylesheet" type="text/css" href="/doc/translation.css" />
<title>12. Web Application Development</title>
<meta http-equiv="Content-Type" content="text/xhtml; charset=UTF-8" />
<meta name="author" content="OpenLink Software Documentation Team ; " />
<meta name="copyright" content="OpenLink Software, 1999 - 2009" />
<meta name="keywords" content="" />
<meta name="GENERATOR" content="OpenLink XSLT Team" />
</head>
<body>
<div id="header">
<a name="blogger" />
<img src="../images/misc/logo.jpg" alt="" />
<h1>12. Web Application Development</h1>
</div>
<div id="navbartop">
<div>
<a class="link" href="webappdevelopment.html">Chapter Contents</a> | <a class="link" href="asmxhosting.html" title="ASMX Web Service Hosting">Prev</a> | <a class="link" href="servphpext.html" title="Deploying PHP Applications">Next</a>
</div>
</div>
<div id="currenttoc">
<form method="post" action="/doc/adv_search.vspx">
<div class="search">Keyword Search: <br />
<input type="text" name="q" /> <input type="submit" name="go" value="Go" />
</div>
</form>
<div>
<a href="http://www.openlinksw.com/">www.openlinksw.com</a>
</div>
<div>
<a href="http://docs.openlinksw.com/">docs.openlinksw.com</a>
</div>
<br />
<div>
<a href="index.html">Book Home</a>
</div>
<br />
<div>
<a href="contents.html">Contents</a>
</div>
<div>
<a href="preface.html">Preface</a>
</div>
<br />
<div class="selected">
<a href="webappdevelopment.html">Web Application Development</a>
</div>
<br />
<div>
<a href="webserver.html">The HTTP Server</a>
</div>
<div>
<a href="wsacl.html">Web Services ACL (Access Control List)</a>
</div>
<div>
<a href="vsp1.html">Virtuoso Server Pages (VSP)</a>
</div>
<div>
<a href="vspx.html">Virtuoso Server Pages for XML (VSPX)</a>
</div>
<div>
<a href="rthwritaspxapps.html">Deploying ASP.Net Web Applications</a>
</div>
<div>
<a href="asmxhosting.html">ASMX Web Service Hosting</a>
</div>
<div class="selected">
<a href="blogger.html">Blogging & Weblogs</a>
<div>
<a href="#blogvirtblogapp" title="The Virtuoso Blogging Application">The Virtuoso Blogging Application</a>
<a href="#bloggerclientcompatibility" title="Blogger Clients Compatibility">Blogger Clients Compatibility</a>
<a href="#bloggermanagementui" title="Blogs Management User Interface">Blogs Management User Interface</a>
<a href="#blogcommunityblog" title="Community Blog Site">Community Blog Site</a>
<a href="#bloggerapi" title="Blogger API">Blogger API</a>
<a href="#bloggermetaweblog" title="MetaWeblog API">MetaWeblog API</a>
<a href="#bloggermovabletype" title="Movable Type API">Movable Type API</a>
<a href="#blogatomapi" title="Atom API">Atom API</a>
<a href="#bloggerendpointconf" title="XML-RPC Endpoint Configuration">XML-RPC Endpoint Configuration</a>
<a href="#bloggerhooks" title="Blog Hooks - Customizing the Blog Server">Blog Hooks - Customizing the Blog Server</a>
<a href="#bloggerclientapi" title="Blogger Client API">Blogger Client API</a>
<a href="#xmlstoragesystem" title="xmlStorageSystem API">xmlStorageSystem API</a>
<a href="#xmlstoragesystem" title="User's Blog quota">User's Blog quota</a>
<a href="#xmlstoragesystem" title="Posting a message in to the Blog">Posting a message in to the Blog</a>
<a href="#xmlstoragesystem" title="Multi-author blogging">Multi-author blogging</a>
<a href="#xmlstoragesystem" title="Posting a comments">Posting a comments</a>
<a href="#xmlstoragesystem" title="Blog Post Upstreaming (bridging)">Blog Post Upstreaming (bridging)</a>
<a href="#xmlstoragesystem" title="Weblogs API">Weblogs API</a>
<a href="#xmlstoragesystem" title="Subscriptions">Subscriptions</a>
<a href="#xmlstoragesystem" title="Trackback API">Trackback API</a>
<a href="#xmlstoragesystem" title="Pingback API">Pingback API</a>
<a href="#xmlstoragesystem" title="E-mail Notifications">E-mail Notifications</a>
<a href="#blognotifcomments" title="Comments tracking options">Comments tracking options</a>
<a href="#xmlstoragesystem" title="Subscription Harmonizer API">Subscription Harmonizer API</a>
<a href="#moblog" title="Mobile Blogging (Moblog)">Mobile Blogging (Moblog)</a>
<a href="#blogxmltemplate" title="Posting a dynamic content">Posting a dynamic content</a>
<a href="#blognotifservices" title="Notification Services">Notification Services</a>
<a href="#blogwaprender" title="Rendering the RSS feed in WML format">Rendering the RSS feed in WML format</a>
</div>
</div>
<div>
<a href="servphpext.html">Deploying PHP Applications</a>
</div>
<div>
<a href="rthjsp.html">Deploying JSP Applications</a>
</div>
<div>
<a href="perlhosting.html">Perl Hosting</a>
</div>
<div>
<a href="pythonhosting.html">Python Hosting</a>
</div>
<div>
<a href="rubyhosting.html">Ruby Hosting</a>
</div>
<br />
</div>
<div id="text">
<a name="blogger" />
<h2>12.7. Blogging & Weblogs</h2>
<p>Weblogs, or Blog, are web pages or sites organized by date.
The content of a typical blog page contains short messages listed in
chronological order. The blog messages are typically excerpts of HTML markup,
since they typically appear on web sites and expect web browsers as clients.</p>
<p>In the rest of this document we will use interchangeable the terms "blog"
and "weblog", and refer to the users that have a blog as "bloggers".</p>
<p>The following terms are also commonly used in this section:</p>
<ul>
<li>
<strong>RSS/OCS/OPML/RDF/Atom</strong> - file formats, XML based to represent
data or list of files containing a data</li>
<li>
<strong>Channels</strong> - a public source containing data in any of
XML/text/HTML format, usually in RSS format. </li>
<li>
<strong>Post/Article(message)</strong> - this is a piece of information
describing something in a human readable format, in some language. This can be have
satellite parts as title, excerpt, publication data etc.</li>
<li>
<strong>PermaLink</strong> - a URL that uniquely designates a
single article in blog-space and time.</li>
</ul>
<p>The Virtuoso Blog system comprises a native Web-based interface
for publishing and blog administration, but can also be interacted with using
an XML-RPC API. The Virtuoso server supports the following XML-RPC APIs for
blogging purposes:</p>
<ul>
<li>Blogger API</li>
<li>MetaWeblog API</li>
<li>Movable Type</li>
</ul>
<p>In addition to the blogger APIs Virtuoso supports:</p>
<ul>
<li>
<strong>xmlStorageSystem</strong> - this allows blogging clients
to upload static (ready to go) content onto a Weblog server.</li>
<li>
<strong>Weblogs ping API</strong> - to allow cross-server
notification for the latest updated sites/blogs</li>
<li>
<strong>Pingback and Trackback API</strong> - to allow bloggers
to notify each other.</li>
<li>
<strong>Subscription Harmonizer</strong> - to allow bloggers to
keep their subscriptions in-sync.</li>
</ul>
<div class="tip">
<div class="tiptitle">See Also:</div>
<p>The <a href="">Blogger System Tables</a>
that are used to keep Weblog data.</p>
</div>
<div class="tip">
<div class="tiptitle">See Also: Reference Material on the Internet:</div>
<p>Blogger API:</p>
<p>
<a href="http://xmlrpc.free-conversant.com/docs/bloggerAPI">xmlrpc.free-conversant.com</a>
</p>
<p>
<a href="http://plant.blogger.com/api/index.html">plant.blogger.com</a>
</p>
<p>Movable Type API (extensions for blogger API):</p>
<p>
<a href="http://www.movabletype.org/docs/mtmanual_programmatic.html">www.movabletype.org</a>
</p>
<p>MetaWeblog API (extension of blogger API with RSS2 elements):</p>
<p>
<a href="http://www.xmlrpc.com/metaWeblogApi">www.xmlrpc.com</a>
</p>
<p>Other:</p>
<p>
<a href="http://www.soapware.org/xmlStorageSystem">xmlStorageSystem API (SOAP/XML-RPC based Internet file system)</a>
</p>
<p>
<a href="http://www.opml.org/spec">OPML (Outline Processor Markup Language)</a>
</p>
<p>
<a href="http://internetalchemy.org/ocs/directory.html">OCS (Open Content Syndication directory)</a>
</p>
</div>
<a name="blogvirtblogapp" />
<h3>12.7.1. The Virtuoso Blogging Application</h3>
<p>Blogs provide their authors with a location on the Internet or Intranet
to receive their thoughts, experiences, idea, or simply anything they have
a desire to write about. For this most part, audience is neither expected
nor required, however comments and feedback are common place. </p>
<p>Blogs originated as a form of public diary. Their exploitation has seen them
as a useful tool for finding personal reviews to products, situations or
general news as guidance for their readers. These can be viewed quicker and
more informative than regular journalism.</p>
<p>Corporate blogs, or use of blogging can be a valuable source of company
information propagation. Members of the company can blog about the activities
or findings with no particular audience in mind. This provides a continual
journal or account of the company's undertakings that is really
self-documenting for every other employee how they fit into the overall
picture. Over time a searchable knowledge base will unravel itself, people
may need information about a product or some aspect of internal support that
took place possibly years prior, otherwise forgotten, stored within the blog.</p>
<p>Virtuoso implements the three major APIs for blogging which makes instantly
attractive to any standard blog application. Virtuoso provides blog authoring
applications of its own. On a personal level, your blogs can be stored or
exposed using the most appropriate server, authored using the most appealing
client and everything held in right places by Virtuoso. On a community level
you get the same but scaled upwards for each member individually,
and further more, centrally. Virtuoso can generate and automatically maintain
a blog site specially for blog collaboration within a community suitable
for a corporate need. All members are listed on the front page and have
the opportunity to contribute (publish) to the main blog view. All blogs
are fully free text searchable - a simple exploit of the Virtuoso
free-text engine. </p>
<p>Virtuoso can provide the blog client, server or relay for blogs or any
RSS or XML-feed based channel or information.</p>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Virtuoso Blogging Conceptual Diagram" src="../images/VirtuosoBlog.jpg" />
</td>
</tr>
<tr>
<td>Figure: 12.7.1.1. Virtuoso Blogging Conceptual Diagram</td>
</tr>
</table>
<a name="blogsyndicateyourblog" />
<h4>12.7.1.2. Syndication to your Blog - RSS & RDF</h4>
<p>The default Virtuoso blog implementation maintains a "blog/gems" subdirectory
for each blog account. Within this is an RDF file and an RSS file.
These provide direct access to the blog information in XML. Other
bloggers or news syndicators can read just the site contents, apart from
the web interface that Virtuoso provides, potentially applying an
XSLT transformations suitable to their application or circumstance, for
example reading the blog from a PDA or mobile device.</p>
<p>Rich Site Summary (RSS) is a lightweight XML format designed for
sharing headlines and other Web content. Think of it as a distributable
"What's New" for your site. Each RSS text file contains both static
information about your site, plus dynamic information about your new blog
entries. Each entry is defined by an <item> tag, which contains a
headline TITLE, URL, and DESCRIPTION. For example: </p>
<div>
<pre class="programlisting">
...
<item>
<title>RSS Resources</title>
<link>http://www.webreference.com/authoring/languages/xml/rss/</link>
<description>Defined in XML, the Rich Site Summary (RSS) format has
quietly become a dominant format for distributing headlines on the Web.
Our list of links gives you the tools, tips and tutorials you need to get
started using RSS. 0323</description>
</item>
...
</pre>
</div>
<p>The Resource Description Framework (RDF) integrates a variety of
applications from library catalogs and world-wide directories to syndication
and aggregation of news, software, and content to personal collections
of music, photos, and events using XML as an interchange syntax. The
RDF specifications provide a lightweight ontology system to support the
exchange of knowledge on the Web. </p>
<br />
<a name="blogchannels" />
<h4>12.7.1.3. Channels - OCS & OPML</h4>
<p>The default Virtuoso blog implementation maintains a "blog/gems" subdirectory
for each blog account. Within this are an OCS file and an OPML file.
Both files provide an outline or hierarchical list of RSS feeds
linked to the blog account in these two popular formats designed for
channel/list exchange. The files are variably accessible following:</p>
<div>
<pre class="programlisting">
http://virtserv/DAV/myaccount/blog/gems/index.ocs
http://virtserv/DAV/myaccount/blog/gems/index.opml
</pre>
</div>
<p>Open Content Syndication (OCS), an application of XML, is an
RDF description of all external RSS feeds linked to the blog site. </p>
<p>The OCS Directory format is designed to enable channel listings to
be constructed for use by portal sites, client based headline software
and other similar applications.</p>
<p>Outline Processor Markup Language (OPML) is a very simple XML
format for storing information in outline format. XML being
inherently hierarchical, OPML constrains XML so that a wide
variety of applications can build in OPML support with the
comfort of knowing it will work with any other OPML tool.
Type of information stored in such hierarchies are web browser
bookmarks, web directories, collaborative outlines, song playlists,
and even web-site content, OPML is a great balance between the
wide open freedom of raw XML and the feeling of security of a
formal vocabulary.</p>
<p>The OCS RDF file is an XML of nested <rdf:descriptions> tags
loosely defined as follows:</p>
<div>
<pre class="programlisting">
<rdf:RDF>
<rdf:description>
This contains a description of this RDF originator
<rdf:description>
Description of a link RSS blog or news feed
<rdf:description>
Description of the URL containing the above described
RSS feed and details about its format, update frequency
and when the link for established.
</rdf:description>
</rdf:description>
more RSS descriptions may follow, one for each
linked.
</rdf:description>
</rdf:RDF>
</pre>
</div>
<p>Here is an example of the contents of the index.ocs file describing
a single linked RSS news feed.</p>
<div>
<pre class="programlisting">
<rdf:RDF
xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
xmlns:ocs="http://InternetAlchemy.org/ocs/directory#"
xmlns:dc="http://purl.org/metadata/dublin_core#">
<rdf:description about="">
<dc:title>My Blog</dc:title>
<dc:creator>blog@openlinksw.com</dc:creator>
<dc:description />
<rdf:description about="http://msdn.microsoft.com/">
<dc:title>MSDN Just Published</dc:title>
<dc:creator />
<dc:description />
<dc:subject />
<dc:image />
<rdf:description about="http://msdn.microsoft.com/rss.xml">
<dc:language>us-en</dc:language>
<ocs:format />
<ocs:updatePeriod>hourly</ocs:updatePeriod>
<ocs:updateFrequency>1</ocs:updateFrequency>
<ocs:updateBase>1999-05-30T00:00</ocs:updateBase>
</rdf:description>
</rdf:description>
</rdf:RDF>
</pre>
</div>
<p>The OPML file is more simple, the corresponding index.opml would be
as follows:</p>
<div>
<pre class="programlisting">
<opml>
<body>
<outline
title="MSDN Just Published"
htmlUrl="http://msdn.microsoft.com/"
xmlUrl="http://msdn.microsoft.com/rss.xml" />
more outline tags for each description...
</body>
</opml>
</pre>
</div>
<div class="tip">
<div class="tiptitle">See Also:</div>
<p>
<a href="http://internetalchemy.org/">internetalchemy.org</a>
</p>
<p>
<a href="http://www.opml.org/">www.opml.org</a>
</p>
</div>
<br />
<a name="blogpersonalblog" />
<h4>12.7.1.4. Personal Blog Sites</h4>
<p>Every WebDAV account with a home directory has the option to create a
default personal blog site. The default blog pages contains a call to
a function that produces XML data containing a list of messages, calendar
for archive navigation and channels that the owner has subscribed to.
This blog directory and pages are generated upon initial sign-in of the
user. Each WebDAV account with a blog directory will thus have the following:</p>
<div>
<pre class="programlisting">
http://<host:port>/DAV/<uname>/blog/
</pre>
</div>
<p>containing the following:</p>
<ul>
<li>
<strong>index.vspx</strong> - The default blog home page using VSPX controls.</li>
<li>
<strong>gems/rss.xml</strong> - The RSS v2.0 file presenting the user's blog data.</li>
<li>
<strong>gems/rss92.xml</strong> - The RSS v0.92 file presenting the user's blog data.</li>
<li>
<strong>gems/rss91.xml</strong> - The RSS v0.91 file presenting the user's blog data.</li>
<li>
<strong>gems/index.rdf</strong> - the user's blog data in RDF format.</li>
<li>
<strong>gems/index.ocs</strong> - the user's channels represented in OCS format.</li>
<li>
<strong>gems/rsd.xml</strong> - Really Simple Discovery file for the blog. This helps client software to find the services needed to read, edit, post etc.</li>
<li>
<strong>gems/atom.xml</strong> - Atom feed file. It's similar to the RSS file but in different format.</li>
<li>
<strong>gems/backlog.xml</strong> - RSS v2.0 file containing all posts in user's blog.</li>
<li>
<strong>gems/foaf.xml</strong> - 'Friend Of Friend' file. This is to provide in a machine-processable format, about blogger, his/she interests, location, friends etc.</li>
<li>
<strong>gems/index.opml</strong> - the user's channels represented in OPML format.</li>
<li>
<strong>gems/ocs.xml</strong> - the user's channels represented in OCS format.</li>
<li>
<strong>gems/opml.xml</strong> - the user's channels represented in OPML format.</li>
<li>
<strong>comments.vsp</strong> - a VSP page for posting a comment to the user's blog.</li>
<li>
<strong>default.xsl</strong> - an XSL-T style sheet providing the default HTML view of the blog XML data.</li>
<li>
<strong>comments.vsp</strong> - pop-up for blog comments (obsoleted)</li>
<li>
<strong>default.css</strong> - CSS for pages</li>
<li>
<strong>main.xsl</strong> - VSPX controls for index.vspx</li>
<li>
<strong>calendar.xsl</strong> - calendar control</li>
<li>
<strong>trackback.xsl</strong> - pop-up for trackbacks (obsoleted)</li>
<li>
<strong>rss_feeds/</strong> - folder containing channel RSS feeds in XML format </li>
</ul>
<p>The <span class="computeroutput">rss.xml</span>, <span class="computeroutput">index.rdf</span>,
<span class="computeroutput">index.ocs</span> files are dynamic SQL-XML resources,
they are not static files and must not be deleted. Their content is
generated in real-time per request.</p>
<p>Blog users may edit the <span class="computeroutput">default.xsl</span> in
order to change the appearance of the default page of their Blog.</p>
<a name="ex_defaultbloghome" />
<div class="example">
<div class="exampletitle">Default blog home (index.vspx) page</div>
<p>The following is source of default blog home page. It's built using a VSPX and macro expansion.
All page components are represented with <vm:* /> this makes page more simpler and allows users to
change it's appearance using custom VSPX components.
</p>
<div>
<pre class="programlisting">
<v:page xmlns:vm="http://www.openlinksw.com/vspx/weblog/"
xmlns:v="http://www.openlinksw.com/vspx/"
style="main.xsl" name="blog-home-page"
doctype="-//W3C//DTD XHTML 1.0 Transitional//EN"
doctype-system="http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<vm:page id="<UID>">
<vm:header>
<vm:title/>
<vm:disco-rss-link/>
<vm:disco-pingback-link/>
<vm:meta-author/>
<vm:meta-description/>
<vm:meta-keywords/>
<vm:style url="default.css" />
</vm:header>
<vm:body>
<div id="header">
<img src="/blog/blogs/images/bloglogo.jpg" alt="OpenLink Virtuoso Blog"/>
<h1><vm:blog-title/></h1>
<h2><vm:blog-about/></h2>
</div>
<div id="navbartop">
<div>Entries: [ <vm:entry-list /> ]</div>
</div>
<table id="pagecontainer" cellspacing="10" cellpadding="0" border="0" width="100%">
<tr>
<td class="box">
<div class="box">
<div class="roll" style="border: none; border">
<div align="center" style="margin-bottom: 3px;">
<b>Personal Details</b>
</div>
<div style="margin-bottom: 3px;"><vm:site-home>Home</vm:site-home></div>
<vm:if test="contact">
<div>
<vm:e-mail> Contact</vm:e-mail>
</div>
</vm:if>
<div>
<vm:photo width="64" />
</div>
</div>
<vm:if test="login">
<div class="roll" >
<div align="center" style="margin-bottom: 3px;">
<b>Configuration</b>
</div>
<vm:configpages />
</div>
</vm:if>
<div class="roll">
<div align="center" style="margin-bottom: 3px;">
<b>Syndicate This Blog</b>
</div>
<vm:rss-link/>
<vm:rdf-link/>
<vm:ocs-link/>
<vm:opml-link/>
</div>
<div align="left" class="roll">
<p class="caption">Keyword search:</p>
<vm:search/>
</div>
<div class="roll">
<div align="center" style="margin-bottom: 3px;">
<b>Post Categories</b>
</div>
<vm:login />
<vm:categories/>
</div>
<vm:if test="subscribe">
<div align="left" class="roll">
<p class="caption">Subscribe</p>
<vm:subscribe/>
</div>
</vm:if>
<div align="left" class="roll">
<vm:last-messages />
</div>
</div>
</td>
<td id="texttd">
<div id="text">
<vm:post-form />
<vm:posts trackback="discovery" />
<vm:if test="comments">
<vm:comments-view>
<vm:trackbacks />
<vm:comments />
<vm:post-comment />
</vm:comments-view>
</vm:if>
</div>
</td>
<td class="box">
<div class="box">
<vm:calendar/>
<vm:if test="blog">
<div class="roll">
<div align="center">
<b>Blog Roll</b>
</div>
<vm:rss/>
</div>
</vm:if>
<vm:if test="channels">
<div class="roll">
<div align="center">
<b>Channel Roll</b>
</div>
<vm:channels/>
</div>
</vm:if>
<vm:if test="ocs">
<div class="roll">
<div align="center" style="margin-bottom: 3px;">
<b>OCS Links</b>
</div>
<vm:ocs/>
</div>
</vm:if>
<vm:if test="opml">
<div class="roll">
<div align="center" style="margin-bottom: 3px;">
<b>OPML Links</b>
</div>
<vm:opml/>
</div>
</vm:if>
</div>
</td>
</tr>
</table>
<div id="powered">
<vm:powered-by/>
</div>
<div class="disclaimer">
<vm:disclaimer/>
</div>
<div class="copy">
<vm:copyright/>
</div>
</vm:body>
</vm:page>
</v:page>
</pre>
</div>
</div>
<a name="ex_bloghome" />
<div class="example">
<div class="exampletitle">Blog home (index.vsp) page</div>
<p>The XML Schema representing the XML data for blog home page is represented below.
Following this fragment is the <span class="computeroutput">default.xsl</span> XSL
style sheet that would be used to transform XML document valid to this into the default web page for public
consumption on the Internet or Intranet.</p>
<div>
<pre class="programlisting">
<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema">
<xs:element name="about">
<xs:complexType/>
</xs:element>
<xs:element name="blog">
<xs:complexType mixed="true">
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element ref="title"/>
<xs:element ref="about"/>
<xs:element ref="email"/>
<xs:element ref="items"/>
<xs:element ref="navigation"/>
<xs:element ref="copy"/>
<xs:element ref="disclaimer"/>
</xs:choice>
<xs:attribute name="base" type="xs:anyURI"/>
<xs:attribute name="category" type="xs:string"/>
<xs:attribute name="category-name" type="xs:string"/>
<xs:attribute name="post" type="xs:string"/>
<xs:attribute name="trackback-url" type="xs:anyURI"/>
</xs:complexType>
</xs:element>
<xs:element name="blogroll">
<xs:complexType>
<xs:sequence>
<xs:element ref="link"/>
</xs:sequence>
<xs:attribute name="id" type="xs:boolean" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="calendar">
<xs:complexType>
<xs:sequence>
<xs:element ref="week" maxOccurs="unbounded"/>
</xs:sequence>
<xs:attribute name="monthname" type="xs:string" use="required"/>
<xs:attribute name="year" type="xs:short" use="required"/>
<xs:attribute name="month" type="xs:byte" use="required"/>
<xs:attribute name="day" type="xs:byte" use="required"/>
<xs:attribute name="prev" type="xs:string" use="required"/>
<xs:attribute name="prev-label" type="xs:string" use="required"/>
<xs:attribute name="next" type="xs:string" use="required"/>
<xs:attribute name="next-label" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="categories">
<xs:complexType>
<xs:sequence>
<xs:element ref="category" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="category">
<xs:complexType>
<xs:attribute name="id" use="required" type="xs:NMTOKEN" />
<xs:attribute name="name" use="required" type="xs:string" />
</xs:complexType>
</xs:element>
<xs:element name="comments" type="xs:boolean"/>
<xs:element name="copy" type="xs:string"/>
<xs:element name="day">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="active" use="required">
<xs:simpleType>
<xs:restriction base="xs:NMTOKEN">
<xs:enumeration value="0"/>
<xs:enumeration value="1"/>
</xs:restriction>
</xs:simpleType>
</xs:attribute>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element name="description" type="xs:string"/>
<xs:element name="disclaimer" type="xs:string"/>
<xs:element name="email" type="xs:string"/>
<xs:element name="id" type="xs:string" />
<xs:element name="item">
<xs:complexType>
<xs:sequence>
<xs:element ref="description"/>
<xs:element ref="pubDate"/>
<xs:element ref="id"/>
<xs:element ref="comments"/>
<xs:element ref="trackbacks"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="items">
<xs:complexType>
<xs:sequence>
<xs:element ref="item" maxOccurs="unbounded"/>
<xs:element ref="last"/>
</xs:sequence>
<xs:attribute name="search" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="last">
<xs:complexType>
<xs:sequence>
<xs:element ref="message" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="link">
<xs:complexType>
<xs:sequence>
<xs:element ref="blog"/>
</xs:sequence>
<xs:attribute name="href" type="xs:anyURI" use="required"/>
<xs:attribute name="rss" type="xs:anyURI" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="message">
<xs:complexType>
<xs:sequence>
<xs:element ref="id"/>
<xs:element ref="title"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="navigation">
<xs:complexType>
<xs:sequence>
<xs:element ref="calendar"/>
<xs:element ref="blogroll"/>
<xs:element ref="categories"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="pubDate" type="xs:string"/>
<xs:element name="title">
<xs:complexType>
<xs:simpleContent>
<xs:extension base="xs:string">
<xs:attribute name="blogid" type="xs:byte"/>
</xs:extension>
</xs:simpleContent>
</xs:complexType>
</xs:element>
<xs:element name="trackbacks" type="xs:boolean"/>
<xs:element name="week">
<xs:complexType>
<xs:sequence>
<xs:element ref="day" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:schema>
</pre>
</div>
<p>The XML data as following XML Schema above will be transformed using the following XSL-T style sheet, default.xsl:</p>
<div>
<pre class="programlisting">
<?xml version="1.0"?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform"
version="1.0"
xmlns:vb="http://www.openlinksw.com/weblog/"
xmlns:vtb="http://www.openlinksw.com/weblog/tb/" >
<xsl:output method="xml" doctype-public="-//W3C//DTD XHTML 1.0 Transitional//EN"
doctype-system="http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"
indent="yes" encoding="UTF-8" omit-xml-declaration="yes" media-type="text/html"/>
<xsl:template match="/">
<html>
<head>
<title>
<xsl:value-of select="//title[1]"/>
</title>
<link rel="alternate" type="application/rss+xml" title="RSS" href="{/blog/@base}gems/rss.xml"/>
<link rel="stylesheet" type="text/css" href="default.css"/>
</head>
<body>
<div id="header">
<img src="/blog/blogs/images/bloglogo.jpg" alt="OpenLink Virtuoso Blog"/>
<h1>
<xsl:value-of select="/blog/title"/>
</h1>
<xsl:if test="/blog/about != ''">
<h2><xsl:value-of select="/blog/about"/></h2>
</xsl:if>
</div>
<div id="navbartop">
<div>Entries: [ <xsl:call-template name="entrylist"/> ]</div>
</div>
<table id="pagecontainer" cellspacing="10" cellpadding="0" border="0" width="100%">
<tr>
<td class="box">
<div class="box">
<div align="left" class="roll" style="border: none; border">
<div align="center" style="margin-bottom: 3px;">
<b>Personal Details</b>
</div>
<div>
<a>
<xsl:attribute name="href">mailto:<xsl:value-of select="/blog/email" /></xsl:attribute>
<img src="/blog/blogs/images/mailto.gif" border="0" alt="mailto"/>
</a> Contact
</div>
</div>
<div class="roll">
<div align="center" style="margin-bottom: 3px;">
<b>Syndicate This Blog</b>
</div>
<div>
<a href="gems/rss.xml">
<img src="/blog/blogs/images/xml.gif" border="0" alt="rss"/>
RSS</a>
</div>
<div>
<a href="gems/index.rdf">
<img src="/blog/blogs/images/rdf48.gif" border="0" alt="rdf"/>
RDF</a>
</div>
<div>
<a href="gems/index.ocs"><img src="/blog/blogs/images/xml.gif" border="0" alt="ocs"/>OCS</a>
</div>
<div>
<a href="gems/index.opml"><img src="/blog/blogs/images/xml.gif" border="0" alt="opml"/>OPML</a>
</div>
</div>
<div align="left" class="roll">
<p class="caption">Keyword search</p>
<form method="post" action="index.vsp">
<div>
<input type="text" name="txt" value="" size="10"/>
<input type="submit" name="GO" value="GO"/>
</div>
<div>
<input type="radio" name="srch_where" value="blog" checked="checked"/>&#160;My Blog</div>
<div>
<input type="radio" name="srch_where" value="web"/>&#160;The Web</div>
</form>
</div>
<xsl:apply-templates select="/blog/navigation/categories"/>
<div align="left" class="roll">
<xsl:for-each select="/blog/items/last/message">
<div>
<a>
<xsl:attribute name="href">index.vsp?id=<xsl:value-of select="id" /></xsl:attribute>
<xsl:value-of select="title" />
</a>
</div>
</xsl:for-each>
</div>
</div>
</td>
<td id="texttd">
<xsl:apply-templates select="/blog/items"/>
</td>
<td class="box">
<div class="box">
<xsl:apply-templates select="/blog/navigation/calendar"/>
<xsl:apply-templates select="/blog/navigation/blogroll"/>
<xsl:apply-templates select="/blog/navigation/channelroll"/>
<xsl:apply-templates select="/blog/navigation/ocs"/>
<xsl:apply-templates select="/blog/navigation/opml"/>
</div>
</td>
</tr>
</table>
</body>
</html>
</xsl:template>
<xsl:template match="title|navigation"/>
<xsl:template name="entrylist">
<xsl:for-each select="/blog/items/item">
<a href="#{id}">
<xsl:number level="multiple" format=" 1 " count="item"/>
</a>
<xsl:if test="following-sibling::item"> | </xsl:if>
</xsl:for-each>
</xsl:template>
<xsl:template match="items">
<div id="text">
<xsl:if test="/blog/@category-name != ''">
<h3>Category: "<xsl:value-of select="/blog/@category-name"/>"</h3>
</xsl:if>
<xsl:apply-templates select="item"/>
<xsl:if test="/blog/@post != ''">
<div><a name="tb" /><h3>TrackBacks</h3>
<div class="tb-url">TrackBack URL for this entry:<br/><b><xsl:value-of select="/blog/@trackback-url"/><xsl:value-of select="/blog/@post"/></b><br />
PingBack URL for this entry:<br/>
<b><xsl:value-of select="/blog/@pingback-url"/></b>
</div>
<xsl:apply-templates select="trackbacks"/>
</div>
<div><a name="comments" /><h3>Comments</h3>
<xsl:if test="not post-comments">
<div>No comments posted yet</div>
</xsl:if>
<xsl:apply-templates select="post-comments"/>
<div>
<form method="post" action="index.vsp">
<input type="hidden" name="id">
<xsl:attribute name="value"><xsl:value-of select="/blog/@post" /></xsl:attribute>
</input>
<table border="0">
<tr><td>Name</td><td><input type="text" name="name" value="" size="50"/></td></tr>
<tr><td>Email</td><td><input type="text" name="email" value="" size="50"/></td></tr>
<tr><td>Web Site</td><td><input type="text" name="url" value="" size="50"/></td></tr>
<tr><td colspan="2">Comment</td></tr>
<tr><td colspan="2"><textarea name="comment" rows="15" cols="50">&#160;</textarea></td></tr>
<tr><td colspan="2"><input type="submit" name="submit" value="Submit" /></td></tr>
</table>
</form>
</div>
</div>
</xsl:if>
<xsl:choose>
<xsl:when test="not item and @search != ''">
No messages found containing "<xsl:value-of select="@search"/>".
</xsl:when>
<xsl:when test="not item and /blog/@category != ''">
No messages found for category "<xsl:value-of select="/blog/@category-name"/>".
</xsl:when>
<xsl:when test="not item and @search = '' and /blog/@cat = ''">
<div class="message">
This is a placeholder for your new weblog.
There are no posts currently.
</div>
</xsl:when>
</xsl:choose>
<div id="powered">
<a href="http://www.openlinksw.com/virtuoso">
<img src="/blog/blogs/images/PoweredByVirtuoso.gif" border="0" alt="powered by" />
</a>
</div>
<div class="disclaimer">
<xsl:value-of select="/blog/disclaimer" disable-output-escaping="yes" />
</div>
<div class="copy">
<xsl:value-of select="/blog/copy" disable-output-escaping="yes" />
</div>
</div>
</xsl:template>
<xsl:template match="item">
<a name="{id}"/>
<div class="message">
<xsl:apply-templates select="pubDate"/>
<xsl:apply-templates select="description"/>
<xsl:if test="function-available('vb:mt_track_back_discovery')">
<xsl:value-of select="vb:mt_track_back_discovery (id)" disable-output-escaping="yes" />
</xsl:if>
<div class="comment">
<a href="#">
<xsl:attribute name="href">index.vsp?id=<xsl:value-of select="id"/>#comments</xsl:attribute>
Comments [<xsl:value-of select="comments"/>]
</a> | <a href="#">
<xsl:attribute name="href">index.vsp?id=<xsl:value-of select="id"/>#tb</xsl:attribute>
TrackBack [<xsl:value-of select="trackbacks"/>]
</a>
</div>
</div>
</xsl:template>
<xsl:template match="post-comments">
<div class="message">
<xsl:apply-templates select="posted"/>
<a><xsl:attribute name="href"><xsl:value-of select="home"/></xsl:attribute><b><xsl:apply-templates select="name"/></b></a>
<div class="desc">
<xsl:value-of select="vb:tidy_xhtml (comment, '*default*')" disable-output-escaping="yes"/>
</div>
</div>
</xsl:template>
<xsl:template match="trackbacks">
<div class="message">
<xsl:apply-templates select="posted"/>
<a><xsl:attribute name="href"><xsl:value-of select="url"/></xsl:attribute><b><xsl:apply-templates select="blog-name"/></b></a>
<div class="desc">
<b><xsl:apply-templates select="title"/></b>
<xsl:value-of select="vb:tidy_xhtml (excerpt, '*default*')" disable-output-escaping="yes"/>
</div>
</div>
</xsl:template>
<xsl:template match="description">
<div class="desc">
<xsl:choose>
<xsl:when test="function-available('vb:tidy_xhtml')">
<xsl:value-of select="vb:tidy_xhtml (., '*default*')" disable-output-escaping="yes"/>
</xsl:when>
<xsl:otherwise>
<xsl:value-of select="." disable-output-escaping="yes"/>
</xsl:otherwise>
</xsl:choose>
</div>
</xsl:template>
<xsl:template match="pubDate">
<div class="pubdate">
<xsl:value-of select="."/>
</div>
</xsl:template>
<xsl:template match="posted">
<div class="pubdate">
<xsl:value-of select="."/>
</div>
</xsl:template>
<xsl:template match="blogroll">
<div class="roll">
<div align="center">
<b>Blog Roll</b>
</div>
<xsl:apply-templates/>
</div>
</xsl:template>
<xsl:template match="channelroll">
<div class="roll">
<div align="center">
<b>Channel Roll</b>
</div>
<xsl:apply-templates/>
</div>
</xsl:template>
<xsl:template match="opml">
<div class="roll">
<div align="center" style="margin-bottom: 3px;">
<b>OPML Links</b>
</div>
<xsl:for-each select="link">
<a>
<xsl:attribute name="href"><xsl:value-of select="@rss"/></xsl:attribute>
<b>
<xsl:value-of select="blog"/>
</b>
</a>
<div style="margin-left:1em;">
<xsl:apply-templates select="link"/>
</div>
</xsl:for-each>
</div>
</xsl:template>
<xsl:template match="ocs">
<div class="roll">
<div align="center" style="margin-bottom: 3px;">
<b>OCS Links</b>
</div>
<xsl:for-each select="link">
<a>
<xsl:attribute name="href"><xsl:value-of select="@rss"/></xsl:attribute>
<b>
<xsl:value-of select="blog"/>
</b>
</a>
<div style="margin-left:1em;">
<xsl:apply-templates select="link"/>
</div>
</xsl:for-each>
</div>
</xsl:template>
<xsl:template match="categories[category]">
<xsl:variable name="dt" select="concat(//calendar/@year, '-', //calendar/@month, '-', //calendar/@day)"/>
<div class="roll">
<div align="center" style="margin-bottom: 3px;">
<b>Post Categories</b>
</div>
<div>
<a>
<xsl:attribute name="href">index.vsp?date=<xsl:value-of select="$dt"/>&amp;cat=</xsl:attribute>
<b>All</b>
</a>
</div>
<xsl:for-each select="category">
<div>
<a >
<xsl:attribute name="href">/blog/rss_cat.xml?:cid=<xsl:value-of select="@id"/>&amp;:bid=<xsl:value-of select="/blog/title/@blogid"/></xsl:attribute>
<img src="/blog/blogs/images/mxml.gif" border="0" alt="rss"/>
</a>
<a>
<xsl:attribute name="href">index.vsp?date=<xsl:value-of select="$dt"/>&amp;cat=<xsl:value-of select="@id"/></xsl:attribute>
<b>
<xsl:value-of select="@name"/>
</b>
</a>
</div>
</xsl:for-each>
</div>
</xsl:template>
<xsl:template match="link">
<div>
<xsl:if test="@rss != ''">
<a>
<xsl:attribute name="href"><xsl:value-of select="@rss"/></xsl:attribute>
<img src="/blog/blogs/images/mxml.gif" border="0" alt="rss"/>
</a>
</xsl:if>
<a>
<xsl:attribute name="href"><xsl:value-of select="@href"/></xsl:attribute>
<xsl:value-of select="." disable-output-escaping="yes" />
</a>
</div>
</xsl:template>
<xsl:template match="calendar">
<table id="calendar">
<caption>
<xsl:value-of select="@monthname"/>
<xsl:text> </xsl:text>
<xsl:value-of select="@year"/>
</caption>
<tr>
<th>Sun</th>
<th>Mon</th>
<th>Tue</th>
<th>Wed</th>
<th>Thu</th>
<th>Fri</th>
<th>Sat</th>
</tr>
<xsl:apply-templates/>
<tr>
<td colspan="3">
<xsl:if test="@prev != ''">
<a>
<xsl:attribute name="href">index.vsp?date=<xsl:value-of select="@prev"/>&amp;cat=<xsl:value-of select="/blog/@category"/></xsl:attribute>
<xsl:value-of select="@prev-label"/>
</a>
</xsl:if>&#160;
</td>
<td>&#160;</td>
<td colspan="3">
<xsl:if test="@next != ''">
&#160;
<a>
<xsl:attribute name="href">index.vsp?date=<xsl:value-of select="@next"/>&amp;cat=<xsl:value-of select="/blog/@category"/></xsl:attribute>
<xsl:value-of select="@next-label"/>
</a>
</xsl:if>
</td>
</tr>
</table>
</xsl:template>
<xsl:template match="week">
<tr>
<xsl:apply-templates/>
</tr>
</xsl:template>
<xsl:template match="day">
<xsl:variable name="dt" select="concat(ancestor::calendar/@year, '-', ancestor::calendar/@month, '-')"/>
<td>
<xsl:choose>
<xsl:when test="boolean(number(@active))">
<xsl:attribute name="class">calactive</xsl:attribute>
<a>
<xsl:attribute name="href">index.vsp?date=<xsl:value-of select="$dt"/><xsl:value-of select="."/>&amp;cat=<xsl:value-of select="/blog/@category"/></xsl:attribute>
<xsl:apply-templates/>
</a>
</xsl:when>
<xsl:otherwise>
<xsl:apply-templates/>
</xsl:otherwise>
</xsl:choose>
</td>
</xsl:template>
</xsl:stylesheet>
</pre>
</div>
</div>
<p>
The XML Schema for RSS v2.0 file (rss.xml)
</p>
<div>
<pre class="programlisting">
<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">
<xs:element name="channel">
<xs:complexType>
<xs:sequence>
<xs:element ref="title"/>
<xs:element ref="link"/>
<xs:element ref="description"/>
<xs:element ref="managingEditor"/>
<xs:element ref="pubDate"/>
<xs:element ref="generator"/>
<xs:element ref="webMaster"/>
<xs:element ref="image"/>
<xs:element ref="cloud"/>
<xs:element ref="item" maxOccurs="unbounded"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="cloud">
<xs:complexType>
<xs:attribute name="domain" type="xs:string" use="required"/>
<xs:attribute name="port" type="xs:short" use="required"/>
<xs:attribute name="path" type="xs:string" use="required"/>
<xs:attribute name="registerProcedure" type="xs:string" use="required"/>
<xs:attribute name="protocol" type="xs:string" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="comments" type="xs:anyURI"/>
<xs:element name="description" type="xs:string"/>
<xs:element name="generator" type="xs:string"/>
<xs:element name="guid" type="xs:anyURI"/>
<xs:element name="height" type="xs:int"/>
<xs:element name="image">
<xs:complexType>
<xs:sequence>
<xs:element ref="title"/>
<xs:element ref="url"/>
<xs:element ref="link"/>
<xs:element ref="description"/>
<xs:element ref="width"/>
<xs:element ref="height"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="item">
<xs:complexType>
<xs:sequence>
<xs:element ref="title"/>
<xs:element ref="guid"/>
<xs:element ref="comments"/>
<xs:element ref="pubDate"/>
<xs:element ref="description"/>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="link" type="xs:anyURI"/>
<xs:element name="managingEditor" type="xs:string"/>
<xs:element name="pubDate" type="xs:string"/>
<xs:element name="rss">
<xs:complexType>
<xs:sequence>
<xs:element ref="channel" minOccurs="1" maxOccurs="1"/>
</xs:sequence>
<xs:attribute name="version" type="xs:string" use="required" fixed="2.0"/>
</xs:complexType>
</xs:element>
<xs:element name="title" type="xs:string"/>
<xs:element name="url" type="xs:anyURI"/>
<xs:element name="webMaster" type="xs:string"/>
<xs:element name="width" type="xs:int"/>
</xs:schema>
</pre>
</div>
<br />
<br />
<a name="bloggerclientcompatibility" />
<h3>12.7.2. Blogger Clients Compatibility</h3>
<p>The Virtuoso Blog server implementation has been tested against the
following blog client applications:</p>
<ul>
<li>
<a href="http://radio.userland.com/download">Radio Userland</a> (Manila Blogger Bridge tool and Upstreaming), available for MS Windows and MacOS X
</li>
<li>
<a href="http://www.newzcrawler.com/downloads.shtml">NewzCrawler</a>, available for MS Windows
</li>
<li>
<a href="http://wbloggar.com/download/">w.bloggar</a>, available for MS Windows
</li>
<li>
<a href="http://blogbuddy.sourceforge.net/">blogBuddy</a>, available for MS Windows
</li>
<li>
<a href="http://www.zempt.com/download/">Zempt</a>, available for MS Windows
</li>
<li>
<a href="http://www.farook.org/BlogMan.htm">BlogMan</a>, available for MS Windows
</li>
<li>
<a href="http://www.myelin.co.nz/thinblog/">thinblog</a>, Java based client
</li>
</ul>
<p>The steps required to allow third-party clients to operate with Virtuoso are:</p>
<ol>
<li>Create a WebDAV account using the Server Administration Interface
making sure that the home directory is created as /DAV/<username>/</li>
<li>Enable the XML-RPC bridge on a SOAP endpoint (see "XML-RPC
endpoint configuration" section above)</li>
<li>Most client tools accept a username and password, enter the
credentials and URI for XML-RPC endpoint.</li>
<li>Allow the client tool time to refresh the Blog data.</li>
<li>Post a simple message, verify its creating using the Server Administration Interface's Weblog link.</li>
</ol>
<div class="formalpara">
<strong>Interoperability Notes</strong>
<p>The "Zempt" application will report an error upon startup saying that
"mt.supportedTextFilters" are not supported, however it it will continue to work
with the Virtuoso's blogging server.</p>
</div>
<br />
<a name="bloggermanagementui" />
<h3>12.7.3. Blogs Management User Interface</h3>
<p>The Server Administration Interface provides a way to manage existing
blogs. The Blog user interface is accessible from the Web Services >> Weblogs
menu. The page will show existing blogs on the server and will allow you to
erase, edit existing, or make new blog sites. </p>
<p>Blog channels and categories are also configurable from this interface.</p>
<br />
<a name="blogcommunityblog" />
<h3>12.7.4. Community Blog Site</h3>
<p>The community blog site feature pools all blog efforts into one page
providing a blog community portal. No personal blogs are altered,
the community site provides a super-set for all blogs.</p>
<p>The community blog site is activated by enabling blogging capabilities on
the DAV administrator account "dav". This can be achieved at two places,
on the Users Administration interface or the Web Services >> Weblogs interface
in the Server Administration Interface menu.</p>
<br />
<a name="bloggerapi" />
<h3>12.7.5. Blogger API</h3>
<p>The Virtuoso server supports the following methods available via XML-RPC
for Weblog management and operation:</p>
<p>
<a href="">blogger.newPost()</a>
</p>
<p>
<a href="">blogger.editPost()</a>
</p>
<p>
<a href="">blogger.deletePost()</a>
</p>
<p>
<a href="">blogger.getRecentPosts()</a>
</p>
<p>
<a href="">blogger.getUsersBlogs()</a>
</p>
<p>
<a href="">blogger.getTemplate()</a>
</p>
<p>
<a href="">blogger.setTemplate()</a>
</p>
<p>
<a href="">blogger.getUserInfo()</a>
</p>
<div class="note">
<div class="notetitle">Note:</div>
<p>First name is the Movable Type "username" up to the first
space character, and last name is the "username" after the first
space character.</p>
</div>
<br />
<a name="bloggermetaweblog" />
<h3>12.7.6. MetaWeblog API</h3>
<p>
<a href="">metaWeblog.newPost()</a>
</p>
<p>
<a href="">metaWeblog.editPost()</a>
</p>
<p>
<a href="">metaWeblog.getPost()</a>
</p>
<p>
<a href="">metaWeblog.getRecentPosts()</a>
</p>
<br />
<a name="bloggermovabletype" />
<h3>12.7.7. Movable Type API</h3>
<p>
<a href="">mt.getRecentPostTitles()</a>
</p>
<p>
<a href="">mt.getCategoryList()</a>
</p>
<p>
<a href="">mt.setPostCategories()</a>
</p>
<p>
<a href="">mt.getPostCategories()</a>
</p>
<p>
<a href="">mt.getTrackbackPings()</a>
</p>
<p>
<a href="">mt.publishPost()</a>
</p>
<p>
<a href="">mt.supportedMethods()</a>
</p>
<div class="note">
<div class="notetitle">Note:</div>
<p>the value of "appkey" is ignored by Movable Type in all of the
Blogger XML-RPC methods.</p>
</div>
<br />
<a name="blogatomapi" />
<h3>12.7.8. Atom API</h3>
<p>The Atom API is a protocol for publishing and editing a blog entries using
the common HTTP verbs:</p>
<ul>
<li>GET - used to retrieve a blog post or perform query</li>
<li>PUT - used to update an existing blog post</li>
<li>POST - used to create a new post or perform an update action</li>
<li>DELETE - used to remove a post</li>
</ul>
<div class="formalpara">
<strong>Authentication</strong>
<p>The Atom API implementation accepts both HTTP basic and digest
authentication. All requests for post content modification require an
authorization. Furthermore, the account used for authentication is checked to be
the blog owner or have granted privileges on that particular blog.
The retrieval operations; which no post modification is possible are not
required to ask for authentication.</p>
</div>
<div class="formalpara">
<strong>Introspection</strong>
<p>When editing the content of a blog, the first thing is to find out the servers capabilities.
So the 'introspection' file lists all the functions that a given site supports.</p>
</div>
<a name="ex_blogatomintrospection" />
<div class="example">
<div class="exampletitle">Intropsection</div>
<p>Request:</p>
<div>
<pre class="programlisting">
GET /Atom/Http/intro?b=128 HTTP/1.1
Host: localhost:6666
</pre>
</div>
<p>Response:</p>
<div>
<pre class="programlisting">
HTTP/1.1 200 OK
Server: Virtuoso
Connection: Keep-Alive
Date: Mon, 10 Nov 2003 10:21:55 GMT
Content-Type: text/xml; charset="ISO-8859-1"
Content-Length: 417
<?xml version="1.0" encoding="ISO-8859-1"?>
<introspection xmlns="http://example.com/newformat#" >
<create-entry>http://localhost:6666/Atom/Http/entry?b=128</create-entry>
<user-prefs>http://localhost:6666/Atom/Http/prefs?b=128</user-prefs>
<search-entries>http://localhost:6666/Atom/Http/search?b=128</search-entries>
<categories>http://localhost:6666/Atom/Http/categories?b=128</categories>
</introspection>
</pre>
</div>
</div>
<div class="formalpara">
<strong>Posting a new entry</strong>
<p>To post a new entry, the HTTP POST must be performed with
MIME type '<span class="computeroutput">application/x.atom+xml</span>'
for the request content. If server accepts the request a
<span class="computeroutput">Location:</span> HTTP header will be
returned to the client containing the URL to the newly created post.</p>
</div>
<a name="ex_blogatompost" />
<div class="example">
<div class="exampletitle">Posting an Entry</div>
<div>
<pre class="programlisting">
POST /Atom/Http/entry?b=128 HTTP/1.1
Content-Type: application/x.atom+xml
Content-Length: nnn
Authorization: ...
<?xml version="1.0" encoding="iso-8859-1"?>
<entry xmlns="http://example.com/newformat#">
<title>My Entry</title>
<author>
<name>Blog Author</name>
</author>
<issued>2003-11-04T17:29:29</issued>
<content type="application/xhtml+xml" xml:lang="en-us">
<p xmlns="">Hello world!</p>
</content>
</entry>
</pre>
</div>
<p>The response from server would be:</p>
<div>
<pre class="programlisting">
HTTP/1.1 201 Created
Location: http://host:port/Atom/Http/entry?b=128&id=nn
</pre>
</div>
</div>
<div class="formalpara">
<strong>Editing an Existing Entry</strong>
<p>An entry can be edited via the HTTP PUT method.
The URL used for PUT must be one returned by the
<span class="computeroutput">Location:</span> header of the
POST response or those returned from entry-search.
The content of PUT request is same as for posting a new entry.
</p>
</div>
<a name="ex_blogatomedit" />
<div class="example">
<div class="exampletitle">Editing a weblog entry</div>
<div>
<pre class="programlisting">
POST /Atom/Http/entry?b=128&id=nn HTTP/1.1
Content-Type: application/x.atom+xml
Content-Length: nnn
Authorization: ...
<?xml version="1.0" encoding="iso-8859-1"?>
<entry xmlns="http://example.com/newformat#">
<title>My Entry</title>
<author>
<name>Blog Author</name>
</author>
<issued>2003-11-04T17:29:29</issued>
<content type="application/xhtml+xml" xml:lang="en-us">
<p xmlns="">Hello world! (edit test)</p>
</content>
</entry>
</pre>
</div>
<p>The server response is:</p>
<div>
<pre class="programlisting">
HTTP/1.1 205 Reset Content
</pre>
</div>
</div>
<div class="formalpara">
<strong>Retrieving an Entry</strong>
<p>Retrieval of an existing entry is the simple, usual HTTP GET
request with URL to the entry.</p>
</div>
<a name="ex_blogatmgetentry" />
<div class="example">
<div class="exampletitle">Retrieving an Entry</div>
<div>
<pre class="programlisting">
GET /Atom/Http/entry?b=128&id=nn HTTP/1.1
Accept: application/x.atom+xml
</pre>
</div>
<p>Server will respond with </p>
<div>
<pre class="programlisting">
HTTP/1.1 200 OK
Content-Type: application/x.atom+xml
Content-Length: nnn
<?xml version="1.0" encoding="iso-8859-1"?>
<entry xmlns="http://example.com/newformat#">
<title>My Entry</title>
<author>
<name>Blog Author</name>
</author>
<issued>2003-11-04T17:29:29</issued>
<content type="application/xhtml+xml" xml:lang="en-us">
<p xmlns="">Hello world! (edit test)</p>
</content>
</entry>
</pre>
</div>
</div>
<div class="formalpara">
<strong>Deleting an Entry</strong>
<p>To remove permanently an existing entry an HTTP DELETE
method is used with URL to the entry.</p>
</div>
<a name="ex_blogatomdelete" />
<div class="example">
<div class="exampletitle">Deleting an Entry</div>
<div>
<pre class="programlisting">
DELETE /Atom/Http/entry?b=128&id=nn HTTP/1.1
</pre>
</div>
<p>Response:</p>
<div>
<pre class="programlisting">
HTTP/1.1 200 OK
</pre>
</div>
</div>
<div class="formalpara">
<strong>Searching Entries</strong>
<p>To retrieve a subset of messages based some criteria a search
should be performed. The current implementation supports two variants:
range and last_N.</p>
</div>
<a name="ex_blogatomsearch" />
<div class="example">
<div class="exampletitle">Searching</div>
<div>
<pre class="programlisting">
GET /Atom/Http/search?b=128?last=7 HTTP/1.1
Accept: application/x.atom+xml
Host: localhost:6666
Authorization: ...
</pre>
</div>
<p>or </p>
<div>
<pre class="programlisting">
GET /Atom/Http/search?b=128&start-range=2&end-range=27 HTTP/1.1
Accept: application/x.atom+xml
Host: localhost:6666
Authorization: ...
</pre>
</div>
<p>Response from server will look like:</p>
<div>
<pre class="programlisting">
<search-results xmlns="http://example.com/newformat#">
<match title="Classic ASP Framework. Make your Classic...">http://localhost:6666/Atom/Http?b=128&amp;id=6</match>
<match title="DB Navigator - an open source .NET control">http://localhost:6666/Atom/Http?b=128&amp;id=4</match>
<match title="Sort an Array with Non-Comparable Items">http://localhost:6666/Atom/Http?b=128&amp;id=5</match>
<match title="SignedXML Licensing Sample">http://localhost:6666/Atom/Http?b=128&amp;id=7</match>
<match title="TicTacToe">http://localhost:6666/Atom/Http?b=128&amp;id=1</match>
<match title="Check your eMails in Hotmail using HTTPMail">http://localhost:6666/Atom/Http?b=128&amp;id=2</match>
<match title="Slashdot.org RSS Feed Reader">http://localhost:6666/Atom/Http?b=128&amp;id=3</match>
</search-results>
</pre>
</div>
<p>Each sub element of the search result contains the title of the post and its
URL. These URLs can be used retrieved using the GET method, or modified via PUT/DELETE
methods.</p>
</div>
<a name="blogatomclientapi" />
<h4>12.7.8.1. Atom Client API</h4>
<p>The Atom Client API is a mirror of the blogger API functionality,
but uses the Atom protocol instead of XML-RPC. Before the Atom API can
be put to use, the introspection file must be retrieved in order to know
the URLs for the requests.</p>
<ul>
<li>
<p>
<span class="computeroutput">atom.new_Post
(<span class="paramdef">in <span class="parameter">uri</span> varchar</span>,
<span class="paramdef">in <span class="parameter">req</span> "blogRequest"</span>);</span>
</p>
<p>This is to post a new entry to the blog identified by 'uri'.
The 'req' must be initialized with authentication and entry data.
This function returns the URL to the new entry. This could be used with sequential
GET/PUT or DELETE requests for it. </p>
</li>
<li>
<p>
<span class="computeroutput">atom.edit_Post
(<span class="paramdef">in <span class="parameter">uri</span> varchar</span>,
<span class="paramdef">in <span class="parameter">req</span> "blogRequest"</span>);</span>
</p>
<p>This is to modify an existing entry identified by 'uri'.
The 'req' must be initialized with authentication and entry data.
The function returns true on success or will signal an error.</p>
</li>
<li>
<p>
<span class="computeroutput">atom.delete_Post
(<span class="paramdef">in <span class="parameter">uri</span> varchar</span>,
<span class="paramdef">in <span class="parameter">req</span> "blogRequest"</span>);</span>
</p>
<p>This is to delete an existing entry identified by 'uri'.
The 'req' must be initialized with authentication data.
The function returns true on success or will signal an error.</p>
</li>
<li>
<p>
<span class="computeroutput">atom.get_Post
(<span class="paramdef">in <span class="parameter">uri</span> varchar</span>,
<span class="paramdef">in <span class="parameter">req</span> "blogRequest"</span>);</span>
</p>
<p>This is to retrieve an existing post entry identified by 'uri'.
The 'req' must be initialized with authentication data.
This function will return on success an MTWeblogPost UDT, filled with
post entry data.</p>
</li>
<li>
<p>
<span class="computeroutput">atom.get_RecentPosts
(<span class="paramdef">in <span class="parameter">uri</span> varchar</span>,
<span class="paramdef">in <span class="parameter">req</span> "blogRequest"</span>,
<span class="paramdef">in <span class="parameter">num</span> int</span>);</span>
</p>
<p>This is to retrieve last-N post entries identified by blog search URL - 'uri'.
The 'req' must be initialized with authentication data.
'num' is number of entries to return.</p>
<p>This function returns an array of arrays containing the title and URL of the
matching blog posts.</p>
</li>
<li>
<p>
<span class="computeroutput">atom.get_Intro
(<span class="paramdef">in <span class="parameter">uri</span> varchar</span>);</span>
</p>
<p>This is used to return Introspection information for a blog identified by
introspection file - 'uri'.</p>
</li>
</ul>
<a name="ex_blogatomclientapi" />
<div class="example">
<div class="exampletitle">Using the Atom Client API</div>
<p>Getting the introspection info about a blog</p>
<div>
<pre class="programlisting">
declare x any;
x := atom.get_Intro ('http://localhost:6666/Atom/Http/intro?b=128');
-- x will contain
-- (("create-entry" "http://localhost:6666/Atom/Http/entry?b=128" )
-- ("user-prefs"
-- "http://localhost:6666/Atom/Http/prefs?b=128" ) ("search-entries"
-- "http://localhost:6666/Atom/Http/search?b=128" ) ("categories"
-- "http://localhost:6666/Atom/Http/categories?b=128" ) )
</pre>
</div>
<p>make a new entry</p>
<div>
<pre class="programlisting">
declare resp any;
declare req "blogRequest";
declare stru "MTWeblogPost";
req := new "blogRequest" ('', '', '', 'dav', 'dav');
stru := new "MTWeblogPost" ();
stru.title := 'My title'
stru.description := '<p>hello</p>';
req.struct := stru;
resp := atom.new_Post ('http://localhost:6666/Atom/Http/entry?b=128', req);
</pre>
</div>
<p>The response, resp, would contain:
<span class="computeroutput">http://localhost:6666/Atom/Http/entry?b=128&id=1</span>
</p>
<p>edit an entry:</p>
<div>
<pre class="programlisting">
declare resp any;
declare req "blogRequest";
declare stru "MTWeblogPost";
req := new "blogRequest" ('', '', '', 'dav', 'dav');
stru := new "MTWeblogPost" ();
stru.title := 'test'
stru.description := '<p>hello from me</p>';
req.struct := stru;
atom.edit_Post ('http://localhost:6666/Atom/Http/entry?b=128&id=1', req);
</pre>
</div>
<p>delete it:</p>
<div>
<pre class="programlisting">
atom.delete_Post ('http://localhost:6666/Atom/Http/entry?b=128&id=1', req);
</pre>
</div>
</div>
<div class="tip">
<div class="tiptitle">See Also:</div>
<p>
<a href="bitworking.org">http://bitworking.org/rfc/draft-gregorio-07.html</a>
</p>
</div>
<br />
<br />
<a name="bloggerendpointconf" />
<h3>12.7.9. XML-RPC Endpoint Configuration</h3>
<p>The Virtuoso blog server can be contacted directly by SOAP XML-RPC.
A virtual directory can be created with blogger APIs (Blogger, MetaWeblog, MoveableType, Atom) ability,
which requires
a mapping to the SOAP endpoint and grants to use the blogger API.
This can be done in two ways:</p>
<ol>
<li>
<div class="formalpara">
<strong>Using the graphical Server Administration Interface</strong>
<p>You can use your web browser to configure a virtual directory based on the "XML-RPC link"
template and with bloggerAPI enabled:</p>
</div>
<ol>
<li>Open a web browser on the Administration User Interface and navigate to: Internet Domains; HTTP Virtual Directories; Edit URL mappings.</li>
<li>Create a new virtual directory.</li>
<li>Select the template for "XML-RPC link".</li>
<li>Check the option 'bloggerAPI' is enabled, this will expose all available blogger APIs to the endpoint (Blogger, MetaWeblog, MoveableType, Atom).</li>
<li>Configure the logical path.</li>
<li>Click Add to save the definition.</li>
</ol>
<div class="tip">
<div class="tiptitle">See Also:</div>
<p>
<a href="htmlconductorbar.html#httpvirtualdirs">Virtual Directory Administration UI</a>
</p>
<p>
<a href="fn_vhost_define.html">vhost_define()</a>, <a href="fn_vhost_remove.html">vhost_remove()</a>
</p>
</div>
<p>The new logical path now will support XML-RPC and will support blogger API requests.</p>
</li>
<li>
<div class="formalpara">
<strong>Programmatical: Script & ISQL</strong>
<p>This method gives you full control, you must perform all steps to
allow full support for the blogger API on a virtual directory. Below is a
template list of commands that could be in a script.</p>
</div>
<p>Using a script, <span class="computeroutput">blogserver.sql</span>, with following contents:</p>
<div>
<pre class="programlisting">
vhost_define (
lpath=>'/RPC2',
ppath=>'/SOAP/',
soap_user=>'$U{usr}',
soap_opts=>vector ('XML-RPC', 'yes')
);
grant execute on "blogger.newPost" to $U{usr};
grant execute on "blogger.editPost" to $U{usr};
grant execute on "blogger.deletePost" to $U{usr};
grant execute on "blogger.getPost" to $U{usr};
grant execute on "blogger.getRecentPosts" to $U{usr};
grant execute on "blogger.getUsersBlogs" to $U{usr};
grant execute on "blogger.getTemplate" to $U{usr};
grant execute on "blogger.setTemplate" to $U{usr};
grant execute on "blogger.getUserInfo" to $U{usr};
grant execute on "metaWeblog.newPost" to $U{usr};
grant execute on "metaWeblog.editPost" to $U{usr};
grant execute on "metaWeblog.getPost" to $U{usr};
grant execute on "metaWeblog.getRecentPosts" to $U{usr};
grant execute on "mt.getRecentPostTitles" to $U{usr};
grant execute on "mt.getCategoryList" to $U{usr};
grant execute on "mt.setPostCategories" to $U{usr};
grant execute on "mt.getPostCategories" to $U{usr};
grant execute on "mt.getTrackbackPings" to $U{usr};
grant execute on "mt.publishPost" to $U{usr};
grant execute on "mt.supportedMethods" to $U{usr};
</pre>
</div>
<p>One can start ISQL using the following parameters:</p>
<div>
<pre class="programlisting">
$ isql 1111 dba dba -u usr="<SQL user for execution>" blog_server.sql
</pre>
</div>
<p>Where "<SQL user for execution>" is an existing SQL user account other than dba.</p>
<div class="note">
<div class="notetitle">Note:</div>
<p>If you specify the "dba" as user for SOAP execution in a virtual directory,
the grant statements will not be needed and this will open a security hole. So this
approach is not recommended. It is always better to have a separate user for
SOAP execution with limited rights.</p>
</div>
</li>
</ol>
<br />
<a name="bloggerhooks" />
<h3>12.7.10. Blog Hooks - Customizing the Blog Server</h3>
<p>Virtuoso provides the default system for blogging using one of the
supported . Virtuoso
provides several PL hooks to customize the blog server.
The following hooks are available for definition:</p>
<ul>
<li>authenticate_<appkey> (in req blogRequest)</li>
<li>newPost_<appkey> (in req blogRequest)</li>
<li>editPost_<appkey> (in req blogRequest)</li>
<li>deletePost_<appkey> (in req blogRequest)</li>
<li>getPost_<appkey> (in req blogRequest)</li>
<li>getRecentPosts_<appkey> (in req blogRequest, in numberOfPosts int)</li>
</ul>
<div class="tip">
<div class="tiptitle">See Also:</div>
<p>
<a href="xmlrpc.html">XML-RPC section</a>
</p>
</div>
<p>blogRequest is a UDT defined as follows:</p>
<div>
<pre class="programlisting">
create type "blogPost" as (
"content" varchar, -- message
"dateCreated" datetime, -- timestamp
"postid" varchar, -- message ID
"userid" int -- creator
) temporary self as ref
;
create type "blogRequest" under "blogPost"
as
(
user_name varchar, -- user name
passwd varchar, -- credentials
appkey varchar, -- application key
blogid varchar, -- web log ID
postId varchar, -- message ID
auth_userid integer, -- user ID
publish smallint, -- not used, but still in API
struct DB.DBA.MWeblogPost -- used in WebMetaLog
) temporary self as ref
constructor method blogRequest (
appkey varchar,
blogid varchar,
postId varchar,
user_name varchar,
passwd varchar
)
;
</pre>
</div>
<a name="ex_customblog" />
<div class="example">
<div class="exampletitle">Customizing the BLOG Server</div>
<div>
<pre class="programlisting">
-- SIMPLE BLOG APPLICATION
-- application key: 0123456789
--
-- the following UDTs are used in API calls
--
-- single message
-- create type "blogPost" as (
-- "content" varchar,
-- "dateCreated" datetime,
-- "postid" varchar,
-- "userid" int
-- ) temporary self as ref
--
--
-- a blog request
-- create type "blogRequest" under "blogPost"
-- as
-- (
-- user_name varchar,
-- passwd varchar,
-- appkey varchar,
-- blogid varchar,
-- postId varchar,
-- auth_userid integer,
-- publish smallint
-- ) temporary self as ref
--
-- as metaWeblog API not not have appkey, we are assuming 'META_WEBLOG' for it.
drop table BLOG;
create table BLOG (
B_APPKEY varchar,
BLOG_ID varchar,
B_CONTENT long varchar,
B_POST_ID varchar,
B_TS timestamp,
B_USER_ID integer,
primary key (B_APPKEY, BLOG_ID, B_POST_ID)
);
-- APPLICATION LEVEL HOOKS
create procedure authenticate_app (inout req blogRequest)
{
declare pwd varchar;
declare id int;
dbg_obj_print ('auth');
whenever not found goto nf;
select U_PWD, U_ID into pwd, id from WS.WS.SYS_DAV_USER where U_NAME = req.user_name;
if (isstring (pwd))
{
if ((pwd[0] = 0 and pwd_magic_calc (req.user_name, req.passwd) = pwd)
or (pwd[0] <> 0 and pwd = req.passwd))
{
req.auth_userid := id;
return;
}
}
nf:
signal ('42000', 'Access denied');
}
;
create procedure
authenticate_0123456789 (in req blogRequest)
{
authenticate_app (req);
}
;
create procedure
newPost_0123456789 (in req blogRequest)
{
req.postId := cast (sequence_next ('blogger.postid') as varchar);
insert into BLOG (B_APPKEY, BLOG_ID, B_CONTENT, B_POST_ID, B_USER_ID)
values (req.appkey, req.blogid, req.content, req.postId, req.auth_userid);
}
;
create procedure
editPost_0123456789 (in req blogRequest)
{
update BLOG set B_CONTENT = req.content where B_APPKEY = req.appkey and B_POST_ID = req.postId;
}
;
create procedure
deletePost_0123456789 (in req blogRequest)
{
delete from BLOG where B_APPKEY = req.appkey and B_POST_ID = req.postId;
}
;
create procedure
getPost_0123456789 (in req blogRequest)
{
declare content, datecreated, userid any;
declare post blogPost;
whenever not found goto nf;
select sprintf ('%V', blob_to_string (B_CONTENT)), B_TS, B_USER_ID into content, datecreated, userid
from BLOG where B_APPKEY = req.appkey and B_POST_ID = req.postId;
post := new blogPost ();
post."content" := content;
post."dateCreated" := datecreated;
post."postid" := req.postId;
post."userid" := userid;
dbg_obj_print ('getPost', post);
return post;
nf:
signal ('22023', 'Cannot find a post with Id = ' || req.postId);
}
;
create procedure
getRecentPosts_0123456789 (in req blogRequest, in numberOfPosts int)
{
declare ret, elm any;
declare post blogPost;
ret := vector ();
for select sprintf ('%V', blob_to_string (B_CONTENT)) as B_CONTENT, B_TS, B_USER_ID, B_POST_ID
from BLOG where B_APPKEY = req.appkey and BLOG_ID = req.blogId order by B_TS desc do
{
post := new blogPost ();
post."content" := B_CONTENT;
post."dateCreated" := B_TS;
post."postid" := B_POST_ID;
post."userid" := B_USER_ID;
ret := vector_concat (ret, vector (post));
numberOfPosts := numberOfPosts - 1;
if (numberOfPosts <= 0)
goto endg;
}
endg:
return ret;
}
;
</pre>
</div>
</div>
<br />
<a name="bloggerclientapi" />
<h3>12.7.11. Blogger Client API</h3>
<p>
<span class="funcdef">varchar <span class="function">blogger.new_Post
(<span class="paramdef">in <span class="parameter">uri</span>, varchar,
in <span class="parameter">req</span>, "blogRequest",
in <span class="parameter">content</span> varchar</span>);</span>
</span>
</p>
<p>
<span class="funcdef">boolean <span class="function">blogger.delete_Post
(in <span class="parameter">uri</span>, varchar,
in <span class="parameter">req</span> "blogRequest")</span>
</span>
</p>
<p>
<span class="funcdef">boolean <span class="function">blogger.edit_Post
(in <span class="parameter">uri</span>, varchar,
in <span class="parameter">req</span>, "blogRequest",
in <span class="parameter">content</span> varchar)</span>
</span>
</p>
<p>
<span class="funcdef">blogPost <span class="function">blogger.get_Post
(in <span class="parameter">uri</span>, varchar,
in <span class="parameter">req</span> "blogRequest")</span>
</span>
</p>
<p>
<span class="funcdef">vector <span class="function">blogger.get_Recent_Posts
(in <span class="parameter">uri</span>, varchar,
in <span class="parameter">req</span>, "blogRequest",
in <span class="parameter">lim</span> int)</span>
</span>
</p>
<a name="ex_bloggerclient" />
<div class="example">
<div class="exampletitle">The Blogging Client</div>
<p>Create a new message.</p>
<div>
<pre class="programlisting">
SQL> select blogger.new_Post ('http://localhost:6666/RPC2',
blogRequest ('0123456789', 'home', '', 'dav', 'dav'),'test');
callret
VARCHAR
_______________________________________________________________________________
6
1 Rows. -- 267 msec.
</pre>
</div>
<p>Edit a message created with previous step:</p>
<div>
<pre class="programlisting">
SQL> select blogger.edit_Post ('http://localhost:6666/RPC2',
blogRequest ('0123456789', 'home', '6', 'dav', 'dav'), 'test edited');
callret
VARCHAR
_______________________________________________________________________________
1
1 Rows. -- 194 msec.
</pre>
</div>
<p>Get the message, result will be in a blogPost UDT:</p>
<div>
<pre class="programlisting">
SQL> dbg_obj_print (blogger.get_Post ('http://localhost:6666/RPC2',
blogRequest ('0123456789', 'home', '6', 'dav', 'dav')));
Done. -- 120 msec.
</pre>
</div>
<div>
<pre class="programlisting">
---- server console ----
{
REF:[ref:0xa0deb00 obj:0xa1ed168 DB.DBA.blogPost]
content=N"test edited"
dateCreated={ts 2003-04-08 15:34:13.000000}
postid=N"6"
userid=2
}
------------------------
</pre>
</div>
<p>get list of messages, in our case the result will be a vector with one
element of blogPost UDT.</p>
<div>
<pre class="programlisting">
SQL> dbg_obj_print (blogger.get_Recent_Posts ('http://localhost:6666/RPC2', blogRequest ('0123456789', 'home', '', 'dav', 'dav'), 10));
Done. -- 124 msec.
---- server console ----
({
REF:[ref:0xa2426a8 obj:0xa20af40 DB.DBA.blogPost]
content=N"test edited"
dateCreated={ts 2003-04-08 15:34:13.000000}
postid=N"6"
userid=2
}
)
------------------------
<programlisting><![CDATA[
SQL> select blogger.delete_Post ('http://localhost:6666/RPC2',
blogRequest ('0123456789', 'home', '6', 'dav', 'dav'));
callret
VARCHAR
_______________________________________________________________________________
1
1 Rows. -- 337 msec.
</pre>
</div>
</div>
<p>There are more examples on using the API in the tutorials.</p>
<br />
<a name="xmlstoragesystem" />
<h3>12.7.12. xmlStorageSystem API</h3>
<p>xmlStorageSystem is an Web storage system for documents that are
programmable over XML-RPC and SOAP 1.1. Uploaded files are accessible via
HTTP. xmlStorageSystem has methods that allow users to register with the
service; upload a set of files; query the server to find out its capabilities;
and to register a notification request.</p>
<div class="tip">
<div class="tiptitle">See Also:</div>
<p>
<a href="xmlrpc.html">XML-RPC section</a>
</p>
</div>
<p>The API methods are:</p>
<ul>
<li>
<a href="fn_xmlStorageSystem.registerUser.html">xmlStorageSystem.registerUser()</a>
</li>
<li>
<a href="fn_xmlStorageSystem.mailPasswordToUser.html">xmlStorageSystem.mailPasswordToUser()</a>
</li>
<li>
<a href="fn_xmlStorageSystem.getServerCapabilities.html">xmlStorageSystem.getServerCapabilities()</a>
</li>
<li>
<a href="fn_xmlStorageSystem.deleteMultipleFiles.html">xmlStorageSystem.deleteMultipleFiles()</a>
</li>
<li>
<a href="fn_xmlStorageSystem.saveMultipleFiles.html">xmlStorageSystem.saveMultipleFiles()</a>
</li>
<li>
<a href="">xmlStorageSystem.requestNotification()</a>
</li>
</ul>
><a name="xssreltodav" />
<h4>12.7.12.1. Relation to the WebDAV Repository</h4>
<p>The xmlStorageSystem stores uploaded files in the WebDAV repository.
Upon user registration a "blog" sub-folder will be created in the user-account
home directory, into which these files will be uploaded and stored using the
xmlStorageSystem API.</p>
<div class="formalpara">
<strong>Authentication</strong>
<p>The XML Storage System uses WebDAV enabled accounts to authenticate.
The passwords sent via the xmlStorageSystem API (except registerUser,
see below) must be an MD5 hash of the real user password. In this way
clear text password cannot be captured from network sniffers.</p>
</div>
<div class="formalpara">
<strong>Cloud notification services</strong>
<p>
The aggregators scan for changes in an interval, but in some situations we want to know when a channel has changed immediately. Notification makes it possible to always be in sync with bandwidth conservation and unneeded loops.
This is possible to register an aggregator using a xmlStorageSystem.requestNotification function, also to make aggregator to know about such service it's parameters are exposed in <cloud> sub-element of <channel> of the RSS files. The notification works as follows: aggregator gets registered via xmlStorageSystem.requestNotification; Then if a registered link changes, the aggregator will be notified via specified protocol and method. The aggregator needs to register itself every 24 hour, otherwise the registration will expire. For full explanation of the cloud element of RSS file see reference at "http://backend.userland.com/rss#ltcloudgtSubelementOfLtchannelgt".
</p>
</div>
<br />
<a name="xssenabledvirtdir" />
<h4>12.7.12.2. Enabling XML Storage System in a Virtual Directory</h4>
<p>The XML Storage System can be enabled by creating a virtual directory
as a SOAP enabled directory, where the SOAP users is set to DBA or any
other user granted execute permissions to the xmlStorageSystem methods.</p>
<a name="ex_xssvirtdir" />
<div class="example">
<div class="exampletitle">Enabling an xmlStorageSystem Virtual Directory</div>
<p>via ISQL tool:</p>
<div>
<pre class="programlisting">
SQL> vhost_define (lpath=>'/xmlStorageSystem', ppath=>'/SOAP/',
soap_user=>'dba');
</pre>
</div>
</div>
<p>The xmlStorageSystem takes into account the following user options:</p>
<ul>
<li>maxFileSize, integer - maximum file length allowed for upload</li>
<li>maxBytesPerUser, integer - maximum total bytes</li>
</ul>
<p>These are set upon initial registration to 1Mb/40Mb respectively
and can be changed via the Visual Server Administration Interface -> WebDAV ->
WebDAV users -> Options link.</p>
<br />
<br />
<a name="xmlstoragesystem" />
<h3>12.7.13. User's Blog quota</h3>
<p>
In reality blog users are going to consume data space via weblog posts.
For maximum flexibility to blog host administrators the following quotas are
available:
</p>
<p>
"Post Quotas": A maximum number of posts
"Cumulative Post Size": A threshold that is based on a cumulative size of
posts.
These are settable to a user which may do a blog posts via WebDAV - User accounts UI.
</p>
<br />
<a name="xmlstoragesystem" />
<h3>12.7.14. Posting a message in to the Blog</h3>
<p>
To post a message to the blog usually is used various tools implementing a blogger APIs as clients.
These are standalone tools running on a PC or other platform, but not in all cases one have
these tolls on hand. Therefore a web interface is needed. The default home page (index.vspx) implements authentication schema and allows blog owners to post to their blogs. To login to that page blogger should go to the site home page and when supply valid credentials will be authenticated and thus possible to make posts/edit existing etc.
For authenticated user in that case is also possible to change details, settings channel subscriptions.
</p>
<br />
<a name="xmlstoragesystem" />
<h3>12.7.15. Multi-author blogging</h3>
<p>
In many cases many people needs authoring in common blog. For that case
web admin have to create a blog which is owned by "group" (not by web user) and then granting this role to
users which are authors will give them access to post on that blog. As group cannot be authenticated, thus it's not possible to login as group and post on behalf of it; the post's author have to be a valid web user account. This feature does not contradict with possibility authors to have their own blogs, they can have own and post to many "group" blogs.
Granting access to a "group" blog can be done via WebDAV users UI, or with GRANT statement via ISQL tool.
</p>
<br />
<a name="xmlstoragesystem" />
<h3>12.7.16. Posting a comments</h3>
<p>
The blog is a something that one person or group of persons (authors) exposing to the public. So in some cases this material may need commentary from other people than authors. This is a option to the blog settings, when it's enabled (default) the home page of the blog (via permaLink) will offer a post form to make a comment.
When making a comment the author's details can be recorded and re-used based on cookie; comment poster may control that option. Once comment is posted it can be read in same place (permaLink) as in discussion group.
</p>
<br />
<a name="xmlstoragesystem" />
<h3>12.7.17. Blog Post Upstreaming (bridging)</h3>
<p>The blog upstreaming allows bloggers to keep in sync their blogs on different servers.
It is possible for blogger to define a routing target, where his/her posts will be sent
after local post is made, updated or deleted. This feature using blogger APIs (Blogger, MetaWeblog, MovableType)
to pass messages to the remote. Therefore the target server must support one of these APIs.
</p>
<p>The upstreaming works in following manner:</p>
<p>The blogger defines a routing job, which is of type "Upstream".
To do this can be used Weblog Bridge UI following the steps: enter the XML-RPC endpoint, username and password valid there; hit "Fetch" to retrieve blogs on that host where the account can post; select desired account ; specify a time interval for update and which categories of posts to exclude; press "add" button.
</p>
<p>This is is a equivalent of executing a simple insert statement : </p>
<div>
<pre class="programlisting">
SQL> INSERT INTO DB.DBA.SYS_ROUTING
(
R_JOB_ID,
R_TYPE_ID,
R_PROTOCOL_ID,
R_DESTINATION,
R_DESTINATION_ID,
R_AUTH_USER,
R_AUTH_PWD,
R_ITEM_ID,
R_FREQUENCY,
R_EXCEPTION_ID)
VALUES
(
1, -- unique for job
1, -- Upstreaming job
1, -- Blogger API (2 for metaWeblog, 3 from mt)
'http://localhost:80/RPC2', -- target endpoint
'home', -- target BlogID
'visitor', -- user
'secret', -- secret
'128', -- local Blog ID (which to replicate)
60, -- hourly update
'0;1;' -- exclude posts within categories with ID 0 and 1
);
</pre>
</div>
<p>This will make so when post is added/edited/deleted to make entry(es) in SYS_BLOGS_ROUTING_LOG table.
Then on specified R_FREQUENCY a scheduled job will make blogger XML-RPC requests to the target server using API as specified in R_PROTOCOL_ID field.
If target server is down the entries will be kept for next job round.
</p>
<p>The upstreaming feature can be extended easily to make another form of routing. The e-mail notification services in blogging is just one of them.</p>
<p>The following shows how this feature can be triggered with simple insert command:</p>
<div>
<pre class="programlisting">
INSERT INTO DB.DBA.SYS_ROUTING
(R_JOB_ID,R_TYPE_ID,R_PROTOCOL_ID,R_DESTINATION,R_ITEM_ID,R_FREQUENCY,R_EXCEPTION_ID)
VALUES(
2, -- unique for job
2, -- Email notification
4, -- STMP protocol
'mail.domain.com:25', -- mail server
'128', -- local Blog ID
10, -- scan every 10 minutes
'0;1;' -- exclude posts within categories with ID 0 and 1
);
</pre>
</div>
<p>The same can be done via Weblog UI - Notification setup</p>
<br />
<a name="xmlstoragesystem" />
<h3>12.7.18. Weblogs API</h3>
<p>This API consists of "weblogUpdates.ping" XML-RPC call and server-side implementation.</p>
<p>The blog owner may enable weblogs pings as option in the blog settings. Then when it's blog gets updated a ping request will be sent on periodic basis to the "http://rpc.weblogs.com/weblogUpdates" server.</p>
<p>The server also implements weblogUpdates.ping method. If this method is exposed on a XML-RPC enabled endpoint, other parties may use it for notification.
</p>
<p>
The server implementation consist of :
weblogUpdates.ping (in weblogname varchar, in weblogurl varchar, out Result struct). The party sends a ping with blog name and url and receive a common for blogger API response as struct (flError boolean, message varchar).
Also a public accessible http://host:port/blog/weblogs.xml file is available for aggregators to track the latest additions made via Weblogs ping call. Please note that this file generates during on weblog site setup. hence we will have this file only if community blog pages are generated.
</p>
<p>
The weblogs.xml file follows the XMLSchema below:</p>
<div>
<pre class="programlisting">
<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" elementFormDefault="qualified">
<xs:element name="weblog">
<xs:complexType>
<xs:attribute name="name" type="xs:string" use="required"/>
<xs:attribute name="url" type="xs:string" use="required"/>
<xs:attribute name="when" type="xs:int" use="required"/>
</xs:complexType>
</xs:element>
<xs:element name="weblogUpdates">
<xs:complexType>
<xs:sequence>
<xs:element ref="weblog" maxOccurs="unbounded"/>
</xs:sequence>
<xs:attribute name="version" type="xs:string" use="required" fixed="1"/>
<xs:attribute name="updated" type="xs:string" use="required"/>
<xs:attribute name="count" type="xs:int" use="required"/>
</xs:complexType>
</xs:element>
</xs:schema>
</pre>
</div>
<br />
<a name="xmlstoragesystem" />
<h3>12.7.19. Subscriptions</h3>
<p>
Every blogger read and link to it's blog a many other sources, which are usually RSS feeds or other Web content.
As RSS feeds (doesn't matter in which format RSS/RDF) are common practice to offer XML data from blogs, this is
preferable source for most of the bloggers. The utilities for collecting such data are known as aggregators.
</p>
<p>
The blogging support implements a own channel/blog aggregator, so bloggers may import RSS as specifying a
URL to it, or using a directory formats as OCS and OPML. Secondly the channel feeds requested by blogger will be refreshed on a periodic basis (depending of channel parameters) and will feed the data locally. Once the channel is
refreshed a blogger may do "BlogThis!" when browsing the local copy of the channel. This function is available via Admin UI - Weblog UI, or via "Channels" on blog home page when owner is authenticated.
</p>
<br />
<a name="xmlstoragesystem" />
<h3>12.7.20. Trackback API</h3>
<p>
The TrackBack provides a method of notification between websites: it is a method of person A saying to person B, "This is something you may be interested in." To do that, person A sends a TrackBack ping to person B.
TrackBack ping call: this is a small message sent from one webserver to another via HTTP POST or GET.
There are few situations where track back is useful:
*As a form of remote comments rather than posting the comment directly on person B's weblog, person A posts it on his own weblog, then sends a TrackBack ping to notify person B.
*Person A has written a post that group of people are interested in; then it sends a trackback to a community server and there visitors can show it.
</p>
<p>
The implementation consist of :
* the "trackback" method which can be invoked via REST(HTTP POST)
* auto-discovery of the trackback URL in default blog home page
</p>
<p>
trackback (varchar id, varchar url, varchar title, varchar excerpt, varchar blog_name, varchar __mode)
the method can be invoked via REST and returns a XML response.
</p>
<p>
A typical trackback post request look-like as :
</p>
<div>
<pre class="programlisting">
POST /mt-tb/Http/trackback?id=1
Content-Type: application/x-www-form-urlencoded
title=Some+Title&url=http://www.some.domain/&excerpt=An+excerpt&blog_name=foo
</pre>
</div>
<p>
A successful trackback response :
</p>
<div>
<pre class="programlisting">
<?xml version="1.0" encoding="ISO-8859-1"?>
<response>
<error>0</error>
</response>
</pre>
</div>
<p>
When "__mode" parameter is specified via GET request, then trackback method returns
a RSS v0.91 XML data for given post enclosed in response element.
</p>
<p>
A sample request and response follows:
</p>
<div>
<pre class="programlisting">
http://host:port/mt-tb/Http/trackback?id=3&__mode=rss
<response>
<error>0</error>
<rss version="0.91">
<channel>
<title/>
<link> http://.... </link>
<description> Description text .... </description>
</channel>
</rss>
</response>
</pre>
</div>
<br />
<a name="xmlstoragesystem" />
<h3>12.7.21. Pingback API</h3>
<p>
The Pingback is another form of trackback, just protocol and parameters are different.
In Pingback is used XML-RPC instead of REST model. Also the requester sends his own and
target url as part of request.
</p>
<p>
The implementation consists of "pingback.ping" XML-RPC method and auto-discovery
in blog home page.
</p>
<p>
"pingback.ping" (in sourceURI varchar, in targetURI varchar) return varchar
</p>
<p>
The sourceURI is URL for page of requester; targetURI is page on the target server.
The pingback.ping method will retrieve sourceURI and will record the data as trackback
it targetURI exists on same server and it's valid permaLink. On success it returns a
string 'Success' otherwise XML-RPC error code. See also external reference "http://www.hixie.ch/specs/pingback/pingback" .
</p>
<br />
<a name="xmlstoragesystem" />
<h3>12.7.22. E-mail Notifications</h3>
<p>The blog implementation offers a two kind of notifications: notify via e-mail a blog owner when a comment is posted; or one could subscribe to receive blog posts via e-mail. Both notifications are disabled by default and can be turned on using Weblog UI. When this flag is on a scheduled job will send e-mail to the blogger for every new comment posted to the given blog.</p>
<p>The blog owner notification can be turned on as setting BI_COMMENTS_NOTIFY to 1 in table SYS_BLOG_INFO for corresponding blog entry. Other way is to use Weblog settings UI.</p>
<p>If blog owner decide, can define a notification route. To do that he can add a routing job
of type SMTP to the routing table. See "Blog Upstreaming" discussed earlier in this chapter how to do that.
Also it's possible via Weblog settings UI to add such route via "Notification" link.
Note that when define such route , better practice is to designate a category which to be considered as
for subscription.
</p>
<p>
Once such routing job is defined for given blog, users can subscribe and therefore receive e-mails for
posts which blogger assign to a category for notification.
</p>
<br />
<a name="blognotifcomments" />
<h3>12.7.23. Comments tracking options</h3>
<p>
When a blogger enable E-mail Notification for comments on his/her
blog, the following options are available: </p>
<p>HTML - the notification will be sent in HTML format, the message
will contain URLs to the post and comment API. Reply to this
mail will add new comment, if mail-gateway is enabled by Web
administrator.</p>
<p>HTML Form - this option will send an email containing comment and
form, which could be used to invoke directly comment API from mail
agent (if it supports posting a form)</p>
<p>Text - this option is same as first, but uses plain text instead
of HTML encoding.</p>
<p>combined : combines all of the above as attachments.</p>
<br />
<a name="xmlstoragesystem" />
<h3>12.7.24. Subscription Harmonizer API</h3>
<p>Considering situation where blogger have many subscribed channels and wish these to be in sync
on different places it usually subscribe/unsubscribe in home, work public blog.
To be easiest for one to keep all mirrored blog instances (see Upstreaming discussed above) to have
same channel subscription can be used Subscription Harmonizer API.
This API consist of four methods available via XML-RPC , so developers can use them to put in sync
blogger channel subscriptions.
</p>
<p>"subsHarmonizer.setup" (in username varchar, in "password" varchar, in array any)
This is used to setup on server channels which are subscribed locally. The user authenticates
using name and password and sends to server list of RSS URLs in "array" parameter.
This action is usually performed once , on initial subscription.
</p>
<p>"subsHarmonizer.subscribe" (in username varchar, in "password" varchar, in array any)
This is used when in local blog instance blogger makes new subscription(s), the "array" will contains only
entries have been added since last call to that or subsHarmonizer.setup call.
The target server will resolve URL list and will make records in SYS_BLOG_CHANNEL and SYS_BLOG_CHANNEL_INFO tables.
</p>
<p>"subsHarmonizer.unsubscribe" (in username varchar, in "password" varchar, in array any)
This function is opposite of subsHarmonizer.setup , it is used when blogger unsubscribe from some channels.
The server action is to remove channel subscriptions from blog instance. Note that in this case server keeps
channel definition , so it can be re-used when another user get subscribed to it, this is to minimize bandwidth consumption for channel characteristics retrieval.
</p>
<p>All of the above returns boolean.</p>
<p>"subsHarmonizer.startup" (in username varchar, in "password" varchar)
This function is used from blog application to get from server list of
subscriptions which are currently registered. In that case blog application
uses the array of URLs returned to set it's local list of channels.
</p>
<br />
<a name="moblog" />
<h3>12.7.25. Mobile Blogging (Moblog)</h3>
<p>The Mobile blogging (moblog) is synonym of messages containing images made via mobile devices
(such as mobile telephones etc.) with ability to record a image and send them via SMTP.</p>
<p>Moblog''ing has become popular as means for users to easily, automatically and immediately
post text and images back to their blog site what ever their location.</p>
<p>The Virtuoso server can act as mail server (see Storing Email in Virtuoso chapter,
and howto configure mail servers in same chapter). Thus it''s possible to capture
mails sent via mobile devices and expose in a Blog. But main problem remains: SMTP have no
authentication. So this functionality is achieved via UI which shows all existing mail messages
sent via mobile devices and containing a images, allowing to the blog owner to decide which image
to go to his/her blog. As an alternative post can be automatic if blogger check this option. </p>
<p>Mobile blogging (Moblog) can be configured via the Virtuoso blog UI by selecting the
Moblog link under the Configuration section as indicated in the diagram below: </p>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Blog page" src="../images/moblog.gif" />
</td>
</tr>
<tr>
<td>Figure: 12.7.25.1. Blog page</td>
</tr>
</table>
<p>The Moblog configuration page enables the details of the POP3 server from
which messages are to be retrieved from is located as indicated in the diagram below:</p>
<table class="figure" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>
<img alt="Blog page" src="../images/moblogconfig.gif" />
</td>
</tr>
<tr>
<td>Figure: 12.7.25.2. Blog page</td>
</tr>
</table>
<ul>
<li>
<strong>Server Address and Port </strong>- Hostname and port number of the POP3 Mail Server.</li>
<li>
<strong>Account Username</strong> - username of POP3 Mail server account.</li>
<li>
<strong>Account Password </strong>- username of POP3 Mail server account.</li>
<li>
<strong>Enable Automatic Moblogging</strong> - enabled automatic posting of messages to Blog site.</li>
<li>
<strong>Allowed MIME types</strong> - mime type of messages to be retrieved form POP3 server, which can be of type image, vidoe or audio.</li>
<li>
<strong>Set</strong> - this button sets the POP3 mail server setting entered above.</li>
<li>
<strong>Fetch</strong> - this button retrieves available moblog messages from the POP3 mail server.</li>
</ul>
<p>Moblog can handle different types of attachments, this depends of list of MIME type
patterns (SQL like syntax), which blogger specifies in Moblog UI. Further any new incoming
message containing attachment matching any of that list will be exposed in the UI for posting,
or it will be posted automatically if ''Automatic post'' option is checked. </p>
<p>Note: feeding a mail box can also be done via "Mail", "Get Mail with
POP3" Admin UI utility. In this case blogger authenticates in this utility, and feeds
it''s local mailbox from some POP3 server. The consequential actions to put a message
as blog message are same as described above. </p>
<p>As alternative to feeding via own POP3 account, Moblog message can be sent to special
mail-gateway account. Such account can be set from Web admin only and can be used from all
bloggers to pass Moblog messages to their blogs. Only requirement in that case is blogger to
include ''@@blogId@@=[blog Id]'' string as a single line whenever in the
message body. Further mail-gateway processing will detect such rule and will expose the
message in the Moblog UI, or automatic post will be performed. </p>
<br />
<a name="blogxmltemplate" />
<h3>12.7.26. Posting a dynamic content</h3>
<p>
The Virtuoso blogging system allows to insert into a post a result from SQL, XPATH or XQuery expressions.
The way this can be done is to have a SQL access enabled for the Web user making the post,
so such blogger can insert into a post body (note that this is not available for title) a XMLTemplate.
(see "XML Templates" for reference)
Then at the render time the template will be executed on behalf of the blogger who is made the post
and result will be shown. There is no limitation how many XML Templates can be included in a single post.
Please note that bloggers without SQL access cannot do such posts. Also the SQL granting rules
will be applied when XML Template is executed.
</p>
<p>
The following will render a simple table containing list of Demo.demo.Shippers table from Demo database.
</p>
<div>
<pre class="programlisting">
<table border="1">
<sql:query xmlns:sql="urn:schemas-openlink-com:xml-sql" >
select 1 as tag , null as parent, CompanyName as [tr!1!td!element]
from Demo.demo.Shippers
for xml explicit
</sql:query>
</table>
</pre>
</div>
<p>
The following post will render a table containing a names of people
which is organized in simple OPML file (located in the tutorial system)
using XQuery.
(See also the tutorial demo BLOG_QUERY)
</p>
<div>
<pre class="programlisting">
<div>
<sql:xquery xmlns:sql="urn:schemas-openlink-com:xml-sql"
sql:context="http://localhost:8890/tutorial/apps/blog_query/">
<![CDATA[
<table border="1">
{ for $o in document ("opml.xml")//outline
return <tr><td>{ string ($o/@text) }</td></tr>
}
</table>
]]>
</sql:xquery>
</div>
</pre>
</div>
<br />
<a name="blognotifservices" />
<h3>12.7.27. Notification Services</h3>
<p>
This UI is used to define a mail routing job.
So it is used for notification of blog visitors
for post updates. If administrator define a mail
target and refresh interval; visitors to the
given blog can subscribe to the 'mailing list' for
blog updates.
Once visitor have subscribed, on every new post
an email will be sent to he/she.
If the mail is deleted, the mailing list for blog update
notification will be canceled.
</p>
<br />
<a name="blogwaprender" />
<h3>12.7.28. Rendering the RSS feed in WML format</h3>
<p>
The user's blog RSS file could be rendered in WML format
for accessing with mobile devices. To do that
built-in PL post-processing hook for blog virtual directory is
introduced (DB.DBA.BLOG_RSS2WML_PP). It working together with
a XSL-T style-sheet which converts the RSS in WML format.
</p>
<p>
To enable this functionality the blogger should enter '*wml-default*' as
RSSFilter option on settings page. Or if he/she has an own XSL-T
filter for WML can enter its URL instead.
</p>
<p>
The DB.DBA.BLOG_RSS2WML_PP post-processing hook:
</p>
<div>
<pre class="programlisting">
create procedure DB.DBA.BLOG_RSS2WML_PP ()
{
declare accept, upar, pars any;
declare lines any;
lines := http_request_header ();
accept := http_request_header (lines, 'Accept');
if (not isstring (accept))
accept := '';
upar := http_request_get ('QUERY_STRING');
if (regexp_match ('text/vnd\.wap\.wml', accept))
{
if (http_path () like '%/rss.xml')
{
declare opts, filt, bid any;
whenever not found goto exitp;
select top 1 BI_BLOG_ID into bid from SYS_BLOG_INFO where
http_path () like BI_HOME || '%' order by length (BI_HOME) desc;
select deserialize (blob_to_string (BI_OPTIONS)) into opts from SYS_BLOG_INFO where BI_BLOG_ID = bid;
if (not isarray(opts))
opts := vector ();
filt := get_keyword ('RSSFilter', opts, '');
if (filt = '*wml-default*')
filt := 'http://local.virt/rss2wml.xsl';
if (not isstring (filt) or not xslt_is_sheet (filt))
goto exitp;
if (length (upar) = 0)
{
http_xslt (filt);
}
else
{
declare rss, xt, xsl any;
rss := http_get_string_output ();
xt := xml_tree_doc (rss);
http_rewrite ();
xsl := xslt (filt, xt, vector ('id', upar));
http_value (xsl, null);
}
http_header ('Content-Type: text/vnd.wap.wml\r\n');
exitp:;
}
}
return;
}
;
</pre>
</div>
<p>
The rss2wml.xsl style sheet:
</p>
<div>
<pre class="programlisting">
<?xml version='1.0'?>
<xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"
xmlns:vb="http://www.openlinksw.com/weblog/">
<xsl:output method="xml" indent="yes" doctype-public="-//WAPFORUM//DTD WML 1.1//EN" doctype-system="http://www.wapforum.org/DTD/wml_1.1.xml" media-type="text/xml"/>
<xsl:param name="id" />
<xsl:template match="/">
<wml>
<card id="card1">
<xsl:apply-templates />
</card>
</wml>
</xsl:template>
<xsl:template match="item">
<xsl:choose>
<xsl:when test="boolean($id!='')">
<xsl:if test="substring-after(link,'?') = $id">
<p>
<xsl:value-of select="vb:tidy_xhtml (string (description), '*default*')"
disable-output-escaping="yes"/>
<br/>
<xsl:if test="preceding-sibling::item">
<a>
<xsl:attribute name="href">rss.xml?<xsl:value-of select="substring-after(preceding-sibling::item/link,'?')"/></xsl:attribute>PREVIOUS</a><br />
</xsl:if>
<xsl:if test="following-sibling::item">
<a>
<xsl:attribute name="href">rss.xml?<xsl:value-of select="substring-after(following-sibling::item/link,'?')"/></xsl:attribute>NEXT</a>
</xsl:if>
</p>
</xsl:if>
</xsl:when>
<xsl:otherwise>
<p>
<a>
<xsl:attribute name="href">rss.xml?<xsl:value-of select="substring-after(link,'?')"/></xsl:attribute>
<xsl:value-of select="title"/>
</a>
</p>
</xsl:otherwise>
</xsl:choose>
</xsl:template>
<xsl:template match="text()"/>
</xsl:stylesheet>
</pre>
</div>
<br />
<table border="0" width="90%" id="navbarbottom">
<tr>
<td align="left" width="33%">
<a href="asmxhosting.html" title="ASMX Web Service Hosting">Previous</a>
<br />ASMX Web Service Hosting</td>
<td align="center" width="34%">
<a href="webappdevelopment.html">Chapter Contents</a>
</td>
<td align="right" width="33%">
<a href="servphpext.html" title="Deploying PHP Applications">Next</a>
<br />Deploying PHP Applications</td>
</tr>
</table>
</div>
<div id="footer">
<div>Copyright© 1999 - 2009 OpenLink Software All rights reserved.</div>
<div id="validation">
<a href="http://validator.w3.org/check/referer">
<img src="http://www.w3.org/Icons/valid-xhtml10" alt="Valid XHTML 1.0!" height="31" width="88" />
</a>
<a href="http://jigsaw.w3.org/css-validator/">
<img src="http://jigsaw.w3.org/css-validator/images/vcss" alt="Valid CSS!" height="31" width="88" />
</a>
</div>
</div>
</body>
</html>
distrib
>
Fedora
>
14
>
x86_64
>
media
>
updates
>
by-pkgid
>
71d40963b505df4524269198e237b3e3
>
files
>
64
