791 replies to this topic

[14steve14]

al3ks, on 31 July 2012 - 02:33 PM, said:

@14steve14

Thanks, that's exactly what it was.

Glad you got it working. it took me ages to find that when i had installed it.

[CrazyCarzCustoms]

Hi Jack,

I just installed this on 2.3.3 , it was a easy install , even for me , and it works like perfect!!

I just wanted to thank you for a very nice addon.

THANKS.


Rob

[Jack_mcs]

You're welcome. I'm glad it is helpful.

[grandpaj]

Hi Jack

Thank you for a great and easy to install add on. Especially for those of us who are real bunnies.

Just one thing. I'm not sure whether the links in the Information box ( Contact Us Shipping & Returns etc) are supposed to show on the Site map page. If they are can you please tell me what I need to do to correct this, as mine doesn't, all I get are the categories and sub categories. I have checked the install instructions and all seem to be OK,, have also read through many posts on this forum but don't seem to be able to find the answer.
I'm also not sure whether there is supposed to be a heading in the page as the page starts a wee way down (about 2.5cm) from the top.

Hope the above makes sense.

Many thanks again for the contribution and look forward to your response.

I have installed v1.9 and using oscommerce .2.2MS2

Grandpa

Edited by grandpaj, 05 October 2012 - 01:10 AM.

[Jack_mcs]

You need go to Boxes Individual Control in box control, select the box and update it. You also need to fill in the titles in settings control.

[grandpaj]

Hi Jack

Many thanks for that. How stupid am I.

I hope this question isn't another silly one.

I have one page in the Information section which is secured. When I click on the link in the Info box it goes to the secure page, but when I click on the link in the site map it goes to the page but the page is not secure, Do you have any thoughts on what I could do, to ensure that when the link in the site map is clicked it will take the user to the secure page.

Many thanks

Grandpa

[Jack_mcs]

There's nothing in the code that will allow the url to switch to secure. The best way to deal with it is to place a command in the .htaccess file to force a change to ssl when that page is loaded. That should be done anyway because it is a security hole if it doesn't change.

[grandpaj]

Hi Jack

Many thanks so much for your reply.

I'm a bit of a bunny, but learning.
What exactly do I need to do. I presume that's the .htaccess file in the "folder or maybe its called the Root Directory" which contains scgibin, mail, pub, mail cgibin etc.

But as to what code I should insert, I'm lost. If you're able to guide that would great and much appreciated.

Again many thanks

Grandpa

[Jack_mcs]

It would be the main .htaccess file in the root. As for how to do it, that is not a subject for this thread. You can post in the general forum or search the web for how to force ssl for a page - there are many examples.

[grandpaj]

Hi jack

many thanks

Grandpas

[Irin]

Hi. Great add-on. I'm using the "Enable & Disable Categories" contribution and was wondering what do I need to change to force the sitemap to not display the hidden categories. Also, I want to display only manufacturers that have linked products and hide those that have no products. How can I do that?

Thanks in advance.

[Jack_mcs]

I don't use that contribution so I don't know what code to add to limit the category. It would have to be added to the sitemap module files where categories are called. For the manufacturers, I think changing this line in includes/modules/sitemap_manufacturers.php file

		  $products_query = tep_db_query("select m.manufacturers_id, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " .  TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join  " .			TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p2c.products_id = p.products_id left join  " .  TABLE_CATEGORIES . " c on p2c.categories_id = c.categories_id where p.products_status > 0 and c.categories_id = " . $mapCID);

to

		  $products_query = tep_db_query("select m.manufacturers_id, m.manufacturers_name from " . TABLE_PRODUCTS . " p left join " .  TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join  " .			TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p2c.products_id = p.products_id left join  " .  TABLE_CATEGORIES . " c on p2c.categories_id = c.categories_id where p.products_status > 0 and p.products_quantity > 0 and c.categories_id = " . $mapCID);

[Irin]

Hi Jack,

I managed to disable the hidden categories by adding c.categories_status = '1' to the following query in category_tree.php and category_tree_no_products.php:

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

I changed the line like you suggested in includes/modules/sitemap_manufacturers.php and includes/modules/sitemap.php, but unfortunately it didn't change how the manufacturers are being displayed. Any other ideas?

[Jack_mcs]

No, I only provide limited support for non-standard changes.

[blaine109]

Jack,

I get the following error when I go to sitemap.php

Fatal error: Cannot redeclare in_multi_array() (previously declared in /home/****/public_html/includes/functions/general.php:1377) in /home/*****/public_html/includes/functions/sitemap.php on line 132

Thanks,
Blaine

[Jack_mcs]

In the includes/functions/sitemap.php and includes/modules/sitemap.php files, find

in_multi_array

and change it to something else, like

sitemap_in_multi_array

[blaine109]

Jack_mcs, on 25 October 2012 - 05:44 PM, said:

In the includes/functions/sitemap.php and includes/modules/sitemap.php files, find

in_multi_array

and change it to something else, like

sitemap_in_multi_array

Thank you sir.

[blaine109]

Jack,

I am also looking for a contribution to generate a sitemap that I can submit to google, bing, etc.

Is you Dynamic Sitemap contribution (http://addons.oscommerce.com/info/3306) still an active project of yours and does it work with all the other contributions (headertags, seo urls, etc.)?

Thanks,
Blaine

[Jack_mcs]

No, I don't recommend the Dynamic Sitemap contribution. This one and the "Google XML Sitemap SEO" are better for the onsite and offsite site maps.

[blaine109]

Does anyone else have issues with FireFox not showing the .css styles?  They work properly in IE but firefox there is no formatting.