<?
// ¶óÀ̺귯¸® ÇÔ¼ö ÆÄÀÏ ÀÎÅ©·çµå
include "lib.php";
// DB ¿¬°á
if(!$connect) $connect=dbConn();
// ¸â¹öÁ¤º¸ ±¸Çϱâ
$member=member_info();
if(!$member[no]) Error("·Î±×ÀÎµÈ È¸¿ø¸¸ÀÌ »ç¿ëÇÒ¼ö ÀÖ½À´Ï´Ù","window.close");
// ±×·ìµ¥ÀÌŸ Àоî¿À±â;;
$group_data=mysql_fetch_array(mysql_query("select * from $group_table where no='$member[group_no]'"));
// »õÂÊÁö ¿Ô½À´Ï´Ù;; ¾Ë¶÷ ¾ø¾Ö±â
mysql_query("update $member_table set new_memo='0' where no='$member[no]'");
// ÀÏÁÖÀÏ ³ÑÀº ±Û »èÁ¦;;
mysql_query("delete from $get_memo_table where (".time()." - reg_date) >= ".$_zbDefaultSetup[memo_limit_time]) or error(mysql_error());
// ¼±ÅÃµÈ ¸Þ¸ð »èÁ¦;;;
if($exec=="del_all") {
for($i=0;$i<count($del);$i++) {
mysql_query("delete from $get_memo_table where no='$del[$i]'");
}
mysql_close($connect);
movepage("$PHP_SELF?page=$page");
}
// ¸Þ¸ð»èÁ¦
if($exec=="del") {
mysql_query("delete from $get_memo_table where no='$no' and member_no='$member[no]'");
mysql_close($connect);
movepage("$PHP_SELF?page=$page");
}
// ¼±ÅÃµÈ ¸Þ¸ð°¡ ÀÖÀ»½Ã µ¥ÀÌŸ »Ì¾Æ¿À±â;;
if($no) {
$now_data=mysql_fetch_array(mysql_query("select a.subject as subject, a.reg_date as reg_date, a.readed as readed, b.name as name, a.member_from as member_from, a.memo as memo from
$get_memo_table a, $member_table b where a.member_from=b.no and a.no='$no' and a.member_no='$member[no]'"));
if($now_data[readed]==1) {
mysql_query("update $get_memo_table set readed='0' where no='$no' and member_no='$member[no]'");
$check=mysql_fetch_array(mysql_query("select count(*) from $get_memo_table where readed='1' and member_no='$member[no]'"));
mysql_query("update $send_memo_table set readed='0' where reg_date='$now_data[reg_date]' and member_to='$member[no]'");
if(!$check[0]) mysql_query("update $member_table set new_memo='0' where no='$member[no]'");
}
}
// ÀÐÁö ¾ÊÀº ÂÊÁöÀÇ °¹¼ö ±¸Çϱâ
$temp1=mysql_fetch_array(mysql_query("select count(*) from $get_memo_table where readed='1' and member_no='$member[no]'"));
$new_total=$temp1[0];
// Àüü ÂÊÁöÀÇ °¹¼ö
$temp2=mysql_fetch_array(mysql_query("select count(*) from $get_memo_table where member_no='$member[no]'"));
$total=$temp2[0];
// ÆäÀÌÁö °è»ê
if(!$page) $page=1;
$page_num=5;
$start_num=($page-1)*$page_num; // ÆäÀÌÁö ¼ö¿¡ µû¸¥ Ãâ·Â½Ã ù¹ø°°¡ µÉ ±ÛÀÇ ¹øÈ£ ±¸ÇÔ
$total_page=(int)(($total-1)/$page_num)+1; // Àüü ÆäÀÌÁö ±¸ÇÔ
if($page>$total_page) $page=$total_page; // ÆäÀÌÁö°¡ Àüü ÆäÀÌÁöº¸´Ù Å©¸é ÆäÀÌÁö ¹øÈ£ ¹Ù²Þ
// µ¥ÀÌŸ »Ì¾Æ¿À´Â ºÎºÐ...
$que="select a.no as no, a.subject as subject, a.reg_date as reg_date, a.readed as readed, b.name as name, a.member_from as member_from from $get_memo_table a ,$member_table b where a.member_no='$member[no]' and a.member_from=b.no order by a.no desc limit $start_num,$page_num";
$result=mysql_query($que) or Error(mysql_error());
// MySQL ´Ý±â
if($connect) mysql_close($connect);
$query_time=getmicrotime();
// ÆäÀÌÁö °è»ê $print_page ¶ó´Â º¯¼ö¿¡ ÀúÀå
$print_page="";
$show_page_num=7;
$start_page=(int)(($page-1)/$show_page_num)*$show_page_num;
$i=1;
if($page>$show_page_num) {
$prev_page=$start_page;
$print_page="<a href=$PHP_SELF?id=$id&page=$prev_page&select_arrange=$select_arrange&desc=$desc&category=$category&sn=$sn&ss=$ss&sc=$sc&keyword=$keyword&page_num=$page_num>[Prev]</a> ";
$print_page.="<a href=$PHP_SELF?id=$id&page=1&select_arrange=$select_arrange&desc=$desc&category=$category&sn=$sn&ss=$ss&sc=$sc&keyword=$keyword&page_num=$page_num>1</a>..";
}
while($i+$start_page<=$total_page&&$i<=$show_page_num) {
$move_page=$i+$start_page;
if($page==$move_page) $print_page.=" <b>$move_page</b> ";
else $print_page.="<a href=$PHP_SELF?id=$id&page=$move_page&select_arrange=$select_arrange&desc=$desc&category=$category&sn=$sn&ss=$ss&sc=$sc&keyword=$keyword&page_num=$page_num>[$move_page]</a>";
$i++;
}
if($total_page>$move_page) {
$next_page=$move_page+1;
$print_page.="..<a href=$PHP_SELF?id=$id&page=$total_page&select_arrange=$select_arrange&desc=$desc&category=$category&sn=$sn&ss=$ss&sc=$sc&keyword=$keyword&page_num=$page_num>[$total_page]</a>";
$print_page.=" <a href=$PHP_SELF?id=$id&page=$next_page&select_arrange=$select_arrange&desc=$desc&category=$category&sn=$sn&ss=$ss&sc=$sc&keyword=$keyword&page_num=$page_num>[Next]</a>";
}
head("bgcolor=white");
?>
<script>
function reverse() {
var i, chked=0;
for(i=0;i<document.list.length;i++)
{
if(document.list[i].type=='checkbox')
{
if(document.list[i].checked) { document.list[i].checked=false; }
else { document.list[i].checked=true; }
}
}
}
</script>
<link rel="stylesheet" type="text/css" href="../img/2fox.css">
<div align=center>
<!-- ¼±ÅÃµÈ ¸Þ¸ð°¡ ÀÖÀ»¶§;; -->
<?
if($now_data[name]) {
$temp_name = get_private_icon($now_data[member_from], "2");
if($temp_name) $now_data[name]="<img src='$temp_name' border=0 align=absmiddle>";
$temp_name = get_private_icon($now_data[member_from], "1");
if($temp_name) $now_data[name]="<img src='$temp_name' border=0 align=absmiddle> ".$now_data[name];
?>
<table align=center height=0 cellSpacing=0 cellPadding=0 width="95%" border=0>
<TR height=5>
<TD></TD></TR>
<TR height=18>
<TD vAlign=top> </TD>
<TD vAlign=bottom align=right width=180>
<A href="../bbs/member_memo.php"><IMG height=16 src="images/list_all.gif" width=49 border=0></A>
<A class=o href="javascript:void(window.open('view_info.php?member_no=<?=$data[member_to]?>','view_info','width=400,height=500,toolbar=no,scrollbars=yes'))"><a href=javascript:void(window.open('view_info.php?member_no=<?=$now_data[member_from]?>','view_info','width=400,height=500,toolbar=no,scrollbars=yes'))><IMG height=16 src="images/reply.gif" width=49 border=0></A>
<A onclick="return confirm('»èÁ¦ÇϽðڽÀ´Ï±î?')" href=<?="$PHP_SELF?exec=view&no=$data[no]&page=$page"?>><IMG height=16 src="images/del_sel.gif" width=49 border=0></A>
</TD>
</TR></TBODY></TABLE>
<table align=center border=0 height=9 cellspacing=0 cellpadding=0 width=95%>
<tr>
<td width=10><img src=images/bot_bg_left.gif border=0></td>
<td width=100% background=images/bot_bg_center.gif></td>
<td width=10><img src=images/bot_bg_right.gif border=0></td>
</tr>
<table align=center cellSpacing=0 cellPadding=3 width="95%" border=0>
<TBODY>
<TR>
<TD colSpan=2> <FONT class=subject><?=stripslashes($now_data[subject])?></FONT> <FONT class=t7_gray><?=date("(Y.m.d. H:i)",$now_data[reg_date])?></FONT></TD></TR>
<TR height=3>
<TD colSpan=2></TD></TR>
<TR>
<TD vAlign=top align=middle width=70><B><A class=o href="javascript:void(window.open('view_info.php?member_no=1','view_info','width=400,height=500,toolbar=no,scrollbars=yes'))"><a href=javascript:void(window.open('view_info.php?member_no=<?=$now_data[member_from]?>','view_info','width=400,height=500,toolbar=no,scrollbars=yes'))><?=stripslashes($now_data[name])?></a></A></B></TD>
<TD style="PADDING-RIGHT: 10px; PADDING-LEFT: 10px; PADDING-BOTTOM: 5px; WORD-BREAK: break-all; PADDING-TOP: 5px" bgColor=#f7f7f7>
<?
// À̸ðƼÄÜ º¯È¯ ºÎºÐÀÔ´Ï´Ù. (À̸ðƼÄÜ ¾È¾²´Â ºÐÀº »èÁ¦)
include "../bbs/include/emo_v.php";
?>
<?
//°ü¸®ÀÚ°¡ º¸³½ ÂÊÁö¸é html Àû¿ë
if($now_data[member_from]=="1") {
echo autolink(nl2br(stripslashes($now_data[memo])))."<br>";
} else {
echo autolink(nl2br(stripslashes(del_html($now_data[memo]))))."<br>";
}
?>
</TD></TR>
<TR height=15>
<TD colSpan=2></TD></TR>
<TR height=1>
<TD background=images/list_line.gif colSpan=2></TD></TR>
<TR height=15>
<TD colSpan=2></TD></TR></TBODY></TABLE></TD></FORM></TR></TBODY></TABLE>
<?
}
?>
<table align=center border=0 width=95% cellpadding=0 cellspacing=0>
<tr>
<form method=post name=list action=<?=$PHP_SELF?> onsubmit="return confirm('»èÁ¦ÇϽðڽÀ´Ï±î?')">
<input type=hidden name=exec value=del_all>
<input type=hidden name=page value=<?=$page?>>
<td>
<table align=center width="100%" border="0" cellspacing="0" cellpadding="0">
<tr height=5>
<td></td></tr>
<tr height=18>
<td valign=top><font class=c_blog_v7b>Received ::</font><font style=font-family:Tahoma;font-size:7pt;color:#cc0000> <b><?=$print_page?></b> </font></td>
<td width=110 align="right" valign=bottom><a class=g href="javascript:reverse()"><img src="images/pick_all.gif" width=49 height=16 border=0></a> <input type=image src="images/del_sel.gif" width=49 height=16 border=0></td>
</tr>
<table align=center align=center width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width=10><img src=images/bot_bg_left.gif border=0></td>
<td width=100% background=images/bot_bg_center.gif></td>
<td width=10><img src=images/bot_bg_right.gif border=0></td>
</tr>
</table>
<?
// Ãâ·Â
$loop_number=$total-($page-1)*$page_num;
while($data=mysql_fetch_array($result)) {
$data[name]=stripslashes($data[name]);
$temp_name = get_private_icon($data[member_from], "2");
if($temp_name) $data[name]="<img src='$temp_name' border=0 align=absmiddle>";
$temp_name = get_private_icon($data[member_from], "1");
if($temp_name) $data[name]="<img src='$temp_name' border=0 align=absmiddle> ".$data[name];
$data[subject]=stripslashes($data[subject]);
$reg_date=date("Y/m/d H:i",$data[reg_date]);
if($data[readed]==0) $readed="<img src=images/memo_readed.gif>"; else $readed="<img src=images/memo_unread.gif>"
?>
<tr>
<td colspan="5" bgcolor="#F0F0F0" align="center"><img src="images/t.gif" width="10" height="1"></td>
</tr>
<table align=center width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<table align=center width="95%" border="0" cellspacing="0" cellpadding="0">
<tr onMouseOver=this.style.backgroundColor="#FFF8C8" onMouseOut=this.style.backgroundColor="">
<td width="20" align="center" height="23">
<input type=checkbox name=del[] value=<?=$data[no]?>>
</td>
<td width="20" align="center"><?=$readed?></td>
<td style='word-break:break-all;' style=cursor:hand; onclick=location.href="<?="$PHP_SELF?exec=view&no=$data[no]&page=$page"?>"><img src="images/t.gif" width="10" height="3"><br>
<a href=<?="$PHP_SELF?exec=view&no=$data[no]&page=$page"?>><?=$data[subject]?></a></td>
<td width="80" align="center"><img src="images/t.gif" width="10" height="3"><br>
<a href=javascript:void(window.open('view_info.php?member_no=<?=$data[member_from]?>','view_info','width=400,height=510,toolbar=no,scrollbars=yes'))><?=$data[name]?></a></td>
<td width="60" align="center"><font style=font-family:Tahoma;font-size:8pt;><span title='<?=$reg_date?>'><? echo"".date("m/d",$data[reg_date])."" ?></span></font></td>
</tr>
<?
$loop_number--;
}
?>
<tr>
<td colspan="5" bgcolor="#F0F0F0" align="center"><img src="images/t.gif" width="10" height="1"></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</form>
</tr>
</table>
</div>
<?
foot();
?>
ÀÌ·¸°Ô ÇÏ¸é ³ª¿Ã±î¿ä ?
|