//쪽지수신 me_id 찾기 $row_memo = sql_fetch(" select max(me_id) as max_me_id from {$g4['memo_table']} "); $me_id = $row_memo[max_me_id]; $me_id2 = $row_memo[max_me_id]+1 ; //쪽지답장 if($member[mb_id] && $ww == $member[mb_id]) { $me_memo = $me_memo_reply; $sql2 = " insert into {$g4['memo_table']} ( me_id, me_recv_mb_id, me_send_mb_id, me_send_datetime, me_memo ) values ( '$me_id2', '$recv_mb_id', '$member[mb_id]', '$g4[time_ymdhis]', '$me_memo' ) "; sql_query($sql2); sql_query(" update {$g4['member_table']} set mb_memo_call = '$member[mb_id]' where mb_id = '$recv_mb_id' "); //alert('쪽지를 보냈습니다.', $g4[path].$_SERVER['REQUEST_URI']); } //새쪽지알림 if ($member['mb_memo_call']) { $recv_mb_nick = get_member($member[mb_memo_call], "mb_nick"); $recv_mb_id = get_member($member[mb_memo_call], "mb_id"); //쪽지내용 바로 보여주기 $sql = " select * from {$g4['memo_table']} where me_id = '$me_id' and me_recv_mb_id = '$member[mb_id]' "; $memo = sql_fetch($sql); //쪽지열람 확인 sql_query(" update {$g4['member_table']} set mb_memo_call = '' where mb_id = '$member[mb_id]' "); ?>