Couple of questions about Database and other.

[AdrianD]

Hello,

I've spent a ton of time on my database relative to how long I've been part of the community. (I'm part of it, right?) But, your second question is easier for me to answer.

I haven't used the in-game #spawn enough to understand it's intricacies. If I want a duplicate of and existing mob, I will use #dbspawn <npc_types.id> then I think #npcspawn create to give it a spawngroupid. I haven't used it much so you may want to check the wiki pages on this http://wiki.eqemulator.org/p?How_to_..._NPCs&frm=Main

I use HeidiSQL to make the vast majority changes to my DB.

Your first question is difficult to answer because I am not aware of anything in the table `npc_types` that distinguishes a raid boss from a non-raid boss. If I were doing something like what you want to do and I wanted to be accurate, unfortunately, I would probably have to go on memory and other sources and hand pick these.

To make hand picking easier, I would write some queries to make searching for these mobs a lot easier. As far as I know, doing it either way will still take some time to sift through the npcs you want to include as a raid boss. Now, if someone had a list, injecting this list into a table and checking npc_types against this table would be "simple".

The answer to your question will be determined by how much time you want to spend on this minus a list someone already has formulated.

[AdrianD]

I learned something new.

There is a column called `raid_target` in the `npc_types` table.

select * from `npc_types` where `raid_target` > 0;

I'm unsure the accuracy of the values in this column as I have never used it to make selections.

EDIT: It appears my database does not have any values outside of the default value in this column. Your DB version will determine if you have values in this column. I have the last cavedude DB from February which has values of 1 for some/all? raid_targets.

EDIT2: The list is incomplete from the February DB. It lists npcs from PoP and GoD. Not all npcs in this list are actual raid bosses indicating, if this column is used in the source, that it may be used for resting regen instead of merely identifying the npcs. It's a start for you though.