Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
You last visited: Today at 08:01

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



how to find item in server

Discussion on how to find item in server within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Nov 2014
Posts: 48
Received Thanks: 6
how to find item in server

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 ?
vengards is offline  
Old 01/22/2015, 14:48   #2

 
elite*gold: 77
Join Date: Jan 2015
Posts: 1,314
Received Thanks: 856
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')
Aaron* is offline  
Old 01/22/2015, 16:55   #3


 
​Exo's Avatar
 
elite*gold: 28
Join Date: Aug 2014
Posts: 4,096
Received Thanks: 2,649
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
​Exo is offline  
Old 01/22/2015, 17:05   #4

 
elite*gold: 77
Join Date: Jan 2015
Posts: 1,314
Received Thanks: 856
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
Aaron* is offline  
Reply


Similar Threads Similar Threads
Cannot find item by 0
05/29/2014 - Metin2 Private Server - 2 Replies
Wie der Titel schon sagt habe ich dieses problem. Es trat aber erst auf nach dem ich diesen swishbot eingebaut habe. http://www.elitepvpers.com/forum/metin2-hacks-bot s-cheats-exploits-macros/2078969-release-switchbot -like-darealfreak.html Das script schaut so aus import chat import item import net import player import shop
I need Bot Find item can??
06/26/2009 - Ragnarok Online - 1 Replies
someone can help me?? give me bOt can hunt item... i wan make quest so hard... Send me at [email protected] i hope u is kind man :rolleyes:
how to find ID of a item
05/30/2008 - Conquer Online 2 - 4 Replies
I know how to find ID of an item but how do i find an ID of an item in inventory? is there something that can tell me the ID of the moonbox in my inventory? beacuse i looked there are about 30 different IDs just for moonbox maybe it has to do with each different ID have a certian type of item inside. Let me know I will figure out which ID have sockets and let you guys know. I have 40 moonboxes in my inventory i want to find out the differnet ID for each one and open them slowly and i will...



All times are GMT +1. The time now is 08:01.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.