PK mode block

03/10/2013 14:52 stivenson2005#1

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

03/10/2013 15:25 Xijezu#2

The value you are looking for is the location_type.

Code:

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)

03/10/2013 15:33 stivenson2005#3

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

03/10/2013 15:35 Xijezu#4

Quote:

Originally Posted by stivenson2005

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

Code:

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

03/10/2013 16:48 stivenson2005#5

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 :)