I need to change the rate of alchemy Csro-r D12 D13 D14 ?

zalo0944172680 · 04/16/2020, 20:46

I need to change the rate of alchemy Csro-r D12 D13 D14 .... I don't know which table it is in Database, please show me, thank you very much!

[GM]Ardoris · 04/16/2020, 21:14

try this I think will work with you

<3

Code:

   USE [SHARD NAME ]
----------------------------Made By [GM]Ardoris----------------------------
DECLARE  [MENTION=1880717]LegendKnight[/MENTION]1 VARCHAR (129)
DECLARE  [MENTION=1880717]LegendKnight[/MENTION]2 VARCHAR (129)
DECLARE  [MENTION=1880717]LegendKnight[/MENTION]3 VARCHAR (129)
DECLARE  [MENTION=1880717]LegendKnight[/MENTION]4 VARCHAR (129)
DECLARE  [MENTION=1880717]LegendKnight[/MENTION]5 VARCHAR (129)
DECLARE  [MENTION=1880717]LegendKnight[/MENTION]6 VARCHAR (129)

SET  [MENTION=1880717]LegendKnight[/MENTION]1 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_B_13'
SET  [MENTION=1880717]LegendKnight[/MENTION]2 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_B_14'
SET  [MENTION=1880717]LegendKnight[/MENTION]3 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_B_15'
SET  [MENTION=1880717]LegendKnight[/MENTION]4 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_13'
SET  [MENTION=1880717]LegendKnight[/MENTION]5 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_14'
SET  [MENTION=1880717]LegendKnight[/MENTION]6 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_15'

Declare @D15x2 int SET @D15x2 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 =  [MENTION=1880717]LegendKnight[/MENTION]6)
Declare  [MENTION=1906554]d13[/MENTION] int SET  [MENTION=1906554]d13[/MENTION] = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 =  [MENTION=1880717]LegendKnight[/MENTION]1)
Declare @D14 int SET @D14 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 =  [MENTION=1880717]LegendKnight[/MENTION]2)
Declare @D15 int SET @D15 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 =  [MENTION=1880717]LegendKnight[/MENTION]3)
Declare  [MENTION=1906554]d13[/MENTION]x2 int SET  [MENTION=1906554]d13[/MENTION]x2 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 =  [MENTION=1880717]LegendKnight[/MENTION]4)
Declare @D14x2 int SET @D14x2 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 =  [MENTION=1880717]LegendKnight[/MENTION]5)

UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2044'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID=  [MENTION=1906554]d13[/MENTION]
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID= @D14
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID= @D15
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID=  [MENTION=1906554]d13[/MENTION]x2
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID= @D14x2
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID= @D15x2

zalo0944172680 · 04/16/2020, 23:42

Quote:

Originally Posted by [GM]Ardoris

try this I think will work with you

<3

Code:

   USE [SHARD NAME ]
----------------------------Made By [GM]Ardoris----------------------------
DECLARE  [MENTION=1880717]LegendKnight[/MENTION]1 VARCHAR (129)
DECLARE  [MENTION=1880717]LegendKnight[/MENTION]2 VARCHAR (129)
DECLARE  [MENTION=1880717]LegendKnight[/MENTION]3 VARCHAR (129)
DECLARE  [MENTION=1880717]LegendKnight[/MENTION]4 VARCHAR (129)
DECLARE  [MENTION=1880717]LegendKnight[/MENTION]5 VARCHAR (129)
DECLARE  [MENTION=1880717]LegendKnight[/MENTION]6 VARCHAR (129)

SET  [MENTION=1880717]LegendKnight[/MENTION]1 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_B_13'
SET  [MENTION=1880717]LegendKnight[/MENTION]2 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_B_14'
SET  [MENTION=1880717]LegendKnight[/MENTION]3 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_B_15'
SET  [MENTION=1880717]LegendKnight[/MENTION]4 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_13'
SET  [MENTION=1880717]LegendKnight[/MENTION]5 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_14'
SET  [MENTION=1880717]LegendKnight[/MENTION]6 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_15'

Declare @D15x2 int SET @D15x2 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 =  [MENTION=1880717]LegendKnight[/MENTION]6)
Declare  [MENTION=1906554]d13[/MENTION] int SET  [MENTION=1906554]d13[/MENTION] = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 =  [MENTION=1880717]LegendKnight[/MENTION]1)
Declare @D14 int SET @D14 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 =  [MENTION=1880717]LegendKnight[/MENTION]2)
Declare @D15 int SET @D15 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 =  [MENTION=1880717]LegendKnight[/MENTION]3)
Declare  [MENTION=1906554]d13[/MENTION]x2 int SET  [MENTION=1906554]d13[/MENTION]x2 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 =  [MENTION=1880717]LegendKnight[/MENTION]4)
Declare @D14x2 int SET @D14x2 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 =  [MENTION=1880717]LegendKnight[/MENTION]5)

UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID='2044'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID=  [MENTION=1906554]d13[/MENTION]
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID= @D14
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID= @D15
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID=  [MENTION=1906554]d13[/MENTION]x2
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID= @D14x2
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1679057930',Param4='839123201' where ID= @D15x2

sorry, it only works for VSRO, I'm looking for the alchemy rate of CSRO-R D12 D13 D14 .... hope someone will find it and share it

[GM]Ardoris · 04/17/2020, 05:49

Quote:

Originally Posted by zalo0944172680

sorry, it only works for VSRO, I'm looking for the alchemy rate of CSRO-R D12 D13 D14 .... hope someone will find it and share it

You need to change something name of your item try change name of item

senol44 · 04/22/2022, 20:28

leo2111 · 04/28/2022, 23:30

Quote:

Originally Posted by senol44

ALCHEMY +12 MORE CSRO-R

0066D22D | 3C 0F | cmp al,C | (SRO CLIENT OFFSET)

00533895 | 8079 2C 0F | cmp bayt ptr ds:[ecx+2C],C (GAMESERVER.EXE OFFSET)

but he's looking for the ratio, not the max plus I guess

senol44 · 04/29/2022, 07:54

Quote:

Originally Posted by leo2111

but he's looking for the ratio, not the max plus I guess

hello bro i tried it is working relax relax

meymeygila · 04/29/2022, 15:05

Quote:

Originally Posted by senol44

hello bro i tried it is working relax relax

what to do with the bytes? nop it? cmp means comparison in asm.

leo2111 · 05/02/2022, 17:38

Quote:

Originally Posted by senol44

hello bro i tried it is working relax relax

Are you blind or stupid?

```
I need to change the rate of alchemy Csro-r D12 D13 D14 .... I don't know which table it is in Database, please show me, thank you very much!
```
He's not asking how to break the alchemy plus limit ( which is set to 12, yeah), he's asking for the ratio, succeed ratio
There is a default table in the shard database, which stores the success ratios for enhancers, awakening and proof stones.

Quote:

Originally Posted by zalo0944172680

I need to change the rate of alchemy Csro-r D12 D13 D14 .... I don't know which table it is in Database, please show me, thank you very much!

There is a table called _RefItemUpgradeNReinforceRatio
in the shard database, where joymax stores customized ratios for all types of enhancers, awakening stones and proof stones (Level Deduction -1 and Opt level),
but it's not fully customized , like for each type of sox , each type of degree and so on
it's customized just for the enhancer typeID's
For example, if you try on d12 magic weapon +1 , you will have the same success ratio as for d15 legend weapon , same goes for plus, you will have the same success ratio for +12 as if you would try +1 because d12 weapon enhancer and d15 weapon enhancer got the same typeID's therefore same success ratio
poorly coded overall , but better than nothing

Cyrillus Rigid · 06/09/2022, 15:48

Quote:

Originally Posted by leo2111

Are you blind or stupid?

```
I need to change the rate of alchemy Csro-r D12 D13 D14 .... I don't know which table it is in Database, please show me, thank you very much!
```
He's not asking how to break the alchemy plus limit ( which is set to 12, yeah), he's asking for the ratio, succeed ratio
There is a default table in the shard database, which stores the success ratios for enhancers, awakening and proof stones.

There is a table called _RefItemUpgradeNReinforceRatio
in the shard database, where joymax stores customized ratios for all types of enhancers, awakening stones and proof stones (Level Deduction -1 and Opt level),
but it's not fully customized , like for each type of sox , each type of degree and so on
it's customized just for the enhancer typeID's
For example, if you try on d12 magic weapon +1 , you will have the same success ratio as for d15 legend weapon , same goes for plus, you will have the same success ratio for +12 as if you would try +1 because d12 weapon enhancer and d15 weapon enhancer got the same typeID's therefore same success ratio
poorly coded overall , but better than nothing

+1