Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Newsbox, Adding Dynamic Items in Newsbox


oscommerceking

Recommended Posts

Hi all

 

I have the ad box successfully installed on my website and it has the moving text which shows some sort of news or what have you for whatever I place in there.

 

However I just want to pull certain items from my shopping cart and have it automatically update when i change the prices in my database

 

Can this be done, any fingers where to find information or approach to this one?

 

Thanks to you all Osc

 

Sincerely

 

Jon

Link to comment
Share on other sites

you can retrieve the products from the products and products_descriptions sql tables. Just order them by the products_last_modified, set a limit and send them for display to your ad box.

Link to comment
Share on other sites

  • 2 weeks later...
you can retrieve the products from the products and products_descriptions sql tables. Just order them by the products_last_modified, set a limit and send them for display to your ad box.

 

Thanks for the pointer.

 

Following the best_sellers.php formulae

 

 if (isset($current_category_id) && ($current_category_id > 0)) {
$best_sellers_query = tep_db_query("select distinct p.products_id, 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, 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 //-->
	 <TABLE WIDTH=160 BORDER=0 CELLPADDING=0 CELLSPACING=0>
<TR>
	<TD COLSPAN=3>
		<IMG SRC="http://yoursite.com/catalog/images/images/adbox.jpg" WIDTH=160 HEIGHT=90></TD>
</TR>
<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">' . tep_row_number_format($rows) . '.;<td class="infoBoxContents"><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('text' => $bestsellers_list);

new infoBox($info_box_contents);
?>

 

 

 

So within the adbox.php a sample call to my sql table would read

 

 

<!-- scroller //-->
	 <TABLE WIDTH=128 BORDER=0 CELLPADDING=0 CELLSPACING=0>
<TR>
	<TD COLSPAN=3>
		<IMG SRC="http://yoursite.com/catalog/images/images/adbox.jpg" WIDTH=160 HEIGHT=55></TD>
</TR>
<TR>
<td>
<?php
 $info_box_contents = array();
 $info_box_contents[] = array('align' => 'left',
						   'text'  => Adbox_info);
 new infoBoxHeading($info_box_contents, false, false);

 $info_box_contents = array();
 $filename = "./news.html";
 $fd = fopen ($filename, "r");
 $contents = fread ($fd, filesize ($filename));
 fclose ($fd);
 $info_box_contents[] = array('align' => 'left',
						   'text'  => '<center><marquee direction="up" height="250" scrollAmount="1" onMouseover="scrollAmount=0" onMouseout="scrollAmount=1">'.$contents.'</marquee></center>'

				);
 new infoBox($info_box_contents);

if (isset($current_category_id) && ($current_category_id > 0)) {
$adbox_query = tep_db_query("select distinct p.products_id, 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_ADBOX);
 } else {
$best_sellers_query = tep_db_query("select distinct p.products_id, 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($adbox_query) >= MIN_DISPLAY_BESTSELLERS) {

<?php
$info_box_contents = array();
$info_box_contents[] = array('text' => BOX_HEADING_ADBOX);

new infoBoxHeading($info_box_contents, false, false);

$rows = 0;
$adbox_list = '<table border="0" width="100%" cellspacing="0" cellpadding="1">';
while ($adbox_sellers = tep_db_fetch_array($adbox_query)) {
  $rows++;
  $adbox_list .= '<tr><td class="infoBoxContents" valign="top">' . tep_row_number_format($rows) . '.;<td class="infoBoxContents"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $best_sellers['products_id']) . '">' . $adbox['products_name'] . '</a></td></tr>';
}
$adbox .= '</table>';

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

new infoBox($info_box_contents);
?>

 

 

Will I have to run an sql statement to add, adbox to my database?

If not how does the code above look?

 

thanks for all of the insight

 

jon

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...