[Request] easy way to add lines to skilldata_35000enc

01/22/2015 02:22 MissinGDeaTh#1
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 ?
01/22/2015 09:12 Crue*#2
about skilldata_xxenc
use this program.

Guild/union limit
01/22/2015 09:47 MissinGDeaTh#3
Quote:
Originally Posted by Crue* View Post
about skilldata_xxenc
use this program.

Guild/union limit
[Only registered and activated users can see links. Click Here To Register...]

i tryed it before, if it worked for me i wouldn't post a thread here :/
01/22/2015 10:09 Syloxx#4
double click the error msg and fix the problem
01/22/2015 10:12 WickedNite.#5
Quote:
Originally Posted by MissinGDeaTh View Post
[Only registered and activated users can see links. Click Here To Register...]

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
01/22/2015 19:10 MissinGDeaTh#6
Quote:
Originally Posted by Crue* View Post
about skilldata_xxenc
use this program.

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


Quote:
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
01/22/2015 19:44 WickedNite.#7
Quote:
Originally Posted by MissinGDeaTh View Post
can you tell me if this lines are wrong ?! cuz am getting client crashed -_-
Those are skilleffect lines...
01/22/2015 19:54 MissinGDeaTh#8
Quote:
Originally Posted by TheWickedNite View Post
Those are skilleffect lines...
ye i know, but it crashes my client at loading ..
01/22/2015 20:05 WickedNite.#9
Quote:
Originally Posted by MissinGDeaTh View Post
ye i know, but it crashes my client at loading ..
They're not supposed to be added in skilldataenc.
01/22/2015 20:16 MissinGDeaTh#10
Quote:
Originally Posted by TheWickedNite View Post
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 :/
01/24/2015 20:31 Little Messi#11
Quote:
Originally Posted by TheWickedNite View Post
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.
01/24/2015 20:53 WickedNite.#12
Quote:
Originally Posted by Little Messi View Post
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 shit