Changeset 27458

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

Location:

extensions/Photo_add_by

Files:

• admin/admin.php (modified) (2 diffs)
• admin/admin.tpl (modified) (1 diff)
• initpicture.php (modified) (3 diffs)
• language/en_UK/plugin.lang.php (modified) (1 diff)
• language/fr_FR/plugin.lang.php (modified) (1 diff)
• main.inc.php (modified) (1 diff)
• maintain.inc.php (modified) (3 diffs)

extensions/Photo_add_by/admin/admin.php

@@ -45 +45 @@
         $options['Average'] = l10n('Rating score');
 
-        
-
   $template->assign(
     'gestionA',
     array(
       'OPTIONS' => $options,
-      'SELECTED' => $selected
+      'SELECTED' => $selected,
       ));
-   
 
-if (isset($_POST['infopab']))
+$PASPBY = pwg_db_fetch_assoc(pwg_query("SELECT state FROM " . PLUGINS_TABLE . " WHERE id = 'see_photos_by_user';"));
+if($PASPBY['state'] == 'active')
+{
+$PABS2T = array(
+    l10n('No'),
+    l10n('Yes'),
+  );
+  
+$PABS2 = array(
+    '0',
+    '1',
+  );
+
+  $template->assign(
+    'gestionB',
+    array(
+          'TOTO' => 'toto',
+      ));
+            global $conf;
+$template->assign('pabs2', $PABS2);
+$template->assign('pabs2t', $PABS2T);
+$template->assign('PABS', $conf['Photo_add_by_show']); 
+          
+}
+
+if (isset($_POST['submitpab']))
         {
 conf_update_param('Photo_add_by', $_POST['infopab']);
+if($PASPBY['state'] == 'active')
+{
+conf_update_param('Photo_add_by_show', $_POST['inspabs2']);
+  $template->assign(
+    'gestionB',
+    array(
+          'TOTO' => 'toto',
+      ));
+$template->assign('PABS', $_POST['inspabs2']); 
+}
 $template->delete_compiled_templates();
 array_push($page['infos'], l10n('Your configuration settings are saved'));
@@ -66 +98 @@
     array(
       'OPTIONS' => $options,
-      'SELECTED' => $selected
+      'SELECTED' => $selected,
       ));
-   
-
-
         }
   break;

extensions/Photo_add_by/admin/admin.tpl

@@ -3 +3 @@
 </div>
 {if isset ($gestionA)}
-        <div>
-                <form method="post" >
-                        <fieldset>
-                                <legend>{'Add information before'|@translate}</legend>
-                {html_options name="infopab" options=$gestionA.OPTIONS selected=$gestionA.SELECTED}
-                                <br>    
-                                <br>
-                                        <div style="text-align:center;">
-                                        <input class="submit" name="submitpab" type="submit" value="{'Save Settings'|@translate}">
-                                        </div>
-                        </fieldset>
-                </form>
-        </div>
+<div>
+<form method="post" >
+<fieldset>
+<legend></legend>
+ <p>
+  <strong>{'Add information before'|@translate}</strong>
+  {html_options name="infopab" options=$gestionA.OPTIONS selected=$gestionA.SELECTED}
+ </p>
+{if isset ($gestionB)}
+ <p>
+  <strong>{'Link on users'|@translate}</strong> 
+  {html_options name="inspabs2" values=$pabs2 output=$pabs2t selected="{$PABS}"}
+  ({'parameter show from the plugin'|@translate} "{'See photos by user'|@translate}")
+ </p>
 {/if}
+ <p>
+  <div style="text-align:center;">
+  <input class="submit" name="submitpab" type="submit" value="{'Save Settings'|@translate}">
+  </div>
+ </p>
+</fieldset>
+</form>
+</div>
+{/if}

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,));
+
   }
 }

extensions/Photo_add_by/language/en_UK/plugin.lang.php

@@ -2 +2 @@
 $lang['Photo added by'] = 'Photo added by';
 $lang['Add information before'] = 'Add information before';
+$lang['Link on users'] = 'Link on users';
+$lang['parameter show from the plugin'] = 'parameter show from the plugin';
 ?>

extensions/Photo_add_by/language/fr_FR/plugin.lang.php

@@ -2 +2 @@
 $lang['Photo added by'] = 'Photo Ajoutée par';
 $lang['Add information before'] = 'Ajouter l\'information avant';
+$lang['Link on users'] = 'Liens sur les utilisateurs';
+$lang['parameter show from the plugin'] = 'Parametre d\'affichage issus du plugin';
 ?>

extensions/Photo_add_by/main.inc.php

@@ -26 +26 @@
 function PAB_admin_menu($menu)
 {
+load_language('plugin.lang', PAB_PATH);
   array_push($menu, array(
-        'NAME' => 'Photo added by',
+        'NAME' => l10n('Photo added by'),
     'URL' => get_admin_plugin_menu_link(PAB_PATH . 'admin/admin.php')));
   return $menu;

extensions/Photo_add_by/maintain.inc.php

@@ -6 +6 @@
 function plugin_install()
 {
-        $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("Photo_add_by","datecreate","Photo_add_by");';
-    pwg_query($query);
+
 }
 
@@ -13 +12 @@
 {
   global $conf;
-  if (empty($conf['Photo_add_by']))
-  {
-        $query = 'INSERT INTO ' . CONFIG_TABLE . ' (param,value,comment) VALUES ("Photo_add_by","datecreate","Photo_add_by");';
-    pwg_query($query);
-  }
+if (!isset($conf['Photo_add_by']))
+ {
+ conf_update_param('Photo_add_by', 'datecreate');
+ }
+if (!isset($conf['Photo_add_by_show']))
+ {
+ conf_update_param('Photo_add_by_show', '0');
+ }
+  
+  
 }
 
@@ -23 +27 @@
 function plugin_uninstall()
 {
-        $q = 'DELETE FROM ' . CONFIG_TABLE . ' WHERE param="Photo_add_by" LIMIT 1;';
-    pwg_query($q);
+        conf_delete_param('Photo_add_by_show','Photo_add_by');
 }
 ?>