<?php

/*引用文件*/

require('e/class/connect.php');

require('e/class/db_sql.php');

require('e/data/dbcache/class.php');</p> <p>/*建立数据库链接 与 实例化类*/

$link = db_connect();

$empire=new mysqlquery(); </p> <p>//header("Content-type:application/xml");

header("Content-type: text/html; charset=utf-8");</p> <p>$operation = $_GET['operation'];

$current_url = explode('/',$_SERVER['PHP_SELF']);

$current_script_name = end($current_url); </p> <p>if($operation && $operation == "makexml")

{

$xml = generate_sitemp_xml();

$result = save_xml('sitemap.xml',$xml);

if($result)

{

echo '生成成功，<a href="sitemap.xml">点此查看</a>';

}

else

{

echo '生成失败，<a href="'.$current_script_name.'">在来一次</a>！';

}

}

else

{

echo '欢迎使用微笑的鱼Sitemap生成工具，请<a href="'.$current_script_name.'?operation=makexml">点此生成</a>！';

}</p> <p></p> <p>

//保存到文件

function save_xml($filename, $text) {

if (!$filename || !$text)

return false;

@chmod($filename,0777);

if ($fp = fopen($filename, "w")) {

if (@fwrite($fp, $text)) {

fclose($fp);

return true;

} else {

fclose($fp);

return false;

}

}

return false;

}

//生成Sitemap XML数据

function generate_sitemp_xml()

{

global $dbtbpre,$empire;

$xml = '';

$xml .= '<?xml version="1.0" encoding="utf-8"?>' .PHP_EOL;

$xml .= '<urlset>' .PHP_EOL;

$xml .= generate_home_xml();//首页

$xml .= generate_class_xml();//栏目

$query="select * from {$dbtbpre}ecms_news order by id desc limit 100";

$sql=$empire->query($query);

while($r=$empire->fetch($sql))

{

$titleurl=sys_ReturnBqTitleLink($r);

$xml .= ' <url>' .PHP_EOL;

$xml .= ' <loc>'.$titleurl.'</loc>' .PHP_EOL;

$xml .= ' <lastmod>'.strftime('%Y-%m-%d',$r['newstime']).'</lastmod>' .PHP_EOL;

$xml .= ' <changefreq>daily</changefreq>' .PHP_EOL;

$xml .= ' <priority>0.8</priority>' .PHP_EOL;

$xml .= ' </url>' .PHP_EOL;

}

$xml .= '</urlset>' .PHP_EOL;

return $xml;

}

//生成栏目链接XML数据

function generate_class_xml()

{

global $dbtbpre,$empire,$class_r;

$xml = '';

$sql=$empire->query("SELECT * FROM {$dbtbpre}enewsclass WHERE islast=1");

while($r=$empire->fetch($sql))

{

$infor=$empire->fetch1("SELECT newstime FROM {$dbtbpre}ecms_".$class_r[$r[classid]][tbname]." WHERE classid='$r[classid]' ORDER BY newstime DESC LIMIT 1");

$class_url=sys_ReturnBqClassname($r, 9);

$xml .= ' <url>' .PHP_EOL;

$xml .= ' <loc>'.$class_url.'</loc>' .PHP_EOL;

$xml .= ' <lastmod>'.strftime('%Y-%m-%d',time()).'</lastmod>' .PHP_EOL;

$xml .= ' <changefreq>daily</changefreq>' .PHP_EOL;

$xml .= ' <priority>0.8</priority>' .PHP_EOL;

$xml .= ' </url>' .PHP_EOL;

}

return $xml;

}

//生成栏目链接XML数据

function generate_home_xml()

{

$xml = '';

$xml .= ' <url>' .PHP_EOL;

$xml .= ' <loc>http://www.jb51.net</loc>' .PHP_EOL;

$xml .= ' <lastmod>'.strftime('%Y-%m-%d',time()).'</lastmod>' .PHP_EOL;

$xml .= ' <changefreq>daily</changefreq>' .PHP_EOL;

$xml .= ' <priority>0.8</priority>' .PHP_EOL;

$xml .= ' </url>' .PHP_EOL;

return $xml;</p> <p>}</p> <p>/*关闭数据库连接 与 释放类*/

db_close();

$empire=null;

?>