Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 22:30

  • Please register to post and access all features, it's quick, easy and FREE!

 

[Help Thread] Please post your questions here.

Reply
 
Old   #616
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
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)



c1ph3r is offline  
Old   #617
 
elite*gold: 0
Join Date: Sep 2008
Posts: 64
Received Thanks: 5
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


Harmomix2007 is online now  
Old   #618
 
elite*gold: 0
Join Date: Oct 2011
Posts: 84
Received Thanks: 11
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
pprfds is offline  
Old   #619
 
elite*gold: 0
Join Date: Jun 2008
Posts: 104
Received Thanks: 14
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?


hackfever is offline  
Old   #620
 
elite*gold: 0
Join Date: Apr 2010
Posts: 389
Received Thanks: 289
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
Strange2010 is offline  
Old   #621
 
elite*gold: 0
Join Date: Jan 2011
Posts: 27
Received Thanks: 15
Post

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.
emekpc is offline  
Old   #622
 
elite*gold: 0
Join Date: Apr 2010
Posts: 389
Received Thanks: 289
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
Strange2010 is offline  
Old   #623
 
elite*gold: 0
Join Date: Jan 2011
Posts: 27
Received Thanks: 15
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:

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)

emekpc is offline  
Old   #624
 
elite*gold: 0
Join Date: Apr 2010
Posts: 389
Received Thanks: 289
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)

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

again THX
Strange2010 is offline  
Old   #625
 
elite*gold: 0
Join Date: Oct 2011
Posts: 84
Received Thanks: 11
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



the dbo monster table resource of the first arcadia



the dbo monster drop table resource of the second arcadia

pprfds is offline  
Old   #626
 
elite*gold: 0
Join Date: Aug 2011
Posts: 2
Received Thanks: 0
@@ there is no help till now?
dodo11dodo is offline  
Old   #627
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
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



the dbo monster table resource of the first arcadia



the dbo monster drop table resource of the second arcadia

c1ph3r is offline  
Thanks
1 User
Old   #628
 
elite*gold: 0
Join Date: Nov 2011
Posts: 66
Received Thanks: 4
Thumbs up

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~
ghost_h is offline  
Old   #629
 
elite*gold: 0
Join Date: Sep 2008
Posts: 1,570
Received Thanks: 1,154
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.
...
c1ph3r is offline  
Old   #630
 
elite*gold: 0
Join Date: Jul 2010
Posts: 374
Received Thanks: 378
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)


sominus is offline  
Reply

Tags
7.4, client, rappelz



« Previous Thread | Next Thread »

Similar Threads
[Helping Topic] 24/7 Helping Services!
stucked on anything while setuping your server? post your problem here and you will get answer as fast as possible better than spamming with posts...
31 Replies - EO PServer Hosting



All times are GMT +2. The time now is 22:30.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.