Jump to content
  • 0
Lantus

SUBSTACK PROBLEM

Question

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?

Share this post


Link to post
Share on other sites

Recommended Posts

  • 1

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.  

Share this post


Link to post
Share on other sites
  • 1
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

Share this post


Link to post
Share on other sites
  • 0
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

Share this post


Link to post
Share on other sites
  • 0
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; } } }

Share this post


Link to post
Share on other sites
  • 0
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

Share this post


Link to post
Share on other sites
  • 0

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

Share this post


Link to post
Share on other sites
  • 0
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

Share this post


Link to post
Share on other sites
  • 0
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

Share this post


Link to post
Share on other sites
  • 0
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

Share this post


Link to post
Share on other sites
Guest
This topic is now closed to further replies.

  • Recently Browsing   0 members

    No registered users viewing this page.



×