2009/09/18 17:01:31     18880     0   
   [Á¦·Îº¸µå4] mysql 4.0 ÀÌÇÏ¿¡¼­ 4.1 ÀÌ»óÀ¸·Î ¼­¹öÀÌÀüÈÄ ·Î±×ÀÎ ¾ÊµÉ¶§
login_check.php ÆÄÀÏ ¼öÁ¤...

¿øº»¼Ò½º¸¦...
// ȸ¿ø ·Î±×ÀΠüũ
      $result = mysql_query("select * from $member_table where user_id='$user_id' and password=password('$password')") or error(mysql_error());
      $member_data = mysql_fetch_array($result);


´ÙÀ½°ú °°ÀÌ ¼öÁ¤...
// ȸ¿ø ·Î±×ÀΠüũ
      $p_result = mysql_query("select length(password) from $member_table where user_id='$user_id'") or error("password error<br>".mysql_error());
      $p_data = mysql_fetch_row($p_result);
      if($p_data[0] == 41)
              $result = mysql_query("select * from $member_table where user_id='$user_id' and password=password('$password')") or error(mysql_error());
      else {
              $m_result = mysql_query("select * from $member_table where user_id='$user_id' and password=old_password('$password')") or error(mysql_error());
              $m_data = mysql_fetch_array($m_result);
              if($m_data[no]) {
                      @mysql_query("update $member_table set password=password('$password') where no='$m_data[no]'") or error("new password update error<br>".mysql_error());
                      $result = mysql_query("select * from $member_table where user_id='$user_id' and password=password('$password')") or error(mysql_error());
              }
              else Error("·Î±×ÀÎÀ» ½ÇÆÐÇÏ¿´½À´Ï´Ù");
      }
      $member_data = mysql_fetch_array($result);


À§¿Í°°ÀÌ ÀÛ¾÷Çϱâ Àü¿¡ zetyx_member_tableÀÇ password Ä÷³±æÀ̸¦ 20¿¡¼­ 41·Î Á¶Á¤
, 2009/09/18 17:01:46    
ÄÚ¸àÆ®¸¦ ÀÛ¼ºÇϽøé 2 Æ÷ÀÎÆ®°¡ Áö±ÞµË´Ï´Ù.

       

311 @@  ÀÚµ¿Â÷ ¿¬·á Àý°¨ÇÒ¼ö ÀÖ´Â ¹æ¹ý  @@ [1] ½º½Ã¿Õ 01/28 22574 09/06(12:25)
310 È¿°úÀûÀÎ ±â¾ï¹ý [1] ±è¿ëÈ£ 01/27 21719 08/31(16:37)
309 ¹ß¹Ù´Ú ±»Àº»ì Á¦°Å¿Í ¿øÀÎ ±è¿ëÈ£ 01/27 27147
308 ¢Æ Äàµî ÇÇÁö.¸ð°ø ÁÙÀÌ´Â 7°¡Áö ³ëÇÏ¿ì ¢Æ [1] ±è¿ëÈ£ 01/27 21089 08/31(16:37)
307 °áÈ¥ ÀÚ±Ý ¸¶·Ã ±è¿ëÈ£ 01/27 18410
306 Áß°íÂ÷ »óÅ Á¡°Ë¿ä·É ¹× üũ»çÇ× ±è¿ëÈ£ 01/27 15854
305 ¸Þ¸ð¸® ´ýÇÁ ¿À·ù ±è¿ëÈ£ 01/27 15963
304 ÀÚµ¿Â÷ º¸Çè º¸»óÀÇ ³ëÇÏ¿ì ±è¿ëÈ£ 01/27 14713
>> [Á¦·Îº¸µå4] mysql 4.0 ÀÌÇÏ¿¡¼­ 4.1 ÀÌ»óÀ¸·Î ¼­... 09/18 18880
302 ½ÉÇÃÇÏ°í °£´ÜÇÑ °¡°èºÎ [1] ¹öµåÀÌÅÍ 05/08 19202 09/23(19:33)
301 Ŭ·´¹Ú½º °Ë»ö±â ¹öµåÀÌÅÍ 01/06 19270
300 µ¶µµ ¹è³Ê ¾Öµå¿Â - ¼öÁ¤(z-index Ãß°¡) v¿­Ç÷³²¾Æ 08/18 20735
299 DB¾È¿¡ ƯÁ¤ ´Ü¾î¸¦ Çѹø¿¡ º¯°æÇϱâ [1] 07/16 22772 07/16(20:46)
298 Á¦·Îº¸µå 4 - ¿øº»±ÛÀÌ ÀÏÁÖÀÏ À̳»ÀÎ °æ¿ì¿¡¸¸ ... [2] 07/15 20248 07/16(21:42)
297 ÀÎÅͳݿ¡¼­ ·Î±×ÀÎÀÌ ¾ÈµÉ¶§ [1] ÆÄÀ̾î¸ðµå 07/14 21698 07/14(20:48)
123456711LAST