Hello everyone,
As we all know that dragon nest community is a dead section.
So i decided to release some stuff to help the new developers.
I will keep this post updating from time to time.
If anyone want to share something just add it in comment and i will update it in first page.
You have to use the DB2Table to make your job more faster.
Search at release section to find it.
Change Item stack
Disable or delete item from drop
Fix character deletion after lvl 80
Teleport character to town(Bug case)
Make an item tradable
To make item giftable
Change the sell value for an item
Find item by Serial Number
Find item at Pandora box
There is more queries i will post them later but i hope other developers will do that before me
Best Regards,
EpicDN Owner.
As we all know that dragon nest community is a dead section.
So i decided to release some stuff to help the new developers.
I will keep this post updating from time to time.
If anyone want to share something just add it in comment and i will update it in first page.
You have to use the DB2Table to make your job more faster.
Search at release section to find it.
Change Item stack
UPDATE itemtable SET [_OverlapCount]=999 WHERE [_NameID]=''
Disable or delete item from drop
UPDATE dbo.itemdroptable SET [_Item1Index]=0,[_Item1Prob]=0 WHERE [_Item1Index]='ITEMID'
Fix character deletion after lvl 80
UPDATE dbo.Characters SET DeleteFlag='FALSE',DeleteByAdminFlag=0 WHERE CharacterName='EpicDN'
Teleport character to town(Bug case)
UPDATE dbo.CharacterStatus SET PositionX=-58649,PositionY=-1688390,PositionZ=597341,Rotate=1.244423,LastVillageGateNumber=2,LastVillageMapID=1,LastMapID=1 WHERE CharacterName='EpicDN'
Make an item tradable
UPDATE dbo.itemtable_equipment SET [_AbleWStorage]=1,[_Reversion]=0 WHERE id='ITEMID'
To make item giftable
UPDATE dbo.cashcommodity SET [_PresentAble]=1
Change the sell value for an item
UPDATE itemtable SET [_SellAmount]=500000000 WHERE id='ITEMID'
Find item by Serial Number
EXECUTE dbo.P_GetItemOwner @inbItemSerial = 0
Find item at Pandora box
SELECT * FROM dbo.charmitemtable WHERE [_ItemID]='ITEMID'
There is more queries i will post them later but i hope other developers will do that before me
Best Regards,
EpicDN Owner.