function GetArcList($atts, $refObj = '', $fields = array())
{
$rsArray = array();
$t1 = Exectime();
if (!$this->isQuery) {
$this->dsql->Execute('dlist', $this->sourceSql);
}
$i = 0;
while ($arr = $this->dsql->GetArray('dlist')) {
$i++;
/**
* 修改源代码
*
* 因为这里修改源码，对其他使用该类的地方不会产生什么影响
* 所以这里为了方便，直接对源码进行一定的修改
*
* 较好的方式是：继承该类并重写当前方法
*/
// 调用系统的helper帮助函数GetOneArchive()取回当前文档的所有信息，包括arcurl
$archive_row = GetOneArchive($arr['aid']);
// 将文档的arcurl信息放入$arr数组中，让其帮助我们把arcurl信息带到前台模板中去，供模板使用
$arr['arcurl'] = $archive_row['arcurl'];
$rsArray[$i] = $this->XSSClean($arr);
if ($i >= $this->pageSize) {
break;
}
}
$this->dsql->FreeResult('dlist');
$this->queryTime = Exectime() - $t1;
return $rsArray;
}
} else {
$baidunews = "<?xml version=\"1.0\" encoding=\"" . $cfg_soft_lang . "\" ?>\n";
$baidunews .= "<document>\n";
$baidunews .= "<webSite>{$cfg_webname} </webSite>\n";
$baidunews .= "<webMaster>{$cfg_adminemail} </webMaster>\n";
$baidunews .= "<updatePeri>{$cfg_updateperi} </updatePeri>\n";
$limit = $cfg_baidunews_limit;
if ($limit > 100 || $limit < 1) {
$limit = 100;
}
$query = "SELECT maintable.*, addtable.body, arctype.typename\r\n FROM #@__archives maintable\r\n LEFT JOIN #@__addonarticle addtable ON addtable.aid=maintable.id\r\n LEFT JOIN #@__arctype arctype ON arctype.ID=maintable.typeid\r\n WHERE maintable.channel=1 and maintable.arcrank!=-1 ORDER BY maintable.pubdate DESC LIMIT {$limit}\r\n ";
$dsql->SetQuery($query);
$dsql->Execute();
while ($row = $dsql->GetArray()) {
$title = dede_htmlspecialchars($row['title']);
$row1 = GetOneArchive($row['id']);
if (strpos($row1['arcurl'], 'http://') === false) {
$link = ($cfg_basehost == '' ? 'http://' . $_SERVER["HTTP_HOST"] . $cfg_cmspath : $cfg_basehost) . $row1['arcurl'];
} else {
$link = $row1['arcurl'];
}
$link = dede_htmlspecialchars($link);
$description = dede_htmlspecialchars(strip_tags($row['description']));
$text = dede_htmlspecialchars(strip_tags($row['body']));
$image = $row['litpic'] == '' ? '' : $row['litpic'];
if ($image != '' && strpos($image, 'http://') === false) {
$image = ($cfg_basehost == '' ? 'http://' . $_SERVER["HTTP_HOST"] . $cfg_cmspath : $cfg_basehost) . $image;
}
//$headlineimg = '';
$keywords = dede_htmlspecialchars($row['keywords']);
$category = dede_htmlspecialchars($row['typename']);
$dsql->ExecuteNoneQuery("Update `#@__archives` set scores=scores-{cfg_feedback_sub},badpost=badpost+1,lastpost='{$dtime}' where id='{$aid}' ");
} else {
if ($feedbacktype == 'good') {
$dsql->ExecuteNoneQuery("Update `#@__archives` set scores=scores+{$cfg_feedback_add},goodpost=goodpost+1,lastpost='{$dtime}' where id='{$aid}' ");
} else {
$dsql->ExecuteNoneQuery("Update `#@__archives` set scores=scores+1,lastpost='{$dtime}' where id='{$aid}' ");
}
}
//给用户增加积分
if ($cfg_ml->M_ID > 0) {
#api{{
if (defined('UC_API') && @(include_once DEDEROOT . '/api/uc.func.php')) {
//同步积分
uc_credit_note($cfg_ml->M_LoginID, $cfg_sendfb_scores);
//推送事件
$arcRow = GetOneArchive($aid);
$feed['icon'] = 'thread';
$feed['title_template'] = '<b>{username} 在网站发表了评论</b>';
$feed['title_data'] = array('username' => $cfg_ml->M_UserName);
$feed['body_template'] = '<b>{subject}</b><br>{message}';
$url = !strstr($arcRow['arcurl'], 'http://') ? $cfg_basehost . $arcRow['arcurl'] : $arcRow['arcurl'];
$feed['body_data'] = array('subject' => "<a href=\"" . $url . "\">{$arcRow['arctitle']}</a>", 'message' => cn_substr(strip_tags(preg_replace("/\\[.+?\\]/is", '', $msg)), 150));
$feed['images'][] = array('url' => $cfg_basehost . '/images/scores.gif', 'link' => $cfg_basehost);
uc_feed_note($cfg_ml->M_LoginID, $feed);
unset($arcRow);
}
#/aip}}
$dsql->ExecuteNoneQuery("Update `#@__member` set scores=scores+{$cfg_sendfb_scores} where mid='{$cfg_ml->M_ID}' ");
$row = $dsql->GetOne("SELECT COUNT(*) AS nums FROM `#@__feedback` WHERE `mid`='" . $cfg_ml->M_ID . "'");
$dsql->ExecuteNoneQuery("UPDATE `#@__member_tj` SET `feedback`='{$row['nums']}' WHERE `mid`='" . $cfg_ml->M_ID . "'");
}
<?php
require_once dirname(__FILE__) . "/../include/common.inc.php";
require_once DEDEINC . "/datalistcp.class.php";
/**
* 从数据库中获取点击数排名前10的电影
*/
$sql = "select id,title from dede_archives order by click desc limit 1,8";
$dsql->SetQuery($sql);
$result = $dsql->Execute();
$res = "";
$i = 1;
while ($row = $dsql->GetArray()) {
$archive_row = GetOneArchive($row['id']);
$res .= "<li class='hover'>\n\t<span>" . $i . "</span>\n\t<a href='" . $archive_row['arcurl'] . "' title='" . $row['title'] . "' target='_blank'>" . $row['title'] . "</a>\n\t</li>";
$i++;
}
echo 'document.write("' . $res . '");\\r\\n';
