contact: page formatting

[sql-web.git] / cron / checkProcesses.php

diff --git a/cron/checkProcesses.php b/cron/checkProcesses.php
index f04c5a5527d4e080dd3242904693c8c6faa9d644..a34d17bc58fa1551514a858a3a6ab5a9cfff3dd7 100755 (executable)
--- a/cron/checkProcesses.php
+++ b/cron/checkProcesses.php
@@ -21,7 +21,6 @@ foreach($bad as $badproc) {
        $baddb = mysql_escape_string($badproc['db']);
        $badtime = $badproc['Time'];
        $badquery = $badproc['Info'];
-       mysql_query('KILL '.$badproc['Id']);
        if (empty($baddb)) continue;
        $sql = "SELECT User.UserId,User.Name,User.Email
                        FROM `User`
@@ -33,6 +32,7 @@ foreach($bad as $badproc) {
                $mailtos[] = $addy['Email'];
                $mailnames[] = $addy['Name'];
        }
+       if (empty($mailtos)) continue;
        $mailto = implode(', ',$mailtos);
        $mailname = implode(', ',$mailnames);
        $mailsubj = "[sql] Slow Query on $baddb";
@@ -52,6 +52,7 @@ This SQL Service is available at sql.mit.edu.
 
 $badquery";
 
+       mysql_query('KILL '.$badproc['Id']);
        mail($mailto,$mailsubj,$mailbody,"From: SQL Service <sql@mit.edu>\r\nBcc: sql@mit.edu\r\n");
 }