Changeset 1741

Timestamp:

07/04/07 17:12:51 (17 months ago)

Author:

mbonetti

Message:

we only want actual item tags, no categories, thank you

Files:

• trunk/gregarius/admin/tags.php (modified) (1 diff)

trunk/gregarius/admin/tags.php

@@ -142 +142 @@
     ."</tr>\n";
 
-    $sql = "select id,tag from " .getTable("tag") . " order by tag asc";
+    $sql = sprintf("select id, tag from %s t left join %s m on (t.id = m.tid) where m.ttype = 'item'", getTable("tag"), getTable("metatag"));
     $res = rss_query($sql);
     $cntr = 0;