2 Attachment(s)
[Release] Inventory, Warehouse and Glyph Slots Expansion WithOut Cashshop
Before Release :
As we know, most people can't run Cashshop service correcty if you can't fix it.
So there's many problem without Cashshop works, like Inventory and Warehouse expansion etc..
I can't fix Cashshop too, so I decide to find out how these expansion function works.
P.S. If anyone can help me fix cashshop that's very thankful! Please PM me if anyone would.
CORE :
After 2 days' researching, I found there is a very important table to make it works. (Though I guess "IT'S THEM" at the very beginning)
It's:
"DNWorld.dbo.EffectItem"
WHY?
You know, WE CAN USING /MAKEITEM COMMAND TO CREATE ALMOST ALL ITEM ALSO INCLUDE CASHITEMS.
So I tested many ways to make it done.
But at the beginning, I just using /makeitem to create an inventory expansion item into my bag, but it doesn't work.(And also the item cannot be used)
Then I walk through the whole database but don't find anything about inventory and warehouse slots.
:mad:"Fxxxxk", how them works?!
:8:Finally I realized 1 thing I've forgot: "WHEN WE BUY AN EXPANSION ITEM, IT WON'T APPEARS IN OUR BAGS BUT EFFECTS INSTANTLY."
:w00t:Yes, IT EFFECTS INSTANTLY.
:?:But WHY THERE'S ITEMS?
:thumbup1:Yes, they're "EffectItem"!
That's why I said "DNWorld.dbo.EffectItem" is the keypoint to solve this problem.
SOLVE :
Using SQL:
Code:
INSERT INTO DNWorld.dbo.EffectItems (CharacterID,ItemID,EffectItemGetCode,EffectItemGetKey,Price,EternityFlag,EffectItemExpireDate,Property1,Property2,Property3,Property4,Property5,RegisterDate,ExpireCompleteFlag,ItemSerial) VALUES ({0},{1},1,1,1,{2}, '2024-01-01 00:00:00',0,0,0,0,0,GETDATE(),'{3},{4})
KeyPoint For Table:
{0} CharacterID Is your Character's Numeric Id can be found in DNMembership or DNWorld -> Characters table
{1} Item ID, it MUST BE the item with full description (Including how much slots it expans eg.5, 10 or 30 -> for Inventory or Warehouse. 1, 3 for Glyph)
{2} EternityFlag, " 'True' " or " 'False' " With "'" it makes EffectItemExprieDate row enable or not.
{3} ExpireCompleteFlag, Like EternityFlag, true for Expire.
{4} ItemSerial, 18 bits Item Indentify Number, MAKE IT NOT SAME AS ANY ITEM BEFORE, Serial is unique, 1 item has 1 serial. e.g: 123456789012345678 or 098765432109876543, both correct.
THE LAST, THE SCREEN SHOTS:
Attachment 143788
Attachment 143789
Best Wishes.
Yours,
FFFFF from China
@TouhouACTClub Technology
Re: [Release] Inventory, Warehouse and Glyph Slots Expansion WithOut Cashshop
Re: [Release] Inventory, Warehouse and Glyph Slots Expansion WithOut Cashshop
that mean can edit webshop on web right?
Re: [Release] Inventory, Warehouse and Glyph Slots Expansion WithOut Cashshop
I've no idea what's you're think about..
How can a webshop not working on a web..
Re: [Release] Inventory, Warehouse and Glyph Slots Expansion WithOut Cashshop
It works, you solve my problem. Thank you.
Re: [Release] Inventory, Warehouse and Glyph Slots Expansion WithOut Cashshop
Everything can work without Cashshop , you can even use an npc for special items and such! , So even through web you make things work out.
But nice release!
Re: [Release] Inventory, Warehouse and Glyph Slots Expansion WithOut Cashshop
thnx for the share at start i felt like reading a story o.o
Quote:
Originally Posted by
major333
Everything can work without Cashshop , you can even use an npc for special items and such! , So even through web you make things work out.
But nice release!
npc? there is stuff like xmas u can buy from npc but u need coins
like xmas coins how to get them o.0 ?!
Re: [Release] Inventory, Warehouse and Glyph Slots Expansion WithOut Cashshop
Quote:
Originally Posted by
NextGfx
thnx for the share at start i felt like reading a story o.o
npc? there is stuff like xmas u can buy from npc but u need coins
like xmas coins how to get them o.0 ?!
I think you would have to add them into the table , then the npc reads the ID from there.
Re: [Release] Inventory, Warehouse and Glyph Slots Expansion WithOut Cashshop
Quote:
Originally Posted by
major333
I think you would have to add them into the table , then the npc reads the ID from there.
ik that but how do u even get Xmas Coins Id !!!?
Re: [Release] Inventory, Warehouse and Glyph Slots Expansion WithOut Cashshop
Quote:
Originally Posted by
NextGfx
ik that but how do u even get Xmas Coins Id !!!?
Hmm not to sure , i haven't checked that one out yet man.
Re: [Release] Inventory, Warehouse and Glyph Slots Expansion WithOut Cashshop
Quote:
Originally Posted by
major333
Hmm not to sure , i haven't checked that one out yet man.
well i cant check the whole DB Id's too much work lol
but if theres a way to remove the requirements of the shop would be nice
Re: [Release] Inventory, Warehouse and Glyph Slots Expansion WithOut Cashshop
Quote:
Originally Posted by
NextGfx
well i cant check the whole DB Id's too much work lol
but if theres a way to remove the requirements of the shop would be nice
I'm gonna look into it , once i get my server going again. At the moment currently having issues with this Invalid Request.
Re: [Release] Inventory, Warehouse and Glyph Slots Expansion WithOut Cashshop
Quote:
Originally Posted by
NextGfx
well i cant check the whole DB Id's too much work lol
but if theres a way to remove the requirements of the shop would be nice
Of course there is another way for you to find out which 1 is xmas coin's ID.
Just open resource\uistring\uistring.xml with advanced edit tool like Notepad++ and search string "xmas" or whatever the xmascoin's name in english ( I'm chinese so idk what's its name :( )
Then you'll got a text line start with " <message mid="xxxxx"> ",
the mid(MessageID) "xxxxx" is your destination.
Then, confirm what's you find out is a "name" or a "description"
If it's a name, using:
Code:
SELECT id FROM DNGSM.dbo.ExtItem WHERE _NameID LIKE '%YourFindIDNumberHere%'
if it's description, change _NameID to _DescriptionIDParam ..
what's SQL Manage tool gives the query results is the ID you want.
Try this way if your DNGSM database has a dbo.ExtItem table , and also it's not empty :D
- - - Updated - - -
Quote:
Originally Posted by
major333
I'm gonna look into it , once i get my server going again. At the moment currently having issues with this Invalid Request.
Try make MissionScore = 0 in DNWorld.dbo.CharacterStatus for your unloginable character
- - - Updated - - -
Oh,
Code:
SELECT id FROM DNGSM.dbo.ExtItem WHERE _NameID LIKE '%YourFindIDNumberHere%'
In that SQL query string, after LIKE must contains " '% " and " %' " or you'll get nothing.
%12345% = aaa12345bbb or ccc12345ddd anyother like that.
Re: [Release] Inventory, Warehouse and Glyph Slots Expansion WithOut Cashshop
Quote:
Originally Posted by
Noein
Of course there is another way for you to find out which 1 is xmas coin's ID.
Just open resource\uistring\uistring.xml with advanced edit tool like Notepad++ and search string "xmas" or whatever the xmascoin's name in english ( I'm chinese so idk what's its name :( )
Then you'll got a text line start with " <message mid="xxxxx"> ",
the mid(MessageID) "xxxxx" is your destination.
Then, confirm what's you find out is a "name" or a "description"
If it's a name, using:
Code:
SELECT id FROM DNGSM.dbo.ExtItem WHERE _NameID LIKE '%YourFindIDNumberHere%'
if it's description, change _NameID to _DescriptionIDParam ..
what's SQL Manage tool gives the query results is the ID you want.
Try this way if your DNGSM database has a dbo.ExtItem table , and also it's not empty :D
- - - Updated - - -
Try make MissionScore = 0 in DNWorld.dbo.CharacterStatus for your unloginable character
- - - Updated - - -
Oh,
Code:
SELECT id FROM DNGSM.dbo.ExtItem WHERE _NameID LIKE '%YourFindIDNumberHere%'
In that SQL query string, after LIKE must contains " '% " and " %' " or you'll get nothing.
%12345% = aaa12345bbb or ccc12345ddd any other like that.
Nice little shortcut there Noein =] , and regards to my issue there is no characters in my DB as it's default.
Haven't got a clue whats going on as everything was working just fine a couple of days ago.
Re: [Release] Inventory, Warehouse and Glyph Slots Expansion WithOut Cashshop
Quote:
Originally Posted by
major333
Nice little shortcut there Noein =] , and regards to my issue there is no characters in my DB as it's default.
Haven't got a clue whats going on as everything was working just fine a couple of days ago.
Does it appears when you're login or?