ȸ¿øµî·Ï £ü ºñ¹øºÐ½Ç

¤ýÀÛ¼ºÀÚ µ¥ÀÌÆ®³ª¶ó
¤ýÀÛ¼ºÀÏ 2002-06-03 (¿ù) 14:51
¤ýȨÆäÀÌÁö http://www.datenara.net
¤ýLink#2 www.datenara.net (Down:10)
¤ýÃßõ: 0  ¤ýÁ¶È¸: 1553      
¤ýIP:
¼¼¼Çº¯¼ö¸¦ ÀÌ¿ëÇÑ ·Î±×Àο¡¼­ ¹®Á¦Á¡[Áú¹®]

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


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


  0
3500
    N     ºÐ·ù     Á¦¸ñ    ±Û¾´ÀÌ ÀÛ¼ºÀÏ Á¶È¸
355 µµ¿ò ¿äû..µµ¿ÍÁÖ¼¼¿ä...¤Ð.¤Ì justnett 2002-06-11 2247
354 ±Ý´Ü Áõ»ó? ºñÈí¿¬ÀÚ 2002-06-10 1648
353 Àϱâ(¿©ÀÚ¿Í ³²ÀÚ) Àϱâ 2002-06-09 1819
352 ±Ã±ÝÇؼ­¿© °¥ÃÄÁÖ¼¼¿µ..~~~ ±Ã±ÝÀÌ 2002-06-08 1791
351 6¿ùÁÖ¸»¹Ý°³°­ ÀÚ¹Ù±âÃÊ°í±Þ Ä¿¸®Å§·³ÂüÁ¶ ±èÀ¯Áø 2002-06-04 1974
350 ¿ùµåÄÅ 16°­ ÁøÃâ°¡´É¼º ±ä±ÞÅõÇ¥ [1] ¿ùµåÄÅ 2002-06-04 1789
349 äÆà º¡°³ 2002-06-04 1227
348 ¼¼¼Çº¯¼ö¸¦ ÀÌ¿ëÇÑ ·Î±×Àο¡¼­ ¹®Á¦Á¡[Áú¹®] µ¥ÀÌÆ®³ª¶ó 2002-06-03 1553
347 ´ç½ÅÀÇ ½Å¿ëÀ» ¾Æ¸§´ä°Ô... À¯¸®±â¼úÅõÀÚ 2002-05-30 1265
346 Àú ´Ô Ȩ ¸µÅ© Çߴµ¥;¤±; ¹Ú¼öÇö 2002-05-29 2
345    Re..Àú ´Ô Ȩ ¸µÅ© Çߴµ¥;¤±; kangjaeg 2002-05-29 1
344 À̰濵 ¿øÁ¶±³Á¦ ¿©¼º ¾ó±¼°ø°³ À̾ç 2002-05-25 2032
343 ¿©±ä... À¯ÄèÇÑ 2002-05-25 1251
342 ¡Ú¡Ù¡Ú¡ÙMCSE/SCJP/À¥¸¶½ºÅÍ/À¥µðÀÚÀÎ/¸®´ª ½º[³ëµ¿ºÎÁöÁ¤±³À°.. °­ÀÌÁ¤ 2002-05-24 1317
341 ÇÎŬ "¼ºÀ¯¸®"ÀÇ ÀÌ°ÍÀÌ ÁøÂ¥´Ù. ÇÎŬ¯ 2002-05-23 1175
340 ±¹³»ÃÖÀú°¡·Î ¼îÇÎÇϼ¼¿ä!Á¦°¡ ÃßõÇϴ¼îÇθô.. ±è¼ºÁø 2002-05-17 1334
1,,,11121314151617181920,,,42