How do i delete All Retail Mobs?

[HouLiGaN]

How do i delete them :P ????

[Erol]

do it in game

/target

//delete

[Akz]

Remove them from spawnlist.sql

[EdenEternal]

How do i delete them :P ????

what mean retail monster i can't understand

[HouLiGaN]

well i know how to do it from ingame but i cant do that to all of l2 world Mobs!

I will Try and do what Akz tell me .

Leki i men the mobs that are already there... not the custom 1 the ones that are from official... Get it?!

 

 

And thanks guys for  respond :)!

[EdenEternal]

well i know how to do it from ingame but i cant do that to all of l2 world Mobs!

I will Try and do what Akz tell me .

Leki i men the mobs that are already there... not the custom 1 the ones that are from official... Get it?!

 

 

And thanks guys for  respond :)!

if don't add it self all packs have retail mobs i think

[Akz]

He wants to delete all mobs from the map.

What's so hard to understand? :P

[nekys]

Wait I might got an SQL.

[nekys]

delete from `spawnlist` where `npc_templateid` in (SELECT `id` FROM `npc` WHERE type` = 'L2Monster' AND `title` = '');

[Akz]

Explain to him how to use that, doubt he knows. :P

[Onix]

easy to explain lets go :

 

1. Open notepad and put this

 

delete from `spawnlist` where `npc_templateid` in (SELECT `id` FROM `npc` WHERE type` = 'L2Monster' AND `title` = '');

 

2. Save as delete.sql (ofc its example) .

 

3. Open Navicat click twice on localhost then right-click in our database (default name is l2jdb) select execute SQL from a file and select your file called delete.sql and click excute and all finished ;)

[xLeGenD]

easy to explain lets go :

 

1. Open notepad and put this

 

delete from `spawnlist` where `npc_templateid` in (SELECT `id` FROM `npc` WHERE type` = 'L2Monster' AND `title` = '');

 

2. Save as delete.sql (ofc its example) .

 

3. Open Navicat click twice on localhost then right-click in our database (default name is l2jdb) select execute SQL from a file and select your file called delete.sql and click excute and all finished ;)

btw u must edit the sql..

[Akz]

It's easier to run SQL-update. :P

[HouLiGaN]

Ty nekys i will try that now and see if it works ;)!

[HouLiGaN]

btw u must edit the sql..

 

 

Sorry for spam...

Please edit it it wont work im running on epilogue l2j server if it makes any difrence!

[Erol]

well i know how to do it from ingame but i cant do that to all of l2 world Mobs!

I will Try and do what Akz tell me .

Leki i men the mobs that are already there... not the custom 1 the ones that are from official... Get it?!

 

 

And thanks guys for  respond :)!

ye but you may need again in a future.

That's why i suggest to delete in game.