QnA ¹¯°í ´äÇϱâ
		Áú¹®Àü °Ë»öÀº ±âº»!!! Áú¹® ³»¿ëÀº ÃÖ´ëÇÑ ÀÚ¼¼ÇÏ°í Á¤È®ÇÏ°Ô!!!!!

Login

ÂÊÁöÇÔ¿¡¼­ À̸ðƼÄÜÀ» º¼·Á¸é     seisu  posted at 2004-01-09 19:09:19 6735 hits  1 comments  http://weclub.byus.net NeWin seisu is level 1  llllllllll

ÆÛ¸Ó¸µÅ© : http://reedyfox.com/island.php/qna/303  [º¹»ç] http://reedyfox.com/island.php/qna/303

<? // ¶óÀ̺귯¸® ÇÔ¼ö ÆÄÀÏ ÀÎÅ©·çµå         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(); ?> ÀÌ·¸°Ô ÇÏ¸é ³ª¿Ã±î¿ä ?

Playstation 2 Socom II online Clan :: Black Wing's mobile P. 018-212-4858

PRINT Text  PRINT HTML

Trackbacks for this Posting (0)

¸®µð  posted at 2004-01-09 20:27      reedyfox is level 38  llllllllll    º»¹®Àº ÀоÁö ¾Ê¾Ò½À´Ï´Ù. ¾Æ¸¶ ¾Æ·¡ ¸µÅ©´ë·Î ÇÏ½Ã¸é µÉ°Å¿¹¿ä. :) http://reedyfox.com/bbs/zboard.php?id=qna&page=2&sn1=&divpage=1&sn=off&ss=on&sc=on&keyword=À̸ðƼÄÜ&select_arrange=headnum&desc=asc&no=169 [»õâ¿¡¼­ ¿­±â]