[Release] MsSQL Script for change Magic Pop rates

[RevoLand]

Hi to all RZ users...
i got idea from "Artuuro_lv" and i made it
Use that script for change Magic Pop rates

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

i think 10x enough rate but you can edit this rate
Script created by me - do not re-relase under your name or your site !
And remember - giving thanks will back you with more usefull script

[MentaL]

[Chern0byl]

Just a little thingy, isn't 32767 int at mssql ? Since it's signed integer, it's 2 bytes (16 bit ofc), it should be between -32768, and 32767. Bigint is -65535 - 65535 as far as i remember. That's how it is on mssql 2000, not sure about 2k5/2k8, huh ?

[RevoLand]

Just a little thingy, isn't 32767 int at mssql ? Since it's signed integer, it's 2 bytes (16 bit ofc), it should be between -32768, and 32767. Bigint is -65535 - 65535 as far as i remember. That's how it is on mssql 2000, not sure about 2k5/2k8, huh ?

i tested manually on Microsoft SQL Server Managament Studio (2005 - 64bit) and max value for "smallint" not "int"

--
okay i got message

[Dragonzee]

nice work

keep it up

[Murgy]

Doesn't this also increase the rate of failing and getting other items, I did this once on my own about a month ago, failed more than before.

[ac777]

Which table is responsible for the drop rate of quest items?

[arabcart]

Hi to all RZ users...
i got idea from "Artuuro_lv" and i made it
Use that script for change Magic Pop rates

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

i think 10x enough rate but you can edit this rate
Script created by me - do not re-relase under your name or your site !
And remember - giving thanks will back you with more usefull script

thanks Bro

[Artuuro_lv]

yeah, this one wont work.. it also increases the failing rate :D
so basically you're just multiplying the values but not increasing the rates at all, they will remain the same.

what i did to my magic pop:

update _RefGachaItemSet set Ratio = Ratio*10 where Ratio < '1000'

That increased the pop rates by 10 on all the best items there but didnt increase the fail items for me because failing items (scrolls & other shit) has rate 1000+ while the others has rates 15-...

[Murgy]

Yeah, thats what I did also to fix it ^^

[ahmed_ahmed9889]

can u tell me gow to do this script

mean do in database from mysql

srry but not know yet how to restore script or doit in mysql 2005

[asuradoll]

Hi to all RZ users...
i got idea from "Artuuro_lv" and i made it
Use that script for change Magic Pop rates

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

i think 10x enough rate but you can edit this rate
Script created by me - do not re-relase under your name or your site !
And remember - giving thanks will back you with more usefull script

Thank you for share, it's working!

[Statiic]

thanks!

[Yamaxanadu]

You could also make a script where the Rates of items with Set_ID = 1 get changed only.. (Set_ID = 1 : win, Set_ID = 2 : fail)...

Just a little hint.

[zieon]

nice dude

[modog1545]

Pls help
When did it become everyone gets Nova of the first time!!
I want returned to what it was Normal :(

now when i tray do this

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

i get (0 row(s) affected)

pls i wan back it to normal helllp :(