[Help Thread] Please post your questions here.

[thefear511]

Originally Posted by NH4NO3+Fuel Oil

Ok, I made it, server running. Now I'm having some troubles with gameguard (err code 150) when I launch the Sframe. I checked gameserver.opt, but N:game.use_security: is already set to 0... Any idea ?

Ok, sorted out. One last doubt... is language localization on client or on server side ?

uuh its a file string.rdb , you can get one arabic and another english. there was a time i had a perfect match with sframe & launcher argument the only thing i had to edit was only the string file replace english with arabic and visa versa.

but in 9.4 u must use english sframe with US encoding in launcher and also an english string to have it fully functional.im not aware if there's another work-around to run multiple languages without doing all this stuff.

[1nternalError]

hello, who then has a skillresource of 6.2 rdb for rmob?

[thefear511]

Originally Posted by 1nternalError

hello, who then has a skillresource of 6.2 rdb for rmob?

what's rmob?
edit: i grabbed some files for you from a fresh 6.2 client if thats what you want.

[アルカード]

Originally Posted by thefear511

what's rmob?
edit: i grabbed some files for you from a fresh 6.2 client if thats what you want.

I think he means rmod from ismokedrow and he would like to have 6.2 skill rdb editor

[thefear511]

Originally Posted by アルカード

I think he means rmod from ismokedrow and he would like to have 6.2 skill rdb editor

oh , he needs structre for 6.2 skillresource. well thats gonna be pain in the *** xd
@
bring me the skillresource schema from 6.2 sql and ill try to make the structre for you.

[NH4NO3+Fuel Oil]

Really no way to use SQL Studio 2014 on Redemption 9.4 release' databases ?
I've create a root machine with W8, installed SQL Server 2017 Dev edition, Management Studio 2017 was not included.
I dld it from official MS page, installed, but I can't launch it (various dlls and missing components errors). I've tried nearly all possible workaround but to no use...
SQL Server 2017 works, but Management Studio 2017 doesn't... My system is definitely refusing it...
Really driving me nuts...

[1nternalError]

Originally Posted by thefear511

oh , he needs structre for 6.2 skillresource. well thats gonna be pain in the *** xd
@
bring me the skillresource schema from 6.2 sql and ill try to make the structre for you.

 Spoiler

USE [Arcadia62]
GO

/****** Object: Table [dbo].[SkillResource] Script Date: 04.09.2018 11:45:19 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[SkillResource](
[id] [int] NOT NULL,
[text_id] [int] NOT NULL,
[desc_id] [int] NOT NULL,
[tooltip_id] [int] NOT NULL,
[is_valid] [tinyint] NOT NULL,
[elemental] [char](1) NOT NULL,
[is_passive] [char](1) NOT NULL,
[is_physical_act] [char](1) NOT NULL,
[is_harmful] [char](1) NOT NULL,
[is_need_target] [char](1) NOT NULL,
[is_corpse] [char](1) NOT NULL,
[is_toggle] [char](1) NOT NULL,
[toggle_group] [int] NOT NULL,
[casting_type] [char](1) NOT NULL,
[casting_level] [char](1) NOT NULL,
[cast_range] [int] NOT NULL,
[valid_range] [int] NOT NULL,
[cost_hp] [int] NOT NULL,
[cost_hp_per_skl] [int] NOT NULL,
[cost_mp] [int] NOT NULL,
[cost_mp_per_skl] [int] NOT NULL,
[cost_mp_per_enhance] [int] NOT NULL,
[cost_hp_per] [decimal](10, 2) NOT NULL,
[cost_hp_per_skl_per] [decimal](10, 2) NOT NULL,
[cost_mp_per] [decimal](10, 2) NOT NULL,
[cost_mp_per_skl_per] [decimal](10, 2) NOT NULL,
[cost_havoc] [int] NOT NULL,
[cost_havoc_per_skl] [int] NOT NULL,
[cost_energy] [decimal](10, 2) NOT NULL,
[cost_energy_per_skl] [decimal](10, 2) NOT NULL,
[cost_exp] [int] NOT NULL,
[cost_exp_per_enhance] [int] NOT NULL,
[cost_jp] [int] NOT NULL,
[cost_jp_per_enhance] [int] NOT NULL,
[cost_item] [int] NOT NULL,
[cost_item_count] [int] NOT NULL,
[cost_item_count_per_skl] [int] NOT NULL,
[need_level] [int] NOT NULL,
[need_hp] [int] NOT NULL,
[need_mp] [int] NOT NULL,
[need_havoc] [int] NOT NULL,
[need_havoc_burst] [int] NOT NULL,
[need_state_id] [int] NOT NULL,
[need_state_level] [tinyint] NOT NULL,
[need_state_exhaust] [tinyint] NOT NULL,
[vf_one_hand_sword] [char](1) NOT NULL,
[vf_two_hand_sword] [char](1) NOT NULL,
[vf_double_sword] [char](1) NOT NULL,
[vf_dagger] [char](1) NOT NULL,
[vf_double_dagger] [char](1) NOT NULL,
[vf_spear] [char](1) NOT NULL,
[vf_axe] [char](1) NOT NULL,
[vf_one_hand_axe] [char](1) NOT NULL,
[vf_double_axe] [char](1) NOT NULL,
[vf_one_hand_mace] [char](1) NOT NULL,
[vf_two_hand_mace] [char](1) NOT NULL,
[vf_lightbow] [char](1) NOT NULL,
[vf_heavybow] [char](1) NOT NULL,
[vf_crossbow] [char](1) NOT NULL,
[vf_one_hand_staff] [char](1) NOT NULL,
[vf_two_hand_staff] [char](1) NOT NULL,
[vf_shield_only] [char](1) NOT NULL,
[vf_is_not_need_weapon] [char](1) NOT NULL,
[delay_cast] [decimal](10, 2) NOT NULL,
[delay_cast_per_skl] [decimal](10, 2) NOT NULL,
[delay_cast_mode_per_enhance] [decimal](10, 2) NOT NULL,
[delay_common] [decimal](10, 2) NOT NULL,
[delay_cooltime] [decimal](10, 2) NOT NULL,
[delay_cooltime_mode_per_enhance] [decimal](10, 2) NOT NULL,
[cool_time_group_id] [int] NOT NULL,
[uf_self] [char](1) NOT NULL,
[uf_party] [char](1) NOT NULL,
[uf_guild] [char](1) NOT NULL,
[uf_neutral] [char](1) NOT NULL,
[uf_purple] [char](1) NOT NULL,
[uf_enemy] [char](1) NOT NULL,
[tf_avatar] [char](1) NOT NULL,
[tf_summon] [char](1) NOT NULL,
[tf_monster] [char](1) NOT NULL,
[target] [smallint] NOT NULL,
[effect_type] [smallint] NOT NULL,
[state_id] [int] NOT NULL,
[state_level_base] [int] NOT NULL,
[state_level_per_skl] [decimal](10, 2) NOT NULL,
[state_level_per_enhance] [decimal](10, 2) NOT NULL,
[state_second] [decimal](10, 2) NOT NULL,
[state_second_per_level] [decimal](10, 2) NOT NULL,
[state_second_per_enhance] [decimal](10, 2) NOT NULL,
[state_type] [char](1) NOT NULL,
[probability_on_hit] [int] NOT NULL,
[probability_inc_by_slv] [int] NOT NULL,
[hit_bonus] [smallint] NOT NULL,
[hit_bonus_per_enhance] [smallint] NOT NULL,
[percentage] [smallint] NOT NULL,
[hate_mod] [decimal](10, 2) NOT NULL,
[hate_basic] [smallint] NOT NULL,
[hate_per_skl] [decimal](10, 2) NOT NULL,
[hate_per_enhance] [decimal](10, 2) NOT NULL,
[critical_bonus] [int] NOT NULL,
[critical_bonus_per_skl] [int] NOT NULL,
[var1] [decimal](12, 4) NOT NULL,
[var2] [decimal](12, 4) NOT NULL,
[var3] [decimal](12, 4) NOT NULL,
[var4] [decimal](12, 4) NOT NULL,
[var5] [decimal](12, 4) NOT NULL,
[var6] [decimal](12, 4) NOT NULL,
[var7] [decimal](12, 4) NOT NULL,
[var8] [decimal](12, 4) NOT NULL,
[var9] [decimal](12, 4) NOT NULL,
[var10] [decimal](12, 4) NOT NULL,
[var11] [decimal](12, 4) NOT NULL,
[var12] [decimal](12, 4) NOT NULL,
[var13] [decimal](12, 4) NOT NULL,
[var14] [decimal](12, 4) NOT NULL,
[var15] [decimal](12, 4) NOT NULL,
[var16] [decimal](12, 4) NOT NULL,
[var17] [decimal](12, 4) NOT NULL,
[var18] [decimal](12, 4) NOT NULL,
[var19] [decimal](12, 4) NOT NULL,
[var20] [decimal](12, 4) NOT NULL,
[icon_id] [int] NOT NULL,
[icon_file_name] [varchar](256) NULL,
[is_projectile] [tinyint] NOT NULL,
[projectile_speed] [decimal](10, 2) NOT NULL,
[projectile_acceleration] [decimal](10, 2) NOT NULL,
CONSTRAINT [UQ__SkillResource__6225902D] UNIQUE NONCLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

[ThunderNikk]

Originally Posted by NH4NO3+Fuel Oil

I've create a root machine with W8, installed SQL Server 2017 Dev edition, Management Studio 2017 was not included.

You don't mean Windows 8 do you? Or do you mean Server 2008?

[NH4NO3+Fuel Oil]

Yep, I mean Windows 8.1 PRO, not Windows Server 2008

[ThunderNikk]

That was a 64 bit Windows 8.1 install?

There are a ton of installation tips and troubleshooting steps on this page...

[NH4NO3+Fuel Oil]

Thank you for the support, I managed to start it by updating runtime components, but now as soon as SQL Management Studio starts, a banner pops up saying that Visual Studio license has expired... Sounds like persecution
Now I fully understand why I've neverupgraded my W7 to any newer **** from MicroBSOD

[ThunderNikk]

Open Visual studio and register it.

[TheMutsu]

Hello Everyone, i have trouble finding specific Item IDs. I have tried all the different Query Requests i could find in the forum but my results always have 0 rows affected after searching for a specific item. Also tried very common Items.

The Server files i used:
The client files i used:

[Dark Blaze]

Originally Posted by TheMutsu

Hello Everyone, i have trouble finding specific Item IDs. I have tried all the different Query Requests i could find in the forum but my results always have 0 rows affected after searching for a specific item. Also tried very common Items.

The Server files i used:
The client files i used:

Can you post the query you're using?

[ThunderNikk]

Originally Posted by TheMutsu

Hello Everyone, i have trouble finding specific Item IDs. I have tried all the different Query Requests i could find in the forum but my results always have 0 rows affected after searching for a specific item. Also tried very common Items.

The Server files i used:
The client files i used:

A lot of item queries are join statements with the string resource.

The server files come by default using the Arabic string resource.

Make sure you change that to the string resource of your language.