public function get_users_reputation_topic($uids, $users_reputation, $limit = 10)
{
if ($users_reputation_topics = $this->model('reputation')->get_reputation_topic($uids)) {
foreach ($users_reputation_topics as $key => $val) {
if ($val['reputation'] < 1 or $val['agree_count'] < 1) {
continue;
}
$reputation_topics[$val['uid']][] = $val;
}
}
if ($reputation_topics) {
foreach ($reputation_topics as $uid => $reputation_topic) {
$reputation_topic = array_slice(aasort($reputation_topic, 'reputation', 'DESC'), 0, $limit);
foreach ($reputation_topic as $key => $val) {
$topic_ids[$val['topic_id']] = $val['topic_id'];
}
foreach ($reputation_topic as $key => $val) {
$reputation_topic[$key]['topic_title'] = $topics[$val['topic_id']]['topic_title'];
$reputation_topic[$key]['url_token'] = $topics[$val['topic_id']]['url_token'];
}
$reputation_topics[$uid] = $reputation_topic;
}
$topics = $this->model('topic')->get_topics_by_ids($topic_ids);
foreach ($reputation_topics as $uid => $reputation_topic) {
foreach ($reputation_topic as $key => $val) {
$reputation_topics[$uid][$key]['topic_title'] = $topics[$val['topic_id']]['topic_title'];
$reputation_topics[$uid][$key]['url_token'] = $topics[$val['topic_id']]['url_token'];
}
}
}
return $reputation_topics;
}
function char_skill(&$sqlr, &$sqlc)
{
global $lang_global, $lang_char, $output, $realm_id, $realm_db, $characters_db, $mmfpm_db, $action_permission, $user_lvl, $user_name, $skill_datasite;
wowhead_tt();
require_once 'core/char/char_security.php';
$order_by = isset($_GET['order_by']) ? $sqlc->quote_smart($_GET['order_by']) : 1;
$dir = isset($_GET['dir']) ? $sqlc->quote_smart($_GET['dir']) : 1;
if (preg_match('/^[01]{1}$/', $dir)) {
} else {
$dir = 1;
}
$order_dir = $dir ? 'ASC' : 'DESC';
$dir = $dir ? 0 : 1;
$result = $sqlc->query('SELECT account, name, race, class, level, gender FROM characters WHERE guid = ' . $id . ' LIMIT 1');
if ($sqlc->num_rows($result)) {
$char = $sqlc->fetch_assoc($result);
// we get user permissions first
$owner_acc_id = $sqlc->result($result, 0, 'account');
$result = $sqlr->query('SELECT `username`, `gmlevel` FROM `account` LEFT JOIN `account_access` ON `account`.`id`=`account_access`.`id` WHERE `account`.`id` = ' . $owner_acc_id . ' ORDER BY `gmlevel` DESC LIMIT 1');
$owner_name = $sqlr->result($result, 0, 'username');
$owner_gmlvl = $sqlr->result($result, 0, 'gmlevel');
if (empty($owner_gmlvl)) {
$owner_gmlvl = 0;
}
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name) {
$result = $sqlc->query('SELECT name, race, class, level, gender FROM characters WHERE guid = ' . $id . '');
$char = $sqlc->fetch_assoc($result);
$output .= '
<center>
<div id="tab_content">
<h1>' . $lang_char['skills'] . '</h1>
<br />';
require_once 'core/char/char_header.php';
$output .= '
<br /><br />
<table class="lined" style="width: 550px;">
<tr>
<th class="title" colspan="' . ($user_lvl ? '3' : '2') . '" align="left">' . $lang_char['skills'] . '</th>
</tr>
<tr>
' . ($user_lvl ? '<th><a href="char_skill.php?id=' . $id . '&realm=' . $realmid . '&order_by=0&dir=' . $dir . '"' . ($order_by == 0 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['skill_id'] . '</a></th>' : '') . '
<th align="right"><a href="char_skill.php?id=' . $id . '&realm=' . $realmid . '&order_by=1&dir=' . $dir . '"' . ($order_by == 1 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['skill_name'] . '</a></th>
<th><a href="char_skill.php?id=' . $id . '&realm=' . $realmid . '&order_by=2&dir=' . $dir . '"' . ($order_by == 2 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['skill_value'] . '</a></th>
</tr>';
$skill_array = array();
$class_array = array();
$prof_1_array = array();
$prof_2_array = array();
$weapon_array = array();
$armor_array = array();
$language_array = array();
$skill_rank_array = array(75 => $lang_char['apprentice'], 150 => $lang_char['journeyman'], 225 => $lang_char['expert'], 300 => $lang_char['artisan'], 375 => $lang_char['master'], 450 => $lang_char['inherent'], 385 => $lang_char['wise']);
$result = $sqlc->query('SELECT skill, value, max FROM character_skills WHERE guid = ' . $id . '');
$sqlm = new SQL();
$sqlm->connect($mmfpm_db['addr'], $mmfpm_db['user'], $mmfpm_db['pass'], $mmfpm_db['name']);
while ($char_skill = $sqlc->fetch_assoc($result)) {
$temp = $char_skill['value'];
$skill = $char_skill['skill'];
$max = $char_skill['max'];
if (skill_get_type($skill, $sqlm) == 6) {
array_push($weapon_array, array($user_lvl ? $skill : '', skill_get_name($skill, $sqlm), $temp, $max));
} elseif (skill_get_type($skill, $sqlm) == 7) {
array_push($class_array, array($user_lvl ? $skill : '', skill_get_name($skill, $sqlm), $temp, $max));
} elseif (skill_get_type($skill, $sqlm) == 8) {
array_push($armor_array, array($user_lvl ? $skill : '', skill_get_name($skill, $sqlm), $temp, $max));
} elseif (skill_get_type($skill, $sqlm) == 9) {
array_push($prof_2_array, array($user_lvl ? $skill : '', skill_get_name($skill, $sqlm), $temp, $max));
} elseif (skill_get_type($skill, $sqlm) == 10) {
array_push($language_array, array($user_lvl ? $skill : '', skill_get_name($skill, $sqlm), $temp, $max));
} elseif (skill_get_type($skill, $sqlm) == 11) {
array_push($prof_1_array, array($user_lvl ? $skill : '', skill_get_name($skill, $sqlm), $temp, $max));
} else {
array_push($skill_array, array($user_lvl ? $skill : '', skill_get_name($skill, $sqlm), $temp, $max));
}
}
unset($char_skill);
aasort($skill_array, $order_by, $dir);
aasort($class_array, $order_by, $dir);
aasort($prof_1_array, $order_by, $dir);
aasort($prof_2_array, $order_by, $dir);
aasort($weapon_array, $order_by, $dir);
aasort($armor_array, $order_by, $dir);
aasort($language_array, $order_by, $dir);
foreach ($skill_array as $data) {
$output .= '
<tr>
' . ($user_lvl ? '<td>' . $data[0] . '</td>' : '') . '
<td align="right">' . $data[1] . '</td>
<td valign="center" class="bar skill_bar" style="background-position: ' . (round(450 * $data[2] / $data[3]) - 450) . 'px;">
<span>' . $data[2] . '/' . $data[3] . '</span>
</td>
</tr>';
}
if (count($class_array)) {
$output .= '
<tr>
<th class="title" colspan="' . ($user_lvl ? '3' : '2') . '" align="left">' . $lang_char['classskills'] . '</th>
</tr>';
}
foreach ($class_array as $data) {
$output .= '
<tr>
' . ($user_lvl ? '<td>' . $data[0] . '</td>' : '') . '
<td align="right"><a href="' . $skill_datasite . '7.' . $char['class'] . '.' . $data[0] . '" target="_blank">' . $data[1] . '</td>
<td valign="center" class="bar skill_bar" style="background-position: 0px;">
</td>
</tr>';
}
if (count($prof_1_array)) {
$output .= '
<tr>
<th class="title" colspan="' . ($user_lvl ? '3' : '2') . '" align="left">' . $lang_char['professions'] . '</th>
</tr>';
}
foreach ($prof_1_array as $data) {
$output .= '
<tr>
' . ($user_lvl ? '<td>' . $data[0] . '</td>' : '') . '
<td align="right"><a href="' . $skill_datasite . '11.' . $data[0] . '" target="_blank">' . $data[1] . '</a></td>
<td valign="center" class="bar skill_bar" style="background-position: ' . (round(450 * $data[2] / $data[3]) - 450) . 'px;">
<span>' . $data[2] . '/' . $data[3] . ' (' . $skill_rank_array[$data[3]] . ')</span>
</td>
</tr>';
}
if (count($prof_2_array)) {
$output .= '
<tr>
<th class="title" colspan="' . ($user_lvl ? '3' : '2') . '" align="left">' . $lang_char['secondaryskills'] . '</th>
</tr>';
}
foreach ($prof_2_array as $data) {
$output .= '
<tr>
' . ($user_lvl ? '<td>' . $data[0] . '</td>' : '') . '
<td align="right"><a href="' . $skill_datasite . '9.' . $data[0] . '" target="_blank">' . $data[1] . '</a></td>
<td valign="center" class="bar skill_bar" style="background-position: ' . (round(450 * $data[2] / $data[3]) - 450) . 'px;">
<span>' . $data[2] . '/' . $data[3] . ' (' . $skill_rank_array[$data[3]] . ')</span>
</td>
</tr>';
}
if (count($weapon_array)) {
$output .= '
<tr>
<th class="title" colspan="' . ($user_lvl ? '3' : '2') . '" align="left">' . $lang_char['weaponskills'] . '</th>
</tr>';
}
foreach ($weapon_array as $data) {
$output .= '
<tr>
' . ($user_lvl ? '<td>' . $data[0] . '</td>' : '') . '
<td align="right">' . $data[1] . '</td>
<td valign="center" class="bar skill_bar" style="background-position: ' . (round(450 * $data[2] / $data[3]) - 450) . 'px;">
<span>' . $data[2] . '/' . $data[3] . '</span>
</td>
</tr>';
}
if (count($armor_array)) {
$output .= '
<tr>
<th class="title" colspan="' . ($user_lvl ? '3' : '2') . '" align="left">' . $lang_char['armorproficiencies'] . '</th>
</tr>';
}
foreach ($armor_array as $data) {
$output .= '
<tr>
' . ($user_lvl ? '<td>' . $data[0] . '</td>' : '') . '
<td align="right">' . $data[1] . '</td>
<td valign="center" class="bar skill_bar" style="background-position: 0px;">
</td>
</tr>';
}
if (count($language_array)) {
$output .= '
<tr>
<th class="title" colspan="' . ($user_lvl ? '3' : '2') . '" align="left">' . $lang_char['languages'] . '</th>
</tr>';
}
foreach ($language_array as $data) {
$output .= '
<tr>
' . ($user_lvl ? '<td>' . $data[0] . '</td>' : '') . '
<td align="right">' . $data[1] . '</td>
<td valign="center" class="bar skill_bar" style="background-position: ' . (round(450 * $data[2] / $data[3]) - 450) . 'px;">
<span>' . $data[2] . '/' . $data[3] . '</span>
</td>
</tr>';
}
$output .= '
</table>
<br />
</div>
<br />
</div>
<br />';
require_once 'core/char/char_footer.php';
$output .= '
<br />
</center>
<!-- end of char_achieve.php -->';
} else {
error($lang_char['no_permission']);
}
} else {
error($lang_char['no_char_found']);
}
}
function char_skill(&$sqlr, &$sqlc)
{
global $lang_global, $lang_char, $output, $realm_id, $realm_db, $characters_db, $mmfpm_db, $action_permission, $user_lvl, $user_name, $skill_datasite;
// this page uses wowhead tooltops
wowhead_tt();
//==========================$_GET and SECURE=================================
// id and multi realm security to prevent sql injection
require_once './include/char/include/char_multi_realm_security.php';
$order_by = isset($_GET['order_by']) ? $sqlc->quote_smart($_GET['order_by']) : 1;
$dir = isset($_GET['dir']) ? $sqlc->quote_smart($_GET['dir']) : 1;
if (preg_match('/^[01]{1}$/', $dir)) {
} else {
$dir = 1;
}
$order_dir = $dir ? 'ASC' : 'DESC';
$dir = $dir ? 0 : 1;
//==========================$_GET and SECURE end=============================
// getting character data from database
$result = $sqlc->query('
SELECT account, name, race, class, gender, level
FROM characters
WHERE guid = ' . $id . '
LIMIT 1');
// no point going further if character does not exist
if ($sqlc->num_rows($result)) {
$char = $sqlc->fetch_assoc($result);
// we get user permissions first
$owner_acc_id = $sqlc->result($result, 0, 'account');
$result = $sqlr->query('
SELECT gmlevel, username
FROM account
WHERE id = ' . $char['account'] . '');
$owner_gmlvl = $sqlr->result($result, 0, 'gmlevel');
$owner_name = $sqlr->result($result, 0, 'username');
// check user permission
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name) {
// character sub header
$output .= '
<center>
<div id="tab_content">
<h1>' . $lang_char['skills'] . '</h1>
<br />';
// character menu tab
require_once './include/char/include/char_header.php';
// character info
require_once './include/char/include/char_info.php';
//---------------Page Specific Data Starts Here--------------------------
$output .= '
<div id="tab_content2">
<table class="lined" style="width: 700px;">
<tr>
<th class="title" colspan="' . ($user_lvl ? '3' : '2') . '" align="left">' . $lang_char['skills'] . '</th>
</tr>
<tr>
' . ($user_lvl ? '<th><a href="char_skill.php?id=' . $id . '&realm=' . $realmid . '&order_by=0&dir=' . $dir . '"' . ($order_by == 0 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['skill_id'] . '</a></th>' : '') . '
<th align="right"><a href="char_skill.php?id=' . $id . '&realm=' . $realmid . '&order_by=1&dir=' . $dir . '"' . ($order_by == 1 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['skill_name'] . '</a></th>
<th><a href="char_skill.php?id=' . $id . '&realm=' . $realmid . '&order_by=2&dir=' . $dir . '"' . ($order_by == 2 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['skill_value'] . '</a></th>
</tr>';
$skill_array = array();
$class_array = array();
$prof_1_array = array();
$prof_2_array = array();
$weapon_array = array();
$armor_array = array();
$language_array = array();
$skill_rank_array = array(1 => $lang_char['none'], 350 => $lang_char['none'], 75 => $lang_char['apprentice'], 150 => $lang_char['journeyman'], 225 => $lang_char['expert'], 300 => $lang_char['artisan'], 375 => $lang_char['master'], 450 => $lang_char['grand_master'], 525 => $lang_char['illustrious']);
$result = $sqlc->query('
SELECT skill, value, max
FROM character_skills
WHERE guid = ' . $id . '');
$sqlm = new SQL();
$sqlm->connect($mmfpm_db['addr'], $mmfpm_db['user'], $mmfpm_db['pass'], $mmfpm_db['name']);
while ($char_skill = $sqlc->fetch_assoc($result)) {
$temp = $char_skill['value'];
$skill = $char_skill['skill'];
$max = $char_skill['max'];
if (skill_get_type($skill, $sqlm) == 6) {
array_push($weapon_array, array($user_lvl ? $skill : '', skill_get_name($skill, $sqlm), $temp, $max));
} elseif (skill_get_type($skill, $sqlm) == 7) {
array_push($class_array, array($user_lvl ? $skill : '', skill_get_name($skill, $sqlm), $temp, $max));
} elseif (skill_get_type($skill, $sqlm) == 8) {
array_push($armor_array, array($user_lvl ? $skill : '', skill_get_name($skill, $sqlm), $temp, $max));
} elseif (skill_get_type($skill, $sqlm) == 9) {
array_push($prof_2_array, array($user_lvl ? $skill : '', skill_get_name($skill, $sqlm), $temp, $max));
} elseif (skill_get_type($skill, $sqlm) == 10) {
array_push($language_array, array($user_lvl ? $skill : '', skill_get_name($skill, $sqlm), $temp, $max));
} elseif (skill_get_type($skill, $sqlm) == 11) {
array_push($prof_1_array, array($user_lvl ? $skill : '', skill_get_name($skill, $sqlm), $temp, $max));
} else {
array_push($skill_array, array($user_lvl ? $skill : '', skill_get_name($skill, $sqlm), $temp, $max));
}
}
unset($char_skill);
aasort($skill_array, $order_by, $dir);
aasort($class_array, $order_by, $dir);
aasort($prof_1_array, $order_by, $dir);
aasort($prof_2_array, $order_by, $dir);
aasort($weapon_array, $order_by, $dir);
aasort($armor_array, $order_by, $dir);
aasort($language_array, $order_by, $dir);
foreach ($skill_array as $data) {
$output .= '
<tr>
' . ($user_lvl ? '<td>' . $data[0] . '</td>' : '') . '
<td align="right">' . $data[1] . '</td>
<td valign="center" class="bar skill_bar" style="background-position: ' . (round(450 * $data[2] / $data[3]) - 450) . 'px;">
<span>' . $data[2] . '/' . $data[3] . '</span>
</td>
</tr>';
}
if (count($class_array)) {
$output .= '
<tr>
<th class="title" colspan="' . ($user_lvl ? '3' : '2') . '" align="left">' . $lang_char['classskills'] . '</th>
</tr>';
}
foreach ($class_array as $data) {
$output .= '
<tr>
' . ($user_lvl ? '<td>' . $data[0] . '</td>' : '') . '
<td align="right"><a href="' . $skill_datasite . '7.' . $char['class'] . '.' . $data[0] . '" target="_blank">' . $data[1] . '</td>
<td valign="center" class="bar skill_bar" style="background-position: 0px;"></td>
</tr>';
}
if (count($prof_1_array)) {
$output .= '
<tr>
<th class="title" colspan="' . ($user_lvl ? '3' : '2') . '" align="left">' . $lang_char['professions'] . '</th>
</tr>';
}
foreach ($prof_1_array as $data) {
$output .= '
<tr>
' . ($user_lvl ? '<td>' . $data[0] . '</td>' : '') . '
<td align="right"><a href="' . $skill_datasite . '11.' . $data[0] . '" target="_blank">' . $data[1] . '</a></td>
<td valign="center" class="bar skill_bar" style="background-position: ' . (round(450 * $data[2] / $data[3]) - 450) . 'px;">
<span>' . $data[2] . '/' . $data[3] . ' (' . $skill_rank_array[$data[3]] . ')</span>
</td>
</tr>';
}
if (count($prof_2_array)) {
$output .= '
<tr>
<th class="title" colspan="' . ($user_lvl ? '3' : '2') . '" align="left">' . $lang_char['secondaryskills'] . '</th>
</tr>';
}
foreach ($prof_2_array as $data) {
$output .= '
<tr>
' . ($user_lvl ? '<td>' . $data[0] . '</td>' : '') . '
<td align="right"><a href="' . $skill_datasite . '9.' . $data[0] . '" target="_blank">' . $data[1] . '</a></td>
<td valign="center" class="bar skill_bar" style="background-position: ' . (round(450 * $data[2] / $data[3]) - 450) . 'px;">
<span>' . $data[2] . '/' . $data[3] . ' (' . $skill_rank_array[$data[3]] . ')</span>
</td>
</tr>';
}
if (count($weapon_array)) {
$output .= '
<tr>
<th class="title" colspan="' . ($user_lvl ? '3' : '2') . '" align="left">' . $lang_char['weaponskills'] . '</th>
</tr>';
}
foreach ($weapon_array as $data) {
$output .= '
<tr>
' . ($user_lvl ? '<td>' . $data[0] . '</td>' : '') . '
<td align="right">' . $data[1] . '</td>
<td valign="center" class="bar skill_bar" style="background-position: ' . (round(450 * $data[2] / $data[3]) - 450) . 'px;">
<span>' . $data[2] . '/' . $data[3] . '</span>
</td>
</tr>';
}
if (count($armor_array)) {
$output .= '
<tr>
<th class="title" colspan="' . ($user_lvl ? '3' : '2') . '" align="left">' . $lang_char['armorproficiencies'] . '</th>
</tr>';
}
foreach ($armor_array as $data) {
$output .= '
<tr>
' . ($user_lvl ? '<td>' . $data[0] . '</td>' : '') . '
<td align="right">' . $data[1] . '</td>
<td valign="center" class="bar skill_bar" style="background-position: 0px;"></td>
</tr>';
}
if (count($language_array)) {
$output .= '
<tr>
<th class="title" colspan="' . ($user_lvl ? '3' : '2') . '" align="left">' . $lang_char['languages'] . '</th>
</tr>';
}
foreach ($language_array as $data) {
$output .= '
<tr>
' . ($user_lvl ? '<td>' . $data[0] . '</td>' : '') . '
<td align="right">' . $data[1] . '</td>
<td valign="center" class="bar skill_bar" style="background-position: ' . (round(450 * $data[2] / $data[3]) - 450) . 'px;">
<span>' . $data[2] . '/' . $data[3] . '</span>
</td>
</tr>';
}
$output .= '
</table>
</div>
</div>
<br />';
//---------------Page Specific Data Ends here----------------------------
// character sub footer
require_once './include/char/include/char_ footer.php';
$output .= '
<br />
</center>';
} else {
error($lang_char['no_permission']);
}
} else {
error($lang_char['no_char_found']);
}
}
public function search_articles($q, $topic_ids = null, $page = 1, $limit = 20, $is_recommend = false)
{
if ($topic_ids) {
$topic_ids = explode(',', $topic_ids);
array_walk_recursive($topic_ids, 'intval_string');
$where[] = '`id` IN (SELECT `item_id` FROM ' . $this->get_table('topic_relation') . ' WHERE topic_id IN(' . implode(',', $topic_ids) . ') AND `type` = "article")';
}
if ($is_recommend) {
$where[] = '(`is_recommend` = "1" OR `chapter_id` IS NOT NULL)';
}
if ($where) {
$where = implode(' AND ', $where);
}
$search_hash = $this->get_search_hash('article', 'title', $q, $where);
if (!($result = $this->fetch_cache($search_hash))) {
if ($result = $this->query_all($this->bulid_query('article', 'title', $q, $where), $this->max_results)) {
$result = aasort($result, 'score', 'DESC');
} else {
return false;
}
$this->save_cache($search_hash, $result);
}
if (!$page) {
$slice_offset = 0;
} else {
$slice_offset = ($page - 1) * $limit;
}
return array_slice($result, $slice_offset, $limit);
}
/**
* Compute trends in the values of a field.
*
* @param object $req Request data
* @param object $query ES query
* @param object $return Partial response
* @return object Response to request
*/
protected function trendField($req, $query, $return, $result)
{
$field = self::canonicalFieldName($req->analyze_field);
// Scale samples. If analyze_limit is more than 50% of the
// results, then change size to 50% of the results to avoid
// overlap
$analyze_limit = $this->config['analyze_limit'];
$query->size = $analyze_limit;
if ($return->hits < $analyze_limit * 2) {
$query->size = $return->hits / 2;
}
$result = $this->esQuery($query);
$analyze = self::collectFieldValues($result->hits->hits, $field);
unset($result);
$analyze = array_count_values($analyze);
$query->sort->{'@timestamp'}->order = 'asc';
$result = $this->esQuery($query);
$return->analysis->count = count($result->hits->hits);
$analyze2 = self::collectFieldValues($result->hits->hits, $field);
unset($result);
$analyze2 = array_count_values($analyze2);
$final = array();
foreach ($analyze as $key => $value) {
$first = isset($analyze2[$key]) ? $analyze2[$key] : 0;
$final[$key] = array();
$final[$key]['count'] = $value;
$final[$key]['start'] = $first;
$final[$key]['trend'] = round(($value / $query->size - $first / $query->size) * 100, 2);
$final[$key]['abs'] = abs($final[$key]['trend']);
}
aasort($final, "abs");
$final = array_slice($final, 0, $this->config['analyze_show'], true);
$return->analysis->results = $final;
return $return;
}
function event_sorting_by_date()
{
query_posts(array('post_type' => 'events', 'post_status' => 'publish'));
$dates_array = array();
if (have_posts()) {
while (have_posts()) {
the_post();
$data = array('post_id' => get_the_ID(), 'start_date' => get_field('start_date'), 'end_date' => get_field('end_date'));
array_push($dates_array, $data);
}
wp_reset_query();
aasort($dates_array, 'start_date');
return $dates_array;
}
return 0;
}
echo round($project['over_budget']);
?>
%</td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
<div class="span6">
<?php
aasort($projects, 'hours_over_budget');
$projects = array_reverse($projects, true);
?>
<h2>Grootste verlies</h2>
<div class="panel">
<table class="table table-striped table-bordered table-condense">
<thead>
<tr>
<th><?php
_e('Project', 'orbis');
?>
</th>
<th><?php
_e('Aantal uren over budget', 'orbis');
function get_exercise_dataFN($id_course_instance, $id_student = "")
{
$dh = $GLOBALS['dh'];
$out_fields_ar = array('ID_NODO', 'ID_ISTANZA_CORSO', 'DATA_VISITA', 'PUNTEGGIO', 'COMMENTO', 'CORREZIONE_RISPOSTA_LIBERA');
$dataHa = $dh->find_ex_history_list($out_fields_ar, $this->id_user, $id_course_instance);
if (AMA_DataHandler::isError($dataHa) || empty($dataHa)) {
$this->user_ex_historyAr = '';
} else {
aasort($dataHa, array("-1"));
$this->user_ex_historyAr = $dataHa;
}
}
public function calculate_by_uid($uid)
{
if (!($user_info = $this->model('account')->get_user_info_by_uid($uid))) {
return false;
}
if ($user_articles = $this->query_all('SELECT id FROM ' . get_table('article') . ' WHERE uid = ' . $user_info['uid'])) {
foreach ($user_articles as $articles_key => $articles_val) {
$articles_ids[] = $articles_val['id'];
}
if ($articles_ids) {
$articles_vote_agree_users = $this->model('article')->get_article_vote_by_ids('article', $articles_ids, 1);
$articles_vote_against_users = $this->model('article')->get_article_vote_by_ids('article', $articles_ids, -1);
if ($article_topics_query = $this->query_all('SELECT item_id, topic_id FROM ' . get_table('topic_relation') . ' WHERE item_id IN(' . implode(',', $articles_ids) . ") AND `type` = 'article'")) {
foreach ($article_topics_query as $article_topics_key => $article_topics_val) {
$article_topics[$article_topics_val['item_id']][] = $article_topics_val;
}
unset($article_topics_query);
}
}
foreach ($user_articles as $articles_key => $articles_val) {
// 赞同的用户
if ($articles_vote_agree_users[$articles_val['id']]) {
foreach ($articles_vote_agree_users[$articles_val['id']] as $articles_vote_agree_user) {
$s_agree_value = $s_agree_value + $articles_vote_agree_user['reputation_factor'];
}
}
// 反对的用户
if ($articles_vote_against_users[$articles_val['id']]) {
foreach ($articles_vote_against_users[$articles_val['id']] as $articles_vote_against_user) {
$s_against_value = $s_against_value + $articles_vote_against_user['reputation_factor'];
}
}
}
$article_reputation = $s_agree_value - $s_against_value;
$reputation_log_factor = get_setting('reputation_log_factor');
if ($article_reputation < 0) {
$article_reputation = 0 - $article_reputation - 0.5;
if ($reputation_log_factor > 1) {
$article_reputation = 0 - log($article_reputation, $reputation_log_factor);
}
} else {
if ($article_reputation > 0) {
$article_reputation = $article_reputation + 0.5;
if ($reputation_log_factor > 1) {
$article_reputation = log($article_reputation, $reputation_log_factor);
}
}
}
// 计算在话题中的威望
if ($article_reputation) {
if ($article_topics[$articles_val['id']]) {
foreach ($article_topics[$articles_val['id']] as $key => $topic_info) {
$user_topics[$topic_info['topic_id']] = array('topic_id' => $topic_info['topic_id'], 'count' => intval($user_topics[$topic_info['topic_id']]['count']) + 1, 'agree_count' => intval($user_topics[$topic_info['topic_id']]['agree_count']) + sizeof($articles_vote_agree_users[$articles_val['id']]), 'thanks_count' => 0, 'reputation' => $user_topics[$topic_info['topic_id']]['reputation'] + $article_reputation);
}
}
}
$user_reputation = $user_reputation + $article_reputation;
}
if ($users_anwsers = $this->query_all('SELECT answer_id, question_id, agree_count, thanks_count FROM ' . get_table('answer') . ' WHERE uid = ' . $user_info['uid'])) {
foreach ($users_anwsers as $anwsers_key => $answers_val) {
$answer_ids[] = $answers_val['answer_id'];
$question_ids[] = $answers_val['question_id'];
}
if ($question_ids) {
if ($questions_info_query = $this->query_all('SELECT question_id, best_answer, published_uid, category_id FROM ' . get_table('question') . ' WHERE question_id IN(' . implode(',', $question_ids) . ')')) {
foreach ($questions_info_query as $questions_info_key => $questions_info_val) {
$questions_info[$questions_info_val['question_id']] = $questions_info_val;
}
unset($questions_info_query);
}
if ($question_topics_query = $this->query_all('SELECT item_id, topic_id FROM ' . get_table('topic_relation') . ' WHERE item_id IN(' . implode(',', $question_ids) . ") AND `type` = 'question'")) {
foreach ($question_topics_query as $question_topics_key => $question_topics_val) {
$question_topics[$question_topics_val['item_id']][] = $question_topics_val;
}
unset($question_topics_query);
}
}
if ($answer_ids) {
$vote_agree_users = $this->model('answer')->get_vote_agree_by_answer_ids($answer_ids);
$vote_against_users = $this->model('answer')->get_vote_against_by_answer_ids($answer_ids);
}
foreach ($users_anwsers as $answers_key => $answers_val) {
if (!$questions_info[$answers_val['question_id']]) {
continue;
}
$answer_reputation = 0;
// 回复威望系数
$s_publisher_agree = 0;
// 得到发起者赞同
$s_publisher_against = 0;
// 得道发起者反对
$s_agree_value = 0;
// 赞同威望系数
$s_against_value = 0;
// 反对威望系数
// 是否最佳回复
if ($questions_info[$answers_val['question_id']]['best_answer'] == $answers_val['answer_id']) {
$s_best_answer = 1;
} else {
$s_best_answer = 0;
}
// 赞同的用户
if ($vote_agree_users[$answers_val['answer_id']]) {
foreach ($vote_agree_users[$answers_val['answer_id']] as $key => $val) {
// 排除发起者
if ($questions_info[$answers_val['question_id']]['published_uid'] != $val['answer_uid']) {
$s_agree_value = $s_agree_value + $val['reputation_factor'];
if ($questions_info[$answers_val['question_id']]['published_uid'] == $val['vote_uid'] and !$s_publisher_agree) {
$s_publisher_agree = 1;
}
}
}
}
// 反对的用户
if ($vote_against_users[$answers_val['answer_id']]) {
foreach ($vote_against_users[$answers_val['answer_id']] as $key => $val) {
// 排除发起者
if ($questions_info[$answers_val['question_id']]['published_uid'] != $val['answer_uid']) {
$s_against_value = $s_against_value + $val['reputation_factor'];
if ($questions_info[$answers_val['question_id']]['published_uid'] == $val['vote_uid'] and !$s_publisher_against) {
$s_publisher_against = 1;
}
}
}
}
if ($s_publisher_agree) {
$s_agree_value = $s_agree_value - 1;
}
if ($s_publisher_against) {
$s_against_value = $s_against_value - 1;
}
$best_answer_reput = get_setting('best_answer_reput');
// 最佳回复威望系数
$publisher_reputation_factor = get_setting('publisher_reputation_factor');
// 发起者赞同/反对威望系数
$reputation_log_factor = get_setting('reputation_log_factor');
//（用户组威望系数 x 赞同数量 - 用户组威望系数 x 反对数量）+ 发起者赞同反对系数 + 最佳答案系数
$answer_reputation = $s_agree_value - $s_against_value + $s_publisher_agree * $publisher_reputation_factor - $s_publisher_against * $publisher_reputation_factor + $s_best_answer * $best_answer_reput;
if ($answer_reputation < 0) {
$answer_reputation = 0 - $answer_reputation - 0.5;
if ($reputation_log_factor > 1) {
$answer_reputation = 0 - log($answer_reputation, $reputation_log_factor);
}
} else {
if ($answer_reputation > 0) {
$answer_reputation = $answer_reputation + 0.5;
if ($reputation_log_factor > 1) {
$answer_reputation = log($answer_reputation, $reputation_log_factor);
}
}
}
// 计算在话题中的威望
if ($answer_reputation) {
if ($question_topics[$answers_val['question_id']]) {
foreach ($question_topics[$answers_val['question_id']] as $key => $topic_info) {
$user_topics[$topic_info['topic_id']] = array('topic_id' => $topic_info['topic_id'], 'count' => intval($user_topics[$topic_info['topic_id']]['count']) + 1, 'agree_count' => intval($user_topics[$topic_info['topic_id']]['agree_count']) + $answers_val['agree_count'], 'thanks_count' => intval($user_topics[$topic_info['topic_id']]['thanks_count']) + $answers_val['thanks_count'], 'reputation' => $user_topics[$topic_info['topic_id']]['reputation'] + $answer_reputation);
}
}
}
if ($questions_info[$answers_val['question_id']]['category_id']) {
$user_reputation_category[$questions_info[$answers_val['question_id']]['category_id']]['reputation'] += $answer_reputation;
$user_reputation_category[$questions_info[$answers_val['question_id']]['category_id']]['agree_count'] += $answers_val['agree_count'];
$user_reputation_category[$questions_info[$answers_val['question_id']]['category_id']]['questions'][$answers_val['question_id']] = $answers_val['question_id'];
}
$user_reputation = $user_reputation + $answer_reputation;
}
}
if (is_array($user_topics)) {
if ($user_topics = aasort($user_topics, 'count', 'DESC')) {
$user_topics = array_slice($user_topics, 0, 20);
}
foreach ($user_topics as $t_key => $t_val) {
if ($reputation_topic_id = $this->fetch_one('reputation_topic', 'auto_id', 'uid = ' . $uid . ' AND topic_id = ' . $t_val['topic_id'])) {
$this->update('reputation_topic', array('uid' => $uid, 'topic_id' => $t_val['topic_id'], 'topic_count' => $t_val['count'], 'update_time' => time(), 'agree_count' => $t_val['agree_count'], 'thanks_count' => $t_val['thanks_count'], 'reputation' => round($t_val['reputation'])), 'auto_id = ' . $reputation_topic_id);
} else {
$this->insert('reputation_topic', array('uid' => $uid, 'topic_id' => $t_val['topic_id'], 'topic_count' => $t_val['count'], 'update_time' => time(), 'agree_count' => $t_val['agree_count'], 'thanks_count' => $t_val['thanks_count'], 'reputation' => round($t_val['reputation'])));
}
}
}
if (is_array($user_reputation_category)) {
foreach ($user_reputation_category as $t_key => $t_val) {
if ($user_reputation_category_id = $this->fetch_one('reputation_category', 'auto_id', 'uid = ' . intval($uid) . ' AND category_id = ' . $t_key)) {
$this->update('reputation_category', array('uid' => intval($uid), 'category_id' => $t_key, 'update_time' => time(), 'reputation' => round($t_val['reputation']), 'agree_count' => $t_val['agree_count'], 'question_count' => count($t_val['questions'])), 'auto_id = ' . $user_reputation_category_id);
} else {
$this->insert('reputation_category', array('uid' => intval($uid), 'category_id' => $t_key, 'update_time' => time(), 'reputation' => round($t_val['reputation']), 'agree_count' => $t_val['agree_count'], 'question_count' => count($t_val['questions'])));
}
}
}
$this->model('account')->update_users_fields(array('reputation' => round($user_reputation), 'reputation_update_time' => time()), $uid);
$this->model('account')->update_user_reputation_group($uid);
}
"> [<?php
echo $abbr;
?>
<?php
echo formatOffset($offset);
?>
] <?php
echo $tz;
?>
</option>-->
<?php
}
?>
<?php
aasort($tzArray, "offset");
foreach ($tzArray as $tz) {
if ($tz["tz"] == $TimeZone) {
$sel = 'selected="selected" style="background-color: yellow;"';
} else {
$sel = "";
}
?>
<option <?php
echo $sel;
?>
value="<?php
echo $tz["tz"];
?>
"> (<?php
echo formatOffset($tz["offset"]);
function Dashboard($dashboard, $plan, $tag, $move)
{
$offset = getOffset();
setTimezone();
$r = '-7' - $_GET['move'];
$s = '-1' - $_GET['move'];
$from = date("Y/m/d", strtotime($r . ' days'));
$to = date("Y/m/d", strtotime($s . ' days'));
$theDate = date('Y/m/d', strtotime($from . ' -1 days'));
while ($theDate != $to) {
$theDate = date('Y/m/d', strtotime($theDate . ' +1 days'));
$category[] = $theDate;
}
$dashList = readDashboard($dashboard);
$peakHour = str_replace(":", "", "18");
$offPeakHour = str_replace(":", "", "22");
foreach ($dashList as $dash) {
$id_item = $dash['id_item'];
$descriptionLong = $dash['descriptionLong'];
$planList = readPlan();
foreach ($planList as $plan) {
unset($weekAvgPeak);
unset($weekAvgOffPeak);
unset($weekQoEPeak);
unset($weekQoEOffPeak);
$id_plan = $plan['id_plan'];
$ldata = loadRAWData($from, $id_plan, $id_item);
$unit = $ldata['unit'];
$div = $ldata['div'];
$plan = $ldata['plan'];
$percentile = calculatePercentile($ldata['allData']);
if (isset($ldata['hostList'])) {
foreach ($ldata['hostList'] as $host) {
$id_host = $host['id_host'];
$nacD = $host['nacD'];
$nacU = $host['nacU'];
$critical = $host['critical'];
$warning = $host['warning'];
$nominal = $host['nominal'];
if ($warning > 100) {
$dir = 1;
} else {
$dir = 0;
}
if ($nominal == -1) {
$nominal = $nacD;
}
if ($nominal == -2) {
$nominal = $nacU;
}
if (isset($ldata['historyList'][$id_host])) {
foreach ($ldata['historyList'][$id_host] as $key => $row) {
$tk = date('m/d', $row['clock']);
if (!isset($weekAvgPeak[$tk])) {
$weekAvgPeak[$tk] = array($tk, 0, 0);
}
if (!isset($weekAvgOffPeak[$tk])) {
$weekAvgOffPeak[$tk] = array($tk, 0, 0);
}
if (!isset($weekQoEPeak[$tk])) {
$weekQoEPeak[$tk] = array($tk, 0, 0);
}
if (!isset($weekQoEOffPeak[$tk])) {
$weekQoEOffPeak[$tk] = array($tk, 0, 0);
}
$skip = false;
if (isset($_SESSION['filter']['P95']) && $row['value'] > $percentile['P95']) {
$skip = true;
}
if (isset($_SESSION['filter']['P5']) && $row['value'] < $percentile['P5']) {
$skip = true;
}
if (!$skip) {
if ($row['t'] == 'P') {
$sum = $weekAvgPeak[$tk][1];
$cnt = $weekAvgPeak[$tk][2];
$x = $sum + $row['value'];
$y = $cnt + 1;
$weekAvgPeak[$tk] = array($tk, $x, $y);
}
if ($row['t'] == 'O') {
$sum = $weekAvgOffPeak[$tk][1];
$cnt = $weekAvgOffPeak[$tk][2];
$x = $sum + $row['value'];
$y = $cnt + 1;
$weekAvgOffPeak[$tk] = array($tk, $x, $y);
}
if ($row['value'] > $nacD) {
$row['value'] = $nominal;
}
if ($row['t'] == 'P') {
$sum = $weekQoEPeak[$tk][1];
$cnt = $weekQoEPeak[$tk][2];
$x = $sum + $row['value'];
$y = $cnt + 1;
$weekQoEPeak[$tk] = array($tk, $x, $y);
}
if ($row['t'] == 'O') {
$sum = $weekQoEOffPeak[$tk][1];
$cnt = $weekQoEOffPeak[$tk][2];
$x = $sum + $row['value'];
$y = $cnt + 1;
$weekQoEOffPeak[$tk] = array($tk, $x, $y);
}
}
}
}
}
}
unset($dataPeak);
unset($dataOffPeak);
unset($dataQoEPeak);
unset($dataQoEOffPeak);
unset($dataNominal);
unset($dataWarning);
unset($dataCritical);
if (isset($weekQoEPeak)) {
aasort($weekQoEPeak, 0);
aasort($weekQoEOffPeak, 0);
aasort($weekAvgPeak, 0);
aasort($weekAvgOffPeak, 0);
$sumQoEPeak = 0;
$cntQoEPeak = 0;
$sumQoEOffPeak = 0;
$cntQoEOffPeak = 0;
foreach (array_reverse($weekQoEPeak) as $tvalue) {
$key = $tvalue[0];
$sumQoEPeak += $weekQoEPeak[$key][1];
$cntQoEPeak += $weekQoEPeak[$key][2];
$sumQoEOffPeak += $weekQoEOffPeak[$key][1];
$cntQoEOffPeak += $weekQoEOffPeak[$key][2];
if ($weekQoEPeak[$key][2] > 0) {
$dataQoEPeak[$key] = array('x' => $key, 'y' => round($weekQoEPeak[$key][1] / $weekQoEPeak[$key][2] / $div, 2), 'cnt' => $weekQoEPeak[$key][2]);
}
// ColorBar($x,$nominal,$warning,$critical,$value,$div)
if ($weekQoEOffPeak[$key][2] > 0) {
$dataQoEOffPeak[$key] = array('x' => $key, 'y' => round($weekQoEOffPeak[$key][1] / $weekQoEOffPeak[$key][2] / $div, 2), 'cnt' => $weekQoEOffPeak[$key][2]);
}
if ($weekAvgPeak[$key][2] > 0) {
$dataAvgPeak[$key] = array('x' => $key, 'y' => round($weekAvgPeak[$key][1] / $weekAvgPeak[$key][2] / $div, 2), 'cnt' => $weekAvgPeak[$key][2]);
}
if ($weekAvgOffPeak[$key][2] > 0) {
$dataAvgOffPeak[$key] = array('x' => $key, 'y' => round($weekAvgOffPeak[$key][1] / $weekAvgOffPeak[$key][2] / $div, 2), 'cnt' => $weekAvgOffPeak[$key][2]);
}
}
//echo $items['descriptionLong'] . " " . $plans['plan'] . " " . $host['host'] ;
//var_dump($dataQoEPeak);
//echo "<br>";
if (!isset($dataAvgOffPeak)) {
$dataAvgOffPeak = null;
}
if (!isset($dataQoEPeak)) {
$dataQoEPeak = null;
}
if (!isset($dataAvgPeak)) {
$dataAvgPeak = null;
}
if ($cntQoEOffPeak == 0) {
$cntQoEOffPeak = 1.0E+22;
}
if ($cntQoEPeak == 0) {
$cntQoEPeak = 9.999999999999999E+22;
}
$dataList[] = array('descriptionLong' => $descriptionLong, 'plan' => $plan, 'id_plan' => $id_plan, 'id_item' => $id_item, 'QoEPeak' => $dataQoEPeak, 'QoEPeakAvg' => round($sumQoEPeak / $cntQoEPeak / $div, 2), 'QoEOffPeak' => $dataQoEOffPeak, 'QoEOffPeakAvg' => round($sumQoEOffPeak / $cntQoEOffPeak / $div, 2), 'AvgPeak' => $dataAvgPeak, 'AvgOffPeak' => $dataAvgOffPeak, 'nominal' => round($nominal / $div, 2), 'warning' => round($warning, 2), 'critical' => round($critical, 2), 'unit' => $unit, 'cntQoEPeak' => $cntQoEPeak, 'cntQoEOffPeak' => $cntQoEOffPeak, 'category' => $category);
}
}
}
echo '<table width="100%" border="0"><tr><td><center>';
echo '<table class="tooltip-tabla">';
$img1 = '<a href="./index.php?route=home0&dashboard=' . $dashboard . '&move=' . ($_GET['move'] + 1) . '"><span class="glyphicon glyphicon-backward"></span></a>';
$img2 = '<a href="./index.php?route=home0&dashboard=' . $dashboard . '&move=' . ($_GET['move'] - 1) . '"><span class="glyphicon glyphicon-forward"></a>';
$img3 = '<a href="./index.php?route=home0&dashboard=' . $dashboard . '&move=' . ($_GET['move'] + 7) . '"><span class="glyphicon glyphicon-fast-backward"></span></a>';
$img4 = '<a href="./index.php?route=home0&dashboard=' . $dashboard . '&move=' . ($_GET['move'] - 7) . '"><span class="glyphicon glyphicon-fast-forward"></a>';
echo '<tbody><tr><th>' . $img1 . " " . $img3 . '</th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th></th><th style="text-align: right;">' . $img4 . " " . $img2 . '</th></tr></tbody>';
$t = '';
if (isset($dataList)) {
foreach ($dataList as $data) {
$timeSlot = 'PEAK';
for ($ij = 1; $ij <= 2; $ij++) {
if ($timeSlot == 'PEAK') {
$QoE = 'QoEPeak';
$Avg = 'QoEPeakAvg';
$Cnt = 'cntQoEPeak';
} else {
$QoE = 'QoEOffPeak';
$Avg = 'QoEOffPeakAvg';
$Cnt = 'cntQoEOffPeak';
}
if ($t != $data['descriptionLong']) {
$t = $data['descriptionLong'];
echo '<tbody><tr><th class="success" colspan="12"><center><big>' . $t . '</big></center></th></tr></tbody>';
echo '<tr>';
echo '<td>Plan</td>';
echo '<td align="center">Left</td>';
echo '<td align="center">Nominal</td>';
//echo '<td align="center">Warning</td>';
//echo '<td align="center">Critical</td>';
echo '<td>Week Average </td>';
for ($i = 0; $i < 7; $i++) {
if (date("w", strtotime($data['category'][$i])) == 0) {
$sun = '<font color="red">';
} else {
$sun = '<font color="black">';
}
echo '<td align="right">' . $sun . substr($data['category'][$i], 5) . '</font> </td>';
}
echo '</tr>';
}
$nominal = $data['nominal'];
$warning = $data['warning'];
$critical = $data['critical'];
$unit = $data['unit'];
echo '<tr>';
echo '<td>' . $data['plan'] . ' </td>';
echo '<td>' . $timeSlot . ' </td>';
echo '<td align="right"> ' . number_format($nominal, 2) . ' ' . $unit . ' </td>';
//echo '<td align="right"> ' . number_format($nominal*$warning/100,2) . ' ' . $unit. ' </td>';
//echo '<td align="right"> ' . number_format($nominal*$critical/100,2) . ' ' . $unit. ' </td>';
echo '<td>';
// . '&tag=' . $_GET['tag']
echo '<a href="index.php?route=home0&type=bar&dashboard=' . $dashboard . '&move=' . $_GET['move'] . '&tag=' . $tag . '&idplan=' . $data['id_plan'] . '&from=' . $from . '&iditem=' . $data['id_item'] . '">';
if (!isset($data[$Avg]) || $data[$Avg] == 0) {
echo '<center><img align="center" src="./images/Button-Close-icon.png" title="' . number_format($data[$Avg], 2) . ' ' . $unit . "<b>Q:" . '0' . '"></center>';
} else {
if ($warning <= 100) {
$T1 = $nominal * $warning / 100;
$T2 = $nominal * $critical / 100;
if ($data[$Avg] >= $T1) {
$color = "./images/Green-Ball-icon.png";
} elseif ($data[$Avg] >= $T2 && $data[$Avg] < $T1) {
$color = "./images/Yellow-Ball-icon.png";
} else {
$color = "./images/Red-Ball-icon.png";
}
} else {
$T1 = $nominal * $warning / 100;
$T2 = $nominal * $critical / 100;
if ($data[$Avg] < $T1) {
$color = "./images/Green-Ball-icon.png";
} elseif ($data[$Avg] >= $T1 && $data[$Avg] < $T2) {
$color = "./images/Yellow-Ball-icon.png";
} else {
$color = "./images/Red-Ball-icon.png";
}
}
echo '<center><img align="center" src="' . $color . '" data-toggle="tooltip" title="(' . number_format($data[$Avg] / $nominal * 100, 2) . '%) ' . number_format($data[$Avg], 2) . ' ' . $unit . " Q:" . $data[$Cnt] . '"></center>';
}
echo '</a>';
echo '</span></td>';
for ($i = 0; $i < 7; $i++) {
$ky = substr($data['category'][$i], 5);
echo '<td>';
//echo '(' . $data[$QoE][$ky]['y'] . ')' . '<br>';
if (!isset($data[$QoE][$ky]['y']) || $data[$QoE][$ky]['y'] == 0 || $data[$QoE][$ky]['y'] == null) {
echo '<center><img align="center" src="./images/Button-Close-icon.png" title="No data"></center>';
} else {
if ($warning <= 100) {
$T1 = $nominal * $warning / 100;
$T2 = $nominal * $critical / 100;
if ($data[$QoE][$ky]['y'] >= $T1) {
$color = "./images/Flag-green-icon.png";
} elseif ($data[$QoE][$ky]['y'] >= $T2 && $data[$QoE][$ky]['y'] < $T1) {
$color = "./images/Flag-yellow-icon.png";
} else {
$color = "./images/Flag-red-icon.png";
}
} else {
$T1 = $nominal * $warning / 100;
$T2 = $nominal * $critical / 100;
if ($data[$QoE][$ky]['y'] < $T1) {
$color = "./images/Flag-green-icon.png";
} elseif ($data[$QoE][$ky]['y'] >= $T1 && $data[$QoE][$ky]['y'] < $T2) {
$color = "./images/Flag-yellow-icon.png";
} else {
$color = "./images/Flag-red-icon.png";
}
}
echo '<center><img align="center" src="' . $color . '" data-toggle="tooltip" title="' . $data[$QoE][$ky]['x'] . ' ' . number_format($data[$QoE][$ky]['y'], 2) . ' ' . $unit . " Q:" . $data[$QoE][$ky]['cnt'] . '"></center>';
}
echo '</span></td>';
}
echo '</tr>';
if ($timeSlot == 'PEAK') {
$timeSlot = 'OFFPEAK';
} else {
$timeSlot = 'PEAK';
}
}
}
}
echo '</table>';
echo '</center></td></tr></table>';
}
function char_quest(&$sqlr, &$sqlc)
{
global $output, $lang_global, $lang_char, $realm_id, $world_db, $characters_db, $action_permission, $user_lvl, $user_name, $quest_datasite, $itemperpage;
wowhead_tt();
require_once 'core/char/char_security.php';
//==========================$_GET and SECURE=================================
$start = isset($_GET['start']) ? $sqlc->quote_smart($_GET['start']) : 0;
if (is_numeric($start)) {
} else {
$start = 0;
}
$order_by = isset($_GET['order_by']) ? $sqlc->quote_smart($_GET['order_by']) : 1;
if (is_numeric($order_by)) {
} else {
$order_by = 1;
}
$dir = isset($_GET['dir']) ? $sqlc->quote_smart($_GET['dir']) : 0;
if (preg_match('/^[01]{1}$/', $dir)) {
} else {
$dir = 0;
}
$order_dir = $dir ? 'ASC' : 'DESC';
$dir = $dir ? 0 : 1;
//==========================$_GET and SECURE end=============================
$result = $sqlc->query('SELECT account, name, race, class, level, gender
FROM characters WHERE guid = ' . $id . ' LIMIT 1');
if ($sqlc->num_rows($result)) {
$char = $sqlc->fetch_assoc($result);
$owner_acc_id = $sqlc->result($result, 0, 'account');
$result = $sqlr->query('SELECT `username`, `gmlevel` FROM `account` LEFT JOIN `account_access` ON `account`.`id`=`account_access`.`id` WHERE `account`.`id` = ' . $owner_acc_id . ' ORDER BY `gmlevel` DESC LIMIT 1');
$owner_name = $sqlr->result($result, 0, 'username');
$owner_gmlvl = $sqlr->result($result, 0, 'gmlevel');
if (empty($owner_gmlvl)) {
$owner_gmlvl = 0;
}
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name) {
$output .= '
<center>
<div id="tab_content">
<h1>' . $lang_char['quests'] . '</h1>
<br />';
require_once 'core/char/char_header.php';
$output .= '
<br /><br />
<table class="lined" style="width: 550px;">
<tr>
<th width="10%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=0&dir=' . $dir . '"' . ($order_by == 0 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_id'] . '</a></th>
<th width="7%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=1&dir=' . $dir . '"' . ($order_by == 1 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_level'] . '</a></th>
<th width="78%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=2&dir=' . $dir . '"' . ($order_by == 2 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_title'] . '</a></th>
<th width="5%"><img src="img/aff_qst.png" width="14" height="14" border="0" alt="" /></th>
</tr>';
$result = $sqlc->query('SELECT quest, status FROM character_queststatus WHERE guid = ' . $id . ' AND ( status = 3 OR status = 1 ) ORDER BY status DESC');
$quests_1 = array();
$quests_3 = array();
if ($sqlc->num_rows($result)) {
while ($quest = $sqlc->fetch_assoc($result)) {
$deplang = get_lang_id();
$query1 = $sqlc->query('SELECT Level, IFNULL(' . ($deplang != 0 ? '`title_loc' . $deplang . '`' : 'NULL') . ', title) as Title FROM `' . $world_db[$realmid]['name'] . '`.`quest_template` LEFT JOIN `' . $world_db[$realmid]['name'] . '`.`locales_quest` ON `quest_template`.`id` = `locales_quest`.`entry` WHERE `quest_template`.`id` = \'' . $quest['quest'] . '\'');
$quest_info = $sqlc->fetch_assoc($query1);
if (1 == $quest['status']) {
array_push($quests_1, array($quest['quest'], $quest_info['QuestLevel'], $quest_info['Title'], $quest['rewarded']));
} else {
array_push($quests_3, array($quest['quest'], $quest_info['QuestLevel'], $quest_info['Title']));
}
}
unset($quest);
unset($quest_info);
aasort($quests_1, $order_by, $dir);
$orderby = $order_by;
if (2 < $orderby) {
$orderby = 1;
}
aasort($quests_3, $orderby, $dir);
$all_record = count($quests_1);
foreach ($quests_3 as $data) {
$output .= '
<tr>
<td>' . $data[0] . '</td>
<td>(' . $data[1] . ')</td>
<td align="left"><a href="' . $quest_datasite . $data[0] . '" target="_blank">' . htmlentities($data[2]) . '</a></td>
<td><img src="img/aff_qst.png" width="14" height="14" alt="" /></td>
</tr>';
}
unset($quest_3);
if (count($quests_1)) {
$output .= '
</table>
<table class="hidden" style="width: 550px;">
<tr align="right">
<td>';
$output .= generate_pagination('char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=' . $order_by . '&dir=' . ($dir ? 0 : 1), $all_record, $itemperpage, $start);
$output .= '
</td>
</tr>
</table>
<table class="lined" style="width: 550px;">
<tr>
<th width="10%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=0&dir=' . $dir . '"' . ($order_by == 0 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_id'] . '</a></th>
<th width="7%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=1&dir=' . $dir . '"' . ($order_by == 1 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_level'] . '</a></th>
<th width="68%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=2&dir=' . $dir . '"' . ($order_by == 2 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_title'] . '</a></th>
<th width="10%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=3&dir=' . $dir . '"' . ($order_by == 3 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['rewarded'] . '</a></th>
<th width="5%"><img src="img/aff_tick.png" width="14" height="14" border="0" alt="" /></th>
</tr>';
$i = 0;
foreach ($quests_1 as $data) {
if ($i < $start + $itemperpage && $i >= $start) {
$output .= '
<tr>
<td>' . $data[0] . '</td>
<td>(' . $data[1] . ')</td>
<td align="left"><a href="' . $quest_datasite . $data[0] . '" target="_blank">' . htmlentities($data[2]) . '</a></td>
<td><img src="img/aff_' . ($data[3] ? 'tick' : 'qst') . '.png" width="14" height="14" alt="" /></td>
<td><img src="img/aff_tick.png" width="14" height="14" alt="" /></td>
</tr>';
}
$i++;
}
unset($data);
unset($quest_1);
$output .= '
<tr align="right">
<td colspan="5">';
$output .= generate_pagination('char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=' . $order_by . '&dir=' . ($dir ? 0 : 1), $all_record, $itemperpage, $start);
$output .= '
</td>
</tr>';
}
} else {
$output .= '
<tr>
<td colspan="4"><p>' . $lang_char['no_act_quests'] . '</p></td>
</tr>';
}
//---------------Page Specific Data Ends here----------------------------
//---------------Character Tabs Footer-----------------------------------
$output .= '
</table>
</div>
</div>
<br />';
require_once 'core/char/char_footer.php';
$output .= '
<br />
</center>
<!-- end of char_quest.php -->';
} else {
error($lang_char['no_permission']);
}
} else {
error($lang_char['no_char_found']);
}
}
}
function aasort(&$array, $key)
{
$sorter = array();
$ret = array();
reset($array);
foreach ($array as $ii => $va) {
$sorter[$ii] = $va[$key];
}
asort($sorter);
foreach ($sorter as $ii => $va) {
$ret[$ii] = $array[$ii];
}
$array = $ret;
}
aasort($slbusesmetros, "departure");
?>
<table id="SLRealtime" data-refresh-every-n-seconds=30>
<tr>
<th style="width:3%"></th>
<th style="width:75px;text-align:center"><img src="http://images2.wikia.nocookie.net/__cb20100824161519/logopedia/images/c/ca/SL_logo.svg" height="30px" /></th>
<th style="padding-left:20"><?php
echo $slstation[0]->get('Name') . ' om ' . $distance . ' min';
?>
</th>
<th style="width:12%;text-align:center">min.</th>
</tr>
<?php
foreach ($slbusesmetros as $dps) {
//if ($dps['transport'] == 'METRO'){
// $distance = 0;
function result_sheet_ajax_rs()
{
$class_name_id = $_GET['class_name_id'];
$class_id = $_GET['class_id'];
$section_id = $_GET['section_id'];
$exam_id = $_GET['exam_id'];
$school_id = $_SESSION['school_id'];
#$data['studentInfo'] = $this->Admin_model->result_sheet_ajax($_SESSION['school_id'],$class_name_id);
$data['studentInfo'] = $this->Admin_model->result_sheet_ajax_rs($_SESSION['school_id'], $class_name_id, $section_id);
$data['studentInfo'] = aasort($data['studentInfo'], 'roll_no');
$list = $this->load->view('admin/result/ajax-student-result', $data, true);
$result = 'success';
$return = array('result' => $result, 'list' => $list);
print json_encode($return);
exit;
}
}
}
if (!empty($request_params["max_price"])) {
if ($csv_item_array[ITEM_PRICE] > $request_params["max_price"]) {
continue;
}
}
$result_array[] = array($csv_item_array[ITEM_ID], $csv_item_array[ITEM_TITLE], $csv_item_array[ITEM_DESCRIPTION], $csv_item_array[ITEM_PRICE]);
}
// SORT
switch ($request_params["sort"]) {
case "price":
aasort($result_array, ITEM_PRICE);
break;
case "id":
aasort($result_array, ITEM_ID);
break;
default:
break;
}
// PAGE && LIMIT
$offset = ($request_params["page"] - 1) * $request_params["limit"];
if ($offset < 0) {
$offset = 0;
}
$length = $request_params["limit"] - $offset;
if ($length < $request_params["limit"]) {
$length = $request_params["limit"];
}
$result_array = array_slice($result_array, $offset, $length);
// OUTPUT
function GraphHour($chart, $id_chart, $id_plan, $id_item, $tag, $from, &$hgram, &$low, &$mid, &$max, &$dir)
{
$offset = getOffset();
setTimezone();
$ldata = loadRAWData($from, $id_plan, $id_item);
$unit = $ldata['unit'];
$div = $ldata['div'];
$percentile = calculatePercentile($ldata['allData']);
$low = 0;
$mid = 0;
$max = 0;
if (isset($ldata['hostList'])) {
foreach ($ldata['hostList'] as $host) {
$id_host = $host['id_host'];
$nacD = $host['nacD'];
$nacU = $host['nacU'];
$critical = $host['critical'];
$warning = $host['warning'];
$nominal = $host['nominal'];
if ($warning > 100) {
$dir = 1;
} else {
$dir = 0;
}
if ($nominal == -1) {
$nominal = $nacD;
}
if ($nominal == -2) {
$nominal = $nacU;
}
if (isset($ldata['historyList'][$id_host])) {
foreach ($ldata['historyList'][$id_host] as $key => $row) {
$tk = date('H', $row['clock']) * 1;
if (!isset($hourAvg[$tk])) {
$hourAvg[$tk] = array($tk, 0, 0);
}
if (!isset($hourQoE[$tk])) {
$hourQoE[$tk] = array($tk, 0, 0);
}
$skip = false;
if (isset($_SESSION['filter']['P95']) && $row['value'] > $percentile['P95']) {
$skip = true;
}
if (isset($_SESSION['filter']['P5']) && $row['value'] < $percentile['P5']) {
$skip = true;
}
if (!$skip) {
$filteredData[] = array(round($row['value'] / $div, 2));
if ($warning <= 100) {
if ($row['value'] >= $nominal * $warning / 100) {
$max++;
}
if ($row['value'] < $nominal * $warning / 100 && $row['value'] >= $nominal * $critical / 100) {
$mid++;
}
if ($row['value'] < $nominal * $critical / 100) {
$low++;
}
} else {
if ($row['value'] <= $nominal * $warning / 100) {
$max++;
}
if ($row['value'] > $nominal * $warning / 100 && $row['value'] <= $nominal * $critical / 100) {
$mid++;
}
if ($row['value'] > $nominal * $critical / 100) {
$low++;
}
}
$sum = $hourAvg[$tk][1];
$cnt = $hourAvg[$tk][2];
$x = $sum + $row['value'];
$y = $cnt + 1;
$hourAvg[$tk] = array($tk, $x, $y);
if ($row['value'] > $nacD) {
$row['value'] = $nacD;
}
$sum = $hourQoE[$tk][1];
$cnt = $hourQoE[$tk][2];
$x = $sum + $row['value'];
$y = $cnt + 1;
$hourQoE[$tk] = array($tk, $x, $y);
}
}
}
}
}
$offset = 0;
unset($dataQoE);
unset($dataAvg);
unset($data3);
unset($data4);
unset($data5);
if (isset($hourQoE)) {
aasort($hourQoE, 0);
unset($k);
for ($h = 0; $h < 24; $h++) {
if (isset($hourQoE[$h])) {
$dataQoE[] = ColorBar($h, $nominal, $warning, $critical, $hourQoE[$h][1] / $hourQoE[$h][2], $div);
$data3[] = array('x' => $h, 'y' => round($nominal / $div, 2));
$data4[] = array('x' => $h, 'y' => round($nominal / $div * $warning / 100, 2));
$data5[] = array('x' => $h, 'y' => round($nominal / $div * $critical / 100, 2));
} else {
$dataQoE[] = null;
$data3[] = array('x' => $h, 'y' => round($nominal / $div, 2));
$data4[] = array('x' => $h, 'y' => round($nominal / $div * $warning / 100, 2));
$data5[] = array('x' => $h, 'y' => round($nominal / $div * $critical / 100, 2));
}
}
aasort($hourAvg, 0);
for ($h = 0; $h < 24; $h++) {
if (isset($hourQoE[$h])) {
$dataAvg[] = array('x' => $h, 'y' => round($hourQoE[$h][1] / $hourQoE[$h][2] / $div, 2), 'color' => 'silver');
$category[] = str_pad($h . ":00", 5, "0", STR_PAD_LEFT);
} else {
$dataAvg[] = null;
$category[] = str_pad($h . ":00", 5, "0", STR_PAD_LEFT);
}
}
for ($i = 0; $i < count($dataAvg); $i++) {
$dataAvg[$i]['y'] = round($dataAvg[$i]['y'] - $dataQoE[$i]['y'], 2);
}
}
if (!isset($filteredData)) {
$filteredData = null;
$nominal = 0;
$category = null;
$data3 = null;
$data4 = null;
$data5 = null;
$warning = 0;
$critical = 0;
$dataAvg = null;
$dataQoE = null;
}
$hgram = createHistogram($filteredData, 0, round($nominal / $div * 2, 0), round($nominal / $div / 6, 0) + 1, 0);
$title = 'Average by Hour for "' . $ldata['item'] . '" on plan "' . $ldata['plan'] . '"';
$subtitle = 'From ' . $ldata['from'] . ' to ' . $ldata['to'];
$chart = chartHeader($chart, $id_chart, $title, $subtitle, $ldata['unit'], $category);
$chart->plotOptions->series->pointPadding = -0.2;
if ($ldata['peak'] > $ldata['offpeak']) {
$chart->xAxis->plotBands = array(array('label' => array('text' => 'Peak Hour', 'x' => 2, 'style' => array('fontSize' => '8px', 'color' => 'red')), 'from' => $ldata['peak'] - 0.5, 'to' => 24 - 1.5, 'color' => '#FCFFC5'), array('label' => array('text' => 'Peak Hour', 'x' => 2, 'style' => array('fontSize' => '8px', 'color' => 'red')), 'from' => -0.5, 'to' => $ldata['offpeak'] + 1.5, 'color' => '#FCFFC5'));
} else {
$chart->xAxis->plotBands = array('label' => array('text' => 'Peak Hour', 'x' => 2, 'style' => array('fontSize' => '8px', 'color' => 'red')), 'from' => $ldata['peak'] - 0.5, 'to' => $ldata['offpeak'] + 0.5, 'color' => '#FCFFC5');
}
$chart->series[0]->type = 'column';
$chart->title->style->fontSize = '14px';
$chart->subtitle->style->fontSize = '10px';
$chart->series[0]->data = $dataAvg;
$chart->series[0]->stack = 0;
$chart->series[0]->tooltip->valueSuffix = ' ' . $ldata['unit'];
$chart->series[0]->name = 'Sample average for ' . $ldata['plan'];
$chart->series[0]->dataLabels->enabled = true;
$chart->series[0]->dataLabels->crop = true;
$chart->series[0]->dataLabels->overflow = 'none';
$chart->series[0]->dataLabels->align = 'center';
$chart->series[0]->dataLabels->y = -8;
$chart->series[0]->dataLabels->color = 'black';
//'#000000';
$chart->series[0]->dataLabels->style->fontSize = '10px';
$chart->series[0]->dataLabels->style->fontFamily = 'Verdana, sans-serif';
$chart->series[0]->dataLabels->formatter = new HighchartJsExpr("function() { return Highcharts.numberFormat(this.point.stackTotal, 2, '.');}");
$chart->series[1]->type = 'column';
$chart->series[1]->data = $dataQoE;
$chart->series[1]->stack = 0;
$chart->series[1]->tooltip->valueSuffix = ' ' . $ldata['unit'];
$chart->series[1]->name = 'Real average for ' . $ldata['plan'];
$chart->series[1]->dataLabels->enabled = true;
$chart->series[1]->dataLabels->rotation = -90;
$chart->series[1]->dataLabels->crop = false;
$chart->series[1]->dataLabels->align = 'center';
$chart->series[1]->dataLabels->color = '#FFFFFF';
$chart->series[1]->dataLabels->style->fontSize = '13px';
$chart->series[1]->dataLabels->style->fontFamily = 'Verdana, sans-serif';
$chart->series[1]->dataLabels->formatter = new HighchartJsExpr("function() { return Highcharts.numberFormat(this.y, 2, '.');}");
$chart->series[2]->type = 'spline';
$chart->series[2]->data = $data3;
$chart->series[2]->stack = 1;
$chart->series[2]->tooltip->valueSuffix = ' ' . $ldata['unit'];
$chart->series[2]->name = 'Nominal at 100%';
$chart->series[2]->dataLabels->crop = false;
$chart->series[2]->dataLabels->enabled = false;
$chart->series[2]->dataLabels->rotation = -90;
$chart->series[2]->dataLabels->align = 'right';
$chart->series[2]->dataLabels->x = 4;
$chart->series[2]->dataLabels->y = 10;
$chart->series[2]->dataLabels->color = '#FFFFFF';
$chart->series[2]->dataLabels->style->fontSize = '13px';
$chart->series[2]->dataLabels->style->fontFamily = 'Verdana, sans-serif';
$chart->series[2]->lineWidth = 2;
$chart->series[2]->color = 'green';
$chart->series[2]->marker->fillColor = 'green';
$chart->series[2]->marker->radius = 2;
$chart->series[2]->dataLabels->formatter = new HighchartJsExpr("function() { return Highcharts.numberFormat(this.y, 2, '.');}");
$chart->series[3]->type = 'spline';
$chart->series[3]->data = $data4;
$chart->series[3]->stack = 2;
$chart->series[3]->tooltip->valueSuffix = ' ' . $ldata['unit'];
$chart->series[3]->dataLabels->crop = false;
$chart->series[3]->name = 'Warning at ' . $warning . '% of the threashold';
$chart->series[3]->dataLabels->enabled = false;
$chart->series[3]->dataLabels->rotation = -90;
$chart->series[3]->dataLabels->align = 'right';
$chart->series[3]->dataLabels->x = 4;
$chart->series[3]->dataLabels->y = 10;
$chart->series[3]->dataLabels->color = '#FFFFFF';
$chart->series[3]->dataLabels->style->fontSize = '10px';
$chart->series[3]->dataLabels->style->fontFamily = 'Verdana, sans-serif';
$chart->series[3]->lineWidth = 2;
$chart->series[3]->color = '#F79E03';
$chart->series[3]->marker->fillColor = '#F79E03';
$chart->series[3]->marker->radius = 2;
$chart->series[3]->dataLabels->formatter = new HighchartJsExpr("function() { return Highcharts.numberFormat(this.y, 2, '.');}");
$chart->series[4]->type = 'line';
$chart->series[4]->data = $data5;
$chart->series[4]->stack = 3;
$chart->series[4]->tooltip->valueSuffix = ' ' . $ldata['unit'];
$chart->series[4]->dataLabels->crop = false;
$chart->series[4]->name = 'Critical at ' . $critical . '% of the threashold';
$chart->series[4]->dataLabels->enabled = false;
$chart->series[4]->dataLabels->rotation = -90;
$chart->series[4]->dataLabels->align = 'right';
$chart->series[4]->dataLabels->x = 4;
$chart->series[4]->dataLabels->y = 10;
$chart->series[4]->dataLabels->color = '#FFFFFF';
$chart->series[4]->dataLabels->style->fontSize = '10px';
$chart->series[4]->dataLabels->style->fontFamily = 'Verdana, sans-serif';
$chart->series[4]->lineWidth = 2;
$chart->series[4]->marker->radius = 2;
$chart->series[4]->color = 'red';
$chart->series[4]->marker->fillColor = 'red';
$chart->series[4]->dataLabels->formatter = new HighchartJsExpr("function() { return Highcharts.numberFormat(this.y, 2, '.');}");
return $chart;
}
public function get_helpful_users_by_topic_ids($topic_ids, $limit = 10, $experience_limit = 1)
{
if (!is_array($topic_ids)) {
return false;
}
array_walk_recursive($topic_ids, 'intval_string');
if ($helpful_users = AWS_APP::cache()->get('helpful_users_' . md5(implode('_', $topic_ids) . '_' . $limit . '_' . $experience_limit))) {
return $helpful_users;
}
foreach ($topic_ids as $topic_id) {
if ($reputation_list = $this->fetch_all('reputation_topic', 'reputation > 0 AND topic_id = ' . intval($topic_id), 'reputation DESC', $limit)) {
foreach ($reputation_list as $key => $val) {
$best_answer_uids[$val['uid']] = $val['uid'];
}
}
}
if (!$best_answer_uids) {
return false;
}
foreach ($best_answer_uids as $best_answer_uid) {
$rank_rate = $this->sum('reputation_topic', 'reputation', 'reputation > 0 AND topic_id IN(' . implode(',', $topic_ids) . ') AND uid = ' . intval($best_answer_uid));
$best_answer_user_ranks[] = array('rate' => $rank_rate, 'uid' => $best_answer_uid);
}
$best_answer_user_ranks = aasort($best_answer_user_ranks, 'rate', 'DESC');
if (sizeof($best_answer_user_ranks) > $limit) {
$best_answer_user_ranks = array_slice($best_answer_user_ranks, 0, $limit);
}
unset($best_answer_uids);
foreach ($best_answer_user_ranks as $user_rank) {
$best_answer_uids[$user_rank['uid']] = $user_rank['uid'];
}
$users_info = $this->model('account')->get_user_info_by_uids($best_answer_uids, true);
foreach ($best_answer_user_ranks as $user_rank) {
$helpful_users[$user_rank['uid']]['user_info'] = $users_info[$user_rank['uid']];
$experience = array();
foreach ($topic_ids as $topic_id) {
$topic_agree_count = $this->model('reputation')->calculate_agree_count($user_rank['uid'], array($topic_id));
$experience[] = array('topic_id' => $topic_id, 'agree_count' => $topic_agree_count);
}
$experience = aasort($experience, 'agree_count', 'DESC');
if (sizeof($experience) > $experience_limit) {
$experience = array_slice($experience, 0, $experience_limit);
}
foreach ($experience as $key => $val) {
$helpful_users[$user_rank['uid']]['experience'][] = array('topic_id' => $val['topic_id'], 'agree_count' => $val['agree_count']);
$experience_topic_ids[$val['topic_id']] = $val['topic_id'];
}
}
$experience_topics_info = $this->model('topic')->get_topics_by_ids($experience_topic_ids);
if ($helpful_users) {
foreach ($helpful_users as $key => $val) {
if (is_array($helpful_users[$key]['experience'])) {
foreach ($helpful_users[$key]['experience'] as $exp_key => $exp_val) {
$helpful_users[$key]['experience'][$exp_key]['topic_info'] = $experience_topics_info[$exp_val['topic_id']];
}
}
}
}
AWS_APP::cache()->set('helpful_users_' . md5(implode('_', $topic_ids) . '_' . $limit . '_' . $experience_limit), $helpful_users, get_setting('cache_level_low'));
return $helpful_users;
}
if ($recmethod == "hightolow") {
function aasort(&$array, $key)
{
$sorter = array();
$ret = array();
reset($array);
foreach ($array as $ii => $va) {
$sorter[$ii] = $va[$key];
}
asort($sorter);
foreach ($sorter as $ii => $va) {
$ret[$ii] = $array[$ii];
}
$array = $ret;
}
aasort($allprods, '5');
foreach (array_reverse($allprods) as $ctr) {
//echo $ctr[6]." ---- ".$ctr[8]."<br>";
if (in_array($ctr[7], $recbrands) or $tempbrands == "") {
if ($ctr[5] <= $recmaxprice) {
echo '<a class="modal-trigger">';
echo '<div class="prodbox col s2">';
echo '<div class="card large">';
echo '<div class="card-image">';
echo '<img class="responsive-img" src="' . $ctr[3] . '">';
echo '<span class="card-title"></span>';
echo '</div>';
echo '<div class="card-content">';
echo '<p>' . $ctr[2] . '</p><br>';
echo '<p>Brand : ' . $ctr[7] . '</p>';
echo '<p>Price : ' . '<strike>' . $ctr[4] . '</strike>' . $ctr[5] . '</p>';
if ($recmethod == "hightolow") {
function aasort(&$array, $key)
{
$sorter = array();
$ret = array();
reset($array);
foreach ($array as $ii => $va) {
$sorter[$ii] = $va[$key];
}
asort($sorter);
foreach ($sorter as $ii => $va) {
$ret[$ii] = $array[$ii];
}
$array = $ret;
}
aasort($allprods, '6');
foreach (array_reverse($allprods) as $ctr) {
//echo $ctr[6]." ---- ".$ctr[8]."<br>";
if (in_array($ctr[8], $filteredbrands) or $recbrands == "") {
if ($ctr[6] <= $recmaxprice) {
echo '<a class="modal-trigger">';
echo '<div class="prodbox col s2">';
echo '<div class="card large">';
echo '<div class="card-image">';
echo '<img class="responsive-img" src="' . $ctr[4] . '">';
echo '<span class="card-title"></span>';
echo '</div>';
echo '<div class="card-content">';
echo '<p>' . $ctr[2] . '</p><br>';
echo '<p>Brand : ' . $ctr[8] . '</p>';
echo '<p>Price : ' . '<strike>' . $ctr[5] . '</strike> ' . $ctr[6] . '</p>';
function char_quest()
{
global $output, $realm_id, $world_db, $logon_db, $characters_db, $action_permission, $locales_search_option, $site_encoding, $user_lvl, $user_name, $base_datasite, $quest_datasite, $itemperpage, $sql, $core;
if (empty($_GET["id"])) {
error(lang("global", "empty_fields"));
}
if (empty($_GET["realm"])) {
$realmid = $realm_id;
} else {
$realmid = $sql["logon"]->quote_smart($_GET["realm"]);
if (is_numeric($realmid)) {
$sql["char"]->connect($characters_db[$realmid]['addr'], $characters_db[$realmid]['user'], $characters_db[$realmid]['pass'], $characters_db[$realmid]['name'], $characters_db[$realmid]["encoding"]);
} else {
$realmid = $realm_id;
}
}
$id = $sql["char"]->quote_smart($_GET["id"]);
if (!is_numeric($id)) {
$id = 0;
}
//==========================$_GET and SECURE=================================
$start = isset($_GET["start"]) ? $sql["char"]->quote_smart($_GET["start"]) : 0;
if (!is_numeric($start)) {
$start = 0;
}
$order_by = isset($_GET["order_by"]) ? $sql["char"]->quote_smart($_GET["order_by"]) : 1;
if (!is_numeric($order_by)) {
} else {
$order_by = 1;
}
$dir = isset($_GET["dir"]) ? $sql["char"]->quote_smart($_GET["dir"]) : 0;
if (!preg_match('/^[01]{1}$/', $dir)) {
$dir = 0;
}
$order_dir = $dir ? 'ASC' : 'DESC';
$dir = $dir ? 0 : 1;
//==========================$_GET and SECURE end=============================
if ($core == 1) {
$result = $sql["char"]->query("SELECT acct, name, race, class, level, gender\r\n FROM characters WHERE guid='" . $id . "' LIMIT 1");
} else {
$result = $sql["char"]->query("SELECT account AS acct, name, race, class, level, gender\r\n FROM characters WHERE guid='" . $id . "' LIMIT 1");
}
if ($sql["char"]->num_rows($result)) {
$char = $sql["char"]->fetch_assoc($result);
// we get user permissions first
$owner_acc_id = $sql["char"]->result($result, 0, 'acct');
if ($core == 1) {
$result = $sql["logon"]->query("SELECT login FROM accounts WHERE acct='" . $char["acct"] . "'");
} else {
$result = $sql["logon"]->query("SELECT username AS login FROM account WHERE id='" . $char["acct"] . "'");
}
$owner_name = $sql["logon"]->result($result, 0, 'login');
$s_query = "SELECT *, SecurityLevel AS gm FROM config_accounts WHERE Login='******'";
$s_result = $sql["mgr"]->query($s_query);
$s_fields = $sql["mgr"]->fetch_assoc($s_result);
$owner_gmlvl = $s_fields["gm"];
$view_mod = $s_fields["View_Mod_Quest"];
if ($owner_gmlvl >= 1073741824) {
$owner_gmlvl -= 1073741824;
}
// owner configured overrides
$view_override = false;
if ($view_mod > 0) {
if ($view_mod == 1) {
} elseif ($view_mod == 2) {
// only registered users may view this page
if ($user_lvl > -1) {
$view_override = true;
}
}
}
// visibility overrides for specific tabs
$view_inv_override = false;
if ($s_fields["View_Mod_Inv"] > 0) {
if ($s_fields["View_Mod_Inv"] == 1) {
} elseif ($s_fields["View_Mod_Inv"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_inv_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_inv_override = true;
}
}
$view_talent_override = false;
if ($s_fields["View_Mod_Talent"] > 0) {
if ($s_fields["View_Mod_Talent"] == 1) {
} elseif ($s_fields["View_Mod_Talent"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_talent_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_talent_override = true;
}
}
$view_achieve_override = false;
if ($s_fields["View_Mod_Achieve"] > 0) {
if ($s_fields["View_Mod_Achieve"] == 1) {
} elseif ($s_fields["View_Mod_Achieve"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_achieve_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_achieve_override = true;
}
}
$view_friends_override = false;
if ($s_fields["View_Mod_Friends"] > 0) {
if ($s_fields["View_Mod_Friends"] == 1) {
} elseif ($s_fields["View_Mod_Friends"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_friends_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_friends_override = true;
}
}
$view_view_override = false;
if ($s_fields["View_Mod_View"] > 0) {
if ($s_fields["View_Mod_View"] == 1) {
} elseif ($s_fields["View_Mod_View"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_view_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_view_override = true;
}
}
if ($view_override || $user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$output .= '
<div class="tab">
<ul>
<li><a href="char.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "char_sheet") . '</a></li>';
if ($view_inv_override) {
$output .= '
<li><a href="char_inv.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "inventory") . '</a></li>';
}
if ($view_talent_override) {
$output .= '
' . ($char["level"] < 10 ? '' : '<li><a href="char_talent.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "talents") . '</a></li>') . '';
}
if ($view_achieve_override) {
$output .= '
<li><a href="char_achieve.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "achievements") . '</a></li>';
}
$output .= '
<li class="selected"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "quests") . '</a></li>';
if ($view_friends_override) {
$output .= '
<li><a href="char_friends.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "friends") . '</a></li>';
}
if ($view_view_override) {
$output .= '
<li><a href="char_view.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "view") . '</a></li>';
}
$output .= '
</ul>
</div>
<div class="tab_content center center_text">
<span class="bold">
' . htmlentities($char["name"], ENT_COMPAT, $site_encoding) . ' -
<img src="img/c_icons/' . $char["race"] . '-' . $char["gender"] . '.gif" onmousemove="oldtoolTip(\'' . char_get_race_name($char["race"]) . '\', \'old_item_tooltip\')" onmouseout="oldtoolTip()" alt="" />
<img src="img/c_icons/' . $char["class"] . '.gif" onmousemove="oldtoolTip(\'' . char_get_class_name($char["class"]) . '\', \'old_item_tooltip\')" onmouseout="oldtoolTip()" alt="" /> - ' . lang("char", "level_short") . char_get_level_color($char["level"]) . '
</span>
<br />
<br />
<table class="lined" id="ch_que_questsA">
<tr>
<th style="width: 10%;"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=0&dir=' . $dir . '"' . ($order_by == 0 ? ' class="' . $order_dir . '"' : '') . '>' . lang("char", "quest_id") . '</a></th>
<th style="width: 7%;"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=1&dir=' . $dir . '"' . ($order_by == 1 ? ' class="' . $order_dir . '"' : '') . '>' . lang("char", "quest_level") . '</a></th>
<th style="width: 78%;"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=2&dir=' . $dir . '"' . ($order_by == 2 ? ' class="' . $order_dir . '"' : '') . '>' . lang("char", "quest_title") . '</a></th>
<th style="width: 5%;"><img src="img/aff_qst.png" width="14" height="14" alt="" /></th>
</tr>';
if ($core == 1) {
$result = $sql["char"]->query("SELECT quest_id, completed\r\n FROM questlog\r\n WHERE player_guid='" . $id . "'");
} elseif ($core == 2) {
$result = $sql["char"]->query("SELECT quest AS quest_id, status AS completed\r\n FROM character_queststatus\r\n WHERE guid='" . $id . "' AND rewarded=0 AND status<>0");
} else {
$result = $sql["char"]->query("SELECT quest AS quest_id, status AS completed\r\n FROM character_queststatus\r\n WHERE guid='" . $id . "' AND status<>0");
}
$quests_1 = array();
$quests_3 = array();
if ($sql["char"]->num_rows($result)) {
while ($quest = $sql["char"]->fetch_assoc($result)) {
$deplang = get_lang_id();
if ($core == 1) {
$query1 = $sql["char"]->query("SELECT *, questlevel, Title AS Title1 FROM `" . $world_db[$realmid]['name'] . "`.quests " . ($locales_search_option != 0 ? "LEFT JOIN `" . $world_db[$realmid]['name'] . "`.quests_localized ON (quests_localized.entry=quests.entry AND language_code='" . $locales_search_option . "' ) " : " ") . "WHERE quests.entry='" . $quest["quest_id"] . "'");
} elseif ($core == 2) {
$query1 = $sql["char"]->query("SELECT *, QuestLevel AS questlevel, Title AS Title1 FROM `" . $world_db[$realmid]['name'] . "`.quest_template " . ($locales_search_option != 0 ? "LEFT JOIN `" . $world_db[$realmid]['name'] . "`.locales_quest ON locales_quest.entry=quest_template.entry " : " ") . "WHERE quest_template.entry='" . $quest["quest_id"] . "'");
} else {
$query1 = $sql["char"]->query("SELECT *, Level AS questlevel, Title AS Title1 FROM `" . $world_db[$realmid]['name'] . "`.quest_template " . ($locales_search_option != 0 ? "LEFT JOIN `" . $world_db[$realmid]['name'] . "`.locales_quest ON locales_quest.entry=quest_template.Id " : " ") . "WHERE quest_template.Id='" . $quest["quest_id"] . "'");
}
$quest_info = $sql["char"]->fetch_assoc($query1);
// Localization
if ($locales_search_option == 0) {
$quest_info["title"] = $quest_info["Title1"];
} else {
if ($core == 1) {
$quest_info["title"] = $quest_info["Title"];
} else {
$quest_info["title"] = $quest_info["Title_loc" . $locales_search_option];
}
}
if ($quest["completed"] == 1) {
array_push($quests_1, array($quest["quest_id"], $quest_info["questlevel"], $quest_info["title"], $quest["rewarded"]));
} else {
array_push($quests_3, array($quest["quest_id"], $quest_info["questlevel"], $quest_info["title"]));
}
}
unset($quest);
unset($quest_info);
aasort($quests_1, $order_by, $dir);
$orderby = $order_by;
if ($orderby > 2) {
$orderby = 1;
}
aasort($quests_3, $orderby, $dir);
$all_record = count($quests_1);
foreach ($quests_3 as $data) {
$output .= '
<tr>
<td>' . $data[0] . '</td>
<td>(' . $data[1] . ')</td>
<td align="left"><a href="' . $base_datasite . $quest_datasite . $data[0] . '" rel="external">' . htmlentities($data[2], ENT_COMPAT, $site_encoding) . '</a></td>
<td><img src="img/aff_qst.png" width="14" height="14" alt="" /></td>
</tr>';
}
unset($quest_3);
if (count($quests_1)) {
$output .= '
</table>
<table class="hidden" id="ch_que_questsB">
<tr align="right">
<td>';
$output .= generate_pagination('char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=' . $order_by . '&dir=' . ($dir ? 0 : 1), $all_record, $itemperpage, $start);
$output .= '
</td>
</tr>
</table>
<table class="lined" id="ch_que_questsC">
<tr>
<th style="width: 10%;"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=0&dir=' . $dir . '"' . ($order_by == 0 ? ' class="' . $order_dir . '"' : '') . '>' . lang("char", "quest_id") . '</a></th>
<th style="width: 7%;"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=1&dir=' . $dir . '"' . ($order_by == 1 ? ' class="' . $order_dir . '"' : '') . '>' . lang("char", "quest_level") . '</a></th>
<th style="width: 68%;"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=2&dir=' . $dir . '"' . ($order_by == 2 ? ' class="' . $order_dir . '"' : '') . '>' . lang("char", "quest_title") . '</a></th>
<th style="width: 10%;"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=3&dir=' . $dir . '"' . ($order_by == 3 ? ' class="' . $order_dir . '"' : '') . '>' . lang("char", "rewarded") . '</a></th>
<th style="width: 5%;"><img src="img/aff_tick.png" width="14" height="14" alt="" /></th>
</tr>';
$i = 0;
foreach ($quests_1 as $data) {
if ($i < $start + $itemperpage && $i >= $start) {
$output .= '
<tr>
<td>' . $data[0] . '</td>
<td>(' . $data[1] . ')</td>
<td align="left"><a href="' . $base_datasite . $quest_datasite . $data[0] . '" rel="external">' . htmlentities($data[2], ENT_COMPAT, $site_encoding) . '</a></td>
<td><img src="img/aff_' . ($data[3] ? 'tick' : 'qst') . '.png" width="14" height="14" alt="" /></td>
<td><img src="img/aff_tick.png" width="14" height="14" alt="" /></td>
</tr>';
}
$i++;
}
unset($data);
unset($quest_1);
$output .= '
<tr align="right">
<td colspan="5">';
$output .= generate_pagination('char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=' . $order_by . '&dir=' . ($dir ? 0 : 1), $all_record, $itemperpage, $start);
$output .= '
</td>
</tr>';
}
} else {
$output .= '
<tr>
<td colspan="4"><p>' . lang("char", "no_act_quests") . '</p></td>
</tr>';
}
//---------------Page Specific Data Ends here----------------------------
//---------------Character Tabs Footer-----------------------------------
$output .= '
</table>
</div>
<br />
<table class="hidden center">
<tr>
<td>';
// button to user account page, user account page has own security
makebutton(lang("char", "chars_acc"), 'user.php?action=edit_user&id=' . $owner_acc_id . '', 130);
$output .= '
</td>
<td>';
// only higher level GM with delete access can edit character
// character edit allows removal of character items, so delete permission is needed
if ($user_lvl > $owner_gmlvl && $user_lvl >= $action_permission["delete"]) {
//makebutton($lang_char["edit_button"], 'char_edit.php?id='.$id.'&realm='.$realmid.'', 130);
$output .= '
</td>
<td>';
}
// only higher level GM with delete access, or character owner can delete character
if ($user_lvl > $owner_gmlvl && $user_lvl >= $action_permission["delete"] || $owner_name === $user_name) {
makebutton(lang("char", "del_char"), 'char_list.php?action=del_char_form&check%5B%5D=' . $id . '" type="wrn', 130);
$output .= '
</td>
<td>';
}
// only GM with update permission can send mail, mail can send items, so update permission is needed
if ($user_lvl >= $action_permission["update"]) {
makebutton(lang("char", "send_mail"), 'mail.php?type=ingame_mail&to=' . $char["name"] . '', 130);
$output .= '
</td>
<td>';
}
makebutton(lang("global", "back"), 'javascript:window.history.back()" type="def', 130);
$output .= '
</td>
</tr>
</table>
<br />
<!-- end of char_quest.php -->';
} else {
error(lang("char", "no_permission"));
}
} else {
error(lang("char", "no_char_found"));
}
}
function char_skill()
{
global $output, $realm_id, $characters_db, $corem_db, $action_permission, $user_lvl, $site_encoding, $user_name, $base_datasite, $skill_datasite, $sql, $core;
//wowhead_tt();
if (empty($_GET["id"])) {
error(lang("global", "empty_fields"));
}
// this is multi realm support, as of writing still under development
// this page is already implementing it
if (empty($_GET["realm"])) {
$realmid = $realm_id;
} else {
$realmid = $sql["logon"]->quote_smart($_GET["realm"]);
if (is_numeric($realmid)) {
$sql["char"]->connect($characters_db[$realmid]['addr'], $characters_db[$realmid]['user'], $characters_db[$realmid]['pass'], $characters_db[$realmid]['name'], $characters_db[$realmid]["encoding"]);
} else {
$realmid = $realm_id;
}
}
$id = $sql["char"]->quote_smart($_GET["id"]);
if (!is_numeric($id)) {
$id = 0;
}
$order_by = isset($_GET["order_by"]) ? $sql["char"]->quote_smart($_GET["order_by"]) : 1;
$dir = isset($_GET["dir"]) ? $sql["char"]->quote_smart($_GET["dir"]) : 1;
if (!preg_match('/^[01]{1}$/', $dir)) {
$dir = 1;
}
$order_dir = $dir ? 'ASC' : 'DESC';
$dir = $dir ? 0 : 1;
if ($core == 1) {
$result = $sql["char"]->query('SELECT acct, name, race, class, level, gender FROM characters WHERE guid = ' . $id . ' LIMIT 1');
} else {
$result = $sql["char"]->query('SELECT account AS acct, name, race, class, level, gender FROM characters WHERE guid = ' . $id . ' LIMIT 1');
}
if ($sql["char"]->num_rows($result)) {
$char = $sql["char"]->fetch_assoc($result);
// we get user permissions first
$owner_acc_id = $sql["char"]->result($result, 0, 'acct');
if ($core == 1) {
$result = $sql["logon"]->query("SELECT login FROM accounts WHERE acct='" . $char["acct"] . "'");
} else {
$result = $sql["logon"]->query("SELECT username AS login FROM account WHERE id='" . $char["acct"] . "'");
}
$owner_name = $sql["logon"]->result($result, 0, 'login');
$s_query = "SELECT *, SecurityLevel AS gm FROM config_accounts WHERE Login='******'";
$s_result = $sql["mgr"]->query($s_query);
$s_fields = $sql["mgr"]->fetch_assoc($s_result);
$owner_gmlvl = $s_fields["gm"];
$view_mod = $s_fields["View_Mod_Skill"];
if ($owner_gmlvl >= 1073741824) {
$owner_gmlvl -= 1073741824;
}
// owner configured overrides
$view_override = false;
if ($view_mod > 0) {
if ($view_mod == 1) {
} elseif ($view_mod == 2) {
// only registered users may view this page
if ($user_lvl > -1) {
$view_override = true;
}
}
}
// visibility overrides for specific tabs
$view_inv_override = false;
if ($s_fields["View_Mod_Inv"] > 0) {
if ($s_fields["View_Mod_Inv"] == 1) {
} elseif ($s_fields["View_Mod_Inv"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_inv_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_inv_override = true;
}
}
$view_talent_override = false;
if ($s_fields["View_Mod_Talent"] > 0) {
if ($s_fields["View_Mod_Talent"] == 1) {
} elseif ($s_fields["View_Mod_Talent"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_talent_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_talent_override = true;
}
}
$view_achieve_override = false;
if ($s_fields["View_Mod_Achieve"] > 0) {
if ($s_fields["View_Mod_Achieve"] == 1) {
} elseif ($s_fields["View_Mod_Achieve"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_achieve_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_achieve_override = true;
}
}
$view_quest_override = false;
if ($s_fields["View_Mod_Quest"] > 0) {
if ($s_fields["View_Mod_Quest"] == 1) {
} elseif ($s_fields["View_Mod_Quest"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_quest_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_quest_override = true;
}
}
$view_friends_override = false;
if ($s_fields["View_Mod_Friends"] > 0) {
if ($s_fields["View_Mod_Friends"] == 1) {
} elseif ($s_fields["View_Mod_Friends"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_friends_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_friends_override = true;
}
}
$view_view_override = false;
if ($s_fields["View_Mod_View"] > 0) {
if ($s_fields["View_Mod_View"] == 1) {
} elseif ($s_fields["View_Mod_View"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_view_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_view_override = true;
}
}
$view_pets_override = false;
if ($s_fields["View_Mod_Pets"] > 0) {
if ($s_fields["View_Mod_Pets"] == 1) {
} elseif ($s_fields["View_Mod_Pets"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_pets_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_pets_override = true;
}
}
$view_rep_override = false;
if ($s_fields["View_Mod_Rep"] > 0) {
if ($s_fields["View_Mod_Rep"] == 1) {
} elseif ($s_fields["View_Mod_Rep"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_rep_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_rep_override = true;
}
}
$view_pvp_override = false;
if ($s_fields["View_Mod_PvP"] > 0) {
if ($s_fields["View_Mod_PvP"] == 1) {
} elseif ($s_fields["View_Mod_PvP"] == 2) {
// only registered users may view this tab
if ($user_lvl > -1) {
$view_pvp_override = true;
}
}
} else {
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
$view_pvp_override = true;
}
}
if ($view_override || $user_lvl > $owner_gmlvl || $owner_name === $user_name || $user_lvl == $action_permission["delete"]) {
if ($core == 1) {
$result = $sql["char"]->query("SELECT data, name, race, class, level, gender FROM characters WHERE guid = '" . $id . "'");
$char = $sql["char"]->fetch_assoc($result);
$char_data = explode(';', $char["data"]);
} else {
$result = $sql["char"]->query("SELECT name, race, class, level, gender FROM characters WHERE guid='" . $id . "'");
$char = $sql["char"]->fetch_assoc($result);
$result = $sql["char"]->query("SELECT * FROM character_skills WHERE guid='" . $id . "'");
// make TC's skill data work like our treatment of Arc's
$char_data = array();
$i = 0;
while ($skill_row = $sql["char"]->fetch_assoc($result)) {
$char_data[PLAYER_SKILL_INFO_1_1 + $i] = $skill_row["skill"];
$char_data[PLAYER_SKILL_INFO_1_1 + $i + 1] = $skill_row["value"];
$char_data[PLAYER_SKILL_INFO_1_1 + $i + 2] = $skill_row["max"];
$i += 3;
}
}
$output .= '
<div class="tab">
<ul>
<li class="selected"><a href="char.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "char_sheet") . '</a></li>';
if ($view_inv_override) {
$output .= '
<li><a href="char_inv.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "inventory") . '</a></li>';
}
if ($view_talent_override) {
$output .= '
' . ($char["level"] < 10 ? '' : '<li><a href="char_talent.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "talents") . '</a></li>') . '';
}
if ($view_achieve_override) {
$output .= '
<li><a href="char_achieve.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "achievements") . '</a></li>';
}
if ($view_quest_override) {
$output .= '
<li><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "quests") . '</a></li>';
}
if ($view_friends_override) {
$output .= '
<li><a href="char_friends.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "friends") . '</a></li>';
}
if ($view_view_override) {
$output .= '
<li><a href="char_view.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "view") . '</a></li>';
}
$output .= '
</ul>
</div>
<div class="tab_content center">
<div class="tab">
<ul>
<li><a href="char.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "char_sheet") . '</a></li>';
if (char_get_class_name($char["class"]) == "Hunter" && $view_pets_override) {
$output .= '
<li><a href="char_pets.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "pets") . '</a></li>';
}
if ($view_rep_override) {
$output .= '
<li><a href="char_rep.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "reputation") . '</a></li>';
}
$output .= '
<li class="selected"><a href="char_skill.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "skills") . '</a></li>';
if ($view_pvp_override) {
$output .= '
<li><a href="char_pvp.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "pvp") . '</a></li>';
}
if ($owner_name == $user_name || $user_lvl >= get_page_permission("insert", "char_mail.php")) {
$output .= '
<li><a href="char_mail.php?id=' . $id . '&realm=' . $realmid . '">' . lang("char", "mail") . '</a></li>';
}
$output .= '
</ul>
</div>
<div class="tab_content2 center center_text">
<span class="bold">
' . htmlentities($char["name"], ENT_COMPAT, $site_encoding) . ' -
<img src="img/c_icons/' . $char["race"] . '-' . $char["gender"] . '.gif" onmousemove="oldtoolTip(\'' . char_get_race_name($char["race"]) . '\', \'old_item_tooltip\')" onmouseout="oldtoolTip()" alt="" />
<img src="img/c_icons/' . $char["class"] . '.gif" onmousemove="oldtoolTip(\'' . char_get_class_name($char["class"]) . '\', \'old_item_tooltip\')" onmouseout="oldtoolTip()" alt="" /> - ' . lang("char", "level_short") . char_get_level_color($char["level"]) . '
</span>
<br />
<br />
<table class="lined" id="ch_ski_main">
<tr>
<th class="title" colspan="' . ($user_lvl ? '3' : '2') . '" align="left">' . lang("char", "skills") . '</th>
</tr>
<tr>
' . ($user_lvl ? '<th><a href="char_skill.php?id=' . $id . '&realm=' . $realmid . '&order_by=0&dir=' . $dir . '"' . ($order_by == 0 ? ' class="' . $order_dir . '"' : '') . '>' . lang("char", "skill_id") . '</a></th>' : '') . '
<th align="right"><a href="char_skill.php?id=' . $id . '&realm=' . $realmid . '&order_by=1&dir=' . $dir . '"' . ($order_by == 1 ? ' class="' . $order_dir . '"' : '') . '>' . lang("char", "skill_name") . '</a></th>
<th><a href="char_skill.php?id=' . $id . '&realm=' . $realmid . '&order_by=2&dir=' . $dir . '"' . ($order_by == 2 ? ' class="' . $order_dir . '"' : '') . '>' . lang("char", "skill_value") . '</a></th>
</tr>';
$skill_array = array();
$class_array = array();
$prof_1_array = array();
$prof_2_array = array();
$weapon_array = array();
$armor_array = array();
$language_array = array();
$skill_rank_array = array(75 => lang("char", "apprentice"), 150 => lang("char", "journeyman"), 225 => lang("char", "expert"), 300 => lang("char", "artisan"), 375 => lang("char", "master"), 450 => lang("char", "inherent"), 385 => lang("char", "wise"));
for ($i = PLAYER_SKILL_INFO_1_1; $i <= PLAYER_SKILL_INFO_1_1 + 384; $i += 3) {
if ($char_data[$i] && skill_get_name($char_data[$i] & 0xffff)) {
$temp = unpack("S", pack("L", $char_data[$i + 1]));
$skill = $char_data[$i] & 0xffff;
if (skill_get_type($skill) == 6) {
array_push($weapon_array, array($user_lvl ? $skill : '', skill_get_name($skill), $temp[1]));
} elseif (skill_get_type($skill) == 7) {
array_push($class_array, array($user_lvl ? $skill : '', skill_get_name($skill), $temp[1]));
} elseif (skill_get_type($skill) == 8) {
array_push($armor_array, array($user_lvl ? $skill : '', skill_get_name($skill), $temp[1]));
} elseif (skill_get_type($skill) == 9) {
array_push($prof_2_array, array($user_lvl ? $skill : '', skill_get_name($skill), $temp[1]));
} elseif (skill_get_type($skill) == 10) {
array_push($language_array, array($user_lvl ? $skill : '', skill_get_name($skill), $temp[1]));
} elseif (skill_get_type($skill) == 11) {
array_push($prof_1_array, array($user_lvl ? $skill : '', skill_get_name($skill), $temp[1]));
} else {
array_push($skill_array, array($user_lvl ? $skill : '', skill_get_name($skill), $temp[1]));
}
}
}
unset($char_data);
aasort($skill_array, $order_by, $dir);
aasort($class_array, $order_by, $dir);
aasort($prof_1_array, $order_by, $dir);
aasort($prof_2_array, $order_by, $dir);
aasort($weapon_array, $order_by, $dir);
aasort($armor_array, $order_by, $dir);
aasort($language_array, $order_by, $dir);
foreach ($skill_array as $data) {
// this_is_junk: style left hardcoded because it's calculated.
$max = $data[2] < $char["level"] * 5 ? $char["level"] * 5 : $data[2];
$output .= '
<tr>
' . ($user_lvl ? '<td>' . $data[0] . '</td>' : '') . '
<td align="right">' . $data[1] . '</td>
<td class="bar skill_bar" style="background-position: ' . (round(385 * $data[2] / $max) - 385) . 'px;">
<span style="position: relative; top: -2px;">' . $data[2] . '/' . $max . '</span>
</td>
</tr>';
}
if (count($class_array)) {
$output .= '
<tr><th class="title" colspan="' . ($user_lvl ? '3' : '2') . '" align="left">' . lang("char", "classskills") . '</th></tr>';
}
foreach ($class_array as $data) {
$max = $data[2] < $char["level"] * 5 ? $char["level"] * 5 : $data[2];
$output .= '
<tr>
' . ($user_lvl ? '<td>' . $data[0] . '</td>' : '') . '
<td align="right"><a href="' . $base_datasite . $skill_datasite . '7.' . $char["class"] . '.' . $data[0] . '" rel="external">' . $data[1] . '</a></td>
<td class="bar skill_bar" style="background-position: 0px;">
</td>
</tr>';
}
if (count($prof_1_array)) {
$output .= '
<tr><th class="title" colspan="' . ($user_lvl ? '3' : '2') . '" align="left">' . lang("char", "professions") . '</th></tr>';
}
foreach ($prof_1_array as $data) {
// this_is_junk: style left hardcoded because it's calculated.
$max = $data[2] < 76 ? 75 : ($data[2] < 151 ? 150 : ($data[2] < 226 ? 225 : ($data[2] < 301 ? 300 : ($data[2] < 376 ? 375 : ($data[2] < 376 ? 375 : 450)))));
$output .= '
<tr>
' . ($user_lvl ? '<td>' . $data[0] . '</td>' : '') . '
<td align="right"><a href="' . $base_datasite . $skill_datasite . '11.' . $data[0] . '" rel="external">' . $data[1] . '</a></td>
<td class="bar skill_bar" style="background-position: ' . (round(385 * $data[2] / $max) - 385) . 'px;">
<span style="position: relative; top: -2px;">' . $data[2] . '/' . $max . ' (' . $skill_rank_array[$max] . ')</span>
</td>
</tr>';
}
if (count($prof_2_array)) {
$output .= '
<tr><th class="title" colspan="' . ($user_lvl ? '3' : '2') . '" align="left">' . lang("char", "secondaryskills") . '</th></tr>';
}
foreach ($prof_2_array as $data) {
// this_is_junk: style left hardcoded because it's calculated.
$max = $data[2] < 76 ? 75 : ($data[2] < 151 ? 150 : ($data[2] < 226 ? 225 : ($data[2] < 301 ? 300 : ($data[2] < 376 ? 375 : ($data[2] < 376 ? 375 : 450)))));
$output .= '
<tr>
' . ($user_lvl ? '<td>' . $data[0] . '</td>' : '') . '
<td align="right"><a href="' . $base_datasite . $skill_datasite . '9.' . $data[0] . '" rel="external">' . $data[1] . '</a></td>
<td class="bar skill_bar" style="background-position: ' . (round(385 * $data[2] / $max) - 385) . 'px;">
<span style="position: relative; top: -2px;">' . $data[2] . '/' . $max . ' (' . $skill_rank_array[$max] . ')</span>
</td>
</tr>';
}
if (count($weapon_array)) {
$output .= '
<tr><th class="title" colspan="' . ($user_lvl ? '3' : '2') . '" align="left">' . lang("char", "weaponskills") . '</th></tr>';
}
foreach ($weapon_array as $data) {
// this_is_junk: style left hardcoded because it's calculated.
$max = $data[2] < $char["level"] * 5 ? $char["level"] * 5 : $data[2];
$output .= '
<tr>
' . ($user_lvl ? '<td>' . $data[0] . '</td>' : '') . '
<td align="right">' . $data[1] . '</td>
<td class="bar skill_bar" style="background-position: ' . (round(385 * $data[2] / $max) - 385) . 'px;">
<span style="position: relative; top: -2px;">' . $data[2] . '/' . $max . '</span>
</td>
</tr>';
}
if (count($armor_array)) {
$output .= '
<tr><th class="title" colspan="' . ($user_lvl ? '3' : '2') . '" align="left">' . lang("char", "armorproficiencies") . '</th></tr>';
}
foreach ($armor_array as $data) {
$max = $data[2] < $char["level"] * 5 ? $char["level"] * 5 : $data[2];
$output .= '
<tr>
' . ($user_lvl ? '<td>' . $data[0] . '</td>' : '') . '
<td align="right">' . $data[1] . '</td>
<td class="bar skill_bar" style="background-position: 0px;">
</td>
</tr>';
}
if (count($language_array)) {
$output .= '
<tr><th class="title" colspan="' . ($user_lvl ? '3' : '2') . '" align="left">' . lang("char", "languages") . '</th></tr>';
}
foreach ($language_array as $data) {
// this_is_junk: style left hardcoded because it's calculated.
$max = $data[2] < $char["level"] * 5 ? $char["level"] * 5 : $data[2];
$output .= '
<tr>
' . ($user_lvl ? '<td>' . $data[0] . '</td>' : '') . '
<td align="right">' . $data[1] . '</td>
<td class="bar skill_bar" style="background-position: ' . (round(385 * $data[2] / $max) - 385) . 'px;">
<span style="position: relative; top: -2px;">' . $data[2] . '/' . $max . '</span>
</td>
</tr>';
}
$output .= '
</table>
<br />
</div>
<br />
</div>
<br />
<table class="hidden center">
<tr>
<td>';
// button to user account page, user account page has own security
makebutton(lang("char", "chars_acc"), 'user.php?action=edit_user&id=' . $owner_acc_id . '', 130);
$output .= '
</td>
<td>';
// only higher level GM with delete access can edit character
// character edit allows removal of character items, so delete permission is needed
if ($user_lvl > $owner_gmlvl && $user_lvl >= $action_permission["delete"]) {
//makebutton($lang_char["edit_button"], 'char_edit.php?id='.$id.'&realm='.$realmid.'', 130);
$output .= '
</td>
<td>';
}
// only higher level GM with delete access, or character owner can delete character
if ($user_lvl > $owner_gmlvl && $user_lvl >= $action_permission["delete"] || $owner_name === $user_name) {
makebutton(lang("char", "del_char"), 'char_list.php?action=del_char_form&check%5B%5D=' . $id . '" type="wrn', 130);
$output .= '
</td>
<td>';
}
// only GM with update permission can send mail, mail can send items, so update permission is needed
if ($user_lvl >= $action_permission["update"]) {
makebutton(lang("char", "send_mail"), 'mail.php?type=ingame_mail&to=' . $char["name"] . '', 130);
$output .= '
</td>
<td>';
}
makebutton(lang("global", "back"), 'javascript:window.history.back()" type="def', 130);
$output .= '
</td>
</tr>
</table>
<br />
<!-- end of char_achieve.php -->';
} else {
error(lang("char", "no_permission"));
}
} else {
error(lang("char", "no_char_found"));
}
}
function GraphSonda($chart, $id_chart, $id_plan, $id_item, $from, $avg, $tag)
{
$offset = getOffset();
// setTimezone();
$dt = getDates($from);
$index = 0;
$average = getAverage($avg);
$format = $average[0];
$divide = $average[1];
if ($divide == 60 * 60 * 6) {
$offset = -60 * 60 * 2;
}
if ($divide == 60 * 60 * 12) {
$offset = +60 * 60 * 4;
}
if ($divide == 60 * 60 * 24) {
$offset = +60 * 60 * 4;
}
$colorIndex = 0;
$ldata = loadRAWData($from, $id_plan, $id_item);
$percentile = calculatePercentile($ldata['allData']);
$div = $ldata['div'];
if (isset($ldata['hostList'])) {
foreach ($ldata['hostList'] as $host) {
$id_host = $host['id_host'];
$hostName = $host['host'];
$nacD = $host['nacD'];
$nacU = $host['nacU'];
$critical = $host['critical'];
$warning = $host['warning'];
$nominal = $host['nominal'];
if ($warning > 100) {
$dir = 1;
} else {
$dir = 0;
}
if ($nominal == -1) {
$nominal = $nacD;
}
if ($nominal == -2) {
$nominal = $nacU;
}
unset($theSondaAvg);
unset($theSondaQoE);
unset($dataAvg);
unset($dataQoE);
if (isset($ldata['historyList'][$id_host])) {
foreach ($ldata['historyList'][$id_host] as $key => $row) {
$tk = round($row['clock'] / $divide, 0) * $divide;
$skip = false;
if (isset($_SESSION['filter']['P95']) && $row['value'] > $percentile['P95']) {
$skip = true;
}
if (isset($_SESSION['filter']['P5']) && $row['value'] < $percentile['P5']) {
$skip = true;
}
if (!$skip) {
if (!isset($theSondaAvg[$tk])) {
$theSondaAvg[$tk] = array($tk, 0, 0);
}
if (!isset($theSondaQoE[$tk])) {
$theSondaQoE[$tk] = array($tk, 0, 0);
}
$sum = $theSondaAvg[$tk][1];
$cnt = $theSondaAvg[$tk][2];
$x = $sum + $row['value'];
$y = $cnt + 1;
$theSondaAvg[$tk] = array($tk, $x, $y);
if ($row['value'] > $nominal) {
$row['value'] = $nominal;
}
$sum = $theSondaQoE[$tk][1];
$cnt = $theSondaQoE[$tk][2];
$x = $sum + $row['value'];
$y = $cnt + 1;
$theSondaQoE[$tk] = array($tk, $x, $y);
}
}
}
if (isset($theSondaAvg)) {
aasort($theSondaAvg, 0);
$next = 0;
$prev = 0;
foreach ($theSondaAvg as $tvalue) {
$next = $tvalue[0] + $offset;
if ($prev > 0 && $next > 0 && $next - $prev > $divide * 2) {
$dataAvg[] = array(($prev + 1000) * 1000, null);
}
$dataAvg[] = array($next * 1000, round($tvalue[1] / $tvalue[2] / $div, 2));
$prev = $next;
}
aasort($theSondaQoE, 0);
$next = 0;
$prev = 0;
foreach ($theSondaQoE as $tvalue) {
$next = $tvalue[0] + $offset;
if ($prev > 0 && $next > 0 && $next - $prev > $divide * 2) {
$dataQoE[] = array(($prev + 1000) * 1000, null);
}
$dataQoE[] = array($next * 1000, round($tvalue[1] / $tvalue[2] / $div, 2));
$prev = $next;
}
}
if (isset($dataAvg)) {
if (!isset($minClock)) {
$minClock = $dataAvg[0][0];
$maxClock = $dataAvg[count($dataAvg) - 1][0];
} else {
if ($dataAvg[0][0] < $minClock) {
$minClock = $dataAvg[0][0];
}
if ($dataAvg[count($dataAvg) - 2][0] > $maxClock) {
$maxClock = $dataAvg[count($dataAvg) - 2][0];
}
}
if ($_GET['qoe'] == 'Average On' || $_GET['qoe'] == 'Both') {
$chart->series[]->name = $hostName . "-AVG";
$chart->series[$index]->type = 'spline';
$chart->series[$index]->dashStyle = 'spline';
$chart->series[$index]->data = $dataAvg;
$chart->series[$index]->color = getColor($colorIndex);
$chart->series[$index]->lineWidth = 1;
$chart->series[$index]->marker->radius = 2;
$index++;
}
if ($_GET['qoe'] == 'QoE On' || $_GET['qoe'] == 'Both') {
$chart->series[]->name = $hostName . '-QoE';
$chart->series[$index]->type = 'shortdot';
$chart->series[$index]->color = getColor($colorIndex);
$chart->series[$index]->data = $dataQoE;
$chart->series[$index]->lineWidth = 1;
$chart->series[$index]->marker->radius = 2;
$index++;
}
$colorIndex++;
}
}
}
$title = 'Sondas for "' . $ldata['item'] . '" on plan "' . $ldata['plan'] . '"';
$subtitle = 'From ' . $ldata['from'] . ' to ' . $ldata['to'];
$chart = chartHeader($chart, $id_chart, $title, $subtitle, $ldata['unit'], null);
if (!isset($minClock)) {
$minClock = 0;
$maxClock = 0;
}
$chart->xAxis->type = 'datetime';
$chart->tooltip->formatter = new HighchartJsExpr("\n function() {\n var s = '<b>'+ Highcharts.dateFormat('%e. %b %H:%M',this.x) +'</b>'; \n \$.each(this.points, function(i, point) {\n s += '<br/><span style=\"color:'+point.series.color+'\">'+ point.series.name +': '+ point.y +' " . $ldata['unit'] . "</span><b>';\n });\n return s;\n }");
echo "\n" . '<script> function redraw() { chart1.xAxis[0].setExtremes(' . $minClock . ', ' . (round($maxClock / (3600 * 24), 0) * 3600 * 24 + $divide * 1000) . ');} </script>';
//var_dump($chart->chart);
return $chart;
}
public function search_articles($q, $topic_ids = null, $page = 1, $limit = 20)
{
if ($topic_ids) {
$topic_ids = explode(',', $topic_ids);
array_walk_recursive($topic_ids, 'intval_string');
$where = "id IN(SELECT item_id FROM " . $this->get_table('topic_relation') . " WHERE topic_id IN(" . implode(',', $topic_ids) . ") AND `type` = 'article')";
}
$search_hash = $this->get_search_hash('article', 'title', $q, $where);
if (!($result = $this->fetch_cache($search_hash))) {
if ($result = $this->query_all($this->bulid_query('article', 'title', $q, $where), $this->max_results)) {
$result = aasort($result, 'score', 'DESC');
} else {
return false;
}
$this->save_cache($search_hash, $result);
}
if (!$page) {
$slice_offset = 0;
} else {
$slice_offset = ($page - 1) * $limit;
}
return array_slice($result, $slice_offset, $limit);
}
function searchIps($search, $serverID, $server, $sortByCol = 'name', $sortBy = 'ASC', $past = true)
{
global $settings;
$found = array();
switch ($sortByCol) {
default:
case 0:
// Name
$sort['bans'] = $sort['banrecords'] = 'b.id';
break;
case 1:
// Type
$sortByType = true;
$sort['bans'] = $sort['banrecords'] = 'b.id';
break;
case 2:
// By
$sort['bans'] = $sort['banrecords'] = 'actor_id';
break;
case 3:
// Reason
$sort['bans'] = $sort['banrecords'] = 'reason';
break;
case 4:
// Expires
$sort['bans'] = 'expires';
$sort['banrecords'] = 'expired';
break;
case 5:
// Date
$sort['bans'] = $sort['banrecords'] = 'created';
break;
}
if ($search == "%") {
$whereStatement = "";
} else {
// Check if search contains a "-", aka range search
if (strpos($search, '-') == true) {
$searchIPs = explode("-", $search);
// Make sure we only have two IP elements
if (count($searchIPs) == 2) {
$whereStatement = "WHERE ip BETWEEN INET_ATON('" . completeIPaddress($searchIPs[0], "start") . "') AND INET_ATON('" . completeIPaddress($searchIPs[1], "end") . "')";
} else {
return false;
}
} else {
// Check if IP is complete, if not complete and turn into range query
if ($search != completeIPaddress($search, "start")) {
$whereStatement = "WHERE ip BETWEEN INET_ATON('" . completeIPaddress($search, "start") . "') AND INET_ATON('" . completeIPaddress($search, "end") . "')";
// Otherwise search for exact IP
} else {
$whereStatement = "WHERE ip = INET_ATON('" . $search . "')";
}
}
}
// Found results
$found = array();
// Current Bans
$result = cache("SELECT b.ip, a.name AS actor_name, b.reason, b.created, b.expires FROM " . $server['ipBansTable'] . " b JOIN " . $server['playersTable'] . " a ON b.actor_id = a.id " . $whereStatement . " ORDER BY " . $sort['bans'] . " {$sortBy}", $settings['cache_search'], $serverID . '/search', $server);
if (isset($result[0]) && !is_array($result[0]) && !empty($result[0])) {
$result = array($result);
}
if ($result && count($result) > 0) {
foreach ($result as $r) {
array_push($found, array('ip' => long2ip($r['ip']), 'by' => $r['actor_name'], 'reason' => $r['reason'], 'type' => 'IP Ban', 'time' => $r['created'], 'expires' => $r['expires']));
}
}
if ($past) {
// Past Bans
$result = cache("SELECT b.ip, a.name AS actor_name, b.reason, b.created, b.expired FROM " . $server['ipBanRecordsTable'] . " b JOIN " . $server['playersTable'] . " a ON b.actor_id = a.id " . $whereStatement . " ORDER BY " . $sort['banrecords'] . " {$sortBy}", $settings['cache_search'], $serverID . '/search', $server);
if (isset($result[0]) && !is_array($result[0]) && !empty($result[0])) {
$result = array($result);
}
if ($result && count($result) > 0) {
foreach ($result as $r) {
if (!isset($found[long2ip($r['ip'])])) {
array_push($found, array('ip' => long2ip($r['ip']), 'by' => $r['actor_name'], 'reason' => $r['reason'], 'type' => 'IP Ban', 'time' => $r['created'], 'expires' => $r['expired'], 'past' => true));
} else {
if ($found[long2ip($r['ip'])]['created'] < $r['created']) {
array_push($found, array('ip' => long2ip($r['ip']), 'by' => $r['actor_name'], 'reason' => $r['reason'], 'type' => 'IP Ban', 'time' => $r['created'], 'expires' => $r['expired'], 'past' => false));
}
}
}
}
}
switch ($sortByCol) {
default:
case 0:
// Name
aasort($found, "ip", $sortBy);
break;
case 1:
// Type
aasort($found, "type", $sortBy);
break;
case 2:
// By
aasort($found, "by", $sortBy);
break;
case 3:
// Reason
aasort($found, "reason", $sortBy);
break;
case 4:
// Expires
aasort($found, "expires", $sortBy);
break;
case 5:
// Date
aasort($found, "time", $sortBy);
break;
}
if (count($found) == 0) {
return false;
} else {
if (count($found) == 1) {
// Redirect!
$p = array_keys($found);
redirect('index.php?action=viewip&ip=' . $p[0] . '&server=' . $serverID);
} else {
// STUFF
return $found;
}
}
}
function sortJSON($arr)
{
$arrOffline = array();
$arrLogin = array();
// split into 2 array
foreach ($arr as $key => $agent) {
if ($agent['agentstatus'] == 'offline') {
$arrOffline[$key] = $arr[$key];
} else {
$arrLogin[$key] = $arr[$key];
}
}
// Sort sec_calls of Offline agent
aasort($arrOffline, 'num_calls');
// Merg 2 array
return array_merge($arrLogin, $arrOffline);
}
function char_quest(&$sqlr, &$sqlc)
{
global $output, $lang_global, $lang_char, $realm_id, $world_db, $characters_db, $action_permission, $user_lvl, $user_name, $quest_datasite, $itemperpage;
wowhead_tt();
if (empty($_GET['id'])) {
error($lang_global['empty_fields']);
}
if (empty($_GET['realm'])) {
$realmid = $realm_id;
} else {
$realmid = $sqlr->quote_smart($_GET['realm']);
if (is_numeric($realmid)) {
$sqlc->connect($characters_db[$realmid]['addr'], $characters_db[$realmid]['user'], $characters_db[$realmid]['pass'], $characters_db[$realmid]['name']);
} else {
$realmid = $realm_id;
}
}
$id = $sqlc->quote_smart($_GET['id']);
if (is_numeric($id)) {
} else {
$id = 0;
}
//==========================$_GET and SECURE=================================
$start = isset($_GET['start']) ? $sqlc->quote_smart($_GET['start']) : 0;
if (is_numeric($start)) {
} else {
$start = 0;
}
$order_by = isset($_GET['order_by']) ? $sqlc->quote_smart($_GET['order_by']) : 1;
if (is_numeric($order_by)) {
} else {
$order_by = 1;
}
$dir = isset($_GET['dir']) ? $sqlc->quote_smart($_GET['dir']) : 0;
if (preg_match('/^[01]{1}$/', $dir)) {
} else {
$dir = 0;
}
$order_dir = $dir ? 'ASC' : 'DESC';
$dir = $dir ? 0 : 1;
//==========================$_GET and SECURE end=============================
$result = $sqlc->query('SELECT account, name, race, class, level, gender
FROM characters WHERE guid = ' . $id . ' LIMIT 1');
if ($sqlc->num_rows($result)) {
$char = $sqlc->fetch_assoc($result);
$owner_acc_id = $sqlc->result($result, 0, 'account');
$result = $sqlr->query('SELECT gmlevel, username FROM account WHERE id = ' . $char['account'] . '');
$owner_gmlvl = $sqlr->result($result, 0, 'gmlevel');
$owner_name = $sqlr->result($result, 0, 'username');
if ($user_lvl > $owner_gmlvl || $owner_name === $user_name) {
$output .= '
<center>
<div id="tab_content">
<div id="tab">
<ul>
<li><a href="char.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['char_sheet'] . '</a></li>
<li><a href="char_inv.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['inventory'] . '</a></li>
<li><a href="char_extra.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['extra'] . '</a></li>
' . ($char['level'] < 10 ? '' : '<li><a href="char_talent.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['talents'] . '</a></li>') . '
<li><a href="char_achieve.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['achievements'] . '</a></li>
<li><a href="char_rep.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['reputation'] . '</a></li>
<li><a href="char_skill.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['skills'] . '</a></li>';
if (char_get_class_name($char['class']) === 'Hunter') {
$output .= '
<li><a href="char_pets.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['pets'] . '</a></li>';
}
$output .= '
<li><a href="char_friends.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['friends'] . '</a></li>
<li><a href="char_spell.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['spells'] . '</a></li>
<li><a href="char_mail.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['mail'] . '</a></li>
</ul>
<ul>';
// selected char tab at last
$output .= '
<li id="selected"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '">' . $lang_char['quests'] . '</a></li>';
$output .= '
</ul>
</div>
<div id="tab_content2">
<font class="bold">
' . htmlentities($char['name']) . ' -
<img src="img/c_icons/' . $char['race'] . '-' . $char['gender'] . '.gif"
onmousemove="toolTip(\'' . char_get_race_name($char['race']) . '\', \'item_tooltip\')" onmouseout="toolTip()" alt="" />
<img src="img/c_icons/' . $char['class'] . '.gif"
onmousemove="toolTip(\'' . char_get_class_name($char['class']) . '\',\'item_tooltip\')" onmouseout="toolTip()" alt="" /> - lvl ' . char_get_level_color($char['level']) . '
</font>
<br /><br />
<table class="lined" style="width: 550px;">
<tr>
<th width="10%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=0&dir=' . $dir . '"' . ($order_by == 0 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_id'] . '</a></th>
<th width="7%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=1&dir=' . $dir . '"' . ($order_by == 1 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_level'] . '</a></th>
<th width="78%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=2&dir=' . $dir . '"' . ($order_by == 2 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_title'] . '</a></th>
<th width="5%"><img src="img/aff_qst.png" width="14" height="14" border="0" alt="" /></th>
</tr>';
$result = $sqlc->query('SELECT quest, status, rewarded FROM character_queststatus WHERE guid = ' . $id . ' AND ( status = 3 OR status = 1 ) ORDER BY status DESC');
$quests_1 = array();
$quests_3 = array();
if ($sqlc->num_rows($result)) {
while ($quest = $sqlc->fetch_assoc($result)) {
$deplang = get_lang_id();
$query1 = $sqlc->query('SELECT QuestLevel, IFNULL(' . ($deplang != 0 ? '`title_loc' . $deplang . '`' : 'NULL') . ', title) as Title FROM `' . $world_db[$realmid]['name'] . '`.`quest_template` LEFT JOIN `' . $world_db[$realmid]['name'] . '`.`locales_quest` ON `quest_template`.`entry` = `locales_quest`.`entry` WHERE `quest_template`.`entry` = \'' . $quest['quest'] . '\'');
$quest_info = $sqlc->fetch_assoc($query1);
if (1 == $quest['status']) {
array_push($quests_1, array($quest['quest'], $quest_info['QuestLevel'], $quest_info['Title'], $quest['rewarded']));
} else {
array_push($quests_3, array($quest['quest'], $quest_info['QuestLevel'], $quest_info['Title']));
}
}
unset($quest);
unset($quest_info);
aasort($quests_1, $order_by, $dir);
$orderby = $order_by;
if (2 < $orderby) {
$orderby = 1;
}
aasort($quests_3, $orderby, $dir);
$all_record = count($quests_1);
foreach ($quests_3 as $data) {
$output .= '
<tr>
<td>' . $data[0] . '</td>
<td>(' . $data[1] . ')</td>
<td align="left"><a href="' . $quest_datasite . $data[0] . '" target="_blank">' . htmlentities($data[2]) . '</a></td>
<td><img src="img/aff_qst.png" width="14" height="14" alt="" /></td>
</tr>';
}
unset($quest_3);
if (count($quests_1)) {
$output .= '
</table>
<table class="hidden" style="width: 550px;">
<tr align="right">
<td>';
$output .= generate_pagination('char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=' . $order_by . '&dir=' . ($dir ? 0 : 1), $all_record, $itemperpage, $start);
$output .= '
</td>
</tr>
</table>
<table class="lined" style="width: 550px;">
<tr>
<th width="10%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=0&dir=' . $dir . '"' . ($order_by == 0 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_id'] . '</a></th>
<th width="7%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=1&dir=' . $dir . '"' . ($order_by == 1 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_level'] . '</a></th>
<th width="68%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=2&dir=' . $dir . '"' . ($order_by == 2 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['quest_title'] . '</a></th>
<th width="10%"><a href="char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=3&dir=' . $dir . '"' . ($order_by == 3 ? ' class="' . $order_dir . '"' : '') . '>' . $lang_char['rewarded'] . '</a></th>
<th width="5%"><img src="img/aff_tick.png" width="14" height="14" border="0" alt="" /></th>
</tr>';
$i = 0;
foreach ($quests_1 as $data) {
if ($i < $start + $itemperpage && $i >= $start) {
$output .= '
<tr>
<td>' . $data[0] . '</td>
<td>(' . $data[1] . ')</td>
<td align="left"><a href="' . $quest_datasite . $data[0] . '" target="_blank">' . htmlentities($data[2]) . '</a></td>
<td><img src="img/aff_' . ($data[3] ? 'tick' : 'qst') . '.png" width="14" height="14" alt="" /></td>
<td><img src="img/aff_tick.png" width="14" height="14" alt="" /></td>
</tr>';
}
$i++;
}
unset($data);
unset($quest_1);
$output .= '
<tr align="right">
<td colspan="5">';
$output .= generate_pagination('char_quest.php?id=' . $id . '&realm=' . $realmid . '&start=' . $start . '&order_by=' . $order_by . '&dir=' . ($dir ? 0 : 1), $all_record, $itemperpage, $start);
$output .= '
</td>
</tr>';
}
} else {
$output .= '
<tr>
<td colspan="4"><p>' . $lang_char['no_act_quests'] . '</p></td>
</tr>';
}
//---------------Page Specific Data Ends here----------------------------
//---------------Character Tabs Footer-----------------------------------
$output .= '
</table>
</div>
</div>
<br />
<table class="hidden">
<tr>
<td>';
// button to user account page, user account page has own security
makebutton($lang_char['chars_acc'], 'user.php?action=edit_user&id=' . $owner_acc_id . '', 130);
$output .= '
</td>
<td>';
// only higher level GM with delete access can edit character
// character edit allows removal of character items, so delete permission is needed
if ($user_lvl > $owner_gmlvl && $user_lvl >= $action_permission['delete']) {
makebutton($lang_char['edit_button'], 'char_edit.php?id=' . $id . '&realm=' . $realmid . '', 130);
$output .= '
</td>
<td>';
}
// only higher level GM with delete access, or character owner can delete character
if ($user_lvl > $owner_gmlvl && $user_lvl >= $action_permission['delete'] || $owner_name === $user_name) {
makebutton($lang_char['del_char'], 'char_list.php?action=del_char_form&check%5B%5D=' . $id . '" type="wrn', 130);
$output .= '
</td>
<td>';
}
// only GM with update permission can send mail, mail can send items, so update permission is needed
if ($user_lvl >= $action_permission['update']) {
makebutton($lang_char['send_mail'], 'mail.php?type=ingame_mail&to=' . $char['name'] . '', 130);
$output .= '
</td>
<td>';
}
makebutton($lang_global['back'], 'javascript:window.history.back()" type="def', 130);
$output .= '
</td>
</tr>
</table>
<br />
</center>
<!-- end of char_quest.php -->';
} else {
error($lang_char['no_permission']);
}
} else {
error($lang_char['no_char_found']);
}
}
$order_supplier[$current_order][$sup_key]['place'] = $supplier['place'];
$order_supplier[$current_order][$sup_key]['art'] = $supplier['art'];
}
}
}
$tpl->Assign("os", $order_supplier);
$tpl->Assign("sorders", $supplier_order);
$tpl->Assign("orders", $orders_data);
$tpl->Assign("contragent", $contragent_data);
function aasort(&$array, $key)
{
$sorter = array();
$ret = array();
reset($array);
foreach ($array as $ii => $va) {
$sorter[$ii] = $va[$key];
}
asort($sorter, SORT_STRING);
foreach ($sorter as $ii => $va) {
$ret[$ii] = $array[$ii];
}
$array = $ret;
}
aasort($suppliers_data, "art");
$tpl->Assign('suppliers', $suppliers_data);
$suppliers_altern = array();
$Order->GetSuppliersAltern($order_id);
$suppliers_altern = $Order->list;
$tpl->Assign('suppliers_altern', $suppliers_altern);
echo $tpl->Parse($GLOBALS['PATH_tpl'] . 'composed_invoice.tpl');
exit(0);
<?php /* Module Loader */ $lethe_modules = array(); include_once LETHE_MODULES . '/lethe.autoresponder/module.conf.php'; include_once LETHE_MODULES . '/lethe.newsletter/module.conf.php'; include_once LETHE_MODULES . '/lethe.organizations/module.conf.php'; include_once LETHE_MODULES . '/lethe.subscribers/module.conf.php'; include_once LETHE_MODULES . '/lethe.templates/module.conf.php'; aasort($lethe_modules, 'sort');
public function get_related_question_list($question_id, $question_content, $limit = 10)
{
$cache_key = 'question_related_list_' . md5($question_content) . '_' . $limit;
if ($question_related_list = AWS_APP::cache()->get($cache_key)) {
return $question_related_list;
}
if ($question_keywords = $this->model('system')->analysis_keyword($question_content)) {
if (sizeof($question_keywords) <= 1) {
return false;
}
if ($question_list = $this->query_all($this->model('search_fulltext')->bulid_query('question', 'question_content', $question_keywords), 2000)) {
$question_list = aasort($question_list, 'score', 'DESC');
$question_list = aasort($question_list, 'agree_count', 'DESC');
$question_list = array_slice($question_list, 0, $limit + 1);
foreach ($question_list as $key => $val) {
if ($val['question_id'] == $question_id) {
unset($question_list[$key]);
} else {
if (!isset($question_related[$val['question_id']])) {
$question_related[$val['question_id']] = $val['question_content'];
$question_info[$val['question_id']] = $val;
}
}
}
}
}
if ($question_related) {
foreach ($question_related as $key => $question_content) {
$question_related_list[] = array('question_id' => $key, 'question_content' => $question_content, 'answer_count' => $question_info[$key]['answer_count']);
}
}
if (sizeof($question_related) > $limit) {
array_pop($question_related);
}
AWS_APP::cache()->set($cache_key, $question_related_list, get_setting('cache_level_low'));
return $question_related_list;
}
function pp_shortcode_generator_options()
{
$plugin_url = get_stylesheet_directory_uri() . '/plugins/shortcode_generator';
//Get all galleries
$args = array('numberposts' => -1, 'post_type' => array('galleries'));
$galleries_arr = get_posts($args);
$galleries_select = array();
$galleries_select[''] = '';
foreach ($galleries_arr as $gallery) {
$galleries_select[$gallery->ID] = $gallery->post_title;
}
//Get all client categories
$client_cat_arr = get_terms('clientcats', 'hide_empty=0&hierarchical=0&parent=0');
$client_cat_select = array();
$client_cat_select[''] = '';
foreach ($client_cat_arr as $client_cat) {
$client_cat_select[$client_cat->slug] = $client_cat->name;
}
//Get all testimonials categories
$testimonial_cat_arr = get_terms('testimonialcats', 'hide_empty=0&hierarchical=0&parent=0');
$testimonial_cat_select = array();
$testimonial_cat_select[''] = '';
foreach ($testimonial_cat_arr as $testimonial_cat) {
$testimonial_cat_select[$testimonial_cat->slug] = $testimonial_cat->name;
}
//Get all button colors options
$button_color_arr = array('black' => 'black', 'grey' => 'grey', 'blue' => 'blue', 'yellow' => 'yellow', 'red' => 'red', 'orange' => 'orange', 'dark blue' => 'dark blue', 'green' => 'green', 'emerald' => 'emerald', 'pink' => 'pink', 'purple' => 'purple');
//Begin shortcode array
$shortcodes = array('dropcap' => array('name' => 'Dropcap', 'attr' => array(), 'desc' => array(), 'content' => TRUE), 'quote' => array('name' => 'Quote Text', 'attr' => array(), 'desc' => array(), 'content' => TRUE), 'tg_button' => array('name' => 'Button', 'attr' => array('href' => 'text', 'color' => 'select', 'bg_color' => 'text', 'text_color' => 'text'), 'desc' => array('href' => 'Enter URL for button', 'color' => 'Select predefined button colors', 'bg_color' => 'Enter custom button background color code ex. #4ec380', 'text_color' => 'Enter custom button text color code ex. #ffffff'), 'options' => $button_color_arr, 'content' => TRUE, 'content_text' => 'Enter text on button'), 'tg_alert_box' => array('name' => 'Alert Box', 'attr' => array('style' => 'select'), 'desc' => array('style' => 'Select content style'), 'options' => array('error' => 'error', 'success' => 'success', 'notice' => 'notice'), 'content' => TRUE), 'one_half' => array('name' => 'One Half Column', 'attr' => array(), 'desc' => array(), 'content' => TRUE, 'repeat' => 1), 'one_half_last' => array('name' => 'One Half Last Column', 'attr' => array(), 'desc' => array(), 'content' => TRUE, 'repeat' => 1), 'one_third' => array('name' => 'One Third Column', 'attr' => array(), 'desc' => array(), 'content' => TRUE, 'repeat' => 2), 'one_third_last' => array('name' => 'One Third Last Column', 'attr' => array(), 'desc' => array(), 'content' => TRUE), 'two_third' => array('name' => 'Two Third Column', 'attr' => array(), 'desc' => array(), 'content' => TRUE), 'two_third_last' => array('name' => 'Two Third Last Column', 'attr' => array(), 'desc' => array(), 'content' => TRUE), 'one_fourth' => array('name' => 'One Fourth Column', 'attr' => array(), 'desc' => array(), 'content' => TRUE, 'repeat' => 3), 'one_fifth' => array('name' => 'One Fifth Column', 'attr' => array(), 'desc' => array(), 'content' => TRUE, 'repeat' => 4), 'one_sixth' => array('name' => 'One Sixth Column', 'attr' => array(), 'desc' => array(), 'content' => TRUE, 'repeat' => 5), 'one_half_bg' => array('name' => 'One Half Column With Background', 'attr' => array('bg' => 'text'), 'desc' => array('bg' => 'Enter background image URL'), 'content' => TRUE), 'one_third_bg' => array('name' => 'One Third Column With Background', 'attr' => array('bg' => 'text'), 'desc' => array('bg' => 'Enter background image URL'), 'content' => TRUE), 'two_third_bg' => array('name' => 'Two Third Column With Background', 'attr' => array('bg' => 'text'), 'desc' => array('bg' => 'Enter background image URL'), 'content' => TRUE), 'one_fourth_bg' => array('name' => 'One Fourth Column With Background', 'attr' => array('bg' => 'text'), 'desc' => array('bg' => 'Enter background image URL'), 'content' => TRUE), 'tg_map' => array('name' => 'Google Map', 'attr' => array('type' => 'select', 'width' => 'text', 'height' => 'text', 'lat' => 'text', 'long' => 'text', 'zoom' => 'text', 'popup' => 'text'), 'desc' => array('type' => 'Select map display type', 'width' => 'Map width in pixels', 'height' => 'Map height in pixels', 'lat' => 'Map latitude <a href="http://www.tech-recipes.com/rx/5519/the-easy-way-to-find-latitude-and-longitude-values-in-google-maps/">Find here</a>', 'long' => 'Map longitude <a href="http://www.tech-recipes.com/rx/5519/the-easy-way-to-find-latitude-and-longitude-values-in-google-maps/">Find here</a>', 'zoom' => 'Enter zoom number (1-16)', 'popup' => 'Enter text to display as popup above location on map for example. your company name'), 'content' => FALSE, 'options' => array('MapTypeId.ROADMAP' => 'Roadmap', 'MapTypeId.SATELLITE' => 'Satellite', 'MapTypeId.HYBRID' => 'Hybrid', 'MapTypeId.TERRAIN' => 'Terrain')), 'googlefont_func' => array('name' => 'Google Font', 'attr' => array('font' => 'text', 'fontsize' => 'text'), 'desc' => array('font' => 'Enter Google Web Font Name you want to use', 'fontsize' => 'Enter font size in pixels'), 'content' => FALSE), 'tg_gallery_slider' => array('name' => 'Gallery Slider', 'attr' => array('gallery_id' => 'select'), 'options' => $galleries_select, 'desc' => array('gallery_id' => 'Select gallery you want to display its images'), 'content' => FALSE), 'tg_social_icons' => array('name' => 'Social Icons', 'attr' => array('style' => 'select', 'size' => 'text'), 'options' => array('dark' => 'Dark', 'light' => 'Light'), 'desc' => array('style' => 'Select color style for social icons', 'size' => 'Enter icon size between small and large'), 'content' => FALSE), 'tg_promo_box' => array('name' => 'Promo Box', 'attr' => array('title' => 'text', 'border' => 'text', 'shadow' => 'select', 'button_text' => 'text', 'button_url' => 'text'), 'options' => array(0 => 'No Shadow', 1 => 'Display Shadow'), 'desc' => array('title' => 'Enter promo box title', 'border' => 'Enter border color code. For example #3facd6', 'shadow' => 'Select "Display Shadow" if you want to display promo box drop shadow', 'button_text' => 'Enter promo box button text. For example More Info', 'button_url' => 'Enter promo box button link URL'), 'content' => TRUE), 'tg_accordion' => array('name' => 'Accordion & Toggle', 'attr' => array('title' => 'text', 'icon' => 'text', 'close' => 'select'), 'desc' => array('title' => 'Enter Accordion\'s title', 'icon' => 'Enter icon class name ex. fa-star. <a href="http://fontawesome.io/cheatsheet/">See all possible here</a>', 'close' => 'Select default status (close or open)'), 'content' => TRUE, 'options' => array(0 => 'Open', 1 => 'Close')), 'tg_image' => array('name' => 'Image Animation', 'attr' => array('src' => 'text', 'animation' => 'select'), 'desc' => array('src' => 'Enter image URL', 'animation' => 'Select animation type'), 'content' => TRUE, 'options' => array('slideRight' => 'Slide Right', 'slideLeft' => 'Slide Left', 'slideUp' => 'Slide Up', 'fadeIn' => 'Fade In'), 'content' => FALSE), 'tg_divider' => array('name' => 'Divider', 'attr' => array('style' => 'select'), 'desc' => array('style' => 'Select HR divider style'), 'options' => array('normal' => 'Normal', 'thick' => 'Thick', 'dotted' => 'Dotted', 'dashed' => 'Dashed', 'faded' => 'Faded', 'totop' => 'Go To Top'), 'content' => FALSE), 'tg_teaser' => array('name' => 'Image Teaser', 'attr' => array('columns' => 'select', 'image' => 'text', 'title' => 'text', 'align' => 'text'), 'desc' => array('columns' => 'Select ligthbox content type', 'image' => 'Enter full image URL', 'title' => 'Enter teaser title', 'align' => 'Enter teaser content text align from left, center and right'), 'options' => array('one' => 'Fullwidth', 'one_half' => 'One Half', 'one_half last' => 'One Half Last', 'one_third' => 'One Third', 'one_half last' => 'One Third Last', 'one_fourth' => 'One Fourth', 'one_fourth last' => 'One Fourth Last'), 'content' => TRUE), 'tg_lightbox' => array('name' => 'Media Lightbox', 'attr' => array('type' => 'select', 'src' => 'text', 'href' => 'text', 'vimeo_id' => 'text', 'youtube_id' => 'text'), 'desc' => array('type' => 'Select ligthbox content type', 'src' => 'Enter lightbox preview image URL', 'href' => 'If you selected "Image". Enter full image URL here', 'vimeo_id' => 'If you selected "Vimeo". Enter Vimeo video ID here ex. 82095744', 'youtube_id' => 'If you selected "Youtube". Enter Youtube video ID here ex. hT_nvWreIhg'), 'content' => TRUE, 'options' => array('image' => 'Image', 'vimeo' => 'Vimeo', 'youtube' => 'Youtube'), 'content' => FALSE), 'tg_youtube' => array('name' => 'Youtube Video', 'attr' => array('width' => 'text', 'height' => 'text', 'video_id' => 'text'), 'desc' => array('width' => 'Enter video width in pixels', 'height' => 'Enter video height in pixels', 'video_id' => 'Enter Youtube video ID here ex. hT_nvWreIhg'), 'content' => FALSE), 'tg_vimeo' => array('name' => 'Vimeo Video', 'attr' => array('width' => 'text', 'height' => 'text', 'video_id' => 'text'), 'desc' => array('width' => 'Enter video width in pixels', 'height' => 'Enter video height in pixels', 'video_id' => 'Enter Vimeo video ID here ex. 82095744'), 'content' => FALSE), 'tg_animate_counter' => array('name' => 'Animated Counter', 'attr' => array('start' => 'text', 'end' => 'text', 'fontsize' => 'text', 'fontcolor' => 'text', 'count_subject' => 'text'), 'desc' => array('start' => 'Enter start number ex. 0', 'end' => 'Enter end number ex. 100', 'fontsize' => 'Enter counter number font size in pixel ex. 38', 'fontcolor' => 'Enter counter number font color code ex. #000000', 'count_subject' => 'Enter count subject ex. followers'), 'content' => TRUE), 'tg_animate_bar' => array('name' => 'Animated Progress Bar', 'attr' => array('percent' => 'text', 'color' => 'text'), 'desc' => array('percent' => 'Enter number of percent value (maximum 100)', 'color' => 'Enter progress background color code ex. #000000'), 'content' => TRUE), 'tg_animate_circle' => array('name' => 'Animated Circle', 'attr' => array('percent' => 'text', 'dimension' => 'text', 'width' => 'text', 'color' => 'text', 'fontsize' => 'text', 'subject' => 'text'), 'desc' => array('percent' => 'Enter percent completion number ex. 90', 'dimension' => 'Enter circle dimension ex. 200', 'width' => 'Enter circle border width ex. 10', 'color' => 'Enter circle border color code ex. #000000', 'fontsize' => 'Enter title font size in pixel ex. 38', 'subject' => 'Enter circle subject info ex. completion'), 'content' => TRUE), 'tg_pricing' => array('name' => 'Pricing', 'attr' => array('columns' => 'select', 'items' => 'text'), 'desc' => array('columns' => 'Select Number of Pricing Columns', 'items' => 'Enter number of items you want to display'), 'content' => TRUE, 'options' => array(2 => '2 Columns', 3 => '3 Columns', 4 => '4 Columns'), 'content' => FALSE), 'ppb_client_carousel' => array('name' => 'Client Logo Carousel', 'attr' => array('cat' => 'select', 'items' => 'text'), 'options' => $client_cat_select, 'desc' => array('cat' => 'Select client category you want to display its contents', 'items' => 'Enter number of items you want to display'), 'content' => FALSE), 'tg_team' => array('name' => 'Team', 'attr' => array('columns' => 'select', 'items' => 'text'), 'desc' => array('columns' => 'Select Number of Columns to display', 'items' => 'Enter number of items you want to display'), 'content' => TRUE, 'options' => array(2 => '2 Columns', 3 => '3 Columns', 4 => '4 Columns'), 'content' => FALSE), 'tg_testimonial' => array('name' => 'Testimonials', 'attr' => array('columns' => 'select', 'items' => 'text'), 'desc' => array('columns' => 'Select Number of Columns to display', 'items' => 'Enter number of items you want to display'), 'options' => array(2 => '2 Columns', 3 => '3 Columns', 4 => '4 Columns'), 'content' => FALSE), 'tg_testimonial_slider' => array('name' => 'Testimonials Slider', 'attr' => array('cat' => 'select', 'items' => 'text'), 'desc' => array('cat' => 'Select testimonials category you want to display its contents', 'items' => 'Enter number of items you want to display'), 'options' => $testimonial_cat_select, 'content' => FALSE), 'tg_header' => array('name' => 'Header', 'attr' => array('title' => 'text', 'subtitle' => 'text'), 'desc' => array('title' => 'Enter header title', 'subtitle' => 'Enter header subtitle'), 'content' => FALSE), 'tg_program' => array('name' => 'Tour Program', 'attr' => array('title' => 'text', 'place' => 'text'), 'desc' => array('title' => 'Enter title of tour program ex. Day 1', 'subtitle' => 'Enter tour program places ex. Rome, Venice'), 'content' => TRUE));
aasort($shortcodes, "name");
?>
<script>
function nl2br (str, is_xhtml) {
var breakTag = (is_xhtml || typeof is_xhtml === 'undefined') ? '<br />' : '<br>';
return (str + '').replace(/([^>\r\n]?)(\r\n|\n\r|\r|\n)/g, '$1'+ breakTag +'$2');
}
jQuery(document).ready(function(){
jQuery('#shortcode_select').change(function() {
var target = jQuery(this).val();
jQuery('.rm_section').hide()
jQuery('#div_'+target).fadeIn()
});
jQuery('.code_area').click(function() {
document.getElementById(jQuery(this).attr('id')).focus();
document.getElementById(jQuery(this).attr('id')).select();
});
jQuery('.shortcode_button').click(function() {
var target = jQuery(this).attr('id');
var gen_shortcode = '';
gen_shortcode+= '['+target;
if(jQuery('#'+target+'_attr_wrapper .attr').length > 0)
{
jQuery('#'+target+'_attr_wrapper .attr').each(function() {
gen_shortcode+= ' '+jQuery(this).attr('name')+'="'+jQuery(this).val()+'"';
});
}
gen_shortcode+= ']';
if(jQuery('#'+target+'_content').length > 0)
{
gen_shortcode+= jQuery('#'+target+'_content').val()+'[/'+target+']';
gen_shortcode+= '\n';
var repeat = jQuery('#'+target+'_content_repeat').val();
for (count=1;count<=repeat;count=count+1)
{
if(count<repeat)
{
gen_shortcode+= '['+target+']';
gen_shortcode+= jQuery('#'+target+'_content').val()+'[/'+target+']';
gen_shortcode+= '\n';
}
else
{
gen_shortcode+= '['+target+'_last]';
gen_shortcode+= jQuery('#'+target+'_content').val()+'[/'+target+'_last]';
gen_shortcode+= '\n';
}
}
}
jQuery('#'+target+'_code').val(gen_shortcode);
jQuery('#pp-insert-to-post').attr('rel', '#'+target+'_code');
jQuery("#"+target+"-pp-insert-to-post").click(function() {
var current_id = jQuery(this).attr('rel');
var current_code = jQuery('#'+target+'_code').val();
tinyMCE.activeEditor.selection.setContent(nl2br(current_code));
});
});
});
</script>
<div style="padding:20px 10px 10px 10px">
<?php
if (!empty($shortcodes)) {
?>
<strong>Select Shortcode</strong><hr class="pp_widget_hr">
<div class="pp_widget_description">Please select short code from list below then enter short code attributes and click "Generate Shortcode". <a href="<?php
echo THEMEDEMOURL;
?>
" target="_blank">Go to demo site</a> and click "Shortcode" to see all short codes available and their sample code.</div>
<br/>
<select id="shortcode_select">
<option value="">(no short code selected)</option>
<?php
foreach ($shortcodes as $shortcode_name => $shortcode) {
$shortcode_key = $shortcode_name;
if (isset($shortcodes[$shortcode_name]['name'])) {
$shortcode_name = $shortcodes[$shortcode_name]['name'];
}
?>
<option value="<?php
echo $shortcode_key;
?>
"><?php
echo $shortcode_name;
?>
</option>
<?php
}
?>
</select>
<?php
}
?>
<br/><br/>
<?php
if (!empty($shortcodes)) {
foreach ($shortcodes as $shortcode_name => $shortcode) {
?>
<div id="div_<?php
echo $shortcode_name;
?>
" class="rm_section" style="display:none">
<div style="width:47%;float:left">
<div class="rm_title">
<h3><?php
echo ucfirst($shortcode_name);
?>
</h3>
<div class="clearfix"></div>
</div>
<div class="rm_text" style="padding: 10px 0 20px 0">
<!-- img src="<?php
echo $plugin_url . '/' . $shortcode_name . '.png';
?>
" alt=""/><br/><br/><br/ -->
<?php
if (isset($shortcode['content']) && $shortcode['content']) {
if (isset($shortcode['content_text'])) {
$content_text = $shortcode['content_text'];
} else {
$content_text = 'Your Content';
}
?>
<strong><?php
echo $content_text;
?>
:</strong><br/><br/>
<?php
if (isset($shortcode['repeat'])) {
?>
<input type="hidden" id="<?php
echo $shortcode_name;
?>
_content_repeat" value="<?php
echo $shortcode['repeat'];
?>
"/>
<?php
}
?>
<textarea id="<?php
echo $shortcode_name;
?>
_content" style="width:100%;height:70px" rows="3" wrap="off"></textarea><br/><br/>
<?php
}
?>
<?php
if (isset($shortcode['attr']) && !empty($shortcode['attr'])) {
?>
<div id="<?php
echo $shortcode_name;
?>
_attr_wrapper">
<?php
foreach ($shortcode['attr'] as $attr => $type) {
?>
<?php
echo '<strong>' . ucfirst($attr) . '</strong>: ' . $shortcode['desc'][$attr];
?>
<br/><br/>
<?php
switch ($type) {
case 'text':
?>
<input type="text" id="<?php
echo $shortcode_name;
?>
_text" style="width:100%" class="attr" name="<?php
echo $attr;
?>
"/>
<?php
break;
case 'select':
?>
<select id="<?php
echo $shortcode_name;
?>
_select" style="width:100%" class="attr" name="<?php
echo $attr;
?>
">
<?php
if (isset($shortcode['options']) && !empty($shortcode['options'])) {
foreach ($shortcode['options'] as $select_key => $option) {
?>
<option value="<?php
echo $select_key;
?>
"><?php
echo $option;
?>
</option>
<?php
}
}
?>
</select>
<?php
break;
}
?>
<br/><br/>
<?php
}
//end attr foreach
?>
</div>
<?php
}
?>
</div>
</div>
<div style="width:47%;float:right">
<strong>Shortcode:</strong><br/><br/>
<textarea id="<?php
echo $shortcode_name;
?>
_code" style="width:100%;height:200px" rows="3" readonly="readonly" class="code_area" wrap="off"></textarea>
<br/><br/>
<input type="button" id="<?php
echo $shortcode_name;
?>
" value="Generate Shortcode" class="button shortcode_button button-primary"/>
</div>
<br style="clear:both"/>
</div>
<?php
}
//end shortcode foreach
}
?>
</div>
<?php
}
