how to find item in server

01/21/2015 23:07 vengards#1
hey guys

i want to know

how to find item in server

explian

i want to know how many sword fight ingame

anyone can give me the query ?
01/22/2015 14:48 Aaron*#2
use this query
Quote:
use sro_vt_shard

Select Count(*) from _Inventory where RefItemID in (select id from _Refobjcommon where codename128 like 'ITEM_CH_SWORD_11_SET_B_RARE')
01/22/2015 16:55 ​Exo#3
Quote:
Originally Posted by Jocs View Post
use this query
-_- _Inventory doesn't even have a RefItemID column.
The ItemID there refers to ID64 @ _Items
01/22/2015 17:05 Aaron*#4
Quote:
Originally Posted by xExorcist View Post
-_- _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