sql=$sql"; $res=mysqli_query($pubConn,$sql); $row=@mysqli_fetch_array($res); //echo mysqli_error($pubConn); $due_date = date("Y-m-d H:i:s",mktime(date("H"),date("i"),date("s")-$heatbeat_overtime,date("m"),date("d"),date("Y"))); $ove_date = date("Y-m-d H:i:s",mktime(date("H"),date("i"),date("s")+$heatbeat_overtime,date("m"),date("d"),date("Y"))); $hex_mes=$row[detailStat]; $refresh_time=$row[updateTime]; //echo $heatbeat_overtime; $bin_mes=''; for($i=0;$ibin_mes=$bin_mes"; $stt_e0 = 45+22; //E1 #0 status (bit 0: 0/1 not in used / in used; bit 1: 0/1 link not ok / link ok) $stt_e1 = 46+22; //E1 #1 status $licenseByte = 58+22; $licenseFlg = hexdec(substr($hex_mes,$licenseByte*2,2));//1:aas 2:vms 3:both //echo "
licenseFlg:$licenseFlg"; //Field08 E1#0 status (bit 0: 0/1 not in used / in used; bit 1: 0/1 link not ok / link ok) for($i=0;$i<2;$i++) { $binSttE0=substr($bin_mes,$stt_e0*8+7-$i,1); $sttE0[$i]=BinDec($binSttE0); if($DEBUG)echo "
sttE0[$i]=$sttE0[$i]"; } if(!$sttE0[0]) { $sttE0[1] = 2; } //Field09 E1#1 status for($i=0;$i<2;$i++) { $binSttE1=substr($bin_mes,$stt_e1*8+7-$i,1); $sttE1[$i]=BinDec($binSttE1); if($DEBUG)echo "
sttE1[$i]=$sttE1[$i]"; } if(!$sttE1[0]) { $sttE1[1] = 2; } }//end get heartbeat $aasDisable = $vmsDisable = 0; if($licenseFlg == 3) { $bothShow = 1; } else if($licenseFlg == 2) { $setAAS = 1; $setVMS = 0; $vmsDisable = 1; } else if($licenseFlg == 1) { $setVMS = 1; $setAAS = 0; $aasDisable = 1; } else { $hideBoth=1; } if(!isset($setAAS)&&!isset($setVMS)) $setAAS=1; $backurl_un = "$PHP_SELF?trunkgp=$trunkgp&infoNo=$infoNo&linkset=$linkset&selectedSysId=$selectedSysId&setAAS=$setAAS&setVMS=$setVMS&slctLanguage=$slctLanguage"; $selfurl = "$PHP_SELF?trunkgp=$trunkgp&infoNo=$infoNo&linkset=$linkset&selectedSysId=$selectedSysId&slctLanguage=$slctLanguage"; $backurl = urlencode($backurl_un); function goLastWeb() { global $backurl_un; global $scroll_y; echo ""; exit(); } $NetIdConfArr=array('International','International-S','National','National-S'); ?> "; else echo ""; $objDB = "OBJ_390"; $paramTable = 'param_99'; $vms_sysId = "390_99_99"; $vms_slctSysId = "390_" . $TypeNo . "_0"; $vms_mtp3_sysId = "222_8_" . $TypeNo; $vms_mtp3_slctSysId = "-1"; $mtp3_sysId = "222_99_99"; $mtp3_slctSysId = "-1"; $msc_sysId = "322_99_99"; $msc_slctSysId = "-1"; $vms_sccp_sysId = "223_8_" . $TypeNo; $vms_sccp_slctSysId = "-1"; $iptrans_sysId = "221_0_".$TypeNo; $vms_oidsysArr=array( array('oid' => '2.1', 'sysid' => $vms_sysId, 'selectsysid' => $vms_slctSysId), array('oid' => '2.2', 'sysid' => $vms_sysId, 'selectsysid' => $vms_slctSysId), array('oid' => '2.3', 'sysid' => $vms_sysId, 'selectsysid' => $vms_slctSysId), array('oid' => '2.4', 'sysid' => $vms_sysId, 'selectsysid' => $vms_slctSysId) ); $pub_oidsysArr=array( array('oid'=>'2.2', 'sysid'=> $mtp3_sysId, 'selectsysid'=> $mtp3_slctSysId), array('oid'=>'2.4.1', 'sysid'=> $mtp3_sysId, 'selectsysid'=> $mtp3_slctSysId), array('oid'=>'2.3', 'sysid'=> $mtp3_sysId, 'selectsysid'=> $mtp3_slctSysId), //获得wxc2 dpc array('oid'=>'2.1.1', 'sysid'=> $msc_sysId, 'selectsysid'=> $msc_slctSysId), array('oid'=>'2.1.2', 'sysid'=> $msc_sysId, 'selectsysid'=> $msc_slctSysId), array('oid'=>'2.1.3', 'sysid'=> $msc_sysId, 'selectsysid'=> $msc_slctSysId), array('oid'=>'2.1.4', 'sysid'=> $msc_sysId, 'selectsysid'=> $msc_slctSysId), array('oid'=>'2.1.6', 'sysid'=> $msc_sysId, 'selectsysid'=> $msc_slctSysId) ); $mtp3_vms_oidsysArr=array( array('oid'=>'2.2', 'sysid'=> $vms_mtp3_sysId, 'selectsysid'=> $vms_mtp3_slctSysId), array('oid'=>'2.3', 'sysid'=> $vms_mtp3_sysId, 'selectsysid'=> $vms_mtp3_slctSysId), //vms dpc array('oid'=>'2.4.1', 'sysid'=> $vms_mtp3_sysId, 'selectsysid'=> $vms_mtp3_slctSysId), //vms linkset array('oid'=>'2.6', 'sysid'=> $vms_mtp3_sysId, 'selectsysid'=> $vms_mtp3_slctSysId), //vms route array('oid'=>'2.2', 'sysid'=> '223_99_99', 'selectsysid'=> '-1'), array('oid'=>'2.1.8', 'sysid'=> $vms_sccp_sysId, 'selectsysid'=> $vms_sccp_slctSysId), array('oid'=>'2.2', 'sysid'=> $vms_sccp_sysId, 'selectsysid'=> $vms_sccp_slctSysId), ); $SaveArr=array( array('oidstr'=>'3.1', 'setvalue'=>'01' ,'sysid'=> $vms_sysId, 'selectsysid'=> $vms_slctSysId), array('oidstr'=>'3.7', 'setvalue'=>'02' ,'sysid'=> $vms_mtp3_sysId, 'selectsysid'=> $vms_mtp3_slctSysId), array('oidstr'=>'3.2', 'setvalue'=>'02' ,'sysid'=> $vms_sccp_sysId, 'selectsysid'=> $vms_sccp_slctSysId), array('oidstr'=>'3.2', 'setvalue'=>'02' ,'sysid'=> '223_99_99', 'selectsysid'=>'-1'), array('oidstr'=>'3.2', 'setvalue'=>'B5' ,'sysid'=> '322_99_99', 'selectsysid'=>'-1'), ); {//DPC $DPC_sysId = '222_99_99'; $DPC_sysIdArr = explode('_',$DPC_sysId); $DPC_sysTypeNo = $DPC_sysIdArr[0]; $DPC_sysNo = $DPC_sysIdArr[1]; $DPC_subSysNo = $DPC_sysIdArr[2]; $DPC_oidstr = '2.4.1'; $DPC_objWhereStr= ''; $DPC_objWhereStr =getLevelWhere($DPC_oidstr); $DPC_objDb = 'OBJ_'.$DPC_sysTypeNo; $DPC_paramTable = 'param_'.$DPC_sysNo; $DPC_paramSql = " SELECT initValue,readValue,instanceNo FROM $DPC_paramTable WHERE $DPC_objWhereStr AND instanceNo ='$linkset' "; if($DEBUG) echo "$DPC_paramSql
"; $DPC_Result = mysqli_query($pubConn,$DPC_paramSql); $DPC_Row = mysqli_fetch_array($DPC_Result); $DPC= hexdec(getBitValue($DPC_Row[initValue],'0.0-2.7')); $NetID = bindec(getBitValue($DPC_Row[initValue],'3.0-3.1')); } if(isset($doingOtherFlag)) { if($setPLMNServNo || $setPSTNServNo || $setLeaveMessNo||$setCheckMessNo) { $callType = 0;//normal $prefix_instance_no=updatePrefix($oldValue,$newValue,$callType,$trunkgp); //=======================to set the cli type to IDD ========= //=======================get the initValue ============ $database="OBJ_322"; $sql="select initValue from param_99 where level_1=2 and level_2=1 and level_3=2 and instanceNo='$prefix_instance_no' "; $result=@mysqli_query($pubConn,$sql); $rows=@mysqli_fetch_array($result); $old_initValue=$rows[initValue]; $new_initValue=substr($old_initValue,0,35); //set cli type to IDD $new_initValue.="2"; $new_initValue.=substr($old_initValue,36,4); ////======= $objDB="OBJ_322"; $oidstr = "2.1.2"; $objWhereStr = getLevelWhere($oidstr); $updSql = "update param_99 set initValue='$new_initValue' where $objWhereStr and instanceNo='$prefix_instance_no'"; mysqli_query($pubConn,$updSql); //======================================= $vms_tmpOidArr=array( array('oid'=>'2.1.1', 'sysid'=> $msc_sysId, 'selectsysid'=> $msc_slctSysId), array('oid'=>'2.1.2', 'sysid'=> $msc_sysId, 'selectsysid'=> $msc_slctSysId), array('oid'=>'2.1.3', 'sysid'=> $msc_sysId, 'selectsysid'=> $msc_slctSysId), array('oid' => '2.2.1.1', 'sysid' => $vms_sysId, 'selectsysid' => '-1') ); SetParam($vms_tmpOidArr); exit; } if(isset($setSCCP_MSISDN)) { {//set VMS SCCP 2.1.8 $ipSql = "SELECT sysNo,subSysNo,ip FROM sysInfo WHERE sysTypeNo='390' AND sysNo='$TypeNo' AND subSysNo='0' "; $ipResult= mysqli_query($pubConn,$ipSql); $Row=mysqli_fetch_array($ipResult); $IP = explode('.',$Row[ip]); $IP[0] = omc_keep_length(dechex($IP[0]),"0","2"); $IP[1] = omc_keep_length(dechex($IP[1]),"0","2"); $IP[2] = omc_keep_length(dechex($IP[2]),"0","2"); $IP[3] = omc_keep_length(dechex($IP[3]),"0","2"); $VMS_ip = $IP[0].$IP[1].$IP[2].$IP[3]; $sysId = "223_8_" . $TypeNo; $oidStr = '2.1.8'; $otherWhereStr = "and subSysNo=$TypeNo"; setParamValue($VMS_ip,$sysId,$oidStr,3,0,$otherWhereStr); setParamValue($NetID,$sysId,$oidStr,1,0,$otherWhereStr); }//end set VMS SCCP 2.1.8 $SCCP_MSISDN = $newValue; $SCCP_MSISDN_old = $oldValue; {//set Dailing prefix $callType = 0;//normal $prefix_instance_no=updatePrefix($SCCP_MSISDN_old,$SCCP_MSISDN,$callType,$trunkgp); //=======================to set the cli type to IDD ========= //=======================get the initValue ============ $database="OBJ_322"; $sql="select initValue from param_99 where level_1=2 and level_2=1 and level_3=2 and instanceNo='$prefix_instance_no' "; $result=@mysqli_query($pubConn,$sql); $rows=@mysqli_fetch_array($result); $old_initValue=$rows[initValue]; $new_initValue=substr($old_initValue,0,35); //set cli type to IDD $new_initValue.="2"; $new_initValue.=substr($old_initValue,36,4); ////======= $objDB="OBJ_322"; $oidstr = "2.1.2"; $objWhereStr = getLevelWhere($oidstr); $updSql = "update param_99 set initValue='$new_initValue' where $objWhereStr and instanceNo='$prefix_instance_no'"; mysqli_query($pubConn,$updSql); //======================================= }//end set Dailing prefix if($newValue===$oldValue) exit; {//SCF-- GTT table param_99 $sccp_objDB = 'OBJ_223'; $tmpTable = 'param_99'; $tmpConf = 'paramConf'; $oidstr = '2.2'; $objWhereStr = getLevelWhere($oidstr); $getSql="SELECT instanceNo,initValue FROM $tmpTable WHERE $objWhereStr AND initValue LIKE '01%' "; if(0) echo "
getSql=$getSql"; $result =mysqli_query($pubConn,$getSql); $haveSeted = 0; while($rows =mysqli_fetch_array($result)) { $tmpStartSCCP_MSISDN = getBitValue($rows[initValue],'03.0-12.7'); $tmpStartSCCP_MSISDN = str_replace('F','',$tmpStartSCCP_MSISDN); $tmpEndSCCP_MSISDN = getBitValue($rows[initValue],'13.0-22.7'); $tmpEndSCCP_MSISDN = str_replace('F','',$tmpEndSCCP_MSISDN); $tmpNi = hexdec(getBitValue($rows[initValue],'23.0-23.7')); $tmpDpc = hexdec(getBitValue($rows[initValue],'24.0-26.7')); $tmpSSN = hexdec(getBitValue($rows[initValue],'27.0-27.7')); if(strcmp($tmpStartSCCP_MSISDN,$SCCP_MSISDN_old)==0 && strcmp($tmpStartSCCP_MSISDN,$tmpEndSCCP_MSISDN)==0 && $tmpSSN == 0) { //echo "
$tmpStartSCCP_MSISDN
$SCCP_MSISDN_old"; $tmpInstanceNo = $rows[instanceNo]; $haveSeted = 1; break; } //echo "
$tmpStartSCCP_MSISDN
$SCCP_MSISDN_old
"; } //exit; if($haveSeted) { $setInstNo = $tmpInstanceNo; } else { $getSql="SELECT instanceNo,initValue FROM $tmpTable WHERE $objWhereStr AND initValue LIKE '00%' "; if(0) echo "
getSql=$getSql"; $result =mysqli_query($pubConn,$getSql); $rows =mysqli_fetch_array($result); $setInstNo = $rows[instanceNo]; } $niTypeArr = getNiType(); if($niTypeArr[$NetID]==0)//ITU { $TT = '00'; $NP = '01'; } else { $TT = '0E'; $NP = '00'; } if(strlen($SCCP_MSISDN)==0) { $rows[initValue] = "000000FFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF00000000000000000000FFFFFFFFFFFFFFFFFFFF"; } else { $rows[initValue] = setBitValue($rows[initValue],'0.0-0.7','01');//flag $rows[initValue] = setBitValue($rows[initValue],'01.0-01.7',$NP);//SCCP_MSISDN $rows[initValue] = setBitValue($rows[initValue],'02.0-02.7',$TT);//SCCP_MSISDN $tmp = omc_keep_length($SCCP_MSISDN,'F',20,0); $rows[initValue] = setBitValue($rows[initValue],'03.0-12.7',$tmp);// $rows[initValue] = setBitValue($rows[initValue],'13.0-22.7',$tmp);// $tmp = omc_keep_length($NetID,'0',2); $rows[initValue] = setBitValue($rows[initValue],'23.0-23.7',$tmp);//NI $tmp = omc_keep_length(dechex($DPC),'0',6); $rows[initValue] = setBitValue($rows[initValue],'24.0-26.7',$tmp);//DPC WXC2sp $tmp = omc_keep_length(dechex(0),'0',2); $rows[initValue] = setBitValue($rows[initValue],'27.0-27.7',$tmp);//SSN=0 $tmp = omc_keep_length(dechex(7),'0',2); $rows[initValue] = setBitValue($rows[initValue],'29.0-29.7',$tmp);//Address indicator } $rows[initValue] = strtoupper($rows[initValue]); //echo "
rows[initValue]:{$rows[initValue]}"; $updflag = "UPDATE $tmpTable SET initValue = '$rows[initValue]' WHERE $objWhereStr and instanceNo='$setInstNo' "; if(0) echo "
$updflag
"; //exit; mysqli_query($pubConn,$updflag); echo mysqli_error($pubConn); {//set gtt attribution from 2.4 $selSql = "select initValue from $tmpTable where level_1='2' and level_2='4' and instanceNo='$instanceNo'"; $Result = mysqli_query($pubConn,$selSql); $Row = mysqli_fetch_array($Result); $setValue = $Row[initValue]; $eleName = $Spname; $tmpEleName = omc_keep_length(toHex($eleName),"0",20,"0"); $setValue = setBitValue($setValue,'3.0-12.7',$tmpEleName); $updSql = "update $tmpTable set initValue = '$setValue' where level_1='2' and level_2='4' and instanceNo='$setInstNo'"; mysqli_query($pubConn,$updSql); echo mysqli_error($pubConn); }//end set gtt attribution form 2.4 }//end gtt table. $vms_tmpOidArr=array( array('oid'=>'2.1.1', 'sysid'=> $msc_sysId, 'selectsysid'=> $msc_slctSysId), array('oid'=>'2.1.2', 'sysid'=> $msc_sysId, 'selectsysid'=> $msc_slctSysId), array('oid'=>'2.1.3', 'sysid'=> $msc_sysId, 'selectsysid'=> $msc_slctSysId), array('oid'=>'2.1.8', 'sysid'=> $vms_sccp_sysId, 'selectsysid'=> $vms_sccp_slctSysId) ); SetParam($vms_tmpOidArr); $sccpSaveArr=array( array('oidstr'=>'3.2', 'setvalue'=>'02', 'sysid'=> $vms_sccp_sysId, 'selectsysid'=> $vms_sccp_slctSysId) ); SaveParam($sccpSaveArr); $sccpResetArr=array( array('oidstr'=>'3.2', 'setvalue'=>'00', 'sysid'=> $vms_sccp_sysId, 'selectsysid'=> $vms_sccp_slctSysId) ); SaveParam($sccpResetArr); exit; }//end if(isset($SCCP_MSISDN_save)) }// if($_SERVER['REQUEST_METHOD'] == "POST") { {//Signaling/Traffic if(isset($LicenseCtl_save)) { $tmp = "LicenseCtl"; $tmp = ${$tmp}; $tmp = omc_keep_length($tmp,'0',16); $oidstr = "2.5"; $objWhereStr = getLevelWhere($oidstr); $updflag = "UPDATE $paramTable SET initValue = '$tmp' WHERE $objWhereStr and instanceNo='$TypeNo'"; mysqli_query($pubConn,$updflag); echo mysqli_error($pubConn); $tmp_vms_oidsysArr=array( array('oid' => '2.5', 'sysid' => $vms_sysId, 'selectsysid' => $vms_slctSysId), ); SetParam($tmp_vms_oidsysArr); $i=0; while(1) { echo "

"; flush(); sleep(1); $i++; if($i>10) break; } goLastWeb(); } } if($setVMS==1) { //Basic Parameters { if(isset($SMSC_port_save) ||isset($SMSC0_ip_save) ||isset($SMSC1_ip_save) ||isset($setSys)) { $oidstr = "2.2.1.6"; $objWhereStr = getLevelWhere($oidstr); $getsql = "select initValue from $paramTable where $objWhereStr "; $result = @mysqli_query($pubConn,$getsql); $row = @mysqli_fetch_array($result); $setValue=$row[0]; $tmp = dechex($SMSC_port); $tmp = omc_keep_length($tmp,'0',4); $setValue = setBitValue($setValue,'00.0-01.7',$tmp); $IP = explode('.',$SMSC0_ip); $IP[0] = omc_keep_length(dechex($IP[0]),"0","2"); $IP[1] = omc_keep_length(dechex($IP[1]),"0","2"); $IP[2] = omc_keep_length(dechex($IP[2]),"0","2"); $IP[3] = omc_keep_length(dechex($IP[3]),"0","2"); $tmp = $IP[0].$IP[1].$IP[2].$IP[3]; $setValue = setBitValue($setValue,'02.0-05.7',$tmp); $IP = explode('.',$SMSC1_ip); $IP[0] = omc_keep_length(dechex($IP[0]),"0","2"); $IP[1] = omc_keep_length(dechex($IP[1]),"0","2"); $IP[2] = omc_keep_length(dechex($IP[2]),"0","2"); $IP[3] = omc_keep_length(dechex($IP[3]),"0","2"); $tmp = $IP[0].$IP[1].$IP[2].$IP[3]; $setValue = setBitValue($setValue,'06.0-09.7',$tmp); $updflag = "UPDATE $paramTable SET initValue = '$setValue' WHERE $objWhereStr "; if($DEBUG) echo "$updflag
"; mysqli_query($pubConn,$updflag); echo mysqli_error($pubConn); if(!isset($setSys)) goLastWeb(); } if(isset($PPS0_ip_save)||isset($PPS1_ip_save)||isset($setSys)) { $oidstr = "2.2.1.7"; $objWhereStr = getLevelWhere($oidstr); $getsql = "select initValue from $paramTable where $objWhereStr "; $result = @mysqli_query($pubConn,$getsql); $row = @mysqli_fetch_array($result); $setValue=$row[0]; $IP = explode('.',$PPS0_ip); $IP[0] = omc_keep_length(dechex($IP[0]),"0","2"); $IP[1] = omc_keep_length(dechex($IP[1]),"0","2"); $IP[2] = omc_keep_length(dechex($IP[2]),"0","2"); $IP[3] = omc_keep_length(dechex($IP[3]),"0","2"); $tmp = $IP[0].$IP[1].$IP[2].$IP[3]; $setValue = setBitValue($setValue,'02.0-05.7',$tmp); $IP = explode('.',$PPS1_ip); $IP[0] = omc_keep_length(dechex($IP[0]),"0","2"); $IP[1] = omc_keep_length(dechex($IP[1]),"0","2"); $IP[2] = omc_keep_length(dechex($IP[2]),"0","2"); $IP[3] = omc_keep_length(dechex($IP[3]),"0","2"); $tmp = $IP[0].$IP[1].$IP[2].$IP[3]; $setValue = setBitValue($setValue,'06.0-09.7',$tmp); $updflag = "UPDATE $paramTable SET initValue = '$setValue' WHERE $objWhereStr "; if($DEBUG) echo "$updflag
"; mysqli_query($pubConn,$updflag); echo mysqli_error($pubConn); if(!isset($setSys)) goLastWeb(); } } } if(isset($setSys) || isset($getSys)) { if(isset($setSys)) { echo "
Setting parameters
"; SetParam($vms_oidsysArr); SetParam($pub_oidsysArr); SetParam($mtp3_vms_oidsysArr); SaveParam($SaveArr); } else { echo "
Getting parameters
"; GetParam($vms_oidsysArr); GetParam($mtp3_vms_oidsysArr); } } } if($setSys || $getSys || $undoSet) { echo "

Finished!

"; if($DEBUG) exit(); goLastWeb(); } echo "

"; {//show head part echo ""; echo ""; echo ""; echo ""; echo ""; echo "

"; //echo "$strConfiguration > $strNetwork > VMS"; echo "Configuration > Network > VSS"; echo "

"; showHelp($helpId); echo "

"; echo "
"; //checkDevices(390); { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

"; echo "VSS System $Spname"; echo "

"; echo ""; echo " "; echo ""; echo "

"; echo "

$strBack"; echo "

"; echo "
"; } } if($hideBoth == 1) { echo ""; echo ""; echo ""; echo ""; echo ""; echo "

Input License Please:

"; echo " "; echo ""; echo "

"; exit; } {//get parameters {//WXC2 OPC $oidstr = '2.2'; $vms_link_Db = 'OBJ_222'; $vms_link_Table = 'param_99'; $subSysNo = 99; $objWhereStr= ''; $objWhereStr =getLevelWhere($oidstr); $paramSql = " SELECT initValue,readValue,instanceNo FROM $vms_link_Table WHERE $objWhereStr AND subSysNo = '$subSysNo' "; if($DEBUG) echo "$paramSql
"; $vms_Result = mysqli_query($pubConn,$paramSql); $vms_Row = mysqli_fetch_array($vms_Result); $NIbit = getBitValue($vms_Row[initValue],"0.$NetID"); $tmp = $NetID+1+$NIbit*4; $oidstr = '2.3.'.$tmp; $objWhereStr= ''; $objWhereStr =getLevelWhere($oidstr); $updSql = "SELECT initValue FROM $vms_link_Table WHERE $objWhereStr AND instanceNo = '0' AND subSysNo = '$subSysNo' "; $Result = mysqli_query($pubConn,$updSql); $Row = mysqli_fetch_array($Result); $WXC2OPC = hexdec($Row[initValue]); } {//MG IP $oidstr = "2.1.6"; $objWhereStr = getLevelWhere($oidstr); $getsql = "select initValue from $paramTable where $objWhereStr order by instanceNo"; $result = @mysqli_query($pubConn,$getsql); $row = @mysqli_fetch_array($result); $mgIp = getBitValue($row[0],'0.0-3.7'); for($i=0; $i<4; $i++) { $tmp = hexdec(substr($mgIp,$i*2,2)); $mgIp_0 .= $tmp . '.'; } $mgIp_0 = rtrim($mgIp_0,'.'); $row = @mysqli_fetch_array($result); $mgIp = getBitValue($row[0],'0.0-3.7'); for($i=0; $i<4; $i++) { $tmp = hexdec(substr($mgIp,$i*2,2)); $mgIp_1 .= $tmp . '.'; } $mgIp_1 = rtrim($mgIp_1,'.'); } {//SMSC address $oidstr = "2.2.1.6"; $objWhereStr = getLevelWhere($oidstr); $getsql = "select initValue from $paramTable where $objWhereStr "; $result = @mysqli_query($pubConn,$getsql); $row = @mysqli_fetch_array($result); //SMSC_port $SMSC_port = hexdec(getBitValue($row[0],'0.0-1.7')); //SMSC0 IP $hexip = getBitValue($row[0],'2.0-5.7'); $ip[0]=hexdec(getBitValue($hexip,"0.0-0.7")); $ip[1]=hexdec(getBitValue($hexip,"1.0-1.7")); $ip[2]=hexdec(getBitValue($hexip,"2.0-2.7")); $ip[3]=hexdec(getBitValue($hexip,"3.0-3.7")); $SMSC0_ip = $ip[0] . "." . $ip[1] . "." . $ip[2] . "." . $ip[3]; //SMSC1 IP $hexip = getBitValue($row[0],'6.0-9.7'); $ip[0]=hexdec(getBitValue($hexip,"0.0-0.7")); $ip[1]=hexdec(getBitValue($hexip,"1.0-1.7")); $ip[2]=hexdec(getBitValue($hexip,"2.0-2.7")); $ip[3]=hexdec(getBitValue($hexip,"3.0-3.7")); $SMSC1_ip = $ip[0] . "." . $ip[1] . "." . $ip[2] . "." . $ip[3]; } {//PPS address $oidstr = "2.2.1.7"; $objWhereStr = getLevelWhere($oidstr); $getsql = "select initValue from $paramTable where $objWhereStr "; $result = @mysqli_query($pubConn,$getsql); $row = @mysqli_fetch_array($result); //PPS0 IP $hexip = getBitValue($row[0],'2.0-5.7'); $ip[0]=hexdec(getBitValue($hexip,"0.0-0.7")); $ip[1]=hexdec(getBitValue($hexip,"1.0-1.7")); $ip[2]=hexdec(getBitValue($hexip,"2.0-2.7")); $ip[3]=hexdec(getBitValue($hexip,"3.0-3.7")); $PPS0_ip = $ip[0] . "." . $ip[1] . "." . $ip[2] . "." . $ip[3]; //PPS1 IP $hexip = getBitValue($row[0],'6.0-9.7'); $ip[0]=hexdec(getBitValue($hexip,"0.0-0.7")); $ip[1]=hexdec(getBitValue($hexip,"1.0-1.7")); $ip[2]=hexdec(getBitValue($hexip,"2.0-2.7")); $ip[3]=hexdec(getBitValue($hexip,"3.0-3.7")); $PPS1_ip = $ip[0] . "." . $ip[1] . "." . $ip[2] . "." . $ip[3]; } {//Link0 type $oidstr = "2.1.8"; $objWhereStr = getLevelWhere($oidstr); $getsql = "select initValue from $paramTable where $objWhereStr"; $result = @mysqli_query($pubConn,$getsql); $row = @mysqli_fetch_array($result); $link0_type = hexdec($row[initValue]); } {//Link1 type $oidstr = "2.1.8"; $objWhereStr = getLevelWhere($oidstr); $getsql = "select initValue from $paramTable where $objWhereStr"; $result = @mysqli_query($pubConn,$getsql); $row = @mysqli_fetch_array($result); $link1_type = hexdec($row[initValue]); } {//encode_rule0 $oidstr = "2.1.9"; $objWhereStr = getLevelWhere($oidstr); $getsql = "select initValue from $paramTable where $objWhereStr"; $result = @mysqli_query($pubConn,$getsql); $row = @mysqli_fetch_array($result); $encode_rule0 = hexdec($row[initValue]); } {//encode_rule1 $oidstr = "2.1.9"; $objWhereStr = getLevelWhere($oidstr); $getsql = "select initValue from $paramTable where $objWhereStr"; $result = @mysqli_query($pubConn,$getsql); $row = @mysqli_fetch_array($result); $encode_rule1 = hexdec($row[initValue]); } {//ISUP_TYPE_LK0 $oidstr = "2.1.10"; $objWhereStr = getLevelWhere($oidstr); $getsql = "select initValue from $paramTable where $objWhereStr"; $result = @mysqli_query($pubConn,$getsql); $row = @mysqli_fetch_array($result); $ISUP_TYPE_LK0 = hexdec($row[initValue]); } {//ISUP_TYPE_LK1 $oidstr = "2.1.10"; $objWhereStr = getLevelWhere($oidstr); $getsql = "select initValue from $paramTable where $objWhereStr"; $result = @mysqli_query($pubConn,$getsql); $row = @mysqli_fetch_array($result); $ISUP_TYPE_LK1 = hexdec($row[initValue]); } {//SCCP 2.1.8 MSISDN $sccp_objDB = 'OBJ_223'; $tmpTable = 'param_8'; $oidstr = '2.1.8'; $objWhereStr = getLevelWhere($oidstr); $getsql = "select initValue from $tmpTable where $objWhereStr"; $result = @mysqli_query($pubConn,$getsql); $row = @mysqli_fetch_array($result); $SCCP_MSISDN_value = getBitValue($row[0],"01.0-10.7"); $SCCP_MSISDN_value = str_replace('F','',$SCCP_MSISDN_value); echo ""; } {//SCCP SCF --- MSISDN(SCF_num) arwean $sccp_objDB = 'OBJ_223'; $tmpTable = 'param_99'; $oidstr = '2.1.147'; $objWhereStr = getLevelWhere($oidstr); $getsql = "select initValue from $tmpTable where $objWhereStr "; $result = @mysqli_query($pubConn,$getsql); $row = @mysqli_fetch_array($result); $SCF_num = getBitValue($row[initValue],"01.0-10.7"); $SCF_num = str_replace('F','',$SCF_num); echo ""; } {//link0 status $vmsLink0_status=$sttE0[1]; $vmsLink1_status=$sttE1[1]; if($vmsLink0_status==1) $color_vmsLink0_stat='blue'; elseif($vmsLink0_status==0) $color_vmsLink0_stat='red'; if($vmsLink1_status==1) $color_vmsLink1_stat='blue'; elseif($vmsLink1_status==0) $color_vmsLink1_stat='red'; } }//end get parameters $linkStaArr=array("N","Y","--"); if($setAAS==1) $bcAAS = '#E6E6E6'; else $bcAAS = ''; if($setVMS==1) $bcVMS = '#E6E6E6'; else $bcVMS = ''; echo ""; echo ""; if($aasDisable != 1) { echo ""; } if($vmsDisable != 1) { echo ""; } echo ""; echo ""; echo ""; echo "

"; echo "AAS Service"; echo "

"; echo "VMS Service"; echo "

"; echo ""; {//Signaling/Traffic echo " "; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; {//network number echo ""; echo ""; echo ""; echo ""; }//end network number {//star link echo ""; echo ""; echo ""; }//end link if($licenseFlg==2) $licenseStr = 'AAS'; else if($licenseFlg==1) $licenseStr = 'VMS'; else if($licenseFlg==3) $licenseStr = 'AAS and VMS'; else $licenseStr = 'Error'; echo ""; echo ""; echo ""; echo ""; echo "

Signaling/Traffic

Signaling Point Code

$DPC

Network Indicator

$NetIdConfArr[$NetID]"; echo ""; echo "

Network Number

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; if($setAAS) { echo ""; echo ""; } if($setVMS) { // echo ""; // echo ""; echo ""; } echo "

CC:	"; $sysId="390_99_99"; $oidStr = "2.1.3"; showParameter($sysId,$oidStr,1,1); echo "	NDC:	"; $oidStr = "2.1.4"; showParameter($sysId,$oidStr,1,1); echo "
MSISDN(SCCP):	"; $sysId="223_8_" . $TypeNo; $oidStr = "2.1.8"; $instanceNo = 0; $otherWhereStr = "and subSysNo=$TypeNo"; $doingOtherUlr="$PHP_SELF?doingOtherFlag=1&setSCCP_MSISDN=1&infoNo=$infoNo&linkset=$linkset&trunkgp=$trunkgp"; showParameter($sysId,$oidStr,2,1,$instanceNo,$doingOtherUlr,$otherWhereStr); echo "	MSISDN(local):	$local_MSISDN

Link

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $i=0; $mgIpName = "mgIp_".$i; $mgIp = $$mgIpName; echo ""; $linkStateId = "link".$i."_state"; $colorState = ${"color_vmsLink".$i."_stat"}; $vmsLinkState = ${"vmsLink".$i."_status"}; echo ""; echo ""; echo ""; echo ""; echo ""; $i=1; $mgIpName = "mgIp_".$i; $mgIp = $$mgIpName; echo ""; $linkStateId = "link".$i."_state"; $colorState = ${"color_vmsLink".$i."_stat"}; $vmsLinkState = ${"vmsLink".$i."_status"}; echo ""; echo ""; echo "

No	E1/T1	ITU/ANSI	A/MU LAW	CIC	MG IP	Status
0	"; $sysId="390_99_99"; $oidStr = "2.1.8"; showParameter($sysId,$oidStr,1,1); echo"	"; $oidStr = "2.1.10"; showParameter($sysId,$oidStr,1,1); echo "	"; $oidStr = "2.1.9"; showParameter($sysId,$oidStr,1,1); echo"	"; $oidStr = "2.1.7"; showParameter($sysId,$oidStr,1,1); echo "	$mgIp	{$linkStaArr[$vmsLinkState]}
1	"; $oidStr = "2.1.7"; showParameter($sysId,$oidStr,2,1); echo "	$mgIp	{$linkStaArr[$vmsLinkState]}

License Control

"; if(isset($LicenseCtl_edit)) { echo " "; echo ""; } else { echo "$licenseStr"; } echo "

"; } echo "
"; if($setVMS) {//Basic Parameters echo " "; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "

Basic Parameters

VMS Number

"; {//show VMS Number echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

MSISDN:	"; $sysId = "390_99_99"; $oidStr = "2.2.1.1"; $instanceNo=$TypeNo; showParameter($sysId,$oidStr,1,1,$instanceNo); echo "
Service No. PLMN:	"; $doingOtherUlr="$PHP_SELF?doingOtherFlag=1&setPLMNServNo=1&trunkgp=$trunkgp"; showParameter($sysId,$oidStr,2,1,$instanceNo,$doingOtherUlr); echo "	Service No. PSTN:	"; $doingOtherUlr="$PHP_SELF?doingOtherFlag=1&setPSTNServNo=1&trunkgp=$trunkgp"; showParameter($sysId,$oidStr,3,1,$instanceNo,$doingOtherUlr); echo "
Leave message:	"; $doingOtherUlr="$PHP_SELF?doingOtherFlag=1&setLeaveMessNo=1&trunkgp=$trunkgp"; showParameter($sysId,$oidStr,4,1,$instanceNo,$doingOtherUlr); echo "	Check message:	"; $doingOtherUlr="$PHP_SELF?doingOtherFlag=1&setCheckMessNo=1&trunkgp=$trunkgp"; showParameter($sysId,$oidStr,5,1,$instanceNo,$doingOtherUlr); echo "

SMPP Parameter

"; {//show ESME Parameter echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

SMPP ID:	"; $sysId = "390_99_99"; $oidStr = "2.2.1.2"; $instanceNo=$TypeNo; showParameter($sysId,$oidStr,1,3,$instanceNo); echo "	SMPP type:	"; $sysId = "390_99_99"; $oidStr = "2.2.1.4"; $instanceNo=$TypeNo; showParameter($sysId,$oidStr,1,3,$instanceNo); echo "
SMPP password:	"; $sysId = "390_99_99"; $oidStr = "2.2.1.3"; $instanceNo=$TypeNo; showParameter($sysId,$oidStr,1,3,$instanceNo); echo "

SMSC Address

"; {//show SMSC address echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

SMPP port:	"; if(isset($SMSC_port_edit)) { echo " "; echo ""; } else { echo ""; if($SMSC_port ==='') $SMSC_port ='--'; echo "$SMSC_port"; } echo "
SMSC0 IP:	"; if(isset($SMSC0_ip_edit)) { echo " "; echo ""; } else { echo ""; if($SMSC0_ip =='...') $SMSC0_ip ='--'; echo "$SMSC0_ip"; } echo "	SMSC1 IP:	"; if(isset($SMSC1_ip_edit)) { echo " "; echo ""; } else { echo ""; if($SMSC1_ip =='...') $SMSC1_ip ='--'; echo "$SMSC1_ip"; } echo "

PPS Address

"; {//show PPS address echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

PPS0 IP:

"; if(isset($PPS0_ip_edit)) { echo " "; echo ""; } else { echo ""; if($PPS0_ip =='') $PPS0_ip ='--'; echo "$PPS0_ip"; } echo "

PPS1 IP:

"; if(isset($PPS1_ip_edit)) { echo " "; echo ""; } else { echo ""; if($PPS1_ip =='') $PPS1_ip ='--'; echo "$PPS1_ip"; } echo "

Prefix

"; {//show Prefix echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

International:

"; $sysId = "390_99_99"; $oidStr = "2.2.1.5"; $instanceNo=0; showParameter($sysId,$oidStr,1,1,$instanceNo); echo "

National:

"; showParameter($sysId,$oidStr,2,1,$instanceNo); echo "

Number modification

"; {//show Number modification echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

Greeting:	"; $sysId = "390_99_99"; $oidStr = "2.2.1.9"; $instanceNo=0; showParameter($sysId,$oidStr,1,1,$instanceNo); echo "	Ringback Calling:	"; $sysId = "390_99_99"; $oidStr = "2.2.1.10"; $instanceNo=0; showParameter($sysId,$oidStr,1,1,$instanceNo); echo "
SMS:	"; for($i=0; $i<32; $i++) { echo "$i"; echo " "; } echo "

"; echo "
"; } if($setVMS) {//Mailbox preferences echo " "; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; {//show play mode echo ""; } echo ""; echo "

Mailbox Preferences

Length

"; {//show Length $w1 = '20%'; $w2 = '30%'; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

Min. voicemail length:

"; $sysId = "390_99_99"; $oidStr = "2.2.2.1"; $instanceNo=0; showParameter($sysId,$oidStr,1,1,$instanceNo); echo "

Max. voicemail length:

"; $sysId = "390_99_99"; $oidStr = "2.2.2.2"; $instanceNo=0; showParameter($sysId,$oidStr,1,1,$instanceNo); echo "

Validity

"; {//show Validity echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

New voicemail validity:

"; $sysId = "390_99_99"; $oidStr = "2.2.2.3"; $instanceNo=0; showParameter($sysId,$oidStr,1,1,$instanceNo); echo " Days

Old voicemail validity:

"; echo "

Digit Collection

"; {//show Digit collection echo ""; echo ""; echo ""; echo ""; } echo "

Password retry times:

"; $sysId = "390_99_99"; $oidStr = "2.2.2.5"; $instanceNo=0; showParameter($sysId,$oidStr,1,1,$instanceNo); echo " Times

Key-press timeout:

"; showParameter($sysId,$oidStr,2,1,$instanceNo); echo " Seconds

Circuit

"; {//show Circuit echo ""; echo ""; echo ""; echo ""; } echo "

Circuit selection:

Clockwise"; echo "

Circuit delay:

"; $sysId = "390_99_99"; $oidStr = "2.2.2.7"; $instanceNo=0; showParameter($sysId,$oidStr,1,1,$instanceNo); echo "

Play Mode

"; $sysId = "390_99_99"; $oidStr = "2.2.2.4"; $instanceNo=0; showParameter($sysId,$oidStr,1,1,$instanceNo); echo "

"; echo "
"; } $languageArr=array("Language 0","Language 1","Language 2","Language 3","Language 4"); if($setVMS) {//Short message notification //$languageArr=array("English","French","Chinese","Russian","Spanish"); echo " "; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; {//show New Message echo ""; echo ""; echo ""; } echo ""; echo ""; echo ""; {//show Unanswered call - CLI echo ""; echo ""; echo ""; } echo ""; echo ""; echo ""; {//show Full mailbox echo ""; echo ""; echo ""; } echo ""; echo ""; echo ""; {//show Unanswered call – no CLI echo ""; echo ""; echo ""; } echo ""; echo "

Short Message Notification"; echo " (Laguage:"; echo ")"; echo "
	Coding	Short Message Contents	Calling Number Prompt
New Message	"; $sysId = "390_99_99"; $oidStr = "2.2.3.1"; $instanceNo=$slctLanguage; showParameter($sysId,$oidStr,1,1,$instanceNo); echo "	"; showParameter($sysId,$oidStr,2,3,$instanceNo); echo "	"; showParameter($sysId,$oidStr,3,3,$instanceNo); echo "
Unanswered Call - CLI	";$sysId = "390_99_99"; $oidStr = "2.2.3.2"; $instanceNo=$slctLanguage; showParameter($sysId,$oidStr,1,1,$instanceNo); echo "	"; showParameter($sysId,$oidStr,2,3,$instanceNo); echo "	"; showParameter($sysId,$oidStr,3,3,$instanceNo); echo "
Full Mailbox	";$sysId = "390_99_99"; $oidStr = "2.2.3.3"; $instanceNo=$slctLanguage; showParameter($sysId,$oidStr,1,1,$instanceNo); echo "	"; showParameter($sysId,$oidStr,2,3,$instanceNo); echo "	"; showParameter($sysId,$oidStr,3,3,$instanceNo); echo "
Unanswered call – no CLI	";$sysId = "390_99_99"; $oidStr = "2.2.3.4"; $instanceNo=$slctLanguage; showParameter($sysId,$oidStr,1,1,$instanceNo); echo "	"; showParameter($sysId,$oidStr,2,3,$instanceNo); echo "	"; echo "--"; echo "

"; echo "
"; } {//Announcement play and update if($setAAS) { $tableName = 'aasAnnounce'; $wName = 'AAS'; } else { $tableName = 'vmsAnnounce'; $wName = 'VMS'; } echo " "; //$languageArr=array("English","French","Chinese","Russian","Spanish"); $selSql = " SELECT instance,languageNum,showfiled FROM $tableName where name ='$wName' and showfiled !='' order by instance"; $Result = @mysqli_query($pubConn,$selSql); $announceNum=@mysqli_num_rows($Result); $selSql = " SELECT showfiled FROM $tableName where name ='languageNum'"; $lan_re = @mysqli_query($pubConn,$selSql); $lan_row = @mysqli_fetch_array($lan_re); echo ""; if($setAAS) { echo ""; echo ""; echo ""; echo ""; } echo ""; // if($setVMS==1) echo ""; else echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; for($num=0;$num< $announceNum;$num++) { echo ""; echo ""; $Row = @mysqli_fetch_array($Result); $fileno = $Row[instance]; $fileno = omc_keep_length($Row[instance],0,3); echo ""; echo ""; echo ""; echo ""; } echo "

$wName Announcement"; echo " (Laguage:"; echo ")"; echo "
Repetition Counter	"; $sysId = "390_99_99"; $oidStr = "2.4.2"; showParameter($sysId,$oidStr,1,1); echo "
Leave Message Announcement	Call Unattainable Announcement
No.	Announcement	Play	Update
$num	$Row[showfiled]	"; $path = "language0".$slctLanguage."/"; $fullpath =$path.$fileno; $tmpSysId='390_'.$sysNo.'_0'; echo "play "; echo "	"; $path = "language0".$slctLanguage."/"; $fullpath =$path.$fileno; echo "upload "; echo "

"; } echo "

"; echo "VSS -> MSS"; echo "

"; echo "
"; {//update vms param $otherWhereStr = "and subSysNo=$TypeNo"; if($setAAS) {//add BB prefix for aas $tmp = omc_keep_length('BB','F',16,0); $tmp = strtoupper($tmp); $oidstr = "2.4.1"; $objWhereStr = getLevelWhere($oidstr); $updflag = "UPDATE $paramTable SET initValue = '$tmp' WHERE $objWhereStr "; if(0) echo "objDB,$objDB,$updflag
"; mysqli_query($pubConn,$updflag); echo mysqli_error($pubConn); //aas0 添加prefix //====change the BB prefix callType to Emergency $callType = 1; if($TypeNo==0) updatePrefix('BB','BB',$callType,$trunkgp); } if($setAAS) {//SCF-- GTT table (arwean 060224) $sccp_objDB = 'OBJ_223'; $tmpTable = 'param_8'; $oidstr = '2.2'; $objWhereStr = getLevelWhere($oidstr); $getSql="SELECT initValue FROM $tmpTable WHERE $objWhereStr $otherWhereStr AND instanceNo='0' "; if($DEBUG) echo "
getSql=$getSql"; $result =mysqli_query($pubConn,$getSql); $rows =mysqli_fetch_array($result); $niTypeArr = getNiType(); if($niTypeArr[$NetID]==0)//ITU { $TT = '00'; $NP = '01'; } else { $TT = '0E'; $NP = '00'; } $rows[initValue] = setBitValue($rows[initValue],'0.0-0.7','01');//flag $rows[initValue] = setBitValue($rows[initValue],'01.0-01.7',$NP); $rows[initValue] = setBitValue($rows[initValue],'02.0-02.7',$TT); $tmp = omc_keep_length($SCF_num,'F',20,0); $rows[initValue] = setBitValue($rows[initValue],'03.0-12.7',$tmp);//SCF number $rows[initValue] = setBitValue($rows[initValue],'13.0-22.7',$tmp);//SCF number $tmp = omc_keep_length($NetID,'0',2); $rows[initValue] = setBitValue($rows[initValue],'23.0-23.7',$tmp);//NI $tmp = omc_keep_length(dechex($WXC2OPC),'0',6); $rows[initValue] = setBitValue($rows[initValue],'24.0-26.7',$tmp);//DPC WXC2sp $tmp = dechex(147); $rows[initValue] = setBitValue($rows[initValue],'27.0-27.7',$tmp);//SSN=147 $rows[initValue] = setBitValue($rows[initValue],'29.0-29.7','07');//Address indicator $rows[initValue] = strtoupper($rows[initValue]); $updflag = "UPDATE $tmpTable SET initValue = '$rows[initValue]' WHERE $objWhereStr $otherWhereStr AND instanceNo='0' "; if($DEBUG) echo "
updflag:: $updflag
"; mysqli_query($pubConn,$updflag); echo mysqli_error($pubConn); } if(1)//修改VMS_mtp3 OPC DPC NI Route (arwean 060309) { $link_Db = 'OBJ_222'; $link_pub_Table = 'param_99'; $oidstr = '2.2'; $objWhereStr= ''; $objWhereStr =getLevelWhere($oidstr); $paramSql = " SELECT initValue,readValue,instanceNo FROM $link_pub_Table WHERE $objWhereStr "; $Result = mysqli_query($pubConn,$paramSql); $Row = mysqli_fetch_array($Result); $link_vms_Table = 'param_8'; $updSql = "UPDATE $link_vms_Table SET initValue = '$Row[initValue]' WHERE $objWhereStr $otherWhereStr AND instanceNo = '0' "; mysqli_query($pubConn,$updSql); $NIoffset = array("0.0-0.0","0.1-0.1","0.2-0.2","0.3-0.3"); $NI_bit = getBitValue($vms_Row[initValue],$NIoffset[$NetID]); $tmp = $NetID+1+$NI_bit*4; $oidstr = '2.3.'.$tmp; $objWhereStr= ''; $objWhereStr =getLevelWhere($oidstr); $set_OPC = dechex($DPC); $set_OPC = omc_keep_length($set_OPC,0,6); $set_OPC = strtoupper($set_OPC); $updSql = "UPDATE $link_vms_Table SET initValue = '$set_OPC' WHERE $objWhereStr $otherWhereStr "; if($DEBUG) echo "$updSql
"; mysqli_query($pubConn,$updSql); //VMS_8_pub--Linkset $TypeNo: $oidstr = '2.4.1'; $objWhereStr = getLevelWhere($oidstr); $getSql="SELECT initValue FROM $link_vms_Table WHERE $objWhereStr $otherWhereStr AND instanceNo='$TypeNo' "; if($DEBUG) echo "
getSql=$getSql"; $result =mysqli_query($pubConn,$getSql); $rows =mysqli_fetch_array($result); $tmp = omc_keep_length(dechex($WXC2OPC),'0',6); $rows[initValue] = setBitValue($rows[initValue],'0.0-2.7',$tmp);//DPC $tmp = omc_keep_length(decbin($NetID),'0',2); $rows[initValue] = setBitValue($rows[initValue],'3.0-3.1',$tmp);//NI $rows[initValue] = strtoupper($rows[initValue]); $updflag = "UPDATE $link_vms_Table SET initValue = '$rows[initValue]' WHERE $objWhereStr $otherWhereStr AND instanceNo='$TypeNo' "; if($DEBUG) echo "$updflag
"; mysqli_query($pubConn,$updflag); echo mysqli_error($pubConn); //VMS_8_pub--route $tmp=$NetID+1; $oidstr = '2.6.'.$tmp; $objWhereStr = getLevelWhere($oidstr); $getSql="SELECT initValue FROM $link_vms_Table WHERE $objWhereStr $otherWhereStr AND instanceNo='$TypeNo' "; if($DEBUG) echo "
getSql=$getSql"; $result =mysqli_query($pubConn,$getSql); $rows =mysqli_fetch_array($result); $tmp = omc_keep_length(dechex($WXC2OPC),'0',6); $rows[initValue] = setBitValue($rows[initValue],'0.0-2.7',$tmp); //DPC $rows[initValue] = setBitValue($rows[initValue],'3.0-3.7','00'); //Normal linkset $rows[initValue] = setBitValue($rows[initValue],'4.0-4.7','00'); //Alternative linkset $rows[initValue] = strtoupper($rows[initValue]); $updflag = "UPDATE $link_vms_Table SET initValue = '$rows[initValue]' WHERE $objWhereStr $otherWhereStr AND instanceNo='$TypeNo' "; if($DEBUG) echo "$updflag
"; mysqli_query($pubConn,$updflag); } if(1)//set vms NI DPC (arwean 060310) { $oidstr = "2.1.1"; //NI $objWhereStr = getLevelWhere($oidstr); $tmp = omc_keep_length(dechex($NetID),'0',2); $updflag = "UPDATE $paramTable SET initValue = '$tmp' WHERE $objWhereStr and instanceNo='$TypeNo' "; mysqli_query($pubConn,$updflag); echo mysqli_error($pubConn); $oidstr = "2.1.2"; //DPC $objWhereStr = getLevelWhere($oidstr); $tmp = omc_keep_length(dechex($WXC2OPC),'0',6);//DPC $tmp = strtoupper($tmp); $updflag = "UPDATE $paramTable SET initValue = '$tmp' WHERE $objWhereStr and instanceNo='$TypeNo' "; if($DEBUG) echo "
updflag: $updflag"; mysqli_query($pubConn,$updflag); echo mysqli_error($pubConn); } } ?>