Query HELP!

[RenePunik]

Hello members.. I'm so proud that i made this query with myself... But it have some faults...

Use SRO_VT_SHARD
Select IT.ID64, IT.OptLevel As Plus, INV.CharID, CH.CharName16, REF.CodeName128 From _RefObjCommon As REF
Right Join _Items As IT On IT.RefItemID = REF.ID
Right Join _Inventory As INV On INV.ItemID = IT.ID64
Right Join _Char as CH On CH.CharID = INV.CharID
Where CodeName128 like 'ItemCodeName' 

If i wrote in ItemCodeName for example 'ITEM_EU_DAGGER_11_SET_B_RARE'
Query getting success, but it's get all players have this weapon i want to select the item from one character , not from all

sorry for my bad english

[MentaL]

[mtnman33]

ok let me get this straight , you want to see all the items on any certian char ? or only that item that you put in code on a char ?

[RenePunik]

ok let me get this straight , you want to see all the items on any certian char ? or only that item that you put in code on a char ?

Yup, As you say... I want specific character.

[mtnman33]

ok well i made a script awhile back that finds and list every item on a char and it works perfectly but for some reason it list DUMMY_OBJECTS as +250 but the Dummy slot is only the empty spaces anyways , but i will post my script for you. just change the CharName to what ever char name you want to find items on

USE SRO_VT_SHARD
Declare @Charname varchar(64)
set @Charname = 'CharName'
SELECT invent.CharID, invent.Slot, ref.CodeName128, items.OptLevel FROM _Inventory as invent
JOIN _Items as items on invent.ItemID = items.ID64
JOIN _RefObjCommon as ref on items.RefItemID = ref.ID
JOIN _Char as chart on invent.CharID = chart.CharID
WHERE chart.CharName16 = @Charname
ORDER BY invent.Slot asc
--> Coded by Mountain_Man33

[RenePunik]

ok well i made a script awhile back that finds and list every item on a char and it works perfectly but for some reason it list DUMMY_OBJECTS as +250 but the Dummy slot is only the empty spaces anyways , but i will post my script for you. just change the CharName to what ever char name you want to find items on

Thank you it worked like a charm, but as you saying the DUMMY_OBJECTS giving too much results. Anyway Good job.

- - - Updated - - -

Hello members.. I'm so proud that i made this query with myself... But it have some faults...

Use SRO_VT_SHARD
Select IT.ID64, IT.OptLevel As Plus, INV.CharID, CH.CharName16, REF.CodeName128 From _RefObjCommon As REF
Right Join _Items As IT On IT.RefItemID = REF.ID
Right Join _Inventory As INV On INV.ItemID = IT.ID64
Right Join _Char as CH On CH.CharID = INV.CharID
Where CodeName128 like 'ItemCodeName' 

If i wrote in ItemCodeName for example 'ITEM_EU_DAGGER_11_SET_B_RARE'
Query getting success, but it's get all players have this weapon i want to select the item from one character , not from all

sorry for my bad english

#Fixed , Request To Close thread.