diff options
Diffstat (limited to 'lib/mysql.php')
-rw-r--r-- | lib/mysql.php | 13 |
1 files changed, 11 insertions, 2 deletions
diff --git a/lib/mysql.php b/lib/mysql.php index 60bfa3a..6d575ad 100644 --- a/lib/mysql.php +++ b/lib/mysql.php @@ -20,9 +20,18 @@ function mysql_run_query($query) { } function show_warning_on_offline_slave() { - $result = mysql_run_query("SHOW STATUS LIKE \"Slave_running\""); + $result = mysql_run_query( + "SHOW STATUS LIKE \"Slave_running\"" + ); if (($result -> num_rows == 0) || ($result -> fetch_assoc() ["Value"] != "ON")) { - print "<div><font color=\"ff0000\">The replication slave is currently not running. The database might be outdated.</font></div>\n"; + $result = mysql_run_query( + "SELECT 1 FROM `ssh_log`" . + " WHERE ADDTIME(`ssh_log`.`date`,\"1:00\")>NOW()" . + " LIMIT 1" + ); + if ($result -> num_rows == 0) { + print "<div><font color=\"ff0000\">The replication slave is currently not running. The database might be outdated.</font></div>\n"; + } } } |