memberlist.aspx.vb

本程序修改自飞天BBS 7.0 将原来的ASP语法迁移为ASP.NET并封装成DLL ASP.NET相对ASP有更快的执行效率以及更高的并发访问量 基于ASP.NET的DLL可以运行在支持ASP

' ***************************************************
' *        本程序由AspToAspX风火轮0.99转换生成      *
' *        http://Www.AspToAspX.Cn                  *
' *        Q Q :  139227536                         *
' *        QQ群:  17152722                          *
' *        MSN :  [e-mail]        *
' *        EMail  [e-mail]              *
' ***************************************************
Imports Microsoft.VisualBasic
Imports System.Web
Imports System.Math
Imports System.Web.SessionState


Public Class _MEMBERLIST
    Inherits System.Web.UI.Page
    Implements IHttpHandler, AspToAspX_Interface

    Public AspToAspX_Host_Class_Object As Object

Public i,bgcolor
Public str_sort
Public root
Public tyname1
Public tyvalue1
Public pagestr
Public getcodeoff
Public onlineoff
Public linkoff
Public defaulthome
Public wzrep
Public homepage
Public sql
Public rs As ADODB.Recordset
Public wzpage
Public wzpagecount
Public wzcount
Public linkdb
Public ft
Public ku
Public ckiesdomain
Public conndb
Public ConnectionString
Public userinfo
Public userinfox
Public num
Public smsnum
    Public ASPX_CONN As _CONN
    Public ASPX_FTBBS_NAV As _FTBBS_NAV
    Public ASPX_PAGEFUN As _PAGEFUN
    Public ASPX_BBSUSER As _BBSUSER
    Public ASPX_INC_BBSTAIL_HTM As _INC_BBSTAIL_HTM
#Region "..."
    Public Sub AspToAspX_InitIncludeFiles()
        ASPX_CONN = New _CONN()
        ASPX_CONN.AspToAspX_Host_Class_Object = AspToAspX_Host_Class_Object
        ASPX_CONN.AspToAspX_InitIncludeFiles()
        ASPX_FTBBS_NAV = New _FTBBS_NAV()
        ASPX_FTBBS_NAV.AspToAspX_Host_Class_Object = AspToAspX_Host_Class_Object
        ASPX_FTBBS_NAV.AspToAspX_InitIncludeFiles()
        ASPX_PAGEFUN = New _PAGEFUN()
        ASPX_PAGEFUN.AspToAspX_Host_Class_Object = AspToAspX_Host_Class_Object
        ASPX_PAGEFUN.AspToAspX_InitIncludeFiles()
        ASPX_BBSUSER = New _BBSUSER()
        ASPX_BBSUSER.AspToAspX_Host_Class_Object = AspToAspX_Host_Class_Object
        ASPX_BBSUSER.AspToAspX_InitIncludeFiles()
        ASPX_INC_BBSTAIL_HTM = New _INC_BBSTAIL_HTM()
        ASPX_INC_BBSTAIL_HTM.AspToAspX_Host_Class_Object = AspToAspX_Host_Class_Object
        ASPX_INC_BBSTAIL_HTM.AspToAspX_InitIncludeFiles()
    End Sub

    Public Sub AspToAspX_UnloadIncludeFiles()
        ASPX_CONN.AspToAspX_UnloadIncludeFiles()
        ASPX_CONN = Nothing
        ASPX_FTBBS_NAV.AspToAspX_UnloadIncludeFiles()
        ASPX_FTBBS_NAV = Nothing
        ASPX_PAGEFUN.AspToAspX_UnloadIncludeFiles()
        ASPX_PAGEFUN = Nothing
        ASPX_BBSUSER.AspToAspX_UnloadIncludeFiles()
        ASPX_BBSUSER = Nothing
        ASPX_INC_BBSTAIL_HTM.AspToAspX_UnloadIncludeFiles()
        ASPX_INC_BBSTAIL_HTM = Nothing
    End Sub

#End Region
    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs)
        AspToAspXGlobal.Application = Application
        AspToAspXGlobal.Server = Server
        AspToAspXGlobal.Response = Response
        AspToAspXGlobal.Request = Request
        AspToAspXGlobal.Session = Session
        AspToAspX_Host_Class_Object = Me
        AspToAspX_InitIncludeFiles()
        AspToAspX_Page_Init()
        End Sub
    Public Sub AspToAspX_Page_Init()
    On Error GoTo _AspToAspX_Err
    ASPX_CONN.AspToAspX_Page_Init ( )
    ASPX_FTBBS_NAV.AspToAspX_Page_Init ( )
    ASPX_PAGEFUN.AspToAspX_Page_Init ( )
    ASPX_BBSUSER.AspToAspX_Page_Init ( )
    str_sort = Request ( "order_key" ) '6
    If AspToAspX_CheckDBNull ( str_sort ) = EmptyString.Value Then '7
        str_sort = "clubuser_id" '8
    End If '9
    root = "" '10
    tyname1 = "order_key" '11
    tyvalue1 = str_sort '12
    pagestr = "&" & tyname1 & "=" & tyvalue1 '13
    FTBBS_HTML_MB ( ft ) '14
    getcodeoff = Application ( "FTBBSMB" ) ( 30 , 0 ) '15
    onlineoff = Application ( "FTBBSMB" ) ( 33 , 0 ) '16
    linkoff = Application ( "FTBBSMB" ) ( 34 , 0 ) '17
    defaulthome = Application ( "FTBBSMB" ) ( 31 , 0 ) '18
    wzrep = Application ( "FTBBSMB" ) ( 5 , 0 ) '19
    homepage = ft_home ( defaulthome ) '20
    sql = "select clubuser_id,clubuser_name,clubuser_sex,clubuser_enter_count,clubuser_reg_date,clubuser_lasttime,postnum,jingyuan from " & ft & "clubuser order by " & str_sort & " desc" '21
    rs = New ADODB.Recordset ( ) '22
    rs.Open ( sql , conn , 1 , 1 ) '23
    If Not rs.EOF Then '24
        wzpage = AspToAspX_CInt ( Request ( "page" ) ) '26
    If AspToAspX_Len ( wzpage ) = 0 Or AspToAspX_CheckDBNull ( wzpage ) = 0 Then
wzpage = 1
End If
    '28
        rs.PageSize = wzrep '29
        rs.AbsolutePage = wzpage '30
        wzpagecount = rs.PageCount '31
        wzcount = rs.RecordCount '32
        Response.Write ( vbCrLf )
        Response.Write ( "<HTML><HEAD>" & Chr ( 13 ) ) '34
        Response.Write ( "<META http-equiv=Content-Type content=text/html;charset=utf-8>" & Chr ( 13 ) ) '35
        Response.Write ( "<title>" ) '36
        Response.Write ( Application ( "FTBBSMB" ) ( 11 , 0 ) ) '36
        Response.Write ( "-会员列表</title>" & Chr ( 13 ) ) '36
        Response.Write ( "<script language=javascript src=""inc/cookies.js""></script>" & Chr ( 13 ) ) '37
        Response.Write ( "<script>" & Chr ( 13 ) ) '38
        Response.Write ( "var stylecook = getCookie(""STYLESHOW"");" & Chr ( 13 ) ) '39
        Response.Write ( "var style;" & Chr ( 13 ) ) '40
        Response.Write ( "var strstyle;" & Chr ( 13 ) ) '41
        Response.Write ( "if(stylecook=="""")" & Chr ( 13 ) ) '42
        Response.Write ( "{" & Chr ( 13 ) ) '43
        Response.Write ( " stylecook=1;" & Chr ( 13 ) ) '44
        Response.Write ( "}" & Chr ( 13 ) ) '45
        Response.Write ( "else" & Chr ( 13 ) ) '46
        Response.Write ( "{" & Chr ( 13 ) ) '47
        Response.Write ( " stylecook++;" & Chr ( 13 ) ) '48
        Response.Write ( "}" & Chr ( 13 ) ) '49
        Response.Write ( "style=""main0""+stylecook+"".css"";" & Chr ( 13 ) ) '50
        Response.Write ( "strstyle=""<link href=\""css/""+style+""\""  rel=\""stylesheet\"" type=\""text/css\""> "";" & Chr ( 13 ) ) '51
        Response.Write ( "document.write(strstyle);" & Chr ( 13 ) ) '52
        Response.Write ( "</script>" & Chr ( 13 ) ) '53
        Response.Write ( "</HEAD>" & Chr ( 13 ) ) '54
        Response.Write ( "<body>" & Chr ( 13 ) ) '55
        Response.Write ( "<script>" & Chr ( 13 ) ) '56
        Response.Write ( "var stylecook = getCookie(""STYLESHOW"");" & Chr ( 13 ) ) '57
        Response.Write ( "var style;" & Chr ( 13 ) ) '58
        Response.Write ( "var tmpstylecook;" & Chr ( 13 ) ) '59
        Response.Write ( "function setcookies()" & Chr ( 13 ) ) '60
        Response.Write ( "{" & Chr ( 13 ) ) '61
        Response.Write ( " tmpstylecook = stylecook;" & Chr ( 13 ) ) '62
        Response.Write ( "}" & Chr ( 13 ) ) '63
        Response.Write ( "function  reloadcook()" & Chr ( 13 ) ) '64
        Response.Write ( "{" & Chr ( 13 ) ) '65
        Response.Write ( "   var scooks = getCookie(""STYLESHOW"");" & Chr ( 13 ) ) '66
        Response.Write ( "   if(scooks != tmpstylecook)" & Chr ( 13 ) ) '67
        Response.Write ( "   {" & Chr ( 13 ) ) '68
        Response.Write ( " " & Chr ( 9 ) & "window.location.reload();" & Chr ( 13 ) ) '69
        Response.Write ( "   }" & Chr ( 13 ) ) '70
        Response.Write ( "}" & Chr ( 13 ) ) '71
        Response.Write ( "setcookies();" & Chr ( 13 ) ) '72
        Response.Write ( "setInterval('reloadcook()',1000);" & Chr ( 13 ) ) '73
        Response.Write ( "</script>" & Chr ( 13 ) ) '74
        If AspToAspX_CheckDBNull ( getcookie ( "ftbbstype" ) ) = 1 Then '76
            Response.Write ( headhtml ) '77
        End If '78
        Response.Write ( vbCrLf )
        Response.Write ( "<table width=""99%"" border=0 align=""center"" cellpadding=2 cellspacing=1 class=""maintbbg"">" & Chr ( 13 ) ) '80
        Response.Write ( "  <tbody>" & Chr ( 13 ) ) '81
        Response.Write ( "          <tr> " & Chr ( 13 ) ) '82
        Response.Write ( "            <td height=""25"" class=""f12bg"">&nbsp;" ) '83
        Response.Write ( userinfo ) '83
        Response.Write ( "</td>" & Chr ( 13 ) ) '83
        Response.Write ( "          </tr>" & Chr ( 13 ) ) '84
        Response.Write ( "          <tr>" & Chr ( 13 ) ) '85
        Response.Write ( "            <td height=""26"" class=""maintbtr3""><table width=""100%"" border=0 cellpadding=0 cellspacing=0>" & Chr ( 13 ) ) '86
        Response.Write ( "                <tbody>" & Chr ( 13 ) ) '87
        Response.Write ( "                  <tr> " & Chr ( 13 ) ) '88
        Response.Write ( "                    <td class=f12><img src=""images/bbs_t1.gif"" align=""absmiddle""> " & Chr ( 13 ) ) '89
        Response.Write ( "                      <a href=""" ) '90
        Response.Write ( homepage ) '90
        Response.Write ( """>论坛首页</a>>>会员列表 " & Chr ( 13 ) ) '90
        Response.Write ( "                    </td>" & Chr ( 13 ) ) '91
        Response.Write ( "                  </tr>" & Chr ( 13 ) ) '92
        Response.Write ( "                </tbody>" & Chr ( 13 ) ) '93
        Response.Write ( "              </table></td>" & Chr ( 13 ) ) '94
        Response.Write ( "          </tr>" & Chr ( 13 ) ) '95
        Response.Write ( "        </tbody>" & Chr ( 13 ) ) '96
        Response.Write ( "</table>" & Chr ( 13 ) ) '97
        Response.Write ( "<table width=""99%"" border=""0"" align=""center"" cellpadding=""0"" cellspacing=""1"">" & Chr ( 13 ) ) '98
        Response.Write ( "  <tr> " & Chr ( 13 ) ) '99
        Response.Write ( "    <td height=5><spacer height=""5"" type=""block""></td>" & Chr ( 13 ) ) '100
        Response.Write ( "  </tr>" & Chr ( 13 ) ) '101
        Response.Write ( "</table>" & Chr ( 13 ) ) '102
        Response.Write ( "<table width=""99%"" border=0 cellpadding=2 cellspacing=0 class=""listborder"" align=""center"">" & Chr ( 13 ) ) '103
        Response.Write ( "  <tbody>" & Chr ( 13 ) ) '104
        Response.Write ( "    <tr valign=""top""> " & Chr ( 13 ) ) '105
        Response.Write ( "      <td colspan=""8"" class=""maintbtr1""> <table width=""100%"" border=""0"" cellspacing=""0"" cellpadding=""0"" align=""center"">" & Chr ( 13 ) ) '106
        Response.Write ( "          <tr> " & Chr ( 13 ) ) '107
        Response.Write ( "            <td align=""left"" height=""25"">" & Chr ( 13 ) ) '108
        Response.Write ( "              " ) '109
        Response.Write ( pageclass ( wzpagecount , wzcount , wzrep , pagestr , root ) ) '109
        Response.Write ( vbCrLf )
        Response.Write ( "            </td>" & Chr ( 13 ) ) '110
        Response.Write ( "          </tr>" & Chr ( 13 ) ) '111
        Response.Write ( "        </table></td>" & Chr ( 13 ) ) '112
        Response.Write ( "    </tr>" & Chr ( 13 ) ) '113
        Response.Write ( "    <tr align=""left"" class=f12> " & Chr ( 13 ) ) '114
        Response.Write ( "      <td width=""16%"" height=""28"" class=""tdborder"">&nbsp;<a class=map href=""memberlist.aspx?order_key=clubuser_name"">用户名</a></td>" & Chr ( 13 ) ) '115
        Response.Write ( "      <td width=""15%"" class=""tdborder"">&nbsp;<a class=map href=""memberlist.aspx?order_key=clubuser_id"">UID</a></td>" & Chr ( 13 ) ) '116
        Response.Write ( "      <td width=""15%"" class=""tdborder"">&nbsp;<a class=map href=""memberlist.aspx?order_key=clubuser_sex"">性别</a></td>" & Chr ( 13 ) ) '117
        Response.Write ( "      <td width=""17%"" class=""tdborder"">&nbsp;<a class=map href=""memberlist.aspx?order_key=clubuser_reg_date"">注册时间</a></td>" & Chr ( 13 ) ) '118
        Response.Write ( "      <td width=""17%"" class=""tdborder"">&nbsp;<a class=map href=""memberlist.aspx?order_key=clubuser_lasttime"">上次访问时间</a></td>" & Chr ( 13 ) ) '119
        Response.Write ( "      <td width=""10%"" class=""tdborder"">&nbsp;<a class=map href=""memberlist.aspx?order_key=postnum"">贴子</a></td>" & Chr ( 13 ) ) '120
        Response.Write ( "      <td width=""10%"" class=""tdborder"">&nbsp;<a class=map href=""memberlist.aspx?order_key=jingyuan"">积分值</a></td>" & Chr ( 13 ) ) '121
        Response.Write ( "    </tr>" & Chr ( 13 ) ) '122
        Response.Write ( "    " ) '123
        For i = 0 To Val ( wzrep ) - 1 '124
        If rs.EOF Then
Exit For
End If
    '125
            Response.Write ( vbCrLf )
            Response.Write ( "    <tr align=""left""> " & Chr ( 13 ) ) '127
            Response.Write ( "      <td width=""16%"" height=""28"" class=""loopborder1"" align=""left"">&nbsp;<a class=map href=""home.aspx?userid=" ) '128