Quote:
|
Originally Posted by mollymillions
SELECT CONCAT('delete from spawn2 WHERE id = ', max(spawn2.id),'; DELETE FROM spawnentry WHERE spawngroupID = ', max(spawn2.spawngroupID),';') Query
FROM spawn2, spawnentry, npc_types
WHERE spawn2.spawngroupID = spawnentry.spawngroupID
AND spawnentry.npcID = npc_types.ID
AND spawn2.pathgrid = 0
GROUP by zone, x, y, z, npc_types.name
HAVING COUNT(spawn2.id) > 1
ORDER BY zone, x, y, z, npc_types.name
|
The above gives a huge list of deletes...but it doens't do them. Do you have to manually type them into mySQL?
If so, can't you dump the results into an sql file that you could source? There are 1200 results from that query :/
Thanks,
Monrezz