function vam_display_banner($action, $identifier)
{
if ($action == 'dynamic') {
$banners_query = vam_db_query("select count(*) as count from " . TABLE_BANNERS . " where status = '1' and banners_group = '" . $identifier . "'");
$banners = vam_db_fetch_array($banners_query);
if ($banners['count'] > 0) {
$banner = vam_random_select("select banners_id, banners_title, banners_image, banners_html_text from " . TABLE_BANNERS . " where status = '1' and banners_group = '" . $identifier . "'");
} else {
return '<b>VaM Shop ERROR! (vam_display_banner(' . $action . ', ' . $identifier . ') -> No banners with group \'' . $identifier . '\' found!</b>';
}
} elseif ($action == 'static') {
if (is_array($identifier)) {
$banner = $identifier;
} else {
$banner_query = vam_db_query("select banners_id, banners_title, banners_image, banners_html_text from " . TABLE_BANNERS . " where status = '1' and banners_id = '" . $identifier . "'");
if (vam_db_num_rows($banner_query)) {
$banner = vam_db_fetch_array($banner_query);
} else {
return '<b>VaM Shop ERROR! (vam_display_banner(' . $action . ', ' . $identifier . ') -> Banner with ID \'' . $identifier . '\' not found, or status inactive</b>';
}
}
} else {
return '<b>VaM Shop ERROR! (vam_display_banner(' . $action . ', ' . $identifier . ') -> Unknown $action parameter value - it must be either \'dynamic\' or \'static\'</b>';
}
if (vam_not_null($banner['banners_html_text'])) {
$banner_string = $banner['banners_html_text'];
} else {
$banner_string = '<a href="' . vam_href_link(FILENAME_REDIRECT, 'action=banner&goto=' . $banner['banners_id']) . '" onclick="window.open(this.href); return false;">' . vam_image(DIR_WS_IMAGES . 'banner/' . $banner['banners_image'], $banner['banners_title']) . '</a>';
}
vam_update_banner_display_count($banner['banners_id']);
return $banner_string;
}
function vam_banner_exists($action, $identifier)
{
if ($action == 'dynamic') {
return vam_random_select("select banners_id, banners_title, banners_image, banners_html_text from " . TABLE_BANNERS . " where status = '1' and banners_group = '" . $identifier . "'");
} elseif ($action == 'static') {
$banner_query = vam_db_query("select banners_id, banners_title, banners_image, banners_html_text from " . TABLE_BANNERS . " where status = '1' and banners_id = '" . $identifier . "'");
return vam_db_fetch_array($banner_query);
} else {
return false;
}
}
Released under the GNU General Public License
---------------------------------------------------------------------------------------*/
$box = new vamTemplate();
$box->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/');
$box_content = '';
// include needed functions
require_once DIR_FS_INC . 'vam_random_select.inc.php';
//fsk18 lock
$fsk_lock = '';
if ($_SESSION['customers_status']['customers_fsk18_display'] == '0') {
$fsk_lock = ' and p.products_fsk18!=1';
}
if (GROUP_CHECK == 'true') {
$group_check = " and p.group_permission_" . $_SESSION['customers_status']['customers_status_id'] . "=1 ";
}
if ($random_product = vam_random_select("select\n p.products_id,\n pd.products_name,\n p.products_price,\n p.products_tax_class_id,\n p.products_image,\n s.expires_date,\n p.products_vpe,\n\t\t\t\t p.products_vpe_status,\n\t\t\t\t p.products_vpe_value,\n s.specials_new_products_price\n from " . TABLE_PRODUCTS . " p,\n " . TABLE_PRODUCTS_DESCRIPTION . " pd,\n " . TABLE_SPECIALS . " s where p.products_status = '1'\n and p.products_id = s.products_id\n and pd.products_id = s.products_id\n and pd.language_id = '" . $_SESSION['languages_id'] . "'\n and s.status = '1'\n " . $group_check . "\n " . $fsk_lock . " \n order by s.specials_date_added\n desc limit " . MAX_RANDOM_SELECT_SPECIALS)) {
$box->assign('box_content', $product->buildDataArray($random_product));
$box->assign('SPECIALS_LINK', vam_href_link(FILENAME_SPECIALS));
$box->assign('language', $_SESSION['language']);
if ($random_product["products_id"] != '') {
// set cache ID
if (!CacheCheck()) {
$box->caching = 0;
$box_specials = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_specials.html');
} else {
$box->caching = 1;
$box->cache_lifetime = CACHE_LIFETIME;
$box->cache_modified_check = CACHE_CHECK;
$cache_id = $_SESSION['language'] . $random_product["products_id"] . $_SESSION['customers_status']['customers_status_name'];
$box_specials = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_specials.html', $cache_id);
}
$box = new vamTemplate();
$box->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/');
$box_content = '';
// include needed functions
require_once DIR_FS_INC . 'vam_random_select.inc.php';
require_once DIR_FS_INC . 'vam_rand.inc.php';
require_once DIR_FS_INC . 'vam_get_products_name.inc.php';
//fsk18 lock
$fsk_lock = '';
if ($_SESSION['customers_status']['customers_fsk18_display'] == '0') {
$fsk_lock = ' and p.products_fsk18!=1';
}
if (GROUP_CHECK == 'true') {
$group_check = " and p.group_permission_" . $_SESSION['customers_status']['customers_status_id'] . "=1 ";
}
if ($random_product = vam_random_select("select distinct\n p.products_id,\n pd.products_name,\n p.products_image,\n p.products_tax_class_id,\n p.products_vpe,\n\t\t\t\t p.products_vpe_status,\n\t\t\t\t p.products_vpe_value,\n p.products_price\n from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c\n where p.products_status=1\n and p.products_id = p2c.products_id\n and pd.products_id = p.products_id\n and p.products_id !='" . (int) $_GET['products_id'] . "'\n and pd.language_id = '" . $_SESSION['languages_id'] . "'\n and c.categories_id = p2c.categories_id\n " . $group_check . "\n " . $fsk_lock . "\n and c.categories_status=1 order by\n p.products_date_added desc limit " . MAX_RANDOM_SELECT_NEW)) {
$whats_new_price = $vamPrice->GetPrice($random_product['products_id'], $format = true, 1, $random_product['products_tax_class_id'], $random_product['products_price']);
}
if ($random_product['products_name'] != '') {
$box->assign('box_content', $product->buildDataArray($random_product));
$box->assign('LINK_NEW_PRODUCTS', vam_href_link(FILENAME_PRODUCTS_NEW));
$box->assign('language', $_SESSION['language']);
// set cache ID
if (!CacheCheck()) {
$box->caching = 0;
$box_whats_new = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_whatsnew.html');
} else {
$box->caching = 1;
$box->cache_lifetime = CACHE_LIFETIME;
$box->cache_modified_check = CACHE_CHECK;
$cache_id = $_SESSION['language'] . $random_product['products_id'] . $_SESSION['customers_status']['customers_status_name'];
function vam_rss_products($sql_products)
{
global $db, $rss, $random;
$sql_maxdate = "select max(products_date_added) as max_date_added, max(products_last_modified) as max_date_modified\n\t\t\t\t\t\t\t\t\t\tfrom " . TABLE_PRODUCTS . "\n\t\t\t\t\t\t\t\t\t\twhere products_status = 1";
$maxdate = vam_db_query($sql_maxdate);
if (!$maxdate) {
$rss->rss_feed_set('lastBuildDate', date('r', strtotime(max($maxdate['max_date_added'], $maxdate['max_date_modified']))));
}
if (isset($_GET['limit']) && (int) $_GET['limit'] > 0 && !$random) {
$sql_products .= ' limit ' . (int) $_GET['limit'];
}
if ($random) {
$products = vam_random_select($sql_products);
} else {
$products_query = vam_db_query($sql_products);
}
if ($random) {
$products = vam_random_select($sql_products);
$link = vam_href_link(FILENAME_PRODUCT_INFO, vam_product_link($products['products_id'], $products['products_name']) . (isset($_GET['ref']) ? '&ref=' . $_GET['ref'] : null), 'NONSSL', false);
$rss->rss_feed_item($products['products_name'], $link, $link, date('r', strtotime(max($products['products_date_added'], $products['products_last_modified']))), $products['products_description'], $products['products_image'], vam_href_link(FILENAME_PRODUCT_REVIEWS_INFO, vam_product_link($products['products_id'], $products['products_name']) . (isset($_GET['ref']) ? '&ref=' . $_GET['ref'] : null), 'NONSSL', false));
} else {
$products_query = vam_db_query($sql_products);
while ($products = vam_db_fetch_array($products_query)) {
$link = vam_href_link(FILENAME_PRODUCT_INFO, vam_product_link($products['products_id'], $products['products_name']) . (isset($_GET['ref']) ? '&ref=' . $_GET['ref'] : null), 'NONSSL', false);
$rss->rss_feed_item($products['products_name'], $link, $link, date('r', strtotime(max($products['products_date_added'], $products['products_last_modified']))), $products['products_description'], $products['products_image'], vam_href_link(FILENAME_PRODUCT_REVIEWS_INFO, vam_product_link($products['products_id'], $products['products_name']) . (isset($_GET['ref']) ? '&ref=' . $_GET['ref'] : null), 'NONSSL', false));
if ($random) {
break;
}
}
}
$rss->rss_feed_out();
}
$box->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/');
$box_content = '';
// include needed functions
require_once DIR_FS_INC . 'vam_random_select.inc.php';
require_once DIR_FS_INC . 'vam_break_string.inc.php';
//fsk18 lock
$fsk_lock = '';
if ($_SESSION['customers_status']['customers_fsk18_display'] == '0') {
$fsk_lock = ' and p.products_fsk18!=1';
}
$random_select = "select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd, " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = r.products_id " . $fsk_lock . " and r.reviews_id = rd.reviews_id and rd.languages_id = '" . (int) $_SESSION['languages_id'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int) $_SESSION['languages_id'] . "'";
if ($product->isProduct()) {
$random_select .= " and p.products_id = '" . $product->data['products_id'] . "'";
}
$random_select .= " order by r.reviews_id desc limit " . MAX_RANDOM_SELECT_REVIEWS;
$random_product = vam_random_select($random_select);
if ($random_product) {
// display random review box
$review_query = "select substring(reviews_text, 1, 60) as reviews_text from " . TABLE_REVIEWS_DESCRIPTION . " where reviews_id = '" . $random_product['reviews_id'] . "' and languages_id = '" . $_SESSION['languages_id'] . "'";
$review_query = vamDBquery($review_query);
$review = vam_db_fetch_array($review_query, true);
$review = htmlspecialchars($review['reviews_text']);
$review = vam_break_string($review, 15, '-<br />');
$products_image = DIR_WS_THUMBNAIL_IMAGES . $random_product['products_image'];
if (!file_exists($products_image)) {
$products_image = DIR_WS_THUMBNAIL_IMAGES . '../noimage.gif';
}
$box_content = '<p><a href="' . vam_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $random_product['products_id'] . '&reviews_id=' . $random_product['reviews_id']) . '">' . vam_image($products_image, $random_product['products_name']) . '</a></p><a href="' . vam_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $random_product['products_id'] . '&reviews_id=' . $random_product['reviews_id']) . '">' . $review . ' ..</a><p>' . vam_image('templates/' . CURRENT_TEMPLATE . '/img/stars_' . $random_product['reviews_rating'] . '.gif', sprintf(BOX_REVIEWS_TEXT_OF_5_STARS, $random_product['reviews_rating'])) . '</p>';
} elseif ($product->isProduct()) {
// display 'write a review' box
$box_content = '<p><a href="' . vam_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, vam_product_link($product->data['products_id'], $product->data['products_name'])) . '">' . vam_image('templates/' . CURRENT_TEMPLATE . '/img/box_write_review.gif', IMAGE_BUTTON_WRITE_REVIEW) . '</a></p><p><a href="' . vam_href_link(FILENAME_PRODUCT_REVIEWS_WRITE, vam_product_link($product->data['products_id'], $product->data['products_name'])) . '">' . BOX_REVIEWS_WRITE_REVIEW . '</a></p>';
Released under the GNU General Public License
---------------------------------------------------------------------------------------*/
$box = new vamTemplate();
$box->assign('tpl_path', 'templates/' . CURRENT_TEMPLATE . '/');
$box_content = '';
// include needed functions
require_once DIR_FS_INC . 'vam_random_select.inc.php';
//fsk18 lock
$fsk_lock = '';
if ($_SESSION['customers_status']['customers_fsk18_display'] == '0') {
$fsk_lock = ' and p.products_fsk18!=1';
}
if (GROUP_CHECK == 'true') {
$group_check = " and p.group_permission_" . $_SESSION['customers_status']['customers_status_id'] . "=1 ";
}
if ($random_product = vam_random_select("select\n p.products_id,\n pd.products_name,\n p.products_price,\n p.products_tax_class_id,\n p.products_image,\n f.expires_date,\n p.products_vpe,\n\t\t\t\t p.products_vpe_status,\n\t\t\t\t p.products_vpe_value\n from " . TABLE_PRODUCTS . " p,\n " . TABLE_PRODUCTS_DESCRIPTION . " pd,\n " . TABLE_FEATURED . " f where p.products_status = '1'\n and p.products_id = f.products_id\n and pd.products_id = f.products_id\n and pd.language_id = '" . $_SESSION['languages_id'] . "'\n and f.status = '1'\n " . $group_check . "\n " . $fsk_lock . " \n order by f.featured_date_added\n desc limit " . MAX_RANDOM_SELECT_FEATURED)) {
$box->assign('box_content', $product->buildDataArray($random_product));
$box->assign('FEATURED_LINK', vam_href_link(FILENAME_FEATURED));
$box->assign('language', $_SESSION['language']);
if ($random_product["products_id"] != '') {
// set cache ID
if (!CacheCheck()) {
$box->caching = 0;
$box_featured = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_featured.html');
} else {
$box->caching = 1;
$box->cache_lifetime = CACHE_LIFETIME;
$box->cache_modified_check = CACHE_CHECK;
$cache_id = $_SESSION['language'] . $random_product["products_id"] . $_SESSION['customers_status']['customers_status_name'];
$box_featured = $box->fetch(CURRENT_TEMPLATE . '/boxes/box_featured.html', $cache_id);
}
