1 | <?php |
---|
2 | defined('USER_COLLEC_PATH') or die('Hacking attempt!'); |
---|
3 | |
---|
4 | // collections orders |
---|
5 | if (isset($_GET['uc_collection_order'])) |
---|
6 | { |
---|
7 | if ( (int)$_GET['uc_collection_order'] > 0) |
---|
8 | { |
---|
9 | pwg_set_session_var('uc_collection_order', (int)$_GET['uc_collection_order']); |
---|
10 | } |
---|
11 | else |
---|
12 | { |
---|
13 | pwg_unset_session_var('uc_collection_order'); |
---|
14 | } |
---|
15 | redirect(USER_COLLEC_PUBLIC); |
---|
16 | } |
---|
17 | |
---|
18 | $col_order_id = pwg_get_session_var('uc_collection_order', 0); |
---|
19 | $orders = get_collections_preferred_orders(); |
---|
20 | |
---|
21 | |
---|
22 | // get sorted collections |
---|
23 | $query = ' |
---|
24 | SELECT * |
---|
25 | FROM '.COLLECTIONS_TABLE.' |
---|
26 | WHERE user_id = '.$user['id'].' |
---|
27 | ORDER BY '.$orders[$col_order_id][1].' |
---|
28 | '; |
---|
29 | $categories = hash_from_query($query, 'id'); |
---|
30 | |
---|
31 | $template->assign('COLLECTIONS_COUNT', count($categories)); |
---|
32 | |
---|
33 | |
---|
34 | // order menu |
---|
35 | if (count($categories)) |
---|
36 | { |
---|
37 | $url = add_url_params(USER_COLLEC_PUBLIC, array('uc_collection_order' => '')); |
---|
38 | |
---|
39 | foreach ($orders as $order_id => $order) |
---|
40 | { |
---|
41 | if ($order[2]) |
---|
42 | { |
---|
43 | $template->append( |
---|
44 | 'image_orders', |
---|
45 | array( |
---|
46 | 'DISPLAY' => $order[0], |
---|
47 | 'URL' => $url.$order_id, |
---|
48 | 'SELECTED' => ($col_order_id == $order_id ? true:false), |
---|
49 | ) |
---|
50 | ); |
---|
51 | } |
---|
52 | } |
---|
53 | } |
---|
54 | |
---|
55 | |
---|
56 | // collections details |
---|
57 | if (count($categories)) |
---|
58 | { |
---|
59 | $query = ' |
---|
60 | SELECT * FROM ( |
---|
61 | SELECT |
---|
62 | i.*, |
---|
63 | ci.col_id |
---|
64 | FROM '.IMAGES_TABLE.' AS i |
---|
65 | INNER JOIN '.COLLECTION_IMAGES_TABLE.' AS ci |
---|
66 | ON i.id = ci.image_id |
---|
67 | WHERE col_id IN('.implode(',', array_keys($categories)).') |
---|
68 | ORDER BY ci.add_date DESC |
---|
69 | ) AS t |
---|
70 | GROUP BY col_id |
---|
71 | ;'; |
---|
72 | $thumbnails = hash_from_query($query, 'col_id'); |
---|
73 | |
---|
74 | $thumbnails[0] = array( |
---|
75 | 'id' => 0, |
---|
76 | 'path' => 'themes/default/icon/img_small.png', |
---|
77 | 'picture_ext' => 'png', |
---|
78 | 'width' => 32, |
---|
79 | 'height' => 32, |
---|
80 | 'rotation' => 0, |
---|
81 | ); |
---|
82 | |
---|
83 | foreach ($thumbnails as &$info) |
---|
84 | { |
---|
85 | $info['src_image'] = new SrcImage($info); |
---|
86 | } |
---|
87 | unset($info); |
---|
88 | |
---|
89 | $tpl_thumbnails_var = array(); |
---|
90 | |
---|
91 | foreach ($categories as $category) |
---|
92 | { |
---|
93 | $thumb = empty($thumbnails[ $category['id'] ]) ? $thumbnails[0] : $thumbnails[ $category['id'] ]; |
---|
94 | $counter = get_display_images_count($category['nb_images'], $category['nb_images'], 0); |
---|
95 | |
---|
96 | $tpl_var = array_merge($category, array( |
---|
97 | 'representative' => $thumb, |
---|
98 | 'TN_ALT' => strip_tags($category['name']), |
---|
99 | 'URL' => USER_COLLEC_PUBLIC.'edit/'.$category['id'], |
---|
100 | 'CAPTION_NB_IMAGES' => empty($counter) ? l10n('%d photo', 0) : $counter, |
---|
101 | 'NAME' => trigger_change('render_category_name', $category['name']), |
---|
102 | 'DESCRIPTION' => trigger_change('render_category_description', $category['comment'], 'subcatify_category_description'), |
---|
103 | 'INFO_DATES' => format_date($category['date_creation'], true), |
---|
104 | 'U_DELETE' => add_url_params(USER_COLLEC_PUBLIC, array('action'=>'delete','col_id'=>$category['id'])), |
---|
105 | )); |
---|
106 | |
---|
107 | $tpl_thumbnails_var[] = $tpl_var; |
---|
108 | } |
---|
109 | |
---|
110 | $derivative_params = trigger_change('get_index_album_derivative_params', ImageStdParams::get_by_type(IMG_THUMB) ); |
---|
111 | $template->assign(array( |
---|
112 | 'maxRequests' => $conf['max_requests'], |
---|
113 | 'category_thumbnails' => $tpl_thumbnails_var, |
---|
114 | 'derivative_params' => $derivative_params, |
---|
115 | )); |
---|
116 | |
---|
117 | $template->set_filename('index_category_thumbnails', 'mainpage_categories.tpl'); |
---|
118 | $template->assign_var_from_handle('CATEGORIES', 'index_category_thumbnails'); |
---|
119 | } |
---|