Changeset 510 for trunk/include/category_default.inc.php

Timestamp:

Sep 1, 2004, 11:39:29 PM (20 years ago)

Author:

z0rglub

Message:

• new special category : random pictures

• reorganisation of special categories menu : template is used only for template. A special category is presented as the template tells to do so.

• favorites becomes just another special category

• bug correction for best rated category : wrong MySQL query if user has forbidden categories (see include/functions_category.inc.php diff)

File:

• trunk/include/category_default.inc.php (modified) (2 diffs)

trunk/include/category_default.inc.php

@@ -39 +39 @@
   
 $query = '
-SELECT DISTINCT(id),file,date_available
+SELECT DISTINCT(id),file,date_available,category_id
        ,tn_ext,name,filesize,storage_category_id,average_rate
   FROM '.IMAGES_TABLE.' AS i
@@ -114 +114 @@
   $thumbnail_title .= ' : '.$filesize.' KB';
   // url link on picture.php page
-  $url_link = PHPWG_ROOT_PATH.'picture.php?cat='.$page['cat'];
+  $url_link = PHPWG_ROOT_PATH.'picture.php?';
+  if ($page['cat'] == 'random')
+  {
+    $url_link.= 'cat='.$row['category_id'];
+  }
+  else
+  {
+   $url_link.= 'cat='.$page['cat'];
+  }
   $url_link.= '&image_id='.$row['id'];
   if ($page['cat'] == 'search')