📄 topic_make.php
字号:
<?
require "inc/check.php";
require "inc/func.php";
require "inc/error.php";
require "publish/pub_func.php";
?>
<html>
<head>
<title>“天勤”网站后台管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<STYLE type=text/css>BODY {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px; scrollbar-face-color: ffffff; scrollbar-shadow-color: C1C1BB; scrollbar-highlight-color: C1C1BB; scrollbar-3dlight-color: EBEBE4; scrollbar-darkshadow-color: EBEBE4; scrollbar-track-color: F4F4F0; scrollbar-arrow-color: CACAB7
}
P {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
INPUT {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
FONT {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
SELECT {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
OPTION {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
TEXTAREA {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
FORM {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px
}
TD {
FONT-FAMILY: "宋体"; FONT-SIZE: 12px; TABLE-LAYOUT: fixed; WORD-BREAK: break-all
}
A:link {
TEXT-DECORATION: none
}
A:visited {
TEXT-DECORATION: none
}
A:hover {
TEXT-DECORATION: underline
}
A:active {
FONT-SIZE: 12px; TEXT-DECORATION: none
}
.border {
BACKGROUND-COLOR: #efefef; BORDER-BOTTOM: 1px dotted; BORDER-COLLAPSE: collapse; BORDER-LEFT: 1px dotted; BORDER-RIGHT: 1px dotted; BORDER-TOP: 1px dotted; COLOR: #000000
}
.shadow1 {
COLOR: #ffffff; FILTER: dropshadow(color=#000000,offx=1,offy=1); FONT-SIZE: 12px
}
.shadow2 {
COLOR: #000000; FILTER: dropshadow(color=#d5d5d5,offx=1,offy=1); FONT-SIZE: 12px
}
.p1 {
COLOR: #ffffff; FONT-SIZE: 12px; TEXT-DECORATION: none
}
.p2 {
COLOR: #000000; FONT-SIZE: 12px; TEXT-DECORATION: none
}
.p3 {
COLOR: #004080; FONT-SIZE: 14px; TEXT-DECORATION: none
}
</STYLE>
</head>
<body>
<?
if($cmdadd){ //如果添加NEWGIVER
/*
标题: %标题%
作者：%作者%
译者：%译者%
来源：%来源%
正文内容：%内容%
加入时间：%时间%
相关链接：%链接%
*/
//生成sqldo语句
$sqldo_head="select newsid,upname,newsname,downname1,downname2,newswriter,newsgiver,newscomper,newstranser,newsdate,column1,column2,column3,newstext,newssource,newssourcestr,uploadertime,uploader,pic1,pic2,pic3,pic4,pic5,clas_statue,newslink from news ";
$sqldo_cont="";
if($sercont or $sertime or $seritem){
$sqldo_cont.="where ";
}
if($sercont){
$sqldo_cont.="(instr(newsname,'$sercont')>0 or instr(newstext,'$sercont')>0) ";
}
if($sercont and $sertime){
$datetime=date("YmdHis",mktime(date(''),date(''),date(''),date("m"),date("d")-$sertime,date("Y")) );
$sqldo_cont.="and uploadertime>'$datetime' ";
}elseif($sertime){
$datetime=date("YmdHis",mktime(date(''),date(''),date(''),date("m"),date("d")-$sertime,date("Y")) );
$sqldo_cont.=" uploadertime>'$datetime' ";
}
if(($sercont or $sertime) and $seritem){
$sqldo_cont.="and column1='$seritem' ";
}elseif($seritem){
$sqldo_cont.=" column1='$seritem' ";
}
$sqldo_s=$sqldo_head.$sqldo_cont;
$sqldo=$sqldo_s;
// echo "sqldo".$sqldo."end";
$res_array=$cla->db_query($sqldo);
$i=0;
//echo "1:".${chk.$res_array[$i][0]};
//echo "2:".$res_array[$i][0];
while($res_array[$i][0]){
if(${chk.$res_array[$i][0]}==$res_array[$i][0]){
//插入专题库
$tempid=$res_array[$i]["NEWSID"]; //新闻ID
$uploader=$ses_login_name; //session 用户注册名
$datetime=date("YmdHis",mktime(date('H'),date('i'),date('s'),date("m"),date("d"),date("Y")) );
$topicsel=trim($topicsel); //专题ID
$sqldo_in="select topicid from topic where newsid='$tempid' and spec_id='$topicsel'";
$res_array_in=$cla->db_query($sqldo_in);
if(!$res_array_in[0][0]){//如果不在专题库中存在
$sqldo="insert into topic values(topictopicid.nextval,'$tempid','$topicsel','$uploader','$datetime','','') ";
//echo $sqldo;
if($cla->db_insert($sqldo)){
$cla->db_commit();
//echo "数据库插入成功！";
}
}
else{
//echo "这条已经存在！<br>";
}
//静态转换内容
$newid=$res_array[$i][NEWSID];
$upname=change($res_array[$i][UPNAME]);
$newname=change($res_array[$i][NEWSNAME]);
$downname1=change($res_array[$i][DOWNNAME1]);
$downname2=change($res_array[$i][DOWNNAME2]);
$newname=$upname.$newname.$downname1.$downname2;
$newwriter=$res_array[$i][NEWSWRITER];
$newgiver=$res_array[$i][NEWSGIVER];
$newcomper=$res_array[$i][NEWSCOMPER];
$newtranser=$res_array[$i][NEWSTRANSER];
$newdate=formnewdate($res_array[$i][NEWSDATE]);
$column1=$res_array[$i][COLUMN1];
$column2=$res_array[$i][COLUMN2];
$column3=$res_array[$i][COLUMN3];
$newtext=replace_html($res_array[$i][NEWSTEXT],$res_array[$i][PIC1],$res_array[$i][PIC2],$res_array[$i][PIC3],$res_array[$i][PIC4],$res_array[$i][PIC5],"../../image_news/".$newid);
$newsource=$res_array[$i][NEWSSOURCE];
$newsourcestr=$res_array[$i][NEWSSOURCESTR];
$uploadertime=$res_array[$i][UPLOADERRTIME];
$uploader=$res_array[$i][UPLOADER];
$newlink=get_newname($res_array[$i][NEWSLINK],$cla);
$modle=$seltemp;
$dirname="../topicfiles/".$topicsel;
$column=get_column($column1,$cla);
generate_html($newid,$dirname,$modle,$newname,$newdate,$newwriter,$newtext,$newlink,$newsourse,$column,$uploader);
// generate_html($newid,$dirname,$modle,$newname,$newdate,$newwriter,$newtext,$newlink,$newsourse);
/*
$newid=$res_array[$i][NEWID];
$upname=change($res_array[$i][UPNAME]);
$newname=change($res_array[$i][NEWNAME]);
$downname1=change($res_array[$i][DOWNNAME1]);
$downname2=change($res_array[$i][DOWNNAME2]);
$title=$upname.$newname.$downname1.$downname2;
$newwriter=$res_array[$i][NEWWRITER];
$newgiver=$res_array[$i][NEWGIVER];
$newcomper=$res_array[$i][NEWCOMPER];
$newtranser=$res_array[$i][NEWTRANSER];
$newdate=formdate($res_array[$i][NEWDATE]);
$column1=$res_array[$i][COLUMN1];
$column2=$res_array[$i][COLUMN2];
$column3=$res_array[$i][COLUMN3];
$newtext=replace_html($res_array[$i][NEWTEXT],$res_array[$i][PIC1],$res_array[$i][PIC2],$res_array[$i][PIC3],$res_array[$i][PIC4],$res_array[$i][PIC5],"../create/yjx/".$newid);
$newsource=$res_array[$i][NEWSOURCE];
$newsourcestr=$res_array[$i][NEWSOURCESTR];
$uploadertime=$res_array[$i][UPLOADERRTIME];
$uploader=$res_array[$i][UPLOADER];
if($newlink){
$newlink=get_newname($res_array[$i][NEWLINK],$cla);
}
$title=$res_array[$i]["NEWNAME"];
$author=$res_array[$i]["NEWWRITER"];
$source=$res_array[$i]["NEWSOURCE"];
$content=$res_array[$i]["NEWTEXT"];
$date=$res_array[$i]["NEWDATE"];
$link=$res_array[$i]["NEWLINK"]; //先分开字符串，再查询，
$htmname=$res_array[$i][0];
if(!is_dir("topicfiles/$topicsel")){
if(mkdir("topicfiles/$topicsel",0777)){
echo "目录建立成功！";
}
}
$filename="topicfiles/$topicsel/$htmname.htm";
if($seltemp==""){
$seltemp="模板1";
}
$tmp_name="template/".$seltemp.".php";
$fp=fopen($tmp_name,"r");
$conn=fread($fp,filesize($tmp_name));
$conn=stripslashes($conn);
fclose($fp);
echo "newtext:".$newtext;
echo "title:".$title;
echo "newwriter:".$newwriter;
echo "newsource:".$newsource;
echo "newlink:".$newlink;
$conn=str_replace("%内容%",$newtext,$conn);
$conn=str_replace("%标题%",$title,$conn);
$conn=str_replace("%作者%",$newwriter,$conn);
$conn=str_replace("%来源%",$source,$conn);
$conn=str_replace("%日期%",$newdate,$conn);
$conn=str_replace("%链接%",$newlink,$conn);
$conn=str_replace("%提交人%",$uploader,$conn);
echo "***".$conn."***";
$fp=fopen($filename,"w");
if(fputs($fp,$conn)){
echo "文件写入成功";
}
fclose($fp);
*/
}
$i++;
}
}
?>
<!-- search code begin -->
<SCRIPT LANGUAGE="JavaScript">
function chg_manu(ser_type){
var subobj=document.form2.ser_type;
alert(subobj.value);
if(""==subobj.value){
// if(-1!=(subobj.options[subobj.selectedIndex].text.indexOf("所有"))) return;
// subobj.options[subobj.selectedIndex+1].selected=true;
// chg_manu(subobj.options[subobj.selectedIndex].value);
// return;
}
document.list_manu.location="list_manu.php?ser_type=group_name";
}
</SCRIPT>
<center>
<p> </p>
<div align="center">
<table width="100%" border="0" height="95">
<tr>
<td width="75%" height="68" rowspan="5">
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -