Remove NPC or edit

[rickske95]

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

[Dyson49]

SQL Server --> Arcadia --> NPCResource (Right Click) --> Edit Top Rows

Then, edit or delete

[eziorav]

use arcadia
delete from npcresource
where id = xxxx

[TheChinStrap]

Originally Posted by eziorav

use arcadia
delete from npcresource
where id = xxxx

Don't do this. ^

Just find the npc in arcadia and change the flag.

[eziorav]

Originally Posted by TheChinStrap

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%"

[TheChinStrap]

Originally Posted by eziorav

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:

 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%'

Then:

 Spoiler

UPDATE dbo.NPCResource
SET local_flag = XXXX
WHERE id = XXXX

[TheOnlyOneRaskim]

Originally Posted by TheChinStrap

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

[TheChinStrap]

Originally Posted by TheOnlyOneRaskim

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

[rakanomar]

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