<!--
- This XML file defines a set of producers intended for a typical indymedia
- site:
+ This XML file defines a set of producers intended for a typical indymedia site:
- a start page
- a navigational bar
- topic pages
<producer name="articles">
<verbs>
<verb name="changed" default="1">
- <Define key="verbcondition" value="(not is_produced)"/>
+ <Define key="verbcondition" value="(not is_produced) and to_article_type != ${articletype.static}"/>
<Set key="limit" value="10"/>
</verb>
<verb name="all">
- <Define key="verbcondition" value=""/>
+ <Define key="verbcondition" value="to_article_type != ${articletype.static}"/>
<Set key="limit" value="-1"/>
</verb>
<verb name="sample">
- <Define key="verbcondition" value=""/>
+ <Define key="verbcondition" value="to_article_type != ${articletype.static}"/>
<Set key="limit" value="10"/>
</verb>
+
+ <verb name="test" >
+ <Define key="verbcondition" value="(id>=5000 and id<7500 ) and to_article_type != ${articletype.static}"/>
+ <Set key="limit" value="2500"/>
+ </verb>
+
+
</verbs>
<body>
<Enumerate key="article" table="content" selection="${verbcondition}"
<producer name="staticpages">
<verbs>
<verb name="changed" default="1">
- <Define key="verbcondition" value="(not is_produced)"/>
+ <Define key="verbcondition" value="(not is_produced) and to_article_type = ${articletype.static}"/>
<Set key="limit" value="10"/>
</verb>
<verb name="all">
- <Define key="verbcondition" value=""/>
+ <Define key="verbcondition" value="to_article_type = ${articletype.static}"/>
<Set key="limit" value="-1"/>
</verb>
</verbs>
<body>
- <Enumerate key="article" table="content" selection="${verbcondition} and to_article_type = ${articletype.static}"
+ <Enumerate key="article" table="content" selection="${verbcondition}"
limit="limit" order="webdb_create desc">
<Enumerate
key="media" table="image"
<GenerateMedia key="media" />
</Enumerate>
+ <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="article.is_published == '1'">
<then>
generator="/article.template"
destination="${config.storageRoot}/${pathprefix}/static/${article.edittitle}.html"/>
</Language>
+
<Generate
generator="/languagebar.template"
destination="${config.storageRoot}/languagebar/${article.to_original.date.formatted.yyyy}/${article.to_original.date.formatted.MM}/${article.to_original.id}.html"/>
</verbs>
<body>
<Set key="whichnewswire" value="Open Publishing News" />
- <List key="newswire" table="content" limit="20"
+ <List key="newswire" table="content" limit="50"
selection="is_published=true and to_article_type=${articletype.newswire}"
order="webdb_create desc"/>
<Language>
selection="is_published=true and to_article_type=${articletype.startspecial}"
order="webdb_create desc"/>
- <List key="features" table="content" limit="4"
+ <List key="features" table="content" limit="5"
selection="is_published=true and to_article_type in (${articletype.feature},${articletype.promotedcommunityarticle},${articletype.promotednewswire})"
order="webdb_create desc"/>
<List key="mostcomments"
table="content c"
extratables="comment cm"
- selection="c.webdb_create > NOW()-'2 years'::interval and c.is_published=true and c.id=cm.to_media group by c.id,c.title,
+ selection="c.webdb_create > NOW()-'1 week'::interval and c.is_published=true and cm.is_published=true and c.id=cm.to_media group by c.id,c.title,
c.subtitle,c.edittitle,c.date,c.creator,c.creator_main_url,c.creator_email,c.creator_address,c.creator_phone,c.description,
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"
+ order="count(cm.id) desc, c.webdb_create desc "
limit="3"
/>
<Define key="topicfile" value="${category.filename}" />
<List key="randomarticles" table="content"
- selection ="id in (select content_id from content_x_topic where topic_id = ${category.id})" order="date DESC"
+ selection ="id in (select content_id from content_x_topic where topic_id = ${category.id}) AND is_published=true" order="date DESC"
limit="3" />
<Language>
<Generate