more old code

git-svn-id: svn://presbrey.mit.edu/sql/web/main@164 a142d4bd-2cfb-0310-9673-cb33a7e74f58

diff --git a/contrib/deleteuser.sql b/contrib/deleteuser.sql
index c208ad825dd957534542a6969695aa65f5ffe57f..ed550d48a2c72bad2edc76f5f489181f342e9d45 100644 (file)
--- a/contrib/deleteuser.sql
+++ b/contrib/deleteuser.sql
@@ -1,5 +1,5 @@
 
-SET @NAME=1340;
+SET @NAME=1341;
 
 USE mitsql;
 DELETE FROM DBQuota WHERE DatabaseId IN (SELECT DatabaseId FROM DBOwner WHERE UserId = @NAME);
@@ -9,3 +9,5 @@ DELETE FROM UserGroup WHERE UserId = @NAME;
 DELETE FROM UserQuota WHERE UserId = @NAME;
 DELETE FROM UserStat WHERE UserId = @NAME;
 DELETE FROM `User` WHERE UserId = @NAME;
+
+ALTER TABLE `User` AUTO_INCREMENT =1340;

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;
 }
 
 ?>