Increase SOX rate

03/13/2017 12:50 RedWoman#1
Hello everyone, I've built the next query to increase sox rate.
PHP Code:
USE [SRO_VT_SHARD]
GO

update _RefDropClassSel_RareEquip set ProbGroup1 = (ProbGroup1 * 4)
update _RefDropClassSel_RareEquip set ProbGroup2 = (ProbGroup2 * 4)
update _RefDropClassSel_RareEquip set ProbGroup3 = (ProbGroup3 * 4)
update _RefDropClassSel_RareEquip set ProbGroup4 = (ProbGroup4 * 4)
update _RefDropClassSel_RareEquip set ProbGroup5 = (ProbGroup5 * 4)
update _RefDropClassSel_RareEquip set ProbGroup6 = (ProbGroup6 * 4)
update _RefDropClassSel_RareEquip set ProbGroup7 = (ProbGroup7 * 4)
update _RefDropClassSel_RareEquip set ProbGroup8 = (ProbGroup8 * 4)
update _RefDropClassSel_RareEquip set ProbGroup9 = (ProbGroup9 * 4)
update _RefDropClassSel_RareEquip set ProbGroup10 = (ProbGroup10 * 4)
update _RefDropClassSel_RareEquip set ProbGroup11 = (ProbGroup11 * 4)
update _RefDropClassSel_RareEquip set ProbGroup12 = (ProbGroup12 * 4)
update _RefDropClassSel_RareEquip set ProbGroup13 = (ProbGroup13 * 4)
update _RefDropClassSel_RareEquip set ProbGroup14 = (ProbGroup14 * 4)
update _RefDropClassSel_RareEquip set ProbGroup15 = (ProbGroup15 * 4)
update _RefDropClassSel_RareEquip set ProbGroup16 = (ProbGroup16 * 4)
update _RefDropClassSel_RareEquip set ProbGroup17 = (ProbGroup17 * 4)
update _RefDropClassSel_RareEquip set ProbGroup18 = (ProbGroup18 * 4)
update _RefDropClassSel_RareEquip set ProbGroup19 = (ProbGroup19 * 4)
update _RefDropClassSel_RareEquip set ProbGroup20 = (ProbGroup20 * 4)
update _RefDropClassSel_RareEquip set ProbGroup21 = (ProbGroup21 * 4)
update _RefDropClassSel_RareEquip set ProbGroup22 = (ProbGroup22 * 4)
update _RefDropClassSel_RareEquip set ProbGroup23 = (ProbGroup23 * 4)
update _RefDropClassSel_RareEquip set ProbGroup24 = (ProbGroup24 * 4)
update _RefDropClassSel_RareEquip set ProbGroup25 = (ProbGroup25 * 4)
update _RefDropClassSel_RareEquip set ProbGroup26 = (ProbGroup26 * 4)
update _RefDropClassSel_RareEquip set ProbGroup27 = (ProbGroup27 * 4)
update _RefDropClassSel_RareEquip set ProbGroup28 = (ProbGroup28 * 4)
update _RefDropClassSel_RareEquip set ProbGroup29 = (ProbGroup29 * 4)
update _RefDropClassSel_RareEquip set ProbGroup30 = (ProbGroup30 * 4)
update _RefDropClassSel_RareEquip set ProbGroup31 = (ProbGroup31 * 4)
update _RefDropClassSel_RareEquip set ProbGroup32 = (ProbGroup32 * 4)
update _RefDropClassSel_RareEquip set ProbGroup33 = (ProbGroup33 * 4)
update _RefDropClassSel_RareEquip set ProbGroup34 = (ProbGroup34 * 4)
update _RefDropClassSel_RareEquip set ProbGroup35 = (ProbGroup35 * 4)
update _RefDropClassSel_RareEquip set ProbGroup36 = (ProbGroup36 * 4) 
is that solution is good?
03/13/2017 16:46 Muhab*#2
Yeah it's good, But you can replace 4 with a declared variable so you can edit the value easily.
03/15/2017 12:43 tmfpkendrick21#3
This query has never worked regardless of what number I've used.
03/18/2017 03:50 RedWoman#4
Quote:
Originally Posted by tmfpkendrick21 View Post
This query has never worked regardless of what number I've used.
so what query did work?
03/19/2017 19:17 uwn#5
Quote:
Originally Posted by NanoKid View Post
so what query did work?
your query work just any time u want change values you need edit all lines
use that1 and just change value 1 time.

USE SRO_VT_SHARD
DECLARE @[Only registered and activated users can see links. Click Here To Register...] INT
SET @[Only registered and activated users can see links. Click Here To Register...] = 10 -- Here we set the multiplier value! Default: 10 // by Artuuro_lv (rz)/Miki Maus (epvp)
update _RefDropClassSel_RareEquip set ProbGroup1 = ProbGroup1 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup2 = ProbGroup2 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup3 = ProbGroup3 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup4 = ProbGroup4 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup5 = ProbGroup5 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup6 = ProbGroup6 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup7 = ProbGroup7 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup8 = ProbGroup8 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup9 = ProbGroup9 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup10 = ProbGroup10 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup11 = ProbGroup11 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup12 = ProbGroup12 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup13 = ProbGroup13 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup14 = ProbGroup14 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup15 = ProbGroup15 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup16 = ProbGroup16 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup17 = ProbGroup17 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup18 = ProbGroup18 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup19 = ProbGroup19 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup20 = ProbGroup20 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup21 = ProbGroup21 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup22 = ProbGroup22 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup23 = ProbGroup23 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup24 = ProbGroup24 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup25 = ProbGroup25 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup26 = ProbGroup26 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup27 = ProbGroup27 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup28 = ProbGroup28 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup29 = ProbGroup29 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup30 = ProbGroup30 @[Only registered and activated users can see links. Click Here To Register...]
update _RefDropClassSel_RareEquip set ProbGroup31 = ProbGroup31 @[Only registered and activated users can see links. Click Here To Register...]
03/19/2017 22:04 tmfpkendrick21#6
okay whats the best number for this ? Used it when it came out saw no increase. If anything I saw less.