📄 modifyaction.asp

📁 5237 论坛.rar
💻 ASP
字号:
<!--#include file="Connections/connY.asp" -->
<!--#include file="Inc/Info.asp" -->
<!--#include file="Inc/TimeFormat.asp" -->
<!--#include file="Inc/UBBCode.asp" -->
<!--#include file="Inc/Md5.asp" -->
<!--#include file="Inc/SetCss.asp" -->
<%
Sex=Request.Form("Sex")
NickName=Request.Form("NickName")
OldUserID=Request.Form("OldUserID")
UserID=Request.Form("UserID")
If Request("PFace")="" Then
PFace=LiannCheckBadWord(Request.Form("PFace2"))
Height=Request.Form("PHeight2")
Width=Request.Form("PWidth2")
Face=Request.Form("Face")
Else
Face=Request.Form("Face2")
PFace=LiannCheckBadWord(Request.Form("PFace"))
Height=Request.Form("PHeight")
Width=Request.Form("PWidth")
End If
BirthYear=Request.Form("BirthYear")
BirthMonth=Request.Form("BirthMonth")
BirthDay=Request.Form("BirthDay")
Password=Request.Form("Pass")
Oicq=Request.Form("Oicq")
Email=Request.Form("Email")
HomePage=Request.Form("HomePage")
From=Request.Form("From")
Personality=Request.Form("Personality")
RegTime=Request.Form("RegTime")
IP=Request.Form("IP")

Set rsModify = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tUserManage Where rUserID='"&OldUserID&"'"
rsModify.Open Sql,ConnY,3,3
Set rsCheck = Server.CreateObject("ADODB.Recordset")
If rsModify("rNickName")<>NickName Then
Sql = "Select *  From tUserManage Where rNickName='"&NickName&"'"
rsCheck.Open Sql,ConnY,3,3
If Not rsCheck.Eof Then Response.Redirect "Error.asp?Error=19"
rsCheck.Close
End If
If rsModify("rUserID")<>UserID Then
Sql = "Select *  From tUserManage Where rUserID='"&UserID&"'"
rsCheck.Open Sql,ConnY,3,3
If Not rsCheck.Eof Then Response.Redirect "Error.asp?Error=20"
rsCheck.Close
End If
Set rsCheck=Nothing
Set rsA = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tArticleManage Where rPoster='"&OldUserID&"'"
rsA.Open Sql,ConnY,3,3
While Not rsA.Eof
rsA("rPoster")=UserID
rsA("rPosterNickName")=NickName
rsA.Update
rsA.MoveNext
Wend
rsA.Close
Set rsA=Nothing
Set rsV = Server.CreateObject("ADODB.Recordset")
Sql = "Select *  From tVoteManage Where rVoteUserNickName='"&OldUserID&"'"
rsV.Open Sql,ConnY,3,3
While Not rsV.Eof
rsV("rVoteUserNickName")=NickName
rsV.Update
rsV.MoveNext
Wend
rsV.Close
Set rsV=Nothing
If rsModify("rPassword")=Password Then
rsModify("rPassword")=Password
Else
rsModify("rPassword")=Md5(Password)
End If
rsModify("rNickName")=NickName
rsModify("rUserID")=UserID
rsModify("rSex")=Sex
rsModify("rFace")=Face
rsModify("rPFace")=PFace
rsModify("rWidth")=Width
rsModify("rHeight")=Height
rsModify("rEmail")=Email
rsModify("rHomePage")=HomePage
rsModify("rAddress")=From
rsModify("rPersonality")=Personality
rsModify("rOicq")=Oicq
rsModify("rBirthYear")=BirthYear
rsModify("rBirthMonth")=BirthMonth
rsModify("rBirthDay")=BirthDay
rsModify.Update
Note="<font color=red>修改信息成功<br><br><a href='Login.asp' onFocus='this.blur()'>重新登陆</a></font>"
Nav="修改信息成功"
rsModify.Close
Set rsModify=Nothing
%>
<html>
<head>
<title><%=Forum_Title%></title>
<meta http-equiv="Content-Type" content="text/html;">
<meta http-equiv="Expires" CONTENT="0">
<meta http-equiv="Cache-Control" CONTENT="no-cache">
<meta http-equiv="Pragma" CONTENT="no-cache">
<!--#include file="Inc/Css.asp" -->
</head>
<body leftmargin="0" topmargin="0" bgcolor="<%=Forum_ColorList_BgColor%>" vlink="<%=Forum_Css_A_Link_Color%>">
<!--#include file="Inc/Top.asp" -->
<table width="<%=Forum_Width%>" border="0" cellspacing="1" cellpadding="0" align="center" bgcolor="<%=Forum_ColorList_BorderColor%>">
  <tr> 
    <td height="20" bgcolor="<%=Forum_ColorList_BgColor%>"> 
      <table width="100%" border="0" cellspacing="0" cellpadding="0" class="font">
        <tr> 
          <td>&nbsp;您所在的位置： <a href="../" onFocus="this.blur()">首页</a> &gt;&gt; 
            <a href="List.asp" onFocus="this.blur()">讨论组</a> &gt;&gt; <font color="<%=Forum_ColorList_NavFontColor%>"><%=Nav%></font></td>
          <td width="150"></td>
          <td width="18"> 
            <div align="center"></div>
          </td>
        </tr>
      </table>
    </td>
  </tr>
</table>
<table width="<%=Forum_Width%>" border="0" cellspacing="0" cellpadding="0" align="center">
  <tr> 
    <td height=1></td>
  </tr>
</table>
<table width="<%=Forum_Width%>" border="0" cellspacing="1" cellpadding="2" align="center" class="font" bgcolor="<%=Forum_ColorList_BorderColor%>">
  <tr>
    <td bgcolor="<%=Forum_ColorList_BgColor%>" height="394">
      <div align="center">
        <table width="400" border="0" cellspacing="1" cellpadding="2" bgcolor="<%=Forum_ColorList_BorderColor%>" class="font">
          <tr>
            <td height="100" bgcolor="<%=Forum_ColorList_AlternateColor1%>">
              <div align="center"><%=Note%></div>
            </td>
          </tr>
        </table>
        <br>
        <br>
        <br>
        <br>
        <br>
        <br>
      </div>
    </td>
  </tr>
</table>
<!--#include file="Inc/Bottom.asp" -->
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -