dedecms相关文章标签匹配tag、关键词、标题及调用全站相关文章方

天外飘仙

接触dedecms是从2009开始的，以前一直用风讯和科讯（ASP的）这两款，后来从成都到东莞进一公司打工，该公司就是使用的dedecms建站，我也跟着学了，怎么说呢刚开始觉得很强大，到后面用着越来越糟糕，很多地方做的不完善，另外一个让大家很火的地方就是，在dede的论坛提问题基本上官方是不会给你解答的。想调用相关文章，以tag优先调用，如果tag匹配不到或者匹配条数不够再以关键词匹配。
dedecms的相关文章标签（likearticle.lib.php）
新版的dedecms5.7相关文章标签有两个问题
1、相关文章文章调只调用当前栏目的，其他栏目的调用不到
2、只能匹配其他文章的标题（title）,和关键词(keywords)，没有去匹配其他文章tag
修改dedecms(5.7)likearticle.lib.php相关文章标签调用全站相关文章
打开likearticle.lib.php(请事先备份)，
查找：$query = "
在其上方添加：$typeid = ' AND arc.id<>$arcid '; 注意有两处，AND arc.id<>$arcid这个的意思就是限制调用出来的相关文章不包含本文章，记的dedecms7.0之前没有做 这个限制-_-，这样就取消了相关文章匹配栏目的限制了。
dedecms相关文章调用tag、关键词（keywords）、标题（title）相同的文章
dedecms官方的相关文章标签并没有匹配tag相同的文章，他只是获取当前文章的tag和关键词（keywords）去匹配其他文章的标题（title）、关键词（keywords） 请看dede的源码片断

1. if(!empty($refObj->Fields['keywords']))
   
2. {
   
3. $keywords = explode(',' , trim($refObj->Fields['keywords']));
   
4. $keyword = '';
   
5. $n = 1;
   
6. foreach($keywords as $k)
   
7. {
   
8. if($n > 3) break;
   
9. 
   
10. if(trim($k)=='') continue;
    
11. else $k = addslashes($k);
    
12. 
    
13. $keyword .= ($keyword=='' ? " CONCAT(arc.keywords,' ',arc.title) LIKE '%$k%' " : " OR CONCAT(arc.keywords,' ',arc.title) LIKE '%$k%' ");
    
14. $n++;
    
15. }
    
16. }
    
17. $arcid = (!empty($refObj->Fields['id']) ? $refObj->Fields['aid'] : 0);
    
18. if( empty($arcid) || $byabs==0 )
    
19. {
    
20. $orderquery = " ORDER BY arc.id desc ";
    
21. }
    
22. else {
    
23. $orderquery = " ORDER BY ABS(arc.id - ".$arcid.") ";
    
24. }
    
25. if($keyword != '')
    
26. {
    
27. if(!empty($typeid)) {
    
28. $typeid = " AND arc.typeid IN($typeid) AND arc.id<>$arcid ";
    
29. }
    
30. $query = "SELECT arc.*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,tp.namerule,
    
31. tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath
    
32. FROM `dede_archives` arc LEFT JOIN `dede_arctype` tp ON arc.typeid=tp.id
    
33. where arc.arcrank>-1 AND ($keyword) $typeid $orderquery limit 0, $row";
    
34. }
    
35. else
    
36. {
    
37. if(!empty($typeid)) {
    
38. $typeid = " arc.typeid IN($typeid) AND arc.id<>$arcid ";
    
39. }
    
40. $query = "SELECT arc.*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,tp.namerule,
    
41. tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath
    
42. FROM `dede_archives` arc LEFT JOIN `dede_arctype` tp ON arc.typeid=tp.id
    
43. WHERE arc.arcrank>-1 AND $typeid $orderquery limit 0, $row";
    
44. }

复制代码

注意以上绿色内容就是一部分匹配条件 ，$keyword .= ($keyword=='' ? " CONCAT(arc.keywords,' ',arc.title) LIKE '%$k%' " : " OR CONCAT(arc.keywords,' ',arc.title) LIKE '%$k%' ");可以看出dedecms只CONCAT了keywords和title，没有做tag的处理，这里提供一个方法原创作者不详。

1. #p#副标题#e#<?php
   
2. if (!defined('DEDEINC'))
   
3. exit('Request Error!');
   
4. function lib_likearticle(&$ctag, &$refObj)
   
5. {
   
6. global $dsql;
   
7. 
   
8. $attlist = "row|12,titlelen|28,infolen|150,col|1,tablewidth|100,mytypeid|0,byabs|0,imgwidth|120,imgheight|90";
   
9. FillAttsDefault($ctag->CAttribute->Items, $attlist);
   
10. extract($ctag->CAttribute->Items, EXTR_SKIP);
    
11. $revalue = '';
    
12. 
    
13. if (empty($tablewidth))
    
14. $tablewidth = 100;
    
15. if (empty($col))
    
16. $col = 1;
    
17. $colWidth = ceil(100 / $col);
    
18. $tablewidth = $tablewidth . "%";
    
19. $colWidth = $colWidth . "%";
    
20. 
    
21. $ids = array();
    
22. $tids = array();
    
23. $arcid = $refObj->Fields['aid'];
    
24. 
    
25. /* if (empty($typeid)) {
    
26. if (!empty($refObj->Typelink->TypeInfos['reid'])) {
    
27. 
    
28. $typeid = $refObj->Typelink->TypeInfos['reid'];
    
29. } else {
    
30. if (!empty($refObj->Fields['typeid']))
    
31. $typeid = $refObj->Fields['typeid'];
    
32. }
    
33. }
    
34. 
    
35. if (!empty($typeid) && !ereg(',', $typeid)) {
    
36. $typeid = GetSonIds($typeid);
    
37. }*/
    
38. 
    
39. if (!empty($refObj->Fields['tags']) && $eregtype != 'keyword') {
    
40. $tags = explode(',', addslashes($refObj->Fields['tags']));
    
41. 
    
42. $getsql = " tag like '" . join("' OR tag like '", $tags) . "' ";
    
43. 
    
44. $dsql->Execute('me', "Select * From `dede_tagindex` where $getsql ");
    
45. while ($arow = $dsql->GetArray('me')) {
    
46. $tids[] = $arow['id'];
    
47. }
    
48. $tid = join(',', $tids);
    
49. if ($tid != '') {
    
50. $dsql->Execute("me", "Select aid From `dede_taglist` where tid in($tid) And arcrank > -1 group by aid order by aid desc limit 0, $row");
    
51. while ($arow = $dsql->GetArray("me")) {
    
52. $ids[] = $arow['aid'];
    
53. $arcid = $refObj->Fields['aid'];
    
54. }
    
55. }
    
56. }
    
57. $typeid = (!empty($mytypeid) ? $mytypeid : ' And arc.id<>'.$arcid.' ');
    
58. if ($eregtype == 'tag' && count($ids) == 0) {
    
59. return '';
    
60. } else {
    
61. if (count($ids) > 0) {
    
62. /* if (!empty($typeid)) {
    
63. $typeid = " And arc.typeid in($typeid) And arc.id<>$arcid ";
    
64. }*/
    
65. $idsStr = join(',', $ids);
    
66. $query = "Select arc.*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,tp.namerule,
    
67. tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath
    
68. from `dede_archives` arc left join `dede_arctype` tp on arc.typeid=tp.id
    
69. where arc.id in($idsStr) $typeid order by arc.id desc";
    
70. }else{
    
71. 
    
72. $limitRow = $row - count($ids);
    
73. $keyword = '';
    
74. if (!empty($refObj->Fields['keywords'])) {
    
75. $keywords = explode(',', trim($refObj->Fields['keywords']));
    
76. $keyword = '';
    
77. $n = 1;
    
78. foreach ($keywords as $k) {
    
79. if ($n > 3)
    
80. break;
    
81. 
    
82. if (trim($k) == '')
    
83. continue;
    
84. else
    
85. $k = addslashes($k);
    
86. 
    
87. $keyword .= ($keyword == '' ? " CONCAT(arc.keywords,' ',arc.title) like '%$k%' " : " OR CONCAT(arc.keywords,' ',arc.title) like '%$k%' ");
    
88. $n++;
    
89. }
    
90. }
    
91. $arcid = (!empty($refObj->Fields['id']) ? $refObj->Fields['aid'] : 0);
    
92. if (empty($arcid) || $byabs == 0) {
    
93. $orderquery = " order by arc.id desc ";
    
94. } else {
    
95. $orderquery = " order by ABS(arc.id - " . $arcid . ") ";
    
96. }
    
97. if ($keyword != '') {
    
98. /* if (!empty($typeid)) {
    
99. $typeid = " And arc.typeid in($typeid) And arc.id<>$arcid ";
    
100. }*/
     
101. $query = "Select arc.*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,tp.namerule,
     
102. tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath
     
103. from `dede_archives` arc left join `dede_arctype` tp on arc.typeid=tp.id
     
104. where arc.arcrank>-1 and ($keyword) $typeid $orderquery limit 0, $row";
     
105. } else {
     
106. /* if (!empty($typeid)) {
     
107. $typeid = " arc.typeid in($typeid) And arc.id<>$arcid ";
     
108. }*/
     
109. $query = "Select arc.*,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,tp.namerule,
     
110. tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath
     
111. from `dede_archives` arc left join `dede_arctype` tp on arc.typeid=tp.id
     
112. where arc.arcrank>-1 and $typeid $orderquery limit 0, $row";
     
113. }
     
114. }
     
115. 
     
116. }
     
117. $innertext = trim($ctag->GetInnerText());
     
118. if ($innertext == '')
     
119. $innertext = GetSysTemplets('part_arclist.htm');
     
120. $dsql->SetQuery($query);
     
121. $dsql->Execute('al');
     
122. $artlist = '';
     
123. if ($col > 1) {
     
124. $artlist = "<table width='$tablewidth' border='0' cellspacing='0' cellpadding='0'>rn";
     
125. }
     
126. $dtp2 = new DedeTagParse();
     
127. $dtp2->SetNameSpace('field', '[', ']');
     
128. $dtp2->LoadString($innertext);
     
129. $GLOBALS['autoindex'] = 0;
     
130. $line = $row;
     
131. for ($i = 0; $i < $line; $i++) {
     
132. if ($col > 1)
     
133. $artlist .= "<tr>rn";
     
134. for ($j = 0; $j < $col; $j++) {
     
135. 
     
136. if ($col > 1)
     
137. $artlist .= " <td width='$colWidth'>rn";
     
138. if ($row = $dsql->GetArray("al")) {
     
139. $ids[] = $row['id'];
     
140. $row['info'] = $row['infos'] = cn_substr($row['description'], $infolen);
     
141. $row['id'] = $row['id'];
     
142. if ($row['corank'] > 0 && $row['arcrank'] == 0) {
     
143. $row['arcrank'] = $row['corank'];
     
144. }
     
145. $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']);
     
146. $row['typeurl'] = GetTypeUrl($row['typeid'], $row['typedir'], $row['isdefault'], $row['defaultname'], $row['ispart'], $row['namerule2'], $row['moresite'], $row['siteurl'], $row['sitepath']);
     
147. if ($row['litpic'] == '-' || $row['litpic'] == '') {
     
148. $row['litpic'] = $GLOBALS['cfg_cmspath'] . '/images/defaultpic.gif';
     
149. }
     
150. if (!eregi("^", $row['litpic']) && $GLOBALS['cfg_multi_site'] == 'Y') {
     
151. $row['litpic'] = $GLOBALS['cfg_mainsite'] . $row['litpic'];
     
152. }
     
153. $row['picname'] = $row['litpic'];
     
154. $row['stime'] = GetDateMK($row['pubdate']);
     
155. $row['typelink'] = "<a href='" . $row['typeurl'] . "'>" . $row['typename'] . "</a>";
     
156. $row['image'] = "<img src='" . $row['picname'] . "' border='0' width='$imgwidth' height='$imgheight' alt='" . ereg_replace("['><]", "", $row['title']) . "'>";
     
157. $row['imglink'] = "<a href='" . $row['filename'] . "'>" . $row['image'] . "</a>";
     
158. $row['fulltitle'] = $row['title'];
     
159. $row['title'] = cn_substr($row['title'], $titlelen);
     
160. if ($row['color'] != '')
     
161. $row['title'] = "<font color='" . $row['color'] . "'>" . $row['title'] . "</font>";
     
162. if (ereg('b', $row['flag']))
     
163. $row['title'] = "<strong>" . $row['title'] . "</strong>";
     
164. $row['textlink'] = "<a href='" . $row['filename'] . "'>" . $row['title'] . "</a>";
     
165. $row['plusurl'] = $row['phpurl'] = $GLOBALS['cfg_phpurl'];
     
166. $row['memberurl'] = $GLOBALS['cfg_memberurl'];
     
167. $row['templeturl'] = $GLOBALS['cfg_templeturl'];
     
168. 
     
169. if (is_array($dtp2->CTags)) {
     
170. foreach ($dtp2->CTags as $k => $ctag) {
     
171. if ($ctag->GetName() == 'array') {
     
172. $dtp2->Assign($k, $row);
     
173. } else {
     
174. if (isset($row[$ctag->GetName()]))
     
175. $dtp2->Assign($k, $row[$ctag->GetName()]);
     
176. else
     
177. $dtp2->Assign($k, '');
     
178. }
     
179. }
     
180. $GLOBALS['autoindex']++;
     
181. }
     
182. $artlist .= $dtp2->GetResult() . "rn";
     
183. } else {
     
184. $artlist .= '';
     
185. }
     
186. if ($col > 1)
     
187. $artlist .= " </td>rn";
     
188. }
     
189. if ($col > 1)
     
190. $i += $col - 1;
     
191. if ($col > 1)
     
192. $artlist .= " </tr>rn";
     
193. }
     
194. if ($col > 1)
     
195. $artlist .= " </table>rn";
     
196. $dsql->FreeResult("al");
     
197. return $artlist;
     
198. }
     
199. ?>

复制代码

用以上内容替换likearticle.lib.php的所有内容，这样调用出来的相关文章就相对完美了些，之所以说相对原因是修改后调用相关文章是优先匹配tag，如果tag能匹配到哪怕是匹配到一条就不会再去匹配关键词了，比如我想调用10条，该篇文章tag能匹配到一条，但是关键词能匹配20条，调用出来的效果也只有一条，我现在的做法是用两个标签tag和关键词分别调用5条，这样出来的效果稍微好些。标签调用代码如下：

1. {dede:likearticle row='5' col=1 titlelen='54' eregtype=tag}
   
2. <li><a href="[field:arcurl/]" title="[field:fulltitle/]">[field:title/]</a></li>
   
3. {/dede:likearticle}
   
4. {dede:likearticle row='5' col=1 titlelen='54' eregtype=keyword}
   
5. <li><a href="[field:arcurl/]" title="[field:fulltitle/]">[field:title/]</a></li>
   
6. {/dede:likearticle}

复制代码

不得不说
dedecms还是算不错的了，新手入门速度快，标签简单易懂，我做了好几个站都是用dedecms做的，最后希望dedecms越做越好，越来越完善吧！