function getPointData($area_id, &$data, $x, $y)
{
global $gZoneToAreaImage, $lang;
$area = getAreaIdFromPoint($data['map'], $data['position_x'], $data['position_y'], $data['position_z']);
$area_data = getArea($area);
if (!$area_data) {
return 0;
}
$zone = @$area_data['zone_id'] ? $area_data['zone_id'] : $area;
$areaname = $area_data['zone_id'] ? getAreaName($zone) . " (" . $area_data['name'] . ")" : $area_data['name'];
$img = 'images/map_points/';
$img .= $gZoneToAreaImage[$zone] == $area_id ? 'gps_icon.png' : 'gps_icon1.png';
$imgX = 16;
$imgY = 16;
$name = '';
if (@$data['type'] == 'n') {
$text = getCreatureName($data['id'], 0) . " ({$data['guid']})<br>{$areaname}<br>{$lang['respawn']} " . getTimeText($data['spawntimesecs']);
if (getCreatureEvent($data['guid']) > 0) {
$text = substr_replace("<br>{$lang['spawn_at_event']} - " . getGameEventName(getCreatureEvent($data['guid'])), $text, 0, 0);
}
if (getCreatureEvent($data['guid']) < 0) {
$text = substr_replace("<br>{$lang['despawn_at_event']} - " . getGameEventName(abs(getCreatureEvent($data['guid']))), $text, 0, 0);
}
if (getCreaturePool($data['guid'])) {
$text = substr_replace("<br>{$lang['pool']} (" . getCreaturePool($data['guid']) . ")", $text, 0, 0);
}
if (getCreaturePoolTemplate($data['id'])) {
$text = substr_replace("<br>{$lang['pool']} (" . getCreaturePoolTemplate($data['id']) . ")", $text, 0, 0);
}
}
if (@$data['type'] == 'o') {
$text = getGameobjectName($data['id'], 0) . " ({$data['guid']})<br>{$areaname}<br>{$lang['respawn']} " . getTimeText($data['spawntimesecs']);
if (getGameobjectEvent($data['guid']) > 0) {
$text = substr_replace("<br>{$lang['spawn_at_event']} - " . getGameEventName(getGameobjectEvent($data['guid'])), $text, 0, 0);
}
if (getGameobjectEvent($data['guid']) < 0) {
$text = substr_replace("<br>{$lang['despawn_at_event']} - " . getGameEventName(abs(getGameobjectEvent($data['guid']))), $text, 0, 0);
}
if (getGameobjectPool($data['guid'])) {
$text = substr_replace("<br>{$lang['pool']} (" . getGameobjectPool($data['guid']) . ")", $text, 0, 0);
}
if (getGameobjectPoolTemplate($data['id'])) {
$text = substr_replace("<br>{$lang['pool']} (" . getGameobjectPoolTemplate($data['id']) . ")", $text, 0, 0);
}
}
return array('id' => $data['id'], 'x' => $y, 'y' => $x, 'imgX' => $imgX, 'imgY' => $imgY, 'image' => $img, 'href' => "", 'tooltip' => $text);
}
$weekly_quest_dateSql = $cDB->selectCell("-- CACHE: 1h\n SELECT `NextWeeklyQuestResetTime` FROM `saved_variables`");
$monthly_quest_dateSql = $cDB->selectCell("-- CACHE: 1h\n SELECT `NextMonthlyQuestResetTime` FROM `saved_variables`");
$ap_date = date("H:i:s d.m.Y", $ap_dateSql);
$daily_quest_date = date("H:i:s d.m.Y", $daily_quest_dateSql);
$weekly_quest_date = date("H:i:s d.m.Y", $weekly_quest_dateSql);
$monthly_quest_date = date("H:i:s d.m.Y", $monthly_quest_dateSql);
echo "<table class=report width=100%>";
echo "<tr><td colspan=2 class=head>" . $lang['stat_timers'] . "</td></tr>";
echo "<tr><td>" . $lang['ap_date'] . "</td><td>" . $ap_date . "</td></tr>";
echo "<tr><td>" . $lang['daily_quest_date'] . "</td><td>" . $daily_quest_date . "</td></tr>";
echo "<tr><td>" . $lang['weekly_quest_date'] . "</td><td>" . $weekly_quest_date . "</td></tr>";
echo "<tr><td>" . $lang['monthly_quest_date'] . "</td><td>" . $monthly_quest_date . "</td></tr>";
if ($ae = getGameEventActive()) {
echo "<tr><td colspan=2 class=head>" . $lang['active_event'] . "</td></tr>";
foreach ($ae as $ae1) {
if (getGameEventActiveName($ae1['event'])) {
echo "<tr><td colspan=2>" . getGameEventName($ae1['event']) . "</td></tr>";
}
}
}
echo "</table>";
if (onoff_realm()) {
if ($number <= 0) {
echo $lang['online_no_players'];
} else {
$list->createReport($number . ' ' . $lang['online_players']);
}
} else {
echo $lang['offline'];
}
}
echo "{$lang['quest_level']} {$quest['QuestLevel']}<br>";
if ($quest['RequiredSkill']) {
echo "<a style='float: right;' href=\"?s=q&SkillID=" . $quest['RequiredSkill'] . "\">" . getSkillName($quest['RequiredSkill'], 0) . " ({$quest['RequiredSkillValue']})</a>";
}
if ($quest['MinLevel']) {
echo "{$lang['obtained_at_level']} {$quest['MinLevel']}</td></tr>";
}
if ($quest['SuggestedPlayers']) {
echo "<tr><td>{$lang['suggestedplayers']} <b>{$quest['SuggestedPlayers']}</b></td></tr>";
}
if ($quest['LimitTime']) {
echo '<tr><td>' . $lang['qlimittime'] . ' ' . getTimeText($quest['LimitTime']) . '</td></tr>';
}
if (getGameEventQuest($quest['entry'])) {
$qevent = getGameEventQuest($quest['entry']);
echo '<tr><td>' . $lang['obtained_at_event'] . ': <FONT color=#E614E6>' . getGameEventName($qevent) . '</FONT></td></tr>';
}
if ($quest['SpecialFlags'] & QUEST_SPECIAL_FLAG_MONTHLY) {
echo "<tr><td>{$lang['item_type']}: <a href=\"?s=q&Sfm=" . $quest['SpecialFlags'] . "\">" . $lang['quest_type3'] . "</a></td></tr>";
}
if ($quest['QuestFlags'] & QUEST_FLAGS_WEEKLY) {
echo "<tr><td>{$lang['item_type']}: <a href=\"?s=q&Sfw=" . $quest['QuestFlags'] . "\">" . $lang['quest_type2'] . "</a></td></tr>";
}
if ($quest['QuestFlags'] & QUEST_FLAGS_DAILY) {
echo "<tr><td>{$lang['item_type']}: <a href=\"?s=q&Sfd=" . $quest['QuestFlags'] . "\">" . $lang['quest_type1'] . "</a></td></tr>";
}
if ($quest['SpecialFlags'] & QUEST_SPECIAL_FLAG_REPEATABLE && ($quest['SpecialFlags'] & QUEST_SPECIAL_FLAG_MONTHLY) == 0 && ($quest['QuestFlags'] & (QUEST_FLAGS_DAILY | QUEST_FLAGS_WEEKLY)) == 0) {
echo "<tr><td>{$lang['item_type']}: <a href=\"?s=q&Sfr=" . $quest['SpecialFlags'] . "\">" . $lang['quest_type0'] . "</a></td></tr>";
}
if ($quest['RequiredMinRepFaction']) {
echo "<tr><td>{$lang['item_faction_rank']}:</td></tr>";
function r_lootRequire($data)
{
global $lang;
$lootcondition = getConditionItem($data['condition_id']);
if ($lootcondition) {
foreach ($lootcondition as $type) {
switch ($type['type']) {
case 1:
// CONDITION_AURA - spell_id, effindex
$spell = getSpell($type['value1'], '`id`, `SpellIconID`');
echo $lang['condition1'];
show_spell($spell['id'], $spell['SpellIconID'], 'quest');
break;
case 2:
// CONDITION_ITEM - item_id, count
$item = getItem($type['value1'], '`entry`, `displayid`');
echo $lang['condition2'] . text_show_item($item['entry'], $item['displayid'], 'quest');
if ($type['value2'] > 1) {
echo 'x' . $type['value2'];
}
break;
case 3:
// CONDITION_ITEM_EQUIPPED - item_id, 0
$item = getItem($type['value1'], '`entry`, `displayid`');
echo $lang['condition3'] . text_show_item($item['entry'], $item['displayid'], 'quest');
break;
case 4:
// CONDITION_AREAID - area_id 0, 1 (0: in (sub)area, 1: not in (sub)area)
if ($type['value2'] > 0) {
echo $lang['condition4_1'] . getAreaName($type['value1']);
}
if ($type['value2'] == 0) {
echo getAreaName($type['value1']);
}
break;
case 5:
// CONDITION_REPUTATION_RANK_MIN - faction_id, min_rank
echo getFactionName($type['value1']) . '=>(' . getReputationRankName($type['value2']) . ')';
break;
case 6:
// CONDITION_TEAM player_team, 0 (469 - Alliance 67 - Horde)
echo getFactionName($type['value1']);
break;
case 7:
// CONDITION_SKILL skill_id, skill_value
echo $lang['condition7'] . getSkillName($type['value1']);
if ($type['value2'] > 1) {
echo ' (' . $type['value2'] . ')';
}
break;
case 8:
// CONDITION_QUESTREWARDED quest_id, 0
echo $lang['condition8'] . getQuestName($type['value1']);
break;
case 9:
// CONDITION_QUESTTAKEN quest_id 0, for condition true while quest active.
echo $lang['condition9'] . getQuestName($type['value1']);
break;
case 10:
// CONDITION_AD_COMMISSION_AURA 0, 0 for condition true while one from AD сommission aura active
echo $lang['condition10'];
break;
case 11:
// CONDITION_NO_AURA spell_id, effindex
$spell = getSpell($type['value1'], '`id`, `SpellIconID`');
echo $lang['condition11'];
show_spell($spell['id'], $spell['SpellIconID'], 'quest');
break;
case 12:
// CONDITION_ACTIVE_GAME_EVENT event_id
echo $lang['condition12'] . getGameEventName($type['value1']);
break;
case 13:
// CONDITION_AREA_FLAG area_flag area_flag_not
if ($type['value1'] > 0) {
echo $lang['condition13_1'] . $type['value1'];
}
if ($type['value2'] > 0) {
echo $lang['condition13_2'] . $type['value2'];
}
break;
case 14:
// CONDITION_RACE_CLASS race_mask class_mask
if ($type['value1'] > 0) {
echo getAllowableRace($type['value1']) . '<br>';
}
if ($type['value2'] > 0) {
echo getAllowableClass($type['value2']);
}
break;
case 15:
// CONDITION_LEVEL player_level 0, 1 or 2
if ($type['value1'] > 0) {
echo $type['value1'];
}
if ($type['value1'] > 0 && $type['value2'] == 0) {
echo $lang['condition15_1'];
}
if ($type['value1'] > 0 && $type['value2'] == 1) {
echo $lang['condition15_2'];
}
if ($type['value1'] > 0 && $type['value2'] == 2) {
echo $lang['condition15_3'];
}
break;
case 16:
// CONDITION_NOITEM item_id count
$item = getItem($type['value1'], '`entry`, `displayid`');
echo $lang['condition16'] . text_show_item($item['entry'], $item['displayid'], 'quest');
if ($type['value1'] > 1) {
echo 'x' . $type['value2'];
}
break;
case 17:
// CONDITION_SPELL spell_id 0, 1 (0: has spell, 1: hasn't spell)
$spell = getSpell($type['value1'], '`id`, `SpellIconID`');
if ($type['value2'] > 0) {
echo $lang['condition17_1'];
show_spell($spell['id'], $spell['SpellIconID'], 'quest');
} else {
echo $lang['condition17_2'];
show_spell($spell['id'], $spell['SpellIconID'], 'quest');
}
break;
case 18:
// CONDITION_INSTANCE_SCRIPT instance_condition_id 0, 1, 2, 3, 4
if ($type['value1'] == 0) {
echo $lang['condition18_0'];
}
if ($type['value1'] == 1) {
echo $lang['condition18_1'];
}
if ($type['value1'] == 2) {
echo $lang['condition18_2'];
}
if ($type['value1'] == 3) {
echo $lang['condition18_3'];
}
if ($type['value1'] == 4) {
echo $lang['condition18_4'];
}
break;
case 20:
// CONDITION_ACHIEVEMENT ach_id 0, 1 (0: has achievement, 1: hasn't achievement) for player
if ($type['value2'] > 0) {
echo $lang['condition20_1'] . $type['value1'];
} else {
echo $lang['condition20_2'] . $type['value1'];
}
break;
case 22:
// CONDITION_QUEST_NONE quest_id
if ($type['value1'] > 0) {
echo $lang['condition22'] . getQuestName($type['value1']);
}
break;
case 23:
// CONDITION_ITEM_WITH_BANK- item_id, count
$item = getItem($type['value1'], '`entry`, `displayid`');
echo $lang['condition23'] . text_show_item($item['entry'], $item['displayid'], 'quest');
if ($type['value2'] > 1) {
echo 'x' . $type['value2'];
}
break;
case 24:
// NOITEM_WITH_BANK item_id count
$item = getItem($type['value1'], '`entry`, `displayid`');
echo $lang['condition24'] . text_show_item($item['entry'], $item['displayid'], 'quest');
if ($type['value1'] > 1) {
echo 'x' . $type['value2'];
}
break;
case 25:
// CONDITION_NOT_ACTIVE_GAME_EVENT event_id
echo $lang['condition25'] . getGameEventName($type['value1']);
break;
case 26:
// CONDITION_ACTIVE_HOLIDAY holiday_id
echo $lang['condition26'] . getGameHolidayName($type['value1']);
break;
case 27:
// CONDITION_NOT_ACTIVE_HOLIDAY holiday_id
echo $lang['condition27'] . getGameHolidayName($type['value1']);
break;
case 28:
// CONDITION_LEARNABLE_ABILITY spell_id 0 or item_id
$spell = getSpell($type['value1'], '`id`, `SpellIconID`');
if ($type['value2'] > 0) {
$item = getItem($type['value2'], '`entry`, `displayid`');
echo $lang['condition28_1'];
show_spell($spell['id'], $spell['SpellIconID'], 'quest');
echo $lang['condition28_2'] . text_show_item($item['entry'], $item['displayid'], 'quest');
} else {
echo $lang['condition28_1'];
show_spell($spell['id'], $spell['SpellIconID'], 'quest');
}
break;
case 29:
// CONDITION_SKILL_BELOW skill_id, skill_value
echo $lang['condition29'] . getSkillName($type['value1']);
if ($type['value2'] > 1) {
echo ' (' . $type['value2'] . ')';
}
break;
case 30:
// CONDITION_REPUTATION_RANK_MAX - faction_id, max_rank
echo getFactionName($type['value1']) . '<=(' . getReputationRankName($type['value2']) . ')';
break;
}
}
}
}