[Realese]Fix +++ Rate [Work For D1~15]

[geomangy011]

Hello
How Are You Guy's
Now I realese My Query To Change + Rate
Im Searching Alot For Query Make That
But All Of The Queries Which Realesed From D1 To D12.
So If Your Server D13 , D14 Or D15
It Will Very Helpful For You :D
-----------------
first The Query

USE [SRO_VT_SHARD]
----------------------------Made By [Dev]LegendKnight----------------------------
DECLARE  [MENTION=795725]Legend[/MENTION]KNIGHT1 VARCHAR (129)
DECLARE  [MENTION=795725]Legend[/MENTION]KNIGHT2 VARCHAR (129)
DECLARE  [MENTION=795725]Legend[/MENTION]KNIGHT3 VARCHAR (129)
DECLARE  [MENTION=795725]Legend[/MENTION]KNIGHT4 VARCHAR (129)
DECLARE  [MENTION=795725]Legend[/MENTION]KNIGHT5 VARCHAR (129)
DECLARE  [MENTION=795725]Legend[/MENTION]KNIGHT6 VARCHAR (129)

SET  [MENTION=795725]Legend[/MENTION]KNIGHT1 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_B_13'
SET  [MENTION=795725]Legend[/MENTION]KNIGHT2 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_B_14'
SET  [MENTION=795725]Legend[/MENTION]KNIGHT3 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_B_15'
SET  [MENTION=795725]Legend[/MENTION]KNIGHT4 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_13'
SET  [MENTION=795725]Legend[/MENTION]KNIGHT5 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_14'
SET  [MENTION=795725]Legend[/MENTION]KNIGHT6 = 'ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_15'

Declare @D15x2 int SET @D15x2 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 =  [MENTION=795725]Legend[/MENTION]KNIGHT6)
Declare @D13 int SET @D13 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 =  [MENTION=795725]Legend[/MENTION]KNIGHT1)
Declare @D14 int SET @D14 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 =  [MENTION=795725]Legend[/MENTION]KNIGHT2)
Declare @D15 int SET @D15 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 =  [MENTION=795725]Legend[/MENTION]KNIGHT3)
Declare @D13x2 int SET @D13x2 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 =  [MENTION=795725]Legend[/MENTION]KNIGHT4)
Declare @D14x2 int SET @D14x2 = (SELECT LINK FROM _RefObjCommon WHERE CodeName128 =  [MENTION=795725]Legend[/MENTION]KNIGHT5)

UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='1347110450' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='1347110450' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='1347110450' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='1347110450' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='1347110450' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='1347110450' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='1347110450' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='1347110450' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='1347110450' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='1347110450' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='1347110450' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='1347110450' where ID='2044'
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='1347110450' where ID= @D13
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='1347110450' where ID= @D14
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='1347110450' where ID= @D15
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='1347110450' where ID= @D13x2
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='1347110450' where ID= @D14x2
UPDATE [dbo].[_RefObjItem] set Param2='1684300900',Param3='1684298325',Param4='1347110450' where ID= @D15x2 

And This Is Alachmy Calculator
This Is Not By Me He Is Realesed Before But I Make New Download Link For You :D

http://files.fm/u/azllimm
Make Your %%%% By This Program
And But The Params At The Query To Make Your + What You Want

[Note]The % Of +12 = The Same Of +13 ~ +250

Thx
And Sorry For Bad English.
[Dev]LegendKnight.

If I See Alot's Of Members Need Query To Change NPC Place And Another One To Change Teleport Place I Will Realese It.

- - - Updated - - -

Hello
How Are You Guy's
Now I realese My Query To Change + Rate
Im Searching Alot For Query Make That
But All Of The Queries Which Realesed From D1 To D12.
So If Your Server D13 , D14 Or D15
It Will Very Helpful For You :D
-----------------
first The Query

http://legendworld-online.com/+Rate%5BBy%5D%5BDev%5DLegendKnight.txt 

And This Is Alachmy Calculator
This Is Not By Me He Is Realesed Before But I Make New Download Link For You :D

http://files.fm/u/azllimm
Make Your %%%% By This Program
And But The Params At The Query To Make Your + What You Want

[Note]The % Of +12 = The Same Of +13 ~ +250

Thx
And Sorry For Bad English.
[Dev]LegendKnight

[MentaL]

[Free2DoM]

ThX Bro

[B1QB0SS]

so it's too hard to ADD A New Lucky Powder RefObjItem ID From "13~15" in the old released query ?

[geomangy011]

Ty :D

- - - Updated - - -

so it's too hard to ADD A New Lucky Powder RefObjItem ID From "13~15" in the old released query ?

It's Easy For You
Not Easy For All .

[NourAyman]

facepalm .

[Master Opera]

ty

[LeMbo]

[[fakss]] <----

[BadFist]

relay....
look here more easy

USE [SRO_VT_SHARD]
UPDATE _RefObjItem SET Param2 = 840832008, Param3 = 134744072, Param4 = 134744072 WHERE ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE '%PROB_UP_A%')

this are 1x and also what you give are +1~+4=100% +5~+8=100% +9=80% +10=75% +11=70% +12=50%

[nandyyto]

Thanks bro