DELETE FROM [yaf_User] WEHRE [UserName] LIKE '%deletethis%'
Originally Posted by: tha_watcha
This should work, if that is an empty forum.
The Fasted way i would use is using the SQL Server Management Studio and delete the entries all manually in a few seconds.
take a look at the yaf procedure for deleting a yaf user, there are some other Places where you need to delete them
create procedure [{databaseOwner}].[{objectQualifier}user_delete](@UserID int) as
begin
declare @GuestUserID int
declare @UserName nvarchar(255)
declare @GuestCount int
select @UserName = Name from [{databaseOwner}].[{objectQualifier}User] where UserID=@UserID
select top 1
@GuestUserID = a.UserID
from
[{databaseOwner}].[{objectQualifier}User] a
inner join [{databaseOwner}].[{objectQualifier}UserGroup] b on b.UserID = a.UserID
inner join [{databaseOwner}].[{objectQualifier}Group] c on b.GroupID = c.GroupID
where
(c.Flags & 2)<>0
select
@GuestCount = count(1)
from
[{databaseOwner}].[{objectQualifier}UserGroup] a
join [{databaseOwner}].[{objectQualifier}Group] b on b.GroupID=a.GroupID
where
(b.Flags & 2)<>0
if @GuestUserID=@UserID and @GuestCount=1 begin
return
end
update [{databaseOwner}].[{objectQualifier}Message] set UserName=@UserName,UserID=@GuestUserID where UserID=@UserID
update [{databaseOwner}].[{objectQualifier}Topic] set UserName=@UserName,UserID=@GuestUserID where UserID=@UserID
update [{databaseOwner}].[{objectQualifier}Topic] set LastUserName=@UserName,LastUserID=@GuestUserID where LastUserID=@UserID
update [{databaseOwner}].[{objectQualifier}Forum] set LastUserName=@UserName,LastUserID=@GuestUserID where LastUserID=@UserID
delete from [{databaseOwner}].[{objectQualifier}Active] where UserID=@UserID
delete from [{databaseOwner}].[{objectQualifier}EventLog] where UserID=@UserID
delete from [{databaseOwner}].[{objectQualifier}UserPMessage] where UserID=@UserID
delete from [{databaseOwner}].[{objectQualifier}PMessage] where FromUserID=@UserID AND PMessageID NOT IN (select PMessageID FROM [{databaseOwner}].[{objectQualifier}PMessage])
-- Delete all the thanks entries associated with this UserID.
delete from [{databaseOwner}].[{objectQualifier}Thanks] where ThanksFromUserID=@UserID OR ThanksToUserID=@UserID
-- Delete all the FavoriteTopic entries associated with this UserID.
delete from [{databaseOwner}].[{objectQualifier}FavoriteTopic] where UserID=@UserID
-- Delete all the Buddy relations between this user and other users.
delete from [{databaseOwner}].[{objectQualifier}Buddy] where FromUserID=@UserID
delete from [{databaseOwner}].[{objectQualifier}Buddy] where ToUserID=@UserID
-- set messages as from guest so the User can be deleted
update [{databaseOwner}].[{objectQualifier}PMessage] SET FromUserID = @GuestUserID WHERE FromUserID = @UserID
delete from [{databaseOwner}].[{objectQualifier}CheckEmail] where UserID = @UserID
delete from [{databaseOwner}].[{objectQualifier}WatchTopic] where UserID = @UserID
delete from [{databaseOwner}].[{objectQualifier}WatchForum] where UserID = @UserID
delete from [{databaseOwner}].[{objectQualifier}UserGroup] where UserID = @UserID
-- ABOT CHANGED
-- Delete UserForums entries Too
delete from [{databaseOwner}].[{objectQualifier}UserForum] where UserID = @UserID
delete from [{databaseOwner}].[{objectQualifier}IgnoreUser] where UserID = @UserID OR IgnoredUserID = @UserID
--END ABOT CHANGED 09.04.2004
delete from [{databaseOwner}].[{objectQualifier}User] where UserID = @UserID
end
GO
Originally Posted by: Zero2Cool