\n"; echo "\n"; exit(); } /************************************************ * Retrieve the Bts Manager ID from object ID * AdjHand.11.0.12 --substr--> 11.0.12 --> 11 ************************************************/ $btsmgrid = substr($objectid,8); if ($btsmgrid[1] == '.') { $btsmgrid=substr($btsmgrid,0,1); } else if ($btsmgrid[2] == '.') { $btsmgrid=substr($btsmgrid,0,2); } else { echo strlen($objectid) . ":Error Object ID:" . $objectid . "\n"; return 0; } include("adjhand.inc"); include("login_parm.inc"); $db = mysql_connect($hostname, $username, $password); mysql_select_db($dbname,$db); echo "=)AdjHand.$btsmgrid.0.*"; echo "

---

\n"; if (!isset($modified_data)) { /************************************************ * Step 1: Display the present neighbor list ************************************************/ /************************************************ * Generate the Neighbor cell list from SQL DB ************************************************/ $sqlstring = "select Label,CellGlobalIdentityLaiMcc,CellGlobalIdentityLaiMnc," . "LocationAreaCodes,CellGlobalIdentityCi,BcchFrequency,BsIdentityCode," . "NeighbourType,ObjectId from OMCR_AdjHand " . "where bssid=$bssid and BcchFrequency<>-1 and CellGlobalIdentityLaiMcc<>0 " . "and CellGlobalIdentityLaiMnc<>0 and CellGlobalIdentityCi<>0 " . "and LocationAreaCodes<>0 and ObjectId LIKE 'AdjHand.$btsmgrid.0.%' " . "ORDER BY (0+SUBSTRING_INDEX(ObjectId,'.',-1))"; //echo $sqlstring . "
"; $result = mysql_query($sqlstring,$db) or die("Invalid query: $sqlstring\n" . mysqli_error($pubConn)); $no_of_fields=mysql_num_fields($result); echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; $num=0; while ( $row = mysqli_fetch_row($result) ) { $num++; echo "\n"; //echo "\n"; echo "\n"; //echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; switch($row[7]) { case 0: echo "\n"; break; case 1: echo "\n"; break; case 2: echo "\n"; break; } echo "\n"; echo "\n"; } if (mysqli_num_rows($result) == 0) { $no_of_fields += 1; echo ""; } echo "

{${$parameter}[cellname]}

{${$parameter}[mcc]}

{${$parameter}[mnc]}

{${$parameter}[lac]}

{${$parameter}[cellid]}

{${$parameter}[bcch]}

{${$parameter}[bsic]}

{${$parameter}[neighbortype]}

{${$parameter}[control]}

$num

" . ($row[0]==''?"-":rawurldecode($row[0])) . "

$row[0]

$row[1]

$row[2]

$row[3]

$row[4]

$row[5]

$row[6]

{${$parameter}[activeonly]}

{${$parameter}[activeidle]}

{${$parameter}[idleonly]}

{${$parameter}[delete]}|" . "{${$parameter}[modify]}

" . ${$parameter}[noneighbor] . "

"; /************************************************ * Find out the next available Adjhand object ID ************************************************/ if (mysqli_num_rows($result)<32) { $sqlstring = "select MIN(0+SUBSTRING_INDEX(ObjectId,'.',-1)) from OMCR_AdjHand where bssid=$bssid and (BcchFrequency=-1 or CellGlobalIdentityLaiMcc=0 or CellGlobalIdentityLaiMnc=0 or CellGlobalIdentityCi=0 or LocationAreaCodes=0) and ObjectId LIKE 'AdjHand.$btsmgrid.0.%'"; //echo $sqlstring . "
"; $result = mysql_query($sqlstring,$db) or die("Invalid query: $sqlstring\n" . mysqli_error($pubConn)); $row = mysqli_fetch_row($result); echo "

---

\n"; echo "

"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "

"; } } ?>