View Single Post
  #6  
Old 06-25-2009, 02:11 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

I created this query to test the database.

Code:
SELECT *
FROM spawn2 s2 
INNER JOIN
spawngroup s1 ON s2.spawngroupID=s1.id
INNER JOIN
spawnentry s3 ON s1.id=s3.spawngroupID
INNER JOIN
npc_types n1 ON s3.npcID=n1.id
 WHERE zone='sirens' AND n1.npc_aggro=1
And it came back negative.....
Reply With Quote