This is a Python script to export a player's legacy into a spreadsheet. You need a Python installation to run it.
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.
Expandlegacy_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