%
Set UploadForm = Server.CreateObject("SiteGalaxyUpload.Form")
set userinfo = server.createobject("ADODB.Connection")
userinfo.open session("dsn")
if UploadForm("name") = "" then
set reqfield=userinfo.execute("select * from " & session("linktable") & " where ÀϷùøÈ£ = " & request.querystring("seqnum"))
textdata = reqfield.fields("³»¿ë")
textdata = Replace(textdata, "&", "&")
textdata = Replace(textdata, "<BR>", chr(13))
textdata = Replace(textdata, " ", chr(32))
textdata = Replace(textdata, ">", ">")
textdata = Replace(textdata, "<", "<")
textdata = Replace(textdata, "
", chr(13))
textdata = Replace(textdata, "''", "'")
session("seqnum") = request.querystring("seqnum")
else
%>
<%
SQLString = "select count(*) from " & session("linktable") & " where ÀϷùøÈ£=" & session("seqnum") & " and ¾ÏÈ£='" & UploadForm("pwd") & "'"
set pwdchk = userinfo.Execute(SQLString)
if pwdchk.fields(0) = 0 and Uploadform("pwd")&";" <> mid(session("dsn"),instr(session("dsn"),"PWD")+4) then
Userinfo.close
set Userinfo=nothing
%>
<%
else
wdate = Year(now) & "-" & Month(now) & "-" & Day(now)
'-----------³»¿ë Á¤¸® --------------
textdata = Replace(textdata, "'", "''")
textdata = Replace(textdata, chr(32), " ")
textdata = Replace(textdata, chr(13), "
")
'-----------³»¿ë Á¤¸® --------------
%>
<%
if Uploadform("pwd")&";" = mid(session("dsn"),instr(session("dsn"),"PWD")+4) then
userinfo.execute("update " & session("linktable") & " set " &_
" À̸§ = '" & UploadForm("name") & "'," &_
" ÀüÀÚ¸ÞÀÏ = '" & UploadForm("email") & "'," &_
" Á¦¸ñ = '" & subject & "'," &_
" ³»¿ë = '" & textdata & "' where ÀϷùøÈ£ = " & session("seqnum"))
else
userinfo.execute("update " & session("linktable") & " set " &_
" ÀÔ·ÂÀÏÀÚ = '" & wdate & "'," &_
" À̸§ = '" & UploadForm("name") & "'," &_
" ÀüÀÚ¸ÞÀÏ = '" & UploadForm("email") & "'," &_
" Á¦¸ñ = '" & subject & "'," &_
" ³»¿ë = '" & textdata & "' where ÀϷùøÈ£ = " & session("seqnum"))
end if
userinfo.close
set userinfo=nothing
response.redirect "boardlist.asp"
end if
end if
%>