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';