GetQueryString($props); echo "" . $title . ""; } try { $req = new SOURCERequest(); } catch (ADEIException $e) { $req = new REQUEST(); $nodata = 1; } */ $flags = REQUEST::NEED_ITEMINFO|REQUEST::NEED_INFO|CACHE::TABLE_INFO|CACHE::NEED_REQUESTS|CACHE::FIND_BROKEN; $cache = new CACHEDB(); $list = $cache->GetCacheList($flags); usort($list, create_function('$a,$b', 'return strcasecmp( $a["db_server"] . "__" . $a["db_name"] . "__" . $a["db_group"], $b["db_server"] . "__" . $b["db_name"] . "__" . $b["db_group"] );')); ?>
" onClick="javascript:doDrop()"/> " onClick="javascript:doRewidth()"/> $info['first'])) { $sum['first'] = $info['first']; } } if (is_numeric($info['last'])) { if (($sum['last'] === false)||($sum['last'] < $info['last'])) { $sum['last'] = $info['last']; } } if (is_numeric($info['dbsize'])) { $sum['dbsize'] += $info['dbsize']; } } if ((isset($_GET['source_info']))||(isset($_GET['filter']))) { $sources = array(); $source_info = array( 'tables' => array(), 'groups' => array(), 'first' => false, 'last' => false, 'dbsize' => 0 ); $servers = array(); $server_info = array( 'tables' => array(), 'databases' => array(), 'groups' => array(), 'first' => false, 'last' => false, 'dbsize' => 0 ); $unknown = array( 'tables' => array(), 'databases' => array(), 'groups' => array(), 'first' => false, 'last' => false, 'dbsize' => 0 ); $groups = array(); foreach ($list as $id => &$info) { if ((!isset($info['db_server']))||(!isset($info['db_name']))||(!isset($info['db_group']))) { array_push($unknown['tables'], $info['postfix']); sumarize_info($unknown, $info['info']); } else { $server = $info['db_server']; $source = $info['db_server'] . "__" . $info['db_name']; $group = $info['db_server'] . "__" . $info['db_name'] . "__" . $info['db_group']; if (!isset($sources[$source])) $sources[$source] = $source_info; if (!isset($servers[$server])) $servers[$server] = $server_info; array_push($servers[$server]['databases'], $source); array_push($sources[$source]['tables'], $info['postfix']); array_push($sources[$source]['groups'], $group); $groups[$group] = $id; sumarize_info($sources[$source], $info['info']); } } foreach ($servers as $server => &$srv) { $srv['databases'] = array_unique($srv['databases']); foreach ($srv['databases'] as $db) { array_splice($servers[$server]['groups'], -1, 0, $sources[$db]['groups']); array_splice($servers[$server]['tables'], -1, 0, $sources[$db]['tables']); sumarize_info($servers[$server], $sources[$db]); } } if ($unknown['tables']) { $servers['_unknown_'] = &$unknown; } if (isset($_GET['filter'])) { $filter = $_GET['filter']; $pos = strpos($filter, "__"); if ($pos === false) { $filter_server = $filter; $filter_source = false; $tables = &$servers[$filter]['tables']; } else { $filter_server = substr($filter, 0, $pos); $filter_source = $filter; $tables = &$sources[$filter]['tables']; } } else { $filter_server = false; $filter_source = false; } if (isset($_GET['source_info'])) { foreach ($servers as $server => &$srv) { if (isset($_GET['group_info'])&&(($filter_server === false)||($filter_server == $server))) $show_mark = true; else $show_mark = false; do { $grp0 = $groups[$srv['groups'][$i++]]; } while ((is_numeric($grp0))&&(!$list[$grp0]['req'])); ?>
>

Server: (', 1)">Mark,', 0)">Unmark)

"; } echo translate("First record: %s", date("r", $srv['first'])) . "
"; echo translate("Last record: %s", date("r", $srv['last'])) . "
"; echo translate("Database Size: %s", dsPrintSize($srv['dbsize'])); if ($srv['databases']) echo "

Databases:
"; else echo ", " . translate("%u groups", sizeof($srv['tables'])) . "
"; foreach ($srv['databases'] as $source) { $db = &$sources[$source]; echo "" . substr(strstr($source, "__"),2) . ": "; echo translate("%u groups", sizeof($db['groups'])) . ", "; echo dsPrintSize($db['dbsize']) . ", "; echo date("r", $db['first']) . " - " . date("r", $db['last']); if (($show_mark)&&(($filter_source === false)||($filter_source == $source))) { ?>(', 1)">Mark,', 0)">Unmark)"; }?>

Tables: cache* ()

"; if ($info['incomplete']) { echo translate("Status") . ": " . translate("Broken") ."" . "
"; } if ($info['req']) { echo translate("Active: yes") . "
"; if ($info['disconnected']) { echo translate("Mode: disconnected") . "
"; } } else if ($info['disconnected']) { echo translate("Active: unknown"); echo " (" . translate("The data source is disconnected at the moment") . ")"; echo "
"; } else { echo translate("Active: no"); if (($info['server'])&&($info['database'])&&($info['group'])) { // strange should not be } else if (($info['server'])&&($info['database'])) { echo " (" . translate("The loggroup is not present any more") . ")"; } else if ($info['server']) { echo " (" . translate("The database is not present any more") . ")"; } else { echo " (" . translate("The data source is not present in active configuration") . ")"; } echo "
"; } if ($info['reader']) { echo translate("Reader: %s", $info['reader']) . "
"; } if ($info['server']) { echo translate("Server: %s", $info['server']) . "
"; } if ($info['database']) { echo translate("Database: %s", $info['database']) . "
"; } if ($info['group']) { echo translate("LogGroup: %s", $info['group']) . "
"; } echo "
"; if ($info['info']['dbsize']) { echo translate("Database Size: %s", dsPrintSize($info['info']['dbsize'])) . "
"; } if ($info['info']['records']) { echo translate("Number of records: %s", $info['info']['records']) . "
"; } if ($info['info']['width']) { echo translate("Number of items: %s", $info['info']['width']); if (is_array($info['info']['items'])) { $reader_width = sizeof($info['info']['items']); if (($reader_width)&&($reader_width != $info['info']['width'])) { echo " (CACHE), $reader_width (READER)"; echo " [ " . translate("Resize") . " ]"; } } echo "
"; } if ($info['info']['outdated']) { echo translate("Table version: outdated, needs update") . "
"; } if (isset($info['info']['ns'])) { if ($info['info']['ns']) { echo translate("Subsecond precision: yes") . "
"; } else { echo translate("Subsecond precision: no") . "
"; } } if (($info['info']['first'])&&($info['info']['last'])) { echo translate("First record: %s", date("r", $info['info']['first'])) . "
"; echo translate("Last record: %s", date("r", $info['info']['last'])) . "
"; } if ($info['info']['tables']) { echo translate("Resolutions:"); foreach (array_keys($info['info']['tables']) as $res) { echo " $res"; } echo "
"; if (isset($_GET['table_info'])) { echo "
"; echo translate("Extended Table Info:") . "
"; foreach ($info['info']['tables'] as $res => $tblinfo) { $output = false; echo ""; } echo "
 " . sprintf("% 5u", $res) . ":"; if ($tblinfo['dbsize']) { if ($output) echo ", "; else $output = true; echo dsPrintSize($tblinfo['dbsize']); } if ($tblinfo['records']) { if ($output) echo ", "; else $output = true; echo translate("%s records", $tblinfo['records']); } if (($tblinfo['first'])&&($tblinfo['last'])) { if ($output) echo ", "; else $output = true; echo date("c", $tblinfo['first']) . ' - ' . date("c", $tblinfo['last']+$res); $output = true; } echo "
"; } if ((isset($_GET['item_info']))&&(is_array($info['info']['items']))) { echo "
"; echo translate("Extended Item Info:") . "
"; foreach ($info['info']['items'] as $id => $iinfo) { echo ""; } echo "
 " . sprintf("% 3u", $id) . ":"; echo $iinfo['name']; echo "
"; } } // print_r($info); ?>

"; ?>