[1.5]Comando clanclose fixo

Galera, percebi que muita gente que tem Gunz 1.5,  tem bug no /clan close ...

Então, postarei uma solução...

Definir clan como NULL (excluir clan, mas deixar os logs no banco de dados).

USE [GunZDB]
GO
/****** Object:  StoredProcedure [dbo].[spReserveCloseClan]    Script Date: 08/03/2009 20:54:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[spReserveCloseClan]   
 @CLID  int 
, @ClanName varchar(24) 
, @MasterCID int   
, @DeleteDate smalldatetime 
AS   
UPDATE Clan SET DeleteFlag=1, Name=NULL, DeleteName=@ClanName WHERE CLID=@CLID AND MasterCID=@MasterCID
DELETE FROM ClanMember WHERE CLID=@CLID

Excluir todas as informações do clan (apagar tudo sobre o clan como se nunca tivesse existido).

 USE [GunZDB]
GO
/****** Object: StoredProcedure [dbo].[spReserveCloseClan] Script Date: 08/08/2009 23:20:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[spReserveCloseClan]
@CLID int
, @ClanName varchar(24)
, @MasterCID int
, @DeleteDate smalldatetime
AS
DELETE FROM ClanGameLog WHERE WinnerCLID=@CLID AND LoserCLID=@CLID
DELETE FROM ClanHonorRanking WHERE CLID=@CLID
DELETE FROM ClanMember WHERE CLID=@CLID
DELETE FROM Clan WHERE CLID=@CLID AND MasterCID=@MasterCID

Adicione isso na sua Message.xml

<MSG id="1108">This clan is disbanded. Please relog.</MSG>

Pronto, agora só ir no Gunz, e digitar :

/clan close "Nome do Clan" (Sem aspas)

Compartilhe ! Tweet