source: extensions/see_photos_by_user/pagespba.php @ 27153

<?php

load_language('plugin.lang', SPBA_PATH);

global $page, $conf, $user, $template;
$page['section'] = 'See_photos_by_author';
  
//read auteur list
$groups = array();
$query = '
select id,username
  FROM ' . USERS_TABLE . '
  WHERE id<>2 
  ORDER BY username ASC;';
$result = pwg_query($query);

while ($row = pwg_db_fetch_assoc($result))
 {
  $groups[$row['id']] = $row['username'];
}
  $selected = 0;
        $options[] = l10n('select user');
        $options['a'] = '----------------------';

  foreach ($groups as $metalist => $metalist2)
        {
   $options[$metalist] = $metalist2;
        }
  $template->assign(
    'gestionA',
    array(
      'OPTIONS' => $options,
      'SELECTED' => $selected
      ));
        
if (isset($_POST['submitchoixauteur']))
 {
     $forbidden = get_sql_condition_FandF(
     array( 'visible_images' => 'id' ),
    'AND'
          );
          
  $page['section'] = 'See_photos_by_author';

    $query = '
  SELECT DISTINCT(id)
  FROM '.IMAGES_TABLE.'
  INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id
  WHERE added_by = \''.$_POST['metalist'].'\'
    '.$forbidden.'
    '.$conf['order_by'].'
  ;';

   $page = array_merge(
  $page,
  array(
    'title' => '<a href="'.duplicate_index_url(array('start'=>0)).'">'.l10n('See photos by author').'</a>',
    'items' => array_from_query($query, 'id'),
      )
     );
          
//read auteur list
$groups = array();
$query = '
 select id,username
  FROM ' . USERS_TABLE . '
  WHERE id<>2 
  ORDER BY username ASC;';
$result = pwg_query($query);

while ($row = pwg_db_fetch_assoc($result))
        {
  $groups[$row['id']] = $row['username'];
        }
  $selected = $_POST['metalist'];

  foreach ($groups as $metalist => $metalist2)
        {
    $options[$metalist] = $metalist2;
        }
  $template->assign(
    'gestionA',
    array(
     'OPTIONS' => $options,
     'SELECTED' => $selected
     ));
 }
$template->assign('SPBA2', 'toto');
$template->set_filename('SPBA', realpath(SPBA_PATH.'pagespba.tpl'));
$template->assign_var_from_handle('CONTENT', 'SPBA');

?>