[Help Thread] Please post your questions here.

[c1ph3r]

Originally Posted by Harmomix2007

this will fix the Masterclass Skills

USE [Arcadia]
GO
insert into dbo.[StateResource] ([state_id], [text_id], [tooltip_id], [is_harmful], [state_time_type], [state_group], [duplicate_group_1], [duplicate_group_2], [duplicate_group_3], [uf_avatar], [uf_summon], [uf_monster], [reiteration_count], [base_effect_id], [fire_interval], [elemental_type], [amplify_base], [amplify_per_skl], [add_damage_base], [add_damage_per_skl], [effect_type], [value_0], [value_1], [value_2], [value_3], [value_4], [value_5], [value_6], [value_7], [value_8], [value_9], [value_10], [value_11], [value_12], [value_13], [value_14], [value_15], [value_16], [value_17], [value_18], [value_19], [icon_id], [icon_file_name], [fx_id], [pos_id], [cast_skill_id], [cast_fx_id], [cast_fx_pos_id], [hit_fx_id], [hit_fx_pos_id], [special_output_timing_id], [special_output_fx_id], [special_output_fx_pos_id], [special_output_fx_delay], [state_fx_id], [state_fx_pos_id]) Values(314060, 30314060, 60314060, N'0', 1, 0, 0, 0, 0, N'1', N'1', N'1', N'0', 0, 0, 0, 0, 0, 0, 0, 1, 2048, 0, 6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20009, N'icon_condition_0011_light_darkness_conditiontion ion', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)

insert into dbo.[StateResource] ([state_id], [text_id], [tooltip_id], [is_harmful], [state_time_type], [state_group], [duplicate_group_1], [duplicate_group_2], [duplicate_group_3], [uf_avatar], [uf_summon], [uf_monster], [reiteration_count], [base_effect_id], [fire_interval], [elemental_type], [amplify_base], [amplify_per_skl], [add_damage_base], [add_damage_per_skl], [effect_type], [value_0], [value_1], [value_2], [value_3], [value_4], [value_5], [value_6], [value_7], [value_8], [value_9], [value_10], [value_11], [value_12], [value_13], [value_14], [value_15], [value_16], [value_17], [value_18], [value_19], [icon_id], [icon_file_name], [fx_id], [pos_id], [cast_skill_id], [cast_fx_id], [cast_fx_pos_id], [hit_fx_id], [hit_fx_pos_id], [special_output_timing_id], [special_output_fx_id], [special_output_fx_pos_id], [special_output_fx_delay], [state_fx_id], [state_fx_pos_id]) Values(314061, 30314061, 60314061, N'0', 1, 0, 0, 0, 0, N'1', N'1', N'1', N'0', 0, 0, 0, 0, 0, 0, 0, 1, 4096, 0, -6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20009, N'icon_condition_0012_light_darkness_conditiontion ion', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)

insert into dbo.[StateResource] ([state_id], [text_id], [tooltip_id], [is_harmful], [state_time_type], [state_group], [duplicate_group_1], [duplicate_group_2], [duplicate_group_3], [uf_avatar], [uf_summon], [uf_monster], [reiteration_count], [base_effect_id], [fire_interval], [elemental_type], [amplify_base], [amplify_per_skl], [add_damage_base], [add_damage_per_skl], [effect_type], [value_0], [value_1], [value_2], [value_3], [value_4], [value_5], [value_6], [value_7], [value_8], [value_9], [value_10], [value_11], [value_12], [value_13], [value_14], [value_15], [value_16], [value_17], [value_18], [value_19], [icon_id], [icon_file_name], [fx_id], [pos_id], [cast_skill_id], [cast_fx_id], [cast_fx_pos_id], [hit_fx_id], [hit_fx_pos_id], [special_output_timing_id], [special_output_fx_id], [special_output_fx_pos_id], [special_output_fx_delay], [state_fx_id], [state_fx_pos_id]) Values(314019, 30314019, 60314019, N'0', 1, 0, 0, 0, 0, N'1', N'1', N'1', N'0', 0, 0, 0, 0, 0, 0, 0, 2, 33554432, 0, 0.2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20009, N'icon_skill_pas_mana_vitality_growth_conditiony_c ondition', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)

insert into dbo.[StateResource] ([state_id], [text_id], [tooltip_id], [is_harmful], [state_time_type], [state_group], [duplicate_group_1], [duplicate_group_2], [duplicate_group_3], [uf_avatar], [uf_summon], [uf_monster], [reiteration_count], [base_effect_id], [fire_interval], [elemental_type], [amplify_base], [amplify_per_skl], [add_damage_base], [add_damage_per_skl], [effect_type], [value_0], [value_1], [value_2], [value_3], [value_4], [value_5], [value_6], [value_7], [value_8], [value_9], [value_10], [value_11], [value_12], [value_13], [value_14], [value_15], [value_16], [value_17], [value_18], [value_19], [icon_id], [icon_file_name], [fx_id], [pos_id], [cast_skill_id], [cast_fx_id], [cast_fx_pos_id], [hit_fx_id], [hit_fx_pos_id], [special_output_timing_id], [special_output_fx_id], [special_output_fx_pos_id], [special_output_fx_delay], [state_fx_id], [state_fx_pos_id]) Values(314091, 30314091, 60314091, N'0', 1, 0, 0, 0, 0, N'1', N'1', N'1', N'0', 0, 0, 0, 0, 0, 0, 0, 26, 314093, 0, 1, 1, 10, 0, 0, 1, 110, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20000, N'icon_skill_act_slow_arrow_condition', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)

insert into dbo.[StateResource] ([state_id], [text_id], [tooltip_id], [is_harmful], [state_time_type], [state_group], [duplicate_group_1], [duplicate_group_2], [duplicate_group_3], [uf_avatar], [uf_summon], [uf_monster], [reiteration_count], [base_effect_id], [fire_interval], [elemental_type], [amplify_base], [amplify_per_skl], [add_damage_base], [add_damage_per_skl], [effect_type], [value_0], [value_1], [value_2], [value_3], [value_4], [value_5], [value_6], [value_7], [value_8], [value_9], [value_10], [value_11], [value_12], [value_13], [value_14], [value_15], [value_16], [value_17], [value_18], [value_19], [icon_id], [icon_file_name], [fx_id], [pos_id], [cast_skill_id], [cast_fx_id], [cast_fx_pos_id], [hit_fx_id], [hit_fx_pos_id], [special_output_timing_id], [special_output_fx_id], [special_output_fx_pos_id], [special_output_fx_delay], [state_fx_id], [state_fx_pos_id]) Values(314092, 30314092, 60314092, N'0', 1, 0, 0, 0, 0, N'1', N'1', N'1', N'0', 0, 0, 0, 0, 0, 0, 0, 26, 314094, 0, 1, 0, 10, 0, 0, 1, 110, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20000, N'icon_skill_act_slow_arrow_condition', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)

insert into dbo.[StateResource] ([state_id], [text_id], [tooltip_id], [is_harmful], [state_time_type], [state_group], [duplicate_group_1], [duplicate_group_2], [duplicate_group_3], [uf_avatar], [uf_summon], [uf_monster], [reiteration_count], [base_effect_id], [fire_interval], [elemental_type], [amplify_base], [amplify_per_skl], [add_damage_base], [add_damage_per_skl], [effect_type], [value_0], [value_1], [value_2], [value_3], [value_4], [value_5], [value_6], [value_7], [value_8], [value_9], [value_10], [value_11], [value_12], [value_13], [value_14], [value_15], [value_16], [value_17], [value_18], [value_19], [icon_id], [icon_file_name], [fx_id], [pos_id], [cast_skill_id], [cast_fx_id], [cast_fx_pos_id], [hit_fx_id], [hit_fx_pos_id], [special_output_timing_id], [special_output_fx_id], [special_output_fx_pos_id], [special_output_fx_delay], [state_fx_id], [state_fx_pos_id]) Values(314093, 30314093, 60314093, N'1', 1, 0, 0, 0, 0, N'1', N'1', N'1', N'0', 0, 0, 0, 0, 0, 0, 0, 2, 8192, -0.35, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 20021, N'icon_skill_act_slow_arrow_condition', 7040, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)

Don't really know why you want to add states 314091-314093 again because they are allready in the infinite db. And there is still one missing id in your insert script.

INSERT [dbo].[StateResource] ([state_id], [text_id], [tooltip_id], [is_harmful], [state_time_type], [state_group], [duplicate_group_1], [duplicate_group_2], [duplicate_group_3], [uf_avatar], [uf_summon], [uf_monster], [reiteration_count], [base_effect_id], [fire_interval], [elemental_type], [amplify_base], [amplify_per_skl], [add_damage_base], [add_damage_per_skl], [effect_type], [value_0], [value_1], [value_2], [value_3], [value_4], [value_5], [value_6], [value_7], [value_8], [value_9], [value_10], [value_11], [value_12], [value_13], [value_14], [value_15], [value_16], [value_17], [value_18], [value_19], [icon_id], [icon_file_name], [fx_id], [pos_id], [cast_skill_id], [cast_fx_id], [cast_fx_pos_id], [hit_fx_id], [hit_fx_pos_id], [special_output_timing_id], [special_output_fx_id], [special_output_fx_pos_id], [special_output_fx_delay], [state_fx_id], [state_fx_pos_id]) VALUES (314069, 30314069, 60314069, N'0', 1, 0, 0, 0, 0, N'1', N'1', N'1', 0, 0, 0, 0, CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), 0, 0, 2, CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(12288.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.060 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), 20009, N'icon_skill_act_penetration_focus_conditionditionion', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)

INSERT [dbo].[StateResource] ([state_id], [text_id], [tooltip_id], [is_harmful], [state_time_type], [state_group], [duplicate_group_1], [duplicate_group_2], [duplicate_group_3], [uf_avatar], [uf_summon], [uf_monster], [reiteration_count], [base_effect_id], [fire_interval], [elemental_type], [amplify_base], [amplify_per_skl], [add_damage_base], [add_damage_per_skl], [effect_type], [value_0], [value_1], [value_2], [value_3], [value_4], [value_5], [value_6], [value_7], [value_8], [value_9], [value_10], [value_11], [value_12], [value_13], [value_14], [value_15], [value_16], [value_17], [value_18], [value_19], [icon_id], [icon_file_name], [fx_id], [pos_id], [cast_skill_id], [cast_fx_id], [cast_fx_pos_id], [hit_fx_id], [hit_fx_pos_id], [special_output_timing_id], [special_output_fx_id], [special_output_fx_pos_id], [special_output_fx_delay], [state_fx_id], [state_fx_pos_id]) VALUES (314060, 30314060, 60314060, N'0', 1, 0, 0, 0, 0, N'1', N'1', N'1', 0, 0, 0, 0, CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), 0, 0, 1, CAST(2048.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(6.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), 20009, N'icon_condition_0011_light_darkness_conditiontionion', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)

INSERT [dbo].[StateResource] ([state_id], [text_id], [tooltip_id], [is_harmful], [state_time_type], [state_group], [duplicate_group_1], [duplicate_group_2], [duplicate_group_3], [uf_avatar], [uf_summon], [uf_monster], [reiteration_count], [base_effect_id], [fire_interval], [elemental_type], [amplify_base], [amplify_per_skl], [add_damage_base], [add_damage_per_skl], [effect_type], [value_0], [value_1], [value_2], [value_3], [value_4], [value_5], [value_6], [value_7], [value_8], [value_9], [value_10], [value_11], [value_12], [value_13], [value_14], [value_15], [value_16], [value_17], [value_18], [value_19], [icon_id], [icon_file_name], [fx_id], [pos_id], [cast_skill_id], [cast_fx_id], [cast_fx_pos_id], [hit_fx_id], [hit_fx_pos_id], [special_output_timing_id], [special_output_fx_id], [special_output_fx_pos_id], [special_output_fx_delay], [state_fx_id], [state_fx_pos_id]) VALUES (314061, 30314061, 60314061, N'0', 1, 0, 0, 0, 0, N'1', N'1', N'1', 0, 0, 0, 0, CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), 0, 0, 1, CAST(4096.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(-6.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), 20009, N'icon_condition_0012_light_darkness_conditiontionion', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)

[Harmomix2007]

Originally Posted by c1ph3r

Don't really know why you want to add states 314091-314093 again because they are allready in the infinite db. And there is still one missing id in your insert script.

INSERT [dbo].[StateResource] ([state_id], [text_id], [tooltip_id], [is_harmful], [state_time_type], [state_group], [duplicate_group_1], [duplicate_group_2], [duplicate_group_3], [uf_avatar], [uf_summon], [uf_monster], [reiteration_count], [base_effect_id], [fire_interval], [elemental_type], [amplify_base], [amplify_per_skl], [add_damage_base], [add_damage_per_skl], [effect_type], [value_0], [value_1], [value_2], [value_3], [value_4], [value_5], [value_6], [value_7], [value_8], [value_9], [value_10], [value_11], [value_12], [value_13], [value_14], [value_15], [value_16], [value_17], [value_18], [value_19], [icon_id], [icon_file_name], [fx_id], [pos_id], [cast_skill_id], [cast_fx_id], [cast_fx_pos_id], [hit_fx_id], [hit_fx_pos_id], [special_output_timing_id], [special_output_fx_id], [special_output_fx_pos_id], [special_output_fx_delay], [state_fx_id], [state_fx_pos_id]) VALUES (314069, 30314069, 60314069, N'0', 1, 0, 0, 0, 0, N'1', N'1', N'1', 0, 0, 0, 0, CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), 0, 0, 2, CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(12288.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.060 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), 20009, N'icon_skill_act_penetration_focus_conditionditionion', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)

INSERT [dbo].[StateResource] ([state_id], [text_id], [tooltip_id], [is_harmful], [state_time_type], [state_group], [duplicate_group_1], [duplicate_group_2], [duplicate_group_3], [uf_avatar], [uf_summon], [uf_monster], [reiteration_count], [base_effect_id], [fire_interval], [elemental_type], [amplify_base], [amplify_per_skl], [add_damage_base], [add_damage_per_skl], [effect_type], [value_0], [value_1], [value_2], [value_3], [value_4], [value_5], [value_6], [value_7], [value_8], [value_9], [value_10], [value_11], [value_12], [value_13], [value_14], [value_15], [value_16], [value_17], [value_18], [value_19], [icon_id], [icon_file_name], [fx_id], [pos_id], [cast_skill_id], [cast_fx_id], [cast_fx_pos_id], [hit_fx_id], [hit_fx_pos_id], [special_output_timing_id], [special_output_fx_id], [special_output_fx_pos_id], [special_output_fx_delay], [state_fx_id], [state_fx_pos_id]) VALUES (314060, 30314060, 60314060, N'0', 1, 0, 0, 0, 0, N'1', N'1', N'1', 0, 0, 0, 0, CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), 0, 0, 1, CAST(2048.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(6.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), 20009, N'icon_condition_0011_light_darkness_conditiontionion', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)

INSERT [dbo].[StateResource] ([state_id], [text_id], [tooltip_id], [is_harmful], [state_time_type], [state_group], [duplicate_group_1], [duplicate_group_2], [duplicate_group_3], [uf_avatar], [uf_summon], [uf_monster], [reiteration_count], [base_effect_id], [fire_interval], [elemental_type], [amplify_base], [amplify_per_skl], [add_damage_base], [add_damage_per_skl], [effect_type], [value_0], [value_1], [value_2], [value_3], [value_4], [value_5], [value_6], [value_7], [value_8], [value_9], [value_10], [value_11], [value_12], [value_13], [value_14], [value_15], [value_16], [value_17], [value_18], [value_19], [icon_id], [icon_file_name], [fx_id], [pos_id], [cast_skill_id], [cast_fx_id], [cast_fx_pos_id], [hit_fx_id], [hit_fx_pos_id], [special_output_timing_id], [special_output_fx_id], [special_output_fx_pos_id], [special_output_fx_delay], [state_fx_id], [state_fx_pos_id]) VALUES (314061, 30314061, 60314061, N'0', 1, 0, 0, 0, 0, N'1', N'1', N'1', 0, 0, 0, 0, CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), 0, 0, 1, CAST(4096.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(-6.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(13, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), CAST(0.000 AS Decimal(12, 3)), 20009, N'icon_condition_0012_light_darkness_conditiontionion', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0)

You are right i have copying the false ids the last 3 insert are false at my Post

[pprfds]

Originally Posted by c1ph3r

Go through your .lua files perhaps you have to fix some bugs in your .luas. Normally the Portal is shown up correctly. Same with the cube.

The Jobchange can be fixed in the .lua and the message too.

Add them in the Database Arcadia.dbo.DropGroupResource

i found the files of the cube but i didnt test it

i try to edit it in the drop grop resource but all my tries not working

[hackfever]

Ive updated the maps on my server from the client and for some reason the warp for vulcanus still dont show with quest or without quest ive looked in each lua and dbo feild prop resource any ideas please?

[Strange2010]

hi guys

i am facing a small problem here

i have 7.3 server and want to make it on hamachi , i changed the ip in gameserver and authserver but no 1 can login to my server !!

this is what i changed :
GAMESERVER.opt
S io.ip_address
S io.auth_ip

and in AUTHSERVER.opt :
S log.ip

i changed them to my hamachi ip but every 1 who tries to login to my server gets 'cant connect to index server'
and YES i compressed the files after changes

[emekpc]

Originally Posted by Strange2010

hi guys

i am facing a small problem here

i have 7.3 server and want to make it on hamachi , i changed the ip in gameserver and authserver but no 1 can login to my server !!

this is what i changed :
GAMESERVER.opt
S io.ip_address
S io.auth_ip

and in AUTHSERVER.opt :
S log.ip

i changed them to my hamachi ip but every 1 who tries to login to my server gets 'cant connect to index server'
and YES i compressed the files after changes

only two ip must be real ip... its 'io.ip_address' - port and 'io.upload.ip' - ports. for guild icon upload, must open two port. and finally 4500 port open must be. because this port for security connection. other all ip and port must be closed for security reason. if you use telnet port, -that, i dont advice- must be open.

[Strange2010]

Originally Posted by emekpc

only two ip must be real ip... its 'io.ip_address' - port and 'io.upload.ip' - ports. for guild icon upload, must open two port. and finally 4500 port open must be. because this port for security connection. other all ip and port must be closed for security reason. if you use telnet port, -that, i dont advice- must be open.

srry but i cant understand what u say ?
if u can talk arabic please pm me

[emekpc]

Originally Posted by Strange2010

srry but i cant understand what u say ?
if u can talk arabic please pm me

Originally Posted by Strange2010

hi guys

i am facing a small problem here

i have 7.3 server and want to make it on hamachi , i changed the ip in gameserver and authserver but no 1 can login to my server !!

this is what i changed :
GAMESERVER.opt
S io.ip_address
S io.auth_ip

and in AUTHSERVER.opt :
S log.ip

i changed them to my hamachi ip but every 1 who tries to login to my server gets 'cant connect to index server'
and YES i compressed the files after changes

look at this sample;

Originally Posted by Strange2010

S io.port:xxxx (opened_port_on_firewall)
S io.ip_address:xxx.xxx.xxx.xxx (opened_ip_on_firewall)

S game.server_screenshot_url:

S io.upload.ip:xxx.xxx.xxx.xxx (opened_ip_on_firewall)
S io.upload.port:xxxx (opened_port_on_firewall)
S game.guild_icon_base_url:
S game.url_list:guild_icon_upload.ip|xxx.xxx.xxx.xxx (opened_ip_on_firewall) |guild_icon_upload.port|xxxx (opened_port_on_firewall) |guild.url| (opened_ip_on_firewall)|web_download_port|80|shop. url|

.....

and two port must be opened.

4500 (opened_port_on_firewall)
console.port:xxxx (opened_port_on_firewall)

[Strange2010]

Originally Posted by emekpc

look at this sample;


.....

and two port must be opened.

4500 (opened_port_on_firewall)
console.port:xxxx (opened_port_on_firewall)

thx very much i stopped firewall and it worked !
now i will start firewall and open the ports i use

again THX

[pprfds]

Originally Posted by c1ph3r

Go through your .lua files perhaps you have to fix some bugs in your .luas. Normally the Portal is shown up correctly. Same with the cube.

The Jobchange can be fixed in the .lua and the message too.

Add them in the Database Arcadia.dbo.DropGroupResource

after many tries i can make the arcadia drop the volcano larms but

it dont drop Essence of Power or Conentrated Power

i used two diffrent arcadia the first drop the volcano larms but dont drop Essence of power or Conentrated Power

the second arcadia drop Essence of power and Conentrated Power but dont drop volcano larms (i tried both of them in the same code) so i opened dbo monester drop table resource but i dont know what to change to make the Essence of Power or Conentrated Power drop

the script i used



the dbo monster table resource of the first arcadia



the dbo monster drop table resource of the second arcadia

[dodo11dodo]

@@ there is no help till now?

[c1ph3r]

Don't mess up with different tables from different dbs! Create your own DropTable...

Go through the dbo.dropgroupresource and search your item. perhaps it's allready in the dropgroupresource and only set to 0%. If it's not in there you have to add the item.

dropgroup_id in dbo.monsterresource is the reference to the monsterdroptable. drop_item_id_00 to drop_item_id_09 in monsterdroptabele are the references to dropgroupresource.

Originally Posted by pprfds

after many tries i can make the arcadia drop the volcano larms but

it dont drop Essence of Power or Conentrated Power

i used two diffrent arcadia the first drop the volcano larms but dont drop Essence of power or Conentrated Power

the second arcadia drop Essence of power and Conentrated Power but dont drop volcano larms (i tried both of them in the same code) so i opened dbo monester drop table resource but i dont know what to change to make the Essence of Power or Conentrated Power drop

the script i used



the dbo monster table resource of the first arcadia



the dbo monster drop table resource of the second arcadia

[ghost_h]

Originally Posted by c1ph3r

Don't mess up with different tables from different dbs! Create your own DropTable...

Go through the dbo.dropgroupresource and search your item. perhaps it's allready in the dropgroupresource and only set to 0%. If it's not in there you have to add the item.

dropgroup_id in dbo.monsterresource is the reference to the monsterdroptable. drop_item_id_00 to drop_item_id_09 in monsterdroptabele are the references to dropgroupresource.

i want to know where Control the drop_percentage and the min/max count,because the monsterdroptable and dropgroupresource all have it..which one?thx~

[c1ph3r]

Originally Posted by c1ph3r

Don't mess up with different tables from different dbs! Create your own DropTable...

Go through the dbo.dropgroupresource and search your item. perhaps it's allready in the dropgroupresource and only set to 0%. If it's not in there you have to add the item.

dropgroup_id in dbo.monsterresource is the reference to the monsterdroptable. drop_item_id_00 to drop_item_id_09 in monsterdroptabele are the references to dropgroupresource.

...

[sominus]

I need to know what client do I need to play on this:

-Windows 7 x64
-Sql Server 2012
-Game Server posted here on EP (from JW988's post)