Quick Couple system fix

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.

Code:

---

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.

is this for official files??

Quote:

---

Originally Posted by wishly

is this for official files??

---

no for calli >_>

Quote:

---

Originally Posted by kloklojul

no for calli >_>

---

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

Nah, but nice share. ;)

Quote:

---

Originally Posted by wishly

is this for official files??

---

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

Quote:

---

Originally Posted by wishly

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??

:P:

Quote:

---

Originally Posted by ctby23

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??

:P:

---

kanya kanya trip yan bata

Thanks for the share! :>

Thnx aloot!

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?

Quote:

---

Originally Posted by 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?

---

Prune all the data from tblCouple and tblCouplePlayer.

it worked, thank you