Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Help Me Pliz Bounty Error

Junior Spellweaver
Joined
Jun 18, 2004
Messages
107
Reaction score
0
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
 
RageZ Hell
Joined
Nov 17, 2006
Messages
511
Reaction score
0
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
 
Upvote 0
Junior Spellweaver
Joined
Jun 18, 2004
Messages
107
Reaction score
0
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
 
Upvote 0
Back
Top