[Help Thread] Please post your questions here.

[ThunderNikk]

That is where all game accounts are created and stored.

[salientheroes]

can you help explaining the final step in these guide?



kinda lost to where do i create the admin account and one more thing, how do i launch the game? i mean by launching the rappelzcmdlauncher.exe?

[ThunderNikk]

I just told you you create accounts in that table auth.dbo.accounts

That is where you create your "Game" "Admin" or "GM" account whatever you want to call it. Just make sure to give the account "GM" or "Admin" permission level for commands. That would be permission 100.

Follow the instructions for the MD5 hash.

You launch the game by setting up the .bat file example in the guide...

RappelzCmdLauncher.exe sframe.exe /auth_ip:127.0.0.1 /auth_port:58422 /use_nprotect:0 /help_url_w:611 /help_url_h:625 /locale:ASCII /country:US /cash /commercial_shop /layout_dir:6 /layout_auto:0 /cash_url_w:800 /cash_url_h:631

[アルカード]

Anyone got 9.1 item modder?i can't use any tool on elitepvpers with this 9.1 server

[アルカード]

I am trying to add this to sql but this is error i get always idk what is issue

[kojima2501]

Hiiiii all how to do this pls : i use Post implantation 9.3 Monster model + map

add_field_prop( 121191, 0, 153241, 77247, 0, 0, 0, 0, 0.75, 0.3, 0.3, 0.3 )

with 100 perm in game i enter this and i have nothing : /addfieldprop( 121191, 0, 153241, 77247, 0, 0, 0, 0, 0.75, 0.3, 0.3, 0.3 )
And /add_field_prop( 121191, 0, 153241, 77247, 0, 0, 0, 0, 0.75, 0.3, 0.3, 0.3 )

possibility to implante in NPC Lua for warp in dungeon like underground 160 ?

[ThunderNikk]

Have you added the 9.3 prop to your 9.1 field prop resource table yet?

[Sherock]

how to convert the returning value of (get_os_time() ) to known date and time ?

[SilentWisdom]

That function returns seconds since UNIX epoch. Google how to convert seconds to date time

[kojima2501]

Re thndr
yes i add prop sql in 9.1 database :

 Spoiler

http://hpics.li/8479f67

Another problem i try with other dungeon gate:
/add_field_prop( 130091, 0, 153241, 77247, 0, 0, 0, 0, 0.75, 0.3, 0.3, 0.3 )

and same problem with one Id 9.1 i see nothing in poss 153241, 77247
i try with other poss but not work too

i don't know why didn't work ....

[SilentWisdom]

Did you export the dbo.FieldPropResource -> db_fieldpropresource.rdb? :P

[kojima2501]

Originally Posted by SilentWisdom

Did you export the dbo.FieldPropResource -> db_fieldpropresource.rdb? :P

Hi =)
yes SilentWisdom i load FieldProp81Database.dll in Rdbtool , save in rdb nohased and add db_fieldpropresource.rdb in Client data.000 with Grimoire
+ i add dbo.FieldPropResource Save rdb file hashed with rdbtool for Ressource Client
But still no work .. T_T XD

i need other solution than Gate ... possibility to inser in Npc with warp ? i just need x & y inside dungeon if u have =)

and thx for ur help all <3

Ty Lamia work with /run add_field_prop()

[InkDevil]

Originally Posted by kojima2501

Hi =)
yes SilentWisdom i load FieldProp81Database.dll in Rdbtool , save in rdb nohased and add db_fieldpropresource.rdb in Client data.000 with Grimoire
+ i add dbo.FieldPropResource Save rdb file hashed with rdbtool for Ressource Client
But still no work .. T_T XD

i need other solution than Gate ... possibility to inser in Npc with warp ? i just need x & y inside dungeon if u have =)

and thx for ur help all <3

You know you have to use /run add_field_prop() and not /add_field_prop() if you want to spawn your prop manually via ingame-command..?

[kojima2501]

Re
i need learn how to found ID MonsterRessource in ItemRessource whith one ID scroll summoning Monster

in ItemRessource i take All summoning Abhuva

like this :

 Spoiler

/****** Script for SelectTopNRows command from SSMS ******/
SELECT *
FROM [Arcadia].[dbo].[ItemResource]
where id='3631032' Or id ='3631033'Or id ='3631051'Or id ='3631070'Or id ='3631089'

and result Query :
** Left- right page for see all table**

 Spoiler

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_id	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
3631032	13631032	23631032	3	99	0	-1	0	0	0	0	1	0	0	0	1	1	1	15	1	1	1	1	0	0	0	0	0.00	1.00	75000000	0	0	0	0	9	0	1165762632	0	0	0.00	0	0.00	0.00	0	0.00	0.00	0	0.00	0.00	0	0.00	0.00	5	65090.00	2.00	0	0.00	0.00	0	0.00	0.00	0	0.00	0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	drop_etc_scroll	0
3631033	13631033	23631033	3	99	0	-1	0	0	0	0	1	0	0	0	1	1	1	15	1	1	1	1	0	0	0	0	0.00	1.00	75000000	0	0	0	0	9	0	1165762632	0	0	0.00	0	0.00	0.00	0	0.00	0.00	0	0.00	0.00	0	0.00	0.00	5	65090.00	3.00	0	0.00	0.00	0	0.00	0.00	0	0.00	0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	drop_etc_scroll	0
3631051	13631051	23631051	3	99	0	-1	0	0	0	0	1	0	0	0	1	1	1	15	1	1	1	1	0	0	0	0	0.00	1.00	75000000	0	0	0	0	9	0	1165762632	0	0	0.00	0	0.00	0.00	0	0.00	0.00	0	0.00	0.00	0	0.00	0.00	5	65091.00	1.00	0	0.00	0.00	0	0.00	0.00	0	0.00	0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	drop_etc_scroll	0
3631070	13631070	23631070	3	99	0	-1	0	0	0	0	1	0	0	0	1	1	1	15	1	1	1	1	0	0	0	0	0.00	1.00	75000000	0	0	0	0	9	0	1165762632	0	0	0.00	0	0.00	0.00	0	0.00	0.00	0	0.00	0.00	0	0.00	0.00	5	65091.00	20.00	0	0.00	0.00	0	0.00	0.00	0	0.00	0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	drop_etc_scroll	0
3631089	13631089	23631089	3	99	0	-1	0	0	0	0	1	0	0	0	1	1	1	15	1	1	1	1	0	0	0	0	0.00	1.00	75000000	0	0	0	0	9	0	1165762632	0	0	0.00	0	0.00	0.00	0	0.00	0.00	0	0.00	0.00	0	0.00	0.00	5	65092.00	19.00	0	0.00	0.00	0	0.00	0.00	0	0.00	0.00	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	drop_etc_scroll	0

i see Opt_typ i think this is value for summoning

but opt_var1_0 and opt_var2_0 no idea ... =X

And ty for ur help ^^ <3

[ThunderNikk]

You know you could have just wrote...

Select * FROM [Arcadia].[dbo].[ItemResource]
where id='3631032' Or id ='3631033'Or id ='3631051'Or id ='3631070'Or id ='3631089'

about opt var values I am not sure but you could take a look at each one in game and see if there is a difference.