PHP jieqi_dbprefix函数代码示例

function jieqi_upbookcasevisit()
{
    if (!empty($_REQUEST['bid'])) {
        include_once $jieqiModules['article']['path'] . '/class/bookcase.php';
        $bookcase_handler =& JieqiBookcaseHandler::getInstance('JieqiBookcaseHandler');
        $bookcase_handler->db->query('UPDATE ' . jieqi_dbprefix('article_bookcase') . ' SET lastvisit=' . JIEQI_NOW_TIME . ' WHERE caseid=' . $_REQUEST['bid']);
    }
}

 function setContent($isreturn = false)
 {
     global $jieqiTpl;
     global $jieqiConfigs;
     jieqi_getconfigs('article', 'configs');
     $article_static_url = empty($jieqiConfigs['article']['staticurl']) ? $GLOBALS['jieqiModules']['article']['url'] : $jieqiConfigs['article']['staticurl'];
     $article_dynamic_url = empty($jieqiConfigs['article']['dynamicurl']) ? $GLOBALS['jieqiModules']['article']['url'] : $jieqiConfigs['article']['dynamicurl'];
     $jieqiTpl->assign('article_static_url', $article_static_url);
     $jieqiTpl->assign('article_dynamic_url', $article_dynamic_url);
     jieqi_includedb();
     $query = JieqiQueryHandler::getInstance('JieqiQueryHandler');
     $criteria = new CriteriaCompo();
     $criteria->setFields("r.*,a.articlename");
     $criteria->setTables(jieqi_dbprefix('article_reviews') . " AS r LEFT JOIN " . jieqi_dbprefix('article_article') . " AS a ON r.ownerid=a.articleid");
     if ($this->exevars['istop'] == 1) {
         $criteria->add(new Criteria('r.istop', '1'));
     } elseif ($this->exevars['istop'] == 2) {
         $criteria->add(new Criteria('r.istop', '0'));
     }
     if ($this->exevars['isgood'] == 1) {
         $criteria->add(new Criteria('r.isgood', '1'));
     } elseif ($this->exevars['isgood'] == 2) {
         $criteria->add(new Criteria('r.isgood', '0'));
     }
     $criteria->setSort('r.topicid');
     $criteria->setOrder('DESC');
     $criteria->setLimit($this->exevars['listnum']);
     $criteria->setStart(0);
     $query->queryObjects($criteria);
     $reviewrows = array();
     $i = 0;
     while ($v = $query->getObject()) {
         $reviewrows[$i]['reviewtitle'] = jieqi_htmlstr(str_replace(array("\r", "\n"), array('', ' '), $v->getVar('title', 'n')));
         $reviewrows[$i]['ownerid'] = $v->getVar('ownerid');
         $reviewrows[$i]['articlename'] = $v->getVar('articlename');
         $reviewrows[$i]['topicid'] = $v->getVar('topicid');
         $reviewrows[$i]['url_review'] = $article_dynamic_url . '/reviews.php?aid=' . $v->getVar('ownerid');
         $reviewrows[$i]['poster'] = $v->getVar('poster');
         $reviewrows[$i]['posterid'] = $v->getVar('posterid');
         $reviewrows[$i]['postdate'] = date('m-d H:i', $v->getVar('posttime'));
         $reviewrows[$i]['posttime'] = $v->getVar('posttime');
         $reviewrows[$i]['replytime'] = $v->getVar('replytime');
         $reviewrows[$i]['views'] = $v->getVar('views');
         $reviewrows[$i]['replies'] = $v->getVar('replies');
         $reviewrows[$i]['islock'] = $v->getVar('islock');
         $reviewrows[$i]['istop'] = $v->getVar('istop');
         $reviewrows[$i]['isgood'] = $v->getVar('isgood');
         $reviewrows[$i]['topictype'] = $v->getVar('topictype');
         $reviewrows[$i]['url_articleinfo'] = jieqi_geturl('article', 'article', $v->getVar('ownerid'), 'info');
         $reviewrows[$i]['url_articleindex'] = jieqi_geturl('article', 'article', $v->getVar('ownerid'), 'index');
         $reviewrows[$i]['url_articleread'] = $reviewrows[$i]['url_articleindex'];
         $i++;
     }
     $jieqiTpl->assign_by_ref('reviewrows', $reviewrows);
     $jieqiTpl->assign('url_more', $article_dynamic_url . '/reviewslist.php');
 }

 function setContent($isreturn = false)
 {
     global $jieqiTpl;
     global $jieqiConfigs;
     global $jieqiSort;
     include_once $GLOBALS['jieqiModules']['article']['path'] . '/class/article.php';
     //载入相关处理函数
     include_once $GLOBALS['jieqiModules']['article']['path'] . '/include/funarticle.php';
     jieqi_getconfigs('article', 'configs');
     jieqi_getconfigs('article', 'sort');
     $article_static_url = empty($jieqiConfigs['article']['staticurl']) ? $GLOBALS['jieqiModules']['article']['url'] : $jieqiConfigs['article']['staticurl'];
     $article_dynamic_url = empty($jieqiConfigs['article']['dynamicurl']) ? $GLOBALS['jieqiModules']['article']['url'] : $jieqiConfigs['article']['dynamicurl'];
     $jieqiTpl->assign('article_static_url', $article_static_url);
     $jieqiTpl->assign('article_dynamic_url', $article_dynamic_url);
     $articlerows = array();
     if (count($this->exevars) > 0) {
         $article_handler =& JieqiArticleHandler::getInstance('JieqiArticleHandler');
         $sql = 'SELECT * FROM ' . jieqi_dbprefix('article_article') . ' WHERE articleid IN (0,' . implode(',', $this->exevars) . ')';
         $sql .= ' LIMIT 0, 100';
         $res = $article_handler->db->query($sql);
         $k = 0;
         while ($v = $article_handler->getObject($res)) {
             $articlerows[$k] = jieqi_article_vars($v);
             $articlerows[$k]['order'] = $k + 1;
             $k++;
         }
     }
     $i = 0;
     $maxrow = count($articlerows);
     $sortrows = array();
     foreach ($this->exevars as $aid) {
         $k = 0;
         while ($k < $maxrow && $articlerows[$k]['articleid'] != $aid) {
             $k++;
         }
         if ($k < $maxrow) {
             $articlerows[$k]['order'] = $i + 1;
             $sortrows[$i] =& $articlerows[$k];
             $i++;
         }
     }
     $jieqiTpl->assign_by_ref('articlerows', $sortrows);
 }

//.........这里部分代码省略.........
             $indexrows[$idx]['cname' . $i] = $chapter['id'];
             $indexrows[$idx]['curl' . $i] = '#' . $chapterid;
             if ($i == $cols) {
                 $idx++;
                 $i = 0;
             }
             if (!empty($vname)) {
                 $tmpvar = $vname . ' ';
             } else {
                 $tmpvar = '';
             }
             $chapters[$n]['title'] = '<a name="' . $chapterid . '">' . $tmpvar . $chapter['id'] . '</a>';
             if (file_exists($txtdir . '/' . $chapterid . $jieqi_file_postfix['txt'])) {
                 $chapters[$n]['content'] = jieqi_htmlstr(jieqi_readfile($txtdir . '/' . $chapterid . $jieqi_file_postfix['txt']));
                 //使链接可点击
                 $patterns = array("/([^]_a-z0-9-=\"'\\/])([a-z]+?):\\/\\/([a-z0-9\\/\\-_+=.~!%@?#%&;:\$\\│]+)/i", "/([^]_a-z0-9-=\"'\\/])www\\.([a-z0-9\\-]+)\\.([a-z0-9\\/\\-_+=.~!%@?#%&;:\$\\│]+)/i", "/([^]_a-z0-9-=\"'\\/])ftp\\.([a-z0-9\\-]+)\\.([a-z0-9\\/\\-_+=.~!%@?#%&;:\$\\│]+)/i", "/([^]_a-z0-9-=\"'\\/:\\.])([a-z0-9\\-_\\.]+?)@([a-z0-9\\/\\-_+=.~!%@?#%&;:\$\\│]+)/i");
                 $replacements = array("\\1<a href=\"\\2://\\3\" target=\"_blank\">\\2://\\3</a>", "\\1<a href=\"http://www.\\2.\\3\" target=\"_blank\">www.\\2.\\3</a>", "\\1<a href=\"ftp://ftp.\\2.\\3\" target=\"_blank\">ftp.\\2.\\3</a>", "\\1<a href=\"mailto:\\2@\\3\">\\2@\\3</a>");
                 $chapters[$n]['content'] = preg_replace($patterns, $replacements, $chapters[$n]['content']);
             } else {
                 $chapters[$n]['content'] = '';
             }
             $attachurl = jieqi_uploadurl($jieqiConfigs['article']['attachdir'], $jieqiConfigs['article']['attachurl'], 'article') . jieqi_getsubdir($this->id) . '/' . $this->id . '/' . $chapterid;
             if (!$jieqiConfigs['article']['packdbattach']) {
                 //检查附件(从文件)
                 $attachdir = jieqi_uploadpath($jieqiConfigs['article']['attachdir'], 'article') . jieqi_getsubdir($this->id) . '/' . $this->id . '/' . $chapterid;
                 if (is_dir($attachdir)) {
                     $attachimage = '';
                     $attachfile = '';
                     $files = array();
                     $dirhandle = @opendir($attachdir);
                     while ($file = @readdir($dirhandle)) {
                         if ($file != '.' && $file != '..') {
                             $files[] = $file;
                         }
                     }
                     @closedir($dirhandle);
                     sort($files);
                     foreach ($files as $file) {
                         if (is_file($attachdir . '/' . $file)) {
                             $url = $attachurl . '/' . $file;
                             if (eregi("\\.(gif|jpg|jpeg|png|bmp)\$", $file)) {
                                 $attachimage .= '<div class="divimage" id="' . $file . '" title="' . $url . '"><a style="cursor: pointer;" onclick="imgclickshow(\'' . $file . '\', \'' . $url . '\')">' . $url . '</a>(' . ceil(filesize($attachdir . '/' . $file) / 1024) . 'K)</div>';
                             } else {
                                 $attachfile .= '<strong>file:</strong><a href="' . $url . '">' . $url . '</a>(' . ceil(filesize($attachdir . '/' . $file) / 1024) . 'K)<br /><br />';
                             }
                         }
                     }
                     if (!empty($attachimage) || !empty($attachfile)) {
                         if (!empty($chapters[$n]['content'])) {
                             $chapters[$n]['content'] .= '<br /><br />';
                         }
                         $chapters[$n]['content'] .= $attachimage . $attachfile;
                     }
                 }
             } else {
                 //检查附件，从数据库
                 global $package_query;
                 $sql = "SELECT attachment FROM " . jieqi_dbprefix('article_chapter') . " WHERE chapterid=" . intval($chapterid);
                 $res = $package_query->execute($sql);
                 $row = $package_query->db->fetchArray($res);
                 $attachary = array();
                 if (!empty($row['attachment'])) {
                     $attachary = unserialize($row['attachment']);
                 }
                 if (is_array($attachary) && count($attachary) > 0) {
                     $attachimage = '';
                     $attachfile = '';
                     foreach ($attachary as $attachvar) {
                         $url = $attachurl . '/' . $attachvar['attachid'] . '.' . $attachvar['postfix'];
                         if ($attachvar['class'] == 'image') {
                             $attachimage .= '<strong>image:</strong><a href="' . $url . '" target="_blank">' . $url . '</a>(' . ceil($attachvar['size'] / 1024) . 'K)<br /><br />';
                         } else {
                             $attachfile .= '<strong>file:</strong><a href="' . $url . '">' . $url . '</a>(' . ceil($attachvar['size'] / 1024) . 'K)<br /><br />';
                         }
                     }
                     if (!empty($attachimage) || !empty($attachfile)) {
                         if (!empty($chapters[$n]['content'])) {
                             $chapters[$n]['content'] .= '<br /><br />';
                         }
                         $chapters[$n]['content'] .= $attachimage . $attachfile;
                     }
                 }
             }
             $n++;
         }
     }
     $jieqiTpl->assign_by_ref('indexrows', $indexrows);
     $jieqiTpl->assign_by_ref('chapters', $chapters);
     $jieqiTpl->assign('articlesubdir', jieqi_getsubdir($this->id));
     $jieqiTpl->assign('url_articleinfo', jieqi_geturl('article', 'article', $this->id, 'info'));
     $jieqiTpl->assign('url_bookroom', ARTICLE_DYNAMIC_URL . '/');
     $jieqiTpl->setCaching(0);
     if ($show) {
         $jieqiTpl->display($GLOBALS['jieqiModules']['article']['path'] . '/templates/fulltext.html');
     } else {
         $htmldir = $this->getDir('fulldir', false);
         $jieqiTpl->assign('jieqi_charset', JIEQI_SYSTEM_CHARSET);
         jieqi_writefile($htmldir . '/' . $this->id . $jieqiConfigs['article']['htmlfile'], $jieqiTpl->fetch($GLOBALS['jieqiModules']['article']['path'] . '/templates/fulltext.html'));
     }
 }

         jieqi_printfail(sprintf($jieqiLang['system']['day_message_limit'], $maxdaymsg));
     }
 }
 include_once JIEQI_ROOT_PATH . '/header.php';
 //获得允许消息数和现有消息数
 jieqi_getconfigs('system', 'honors');
 jieqi_getconfigs(JIEQI_MODULE_NAME, 'right');
 $maxmessage = $jieqiConfigs['system']['messagelimit'];
 $honorid = jieqi_gethonorid($_SESSION['jieqiUserScore'], $jieqiHonors);
 if ($honorid && isset($jieqiRight['system']['maxmessages']['honors'][$honorid]) && is_numeric($jieqiRight['system']['maxmessages']['honors'][$honorid])) {
     $maxmessage = intval($jieqiRight['system']['maxmessages']['honors'][$honorid]);
 }
 //根据头衔设置的消息数
 include_once JIEQI_ROOT_PATH . '/class/message.php';
 $message_handler = JieqiMessageHandler::getInstance('JieqiMessageHandler');
 $sql = "SELECT COUNT(*) AS msgnum FROM " . jieqi_dbprefix('system_message') . " WHERE (fromid=" . $_SESSION['jieqiUserId'] . " AND fromdel=0) OR (toid=" . $_SESSION['jieqiUserId'] . " AND todel=0)";
 $res = $message_handler->db->query($sql);
 $row = $message_handler->getRow($res);
 $nowmessage = (int) $row['msgnum'];
 if ($nowmessage >= $maxmessage) {
     $jieqiTpl->setCaching(0);
     $jieqiTpl->assign('jieqi_contents', jieqi_msgbox($jieqiLang['system']['message_is_full'], $jieqiLang['system']['message_box_full']));
 } else {
     $jieqiTpl->assign('maxdaymsg', $maxdaymsg);
     $jieqiTpl->assign('nowmessage', $nowmessage);
     $jieqiTpl->assign('maxmessage', $maxmessage);
     $jieqiTpl->assign('url_newmessage', JIEQI_URL . '/newmessage.php?do=submit');
     $message = false;
     if (!empty($_REQUEST['reid']) || !empty($_REQUEST['fwid'])) {
         include_once JIEQI_ROOT_PATH . '/class/message.php';
         $message_handler = JieqiMessageHandler::getInstance('JieqiMessageHandler');

/**
 * 用户登录后处理
 * 
 * @param      object      $jieqiUsers 用户对象
 * @access     public
 * @return     bool
 */
function jieqi_loginprocess($jieqiUsers, $usecookie = 0)
{
    global $jieqiConfigs;
    global $jieqiHonors;
    global $jieqiGroups;
    if (!isset($jieqiConfigs['system'])) {
        jieqi_getconfigs('system', 'configs');
    }
    include_once JIEQI_ROOT_PATH . '/class/users.php';
    $users_handler =& JieqiUsersHandler::getInstance('JieqiUsersHandler');
    //更新在线用户表
    include_once JIEQI_ROOT_PATH . '/class/online.php';
    $online_handler =& JieqiOnlineHandler::getInstance('JieqiOnlineHandler');
    $criteria = new CriteriaCompo(new Criteria('uid', $jieqiUsers->getVar('uid', 'n')));
    $criteria->setSort('updatetime');
    $criteria->setOrder('DESC');
    $online_handler->queryObjects($criteria);
    $online = $online_handler->getObject();
    //读cookie信息
    $jieqi_user_info = array();
    if (!empty($_COOKIE['jieqiUserInfo'])) {
        $jieqi_user_info = jieqi_strtosary($_COOKIE['jieqiUserInfo']);
    } else {
        $jieqi_user_info = array();
    }
    $jieqi_visit_info = array();
    if (!empty($_COOKIE['jieqiVisitInfo'])) {
        $jieqi_visit_info = jieqi_strtosary($_COOKIE['jieqiVisitInfo']);
    } else {
        $jieqi_visit_info = array();
    }
    if (is_object($online)) {
        $ip = jieqi_userip();
        if (JIEQI_SESSION_EXPRIE > 0) {
            $exprie_time = JIEQI_SESSION_EXPRIE;
        } else {
            $exprie_time = @ini_get('session.gc_maxlifetime');
        }
        if (empty($exprie_time)) {
            $exprie_time = 1800;
        }
        if (defined('JIEQI_DENY_RELOGIN') && JIEQI_DENY_RELOGIN == 1 && JIEQI_NOW_TIME - $online->getVar('updatetime') < $exprie_time && $online->getVar('ip', 'n') != $ip && $jieqi_visit_info['jieqiUserId'] != $jieqiUsers->getVar('uid')) {
            return -8;
        }
        $tmpvar = strlen($jieqiUsers->getVar('name', 'q')) > 0 ? $jieqiUsers->getVar('name', 'q') : $jieqiUsers->getVar('uname', 'q');
        $sql = "UPDATE " . jieqi_dbprefix('system_online') . " SET uid=" . $jieqiUsers->getVar('uid', 'q') . ", sid='" . jieqi_dbslashes(session_id()) . "', uname='" . $jieqiUsers->getVar('uname', 'q') . "', name='" . $tmpvar . "', pass='" . $jieqiUsers->getVar('pass', 'q') . "',email='" . $jieqiUsers->getVar('email', 'q') . "', groupid=" . $jieqiUsers->getVar('groupid', 'q') . ", updatetime=" . JIEQI_NOW_TIME . ", ip='" . jieqi_dbslashes($ip) . "' WHERE uid=" . $jieqiUsers->getVar('uid', 'q') . " OR sid='" . jieqi_dbslashes(session_id()) . "'";
        $online_handler->db->query($sql);
    } else {
        include_once JIEQI_ROOT_PATH . '/include/visitorinfo.php';
        $online = $online_handler->create();
        $online->setVar('uid', $jieqiUsers->getVar('uid', 'n'));
        $online->setVar('siteid', JIEQI_SITE_ID);
        $online->setVar('sid', session_id());
        $online->setVar('uname', $jieqiUsers->getVar('uname', 'n'));
        $tmpvar = strlen($jieqiUsers->getVar('name', 'n')) > 0 ? $jieqiUsers->getVar('name', 'n') : $jieqiUsers->getVar('uname', 'n');
        $online->setVar('name', $tmpvar);
        $online->setVar('pass', $jieqiUsers->getVar('pass', 'n'));
        $online->setVar('email', $jieqiUsers->getVar('email', 'n'));
        $online->setVar('groupid', $jieqiUsers->getVar('groupid', 'n'));
        $tmpvar = JIEQI_NOW_TIME;
        $online->setVar('logintime', $tmpvar);
        $online->setVar('updatetime', $tmpvar);
        $online->setVar('operate', '');
        $tmpvar = VisitorInfo::getIp();
        $online->setVar('ip', $tmpvar);
        $online->setVar('browser', VisitorInfo::getBrowser());
        $online->setVar('os', VisitorInfo::getOS());
        $location = VisitorInfo::getIpLocation($tmpvar);
        if (JIEQI_SYSTEM_CHARSET == 'big5') {
            include_once JIEQI_ROOT_PATH . '/include/changecode.php';
            $location = jieqi_gb2big5($location);
        }
        $online->setVar('location', $location);
        $online->setVar('state', '0');
        $online->setVar('flag', '0');
        $online_handler->insert($online);
    }
    //删除过期的在线用户
    unset($criteria);
    $criteria = new CriteriaCompo(new Criteria('updatetime', JIEQI_NOW_TIME - $jieqiConfigs['system']['onlinetime'], '<'));
    $online_handler->delete($criteria);
    //检查短消息
    include_once JIEQI_ROOT_PATH . '/class/message.php';
    $message_handler = JieqiMessageHandler::getInstance('JieqiMessageHandler');
    $criteria = new CriteriaCompo(new Criteria('toid', $jieqiUsers->getVar('uid'), '='));
    $criteria->add(new Criteria('isread', 0, '='));
    $criteria->add(new Criteria('todel', 0, '='));
    $newmsgnum = $message_handler->getCount($criteria);
    unset($criteria);
    //有短消息
    //用户信息
    $previewlogin = intval($jieqiUsers->getVar('lastlogin'));
    $jieqiUsers->setVar('lastlogin', JIEQI_NOW_TIME);
//.........这里部分代码省略.........

 function setContent($isreturn = false)
 {
     global $jieqiTpl;
     global $jieqiConfigs;
     global $jieqiSort;
     include_once $GLOBALS['jieqiModules']['article']['path'] . '/class/article.php';
     //载入相关处理函数
     include_once $GLOBALS['jieqiModules']['article']['path'] . '/include/funarticle.php';
     jieqi_getconfigs('article', 'configs');
     jieqi_getconfigs('article', 'sort');
     $article_static_url = empty($jieqiConfigs['article']['staticurl']) ? $GLOBALS['jieqiModules']['article']['url'] : $jieqiConfigs['article']['staticurl'];
     $article_dynamic_url = empty($jieqiConfigs['article']['dynamicurl']) ? $GLOBALS['jieqiModules']['article']['url'] : $jieqiConfigs['article']['dynamicurl'];
     $jieqiTpl->assign('article_static_url', $article_static_url);
     $jieqiTpl->assign('article_dynamic_url', $article_dynamic_url);
     $tmpvar = explode('-', date('Y-m-d', JIEQI_NOW_TIME));
     $daystart = mktime(0, 0, 0, (int) $tmpvar[1], (int) $tmpvar[2], (int) $tmpvar[0]);
     $monthstart = mktime(0, 0, 0, (int) $tmpvar[1], 1, (int) $tmpvar[0]);
     $tmpvar = date('w', JIEQI_NOW_TIME);
     if ($tmpvar == 0) {
         $tmpvar = 7;
     }
     //星期天是0，国人习惯作为作为一星期的最后一天
     $weekstart = $daystart;
     if ($tmpvar > 1) {
         $weekstart -= ($tmpvar - 1) * 86400;
     }
     $article_handler =& JieqiArticleHandler::getInstance('JieqiArticleHandler');
     $sql = 'SELECT * FROM ' . jieqi_dbprefix('article_article') . ' WHERE display=0 AND size>0';
     if (!empty($this->exevars['sortid'])) {
         $sortstr = '';
         $sortnum = 0;
         $sortary = explode('|', $this->exevars['sortid']);
         foreach ($sortary as $v) {
             if (is_numeric($v)) {
                 if (!empty($sortstr)) {
                     $sortstr .= ' OR ';
                 }
                 $sortstr .= 'sortid=' . intval($v);
                 $sortnum++;
             }
         }
         if ($sortnum == 1) {
             $sql .= ' AND ' . $sortstr;
         } elseif ($sortnum > 1) {
             $sql .= ' AND (' . $sortstr . ')';
         }
     }
     if ($this->exevars['isauthor'] == 1) {
         $sql .= ' AND authorid>0';
     } elseif ($this->exevars['isauthor'] == 2) {
         $sql .= ' AND authorid=0';
     }
     if ($this->exevars['isfull'] == 1) {
         $sql .= ' AND fullflag=1';
     } elseif ($this->exevars['isfull'] == 2) {
         $sql .= ' AND fullflag=0';
     }
     //授权许可
     if (strlen($this->exevars['permission']) > 0) {
         $perstr = '';
         $pernum = 0;
         $perary = explode('|', $this->exevars['permission']);
         foreach ($perary as $v) {
             if (is_numeric($v)) {
                 if (!empty($perstr)) {
                     $perstr .= ' OR ';
                 }
                 $perstr .= 'permission=' . intval($v);
                 $pernum++;
             }
         }
         if ($pernum == 1) {
             $sql .= ' AND ' . $perstr;
         } elseif ($pernum > 1) {
             $sql .= ' AND (' . $perstr . ')';
         }
     }
     //是否首发
     if (strlen($this->exevars['firstflag']) > 0) {
         $sql .= ' AND firstflag=' . intval($this->exevars['firstflag']);
     }
     //状态标志
     if (strlen($this->exevars['power']) > 0) {
         $sql .= ' AND power=' . intval($this->exevars['power']);
     }
     switch ($this->exevars['field']) {
         case 'monthvisit':
             $sql .= ' AND lastvisit>=' . $monthstart;
             $sql .= ' ORDER BY ' . $this->exevars['field'];
             break;
         case 'monthvote':
             $sql .= ' AND lastvote>=' . $monthstart;
             $sql .= ' ORDER BY ' . $this->exevars['field'];
             break;
         case 'weekvisit':
             $sql .= ' AND lastvisit>=' . $weekstart;
             $sql .= ' ORDER BY ' . $this->exevars['field'];
             break;
         case 'weekvote':
             $sql .= ' AND lastvote>=' . $weekstart;
//.........这里部分代码省略.........

 /**
  * 批量更新数据
  *
  * @param      mixed       $fields 更新的字段，字符串或者数组
  * @param      object      $criteria 查询对象
  * @access     public
  * @return     bool
  */
 function updatefields($fields, $criteria = NULL)
 {
     $sql = 'UPDATE ' . jieqi_dbprefix($this->dbname, $this->fullname) . ' SET ';
     $start = true;
     if (is_array($fields)) {
         foreach ($fields as $k => $v) {
             if (!$start) {
                 $sql .= ', ';
             } else {
                 $start = false;
             }
             if (is_numeric($v)) {
                 $sql .= $k . '=' . $this->db->quoteString($v);
             } else {
                 $sql .= $k . '=' . $this->db->quoteString($v);
             }
         }
     } else {
         $sql .= $fields;
     }
     if (isset($criteria) && is_subclass_of($criteria, 'criteriaelement')) {
         $sql .= ' ' . $criteria->renderWhere();
     }
     if (!($result = $this->db->query($sql))) {
         return false;
     }
     return true;
 }

        if ($obookcase->getVar('userid') == $_SESSION['jieqiUserId']) {
            include_once $jieqiModules['obook']['path'] . '/class/obook.php';
            $obook_handler =& JieqiobookHandler::getInstance('JieqiobookHandler');
            $obook_handler->db->query('UPDATE ' . jieqi_dbprefix('obook_obook') . ' SET goodnum=goodnum-1 WHERE obookid=' . $obookcase->getVar('obookid', 'n'));
            $obookcase_handler->delete($_REQUEST['delid']);
        }
    }
    unset($obookcase);
}
//最大收藏数
$maxnum = $jieqiConfigs['obook']['bookcasenum'];
$jieqiTpl->assign('checkall', '<input type="checkbox" id="checkall" name="checkall" value="checkall" onclick="javascript: for (var i=0;i<this.form.elements.length;i++){ if (this.form.elements[i].name != \'checkkall\') this.form.elements[i].checked = form.checkall.checked; }">');
jieqi_includedb();
$obookcase_query = JieqiQueryHandler::getInstance('JieqiQueryHandler');
$criteria = new CriteriaCompo(new Criteria('c.userid', $_SESSION['jieqiUserId']));
$criteria->setTables(jieqi_dbprefix('obook_obookcase') . ' c LEFT JOIN ' . jieqi_dbprefix('obook_obook') . ' a ON c.obookid=a.obookid');
$criteria->setFields('c.*, a.obookid, a.articleid, a.lastupdate, a.obookname, a.lastchapterid, a.lastchapter');
$criteria->setSort('a.lastupdate');
$criteria->setOrder('DESC');
$obookcase_query->queryObjects($criteria);
unset($criteria);
$obookcaserows = array();
$k = 0;
while ($v = $obookcase_query->getObject()) {
    $obookcaserows[$k]['ocaseid'] = $v->getVar('ocaseid');
    $obookcaserows[$k]['checkbox'] = '<input type="checkbox" id="checkid[]" name="checkid[]" value="' . $v->getVar('oocaseid') . '">';
    $tmpvar = $v->getVar('obookname');
    if (!empty($tmpvar)) {
        $obookcaserows[$k]['url_obookinfo'] = $obook_dynamic_url . '/readbookcase.php?oid=' . $v->getVar('obookid') . '&bid=' . $v->getVar('ocaseid');
        $obookcaserows[$k]['url_index'] = $obookcaserows[$k]['url_obookinfo'] . '&indexflag=1';
        $obookcaserows[$k]['obookname'] = $v->getVar('obookname');

        $varstring = "<?php\n" . jieqi_extractvars('jieqiObookdata', $jieqiObookdata) . "\n?>";
        jieqi_writefile($linkfile, $varstring);
    }
} elseif ($_REQUEST['action'] == 'unsale') {
    $obook_handler->db->query('UPDATE ' . jieqi_dbprefix('obook_obook') . ' SET display=2 WHERE obookid=' . intval($_REQUEST['id']));
    $obook_handler->db->query('UPDATE ' . jieqi_dbprefix('obook_ochapter') . ' SET state=display, display=2 WHERE obookid=' . intval($_REQUEST['id']));
    if (!empty($linkfile) && file_exists($linkfile)) {
        global $jieqiObookdata;
        include_once $linkfile;
        $jieqiObookdata['obook']['display'] = 2;
        $varstring = "<?php\n" . jieqi_extractvars('jieqiObookdata', $jieqiObookdata) . "\n?>";
        jieqi_writefile($linkfile, $varstring);
    }
} elseif ($_REQUEST['action'] == 'delete') {
    $obook_handler->db->query('DELETE FROM ' . jieqi_dbprefix('obook_obook') . ' WHERE obookid=' . intval($_REQUEST['id']));
    $obook_handler->db->query('DELETE FROM ' . jieqi_dbprefix('obook_ochapter') . ' WHERE obookid=' . intval($_REQUEST['id']));
    if (!empty($linkfile) && file_exists($linkfile)) {
        jieqi_delfile($linkfile);
    }
}
//更新最新电子书
jieqi_getcachevars('obook', 'obookuplog');
if (!is_array($jieqiObookuplog)) {
    $jieqiObookuplog = array('obookuptime' => 0, 'chapteruptime' => 0);
}
$jieqiObookuplog['obookuptime'] = JIEQI_NOW_TIME;
jieqi_setcachevars('obookuplog', 'jieqiObookuplog', $jieqiObookuplog, 'obook');
jieqi_getconfigs(JIEQI_MODULE_NAME, 'configs');
$obook_static_url = empty($jieqiConfigs['obook']['staticurl']) ? $jieqiModules['obook']['url'] : $jieqiConfigs['obook']['staticurl'];
$obook_dynamic_url = empty($jieqiConfigs['obook']['dynamicurl']) ? $jieqiModules['obook']['url'] : $jieqiConfigs['obook']['dynamicurl'];
//减少电子书和章节积分

    			}
    		}
    		$sql='DELETE FROM '.jieqi_dbprefix('article_review').' WHERE '.$where;
    		$reviews_handler->db->query($sql);
    	}
    */
}
include_once JIEQI_ROOT_PATH . '/admin/header.php';
$jieqiTpl->assign('article_static_url', $article_static_url);
$jieqiTpl->assign('article_dynamic_url', $article_dynamic_url);
include_once JIEQI_ROOT_PATH . '/lib/text/textfunction.php';
$jieqiTpl->assign('url_review', $article_dynamic_url . '/admin/reviews.php');
$jieqiTpl->assign('checkall', '<input type="checkbox" id="checkall" name="checkall" value="checkall" onclick="javascript: for (var i=0;i<this.form.elements.length;i++){ if (this.form.elements[i].name != \'checkkall\') this.form.elements[i].checked = form.checkall.checked; }">');
$criteria = new CriteriaCompo();
$criteria->setFields("r.*,a.articlename");
$criteria->setTables(jieqi_dbprefix('article_reviews') . " AS r LEFT JOIN " . jieqi_dbprefix('article_article') . " AS a ON r.ownerid=a.articleid");
if (!empty($_REQUEST['keyword'])) {
    $_REQUEST['keyword'] = trim($_REQUEST['keyword']);
    if ($_REQUEST['keytype'] == 1) {
        $criteria->add(new Criteria('r.poster', $_REQUEST['keyword'], '='));
    } else {
        $criteria->add(new Criteria('a.articlename', $_REQUEST['keyword'], '='));
    }
}
if (isset($_REQUEST['type']) && $_REQUEST['type'] == 'good') {
    //精华书评
    $criteria->add(new Criteria('isgood', 1));
} else {
    $_REQUEST['type'] = 'all';
}
//页码

 function setContent($isreturn = false)
 {
     global $jieqiTpl;
     global $jieqiConfigs;
     jieqi_getconfigs('article', 'configs');
     jieqi_getconfigs('article', 'sort');
     $article_static_url = empty($jieqiConfigs['article']['staticurl']) ? $GLOBALS['jieqiModules']['article']['url'] : $jieqiConfigs['article']['staticurl'];
     $article_dynamic_url = empty($jieqiConfigs['article']['dynamicurl']) ? $GLOBALS['jieqiModules']['article']['url'] : $jieqiConfigs['article']['dynamicurl'];
     $jieqiTpl->assign('article_static_url', $article_static_url);
     $jieqiTpl->assign('article_dynamic_url', $article_dynamic_url);
     jieqi_includedb();
     $bookcase_query = JieqiQueryHandler::getInstance('JieqiQueryHandler');
     $criteria = new CriteriaCompo();
     $criteria->add(new Criteria('c.userid', intval($this->blockvars['cacheid'])));
     if ($this->exevars['flag'] == 1) {
         $criteria->add(new Criteria('flag', 1));
     } elseif ($this->exevars['flag'] == 2) {
         $criteria->add(new Criteria('flag', 0));
     }
     $criteria->setTables(jieqi_dbprefix('article_bookcase') . ' c LEFT JOIN ' . jieqi_dbprefix('article_article') . ' a ON c.articleid=a.articleid');
     $criteria->setFields('c.*, a.articleid, a.lastupdate, a.articlename, a.authorid, a.author, a.sortid, a.typeid, a.lastchapterid, a.lastchapter');
     $tmpary = array('articleid' => 'a.articleid', 'lastupdate' => 'a.lastupdate', 'caseid' => 'c.caseid', 'joindate' => 'c.joindate', 'lastvisit' => 'c.lastvisit');
     $criteria->setSort($tmpary[$this->exevars['field']]);
     if ($this->exevars['asc'] == 1) {
         $criteria->setOrder('ASC');
     } else {
         $criteria->setOrder('DESC');
     }
     $criteria->setLimit($this->exevars['listnum']);
     $criteria->setStart(0);
     $bookcase_query->queryObjects($criteria);
     unset($criteria);
     $bookcaserows = array();
     $k = 0;
     while ($v = $bookcase_query->getObject()) {
         $bookcaserows[$k]['caseid'] = $v->getVar('caseid');
         $bookcaserows[$k]['articleid'] = $v->getVar('articleid');
         $bookcaserows[$k]['lastchapterid'] = $v->getVar('lastchapterid');
         $bookcaserows[$k]['chapterid'] = $v->getVar('chapterid');
         $bookcaserows[$k]['sortid'] = $v->getVar('sortid');
         $bookcaserows[$k]['typeid'] = $v->getVar('typeid');
         $bookcaserows[$k]['sort'] = $jieqiSort['article'][$v->getVar('sortid')]['shortname'];
         $bookcaserows[$k]['type'] = $bookcaserows[$k]['sort'];
         //$bookcaserows[$k]['type']=$jieqiSort['article'][$v->getVar('sortid')]['types'][$v->getVar('typeid')];
         $bookcaserows[$k]['authorid'] = $v->getVar('authorid');
         $bookcaserows[$k]['author'] = $v->getVar('author');
         $bookcaserows[$k]['checkbox'] = '<input type="checkbox" id="checkid[]" name="checkid[]" value="' . $v->getVar('caseid') . '">';
         $tmpvar = $v->getVar('articlename');
         if (!empty($tmpvar)) {
             $bookcaserows[$k]['url_articleinfo'] = $article_dynamic_url . '/readbookcase.php?aid=' . $v->getVar('articleid') . '&bid=' . $v->getVar('caseid');
             $bookcaserows[$k]['url_index'] = $bookcaserows[$k]['url_articleinfo'] . '&indexflag=1';
             $bookcaserows[$k]['articlename'] = $v->getVar('articlename');
         } else {
             $bookcaserows[$k]['url_articleinfo'] = '#';
             $bookcaserows[$k]['url_index'] = '#';
             $bookcaserows[$k]['articlename'] = $jieqiLang['article']['articlemark_has_deleted'];
         }
         if ($v->getVar('lastchapter') == '') {
             $bookcaserows[$k]['lastchapter'] = '';
             $bookcaserows[$k]['url_lastchapter'] = '#';
         } else {
             $bookcaserows[$k]['lastchapter'] = $v->getVar('lastchapter');
             $bookcaserows[$k]['url_lastchapter'] = $article_dynamic_url . '/readbookcase.php?aid=' . $v->getVar('articleid') . '&bid=' . $v->getVar('caseid') . '&cid=' . $v->getVar('lastchapterid');
         }
         if ($v->getVar('lastupdate') > $v->getVar('lastvisit')) {
             $bookcaserows[$k]['hasnew'] = 1;
         } else {
             $bookcaserows[$k]['hasnew'] = 0;
         }
         if ($v->getVar('chaptername') == '') {
             $bookcaserows[$k]['articlemark'] = '';
             $bookcaserows[$k]['url_articlemark'] = '#';
         } else {
             $bookcaserows[$k]['articlemark'] = $v->getVar('chaptername');
             $bookcaserows[$k]['url_articlemark'] = $article_dynamic_url . '/readbookcase.php?aid=' . $v->getVar('articleid') . '&bid=' . $v->getVar('caseid') . '&cid=' . $v->getVar('chapterid');
         }
         $bookcaserows[$k]['lastupdate'] = $v->getVar('lastupdate');
         $bookcaserows[$k]['url_delete'] = jieqi_addurlvars(array('delid' => $v->getVar('caseid')));
         $k++;
     }
     $jieqiTpl->assign_by_ref('bookcaserows', $bookcaserows);
     $jieqiTpl->assign('ownerid', $this->blockvars['cacheid']);
 }

 function setContent($isreturn = false)
 {
     global $jieqiTpl;
     global $jieqiConfigs;
     global $jieqiSort;
     include_once $GLOBALS['jieqiModules']['obook']['path'] . '/class/obook.php';
     jieqi_getconfigs('obook', 'configs');
     $obook_static_url = empty($jieqiConfigs['obook']['staticurl']) ? $GLOBALS['jieqiModules']['obook']['url'] : $jieqiConfigs['obook']['staticurl'];
     $obook_dynamic_url = empty($jieqiConfigs['obook']['dynamicurl']) ? $GLOBALS['jieqiModules']['obook']['url'] : $jieqiConfigs['obook']['dynamicurl'];
     $jieqiTpl->assign('obook_static_url', $obook_static_url);
     $jieqiTpl->assign('obook_dynamic_url', $obook_dynamic_url);
     $tmpvar = explode('-', date('Y-m-d', JIEQI_NOW_TIME));
     $daystart = mktime(0, 0, 0, (int) $tmpvar[1], (int) $tmpvar[2], (int) $tmpvar[0]);
     $monthstart = mktime(0, 0, 0, (int) $tmpvar[1], 1, (int) $tmpvar[0]);
     $tmpvar = date('w', JIEQI_NOW_TIME);
     if ($tmpvar == 0) {
         $tmpvar = 7;
     }
     //星期天是0，国人习惯作为作为一星期的最后一天
     $weekstart = $daystart;
     if ($tmpvar > 1) {
         $weekstart -= ($tmpvar - 1) * 86400;
     }
     $obook_handler =& JieqiObookHandler::getInstance('JieqiObookHandler');
     $sql = 'SELECT * FROM ' . jieqi_dbprefix('obook_obook') . ' WHERE display=0 AND size>0';
     if (!empty($this->exevars['sortid'])) {
         $sortstr = '';
         $sortnum = 0;
         $sortary = explode('|', $this->exevars['sortid']);
         foreach ($sortary as $v) {
             if (is_numeric($v)) {
                 if (!empty($sortstr)) {
                     $sortstr .= ' OR ';
                 }
                 $sortstr .= 'sortid=' . intval($v);
                 $sortnum++;
             }
         }
         if ($sortnum == 1) {
             $sql .= ' AND ' . $sortstr;
         } elseif ($sortnum > 1) {
             $sql .= ' AND (' . $sortstr . ')';
         }
     }
     if (isset($this->exevars['publishid']) && $this->exevars['publishid'] !== '') {
         $publishstr = '';
         $publishnum = 0;
         $publishary = explode('|', $this->exevars['publishid']);
         foreach ($publishary as $v) {
             if (is_numeric($v)) {
                 if (!empty($publishstr)) {
                     $publishstr .= ' OR ';
                 }
                 $publishstr .= 'publishid=' . intval($v);
                 $publishnum++;
             }
         }
         if ($publishnum == 1) {
             $sql .= ' AND ' . $publishstr;
         } elseif ($publishnum > 1) {
             $sql .= ' AND (' . $publishstr . ')';
         }
     }
     if ($this->exevars['isfull'] == 1) {
         $sql .= ' AND fullflag=1';
     } elseif ($this->exevars['isfull'] == 2) {
         $sql .= ' AND fullflag=0';
     }
     switch ($this->exevars['field']) {
         case 'monthsale':
             $sql .= ' AND lastsale>=' . $monthstart;
             break;
         case 'weeksale':
             $sql .= ' AND lastsale>=' . $weekstart;
             break;
         case 'daysale':
             $sql .= ' AND lastsale>=' . $daystart;
             break;
     }
     $sql .= ' ORDER BY ' . $this->exevars['field'];
     if ($this->exevars['asc'] == 1) {
         $sql .= ' ASC';
     } else {
         $sql .= ' DESC';
     }
     $sql .= ' LIMIT 0, ' . $this->exevars['listnum'];
     $res = $obook_handler->db->query($sql);
     jieqi_getconfigs('obook', 'sort');
     $obookrows = array();
     $k = 0;
     while ($v = $obook_handler->getObject($res)) {
         $obookrows[$k]['order'] = $k + 1;
         $obookrows[$k]['obookid'] = $v->getVar('obookid');
         //文章序号
         $obookrows[$k]['obookname'] = $v->getVar('obookname');
         //文章名称
         $obookrows[$k]['articleid'] = $v->getVar('articleid');
         //文章序号
         if ($jieqiConfigs['obook']['fakeinfo'] == 1) {
             $obookrows[$k]['obooksubdir'] = jieqi_getsubdir($v->getVar('obookid'));
//.........这里部分代码省略.........

//°üº¬Îļþ
require_once '../global.php';
include_once JIEQI_ROOT_PATH . '/' . JIEQI_MODULE_NAME . '/lang/language.php';
include_once JIEQI_ROOT_PATH . '/' . JIEQI_MODULE_NAME . '/header.php';
$jieqiTpl->assign('step_title', $jieqiLang[JIEQI_MODULE_NAME]['step' . CURRENT_STEP . '_title']);
$jieqiTpl->assign('step_summary', $jieqiLang[JIEQI_MODULE_NAME]['step' . CURRENT_STEP . '_summary']);
$jieqiTpl->assign('next_page', 'step' . (CURRENT_STEP + 1) . '.php');
$jieqiTpl->assign('current_step', CURRENT_STEP);
//¼ì²éÒÑ°²×°Ä£¿é
//°üº¬Êý¾Ý¿âÀà
jieqi_includedb();
$inmodules = array();
$db_query = JieqiQueryHandler::getInstance('JieqiQueryHandler');
$res = $db_query->execute("SHOW TABLES LIKE '" . jieqi_dbprefix('system_modules') . "'");
if ($db_query->getRow($res)) {
    $res = $db_query->execute('SELECT * FROM ' . jieqi_dbprefix('system_modules'));
    $inmodules = array();
    if ($res) {
        $inmodules[] = 'system';
        while ($row = $db_query->getRow($res)) {
            $inmodules[] = $row['name'];
        }
    }
}
//¼ì²â°²×°Îļþ
$i = 0;
$sql_dir = 'sql';
$mod_array = array();
$jieqiDir = dir($sql_dir);
while ($mod_dir = $jieqiDir->read()) {
    if (is_dir($sql_dir . '/' . $mod_dir) && $mod_dir !== "." && $mod_dir !== "..") {

    exit;
}
jieqi_loadlang('share', JIEQI_MODULE_NAME);
jieqi_getconfigs(JIEQI_MODULE_NAME, 'publisher');
jieqi_getconfigs(JIEQI_MODULE_NAME, 'configs');
$obook_static_url = empty($jieqiConfigs['obook']['staticurl']) ? $jieqiModules['obook']['url'] : $jieqiConfigs['obook']['staticurl'];
$obook_dynamic_url = empty($jieqiConfigs['obook']['dynamicurl']) ? $jieqiModules['obook']['url'] : $jieqiConfigs['obook']['dynamicurl'];
include_once $jieqiModules['obook']['path'] . '/class/obook.php';
$obook_handler =& JieqiObookHandler::getInstance('JieqiObookHandler');
include_once JIEQI_ROOT_PATH . '/admin/header.php';
$jieqiTpl->assign('obook_static_url', $obook_static_url);
$jieqiTpl->assign('obook_dynamic_url', $obook_dynamic_url);
jieqi_getconfigs(JIEQI_MODULE_NAME, 'sort');
jieqi_getconfigs(JIEQI_MODULE_NAME, 'publisher');
//计算总销售额
$sql = "SELECT sum(sumegold) as totalegold, sum(sumesilver) as totalesilver FROM " . jieqi_dbprefix('obook_obook') . " WHERE publishid='" . intval($_SESSION['jieqiPublishid']) . "'";
$res = $obook_handler->db->query($sql);
$totalrow = $obook_handler->db->fetchArray($res);
$jieqiTpl->assign('totalegold', $totalrow['totalegold']);
$jieqiTpl->assign('totalesilver', $totalrow['totalesilver']);
$jieqiTpl->assign('totalemoney', $totalrow['totalegold'] + $totalrow['totalesilver']);
//页码
if (empty($_REQUEST['page']) || !is_numeric($_REQUEST['page'])) {
    $_REQUEST['page'] = 1;
}
$criteria = new CriteriaCompo();
if (!empty($_REQUEST['keyword'])) {
    $_REQUEST['keyword'] = trim($_REQUEST['keyword']);
    if ($_REQUEST['keytype'] == 1) {
        $criteria->add(new Criteria('author', $_REQUEST['keyword'], '='));
    } elseif ($_REQUEST['keytype'] == 2) {