<?php
#phpinfo();
//Requires
require_once 'WebTool.php';
$wt = new WebTool('test');
$wt->loadDBCredentials();
echo "Hallo";
#print_r($wt->metap);
foreach ($wt->metap as $db => $row) {
$slice = $row["slice"];
if ($db == "centralauth") {
continue;
}
# if ( in_array( $db, array("bgwiki","afwiki","abwiki","acewiki","amwiki", "angwiki") ) || $db == "commonswiki" ) { continue; }
$queries[$slice][] = "\n\t\t\t(SELECT rev_timestamp, '{$db}' as wiki, page_namespace, page_title, rev_id\n\t\t\tFROM {$db}_p.revision_userindex\n\t\t\tJOIN {$db}_p.page on page_id = rev_page\n\t\t\twhere rev_user_text = 'Hedonil' AND rev_timestamp > '20140628210110'\n\t\t\tLimit 10)\n\t";
}
# print_r($queries);
foreach ($queries as $slice => $slarr) {
$stime = microtime(true);
$dbr = new Database2($slice, $dbUser, $dbPwd, '');
$dur = number_format(microtime(true) - $stime, 3);
$query = implode(" UNION ", $slarr);
echo $query;
$res = $dbr->query($query);
$anz = count($res);
echo "{$slice} --- {$db} --- {$anz} --- {$dur} <br/>\n";
$dbr->close();
}
