À̸§: µ¥ÀÌÆ®³ª¶ó (datenara@empal.com)
ȨÆäÀÌÁö: http://www.datenara.net
2002/6/3(¿ù)
www.datenara.net(Load:35)
¼¼¼Çº¯¼ö¸¦ ÀÌ¿ëÇÑ ·Î±×Àο¡¼­ ¹®Á¦Á¡[Áú¹®]  

¾È³çÇϼ¼¿ä. 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 ÀÔ´Ï´Ù.
°áÈ¥Á¤º¸ »çÀÌÆ®Àε¥ ¸ÞÀÏ·Î ¿¬¶ôÁÖ½Ã¸é ´õ¿í
°¨»çÇÏ°Ú½À´Ï´Ù.


°¨»çÇÕ´Ï´Ù. ÁÁÀº ÇÏ·ç µÇ½Ê½Ã¿ä.


                    ´äº¯/°ü·Ã ¾²±â Æû¸ÞÀÏ ¹ß¼Û ¼öÁ¤/»èÁ¦    â´Ý±â