// ÀÌÀü ÄÚ¸à ´Ü »ç¶÷¿¡°Ô ÂÊÁö·Î ÄÚ¸à ¾Ë¸²//
$query = "select distinct(ismember),name from $t_comment"."_$id where parent='$no'"; // ÄÚ¸àÆ® ´Ü »ç¶÷ À̸§°ú ¹øÈ£¸¦ Áߺ¹ ¾ÈµÇ°Ô
$res = mysql_query($query, $connect); // ÇÑ »ç¶÷ÀÌ ¿©·¯°³¸¦ ´Þ¾Æµµ Çѹø¸¸ Äõ¸®µÊ. distinct...
while ($c_data = mysql_fetch_array($res)) {
if ($c_data[ismember] > 0 && $c_data[ismember] != $s_data[ismember]) { // ÄÚ¸àÆ® ¾´ »ç¶÷ÀÌ ¸â¹ö && ÄÚ¸àÆ® ÀÛ¼ºÀÚ != ¿øº» ÀÛ¼ºÀÚ
if ($member[no] != $c_data[ismember]) {
$reply_message="ȸ¿ø´ÔÀÌ ÄÚ¸àÆ® ³²±â¼Ì´ø ±Û,<br><font color=orange><b>".$s_data[subject]."</b></font> <font class=wizz_g>(".$s_data[name].")</font> ¿¡<br><font color=orange>".$name."</font> ´Ô ´ÙÀ½ÀÇ ÄÚ¸àÆ®¸¦ ³²°å½À´Ï´Ù.<br><br>".$memo."<br><br><a target=_top href=\"view.php?id=$id&page=$page&no=$no\"><br><br><b><u>°Ô½Ã¹°·Î ¹Ù·Î°¡±â</u></b></a>";
$query = "insert into $get_memo_table (member_no, member_from, subject, memo, readed, reg_date) values ('$c_data[ismember]', 1, '´Ù¸¥ ºÐµµ ÄÚ¸àÆ®¸¦ ´Þ¾Ò½À´Ï´Ù', '$reply_message', 1, '$reg_date')";
mysql_query($query, $connect) or error(mysql_error());
$query = "insert into $send_memo_table (member_to, member_no, subject, memo, readed, reg_date) values ('$c_data[ismember]', 1, '´Ù¸¥ ºÐµµ ÄÚ¸àÆ®¸¦ ´Þ¾Ò½À´Ï´Ù', '$reply_message', 1, '$reg_date')";
mysql_query($query, $connect) or error(mysql_error());
$query = "update $member_table set new_memo=1 where no=$c_data[ismember]";
mysql_query($query, $connect) or error(mysql_error());
}
}
}
À§¿Í °°Àº ¹Ù·Î°¡±â¸¦ ½è´Âµ¥¿ä^^;
(±×·¯´Ï±ñ ÄÚ¸àÆ® ´Þ¸é ¾Ë¸² ±â´É »ç¿ëÇß¾î¿ä)
°Ô½Ã¹° ¸ñ·ÏÀº ¾Èº¸À̴µ¥; ¾î¶»°Ô ¼öÁ¤ÇÏ¸é µÇ´ÂÁö;
¸®µðÆø½º´åÄÄ¿£ ¸ñ·ÏÀÌ º¸À̴µ¥;
¸®¾óÆ÷Åä¿¡µµ ±×¸® Çߴµ¥; ¸ñ·ÏÀº ¾Èº¸À̳׿ä^^;
¹Ù·Î°¡±â ÇÏ´Ï^^;
Á» ¾Ë·ÁÁÖ½Ç ¼ö ÀÖÀ»·±Áö+_+;
|