function debits() { if (isset($_SESSION['user_id'])) { $user_id = $_SESSION['user_id']; if (isset($_GET['page'])) { $page = tools::filter($_GET['page']); } else { $page = 1; } $sql = "SELECT auction_id, description, debit, created FROM " . DB_PREFIX . "bids"; if (isset($_GET['auction_id'])) { $conditions = "WHERE user_id=" . $user_id . " AND debit > 0 AND credit = 0 AND auction_id=" . $_GET['auction_id'] . " ORDER BY created DESC"; } else { $conditions = "WHERE user_id=" . $user_id . " AND debit > 0 AND credit = 0 ORDER BY created DESC"; } list($bids, $pagination) = tools::paginate($sql, $conditions, "" . DB_PREFIX . "bids", $page, $this->settings['app']['per_page']); $this->smarty->assign(array('bids' => $bids, 'pagination' => $pagination)); $this->smarty->display('user/debits.tpl'); } else { tools::setFlash($this->l('Please log in to access this area'), 'error'); tools::redirect('/user/login'); } }