Vsro files - SOX drop rates

09/17/2011 20:13 zilvis69#1
Couldn't find the answer for this problem , so i'm posting this here.
Does anyone know how to change SOX drop rate?
My item drop rate is 50 and i killed thousands of mobs and i didn't have any SOX drop.Does anyone have the same problem ?Any idea how to fix this?(and yes , i cracked my drop rate limit with OllyDbg )
09/18/2011 07:57 cosmin_cezar#2
Still need a answer!
11/18/2011 14:04 HuN_SzabeE#3
This Is a High SOX Rate
PHP Code:
USE [SRO_VT_SHARD_INIT]
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_CH%RARE'
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_EU%RARE'
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_CH%RARE%'
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_EU%RARE%' 
11/18/2011 14:24 phobos16#4
"Common SET Rarity=" is there where i put the number of rate?
11/24/2011 18:38 fami#5
can somebody tell a good value for the sox rates?
rarity = 3 seems to be too high..
and how can i use

USE [SRO_VT_SHARD_INIT]
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_CH%RARE'
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_EU%RARE'
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_CH%RARE%'
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_EU%RARE%'
this script? update my table with rightclick on the table -> update?
11/24/2011 18:57 Dr.Abdelfattah#6
Quote:
Originally Posted by fami View Post
can somebody tell a good value for the sox rates?
rarity = 3 seems to be too high..
and how can i use

USE [SRO_VT_SHARD_INIT]
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_CH%RARE'
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_EU%RARE'
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_CH%RARE%'
UPDATE dbo._RefObjCommon SET Rarity=3 WHERE CodeName128 LIKE 'ITEM_EU%RARE%'
this script? update my table with rightclick on the table -> update?
open new query in ur sql management studio and paste this in SRO_VT_SHARD database and click execute .