Notorious Monster ID list

[Cyprus]

I have looked all over for an easy to read list of Notorious Monsters & their ID # to use with the GM spawn command but can't find one. The sql list of mobs is massive & not very quick to locate monsters...anyone have something like this??

[whasf]

I'd just use the spawn list.. or http://www.dspt.info/moblist.php .. the ID will be in the URL

[kjLotus]

you can use sql queries to find the regular mob id of notorious monsters (ie. "select mobid from mob_spawn_points where mobname = "fafnir";", etc)

[atom0s]

Inside mob_pools is the mobType field. If the type contains the mask value of 2, it means it is an NM.
So you can do a query like this to pull the full list of NMs from the database with their IDs and such:

Code: Select all

SELECT mobid, mobname FROM dspdb.mob_spawn_points
	INNER JOIN dspdb.mob_groups ON dspdb.mob_spawn_points.groupid = dspdb.mob_groups.groupid
	INNER JOIN dspdb.mob_pools ON dspdb.mob_groups.poolid = dspdb.mob_pools.poolid
WHERE ((dspdb.mob_pools.mobType  & 2) > 0)
ORDER BY mobname

And if you want their spawn position and zone, you can use:

Code: Select all

SELECT mobid, mobname, pos_x, pos_y, pos_z, dspdb.mob_groups.zoneid FROM dspdb.mob_spawn_points
	INNER JOIN dspdb.mob_groups ON dspdb.mob_spawn_points.groupid = dspdb.mob_groups.groupid
	INNER JOIN dspdb.mob_pools ON dspdb.mob_groups.poolid = dspdb.mob_pools.poolid
WHERE ((dspdb.mob_pools.mobType  & 2) > 0)
ORDER BY mobname

To obtain that info as well.

[Cyprus]

Thanks for the replies...still learning a lot of this stuff so it helps a lot.