</verbs>
<body>
<Enumerate key="topic" table="topic" limit="_topics">
- <Define key="docSuffix" value=".shtml"/>
- <Define key="storageSuffix" value=".shtml"/>
+ <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}"
</verbs>
<body>
<Set key="whichnewswire" value="Open Publishing News" />
- <List key="newswire" table="content" limit="30"
+ <List key="newswire" table="content" limit="20"
selection="is_published=true and to_article_type=${articletype.newswire}"
order="webdb_create desc"/>
<Language>
</verbs>
<body>
<Set key="whichnewswire" value="RSS Publishing News" />
- <List key="newswire" table="content" limit="30"
+ <List key="newswire" table="content" limit="20"
selection="is_published=true and to_article_type=${articletype.communityrssarticle}"
order="webdb_create desc"/>
<Language>
</verbs>
<body>
- <List key="startspecial" table="content" limit="2"
+ <List key="startspecial" table="content" limit="1"
selection="is_published=true and to_article_type=${articletype.startspecial}"
order="webdb_create desc"/>
- <List key="features" table="content" limit="10"
+ <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"/>
selection="is_published=true and to_article_type in (${articletype.communityrssarticle},${articletype.promotedcommunityarticle})"
order="webdb_create desc"/>
- <List key="newswire" table="content" limit="30"
+ <List key="newswire" table="content" limit="20"
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"
- limit="5"
+ limit="3"
/>
<Set key="counter" value="1"/>
<Enumerate key="category" table="topic t" extratables="topic t2"
- selection="t.id=t2.id AND t.archiv_url = 'Category' AND (SELECT count(*) from content_x_topic where topic_id = t.id) > 0" order="RANDOM()" limit="10">
+ selection="t.id=t2.id AND t.archiv_url = 'Category' AND (SELECT count(*) from content_x_topic where topic_id = t.id) > 0" order="RANDOM()" limit="20">
<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"
- limit="5" />
+ limit="1" />
<Generate
generator="/randomcategory.template"