Alchmey Rate

revldo1 · 07/30/2016, 01:22

i want 1~3=100% 3~5=50% 5~7=20% 7~10=5% 10~12=1%

cristianxi · 07/30/2016, 03:05

PHP Code:



USE [SRO_VT_SHARD] 
UPDATE _RefObjItem  
SET Param2 = 1684288050, Param3 = 840176645, Param4 = 84214017  
WHERE ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE '%PROB_UP_B%')

Enjoy !

rares495 · 07/30/2016, 11:45

Here's a useful tool for alchemy params.

Set the % for each plus and then press File and Encrypt. Then all you have to do is copy the params into the DB.

Lelouch9 · 07/31/2016, 20:26

use this program

then use this query
USE [SRO_VT_SHARD_INIT]
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2044'