[art-web] [admin] only show active themes and background in listing



commit 8bf77a2786ee02cae0e9e1b569a7d929172e5225
Author: Thomas Wood <thos gnome org>
Date:   Sun Jan 3 23:20:31 2010 +0000

    [admin] only show active themes and background in listing

 admin.php |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)
---
diff --git a/admin.php b/admin.php
index 02a9ddc..6624bc5 100644
--- a/admin.php
+++ b/admin.php
@@ -232,10 +232,10 @@ else
 
   if ($section == 'theme')
     $sql = "SELECT themeID as artID, name, thumbnail_filename, status
-            FROM theme WHERE category='$category' AND themeID > 1000";
+            FROM theme WHERE category='$category' AND themeID > 1000 AND status='active'";
   else
     $sql = "SELECT backgroundID as artID, name, thumbnail_filename, status
-            FROM background WHERE category='$category' AND backgroundID > 1000";
+            FROM background WHERE category='$category' AND backgroundID > 1000 AND status='active'";
 
   $res = mysql_query ($sql);
 



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]