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" selection="${articleSelection}" order = "webdb_create desc, date desc" limit="limit" />
 137         </then>
 138         <else>
 139           <List key="articles" table="content" selection="${articleSelection}" order = "webdb_create desc, 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="is_published='1'" />
 164       <string name="basefilename" defaultvalue="main" />
 165     </parameters>
 166     <definition>
 167       <!-- newswire -->
 168       <RSSChannel
 169         articleSelection="(to_article_type in (${articletype.newswire}) or (to_article_type=${articletype.translation} and 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="(to_article_type in (${articletype.newswire}) or (to_article_type=${articletype.translation} and 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="(to_article_type 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="(to_article_type 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       <verb name="regen">
 225         <Define key="verbcondition" value="(not is_produced) and to_article_type != ${articletype.static}"/>
 226         <Set key="limit" value="5000"/>
 227       </verb>
 228     </verbs>
 229     <body>
 230       <Enumerate key="article" table="content" selection="${verbcondition}"
 231                   limit="limit" order="webdb_create desc">
 232         <Enumerate
 233             key="media" table="image"
 234             selection="exists (select * from content_x_media where media_id=images.id and content_id=${article.id})
 235                or      exists (select * from comment_x_media, comment
 236                            where comment_id = comment.id and media_id=images.id and comment.to_media=${article.id})"
 237             order="id desc">
 238
 239            <GenerateMedia key="media" />
 240         </Enumerate>
 241         <Enumerate
 242             key="media" table="video"
 243             selection="exists (select * from content_x_media where media_id=video.id and content_id=${article.id})
 244                or      exists (select * from comment_x_media, comment
 245                            where comment_id = comment.id and media_id=video.id and comment.to_media=${article.id})"
 246             order="id desc">
 247            <GenerateMedia key="media" />
 248         </Enumerate>
 249         <Enumerate
 250             key="media" table="audio"
 251             selection="exists (select * from content_x_media where media_id=audio.id and content_id=${article.id})
 252                or      exists (select * from comment_x_media, comment
 253                                        where comment_id = comment.id and media_id=audio.id and comment.to_media=${article.id})"
 254             order="id desc">
 255
 256            <GenerateMedia key="media" />
 257         </Enumerate>
 258
 259
 260         <Enumerate
 261             key="media" table="otherMedia"
 262             selection="exists (select * from content_x_media where media_id=other_media.id and content_id=${article.id})
 263                or      exists (select * from comment_x_media, comment
 264                                        where comment_id = comment.id and media_id=other_media.id and comment.to_media=${article.id})"
 265             order="id desc">
 266
 267            <GenerateMedia key="media" />
 268         </Enumerate>
 269
 270
 271               <List key="topics" table="topic t" extratables="content_x_topic ctx"
 272                 selection="ctx.content_id = ${article.id} AND ctx.topic_id = t.id"  />
 273                    <!--<If condition="utility.listSize(topics) > 0">
 274                    <then>
 275                         <Log message="I have a topic list with ${utility.listSize(topics)}" />
 276                     </then>
 277                    </If>-->
 278               <Log message="I am generating: ${article.id}"/>
 279
 280   <If condition="article.is_published == '1'">
 281           <then>
 282             <Language>
 283               <Generate
 284                 generator="/article.template"
 285                 destination="${config.storageRoot}/${pathprefix}/${article.date.formatted.yyyy}/${article.date.formatted.MM}/${article.id}.html"/>
 286              </Language>
 287              <Generate
 288                 generator="/languagebar.template"
 289                 destination="${config.storageRoot}/languagebar/${article.to_original.date.formatted.yyyy}/${article.to_original.date.formatted.MM}/${article.to_original.id}.html"/>
 290              <IndexContent key="article" pathToIndex="${config['IndexPath']}"/>
 291           </then>
 292           <else>
 293             <UnIndexContent key="article" pathToIndex="${config['IndexPath']}"/>
 294           </else>
 295         </If>
 296         <MarkContent key="article"/>
 297       </Enumerate>
 298     </body>
 299   </producer>
 300
 301   <producer name="staticpages">
 302     <verbs>
 303       <verb name="changed" default="1">
 304         <Define key="verbcondition" value="(not is_produced) and to_article_type = ${articletype.static}"/>
 305         <Set key="limit" value="10"/>
 306       </verb>
 307       <verb name="all">
 308         <Define key="verbcondition" value="to_article_type = ${articletype.static}"/>
 309         <Set key="limit" value="-1"/>
 310       </verb>
 311     </verbs>
 312
 313     <body>
 314       <Enumerate key="article" table="content" selection="${verbcondition}"
 315                   limit="limit" order="webdb_create desc">
 316         <Enumerate
 317             key="media" table="image"
 318             selection="exists (select * from content_x_media where media_id=images.id and content_id=${article.id})"
 319             order="id desc">
 320
 321            <GenerateMedia key="media" />
 322         </Enumerate>
 323         <Enumerate
 324             key="media" table="video"
 325             selection="exists (select * from content_x_media where media_id=video.id and content_id=${article.id})"
 326             order="id desc">
 327
 328            <GenerateMedia key="media" />
 329         </Enumerate>
 330         <Enumerate
 331             key="media" table="audio"
 332             selection="exists (select * from content_x_media where media_id=audio.id and content_id=${article.id})"
 333             order="id desc">
 334
 335            <GenerateMedia key="media" />
 336         </Enumerate>
 337         <Enumerate
 338             key="media" table="otherMedia"
 339             selection="exists (select * from content_x_media where media_id=other_media.id and content_id=${article.id})"
 340
 341             order="id desc">
 342
 343            <GenerateMedia key="media" />
 344         </Enumerate>
 345        <List key="topics" table="topic t" extratables="content_x_topic ctx"
 346                 selection="ctx.content_id = ${article.id} AND ctx.topic_id = t.id"  />
 347
 348         <If condition="article.is_published == '1'">
 349           <then>
 350             <Language>
 351               <Generate
 352                 generator="/staticpage.template"
 353                 destination="${config.storageRoot}/${pathprefix}/static/${article.edittitle}.html"/>
 354              </Language>
 355
 356              <Generate
 357                 generator="/languagebar.template"
 358                 destination="${config.storageRoot}/languagebar/${article.to_original.date.formatted.yyyy}/${article.to_original.date.formatted.MM}/${article.to_original.id}.html"/>
 359              <IndexContent key="article" pathToIndex="${config['IndexPath']}"/>
 360           </then>
 361           <else>
 362             <UnIndexContent key="article" pathToIndex="${config['IndexPath']}"/>
 363           </else>
 364         </If>
 365         <MarkContent key="article"/>
 366       </Enumerate>
 367     </body>
 368   </producer>
 369
 370   <producer name="navigation">
 371     <verbs>
 372       <verb name="generate" default="1" description="generates the left column"/>
 373     </verbs>
 374     <body>
 375       <Language>
 376         <Generate
 377             generator="/navigation.template"
 378             destination="${config.storageRoot}/${pathprefix}/navigation.html"/>
 379       </Language>
 380     </body>
 381   </producer>
 382
 383   <producer name="staticimages">
 384     <verbs>
 385       <verb name="generate" default="1" description="copies all the static image files into place"/>
 386     </verbs>
 387     <body>
 388       <CopyDir destination="img" source="etc/producer/images"/>
 389     </body>
 390   </producer>
 391
 392
 393    <producer name="staticfiles">
 394     <verbs>
 395       <verb name="generate" default="1" description="copies all the static image files into place"/>
 396     </verbs>
 397     <body>
 398       <CopyDir destination="js" source="etc/producer/js"/>
 399     </body>
 400   </producer>
 401
 402   <producer name="newswirearchive">
 403     <verbs>
 404       <verb name="new">
 405         <Set key="pages" value="3"/>
 406       </verb>
 407       <verb name="all">
 408         <Set key="pages" value="-1"/>
 409       </verb>
 410     </verbs>
 411     <body>
 412         <Define key="docSuffix" value=".html"/>
 413         <Define key="storageSuffix" value=".html"/>
 414
 415         <Batch key="articles" infokey="batch" table="content"
 416                process="pages" batchsize="20" minbatchsize="10"
 417                selection="is_published='1' and to_article_type = ${articletype.newswire}"
 418                order="webdb_create asc">
 419           <batches>
 420             <Language>
 421               <Define key="pagePrefix" value="${pathprefix}/newswire/archive"/>
 422               <Define key="storagePrefix" value="${config[&quot;Producer.StorageRoot&quot;]}/${pagePrefix}"/>
 423               <Define key="docPrefix" value="${config[&quot;Producer.DocRoot&quot;]}/${pagePrefix}"/>
 424
 425               <Generate
 426                   generator="newswirearchive.template"
 427                   destination="${storagePrefix}${batch.current.identifier}${storageSuffix}"/>
 428
 429             </Language>
 430           </batches>
 431           <batchlist>
 432             <Language>
 433               <Define key="pagePrefix" value="${pathprefix}/newswire/archive"/>
 434               <Define key="storagePrefix" value="${config[&quot;Producer.StorageRoot&quot;]}/${pagePrefix}"/>
 435               <Define key="docPrefix" value="${config[&quot;Producer.DocRoot&quot;]}/${pagePrefix}"/>
 436               <Generate
 437                   generator="batchnav.template"
 438                   destination="${storagePrefix}nav${storageSuffix}"/>
 439             </Language>
 440           </batchlist>
 441         </Batch>
 442     </body>
 443   </producer>
 444
 445   <producer name="featurearchive">
 446     <verbs>
 447       <verb name="new">
 448         <Set key="pages" value="3"/>
 449       </verb>
 450       <verb name="all">
 451         <Set key="pages" value="-1"/>
 452       </verb>
 453     </verbs>
 454     <body>
 455         <Define key="docSuffix" value=".html"/>
 456         <Define key="storageSuffix" value=".html"/>
 457
 458         <Batch key="articles" infokey="batch" table="content"
 459                process="pages" batchsize="20" minbatchsize="10"
 460                selection="is_published='1' and to_article_type in (${articletype.feature}, ${articletype.startspecial})"
 461                order="webdb_create asc">
 462           <batches>
 463             <Language>
 464               <Define key="pagePrefix" value="${pathprefix}/feature/archive"/>
 465               <Define key="storagePrefix" value="${config[&quot;Producer.StorageRoot&quot;]}/${pagePrefix}"/>
 466               <Define key="docPrefix" value="${config[&quot;Producer.DocRoot&quot;]}/${pagePrefix}"/>
 467
 468               <Generate
 469                   generator="featurearchive.template"
 470                   destination="${storagePrefix}${batch.current.identifier}${storageSuffix}"/>
 471
 472             </Language>
 473           </batches>
 474           <batchlist>
 475             <Language>
 476               <Define key="pagePrefix" value="${pathprefix}/feature/archive"/>
 477               <Define key="storagePrefix" value="${config[&quot;Producer.StorageRoot&quot;]}/${pagePrefix}"/>
 478               <Define key="docPrefix" value="${config[&quot;Producer.DocRoot&quot;]}/${pagePrefix}"/>
 479               <Generate
 480                   generator="batchnav.template"
 481                   destination="${storagePrefix}nav${storageSuffix}"/>
 482             </Language>
 483           </batchlist>
 484         </Batch>
 485     </body>
 486   </producer>
 487
 488   <producer name="topicpages">
 489     <verbs>
 490       <verb name="new">
 491         <Set key="_topics" value="-1"/>
 492         <Set key="pages" value="3"/>
 493       </verb>
 494       <verb name="all">
 495         <Set key="_topics" value="-1"/>
 496         <Set key="pages" value="-1"/>
 497       </verb>
 498       <verb name="sample">
 499         <Set key="_topics" value="2"/>
 500         <Set key="pages" value="4"/>
 501       </verb>
 502     </verbs>
 503     <body>
 504       <Enumerate key="topic" table="topic">
 505         <Define key="docSuffix" value=".html"/>
 506         <Define key="storageSuffix" value=".html"/>
 507
 508         <Log message="topic = ${topic.title}" />
 509         <List key="special" table="content c"
 510           selection="c.is_published='1' and c.to_article_type = ${articletype.topicspecial} and c.id=cxt.content_id and cxt.topic_id = ${topic.id}"
 511           order = "webdb_create desc" limit="1"
 512           extratables="content_x_topic cxt"/>
 513
 514         <Batch key="articles" infokey="batch" table="content c"
 515                process="pages" batchsize="20" minbatchsize="10"
 516                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}"
 517                order="webdb_create asc" extratables="content_x_topic cxt">
 518           <batches>
 519             <Language>
 520               <Define key="pagePrefix" value="${pathprefix}/${topic.filename}/archive"/>
 521               <Define key="storagePrefix" value="${config[&quot;Producer.StorageRoot&quot;]}/${pagePrefix}"/>
 522               <Define key="docPrefix" value="${config[&quot;Producer.DocRoot&quot;]}/${pagePrefix}"/>
 523                   <Log message="topic now = ${topic.title}" />
 524
 525               <Generate
 526                   generator="topicpage.template"
 527                   destination="${storagePrefix}${batch.current.identifier}${storageSuffix}"/>
 528
 529             </Language>
 530           </batches>
 531           <batchlist>
 532             <Language>
 533               <Define key="pagePrefix" value="${pathprefix}/${topic.filename}/archive"/>
 534               <Define key="storagePrefix" value="${config[&quot;Producer.StorageRoot&quot;]}/${pagePrefix}"/>
 535               <Define key="docPrefix" value="${config[&quot;Producer.DocRoot&quot;]}/${pagePrefix}"/>
 536               <Generate
 537                   generator="batchnav.template"
 538                   destination="${storagePrefix}nav${storageSuffix}"/>
 539             </Language>
 540           </batchlist>
 541         </Batch>
 542       </Enumerate>
 543     </body>
 544   </producer>
 545
 546
 547   <producer name="opnewswireinclude">
 548     <verbs>
 549       <verb name="generate" default="1" description="Generates the op newswire"/>
 550     </verbs>
 551 <body>
 552 <Set key="whichnewswire" value="Open Publishing News" />
 553       <List key="newswire" table="content" limit="50"
 554         selection="is_published=true and to_article_type=${articletype.newswire}"
 555         order="webdb_create desc"/>
 556       <Language>
 557         <Generate
 558             generator="/newswireinclude.template"
 559             destination="${config.storageRoot}/${pathprefix}/newswireinclude.html"/>
 560       </Language>
 561
 562
 563 </body>
 564 </producer>
 565
 566   <producer name="rssnewswireinclude">
 567     <verbs>
 568       <verb name="generate" default="1" description="Generates the rss newswire"/>
 569     </verbs>
 570 <body>
 571 <Set key="whichnewswire" value="RSS Publishing News" />
 572       <List key="newswire" table="content" limit="20"
 573         selection="is_published=true and to_article_type=${articletype.communityrssarticle}"
 574         order="webdb_create desc"/>
 575       <Language>
 576         <Generate
 577             generator="/newswireinclude.template"
 578             destination="${config.storageRoot}/${pathprefix}/rssnewswireinclude.html"/>
 579       </Language>
 580
 581
 582 </body>
 583 </producer>
 584
 585
 586
 587   <producer name="startpage">
 588     <verbs>
 589       <verb name="generate" default="1" description="Generates the startpage"/>
 590     </verbs>
 591
 592
 593     <body>
 594       <List key="startspecial" table="content" limit="1"
 595         selection="is_published=true and to_article_type=${articletype.startspecial}"
 596         order="webdb_create desc"/>
 597
 598       <Enumerate key="ssimage" table="image" selection="to_media_folder=9 and is_published=true" >
 599         <Define key="ssimagepath" value="${ssimage.publish_server}/${ssimage.publish_path}" />
 600         <Define key="sstitle" value="${ssimage.title}" />
 601       </Enumerate>
 602
 603
 604       <List key="features" table="content" limit="5"
 605         selection="is_published=true and to_article_type in (${articletype.feature},${articletype.promotedcommunityarticle},${articletype.promotednewswire})"
 606         order="webdb_create desc"/>
 607
 608       <List key="communityrssarticles" table="content" limit="10"
 609         selection="is_published=true and to_article_type in (${articletype.communityrssarticle},${articletype.promotedcommunityarticle})"
 610         order="webdb_create desc"/>
 611
 612       <List key="newswire" table="content" limit="20"
 613         selection="is_published=true and to_article_type=${articletype.newswire}"
 614         order="webdb_create desc"/>
 615
 616       <List key="mostcomments"
 617                   table="content c"
 618                   extratables="comment cm"
 619                   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,
 620                                          c.subtitle,c.edittitle,c.date,c.creator,c.creator_main_url,c.creator_email,c.creator_address,c.creator_phone,c.description,
 621                                          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,
 622                                          c.content_data,c.is_html,c.to_article_type,c.to_content,c.keywords,c.to_locking_user"
 623                           order="count(cm.id) desc, c.webdb_create desc "
 624                           limit="3"
 625                     />
 626
 627
 628       <List key="breakingnews" table="breakingNews" limit="10"
 629          order="webdb_create desc"/>
 630
 631       <Language>
 632         <Generate
 633             generator="/startpage.template"
 634             destination="${config.storageRoot}/${pathprefix}/index.html"/>
 635       </Language>
 636     </body>
 637   </producer>
 638
 639   <producer name="synchronization">
 640     <verbs>
 641       <verb name="run" default="1" description="Synchronizes the publication site with the production site"/>
 642     </verbs>
 643
 644     <body>
 645       <If condition="config['Rsync'] in ('1', 'y', 'yes', 'Y')">
 646         <then>
 647           <Execute command="${config['Rsync.Script.Path']}"/>
 648         </then>
 649       </If>
 650     </body>
 651   </producer>
 652
 653
 654   <producer name="media">
 655     <verbs>
 656       <verb name="new" default="1">
 657         <Define key="verbcondition" value="(not is_produced)"/>
 658         <Set key="limit" value="10"/>
 659       </verb>
 660       <verb name="all">
 661         <Define key="verbcondition" value=""/>
 662         <Set key="limit" value="-1"/>
 663       </verb>
 664
 665       <verb name="sample">
 666         <Define key="verbcondition" value=""/>
 667         <Set key="limit" value="10"/>
 668       </verb>
 669     </verbs>
 670     <body>
 671       <Enumerate
 672           key="media" table="image"
 673           selection="${verbcondition}"
 674           limit="limit"
 675           order="webdb_create desc">
 676
 677          <GenerateMedia key="media" />
 678       </Enumerate>
 679       <Enumerate
 680           key="media" table="video"
 681           selection="${verbcondition}"
 682           limit="limit"
 683           order="webdb_create desc">
 684
 685          <GenerateMedia key="media" />
 686       </Enumerate>
 687       <Enumerate
 688           key="media" table="audio"
 689           selection="${verbcondition}"
 690           limit="limit"
 691           order="webdb_create desc">
 692
 693          <GenerateMedia key="media" />
 694       </Enumerate>
 695       <Enumerate
 696           key="media" table="otherMedia"
 697           selection="${verbcondition}"
 698           limit="limit"
 699           order="webdb_create desc">
 700
 701          <GenerateMedia key="media" />
 702       </Enumerate>
 703     </body>
 704   </producer>
 705
 706   <producer name="syndication">
 707     <verbs>
 708       <verb name="generate" />
 709     </verbs>
 710     <body>
 711       <!-- the main features and newswire -->
 712       <RSSChannelBundle />
 713
 714       <!-- the topic features and newswires -->
 715       <Enumerate key="topic" table="topic">
 716         <RSSChannelBundle
 717           basefilename="${topic.filename}"
 718           selection="id=cxt.content_id and cxt.topic_id = ${topic.id}"
 719           extratables="content_x_topic as cxt"
 720         />
 721       </Enumerate>
 722
 723
 724
 725     </body>
 726
 727   </producer>
 728
 729   <producer name="radicalendar">
 730     <verbs>
 731       <verb name="pull" />
 732     </verbs>
 733     <body>
 734       <!-- groupname you will see as the value of "group" in the url for your radicalendar page, -->
 735       <!--      gmtoffset is in minutes                                                          -->
 736       <Radicalendar key="calendar" groupname="_imc" gmtoffset="60"  />
 737       <Generate
 738         generator="/radicalendar.template"
 739         destination="${config.storageRoot}/calendarinclude.html"/>
 740
 741
 742     </body>
 743   </producer>
 744
 745
 746   <producer name="update">
 747     <verbs>
 748       <verb name="templates" description="updates templates and bundles">
 749         <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/"/>
 750       </verb>
 751     </verbs>
 752
 753     <body>
 754       <Execute command="${command}"/>
 755     </body>
 756   </producer>
 757
 758
 759
 760
 761
 762  <producer name="generatefpincludes">
 763    <verbs>
 764      <verb name="doit" />
 765    </verbs>
 766    <body>
 767
 768         <Set key="counter" value="1"/>
 769       <Enumerate key="fpimage" table="image" selection="to_media_folder=8 and is_published=true" >
 770         <Log message="generating include for image id: ${fpimage.id}" type="info" />
 771
 772           <Generate
 773                 generator="/fpinclude.template"
 774                 destination="${config.storageRoot}/fpincludes/${fpimage.id}.inc" />
 775        <Set key="counter" value="counter+1" />
 776       </Enumerate>
 777
 778
 779            <List key="fpincludes" table="image" selection="to_media_folder=8 and is_published=true" />
 780                 <Generate
 781                         generator="/fpmapping.template"
 782                         destination="${config.storageRoot}/fpincludes/map.txt" />
 783
 784     </body>
 785   </producer>
 786
 787
 788
 789
 790  <!-- generates a count for each topic -->
 791
 792  <!-- TODO: add date limit when we actually are going live with this -->
 793  <producer name="generateTopicCounts">
 794  <verbs>
 795         <verb name="doit" />
 796  </verbs>
 797  <body>
 798         <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
 799                                                                                  as x ON (t.id=x.topic_id) LEFT OUTER JOIN content as c ON (c.id=x.content_id)
 800                                                                                  WHERE c.webdb_create > NOW()-'1 day'::interval AND  t.archiv_url = 'Category' GROUP BY t.title , t.filename ORDER BY t.title"
 801                    type="set"/>
 802         <Language>
 803         <Generate generator="/topiccount.template"
 804                 destination="${config.storageRoot}/${pathprefix}/topiccount.html" />
 805         </Language>
 806   </body>
 807   </producer>
 808
 809
 810
 811  <producer name="generateRandomTopics">
 812   <verbs>
 813     <verb name="doit" />
 814   </verbs>
 815   <body>
 816         <Set key="counter" value="1"/>
 817
 818         <Enumerate key="category" table="topic t" extratables="topic t2"
 819                 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">
 820
 821         <Log message="Getting Last 5 articles for category: ${category.title} - counter: ${counter}" />
 822         <Define key="topictitle" value="${category.title}" />
 823         <Define key="topicfile" value="${category.filename}" />
 824
 825         <List key="randomarticles" table="content"
 826                 selection ="id in (select content_id from content_x_topic where topic_id = ${category.id}) AND is_published=true" order="date DESC"
 827                 limit="3" />
 828         <Language>
 829         <Generate
 830                 generator="/randomcategory.template"
 831                 destination="${config.storageRoot}/${pathprefix}/randomcats/random${counter}.html" />
 832         </Language>
 833
 834         <Set key="counter" value="counter+1" />
 835     </Enumerate>
 836   </body>
 837  </producer>
 838
 839  <producer name="getlocalblogs">
 840    <verbs>
 841      <verb name="doit" />
 842    </verbs>
 843    <body>
 844       <Enumerate key="article" table="content" selection="to_article_type in(${articletype.communityrssfeed}) and is_published=true"  order="webdb_create desc">
 845         <Log message="Pulling 1.0 feed from ${article.title} at ${article.source}" type="info" />
 846         <Pull
 847           url="${article.source}"
 848           articletype="${articletype.communityrssarticle}"
 849           blogurl="${article.creator_main_url}"
 850           blogname="${article.title}"
 851         />
 852       </Enumerate>
 853     </body>
 854   </producer>
 855
 856   <producer name="footer">
 857     <verbs>
 858       <verb name="generate" default="1" description="generates the default footer"/>
 859     </verbs>
 860     <body>
 861       <Language>
 862         <Generate
 863             generator="/footer.template"
 864             destination="${config.storageRoot}/${pathprefix}/footer.html"/>
 865       </Language>
 866     </body>
 867   </producer>
 868
 869
 870   <producer name="headArticle">
 871     <verbs>
 872       <verb name="generate" default="1" description="generates the article html head"/>
 873     </verbs>
 874     <body>
 875       <Language>
 876         <Generate
 877             generator="/head.article.template"
 878             destination="${config.storageRoot}/${pathprefix}/head.article.html"/>
 879       </Language>
 880     </body>
 881   </producer>
 882
 883 </producers>
 884
 885