[RELEASE] Yet another negative bounty fix

[alduath]

Ok, this is for the negative bounty problem in QUEST MODE.

Original spUpdateCharBP:

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:

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 = BP+@nBP
    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

[MentaL]

[haxing]

hey thanks man! u fixed my prob =)

[Keith]

Thanks ..

[ShakatoNNN]

thanks nice release ;)

[kekku500]

Hre is now 1 good thing and 1 bad thing
GOOD is its fixeddd :D
BAD is.. i must put price to items OMG

[SpadeZ[905]]

<3 I love you man good job :D FInally I can afford items