User:Sten/Legacy to spreadsheet

This is a Python script to export a player's legacy into a spreadsheet.

Usage

Copy the code in the box below into a text file named legacy_table.py (or whatever you want) inside the Wildermyth/Players/<player ID> directory. Then run it by calling python legacy_table.py from the command line. It will create a text file called legacy_table.txt, which is tab-delimited and can be loaded by any spreadsheet software or viewed in a text editor.

legacy_table.py

import json
from zipfile import ZipFile
from glob import glob

mod_paths = ['../..'] + glob('../../mods/builtIn/*')

dictionary = {}
for m in mod_paths:
  try:
    with open(m + '/assets/text/aspects/aspects.properties','r',encoding='utf8') as f:
      lines = f.readlines()
      for line in lines:
        if line[0] == '#':
          continue
        try:
          key,val = line.split('=')
        except:
          continue
        try:
          key_split = key.split('.')
        except:
          continue
        if len(key_split) != 2 or key_split[-1] != 'name':
          continue
        dictionary[key_split[0]] = val[:-1]
  except:
    continue
  
def test_ability(string):
  if string in ['hunterGreenhorn_silkstep']:
    return False
  for prefix in ['mystic','hunter','warrior','common']:
    for suffix in ['Deck','Special','Greenhorn','Goldhorn']:
      if string.startswith(prefix+suffix):
        return True
  return False

snapshot = -1

with ZipFile('legacy.json.zip') as zf:
  with zf.open('legacy.json') as f:
    data = json.load(f)

names = []
tiers = []
classes = []
themes = []
playables = []
hooks = []
abilities = []
for entry in data['entries']:
  hook = 0
  themes_ = []
  abilities_ = []
  class_ = ''
  try:
    tier = int(entry['tier'])+1
  except:
    tier = 1
  try: 
    if entry['usage'] == 'background':
      playable = 'N'
    else:
      raise
  except:
    playable = 'Y'
  entities = entry['snapshots'][snapshot]['entities']
  for j in range(len(entities)):
    try:
      name = entities[j][6]['name']
    except:
      continue
    for entry_ in entities[j][6]['aspects']['entries']:
      if entry_[0] in ['hunter','warrior','mystic'] and entry_[1]['value'] == 1:
        class_ = entry_[0]
      elif entry_[0].startswith('themePiece_') and entry_[1]['value'] == 1:
        themes_ += [dictionary[entry_[0]]]
      elif entry_[0].startswith('hookResolved_retirementAgeBoost') and entry_[1]['value'] == 1:
        hook += 1
      elif test_ability(entry_[0]) and entry_[1]['value'] == 1:
        abilities_ += [dictionary[entry_[0]]]
  names += [name]
  tiers += [tier]
  classes += [class_]
  playables += [playable]
  themes += [themes_]
  abilities += [abilities_]
  hooks += [hook]

weapons = []
for entry in data['entries']:
  weapons_ = []
  entities = entry['snapshots'][snapshot]['entities']
  for j in range(len(entities)):
    try:
      if 'MAIN_HAND' in entities[j][6]['slots']:
        try:
          if entities[j][6]['artifact']:
            weapons_ += [entities[j][4]['name']]
          else:
            raise
        except:
          weapons_ += [entities[j][4]['localizableName'].split('.')[-1]]
    except:
      pass
  weapons += [weapons_]

offhands = []
for entry in data['entries']:
  offhand = ''
  entities = entry['snapshots'][snapshot]['entities']
  for j in range(len(entities)):
    try:
      if 'OFF_HAND' in entities[j][6]['slots'] and 'MAIN_HAND' not in entities[j][6]['slots']:
        offhand = entities[j][4]['name']
    except:
      pass
  offhands += [offhand]

with open('legacy_table.txt', 'w') as f:
  f.write('Name\tPlayable\tTier\tClass\tHooks\tThemes\tWeapons\tOffhand\tAbilities\n')
  for i,name in enumerate(names):
    f.write('%s\t%s\t%d\t%s\t%d\t'%(name,playables[i],tiers[i],classes[i],hooks[i]) + ', '.join(themes[i]) + '\t' + ', '.join(weapons[i]) + '\t' + offhands[i] + '\t' + ', '.join(abilities[i]) + '\n')

Output

This script does not make any changes to the legacy.

The following fields appear in the output table (legacy_table.txt):

• Name
• Playable (Y/N)
• Legacy tier
• Class
• Number of hooks resolved
• Themes
• Weapons
• Offhand item
• Abilities

Example

Example legacy export, viewed in Microsoft Excel