Sow in Dungeons

[Angelox]

Here is the revised 'default NPC' and 'default pet NPC' spell list insert - also has the shaman sow list at 720. I made one mistake and this is I took sow off default shamans and kept sow on the new shaman list < it should be the other way around (easy to fix).
You need to first delete what you have;

DELETE FROM npc_spells_entries
where (npc_spells_id >=1 and npc_spells_id <=12)
or (npc_spells_id >=514 and npc_spells_id <=524);

Then run the insert.
When you get done, you can go into a zone and #showbuffs will reveal 3-4 buffs (or less).
buffing spam is gone with this fix.
It's only for PEQ database, will not work on AX_CLASSIC, as 514-524 are bots. I already have added them to the posted AX_CLASSIC update.

[Congdar]

bots are 701-712

[Angelox]

Originally Posted by Congdar

bots are 701-712

That's for PEQ- I made them 513-524 since the pet list is at 213-224 on my DB.
On PEQ 513 -524 is default pet NPC.

[Angelox]

Here's a better idea to what I originally had in mind - All these code snipets I'm posted are already tested for a while now, I sort of wanted to make sure i wasn't 'blunder posting' first.

Since really we are talking about Shamans Sow in dungeons, Why not disable all speed movement spells in dungeons , then add extra run speed to choice mobs?

around Line 164 in MobAI.cpp replace this;

						if (
							(spells[AIspells[i].spellid].targettype == ST_Target || tar == this)
							&& tar->DontBuffMeBefore() < Timer::GetCurrentTime()
							&& !tar->IsImmuneToSpell(AIspells[i].spellid, this)
							&& tar->CanBuffStack(AIspells[i].spellid, GetLevel(), true) >= 0
							&& !(tar->IsPet() && tar->GetOwner()->IsClient() && this != tar)	//no buffing PC's pets, but they can buff themself
							) {
							AIDoSpellCast(i, tar, mana_cost, &tar->pDontBuffMeBefore);
							return true;
						}

With this;

						if (
							(spells[AIspells[i].spellid].targettype == ST_Target || tar == this)
							&& tar->DontBuffMeBefore() < Timer::GetCurrentTime()
							&& !tar->IsImmuneToSpell(AIspells[i].spellid, this)
							&& tar->CanBuffStack(AIspells[i].spellid, GetLevel(), true) >= 0
							&& !(tar->IsPet() && tar->GetOwner()->IsClient() && this != tar)	//no buffing PC's pets, but they can buff themself
						) {	
						if(IsEffectInSpell(AIspells[i].spellid, SE_Levitate) && !zone->CanLevitate() ||
						  IsEffectInSpell(AIspells[i].spellid, SE_MovementSpeed) && !zone->CanCastOutdoor()){ //Angelox
						break;
						}
							AIDoSpellCast(i, tar, mana_cost, &tar->pDontBuffMeBefore);
							return true;
						}

I included Levitate also.

I then went through the dungeons where I knew shamans could sow, and ran Querys like this one;

UPDATE npc_types SET runspeed='1.9' WHERE (ID>='65000' AND ID<='65999') and class='10'; ##GukTop Shamans