Lantus Posted September 8, 2019 Share Posted September 8, 2019 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? Link to comment Share on other sites More sharing options...
1 Nevermind25 Posted September 9, 2019 Share Posted September 9, 2019 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. Link to comment Share on other sites More sharing options...
1 mjst Posted September 11, 2019 Share Posted September 11, 2019 (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 September 11, 2019 by Majestic12 Link to comment Share on other sites More sharing options...
0 sandeagle Posted September 8, 2019 Share Posted September 8, 2019 VIA extender or AI scripts.check Vang's source or some substack scripts Link to comment Share on other sites More sharing options...
0 Nevermind25 Posted September 8, 2019 Share Posted September 8, 2019 what are you using? explain better to help you Link to comment Share on other sites More sharing options...
0 Lantus Posted September 9, 2019 Author Share Posted September 9, 2019 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 Link to comment Share on other sites More sharing options...
0 Lantus Posted September 9, 2019 Author Share Posted September 9, 2019 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; } } } Link to comment Share on other sites More sharing options...
0 l2daniel Posted September 9, 2019 Share Posted September 9, 2019 in_getaquireskill procedure on your lin2world thats what i was looking yesterday in the files thats where you change all that staff XD Link to comment Share on other sites More sharing options...
0 Lantus Posted September 9, 2019 Author Share Posted September 9, 2019 (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? 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 Link to comment Share on other sites More sharing options...
0 Nevermind25 Posted September 9, 2019 Share Posted September 9, 2019 You can with it but if you find the other procedure all be more simple and better, search again Link to comment Share on other sites More sharing options...
0 Lantus Posted September 10, 2019 Author Share Posted September 10, 2019 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 Link to comment Share on other sites More sharing options...
0 Nevermind25 Posted September 12, 2019 Share Posted September 12, 2019 @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? Link to comment Share on other sites More sharing options...
0 guytis Posted September 12, 2019 Share Posted September 12, 2019 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 Link to comment Share on other sites More sharing options...
0 guytis Posted September 12, 2019 Share Posted September 12, 2019 (edited) k Edited September 12, 2019 by guytis Link to comment Share on other sites More sharing options...
0 Lantus Posted September 13, 2019 Author Share Posted September 13, 2019 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 Link to comment Share on other sites More sharing options...
0 Nevermind25 Posted September 13, 2019 Share Posted September 13, 2019 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 Link to comment Share on other sites More sharing options...
Question
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?
Link to comment
Share on other sites
17 answers to this question
Recommended Posts