Myth Reborn GM Mastery

[Media.]

Didn't see it anywhere else copied and released from Myth Reborn, and although it's useless it's still amusing stuff.



The mastery has pretty funny skills such as a massive kill skill, a long teleport (just like ghost walk), annoying overpowered debuffs, cure & co., disguise and of course a 1000% speed increase skill.

 Small Guide

All the necessary stuff and lines are included in the .rar file.

Copy'n'paste the skill lines from the gmskill.txt into the RefSkill table, and replace the ID's.

Afterwards add the sole skill code's in to the RefSkillGroup table.

 RefSkillGroup

Then adjust the ID from the RefSkillGroup table with the GroupID in the RefSkill table (also do that in the gmskill.txt).

 RefSkill

Of course you gotta add the mastery itself as well, therefore just add it in the RefSkillMastery table, the ID is 289.

 RefSkillMastery

That's pretty much everything for the database, all the client sided stuff (skilleffect, skillgroup, skillmasterydata, text stuff, icon's & efp's) is included in the .rar file and just has to be add to your client, so no explanation necessary I assume.

In order to add the mastery to your character simply add the mastery ID to your character in the CharSkillMastery table and either teleport or relog.
Don't forget, the ID is 289.

 CharSkillMastery

As already mentioned the credits belong to the Myth Reborn folks.

[bares1993]

nice one...

maybe you have myth reborn client for upload ?

[Blue-Phoenix]

nice thread

thanks.

[tj66257297]

Thank you, brother, thanks for sharing

[thebigbody]

done added
thx very much

 Spoiler

[Dallin¥]

let's help those gm's a lil bit okay i just make a lil query that's will open the mastery just for gm's characters all of you have to do use this query you can edit the 'skill id' part to your skill id that's it

 Spoiler

USE [sro_vt_log]
GO
/****** Object: StoredProcedure [dbo].[_AddLogChar] Script Date: 9/21/2014 7:15:15 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER procedure [dbo].[_AddLogChar]
@CharID int,
@EventID tinyint,
@Data1 int,
@Data2 int,
@strPos varchar(64),
@Desc varchar(128)
as
IF (@CharID IN (select charid from SRO_VT_SHARD.._User with (nolock) where UserJID in (select JID from SRO_VT_ACCOUNT..TB_User with (nolock) where sec_content in (1,11))))
BEGIN

if not exists (select charid from SRO_VT_SHARD.._CharSkillMastery where CharID = @CharID and MasteryID = 289)
begin
insert into SRO_VT_SHARD.._CharSkillMastery values (@CharID, 289, 1)
insert into SRO_VT_SHARD.dbo._CharSkill (CharID,SkillID,[Enable]) values (@CharID,'skill id',1)
insert into SRO_VT_SHARD.dbo._CharSkill (CharID,SkillID,[Enable]) values (@CharID,'skill id',1)
insert into SRO_VT_SHARD.dbo._CharSkill (CharID,SkillID,[Enable]) values (@CharID,'skill id',1)
insert into SRO_VT_SHARD.dbo._CharSkill (CharID,SkillID,[Enable]) values (@CharID,'skill id',1)
insert into SRO_VT_SHARD.dbo._CharSkill (CharID,SkillID,[Enable]) values (@CharID,'skill id',1)
insert into SRO_VT_SHARD.dbo._CharSkill (CharID,SkillID,[Enable]) values (@CharID,'skill id',1)
insert into SRO_VT_SHARD.dbo._CharSkill (CharID,SkillID,[Enable]) values (@CharID,'skill id',1)
insert into SRO_VT_SHARD.dbo._CharSkill (CharID,SkillID,[Enable]) values (@CharID,'skill id',1)
end
end

IF(
(@EventID NOT BETWEEN 23 AND 27) AND
(@EventID NOT BETWEEN 200 AND 202) AND
(@EventID NOT BETWEEN 204 AND 206) AND
(@EventID != 210) AND (@EventID != 214) AND (@EventID != 244) and (@EventID != 21)
)
begin
declare @len_pos int
declare @len_desc int
select @len_pos = len(@strPos),
@len_desc = len(@Desc)
if (@len_pos > 0 and @len_desc > 0)
begin
insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, EventPos, strDesc) values (@CharID, GetDate(), @EventID, @Data1, @Data2, @strPos, @Desc)
end
else if (@len_pos > 0 and @len_desc = 0)
begin
insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, EventPos, strDesc) values(@CharID, GetDate(), @EventID, @Data1, @Data2, @strPos, @Desc)
end
else if (@len_pos = 0 and @len_desc > 0)
begin
insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, strDesc) values(@CharID, GetDate(), @EventID, @Data1, @Data2, @Desc)
end
else
begin
insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2) values(@CharID, GetDate(), @EventID, @Data1, @Data2)
end
end

[Syloxx]

Originally Posted by M̷r̷.̷X̷

let's help those gm's a lil bit okay i just make a lil query that's will open the mastery just for gm's characters all of you have to do use this query you can edit the 'skill id' part to your skill id that's it

 Spoiler

USE [sro_vt_log]
GO
/****** Object: StoredProcedure [dbo].[_AddLogChar] Script Date: 9/21/2014 7:15:15 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


ALTER procedure [dbo].[_AddLogChar]
@CharID int,
@EventID tinyint,
@Data1 int,
@Data2 int,
@strPos varchar(64),
@Desc varchar(128)
as
IF (@CharID IN (select charid from SRO_VT_SHARD.._User with (nolock) where UserJID in (select JID from SRO_VT_ACCOUNT..TB_User with (nolock) where sec_content in (1,11))))
BEGIN

if not exists (select charid from SRO_VT_SHARD.._CharSkillMastery where CharID = @CharID and MasteryID = 289)
begin
insert into SRO_VT_SHARD.._CharSkillMastery values (@CharID, 289, 1)
insert into SRO_VT_SHARD.dbo._CharSkill (CharID,SkillID,[Enable]) values (@CharID,'skill id',1)
insert into SRO_VT_SHARD.dbo._CharSkill (CharID,SkillID,[Enable]) values (@CharID,'skill id',1)
insert into SRO_VT_SHARD.dbo._CharSkill (CharID,SkillID,[Enable]) values (@CharID,'skill id',1)
insert into SRO_VT_SHARD.dbo._CharSkill (CharID,SkillID,[Enable]) values (@CharID,'skill id',1)
insert into SRO_VT_SHARD.dbo._CharSkill (CharID,SkillID,[Enable]) values (@CharID,'skill id',1)
insert into SRO_VT_SHARD.dbo._CharSkill (CharID,SkillID,[Enable]) values (@CharID,'skill id',1)
insert into SRO_VT_SHARD.dbo._CharSkill (CharID,SkillID,[Enable]) values (@CharID,'skill id',1)
insert into SRO_VT_SHARD.dbo._CharSkill (CharID,SkillID,[Enable]) values (@CharID,'skill id',1)
end
end

IF(
(@EventID NOT BETWEEN 23 AND 27) AND
(@EventID NOT BETWEEN 200 AND 202) AND
(@EventID NOT BETWEEN 204 AND 206) AND
(@EventID != 210) AND (@EventID != 214) AND (@EventID != 244) and (@EventID != 21)
)
begin
declare @len_pos int
declare @len_desc int
select @len_pos = len(@strPos),
@len_desc = len(@Desc)
if (@len_pos > 0 and @len_desc > 0)
begin
insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, EventPos, strDesc) values (@CharID, GetDate(), @EventID, @Data1, @Data2, @strPos, @Desc)
end
else if (@len_pos > 0 and @len_desc = 0)
begin
insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, EventPos, strDesc) values(@CharID, GetDate(), @EventID, @Data1, @Data2, @strPos, @Desc)
end
else if (@len_pos = 0 and @len_desc > 0)
begin
insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2, strDesc) values(@CharID, GetDate(), @EventID, @Data1, @Data2, @Desc)
end
else
begin
insert _LogEventChar (CharID, EventTime, EventID, Data1, Data2) values(@CharID, GetDate(), @EventID, @Data1, @Data2)
end
end

your query will executed on every log event... and that's useless

and please use inner joins next time...



_AddNewChar




Why i add my code as IMG?

I don't like copy paste so write this query with your own hands maybe u´ll understand this query then

[Dallin¥]

Originally Posted by Syloxx

your query will executed on every log event... and that's useless

and please use inner joins next time...



_AddNewChar




Why i add my code as IMG?

I don't like copy paste so write this query with your own hands maybe u´ll understand this query then

it was a quickly query and both will going to work fine

[asanoftw]

helpful, thanks meh, xd

[where_love2003]

Look

[Hamza FiGo]

Again the **** file Skilleffect. i`m sure of it



Ty fixed and worked 100%

[Bocc1337]

ya man nice i like it. anything to make my DB worth more money hehe

What i really want are the 140 cap mastery skills. any one have?

[atooooon]

thank you

[Bocc1337]

anyone tell me why i get this problem? and if i try to go up on any of the skills not showing i get crash.

[where_love2003]

Originally Posted by sonsof2004

anyone tell me why i get this problem? and if i try to go up on any of the skills not showing i get crash.

i got this problem
but its fixed
its by ID skills