¹«½¼ ¶æÀÎÁö ÆľÇÀ» ¸øÇØ ¸®µðÆø½º ´åÄÄÀÇ ¼Ò½º¸¦ ±×´ë·Î ¿Å±é´Ï´Ù.
// ¿øº»±ÛÀÇ ÀÛ¼ºÀÚ°¡ ȸ¿øÀÏ °æ¿ì(ÄÚ¸àÆ® ÀÛ¼ºÀÚ°¡ ¿øº»±ÛÀÇ ÀÛ¼ºÀÚ¿Í ´Ù¸¦ °æ¿ì¸¸) ¿øº»±ÛÀÇ ÀÛ¼ºÀÚ¿¡°Ô ÂÊÁö ³¯·ÁÁÖ±â
$check = mysql_fetch_array(mysql_query("select ismember from $t_board"."_$id where no = '$no'", $connect));
$subject = mysql_fetch_array(mysql_query("select subject from $t_board"."_$id where no = '$no'", $connect));
$subject = $subject[0];
if($check[0]>0 && $check[0]!=$member[no]) {
$memo_new="<font color=orange><b>".$subject."</b></font><br><font color=orange>".$name."</font> ´ÔÀÌ ÄÚ¸àÆ®¸¦ ³²±â¼Ì½À´Ï´Ù. <br><br>".
$memo."<a target=_top href=\"$view_file_link?id=$id&page=$page&page_num=$page_num&select_arrange=$select_arrange&desc=$des&sn=$sn&ss=$ss&sc=$sc&keyword=$keyword&no=$no&category=$category\"><br><br><b><u>°Ô½Ã¹°·Î ¹Ù·Î°¡±â</u></b></a>";
mysql_query("insert into $get_memo_table (member_no,member_from,subject,memo,readed,reg_date) values ('$check[0]','1','¾²½Å ±Û¿¡ ÄÚ¸àÆ®°¡ ´Þ·È½À´Ï´Ù','$memo_new',1,'$reg_date')") or error(mysql_error());
mysql_query("insert into $send_memo_table (member_to,member_no,subject,memo,readed,reg_date) values ('$check[0]','1','¾²½Å ±Û¿¡ ÄÚ¸àÆ®°¡ ´Þ·È½À´Ï´Ù','$memo_new',1,'$reg_date')") or error(mysql_error());
mysql_query("update $member_table set new_memo=1 where no='$check[0]'") or error(mysql_error());
}
//****************************************************************
// ÄÚ¸àÆ® ´Ü »ç¶÷µé Á¤º¸ ¾ò¾î¿Í¼ ÂÊÁö µ¹¸®±â
//****************************************************************
$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());
}
}
}
|