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
|
<?php include_once("_common.php");?> <? echo $upass; $today = date("Y-m-d"); //¿À´Ã³¯Â¥ $todaytime = date("Y-m-d H:s:i"); //¿À´Ã³¯Â¥½Ã°£ $limitdate = date('Y-m-d',time()+60*60*24*15);
include("../manage/category/msdbcommon.php");
$smqry = "SELECT * FROM app WHERE app_id = '12'"; $smresult = mysql_query($smqry); $smrow = mysql_fetch_array($smresult);
echo $smqry;
$appid = $smrow[app_id]; $appip = $smrow[default_app_dbip]; $appdb = $smrow[default_app_dbname]; $appdbid = $appdb."_".$cid;
$ipqry = "INSERT INTO app_priv (user_id, app_id, use_demo, limitdate, limituser, extlmtuser, eorderlimit, app_active, app_dbip, pda_sock_ip, app_dbname, app_dbsize, pgoptions, bigo) values ( '$cid', '$appid', '1', '$limitdate', '2', '0', '1', '1', '$appip', '114.108.136.196', '$appdbid','10240', '0000000000', '')"; mysql_query($ipqry); echo $ipqry; ?> <br> <? echo $cid;?> <br> <? echo $wpassword;?> <br> <? // ¼ÒÄÏ db»ý¼º ½ÃÀÛ
$address = $appip; $port="10085"; //¼ÒÄÏ
$socket=socket_create(AF_INET,SOCK_STREAM, SOL_TCP); $result=socket_connect($socket,$address,$port); echo $result; if(!$result) { ?> <SCRIPT LANGUAGE="JavaScript"> parent.alert("DB»ý¼º ¿¡·¯ÀÔ´Ï´Ù."); </SCRIPT> <? } else { ?>
<? $send_data="/1;12;$cid;$upass"; socket_send($socket,$send_data,strlen($send_data),0); $sMsg = socket_read($socket, 4096); if( $sMsg == "1"){ ?> <SCRIPT LANGUAGE="JavaScript"> parent.alert("DB»ý¼ºÀÌ ¿Ï·áµÇ¾ú½À´Ï´Ù. \n ·Î±×ÀιöưÀ» Çѹø ´õ Ŭ¸¯ÇØ ÁֽʽÿÀ."); </SCRIPT>
<? } socket_close($socket); // ¼ÒÄÏ db»ý¼º Á¾·á } ?>
|