Powered by Á¶ÇÑ½Ä in Nzeo (ȨÆäÀÌÁö :
http://www.darkhead.net/)
member_join_ok.php ÆÄÀÏ¿¡¼
mysql_query("insert into $member_table (level,group_no,user_id,password,name,email,homepage,icq,year,msn,jumin,comment,job,hobby,home_address,home_tel,office_address,office_tel,handphone,mailing,birth,reg_date,openinfo,open_email,open_homepage,open_icq,open_msn,open_comment,open_job,open_hobby,open_home_address,open_home_tel,open_office_address,open_office_tel,open_handphone,open_birth,open_picture,picture,open_aol) values ('$group_data[join_level]','$group_data[no]','$user_id',password('$password'),'$name','$email','$homepage','$icq','$year','$msn',password('$jumin'),'$comment','$job','$hobby','$home_address','$home_tel','$office_address','$office_tel','$handphone','$mailing','$birth','$reg_date','$openinfo','$open_email','$open_homepage','$open_icq','$open_msn','$open_comment','$open_job','$open_hobby','$open_home_address','$open_home_tel','$open_office_address','$open_office_tel','$open_handphone','$open_birth','$open_picture','$picture_name','$open_aol')") or error("ȸ¿ø µ¥ÀÌŸ ÀԷ½à ¿¡·¯°¡ ¹ß»ýÇß½À´Ï´Ù<br>".mysql_error());
mysql_query("update $group_table set member_num=member_num+1 where no='$group_data[no]'");
¶ó´Â ±¸¹®À» ã¾Æ, ±× ´ÙÀ½ Çà¿¡ ´ÙÀ½À» »ðÀÔÇÑ´Ù.
// ȸ¿ø °¡ÀÔ »ç½ÇÀ» °ü¸®ÀÚ¿¡°Ô ¾Ë¸²
$masters=mysql_query("select * from $member_table where is_admin=1||(is_admin=2&&group_no=$group_data[no])",$connect);
$masters_num=mysql_affected_rows();
for($i=0;$i<$masters_num;$i++){
mysql_data_seek($masters,$i);
$master_info=mysql_fetch_array($masters);
$memo=$name."(".$user_id.") ´Ô²²¼ ".$group_data[name]."±×·ì¿¡ »õ·Î °¡ÀÔÇß½À´Ï´Ù.";
mysql_query("insert into $get_memo_table (member_no,member_from,subject,memo,readed,reg_date) values ($master_info[no],1,'ȸ¿ø°¡ÀÔ ¾È³»','$memo',1,'$reg_date')") or error(mysql_error());
mysql_query("update $member_table set new_memo=1 where no=$master_info[no]") or error(mysql_error());
}