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 ?> مرحبا بكم في Middern

لا توجد منتجات لعرضها

مرحبا بكم في Middern

ذكرياتك، والتواصل مع الآخرين، وتكوين صداقات جديدة

تسجيل الدخول

غير مسجل؟ إنشاء حساب جديد

التسجيل

هل لديك حساب؟ سجل الدخول الآن
المزيد من المقالات