function do_del($id = null, $dialog = true)
{
$id === null && ($id = $this->id);
$id or iPHP::alert('请选择要删除的网站!');
iDB::query("DELETE FROM `#iCMS@__links` WHERE `id` = '{$id}'");
$dialog && iPHP::success('网站已经删除', 'js:parent.$("#tr' . $id . '").remove();');
}
function do_del($id = null, $dialog = true)
{
$id === null && ($id = $this->pid);
$id or iPHP::alert('请选择要删除的属性!');
iDB::query("DELETE FROM `#iCMS@__prop` WHERE `pid` = '{$id}';");
$this->cache();
$dialog && iPHP::success("已经删除!", 'url:' . APP_URI);
}
function do_del($gid = null, $dialog = true)
{
$gid === null && ($gid = $this->gid);
$gid or iPHP::alert('请选择要删除的用户组');
$gid == "1" && iPHP::alert('不能删除超级管理员组');
iDB::query("DELETE FROM `#iCMS@__group` WHERE `gid` = '{$gid}'");
$dialog && iPHP::success('用户组删除完成', 'js:parent.$("#tr' . $gid . '").remove();');
}
private function slog($search)
{
$sid = iDB::value("SELECT `id` FROM `#iCMS@__search_log` WHERE `search` = '{$search}' LIMIT 1");
if ($sid) {
iDB::query("UPDATE `#iCMS@__search_log` SET `times` = times+1 WHERE `id` = '{$sid}';");
} else {
iDB::query("INSERT INTO `#iCMS@__search_log` (`search`, `times`, `addtime`) VALUES ('{$search}', '1', '" . time() . "');");
}
}
function do_del($id = null, $dialog = true)
{
$id === null && ($id = $this->id);
$id or iPHP::alert('请选择要删除的评论!');
$comment = iDB::row("SELECT * FROM `#iCMS@__comment` WHERE `id`='{$id}' LIMIT 1");
iPHP::import(iPHP_APP_CORE . '/iAPP.class.php');
$table = app::get_table($comment->appid);
iDB::query("UPDATE {$table['name']} SET comments = comments-1 WHERE `comments`>0 AND `{$table['primary']}`='{$comment->iid}' LIMIT 1;");
iDB::query("UPDATE `#iCMS@__user` SET comments = comments-1 WHERE `comments`>0 AND `uid`='{$comment->userid}' LIMIT 1;");
iDB::query("DELETE FROM `#iCMS@__comment` WHERE `id` = '{$id}';");
$dialog && iPHP::success('评论删除完成', 'js:parent.$("#id-' . $id . '").remove();');
}
public static function diff($Nnodes, $Onodes, $iid = "0")
{
$N = explode(',', $Nnodes);
$O = explode(',', $Onodes);
$diff = array_diff_values($N, $O);
$varsArray = array();
foreach ((array) $N as $i => $_node) {
//新增
$varsArray[$i] = self::addnew($_node, $iid);
}
foreach ((array) $diff['-'] as $_node) {
//减少
iDB::query("DELETE FROM `" . self::table() . "` WHERE `" . self::$field . "`='{$_node}' AND `iid`='{$iid}' AND `appid`='" . self::$appid . "'");
}
return json_encode($varsArray);
}
private function vote($_do)
{
// iPHP::app('user.class','static');
// user::get_cookie() OR iPHP::code(0,'iCMS:!login',0,'json');
$aid = (int) $_GET['iid'];
$aid or iPHP::code(0, 'iCMS:article:empty_id', 0, 'json');
$ackey = 'article_' . $_do . '_' . $aid;
$vote = iPHP::get_cookie($ackey);
$vote && iPHP::code(0, 'iCMS:article:!' . $_do, 0, 'json');
if ($_do == 'good') {
$sql = '`good`=good+1';
} else {
$sql = '`bad`=bad+1';
}
iDB::query("UPDATE `#iCMS@__article` SET {$sql} WHERE `id` ='{$aid}' limit 1");
iPHP::set_cookie($ackey, time(), 86400);
iPHP::code(1, 'iCMS:article:' . $_do, 0, 'json');
}
public static function checkLogin()
{
// self::$LOGIN_COUNT = (int)authcode(get_cookie('iCMS_LOGIN_COUNT'),'DECODE');
// if(self::$LOGIN_COUNT>iCMS_LOGIN_COUNT) exit();
$a = iS::escapeStr($_POST['username']);
$p = iS::escapeStr($_POST['password']);
$ip = iPHP::getIp();
$sep = iPHP_AUTH_IP ? '#=iCMS[' . $ip . ']=#' : '#=iCMS=#';
if (empty($a) && empty($p)) {
$auth = iPHP::get_cookie(self::$AUTH);
list($a, $p) = explode($sep, authcode($auth, 'DECODE'));
return self::check($a, $p);
} else {
$p = md5($p);
$crs = self::check($a, $p);
iDB::query("UPDATE `#iCMS@__members` SET `lastip`='" . $ip . "',`lastlogintime`='" . time() . "',`logintimes`=logintimes+1 WHERE `uid`='" . self::$userid . "'");
iPHP::set_cookie(self::$AUTH, authcode($a . $sep . $p, 'ENCODE'));
self::$AJAX && iPHP::json(array('code' => 1));
return $crs;
}
}
/**
* [ACTION_add 添加到收藏夹]
*/
public function ACTION_add()
{
$this->__login();
$uid = user::$userid;
$appid = (int) $_POST['appid'];
$iid = (int) $_POST['iid'];
$cid = (int) $_POST['cid'];
$suid = (int) $_POST['suid'];
$id = (int) $_POST['id'];
$fid = (int) $_POST['fid'];
$title = iS::escapeStr($_POST['title']);
$url = iS::escapeStr($_POST['url']);
$addtime = time();
$id = iDB::value("SELECT `id` FROM `#iCMS@__favorite_data` WHERE `uid`='{$uid}' AND `fid`='{$fid}' AND `url`='{$url}' LIMIT 1");
$id && iPHP::code(0, 'iCMS:favorite:failure', 0, 'json');
$fields = array('uid', 'appid', 'fid', 'iid', 'url', 'title', 'addtime');
$data = compact($fields);
$fdid = iDB::insert('favorite_data', $data);
if ($fdid) {
iDB::query("\n UPDATE `#iCMS@__favorite`\n SET `count` = count+1\n WHERE `id` = '{$fid}';\n ");
iPHP::code(1, 'iCMS:favorite:success', $fdid, 'json');
}
iPHP::code(0, 'iCMS:favorite:error', 0, 'json');
}
public function API_crontab()
{
$timeline = iCMS::timeline();
//var_dump($timeline);
$pieces = array();
foreach ($timeline as $key => $bool) {
$field = "hits_{$key}";
if ($key == 'yday') {
if ($bool == 1) {
$pieces[] = "`hits_yday` = hits_today";
} elseif ($bool > 1) {
$pieces[] = "`hits_yday` = 0";
}
} else {
$bool or $pieces[] = "`{$field}` = 0";
}
}
$pieces && ($sql = implode(',', $pieces));
if ($sql) {
//点击初始化
iDB::query("UPDATE `#iCMS@__article` SET {$sql}");
iDB::query("UPDATE `#iCMS@__user` SET {$sql}");
}
}
function update_count($cid)
{
$cc = iDB::value("SELECT count(*) FROM `#iCMS@__" . $this->_app_table . "` where `" . $this->_app_cid . "`='{$cid}'");
iDB::query("UPDATE `#iCMS@__category` SET `count` ='{$cc}' WHERE `cid` ='{$cid}'");
}
function do_del($uid = null, $dialog = true)
{
$uid === null && ($uid = $this->uid);
$uid or iPHP::alert('请选择要删除的用户');
iDB::query("DELETE FROM `#iCMS@__user` WHERE `uid` = '{$uid}'");
iDB::query("DELETE FROM `#iCMS@__prop_map` WHERE `iid` = '{$uid}' AND `appid` = '" . iCMS_APP_USER . "' ;");
$dialog && iPHP::success('用户删除完成', 'js:parent.$("#tr' . $uid . '").remove();');
}
public function API_hits($uid = null)
{
$uid === null && ($uid = (int) $_GET['uid']);
if ($uid) {
$sql = iCMS::hits_sql();
iDB::query("UPDATE `#iCMS@__user` SET {$sql} WHERE `uid` ='{$uid}'");
}
}
public static function del($tags, $field = 'name', $iid = 0)
{
$tagArray = explode(",", $tags);
$iid && ($sql = "AND `iid`='{$iid}'");
foreach ($tagArray as $k => $v) {
$tag = iDB::row("SELECT * FROM `#iCMS@__tags` WHERE `{$field}`='{$v}' LIMIT 1;");
$tRS = iDB::all("SELECT `iid` FROM `#iCMS@__tags_map` WHERE `node`='{$tag->id}' AND `appid`='" . TAG_APPID . "' {$sql}");
foreach ((array) $tRS as $TL) {
$idA[] = $TL['iid'];
}
if ($idA) {
$ids = iPHP::get_ids($idA, null);
if ($ids) {
iPHP::app('apps.class', 'static');
$table = APPS::table(TAG_APPID);
iDB::query("\n UPDATE `#iCMS@__{$table}`\n SET `tags`= REPLACE(tags, '{$tag->name},',''),\n `tags`= REPLACE(tags, ',{$tag->name}','')\n WHERE id IN({$ids})\n ");
}
}
self::$remove && iDB::query("DELETE FROM `#iCMS@__tags` WHERE `{$field}`='{$v}'");
iDB::query("\n DELETE FROM\n `#iCMS@__tags_map`\n WHERE `node`='{$tag->id}'\n AND `appid`='" . TAG_APPID . "' {$sql}");
$ckey = self::tkey($tag->cid);
iCache::delete($ckey);
}
}
function delArticle($id, $uid = '0', $postype = '1')
{
$id = (int) $id;
$id or iPHP::alert("请选择要删除的文章");
$uid && ($sql = "and `userid`='{$uid}' and `postype`='{$postype}'");
$art = articleTable::row($id, 'cid,pic,tags', $sql);
iACP::CP($art['cid'], 'cd', 'alert');
$frs = articleTable::select_filedata_indexid($id);
for ($i = 0; $i < count($frs); $i++) {
if ($frs[$i]) {
$path = $frs[$i]['path'] . '/' . $frs[$i]['filename'] . '.' . $frs[$i]['ext'];
iFS::del(iFS::fp($frs[$i]['path'], '+iPATH'));
$msg .= $this->del_msg($path . ' 文件删除');
}
}
if ($art['tags']) {
iPHP::app('tag.class', 'static');
$msg .= tag::del($art['tags']);
}
iDB::query("DELETE FROM `#iCMS@__category_map` WHERE `iid` = '{$id}' AND `appid` = '" . $this->appid . "';");
iDB::query("DELETE FROM `#iCMS@__prop_map` WHERE `iid` = '{$id}' AND `appid` = '" . $this->appid . "' ;");
articleTable::del_filedata($id, 'indexid');
$msg .= $this->del_msg('相关文件数据删除');
articleTable::del_comment($id);
$msg .= $this->del_msg('评论数据删除');
articleTable::del($id);
articleTable::del_data($id);
$msg .= $this->del_msg('文章数据删除');
$this->categoryApp->update_count_one($art['cid'], '-');
$msg .= $this->del_msg('栏目数据更新');
$msg .= $this->del_msg('删除完成');
return $msg;
}
function run_query($sql)
{
$sql = str_replace("\r", "\n", $sql);
$resource = array();
$num = 0;
$sql_array = explode(";\n", trim($sql));
foreach ($sql_array as $query) {
$queries = explode("\n", trim($query));
foreach ($queries as $query) {
$resource[$num] .= $query[0] == '#' ? '' : $query;
}
$num++;
}
unset($sql);
foreach ($resource as $key => $query) {
$query = trim($query);
$query && iDB::query($query);
}
}
public function ACTION_add()
{
if (!iCMS::$config['comment']['enable']) {
iPHP::code(0, 'iCMS:comment:close', 0, 'json');
}
iPHP::app('user.class', 'static');
user::get_cookie() or iPHP::code(0, 'iCMS:!login', 0, 'json');
$seccode = iS::escapeStr($_POST['seccode']);
if (iCMS::$config['comment']['seccode']) {
iPHP::seccode($seccode, true) or iPHP::code(0, 'iCMS:seccode:error', 'seccode', 'json');
}
iPHP::app('user.msg.class', 'static');
$appid = (int) $_POST['appid'];
$iid = (int) $_POST['iid'];
$cid = (int) $_POST['cid'];
$suid = (int) $_POST['suid'];
$reply_id = (int) $_POST['id'];
$reply_uid = (int) $_POST['userid'];
$reply_name = iS::escapeStr($_POST['name']);
$title = iS::escapeStr($_POST['title']);
$content = iS::escapeStr($_POST['content']);
$iid or iPHP::code(0, 'iCMS:article:empty_id', 0, 'json');
$content or iPHP::code(0, 'iCMS:comment:empty', 0, 'json');
$fwd = iCMS::filter($content);
$fwd && iPHP::code(0, 'iCMS:comment:filter', 0, 'json');
$appid or $appid = iCMS_APP_ARTICLE;
$addtime = $_SERVER['REQUEST_TIME'];
$ip = iPHP::getIp();
$userid = user::$userid;
$username = user::$nickname;
$status = iCMS::$config['comment']['examine'] ? '0' : '1';
$up = '0';
$down = '0';
$quote = '0';
$floor = '0';
$fields = array('appid', 'cid', 'iid', 'suid', 'title', 'userid', 'username', 'content', 'reply_id', 'reply_uid', 'reply_name', 'addtime', 'status', 'up', 'down', 'ip', 'quote', 'floor');
$data = compact($fields);
$id = iDB::insert('comment', $data);
iDB::query("UPDATE `#iCMS@__article` SET comments=comments+1 WHERE `id` ='{$iid}' limit 1");
user::update_count($userid, 1, 'comments');
if (iCMS::$config['comment']['examine']) {
iPHP::code(0, 'iCMS:comment:examine', $id, 'json');
}
iPHP::code(1, 'iCMS:comment:success', $id, 'json');
}
public static function gc($sessMaxLifeTime = 0)
{
// delete old sessions
$return = iDB::query("\n DELETE FROM " . iPHP_DB_PREFIX_TAG . "sessions\n WHERE expires < " . time());
// return affected rows
if ($return) {
return true;
}
// ...else return false
return false;
}
function do_batch()
{
$idArray = (array) $_POST['id'];
$idArray or iPHP::alert("请选择要操作的标签");
$ids = implode(',', $idArray);
$batch = $_POST['batch'];
switch ($batch) {
case 'dels':
iPHP::$break = false;
foreach ($idArray as $id) {
$this->do_del($id, false);
}
iPHP::$break = true;
iPHP::success('标签全部删除完成!', 'js:1');
break;
case 'move':
$_POST['cid'] or iPHP::alert("请选择目标栏目!");
iPHP::import(iPHP_APP_CORE . '/iMAP.class.php');
map::init('category', $this->appid);
$cid = (int) $_POST['cid'];
foreach ($idArray as $id) {
$_cid = iDB::value("SELECT `cid` FROM `#iCMS@__tags` where `id` ='{$id}'");
iDB::update("tags", compact('cid'), compact('id'));
if ($_cid != $cid) {
map::diff($cid, $_cid, $id);
$this->categoryApp->update_count_one($_cid, '-');
$this->categoryApp->update_count_one($cid);
}
}
iPHP::success('成功移动到目标栏目!', 'js:1');
break;
case 'mvtcid':
$_POST['tcid'] or iPHP::alert("请选择目标分类!");
iPHP::import(iPHP_APP_CORE . '/iMAP.class.php');
map::init('category', $this->appid);
$tcid = (int) $_POST['tcid'];
foreach ($idArray as $id) {
$_tcid = iDB::value("SELECT `tcid` FROM `#iCMS@__tags` where `id` ='{$id}'");
iDB::update("tags", compact('tcid'), compact('id'));
if ($_tcid != $tcid) {
map::diff($tcid, $_tcid, $id);
$this->categoryApp->update_count_one($_tcid, '-');
$this->categoryApp->update_count_one($tcid);
}
}
iPHP::success('成功移动到目标分类!', 'js:1');
break;
case 'prop':
iPHP::import(iPHP_APP_CORE . '/iMAP.class.php');
map::init('prop', $this->appid);
$pid = implode(',', (array) $_POST['pid']);
foreach ((array) $_POST['id'] as $id) {
$_pid = iDB::value("SELECT pid FROM `#iCMS@__tags` WHERE `id`='{$id}'");
iDB::update("tags", compact('pid'), compact('id'));
map::diff($pid, $_pid, $id);
}
iPHP::success('属性设置完成!', 'js:1');
break;
case 'weight':
$weight = _int($_POST['mweight']);
$sql = "`weight` = '{$weight}'";
break;
case 'tpl':
$tpl = iS::escapeStr($_POST['mtpl']);
$sql = "`tpl` = '{$tpl}'";
break;
case 'keyword':
if ($_POST['pattern'] == 'replace') {
$sql = "`keywords` = '" . iS::escapeStr($_POST['mkeyword']) . "'";
} elseif ($_POST['pattern'] == 'addto') {
foreach ($idArray as $id) {
$keywords = iDB::value("SELECT keywords FROM `#iCMS@__tags` WHERE `id`='{$id}'");
$sql = "`keywords` = '" . ($keywords ? $keywords . ',' . iS::escapeStr($_POST['mkeyword']) : iS::escapeStr($_POST['mkeyword'])) . "'";
iDB::query("UPDATE `#iCMS@__tags` SET {$sql} WHERE `id`='{$id}'");
}
iPHP::success('关键字更改完成!', 'js:1');
}
break;
case 'tag':
if ($_POST['pattern'] == 'replace') {
$sql = "`related` = '" . iS::escapeStr($_POST['mtag']) . "'";
} elseif ($_POST['pattern'] == 'addto') {
foreach ($idArray as $id) {
$keywords = iDB::value("SELECT related FROM `#iCMS@__tags` WHERE `id`='{$id}'");
$sql = "`related` = '" . ($keywords ? $keywords . ',' . iS::escapeStr($_POST['mtag']) : iS::escapeStr($_POST['mtag'])) . "'";
iDB::query("UPDATE `#iCMS@__tags` SET {$sql} WHERE `id`='{$id}'");
}
iPHP::success('相关标签更改完成!', 'js:1');
}
break;
default:
if (strpos($batch, ':')) {
$data = iACP::fields($batch);
foreach ($idArray as $id) {
$data && iDB::update("tags", $data, array('id' => $id));
}
iPHP::success('操作成功!', 'js:1');
} else {
iPHP::alert('请选择要操作项!', 'js:1');
}
}
$sql && iDB::query("UPDATE `#iCMS@__tags` SET {$sql} WHERE `id` IN ({$ids})");
iPHP::success('操作成功!', 'js:1');
}
public static function del($tags, $field = 'name', $iid = 0)
{
$tagArray = explode(",", $tags);
$iid && ($sql = "AND `iid`='{$iid}'");
foreach ($tagArray as $k => $v) {
$tagA = iDB::row("SELECT * FROM `#iCMS@__tags` WHERE `{$field}`='{$v}' LIMIT 1;");
$tRS = iDB::all("SELECT `iid` FROM `#iCMS@__tags_map` WHERE `node`='{$tagA->id}' AND `appid`='" . TAG_APPID . "' {$sql}");
foreach ((array) $tRS as $TL) {
$idA[] = $TL['iid'];
}
// if($idA){
// iPHP::appClass('model',"break");
// $table = model::table(TAG_APPID);
// $ids = implode(',',$idA);
// iDB::query("UPDATE `#iCMS@__$table` SET `tags`=REPLACE(tags, '$tagA->name,',''),`tags`=REPLACE(tags, ',$tagA->name','') WHERE id IN($ids)");
// }
iDB::query("DELETE FROM `#iCMS@__tags` WHERE `{$field}`='{$v}'");
iDB::query("DELETE FROM `#iCMS@__tags_map` WHERE `node`='{$tagA->id}' AND `appid`='" . TAG_APPID . "' {$sql}");
$ckey = self::tkey($tagA->cid);
iCache::delete($ckey);
}
}
function do_del()
{
$id = (int) $_GET['id'];
if (empty(iACP::$menu->root_array[$id])) {
iDB::query("DELETE FROM `#iCMS@__menu` WHERE `id` = '{$id}'");
iACP::$menu->cache();
$msg = '删除成功!';
} else {
$msg = '请先删除本菜单下的子菜单!';
}
iPHP::dialog($msg, 'js:parent.$("#' . $id . '").remove();');
}
public static function update_count($uid = 0, $count = 0, $field = 'article', $math = '+')
{
$math == '-' && ($sql = " AND `{$field}`>0");
iDB::query("UPDATE `#iCMS@__user` SET `{$field}` = {$field}{$math}{$count} WHERE `uid`='{$uid}' {$sql} LIMIT 1;");
}
function do_delproject()
{
$this->pid or iPHP::alert("请选择要删除的项目");
iDB::query("delete from `#iCMS@__spider_project` where `id` = '{$this->pid}';");
iPHP::success('删除完成');
}
public function update_count_one($cid, $math = '+')
{
$math == '-' && ($sql = " AND `count`>0");
iDB::query("UPDATE `#iCMS@__category` SET `count` = count" . $math . "1 WHERE `cid` ='{$cid}' {$sql}");
}
function do_del($uid = null, $dialog = true)
{
$uid === null && ($uid = $this->uid);
$uid or iPHP::alert('请选择要删除的用户');
$uid == "1" && iPHP::alert('不能删除超级管理员');
iDB::query("DELETE FROM `#iCMS@__members` WHERE `uid` = '{$uid}'");
$dialog && iPHP::success('用户删除完成', 'js:parent.$("#tr' . $uid . '").remove();');
}
function do_del($id = null)
{
iACP::MP('FILE.DELETE', 'alert');
$id === null && ($id = $this->id);
$id or iPHP::alert("请选择要删除的文件");
$indexid = (int) $_GET['indexid'];
$sql = isset($_GET['indexid']) ? "AND `indexid`='{$indexid}'" : "";
$rs = iDB::row("SELECT * FROM `#iCMS@__filedata` WHERE `id` = '{$id}' {$sql} LIMIT 1;");
if ($rs) {
$rs->filepath = rtrim($rs->path, '/') . '/' . $rs->filename . '.' . $rs->ext;
$FileRootPath = iFS::fp($rs->filepath, "+iPATH");
if (iFS::del($FileRootPath)) {
iDB::query("DELETE FROM `#iCMS@__filedata` WHERE `id` = '{$id}' {$sql};");
$msg = 'success:#:check:#:文件删除完成!';
$_GET['ajax'] && iPHP::json(array('code' => 1, 'msg' => $msg));
} else {
$msg = 'warning:#:warning:#:找不到相关文件,文件删除失败!<hr/>文件相关数据已清除';
$_GET['ajax'] && iPHP::json(array('code' => 0, 'msg' => $msg));
}
iPHP::dialog($msg, 'js:parent.$("#tr' . $id . '").remove();');
}
$msg = '文件删除失败!';
$_GET['ajax'] && iPHP::json(array('code' => 0, 'msg' => $msg));
iPHP::alert($msg);
}
public static function del_comment($iid)
{
iDB::query("DELETE FROM `#iCMS@__comment` WHERE iid='{$iid}' and appid='" . iCMS_APP_ARTICLE . "'");
}
function do_query()
{
$field = $_POST["field"];
$pattern = $_POST["pattern"];
$replacement = $_POST["replacement"];
$where = $_POST["where"];
$pattern or iPHP::alert("查找项不能为空~!");
if ($field == "body") {
$rows_affected = iDB::query("UPDATE `#iCMS@__article_data` SET `body` = REPLACE(`body`, '{$pattern}', '{$replacement}') {$where}");
} else {
if ($field == "tkd") {
$rows_affected = iDB::query("UPDATE `#iCMS@__article` SET `title` = REPLACE(`title`, '{$pattern}', '{$replacement}'),\n\t\t \t`keywords` = REPLACE(`keywords`, '{$pattern}', '{$replacement}'),\n\t\t \t`description` = REPLACE(`description`, '{$pattern}', '{$replacement}'){$where}");
} else {
$rows_affected = iDB::query("UPDATE `#iCMS@__article` SET `{$field}` = REPLACE(`{$field}`, '{$pattern}', '{$replacement}'){$where}");
}
}
iPHP::success($rows_affected . "条记录被替换<hr />操作完成!!");
}
