쪽지 많을때 페이지 넘어가게하기... > 그누3 팁자료실

그누3 팁자료실

쪽지 많을때 페이지 넘어가게하기... 정보

그누호환 쪽지 많을때 페이지 넘어가게하기...

본문

mbmemo.php입니다...
//몇개씩 볼건가?의 $rows = '값'을 조정하면 됩니다

<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가

define("_DOCTYPE_", "STYLE");

$cfg[leftmargin] = $cfg[topmargin] = 0;

header_cache();
   
if (!$member[mb_id]) {
    echo "
    <script language='javascript'>
        alert('회원만 이용하실 수 있습니다.');
        window.close();
    </script>";
    exit;
}

// 설정일이 지난 읽은 메모 삭제
$time = date("Y-m-d H:i:s", time() - 86400 * $cfg[mb_memo_del]);
$sql = " delete from  $cfg[table_memo]
          where me_recv_mb_id = '$member[mb_id]'
            and me_read_datetime <> '0000-00-00 00:00:00'
            and me_read_datetime < '$time' ";
sql_query($sql);

if (!$kind) {
    $kind = "recv";
}

if ($kind == 'recv') {
    $unkind = 'send';
} else if ($kind == 'send') {
    $unkind = 'recv';
} else {
    alert("\$kind 값을 넘겨주세요.");
}

$sql = " select count(*) from $cfg[table_memo]
          where me_{$kind}_mb_id = '$member[mb_id]' ";
$row = sql_fetch($sql);
$total_count = number_format($row[0]);
$rows=3;  //몇개씩 볼건가
$total_page  = ceil($total_count / $rows);  // 전체 페이지 계산
if (!$page) { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함

$html_title = "나의 쪽지";

if ($kind == 'recv') {
    $html_title .= " > 받은쪽지함";
} else {
    $html_title .= " > 보낸쪽지함";
}

/*
$sql = " select a.*, b.mb_name from $cfg[table_memo] a
          left outer join $cfg[table_member] b on (a.me_{$unkind}_mb_id = b.mb_id)
          where a.me_{$kind}_mb_id = '$member[mb_id]'
          order by a.me_id desc ";
$result = sql_query($sql);
for ($i=0; $row=mysql_fetch_array($result); $i++) {
    $list[$i][me_id] = $row[me_id];

    if (substr($row[me_read_datetime],0,1) == '0') {
        $list[$i][me_read_datetime] = '아직 읽지 않음';
    } else {
        $list[$i][me_read_datetime] = $row[me_read_datetime];
    }

    $list[$i][mb_id] = $row["me_{$unkind}_mb_id"];
    if ($row[mb_name]) {
        $list[$i][mb_name] = $row[mb_name];
    } else {
        $list[$i][mb_name] = "<font color=silver>정보없음</font>";
    }

    $list[$i][me_send_datetime] = $row[me_send_datetime];
}

include "$memo_skin/mbmemo.skin.php";
*/
?>

<img src='image/title_memo.gif'><br><br>

<table width=99% align=center cellpadding=0 cellspacing=0><tr><td>

<table width=100% cellpadding=0 cellspacing=0>
<tr><td colspan=2></td></tr>
<tr>
<td>
            <?
            if ($kind == 'recv') {
                echo "<img src='image/title_memo_01_on.gif' border=0>";
                echo "<a href='./?doc=bbs/mbmemo.php&kind=send'><img src='image/title_memo_02_off.gif' border=0></a>";
            }
           
            if ($kind == 'send') {
                echo "<a href='./?doc=bbs/mbmemo.php&kind=recv'><img src='image/title_memo_01_off.gif' border=0></a>";
                echo "<img src='image/title_memo_02_on.gif' border=0>";
            } ?></td>
        <td align=right valign=bottom> 전체 받은 쪽지 [ <B><?=$total_count?></B> ]통</td>
  </tr>
</table>

<table width=100% bgcolor=#CCCCCC cellpadding=1 cellspacing=0>
<tr>
    <td>
        <table width=100% cellpadding=0 cellspacing=0>
        <tr>
            <td align=center>
                <table width=100% cellpadding=1 cellspacing=1 border=0>
                <tr height=25 bgcolor=#F3F3F3 align=center>
                    <td><?= ($kind == 'recv') ? "보낸사람" : "받는사람"; ?></td>
                    <td width=120>보낸시간</td>
                    <td width=120>읽은시간 </td>
                    <td width=30>삭제</td>
                </tr>

                <?
                $sql = " select a.*, b.mb_name from $cfg[table_memo] a
                          left outer join $cfg[table_member] b on (a.me_{$unkind}_mb_id = b.mb_id)
                          where a.me_{$kind}_mb_id = '$member[mb_id]'
                          order by a.me_id desc limit $from_record, $rows";
                $result = sql_query($sql);
                for ($i=0; $row=mysql_fetch_array($result); $i++) {
                    $mb_id = $row["me_{$unkind}_mb_id"];

                    if ($row[mb_name])
                        $mb_name = $row[mb_name];
                    else
                        $mb_name = "<font color=silver>정보없음</font>";

                    if (substr($row[me_read_datetime],0,1) == '0')
                        $read_datetime = '아직 읽지 않음';
                    else
                        $read_datetime = $row[me_read_datetime];

                    $href = "./?doc=bbs/mbmemoview.php&me_id=$row[me_id]&kind=$kind";

                    echo "
                    <tr height=25 bgcolor=#FFFFFF align=center>
                        <td><a href='$href'>$mb_id ($mb_name)</a></td>
                        <td><a href='$href'>$row[me_send_datetime]</a></td>
                        <td><a href='$href'>$read_datetime</a></td>
                        <td><a href=\"javascript:if (confirm('삭제하시겠습니까?')) {location='./?doc=bbs/mbmemodelete.php&me_id=$row[me_id]&kind=$kind'}\"><img src='image/btn_memo_del.gif' border=0></a></td>
                    </tr>";

                }

                if ($i == 0) { echo "<tr bgcolor=#FFFFFF><td align=center colspan=4 height=100>자료가 없습니다.</td></tr>"; }
                ?>

                </table>
            </td>
        </tr>
        </table>
    </td>
</tr>
</table>

<table width=100% cellpadding=0 cellspacing=0 border=0>
<tr><td height=30>&nbsp;<a href="./?doc=bbs/mbmemoform.php"><img src='image/btn_send.gif' border=0></a> <a href="javascript:window.close();"><img src='image/btn_close.gif' border=0></a></td></tr>
</table>
<table width=100% cellpadding=0 cellspacing=0 border=0>
<tr><td height=30><?= get_paging(10, $page, $total_page,  "./?doc=bbs/mbmemo.php&page=");?></td></tr>
</table>

</td></tr></table>
추천
0

댓글 전체

두군데 수정본 올라갑니다.

<?
if (!defined("_GNUBOARD_")) exit; // 개별 페이지 접근 불가

define("_DOCTYPE_", "STYLE");

$cfg[leftmargin] = $cfg[topmargin] = 0;

header_cache();
   
if (!$member[mb_id]) {
    echo "
    <script language='javascript'>
        alert('회원만 이용하실 수 있습니다.');
        window.close();
    </script>";
    exit;
}

// 설정일이 지난 읽은 메모 삭제
$time = date("Y-m-d H:i:s", time() - 86400 * $cfg[mb_memo_del]);
$sql = " delete from  $cfg[table_memo]
          where me_recv_mb_id = '$member[mb_id]'
            and me_read_datetime <> '0000-00-00 00:00:00'
            and me_read_datetime < '$time' ";
sql_query($sql);

if (!$kind) {
    $kind = "recv";
}

if ($kind == 'recv') {
    $unkind = 'send';
} else if ($kind == 'send') {
    $unkind = 'recv';
} else {
    alert("\$kind 값을 넘겨주세요.");
}

$sql = " select count(*) from $cfg[table_memo]
          where me_{$kind}_mb_id = '$member[mb_id]' ";
$row = sql_fetch($sql);
$total_count = number_format($row[0]);
$rows=8;  //몇개씩 볼건가
$total_page  = ceil($total_count / $rows);  // 전체 페이지 계산
if (!$page) { $page = 1; } // 페이지가 없으면 첫 페이지 (1 페이지)
$from_record = ($page - 1) * $rows; // 시작 열을 구함

if ($kind == 'recv') {
    $html_title .= " > 받은쪽지함";
    $kind_title = "받은";
} else {
    $html_title .= " > 보낸쪽지함";
    $kind_title = "보낸";
}

/*
$sql = " select a.*, b.mb_name from $cfg[table_memo] a
          left outer join $cfg[table_member] b on (a.me_{$unkind}_mb_id = b.mb_id)
          where a.me_{$kind}_mb_id = '$member[mb_id]'
          order by a.me_id desc ";
$result = sql_query($sql);
for ($i=0; $row=mysql_fetch_array($result); $i++) {
    $list[$i][me_id] = $row[me_id];

    if (substr($row[me_read_datetime],0,1) == '0') {
        $list[$i][me_read_datetime] = '아직 읽지 않음';
    } else {
        $list[$i][me_read_datetime] = $row[me_read_datetime];
    }

    $list[$i][mb_id] = $row["me_{$unkind}_mb_id"];
    if ($row[mb_name]) {
        $list[$i][mb_name] = $row[mb_name];
    } else {
        $list[$i][mb_name] = "<font color=silver>정보없음</font>";
    }

    $list[$i][me_send_datetime] = $row[me_send_datetime];
}

include "$memo_skin/mbmemo.skin.php";
*/
?>

<img src='image/title_memo.gif'><br><br>

<table width=99% align=center cellpadding=0 cellspacing=0><tr><td>

<table width=100% cellpadding=0 cellspacing=0>
<tr><td colspan=2></td></tr>
<tr>
<td>
            <?
            if ($kind == 'recv') {
                echo "<img src='image/title_memo_01_on.gif' border=0>";
                echo "<a href='./?doc=bbs/mbmemo.php&kind=send'><img src='image/title_memo_02_off.gif' border=0></a>";
            }
           
            if ($kind == 'send') {
                echo "<a href='./?doc=bbs/mbmemo.php&kind=recv'><img src='image/title_memo_01_off.gif' border=0></a>";
                echo "<img src='image/title_memo_02_on.gif' border=0>";
            } ?></td>
        <td align=right valign=bottom> 전체 <?=$kind_title?> 쪽지 [ <B><?=$total_count?></B> ]통</td>
  </tr>
</table>

<table width=100% bgcolor=#CCCCCC cellpadding=1 cellspacing=0>
<tr>
    <td>
        <table width=100% cellpadding=0 cellspacing=0>
        <tr>
            <td align=center>
                <table width=100% cellpadding=1 cellspacing=1 border=0>
                <tr height=25 bgcolor=#F3F3F3 align=center>
                    <td><?= ($kind == 'recv') ? "보낸사람" : "받는사람"; ?></td>
                    <td width=120>보낸시간</td>
                    <td width=120>읽은시간 </td>
                    <td width=30>삭제</td>
                </tr>

                <?
                $sql = " select a.*, b.mb_name from $cfg[table_memo] a
                          left outer join $cfg[table_member] b on (a.me_{$unkind}_mb_id = b.mb_id)
                          where a.me_{$kind}_mb_id = '$member[mb_id]'
                          order by a.me_id desc limit $from_record, $rows";
                $result = sql_query($sql);
                for ($i=0; $row=mysql_fetch_array($result); $i++) {
                    $mb_id = $row["me_{$unkind}_mb_id"];

                    if ($row[mb_name])
                        $mb_name = $row[mb_name];
                    else
                        $mb_name = "<font color=silver>정보없음</font>";

                    if (substr($row[me_read_datetime],0,1) == '0')
                        $read_datetime = '아직 읽지 않음';
                    else
                        $read_datetime = $row[me_read_datetime];

                    $href = "./?doc=bbs/mbmemoview.php&me_id=$row[me_id]&kind=$kind";

                    echo "
                    <tr height=25 bgcolor=#FFFFFF align=center>
                        <td><a href='$href'>$mb_id ($mb_name)</a></td>
                        <td><a href='$href'>$row[me_send_datetime]</a></td>
                        <td><a href='$href'>$read_datetime</a></td>
                        <td><a href=\"javascript:if (confirm('삭제하시겠습니까?')) {location='./?doc=bbs/mbmemodelete.php&me_id=$row[me_id]&kind=$kind'}\"><img src='image/btn_memo_del.gif' border=0></a></td>
                    </tr>";

                }

                if ($i == 0) { echo "<tr bgcolor=#FFFFFF><td align=center colspan=4 height=100>자료가 없습니다.</td></tr>"; }
                ?>

                </table>
            </td>
        </tr>
        </table>
    </td>
</tr>
</table>

<table width=100% cellpadding=0 cellspacing=0 border=0>
<tr><td height=30> <a href="./?doc=bbs/mbmemoform.php"><img src='image/btn_send.gif' border=0></a> <a href="javascript:window.close();"><img src='image/btn_close.gif' border=0></a></td></tr>
</table>
<table width=100% cellpadding=0 cellspacing=0 border=0>
<tr><td height=30>
<?= get_paging(10, $page, $total_page,  "./?doc=bbs/mbmemo.php&kind=$kind&page=");?>
</td></tr>
</table>

</td></tr></table>
전체 1,026
그누3 팁자료실 내용 검색

회원로그인

(주)에스아이알소프트 / 대표:홍석명 / (06211) 서울특별시 강남구 역삼동 707-34 한신인터밸리24 서관 1402호 / E-Mail: admin@sir.kr
사업자등록번호: 217-81-36347 / 통신판매업신고번호:2014-서울강남-02098호 / 개인정보보호책임자:김민섭(minsup@sir.kr)
© SIRSOFT