Release magic pop query

[JuliaRocks*]

PHP Code:

USE [big]
GO
DECLARE @Rate int
SET @Rate = 1000
UPDATE dbo._RefGachaItemSet SET Ratio = Ratio*@Rate WHERE Ratio*@Rate < 32768 -- 32767 max value for smallint 


SET@Rate = 1000 = 100x (1 card 1 win)
SET@Rate = 100 = 10x (5-8 cards 1 win)
And so
Credits : Myself
EDIT : Tested on 1-10 Degree !
31 Cards succeed 4 cards failed from 35 cards.
2000 Would be like 200%

[FoxRayz]

Hi thanks for the release but as far as i know this QUERY is already released here.

[JuliaRocks*]

If you want 100% for 11Degree,you should try SET@RATE = 1100 or higher.

Originally Posted by FoxRayz

Hi thanks for the release but as far as i know this QUERY is already released here.

Maby but it's for 10x.
People think setrate 100 = 100x

[johnnydung]

I tried this query but it doesn't work for items from D8-D11, can you share another query with me?

[newenzel]

great contribution , I think moving it to the Coding corner would be much more useful!

[Tirex88]

cool ty

[NoxusOnline]

thanks for share

[abosliem1]

Hi thanks for the release but as far as i know this QUERY is already released here.

[_HouseMusicx3]

Originally Posted by abosliem1

Hi thanks for the release but as far as i know this QUERY is already released here.

Eh the release is 12 years old?

[Devsome]

Originally Posted by abosliem1

Hi thanks for the release but as far as i know this QUERY is already released here.

Originally Posted by _HouseMusicx3

Eh the release is 12 years old?

as _HouseMusicx3 already answered, this release is 12 years old abosliem1



#closed