Jump to content
MaxCheaters Official Group on Discord
Top.MaxCheaters.com is now OPEN – Lineage 2 Top Listing

Full Interlude files.

Hazel
 Share

Recommended Posts

kanziguy Newbie

kanziguy

Posted
Posted

CREATE TABLE [dbo].[hellbound_point] (

[point] [int] NOT NULL DEFAULT 0

) ON [PRIMARY]

GO

 

ALTER TABLE user_data ADD

reputation_point int NULL DEFAULT 0;

GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[lin_GetUserDataByCharId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[lin_GetUserDataByCharId]

GO

 

CREATE    PROCEDURE dbo.lin_GetUserDataByCharId

(

@char_id INT

)

AS

SET NOCOUNT ON

DECLARE @acc NVARCHAR(50)

set @acc=(select account_name from user_data where char_id=@char_id)

     

IF @char_id > 0

     

SELECT     

RTRIM(ud.char_name), ud.char_id, RTRIM(ud.account_name), ud.account_id, ud.pledge_id, ud.builder, ud.gender, ud.race, ud.class,     

ud.world, ud.xloc, ud.yloc, ud.zloc, ud.IsInVehicle, ud.HP, ud.MP, ud.Max_HP, ud.Max_MP, ud.CP, ud.Max_CP, ud.SP, ud.Exp, ud.Lev, ud.align, ud.PK, ud.duel, ud.pkpardon,     

ud.ST_underware, ud.ST_right_ear, ud.ST_left_ear, ud.ST_neck, ud.ST_right_finger, ud.ST_left_finger, ud.ST_head, ud.ST_right_hand, ud.ST_left_hand, ud.ST_gloves, ud.ST_chest, ud.ST_legs, ud.ST_feet, ud.ST_back, ud.ST_both_hand, ud.ST_hair, 

ISNULL(YEAR(temp_delete_date),0), ISNULL(MONTH(temp_delete_date),0), ISNULL(DAY(temp_delete_date),0), 

ISNULL(DATEPART(HOUR, temp_delete_date),0), ISNULL(DATEPART(mi, temp_delete_date),0), ISNULL(DATEPART(s, temp_delete_date),0), 

ISNULL(uas.s1, 0), ISNULL(uas.l1, 0), ISNULL(uas.d1, 0), ISNULL(uas.c1, 0),     

ISNULL(uas.s2, 0), ISNULL(uas.l2, 0), ISNULL(uas.d2, 0), ISNULL(uas.c2, 0),     

ISNULL(uas.s3, 0), ISNULL(uas.l3, 0), ISNULL(uas.d3, 0), ISNULL(uas.c3, 0),     

ISNULL(uas.s4, 0), ISNULL(uas.l4, 0), ISNULL(uas.d4, 0), ISNULL(uas.c4, 0),     

ISNULL(uas.s5, 0), ISNULL(uas.l5, 0), ISNULL(uas.d5, 0), ISNULL(uas.c5, 0),     

ISNULL(uas.s6, 0), ISNULL(uas.l6, 0), ISNULL(uas.d6, 0), ISNULL(uas.c6, 0),     

ISNULL(uas.s7, 0), ISNULL(uas.l7, 0), ISNULL(uas.d7, 0), ISNULL(uas.c7, 0),     

ISNULL(uas.s8, 0), ISNULL(uas.l8, 0), ISNULL(uas.d8, 0), ISNULL(uas.c8, 0),     

ISNULL(uas.s9, 0), ISNULL(uas.l9, 0), ISNULL(uas.d9, 0), ISNULL(uas.c9, 0),     

ISNULL(uas.s10, 0), ISNULL(uas.l10, 0), ISNULL(uas.d10, 0), ISNULL(uas.c10, 0),     

ISNULL(uas.s11, 0), ISNULL(uas.l11, 0), ISNULL(uas.d11, 0), ISNULL(uas.c11, 0),     

ISNULL(uas.s12, 0), ISNULL(uas.l12, 0), ISNULL(uas.d12, 0), ISNULL(uas.c12, 0),     

ISNULL(uas.s13, 0), ISNULL(uas.l13, 0), ISNULL(uas.d13, 0), ISNULL(uas.c13, 0),     

ISNULL(uas.s14, 0), ISNULL(uas.l14, 0), ISNULL(uas.d14, 0), ISNULL(uas.c14, 0),     

ISNULL(uas.s15, 0), ISNULL(uas.l15, 0), ISNULL(uas.d15, 0), ISNULL(uas.c15, 0),     

ISNULL(uas.s16, 0), ISNULL(uas.l16, 0), ISNULL(uas.d16, 0), ISNULL(uas.c16, 0),     

ISNULL(uas.s17, 0), ISNULL(uas.l17, 0), ISNULL(uas.d17, 0), ISNULL(uas.c17, 0),     

ISNULL(uas.s18, 0), ISNULL(uas.l18, 0), ISNULL(uas.d18, 0), ISNULL(uas.c18, 0),     

ISNULL(uas.s19, 0), ISNULL(uas.l19, 0), ISNULL(uas.d19, 0), ISNULL(uas.c19, 0),   

ISNULL(uas.s20, 0), ISNULL(uas.l20, 0), ISNULL(uas.d20, 0), ISNULL(uas.c20, 0),     

ud.quest_flag, ud.face_index, ud.hair_shape_index, ud.hair_color_index,     

ud.nickname, ud.power_flag, ud.pledge_dismiss_time, ud.pledge_ousted_time, ud.pledge_withdraw_time, ud.surrender_war_id, ud.use_time, ud.drop_exp,

ISNULL( ub.status, 0), ISNULL( ub.ban_end , 0), ISNULL(ud.subjob_id , 0),

ud.subjob0_class, ud.subjob1_class, ud.subjob2_class, ud.subjob3_class, ISNULL(ssq_dawn_round, 0),

ISNULL(uun.color_rgb, 0x00ffffff),ISNULL(ud.wedding,0),ud.division,ud.pledge_group,ud.AcademyLev,ud.KarmaOrig,ud.PKdiff,ud.ST_face,ud.CursedTimeEquip,ISNULL(ud.TitleColor,0x00ffffff),ud.WeddingTelTime,

ISNULL(dyn.adena_drop,1),ISNULL(dyn.items_drop,1),ISNULL(dyn.spoil,1),ISNULL(dyn._exp,1),ISNULL(dyn._sp,1),ISNULL(SponsorId,0),

ISNULL(uas.s21, 0), ISNULL(uas.l21, 0), ISNULL(uas.d21, 0), ISNULL(uas.c21, 0),

ISNULL(uas.s22, 0), ISNULL(uas.l22, 0), ISNULL(uas.d22, 0), ISNULL(uas.c22, 0),

ISNULL(uas.s23, 0), ISNULL(uas.l23, 0), ISNULL(uas.d23, 0), ISNULL(uas.c23, 0),

ISNULL(uas.s24, 0), ISNULL(uas.l24, 0), ISNULL(uas.d24, 0), ISNULL(uas.c24, 0),

ud.ST_left_bracelet,ud.ST_right_bracelet,ud.ST_hairall,ud.ST_agathon,ud.souls,ud.transformation_id,ud.talisman1,ud.talisman2,ud.talisman3,ud.talisman4,ud.talisman5,ud.talisman6,

ISNULL(uas.s25, 0), ISNULL(uas.l25, 0), ISNULL(uas.d25, 0), ISNULL(uas.c25, 0),

ISNULL(uas.s26, 0), ISNULL(uas.l26, 0), ISNULL(uas.d26, 0), ISNULL(uas.c26, 0),

ISNULL(uas.s27, 0), ISNULL(uas.l27, 0), ISNULL(uas.d27, 0), ISNULL(uas.c27, 0),

ISNULL(uas.s28, 0), ISNULL(uas.l28, 0), ISNULL(uas.d28, 0), ISNULL(uas.c28, 0),

ISNULL(uas.s29, 0), ISNULL(uas.l29, 0), ISNULL(uas.d29, 0), ISNULL(uas.c29, 0),

ISNULL(uas.s30, 0), ISNULL(uas.l30, 0), ISNULL(uas.d30, 0), ISNULL(uas.c30, 0),

ISNULL(uas.s31, 0), ISNULL(uas.l31, 0), ISNULL(uas.d31, 0), ISNULL(uas.c31, 0),

ISNULL(uas.s32, 0), ISNULL(uas.l32, 0), ISNULL(uas.d32, 0), ISNULL(uas.c32, 0),

ISNULL(uas.s33, 0), ISNULL(uas.l33, 0), ISNULL(uas.d33, 0), ISNULL(uas.c33, 0),

ISNULL(uas.s34, 0), ISNULL(uas.l34, 0), ISNULL(uas.d34, 0), ISNULL(uas.c34, 0),

ISNULL(uas.s35, 0), ISNULL(uas.l35, 0), ISNULL(uas.d35, 0), ISNULL(uas.c35, 0),

ISNULL(uas.s36, 0), ISNULL(uas.l36, 0), ISNULL(uas.d36, 0), ISNULL(uas.c36, 0),

ISNULL(uas.s37, 0), ISNULL(uas.l37, 0), ISNULL(uas.d37, 0), ISNULL(uas.c37, 0),

ISNULL(uas.s38, 0), ISNULL(uas.l38, 0), ISNULL(uas.d38, 0), ISNULL(uas.c38, 0),

ISNULL(uas.s39, 0), ISNULL(uas.l39, 0), ISNULL(uas.d39, 0), ISNULL(uas.c39, 0),

ISNULL(uas.s40, 0), ISNULL(uas.l40, 0), ISNULL(uas.d40, 0), ISNULL(uas.c40, 0),

ISNULL(reputation_point,0)

FROM       

(SELECT * FROM User_data (nolock) WHERE char_id = @char_id) AS ud     

LEFT OUTER JOIN     

(SELECT * FROM user_ActiveSkill (nolock) WHERE char_id = @char_id) as uas ON ud.char_id = uas.char_id

left  OUTER JOIN

(select * from user_ban (nolock) where char_id = @char_id) as ub on ud.char_id = ub.char_id 

left OUTER JOIN

(select * from user_name_color (nolock) where char_id = @char_id) as uun on ud.char_id = uun.char_id

left OUTER JOIN

(select * from dynamic_rates (nolock) where acc_name=@acc) as dyn on @acc=dyn.acc_name

GO

evilgh0st Newbie

evilgh0st

Posted
Posted

CREATE TABLE [dbo].[hellbound_point] (

[point] [int] NOT NULL DEFAULT 0

) ON [PRIMARY]

GO

 

ALTER TABLE user_data ADD

reputation_point int NULL DEFAULT 0;

GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[lin_GetUserDataByCharId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[lin_GetUserDataByCharId]

GO

 

CREATE    PROCEDURE dbo.lin_GetUserDataByCharId

(

@char_id INT

)

AS

SET NOCOUNT ON

DECLARE @acc NVARCHAR(50)

set @acc=(select account_name from user_data where char_id=@char_id)

     

IF @char_id > 0

     

SELECT     

RTRIM(ud.char_name), ud.char_id, RTRIM(ud.account_name), ud.account_id, ud.pledge_id, ud.builder, ud.gender, ud.race, ud.class,     

ud.world, ud.xloc, ud.yloc, ud.zloc, ud.IsInVehicle, ud.HP, ud.MP, ud.Max_HP, ud.Max_MP, ud.CP, ud.Max_CP, ud.SP, ud.Exp, ud.Lev, ud.align, ud.PK, ud.duel, ud.pkpardon,     

ud.ST_underware, ud.ST_right_ear, ud.ST_left_ear, ud.ST_neck, ud.ST_right_finger, ud.ST_left_finger, ud.ST_head, ud.ST_right_hand, ud.ST_left_hand, ud.ST_gloves, ud.ST_chest, ud.ST_legs, ud.ST_feet, ud.ST_back, ud.ST_both_hand, ud.ST_hair, 

ISNULL(YEAR(temp_delete_date),0), ISNULL(MONTH(temp_delete_date),0), ISNULL(DAY(temp_delete_date),0), 

ISNULL(DATEPART(HOUR, temp_delete_date),0), ISNULL(DATEPART(mi, temp_delete_date),0), ISNULL(DATEPART(s, temp_delete_date),0), 

ISNULL(uas.s1, 0), ISNULL(uas.l1, 0), ISNULL(uas.d1, 0), ISNULL(uas.c1, 0),     

ISNULL(uas.s2, 0), ISNULL(uas.l2, 0), ISNULL(uas.d2, 0), ISNULL(uas.c2, 0),     

ISNULL(uas.s3, 0), ISNULL(uas.l3, 0), ISNULL(uas.d3, 0), ISNULL(uas.c3, 0),     

ISNULL(uas.s4, 0), ISNULL(uas.l4, 0), ISNULL(uas.d4, 0), ISNULL(uas.c4, 0),     

ISNULL(uas.s5, 0), ISNULL(uas.l5, 0), ISNULL(uas.d5, 0), ISNULL(uas.c5, 0),     

ISNULL(uas.s6, 0), ISNULL(uas.l6, 0), ISNULL(uas.d6, 0), ISNULL(uas.c6, 0),     

ISNULL(uas.s7, 0), ISNULL(uas.l7, 0), ISNULL(uas.d7, 0), ISNULL(uas.c7, 0),     

ISNULL(uas.s8, 0), ISNULL(uas.l8, 0), ISNULL(uas.d8, 0), ISNULL(uas.c8, 0),     

ISNULL(uas.s9, 0), ISNULL(uas.l9, 0), ISNULL(uas.d9, 0), ISNULL(uas.c9, 0),     

ISNULL(uas.s10, 0), ISNULL(uas.l10, 0), ISNULL(uas.d10, 0), ISNULL(uas.c10, 0),     

ISNULL(uas.s11, 0), ISNULL(uas.l11, 0), ISNULL(uas.d11, 0), ISNULL(uas.c11, 0),     

ISNULL(uas.s12, 0), ISNULL(uas.l12, 0), ISNULL(uas.d12, 0), ISNULL(uas.c12, 0),     

ISNULL(uas.s13, 0), ISNULL(uas.l13, 0), ISNULL(uas.d13, 0), ISNULL(uas.c13, 0),     

ISNULL(uas.s14, 0), ISNULL(uas.l14, 0), ISNULL(uas.d14, 0), ISNULL(uas.c14, 0),     

ISNULL(uas.s15, 0), ISNULL(uas.l15, 0), ISNULL(uas.d15, 0), ISNULL(uas.c15, 0),     

ISNULL(uas.s16, 0), ISNULL(uas.l16, 0), ISNULL(uas.d16, 0), ISNULL(uas.c16, 0),     

ISNULL(uas.s17, 0), ISNULL(uas.l17, 0), ISNULL(uas.d17, 0), ISNULL(uas.c17, 0),     

ISNULL(uas.s18, 0), ISNULL(uas.l18, 0), ISNULL(uas.d18, 0), ISNULL(uas.c18, 0),     

ISNULL(uas.s19, 0), ISNULL(uas.l19, 0), ISNULL(uas.d19, 0), ISNULL(uas.c19, 0),   

ISNULL(uas.s20, 0), ISNULL(uas.l20, 0), ISNULL(uas.d20, 0), ISNULL(uas.c20, 0),     

ud.quest_flag, ud.face_index, ud.hair_shape_index, ud.hair_color_index,     

ud.nickname, ud.power_flag, ud.pledge_dismiss_time, ud.pledge_ousted_time, ud.pledge_withdraw_time, ud.surrender_war_id, ud.use_time, ud.drop_exp,

ISNULL( ub.status, 0), ISNULL( ub.ban_end , 0), ISNULL(ud.subjob_id , 0),

ud.subjob0_class, ud.subjob1_class, ud.subjob2_class, ud.subjob3_class, ISNULL(ssq_dawn_round, 0),

ISNULL(uun.color_rgb, 0x00ffffff),ISNULL(ud.wedding,0),ud.division,ud.pledge_group,ud.AcademyLev,ud.KarmaOrig,ud.PKdiff,ud.ST_face,ud.CursedTimeEquip,ISNULL(ud.TitleColor,0x00ffffff),ud.WeddingTelTime,

ISNULL(dyn.adena_drop,1),ISNULL(dyn.items_drop,1),ISNULL(dyn.spoil,1),ISNULL(dyn._exp,1),ISNULL(dyn._sp,1),ISNULL(SponsorId,0),

ISNULL(uas.s21, 0), ISNULL(uas.l21, 0), ISNULL(uas.d21, 0), ISNULL(uas.c21, 0),

ISNULL(uas.s22, 0), ISNULL(uas.l22, 0), ISNULL(uas.d22, 0), ISNULL(uas.c22, 0),

ISNULL(uas.s23, 0), ISNULL(uas.l23, 0), ISNULL(uas.d23, 0), ISNULL(uas.c23, 0),

ISNULL(uas.s24, 0), ISNULL(uas.l24, 0), ISNULL(uas.d24, 0), ISNULL(uas.c24, 0),

ud.ST_left_bracelet,ud.ST_right_bracelet,ud.ST_hairall,ud.ST_agathon,ud.souls,ud.transformation_id,ud.talisman1,ud.talisman2,ud.talisman3,ud.talisman4,ud.talisman5,ud.talisman6,

ISNULL(uas.s25, 0), ISNULL(uas.l25, 0), ISNULL(uas.d25, 0), ISNULL(uas.c25, 0),

ISNULL(uas.s26, 0), ISNULL(uas.l26, 0), ISNULL(uas.d26, 0), ISNULL(uas.c26, 0),

ISNULL(uas.s27, 0), ISNULL(uas.l27, 0), ISNULL(uas.d27, 0), ISNULL(uas.c27, 0),

ISNULL(uas.s28, 0), ISNULL(uas.l28, 0), ISNULL(uas.d28, 0), ISNULL(uas.c28, 0),

ISNULL(uas.s29, 0), ISNULL(uas.l29, 0), ISNULL(uas.d29, 0), ISNULL(uas.c29, 0),

ISNULL(uas.s30, 0), ISNULL(uas.l30, 0), ISNULL(uas.d30, 0), ISNULL(uas.c30, 0),

ISNULL(uas.s31, 0), ISNULL(uas.l31, 0), ISNULL(uas.d31, 0), ISNULL(uas.c31, 0),

ISNULL(uas.s32, 0), ISNULL(uas.l32, 0), ISNULL(uas.d32, 0), ISNULL(uas.c32, 0),

ISNULL(uas.s33, 0), ISNULL(uas.l33, 0), ISNULL(uas.d33, 0), ISNULL(uas.c33, 0),

ISNULL(uas.s34, 0), ISNULL(uas.l34, 0), ISNULL(uas.d34, 0), ISNULL(uas.c34, 0),

ISNULL(uas.s35, 0), ISNULL(uas.l35, 0), ISNULL(uas.d35, 0), ISNULL(uas.c35, 0),

ISNULL(uas.s36, 0), ISNULL(uas.l36, 0), ISNULL(uas.d36, 0), ISNULL(uas.c36, 0),

ISNULL(uas.s37, 0), ISNULL(uas.l37, 0), ISNULL(uas.d37, 0), ISNULL(uas.c37, 0),

ISNULL(uas.s38, 0), ISNULL(uas.l38, 0), ISNULL(uas.d38, 0), ISNULL(uas.c38, 0),

ISNULL(uas.s39, 0), ISNULL(uas.l39, 0), ISNULL(uas.d39, 0), ISNULL(uas.c39, 0),

ISNULL(uas.s40, 0), ISNULL(uas.l40, 0), ISNULL(uas.d40, 0), ISNULL(uas.c40, 0),

ISNULL(reputation_point,0)

FROM       

(SELECT * FROM User_data (nolock) WHERE char_id = @char_id) AS ud     

LEFT OUTER JOIN     

(SELECT * FROM user_ActiveSkill (nolock) WHERE char_id = @char_id) as uas ON ud.char_id = uas.char_id

left  OUTER JOIN

(select * from user_ban (nolock) where char_id = @char_id) as ub on ud.char_id = ub.char_id 

left OUTER JOIN

(select * from user_name_color (nolock) where char_id = @char_id) as uun on ud.char_id = uun.char_id

left OUTER JOIN

(select * from dynamic_rates (nolock) where acc_name=@acc) as dyn on @acc=dyn.acc_name

GO

 

WOW !!!! Thx DUDE!

  • 2 weeks later...
benckis Newbie

benckis

Posted
Posted

CREATE TABLE [dbo].[hellbound_point] (

[point] [int] NOT NULL DEFAULT 0

) ON [PRIMARY]

GO

 

Thanks :)

ALTER TABLE user_data ADD

reputation_point int NULL DEFAULT 0;

GO

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[lin_GetUserDataByCharId]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

drop procedure [dbo].[lin_GetUserDataByCharId]

GO

 

CREATE    PROCEDURE dbo.lin_GetUserDataByCharId

(

@char_id INT

)

AS

SET NOCOUNT ON

DECLARE @acc NVARCHAR(50)

set @acc=(select account_name from user_data where char_id=@char_id)

     

IF @char_id > 0

     

SELECT      

RTRIM(ud.char_name), ud.char_id, RTRIM(ud.account_name), ud.account_id, ud.pledge_id, ud.builder, ud.gender, ud.race, ud.class,      

ud.world, ud.xloc, ud.yloc, ud.zloc, ud.IsInVehicle, ud.HP, ud.MP, ud.Max_HP, ud.Max_MP, ud.CP, ud.Max_CP, ud.SP, ud.Exp, ud.Lev, ud.align, ud.PK, ud.duel, ud.pkpardon,      

ud.ST_underware, ud.ST_right_ear, ud.ST_left_ear, ud.ST_neck, ud.ST_right_finger, ud.ST_left_finger, ud.ST_head, ud.ST_right_hand, ud.ST_left_hand, ud.ST_gloves, ud.ST_chest, ud.ST_legs, ud.ST_feet, ud.ST_back, ud.ST_both_hand, ud.ST_hair,  

ISNULL(YEAR(temp_delete_date),0), ISNULL(MONTH(temp_delete_date),0), ISNULL(DAY(temp_delete_date),0),  

ISNULL(DATEPART(HOUR, temp_delete_date),0), ISNULL(DATEPART(mi, temp_delete_date),0), ISNULL(DATEPART(s, temp_delete_date),0),  

ISNULL(uas.s1, 0), ISNULL(uas.l1, 0), ISNULL(uas.d1, 0), ISNULL(uas.c1, 0),      

ISNULL(uas.s2, 0), ISNULL(uas.l2, 0), ISNULL(uas.d2, 0), ISNULL(uas.c2, 0),      

ISNULL(uas.s3, 0), ISNULL(uas.l3, 0), ISNULL(uas.d3, 0), ISNULL(uas.c3, 0),      

ISNULL(uas.s4, 0), ISNULL(uas.l4, 0), ISNULL(uas.d4, 0), ISNULL(uas.c4, 0),      

ISNULL(uas.s5, 0), ISNULL(uas.l5, 0), ISNULL(uas.d5, 0), ISNULL(uas.c5, 0),      

ISNULL(uas.s6, 0), ISNULL(uas.l6, 0), ISNULL(uas.d6, 0), ISNULL(uas.c6, 0),      

ISNULL(uas.s7, 0), ISNULL(uas.l7, 0), ISNULL(uas.d7, 0), ISNULL(uas.c7, 0),      

ISNULL(uas.s8, 0), ISNULL(uas.l8, 0), ISNULL(uas.d8, 0), ISNULL(uas.c8, 0),      

ISNULL(uas.s9, 0), ISNULL(uas.l9, 0), ISNULL(uas.d9, 0), ISNULL(uas.c9, 0),      

ISNULL(uas.s10, 0), ISNULL(uas.l10, 0), ISNULL(uas.d10, 0), ISNULL(uas.c10, 0),      

ISNULL(uas.s11, 0), ISNULL(uas.l11, 0), ISNULL(uas.d11, 0), ISNULL(uas.c11, 0),      

ISNULL(uas.s12, 0), ISNULL(uas.l12, 0), ISNULL(uas.d12, 0), ISNULL(uas.c12, 0),      

ISNULL(uas.s13, 0), ISNULL(uas.l13, 0), ISNULL(uas.d13, 0), ISNULL(uas.c13, 0),      

ISNULL(uas.s14, 0), ISNULL(uas.l14, 0), ISNULL(uas.d14, 0), ISNULL(uas.c14, 0),      

ISNULL(uas.s15, 0), ISNULL(uas.l15, 0), ISNULL(uas.d15, 0), ISNULL(uas.c15, 0),      

ISNULL(uas.s16, 0), ISNULL(uas.l16, 0), ISNULL(uas.d16, 0), ISNULL(uas.c16, 0),      

ISNULL(uas.s17, 0), ISNULL(uas.l17, 0), ISNULL(uas.d17, 0), ISNULL(uas.c17, 0),      

ISNULL(uas.s18, 0), ISNULL(uas.l18, 0), ISNULL(uas.d18, 0), ISNULL(uas.c18, 0),      

ISNULL(uas.s19, 0), ISNULL(uas.l19, 0), ISNULL(uas.d19, 0), ISNULL(uas.c19, 0),    

ISNULL(uas.s20, 0), ISNULL(uas.l20, 0), ISNULL(uas.d20, 0), ISNULL(uas.c20, 0),      

ud.quest_flag, ud.face_index, ud.hair_shape_index, ud.hair_color_index,      

ud.nickname, ud.power_flag, ud.pledge_dismiss_time, ud.pledge_ousted_time, ud.pledge_withdraw_time, ud.surrender_war_id, ud.use_time, ud.drop_exp,

ISNULL( ub.status, 0), ISNULL( ub.ban_end , 0), ISNULL(ud.subjob_id , 0),

ud.subjob0_class, ud.subjob1_class, ud.subjob2_class, ud.subjob3_class, ISNULL(ssq_dawn_round, 0),

ISNULL(uun.color_rgb, 0x00ffffff),ISNULL(ud.wedding,0),ud.division,ud.pledge_group,ud.AcademyLev,ud.KarmaOrig,ud.PKdiff,ud.ST_face,ud.CursedTimeEquip,ISNULL(ud.TitleColor,0x00ffffff),ud.WeddingTelTime,

ISNULL(dyn.adena_drop,1),ISNULL(dyn.items_drop,1),ISNULL(dyn.spoil,1),ISNULL(dyn._exp,1),ISNULL(dyn._sp,1),ISNULL(SponsorId,0),

ISNULL(uas.s21, 0), ISNULL(uas.l21, 0), ISNULL(uas.d21, 0), ISNULL(uas.c21, 0),

ISNULL(uas.s22, 0), ISNULL(uas.l22, 0), ISNULL(uas.d22, 0), ISNULL(uas.c22, 0),

ISNULL(uas.s23, 0), ISNULL(uas.l23, 0), ISNULL(uas.d23, 0), ISNULL(uas.c23, 0),

ISNULL(uas.s24, 0), ISNULL(uas.l24, 0), ISNULL(uas.d24, 0), ISNULL(uas.c24, 0),

ud.ST_left_bracelet,ud.ST_right_bracelet,ud.ST_hairall,ud.ST_agathon,ud.souls,ud.transformation_id,ud.talisman1,ud.talisman2,ud.talisman3,ud.talisman4,ud.talisman5,ud.talisman6,

ISNULL(uas.s25, 0), ISNULL(uas.l25, 0), ISNULL(uas.d25, 0), ISNULL(uas.c25, 0),

ISNULL(uas.s26, 0), ISNULL(uas.l26, 0), ISNULL(uas.d26, 0), ISNULL(uas.c26, 0),

ISNULL(uas.s27, 0), ISNULL(uas.l27, 0), ISNULL(uas.d27, 0), ISNULL(uas.c27, 0),

ISNULL(uas.s28, 0), ISNULL(uas.l28, 0), ISNULL(uas.d28, 0), ISNULL(uas.c28, 0),

ISNULL(uas.s29, 0), ISNULL(uas.l29, 0), ISNULL(uas.d29, 0), ISNULL(uas.c29, 0),

ISNULL(uas.s30, 0), ISNULL(uas.l30, 0), ISNULL(uas.d30, 0), ISNULL(uas.c30, 0),

ISNULL(uas.s31, 0), ISNULL(uas.l31, 0), ISNULL(uas.d31, 0), ISNULL(uas.c31, 0),

ISNULL(uas.s32, 0), ISNULL(uas.l32, 0), ISNULL(uas.d32, 0), ISNULL(uas.c32, 0),

ISNULL(uas.s33, 0), ISNULL(uas.l33, 0), ISNULL(uas.d33, 0), ISNULL(uas.c33, 0),

ISNULL(uas.s34, 0), ISNULL(uas.l34, 0), ISNULL(uas.d34, 0), ISNULL(uas.c34, 0),

ISNULL(uas.s35, 0), ISNULL(uas.l35, 0), ISNULL(uas.d35, 0), ISNULL(uas.c35, 0),

ISNULL(uas.s36, 0), ISNULL(uas.l36, 0), ISNULL(uas.d36, 0), ISNULL(uas.c36, 0),

ISNULL(uas.s37, 0), ISNULL(uas.l37, 0), ISNULL(uas.d37, 0), ISNULL(uas.c37, 0),

ISNULL(uas.s38, 0), ISNULL(uas.l38, 0), ISNULL(uas.d38, 0), ISNULL(uas.c38, 0),

ISNULL(uas.s39, 0), ISNULL(uas.l39, 0), ISNULL(uas.d39, 0), ISNULL(uas.c39, 0),

ISNULL(uas.s40, 0), ISNULL(uas.l40, 0), ISNULL(uas.d40, 0), ISNULL(uas.c40, 0),

ISNULL(reputation_point,0)

FROM        

(SELECT * FROM User_data (nolock) WHERE char_id = @char_id) AS ud      

LEFT OUTER JOIN      

(SELECT * FROM user_ActiveSkill (nolock) WHERE char_id = @char_id) as uas ON ud.char_id = uas.char_id

left  OUTER JOIN

(select * from user_ban (nolock) where char_id = @char_id) as ub on ud.char_id = ub.char_id  

left OUTER JOIN

(select * from user_name_color (nolock) where char_id = @char_id) as uun on ud.char_id = uun.char_id

left OUTER JOIN

(select * from dynamic_rates (nolock) where acc_name=@acc) as dyn on @acc=dyn.acc_name

GO

 

Thanks

panchio Newbie

panchio

Posted
Posted

This files are expirable... after 3 weeks i got this " [19:57:56] Timeout expired " and a message with " Your data is gonna expirate soon " and pooom server closed.

Khelthor Newbie

Khelthor

Posted
Posted

Nice share, if you share with all of us regardless of the amount of posts i will share here the dvamp 1.75mb (1792kb) binaries with sabotage64.dll included + sql updates!

 

:)

Guest
This topic is now closed to further replies.
 Share
Go to topic listing


  • Posts

    • Griftercs69
      H5 L2Mythras Files - Sources, Compiled, Geo, Patch.

      By Griftercs69 · Posted

      buenas no puedo poner el server On para que entren mis amigos   LoginServer # ================================================= # Settings authorization server # ================================================= # Host and port for client connections LoginserverHostname = 127.0.0.1 LoginserverPort = 2106 # Host and port for game servers LoginHost = 192.168.100.25 ( mi Ip interna) LoginPort = 9014     GameServer   # =============================== # Network Configuration Server  # # =============================== # IP which Bind Game server, * - all possible GameserverHostname = * GameserverPort = 7777 # This is transmitted to the clients connecting from an external network, so it has to be a public IP or resolvable hostname ExternalHostname = 186.158.144.71 ( Ip externa ovbio) # This is transmitted to the client from the same network, so it has to be a local IP or resolvable host name InternalHostname = 192.168.100.25 # AdvIpSystem Make more GameServerIDs. Every Ip should be Protected by a DDoS Guard. # Your Server will have Success with this system Online. AdvIPSystem = False # Address \ port LS LoginPort = 9014 LoginHost = 192.168.100.25 LoginUseCrypt = true # How to request ID of LS RequestServerID = 4 # Permission to take a different id, if requested busy AcceptAlternateID = False     en que estaria fallando ?    
    • MarGaZeaS
      L2 Interlude C6 Private Server Project

      By MarGaZeaS · Posted

      mporeis na valeis l2jaCis i kapoio etimo project  free sources gia aCis edw https://acis.i-live.eu/index.php?topic=1974.0 server install ktl edw https://acis.i-live.eu/index.php?topic=10190.0 an dn vgaleis akrh steile mou discord margazeas2
    • bomarket
      ⭐️BUYING CSGO SKINS⭐️INSTANT CRYPTO / BANK

      By bomarket · Posted

      Bump
    • ghecko
      L2 Interlude C6 Private Server Project

      By ghecko · Posted

      Hello! I am new to l2 server creation and i need your help please!!! I want to make my own l2 interlude c6 server with custom thing in it.  I need help with where to start. What source pack to pick to start and what to do. Please if you can help me i would appreciate it very much !!!
    • Disvault
      Discord Accounts⚡️Early Supporter - Prices Updated ✅ Limited

      By Disvault · Posted

      Need Discord with rare badge? VISIT US AND SHOP WITH US! NEW STOCK   Aged, Early Supporter Discord Accounts I sell HQ Aged and Early, Discord Accounts that are inactive and not flagged by discord at cheap prices   If you want to contact me, you can add me on discord: worldcoldwar Features: Format - age : email : pass : token Not flagged and undetected by discord HQ % With OGE Emails, password etc can be changed Unverified Early Supporter 24M Boost Badge HypeSquad Events Early Verified Bot Developer Early Supporters SHOP LINK: disvault1.mypaylix.gg/ For PayPal payments, please open a ticket. If you experience any problems with cryptocurrency payments, please open a ticket as well.

  • Topics

×
×
  • Create New...

Important Information

This community uses essential cookies to function properly. Non-essential cookies and third-party services are used only with your consent. Read our Privacy Policy and We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue..