$r = (int) $_GET['r'];
if ($r != 0) {
$r = 1;
}
$a['sponsored'] = $r;
$a['sponsoredon'] = $r = 0 ? '' : date('Y-m-d', time());
Ad::update($o, $a);
}
$tct = Ad::count();
//total count
$rpp = 10;
//row per page
$pager_options = array('mode' => 'Sliding', 'perPage' => $rpp, 'delta' => 2, 'totalItems' => $tct, 'excludeVars' => array('o', 'r', 'd', 't', 'e'));
$pager = @Pager::factory($pager_options);
list($from, $to) = $pager->getOffsetByPageId();
$ads = Ad::get_all(array(), '', $from - 1 . ", {$rpp}");
include "page-header.php";
?>
<div id="wrapper">
<?php
include "page-left.php";
?>
<div id="content">
<?php
if ($tct > $rpp) {
echo $pager->links . '<br /><br />';
}
$or_filter .= " OR id LIKE '{$gs_description}'";
}
if ($or_filter != '') {
$filter .= " AND (1=2 {$or_filter})";
}
if ($g_category != "any" && $g_category != '0') {
$filter .= " AND (category=(SELECT r.id FROM category r WHERE r.slug='{$g_category}' LIMIT 1) OR category IN (SELECT r.id FROM category r WHERE r.parent=(SELECT s.id FROM category s WHERE s.slug='{$g_category}' LIMIT 1)))";
}
if ($g_region != "any" && $g_region != '0') {
$filter .= " AND (region=(SELECT r.id FROM region r WHERE r.slug='{$g_region}' LIMIT 1) OR region IN (SELECT r.id FROM region r WHERE r.parent=(SELECT s.id FROM region s WHERE s.slug='{$g_region}' LIMIT 1)))";
}
if ($g_min_price != "") {
$filter .= " AND ar>={$g_min_price}";
}
if ($g_max_price != "") {
$filter .= " AND ar<={$g_max_price}";
}
if ($g_id > 0) {
$filter .= " AND id='{$g_id}'";
}
}
$rpp = 15;
//row per page
$tct = Ad::count(array(), $filter);
//total count
$pager_options = array('mode' => 'Sliding', 'perPage' => $rpp, 'delta' => 2, 'totalItems' => $tct);
$pager = @Pager::factory($pager_options);
list($from, $to) = $pager->getOffsetByPageId();
$ads = Ad::get_all(array(), $filter, $from - 1 . ", {$rpp}");
$curr_page = "home";
include "./templates/ad-list.php";
/**
* Get user's all favourite ads
*
* @param int $user_id The user's id.
* @param int $limit Number of rows needs to be returned.
* @return array The result rows as array.
*/
public static function get_all($user_id, $limit)
{
global $db;
$filter = sprintf("h.active=1 AND h.id IN (SELECT f.ad_id FROM " . static::$table_name . " f WHERE f.user_id=%d)", $user_id);
return Ad::get_all(array(), $filter, $limit);
}
