admin_bbs_board.asp

WAP网上购物系统源程序,,有兴趣的朋友,一起研究一下..交流经眼

<!--#include file=INC/skin.asp-->

<style>
table {WORD-BREAK: break-all;}	
</style>
<%
Dim const_txl_HomeUrl
const_txl_HomeUrl = ""
%>
<!--#include file=admin_login_check.asp-->
<%
Call OpenDatabase
txl_SiteHead const_txlname&"- 管理员"
Call BBSSET
If Request.QueryString("action")="setbbsnotic" 	THen
	Call setbbsnotic
Else
	Call bbsnotic
End If
Call closedatabase
Call web_end
Function BBSSET
Dim Reqn,WriteN
ReqN = 0
WriteN = 0
%>
  <p style="margin-left:15px;"> <br>
    <b> Wap影音论坛==<a href="admin_bbs_add_board.asp">添加版面</a>||<b><a href="admin_bbs_board.asp">版面管理</a></b></b></p>
  <table width="779" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#000000" >
    <tr> 
      <td class="blu">ID</td>
      <td class="blu">论坛名称</td>
      <td class="blu">操作</td>
      <td class="blu">顺序</td>
    </tr>
	<%
	
	dim rs,sql,total,i
	sql="select * from boards order by orderid asc,boardid desc"
	set rs=server.CreateObject("adodb.recordset")
	rs.open sql,conn,1
	total=rs.recordcount
	i=1
	for i=1 to total
	%>
    <tr bgcolor="#eeeeee" > 
      <td width="10%"><%=rs("boardid")%></td>
      <td width="25%"><%=rs("boardname")%></td>
      
    <td width="25%"><a href="admin_bbs_board_edit.asp?boardid=<%=rs("boardid")%>">修改</a> 
      <a href="admin_bbs_board_del.asp?boardid=<%=rs("boardid")%>">删版面</a> <a href="admin_bbs_admin_bbs_delannounce.asp?boardid=<%=rs("boardid")%>">删帖子</a> 
    </td>
      
    <td width="10%"><%=rs("orderid")%>
	  <%if i<>1 then %>
	  <a href="admin_bbs_orderid_edit.asp?boardid=<%=rs("boardid")%>&action=up">上</a>
	  <%else%>
	  上
	  <%end if%>
	  <%if i<>total then %>
      <a href="admin_bbs_orderid_edit.asp?boardid=<%=rs("boardid")%>&action=down">下</a>
	  <%else%>
	   下
	  <%end if%>
      </td>
    </tr>
	<%
	rs.movenext
	
	next
	%>
  </table>
<%
end function%>
<%Sub bbsnotic
dim rs,str_bbsnotic
set rs=conn.execute ("select bbsnotic from config where id=1")
str_bbsnotic=rs(0)
rs.close
set rs=nothing
%>
<form name="form1" method="post" action="?action=setbbsnotic">
  <table width="779" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#000000" >
    <tr bgcolor="#eeeeee"> 
      <td width="93%" align="center">论坛公告：<font color="#FF0000">(此公告将在影音论坛首页显示，HTML支持)</font></td>
    </tr>
    <tr bgcolor="#eeeeee" > 
      <td align="center">
<textarea name="bbsnotic" cols="70" rows="6" id="bbsnotic"><%=str_bbsnotic%></textarea></td>
    </tr>
    <tr bgcolor="#eeeeee" > 
      <td align="center"><input type="submit" name="Submit" value="提　交"> 
        　
        <input type="reset" name="Submit2" value="重　置"> 
      </td>
    </tr>
  </table>
</form>
<%End Sub%>
<%
Sub setbbsnotic
	dim sql,bbsnotic
	bbsnotic=Request.Form("bbsnotic")
	bbsnotic=Replace(bbsnotic,"'","''")
	sql="Update config set bbsnotic='"& bbsnotic&"' where id=1"
	conn.execute (sql)
	Response.Redirect(Request.ServerVariables("Script_name"))
End Sub
%>