query("SELECT posts.post_id FROM posts INNER JOIN posts_products ON posts.post_id = posts_products.post_id WHERE posts.post_type = 'product' AND posts_products.available = '1' AND posts.boosted = '1' ORDER BY RAND() LIMIT 3") or _error(SQL_ERROR); while($promoted_product = $get_promoted->fetch_assoc()) { $promoted_product = $user->get_post($promoted_product['post_id']); if($promoted_product) { $promoted_products[] = $promoted_product; } } /* assign variables */ $smarty->assign('promoted_products', $promoted_products); /* prepare where query */ $where_query = ""; /* prepare pager url */ $url = ""; break; } // get market categories $categories = $user->get_market_categories(); /* assign variables */ $smarty->assign('categories', $categories); // get products require('includes/class-pager.php'); $params['selected_page'] = ( (int) $_GET['page'] == 0) ? 1 : $_GET['page']; $total = $db->query("SELECT posts.post_id FROM posts INNER JOIN posts_products ON posts.post_id = posts_products.post_id WHERE posts.post_type = 'product' AND posts_products.available = '1'".$where_query) or _error(SQL_ERROR); $params['total_items'] = $total->num_rows; $params['items_per_page'] = $system['min_results_even']; $params['url'] = $system['system_url'].'/market'.$url.'/%s'; $pager = new Pager($params); $limit_query = $pager->getLimitSql(); // get posts $rows = array(); $get_rows = $db->query("SELECT posts.post_id FROM posts INNER JOIN posts_products ON posts.post_id = posts_products.post_id WHERE posts.post_type = 'product' AND posts_products.available = '1'".$where_query." ORDER BY post_id DESC ".$limit_query) or _error(SQL_ERROR); while($row = $get_rows->fetch_assoc()) { $row = $user->get_post($row['post_id']); if($row) { $rows[] = $row; } } /* assign variables */ $smarty->assign('rows', $rows); $smarty->assign('total', $params['total_items']); $smarty->assign('pager', $pager->getPager()); $smarty->assign('view', $_GET['view']); // get ads $ads = $user->ads('market'); /* assign variables */ $smarty->assign('ads', $ads); } catch (Exception $e) { _error(__("Error"), $e->getMessage()); } // page footer ?> Benvenuto alla Middern

No products to show

Benvenuto alla Middern

Scopri il primo social network per i proprietari di cani. Condividi i tuoi ricordi, fai nuove amicizie, parla con professionisti del settore cinofilo.

Accedi

Non sei registrato? Crea un account

Registrati

Hai un account? Accedi ora
More Articles