[Request] easy way to add lines to skilldata_35000enc

[MissinGDeaTh]

as title said i want easy way to add lines to skilldata_35000enc
because i try every guide on epvpers, and still get crashed after launching the client + i can't add any new stuff to my server w/o knowing how to add lines to
skilldata_35000enc


and i want to limit guild members for 20 or 25 players and union to only 2 guilds
it that's possiple ?

[Crue*]

about skilldata_xxenc
use this program.

 Spoiler

Guild/union limit

 Spoiler

[MissinGDeaTh]

Originally Posted by Crue*

about skilldata_xxenc
use this program.

 Spoiler

Guild/union limit

 Spoiler

i tryed it before, if it worked for me i wouldn't post a thread here :/

[Syloxx]

double click the error msg and fix the problem

[WickedNite.]

Originally Posted by MissinGDeaTh

i tryed it before, if it worked for me i wouldn't post a thread here :/

lazy people can't fix anything.

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_Guild_FnAddMember] Script Date: 01/22/2015 10:12:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO




ALTER PROCEDURE [dbo].[_Guild_FnAddMember]
@guildID int,
@MemberID int,
@MemberClass tinyint,
@joinDate smalldatetime,
@permission int

as
Declare @LiMiT int = '31' -- << Userr Limit Credits by $Apollo
if (exists (select CharID from _GuildMember where CharID = @MemberID))
begin
return -1001
end


declare @MemberName varchar(64)
declare @curLevel tinyint
select @MemberName = CharName16, @curLevel = CurLevel from _Char with (nolock) where CharID = @MemberID
if (@@error <> 0 or @@rowcount = 0)
begin
return -1
end
if (exists (select CharID from _GuildMember with (nolock) where GuildID = @guildID and CharID = @MemberID))
begin
return -2
end

declare @ReFObjID int
select @ReFObjID = RefObjID from _Char with (nolock) where CharID = @MemberID

if (@@error <> 0 or @@rowcount = 0)
begin
return -5
end

[MissinGDeaTh]

Originally Posted by Crue*

about skilldata_xxenc
use this program.

 Spoiler

Guild/union limit

 Spoiler

can you tell me if this lines are wrong ?! cuz am getting client crashed -_-

1 귀환서 사용전 SKILL_MALL_STATS_POINT_RECALL_A_KARA 0 FALSE 0 DEFAULT none none none none none none none none 0 0,0,0,0 ONE none none none none none none none 0 1
귀환서 사용전 SKILL_MALL_STATS_POINT_RECALL_A_KARA ACT_S 0 FALSE none none 0 0 0 0 1 0,0 AT_LOOP MOV_NONE,0,0,0 0,0,0 false,0,0,0,0,false system\ item_returnscroll.efp none 0,0,0 none 0,0,0 none 0 none none none

[WickedNite.]

Originally Posted by MissinGDeaTh

can you tell me if this lines are wrong ?! cuz am getting client crashed -_-

Those are skilleffect lines...

[MissinGDeaTh]

Originally Posted by TheWickedNite

Those are skilleffect lines...

ye i know, but it crashes my client at loading ..

[WickedNite.]

Originally Posted by MissinGDeaTh

ye i know, but it crashes my client at loading ..

They're not supposed to be added in skilldataenc.

[MissinGDeaTh]

Originally Posted by TheWickedNite

They're not supposed to be added in skilldataenc.

I thought the error was in skilldataenc, but it was not, so am now asking for these lines in skilleffect, because it crashes the CLIENT. and i didn't want to start a new topic for that :/

[Little Messi]

Originally Posted by TheWickedNite

lazy people can't fix anything.

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_Guild_FnAddMember] Script Date: 01/22/2015 10:12:09 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO




ALTER PROCEDURE [dbo].[_Guild_FnAddMember]
@guildID int,
@MemberID int,
@MemberClass tinyint,
@joinDate smalldatetime,
@permission int

as
Declare @LiMiT int = '31' -- << Userr Limit Credits by $Apollo
if (exists (select CharID from _GuildMember where CharID = @MemberID))
begin
return -1001
end


declare @MemberName varchar(64)
declare @curLevel tinyint
select @MemberName = CharName16, @curLevel = CurLevel from _Char with (nolock) where CharID = @MemberID
if (@@error <> 0 or @@rowcount = 0)
begin
return -1
end
if (exists (select CharID from _GuildMember with (nolock) where GuildID = @guildID and CharID = @MemberID))
begin
return -2
end

declare @ReFObjID int
select @ReFObjID = RefObjID from _Char with (nolock) where CharID = @MemberID

if (@@error <> 0 or @@rowcount = 0)
begin
return -5
end

this query canceled the whole guild function in the server, i can't CREATE guild or join another player to my guild.

[WickedNite.]

Originally Posted by Little Messi

this query canceled the whole guild function in the server, i can't CREATE guild or join another player to my guild.

Then you suck, you're supposed to use this in guild_fn_member ****