$query = $req->GetQueryString($props);
echo "<a href=\"services/getdata.php?$query\">" . $title . "</a>";
}
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"]
);'));
?>
<br/><form id="postfix_form" action="index.php?page=do.php" method="post">
<input type="hidden" name="action" id="action_input"/>
<input type="submit" value="<?echo translate("Drop Selected");?> " onClick="javascript:doDrop()"/>
<input type="submit" value="<?echo translate("Resize Selected");?> " onClick="javascript:doRewidth()"/>
<?
function sumarize_info(&$sum, &$info) {
if (is_numeric($info['first'])) {
if (($sum['first'] === false)||($sum['first'] > $info['first'])) {
$sum['first'] = $info['first'];
case "cache":
try {
$req = new GROUPRequest();
$fix_time = $req->GetTimeFormat();
$multi_mode = false;
} catch (ADEIException $ae) {
if ($_GET['db_server'] || $_GET['db_name'] || $_GET['db_group']) {
throw $ae;
}
$multi_mode = true;
}
try {
$cache = new CACHEDB();
$flags = REQUEST::NEED_ITEMINFO | REQUEST::NEED_INFO | CACHE::TABLE_INFO;
if ($multi_mode) {
$info = $cache->GetCacheList($flags);
} else {
$info = array();
$postfix = $cache->GetCachePostfix($req->props['db_group'], $req->props['db_name'], $req->props['db_server']);
$info[0] = $cache->GetExtendedCacheInfo($postfix, $flags);
}
} catch (ADEIException $ex) {
$ex->logInfo(NULL, $req);
$error = xml_escape($ex->getInfo());
}
break;
case "log":
try {
$cur = time();
$interval = $_REQUEST['interval'];
$filter = json_decode(stripslashes($_REQUEST['filter']), true);
<?php
require "../adei.php";
$c = new CACHEDB();
$c->CreateStoredProcedures();
$list = $c->GetCacheList(REQUEST::NEED_ITEMINFO);
foreach ($list as &$info) {
$table = "cache0{$info['postfix']}";
$subseconds = $info['info']['ns'];
echo $table . " - ";
try {
$query = "ALTER TABLE `{$table}` ADD `id` BIGINT NOT NULL FIRST";
$c->Query($query);
if ($subseconds) {
$query = "UPDATE `{$table}` SET id = UNIX_TIMESTAMP(`time`)*1000000000+`ns`";
} else {
$query = "UPDATE `{$table}` SET id = UNIX_TIMESTAMP(`time`)*1000000000";
}
$c->Query($query);
$query = "ALTER TABLE `{$table}` ADD UNIQUE KEY (id)";
$c->Query($query);
# if ($subseconds) {
# $query = "CREATE TRIGGER cache0_id BEFORE INSERT ON `$table` FOR EACH ROW SET NEW.id = UNIX_TIMESTAMP(NEW.time)*1000000000+NEW.ns";
# } else {
# $query = "CREATE TRIGGER cache0_id BEFORE INSERT ON `$table` FOR EACH ROW SET NEW.id = UNIX_TIMESTAMP(NEW.time)*1000000000";
# }
# $c->Query($query);
$done = true;
} catch (ADEIException $ae) {
$done = false;
$error = $ae->getMessage();
