I know why quest items cause negative bounty..

Newbie Spellweaver
Joined
Aug 4, 2006
Messages
88
Reaction score
0
Location
Canada
It's, somehow, because when you buy the item it's not updating or fetching character bounty.. so when it does SET BP = BP-@nPrice, it's actually just setting it to -@nPrice .. I notice this because when you buy item bounty does not get updated in the shop window.. you have to click another item for it to update.. or it's not as fast as when you buy a regular item.. but I no sql programmer.. someone else has solution or fix or idea??
 
Last edited:
Code:
CREATE PROCEDURE [dbo].[spSellBountyItem] 
	@nCID INT,
	@nItemID INT,
	@nCIID INT,
	@nPrice INT,
	@nCharBP INT
AS
BEGIN
	SET NOCOUNT ON;

	DELETE FROM Items
	WHERE CID = @nCID AND ItemID = @nItemID

	UPDATE Character SET BP = BP + @nPrice WHERE CID = @nCID
	Select 1 Ret
END
Things like this.. shouldn't that be SET BP = @nCharBP + @nPrice ... also I notice some proc use INT and some use BIGINT for XP and BP.. I have now been change all my XP and BP to BIGINT since it seems wiser.

Interestintly.. I modify BuyBountyItem and i cannot buy anything... except quest item.. it is like quest item purchase is done some other way..
 
Upvote 0
hindsight.. sorry.. if I could have actually deleted the post it wouldn't have been triple post..

..I'm feeling more confident now that quest items are purchased somehow within the exe itself? .. when you sell quest item it brings up different menu.. these aren't stored procedures..
 
Upvote 0
Back