query("insert into {$dbtbpre}enewsad(picurl,url,pic_width,pic_height,onclick,classid,adtype,title,target,alt,starttime,endtime,adsay,titlefont,titlecolor,htmlcode,t,ylink,reptext) values('$add[picurl]','$add[url]',$add[pic_width],$add[pic_height],0,$add[classid],$add[adtype],'$add[title]','$add[target]','$add[alt]','$add[starttime]','$add[endtime]','$add[adsay]','$ttitlefont','$titlecolor','$add[htmlcode]',$add[t],$add[ylink],'$add[reptext]');"); $adid=$empire->lastid(); //更新附件 UpdateTheFileOther(3,$adid,$add['filepass'],'other'); GetAdJs($adid); if($sql) { //操作日志 insert_dolog("adid=".$adid."
title=".$add[title]); printerror("AddAdSuccess","AddAd.php?enews=AddAd&t=".$add[t].hReturnEcmsHashStrHref2(0)); } else {printerror("DbError","history.go(-1)");} } //修改广告 function EditAd($add,$titlefont,$titlecolor,$userid,$username){ global $empire,$time,$dbtbpre; $add[adid]=(int)$add[adid]; if(!$add[classid]||!$add[title]||!$add[adtype]||!$add[adid]) {printerror("EmptyAd","history.go(-1)");} //验证权限 CheckLevel($userid,$username,$classid,"ad"); $add[htmlcode]=AddAddsData(RepPhpAspJspcodeText($add[htmlcode])); $add[reptext]=AddAddsData(RepPhpAspJspcodeText($add[reptext])); $ttitlefont=TitleFont($titlefont,'no'); //重置 if($add[reset]) {$a=",onclick=0";} //变量处理 $add['title']=hRepPostStr($add['title'],1); $add[pic_width]=(int)$add[pic_width]; $add[pic_height]=(int)$add[pic_height]; $add[classid]=(int)$add[classid]; $add[adtype]=(int)$add[adtype]; $add[t]=(int)$add[t]; $add[ylink]=(int)$add[ylink]; $add['filepass']=(int)$add['filepass']; $add['picurl']=hRepPostStr2(eDoRepPostComStr($add['picurl'],1)); $add['url']=hRepPostStr2(eDoRepPostComStr($add['url'],1)); $add['target']=hRepPostStr($add['target'],1); $add['alt']=hRepPostStr($add['alt'],1); $add['starttime']=hRepPostStr($add['starttime'],1); $add['endtime']=hRepPostStr($add['endtime'],1); $add['adsay']=hRepPostStr2($add['adsay']); $ttitlefont=AddAddsData($ttitlefont); $titlecolor=AddAddsData($titlecolor); $sql=$empire->query("update {$dbtbpre}enewsad set picurl='$add[picurl]',url='$add[url]',pic_width=$add[pic_width],pic_height=$add[pic_height],classid=$add[classid],adtype=$add[adtype],title='$add[title]',target='$add[target]',alt='$add[alt]',starttime='$add[starttime]',endtime='$add[endtime]',adsay='$add[adsay]',titlefont='$ttitlefont',titlecolor='$titlecolor',htmlcode='$add[htmlcode]',t=$add[t],ylink=$add[ylink],reptext='$add[reptext]'".$a." where adid='$add[adid]'"); UpdateTheFileEditOther(3,$add['adid'],'other'); GetAdJs($add[adid]); if($sql) { //操作日志 insert_dolog("adid=".$add[adid]."
title=".$add[title]); printerror("EditAdSuccess","ListAd.php?time=$time".hReturnEcmsHashStrHref2(0)); } else {printerror("DbError","history.go(-1)");} } //删除广告 function DelAd($adid,$userid,$username){ global $empire,$time,$public_r,$dbtbpre; $adid=(int)$adid; if(!$adid) {printerror("NotDelAdid","history.go(-1)");} //验证权限 CheckLevel($userid,$username,$classid,"ad"); $r=$empire->fetch1("select title from {$dbtbpre}enewsad where adid='$adid'"); $sql=$empire->query("delete from {$dbtbpre}enewsad where adid='$adid'"); $file="../../../d/js/acmsd/".$public_r[adfile].$adid.".js"; DelFiletext($file); //删除附件 DelFileOtherTable("modtype=3 and id='$adid'"); if($sql) { //操作日志 insert_dolog("adid=".$adid."
title=".$r[title]); printerror("DelAdSuccess","ListAd.php?time=$time".hReturnEcmsHashStrHref2(0)); } else {printerror("DbError","history.go(-1)");} } //批量生成广告 function ReAdJs_all($start=0,$from,$userid,$username){ global $empire,$public_r,$fun_r,$dbtbpre; $moreportpid=(int)$_GET['moreportpid']; $mphref=''; if($moreportpid) { $mphref=Moreport_ReturnUrlCsPid($moreportpid,0,0,''); } $start=(int)$start; if(empty($start)) { $start=0; } $b=0; $sql=$empire->query("select adid from {$dbtbpre}enewsad where adid>$start order by adid limit ".$public_r['readjsnum']); while($r=$empire->fetch($sql)) { $b=1; $newstart=$r[adid]; GetAdJs($r[adid]); } if(empty($b)) { //操作日志 insert_dolog(""); printerror("ReAdJsSuccess",$from); } echo $fun_r['OneReAdJsSuccess']."(ID:".$newstart.")"; exit(); } //清除注释 function ClearHtmlZs($text){ $text=str_replace('','',$text); $text=str_replace('-->','',$text); return $text; } //生成广告js function GetAdJs($adid){ global $empire,$public_r,$dbtbpre; $r=$empire->fetch1("select * from {$dbtbpre}enewsad where adid='$adid'"); $file=eReturnTrueEcmsPath()."d/js/acmsd/".$public_r[adfile].$adid.".js"; //到期 if($r['endtime']<>'0000-00-00'&&time()>to_time($r['endtime'])) { $r[reptext]=ClearHtmlZs($r[reptext]); $h=addslashes(str_replace("\r\n","",$r[reptext])); $html="document.write(\"".$h."\")"; WriteFiletext_n($file,$html); return ''; } if($r['ylink']) { $ad_url=$r['url']; } else { $ad_url=$public_r[newsurl]."e/public/ClickAd?adid=".$adid;//广告链接 } //----------------------文字广告 if($r[t]==1) { $r[titlefont]=$r[titlecolor].','.$r[titlefont]; $picurl=DoTitleFont($r[titlefont],$r[picurl]);//文字属性 $h="".addslashes($picurl).""; //普通显示 if($r[adtype]==1) { $html="document.write(\"".$h."\")"; } //可移动透明对话框 else { $html="document.write(\"\"); document.write(\"
关闭>>> 
 ".$h."
\");"; } } //------------------html广告 elseif($r[t]==2) { $r[htmlcode]=ClearHtmlZs($r[htmlcode]); $h=addslashes(str_replace("\r\n","",$r[htmlcode])); //普通显示 if($r[adtype]==1) { $html="document.write(\"".$h."\")"; } //可移动透明对话框 else { $html="document.write(\"\"); document.write(\"
关闭>>> 
 ".$h."
\");"; } } //------------------弹出广告 elseif($r[t]==3) { //打开新窗口 if($r[adtype]==8) { $html="window.open('".$r[url]."');"; } //弹出窗口 elseif($r[adtype]==9) { $html="window.open('".$r[url]."','','width=".$r[pic_width].",height=".$r[pic_height].",scrollbars=yes');"; } //普能网页窗口 else { $html="window.showModalDialog('".$r[url]."','','dialogWidth:".$r[pic_width]."px;dialogHeight:".$r[pic_height]."px;scroll:no;status:no;help:no');"; } } //---------------------图片与flash广告 else { $filetype=GetFiletype($r[picurl]); //flash if($filetype==".swf") { $h=""; } else { $h="".$r[alt].""; } //普通显示 if($r[adtype]==1) { $html="document.write(\"".$h."\");"; } //满屏浮动显示 elseif($r[adtype]==4) { $html="ns4=(document.layers)?true:false; ie4=(document.all)?true:false; if(ns4){document.write(\"".$h."\");} else{document.write(\"
".$h."
\");} document.write(\"\");"; } //上下浮动显示 - 右 elseif($r[adtype]==5) { $html="if (navigator.appName == 'Netscape') {document.write(\"".$h."\");} else{document.write(\"
".$h."
\");} document.write(\"\");"; } //上下浮动显示 - 左 elseif($r[adtype]==6) { $html="if(navigator.appName == 'Netscape') {document.write(\"".$h."\");} else{document.write(\"
".$h."
\");} document.write(\"\");"; } //全屏幕渐隐消失 elseif($r[adtype]==7) { $html="ns4=(document.layers)?true:false; if(ns4){document.write(\"".$h."\");} else{document.write(\"
".$h."
\");} document.write(\"\");"; } //可移动透明对话框 elseif($r[adtype]==3) { $html="document.write(\"\"); document.write(\"
关闭>>> 
 ".$h."
\");"; } else { $html="function closeAd(){huashuolayer2.style.visibility='hidden';huashuolayer3.style.visibility='hidden';}function winload(){huashuolayer2.style.top=109;huashuolayer2.style.left=5;huashuolayer3.style.top=109;huashuolayer3.style.right=5;}//if(document.body.offsetWidth>800){ {document.write(\"
".$h."
\"+\"
".$h."
\");}winload()//}"; } } WriteFiletext_n($file,$html); } $enews=$_POST['enews']; if(empty($enews)) {$enews=$_GET['enews'];} if($enews) { hCheckEcmsRHash(); } //设置访问端 $moreportpid=0; if($enews=='ReAdJs_all') { $moreportpid=Moreport_hDoSetSelfPath(0); } //增加广告 if($enews=="AddAd") { $add=$_POST['add']; $add[picurl]=$_POST['picurl']; $titlefont=$_POST['titlefont']; $titlecolor=$_POST['titlecolor']; $add['filepass']=$_POST['filepass']; AddAd($add,$titlefont,$titlecolor,$logininid,$loginin); } //修改广告 elseif($enews=="EditAd") { $add=$_POST['add']; $add[picurl]=$_POST['picurl']; $titlefont=$_POST['titlefont']; $titlecolor=$_POST['titlecolor']; $time=$_POST['time']; $add['filepass']=$_POST['filepass']; EditAd($add,$titlefont,$titlecolor,$logininid,$loginin); } //删除广告 elseif($enews=="DelAd") { $adid=$_GET['adid']; $time=$_POST['time']; DelAd($adid,$logininid,$loginin); } //批量刷新广告JS elseif($enews=="ReAdJs_all") { ReAdJs_all($_GET['start'],$_GET['from'],$logininid,$loginin); } $page=(int)$_GET['page']; $page=RepPIntvar($page); $start=0; $line=20;//每页显示条数 $page_line=12;//每页显示链接数 $offset=$page*$line;//总偏移量 $totalquery="select count(*) as total from {$dbtbpre}enewsad"; $query="select * from {$dbtbpre}enewsad"; //过期广告 $search=''; $search.=$ecms_hashur['ehref']; $where=''; $and=''; $time=(int)$_GET['time']; if($time) { $date=date("Y-m-d"); $where.="endtime<'$date' and endtime<>'0000-00-00'"; $and=' and '; $search.="&time=$time"; } //搜索 $sear=(int)$_GET['sear']; if($sear) { $keyboard=RepPostVar2($_GET['keyboard']); $show=(int)$_GET['show']; $classid=(int)$_GET['classid']; $t=(int)$_GET['t']; if($keyboard) { if($show==1) { $where.=$and."title like '%$keyboard%'"; } elseif($show==2) { $where.=$and."adsay like '%$keyboard%'"; } else { $where.=$and."(title like '%$keyboard%' or adsay like '%$keyboard%')"; } $and=' and '; } if($classid) { $where.=$and."classid='$classid'"; $and=' and '; } if($t!=9) { $where.=$and."t='$t'"; $and=' and '; } $search.="&classid=$classid&show=$show&t=$t&sear=1&keyboard=$keyboard"; } if($where) { $totalquery.=' where '.$where; $query.=' where '.$where; } $num=$empire->gettotal($totalquery);//取得总条数 $query=$query." order by adid desc limit $offset,$line"; $sql=$empire->query($query); $returnpage=page2($num,$line,$page_line,$start,$page,$search); $ty[1]="普通显示"; $ty[2]=""; $ty[3]="可移动透明对话框"; $ty[4]="满屏浮动显示"; $ty[5]="上下浮动显示 - 右"; $ty[6]="上下浮动显示 - 左"; $ty[7]="全屏幕渐隐消失"; $ty[8]="打开新窗口"; $ty[9]="弹出窗口"; $ty[10]="普通网页对话框"; $ty[11]="对联式广告"; $myt[1]="文字广告"; $myt[2]="html广告"; $myt[3]="弹出广告"; $myt[0]="图片与flash广告"; //广告类别 $csql=$empire->query("select classid,classname from {$dbtbpre}enewsadclass"); while($cr=$empire->fetch($csql)) { $cselected=''; if($classid==$cr['classid']) { $cselected=' selected'; } $options.=""; } ?> 管理广告
位置：管理广告
     
关键字： > 过期广告
fetch($sql)) { ?>
ID
广告名称
广告类型
过期时间
JS调用
点击
备注
操作

()

JS调用 | 标签调用
预览 | 修改 | 删除
说明：调用方式：<script src=广告js地址></script>或用标签调用