source: extensions/see_my_photos/pagessmp.php @ 26634

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


?>