source: extensions/PWG_Stuffs/trunk/modules/Recent/main.inc.php @ 16691

Last change on this file since 16691 was 16691, checked in by patdenice, 12 years ago

Compatible with piwigo 2.4

File size: 2.0 KB
Line 
1<?php
2
3if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');
4
5global $page, $user, $conf, $template;
6
7$page_save = $page;
8$tpl_save = $template->get_template_vars('THUMBNAILS');
9
10if (script_basename() == 'picture'
11  or ($datas['cat_display'] == 'wo_thumb' and !empty($page['items']))
12  or ($datas['cat_display'] == 'w_thumb' and empty($page['items']) and isset($page['category']))
13  or ($datas['cat_display'] == 'selected_cats' and isset($page['category']) and !in_array($page['category']['id'], $datas['cat_selection'])))
14{
15  return false;
16}
17
18$forbidden = get_sql_condition_FandF
19  (
20    array
21      (
22        'forbidden_categories' => 'ic.category_id',
23        'visible_categories' => 'ic.category_id',
24        'visible_images' => 'i.id'
25      ),
26    'AND'
27  );
28
29$query ='
30SELECT DISTINCT(i.id)
31  FROM '.IMAGES_TABLE.' AS i
32    INNER JOIN '.IMAGE_CATEGORY_TABLE.' AS ic ON i.id = ic.image_id
33    INNER JOIN '.CATEGORIES_TABLE.' AS c ON ic.category_id = c.id
34  WHERE i.date_available >= SUBDATE(
35      CURRENT_DATE,INTERVAL '.$user['recent_period'].' DAY)';
36
37if (isset($page['category']))
38{
39  $query .= '
40        AND ( c.uppercats LIKE \''.$page['category']['uppercats'].',%\' OR c.id = '.$page['category']['id'].' )
41  ';
42}
43
44$query .= '
45    '.$forbidden.'
46    ORDER BY  date_available DESC, i.id DESC
47    LIMIT 0, '.$datas['nb_images'].'
48  ;';
49 
50$page['items'] = array_from_query($query, 'id');
51$page['start'] = 0;
52$page['nb_image_page'] = $datas['nb_images'];
53$page['section'] = 'category';
54
55$tpl_thumbnails_var = array();
56$pwg_stuffs_tpl_thumbnails_var = & $tpl_thumbnails_var;
57include(PHPWG_ROOT_PATH.'include/category_default.inc.php');
58
59if (!empty($pwg_stuffs_tpl_thumbnails_var))
60{
61  $block['thumbnails'] = $pwg_stuffs_tpl_thumbnails_var;
62  $block['derivative_params'] = ImageStdParams::get_by_type(IMG_THUMB);
63  $block['TEMPLATE'] = 'stuffs_thumbnails.tpl';
64}
65
66$page = $page_save;
67$template->assign('THUMBNAILS', $tpl_save);
68
69?>
Note: See TracBrowser for help on using the repository browser.