art-web r546 - branches/art-hub/models

[thos svn gnome org]

Author: thos
Date: Sat Sep  6 16:55:21 2008
New Revision: 546
URL: http://svn.gnome.org/viewvc/art-web?rev=546&view=rev

Log:
* Fix total count SQL


Modified:
   branches/art-hub/models/backgrounds.php
   branches/art-hub/models/themes.php

Modified: branches/art-hub/models/backgrounds.php
==============================================================================
--- branches/art-hub/models/backgrounds.php	(original)
+++ branches/art-hub/models/backgrounds.php	Sat Sep  6 16:55:21 2008
@@ -9,7 +9,7 @@
             ORDER BY %s LIMIT %s,%s";
 
   var $get_total_sql = "SELECT COUNT(name) FROM background
-            WHERE category = '%s'";
+            WHERE category = '%s' AND status='active'";
 
   function get_resolutions ($backgroundID)
   {

Modified: branches/art-hub/models/themes.php
==============================================================================
--- branches/art-hub/models/themes.php	(original)
+++ branches/art-hub/models/themes.php	Sat Sep  6 16:55:21 2008
@@ -9,7 +9,7 @@
             ORDER BY %s LIMIT %s,%s";
 
   var $get_total_sql = "SELECT COUNT(name) FROM theme
-            WHERE category = '%s'";
+            WHERE category = '%s' AND status='active'";
 }
 
 ?>