Remove NPC or edit

06/16/2013 19:13 rickske95#1
Is there a way to edit npc's and remove because i have some npc's ingame and they will crash the client when click on it
06/16/2013 19:19 Dyson49#2
SQL Server --> Arcadia --> NPCResource (Right Click) --> Edit Top Rows

Then, edit or delete
06/16/2013 20:16 eziorav#3
use arcadia
delete from npcresource
where id = xxxx
06/17/2013 11:15 TheChinStrap#4
Quote:
Originally Posted by eziorav View Post
use arcadia
delete from npcresource
where id = xxxx
Don't do this. ^

Just find the npc in arcadia and change the flag.
06/17/2013 14:19 eziorav#5
Quote:
Originally Posted by TheChinStrap View Post
Don't do this. ^

Just find the npc in arcadia and change the flag.
Yep u are right
the code will remove any Npc with the same id
just change the flag as he said

update npcresource
set local_flag = 18937 where contact_script like "%xxxxx%"
06/18/2013 05:26 TheChinStrap#6
Quote:
Originally Posted by eziorav View Post
Yep u are right
the code will remove any Npc with the same id
just change the flag as he said

update npcresource
set local_flag = 18937 where contact_script like "%xxxxx%"
Don't do this ^ either.

Use this script to find the id:

Then:
06/18/2013 08:30 TheOnlyOneRaskim#7
Quote:
Originally Posted by TheChinStrap View Post
Then:

UPDATE dbo.StringResource
SET local_flag = XXXX
WHERE id = XXXX
You Serious?

Im sure you meant this or?
Update arcadia.dbo.npcresource set local_flag = xx where id = xx
06/18/2013 10:26 TheChinStrap#8
Quote:
Originally Posted by TheOnlyOneRaskim View Post
You Serious?

Im sure you meant this or?
Update arcadia.dbo.npcresource set local_flag = xx where id = xx
Ha ha ha. Yeah, I must have been tired. Post corrected. Thanks, Raskim, for pointing out my shortcomings, yet again. XD
06/18/2013 18:21 rakanomar#9
some note : if you want to edit the NPC you must edit in Database and in RDB
But , if you just want to edit the location ( x,y) you can edit it in Database only