function SpInfoReBak($add, $userid, $username)
{
global $empire, $dbtbpre;
$spid = (int) $add[spid];
$sid = (int) $add[sid];
$bid = (int) $add[bid];
if (!$spid || !$sid || !$bid) {
printerror('ErrorUrl', '');
}
//验证
$spr = CheckSpInfoLevel($spid);
if ($spr['sptype'] != 3) {
printerror('ErrorUrl', '');
}
$br = $empire->fetch1("select bid,sptext from {$dbtbpre}enewssp_3_bak where bid='{$bid}' and sid='{$sid}' and spid='{$spid}'");
if (!$br['bid']) {
printerror('ErrorUrl', '');
}
$sql = $empire->query("update {$dbtbpre}enewssp_3 set sptext='" . StripAddsData($br[sptext]) . "' where sid='{$sid}'");
if ($sql) {
//操作日志
insert_dolog("spid=" . $spid . "&spname=" . $spr[spname] . "<br>sid={$sid}&bid={$bid}");
echo "<script>opener.ReSpInfoBak();window.close();</script>";
exit;
} else {
printerror("DbError", "history.go(-1)");
}
}
function ReturnAddF($add, $modid, $userid, $username, $do = 0, $rdata = 0, $ch = 0)
{
global $empire, $public_r, $dbtbpre, $emod_r;
if ($do == 0 || $do == 1) {
//导入gd处理文件
if ($add['mark'] || $add['getfirsttitlespic'] || $add['mcreatespic']) {
include_once ECMS_PATH . 'e/class/gd.php';
}
}
$ret_r['tb'] = $emod_r[$modid]['deftb'];
$r = explode(',', $emod_r[$modid][enter]);
$count = count($r) - 1;
if (empty($do)) {
//数据库操作
for ($i = 1; $i < $count; $i++) {
$f = $r[$i];
if ($f == 'special.field' || !strstr($emod_r[$modid]['canaddf'], ',' . $f . ',')) {
continue;
}
$add[$f] = ReturnCheckboxAddF($add[$f], $modid, $f);
//复选框
$value = RepPhpAspJspcodeText($add[$f]);
if ($f == 'newstime') {
$value = empty($value) ? time() : to_time($value);
} elseif ($f == "morepic") {
$value = ReturnMorepicpath($add['msmallpic'], $add['mbigpic'], $add['mpicname'], $add['mdelpicid'], $add['mpicid'], $add, $add['mpicurl_qz'], 0);
} elseif ($f == "downpath") {
$value = ReturnDownpath($add['downname'], $add['downpath'], $add['delpathid'], $add['pathid'], $add['downuser'], $add['fen'], $add['thedownqz'], $add, $add['foruser'], $add['downurl_qz'], 0);
} elseif ($f == "onlinepath") {
$value = ReturnDownpath($add['odownname'], $add['odownpath'], $add['odelpathid'], $add['opathid'], $add['odownuser'], $add['ofen'], $add['othedownqz'], $add, $add['oforuser'], $add['onlineurl_qz'], 0);
} elseif ($f == "smalltext") {
if (!trim($value)) {
$value = SubSmalltextVal($add[newstext], $public_r[smalltextlen]);
//截取新闻内容
}
} elseif ($f == 'infoip') {
$value = egetip();
} elseif ($f == 'infozm') {
$value = $value ? $value : GetInfoZm($add[title]);
}
//处理函数
$value = DoFFun($modid, $f, $value, 1, 0);
//检测必填字段
if ($ch == 1 && empty($add['titleurl'])) {
ChMustAddF($modid, $f, $value);
ChIsOnlyAddF($modid, 0, $f, $value, 0);
//唯一值
}
//编辑器
if ($f == "newstext") {
//远程保存
$value = addslashes(CopyImg(stripSlashes($value), $add[copyimg], $add[copyflash], $add[classid], $add[qz_url], $username, $add['id'], $add['filepass'], $add['mark']));
//替换关键字和字符
$value = DoReplaceKeyAndWord($value, $add['dokey']);
//自动分页
if ($add[autopage] && !strstr($value, "[!--empirenews.page--]")) {
if (empty($add[autosize])) {
$add[autosize] = 5000;
}
$value = AutoDoPage($value, $add[autosize]);
}
}
//存文本
if ($emod_r[$modid]['savetxtf'] && $f == $emod_r[$modid]['savetxtf']) {
//建立目录
$thetxtfile = GetFileMd5();
$truevalue = MkDirTxtFile(date("Y/md"), $thetxtfile);
//写放文件
EditTxtFieldText($truevalue, $value);
$value = $truevalue;
}
if (strstr($emod_r[$modid]['tbdataf'], ',' . $f . ',')) {
$ret_r['datafields'] .= "," . $f;
$ret_r['datavalues'] .= ",'" . addslashes($value) . "'";
} else {
$ret_r['fields'] .= "," . $f;
$ret_r['values'] .= ",'" . addslashes($value) . "'";
}
}
} elseif ($do == 1) {
//数据库操作
for ($i = 1; $i < $count; $i++) {
$f = $r[$i];
if ($f == "special.field" || !strstr($emod_r[$modid]['caneditf'], ',' . $f . ',')) {
continue;
}
$add[$f] = ReturnCheckboxAddF($add[$f], $modid, $f);
//复选框
$value = RepPhpAspJspcodeText($add[$f]);
if ($f == 'newstime') {
$value = empty($value) ? time() : to_time($value);
} elseif ($f == "morepic") {
$value = ReturnMorepicpath($add['msmallpic'], $add['mbigpic'], $add['mpicname'], $add['mdelpicid'], $add['mpicid'], $add, $add['mpicurl_qz'], 1);
} elseif ($f == "downpath") {
$value = ReturnDownpath($add['downname'], $add['downpath'], $add['delpathid'], $add['pathid'], $add['downuser'], $add['fen'], $add['thedownqz'], $add, $add['foruser'], $add['downurl_qz'], 1);
} elseif ($f == "onlinepath") {
$value = ReturnDownpath($add['odownname'], $add['odownpath'], $add['odelpathid'], $add['opathid'], $add['odownuser'], $add['ofen'], $add['othedownqz'], $add, $add['oforuser'], $add['onlineurl_qz'], 1);
} elseif ($f == "smalltext") {
if (!trim($value)) {
$value = SubSmalltextVal($add[newstext], $public_r[smalltextlen]);
//截取新闻内容
}
} elseif ($f == 'infozm') {
$value = $value ? $value : GetInfoZm($add[title]);
}
//处理函数
$value = DoFFun($modid, $f, $value, 0, 0);
//检测必填字段
if ($ch == 1 && empty($add['titleurl'])) {
ChMustAddF($modid, $f, $value);
ChIsOnlyAddF($modid, $add[id], $f, $value, 0);
//唯一值
}
//数据同步
SameDataAddF($add[id], $add[classid], $modid, $f, $value);
//内容
if ($f == "newstext") {
//远程保存
$value = addslashes(CopyImg(stripSlashes($value), $add[copyimg], $add[copyflash], $add[classid], $add[qz_url], $username, $add['id'], $add['filepass'], $add['mark']));
//自动分页
if ($add[autopage] && !strstr($value, "[!--empirenews.page--]")) {
if (empty($add[autosize])) {
$add[autosize] = 5000;
}
$value = AutoDoPage($value, $add[autosize]);
}
}
//存文本
if ($emod_r[$modid]['savetxtf'] && $f == $emod_r[$modid]['savetxtf']) {
//建立目录
$newstexttxt_r = explode("/", $add[newstext_url]);
$thetxtfile = $newstexttxt_r[2];
$truevalue = MkDirTxtFile($newstexttxt_r[0] . "/" . $newstexttxt_r[1], $thetxtfile);
//写放文件
EditTxtFieldText($truevalue, $value);
$value = $truevalue;
}
if (strstr($emod_r[$modid]['tbdataf'], ',' . $f . ',')) {
$ret_r['datafields'] .= "," . $f;
$ret_r['datavalues'] .= "," . $f . "='" . addslashes($value) . "'";
} else {
$ret_r['fields'] .= "," . $f;
$ret_r['values'] .= "," . $f . "='" . addslashes($value) . "'";
}
}
} elseif ($do == 8) {
//数据库操作
for ($i = 1; $i < $count; $i++) {
$f = $r[$i];
if ($f == 'special.field') {
continue;
}
$value = $add[$f];
//存文本
if ($emod_r[$modid]['savetxtf'] && $f == $emod_r[$modid]['savetxtf']) {
//建立目录
$newstexttxt_r = explode("/", $add[newstext_url]);
$thetxtfile = $newstexttxt_r[2];
$truevalue = MkDirTxtFile($newstexttxt_r[0] . "/" . $newstexttxt_r[1], $thetxtfile);
//写放文件
EditTxtFieldText($truevalue, $value);
$value = $truevalue;
}
if (strstr($emod_r[$modid]['tbdataf'], ',' . $f . ',')) {
$ret_r['datafields'] .= "," . $f;
$ret_r['datavalues'] .= "," . $f . "='" . StripAddsData($value) . "'";
} else {
$ret_r['fields'] .= "," . $f;
$ret_r['values'] .= "," . $f . "='" . StripAddsData($value) . "'";
}
}
} elseif ($do == 9) {
//数据库操作
for ($i = 1; $i < $count; $i++) {
$f = $r[$i];
if ($f == 'special.field') {
continue;
}
$value = $add[$f];
//存文本
if ($emod_r[$modid]['savetxtf'] && $f == $emod_r[$modid]['savetxtf']) {
//建立目录
$thetxtfile = GetFileMd5();
$truevalue = MkDirTxtFile(date("Y/md"), $thetxtfile);
//写放文件
EditTxtFieldText($truevalue, $value);
$value = $truevalue;
}
if (strstr($emod_r[$modid]['tbdataf'], ',' . $f . ',')) {
$ret_r['datafields'] .= "," . $f;
$ret_r['datavalues'] .= ",'" . StripAddsData($value) . "'";
} else {
$ret_r['fields'] .= "," . $f;
$ret_r['values'] .= ",'" . StripAddsData($value) . "'";
}
}
} elseif ($do == 10) {
//数据库操作
for ($i = 1; $i < $count; $i++) {
$f = $r[$i];
if ($f == 'special.field') {
continue;
}
$value = $add[$f];
if (strstr($emod_r[$modid]['tbdataf'], ',' . $f . ',')) {
$ret_r['datafields'] .= "," . $f;
$ret_r['datavalues'] .= ",'" . StripAddsData($value) . "'";
} else {
$ret_r['fields'] .= "," . $f;
$ret_r['values'] .= ",'" . StripAddsData($value) . "'";
}
}
}
return $ret_r;
}
function DoDocInfo($tb, $r, $ecms = 0)
{
global $empire, $dbtbpre, $class_r, $emod_r;
if ($ecms == 1) {
$table = $dbtbpre . 'ecms_' . $tb . '_doc_index';
//索引表
$table1 = $dbtbpre . 'ecms_' . $tb . '_doc';
//主表
$table2 = $dbtbpre . 'ecms_' . $tb . '_doc_data';
//副表
$ytable = $dbtbpre . 'ecms_' . $tb . '_index';
//目标索引表
$ytable1 = $dbtbpre . 'ecms_' . $tb;
//目标主表
$ytable2 = $dbtbpre . 'ecms_' . $tb . '_data_' . $r[stb];
//目标副表
} else {
$table = $dbtbpre . 'ecms_' . $tb . '_index';
//索引表
$table1 = $dbtbpre . 'ecms_' . $tb;
//主表
$table2 = $dbtbpre . 'ecms_' . $tb . '_data_' . $r[stb];
//副表
$ytable = $dbtbpre . 'ecms_' . $tb . '_doc_index';
//目标索引表
$ytable1 = $dbtbpre . 'ecms_' . $tb . '_doc';
//目标主表
$ytable2 = $dbtbpre . 'ecms_' . $tb . '_doc_data';
//目标副表
}
$mid = $class_r[$r[classid]][modid];
//索引表
$index_r = $empire->fetch1("select * from " . $table . " where id='{$r['id']}' limit 1");
if ($index_r['checked'] == 0) {
return '';
}
//副表
$fr = $empire->fetch1("select " . ReturnSqlFtextF($mid) . " from " . $table2 . " where id='{$r['id']}' limit 1");
$r = array_merge($r, $fr);
$ret_r = ReturnAddF($r, $mid, $userid, $username, 10, 0, 0);
//返回自定义字段
//索引表
$empire->query("insert into " . $ytable . "(id,classid,checked,newstime,truetime,lastdotime,havehtml) values('{$index_r['id']}','{$index_r['classid']}','{$index_r['checked']}','{$index_r['newstime']}','{$index_r['truetime']}','{$index_r['lastdotime']}','{$index_r['havehtml']}');");
//主表
$empire->query("replace into " . $ytable1 . "(id,classid,ttid,onclick,plnum,totaldown,newspath,filename,userid,username,firsttitle,isgood,ispic,istop,isqf,ismember,isurl,truetime,lastdotime,havehtml,groupid,userfen,titlefont,titleurl,stb,fstb,restb,keyboard" . $ret_r[fields] . ") values('{$r['id']}','{$r['classid']}','{$r['ttid']}','{$r['onclick']}','{$r['plnum']}','{$r['totaldown']}','" . StripAddsData($r[newspath]) . "','" . StripAddsData($r[filename]) . "','{$r['userid']}','" . StripAddsData($r[username]) . "','{$r['firsttitle']}','{$r['isgood']}','{$r['ispic']}','{$r['istop']}','{$r['isqf']}','{$r['ismember']}','{$r['isurl']}','{$r['truetime']}','{$r['lastdotime']}','{$r['havehtml']}','{$r['groupid']}','{$r['userfen']}','" . StripAddsData($r[titlefont]) . "','" . StripAddsData($r[titleurl]) . "','{$r['stb']}','{$r['fstb']}','{$r['restb']}','" . StripAddsData($r[keyboard]) . "'" . $ret_r[values] . ");");
//副表
$empire->query("replace into " . $ytable2 . "(id,classid,keyid,dokey,newstempid,closepl,haveaddfen,infotags" . $ret_r[datafields] . ") values('{$r['id']}','{$r['classid']}','{$r['keyid']}','{$r['dokey']}','{$r['newstempid']}','{$r['closepl']}','{$r['haveaddfen']}','" . StripAddsData($r[infotags]) . "'" . $ret_r[datavalues] . ");");
//删除
$empire->query("delete from " . $table . " where id='{$r['id']}'");
$empire->query("delete from " . $table1 . " where id='{$r['id']}'");
$empire->query("delete from " . $table2 . " where id='{$r['id']}'");
//更新栏目信息数
if ($ecms == 1) {
AddClassInfos($r['classid'], '+1', '+1');
} else {
AddClassInfos($r['classid'], '-1', '-1');
}
}
function ChangeDocDataTableF($add, $userid, $username)
{
global $empire, $dbtbpre, $public_r, $fun_r;
//验证权限
CheckLevel($userid, $username, $classid, "f");
$fid = (int) $add[fid];
$tid = (int) $add[tid];
$tbname = RepPostVar($add[tbname]);
$line = (int) $add[line];
$start = (int) $add[start];
if (!$fid || !$tid || !$tbname) {
printerror("ErrorUrl", "history.go(-1)");
}
if (empty($line)) {
$line = 200;
}
$fr = $empire->fetch1("select * from {$dbtbpre}enewsf where fid='{$fid}'");
if (!$fr[fid]) {
printerror("ErrorUrl", "history.go(-1)");
}
if (empty($fr[isadd])) {
printerror("NotIsAdd", "history.go(-1)");
}
$tid = $fr[tid];
$tbname = $fr[tbname];
$f = $fr[f];
$selectf = '';
if (empty($fr[tbdataf])) {
$selectf = ',' . $fr[f];
}
$b = 0;
$sql = $empire->query("select id,stb" . $selectf . " from {$dbtbpre}ecms_" . $tbname . "_doc where id>{$start} order by id limit " . $line);
while ($r = $empire->fetch($sql)) {
$b = 1;
$newstart = $r['id'];
if ($fr[tbdataf]) {
$finfor = $empire->fetch1("select " . $f . " from {$dbtbpre}ecms_" . $tbname . "_doc_data where id='{$r['id']}'");
$value = $finfor[$f];
$empire->query("update {$dbtbpre}ecms_" . $tbname . "_doc set " . $f . "='" . StripAddsData($value) . "' where id='{$r['id']}'");
} else {
$value = $r[$f];
$empire->query("update {$dbtbpre}ecms_" . $tbname . "_doc_data set " . $f . "='" . StripAddsData($value) . "' where id='{$r['id']}'");
}
}
if (empty($b)) {
//删除字段
if ($fr[tbdataf]) {
$tbr = $empire->fetch1("select datatbs from {$dbtbpre}enewstable where tid='{$tid}'");
if ($tbr['datatbs']) {
$dtbr = explode(',', $tbr['datatbs']);
$count = count($dtbr);
for ($i = 1; $i < $count - 1; $i++) {
$empire->query("alter table {$dbtbpre}ecms_" . $tbname . "_data_" . $dtbr[$i] . " drop COLUMN " . $fr[f]);
}
}
//归档副表
$empire->query("alter table {$dbtbpre}ecms_" . $tbname . "_doc_data drop COLUMN " . $fr[f]);
} else {
$empire->query("alter table {$dbtbpre}ecms_" . $tbname . " drop COLUMN " . $fr[f]);
$empire->query("alter table {$dbtbpre}ecms_" . $tbname . "_doc drop COLUMN " . $fr[f]);
}
$newtbdataf = $fr[tbdataf] ? 0 : 1;
$empire->query("update {$dbtbpre}enewsf set tbdataf='{$newtbdataf}' where fid='{$fid}'");
//删除模型中字段项
if (empty($tbr['datatbs'])) {
$record = "<!--record-->";
$field = "<!--field--->";
$like = $field . $fr[f] . $record;
$slike = "," . $fr[f] . ",";
$dsql = $empire->query("select mid,searchvar,listandf,listtempvar,orderf from {$dbtbpre}enewsmod where tid='{$tid}' and (searchvar like '%" . $slike . "%' or listtempvar like '%" . $like . "%' or listandf like '%" . $slike . "%' or orderf like '%" . $slike . "%')");
while ($r = $empire->fetch($dsql)) {
$listtempvar = "";
$searchvar = "";
$listandf = "";
$orderf = "";
$re = "";
$re1 = "";
$and = "";
$dh = "";
//列表模板变量
if (strstr($r[listtempvar], $like)) {
$re1 = explode($record, $r[listtempvar]);
for ($i = 0; $i < count($re1) - 1; $i++) {
if (strstr($re1[$i] . $record, $like)) {
continue;
}
$listtempvar .= $re1[$i] . $record;
}
$and .= $dh . "listtempvar='{$listtempvar}'";
}
$dh = "";
//搜索变量
if (strstr($r[searchvar], $slike)) {
if (!empty($and)) {
$dh = ",";
}
$searchvar = str_replace($slike, ",", $r[searchvar]);
$and .= $dh . "searchvar='{$searchvar}'";
}
//结合项
$dh = "";
if (strstr($r[listandf], $slike)) {
if (!empty($and)) {
$dh = ",";
}
$listandf = str_replace($slike, ",", $r[listandf]);
$and .= $dh . "listandf='{$listandf}'";
}
//排序项
$dh = "";
if (strstr($r[orderf], $slike)) {
if (!empty($and)) {
$dh = ",";
}
$orderf = str_replace($slike, ",", $r[orderf]);
$and .= $dh . "orderf='{$orderf}'";
}
if ($and) {
$empire->query("update {$dbtbpre}enewsmod set " . $and . " where mid='{$r['mid']}'");
}
}
}
GetConfig(1);
//更新缓存
insert_dolog("tid={$tid}&tbname={$tbname}<br>fid={$fid}&field={$f}&tbdataf=" . $newtbdataf);
//操作日志
printerror("ChangeDataTableFSuccess", "db/ListF.php?tid={$tid}&tbname={$tbname}");
}
echo "<link rel=\"stylesheet\" href=\"../data/images/css.css\" type=\"text/css\"><meta http-equiv=\"refresh\" content=\"" . $public_r['realltime'] . ";url=ecmsmod.php?enews=ChangeDocDataTableF&tid={$tid}&tbname={$tbname}&fid={$fid}&line={$line}&start={$newstart}\">" . $fun_r[OneChangeDocDataTableFSuccess] . "(ID:<font color=red><b>" . $newstart . "</b></font>)";
exit;
}
function ReEBakTemp($add, $userid, $username)
{
global $empire, $dbtbpre;
$bid = (int) $add['bid'];
if (!$bid) {
printerror("NotBakTemp", "history.go(-1)");
}
$r = $empire->fetch1("select * from {$dbtbpre}enewstempbak where bid='{$bid}'");
if (!$r['bid']) {
printerror("NotBakTemp", "history.go(-1)");
}
//操作权限
if ($r['temptype'] == 'tempvar') {
CheckLevel($userid, $username, $classid, "tempvar");
} else {
CheckLevel($userid, $username, $classid, "template");
}
$gid = (int) $r['gid'];
if (!$gid) {
$gid = GetDoTempGid();
}
if ($temptype == 'indexpage') {
$gid = 1;
}
if ($r['temptype'] == 'bqtemp') {
$sql = $empire->query("update " . GetDoTemptb("enewsbqtemp", $gid) . " set tempname='" . StripAddsData($r[tempname]) . "',temptext='" . addslashes($r[temptext]) . "',modid='{$r['modid']}',showdate='" . StripAddsData($r[showdate]) . "',listvar='" . addslashes($r[listvar]) . "',subnews='{$r['subnews']}',rownum='{$r['rownum']}',classid='{$r['classid']}',docode='{$r['docode']}' where tempid='{$r['tempid']}'");
} elseif ($r['temptype'] == 'classtemp') {
$sql = $empire->query("update " . GetDoTemptb("enewsclasstemp", $gid) . " set tempname='" . StripAddsData($r[tempname]) . "',temptext='" . addslashes($r[temptext]) . "',classid='{$r['classid']}' where tempid='{$r['tempid']}'");
} elseif ($r['temptype'] == 'jstemp') {
$sql = $empire->query("update " . GetDoTemptb("enewsjstemp", $gid) . " set tempname='" . StripAddsData($r[tempname]) . "',temptext='" . addslashes($r[temptext]) . "',classid='{$r['classid']}',showdate='" . StripAddsData($r[showdate]) . "',modid='{$r['modid']}',subnews='{$r['subnews']}',subtitle='{$r['subtitle']}' where tempid='{$r['tempid']}'");
} elseif ($r['temptype'] == 'listtemp') {
$sql = $empire->query("update " . GetDoTemptb("enewslisttemp", $gid) . " set subnews='{$r['subnews']}',tempname='" . StripAddsData($r[tempname]) . "',temptext='" . addslashes($r[temptext]) . "',listvar='" . addslashes($r[listvar]) . "',rownum='{$r['rownum']}',modid='{$r['modid']}',showdate='" . StripAddsData($r[showdate]) . "',subtitle='{$r['subtitle']}',classid='{$r['classid']}',docode='{$r['docode']}' where tempid='{$r['tempid']}'");
} elseif ($r['temptype'] == 'newstemp') {
$sql = $empire->query("update " . GetDoTemptb("enewsnewstemp", $gid) . " set tempname='" . StripAddsData($r[tempname]) . "',temptext='" . addslashes($r[temptext]) . "',showdate='" . StripAddsData($r[showdate]) . "',modid='{$r['modid']}',classid='{$r['classid']}' where tempid='{$r['tempid']}'");
} elseif ($r['temptype'] == 'pltemp') {
$sql = $empire->query("update " . GetDoTemptb("enewspltemp", $gid) . " set tempname='" . StripAddsData($r[tempname]) . "',temptext='" . addslashes($r[temptext]) . "' where tempid='{$r['tempid']}'");
} elseif ($r['temptype'] == 'printtemp') {
$sql = $empire->query("update " . GetDoTemptb("enewsprinttemp", $gid) . " set tempname='" . StripAddsData($r[tempname]) . "',temptext='" . addslashes($r[temptext]) . "',showdate='" . StripAddsData($r[showdate]) . "',modid='{$r['modid']}' where tempid='{$r['tempid']}'");
} elseif ($r['temptype'] == 'searchtemp') {
$sql = $empire->query("update " . GetDoTemptb("enewssearchtemp", $gid) . " set subnews='{$r['subnews']}',tempname='" . StripAddsData($r[tempname]) . "',temptext='" . addslashes($r[temptext]) . "',listvar='" . addslashes($r[listvar]) . "',rownum='{$r['rownum']}',modid='{$r['modid']}',showdate='" . StripAddsData($r[showdate]) . "',subtitle='{$r['subtitle']}',classid='{$r['classid']}',docode='{$r['docode']}' where tempid='{$r['tempid']}'");
} elseif ($r['temptype'] == 'tempvar') {
$sql = $empire->query("update " . GetDoTemptb("enewstempvar", $gid) . " set myvar='" . StripAddsData($r[tempname]) . "',varname='" . StripAddsData($r[listvar]) . "',varvalue='" . addslashes($r[temptext]) . "',classid='{$r['classid']}',isclose='{$r['docode']}',myorder='{$r['subnews']}' where varid='{$r['tempid']}'");
} elseif ($r['temptype'] == 'votetemp') {
$sql = $empire->query("update " . GetDoTemptb("enewsvotetemp", $gid) . " set tempname='" . StripAddsData($r[tempname]) . "',temptext='" . addslashes($r[temptext]) . "' where tempid='{$r['tempid']}'");
} elseif ($r['temptype'] == 'pagetemp') {
$sql = $empire->query("update " . GetDoTemptb("enewspagetemp", $gid) . " set tempname='" . StripAddsData($r[tempname]) . "',temptext='" . addslashes($r[temptext]) . "' where tempid='{$r['tempid']}'");
} elseif ($r['temptype'] == 'indexpage') {
$sql = $empire->query("update {$dbtbpre}enewsindexpage set tempname='" . StripAddsData($r[tempname]) . "',temptext='" . addslashes($r[temptext]) . "' where tempid='{$r['tempid']}'");
} elseif ($r['temptype'] == 'pubindextemp') {
$sql = $empire->query("update " . GetDoTemptb("enewspubtemp", $gid) . " set indextemp='" . addslashes($r[temptext]) . "' limit 1");
} elseif ($r['temptype'] == 'pubcptemp') {
$sql = $empire->query("update " . GetDoTemptb("enewspubtemp", $gid) . " set cptemp='" . addslashes($r[temptext]) . "' limit 1");
} elseif ($r['temptype'] == 'pubsearchtemp') {
$sql = $empire->query("update " . GetDoTemptb("enewspubtemp", $gid) . " set searchtemp='" . addslashes($r[temptext]) . "' limit 1");
} elseif ($r['temptype'] == 'pubsearchjstemp') {
$sql = $empire->query("update " . GetDoTemptb("enewspubtemp", $gid) . " set searchjstemp='" . addslashes($r[temptext]) . "' limit 1");
} elseif ($r['temptype'] == 'pubsearchjstemp1') {
$sql = $empire->query("update " . GetDoTemptb("enewspubtemp", $gid) . " set searchjstemp1='" . addslashes($r[temptext]) . "' limit 1");
} elseif ($r['temptype'] == 'pubotherlinktemp') {
$sql = $empire->query("update " . GetDoTemptb("enewspubtemp", $gid) . " set otherlinktemp='" . addslashes($r[temptext]) . "',otherlinktempsub='{$r['subtitle']}',otherlinktempdate='" . StripAddsData($r[showdate]) . "' limit 1");
} elseif ($r['temptype'] == 'pubdownsofttemp') {
$sql = $empire->query("update " . GetDoTemptb("enewspubtemp", $gid) . " set downsofttemp='" . addslashes($r[temptext]) . "' limit 1");
} elseif ($r['temptype'] == 'pubonlinemovietemp') {
$sql = $empire->query("update " . GetDoTemptb("enewspubtemp", $gid) . " set onlinemovietemp='" . addslashes($r[temptext]) . "' limit 1");
} elseif ($r['temptype'] == 'publistpagetemp') {
$sql = $empire->query("update " . GetDoTemptb("enewspubtemp", $gid) . " set listpagetemp='" . addslashes($r[temptext]) . "' limit 1");
} elseif ($r['temptype'] == 'pubpljstemp') {
$sql = $empire->query("update " . GetDoTemptb("enewspubtemp", $gid) . " set pljstemp='" . addslashes($r[temptext]) . "' limit 1");
} elseif ($r['temptype'] == 'pubdownpagetemp') {
$sql = $empire->query("update " . GetDoTemptb("enewspubtemp", $gid) . " set downpagetemp='" . addslashes($r[temptext]) . "' limit 1");
} elseif ($r['temptype'] == 'pubgbooktemp') {
$sql = $empire->query("update " . GetDoTemptb("enewspubtemp", $gid) . " set gbooktemp='" . addslashes($r[temptext]) . "' limit 1");
} elseif ($r['temptype'] == 'publoginiframe') {
$sql = $empire->query("update " . GetDoTemptb("enewspubtemp", $gid) . " set loginiframe='" . addslashes($r[temptext]) . "' limit 1");
} elseif ($r['temptype'] == 'publoginjstemp') {
$sql = $empire->query("update " . GetDoTemptb("enewspubtemp", $gid) . " set loginjstemp='" . addslashes($r[temptext]) . "' limit 1");
} elseif ($r['temptype'] == 'pubschalltemp') {
$sql = $empire->query("update " . GetDoTemptb("enewspubtemp", $gid) . " set schalltemp='" . addslashes($r[temptext]) . "',schallsubnum='{$r['subnews']}',schalldate='" . StripAddsData($r[showdate]) . "' limit 1");
}
if ($sql) {
//操作日志
insert_dolog("bid={$bid}&temptype={$r['temptype']}<br>tempid={$r['tempid']}&tempname={$r['tempname']}&gid={$r['gid']}");
echo "<script>opener.ReTempBak();window.close();</script>";
exit;
} else {
printerror("DbError", "history.go(-1)");
}
}
function DoDocInfo($tb, $r, $ecms = 0)
{
global $empire, $dbtbpre, $class_r, $emod_r;
if ($ecms == 1) {
$table1 = $dbtbpre . 'ecms_' . $tb . '_doc';
//主表
$table2 = $dbtbpre . 'ecms_' . $tb . '_doc_data';
//副表
$ytable1 = $dbtbpre . 'ecms_' . $tb;
//目标主表
$ytable2 = $dbtbpre . 'ecms_' . $tb . '_data_' . $r[stb];
//目标副表
} else {
$table1 = $dbtbpre . 'ecms_' . $tb;
//主表
$table2 = $dbtbpre . 'ecms_' . $tb . '_data_' . $r[stb];
//副表
$ytable1 = $dbtbpre . 'ecms_' . $tb . '_doc';
//目标主表
$ytable2 = $dbtbpre . 'ecms_' . $tb . '_doc_data';
//目标副表
}
$mid = $class_r[$r[classid]][modid];
//副表
if ($emod_r[$mid]['tbdataf'] && $emod_r[$mid]['tbdataf'] != ',') {
$selectdataf = substr($emod_r[$mid]['tbdataf'], 1, -1);
$fr = $empire->fetch1("select " . $selectdataf . " from " . $table2 . " where id='{$r['id']}'");
$r = array_merge($r, $fr);
}
$ret_r = ReturnAddF($r, $mid, $userid, $username, 10, 0, 0);
//返回自定义字段
//主表
$empire->query("replace into " . $ytable1 . "(id,classid,onclick,newspath,keyboard,keyid,userid,username,ztid,checked,istop,truetime,ismember,dokey,userfen,isgood,titlefont,titleurl,filename,groupid,newstempid,plnum,firsttitle,isqf,totaldown,closepl,havehtml,lastdotime,haveaddfen,infopfen,infopfennum,votenum,stb,copyids,ttid,infotags,ispic" . $ret_r[fields] . ") values('{$r['id']}','{$r['classid']}','{$r['onclick']}','" . StripAddsData($r[newspath]) . "','" . StripAddsData($r[keyboard]) . "','{$r['keyid']}','{$r['userid']}','" . StripAddsData($r[username]) . "','{$r['ztid']}','{$r['checked']}','{$r['istop']}','{$r['truetime']}','{$r['ismember']}','{$r['dokey']}','{$r['userfen']}','{$r['isgood']}','" . StripAddsData($r[titlefont]) . "','" . StripAddsData($r[titleurl]) . "','" . StripAddsData($r[filename]) . "','{$r['groupid']}','{$r['newstempid']}','{$r['plnum']}','{$r['firsttitle']}','{$r['isqf']}','{$r['totaldown']}','{$r['closepl']}','{$r['havehtml']}','{$r['lastdotime']}','{$r['haveaddfen']}','{$r['infopfen']}','{$r['infopfennum']}','{$r['votenum']}','{$r['stb']}','{$r['copyids']}','{$r['ttid']}','" . StripAddsData($r[infotags]) . "','{$r['ispic']}'" . $ret_r[values] . ");");
//副表
$empire->query("replace into " . $ytable2 . "(id,classid" . $ret_r[datafields] . ") values('{$r['id']}','{$r['classid']}'" . $ret_r[datavalues] . ");");
//删除
$empire->query("delete from " . $table1 . " where id='{$r['id']}'");
$empire->query("delete from " . $table2 . " where id='{$r['id']}'");
}
