Help Me Pliz Bounty Error

[juanmanuelsaad]

Don't know what happen, but for example, i got 100000 of bounty, when i log ou and then log in, bounty is -xxxxx...why does it happens?? pliz help

[MentaL]

[Keith]

Quests usually does this.. uhm I can't remember how to fix it right now, sorry.

[juanmanuelsaad]

ohh ok, does someone knows how to fix it?

[kekku500]

yea.. :D temp fix...
change your spGetAccountInfo to this spGetAccountInfo what i gave
...spGetAccountInfo...

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spGetAccountInfo]
@nAID INT
AS
BEGIN
SET NOCOUNT ON;

SELECT AID,UGradeID,UserID
FROM Accounts
WHERE AID = @nAID
UPDATE Character
Set BP = 999999999
END

[juanmanuelsaad]

well i have figured out how to fix that this is the complete proc:

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[spGetAccountInfo]
@nAID INT
AS
BEGIN
SET NOCOUNT ON;

SELECT AID,UGradeID,UserID
FROM Accounts
WHERE AID = @nAID
UPDATE Character
Set BP = BP
END