- Joined
- Apr 23, 2008
- Messages
- 714
- Reaction score
- 101
Hello all today im show you how fix the guild bug wen one member of guild can't leave guild use on
_________________
Query Analyzer
Select ,MuOnline.
and past this code ...
i think is simple guide for old versions ...
_________________
Query Analyzer
Select ,MuOnline.
and past this code ...
Code:
declare @gloop char(15)
declare @gctr int
declare @tctr int
set @tctr=0
set @gctr=0
select G_name from Guild
set @tctr = @@ROWCOUNT
while @gctr<@tctr
BEGIN
set @gctr = @gctr + 1
select @gloop=G_name from Guild
select * from Guildmember where G_Name=@gloop
IF @@ROWCOUNT < 2
begin
delete from Guildmember where G_Name = @gloop
delete from Guild where G_Name = @gloop
end
END
i think is simple guide for old versions ...