function doadd()
{
include iPATH . 'include/from.fun.php';
$mid = $_GET['mid'];
$table = model::tbn($_GET['table']);
$model = model::data($mid);
$fArray = explode(',', $model['field']);
$_count = count($fArray);
$rs = array();
$id = $_GET['id'];
$id && ($rs = iCMS_DB::getRow("SELECT * FROM `#iCMS@__{$table}` where `id`='{$id}'", ARRAY_A));
$rs['mName'] = $_GET['table'];
$rs['mid'] = $mid;
$rs['fid'] = empty($rs['fid']) ? intval($_GET['fid']) : $rs['fid'];
$rs['pubdate'] = empty($id) ? get_date('', "Y-m-d H:i:s") : get_date($rs['pubdate'], 'Y-m-d H:i:s');
empty($rs['editor']) && ($rs['editor'] = empty(member::$Rs->name) ? member::$Rs->username : member::$Rs->name);
empty($rs['userid']) && ($rs['userid'] = member::$uId);
$rs['orderNum'] = _int($rs['orderNum']);
$rs['top'] = _int($rs['top']);
$formArray = FormArray($mid, $fArray, $rs);
$strpos = strpos(__REF__, '?');
$REFERER = $strpos === false ? '' : substr(__REF__, $strpos);
include admincp::tpl();
}
function doEditField()
{
$fid = (int) $_POST['fid'];
$mid = (int) $_POST['mid'];
$name = dhtmlspecialchars($_POST['name']);
$field = dhtmlspecialchars($_POST['field']);
$ofield = dhtmlspecialchars($_POST['ofield']);
if (empty($field)) {
include iPATH . 'include/cn.class.php';
$field = CN::pinyin($name);
}
$type = $_POST['type'];
$show = $_POST['show'];
$default = dhtmlspecialchars($_POST['default']);
$validate = $_POST['validate'];
$description = dhtmlspecialchars($_POST['description']);
$option = addslashes(serialize($_POST['option']));
$hidden = isset($_POST['hidden']) ? 1 : 0;
!preg_match("/[a-zA-Z]/", $field[0]) && javascript::alert('字段只能以英文字母开头');
!preg_match("/[a-zA-Z0-9_\\-~]/", $field) && javascript::alert('字段只能由英文字母或数字组成');
model::isDefField($field) && javascript::alert('您所填写的字段是默认字段!请重新填写.');
$model = model::data($mid);
$oFieldA = explode(',', $model['field']);
$sql = "ALTER TABLE `#iCMS@__" . model::tbn($model['table']) . "`";
if ($fid) {
iCMS_DB::getValue("SELECT `id` FROM `#iCMS@__field` where `field` = '{$field}' and `mid`='{$mid}' and `id`!='{$fid}'") && javascript::alert('该字段已经存在!请检查是否重复');
iCMS_DB::query("UPDATE `#iCMS@__field` SET `name` = '{$name}', `field` = '{$field}', `mid` = '{$mid}', `type` = '{$type}',`show` = '{$show}', `default` = '{$default}', `validate` = '{$validate}', `hidden` = '{$hidden}', `description` = '{$description}', `option` = '{$option}' WHERE `id` = '{$fid}';");
$sql .= " CHANGE COLUMN `{$ofield}` `{$field}`";
if ($field != $ofield) {
$fKey = array_search($ofield, $oFieldA);
unset($oFieldA[$fKey]);
}
} else {
iCMS_DB::getValue("SELECT `id` FROM `#iCMS@__field` where `field` = '{$field}' and `mid`='{$mid}'") && javascript::alert('该字段已经存在!请检查是否重复');
iCMS_DB::query("INSERT INTO `#iCMS@__field` (`name`, `field`, `mid`, `type`,`show`, `default`, `validate`, `hidden`, `description`, `option`) VALUES ('{$name}', '{$field}', '{$mid}', '{$type}', '{$show}', '{$default}', '{$validate}', '{$hidden}', '{$description}', '{$option}');");
$sql .= " ADD COLUMN `{$field}`";
//新增
$col = iCMS_DB::getCol("describe `#iCMS@__" . model::tbn($model['table']) . "`");
$AfterSql = ' after `' . end($col) . '`';
}
$SqlType = model::SqlType($type, $default);
iCMS_DB::query($sql . $SqlType . $AfterSql);
if ($field != $ofield) {
array_push($oFieldA, $field);
$mField = implode(',', array_unique($oFieldA));
iCMS_DB::query("update `#iCMS@__model` SET `field`='{$mField}' where id='{$mid}'");
}
model::cache();
javascript::dialog('字段添加完成!<br />10秒后返回字段管理', "url:" . __SELF__ . "?mo=models&do=managefield&id=" . $mid);
}
function delContent($id, $mid, $uid = '0', $postype = '1')
{
$uid && ($sql = "and `userid`='{$uid}' and `postype`='{$postype}'");
$model = model::data($mid);
$table = $model['tbn'];
$FArray = model::field($mid);
$MF = explode(',', $model['field']);
$rs = iCMS_DB::getRow("SELECT * FROM `#iCMS@__{$table}` where `id`='{$id}' {$sql}", ARRAY_A);
foreach ($MF as $field) {
if ($FArray[$field]['type'] == 'upload') {
$rs[$field] && ($msg .= delpic($rs[$field]));
}
}
$rs['tags'] && ($msg .= deltag($rs['tags']));
iCMS_DB::query("DELETE FROM `#iCMS@__comment` WHERE indexId='{$id}' and mid='{$mid}'");
$msg .= '评论数据删除…<span style=\'color:green;\'>√</span><br />';
iCMS_DB::query("DELETE FROM `#iCMS@__{$table}` WHERE id='{$id}'");
iCMS_DB::query("DELETE FROM `#iCMS@__vlink` WHERE indexId='{$id}' AND modelId='{$mid}'");
$msg .= '内容数据删除…<span style=\'color:green;\'>√</span><br />';
iCMS_DB::query("UPDATE `#iCMS@__forum` SET `count` = count-1 WHERE `fid` ='" . $rs['fid'] . "' LIMIT 1");
$msg .= '栏目数据更新…<span style=\'color:green;\'>√</span><br />';
$msg .= '删除完成…<span style=\'color:green;\'>√</span><hr />';
return $msg;
}
function domanage()
{
$mid = $_GET['mid'];
$model = model::data($mid);
$table = $model['tbn'];
$forum = new forum();
$fid = (int) $_GET['fid'];
$sql = " where `userid`='" . (int) member::$uId . "' AND `postype`='0'";
//postype: [0:用户][1:管理员] status:[0:草稿][1:正常][2:回收]
$_GET['keyword'] && ($sql .= " AND CONCAT(title,tags) REGEXP '{$_GET['keyword']}'");
$_GET['status'] != "" && ($sql .= " AND `status`='" . $_GET['status'] . "'");
if ($fid) {
$fidIN = $forum->fid($fid) . $fid;
if (isset($_GET['sub']) && strstr($fidIN, ',')) {
$sql .= " AND fid IN(" . $fidIN . ")";
} else {
$sql .= " AND fid ='{$fid}'";
}
//$sql.=" OR `vlink` REGEXP '[[:<:]]".preg_quote($fid, '/')."[[:>:]]')";
}
// $_GET['starttime'] && $sql.=" and `pubdate`>='".strtotime($_GET['starttime'])."'";
// $_GET['endtime'] && $sql.=" and `pubdate`<='".strtotime($_GET['endtime'])."'";
isset($_GET['keyword']) && ($uri .= '&keyword=' . $_GET['keyword']);
$orderby = $_GET['orderby'] ? $_GET['orderby'] : "id DESC";
$maxperpage = (int) $_GET['perpage'] > 0 ? $_GET['perpage'] : 20;
$total = $page == 1 || empty($_GET['rowNum']) ? iCMS_DB::getValue("SELECT count(*) FROM `#iCMS@__{$table}` {$sql}") : (int) $_GET['rowNum'];
page($total, $maxperpage, "条记录");
$rs = iCMS_DB::getArray("SELECT * FROM `#iCMS@__{$table}` {$sql} order by {$orderby} LIMIT {$this->firstcount} , {$maxperpage}");
$_count = count($rs);
include $this->tpl();
}
