Creating a Spell Spreadsheet

Discussion in 'General Modification' started by Rudy, Feb 17, 2013.

Remove all ads!
  1. Shiningted

    Shiningted I changed this damn title, finally! Administrator

    Joined:
    Oct 23, 2004
    Messages:
    12,743
    Likes Received:
    374
    I never said we fixed everything.
     
  2. Daryk

    Daryk Veteran Member

    Joined:
    Jan 14, 2012
    Messages:
    1,177
    Likes Received:
    34
    Ah, sorry then. I took your statement as broader than intended.
     
  3. Rudy

    Rudy Established Member

    Joined:
    Jan 30, 2005
    Messages:
    345
    Likes Received:
    2
    So, none of this stuff was changed/fixed for 7.7.0, nor were spells, added, yes? Just checking that there's nothing to change about the spreadsheet.
     
  4. Gaear

    Gaear Bastard Maestro Administrator

    Joined:
    Apr 27, 2004
    Messages:
    11,038
    Likes Received:
    42
    That's correct.
     
  5. Shiningted

    Shiningted I changed this damn title, finally! Administrator

    Joined:
    Oct 23, 2004
    Messages:
    12,743
    Likes Received:
    374
    I didn't get the Domain stuff done in time for release, Rudy, (and haven't even started on the potions) but it sounds like there will have to be a patch for my botched WF Ray fix, so I'll try to slip some new spells in, and let you know what they are. If you could keep then update this, that'd be great.
     
  6. Rudy

    Rudy Established Member

    Joined:
    Jan 30, 2005
    Messages:
    345
    Likes Received:
    2
    Sure, no problem :) I'm also adding in item codes for arcane spell scrolls as I go into the spreadsheet, since I've found that useful in testing.
     
  7. Rudy

    Rudy Established Member

    Joined:
    Jan 30, 2005
    Messages:
    345
    Likes Received:
    2
    Attached is an updated version, with the item codes added for all arcane scrolls. The code for Owl's Wisdom is red because, for whatever reason, that item is created as a divine scroll by default, and so cannot be copied by a wizard.
     

    Attached Files:

  8. Gaear

    Gaear Bastard Maestro Administrator

    Joined:
    Apr 27, 2004
    Messages:
    11,038
    Likes Received:
    42
    Nice work, Rudy. Just a couple FYIs ...

    • Not sure if you already know this but you can look up chances of scrolls appearing in data/rules/invensource.mes. Each entity (NPC or chest, etc.) will have an entry there with a bunch of proto codes listed. The number that appears before any proto code is the percent chance that the game will generate it for that NPC/chest/shop. So 90,8007 means that there is a 90% chance that the game will generate a potion of cure moderate wounds (I think that's 8007) for that NPC/chest when its inventory is generated. This usually happens only once in the case of NPCs, but for merchants who must refresh their inventories, it happens each time that occurs. Thus Burne's assistant or whomever may have one scroll one day but not the next.
    • I see that the proto entry for the scroll of Owl's Wisdom lists the contained spell as cleric 2, unlike the other five 2nd level stat enhancing spells, two of which are bard 2 and three of which are sorcerer 2. I rather suspect that the game handles this mechanic internally, but we could try changing it to sorcerer 2 and see what happens.
     
  9. Rudy

    Rudy Established Member

    Joined:
    Jan 30, 2005
    Messages:
    345
    Likes Received:
    2
    I did not know that one the first point, but I'll use it to double check a few iffy things I noticed from the walkthrough thread information, as well as look at other vendors.

    On the second point, that would probably be worth trying. So far that's the only spell I've come across that has that issue for scribing.
     
Our Host!