<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 = "check table {$table};";
    $result = mysql_query($query, $link);
    if($result) {
      $row = mysql_fetch_array($result);
      if($row['Msg_text']!=='OK') {
        print_r($row);
        echo "<br /><br />";
        $errors++;
      }
    }
  }

}

if(!$errors) {
  echo "<h1>VSETKO JE OK!!!</h1>";
}

mysql_close($link);
?>