[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

well done:drool:

that mean can edit webshop on web right?

I've no idea what's you're think about..
How can a webshop not working on a web..

It works, you solve my problem. Thank you.

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!

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 ?!

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.

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 !!!?

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.

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

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.

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.

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.

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?