- Joined
- Jan 28, 2007
- Messages
- 39
- Reaction score
- 0
Ok, this is for the negative bounty problem in QUEST MODE.
Original spUpdateCharBP:
If you log the parameters into some table, you will notice that @nBP is negative, so this procedure should be as follows:
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
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
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
If anyone released this before, please, I'm not trying to steal your credits, just trying to help others here.
Cya