Quick Couple system fix

[DragonLord]

The couple system in the repack has one simple flaw;
If you break up, it doesn't remove the couple, so in turn you can't make a new couple due to having duplicate entries.
So for the sake of the good old spirit of ragezone, I'm sharing this basic fix for the couple deletion stored procedure.

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

Enjoy.
Don't like it? shove it.

[MentaL]

[wishly]

is this for official files??

[kloklojul]

is this for official files??

no for calli >_>

[spikensbror]

no for calli >_>

0mgwut c44li 1s b4nned!!!!!!!!!!!!1111111!!!1 oone!

Nah, but nice share. ;)

[DragonLord]

is this for official files??

Pointless question.
There's a simple saying: "If you can't understand it, don't do it!"

[ctby23]

is this for official files??

what a nooby question... damn ur a pinoy?? (pinoy ka pa man din) -,-

I ask u.. is there a couple system in other files other than official??

[wishly]

what a nooby question... damn ur a pinoy?? (pinoy ka pa man din) -,-

I ask u.. is there a couple system in other files other than official??

kanya kanya trip yan bata

[Alexz23]

Thanks for the share! :>

[fantobros]

Thnx aloot!

[KING5]

what went wrong? I try to propose to someone and it says Database error lol and also i am couple to my self wtf what happened and how can i fix this?

[DragonLord]

what went wrong? I try to propose to someone and it says Database error lol and also i am couple to my self wtf what happened and how can i fix this?

Prune all the data from tblCouple and tblCouplePlayer.

[KING5]

it worked, thank you