if (isset($_GET['products_id'])) {
if (!isset($nProductsId)) $nProductsId = oos_get_product_id($_GET['products_id']);
}
$aOption['popup_print'] = $sTheme . '/products/popup_print.html';
//smarty
require 'includes/classes/class_template.php';
$oSmarty = new Template;
$oSmarty->caching = true;
$popup_cache_id = $sTheme . '|products|' . $nGroupID . '|print|' . $nProductsId . '|' . $sLanguage;
if (!$oSmarty->is_cached($aOption['popup_print'], $popup_cache_id )) {
$productstable = $oostable['products'];
$products_descriptiontable = $oostable['products_description'];
$product_info_sql = "SELECT p.products_id, pd.products_name, pd.products_description, pd.products_url,
pd.products_description_meta, pd.products_keywords_meta, p.products_model,
p.products_quantity, p.products_image, p.products_subimage1, p.products_subimage2,
p.products_subimage3, p.products_subimage4, p.products_subimage5, p.products_subimage6,
p.products_discount_allowed, p.products_price, p.products_base_price, p.products_base_unit,
p.products_quantity_order_min, p.products_quantity_order_units,
p.products_discount1, p.products_discount2, p.products_discount3, p.products_discount4,
p.products_discount1_qty, p.products_discount2_qty, p.products_discount3_qty,
p.products_discount4_qty, p.products_tax_class_id, p.products_units_id, p.products_date_added,
p.products_date_available, p.manufacturers_id, p.products_price_list
FROM $productstable p,
$products_descriptiontable pd
$sql = "SELECT p.products_id, p.products_status, pd.products_name\n FROM {$productstable} p,\n {$products_descriptiontable} pd\n WHERE p.products_status >= '1'\n AND p.products_id = '" . oos_db_input($pr_ids[$i]) . "'\n AND pd.products_id = p.products_id\n AND pd.products_languages_id = '" . intval($nLanguageID) . "'";
$result = $dbconn->Execute($sql);
if ($row = $result->fields) {
$prods .= '<br />' . $row["products_name"];
}
}
if ($prods == '') {
$prods = '<br />NONE';
}
$text_coupon_help .= $prods;
} else {
$nCouponID = 0;
}
$aOption['popup_help'] = $sTheme . '/system/popup_help.html';
//smarty
require 'includes/classes/class_template.php';
$oSmarty = new Template();
$oSmarty->caching = true;
$nCouponID += 0;
$help_cache_id = $sTheme . '|popup|coupon|' . $nCouponID . '|' . $sLanguage;
if (!$oSmarty->is_cached($aOption['popup_help'], $help_cache_id)) {
// assign Smarty variables;
$oSmarty->assign('oos_base', ($request_type == 'SSL' ? OOS_HTTPS_SERVER : OOS_HTTP_SERVER) . OOS_SHOP);
$oSmarty->assign('lang', $aLang);
$oSmarty->assign('heading_titel', $aLang['heading_coupon_help']);
$oSmarty->assign('help_text', $text_coupon_help);
$oSmarty->assign('theme_image', 'themes/' . $sTheme . '/images');
$oSmarty->assign('theme_css', 'themes/' . $sTheme);
}
// display the template
$oSmarty->display($aOption['popup_help'], $help_cache_id);
}
$_GET['s'] = trim($_GET['s']);
$page = isset($_GET['p']) ? $_GET['p'] : 1;
$per_page = isset($_GET['pp']) ? $_GET['pp'] : 20;
$too_short = strlen($_GET['s']) < 4;
$search_id = md5("{$_GET['s']}-{$page}-{$_GET['c']}-{$_GET['f']}");
$t = new Template();
$t->caching = TRUE;
$t->cache_lifetime = 3600;
$DB = new DB($C['db_hostname'], $C['db_username'], $C['db_password'], $C['db_name']);
$DB->Connect();
$domain = $DB->Row('SELECT * FROM `tx_domains` WHERE `domain`=?', array(preg_replace('~^www\\.~i', '', strtolower($_SERVER['HTTP_HOST']))));
if ($domain) {
$C['cookie_domain'] = $domain['domain'];
}
if (!$too_short && !$t->is_cached($domain['template_prefix'] . 'search-results.tpl', $search_id)) {
$categories =& $DB->FetchAll('SELECT `name`,`tag` FROM `tx_categories` WHERE `hidden`=0 ORDER BY `name`', null, 'tag');
$galleries = array();
$search_wheres = array('MATCH(`description`,`keywords`) AGAINST(? IN BOOLEAN MODE)', '`status` IN (?,?)');
$search_binds = array($_GET['s'], 'used', 'holding');
// If category was specified, add it to the where clause
if ($_GET['c']) {
$search_wheres[] = 'MATCH(`categories`) AGAINST(? IN BOOLEAN MODE)';
$search_binds[] = $_GET['c'];
}
// If format was specified, add it to the where clause
if ($_GET['f']) {
$search_wheres[] = '`format`=?';
$search_binds[] = $_GET['f'];
}
$result = $DB->QueryWithPagination('SELECT * FROM `tx_galleries` WHERE ' . join(' AND ', $search_wheres), $search_binds, $page, $per_page);
function DisplayCategory()
{
global $C, $DB;
$t = new Template();
$t->caching = TRUE;
$t->cache_lifetime = $C['cache_category'];
$custom_sort = isset($_GET['s']);
$from_path = FALSE;
$template = 'directory-category.tpl';
if ($custom_sort) {
$t->caching = FALSE;
}
if ($C['mod_rewrite'] && !is_numeric($_GET['c'])) {
$_GET['c'] = preg_replace('~^/|/$~', '', $_GET['c']);
if (preg_match("~(.*?)/(\\d+)\\.{$C['extension']}\$~", $_GET['c'], $matches)) {
$_GET['c'] = $matches[1];
$_GET['p'] = $matches[2];
}
$from_path = TRUE;
}
$_GET['p'] = isset($_GET['p']) ? $_GET['p'] : 1;
$cache_id = md5($_GET['c'] . '-' . $_GET['p']);
if ($custom_sort || $C['custom_categories'] || !$t->is_cached($template, $cache_id)) {
$DB->Connect();
// Get the category
if ($from_path) {
$category = $DB->Row('SELECT * FROM lx_categories WHERE path_hash=?', array(md5($_GET['c'])));
} else {
$category = $DB->Row('SELECT * FROM lx_categories WHERE category_id=?', array($_GET['c']));
}
if ($category['template']) {
$template = $category['template'];
}
if (!$category) {
require_once 'includes/language.php';
$t->caching = FALSE;
$t->assign('error', $L['NO_SUCH_PAGE']);
$t->assign_by_ref('config', $C);
$t->display('error-nice.tpl');
return;
}
}
if ($custom_sort || !$t->is_cached($template, $cache_id)) {
$category['path_parts'] = unserialize($category['path_parts']);
$t->assign_by_ref('this_category', $category);
$t->assign_by_ref('config', $C);
$t->assign('page_num', $_GET['p']);
$t->assign('get_c', $_GET['c']);
$t->assign('template', $template);
$t->assign_by_ref('request', $_GET);
}
$t->display($template, $cache_id);
}
}
$_POST['s'] = trim($_POST['s']);
$page = !empty($_POST['p']) ? $_POST['p'] : 1;
$per_page = !empty($_POST['pp']) ? $_POST['pp'] : 20;
$too_short = strlen($_POST['s']) < 4;
$search_id = sha1("{$_POST['s']}-{$_POST['c']}-{$page}");
$t = new Template();
$t->caching = TRUE;
$t->cache_lifetime = 3600;
$t->assign('search_term', $_POST['s']);
$t->assign('search_category', $_POST['c']);
$t->assign('page', $page);
$t->assign('per_page', $per_page);
$t->assign('search_too_short', $too_short);
$t->assign_by_ref('config', $C);
if (!$too_short && !$t->is_cached('search-results.tpl', $search_id)) {
$DB = new DB($C['db_hostname'], $C['db_username'], $C['db_password'], $C['db_name']);
$DB->Connect();
$accounts = array();
$result = $DB->QueryWithPagination('SELECT * FROM `tlx_accounts` JOIN `tlx_account_hourly_stats` USING (`username`) WHERE ' . 'MATCH(`title`,`description`,`keywords`) AGAINST(? IN BOOLEAN MODE) AND ' . '`status`=? AND ' . '`disabled`=0 ' . (!empty($_POST['c']) && is_numeric($_POST['c']) ? ' AND `category_id`=' . $DB->Escape($_POST['c']) . ' ' : '') . 'ORDER BY `unique_in_total` DESC', array($_POST['s'], 'active'), $page, $per_page);
if ($result['result']) {
while ($account = $DB->NextRow($result['result'])) {
$accounts[] = array_merge($account, $DB->Row('SELECT * FROM `tlx_account_fields` WHERE `username`=?', array($account['username'])));
}
$DB->Free($result['result']);
unset($result['result']);
}
$categories = $DB->FetchAll('SELECT * FROM `tlx_categories` ORDER BY `name`');
if (!$categories) {
$categories = array();
}
if (function_exists('date_default_timezone_set')) {
date_default_timezone_set('America/Chicago');
}
if (get_magic_quotes_gpc()) {
_ArrayStripSlashes($_GET);
}
$link = array('link_id' => $_GET['id']);
$cache_id = md5($_GET['id']);
// Indicate if logged in
$C['logged_in'] = isset($_COOKIE['linkxuser']);
$t = new Template();
$t->caching = $C['cache_details'] > 0;
$t->cache_lifetime = $C['cache_details'];
$t->cache_dir = 'templates/cache_details';
$t->assign_by_ref('link', $link);
if (!$t->is_cached('directory-link-details.tpl', $cache_id)) {
$DB = new DB($C['db_hostname'], $C['db_username'], $C['db_password'], $C['db_name']);
$DB->Connect();
$link = $DB->Row('SELECT * FROM lx_links JOIN lx_link_fields USING (link_id) WHERE lx_links.link_id=?', array($_GET['id']));
if (!$link) {
require_once 'includes/language.php';
$t->caching = FALSE;
$t->assign('error', $L['NO_SUCH_PAGE']);
$t->assign_by_ref('config', $C);
$t->display('error-nice.tpl');
return;
}
// Get all categories for this link
$categories = array();
$result = $DB->Query('SELECT * FROM lx_link_cats JOIN lx_categories USING (category_id) WHERE link_id=?', array($_GET['id']));
while ($category = $DB->NextRow($result)) {
