function do_iCMS($appid = 0) { iPHP::import(iPHP_APP_CORE . '/iAPP.class.php'); $this->categoryApp = iACP::app('category', 'all'); $this->category = $this->categoryApp->category; $sql = "WHERE 1=1"; if ($appid || $_GET['appid']) { $_GET['appid'] && ($appid = (int) $_GET['appid']); $sql .= " AND `appid`='{$appid}'"; } $_GET['iid'] && ($sql .= " AND `iid`='" . (int) $_GET['iid'] . "'"); isset($_GET['status']) && ($sql .= " AND `status`='" . $_GET['status'] . "'"); if ($_GET['cid']) { $cid = (int) $_GET['cid']; if (isset($_GET['sub'])) { $cids = $this->categoryApp->get_ids($cid, true); array_push($cids, $cid); $sql .= " AND cid IN(" . implode(',', $cids) . ")"; } else { $sql .= " AND cid ='{$cid}'"; } } $_GET['userid'] && ($sql .= " AND `userid`='" . (int) $_GET['userid'] . "'"); $_GET['ip'] && ($sql .= " AND `ip`='" . $_GET['ip'] . "'"); if ($_GET['keywords']) { $sql .= " AND CONCAT(username,title) REGEXP '{$_GET['keywords']}'"; } $maxperpage = $_GET['perpage'] > 0 ? (int) $_GET['perpage'] : 20; $total = iPHP::total(false, "SELECT count(*) FROM `#iCMS@__comment` {$sql}", "G"); iPHP::pagenav($total, $maxperpage, "条评论"); $rs = iDB::all("SELECT * FROM `#iCMS@__comment` {$sql} order by id DESC LIMIT " . iPHP::$offset . " , {$maxperpage}"); $_count = count($rs); include iACP::view("comment.manage"); }
function do_iCMS() { $filter = $this->setting->get(0, 'word.filter'); $disable = $this->setting->get(0, 'word.disable'); foreach ((array) $filter as $k => $val) { $filterArray[$k] = implode("=", (array) $val); } include iACP::view("filter"); }
function do_iCMS() { $res = iFS::folder('template', array('htm', 'css', 'js', 'png', 'jpg', 'gif')); $dirRs = $res['DirArray']; $fileRs = $res['FileArray']; $pwd = $res['pwd']; $parent = $res['parent']; $URI = $res['URI']; $navbar = true; $file_edit = true; include iACP::view("files.explorer"); }
function do_iCMS() { if ($_GET['keywords']) { $sql = " WHERE `keyword` REGEXP '{$_GET['keywords']}'"; } $orderby = $_GET['orderby'] ? $_GET['orderby'] : "id DESC"; $maxperpage = $_GET['perpage'] > 0 ? (int) $_GET['perpage'] : 20; $total = iPHP::total(false, "SELECT count(*) FROM `#iCMS@__keywords` {$sql}", "G"); iPHP::pagenav($total, $maxperpage, "个关键词"); $rs = iDB::all("SELECT * FROM `#iCMS@__keywords` {$sql} order by {$orderby} LIMIT " . iPHP::$offset . " , {$maxperpage}"); $_count = count($rs); include iACP::view("keywords.manage"); }
function do_iCMS() { if ($_GET['job']) { require_once iPHP_APP_CORE . '/iJob.class.php'; $job = new JOB(); } $sql = "WHERE 1=1"; //isset($this->type) && $sql.=" AND `type`='$this->type'"; $_GET['gid'] && ($sql .= " AND `gid`='{$_GET['gid']}'"); $orderby = $_GET['orderby'] ? $_GET['orderby'] : "uid DESC"; $maxperpage = $_GET['perpage'] > 0 ? (int) $_GET['perpage'] : 20; $total = iPHP::total(false, "SELECT count(*) FROM `#iCMS@__members` {$sql}", "G"); iPHP::pagenav($total, $maxperpage, "个用户"); $rs = iDB::all("SELECT * FROM `#iCMS@__members` {$sql} order by {$orderby} LIMIT " . iPHP::$offset . " , {$maxperpage}"); $_count = count($rs); include iACP::view("account.manage"); }
function do_manage() { $sql = " where 1=1"; $cid = (int) $_GET['cid']; $tcid = (int) $_GET['tcid']; $pid = (int) $_GET['pid']; $_GET['keywords'] && ($sql .= " AND CONCAT(name,seotitle,subtitle,keywords,description) REGEXP '{$_GET['keywords']}'"); $sql .= $this->categoryApp->search_sql($cid); $sql .= $this->tagcategory->search_sql($tcid, 'tcid'); isset($_GET['pic']) && ($sql .= " AND `haspic` ='" . ($_GET['pic'] ? 1 : 0) . "'"); if (isset($_GET['pid']) && $pid != '-1') { $uri_array['pid'] = $pid; if ($_GET['pid'] == 0) { $sql .= " AND `pid`=''"; } else { iPHP::import(iPHP_APP_CORE . '/iMAP.class.php'); map::init('prop', $this->appid); $map_where = map::where($pid); } } if ($map_where) { $map_sql = iCMS::map_sql($map_where); $sql = ",({$map_sql}) map {$sql} AND `id` = map.`iid`"; } $orderby = $_GET['orderby'] ? $_GET['orderby'] : "id DESC"; $maxperpage = $_GET['perpage'] > 0 ? (int) $_GET['perpage'] : 20; $total = iPHP::total(false, "SELECT count(*) FROM `#iCMS@__tags` {$sql}", "G"); iPHP::pagenav($total, $maxperpage, "个标签"); $limit = 'LIMIT ' . iPHP::$offset . ',' . $maxperpage; if ($map_sql || iPHP::$offset) { $ids_array = iDB::all("\n SELECT `id` FROM `#iCMS@__tags` {$sql}\n ORDER BY {$orderby} {$limit}\n "); //iDB::debug(1); $ids = iCMS::get_ids($ids_array); $ids = $ids ? $ids : '0'; $sql = "WHERE `id` IN({$ids})"; $limit = ''; } $rs = iDB::all("SELECT * FROM `#iCMS@__tags` {$sql} ORDER BY {$orderby} {$limit}"); $_count = count($rs); include iACP::view("tags.manage"); }
function do_iCMS() { //数据统计 $rs = iDB::all("SHOW FULL TABLES FROM `" . iPHP_DB_NAME . "` WHERE table_type = 'BASE TABLE';"); foreach ($rs as $k => $val) { if (strstr(iPHP_DB_PREFIX, $val['Tables_in_' . iPHP_DB_NAME]) === false) { $iTable[] = strtoupper($val['Tables_in_' . iPHP_DB_NAME]); } else { $oTable[] = $val['Tables_in_' . iPHP_DB_NAME]; } } $content_datasize = 0; $tables = iDB::all("SHOW TABLE STATUS"); $_count = count($tables); for ($i = 0; $i < $_count; $i++) { $tableName = strtoupper($tables[$i]['Name']); if (in_array($tableName, $iTable)) { $datasize += $tables[$i]['Data_length']; $indexsize += $tables[$i]['Index_length']; if (stristr(strtoupper(iPHP_DB_PREFIX . "article," . iPHP_DB_PREFIX . "category," . iPHP_DB_PREFIX . "comment," . iPHP_DB_PREFIX . "article_data"), $tableName)) { $content_datasize += $tables[$i]['Data_length'] + $tables[$i]['Index_length']; } } } $acc = iDB::value("SELECT count(*) FROM `#iCMS@__category` WHERE `appid`='" . iCMS_APP_ARTICLE . "'"); $tac = iDB::value("SELECT count(*) FROM `#iCMS@__category` WHERE `appid`='" . iCMS_APP_TAG . "'"); $pac = iDB::value("SELECT count(*) FROM `#iCMS@__category` WHERE `appid`='" . iCMS_APP_PUSH . "'"); $ac = iDB::value("SELECT count(*) FROM `#iCMS@__article`"); $ac0 = iDB::value("SELECT count(*) FROM `#iCMS@__article` WHERE `status`='0'"); $ac2 = iDB::value("SELECT count(*) FROM `#iCMS@__article` WHERE `status`='2'"); $ctc = iDB::value("SELECT count(*) FROM `#iCMS@__comment`"); $tc = iDB::value("SELECT count(*) FROM `#iCMS@__tags`"); $kc = iDB::value("SELECT count(*) FROM `#iCMS@__keywords`"); $pc = iDB::value("SELECT count(*) FROM `#iCMS@__push`"); $uc = iDB::value("SELECT count(*) FROM `#iCMS@__user`"); $fdc = iDB::value("SELECT count(*) FROM `#iCMS@__filedata`"); $lc = iDB::value("SELECT count(*) FROM `#iCMS@__links`"); include iACP::view("home"); }
<div class="input-prepend"> <span class="add-on">发送账号</span> <input type="text" name="config[mail][setfrom]" class="span3" id="mail_setfrom" value="<?php echo $config['mail']['setfrom']; ?> "/> </div> <span class="help-inline">用于发送邮件的账号</span> <div class="clearfloat mt10"></div> <div class="input-prepend"> <span class="add-on">联系Email</span> <input type="text" name="config[mail][replyto]" class="span3" id="mail_replyto" value="<?php echo $config['mail']['replyto']; ?> "/> </div> <span class="help-inline">用于邮件中回复Email的账号</span> <div class="clearfloat mt10"></div> </div> <?php include iACP::view("weixin.config"); ?> <div class="form-actions"> <button class="btn btn-primary" type="submit"><i class="fa fa-check"></i> 提交</button> </div> </div> </form> </div> </div> </div> <?php iACP::foot();
function do_iCMS() { $sql = " where 1=1"; // $cid = (int)$_GET['cid']; // // if($cid) { // $cids = $_GET['sub']?iCMS::get_category_ids($cid,true):$cid; // $cids OR $cids = $vars['cid']; // $sql.= iPHP::where($cids,'cid'); // } $_GET['field'] && ($sql .= " AND `field`='" . $_GET['field'] . "'"); $_GET['field'] && ($uri .= '&field=' . $_GET['field']); $_GET['type'] && ($sql .= " AND `type`='" . $_GET['type'] . "'"); $_GET['type'] && ($uri .= '&type=' . $_GET['type']); $_GET['cid'] && ($sql .= " AND `cid`='" . $_GET['cid'] . "'"); $_GET['cid'] && ($uri .= '&cid=' . $_GET['cid']); $maxperpage = $_GET['perpage'] > 0 ? (int) $_GET['perpage'] : 20; $total = iPHP::total(false, "SELECT count(*) FROM `#iCMS@__prop` {$sql}", "G"); iPHP::pagenav($total, $maxperpage, "个属性"); $rs = iDB::all("SELECT * FROM `#iCMS@__prop` {$sql} order by pid DESC LIMIT " . iPHP::$offset . " , {$maxperpage}"); $_count = count($rs); include iACP::view("prop.manage"); }
function do_iCMS() { $rs = iDB::all("SELECT * FROM `#iCMS@__group` ORDER BY `type` , `gid` ASC"); $_count = count($rs); include iACP::view("groups.manage"); }
function do_iCMS() { //iPHP::app('user.class','static'); $sql = "WHERE 1=1"; $pid = $_GET['pid']; if ($_GET['keywords']) { $sql .= " AND CONCAT(username,nickname) REGEXP '{$_GET['keywords']}'"; } $_GET['gid'] && ($sql .= " AND `gid`='{$_GET['gid']}'"); if (isset($_GET['status']) && $_GET['status'] !== '') { $sql .= " AND `status`='{$_GET['status']}'"; } $_GET['regip'] && ($sql .= " AND `regip`='{$_GET['regip']}'"); $_GET['loginip'] && ($sql .= " AND `lastloginip`='{$_GET['loginip']}'"); if (isset($_GET['pid']) && $pid != '-1') { $uri_array['pid'] = $pid; if ($_GET['pid'] == 0) { $sql .= " AND `pid`=''"; } else { iPHP::import(iPHP_APP_CORE . '/iMAP.class.php'); map::init('prop', $this->appid); $map_where = map::where($pid); } } if ($map_where) { $map_sql = iCMS::map_sql($map_where); $sql = ",({$map_sql}) map {$sql} AND `uid` = map.`iid`"; } $orderby = $_GET['orderby'] ? $_GET['orderby'] : "uid DESC"; $maxperpage = $_GET['perpage'] > 0 ? (int) $_GET['perpage'] : 20; $total = iPHP::total(false, "SELECT count(*) FROM `#iCMS@__user` {$sql}", "G"); iPHP::pagenav($total, $maxperpage, "个用户"); $limit = 'LIMIT ' . iPHP::$offset . ',' . $maxperpage; if ($map_sql || iPHP::$offset) { $ids_array = iDB::all("\n SELECT `uid` FROM `#iCMS@__user` {$sql}\n ORDER BY {$orderby} {$limit}\n "); //iDB::debug(1); $ids = iCMS::get_ids($ids_array, 'uid'); $ids = $ids ? $ids : '0'; $sql = "WHERE `uid` IN({$ids})"; $limit = ''; } $rs = iDB::all("SELECT * FROM `#iCMS@__user` {$sql} ORDER BY {$orderby} {$limit}"); $_count = count($rs); include iACP::view("user.manage"); }
function do_addproject() { $rs = array(); $this->pid && ($rs = spider::project($this->pid)); $cid = empty($rs['cid']) ? $this->cid : $rs['cid']; $categoryApp = iACP::app('category', iCMS_APP_ARTICLE); $cata_option = $categoryApp->select(false, $cid); $rule_option = $this->rule_opt($rs['rid']); $post_option = $this->post_opt($rs['poid']); //$rs['sleep'] OR $rs['sleep'] = 30; include iACP::view("spider.addproject"); }
function do_update() { $this->msg = iPatch::download(); //下载文件包 include iACP::view("patch"); }
function do_replace() { include iACP::view("database.replace"); }
function do_preview() { $_GET['pic'] && ($src = iFS::fp($_GET['pic'], '+http')); include iACP::view("files.preview"); }
function do_manage($doType = null) { include iACP::view("menu.manage"); }
</select> </div> <div class="clearfloat mb10"></div> <div class="input-prepend"> <span class="add-on">来自</span> <input type="text" name="from" id="from" class="span3" value="<?php echo $rs->info['from']; ?> " /> </div> <div class="clearfloat mb10"></div> <div class="input-prepend"> <span class="add-on">签名</span> <textarea name="signature" id="signature" cols="45" rows="5" class="span3"><?php echo $rs->info['signature']; ?> </textarea> </div> <div class="clearfloat mb10"></div> </div> <?php include iACP::view("admincp.power"); ?> </div> <div class="form-actions"> <button class="btn btn-primary" type="submit"><i class="fa fa-check"></i> 提交</button> </div> </form> </div> </div> </div> <?php iACP::foot();
function do_manage($doType = null) { $cid = (int) $_GET['cid']; $sql = " where "; switch ($doType) { //status:[0:草稿][1:正常][2:回收][3:审核][4:不合格] case 'inbox': //草稿 $sql .= "`status` ='0'"; // if(iMember::$data->gid!=1){ // $sql.=" AND `userid`='".iMember::$userid."'"; // } $position = "草稿"; break; case 'trash': //回收站 $sql .= "`status` ='2'"; $position = "回收站"; break; case 'examine': //审核 $sql .= "`status` ='3'"; $position = "已审核"; break; case 'off': //未通过 $sql .= "`status` ='4'"; $position = "未通过"; break; default: $sql .= " `status` ='1'"; $cid && ($position = $this->category[$cid]['name']); } if ($_GET['keywords']) { $sql .= " AND CONCAT(title,title2,title3) REGEXP '{$_GET['keywords']}'"; } $sql .= $this->categoryApp->search_sql($cid); isset($_GET['nopic']) && ($sql .= " AND `haspic` ='0'"); $_GET['starttime'] && ($sql .= " and `addtime`>=UNIX_TIMESTAMP('" . $_GET['starttime'] . " 00:00:00')"); $_GET['endtime'] && ($sql .= " and `addtime`<=UNIX_TIMESTAMP('" . $_GET['endtime'] . " 23:59:59')"); isset($_GET['userid']) && ($uri .= '&userid=' . (int) $_GET['userid']); isset($_GET['keyword']) && ($uri .= '&keyword=' . $_GET['keyword']); isset($_GET['pid']) && ($uri .= '&pid=' . $_GET['pid']); isset($_GET['cid']) && ($uri .= '&cid=' . $_GET['cid']); isset($_GET['pid']) && $_GET['pid'] != '-1' && ($uri .= '&pid=' . $_GET['at']); $orderby = $_GET['orderby'] ? $_GET['orderby'] : "id DESC"; $maxperpage = $_GET['perpage'] > 0 ? (int) $_GET['perpage'] : 20; $total = iPHP::total(false, "SELECT count(*) FROM `#iCMS@__push` {$sql}", "G"); iPHP::pagenav($total, $maxperpage, "条记录"); $rs = iDB::all("SELECT * FROM `#iCMS@__push` {$sql} order by {$orderby} LIMIT " . iPHP::$offset . " , {$maxperpage}"); $_count = count($rs); include iACP::view("push.manage"); }
function do_manage($stype = 'normal') { $cid = (int) $_GET['cid']; $pid = $_GET['pid']; //$stype OR $stype = iACP::$app_do; $stype_map = array('inbox' => '0', 'normal' => '1', 'trash' => '2', 'examine' => '3', 'off' => '4'); $map_where = array(); //status:[0:草稿][1:正常][2:回收][3:待审核][4:不合格] //postype: [0:用户][1:管理员] $stype && ($this->_status = $stype_map[$stype]); if (isset($_GET['pt']) && $_GET['pt'] != '') { $this->_postype = (int) $_GET['pt']; } $sql = "WHERE `status`='{$this->_status}'"; $this->_postype === 'all' or $sql .= " AND `postype`='{$this->_postype}'"; if (iACP::MP("ARTICLE.VIEW")) { $_GET['userid'] && ($sql .= iPHP::where($_GET['userid'], 'userid')); } else { $sql .= iPHP::where(iMember::$userid, 'userid'); } if (isset($_GET['pid']) && $pid != '-1') { $uri_array['pid'] = $pid; if (empty($_GET['pid'])) { $sql .= " AND `pid`=''"; } else { iPHP::import(iPHP_APP_CORE . '/iMAP.class.php'); map::init('prop', $this->appid); $map_where += map::where($pid); } } $cp_cids = iACP::CP('__CID__', 'cs'); //取得所有有权限的栏目ID if ($cp_cids) { if (is_array($cp_cids)) { if ($cid) { array_search($cid, $cp_cids) === false && iACP::permission_msg('栏目[cid:' . $cid . ']', $ret); } else { $cids = $cp_cids; } } else { $cids = $cid; } if ($_GET['sub'] && $cid) { $cids = $this->categoryApp->get_ids($cid, true); array_push($cids, $cid); } if ($_GET['scid'] && $cid) { iPHP::import(iPHP_APP_CORE . '/iMAP.class.php'); map::init('category', $this->appid); $map_where += map::where($cids); } else { $sql .= iPHP::where($cids, 'cid'); } } else { $sql .= iPHP::where('-1', 'cid'); } if ($_GET['keywords']) { $kws = $_GET['keywords']; switch ($_GET['st']) { case "title": $sql .= " AND `title` REGEXP '{$kws}'"; break; case "tag": $sql .= " AND `tags` REGEXP '{$kws}'"; break; case "source": $sql .= " AND `source` REGEXP '{$kws}'"; break; case "weight": $sql .= " AND `weight`='{$kws}'"; break; case "id": $sql .= " AND `id` REGEXP '{$kws}'"; break; case "tkd": $sql .= " AND CONCAT(title,keywords,description) REGEXP '{$kws}'"; break; } } $_GET['title'] && ($sql .= " AND `title` like '%{$_GET['title']}%'"); $_GET['tag'] && ($sql .= " AND `tags` REGEXP '[[:<:]]" . preg_quote(rawurldecode($_GET['tag']), '/') . "[[:>:]]'"); $_GET['starttime'] && ($sql .= " AND `pubdate`>='" . iPHP::str2time($_GET['starttime'] . " 00:00:00") . "'"); $_GET['endtime'] && ($sql .= " AND `pubdate`<='" . iPHP::str2time($_GET['endtime'] . " 23:59:59") . "'"); isset($_GET['pic']) && ($sql .= " AND `haspic` ='" . ($_GET['pic'] ? 1 : 0) . "'"); isset($_GET['userid']) && ($uri_array['userid'] = (int) $_GET['userid']); isset($_GET['keyword']) && ($uri_array['keyword'] = $_GET['keyword']); isset($_GET['tag']) && ($uri_array['tag'] = $_GET['tag']); isset($_GET['pt']) && ($uri_array['pt'] = $_GET['pt']); isset($_GET['cid']) && ($uri_array['cid'] = $_GET['cid']); $uri_array && ($uri = http_build_query($uri_array)); $orderby = $_GET['orderby'] ? $_GET['orderby'] : "id DESC"; $maxperpage = $_GET['perpage'] > 0 ? (int) $_GET['perpage'] : 20; if ($map_where) { $map_sql = iCMS::map_sql($map_where); $sql = ",({$map_sql}) map {$sql} AND `id` = map.`iid`"; } $total = iPHP::total(false, articleTable::count_sql($sql), "G"); iPHP::pagenav($total, $maxperpage, "篇文章"); $limit = 'LIMIT ' . iPHP::$offset . ',' . $maxperpage; if ($map_sql || iPHP::$offset) { // if($map_sql){ $ids_array = iDB::all("\n SELECT `id` FROM `#iCMS@__article` {$sql}\n ORDER BY {$orderby} {$limit}\n "); //iDB::debug(1); $ids = iCMS::get_ids($ids_array); $ids = $ids ? $ids : '0'; $sql = "WHERE `id` IN({$ids})"; // }else{ // $sql = ",( // SELECT `id` AS aid FROM `#iCMS@__article` {$sql} // ORDER BY {$orderby} {$limit} // ) AS art WHERE `id` = art.aid "; // } $limit = ''; } $rs = iDB::all("SELECT * FROM `#iCMS@__article` {$sql} ORDER BY {$orderby} {$limit}"); //iDB::debug(1); $_count = count($rs); include iACP::view("article.manage"); }
function do_list() { iACP::$app_do = 'list'; $sql = " where `appid`='{$this->appid}'"; $cids = iACP::CP('__CID__'); $sql .= iPHP::where($cids, 'cid'); if ($_GET['keywords']) { if ($_GET['st'] == "name") { $sql .= " AND `name` REGEXP '{$_GET['keywords']}'"; } else { if ($_GET['st'] == "cid") { $sql .= " AND `cid` REGEXP '{$_GET['keywords']}'"; } else { if ($_GET['st'] == "tkd") { $sql .= " AND CONCAT(name,title,keywords,description) REGEXP '{$_GET['keywords']}'"; } } } } if (isset($_GET['rootid']) && $_GET['rootid'] != '-1') { $sql .= " AND `rootid`='{$_GET['rootid']}'"; } $orderby = $_GET['orderby'] ? $_GET['orderby'] : "cid DESC"; $maxperpage = $_GET['perpage'] > 0 ? (int) $_GET['perpage'] : 20; $total = iPHP::total(false, "SELECT count(*) FROM `#iCMS@__category` {$sql}", "G"); iPHP::pagenav($total, $maxperpage); $rs = iDB::all("SELECT * FROM `#iCMS@__category` {$sql} order by {$orderby} LIMIT " . iPHP::$offset . " , {$maxperpage}"); $_count = count($rs); include iACP::view("category.manage"); }
function do_iCMS() { $sql = " where 1=1"; $_GET['pid'] && ($sql .= " AND `pid`='" . $_GET['pid'] . "'"); $_GET['pid'] && ($uri .= '&pid=' . $_GET['pid']); $_GET['cid'] && ($sql .= " AND `cid`='" . $_GET['cid'] . "'"); $_GET['cid'] && ($uri .= '&cid=' . $_GET['cid']); $maxperpage = $_GET['perpage'] > 0 ? (int) $_GET['perpage'] : 20; $total = iPHP::total(false, "SELECT count(*) FROM `#iCMS@__marker` {$sql}", "G"); iPHP::pagenav($total, $maxperpage, "个标记"); $rs = iDB::all("SELECT * FROM `#iCMS@__marker` {$sql} order by id DESC LIMIT " . iPHP::$offset . " , {$maxperpage}"); $_count = count($rs); include iACP::view("marker.manage"); }
function do_article() { $this->categoryApp = iACP::app('category', iCMS_APP_ARTICLE); include iACP::view("html.article"); }
/** * [app 其它应用配置接口] * @param integer $appid [应用ID] * @param [sting] $name [应用名] */ function app($appid = 0, $name = null) { $name === null && ($name = iACP::$app_name); $config = $this->get($appid, $name); include iACP::view($name . ".config"); }