NPC problem

03/31/2013 15:54 H1tcher#1
What is ID of this NPC

[Only registered and activated users can see links. Click Here To Register...]

I search all day can'n find id to remove him!

Edit: I found it ! Close pls
03/31/2013 16:32 ThunderNikk#2
One of these...

NPC_Event_2011_xmas_event_rudolph_contact()
NPC_Event_2011_xmas_event_rudolph_contact()
NPC_Event_2011_xmas_event_rudolph_contact()
NPC_Event_2011_xmas_event_rudolph_contact()
NPC_Event_2011_xmas_event_rudolph_contact()
NPC_Event_2011_xmas_event_rudolph_contact()
NPC_Event_2011_xmas_event_claus_contact()
NPC_Event_2011_xmas_event_claus_contact()
NPC_Event_2011_xmas_event_claus_contact()
NPC_Event_2011_xmas_event_claus_contact()
NPC_Event_2011_xmas_event_claus_contact()
NPC_Event_2011_xmas_event_claus_contact()
NPC_Event_2011_xmas_event_claus_contact()

NPC_event_2012_Xmas_m()
NPC_event_2012_Xmas_m()
NPC_event_2012_Xmas_m()
NPC_event_2012_Xmas_m()
NPC_event_2012_Xmas_m()
NPC_event_2012_Xmas_f_1()
NPC_event_2012_Xmas_f_2()
NPC_event_2012_Xmas_f_3()
NPC_event_2012_Xmas_f_4()
NPC_event_2012_Xmas_f_5()

IDs

11702
11703
11704
11705
11706
11707
11708
11709
11710
11711
11712
11713
11714

11816
11817
11818
11819
11820
11821
11822
11823
11824
11825
04/01/2013 02:36 stivenson2005#3
best is go to the NPC try to align yourself at the exact spot he is standing at and use /position.

now go to your dbo.NPCResource and copy all of the data there to an Excel sheet, then use the Search and search for the coordinates you got by /position.

try to search with the first 4 or 3 digits and see the one you think it is, then take the x and y of it and teleport to that coordinate if you landed on that NPC then you got it and it's ID


I hope this was helpful. There is many methods, I just gave you one, (which I use). GL
04/01/2013 12:15 TheOnlyOneRaskim#4
Code:
use arcadia

select npc.id,st.value,st2.value,npc.x,npc.y,npc.local_flag,npc.contact_script 
from npcresource npc join StringResource st on npc.text_id = st.code join StringResource st2 on npc.name_text_id = st2.code 
where contact_script like '%NPC_Event_2011_xmas%' or contact_script like '%NPC_event_2012_Xmas%'  order by st.value
Result (With German Strings):


Look at the Query and in the future build your own search query please.
04/02/2013 00:13 TheChinStrap#5
Quote:
Originally Posted by stivenson2005 View Post
best is go to the NPC try to align yourself at the exact spot he is standing at and use /position.

now go to your dbo.NPCResource and copy all of the data there to an Excel sheet, then use the Search and search for the coordinates you got by /position.

try to search with the first 4 or 3 digits and see the one you think it is, then take the x and y of it and teleport to that coordinate if you landed on that NPC then you got it and it's ID


I hope this was helpful. There is many methods, I just gave you one, (which I use). GL

You must be joking. What a waste of time...


If you know the name of the npc:
For example, if i am looking for teleporter Asmond, I serch for Asmond.

If the npc's name is an empty string, then search for the id. (Empty String:105002005 means the name id is 105002005):
Or