Re: X-Cart Product Images Sitemap Generator
nice mod.. for old xcart versions and people using wcm_cdseo, change the query and first part of the foreach sections to this:
Code:
$images_D = db_query("
SELECT * FROM $sql_tbl[products]
INNER JOIN $sql_tbl[images_D] ON $sql_tbl[products].productid = $sql_tbl[images_D].id
WHERE forsale='Y' ORDER BY productid DESC LIMIT $products_limit
");
while ($row = db_fetch_array($images_D)) {
$results[] = $row;
}
foreach ($results as $result){
//$clean_url = $result['clean_url'] . $product_urls_extension;
$pid=$result['productid'];
$cdseo_url = func_query_first_cell("SELECT cdseoUrl FROM wcm_cdseo WHERE cdseoReplaceID='$pid' AND cdseoType='product'");
if ($cdseo_url!='') {
$cdseo_url.=".html";
$clean_url=$cdseo_url;
} else {
continue;
}
you have to do that for the images_p and images_t sections too.
-Matt
__________________
4.7.7.
php7.1, AWS RDS database
memcache, reboot theme AWS EC2 load balancer, 2 c5.large instances CDSEO Shop By Filters,
AC onepage checkout and checkout tools,
altercart cash rewards, bcse DPM for paypal
|