1 | <?php |
---|
2 | |
---|
3 | if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!'); |
---|
4 | |
---|
5 | global $page, $user, $conf, $template; |
---|
6 | |
---|
7 | $page_save = $page; |
---|
8 | $tpl_save = $template->get_template_vars('THUMBNAILS'); |
---|
9 | |
---|
10 | if (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 = ' |
---|
30 | SELECT 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.rating_score IS NOT NULL'; |
---|
35 | |
---|
36 | if (isset($page['category'])) |
---|
37 | { |
---|
38 | $query .= ' |
---|
39 | AND ( c.uppercats LIKE \''.$page['category']['uppercats'].',%\' OR c.id = '.$page['category']['id'].' ) |
---|
40 | '; |
---|
41 | } |
---|
42 | |
---|
43 | $query .= ' |
---|
44 | '.$forbidden.' |
---|
45 | ORDER BY i.rating_score DESC, i.id DESC |
---|
46 | LIMIT 0, '.$datas['nb_images'].' |
---|
47 | ;'; |
---|
48 | |
---|
49 | $page['items'] = array_from_query($query, 'id'); |
---|
50 | $page['start'] = 0; |
---|
51 | $page['nb_image_page'] = $datas['nb_images']; |
---|
52 | $page['section'] = 'best_rated'; |
---|
53 | |
---|
54 | $tpl_thumbnails_var = array(); |
---|
55 | $pwg_stuffs_tpl_thumbnails_var = & $tpl_thumbnails_var; |
---|
56 | include(PHPWG_ROOT_PATH.'include/category_default.inc.php'); |
---|
57 | |
---|
58 | if (!empty($pwg_stuffs_tpl_thumbnails_var)) |
---|
59 | { |
---|
60 | $block['thumbnails'] = $pwg_stuffs_tpl_thumbnails_var; |
---|
61 | $block['derivative_params'] = ImageStdParams::get_by_type(IMG_THUMB); |
---|
62 | $block['TEMPLATE'] = 'stuffs_thumbnails.tpl'; |
---|
63 | } |
---|
64 | |
---|
65 | $page = $page_save; |
---|
66 | $template->assign('THUMBNAILS', $tpl_save); |
---|
67 | |
---|
68 | ?> |
---|