scribespells <level> broken?
 

Scribespells <level> seems to be broken.
Rev 649, DB rev 646
pulled & compiled today.

client says scribing spells to spellbook... and nothing happens.
tried on several characters.

bought a spell and tried scribing it, get 'unexpected error: spell id out of range'

using spells from SoF client on the server, and using SoF client.

did i miss something?

Did you try scribing a normal spell? Like from a scroll?

yep tried that after i zoned and bought a spell from a vendor.

this was on a clean install of the database from PEQ db rev 628 + clean install of player tables + clean install of bot tables + freshly created character + SVN sql updates

Was scribing spells working ok for you on the last Revision you were using? Which revision did you use before this and were you using the same spells file?

Also, did you compile the source yourself, or are you using the pre-compiled binaries for Windows? Do you know if you are set to use the spells_new table or the spells_us.txt file for loading spells on the server? The default with the pre-compiled binaries is to load from the spell file, not the table (which I think needs to be changed soon to use the table as default).

Have you edited the spell file at all from the standard one that comes with SoF? If you edited it, there is a chance that something got messed up. If you used the Ailia/Bleh editor to edit it, it will mess up SoF spell files, since it is only designed to work with Titanium spell files. You can still use the ailia/bleh editor, but if you do, you have to import the file into the database after you edit it and then export it back out of the database so it has all of the required fields for SoF. Otherwise, it will cause major issues and probably crash your SoF client.

Have you tested the server using a Titanium client to see what happens?

Last, I did make a few recent changes to how the spell are loaded to the player profile for SoF, but they shouldn't cause any problems. One thing I changed was to increase the amount of spells that can be stored in your player profile from 400 to 480 since SoF now has a 60 page spell book as apposed to the 50 page spell book in Titanium. Another thing I changed is that I found the player profile structure for SoF had the spellbook field off by 2 spells, which was causing the first 2 spells in your book to not show up after zoning, which made them unusable. That is now fixed and neither of those changes should be causing the problems you are seeing. I am running R646 on Storm Haven and it works just fine.

tbh i haven't tried scribespells in quite a while. i accidentally cleared out my db *and* trashed my backups today so i figgured it'd be a good time to start from scratch....

Yep, compiled 'em myself - been doing that since we started with the 1129RevXXX. Haven't touched the source, so if the default is loading from spell file, it's loading from the spell file. Using the spell file from the SoF Client on both the server and the client. (what's the change to pull from the database? i can try that and re-compile)

nope - just copy - pasted the spells file from the sof folder to the server.

Nope - i'll give it a shot and post back.

i'm running the R649 binaries i pulled today, everything else appears to work....

Same thing happens in Titanium

i did a #findspell and received the message 'spells not loaded'



an aside....
/camp seems to disconnect immediately on R649

i attempted to sell a bone chip to the necro spell vendor in gloomingdeep, and 'seemed to have misplaced that item'. all npcs became untargetable....

Yeah I see the same problem also, I know it worked it rev 632 but it does not work now. I really dont have time to look deeper at this but just wanted to confirm it.

Go Cheese Heads!

Thanks leslamarch .... at least I'm not crazy =)

lol not a good year to be a packer fan :(

*edited* I'll post the results of my last test.

I had to use $ulevel to get it to work,, if this is what i think you are discussing

To change your source to use the spells_new table instead of the spell files, just do the following:

Open /zone/spdat.h

Find this section near the top of the file around line 42:
And change it to this:
And then save the changes and recompile your source. That is all there is to it. All you are doing is commenting out the define to use the old spell file way and uncommenting out the define to use the new table way of loading spells instead.

nosfentora,

It sounds like your spells aren't being loaded at all by the server. Was it previously working with the SoF spells_us.txt file, or is this the first time you tried the SoF spell file. Can you try the Titanium spell file and see if it works? I know that the SoF spells work if you load them into the database, because of how the table is handled. But, since Titanium and SoF both have different number of fields in them, it might just be that the server doesn't know how to handle the extra fields in the SoF spell file. The database table is setup with all of the fields up to Live I believe, and is able to handle them all, so it works with either Titanium or SoF spell files if you import them in. PEQ should come with the Titanium spell file already loaded into the spells_new table, so if you enable it in the source, they should work automatically. But, if you are wanting to use the SoF spell file as your default spell file, you will need to use the import perl scripts to import the spells_us.txt from SoF into your spells_new table.


arcerean,

I believe they are referring to the #scribespells command, which does take a level argument. You are referring to the quest command quest::scribespells($level), which was changed a long time ago.

Are you on a GM character when you /camp? It will automatically disconnect.

yep - that'll do it.


I'm trying the titanium spell files first - we'll see what happens. I'll try with Titanium client and SoF client.

Edit: I tried w/ the titanium spell set and the same thing on #findspell - spells not loaded.
Trying to compile w/ loading spells from db.

I just pulled rev654 and looked at spdat.h, it was already:

i never looked at it before so i don't know when it was changed.

i'll compile and see what happens. my spells_new table in the db is full. (14257 spells it looks like)

It seems my server is not loading the spells from the db for some reason.

the spells_new table is there with 14,257 entries.

spdat.h is set to load from the db

the zone logs say they've loaded spells, don't seem to be any errors
zone log:
zone debug log

recompiled rev654 with
and spells now work.

spells can be scribed and casted in both titanium and sof, however constantly getting 'you cannot see your target' messages. using rev28 of the maps

Not all SoF zones have .map files for them. You will need to verify the zone you are trying in has a .map file already. Otherwise, you won't be able to use that zone as a hunting zone, since players can't cast spells on others.

yea, but Tox? (should have specified)

Beh, edit:

maps were in eqemu\maps\maps, and the config file was maps\maps - was working before. moved them to eqemu\maps, changed the config and it works fine now.

any thoughts on the db spells table problem?
using both titanium and sof clients, with both titanium and sof spell sets, using only the spell files everything works.

compiling the server to load from the db, doesn't.

If there is an issue with your spells_new table, that can cause spells to not be able to load from the database. I recently saw this when I was editing the table using a webtool that I have for managing databases. The exact problem I had was that the tool had saved the spells I edited, but it put NULL entries into fields that were left blank and that do not allow NULL values. So, when it tried to load the spells, it failed because a couple of the spells were messed up in the database.

If you can figure out how to do it, I would highly recommend that you use the import and export perl scripts for managing your spells_new table. Some info on how to use them can be found in this thread:

http://www.eqemulator.net/forums/sho...t=24193&page=3

Specifically post 45 in that thread explains how to use the import and export scripts fairly well.

And yeah, the old Tox has a .map file and should work fine, but if you are using SoF, there is a new Tox and that version does not have a .map file for it yet. It is unfortunate too, because the new Tox is pretty awesome IMO. Most of the amazing new outdoor zones that come with SoF are missing their .map files, but hopefully at some point Azone2 will be updated to be able to handle the new zone file types for those files, because many of the missing zones are the best ones that were added!

Thanks Trevius,

i was using whatever default table came with PEQ and hadn't made any changes with it. I'll try and import the sof spells and see what happens.

i zoned into tox w/ sof (#zone tox - unless that one takes you to the old tox) and spells worked fine. it was populated so maybe it was the old one.

thanks again!