NPC problem

[H1tcher]

What is ID of this NPC



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

Edit: I found it ! Close pls

[ThunderNikk]

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

[stivenson2005]

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

[TheOnlyOneRaskim]

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

 Spoiler

11832	???	????<????,??>	152409	77118	-8193	NPC_event_2012_Xmas_f_1()
11833	???	????<???,??>	6690	6597	-8193	NPC_event_2012_Xmas_f_2()
11834	???	????<??,??>	116663	57286	-8193	NPC_event_2012_Xmas_f_3()
11835	???	????<????,??>	221707	20017	-8193	NPC_event_2012_Xmas_f_4()
11836	???	????<??,??>	137467	105428	-8193	NPC_event_2012_Xmas_f_5()
11816	Cooler	Weihnachtsmann	152519	77121	-1	NPC_event_2012_Xmas_m()
11817	Cooler	Weihnachtsmann	6847	6573	-1	NPC_event_2012_Xmas_m()
11818	Cooler	Weihnachtsmann	116870	57088	-1	NPC_event_2012_Xmas_m()
11819	Cooler	Weihnachtsmann	221792	19911	-1	NPC_event_2012_Xmas_m()
11820	Cooler	Weihnachtsmann	137537	105532	-1	NPC_event_2012_Xmas_m()
11821	Sexy	Weihnachtsmannschwester	152409	77118	-1	NPC_event_2012_Xmas_f_1()
11822	Sexy	Weihnachtsmannschwester	6690	6597	-1	NPC_event_2012_Xmas_f_2()
11823	Sexy	Weihnachtsmannschwester	116663	57286	-1	NPC_event_2012_Xmas_f_3()
11824	Sexy	Weihnachtsmannschwester	221707	20017	-1	NPC_event_2012_Xmas_f_4()
11825	Sexy	Weihnachtsmannschwester	137467	105428	-1	NPC_event_2012_Xmas_f_5()
11701	Weihnachtshelfer	Rentier<Laksy>	7557	7395	-1	NPC_Event_2011_xmas_event_rudolph_contact()
11702	Weihnachtshelfer	Rentier<Katan>	116960	57243	-1	NPC_Event_2011_xmas_event_rudolph_contact()
11703	Weihnachtshelfer	Rentier<Horizon>	153338	77057	-1	NPC_Event_2011_xmas_event_rudolph_contact()
11704	Weihnachtshelfer	Rentier<Rondo>	138406	105250	-1	NPC_Event_2011_xmas_event_rudolph_contact()
11705	Weihnachtshelfer	Rentier<City remains>	153838	150755	-1	NPC_Event_2011_xmas_event_rudolph_contact()
11706	Weihnachtshelfer	Rentier<Trainee Island >	172113	51729	-1	NPC_Event_2011_xmas_event_rudolph_contact()
11707	Weihnachtshelfer	Rentier<Hidden village>	221703	20214	-1	NPC_Event_2011_xmas_event_rudolph_contact()
11708	Weihnachtshelfer	Cruz<Laksy>	7645	7500	-1	NPC_Event_2011_xmas_event_claus_contact()
11709	Weihnachtshelfer	Cruz<Katan>	117003	57138	-1	NPC_Event_2011_xmas_event_claus_contact()
11710	Weihnachtshelfer	Cruz<Horizon>	153333	76919	-1	NPC_Event_2011_xmas_event_claus_contact()
11711	Weihnachtshelfer	Cruz<Rondo>	138242	105201	-1	NPC_Event_2011_xmas_event_claus_contact()
11712	Weihnachtshelfer	Cruz<City remains>	153751	150529	-1	NPC_Event_2011_xmas_event_claus_contact()
11713	Weihnachtshelfer	Cruz<Trainee Island >	172252	51734	-1	NPC_Event_2011_xmas_event_claus_contact()
11714	Weihnachtshelfer	Cruz<Hidden village>	221825	20218	-1	NPC_Event_2011_xmas_event_claus_contact()

Look at the Query and in the future build your own search query please.

[TheChinStrap]

Originally Posted by stivenson2005

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:

 Spoiler

USE Arcadia
GO

SELECT NPC.id, NPC.name_text_id, STRING.value, NPC.x, NPC.y, NPC.contact_script
FROM dbo.NPCResource as NPC
LEFT JOIN dbo.StringResource as STRING
ON npc.name_text_id = string.code
WHERE STRING.value like '%Asmond%'

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

 Spoiler

USE Arcadia
GO

SELECT NPC.id, NPC.name_text_id, STRING.value, NPC.x, NPC.y, NPC.contact_script
FROM dbo.NPCResource as NPC
LEFT JOIN dbo.StringResource as STRING
ON npc.name_text_id = string.code
WHERE NPC.name_text_id = 105002005

Or

 Spoiler

SELECT NPC.id, NPC.name_text_id, STRING.value, NPC.x, NPC.y, NPC.contact_script
FROM dbo.NPCResource as NPC
LEFT JOIN dbo.StringResource as STRING
ON npc.name_text_id = string.code
WHERE NPC.id = 2005