-
<!--
This XML file defines a set of producers intended for a typical indymedia
site:
<Set key="origin" value="item.identifier"/>
</else>
</If>
+
+
<If condition="item['dcterms:hasPart']">
<then>
key="article"
table="content"
- date="config.now.formatted.yyyymmdd"
+ date="utility.datetime.formatDate(item['dc:date'], 'yyyyMMdd')"
publish_path="' '"
to_publisher="'0'"
is_produced="'0'"
description="haspartimg++item['rss:description']++' '"
to_language="languageCodeToId(languagecode)"
title="item['rss:title']++''"
- webdb_create="config.now"
+ webdb_create="item['dc:date']"
creator="blogname"
comment="'Taken from ' ++ blogname"
/>
</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"/>
+ <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,
+ 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"
+ limit="3"
+ />
+
+
<List key="breakingnews" table="breakingNews" limit="10"
order="webdb_create desc"/>
<Language>
<Generate
generator="/startpage.template"
- destination="${config.storageRoot}/${pathprefix}/index.shtml"/>
+ destination="${config.storageRoot}/${pathprefix}/index.html"/>
</Language>
</body>
</producer>
</body>
</producer>
+
+
+
+
+ <producer name="generatefpincludes">
+ <verbs>
+ <verb name="doit" />
+ </verbs>
+ <body>
+
+ <Set key="counter" value="1"/>
+ <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" />
+ <Set key="counter" value="counter+1" />
+ </Enumerate>
+
+
+ <List key="fpincludes" table="image" selection="to_media_folder=8 and is_published=true" />
+ <Generate
+ generator="/fpmapping.template"
+ destination="${config.storageRoot}/fpincludes/map.txt" />
+
+ </body>
+ </producer>
+
+
+
+
+ <!-- generates a count for each topic -->
+
+ <!-- TODO: add date limit when we actually are going live with this -->
+ <producer name="generateTopicCounts">
+ <verbs>
+ <verb name="doit" />
+ </verbs>
+ <body>
+ <FreeQuery key="topicCounts" query=" SELECT count(x.content_id) as count, t.title FROM topic as t LEFT OUTER JOIN content_x_topic
+ 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"/>
+
+ <Generate generator="/topiccount.template"
+ destination="${config.storageRoot}/${pathprefix}/topiccount.shtml" />
+ </body>
+ </producer>
+
+
+
+ <producer name="generateRandomTopics">
+ <verbs>
+ <verb name="doit" />
+ </verbs>
+ <body>
+ <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="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="1" />
+
+ <Generate
+ generator="/randomcategory.template"
+ destination="${config.storageRoot}/fpincludes/random${counter}.inc" />
+
+
+ <Set key="counter" value="counter+1" />
+ </Enumerate>
+ </body>
+ </producer>
+
<producer name="getlocalblogs">
<verbs>
<verb name="doit" />