set('parent_id', $parent_id); $keywords_search = $db->rem_special_chars($_REQUEST['keywords_search']); $template->set('keywords_search', $keywords_search); $template->set('header_wanted_ads', header5(GMSG_WANTED_ADS)); //$template->set('db', $db); //$template->set('fees', $fees); $template->set('session', $session); (string) $subcategories_content = null; $categories_header_menu = category_navigator($parent_id, true, true, 'wanted_ads.php'); $template->set('categories_header_menu', $categories_header_menu . ' [–]'); $is_subcategories = $db->count_rows('categories', "WHERE parent_id='" . $parent_id . "'"); $template->set('is_subcategories', $is_subcategories); $sql_select_categories = $db->query("SELECT category_id, wanted_counter FROM " . DB_PREFIX . "categories WHERE parent_id='" . $parent_id . "' AND user_id=0 AND enable_wanted=1 ORDER BY order_id ASC, name ASC"); (array) $wanted_cats = null; while ($cat_details = $db->fetch_array($sql_select_categories)) { $wanted_cats[] =$cat_details; } $columns = 3; //columns $all = count($wanted_cats); for ($i=0; $i<$all; $i++) { if (($i % $columns)==0 and $i!=0) { $subcategories_content .= ''; } $subcategories_content .= ''. '' . $category_lang[$wanted_cats[$i]['category_id']] . ' '. (($setts['enable_cat_counters']) ? (($wanted_cats[$i]['wanted_counter']) ? '(' . $wanted_cats[$i]['wanted_counter'] . ')' : '(' . $wanted_cats[$i]['wanted_counter'] . ')') : '') . ''; } $template->set('subcategories_content', $subcategories_content); if ($parent_id) { (array) $src_cats = null; (string) $category_name = null; reset($categories_array); foreach ($categories_array as $key => $value) { if ($parent_id == $key) { list($category_name, $tmp_user_id) = $value; } } reset($categories_array); while (list($cat_array_id, $cat_array_details) = each($categories_array)) { list($cat_array_name, $cat_user_id) = $cat_array_details; $categories_match = strpos($cat_array_name, $category_name); if (trim($categories_match) == "0") { $src_cats[] = $cat_array_id; } } $all_subcategories = $db->implode_array($src_cats); $query[] = "(a.category_id IN (" . $all_subcategories . ") OR a.addl_category_id IN (" . $all_subcategories . "))"; } if ($keywords_search) { $query[] = "MATCH (a.name, a.description) AGAINST ('" . $keywords_search . "*' IN BOOLEAN MODE)"; } $addl_where_query = $db->implode_array($query, ' AND '); $addl_where_query = (!empty($addl_where_query)) ? ' AND ' . $addl_where_query : ''; $page_url = 'wanted_ads'; $where_query = "WHERE a.active=1 AND a.closed=0 AND a.deleted=0" . $addl_where_query; $order_field = ($_REQUEST['order_field']) ? $_REQUEST['order_field'] : 'a.end_time'; $order_type = ($_REQUEST['order_type']) ? $_REQUEST['order_type'] : 'ASC'; $additional_vars = '&parent_id=' . $parent_id . '&keywords_search=' . $keywords_search; $limit = 20; $order_link = '&order_field=' . $order_field . '&order_type=' . $order_type; $limit_link = '&start=' . $start . '&limit=' . $limit; $template->set('page_order_itemname', page_order($page_url . '.php', 'a.name', $start, $limit, $additional_vars, MSG_ITEM_TITLE)); $template->set('page_order_nb_bids', page_order($page_url . '.php', 'a.nb_bids', $start, $limit, $additional_vars, MSG_NR_OFFERS)); $template->set('page_order_end_time', page_order($page_url . '.php', 'a.end_time', $start, $limit, $additional_vars, MSG_ENDS)); $nb_items = $db->count_rows('wanted_ads a', $where_query); $template->set('nb_items', $nb_items); if ($nb_items) { $pagination = paginate($start, $limit, $nb_items, $page_url . '.php', $additional_vars . $order_link); //g $template->set('pagination', $pagination); $sql_select_wanted_ads = $db->query("SELECT a.wanted_ad_id, a.name, a.nb_bids, a.end_time, a.closed, am.media_url FROM " . DB_PREFIX . "wanted_ads a LEFT JOIN " . DB_PREFIX . "auction_media am ON a.wanted_ad_id=am.wanted_ad_id AND am.media_type=1 AND am.upload_in_progress=0 " . $where_query . " GROUP BY a.wanted_ad_id ORDER BY " . $order_field . " " . $order_type . " LIMIT " . $start . ", " . $limit); //g (string) $browse_wanted_ads_content = null; while ($item_details = $db->fetch_array($sql_select_wanted_ads)) { $background = ($counter++%2) ? 'c1' : 'c2'; $wanted_ad_link = process_link('wanted_details', array('name' => $item_details['name'], 'wanted_ad_id' => $item_details['wanted_ad_id'])); $wanted_ad_image = (!empty($item_details['media_url'])) ? $item_details['media_url'] : 'themes/' . $setts['default_theme'] . '/img/system/noimg.gif'; $browse_wanted_ads_content .= ' '. ' '. ' ' . $item_details['name'] . ' '. ' ' . $item_details['nb_bids'] . ' '. ' ' . time_left($item_details['end_time']) . ' '. ' '; } } else { $browse_wanted_ads_content = '' . GMSG_NO_ITEMS_MSG . ''; } $template->set('browse_wanted_ads_content', $browse_wanted_ads_content); $template_output .= $template->process('browse_wanted_ads.tpl.php'); include_once ('global_footer.php'); echo $template_output; } else { header_redirect('index.php'); } ?>