This is one of the items remaining on the Velious To-Do list. 
Most of the npcs have correct spawn timers at this point, but these are the remainders.  I figured I'd open this up so people can research on their own, and maybe finish it sooner.
	Code:
	select distinct npt.name,sp2.respawntime
from npc_types npt
left join spawnentry spt on (spt.npcid=npt.id)
left join spawn2 sp2 on (sp2.spawngroupid=spt.spawngroupid)
left join spawngroup sg on (sg.id = spt.spawngroupid)
where sp2.zone = 'westwastes' and spt.chance > '0' and sp2.respawntime < '1000'
 So, everything that spawns in westwastes that has a respawn time less than 1000 seconds.  (Default value is 360 or 400).
	Quote:
	
	
		| Bratavar        400 Pantrilla        400
 Vraptin        400
 Gafala        400
 Yeldema        400
 a_wyvern        400
 Vitaela        400
 Hechaeva        400
 Shardwing_Courier        400
 Harla_Dar        400
 Travala        400
 Mraaka        400
 The_Dragon_Sage        400
 a_shipwrecked_pirate        400
 Breezeboot_Swordrattler        400
 Mazi        400
 a_drake        400
 Tranala        400
 Makil_Rargon        400
 an_elder_wyvern        400
 Tsiraka        400
 a_glacier_mastodon        400
 a_wyvern_hunter        400
 a_wyvern_huntress        400
 a_velium_hound        400
 a_brontotherium        400
 an_ice_burrower        400
 a_gravid_drake        400
 a_cragwyrm        400
 a_Velious_Drake        400
 a_lindwyrm        400
 Cargalia        400
 Ayillish        400
 Derasinal        400
 Draazak        400
 Entariz        400
 Ionat        400
 Karkona        400
 Glati        400
 Kar_Sapara        400
 Jen_Sapara        400
 Zil_Sapara        400
 Rak_Sapara        400
 Mav_Sapara        400
 Del_Sapara        400
 Neordla        400
 Esorpa_of_the_Ring        360
 Von        360
 |