0 and Time>0" . (isset($perBssid)? " AND Bssid=$perBssid":"") . (isset($perCellid)? " AND Cellid=$perCellid":"") . (isset($perStartPeriod)? " AND Time>='$perStartPeriod'":"") . (isset($perEndPeriod)? " AND Time<='$perEndPeriod'":""); echo $sqlstring . "
"; $result = mysql_query($sqlstring,$db) or die("Invalid query: $sqlstring\n" . mysqli_error($pubConn)); list($no_of_records) = mysqli_fetch_row($result); mysql_free_result($result); if (!isset($offset)) { $offset = 0; } echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; echo "\n"; //echo "

\n"; echo ${$parameter}[total] . ": " .$no_of_records . " " . ${$parameter}[pages]; echo "

\n"; echo "$stepsize " . ${$parameter}[record] . "/" . ${$parameter}[pages]; echo "

\n"; if ($no_of_records) echo (floor($offset/$stepsize) + 1) . "/" . (ceil($no_of_records/$stepsize)) . " " . ${$parameter}[pages]; else echo "0/0 " . ${$parameter}[pages]; echo "

\n"; echo ""; echo " "; echo "{${$parameter}[pages]}   "; //echo $offset . "-" . $stepsize; if ($offset > $stepsize-1) { //if ($offset < $stepsize) $offset=0; echo ""; } else { echo ""; } //echo $offset . "-" . $stepsize; if ($no_of_records > $offset + $stepsize) { echo ""; } else { echo ""; } echo "

\n"; echo "\n"; echo "\n"; $sqlstring = "select ${language}DisplayName,FieldName,${language}Remarks " . "from OMCR_Meta_Statistics"; //echo "$sqlstring
"; $result = mysql_query($sqlstring,$db) or die("Invalid query: $sqlstring\n" . mysqli_error($pubConn)); echo "\n"; echo ""; echo ""; echo ""; while ( $row = mysqli_fetch_row($result) ) { $fieldname[] = $row[1]; echo "\n"; } echo "\n"; mysql_free_result($result); $sqlstring = "select Bssid,Cellid,Time," . join(",",$fieldname) . " from OMCR_GeneralReport where Cellid>0 and Time>0" . (isset($perBssid)? " AND Bssid=$perBssid":"") . (isset($perCellid)? " AND Cellid=$perCellid":"") . (isset($perStartPeriod)? " AND Time>='$perStartPeriod'":"") . (isset($perEndPeriod)? " AND Time<='$perEndPeriod'":""); if ($offset >= 0) { $sqlstring .= " ORDER BY Time DESC LIMIT $offset,$stepsize"; } else { $sqlstring .= " ORDER BY Time DESC LIMIT 0," . ($stepsize+$offset); } //echo $sqlstring . "
"; $result = mysql_query($sqlstring,$db) or die("Invalid query: $sqlstring\n" . mysqli_error($pubConn)); $no_of_fields = mysql_num_fields($result); while ( $row = mysqli_fetch_row($result) ) { echo ""; for ($i=0;$i<$no_of_fields;$i++) { printf("\n",(isset($row[$i])? $row[$i]:"-")); } echo "\n"; } echo "

{${$parameter}[bssid]}	{${$parameter}[cellidentity]}	{${$parameter}[time]}	"; echo "$row[0]"; echo "
%s

\n"; if (mysqli_num_rows($result) == 0) echo "
{${$parameter}[norecord]}
"; echo "\n"; echo "\n"; echo "\n"; echo "

\n"; mysql_free_result($result); ?>