changed include in article and topicpage, changed link in topiccount
[nyc.indymedia.org.git] / etc / producer / producers.xml
index 4d8f823..a99938d 100755 (executable)
        <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 
+       <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 
                                                                                 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"/>
-                  
+       <Language>          
        <Generate generator="/topiccount.template"
                destination="${config.storageRoot}/${pathprefix}/topiccount.html" />
+       </Language>
   </body>
   </producer>