SQL Queries

-- find all spawns in a zone, ordered by level desc
SELECT CONCAT('UPDATE spawn2 SET min_expansion = ', s2.min_expansion, ' WHERE spawngroupid = ', s2.spawngroupid, ' -- ', n.name, ' lvl ', n.level, ' ', se.chance, '% chance in ', s2.zone) spawn2
FROM spawn2 s2 INNER JOIN spawnentry se ON s2.spawngroupid = se.spawngroupid INNER JOIN npc_types n ON n.id = se.npcid
WHERE s2.zone = 'hateplane' GROUP BY se.spawngroupid ORDER BY n.level DESC