[Database] Find Inventory

[fadekz]

Hello epvp expert and community,

I search in the database where is located the Inventory per char

Thank's and good day

[B1Q]

Originally Posted by fadekz

Hello epvp expert and community,

I search in the database where is located the Inventory per char

Thank's and good day

use this query

select inv.ItemID,chr.CharID,ref.CodeName128,it.RefItemID,it.ID64
from _Inventory as inv
LEFT JOIN _Char as chr ON chr.CharID=inv.CharID
LEFT JOIN _Items as it ON it.ID64 = inv.ItemID
LEFT JOIN _RefObjCommon as ref on ref.ID=it.RefItemID
where chr.CharName16='test'

and ofcourse you have to change test to your charname

[fadekz]

Hello @,

How i can find the shortcut about the Table (exemple: inv. get directly the link about SRO_VT_SHARD.[dbo]_Inventory ? (I'll try to dev some finder tools same has your for share it here too )

Thank's for your answer

Editing:

select roch.ID,roch.Lvl,roch.MaxHP,roch.ExpToGive
from _RefObjChar as roch
LEFT JOIN _RefObjCommon as roco ON roco.link=roch.ID
where roco.CodeName128='MOB_RM_TAHOMET'

Have find ! Thanks (MOB Unique/Monters Finder)

[MrCatGardens]

Originally Posted by fadekz

Hello @,

How i can find the shortcut about the Table (exemple: inv. get directly the link about SRO_VT_SHARD.[dbo]_Inventory ? (I'll try to dev some finder tools same has your for share it here too )

Thank's for your answer

This:

from _Inventory as inv

will point the

inv

to the _Inventory - Table

[B1Q]

Originally Posted by fadekz

Hello @,

How i can find the shortcut about the Table (exemple: inv. get directly the link about SRO_VT_SHARD.[dbo]_Inventory ? (I'll try to dev some finder tools same has your for share it here too )

Thank's for your answer

Editing:

select roch.ID,roch.Lvl,roch.MaxHP,roch.ExpToGive
from _RefObjChar as roch
LEFT JOIN _RefObjCommon as roco ON roco.link=roch.ID
where roco.CodeName128='MOB_RM_TAHOMET'

Have find ! Thanks (MOB Unique/Monters Finder)

good luck

[Spidy.]

^
#Closed