plz help

Quote:

Originally Posted by karrarserver i want sql... possible weapons professionalism Please <<<<<<<<<<<<<<<<<<<<<<<<<<<<< i have dss and nx3 but i need Something af you know wat i need Give me plzzzzzzz <<<<sorry for my englsh>>>> :D

Quote:

Originally Posted by eziorav Sorry i don't know what you need cause i didn't understand what you trying to say just write in your mother language then we use google to translate better than you did & next time use [Only registered and activated users can see links. Click Here To Register...]

Quote:

Originally Posted by karrarserver sorry for my english :(

Quote:

INSERT [dbo].[ItemResource] ([id], [name_id], [tooltip_id], [type], [group], [class], [wear_type], [set_id], [set_part_flag], [grade], [rank], [level], [enhance], [socket], [status_flag], [limit_deva], [limit_asura], [limit_gaia], [job_depth], [limit_fighter], [limit_hunter], [limit_magician], [limit_summoner], [use_min_level], [use_max_level], [target_min_level], [target_max_level], [range], [weight], [price], [huntaholic_point], [arena_point], [ethereal_durability], [endurance], [material], [summon_id], [item_use_flag], [available_period], [decrease_type], [throw_range], [base_type_0], [base_var1_0], [base_var2_0], [base_type_1], [base_var1_1], [base_var2_1], [base_type_2], [base_var1_2], [base_var2_2], [base_type_3], [base_var1_3], [base_var2_3], [opt_type_0], [opt_var1_0], [opt_var2_0], [opt_type_1], [opt_var1_1], [opt_var2_1], [opt_type_2], [opt_var1_2], [opt_var2_2], [opt_type_3], [opt_var1_3], [opt_var2_3], [effect_id], [enhance_0_id], [enhance_0_01], [enhance_0_02], [enhance_0_03], [enhance_0_04], [enhance_1_id], [enhance_1_01], [enhance_1_02], [enhance_1_03], [enhance_1_04], [skill_id], [state_id], [state_level], [state_time], [cool_time], [cool_time_group], [model_type_dem], [model_type_def], [model_type_asm], [model_type_asf], [model_type_gam], [model_type_gaf], [deco_model_change], [model_00], [model_01], [model_02], [model_03], [model_04], [model_05], [model_06], [model_07], [model_08], [model_09], [model_10], [model_11], [model_12], [model_13], [model_14], [model_15], [model_16], [model_17], [texture_filename], [drop_type], [icon_id], [icon_file_name], [script_text]) VALUES (105731, 105731, 1000105731, 1, 1, 105, 99, 0, 0, 0, 7, 1, 0, 4, 0, N'1', N'1', N'1', 15, N'1', N'1', N'1', N'1', 155, 300, 0, 0, CAST(0.60 AS Decimal(10, 2)), CAST(202.00 AS Decimal(10, 2)), 93548000, 0, 0, 1810000, 0, 3, 0, 16777216, 0, 0, CAST(0.00 AS Decimal(10, 2)), 11, CAST(1151.15 AS Decimal(12, 2)), CAST(11.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 14, CAST(-30.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 12, CAST(397.90 AS Decimal(12, 2)), CAST(5.20 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 102737, 11, CAST(2x.x0 AS Decimal(10, 2)), CAST(29.30 AS Decimal(10, 2)), CAST(35.20 AS Decimal(10, 2)), CAST(44.80 AS Decimal(10, 2)), 12, CAST(8.60 AS Decimal(10, 2)), CAST(10.00 AS Decimal(10, 2)), CAST(12.00 AS Decimal(10, 2)), CAST(15.30 AS Decimal(10, 2)), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'0', N'drop_weapon_axe', 0, N'Icon_2handaxe_dawnofhektor', N' ')

Quote:

Originally Posted by karrarserver oke >>>>>>اريد مساعة لتعريف الاسلحة يعني لما اريد اعدل عن الاسلحة وكذا حقت الاحتراف يعني مشكلة هالكود غلط انا معي هذه الكود لكنه غلط اريد الصحيح <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< i,have this code for the wapen but this not correct >>>> i mean <<< i,want Make new wapens With new colors plz anyone help me>>>>

INSERT [dbo].[ItemResource] ([id], [name_id], [tooltip_id], [type], [group], [class], [wear_type], [set_id], [set_part_flag], [grade], [rank], [level], [enhance], [socket], [status_flag], [limit_deva], [limit_asura], [limit_gaia], [job_depth], [limit_fighter], [limit_hunter], [limit_magician], [limit_summoner], [use_min_level], [use_max_level], [target_min_level], [target_max_level], [range], [weight], [price], [huntaholic_point], [arena_point], [ethereal_durability], [endurance], [material], [summon_id], [item_use_flag], [available_period], [decrease_type], [throw_range], [base_type_0], [base_var1_0], [base_var2_0], [base_type_1], [base_var1_1], [base_var2_1], [base_type_2], [base_var1_2], [base_var2_2], [base_type_3], [base_var1_3], [base_var2_3], [opt_type_0], [opt_var1_0], [opt_var2_0], [opt_type_1], [opt_var1_1], [opt_var2_1], [opt_type_2], [opt_var1_2], [opt_var2_2], [opt_type_3], [opt_var1_3], [opt_var2_3], [effect_id], [enhance_0_id], [enhance_0_01], [enhance_0_02], [enhance_0_03], [enhance_0_04], [enhance_1_id], [enhance_1_01], [enhance_1_02], [enhance_1_03], [enhance_1_04], [skill_id], [state_id], [state_level], [state_time], [cool_time], [cool_time_group], [model_type_dem], [model_type_def], [model_type_asm], [model_type_asf], [model_type_gam], [model_type_gaf], [deco_model_change], [model_00], [model_01], [model_02], [model_03], [model_04], [model_05], [model_06], [model_07], [model_08], [model_09], [model_10], [model_11], [model_12], [model_13], [model_14], [model_15], [model_16], [model_17], [texture_filename], [drop_type], [icon_id], [icon_file_name], [script_text]) VALUES (10572431, 105731, 1000105731, 1, 1, 105, 99, 0, 0, 0, 7, 1, 0, 4, 0, N'1', N'1', N'1', 15, N'1', N'1', N'1', N'1', 155, 300, 0, 0, CAST(0.60 AS Decimal(10, 2)), CAST(202.00 AS Decimal(10, 2)), 93548000, 0, 0, 1810000, 0, 3, 0, 16777216, 0, 0, CAST(0.00 AS Decimal(10, 2)), 11, CAST(1151.15 AS Decimal(12, 2)), CAST(11.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 14, CAST(-30.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 12, CAST(397.90 AS Decimal(12, 2)), CAST(5.20 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 102737, 11, CAST(0.00 AS Decimal(10, 2)), CAST(29.30 AS Decimal(10, 2)), CAST(35.20 AS Decimal(10, 2)), CAST(44.80 AS Decimal(10, 2)), 12, CAST(8.60 AS Decimal(10, 2)), CAST(10.00 AS Decimal(10, 2)), CAST(12.00 AS Decimal(10, 2)), CAST(15.30 AS Decimal(10, 2)), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'0', N'drop_weapon_axe', 0, N'Icon_2handaxe_dawnofhektor', N' ')

Quote:

Originally Posted by eziorav to make new weapons from old ones just change the id,name_id,text_id(better leave it like that if you don't fully understand what it does) 2- add a string for the name_id you changed 3- if you have any 3D design skills use the nx3 plugin to create your own weapons, if not or you have photoshop skills just edit the dds files 4- this the correct query for the item use arcadia Code: INSERT [dbo].[ItemResource] ([id], [name_id], [tooltip_id], [type], [group], [class], [wear_type], [set_id], [set_part_flag], [grade], [rank], [level], [enhance], [socket], [status_flag], [limit_deva], [limit_asura], [limit_gaia], [job_depth], [limit_fighter], [limit_hunter], [limit_magician], [limit_summoner], [use_min_level], [use_max_level], [target_min_level], [target_max_level], [range], [weight], [price], [huntaholic_point], [arena_point], [ethereal_durability], [endurance], [material], [summon_id], [item_use_flag], [available_period], [decrease_type], [throw_range], [base_type_0], [base_var1_0], [base_var2_0], [base_type_1], [base_var1_1], [base_var2_1], [base_type_2], [base_var1_2], [base_var2_2], [base_type_3], [base_var1_3], [base_var2_3], [opt_type_0], [opt_var1_0], [opt_var2_0], [opt_type_1], [opt_var1_1], [opt_var2_1], [opt_type_2], [opt_var1_2], [opt_var2_2], [opt_type_3], [opt_var1_3], [opt_var2_3], [effect_id], [enhance_0_id], [enhance_0_01], [enhance_0_02], [enhance_0_03], [enhance_0_04], [enhance_1_id], [enhance_1_01], [enhance_1_02], [enhance_1_03], [enhance_1_04], [skill_id], [state_id], [state_level], [state_time], [cool_time], [cool_time_group], [model_type_dem], [model_type_def], [model_type_asm], [model_type_asf], [model_type_gam], [model_type_gaf], [deco_model_change], [model_00], [model_01], [model_02], [model_03], [model_04], [model_05], [model_06], [model_07], [model_08], [model_09], [model_10], [model_11], [model_12], [model_13], [model_14], [model_15], [model_16], [model_17], [texture_filename], [drop_type], [icon_id], [icon_file_name], [script_text]) VALUES (10572431, 105731, 1000105731, 1, 1, 105, 99, 0, 0, 0, 7, 1, 0, 4, 0, N'1', N'1', N'1', 15, N'1', N'1', N'1', N'1', 155, 300, 0, 0, CAST(0.60 AS Decimal(10, 2)), CAST(202.00 AS Decimal(10, 2)), 93548000, 0, 0, 1810000, 0, 3, 0, 16777216, 0, 0, CAST(0.00 AS Decimal(10, 2)), 11, CAST(1151.15 AS Decimal(12, 2)), CAST(11.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 14, CAST(-30.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 12, CAST(397.90 AS Decimal(12, 2)), CAST(5.20 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 0, CAST(0.00 AS Decimal(12, 2)), CAST(0.00 AS Decimal(12, 2)), 102737, 11, CAST(0.00 AS Decimal(10, 2)), CAST(29.30 AS Decimal(10, 2)), CAST(35.20 AS Decimal(10, 2)), CAST(44.80 AS Decimal(10, 2)), 12, CAST(8.60 AS Decimal(10, 2)), CAST(10.00 AS Decimal(10, 2)), CAST(12.00 AS Decimal(10, 2)), CAST(15.30 AS Decimal(10, 2)), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'2handaxe_dawnofhektor', N'0', N'drop_weapon_axe', 0, N'Icon_2handaxe_dawnofhektor', N' ') hope i've helped you & use thanks button ;)

Quote:

Originally Posted by karrarserver thanks alot :)