2009/09/18 17:01:31     18881     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 Æ÷ÀÎÆ®°¡ Áö±ÞµË´Ï´Ù.

       

293 Á¦·Îº¸µå4.1À» MySQL 5.0 ¹öÁ¯¿¡¼­ ¼³Ä¡Çϱâ [2] 05/26 20113 03/28(11:39)
1 ÆÁ/Å×Å©´Ð [3] 11/01 19699 06/04(01:57)
134 Á¦·Îº¸µå °Ô½ÃÆÇ À̸§ ¹Ù²Ù±â 12/31 19436
301 Ŭ·´¹Ú½º °Ë»ö±â ¹öµåÀÌÅÍ 01/06 19270
302 ½ÉÇÃÇÏ°í °£´ÜÇÑ °¡°èºÎ [1] ¹öµåÀÌÅÍ 05/08 19203 09/23(19:33)
>> [Á¦·Îº¸µå4] mysql 4.0 ÀÌÇÏ¿¡¼­ 4.1 ÀÌ»óÀ¸·Î ¼­... 09/18 18881
228 ȨÇÇ¿¡ ±¸±Û±¤°í ´Þ±â - AdSense ¸·µ¥¹«½Î 10/19 18718
152 Á¦·Îº¸µå °ü¸®ÀÚ Æнº¿öµå ºÐ½Ç½Ã ÇØ°á¹æ¹ý 02/28 18626
264 ¶óÀ̼¾½º ¸¸·áµÈ Æ÷Åä¼¥ ¾¾¸®¾ó ÃʱâÈ­Çϱâ 10/12 18538
307 °áÈ¥ ÀÚ±Ý ¸¶·Ã ±è¿ëÈ£ 01/27 18416
249 ÀÀ´ä¾ø´Â ÇÁ·Î±×·¥ »¡¸®²ô±â ^^ [4] ±è¼º¼ö 02/23 17500 01/20(01:08)
216 IIS¿¡ PHP+MySQL¸¦ ¼³Ä¡ÇÏÀÚ. À£Æ® 06/22 17432
225 [°­Ãß] ȨÆäÀÌÁö ü°¨¼Óµµ Çâ»ó!!! [3] 10/04 17332 04/14(11:57)
4 Ç÷¡½¬ º£³Ê¸¸µé±â [3] 11/12 17322 03/02(15:13)
17 Á¦·Îº¸µå °øÁö»ðÀÔ¹ý=[¾ÆÀÌÄÜ]+³¯Â¥+Á¦¸ñ ÃÖ±Ù°Ô... ½ÅÀçÈÆ 12/13 16698
FIRST123456712LAST