¼¼¼Çº¯¼ö¸¦ ÀÌ¿ëÇÑ ·Î±×Àο¡¼ ¹®Á¦Á¡[Áú¹®] ¾È³çÇϼ¼¿ä. 5¿ù ÃÊ »çÀÌÆ®¸¦ ¿ÀÇÂÇÏ¿© ¿ÀÇÂÁßÀÎ
»çÀÌÆ® °ü¸®ÀÚÀÔ´Ï´Ù. ´ä´äÇÑ°Ô ÀÖ¾î¼ ¹®ÀÇ µå¸³´Ï´Ù.
asp¿¡¼ ¼¼¼Çº¯¼ö¸¦ »ç¿ëÇÏ¿© ·Î±×Àΰú ·Î±×¾Æ¿ô ±×¸®°í
ȸ¿øÁ¤º¸¸¦ ¿¬°áÇÏ¿© ¼¼¼Çº¯¼ö¿¡ ´ã¾Æ »ç¿ëÇÏ°í ÀÖ½À´Ï´Ù.
±×·±µ¥ ÀϺΠºê¶ó¿ìÀú¿¡¼ ÀÌ°Ô Àß µÇÁö ¾Ê½À´Ï´Ù.
·Î±×ÀÎÀ» Çϸé À̸§°ú ¹æ¹®È½¼öµîÀ» DB¿¡¼ ºÒ·¯¿Í¼
***´Ô ¾È³çÇϼ¼¿ä? **¹ø° ¹æ¹®ÀÔ´Ï´Ù.¶ó°í ·Î±×ÀΠâ¿¡
¶ç¿ö¾ß µÇ´Âµ¥ ¾î´ÀÄÄ¿¡¼´Â µÇ°í ¾î´ÀÄÄ¿¡¼´Â Çѹø¿¡
·Î±×ÀÎÀÌ µÉ¶§µµ ÀÖ°í »õ·Î°íħÇØ¾ß µÉ¶§µµ ÀÖ°í »õ·Î°íħÀ»
°è¼Ó ´·¯ºÁµµ µÇÁö¾Ê´Â °æ¿ìµµ ÀÖ½À´Ï´Ù.
¼¼¼Çº¯¼ö°¡ »õ·Î ÁöÁ¤ µÇ¾ú´Âµ¥ Àü¿¡ ÀÖ´ø ÀúÀåµÈ ÆäÀÌÁö¸¦ °è¼Ó
ÀÐ¾î ¿À´Âµí ½Í½À´Ï´Ù.
¼Ò½º´Â ´ëÃæ ¾Æ·¡¿Í °°½À´Ï´Ù.
´Ù¸¥ ÆäÀÌÁö¿¡µµ <% response.expires=0 %> Äڵ尡 ùÁÙ¿¡ µé¾î
ÀÖ½À´Ï´Ù.
<% response.expires=0 %>
<%
id=request("userid")
pwd=request("pwd")
nowdoc=request("nowdoc")
set db=Server.CreateObject("ADODB.Connection")
db.open ("dsn=datenaraDB; uid=sa; pwd=hmk0129")
SQL="select mem_name,mem_id,mem_pwd,mem_sex,mem_class from Member where mem_id='" & id & "'"
set rs=Server.CreateObject("ADODB.Recordset")
rs.Open SQL, db
if rs.eof or rs.bof then
%>
<script language="javascript">
<!--
alert("Á¸ÀçÇÏÁö ¾Ê´Â IDÀÔ´Ï´Ù.")
history.back()
file://-->
</script>
<%
elseif rs("mem_pwd")<>pwd then
%>
<script language="javascript">
<!--
alert("PassWord°¡ ÀÏÄ¡ÇÏÁö ¾Ê½À´Ï´Ù")
history.back()
file://-->
</script>
<%
else
session("id")=rs("mem_id")
session("name")=rs("mem_name")
session("mclass")=rs("mem_class")
& nbsp;session("sex")=rs("mem_sex")
rs.close
set rs = Nothing
SQL="select count(*) from SendDate where mem_id = '" & id & "'"
set rt1=db.execute(SQL)
session("sdate") = rt1(0)
rt1.close
set rt1 = Nothing
SQL="select count(*) from SendDate where mem_id = '" & id & "' and sd_ok='ok'" 'ok¹ÞÀº ¼ö
set rt2=db.execute(SQL)
session("sdok") = rt2(0)
rt2.close
set rt2 = Nothing
SQL="select count(*) from RcvDate where mem_id = '" & id & "'"
set rt3=db.execute(SQL)
session("rdate") = rt3(0)
rt3.close
set rt3 = Nothing
SQL="select count(*) from RcvDate where mem_id = '" & id & "' and rd_ok='ok'"
set rt4=db.execute(SQL)
session("rdok") = rt4(0)
rt4.close
set rt4 = Nothing
SQL="select count(*) from ImrList where mem_id = '" & id & "'"
set rt5=db.execute(SQL)
session("imr") = rt5(0)
rt5.close
set rt5 = Nothing
SQL="select count(*) from ImeList where mem_id = '" & id & "'"
set rt6=db.execute(SQL)
session("ime") = rt6(0)
rt6.close
set rt6 = Nothing
SQL="update Actstatus set act_visit = act_visit + 1 where mem_id = '" & id & "'"
db.execute SQL
SQL="update Actstatus set act_lastday ='" & now() & "' where mem_id = '" & id & "'"
db.execute SQL
%>
<script language="javascript">
<!--
window.top.location.replace('<%=nowdoc%>')
window.close();
file://-->
</script>
<%
end if
db.close
set db = Nothing
%>
¹Ù»Ú½Ã´õ¶óµµ °æÇèÀÌ °è½Å ºÐµéÀÇ Á¶¾ðÀ» ±â´Ù¸®°Ú½À´Ï´Ù.
¼¹öÀÇ ¹®Á¦ÀÎÁö.. ºê¶ó¿ìÀúÀÇ ¹®Á¦ÀÎÁö...
¾Æ´Ï¸é ÇÁ·Î±×·¥ÀÇ ¹®Á¦ÀÎÁö ¾Ë ¼ö°¡ ¾ø½À´Ï´Ù.
¼¹ö³ª ºê¶ó¿ìÀúÀÇ ¹®Á¦¶ó¸é ¼³Á¤À» ¾î¶»°Ô ¹Ù²Ù¾î¾ß µÇ´ÂÁö ¾Æ½Ã´Â ºÐ
´äº¯À» ¾ÖŸ°Ô ±â´Ù¸®°Ú½À´Ï´Ù.
Á¦»ý°¢¿£ ºê¶ó¿ìÀú ¹öÀü¿¡ µû¶ó ¶Ç´Â ºê¶ó¿ìÀú ¼³Á¤¿¡ µû¶ó ÀÌ·± Çö»óÀÌ »ý±â´Â°Ô
¾Æ´Ñ°¡ »ý°¢ µË´Ï´Ù. ¿Ö³Ä¸é ÄÄÇ»ÅÍ¿¡ µû¶ó Á¤»óÀûÀ¸·Î µ¿ÀÛÇÏ´Â°Ô ´õ ¸¹½À´Ï´Ù.
Ȥ½Ã ¸ÞÀÏ Áֽøé datenara@empal.com ÀÔ´Ï´Ù.
°áÈ¥Á¤º¸ »çÀÌÆ®Àε¥ ¸ÞÀÏ·Î ¿¬¶ôÁÖ½Ã¸é ´õ¿í
°¨»çÇÏ°Ú½À´Ï´Ù.
°¨»çÇÕ´Ï´Ù. ÁÁÀº ÇÏ·ç µÇ½Ê½Ã¿ä.