$db->BeginTrans();
if (strlen(trim($_POST['keywords'])) != 0) {
$keys = explode('|', $_POST['keywords']);
$key_id = array();
$sql = "delete from {$tbl_object_keywords} where object_id = " . intval($_POST['id']);
if (!$db->Execute($sql)) {
alert("关键字更改失败2");
$db->RollbackTrans();
exit;
}
foreach ($keys as $key) {
if (strlen(trim($key))) {
$sql = "select keyword_id from {$tbl_keywords} where keyword = '" . $key . "'";
$id = $db->GetOne($sql);
if (!$id) {
$id = GetSeq();
$sql = "insert into {$tbl_keywords} (keyword_id,keyword) values ({$id},'{$key}')";
if (!$db->Execute($sql)) {
alert("关键字更改失败1");
$db->RollbackTrans();
exit;
}
}
array_push($key_id, $id);
}
}
$stmt = $db->Prepare("insert into {$tbl_object_keywords} (class_id,object_id,keyword_id) values (1," . intval($_POST['id']) . ",?)");
foreach ($key_id as $keyid) {
if (!$db->Execute($stmt, $keyid)) {
alert("关键字更改失败3");
$db->RollbackTrans();
$tbl_articlelink = $cfg['tbl_articlelink'];
$tbl_keywords = $cfg['tbl_keywords'];
$tbl_object_keywords = $cfg['tbl_object_keywords'];
if (isset($_GET['catalog_id'])) {
$catalog = intval($_GET['catalog_id']);
} else {
$catalog = intval($_POST['catalog_id']);
}
$sql = "select id,name,contrib from {$tbl_columns} where id = {$catalog}";
$column = $db->GetRow($sql);
if (!$column || !$column['contrib']) {
alert("当前栏目不允许投稿");
exit;
}
if (!isset($_POST['postflag'])) {
$object_id = GetSeq();
$article['catalog'] = $catalog;
$article['id'] = intval($object_id);
$smarty->assign("data", $article);
$smarty->assign("catalog", $column);
$smarty->assign("flow_basedir", $cfg['flow_basedir']);
$smarty->display("contribute_edit.html");
} else {
if (!isset($_POST['heading']) || strlen(trim($_POST['heading'])) == 0) {
alert("必须有文章标题");
exit;
}
$sql = "select * from {$tbl_article} where 0";
$rs = $db->Execute($sql);
$_POST['dt'] = date("Y-m-d");
$_POST['catalog'] = $catalog;
