Changeset 582 for trunk/admin/include
- Timestamp:
- Oct 24, 2004, 8:57:19 PM (20 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/include/functions_metadata.php
r562 r582 67 67 { 68 68 global $conf; 69 69 70 if (!defined('CURRENT_DATE')) 71 { 72 define('CURRENT_DATE', "'".date('Y-m-d')."'"); 73 } 74 70 75 $inserts = array(); 71 76 … … 252 257 SELECT id, dir 253 258 FROM '.CATEGORIES_TABLE.' 259 WHERE dir IS NOT NULL 254 260 ;'; 255 261 $result = mysql_query($query); … … 266 272 $query = ' 267 273 SELECT id, uppercats 268 FROM '.CATEGORIES_TABLE; 274 FROM '.CATEGORIES_TABLE.' 275 WHERE site_id = 1 276 AND dir IS NOT NULL'; 269 277 if (is_numeric($category_id)) 270 278 { … … 272 280 { 273 281 $query.= ' 274 WHEREuppercats REGEXP \'(^|,)'.$category_id.'(,|$)\'282 AND uppercats REGEXP \'(^|,)'.$category_id.'(,|$)\' 275 283 '; 276 284 } … … 278 286 { 279 287 $query.= ' 280 WHEREid = '.$category_id.'288 AND id = '.$category_id.' 281 289 '; 282 290 }
Note: See TracChangeset
for help on using the changeset viewer.