📄 adminright3.asp
字号:
<!--#include file="conn.asp"--><!--#include file="inc/fun.asp"--><!--#include file="inc/md5.asp"-->
<%dim action,strt,i,lgname,lgpwd,lgpwdmd5,lguserid,touserid,usedtable,usetable,using,table,canadd,totable,tablestr,autotable,usedtable1,sql,bd
lgname=replace(session(prefix&"lgname"),"'","''")
lgpwd=replace(session(prefix&"lgpwd"),"'","''")
if isnull(lgname) or lgname="" or isnull(lgpwd) or lgpwd="" then
response.redirect"admincheck.asp"
else
lgpwdmd5=md5(lgpwd)
if conn.execute("select top 1 bd from admin where name='"&lgname&"' and password='"&lgpwdmd5&"' and bd=0").eof then
response.redirect"admincheck.asp"
end if
end if
lguserid=checknum(session(prefix&"lguserid"))
action=request.querystring("action")
select case action
case"sms","deloldsms","delusersms" strt="论坛留言管理"
case"sendsms","savesms" strt="群发留言"
case"table","updatetable","addtable","deltable" strt="论坛帖子数据表管理"
case"recycle","delbbsgg" strt="论坛回收站"
end select
sub send(str)
response.write"<table class=td1 border=1 cellpadding=0 cellspacing=0 style='border-collapse: collapse' bordercolor=#F4F6FC width=100% bgcolor=#749AEC height=50><tr><td width=100% ><p style='margin:5px;line-height:150%'>"&str&"</p></td></tr></table>"
end sub
%>
<link rel=stylesheet type=text/css href=inc/css.css>
<STYLE type=text/css>BODY {
SCROLLBAR-FACE-COLOR: #749AEC; SCROLLBAR-HIGHLIGHT-COLOR:#749AEC; SCROLLBAR-3DLIGHT-COLOR: #749AEC; SCROLLBAR-ARROW-COLOR:#F4F6FC; SCROLLBAR-TRACK-COLOR: #B0C7F4; SCROLLBAR-DARKSHADOW-COLOR: #749AEC}
</style>
<body topmargin="0" leftmargin="0">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td width="12"><img border="0" src="pic/admin/a1.gif"></td>
<td background="pic/admin/a2.gif" width="100%"> </td>
<td width="279"><map name="FPMap0">
<area target="_top" href="index.asp" shape="rect" coords="14, 3, 94, 22">
<area target="_top" coords="94, 3, 175, 22" shape="rect" href="admin.asp">
<area target="_top" coords="175, 3, 260, 22" shape="rect" href="admincheck.asp?action=exit">
</map><img border="0" src="pic/admin/a3.gif" usemap="#FPMap0"></td>
</tr>
</table>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="100%" bgcolor="#749AEC">
<tr>
<td class=td1 width="100%" height="35">
<img border="0" src="pic/admin/a4.gif" align="absmiddle"><%=strt%></td>
</tr>
</table>
<table border="3" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#749AEC" width="100%">
<tr>
<td width="100%" valign="top" height="475">
<%
select case action
case"sms"
%><br><form method="POST" action="adminright3.asp?action=deloldsms">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td class=td1 width="100%" height="32" colspan="2" bgcolor="#749AEC"> 删除所有已读的留言:</td>
</tr>
<tr>
<td class=td2 width="30%" height="40" bgcolor="#F4F6FC">
<p style="margin: 6">删除所有已读的留言：<br>确实要删除，请输入<font color="#FF0000">ok</font>。</td>
<td width="70%" bgcolor="#F4F6FC">
<input type="text" name="ok" size="20">
<input type="submit" value=" 确 认 删 除 " name="B1"></td>
</tr>
</table></form>
<form method="POST" action="adminright3.asp?action=delusersms">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%">
<tr>
<td class=td1 width="100%" height="32" colspan="2" bgcolor="#749AEC">
删除指定用户的所有留言：</td>
</tr>
<tr>
<td class=td2 width="30%" height="40" bgcolor="#F4F6FC">
<p style="margin: 6">删除指定用户的留言：( 用户名 )</td>
<td width="70%" bgcolor="#F4F6FC">
<input type="text" name="name" size="20"> <input type="submit" value=" 确 认 删 除 " name="B1"></td>
</tr>
</table></form>
<%case"deloldsms"
dim ok
ok=Replace(Request.Form("ok"),"'","")
if ok="ok" then
conn.execute("delete*from sms where new=false")
call send("删除已读留言成功。")
else
call send("删除已读留言失败。")
end if
case"delusersms"
dim name,userid
name=Replace(Request.Form("name"),"'","")
set rs=conn.execute("select top 1 userid from [user] where name='"&name&"'")
if rs.eof then
call send("·论坛不存在该用户<br>·<a href='javascript:history.go(-1)'><font color=#ffffff>返回重新填写</font></a>")
else
userid=rs(0)
conn.execute("delete*from sms where touserid="&userid&"")
call send("删除 "&kbbs(name)&" 的留言成功。")
end if
set rs=nothing
%>
<%case"sendsms"%>
<SCRIPT src=inc/ybbcode.js></script>
<SCRIPT>function openwin()
{
document.form1.topic.value="发送给 "+document.topic.toname.value+" 的留言";
document.form1.content.value=document.topic.content.value;
var popupWin = window.open('paper.asp?action=preview', 'showgg', 'width=500,height=400,resizable=1,scrollbars=yes,menubar=no,status=yes');
document.form1.submit()
}
</SCRIPT>
<form method="POST" action="adminright3.asp?action=savesms" name="topic">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="100%" bordercolor="#F4F6FC">
<tr>
<td class=td2 width="100%" height="32" colspan="2" bgcolor="#F4F6FC">
<font color="#FF0000">注意：该操作将会占用很大系统资源，请慎用。</font></td>
</tr>
<tr>
<td class=td2 width="25%" height="32">
<p style="line-height: 120%; margin: 4">留言对象：</td>
<td width="75%">
<p style="line-height: 120%; margin: 4">
<select style="FONT-SIZE: 9pt" name="toname">
<option value="0" selected>所有在线用户</option>
<option value="1">所有版主</option>
<option value="2">所有超级版主</option>
<option value="3">所有管理员</option>
<option value="4">所有Vip用户</option>
<option value="5">所有注册用户</option>
</select></td>
</tr>
<tr>
<td valign="top">
<p style="line-height: 120%; margin: 4"><font color="#0466CC"><b>留言内容：</b></font><br>
·UBB标签： <font color="red">√</font><br>
·HTML标签：<font color="red">√</font><br>
·字数限制：<font color="red">20k</font><br>
·<a href="javascript:emoticon('[sup]内容[/sup]')">上标</a> ·<a href="javascript:emoticon('[sub]内容[/sub]')">下标</a><br>
·<a href="javascript:emoticon('[code]内容[/code]')">插入代码</a></td>
<td>
<p style="margin: 4"><img onclick=fly() alt=飞行字 src="pic/fly.gif" border=0>
<img onclick=move() alt=移动字 src="pic/move.gif" border=0>
<img onclick=light() alt=发光字 src="pic/glow.gif" border=0>
<img onclick=ying() alt=阴影字 src="pic/shadow.gif" border=0>
<img onclick=Cbold() alt=粗体字 src="pic/bold.gif" border=0>
<img onclick=Citalic() alt=斜体字 src="pic/italicize.gif" border=0>
<img onclick=Cunder() alt=下划线 src="pic/underline.gif" border=0>
<img onclick=center() alt="居中" border="0" src="pic/center.gif">
<img onclick=image() alt=图片 src="pic/image.gif" border=0>
<img onclick=Cdir() alt=Shockwave文件 src="pic/Shockwave.gif" border=0>
<img onclick=Crm() alt=realplay视频文件 src="pic/rm.gif" border=0>
<img onclick=Cwmv() alt="Media Player视频文件" src="pic/mp.gif" border=0>
<img onclick=Curl() alt="超连接" border="0" src="pic/url1.gif">
<img onclick=Cemail() alt="Email连接" border="0" src="pic/ubb_email.gif">
<img onclick=Csound() alt="插入背景音乐" border="0" src="pic/csound.gif">
<img onclick=Cra() alt="real音频文件" border="0" src="pic/ra.gif"></p>
<p style="line-height: 150%; margin: 5">
文字大小：<select onchange=ybbsize(this.options[this.selectedIndex].value) name=a style="font-size: 9pt"><OPTION value=1>1</OPTION><OPTION value=2>2</OPTION><OPTION value=3>3</OPTION><OPTION value=4>4</OPTION></SELECT> 颜色：<select onchange=COLOR(this.options[this.selectedIndex].value) name="111" style="font-size: 9pt"><option style='COLOR:000000;BACKGROUND-COLOR:000000' value=000000>黑色</option><option style='COLOR:FFFFFF;BACKGROUND-COLOR:FFFFFF' value=FFFFFF>白色</option><option style='COLOR:008000;BACKGROUND-COLOR:008000' value=008000>绿色</option><option style='COLOR:800000;BACKGROUND-COLOR:800000' value=800000>褐色</option><option style='COLOR:808000;BACKGROUND-COLOR:808000' value=808000>橄榄色</option><option style='COLOR:000080;BACKGROUND-COLOR:000080' value=000080>深蓝色</option><option style='COLOR:800080;BACKGROUND-COLOR:800080' value=800080>紫色</option><option style='COLOR:808080;BACKGROUND-COLOR:808080' value=808080>灰色</option><option style='COLOR:FFFF00;BACKGROUND-COLOR:FFFF00' value=FFFF00>黄色</option><option style='COLOR:00FF00;BACKGROUND-COLOR:00FF00' value=00FF00>浅绿色</option><option style='COLOR:00FFFF;BACKGROUND-COLOR:00FFFF' value=00FFFF>浅蓝色</option><option style='COLOR:FF00FF;BACKGROUND-COLOR:FF00FF' value=FF00FF>粉红色</option><option style='COLOR:C0C0C0;BACKGROUND-COLOR:C0C0C0' value=C0C0C0>银白色</option><option style='COLOR:FF0000;BACKGROUND-COLOR:FF0000' value=FF0000>红色</option><option style='COLOR:0000FF;BACKGROUND-COLOR:0000FF' value=0000FF>蓝色</option><option style='COLOR:008080;BACKGROUND-COLOR:008080' value=008080>蓝绿色</option></select> 字限：<INPUT disabled maxLength=5 name=total size=4 value=20480>
已写：<INPUT disabled maxLength=5 name=used size=4 value=0>
剩余：<INPUT disabled maxLength=5 name=remain size=4 value=20480><BR>
<SCRIPT language=javascript>
<!--
function gbcount(message,total,used,remain)
{
var max;
max = total.value;
if (message.value.length > max) {
message.value = message.value.substring(0,max);
used.value = max;
remain.value = 0;
alert("您输入的帖子内容已经超过系统允许的最大值20480字节！\n请删减部分帖子内容在发表！");
}
else {
used.value = message.value.length;
remain.value = max - used.value;
}
}
-->
</SCRIPT><br> <textarea rows="9" name="content" cols="85" style="font-family: 宋体; font-size: 9pt" onkeydown=presskey(); onkeyup=gbcount(this.form.content,this.form.total,this.form.used,this.form.remain);></textarea>
<p style="line-height: 150%; margin: 5">
<script>
ii=0
for(i=1;i<=9;i=i+1) {
ii=ii+1
document.write("<A href=javascript:emoticon('[em"+i+"]')><img border=0 src=images/emote/em"+i+".gif> ")
if (ii==10){document.write("<p style='margin-top: 2; margin-bottom: 2'>");ii=0;}
}document.write("<A href=javascript:emoticon('[em"+i+"]')><img border=0 src=images/emote/em"+i+".gif>")
</script>
<SCRIPT>
function emoticon(theSmilie){
document.topic.content.value +=theSmilie + '';
document.topic.content.focus();
}
function presskey(eventobject)
{
if(event.ctrlKey && window.event.keyCode==13){this.document.topic.submit();}else{return false}
}
</SCRIPT>
</p><br></td>
</tr>
<tr>
<td colspan="2" align="center" height="40" bgcolor="#F4F6FC">
<input class=submit type=submit value=OK_！发送 name=B1> <input class=submit type=button value="预 览！" onclick=openwin()> <input class=submit type=reset value=NO_！重写 name=B2> [ 按 Alt+Enter 直接发送 ]</td>
</tr>
</table>
</div>
</form>
<form name=form1 action=paper.asp?action=preview method=post target=showgg>
<input type=hidden name=topic value=><input type=hidden name=content value=>
</form>
<%case"savesms"
dim bad,b,toname,content,contentok,content2
toname=checknum(request.form("toname"))
function checkbad(str)
if isnull(str) then exit function
bad=split(application(prefix&"badcontent"), "|")
for b=0 to ubound(bad)
str=Replace(str,bad(b),string(len(bad(b)),"*"))
next
checkbad=str
end function
content=checkbad(Request.Form("content"))
content=replace(content,"|","│")
content=replace(content,"'","''")
contentok=Replace(content," ","")
content2=content&"|"&now()+timeset/24
if toname="" or contentok="" then
call send("·请填写完整留言对象和留言内容<br>·<a href='javascript:history.go(-1)'><font color=#ffffff>返回重新填写</font></a>")
else
select case toname
case 0
set rs=conn.execute("select userid from online where userid<>0")
do while not rs.eof
conn.execute("insert into sms(fromuserid,touserid,content) values("&lguserid&","&rs("userid")&",'"&content2&"')")
rs.movenext
loop
set rs=nothing
case 1
set rs=conn.execute("select userid from [user] where grade=14")
do while not rs.eof
conn.execute("insert into sms(fromuserid,touserid,content) values("&lguserid&","&rs("userid")&",'"&content2&"')")
rs.movenext
loop
set rs=nothing
case 2
set rs=conn.execute("select userid from [user] where grade=15")
do while not rs.eof
conn.execute("insert into sms(fromuserid,touserid,content) values("&lguserid&","&rs("userid")&",'"&content2&"')")
rs.movenext
loop
set rs=nothing
case 3
set rs=conn.execute("select userid from [user] where grade=16")
do while not rs.eof
conn.execute("insert into sms(fromuserid,touserid,content) values("&lguserid&","&rs("userid")&",'"&content2&"')")
rs.movenext
loop
set rs=nothing
case 4
set rs=conn.execute("select userid from [user] where grade=13")
do while not rs.eof
conn.execute("insert into sms(fromuserid,touserid,content) values("&lguserid&","&rs("userid")&",'"&content2&"')")
rs.movenext
loop
set rs=nothing
case 5
set rs=conn.execute("select userid from [user]")
do while not rs.eof
conn.execute("insert into sms(fromuserid,touserid,content) values("&lguserid&","&rs("userid")&",'"&content2&"')")
rs.movenext
loop
set rs=nothing
end select
call send("群发留言成功。")
end if
case"table"
%><form method="POST" action="adminright3.asp?action=updatetable">
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#F4F6FC" width="100%">
<tr>
<td class=td2 width="100%" colspan="4" height="32" bgcolor="#F4F6FC"> 当前论坛已有的帖子数据表：</td>
</tr>
<tr class=td2>
<td width="20%" height="28"> 数据表名称：</td>
<td width="20%"> 帖数：</td>
<td width="20%"> 默认使用：</td>
<td width="40%"> 删除：（这样将删除相关的帖子）</td>
</tr>
<%usedtable=application(prefix&"usedtable")
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -