Guest Posted May 20, 2010 Posted May 20, 2010 Hi everyone, I want to change the sitemap. So far I am using the code: <?php header('Content-type: application/xml'); require("includes/configure.php"); require(DIR_WS_INCLUDES . 'database_tables.php'); require(DIR_WS_FUNCTIONS . 'database.php'); function sitemap($parent_id=0,$parent_string=''){ $result = tep_db_query("SELECT categories_id FROM ". TABLE_CATEGORIES." WHERE parent_id='".$parent_id."' ORDER BY `categories_id`"); while ($row=tep_db_fetch_array($result)) { // print_r($row); echo '<url><loc>http://'.$_SERVER['HTTP_HOST'].'/osc/index.php/-c-'.$row['categories_id'].'</loc><priority>0.5</priority><lastmod>'.date("Y-m-d").'T00:00:00+00:00</lastmod><changefreq>monthly</changefreq></url>'."\n"; $rsl = tep_db_query("SELECT products_id FROM ".TABLE_PRODUCTS_TO_CATEGORIES." WHERE categories_id='".$row['categories_id']."'"); while ($rw=tep_db_fetch_array($rsl)) { echo '<url><loc>http://'.$_SERVER['HTTP_HOST'].'/osc/product_info.php/'.$parent_string.$row['categories_id'].'-p-'.$rw['products_id'].'</loc><priority>0.5</priority><lastmod>'.date("Y-m-d").'T00:00:00+00:00</lastmod><changefreq>monthly</changefreq></url>'."\n"; } sitemap($row['categories_id'],$parent_string.$row['categories_id'].'_'); } } tep_db_connect() or die('Unable to connect to database server!'); echo '<?xml version="1.0" encoding="UTF-8"?> <urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9"'>http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/09/sitemap.xsd"> <url><loc>http://'.$_SERVER['HTTP_HOST'].'/</loc><priority>0.5</priority><lastmod>2007-02-01T04:27:55+00:00</lastmod><changefreq>monthly</changefreq></url>'; sitemap(); echo '</urlset>'; ?> which basically produces two sorts of links: http://our web/osc/index.php/-c-24 http://our web/osc/product_info.php/20_24-p-70 Unfortunately our links are formulated in other way: http://our web/osc/index.php/categories name-c-24 http://our web/osc/product_info.php/products_name-p-70 How to change the code to include those? I will appreciate any suggestions! A.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.