PK mode block

[stivenson2005]

Hi all ^^

I am wondering how to block the PK mode in Dungeons for example, like it is on Trainee island? is it possible, I know it is through dbo.WorldLocation, I just need a bit of help and guidance if possible.


Thanks

[Xijezu]

The value you are looking for is the location_type.

SELECT s.value, w.location_type FROM WorldLocation w LEFT JOIN StringResource s ON w.text_id = s.code

Trainee Island has location_type 3, towns usually 1.

BattleField = 5,
Dungeon = 4,
Etc = 0,
EventMap = 7,
Field = 2,
FleaMarket = 10,
HuntaholicDungeon = 9,
HuntaholicLobby = 8,
NonPkField = 3,
Town = 1
(Source: Rappelz Emu)

[stivenson2005]

Thanks Xijezu for your prompt response, it was a big help thanks a lot.

[Xijezu]

Originally Posted by stivenson2005

do you know what is trainee's island text_id is?

SELECT s.value, s.code, w.location_type FROM WorldLocation w LEFT JOIN StringResource s ON w.text_id = s.code WHERE s.[value] LIKE '%Trainee%'

Would be 70100300

[stivenson2005]

Yeah, thanks again it was a grey moment didn't think of I could look into every location_type 3 and find the text_id.

thanks again