Jump to content
  • 0

SUBSTACK PROBLEM


Question

Posted

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?

Recommended Posts

  • 1
Posted

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.  

  • 1
Posted (edited)
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
  • 0
Posted
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

  • 0
Posted
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; } } }

  • 0
Posted (edited)
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
  • 0
Posted

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

  • 0
Posted
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

  • 0
Posted
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

  • 0
Posted
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

Guest
This topic is now closed to further replies.


  • Posts

    • 🎉 ¡Llega EuroLatinL2! 🎉 🌍 Un servidor Interlude x20 con esencia retail y ajustes justos para una experiencia única. 🧠 Desarrollado por profesionales rusos, EuroLatinL2 está basado en el cliente original de Lineage II Interlude. Buscamos revivir lo mejor de la vieja escuela con un balance perfecto entre nostalgia y jugabilidad moderna. 🛡️ ¿Qué hace diferente a EuroLatinL2? ✨ Rates Mid x20 – Equilibrados para un progreso fluido, sin perder el desafío. 🧪 Experiencia 100% retail con leves ajustes para mantener el interés. ⚔️ Raid Bosses épicos ajustados al nivel 80. 💡 Nada de GM Shop, sin buffs OP, sin teleport personalizados. ⛩️ Solo tiendas y contenido original de Lineage II. 🧙 Buffer básico (solo Prophet), duración de 60 minutos. 🔄 Sistema de héroes cada 15 días y Olimpiadas 2h por día. 🛒 Sistema de donaciones solo para servicios estéticos y premium (sin pay-to-win). 🧬 Sistema de skins para armas y armaduras (solo apariencia). 💤 AutoFarm disponible solo con adena/premium, opcional. 🔥 ¿Quieres volver a disfrutar Lineage II como en sus mejores tiempos? 💬 Completa quests, forma grupos reales, derrota jefes con estrategia, y recolecta recetas (¡incluso para Soulshots!). ⏳ ¡La apertura está muy cerca! 🚪 No te quedes fuera de esta aventura. Vive Lineage II como debe ser. 🌐 Sitio oficial: https://eurolatin.eu 📣 ¡Comparte con tu clan y prepárate para la nostalgia! #Lineage2 #Interlude #EuroLatinL2 #L2Classic #PvE #PvP #NostalgiaL2
    • Still looking to adapt packets to allow modern client to connect on my GF Extender.
    • Καλησπέρα,  Αναζητώ Lineage II C3 Rise of Darkness client (καθαρή έκδοση) και το απαραίτητο αρχείο System για Windows 10/11 Προσφέρω αμοιβή για τη βοήθεια  Ευχαριστώ.   Good evening,  I am looking for a Lineage II C3 Rise of Darkness client and the necessary System file for Windows 10/11 compatibility I am willing to pay for assistance  Thank you    Add me Discord: devibtv  or dm here                                                        @AlisaCodeDragon
    • Sorry, I didn't get to read everything you actually wrote, I don't think it has value. Regards.
    • "Why do you have problems with all forum users?" I dont. I respond based on how people act toward me or my clients! You are defending someone who has been trash-talking me and attacking me directly. And somehow you think I’m the one creating the problem? Did you even bother to check what actually happened, or did you just jump on his side?    While there is another guy that knows and calls him out, he is a known scammer. on this very same topic   If you believe I have issues with all forum users, name them, vilmis is not all forum users.   Besides, this looks like you are just another Vilmis alt accounts blindly backing him without facts.   Tinker123aa I have an alergy on scammers you see, ill wait for your list of all forum users tho.
  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock