Release magic pop query

09/08/2012 16:43 JuliaRocks*#1

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%

09/08/2012 16:44 FoxRayz#2

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

09/08/2012 16:45 JuliaRocks*#3

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

Quote:

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

01/27/2024 01:16 johnnydung#4

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

01/27/2024 20:03 newenzel#5

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

02/08/2024 14:56 Tirex88#6

cool ty

02/15/2024 02:43 NoxusOnline#7

thanks for share

02/25/2024 17:11 abosliem1#8

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

02/25/2024 18:59 _HouseMusicx3#9

Quote:

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?

02/26/2024 11:02 Devsome#10

Quote:

Originally Posted by abosliem1

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

Quote:

Originally Posted by _HouseMusicx3

Eh the release is 12 years old?

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

:confused::confused:

#closed