Changeset 582

Timestamp:

Oct 24, 2004, 8:57:19 PM (19 years ago)

Author:

z0rglub

Message:

• bug correction : only local categories can be metadata synchronized

File:

• trunk/admin/include/functions_metadata.php (modified) (5 diffs)

trunk/admin/include/functions_metadata.php

@@ -67 +67 @@
 {
   global $conf;
-  
+
+  if (!defined('CURRENT_DATE'))
+  {
+    define('CURRENT_DATE', "'".date('Y-m-d')."'");
+  }
+
   $inserts = array();
 
@@ -252 +257 @@
 SELECT id, dir
   FROM '.CATEGORIES_TABLE.'
+  WHERE dir IS NOT NULL
 ;';
   $result = mysql_query($query);
@@ -266 +272 @@
   $query = '
 SELECT id, uppercats
-  FROM '.CATEGORIES_TABLE;
+  FROM '.CATEGORIES_TABLE.'
+  WHERE site_id = 1
+    AND dir IS NOT NULL';
   if (is_numeric($category_id))
   {
@@ -272 +280 @@
     {
       $query.= '
-  WHERE uppercats REGEXP \'(^|,)'.$category_id.'(,|$)\'
+    AND uppercats REGEXP \'(^|,)'.$category_id.'(,|$)\'
 ';
     }
@@ -278 +286 @@
     {
       $query.= '
-  WHERE id = '.$category_id.'
+    AND id = '.$category_id.'
 ';
     }