Quote:
Originally Posted by Kingly_Krab
Actually, I'm not doing all Orcs, I do it by zone.
Code:
UPDATE npc_types n INNER JOIN spawnentry s ON n.id = s.npcID INNER JOIN spawn2 s2
ON s.spawngroupID = s2.spawngroupID SET n.CHANGEME = VALUE WHERE s2.zone = 'ZONENAME';
Code:
SELECT DISTINCT n.* FROM npc_types n INNER JOIN spawnentry s
ON n.id = s.npcID INNER JOIN spawn2 s2 ON s.spawngroupID = s2.spawngroupID WHERE s2.zone = 'ZONENAME'
ORDER BY `hp` DESC LIMIT 1000;
|
K well.. I'm not gonna have a dick-swinging contest with you. Do things your way. I shared this because I figured it would save some people a bit of time.