function EditNews($add, $userid, $username) { global $empire, $class_r, $class_zr, $bclassid, $public_r, $dbtbpre, $emod_r; $add[classid] = (int) $add[classid]; $userid = (int) $userid; $add[id] = (int) $add[id]; if (!$add[id] || !$add[title] || !$add[classid] || !$add[filename]) { printerror("EmptyTitle", "history.go(-1)"); } $doselfinfo = CheckLevel($userid, $username, $add[classid], "news"); //操作权限 if (!$doselfinfo['doeditinfo']) { printerror("NotEditInfoLevel", "history.go(-1)"); } $ccr = $empire->fetch1("select classid,modid,listdt,haddlist,sametitle,addreinfo,wburl,repreinfo from {$dbtbpre}enewsclass where classid='{$add['classid']}' and islast=1 limit 1"); if (!$ccr['classid'] || $ccr['wburl']) { printerror("ErrorUrl", "history.go(-1)"); } //索引表 $index_checkr = $empire->fetch1("select id,classid,checked from {$dbtbpre}ecms_" . $class_r[$add[classid]][tbname] . "_index where id='{$add['id']}' limit 1"); if (!$index_checkr['id'] || $index_checkr['classid'] != $add['classid']) { printerror("ErrorUrl", "history.go(-1)"); } //主表 $infotb = ReturnInfoMainTbname($class_r[$add[classid]][tbname], $index_checkr['checked']); $checkr = $empire->fetch1("select id,classid,userid,username,ismember,stb,newspath,filename,isqf,fstb,isgood,firsttitle,istop from " . $infotb . " where id='{$add['id']}' limit 1"); if ($doselfinfo['doselfinfo'] && ($checkr['userid'] != $userid || $checkr['ismember'])) { printerror("NotDoSelfinfo", "history.go(-1)"); } //已审核信息不可修改 if ($doselfinfo['docheckedit'] && $index_checkr['checked']) { printerror("NotEditCheckInfoLevel", "history.go(-1)"); } //审核权限 if (!$doselfinfo['docheckinfo']) { $add['checked'] = $index_checkr['checked']; } //必须审核 if ($doselfinfo['domustcheck'] && !$index_checkr['checked']) { $add['checked'] = 0; } //推荐权限 if (!$doselfinfo['dogoodinfo']) { $add['isgood'] = $checkr['isgood']; $add['firsttitle'] = $checkr['firsttitle']; $add['istop'] = $checkr['istop']; } if ($ccr['sametitle']) { if (ReturnCheckRetitle($add)) { printerror("ReInfoTitle", "history.go(-1)"); } } //公共表 $pubid = ReturnInfoPubid($add['classid'], $add['id']); $pubcheckr = $empire->fetch1("select copyids from {$dbtbpre}enewsinfovote where pubid='{$pubid}' limit 1"); $mid = $class_r[$add[classid]][modid]; $pf = $emod_r[$mid]['pagef']; $add = DoPostInfoVar($add); //返回变量 $add['fstb'] = $checkr['fstb']; $ret_r = ReturnAddF($add, $class_r[$add[classid]][modid], $userid, $username, 1, 0, 1); //返回自定义字段 $deloldfile = 0; if ($add[groupid] != $add[oldgroupid] || $index_checkr['checked'] && !$add[checked]) { DelNewsFile($checkr[filename], $checkr[newspath], $add[classid], $add[$pf], $add[oldgroupid]); //删除旧的文件 $deloldfile = 1; } //签发 $newchecked = $index_checkr['checked']; $a = ''; if ($class_r[$add[classid]][wfid] && $checkr['isqf']) { $qfr = $empire->fetch1("select checktno from {$dbtbpre}enewswfinfo where id='{$add['id']}' and classid='{$add['classid']}' limit 1"); if ($qfr['checktno'] == '100') { $aqf = ",checked='{$add['checked']}'"; $newchecked = $add[checked]; } else { if ($add[reworkflow]) { InfoUpdateToWorkflow($add[id], $add[classid], $class_r[$add[classid]][wfid], $userid, $username); } $aqf = ''; } } else { $aqf = ",checked='{$add['checked']}'"; $newchecked = $add[checked]; } //日期目录 $updatefile = ''; $urlnewspath = $checkr['newspath']; if ($add['newspath'] != $checkr[newspath]) { $add[newspath] = FormatPath($add[classid], $add[newspath], 1); //查看目录是否存在,不存在则建立 $updatefile .= ",newspath='{$add['newspath']}'"; if ($deloldfile == 0) { DelNewsFile($checkr[filename], $checkr[newspath], $add[classid], $add[$pf], $add[oldgroupid]); //删除旧文件 $deloldfile = 1; } $urlnewspath = $add['newspath']; } //文件名 $urlfilename = $checkr['filename']; if ($add['filename'] && $add['filename'] != $checkr[filename]) { $newfilename = $add['filename']; $updatefile .= ",filename='{$newfilename}'"; if ($deloldfile == 0) { DelNewsFile($checkr[filename], $checkr[newspath], $add[classid], $add[$pf], $add[oldgroupid]); //删除旧文件 $deloldfile = 1; } $urlfilename = $newfilename; } $newstime = empty($add['newstime']) ? time() : to_time($add['newstime']); $lastdotime = time(); //返回关键字组合 if ($add['info_diyotherlink']) { $keyid = DoPostDiyOtherlinkID($add['info_keyid']); } else { $keyid = GetKeyid($add[keyboard], $add[classid], $add[id], $class_r[$add[classid]][link_num]); } //附加链接参数 $addecmscheck = empty($newchecked) ? '&ecmscheck=1' : ''; //信息地址 $infourl = GotoGetTitleUrl($add['classid'], $add['id'], $urlnewspath, $urlfilename, $add['groupid'], $add['isurl'], $add['titleurl']); //返回表信息 $infotbr = ReturnInfoTbname($class_r[$add[classid]][tbname], $index_checkr['checked'], $checkr['stb']); //索引表 $indexsql = $empire->query("update {$dbtbpre}ecms_" . $class_r[$add[classid]][tbname] . "_index set newstime='{$newstime}',lastdotime='{$lastdotime}'" . $aqf . " where id='{$add['id']}' limit 1"); //主表 $sql = $empire->query("update " . $infotbr['tbname'] . " set classid='{$add['classid']}',ttid='{$add['ttid']}',onclick='{$add['onclick']}',totaldown='{$add['totaldown']}',firsttitle={$add['firsttitle']},isgood={$add['isgood']},ispic='{$add['ispic']}',istop={$add['istop']},isurl='{$add['isurl']}',lastdotime={$lastdotime},groupid={$add['groupid']},userfen={$add['userfen']},titlefont='" . addslashes($add[my_titlefont]) . "',titleurl='" . addslashes($infourl) . "',keyboard='" . addslashes($add[keyboard]) . "'" . $updatefile . $ret_r[values] . " where id='{$add['id']}' limit 1"); //副表 $stb = $checkr['stb']; $fsql = $empire->query("update " . $infotbr['datatbname'] . " set classid='{$add['classid']}',keyid='{$keyid}',dokey={$add['dokey']},newstempid={$add['newstempid']},closepl={$add['closepl']},infotags='" . addslashes($add[infotags]) . "'" . $ret_r[datavalues] . " where id='{$add['id']}' limit 1"); //取第一张图作为标题图片 if ($add['getfirsttitlepic'] && empty($add['titlepic'])) { $firsttitlepic = GetFpicToTpic($add['classid'], $add['id'], $add['getfirsttitlepic'], $add['getfirsttitlespic'], $add['getfirsttitlespicw'], $add['getfirsttitlespich'], $checkr['fstb']); if ($firsttitlepic) { $usql = $empire->query("update " . $infotbr['tbname'] . " set titlepic='" . addslashes($firsttitlepic) . "',ispic=1 where id='{$add['id']}'"); } } //更新附件 UpdateTheFileEdit($add['classid'], $add['id'], $checkr['fstb']); //替换图片下一页 if ($add['repimgnexturl']) { UpdateImgNexturl($add['classid'], $add['id'], $index_checkr['checked']); } //投票 AddInfoVote($add['classid'], $add['id'], $add); //写入专题 InsertZtInfo($add['ztids'], $add['zcids'], $add['oldztids'], $add['oldzcids'], $add['classid'], $add['id'], $newstime); //TAGS if ($add[infotags] && $add[infotags] != $add[oldinfotags]) { eInsertTags($add[infotags], $add['classid'], $add['id'], $newstime); } //是否改变审核状态 if ($index_checkr['checked'] != $newchecked) { MoveCheckInfoData($class_r[$add[classid]][tbname], $index_checkr['checked'], $checkr['stb'], "id='{$add['id']}'"); //更新栏目信息数 if ($newchecked) { AddClassInfos($add['classid'], '', '+1'); } else { AddClassInfos($add['classid'], '', '-1'); } } //生成文件 if ($ccr['addreinfo'] && $newchecked) { GetHtml($add['classid'], $add['id'], '', 0); } //生成上一篇 if ($ccr['repreinfo'] && ($newchecked || $newchecked != $add[oldchecked])) { $prer = $empire->fetch1("select * from {$dbtbpre}ecms_" . $class_r[$add[classid]][tbname] . " where id<{$add['id']} and classid='{$add['classid']}' order by id desc limit 1"); GetHtml($prer['classid'], $prer['id'], $prer, 1); } //生成栏目 if ($ccr['haddlist'] && ($newchecked || $newchecked != $add[oldchecked])) { hAddListHtml($add[classid], $ccr['modid'], $ccr['haddlist'], $ccr['listdt']); //生成信息列表 if ($add['ttid']) { ListHtml($add['ttid'], '', 5); } //改变标题分类 if ($add['oldttid'] && $add['ttid'] != $add['oldttid']) { ListHtml($add['oldttid'], '', 5); } } //同时更新 if ($pubcheckr['copyids'] && $pubcheckr['copyids'] != '1') { EditInfoToCopyInfo($add[classid], $add[id], $userid, $username, $doselfinfo); } else { $copyclassid = $add[copyclassid]; $cpcount = count($copyclassid); if ($cpcount) { $copyids = AddInfoToCopyInfo($add[classid], $add[id], $copyclassid, $userid, $username, $doselfinfo); if ($copyids) { UpdateInfoCopyids($add['classid'], $add['id'], $copyids); } } } if ($sql) { //返回地址 if ($add['ecmsfrom'] && (stristr($add['ecmsfrom'], 'ListNews.php') || stristr($add['ecmsfrom'], 'ListAllInfo.php'))) { $ecmsfrom = $add['ecmsfrom']; } else { $ecmsfrom = "ListNews.php?bclassid={$add['bclassid']}&classid={$add['classid']}" . hReturnEcmsHashStrHref2(0); } insert_dolog("classid={$add['classid']}<br>id=" . $add[id] . "<br>title=" . $add[title], $pubid); //操作日志 printerror("EditNewsSuccess", $ecmsfrom . $addecmscheck); } else { printerror("DbError", "history.go(-1)"); } }
} else { $voteid = $_POST['voteid']; $vote = $_POST['vote']; } AddVote($voteid, $vote); } elseif ($enews == 'AddInfoVote') { if ($_GET['id']) { $id = $_GET['id']; $classid = $_GET['classid']; $vote = $_GET['vote']; } else { $id = $_POST['id']; $classid = $_POST['classid']; $vote = $_POST['vote']; } AddInfoVote($classid, $id, $vote); } elseif ($enews == 'AddInfoPfen') { if ($_GET['id']) { $add = $_GET; } else { $add = $_POST; } AddInfoPfen($add); } elseif ($enews == "AddGbook") { AddGbook($_POST); } elseif ($enews == "AddFeedback") { $doetran = 1; AddFeedback($_POST); } elseif ($enews == "AddError") { AddError($_POST); } else {
function EditNews($add, $userid, $username) { global $empire, $class_r, $class_zr, $bclassid, $public_r, $dbtbpre, $emod_r; $add[classid] = (int) $add[classid]; $userid = (int) $userid; $ztid = $add[ztid]; $add[id] = (int) $add[id]; if (!$add[id] || !$add[title] || !$add[classid] || !$add[filename]) { printerror("EmptyTitle", "history.go(-1)"); } $doselfinfo = CheckLevel($userid, $username, $add[classid], "news"); //操作权限 if (!$doselfinfo['doeditinfo']) { printerror("NotEditInfoLevel", "history.go(-1)"); } $ccr = $empire->fetch1("select classid,modid,listdt,haddlist,sametitle,addreinfo,wburl,repreinfo from {$dbtbpre}enewsclass where classid='{$add['classid']}' and islast=1"); if (!$ccr['classid'] || $ccr[wburl]) { printerror("ErrorUrl", "history.go(-1)"); } $checkr = $empire->fetch1("select id,userid,username,ismember,stb,copyids,newspath,filename,isqf,checked from {$dbtbpre}ecms_" . $class_r[$add[classid]][tbname] . " where id='{$add['id']}' and classid='{$add['classid']}'"); if (!$checkr[id]) { printerror("ErrorUrl", "history.go(-1)"); } if ($doselfinfo['doselfinfo'] && ($checkr[userid] != $userid || $checkr[ismember])) { printerror("NotDoSelfinfo", "history.go(-1)"); } if ($ccr['sametitle']) { $num = $empire->gettotal("select count(*) as total from {$dbtbpre}ecms_" . $class_r[$add[classid]][tbname] . " where title='{$add['title']}' and id<>{$add['id']} limit 1"); if ($num) { printerror("ReInfoTitle", "history.go(-1)"); } } $mid = $class_r[$add[classid]][modid]; $pf = $emod_r[$mid]['pagef']; $add = DoPostInfoVar($add); //返回变量 $ret_r = ReturnAddF($add, $class_r[$add[classid]][modid], $userid, $username, 1, 0, 1); //返回自定义字段 $deloldfile = 0; if ($add[groupid] != $add[oldgroupid] || $checkr['checked'] && !$add[checked]) { DelNewsFile($checkr[filename], $checkr[newspath], $add[classid], $add[$pf], $add[oldgroupid]); //删除旧的文件 $deloldfile = 1; } //签发 $a = ''; if ($class_r[$add[classid]][wfid] && $checkr['isqf']) { $qfr = $empire->fetch1("select checktno from {$dbtbpre}enewswfinfo where id='{$add['id']}' and classid='{$add['classid']}' limit 1"); if ($qfr['checktno'] == '100') { $aqf = ",checked='{$add['checked']}'"; } else { if ($add[reworkflow]) { InfoUpdateToWorkflow($add[id], $add[classid], $class_r[$add[classid]][wfid], $userid, $username); } $aqf = ''; } } else { $aqf = ",checked='{$add['checked']}'"; } //日期目录 $updatefile = ''; if ($add['newspath'] != $checkr[newspath]) { $add[newspath] = FormatPath($add[classid], $add[newspath], 1); //查看目录是否存在,不存在则建立 $updatefile .= ",newspath='{$add['newspath']}'"; if ($deloldfile == 0) { DelNewsFile($checkr[filename], $checkr[newspath], $add[classid], $add[$pf], $add[oldgroupid]); //删除旧文件 $deloldfile = 1; } } //文件名 if ($add['filename'] && $add['filename'] != $checkr[filename]) { $newfilename = $add['filename']; $updatefile .= ",filename='{$newfilename}'"; if ($deloldfile == 0) { DelNewsFile($checkr[filename], $checkr[newspath], $add[classid], $add[$pf], $add[oldgroupid]); //删除旧文件 $deloldfile = 1; } } $lastdotime = time(); //返回关键字组合 if ($add['info_diyotherlink']) { $keyid = DoPostDiyOtherlinkID($add['info_keyid']); } else { $keyid = GetKeyid($add[keyboard], $add[classid], $add[id], $class_r[$add[classid]][link_num]); } //主表 $sql = $empire->query("update {$dbtbpre}ecms_" . $class_r[$add[classid]][tbname] . " set classid='{$add['classid']}',keyboard='" . addslashes($add[keyboard]) . "',keyid='{$keyid}',ztid='{$add['my_ztid']}',istop={$add['istop']},dokey={$add['dokey']},isgood={$add['isgood']},titlefont='" . addslashes($add[my_titlefont]) . "',titleurl='" . addslashes($add[titleurl]) . "',groupid={$add['groupid']},newstempid={$add['newstempid']},firsttitle={$add['firsttitle']},userfen={$add['userfen']},closepl={$add['closepl']},lastdotime={$lastdotime},ttid='{$add['ttid']}',onclick='{$add['onclick']}',totaldown='{$add['totaldown']}',infotags='" . addslashes($add[infotags]) . "',ispic='{$add['ispic']}'" . $updatefile . $aqf . $ret_r[values] . " where id='{$add['id']}'"); //副表 $stb = $checkr['stb']; $fsql = $empire->query("update {$dbtbpre}ecms_" . $class_r[$add[classid]][tbname] . "_data_" . $stb . " set classid='{$add['classid']}'" . $ret_r[datavalues] . " where id='{$add['id']}'"); //取第一张图作为标题图片 if ($add['getfirsttitlepic'] && empty($add['titlepic'])) { $firsttitlepic = GetFpicToTpic($add['classid'], $add['id'], $add['getfirsttitlepic'], $add['getfirsttitlespic'], $add['getfirsttitlespicw'], $add['getfirsttitlespich']); if ($firsttitlepic) { $usql = $empire->query("update {$dbtbpre}ecms_" . $class_r[$add[classid]][tbname] . " set titlepic='" . addslashes($firsttitlepic) . "',ispic=1 where id='{$add['id']}'"); } } //更新附件 UpdateTheFileEdit($add['classid'], $add['id']); //替换图片下一页 if ($add['repimgnexturl']) { UpdateImgNexturl($add['classid'], $add['id']); } //投票 AddInfoVote($add['classid'], $add['id'], $add); //TAGS if ($add[infotags] && $add[infotags] != $add[oldinfotags]) { $tagtime = empty($add[newstime]) ? time() : to_time($add[newstime]); eInsertTags($add[infotags], $add['classid'], $add['id'], $tagtime); } //生成文件 if ($ccr['addreinfo']) { $ar = $empire->fetch1("select * from {$dbtbpre}ecms_" . $class_r[$add[classid]][tbname] . " where id='{$add['id']}'"); GetHtml($ar, ''); } //生成上一篇 if ($ccr['repreinfo'] && ($add[checked] || $add[checked] != $add[oldchecked])) { $prer = $empire->fetch1("select * from {$dbtbpre}ecms_" . $class_r[$add[classid]][tbname] . " where id<{$add['id']} and classid='{$add['classid']}' and checked=1 order by id desc limit 1"); GetHtml($prer, ''); } //生成栏目 if ($ccr['haddlist'] && ($add[checked] || $add[checked] != $add[oldchecked])) { hAddListHtml($add[classid], $ccr['modid'], $ccr['haddlist'], $ccr['listdt']); //生成信息列表 for ($z = 0; $z < count($ztid); $z++) { ListHtml(intval($ztid[$z]), '', 1); } //改变专题 $oldztid = $add[oldztid]; $myztid = $add['my_ztid']; if ($oldztid != $myztid && $oldztid) { $o_z = explode("|", $oldztid); for ($z = 1; $z < count($o_z) - 1; $z++) { $cr = explode("|" . $o_z[$z] . "|", $myztid); if ($cr == 1) { ListHtml(intval($o_z[$z]), '', 1); } } } } //同时更新 if ($checkr['copyids'] && $checkr['copyids'] != '1') { EditInfoToCopyInfo($add[classid], $add[id], $userid, $username); } else { $copyclassid = $add[copyclassid]; $cpcount = count($copyclassid); if ($cpcount) { $copyids = AddInfoToCopyInfo($add[classid], $add[id], $copyclassid, $userid, $username); if ($copyids) { $empire->query("update {$dbtbpre}ecms_" . $class_r[$add[classid]][tbname] . " set copyids='{$copyids}' where id='{$add['id']}'"); } } } if ($sql) { //返回地址 if ($add['ecmsfrom'] && (stristr($add['ecmsfrom'], 'ListNews.php') || stristr($add['ecmsfrom'], 'ListAllInfo.php'))) { $ecmsfrom = $add['ecmsfrom']; } else { $ecmsfrom = "ListNews.php?bclassid={$add['bclassid']}&classid={$add['classid']}"; } insert_dolog("classid={$add['classid']}<br>id=" . $add[id] . "<br>title=" . $add[title]); //操作日志 printerror("EditNewsSuccess", $ecmsfrom); } else { printerror("DbError", "history.go(-1)"); } }