Tradeskill Recipe BOM as of 7.2.5.24461

tradeskills.csv

tradeskills.php

<?php

// quick hack of a script to get tradeskill spells and reagents
// uses github.com/erorus/db2

require_once __DIR__ . '/src/autoload.php';

use \Erorus\DB2\Reader;

$skillLookup = [];
$skillIDs      = [164,165,171,182,185,186,197,202,333,356,393,413,755,773,794,975,976,977,978,979,980,981,982];

$skillLineAbilityReader = new Reader (__DIR__ . '/DBFilesClient/SkillLineAbility.db2');
$skillLineAbilityReader->setFieldNames([
    0 => "spellid",
    3 => "lineid",
]);
foreach ($skillLineAbilityReader->generateRecords() as $record) {
    if (in_array($record['lineid'], $skillIDs)) {
        $skillLookup[$record['spellid']] = $record['lineid'];
    }
}
unset($skillLineAbilityReader);

$lineNames = [];
$skillLineReader = new Reader(__DIR__ . '/DBFilesClient/SkillLine.db2');
foreach ($skillLineReader->generateRecords() as $id => $record) {
    if (in_array($id, $skillIDs)) {
        $lineNames[$id] = $record[0];
    }
}
unset($skillLineReader);

$reagentLookup = [];
$reagentReader = new Reader(__DIR__ . '/DBFilesClient/SpellReagents.db2');
$reagentReader->setFieldNames(['spell', 'items', 'quantities']);
foreach ($reagentReader->generateRecords() as $record) {
    if (isset($skillLookup[$record['spell']])) {
        $reagentLookup[$record['spell']] = [$record['items'], $record['quantities']];
    }
}
unset($reagentReader);

$spellEffectReader = new Reader(__DIR__ . '/DBFilesClient/SpellEffect.db2');
$spellEffectReader->setFieldNames([
    2 => "spellid",
    3 => "effecttypeid",
    5 => "qtymade",
    6 => "effectorder",
    16 => "diesides",
    17 => "itemcreated"
]);

$row = ['Profession', 'Spell ID', 'Min Quantity', 'Max Quantity', 'Created Item ID'];
for ($x = 1; $x <= 8; $x++) {
    $row[] = sprintf('Reagent %d Qty', $x);
    $row[] = sprintf('Reagent %d Item ID', $x);
}
fputcsv(STDOUT, $row);

foreach ($spellEffectReader->generateRecords() as $id => $record) {
    if (!$record['itemcreated']) {
        continue;
    }
    if (!isset($skillLookup[$record['spellid']])) {
        continue;
    }

    if ($record['qtymade'] == 0 && $record['diesides'] == 0) {
        $record['qtymade'] = 1;
    }

    $min = $record['qtymade'] + ($record['diesides'] ? 1 : 0);
    $max = $record['qtymade'] + $record['diesides'];

    switch ($record['effecttypeid']) {
        case 24:  // create item
        case 53:  // enchant
        case 59:  // create & fast loot
        case 157: // create tradeskill item
            $row = [
                $lineNames[$skillLookup[$record['spellid']]],
                $record['spellid'],
                $min,
                $max,
                $record['itemcreated']
            ];

            if (isset($reagentLookup[$record['spellid']])) {
                foreach ($reagentLookup[$record['spellid']][0] as $x => $itm) {
                    if ($itm) {
                        $row[] = $reagentLookup[$record['spellid']][1][$x];
                        $row[] = $itm;
                    }
                }
            }

            while (count($row) < 21) {
                $row[] = '';
            }
            fputcsv(STDOUT, $row);
            break;
    }
}