Changeset 6619 for extensions/virtualAutoGrant/virtual_categories_granted_to_creator.php

Timestamp:

Jun 29, 2010, 12:06:15 AM (14 years ago)

Author:

vdigital

Message:

Fix: Missing translations
Fix: Who can see in general case

Testing phase - unstable version

File:

• extensions/virtualAutoGrant/virtual_categories_granted_to_creator.php (modified) (4 diffs)

extensions/virtualAutoGrant/virtual_categories_granted_to_creator.php

@@ -38 +38 @@
     list($max_id) = pwg_db_fetch_row(pwg_query('SELECT MAX(id) FROM '.CATEGORIES_TABLE . ';'));
     $vag['lastcat before'] == $max_id;
+    list($max_id) = pwg_db_fetch_row(pwg_query('SELECT MAX(id) FROM '.IMAGES_TABLE . ';'));
+    $vag['lastimg before'] == $max_id;
     add_event_handler('loc_end_admin', 'VAG_grant_to_somebody');
     return $menu;
@@ -44 +46 @@
     function VAG_grant_to_somebody() {
       global $conf, $vag, $user;
-      if ( !isset($vag['lastcat before']) ) return false;
+      if ( empty($vag['lastcat before']) ) $vag['lastcat before'] = 0;
+      if ( empty($vag['lastimg before']) ) $vag['lastimg before'] = 0;
       list($new_id) = pwg_db_fetch_row(pwg_query('SELECT MAX(id) FROM '.CATEGORIES_TABLE
       . ' WHERE id > ' . $vag['lastcat before'] . ' AND site_id IS NULL;'));
@@ -54 +57 @@
         mass_inserts(USER_ACCESS_TABLE, array('user_id','cat_id'), $insert);
       }
-      // To do set level
+      // Who can see
+      if ( $vag['set_who_can_see'] == 0 ) return false;
+      if ( is_webmaster() and $vag['webmaster_set_who_can_see'] == 1) return false;
+      // New image_ids
+      $img_ids = array_from_query('SELECT id FROM ' . IMAGES_TABLE . ' WHERE id > ' . $vag['lastimg before'] . ';', 'id');
+      if (count($img_ids) == 0) return false;
+      // New image_ids which are associated to a public category at least
+      if ($vag['ignore_who_can_see_on_private'] == 1)
+        $img_ids = array_from_query('SELECT image_id FROM ' . IMAGE_CATEGORY_TABLE 
+            . ' WHERE category_id IN (SELECT id FROM ' . CATEGORIES_TABLE . ' WHERE status = \'public\')'
+            . ' AND image_id IN ('.implode(',', $img_ids).');');
+      $r = pwg_query('UPDATE '.IMAGES_TABLE.' SET level = ' . $user['level'] . ' WHERE level < '. $user['level'] 
+            . ' AND id IN ('.implode(',', $img_ids).');');
     }
   }
@@ -116 +131 @@
         array_push($menu, array(
                 'NAME' => 'Virtual AutoGrant',
-                'URL' => get_admin_plugin_menu_link(dirname(__FILE__).'/VAG_admin.php')
+                'URL' => get_admin_plugin_menu_link( VAG_PATH .'VAG_admin.php')
         ));
         return $menu;