|
|
Posted by Steven Kalcevich on 11/18/05 00:07
actually i found a fix not there but via google search. belows the code
if anyone googles this in the future!
----
<?php
/*
$Id: products_new.php,v 1.27 2003/06/09 22:35:33 hpdl Exp $
osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com
Copyright (c) 2003 osCommerce
Released under the GNU General Public License
*/
require('includes/application_top.php');
require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCTS_NEW);
$breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_PRODUCTS_NEW));
?>
<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
<html <?php echo HTML_PARAMS; ?>>
<head>
<link rel="stylesheet" type="text/css" href="stylesheet.css">
<link rel="stylesheet" type="text/css" media="print" href="print.css">
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo
CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER :
HTTP_SERVER) . DIR_WS_CATALOG; ?>">
</head>
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0"
leftmargin="0" rightmargin="0">
<table align="left" width="805" height="100%" cellpadding="0"
cellspacing="0">
<tr>
<td align="center" valign="top">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->
<!-- body //-->
<img src="../gfx/x.gif" width="1" height="3"><br>
<table border="0" width="100%" cellspacing="3" cellpadding="0"
align="left">
<tr>
<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0"
width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
</table></td>
<td width="5"><img src="../gfx/x.gif" width="5" height="1"></td>
<!-- body_text //-->
<td width="100%" valign="top"><table border="0" width="100%"
cellspacing="0" cellpadding="0">
<tr>
<td>
<?php
// create column list
$define_list = array('PRODUCT_LIST_NAME' => PRODUCT_LIST_NAME,
'PRODUCT_LIST_MANUFACTURER' =>
PRODUCT_LIST_MANUFACTURER,
'PRODUCT_LIST_PRICE' => PRODUCT_LIST_PRICE,
'PRODUCT_LIST_MODEL' => PRODUCT_LIST_MODEL,
'PRODUCT_LIST_IMAGE' => PRODUCT_LIST_IMAGE);
asort($define_list);
$column_list = array();
reset($define_list);
while (list($column, $value) = each($define_list)) {
if ($value) $column_list[] = $column;
}
$select_column_list = '';
for ($col=0, $n=sizeof($column_list); $col<$n; $col++) {
if ( ($column_list[$col] == 'PRODUCT_LIST_BUY_NOW') ||
($column_list[$col] == 'PRODUCT_LIST_NAME') || ($column_list[$col] ==
'PRODUCT_LIST_PRICE') ) {
continue;
}
}
$listing_sql = "select p.products_id, pd.products_name,
p.products_image, p.products_price, p.products_date_added,
p.products_model, m.manufacturers_name from " . TABLE_PRODUCTS . " p
left join " . TABLE_MANUFACTURERS . " m on (p.manufacturers_id =
m.manufacturers_id), " . TABLE_PRODUCTS_DESCRIPTION . " pd where
p.products_status = '1' and p.products_id = pd.products_id and
TO_DAYS(NOW()) - TO_DAYS(p.products_date_added) < '" . '7' . "' and
pd.language_id = '" . (int)$languages_id . "' order by pd.products_name
ASC, m.manufacturers_name";
//$listing_sql = "select p.products_id, pd.products_name,
pd.products_description, p.products_image, p.products_price,
IF(s.status, s.specials_new_products_price, NULL) as
specials_new_products_price, p.products_date_added,
m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " .
TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id
left join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id =
pd.products_id and pd.language_id = '" . $languages_id . "' left join "
.. TABLE_SPECIALS . " s on p.products_id = s.products_id $where order by
pd.products_name ASC, pd.products_name";
include(DIR_WS_MODULES . FILENAME_PRODUCT_LISTING_COL);
?>
</td>
</tr>
</table></td>
</tr>
<?php
if (($products_new_split->number_of_rows > 0) &&
((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3'))) {
?>
<tr>
<td><table border="0" width="100%" cellspacing="0"
cellpadding="2">
<tr>
<td class="smallText"><?php echo
$products_new_split->display_count(TEXT_DISPLAY_NUMBER_OF_PRODUCTS_NEW);
?></td>
<td align="left" class="smallText"><?php echo
TEXT_RESULT_PAGE . ' ' .
$products_new_split->display_links(MAX_DISPLAY_PAGE_LINKS,
tep_get_all_get_params(array('page', 'info', 'x', 'y'))); ?></td>
</tr>
</table></td>
<?php
}
?>
<!-- body_text_eof //-->
</tr>
</table>
<!-- body_eof //-->
</td>
<td align="right" width="1" valign="top"
background="../gfx/line.gif"><img src="../gfx/x.gif" width="1"
height="1"></td>
</tr></table>
<br>
</body>
</html>
<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
--
cheers!!!!
Regards,
Steven Kalcevich
[Back to original message]
|