Changeset 659 for trunk/include/category_subcats.inc.php
- Timestamp:
- Dec 27, 2004, 3:30:49 PM (19 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/include/category_subcats.inc.php
r610 r659 70 70 FROM '.CATEGORIES_TABLE.' AS c INNER JOIN '.IMAGES_TABLE.' AS i 71 71 ON i.id = c.representative_picture_id 72 WHERE uppercats REGEXP \'(^|,)'.$row['id'].'(,|$)\' 72 WHERE uppercats REGEXP \'(^|,)'.$row['id'].'(,|$)\''; 73 // we must not show pictures of a forbidden category 74 if ($user['forbidden_categories'] != '') 75 { 76 $query.= ' 77 AND c.id NOT IN ('.$user['forbidden_categories'].')'; 78 } 79 $query.= ' 73 80 ORDER BY RAND() 74 81 LIMIT 0,1
Note: See TracChangeset
for help on using the changeset viewer.