plz help

[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>>>>

[eziorav]

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>>>>

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

[karrarserver]

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

sorry for my english

[Prentis]

Originally Posted by karrarserver

sorry for my english

Post it in your language plz. Saying sorry won't help us help you

[karrarserver]

oke >>>>>>اريد مساعة لتعريف الاسلحة يعني لما اريد اعدل عن الاسلحة وكذا حقت الاحتراف يعني مشكلة هالكود غلط

انا معي هذه الكود لكنه غلط اريد الصحيح

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' ')

<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

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>>>>

[eziorav]

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>>>>

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

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

[karrarserver]

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

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

thanks alot

[Prentis]

Originally Posted by karrarserver

thanks alot

There's a thank button for that! :P

Thank eziorav