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!

The Divinity Project GM/Server Tools - Advanced (Revamp: Binary Mass GM Tool Kit EP8)

Joined
Feb 26, 2010
Messages
1,374
Reaction score
780
no you dont. i have shops for alz,ecoins,dp,wexp and nothing edited in database.

If you add stuff for cash in DP shop you can't buy them unless you sync the shop with npc_itemdata. I dont know why you argue with me when I've proven time over time I'm right.

Enough arguing. Already got my first thread deleted because of people arguing and flaming. so please pm each other if you want to argue.

Just saying what you need, 'ts all.
 
Joined
Sep 30, 2010
Messages
455
Reaction score
135
If you add stuff for cash in DP shop you can't buy them unless you sync the shop with npc_itemdata. I dont know why you argue with me when I've proven time over time I'm right.

and im saying it works with just editing NPCShop.scp. me and my players reported me it works so i dont know what you are talking. i guess i proved it better then you :)
 
Junior Spellweaver
Joined
Apr 14, 2007
Messages
109
Reaction score
180
It doesn't work, not unless the id is already in the table. Post the table.

I verified this. PunkS7yle is correct on this. Thanks for the information though, makes my life easier. Alot of coding ahead to make all features work to MY SPECIFICATIONS, meaning it has to be bug free. Will update more on progress with new screen shots when available. Please feel free to post any more Suggestions/requested features. I will try and add those features that I find efficient solutions for.

In this new tool, all code is being optimized for maximum efficiency.
 
Elite Diviner
Joined
Sep 11, 2010
Messages
430
Reaction score
94
i posted on the original release thread an edit to a stored proc that added the missin items when bought ... i'm guessin the mods deleted it (if it's not there anymore, haven't checked) for "unknown reasons" :p

yes, u posted this one:

here's a fix for npc cash shop :D
ALTER PROC [dbo].[npc_purchaseCashItem]
@usernum INT
, @ItemIdx INT
, @OptionIdx INT
, @Duration INT
, @Quantity INT
, @Cash INT
, @ResultCode INT OUTPUT
, @CashLogNo BIGINT OUTPUT
, @RemainingCash INT OUTPUT
AS
SET XACT_ABORT ON
DECLARE @UserCash INT
DECLARE @NPCItemIdx INT
DECLARE @UserID VARCHAR(30)

SET @CashLogNo = 0
SET @UserCash = 0
SET @RemainingCash = 0

SELECT TOP 1 @UserID = ID
FROM ACCOUNT.dbo.cabal_auth_table
WHERE usernum = @usernum

IF @UserID IS NULL
BEGIN
SET @ResultCode = 0xE9
SET XACT_ABORT OFF
RETURN
END

SELECT @UserCash = CashTotal
FROM CashAccount
WHERE Usernum = @usernum

IF ISNULL(@UserCash, 0) < @Cash
BEGIN
SET @ResultCode = 0xE2
SET @RemainingCash = ISNULL(@UserCash, 0)
SET XACT_ABORT OFF
RETURN
END

SELECT @NPCItemIdx = LinkPrdID
FROM [dbo].[npc_itemdata]
WHERE ItemIdx = @ItemIdx
AND ItemOption = @OptionIdx
AND Duration = @Duration

IF @NPCItemIdx is null
BEGIN
SET @NPCItemIdx = @ItemIdx + @OptionIdx + @Duration
INSERT INTO [dbo].[npc_itemdata]
(ItemIdx
,[Duration]
,[ItemOption]
,LinkPrdID)
VALUES
(@ItemIdx
,@Duration
,@OptionIdx
,@NPCItemIdx)
END

DECLARE @PreCash INT
DECLARE @PreCashBonus INT

DECLARE @NextCash INT
DECLARE @NextCashBonus INT

SELECT @PreCash = Cash
, @PreCashBonus = CashBonus
FROM CashAccount
WHERE Usernum = @usernum

IF (@PreCash + @PreCashBonus) < @Cash
BEGIN
SET @ResultCode = 0xE2
SET @RemainingCash = @PreCash + @PreCashBonus
SET XACT_ABORT OFF
RETURN
END

IF @PreCashBonus < @Cash
BEGIN
SET @NextCashBonus = 0
SET @NextCash = @PreCash - @Cash + @PreCashBonus
END
ELSE
BEGIN
SET @NextCashBonus = @PreCashBonus - @Cash
SET @NextCash = @PreCash
END

BEGIN TRAN NPC_Purchase_Transaction

UPDATE CashAccount
SET Cash = @NextCash
, CashBonus = @NextCashBonus
WHERE Usernum = @usernum

INSERT INTO [dbo].[CashLog]
([UserNum]
, ID
,[LogType]
,[LogSubType]
,[CashAfter]
,[CashBonusAfter]
,[CashPre]
,[CashBonusPre]
,[ChangeCash]
,[ChangeCashBonus]
,[ItemCD]
,[Quantity]
,[TranNo]
,[LogDateTime]
)
VALUES
(@usernum
, @UserID
,2
,1
,@NextCash
,@NextCashBonus
,@PreCash
,@PreCashBonus
,@NextCash - @PreCash
,@NextCashBonus - @PreCashBonus
,@NPCItemIdx
,@Quantity
,0
,GETDATE()
)
SET @CashLogNo = @@IDENTITY

DECLARE @RowCount INT

SET @RowCount = 1
SET @RemainingCash = @NextCash + @NextCashBonus
SET @ResultCode = 0x00

COMMIT TRAN NPC_Purchase_Transaction
SET XACT_ABORT OFF
 
Junior Spellweaver
Joined
Jun 2, 2011
Messages
145
Reaction score
14
u can send me pm with ur tool, i can test it on my server ;]
 
Junior Spellweaver
Joined
Apr 14, 2007
Messages
109
Reaction score
180
screen1_2-16-13 - The Divinity Project GM/Server Tools - Advanced (Revamp: Binary Mass GM Tool Kit EP8) - RaGEZONE Forums screen2_2-16-13 - The Divinity Project GM/Server Tools - Advanced (Revamp: Binary Mass GM Tool Kit EP8) - RaGEZONE Forums
screen3_2-16-13 - The Divinity Project GM/Server Tools - Advanced (Revamp: Binary Mass GM Tool Kit EP8) - RaGEZONE Forums screen4_2-16-13 - The Divinity Project GM/Server Tools - Advanced (Revamp: Binary Mass GM Tool Kit EP8) - RaGEZONE Forums

As promised, more screenshots of progress. Tool is now loading data from live EP8 databases on my test server. Saving Character / Inventory / Warehouse modifications.

Look for further updates in the coming days...
 

Attachments

You must be registered for see attachments list
█║▌║▌║TheMerc iful║▌║▌║█
Loyal Member
Joined
Jan 29, 2005
Messages
1,366
Reaction score
80
Elite Diviner
Joined
Aug 23, 2012
Messages
406
Reaction score
99
Job well done CrazyArcad... Maybe this time you can share with us your beta version. We actually need for now is the Item sender/editor function since emi have been released his beta version for Account/Char management. There's also another tool been released with minimal function same with emi's release.
-- we can actually send items to an account manually but we find hard the exact option codes for the item# 2000 up (slots and epic). the balqtool is only limited for items number 2000 below.

Thanks for the time you've spent for this wonderful project...
 
█║▌║▌║TheMerc iful║▌║▌║█
Loyal Member
Joined
Jan 29, 2005
Messages
1,366
Reaction score
80
Newbie Spellweaver
Joined
Oct 28, 2011
Messages
72
Reaction score
13
*reads everything this tool will be able to accomplish* *faints*

I can't wait for it to be released! :D The item editor in particular would be most useful. Not that the DB script is that troublesome to use, it's the item option part that ruins it. xD
 
Back
Top