','-',$xmlStr); $xmlStr=str_replace("''",'-',$xmlStr); $xmlStr=str_replace('"','-',$xmlStr); $xmlStr=str_replace("'",'-',$xmlStr); $xmlStr=str_replace("#",'',$xmlStr); $xmlStr=str_replace("---",'-',$xmlStr); $xmlStr=str_replace("--",'-',$xmlStr); $xmlStr=str_replace("&",'&',$xmlStr); //$xmlStr=str_replace("&",'&',$xmlStr); return $xmlStr; } $sql_main=mysqli_query($conn,"SELECT site_pages.id AS pageid,site_page_title AS pt,main_seo_tag FROM site_pages ORDER BY pos"); header("Content-type: text/xml"); echo' '; while($row=mysqli_fetch_array($sql_main)){ $pageid=$row['pageid']; $pt=$row['pt']; $main_seo_tag=$row['main_seo_tag']; if($main_seo_tag !=""){ $main_tag = $main_seo_tag; }else{ $main_tag = $row['pt']; } //$pt=strtolower(str_replace($patterns,"-",$pt)); $main_tag=strtolower(str_replace($patterns,"-",$main_tag)); switch($pageid){ case"1": $link = $host."/"; break; default: $link = $host."/".parseToXML($main_tag); break; } $subl = mysqli_query($conn,"SELECT site_pages.id AS pagename,site_pages.site_page_title AS title,categories.id AS subid,categories.categ_name AS cname,categories.site_page,categories.published,categories.parent,categories.issue,single,events,gallery,videos,seo_tag,child_name FROM site_pages LEFT OUTER JOIN categories ON (site_pages.id=categories.site_page) WHERE site_pages.id='$pageid' AND categories.published='on' ORDER BY position ASC"); echo' '.$link.' always 1 '; while($rows = mysqli_fetch_array($subl)){ $cname=$rows['cname']; $child_name=$rows['child_name']; $sub=$rows['subid']; $parent=$rows['parent']; $pagename=$rows['pagename']; if($cname==''){ $cname=$child_name; }else{ $cname=$cname; } $seo_tag = $rows['seo_tag']; if($seo_tag !=""){ $catname=strtolower(str_replace($patterns,"-",$seo_tag)); }else{ $catname=strtolower(str_replace($patterns,"-",$cname)); } $linkS=$host."/".$catname; echo' '.parseToXML($linkS).' always 1 '; } } //blogs $blog = mysqli_query($conn,"SELECT product_name AS blogname FROM galleries ORDER BY POSTED DESC"); while($row = mysqli_fetch_array($blog)){ $blog_name = strtolower(str_replace($patterns,"-",$row['blogname'])); $linkB = $host."/".$blog_name; echo' '.parseToXML($linkB).' always 1 '; } //products $prod = mysqli_query($conn,"SELECT product_name AS prodname FROM product ORDER BY product_name ASC"); while($row = mysqli_fetch_array($prod)){ $prod_name = strtolower(str_replace($patterns,"-",$row['prodname'])); $linkP = $host."/".$prod_name; echo' '.parseToXML($linkP).' always 1 '; } ?>