if (empty($u)) return;
$this->u = $u;
$this->p = $p;
- if (is_numeric($u)) {
+ if ((string)intval($u)===(string)$u) {
$this->id = $u;
$opt = sprintf(" Username = '%s' OR UserId = '%s'", mysql_escape_string($u), mysql_escape_string($u));
} else {
is_null($name) || $arr['Name'] = $name;
is_null($email) || $arr['Email'] = $email;
$upd = buildSQLSet($arr);
- $sql = sprintf("UPDATE User %s WHERE UserId = '%s'",
+ $sql = sprintf("UPDATE User SET %s WHERE UserId = '%s'",
$upd, mysql_escape_string($this->getUserId()));
if (!empty($upd) && $upd != 'SET')
DBUpdate($sql);
function isOverQuota() {
return $this->exists()?($this->info['bOverQuota']>0?true:false):'';
}
+ function getDBQuotaHard() {
+ return $this->exists()?$this->info['nDatabasesHard']:0;
+ }
function getBytes() {
if($this->exists()) {
$arr['nBytes'] = $this->info['nBytes'];
}
function setPassword($pwd) {
$arr['Password'] = base64_encode($pwd);
- $sql = sprintf("UPDATE User %s WHERE UserId = '%s'",
+ $sql = sprintf("UPDATE User SET %s WHERE UserId = '%s'",
buildSQLSet($arr), mysql_escape_string($this->getUserId()));
DBUpdate($sql);
$sql = sprintf('SET PASSWORD FOR \'%s\'@\'%%\'=PASSWORD(\'%s\')',
$arr['Password'] = base64_encode($pwd);
$arr['bEnabled'] = 1;
$arr['dSignup'] = 'NOW()';
- $sql = sprintf("UPDATE User %s WHERE UserId = '%s'",
+ $sql = sprintf("UPDATE User SET %s WHERE UserId = '%s'",
buildSQLSet($arr), mysql_escape_string($this->getUserId()));
DBUpdate($sql);
} else {
return false;
}
- $sql = sprintf("UPDATE DB %s WHERE DB.DatabaseId = '%s'",
+ $sql = sprintf("UPDATE DB SET %s WHERE DB.DatabaseId = '%s'",
buildSQLSet($arr),
$DBId);
DBUpdate($sql);
DBCreate(sprintf('DROP DATABASE `%s`', mysql_escape_string($dbname)));
$arr['bEnabled'] = 0;
- $sql = sprintf("UPDATE DB %s WHERE DB.Name = '%s'",
+ $sql = sprintf("UPDATE DB SET %s WHERE DB.Name = '%s'",
buildSQLSet($arr),
$dbname);
DBUpdate($sql);