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
|
<? include("./_common2.php"); @session_start();?> <? include("category/opcommon.php");
function sql_json($idx){ $sql = "select * from regist_user where idx = '$idx' "; $res = mysql_query($sql); $info = mysql_fetch_array($res); return json_encode($info); }
$edate = date("Y-m-d H:i:s",time());
$old_json = addslashes(sql_json($idx)); $isql = "UPDATE regist_user set license_pc = '$pgnum', license_pda = '$pdanum', sale_amount = '$price', bigo = '$bigo' , app_block = '$appblock' WHERE idx = '$idx' "; mysql_query($isql);
$new_json = addslashes(sql_json($idx));
$sql = "insert into regist_user_log set ru_idx = '{$idx}', rgster = '{$_SESSION[ADMINID]}', ru_old = '{$old_json}', ru_new = '{$new_json}', rgst_dtm = '{$edate}', act_type = '¼öÁ¤' "; mysql_query($sql);
$sql = "select count(*) as cnt from regist_user_edate where idx = '{$idx}' "; $res = mysql_query($sql); $info = mysql_fetch_array($res); if($info['cnt']>0){ $sql = "update regist_user_edate set edit_date = '{$edate}' where idx = '{$idx}' "; } else { $sql = "insert into regist_user_edate set edit_date = '{$edate}', idx = '{$idx}' "; } mysql_query($sql); ?> <SCRIPT LANGUAGE="JavaScript"> parent.alert("ÀúÀåµÇ¾ú½À´Ï´Ù"); parent.location.reload(); </SCRIPT>
|