X-Cart forums

[usiripakdi]

I added Subcategories to my main category and I just leave the icon with "No Image Avaiable" icon. The manual said that the icon will not show in the customer section, but it is there, showing on the page. What did I do wrong?

Here is the link
http://www.thaimediastore.com/shop/home.php?cat=248

[dsparks]

You probably did not do anything incorrectly.

Even in v4.0.13 the "No Image Available" category icon is still displayed even if there is no image assigned.

This is also true in the product area, bestsellers area, etc.

I posted a mod for this earlier.

Just follow the link below and look for the source code posted on "Mon Mar 14, 2005 12:14 am" and disregard the source code before that date. The reply starts with "I finally got the code straight".


http://forum.x-cart.com/viewtopic.php?t=17584&highlight=


Hope this helps...

[usiripakdi]

Yur refer to the table "xcart_categories". What is it?
Where is the table? In config file?




1) Add a new field show_image to the table xcart_categories:

Code:
ALTER TABLE `xcart_categories` ADD `show_image` CHAR( 1 ) DEFAULT 'Y' NOT NULL ;



Note: If you want the default option to always start with "No" instead of "Yes" to display category images, then just execute the code below instead:

Code:
ALTER TABLE `xcart_categories` ADD `show_image` CHAR( 1 ) DEFAULT 'N' NOT NULL ;



2) Add a new label lbl_show_image in the Language area:

Go to the Language option and select the language you want to edit. Make sure the Select topic is on the Labels option. Now, go down towards the bottom of the page and add a new label entry.

Code:
Where "Variable" = "lbl_show_image", "Description" = "Show image" and "Value" = "Show image"

[dsparks]

You asked:

Yur refer to the table "xcart_categories". What is it?
Where is the table? In config file?

The file "xcart_categories" is in your MySQL database where all of the other xcart databases are stored on your web site.

Usually you access them via PHPMyadmin or some other tool that you use to maintain your databases.

Hope this helps...

[usiripakdi]

There is no xcart_categories file in sql dir. I found xcart_tables.sql in that dir, and found this code.

CREATE TABLE xcart_categories (
categoryid int(11) NOT NULL auto_increment,
parentid int(11) NOT NULL default '0',
categoryid_path varchar(255) NOT NULL default '',
image_x int(11) NOT NULL default '0',
image_y int(11) NOT NULL default '0',
category varchar(255) NOT NULL default '',
description text NOT NULL,
meta_descr varchar(255) NOT NULL default '',
avail char(1) NOT NULL default 'Y',
views_stats int(11) NOT NULL default '0',
order_by int(11) NOT NULL default '0',
membership varchar(32) NOT NULL default '',
threshold_bestsellers int(11) NOT NULL default '1',
product_count int(11) NOT NULL default '0',
meta_keywords varchar(255) NOT NULL default '',
PRIMARY KEY (categoryid),
KEY category_path (parentid,categoryid_path),
KEY category_path2 (categoryid,categoryid_path),
KEY avail (avail),
KEY membership (membership),
KEY order_by (order_by,category),
KEY am (avail,membership),
KEY pam (categoryid_path,avail,membership),
KEY ia (categoryid,avail),
KEY iam (categoryid,avail,membership)
) TYPE=MyISAM;

Should I add the field

ALTER TABLE `xcart_categories` ADD `show_image` CHAR( 1 ) DEFAULT 'Y' NOT NULL ;

inside the xcart_categories() ??

Thanks.