Author Topic: Database questions  (Read 4809 times)

0 Members and 1 Guest are viewing this topic.

Offline dagorhir

  • Senior Adept
  • **
  • Posts: 571
  • OIC Points +0/-0
Database questions
« on: July 11, 2013, 04:42:11 PM »
Which database file actually fills the attack drop down in the defenses tab?

Also, here's a topic for asking questions about the database which aren't issues.


Offline DavidKlecker

  • Senior Adept
  • **
  • Posts: 697
  • OIC Points +0/-0
  • Everything is coming up Milhouse!
Re: Database questions
« Reply #1 on: July 11, 2013, 09:23:37 PM »
I believe that is coming from the CombatFromCoreRules.xml file which is appended to by the CombatFromMartialLaw.xml file if you have that. It is populated with the node <Weapon>

Offline dagorhir

  • Senior Adept
  • **
  • Posts: 571
  • OIC Points +0/-0
Re: Database questions
« Reply #2 on: July 12, 2013, 02:38:52 PM »
Thanks

Am I correct to assume that the tag <WeaponCategoryName> will link to the skill associated to the weapon?

Also, how many characters can the attack dropdown can display?

Offline DavidKlecker

  • Senior Adept
  • **
  • Posts: 697
  • OIC Points +0/-0
  • Everything is coming up Milhouse!
Re: Database questions
« Reply #3 on: July 13, 2013, 04:50:32 PM »
Yes, that's the intent however I don't believe that I actually use that node right now. I believe I was just being thorough since I figured why not just define the category in case I need it later.

Offline dagorhir

  • Senior Adept
  • **
  • Posts: 571
  • OIC Points +0/-0
Re: Database questions
« Reply #4 on: July 14, 2013, 08:27:47 AM »
ok, if it's implemented right I won't bother with it for now. The way I use the weapon skills doesn't associated a specific weapon to a specific skill. It depends on the size of the character and the size of the weapon.

For instance, a broadsword, a medium size weapon, will be used as a Great Blades for small characters, Long Blades for medium characters and Short Blades for large characters. One weapon, three skills.

Once the weapon+skill is implemented in Autoharp, I will have to figure out a way to get that into the database.

Offline dagorhir

  • Senior Adept
  • **
  • Posts: 571
  • OIC Points +0/-0
Re: Database questions
« Reply #5 on: July 15, 2013, 12:59:56 PM »
Is the <StartingMoney> node used in AutoHarp or is this for future implementation?

Offline DavidKlecker

  • Senior Adept
  • **
  • Posts: 697
  • OIC Points +0/-0
  • Everything is coming up Milhouse!
Re: Database questions
« Reply #6 on: July 16, 2013, 05:49:42 AM »
<StartingMoney> from the preferences file has always been implemented however I have now added <StartingMoney> to the database itself since Martial Law was implement as a new feature for the Social classes.

Offline dagorhir

  • Senior Adept
  • **
  • Posts: 571
  • OIC Points +0/-0
Re: Database questions
« Reply #7 on: July 16, 2013, 06:34:38 AM »
How do I get it to use the <StaringMoney> from Martial Law?

Offline DavidKlecker

  • Senior Adept
  • **
  • Posts: 697
  • OIC Points +0/-0
  • Everything is coming up Milhouse!
Re: Database questions
« Reply #8 on: July 16, 2013, 08:33:53 AM »
If Martial Law is installed, you need to enable the ItemsFromMartialLaw.xml as using baseRules=true. You can do this from the AttachBooks (or Manage Books) menu option under tools. Drill into the Martial Law section and look for the Items row. I'm thinking baseRules set to false right now for you. Set it to true. I believe I have made this automatic right now (updated when version 1.0.3 comes out) as I agree, this is too obscure for most to figure out. I'll check to make sure I have it setup as automatic.

What this does is makes all the base rules in that particular xml as default. If you create a custom xml with your own rules for StartingMoney and Money, if you set that file up as baseRules=true, then those rules will be the default. It sounds like I need to start working on a video tutorial that can help people understand all this as I agree, it's rather obscure.

Offline dagorhir

  • Senior Adept
  • **
  • Posts: 571
  • OIC Points +0/-0
Re: Database questions
« Reply #9 on: July 16, 2013, 08:59:38 AM »
I'm currently setup as having my custom items database defined as base rules. The items database for Harp Fantasy and Martial Law are unchecked. I have copied all the nodes from Martial Law into my database and changed the values to match to coins I use. I still get the value that is found in the preferences, and that also rounds up the value. I currently have 2.5 silver in the preferences and I get 3 silvers in the character instead of 2 silver and 1 half-penny (0.5 silver). The modify coins button works perfectly though.

My custom items database is setup like this:
Code: [Select]
<Money use="true">
<MoneyName Multiply="0" IntoCoin="Gold">Gold</MoneyName>
<MoneyName Multiply="24" IntoCoin="Silver">Silver</MoneyName>
<MoneyName Multiply="2" IntoCoin="Half-Penny">Half-Penny</MoneyName>
<MoneyName Multiply="2" IntoCoin="Farthing">Farthing</MoneyName>
</Money>

<StartingMoney defaultCoin="Silver" defaultValue="15">
<SocialClass name="Destitute" coin="Silver">1D10*.25</SocialClass>
<SocialClass name="Poor" coin="Silver">1D10*2.5</SocialClass>
<SocialClass name="Lower Class" coin="Silver">1D100*2.5+125</SocialClass>
<SocialClass name="Middle Class" coin="Silver">1D100*2.5+375</SocialClass>
<SocialClass name="Upper Class" coin="Silver">2D1000*2.5+2500</SocialClass>
</StartingMoney>


Because I have significant differences from the standard Harp, I generally can't used the databases as is. My custom database completely supersedes all of the standard databases, so I copy what ever is new into my custom database.

Offline DavidKlecker

  • Senior Adept
  • **
  • Posts: 697
  • OIC Points +0/-0
  • Everything is coming up Milhouse!
Re: Database questions
« Reply #10 on: July 16, 2013, 11:32:57 AM »
I can look into the application and make sure this working right. Also, I was writing up how this worked, and realized that there is an inconsistency. Buying items which have a decimal point work according to the decimal, but they don't seem to work with the starting money in the same way, which I agree, I think they should be consistent. It is setup here to round the value.

Offline dagorhir

  • Senior Adept
  • **
  • Posts: 571
  • OIC Points +0/-0
Re: Database questions
« Reply #11 on: July 16, 2013, 11:40:36 AM »
I did further testing and it takes the value from the preferences.

Is it suppose to give a random value for the starting? And what would be the appropriate syntax for the formula in the social class?

Offline DavidKlecker

  • Senior Adept
  • **
  • Posts: 697
  • OIC Points +0/-0
  • Everything is coming up Milhouse!
Re: Database questions
« Reply #12 on: July 16, 2013, 12:51:23 PM »
Actually could you put into a code block here your config.xml file? I can certainly see if there is anything wrong in there. As per the random value for the starting, if it is getting it from the preferences file then the value will read something like 1D10 or something similar. As far as I remember I did not put a random value into the preferences file, just the ItemsFromMartialLaw.xml

I'm sorry you are running into issues on this. This weeks sounds like a good week to get an update started.

Offline dagorhir

  • Senior Adept
  • **
  • Posts: 571
  • OIC Points +0/-0
Re: Database questions
« Reply #13 on: July 16, 2013, 01:26:56 PM »
Those are very minor issues. AutoHarp works for me as I have work-arounds for about every issue.
Code: [Select]
<?xml version="1.1" encoding="UTF-8"?>
<Config>
  <Database>Harp Fantasy</Database>
  <Book name="Martial Law" use="true">
    <File name="Talents" Information="Collective" use="true" baseRules="false">
      <DatabaseLocation>Martial Law/TalentsFromMartialLaw.xml</DatabaseLocation>
    </File>
    <File name="Statistics" Information="Single" use="true" baseRules="false">
      <DatabaseLocation>Martial Law/StatisticsFromMartialLaw.xml</DatabaseLocation>
    </File>
    <File name="SpellList" Information="Collective" use="false" baseRules="false">
      <SpellLocation>Martial Law/SpellsFromMartialLaw.xml</SpellLocation>
      <DatabaseLocation>Martial Law/SpellListFromMartialLaw.xml</DatabaseLocation>
    </File>
    <File name="Skills" Information="Collective" use="false" baseRules="false">
      <DatabaseLocation>Martial Law/SkillsFromMartialLaw.xml</DatabaseLocation>
    </File>
    <File name="Races" Information="Collective" use="false" baseRules="false">
      <DatabaseLocation>Martial Law/RacesFromMartialLaw.xml</DatabaseLocation>
    </File>
    <File name="Professions" Information="Collective" use="false" baseRules="false">
      <DatabaseLocation>Martial Law/ProfessionsFromMartialLaw.xml</DatabaseLocation>
    </File>
    <File name="MonsterTables" Information="Single" use="true" baseRules="false">
      <DatabaseLocation>Martial Law/MonsterTablesFromMartialLaw.xml</DatabaseLocation>
    </File>
    <File name="Maneuver" Information="Single" use="true" baseRules="false">
      <DatabaseLocation>Martial Law/ManeuverFromMartialLaw.xml</DatabaseLocation>
    </File>
    <File name="MagicItems" Information="Single" use="true" baseRules="false">
      <DatabaseLocation>Martial Law/MagicItemsFromMartialLaw.xml</DatabaseLocation>
    </File>
    <File name="Items" Information="Collective" use="false" baseRules="false">
      <DatabaseLocation>Martial Law/ItemsFromMartialLaw.xml</DatabaseLocation>
    </File>
    <File name="HerbsAndPoisons" Information="Single" use="false" baseRules="false">
      <DatabaseLocation>Martial Law/HerbsAndPoisonsFromMartialLaw.xml</DatabaseLocation>
    </File>
    <File name="Encounters" Information="Single" use="true" baseRules="false">
      <DatabaseLocation>Martial Law/EncountersFromMartialLaw.xml</DatabaseLocation>
    </File>
    <File name="Defenses" Information="Single" use="false" baseRules="false">
      <DatabaseLocation>Martial Law/DefensesFromMartialLaw.xml</DatabaseLocation>
    </File>
    <File name="Cultures" Information="Collective" use="false" baseRules="false">
      <DatabaseLocation>Martial Law/CulturesFromMartialLaw.xml</DatabaseLocation>
    </File>
    <File name="Combat" Information="Collective" use="false" baseRules="false">
      <CombatName>Martial Law Rules</CombatName>
      <DatabaseLocation>Martial Law/CombatFromMartialLaw.xml</DatabaseLocation>
    </File>
  </Book>
  <Book name="Harp Fantasy" use="true">
    <File name="MagicItems" Information="Collective" use="true" baseRules="true">
      <DatabaseLocation>Harp Fantasy/MagicItemsFromCoreRules.xml</DatabaseLocation>
    </File>
    <File name="Maneuver" Information="Single" use="true" baseRules="true">
      <DatabaseLocation>Harp Fantasy/ManeuverFromCoreRules.xml</DatabaseLocation>
    </File>
    <File name="MonsterTables" Information="Collective" use="true" baseRules="true">
      <DatabaseLocation>Harp Fantasy/MonsterTablesFromCoreRules.xml</DatabaseLocation>
    </File>
    <File name="Statistics" Information="Single" use="true" baseRules="true">
      <DatabaseLocation>Harp Fantasy/StatisticsFromCoreRules.xml</DatabaseLocation>
    </File>
    <File name="Combat" Information="Collective" use="false" baseRules="true">
      <DatabaseLocation>Harp Fantasy/CombatFromCoreRules.xml</DatabaseLocation>
      <CombatName>Core Combat Rules</CombatName>
    </File>
    <File name="Cultures" Information="Collective" use="false" baseRules="true">
      <DatabaseLocation>Harp Fantasy/CulturesFromCoreRules.xml</DatabaseLocation>
    </File>
    <File name="Defenses" Information="Single" use="false" baseRules="true">
      <DatabaseLocation>Harp Fantasy/DefensesFromCoreRules.xml</DatabaseLocation>
    </File>
    <File name="Encounters" Information="Collective" use="false" baseRules="true">
      <DatabaseLocation>Harp Fantasy/EncountersFromCoreRules.xml</DatabaseLocation>
    </File>
    <File name="HerbsAndPoisons" Information="Collective" use="false" baseRules="true">
      <DatabaseLocation>Harp Fantasy/HerbsAndPoisonsFromCoreRules.xml</DatabaseLocation>
    </File>
    <File name="Items" Information="Collective" use="false" baseRules="true">
      <DatabaseLocation>Harp Fantasy/ItemsFromCoreRules.xml</DatabaseLocation>
    </File>
    <File name="Professions" Information="Collective" use="false" baseRules="true">
      <DatabaseLocation>Harp Fantasy/ProfessionsFromCoreRules.xml</DatabaseLocation>
    </File>
    <File name="Races" Information="Collective" use="false" baseRules="true">
      <DatabaseLocation>Harp Fantasy/RacesFromCoreRules.xml</DatabaseLocation>
    </File>
    <File name="Skills" Information="Collective" use="false" baseRules="true">
      <DatabaseLocation>Harp Fantasy/SkillsFromCoreRules.xml</DatabaseLocation>
    </File>
    <File name="SpellList" Information="Collective" use="false" baseRules="true">
      <DatabaseLocation>Harp Fantasy/SpellListFromCoreRules.xml</DatabaseLocation>
      <SpellLocation>Harp Fantasy/SpellsFromCoreRules.xml</SpellLocation>
    </File>
    <File name="Talents" Information="Collective" use="false" baseRules="true">
      <DatabaseLocation>Harp Fantasy/TalentsFromCoreRules.xml</DatabaseLocation>
    </File>
  </Book>
  <Book name="Astoria" use="true">
    <File name="Combat" Information="Collective" use="true" baseRules="true">
      <DatabaseLocation>Astoria/CombatFromAstoria.xml</DatabaseLocation>
      <CombatName>Astoria Combat Rules</CombatName>
    </File>
    <File name="Cultures" Information="Collective" use="true" baseRules="true">
      <DatabaseLocation>Astoria/CulturesFromAstoria.xml</DatabaseLocation>
    </File>
    <File name="Defenses" Information="Single" use="true" baseRules="true">
      <DatabaseLocation>Astoria/DefensesFromAstoria.xml</DatabaseLocation>
    </File>
    <File name="Encounters" Information="Collective" use="true" baseRules="true">
      <DatabaseLocation>Astoria/EncountersFromAstoria.xml</DatabaseLocation>
    </File>
    <File name="HerbsAndPoisons" Information="Collective" use="true" baseRules="true">
      <DatabaseLocation>Astoria/HerbsAndPoisonsFromAstoria.xml</DatabaseLocation>
    </File>
    <File name="Items" Information="Collective" use="true" baseRules="true">
      <DatabaseLocation>Astoria/ItemsFromAstoria.xml</DatabaseLocation>
    </File>
    <File name="Professions" Information="Collective" use="true" baseRules="true">
      <DatabaseLocation>Astoria/ProfessionsFromAstoria.xml</DatabaseLocation>
    </File>
    <File name="Races" Information="Collective" use="true" baseRules="true">
      <DatabaseLocation>Astoria/RacesFromAstoria.xml</DatabaseLocation>
    </File>
    <File name="Skills" Information="Collective" use="true" baseRules="true">
      <DatabaseLocation>Astoria/SkillsFromAstoria.xml</DatabaseLocation>
    </File>
    <File name="SpellList" Information="Collective" use="true" baseRules="true">
      <DatabaseLocation>Astoria/SpellListFromAstoria.xml</DatabaseLocation>
      <SpellLocation>Harp Fantasy/SpellsFromCoreRules.xml</SpellLocation>
    </File>
    <File name="Talents" Information="Collective" use="true" baseRules="true">
      <DatabaseLocation>Astoria/TalentsFromAstoria.xml</DatabaseLocation>
    </File>
    <File name="MagicItems" Information="Collective" use="false" baseRules="true">
      <DatabaseLocation>Astoria/MagicItemsFromAstoria.xml</DatabaseLocation>
    </File>
    <File name="Maneuver" Information="Single" use="false" baseRules="true">
      <DatabaseLocation>Astoria/ManeuverFromAstoria.xml</DatabaseLocation>
    </File>
    <File name="MonsterTables" Information="Collective" use="false" baseRules="true">
      <DatabaseLocation>Astoria/MonsterTablesFromAstoria.xml</DatabaseLocation>
    </File>
    <File name="Statistics" Information="Single" use="false" baseRules="true">
      <DatabaseLocation>Astoria/StatisticsFromAstoria.xml</DatabaseLocation>
    </File>
  </Book>
</Config>

Offline DavidKlecker

  • Senior Adept
  • **
  • Posts: 697
  • OIC Points +0/-0
  • Everything is coming up Milhouse!
Re: Database questions
« Reply #14 on: July 16, 2013, 02:16:51 PM »
<File name="Items" Information="Collective" use="false" baseRules="true">
      <DatabaseLocation>Harp Fantasy/ItemsFromCoreRules.xml</DatabaseLocation>
</File>
You still have Harp Fantasy set to use baseRules as true however the use is set to false. Try setting the baseRules to false to see if it works. It shouldn't as i think i check first to see if it is used however I could bypass the use attribute and just check for the baseRules.

Offline dagorhir

  • Senior Adept
  • **
  • Posts: 571
  • OIC Points +0/-0
Re: Database questions
« Reply #15 on: July 16, 2013, 02:38:00 PM »
<File name="Items" Information="Collective" use="false" baseRules="true">
      <DatabaseLocation>Harp Fantasy/ItemsFromCoreRules.xml</DatabaseLocation>
</File>
You still have Harp Fantasy set to use baseRules as true however the use is set to false. Try setting the baseRules to false to see if it works. It shouldn't as i think i check first to see if it is used however I could bypass the use attribute and just check for the baseRules.

I set all the use baseRules to false for databases that are not used. It still used the value from the preferences.

Offline DavidKlecker

  • Senior Adept
  • **
  • Posts: 697
  • OIC Points +0/-0
  • Everything is coming up Milhouse!
Re: Database questions
« Reply #16 on: July 16, 2013, 07:03:59 PM »
rats.  :( It must never bring that item back for reasons.

Offline dagorhir

  • Senior Adept
  • **
  • Posts: 571
  • OIC Points +0/-0
Re: Database questions
« Reply #17 on: July 17, 2013, 01:33:12 PM »
How is the <SocialClass> tag link to the Social Class talents? Shouldn't the name's match? And which social class is used if no talent is selected?

Code: [Select]
<StartingMoney defaultCoin="Silver" defaultValue="15">
<SocialClass name="Destitute" coin="Silver">31.25</SocialClass>
<SocialClass name="Poor" coin="Silver">62.5</SocialClass>
<SocialClass name="Lower Class" coin="Silver">125</SocialClass>
<SocialClass name="Middle Class" coin="Silver">375</SocialClass>
<SocialClass name="Upper Class" coin="Silver">2500</SocialClass>
</StartingMoney>

Code: [Select]
    <Talent name="Social Class: Lower Class">
        <Name>Social Class: Lower Class</Name>
        <Cost>5</Cost>
        <Description>Character is part of the lower class of society. Determines starting coin value. </Description>
    </Talent>
    <Talent name="Social Class: Middle Class">
        <Name>Social Class: Middle Class</Name>
        <Cost>10</Cost>
        <Description>Character is part of the middle class of society. Determines starting money. </Description>
    </Talent>
    <Talent name="Social Class: Upper Class">
        <Name>Social Class: Upper Class</Name>
        <Cost>20</Cost>
        <Description>Same as the talent Nobility. The character is a member of the nobility, or ruling class of his culture. He may have been awarded nobility, or been born into it. The Player and the Gamemaster should determine the characters title and the extent of his powers and rights as a nobleman.</Description>
    </Talent>

Offline DavidKlecker

  • Senior Adept
  • **
  • Posts: 697
  • OIC Points +0/-0
  • Everything is coming up Milhouse!
Re: Database questions
« Reply #18 on: July 18, 2013, 08:35:22 AM »
I didn't want to automatically have the talents be used since this was not a rule from the book. It was a rule I made up on the fly because I felt it was better to have talents for something that gave you more money. The Nobility talent I don't believe ever gave the character more money or at least this was not in the description of the talent, but could certainly have been implied. I didn't want to force my rule on anyone. Thus, there is no link between these two nodes. Manually setting the talent is as designed.

Offline dagorhir

  • Senior Adept
  • **
  • Posts: 571
  • OIC Points +0/-0
Re: Database questions
« Reply #19 on: July 18, 2013, 09:03:17 AM »
Ok, that's good for me.

In my setting there's only three levels of social class: Slave/Thrall/Serf, Small Folk, and Nobility. All characters are considered Small Folk unless they take the Nobility status talent, which does increase starting money. I have another custom status talent which is Knighthood. This will only increase starting money if the character doesn't also have Nobility. Knighthood has some limitations to it related to religion and by consequence race.

My plan was to use the Modify Coins button to add any extra money from die rolls.