changed random categories
authormtopper <mtopper>
Sat, 30 Jul 2005 22:23:32 +0000 (22:23 +0000)
committermtopper <mtopper>
Sat, 30 Jul 2005 22:23:32 +0000 (22:23 +0000)
etc/producer/producers.xml
etc/producer/startpage.template

index b9ad277..00cb67c 100755 (executable)
        <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">
+               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">
        
         <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" />
+               limit="3" />
         <Language>     
                <Generate
                        generator="/randomcategory.template"
index 5ee4ef2..dec7754 100755 (executable)
                      <!--#include virtual="/fpincludes/random3.inc" -->\r
                      <!--#include virtual="/fpincludes/random4.inc" -->\r
                      <!--#include virtual="/fpincludes/random5.inc" -->\r
-                     <!--#include virtual="/fpincludes/random6.inc" -->\r
-                     <!--#include virtual="/fpincludes/random7.inc" -->\r
-                     <!--#include virtual="/fpincludes/random8.inc" -->\r
-                     <!--#include virtual="/fpincludes/random9.inc" -->\r
-                     <!--#include virtual="/fpincludes/random10.inc" -->\r
                \r
                </div>\r
                </td>\r
                <td class="margin"><div><!-- --></div></td>\r
                <td>\r
                   <div class="listWrap">\r
-                     <!--#include virtual="/fpincludes/random11.inc" -->\r
-                     <!--#include virtual="/fpincludes/random12.inc" -->\r
-                     <!--#include virtual="/fpincludes/random13.inc" -->\r
-                     <!--#include virtual="/fpincludes/random14.inc" -->\r
-                     <!--#include virtual="/fpincludes/random15.inc" -->\r
-                     <!--#include virtual="/fpincludes/random16.inc" -->\r
-                     <!--#include virtual="/fpincludes/random17.inc" -->\r
-                     <!--#include virtual="/fpincludes/random18.inc" -->\r
-                     <!--#include virtual="/fpincludes/random19.inc" -->\r
-                     <!--#include virtual="/fpincludes/random20.inc" -->\r
-\r
-\r
+                     <!--#include virtual="/fpincludes/random6.inc" -->\r
+                     <!--#include virtual="/fpincludes/random7.inc" -->\r
+                     <!--#include virtual="/fpincludes/random8.inc" -->\r
+                     <!--#include virtual="/fpincludes/random9.inc" -->\r
+                     <!--#include virtual="/fpincludes/random10.inc" -->\r
                   </div>\r
                </td>\r
             </tr>\r
    </tr>\r
 </table>\r
 \r
-<!--#include virtual="footer.inc" -->
\ No newline at end of file
+<!--#include virtual="footer.inc" -->\r