query( $strSQL ); if( $objConn->nf() != 0 ) { $objConn->next_record(); $cnt = $objConn->f(0); } if( $cnt > 0 ) { $objConn->close(); AlertBack( "µ¿ÀÏÇÑ IDÀÇ POPÀÌ ÀÌ¹Ì Á¸ÀçÇÕ´Ï´Ù.\n\n´Ù¸¥ ID¸¦ ÀÔ·ÂÇϼ¼¿ä." ); exit; } // CHG 2015-11-19 huibong // t_rms_rc_index table ÀÇ arranage Ä÷³Àº auto increment ¼³Á¤À̹ǷÎ.. ºó°ª ÀԷ½à insert ¿À·ù ¹ß»ý. // µû¶ó¼­ arrange Ç׸ñ »èÁ¦ ó¸®ÇÔ. $strSQL_1 = " INSERT INTO t_rms_rc_index " . " (rcid, rc_name, svc_rcts_url, vol_url_rts, rcacct, reg_datetime ) " . " VALUES " . " ('$rcid', '$rc_name', '$rcts_addr', '$fhs_addr', '$rc_acct', now() ); "; $CookieSEED = "skldfhoi40wyrf83yf0hs9efh8943yf9herf"; $crypt = new cast128; $crypt->setkey( $CookieSEED ); //$loginid = $crypt->decrypt( base64_decode($_COOKIE["cookie_admin_id"]) ); $loginid = $_COOKIE["cookie_admin_id"] ; $reg_date = date( "Y-m-d H:i:s", time() ); $update_date = date( "Y-m-d H:i:s", time() ); $remoteaddr = getenv('REMOTE_ADDR'); $alert_msg = "[POPÃß°¡] POP ID:" . $rcid ." POP À̸§:" . $rc_name; // CHG 2015-11-19 huibong // t_system_event table insert 󸮽à column Ç׸ñ ¼³Á¤ ¾ÈÇÒ °æ¿ì.. auto increment Ç׸ñ ¶§¹®¿¡ ¿À·ù ¹ß»ý. $strSQL_4 = " INSERT INTO t_system_event " . " (sp_user_seq, sys_evt_svr_name, sys_evt_code, sys_evt_dtl, sys_evt_sendcnt, reg_datetime, update_datetime, deleted_yn, sys_evt_adminid) " . " VALUES " . " ( $admin_seq, '$remoteaddr', 'EV01', '$alert_msg', 0, '$reg_date', '$update_date', 'N', '$loginid' ); "; //$strSQL = $strSQL_1 . $strSQL_2 . $strSQL_3 . $strSQL_4; $strSQL = $strSQL_1 . $strSQL_4; $res1 = $objConn->query($strSQL_1); $res4 = $objConn->query($strSQL_4); //if( $objConn->query($strSQL) ) if( $res1 && $res4 ) { //$objConn->commitTrans(); // rcacct.conf ÆÄÀÏ ¾÷µ¥ÀÌÆ® $fp = fopen($rcAcctPath, "w"); $strSql = "SELECT rcacct FROM t_rms_rc_index WHERE deleted_yn = 'N' "; $res = $objConn->query($strSql); if( $objConn->nf() != 0 ) { while( $objConn->next_record() ) { $rcacct = $objConn->f("rcacct"); if (!is_null($rcacct) && $rcacct != "") { fwrite($fp, $rcacct."\n"); } } } fclose($fp); $objConn->close(); AlertMsg( "$rc_name RC°¡ Ãß°¡µÇ¾ú½À´Ï´Ù." ); echo( "" ); } else { $objConn->rollbackTrans(); $objConn->close(); AlertBack( "error: database query failed" ); } ?>