public function save() { $query = "INSERT INTO " . self::TABLE_NAME . " (setting_id, value) VALUES (?, ?)\n ON DUPLICATE KEY UPDATE value = ?"; return DBCore::doUpdateQuery($query, "sss", array($this->id, $this->value, $this->value)); }
/** * Updates users avatar image file path in the DB. * * @param string $newAvatarFileName New filename. * * @return boolean Success flag. */ public function updateAvatar($newAvatarFileName) { $currentAvatarFileName = $this->avatar; if (!empty($currentAvatarFileName) && file_exists(Config::DIR_AVATARS . $currentAvatarFileName)) { unlink(Config::DIR_AVATARS . $currentAvatarFileName); } if (file_exists(Config::DIR_AVATARS . $newAvatarFileName)) { $query = "UPDATE " . self::TABLE_NAME . " SET avatar = ?" . " WHERE " . self::ID_FIELD_NAME . " = ?"; if (DBCore::doUpdateQuery($query, "si", array($newAvatarFileName, $this->id))) { $this->avatar = $newAvatarFileName; return true; } else { return false; } } else { return false; } }
/** * Saves removement flag to the database. * * @return integer Returns the number of affected rows on success, and -1 if * the last query failed. */ public function saveRemovementFlag() { $this->changeUpdateTime(); return DBCore::doUpdateQuery("UPDATE " . static::TABLE_NAME . "\n SET removed = ?,\n update_time = ?,\n update_user_id = ?\n WHERE " . static::ID_FIELD_NAME . " = ?\n LIMIT 1", "isii", array($this->removed, $this->updateTime, $this->updateUserId, $this->id)); }