Changeset 12629 for branches/2.3/include/functions_tag.inc.php
- Timestamp:
- Nov 15, 2011, 12:48:37 PM (12 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
branches/2.3/include/functions_tag.inc.php
r12118 r12629 167 167 * @return array 168 168 */ 169 function get_image_ids_for_tags($tag_ids, $mode='AND', $extra_images_where_sql='', $order_by='' )169 function get_image_ids_for_tags($tag_ids, $mode='AND', $extra_images_where_sql='', $order_by='', $use_permissions=true) 170 170 { 171 171 global $conf; … … 176 176 177 177 $query = 'SELECT id 178 FROM '.IMAGES_TABLE.' i 179 INNER JOIN '.IMAGE_CATEGORY_TABLE.' ic ON id=ic.image_id 178 FROM '.IMAGES_TABLE.' i '; 179 180 if ($use_permissions) 181 { 182 $query.= ' 183 INNER JOIN '.IMAGE_CATEGORY_TABLE.' ic ON id=ic.image_id'; 184 } 185 186 $query.= ' 180 187 INNER JOIN '.IMAGE_TAG_TABLE.' it ON id=it.image_id 181 WHERE tag_id IN ('.implode(',', $tag_ids).')' 182 .get_sql_condition_FandF 183 ( 184 array 185 ( 186 'forbidden_categories' => 'category_id', 187 'visible_categories' => 'category_id', 188 'visible_images' => 'id' 188 WHERE tag_id IN ('.implode(',', $tag_ids).')'; 189 190 if ($use_permissions) 191 { 192 $query.= get_sql_condition_FandF( 193 array( 194 'forbidden_categories' => 'category_id', 195 'visible_categories' => 'category_id', 196 'visible_images' => 'id' 189 197 ), 190 198 "\n AND" 191 ) 192 .(empty($extra_images_where_sql) ? '' : " \nAND (".$extra_images_where_sql.')') 193 .' 199 ); 200 } 201 202 $query.= (empty($extra_images_where_sql) ? '' : " \nAND (".$extra_images_where_sql.')').' 194 203 GROUP BY id'; 195 204
Note: See TracChangeset
for help on using the changeset viewer.