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
|
<? include("./_common2.php"); include("category/opcommon.php"); $sql = "SELECT * from regist_user WHERE idx = '$idx'"; $result = mysql_query($sql); $row = mysql_fetch_array($result);
$detailsql = "SELECT * FROM mac_detail WHERE cdkey = '$row[cdkey]'"; //¸ÆÁ¤º¸Àоî¿À±â $detailresult = mysql_query($detailsql); while($detailrow = mysql_fetch_array($detailresult)){ $macupdatesql = "UPDATE macs SET app_rgsted = 0 WHERE mac_addr = '$detailrow[mac_addr]' AND app_code = '$row[app_code]'"; // mysql_query($macupdatesql); echo $macupdatesql; }
$detaildelsql = "UPDATE mac_detail set cdkey = null WHERE cdkey = '$row[cdkey]' AND app_code = '$row[app_code]'"; //¸ÆµðÅ×ÀÏ ¾¾µðŰ Null mysql_query($detaildelsql); echo $detaildelsql;
$dsql = "delete from regist_user WHERE idx = '$idx'"; mysql_query($dsql); ?> <SCRIPT LANGUAGE="JavaScript"> parent.alert("»èÁ¦µÇ¾ú½À´Ï´Ù"); parent.location.reload(); </SCRIPT>
|