"; $sgTableConfArr=array( array('SG Flag','00.0-00.7'), array('Application Mode','01.0-01.7'), array('Ack Option','02.0-02.0'), array('Signaling Type','02.1-02.7'), array('Remote IP','03.0-06.7') ); $statusLabel=array(0=>"Disable",1=>"Enable"); $serverLabel=array(0=>"Client",1=>"Server"); $ackLabel=array(0=>"Allow",1=>"Forbid"); $typeLabel=array(0=>"M2UA",1=>"IUA",2=>"M3UA"); //Get the default value $OBJ_222="OBJ_222"; $defSql = " SELECT initValue FROM paramConf WHERE keyId > 0 AND level_1 = 2 AND level_2 = 9 AND paramType=2"; $defRes = @mysqli_query($pubConn,$defSql); $defRow = @mysqli_fetch_array($defRes); $defaultValue = $defRow[initValue]; //echo "defaultValue=$defaultValue"; if($_SERVER['REQUEST_METHOD'] == "POST") { //echo "instanceNo=$instanceNo,status=$status,server=$server,ack=$ack,typr=$type,ip=$ip"; $status=omc_keep_length($status,"0","2","1"); $server=omc_keep_length($server,"0","2","1"); $ip=omc_keep_length($ip,"0","8","1"); $ip=ipDec2Hex($ip); //echo "instanceNo=$instanceNo,status=$status,server=$server,ack=$ack,typr=$type,ip=$ip"; $totalValue=$status.$server.$ack.$type.$ip; $totalValue="00000000000000"; $totalValue=setBitValue($totalValue,$sgTableConfArr[0][1],$status); $totalValue=setBitValue($totalValue,$sgTableConfArr[1][1],$server); $totalValue=setBitValue($totalValue,$sgTableConfArr[2][1],$ack); //echo "type=$type,{$sgTableConfArr[3][1]},totalValue=$totalValue"; $totalValue=setBitValue($totalValue,$sgTableConfArr[3][1],decbin($type)); $totalValue=setBitValue($totalValue,$sgTableConfArr[4][1],$ip); //echo "type=$type,{$sgTableConfArr[3][1]},totalValue=$totalValue"; //exit; $levelArr=explode('.',$objIdStr); for($j=0;$jlevelArr[$j]={$levelArr[$j]}"; } $updSql="UPDATE OBJ_222.param_99 SET initValue = '$totalValue' WHERE level_1='$level_1' AND level_2='$level_2' AND instanceNo='$instanceNo' "; if($DEBUG) echo "updSql=$updSql"; mysqli_query($pubConn,$updSql); echo mysqli_error($pubConn); echo ""; exit(); } //Get the parameter //$value,$instanceNoList,instanceNoCount $levelArr=explode('.',$objIdStr); for($j=0;$jlevelArr[$j]={$levelArr[$j]}"; } if($instanceNo == 'new') { $value=$defaultValue; } else { $getSql="SELECT initValue FROM OBJ_222.param_99 WHERE level_1='$level_1' AND level_2='$level_2' AND instanceNo='$instanceNo' "; if($DEBUG) echo "getSql=$getSql"; $result =mysqli_query($pubConn,$getSql); echo mysqli_error($pubConn); $rows =mysqli_fetch_array($result); echo mysqli_error($pubConn); $value=$rows[0]; } if($instanceNo == 'new') { $getInstanceSql="SELECT instanceNo FROM OBJ_222.param_99 WHERE level_1='$level_1' AND level_2='$level_2' AND initValue ='$defaultValue'"; if($DEBUG) echo "$getInstanceSql"; $result=mysqli_query($pubConn,$getInstanceSql); echo mysqli_error($pubConn); $instanceNoCount=0; while($row=mysqli_fetch_array($result)) { $instanceNoList[$instanceNoCount++]=$row[instanceNo]; //echo "$row[instanceNo]"; } } $sgStatus=getBitValue($value,$sgTableConfArr[0][1])+0; $sgServer=getBitValue($value,$sgTableConfArr[1][1])+0; $sgACK=getBitValue($value,$sgTableConfArr[2][1])+0; $sgType=bindec(getBitValue($value,$sgTableConfArr[3][1]))+0; $sgIP=getBitValue($value,$sgTableConfArr[4][1]); $sgIP=ipHex2Dec($sgIP); if($DEBUG) echo "instanceNo=$instanceNo,status=$sgStatus,server=$sgServer,ack=$sgACK,type=$sgType,ip=$sgIP"; //show the page echo ""; echo ""; echo ""; echo "NameValue"; //instanceNo echo ""; if($instanceNo == 'new') { echo "No."; echo ""; for($i=0;$i<$instanceNoCount;$i++) { echo "{$instanceNoList[$i]}"; } echo ""; } else { echo "No."; echo "$instanceNo"; echo ""; } echo ""; //SG Flag echo ""; echo "SG Flag"; echo ""; echo ""; for($i=0;$i{$statusLabel[$i]}"; else echo "{$statusLabel[$i]}"; } echo ""; echo ""; echo ""; //server echo ""; echo "Application Mode"; echo ""; echo ""; for($i=0;$i{$serverLabel[$i]}"; else echo "{$serverLabel[$i]}"; } //ACK echo ""; echo "Ack Option"; echo ""; echo ""; for($i=0;$i{$ackLabel[$i]}"; else echo "{$ackLabel[$i]}"; } //Signaling Type echo ""; echo "Signaling Type"; echo ""; echo ""; for($i=0;$i{$typeLabel[$i]}"; else echo "{$typeLabel[$i]}"; } echo ""; //ip echo ""; echo "Remote IP"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "\n "; echo "\n "; if($instanceNo != 'new') { echo "\n "; } echo "\n "; echo "\n "; echo ""; echo ""; //function define function ipHex2Dec($ipHex) { $ipDec=""; for($i=0;$i<4;$i++) { $temp=substr($ipHex,$i*2,2); $temp=hexdec($temp); $ipDec.=$temp."."; } $ipDec=substr($ipDec,0,strlen($ipDec)-1); return $ipDec; } function ipDec2Hex($ipDec) { $ipHex=""; $unit=explode(".",$ipDec); for($i=0;$i<4;$i++) { $temp=dechex($unit[$i]); $temp=omc_keep_length($temp,"0","2","1"); $ipHex.=$temp; } return strtoupper($ipHex); } ?>