Changeset 5654 for trunk/include/picture_comment.inc.php
- Timestamp:
- Apr 5, 2010, 12:50:12 AM (14 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/include/picture_comment.inc.php
r5649 r5654 89 89 if ($page['show_comments']) 90 90 { 91 if ( !is_admin() ) 92 { 93 $validated_clause = ' AND validated = \'true\''; 94 } 95 else 96 { 97 $validated_clause = ''; 98 } 99 91 100 // number of comments for this picture 92 101 $query = ' 93 SELECT COUNT(*) AS nb_comments 102 SELECT 103 COUNT(*) AS nb_comments 94 104 FROM '.COMMENTS_TABLE.' 95 WHERE image_id='.$page['image_id']." AND validated = 'true'"; 105 WHERE image_id = '.$page['image_id'] 106 .$validated_clause.' 107 ;'; 96 108 $row = pwg_db_fetch_assoc( pwg_query( $query ) ); 97 109 … … 119 131 if ($row['nb_comments'] > 0) 120 132 { 121 if ( !is_admin() )122 {123 $validated_clause = ' AND validated = \'true\'';124 }125 else126 {127 $validated_clause = '';128 }129 130 133 $query = ' 131 SELECT com.id,author,author_id,'.$conf['user_fields']['username'].' AS username, 132 date,image_id,content,validated 134 SELECT 135 com.id, 136 author, 137 author_id, 138 '.$conf['user_fields']['username'].' AS username, 139 date, 140 image_id, 141 content, 142 validated 133 143 FROM '.COMMENTS_TABLE.' AS com 134 144 LEFT JOIN '.USERS_TABLE.' AS u 135 145 ON u.'.$conf['user_fields']['id'].' = author_id 136 WHERE image_id = '.$page['image_id']. 137 $validated_clause.'146 WHERE image_id = '.$page['image_id'].' 147 '.$validated_clause.' 138 148 ORDER BY date ASC 139 149 LIMIT '.$conf['nb_comment_page'].' OFFSET '.$page['start'].'
Note: See TracChangeset
for help on using the changeset viewer.