Beispiel #1
0
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)");
    }
}
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)");
    }
}