PHP jieqi_includedb函数代码示例

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

 * @package    article
 * @copyright  Copyright (c) Hangzhou Jieqi Network Technology Co.,Ltd. (http://www.jieqi.com)
 * @author     $Author: juny $
 * @version    $Id: package.php 339 2009-06-23 03:03:24Z juny $
 */
//需要更新静态文章信息页面的打包类
include_once JIEQI_ROOT_PATH . '/lib/xml/xml.php';
jieqi_getconfigs('article', 'configs');
if (!isset($jieqiConfigs['article']['packdbattach'])) {
    $jieqiConfigs['article']['packdbattach'] = 0;
}
if (!$jieqiConfigs['article']['packdbattach'] && preg_match('/^(ftps?):\\/\\/([^:\\/]+):([^:\\/]*)@([0-9a-z\\-\\.]+)(:(\\d+))?([0-9a-z_\\-\\/\\.]*)/is', $jieqiConfigs['article']['attachdir'])) {
    $jieqiConfigs['article']['packdbattach'] = 1;
}
if ($jieqiConfigs['article']['packdbattach']) {
    jieqi_includedb();
    $package_query = JieqiQueryHandler::getInstance('JieqiQueryHandler');
}
if (!empty($jieqiConfigs['article']['dynamicurl'])) {
    define('ARTICLE_DYNAMIC_URL', $jieqiConfigs['article']['dynamicurl']);
} else {
    define('ARTICLE_DYNAMIC_URL', $GLOBALS['jieqiModules']['article']['url']);
}
$article_dynamic_rooturl = ARTICLE_DYNAMIC_URL;
if (strpos($article_dynamic_rooturl, '/modules') > 0) {
    $article_dynamic_rooturl = substr($article_dynamic_rooturl, 0, strpos($article_dynamic_rooturl, '/modules'));
}
define('ARTICLE_DYNAMIC_ROOTURL', $article_dynamic_rooturl);
if (!empty($jieqiConfigs['article']['staticurl'])) {
    define('ARTICLE_STATIC_URL', $jieqiConfigs['article']['staticurl']);
} else {

/**
 * 帖子编辑后更新主题表
 * 
 * @param      array       $post_set 发帖信息设置
 * @param      string      $table 表名
 * @access     public
 * @return     bool
 */
function jieqi_topic_upedit(&$post_set, $table)
{
    global $query;
    if (!is_a($query, 'JieqiQueryHandler')) {
        jieqi_includedb();
        $query = JieqiQueryHandler::getInstance('JieqiQueryHandler');
    }
    $sql = "UPDATE " . $table . " SET title='" . jieqi_dbslashes($post_set['topictitle']) . "' WHERE topicid=" . intval($post_set['topicid']);
    return $query->execute($sql);
}

function article_make_stoplist($sort, $fid = 1, $tid = 0, $static = true, $output = false)
{
    global $jieqiConfigs;
    global $query;
    if (!isset($jieqiConfigs['article'])) {
        jieqi_getconfigs('article', 'configs');
    }
    if (empty($tid) && JIEQI_MAX_PAGES > 0) {
        $tid = JIEQI_MAX_PAGES;
    }
    if (empty($tid)) {
        if (!is_a($query, 'JieqiQueryHandler')) {
            jieqi_includedb();
            $query = JieqiQueryHandler::getInstance('JieqiQueryHandler');
        }
        $sql = "SELECT count(*) AS cot FROM " . jieqi_dbprefix('article_article') . " WHERE display=0 AND size>0";
        $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;
        }
        switch ($sort) {
            case 'monthvisit':
            case 'mouthvisit':
                $sql .= " AND lastvisit >= " . $monthstart;
                break;
            case 'weekvisit':
                $sql .= " AND lastvisit >= " . $weekstart;
                break;
            case 'dayvisit':
                $sql .= " AND lastvisit >= " . $daystart;
                break;
            case 'allauthorvisit':
                $sql .= " AND authorid > 0";
                break;
            case 'monthauthorvisit':
            case 'mouthauthorvisit':
                $sql .= " AND authorid > 0 AND lastvisit >= " . $monthstart;
                break;
            case 'weekauthorvisit':
                $sql .= " AND authorid > 0 AND lastvisit >= " . $weekstart;
                break;
            case 'dayauthorvisit':
                $sql .= " AND authorid > 0 AND lastvisit >= " . $daystart;
                break;
            case 'monthvote':
            case 'mouthvote':
                $sql .= " AND lastvote >= " . $monthstart;
                break;
            case 'weekvote':
                $sql .= " AND lastvote >= " . $weekstart;
                break;
            case 'dayvote':
                $sql .= " AND lastvote >= " . $daystart;
                break;
            case 'authorupdate':
                $sql .= " AND authorid > 0";
                break;
            case 'masterupdate':
                $sql .= " AND authorid = 0";
                break;
        }
        $query->execute($sql);
        if ($row = $query->getRow()) {
            $cot = intval($row['cot']);
            $pnum = intval($jieqiConfigs['article']['toppagenum']);
            if (empty($pnum)) {
                $pnum = 10;
            }
            $tid = ceil($cot / $pnum);
        }
        if ($tid < 1) {
            $tid = 1;
        }
    }
    if ($fid > $tid) {
        return false;
    }
    for ($page = $fid; $page <= $tid; $page++) {
        article_make_ptoplist($sort, $page, $static, $output);
    }
}

 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']);
 }

/**
 * 通用的点击统计处理
 * 
 * 先判断是否重复的点击、然后检查是否缓存点击，然后更新点击数
 * 
 * @param      int         $id 点击对象ID
 * @param      string      $table 点击对象表名
 * @param      string      $fieldstat 点击数的字段名
 * @param      string      $fieldid ID的字段名
 * @param      object      $query 查询对象，不存在会自动创建
 * @param      int         $addnum 每次点击加几个点击数，默认1
 * @access     public
 * @return     bool
 */
function jieqi_visit_stat($id, $table, $fieldstat, $fieldid, $query = NULL, $addnum = 1)
{
    if (jieqi_visit_valid($id, $table . '_' . $fieldstat)) {
        if ($ids = jieqi_visit_ids($id, $table . '_' . $fieldstat)) {
            global $query;
            if (!is_a($query, 'JieqiQueryHandler')) {
                jieqi_includedb();
                $query = JieqiQueryHandler::getInstance('JieqiQueryHandler');
            }
            foreach ($ids as $k => $v) {
                $v['visitnum'] = intval($v['visitnum'] * $addnum);
                $sql = 'UPDATE ' . $table . ' SET ' . $fieldstat . '=' . $fieldstat . '+' . $v['visitnum'] . ' WHERE ' . $fieldid . '=' . intval($k);
                $query->execute($sql);
            }
        }
        return true;
    } else {
        return false;
    }
}

/**
 * 本地用户注册，正式处理
 * 
 * @param      array       $params 参数数组
 * 必须参数： $params['username'] - 用户名,$params['password'] - 密码,$params['email'] - 邮箱
 * @access     public
 * @return     int    
 */
function jieqi_uregister_lprocess(&$params)
{
    global $jieqiConfigs;
    global $jieqiLang;
    global $query;
    global $users_handler;
    //载入参数设置
    if (!isset($jieqiConfigs['system'])) {
        jieqi_getconfigs('system', 'configs');
    }
    //载入语言包
    if (!isset($jieqiLang['system'])) {
        jieqi_loadlang('users', 'system');
    }
    //初始化查询类
    if (!is_a($query, 'JieqiQueryHandler')) {
        jieqi_includedb();
        $query = JieqiQueryHandler::getInstance('JieqiQueryHandler');
    }
    if (!is_a($users_handler, 'JieqiUsersHandler')) {
        include_once JIEQI_ROOT_PATH . '/class/users.php';
        $users_handler =& JieqiUsersHandler::getInstance('JieqiUsersHandler');
    }
    include_once JIEQI_ROOT_PATH . '/lib/text/textfunction.php';
    $newUser = $users_handler->create();
    $newUser->setVar('siteid', JIEQI_SITE_ID);
    $newUser->setVar('uname', $params['username']);
    $newUser->setVar('name', $params['nickname']);
    $newUser->setVar('pass', $users_handler->encryptPass($params['password']));
    $newUser->setVar('groupid', JIEQI_GROUP_USER);
    $newUser->setVar('regdate', JIEQI_NOW_TIME);
    $newUser->setVar('initial', jieqi_getinitial($params['username']));
    $newUser->setVar('sex', $params['sex']);
    $newUser->setVar('email', $params['email']);
    $newUser->setVar('url', $params['url']);
    $newUser->setVar('avatar', 0);
    $newUser->setVar('workid', 0);
    $newUser->setVar('qq', $params['qq']);
    $newUser->setVar('icq', '');
    $newUser->setVar('msn', $params['msn']);
    $newUser->setVar('mobile', '');
    $newUser->setVar('sign', '');
    $newUser->setVar('intro', '');
    $newUser->setVar('setting', '');
    $newUser->setVar('badges', '');
    $newUser->setVar('lastlogin', JIEQI_NOW_TIME);
    $newUser->setVar('showsign', 0);
    $newUser->setVar('viewemail', $params['viewemail']);
    $newUser->setVar('notifymode', 0);
    $newUser->setVar('adminemail', $params['adminemail']);
    $newUser->setVar('monthscore', 0);
    $newUser->setVar('experience', $jieqiConfigs['system']['scoreregister']);
    $newUser->setVar('score', $jieqiConfigs['system']['scoreregister']);
    $newUser->setVar('egold', 0);
    $newUser->setVar('esilver', 0);
    $newUser->setVar('credit', 0);
    $newUser->setVar('goodnum', 0);
    $newUser->setVar('badnum', 0);
    $newUser->setVar('isvip', 0);
    $newUser->setVar('overtime', 0);
    $newUser->setVar('state', 0);
    if (!$users_handler->insert($newUser)) {
        $params['uid'] = $newUser->getVar('uid', 'n');
        $params['error'] = $jieqiLang['system']['register_failure'];
        if ($params['return']) {
            return false;
        } else {
            jieqi_printfail($params['error']);
        }
    } else {
        //自动登录
        //记录注册时间IP
        if ($jieqiConfigs['system']['regtimelimit'] > 0) {
            $sql = "DELETE FROM " . jieqi_dbprefix('system_registerip') . " WHERE regtime<" . (JIEQI_NOW_TIME - ($jieqiConfigs['system']['regtimelimit'] > 72 ? $jieqiConfigs['system']['regtimelimit'] : 72) * 3600);
            $query->execute($sql);
            $sql = "INSERT INTO " . jieqi_dbprefix('system_registerip') . " (ip, regtime, count) VALUES ('" . jieqi_dbslashes($params['uip']) . "', '" . JIEQI_NOW_TIME . "', '0')";
            $query->execute($sql);
        }
        //更新在线用户表
        include_once JIEQI_ROOT_PATH . '/class/online.php';
        $online_handler =& JieqiOnlineHandler::getInstance('JieqiOnlineHandler');
        include_once JIEQI_ROOT_PATH . '/include/visitorinfo.php';
        $online = $online_handler->create();
        $online->setVar('uid', $newUser->getVar('uid', 'n'));
        $online->setVar('siteid', JIEQI_SITE_ID);
        $online->setVar('sid', session_id());
        $online->setVar('uname', $newUser->getVar('uname', 'n'));
        $tmpvar = strlen($newUser->getVar('name', 'n')) > 0 ? $newUser->getVar('name', 'n') : $newUser->getVar('uname', 'n');
        $online->setVar('name', $tmpvar);
        $online->setVar('pass', $newUser->getVar('pass', 'n'));
        $online->setVar('email', $newUser->getVar('email', 'n'));
        $online->setVar('groupid', $newUser->getVar('groupid', 'n'));
//.........这里部分代码省略.........

/**
 * 删除标签关联信息
 * 
 * @param      array      $tags 标签数组
 * @param      int        $articleid 关联ID
 * @param      array      $tables 标签相关数据表 array('tag'=>'', 'taglink'=>'', 'tagcache'=>'')
 * @access     public
 * @return     bool
 */
function jieqi_tag_delete($tags, $articleid, $tables)
{
    global $query;
    if (!is_a($query, 'JieqiQueryHandler')) {
        jieqi_includedb();
        $query = JieqiQueryHandler::getInstance('JieqiQueryHandler');
    }
    $articleid = intval($articleid);
    foreach ($tags as $tag) {
        $sql = "SELECT * FROM " . $tables['tag'] . " WHERE tagname = '" . jieqi_dbslashes($tag) . "' LIMIT 0,1";
        $query->execute($sql);
        if ($row = $query->getRow()) {
            $tagid = intval($row['tagid']);
            $sql = "DELETE FROM " . $tables['taglink'] . " WHERE tagid = " . $tagid . " AND articleid = " . $articleid;
            $query->execute($sql);
            if ($query->db->getAffectedRows() > 0) {
                $uptag = true;
                //最后一条关联记录
                if ($row['linknum'] <= 1) {
                    $sql = "SELECT count(*) as cot FROM " . $tables['taglink'] . " WHERE tagid = " . $tagid;
                    $query->execute($sql);
                    if ($row1 = $query->getRow()) {
                        if ($row1['cot'] == 0) {
                            $uptag = false;
                            $sql = "DELETE FROM " . $tables['tag'] . " WHERE tagid = " . $tagid;
                            $query->execute($sql);
                            $sql = "DELETE FROM " . $tables['tagcache'] . " WHERE tagid = " . $tagid;
                            $query->execute($sql);
                        }
                    }
                }
                if (!$uptag) {
                    $sql = "UPDATE " . $tables['tag'] . " SET linknum = linknum - 1 WHERE tagid = " . $tagid;
                    $query->execute($sql);
                    $sql = "SELECT * FROM " . $tables['tagcache'] . " WHERE tagid = " . $tagid . " LIMIT 0,1";
                    $query->execute($sql);
                    if ($row2 = $query->getRow()) {
                        $lids = explode(',', $row2['linkids']);
                        if (!in_array($articleid, $lids)) {
                            $lids[] = $articleid;
                            $sql = "UPDATE " . $tables['tagcache'] . " SET linkids = '" . jieqi_dbslashes(implode(',', $lids)) . "' WHERE tagid = " . $tagid;
                            $query->execute($sql);
                        }
                    }
                }
            }
        }
    }
    return true;
}