Wizard like to chain cast see invis

[cubber]

If I create a wizard bot she will start her buff set, and when she gets to see invis she will just keep casting it over and over again. Looks like she meds after each cast then gets up and starts casting it. If I ask for her to do a #bot lore she will interrupt the see invis casting do the lore lookup then go back to casting see invis.

[Angelox]

If you're running older database, you need to run the Sql included in the sources SVN, or stuff like that will happen;

Required SQL: utils/sql/svn/250_bot_spell_update.sql

And if you want to use the #bot resist commands other than it being automatic, this one will fix it;

Optional SQL: utils/sql/svn/250_optional_bot_spell_update.sql

[cubber]

Not running and old DB just did not realize I needed to update the spell tables for bots. Will do that now thanks.

Wondering if this will fix the bug I just had with a druid evac. Said Zoning to Plane of War when I had a druid evac me in frontier mnts. That kinda spooked me a bit, until I landed safely in FM.

[cubber]

Just for future reference, are most of the sql files in that folder included in the newer PEQ CVS releases or will I have to update them each time I pull down a new db and svn? Looking through the older ones they seem to all be in the DB already. The only ones I had to add so far are mail chatchannels and bot spells.

[number6]

Originally Posted by cubber

Wondering if this will fix the bug I just had with a druid evac. Said Zoning to Plane of War when I had a druid evac me in frontier mnts. That kinda spooked me a bit, until I landed safely in FM.

Actually, if I remember rightly this is an intentional kludge to make sure you clear aggro when evac'ing... it makes you briefly zone out and get forgotten about by the mobs.

[cubber]

The update did not fix the invis casting loop. Just to note when I do a svn update and compile I always pull down the latest PEQ CVS and install that as well.

Running SVN Rev 255 and PEQ CVS Rev 1129Rev245.sql

[cubber]

Hmm looking at it a bit more it looks like when CaveDude does an update he includes the svn sql updates, however since there has not been a PEQ update since 245 and I am running svn 255 there are some missing updates that are needed for the newer server core that need to be applied.

But when PEQ comes out with a new update these svn updates should be applied?

Edit: The resist update seems to have worked. I hated the fact that they filled up my buff slots with unneeded resists. Thanks!

[Angelox]

Is it invisible or see invisible you're having trouble with?

[cubber]

see invis

She will cast it and it says "your eyes tingle"

then she will cast again and it will wear off and then say "your eyes tingle" again. and again and again.

[Angelox]

What it is, I planned to add 'see invisble' to the '#bot invis' option and forgot.
"Do you want [invis undead], [invis live], or [invis see]?"

I'll try fix it today, mean time you can run this Sql;

DELETE FROM npc_spells_entries where (npc_spells_id >=701 and npc_spells_id <=712) AND spellid=80;

And it should fix the problem.

Any spell that has become a #bot command, needs to be removed from the bots spell list.

[cubber]

The sql fixed the casting loop. She now goes on to cast her other buffs on herself. Before she would cast the first buff then see invis then loop in see invis. Now she does not cast see invis at all.

I tried #bot invis see but it just gave me options for invis live and invis undead

I figured that #bot invis see needs to be implemented yet to work.

[Angelox]

It's all fixed and submitted, '#bot invis see', also the wizard evac.

Originally Posted by cubber

The sql fixed the casting loop. She now goes on to cast her other buffs on herself. Before she would cast the first buff then see invis then loop in see invis. Now she does not cast see invis at all.

I tried #bot invis see but it just gave me options for invis live and invis undead

I figured that #bot invis see needs to be implemented yet to work.

[cubber]

Thank you, I will recompile and test if I get a chance tommorrow.

I was also thinking what about corpse summoning for Necros and SK's? Give them the proper coffin and they summon your corpse?

[cubber]

One other thing that would make wizards better, would be to make levitation an optional spell like invis, sow and the rest. They always will cast levitate on you if one is in your group. If it gets clicked off it will be recast. The only way around it is to get all your buff slots filled up to prevent it from sticking.

Some zones levitation is nice, however it can be very annoying in most situations especially for a melee class.

[Angelox]

That spell is already a command and should have been removed, I just left it out of the 250_bot_spell_update.sql, I updated that file, here's what I added, you can also remove;

DELETE FROM npc_spells_entries where (npc_spells_id >=701 and npc_spells_id <=712) AND spellid=80;
DELETE FROM npc_spells_entries where (npc_spells_id >=701 and npc_spells_id <=712) AND spellid=261;
DELETE FROM npc_spells_entries where (npc_spells_id >=701 and npc_spells_id <=712) AND spellid=255;
DELETE FROM npc_spells_entries where (npc_spells_id >=701 and npc_spells_id <=712) AND spellid=894;
DELETE FROM npc_spells_entries where (npc_spells_id >=701 and npc_spells_id <=712) AND spellid=2739;
DELETE FROM npc_spells_entries where (npc_spells_id >=701 and npc_spells_id <=712) AND spellid=86;

Any spell that's been turned into a #bot command, needs to be removed from the PEQ databases "npc_spells_entries" table.
I think I finally got them all, but if you see a bot auto casting a spell that should be a command, post it and we'll add it to the above list ('#bot list' will tell you what spell should be a command).
A lot of these spells I had pulled out of my own database a long time ago, just because they annoyed me, and I forgot they were still in the PEQ database.