尼玛博客评论合并脚本

<?php

$dbhost='127.0.0.1';

$dbname='tp';

$dbuser='root';

$dbpass='root';

date_default_timezone_set('PRC');

try{$pdo=new PDO('mysql:host='.$dbhost.';dbname='.$dbname,$dbuser,$dbpass);}catch(Exception $e){die('sqlsb');}

$rt=$pdo->query('SELECT * FROM `typecho_contents` LIMIT 20')->fetchAll(PDO::FETCH_ASSOC);

foreach($rt as $ttt){

$rr=$pdo->query('SELECT * FROM `typecho_comments` WHERE `cid`='.$ttt['cid'].' ORDER BY `coid` ASC')->fetchAll(PDO::FETCH_ASSOC);

$txt='

<br />

<div class="nima_comments">

';

foreach($rr as $rrr){

$txt.='<hr />

<div class="nima_comment" id="nima_comment_'.$rrr['coid'].'">

<span class="nima_comment_user">'.(empty($rrr['url'])?$rrr['author']:'<a href="'.$rrr['url'].'" target="_blank" rel="nofollow">'.$rrr['author'].'</a>').'</span>

'.(($rrr['created']==28800)?'':'在

<span class="nima_comment_time">'.date('Y/m/d H:i:s',$rrr['created']).'</span>

').(empty($rrr['parent'])?'评论':'<a href="#nima_comment_'.$rrr['parent'].'">回应</a>').'：

<br />

<span class="nima_comment_text">'.$rrr['text'].'</span>

</div>

';

}

$txt.='</div>

';

$ttt['text'].=$txt;

$pdo->exec('UPDATE `typecho_contents` SET `text`="'.addslashes($ttt['text']).'" WHERE `cid`='.$ttt['cid']);

}

?>

仅供参考