Query HELP!

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

PHP Code:

---

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

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 ?

Quote:

---

Originally Posted by 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 ?

---

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

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

Quote:

---

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

---

Quote:

---

Originally Posted by 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

---

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

- - - Updated - - -

Quote:

---

Originally Posted by RenePunik

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

PHP Code:

---

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.