1500 NP si Olmayan Krallığa Oy Veremesin !!

/****** Object: Stored Procedure dbo.KING_ELECTION_PROC Script Date: 6/6/2006 6:03:33 PM ******/

-- 2009.08.13. "Admin / Celal / Mersin"

CREATE PROCEDURE [dbo].[KING_ELECTION_PROC]
@strAccountID char(21), -- Voted man's account
@strCharID char(21), -- Nick's vote
@byNation tinyint,
@strCandidacyID char(21), -- Nick chosen people
@nRet smallint OUTPUT

AS

DECLARE @nRow smallint

SELECT @nRow = Count(strAccountID) FROM KING_BALLOT_BOX WHERE strAccountID = @strAccountID
IF @nRow > 0 -- Vote for one person
BEGIN
SET @nRet = -3
RETURN
END

DECLARE @Loyalty int
SELECT @Loyalty = Loyalty FROM USERDATA WHERE strUserID = @strCharID
IF @Loyalty < 1500
BEGIN
SET @nRet = -3
RETURN
END

INSERT INTO KING_BALLOT_BOX (strAccountID, strCharID, byNation, strCandidacyID )
VALUES ( @strAccountID, @strCharID, @byNation, @strCandidacyID )

UPDATE KING_ELECTION_LIST SET nMoney = nMoney + 1
WHERE byType = 4 and strName = @strCandidacyID

SET @nRet = 1
RETURN
GO