stripped dbaccess

[sql-web.git] / lib / dbaccess.lib.php

<?php
/*
	(c) 2005 Joe Presbrey
*/

require_once('joe/util.lib.php');
require_once('joe/mysql.lib.php');

function checkQuotas($userId=null) {
	if (empty($userId)) {
		$sql = 'SELECT DatabaseId,Name FROM DB WHERE bEnabled=1';
	} else {
		if (is_array($userId)) {
			$sql_userId = sprintf("UserId IN ('%s')", implode("','",array_map('mysql_escape_string',$userId)));
		} elseif (is_numeric($userId)) {
			$sql_userId = sprintf("UserId = '%s'", mysql_escape_string($userId));
		} else {
			die('userId parameter error in checkQuotas');
		}
		$sql = sprintf("SELECT DB.DatabaseId,Name FROM DB INNER JOIN DBOwner ON DB.DatabaseId = DBOwner.DatabaseId WHERE bEnabled=1 AND %s", $sql_userId);
	}
	$databases = fetchRows(DBSelect($sql),'Name');
	foreach($databases as $db) {
		$DBId = $db['DatabaseId'];
		$arr['dLastCheck'] = 'NOW()';
		$arr['nBytes'] = calcDBSize($db['Name']);
		$sql = sprintf("UPDATE DB SET %s WHERE DatabaseId = '%s'",
						buildSQLSet($arr),
						mysql_escape_string($DBId));
		DBUpdate($sql);
	}
	$sql = "UPDATE UserStat SET nBytes = (
				SELECT SUM(nBytes)
				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 .= " WHERE $sql_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 .= " WHERE $sql_userId";
	DBUpdate($sql);
}

?>