Changeset 1648 for trunk/include/functions_category.inc.php
- Timestamp:
- Dec 10, 2006, 11:48:32 PM (17 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/include/functions_category.inc.php
r1641 r1648 68 68 FROM '.CATEGORIES_TABLE.' INNER JOIN '.USER_CACHE_CATEGORIES_TABLE.' 69 69 ON id = cat_id and user_id = '.$user['id']; 70 if ( !$user['expand'])70 if ($page['filter_mode']) 71 71 { 72 72 $query.= ' 73 WHERE (id_uppercat is NULL'; 74 if (isset($page['category'])) 75 { 76 $query.= ' OR id_uppercat IN ('.$page['uppercats'].')'; 77 } 78 $query.= ')'; 73 where max_date_last > SUBDATE( 74 CURRENT_DATE,INTERVAL '.$user['recent_period'].' DAY)'; 75 } 76 else 77 { 78 // Always expand when filter_mode is activated 79 if (!$user['expand']) 80 { 81 $query.= ' 82 WHERE (id_uppercat is NULL'; 83 if (isset($page['category'])) 84 { 85 $query.= ' OR id_uppercat IN ('.$page['uppercats'].')'; 86 } 87 $query.= ')'; 88 } 79 89 } 80 90 $query.= '
Note: See TracChangeset
for help on using the changeset viewer.