PhpMyAdmin ¿¡¼ zetyx_member_table¿¡¼ Çʵå Ãß°¡¸¦ ÇÑ´Ù.
ÇʵåÀ̸§ pop
Á¾·ù char
±æÀÌ 1
Null
±âº»°ª 0
±âÁ¸ ÂÊÁö ¼Ò½º¸¦ ´ÙÀ½°ú °°ÀÌ ´ëüÇÑ´Ù.
<!--ÂÊÁö ¶ç¿ì±â ½ÃÀÛ-->
<?php
$memopop=mysql_fetch_array(mysql_query("select * from zetyx_member_table where no='$member[no]'"));
$memopop=$memopop[pop];
if($memopop==0) {
$unread=mysql_fetch_array(mysql_query("select count(*) from zetyx_get_memo where readed='1' and member_no='$member[no]'"));
$unreadnum=$unread[0];
if($unreadnum>0) {
echo "<div align=center id='automemo' class=memopop>";
echo "<table width=100% border=0 cellpadding=0 cellspacing=0><tr><td>";
echo "<iframe name=memo id=layerifrm class=memoifr src=../bbs/member_memo.php scrolling=no frameborder=0></iframe></td></tr><tr heigh=1><td background=../_img/list_line.gif></td></tr>";
echo "<tr height=15><td align=right valign=middle><font class=t8b-1_4a4d4a><a class=o href=../bbs/member_memo.php target=memo>Received</a> : <a class=o href=../bbs/member_memo2.php target=memo>Sent</a> : <a href='#' onClick='closememo()'>Window close</a> </font></td></tr>";
echo "</table></div>";
}
} else {
mysql_query("update zetyx_get_memo set readed='0' where member_no='$member[no]'");
}
?>
±×¸®°í on/off ¸¦ ¼±ÅÃÇÒ ¼ö ÀÖ´Â ¸Þ´º¸¦ Ãß°¡ÇÏÀÚ.
<?php
if($member[no]&&$memopop==0) {
echo "Message <u>on</u> <a class=mor_menu href='memo_pop_ok.php?member_no=$member[no]&memo_pop=$memopop'>off</a> ";
} elseif($member[no]) {
echo "Message <a class=mor_menu href='memo_pop_ok.php?member_no=$member[no]&memo_pop=$memopop'>on</a> <u>off</u> ";
}
?>
¸¶Áö¸·À¸·Î memo_pop_ok.php ¸¦ ¸¸µé¾î
<?php
require "../bbs/lib.php";
if(!$connect) $connect=dbConn();
$setup=get_table_attrib($id);
$group=group_info($setup[group_no]);
$member=member_info();
if($member[is_admin]==1||$member[is_admin]==2&&$member[group_no]==$setup[group_no]) $is_admin=1; else $is_admin="";
$avoid_ip=explode(",",$setup[avoid_ip]);
for($i=0;$i<count($avoid_ip);$i++)
{
if(!isblank($avoid_ip[$i])&&eregi($avoid_ip[$i],$REMOTE_ADDR)&&!$is_admin)
Error(" Access Denied ");
}
if($group[is_open]==0&&!$is_admin&&$member[group_no]!=$setup[group_no]) Error("°ø°³ µÇ¾î ÀÖÁö ¾Ê½À´Ï´Ù");
//¸Þ½ÃÁö show/hide ºÎºÐ
if($member_no) {
if($memo_pop==1)
mysql_query("update zetyx_member_table set pop=0 where no='$member_no'");
else
mysql_query("update zetyx_member_table set pop=1 where no='$member_no'");
} else Error("ȸ¿øÀÌ ¾Æ´Ï¸é ¼³Á¤ÀÌ ºÒ°¡´ÉÇÕ´Ï´Ù.");
//////// MySQL ´Ý±â ///////////////////////////////////////////////
if($connect) mysql_close($connect);
$query_time=getmicrotime();
header("location:main.html");
?>
¸¦ Áý¾î ³ÖÀº ÈÄ ÀúÀå.
|