zerotb.php 110ÇàÂë º¸¸é
// ÄÚ¸àÆ® ÀÔ·Â
mysql_query("insert into zetyx_board_comment_".$bbs_id." (parent,ismember,name,password,memo,reg_date,ip) values ('$parent','0','$name','$password','$memo','$reg_date','$REMOTE_ADDR')")
or ($result = array("error" => 1, "message" => "Server DB Error."));
¶ó´Â ºÎºÐÀÌ Àִµ¥ ±× ¹Ù·Î ¹Ø¿¡ ´ÙÀ½À» ³©±Å³ÖÀ¸¸é µÈ´Ù.
// ¿øº»±Û ÀÛ¼ºÀÚ¿¡°Ô ¾Ë¸² ¸Þ¼¼Áö º¸³»±â
$tfatherwho = mysql_fetch_array(mysql_query("select ismember from zetyx_board_".$bbs_id." where no = '".$parent."'")); //¿øº»±Û ÀÛ¼ºÀÚ ºÒ·¯¿È
$tfathertitle = mysql_fetch_array(mysql_query("select subject from zetyx_board_".$bbs_id." where no = '".$parent."'")); //¿øº»±Û Á¦¸ñ ºÒ·¯¿È
$tfathertitle = $tfathertitle[0];
if($tfatherwho[0]>0 && $tfatherwho[0]!=$member[no]) { //¿øº»±Û ÀÛ¼ºÀÚ°¡ ȸ¿øÀÌ°í ´ä±Û ÀÛ¼ºÀÚ¿Í µ¿ÀÏÀÎÀÌ ¾Æ´Ï¶ó¸é ¾Æ·¡¿Í °°ÀÌ ¸Þ¼¼Áö¸¦ º¸³½´Ù.
$tsendmemo="<font color=orange><b>".$tfathertitle."</b></font><br>À§ °Ô½Ã¹°¿¡ Æ®·¢¹éÀÌ ³²°ÜÁ³½À´Ï´Ù. <br><br><a target=_top href=\"view.php?id=".$bbs_id."&no=".$parent."\"><br><br><b><u>°Ô½Ã¹°·Î ¹Ù·Î°¡±â</u></b></a>";
mysql_query("insert into zetyx_get_memo (member_no,member_from,subject,memo,readed,reg_date) values ('$tfatherwho[0]','1','Æ®·¢¹é º¸°íÀÔ´Ï´Ù','$tsendmemo',1,'$reg_date')") or error(mysql_error());
mysql_query("insert into zetyx_send_memo (member_to,member_no,subject,memo,readed,reg_date) values ('$tfatherwho[0]','1','Æ®·¢¹é º¸°íÀÔ´Ï´Ù','$tsendmemo',1,'$reg_date')") or error(mysql_error());
mysql_query("update zetyx_member_table set new_memo=1 where no='$tfatherwho[0]'") or error(mysql_error());
}
|