Admin Control Panel v2.0

✎ Editing: cron.sitemap.php ← Back

<?php
include('../includes/inc.config.php');

if (isset($_GET['secret']) && ($_GET['secret'] == 'CAMINE@2010')){ 
$fp_sm = fopen('../sitemap.xml', 'w');
fwrite($fp_sm, "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n");
fwrite($fp_sm, "<urlset xmlns=\"http://www.sitemaps.org/schemas/sitemap/0.9\">\n");
$sql = $database->execute("SELECT * FROM products where status = '1'");
$sql2 = $database->execute("SELECT * FROM categories");
$sql3 = $database->execute("SELECT * FROM subcategory");
$sql4 = $database->execute("SELECT * FROM blogs");

$num_rows1 = $database->num($sql);
$num_rows2 = $database->num($sql2);
$num_rows3 = $database->num($sql3);
$num_rows4 = $database->num($sql4);

$num_rows = $num_rows1 + $num_rows2 + $num_rows3 + $num_rows4;
while($rows = $database->fetch($sql)){
$id = $rows['id'];
$product_name = $rows['name'];
$cat_name = $data->cat_data($rows['cat_id']);
$scat_name = $data->scat_data($rows['scat_id']);

$cat_link = preg_replace("/[^A-Za-z0-9 ]/", '', $cat_name);
$cat_link = str_replace(' ', '-', strtolower($cat_link));

$scat_link = preg_replace("/[^A-Za-z0-9 ]/", '', $scat_name);
$scat_link = str_replace(' ', '-', strtolower($scat_link));

$seo_link = preg_replace("/[^A-Za-z0-9 ]/", '', $product_name);
$seo_link = str_replace(' ', '-', strtolower($seo_link));

fwrite($fp_sm, "<url>\n");
fwrite($fp_sm, "<loc>".ROOT_URL."detalii-produs/$seo_link/$id</loc>\n");
fwrite($fp_sm, "<changefreq>daily</changefreq>\n");
fwrite($fp_sm, "<priority>0.5</priority>\n");
fwrite($fp_sm, "</url>\n");
}
while($cats = $database->fetch($sql2)){
$cat_id = $cats['id'];
$cat_name = $cats['name'];
$cat_seo_link = preg_replace("/[^A-Za-z0-9 ]/", '', $cat_name);
$cat_seo_link = str_replace(' ', '-', $cat_seo_link);

fwrite($fp_sm, "<url>\n");
fwrite($fp_sm, "<loc>".ROOT_URL."categorii-produse-$cat_id/$cat_seo_link/</loc>\n");
fwrite($fp_sm, "<changefreq>daily</changefreq>\n");
fwrite($fp_sm, "<priority>0.5</priority>\n");
fwrite($fp_sm, "</url>\n");
}
fwrite($fp_sm, "<url>\n");
fwrite($fp_sm, "<loc>".ROOT_URL."produse-romanesti/</loc>\n");
fwrite($fp_sm, "<changefreq>daily</changefreq>\n");
fwrite($fp_sm, "<priority>0.5</priority>\n");
fwrite($fp_sm, "</url>\n");

while($page = $database->fetch($sql4)){
$page_name = $page['title'];
$page_seo_link = preg_replace("/[^A-Za-z0-9 ]/", '', $page_name);
$page_seo_link = str_replace(' ', '-', strtolower($page_seo_link));

fwrite($fp_sm, "<url>\n");
fwrite($fp_sm, "<loc>".ROOT_URL."blog/$page_seo_link-".$page['id'].".html</loc>\n");
fwrite($fp_sm, "<changefreq>daily</changefreq>\n");
fwrite($fp_sm, "<priority>0.5</priority>\n");
fwrite($fp_sm, "</url>\n");
}

fwrite($fp_sm, "</urlset>\n");
fclose($fp_sm); 
if($fp_sm){
echo  '<div style="color:green;">Succesfuly generated <b>'.$num_rows.'</b> links in sitemap.xml</div>';

$sitemapUrl = "".ROOT_URL."sitemap.xml";
$GpingUrl="http://www.google.com/webmasters/sitemaps/ping?sitemap=".urlencode($sitemapUrl);
echo "Google ping url: " . $GpingUrl . "<br />";
$Gresponse = file_get_contents($GpingUrl);
echo "Response: " . $Gresponse.'<br />';
echo '<br />';

$pingUrl="http://www.bing.com/webmaster/ping.aspx?siteMap=".urlencode($sitemapUrl);
echo "Bing ping url: " . $pingUrl . "<br />";
$response = file_get_contents($pingUrl);
echo "Response: " . $response.'<br />';

}else{
echo '<div style="color:red;">Error! There is a problem with sitemap.xml, please check if this file exist and if the file have write permissions.</div>';
}
}else{
echo "<font color='red'>Wrong security key!</font>";
}

Cancel