art-web r555 - branches/art-hub/models

[thos svn gnome org]

Author: thos
Date: Sat Nov 22 23:23:03 2008
New Revision: 555
URL: http://svn.gnome.org/viewvc/art-web?rev=555&view=rev

Log:
Exclude "archive" content. This doesn't have license or author information.


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 Nov 22 23:23:03 2008
@@ -24,19 +24,23 @@
   var $get_items_sql = "SELECT * FROM background,user
             WHERE status='active' AND category = '%s'
             AND background.userID = user.userID
+            AND background.backgroundID > 1000
             ORDER BY %s LIMIT %s,%s";
 
   var $get_total_sql = "SELECT COUNT(name) FROM background
-            WHERE category = '%s' AND status='active'";
+            WHERE category = '%s' AND status='active'
+            AND background.backgroundID > 1000";
 
   var $search_items_sql = "SELECT * FROM background,user
             WHERE status='active'
             AND background.userID = user.userID
             AND (%s)
+            AND background.backgroundID > 1000
             ORDER BY %s LIMIT %s,%s";
 
   var $search_total_sql = "SELECT COUNT(*) FROM background
-            WHERE status='active' AND (%s)";
+            WHERE status='active' AND (%s)
+            AND background.backgroundID > 1000";
 
   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 Nov 22 23:23:03 2008
@@ -24,18 +24,22 @@
   var $get_items_sql = "SELECT * FROM theme,user
             WHERE status='active' AND category = '%s'
             AND theme.userID = user.userID
+            AND theme.themeID > 1000
             ORDER BY %s LIMIT %s,%s";
 
   var $get_total_sql = "SELECT COUNT(name) FROM theme
-            WHERE category = '%s' AND status='active'";
+            WHERE category = '%s' AND status='active'
+            AND theme.themeID > 1000";
 
   var $search_items_sql = "SELECT * FROM theme,user
             WHERE status='active' AND (%s)
             AND theme.userID = user.userID
+            AND theme.themeID > 1000
             ORDER BY %s LIMIT %s,%s";
 
   var $search_total_sql = "SELECT COUNT(name) FROM theme
-            WHERE (%s) AND status='active'";
+            WHERE (%s) AND status='active'
+            ORDER BY %s LIMIT %s,%s";
 }
 
 ?>