Simple query to help you adding a new skill

[Mr.Awesome1337]

Recently, I've been adding skills and it was boring searching the slot manually, it really was, so I thought of creating a new query to help me with that using SkillCode from Textdata_Equip&Skill so I created a procedure to do the job, here it is

Procedure, execute it anywhere:

Create Procedure _AddNewSkill
@SkillName varchar(max)
as
begin
Declare @NewSkillID bigint = (Select max (ID)+1 from SRO_VT_SHARD.._RefSkill)
Declare @NewSkillGroupID bigint = (Select max (ID)+1 from SRO_VT_SHARD.._RefSkillGroup)
Declare @NewSlot int = (Select max (UI_SkillRow)+1 from SRO_VT_SHARD.._RefSkill where UI_SkillName = @SkillName and UI_SkillRow < 255 and UI_SkillTab < 255)
Declare @SkillExists varchar (max) = (Select TOP 1 UI_SkillName from SRO_VT_SHARD.._RefSkill where UI_SkillName = @SkillName)
if (@NewSlot < 8 and @SkillExists is not null)
begin
Select TOP 1 @NewSkillID as NewSkillID,@NewSkillGroupID as NewGroupID,ReqCommon_Mastery1,ReqLearn_Race,UI_SkillTab,UI_SkillPage,UI_SkillColumn,@NewSlot as NewUI_SkillRow from SRO_VT_SHARD.._RefSkill where UI_SkillName = @SkillName
end
else if (@NewSlot >= 7 and @SkillExists is not null)
begin
print 'No more slots available on this column'
end
else if (@SkillExists is null)
begin
print 'This skillname does not exist'
end
end

Usage:

Exec _AddNewSkill 'SN_SKILL_EU_WARRIOR_ONEHANDA_STRIKE_A'

Result:

Note: you don't have to select the latest skill on the column, any skill should be fine


Note #2: Remember 0 = slot number 1
Thanks to @$$

[hoangphan7]

Nothing query can help you! You should find slot with your eyes, it's better!
If your @SkillName does not exists, nothing selected
This query usefull to add new level to old skill.
btw. keep going :-)

[Mr.Awesome1337]

Originally Posted by hoangphan7

Nothing query can help you! You should find slot with your eyes, it's better!
If your @SkillName does not exists, nothing selected
This query usefull to add new level to old skill.
btw. keep going :-)

SkillName should be the same as UI_SkillName in _RefSkill unless someone changed it in Skilldataenc and didn't change it in _RefSkill, people doesn't do that usually anyways, thank you.

[hoangphan7]

Originally Posted by Mr.Awesome1337

SkillName should be the same as UI_SkillName in _RefSkill unless someone changed it in Skilldataenc and didn't change it in _RefSkill, people doesn't do that usually anyways, thank you.

What do you mean "new skill"? Your database always don't have "new skill" if you want to add new one which dont in your database. Your query dont working fine! :-)

[Mr.Awesome1337]

Originally Posted by hoangphan7

What do you mean "new skill"? Your database always don't have "new skill" if you want to add new one which dont in your database. Your query dont working fine! :-)

I think you didn't get my point, let me give you an example
If you want to add a new passive such as a passive skill to give eu 20% inc/abs to make it more balanced, you will have to search manually for the Purify skill and check its column and row and etc so you get to know the new position of the new skill that you want to add, this query does exactly that, it gives you a new skill position that you are free to use to add your new passive skill to latest possible square to the skillcodename you provided, got it?

[hoangphan7]

Originally Posted by Mr.Awesome1337

I think you didn't get my point, let me give you an example
If you want to add a new passive such as a passive skill to give eu 20% inc/abs to make it more balanced, you will have to search manually for the Purify skill and check its column and row and etc so you get to know the new position of the new skill that you want to add, this query does exactly that, it gives you a new skill position that you are free to use to add your new passive skill to latest possible square to the skillcodename you provided, got it?

No no :-) Your new skill mean official skill from isro, ksro ..etc...
My new skill mean "real new skill" like this pictures :-)
You can easily count slot skill with your eyes like this!
Count left to right and up to down... from 0 to 1,2,3...

[Mr.Awesome1337]

Originally Posted by hoangphan7

No no :-) Your new skill mean official skill from isro, ksro ..etc...
My new skill mean "real new skill" like this pictures :-)
You can easily count slot skill with your eyes like this!
Count left to right and up to down... from 0 to 1,2,3...

Yes you can do it by your eyes, but not everyone can do this, even the query is a way faster and there is no place for mistaking and this one called "new mastery"

[XxGhostSpiriTxX]

Thanks For Shared Bro!

[Mr.Awesome1337]

Originally Posted by esteve458

Thanks For Shared Bro!

uw

[@$$]

Remember 0= slot number 1

[Mr.Awesome1337]

Originally Posted by @$$

Remember 0= slot number 1

thanks for this note