";
$to_mails = "webting@solbox.com";
####$to_mails = "linuxser@solbox.com,dev@netomi.co.kr,bs@netomi.co.kr,lyj94@netomi.co.kr,2020kid@netomi.co.kr,redeye@netomi.co.kr,ssantacho@netomi.co.kr,hnanna@kt.co.kr,tukim99@kt.co.kr,dgkim06@kt.co.kr,leehj@kt.co.kr,js4c@netomi.co.kr,waiting@netomi.co.kr";
// CHG 2011-03-22 huibong 메일 전송 계정을 svc1 로 변경처리함.
//$from_mail = "nuhonda@solbox.com";
$from_mail = "svc1@solbox.com";
$body = trim(htmlBody($raddr));
$to_mail = explode(",", $to_mails);
$cnt = count($to_mail);
for($i=0; $i < $cnt; $i++)
{
$sendmail = new sendmail("127.0.0.1", 25, 30);
$sendmail->open();
$sendmail->send($to_mail[$i], $from_mail, trim($msg), $body);
$sendmail->close();
}
if($id != "" && $msg != "")
{
//$msg = "[RAID:".$_GET['host']."] ".$sms_time." ".$mseg;
// NEW 2010-06-18 huibong RAID SMS 가 다음과 같은 형식으로 처리되도록 수정처리함.
// [RAID:ics15-qcfhs1 222.122.162.111] 07-16 10:28:41 #1 IDE Channel #16 Device Removed
// 1. host 부분에서 ktsh.co.kr 제거처리
$sms_host = strtok( $_GET['host'], "." );
// 2. 시간 정보 중 년도 부분을 제거처리
$sms_time = $time;
if( strlen($sms_time) > 14 )
{
$sms_time = substr($time, 5);
}
// 3. 메시지 중 Controller#1 부분을 #1 으로 변경처리
$sms_msg = $mseg;
if( strncmp( $mseg, "Controller#", 11) == 0 )
{
$sms_msg = substr( $mseg, 10 );
}
// 4. 최종 SMS 메시지 조립 (IP 정보 부분 추가 처리)
$msg = "[RAID:".$sms_host." ".$raddr."] ".$sms_time." ".$sms_msg;
echo $msg."
";
$dbConnPgSql = new DB_Sql;
$strSqlpg = "SELECT group_seq ";
$strSqlpg .= "FROM t_group ";
$strSqlpg .= "WHERE group_id = '".$id."' AND group_password = '".$pw."' AND deleted_yn = 'N'";
$dbConnPgSql->query($strSqlpg);
if($dbConnPgSql->nf() == 1)
{
$dbConnPgSql->next_record();
$group_seq = $dbConnPgSql->f("group_seq");
if($group_seq != "")
{
$strSqlpg = "SELECT member_cellphone ";
$strSqlpg .= "FROM t_group_member ";
$strSqlpg .= "WHERE group_seq = ".$group_seq;
//echo $strSqlpg."
";
$dbConnPgSql->query($strSqlpg);
//echo $dbConnPgSql->nf()."
";
if($dbConnPgSql->nf() != 0)
{
$tmpSqlmy = "";
$tmpSqlpg = "";
$user_count =0;
$cellphone_list = "";
// 2010-09-15 huibong SMS RELAY 서버 변경 및 관련 코드 수정 처리함.
$dbConnMySql = new dbconnect('222.122.18.22', 'smsuser', 'sms5emffld)', 'sms', __FILE__, __LINE__);
while($dbConnPgSql->next_record())
{
$cellphone = $dbConnPgSql->f("member_cellphone");
if( strlen($cellphone_list) > 0 )
{
$cellphone_list .= "|ktics1^" . $cellphone;
}
else
{
$cellphone_list = "ktics1^" . $cellphone;
}
$user_count ++;
$tmpSqlpg .= "INSERT INTO t_sms_log (group_seq, sms_id, sms_cellphone, sms_message, reg_datetime, update_datetime) ";
$tmpSqlpg .= "VALUES (".$group_seq.", 'SH_".$id."', '".$cellphone."', '".$msg."', now(), now()); ";
}
$tmpSqlmy = "INSERT INTO SDK_SMS_SEND ( USER_ID, SCHEDULE_TYPE, SUBJECT, NOW_DATE,SEND_DATE, CALLBACK, DEST_COUNT, DEST_INFO, SMS_MSG) ";
$tmpSqlmy .= "VALUES ('ktics1', 0,'ktics1',DATE_FORMAT(now(),'%Y%m%d%H%i%s'),DATE_FORMAT(now(),'%Y%m%d%H%i%s'),'0317810344',$user_count,'$cellphone_list','$msg')";
echo $tmpSqlpg."
";
echo $tmpSqlmy."
";
$res = $dbConnMySql->query($tmpSqlmy,__FILE__, __LINE__);
if( !$res->result )
{
echo "fail to send SMS "; echo "
";
}
$dbConnMySql->close();
$dbConnPgSql->query($tmpSqlpg);
}
}
}
}
?>