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!

Dam.. i hate if bounty goes minussss..-999.sss

RageZ Hell
Joined
Nov 17, 2006
Messages
511
Reaction score
0
well i tryed

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

but bounty goes still minus if i buy quest item :boom:
 
Newbie Spellweaver
Joined
Jan 15, 2007
Messages
77
Reaction score
0
eh, give people like 100,000,000,000,000 bounty, yet that doesnt work for me, i'm reverting back to the old way,
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
 
Upvote 0
RageZ Hell
Joined
Nov 17, 2006
Messages
511
Reaction score
0
kk now im using ppl got 9999999999 and every time if login change bounty 99999999999
 
Upvote 0
Joined
Jan 6, 2005
Messages
500
Reaction score
79
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

This is absolutely wrong!!! hehe You know whats wrong with this SQL? With this kind of SQL, all the players will be deducted once player buy an item... so meaning you must specified what nCID is it? Put some WHERE clause in your SQL...
 
Upvote 0
Newbie Spellweaver
Joined
Jan 15, 2007
Messages
96
Reaction score
0
Easy, just don't allow any quest items to be bought from the shop.
 
Upvote 0
Back
Top