X-Git-Url: http://andersk.mit.edu/gitweb/sql-web.git/blobdiff_plain/9c70b48184fc9dc34b9725daa6b3b050fd49e6d0..9840d1021689621de69674389a2a15ac10183d02:/lib/dbaccess.lib.php

diff --git a/lib/dbaccess.lib.php b/lib/dbaccess.lib.php
index d58bef8..a3211a1 100644
--- a/lib/dbaccess.lib.php
+++ b/lib/dbaccess.lib.php
@@ -75,6 +75,16 @@ function checkQuotas($userId=null) {
 				), dLastCheck = NOW()";
 	if (!empty($userId)) $sql .= sprintf(" WHERE UserId = '%s'", mysql_escape_string($userId));
 	DBUpdate($sql);
+	$sql = "UPDATE UserStat SET nDatabases = (
+				SELECT COUNT(*)
+				FROM DB
+				INNER JOIN DBOwner ON DBOwner.DatabaseId = DB.DatabaseId
+				WHERE DBOwner.UserId = UserStat.UserId
+				  AND DB.bEnabled=1
+				GROUP BY UserId
+				), dLastCheck = NOW()";
+	if (!empty($userId)) $sql .= sprintf(" WHERE UserId = '%s'", mysql_escape_string($userId));
+	DBUpdate($sql);
 }
 
 ?>