'."\n".$http_location."\n2008-01-09T22:44:35-05:00\n\n"; $rowHeader ="\n"; $rowFooter = "\n2008-02-03T23:45:36-05:00\n0.8\n\n"; $catFooter = "\n2008-02-03T23:45:36-05:00\n1.0\n\n"; $fileFooter =""; $rowValue=""; // Categories $query = ' SELECT c.categoryid, c.category, c.parentid FROM ' . $sql_tbl['categories'] . ' c WHERE c.avail="Y" '; $tmp_categories = func_query($query); echo $fileHeader; if($tmp_categories) { foreach($tmp_categories AS $sitemap_category) { if (!empty($active_modules["XC_SEO"])){ $rowValue = $http_location ."/". $seo->_category_callback(array("home.php?cat=".$sitemap_category['categoryid'],false,'','categoryid='.$sitemap_category['categoryid'],'',''), true, $sitemap_category['category']); echo $rowHeader.$rowValue.$catFooter."\r\n"; } } } unset($tmp_categories); // Products $query = ' SELECT p.productid, p.product, pc.categoryid FROM ' . $sql_tbl['products'] . ' p INNER JOIN ' . $sql_tbl['products_categories'] . ' pc ON (p.productid = pc.productid) WHERE p.forsale="Y" limit 100 '; $products = func_query($query); $rowValue = ""; if($products) { foreach($products AS $product) { if (!empty($active_modules["XC_SEO"])){ $rowValue = $http_location ."/". $seo->_product_callback(array("product.php?productid=".$product['productid'],false,'','productid='.$product['productid'],'',''), true, $product['product']); echo $rowHeader.$rowValue.$rowFooter."\r\n"; } } } echo $fileFooter; flush(); unset($products); ?>