Clan Deletion Help [BRGUNZ]
Do you guys see anything wrong with this?
Code:
USE [GunzDB]
GO
/****** Object: StoredProcedure [dbo].[spDeleteClan] Script Date: 03/13/2008 20:08:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- 클랜 삭제하기
ALTER PROC [dbo].[spDeleteClan]
@CLID int,
@ClanName varchar(24)
AS
SET NOCOUNT ON
-- 클랜원 모두 삭제
DELETE FROM ClanMember WHERE CLID=@CLID
-- 클랜 삭제
UPDATE Clan SET Name=NULL, DeleteFlag=1, DeleteName=@ClanName WHERE CLID=@CLID[/EMAIL">CLID=@CLID"]CLID=@CLID
It lets us delete the clan, but the clan is still there. That may not be the part that is messed up, but if it is please correct it for me; or tell me how to fix.
Re: Clan Deletion Help [BRGUNZ]
Same problem for me ppl cant delite or leave clan how i fix?:eek:
