Home >CMS Tutorial >DEDECMS >How does DEDECMS call the number of article comments?

How does DEDECMS call the number of article comments?

藏色散人
藏色散人Original
2019-11-19 10:41:381996browse

How does DEDECMS call the number of article comments?

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

Then open plus\feedback.php and find about 220

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

Insert the content of position 1:

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


Insert the content of position 2:

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

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn