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