admin_usermana.asp

一个美化的论坛程序

<!--#include file="function.asp"-->
<%CheckAdmin%>
<script language="javascript">
<!--
   function test(n) {
      result=confirm("警告！\n将同时删除该用户所有帖子！是否继续？");
	  if (result){
	  window.open('admin_userdel.asp?name='+n,'_self');
	  }
    }
//-->
</script>
<!--#include file="conn.asp"-->
<%
if not isempty(request("page")) then
	currentPage=cint(request("page"))
else
	currentPage=1
end if
%>
<!--#include file="top.asp"-->
<img src="" width="1" height="3"><table border="0" width="680" cellspacing="1" cellpadding="1" bgcolor="<%=tablebackcolor%>" align="center">
  <tr> 
    <td valign=top width="20%" bgcolor="<%=tabletitlecolor%>"> 
      <!--#include file="admin_left.asp"-->
    </td>
    <td align=center valign=top bgcolor="<%=tablebodycolor%>"> 
      <%
set rs=server.createobject("adodb.recordset")
sql="select id,username,lockuser from user order by id desc" 
rs.open sql,conn,1,1
if rs.eof and rs.bof then 
	response.write "<p align='center'>暂时没有会员注册</p>" 
else 
	PageUrl="admin_UserMana.asp"
	totalPut=rs.recordcount 
	if currentpage<1 then currentpage=1
	if (currentpage-1)*MaxPerPage>totalput then 
		if (totalPut mod MaxPerPage)=0 then 
			currentpage= totalPut \ MaxPerPage 
		else 
			currentpage= totalPut \ MaxPerPage + 1 
		end if 
	end if 
	if currentPage=1 then 
		showpage totalput,MaxPerPage,PageUrl
		showContent 
		showpage totalput,MaxPerPage,PageUrl
	else 
		if (currentPage-1)*MaxPerPage<totalPut then 
			rs.move  (currentPage-1)*MaxPerPage 
			dim bookmark 
			bookmark=rs.bookmark 
			showpage totalput,MaxPerPage,PageUrl
			showContent 
			showpage totalput,MaxPerPage,PageUrl
		else 
			currentPage=1 
			showpage totalput,MaxPerPage,PageUrl
			showContent 
			showpage totalput,MaxPerPage,PageUrl
		end if 
	end if 
end if 
rs.close 
			
sub showContent 
i=0 
%>
      <table border="0" width="98%" cellspacing="1" cellpadding="0" class="TableLine" bordercolorlight="<%=MainBColor%>" bgcolor="<%=tablebackcolor%>">
        <tr bgcolor="<%=tabletitlecolor%>"> 
          <td width="10%" height=22 align=center><font color="#FFFFFF">ID</font></td>
          <td width="60%" height=22 align=center><font color="#FFFFFF">会员</font></td>
          <td width="10%" height=22 align=center><font color="#FFFFFF">修改</font></td>
          <td width="10%" height=22 align=center><font color="#FFFFFF">锁定</font></td>
          <td width="10%" height=22 align=center><font color="#FFFFFF">删除</font></td>
        </tr>
        <%
do while not rs.eof
	i=i+1
%>
        <tr bgcolor="<%=tablebodyacolor%>"> 
          <td align=center><%=rs("id")%>　</td>
          <td align=center><a href="Userinf.asp?id=<%=rs("id")%>" target=_blank><%=rs("UserName")%></a></td>
          <td align=center> 
          <a href=admin_UserModify.asp?id=<%=rs("id")%>>修改</a>
          </td>
          <td align=center> 
          <a href=admin_UserSave.asp?id=<%=rs("id")%>&act=lock><%if rs("lockuser")=false then%>未锁定<%else%><font color=#ff0000>已锁定</font><%end if%></a>
          </td>
          <td align=center> 
          <a href="javascript:test('<%=rs("username")%>')">删除</a>
          </td>
        </tr>
        <%
	if i>=MaxPerPage then exit do
rs.movenext
loop
%>
      </table>
      <%
end sub 

function showpage(totalnumber,maxperpage,filename)
dim n
if totalnumber mod maxperpage=0 then
	n= totalnumber \ maxperpage
else
	n= totalnumber \ maxperpage+1
end if
response.write "<form method=post action="&filename&">"
if CurrentPage<2 then
response.write "&nbsp;首页&nbsp;|&nbsp;上一页&nbsp;|"
else
response.write "&nbsp<a href="&filename&"?boardid="&boardid&"&page=1>首页</a>&nbsp;|&nbsp;<a href="&filename&"?boardid="&boardid&"&page="&CurrentPage-1&">上一页</a>&nbsp;|" 
end if
if n-currentpage<1 then
response.write "&nbsp;下一页&nbsp;|&nbsp;末页"
else
response.write "&nbsp;<a href="&filename&"?boardid="&boardid&"&page="&CurrentPage+1&">下一页</a>&nbsp;|"&_
                "&nbsp;<a href="&filename&"?boardid="&boardid&"&page="&n&">末页</a>" 
end if
response.write "&nbsp;|&nbsp;页次:<strong>"&CurrentPage&"/"&n&"</strong>页 | 转到:<select name='page' size='1' onchange='javascript:submit()'>"
               for i = 1 to n
response.write "<option value="&i
 				if cint(CurrentPage)=cint(i) then response.write " selected "
response.write ">第"&i&"页</option>"
                next
response.write "</select></form>"      
end function
%>
    </td>
  </tr>
</table>
<!--#include file="copyright.asp"--></div>
<p></p>
<%
set rs=nothing
conn.close
set conn=nothing%>
</body>
</html>