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
|
<?
@extract($_REQUEST);
if($parm_user_mac == ""){ //¸ÆÁÖ¼Ò°¡ ¾øÀ¸¸é ¾Æ¹«ÀÛ¾÷ ¾ÊÇÔ
} else {
include("common.php"); //DBÁ¢¼Ó
#------------ mac »ó¼¼Á¤º¸ °»½Å --------------#
$sql = "SELECT idx FROM macs WHERE mac_addr = '$parm_user_mac' AND app_code = '$parm_app_code'";
$result = mysql_query($sql);
if( mysql_num_rows($result) > 0){ //°ªÀÌ ÀÖÀ¸¸é
$row = mysql_fetch_array($result);
$var_idx = $row[idx];
$usql = "UPDATE macs SET app_rgsted = 1, uninstalled = 0 WHERE idx = '$var_idx'"; //Á¤Ç°µî·ÏÁ¤º¸ ¾÷µ¥ÀÌÆ®
mysql_query($usql);
#------------ mac_detail À¯ÀúÁ¤º¸ °»½Å --------------#
$dsql = "SELECT mac_idx FROM mac_detail WHERE mac_idx = '$var_idx'";
$dresult = mysql_query($dsql);
if( mysql_num_rows($dresult) > 0){ //mac_detail¿¡ °ªÀÌ ÀÖÀ¸¸é ¾÷µ¥ÀÌÆ®
$dusql = "UPDATE mac_detail SET user_id = '$parm_user_id', user_name = '$parm_user_name'
WHERE mac_idx = '$var_idx' ";
mysql_query($dusql);
} else { //mac_detail¿¡ °ªÀÌ ¾øÀ¸¸é Ãß°¡
$disql = "INSERT INTO mac_detail ( mac_idx, user_id, user_name )
VALUES ( '$var_idx', '$parm_user_id', '$parm_user_name' )";
mysql_query($disql);
}
}
}
?>
|