Newbie Spellweaver
- Joined
- Oct 14, 2006
- Messages
- 46
- Reaction score
- 0
for percent how come mine is stuck at 100% and for the bounty bug i followed the bounty bug fix release
http://forum.ragezone.com/gunz-releases/release-negative-bounty-fix-210307.html
but I still get negative bounty. This is what i did like it said:
CREATE PROCEDURE [dbo].[spBuyBountyItem]
@nCID INT,
@nItemID INT,
@nPrice INT
AS
BEGIN
SET NOCOUNT ON;
UPDATE Character SET BP = BP-@nPrice
INSERT INTO Items
VALUES(@nCID,@nItemID,NULL)
SELECT 0 OrderCIID
END
so i added the line WHERE CID = @nCID to it
and it became like this
CREATE PROCEDURE [dbo].[spBuyBountyItem]
@nCID INT,
@nItemID INT,
@nPrice INT
AS
BEGIN
SET NOCOUNT ON;
UPDATE Character SET BP = BP-@nPrice WHERE CID = @nCID
INSERT INTO Items
VALUES(@nCID,@nItemID,NULL)
SELECT 0 OrderCIID
END
this happens after i die in quest I logged out and logged back on and my bounty was in the negatives. Anyone know what is wrong?
http://forum.ragezone.com/gunz-releases/release-negative-bounty-fix-210307.html
but I still get negative bounty. This is what i did like it said:
CREATE PROCEDURE [dbo].[spBuyBountyItem]
@nCID INT,
@nItemID INT,
@nPrice INT
AS
BEGIN
SET NOCOUNT ON;
UPDATE Character SET BP = BP-@nPrice
INSERT INTO Items
VALUES(@nCID,@nItemID,NULL)
SELECT 0 OrderCIID
END
so i added the line WHERE CID = @nCID to it
and it became like this
CREATE PROCEDURE [dbo].[spBuyBountyItem]
@nCID INT,
@nItemID INT,
@nPrice INT
AS
BEGIN
SET NOCOUNT ON;
UPDATE Character SET BP = BP-@nPrice WHERE CID = @nCID
INSERT INTO Items
VALUES(@nCID,@nItemID,NULL)
SELECT 0 OrderCIID
END
this happens after i die in quest I logged out and logged back on and my bounty was in the negatives. Anyone know what is wrong?