How does DEDECMS call the number of article comments?-DEDECMS-php.cn

How does DEDECMS call the number of article comments?

藏色散人

Release： 2019-11-19 10:41:38

Original

1918 people have browsed it

How does DEDECMS call the number of article comments?

Dreamweaver DEDECMS calls the number of comments on an article

Dreamweaver DEDECMS wants to call the number of comments on an article, you must modify the data table (dede_archives) and add a field Used to store the number of comments on this article, and then call the value of this field.

Recommended learning: dedecms tutorial

Solution:

dede_archives 添加postcount int(10) UNSIGNED default 0

Copy after login

Then open plus\feedback.php and find about 220

//保存评论内容  
if($comtype == &#39;comments&#39;)  
{  
$arctitle = addslashes($title);  
if($msg!=&#39;&#39;)  
{  
$inquery = "INSERT INTO `cmsxx_feedback`(`aid`,`typeid`,`username`,
`arctitle`,`ip`,`ischeck`,`dtime`, `mid`,`bad`,`good`,`ftype`,`face`,`msg`)  
VALUES (&#39;$aid&#39;,&#39;$typeid&#39;,&#39;$username&#39;,&#39;$arctitle&#39;,&#39;$ip&#39;,&#39;$ischeck&#39;,&#39;$dtime&#39;,
 &#39;{$cfg_ml->M_ID}&#39;,&#39;0&#39;,&#39;0&#39;,&#39;$feedbacktype&#39;,&#39;$face&#39;,&#39;$msg&#39;); ";  
 
//插入位置1  
$rs = $dsql->ExecuteNoneQuery($inquery);  
if(!$rs)  
{  
echo $dsql->GetError();  
exit();  
}  
//插入位置2

Copy after login

Insert the content of position 1:

$rowc = $dsql->GetOne("Select count(*) as count from `dede_feedback` where aid =&#39;$aid&#39;");  
$pcount = $rowc [&#39;count&#39;];  
$inquery2 = "update `dede_archives` set postcount = &#39;$pcount&#39; where id = &#39;$aid&#39;";

Copy after login

Insert the content of position 2:

$rs = $dsql->ExecuteNoneQuery($inquery2); 
if(!$rs) 
{ 
echo $dsql->GetError(); 
exit(); 
}

Copy after login

The above is the detailed content of How does DEDECMS call the number of article comments?. For more information, please follow other related articles on the PHP Chinese website!