[RELEASE] Yet another negative bounty fix

Newbie Spellweaver
Joined
Jan 28, 2007
Messages
39
Reaction score
0
Ok, this is for the negative bounty problem in QUEST MODE.

Original spUpdateCharBP:

Code:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spUpdateCharBP]
    @nBP INT,
    @nCID INT
AS
BEGIN
    SET NOCOUNT ON;

    UPDATE Character
    SET BP = @nBP
    WHERE CID = @nCID
END
If you log the parameters into some table, you will notice that @nBP is negative, so this procedure should be as follows:

Code:
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spUpdateCharBP]
    @nBP INT,
    @nCID INT
AS
BEGIN
    SET NOCOUNT ON;

    UPDATE Character
    [B]SET BP = BP+@nBP[/B]
    WHERE CID = @nCID
END
Maybe this is a dupe release, I don't know as I didn't search, but I was just enabling full quest mode on my server and found this error at the procedures. Hope it helps someone out there.

If anyone released this before, please, I'm not trying to steal your credits, just trying to help others here.

Cya
 
Back