[Help Thread] Please post your questions here.

05/17/2012 09:36 c1ph3r#616
Quote:
Originally Posted by Harmomix2007 View Post
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.

Code:
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)
05/17/2012 10:28 Harmomix2007#617
Quote:
Originally Posted by c1ph3r View Post
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.

Code:
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
05/17/2012 18:10 pprfds#618
Quote:
Originally Posted by c1ph3r View Post
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
05/18/2012 06:37 hackfever#619
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?
05/18/2012 07:10 Strange2010#620
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
05/18/2012 09:14 emekpc#621
Quote:
Originally Posted by Strange2010 View Post
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.
05/18/2012 09:58 Strange2010#622
Quote:
Originally Posted by emekpc View Post
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
05/18/2012 11:09 emekpc#623
Quote:
Originally Posted by Strange2010 View Post
srry but i cant understand what u say ?
if u can talk arabic please pm me
Quote:
Originally Posted by Strange2010 View Post
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;

Quote:
Originally Posted by Strange2010 View Post
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:[Only registered and activated users can see links. Click Here To Register...]

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:[Only registered and activated users can see links. Click Here To Register...]
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|[Only registered and activated users can see links. Click Here To Register...] (opened_ip_on_firewall)|web_download_port|80|shop. url|[Only registered and activated users can see links. Click Here To Register...]
.....

and two port must be opened.

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

:rolleyes:
05/18/2012 11:29 Strange2010#624
Quote:
Originally Posted by emekpc View Post
look at this sample;


.....

and two port must be opened.

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

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

again THX
05/19/2012 14:08 pprfds#625
Quote:
Originally Posted by c1ph3r View Post
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

[Only registered and activated users can see links. Click Here To Register...]

the dbo monster table resource of the first arcadia

[Only registered and activated users can see links. Click Here To Register...]

the dbo monster drop table resource of the second arcadia

[Only registered and activated users can see links. Click Here To Register...]
05/20/2012 13:56 dodo11dodo#626
@@ there is no help till now?
05/22/2012 11:35 c1ph3r#627
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.

Quote:
Originally Posted by pprfds View Post
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

[Only registered and activated users can see links. Click Here To Register...]

the dbo monster table resource of the first arcadia

[Only registered and activated users can see links. Click Here To Register...]

the dbo monster drop table resource of the second arcadia

[Only registered and activated users can see links. Click Here To Register...]
05/22/2012 22:45 ghost_h#628
Quote:
Originally Posted by c1ph3r View Post
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~;)
05/22/2012 23:40 c1ph3r#629
Quote:
Originally Posted by c1ph3r View Post
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.
...
05/23/2012 01:25 sominus#630
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)