当前位置:CMS系统 > > 正文

dedecms标签分类(dedecms list增加noflag属性的方法 实现让列表标签不调用有推荐属性的文章)

时间:2022-01-15 01:47:51类别:CMS系统

dedecms标签分类

dedecms list增加noflag属性的方法 实现让列表标签不调用有推荐属性的文章
  • 修改include/arc.listview.class.php,以下是修改后的文件

     

  • 复制代码
  • 代码如下:

  • <?php if(!defined('DEDEINC')) exit('Request Error!');</p> <p>require_once(DEDEINC.'/arc.partview.class.php');
    require_once(DEDEINC.'/ftp.class.php');</p> <p>helper('cache');
    @set_time_limit(0);</p> <p>
    class ListView
    {
    var $dsql;
    var $dtp;
    var $dtp2;
    var $TypeID;
    var $TypeLink;
    var $PageNo;
    var $TotalPage;
    var $TotalResult;
    var $PageSize;
    var $ChannelUnit;
    var $ListType;
    var $Fields;
    var $PartView;
    var $upPageType;
    var $addSql;
    var $IsError;
    var $CrossID;
    var $IsReplace;
    var $ftp;
    var $remoteDir;
    var $Noflag; 
    function __construct($typeid, $uppage=1)
    {
    global $dsql,$ftp;
    $this->TypeID = $typeid;
    $this->dsql = &$dsql;
    $this->CrossID = '';
    $this->IsReplace = false;
    $this->IsError = false;
    $this->dtp = new DedeTagParse();
    $this->dtp->SetRefObj($this);
    $this->dtp->SetNameSpace("dede", "{", "}");
    $this->dtp2 = new DedeTagParse();
    $this->dtp2->SetNameSpace("field","[","]");
    $this->TypeLink = new TypeLink($typeid);
    $this->upPageType = $uppage;
    $this->ftp = &$ftp;
    $this->remoteDir = '';
    $this->TotalResult = is_numeric($this->TotalResult)? $this->TotalResult : "";

    if(!is_array($this->TypeLink->TypeInfos))
    {
    $this->IsError = true;
    }
    if(!$this->IsError)
    {
    $this->ChannelUnit = new ChannelUnit($this->TypeLink->TypeInfos['channeltype']);
    $this->Fields = $this->TypeLink->TypeInfos;
    $this->Fields['id'] = $typeid;
    $this->Fields['position'] = $this->TypeLink->GetPositionLink(true);
    $this->Fields['title'] = preg_replace("/[<>]/", " / ", $this->TypeLink->GetPositionLink(false));
    //设置一些全局参数的值
    foreach($GLOBALS['PubFields'] as $k=>$v) $this->Fields[$k] = $v;
    $this->Fields['rsslink'] = $GLOBALS['cfg_cmsurl']."/data/rss/".$this->TypeID.".xml";</p> <p>//设置环境变量
    SetSysEnv($this->TypeID,$this->Fields['typename'],0,'','list');
    $this->Fields['typeid'] = $this->TypeID;</p> <p>//获得交叉栏目ID
    if($this->TypeLink->TypeInfos['cross']>0 && $this->TypeLink->TypeInfos['ispart']==0)
    {
    $selquery = '';
    if($this->TypeLink->TypeInfos['cross']==1)
    {
    $selquery = "SELECT id,topid FROM `dede_arctype` WHERE typename LIKE '{$this->Fields['typename']}' AND id<>'{$this->TypeID}' AND topid<>'{$this->TypeID}' ";
    }
    else
    {
    $this->Fields['crossid'] = preg_replace('/[^0-9,]/', '', trim($this->Fields['crossid']));
    if($this->Fields['crossid']!='')
    {
    $selquery = "SELECT id,topid FROM `dede_arctype` WHERE id in({$this->Fields['crossid']}) AND id<>{$this->TypeID} AND topid<>{$this->TypeID} ";
    }
    }
    if($selquery!='')
    {
    $this->dsql->SetQuery($selquery);
    $this->dsql->Execute();
    while($arr = $this->dsql->GetArray())
    {
    $this->CrossID .= ($this->CrossID=='' ? $arr['id'] : ','.$arr['id']);
    }
    }
    }
    }//!error
    }</p> <p>//php4构造函数
    function ListView($typeid,$uppage=0){
    $this->__construct($typeid,$uppage);
    }
    //关闭相关资源
    function Close()
    { }
    function CountRecord()
    {
    global $cfg_list_son,$cfg_need_typeid2,$cfg_cross_sectypeid;
    if(empty($cfg_need_typeid2)) $cfg_need_typeid2 = 'N';

    //统计数据库记录
    $this->TotalResult = -1;
    if(isset($GLOBALS['TotalResult'])) $this->TotalResult = $GLOBALS['TotalResult'];
    if(isset($GLOBALS['PageNo'])) $this->PageNo = $GLOBALS['PageNo'];
    else $this->PageNo = 1;
    $this->addSql = " arc.arcrank > -1 ";

    $typeid2like = " '%,{$this->TypeID},%' ";
    if($cfg_list_son=='N')
    {

    if($cfg_need_typeid2=='N')
    {
    if($this->CrossID=='') $this->addSql .= " AND (arc.typeid='".$this->TypeID."') ";
    else $this->addSql .= " AND (arc.typeid in({$this->CrossID},{$this->TypeID})) ";
    }
    else
    {
    if($this->CrossID=='')
    {
    $this->addSql .= " AND ( (arc.typeid='".$this->TypeID."') OR CONCAT(',', arc.typeid2, ',') LIKE $typeid2like) ";
    } else {
    if($cfg_cross_sectypeid == 'Y')
    {
    $typeid2Clike = " '%,{$this->CrossID},%' ";
    $this->addSql .= " AND ( arc.typeid IN({$this->CrossID},{$this->TypeID}) OR CONCAT(',', arc.typeid2, ',') LIKE $typeid2like OR CONCAT(',', arc.typeid2, ',') LIKE $typeid2Clike)";
    } else {
    $this->addSql .= " AND ( arc.typeid IN({$this->CrossID},{$this->TypeID}) OR CONCAT(',', arc.typeid2, ',') LIKE $typeid2like)";
    }
    }
    }
    }
    else
    {
    $sonids = GetSonIds($this->TypeID,$this->Fields['channeltype']);
    if(!preg_match("/,/", $sonids)) {
    $sonidsCon = " arc.typeid = '$sonids' ";
    }
    else {
    $sonidsCon = " arc.typeid IN($sonids) ";
    }
    if($cfg_need_typeid2=='N')
    {
    if($this->CrossID=='') $this->addSql .= " AND ( $sonidsCon ) ";
    else $this->addSql .= " AND ( arc.typeid IN ({$sonids},{$this->CrossID}) ) ";
    }
    else
    {
    if($this->CrossID=='')
    {
    $this->addSql .= " AND ( $sonidsCon OR CONCAT(',', arc.typeid2, ',') like $typeid2like ) ";
    } else {
    if($cfg_cross_sectypeid == 'Y')
    {
    $typeid2Clike = " '%,{$this->CrossID},%' ";
    $this->addSql .= " AND ( arc.typeid IN ({$sonids},{$this->CrossID}) OR CONCAT(',', arc.typeid2, ',') LIKE $typeid2like OR CONCAT(',', arc.typeid2, ',') LIKE $typeid2Clike) ";
    } else {
    $this->addSql .= " AND ( arc.typeid IN ({$sonids},{$this->CrossID}) OR CONCAT(',', arc.typeid2, ',') LIKE $typeid2like) ";
    }
    }
    }
    }
    if($this->TotalResult==-1)
    {
    $cquery = "SELECT COUNT(*) AS dd FROM `dede_arctiny` arc WHERE ".$this->addSql;
    $row = $this->dsql->GetOne($cquery);
    if(is_array($row))
    {
    $this->TotalResult = $row['dd'];
    }
    else
    {
    $this->TotalResult = 0;
    }
    }</p> <p>//初始化列表模板,并统计页面总数
    $tempfile = $GLOBALS['cfg_basedir'].$GLOBALS['cfg_templets_dir']."/".$this->TypeLink->TypeInfos['templist'];
    $tempfile = str_replace("{tid}", $this->TypeID, $tempfile);
    $tempfile = str_replace("{cid}", $this->ChannelUnit->ChannelInfos['nid'], $tempfile);
    if(!file_exists($tempfile))
    {
    $tempfile = $GLOBALS['cfg_basedir'].$GLOBALS['cfg_templets_dir']."/".$GLOBALS['cfg_df_style']."/list_default.htm";
    }
    if(!file_exists($tempfile)||!is_file($tempfile))
    {
    echo "模板文件不存在,无法解析文档!";
    exit();
    }
    $this->dtp->LoadTemplate($tempfile);
    $ctag = $this->dtp->GetTag("page");
    if(!is_object($ctag))
    {
    $ctag = $this->dtp->GetTag("list");
    }
    if(!is_object($ctag))
    {
    $this->PageSize = 20;
    }
    else
    {
    if($ctag->GetAtt("pagesize")!="")
    {
    $this->PageSize = $ctag->GetAtt("pagesize");
    }
    else
    {
    $this->PageSize = 20;
    }
    }
    $this->TotalPage = ceil($this->TotalResult/$this->PageSize);
    }
    function MakeHtml($startpage=1, $makepagesize=0, $isremote=0)
    {
    global $cfg_remote_site;
    if(empty($startpage))
    {
    $startpage = 1;
    }</p> <p>//创建封面模板文件
    if($this->TypeLink->TypeInfos['isdefault']==-1)
    {
    echo '这个类目是动态类目!';
    return '../plus/list.php?tid='.$this->TypeLink->TypeInfos['id'];
    }</p> <p>//单独页面
    else if($this->TypeLink->TypeInfos['ispart']>0)
    {
    $reurl = $this->MakePartTemplets();
    return $reurl;
    }</p> <p>$this->CountRecord();
    //初步给固定值的标记赋值
    $this->ParseTempletsFirst();
    $totalpage = ceil($this->TotalResult/$this->PageSize);
    if($totalpage==0)
    {
    $totalpage = 1;
    }
    CreateDir(MfTypedir($this->Fields['typedir']));
    $murl = '';
    if($makepagesize > 0)
    {
    $endpage = $startpage+$makepagesize;
    }
    else
    {
    $endpage = ($totalpage+1);
    }
    if( $endpage >= $totalpage+1 )
    {
    $endpage = $totalpage+1;
    }
    if($endpage==1)
    {
    $endpage = 2;
    }
    for($this->PageNo=$startpage; $this->PageNo < $endpage; $this->PageNo++)
    {
    $this->ParseDMFields($this->PageNo,1);
    $makeFile = $this->GetMakeFileRule($this->Fields['id'],'list',$this->Fields['typedir'],'',$this->Fields['namerule2']);
    $makeFile = str_replace("{page}", $this->PageNo, $makeFile);
    $murl = $makeFile;
    if(!preg_match("/^\//", $makeFile))
    {
    $makeFile = "/".$makeFile;
    }
    $makeFile = $this->GetTruePath().$makeFile;
    $makeFile = preg_replace("/\/{1,}/", "/", $makeFile);
    $murl = $this->GetTrueUrl($murl);
    $this->dtp->SaveTo($makeFile);
    //如果启用远程发布则需要进行判断
    if($cfg_remote_site=='Y'&& $isremote == 1)
    {
    //分析远程文件路径
    $remotefile = str_replace(DEDEROOT, '',$makeFile);
    $localfile = '..'.$remotefile;
    $remotedir = preg_replace('/[^\/]*\.html/', '',$remotefile);
    //不相等则说明已经切换目录则可以创建镜像
    $this->ftp->rmkdir($remotedir);
    $this->ftp->upload($localfile, $remotefile, 'acii');
    }
    }
    if($startpage==1)
    {
    //如果列表启用封面文件,复制这个文件第一页
    if($this->TypeLink->TypeInfos['isdefault']==1
    && $this->TypeLink->TypeInfos['ispart']==0)
    {
    $onlyrule = $this->GetMakeFileRule($this->Fields['id'],"list",$this->Fields['typedir'],'',$this->Fields['namerule2']);
    $onlyrule = str_replace("{page}","1",$onlyrule);
    $list_1 = $this->GetTruePath().$onlyrule;
    $murl = MfTypedir($this->Fields['typedir']).'/'.$this->Fields['defaultname'];
    //如果启用远程发布则需要进行判断
    if($cfg_remote_site=='Y'&& $isremote == 1)
    {
    //分析远程文件路径
    $remotefile = $murl;
    $localfile = '..'.$remotefile;
    $remotedir = preg_replace('/[^\/]*\.html/', '',$remotefile);
    //不相等则说明已经切换目录则可以创建镜像
    $this->ftp->rmkdir($remotedir);
    $this->ftp->upload($localfile, $remotefile, 'acii');
    }
    $indexname = $this->GetTruePath().$murl;
    copy($list_1,$indexname);
    }
    }
    return $murl;
    }</p> <p>function Display()
    {
    if($this->TypeLink->TypeInfos['ispart']>0)
    {
    $this->DisplayPartTemplets();
    return ;
    }
    $this->CountRecord();
    if((empty($this->PageNo) || $this->PageNo==1)
    && $this->TypeLink->TypeInfos['ispart']==1)
    {
    $tmpdir = $GLOBALS['cfg_basedir'].$GLOBALS['cfg_templets_dir'];
    $tempfile = str_replace("{tid}",$this->TypeID,$this->Fields['tempindex']);
    $tempfile = str_replace("{cid}",$this->ChannelUnit->ChannelInfos['nid'],$tempfile);
    $tempfile = $tmpdir."/".$tempfile;
    if(!file_exists($tempfile))
    {
    $tempfile = $tmpdir."/".$GLOBALS['cfg_df_style']."/index_default.htm";
    }
    $this->dtp->LoadTemplate($tempfile);
    }
    $this->ParseTempletsFirst();
    $this->ParseDMFields($this->PageNo,0);
    $this->dtp->Display();

    function MakePartTemplets()
    {
    $this->PartView = new PartView($this->TypeID,false);
    $this->PartView->SetTypeLink($this->TypeLink);
    $nmfa = 0;
    $tmpdir = $GLOBALS['cfg_basedir'].$GLOBALS['cfg_templets_dir'];
    if($this->Fields['ispart']==1)
    {
    $tempfile = str_replace("{tid}",$this->TypeID,$this->Fields['tempindex']);
    $tempfile = str_replace("{cid}",$this->ChannelUnit->ChannelInfos['nid'],$tempfile);
    $tempfile = $tmpdir."/".$tempfile;
    if(!file_exists($tempfile))
    {
    $tempfile = $tmpdir."/".$GLOBALS['cfg_df_style']."/index_default.htm";
    }
    $this->PartView->SetTemplet($tempfile);
    }
    else if($this->Fields['ispart']==2)
    {
    //跳转网址
    return $this->Fields['typedir'];
    }
    CreateDir(MfTypedir($this->Fields['typedir']));
    $makeUrl = $this->GetMakeFileRule($this->Fields['id'],"index",MfTypedir($this->Fields['typedir']),$this->Fields['defaultname'],$this->Fields['namerule2']);
    $makeUrl = preg_replace("/\/{1,}/", "/", $makeUrl);
    $makeFile = $this->GetTruePath().$makeUrl;
    if($nmfa==0)
    {
    $this->PartView->SaveToHtml($makeFile);
    //如果启用远程发布则需要进行判断
    if($GLOBALS['cfg_remote_site']=='Y'&& $isremote == 1)
    {
    //分析远程文件路径
    $remotefile = str_replace(DEDEROOT, '',$makeFile);
    $localfile = '..'.$remotefile;
    $remotedir = preg_replace('/[^\/]*\.html/', '',$remotefile);
    //不相等则说明已经切换目录则可以创建镜像
    $this->ftp->rmkdir($remotedir);
    $this->ftp->upload($localfile, $remotefile, 'acii');
    }
    }
    else
    {
    if(!file_exists($makeFile))
    {
    $this->PartView->SaveToHtml($makeFile);
    //如果启用远程发布则需要进行判断
    if($cfg_remote_site=='Y'&& $isremote == 1)
    {
    //分析远程文件路径
    $remotefile = str_replace(DEDEROOT, '',$makeFile);
    $localfile = '..'.$remotefile;
    $remotedir = preg_replace('/[^\/]*\.html/', '',$remotefile);
    //不相等则说明已经切换目录则可以创建镜像
    $this->ftp->rmkdir($remotedir);
    $this->ftp->upload($localfile, $remotefile, 'acii');
    }
    }
    }
    return $this->GetTrueUrl($makeUrl);
    }</p> <p> 
    function DisplayPartTemplets()
    {
    $this->PartView = new PartView($this->TypeID,false);
    $this->PartView->SetTypeLink($this->TypeLink);
    $nmfa = 0;
    $tmpdir = $GLOBALS['cfg_basedir'].$GLOBALS['cfg_templets_dir'];
    if($this->Fields['ispart']==1)
    {
    //封面模板
    $tempfile = str_replace("{tid}",$this->TypeID,$this->Fields['tempindex']);
    $tempfile = str_replace("{cid}",$this->ChannelUnit->ChannelInfos['nid'],$tempfile);
    $tempfile = $tmpdir."/".$tempfile;
    if(!file_exists($tempfile))
    {
    $tempfile = $tmpdir."/".$GLOBALS['cfg_df_style']."/index_default.htm";
    }
    $this->PartView->SetTemplet($tempfile);
    }
    else if($this->Fields['ispart']==2)
    {
    //跳转网址
    $gotourl = $this->Fields['typedir'];
    header("Location:$gotourl");
    exit();
    }
    CreateDir(MfTypedir($this->Fields['typedir']));
    $makeUrl = $this->GetMakeFileRule($this->Fields['id'],"index",MfTypedir($this->Fields['typedir']),$this->Fields['defaultname'],$this->Fields['namerule2']);
    $makeFile = $this->GetTruePath().$makeUrl;
    if($nmfa==0)
    {
    $this->PartView->Display();
    }
    else
    {
    if(!file_exists($makeFile))
    {
    $this->PartView->Display();
    }
    else
    {
    include($makeFile);
    }
    }
    }</p> <p> 
    function GetTruePath()
    {
    $truepath = $GLOBALS["cfg_basedir"];
    return $truepath;
    }</p> <p> 
    function GetTrueUrl($nurl)
    {
    if($this->Fields['moresite']==1)
    {
    if($this->Fields['sitepath']!='')
    {
    $nurl = preg_replace("/^".$this->Fields['sitepath']."/", '', $nurl);
    }
    $nurl = $this->Fields['siteurl'].$nurl;
    }
    return $nurl;
    }</p> <p> 
    function ParseTempletsFirst()
    {
    if(isset($this->TypeLink->TypeInfos['reid']))
    {
    $GLOBALS['envs']['reid'] = $this->TypeLink->TypeInfos['reid'];
    }
    $GLOBALS['envs']['typeid'] = $this->TypeID;
    $GLOBALS['envs']['topid'] = GetTopid($this->Fields['typeid']);
    $GLOBALS['envs']['cross'] = 1;
    MakeOneTag($this->dtp,$this);
    }</p> <p> 
    function ParseDMFields($PageNo,$ismake=1)
    {
    //替换第二页后的内容
    if(($PageNo>1 || strlen($this->Fields['content'])<10 ) && !$this->IsReplace)
    {
    $this->dtp->SourceString = str_replace('[cmsreplace]','display:none',$this->dtp->SourceString);
    $this->IsReplace = true;
    }
    foreach($this->dtp->CTags as $tagid=>$ctag)
    {
    if($ctag->GetName()=="list")
    {
    $limitstart = ($this->PageNo-1) * $this->PageSize;
    $row = $this->PageSize;
    if(trim($ctag->GetInnerText())=="")
    {
    $InnerText = GetSysTemplets("list_fulllist.htm");
    }
    else
    {
    $InnerText = trim($ctag->GetInnerText());
    }
    $this->dtp->Assign($tagid,
    $this->GetArcList(
    $limitstart,
    $row,
    $ctag->GetAtt("col"),
    $ctag->GetAtt("titlelen"),
    $ctag->GetAtt("infolen"),
    $ctag->GetAtt("imgwidth"),
    $ctag->GetAtt("imgheight"),
    $ctag->GetAtt("listtype"),
    $ctag->GetAtt("orderby"),
    $InnerText,
    $ctag->GetAtt("tablewidth"),
    $ismake,
    $ctag->GetAtt("orderway"),
    $ctag->GetAtt("noflag")
    )
    );
    }
    else if($ctag->GetName()=="pagelist")
    {
    $list_len = trim($ctag->GetAtt("listsize"));
    $ctag->GetAtt("listitem")=="" ? $listitem="index,pre,pageno,next,end,option" : $listitem=$ctag->GetAtt("listitem");
    if($list_len=="")
    {
    $list_len = 3;
    }
    if($ismake==0)
    {
    $this->dtp->Assign($tagid,$this->GetPageListDM($list_len,$listitem));
    }
    else
    {
    $this->dtp->Assign($tagid,$this->GetPageListST($list_len,$listitem));
    }
    }
    else if($PageNo!=1 && $ctag->GetName()=='field' && $ctag->GetAtt('display')!='')
    {
    $this->dtp->Assign($tagid,'');
    }
    }
    }</p> <p> 
    function GetMakeFileRule($typeid,$wname,$typedir,$defaultname,$namerule2)
    {
    $typedir = MfTypedir($typedir);
    if($wname=='index')
    {
    return $typedir.'/'.$defaultname;
    }
    else
    {
    $namerule2 = str_replace('{tid}',$typeid,$namerule2);
    $namerule2 = str_replace('{typedir}',$typedir,$namerule2);
    return $namerule2;
    }
    }</p> <p> 
    function GetArcList($limitstart=0,$row=10,$col=1,$titlelen=30,$infolen=250,
    $imgwidth=120,$imgheight=90,$listtype="all",$orderby="default",$innertext="",$tablewidth="100",$ismake=1,$orderWay='desc',$noflag='')
    {
    global $cfg_list_son,$cfg_digg_update;
    $noflags = explode(',', $noflag);
    $noflagsql = '';
    for($i=0;$i<count($noflags);$i++)
    {
    $noflagsql .= "And arc.flag not like '%{$noflags[$i]}%' ";

    $typeid=$this->TypeID;

    if($row=='') $row = 10;
    if($limitstart=='') $limitstart = 0;
    if($titlelen=='') $titlelen = 100;
    if($infolen=='') $infolen = 250;
    if($imgwidth=='') $imgwidth = 120;
    if($imgheight=='') $imgheight = 120;
    if($listtype=='') $listtype = 'all';
    if($orderWay=='') $orderWay = 'desc';

    if($orderby=='') {
    $orderby='default';
    }
    else {
    $orderby=strtolower($orderby);
    }

    $tablewidth = str_replace('%','',$tablewidth);
    if($tablewidth=='') $tablewidth=100;
    if($col=='') $col=1;
    $colWidth = ceil(100/$col);
    $tablewidth = $tablewidth.'%';
    $colWidth = $colWidth.'%';

    $innertext = trim($innertext);
    if($innertext=='') {
    $innertext = GetSysTemplets('list_fulllist.htm');
    }</p> <p>//排序方式
    $ordersql = '';
    if($orderby=="senddate" || $orderby=="id") {
    $ordersql=" ORDER BY arc.id $orderWay";
    }
    else if($orderby=="hot" || $orderby=="click") {
    $ordersql = " ORDER BY arc.click $orderWay";
    }
    else if($orderby=="lastpost") {
    $ordersql = " ORDER BY arc.lastpost $orderWay";
    }
    else {
    $ordersql=" ORDER BY arc.sortrank $orderWay";
    }</p> <p>//获得附加表的相关信息
    $addtable = $this->ChannelUnit->ChannelInfos['addtable'];
    if($addtable!="")
    {
    $addJoin = " LEFT JOIN `$addtable` ON arc.id = ".$addtable.'.aid ';
    $addField = '';
    $fields = explode(',',$this->ChannelUnit->ChannelInfos['listfields']);
    foreach($fields as $k=>$v)
    {
    $nfields[$v] = $k;
    }
    if(is_array($this->ChannelUnit->ChannelFields) && !empty($this->ChannelUnit->ChannelFields))
    {
    foreach($this->ChannelUnit->ChannelFields as $k=>$arr)
    {
    if(isset($nfields[$k]))
    {
    if(!empty($arr['rename'])) {
    $addField .= ','.$addtable.'.'.$k.' as '.$arr['rename'];
    }
    else {
    $addField .= ','.$addtable.'.'.$k;
    }
    }
    }
    }
    }
    else
    {
    $addField = '';
    $addJoin = '';
    }</p> <p>//如果不用默认的sortrank或id排序,使用联合查询(数据量大时非常缓慢)
    if(preg_match('/hot|click|lastpost/', $orderby))
    {
    $query = "Select arc.*,tp.typedir,tp.typename,tp.isdefault,tp.defaultname,
    tp.namerule,tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath
    $addField
    from `dede_archives` arc
    left join `dede_arctype` tp on arc.typeid=tp.id
    $addJoin
    where {$this->addSql} $noflagsql $ordersql limit $limitstart,$row";
    }
    //普通情况先从arctiny表查出ID,然后按ID查询(速度非常快)
    else
    {
    $numquery = "Select id From `dede_archives` arc where {$this->addSql} $noflagsql $ordersql";
    $this->dsql->SetQuery($numquery);
    $this->dsql->Execute();
    while($arr=$this->dsql->GetArray())
    {
    $fuck[] = $arr['id'];
    }
    $this->TotalResult = count($fuck);
    $t1 = ExecTime();
    $ids = array();
    $query = "Select id From `dede_archives` arc where {$this->addSql} $noflagsql $ordersql limit $limitstart,$row ";
    $this->dsql->SetQuery($query);
    $this->dsql->Execute();
    while($arr=$this->dsql->GetArray())
    {
    $ids[] = $arr['id'];
    }
    $idstr = join(',',$ids);
    if($idstr=='')
    {
    return '';
    }
    else
    {
    $query = "Select arc.*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,
    tp.namerule,tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath
    $addField
    from `dede_archives` arc left join `dede_arctype` tp on arc.typeid=tp.id
    $addJoin
    where arc.id in($idstr) $noflagsql $ordersql ";
    }
    $t2 = ExecTime();
    //echo $t2-$t1;</p> <p>}
    $this->dsql->SetQuery($query);
    $this->dsql->Execute('al');
    $t2 = ExecTime();</p> <p>//echo $t2-$t1;
    $artlist = '';
    $this->dtp2->LoadSource($innertext);
    $GLOBALS['autoindex'] = 0;
    for($i=0;$i<$row;$i++)
    {
    if($col>1)
    {
    $artlist .= "<li>\r\n";
    }
    for($j=0;$j<$col;$j++)
    {
    if($row = $this->dsql->GetArray("al"))
    {
    $GLOBALS['autoindex']++;
    $ids[$row['id']] = $row['id'];</p> <p>//处理一些特殊字段
    $row['infos'] = cn_substr($row['description'],$infolen);
    $row['id'] = $row['id'];
    if($cfg_digg_update > 0)
    {
    $prefix = 'diggCache';
    $key = 'aid-'.$row['id'];
    $cacherow = GetCache($prefix, $key);
    $row['goodpost'] = $cacherow['goodpost'];
    $row['badpost'] = $cacherow['badpost'];
    $row['scores'] = $cacherow['scores'];
    }</p> <p>if($row['corank'] > 0 && $row['arcrank']==0)
    {
    $row['arcrank'] = $row['corank'];
    }</p> <p>$row['filename'] = $row['arcurl'] = 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'],$row['sitepath']);
    $row['typeurl'] = GetTypeUrl($row['typeid'],MfTypedir($row['typedir']),$row['isdefault'],$row['defaultname'],
    $row['ispart'],$row['namerule2'],$row['moresite'],$row['siteurl'],$row['sitepath']);
    if($row['litpic'] == '-' || $row['litpic'] == '')
    {
    $row['litpic'] = $GLOBALS['cfg_cmspath'].'/images/defaultpic.gif';
    }
    if(!preg_match("/^http:\/\//i", $row['litpic']) && $GLOBALS['cfg_multi_site'] == 'Y')
    {
    $row['litpic'] = $GLOBALS['cfg_mainsite'].$row['litpic'];
    }
    $row['picname'] = $row['litpic'];
    $row['stime'] = GetDateMK($row['pubdate']);
    $row['typelink'] = "<a href='".$row['typeurl']."'>".$row['typename']."</a>";
    $row['image'] = "<img src='".$row['picname']."' border='0' width='$imgwidth' height='$imgheight' style="margin: 0px; padding: 0px; outline: none; line-height: 25.2px;">  
  • 标签:
    上一篇下一篇

    猜您喜欢

    热门推荐