scribeallspells() and learnalldisciplines()

[strider51]

I recently made an npc that will call these functions as part of a quest. However I noticed that it throws a bunch of extra spells and some 'unknown' disciplines into my toons books and abilities.

I was thinking about just deleting these from the database (the source tables, not the relational table) any harm in this?

Also I may have gotten the exact syntax wrong for the functions bec@ause I'm not on a pc.

Does anyone else experience these extra spells and disc? Is there harm in leaving them in?

Thanks!

[sorvani]

They are annoying clutter in the spell books, I glanced at the code once but got side tracked on something else.

[strider51]

Ok,

Is this a database fix, or a code fix? I was thinking about just fixing the code rather than DB to include an additional rule check that would filter those out, because I'm afraid they might be used elsewhere for an NPC or item colicky or something.

[trevius]

If you wanted to remove them, you would remove them from the Database.

Though, the easiest solution would be to make use of the spells import/export scripts. You can run those scripts to either export all of the spells in the database into a spells_us.txt file that you can put in your EQ folder, or you can import the spells_us.txt file that you currently have in your EQ folder into your database. Either solution will work and will get rid of the unknown spells. The main point is that you need to have your server and clients matching spell files.

The downside to removing spells from the DB is that you would probably be removing focuses and other spells that higher level items use. As long as you don't plan to use newer items, you shouldn't need to worry about it, though.

[strider51]

thanks much for the help.
Trevius, I have taken a lot of your advice, and used a few of your quest scripts. I would like to thank you kindly for your contributions.