Setting maxed Runes / Editing <Binary Data> in SQL server

[KeelzYou]

After searching and stuff I thought I would be nice and post this for those of you having trouble editing the binary data. This thread will pretty much be a 2-in-1 guide thread.

/****** Replace everything with the corresponding values you want  ******/
UPDATE table_name 
SET field_name=name
WHERE field_name_filter=value

Here's an example which is pretty much the 2nd part of the guide: Adding basic runes to a character.

In the Server DB go to [cabal_soul_ability_table] right click -> "Edit Top1000 Rows" then find the CharacterIDx you want to edit.

Open a new query and copy the code for your class type that I put at the bottom of this post.

End outcome should be like this:

/****** Script for Magic Users  ******/
UPDATE [dbo].[cabal_soul_ability_table] 
SET PassiveAbilityData=0x45090000030007AB9F0600000F000000A6060000030002009C060000070004009E06000007000C009D06000007000E00A40600000F000900A00600000F000C0046090000050027A9A30600000C00DDA7A20600000C000300A906000004000000
WHERE CharacterIdx=CharID goes here

/****** Script for Sword Users  ******/
UPDATE [dbo].[cabal_soul_ability_table] 
SET PassiveAbilityData=0xA8060000040007AB45090000030007AB9F0600000F000000A606000003000200A10600000C0027A99C060000070004009E06000007000C009D06000007000E00A40600000F000900A00600000F000C0046090000050027A9A30600000C00DDA7
WHERE CharacterIdx=CharID goes here

 

[li198306]

Good~~~~~
why? Don't have UPDATE 2 level

 

[KeelzYou]

Good~~~~~
why? Don't have UPDATE 2 level

I don't understand what you mean?

 

[S37uP!Update]

Nice guide.

 

[Drav3n]

does it include the blended runes too?

 

[KeelzYou]

does it include the blended runes too?

No, blended runes are stored in BlendedAbilityData not PassiveAbilityData.

 

[Tmxx Rush]

Nice ! I have probs with adding starter items to all new char but my think this solve my prob after i woke up and work on it Thanks a lot !!

 

[laukinfai001]

why i sql no show 2 binary data eg..0X0000000000000

 

[MhieYhang]

After searching and stuff I thought I would be nice and post this for those of you having trouble editing the binary data. This thread will pretty much be a 2-in-1 guide thread.

/****** Replace everything with the corresponding values you want  ******/
UPDATE table_name 
SET field_name=name
WHERE field_name_filter=value

Here's an example which is pretty much the 2nd part of the guide: Adding basic runes to a character.

In the Server DB go to [cabal_soul_ability_table] right click -> "Edit Top1000 Rows" then find the CharacterIDx you want to edit.

Open a new query and copy the code for your class type that I put at the bottom of this post.

End outcome should be like this:

/****** Script for Magic Users  ******/
UPDATE [dbo].[cabal_soul_ability_table] 
SET PassiveAbilityData=0x45090000030007AB9F0600000F000000A6060000030002009C060000070004009E06000007000C009D06000007000E00A40600000F000900A00600000F000C0046090000050027A9A30600000C00DDA7A20600000C000300A906000004000000
WHERE CharacterIdx=CharID goes here

/****** Script for Sword Users  ******/
UPDATE [dbo].[cabal_soul_ability_table] 
SET PassiveAbilityData=0xA8060000040007AB45090000030007AB9F0600000F000000A606000003000200A10600000C0027A99C060000070004009E06000007000C009D06000007000E00A40600000F000900A00600000F000C0046090000050027A9A30600000C00DDA7
WHERE CharacterIdx=CharID goes here

awesome, let me try this thing .. hehe :w00t:

 

[Tryout]

sorry for bumping but how to set it as automatic directly to new character?

 

[S37uP!Update]

sorry for bumping but how to set it as automatic directly to new character?

Create Trigger:

Set
PassiveAbilityData=0xA8060000040007AB45090000030007AB9F0600000F000000A606000003000200A10600000C0027A99C060000070004009E06000007000C009D06000007000E00A40600000F000900A00600000F000C0046090000050027A9A30600000C00DDA7
Where
PassiveAbilityData=0x

 

[ShadowGohan]

Create Trigger:

Set
PassiveAbilityData=0xA8060000040007AB45090000030007AB9F0600000F000000A606000003000200A10600000C0027A99C060000070004009E06000007000C009D06000007000E00A40600000F000900A00600000F000C0046090000050027A9A30600000C00DDA7
Where
PassiveAbilityData=0x

That implies that the user of the code has the exact same rune levels & id's existing/wants to add those specific ones with those specific levels

Understanding how the runes work, which ones are you actually adding sounds a little more efficient (not to start an argument over it or anything, I'm just saying that it might avoid having more questions after than before trying to do what the person has asked for)

An easy way to find out how it works would be activating a single rune on the character, a quick relog on the character and then selecting the data from within the database table

The first digits being the id of the rune (dec > hex/hex > dec - might want to look up little-/big endian on a side note), the data is stored in a fairly simple way, length of the rune data as well as the rest of it may be important to those planning to add more levels to the runes as well.

 

[Aerox009x]

after i put the code i got error Msg 208, Level 16, State 1, Line 2Invalid object name 'dbo.cabal_soul_ability_table'.

 

[DarkMage]

after i put the code i got error Msg 208, Level 16, State 1, Line 2Invalid object name 'dbo.cabal_soul_ability_table'.

It should work, tried it many times.