source: extensions/see_photos_by_user/pagespba.php @ 26635

<?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');



?>