[Help Thread] Please post your questions here.

[ThunderNikk]

Originally Posted by mlejnek2

both Game server Opts

You are running more than one server on the same host?

What are the host specs?

I just ran through on my server but I am one player playing it.

I only lagged once which was just right before I was about to try to tame Soul Seeker.

No lags taming DF Takin or AN not even running to get to all of those places.

Only tested PP1 though have not run PP2 yet.

[mlejnek2]

we run 3 server at a time but. Intel 2 Quadcore 3.1 ghz 6gb ddr3, quad chan. 1tb cgate 7200 rpm HD cpu 12mb chac. 1 gb Fiberwire connection 15 players on mix of the 3 servers, and we only lag when players go through PP1 andd or 2 and they hit a area that is blocked but its only in the narrow areas in there that we get the lag from

when no one is in the 2 PP dung's we never get lag

its like the collision seems to be causing PP1 and PP2 to be crappy cause of how narrow they are

and and CPU never go over 20%

network sits under 1% at all times

and only 2 servers are 9.1

[ThunderNikk]

Whats the 6 GB memory usage hitting when they run through the narrow areas of PP?

[mlejnek2]

it stays about 20-45 % total usage no matter what only servers lag there are no spikes in the Ram or the Cpu thats whats so odd about it and we use the Auth EMU

[ThunderNikk]

Yeah I am pretty sure it has little to do with the auth emulator verses the retail auth, and more to do with the game server or client.

Yet I am not sure what yet.

On the narrow spots in PP when it lags are they near the edge, or black border of PP, that could be next to something else on the broader Rappelz maps.

[noobeee]

guys i am sorry but i have been searching every where.

I cant find a solution to two things...

How can i change teh tame rates of the diff tiers of pets via SQL?

and everytime i log out i keep losing my skills on my bar and items. How can i fix this?

[ThunderNikk]

As far as changing the tame rates by tier.

You can write an SQL statement to change globally a taming rate tier.

Example SQL to change taming rate of wolves and all other tier 2 pets...

update Arcadia.dbo.MonsterResource set taming_percentage = 0.5000 where taming_percentage = 0.2500

That will change all tier 2 pets from 25% to 50% as 1.0000 = 100%

At least I think those are the numbers. So just peruse the table for the tier of pet you want to change and follow the example.

As far as you skill bars if you are running the 9.1 files you need to perform the billing fixes explained in the guide in order to fix it.

[noobeee]

Originally Posted by thndr

As far as you skill bars if you are running the 9.1 files you need to perform the billing fixes explained in the guide in order to fix it.

hey mate,

thank you for this,

i did run the fixes, but got the following errors on:

smp_update_takeout_info.sql



and on

add_paiditem_to_91.sql

[nintynice]

got a question regarding levels.

Is there a specific command to set a player to a certain level or do I just have to alter the exp in the character table via a small script? (for example level 150 is X.***.***.*** exp so I alter the exp of the character to that value)

[TheRainy]

Hey, i do have a little Problem...

I try'd to make an Launcher for my 9.1 Server in C++ but somehow my Sframe sends me this Error: Page 4(0xf0, 6)

Here's the Code of my Launcher:

 Spoiler

//Start the Game
private void strtGameBtn_Click(object sender, EventArgs e)
{
Process.Start("SFrame.exe", "/auth_ip: ***** /auth_port:***** /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");
this.Close();
}

But somehow it wont launch the Game... could anyone help me out pls?

[ThunderNikk]

Pretty sure that error is caused by not running the RappelzCMDLauncher.exe in your process start arguments.

I have mine at home I could post later.

[glandu2]

indeed SFrame shows "Error: Page 4(0xf0, 6)" when it can't validate the launcher

[SeevanXT]

I have a Problem to Warp by a NPC to Underground & Circus Instance.
When i Click on anny Stage to can Warp in the right Instance i get at System Chat this Script error " SCRIPT_WarpToInstanceDungeon() : invalid name "
and i use this at a NPC to Warp in.

 Spoiler

Moonlight
dlg_menu("@690000090", "warp_to_instance_dungeon(40000, 0)")
dlg_menu("@690000091", "warp_to_instance_dungeon(40000, 1)")
dlg_menu("@690000092", "warp_to_instance_dungeon(40000, 2)")
dlg_menu("@690000093", "warp_to_instance_dungeon(40000, 3)")

Red spider Circus
dlg_menu("@690000141", "warp_to_instance_dungeon(50000,0)")
dlg_menu("@690000142", "warp_to_instance_dungeon(50000,1)")
dlg_menu("@690000143", "warp_to_instance_dungeon(50000,2)")
dlg_menu("@690000144", "warp_to_instance_dungeon(50000,3)")

annyone know how i can fix it?

[ThunderNikk]

IDK but what are the @ symbols for?

And isn't that just the menu choices for the NPC that is not the all inclusive script that probably has the name error. Like the actual script functions or are they one in the same?

[SeevanXT]

Originally Posted by thndr

IDK but what are the @ symbols for?

And isn't that just the menu choices for the NPC that is not the all inclusive script that probably has the name error. Like the actual script functions or are they one in the same?

the @ are only menu text have nothing to do with error

i think this is my Problem in InstanceDungeonTypeResource are at Underground Instance are only on_create_script = set_instance_dungeon_flag( 40000, #@layer@#, 'check_open_prop', 2)

but in ECT_dungeon_prop are only check_open_prop', 1 and 0

ETC_dungeon_prop.lua

 Spoiler

function Call_Main_Chest( monster_handle )

local monster_id = get_monster_id( monster_handle )
local layer = ghv( monster_handle, 'layer' )

local quest_progress3644 = get_quest_progress(3644) -- [One days] Subjugation: Medusa hunting
local quest_progress3645 = get_quest_progress(3645) -- [One days] Subjugation: Black Widow hunting
local quest_progress3646 = get_quest_progress(3646) -- [One days] Subjugation: The dragon hunt
local quest_progress3647 = get_quest_progress(3647) -- [One days] Dungeon Subjugation: Microraptor hunting
-- Returns -1: Or Nothing / 0: surakga / 1: Performing / 2: Exit Enable / 100: Fail / 255: already terminated


if monster_id == 20190001 or monster_id == 20190006 --Medeon underground bases Step 1
or monster_id == 20190028 or monster_id == 20190033 --Medeon underground bases Step 2
or monster_id == 20190055 or monster_id == 20190060 --Medeon underground bases Step 3
or monster_id == 20190082 or monster_id == 20190087 then --Medeon underground bases Step 4

local monster_count = get_instance_dungeon_flag( 40000, layer, 'check_open_prop')
if monster_count == 2 then
set_instance_dungeon_flag( 40000, layer, 'check_open_prop', 1)
elseif monster_count == 1 then
add_field_prop ( 60170, 60000, 38719, 22938, layer )
set_instance_dungeon_flag( 40000, layer, 'check_open_prop', 0)
end

if quest_progress3644 == 1 and monster_id == 20190001 then
if get_quest_status( 3644 , 1 ) == 0 then
local A_day_A_quest = get_quest_status( 3644 , 1 ) + 1
set_quest_status( 3644, 1, A_day_A_quest )
end
elseif quest_progress3644 == 1 and monster_id == 20190028 then
if get_quest_status( 3644 , 1 ) == 0 then
local A_day_A_quest = get_quest_status( 3644 , 1 ) + 1
set_quest_status( 3644, 1, A_day_A_quest )
end
elseif quest_progress3644 == 1 and monster_id == 20190055 then
if get_quest_status( 3644 , 1 ) == 0 then
local A_day_A_quest = get_quest_status( 3644 , 1 ) + 1
set_quest_status( 3644, 1, A_day_A_quest )
end
elseif quest_progress3644 == 1 and monster_id == 20190082 then
if get_quest_status( 3644 , 1 ) == 0 then
local A_day_A_quest = get_quest_status( 3644 , 1 ) + 1
set_quest_status( 3644, 1, A_day_A_quest )
end
elseif quest_progress3644 == 1 and monster_id == 20190006 then
if get_quest_status( 3644 , 2 ) == 0 then
local A_day_A_quest = get_quest_status( 3644 , 2 ) + 1
set_quest_status( 3644, 2, A_day_A_quest )
end
elseif quest_progress3644 == 1 and monster_id == 20190033 then
if get_quest_status( 3644 , 2 ) == 0 then
local A_day_A_quest = get_quest_status( 3644 , 2 ) + 1
set_quest_status( 3644, 2, A_day_A_quest )
end
elseif quest_progress3644 == 1 and monster_id == 20190060 then
if get_quest_status( 3644 , 2 ) == 0 then
local A_day_A_quest = get_quest_status( 3644 , 2 ) + 1
set_quest_status( 3644, 2, A_day_A_quest )
end
elseif quest_progress3644 == 1 and monster_id == 20190087 then
if get_quest_status( 3644 , 2 ) == 0 then
local A_day_A_quest = get_quest_status( 3644 , 2 ) + 1
set_quest_status( 3644, 2, A_day_A_quest )
end
end

elseif monster_id == 20190025 or monster_id == 20190008 --Underground coal mine bases Step 1
or monster_id == 20190052 or monster_id == 20190035 --Underground coal mine bases Step 2
or monster_id == 20190079 or monster_id == 20190062 --Underground coal mine bases Step 3
or monster_id == 21190106 or monster_id == 20190089 then --Underground coal mine bases Step 4

local monster_count = get_instance_dungeon_flag( 41001, layer, 'check_open_prop')
if monster_count == 2 then
set_instance_dungeon_flag( 41001, layer, 'check_open_prop', 1)
elseif monster_count == 1 then
add_field_prop ( 60171, 60000, 40379, 9573, layer )
set_instance_dungeon_flag( 41001, layer, 'check_open_prop', 0)
end

if quest_progress3645 == 1 and monster_id == 20190025 then
if get_quest_status( 3645 , 1 ) == 0 then
local A_day_A_quest = get_quest_status( 3645 , 1 ) + 1
set_quest_status( 3645, 1, A_day_A_quest )
end
elseif quest_progress3645 == 1 and monster_id == 20190052 then
if get_quest_status( 3645 , 1 ) == 0 then
local A_day_A_quest = get_quest_status( 3645 , 1 ) + 1
set_quest_status( 3645, 1, A_day_A_quest )
end
elseif quest_progress3645 == 1 and monster_id == 20190079 then
if get_quest_status( 3645 , 1 ) == 0 then
local A_day_A_quest = get_quest_status( 3645 , 1 ) + 1
set_quest_status( 3645, 1, A_day_A_quest )
end
elseif quest_progress3645 == 1 and monster_id == 21190106 then
if get_quest_status( 3645 , 1 ) == 0 then
local A_day_A_quest = get_quest_status( 3645 , 1 ) + 1
set_quest_status( 3645, 1, A_day_A_quest )
end
elseif quest_progress3645 == 1 and monster_id == 20190008 then
if get_quest_status( 3645 , 2 ) == 0 then
local A_day_A_quest = get_quest_status( 3645 , 2 ) + 1
set_quest_status( 3645, 2, A_day_A_quest )
end
elseif quest_progress3645 == 1 and monster_id == 20190035 then
if get_quest_status( 3645 , 2 ) == 0 then
local A_day_A_quest = get_quest_status( 3645 , 2 ) + 1
set_quest_status( 3645, 2, A_day_A_quest )
end
elseif quest_progress3645 == 1 and monster_id == 20190062 then
if get_quest_status( 3645 , 2 ) == 0 then
local A_day_A_quest = get_quest_status( 3645 , 2 ) + 1
set_quest_status( 3645, 2, A_day_A_quest )
end
elseif quest_progress3645 == 1 and monster_id == 20190089 then
if get_quest_status( 3645 , 2 ) == 0 then
local A_day_A_quest = get_quest_status( 3645 , 2 ) + 1
set_quest_status( 3645, 2, A_day_A_quest )
end
end

elseif monster_id == 20190026 or monster_id == 20190012
or monster_id == 20190053 or monster_id == 20190039
or monster_id == 20190080 or monster_id == 20190066
or monster_id == 21190107 or monster_id == 20190093 then

local monster_count = get_instance_dungeon_flag( 42001, layer, 'check_open_prop')
if monster_count == 2 then
set_instance_dungeon_flag( 42001, layer, 'check_open_prop', 1)
elseif monster_count == 1 then
add_field_prop ( 60172, 60000, 61784, 31019, layer )
set_instance_dungeon_flag( 42001, layer, 'check_open_prop', 0)
end

if quest_progress3646 == 1 and monster_id == 20190026 then
if get_quest_status( 3646 , 1 ) == 0 then
local A_day_A_quest = get_quest_status( 3646 , 1 ) + 1
set_quest_status( 3646, 1, A_day_A_quest )
end
elseif quest_progress3646 == 1 and monster_id == 20190053 then
if get_quest_status( 3646 , 1 ) == 0 then
local A_day_A_quest = get_quest_status( 3646 , 1 ) + 1
set_quest_status( 3646, 1, A_day_A_quest )
end
elseif quest_progress3646 == 1 and monster_id == 20190080 then
if get_quest_status( 3646 , 1 ) == 0 then
local A_day_A_quest = get_quest_status( 3646 , 1 ) + 1
set_quest_status( 3646, 1, A_day_A_quest )
end
elseif quest_progress3646 == 1 and monster_id == 21190107 then
if get_quest_status( 3646 , 1 ) == 0 then
local A_day_A_quest = get_quest_status( 3646 , 1 ) + 1
set_quest_status( 3646, 1, A_day_A_quest )
end
elseif quest_progress3646 == 1 and monster_id == 20190012 then
if get_quest_status( 3646 , 2 ) == 0 then
local A_day_A_quest = get_quest_status( 3646 , 2 ) + 1
set_quest_status( 3646, 2, A_day_A_quest )
end
elseif quest_progress3646 == 1 and monster_id == 20190039 then
if get_quest_status( 3646 , 2 ) == 0 then
local A_day_A_quest = get_quest_status( 3646 , 2 ) + 1
set_quest_status( 3646, 2, A_day_A_quest )
end
elseif quest_progress3646 == 1 and monster_id == 20190066 then
if get_quest_status( 3646 , 2 ) == 0 then
local A_day_A_quest = get_quest_status( 3646 , 2 ) + 1
set_quest_status( 3646, 2, A_day_A_quest )
end
elseif quest_progress3646 == 1 and monster_id == 20190093 then
if get_quest_status( 3646 , 2 ) == 0 then
local A_day_A_quest = get_quest_status( 3646 , 2 ) + 1
set_quest_status( 3646, 2, A_day_A_quest )
end
end

elseif monster_id == 20190027 or monster_id == 20190010
or monster_id == 20190054 or monster_id == 20190037
or monster_id == 20190081 or monster_id == 20190064
or monster_id == 21190108 or monster_id == 20190091 then

local monster_count = get_instance_dungeon_flag( 43001, layer, 'check_open_prop')
if monster_count == 2 then
set_instance_dungeon_flag( 43001, layer, 'check_open_prop', 1)
elseif monster_count == 1 then
add_field_prop ( 60173, 60000, 53659, 4147, layer )
set_instance_dungeon_flag( 43001, layer, 'check_open_prop', 0)
end

if quest_progress3647 == 1 and monster_id == 20190027 then
if get_quest_status( 3647 , 1 ) == 0 then
local A_day_A_quest = get_quest_status( 3647 , 1 ) + 1
set_quest_status( 3647, 1, A_day_A_quest )
end
elseif quest_progress3647 == 1 and monster_id == 20190054 then
if get_quest_status( 3647 , 1 ) == 0 then
local A_day_A_quest = get_quest_status( 3647 , 1 ) + 1
set_quest_status( 3647, 1, A_day_A_quest )
end
elseif quest_progress3647 == 1 and monster_id == 20190081 then
if get_quest_status( 3647 , 1 ) == 0 then
local A_day_A_quest = get_quest_status( 3647 , 1 ) + 1
set_quest_status( 3647, 1, A_day_A_quest )
end
elseif quest_progress3647 == 1 and monster_id == 21190108 then
if get_quest_status( 3647 , 1 ) == 0 then
local A_day_A_quest = get_quest_status( 3647 , 1 ) + 1
set_quest_status( 3647, 1, A_day_A_quest )
end
elseif quest_progress3647 == 1 and monster_id == 20190010 then
if get_quest_status( 3647 , 2 ) == 0 then
local A_day_A_quest = get_quest_status( 3647 , 2 ) + 1
set_quest_status( 3647, 2, A_day_A_quest )
end
elseif quest_progress3647 == 1 and monster_id == 20190037 then
if get_quest_status( 3647 , 2 ) == 0 then
local A_day_A_quest = get_quest_status( 3647 , 2 ) + 1
set_quest_status( 3647, 2, A_day_A_quest )
end
elseif quest_progress3647 == 1 and monster_id == 20190064 then
if get_quest_status( 3647 , 2 ) == 0 then
local A_day_A_quest = get_quest_status( 3647 , 2 ) + 1
set_quest_status( 3647, 2, A_day_A_quest )
end
elseif quest_progress3647 == 1 and monster_id == 20190091 then
if get_quest_status( 3647 , 2 ) == 0 then
local A_day_A_quest = get_quest_status( 3647 , 2 ) + 1
set_quest_status( 3647, 2, A_day_A_quest )
end
end

end

end

NPC_Dungeon.lua

 Spoiler

--================================================== ==========
-- <<<<<< 4 Entrance for the underground base indeon NPC >>>>>>
--================================================== ==========

function NPC_Teleport_instanceDuneGeon_contact()

local npc_id = get_npc_id()
local level = get_value( 'level' )

if level < 160 then

if npc_id == 11812 then
dlg_title( "@90605758" ) --Wachposten Jack
dlg_text( "@90605763" )

elseif npc_id == 11813 then
dlg_title( "@90605759" ) --Wachposten Kate
dlg_text( "@90605763" )

elseif npc_id == 11814 then
dlg_title( "@90605760" ) --Wachposten Side
dlg_text( "@90605763" )
elseif npc_id == 11815 then
dlg_title( "@90605761" ) --Wachposten Jinsu
dlg_text( "@90605763" )
elseif npc_id == 13000 then
dlg_title( "@90606149" ) --Stoßtrupp Pie
dlg_text( "@90605763" )
end


elseif level >= 160 then --Untergrund & Zirkus Stufen NPC

if npc_id == 11812 then --Wachposten Jack
dlg_title( "@90605758" )
dlg_text( "@90605762" )
dlg_menu("@690000090", "warp_to_instance_dungeon(40000, 0)") --Mondlicht Stufe 1
dlg_menu("@690000091", "warp_to_instance_dungeon(40000, 1)") --Mondlicht Stufe 2
dlg_menu("@690000092", "warp_to_instance_dungeon(40000, 2)") --Mondlicht Stufe 3
dlg_menu("@690000093", "warp_to_instance_dungeon(40000, 3)") --Mondlicht Stufe 4

elseif npc_id == 11813 then --Wachposten Kate
dlg_title( "@90605759" )
dlg_text( "@90605762" )
dlg_menu("@690000090", "warp_to_instance_dungeon(41001, 0)") --More from coal 1단계 입장
dlg_menu("@690000091", "warp_to_instance_dungeon(41001, 1)") --More from coal 2단계 입장
dlg_menu("@690000092", "warp_to_instance_dungeon(41001, 2)") --More from coal 3단계 입장
dlg_menu("@690000093", "warp_to_instance_dungeon(41001, 3)") --More from coal 4단계 입장


elseif npc_id == 11814 then --Wachposten Side
dlg_title( "@90605760" )
dlg_text( "@90605762" )
dlg_menu("@690000090", "warp_to_instance_dungeon(42001, 0)") --Kristalltal 1
dlg_menu("@690000091", "warp_to_instance_dungeon(42001, 1)") --Kristalltal 2
dlg_menu("@690000092", "warp_to_instance_dungeon(42001, 2)") --Kristalltal 3
dlg_menu("@690000093", "warp_to_instance_dungeon(42001, 3)") --Kristalltal 4


elseif npc_id == 11815 then --Wachposten Jinsu
dlg_title( "@90605761" )
dlg_text( "@90605762" )
dlg_menu("@690000090", "warp_to_instance_dungeon(43001, 0)") --Palmir Plateau 1
dlg_menu("@690000091", "warp_to_instance_dungeon(43001, 1)") --Palmir Plateau 2
dlg_menu("@690000092", "warp_to_instance_dungeon(43001, 2)") --Palmir Plateau 3
dlg_menu("@690000093", "warp_to_instance_dungeon(43001, 3)") --Palmir Plateau 4

elseif npc_id == 13000 then --Circus position npc Stoßtrupp Pie
dlg_title( "@90606149" )
dlg_text( "@90606148" )
dlg_menu("@690000141", "warp_to_instance_dungeon(50000,0)") --Red spider Circus 1
dlg_menu("@690000142", "warp_to_instance_dungeon(50000,1)") --Red spider Circus 2
dlg_menu("@690000143", "warp_to_instance_dungeon(50000,2)") --Red spider Circus 3
dlg_menu("@690000144", "warp_to_instance_dungeon(50000,3)") --Red spider Circus 4

end

end

dlg_menu( "@90010002", " " )


dlg_show()

end