DedeCms用tag调用全站相关文章

单用tag来调用相关文章,也可用tag+keyword来调用相关文章(默认tag优先于keyword,可以自己排序),非常适合SEO,经测试效果极佳 

1.把下边代码保存到文章模版的适当位置 

1
2
3
4
5
6
7
8
9
10
11
12
< div class="xgwz"> 
      < dl class="tbox"> 
            < dt >< strong >相关文章</ strong ></ dt
                < dd
                   < ul class="c1 ico2"> 
                        {dede:likearticle col='2' row='10' titlelen='42' eregtype=all|tag|keyword} 
                              < li >< a href="[field:arcurl/]">[field:title/]</ a ></ li
                       {/dede:likearticle} 
                   </ ul
                </ dd
      </ dl
</ div >

  

2.把下边的php代码替换掉include/taglib/likearticle.lib里的代码 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
<?php
if (!defined( 'DEDEINC' )) exit ( 'Request Error!' );
/*--------------------------------------
按关键词关连文章的标签
eregtype属性 
eregtype = keyword 只匹配关键字
eregtype = tag 只匹配tag
eregtype = all tag优先,不存在tag则匹配关键字
mytypeid='' 栏目ID,多个栏目用,隔开
---------------------------------------*/
function lib_likearticle(& $ctag ,& $refObj )
{
  global $dsql ;
       
  //属性处理
  $attlist = "row|12,titlelen|28,infolen|150,col|1,tablewidth|100,mytypeid|0,byabs|0,imgwidth|120,imgheight|90" ;
  FillAttsDefault( $ctag ->CAttribute->Items, $attlist );
  extract( $ctag ->CAttribute->Items, EXTR_SKIP);
  $revalue = '' ;
       
  if ( empty ( $tablewidth )) $tablewidth = 100;
  if ( empty ( $col )) $col = 1;
  $colWidth = ceil (100/ $col );
  $tablewidth = $tablewidth . "%" ;
  $colWidth = $colWidth . "%" ;
       
  $ids = array ();
  $tids = array ();
      
      
       
  $typeid = ( ! empty ( $mytypeid ) ? $mytypeid : 0 );
  if ( empty ( $typeid ))
  {
    if (! empty ( $refObj ->Typelink->TypeInfos[ 'reid' ])) {
      $typeid = $refObj ->Typelink->TypeInfos[ 'reid' ];
    }
    else {
      if (! empty ( $refObj ->Fields[ 'typeid' ])) $typeid = $refObj ->Fields[ 'typeid' ];
    }
  }
       
  if ( ! empty ( $typeid ) && ! ereg ( ',' , $typeid ) ) {
    $typeid = GetSonIds( $typeid );
  }
  if (! empty ( $refObj ->Fields[ 'tags' ]) && $eregtype != 'keyword' )
  {
   $tags = explode ( ',' , addslashes ( $refObj ->Fields[ 'tags' ]));
                     
   $getsql = " tag like '" .join( "' OR tag like '" , $tags ). "' " ;
                     
   $dsql ->Execute( 'me' , "Select * From zmb_tagindex where $getsql " );
   while ( $arow = $dsql ->GetArray( 'me' )) {
    $tids [] = $arow [ 'id' ];
   }
   $tid = join( ',' , $tids );
   if ( $tid != '' )
   {
    $dsql ->Execute( "me" , "Select aid From zmb_taglist where tid in($tid) And arcrank > -1 group by aid order by aid desc limit 0, $row" );
    while ( $arow = $dsql ->GetArray( "me" ))
    {
     $ids [] = $arow [ 'aid' ];
                                 $arcid $refObj ->Fields[ 'aid' ];
    }
   }
  }
       
  if ( $eregtype == 'tag' && count ( $ids ) == 0 )
  {
   return '' ;
  }
  else
  {
   if ( count ( $ids ) > 0)
      
      
   {
                  if (! empty ( $typeid )) {
      // $typeid = " And arc.typeid in($typeid) And arc.id<>$arcid "; 调用整站相关文章
      $typeid = "And arc.id<>$arcid" ;
     }
    $idsStr = join( ',' , $ids );
    $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
             from zmb_archives arc left join zmb_arctype tp on arc.typeid=tp.id
             where arc.id in( $idsStr ) $typeid order by arc.id desc";
   }
   else
   {
  $limitRow = $row - count ( $ids );
  $keyword = '' ;
  if (! empty ( $refObj ->Fields[ 'keywords' ]))
  {
    $keywords = explode ( ',' , trim( $refObj ->Fields[ 'keywords' ]));
    $keyword = '' ;
    $n = 1;
    foreach ( $keywords as $k )
    {
       if ( $n > 3)  break ;
            
       if (trim( $k )== '' ) continue ;
       else $k = addslashes ( $k );
            
       $keyword .= ( $keyword == '' ? " CONCAT(arc.keywords,' ',arc.title) like '%$k%' " : " OR CONCAT(arc.keywords,' ',arc.title) like '%$k%' " );
        $n ++;
    }
  }
  $arcid = (! empty ( $refObj ->Fields[ 'id' ]) ? $refObj ->Fields[ 'aid' ] : 0);
  if ( empty ( $arcid ) || $byabs ==0 ) {
   $orderquery = " order by arc.id desc " ;  
  }
  else {
   $orderquery = " order by ABS(arc.id - " . $arcid . ") " ;
   }
  if ( $keyword != '' )
  {
     if (! empty ( $typeid )) {
       $typeid = " And arc.typeid in($typeid) And arc.id<>$arcid " ;
     }
     $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
             from zmb_archives arc left join zmb_arctype tp on arc.typeid=tp.id
             where arc.arcrank>-1 and ( $keyword $typeid $orderquery limit 0, $row ";
  }
  else
  {
    if (! empty ( $typeid )) {
      $typeid = " arc.typeid in($typeid) And arc.id<>$arcid " ;
    }
    $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
             from zmb_archives arc left join zmb_arctype tp on arc.typeid=tp.id
            where arc.arcrank>-1 and  $typeid $orderquery limit 0, $row ";
                    }
               }
            }
  $innertext = trim( $ctag ->GetInnerText() );
  if ( $innertext == '' ) $innertext = GetSysTemplets( 'part_arclist.htm' );
  $dsql ->SetQuery( $query );
  $dsql ->Execute( 'al' );
   $artlist = '' ;
  if ( $col > 1) {
   $artlist = "<table width='$tablewidth' border='0' cellspacing='0' cellpadding='0'>\r\n" ;
  }
  $dtp2 = new DedeTagParse();
  $dtp2 ->SetNameSpace( 'field' , '[' , ']' );
  $dtp2 ->LoadString( $innertext );
  $GLOBALS [ 'autoindex' ] = 0;
  $line = $row ;
  for ( $i =0; $i < $line ; $i ++)
  {
   if ( $col >1) $artlist .= "<tr>\r\n" ;
   for ( $j =0; $j < $col ; $j ++)
   {
    if ( $col >1) $artlist .= " <td width='$colWidth'>\r\n" ;
    if ( $row = $dsql ->GetArray( "al" ))
    {
     $ids [] = $row [ 'id' ];
     //处理一些特殊字段
     $row [ 'info' ] = $row [ 'infos' ] = cn_substr( $row [ 'description' ], $infolen );
     $row [ 'id' ] =  $row [ 'id' ];
     if ( $row [ 'corank' ] > 0 && $row [ 'arcrank' ]==0)
     {
       $row [ 'arcrank' ] = $row [ 'corank' ];
     }
     $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' ], $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 (! eregi ( "^http://" , $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' alt= '".ereg_replace("[' ><]", "" , $row [ 'title' ]). "'>" ;
     $row [ 'imglink' ] = "<a href='" . $row ['filename ']."' >". $row [ 'image' ]. "</a>" ;
     $row [ 'fulltitle' ] = $row [ 'title' ];
     $row [ 'title' ] = cn_substr( $row [ 'title' ], $titlelen );
     if ( $row [ 'color' ]!= '' ) $row [ 'title' ] = "<font color='" . $row ['color ']."' >". $row [ 'title' ]. "</font>" ;
     if ( ereg ( 'b' , $row [ 'flag' ])) $row [ 'title' ] = "<strong>" . $row [ 'title' ]. "</strong>" ;
     $row [ 'textlink' ] = "<a href='" . $row ['filename ']."' >". $row [ 'title' ]. "</a>" ;
     $row [ 'plusurl' ] = $row [ 'phpurl' ] = $GLOBALS [ 'cfg_phpurl' ];
     $row [ 'memberurl' ] = $GLOBALS [ 'cfg_memberurl' ];
     $row [ 'templeturl' ] = $GLOBALS [ 'cfg_templeturl' ];
          
     if ( is_array ( $dtp2 ->CTags))
     {
      foreach ( $dtp2 ->CTags as $k => $ctag )
      {
       if ( $ctag ->GetName()== 'array' ) {
        $dtp2 ->Assign( $k , $row );
       }
       else {
        if (isset( $row [ $ctag ->GetName()])) $dtp2 ->Assign( $k , $row [ $ctag ->GetName()]);
        else $dtp2 ->Assign( $k , '' );
       }
      }
      $GLOBALS [ 'autoindex' ]++;
     }
     $artlist .= $dtp2 ->GetResult(). "\r\n" ;
    }
    //if hasRow
    else
    {
     $artlist .= '' ;
    }
    if ( $col >1) $artlist .= " </td>\r\n" ;
   }
   //Loop Col
   if ( $col >1) $i += $col - 1;
   if ( $col >1) $artlist .= " </tr>\r\n" ;
  }
  //loop line
  if ( $col >1) $artlist .= " </table>\r\n" ;
  $dsql ->FreeResult( "al" );
  return $artlist ;
}
?>

  

 

转载于:https://www.cnblogs.com/onlylove2015/p/4393584.html

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值