本文整理汇总了PHP中jieqi_dbprefix函数的典型用法代码示例。如果您正苦于以下问题：PHP jieqi_dbprefix函数的具体用法？PHP jieqi_dbprefix怎么用？PHP jieqi_dbprefix使用的例子？那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了jieqi_dbprefix函数的20个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: jieqi_upbookcasevisit
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']);
}
}
开发者ID:thu0ng91，项目名称:jmc，代码行数:8，代码来源:readbookcase.php
示例2: setContent
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');
}
开发者ID:thu0ng91，项目名称:jmc，代码行数:56，代码来源:block_reviewslist.php
示例3: setContent
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);
}
开发者ID:thu0ng91，项目名称:jmc，代码行数:43，代码来源:block_commend.php
示例4: makefulltext
//.........这里部分代码省略.........
$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'));
}
}
开发者ID:thu0ng91，项目名称:jmc，代码行数:101，代码来源:package.php
示例5: jieqi_printfail
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');
开发者ID:thu0ng91，项目名称:jmc，代码行数:31，代码来源:newmessage.php
示例6: jieqi_loginprocess
/**
* 用户登录后处理
*
* @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);
//.........这里部分代码省略.........
开发者ID:thu0ng91，项目名称:jmc，代码行数:101，代码来源:checklogin.php
示例7: setContent
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;
//.........这里部分代码省略.........
开发者ID:thu0ng91，项目名称:jmc，代码行数:101，代码来源:block_articlelist.php
示例8: updatefields
/**
* 批量更新数据
*
* @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;
}
开发者ID:thu0ng91，项目名称:jmc，代码行数:36，代码来源:database.php
示例9: jieqi_dbprefix
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');
开发者ID:thu0ng91，项目名称:jmc，代码行数:31，代码来源:obookcase.php
示例10: jieqi_extractvars
$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'];
//减少电子书和章节积分
开发者ID:thu0ng91，项目名称:jmc，代码行数:31，代码来源:obookset.php
示例11: for
}
}
$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';
}
//页码
开发者ID:thu0ng91，项目名称:jmc，代码行数:31，代码来源:reviews.php
示例12: setContent
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']);
}
开发者ID:thu0ng91，项目名称:jmc，代码行数:83，代码来源:block_ubookcase.php
示例13: setContent
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'));
//.........这里部分代码省略.........
开发者ID:thu0ng91，项目名称:jmc，代码行数:101，代码来源:block_obooklist.php
示例14: jieqi_includedb
//°üº¬Îļþ
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 !== "..") {
开发者ID:thu0ng91，项目名称:jmc，代码行数:31，代码来源:step7.php
示例15: jieqi_loadlang
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) {
开发者ID:thu0ng |
客服电话
APP下载
官方微信
请发表评论