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> <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>
|