Maybe Anyone Have Spawnlist Without Monsters?

[Mellion]

Hello i wanna ask, maybe someone have spawnlist( in database) without monsters but whit npc in town? please share if you have.

[xxdem]

A quick solution to this is to ignore monster spawns at L2Spawn class

[AbsolutePower]

a simple sql code to delete all monsters :P

DELETE  FROM npc  WHERE type = 'L2Monster';

Edited December 19, 2016 by AbSoLuTePoWeR

[SweeTs]

There is no type in SQL defined QQ

[AbsolutePower]

There is no type in SQL defined QQ

what? try again.

DELETE FROM npc
WHERE type='L2Monster';

[SweeTs]

What I mean is, spawnlist on aCis does not contain monster type. If you ask me it's pointless, but in such case, hell yeah, that would be handy. There is no npc table as well :D

 

 

The only thing that comes to my mind is, to delete npcs by id range. As npcs (traders) and monsters are not really mixed, if I'm not wrong. It's like 0-100 monsters, 200-300 npc and so on. Just an example.

Edited December 19, 2016 by SweeTs

[AbsolutePower]

What I mean is, spawnlist on aCis does not contain monster type. If you ask me it's pointless, but in such case, hell yeah, that would be handy. There is no npc table as well :D

 

 

The only thing that comes to my mind is, to delete npcs by id range. As npcs (traders) and monsters are not really mixed, if I'm not wrong. It's like 0-100 monsters, 200-300 npc and so on. Just an example.

he is using acis? :S ook then   :happyforever:

Edited December 19, 2016 by AbSoLuTePoWeR

[SweeTs]

Well, not sure haha, dunno why I tho he mentioned aCis.. :D

 

Anyway, if aCis - there is nothing you can do. If frozen - then yeah, sql query is enough to delete npcs.

[xxdem]

 

Anyway, if aCis - there is nothing you can do

 

read my answer again

[Mobius]

A quick solution to this is to ignore monster spawns at L2Spawn class

 

That would work, but...

What if he later wants to spawn his own monsters?

>:D

[xxdem]

That would work, but...

What if he later wants to spawn his own monsters?

>:D

 

What I did, was to remove L2Monsters and subclasses from L2Spawn while it got init via a temp method that would be used only once and removed. That method will remove it straight from the DB. 

 

Of course that is if you wan't to permantly clean your spawnlist.sql with the help of the gs, and then you can add your own and remove the temp method. After that all you have is a clean spawnlist.sql that you can use as a base.

 

Thats what I did, its stupid but took me just a few minutes

Edited December 20, 2016 by xxdem

[Mobius]

What I did, was to remove L2Monsters and subclasses from L2Spawn while it got init via a temp method that would be used only once and removed. That method will remove it straight from the DB. 

 

Of course that is if you wan't to permantly clean your spawnlist.sql with the help of the gs, and then you can add your own and remove the temp method. After that all you have is a clean spawnlist.sql that you can use as a base.

 

Thats what I did, its stupid but took me just a few minutes

 

How about sharing with this guy then.  >:D

[SweeTs]

read my answer again

Yeah, I was talking about SQL query :p

[Mobius]

From another post I saw he uses l2jfrozen.

So an SQL query would do.

 

DELETE s.* FROM spawnlist s INNER JOIN npc n ON s.npc_templateid = n.idTemplate WHERE (n.type = "L2Monster");

[Mellion]

yes its does matter now, just please help me now whit enchanter thanks

[AccessDenied]

The only nice answer is given by xdem, the rest you're just noobs, low IQ kids who can't code shit   :-[

if (template1.type.equalsIgnoreCase("L2Monster"))
{
  //ignore spawn and kiss sweet's cheeks				
}

in spawnTable will ignore the spawn come from spawnlist.

Edited December 20, 2016 by AccessDenied