X-Cart forums

[user1]

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

AND main = 'Y'

change doesn't matter.

So, try this:

$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]

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:

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

Yours!

[jones]

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]

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

Originally Posted by jones

Hello,

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

Enjoy

[jones]

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

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]

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

Originally Posted by jones

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

[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

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

Originally Posted by lewaff

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

[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

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]

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

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]

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.

Originally Posted by lewaff

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