/**
* 用户登录检查
*
*/
public function checklogin()
{
$this->_globals();
$_POST["username"] = strtolower($_POST["username"]);
$rs = $this->mCustomer->checkLogin();
if ($rs) {
$sql = "SELECT * FROM " . get_table("customers") . " WHERE email = '" . $_POST["username"] . "'";
$r = $this->mDb->getRow($sql);
if ($r["status"] == 1) {
$msg["status"] = "true";
$this->mCustomer->upHits($_SESSION["login_user"]["id"]);
$_SESSION["login_user"] = $r;
$msg["message"] = "登录成功";
$this->mLog->userLog("前台登录成功");
} else {
$msg["status"] = "false";
$msg["message"] = "您的邮箱还没有验证,请查看邮件进行验证";
}
} else {
$msg["status"] = "false";
$msg["message"] = "错误的用户名或密码";
$_SESSION["tmpuser"] = $_POST["username"];
}
echo json_encode($msg);
die;
}
/**
* 系统初始化
*/
private static function init()
{
set_exception_handler(array('AWS_APP', 'exception_handle'));
self::$config = load_class('core_config');
self::$db = load_class('core_db');
self::$plugins = load_class('core_plugins');
self::$settings = self::model('setting')->get_settings();
if ((!defined('G_SESSION_SAVE') or G_SESSION_SAVE == 'db') and get_setting('db_version') > 20121123) {
Zend_Session::setSaveHandler(new Zend_Session_SaveHandler_DbTable(array('name' => get_table('sessions'), 'primary' => 'id', 'modifiedColumn' => 'modified', 'dataColumn' => 'data', 'lifetimeColumn' => 'lifetime')));
self::$session_type = 'db';
}
Zend_Session::setOptions(array('name' => G_COOKIE_PREFIX . '_Session', 'cookie_domain' => G_COOKIE_DOMAIN));
if (G_SESSION_SAVE == 'file' and G_SESSION_SAVE_PATH) {
Zend_Session::setOptions(array('save_path' => G_SESSION_SAVE_PATH));
}
Zend_Session::start();
self::$session = new Zend_Session_Namespace(G_COOKIE_PREFIX . '_Anwsion');
if ($default_timezone = get_setting('default_timezone')) {
date_default_timezone_set($default_timezone);
}
if ($img_url = get_setting('img_url')) {
define('G_STATIC_URL', $img_url);
} else {
define('G_STATIC_URL', base_url() . '/static');
}
if (self::config()->get('system')->debug) {
if ($cornd_timer = self::cache()->getGroup('crond')) {
foreach ($cornd_timer as $cornd_tag) {
if ($cornd_runtime = self::cache()->get($cornd_tag)) {
AWS_APP::debug_log('crond', 0, 'Tag: ' . str_replace('crond_timer_', '', $cornd_tag) . ', Last run time: ' . date('Y-m-d H:i:s', $cornd_runtime));
}
}
}
}
}
public function defshow()
{
//检查登录
if (!$_SESSION["login_user"]) {
$_SESSION["fromurl"] = $_SERVER["HTTP_REFERER"];
header("Location: /user/login.html");
} else {
$this->result["login_user"] = $_SESSION["login_user"];
}
$this->result["sites"]["pagetitle"] = "课程设置";
$this->result["nav1"] = $this->mArt->getPidLists(7);
// 项目
$this->result["nav2"] = $this->mArt->getPidLists(10);
// 招生
$this->result["logout"] = $this->mClient->isOrLogin();
$this->result["sites"]["course"] = 'current';
$this->result["ads"]["indexlbanner"] = $this->mAd->getAd("indexlbanner", "list");
$sql1 = "select id,cname from " . get_table("art_cates") . " where pid = 14";
$info = $this->mDb->getall($sql1);
$this->result["info"] = $info;
$sql2 = "select c.id as cid,a.id as aid,a.title from sb_art_cates AS c,sb_articles AS a where c.id=a.class_id and c.id in (select id from sb_art_cates where pid = 14)";
$rs = $this->mDb->getall($sql2);
$this->result["rs"] = $rs;
$sql3 = "select id,cname from " . get_table("art_cates") . " where pid = 23";
$infos = $this->mDb->getall($sql3);
$this->result["infos"] = $infos;
$sql4 = "select c.id as cid,a.id as aid,a.title from sb_art_cates AS c,sb_articles AS a where c.id=a.class_id and c.id in (select id from sb_art_cates where pid = 23)";
$rse = $this->mDb->getall($sql4);
$this->result["rse"] = $rse;
$this->tplname = $_GET["lang"] . '/course';
}
public function batch()
{
$this->_globals();
//$rs = $this->mArticle->Batch();
$i = 0;
while ($i < count($_POST["selected"])) {
if ($_POST["more"] == "0") {
$sql = "DELETE FROM " . get_table("download") . " WHERE id=" . $_POST["selected"][$i];
} else {
$sql = "UPDATE " . get_table("download") . " SET class_id='" . $_POST["class_id"] . "' WHERE id=" . $_POST["selected"][$i];
}
$rs = $this->mDb->execute($sql);
$i++;
}
$this->mLog->adminLog("批量移动/删除内容");
/*if($rs)
{
$msg["status"] = "true";
}
else
{
$msg["false"] = "true";
$msg["message"] = "保存错误，请联系管理员";
}
echo json_encode($msg);*/
die;
}
function revert()
{
$this->build();
$sql = "SELECT * FROM " . get_table("backuplist") . " WHERE id=" . $_POST["dataid"];
$rs = $this->mDb->getrow($sql);
$path = $rs["path"] . $rs["filename"];
system("mysql -h " . _DB_HOST . " -u " . _DB_USER . " -p" . _DB_PASS . " " . _DB_NAME . " < " . $this->mPath . "/" . $rs["filename"]);
}
public function db_clean()
{
$users_columns = $this->query_all("SHOW COLUMNS FROM `" . get_table('users') . "`");
foreach ($users_columns as $key => $val) {
if (in_array($val['Field'], array('avatar_type', 'url'))) {
$this->query("ALTER TABLE `" . get_table('users') . "` DROP `" . $val['Field'] . "`;");
}
}
}
public function count_favorite_items($uid, $tag = null)
{
if ($tag) {
$favorite_items = $this->query_all('SELECT DISTINCT item_id FROM ' . get_table('favorite_tag') . ' WHERE uid = ' . intval($uid) . " AND title = '" . $this->quote($tag) . "'");
return sizeof($favorite_items);
} else {
return $this->count('favorite', 'uid = ' . intval($uid));
}
}
public function get_topics_by_feature_id($feature_id)
{
if (!($topics = $this->query_all('SELECT topic_id FROM ' . get_table('feature_topic') . ' WHERE feature_id = ' . intval($feature_id)))) {
return false;
}
foreach ($topics as $key => $val) {
$topic_ids[] = $val['topic_id'];
}
return $topic_ids;
}
public static function _saveAnswer($aid, $qid, $username, $content, $vote)
{
$a = get_table('answer');
$update = array('id' => $aid, 'q_id' => $qid, 'user' => $username, 'text' => $content, 'vote' => $vote, 'fetched' => time());
$where = array('id' => $aid);
$rs = $a->update($where, array('$set' => $update), array('upsert' => true));
if (!$rs['ok']) {
echo basename(__FILE__) . ':' . __LINE__ . ' ' . $rs['err'] . "\n";
}
return $rs;
}
public function savePost()
{
foreach ($_POST as $key => $val) {
$sql[] = $key . " = '{$val}'";
}
$sql = implode(",", $sql);
$sql = "UPDATE " . get_table("sites") . " SET {$sql} WHERE id=1";
$rs = $this->mDb->execute($sql);
$this->building();
return $rs;
}
public function pay_to_project_order_id($order_id, $project_product_order_id)
{
if (!($order_info = $this->get_order($order_id))) {
return false;
}
if (!($project_order_info = $this->model('project')->get_project_order_info_by_id($project_product_order_id))) {
return false;
}
$this->query("UPDATE " . get_table('project') . " SET paid = paid + " . $order_info['amount'] . " WHERE id = " . intval($project_order_info['project_id']));
return $this->set_order_payment_time($project_product_order_id);
}
public function update_dialog_count($dialog_id, $uid)
{
if (!($inbox_dialog = $this->get_dialog_by_id($dialog_id))) {
return false;
}
$this->update('inbox_dialog', array('sender_count' => $this->count('inbox', 'uid IN(' . $inbox_dialog['sender_uid'] . ', ' . $inbox_dialog['recipient_uid'] . ') AND sender_remove = 0 AND dialog_id = ' . intval($dialog_id)), 'recipient_count' => $this->count('inbox', 'uid IN(' . $inbox_dialog['sender_uid'] . ', ' . $inbox_dialog['recipient_uid'] . ') AND recipient_remove = 0 AND dialog_id = ' . intval($dialog_id)), 'update_time' => time()), 'id = ' . intval($dialog_id));
if ($inbox_dialog['sender_uid'] == $uid) {
$this->query("UPDATE " . get_table('inbox_dialog') . " SET recipient_unread = recipient_unread + 1 WHERE id = " . intval($dialog_id));
} else {
$this->query("UPDATE " . get_table('inbox_dialog') . " SET sender_unread = sender_unread + 1 WHERE id = " . intval($dialog_id));
}
}
public function search_users($q, $page, $limit = 20)
{
if (is_array($q) and sizeof($q) > 1) {
$where[] = "user_name = '" . $this->quote(implode(' ', $q)) . "' OR user_name = '" . $this->quote(implode('', $q)) . "'";
} else {
if (is_array($q)) {
$q = implode('', $q);
}
$where[] = "user_name LIKE '" . $this->quote($q) . "%'";
}
return $this->query_all('SELECT uid, last_login FROM ' . get_table('users') . ' WHERE ' . implode(' OR ', $where), calc_page_limit($page, $limit));
}
function get_reason($reason)
{
global $db, $L;
$str = '';
$arr = explode('|', $reason);
switch ($arr[0]) {
case 'deposit':
$str = $L['charge_reason_deposit'];
break;
case 'credit':
$str = $L['charge_reason_credit'];
break;
case 'vip':
$str = $L['charge_reason_vip'];
break;
case 'pay':
if (is_numeric($arr[1]) && is_numeric($arr[2])) {
$t = $db->get_one("SELECT title FROM " . get_table(intval($arr[1])) . " WHERE itemid=" . intval($arr[2]));
if ($t) {
$str = $t['title'];
}
}
break;
case 'trade':
if (is_numeric($arr[1])) {
$t = $db->get_one("SELECT title FROM " . $db->pre . "mall_order WHERE itemid=" . intval($arr[1]));
if ($t) {
$str = $t['title'];
}
}
break;
case 'trades':
$ids = explode(',', $arr[1]);
$t = $db->get_one("SELECT title FROM " . $db->pre . "group_order WHERE itemid=" . intval($ids[0]));
if ($t) {
$str = $L['charge_reason_muti'] . $t['title'] . '...';
}
break;
case 'group':
if (is_numeric($arr[1])) {
$t = $db->get_one("SELECT title FROM " . $db->pre . "group_order WHERE itemid=" . intval($arr[1]));
if ($t) {
$str = $t['title'];
}
}
break;
default:
break;
}
return $str;
}
private function check_dunning($bdname, $time, $status)
{
$sql = "select * from " . get_table($bdname) . " where etime >=now() and etime <='" . $time . "' and emailstatus<>" . $status;
$rs = $this->mDb->getall($sql);
foreach ($rs as $key => $value) {
$r = $this->getRow("customers", $value["uid"]);
$rs[$key]["email"] = $r["email"];
if ($value["emailstatus"] == $status - 1) {
if ($this->to_email($rs[$key]["email"], $status, $bdname)) {
$this->Update($bdname, $value["id"], " emailstatus =" . $status);
}
}
}
}
public function canceldomain()
{
$this->_globals();
$root = "/data/wwwroot/vhost/";
system("rm -f " . $root . $_POST["host"]);
$sql = "DELETE FROM " . get_table("domain") . " WHERE domain='" . $_POST["host"] . "'";
$rs = $this->mDb->execute($sql);
if ($rs == false) {
$msg["status"] = "false";
} else {
$msg["status"] = "true";
}
echo json_encode($msg);
die;
}
public function defshow()
{
$this->_globals();
include _APP_PATH . "libs/adodb/adodb-pager2.inc.php";
$r = $this->mBasic->getList("orderprodlist", array("uid = '" . $_SESSION["login_user"]["id"] . "'", " payflag != 2 "));
$payflag = $this->mOrder->getPayflagList();
foreach ($r["logs"] as $key => $val) {
$r["logs"][$key]["payflagname"] = $payflag[$val["payflag"]];
$r["logs"][$key]["infolist"] = $this->mDb->getall("SELECT * FROM " . get_table("orderprod") . " p ," . get_table("orderprodlist") . " o ," . get_table("products") . " pr WHERE p.oid=o.id AND p.pid = pr.id AND p.oid = '" . $val["id"] . "'");
$r["logs"][$key]["infos"] = $this->mDb->getall("SELECT * FROM " . get_table("orderprod") . " p ," . get_table("orderprodlist") . " o WHERE p.oid=o.id AND p.oid = '" . $val["id"] . "'");
}
$this->result["logs"] = $r["logs"];
$this->result["pages"] = $r["pages"];
$this->result["sites"]["pagetitle"] = "订单中心";
$this->tplname = 'orderlist';
}
public function savepost()
{
$this->_globals();
$password = md5($_POST["password"]);
$sql = "UPDATE " . get_table("customers") . " SET password = '******' WHERE id= '" . $_POST["id"] . "'";
$rs = $this->mDb->execute($sql);
if ($rs) {
$msg["status"] = "true";
$msg["message"] = "密码重设成功，请重新登录";
} else {
$msg["status"] = "false";
$msg["message"] = "密码重设失败，请稍后重试";
}
echo json_encode($msg);
die;
}
public function index_action()
{
$publisher_projects = $this->model('project')->query_all('SELECT id FROM ' . get_table('project') . ' WHERE uid = ' . intval($this->user_id));
if (!$publisher_projects) {
exit;
}
foreach ($publisher_projects as $value) {
$project_ids[] = $value['id'];
}
$order_list = $this->model('project')->fetch_all('product_order', 'project_id IN (' . implode(',', $project_ids) . ')', 'id ASC');
if (!$order_list) {
exit;
}
foreach ($order_list as $order_info) {
$uids[] = $order_info['uid'];
}
$users = $this->model('account')->get_user_info_by_uids($uids);
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setTitle('活动列表');
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', '活动 ID')->setCellValue('B1', '联系人')->setCellValue('C1', '报名时间')->setCellValue('D1', '手机号')->setCellValue('E1', '邮箱')->setCellValue('F1', '收货地址')->setCellValue('G1', '邮编')->setCellValue('H1', '支持金额')->setCellValue('I1', '状态');
$i = 1;
foreach ($order_list as $order_info) {
$i++;
$order_info['order_status'] = $this->model('project')->get_order_status($order_info);
switch ($order_info['order_status']) {
case 'pay':
$order_info['order_status'] = '未支付';
break;
case 'refunded':
$order_info['order_status'] = '已退款';
break;
case 'shipped':
$order_info['order_status'] = '已回报';
break;
case 'donate':
$order_info['order_status'] = '无需回报';
break;
default:
$order_info['order_status'] = '等待回报';
break;
}
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A' . $i, $order_info['project_id'] ?: '')->setCellValue('B' . $i, $order_info['shipping_name'] ?: '')->setCellValue('C' . $i, date('Y-m-d H:i:s', $order_info['add_time']) ?: '')->setCellValue('D' . $i, $order_info['shipping_mobile'] ?: '')->setCellValue('E' . $i, $order_info['project_type'] == 'DEFAULT' ? $users[$order_info['uid']]['email'] : $order_info['shipping_address'])->setCellValue('F' . $i, $order_info['project_type'] == 'DEFAULT' ? $order_info['shipping_province'] . $order_info['shipping_city'] . $order_info['shipping_address'] : $order_info['address'])->setCellValue('G' . $i, $order_info['shipping_zipcode'] ?: '')->setCellValue('H' . $i, $order_info['amount'] ?: '')->setCellValue('I' . $i, $order_info['order_status']);
}
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save('php://output');
exit;
}
public function online_active($uid, $last_active)
{
if (!$uid or $last_active + 60 > time()) {
return false;
}
$online_data = array('uid' => $uid, 'last_active' => time(), 'ip' => ip2long(fetch_ip()), 'user_agent' => $_SERVER['HTTP_USER_AGENT'], 'active_url' => $_SERVER['HTTP_REFERER']);
if ($user_online = $this->fetch_row('users_online', 'uid = ' . intval($uid))) {
$this->shutdown_update('users_online', $online_data, 'uid = ' . $user_online['uid']);
} else {
$this->insert('users_online', $online_data);
}
$online_time = time() - $last_active;
if ($online_time > 300) {
$online_time = 1;
}
$this->shutdown_query("UPDATE " . get_table('users') . ' SET online_time = online_time + ' . intval($online_time) . ', last_active = ' . time() . ' WHERE uid = ' . intval($uid));
return true;
}
public function slist()
{
$this->_globals();
$sql = "SELECT * FROM " . get_table("brands");
if ($_GET["keyword"]) {
$sql .= " WHERE cname LIKE '%" . $_GET["keyword"] . "%'";
}
//echo $sql;
$rs = $this->mDb->getall($sql);
if ($rs) {
foreach ($rs as $val) {
$str .= "<option value=\"" . $val["id"] . "\">" . $val["cname"] . "</option>";
}
} else {
$str = "<option value=\"\">无结果</option>";
}
echo $str;
die;
}
public function defshow()
{
$this->checkLogin();
$this->result["sites"]["dashboard"] = "selected";
$this->result["sites"]["title"] = "首页";
$rs = $this->mOrd->getNewList();
$this->result["statuslist"] = $this->mOrd->getStatusList();
$log["order_total"] = $this->mDb->getone("SELECT COUNT(*) FROM " . get_table("orders") . "");
$log["product_total"] = $this->mDb->getone("SELECT COUNT(*) FROM " . get_table("products") . "");
$log["product_warn_quantity"] = $this->mDb->getone("SELECT COUNT(*) FROM " . get_table("products") . " WHERE warn_quantity>=quantity");
$log["order_succeed"] = $this->mDb->getone("SELECT COUNT(*) FROM " . get_table("orders") . " WHERE status=6");
foreach ($rs as $key => $val) {
$rs[$key]["status"] = $this->result["statuslist"][$val["status"]];
}
$this->result["log"] = $log;
$this->result["logs"] = $rs;
$this->result["sites"]["url"] = encrypt("index");
$this->tplname = 'admin/index';
}
/**
* 数据定义 列表，编辑，添加时自动创建页面时用
*/
public static function get_table()
{
$tableinfo = get_table('user');
$keys = array('username', 'password', 'name', 'addr', 'tel', 'mobile', 'member_lv_id', 'grade', 'disabled');
$FromName = array('username' => '用户名', 'password' => '密码', 'name' => '姓名', 'grade' => '管理级别', 'mobile' => '手机', 'email' => '邮箱', 'remark' => '备注');
//$FromType['member_lv_id']=array('select',self:: get_member_lv());
$FromType['grade'] = array('select', self::get_grades());
//$FromType['disabled']=array('select',array('false'=>'启用','true'=>'停用'));
//$FromMsg['member_lv_id']='会员级别';
$FromMsg['username'] = '******';
$FromMsg['password'] = '******';
foreach ($tableinfo as $k => &$info) {
$info['FromType'] = $FromType[$k];
$info['FromMsg'] = $FromMsg[$k];
$info['FromName'] = $FromName[$k] ? $FromName[$k] : $k;
$info['FromView'] = in_array($k, $keys);
$info['size'] = substr($invo['Type'], 0, 7) == 'varchar';
}
return $tableinfo;
}
public function defshow()
{
$lang = $_GET["lang"] == 'cn' ? "1" : "3";
include _APP_PATH . "libs/adodb/adodb-pager" . $lang . ".inc.php";
$this->result["sites"]["pagetitle"] = "搜索";
$this->result["sites"]["en_pagetitle"] = "search";
$this->result["ads"]["indexlbanner"] = $this->mAd->getAd("indexlbanner", "list");
$this->tplname = $_GET["lang"] . '/search';
$_GET["lang"] = "cn";
$this->result["nav1"] = $this->mArt->getPidLists(7);
// 项目
$this->result["nav2"] = $this->mArt->getPidLists(10);
// 招生
$this->result["logout"] = $this->mClient->isOrLogin();
$keys = $_POST['search_name'];
$sql = "SELECT id,title,addtime,en_title FROM " . get_table("articles") . " where class_id !=17 and class_id !=18 and class_id !=19 and title like '%" . $keys . "%'";
$rs = $this->mDb->getAll($sql);
$this->result["rs"] = $rs;
$this->result["sites"]["news"] = 'current';
}
public function defshow()
{
$this->_globals();
//查询成功案例
//echo $_GET["id"];
$this->result["log"] = $this->mBasic->getRow("articles", $_GET["id"]);
if (!$this->result["log"] or $this->result["log"]['status'] == 0) {
$this->loadEorr();
}
//下一个
$this->result["log1"] = $this->mDb->getrow("SELECT * FROM " . get_table("articles") . " WHERE id > " . $_GET["id"] . " AND class_id = '46'");
//上一个
$this->result["log2"] = $this->mDb->getrow("SELECT * FROM " . get_table("articles") . " WHERE id < " . $_GET["id"] . " AND class_id = '46'");
$this->result["sites"]["pagetitle"] = $this->result["log"]["title"];
$this->result["aboutlogs"] = $this->mBasic->getNavList("articles", " class_id = '46' AND id != '" . $_GET["id"] . "'", 3);
//读取行业新闻
$this->result["news"] = $this->mArticle->getNavList(54, 6);
//读取广告
$this->result["teacher"] = $this->mAd->getAd("teacher");
$this->tplname = 'artile_detail';
}
function property_update($post_ppt, $moduleid, $catid, $itemid)
{
global $db;
if (!$post_ppt || !$moduleid || !$catid || !$itemid) {
return;
}
$OP = property_option($catid);
if (!$OP) {
return;
}
if (!defined('DT_ADMIN')) {
$post_ppt = dhtmlspecialchars($post_ppt);
}
$db->query("DELETE FROM {$db->pre}category_value WHERE moduleid={$moduleid} AND itemid={$itemid}");
$ppt = array();
foreach ($OP as $v) {
if ($v['type'] > 1 && $v['search']) {
$ppt[] = $v['oid'];
}
}
$pptword = '';
foreach ($post_ppt as $k => $v) {
if (in_array($k, $ppt)) {
if (is_array($v)) {
foreach ($v as $_v) {
$pptword .= 'O' . $k . ':' . $_v . ';';
}
} else {
$pptword .= 'O' . $k . ':' . $v . ';';
}
}
if (is_array($v)) {
$v = implode(',', $v);
}
$db->query("INSERT INTO {$db->pre}category_value (oid,moduleid,itemid,value) VALUES ('{$k}','{$moduleid}','{$itemid}','{$v}')");
}
if ($pptword) {
$db->query("UPDATE " . get_table($moduleid) . " SET pptword='{$pptword}' WHERE itemid={$itemid}");
}
}
public function getList($classid, $t, $lang, $size = 30)
{
if ($_GET["auditing"]) {
$t = $_GET["auditing"];
}
$sql = "SELECT * FROM " . get_table("goods") . " ORDER BY id DESC";
$pager = new Page();
$get_page = is_numeric($_GET["page"]) ? $get_page : 1;
$pagesize = $_GET["pagesize"] ? $_GET["pagesize"] : _PAGES;
$pager->Page($key = '', $pagesize, $groupsize = 0, $current = $get_page);
$pager->execute($this->mDb, $sql);
$pages['link'] = $pager->pageLinks();
$pages['fromto'] = $pager->fromto();
$pages['total'] = $pager->getTotalpage();
$pages['current'] = $pager->getCurrent();
$pages['totalnum'] = $pager->getTotalnum();
$pages['jump'] = $pager->jump();
$pages['pagenum'] = $pagesize;
$rs = $pager->getResult();
$r["logs"] = $rs;
$r["pages"] = $pages;
return $r;
}
public function fetch_answers_list_by_topic_ids($topic_ids, $page, $limit)
{
if (!is_array($topic_ids)) {
return false;
}
array_walk_recursive($topic_ids, 'intval_string');
$result_cache_key = 'reader_list_by_topic_ids_' . md5(implode('_', $topic_ids) . $page . $limit);
if (!($result = AWS_APP::cache()->get($result_cache_key))) {
$topic_relation_where[] = '`topic_id` IN(' . implode(',', $topic_ids) . ')';
$topic_relation_where[] = "`type` = 'question'";
if ($topic_relation_query = $this->query_all("SELECT item_id FROM " . get_table('topic_relation') . " WHERE " . implode(' AND ', $topic_relation_where))) {
foreach ($topic_relation_query as $key => $val) {
$question_ids[$val['item_id']] = $val['item_id'];
}
}
if (!$question_ids) {
return false;
}
$result = $this->fetch_all('answer', 'question_id IN (' . implode(',', $question_ids) . ') AND add_time > ' . (time() - 86400 * intval(get_setting('reader_questions_last_days'))) . ' AND agree_count >= ' . intval(get_setting('reader_questions_agree_count')), 'add_time DESC', calc_page_limit($page, $limit));
AWS_APP::cache()->set($result_cache_key, $result, get_setting('cache_level_low'));
}
return $result;
}
public function defshow()
{
$this->result["ads"]["indexlbanner"] = $this->mAd->getAd("indexlbanner", "list");
$this->tplname = $_GET["lang"] . '/artile';
$_GET["lang"] = "cn";
$this->result["log"] = $this->mArt->getRow($_GET["id"]);
if (!$this->result["log"]) {
$this->loadEorr();
}
$this->result["next"] = $_GET["id"] + 1;
$this->result["sites"]["en_pagetitle"] = $this->result["log"]["en_title"];
$this->result["sites"]["pagetitle"] = $this->result["log"]["title"];
//如果是新闻活动选项卡，显示创建时间
$sql = "SELECT id FROM " . get_table("articles") . " WHERE class_id=6 ";
$rs = $this->mDb->getall($sql);
foreach ($rs as $key => $val) {
$result[] = $val["id"];
}
if (in_array($_GET["id"], $result)) {
$this->result["news"] = 'news';
}
//师资力量处理
$sql = "SELECT id FROM " . get_table("articles") . " WHERE class_id = 31 ";
$r = $this->mDb->getall($sql);
foreach ($r as $key => $val) {
$rs[] = $val["id"];
}
if (in_array($_GET["id"], $rs)) {
$this->result["teacher"] = 'teacher';
}
$this->result["logout"] = $this->mClient->isOrLogin();
if ($_GET["id"] == 121) {
$this->result["sites"]["project"] = 'current';
}
$this->result["sites"][$_GET["cate"]] = 'current';
}
public function Update($table, $id, $set)
{
$sql = "UPDATE " . get_table($table) . " SET {$set} WHERE id={$id}";
$rs = $this->mDb->execute($sql);
}
