📄 jiaoliou_disp.asp
字号:
<!--#include file="open.asp" -->
<!--#include file="inc/md5.inc" -->
<%path_name=request.servervariables("SCRIPT_NAME")
strnum=len(path_name)-instrrev(path_name,"/")
self_name=right(path_name,strnum)%>
<%
doing=request.querystring("doing")
disp_id=request.querystring("disp_id")
if doing="login" then '用户登录
user_id=trim(request.form("user_id"))
pass=trim(request.form("pass"))
if user_id<>"" and pass<>"" and instr(user_id,"'")=0 and instr(user_id,"&")=0 then
pass=ucase(md5(pass))
str="select * from user_teacher where teacher_user='"&user_id&"' and teacher_pass='"&pass&"'"
set rs=conn.execute(str)
if not rs.eof then
session("zzteacher")=true
session("name")=rs("teacher_name")
if rs("teacher_class")="超级管理员" then session("zzadmin")=true end if
else
str="select * from user_student where 学籍号='"&user_id&"' and 密码='"&pass&"'"
set rs=conn.execute(str)
if not rs.eof then
session("zzstudent")=true
session("student_id")=user_id
session("name")=rs("姓名")
session("student_bj")=rs("班级")
end if
end if
end if
end if
%>
<% '置顶操作
if doing="top" then
disp_id=request.querystring("disp_id")
str="update jiaoliou set 置顶=1 where id="&disp_id&""
conn.execute(str)
response.redirect("jiaoliou.asp")
end if
if doing="untop" then
disp_id=request.querystring("disp_id")
str="update jiaoliou set 置顶=0 where id="&disp_id&""
conn.execute(str)
response.redirect("jiaoliou.asp")
end if
'删除文章
if doing="del" then
del_id=request.querystring("del_id")
str="delete from jiaoliou where id="&del_id&" or 跟贴="&del_id&""
conn.execute(str)
response.redirect("jiaoliou.asp")
end if
'写入回复
if doing="send" then
disp_id=request.querystring("disp_id")
aaa=request.form("hf_text")
if aaa<>"" then
aaa=replace(aaa,chr(13),"<br>")
aaa=replace(aaa," "," ")
namer=session("name")
str="insert into jiaoliou(是否主题,跟贴,回应日期,回应时间,回应人,内容) values(0,"&disp_id&",#"&date&"#,#"&time&"#,'"&namer&"','"&aaa&"')"
conn.execute(str)
str="update jiaoliou set 回应数=回应数+1,回应日期=#"&date&"#,回应时间=#"&time&"#,回应人='"&session("name")&"' where id="&disp_id&""
conn.execute(str)
end if
end if
'删除回复
if doing="delhf" then
delhf_id=request.querystring("delhf_id")
str="delete from jiaoliou where id="&delhf_id&""
conn.execute(str)
end if
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head><!--#include file="inc/css.css" -->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>留溪在线考试</title>
</head>
<body topmargin="1">
<!--#include file="top.asp" -->
<!--#include file="menu.asp" -->
<table width="770" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#ff99cc" bgcolor="#edebdb">
<%if session("zzteacher")=true or session("zzstudent")=true then%>
<tr>
<td height="20" class="unnamed12"><div align="center">用户已登录 用户类别：
<%if session("zzstudent")=true then%>学生 学籍号：<%=session("student_id")%> 姓名：<%=session("name")%> 班级：<%=session("student_bj")%><%end if%>
<%if session("zzteacher")=true then%>教师 姓名：<%=session("name")%><%end if%>
<%if session("zzadmin")=true then%><a href=system_setup.asp>系统设置</a><%end if%>
<a href="jiaoliou.asp">返回</a> <a href="quit.asp?back=jiaoliou.asp">退出</a></div></td>
</tr>
<%else%>
<tr>
<td height="20" class="unnamed12"> <form name="form1" method="post" action="<%=self_name%>?doing=login&disp_id=<%=disp_id%>">
<div align="center">用户登录 输入学籍号或用户名：
<input name="user_id" type="text" id="user_id" value=<%=id_disp%> size="20">
密码：
<input name="pass" type="password" id="pass" size="16">
<input type="submit" name="Submit" class="unnamed12" value="登录">
<input type="reset" name="Submit2" class="unnamed12" value="重填">
<a href="reg.asp?back=<%=self_name%>">注册</a> <a href="rereg.asp">忘记密码</a></div>
</td></form>
</tr>
<%end if%>
</table>
<table width="770" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="unnamed4"> </td>
</tr>
</table>
<table width="770" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#ff99cc" bgcolor="#edebdb">
<tr>
<td valign="top">
<%if session("zzteacher")=true or session("zzstudent")=true then%>
<div class="unnamed14h20"> <a href="jiaoliou_send.asp">发表文章</a>
<%end if%>
<% disp_id=request.querystring("disp_id")
str="update jiaoliou set 浏览数=浏览数+1 where id="&disp_id&""
conn.execute(str)
str="select 标题,内容,发表人,发表日期,发表时间,置顶,浏览数,回应数 from jiaoliou where id="&disp_id&""
set rs=conn.execute(str)%>
<table width="770" border="1" cellspacing="0" cellpadding="0">
<tr bgcolor="#CCCCCC">
<td width="200" height="22"> <div align="center" class="unnamed14">标 题</div></td>
<td width="570" class="unnamed14"> <%=rs("标题")%></td>
</tr>
<tr>
<td width="200" valign="top"> <table width="163" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td class="unnamed6"> </td>
</tr>
<tr>
<td background="images/top01.gif" class="unnamed10"> </td>
</tr>
<tr>
<td height="25" background="images/mid01.gif"> <table width="150" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="50%" class="unnamed12"> <div align="center">原
创 者：</div></td>
<td class="unnamed12"><%=rs("发表人")%></td>
</tr>
</table></td>
</tr>
<tr>
<td height="25" background="images/mid01.gif"> <table width="150" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="50%" class="unnamed12"> <div align="center">发表日期：</div></td>
<td class="unnamed12"><%=rs("发表日期")%></td>
</tr>
</table></td>
</tr>
<tr>
<td height="25" background="images/mid01.gif"> <table width="150" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="50%" class="unnamed12"> <div align="center">发表时间：</div></td>
<td class="unnamed12H"><%=rs("发表时间")%></td>
</tr>
</table></td>
</tr>
<tr>
<td height="25" background="images/mid01.gif"> <table width="150" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="50%" class="unnamed12"> <div align="center">浏
览 数：</div></td>
<td class="unnamed12"><%=rs("浏览数")%></td>
</tr>
</table></td>
</tr>
<tr>
<td height="25" background="images/mid01.gif"> <table width="150" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="50%" class="unnamed12"> <div align="center">回
应 数：</div></td>
<td class="unnamed12"><%=rs("回应数")%></td>
</tr>
</table></td>
</tr>
<tr>
<td height="25" background="images/mid01.gif" class="unnamed12"><div align="center">
<%if session("zzteacher")=true then%>
<%if rs("置顶")=0 then%>
<a href="jiaoliou_disp.asp?doing=top&disp_id=<%=disp_id%>">置顶</a>
<%else%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -