Help Me Pliz Bounty Error

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

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

ohh ok, does someone knows how to fix it?

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

Quote:

---

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

---

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

Quote:

---

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

---