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
|