Bounty Bug!!

[William2099]

I realized when somebody purchase an item discounts to all the players.

Error in stored procedures!!

Help me!!

en espa

 

[jer0m3]

Dude Look on the stickies...there's a lot of fixers there..

 

[snlwg]

yep =] think before u post

 

[Rotana]

To fix the bounty. Change your database. At dbo.SpBuyBountyItem

and put this code in it

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER 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

Credits to -Lambda- .

 

[Avunari]

To fix the bounty. Change your database. At dbo.SpBuyBountyItem

and put this code in it

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER 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

Credits to -Lambda- .

Nope, You need to put this code in:

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

   [COLOR="Red"] UPDATE Character SET BP = BP-@nPrice WHERE CID = @nCID [/COLOR]
    INSERT INTO Items
    VALUES(@nCID,@nItemID,NULL)
    SELECT 0 OrderCIID

END

 

[Pp7]

there was a fix code in the section.

 

[Rotana]

Nope, You need to put this code in:

 CREATE PROCEDURE [dbo].[spBuyBountyItem]
    @nCID INT,
    @nItemID INT,
    @nPrice INT
AS
BEGIN
    SET NOCOUNT ON;
 
   [COLOR=red]UPDATE Character SET BP = BP-@nPrice WHERE CID = @nCID [/COLOR]
    INSERT INTO Items
    VALUES(@nCID,@nItemID,NULL)
    SELECT 0 OrderCIID
 
END

Sorry i'm wrong and your right... You need this one

 

[kekku500]

it now work still bounty goes to minus