aalmair
چهارشنبه 17 اردیبهشت 1393, 21:32 عصر
فایل sitemap.php در ریشه سایت
<?php
$db_link=mysql_connect('localhost','root','') ;
mysql_select_db('blog',$db_link);
mysql_set_charset('utf-8',$db_link);
$run_query=mysql_query("select * from posts where posts.post_status='publish' ;",$db_link);
$count_post=mysql_affected_rows($db_link);
$host= 'http://your-site/';
$sitmap_url=$host."/sitemap.php?p=";
////// 50,000 url max
////// 10 mb (10,485,760 bytes) max byte
$max_url=50000;
// $max_byte=2;
$max_url_post=$max_url/2;
$sitemap_part=ceil(($count_post)/$max_url);
if((isset($_GET['p'])&&is_numeric($_GET['p']))){
header("Content-Type: text/xml; charset=utf-8");
$page=$_GET['p'];
if(is_numeric($page)&&$page>0){
$page=(int)$page;
if(!($page<=$sitemap_part)) {
$page=1;
}
}else{
$page=1;
}
echo '<?xml version="1.0" encoding="UTF-8"?><urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">';
$query="select posts.* from posts where posts.post_status='publish' group by posts.postid order by time desc limit ".(($page-1)*$max_url_post).",$max_url_post ";
$mysql_query=mysql_query($query,$db_link);
while($line=mysql_fetch_array($mysql_query,MYSQL_A SSOC)){
echo '<url><loc>';
echo $host.'/post/'.($line['name'])."\n";
echo '</loc><lastmod>';
echo date('Y-m-d',$line['time']);
echo 'T';
echo date('H:i:sP',$line['time']);
echo '</lastmod><changefreq>monthly</changefreq><priority>never</priority></url>';
}
echo '</urlset>';
}else{
header("Content-Type: text/xml; charset=utf-8");
echo '<?xml version="1.0" encoding="UTF-8"?>
<sitemapindex xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">';
for($i=1;$i<=$sitemap_part;$i++){
echo '<sitemap><loc>'.$sitmap_url."$i".'</loc></sitemap>';
}
echo '</sitemapindex>';
}