I did so before multiple times before I stumbled upon Noggit. Its a very good way of loosing your nerves and getting performance drops.

.gobject delete [guid]

guid can be ackquired by many ways. The most common ones are 2.:
.gobject target - will get you information about the closest gob to you.
.gobject near [range] - will get you list of all gobs in given range (implicit value is 10yd) with their guids.

If you have TrinityAdmin addon installed, .gobject target and then just clicking on delete in chat is the fastest way of doing most of things.

You can also, obviously, delete gobs from database (table world.gameobject). This method gives you by far most of options for any mass-deleting of gobs, depending on level of your skill in SQL.

Yes.



You need to use gossip_menu, gossip_menu_option and npc_text tables in world database. You also need to assign npc flag 1 (gossip) to your NPC.

You were probably not really following all steps:
"If you've never done so before, consider running ItemDBCToDB first. Explanation is in that tool's description."

And that explanation is here:
"ItemDBCToDB is here to get list of all items in item.dbc which are missing in your server's item_template and to insert their generated versions into that item_template. This can be useful if you want to give players possibility to use some items which were made for NPCs, but never for players (for example weapon and shield of gnome king, weapons of NE sentinels...). If you don't use this tool at least once before using ClientItem, you'll LOOSE all these NPC items which aren't present in item_template. This will lead into loosing all items held by NPCs which aren't in item_template, and into server error log spam. So consider running this tool once before ever using ClientItem."

I made video about usage of this pair of tools, and this fact is mentioned there, too.:



So:
- Use ItemDBCToDB to get all NPC-only items into item_template, making them accessible AND preventing them from being lost in next step.
- Use Client Item to get all item.dbc which is up to date and contains everythig: NPC-only items, original player-accessible items and your new custom items as well.

First of all, 0 GroupID for loots is fine in many cases. It only means "no group" - which means that more than 1 out of items in group can drop at once (or none can drop as well). And thats what you don't want in this particular case, yes. What happens at the moment is that in 10% of cases references are used, which have up to 26% to drop. 26/10 = 2.6%.

So there is only up to 2.6% of anything from references dropping, the rest what remains to 10% is quite high chance that NOTHING will drop. Because of groupID=0 which says "none, one, or multiple can drop at once". Set groupID to 1 in references, too.

Getting any kinds of spell/fire/fog/whatever effects from especially WoD+ to WotLK often results in huge loss of quality or produces something, what can't really be used at all, because WotLK doesn't support some of features introduced in later expansions. I don't know how much does this apply to Cata though.

Wheter it is possible - yes, it probably (not 100%) is - but thats universal answer to all "is it possible" questions around here. Just note that it may not be worth actual result. You can certainly try. In case of WotLK, SpellVisual*.dbc are responsible for spell visual effects. You'd have to figure out how whole system works, retro-port Legion M2s you want to use, get them into corresponding DBCs on older client and link them to your new spells. Also, if there is some crazy system on Legion putting spell effect M2s together which works in completely different way than on WotLK, this may not be really doable at all.

Then cg.

Skarn and some other people made WMO addon for Blender, and afaik, they are working (or going to work) on M2 addon as well. Perhaps contacting them and joining forces would be more effective.

https://github.com/WowDevTools/Blender-WMO-import-export-scripts