Help L2J: How to deleted a npc spawn that cannot be targeted

[Aaron_Shinta]

Hello everyone:

By mistake I've spawned a "SandStorm" (ID = 32350 ) at my server, as I was actually looking to spawn a "Sandstorm*" (ID = 22340); now, I'm not able to delete the former one,  as it not possible to be targeted. Could anyone give me any idea how to see the implemented spawned npcs, and /or other way to delete/unspawn this NPC?

Thanks a lot in advanced for anyone that pass here and give any clues.

[HyperBlown]

//scan command or manualy on the table: custom_spawnlist 

[Kara]

10 hours ago, Aaron_Shinta said:

Hello everyone:

By mistake I've spawned a "SandStorm" (ID = 32350 ) at my server, as I was actually looking to spawn a "Sandstorm*" (ID = 22340); now, I'm not able to delete the former one,  as it not possible to be targeted. Could anyone give me any idea how to see the implemented spawned npcs, and /or other way to delete/unspawn this NPC?

Thanks a lot in advanced for anyone that pass here and give any clues.

 

Open your eclipse, select your database, query, insert the following:

 

DELETE FROM custom_spawnlist WHERE custom_spawnlist.npc_templateid = <ID_HERE>;

 

and execute it.

[GsL]

Just find into your spawn files the ID of your npc .  And delete it .. what pack u use ? L2jfroxen have it into data base 

Mobius into xml

[Aaron_Shinta]

Thanks for the reply eveyrone
 

14 hours ago, HyperBlown said:

//scan command or manualy on the table: custom_spawnlist 

Considering this suggestion, the Table custom_spawnlist is empty so, I guess that it is used when I spawn NPCs actually customed (i.e., not retail NPC's)?

 

Btoh... yes!! The scan command does the trick!!

Thanks a lot HyperBlown and eveyone else that came up to give help. I really appreciate this community (there are pretty few trolls compared to the friendly people ).

[Vision]

We are happy to see you satisfied mate.

I lock this one.