<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<?php

$db_server = 'host';
$db_user = 'jmeno';
$db_password = 'heslo';
$dbs = Array (
  'characters',
  'world',
  'realm'
);

$link = mysql_connect($db_server, $db_user, $db_password)
  or die("Nelze se připojit");

$errors = 0;
foreach($dbs as $db_name) {

  if(!mysql_select_db($db_name, $link))
        die('Zvolena databaza neexistuje: '.$db_name);

  $query = "SHOW TABLES;";
  $result = mysql_query($query, $link);
  if(!$result)
        die('Query neuspesna');


  $arr_tables = Array();
  while($row = mysql_fetch_array($result)) {
        $arr_tables[] = $row[0];
  }

  foreach($arr_tables as $table) {
    $query = "repair table {$table};";
    $result = mysql_query($query, $link);
    if($result) {
			echo "<h1>".$table.".. OPRAVENO</h1>";
    }
  }

}


mysql_close($link);
?>