etc/producer/producers.xml

   1 <!--
   2   This XML file defines a set of producers intended for a typical indymedia site:
   3     - a start page
   4     - a navigational bar
   5     - topic pages
   6     - a newswire archive
   7     - a feature archive
   8     - articles
   9     - media
  10 -->
  11
  12 <producers>
  13   <nodedefinition name="Language">
  14     <parameters>
  15       <string name="languagecondition" defaultvalue="code != 'ot'"/>
  16       <string name="bundle" defaultvalue="bundles.producer" />
  17       <node name="sub"/>
  18     </parameters>
  19
  20     <definition>
  21       <List key="languages" table="language" selection="${languagecondition}" order="code"/>
  22       <Enumerate key="language" table="language" selection="${languagecondition}" order="code">
  23         <Resource bundle="${bundle}" key="lang" language="${language.code}"/>
  24         <Define key="pathprefix" value="${language.code}" />
  25         <Define key="languagepreference" value="${language.code}" />
  26         <sub/>
  27         <If condition="language.code=='en'">
  28           <then>
  29             <Define key="pathprefix" value="or" />
  30             <Define key="languagepreference" value="" />
  31             <sub/>
  32           </then>
  33         </If>
  34       </Enumerate>
  35     </definition>
  36   </nodedefinition>
  37
  38 <nodedefinition name="Pull">
  39     <parameters>
  40       <string name="url"/>
  41       <string name="blogname"/>
  42       <string name="blogurl"/>
  43       <string name="articletype"/>
  44     </parameters>
  45
  46     <definition>
  47       <Log message="Pulling 1.0 feed from ${blogname} at ${url}" type="info" />
  48       <RSS key="feeditems" url="${url}" encoding="UTF-8" />
  49       <Enumerate key="item" list="feeditems['rss:item']" >
  50         <Define key="languagecode" value="ot" />
  51         <If condition="item['dc:language']">
  52           <then>
  53             <Set key="languagecode" value="item['dc:language']"/>
  54           </then>
  55         </If>
  56
  57         <If condition="item['dc:source']">
  58           <then>
  59             <Set key="origin" value="item['dc:source']"/>
  60           </then>
  61           <else>
  62             <Set key="origin" value="item.identifier"/>
  63           </else>
  64         </If>
  65
  66
  67
  68         <If condition="item['dcterms:hasPart']">
  69           <then>
  70             <Set key="haspartimg" value="'&lt;img align=&quot;right&quot; src=&quot;'++item['dcterms:hasPart'] ++'&quot; /&gt;' " />
  71           </then>
  72           <else>
  73             <Set key="haspartimg" value="' '" />
  74           </else>
  75         </If>
  76
  77         <Set key="present" value="0" />
  78         <Enumerate
  79           key="article"
  80           table="content"
  81           selection="source='${utility.escapeJDBCString(origin)}'" limit="1">
  82           <Set key="present" value="1" />
  83         </Enumerate>
  84         <If condition="present==0">
  85           <then>
  86             <Log message="  new entry from ${blogname}: ${item['rss:title']}" type="info" />
  87              <CreateEntity
  88                key="article"
  89                table="content"
  90
  91                date="utility.datetime.formatDate(item['dc:date'], 'yyyyMMdd')"
  92                publish_path="' '"
  93                to_publisher="'0'"
  94                is_produced="'0'"
  95                is_published="'1'"
  96                is_html="'1'"
  97
  98                source="origin"
  99                to_article_type="articletype"
 100
 101                content_data="item['content:encoded']++' '"
 102                creator_main_url="blogurl"
 103                description="haspartimg++item['rss:description']++' '"
 104                to_language="languageCodeToId(languagecode)"
 105                title="item['rss:title']++''"
 106                webdb_create="item['dc:date']"
 107                creator="blogname"
 108                comment="'Taken from ' ++ blogname"
 109              />
 110           </then>
 111         </If>
 112       </Enumerate>
 113     </definition>
 114   </nodedefinition>
 115
 116
 117   <nodedefinition name="RSSChannel">
 118     <parameters>
 119       <string name="articleSelection"/>
 120       <string name="extratables" defaultvalue="none" />
 121       <integer name="limit" defaultvalue="15"/>
 122       <string name="channelidentifier" defaultvalue=""/>
 123       <string name="channelfilename"/>
 124       <string name="channeltitle"/>
 125       <string name="articleprefix" defaultvalue="${config['Producer.PublicationHost']}/or" />
 126       <string name="iconprefix" defaultvalue="${config['Producer.PublicationHost']}/icon" />
 127       <string name="channelpublisher" defaultvalue="${config['Mir.Name']}" />
 128       <string name="encoding" defaultvalue="UTF-8" />
 129       <string name="channeldescription" defaultvalue=""/>
 130       <string name="generator" defaultvalue="/RSS.template" />
 131     </parameters>
 132
 133     <definition>
 134       <If condition="extratables == 'none' ">
 135         <then>
 136           <List key="articles" table="content c" selection="${articleSelection}" order = "c.webdb_create desc, c.date desc" limit="limit" />
 137         </then>
 138         <else>
 139           <List key="articles" table="content c" selection="${articleSelection}" order = "c.webdb_create desc, c.date desc" limit="limit" extratables="${extratables}" />
 140         </else>
 141       </If>
 142       <If condition="channeldescription==''">
 143         <then>
 144           <Define key="channeldescription" value="${channeltitle}"/>
 145         </then>
 146       </If>
 147       <If condition="channelidentifier==''">
 148         <then>
 149           <Define key="channelidentifier" value="${config['Producer.PublicationHost']}/or/${channelfilename}"/>
 150         </then>
 151       </If>
 152
 153       <Generate
 154          parameters="${encoding}"
 155          generator="${generator}"
 156          destination="${config.storageRoot}/${channelfilename}"/>
 157     </definition>
 158   </nodedefinition>
 159
 160   <nodedefinition name="RSSChannelBundle">
 161     <parameters>
 162       <string name="extratables" defaultvalue="none" />
 163       <string name="selection" defaultvalue="c.is_published='1'" />
 164       <string name="basefilename" defaultvalue="main" />
 165     </parameters>
 166     <definition>
 167       <!-- newswire -->
 168       <RSSChannel
 169         articleSelection="(c.to_article_type in (${articletype.newswire}) or (c.to_article_type=${articletype.translation} and c.to_original.to_articletype in (${articletype.newswire}))) and ${selection}"
 170         channelfilename="${basefilename}-newswire.rss"
 171         channeltitle="${config['Mir.Name']} ${basefilename} newswire"
 172         limit="20"
 173         extratables="${extratables}"
 174       />
 175       <RSSChannel
 176         articleSelection="(c.to_article_type in (${articletype.newswire}) or (c.to_article_type=${articletype.translation} and c.to_original.to_articletype in (${articletype.newsire}))) and ${selection}"
 177         channelfilename="${basefilename}-newswire-content.rss"
 178         channeltitle="${config['Mir.Name']} ${basefilename} newswire"
 179         limit="20"
 180         generator="RSS-full.template"
 181         extratables="${extratables}"
 182       />
 183       <!-- features -->
 184       <RSSChannel
 185         articleSelection="(c.to_article_type in (${articletype.feature},${articletype.startspecial},${articletype.topicspecial}) or (c.to_article_type=${articletype.translation} and c.to_original.to_articletype in (${articletype.feature},${articletype.startspecial},${articletype.topicspecial}))) and ${selection}"
 186         channelfilename="${basefilename}-features.rss"
 187         channeltitle="${config['Mir.Name']} ${basefilename} features"
 188         limit="20"
 189         extratables="${extratables}"
 190       />
 191       <RSSChannel
 192         articleSelection="(c.to_article_type in (${articletype.feature},${articletype.startspecial},${articletype.topicspecial}) or (c.to_article_type=${articletype.translation} and c.to_original.to_articletype in (${articletype.feature},${articletype.startspecial},${articletype.topicspecial}))) and ${selection}"
 193         channelfilename="${basefilename}-features-content.rss"
 194         channeltitle="${config['Mir.Name']} ${basefilename} features"
 195         limit="20"
 196         generator="RSS-full.template"
 197         extratables="${extratables}"
 198       />
 199     </definition>
 200   </nodedefinition>
 201
 202
 203   <producer name="articles">
 204     <verbs>
 205       <verb name="changed" default="1">
 206         <Define key="verbcondition" value="(not is_produced) and to_article_type != ${articletype.static}"/>
 207         <Set key="limit" value="10"/>
 208       </verb>
 209       <verb name="all">
 210         <Define key="verbcondition" value="to_article_type != ${articletype.static}"/>
 211         <Set key="limit" value="-1"/>
 212       </verb>
 213
 214       <verb name="sample">
 215         <Define key="verbcondition" value="to_article_type != ${articletype.static}"/>
 216         <Set key="limit" value="10"/>
 217       </verb>
 218
 219       <verb name="test" >
 220         <Define key="verbcondition" value="(id&gt;=5000 and id&lt;7500 ) and to_article_type != ${articletype.static}"/>
 221         <Set key="limit" value="2500"/>
 222       </verb>
 223
 224
 225     </verbs>
 226     <body>
 227       <Enumerate key="article" table="content" selection="${verbcondition}"
 228                   limit="limit" order="webdb_create desc">
 229         <Enumerate
 230             key="media" table="image"
 231             selection="exists (select * from content_x_media where media_id=images.id and content_id=${article.id})
 232                or      exists (select * from comment_x_media, comment
 233                            where comment_id = comment.id and media_id=images.id and comment.to_media=${article.id})"
 234             order="id desc">
 235
 236            <GenerateMedia key="media" />
 237         </Enumerate>
 238         <Enumerate
 239             key="media" table="video"
 240             selection="exists (select * from content_x_media where media_id=video.id and content_id=${article.id})
 241                or      exists (select * from comment_x_media, comment
 242                            where comment_id = comment.id and media_id=video.id and comment.to_media=${article.id})"
 243             order="id desc">
 244            <GenerateMedia key="media" />
 245         </Enumerate>
 246         <Enumerate
 247             key="media" table="audio"
 248             selection="exists (select * from content_x_media where media_id=audio.id and content_id=${article.id})
 249                or      exists (select * from comment_x_media, comment
 250                                        where comment_id = comment.id and media_id=audio.id and comment.to_media=${article.id})"
 251             order="id desc">
 252
 253            <GenerateMedia key="media" />
 254         </Enumerate>
 255
 256
 257         <Enumerate
 258             key="media" table="otherMedia"
 259             selection="exists (select * from content_x_media where media_id=other_media.id and content_id=${article.id})
 260                or      exists (select * from comment_x_media, comment
 261                                        where comment_id = comment.id and media_id=other_media.id and comment.to_media=${article.id})"
 262             order="id desc">
 263
 264            <GenerateMedia key="media" />
 265         </Enumerate>
 266
 267
 268               <List key="topics" table="topic t" extratables="content_x_topic ctx"
 269                 selection="ctx.content_id = ${article.id} AND ctx.topic_id = t.id"  />
 270                    <If condition="utility.listSize(topics) > 0">
 271                    <then>
 272                         <Log message="I have a topic list with ${utility.listSize(topics)}" />
 273                     </then>
 274                    </If>
 275         <If condition="article.is_published == '1'">
 276           <then>
 277             <Language>
 278               <Generate
 279                 generator="/article.template"
 280                 destination="${config.storageRoot}/${pathprefix}/${article.date.formatted.yyyy}/${article.date.formatted.MM}/${article.id}.html"/>
 281              </Language>
 282              <Generate
 283                 generator="/languagebar.template"
 284                 destination="${config.storageRoot}/languagebar/${article.to_original.date.formatted.yyyy}/${article.to_original.date.formatted.MM}/${article.to_original.id}.html"/>
 285              <IndexContent key="article" pathToIndex="${config['IndexPath']}"/>
 286           </then>
 287           <else>
 288             <UnIndexContent key="article" pathToIndex="${config['IndexPath']}"/>
 289           </else>
 290         </If>
 291         <MarkContent key="article"/>
 292       </Enumerate>
 293     </body>
 294   </producer>
 295
 296   <producer name="staticpages">
 297     <verbs>
 298       <verb name="changed" default="1">
 299         <Define key="verbcondition" value="(not is_produced) and to_article_type = ${articletype.static}"/>
 300         <Set key="limit" value="10"/>
 301       </verb>
 302       <verb name="all">
 303         <Define key="verbcondition" value="to_article_type = ${articletype.static}"/>
 304         <Set key="limit" value="-1"/>
 305       </verb>
 306     </verbs>
 307
 308     <body>
 309       <Enumerate key="article" table="content" selection="${verbcondition}"
 310                   limit="limit" order="webdb_create desc">
 311         <Enumerate
 312             key="media" table="image"
 313             selection="exists (select * from content_x_media where media_id=images.id and content_id=${article.id})"
 314             order="id desc">
 315
 316            <GenerateMedia key="media" />
 317         </Enumerate>
 318         <Enumerate
 319             key="media" table="video"
 320             selection="exists (select * from content_x_media where media_id=video.id and content_id=${article.id})"
 321             order="id desc">
 322
 323            <GenerateMedia key="media" />
 324         </Enumerate>
 325         <Enumerate
 326             key="media" table="audio"
 327             selection="exists (select * from content_x_media where media_id=audio.id and content_id=${article.id})"
 328             order="id desc">
 329
 330            <GenerateMedia key="media" />
 331         </Enumerate>
 332         <Enumerate
 333             key="media" table="otherMedia"
 334             selection="exists (select * from content_x_media where media_id=other_media.id and content_id=${article.id})"
 335
 336             order="id desc">
 337
 338            <GenerateMedia key="media" />
 339         </Enumerate>
 340        <List key="topics" table="topic t" extratables="content_x_topic ctx"
 341                 selection="ctx.content_id = ${article.id} AND ctx.topic_id = t.id"  />
 342
 343         <If condition="article.is_published == '1'">
 344           <then>
 345             <Language>
 346               <Generate
 347                 generator="/article.template"
 348                 destination="${config.storageRoot}/${pathprefix}/static/${article.edittitle}.html"/>
 349              </Language>
 350
 351              <Generate
 352                 generator="/languagebar.template"
 353                 destination="${config.storageRoot}/languagebar/${article.to_original.date.formatted.yyyy}/${article.to_original.date.formatted.MM}/${article.to_original.id}.html"/>
 354              <IndexContent key="article" pathToIndex="${config['IndexPath']}"/>
 355           </then>
 356           <else>
 357             <UnIndexContent key="article" pathToIndex="${config['IndexPath']}"/>
 358           </else>
 359         </If>
 360         <MarkContent key="article"/>
 361       </Enumerate>
 362     </body>
 363   </producer>
 364
 365   <producer name="navigation">
 366     <verbs>
 367       <verb name="generate" default="1" description="generates the left column"/>
 368     </verbs>
 369     <body>
 370       <Language>
 371         <Generate
 372             generator="/navigation.template"
 373             destination="${config.storageRoot}/${pathprefix}/navigation.html"/>
 374       </Language>
 375     </body>
 376   </producer>
 377
 378   <producer name="staticimages">
 379     <verbs>
 380       <verb name="generate" default="1" description="copies all the static image files into place"/>
 381     </verbs>
 382     <body>
 383       <CopyDir destination="img" source="etc/producer/images"/>
 384     </body>
 385   </producer>
 386
 387   <producer name="newswirearchive">
 388     <verbs>
 389       <verb name="new">
 390         <Set key="pages" value="3"/>
 391       </verb>
 392       <verb name="all">
 393         <Set key="pages" value="-1"/>
 394       </verb>
 395     </verbs>
 396     <body>
 397         <Define key="docSuffix" value=".html"/>
 398         <Define key="storageSuffix" value=".html"/>
 399
 400         <Batch key="articles" infokey="batch" table="content"
 401                process="pages" batchsize="20" minbatchsize="10"
 402                selection="is_published='1' and to_article_type = ${articletype.newswire}"
 403                order="webdb_create asc">
 404           <batches>
 405             <Language>
 406               <Define key="pagePrefix" value="${pathprefix}/newswire/archive"/>
 407               <Define key="storagePrefix" value="${config[&quot;Producer.StorageRoot&quot;]}/${pagePrefix}"/>
 408               <Define key="docPrefix" value="${config[&quot;Producer.DocRoot&quot;]}/${pagePrefix}"/>
 409
 410               <Generate
 411                   generator="newswirearchive.template"
 412                   destination="${storagePrefix}${batch.current.identifier}${storageSuffix}"/>
 413
 414             </Language>
 415           </batches>
 416           <batchlist>
 417             <Language>
 418               <Define key="pagePrefix" value="${pathprefix}/newswire/archive"/>
 419               <Define key="storagePrefix" value="${config[&quot;Producer.StorageRoot&quot;]}/${pagePrefix}"/>
 420               <Define key="docPrefix" value="${config[&quot;Producer.DocRoot&quot;]}/${pagePrefix}"/>
 421               <Generate
 422                   generator="batchnav.template"
 423                   destination="${storagePrefix}nav${storageSuffix}"/>
 424             </Language>
 425           </batchlist>
 426         </Batch>
 427     </body>
 428   </producer>
 429
 430   <producer name="featurearchive">
 431     <verbs>
 432       <verb name="new">
 433         <Set key="pages" value="3"/>
 434       </verb>
 435       <verb name="all">
 436         <Set key="pages" value="-1"/>
 437       </verb>
 438     </verbs>
 439     <body>
 440         <Define key="docSuffix" value=".html"/>
 441         <Define key="storageSuffix" value=".html"/>
 442
 443         <Batch key="articles" infokey="batch" table="content"
 444                process="pages" batchsize="20" minbatchsize="10"
 445                selection="is_published='1' and to_article_type in (${articletype.feature}, ${articletype.startspecial})"
 446                order="webdb_create asc">
 447           <batches>
 448             <Language>
 449               <Define key="pagePrefix" value="${pathprefix}/feature/archive"/>
 450               <Define key="storagePrefix" value="${config[&quot;Producer.StorageRoot&quot;]}/${pagePrefix}"/>
 451               <Define key="docPrefix" value="${config[&quot;Producer.DocRoot&quot;]}/${pagePrefix}"/>
 452
 453               <Generate
 454                   generator="featurearchive.template"
 455                   destination="${storagePrefix}${batch.current.identifier}${storageSuffix}"/>
 456
 457             </Language>
 458           </batches>
 459           <batchlist>
 460             <Language>
 461               <Define key="pagePrefix" value="${pathprefix}/feature/archive"/>
 462               <Define key="storagePrefix" value="${config[&quot;Producer.StorageRoot&quot;]}/${pagePrefix}"/>
 463               <Define key="docPrefix" value="${config[&quot;Producer.DocRoot&quot;]}/${pagePrefix}"/>
 464               <Generate
 465                   generator="batchnav.template"
 466                   destination="${storagePrefix}nav${storageSuffix}"/>
 467             </Language>
 468           </batchlist>
 469         </Batch>
 470     </body>
 471   </producer>
 472
 473   <producer name="topicpages">
 474     <verbs>
 475       <verb name="new">
 476         <Set key="_topics" value="-1"/>
 477         <Set key="pages" value="3"/>
 478       </verb>
 479       <verb name="all">
 480         <Set key="_topics" value="-1"/>
 481         <Set key="pages" value="-1"/>
 482       </verb>
 483       <verb name="sample">
 484         <Set key="_topics" value="2"/>
 485         <Set key="pages" value="4"/>
 486       </verb>
 487     </verbs>
 488     <body>
 489       <Enumerate key="topic" table="topic">
 490         <Define key="docSuffix" value=".html"/>
 491         <Define key="storageSuffix" value=".html"/>
 492
 493         <Log message="topic = ${topic.title}" />
 494         <List key="special" table="content c"
 495           selection="c.is_published='1' and c.to_article_type = ${articletype.topicspecial} and c.id=cxt.content_id and cxt.topic_id = ${topic.id}"
 496           order = "webdb_create desc" limit="1"
 497           extratables="content_x_topic cxt"/>
 498
 499         <Batch key="articles" infokey="batch" table="content c"
 500                process="pages" batchsize="20" minbatchsize="10"
 501                selection="c.is_published='1' and c.to_article_type in (${articletype.newswire}, ${articletype.feature}) and c.id=cxt.content_id and cxt.topic_id = ${topic.id}"
 502                order="webdb_create asc" extratables="content_x_topic cxt">
 503           <batches>
 504             <Language>
 505               <Define key="pagePrefix" value="${pathprefix}/${topic.filename}/archive"/>
 506               <Define key="storagePrefix" value="${config[&quot;Producer.StorageRoot&quot;]}/${pagePrefix}"/>
 507               <Define key="docPrefix" value="${config[&quot;Producer.DocRoot&quot;]}/${pagePrefix}"/>
 508                   <Log message="topic now = ${topic.title}" />
 509
 510               <Generate
 511                   generator="topicpage.template"
 512                   destination="${storagePrefix}${batch.current.identifier}${storageSuffix}"/>
 513
 514             </Language>
 515           </batches>
 516           <batchlist>
 517             <Language>
 518               <Define key="pagePrefix" value="${pathprefix}/${topic.filename}/archive"/>
 519               <Define key="storagePrefix" value="${config[&quot;Producer.StorageRoot&quot;]}/${pagePrefix}"/>
 520               <Define key="docPrefix" value="${config[&quot;Producer.DocRoot&quot;]}/${pagePrefix}"/>
 521               <Generate
 522                   generator="batchnav.template"
 523                   destination="${storagePrefix}nav${storageSuffix}"/>
 524             </Language>
 525           </batchlist>
 526         </Batch>
 527       </Enumerate>
 528     </body>
 529   </producer>
 530
 531
 532   <producer name="opnewswireinclude">
 533     <verbs>
 534       <verb name="generate" default="1" description="Generates the op newswire"/>
 535     </verbs>
 536 <body>
 537 <Set key="whichnewswire" value="Open Publishing News" />
 538       <List key="newswire" table="content" limit="20"
 539         selection="is_published=true and to_article_type=${articletype.newswire}"
 540         order="webdb_create desc"/>
 541       <Language>
 542         <Generate
 543             generator="/newswireinclude.template"
 544             destination="${config.storageRoot}/${pathprefix}/newswireinclude.html"/>
 545       </Language>
 546
 547
 548 </body>
 549 </producer>
 550
 551   <producer name="rssnewswireinclude">
 552     <verbs>
 553       <verb name="generate" default="1" description="Generates the rss newswire"/>
 554     </verbs>
 555 <body>
 556 <Set key="whichnewswire" value="RSS Publishing News" />
 557       <List key="newswire" table="content" limit="20"
 558         selection="is_published=true and to_article_type=${articletype.communityrssarticle}"
 559         order="webdb_create desc"/>
 560       <Language>
 561         <Generate
 562             generator="/newswireinclude.template"
 563             destination="${config.storageRoot}/${pathprefix}/rssnewswireinclude.html"/>
 564       </Language>
 565
 566
 567 </body>
 568 </producer>
 569
 570
 571
 572   <producer name="startpage">
 573     <verbs>
 574       <verb name="generate" default="1" description="Generates the startpage"/>
 575     </verbs>
 576
 577     <body>
 578       <List key="startspecial" table="content" limit="1"
 579         selection="is_published=true and to_article_type=${articletype.startspecial}"
 580         order="webdb_create desc"/>
 581
 582       <List key="features" table="content" limit="5"
 583         selection="is_published=true and to_article_type in (${articletype.feature},${articletype.promotedcommunityarticle},${articletype.promotednewswire})"
 584         order="webdb_create desc"/>
 585
 586       <List key="communityrssarticles" table="content" limit="10"
 587         selection="is_published=true and to_article_type in (${articletype.communityrssarticle},${articletype.promotedcommunityarticle})"
 588         order="webdb_create desc"/>
 589
 590       <List key="newswire" table="content" limit="20"
 591         selection="is_published=true and to_article_type=${articletype.newswire}"
 592         order="webdb_create desc"/>
 593
 594       <List key="mostcomments"
 595                   table="content c"
 596                   extratables="comment cm"
 597                   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,
 598                                          c.subtitle,c.edittitle,c.date,c.creator,c.creator_main_url,c.creator_email,c.creator_address,c.creator_phone,c.description,
 599                                          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,
 600                                          c.content_data,c.is_html,c.to_article_type,c.to_content,c.keywords,c.to_locking_user"
 601                           order="count(cm.id) desc"
 602                           limit="3"
 603                     />
 604
 605
 606       <List key="breakingnews" table="breakingNews" limit="10"
 607          order="webdb_create desc"/>
 608
 609       <Language>
 610         <Generate
 611             generator="/startpage.template"
 612             destination="${config.storageRoot}/${pathprefix}/index.html"/>
 613       </Language>
 614     </body>
 615   </producer>
 616
 617   <producer name="synchronization">
 618     <verbs>
 619       <verb name="run" default="1" description="Synchronizes the publication site with the production site"/>
 620     </verbs>
 621
 622     <body>
 623       <If condition="config['Rsync'] in ('1', 'y', 'yes', 'Y')">
 624         <then>
 625           <Execute command="${config['Rsync.Script.Path']}"/>
 626         </then>
 627       </If>
 628     </body>
 629   </producer>
 630
 631
 632   <producer name="media">
 633     <verbs>
 634       <verb name="new" default="1">
 635         <Define key="verbcondition" value="(not is_produced)"/>
 636         <Set key="limit" value="10"/>
 637       </verb>
 638       <verb name="all">
 639         <Define key="verbcondition" value=""/>
 640         <Set key="limit" value="-1"/>
 641       </verb>
 642
 643       <verb name="sample">
 644         <Define key="verbcondition" value=""/>
 645         <Set key="limit" value="10"/>
 646       </verb>
 647     </verbs>
 648     <body>
 649       <Enumerate
 650           key="media" table="image"
 651           selection="${verbcondition}"
 652           limit="limit"
 653           order="webdb_create desc">
 654
 655          <GenerateMedia key="media" />
 656       </Enumerate>
 657       <Enumerate
 658           key="media" table="video"
 659           selection="${verbcondition}"
 660           limit="limit"
 661           order="webdb_create desc">
 662
 663          <GenerateMedia key="media" />
 664       </Enumerate>
 665       <Enumerate
 666           key="media" table="audio"
 667           selection="${verbcondition}"
 668           limit="limit"
 669           order="webdb_create desc">
 670
 671          <GenerateMedia key="media" />
 672       </Enumerate>
 673       <Enumerate
 674           key="media" table="otherMedia"
 675           selection="${verbcondition}"
 676           limit="limit"
 677           order="webdb_create desc">
 678
 679          <GenerateMedia key="media" />
 680       </Enumerate>
 681     </body>
 682   </producer>
 683
 684   <producer name="syndication">
 685     <verbs>
 686       <verb name="generate" />
 687     </verbs>
 688     <body>
 689       <!-- the main features and newswire -->
 690       <RSSChannelBundle />
 691
 692       <!-- the topic features and newswires -->
 693       <Enumerate key="topic" table="topic">
 694         <RSSChannelBundle
 695           basefilename="${topic.filename}"
 696           selection="c.id=cxt.content_id and cxt.topic_id = ${topic.id}"
 697           extratables="content_x_topic cxt"
 698         />
 699       </Enumerate>
 700
 701
 702
 703     </body>
 704
 705   </producer>
 706
 707   <producer name="radicalendar">
 708     <verbs>
 709       <verb name="pull" />
 710     </verbs>
 711     <body>
 712       <!-- groupname you will see as the value of "group" in the url for your radicalendar page, -->
 713       <!--      gmtoffset is in minutes                                                          -->
 714       <Radicalendar key="calendar" groupname="_imc" gmtoffset="60"  />
 715       <Generate
 716         generator="/radicalendar.template"
 717         destination="${config.storageRoot}/calendarinclude.html"/>
 718
 719
 720     </body>
 721   </producer>
 722
 723
 724   <producer name="update">
 725     <verbs>
 726       <verb name="templates" description="updates templates and bundles">
 727         <Define key="command" value="/usr/bin/rsync -rb --include=*/ --include=*.template  /var/lib/mir/nyc/mir/etc/ /var/lib/mir/nyc/mir/bin/mir/WEB-INF/etc/"/>
 728       </verb>
 729     </verbs>
 730
 731     <body>
 732       <Execute command="${command}"/>
 733     </body>
 734   </producer>
 735
 736
 737
 738
 739
 740  <producer name="generatefpincludes">
 741    <verbs>
 742      <verb name="doit" />
 743    </verbs>
 744    <body>
 745
 746         <Set key="counter" value="1"/>
 747       <Enumerate key="fpimage" table="image" selection="to_media_folder=8 and is_published=true" >
 748         <Log message="generating include for image id: ${fpimage.id}" type="info" />
 749
 750           <Generate
 751                 generator="/fpinclude.template"
 752                 destination="${config.storageRoot}/fpincludes/${fpimage.id}.inc" />
 753        <Set key="counter" value="counter+1" />
 754       </Enumerate>
 755
 756
 757            <List key="fpincludes" table="image" selection="to_media_folder=8 and is_published=true" />
 758                 <Generate
 759                         generator="/fpmapping.template"
 760                         destination="${config.storageRoot}/fpincludes/map.txt" />
 761
 762     </body>
 763   </producer>
 764
 765
 766
 767
 768  <!-- generates a count for each topic -->
 769
 770  <!-- TODO: add date limit when we actually are going live with this -->
 771  <producer name="generateTopicCounts">
 772  <verbs>
 773         <verb name="doit" />
 774  </verbs>
 775  <body>
 776         <FreeQuery key="topicCounts" query=" SELECT count(x.content_id) as count, t.title, t.filename FROM topic as t LEFT OUTER JOIN content_x_topic
 777                                                                                  as x ON (t.id=x.topic_id) LEFT OUTER JOIN content as c ON (c.id=x.content_id)
 778                                                                                  WHERE c.webdb_create > NOW()-'1 day'::interval AND  t.archiv_url = 'Category' GROUP BY t.title , t.filename ORDER BY t.title"
 779                    type="set"/>
 780         <Language>
 781         <Generate generator="/topiccount.template"
 782                 destination="${config.storageRoot}/${pathprefix}/topiccount.html" />
 783         </Language>
 784   </body>
 785   </producer>
 786
 787
 788
 789  <producer name="generateRandomTopics">
 790   <verbs>
 791     <verb name="doit" />
 792   </verbs>
 793   <body>
 794         <Set key="counter" value="1"/>
 795
 796         <Enumerate key="category" table="topic t" extratables="topic t2"
 797                 selection="t.id=t2.id AND t.archiv_url = 'Subcategory' AND (SELECT count(*) from content_x_topic where topic_id = t.id) > 0" order="RANDOM()" limit="10">
 798
 799         <Log message="Getting Last 5 articles for category: ${category.title} - counter: ${counter}" />
 800         <Define key="topictitle" value="${category.title}" />
 801         <Define key="topicfile" value="${category.filename}" />
 802
 803         <List key="randomarticles" table="content"
 804                 selection ="id in (select content_id from content_x_topic where topic_id = ${category.id})" order="date DESC"
 805                 limit="3" />
 806         <Language>
 807         <Generate
 808                 generator="/randomcategory.template"
 809                 destination="${config.storageRoot}/${pathprefix}/randomcats/random${counter}.html" />
 810         </Language>
 811
 812         <Set key="counter" value="counter+1" />
 813     </Enumerate>
 814   </body>
 815  </producer>
 816
 817  <producer name="getlocalblogs">
 818    <verbs>
 819      <verb name="doit" />
 820    </verbs>
 821    <body>
 822       <Enumerate key="article" table="content" selection="to_article_type in(${articletype.communityrssfeed}) and is_published=true"  order="webdb_create desc">
 823         <Log message="Pulling 1.0 feed from ${article.title} at ${article.source}" type="info" />
 824         <Pull
 825           url="${article.source}"
 826           articletype="${articletype.communityrssarticle}"
 827           blogurl="${article.creator_main_url}"
 828           blogname="${article.title}"
 829         />
 830       </Enumerate>
 831     </body>
 832   </producer>
 833
 834   <producer name="footer">
 835     <verbs>
 836       <verb name="generate" default="1" description="generates the default footer"/>
 837     </verbs>
 838     <body>
 839       <Language>
 840         <Generate
 841             generator="/footer.template"
 842             destination="${config.storageRoot}/${pathprefix}/footer.html"/>
 843       </Language>
 844     </body>
 845   </producer>
 846
 847
 848   <producer name="headArticle">
 849     <verbs>
 850       <verb name="generate" default="1" description="generates the article html head"/>
 851     </verbs>
 852     <body>
 853       <Language>
 854         <Generate
 855             generator="/head.article.template"
 856             destination="${config.storageRoot}/${pathprefix}/head.article.html"/>
 857       </Language>
 858     </body>
 859   </producer>
 860
 861 </producers>
 862
 863