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
|
<? session_start(); ?> <? include_once("./_common.php"); setcookie("cookie[op1]","$option1",0); //±âº»¼ö·® setcookie("cookie[op2]","$option2",0); //ÇÒÀαâÁØ setcookie("cookie[op3]","$option3",0); //ÇÒÀιæ½Ä setcookie("cookie[op4]","$option4",0); //°Ë»ö »óǰÁ¤·Ä¹æ½Ä setcookie("cookie[op5]","$option5",0); //°Ë»ö ¼ÒºÐ·ùÁ¤·Ä¹æ½Ä setcookie("cookie[op6]","$option6",0); //°ü¸®Ã¢°í setcookie("cookie[op7]","$option7",0); //Àç°í ÀÖ´Â »óǰ¸¸ °Ë»ö setcookie("cookie[op8]","$option8",0); //´ã´çÀÚº° °Å·¡Ã³ °Ë»ö »ç¿ë setcookie("cookie[op9]","$option9",0); //µî·Ï󸮽à ¹Ú½º»ç¿ë setcookie("cookie[op10]","$option10",0); //Àç°íºÎÁ·¸Þ½ÃÁö »ç¿ë setcookie("cookie[op11]","$option11",0); //ÁÖ¸ÅÀÔó ÀÚµ¿µî·Ï »ç¿ë setcookie("cookie[op12]","$option12",0); //°Å·¡Ã³º° »óǰ°Ë»ö±â´É »ç¿ë setcookie("cookie[op13]","$option13",0); //Àü¼ÛÈÄ °Å·¡Ã³ °íÁ¤
include("./commonOption.php"); $odbname = "jegocs_".$psa_uid; $osql = "SELECT * FROM user_configs WHERE dbname = '$odbname' AND ucode = '$pcusid' AND appcode = 'p1'"; $oresult = mysql_query($osql); if( mysql_num_rows($oresult) > 0){
$upqry1 = "UPDATE user_configs SET optvalue = '$option1' WHERE dbname = '$odbname' AND ucode = '$pcusid' AND appcode = 'p1' AND optname = 'ȯ°æ_±âº»¼ö·®'"; mysql_query($upqry1); $upqry2 = "UPDATE user_configs SET optvalue = '$option2' WHERE dbname = '$odbname' AND ucode = '$pcusid' AND appcode = 'p1' AND optname = 'ȯ°æ_ÇÒÀαâÁØ'"; mysql_query($upqry2); $upqry3 = "UPDATE user_configs SET optvalue = '$option3' WHERE dbname = '$odbname' AND ucode = '$pcusid' AND appcode = 'p1' AND optname = 'ȯ°æ_ÇÒÀιæ½Ä'"; mysql_query($upqry3); $upqry4 = "UPDATE user_configs SET optvalue = '$option4' WHERE dbname = '$odbname' AND ucode = '$pcusid' AND appcode = 'p1' AND optname = 'ȯ°æ_»óǰÁ¤·Ä'"; mysql_query($upqry4); $upqry5 = "UPDATE user_configs SET optvalue = '$option5' WHERE dbname = '$odbname' AND ucode = '$pcusid' AND appcode = 'p1' AND optname = 'ȯ°æ_¼ÒºÐ·ùÁ¤·Ä'"; mysql_query($upqry5); $upqry6 = "UPDATE user_configs SET optvalue = '$option6' WHERE dbname = '$odbname' AND ucode = '$pcusid' AND appcode = 'p1' AND optname = 'ȯ°æ_°ü¸®Ã¢°í'"; mysql_query($upqry6); $upqry7 = "UPDATE user_configs SET optvalue = '$option7' WHERE dbname = '$odbname' AND ucode = '$pcusid' AND appcode = 'p1' AND optname = 'ȯ°æ_Àç°í»óǰ°Ë»ö'"; mysql_query($upqry7); $upqry8 = "UPDATE user_configs SET optvalue = '$option8' WHERE dbname = '$odbname' AND ucode = '$pcusid' AND appcode = 'p1' AND optname = 'ȯ°æ_´ã´çÀÚ°Å·¡Ã³'"; mysql_query($upqry8); $upqry9 = "UPDATE user_configs SET optvalue = '$option9' WHERE dbname = '$odbname' AND ucode = '$pcusid' AND appcode = 'p1' AND optname = 'ȯ°æ_¹Ú½º»ç¿ë'"; mysql_query($upqry9); $upqry10 = "UPDATE user_configs SET optvalue = '$option10' WHERE dbname = '$odbname' AND ucode = '$pcusid' AND appcode = 'p1' AND optname = 'ȯ°æ_Àç°íºÎÁ·¾Ë¸²'"; mysql_query($upqry10); $upqry11 = "UPDATE user_configs SET optvalue = '$option11' WHERE dbname = '$odbname' AND ucode = '$pcusid' AND appcode = 'p1' AND optname = 'ȯ°æ_ÁÖ¸ÅÀÔóÀÚµ¿'"; mysql_query($upqry11); $upqry12 = "UPDATE user_configs SET optvalue = '$option12' WHERE dbname = '$odbname' AND ucode = '$pcusid' AND appcode = 'p1' AND optname = 'ȯ°æ_°Å·¡Ã³º°»óǰ°Ë»ö'"; mysql_query($upqry12); $upqry13 = "UPDATE user_configs SET optvalue = '$option13' WHERE dbname = '$odbname' AND ucode = '$pcusid' AND appcode = 'p1' AND optname = 'ȯ°æ_°Å·¡Ã³°íÁ¤'"; mysql_query($upqry13);
} else { $iqry1 = "INSERT INTO user_configs ( dbname, ucode, appcode, optname, optvalue ) value ( '$odbname', '$pcusid', 'p1', 'ȯ°æ_±âº»¼ö·®', '$option1'), ( '$odbname', '$pcusid', 'p1', 'ȯ°æ_ÇÒÀαâÁØ', '$option2'), ( '$odbname', '$pcusid', 'p1', 'ȯ°æ_ÇÒÀιæ½Ä', '$option3'), ( '$odbname', '$pcusid', 'p1', 'ȯ°æ_»óǰÁ¤·Ä', '$option4'), ( '$odbname', '$pcusid', 'p1', 'ȯ°æ_¼ÒºÐ·ùÁ¤·Ä', '$option5'), ( '$odbname', '$pcusid', 'p1', 'ȯ°æ_°ü¸®Ã¢°í', '$option6'), ( '$odbname', '$pcusid', 'p1', 'ȯ°æ_Àç°í»óǰ°Ë»ö', '$option7'), ( '$odbname', '$pcusid', 'p1', 'ȯ°æ_´ã´çÀÚ°Å·¡Ã³', '$option8'), ( '$odbname', '$pcusid', 'p1', 'ȯ°æ_¹Ú½º»ç¿ë', '$option9'), ( '$odbname', '$pcusid', 'p1', 'ȯ°æ_Àç°íºÎÁ·¾Ë¸²', '$option10'), ( '$odbname', '$pcusid', 'p1', 'ȯ°æ_ÁÖ¸ÅÀÔóÀÚµ¿', '$option11'), ( '$odbname', '$pcusid', 'p1', 'ȯ°æ_°Å·¡Ã³º°»óǰ°Ë»ö', '$option12'), ( '$odbname', '$pcusid', 'p1', 'ȯ°æ_°Å·¡Ã³°íÁ¤', '$option13') "; mysql_query($iqry1); }
?> <SCRIPT LANGUAGE="JavaScript">
parent.alert("ÀúÀåµÇ¾ú½À´Ï´Ù.");
</SCRIPT>
|