/home/mjc1/public_html/manage/newwinedit_log.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
<?php include("./_common2.php"); ?>
<!DOCTYPE html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=euc-kr">
        <title>MacAddress »èÁ¦·Î±×</title> 
        <link rel='stylesheet' type='text/css' href='./css/reset.css'>
        <link rel='stylesheet' type='text/css' href='./css/point.css'>
        <script language='javascript' src="./js/jquery-1.8.3.min.js"></script>
    </head>
    
<?
    
@session_start();
    include(
"category/opcommon.php");
?>


<body>
<div class='wrap'><!--//wrap-->
    <div>
        <h2>MACÁ¤º¸»èÁ¦·Î±×</h2>

<style>
.rowWarp {margin:0 auto;width:620px;border:1px solid #9faebe;border-bottom:none }
.rowTable {width:100%;}
.rowTable th {height:24px;line-height:24px;padding:2px 2px 0;text-align:center;font-weight:600;border-right:1px solid #d1d7de;background:#ecf1f5}
.rowTable th.last {border-right:0 none;}
.rowTable td {height:20px;line-height:1.25;padding:2px 2px 0;text-align:center;border-right:1px solid #d1d7de; border-bottom:1px solid #9faebe;}
.rowTable td.last {border-right:0 none;}
</style>
        <div class="rowWarp">            
            CDKEY : <?php echo $cdkey;?><br>
            MACÁÖ¼Ò°Ë»ö <input type='text' name='skey' id="skey" value='<?php echo $skey;?>' style='border:1px solid #e0e0e0;'> <button onclick="mac_search()">°Ë»ö</button>
            &nbsp;&nbsp;<input type='checkbox' name='mac_sort' id='mac_sort' value='1' <?php if($mac_sort=='1'){ echo "checked"; }?>>°°Àº¸Æ ¸ð¾Æº¸±â
        </div>
        <div class="rowWarp">            
            <table class="rowTable">
                <colgroup>
                    <col style="width:110px;"><col style="width:250px;"><col style="width:170px;"><col style="width:120px;">
                </colgroup>
                <tr>
                    <th>ȸ¿øID</th>
                    <th>MACÁÖ¼Ò</th>
                    <th>»èÁ¦ÀÚ</th>
                    <th class="last">»èÁ¦ÀϽÃ</th>
                </tr>
<? 
    
//$sql = "SELECT * FROM mac_detail WHERE cdkey = '$cdkey'";
    
if($skey!=''){ $add_where " and replace(mac_addr,':','') like '%{$skey}%' "; } else { $add_where ""; }
    if(
$mac_sort=='1'){
        
$sql "SELECT A.* FROM mac_remove_log A WHERE A.cdkey = '{$cdkey}{$add_where} order by mac_addr";
    } else {
        
$sql "SELECT A.* FROM mac_remove_log A WHERE A.cdkey = '{$cdkey}{$add_where} order by del_date desc";
    }
    
//echo $sql;
    
$result mysql_query($sql);
    
    while(
$row mysql_fetch_array($result)){
        
$row['bigo'] = str_replace(",µ¥¸ð¿¬Àå"""$row['bigo']);

?>
                <tr>
                    <td><?=$row['user_id']?></td>
                    <td><?=$row['mac_addr']?></td>
                    <td><? if($row['admin_id']!=''){ echo $row['admin_id']; } else { echo "ȸ¿ø»èÁ¦"; }?>
                    </td>
                    <td class="last"><?=$row['del_date']?></td>
                </tr>
<? ?>     

            </table><!--//rowTable-->
        </div><!--//rowWarp-->

        <div class="btn2Warp" style="width:130px;">
           <img src="./images/common/btn_close.png" alt="´Ý±â"  onclick="javascript:self.close();" class="ml10">
        </div>
        <!-- ¸ÆÁ¤º¸ °ü¸® °ü·Ã ³¡ -->

    </div><!--//wrap-->
<script>
$(function(){
    $("#mac_sort").click(function(){
        mac_search();
    });
});
function mac_search(){
    v_skey = document.all.skey.value;
    v_mac_sort = 0;
    if($("#mac_sort").is(":checked")==true){
        v_mac_sort = 1;
    }
    document.location.href="newwinedit_log.php?cdkey=<?php echo $cdkey;?>&skey="+v_skey+"&mac_sort="+v_mac_sort;
}
</script>
</body>
</html>