Community Add-Ons

FIX INSTALL

1- Replace file star_product.php in catalog/admin/ with this in contribution not in catalog/admin/includes/modules path.

Sorry

now you're choose more star product and this display random in index page

Hi, i forgot some styles for the border around the box ..
Sorry about that


New full package

This contribution has a few different version and many of the original features are broken.

In this version tax and special price works again and it has some graphics to make it look a bit better.

Full package including starproducts 1.6 and my uppdated files in a separate folder

You can see what it looks like here
http://www.mindsparx.org/mindsparx_starprod2/

All credit goes to the original authors for this great contribution...

Tooltip is a Rollover zoomimage javascript.
Easy to install.

Note: this update only work with 3images contrib or Additional_Images contrib

Exemple: www.expodreams.com/gallery/index.php

Enjoy!

I work only with firefox, its working very well.
I've had to do updates for IE. It is now OK!
Sorry for any inconvenience ..
Full package

Tooltip is a rollover image box, without htlmpopup page.
Very nice and easy to install

Apliccations:
Star Product
Featured products
New products
Listing products (also manufacturers products)

Work with:
3images contrib(contributions,1346)
Additional_Images contrib(tested with v2.0.0)

Example of this code
http://www.expodreams.com/gallery/index.php

Tooltip is a rollover image box, without htlmpopup page.
Very nice and easy to install

Apliccations:
Star Product
Featured products
New products
Listing products (also manufacturers products)

Work with:
3images contrib(contributions,1346)
Additional_Images contrib(tested with v2.0.0)

Example of this code
http://www.expodreams.com/gallery/index.php

Ignore the one i uploaded before, tax didnt work properly

Hi!
I have used this contribution for years, and i just realized that i have done a pimped version of it that i would like to share ;)

you can see a picture of it here:
http://www.mindsparx.se/demo_pic.htm

This is based on version 1.6 since it was done before hardcore_chad´s version... but it works well.

Hi guys!

Just finished doing a bit of moving and incorporating of old updates with the complete package.

I've made the following changes:
- The photo does not link anywhere
- The More info link is replaced with "..."
* I made these mods to allow the index page to be more SEO friendly. osC has many links in the index page already. Adding 4 more, with 2-3 pointing to the product info page is redundant.
- Picture resized to its original thumbnail size
- The price is already right below the product picture
- The tax price update is already included
- I wasn't able to incorporate the "acive or inactive " prod mod by lildog because the syntax phrase in my file is different from his, out of the box. Just do not add anything that is disabled in the product listing. It will just show a blank star product box. No worries.

NOTE: The file included in this package is for the catalogincludesmodules area.

Cheers!

This mod only allows you to select products that have an enabled status. Optional categories staus included.
in catalog/admin/star_product.php:

FIND:
$star_query = tep_db_query("select p.products_id, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' order by pd.products_name");


REPLACE WITH: (if you do not have Enable & Disable Categories contrib installed)
$star_query = tep_db_query("select p.products_id, pd.products_name, p.products_status from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_status = '1' order by pd.products_name");

OR

REPLACE WITH: (if you have Enable & Disable Categories contrib installed)
$star_query = tep_db_query("select p.products_id, pd.products_name, p.products_status from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd left join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id left join " . TABLE_CATEGORIES . " c on p2c.categories_id = c.categories_id where p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_status = '1' and c.categories_status = '1' order by pd.products_name");

I had a problem with 1.6 were the price was displayed without V.A.T (UK Tax)

I managed to solve it with the following
in catalogincludesmodulesstar_products.php replace lines 39 and 60 (which should be)
$currencies->display_price($star_products['final_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</td>

With this

$products_price = $currencies->display_price($star_products['products_price'], tep_get_tax_rate($star_products['products_tax_class_id'])) . '</td>

COMPLETE PACK:

- include all fixes and changes of before versions, all credits for they authors. Module can be select active o not active and select the star product by the admin side. With version Star Product v 1.5c (by mickeymouse)
- unified sql changes in one file star_product.sql (the new table start_product and sql of Star Product v 1.5c) for a easy install.
- include fix to don´t cut words (Another quick fix by Iván Prieto 13 Dec 2004)
- a better order of installation steps for not display errors during installation
- include install instructions in spanish
- screenshots of admin configuration of star product and Star Product module of main index page of catalog.
- Folder called: catalog_for_new_shops_only, that include all files changed with this contribution for upload to new shop only that didn´t have modifications in his files.


DEMO:

http://www.oscommerce-demo.com/demo01/

(this demo include graphical modification of modules and boxes not include in this contribution)



FORUM SUPPORT:

http://forums.oscommerce.com/index.php?showtopic=106740&st=0





---------



PACK COMPLETO:

- incluye todas las correciones y añadidos de las versiones anteriores, todos los creditos corresponden a cada uno de sus autores. El modulo puede ser activado para ser visible o no, y seleccionado el producto estrella, desde el admin. por Star Product v 1.5c (by mickeymouse)
- creacion de instrucciones en español
- unificacion de los cambios para la base de datos, en un solo archivo sql: star_product.sql (la nueva tabla que introduce la contribucion start_product y el cambio introducido en la version Star Product v 1.5c) para una mas facil instalacion.
- incluye la correcion para que no corte palabras en la descripcion (de la version "Another quick fix" creada por Iván Prieto el 13 Dec 2004)
- orden de las instrucciones cambiado para que no se muestren errores en la portada del catalogo durante la instalacion.
- nuevos screenshots imagenes de ejemplo y carpeta con todos los archivos modificados para tiendas nuevas sin cambios en los archivos.
- incluye carpeta llamada catalog_for_new_shops_only, que incluye todos los archivos modificados por esta contribucion para subir a tiendas nuevas que no tengan modificaciones en sus archivos o contribuciones instaladas.


DEMO:

http://www.oscommerce-demo.com/demo01/

(esta demo incluye modificaciones del aspecto grafico de los modulos del catalogo no incluidas en este pack)



FORO DE SOPORTE de esta version en español:

http://foros.oscommerce-tutoriales.com/index.php/topic,108.0.html



FOROS DE SOPORTE EN ESPAÑOL de osCommerce:

http://oscommerce.qadram.com

Minor update:
A slight addition to Expert's update. His new admin ability of turning the Star Product on or off is great however it called a configuration value that didn't exist.

Run this sql command on your database:
INSERT INTO `configuration` VALUES (768, 'Show Start Product', 'SHOW_STARPRODUCT', 'false', 'Show Star Product on Index Page', 1, 154, '2006-08-12 19:45:03', '2003-08-14 00:25:08', NULL, 'tep_cfg_select_option(array(''false'', ''true''),');

Next...to get rid of the star product box on the index page when turned off in admin:

Find these lines:
<tr>
<td><?php include(DIR_WS_MODULES . FILENAME_STAR_PRODUCT); ?></td>
</tr>

And replace with these:
<?
// STAR PRODUCT START...
if (SHOW_STARPRODUCT=="true") {
?>
<tr>
<td><?php include(DIR_WS_MODULES . FILENAME_STAR_PRODUCT); ?></td>
</tr>

<?
}
// STAR PRODUCT END...
?>

That's it...
All credit goes to the original authors...I just updated it a touch.

File included is just a text file w/ tese changes. This is not a complete package

With this small modification you can enable/disable your star product status in star product select page in admin. No need to go Admin->Configuration to set its status.

Some cosmetics table arrangements are also available.
A screenshot is included..

Just replace your /catalog/admin/star_product.php

Warning: Please backup your current file....

Download this one... Previous one contains unnecessary test attrib in table tag.. (abidik) :)

Replace;

/catalog/includes/modules/star_product.php

with this one provided in Zip

If you have html formmatted product_info this fix remove all html tags from taken part of product_info text. Otherwise unclosed tags cause imporper html output. (For example; is there is <table> tag at the beginning, modul graps some part of it before closing the </table> tag. Imagine what happens?

someone please help us out with this SQL error:

In the database it says;

"No index identified"

================================

At the site i get an:

1146 - Table 'smartmediastore_nl_-_store1.TABLE_STAR_PRODUCT' doesn't exist

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 products p, products_description pd, TABLE_STAR_PRODUCT sp left join 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 = '5'

[TEP STOP]

==================================

This post includes the origenal SQL file...don't know what to do. Please help out

With this quick fix Star Product don't cut words:

1.-Open catalog/includes/modules/star_product.php
2.-Search this line:
$star_products['products_name'] = tep_get_products_name($star_products['products_id']);
3.-Add this after it:
$evita_cortar_palabras = explode( ' ', $star_products["products_description"] );
array_pop( $evita_cortar_palabras );
$star_products["products_description"] = implode( ' ', $evita_cortar_palabras );
4.-Done

Simple update to change the visibility of the Star Product module via Admin.

Just the update instructions, not the whole package!

Have fun!

Star Product v1.5

German Translation included
Possibility to show the image left or right!

====================================

Star Product v1.5

Deutsche Übersetzung hinzugefügt
Möglichkeit das Bild links oder recht anzeigen zu lassen!

Bug fixed (Correct end of tables).

******UPDATE******
If you have a previous version of Star Product:

Open star_product.php and search this line:

new contentBox($star_products);

Replace with this:

$star_products_output = array_slice($star_products, sizeof($star_products)-1);
new contentBox($star_products_output);

******Support*******

http://forums.oscommerce.com/index.php?showtopic=106740

Bug fixed: When the Star Product has options the "Buy now" button didn't work
Bigger image size.

If you like this contribution help to the community adding code, languages, or ...

-Added product price.
-Deleted the title link.
-Changed the image link from "product info" to "enlarge image".
-Modifed the install instructions, I forgot in the other versions to include the styles.
-Added support to thumbnails (Thanks Burt).

If you are upgrading, you must to replace the star_product.php file (If you cant replace the file be carefull, there are many changes) and read the install instructions for adding styles to the contribution.

Fixed bugs, if you are using Star Product v1.0 you need to replace: catalog/admin/star_product.php
(Do it although your contrib runs correctly, if you delete in the database the product that is selected in "Star Product" the contribution will stop working)

I think the sSQL file is not correct, please correct.

Star Product, add to your main page a new box under your welcome text (you can replace this text with this contrib) with one featured product.

This box have the title, description, product image and two buttons: "info" and "buy now"

The description is limited to a number of characters if it exceds a "read more" link appears.

You can select the star product by the admin side.