SUBSTACK PROBLEM

[Lantus]

Hi everyone. I have this problem when I take a subckas. I can do the subclass but the skilles are replaced by the new class. I want to keep the skilles from the class before plus the new class.

How can I do that?

[Nevermind25]

You can't use

myself::ClassChange(talker, Class_ID); 

That will give problems in collision, critical errors, etc

 

The better way to do it its selling the Subclass Quest "mimir's Elixir" in other NPC and then make the subclasses in the master. 

Now, how to stack skills? its simple, modify the lin_getaquireskill procedure on your lin2world database.  

[mjst]

CREATE TABLE [SubStack](
	[char_id] [int] NOT NULL DEFAULT 0,
	[baseClass0] [int] NOT NULL DEFAULT -1,
	[baseClass1] [int] NOT NULL DEFAULT -1,
	[baseClass2] [int] NOT NULL DEFAULT -1,
	[baseClass3] [int] NOT NULL DEFAULT -1,
	[stackClass0] [int] NOT NULL DEFAULT -1,
	[stackClass1] [int] NOT NULL DEFAULT -1,
	[stackClass2] [int] NOT NULL DEFAULT -1,
	[stackClass3] [int] NOT NULL DEFAULT -1
) ON [PRIMARY]

GO

CREATE PROCEDURE lin_SaveSubStack
(
 @charId INT,
 @classIndex INT,
 @baseClass INT,
 @stackClass INT
)
AS
SET NOCOUNT ON;

IF @classIndex = 0
BEGIN
	UPDATE [SubStack] SET [baseClass0] = @baseClass, [stackClass0] = @stackClass WHERE [char_id] = @charId
	IF @@ROWCOUNT=0
	BEGIN
		INSERT INTO [SubStack] ([char_id], [baseClass0], [stackClass0] ) VALUES (@charId, @baseClass, @stackClass )
	END
END
ELSE IF @classIndex = 1
BEGIN
	UPDATE [SubStack] SET [baseClass1] = @baseClass, [stackClass1] = @stackClass WHERE [char_id] = @charId
	IF @@ROWCOUNT=0
	BEGIN
		INSERT INTO [SubStack] ([char_id], [baseClass1], [stackClass1] ) VALUES (@charId, @baseClass, @stackClass )
	END
END
ELSE IF @classIndex = 2
BEGIN
	UPDATE [SubStack] SET [baseClass2] = @baseClass, [stackClass2] = @stackClass WHERE [char_id] = @charId
	IF @@ROWCOUNT=0
	BEGIN
		INSERT INTO [SubStack] ([char_id], [baseClass2], [stackClass2] ) VALUES (@charId, @baseClass, @stackClass )
	END
END
ELSE IF @classIndex = 3
BEGIN
	UPDATE [SubStack] SET [baseClass3] = @baseClass, [stackClass3] = @stackClass WHERE [char_id] = @charId
	IF @@ROWCOUNT=0
	BEGIN
		INSERT INTO [SubStack] ([char_id], [baseClass3], [stackClass3] ) VALUES (@charId, @baseClass, @stackClass )
	END
END

GO

 

Edited September 11, 2019 by Majestic12

[sandeagle]

VIA extender or AI scripts.check Vang's source or some substack scripts

[Nevermind25]

what are you using? explain better to help you

[Lantus]

1 hour ago, Nevermind25 said:

what are you using? explain better to help you

 I`m using Vang`s pack. Sorry if my english is not so good but It`s not my first language. I`m trying my best.

I`m gonna check what SANDEAGLE told me, but to be honest I don`t really know where I have to look at. So, I will check out everything in AI.OBJ

[Lantus]

10 hours ago, sandeagle said:

VIA extender or AI scripts.check Vang's source or some substack scripts

Here we go. I`found this entry in the AI.OBJ in CLASS_CHANGE. Please tell me if I`m right and if It`s the case where I have to change. Thanks a lot

 

class 1 class_change : citizen { parameter: string fnHi = "class_change_start.htm"; string fnHi2 = "class_change_grats.htm"; handler: EventHandler TALKED( talker ) { myself::ShowPage( talker, fnHi ); return; } EventHandler MENU_SELECTED( ask, reply, talker ) { if( ask == 3 && reply == 3 ) { if( myself::IsInCategory( @third_class_group, talker.occupation ) == 1 ) { if( talker.level >= 76 ) { if( talker.occupation == @gladiator ) { myself::ClassChange( talker, @duelist ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @warlord ) { myself::ClassChange( talker, @dreadnought ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @paladin ) { myself::ClassChange( talker, @phoenix_knight ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @dark_avenger ) { myself::ClassChange( talker, @hell_knight ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @treasure_hunter ) { myself::ClassChange( talker, @adventurer ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @hawkeye ) { myself::ClassChange( talker, @sagittarius ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @sorcerer ) { myself::ClassChange( talker, @archmage ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @necromancer ) { myself::ClassChange( talker, @soultaker ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @warlock ) { myself::ClassChange( talker, @arcana_lord ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @bishop ) { myself::ClassChange( talker, @cardinal ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @prophet ) { myself::ClassChange( talker, @hierophant ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @temple_knight ) { myself::ClassChange( talker, @evas_templar ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @swordsinger ) { myself::ClassChange( talker, @sword_muse ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @plains_walker ) { myself::ClassChange( talker, @wind_rider ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @silver_ranger ) { myself::ClassChange( talker, @moonlight_sentinel ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @spellsinger ) { myself::ClassChange( talker, @mystic_muse ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @elemental_summoner ) { myself::ClassChange( talker, @elemental_master ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @elder ) { myself::ClassChange( talker, @evas_saint ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @shillien_knight ) { myself::ClassChange( talker, @shillien_templar ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @bladedancer ) { myself::ClassChange( talker, @spectral_dancer ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @abyss_walker ) { myself::ClassChange( talker, @ghost_hunter ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @phantom_ranger ) { myself::ClassChange( talker, @ghost_sentinel ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @spellhowler ) { myself::ClassChange( talker, @storm_screamer ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @phantom_summoner ) { myself::ClassChange( talker, @spectral_master ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @shillien_elder ) { myself::ClassChange( talker, @shillien_saint ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @destroyer ) { myself::ClassChange( talker, @titan ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @tyrant ) { myself::ClassChange( talker, @grand_khavatari ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @overlord ) { myself::ClassChange( talker, @dominator ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @warcryer ) { myself::ClassChange( talker, @doomcryer ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @bounty_hunter ) { myself::ClassChange( talker, @fortune_seeker ); myself::ShowPage( talker, fnHi2 ); return; } else if( talker.occupation == @warsmith ) { myself::ClassChange( talker, @maestro ); myself::ShowPage( talker, fnHi2 ); return; } } } } else if( ask == 303 ) { myself::ShowMultisell( reply, talker ); return; } } }

[l2daniel]

in_getaquireskill procedure on your lin2world

 

 

thats what i was looking yesterday in the files thats where you change all that staff XD 

[Lantus]

Hace 10 horas, Nevermind25 dijo:

No puedes usar

yo :: ClassChange (hablador, Class_ID); 

Eso dará problemas de colisión, errores críticos, etc.

 

La mejor manera de hacerlo es vender la Subclase Quest "mimir's Elixir" en otro NPC y luego hacer las subclases en el maestro. 

Ahora, ¿cómo apilar habilidades? es simple, modifique el procedimiento lin_getaquireskill en su base de datos lin2world.  

Gracias por comentar sobre mi problema y también a l2daniel.

Entonces, si lo entiendo bien, ¿no sería bueno poner un apilador NPC debido a que no se puede vender el elixir de Mimir?

Otro problema y aquí es donde pongo "UPS" es porque no tengo una llamada de procedimiento como esa. Te muestro la imagen.

¿Está mi paquete con archivos faltantes?

 

However I`ve found a procedure that could work. Please tell me if It`s correct 

ALTER PROCEDURE [dbo].[lin_SetAquireSkill]
(
  @char_id  INT,
  @subjob_id  INT,
  @skill_id      INT,
  @skill_level  TINYINT
)
AS
SET NOCOUNT ON

IF EXISTS(SELECT skill_lev FROM user_skill WHERE char_id = @char_id AND skill_id = @skill_id )
  UPDATE user_skill SET skill_lev = @skill_level WHERE char_id = @char_id AND skill_id = @skill_id
ELSE
  INSERT INTO user_skill (char_id, subjob_id, skill_id, skill_lev) VALUES (@char_id, @subjob_id, @skill_id, @skill_level);
  INSERT INTO user_skill (char_id, subjob_id, skill_id, skill_lev) VALUES (@char_id, 1, @skill_id, @skill_level);
  INSERT INTO user_skill (char_id, subjob_id, skill_id, skill_lev) VALUES (@char_id, 2, @skill_id, @skill_level);
  INSERT INTO user_skill (char_id, subjob_id, skill_id, skill_lev) VALUES (@char_id, 3, @skill_id, @skill_level);

Edited September 9, 2019 by Lantus
update

[Nevermind25]

You can with it but if you find the other procedure all be more simple and better, search again

[Lantus]

Once and again I want to thank you guys for all the help you gave me. I solved the issue so I can close de topic.

Thanks again

[Nevermind25]

@Majestic12 hello, that is a procedure for the vanganth pack the boy asks for a c4 server like l2patchd or other. 

Now, i have a question. The substack system of vanganth works well? i've tested but the character goes under ground or fly in the air depending on the race of the class that you add. It must change the character appearance? how did you solved it? 

[guytis]

13 hours ago, Nevermind25 said:

@Majestic12 hello, that is a procedure for the vanganth pack the boy asks for a c4 server like l2patchd or other. 

Now, i have a question. The substack system of vanganth works well? i've tested but the character goes under ground or fly in the air depending on the race of the class that you add. It must change the character appearance? how did you solved it? 

Vaganth's is very bad I had to do my own npc and the subclass I control them by quantity of item in the inventory

[guytis]

k

Edited September 12, 2019 by guytis

[Lantus]

12 hours ago, guytis said:

Vaganth's is very bad I had to do my own npc and the subclass I control them by quantity of item in the inventory

 

Thanks a lot for the share. However I did It work with anotehr procedure.

I want to ask you if you have the proceadure to skip race or classes (I mean, dark elves with wite elves and so).

Thanks again

[Nevermind25]

14 hours ago, guytis said:

Vaganth es muy malo, tuve que hacer mi propio npc y la subclase que controlo por cantidad de artículo en el inventario

Why you dont use the common subclass system? or why vanganth made another? the race of the character changes with the class? in my case the character just fly or go down the ground ! Ha Ha

I supose that you dont use the common system couse you need to stack one or two, or four classes NOT THREE, im allright? 

1 hour ago, Lantus said:

 

Muchas gracias por compartir Sin embargo, lo hice funciona con un procedimiento anotehr.

Quiero preguntarte si tienes el procedimiento para saltarte la carrera o las clases (quiero decir, elfos oscuros con elfos blancos, etc.).

Gracias de nuevo

You need to make a little AI work in classmasters where you do the subclass for elves and dark elves