[Database] Find Inventory

10/14/2016 11:31 fadekz#1
Hello epvp expert and community,

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

Thank's and good day
10/14/2016 16:10 B1Q#2
Quote:
Originally Posted by fadekz View Post
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
Code:
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
10/18/2016 13:13 fadekz#3
Hello @[Only registered and activated users can see links. Click Here To Register...],

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:

Code:
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)
10/18/2016 13:20 MrCatGardens#4
Quote:
Originally Posted by fadekz View Post
Hello @[Only registered and activated users can see links. Click Here To Register...],

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:
HTML Code:
from _Inventory as inv
will point the
HTML Code:
inv
to the _Inventory - Table
10/18/2016 14:58 B1Q#5
Quote:
Originally Posted by fadekz View Post
Hello @[Only registered and activated users can see links. Click Here To Register...],

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:

Code:
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
10/18/2016 15:25 Spidy.#6
^
#Closed