Thread
:
SQL Help: Linking NPC ID to zoneid
View Single Post
#
2
10-20-2010, 01:14 AM
csb4623
Sarnak
Join Date: Oct 2009
Location: Louisiana
Posts: 62
SELECT nt.name, s2.zone
FROM spawn2 s2
JOIN spawngroup sg
ON sg.id = s2.spawngroupid
JOIN spawnentry se
ON se.spawngroupid = sg.id
JOIN npc_types nt
ON nt.id = se.npcid
WHERE s2.zone = 'crushbone';
csb4623
View Public Profile
Send a private message to csb4623
Find all posts by csb4623