[Help Thread] Please post your questions here.

[nimoht]

Originally Posted by tokesbowls

Guess no one wants to answer my question. :-(

Or can't !
i don't know the blue and red sheep, have you got screens ?
I don't know e unique and s4g ( items pet cards summon cards )

I'm french, don't know this words , give example.

Hy all
First problem :
i search full help web site source in English or French because this don't work :

 Spoiler

S:game.helpdesk_url:
S:game.newbiehelp_asura_url:
S:game.newbiehelp_deva_url:
S:game.newbiehelp_gaia_url:

I don't know how to get it by official .
If anyone have it and can release it , thank's a lot

Second problem :
I need to can connect to my server by external and local network :
i have 3 pc on my local network ( one with the server and client and two with just the client ) and betwin five at ten pc on external network ( not the same local network for them ) , these are friends .
I don't want to use Hamashi , i have an great network connection by my network dealer .
if i make this : 192.168.1.150 = local pc adress with rooter nat rules and all needed ports open 15574 4500)
S:io.port:15574
S:io.auth.ip:192.168.1.150
S:io.ip_address:192.168.1.150
and put my external rooter ip on launchers of my friends , it can't connect ;
me and my local pc's with 192.168.1.150 on the launcher can connect .
if i change S:io.auth.ip:external rooter adress game server can't connect to auth .
if i make this :
S:io.port:15574
S:io.auth.ip:192.168.1.150
S:io.ip_address:external rooter adress
nobody can connect .
for all settings i tested if game server connect to auth the result in game server console is :
Connect to Auth... ok
Adding auth connection to IOCP... ok
Acceptor initialize... ok(IP: 0.0.0.0, Port: 15574)
Adding acceptor to IOCP... ok

auth.opt :

 Spoiler

auth.db.server:127.0.0.1
auth.db.port:1433
auth.db.name:Auth
auth.db.account:my auth account
auth.db.password:my password
auth.db.salt:2011

auth.clients.ip:192.168.1.150
auth.clients.port:58422
auth.clients.des_key:MERONG
auth.clients.maxpublicserveridx:10

auth.gameserver.ip:192.168.1.150
auth.gameserver.port:4502

upload.dir=upload
upload.gameserver.ip:192.168.1.150
upload.gameserver.port:4616

upload.clients.ip:192.168.1.150
upload.clients.port:4617

upload.iconserver.ip:192.168.1.150
upload.iconserver.port:5000

sql.db_account.column.serveridxoffset:server_list_ mask

core.log.level:trace
core.log.consolelevel:info

sql.db_account.query:SELECT * FROM Account WITH(NOLOCK) WHERE login_name = ? AND password = ?;

game.opt :

 Spoiler

S:app.name:Game001
T:auth.server_idx:1
S:auth.server_name:RappelzFamily

S:db.c.server:127.0.0.1
S:db.c.name:Arcadia
S:db.c.account:my arcadia account
S:db.c._password:my arcadia pass
S:db.user.server:127.0.0.1
S:db.user.name:Telecaster
S:db.user.account:my telecaster account
S:db.user._password:my telecaster pass
T:db.user.thread:4

S:io.upload.ip:192.168.1.150
S:io.upload.port:4616
S:game.guild_icon_base_url:192.168.1.150:5000/upload/
S:game.url_list:guild_icon_upload.ip|192.168.1.150 |guild_icon_upload.port|4617|guild_test_download.u rl|upload/|web_download|192.168.1.150:5000|shop.url|

N:console.port:44554
S:console.allow_ip:127.0.0.1
S:console._password:

S:log.chat.ip:127.0.0.1
S:log.ip:127.0.0.1
T:log.chat.working:0
T:log.working:0
T:log.disable:1

S:io.port:15574
S:io.auth.ip:192.168.1.150
S:io.ip_address:192.168.1.150

T:game.update.version:24
T:game.max_level:180
T:game.PKServer:1
T:game.AdultServer:0
T:game.cash_usable_server:1
S:game.local_flag:128
T:game.min_global_chat_usable_level:1
T:game.use_auto_trap:0
T:game.use_auto_jail:0
T:game.ServiceServer:0

T:game.disable_trade:0
T:game.disable_booth:0
S:game.enhance_fail_type:2
T:game.monster_pathfinding:1
T:game.monster_wandering:1
T:game.no_collision_check:0
T:game.no_skill_cooltime:0
N:game.item_hold_time:2500

S:game.server_screenshot_url:
S:game.helpdesk_url:
S:game.newbiehelp_asura_url:
S:game.newbiehelp_deva_url:
S:game.newbiehelp_gaia_url:
S:game.local_setting_list:log.ip|log.chat.ip|io.au th.ip|io.ip_address|db.c.server|db.user.server|N game.periodical_npc_adjustment
S:game.mem_usage_info_save_interval:9999999

S game.exp_rate:3
S game.item_drop_rate:3
S game.gold_drop_rate:10000
S game.chaos_drop_rate:5
F:game.base_ethereal_durability_consumption_on_dam age:.30
F:game.base_ethereal_durability_consumption_on_ski ll_attack:.40
F:game.base_ethereal_durability_consumption_on_nor mal_attack:.10
F:game.pvp_damage_rate_for_summon:.12
F:game.pvp_damage_rate_for_player:.08
T game.apply_stamina_bonus_in_premium_pcb:0
F game.premium_pcbang_bonus_rate:.30
F game.premium_pcbang_chaos_bonus_rate:.30
F game.premium_pcbang_gold_bonus_drop_rate:.30
F game.premium_pcbang_item_bonus_drop_rate:.30
F game.premium_pcbang_chaos_bonus_drop_rate:.30
F game.ally_pcbang_bonus_rate:.30
S game.ally_pcbang_chaos_bonus_rate:.30

if anyone can help me with this because me :

[king1king]

Originally Posted by nimoht

you can manually edit the npc you want on your db and make new rdb with this tool by Glandu2 :

thank you man

I am Arabian and the program will be difficult to deal with it

I hope that is the explanation video in the future

Originally Posted by thndr

@ king1king

You can not add an NPC in 9.1 with one of the old tools, because there are a couple columns removed from the tables for available time and other columns for temporary or event NPCs.

You can still add the NPC just add them manually or with a specifically tailored SQL script to add them that does not contain the temp event NPC time columns.

As far as the item price make sure you have filled it in in the correct column in its market resource entry.

If it does not change you may need to create a new market resource RDB file for the client.

8958	103513	28958	1	4	159	3	0	2	8958	1.00	1.00	14.00	40	150	260	120	1	5	0.40	5	0	1	101	3	1	0	5	-18	24	-0.30	-0.06	14.86	beast_camel	103251	0	0	0	0	0	0	0	0	0	0	0	0	2	0
8959	103514	28959	1	4	159	4	0	2	8959	1.00	1.00	14.00	40	150	260	120	1	5	0.40	5	0	1	101	3	1	0	5	-18	24	-0.30	-0.06	14.86	beast_whitecamel	103252	0	0	0	0	0	0	0	0	0	0	0	0	2	0

I didn't see any sheep maybe they are not 9.1 but there were a few test creatures for riding...

60	60	20060	1	7	4	0	0	0	60	2.40	1.00	12.00	40	150	80	200	1	2	0.20	1	1	1	106	0	1	0	3	-25	25	-0.30	-0.06	14.86	creaturetest01	60	0	icon_creature_creaturetest01	540111	0	game_image_card_creaturetest01	3002601	0	0	0	0	0	0	-1	0
61	61	20061	1	3	4	0	0	0	61	2.40	1.00	12.00	40	150	80	200	1	2	0.20	1	1	1	106	0	1	0	3	-25	25	-0.30	-0.06	14.86	creaturetest02	61	0	icon_creature_creaturetest02	540112	0	game_image_card_creaturetest02	3002601	0	0	0	0	0	0	-1	0
62	62	20062	1	4	4	0	0	0	62	2.40	1.00	12.00	40	150	80	200	1	2	0.20	1	1	1	106	0	1	0	3	-25	25	-0.30	-0.06	14.86	creaturetest03	62	0	icon_creature_creaturetest03	540113	0	game_image_card_creaturetest03	3002601	0	0	0	0	0	0	-1	0
63	63	20063	1	4	4	0	0	0	63	2.40	1.00	12.00	40	150	80	200	1	2	0.20	1	1	1	106	0	1	0	3	-25	25	-0.30	-0.06	14.86	creaturetest04	63	0	icon_creature_creaturetest04	540114	0	game_image_card_creaturetest04	3002601	0	0	0	0	0	0	-1	0
64	64	20064	1	4	4	0	0	0	64	2.40	1.00	12.00	40	150	80	200	1	2	0.20	1	1	1	106	0	1	0	3	-25	25	-0.30	-0.06	14.86	creaturetest05	64	0	icon_creature_creaturetest05	540115	0	game_image_card_creaturetest05	3002601	0	0	0	0	0	0	-1	0
65	65	20065	1	4	4	0	0	0	65	2.40	1.00	12.00	40	150	80	200	1	2	0.20	1	1	1	106	0	1	0	3	-25	25	-0.30	-0.06	14.86	creaturetest06	65	0	icon_creature_creaturetest06	540116	0	game_image_card_creaturetest06	3002601	0	0	0	0	0	0	-1	0

You could learn to look through your database tables.

thank you

[Kuchen31]

When i want to edit the top 200 rows of a table the following error apperas(picture)

It basicly says that i wantedt to read/write in protected memory/storage
That is frequently an indicator for a damaged memory/storage.


And i have an other problem once i skill any skill in the masterclass tree the gameserver crashes.

[nimoht]

i don't know why this error but go on sql server /Tools/option /sql server object explorator and put 0 for update and for select .
when you modify an row you need to click an other row to validate the modification of your row and after clic execute button .

[sergeu1988]

thank you.
Several of these issues:
1.I made a request to the experience obtained from the quest by accident as follows:

 Spoiler

UPDATE [Arcadia].[dbo].[QuestResource]
SET exp = exp *150
go

players quickly take him level. How to return back to normal everything was?
2. How to make the removal of the fine in the guild menu from a dealer?
3. Points are not issued talent from the merchants. here's the script:

 Spoiler

dlg_menu( "ОТ", "OT()" )

[SPOILERfunction OT()
sv("tp", 9)
return
dlg_show()
end][/SPOILER]

[ThunderNikk]

1. Easy do the opposite math...

UPDATE [Arcadia].[dbo].[QuestResource]
SET exp = exp / 150
go

2. Not sure what you are asking for.

3. Needs someone more familiar with the commands.

[nimoht]

Hy thndr have you got an idea for these :

 Spoiler

Hy all
First problem :
i search full help web site source in English or French because this don't work :

 Spoiler

S:game.helpdesk_url:
S:game.newbiehelp_asura_url:
S:game.newbiehelp_deva_url:
S:game.newbiehelp_gaia_url:

I don't know how to get it by official .
If anyone have it and can release it , thank's a lot

Second problem :
I need to can connect to my server by external and local network :
i have 3 pc on my local network ( one with the server and client and two with just the client ) and betwin five at ten pc on external network ( not the same local network for them ) , these are friends .
I don't want to use Hamashi , i have an great network connection by my network dealer .
if i make this : 192.168.1.150 = local pc adress with rooter nat rules and all needed ports open 15574 4500)
S:io.port:15574
S:io.auth.ip:192.168.1.150
S:io.ip_address:192.168.1.150
and put my external rooter ip on launchers of my friends , it can't connect ;
me and my local pc's with 192.168.1.150 on the launcher can connect .
if i change S:io.auth.ip:external rooter adress game server can't connect to auth .
if i make this :
S:io.port:15574
S:io.auth.ip:192.168.1.150
S:io.ip_address:external rooter adress
nobody can connect .
for all settings i tested if game server connect to auth the result in game server console is :
Connect to Auth... ok
Adding auth connection to IOCP... ok
Acceptor initialize... ok(IP: 0.0.0.0, Port: 15574)
Adding acceptor to IOCP... ok

auth.opt :

 Spoiler

auth.db.server:127.0.0.1
auth.db.port:1433
auth.db.name:Auth
auth.db.account:my auth account
auth.db.password:my password
auth.db.salt:2011

auth.clients.ip:192.168.1.150
auth.clients.port:58422
auth.clients.des_key:MERONG
auth.clients.maxpublicserveridx:10

auth.gameserver.ip:192.168.1.150
auth.gameserver.port:4502

upload.dir=upload
upload.gameserver.ip:192.168.1.150
upload.gameserver.port:4616

upload.clients.ip:192.168.1.150
upload.clients.port:4617

upload.iconserver.ip:192.168.1.150
upload.iconserver.port:5000

sql.db_account.column.serveridxoffset:server_list_ mask

core.log.level:trace
core.log.consolelevel:info

sql.db_account.query:SELECT * FROM Account WITH(NOLOCK) WHERE login_name = ? AND password = ?;

game.opt :

 Spoiler

S:app.name:Game001
T:auth.server_idx:1
S:auth.server_name:RappelzFamily

S:db.c.server:127.0.0.1
S:db.c.name:Arcadia
S:db.c.account:my arcadia account
S:db.c._password:my arcadia pass
S:db.user.server:127.0.0.1
S:db.user.name:Telecaster
S:db.user.account:my telecaster account
S:db.user._password:my telecaster pass
T:db.user.thread:4

S:io.upload.ip:192.168.1.150
S:io.upload.port:4616
S:game.guild_icon_base_url:192.168.1.150:5000/upload/
S:game.url_list:guild_icon_upload.ip|192.168.1.150 |guild_icon_upload.port|4617|guild_test_download.u rl|upload/|web_download|192.168.1.150:5000|shop.url|

N:console.port:44554
S:console.allow_ip:127.0.0.1
S:console._password:

S:log.chat.ip:127.0.0.1
S:log.ip:127.0.0.1
T:log.chat.working:0
T:log.working:0
T:log.disable:1

S:io.port:15574
S:io.auth.ip:192.168.1.150
S:io.ip_address:192.168.1.150

T:game.update.version:24
T:game.max_level:180
T:game.PKServer:1
T:game.AdultServer:0
T:game.cash_usable_server:1
S:game.local_flag:128
T:game.min_global_chat_usable_level:1
T:game.use_auto_trap:0
T:game.use_auto_jail:0
T:game.ServiceServer:0

T:game.disable_trade:0
T:game.disable_booth:0
S:game.enhance_fail_type:2
T:game.monster_pathfinding:1
T:game.monster_wandering:1
T:game.no_collision_check:0
T:game.no_skill_cooltime:0
N:game.item_hold_time:2500

S:game.server_screenshot_url:
S:game.helpdesk_url:
S:game.newbiehelp_asura_url:
S:game.newbiehelp_deva_url:
S:game.newbiehelp_gaia_url:
S:game.local_setting_list:log.ip|log.chat.ip|io.au th.ip|io.ip_address|db.c.server|db.user.server|N game.periodical_npc_adjustment
S:game.mem_usage_info_save_interval:9999999

S game.exp_rate:3
S game.item_drop_rate:3
S game.gold_drop_rate:10000
S game.chaos_drop_rate:5
F:game.base_ethereal_durability_consumption_on_dam age:.30
F:game.base_ethereal_durability_consumption_on_ski ll_attack:.40
F:game.base_ethereal_durability_consumption_on_nor mal_attack:.10
F:game.pvp_damage_rate_for_summon:.12
F:game.pvp_damage_rate_for_player:.08
T game.apply_stamina_bonus_in_premium_pcb:0
F game.premium_pcbang_bonus_rate:.30
F game.premium_pcbang_chaos_bonus_rate:.30
F game.premium_pcbang_gold_bonus_drop_rate:.30
F game.premium_pcbang_item_bonus_drop_rate:.30
F game.premium_pcbang_chaos_bonus_drop_rate:.30
F game.ally_pcbang_bonus_rate:.30
S game.ally_pcbang_chaos_bonus_rate:.30

if anyone can help me with this because me :

thanks

[king1king]

how i can add new pet in my server ?

the file with me but i cant add him ~~

help >> vedio

sorry for bad english

[sergeu1988]

Do not drop unique maps 9.1, how to make them fall?

[Juice_ifer]

Hi, I have problem launching the game Rappelz zesua. When I launch the game, it gives me and error with the following message: The remote sever returned an error403) Forbidden. So I was wondering what have gone wrong. I have have download all the 3 separate folders and also 1 whole folder and both came out the same result. So can some one guide me through this so I can start playing the game. Thanks in advance.

[Sherock]

is it possible to change SFrame language?

[ThunderNikk]

Originally Posted by Sherock

is it possible to change SFrame language?

I think you need to be a little more specific because sframe does not have a language per-se.

[nimoht]

update of my problem , more info :

 Spoiler

Hy all
First problem :
i search full help web site source in English or French because this don't work :

 Spoiler

S:game.helpdesk_url:
S:game.newbiehelp_asura_url:
S:game.newbiehelp_deva_url:
S:game.newbiehelp_gaia_url:

I don't know how to get it by official .
If anyone have it and can release it , thank's a lot

Second problem :
I need to can connect to my server by external and local network :
i have 3 pc on my local network ( one with the server and client and two with just the client ) and betwin five at ten pc on external network ( not the same local network for them ) , these are friends .
I don't want to use Hamashi , i have an great network connection by my network dealer .

if i make this :

192.168.1.150 = local pc static ip adress

auth:58422 game:15574 needed:4500 upload:5000 = ports open on Windows firewall for * ip in and out

auth:58422 game:15574 needed:4500 upload:5000 = rooter nat rules to 192.168.1.150

S:io.port:15574
S:io.auth.ip:192.168.1.150
S:io.ip_address:192.168.1.150

put my external rooter ip on launchers of my friends , they connect to auth but can't choose server on the list,
me and my local pc's with 192.168.1.150 on the launcher can connect and play

if i change S:io.auth.ip:external rooter adress , game server can't connect to auth .

if i make this :

S:io.port:15574
S:io.auth.ip:192.168.1.150
S:io.ip_address:external rooter adress

local network with 192.168.1.150 on launcher connect to auth can't connect to game ,
local network with external ip of rooter on launcher can't connect auth & game ,
external network with external rooter ip on launcher connect and play

for all settings i tested if game server connect to auth the result in game server console is :

Connect to Auth... ok
Adding auth connection to IOCP... ok
Acceptor initialize... ok(IP: 0.0.0.0, Port: 15574)
Adding acceptor to IOCP... ok

auth.opt :

 Spoiler

auth.db.server:127.0.0.1
auth.db.port:1433
auth.db.name:Auth
auth.db.account:my auth account
auth.db.password:my password
auth.db.salt:2011

auth.clients.ip:192.168.1.150
auth.clients.port:58422
auth.clients.des_key:MERONG
auth.clients.maxpublicserveridx:10

auth.gameserver.ip:192.168.1.150
auth.gameserver.port:4502

upload.dir=upload
upload.gameserver.ip:192.168.1.150
upload.gameserver.port:4616

upload.clients.ip:192.168.1.150
upload.clients.port:4617

upload.iconserver.ip:192.168.1.150
upload.iconserver.port:5000

sql.db_account.column.serveridxoffset:server_list_ mask

core.log.level:trace
core.log.consolelevel:info

sql.db_account.query:SELECT * FROM Account WITH(NOLOCK) WHERE login_name = ? AND password = ?;

game.opt :

 Spoiler

S:app.name:Game001
T:auth.server_idx:1
S:auth.server_name:RappelzFamily

S:db.c.server:127.0.0.1
S:db.c.name:Arcadia
S:db.c.account:my arcadia account
S:db.c._password:my arcadia pass
S:db.user.server:127.0.0.1
S:db.user.name:Telecaster
S:db.user.account:my telecaster account
S:db.user._password:my telecaster pass
T:db.user.thread:4

S:io.upload.ip:192.168.1.150
S:io.upload.port:4616
S:game.guild_icon_base_url:192.168.1.150:5000/upload/
S:game.url_list:guild_icon_upload.ip|192.168.1.150 |guild_icon_upload.port|4617|guild_test_download.u rl|upload/|web_download|192.168.1.150:5000|shop.url|

N:console.port:44554
S:console.allow_ip:127.0.0.1
S:console._password:

S:log.chat.ip:127.0.0.1
S:log.ip:127.0.0.1
T:log.chat.working:0
T:log.working:0
T:log.disable:1

S:io.port:15574
S:io.auth.ip:192.168.1.150
S:io.ip_address:192.168.1.150

T:game.update.version:24
T:game.max_level:180
T:game.PKServer:1
T:game.AdultServer:0
T:game.cash_usable_server:1
S:game.local_flag:128
T:game.min_global_chat_usable_level:1
T:game.use_auto_trap:0
T:game.use_auto_jail:0
T:game.ServiceServer:0

T:game.disable_trade:0
T:game.disable_booth:0
S:game.enhance_fail_type:2
T:game.monster_pathfinding:1
T:game.monster_wandering:1
T:game.no_collision_check:0
T:game.no_skill_cooltime:0
N:game.item_hold_time:2500

S:game.server_screenshot_url:
S:game.helpdesk_url:
S:game.newbiehelp_asura_url:
S:game.newbiehelp_deva_url:
S:game.newbiehelp_gaia_url:
S:game.local_setting_list:log.ip|log.chat.ip|io.au th.ip|io.ip_address|db.c.server|db.user.server|N game.periodical_npc_adjustment
S:game.mem_usage_info_save_interval:9999999

S game.exp_rate:3
S game.item_drop_rate:3
S game.gold_drop_rate:10000
S game.chaos_drop_rate:5
F:game.base_ethereal_durability_consumption_on_dam age:.30
F:game.base_ethereal_durability_consumption_on_ski ll_attack:.40
F:game.base_ethereal_durability_consumption_on_nor mal_attack:.10
F:game.pvp_damage_rate_for_summon:.12
F:game.pvp_damage_rate_for_player:.08
T game.apply_stamina_bonus_in_premium_pcb:0
F game.premium_pcbang_bonus_rate:.30
F game.premium_pcbang_chaos_bonus_rate:.30
F game.premium_pcbang_gold_bonus_drop_rate:.30
F game.premium_pcbang_item_bonus_drop_rate:.30
F game.premium_pcbang_chaos_bonus_drop_rate:.30
F game.ally_pcbang_bonus_rate:.30
S game.ally_pcbang_chaos_bonus_rate:.30

if anyone can help me with this because me :
thanks
i'm sure the problem for game access is the ip on the launcher need to are the same at this in game.opt s:io.ip_adress . is it possible to have more of 1 s:io.ip_adress on game.opt or more of 1 ip adress on this row ???
PS: my rooter don't support loopback ... (Orange for french guys ;-) )

[ismokedrow]

Originally Posted by Sherock

is it possible to change SFrame language?

Since the "mod" didn't find my picard meme 'necessary' let me rephrase.

As has been said 10000000^ times, the SFRAME.exe is LANGUAGE NEUTRAL meaning it itself has no inherent language. All text displayed inside of the SFRAME.exe during operation is loaded from one of two files db_string(ascii).rdb / db_string.rdb. The SFRAME.exe is then told which file to load from via the start arguments.

For example:

/Locale:

-- When set to ASCII all strings are read from db_string(ascii).rdb else all strings are read from db_string.rdb

/Country:

-- This is more determining country based options such as Announcement configuration and font. [Pretty sure it links directly to localeinfo.ini where settings are stated as [RAPPELZ_US] / [RAPPELZ_EU] etc..

[Kuchen31]

i have a quesiton refering to the string resource.
When i export the string resource using the RappelzRDBToolQt.exe tool
all these new characters like the dungeon teleporter or the guys before the circus have empty string as name and when i delete the string resource everything works just fine. But i wanna add string resources for new npcs , monsters ,items etc. . does this error appear because this tool does only support 8.1 string resources and the coloumns changed or because of something else? And if the tool is the problem is there an other tool that can fix that and also cover the 9.1 string resources?