template alternating colors

diff --git a/dbscripts/create_pg.sql b/dbscripts/create_pg.sql
index bacd92c..c0a3805 100755 (executable)
--- a/dbscripts/create_pg.sql
+++ b/dbscripts/create_pg.sql
@@ -527,6 +527,11 @@ CREATE  INDEX "comment_checksum_index" on "comment" using btree ( "checksum" "in
 
 CREATE  INDEX "idx_comment_to_media" on "comment" using btree ( "to_media" "int4_ops" );
 
+
+create index idx_comment_webdb_create on comment(webdb_create);
+
+
+
 --
 
 --

diff --git a/templates-dist/admin/commentlist.template b/templates-dist/admin/commentlist.template
index 4e36ecd..8829768 100755 (executable)
--- a/templates-dist/admin/commentlist.template
+++ b/templates-dist/admin/commentlist.template
@@ -47,11 +47,11 @@
 <if data.contentlist>
   
   <list data.contentlist as entry>
-  <tr <transform compressWhitespace><if grey=="1"><assign grey="0">bgcolor="#dddddd" <else><assign grey="1"> </if></transform>>
+  <tr <if grey=="1"><assign grey="0">bgcolor="#dddddd" <else><assign grey="1"> </if> >
        <td>${entry.date}<br>
        <if entry.is_published=="0"><font color="Brown">V</font><else>-</if>
        </td>
-       
+
        <td>
                <b>${entry.title}</b><br>${entry.creator}
        </td>
@@ -77,6 +77,7 @@
     <td>&nbsp;</td>
   </tr>
 <tr><td>
+
 <if data.prev>
 <a href="${config.actionRoot}?module=Comment&do=list&order=${data.order}&query_text=${data.query_text_encoded}&query_field=${data.query_field}&query_is_published=${data.query_is_published}&query_media_folder=${data.query_media_folder}&offset=${data.prev}&prev=zur&uuml;ck">zurueck</a>&nbsp;
 </if>
@@ -88,7 +89,9 @@
   <tr><td align="center">${lang("no_matches_found")}</td></tr>
 </if>
 </table>
+
 <include "admin/foot.template">
+
 </body>
 </html>