protected function generateContent()
{
$classes = new CharClassList();
if (!$classes->error) {
$this->lvTabs[] = ['class', ['data' => array_values($classes->getListviewData())]];
}
}
protected function generateContent()
{
$classes = new CharClassList();
if (!$classes->error) {
$this->lvTabs[] = array('file' => 'class', 'data' => $classes->getListviewData(), 'params' => []);
}
}
private function _searchCharClass($cndBase)
{
$result = [];
$cnd = array_merge($cndBase, [$this->createLookup()]);
$classes = new CharClassList($cnd);
if ($data = $classes->getListviewData()) {
if ($this->searchMask & SEARCH_TYPE_OPEN) {
foreach ($classes->iterate() as $__) {
$data[$classes->id]['param1'] = 'class_' . strToLower($classes->getField('fileString'));
}
}
$result = array('type' => TYPE_CLASS, 'appendix' => ' (Class)', 'matches' => $classes->getMatches(), 'file' => CharClassList::$brickFile, 'data' => $data, 'params' => []);
if ($classes->getMatches() > $this->maxResults) {
// $result['params']['note'] = sprintf(Util::$tryNarrowingString, 'LANG.lvnote_', $classes->getMatches(), $this->maxResults);
$result['params']['_truncated'] = 1;
}
}
return $result;
}
public function __construct()
{
$classes = new CharClassList();
foreach ($classes->iterate() as $cId => $_tpl) {
// preselect misc subclasses
$this->ubFilter[$cId] = [ITEM_CLASS_WEAPON => [14], ITEM_CLASS_ARMOR => [0]];
for ($i = 0; $i < 21; $i++) {
if ($_tpl['weaponTypeMask'] & 1 << $i) {
$this->ubFilter[$cId][ITEM_CLASS_WEAPON][] = $i;
}
}
for ($i = 0; $i < 11; $i++) {
if ($_tpl['armorTypeMask'] & 1 << $i) {
$this->ubFilter[$cId][ITEM_CLASS_ARMOR][] = $i;
}
}
}
parent::__construct();
}
protected function generateContent()
{
/****************/
/* Main Content */
/****************/
$this->headIcons = [$this->subject->getField('iconString')];
$this->redButtons = array(BUTTON_WOWHEAD => true, BUTTON_LINKS => true);
if ($_ = $this->subject->getField('description', true)) {
$this->extraText = $_;
}
/**************/
/* Extra Tabs */
/**************/
if (in_array($this->cat, [-5, 9, 11])) {
// tab: recipes [spells] (crafted)
$condition = array(['OR', ['s.reagent1', 0, '>'], ['s.reagent2', 0, '>'], ['s.reagent3', 0, '>'], ['s.reagent4', 0, '>'], ['s.reagent5', 0, '>'], ['s.reagent6', 0, '>'], ['s.reagent7', 0, '>'], ['s.reagent8', 0, '>']], ['OR', ['s.skillLine1', $this->typeId], ['AND', ['s.skillLine1', 0, '>'], ['s.skillLine2OrMask', $this->typeId]]], CFG_SQL_LIMIT_NONE);
$recipes = new SpellList($condition);
// also relevant for 3
if (!$recipes->error) {
$this->extendGlobalData($recipes->getJSGlobals(GLOBALINFO_SELF | GLOBALINFO_RELATED));
$this->lvTabs[] = array('file' => 'spell', 'data' => $recipes->getListviewData(), 'params' => array('id' => 'recipes', 'name' => '$LANG.tab_recipes', 'visibleCols' => "\$['reagents', 'source']", 'note' => sprintf(Util::$filterResultString, '?spells=' . $this->cat . '.' . $this->typeId . '&filter=cr=20;crs=1;crv=0')));
}
// tab: recipe Items [items] (Books)
$filterRecipe = [null, 165, 197, 202, 164, 185, 171, 129, 333, 356, 755, 773, 186, 182];
$conditions = array(['requiredSkill', $this->typeId], ['class', ITEM_CLASS_RECIPE], CFG_SQL_LIMIT_NONE);
$recipeItems = new ItemList($conditions);
if (!$recipeItems->error) {
$this->extendGlobalData($recipeItems->getJSGlobals(GLOBALINFO_SELF));
if ($_ = array_search($this->typeId, $filterRecipe)) {
$_ = sprintf(Util::$filterResultString, "?items=9." . $_);
}
$this->lvTabs[] = array('file' => 'item', 'data' => $recipeItems->getListviewData(), 'params' => array('id' => 'recipe-items', 'name' => '$LANG.tab_recipeitems', 'note' => $_));
}
// tab: crafted items [items]
$filterItem = [null, 171, 164, 185, 333, 202, 129, 755, 165, 186, 197, null, null, 356, 182, 773];
$created = [];
foreach ($recipes->iterate() as $__) {
if ($idx = $recipes->canCreateItem()) {
foreach ($idx as $i) {
$created[] = $recipes->getField('effect' . $i . 'CreateItemId');
}
}
}
if ($created) {
$created = new ItemList(array(['i.id', $created], CFG_SQL_LIMIT_NONE));
if (!$created->error) {
$this->extendGlobalData($created->getJSGlobals(GLOBALINFO_SELF));
if ($_ = array_search($this->typeId, $filterItem)) {
$_ = sprintf(Util::$filterResultString, "?items&filter=cr=86;crs=" . $_ . ";crv=0");
}
$this->lvTabs[] = array('file' => 'item', 'data' => $created->getListviewData(), 'params' => array('id' => 'crafted-items', 'name' => '$LANG.tab_crafteditems', 'note' => $_));
}
}
// tab: required by [item]
$conditions = array(['requiredSkill', $this->typeId], ['class', ITEM_CLASS_RECIPE, '!'], CFG_SQL_LIMIT_NONE);
$reqBy = new ItemList($conditions);
if (!$reqBy->error) {
$this->extendGlobalData($reqBy->getJSGlobals(GLOBALINFO_SELF));
if ($_ = array_search($this->typeId, $filterItem)) {
$_ = sprintf(Util::$filterResultString, "?items&filter=cr=99:168;crs=" . $_ . ":2;crv=0:0");
}
$this->lvTabs[] = array('file' => 'item', 'data' => $reqBy->getListviewData(), 'params' => array('id' => 'required-by', 'name' => '$LANG.tab_requiredby', 'note' => $_));
}
// tab: required by [itemset]
$conditions = array(['skillId', $this->typeId], CFG_SQL_LIMIT_NONE);
$reqBy = new ItemsetList($conditions);
if (!$reqBy->error) {
$this->extendGlobalData($reqBy->getJSGlobals(GLOBALINFO_SELF));
$this->lvTabs[] = array('file' => 'itemset', 'data' => $reqBy->getListviewData(), 'params' => array('id' => 'required-by-set', 'name' => '$LANG.tab_requiredby'));
}
}
// tab: spells [spells] (exclude first tab)
$reqClass = 0x0;
$reqRace = 0x0;
$condition = array(['AND', ['s.reagent1', 0], ['s.reagent2', 0], ['s.reagent3', 0], ['s.reagent4', 0], ['s.reagent5', 0], ['s.reagent6', 0], ['s.reagent7', 0], ['s.reagent8', 0]], ['OR', ['s.skillLine1', $this->typeId], ['AND', ['s.skillLine1', 0, '>'], ['s.skillLine2OrMask', $this->typeId]]], CFG_SQL_LIMIT_NONE);
foreach (Util::$skillLineMask as $line1 => $sets) {
foreach ($sets as $idx => $set) {
if ($set[1] == $this->typeId) {
$condition[1][] = array('AND', ['s.skillLine1', $line1], ['s.skillLine2OrMask', 1 << $idx, '&']);
break 2;
}
}
}
$spells = new SpellList($condition);
if (!$spells->error) {
foreach ($spells->iterate() as $__) {
$reqClass |= $spells->getField('reqClassMask');
$reqRace |= $spells->getField('reqRaceMask');
}
$this->extendGlobalData($spells->getJSGlobals(GLOBALINFO_SELF));
$lv = array('file' => 'spell', 'data' => $spells->getListviewData(), 'params' => ['visibleCols' => "\$['source']"]);
switch ($this->cat) {
case -4:
$lv['params']['note'] = sprintf(Util::$filterResultString, '?spells=-4');
break;
case 7:
if ($this->typeId != 769) {
// Internal
$lv['params']['note'] = sprintf(Util::$filterResultString, '?spells=' . $this->cat . '.' . (log($reqClass, 2) + 1) . '.' . $this->typeId);
}
// doesn't matter what spell; reqClass should be identical for all Class Spells
break;
case 9:
case 11:
$lv['params']['note'] = sprintf(Util::$filterResultString, '?spells=' . $this->cat . '.' . $this->typeId);
break;
}
$this->lvTabs[] = $lv;
}
// tab: trainers [npcs]
if (in_array($this->cat, [-5, 6, 7, 8, 9, 11])) {
$list = [];
if (!empty(Util::$trainerTemplates[TYPE_SKILL][$this->typeId])) {
$list = DB::World()->selectCol('SELECT DISTINCT entry FROM npc_trainer WHERE spell IN (?a) AND entry < 200000', Util::$trainerTemplates[TYPE_SKILL][$this->typeId]);
} else {
$mask = 0;
foreach (Util::$skillLineMask[-3] as $idx => $pair) {
if ($pair[1] == $this->typeId) {
$mask |= 1 << $idx;
}
}
$spellIds = DB::Aowow()->selectCol('SELECT id FROM ?_spell WHERE typeCat IN (-11, 9) AND (skillLine1 = ?d OR (skillLine1 > 0 AND skillLine2OrMask = ?d) {OR (skillLine1 = -3 AND skillLine2OrMask = ?d)})', $this->typeId, $this->typeId, $mask ?: DBSIMPLE_SKIP);
$list = $spellIds ? DB::World()->selectCol('
SELECT IF(t1.entry > 200000, t2.entry, t1.entry)
FROM npc_trainer t1
LEFT JOIN npc_trainer t2 ON t2.spell = -t1.entry
WHERE t1.spell IN (?a)', $spellIds) : [];
}
if ($list) {
$this->addJS('?data=zones&locale=' . User::$localeId . '&t=' . $_SESSION['dataKey']);
$trainer = new CreatureList(array(CFG_SQL_LIMIT_NONE, ['ct.id', $list], ['s.guid', NULL, '!'], ['ct.npcflag', 0x10, '&']));
if (!$trainer->error) {
$this->extendGlobalData($trainer->getJSGlobals());
$this->lvTabs[] = array('file' => 'creature', 'data' => $trainer->getListviewData(), 'params' => array('id' => 'trainer', 'name' => '$LANG.tab_trainers'));
}
}
}
// tab: quests [quests]
if (in_array($this->cat, [9, 11])) {
$sort = 0;
switch ($this->typeId) {
case 182:
$sort = 24;
break;
// Herbalism
// Herbalism
case 356:
$sort = 101;
break;
// Fishing
// Fishing
case 164:
$sort = 121;
break;
// Blacksmithing
// Blacksmithing
case 171:
$sort = 181;
break;
// Alchemy
// Alchemy
case 165:
$sort = 182;
break;
// Leatherworking
// Leatherworking
case 202:
$sort = 201;
break;
// Engineering
// Engineering
case 197:
$sort = 264;
break;
// Tailoring
// Tailoring
case 185:
$sort = 304;
break;
// Cooking
// Cooking
case 129:
$sort = 324;
break;
// First Aid
// First Aid
case 773:
$sort = 371;
break;
// Inscription
// Inscription
case 755:
$sort = 373;
break;
// Jewelcrafting
}
if ($sort) {
$quests = new QuestList(array(['zoneOrSort', -$sort], CFG_SQL_LIMIT_NONE));
if (!$quests->error) {
$this->extendGlobalData($quests->getJSGlobals());
$this->lvTabs[] = array('file' => 'quest', 'data' => $quests->getListviewData(), 'params' => []);
}
}
}
// tab: related classes (apply classes from [spells])
$class = [];
for ($i = 0; $i < 11; $i++) {
if ($reqClass & 1 << $i) {
$class[] = $i + 1;
}
}
if ($class) {
$classes = new CharClassList(array(['id', $class]));
if (!$classes->error) {
$this->lvTabs[] = array('file' => 'class', 'data' => $classes->getListviewData(), 'params' => []);
}
}
// tab: related races (apply races from [spells])
$race = [];
for ($i = 0; $i < 12; $i++) {
if ($reqRace & 1 << $i) {
$race[] = $i + 1;
}
}
if ($race) {
$races = new CharRaceList(array(['id', $race]));
if (!$races->error) {
$this->lvTabs[] = array('file' => 'race', 'data' => $races->getListviewData(), 'params' => []);
}
}
}
private function _searchCharClass($cndBase)
{
$cnd = array_merge($cndBase, [$this->createLookup()]);
$classes = new CharClassList($cnd);
if ($data = $classes->getListviewData()) {
$result['data'] = array_values($data);
$osInfo = [TYPE_CLASS, ' (Class)', $classes->getMatches(), []];
if ($this->searchMask & SEARCH_TYPE_OPEN) {
foreach ($classes->iterate() as $id => $__) {
$osInfo[3][$id] = 'class_' . strToLower($classes->getField('fileString'));
}
}
if ($classes->getMatches() > $this->maxResults) {
// $result['note'] = sprintf(Util::$tryNarrowingString, 'LANG.lvnote_', $classes->getMatches(), $this->maxResults);
$result['_truncated'] = 1;
}
return ['class', $result, null, $osInfo];
}
return false;
}
protected function generateContent()
{
$infobox = [];
$_mask = 1 << $this->typeId - 1;
$mountVendors = array(null, [384, 33307], [3362, 33553], [1261, 33310], [4730, 33653], [4731, 33555], [3685, 33556], [7955, 33650], [7952, 33554], null, [16264, 33557], [17584, 33657]);
/***********/
/* Infobox */
/***********/
$infobox = Lang::getInfoBoxForFlags($this->subject->getField('cuFlags'));
// side
if ($_ = $this->subject->getField('side')) {
$infobox[] = Lang::main('side') . Lang::main('colon') . '[span class=icon-' . ($_ == 2 ? 'horde' : 'alliance') . ']' . Lang::game('si', $_) . '[/span]';
}
// faction
if ($_ = $this->subject->getField('factionId')) {
$fac = new FactionList(array(['f.id', $_]));
$this->extendGlobalData($fac->getJSGlobals());
$infobox[] = Util::ucFirst(Lang::game('faction')) . Lang::main('colon') . '[faction=' . $fac->id . ']';
}
// leader
if ($_ = $this->subject->getField('leader')) {
$this->extendGlobalIds(TYPE_NPC, $_);
$infobox[] = Lang::race('racialLeader') . Lang::main('colon') . '[npc=' . $_ . ']';
}
// start area
if ($_ = $this->subject->getField('startAreaId')) {
$this->extendGlobalIds(TYPE_ZONE, $_);
$infobox[] = Lang::race('startZone') . Lang::main('colon') . '[zone=' . $_ . ']';
}
/****************/
/* Main Content */
/****************/
$this->infobox = '[ul][li]' . implode('[/li][li]', $infobox) . '[/li][/ul]';
$this->expansion = Util::$expansionString[$this->subject->getField('expansion')];
$this->headIcons = array('race_' . strtolower($this->subject->getField('fileString')) . '_male', 'race_' . strtolower($this->subject->getField('fileString')) . '_female');
$this->redButtons = array(BUTTON_WOWHEAD => true, BUTTON_LINKS => true);
/**************/
/* Extra Tabs */
/**************/
// Classes
$classes = new CharClassList(array(['racemask', $_mask, '&']));
if (!$classes->error) {
$this->extendGlobalData($classes->getJSGlobals());
$this->lvTabs[] = ['class', ['data' => array_values($classes->getListviewData())]];
}
// Tongues
$conditions = array(['typeCat', -11], ['reqRaceMask', $_mask, '&']);
$tongues = new SpellList($conditions);
if (!$tongues->error) {
$this->extendGlobalData($tongues->getJSGlobals());
$this->lvTabs[] = ['spell', array('data' => array_values($tongues->getListviewData()), 'id' => 'languages', 'name' => '$LANG.tab_languages', 'hiddenCols' => ['reagents'])];
}
// Racials
$conditions = array(['typeCat', -4], ['reqRaceMask', $_mask, '&']);
$racials = new SpellList($conditions);
if (!$racials->error) {
$this->extendGlobalData($racials->getJSGlobals());
$this->lvTabs[] = ['spell', array('data' => array_values($racials->getListviewData()), 'id' => 'racial-traits', 'name' => '$LANG.tab_racialtraits', 'hiddenCols' => ['reagents'])];
}
// Quests
$conditions = array(['reqRaceMask', $_mask, '&'], [['reqRaceMask', RACE_MASK_HORDE, '&'], RACE_MASK_HORDE, '!'], [['reqRaceMask', RACE_MASK_ALLIANCE, '&'], RACE_MASK_ALLIANCE, '!']);
$quests = new QuestList($conditions);
if (!$quests->error) {
$this->extendGlobalData($quests->getJSGlobals());
$this->lvTabs[] = ['quest', ['data' => array_values($quests->getListviewData())]];
}
// Mounts
// ok, this sucks, but i rather hardcode the trainer, than fetch items by namepart
$items = isset($mountVendors[$this->typeId]) ? DB::World()->selectCol('SELECT item FROM npc_vendor WHERE entry IN (?a)', $mountVendors[$this->typeId]) : 0;
$conditions = array(['i.id', $items], ['i.class', ITEM_CLASS_MISC], ['i.subClass', 5]);
$mounts = new ItemList($conditions);
if (!$mounts->error) {
$this->extendGlobalData($mounts->getJSGlobals());
$this->lvTabs[] = ['item', array('data' => array_values($mounts->getListviewData()), 'id' => 'mounts', 'name' => '$LANG.tab_mounts', 'hiddenCols' => ['slot', 'type'])];
}
}