Query

[vhrool12]

Hello, does anyone have a query to close the clan for the game and can give me, version 1.5 / clan close <name>

[MentaL]

[LGPaul]

Hello, does anyone have a query to close the clan for the game and can give me, version 1.5 / clan close <name>

Programming -> StoredProcedure -> spReserveCloseClan

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 varchar(24)  
AS  
UPDATE Clan SET DeleteFlag=1, Name=NULL, DeleteName=@ClanName WHERE CLID=@CLID AND MasterCID=@MasterCID

Message.xml

<MSG id="1108">This clan has been closed, please rejoin.</Msg> 

[vhrool12]

Programming -> StoredProcedure -> spReserveCloseClan

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 varchar(24)  
AS  
UPDATE Clan SET DeleteFlag=1, Name=NULL, DeleteName=@ClanName WHERE CLID=@CLID AND MasterCID=@MasterCID

Message.xml

<MSG id="1108">This clan has been closed, please rejoin.</Msg> 

thanks.

[OJuice]

credits to kike2 for that

http://forum.ragezone.com/f245/fix-c...-1-5-a-914241/