<?
$g4_path = "..";
include_once ("$g4_path/common.php");
include_once("$g4[path]/head.sub.php");
include_once("$g4[path]/head.php");

$g4[title] = "È¸¿ø¸ñ·Ï";

// È¸¿ø »èÁ¦
function member_delete($mb_id)
{
    global $config;
    global $g4;

    $sql = " select mb_recommend from $g4[member_table] where mb_id= '$mb_id' ";
    $mb = sql_fetch($sql);
    if ($mb[mb_recommend]) {
        $row = sql_fetch(" select count(*) as cnt from $g4[member_table] where mb_id = '$mb[mb_recommend]' ");
        if ($row[cnt])
            insert_point($mb[mb_recommend], $config[cf_recommend_point] * (-1), "{$mb_id}´ÔÀÇ È¸¿øÀÚ·á »èÁ¦·Î ÀÎÇÑ ÃßÃµÀÎ Æ÷ÀÎÆ® ¹ÝÈ¯");
    }

    $mb = sql_fetch(" select mb_name, mb_ip from $g4[member_table] where mb_id = '$mb_id' ");
    
    // È¸¿ø ÀÚ·á »èÁ¦
    sql_query(" delete from $g4[member_table] where mb_id = '$mb_id' ");

    // ´Ù¸¥ »ç¶÷ÀÌ ÀÌ È¸¿ø¾ÆÀÌµð¸¦ »ç¿ëÇÏÁö ¸øÇÏµµ·Ï ¾ÆÀÌµð¸¸ »ý¼ºÇØ ³õ½À´Ï´Ù.
    // °Ô½ÃÆÇ¿¡¼­ È¸¿ø¾ÆÀÌµð´Â »èÁ¦ÇÏÁö ¾Ê±â ¶§¹®ÀÔ´Ï´Ù.
    sql_query(" insert into $g4[member_table] set mb_id = '$mb_id', mb_name='$mb[mb_name]', mb_nick='[»èÁ¦µÊ]', mb_ip='$mb[mb_ip]', mb_datetime = '$g4[time_ymdhis]' ");
    
    // Æ÷ÀÎÆ® Å×ÀÌºí¿¡¼­ »èÁ¦
    sql_query(" delete from $g4[point_table] where mb_id = '$mb_id' ");
    
    // ±×·ìÁ¢±Ù°¡´É »èÁ¦
    sql_query(" delete from $g4[group_member_table] where mb_id = '$mb_id' ");
    
    // ÂÊÁö »èÁ¦
    sql_query(" delete from $g4[memo_table] where me_recv_mb_id = '$mb_id' or me_send_mb_id = '$mb_id' ");
    
    // ½ºÅ©·¦ »èÁ¦
    sql_query(" delete from $g4[scrap_table] where mb_id = '$mb_id' ");

    // ±×·ì°ü¸®ÀÚÀÎ °æ¿ì ±×·ì°ü¸®ÀÚ¸¦ °ø¹éÀ¸·Î 
    sql_query(" update $g4[group_table] set gr_admin = '' where gr_admin = '$mb_id' ");

    // °Ô½ÃÆÇ°ü¸®ÀÚÀÎ °æ¿ì °Ô½ÃÆÇ°ü¸®ÀÚ¸¦ °ø¹éÀ¸·Î
    sql_query(" update $g4[board_table] set bo_admin = '' where bo_admin = '$mb_id' ");

    // ¾ÆÀÌÄÜ »èÁ¦
    @unlink("$g4[path]/data/member/".substr($mb_id,0,2)."/$mb_id.gif");
}


// È¸¿ø±ÇÇÑÀ» SELECT Çü½ÄÀ¸·Î ¾òÀ½
function get_member_level_select($name, $start_id=0, $end_id=10, $selected='', $event='')
{
    global $g4;

    /*
    ksort($g4[member_level]);
    $str = "<select name='$name' $event>";
    foreach ($g4[member_level] as $key=>$value) {
        if ($key >= $start_id && $key <= $end_id) {
            $str .= "<option value='$key'";
            if ($key == $selected) $str .= " selected";
            $str .= ">$value</option>";
        }
    }
    $str .= "</select>";
    */
    $str = "<select name='$name' $event>";
    for ($i=$start_id; $i<=$end_id; $i++)
    {
        $str .= "<option value='$i'";
        if ($i == $selected) 
            $str .= " selected";
        $str .= ">$i</option>";
    }
    $str .= "</select>";
    return $str;
}


// È¸¿ø¾ÆÀÌµðÀ» SELECT Çü½ÄÀ¸·Î ¾òÀ½
function get_member_id_select($name, $level, $selected='', $event='')
{
    global $g4;

    $sql = " select mb_id from $g4[member_table] where mb_level >= '$level' ";
    $result = sql_query($sql);
    $str = "<select name='$name' $event><option value=''>¼±ÅÃ¾ÈÇÔ";
    for ($i=0; $row=sql_fetch_array($result); $i++) 
    {
        $str .= "<option value='$row[mb_id]'";
        if ($row[mb_id] == $selected) $str .= " selected";
        $str .= ">$row[mb_id]</option>";
    }
    $str .= "</select>";
    return $str;
}

// ±ÇÇÑ °Ë»ç
function auth_check($auth, $attr)
{
    global $is_admin;

    if ($is_admin == "super") return;

    if (!trim($auth))
        alert("ÀÌ ¸Þ´º¿¡´Â Á¢±Ù ±ÇÇÑÀÌ ¾ø½À´Ï´Ù.\\n\\nÁ¢±Ù ±ÇÇÑÀº ÃÖ°í°ü¸®ÀÚ¸¸ ºÎ¿©ÇÒ ¼ö ÀÖ½À´Ï´Ù.");

    $attr = strtolower($attr);

    if (!strstr($auth, $attr)) {
        if ($attr == "r")
            alert("ÀÐÀ» ±ÇÇÑÀÌ ¾ø½À´Ï´Ù.");
        else if ($attr == "w")
            alert("ÀÔ·Â, Ãß°¡, »ý¼º, ¼öÁ¤ ±ÇÇÑÀÌ ¾ø½À´Ï´Ù.");
        else if ($attr == "d")
            alert("»èÁ¦ ±ÇÇÑÀÌ ¾ø½À´Ï´Ù.");
        else 
            alert("¼Ó¼ºÀÌ Àß¸ø µÇ¾ú½À´Ï´Ù.");
    }
}


// Á¢±Ù ±ÇÇÑ °Ë»ç
if (!$member[mb_id])
    alert("·Î±×ÀÎ ÇÏ½Ê½Ã¿À.", "$g4[bbs_path]/login.php?url=" . urlencode("$_SERVER[PHP_SELF]?w=$w&mb_id=$mb_id"));

else if($member[mb_level] < 3) { //3·¹º§ ¹Ì¸¸ÀÌ¸é È¨ÆäÀÌÁö ¸ÞÀÎÀ¸·Î Æ¨°ÜÁÖ±â*^^*
alert("Á¢±Ù±ÇÇÑÀÌ ¾ø½À´Ï´Ù.", $g4[path]);
}

else if ($is_admin != "super") {
    $auth = array();
    $sql = " select au_menu, au_auth from $g4[auth_table] where mb_id = '$member[mb_id]' ";
    $result = sql_query($sql);
    for($i=0; $row=sql_fetch_array($result); $i++) {
        $auth[$row[au_menu]] = $row[au_auth];
    }

//    if (!$i) //È¸¿ø ·¹º§º° È¸¿ø ¸ñ·Ï¿¡ Á¢±ÙÇÏ±â À§ÇØ ¿øº»¼Ò½º ÇÏ´Ü 2ÁÙ±îÁö ÁÖ¼®Ã³¸®
//        alert("ÃÖ°í°ü¸®ÀÚ ¶Ç´Â °ü¸®±ÇÇÑÀÌ ÀÖ´Â È¸¿ø¸¸ Á¢±Ù °¡´ÉÇÕ´Ï´Ù.", $g4[path]);

//·¹º§º° Á¢±Ù±ÇÇÑ ¼³Á¤À¸·Î Á¦¾îÇÏ±â 132~134¶óÀÎ¿¡ ±âÀçÇØµµ ÀÇµµ´ë·Î ±¸Çö, ÇöÀç¶óÀÎ ÀÌÇÏ 3¶óÀÎÀÌ¾îµµ °¡´ÉÇÔ.
//  if($member[mb_level] < 3) { //3·¹º§ ¹Ì¸¸ÀÌ¸é È¨ÆäÀÌÁö ¸ÞÀÎÀ¸·Î Æ¨±â±â
//  alert("Á¢±Ù±ÇÇÑÀÌ ¾ø½À´Ï´Ù.", $g4[path]);
//  }
}

$sql_common = " from $g4[member_table] ";

$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;
        default :
            $sql_search .= " ($sfl like '$stx%') ";
            break;
    }
    $sql_search .= " ) ";
}

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

if (!$sst) {
    $sst = "mb_datetime";
    $sod = "desc";
}

$sql_order = " order by $sst $sod ";

$sql = " select count(*) as cnt
         $sql_common
         $sql_search
         $sql_order ";
$row = sql_fetch($sql);
$total_count = $row[cnt];

$rows = $config[cf_page_rows];
$total_page  = ceil($total_count / $rows);  // ÀüÃ¼ ÆäÀÌÁö °è»ê
if (!$page) $page = 1; // ÆäÀÌÁö°¡ ¾øÀ¸¸é Ã¹ ÆäÀÌÁö (1 ÆäÀÌÁö)
$from_record = ($page - 1) * $rows; // ½ÃÀÛ ¿­À» ±¸ÇÔ

// Å»ÅðÈ¸¿ø¼ö
$sql = " select count(*) as cnt
         $sql_common
         $sql_search
            and mb_leave_date <> ''
         $sql_order ";
$row = sql_fetch($sql);
$leave_count = $row[cnt];

// Â÷´ÜÈ¸¿ø¼ö
$sql = " select count(*) as cnt
         $sql_common
         $sql_search
            and mb_intercept_date <> ''
         $sql_order ";
$row = sql_fetch($sql);
$intercept_count = $row[cnt];

$sql = " select *
          $sql_common
          $sql_search
          $sql_order
          limit $from_record, $rows ";
$result = sql_query($sql);

$listall = "<a href='$_SERVER[PHP_SELF]' class=tt>Ã³À½</a>";

?>

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

<style>
.tablebg { background-color:#DDDDDD; }

.subject { color:#315584; }
.subjectbg { background-color:#EFF3F7; }

.list { color:#222222; }
.list0 { background-color:#FFFFFF; }
.list1 { background-color:#F5F5F5; }

.ht { height:30px; } 
</style>

<script language="JavaScript">
var list_update_php = "../adm/member_list_update.php";
var list_delete_php = "../adm/member_list_delete.php";
</script>

<table align=center width=100%>
<form name=fsearch method=get>
<tr>
    <td width=50% align=left><?=$listall?> (ÃÑÈ¸¿ø¼ö : <?=number_format($total_count)?>, Â÷´Ü : <?=number_format($intercept_count)?>, Å»Åð : <?=number_format($leave_count)?>)</td>
    <td width=50% align=right>
        <select name=sfl class=cssfl>
            <option value='mb_id'>È¸¿ø¾ÆÀÌµð</option>
            <option value='mb_nick'>º°¸í</option>
            <option value='mb_level'>±ÇÇÑ</option>
            <option value='mb_email'>E-MAIL</option>
            <option value='mb_tel'>ÀüÈ­¹øÈ£</option>
            <option value='mb_hp'>ÇÚµåÆù¹øÈ£</option>
            <option value='mb_point'>Æ÷ÀÎÆ®</option>
            <option value='mb_datetime'>°¡ÀÔÀÏ½Ã</option>
            <option value='mb_ip'>IP</option>
            <option value='mb_recommend'>ÃßÃµÀÎ</option>
        </select>
        <input type=text name=stx required itemname='°Ë»ö¾î' value='<? echo $stx ?>'>
        <input type=image src='../adm/img/btn_search.gif' align=absmiddle></td>
</tr>
</form>
</table>

<table align=center width=100% cellpadding=3 cellspacing=1 class=tablebg>
<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=100>
<colgroup width=120>
<colgroup width=>
<colgroup width=80>
<colgroup width=80>
<colgroup width=80>
<!-- <colgroup width=70> -->
<colgroup width=120>
<tr class='subject subjectbg ht' align=center>
    <td><?=subject_sort_link('mb_id')?>È¸¿ø¾ÆÀÌµð</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_datetime', '', 'desc')?>°¡ÀÔÀÏ</a></td>
    <td><?=subject_sort_link('mb_today_login', '', 'desc')?>ÃÖÁ¾Á¢¼Ó</a></td>
    <!-- <td><?=subject_sort_link('mb_birth', '', 'desc')?>»ýÀÏ</a></td> -->
	<td><a href="../adm/member_form.php">Ãß°¡</a></td>
</tr>

<?
for ($i=0; $row=sql_fetch_array($result); $i++) {
    // Á¢±Ù°¡´ÉÇÑ ±×·ì¼ö
    $sql2 = " select count(*) as cnt from $g4[group_member_table] where mb_id = '$row[mb_id]' ";
    $row2 = sql_fetch($sql2);
    $group = "";
    if ($row2[cnt])
        $group = "<a href='../adm/boardgroupmember_form.php?mb_id=$row[mb_id]'>$row2[cnt]</a>";

    if ($is_admin == 'group') {
        $s_mod = "";
        $s_del = "";
    } else {
        $s_mod = "<a href=\"../adm/member_form.php?$qstr&w=u&mb_id=$row[mb_id]\">¼öÁ¤</a>";
        $s_del = "<a href=\"javascript:del('../adm/member_delete.php?$qstr&w=d&mb_id=$row[mb_id]');\">»èÁ¦</a>";
    }
    $s_grp = "<a href='../adm/boardgroupmember_form.php?mb_id=$row[mb_id]'>±×·ì</a>";

    $leave_date = $row[mb_leave_date] ? $row[mb_leave_date] : date("Ymd", $g4[server_time]);
    $intercept_date = $row[mb_intercept_date] ? $row[mb_intercept_date] : date("Ymd", $g4[server_time]);

    $mb_nick = get_sideview($row[mb_id], $row[mb_nick], $row[mb_email], $row[mb_homepage]);

    $list = $i%2;
    echo "
    <input type=hidden name=mb_id[$i] value='$row[mb_id]'>
    <tr class='ht list' bgcolor='#ffffff' height=25 align=center onMouseOver=this.style.backgroundColor='#eeeeee' onMouseOut=this.style.backgroundColor=''>
        <td title='$row[mb_id]'><nobr style='display:block; overflow:hidden; width:100px;'>&nbsp;$row[mb_id]</nobr></td>
        <td><u>$mb_nick</u></td>
        <td>$row[mb_level]</td>
        <td><a href='point_list.php?sfl=a.mb_id&stx=$row[mb_id]' class=tt>".number_format($row[mb_point])."</a>&nbsp;</td>
        <td>".substr($row[mb_datetime],2,8)."</td>
        <td>".substr($row[mb_today_login],2,8)."</td>
        <!-- <td>".$row[mb_birth]."</td> -->
        <td>$s_mod $s_del $s_grp</td>
    </tr>";
}

if ($i == 0)
echo "<tr><td colspan='14' align=center height=100 class=contentbg>ÀÚ·á°¡ ¾ø½À´Ï´Ù.</td></tr>";
echo "</table>";

$pagelist = get_paging($config[cf_write_pages], $page, $total_page, "?$qstr&page=");
echo "<table width=100% cellpadding=3 cellspacing=1>";
echo "<tr><td width=100% align=right>$pagelist</td></tr></table>\n";

if ($stx)
    echo "<script language='javascript'>document.fsearch.sfl.value = '$sfl';</script>\n";
?>
</form>

<?
include_once("$g4[path]/tail.php");
include_once("$g4[path]/tail.sub.php");
?>
