<% sFlag = session("sFlag") %>
<%
'==================================
' 會員頁面
' 更新時間: 2006-1-9
'==================================
Dim blog_Mem
If Request.QueryString("action") = "edit" Then
If memName = Empty Then RedirectUrl("member.asp")
%>
修改用戶資訊
<%
if Session("sFlag") = "MMH" then
Set blog_Mem = connMMH.Execute("select * from blog_Member where mem_Name='"&CheckStr(memName)&"'")
else
Set blog_Mem = conn.Execute("select * from blog_Member where mem_Name='"&CheckStr(memName)&"'")
end if
If blog_Mem.EOF Or blog_Mem.bof Then
%>
<%else%>
<%
End If
blog_Mem.Close
Set blog_Mem = Nothing
%>
<%
ElseIf Request.QueryString("action") = "view" Then
%>
<%
ElseIf Request.Form("action") = "save" Then
Dim reg
reg = SaveMem
%>
<%
Else
Dim searchType
Dim PageCount, BM
Set blog_Mem = Server.CreateObject("ADODB.RecordSet")
SQL = "SELECT * FROM blog_Member order by mem_RegTime desc"
if Session("sFlag") = "MMH" then
blog_Mem.Open SQL, ConnMMH, 1, 1
else
blog_Mem.Open SQL, Conn, 1, 1
end if
SQLQueryNums = SQLQueryNums + 1
blog_Mem.PageSize = 20
blog_Mem.AbsolutePage = CurPage
%>
用戶列表
<%If blog_Mem.EOF Or blog_Mem.bof Then
response.Write "沒找到任何註冊用戶!"
Else
%>
用戶名 | 郵件 | 首頁 | 日誌 | 評論 | 留言 | 註冊時間 |
<%
Do Until blog_Mem.EOF Or PageCount = blog_Mem.PageSize
If blog_Mem("mem_HideEmail") Or Len(blog_Mem("mem_Email"))<1 Or IsNull(blog_Mem("mem_Email")) Then
BM = "![]() | "
Else
BM = "![]() | "
End If
If Len(blog_Mem("mem_HomePage"))<1 Or IsNull(blog_Mem("mem_HomePage")) Then
BM = BM&"![]() | "
Else
BM = BM&"![]() | "
End If
'If Len(blog_Mem("mem_QQ"))<1 Or IsNull(blog_Mem("mem_QQ")) Then
' BM = BM&"![]() | "
'Else
' BM = BM&"![]() | "
'End If
response.Write ""&blog_Mem("mem_Name")&" | "&BM&""&blog_Mem("mem_PostLogs")&" | "&blog_Mem("mem_PostComms")&" | "&blog_Mem("mem_PostMessageNums")&" | "&DateToStr(blog_Mem("mem_RegTime"), "Y-m-d H:I A")&" | "
PageCount = PageCount + 1
blog_Mem.movenext
Loop
response.Write "
"
response.Write "
"&MultiPage(blog_Mem.RecordCount, 20, CurPage, "?", "", "float:left","")&"
"
End If
blog_Mem.Close
Set blog_Mem = Nothing
%>
<%End if%>
<%
Function SaveMem
Dim ReInfo
Dim UID, username, Oldpassword, password, Confirmpassword, Gender, email, homepage, QQ, HideEmail, checkUser, fishQA, mimabaohuwenti, mimabaohudaan
UID = CLng(Trim(CheckStr(request.Form("UID"))))
ReInfo = Array("錯誤資訊", "", "MessageIcon")
Oldpassword = Trim(CheckStr(request.Form("Oldpassword")))
password = Trim(CheckStr(request.Form("password")))
Confirmpassword = Trim(CheckStr(request.Form("Confirmpassword")))
Gender = CheckStr(request.Form("Gender"))
email = Trim(CheckStr(request.Form("email")))
homepage = Trim(checkURL(CheckStr(request.Form("homepage"))))
QQ = CheckStr(request.Form("QQ"))
fishQA = CheckStr(request.Form("fishQA"))
if int(fishQA) = 1 then
mimabaohuwenti = CheckStr(request.Form("mimabaohuwenti"))
mimabaohudaan = CheckStr(request.Form("mimabaohudaan"))
end if
If request.Form("hiddenEmail") = 1 Then
HideEmail = True
Else
HideEmail = False
End If
If IsInteger(Gender) = False Then
ReInfo(0) = "錯誤資訊"
ReInfo(1) = "