Increase SOX rate

RedWoman · 03/13/2017, 12:50

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?

Muhab* · 03/13/2017, 16:46

Yeah it's good, But you can replace 4 with a declared variable so you can edit the value easily.

tmfpkendrick21 · 03/15/2017, 12:43

This query has never worked regardless of what number I've used.

RedWoman · 03/18/2017, 03:50

Quote:

Originally Posted by tmfpkendrick21

This query has never worked regardless of what number I've used.

so what query did work?

uwn · 03/19/2017, 19:17

Quote:

Originally Posted by NanoKid

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 @

INT
SET @

= 10 -- Here we set the multiplier value! Default: 10 // by Artuuro_lv (rz)/Miki Maus (epvp)
update _RefDropClassSel_RareEquip set ProbGroup1 = ProbGroup1 @

update _RefDropClassSel_RareEquip set ProbGroup2 = ProbGroup2 @

update _RefDropClassSel_RareEquip set ProbGroup3 = ProbGroup3 @

update _RefDropClassSel_RareEquip set ProbGroup4 = ProbGroup4 @

update _RefDropClassSel_RareEquip set ProbGroup5 = ProbGroup5 @

update _RefDropClassSel_RareEquip set ProbGroup6 = ProbGroup6 @

update _RefDropClassSel_RareEquip set ProbGroup7 = ProbGroup7 @

update _RefDropClassSel_RareEquip set ProbGroup8 = ProbGroup8 @

update _RefDropClassSel_RareEquip set ProbGroup9 = ProbGroup9 @

update _RefDropClassSel_RareEquip set ProbGroup10 = ProbGroup10 @

update _RefDropClassSel_RareEquip set ProbGroup11 = ProbGroup11 @

update _RefDropClassSel_RareEquip set ProbGroup12 = ProbGroup12 @

update _RefDropClassSel_RareEquip set ProbGroup13 = ProbGroup13 @

update _RefDropClassSel_RareEquip set ProbGroup14 = ProbGroup14 @

update _RefDropClassSel_RareEquip set ProbGroup15 = ProbGroup15 @

update _RefDropClassSel_RareEquip set ProbGroup16 = ProbGroup16 @

update _RefDropClassSel_RareEquip set ProbGroup17 = ProbGroup17 @

update _RefDropClassSel_RareEquip set ProbGroup18 = ProbGroup18 @

update _RefDropClassSel_RareEquip set ProbGroup19 = ProbGroup19 @

update _RefDropClassSel_RareEquip set ProbGroup20 = ProbGroup20 @

update _RefDropClassSel_RareEquip set ProbGroup21 = ProbGroup21 @

update _RefDropClassSel_RareEquip set ProbGroup22 = ProbGroup22 @

update _RefDropClassSel_RareEquip set ProbGroup23 = ProbGroup23 @

update _RefDropClassSel_RareEquip set ProbGroup24 = ProbGroup24 @

update _RefDropClassSel_RareEquip set ProbGroup25 = ProbGroup25 @

update _RefDropClassSel_RareEquip set ProbGroup26 = ProbGroup26 @

update _RefDropClassSel_RareEquip set ProbGroup27 = ProbGroup27 @

update _RefDropClassSel_RareEquip set ProbGroup28 = ProbGroup28 @

update _RefDropClassSel_RareEquip set ProbGroup29 = ProbGroup29 @

update _RefDropClassSel_RareEquip set ProbGroup30 = ProbGroup30 @

update _RefDropClassSel_RareEquip set ProbGroup31 = ProbGroup31 @

tmfpkendrick21 · 03/19/2017, 22:04

okay whats the best number for this ? Used it when it came out saw no increase. If anything I saw less.