These results are based on our legacy PHP analysis, consider migrating to our new PHP analysis engine instead. Learn more
1 | <?php |
||
2 | /* |
||
3 | ------------------------------------------------------------------------- |
||
4 | ADSLIGHT 2 : Module for Xoops |
||
5 | |||
6 | Redesigned and ameliorate By Luc Bizet user at www.frxoops.org |
||
7 | Started with the Classifieds module and made MANY changes |
||
8 | Website : http://www.luc-bizet.fr |
||
9 | Contact : [email protected] |
||
10 | ------------------------------------------------------------------------- |
||
11 | Original credits below Version History |
||
12 | ########################################################################## |
||
13 | # Classified Module for Xoops # |
||
14 | # By John Mordo user jlm69 at www.xoops.org and www.jlmzone.com # |
||
15 | # Started with the MyAds module and made MANY changes # |
||
16 | ########################################################################## |
||
17 | Original Author: Pascal Le Boustouller |
||
18 | Author Website : [email protected] |
||
19 | Licence Type : GPL |
||
20 | ------------------------------------------------------------------------- |
||
21 | */ |
||
22 | |||
23 | include_once __DIR__ . '/header.php'; |
||
24 | require XOOPS_ROOT_PATH . '/modules/adslight/include/gtickets.php'; |
||
25 | xoops_load('XoopsLocal'); |
||
26 | $tempXoopsLocal = new XoopsLocal; |
||
27 | $myts = MyTextSanitizer::getInstance(); |
||
28 | $module_id = $xoopsModule->getVar('mid'); |
||
29 | |||
30 | View Code Duplication | if (is_object($GLOBALS['xoopsUser'])) { |
|
31 | $groups = $GLOBALS['xoopsUser']->getGroups(); |
||
32 | } else { |
||
33 | $groups = XOOPS_GROUP_ANONYMOUS; |
||
34 | } |
||
35 | $gpermHandler = xoops_getHandler('groupperm'); |
||
36 | if (isset($_POST['item_id'])) { |
||
37 | $perm_itemid = (int)$_POST['item_id']; |
||
38 | } else { |
||
39 | $perm_itemid = 0; |
||
40 | } |
||
41 | |||
42 | View Code Duplication | if (!$gpermHandler->checkRight('adslight_view', $perm_itemid, $groups, $module_id)) { |
|
43 | redirect_header(XOOPS_URL . '/index.php', 3, _NOPERM); |
||
44 | } |
||
45 | if (!$gpermHandler->checkRight('adslight_premium', $perm_itemid, $groups, $module_id)) { |
||
46 | $prem_perm = '0'; |
||
47 | } else { |
||
48 | $prem_perm = '1'; |
||
49 | } |
||
50 | |||
51 | include XOOPS_ROOT_PATH . '/modules/adslight/class/classifiedstree.php'; |
||
52 | //include XOOPS_ROOT_PATH . '/modules/adslight/class/utilities.php'; |
||
53 | $mytree = new ClassifiedsTree($xoopsDB->prefix('adslight_categories'), 'cid', 'pid'); |
||
54 | |||
55 | # function view (categories) |
||
56 | ##################################################### |
||
57 | /** |
||
58 | * @param int $cid |
||
59 | * @param int $min |
||
60 | * @param $orderby |
||
61 | * @param int $show |
||
62 | */ |
||
63 | function adsView($cid = 0, $min = 0, $orderby, $show = 0) |
||
64 | { |
||
65 | global $xoopsDB, $xoopsTpl, $xoopsConfig, $myts, $mytree, $imagecat, $meta, $moduleDirName, $main_lang, $mid, $prem_perm, $xoopsModule; |
||
66 | $pathIcon16 = $xoopsModule->getInfo('icons16'); |
||
67 | |||
68 | $GLOBALS['xoopsOption']['template_main'] = 'adslight_category.tpl'; |
||
69 | include XOOPS_ROOT_PATH . '/header.php'; |
||
70 | |||
71 | $xoopsTpl->assign('xmid', $xoopsModule->getVar('mid')); |
||
72 | $xoopsTpl->assign('add_from', _ADSLIGHT_ADDFROM . ' ' . $xoopsConfig['sitename']); |
||
73 | $xoopsTpl->assign('add_from_title', _ADSLIGHT_ADDFROM); |
||
74 | $xoopsTpl->assign('add_from_sitename', $xoopsConfig['sitename']); |
||
75 | $xoopsTpl->assign('only_pix', _ADSLIGHT_ONLYPIX); |
||
76 | $xoopsTpl->assign('adslight_logolink', _ADSLIGHT_LOGOLINK); |
||
77 | $xoopsTpl->assign('permit', $prem_perm); |
||
78 | |||
79 | $xoopsTpl->assign('xoops_module_header', '<link rel="stylesheet" href="' . XOOPS_URL . '/modules/adslight/assets/css/adslight.css" type="text/css" media="all" />'); |
||
80 | |||
81 | // $adslight_use_catscode = $GLOBALS['xoopsModuleConfig']['adslight_use_catscode']; |
||
82 | // $adslight_cats_code = $GLOBALS['xoopsModuleConfig']['adslight_cats_code']; |
||
83 | |||
84 | $xoopsTpl->assign('adslight_use_catscode', $GLOBALS['xoopsModuleConfig']['adslight_use_catscode']); |
||
85 | $xoopsTpl->assign('adslight_cats_code', $GLOBALS['xoopsModuleConfig']['adslight_cats_code']); |
||
86 | |||
87 | $banner = xoops_getbanner(); |
||
88 | $xoopsTpl->assign('banner', $banner); |
||
89 | // $index_code_place = $GLOBALS['xoopsModuleConfig']['adslight_index_code_place']; |
||
90 | // $use_extra_code = $GLOBALS['xoopsModuleConfig']['adslight_use_index_code']; |
||
91 | // $adslight_use_banner = $GLOBALS['xoopsModuleConfig']['adslight_use_banner']; |
||
92 | // $index_extra_code = $GLOBALS['xoopsModuleConfig']['adslight_index_code']; |
||
93 | |||
94 | $xoopsTpl->assign('use_extra_code', $GLOBALS['xoopsModuleConfig']['adslight_use_index_code']); |
||
95 | $xoopsTpl->assign('adslight_use_banner', $GLOBALS['xoopsModuleConfig']['adslight_use_banner']); |
||
96 | $xoopsTpl->assign('index_extra_code', $GLOBALS['xoopsModuleConfig']['adslight_index_code']); |
||
97 | $xoopsTpl->assign('index_code_place', $GLOBALS['xoopsModuleConfig']['adslight_index_code_place']); |
||
98 | |||
99 | // adslight 2 |
||
100 | $xoopsTpl->assign('adslight_active_menu', $GLOBALS['xoopsModuleConfig']['adslight_active_menu']); |
||
101 | $xoopsTpl->assign('adslight_active_rss', $GLOBALS['xoopsModuleConfig']['adslight_active_rss']); |
||
102 | |||
103 | /// No Adds in this Cat /// |
||
104 | $submit_perms = AdslightUtilities::getMyItemIds('adslight_submit'); |
||
105 | |||
106 | if ($GLOBALS['xoopsUser'] && is_array($submit_perms) && count($submit_perms) > 0) { |
||
107 | $xoopsTpl->assign('not_adds_in_this_cat', |
||
108 | '' . _ADSLIGHT_ADD_LISTING_NOTADDSINTHISCAT . '<a href="addlisting.php?cid=' . addslashes($cid) . '">' . _ADSLIGHT_ADD_LISTING_NOTADDSSUBMIT . '</a>'); |
||
109 | } else { |
||
110 | $xoopsTpl->assign('not_adds_in_this_cat', |
||
111 | '' . _ADSLIGHT_ADD_LISTING_NOTADDSINTHISCAT . '<br>' . _ADSLIGHT_ADD_LISTING_BULL . '<a href="' . XOOPS_URL . '/register.php">' . _ADSLIGHT_ADD_LISTING_SUB . '</a>.'); |
||
112 | } |
||
113 | |||
114 | $xoopsTpl->assign('Feed_RSS_cat', ' <a href="rss.php?cid=' . addslashes($cid) . '"><img border="0" alt="Feed RSS" src="assets/images/rssfeed_buttons.png" /></a>'); |
||
115 | |||
116 | View Code Duplication | if ($GLOBALS['xoopsUser']) { |
|
1 ignored issue
–
show
|
|||
117 | $member_usid = $GLOBALS['xoopsUser']->getVar('uid'); |
||
118 | if ($usid = $member_usid) { |
||
119 | $xoopsTpl->assign('istheirs', true); |
||
120 | |||
121 | list($show_user) = $xoopsDB->fetchRow($xoopsDB->query('SELECT COUNT(*) FROM ' . $xoopsDB->prefix('adslight_listing') . ' WHERE usid=' . $member_usid . '')); |
||
122 | |||
123 | $xoopsTpl->assign('show_user', $show_user); |
||
124 | $xoopsTpl->assign('show_user_link', 'members.php?usid=' . $member_usid . ''); |
||
125 | } |
||
126 | } |
||
127 | |||
128 | $default_sort = $GLOBALS['xoopsModuleConfig']['adslight_lsort_order']; |
||
129 | |||
130 | $cid = ((int)$cid > 0) ? (int)$cid : 0; |
||
131 | $min = ((int)$min > 0) ? (int)$min : 0; |
||
132 | $show = ((int)$show > 0) ? (int)$show : $GLOBALS['xoopsModuleConfig']['adslight_perpage']; |
||
133 | $max = $min + $show; |
||
134 | $orderby = isset($orderby) ? AdslightUtilities::convertOrderByIn($orderby) : $default_sort; |
||
135 | |||
136 | $updir = $GLOBALS['xoopsModuleConfig']['adslight_link_upload']; |
||
137 | $xoopsTpl->assign('add_from', _ADSLIGHT_ADDFROM . ' ' . $xoopsConfig['sitename']); |
||
138 | $xoopsTpl->assign('add_from_title', _ADSLIGHT_ADDFROM); |
||
139 | $xoopsTpl->assign('add_from_sitename', $xoopsConfig['sitename']); |
||
140 | $xoopsTpl->assign('subcat_title2', _ADSLIGHT_ANNONCES); |
||
141 | |||
142 | $categories = AdslightUtilities::getMyItemIds('adslight_view'); |
||
143 | View Code Duplication | if (is_array($categories) && count($categories) > 0) { |
|
144 | if (!in_array($cid, $categories)) { |
||
145 | redirect_header(XOOPS_URL . '/modules/adslight/index.php', 3, _NOPERM); |
||
146 | } |
||
147 | } else { // User can't see any category |
||
148 | redirect_header(XOOPS_URL . '/index.php', 3, _NOPERM); |
||
149 | } |
||
150 | |||
151 | $arrow = '<img src="' . XOOPS_URL . '/modules/adslight/assets/images/arrow.gif" alt="»" />'; |
||
152 | |||
153 | $pathstring = '<a href="index.php">' . _ADSLIGHT_MAIN . '</a>'; |
||
154 | $pathstring .= $mytree->getNicePathFromId($cid, 'title', 'viewcats.php?'); |
||
155 | $xoopsTpl->assign('module_name', $xoopsModule->getVar('name')); |
||
156 | $xoopsTpl->assign('category_path', $pathstring); |
||
157 | $xoopsTpl->assign('category_id', $cid); |
||
158 | |||
159 | $countresult = $xoopsDB->query('SELECT COUNT(*) FROM ' . $xoopsDB->prefix('adslight_listing') . ' WHERE cid=' . $xoopsDB->escape($cid) . ' AND valid="Yes" AND status!="1"'); |
||
160 | list($trow) = $xoopsDB->fetchRow($countresult); |
||
161 | $trows = $trow; |
||
162 | |||
163 | $cat_perms = ''; |
||
164 | if (is_array($categories) && count($categories) > 0) { |
||
165 | $cat_perms .= ' AND cid IN (' . implode(',', $categories) . ') '; |
||
166 | } |
||
167 | |||
168 | $result = $xoopsDB->query('SELECT cid, pid, title, cat_desc, cat_keywords FROM ' . $xoopsDB->prefix('adslight_categories') . ' WHERE cid=' . $xoopsDB->escape($cid) . ' ' . $cat_perms . ''); |
||
169 | list($cid, $pid, $title, $cat_desc, $cat_keywords) = $xoopsDB->fetchRow($result); |
||
170 | |||
171 | $xoopsTpl->assign('cat_desc', $cat_desc); |
||
172 | $xoopsTpl->assign('cat_title', _ADSLIGHT_ANNONCES . ' ' . $title); |
||
173 | $xoopsTpl->assign('cat_keywords', $cat_keywords); |
||
174 | $xoopsTpl->assign('xoops_pagetitle', $title); |
||
175 | |||
176 | if ($cat_desc > '0') { |
||
177 | // meta description & keywords tags for categories |
||
178 | $cat_desc_clean = strip_tags($cat_desc, '<font><img><strong><i><u>'); |
||
179 | $cat_keywords_clean = strip_tags($cat_keywords, '<font><img><strong><i><u><br><li>'); |
||
180 | |||
181 | $xoTheme->addMeta('meta', 'description', '' . substr($cat_desc_clean, 0, 200)); |
||
182 | $xoTheme->addMeta('meta', 'keywords', '' . substr($cat_keywords_clean, 0, 1000)); |
||
183 | } |
||
184 | |||
185 | $submit_perms = AdslightUtilities::getMyItemIds('adslight_submit'); |
||
186 | if ($GLOBALS['xoopsUser'] && is_array($submit_perms) && count($submit_perms) > 0) { |
||
187 | $add_listing = '' . _ADSLIGHT_ADD_LISTING_BULLCATS . '<a href="addlisting.php?cid=' . addslashes($cid) . '">' . _ADSLIGHT_ADD_LISTING_SUBOK . '</a> |
||
188 | '; |
||
189 | } else { // User can't see any category |
||
190 | $add_listing = '' . _ADSLIGHT_ADD_LISTING_BULLCATSOK . '<a href="' . XOOPS_URL . '/register.php">' . _ADSLIGHT_ADD_LISTING_SUB . '</a>. |
||
191 | '; |
||
192 | } |
||
193 | |||
194 | if ($GLOBALS['xoopsModuleConfig']['adslight_main_cat'] == 1 || $pid != 0) { |
||
195 | $xoopsTpl->assign('bullinfotext', $add_listing); |
||
196 | } |
||
197 | |||
198 | $arr = array(); |
||
199 | $arr = $mytree->getFirstChild($cid, 'title'); |
||
200 | |||
201 | if (count($arr) > 0) { |
||
202 | $scount = 1; |
||
203 | foreach ($arr as $ele) { |
||
204 | if (in_array($ele['cid'], $categories)) { |
||
205 | $sub_arr = array(); |
||
206 | $sub_arr = $mytree->getFirstChild($ele['cid'], 'title'); |
||
207 | $space = 0; |
||
208 | $chcount = 0; |
||
209 | $infercategories = ''; |
||
210 | $totallisting = AdslightUtilities::getTotalItems($ele['cid'], 1); |
||
211 | foreach ($sub_arr as $sub_ele) { |
||
212 | if (in_array($sub_ele['cid'], $categories)) { |
||
213 | $chtitle = $myts->htmlSpecialChars($sub_ele['title']); |
||
214 | |||
215 | if ($chcount > 5) { |
||
216 | $infercategories .= '...'; |
||
217 | break; |
||
218 | } |
||
219 | if ($space > 0) { |
||
220 | $infercategories .= ', '; |
||
221 | } |
||
222 | $infercategories .= '<a href="' . XOOPS_URL . '/modules/adslight/viewcats.php?cid=' . $sub_ele['cid'] . '">' . $chtitle . '</a>'; |
||
223 | |||
224 | $infercategories .= ' (' . AdslightUtilities::getTotalItems($sub_ele['cid']) . ')'; |
||
225 | $infercategories .= ' ' . categorynewgraphic($sub_ele['cid']) . ''; |
||
226 | ++$space; |
||
227 | ++$chcount; |
||
228 | } |
||
229 | } |
||
230 | |||
231 | $xoopsTpl->append('subcategories', array( |
||
232 | 'title' => $myts->htmlSpecialChars($ele['title']), |
||
233 | 'id' => $ele['cid'], |
||
234 | 'infercategories' => $infercategories, |
||
235 | 'totallisting' => $totallisting, |
||
236 | '' |
||
237 | )); |
||
238 | |||
239 | ++$scount; |
||
240 | $xoopsTpl->assign('lang_subcat', _ADSLIGHT_AVAILAB); |
||
241 | } |
||
242 | } |
||
243 | } |
||
244 | |||
245 | $pagenav = ''; |
||
246 | if ($trows > '0') { |
||
247 | $xoopsTpl->assign('last_head', _ADSLIGHT_THE . ' ' . $GLOBALS['xoopsModuleConfig']['adslight_newcount'] . ' ' . _ADSLIGHT_LASTADD); |
||
248 | $xoopsTpl->assign('last_head_title', _ADSLIGHT_TITLE); |
||
249 | $xoopsTpl->assign('last_head_price', _ADSLIGHT_PRICE); |
||
250 | $xoopsTpl->assign('last_head_date', _ADSLIGHT_DATE); |
||
251 | $xoopsTpl->assign('last_head_local', _ADSLIGHT_LOCAL2); |
||
252 | $xoopsTpl->assign('last_head_hits', _ADSLIGHT_VIEW); |
||
253 | $xoopsTpl->assign('last_head_photo', _ADSLIGHT_PHOTO); |
||
254 | $xoopsTpl->assign('cat', $cid); |
||
255 | $xoopsTpl->assign('min', $min); |
||
256 | $rank = 1; |
||
257 | |||
258 | $cat_perms = ''; |
||
259 | if (is_array($categories) && count($categories) > 0) { |
||
260 | $cat_perms .= ' AND cid IN (' . implode(',', $categories) . ') '; |
||
261 | } |
||
262 | |||
263 | $sql = 'SELECT lid, title, status, type, price, typeprice, date, town, country, contactby, usid, premium, valid, photo, hits FROM ' |
||
264 | . $xoopsDB->prefix('adslight_listing') |
||
265 | . ' WHERE valid="Yes" and cid=' |
||
266 | . $xoopsDB->escape($cid) |
||
267 | . ' AND status!="1" ' |
||
268 | . $cat_perms |
||
269 | . ' ORDER BY ' |
||
270 | . $orderby |
||
271 | . ''; |
||
272 | $result1 = $xoopsDB->query($sql, $show, $min); |
||
273 | if ($trows > '1') { |
||
274 | $xoopsTpl->assign('show_nav', true); |
||
275 | $orderbyTrans = AdslightUtilities::convertOrderByTrans($orderby); |
||
276 | $xoopsTpl->assign('lang_sortby', _ADSLIGHT_SORTBY); |
||
277 | $xoopsTpl->assign('lang_title', _ADSLIGHT_TITLE); |
||
278 | $xoopsTpl->assign('lang_titleatoz', _ADSLIGHT_TITLEATOZ); |
||
279 | $xoopsTpl->assign('lang_titleztoa', _ADSLIGHT_TITLEZTOA); |
||
280 | $xoopsTpl->assign('lang_date', _ADSLIGHT_DATE); |
||
281 | $xoopsTpl->assign('lang_dateold', _ADSLIGHT_DATEOLD); |
||
282 | $xoopsTpl->assign('lang_datenew', _ADSLIGHT_DATENEW); |
||
283 | $xoopsTpl->assign('lang_price', _ADSLIGHT_PRICE); |
||
284 | $xoopsTpl->assign('lang_priceltoh', '' . _ADSLIGHT_PRICELTOH . ''); |
||
285 | $xoopsTpl->assign('lang_pricehtol', '' . _ADSLIGHT_PRICEHTOL . ''); |
||
286 | $xoopsTpl->assign('lang_popularity', _ADSLIGHT_POPULARITY); |
||
287 | $xoopsTpl->assign('lang_popularityleast', _ADSLIGHT_POPULARITYLTOM); |
||
288 | $xoopsTpl->assign('lang_popularitymost', _ADSLIGHT_POPULARITYMTOL); |
||
289 | $xoopsTpl->assign('lang_cursortedby', sprintf(_ADSLIGHT_CURSORTEDBY, AdslightUtilities::convertOrderByTrans($orderby))); |
||
290 | } |
||
291 | |||
292 | while (list($lid, $title, $status, $type, $price, $typeprice, $date, $town, $country, $contactby, $usid, $premium, $valid, $photo, $hits) = $xoopsDB->fetchRow($result1)) { |
||
293 | $a_item = array(); |
||
294 | $title = $myts->htmlSpecialChars($title); |
||
295 | $type = $myts->htmlSpecialChars($type); |
||
296 | // $price = number_format($price, 2, ',', ' '); |
||
297 | $town = $myts->htmlSpecialChars($town); |
||
298 | $country = $myts->htmlSpecialChars($country); |
||
299 | $contactby = $myts->htmlSpecialChars($contactby); |
||
300 | $useroffset = ''; |
||
301 | |||
302 | $newcount = $GLOBALS['xoopsModuleConfig']['adslight_countday']; |
||
303 | $startdate = (time() - (86400 * $newcount)); |
||
304 | View Code Duplication | if ($startdate < $date) { |
|
305 | $newitem = '<img src="' . XOOPS_URL . '/modules/adslight/assets/images/newred.gif" />'; |
||
306 | $a_item['new'] = $newitem; |
||
307 | } |
||
308 | if ($GLOBALS['xoopsUser']) { |
||
309 | $timezone = $GLOBALS['xoopsUser']->timezone(); |
||
310 | if (isset($timezone)) { |
||
311 | $useroffset = $GLOBALS['xoopsUser']->timezone(); |
||
312 | } else { |
||
313 | $useroffset = $xoopsConfig['default_TZ']; |
||
314 | } |
||
315 | } |
||
316 | $date = ($useroffset * 3600) + $date; |
||
317 | $date = formatTimestamp($date, 's'); |
||
318 | View Code Duplication | if ($GLOBALS['xoopsUser']) { |
|
319 | if ($GLOBALS['xoopsUser']->isAdmin()) { |
||
320 | $a_item['admin'] = '<a href="' |
||
321 | . XOOPS_URL |
||
322 | . '/modules/adslight/admin/validate_ads.php?op=ModifyAds&lid=' |
||
323 | . $lid |
||
324 | . '"><img src="' |
||
325 | . $pathIcon16 |
||
326 | . '/edit.png' |
||
327 | . '" border=0 alt="' |
||
328 | . _ADSLIGHT_MODADMIN |
||
329 | . '" title="' |
||
330 | . _ADSLIGHT_MODADMIN |
||
331 | . '"/></a>'; |
||
332 | } |
||
333 | } |
||
334 | |||
335 | $result7 = $xoopsDB->query('SELECT nom_type FROM ' . $xoopsDB->prefix('adslight_type') . ' WHERE id_type=' . $xoopsDB->escape($type) . ''); |
||
336 | list($nom_type) = $xoopsDB->fetchRow($result7); |
||
337 | |||
338 | $result8 = $xoopsDB->query('SELECT nom_price FROM ' . $xoopsDB->prefix('adslight_price') . ' WHERE id_price=' . $xoopsDB->escape($typeprice) . ''); |
||
339 | list($nom_price) = $xoopsDB->fetchRow($result8); |
||
340 | |||
341 | $a_item['type'] = $myts->htmlSpecialChars($nom_type); |
||
342 | $a_item['title'] = '<a href="viewads.php?lid=' . $lid . '"><strong>' . $title . '</strong></a>'; |
||
343 | $a_item['status'] = $status; |
||
344 | if ($price > 0) { |
||
345 | |||
346 | // $a_item['price'] = $price. ' '. $GLOBALS['xoopsModuleConfig']['adslight_money'].''; |
||
347 | $a_item['price'] = AdslightUtilities::getMoneyFormat('%.2n', $price); |
||
348 | $a_item['price_typeprice'] = $myts->htmlSpecialChars($nom_price); |
||
349 | } |
||
350 | $a_item['date'] = $date; |
||
351 | $a_item['local'] = ''; |
||
352 | if ($town) { |
||
353 | $a_item['local'] .= $town; |
||
354 | } |
||
355 | $a_item['country'] = ''; |
||
356 | if ($country) { |
||
357 | $a_item['country'] = $country; |
||
358 | } |
||
359 | |||
360 | $cat = addslashes($cid); |
||
361 | if ($status == 2) { |
||
362 | $a_item['sold'] = _ADSLIGHT_RESERVEDMEMBER; |
||
363 | } |
||
364 | |||
365 | View Code Duplication | if ($GLOBALS['xoopsModuleConfig']['active_thumbscats'] > 0) { |
|
366 | $a_item['no_photo'] = '<a href="' |
||
367 | . XOOPS_URL |
||
368 | . '/modules/adslight/viewads.php?lid=' |
||
369 | . $lid |
||
370 | . '"><img class="thumb" src="' |
||
371 | . XOOPS_URL |
||
372 | . '/modules/adslight/assets/images/nophoto.jpg" align="left" width="100px" alt="' |
||
373 | . $title |
||
374 | . '" /></a>'; |
||
375 | |||
376 | $updir = $GLOBALS['xoopsModuleConfig']['adslight_link_upload']; |
||
377 | $sql = 'SELECT cod_img, lid, uid_owner, url FROM ' |
||
378 | . $xoopsDB->prefix('adslight_pictures') |
||
379 | . ' WHERE uid_owner=' |
||
380 | . $xoopsDB->escape($usid) |
||
381 | . ' AND lid=' |
||
382 | . $xoopsDB->escape($lid) |
||
383 | . ' ORDER BY date_added ASC limit 1'; |
||
384 | $resultp = $xoopsDB->query($sql); |
||
385 | |||
386 | while (list($cod_img, $pic_lid, $uid_owner, $url) = $xoopsDB->fetchRow($resultp)) { |
||
387 | if ($photo) { |
||
388 | $a_item['photo'] = '<a href="' |
||
389 | . XOOPS_URL |
||
390 | . '/modules/adslight/viewads.php?lid=' |
||
391 | . $lid |
||
392 | . '"><img class="thumb" src="' |
||
393 | . $updir |
||
394 | . '/thumbs/thumb_' |
||
395 | . $url |
||
396 | . '" align="left" width="100px" alt="' |
||
397 | . $title |
||
398 | . '" /></a>'; |
||
399 | } |
||
400 | } |
||
401 | } else { |
||
402 | $a_item['no_photo'] = '<p><img src="' . XOOPS_URL . '/modules/adslight/assets/images/camera_nophoto.png" align="left" width="24" alt="' . $title . '" /></p>'; |
||
403 | $updir = $GLOBALS['xoopsModuleConfig']['adslight_link_upload']; |
||
404 | $sql = 'SELECT cod_img, lid, uid_owner, url FROM ' |
||
405 | . $xoopsDB->prefix('adslight_pictures') |
||
406 | . ' WHERE uid_owner=' |
||
407 | . $xoopsDB->escape($usid) |
||
408 | . ' AND lid=' |
||
409 | . $xoopsDB->escape($lid) |
||
410 | . ' ORDER BY date_added ASC limit 1'; |
||
411 | $resultp = $xoopsDB->query($sql); |
||
412 | while (list($cod_img, $pic_lid, $uid_owner, $url) = $xoopsDB->fetchRow($resultp)) { |
||
413 | if ($photo) { |
||
414 | $a_item['photo'] = '<p><img src="' . XOOPS_URL . '/modules/adslight/assets/images/camera_photo.png" align="left" width="24" alt="' . $title . '" /></p>'; |
||
415 | } |
||
416 | } |
||
417 | } |
||
418 | |||
419 | $a_item['hits'] = $hits; |
||
420 | ++$rank; |
||
421 | $xoopsTpl->append('items', $a_item); |
||
422 | } |
||
423 | |||
424 | $cid = ((int)$cid > 0) ? (int)$cid : 0; |
||
425 | |||
426 | $orderby = AdslightUtilities::convertOrderByOut($orderby); |
||
427 | $linkpages = ceil($trows / $show); |
||
428 | |||
429 | //Page Numbering |
||
430 | if ($linkpages != 1 && $linkpages != 0) { |
||
431 | $prev = $min - $show; |
||
432 | if ($prev >= 0) { |
||
433 | $pagenav .= "<a href='viewcats.php?cid=$cid&min=$prev&orderby=$orderby&show=$show'><strong><u>«</u></strong></a> "; |
||
434 | } |
||
435 | $counter = 1; |
||
436 | $currentpage = ($max / $show); |
||
437 | while ($counter <= $linkpages) { |
||
438 | $mintemp = ($show * $counter) - $show; |
||
439 | if ($counter == $currentpage) { |
||
440 | $pagenav .= "<strong>($counter)</strong> "; |
||
441 | } else { |
||
442 | $pagenav .= "<a href='viewcats.php?cid=$cid&min=$mintemp&orderby=$orderby&show=$show'>$counter</a> "; |
||
443 | } |
||
444 | ++$counter; |
||
445 | } |
||
446 | if ($trows > $max) { |
||
447 | $pagenav .= "<a href='viewcats.php?cid=$cid&min=$max&orderby=$orderby&show=$show'>"; |
||
448 | $pagenav .= '<strong><u>»</u></strong></a>'; |
||
449 | } |
||
450 | } |
||
451 | } |
||
452 | |||
453 | $xoopsTpl->assign('nav_page', $pagenav); |
||
454 | |||
455 | if (!$GLOBALS['xoopsUser']) { |
||
456 | global $xoopsDB; |
||
457 | |||
458 | $xt = new XoopsTree($xoopsDB->prefix('adslight_categories'), 'cid', 'pid'); |
||
459 | $jump = XOOPS_URL . '/modules/adslight/viewcats.php?cid='; |
||
460 | ob_start(); |
||
461 | $xt->makeMySelBox('title', 'title', $cid, 1, 'pid', "location=\"" . $jump . "\"+this.options[this.selectedIndex].value"); |
||
462 | $select_go_cats = ob_get_contents(); |
||
463 | ob_end_clean(); |
||
464 | $xoopsTpl->assign('select_go_cats', $select_go_cats); |
||
465 | } |
||
466 | } |
||
467 | |||
468 | # function categorynewgraphic |
||
469 | ##################################################### |
||
470 | /** |
||
471 | * @param $cid |
||
472 | */ |
||
473 | function categorynewgraphic($cid) |
||
474 | { |
||
475 | global $xoopsDB; |
||
476 | } |
||
477 | |||
478 | ###################################################### |
||
479 | |||
480 | $pa = !isset($_GET['pa']) ? null : $_GET['pa']; |
||
481 | $lid = !isset($_GET['lid']) ? null : $_GET['lid']; |
||
482 | $cid = !isset($_GET['cid']) ? null : $_GET['cid']; |
||
483 | $usid = isset($_GET['usid']) ? $_GET['usid'] : ''; |
||
484 | $min = !isset($_GET['min']) ? null : $_GET['min']; |
||
485 | $show = !isset($_GET['show']) ? null : $_GET['show']; |
||
486 | $orderby = !isset($_GET['orderby']) ? null : $_GET['orderby']; |
||
487 | |||
488 | switch ($pa) { |
||
489 | default: |
||
490 | $GLOBALS['xoopsOption']['template_main'] = 'adslight_category.tpl'; |
||
491 | adsView($cid, $min, $orderby, $show); |
||
492 | break; |
||
493 | } |
||
494 | include XOOPS_ROOT_PATH . '/footer.php'; |
||
495 |
Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation.
You can also find more detailed suggestions in the “Code” section of your repository.