function dowork($id, $job)
{
global $db, $_pre, $timestamp, $userdb, $webdb, $Fid_db;
$RS = $db->get_one("SELECT fid FROM {$_pre}db WHERE id='{$id}'");
$_erp = $Fid_db[tableid][$RS[fid]];
$rsdb = $db->get_one("SELECT * FROM {$_pre}content{$_erp} WHERE id='{$id}' ");
if ($job == "delete") {
del_info($id, $_erp, $rsdb);
//$db->query(" UPDATE `{$_pre}sort` SET contents=contents-1 WHERE fid='$rsdb[fid]' ");
//$db->query(" UPDATE `{$_pre}sort` SET contents=contents-1 WHERE fid='$fidDB[fup]' ");
} elseif ($job == "move") {
global $fid;
if ($fid) {
$rs = $db->get_one("SELECT name,mid FROM {$_pre}sort WHERE fid='{$fid}'");
if ($rs[mid] == $rsdb[mid]) {
$db->query("UPDATE {$_pre}content{$_erp} SET fid='{$fid}',fname='{$rs['name']}',lastfid='{$rsdb['fid']}' WHERE id='{$id}' ");
$db->query("UPDATE {$_pre}content_{$rsdb['mid']} SET fid='{$fid}' WHERE id='{$id}' ");
}
}
} elseif ($job == "color") {
global $color;
$db->query("UPDATE {$_pre}content{$_erp} SET titlecolor='{$color}' WHERE id='{$id}' ");
} elseif ($job == "yz") {
$db->query("UPDATE {$_pre}content{$_erp} SET yz='1' WHERE id='{$id}' ");
} elseif ($job == "unyz") {
$db->query("UPDATE {$_pre}content{$_erp} SET yz='0' WHERE id='{$id}' ");
} elseif ($job == "undel") {
$db->query("UPDATE {$_pre}content{$_erp} SET yz='1' WHERE id='{$id}' ");
} elseif ($job == "com") {
global $levels;
if ($levels == 1) {
$SQL = ",yz=1";
}
$db->query("UPDATE {$_pre}content{$_erp} SET levels='{$levels}',levelstime='{$timestamp}'{$SQL} WHERE id='{$id}' ");
} elseif ($job == "uncom") {
$db->query("UPDATE {$_pre}content{$_erp} SET levels='0',levelstime='0' WHERE id='{$id}' ");
} elseif ($job == "unyz") {
$db->query("UPDATE {$_pre}content{$_erp} SET levels='0',levelstime='0' WHERE id='{$id}' ");
} elseif ($job == "top") {
global $toptime;
$db->query("UPDATE {$_pre}content{$_erp} SET list=list+'{$toptime}' WHERE id='{$id}' ");
} elseif ($job == "untop") {
$db->query("UPDATE {$_pre}content{$_erp} SET list='{$timestamp}' WHERE id='{$id}' ");
} elseif ($job == "front") {
global $topid;
if ($topid) {
$rs = $db->get_one("SELECT list FROM {$_pre}content{$_erp} WHERE id='{$topid}' ");
$list = $rs["list"] + 1;
$db->query("UPDATE {$_pre}content{$_erp} SET list='{$list}' WHERE id='{$id}' ");
} else {
$db->query("UPDATE {$_pre}content{$_erp} SET list='{$timestamp}' WHERE id='{$id}' ");
}
} elseif ($job == "bottom") {
global $bottomid;
if ($bottomid) {
$rs = $db->get_one("SELECT list FROM {$_pre}content{$_erp} WHERE id='{$bottomid}' ");
$list = $rs["list"] - 1;
$db->query("UPDATE {$_pre}content{$_erp} SET list='{$list}' WHERE id='{$id}' ");
} else {
$db->query("UPDATE {$_pre}content{$_erp} SET list='0' WHERE id='{$id}' ");
}
} elseif ($job == "punish") {
global $Type;
if ($Type == 1) {
add_user($rsdb[uid], -abs($webdb[ErrSortMoney]), '信息奖励');
} elseif ($Type == 2) {
add_user($rsdb[uid], -abs($webdb[illInfoMoney]), '信息扣分');
}
}
}
foreach ($field_db as $key => $value) {
isset($postdb[$key]) && ($sqldb[] = "`{$key}`='{$postdb[$key]}'");
}
$sql = implode(",", $sqldb);
/*往辅信息表插入内容*/
$db->query("INSERT INTO `{$_pre}content_{$fidDB['mid']}` SET {$sql}");
refreshto($FROMURL, "<a href='{$FROMURL}'>继续发布</a> <a href='../bencandy.php?fid={$fid}&id={$id}' target='_blank'>查看效果</a>", 600);
} elseif ($action == "del") {
$rsdb = $db->get_one("SELECT A.*,B.* FROM `{$_pre}content` A LEFT JOIN `{$_pre}content_{$fidDB['mid']}` B ON A.id=B.id WHERE A.id='{$id}'");
if ($rsdb[fid] != $fidDB[fid]) {
showerr("栏目有问题");
}
if ($rsdb[uid] != $lfjuid && !$web_admin) {
showerr("你没权限!");
}
del_info($id, $rsdb);
refreshto($FROMURL, "删除成功");
} elseif ($job == "edit") {
$rsdb = $db->get_one("SELECT B.*,A.* FROM `{$_pre}content` A LEFT JOIN `{$_pre}content_{$fidDB['mid']}` B ON A.id=B.id WHERE A.id='{$id}'");
if ($rsdb[uid] != $lfjuid && !$web_admin) {
showerr('你没权限!');
}
/*表单默认变量作处理*/
$Module_db->formGetVale($field_db, $rsdb);
$atc = "edit";
require ROOT_PATH . "member/head.php";
require getTpl("post_{$fidDB['mid']}", $FidTpl['post']);
require ROOT_PATH . "member/foot.php";
} elseif ($action == "edit") {
$rsdb = $db->get_one("SELECT A.*,B.* FROM `{$_pre}content` A LEFT JOIN `{$_pre}content_{$fidDB['mid']}` B ON A.id=B.id WHERE A.id='{$id}'");
if ($rsdb[uid] != $lfjuid && !$web_admin) {
foreach ($field_db as $key => $value) {
isset($postdb[$key]) && ($sqldb[] = "`{$key}`='{$postdb[$key]}'");
}
$sql = implode(",", $sqldb);
/*往辅信息表插入内容*/
$db->query("INSERT INTO `{$_pre}content_{$fidDB['mid']}` SET {$sql}");
refreshto($FROMURL, "<a href='{$FROMURL}'>继续发布</a> <a href='../bencandy.php?fid={$fid}&id={$id}' target='_blank'>查看效果</a>", 600);
} elseif ($action == "del") {
$_erp = $Fid_db[tableid][$fid];
$rsdb = $db->get_one("SELECT A.*,B.* FROM `{$_pre}content{$_erp}` A LEFT JOIN `{$_pre}content_{$fidDB['mid']}` B ON A.id=B.id WHERE A.id='{$id}'");
if ($rsdb[fid] != $fidDB[fid]) {
showerr("栏目有问题");
} elseif ($rsdb[uid] != $lfjuid && !$web_admin && !in_array($lfjid, explode(",", $fidDB[admin]))) {
showerr("你没权限!");
}
del_info($id, $_erp, $rsdb);
if ($rsdb[yz]) {
add_user($lfjdb[uid], -$webdb[PostInfoMoney], '删除信息扣分');
}
refreshto("list.php", "删除成功");
} elseif ($job == "edit") {
$_erp = $Fid_db[tableid][$fid];
$rsdb = $db->get_one("SELECT B.*,A.* FROM `{$_pre}content{$_erp}` A LEFT JOIN `{$_pre}content_{$fidDB['mid']}` B ON A.id=B.id WHERE A.id='{$id}'");
if ($rsdb[uid] != $lfjuid && !$web_admin && !in_array($lfjid, explode(",", $fidDB[admin]))) {
showerr('你没权限!');
}
/*表单默认变量作处理*/
$Module_db->formGetVale($field_db, $rsdb);
$atc = "edit";
$rsdb['list'] > $timestamp ? $ifTop[1] = ' checked ' : ($ifTop[0] = ' checked ');
$rsdb[price] == 0 && ($rsdb[price] = '');
$rs = $db->get_one("SELECT S.admin,S.fid,A.uid,A.mid FROM {$_pre}content{$_erp} A LEFT JOIN {$_pre}sort S ON A.fid=S.fid WHERE A.id='{$id}'");
$detail = @explode(",", $rs[admin]);
if ($rs[uid] == $lfjuid) {
$power = 1;
} elseif ($lfjid && @in_array($lfjid, $detail)) {
$power = 2;
} else {
$power = 0;
}
}
if ($power == 0) {
die("ÄãÎÞȨ²Ù×÷");
}
if ($step == 2) {
if ($action == "del") {
del_info($id, $_erp, $rs);
$rs[url] = get_info_url('', $rs[fid], $rs[city_id]);
refreshto($rs[url], "ɾ³ý³É¹¦", 1);
} elseif ($action == "levels" && $power == 2) {
$db->query("UPDATE {$_pre}content{$_erp} SET levels='{$levels}' WHERE id='{$id}'");
refreshto("{$FROMURL}", "²Ù×÷³É¹¦", 1);
} elseif ($action == "yz" && $power == 2) {
$db->query("UPDATE {$_pre}content{$_erp} SET yz='{$yz}' WHERE id='{$id}'");
refreshto("{$FROMURL}", "²Ù×÷³É¹¦", 1);
} elseif ($action == "top" && $power == 2) {
$db->query("UPDATE {$_pre}content{$_erp} SET list='{$top}' WHERE id='{$id}'");
refreshto("{$FROMURL}", "²Ù×÷³É¹¦", 1);
}
} else {
$rs = $db->get_one("SELECT * FROM {$_pre}content{$_erp} WHERE id='{$id}'");
echo "<A HREF=\"{$city_url}/post.php?job=edit&fid={$fid}&id={$id}\">ÐÞ¸Ä</A><br><A HREF=\"{$city_url}/post.php?action=del&fid={$fid}&id={$id}\" onclick=\"return confirm('ÄãÈ·ÈÏҪɾ³ýÂð?');\">ɾ³ý</A><br>";
