function realmMenu()
{
$subEU = [];
$subUS = [];
$set = 0x0;
$menu = [['us', 'US & Oceanic', null, [[Util::urlize(CFG_BATTLEGROUP), CFG_BATTLEGROUP, null, &$subEU]]], ['eu', 'Europe', null, [[Util::urlize(CFG_BATTLEGROUP), CFG_BATTLEGROUP, null, &$subUS]]]];
if (DB::isConnectable(DB_AUTH)) {
$rows = DB::Auth()->select('SELECT name, IF(timezone IN (8, 9, 10, 11, 12), "eu", "us") AS region FROM realmlist WHERE allowedSecurityLevel = 0 AND gamebuild = ?d', WOW_VERSION);
foreach ($rows as $row) {
if ($row['region'] == 'eu') {
$set |= 0x1;
$subEU[] = [Util::urlize($row['name']), $row['name']];
} else {
if ($row['region'] == 'us') {
$set |= 0x2;
$subUS[] = [Util::urlize($row['name']), $row['name']];
}
}
}
} else {
CLISetup::log(' - realmMenu: Auth-DB not set up .. menu will be empty', CLISetup::LOG_WARN);
}
if (!($set & 0x1)) {
array_shift($menu);
}
if (!($set & 0x2)) {
array_pop($menu);
}
return Util::toJSON($menu);
}
function realmMenu()
{
$subEU = [];
$subUS = [];
$set = 0x0;
$menu = [['us', 'US & Oceanic', null, [[Util::urlize(CFG_BATTLEGROUP), CFG_BATTLEGROUP, null, &$subUS]]], ['eu', 'Europe', null, [[Util::urlize(CFG_BATTLEGROUP), CFG_BATTLEGROUP, null, &$subEU]]]];
foreach (Util::getRealms() as $row) {
if ($row['region'] == 'eu') {
$set |= 0x1;
$subEU[] = [Util::urlize($row['name']), $row['name']];
} else {
if ($row['region'] == 'us') {
$set |= 0x2;
$subUS[] = [Util::urlize($row['name']), $row['name']];
}
}
}
if (!$set) {
CLISetup::log(' - realmMenu: Auth-DB not set up .. menu will be empty', CLISetup::LOG_WARN);
}
if (!($set & 0x1)) {
array_pop($menu);
}
if (!($set & 0x2)) {
array_shift($menu);
}
return Util::toJSON($menu);
}
function itemScalingSD()
{
$data = DB::Aowow()->select('SELECT *, Id AS ARRAY_KEY FROM dbc_scalingstatdistribution');
foreach ($data as &$row) {
$row = array_values($row);
array_splice($row, 0, 1);
}
return CFG_DEBUG ? debugify($data) : Util::toJSON($data);
}
function realms()
{
$realms = [];
if (DB::isConnectable(DB_AUTH)) {
$realms = DB::Auth()->select('SELECT id AS ARRAY_KEY, name, ? AS battlegroup, IF(timezone IN (8, 9, 10, 11, 12), "eu", "us") AS region FROM realmlist WHERE allowedSecurityLevel = 0 AND gamebuild = ?d', CFG_BATTLEGROUP, WOW_VERSION);
} else {
CLISetup::log(' - realms: Auth-DB not set up .. static data g_realms will be empty', CLISetup::LOG_WARN);
}
$toFile = "var g_realms = " . Util::toJSON($realms) . ";";
$file = 'datasets/realms';
return CLISetup::writeFile($file, $toFile);
}
function gems()
{
// sketchy, but should work
// Id < 36'000 || ilevel < 70 ? BC : WOTLK
$gems = DB::Aowow()->Select('SELECT i.id AS itemId,
i.name_loc0, i.name_loc2, i.name_loc3, i.name_loc4, i.name_loc6, i.name_loc8,
IF (i.id < 36000 OR i.itemLevel < 70, 1 , 2) AS expansion,
i.quality,
ic.iconString AS icon,
i.gemEnchantmentId AS enchId,
i.gemColorMask AS colors
FROM ?_items i
JOIN ?_icons ic ON ic.id = -i.displayId
WHERE i.gemEnchantmentId <> 0
ORDER BY i.id DESC');
$success = true;
// check directory-structure
foreach (Util::$localeStrings as $dir) {
if (!CLISetup::writeDir('datasets/' . $dir)) {
$success = false;
}
}
$enchIds = [];
foreach ($gems as $pop) {
$enchIds[] = $pop['enchId'];
}
$enchantments = new EnchantmentList(array(['id', $enchIds], CFG_SQL_LIMIT_NONE));
if ($enchantments->error) {
CLISetup::log('Required table ?_itemenchantment seems to be empty! Leaving gems()...', CLISetup::LOG_ERROR);
CLISetup::log();
return false;
}
foreach (CLISetup::$localeIds as $lId) {
set_time_limit(5);
User::useLocale($lId);
Lang::load(Util::$localeStrings[$lId]);
$gemsOut = [];
foreach ($gems as $pop) {
if (!$enchantments->getEntry($pop['enchId'])) {
CLISetup::log(' * could not find enchantment #' . $pop['enchId'] . ' referenced by item #' . $gem['itemId'], CLISetup::LOG_WARN);
continue;
}
$gemsOut[$pop['itemId']] = array('name' => Util::localizedString($pop, 'name'), 'quality' => $pop['quality'], 'icon' => strToLower($pop['icon']), 'enchantment' => $enchantments->getField('name', true), 'jsonequip' => $enchantments->getStatGain(), 'colors' => $pop['colors'], 'expansion' => $pop['expansion']);
}
$toFile = "var g_gems = " . Util::toJSON($gemsOut) . ";";
$file = 'datasets/' . User::$localeString . '/gems';
if (!CLISetup::writeFile($file, $toFile)) {
$success = false;
}
}
return $success;
}
function realms()
{
$realms = Util::getRealms();
if (!$realms) {
CLISetup::log(' - realms: Auth-DB not set up .. static data g_realms will be empty', CLISetup::LOG_WARN);
} else {
foreach ($realms as &$r) {
$r['battlegroup'] = CFG_BATTLEGROUP;
}
}
$toFile = "var g_realms = " . Util::toJSON($realms) . ";";
$file = 'datasets/realms';
return CLISetup::writeFile($file, $toFile);
}
function glyphs()
{
$success = true;
$glyphList = DB::Aowow()->Select('SELECT i.id AS itemId,
i.*,
IF (g.typeFlags & 0x1, 2, 1) AS type,
i.subclass AS classs,
i.requiredLevel AS level,
s1.Id AS glyphSpell,
ic.iconString AS icon,
s1.skillLine1 AS skillId,
s2.Id AS glyphEffect,
s2.Id AS ARRAY_KEY
FROM ?_items i
JOIN ?_spell s1 ON s1.Id = i.spellid1
JOIN ?_glyphproperties g ON g.Id = s1.effect1MiscValue
JOIN ?_spell s2 ON s2.Id = g.spellId
JOIN ?_icons ic ON ic.Id = s1.iconIdAlt
WHERE i.classBak = 16');
// check directory-structure
foreach (Util::$localeStrings as $dir) {
if (!CLISetup::writeDir('datasets/' . $dir)) {
$success = false;
}
}
$glyphSpells = new SpellList(array(['s.id', array_keys($glyphList)], CFG_SQL_LIMIT_NONE));
foreach (CLISetup::$localeIds as $lId) {
set_time_limit(30);
User::useLocale($lId);
Lang::load(Util::$localeStrings[$lId]);
$glyphsOut = [];
foreach ($glyphSpells->iterate() as $__) {
$pop = $glyphList[$glyphSpells->id];
if (!$pop['glyphEffect']) {
continue;
}
if ($glyphSpells->getField('effect1Id') != 6 && $glyphSpells->getField('effect2Id') != 6 && $glyphSpells->getField('effect3Id') != 6) {
continue;
}
$glyphsOut[$pop['itemId']] = array('name' => Util::localizedString($pop, 'name'), 'description' => $glyphSpells->parseText()[0], 'icon' => $pop['icon'], 'type' => $pop['type'], 'classs' => $pop['classs'], 'skill' => $pop['skillId'], 'level' => $pop['level']);
}
$toFile = "var g_glyphs = " . Util::toJSON($glyphsOut) . ";";
$file = 'datasets/' . User::$localeString . '/glyphs';
if (!CLISetup::writeFile($file, $toFile)) {
$success = false;
}
}
return $success;
}
protected function generateContent()
{
$tabData = array('data' => [], 'name' => Util::ucFirst(Lang::game('enchantments')));
$conditions = [];
if (!User::isInGroup(U_GROUP_EMPLOYEE)) {
$conditions[] = [['cuFlags', CUSTOM_EXCLUDE_FOR_LISTVIEW, '&'], 0];
}
if ($_ = $this->filterObj->getConditions()) {
$conditions[] = $_;
}
$ench = new EnchantmentList($conditions);
$tabData['data'] = array_values($ench->getListviewData());
$this->extendGlobalData($ench->getJSGlobals());
// recreate form selection
$this->filter = array_merge($this->filterObj->getForm('form'), $this->filter);
$this->filter['query'] = isset($_GET['filter']) ? $_GET['filter'] : NULL;
$this->filter['fi'] = $this->filterObj->getForm();
$xCols = $this->filterObj->getForm('extraCols', true);
foreach (Util::$itemFilter as $fiId => $str) {
if (array_column($tabData['data'], $str)) {
$xCols[] = $fiId;
}
}
if (array_column($tabData['data'], 'dmg')) {
$xCols[] = 34;
}
if ($xCols) {
$this->filter['fi']['extraCols'] = "fi_extraCols = " . Util::toJSON(array_values(array_unique($xCols))) . ";";
}
if (!empty($this->filter['fi']['extraCols'])) {
$tabData['extraCols'] = '$fi_getExtraCols(fi_extraCols, 0, 0)';
}
if ($ench->getMatches() > CFG_SQL_LIMIT_DEFAULT) {
$tabData['note'] = sprintf(Util::$tryFilteringString, 'LANG.lvnote_enchantmentsfound', $ench->getMatches(), CFG_SQL_LIMIT_DEFAULT);
$tabData['_truncated'] = 1;
}
if (array_filter(array_column($tabData['data'], 'spells'))) {
$tabData['visibleCols'] = ['trigger'];
}
if (!$ench->hasSetFields(['skillLine'])) {
$tabData['hiddenCols'] = ['skill'];
}
if ($this->filterObj->error) {
$tabData['_errors'] = '$1';
}
$this->lvTabs[] = ['enchantment', $tabData, 'enchantment'];
}
function pets()
{
$success = true;
$locations = [];
$petList = DB::Aowow()->Select('SELECT cr. id,
cr.name_loc0, cr.name_loc2, cr.name_loc3, cr.name_loc6, cr.name_loc8,
cr.minLevel,
cr.maxLevel,
ft.A,
ft.H,
cr.rank AS classification,
cr.family,
cr.displayId1 AS displayId,
cr.textureString AS skin,
LOWER(SUBSTRING_INDEX(cf.iconString, "\\\\", -1)) AS icon,
cf.petTalentType AS type
FROM ?_creature cr
JOIN ?_factiontemplate ft ON ft.Id = cr.faction
JOIN dbc_creaturefamily cf ON cf.id = cr.family
WHERE cr.typeFlags & 0x1 AND (cr.cuFlags & 0x2) = 0
ORDER BY cr.id ASC');
// check directory-structure
foreach (Util::$localeStrings as $dir) {
if (!CLISetup::writeDir('datasets/' . $dir)) {
$success = false;
}
}
foreach (CLISetup::$localeIds as $lId) {
User::useLocale($lId);
Lang::load(Util::$localeStrings[$lId]);
$petsOut = [];
foreach ($petList as $pet) {
// get locations
// again: caching will save you time and nerves
if (!isset($locations[$pet['id']])) {
$locations[$pet['id']] = DB::Aowow()->SelectCol('SELECT DISTINCT areaId FROM ?_spawns WHERE type = ?d AND typeId = ?d', TYPE_NPC, $pet['id']);
}
$petsOut[$pet['id']] = array('id' => $pet['id'], 'name' => Util::localizedString($pet, 'name'), 'minlevel' => $pet['minLevel'], 'maxlevel' => $pet['maxLevel'], 'location' => $locations[$pet['id']], 'react' => [$pet['A'], $pet['H']], 'classification' => $pet['classification'], 'family' => $pet['family'], 'displayId' => $pet['displayId'], 'skin' => $pet['skin'], 'icon' => $pet['icon'], 'type' => $pet['type']);
}
$toFile = "var g_pets = " . Util::toJSON($petsOut) . ";";
$file = 'datasets/' . User::$localeString . '/pets';
if (!CLISetup::writeFile($file, $toFile)) {
$success = false;
}
}
return $success;
}
protected function generateContent()
{
$this->addJS('?data=zones&locale=' . User::$localeId . '&t=' . $_SESSION['dataKey']);
$conditions = [];
if (!User::isInGroup(U_GROUP_EMPLOYEE)) {
$conditions[] = [['cuFlags', CUSTOM_EXCLUDE_FOR_LISTVIEW, '&'], 0];
}
if ($this->category) {
$conditions[] = ['type', $this->category[0]];
$this->petFamPanel = $this->category[0] == 1;
} else {
$this->petFamPanel = false;
}
if ($_ = $this->filterObj->getConditions()) {
$conditions[] = $_;
}
// beast subtypes are selected via filter
$npcs = new CreatureList($conditions, ['extraOpts' => $this->filterObj->extraOpts]);
// recreate form selection
$this->filter = array_merge($this->filterObj->getForm('form'), $this->filter);
$this->filter['query'] = isset($_GET['filter']) ? $_GET['filter'] : NULL;
$this->filter['fi'] = $this->filterObj->getForm();
$repCols = $this->filterObj->getForm('reputationCols');
$tabData = array('data' => array_values($npcs->getListviewData($repCols ? NPCINFO_REP : 0x0)));
if ($repCols) {
$tabData['extraCols'] = '$fi_getReputationCols(' . Util::toJSON($repCols) . ')';
} else {
if (!empty($this->filter['fi']['extraCols'])) {
$tabData['extraCols'] = '$fi_getExtraCols(fi_extraCols, 0, 0)';
}
}
if ($this->category) {
$tabData['hiddenCols'] = ['type'];
}
// create note if search limit was exceeded
if ($npcs->getMatches() > CFG_SQL_LIMIT_DEFAULT) {
$tabData['note'] = sprintf(Util::$tryFilteringString, 'LANG.lvnote_npcsfound', $npcs->getMatches(), CFG_SQL_LIMIT_DEFAULT);
$tabData['_truncated'] = 1;
}
if ($this->filterObj->error) {
$tabData['_errors'] = 1;
}
$this->lvTabs[] = ['creature', $tabData];
// sort for dropdown-menus
Lang::sort('game', 'fa');
}
protected function generateContent()
{
$conditions = [];
if (!User::isInGroup(U_GROUP_EMPLOYEE)) {
$conditions[] = [['cuFlags', CUSTOM_EXCLUDE_FOR_LISTVIEW, '&'], 0];
}
if (isset($this->category[1])) {
$conditions[] = ['zoneOrSort', $this->category[1]];
} else {
if (isset($this->category[0])) {
$conditions[] = ['zoneOrSort', $this->validCats[$this->category[0]]];
}
}
if ($_ = $this->filterObj->getConditions()) {
$conditions[] = $_;
}
$quests = new QuestList($conditions, ['extraOpts' => $this->filterObj->extraOpts]);
$this->extendGlobalData($quests->getJSGlobals());
// recreate form selection
$this->filter = array_merge($this->filterObj->getForm('form'), $this->filter);
$this->filter['query'] = isset($_GET['filter']) ? $_GET['filter'] : NULL;
$this->filter['fi'] = $this->filterObj->getForm();
$lv = array('file' => 'quest', 'data' => $quests->getListviewData(), 'params' => []);
if ($_ = $this->filterObj->getForm('reputationCols')) {
$lv['params']['extraCols'] = '$fi_getReputationCols(' . Util::toJSON($_) . ')';
} else {
if (!empty($this->filter['fi']['extraCols'])) {
$lv['params']['extraCols'] = '$fi_getExtraCols(fi_extraCols, 0, 0)';
}
}
// create note if search limit was exceeded
if ($quests->getMatches() > CFG_SQL_LIMIT_DEFAULT) {
$lv['params']['note'] = sprintf(Util::$tryFilteringString, 'LANG.lvnote_questsfound', $quests->getMatches(), CFG_SQL_LIMIT_DEFAULT);
$lv['params']['_truncated'] = 1;
} else {
if (isset($this->category[1]) && $this->category[1] > 0) {
$lv['params']['note'] = '$$WH.sprintf(LANG.lvnote_questgivers, ' . $this->category[1] . ', g_zones[' . $this->category[1] . '], ' . $this->category[1] . ')';
}
}
if ($this->filterObj->error) {
$lv['params']['_errors'] = '$1';
}
$this->lvTabs[] = $lv;
}
function gems()
{
// sketchy, but should work
// Id < 36'000 || ilevel < 70 ? BC : WOTLK
$gems = DB::Aowow()->Select('SELECT i.id AS itemId,
i.name_loc0, i.name_loc2, i.name_loc3, i.name_loc6, i.name_loc8,
IF (i.id < 36000 OR i.itemLevel < 70, 1 , 2) AS expansion,
i.quality,
ic.iconString AS icon,
i.gemEnchantmentId AS enchId,
i.gemColorMask AS colors
FROM ?_items i
JOIN ?_icons ic ON ic.id = -i.displayId
WHERE i.gemEnchantmentId <> 0
ORDER BY i.id DESC');
$success = true;
// check directory-structure
foreach (Util::$localeStrings as $dir) {
if (!CLISetup::writeDir('datasets/' . $dir)) {
$success = false;
}
}
$enchIds = [];
foreach ($gems as $pop) {
$enchIds[] = $pop['enchId'];
}
$enchMisc = [];
$enchJSON = Util::parseItemEnchantment($enchIds, false, $enchMisc);
foreach (CLISetup::$localeIds as $lId) {
set_time_limit(5);
User::useLocale($lId);
Lang::load(Util::$localeStrings[$lId]);
$gemsOut = [];
foreach ($gems as $pop) {
$gemsOut[$pop['itemId']] = array('name' => Util::localizedString($pop, 'name'), 'quality' => $pop['quality'], 'icon' => strToLower($pop['icon']), 'enchantment' => Util::localizedString(@$enchMisc[$pop['enchId']]['text'] ?: [], 'text'), 'jsonequip' => @$enchJSON[$pop['enchId']] ?: [], 'colors' => $pop['colors'], 'expansion' => $pop['expansion']);
}
$toFile = "var g_gems = " . Util::toJSON($gemsOut) . ";";
$file = 'datasets/' . User::$localeString . '/gems';
if (!CLISetup::writeFile($file, $toFile)) {
$success = false;
}
}
return $success;
}
function weightPresets()
{
// check directory-structure
if (!CLISetup::writeDir('datasets/')) {
return false;
}
$wtPresets = [];
$scales = DB::Aowow()->select('SELECT id, name, icon, class FROM ?_account_weightscales WHERE userId = 0 ORDER BY class, id ASC');
foreach ($scales as $s) {
$weights = DB::Aowow()->selectCol('SELECT field AS ARRAY_KEY, val FROM ?_account_weightscale_data WHERE id = ?d', $s['id']);
if (!$weights) {
CLISetup::log('WeightScale \'' . CLISetup::bold($s['name']) . '\' has no data set. Skipping...', CLISetup::LOG_WARN);
continue;
}
$wtPresets[$s['class']]['pve'][$s['name']] = array_merge(['__icon' => $s['icon']], $weights);
}
$toFile = "var wt_presets = " . Util::toJSON($wtPresets) . ";";
$file = 'datasets/weight-presets';
if (!CLISetup::writeFile($file, $toFile)) {
return false;
}
return true;
}
<?php
if (!empty($this->pageText)) {
?>
<div class="clear"></div>
<h3><?php
echo Lang::item('content');
?>
</h3>
<div id="book-generic"></div>
<script>//<![CDATA[
new Book({ parent: 'book-generic', pages: <?php
echo Util::toJSON($this->pageText);
?>
})
//]]></script>
<?php
}
protected function generateTooltip($asError = false)
{
if ($asError) {
die('$WowheadPower.registerSpell(' . $this->typeId . ', ' . User::$localeId . ', {});');
}
$x = '$WowheadPower.registerSpell(' . $this->typeId . ', ' . User::$localeId . ", {\n";
$pt = [];
if ($n = $this->subject->getField('name', true)) {
$pt[] = "\tname_" . User::$localeString . ": '" . Util::jsEscape($n) . "'";
}
if ($i = $this->subject->getField('iconString')) {
$pt[] = "\ticon: '" . urlencode($i) . "'";
}
if ($tt = $this->subject->renderTooltip()) {
$pt[] = "\ttooltip_" . User::$localeString . ": '" . Util::jsEscape($tt[0]) . "'";
$pt[] = "\tspells_" . User::$localeString . ": " . Util::toJSON($tt[1]);
}
if ($btt = $this->subject->renderBuff()) {
$pt[] = "\tbuff_" . User::$localeString . ": '" . Util::jsEscape($btt[0]) . "'";
$pt[] = "\tbuffspells_" . User::$localeString . ": " . Util::toJSON($btt[1]);
}
$x .= implode(",\n", $pt) . "\n});";
return $x;
}
protected function handleReplyEdit()
{
if (!User::canComment()) {
return 'You are not allowed to reply.';
} else {
if (!$this->_post['replyId'] || !$this->_post['commentId']) {
return Lang::main('genericError');
} else {
if (!$this->_post['body'] || mb_strlen($this->_post['body']) < self::REPLY_LENGTH_MIN || mb_strlen($this->_post['body']) > self::REPLY_LENGTH_MAX) {
return 'Your reply has ' . mb_strlen($this->_post['body']) . ' characters and must have at least ' . self::REPLY_LENGTH_MIN . ' and at most ' . self::REPLY_LENGTH_MAX . '.';
}
}
}
if (DB::Aowow()->query('UPDATE ?_comments SET body = ?, editUserId = ?d, editDate = UNIX_TIMESTAMP(), editCount = editCount + 1 WHERE id = ?d AND replyTo = ?d{ AND userId = ?d}', $this->_post['body'], User::$id, $this->_post['replyId'], $this->_post['commentId'], User::isInGroup(U_GROUP_MODERATOR) ? DBSIMPLE_SKIP : User::$id)) {
return Util::toJSON(CommunityContent::getCommentReplies($this->_post['commentId']));
} else {
return Lang::main('genericError');
}
}
private function handleWeightPresets()
{
$this->addCSS(['string' => '.wt-edit {display:inline-block; vertical-align:top; width:350px;}']);
$this->addJS('filters.js');
$head = $body = '';
$scales = DB::Aowow()->select('SELECT class AS ARRAY_KEY, id AS ARRAY_KEY2, name, icon FROM ?_account_weightscales WHERE userId = 0');
$weights = DB::Aowow()->selectCol('SELECT awd.id AS ARRAY_KEY, awd.field AS ARRAY_KEY2, awd.val FROM ?_account_weightscale_data awd JOIN ?_account_weightscales ad ON awd.id = ad.id WHERE ad.userId = 0');
foreach ($scales as $cl => $data) {
$ul = '';
foreach ($data as $id => $s) {
$weights[$id]['__icon'] = $s['icon'];
$ul .= '[url=# onclick="loadScale.bind(this, ' . $id . ')();"]' . $s['name'] . '[/url][br]';
}
$head .= '[td=header]' . Lang::game('cl', $cl) . '[/td]';
$body .= '[td valign=top]' . $ul . '[/td]';
}
$this->extraText = '[table class=grid][tr]' . $head . '[/tr][tr]' . $body . '[/tr][/table]';
$this->extraHTML = '<script type="text/javascript">var wt_presets = ' . Util::toJSON($weights) . ";</script>\n\n";
}
<div class="main" id="main">
<div class="main-precontents" id="main-precontents"></div>
<div class="main-contents" id="main-contents">
<?php
$this->brick('announcement');
$this->brick('pageTemplate');
?>
<div class="text">
<div id="compare-generic"></div>
<script type="text/javascript">//<![CDATA[
<?php
foreach ($this->cmpItems as $iId => $iData) {
echo ' g_items.add(' . $iId . ', ' . Util::toJSON($iData) . ");\n";
}
?>
new Summary(<?php
echo Util::toJSON($this->summary);
?>
);
//]]></script>
</div>
<div class="clear"></div>
</div><!-- main-contents -->
</div><!-- main -->
<?php
$this->brick('footer');
protected function generateContent()
{
$_level = $this->subject->getField('level');
$_minLevel = $this->subject->getField('minLevel');
$_flags = $this->subject->getField('flags');
$_specialFlags = $this->subject->getField('specialFlags');
$_side = Util::sideByRaceMask($this->subject->getField('reqRaceMask'));
/***********/
/* Infobox */
/***********/
$infobox = Lang::getInfoBoxForFlags($this->subject->getField('cuFlags'));
// event (todo: assign eventData)
if ($_ = $this->subject->getField('eventId')) {
$this->extendGlobalIds(TYPE_WORLDEVENT, $_);
$infobox[] = Lang::game('eventShort') . Lang::main('colon') . '[event=' . $_ . ']';
}
// level
if ($_level > 0) {
$infobox[] = Lang::game('level') . Lang::main('colon') . $_level;
}
// reqlevel
if ($_minLevel) {
$lvl = $_minLevel;
if ($_ = $this->subject->getField('maxLevel')) {
$lvl .= ' - ' . $_;
}
$infobox[] = sprintf(Lang::game('reqLevel'), $lvl);
}
// loremaster (i dearly hope those flags cover every case...)
if ($this->subject->getField('zoneOrSortBak') > 0 && !$this->subject->isRepeatable()) {
$conditions = array(['ac.type', ACHIEVEMENT_CRITERIA_TYPE_COMPLETE_QUESTS_IN_ZONE], ['ac.value1', $this->subject->getField('zoneOrSortBak')], ['a.faction', $_side, '&']);
$loremaster = new AchievementList($conditions);
$this->extendGlobalData($loremaster->getJSGlobals(GLOBALINFO_SELF));
switch ($loremaster->getMatches()) {
case 0:
break;
case 1:
$infobox[] = Lang::quest('loremaster') . Lang::main('colon') . '[achievement=' . $loremaster->id . ']';
break;
default:
$lm = Lang::quest('loremaster') . Lang::main('colon') . '[ul]';
foreach ($loremaster->iterate() as $id => $__) {
$lm .= '[li][achievement=' . $id . '][/li]';
}
$infobox[] = $lm . '[/ul]';
break;
}
}
// type (maybe expand uppon?)
$_ = [];
if ($_flags & QUEST_FLAG_DAILY) {
$_[] = Lang::quest('daily');
} else {
if ($_flags & QUEST_FLAG_WEEKLY) {
$_[] = Lang::quest('weekly');
} else {
if ($_specialFlags & QUEST_FLAG_SPECIAL_MONTHLY) {
$_[] = Lang::quest('monthly');
}
}
}
if ($t = $this->subject->getField('type')) {
$_[] = Lang::quest('questInfo', $t);
}
if ($_) {
$infobox[] = Lang::game('type') . Lang::main('colon') . implode(' ', $_);
}
// side
$_ = Lang::main('side') . Lang::main('colon');
switch ($_side) {
case 3:
$infobox[] = $_ . Lang::game('si', 3);
break;
case 2:
$infobox[] = $_ . '[span class=icon-horde]' . Lang::game('si', 2) . '[/span]';
break;
case 1:
$infobox[] = $_ . '[span class=icon-alliance]' . Lang::game('si', 1) . '[/span]';
break;
}
// races
if ($_ = Lang::getRaceString($this->subject->getField('reqRaceMask'), $__, $jsg, $n, false)) {
$this->extendGlobalIds(TYPE_RACE, $jsg);
$t = $n == 1 ? Lang::game('race') : Lang::game('races');
$infobox[] = Util::ucFirst($t) . Lang::main('colon') . $_;
}
// classes
if ($_ = Lang::getClassString($this->subject->getField('reqClassMask'), $jsg, $n, false)) {
$this->extendGlobalIds(TYPE_CLASS, $jsg);
$t = $n == 1 ? Lang::game('class') : Lang::game('classes');
$infobox[] = Util::ucFirst($t) . Lang::main('colon') . $_;
}
// profession / skill
if ($_ = $this->subject->getField('reqSkillId')) {
$this->extendGlobalIds(TYPE_SKILL, $_);
$sk = '[skill=' . $_ . ']';
if ($_ = $this->subject->getField('reqSkillPoints')) {
$sk .= ' (' . $_ . ')';
}
$infobox[] = Lang::quest('profession') . Lang::main('colon') . $sk;
}
// timer
if ($_ = $this->subject->getField('timeLimit')) {
$infobox[] = Lang::quest('timer') . Lang::main('colon') . Util::formatTime($_ * 1000);
}
$startEnd = DB::Aowow()->select('SELECT * FROM ?_quests_startend WHERE questId = ?d', $this->typeId);
// start
$start = '[icon name=quest_start' . ($this->subject->isDaily() ? '_daily' : '') . ']' . Lang::event('start') . Lang::main('colon') . '[/icon]';
$s = [];
foreach ($startEnd as $se) {
if ($se['method'] & 0x1) {
$this->extendGlobalIds($se['type'], $se['typeId']);
$s[] = ($s ? '[span=invisible]' . $start . '[/span] ' : $start . ' ') . '[' . Util::$typeStrings[$se['type']] . '=' . $se['typeId'] . ']';
}
}
if ($s) {
$infobox[] = implode('[br]', $s);
}
// end
$end = '[icon name=quest_end' . ($this->subject->isDaily() ? '_daily' : '') . ']' . Lang::event('end') . Lang::main('colon') . '[/icon]';
$e = [];
foreach ($startEnd as $se) {
if ($se['method'] & 0x2) {
$this->extendGlobalIds($se['type'], $se['typeId']);
$e[] = ($e ? '[span=invisible]' . $end . '[/span] ' : $end . ' ') . '[' . Util::$typeStrings[$se['type']] . '=' . $se['typeId'] . ']';
}
}
if ($e) {
$infobox[] = implode('[br]', $e);
}
// Repeatable
if ($_flags & QUEST_FLAG_REPEATABLE || $_specialFlags & QUEST_FLAG_SPECIAL_REPEATABLE) {
$infobox[] = Lang::quest('repeatable');
}
// sharable | not sharable
$infobox[] = $_flags & QUEST_FLAG_SHARABLE ? Lang::quest('sharable') : Lang::quest('notSharable');
// Keeps you PvP flagged
if ($this->subject->isPvPEnabled()) {
$infobox[] = Lang::quest('keepsPvpFlag');
}
// difficulty (todo (low): formula unclear. seems to be [minLevel,] -4, -2, (level), +3, +(9 to 15))
if ($_level > 0) {
$_ = [];
// red
if ($_minLevel && $_minLevel < $_level - 4) {
$_[] = '[color=q10]' . $_minLevel . '[/color]';
}
// orange
if (!$_minLevel || $_minLevel < $_level - 2) {
$_[] = '[color=r1]' . (!$_ && $_minLevel > $_level - 4 ? $_minLevel : $_level - 4) . '[/color]';
}
// yellow
$_[] = '[color=r2]' . (!$_ && $_minLevel > $_level - 2 ? $_minLevel : $_level - 2) . '[/color]';
// green
$_[] = '[color=r3]' . ($_level + 3) . '[/color]';
// grey (is about +/-1 level off)
$_[] = '[color=r4]' . ($_level + 3 + ceil(12 * $_level / MAX_LEVEL)) . '[/color]';
if ($_) {
$infobox[] = Lang::game('difficulty') . Lang::main('colon') . implode('[small] [/small]', $_);
}
}
$this->infobox = '[ul][li]' . implode('[/li][li]', $infobox) . '[/li][/ul]';
/**********/
/* Series */
/**********/
// Quest Chain (are there cases where quests go in parallel?)
$chain = array(array(array('side' => $_side, 'typeStr' => Util::$typeStrings[TYPE_QUEST], 'typeId' => $this->typeId, 'name' => $this->name, '_next' => $this->subject->getField('nextQuestIdChain'))));
$_ = $chain[0][0];
while ($_) {
if ($_ = DB::Aowow()->selectRow('SELECT id AS typeId, name_loc0, name_loc2, name_loc3, name_loc6, name_loc8, reqRaceMask FROM ?_quests WHERE nextQuestIdChain = ?d', $_['typeId'])) {
$n = Util::localizedString($_, 'name');
array_unshift($chain, array(array('side' => Util::sideByRaceMask($_['reqRaceMask']), 'typeStr' => Util::$typeStrings[TYPE_QUEST], 'typeId' => $_['typeId'], 'name' => strlen($n) > 40 ? substr($n, 0, 40) . '…' : $n)));
}
}
$_ = end($chain)[0];
while ($_) {
if ($_ = DB::Aowow()->selectRow('SELECT id AS typeId, name_loc0, name_loc2, name_loc3, name_loc6, name_loc8, reqRaceMask, nextQuestIdChain AS _next FROM ?_quests WHERE id = ?d', $_['_next'])) {
$n = Util::localizedString($_, 'name');
array_push($chain, array(array('side' => Util::sideByRaceMask($_['reqRaceMask']), 'typeStr' => Util::$typeStrings[TYPE_QUEST], 'typeId' => $_['typeId'], 'name' => strlen($n) > 40 ? substr($n, 0, 40) . '…' : $n, '_next' => $_['_next'])));
}
}
if (count($chain) > 1) {
$this->series[] = [$chain, null];
}
// todo (low): sensibly merge the following lists into 'series'
$listGen = function ($cnd) {
$chain = [];
$list = new QuestList($cnd);
if ($list->error) {
return null;
}
foreach ($list->iterate() as $id => $__) {
$n = $list->getField('name', true);
$chain[] = array(array('side' => Util::sideByRaceMask($list->getField('reqRaceMask')), 'typeStr' => Util::$typeStrings[TYPE_QUEST], 'typeId' => $id, 'name' => strlen($n) > 40 ? substr($n, 0, 40) . '…' : $n));
}
return $chain;
};
$extraLists = array(['reqQ', array('OR', ['AND', ['nextQuestId', $this->typeId], ['exclusiveGroup', 0, '<']], ['AND', ['id', $this->subject->getField('prevQuestId')], ['nextQuestIdChain', $this->typeId, '!']])], ['reqOneQ', array(['exclusiveGroup', 0, '>'], ['nextQuestId', $this->typeId])], ['opensQ', array('OR', ['AND', ['prevQuestId', $this->typeId], ['id', $this->subject->getField('nextQuestIdChain'), '!']], ['id', $this->subject->getField('nextQuestId')])], ['closesQ', array(['exclusiveGroup', 0, '!'], ['exclusiveGroup', $this->subject->getField('exclusiveGroup')], ['id', $this->typeId, '!'])], ['enablesQ', array(['prevQuestId', -$this->typeId])], ['enabledByQ', array(['id', -$this->subject->getField('prevQuestId')])]);
foreach ($extraLists as $el) {
if ($_ = $listGen($el[1])) {
$this->series[] = [$_, sprintf(Util::$dfnString, Lang::quest($el[0] . 'Desc'), Lang::quest($el[0]))];
}
}
/*******************/
/* Objectives List */
/*******************/
$this->objectiveList = [];
$this->providedItem = [];
// gather ids for lookup
$olItems = $olNPCs = $olGOs = $olFactions = [];
// items
$olItems[0] = array($this->subject->getField('sourceItemId'), $this->subject->getField('sourceItemCount'), false);
for ($i = 1; $i < 7; $i++) {
$id = $this->subject->getField('reqItemId' . $i);
$qty = $this->subject->getField('reqItemCount' . $i);
if (!$id || !$qty) {
continue;
}
$olItems[$i] = [$id, $qty, $id == $olItems[0][0]];
}
if ($ids = array_column($olItems, 0)) {
$olItemData = new ItemList(array(['id', $ids]));
$this->extendGlobalData($olItemData->getJSGlobals(GLOBALINFO_SELF));
$providedRequired = false;
foreach ($olItems as $i => list($itemId, $qty, $provided)) {
if (!$i || !$itemId || !in_array($itemId, $olItemData->getFoundIDs())) {
continue;
}
if ($provided) {
$providedRequired = true;
}
$this->objectiveList[] = array('typeStr' => Util::$typeStrings[TYPE_ITEM], 'id' => $itemId, 'name' => $olItemData->json[$itemId]['name'], 'qty' => $qty > 1 ? $qty : 0, 'quality' => 7 - $olItemData->json[$itemId]['quality'], 'extraText' => $provided ? ' (' . Lang::quest('provided') . ')' : '');
}
// if providd item is not required by quest, list it below other requirements
if (!$providedRequired && $olItems[0][0] && in_array($olItems[0][0], $olItemData->getFoundIDs())) {
$this->providedItem = array('id' => $olItems[0][0], 'name' => $olItemData->json[$olItems[0][0]]['name'], 'qty' => $olItems[0][1] > 1 ? $olItems[0][1] : 0, 'quality' => 7 - $olItemData->json[$olItems[0][0]]['quality']);
}
}
// creature or GO...
for ($i = 1; $i < 5; $i++) {
$id = $this->subject->getField('reqNpcOrGo' . $i);
$qty = $this->subject->getField('reqNpcOrGoCount' . $i);
$altTxt = $this->subject->getField('objectiveText' . $i, true);
if ($id > 0 && $qty) {
$olNPCs[$id] = [$qty, $altTxt, []];
} else {
if ($id < 0 && $qty) {
$olGOs[-$id] = [$qty, $altTxt];
}
}
}
// .. creature kills
if ($ids = array_keys($olNPCs)) {
$olNPCData = new CreatureList(array('OR', ['id', $ids], ['killCredit1', $ids], ['killCredit2', $ids]));
$this->extendGlobalData($olNPCData->getJSGlobals(GLOBALINFO_SELF));
// create proxy-references
foreach ($olNPCData->iterate() as $id => $__) {
if ($p = $olNPCData->getField('KillCredit1')) {
if (isset($olNPCs[$p])) {
$olNPCs[$p][2][$id] = $olNPCData->getField('name', true);
}
}
if ($p = $olNPCData->getField('KillCredit2')) {
if (isset($olNPCs[$p])) {
$olNPCs[$p][2][$id] = $olNPCData->getField('name', true);
}
}
}
foreach ($olNPCs as $i => $pair) {
if (!$i || !in_array($i, $olNPCData->getFoundIDs())) {
continue;
}
$ol = array('typeStr' => Util::$typeStrings[TYPE_NPC], 'id' => $i, 'name' => $pair[1] ?: Util::localizedString($olNPCData->getEntry($i), 'name'), 'qty' => $pair[0] > 1 ? $pair[0] : 0, 'extraText' => $_specialFlags & QUEST_FLAG_SPECIAL_SPELLCAST || $pair[1] ? '' : ' ' . Lang::achievement('slain'), 'proxy' => $pair[2]);
if ($pair[2]) {
// has proxies assigned, add yourself as another proxy
$ol['proxy'][$i] = Util::localizedString($olNPCData->getEntry($i), 'name');
}
$this->objectiveList[] = $ol;
}
}
// .. GO interactions
if ($ids = array_keys($olGOs)) {
$olGOData = new GameObjectList(array(['id', $ids]));
$this->extendGlobalData($olGOData->getJSGlobals(GLOBALINFO_SELF));
foreach ($olNPCs as $i => $pair) {
if (!$i || !in_array($i, $olGOData->getFoundIDs())) {
continue;
}
$this->objectiveList[] = array('typeStr' => Util::$typeStrings[TYPE_OBJECT], 'id' => $i, 'name' => $pair[1] ?: Util::localizedString($olGOData->getEntry($i), 'name'), 'qty' => $pair[0] > 1 ? $pair[0] : 0);
}
}
// reputation required
for ($i = 1; $i < 3; $i++) {
$id = $this->subject->getField('reqFactionId' . $i);
$val = $this->subject->getField('reqFactionValue' . $i);
if (!$id) {
continue;
}
$olFactions[$id] = $val;
}
if ($ids = array_keys($olFactions)) {
$olFactionsData = new FactionList(array(['id', $ids]));
$this->extendGlobalData($olFactionsData->getJSGlobals(GLOBALINFO_SELF));
foreach ($olFactions as $i => $val) {
if (!$i || !in_array($i, $olFactionsData->getFoundIDs())) {
continue;
}
$this->objectiveList[] = array('typeStr' => Util::$typeStrings[TYPE_FACTION], 'id' => $i, 'name' => Util::localizedString($olFactionsData->getEntry($i), 'name'), 'qty' => sprintf(Util::$dfnString, $val . ' ' . Lang::achievement('points'), Lang::getReputationLevelForPoints($val)), 'extraText' => '');
}
}
// granted spell
if ($_ = $this->subject->getField('sourceSpellId')) {
$this->extendGlobalIds(TYPE_SPELL, $_);
$this->objectiveList[] = array('typeStr' => Util::$typeStrings[TYPE_SPELL], 'id' => $_, 'name' => SpellList::getName($_), 'qty' => 0, 'extraText' => ' (' . Lang::quest('provided') . ')');
}
// required money
if ($this->subject->getField('rewardOrReqMoney') < 0) {
$this->objectiveList[] = ['text' => Lang::quest('reqMoney') . Lang::main('colon') . Util::formatMoney(abs($this->subject->getField('rewardOrReqMoney')))];
}
// required pvp kills
if ($_ = $this->subject->getField('reqPlayerKills')) {
$this->objectiveList[] = ['text' => Lang::quest('playerSlain') . ' (' . $_ . ')'];
}
/**********/
/* Mapper */
/**********/
$this->addJS('?data=zones&locale=' . User::$localeId . '&t=' . $_SESSION['dataKey']);
/*
TODO (GODDAMNIT): jeez..
*/
// $startend + reqNpcOrGo[1-4]
$this->map = null;
// array(
// 'data' => ['zone' => $this->typeId],
// 'som' => Util::toJSON($som)
// );
/****************/
/* Main Content */
/****************/
$this->gains = $this->createGains();
$this->mail = $this->createMail($maTab, $startEnd);
$this->rewards = $this->createRewards();
$this->objectives = $this->subject->parseText('objectives', false);
$this->details = $this->subject->parseText('details', false);
$this->offerReward = $this->subject->parseText('offerReward', false);
$this->requestItems = $this->subject->parseText('requestItems', false);
$this->completed = $this->subject->parseText('completed', false);
$this->end = $this->subject->parseText('end', false);
$this->suggestedPl = $this->subject->getField('suggestedPlayers');
$this->unavailable = $_flags & QUEST_FLAG_UNAVAILABLE || $this->subject->getField('cuFlags') & CUSTOM_EXCLUDE_FOR_LISTVIEW;
$this->redButtons = array(BUTTON_LINKS => ['color' => 'ffffff00', 'linkId' => 'quest:' . $this->typeId . ':' . $_level . ''], BUTTON_WOWHEAD => true);
if ($maTab) {
$this->lvTabs[] = $maTab;
}
// factionchange-equivalent
if ($pendant = DB::World()->selectCell('SELECT IF(horde_id = ?d, alliance_id, -horde_id) FROM player_factionchange_quests WHERE alliance_id = ?d OR horde_id = ?d', $this->typeId, $this->typeId, $this->typeId)) {
$altQuest = new QuestList(array(['id', abs($pendant)]));
if (!$altQuest->error) {
$this->transfer = sprintf(Lang::quest('_transfer'), $altQuest->id, $altQuest->getField('name', true), $pendant > 0 ? 'alliance' : 'horde', $pendant > 0 ? Lang::game('si', 1) : Lang::game('si', 2));
}
}
/**************/
/* Extra Tabs */
/**************/
// tab: see also
$seeAlso = new QuestList(array(['name_loc' . User::$localeId, '%' . $this->name . '%'], ['id', $this->typeId, '!']));
if (!$seeAlso->error) {
$this->extendGlobalData($seeAlso->getJSGlobals());
$this->lvTabs[] = array('file' => 'quest', 'data' => $seeAlso->getListviewData(), 'params' => array('name' => '$LANG.tab_seealso', 'id' => 'see-also'));
}
// tab: criteria of
$criteriaOf = new AchievementList(array(['ac.type', ACHIEVEMENT_CRITERIA_TYPE_COMPLETE_QUEST], ['ac.value1', $this->typeId]));
if (!$criteriaOf->error) {
$this->extendGlobalData($criteriaOf->getJSGlobals());
$this->lvTabs[] = array('file' => 'achievement', 'data' => $criteriaOf->getListviewData(), 'params' => array('name' => '$LANG.tab_criteriaof', 'id' => 'criteria-of'));
}
// tab: conditions
$cnd = [];
if ($_ = $this->subject->getField('reqMinRepFaction')) {
$cnd[CND_SRC_QUEST_ACCEPT][$this->typeId][0][] = [CND_REPUTATION_RANK, $_, 1 << Util::getReputationLevelForPoints($this->subject->getField('reqMinRepValue'))];
$this->extendGlobalIds(TYPE_FACTION, $_);
}
if ($_ = $this->subject->getField('reqMaxRepFaction')) {
$cnd[CND_SRC_QUEST_ACCEPT][$this->typeId][0][] = [-CND_REPUTATION_RANK, $_, 1 << Util::getReputationLevelForPoints($this->subject->getField('reqMaxRepValue'))];
$this->extendGlobalIds(TYPE_FACTION, $_);
}
$_ = Util::getServerConditions([CND_SRC_QUEST_ACCEPT, CND_SRC_QUEST_SHOW_MARK], null, $this->typeId);
if (!empty($_[0])) {
// awkward merger
if (isset($_[0][CND_SRC_QUEST_ACCEPT][$this->typeId][0])) {
if (isset($cnd[CND_SRC_QUEST_ACCEPT][$this->typeId][0])) {
$cnd[CND_SRC_QUEST_ACCEPT][$this->typeId][0] = array_merge($cnd[CND_SRC_QUEST_ACCEPT][$this->typeId][0], $_[0][CND_SRC_QUEST_ACCEPT][$this->typeId][0]);
} else {
$cnd[CND_SRC_QUEST_ACCEPT] = $_[0][CND_SRC_QUEST_ACCEPT];
}
}
if (isset($_[0][CND_SRC_QUEST_SHOW_MARK])) {
$cnd[CND_SRC_QUEST_SHOW_MARK] = $_[0][CND_SRC_QUEST_SHOW_MARK];
}
$this->extendGlobalData($_[1]);
}
if ($cnd) {
$tab = "<script type=\"text/javascript\">\n" . "var markup = ConditionList.createTab(" . Util::toJSON($cnd) . ");\n" . "Markup.printHtml(markup, 'tab-conditions', { allow: Markup.CLASS_STAFF })" . "</script>";
$this->lvTabs[] = array('file' => null, 'data' => $tab, 'params' => array('id' => 'conditions', 'name' => '$LANG.requires'));
}
}
protected function generateContent()
{
$this->addJS('?data=zones&locale=' . User::$localeId . '&t=' . $_SESSION['dataKey']);
$_itemId = $this->subject->getField('itemId');
/***********/
/* Infobox */
/**********/
$infobox = Lang::getInfoBoxForFlags($this->subject->getField('cuFlags'));
if ($this->typeId == 103) {
// Arena Points
$infobox[] = Lang::currency('cap') . Lang::main('colon') . '10\'000';
} else {
if ($this->typeId == 104) {
// Honor
$infobox[] = Lang::currency('cap') . Lang::main('colon') . '75\'000';
}
}
/****************/
/* Main Content */
/****************/
$this->infobox = $infobox ? '[ul][li]' . implode('[/li][li]', $infobox) . '[/li][/ul]' : null;
$this->name = $this->subject->getField('name', true);
$this->headIcons = $this->typeId == 104 ? ['inv_bannerpvp_02', 'inv_bannerpvp_01'] : [$this->subject->getField('iconString')];
$this->redButtons = array(BUTTON_WOWHEAD => true, BUTTON_LINKS => true);
/**************/
/* Extra Tabs */
/**************/
if ($this->typeId != 103 && $this->typeId != 104) {
// tabs: this currency is contained in..
$lootTabs = new Loot();
if ($lootTabs->getByItem($_itemId)) {
$this->extendGlobalData($lootTabs->jsGlobals);
foreach ($lootTabs->iterate() as $tab) {
$this->lvTabs[] = array('file' => $tab[0], 'data' => $tab[1], 'params' => ['name' => $tab[2], 'id' => $tab[3], 'extraCols' => $tab[4] ? '$[' . implode(', ', array_unique($tab[4])) . ']' : null, 'hiddenCols' => $tab[5] ? '$[' . implode(', ', array_unique($tab[5])) . ']' : null, 'visibleCols' => $tab[6] ? '$' . Util::toJSON(array_unique($tab[6])) : null]);
}
}
// tab: sold by
$itemObj = new ItemList(array(['id', $_itemId]));
if (!empty($itemObj->getExtendedCost()[$_itemId])) {
$vendors = $itemObj->getExtendedCost()[$_itemId];
$this->extendGlobalData($itemObj->getJSGlobals(GLOBALINFO_SELF | GLOBALINFO_RELATED));
$soldBy = new CreatureList(array(['id', array_keys($vendors)]));
if (!$soldBy->error) {
$sbData = $soldBy->getListviewData();
$extraCols = ['Listview.extraCols.stock', "Listview.funcBox.createSimpleCol('stack', 'stack', '10%', 'stack')", 'Listview.extraCols.cost'];
$holidays = [];
foreach ($sbData as $k => &$row) {
$items = [];
$tokens = [];
foreach ($vendors[$k] as $id => $qty) {
if (is_string($id)) {
continue;
}
if ($id > 0) {
$tokens[] = [$id, $qty];
} else {
if ($id < 0) {
$items[] = [-$id, $qty];
}
}
}
if ($vendors[$k]['event']) {
if (count($extraCols) == 3) {
// not already pushed
$extraCols[] = 'Listview.extraCols.condition';
}
$this->extendGlobalIds(TYPE_WORLDEVENT, $vendors[$k]['event']);
$row['condition'][0][$this->typeId][] = [[CND_ACTIVE_EVENT, $vendors[$k]['event']]];
}
$row['stock'] = $vendors[$k]['stock'];
$row['stack'] = $itemObj->getField('buyCount');
$row['cost'] = array($itemObj->getField('buyPrice'), $items ? $items : null, $tokens ? $tokens : null);
}
$this->lvTabs[] = array('file' => 'creature', 'data' => $sbData, 'params' => ['name' => '$LANG.tab_soldby', 'id' => 'sold-by-npc', 'extraCols' => '$[' . implode(', ', $extraCols) . ']', 'hiddenCols' => "\$['level', 'type']"]);
}
}
}
// tab: created by (spell) [for items its handled in Loot::getByContainer()]
if ($this->typeId == 104) {
$createdBy = new SpellList(array(['effect1Id', 45], ['effect2Id', 45], ['effect3Id', 45], 'OR'));
if (!$createdBy->error) {
$this->extendGlobalData($createdBy->getJSGlobals(GLOBALINFO_SELF | GLOBALINFO_RELATED));
if ($createdBy->hasSetFields(['reagent1'])) {
$visCols = ['reagents'];
}
$this->lvTabs[] = array('file' => 'spell', 'data' => $createdBy->getListviewData(), 'params' => ['name' => '$LANG.tab_createdby', 'id' => 'created-by', 'visibleCols' => isset($visCols) ? '$' . Util::toJSON($visCols) : null]);
}
}
// tab: currency for
if ($this->typeId == 103) {
$n = '?items&filter=cr=145;crs=1;crv=0';
$w = 'reqArenaPoints > 0';
} else {
if ($this->typeId == 104) {
$n = '?items&filter=cr=144;crs=1;crv=0';
$w = 'reqHonorPoints > 0';
} else {
$n = in_array($this->typeId, [42, 61, 81, 241, 121, 122, 123, 125, 126, 161, 201, 101, 102, 221, 301, 341]) ? '?items&filter=cr=158;crs=' . $_itemId . ';crv=0' : null;
$w = 'reqItemId1 = ' . $_itemId . ' OR reqItemId2 = ' . $_itemId . ' OR reqItemId3 = ' . $_itemId . ' OR reqItemId4 = ' . $_itemId . ' OR reqItemId5 = ' . $_itemId;
}
}
$xCosts = DB::Aowow()->selectCol('SELECT id FROM ?_itemextendedcost WHERE ' . $w);
$boughtBy = $xCosts ? DB::World()->selectCol('SELECT item FROM npc_vendor WHERE extendedCost IN (?a) UNION SELECT item FROM game_event_npc_vendor WHERE extendedCost IN (?a)', $xCosts, $xCosts) : [];
if ($boughtBy) {
$boughtBy = new ItemList(array(['id', $boughtBy]));
if (!$boughtBy->error) {
if ($boughtBy->getMatches() <= CFG_SQL_LIMIT_DEFAULT) {
$n = null;
}
$this->lvTabs[] = array('file' => 'item', 'data' => $boughtBy->getListviewData(ITEMINFO_VENDOR, [TYPE_CURRENCY => $this->typeId]), 'params' => ['name' => '$LANG.tab_currencyfor', 'id' => 'currency-for', 'extraCols' => "\$[Listview.funcBox.createSimpleCol('stack', 'stack', '10%', 'stack')]", 'note' => $n ? sprintf(Util::$filterResultString, $n) : null]);
$this->extendGlobalData($boughtBy->getJSGlobals(GLOBALINFO_SELF | GLOBALINFO_RELATED));
}
}
}
protected function generateTooltip($asError = false)
{
if ($asError) {
return '$WowheadPower.registerObject(' . $this->typeId . ', ' . User::$localeId . ', {});';
}
$s = $this->subject->getSpawns(SPAWNINFO_SHORT);
$x = '$WowheadPower.registerObject(' . $this->typeId . ', ' . User::$localeId . ", {\n";
$x .= "\tname_" . User::$localeString . ": '" . Util::jsEscape($this->subject->getField('name', true)) . "',\n";
$x .= "\ttooltip_" . User::$localeString . ": '" . Util::jsEscape($this->subject->renderTooltip()) . "',\n";
$x .= "\tmap: " . ($s ? "{zone: " . $s[0] . ", coords: {" . $s[1] . ":" . Util::toJSON($s[2]) . "}}" : '{}') . "\n";
$x .= "});";
return $x;
}
<?php
foreach ($this->announcements as $id => $data) {
?>
<div id="announcement-<?php
echo $id;
?>
"></div>
<script type="text/javascript">
new Announcement(<?php
echo Util::toJSON($data);
?>
);
</script>
<?php
}
private function _searchTalent($cndBase)
{
$result = [];
$cnd = array_merge($cndBase, array(['s.typeCat', [-7, -2]], $this->createLookup()));
$talents = new SpellList($cnd);
if ($data = $talents->getListviewData()) {
if ($this->searchMask & SEARCH_TYPE_REGULAR) {
$this->extendGlobalData($talents->getJSGlobals());
}
$vis = ['level', 'singleclass', 'schools'];
if ($talents->hasSetFields(['reagent1'])) {
$vis[] = 'reagents';
}
if ($this->searchMask & SEARCH_TYPE_OPEN) {
foreach ($talents->iterate() as $__) {
$data[$talents->id]['param1'] = strToLower($talents->getField('iconString'));
$data[$talents->id]['param2'] = $talents->ranks[$talents->id];
}
}
$result = array('type' => TYPE_SPELL, 'appendix' => ' (Talent)', 'matches' => $talents->getMatches(), 'file' => SpellList::$brickFile, 'data' => $data, 'params' => ['id' => 'talents', 'name' => '$LANG.tab_talents', 'visibleCols' => '$' . Util::toJSON($vis)]);
if ($talents->getMatches() > $this->maxResults) {
$result['params']['note'] = sprintf(Util::$tryNarrowingString, 'LANG.lvnote_talentsfound', $talents->getMatches(), $this->maxResults);
$result['params']['_truncated'] = 1;
}
if (isset($result['params']['note'])) {
$result['params']['note'] .= ' + LANG.dash + $WH.sprintf(LANG.lvnote_filterresults, \'?spells=-2&filter=na=' . urlencode($this->search) . '\')';
} else {
$result['params']['note'] = '$$WH.sprintf(LANG.lvnote_filterresults, \'?spells=-2&filter=na=' . urlencode($this->search) . '\')';
}
}
return $result;
}
echo STATIC_URL . '/js/Markup.js?' . AOWOW_REVISION;
?>
" type="text/javascript"></script>
<?php
if (User::isInGroup(U_GROUP_STAFF | U_GROUP_SCREENSHOT | U_GROUP_VIDEO)) {
echo ' <script src="' . STATIC_URL . '/js/staff.js?' . AOWOW_REVISION . "\" type=\"text/javascript\"></script>\n";
}
foreach ($this->js as $js) {
if (!empty($js)) {
echo ' <script src="' . ($js[0] == '?' ? $js . '&' : STATIC_URL . '/js/' . $js . '?') . AOWOW_REVISION . "\" type=\"text/javascript\"></script>\n";
}
}
?>
<script type="text/javascript">
var g_user = <?php
echo Util::toJSON($this->gUser, JSON_UNESCAPED_UNICODE);
?>
;
</script>
<?php
if (CFG_ANALYTICS_USER) {
?>
<script>
(function(i,s,o,g,r,a,m){i['GoogleAnalyticsObject']=r;i[r]=i[r]||function(){
(i[r].q=i[r].q||[]).push(arguments)},i[r].l=1*new Date();a=s.createElement(o),
m=s.getElementsByTagName(o)[0];a.async=1;a.src=g;m.parentNode.insertBefore(a,m)
})(window,document,'script','//www.google-analytics.com/analytics.js','ga');
ga('create', '<?php
echo CFG_ANALYTICS_USER;
?>
protected function generateContent()
{
$this->addJS('?data=weight-presets&locale=' . User::$localeId . '&t=' . $_SESSION['dataKey']);
$conditions = [];
if (!User::isInGroup(U_GROUP_EMPLOYEE)) {
$conditions[] = [['cuFlags', CUSTOM_EXCLUDE_FOR_LISTVIEW, '&'], 0];
}
/*******************/
/* evaluate filter */
/*******************/
// recreate form selection (must be evaluated first via getConditions())
if ($_ = $this->filterObj->getConditions()) {
$conditions[] = $_;
}
$this->filter = array_merge($this->filterObj->getForm('form'), $this->filter);
$this->filter['query'] = isset($_GET['filter']) ? $_GET['filter'] : null;
$this->filter['fi'] = $this->filterObj->getForm();
$menu = $this->createExtraMenus();
foreach ($menu['type'][0] as $k => $str) {
if ($str && (!$menu['type'][1] || $menu['type'][1] & 1 << $k)) {
$this->filter['type'][$k] = $str;
}
}
foreach ($menu['slot'][0] as $k => $str) {
if ($str && (!$menu['slot'][1] || $menu['slot'][1] & 1 << $k)) {
$this->filter['slot'][$k] = $str;
}
}
if (isset($this->filter['slot'][INVTYPE_SHIELD])) {
// "Off Hand" => "Shield"
$this->filter['slot'][INVTYPE_SHIELD] = Lang::item('armorSubClass', 6);
}
$xCols = $this->filterObj->getForm('extraCols', true);
$infoMask = ITEMINFO_JSON;
if (array_intersect([63, 64, 125], $xCols)) {
// 63:buyPrice; 64:sellPrice; 125:reqarenartng
$infoMask |= ITEMINFO_VENDOR;
}
if (!empty($this->filter['fi']['extraCols'])) {
$this->sharedLV['extraCols'] = '$fi_getExtraCols(fi_extraCols, ' . (isset($this->filter['gm']) ? $this->filter['gm'] : 0) . ', ' . (array_intersect([63], $xCols) ? 1 : 0) . ')';
}
if ($this->filterObj->error) {
$this->sharedLV['_errors'] = '$1';
}
/******************/
/* set conditions */
/******************/
if (isset($this->category[0])) {
$conditions[] = ['i.class', $this->category[0]];
}
if (isset($this->category[1])) {
$conditions[] = ['i.subClass', $this->category[1]];
}
if (isset($this->category[2])) {
$conditions[] = ['i.subSubClass', $this->category[2]];
}
/***********************/
/* handle auto-gemming */
/***********************/
$this->gemScores = $this->createGemScores();
/*************************/
/* handle upgrade search */
/*************************/
$upgItemData = [];
if (!empty($this->filter['upg']) && !empty($this->filter['fi']['setWeights'])) {
$upgItems = new ItemList(array(['id', array_keys($this->filter['upg'])]), ['extraOpts' => $this->filterObj->extraOpts]);
if (!$upgItems->error) {
$this->extendGlobalData($upgItems->getJSGlobals());
$upgItemData = $upgItems->getListviewData($infoMask);
}
}
if ($upgItemData) {
$singleSlot = true;
$ref = reset($this->filter['upg']);
foreach ($this->filter['upg'] as $slot) {
if ($slot == $ref) {
continue;
}
$singleSlot = false;
break;
}
if ($singleSlot && empty($this->filter['gb'])) {
// enforce group by slot
$this->filter['gb'] = 1;
} else {
if (!$singleSlot) {
$this->filter['gb'] = 1;
$maxResults = 25;
$this->sharedLV['customFilter'] = '$fi_filterUpgradeListview';
}
}
}
/********************************************************************************************************************************/
/* group by */
/* */
/* cases that make sense: */
/* no upgItems -> everything goes */
/* 1 upgItems OR */
/* N upgItems (same slot) -> gb:none - disabled */
/* -> gb:slot - limited to slot of the upgItems (in theory weapons create a tab for each weapon type) */
/* -> gb:level - upgItems is added to all tabs */
/* -> gb:source - upgItems is added to all tabs */
/* N upgItems (random) -> gb:none - disabled */
/* -> gb:slot - only slots existing within the upgItems; match upgItems to slot */
/* -> gb:level - disabled */
/* -> gb:source - disabled */
/********************************************************************************************************************************/
$availableSlots = array(ITEM_CLASS_ARMOR => [INVTYPE_HEAD, INVTYPE_NECK, INVTYPE_SHOULDERS, INVTYPE_CHEST, INVTYPE_WAIST, INVTYPE_LEGS, INVTYPE_FEET, INVTYPE_WRISTS, INVTYPE_HANDS, INVTYPE_FINGER, INVTYPE_TRINKET, INVTYPE_SHIELD, INVTYPE_CLOAK], ITEM_CLASS_WEAPON => [INVTYPE_WEAPON, INVTYPE_RANGED, INVTYPE_2HWEAPON, INVTYPE_WEAPONMAINHAND, INVTYPE_WEAPONOFFHAND, INVTYPE_THROWN, INVTYPE_HOLDABLE]);
$groups = [];
$nameSource = [];
$grouping = isset($this->filter['gb']) ? $this->filter['gb'] : null;
$extraOpts = [];
$maxResults = CFG_SQL_LIMIT_DEFAULT;
switch ($grouping) {
// slot: (try to limit the lookups by class grouping and intersecting with preselected slots)
// if intersect yields an empty array no lookups will occur
case 1:
if (isset($this->category[0]) && $this->category[0] == ITEM_CLASS_ARMOR) {
$groups = $availableSlots[ITEM_CLASS_ARMOR];
} else {
if (isset($this->category[0]) && $this->category[0] == ITEM_CLASS_WEAPON) {
$groups = $availableSlots[ITEM_CLASS_WEAPON];
} else {
$groups = array_merge($availableSlots[ITEM_CLASS_ARMOR], $availableSlots[ITEM_CLASS_WEAPON]);
}
}
if (isset($this->filter['sl'])) {
// skip lookups for unselected slots
$groups = array_intersect($groups, (array) $this->filter['sl']);
}
if (isset($this->filter['upg'])) {
// skip lookups for slots we dont have items to upgrade for
$groups = array_intersect($groups, (array) $this->filter['upg']);
}
if ($groups) {
$nameSource = Lang::item('inventoryType');
$this->forceTabs = true;
}
break;
case 2:
// itemlevel: first, try to find 10 level steps within range (if given) as tabs
// ohkayy, maybe i need to rethink $this
$this->filterOpts = $this->filterObj->extraOpts;
$this->filterOpts['is']['o'] = [null];
// remove 'order by' from itemStats
$extraOpts = array_merge($this->filterOpts, ['i' => ['g' => ['itemlevel'], 'o' => ['itemlevel DESC']]]);
$levelRef = new ItemList(array_merge($conditions, [10]), ['extraOpts' => $extraOpts]);
foreach ($levelRef->iterate() as $_) {
$l = $levelRef->getField('itemLevel');
$groups[] = $l;
$nameSource[$l] = Lang::game('level') . ' ' . $l;
}
if ($groups) {
$l = -end($groups);
$groups[] = $l;
// push last value as negativ to signal misc group after $this level
$extraOpts = ['i' => ['o' => ['itemlevel DESC']]];
$nameSource[$l] = Lang::item('tabOther');
$this->forceTabs = true;
}
break;
case 3:
// source
$groups = [1, 2, 3, 4, 5, 10, 11, 12, 0];
$nameSource = Lang::game('sources');
$this->forceTabs = true;
break;
// none
// none
default:
$grouping = 0;
$groups[0] = null;
}
/*****************************/
/* create lv-tabs for groups */
/*****************************/
foreach ($groups as $group) {
switch ($grouping) {
case 1:
$finalCnd = array_merge($conditions, [['slot', $group], $maxResults]);
break;
case 2:
$finalCnd = array_merge($conditions, [['itemlevel', abs($group), $group > 0 ? null : '<'], $maxResults]);
break;
case 3:
$finalCnd = array_merge($conditions, [$group ? ['src.src' . $group, null, '!'] : ['src.typeId', null], $maxResults]);
break;
default:
$finalCnd = $conditions;
}
$items = new ItemList($finalCnd, ['extraOpts' => array_merge($extraOpts, $this->filterObj->extraOpts)]);
if ($items->error) {
continue;
}
$this->extendGlobalData($items->getJSGlobals());
$tab = array('file' => 'item', 'data' => $items->getListviewData($infoMask), 'params' => $this->sharedLV);
$upg = [];
if ($upgItemData) {
if ($grouping == 1) {
$upg = array_keys(array_filter($this->filter['upg'], function ($v) use($group) {
return $v == $group;
}));
foreach ($upg as $uId) {
$tab['data'][$uId] = $upgItemData[$uId];
}
if ($upg) {
$tab['params']['_upgradeIds'] = '$' . Util::toJSON($upg);
}
} else {
if ($grouping) {
$upg = array_keys($this->filter['upg']);
$tab['params']['_upgradeIds'] = '$' . Util::toJSON($upg);
foreach ($upgItemData as $uId => $data) {
// using numeric keys => cant use array_merge
$tab['data'][$uId] = $data;
}
}
}
}
if ($grouping) {
switch ($grouping) {
case 1:
$tab['params']['id'] = 'slot-' . $group;
break;
case 2:
$tab['params']['id'] = $group > 0 ? 'level-' . $group : 'other';
break;
case 3:
$tab['params']['id'] = $group ? 'source-' . $group : 'unknown';
break;
}
$tab['params']['name'] = $nameSource[$group];
$tab['params']['tabs'] = '$tabsGroups';
}
if (!empty($this->filter['fi']['setWeights'])) {
if ($items->hasSetFields(['armor'])) {
$tab['params']['visibleCols'][] = 'armor';
}
}
// create note if search limit was exceeded; overwriting 'note' is intentional
if ($items->getMatches() > $maxResults && count($groups) > 1) {
$tab['params']['_truncated'] = 1;
$cls = isset($this->category[0]) ? '=' . $this->category[0] : '';
$override = ['gb' => ''];
if ($upg) {
$override['upg'] = implode(':', $upg);
}
switch ($grouping) {
case 1:
$override['sl'] = $group;
$tab['params']['note'] = '$$WH.sprintf(LANG.lvnote_viewmoreslot, \'' . $cls . '\', \'' . $this->filterObj->urlize($override) . '\')';
break;
case 2:
if ($group > 0) {
$override['minle'] = $group;
$override['maxle'] = $group;
} else {
$override['maxle'] = abs($group) - 1;
}
$tab['params']['note'] = '$$WH.sprintf(LANG.lvnote_viewmorelevel, \'' . $cls . '\', \'' . $this->filterObj->urlize($override) . '\')';
break;
case 3:
if ($_ = [null, 3, 4, 5, 6, 7, 9, 10, 11][$group]) {
$tab['params']['note'] = '$$WH.sprintf(LANG.lvnote_viewmoresource, \'' . $cls . '\', \'' . $this->filterObj->urlize($override, ['cr' => 128, 'crs' => $_, 'crv' => 0]) . '\')';
}
break;
}
} else {
if ($items->getMatches() > $maxResults) {
$tab['params']['note'] = sprintf(Util::$tryFilteringString, 'LANG.lvnote_itemsfound', $items->getMatches(), CFG_SQL_LIMIT_DEFAULT);
$tab['params']['_truncated'] = 1;
}
}
if (!empty($tab['params']['hiddenCols'])) {
$tab['params']['hiddenCols'] = '$' . Util::toJSON($tab['params']['hiddenCols']);
}
if (!empty($tab['params']['visibleCols'])) {
$tab['params']['visibleCols'] = '$' . Util::toJSON($tab['params']['visibleCols']);
}
foreach ($tab['params'] as $k => $p) {
if (!$p) {
unset($tab['params'][$k]);
}
}
if ($grouping) {
$tab['params']['hideCount'] = '$1';
}
$this->lvTabs[] = $tab;
}
// reformat for use in template
if (isset($this->filter['upg'])) {
$this->filter['upg'] = implode(':', array_keys($this->filter['upg']));
}
// whoops, we have no data? create emergency content
if (empty($this->lvTabs)) {
$this->forceTabs = false;
$this->lvTabs[] = ['file' => 'item', 'data' => [], 'params' => []];
}
// sort for dropdown-menus
Lang::sort('game', 'ra');
Lang::sort('game', 'cl');
}
function profiler()
{
$success = true;
$scripts = [];
/**********/
/* Quests */
/**********/
$scripts[] = function () {
$success = true;
$condition = [CFG_SQL_LIMIT_NONE, 'AND', [['cuFlags', CUSTOM_EXCLUDE_FOR_LISTVIEW], 0], [['flags', QUEST_FLAG_DAILY | QUEST_FLAG_WEEKLY | QUEST_FLAG_REPEATABLE | QUEST_FLAG_AUTO_REWARDED, '&'], 0], [['specialFlags', QUEST_FLAG_SPECIAL_REPEATABLE | QUEST_FLAG_SPECIAL_DUNGEON_FINDER | QUEST_FLAG_SPECIAL_MONTHLY, '&'], 0]];
$questz = new QuestList($condition);
$_ = [];
$currencies = array_column($questz->rewards, TYPE_CURRENCY);
foreach ($currencies as $curr) {
foreach ($curr as $cId => $qty) {
$_[] = $cId;
}
}
$relCurr = new CurrencyList(array(['id', $_]));
foreach (CLISetup::$localeIds as $l) {
set_time_limit(20);
User::useLocale($l);
Lang::load(Util::$localeStrings[$l]);
$buff = "var _ = g_gatheredcurrencies;\n";
foreach ($relCurr->getListviewData() as $id => $data) {
$buff .= '_[' . $id . '] = ' . Util::toJSON($data) . ";\n";
}
$buff .= "\n\nvar _ = g_quests;\n";
foreach ($questz->getListviewData() as $id => $data) {
$buff .= '_[' . $id . '] = ' . Util::toJSON($data) . ";\n";
}
$buff .= "\ng_quest_catorder = [0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10];\n";
if (!CLISetup::writeFile('datasets/' . User::$localeString . '/p-quests', $buff)) {
$success = false;
}
}
return $success;
};
/****************/
/* Achievements */
/****************/
$scripts[] = function () {
$success = true;
$condition = array(CFG_SQL_LIMIT_NONE, [['cuFlags', CUSTOM_EXCLUDE_FOR_LISTVIEW, '&'], 0], [['flags', 1, '&'], 0]);
$achievez = new AchievementList($condition);
foreach (CLISetup::$localeIds as $l) {
set_time_limit(5);
User::useLocale($l);
Lang::load(Util::$localeStrings[$l]);
$sumPoints = 0;
$buff = "var _ = g_achievements;\n";
foreach ($achievez->getListviewData(ACHIEVEMENTINFO_PROFILE) as $id => $data) {
$sumPoints += $data['points'];
$buff .= '_[' . $id . '] = ' . Util::toJSON($data) . ";\n";
}
// categories to sort by
$buff .= "\ng_achievement_catorder = [92, 14863, 97, 169, 170, 171, 172, 14802, 14804, 14803, 14801, 95, 161, 156, 165, 14806, 14921, 96, 201, 160, 14923, 14808, 14805, 14778, 14865, 14777, 14779, 155, 14862, 14861, 14864, 14866, 158, 162, 14780, 168, 14881, 187, 14901, 163, 14922, 159, 14941, 14961, 14962, 14981, 15003, 15002, 15001, 15041, 15042, 81]";
// sum points
$buff .= "\ng_achievement_points = [" . $sumPoints . "];\n";
if (!CLISetup::writeFile('datasets/' . User::$localeString . '/p-achievements', $buff)) {
$success = false;
}
}
return $success;
};
/**********/
/* Titles */
/**********/
$scripts[] = function () {
$success = true;
$condition = array(CFG_SQL_LIMIT_NONE, [['cuFlags', CUSTOM_EXCLUDE_FOR_LISTVIEW, '&'], 0]);
$titlez = new TitleList($condition);
foreach (CLISetup::$localeIds as $l) {
set_time_limit(5);
User::useLocale($l);
Lang::load(Util::$localeStrings[$l]);
foreach ([0, 1] as $g) {
$buff = "var _ = g_titles;\n";
foreach ($titlez->getListviewData() as $id => $data) {
$data['name'] = Util::localizedString($titlez->getEntry($id), $g ? 'female' : 'male');
unset($data['namefemale']);
$buff .= '_[' . $id . '] = ' . Util::toJSON($data) . ";\n";
}
if (!CLISetup::writeFile('datasets/' . User::$localeString . '/p-titles-' . $g, $buff)) {
$success = false;
}
}
}
return $success;
};
/**********/
/* Mounts */
/**********/
$scripts[] = function () {
$success = true;
$condition = array(CFG_SQL_LIMIT_NONE, [['cuFlags', CUSTOM_EXCLUDE_FOR_LISTVIEW, '&'], 0], ['typeCat', -5]);
$mountz = new SpellList($condition);
foreach (CLISetup::$localeIds as $l) {
set_time_limit(5);
User::useLocale($l);
Lang::load(Util::$localeStrings[$l]);
$buff = "var _ = g_spells;\n";
foreach ($mountz->getListviewData(ITEMINFO_MODEL) as $id => $data) {
$data['quality'] = $data['name'][0];
$data['name'] = mb_substr($data['name'], 1);
$buff .= '_[' . $id . '] = ' . Util::toJSON($data) . ";\n";
}
if (!CLISetup::writeFile('datasets/' . User::$localeString . '/p-mounts', $buff)) {
$success = false;
}
}
return $success;
};
/**************/
/* Companions */
/**************/
$scripts[] = function () {
$success = true;
$condition = array(CFG_SQL_LIMIT_NONE, [['cuFlags', CUSTOM_EXCLUDE_FOR_LISTVIEW, '&'], 0], ['typeCat', -6]);
$companionz = new SpellList($condition);
foreach (CLISetup::$localeIds as $l) {
set_time_limit(5);
User::useLocale($l);
Lang::load(Util::$localeStrings[$l]);
$buff = "var _ = g_spells;\n";
foreach ($companionz->getListviewData(ITEMINFO_MODEL) as $id => $data) {
$data['quality'] = $data['name'][0];
$data['name'] = mb_substr($data['name'], 1);
$buff .= '_[' . $id . '] = ' . Util::toJSON($data) . ";\n";
}
if (!CLISetup::writeFile('datasets/' . User::$localeString . '/p-companions', $buff)) {
$success = false;
}
}
return $success;
};
/************/
/* Factions */
/************/
$scripts[] = function () {
$success = true;
$condition = array(CFG_SQL_LIMIT_NONE, [['cuFlags', CUSTOM_EXCLUDE_FOR_LISTVIEW, '&'], 0]);
$factionz = new FactionList($condition);
foreach (CLISetup::$localeIds as $l) {
set_time_limit(5);
User::useLocale($l);
Lang::load(Util::$localeStrings[$l]);
$buff = "var _ = g_factions;\n";
foreach ($factionz->getListviewData() as $id => $data) {
$buff .= '_[' . $id . '] = ' . Util::toJSON($data) . ";\n";
}
$buff .= "\ng_faction_order = [0, 469, 891, 1037, 1118, 67, 1052, 892, 936, 1117, 169, 980, 1097];\n";
if (!CLISetup::writeFile('datasets/' . User::$localeString . '/p-factions', $buff)) {
$success = false;
}
}
return $success;
};
/***********/
/* Recipes */
/***********/
$scripts[] = function () {
// special case: secondary skills are always requested, so put them in one single file (185, 129, 356); it also contains g_skill_order
$skills = [171, 164, 333, 202, 182, 773, 755, 165, 186, 393, 197, [185, 129, 356]];
$success = true;
$baseCnd = array(CFG_SQL_LIMIT_NONE, [['cuFlags', CUSTOM_EXCLUDE_FOR_LISTVIEW, '&'], 0], ['effect1Id', [6, 45, 57, 127, 33, 158, 99, 28, 95], '!'], ['effect2Id', [118, 60], '!'], ['OR', ['typeCat', 9], ['typeCat', 11]]);
foreach ($skills as $s) {
$file = is_array($s) ? 'sec' : (string) $s;
$cnd = array_merge($baseCnd, [['skillLine1', $s]]);
$recipez = new SpellList($cnd);
$created = '';
foreach ($recipez->iterate() as $__) {
foreach ($recipez->canCreateItem() as $idx) {
$id = $recipez->getField('effect' . $idx . 'CreateItemId');
$created .= "g_items.add(" . $id . ", {'icon':'" . $recipez->relItems->getEntry($id)['iconString'] . "'});\n";
}
}
foreach (CLISetup::$localeIds as $l) {
set_time_limit(10);
User::useLocale($l);
Lang::load(Util::$localeStrings[$l]);
$buff = '';
foreach ($recipez->getListviewData() as $id => $data) {
$buff .= '_[' . $id . '] = ' . Util::toJSON($data) . ";\n";
}
if (!$buff) {
// this behaviour is intended, do not create an error
CLISetup::log('profiler - file datasets/' . User::$localeString . '/p-recipes-' . $file . ' has no content => skipping', CLISetup::LOG_WARN);
continue;
}
$buff = $created . "\nvar _ = g_spells;\n" . $buff;
if (is_array($s)) {
$buff .= "\ng_skill_order = [171, 164, 333, 202, 182, 773, 755, 165, 186, 393, 197, 185, 129, 356];\n";
}
if (!CLISetup::writeFile('datasets/' . User::$localeString . '/p-recipes-' . $file, $buff)) {
$success = false;
}
}
}
return $success;
};
// check directory-structure
foreach (Util::$localeStrings as $dir) {
if (!CLISetup::writeDir('datasets/' . $dir)) {
$success = false;
}
}
// run scripts
foreach ($scripts as $func) {
if (!$func()) {
$success = false;
}
}
return $success;
}
protected function ssManage()
{
$res = [];
if ($this->_get['type'] && $this->_get['type'] && $this->_get['typeid'] && $this->_get['typeid']) {
$res = CommunityContent::getScreenshotsForManager($this->_get['type'], $this->_get['typeid']);
} else {
if ($this->_get['user']) {
if ($uId = DB::Aowow()->selectCell('SELECT id FROM ?_account WHERE displayName = ?', $this->_get['user'])) {
$res = CommunityContent::getScreenshotsForManager(0, 0, $uId);
}
}
}
return 'ssm_screenshotData = ' . Util::toJSON($res);
}
$this->brick('infobox');
?>
<div class="text">
<h1><?php
echo $this->name;
?>
</h1>
<span><?php
echo Lang::screenshot('cropHint');
?>
</span>
<div class="pad"></div>
<div id="ss-container"></div><script type="text/javascript">//<![CDATA[
var myCropper = new Cropper(<?php
echo Util::toJSON($this->cropper);
?>
);
//]]></script>
<div class="pad"></div>
<button style="margin:4px 0 0 5px" onclick="myCropper.selectAll()"><?php
echo Lang::screenshot('selectAll');
?>
</button>
<div class="clear"></div>
<div class="pad3"></div>
<form action="?screenshot=complete&<?php
echo $this->destType . '.' . $this->destTypeId . '.' . $this->imgHash;
public function writeGlobalVars()
{
$buff = '';
foreach ($this->jsGlobals as $type => $struct) {
$buff .= " var _ = " . $struct[0] . ';';
foreach ($struct[1] as $key => $data) {
foreach ($data as $k => $v) {
// localizes expected fields
if (in_array($k, ['name', 'namefemale'])) {
$data[$k . '_' . User::$localeString] = $v;
unset($data[$k]);
}
}
$buff .= ' _[' . (is_numeric($key) ? $key : "'" . $key . "'") . "]=" . Util::toJSON($data) . ';';
}
$buff .= "\n";
if (!empty($this->typeId) && !empty($struct[2][$this->typeId])) {
$x = $struct[2][$this->typeId];
// spell
if (!empty($x['tooltip'])) {
// spell + item
$buff .= "\n _[" . $x['id'] . '].tooltip_' . User::$localeString . ' = ' . Util::toJSON($x['tooltip']) . ";\n";
}
if (!empty($x['buff'])) {
// spell
$buff .= " _[" . $x['id'] . '].buff_' . User::$localeString . ' = ' . Util::toJSON($x['buff']) . ";\n";
}
if (!empty($x['spells'])) {
// spell + item
$buff .= " _[" . $x['id'] . '].spells_' . User::$localeString . ' = ' . Util::toJSON($x['spells']) . ";\n";
}
if (!empty($x['buffspells'])) {
// spell
$buff .= " _[" . $x['id'] . '].buffspells_' . User::$localeString . ' = ' . Util::toJSON($x['buffspells']) . ";\n";
}
$buff .= "\n";
}
}
return $buff;
}
} else {
// does not appear as announcement, those have already been handled at this point
trigger_error('requested undefined listview: ' . $lv[0], E_USER_ERROR);
}
} elseif ($isTabbed) {
$n = $lv[1]['name'][0] == '$' ? substr($lv[1]['name'], 1) : "'" . $lv[1]['name'] . "'";
echo $tabVar . ".add(" . $n . ", { id: '" . $lv[1]['id'] . "' });\n";
}
}
}
if (!empty($this->user)) {
if (!empty($this->user['characterData'])) {
echo ' us_addCharactersTab(' . Util::toJSON($this->user['characterData']) . ");\n";
}
if (!empty($this->user['profileData'])) {
echo ' us_addProfilesTab(' . Util::toJSON($this->user['profileData']) . ");\n";
}
} elseif ($relTabs) {
?>
new Listview({template: 'comment', id: 'comments', name: LANG.tab_comments, tabs: <?php
echo $tabVar;
?>
, parent: 'lv-generic', data: lv_comments});
new Listview({template: 'screenshot', id: 'screenshots', name: LANG.tab_screenshots, tabs: <?php
echo $tabVar;
?>
, parent: 'lv-generic', data: lv_screenshots});
if (lv_videos.length || (g_user && g_user.roles & (U_GROUP_ADMIN | U_GROUP_BUREAU | U_GROUP_VIDEO)))
new Listview({template: 'video', id: 'videos', name: LANG.tab_videos, tabs: <?php
echo $tabVar;
?>
