function doManagefield()
{
$mid = (int) $_GET['id'];
$FieldArray = model::field($mid);
$model = model::data($mid);
$fArray = explode(',', $model['field']);
include admincp::tpl();
}
public function db()
{
jiashu::loadLib('model');
$user = new model('user', 'testdb');
//$r = $user->executeSql('select * from test_user');//you can use executeSql() to query a SQL statment directly.用executeSql()函数可以直接执行SQL语句
$r = $user->field('username,email')->limit('1')->query();
JSFW()->setTplData('r', $r);
JSFW()->render('index');
}
function dosave()
{
include_once iPATH . 'include/tag.class.php';
$id = $_POST['id'];
$mid = $_POST['mid'];
$FArray = model::field($mid);
$model = model::data($mid);
$content = array();
if ($_POST['content']) {
foreach ($_POST['content'] as $field => $value) {
if (model::isDefField($field)) {
switch ($field) {
case "userid":
$value = intval($value);
break;
case "fid":
$value = $fid = intval($value);
empty($value) && javascript::alert('请选择所属栏目');
break;
case "orderNum":
$value = _int($value);
break;
case "top":
$value = _int($value);
break;
case "title":
$value = dhtmlspecialchars($value);
empty($value) && javascript::alert('标题不能为空！');
break;
case "editor":
$value = dhtmlspecialchars($value);
break;
case "tags":
$value = iTAG::split(dhtmlspecialchars($value), true);
break;
case "type":
$value = intval($value);
break;
case "vlink":
$value = implode(',', $value);
break;
case "postype":
$value = empty($value) ? intval($value) : "1";
break;
case "pubdate":
$value = _strtotime($value);
break;
case "clink":
$value = dhtmlspecialchars($value);
if ($value) {
$clinklen = strlen($value);
for ($i = 0; $i < $clinklen; $i++) {
!preg_match("/[a-zA-Z0-9_\\-~" . preg_quote($this->iCMS->config['CLsplit'], '/') . "]/", $value[$i]) && javascript::alert('自定链接只能由英文字母、数字或_-~组成(不支持中文)');
}
}
break;
}
} elseif ($F = $FArray[$field]) {
switch ($F['type']) {
case "number":
$value = intval($value);
break;
case "calendar":
$value = _strtotime($value);
break;
case in_array($F['type'], array('text', 'textarea', 'radio', 'select', 'email', 'url', 'image', 'upload')):
$value = dhtmlspecialchars($value);
break;
case in_array($F['type'], array('checkbox', 'multiple')):
$value = implode(',', $value);
break;
case 'editor':
$this->iCMS->config['autoformat'] && ($value = autoformat($value));
break;
default:
$value = dhtmlspecialchars($value);
}
}
WordFilter($value) && javascript::alert($field . '字段包含被系统屏蔽的字符，请返回重新填写。');
$content[$field] = $value;
$PF[] = $field;
}
}
if (empty($content['clink'])) {
include iPATH . 'include/cn.class.php';
$content['clink'] = CN::pinyin($content['title'], $this->iCMS->config['CLsplit']);
}
$table = model::tbn($_POST['table']);
$MF = explode(',', $model['field']);
$diff = array_diff_values($PF, $MF);
if ($diff['-']) {
foreach ($diff['-'] as $field) {
$content[$field] = '';
}
}
//缺少的字段 填认空值
$SELFURL = __SELF__ . (empty($_POST['REFERER']) ? '?mo=content&do=manage' : $_POST['REFERER']);
$forum = new forum();
if (empty($id)) {
empty($content['userid']) && ($content['userid'] = member::$uId);
$content['hits'] = $content['good'] = $content['bad'] = $content['comments'] = 0;
$content['status'] = "1";
$checkCL = iCMS_DB::getValue("SELECT `id` FROM `#iCMS@__{$table}` where `clink` ='" . $content['clink'] . "'");
if ($this->iCMS->config['repeatitle']) {
iCMS_DB::getValue("SELECT `id` FROM `#iCMS@__{$table}` where `title` = '{$title}'") && alert('该标题内容已经存在!请检查是否重复');
$checkCL && javascript::alert('该自定链接已经存在!请另选一个');
} else {
$checkCL && ($clink .= $this->iCMS->config['CLsplit'] . random(6, 1));
}
iCMS_DB::insert($table, $content);
$id = iCMS_DB::$insert_id;
model::upload($table, $id, $title);
iTAG::add($content['tags'], $content['userid'], $id, $forum->rootid($fid), $mid);
$vlink = empty($content['vlink']) ? $fid : $content['vlink'] . ',' . $fid;
vlinkDiff($vlink, '', $id, $mid);
if (!strstr($forum->forum[$fid]['contentRule'], '{PHP}') && !$forum->forum[$fid]['url'] && $forum->forum[$fid]['mode'] == "1" && $content['status']) {
include iPATH . 'include/iHtml.class.php';
iHtml::content($id, $mid, $table);
iHtml::forum($fid, 1, 0, 1);
}
iCMS_DB::query("UPDATE `#iCMS@__forum` SET `count` = count+1 WHERE `fid` ='{$fid}' LIMIT 1 ");
// $moreaction=array(
// array("text"=>"编辑该内容","url"=>__SELF__."?do=content&operation=add&table=".$table."&mid=".$mid."&id=".$id),
// array("text"=>"继续添加内容","url"=>__SELF__."?do=content&operation=add&table=".$table."&mid=".$mid."&cid=".$cid),
// array("text"=>"查看该内容","url"=>$iCMS->iurl('content',array('mId'=>$mid,'id'=>$id,'link'=>$clink,'pubdate'=>$pubdate,'cid'=>$cid,'dir'=>$catalog->catalog[$cid]['dir'],'domain'=>$catalog->catalog[$cid]['domain'],'htmlext'=>$catalog->catalog[$cid]['htmlext']))->href,"o"=>'target="_blank"'),
// array("text"=>"查看网站首页","url"=>"../index.php","o"=>'target="_blank"')
// );
javascript::dialog("添加完成!", 'url:' . __SELF__ . "?mo=content&do=manage&table=" . $table . "&mid=" . $mid);
} else {
$checkCL = iCMS_DB::getValue("SELECT `id` FROM `#iCMS@__{$table}` where `clink` ='{$clink}' AND `id` !='{$id}'");
if ($this->iCMS->config['repeatitle']) {
$checkCL && alert('该自定链接已经存在!请另选一个');
} else {
$checkCL && ($clink .= $this->iCMS->config['CLsplit'] . random(6, 1));
}
$art = iCMS_DB::getRow("SELECT `fid`,`tags`,`vlink` FROM `#iCMS@__{$table}` where `id` ='{$id}'");
iTAG::diff($content['tags'], member::$uId, $art->tags, $id, $forum->rootid($fid));
iCMS_DB::update($table, $content, array('id' => $id));
model::upload($table, $id, $title);
$vlink = empty($content['vlink']) ? $fid : $content['vlink'] . ',' . $fid;
vlinkDiff($vlink, $art->vlink, $id);
if (!strstr($forum->forum[$fid]['contentRule'], '{PHP}') && !$forum->forum[$fid]['url'] && $forum->forum[$fid]['mode'] == "1" && $status) {
include iPATH . 'include/iHtml.class.php';
iHtml::content($id, $mid, $table);
iHtml::forum($fid, 1, 0, 1);
}
if ($art->fid != $fid) {
iCMS_DB::query("UPDATE `#iCMS@__forum` SET `count` = count-1 WHERE `fid` ='{$art->fid}' LIMIT 1 ");
iCMS_DB::query("UPDATE `#iCMS@__forum` SET `count` = count+1 WHERE `fid` ='{$fid}' LIMIT 1 ");
}
javascript::dialog('编辑完成!<br />3秒后返回项目列表', 'url:' . $SELFURL);
}
}
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;
}