source: extensions/see_my_photos/pagessmp.php @ 27153

<?php
load_language('plugin.lang', SMP_PATH);

global $page, $conf, $user;
        $forbidden = get_sql_condition_FandF(
              array( 'visible_images' => 'id' ),
              'AND'
          );
$page['section'] = 'see_my_photos';

 $query = '
SELECT DISTINCT(id)
 FROM '.IMAGES_TABLE.'
 INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id
 WHERE added_by = \''.$user['id'].'\'
 '.$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'),
  )
 );
?>