Changeset 31465 for extensions/Photo_add_by/initpicture.php

Timestamp:

Mar 19, 2016, 9:01:52 PM (8 years ago)

Author:

ddtddt

Message:

[extensions] - Photo_add_by - 2.8

File:

• extensions/Photo_add_by/initpicture.php (modified) (2 diffs)

extensions/Photo_add_by/initpicture.php

@@ -1 +1 @@
 <?php
+// +-----------------------------------------------------------------------+
+// | Photo added by plugin for Piwigo                                      |
+// +-----------------------------------------------------------------------+
+// | Copyright(C) 2012-2016 ddtddt               http://temmii.com/piwigo/ |
+// +-----------------------------------------------------------------------+
+// | This program is free software; you can redistribute it and/or modify  |
+// | it under the terms of the GNU General Public License as published by  |
+// | the Free Software Foundation                                          |
+// |                                                                       |
+// | This program is distributed in the hope that it will be useful, but   |
+// | WITHOUT ANY WARRANTY; without even the implied warranty of            |
+// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU      |
+// | General Public License for more details.                              |
+// |                                                                       |
+// | You should have received a copy of the GNU General Public License     |
+// | along with this program; if not, write to the Free Software           |
+// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, |
+// | USA.                                                                  |
+// +-----------------------------------------------------------------------+
 
 //Ajout du prefiltre
@@ -32 +51 @@
 add_event_handler('loc_begin_picture', 'pab');
 
-function pab()
-{
+function pab(){
 global $conf, $page, $template;
 load_language('plugin.lang', PAB_PATH);
 load_language('lang', PHPWG_ROOT_PATH.PWG_LOCAL_DIR, array('no_fallback'=>true, 'local'=>true) );
 
-  if ( !empty($page['image_id']) )   
-  {
- 
-  $query = '
-select added_by
-  FROM ' . IMAGES_TABLE . '
-  WHERE id = \''.$page['image_id'].'\'
-  ;';
-$result = pwg_query($query);
-$row = pwg_db_fetch_assoc($result);
-$userab=$row['added_by'];
-
-  $query = '
-select '.$conf['user_fields']['username'].' AS username
-  FROM ' . USERS_TABLE . '
-  WHERE '.$conf['user_fields']['id'].' = \''.$userab.'\'
-  ;';
-$result = pwg_query($query);
-$row = pwg_db_fetch_assoc($result);
-$pab=$row['username'];
-
-$PASPBY = pwg_db_fetch_assoc(pwg_query("SELECT state FROM " . PLUGINS_TABLE . " WHERE id = 'see_photos_by_user';"));
-$showpab = $conf['Photo_add_by_show'];
-if($showpab == 1 and $PASPBY['state'] == 'active')
-{
-$query2 = '
-SELECT UT.id, UT.username, COUNT(DISTINCT(IT.id)) AS PBU
- FROM ' . USERS_TABLE . ' as UT
- INNER JOIN '.IMAGES_TABLE.' AS IT ON IT.added_by = UT.id
- INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON IT.id = ic.image_id
-  '.get_sql_condition_FandF
-  (
-    array
-      (
-        'forbidden_categories' => 'category_id',
-        'visible_categories' => 'category_id',
-        'visible_images' => 'id'
-      ),
-    'WHERE'
-  ).'
- GROUP BY IT.added_by
- HAVING PBU >'.$conf['see_photos_by_user_nbphotos'].'
- ORDER BY '.$conf['see_photos_by_user_order'].'
- LIMIT '.$conf['see_photos_by_user_limit'].';';
-
-$result2 = pwg_query($query2);
-
-$userok = array();
-while ($row2 = pwg_db_fetch_assoc($result2))
- {
-  $userok[] = $row2['username'];
-}
-if(in_array($pab, $userok) and $showpab == 1 and $PASPBY['state'] == 'active')
-{
-$urlpab = get_root_url().'index.php?/user-'.$userab.'-'.$pab;
-$pab2 ='<a href="'.$urlpab.'">'.$pab.'</a>';
-}
-else
-{
-$pab2=$pab;
-}
-}
-else
-{
-$pab2=$pab;
-}
-$template->assign(array('PAB' => $pab2,));
-
+  if ( !empty($page['image_id']) ){
+    $query = 'select added_by FROM ' . IMAGES_TABLE . ' WHERE id = \''.$page['image_id'].'\';';
+        $result = pwg_query($query);
+        $row = pwg_db_fetch_assoc($result);
+        $userab=$row['added_by'];
+        
+        $query = 'select '.$conf['user_fields']['username'].' AS username FROM ' . USERS_TABLE . ' WHERE '.$conf['user_fields']['id'].' = \''.$userab.'\';';
+        $result = pwg_query($query);
+        $row = pwg_db_fetch_assoc($result);
+        $pab=$row['username'];
+        
+        $PASPBY = pwg_db_fetch_assoc(pwg_query("SELECT state FROM " . PLUGINS_TABLE . " WHERE id = 'see_photos_by_user';"));
+        $showpab = $conf['Photo_add_by_show'];
+          if($showpab == 1 and $PASPBY['state'] == 'active'){
+                $query2 = 'SELECT UT.id, UT.username, COUNT(DISTINCT(IT.id)) AS PBU
+                  FROM ' . USERS_TABLE . ' as UT
+                  INNER JOIN '.IMAGES_TABLE.' AS IT ON IT.added_by = UT.id
+                  INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON IT.id = ic.image_id
+                    '.get_sql_condition_FandF
+                        (
+                        array
+           (
+                   'forbidden_categories' => 'category_id',
+                   'visible_categories' => 'category_id',
+                   'visible_images' => 'id'
+                   ),
+                   'WHERE'
+                   ).'
+                   GROUP BY IT.added_by
+           HAVING PBU >'.$conf['see_photos_by_user_nbphotos'].'
+                   ORDER BY '.$conf['see_photos_by_user_order'].'
+                   LIMIT '.$conf['see_photos_by_user_limit'].';';
+                $result2 = pwg_query($query2);
+                $userok = array();
+                while ($row2 = pwg_db_fetch_assoc($result2)){
+                  $userok[] = $row2['username'];
+                }
+                if(in_array($pab, $userok) and $showpab == 1 and $PASPBY['state'] == 'active'){
+                  $urlpab = get_root_url().'index.php?/user-'.$userab.'-'.$pab;
+                  $pab2 ='<a href="'.$urlpab.'">'.$pab.'</a>';
+                }else{
+                  $pab2=$pab;
+                }
+          }else{
+            $pab2=$pab;
+          }
+        $template->assign(array('PAB' => $pab2,));
   }
 }