Community Add-Ons

This great contribution should have its own thread. It can now be found at:

http://forums.oscommerce.com/topic/368948-contribution-products-tabs/

**************************************************************************************************************
|What does it work for?|
|______________________|

Ans:It makes the checkbox ("Product in Description") in advanced_search.php site to work correctly.


-Open the catalog/advanced_search_results.php file.
=============================================================================================================

#####Find:
if (isset($HTTP_GET_VARS['search_in_description']) && ($HTTP_GET_VARS['search_in_description'] == '1')) $where_str .= " or pd.products_description like '%" . tep_db_input($keyword) . "%'";

#####Replace with:

//BOF: Search in Products Tabs (by faaliyet)
if (isset($HTTP_GET_VARS['search_in_description']) && ($HTTP_GET_VARS['search_in_description'] == '1')) $where_str .= " or pd.products_description like '%" . tep_db_input($keyword) . "%' or pd.products_spec like '%" . tep_db_input($keyword) . "%' or pd.products_musthave like '%" . tep_db_input($keyword) . "%' or pd.products_extraimage like '%" . tep_db_input($keyword) . "%' or pd.products_manual like '%" . tep_db_input($keyword) . "%' or pd.products_extra1 like '%" . tep_db_input($keyword) . "%' or pd.products_moreinfo like '%" . tep_db_input($keyword) . "%'";
//EOF: Search in Products Tabs (by faaliyet)

================================================ That's All. =================================================

**************************************************************************************************************

This is a addon to the Product Tabs 2.1 (Fixed and Full English Version Modified by Waleed Hagag).

I provid this since I thought that the information in the package by Mr Waleed Hagag) didn't work very well regarding how to include the Fck editor.

Include the Fck editor:

1)
Start by download the latest Fck editor from the Fck editor homepage.
2)
Create a new directory in your osCommerce directory named Fckeditor (you can name it whatever you like and place it someware else but then you have to change some of the codes below).
3) Upload all the files in the Fck editor package to this directory.
4) Make the following changes to the admin/include/modules/product_tabs.php file

On the first line add the following:

<?php
require_once("../fckeditor/fckeditor.php") ;
?>

Then replace everything after this:

<ul class="domtabs">
<li><a href="#t1<?=$i?>"><?PHP ECHO TEXT_TAB_DESCRIPTION;?></a></li>
<li><a href="#t2<?=$i?>"><?PHP ECHO TEXT_TAB_SPEC;?></a></li>
<li><a href="#t3<?=$i?>"><?PHP ECHO TEXT_TAB_MUSTHAVE;?></a></li>
<li><a href="#t4<?=$i?>"><?PHP ECHO TEXT_TAB_EXTRAIMAGE;?></a></li>
<li><a href="#t5<?=$i?>"><?PHP ECHO TEXT_TAB_MANUAL;?></a></li>
<li><a href="#t6<?=$i?>"><?PHP ECHO TEXT_TAB_EXTRA1;?></a></li>
<li><a href="#t7<?=$i?>"><?PHP ECHO TEXT_TAB_MOREINFO;?></a></li>
</ul>

With the following:

<div class="tabcontent">
<a name="t1<?=$i?>" id="t1<?=$i?>"></a>
<table border="0" cellspacing="0" cellpadding="1" width="700px">
<tr align="left">
<td valign="top" class="main_white" height="500px"> <?PHP ECHO TEXT_TAB_DESCRIPTION;?><br />
<?php
$oFCKeditor = new FCKeditor('products_description[' . $languages[$i]['id'] . ']');
$oFCKeditor->BasePath = '../fckeditor/' ;
$oFCKeditor->Value = tep_get_products_description($pInfo->products_id, $languages[$i]['id']) ;
$oFCKeditor->Create() ;
?>
</td>
<td><?php //echo TEXT_PRODUCTS_DESCRIPTION; ?><br>
<?php //echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']); ?></td>
</tr>
</table>
<a href="#top"></a>
</div>

<div class="tabcontent">
<a name="t2<?=$i?>" id="t2<?=$i?>"></a>
<table border="0" cellspacing="0" cellpadding="1" width="700px">
<tr align="left">
<td valign="top" class="main_white" height="500px"> <?PHP ECHO TEXT_TAB_SPEC;?><br />
<?php
$oFCKeditor = new FCKeditor('products_spec[' . $languages[$i]['id'] . ']');
$oFCKeditor->BasePath = '../fckeditor/' ;
$oFCKeditor->Value = tep_get_products_spec($pInfo->products_id, $languages[$i]['id']) ;
$oFCKeditor->Create() ;
?>
</td>
<td><?php //echo TEXT_PRODUCTS_SPEC; ?><br>
<?php //echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']); ?></td>
</tr>
</table>
<a href="#top"></a>
</div>

<div class="tabcontent">
<a name="t3<?=$i?>" id="t3<?=$i?>"></a>
<table border="0" cellspacing="0" cellpadding="1" width="700px">
<tr align="left">
<td valign="top" class="main_white" height="500px"> <?PHP ECHO TEXT_TAB_MUSTHAVE;?><br />
<?php
$oFCKeditor = new FCKeditor('products_musthave[' . $languages[$i]['id'] . ']');
$oFCKeditor->BasePath = '../fckeditor/' ;
$oFCKeditor->Value = tep_get_products_musthave($pInfo->products_id, $languages[$i]['id']) ;
$oFCKeditor->Create() ;
?>
</td>
<td ><?php //echo TEXT_PRODUCTS_MUSTHAVE; ?><br>
<?php //echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']); ?></td>
</tr>
</table>
<a href="#top"></a>
</div>

<div class="tabcontent">
<a name="t4<?=$i?>" id="t4<?=$i?>"></a>
<table border="0" cellspacing="0" cellpadding="1" width="700px">
<tr align="left">
<td valign="top" class="main_white" height="500px"> <?PHP ECHO TEXT_TAB_EXTRAIMAGE;?><br />
<?php
$oFCKeditor = new FCKeditor('products_extraimage[' . $languages[$i]['id'] . ']');
$oFCKeditor->BasePath = '../fckeditor/' ;
$oFCKeditor->Value = tep_get_products_extraimage($pInfo->products_id, $languages[$i]['id']) ;
$oFCKeditor->Create() ;
?>
</td>
<td><?php //echo TEXT_PRODUCTS_EXTRAIMAGE; ?><br>
<?php //echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']); ?></td>
</tr>
</table>
<a href="#top"></a>
</div>

<div class="tabcontent">
<a name="t5<?=$i?>" id="t5<?=$i?>"></a>
<table border="0" cellspacing="0" cellpadding="1" width="700px">
<tr align="left">
<td valign="top" class="main_white" height="500px"> <?PHP ECHO TEXT_TAB_MANUAL;?><br />
<?php
$oFCKeditor = new FCKeditor('products_manual[' . $languages[$i]['id'] . ']');
$oFCKeditor->BasePath = '../fckeditor/' ;
$oFCKeditor->Value = tep_get_products_manual($pInfo->products_id, $languages[$i]['id']) ;
$oFCKeditor->Create() ;
?>
</td>
<td><?php //echo TEXT_PRODUCTS_MANUAL; ?><br>
<?php //echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']); ?></td>
</tr>
</table>
<a href="#top"></a>
</div>

<div class="tabcontent">
<a name="t6<?=$i?>" id="t6<?=$i?>"></a>
<table border="0" cellspacing="0" cellpadding="1" width="700px">
<tr align="left">
<td valign="top" class="main_white" height="500px"> <?PHP ECHO TEXT_TAB_EXTRA1;?><br />
<?php
$oFCKeditor = new FCKeditor('products_extra1[' . $languages[$i]['id'] . ']');
$oFCKeditor->BasePath = '../fckeditor/' ;
$oFCKeditor->Value = tep_get_products_extra1($pInfo->products_id, $languages[$i]['id']) ;
$oFCKeditor->Create() ;
?>
</td>
<td><?php //echo TEXT_PRODUCTS_EXTRA1; ?><br>
<?php //echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']); ?></td>
</tr>
</table>
<a href="#top"></a>
</div>
<div class="tabcontent">
<a name="t7<?=$i?>" id="t7<?=$i?>"></a>
<table border="0" cellspacing="0" cellpadding="1" width="700px">
<tr align="left">
<td valign="top" class="main_white" height="500px"> <?PHP ECHO TEXT_TAB_MOREINFO;?><br />
<?php
$oFCKeditor = new FCKeditor('products_moreinfo[' . $languages[$i]['id'] . ']');
$oFCKeditor->BasePath = '../fckeditor/' ;
$oFCKeditor->Value = tep_get_products_moreinfo($pInfo->products_id, $languages[$i]['id']) ;
$oFCKeditor->Create() ;
?>
</td>
<td><?php //echo TEXT_PRODUCTS_MOREINFO; ?><br>
<?php //echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']); ?></td>
</tr>
</table>
<a href="#top"></a>
</div>
</td></tr></table>


This it all you have to do to get the Fck editor to work but if you also want to be able to upload images to the tabs then you have to make one more adjustment.

Make the following changes to the fckeditor/editor/filemanager/connectors/php/config.php file:

Find this
$Config['Enabled'] = false ;

Change it to:
$Config['Enabled'] = true ;

That is all, now you will have a Fckeditor that works for you and allows you to edit the tabs.

Boffa


The complete product_tabs.php file is included in the zip package.

Product Tabs 2.1 ( Fixed and Full Version Modified by Waleed Hagag )

Fixed many problems and enhanced many things , mainly solve the problem

Parse error: syntax error, unexpected $end in /hsphere/local/home

/includes/boxes/categories.php on line

This is my post :
http://forums.oscommerce.com/index.php?showtopic=318979&st=0&p=1326509&#entry1326509


ENGLISH Full package uploaded
rename the extension to (rar) instead of (zip)
it's winrar file and use winrar to decompress it

to use the wysiwyg with product tabs and header tags use this.

<?php
//Added WYSIWYG HTML Area Box + Admin Function v1.7 - 2.2 MS2 Products Description HTML
if (HTML_AREA_WYSIWYG_DISABLE == 'Disable') {} else { ?>
<script language="JavaScript1.2" defer>
var config = new Object(); // create new config object
config.width = "<?php echo HTML_AREA_WYSIWYG_WIDTH; ?>px";
config.height = "<?php echo HTML_AREA_WYSIWYG_HEIGHT; ?>px";
config.bodyStyle = 'background-color: <?php echo HTML_AREA_WYSIWYG_BG_COLOUR; ?>; font-family: "<?php echo HTML_AREA_WYSIWYG_FONT_TYPE; ?>"; color: <?php echo HTML_AREA_WYSIWYG_FONT_COLOUR; ?>; font-size: <?php echo HTML_AREA_WYSIWYG_FONT_SIZE; ?>pt;';
config.debug = <?php echo HTML_AREA_WYSIWYG_DEBUG; ?>;
<?php for ($i = 0, $n = sizeof($languages); $i < $n; $i++) { ?>
editor_generate('products_description[<?php echo $languages[$i]['id']; ?>]',config);
editor_generate('products_spec[<?php echo $languages[$i]['id']; ?>]',config);
editor_generate('products_musthave[<?php echo $languages[$i]['id']; ?>]',config);
editor_generate('products_manual[<?php echo $languages[$i]['id']; ?>]',config);
editor_generate('products_moreinfo[<?php echo $languages[$i]['id']; ?>]',config);
editor_generate('products_extra1[<?php echo $languages[$i]['id']; ?>]',config);
editor_generate('products_extraimage[<?php echo $languages[$i]['id']; ?>]',config);
editor_generate('products_head_title_tag[<?php echo $languages[$i]['id']; ?>]',config);
editor_generate('products_head_desc_tag[<?php echo $languages[$i]['id']; ?>]',config);
editor_generate('products_head_keywords_tag[<?php echo $languages[$i]['id']; ?>]',config);
<?php } } ?>
</script>

Here is an easier way to get the product tabs to work with the wyswyg editor and a whole lot less code than the solutions below.

You just need to replace the second part of the Wysiwyg script which you'll find just after the closing </form> tag with this:

<?php
//Added WYSIWYG HTML Area Box + Admin Function v1.7 - 2.2 MS2 Products Description HTML
if (HTML_AREA_WYSIWYG_DISABLE == 'Disable') {} else { ?>
<script language="JavaScript1.2" defer>
var config = new Object(); // create new config object
config.width = "<?php echo HTML_AREA_WYSIWYG_WIDTH; ?>px";
config.height = "<?php echo HTML_AREA_WYSIWYG_HEIGHT; ?>px";
config.bodyStyle = 'background-color: <?php echo HTML_AREA_WYSIWYG_BG_COLOUR; ?>; font-family: "<?php echo HTML_AREA_WYSIWYG_FONT_TYPE; ?>"; color: <?php echo HTML_AREA_WYSIWYG_FONT_COLOUR; ?>; font-size: <?php echo HTML_AREA_WYSIWYG_FONT_SIZE; ?>pt;';
config.debug = <?php echo HTML_AREA_WYSIWYG_DEBUG; ?>;
<?php for ($i = 0, $n = sizeof($languages); $i < $n; $i++) { ?>
editor_generate('products_description[<?php echo $languages[$i]['id']; ?>]',config);
editor_generate('products_spec[<?php echo $languages[$i]['id']; ?>]',config);
editor_generate('products_musthave[<?php echo $languages[$i]['id']; ?>]',config);
editor_generate('products_manual[<?php echo $languages[$i]['id']; ?>]',config);
editor_generate('products_moreinfo[<?php echo $languages[$i]['id']; ?>]',config);
editor_generate('products_extra1[<?php echo $languages[$i]['id']; ?>]',config);
editor_generate('products_extraimage[<?php echo $languages[$i]['id']; ?>]',config);
<?php } } ?>
</script>

No file uploaded.

This update for users the contribution "WYSIWYG HTMLArea MS2 v1.7"

*********************************To UPDATE***********************************

1)Open admin/categories.php file

--Find:

editor_generate('products_description[<?php echo $languages[$i]['id']; ?>]',config);
<?php } } ?>
</script>


--And Replace With this lines:

editor_generate('products_description[<?php echo $languages[$i]['id']; ?>]',config);
<?php } } ?>
</script>

<?php
//MaxiDVD Added WYSIWYG HTML Area Box + Admin Function v1.7 - 2.2 MS2 Products Description HTML - </form>
if (HTML_AREA_WYSIWYG_DISABLE == 'Disable') {} else { ?>
<script language="JavaScript1.2" defer>
var config = new Object(); // create new config object
config.width = "<?php echo HTML_AREA_WYSIWYG_WIDTH; ?>px";
config.height = "<?php echo HTML_AREA_WYSIWYG_HEIGHT; ?>px";
config.bodyStyle = 'background-color: <?php echo HTML_AREA_WYSIWYG_BG_COLOUR; ?>; font-family: "<?php echo HTML_AREA_WYSIWYG_FONT_TYPE; ?>"; color: <?php echo HTML_AREA_WYSIWYG_FONT_COLOUR; ?>; font-size: <?php echo HTML_AREA_WYSIWYG_FONT_SIZE; ?>pt;';
config.debug = <?php echo HTML_AREA_WYSIWYG_DEBUG; ?>;
<?php for ($i = 0, $n = sizeof($languages); $i < $n; $i++) { ?>
editor_generate('products_spec[<?php echo $languages[$i]['id']; ?>]',config);
<?php } } ?>
</script>

<?php
//MaxiDVD Added WYSIWYG HTML Area Box + Admin Function v1.7 - 2.2 MS2 Products Description HTML - </form>
if (HTML_AREA_WYSIWYG_DISABLE == 'Disable') {} else { ?>
<script language="JavaScript1.2" defer>
var config = new Object(); // create new config object
config.width = "<?php echo HTML_AREA_WYSIWYG_WIDTH; ?>px";
config.height = "<?php echo HTML_AREA_WYSIWYG_HEIGHT; ?>px";
config.bodyStyle = 'background-color: <?php echo HTML_AREA_WYSIWYG_BG_COLOUR; ?>; font-family: "<?php echo HTML_AREA_WYSIWYG_FONT_TYPE; ?>"; color: <?php echo HTML_AREA_WYSIWYG_FONT_COLOUR; ?>; font-size: <?php echo HTML_AREA_WYSIWYG_FONT_SIZE; ?>pt;';
config.debug = <?php echo HTML_AREA_WYSIWYG_DEBUG; ?>;
<?php for ($i = 0, $n = sizeof($languages); $i < $n; $i++) { ?>
editor_generate('products_musthave[<?php echo $languages[$i]['id']; ?>]',config);
<?php } } ?>
</script>

<?php
//MaxiDVD Added WYSIWYG HTML Area Box + Admin Function v1.7 - 2.2 MS2 Products Description HTML - </form>
if (HTML_AREA_WYSIWYG_DISABLE == 'Disable') {} else { ?>
<script language="JavaScript1.2" defer>
var config = new Object(); // create new config object
config.width = "<?php echo HTML_AREA_WYSIWYG_WIDTH; ?>px";
config.height = "<?php echo HTML_AREA_WYSIWYG_HEIGHT; ?>px";
config.bodyStyle = 'background-color: <?php echo HTML_AREA_WYSIWYG_BG_COLOUR; ?>; font-family: "<?php echo HTML_AREA_WYSIWYG_FONT_TYPE; ?>"; color: <?php echo HTML_AREA_WYSIWYG_FONT_COLOUR; ?>; font-size: <?php echo HTML_AREA_WYSIWYG_FONT_SIZE; ?>pt;';
config.debug = <?php echo HTML_AREA_WYSIWYG_DEBUG; ?>;
<?php for ($i = 0, $n = sizeof($languages); $i < $n; $i++) { ?>
editor_generate('products_extraimage[<?php echo $languages[$i]['id']; ?>]',config);
<?php } } ?>
</script>

<?php
//MaxiDVD Added WYSIWYG HTML Area Box + Admin Function v1.7 - 2.2 MS2 Products Description HTML - </form>
if (HTML_AREA_WYSIWYG_DISABLE == 'Disable') {} else { ?>
<script language="JavaScript1.2" defer>
var config = new Object(); // create new config object
config.width = "<?php echo HTML_AREA_WYSIWYG_WIDTH; ?>px";
config.height = "<?php echo HTML_AREA_WYSIWYG_HEIGHT; ?>px";
config.bodyStyle = 'background-color: <?php echo HTML_AREA_WYSIWYG_BG_COLOUR; ?>; font-family: "<?php echo HTML_AREA_WYSIWYG_FONT_TYPE; ?>"; color: <?php echo HTML_AREA_WYSIWYG_FONT_COLOUR; ?>; font-size: <?php echo HTML_AREA_WYSIWYG_FONT_SIZE; ?>pt;';
config.debug = <?php echo HTML_AREA_WYSIWYG_DEBUG; ?>;
<?php for ($i = 0, $n = sizeof($languages); $i < $n; $i++) { ?>
editor_generate('products_manual[<?php echo $languages[$i]['id']; ?>]',config);
<?php } } ?>
</script>

<?php
//MaxiDVD Added WYSIWYG HTML Area Box + Admin Function v1.7 - 2.2 MS2 Products Description HTML - </form>
if (HTML_AREA_WYSIWYG_DISABLE == 'Disable') {} else { ?>
<script language="JavaScript1.2" defer>
var config = new Object(); // create new config object
config.width = "<?php echo HTML_AREA_WYSIWYG_WIDTH; ?>px";
config.height = "<?php echo HTML_AREA_WYSIWYG_HEIGHT; ?>px";
config.bodyStyle = 'background-color: <?php echo HTML_AREA_WYSIWYG_BG_COLOUR; ?>; font-family: "<?php echo HTML_AREA_WYSIWYG_FONT_TYPE; ?>"; color: <?php echo HTML_AREA_WYSIWYG_FONT_COLOUR; ?>; font-size: <?php echo HTML_AREA_WYSIWYG_FONT_SIZE; ?>pt;';
config.debug = <?php echo HTML_AREA_WYSIWYG_DEBUG; ?>;
<?php for ($i = 0, $n = sizeof($languages); $i < $n; $i++) { ?>
editor_generate('products_extra1[<?php echo $languages[$i]['id']; ?>]',config);
<?php } } ?>
</script>

<?php
//MaxiDVD Added WYSIWYG HTML Area Box + Admin Function v1.7 - 2.2 MS2 Products Description HTML - </form>
if (HTML_AREA_WYSIWYG_DISABLE == 'Disable') {} else { ?>
<script language="JavaScript1.2" defer>
var config = new Object(); // create new config object
config.width = "<?php echo HTML_AREA_WYSIWYG_WIDTH; ?>px";
config.height = "<?php echo HTML_AREA_WYSIWYG_HEIGHT; ?>px";
config.bodyStyle = 'background-color: <?php echo HTML_AREA_WYSIWYG_BG_COLOUR; ?>; font-family: "<?php echo HTML_AREA_WYSIWYG_FONT_TYPE; ?>"; color: <?php echo HTML_AREA_WYSIWYG_FONT_COLOUR; ?>; font-size: <?php echo HTML_AREA_WYSIWYG_FONT_SIZE; ?>pt;';
config.debug = <?php echo HTML_AREA_WYSIWYG_DEBUG; ?>;
<?php for ($i = 0, $n = sizeof($languages); $i < $n; $i++) { ?>
editor_generate('products_moreinfo[<?php echo $languages[$i]['id']; ?>]',config);
<?php } } ?>
</script>


2)And Go to your admin panel and edit your admin -> configuration -> WYSIWYG Editor 1.7 -> Product Description Layout Width -> 700 px

That's All. Enjoy...

no file...

I noticed that in the admin I could see correctly the 'aqua' tabs, but none viewed in the store... so i decide to correct the scr.css (to be putted in the catalog) present in the catalog folder.

PS remember to put inside in /images/icons/ the images you put before in /admin/images/icons/... You will find everything in the archive!

Now it looks better (for me)... See it in 'www.dragoo.net'!

I had a problem getting the javascript to work on 2.1. I then uploaded scr.js from version 2.0 and that solved the problem.

I use Header tags Controller and Tabs
so I inserted all fields into tabs

<b>Only two Files</b> in this package : categories.php and product_tabs.php

p.s. I haven't tested it for long time,
so please back up all your files first.

Page Scrolling corrected in Internet Explorer
Just replace catalog/include/modules/product_tabs.php

Full contribution

See live example
www.tronica.fi

I have merge Ask a Question contribution to Tabs. Also some little corrections to Admin side and some JavaScript help for those who have many java in product_info.php page.
Also there is possibility use FCKeditor in admin tabs (you have to download and install FCKeditor separately).
Just change admin/categories.php code
require(DIR_WS_MODULES ."product_tabs.php");
// require(DIR_WS_MODULES ."fck_product_tabs.php");

to this:

// require(DIR_WS_MODULES ."product_tabs.php");
require(DIR_WS_MODULES ."fck_product_tabs.php");

I have made some changes to previous versions.

- Now you can use tabs in admin side (like vs.1.7), but you don't have to have FCKeditor installed. If you want to use FCKeditor in admin side, you can download product tabs 1.7.2 with admin tabs
- Now you can use UltraPics - MS2 Image Addon Pack to upload images to Product tabs.

There is few screenshots includet

You can find working version from my shop:
www.tronica.fi

ajout et correction de la feuille de style pour l'administration.
ajout d'images d'onglet pour une meilleur présentation

Some little correction to the admin stylesheet.

voici ma premier contribution
j'ai ajouté en plus la fonction tab a l'administration des produits
cette version utilise FCKeditor pour les inputs
elle est compatible multi-langues

voici un exemple:
http://www.arnotv.fr/capture_admin.jpg

this version adds tabs to tha admin categorie products
that contribution use FCKEditor but you change it
with the good input fields
it's run with multi-languages two

Instalation.txt is missing one function from general.php

function tep_get_products_spec($product_id, $language_id) {
$product_query = tep_db_query("select products_spec from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$product_id . "' and language_id = '" . (int)$language_id . "'");
$product = tep_db_fetch_array($product_query);

This is not full contribution

Just one more little update. The 'tabs' were not really tabs, just instead buttons hovering between two <hr> lines.

I have now changed this so they look like tabs. I have my own colour properties in the css file, so feel free to change this to better suit your site.

This contribution includes only those files affects. Install first contribution 1.5, then apply the updates in both 1.6 and this one, 1.7.

Slight update to Product Tabs 1.5 to correct the problem in the Admin section. The text entry boxes were falling out of snyc with the 'proper' oscommerce format, making things appear a little confusing and messed up.

Otherwise no problems. Great contribution.

This update includes only the admin/categories.php file. NOT A FULL VERSION.

Changed

Added to product info page five extra fields for product data.
Field by field if there is data then it show.
You can find live example http://www.redpower.fi/

This is my first modding so REMEMBER BACKUP

Product tabs 1.4

Split the data previously added to product_info into two files and put them into the includes folder. Changed the data added to product_info.php to be selective if the products_spec field has data in it or not. Some products warrant additional data and some don't. If there is no data then the original (default osc) method of display is used, if there is data then the tab method is used.

Changed CSS with some less in your face colors and commented where to change the various components
Added some screnshots showing with and without

Now has overwrite and run files for unmodded store.

Sorry only in English
This works on CRE too but not using overwrite option.

Enjoy

Happy New Year

Steve

French version, and integration of the miniature produces within the frameworks

Only change is to make it work with Firefox! Changed scr.js file.

Ok here is the update for product tabs

Basicly all i added was removing styles from product_info.php file and put them in a separate file which is scr.css

This Contribution will add a new field to your products with multi language support and plus add a new field which is products_spec so instead of having only description and out everything there you can have description + specification or what ever you name it and its not only that. when customers see your products instead of having a long page with full of texts they will see some tabs with details in them which is much more better than the old way
and also i added a back button in product_info so customer doesnt need to use back button instead there will be a back button next to add_to_cart

Here is the demo

www.gadgetboom.net/store/product_info.php/products_id/59

i hope it will help

any problem email me : hamed@gadgetboom.net