Changeset 9447 for extensions

Timestamp:

Mar 1, 2011, 12:02:26 PM (13 years ago)

Author:

plg

Message:

admins have no community permissions but full rights, no need to check for moderation, ths SQL query was crashing Piwigo

File:

• extensions/community/add_photos.php (modified) (2 diffs)

extensions/community/add_photos.php

@@ -108 +108 @@
   // events/parties/happyNewYear2011
   $moderate = true;
-  
-  $query = '
+  if (is_admin())
+  {
+    $moderate = false;
+  }
+  else
+  {  
+    $query = '
 SELECT
     cp.category_id,
@@ -118 +123 @@
     AND cp.moderated = \'false\'
 ;';
-  $result = pwg_query($query);
-  while ($row = pwg_db_fetch_assoc($result))
-  {
-    if (empty($row['category_id']))
-    {
-      $moderate = false;
-    }
-    elseif (preg_match('/^'.$row['uppercats'].'(,|$)/', $category_infos['uppercats']))
-    {
-      $moderate = false;
-    }
-  }
-
+    $result = pwg_query($query);
+    while ($row = pwg_db_fetch_assoc($result))
+    {
+      if (empty($row['category_id']))
+      {
+        $moderate = false;
+      }
+      elseif (preg_match('/^'.$row['uppercats'].'(,|$)/', $category_infos['uppercats']))
+      {
+        $moderate = false;
+      }
+    }
+  }
+  
   if ($moderate)
   {