Register for your free account! | Forgot your password?

You last visited: Today at 18:04

  • Please register to post and access all features, it's quick, easy and FREE!

 

NPC problem

Reply
 
Old   #1
 
elite*gold: 0
Join Date: Mar 2013
Posts: 28
Received Thanks: 0
NPC problem

What is ID of this NPC



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

Edit: I found it ! Close pls



H1tcher is offline  
Old   #2
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,004
Received Thanks: 958
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


ThunderNikk is offline  
Thanks
1 User
Old   #3
 
elite*gold: 0
Join Date: May 2010
Posts: 85
Received Thanks: 15
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
stivenson2005 is offline  
Thanks
1 User
Old   #4
 
elite*gold: 0
Join Date: Nov 2011
Posts: 980
Received Thanks: 1,007
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.


TheOnlyOneRaskim is offline  
Thanks
2 Users
Old   #5
 
elite*gold: 0
Join Date: Jul 2012
Posts: 147
Received Thanks: 196
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


TheChinStrap is offline  
Reply



« Previous Thread | Next Thread »



All times are GMT +2. The time now is 18:04.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy
Copyright ©2017 elitepvpers All Rights Reserved.