osCommerce Contribution - Dynamic SiteMap V 1.0

Compare Products

You have no items to compare.

Affiliate Info

Affiliate Program FAQ
Affiliate Log In

Recent Orders

Hot Keywords: Order Notification, Order Search, Coupon, Flash Board, Compare, Floating Message, Tracking, Moneris, RSS, Visitor Filter

Dynamic SiteMap V 1.0

1 of 1494 Next > Last >>

The following osCommerce contribution is a free Opensource code originated from official osCommerce website and provided for your reference only, you may download the original contribution file(s) and install it on your own; or you may request a Paid Installation Service from Agents Of Power; Agents Of Power does the "AS IS" installation on your website, we do not guarantee it will work properly on your website. Extra Paid service is available for repairing the problem from the original contribution or from your website.

Bug fix for version 4.2 after I discovered that MySQL version 4 processes the IN operator with a different precidence than version 5 does. Queries that worked fine on my version 5 test server didn't work right at all on our version 4 production server. Version 4.21 simply adds needed parenthesis to the SQL queries so that the results will be the same in any version of MySQL. Complete contribution attached, only catalog/dynamic_sitemap.php and admin/create_xml_sitemaps have changed.
After installing version 4.1 on our public web site after having tested it on our test site I discovered that the dynamic site map was taking nearly 30 seconds to load, and we are directly connected to our web server using gigabit ethernet! Since our public site currently has over 10,000 different products spread among 319 different categories that are nested up to five levels deep I suspected that counting the products in each category to determine which ones to hide was a part of the problem. Sure enough if I commented out the product counts for the categories the time to display the page was cut at least in half. A quick look at the product counting function revealed that it performs one count query for the category plus one for every subcategory it contains. A category with ten subcategories would therefore perform eleven counting queries just to get the number of products for that one category. I have therefore rewritten the category product count methods in both dynamic_sitemap.php and create_xml_sitemaps.php so that it first builds a list of the needed categories and then performs ONE count query on products found in that list of categories. This keeps the time to display the dynamic site map on our web site down to a much more acceptible level. I also discovered that another five seconds could be saved simply by adding an index to the manufacturers_id in the products table. The complete install is attached but only two files have changed since version 4.1. Complete upgrade and install instructions are included.
Upload in admin/includes/langages/french/ This is not a full version.
Small fix to avoid displaying all files 2 times in the client side dynamic sitemap.
fixed files to play nice with windows.
+ implemented the fix for extra bullets in sitemap + updated information pages unlimited compatibility docs Full Package + update guides
+ added compatibility documents for all products contribution and Information Pages Unlimited contribution + moved other contribution documents to a separate directory both of the docs mentioned above are very useable but not perfect, I encourage you to improve if you have the skills. Full Package + update guide
+ fixed install docs. Half were missing. + deleted an extra piece of code. See update guide for details. Full Package+ update guides
Posted on: 09/15/2008 See contribution details	Request Installation with Paid service