Changeset 27442 for extensions/see_photos_by_user

Timestamp:

Feb 20, 2014, 11:28:01 PM (10 years ago)

Author:

ddtddt

Message:

[extensions] - see_photos_by_user - bug desactivate plug - link direct user only for autorise user

Location:

extensions/see_photos_by_user

Files:

• main.inc.php (modified) (1 diff)
• maintain.inc.php (modified) (1 diff)

extensions/see_photos_by_user/main.inc.php

@@ -47 +47 @@
 function section_init_SPBA()
 {
- global $tokens;
+ global $tokens, $conf;
 $testa = explode('user-', $_SERVER['REQUEST_URI']); 
 if (!empty ($testa[1]))
 {
 $testd= explode('/', $testa[1]);
+$query = '
+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'].';';
+
+$result = pwg_query($query);
+$userok = array();
+while ($row = pwg_db_fetch_assoc($result))
+ {
+  $userok[] = $row['username'];
+}
+
+if (in_array($testd[0], $userok))
+{
 $me = 'user-'.$testd[0];
+}
+else
+{
+ $redirect_url = get_root_url().'index.php?/categories';
+ redirect($redirect_url);
+}
 }
 else

extensions/see_photos_by_user/maintain.inc.php

@@ -5 +5 @@
 function plugin_activate()
 {
+
+global $conf;
+
 if (!isset($conf['see_photos_by_user_nbphotos']))
  {