From 07e7fa78cd0a0483e7c88bd240d0ae06870a8d6c Mon Sep 17 00:00:00 2001
From: Joe Presbrey <presbrey@mit.edu>
Date: Thu, 25 Sep 2008 13:57:09 +0000
Subject: [PATCH] more old code

git-svn-id: svn://presbrey.mit.edu/sql/web/main@164 a142d4bd-2cfb-0310-9673-cb33a7e74f58
---
 contrib/deleteuser.sql  | 4 +++-
 cron/checkProcesses.php | 7 +++++--
 2 files changed, 8 insertions(+), 3 deletions(-)

diff --git a/contrib/deleteuser.sql b/contrib/deleteuser.sql
index c208ad8..ed550d4 100644
--- 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 67d3a2c..5d1e525 100755
--- 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;
 }
 
 ?>
-- 
2.45.0