Changeset 6601


Ignore:
Timestamp:
06/24/10 22:22:21 (9 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.