Skip to content

SUBSTACK PROBLEM

Featured Replies

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?

  • Author
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

  • Author
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; } } }

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.  

in_getaquireskill procedure on your lin2world

 

 

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

  • Author
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?

lin2world table.png

 

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 by Lantus
update

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

  • Author

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

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 by Majestic12

@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? 

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

  • Author
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

Guest
This topic is now closed to further replies.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.