[contribution] Star Product

[Picto]

For some reason i get a lot of space under my buttons. Anyone know have to fix this. I woud like my buttons to be just over the frame. Or even better the frame smaller.

 

 

Thanks

 

 

This is for me the same!

 

Any solution yet!

[zozzoozzz]

Thanks for this useful CONTRI.

 

when i installed it on my store, this star product box have a double border , how to change the double border to one border arrounding it?

 

 

 

thanks

[girish_327]

Hello,

I am newbie in ocCommerce. I recently downloaded osCommerce free_oscommerce-22-rc2a from Template Monster. I tried to install Star Product on this but when I came to index page update and tried to find

 

5.- OPEN file:

/catalog/index.php

FIND:

<tr>

<td class="main"><?php echo TEXT_MAIN; ?></td>

</tr>

 

Its not there Now how can I install Star Product Please guide me.

[drumer979]

Hello

 

I installed star product, but in homapage box is blank ( in admin I select one product ). No errors are shown anywhere.

 

thx,

 

drumer979

[numero7]

Good Morning,

 

I just installed star Product everything is in place however I can't seem to get the actice button to activate. I hit the button. It refreshes the page but the button still stay inactive......No error messages or anything...

 

 

Hello maybe I come to late, but I had the same issue and I fixed it by removing the star_product table in my database and redo the sql query... it works fine now.. I think it's a primary key issue when you perform other queries on the database, but i'm not sure of it.. anyway it works well now.

[Patty]

anyone know why i get this weirdness?

 

i did everything right...no errors just no display on products,,,

It seems no one is supporting this contribution.

 

I was having the same problem in one of my stores, when it was working fine in all others. So I checked MySQL version and on the store with this problem the version was 4.1.22. The table for this contribution had no index key assigned, so I changed the key to primary and voilá! It works now!

 

Hope it helps. :)

[boadboard]

Hello everyone,

I liked this Star_product, but i have a problem. In my store, i can't put all products in star_product box. I try many things, but i can not. In other Forum, nobody can help me. I put below the code.

<?php
/*
 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com
 Copyright (c) 2009 osCommerce

 Created by Mindsparx 2009
 http://www.mindsparx.org
 Released under the GNU General Public License
*/
?>
<!-- Mindsparx specials //-->
<?php

 if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {
   $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, p.products_price, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_prix from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by RAND() limit " . MAX_DISPLAY_NEW_PRODUCTS);
 } else {
   $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, p.products_price, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_prix from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by RAND() limit " . MAX_DISPLAY_NEW_PRODUCTS);
 }

 $row = 0;
 $col = 0;
 $info_box_contents = array();
 while ($new_products = tep_db_fetch_array($new_products_query)) {
	$sql = 'SELECT `products_description` FROM `products_description` WHERE products_id ='.$new_products['products_id'].' && language_id='.(int)$languages_id;
	$description_query = tep_db_query($sql);
	$description = mysql_fetch_array($description_query, MYSQL_ASSOC);        
	$description['products_description'] = substr($description['products_description'], 0, 50);
	$desc_len = strlen($description['products_description']);
   	$show['desc'] = $description['products_description'] ;



   $info_box_contents[$row][$col] = array('align' => 'center',
                                          'params' => ' ',
                                          'text' => '

									<table class="box_outline3"  width="98%" border="0" cellspacing="5" cellpadding="0">
 <tr>
  <td align="left" valign="top"><div style="padding-top:10px;"><a class="specials_name" href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a></div><div align="left" class="specials_desc">'.$show['desc'].'...</div></td>
   <td width="80" rowspan="3" align="center" valign="middle"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a></td>
 </tr>
 <tr>
   <td height="20" align="center" class="specials_old_price" valign="bottom">'. SPECIALS_OLD_PRICE .'<s>' . $currencies->display_price_nodiscount($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])) . '</s></td>
 </tr>
 <tr>
   <td height="30" valign="top"><table align="center" width="96" border="0" cellspacing="0" cellpadding="0">
 <tr>
   <td align="center" width="96" height="26" background="images/special_price.gif"><span class="specials_price">'. SPECIALS_PRICE .'' . $currencies->display_price_nodiscount($new_products['products_prix'], tep_get_tax_rate($new_products['products_tax_class_id'])) . '</span></td> 
 </tr>
</table>
</td>
 </tr>
</table>'

);	
   $col ++;
   if ($col > 1) {
     $col = 0;
     $row ++;
   }
 }
 new contentBox($info_box_contents);
?>
<!-- Mindsparx specials //-->

 

I hope your helps

Thanks everyone

[luuuciano]

It seems no one is supporting this contribution.

 

I was having the same problem in one of my stores, when it was working fine in all others. So I checked MySQL version and on the store with this problem the version was 4.1.22. The table for this contribution had no index key assigned, so I changed the key to primary and voilá! It works now!

 

Hope it helps. :)

 

I am having this same problem!

I have changed that table to primary, as you suggested... but nothing changed... the star product do not show any ID assigned (like the screen shot up there)

 

any idea? :(

 

pd: a friend of mine have a working star product setup... without primary key assigned... and it works like a charm...

Edited July 12, 2010 by luuuciano

[repare31]

Hi from france,

 

what to add more than 1 star product ?

 

thanks..

[The ANT man]

Hey All

 

I just installed this mod but it seems something in the code below is not php5 compliant as i get the same error as some of the above being "1054 - Unknown column 'p.products_id' in 'on clause'

".

 

Can anyone clued up have a look at this code please?

 

<?php
//REMOVE THIS LINES IF YOU DON'T WANT TO SHOW THE HEADER
 $header_star_product = array();
 $header_star_product[] = array('align' => 'center', 'text' => sprintf(STAR_TITLE));
 new contentBoxHeading($header_star_product);
//END OF -REMOVE THIS LINES IF YOU DON'T WANT TO SHOW THE HEADER-

 function tep_star_product_with_attributes($products_id) {
 $attributes_query = tep_db_query("select count(*) as count from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . (int)$products_id . "'");
 $attributes = tep_db_fetch_array($attributes_query);

 if ($attributes['count'] > 0) {
   return true;
 }
 else {
   return false;
   }
 }

 $star_products_query = tep_db_query("select substring(pd.products_description, 1, 598) as products_description, p.products_id, p.products_image, p.manufacturers_id, p.products_price, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price, p.products_tax_class_id, sp.product_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_STAR_PRODUCT . " sp left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where p.products_id = pd.products_id and p.products_status = '1' and pd.products_description != '' and p.products_id=sp.product_id and pd.language_id = '" . $languages_id . "'");
 $star_products = tep_db_fetch_array($star_products_query);
 $star_products['products_name'] = tep_get_products_name($star_products['products_id']);
 $evita_cortar_palabras = explode( ' ',  $star_products["products_description"] );
array_pop( $evita_cortar_palabras );
$star_products["products_description"]  = implode( ' ', $evita_cortar_palabras );

if (!tep_star_product_with_attributes($star_products['products_id'])) {
 $star_products["0"] = array('align' => 'center',
			      'params' => 'width="100%" valign="top"',
                                     'text' => '<tr>
			      		   <td height="15%" width="85%" class="star-product-title">' . $star_products['products_name'] . '</td>
					   <td align="right"  height="100%" width="15%" rowspan="2"><a href="' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $star_products['products_id']) . '"' . ' target="popup"' . ' onClick="window.open(this.href, this.target, \'toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=no, resizable=yes, copyhistory=no, width=' . SMALL_IMAGE_WIDTH . ', height=' . SMALL_IMAGE_HEIGHT . '\').focus(); return false;">' . tep_image(DIR_WS_IMAGES . $star_products['products_image'], $star_products['products_name'], SMALL_IMAGE_WIDTH*2, SMALL_IMAGE_HEIGHT*2) . '</a></td>
					 </tr>
					 <tr>
					   <td height="80%" width="85%" class="star-product">'. strip_tags($star_products["products_description"]) . '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, "products_id=" . $star_products["products_id"]). '">' . STAR_READ_MORE . '</a></td>
					 </tr>
					 <tr>
					   <td height="5%" width="85%" class="star-product-price" align="center">'.
$currencies->display_price($star_products['final_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</td>
					 </tr>
					 <tr>
					   <td><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, "products_id=" . $star_products["products_id"]). '">' . tep_image(DIR_WS_LANGUAGES . $language . '/images/buttons/more_info.gif') . '</a>' . tep_draw_separator('pixel_trans.gif', '10', '10') . '<a href="' . tep_href_link(FILENAME_DEFAULT, tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $star_products['products_id']) . '">' . tep_image_button('button_buy_now.gif', IMAGE_BUTTON_IN_CART) . '</a></td>
					 </tr>');
$star_products_output = array_slice($star_products, sizeof($star_products)-1);
new contentBox($star_products_output);
}

else {
 $star_products["0"] = array('align' => 'center',
			      'params' => 'width="100%" valign="top"',
                                     'text' => '<tr>
			      		   <td height="15%" width="85%" class="star-product-title">' . $star_products['products_name'] . '</td>
					   <td align="right"  height="100%" width="15%" rowspan="2"><a href="' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $star_products['products_id']) . '"' . ' target="popup"' . ' onClick="window.open(this.href, this.target, \'toolbar=no, location=no, directories=no, status=no, menubar=no, scrollbars=no, resizable=yes, copyhistory=no, width=' . SMALL_IMAGE_WIDTH . ', height=' . SMALL_IMAGE_HEIGHT . '\').focus(); return false;">' . tep_image(DIR_WS_IMAGES . $star_products['products_image'], $star_products['products_name'], SMALL_IMAGE_WIDTH*2, SMALL_IMAGE_HEIGHT*2) . '</a></td>
					 </tr>
					 <tr>
					   <td height="80%" width="85%" class="star-product">'. strip_tags($star_products["products_description"]) . '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, "products_id=" . $star_products["products_id"]). '">' . STAR_READ_MORE . '</a></td>
					 </tr>
					 <tr>
					   <td height="5%" width="85%" class="star-product-price" align="center">'.
$currencies->display_price($star_products['final_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</td>
					 </tr>
					 <tr>
					   <td><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, "products_id=" . $star_products["products_id"]). '">' . tep_image(DIR_WS_LANGUAGES . $language . '/images/buttons/more_info.gif') . '</a>' . tep_draw_separator('pixel_trans.gif', '10', '10') . '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $star_products['products_id']) . '">' . tep_image_button('button_buy_now.gif', IMAGE_BUTTON_IN_CART) . '</a></td>
					 </tr>');
new contentBox($star_products);
}
?>

[The ANT man]

up up up