Quellcode
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- /****** Object: Stored Procedure dbo.uspDeleteCouple Script Date: 03/12/2009 19:27:05 ******/
- ALTER PROCEDURE [dbo].[uspDeleteCouple]
- @serverindex char(2),
- @idHusbandOrWife char(7)
- AS
- SET NOCOUNT ON
- declare @cid int
- declare @idFirst int
- declare @idSecond int
- select @cid = cid from tblCouplePlayer where idPlayer = @idHusbandOrWife
- select @idFirst = max(idPlayer) from tblCouplePlayer where cid = @cid and nServer = @serverindex
- select @idSecond = min(idPlayer) from tblCouplePlayer where cid = @cid and nServer = @serverindex
- delete from tblCouplePlayer where
- nServer = @serverindex
- AND
- (idPlayer = @idFirst
- OR
- idPlayer = @idSecond)
- delete from tblCouple where
- nServer = @serverindex
- AND
- cid = @cid
- SET NOCOUNT OFF
- GO
- SET ANSI_NULLS OFF
- GO
- SET QUOTED_IDENTIFIER OFF
- GO
Couple System Fix Procedure.
Mehr muss man dazu ja nicht sagen
Have fun && Fix !
LG Time2Chill
Quelle: Dragonlord im Ragezone-Forum // forum.ragezone.com/f457/quick-couple-system-fix-627176/