Community Add-Ons

This is a small fix for deleting attribute sets.

I Just updated layout and the buttons.

- Full package included.

to make version 1.3.3 works with Oscommerce version 2.3.1
in the original instructions - step 3
in file /catalog/includes/boxs/catalog.php
instead of the originals instructions do this:

###after this line### -

array(
'code' => FILENAME_PRODUCTS_ATTRIBUTES,
'title' => BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES,
'link' => tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES)
),

###Add this lines### -

array(
'code' => FILENAME_PRODUCTS_ATTRIBUTES_SETS,
'title' => BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES_SETS,
'link' => tep_href_link(FILENAME_PRODUCTS_ATTRIBUTES_SETS)
),

#I hope that will helps :)

PROBLEM: THE ADMINISTRATOR LOGIN SCREEN IS BLOCKED

All works fine in localhost but when I transfer the files to my server by FTP, the Administrator Login Screen is blocked.

FIX:

In the files:

/catalog/admin/includes/database_tables.php
/catalog/includes/database_tables.php

Insert a space before 'products_attributes_sets_elements'.

BEFORE:

define('TABLE_PRODUCTS_ATTRIBUTES_SETS_ELEMENTS','products_attributes_sets_elements');

AFTER:

define('TABLE_PRODUCTS_ATTRIBUTES_SETS_ELEMENTS', 'products_attributes_sets_elements');

------------------------------------------------------------------------------------

SunDust

To use this great contribution in a Multilanguage store, make the next steps:

First:

Make the same changes in the files of your language (in my case, spanish):

"/catalog/admin/includes/languages/english.php" --> make the same changes in --> "/catalog/admin/includes/languages/espanol.php"
"/catalog/admin/includes/languages/english/categories.php" --> make the same changes in --> "/catalog/admin/includes/languages/espanol/categories.php"
"/catalog/admin/includes/languages/english/products_attributes.php" --> make the same changes in --> "/catalog/admin/includes/languages/espanol/products_attributes.php"


Second:

COPY also the next files in your language folder (in my case, "spanol" folder):

/catalog/admin/includes/languages/english/products_attributes_sets.php
/catalog/admin/includes/languages/english/products_attributes_sets_edit.php
/catalog/admin/includes/languages/english/images/buttons/button_add_as.gif
/catalog/admin/includes/languages/english/images/buttons/button_create.gif


---------------------------------------------------------------------------------


Well, now we have a problem. If you use Multilanguage you will see the Attributes and the Values of the different languages at the same time when you make new attribute sets. The contribution works but is something uncomfortable. To fix this, make the next changes in the file "/catalog/admin/products_attributes_sets.php":

1a.- Change this:

$options_name_query_sql = "select po.products_options_name, po.products_options_id from " . TABLE_PRODUCTS_OPTIONS . " po where po.products_options_id=".$_POST['products_options_id'];

1b.- To this:

$options_name_query_sql = "select po.products_options_name, po.products_options_id from " . TABLE_PRODUCTS_OPTIONS . " po where po.language_id = '" . (int)$languages_id . "' and po.products_options_id=".$_POST['products_options_id'];

-----------------------------------------------

2a.- Change this:

$attributeSets_query = tep_db_query("select products_options_id, products_options_name from " . TABLE_PRODUCTS_OPTIONS . " order by products_options_name");

2b.- To this:

$attributeSets_query = tep_db_query("select products_options_id, products_options_name from " . TABLE_PRODUCTS_OPTIONS . " where language_id = '" . (int)$languages_id . "' order by products_options_name");

-----------------------------------------------

3a.- Change this:

$attribute_set_sql = "SELECT pas.products_attributes_sets_id, pas.products_attributes_sets_name, pas.products_options_id, po.products_options_name, pase.products_attributes_sets_elements_id, pase.options_values_id, pase.options_values_price, pase.price_prefix, pase.sort_order FROM " . TABLE_PRODUCTS_ATTRIBUTES_SETS . " pas, " . TABLE_PRODUCTS_ATTRIBUTES_SETS_ELEMENTS . " pase, ". TABLE_PRODUCTS_OPTIONS . " po WHERE pas.products_attributes_sets_id = " . $_GET['attset_id'] . " AND pas.products_attributes_sets_id = pase.products_attributes_sets_id AND pas.products_options_id = po.products_options_id ORDER BY pase.sort_order";

3b.- To this:

$attribute_set_sql = "SELECT pas.products_attributes_sets_id, pas.products_attributes_sets_name, pas.products_options_id, po.products_options_name, pase.products_attributes_sets_elements_id, pase.options_values_id, pase.options_values_price, pase.price_prefix, pase.sort_order FROM " . TABLE_PRODUCTS_ATTRIBUTES_SETS . " pas, " . TABLE_PRODUCTS_ATTRIBUTES_SETS_ELEMENTS . " pase, ". TABLE_PRODUCTS_OPTIONS . " po WHERE pas.products_attributes_sets_id = " . $_GET['attset_id'] . " AND pas.products_attributes_sets_id = pase.products_attributes_sets_id AND pas.products_options_id = po.products_options_id AND po.language_id = '" . (int)$languages_id . "' ORDER BY pase.sort_order";

-----------------------------------------------

4a.- Change this:

$options_query_sql = "select pov.products_options_values_name, pov.products_options_values_id from " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov, " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " pov2po where pov2po.products_options_id = " . (int)$_POST['products_options_id'] . " and pov.products_options_values_id = pov2po.products_options_values_id order by pov.products_options_values_name";

4b.- To this:

$options_query_sql = "select pov.products_options_values_name, pov.products_options_values_id from " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov, " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " pov2po where pov2po.products_options_id = " . (int)$_POST['products_options_id'] . " and pov.products_options_values_id = pov2po.products_options_values_id and pov.language_id = '" . (int)$languages_id . "' order by pov.products_options_values_name";

-----------------------------------------------

5a.- Change this:

$options_query_sql = "SELECT pov.products_options_values_name, pov.products_options_values_id FROM " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov, " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " pov2po where pov2po.products_options_id = '" . $attribute_set['products_options_id'] . "' and pov.products_options_values_id=pov2po.products_options_values_id order by pov.products_options_values_name";

5b.- To this:

$options_query_sql = "SELECT pov.products_options_values_name, pov.products_options_values_id FROM " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov, " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " pov2po where pov2po.products_options_id = '" . $attribute_set['products_options_id'] . "' and pov.products_options_values_id=pov2po.products_options_values_id and pov.language_id = '" . (int)$languages_id . "' order by pov.products_options_values_name";

-----------------------------------------------

SunDust

Added use notes
moved history to a separate file

+ when adding a set:
fixed some text formatting
after adding set go directly back to sets main page and skip 'set successfully created' page, confirm message appears in sets mainpage


Full Package + update guides

+ Cleaned up code in admin/products_attributes_sets_edit.php (No code change)
+ moved some language defines to admin/includes/languages/english/products_attributes_sets_edit.php file
+ fixed formatting of some text when editing sets, added black divider lines
+ bypassed update/saved successful page, instead added alerts and returns to main catalog page
+ confirmed OSC 2.2rc2a compatible

FULL Package + update guides

+ Cleaned up code in admin/products_attributes_sets.php (No code change)
+ Added ability to increase number of lines in a set. Thanks to HundPferd for the code.
+ moved some language defines to admin/includes/languages/english/products_attributes_sets.php file
+ fixed formatting of some text when editing sets, added black divider lines
+ bypassed update/saved successful page, instead added alerts and returns to main attributes sets page
+ confirmed OSC 2.2rc2a compatible


Complete Package+update guide

Added missing language define for the attribute sets button in admin.

Based on Linkmatics Attribute Sets Plus v1.2a uploaded 24 Jan 2008

Had to re-upload. Version Linkmatics Attribute Sets Plus v1.2a does not include the following file:
catalog/includes/database_tables.php.

Do not use that version. This one should include all changed files.

This is the same contribution as
Linkmatics Attribute Sets Plus v1.2
The only changes is that all files have been pre-edited. No hand editing is neccessary. Recommended for a clean install of osC. The files were tested on oscommerce-2.2rc2.

The files were originally edited for a member in the forum and then added to this page to help anyone who does not wish to hand edit original files.

All original files are included..

This is a FULL PACKAGE of Attributes Sets Plus.

This update is due to the discovery of a minor (installation) issue with the structure of a database table when using MySQL v.5.x

This new package ensures that any new installs will work with MySQL version 5.x

There are NO CHANGES to the functionality in this package.

Existing installs can check the issue here:
http://forums.oscommerce.com/index.php?s=&showtopic=173616&view=findpost&p=1087964

This is a modification of the fantastic AttributeSet contribution.
I often need to enlarge Attribute Sets and I got bored with having to change the tables via SQL before being able to add the new attributes.
Therefore I modified the "Edit Attributes" Page to allow me to enter the new size of the Set.
After saving the change, I can just re-enter the attribute set and add the new attributes.
It is not perfect yet but it works for me.
THIS IS NOT A FULL INSTALLATION. You need to download/install the version below from 'toasty' before this modification can be installed.

As requested this version includes the patch to ensure existing and non-sets attributes are displayed in the catalog.

This is a full file set and includes 'minor' install instructions changes following forum feedback.

Enjoy.
Chris.

note: this also means the install instructions uploaded by WEB11 are now out of date.

When I first attepmted to install this package I often got lost in the middle of all the code and instructions in the installation text file and ended up failing the install, so I decided to make it a little more friendly, before I made a second attempt.

There was also a few mistakes like the changes asked to be made to /catalog/admin/includes/languages/english/products_attributes.php that was already included with the admin folder supplied.

I went over the install notes and added color codes to all instructions and codes to make it a little easier to follow. This is a RTF file that should be open with WORDPAD so you can see the color codes.

I also removed all unecessarie notes and upgrade instructions. So if you are upgrading or need instructions on how to use the contrib use the original installation txt. Use this for a FRESH INSTALL ONLY.

All credits goes to the original contribution creator as he is the one who actually wrote the manual, I merely edited it to make it more friendly for beginners like me.

This is not the full package, download it bellow.

- Minor updates to the install file for clarity.
- This is the full package.
- No code changes have been made for this upload.

Attribute Sets Plus for osCommerce 2.2 MS2
=================================

Purpose of this Contribution
--------------------------------
This contribution builds on the original Attributesets contribution. It provides the ability to add a set of predefined 'attributes' (herafter known as an Attribute Set) to a product.
Attributes Sets Plus irons out the creases of the excellent original contribution for a smoother operation.

CHANGES
-----------
(commercial info removed) has provided the following imements:

- This contribution is now register_globals OFF ready
- Ability to add multiple attribute sets to a single product at a time.
- The engine now uses database structures instead of arrays.
- A number of bugs were ironed out
- The processes alterred to allow for legacy products AND legacy attributes to co-exist with new attributes sets
- The deletes now make mor logical sense and work correctly
- No core osC tables are alterred - custom tables are used instead
- Less chance of conflict with other contributions (so I am told)
- The install is clear and well commented to help spot editting errors

See the install file for more information.

Support Thread is here:
http://forums.oscommerce.com/index.php?showtopic=173616

Note: As far as I can see this contribution includes at least everything up to attribute sets 5.5, although it is not the same code and did not follow the same development path.