best sellers scroll

Udbygger du din osC-shop med flere moduler, eller er du faldet over et godt modul, så brug dette forum.
Både spørgsmål og indlæg er velkomne her.

Redaktør: Redaktionen

best sellers scroll

Indlægaf johank » 2005-03-28 02:22

Jeg har hentet best sellers scroll men vil gerne have den centret er der nogle der kan hjælpe....

Har selv løst det satte center ind lige før linket hvor oplysningerne bliver hentet... :oops:

<?php
/*
$Id: best_sellers.php,v 1.21 2003/06/09 22:07:52 hpdl Exp $

osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com

Copyright (c) 2003 osCommerce

Released under the GNU General Public License



*/

if (isset($current_category_id) && ($current_category_id > 0)) {
$best_sellers_query = tep_db_query("select distinct p.products_id, p.products_image, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and '" . (int)$current_category_id . "' in (c.categories_id, c.parent_id) order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS);
} else {
$best_sellers_query = tep_db_query("select distinct p.products_id, p.products_image, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_ordered desc, pd.products_name limit " . MAX_DISPLAY_BESTSELLERS);
}

if (tep_db_num_rows($best_sellers_query) >= MIN_DISPLAY_BESTSELLERS) {
?>
<!-- best_sellers_scroll //-->
<tr>
<td>
<?php


$info_box_contents = array();
$info_box_contents[] = array('text' => BOX_HEADING_BESTSELLERS);

new infoBoxHeading($info_box_contents, false, false);

$rows = 0;
$bestsellers_list = '<table border="0" width="100%" cellspacing="0" cellpadding="1">';
while ($best_sellers = tep_db_fetch_array($best_sellers_query)) {
$rows++;
$bestsellers_list .= '<tr><td class="infoBoxContents " valign="top">' . '</td><td class="infoBoxContents" align"center,>'. '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']) . '">' .tep_image(DIR_WS_IMAGES . $best_sellers['products_image'], $best_sellers['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT).'<br>'. tep_row_number_format($rows). '. <a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']) . '">' . $best_sellers['products_name'] . '</a></td></tr>';
}
$bestsellers_list .= '</table>';

$info_box_contents = array();
$info_box_contents[] = array('align' => "center",'text' => '<MARQUEE behavior= "scroll" align= "center" direction= "up" height="160" scrollamount= "1" scrolldelay= "70" onmouseover=\'this.stop()\' onmouseout=\'this.start()\'>'.$bestsellers_list.'</MARQUEE>');

new infoBox($info_box_contents);
?>
</td>
</tr>
<!-- best_sellers_scroll_eof //-->
<?php
}
?>
Brugeravatar
johank
Novice
Novice
 
Indlæg: 6
Tilmeldt: 2005-03-13 20:18
Geografisk sted: Albertslund

Tilbage til Contributions/Moduler (NY)

Hvem er online

Brugere der læser dette forum: Ingen tilmeldte og 19 gæster

cron