[Release] Magic Pop X2 Query

[lucas7575]

Hi guys, i have made a Query for MSQL that Updates every row in the table "_RefGachaItemSet" setting all the ratios to X2.

USE [SRO_VT_SHARD]
UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '3000', '6000')
WHERE Ratio LIKE '3000%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '2400', '4800')
WHERE Ratio LIKE '2400%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '2100', '4200')
WHERE Ratio LIKE '2100%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '1500', '3000')
WHERE Ratio LIKE '1500%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '1200', '2400')
WHERE Ratio LIKE '1200%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '1000', '2000')
WHERE Ratio LIKE '1000%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '250', '500')
WHERE Ratio LIKE '250%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '25', '50')
WHERE Ratio LIKE '25%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '16', '32')
WHERE Ratio LIKE '16%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '8', '16')
WHERE Ratio LIKE '8%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '5', '10')
WHERE Ratio LIKE '5%';

If you want to change the ratio, you should change this line "replace(Ratio, '3000', '6000')" where it says "6000" for example if you want X3 you should change the 6000 for 9000 and so. I hope this will be useful for you guys

[MentaL]

[saxz]

usefull for noobs ^^

[nuocda]

WHERE Ratio LIKE '5%';

LOL, isn't 5%

[AkiraLee]

in magic pop 60000should be 60% 6000 should be 6% 600 should be 0.6% etc

[Dragonzee]

no

idk what its mean

cuz i tried to put 500 on staff it may success in 2nd time and higher one was 10

i dont know how its going this rates :S

[lucas7575]

LOL, isn't 5%

No, that "%" that you saw there is just part of the script to define the search of the string, it doesn't means that it indicates the percentage of the succes ratio. what i actually urdestand the ratio is: 10000/100%

[LastThief]

LOL, isn't 5%

read about LIKE in mssql manual

[ahmed_ahmed9889]

thx

i try it and for gdf (gold dragon flag) at frist time

and staff d11 not succes :D

i use 20 card and nothing

thx anyway :D