有偿找人优化个PHP代码

逝水年华 · 发表于 2023-9-25 18:31:16

马上注册，免费下载更多dz插件网资源。

您需要登录才可以下载或查看，没有账号？立即注册

×

<?php
/**
* 生成Sitemap操作
*
* @version       $Id: google_sitemap.php 1 10:00 2011年9月19日Z SSKCN $
* @package       SSKCN.Administrator
* @copyright    Copyright (c) 2011 - 2013, SSKCN, Inc.
* @license       http://www.sskcn.com/license.html
* @link          http://www.sskcn.com/
*/
require_once(dirname(__FILE__)."/config.php");
CheckPurview('plus_Sitemap');
require_once(DEDEINC."/typelink.class.php");

$tl = new TypeLink(0);

function DateDiff($interval, $date1, $date2) {
$time_difference = $date2 - $date1;
switch ($interval) {
      case "y": $retval = bcdiv($time_difference, 31536000); break;
      case "m": $retval = bcdiv($time_difference, 2592000); break;
      case "w": $retval = bcdiv($time_difference, 604800); break;
      case "d": $retval = bcdiv($time_difference, 86400); break;
      case "h": $retval = bcdiv($time_difference, 3600); break;
      case "n": $retval = bcdiv($time_difference, 60); break;
      case "s": $retval = $time_difference; break;
}
return $retval;
}
function getSonClass($ID) {
$dsql = new DedeSql(false);
$dsql->SetQuery("Select id,typename,typedir,isdefault,ispart,defaultname,namerule2,moresite,siteurl,sitepath from `#@__arctype` where reid='".$ID."' and ishidden<>1 order by id,sortrank");
$dsql->execute($ID);
while($row_class = $dsql->getarray($ID)){
ShowMsg($ID);
      $SonClass .= "<url>\n";
      $iClassUrl = $tl->GetOneTypeUrl($row_class);
      $iClassUrl = count(explode("http://",$iClassUrl))>1 ? $iClassUrl: $cfg_basehost.$iClassUrl;
      $SonClass .= "<loc>".$iClassUrl."</loc>\n";
      $SonClass .= "<lastmod>".date("Y-m-d",time())."T".date("H:i:s+08:00",time())."</lastmod>\n";
      $SonClass .= "<changefreq>daily</changefreq>\n";
      $SonClass .= "<priority>0.9</priority>\n";
      $SonClass .= "</url>\n";
      getSonClass($row_class["id"]);
}
return $SonClass;
}
function MK_Dir($path,$pathname){
if(!file_exists($path)){
      createDir(dirname($path));
      mkdir($path, 0775);
      ShowMsg("成功创建目录".$pathname,"javascript:;");
}
}
if(empty($dopost)){
include DEDEADMIN.'/templets/google_sitemap.htm';
}else if($dopost=="make"){
//取得数目
$dsql->SetQuery("Select count(*) as mycount from `#@__archives` where ismake=1");
$dsql->execute();
$row_sum = $dsql->getarray();
if(($sumurl > $row_sum['mycount']) || empty($sumurl)){
      $sumurl = $row_sum['mycount'];
}
$pagenum = intval($sumurl/$perpageurl);
      $pagenumber = $pagenum;
if($pagenum < ($sumurl/$perpageurl)){
      $pagenumber = $pagenum + 1;
}
//创建目录
MK_Dir(dirname(__FILE__)."/../".$filename,$filename);
//索引页sitemap_index.xml
$sitemap_index = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";
$sitemap_index .= "<sitemapindex xmlns=\"http://www.sitemaps.org/schemas/sitemap/0.9\">\n";
for($i=0; $i <= $pagenumber; $i++){
      $sitemap_index .= "<sitemap>\n";
      $sitemap_index .= "<loc>".$cfg_basehost."/sitemap/sitemap_$i.xml</loc>\n";
      $sitemap_index .= "<lastmod>".date("Y-m-d",time())."T".date("H:i:s+08:00",time())."</lastmod>\n";
      $sitemap_index .= "</sitemap>\n";
}
$sitemap_index .= "</sitemapindex>";
$indexmap = fopen(dirname(__FILE__)."/../".$filename."/sitemap_index.xml", "w");
fwrite($indexmap, $sitemap_index);
fclose($indexmap);
ShowMsg("成功生成地图索引：<a href='".$cfg_basehost."/".$filename."/sitemap_index.xml' target='_blank'>/".$filename."/sitemap_index.xml</a>","javascript:;");
//首页、栏目列表sitemap_0.xml
$sitemap_1 = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";
$sitemap_1 .= "<urlset xmlns=\"http://www.sitemaps.org/schemas/sitemap/0.9\">\n";
$sitemap_1 .= "<url>\n";
$sitemap_1 .= "<loc>".$cfg_basehost."/</loc>\n";
$sitemap_1 .= "<lastmod>".date("Y-m-d",time())."T".date("H:i:s+08:00",time())."</lastmod>\n";
$sitemap_1 .= "<changefreq>always</changefreq>\n";
$sitemap_1 .= "<priority>1.0</priority>\n";
$sitemap_1 .= "</url>\n";
$dsql->SetQuery("Select id,typename,typedir,isdefault,ispart,defaultname,namerule2,moresite,siteurl,sitepath from `#@__arctype` where ishidden<>1 order by id,sortrank");
$dsql->execute();
while($row_type = $dsql->getarray()){
      $sitemap_1 .= "<url>\n";
      $iTypeUrl = $tl->GetOneTypeUrl($row_type);
      $iTypeUrl = count(explode("http://",$iTypeUrl))>1 ? $iTypeUrl : $cfg_basehost.$iTypeUrl;
      $sitemap_1 .= "<loc>".$iTypeUrl."</loc>\n";
      $sitemap_1 .= "<lastmod>".date("Y-m-d",time())."T".date("H:i:s+08:00",time())."</lastmod>\n";
      $sitemap_1 .= "<changefreq>daily</changefreq>\n";
      $sitemap_1 .= "<priority>0.9</priority>\n";
      $sitemap_1 .= "</url>\n";
      //$sitemap_1 .= getSonClass($row_type["id"]);
}
$sitemap_1 .= "</urlset>";
$classmap = fopen(dirname(__FILE__)."/../".$filename."/sitemap_0.xml", "w");
fwrite($classmap, $sitemap_1);
fclose($classmap);
ShowMsg("成功生成首页、栏目列表地图：<a href='".$cfg_basehost."/".$filename."/sitemap_0.xml' target='_blank'>/".$filename."/sitemap_0.xml</a>","javascript:;");
//所有文章sitemap_(1-*).xml
$limit_st = 0;
for($page_num=1; $page_num<=$pagenumber; $page_num++){
      $sitemap = "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";
      $sitemap .= "<urlset xmlns=\"http://www.sitemaps.org/schemas/sitemap/0.9\">\n";
      $query = "Select arc.*,tp.typedir,tp.typename,tp.isdefault,tp.defaultname,tp.namerule,tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath
      from `#@__archives` arc LEFT JOIN `#@__arctype` tp ON arc.typeid=tp.id
      where arc.ismake=1 order by pubdate limit $limit_st,$perpageurl";
      $dsql->SetQuery($query);
      $dsql->execute();
      while($row_url = $dsql->getarray()){
         //自动识别动态页和静态页
         $row_url["arcurl"] = GetFileUrl($row_url["id"],$row_url["typeid"],$row_url["senddate"],$row_url["title"],$row_url["ismake"],$row_url["arcrank"],$row_url["namerule"],$row_url["typedir"],$row_url["money"],$row_url['filename'],$row_url["moresite"],$row_url["siteurl"],$row_url["sitepath"]);
         $row_url["fullurl"] = $cfg_basehost.$row_url["arcurl"];
         if($GLOBALS['cfg_multi_site'] == 'Y') $row_url["fullurl"] = $row_url["arcurl"];
         $link = $row_url["fullurl"];
         $times = $row_url['senddate'] ;
         $lastmodified=date("Y-m-d",$times)."T".date("H:i:s+08:00",$times);
         //生成更新频率和更新指数

            $priority="0.8";

         //生成sitemap
         $sitemap .= "<url>\n";
         $sitemap .= "<loc>$link</loc>\n";
         $sitemap .= "<lastmod>$lastmodified</lastmod>\n";
         $sitemap .= "<changefreq>$changefreq</changefreq>\n";
         $sitemap .= "<priority>$priority</priority>\n";
         $sitemap .= "</url>\n";
      }
      $sitemap .= "</urlset>";
      $urlmap = fopen(dirname(__FILE__)."/../".$filename."/sitemap_".$page_num.".xml","w");
      fwrite($urlmap,$sitemap);
      fclose($urlmap);
      ShowMsg("成功生成文章列表地图：<a href='".$cfg_basehost."/".$filename."/sitemap_".$page_num.".xml' target='_blank'>/".$filename."/sitemap_".$page_num.".xml</a><br>共".$row_sum['mycount']."条记录，每页".$perpageurl."条，当前".$page_num."/".$pagenumber."页","javascript:;");
      $limit_st = $limit_st + $perpageurl;
}
ShowMsg("全部生成成功！","javascript:;");
exit();
}
?>
生成老是会卡住。。大概一百多万条数据。。

©DZ插件网所发布的一切资源仅限用于学习和研究目的；不得将上述内容用于商业或者非法用途，否则，一切后果请用户自负。
网站部分内容来源于网络，版权争议与本站无关。您必须在下载后的24个小时之内，从您的电脑中彻底删除上述内容。如果您喜欢该程序，请支持正版软件，得到更好的正版服务。
您在本站任何的赞助购买、下载、查阅、回复等行为等均表示接受并同意签订《DZ插件网免责声明协议》。
如有侵权请邮件与我们联系处理: discuzaddons@vip.qq.com 并出示相关证明以便删除。敬请谅解！

拾光 · 发表于 2023-9-25 18:31:40

看不懂。给你顶一下哈

婷姐 · 发表于 2023-9-25 18:32:03

看不懂。给你顶一下哈

TyCoding · 发表于 2023-9-25 18:32:41

织梦的程序？你把这个拆开生成看看

独家记忆 · 发表于 2023-9-25 18:33:21

不好拆吧。

独家记忆 · 发表于 2023-9-25 18:33:35

明显可以拆啊，自己改写按照分类生成吧！你可能数据量大，生成出问题的

IT618发布 · 发表于 2023-9-25 18:33:53

怎么拆啊。

独家记忆 · 发表于 2023-9-25 18:34:41

<?php/*** 生成Sitemap操作** @version $Id: google_sitemap.php 1 10:00 2011年9月19日Z SSKCN $* @package SSKCN.Administrator* @copyright Copyright (c) 2011 - 2013, SSKCN, Inc.* @license http://www.sskcn.com/license.html* [url=home.php?mod=space&uid=19972]@link[/url] http://www.sskcn.com/*/require_once(dirname(__FILE__)."/config.php");CheckPurview('plus_Sitemap');require_once(DEDEINC."/typelink.class.php");$tl = new TypeLink(0);function DateDiff($interval, $date1, $date2) { $time_difference = $date2 - $date1; switch ($interval) { case "y": $retval = bcdiv($time_difference, 31536000); break; case "m": $retval = bcdiv($time_difference, 2592000); break; case "w": $retval = bcdiv($time_difference, 604800); break; case "d": $retval = bcdiv($time_difference, 86400); break; case "h": $retval = bcdiv($time_difference, 3600); break; case "n": $retval = bcdiv($time_difference, 60); break; case "s": $retval = $time_difference; break; } return $retval;}function getSonClass($ID, $tl) { global $dsql; $SonClass = ""; $dsql->SetQuery("Select id,typename,typedir,isdefault,ispart,defaultname,namerule2,moresite,siteurl,sitepath from `#@__arctype` where reid='".$ID."' and ishidden<>1 order by id,sortrank"); $dsql->execute(); while($row_class = $dsql->getarray($ID)){ ShowMsg($ID); $SonClass .= "<url>\n"; $iClassUrl = $tl->GetOneTypeUrl($row_class); $iClassUrl = count(explode("http://",$iClassUrl)) > 1 ? $iClassUrl : $GLOBALS['cfg_basehost'].$iClassUrl; $SonClass .= "<loc>".$iClassUrl."</loc>\n"; $SonClass .= "<lastmod>".date("Y-m-d",time())."T".date("H:i:s+08:00",time())."</lastmod>\n"; $SonClass .= "<changefreq>daily</changefreq>\n"; $SonClass .= "<priority>0.9</priority>\n"; $SonClass .= "</url>\n"; $SonClass .= getSonClass($row_class["id"], $tl); } return $SonClass;}function MK_Dir($path,$pathname){ if(!file_exists($path)){ createDir(dirname($path)); mkdir($path, 0775); ShowMsg("成功创建目录".$pathname,"javascript:;"); }}if(empty($dopost)){ include DEDEADMIN.'/templets/google_sitemap.htm';} else if($dopost == "make") { //取得数目 $dsql->SetQuery("Select count(*) as mycount from `#@__archives` where ismake=1"); $dsql->execute(); $row_sum = $dsql->getarray(); if(($sumurl > $row_sum['mycount']) || empty($sumurl)){ $sumurl = $row_sum['mycount']; } $pagenum = intval($sumurl/$perpageurl); $pagenumber = $pagenum; if($pagenum < ($sumurl/$perpageurl)){ $pagenumber = $pagenum + 1; } //创建目录 MK_Dir(dirname(__FILE__)."/../".$filename,$filename); //索引页sitemap_index.xml $sitemap_index = "<?xml version="1.0" encoding="UTF-8"?>\n"; $sitemap_index .= "<sitemapindex xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">\n"; for($i=0; $i <= $pagenumber; $i++){ $sitemap_index .= "<sitemap>\n"; $sitemap_index .= "<loc>".$GLOBALS['cfg_basehost']."/sitemap/sitemap_$i.xml</loc>\n"; $sitemap_index .= "<lastmod>".date("Y-m-d",time())."T".date("H:i:s+08:00",time())."</lastmod>\n"; $sitemap_index .= "</sitemap>\n"; } $sitemap_index .= "</sitemapindex>"; $indexmap = fopen(dirname(__FILE__)."/../".$filename."/sitemap_index.xml", "w"); fwrite($indexmap, $sitemap_index); fclose($indexmap); ShowMsg("成功生成地图索引：<a href='".$GLOBALS['cfg_basehost']."/".$filename."/sitemap_index.xml' target='_blank'>/".$filename."/sitemap_index.xml</a>","javascript:;"); //首页、栏目列表sitemap_0.xml $sitemap_1 = "<?xml version="1.0" encoding="UTF-8"?>\n"; $sitemap_1 .= "<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">\n"; $sitemap_1 .= "<url>\n"; $sitemap_1 .= "<loc>".$GLOBALS['cfg_basehost']."/</loc>\n"; $sitemap_1 .= "<lastmod>".date("Y-m-d",time())."T".date("H:i:s+08:00",time())."</lastmod>\n"; $sitemap_1 .= "<changefreq>always</changefreq>\n"; $sitemap_1 .= "<priority>1.0</priority>\n"; $sitemap_1 .= "</url>\n"; // 获取栏目数据（优化） $arctypeData = []; $dsql->SetQuery("Select id,typename,typedir,isdefault,ispart,defaultname,namerule2,moresite,siteurl,sitepath from `#@__arctype` where ishidden<>1 order by id,sortrank"); $dsql->execute(); while($row_type = $dsql->getarray()){ $arctypeData[] = $row_type; // 保存到数组中，避免多次查询数据库 } foreach($arctypeData as $row_type) { $sitemap_1 .= "<url>\n"; $iTypeUrl = $tl->GetOneTypeUrl($row_type); $iTypeUrl = count(explode("http://",$iTypeUrl)) > 1 ? $iTypeUrl : $GLOBALS['cfg_basehost'].$iTypeUrl; $sitemap_1 .= "<loc>".$iTypeUrl."</loc>\n"; $sitemap_1 .= "<lastmod>".date("Y-m-d",time())."T".date("H:i:s+08:00",time())."</lastmod>\n"; $sitemap_1 .= "<changefreq>daily</changefreq>\n"; $sitemap_1 .= "<priority>0.9</priority>\n"; $sitemap_1 .= "</url>\n"; //$sitemap_1 .= getSonClass($row_type["id"]); } $sitemap_1 .= "</urlset>"; $classmap = fopen(dirname(__FILE__)."/../".$filename."/sitemap_0.xml", "w"); fwrite($classmap, $sitemap_1); fclose($classmap); ShowMsg("成功生成首页、栏目列表地图：<a href='".$GLOBALS['cfg_basehost']."/".$filename."/sitemap_0.xml' target='_blank'>/".$filename."/sitemap_0.xml</a>","javascript:;"); //所有文章sitemap_(1-*).xml $limit_st = 0; for($page_num=1; $page_num<=$pagenumber; $page_num++){ $sitemap = "<?xml version="1.0" encoding="UTF-8"?>\n"; $sitemap .= "<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">\n"; $query = "Select arc.*,tp.typedir,tp.typename,tp.isdefault,tp.defaultname,tp.namerule,tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath from `#@__archives` arc LEFT JOIN `#@__arctype` tp ON arc.typeid=tp.id where arc.ismake=1 order by pubdate limit $limit_st,$perpageurl"; $dsql->SetQuery($query); $dsql->execute(); while($row_url = $dsql->getarray()){ //自动识别动态页和静态页 $row_url["arcurl"] = GetFileUrl($row_url["id"],$row_url["typeid"],$row_url["senddate"],$row_url["title"],$row_url["ismake"],$row_url["arcrank"],$row_url["namerule"],$row_url["typedir"],$row_url["money"],$row_url['filename'],$row_url["moresite"],$row_url["siteurl"],$row_url["sitepath"]); $row_url["fullurl"] = $GLOBALS['cfg_basehost'].$row_url["arcurl"]; if($GLOBALS['cfg_multi_site'] == 'Y') $row_url["fullurl"] = $row_url["arcurl"]; $link = $row_url["fullurl"]; $times = $row_url['senddate'] ; $lastmodified=date("Y-m-d",$times)."T".date("H:i:s+08:00",$times); //生成更新频率和更新指数 $priority="0.8"; //生成sitemap $sitemap .= "<url>\n"; $sitemap .= "<loc>$link</loc>\n"; $sitemap .= "<lastmod>$lastmodified</lastmod>\n"; $sitemap .= "<changefreq>$changefreq</changefreq>\n"; $sitemap .= "<priority>$priority</priority>\n"; $sitemap .= "</url>\n"; } $sitemap .= "</urlset>"; $urlmap = fopen(dirname(__FILE__)."/../".$filename."/sitemap_".$page_num.".xml","w"); fwrite($urlmap,$sitemap); fclose($urlmap); ShowMsg("成功生成文章列表地图：<a href='".$GLOBALS['cfg_basehost']."/".$filename."/sitemap_".$page_num.".xml' target='_blank'>/".$filename."/sitemap_".$page_num.".xml</a><br>共".$row_sum['mycount']."条记录，每页".$perpageurl."条，当前".$page_num."/".$pagenumber."页","javascript:;"); $limit_st = $limit_st + $perpageurl; } ShowMsg("全部生成成功！","javascript:;"); exit();}?>

复制代码

给你做了一下优化，试试看，

浅生 · 发表于 2023-9-25 18:34:58

***内容可能违规暂时被隐藏***

拾光 · 发表于 2023-9-25 18:35:46

<?php// 引入必要文件require_once(dirname(__FILE__)."/config.php");require_once(DEDEINC."/arc.partview.class.php");require_once(DEDEINC."/gzip.func.php");// 检查是否具有管理员权限CheckPurview('sys_Sitemap');// 获取每个Sitemap中最大文章数量$sitemap_max_count = isset($sitemap_max_count) ? intval($sitemap_max_count) : 50000;if(empty($dopost)){ // 显示生成Sitemap的表单页面 include(dirname(__FILE__)."/google_sitemap.htm");}else if($dopost == "make"){ // 获取所有栏目ID $acolumns = GetOptionList($cfg_mainsite."--".$cfg_curhost."/sitemap_columns.txt"); // 获取文章总数和总页数 $totalcount = $dsql->GetOne("SELECT COUNT(*) FROM `#@__archives` WHERE arcrank>-1 AND ishidden=0"); $pagesize = ceil($totalcount['COUNT(*)'] / $sitemap_max_count); // 生成地图索引文件 $sitemap_index_content = '<?xml version="1.0" encoding="UTF-8"?>'; $sitemap_index_content .= '<sitemapindex xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">'; for ($i=0; $i < $pagesize; $i++) { $filename = 'sitemap_'.$i.'.xml'; $file_path = $sitemap_dir . '/' . $filename; if (!is_file($file_path)) { touch($file_path); chmod($file_path, 0777); } $sitemap_index_content .= '<sitemap>'; $sitemap_index_content .= '<loc>'.$sitemap_url.'/'.$filename.'</loc>'; $sitemap_index_content .= '<lastmod>'.date('Y-m-d').'</lastmod>'; $sitemap_index_content .= '</sitemap>'; // 生成地图文件 $arcQuery = "SELECT arc.id,arc.title,arc.senddate,tp.typedir,tp.typename,tp.corank,arc.click,arc.description FROM `#@__archives` AS arc LEFT JOIN `#@__arctype` AS tp ON arc.typeid=tp.id WHERE arc.arcrank>-1 AND arc.ishidden=0 ORDER BY arc.id DESC"; $arcQuery = $dsql->SetQuery($arcQuery); $arcResult = $dsql->Execute('arcList', $arcQuery); $item_count = 0; // 当前地图文件已生成的文章数 $xml_content = '<?xml version="1.0" encoding="UTF-8"?>'; $xml_content .= '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">'; while ($row = $dsql->GetArray('arcList')) { // 获取文章URL $artUrl = GetFileUrl($row['id'], $row['typeid'], $row['senddate'], $row['title'], $row['ismake'], $row['arcrank'], $row['namerule'], $row['typedir'], $row['money'], $row['filename'], $row['moresite'], $row['siteurl']); if ($item_count < $sitemap_max_count) { // 将文章URL添加到当前地图文件中 $xml_content .= '<url>'; $xml_content .= '<loc>'.$artUrl.'</loc>'; $xml_content .= '<lastmod>'.date('Y-m-d', strtotime($row['senddate'])).'</lastmod>'; $xml_content .= '<changefreq>weekly</changefreq>'; $xml_content .= '<priority>0.8</priority>'; $xml_content .= '</url>'; $item_count++; } else { break; } } $xml_content .= '</urlset>'; // 将当前地图文件写入缓存 $cache_key = 'sitemap_'.$i; $cache->set($cache_key, $xml_content); unset($arcResult); } $sitemap_index_content .= '</sitemapindex>'; // 将地图索引文件写入磁盘 $sitemap_index_file = $sitemap_dir . '/' . 'sitemap_index.xml'; file_put_contents($sitemap_index_file, $sitemap_index_content); echo "<script>alert('Sitemap已经生成！');</script>";}?>

复制代码

试试这个呢