View Single Post
  #3  
Old 02-09-2004, 08:21 PM
Muuss
Dragon
 
Join Date: May 2003
Posts: 539
Default

launch a mysql console (like you would do if you wanted to source a db.sql)

then type :

select spawn2.id from spawn2,npc_types,spawnentry where npc_types.name like '%sleeper%' and spawnentry.npcID=npc_types.id and spawnentry.spawngroupID=spawn2.spawngroupID;

ps : i have no DB here, so i haven't tested it
__________________
Muuss - [PEQGC] Dobl, the ogre that counts for 2 !
http://www.vilvert.fr/page.php?id=10
Reply With Quote