[Release] Alchemy lucky rate edit

[Mdarude]

Hello i made a small edit on the alchemy luck rate so people don't need a tool for it again this is a EDIT of a other code.

this query is build up in 2 sections.
1. Lucky rate connect to the elixirs (( the once i use in my DB ))
2. the Lucky powders (( also the once i use in my DB ))

for the people who are new:
Parm2 1-4
Parm3 5-8
Parm4 9-12
Parm5 13-16
Parm6 17-20

USE [SRO_VT_SHARD]

-- Define the maximum value representing 100% luck rate
DECLARE @MaxValue INT = 1684300900;

-- Define luck rates as percentages (Change these values as needed)
DECLARE @Param2_Elixers_Percent FLOAT = 0.10;  -- 10% luck rate for Param2
DECLARE @Param3_Elixers_Percent FLOAT = 0.05;  -- 5% luck rate for Param3
DECLARE @Param4_Elixers_Percent FLOAT = 0.01;  -- 1% luck rate for Param4
DECLARE @Param5_Elixers_Percent FLOAT = 0.50;  -- 50% luck rate for Param5
DECLARE @Param6_Elixers_Percent FLOAT = 1.00;  -- 100% luck rate for Param6

DECLARE @Param2_ProbUp_Percent FLOAT = 0.15;  -- 15% luck rate for Param2
DECLARE @Param3_ProbUp_Percent FLOAT = 0.10;  -- 10% luck rate for Param3
DECLARE @Param4_ProbUp_Percent FLOAT = 0.05;  -- 5% luck rate for Param4
DECLARE @Param5_ProbUp_Percent FLOAT = 0.00;  -- 0% luck rate for Param5
DECLARE @Param6_ProbUp_Percent FLOAT = 0.00;  -- 0% luck rate for Param6

-- Convert percentages to luck values for Elixirs
DECLARE @Param2_Elixers INT = CAST(@MaxValue * @Param2_Elixers_Percent AS INT);
DECLARE @Param3_Elixers INT = CAST(@MaxValue * @Param3_Elixers_Percent AS INT);
DECLARE @Param4_Elixers INT = CAST(@MaxValue * @Param4_Elixers_Percent AS INT);
DECLARE @Param5_Elixers INT = CAST(@MaxValue * @Param5_Elixers_Percent AS INT);
DECLARE @Param6_Elixers INT = CAST(@MaxValue * @Param6_Elixers_Percent AS INT);

-- Convert percentages to luck values for Prob Up items
DECLARE @Param2_ProbUp INT = CAST(@MaxValue * @Param2_ProbUp_Percent AS INT);
DECLARE @Param3_ProbUp INT = CAST(@MaxValue * @Param3_ProbUp_Percent AS INT);
DECLARE @Param4_ProbUp INT = CAST(@MaxValue * @Param4_ProbUp_Percent AS INT);
DECLARE @Param5_ProbUp INT = CAST(@MaxValue * @Param5_ProbUp_Percent AS INT);
DECLARE @Param6_ProbUp INT = CAST(@MaxValue * @Param6_ProbUp_Percent AS INT);

-- Update luck rates for the 4 specific Elixir items
UPDATE _RefObjItem 
SET Param2 = @Param2_Elixers, 
    Param3 = @Param3_Elixers, 
    Param4 = @Param4_Elixers, 
    Param5 = @Param5_Elixers, 
    Param6 = @Param6_Elixers 
WHERE ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 IN (
    'ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_WEAPON_B',
    'ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_SHIELD_B',
    'ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_ARMOR_B',
    'ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_ACCESSARY_B'));

-- Update luck rates for the 12 specific Prob Up items
UPDATE _RefObjItem 
SET Param2 = @Param2_ProbUp, 
    Param3 = @Param3_ProbUp, 
    Param4 = @Param4_ProbUp, 
    Param5 = @Param5_ProbUp, 
    Param6 = @Param6_ProbUp 
WHERE ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_%');

I am also looking for people with the same mindset to make most things DB related and true a filter.

If you want to help me or have some ideas feel free to send me a Message or contact me on Discord. i am no pro and new to all of this so do not make it to complicated i want to keep it easy and simple.

and again have fun with the code !!!

[cristianxi]

Good, Keep Sharing

[hoangphan7]

idk what will happends. But all alchemy success rate after 12+ are the same

[Mdarude]

Originally Posted by hoangphan7

idk what will happends. But all alchemy success rate after 12+ are the same

0% in this will fail however in the calculations the lucky rate of lucky stones/premium/dress and other lucky things are not included.

so in that context it is still possible to go higher then +12 on my test server i am actually testing the rates up to +10 now since i am going to change these things on my main server soon :-)

if you want you could contact me on discord and help me see what happens after +12 since i dont have the time for it at this moment.

[Worshiper]

GOOD WORK

[janicka]

Originally Posted by hoangphan7

idk what will happends. But all alchemy success rate after 12+ are the same

Are you sure?

[hoangphan7]

Originally Posted by janicka

Are you sure?

Im sure. do you tested?
In param5 elixir armor and accessory, it not alchemy rate. if you change it, you can't mix Armor and Access EU item.
Easily test it. You made Param4 100% success rate (9-12). After 12+ always have 100% success rate.

[AligatorSniper]

Hello, I can't find you on Discord, how can I talk to you?
Mdarude

[johnnydung]

thanks