그누보드4 페이지 번호가 안보입니다 채택완료

</p>

<p><?</p>

<p>

$sub_menu = "200400";

include_once("./_common.php");</p>

<p>auth_check($auth[$sub_menu], "r");</p>

<p>$sql_common = " from $g4[member_table] ";</p>

<p>$sql_search = " where (1) ";

if ($stx) {

    $sql_search .= " and ( ";

    switch ($sfl) {

        case "mb_point" :

            $sql_search .= " ($sfl >= '$stx') ";

            break;

        case "mb_level" :

            $sql_search .= " ($sfl = '$stx') ";

            break;

        case "mb_tel" :

        case "mb_hp" :

            $sql_search .= " ($sfl like '%$stx') ";

            break;

        default :

            $sql_search .= " ($sfl like '$stx%') ";

            break;

    }

    $sql_search .= " ) ";

}</p>

<p>// 만료일 검색

if ($membership_date1&&$membership_date2) {

    $sql_search .= "  and (mb_1 >= '$membership_date1' and mb_1 <= '$membership_date2') ";

}</p>

<p>// 회비납부 연장 클릭에 대한 DB쿼리</p>

<p>if($membership_fee&&$membership_id){

    switch ($membership_fee) {

        case "ok" :

            $sql_fee = " update  $g4[member_table] set mb_1 = DATE_FORMAT(DATE_ADD(mb_1,INTERVAL 1 MONTH),'%Y-%m-%d') where mb_id = '$membership_id' ";

            break;

        case "cancle" :

            $sql_fee = " update  $g4[member_table] set mb_1 = '' where mb_id = '$membership_id' ";

            break;

        default :

            $sql_fee = " update  $g4[member_table] set mb_1 = '".date("Y-m-d", mktime(0,0,0,date("m")+1  , date("d"), date("Y")))."' where mb_id = '$membership_id' ";

            break;

    }

    sql_query($sql_fee);

}</p>

<p>//if ($is_admin == 'group') $sql_search .= " and mb_level = '$member[mb_level]' ";

if ($is_admin != 'super') 

    $sql_search .= " and mb_level <= '$member[mb_level]' ";</p>

<p>if (!$sst) {

    $sst = "mb_datetime";

    $sod = "desc";

}</p>

<p>$sql_order = " order by $sst $sod ";</p>

<p>$sql = " select count(*) as cnt

         $sql_common

         $sql_search

         $sql_order ";

$row = sql_fetch($sql);

$total_count = $row[cnt];</p>

<p>$rows = $config[cf_page_rows];

$total_page  = ceil($total_count / $rows);  // 전체 페이지 계산

if (!$page) $page = 1; // 페이지가 없으면 첫 페이지 (1 페이지)

$from_record = ($page - 1) * $rows; // 시작 열을 구함</p>

<p>$listall = "<a href='$_SERVER[PHP_SELF]' class=tt>처음</a>";</p>

<p>$g4[title] = "회원관리";

include_once("./admin.head.php");</p>

<p>$sql = " select *

          $sql_common

          $sql_search

          $sql_order

          limit $from_record, $rows ";

$result = sql_query($sql);</p>

<p>$colspan = 10;

$today_date_7 = date("Y-m-d", mktime(0,0,0,date("m")  , date("d")+7, date("Y")));

$today_date = date('Y-m-d');

?></p>

<p><script language="javascript" src="<?=$g4[path]?>/js/sideview.js"></script>

<script language="javascript">

function membership_ok(member_id,member_fee){

    document.fmemberlist.membership_id.value = member_id;

    document.fmemberlist.membership_fee.value = member_fee;

    document.fmemberlist.submit();

}</p>

<p>function date_search(){

    if (!document.fsearch.membership_date1.value&&!document.fsearch.membership_date2.value){

        alert("기간이 입력되어 있지 않습니다.");

        document.fsearch.membership_date1.focus();

        return;

    } else if (!document.fsearch.membership_date1.value){

        document.fsearch.membership_date1.value = document.fsearch.membership_date2.value;

    } else if (!document.fsearch.membership_date2.value){

        document.fsearch.membership_date2.value = document.fsearch.membership_date1.value;

    } else {

    }

    document.fsearch.sfl.value="membership_date";

    document.fsearch.submit();

}</p>

<p>function week_search(){

    document.fsearch.membership_date1.value = document.fsearch.today_date.value;

    document.fsearch.membership_date2.value = document.fsearch.today_date_7.value;

    document.fsearch.sfl.value="membership_week";

    document.fsearch.submit();

}</p>

<p>function f_submit(){

    document.fsearch.submit();

}</p>

<p></script>

<table width=100%>

<form name=fsearch method=get>

<input type="hidden" name="today_date" value="<?=$today_date?>">

<input type="hidden" name="today_date_7" value="<?=$today_date_7?>">

<tr>

    <td width=130 align=left><?=$listall?> 

        (총회원수 : <?=number_format($total_count)?>)

    </td>

    <td>

        만료일 검색 :    <input type="text" name="membership_date1" value="<?=$membership_date1?>" size="10"> ~ 

                                <input type="text" name="membership_date2" value="<?=$membership_date2?>" size="10"><input type="button" name="date_s" value="검색" onclick="javascript:date_search();">

                                
( 날짜형태 ex. 2007-01-01 형태로 입력하세요.)                                

    </td>

    <td width=280 align=right>

        <select name=sfl class=cssfl>

            <option value='mb_id'>회원아이디</option>

            <option value='mb_name'>이름</option>

            <option value='mb_nick'>별명</option>

            <option value='mb_level'>권한</option>

            <option value='mb_point'>포인트</option>

        </select>

        <input type=text name=stx required itemname='검색어' value='<? echo $stx ?>'>

        <img src='<?=$g4[admin_path]?>/img/btn_search.gif' align=absmiddle onclick="javascript:f_submit();" style="cursor:hand;"></td>

</tr>

</form>

</table></p>

<p><table width=100% cellpadding=0 cellspacing=0>

<form name=fmemberlist method=post>

<input type=hidden name=sst  value='<?=$sst?>'>

<input type=hidden name=sod  value='<?=$sod?>'>

<input type=hidden name=sfl  value='<?=$sfl?>'>

<input type=hidden name=stx  value='<?=$stx?>'>

<input type=hidden name=page value='<?=$page?>'>

<colgroup width=90><!-- 회원아이디 -->

<colgroup width=60><!-- 이름 -->

<colgroup width=80><!-- 별명 -->

<colgroup width=''><!-- 권한 -->

<colgroup width=70><!-- 포인트 -->

<colgroup width=80><!-- 최종접속일 -->

<colgroup width=80><!-- 만료일 -->

<colgroup width=''><!-- 버튼 -->

<tr><td colspan='<?=$colspan?>' class='line1'></td></tr>

<tr class='bgcol1 bold col1 ht center'>

    <td><?=subject_sort_link('mb_id')?>회원아이디</a></td>

    <td><?=subject_sort_link('mb_name')?>이름</a></td>

    <td><?=subject_sort_link('mb_nick')?>별명</a></td>

    <td><?=subject_sort_link('mb_level', '', 'desc')?>권한</a></td>

    <td><?=subject_sort_link('mb_point', '', 'desc')?>포인트</a></td>

    <td><?=subject_sort_link('mb_today_login', '', 'desc')?>최종접속</a></td>

    <td><?=subject_sort_link('mb_1', '', 'desc')?>만료일</a></td>

    <td><input type="button" name="week_s" value="일주일내 종료 검색" style="width:110;" onclick="javascript:week_search();"></td>

</tr>

<tr><td colspan='<?=$colspan?>' class='line2'></td></tr>

<input type="hidden" name="membership_id" value="">

<input type="hidden" name="membership_fee" value="">

<?

for ($i=0; $row=sql_fetch_array($result); $i++) {

    $intercept_date = $row[mb_intercept_date] ? $row[mb_intercept_date] : date("Ymd", $g4[server_time]);</p>

<p>    $mb_nick = get_sideview($row[mb_id], $row[mb_nick], $row[mb_email], $row[mb_homepage]);</p>

<p>    $mb_id = $row[mb_id];

    if ($row[mb_leave_date])

        $mb_id = "<font color=crimson>$mb_id</font>";

    else if ($row[mb_intercept_date])

        $mb_id = "<font color=orange>$mb_id</font>";</p>

<p>    $list = $i%2;

    if($row[mb_1]) $membership_date = "ok"; else $membership_date = "new";

    echo "

    <input type=hidden name=mb_id[$i] value='$row[mb_id]'>

    <tr class='list$list col1 ht center'>

        <td title='$row[mb_id]'><nobr style='display:block; overflow:hidden; width:90;'> $mb_id</nobr></td>

        <td><nobr style='display:block; overflow:hidden; width:90px;'>$row[mb_name]</nobr></td>

        <td><nobr style='display:block; overflow:hidden; width:90px;'><u>$mb_nick</u></nobr></td>

        <td>".get_member_level_select("mb_level[$i]", 1, $member[mb_level], $row[mb_level])."</td>

        <td align=right><a href='point_list.php?sfl=mb_id&stx=$row[mb_id]' class=tt>".number_format($row[mb_point])."</a> </td>

        <td>".substr($row[mb_today_login],2,8)."</td>";</p>

<p>    if ($row[mb_1]<date("Y-m-d", mktime(0,0,0,date("m")  , date("d")-7, date("Y"))))

        echo "<td><font color='red'><b>".$row[mb_1]."</b></font></td>";

    else if ($row[mb_1]<date("Y-m-d"))

        echo "<td><font color='orange'><b>".$row[mb_1]."</b></font></td>";

    else

        echo "<td>".$row[mb_1]."</td>";

    echo "<td align='right'>";</p>

<p>    if($row[mb_1])

        echo "<nobr><input type='button' value='기존+1개월' onclick=\"javascript:membership_ok('".$row[mb_id]."','".$membership_date."')\">";

    echo "<input type='button' value='오늘+1개월' onclick=\"javascript:membership_ok('".$row[mb_id]."','new')\"><input type='button' value='연장취소' onclick=\"javascript:membership_ok('".$row[mb_id]."','cancle')\"></td></tr>";

}</p>

<p>if ($i == 0)

    echo "<tr><td colspan='$colspan' align=center height=100 class=contentbg>자료가 없습니다.</td></tr>";</p>

<p>echo "<tr><td colspan='$colspan' class='line2'></td></tr>";

echo "</table>";</p>

<p>$pagelist = get_paging($config[cf_write_pages], $page, $total_page, "?$qstr&page=");</p>

<p>if ($stx)

    echo "<script language='javascript'>document.fsearch.sfl.value = '$sfl';</script>\n";

?>

</form>

</form>

<input type="button" name="list_view" value="목록보기" onClick="javascript:location.href('./membership_fee.php');"></p>

<p><?

include_once ("./admin.tail.php");

?></p>

<p>