Changeset 27486 for extensions

Timestamp:

Feb 24, 2014, 9:59:26 PM (11 years ago)

Author:

ddtddt

Message:

[extensions] - see_my_photos - change permission - link

Location:

extensions/see_my_photos

Files:

• main.inc.php (modified) (1 diff)
• pagessmp.php (modified) (1 diff)

extensions/see_my_photos/main.inc.php

@@ -27 +27 @@
   FROM '.IMAGES_TABLE.'
   INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id
-  WHERE added_by = \''.$user['id'].'\'
+    '.get_sql_condition_FandF
+  (
+    array
+      (
+        'forbidden_categories' => 'category_id',
+        'visible_categories' => 'category_id',
+        'visible_images' => 'id'
+      ),
+    'WHERE'
+  ).'
+  AND added_by = \''.$user['id'].'\'
 ;';
   $result = pwg_query($query);

extensions/see_my_photos/pagessmp.php

@@ -8 +8 @@
           );
 $page['section'] = 'see_my_photos';
+$page['section_title'] =  '<a href="'.get_absolute_root_url().'">'.l10n('Home').'</a>'.$conf['level_separator']. '<a href="'.get_absolute_root_url().'index.php?/see_my_photos">'.l10n('My photos').'</a>';
 
- $query = '
+$query = '
 SELECT DISTINCT(id)
  FROM '.IMAGES_TABLE.'
  INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id
- WHERE added_by = \''.$user['id'].'\'
- '.$forbidden.'
+ '.get_sql_condition_FandF
+  (
+    array
+      (
+        'forbidden_categories' => 'category_id',
+        'visible_categories' => 'category_id',
+        'visible_images' => 'id'
+      ),
+    'WHERE'
+  ).'
+ AND added_by = \''.$user['id'].'\'
  '.$conf['order_by'].'
 ;';