0 AND Object_Name='$name[1]'"; if ($debug) echo "$sqlstring
"; else echo "."; $res = mysql_query($sqlstring, $db) or die("Invalid query:$sqlstring\n" . mysqli_error($pubConn)); while ( $row = mysqli_fetch_row($res) ) { list($parameters[],$attribute_type[]) = $row; } mysql_free_result($res); $sqlstring = "SELECT " . join(",",$parameters) . " FROM $tablename WHERE bssid=$bssid AND ObjectId='$objectid'"; } /* * Create NMI Set Command for paramter download */ function create_nmi_command($db,$sqlstring,$parameters,$attribute_type, &$nmicommand,$debug) { if ($debug) echo "$sqlstring
"; else echo "."; $res = mysql_query($sqlstring, $db) or die("Invalid query:$sqlstring\n" . mysqli_error($pubConn)); $value = mysqli_fetch_row($res); mysql_free_result($res); $nmicommand = "set"; for ($i=0;$i"; else echo "."; $retval = send_nmicommand($db,$bssid,"oid BssFunc",$resultcode, $responsecode,$response,$debug); if (($retval != 0) || ($resultcode[0] != 0)) return (-1); flush(); if ($debug) echo "==) set DownLoadInProgress=1" . "
"; else echo "."; $retval = send_nmicommand($db,$bssid,"set DownLoadInProgress=1",$resultcode, $responsecode,$response,$debug); if (($retval != 0) || ($resultcode[0] != 0)) return (-1); flush(); $objectlist = Array( "Card.0.10", "Bsc.0", "AIf.0", "ALinkSet.0.0", "ALink.0.0.0" ); $tablenamelist = Array( "OMCR_ClockMod", "OMCR_Bsc", "OMCR_AIf", "OMCR_ALinkSet", "OMCR_ALink" ); $sqlstring = "SELECT SUBSTRING_INDEX(ObjectId,'.',-1) FROM OMCR_BSSTREE WHERE bssid=$bssid" . " AND Presence=1 AND ObjectId='ALink.0.0.%'" . " AND ObjectId<>'ALink.0.0.0'"; $res = mysql_query($sqlstring, $db) or die("Invalid query: $sqlstring\n" . mysqli_error($pubConn)); while ((list($row) = mysqli_fetch_row($res)) != null) { if ($debug) echo "==) oid ALinkSet.0.0" . "
"; else echo "."; $retval = send_nmicommand($db,$bssid,"oid ALinkSet.0.0",$resultcode, $responsecode,$response,$debug); if (($retval != 0) || ($resultcode[0] != 0)) return (-1); flush(); if ($debug) echo "==) create ALink $row" . "
"; else echo "."; $retval = send_nmicommand($db,$bssid,"create ALink $row",$resultcode, $responsecode,$response,$debug); if (($retval != 0) || ($resultcode[0] != 0)) return (-1); flush(); $objectlist = array_merge($objectlist, Array ( "ALink.0.0.$row")); $tablenamelist = array_merge($tablenamelist, Array("OMCR_ALink")); } $sqlstring = "SELECT SUBSTRING_INDEX(ObjectId,'.',-1) FROM OMCR_BSSTREE WHERE bssid=$bssid" . " AND Presence=1 AND ObjectId REGEXP 'Card.0.[1-8]$'"; $res = mysql_query($sqlstring, $db) or die("Invalid query: $sqlstring\n" . mysqli_error($pubConn)); $e1trmod_id_list = null; while ( $row = mysqli_fetch_row($res) ) { list($e1trmod_id_list[]) = $row; } //echo "==) oid Shelf.0" . "
"; //$retval = send_nmicommand($db,$bssid,"oid Shelf.0",$resultcode, $responsecode,$response,$debug); //if (($retval != 0) || ($resultcode[0] != 0)) // return (-1); //flush(); for ($i=0; $i"; //$retval = send_nmicommand($db,$bssid,"create E1trmod $e1trmod_id_list[$i]",$resultcode, $responsecode,$response,$debug); //if (($retval != 0) || ($resultcode[0] != 0)) // return (-1); //flush(); } for ($i=0; $i"; else echo "."; $retval = send_nmicommand($db,$bssid,"oid $objectid",$resultcode, $responsecode,$response,$debug); if (($retval != 0) || ($resultcode[0] != 0)) return (-1); flush(); create_sql_string_from_meta_table( $db,$bssid,$objectid,$tablename,$sqlstring,$parameters,$attribute_type,$debug); create_nmi_command($db,$sqlstring,$parameters,$attribute_type,$nmicommand,$debug); if ($debug) echo "==) $nmicommand" . "
"; else echo "."; $retval = send_nmicommand($db,$bssid,"$nmicommand",$resultcode, $responsecode,$response,$debug); if (($retval != 0) || ($resultcode[0] != 0)) return (-1); flush(); } /********************************************* * For each BtsMgr, download parameters *********************************************/ $sqlstring = "SELECT SUBSTRING_INDEX(ObjectId,'.',-1) FROM OMCR_BSSTREE WHERE bssid=$bssid AND Presence=1 AND ObjectId Like 'BtsMgr.%'"; if ($debug) echo "$sqlstring
\n"; else echo "."; $res = mysql_query($sqlstring, $db) or die("Invalid query: $sqlstring\n" . mysqli_error($pubConn)); $btsmgr_list=null; while ( $row = mysqli_fetch_row($res) ) { list($btsmgr_list[]) = $row; } mysql_free_result($res); //for ($i=0; $i"; if ($debug) echo "==) oid BssFunc" . "
"; else echo "."; $retval = send_nmicommand($db,$bssid,"oid BssFunc",$resultcode, $responsecode,$response,$debug); if (($retval != 0) || ($resultcode[0] != 0)) return (-1); flush(); if ($debug) echo "==) create BtsMgr $btsid" . "
"; else echo "."; $retval = send_nmicommand($db,$bssid,"create BtsMgr $btsid",$resultcode, $responsecode,$response,$debug); if (($retval != 0) || ($resultcode[0] != 0)) return (-1); flush(); //echo "==) oid BtsMgr_Shelf.$btsid.0" . "
"; //$retval = send_nmicommand($db,$bssid,"oid BtsMgr_Shelf.$btsid.0",$resultcode, $responsecode,$response,$debug); //if (($retval != 0) || ($resultcode[0] != 0)) // return (-1); //flush(); /************************* * Create E1TrMod *************************/ $sqlstring = "SELECT SUBSTRING_INDEX(ObjectId,'.',-1) FROM OMCR_BSSTREE WHERE bssid=$bssid" . " AND Presence=1 AND ObjectId REGEXP 'BtsMgr_Shelf_Card.$btsid.0.[1-8]$'"; $res = mysql_query($sqlstring, $db) or die("Invalid query: $sqlstring\n" . mysqli_error($pubConn)); $card_id_list = null; while ( $row = mysqli_fetch_row($res) ) { list($card_id_list) = $row; } mysql_free_result($res); for ($j=0; $j"; else echo "
."; $retval = send_nmicommand($db,$bssid,"oid BtsMgr_Shelf.$btsid.0",$resultcode, $responsecode,$response,$debug); if (($retval != 0) || ($resultcode[0] != 0)) return (-1); flush(); if ($card_id_list[$j] == 1) { $objectlist = array_merge($objectlist, Array ( "BtsMgr_Shelf_Card_Port.$btsid.0.$card_id_list[$j].0", "BtsMgr_Shelf_Card_Port.$btsid.0.$card_id_list[$j].1") ); $tablenamelist = array_merge($tablenamelist, Array("OMCR_E1port", "OMCR_E1port")); if ($debug) echo "==) create E1trmod $card_id_list[$j]" . "
"; else echo "."; $retval = send_nmicommand($db,$bssid,"create E1trmod $card_id_list[$j]",$resultcode, $responsecode,$response,$debug); } else { $objectlist = array_merge($objectlist, Array ( "Trx.$btsid.0.$card_id_list[$j]", "RCarrier.$btsid.0.$card_id_list[$j]", "TrxCh.$btsid.0.$card_id_list[$j].0", "TrxCh.$btsid.0.$card_id_list[$j].1", "TrxCh.$btsid.0.$card_id_list[$j].2", "TrxCh.$btsid.0.$card_id_list[$j].3", "TrxCh.$btsid.0.$card_id_list[$j].4", "TrxCh.$btsid.0.$card_id_list[$j].5", "TrxCh.$btsid.0.$card_id_list[$j].6", "TrxCh.$btsid.0.$card_id_list[$j].7") ); $tablenamelist = array_merge($tablenamelist, Array ( "OMCR_Trx", "OMCR_RCarrier", "OMCR_TrxCh","OMCR_TrxCh", "OMCR_TrxCh","OMCR_TrxCh", "OMCR_TrxCh","OMCR_TrxCh", "OMCR_TrxCh","OMCR_TrxCh") ); if ($debug) echo "==) create TrxMod $card_id_list[$j]" . "
"; else echo "."; $retval = send_nmicommand($db,$bssid,"create TrxMod $card_id_list[$j]",$resultcode, $responsecode,$response,$debug); } if (($retval != 0) || ($resultcode[0] != 0)) return (-1); flush(); } for ($j=0; $j"; else echo "."; $retval = send_nmicommand($db,$bssid,"oid $objectid",$resultcode, $responsecode,$response,$debug); if (($retval != 0) || ($resultcode[0] != 0)) return (-1); flush(); create_sql_string_from_meta_table( $db,$bssid,$objectid,$tablename,$sqlstring,$parameters,$attribute_type,$debug); create_nmi_command($db,$sqlstring,$parameters,$attribute_type,$nmicommand,$debug); if ($debug) echo "==) $nmicommand" . "
"; else echo "."; $retval = send_nmicommand($db,$bssid,"$nmicommand",$resultcode, $responsecode,$response,$debug); if (($retval != 0) || ($resultcode[0] != 0)) return (-1); flush(); } } if ($debug) echo "==) oid BssFunc" . "
"; else echo "."; $retval = send_nmicommand($db,$bssid,"oid BssFunc",$resultcode, $responsecode,$response,$debug); if (($retval != 0) || ($resultcode[0] != 0)) return -1; flush(); if ($debug) echo "==) set DownLoadInProgress=0" . "
"; else echo "."; $retval = send_nmicommand($db,$bssid,"set DownLoadInProgress=0",$resultcode, $responsecode,$response,$debug); if (($retval != 0) || ($resultcode[0] != 0)) return -1; flush(); return 0; } ?>