<?php

include("autoload.inc");

$link = Database::connectLocal();

$digits = explode(",",$_SERVER['argv'][1]);

print_r($digits);

$result = $link->query("SHOW TABLES in pluginlongterm");

while ($row = $result->fetchObject()) {
	$table = $row->Tables_in_pluginlongterm;

	$filename = "/data/mysql/pluginlongterm/$table.MYI";


	if (!file_exists($filename) || !is_link($filename)) continue;

	$target = readlink($filename);
	if (file_exists($target)) continue;

	if (!preg_match('#d(\d+)#',$table,$device)) continue;

	$digit = $device[1][1];
	var_dump($digit);
	if (!in_array($digit,$digits)) continue;

	echo "fixing table $table\n";
	$link->query("REPAIR TABLE pluginlongterm.$table USE_FRM");

	if ($link->error()) exit($link->error());
}