198 replies to this topic

[kymation]

dvharrison, on 22 April 2010 - 09:53 AM, said:

I have written the code to rectify this in the admin/includes/languages/english/categories.php file:

Hope I weren't the only one to find this!  

Yes, that's a bug, and your fix is perfect. Thanks for reporting it.

Regards
Jim

[offie]

kymation, on 22 April 2010 - 03:56 PM, said:

Both sites work for me in Firefox and IE 8.

Regards
Jim

Thanks Jim for your reply. Unfortnately my computer has been down for 2 days so I could not post a comment on my problem. I have infact solved the problem and I am fraid to say the problem was me. On page 6 of this thread MarcelN asked if there was a way to increase the image size without altering the values of SMALL_IMAGE.

It was mentioned to alter the code from:

$info_box_text .= tep_image (DIR_WS_IMAGES . $category['image'], $category['name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="2" vspace="3"');

to

 $info_box_text .= tep_image (DIR_WS_IMAGES . $category['image'], $category['name'], 'WIDTH="25" HEIGHT="25"', 'hspace="2" vspace="3"');

This is what I did and it worked in Firefox which was the only browser I was using. What I failed to do was read further into the thread to find that caused a problem and you in fact gave an answer on what to do.

I have now done what you suggested on page 6 and everything now works fine.

Just goes to prove that its good to read and then read again to make sure.

Sorry for bothering you all when the answer was already there and all I had to do was read it.

Michael

[dvharrison]

kymation, on 22 April 2010 - 04:05 PM, said:

Yes, that's a bug, and your fix is perfect. Thanks for reporting it.

Regards
Jim

Cool.  First time I've ever fixed a bug for someone!  

[Mort-lemur]

Hi.

Installed this contribution some time ago - and it works great for me.

However, not that my shop is up and running, Im spending some time cleaning up some code issues.

When I installed this contribution, I think I must have somehow run the sql more than once, so my admin page looks like this :

Quote

Show box   True  
Show box True Info
Show box True Info
Show images in box True Info
Show images in box True Info
Show images in box True Info
Show name in box True Info
Show name in box True Info
Show name in box True Info
Show description in box True Info
Show description in box True Info
Show description in box True Info
Box style Grid Info
Box style Grid Info
Box style Grid Info
Box columns 4 Info
Box columns 4 Info
Box columns 4 Info
Box frame style Simple Info
Box frame style Simple Info
Box frame style Simple Info

As you can see, all enteries are there 3 Times. Everything works as it should, but I would really like to clean this up.

Any ideas please?

Thanks

[kymation]

You will need to edit your database manually and remove the extra entries. Entries are in the Configuration table with a configuration_group_id value of 112 (unless you changed it.)

Regards
Jim

[Mort-lemur]

Hi Again,

Made a post in the General forum, but this might be a better place:

I have installed the contribution by Spooks for hiding Categories This One and it works great.

However I have the categories image box contribution installed as well.

The hide categories works on the admin side, and hides the category from the Menu (in my case dynamenu) but it does not hide it in the categories image box.

I cannot find a support thread for this.

At the bottom of the install instructions, Sam says

Quote

There may other instances I have missed, the genereral Rule is: If there is a general tep_db_query including TABLE_CATEGORIES add the filter: and categories_status = 1

but I am completely lost in adding this to the categories image box code.

I think I have found the block of code to modify in catalog/includes/modules/categories_images.php

which reads as this:

 $categories_query = tep_db_query ("select c.categories_id, 
											  c.categories_image_front, 
											  cd.categories_description_front, 
											  cd.categories_name
										from " . TABLE_CATEGORIES_DESCRIPTION . " cd,
											" . TABLE_CATEGORIES . " c 
									   where c.parent_id = '0' 
										 and c.categories_id = cd.categories_id 
										 and cd.language_id = '" . (int) $languages_id . "' 
									   order by c.sort_order
									 ");

I have tried modding this as :

$categories_query = tep_db_query ("select c.categories_id, 
											  c.categories_image_front, 
											  cd.categories_description_front, 
											  cd.categories_name
										c.categories_status
									   from " . TABLE_CATEGORIES_DESCRIPTION . " cd,
											" . TABLE_CATEGORIES . " c 
									   where c.parent_id = '0' 
												and c.categories_status = '1'
										 and c.categories_id = cd.categories_id 
										 and cd.language_id = '" . (int) $languages_id . "' 
									   order by c.sort_order
									 ");

But I get an SQL error on my index page as follows:

Quote

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.categories_status from categories_descri' at line 5

select c.categories_id, c.categories_image_front, cd.categories_description_front, cd.categories_name c.categories_status from categories_description cd, categories c where c.parent_id = '0' and c.categories_status = '1' and c.categories_id = cd.categories_id and cd.language_id = '1' order by c.sort_order

Any help would be really useful.

Thanks

[offie]

Hi, just a quick question. I have not looked at this contribution for a while and have forgotten how to change somethings. Really all I need to know now is how to increase the number of categories being shown on the index page. It is currently showing 9 categories on the index page but I would like to increase this so that it shows 12 categories but I can not remember where I change the code from 9 to 12.

Thanks for any help

Michael

[offie]

offie, on 08 September 2010 - 05:03 PM, said:

Hi, just a quick question. I have not looked at this contribution for a while and have forgotten how to change somethings. Really all I need to know now is how to increase the number of categories being shown on the index page. It is currently showing 9 categories on the index page but I would like to increase this so that it shows 12 categories but I can not remember where I change the code from 9 to 12.

Thanks for any help

Michael

Its fine, I have found the code in catalog/includes/modules/categories_images.php

Thanks

[satkin2]

Hi,

Firstly thanks for a great contribution, this really suited my needs perfectly.

I'm not sure if this is something I'm missing, but to set the size of my category images I'm using Admin -> Images -> Small Image Width/Height, however this is also controlling the size of my image in the product_info page.  I want my pictures on the product_info page to be significantly larger than those I'm showing for the category images, however as they are both linked to the same admin option I can't make them independent of each others size.  How would I go about doing this?

Sorry if this is something that is already covered in this support thread, I've tried to check through it but there are a lot of posts so I may have missed something.

Steve

[satkin2]

satkin2, on 09 November 2010 - 07:38 PM, said:

Hi,

Firstly thanks for a great contribution, this really suited my needs perfectly.

I'm not sure if this is something I'm missing, but to set the size of my category images I'm using Admin -> Images -> Small Image Width/Height, however this is also controlling the size of my image in the product_info page.  I want my pictures on the product_info page to be significantly larger than those I'm showing for the category images, however as they are both linked to the same admin option I can't make them independent of each others size.  How would I go about doing this?

Sorry if this is something that is already covered in this support thread, I've tried to check through it but there are a lot of posts so I may have missed something.

Steve

After going through a number of threads on the subject I've stumbled upon this contribution which solves my problem perfectly.

http://addons.oscommerce.com/info/6211

[kymation]

The problem is that the Categories Images Box is using SMALL_IMAGE_WIDTH and SMALL_IMAGE_HEIGHT when it really shouldn't be. Then again, those values should always be blank anyway. I'll fix this in the next release.

Thanks for reporting the bug.

Regards
Jim

[kvadre]

Hi

I'm a newbie that needs a bit of help. How do I run the categories_images_box.sql file and ad it to my web server?

/Jesper

[kymation]

Read this.

Regards
Jim

[kvadre]

Thank you Jim, it worked like a charm.

Regards Jesper

kymation, on 13 March 2011 - 07:15 PM, said:

Read this.

Regards
Jim

[kvadre]

Hi

First thank you for the contribution, it works great.

Not sure if it is a general question but here goes.

I wanted to have the "categories images box" on a page for itself in a layer under the index page and link to it from index, what I did was create a new page and copy the code from the index page and remove what I didn't want.
The question is, is there a better way to do this?

Kind regards
Jesper

[birdrockdesigns]

Doesn't work for me. OSC 2.3.1, Windows 7 checked in FF, IE8, Safari and Chrome. Blank home page.  

[kymation]

This Addon is for osCommerce 2.2x. It can be used with 2.3.x but there will be modifications needed. There is a 2.3.1 version included in the Modular Front Page addon. I suggest that you use that one.

Regards
Jim

[offie]

Hi, I have just come to load this contribution and I have found that my stylesheet.css is completely different to the one you have said to compare.

I have also noticed that 2 stylesheets.css have been downloaded with the contribution, one is in the top folder with the install instructions etc and the other is in the catalog file, which is the correct one to use? I am guessing its the one in the catalog file.

If my style sheet is completely different to yours would I just add yours to the bottom of mine or is it more complicated than that?

Thanks

Michael

[offie]

offie, on 07 October 2011 - 09:01 AM, said:

Hi, I have just come to load this contribution and I have found that my stylesheet.css is completely different to the one you have said to compare.

I have also noticed that 2 stylesheets.css have been downloaded with the contribution, one is in the top folder with the install instructions etc and the other is in the catalog file, which is the correct one to use? I am guessing its the one in the catalog file.

If my style sheet is completely different to yours would I just add yours to the bottom of mine or is it more complicated than that?

Thanks

Michael

Its ok I have worked it out.

If anybody else wants to know the first stylesheet.css in the top folder is for the install.html instructions required to install this contribution.

The stylesheet you need to compare/amend for your store is in the catalog folder in the usual structure. The only piece of code which will need adding to your stylesheet.css is at the bottom of the contribution stylesheet.css which begins with:

/*  Categories in the Categories Images box  */

hope this helps someone

Michael

Edited by offie, 10 October 2011 - 09:09 AM.