Page 1 of 1
Notorious Monster ID list
Posted: Mon Sep 08, 2014 1:04 pm
by 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??
Re: Notorious Monster ID list
Posted: Mon Sep 08, 2014 2:16 pm
by whasf
I'd just use the spawn list.. or
http://www.dspt.info/moblist.php .. the ID will be in the URL
Re: Notorious Monster ID list
Posted: Mon Sep 08, 2014 2:17 pm
by 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)
Re: Notorious Monster ID list
Posted: Mon Sep 08, 2014 2:47 pm
by 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.
Re: Notorious Monster ID list
Posted: Tue Sep 09, 2014 3:02 pm
by Cyprus
Thanks for the replies...still learning a lot of this stuff so it helps a lot.