ArgentinaExt - Lineage II Interlude/C4

Publicado por dandiarena, Ago 03, 2022, 02:01 PM

Tema anterior - Siguiente tema
Ago 03, 2022, 02:01 PM Ultima modificación: Ago 08, 2022, 11:23 PM por dandiarena
ArgentinaExt - Extender Libre


Contenido:
Fix y Mejoras en general (Todo en el ext y .ini)
Fix Hair Slot
Fix Auction (En progreso)
Fix TvT agregados (looser reward, kill title, anuncios)
Fix Show Level Mob & Flags Clan
Fix Custom drop para MOBS & BOSS
Sistema de servicios in game (skin, race, color nick/title, karma/pk)
Sistema de anuncios (login hero,lord castle,top pvp/pk - enchant - subclass)
Sistema Achievement BETA (En progreso)

Panel de admin: //admin
Comandos habilitados: .menu - .info - .vip - .offline - .achiv - .varmor - .vweapon - .dressme

NPC BETA: //summon test_server_helper

Y un par de cosas mas que seguro me olvido pero esta todo en los .ini

PRUEBENLO Y ME AVISAN EL SOPORTE ES TOTALMENTE GRATIS, SUMATE AL GRUPO DE DISCORD!


Descarga: You are not allowed to view links. Register or Login

Lineage II FAN

Ago 08, 2022, 11:18 PM #1 Ultima modificación: Ago 25, 2022, 10:13 PM por dandiarena
Aplicar las siguientes querys en SQL  para actualizar la base de 50 slots de buff y el guardado de buff al relogear.

Parte 1 - Fix SchemeBuffer

USE [lin2world]
GO

DROP TABLE user_scheme_buffer
GO

create table user_scheme_buffer(
char_id int not null,
subjob_index int not null default 0,
type int not null default 0,
b0 int not null default 0,
b1 int not null default 0,
b2 int not null default 0,
b3 int not null default 0,
b4 int not null default 0,
b5 int not null default 0,
b6 int not null default 0,
b7 int not null default 0,
b8 int not null default 0,
b9 int not null default 0,
b10 int not null default 0,
b11 int not null default 0,
b12 int not null default 0,
b13 int not null default 0,
b14 int not null default 0,
b15 int not null default 0,
b16 int not null default 0,
b17 int not null default 0,
b18 int not null default 0,
b19 int not null default 0,
b20 int not null default 0,
b21 int not null default 0,
b22 int not null default 0,
b23 int not null default 0,
b24 int not null default 0,
b25 int not null default 0,
b26 int not null default 0,
b27 int not null default 0,
b28 int not null default 0,
b29 int not null default 0,
b30 int not null default 0,
b31 int not null default 0,
b32 int not null default 0,
b33 int not null default 0,
b34 int not null default 0,
b35 int not null default 0,
b36 int not null default 0,
b37 int not null default 0,
b38 int not null default 0,
b39 int not null default 0,
b40 int not null default 0,
b41 int not null default 0,
b42 int not null default 0,
b43 int not null default 0,
b44 int not null default 0,
b45 int not null default 0,
b46 int not null default 0,
b47 int not null default 0,
b48 int not null default 0,
b49 int not null default 0,
)
go

Lineage II FAN

Ago 08, 2022, 11:19 PM #2 Ultima modificación: Ago 25, 2022, 10:13 PM por dandiarena
Parte 2 - Fix User ActiveSkill


USE [LIN2WORLD]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
DROP TABLE [dbo].[user_ActiveSkill]
GO
CREATE TABLE [dbo].[user_ActiveSkill](
[char_id] [int] NOT NULL,
[s1] [int] NULL,
[l1] [tinyint] NULL,
[d1] [int] NULL,
[s2] [int] NULL,
[l2] [tinyint] NULL,
[d2] [int] NULL,
[s3] [int] NULL,
[l3] [tinyint] NULL,
[d3] [int] NULL,
[s4] [int] NULL,
[l4] [tinyint] NULL,
[d4] [int] NULL,
[s5] [int] NULL,
[l5] [tinyint] NULL,
[d5] [int] NULL,
[s6] [int] NULL,
[l6] [tinyint] NULL,
[d6] [int] NULL,
[s7] [int] NULL,
[l7] [tinyint] NULL,
[d7] [int] NULL,
[s8] [int] NULL,
[l8] [tinyint] NULL,
[d8] [int] NULL,
[s9] [int] NULL,
[l9] [tinyint] NULL,
[d9] [int] NULL,
[s10] [int] NULL,
[l10] [tinyint] NULL,
[d10] [int] NULL,
[s11] [int] NULL,
[l11] [tinyint] NULL,
[d11] [int] NULL,
[s12] [int] NULL,
[l12] [tinyint] NULL,
[d12] [int] NULL,
[s13] [int] NULL,
[l13] [tinyint] NULL,
[d13] [int] NULL,
[s14] [int] NULL,
[l14] [tinyint] NULL,
[d14] [int] NULL,
[s15] [int] NULL,
[l15] [tinyint] NULL,
[d15] [int] NULL,
[s16] [int] NULL,
[l16] [tinyint] NULL,
[d16] [int] NULL,
[s17] [int] NULL,
[l17] [tinyint] NULL,
[d17] [int] NULL,
[s18] [int] NULL,
[l18] [tinyint] NULL,
[d18] [int] NULL,
[s19] [int] NULL,
[l19] [tinyint] NULL,
[d19] [int] NULL,
[s20] [int] NULL,
[l20] [tinyint] NULL,
[d20] [int] NULL,
[s21] [int] NULL,
[l21] [tinyint] NULL,
[d21] [int] NULL,
[s22] [int] NULL,
[l22] [tinyint] NULL,
[d22] [int] NULL,
[s23] [int] NULL,
[l23] [tinyint] NULL,
[d23] [int] NULL,
[s24] [int] NULL,
[l24] [tinyint] NULL,
[d24] [int] NULL,
[s25] [int] NULL,
[l25] [tinyint] NULL,
[d25] [int] NULL,
[s26] [int] NULL,
[l26] [tinyint] NULL,
[d26] [int] NULL,
[s27] [int] NULL,
[l27] [tinyint] NULL,
[d27] [int] NULL,
[s28] [int] NULL,
[l28] [tinyint] NULL,
[d28] [int] NULL,
[s29] [int] NULL,
[l29] [tinyint] NULL,
[d29] [int] NULL,
[s30] [int] NULL,
[l30] [tinyint] NULL,
[d30] [int] NULL,
[s31] [int] NULL,
[l31] [tinyint] NULL,
[d31] [int] NULL,
[s32] [int] NULL,
[l32] [tinyint] NULL,
[d32] [int] NULL,
[s33] [int] NULL,
[l33] [tinyint] NULL,
[d33] [int] NULL,
[s34] [int] NULL,
[l34] [tinyint] NULL,
[d34] [int] NULL,
[s35] [int] NULL,
[l35] [tinyint] NULL,
[d35] [int] NULL,
[s36] [int] NULL,
[l36] [tinyint] NULL,
[d36] [int] NULL,
[s37] [int] NULL,
[l37] [tinyint] NULL,
[d37] [int] NULL,
[s38] [int] NULL,
[l38] [tinyint] NULL,
[d38] [int] NULL,
[s39] [int] NULL,
[l39] [tinyint] NULL,
[d39] [int] NULL,
[s40] [int] NULL,
[l40] [tinyint] NULL,
[d40] [int] NULL,
[s41] [int] NULL,
[l41] [tinyint] NULL,
[d41] [int] NULL,
[s42] [int] NULL,
[l42] [tinyint] NULL,
[d42] [int] NULL,
[s43] [int] NULL,
[l43] [tinyint] NULL,
[d43] [int] NULL,
[s44] [int] NULL,
[l44] [tinyint] NULL,
[d44] [int] NULL,
[s45] [int] NULL,
[l45] [tinyint] NULL,
[d45] [int] NULL,
[s46] [int] NULL,
[l46] [tinyint] NULL,
[d46] [int] NULL,
[s47] [int] NULL,
[l47] [tinyint] NULL,
[d47] [int] NULL,
[s48] [int] NULL,
[l48] [tinyint] NULL,
[d48] [int] NULL,
[s49] [int] NULL,
[l49] [tinyint] NULL,
[d49] [int] NULL,
[s50] [int] NULL,
[l50] [tinyint] NULL,
[d50] [int] NULL,
[c1] [tinyint] NULL,
[c2] [tinyint] NULL,
[c3] [tinyint] NULL,
[c4] [tinyint] NULL,
[c5] [tinyint] NULL,
[c6] [tinyint] NULL,
[c7] [tinyint] NULL,
[c8] [tinyint] NULL,
[c9] [tinyint] NULL,
[c10] [tinyint] NULL,
[c11] [tinyint] NULL,
[c12] [tinyint] NULL,
[c13] [tinyint] NULL,
[c14] [tinyint] NULL,
[c15] [tinyint] NULL,
[c16] [tinyint] NULL,
[c17] [tinyint] NULL,
[c18] [tinyint] NULL,
[c19] [tinyint] NULL,
[c20] [tinyint] NULL,
[c21] [tinyint] NULL,
[c22] [tinyint] NULL,
[c23] [tinyint] NULL,
[c24] [tinyint] NULL,
[c25] [tinyint] NULL,
[c26] [tinyint] NULL,
[c27] [tinyint] NULL,
[c28] [tinyint] NULL,
[c29] [tinyint] NULL,
[c30] [tinyint] NULL,
[c31] [tinyint] NULL,
[c32] [tinyint] NULL,
[c33] [tinyint] NULL,
[c34] [tinyint] NULL,
[c35] [tinyint] NULL,
[c36] [tinyint] NULL,
[c37] [tinyint] NULL,
[c38] [tinyint] NULL,
[c39] [tinyint] NULL,
[c40] [tinyint] NULL,
[c41] [tinyint] NULL,
[c42] [tinyint] NULL,
[c43] [tinyint] NULL,
[c44] [tinyint] NULL,
[c45] [tinyint] NULL,
[c46] [tinyint] NULL,
[c47] [tinyint] NULL,
[c48] [tinyint] NULL,
[c49] [tinyint] NULL,
[c50] [tinyint] NULL
) ON [PRIMARY]

go

USE [lin2world]
GO
drop procedure lin_CreateActiveSkill
go

CREATE PROCEDURE [dbo].[lin_CreateActiveSkill]
(
 @char_id INT,
 @s1 INT, @l1 TINYINT, @d1 INT, @c1 TINYINT,
 @s2 INT, @l2 TINYINT, @d2 INT, @c2 TINYINT,
 @s3 INT, @l3 TINYINT, @d3 INT, @c3 TINYINT,
 @s4 INT, @l4 TINYINT, @d4 INT, @c4 TINYINT,
 @s5 INT, @l5 TINYINT, @d5 INT, @c5 TINYINT,
 @s6 INT, @l6 TINYINT, @d6 INT, @c6 TINYINT,
 @s7 INT, @l7 TINYINT, @d7 INT, @c7 TINYINT,
 @s8 INT, @l8 TINYINT, @d8 INT, @c8 TINYINT,
 @s9 INT, @l9 TINYINT, @d9 INT, @c9 TINYINT,
 @s10 INT, @l10 TINYINT, @d10 INT, @c10 TINYINT,
 @s11 INT, @l11 TINYINT, @d11 INT, @c11 TINYINT,
 @s12 INT, @l12 TINYINT, @d12 INT, @c12 TINYINT,
 @s13 INT, @l13 TINYINT, @d13 INT, @c13 TINYINT,
 @s14 INT, @l14 TINYINT, @d14 INT, @c14 TINYINT,
 @s15 INT, @l15 TINYINT, @d15 INT, @c15 TINYINT,
 @s16 INT, @l16 TINYINT, @d16 INT, @c16 TINYINT,
 @s17 INT, @l17 TINYINT, @d17 INT, @c17 TINYINT,
 @s18 INT, @l18 TINYINT, @d18 INT, @c18 TINYINT,
 @s19 INT, @l19 TINYINT, @d19 INT, @c19 TINYINT,
 @s20 INT, @l20 TINYINT, @d20 INT, @c20 TINYINT,
 @s21 INT, @l21 TINYINT, @d21 INT, @c21 TINYINT,
 @s22 INT, @l22 TINYINT, @d22 INT, @c22 TINYINT,
 @s23 INT, @l23 TINYINT, @d23 INT, @c23 TINYINT,
 @s24 INT, @l24 TINYINT, @d24 INT, @c24 TINYINT,
 @s25 INT, @l25 TINYINT, @d25 INT, @c25 TINYINT,
 @s26 INT, @l26 TINYINT, @d26 INT, @c26 TINYINT,
 @s27 INT, @l27 TINYINT, @d27 INT, @c27 TINYINT,
 @s28 INT, @l28 TINYINT, @d28 INT, @c28 TINYINT,
 @s29 INT, @l29 TINYINT, @d29 INT, @c29 TINYINT,
 @s30 INT, @l30 TINYINT, @d30 INT, @c30 TINYINT,
 @s31 INT, @l31 TINYINT, @d31 INT, @c31 TINYINT,
 @s32 INT, @l32 TINYINT, @d32 INT, @c32 TINYINT,
 @s33 INT, @l33 TINYINT, @d33 INT, @c33 TINYINT,
 @s34 INT, @l34 TINYINT, @d34 INT, @c34 TINYINT,
 @s35 INT, @l35 TINYINT, @d35 INT, @c35 TINYINT,
 @s36 INT, @l36 TINYINT, @d36 INT, @c36 TINYINT,
 @s37 INT, @l37 TINYINT, @d37 INT, @c37 TINYINT,
 @s38 INT, @l38 TINYINT, @d38 INT, @c38 TINYINT,
 @s39 INT, @l39 TINYINT, @d39 INT, @c39 TINYINT,
 @s40 INT, @l40 TINYINT, @d40 INT, @c40 TINYINT,
 @s41 INT, @l41 TINYINT, @d41 INT, @c41 TINYINT,
 @s42 INT, @l42 TINYINT, @d42 INT, @c42 TINYINT,
 @s43 INT, @l43 TINYINT, @d43 INT, @c43 TINYINT,
 @s44 INT, @l44 TINYINT, @d44 INT, @c44 TINYINT,
 @s45 INT, @l45 TINYINT, @d45 INT, @c45 TINYINT,
 @s46 INT, @l46 TINYINT, @d46 INT, @c46 TINYINT,
 @s47 INT, @l47 TINYINT, @d47 INT, @c47 TINYINT,
 @s48 INT, @l48 TINYINT, @d48 INT, @c48 TINYINT,
 @s49 INT, @l49 TINYINT, @d49 INT, @c49 TINYINT,
 @s50 INT, @l50 TINYINT, @d50 INT, @c50 TINYINT
)
AS
SET NOCOUNT ON

 INSERT INTO user_activeskill
 (char_id,
 s1, l1, d1, c1,
 s2, l2, d2, c2,
 s3, l3, d3, c3,
 s4, l4, d4, c4,
 s5, l5, d5, c5,
 s6, l6, d6, c6,
 s7, l7, d7, c7,
 s8, l8, d8, c8,
 s9, l9, d9, c9,
 s10, l10, d10, c10,
 s11, l11, d11, c11,
 s12, l12, d12, c12,
 s13, l13, d13, c13,
 s14, l14, d14, c14,
 s15, l15, d15, c15,
 s16, l16, d16, c16,
 s17, l17, d17, c17,
 s18, l18, d18, c18,
 s19, l19, d19, c19,
 s20, l20, d20, c20,
 s21, l21, d21, c21,
 s22, l22, d22, c22,
 s23, l23, d23, c23,
 s24, l24, d24, c24,
 s25, l25, d25, c25,
 s26, l26, d26, c26,
 s27, l27, d27, c27,
 s28, l28, d28, c28,
 s29, l29, d29, c29,
 s30, l30, d30, c30,
 s31, l31, d31, c31,
 s32, l32, d32, c32,
 s33, l33, d33, c33,
 s34, l34, d34, c34,
 s35, l35, d35, c35,
 s36, l36, d36, c36,
 s37, l37, d37, c37,
 s38, l38, d38, c38,
 s39, l39, d39, c39,
 s40, l40, d40, c40,
 s41, l41, d41, c41,
 s42, l42, d42, c42,
 s43, l43, d43, c43,
 s44, l44, d44, c44,
 s45, l45, d45, c45,
 s46, l46, d46, c46,
 s47, l47, d47, c47,
 s48, l48, d48, c48,
 s49, l49, d49, c49,
 s50, l50, d50, c50 )
 VALUES
 (@char_id,
 @s1, @l1, @d1, @c1,
 @s2, @l2, @d2, @c2,
 @s3, @l3, @d3, @c3,
 @s4, @l4, @d4, @c4,
 @s5, @l5, @d5, @c5,
 @s6, @l6, @d6, @c6,
 @s7, @l7, @d7, @c7,
 @s8, @l8, @d8, @c8,
 @s9, @l9, @d9, @c9,
 @s10, @l10, @d10, @c10,
 @s11, @l11, @d11, @c11,
 @s12, @l12, @d12, @c12,
 @s13, @l13, @d13, @c13,
 @s14, @l14, @d14, @c14,
 @s15, @l15, @d15, @c15,
 @s16, @l16, @d16, @c16,
 @s17, @l17, @d17, @c17,
 @s18, @l18, @d18, @c18,
 @s19, @l19, @d19, @c19,
 @s20, @l20, @d20, @c20,
 @s21, @l21, @d21, @c21,
 @s22, @l22, @d22, @c22,
 @s23, @l23, @d23, @c23,
 @s24, @l24, @d24, @c24,
 @s25, @l25, @d25, @c25,
 @s26, @l26, @d26, @c26,
 @s27, @l27, @d27, @c27,
 @s28, @l28, @d28, @c28,
 @s29, @l29, @d29, @c29,
 @s30, @l30, @d30, @c30,
 @s31, @l31, @d31, @c31,
 @s32, @l32, @d32, @c32,
 @s33, @l33, @d33, @c33,
 @s34, @l34, @d34, @c34,
 @s35, @l35, @d35, @c35,
 @s36, @l36, @d36, @c36,
 @s37, @l37, @d37, @c37,
 @s38, @l38, @d38, @c38,
 @s39, @l39, @d39, @c39,
 @s40, @l40, @d40, @c40,
 @s41, @l41, @d41, @c41,
 @s42, @l42, @d42, @c42,
 @s43, @l43, @d43, @c43,
 @s44, @l44, @d44, @c44,
 @s45, @l45, @d45, @c45,
 @s46, @l46, @d46, @c46,
 @s47, @l47, @d47, @c47,
 @s48, @l48, @d48, @c48,
 @s49, @l49, @d49, @c49,
 @s50, @l50, @d50, @c50)
 
 go


USE lin2world
go
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

IF EXISTS (SELECT 1
    FROM sys.procedures
    WHERE [name]='lin_GetActiveSkills')
        drop procedure lin_GetActiveSkills
go

CREATE PROCEDURE lin_GetActiveSkills
-- Add the parameters for the stored procedure here
@char_id AS INT
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

    -- Insert statements for procedure here
SELECT [s1]
      ,[l1]
      ,[d1]
      ,[s2]
      ,[l2]
      ,[d2]
      ,[s3]
      ,[l3]
      ,[d3]
      ,[s4]
      ,[l4]
      ,[d4]
      ,[s5]
      ,[l5]
      ,[d5]
      ,[s6]
      ,[l6]
      ,[d6]
      ,[s7]
      ,[l7]
      ,[d7]
      ,[s8]
      ,[l8]
      ,[d8]
      ,[s9]
      ,[l9]
      ,[d9]
      ,[s10]
      ,[l10]
      ,[d10]
      ,[s11]
      ,[l11]
      ,[d11]
      ,[s12]
      ,[l12]
      ,[d12]
      ,[s13]
      ,[l13]
      ,[d13]
      ,[s14]
      ,[l14]
      ,[d14]
      ,[s15]
      ,[l15]
      ,[d15]
      ,[s16]
      ,[l16]
      ,[d16]
      ,[s17]
      ,[l17]
      ,[d17]
      ,[s18]
      ,[l18]
      ,[d18]
      ,[s19]
      ,[l19]
      ,[d19]
      ,[s20]
      ,[l20]
      ,[d20]
      ,[s21]
      ,[l21]
      ,[d21]
      ,[s22]
      ,[l22]
      ,[d22]
      ,[s23]
      ,[l23]
      ,[d23]
      ,[s24]
      ,[l24]
      ,[d24]
      ,[s25]
      ,[l25]
      ,[d25]
      ,[s26]
      ,[l26]
      ,[d26]
      ,[s27]
      ,[l27]
      ,[d27]
      ,[s28]
      ,[l28]
      ,[d28]
      ,[s29]
      ,[l29]
      ,[d29]
      ,[s30]
      ,[l30]
      ,[d30]
      ,[s31]
      ,[l31]
      ,[d31]
      ,[s32]
      ,[l32]
      ,[d32]
      ,[s33]
      ,[l33]
      ,[d33]
      ,[s34]
      ,[l34]
      ,[d34]
      ,[s35]
      ,[l35]
      ,[d35]
      ,[s36]
      ,[l36]
      ,[d36]
      ,[s37]
      ,[l37]
      ,[d37]
      ,[s38]
      ,[l38]
      ,[d38]
      ,[s39]
      ,[l39]
      ,[d39]
      ,[s40]
      ,[l40]
      ,[d40]
  ,[s41]
      ,[l41]
      ,[d41]
      ,[s42]
      ,[l42]
      ,[d42]
      ,[s43]
      ,[l43]
      ,[d43]
      ,[s44]
      ,[l44]
      ,[d44]
      ,[s45]
      ,[l45]
      ,[d45]
      ,[s46]
      ,[l46]
      ,[d46]
      ,[s47]
      ,[l47]
      ,[d47]
      ,[s48]
      ,[l48]
      ,[d48]
      ,[s49]
      ,[l49]
      ,[d49]
      ,[s50]
      ,[l50]
      ,[d50]
      ,[c1]
      ,[c2]
      ,[c3]
      ,[c4]
      ,[c5]
      ,[c6]
      ,[c7]
      ,[c8]
      ,[c9]
      ,[c10]
      ,[c11]
      ,[c12]
      ,[c13]
      ,[c14]
      ,[c15]
      ,[c16]
      ,[c17]
      ,[c18]
      ,[c19]
      ,[c20]
      ,[c21]
      ,[c22]
      ,[c23]
      ,[c24]
      ,[c25]
      ,[c26]
      ,[c27]
      ,[c28]
      ,[c29]
      ,[c30]
      ,[c31]
      ,[c32]
      ,[c33]
      ,[c34]
      ,[c35]
      ,[c36]
      ,[c37]
      ,[c38]
      ,[c39]
      ,[c40]
  ,[c41]
      ,[c42]
      ,[c43]
      ,[c44]
      ,[c45]
      ,[c46]
      ,[c47]
      ,[c48]
      ,[c49]
      ,[c50]
FROM [lin2world].[dbo].[user_ActiveSkill] WHERE char_id = @char_id
END
GO
Lineage II FAN

Ago 08, 2022, 11:19 PM #3 Ultima modificación: Ago 08, 2022, 11:21 PM por dandiarena
Parte 3 - Fix UpdateActiveSkill


USE lin2world
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
USE [lin2world]
GO
drop procedure lin_UpdateActiveSkill
go

CREATE PROCEDURE lin_UpdateActiveSkill
(
 @char_id INT,
 @s1 INT, @l1 TINYINT, @d1 INT, @c1 TINYINT,
 @s2 INT, @l2 TINYINT, @d2 INT, @c2 TINYINT,
 @s3 INT, @l3 TINYINT, @d3 INT, @c3 TINYINT,
 @s4 INT, @l4 TINYINT, @d4 INT, @c4 TINYINT,
 @s5 INT, @l5 TINYINT, @d5 INT, @c5 TINYINT,
 @s6 INT, @l6 TINYINT, @d6 INT, @c6 TINYINT,
 @s7 INT, @l7 TINYINT, @d7 INT, @c7 TINYINT,
 @s8 INT, @l8 TINYINT, @d8 INT, @c8 TINYINT,
 @s9 INT, @l9 TINYINT, @d9 INT, @c9 TINYINT,
 @s10 INT, @l10 TINYINT, @d10 INT, @c10 TINYINT,
 @s11 INT, @l11 TINYINT, @d11 INT, @c11 TINYINT,
 @s12 INT, @l12 TINYINT, @d12 INT, @c12 TINYINT,
 @s13 INT, @l13 TINYINT, @d13 INT, @c13 TINYINT,
 @s14 INT, @l14 TINYINT, @d14 INT, @c14 TINYINT,
 @s15 INT, @l15 TINYINT, @d15 INT, @c15 TINYINT,
 @s16 INT, @l16 TINYINT, @d16 INT, @c16 TINYINT,
 @s17 INT, @l17 TINYINT, @d17 INT, @c17 TINYINT,
 @s18 INT, @l18 TINYINT, @d18 INT, @c18 TINYINT,
 @s19 INT, @l19 TINYINT, @d19 INT, @c19 TINYINT,
 @s20 INT, @l20 TINYINT, @d20 INT, @c20 TINYINT,
 @s21 INT, @l21 TINYINT, @d21 INT, @c21 TINYINT,
 @s22 INT, @l22 TINYINT, @d22 INT, @c22 TINYINT,
 @s23 INT, @l23 TINYINT, @d23 INT, @c23 TINYINT,
 @s24 INT, @l24 TINYINT, @d24 INT, @c24 TINYINT,
 @s25 INT, @l25 TINYINT, @d25 INT, @c25 TINYINT,
 @s26 INT, @l26 TINYINT, @d26 INT, @c26 TINYINT,
 @s27 INT, @l27 TINYINT, @d27 INT, @c27 TINYINT,
 @s28 INT, @l28 TINYINT, @d28 INT, @c28 TINYINT,
 @s29 INT, @l29 TINYINT, @d29 INT, @c29 TINYINT,
 @s30 INT, @l30 TINYINT, @d30 INT, @c30 TINYINT,
 @s31 INT, @l31 TINYINT, @d31 INT, @c31 TINYINT,
 @s32 INT, @l32 TINYINT, @d32 INT, @c32 TINYINT,
 @s33 INT, @l33 TINYINT, @d33 INT, @c33 TINYINT,
 @s34 INT, @l34 TINYINT, @d34 INT, @c34 TINYINT,
 @s35 INT, @l35 TINYINT, @d35 INT, @c35 TINYINT,
 @s36 INT, @l36 TINYINT, @d36 INT, @c36 TINYINT,
 @s37 INT, @l37 TINYINT, @d37 INT, @c37 TINYINT,
 @s38 INT, @l38 TINYINT, @d38 INT, @c38 TINYINT,
 @s39 INT, @l39 TINYINT, @d39 INT, @c39 TINYINT,
 @s40 INT, @l40 TINYINT, @d40 INT, @c40 TINYINT,
 @s41 INT, @l41 TINYINT, @d41 INT, @c41 TINYINT,
 @s42 INT, @l42 TINYINT, @d42 INT, @c42 TINYINT,
 @s43 INT, @l43 TINYINT, @d43 INT, @c43 TINYINT,
 @s44 INT, @l44 TINYINT, @d44 INT, @c44 TINYINT,
 @s45 INT, @l45 TINYINT, @d45 INT, @c45 TINYINT,
 @s46 INT, @l46 TINYINT, @d46 INT, @c46 TINYINT,
 @s47 INT, @l47 TINYINT, @d47 INT, @c47 TINYINT,
 @s48 INT, @l48 TINYINT, @d48 INT, @c48 TINYINT,
 @s49 INT, @l49 TINYINT, @d49 INT, @c49 TINYINT,
 @s50 INT, @l50 TINYINT, @d50 INT, @c50 TINYINT
)
AS
SET NOCOUNT ON;
IF EXISTS(SELECT * FROM user_activeskill WHERE char_id = @char_id)
BEGIN
 UPDATE user_activeskill
 SET
 s1 = @s1, l1 = @l1, d1 = @d1, c1 = @c1,
 s2 = @s2, l2 = @l2, d2 = @d2, c2 = @c2,
 s3 = @s3, l3 = @l3, d3 = @d3, c3 = @c3,
 s4 = @s4, l4 = @l4, d4 = @d4, c4 = @c4,
 s5 = @s5, l5 = @l5, d5 = @d5, c5 = @c5,
 s6 = @s6, l6 = @l6, d6 = @d6, c6 = @c6,
 s7 = @s7, l7 = @l7, d7 = @d7, c7 = @c7,
 s8 = @s8, l8 = @l8, d8 = @d8, c8 = @c8,
 s9 = @s9, l9 = @l9, d9 = @d9, c9 = @c9,
 s10 = @s10, l10 = @l10, d10 = @d10, c10 = @c10,
 s11 = @s11, l11 = @l11, d11 = @d11, c11 = @c11,
 s12 = @s12, l12 = @l12, d12 = @d12, c12 = @c12,
 s13 = @s13, l13 = @l13, d13 = @d13, c13 = @c13,
 s14 = @s14, l14 = @l14, d14 = @d14, c14 = @c14,
 s15 = @s15, l15 = @l15, d15 = @d15, c15 = @c15,
 s16 = @s16, l16 = @l16, d16 = @d16, c16 = @c16,
 s17 = @s17, l17 = @l17, d17 = @d17, c17 = @c17,
 s18 = @s18, l18 = @l18, d18 = @d18, c18 = @c18,
 s19 = @s19, l19 = @l19, d19 = @d19, c19 = @c19,
 s20 = @s20, l20 = @l20, d20 = @d20, c20 = @c20,
 s21 = @s21, l21 = @l21, d21 = @d21, c21 = @c21,
 s22 = @s22, l22 = @l22, d22 = @d22, c22 = @c22,
 s23 = @s23, l23 = @l23, d23 = @d23, c23 = @c23,
 s24 = @s24, l24 = @l24, d24 = @d24, c24 = @c24,
 s25 = @s25, l25 = @l25, d25 = @d25, c25 = @c25,
 s26 = @s26, l26 = @l26, d26 = @d26, c26 = @c26,
 s27 = @s27, l27 = @l27, d27 = @d27, c27 = @c27,
 s28 = @s28, l28 = @l28, d28 = @d28, c28 = @c28,
 s29 = @s29, l29 = @l29, d29 = @d29, c29 = @c29,
 s30 = @s30, l30 = @l30, d30 = @d30, c30 = @c30,
 s31 = @s31, l31 = @l31, d31 = @d31, c31 = @c31,
 s32 = @s32, l32 = @l32, d32 = @d32, c32 = @c32,
 s33 = @s33, l33 = @l33, d33 = @d33, c33 = @c33,
 s34 = @s34, l34 = @l34, d34 = @d34, c34 = @c34,
 s35 = @s35, l35 = @l35, d35 = @d35, c35 = @c35,
 s36 = @s36, l36 = @l36, d36 = @d36, c36 = @c36,
 s37 = @s37, l37 = @l37, d37 = @d37, c37 = @c37,
 s38 = @s38, l38 = @l38, d38 = @d38, c38 = @c38,
 s39 = @s39, l39 = @l39, d39 = @d39, c39 = @c39,
 s40 = @s40, l40 = @l40, d40 = @d40, c40 = @c40,
 s41 = @s41, l41 = @l41, d41 = @d41, c41 = @c41,
 s42 = @s42, l42 = @l42, d42 = @d42, c42 = @c42,
 s43 = @s43, l43 = @l43, d43 = @d43, c43 = @c43,
 s44 = @s44, l44 = @l44, d44 = @d44, c44 = @c44,
 s45 = @s45, l45 = @l45, d45 = @d45, c45 = @c45,
 s46 = @s46, l46 = @l46, d46 = @d46, c46 = @c46,
 s47 = @s47, l47 = @l47, d47 = @d47, c47 = @c47,
 s48 = @s48, l48 = @l48, d48 = @d48, c48 = @c48,
 s49 = @s49, l49 = @l49, d49 = @d49, c49 = @c49,
 s50 = @s50, l50 = @l50, d50 = @d50, c50 = @c50
 WHERE char_id = @char_id
END 
ELSE
BEGIN 
 INSERT INTO user_activeskill
 (char_id,
 s1, l1, d1, c1,
 s2, l2, d2, c2,
 s3, l3, d3, c3,
 s4, l4, d4, c4,
 s5, l5, d5, c5,
 s6, l6, d6, c6,
 s7, l7, d7, c7,
 s8, l8, d8, c8,
 s9, l9, d9, c9,
 s10, l10, d10, c10,
 s11, l11, d11, c11,
 s12, l12, d12, c12,
 s13, l13, d13, c13,
 s14, l14, d14, c14,
 s15, l15, d15, c15,
 s16, l16, d16, c16,
 s17, l17, d17, c17,
 s18, l18, d18, c18,
 s19, l19, d19, c19,
 s20, l20, d20, c20,
 s21, l21, d21, c21,
 s22, l22, d22, c22,
 s23, l23, d23, c23,
 s24, l24, d24, c24,
 s25, l25, d25, c25,
 s26, l26, d26, c26,
 s27, l27, d27, c27,
 s28, l28, d28, c28,
 s29, l29, d29, c29,
 s30, l30, d30, c30,
 s31, l31, d31, c31,
 s32, l32, d32, c32,
 s33, l33, d33, c33,
 s34, l34, d34, c34,
 s35, l35, d35, c35,
 s36, l36, d36, c36,
 s37, l37, d37, c37,
 s38, l38, d38, c38,
 s39, l39, d39, c39,
 s40, l40, d40, c40,
 s41, l41, d41, c41,
 s42, l42, d42, c42,
 s43, l43, d43, c43,
 s44, l44, d44, c44,
 s45, l45, d45, c45,
 s46, l46, d46, c46,
 s47, l47, d47, c47,
 s48, l48, d48, c48,
 s49, l49, d49, c49,
 s50, l50, d50, c50 )
 VALUES
 (@char_id,
 @s1, @l1, @d1, @c1,
 @s2, @l2, @d2, @c2,
 @s3, @l3, @d3, @c3,
 @s4, @l4, @d4, @c4,
 @s5, @l5, @d5, @c5,
 @s6, @l6, @d6, @c6,
 @s7, @l7, @d7, @c7,
 @s8, @l8, @d8, @c8,
 @s9, @l9, @d9, @c9,
 @s10, @l10, @d10, @c10,
 @s11, @l11, @d11, @c11,
 @s12, @l12, @d12, @c12,
 @s13, @l13, @d13, @c13,
 @s14, @l14, @d14, @c14,
 @s15, @l15, @d15, @c15,
 @s16, @l16, @d16, @c16,
 @s17, @l17, @d17, @c17,
 @s18, @l18, @d18, @c18,
 @s19, @l19, @d19, @c19,
 @s20, @l20, @d20, @c20,
 @s21, @l21, @d21, @c21,
 @s22, @l22, @d22, @c22,
 @s23, @l23, @d23, @c23,
 @s24, @l24, @d24, @c24,
 @s25, @l25, @d25, @c25,
 @s26, @l26, @d26, @c26,
 @s27, @l27, @d27, @c27,
 @s28, @l28, @d28, @c28,
 @s29, @l29, @d29, @c29,
 @s30, @l30, @d30, @c30,
 @s31, @l31, @d31, @c31,
 @s32, @l32, @d32, @c32,
 @s33, @l33, @d33, @c33,
 @s34, @l34, @d34, @c34,
 @s35, @l35, @d35, @c35,
 @s36, @l36, @d36, @c36,
 @s37, @l37, @d37, @c37,
 @s38, @l38, @d38, @c38,
 @s39, @l39, @d39, @c39,
 @s40, @l40, @d40, @c40,
 @s41, @l41, @d41, @c41,
 @s42, @l42, @d42, @c42,
 @s43, @l43, @d43, @c43,
 @s44, @l44, @d44, @c44,
 @s45, @l45, @d45, @c45,
 @s46, @l46, @d46, @c46,
 @s47, @l47, @d47, @c47,
 @s48, @l48, @d48, @c48,
 @s49, @l49, @d49, @c49,
 @s50, @l50, @d50, @c50 )
END

go
Lineage II FAN

Custom

Sistema de SubClass Acumulativa por NPC con cambio de skin.

Como funciona? Configurar desde ArgentinaExt/config/Extras.ini

MakeSubClass_ItemId = ID del item que debe ser item quest no dropeable no tradeable, agregar cuando se crea un personaje, desde el setting.txt (este item se elimina al hacer subclass)
MakeSubClass1_ItemId = ID del item que debe ser item quest no dropeable no tradeable. (este item se elimina al hacer subclass)
MakeSubClass2_ItemId = ID del item que debe ser item quest no dropeable no tradeable. (este item se elimina al hacer subclass)
MakeSubClass3_ItemId = ID del item que debe ser item quest no dropeable no tradeable. (este item no se elimina al hacer subclass)

SIN ESTA CONFIGURACION EL SISTEMA NO FUNCIONA O PUEDE TENER FALLAS COMO SUBCLASS INFINITAS

Descargar el adjunto, el cual contiene los html de cada subclass por raza.

Lo unico que debes agregar en un NPC seria un bypass de link

Ejemplo:

<button value="Subclass" action="link aio_char_sub.htm" width=204 height=20 back="sek.cbui36" fore="sek.cbui75">
Lineage II FAN