function GetKeyid($keyboard, $classid, $id, $link_num) { global $empire, $public_r, $class_r, $fun_r, $dbtbpre, $eyh_r, $etable_r; if ($keyboard) { if (empty($link_num)) { return ''; } $keyboard = RepDyh($keyboard); $r = explode(",", $keyboard); for ($i = 0; $i < count($r); $i++) { if ($i == 0) { $or = ""; } else { $or = " or "; } $repadd .= $or . "[!--f--!]" . " like '%" . $r[$i] . "%'"; } //搜索范围 if ($public_r['newslink'] == 1) { $add = '(' . str_replace('[!--f--!]', 'keyboard', $repadd) . ')'; } elseif ($public_r['newslink'] == 2) { $add = '(' . str_replace('[!--f--!]', 'keyboard', $repadd) . ' or ' . str_replace('[!--f--!]', 'title', $repadd) . ')'; } else { $add = '(' . str_replace('[!--f--!]', 'title', $repadd) . ')'; } //模型 if (!empty($class_r[$classid][modid])) { $mr = $empire->fetch1("select sonclass from {$dbtbpre}enewsmod where mid='" . $class_r[$classid][modid] . "'"); $where = " and (" . ReturnClass($mr[sonclass]) . ")"; } //优化 $tbname = $class_r[$classid][tbname]; $yhvar = 'otherlink'; $yhid = $etable_r[$tbname][yhid]; $yhadd = ''; if ($yhid) { $yhadd = ReturnYhSql($yhid, $yhvar); } //ID声名 $keyid = ""; $first = 0; $key_sql = $empire->query("select id from {$dbtbpre}ecms_" . $class_r[$classid][tbname] . " where " . $yhadd . $add . $where . " and id<>{$id} and checked=1 order by newstime desc limit {$link_num}"); while ($link_r = $empire->fetch($key_sql)) { if (empty($first)) { $dh = ""; $first = 1; } else { $dh = ","; } $keyid .= $dh . $link_r[id]; } } else { $keyid = ""; } return $keyid; }
function CjNewsIn_all($classid, $checked, $uptime, $start, $userid, $username) { global $class_r, $empire, $public_r, $dbtbpre, $fun_r, $emod_r; $checked = (int) $checked; $classid = (int) $classid; $start = (int) $start; if (empty($classid)) { printerror("ErrorUrl", "history.go(-1)"); } //操作权限 CheckLevel($userid, $username, $classid, "cj"); $cr = $empire->fetch1("select * from {$dbtbpre}enewsinfoclass where classid='{$classid}'"); //副表 $cra = $empire->fetch1("select * from {$dbtbpre}ecms_infoclass_" . $cr[tbname] . " where classid='{$classid}'"); //组合两数组 $cr = TogTwoArray($cr, $cra); //导入gd处理文件 if ($cr['mark'] || $cr['getfirstspic']) { @(include_once "gd.php"); } if (empty($cr[insertnum])) { $cr[insertnum] = 10; } $mid = $class_r[$cr[newsclassid]][modid]; $savetxtf = $emod_r[$mid]['savetxtf']; $stb = $emod_r[$mid]['deftb']; //取得采集字段 $record = "<!--record-->"; $field = "<!--field--->"; $mr = $empire->fetch1("select cj from {$dbtbpre}enewsmod where mid='" . $class_r[$cr[newsclassid]][modid] . "'"); $cjr = explode($record, $mr[cj]); $ccount = count($cjr); $sql = $empire->query("select * from {$dbtbpre}ecms_infotmp_" . $cr[tbname] . " where classid='{$classid}' and checked=0 and id>{$start} order by id limit " . $cr[insertnum]); $filetime = date("Y-m-d H:i:s"); $todaytime = time(); $b = 0; while ($r = $empire->fetch($sql)) { $b = 1; $newstart = $r[id]; $ivalue = ''; $ifield = ''; $dataivalue = ''; $dataifield = ''; $titlepicnoval = 0; for ($j = 0; $j < $ccount - 1; $j++) { $cjr1 = explode($field, $cjr[$j]); $dofield = $cjr1[1]; $var = "zz_" . $dofield; $var1 = "z_" . $dofield; $var2 = "qz_" . $dofield; $var3 = "save_" . $dofield; $value = $r[$dofield]; //自身链接 if ($dofield == "empireselfurl") { $value = $r['oldurl']; } //内容 if ($dofield == "newstext") { if ($cr[copyimg] || $cr[copyflash]) { $GLOBALS['cjnewsurl'] = $r[oldurl]; $value = addslashes(CopyImg(stripSlashes($value), $cr[copyimg], $cr[copyflash], $cr[newsclassid], $cr[imgurl], $username, 0, $r['id'], $cr['mark'])); } //替换关键字和字符 $value = DoReplaceKeyAndWord($value, 1); } //简介 if ($dofield == "smalltext") { if (empty($value)) { $value = SubSmalltextVal($r[newstext], $cr[smalltextlen]); } else { $value = DoClearSmalltextVal($value); } } //图片集 if ($dofield == "morepic") { if ($cr[$var3] == " checked") { $msavepic = 1; $r['filepass'] = $r['id']; $value = LoadInSaveMorepicFile($value, $msavepic, $cr[newsclassid], 0, $r); } } //时间 if ($dofield == "newstime") { continue; } //图片标题 if ($dofield == "titlepic" && $cr[zz_titlepicl]) { $cr[$var] = $cr[zz_titlepicl]; $cr[$var1] = $cr[z_titlepicl]; $cr[$var2] = $cr[qz_titlepicl]; $cr[$var3] = $cr[save_titlepicl]; } if ($dofield == "titlepic" && empty($value)) { $titlepicnoval = 1; } //是否远程保存 if ($value && !$cr[$var1] && $cr[$var3] == " checked" && $dofield != "morepic") { $tranr = DoTranUrl($value, $cr[newsclassid]); if ($tranr[tran]) { $tranr[filesize] = (int) $tranr[filesize]; $tranr[type] = (int) $tranr[type]; $r[id] = (int) $r[id]; //记录数据库 $usql = $empire->query("insert into {$dbtbpre}enewsfile(filename,filesize,adduser,path,filetime,classid,no,type,id,cjid,onclick,fpath) values('{$tranr['filename']}',{$tranr['filesize']},'{$username}','{$tranr['filepath']}','{$filetime}',{$cr['newsclassid']},'[URL]" . $tranr[filename] . "',{$tranr['type']},0,{$r['id']},0,'{$public_r['fpath']}');"); $value = $tranr[url]; } } //存放文本 if ($savetxtf == $dofield) { //建立目录 $thetxtfile = GetFileMd5(); $truevalue = MkDirTxtFile(date("Y/md"), $thetxtfile); //写放文件 EditTxtFieldText($truevalue, $value); $value = $truevalue; } $value = RepDyh($value); if (strstr($emod_r[$mid]['tbdataf'], ',' . $dofield . ',')) { $dataifield .= "," . $dofield; $dataivalue .= ",'" . $value . "'"; } else { $ifield .= "," . $dofield; $ivalue .= ",'" . $value . "'"; } } $r[keyboard] = RepDyh($r[keyboard]); //时间 if ($uptime) { $r[newstime] = $todaytime; $r[truetime] = $todaytime; } else { if ($r[newstime] == "0000-00-00 00:00:00") { $r[newstime] = $todaytime; } else { $r[newstime] = to_time($r[newstime]); } } //查看目录是否存在,不存在则建立 $newspath = FormatPath($cr[newsclassid], "", 0); //强制签发 if ($class_r[$cr[newsclassid]][wfid]) { $checked = 0; $isqf = 1; } else { $checked = $checked; $isqf = 0; } //变量处理 $newstempid = 0; $ispic = $r[titlepic] ? 1 : 0; //返回关键字 $keyid = GetKeyid($r[keyboard], $cr[newsclassid], 0, $class_r[$cr[newsclassid]][link_num]); $isql = $empire->query("insert into {$dbtbpre}ecms_" . $cr[tbname] . "(classid,onclick,newspath,keyboard,keyid,userid,username,ztid,checked,truetime,ismember,dokey,isgood,titlefont,titleurl,filename,groupid,newstempid,plnum,firsttitle,isqf,userfen,totaldown,closepl,havehtml,lastdotime,haveaddfen,infopfen,infopfennum,votenum,stb,ttid,newstime,ispic" . $ifield . ") values({$cr['newsclassid']},0,'{$newspath}','{$r['keyboard']}','{$keyid}',{$r['userid']},'{$r['username']}','{$cr['newsztid']}','{$checked}','{$r['truetime']}',0,1,0,'{$r['titlefont']}','{$r['titleurl']}','{$filename}',0,'" . $newstempid . "',0,0,'{$isqf}',0,0,0,0,'{$r['truetime']}',0,0,0,0,'{$stb}',0,'{$r['newstime']}','{$ispic}'" . $ivalue . ");"); $id = $empire->lastid(); //副表 $fisql = $empire->query("insert into {$dbtbpre}ecms_" . $cr[tbname] . "_data_" . $stb . "(id,classid" . $dataifield . ") values('{$id}','{$cr['newsclassid']}'" . $dataivalue . ");"); //签发 if ($isqf == 1) { InfoInsertToWorkflow($id, $cr[newsclassid], $class_r[$cr[newsclassid]][wfid], $userid, $username); } //更新附件 UpdateTheFile($id, $r['id']); //取第一张图片为标题图片 $addtitlepic = ""; if ($cr['getfirstpic'] && $titlepicnoval) { $firsttitlepic = GetFpicToTpic($cr[newsclassid], $id, $cr['getfirstpic'], $cr['getfirstspic'], $cr['getfirstspicw'], $cr['getfirstspich']); if ($firsttitlepic) { $addtitlepic = ",titlepic='" . addslashes($firsttitlepic) . "',ispic=1"; } } //文件命名 $filename = ReturnInfoFilename($cr[newsclassid], $id, $r[filenameqz]); $usql = $empire->query("update {$dbtbpre}ecms_" . $cr[tbname] . " set filename='{$filename}'" . $addtitlepic . " where id='{$id}'"); } $fm = $_GET['fm']; //全部入库完毕 if (empty($b)) { //取得忧化字段 for ($ci = 0; $ci < $ccount - 1; $ci++) { $cir = explode($field, $cjr[$ci]); $cifield = $cir[1]; if ($cifield == "title") { continue; } $updatefield .= "," . $cifield . "=''"; } //状态原记录 if ($cr['delloadinfo']) { $del = $empire->query("delete from {$dbtbpre}ecms_infotmp_" . $cr[tbname] . " where classid='{$classid}'"); } else { $del = $empire->query("update {$dbtbpre}ecms_infotmp_" . $cr[tbname] . " set checked=1,keyboard=''" . $updatefield . " where classid='{$classid}'"); } if ($fm) { echo "<link rel=\"stylesheet\" href=\"../data/images/css.css\" type=\"text/css\"><body topmargin=0><font color=red>" . $cr[classname] . " " . $fun_r['CjLoadInInfosSuccess'] . "</font>, <input type=button name=button value='" . $fun_r['OnlickLoadInCj'] . "' onclick=\"window.open('CheckCj.php?classid={$classid}&from={$_GET['from']}');\"></body>"; exit; } else { printerror("CjLoadDbSuccess", "CheckCj.php?classid={$classid}&from={$_GET['from']}"); } } echo "<b>{$cr['classname']}</b> " . $fun_r['OneCjLoadDbSuccess'] . "(ID:<font color=red><b>" . $newstart . "</b></font>)<script>self.location.href='ecmscj.php?enews=CjNewsIn_all&checked={$checked}&uptime={$uptime}&classid={$classid}&start={$newstart}&fm={$fm}&from={$_GET['from']}';</script>"; exit; }