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 ?> Willkommen bei Middern

No products to show

Willkommen bei Middern

Teilen Sie Ihre Erinnerungen, mit anderen verbinden, neue Freunde

Anmelden

Nicht registriert Erstellen Sie ein Konto

Registrieren

Have an account? Anmelden
More Articles