more old code

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

diff --git a/cron/checkProcesses.php b/cron/checkProcesses.php
index 67d3a2c012a0df3facb46a63e2af115185b85f54..5d1e5257d0d500858722e84b87988d73633c0f24 100755 (executable)
--- a/cron/checkProcesses.php
+++ b/cron/checkProcesses.php
@@ -5,7 +5,7 @@ require_once('mitsql.cfg.php');
 require_once('mitsql.lib.php');
 isOffline() && exit;
 
-define('MAX_PROC_TIME', 30);
+define('MAX_PROC_TIME', 100);
 
 $baddbs = $badusers = $bad = array();
 $result = mysql_query('SHOW FULL PROCESSLIST');
@@ -19,6 +19,8 @@ while ($row = mysql_fetch_assoc($result)){
 mysql_free_result($result);
 
 foreach($bad as $badproc) {
+       mysql_query('KILL '.$badproc['Id']);
+    continue;
        $mailtos = $mailnames = array();
        $baddb = mysql_escape_string($badproc['db']);
        if (empty($baddb)) continue;
@@ -61,7 +63,8 @@ Web: http://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");
+       #mail($mailto,$mailsubj,$mailbody,"From: SQL Service <sql@mit.edu>\r\nBcc: sql@mit.edu\r\n");
+    echo $mailbody;
 }
 
 ?>