Jump to content

kanziguy

Members
  • Posts

    39
  • Credits

  • Joined

  • Last visited

  • Feedback

    0%

Everything posted by kanziguy

  1. please tell me how change areadata.txt and range please.
  2. where I find ertheia system patcher? (dimentioal stragers) I want patch my original system folder. (not patched system) help me please.
  3. hello, guys. I need protocol 606 korean client (system). help me please :D
  4. hello, sorry, I looking for korean ertheia client. protocl 606.

    can you help me?

  5. I looking for L2off GOD or CLASSIC server file. I want buy.
  6. I looking for official GOD server file. (like advext) help me.
  7. my test log: 1. try connect to server. 2. disconnect from server. 3. happen message in l2server window: [usersocket]unknown protocol 250 how fix this?
  8. ;Custom Enter World packet (default off = 0, on = 1) HashSystem=0 [HashSystem] ;Hash Code that will be checked in enterworld packet HashCode=20cbbcce3a0e712a93bc49018febd7d3 ;Check Mac Address at Enter World CheckMac=0 MaxAllowedClients=2 ;Check Client Version in custom packet (0=off any > 0 = version) ClientVersion=0
  9. client protocol is 744. server protocol revision is 744. same. and I can see server name in server list. but disconnect from server when double click server name.
  10. 1. use client revision 744. 2. changed server revision 744. 3. log in 4. I see server list. 5. double click server name. 6. disconnect from server. 7. re log in 8. aleady use account. what is wrong? hele me please.
  11. 1. use client revision 744. 2. changed server revision 744. 3. log in 4. I see server list. 5. double click server name. 6. disconnect from server. 7. re log in 8. aleady use account. what is wrong? hele me please.
  12. Can't running server on windows 2003 x64? open l2server patch console - 1.0 and? not happen anymore.
  13. 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
  14. HP/MP regen too fast... (character and monster)
×
×
  • Create New...