source: extensions/see_my_photos/pagessmp.php @ 26634

Revision 26634, 692 bytes checked in by ddtddt, 6 years ago (diff)

[extensions] - see_my_photos - first commit

Line 
1<?php
2
3load_language('plugin.lang', SMP_PATH);
4
5global $page, $conf, $user;
6
7        $forbidden = get_sql_condition_FandF(
8              array( 'visible_images' => 'id' ),
9              'AND'
10          );
11
12$page['section'] = 'see_my_photos';
13
14    $query = '
15SELECT DISTINCT(id)
16  FROM '.IMAGES_TABLE.'
17  INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON id = ic.image_id
18  WHERE added_by = \''.$user['id'].'\'
19    '.$forbidden.'
20    '.$conf['order_by'].'
21;';
22
23    $page = array_merge(
24      $page,
25      array(
26        'title' => '<a href="'.duplicate_index_url(array('start'=>0)).'">'.l10n('See photos by author').'</a>',
27        'items' => array_from_query($query, 'id'),
28        )
29      );
30
31
32?>
Note: See TracBrowser for help on using the repository browser.