How to Change Magic Pop Ratio to specified value?

06/06/2019 06:56 salemdahmen1#1
Hello everyone!

Im looking to change magic pop rates, i found some query on the internet, but its not really helping, its more like global changing of all the table value.

Exemple of Query that i found:
Code:
USE [SRO_VT_SHARD]
GO
/* MsSQL Script For Change Magic Pop Rates - CEZALAND - ! ******** ! */
DECLARE [MENTION=1720025]Rate[/MENTION] int
SET [MENTION=1720025]Rate[/MENTION] = 10
UPDATE dbo._RefGachaItemSet SET Ratio = Ratio [MENTION=1720025]Rate[/MENTION] WHERE Ratio [MENTION=1720025]Rate[/MENTION] < 32768 -- 32767 max value for smallint
Im looking to change the rate of items to value like 20%, 10% or 5%...
Any Idea how to do that ? thanks !