$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();