¾È³çÇϼ¼¿ä~
Á¦·Îº¸µå¿¡¼ ÇÑÂüÀ» Çì¸Å°í, È¥ÀÚ ³©³©°Å¸®´Ù°¡ µµ¹«Áö ÀÌÀ¯¸¦ ¾Ë ¼ö°¡ ¾ú¾î¼ Áú¹®À» µå¸³´Ï´Ù.
ÀÚµ¿·Î±×ÀÎ »óÅ¿¡¼ ½Ç½Ã°£À¸·Î Æ÷ÀÎÅÍ º¯µ¿¿¡ µû¶ó ·¹º§µµ °°ÀÌ º¯µ¿µÇ°Ô ¼öÁ¤ÇÏ°í ½Í¾î¿ä.
Á¦°¡ Á¦·Î¿¡¼ °Ë»öÇÑ ¼Ò½º¸¦ ¾Æ·¡¿Í °°ÀÌ Á¤¸®Çؼ phpÆÄÀÏÀ» °¢°¢ ¼öÁ¤Çߴµ¥,
¿©ÀüÈ÷ ·Î±äÇÒ ¶§ ·¹º§ÀÌ ¹Ù²î°í, ·Î±ä µÈ »óÅ¿¡¼´Â ¾Æ¹«·± º¯È°¡ ¾ø³×¿ä~
Á¦°¡ »ç¿ëÇß´ø ¼Ò½º ¿Ã¸±Å×´Ï È®ÀÎ Á» ºÎŹµå¸³´Ï´Ù.
******* 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);
¸¦ ã¾Æ¼ ¹Ù·Î ¾Æ·¡¿¡ ´ÙÀ½ ³»¿ëÀ» Ãß°¡ÇÕ´Ï´Ù.
// ÀÚµ¿ ·¹º§ ¼³Á¤
$s_point1 = $member_data["point1"]*10;
$s_point2 = $member_data["point2"];
$s_point = $s_point1 + $s_point2;
$s_level = $member_data["level"];
if($s_point < 0) {@mysql_query("update $member_table set point1='0' where no='$member_data[no]'",$connect) or error(mysql_error());}
if($s_point < 0) {@mysql_query("update $member_table set point2='0' where no='$member_data[no]'",$connect) or error(mysql_error());
$s_point = 0;} // Æ÷ÀÎÆ®°¡ 0º¸´Ù ³·¾ÆÁø °æ¿ì 0À¸·Î ´ëü
if($s_level >= 0 and $s_level <= 3); // ·¹º§ 4~10±îÁö ÇØ´ç
elseif($s_point <= 30) //
{@mysql_query("update $member_table set level='9' where user_id='$user_id'",$connect) or error(mysql_error());}
elseif($s_point <= 400) //
{@mysql_query("update $member_table set level='8' where user_id='$user_id'",$connect) or error(mysql_error());}
elseif($s_point >= 401) //
{@mysql_query("update $member_table set level='7' where user_id='$user_id'",$connect) or error(mysql_error());}
------------------------------------------------------------------------------
************ write_ok.php *****************************************************
// ȸ¿øÀÏ °æ¿ì ÇØ´ç ÇØ¿øÀÇ Á¡¼ö ÁÖ±â
if($mode=="write"||$mode=="reply") @mysql_query("update $member_table set point1=point1+1 where no='$member[no]'",$connect) or error(mysql_error());
À» Áö¿ì°í ´ÙÀ½ÀÇ ³»¿ëÀ¸·Î ´ëüÇÕ´Ï´Ù.
// ȸ¿øÀÏ °æ¿ì ÇØ´ç ÇØ¿øÀÇ Á¡¼ö ÁÖ±â
if($mode=="write"||$mode=="reply") {@mysql_query("update $member_table set point1=point1+1 where no='$member[no]'",$connect) or error(mysql_error());
$loginnot=0;} else {$loginnot=1;}
// ÀÚµ¿ ·¹º§ ¼³Á¤
$result = mysql_query("select * from $member_table where no='$member[no]'",$connect) or error(mysql_error());
$member_p = mysql_fetch_array($result);
$s_point1 = $member_data["point1"]*10;
$s_point2 = $member_data["point2"];
$s_point = $s_point1 + $s_point2;
$s_level = $member_data["level"];
$s_id = $member_p[user_id];
if($loginnot == 1) {$s_id="admin";} //·Î±×ÀÎ ¾ÈÇßÀ» °æ¿ìÀÇ Á¡¼ö¿Ã¸®±â ½ÇÆп¡·¯ ¹æÁö
if($s_level >= 0 and $s_level <= 3); // ·¹º§ 4~10±îÁö ÇØ´ç
elseif($s_point <= 30) //
{@mysql_query("update $member_table set level='9' where user_id='$user_id'",$connect) or error(mysql_error());}
elseif($s_point <= 400) //
{@mysql_query("update $member_table set level='8' where user_id='$user_id'",$connect) or error(mysql_error());}
elseif($s_point >= 401) //
{@mysql_query("update $member_table set level='7' where user_id='$user_id'",$connect) or error(mysql_error());}
------------------------------------------------------------------------------
******************** comment_ok.php ****************************************
// ȸ¿øµî·ÏÀÌ µÇ¾î ÀÖÀ»¶§ À̸§µîÀ» °¡Á®¿È;;
if($member[no]) {
if($mode=="modify"&&$member[no]!=$s_data[ismember]) {
$name=$s_data[name];
} else {
$name=$member[name];
}
}
¸¦ Áö¿ì°í ´ÙÀ½ ³»¿ëÀ¸·Î ´ëüÇÕ´Ï´Ù.
// ȸ¿øµî·ÏÀÌ µÇ¾î ÀÖÀ»¶§ À̸§µîÀ» °¡Á®¿È;;
if($member[no]) {$loginnot=0;
if($mode=="modify"&&$member[no]!=$s_data[ismember]) {
$name=$s_data[name];
} else {
$name=$member[name];
}
} else {$loginnot=1;}
ÇÑ °÷À» ´õ ¼öÁ¤ÇØ¾ß ÇÕ´Ï´Ù. ¾Æ·¡·Î À̵¿ÇÏ¿©
// ȸ¿øÀÏ °æ¿ì ÇØ´ç ÇØ¿øÀÇ Á¡¼ö ÁÖ±â
@mysql_query("update $member_table set point2=point2+1 where no='$member[no]'",$connect) or error(mysql_error());
ÀÇ ¹Ù·Î ¾Æ·¡¿¡ ´ÙÀ½ÀÇ ³»¿ëÀ» Ãß°¡ÇÕ´Ï´Ù.
// ÀÚµ¿ ·¹º§ ¼³Á¤
$result = mysql_query("select * from $member_table where no='$member[no]'",$connect) or error(mysql_error());
$member_p = mysql_fetch_array($result);
$s_point1 = $member_data["point1"]*10;
$s_point2 = $member_data["point2"];
$s_point = $s_point1 + $s_point2;
$s_level = $member_data["level"];
$s_id = $member_p[user_id];
if($loginnot == 1) {$s_id="admin";} //·Î±×ÀÎ ¾ÈÇßÀ» °æ¿ìÀÇ Á¡¼ö¿Ã¸®±â ½ÇÆп¡·¯ ¹æÁö
if($s_level >= 0 and $s_level <= 3); // ·¹º§ 4~10±îÁö ÇØ´ç
elseif($s_point <= 30) //
{@mysql_query("update $member_table set level='9' where user_id='$user_id'",$connect) or error(mysql_error());}
elseif($s_point <= 400) //Àû¿ë
{@mysql_query("update $member_table set level='8' where user_id='$user_id'",$connect) or error(mysql_error());}
elseif($s_point >= 401) //
{@mysql_query("update $member_table set level='7' where user_id='$user_id'",$connect) or error(mysql_error());}
------------------------------------------------------------------------------
*************************** delete_ok.php *************************************
// ȸ¿øÀÏ °æ¿ì ÇØ´ç ÇØ¿øÀÇ Á¡¼ö ÁÖ±â
if($member[no]==$s_data[ismember]) @mysql_query("update $member_table set point1=point1-1 where no='$member[no]'",$connect) or error(mysql_error());
}
¸¦ ã¾Æ¼ ´ÙÀ½°ú °°ÀÌ ³»¿ëÀ» ¹Ù²ß´Ï´Ù.
// ȸ¿øÀÏ °æ¿ì ÇØ´ç ÇØ¿øÀÇ Á¡¼ö ÁÖ±â
mysql_query("update $member_table set point1=point1-1 where no='$s_data[ismember]'",$connect);
}
// ÀÚµ¿ ·¹º§ ¼³Á¤
$result = mysql_query("select * from $member_table where no='$s_data[ismember]'",$connect) or error(mysql_error());
$member_p = mysql_fetch_array($result);
$s_point1 = $member_data["point1"]*10;
$s_point2 = $member_data["point2"];
$s_point = $s_point1 + $s_point2;
$s_level = $member_data["level"];
$s_id = $member_p[user_id];
if($s_point < 0) {@mysql_query("update $member_table set point1='0' where no='$s_data[ismember]'",$connect) or error(mysql_error());}
if($s_point < 0) {@mysql_query("update $member_table set point2='0' where no='$s_data[ismember]'",$connect) or error(mysql_error());
$s_point = 0;} // Æ÷ÀÎÆ®°¡ 0º¸´Ù ³·¾ÆÁø °æ¿ì 0À¸·Î ´ëü
if($s_level >= 0 and $s_level <= 3); // ·¹º§ 4~10±îÁö ÇØ´ç
elseif($s_point <= 30)
{@mysql_query("update $member_table set level='9' where user_id='$user_id'",$connect) or error(mysql_error());}
elseif($s_point <= 400)
{@mysql_query("update $member_table set level='8' where user_id='$user_id'",$connect) or error(mysql_error());}
elseif($s_point >= 401)
{@mysql_query("update $member_table set level='7' where user_id='$user_id'",$connect) or error(mysql_error());}
********************** del_comment_ok.php*****************************
// ȸ¿øÀÏ °æ¿ì ÇØ´ç ÇØ¿øÀÇ Á¡¼ö ÁÖ±â
if($member[no]==$s_data[ismember]) @mysql_query("update $member_table set point2=point2-1 where no='$member[no]'",$connect) or error(mysql_error());
¸¦ ã¾Æ¼ ´ÙÀ½°ú °°ÀÌ ³»¿ëÀ» ¹Ù²ß´Ï´Ù.
// ȸ¿øÀÏ °æ¿ì ÇØ´ç ÇØ¿øÀÇ Á¡¼ö ÁÖ±â
mysql_query("update $member_table set point2=point2-1 where no='$s_data[ismember]'",$connect) or error(mysql_error());
// ÀÚµ¿ ·¹º§ ¼³Á¤
$result = mysql_query("select * from $member_table where no='$s_data[ismember]'",$connect) or error(mysql_error());
$member_p = mysql_fetch_array($result);
$s_point1 = $member_data["point1"]*10;
$s_point2 = $member_data["point2"];
$s_point = $s_point1 + $s_point2;
$s_level = $member_data["level"];
$s_id = $member_p[user_id];
if($s_point < 0) {@mysql_query("update $member_table set point1='0' where no='$s_data[ismember]'",$connect) or error(mysql_error());}
if($s_point < 0) {@mysql_query("update $member_table set point2='0' where no='$s_data[ismember]'",$connect) or error(mysql_error());
$s_point = 0;} // Æ÷ÀÎÆ®°¡ 0º¸´Ù ³·¾ÆÁø °æ¿ì 0À¸·Î ´ëü
if($s_level >= 0 and $s_level <= 3); // ·¹º§ 4~10±îÁö ÇØ´ç
elseif($s_point <= 30)
{@mysql_query("update $member_table set level='9' where user_id='$user_id'",$connect) or error(mysql_error());}
elseif($s_point <= 400)
{@mysql_query("update $member_table set level='8' where user_id='$user_id'",$connect) or error(mysql_error());}
elseif($s_point >= 401)
{@mysql_query("update $member_table set level='7' where user_id='$user_id'",$connect) or error(mysql_error());}
------------------------------------------------------------------------------
|