[Help]Want To Change Magic Pop Rate

I Want Change Magic Pop Rate but dont give me this Query

Quote:

---

USE [SRO_VT_SHARD]
GO
/* MsSQL Script For Change Magic Pop Rates - CEZALAND - ! ******** ! */
DECLARE @Rate int
SET @Rate = 10
UPDATE dbo._RefGachaItemSet SET Ratio = Ratio*@Rate WHERE Ratio*@Rate < 32768 -- 32767 max value for smallint

---

Or This Query

Quote:

---

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%';

---

I Want make it Manual Or Give me new Query and video Turital cuz i am tired :(

first query

rate 100%

new query

Quote:

---

USE [SRO_VT_SHARD]
GO
/* MsSQL Script For Change Magic Pop Rates - CEZALAND - ! ******** ! */
DECLARE @Rate int
SET @Rate = 100
UPDATE dbo._RefGachaItemSet SET Ratio = Ratio*@Rate WHERE Ratio*@Rate < 32768 -- 32767 max value for smallint

---