<?php
/*
Plugin Name: See photos by user
Version: auto
Description: See photos by user
Plugin URI: http://piwigo.org/ext/extension_view.php?eid=723
Author: ddtddt
Author URI: 
*/

if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');

define('SPBA_DIR' , basename(dirname(__FILE__)));
define('SPBA_PATH' , PHPWG_PLUGINS_PATH . SPBA_DIR . '/');
load_language('plugin.lang', SPBA_PATH);

global $conf;
$showSPBU = $conf['see_photos_by_user_show'];

if (in_array($showSPBU, array(1,3)))
{
add_event_handler('blockmanager_apply' , 'add_link_SPBA');
}
function add_link_SPBA($menu_ref_arr)
 {
  global $conf, $user;
  $menu = & $menu_ref_arr[0];
  if (($block = $menu->get_block('mbSpecials')) != null)
   {
   load_language('plugin.lang', SPBA_PATH);
   $position = (isset($conf['SPBA_position']) and is_numeric($conf['SPBA_position'])) ? $conf['SPBA_position'] : count($block->data)+1;
   array_splice
	 ($block->data, $position-1, 0, array
	  ('user-' =>
      array
			 (
			 'URL' => make_index_url(array('section' => 'user-')),
			 'TITLE' => l10n('See photos by user'),
			 'NAME' => l10n('See photos by user')
       )
    )
   );
   }
 }

add_event_handler('loc_end_section_init', 'section_init_SPBA');
function section_init_SPBA()
{
 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
{$me = 'user-';}

if (in_array($me, $tokens))
 include(SPBA_PATH . 'pagespba.php');
}

if (in_array($showSPBU, array(2,3,4)))
{
add_event_handler('blockmanager_register_blocks', 'register_users_menubar_blocks');
add_event_handler('blockmanager_apply', 'users_apply');
}
function register_users_menubar_blocks( $menu_ref_arr )
{
  $menu = & $menu_ref_arr[0];
  if ($menu->get_id() != 'menubar')
    return;
  $menu->register_block( new RegisteredBlock( 'mbUsers','Users',('See photos by user')));
}

function users_apply($menu_ref_arr)
{
global $template, $conf, $user;
$menu = & $menu_ref_arr[0];
load_language('plugin.lang', SPBA_PATH);
load_language('lang', PHPWG_ROOT_PATH.'local/', array('no_fallback'=>true, 'local'=>true));

$userslistemenu1 = pwg_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'].';');

if (pwg_db_num_rows($userslistemenu1)) {	
 while ($userslistemenu = pwg_db_fetch_assoc($userslistemenu1))
	{
    $items = array(
      'USERSSPBYL' => $userslistemenu['username'],
	  'USERSSPBYLC' => $userslistemenu['PBU'],
		);
		
	$template->append('userslistemenu1', $items);
  	}
}
$linkusersliste = get_root_url().'index.php?/user-';
$template->assign('USERSSPBY', $linkusersliste);
   
 if (($block = $menu->get_block( 'mbUsers' )) != null) {
 $template->set_template_dir(SPBA_PATH);
 $block->template = 'menubar_users.tpl';}
}

add_event_handler('get_admin_plugin_menu_links', 'SPBA_admin_menu');
function SPBA_admin_menu($menu)
{
  array_push(
    $menu,
    array(
      'NAME' => l10n('See photos by user'),
      'URL' => get_admin_plugin_menu_link(SPBA_PATH . 'admin.php')
	  //'URL' => get_root_url().'admin.php?page=plugin-See_photos_by_user'
      )
    );
  
  return $menu;
}

?>