source: extensions/see_my_photos/pagessmp.php @ 27486

<?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';
$page['section_title'] =  '<a href="'.get_absolute_root_url().'">'.l10n('Home').'</a>'.$conf['level_separator']. '<a href="'.get_absolute_root_url().'index.php?/see_my_photos">'.l10n('My photos').'</a>';

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