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 ?> Hoşgeldiniz Middern

No products to show

Hoşgeldiniz Middern

Anılarınızı paylaşın, diğerleri ile bağlantı kurmak, yeni arkadaşlar bulun

Giriş

Forgotten password?
Kayıtlı değil? Hesap oluştur?

Kayıt ol

Have an account? Hemen Giriş Yap
More Articles