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

[TriEdge]

If you set price to alz you can, if you set price to coins you must edit DB.

no you dont. i have shops for alz,ecoins,dp,wexp and nothing edited in database.

 

[CrazyArcad]

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

 

[PunkS7yle]

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.

 

[TriEdge]

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

 

[PunkS7yle]

You proved nothing, just words. I urge everyone that wants to edit to try it, add an item like superior core high for example in N shop for 500 coins, and try buying it

 

[Spik3man]

me and my friends aleardy did that , and its working without editing the db.. strage but is work

 

[PunkS7yle]

It doesn't work, not unless the id is already in the table. Post the table.

 

[CrazyArcad]

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.

 

[x30unlimited]

It doesn't work, not unless the id is already in the table. Post the table.

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"

 

[cadena]

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"

yes, u posted this one:

here's a fix for npc cash shop
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

 

[4pLay]

Any Free Taste Yet?!... :

 

[CrazyArcad]

Nothing yet... Soon though. Have to finish main functions before first release. will keep you all informed.

 

[juleki]

u can send me pm with ur tool, i can test it on my server ;]

 

[CrazyArcad]

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...

 

[4pLay]

View attachment 123827View attachment 123828
View attachment 123829View attachment 123830

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...

Did You Add Images Of Which Item You Are Adding/Editing?!...

Just For Visual Experience... :

Thanks! And God Speed!

 

[R0N]

any update?

 

[CrazyArcad]

Screenshots of additional features in the works. Work continues...

 

[jaguar666]

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...

 

[4pLay]

View attachment 123932View attachment 123933View attachment 123935


Screenshots of additional features in the works. Work continues...

You Have Made A Putty Version Of Yours In Your Tool,.. That's 1 Way Of Closing The Deal With The Best GM Tool Ever... :

Take Your Time My Friend! No Rush! Rushing Into Things Will Complicate Things...

Thank You And God Speed!

 

[Caelann]

*reads everything this tool will be able to accomplish* *faints*

I can't wait for it to be released! 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