X-Cart forums - free google sitemap

Page 2 of 5

Last »

Show 40 posts from this thread on one page

X-Cart forums (https://forum.x-cart.com/index.php)

- Third Party Add-Ons for X-Cart 4 (https://forum.x-cart.com/forumdisplay.php?f=45)

- - free google sitemap (https://forum.x-cart.com/showthread.php?t=51775)

user1

08-12-2010 01:09 PM

Re: free google sitemap

My mistake. I used wrong variables for the table names. The

Code:

AND main = 'Y'

change doesn't matter.

So, try this:

Code:

$prods = func_query("SELECT * FROM $sql_tbl[clean_urls], $sql_tbl[products_categories], $sql_tbl[products], $sql_tbl[categories] WHERE xcart_clean_urls.resource_type = 'P' AND xcart_products.productid = xcart_clean_urls.resource_id AND main = 'Y' AND xcart_products.productid = xcart_products_categories.productid AND xcart_products.forsale = 'Y' AND xcart_products_categories.categoryid = xcart_categories.categoryid AND xcart_categories.avail = 'Y'");

This must be correct.

Andreas

HumanNature

08-12-2010 02:35 PM

Re: free google sitemap

Thanks man that worked! :)

Anyway I have find a "bug":

If you don't use ".html" in your pages and products urls you have to remove the "html" from the code so the lines are finally like this:

Code:

<loc>'.$http_location.'/'.$pr["clean_url"].'</loc>

Yours!

jones

08-31-2010 09:43 AM

Re: free google sitemap

Hello,

Im creator of this module.
Here version for xcart 4.3.x with supporting "clean_url" option.

Enjoy ;)

UPDATE: This is old version of module. New version on post #24 - http://forum.x-cart.com/showpost.php?p=296734&postcount=24

lewaff

09-01-2010 10:44 AM

Re: free google sitemap

Thanks
I have tried IronShop_Google_Sitemap this on my www.qualitechnic.co.uk site
but its creating a blank sitemap.xml
am i doing something wrong
lewis

Quote:

Originally Posted by jones

Hello,

Im creator of this module.
Here version for xcart 4.3.x with supporting "clean_url" option.

Enjoy ;)

jones

09-01-2010 11:30 PM

Re: free google sitemap

Hi lewis,

I have opened your site and found that you has http://www.qualitechnic.co.uk/sitemap.xml
But it was generated not by my module.
I have test it again on 4.3.2 version, results here:

http://www.ironshop.fr/ebay/sitemap.xml

Thank you,
Alex

Quote:

Originally Posted by lewaff

Thanks
I have tried IronShop_Google_Sitemap this on my www.qualitechnic.co.uk site
but its creating a blank sitemap.xml
am i doing something wrong
lewis

lewaff

09-02-2010 06:29 AM

Re: free google sitemap

sorry
i put the original sitemap back on my site has it was blank from your program
I think yours would me more suitable for the xcart
but i can install it again
but dont want to leave a blank one on live for long
thank you again lewis

Quote:

Originally Posted by jones

lewaff

09-02-2010 11:32 AM

Re: free google sitemap

I tempery altered the sitemap.php
to create the sitemap at www.qualitechnic.co.uk/sitemap1.xml
and has you see its created a blank one
here's the code i changed

Quote:

}
$filename = '../sitemap1.xml';
if(!$fp = fopen($filename, 'w')) {
print "Cannot open file ($filename)";
exit;

Quote:

Originally Posted by lewaff

jones

09-02-2010 12:33 PM

Re: free google sitemap

Yes, you made corect changes.
Can you comment these lines in sitemap.php ?

PHP Code:


		
			
if ($xm_today == $config["iron_sitemap_time"])
    return;

So it will look like this:

PHP Code:


		
			
//if ($xm_today == $config["iron_sitemap_time"])
//    return;

These lines allow make refresh sitemap only one time per day.

Alex

Quote:

Originally Posted by lewaff

I tempery altered the sitemap.php
to create the sitemap at www.qualitechnic.co.uk/sitemap1.xml
and has you see its created a blank one
here's the code i changed

lewaff

09-02-2010 12:51 PM

Re: free google sitemap

Yes thats done the trick do i have leave these commented out
thank you very much
thats great service:D/

Quote:

Originally Posted by jones

Yes, you made corect changes.
Can you comment these lines in sitemap.php ?

PHP Code:


		
			
if ($xm_today == $config["iron_sitemap_time"])
return;

So it will look like this:

PHP Code:


		
			
//if ($xm_today == $config["iron_sitemap_time"])
// return;

These lines allow make refresh sitemap only one time per day.

Alex

jones

09-02-2010 02:21 PM

Re: free google sitemap

Turn off previous Sitemap Generator, then change sitemap1.xml to sitemap.xml,
then visit your admin home page. And only after that un-comment these lines.

:)

Quote:

Originally Posted by lewaff

Yes thats done the trick do i have leave these commented out
thank you very much
thats great service:D/

All times are GMT -8. The time now is 09:55 AM.

Page 2 of 5

Last »

Show 40 posts from this thread on one page