Changeset 27458 for extensions/Photo_add_by/initpicture.php

Timestamp:

Feb 23, 2014, 9:08:38 AM (10 years ago)

Author:

ddtddt

Message:

[extensions] - Photo_add_by - if plugin see photo by user is actif - can show link on user on picture page with parameter plugin see photo by user

File:

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

extensions/Photo_add_by/initpicture.php

@@ -17 +17 @@
  
   $search = '#<div id="'.$conf['Photo_add_by'].'" class="imageInfo">#';
-  
+
   $replacement = '
   {if $PAB}
@@ -49 +49 @@
 $row = pwg_db_fetch_assoc($result);
 $userab=$row['added_by'];
-  
+
   $query = '
 select '.$conf['user_fields']['username'].' AS username
@@ -59 +59 @@
 $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, IT.id
+ 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'].';';
 
-    // Envoi des données au template
-            $template->assign   (
-                array   (
-                'PAB' => $pab,
-                                )                       );
+$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-'.($pab);
+$pab2 ='<a href="'.$urlpab.'">'.$pab.'</a>';
+}
+else
+{
+$pab2=$pab;
+}
+}
+else
+{
+$pab2=$pab;
+}
+$template->assign(array('PAB' => $pab2,));
+
   }
 }