Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[contribution] Star Product


euskopc

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!

Link to comment
Share on other sites

  • 3 weeks later...
  • Replies 135
  • Created
  • Last Reply

Top Posters In This Topic

  • 3 weeks later...

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.

Link to comment
Share on other sites

  • 2 months later...
  • 2 months later...

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

Link to comment
Share on other sites

  • 5 weeks later...

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

Link to comment
Share on other sites

  • 1 month later...

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

Link to comment
Share on other sites

  • 4 months later...

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
Link to comment
Share on other sites

  • 3 weeks later...

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

Link to comment
Share on other sites

  • 3 months later...

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

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...