- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
- 64
- 65
- 66
- 67
- 68
- 69
- 70
- 71
- 72
- 73
- 74
- 75
- 76
- 77
- 78
- 79
- 80
- 81
- 82
- 83
- 84
- 85
- 86
- 87
- 88
- 89
- 90
- 91
- 92
<?php
/*
$Id: specials.php,v 1.1.1.1 2004/03/04 23:42:27 ccwjr Exp $
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
Copyright (c) 2003 osCommerce
CRE Loaded , Open Source E-Commerce Solutions
http://www.creloaded.com
Chain Reaction Works, Inc
Portions: Copyright © 2005 - 2006 Chain Reaction Works, Inc.
Last Modified by $Author$
Last Modifed on : $Date$
Latest Revision : $Revision:$
Released under the GNU General Public License
*/
if(!tep_session_is_registered('sppc_customer_group_id')) {
$customer_group_id = 'G';
} else {
$customer_group_id = $sppc_customer_group_id;
}
$random_product25 = tep_db_query("select distinct
p.products_id,
pd.products_name,
IF(pg.customers_group_price IS NOT NULL,pg.customers_group_price, p.products_price) as products_price,
p.products_tax_class_id,
p.products_image,
s.specials_new_products_price
from " . TABLE_PRODUCTS . " p
left join " . TABLE_PRODUCTS_GROUPS . " pg on p.products_id = pg.products_id and pg.customers_group_id like '%" . $customer_group_id . "%',
" . TABLE_PRODUCTS_DESCRIPTION . " pd,
" . TABLE_SPECIALS . " s
where
p.products_status = '1'
and p.products_id = s.products_id
and pd.products_id = s.products_id
and pd.language_id = '" . (int)$languages_id . "'
and s.status = '1'
and p.products_group_access like '%". $customer_group_id."%'
order by rand(), s.specials_date_added desc limit " . MAX_RANDOM_SELECT_SPECIALS);
$random_product24_side_row = tep_db_num_rows($random_product25);
if ($random_product24_side_row > 0){
// EOF Separate Price per Customer
//Eversun mod end for sppc and qty price breaks
?>
<!-- d specials //-->
<tr>
<td>
<?php
while ($product_specials22 = tep_db_fetch_array($random_product25)){
$product_specials22_id = $product_specials22['products_id'];
$product_specials22_image = tep_get_products_image($product_specials22['products_id']);
$product_specials22_name = tep_get_products_name($product_specials22['products_id']);
$pf->loadProduct($product_specials22['products_id'],$languages_id);
$special_random_price = $pf->getPriceStringShort();
}
$info_box_contents = array();
$info_box_contents[] = array('text' => '<font color="' . $font_color . '">' . BOX_HEADING_SPECIALS . '</font>');
new infoBoxHeading($info_box_contents, tep_href_link(FILENAME_SPECIALS));
$info_box_contents = array();
$info_box_contents[] = array('align' => 'center',
'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $product_specials22_id) . '">' . tep_image(DIR_WS_IMAGES . $product_specials22_image, $product_specials22_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $product_specials22_id) . '">' . $product_specials22_name . '</a><br>' . $special_random_price);
new infoBox($info_box_contents);
if (TEMPLATE_INCLUDE_FOOTER =='true'){
$info_box_contents = array();
$info_box_contents[] = array('align' => 'left',
'text' => tep_draw_separator('pixel_trans.gif', '100%', '1')
);
new infoboxFooter($info_box_contents);
}
?>
</td>
</tr>
<!-- d specials_eof //-->
<?php
}
?>
Follow us!