Quote:
Originally Posted by xExorcist
-_- _Inventory doesn't even have a RefItemID column.
The ItemID there refers to ID64 @ _Items
|
I meant ItemID. sorry i read it wrong.
this query should work.
Quote:
USE SRO_VT_SHARD
go
declare @ItemCode varchar(max) = 'ITEM_CODE
declare @ItemID int = (select id from _Refobjcommon where codename128 like @ItemCode)
Select count (*) from _Items where RefItemID like @ItemID
|
this query result will be : how many (specified item) exist on the players inventories.
Sorry again i was tired when i wrote the first query xD