<Enumerate
key="media" table="otherMedia"
selection="exists (select * from content_x_media where media_id=other_media.id and content_id=${article.id})
<Enumerate
key="media" table="otherMedia"
selection="exists (select * from content_x_media where media_id=other_media.id and content_id=${article.id})
+
+ <List key="topics" table="topic t" extratables="content_x_topic ctx"
+ selection="ctx.content_id = ${article.id} AND ctx.topic_id = t.id" />
+ <If condition="utility.listSize(topics) > 0">
+ <then>
+ <Log message="I have a topic list with ${utility.listSize(topics)}" />
+ </then>
+ </If>
<Batch key="articles" infokey="batch" table="content"
process="pages" batchsize="20" minbatchsize="10"
<Batch key="articles" infokey="batch" table="content"
process="pages" batchsize="20" minbatchsize="10"
<Batch key="articles" infokey="batch" table="content"
process="pages" batchsize="20" minbatchsize="10"
<Batch key="articles" infokey="batch" table="content"
process="pages" batchsize="20" minbatchsize="10"
- <Enumerate key="topic" table="topic" limit="_topics">
- <Define key="docSuffix" value=".shtml"/>
- <Define key="storageSuffix" value=".shtml"/>
+ <Enumerate key="topic" table="topic">
+ <Define key="docSuffix" value=".html"/>
+ <Define key="storageSuffix" value=".html"/>
<List key="special" table="content c"
selection="c.is_published='1' and c.to_article_type = ${articletype.topicspecial} and c.id=cxt.content_id and cxt.topic_id = ${topic.id}"
order = "webdb_create desc" limit="1"
<List key="special" table="content c"
selection="c.is_published='1' and c.to_article_type = ${articletype.topicspecial} and c.id=cxt.content_id and cxt.topic_id = ${topic.id}"
order = "webdb_create desc" limit="1"
<Define key="pagePrefix" value="${pathprefix}/${topic.filename}/archive"/>
<Define key="storagePrefix" value="${config["Producer.StorageRoot"]}/${pagePrefix}"/>
<Define key="docPrefix" value="${config["Producer.DocRoot"]}/${pagePrefix}"/>
<Define key="pagePrefix" value="${pathprefix}/${topic.filename}/archive"/>
<Define key="storagePrefix" value="${config["Producer.StorageRoot"]}/${pagePrefix}"/>
<Define key="docPrefix" value="${config["Producer.DocRoot"]}/${pagePrefix}"/>
selection="is_published=true and to_article_type=${articletype.newswire}"
order="webdb_create desc"/>
<Language>
<Generate
generator="/newswireinclude.template"
selection="is_published=true and to_article_type=${articletype.newswire}"
order="webdb_create desc"/>
<Language>
<Generate
generator="/newswireinclude.template"
selection="is_published=true and to_article_type=${articletype.communityrssarticle}"
order="webdb_create desc"/>
<Language>
<Generate
generator="/newswireinclude.template"
selection="is_published=true and to_article_type=${articletype.communityrssarticle}"
order="webdb_create desc"/>
<Language>
<Generate
generator="/newswireinclude.template"
selection="is_published=true and to_article_type=${articletype.startspecial}"
order="webdb_create desc"/>
selection="is_published=true and to_article_type=${articletype.startspecial}"
order="webdb_create desc"/>
selection="is_published=true and to_article_type in (${articletype.feature},${articletype.promotedcommunityarticle},${articletype.promotednewswire})"
order="webdb_create desc"/>
selection="is_published=true and to_article_type in (${articletype.feature},${articletype.promotedcommunityarticle},${articletype.promotednewswire})"
order="webdb_create desc"/>
selection="is_published=true and to_article_type in (${articletype.communityrssarticle},${articletype.promotedcommunityarticle})"
order="webdb_create desc"/>
selection="is_published=true and to_article_type in (${articletype.communityrssarticle},${articletype.promotedcommunityarticle})"
order="webdb_create desc"/>
selection="is_published=true and to_article_type=${articletype.newswire}"
order="webdb_create desc"/>
selection="is_published=true and to_article_type=${articletype.newswire}"
order="webdb_create desc"/>
c.comment,c.source,c.is_published,c.is_produced,c.to_publisher,c.to_language,c.to_rights,c.webdb_create,c.webdb_lastchange,
c.content_data,c.is_html,c.to_article_type,c.to_content,c.keywords,c.to_locking_user"
order="count(cm.id) desc"
c.comment,c.source,c.is_published,c.is_produced,c.to_publisher,c.to_language,c.to_rights,c.webdb_create,c.webdb_lastchange,
c.content_data,c.is_html,c.to_article_type,c.to_content,c.keywords,c.to_locking_user"
order="count(cm.id) desc"
<Enumerate key="fpimage" table="image" selection="to_media_folder=8 and is_published=true" >
<Log message="generating include for image id: ${fpimage.id}" type="info" />
<Generate
generator="/fpinclude.template"
destination="${config.storageRoot}/fpincludes/${fpimage.id}.inc" />
<Enumerate key="fpimage" table="image" selection="to_media_folder=8 and is_published=true" >
<Log message="generating include for image id: ${fpimage.id}" type="info" />
<Generate
generator="/fpinclude.template"
destination="${config.storageRoot}/fpincludes/${fpimage.id}.inc" />
as x ON (t.id=x.topic_id) LEFT OUTER JOIN content as c ON (c.id=x.content_id)
WHERE t.archiv_url = 'Category' GROUP BY t.title ORDER BY length(t.title)"
type="set"/>
as x ON (t.id=x.topic_id) LEFT OUTER JOIN content as c ON (c.id=x.content_id)
WHERE t.archiv_url = 'Category' GROUP BY t.title ORDER BY length(t.title)"
type="set"/>
<Log message="Getting Last 5 articles for category: ${category.title} - counter: ${counter}" />
<Define key="topictitle" value="${category.title}" />
<Log message="Getting Last 5 articles for category: ${category.title} - counter: ${counter}" />
<Define key="topictitle" value="${category.title}" />
<List key="randomarticles" table="content"
selection ="id in (select content_id from content_x_topic where topic_id = ${category.id})" order="date DESC"
<List key="randomarticles" table="content"
selection ="id in (select content_id from content_x_topic where topic_id = ${category.id})" order="date DESC"
<Generate
generator="/randomcategory.template"
destination="${config.storageRoot}/fpincludes/random${counter}.inc" />
<Generate
generator="/randomcategory.template"
destination="${config.storageRoot}/fpincludes/random${counter}.inc" />
+ <producer name="footer">
+ <verbs>
+ <verb name="generate" default="1" description="generates the default footer"/>
+ </verbs>
+ <body>
+ <Language>
+ <Generate
+ generator="/footer.template"
+ destination="${config.storageRoot}/${pathprefix}/footer.inc"/>
+ </Language>
+ </body>
+ </producer>