"; echo ""; echo ""; echo "$strMaintenance > Control Panel > Welcome SMS
"; echo ""; echo ""; $helpId="5.2.3"; showHelp($helpId); echo ""; echo ""; echo ""; adjust_title_tail(); adjust_content_head(); echo "
"; ?> "; //delete from the wsmsServConf $pubDb="OMC_PUB"; $delSql = "DELETE FROM wsmsServConf WHERE mcc='$mcc' and mnc='$mnc' "; //echo "
delSql=$delSql"; $delRes = @mysqli_query($pubConn,$delSql); echo mysqli_error($pubConn); //delete from wsmsMsgConf $delSql = "DELETE FROM wsmsMsgConf WHERE mcc='$mcc' and mnc='$mnc' "; //echo "
delSql=$delSql"; $delRes = @mysqli_query($pubConn,$delSql); echo mysqli_error($pubConn); echo "Delete successfully!
"; } //Get the hpmn server info from database $database="OMC_PUB"; $selSql = "SELECT * FROM wsmsServConf "; $selRes = @mysqli_query($pubConn,$selSql); $HpmnCount=mysqli_num_rows($selRes); echo mysqli_error($pubConn); //echo "count:$HpmnCount
"; $HpmnIndex=0; while($selRow = @mysqli_fetch_array($selRes)) { $HpmnMcc[$HpmnIndex]=$selRow[mcc]; $HpmnMnc[$HpmnIndex]=$selRow[mnc]; $HpmnFlag[$HpmnIndex]=$selRow[flag]; $HpmnSmsEncode[$HpmnIndex]=$selRow[smsEncode]; $HpmnWelcomeMsg[$HpmnIndex]=$selRow[welcomeMsg]; if($HpmnSmsEncode[$HpmnIndex]==2) $HpmnWelcomeMsg[$HpmnIndex]=unicode2gb($HpmnWelcomeMsg[$HpmnIndex]); $HpmnIndex++; //echo "HpmnMcc[$HpmnIndex]={$HpmnMcc[$HpmnIndex]}
"; } echo "

"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $flagLabel=array(0=>"Disable",1=>"Enable"); $encodeSchemeLabel=array(0=>"7 bit",1=>"8 bit",2=>"16 bit"); for($i=0;$i<$HpmnCount;$i++) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $tmpWl=$HpmnWelcomeMsg[$i]; $maxLen=70; if($HpmnSmsEncode[$i]==2) $maxLen=$maxLen*3; if(strlen($HpmnWelcomeMsg[$i])>$maxLen) $tmpWl=substr($HpmnWelcomeMsg[$i],0,$maxLen)."..."; $cc=strlen($HpmnWelcomeMsg[$i]); echo ""; //echo ""; $select="SELECT * FROM wsmsMsgConf where mcc={$HpmnMcc[$i]} and mnc={$HpmnMnc[$i]} order by no ASC "; $select_res = @mysqli_query($pubConn,$select); echo ""; echo ""; echo ""; } echo ""; echo "
No.MCCMNCFlagEncodeWelcome MessageAD MessageDelete
$i{$HpmnMcc[$i]}{$HpmnMnc[$i]}{$flagLabel[$HpmnFlag[$i]]}{$encodeSchemeLabel[$HpmnSmsEncode[$i]]}$tmpWl
{$HpmnAdContent[$i]}
|"; $id=1; while($select_row= @mysqli_fetch_array($select_res)) { $adno=$select_row[no]; $content=$select_row[content]; if($HpmnSmsEncode[$i]==2) $content=unicode2gb($content); echo "$id|"; $id++; } //The max ad count is 8 if($id<=8) echo "New
Delete
New--------------
"; adjust_content_tail(); ?>