How to delete all the mobs.

[mevacrana]

Well there was a topic of the same subject 2 days ago and the answer was:

 

Run a mysql Query. : DELETE * FROM spawnlist;

 

That pops this message tho:

 

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '* FROM spawnlist' at line 1

 

 

Any ideas?

Thanks ppl.

[Lucky Dice]

SO you want to delete all mobs?

one one :P

[mevacrana]

Im sure it is possible to delete them all in 1 shot.

[down]

DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level>0

 

Try this...

[Commodus]

SO you want to delete all mobs?

one one :P

 

Failed.

 

DELETE spawnlist, npc FROM spawnlist, npc WHERE spawnlist.npc_templateid=npc.idTemplate AND npc.level>0

 

Try this...

 

Failed Search . Does not Working.

 

Im sure it is possible to delete them all in 1 shot.

 

Of course you can.

 

Here is the script :

 

DELETE FROM spawnlist
WHERE id< ( here put the number id of your latest mob in spawnlist )

For example :

DELETE FROM spawnlist
WHERE id<75000

 

Execute it and you're done.

[mevacrana]

Cool ill try it... and whats the highest ID ? Are u sure it wont take off the NPC's as well ?

[Commodus]

Cool ill try it... and whats the highest ID ? Are u sure it wont take off the NPC's as well ?

 

Well look better the code.

 

Delete from SPAWNLIST. Not from npc :]

 

When i said the highest i mean , go in your database in table spawnlist.

 

You know , each mob has an id , and if you go in the last page you will see in the last line the mob with the highest id :]

 

And btw , it's working. Used it many times.

 

[Intrepid]

answered, locked.