Jump to content
Sign in to follow this  
euskopc

[contribution] Star Product

Recommended Posts

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.

 

star.jpg

 

Thanks

 

 

This is for me the same!

 

Any solution yet!

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Hello

 

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

 

thx,

 

drumer979

Share this post


Link to post
Share on other sites

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.


STS 4.5.8

Share this post


Link to post
Share on other sites

anyone know why i get this weirdness?

starproductweirdnesszr3.jpg

 

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. :)


Patty

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 by luuuciano

Share this post


Link to post
Share on other sites

Hi from france,

 

what to add more than 1 star product ?

 

thanks..


oscommerce-2.2rc2a - HeaderTags_SEO_V_3.1.8 - Ultimate_SEO_URLSv22d_9 - SEO-images-rename-1.0 - Dynamic Image Resizer_1 - fancybox - dynamic_sitemap_v4_21 - csv_import_v2_1_3 - colissimo_v1.9 - export_csv_xml - thumb_watermark - short_descriptionV1.2 - more_pics_6_v1.4.3 - Ask a question_1_2 - Stats_Products_Stocklevel 1_5_1 - category_box_+_no_qty_category - large_search - ip_on_mail - Tinymce - loging_box - new_prod_list_likebestseller_+_featured_product - cgv_acceptation - Product_Truncated_Description_v_1.5 - discount-or-payment-surcharge-v1.1 - trackingcolissimo+ups102 - reclamaposte_10 - InvoicePDF1.5

Share this post


Link to post
Share on other sites

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);
}
?>

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×