[RELEASE] Negative Bounty Fix

**-Lambda-** · 14-01-07

Yeah, i release this fix :juggle:

First, edit your spBuyBountyItem procedure

You have this procedure:

Code:

CREATE PROCEDURE [dbo].[spBuyBountyItem]
    @nCID INT,
    @nItemID INT,
    @nPrice INT
AS
BEGIN
    SET NOCOUNT ON;

    UPDATE Character SET BP = BP-@nPrice 
    INSERT INTO Items
    VALUES(@nCID,@nItemID,NULL)
    SELECT 0 OrderCIID

END

Ok, the bug is in this line:

Code:

UPDATE Character SET BP = BP-@nPrice

This line, set the ALL characters BP to negative but dont have a WHERE CID = @nCID

This is a fixed procedure

Code:

CREATE PROCEDURE [dbo].[spBuyBountyItem]
    @nCID INT,
    @nItemID INT,
    @nPrice INT
AS
BEGIN
    SET NOCOUNT ON;

    UPDATE Character SET BP = BP-@nPrice WHERE CID = @nCID
    INSERT INTO Items
    VALUES(@nCID,@nItemID,NULL)
    SELECT 0 OrderCIID

END

Credits to me

**MentaL**

**fsadario** · 14-01-07

Yes!! I need test it now
Thanks very much. Works really good

**emisand** · 14-01-07

WoW!

Nice work lambda

This is very helpful
Thanks

**MAXTRAXv3** · 14-01-07

yer thanks alot!

**monkeyeed** · 14-01-07

thanks i really needed this =)

**kochon** · 14-01-07

wondeful, i love you

**cronic123** · 14-01-07

wooah great job man ;)

**mts** · 14-01-07

Wowwwwwwwwwwwwww!!!! Excellent....

**jer0m3** · 15-01-07

Finally!!!the fix for negative bounty,thx so much and nice work

**LilHustLa** · 15-01-07

YES!!! finally thx man =)

**frank** · 15-01-07

thx very good work ....

**kekku500** · 15-01-07

tyyyyyyyy ^^^^^^^^^^

**Pp7** · 15-01-07

awesome.

**Avunari** · 15-01-07

Really nice man, Thanks alot.

**dordort** · 15-01-07

I love you.

**3ddy** · 15-01-07

dordort i thot u from GzN lol....orhhzzz i noe liao u take hacks from here and post in GzN to become a reg+ or a mod noob

**3ddy** · 15-01-07

lol edit tis at where?Xml document?

**jer0m3** · 15-01-07

Originally Posted by 3ddy

lol edit tis at where?Xml document?

Dude copy the procedure to your SQL not on XML file!don't be so newbie dude

**Kawaii-ne** · 15-01-07

Originally Posted by jer0m3

Dude copy the procedure to your SQL not on XML file!don't be so newbie dude

we are once a newbie too, though it is obvious that its not XML ...

**tozezao** · 16-01-07

I'm still having the same negative bounty problem...
And i did everything alright...

**-Lambda-** · 16-01-07

Originally Posted by tozezao

I'm still having the same negative bounty problem...
And i did everything alright...

mmm i dont have that problem..

check all of procedures, that need to modify a Character table, and check if WHERE CID = @nCID (or similar) is in the procedure

**Vitto** · 17-01-07

Just a question

Code:

CREATE PROCEDURE [dbo].[spBuyBountyItem]
    @nCID INT,
    @nItemID INT,
    @nPrice INT
AS
BEGIN
    SET NOCOUNT ON;

    UPDATE Character SET BP = BP-@nPrice WHERE CID = @nCID
    INSERT INTO Items
    VALUES(@nCID,@nItemID,NULL)
    SELECT 0 OrderCIID

END

Why are you creating the tables, shouldn't it be ALTER PROCEDURE [dbo].[spBuyBountyItem]? Or am i just missing something here?

This doesn't work for me neither.

**toshiharu** · 17-01-07

omg just delete the old 1 and execute that 1

ffs

**Vitto** · 17-01-07

That was what i was thinking :)

**Tsukasa035** · 17-01-07

Works like a charm. For everyone that's whining, just delete dbo.spBuyBountyItem and then create the procedure with the fixed entry.

[RELEASE] Negative Bounty Fix

Thread Tools

Search Thread

[RELEASE] Negative Bounty Fix

Advertisement