Changeset 6601


Ignore:
Timestamp:
Jun 24, 2010, 10:22:21 PM (14 years ago)
Author:
nikrou
Message:

Bug 1735 fixed : amend commit 6596
Need to add permissions filter to retrieve categories

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/comments.php

    r6596 r6601  
    368368       com.validated
    369369  FROM '.IMAGE_CATEGORY_TABLE.' AS ic
    370     LEFT JOIN '.COMMENTS_TABLE.' AS com
     370    INNER JOIN '.COMMENTS_TABLE.' AS com
    371371    ON ic.image_id = com.image_id
    372372    LEFT JOIN '.USERS_TABLE.' As u
     
    419419  LEFT JOIN '.COMMENTS_TABLE.' AS com
    420420  ON ic.image_id=com.image_id
     421  '.get_sql_condition_FandF
     422    (
     423      array
     424      (
     425        'forbidden_categories' => 'c.id',
     426        'visible_categories' => 'c.id'
     427       ),
     428      'WHERE'
     429     ).'
    421430;';
    422431  $categories = hash_from_query($query, 'comment_id');
Note: See TracChangeset for help on using the changeset viewer.