Giving all skills upon char logout in map

[xteslaz]

Aight so, you might know what I'm talking about when you've played Falou or Velika.

You choose your prestige class (eg. glad/knight) in one map, you go to the next map, and then relog, when you log back in you have all skills for your prestige class.

So my question is, how can I do this properly? (don't say SQL, I know it has something to do with p_Char_Logout procedure.)


Thanks in advance

[MentaL]

[Kevx96]

USE [w00_Character]
GO
/****** Object: StoredProcedure [dbo].[p_Char_Logout] Script Date: 02.10.2016 21:42:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/****** 개체: 저장 프로시저 dbo.p_Char_Logout 스크립트 날짜: 2007-03-13 오후 6:25:10 ******/




ALTER PROCEDURE [dbo].[p_Char_Logout]
/*
Character logout
2004.6 By CJC
Input:
nCharNo = To be logout
nPlayMin = Play minute at this time
output:
0 = error
1 = work ok
*/


@nCharNo int,
@nPlayMin int,
@nRet int OUTPUT
AS
SET NOCOUNT ON
UPDATE tCharacter
SET nPlayMin = nPlayMin + @nPlayMin
WHERE nCharNo = @nCharNo
SET @nRet = @@ROWCOUNT
Delete from dbo.LoggedInChars where nCharNo = @nCharNo
BEGIN
DECLARE @nLevel INT
DECLARE @nClass INT


SELECT @nLevel = nLevel FROM tCharacter WHERE nCharNo = @nCharNo


-- Only if level == 2
IF @nLevel = 2
BEGIN
&alllearnskill
CLOSE db_cursor
DEALLOCATE db_cursor
END
END
-- end

[xteslaz]

USE [w00_Character]
GO
/****** Object: StoredProcedure [dbo].[p_Char_Logout] Script Date: 02.10.2016 21:42:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/****** 개체: 저장 프로시저 dbo.p_Char_Logout 스크립트 날짜: 2007-03-13 오후 6:25:10 ******/




ALTER PROCEDURE [dbo].[p_Char_Logout]
/*
Character logout
2004.6 By CJC
Input:
nCharNo = To be logout
nPlayMin = Play minute at this time
output:
0 = error
1 = work ok
*/


@nCharNo int,
@nPlayMin int,
@nRet int OUTPUT
AS
SET NOCOUNT ON
UPDATE tCharacter
SET nPlayMin = nPlayMin + @nPlayMin
WHERE nCharNo = @nCharNo
SET @nRet = @@ROWCOUNT
Delete from dbo.LoggedInChars where nCharNo = @nCharNo
BEGIN
DECLARE @nLevel INT
DECLARE @nClass INT


SELECT @nLevel = nLevel FROM tCharacter WHERE nCharNo = @nCharNo


-- Only if level == 2
IF @nLevel = 2
BEGIN
&alllearnskill
CLOSE db_cursor
DEALLOCATE db_cursor
END
END
-- end

kys.

Anyone that can actually help?

[Amanecer]

There might be another way to do this. But I don't recommend it as it is very time consuming. If you open the DefaultCharacterData.txt (located in the Shine folder) and scroll down to to the SKILL section. You can define a class and which skill (ID used in ActiveSkill/PassiveSkill) the character learns. I never tried it myself but it should also work that way.

[xteslaz]

There might be another way to do this. But I don't recommend it as it is very time consuming. If you open the DefaultCharacterData.txt (located in the Shine folder) and scroll down to to the SKILL section. You can define a class and which skill (ID used in ActiveSkill/PassiveSkill) the character learns. I never tried it myself but it should also work that way.

That won't give skills according to prestige class.

Verstuurd vanaf mijn SM-G900F met Tapatalk

[Myth]

The benefit of coding a filter is that you could give everybody admin powers without them knowing, and on a prestige, simply send the server &learnskill commands on that players behalf.

That's the only efficient solution that comes to mind, it'd be more beneficial in the end as well since you could easily filter out nasty packets/extend that further to do other modifications client-side.

Other than the above, LSQ is the only way. SQL