function do_block($page, $param1, $param2) { $num = (int) trim($param1) > 0 ? (int) trim($param1) : 15; $exp = array(); foreach (array_map('trim', explode("\n", $param2)) as $s) { if ($s != '') { $exp[] = $s; } } $db = DataBase::getinstance(); $query = "SELECT pagename,timestamp FROM page"; if ($exp != array()) { $_exp = $db->escape('(?:' . join('|', $exp) . ')'); $query .= " WHERE php('mb_ereg', '{$_exp}', pagename) = 0"; } $query .= " ORDER BY timestamp DESC, pagename ASC LIMIT {$num}"; $result = $db->query($query); $list = array(); while ($row = $db->fetch($result)) { $list[date('Y-m-d', $row['timestamp'])][] = makelink(Page::getinstance($row['pagename'])); } $smarty = $this->getSmarty(); $smarty->assign('list', $list); return $smarty->fetch('recent.tpl.htm'); }
/** * Generate the Honor List * * @return string */ function generateHsList() { global $roster; //Highest Lifetime Rank $query = "SELECT `name`, `lifetimeRankName` FROM `" . $roster->db->table('players') . "` WHERE `guild_id` = '" . $roster->data['guild_id'] . "' ORDER BY `lifetimeHighestRank`DESC, `lifetimeHK` DESC LIMIT 0 , 1"; $result = $roster->db->query($query) or die_quietly($roster->db->error(), 'Database Error', __FILE__, __LINE__, $query); $row = $roster->db->fetch($result); if ($row) { $roster->tpl->assign_block_vars('hslist', array('ROW_CLASS' => $roster->switch_row_class(), 'LINK' => makelink('guild-memberslist-honorlist'), 'VALUE' => $roster->locale->act['hslist1'], 'NAME' => $row['name'], 'COUNT' => $row['lifetimeRankName'] ? $row['lifetimeRankName'] : ' ')); } //Highest LifeTime HKs $query = "SELECT `name`, `lifetimeHK` FROM `" . $roster->db->table('players') . "` WHERE `guild_id` = '" . $roster->data['guild_id'] . "' ORDER BY `lifetimeHK` DESC, `lifetimeHighestRank` DESC LIMIT 0 , 1"; $result = $roster->db->query($query) or die_quietly($roster->db->error(), 'Database Error', __FILE__, __LINE__, $query); $row = $roster->db->fetch($result); if ($row) { $roster->tpl->assign_block_vars('hslist', array('ROW_CLASS' => $roster->switch_row_class(), 'LINK' => makelink('guild-memberslist-honorlist'), 'VALUE' => $roster->locale->act['hslist2'], 'NAME' => $row['name'], 'COUNT' => $row['lifetimeHK'])); } //Highest honorpoints $query = "SELECT `name`, `honorpoints` FROM `" . $roster->db->table('players') . "` WHERE `guild_id` = '" . $roster->data['guild_id'] . "' ORDER BY `honorpoints` DESC LIMIT 0 , 1"; $result = $roster->db->query($query) or die_quietly($roster->db->error(), 'Database Error', __FILE__, __LINE__, $query); $row = $roster->db->fetch($result); if ($row) { $roster->tpl->assign_block_vars('hslist', array('ROW_CLASS' => $roster->switch_row_class(), 'LINK' => makelink('guild-memberslist-honorlist'), 'VALUE' => $roster->locale->act['hslist3'], 'NAME' => $row['name'], 'COUNT' => $row['honorpoints'])); } //Highest arenapoints $query = "SELECT `name`, `arenapoints` FROM `" . $roster->db->table('players') . "` WHERE `guild_id` = '" . $roster->data['guild_id'] . "' ORDER BY `arenapoints` DESC LIMIT 0 , 1"; $result = $roster->db->query($query) or die_quietly($roster->db->error(), 'Database Error', __FILE__, __LINE__, $query); $row = $roster->db->fetch($result); if ($row) { $roster->tpl->assign_block_vars('hslist', array('ROW_CLASS' => $roster->switch_row_class(), 'LINK' => makelink('guild-memberslist-honorlist'), 'VALUE' => $roster->locale->act['hslist4'], 'NAME' => $row['name'], 'COUNT' => $row['arenapoints'])); } $roster->db->free_result($result); $roster->tpl->set_handle('hslist', 'hslist.html'); return $roster->tpl->fetch('hslist'); }
function table_dns() { global $construct, $db, $vars; $form_search_dns = $this->form_search_dns(); if (substr($form_search_dns->data[1]['value'], -strlen("." . $vars['dns']['root_zone'])) == "." . $vars['dns']['root_zone']) { $form_search_dns->data[1]['value'] = substr($form_search_dns->data[1]['value'], 0, -strlen("." . $vars['dns']['root_zone'])); } $where = $form_search_dns->db_data_where(array("dns_zones__name" => "starts_with")); $table_dns = new table(array('TABLE_NAME' => 'table_dns', 'FORM_NAME' => 'table_dns')); $table_dns->db_data('dns_zones.id AS dns_zones__id, dns_zones.name AS dns_zones__name, dns_zones.type, dns_zones.date_in, dns_zones.status, nodes.name AS nodes__name, nodes.id AS nodes__id', 'dns_zones LEFT JOIN nodes ON dns_zones.node_id = nodes.id', $where, "", "dns_zones.status ASC, dns_zones.type ASC, dns_zones.name ASC"); for ($i = 1; $i < count($table_dns->data); $i++) { if (isset($table_dns->data[$i])) { $table_dns->data[$i]['nodes__name'] .= " (#" . $table_dns->data[$i]['nodes__id'] . ")"; if ($table_dns->data[$i]['type'] == 'forward') { $table_dns->data[$i]['dns_zones__name'] .= "." . $vars['dns']['root_zone']; } $table_dns->info['EDIT'][$i] = makelink(array("page" => "nodes", "node" => $table_dns->data[$i]['nodes__id'])); } } $table_dns->info['EDIT_COLUMN'] = 'nodes__name'; $table_dns->db_data_remove('dns_zones__id', 'type', 'nodes__id'); $table_dns->db_data_translate('dns_zones__status'); return $table_dns; }
function do_block($page, $param1, $param2) { $prefix = resolvepath(trim($param1)); if ($prefix == '') { $prefix = $page->getpagename(); } $prefix .= '/'; $db = DataBase::getinstance(); $query = "SELECT pagename FROM page"; $query .= " WHERE pagename like '{$prefix}%'"; $query .= " ORDER BY pagename ASC"; $result = $db->query($query); $list = array(); while ($row = $db->fetch($result)) { $list[] = $row['pagename']; } if ($list == array()) { return ''; } natsort($list); $len = strlen($prefix); foreach ($list as $pagename) { $link[] = '<li>' . makelink(Page::getinstance($pagename), substr($pagename, $len)) . '</li>'; } return "<ul>\n" . join("\n", $link) . "\n</ul>\n"; }
function search($search, $limit = 10, $page = 0) { global $roster; $first = $page * $limit; $sql = "SELECT `member_id`, `name`, `server`, `region`, `guild_id`, `class`, `level`, `note`, `guild_rank`,`guild_title`, `zone`, `last_online`" . " FROM `" . $roster->db->table('members') . "`" . " WHERE (`member_id` LIKE '%{$search}%'" . " OR `name` LIKE '%" . ucfirst($search) . "%'" . " OR `name` LIKE '%" . $search . "%'" . " OR `server` LIKE '%{$search}%'" . " OR `region` LIKE '%{$search}%'" . " OR `guild_id` LIKE '%{$search}%'" . " OR `class` LIKE '%{$search}%'" . " OR `level` LIKE '%{$search}%'" . " OR `note` LIKE '%{$search}%'" . " OR `guild_rank` LIKE '%{$search}%'" . " OR `guild_title` LIKE '%{$search}%'" . " OR `zone` LIKE '%{$search}%')" . " GROUP BY `member_id`" . ($limit > 0 ? " LIMIT {$first}," . $limit : '') . ';'; // calculating the search time $this->start_search = format_microtime(); $result = $roster->db->query($sql); $this->stop_search = format_microtime(); $this->time_search = $this->stop_search - $this->start_search; $nrows = $roster->db->num_rows($result); $crows = 0; $x = $limit > $nrows ? $nrows : ($limit > 0 ? $limit : $nrows); if ($nrows > 0) { while ($x > 0) { list($member_id, $name, $server, $region, $guild_id, $class, $level, $note, $guild_rank, $guild_title, $zone, $last_online) = $roster->db->fetch($result); $item['title'] = $name; $item['date'] = $last_online; $item['html'] = '<td class="SearchRowCell">' . $level . '</td><td class="SearchRowCell">' . $class . '</td><td class="SearchRowCell"><a href="' . makelink("char-info&a=c:{$member_id}") . '"><strong>' . $name . '</strong></a></td><td class="SearchRowCellRight">' . $guild_title . '</td>'; $this->add_result($item); unset($item); $x--; } } $roster->db->free_result($result); }
function get_news($db) { $sql = "SELECT t.topic_id, topic_poster, p.post_text, u.username, u.user_email, t.topic_time, t.topic_posts_approved, t.topic_title, t.forum_id\n" . "FROM phpbb3_topics AS t, phpbb3_users AS u, phpbb3_posts AS p\n" . "WHERE(t.forum_id = 2 or t.forum_id = 38) AND t.topic_poster = u.user_id AND t.topic_id = p.topic_id AND t.topic_time = p.post_time\n" . "ORDER BY t.topic_time DESC\n" . "LIMIT 5"; $res = mysqli_query($db, $sql); $newstemplate = file_get_contents('templates/newsitem.html'); $news = ""; $newskeys = array('#HEADLINE#', '#BODY#', '#POSTER#', '#POSTDATE#'); while ($row = mysqli_fetch_array($res)) { if ($row['forum_id'] == 38) { if (preg_match('/^\\[(game|map|engine|website|misc)\\] (.*)$/', $row['topic_title'], $arr) === FALSE) { continue; } if (sizeof($arr) == 0) { continue; } $title = $arr[1] . ": " . htmlspecialchars_decode($arr[2]); } else { $title = $row['topic_title']; } $postlink = '/phpbb/viewtopic.php?t=' . $row['topic_id']; $title = makelink($postlink, $title); $newstext = link_replace(parse_bbcode($row['post_text'])); $poster = $row['username']; $postdate = date("Y-m-d H:i", $row['topic_time']); $newsdata = array($title, $newstext, $poster, $postdate); $news .= str_replace($newskeys, $newsdata, $newstemplate); } return $news; }
function skill_dropdown() { global $roster; $query = 'SELECT DISTINCT `skill_order`, `skill_type`, `skill_name` ' . 'FROM `' . $roster->db->table('skills') . '` ' . 'ORDER BY `skill_order`;'; $result = $roster->db->query($query); $output = '<form name="skillpicker" action="' . makelink() . '" method="post">' . "\n"; $output .= ' <select name="skill" onchange="document.forms[\'skillpicker\'].submit();">' . "\n"; $type = null; while ($row = $roster->db->fetch($result)) { if ($row['skill_type'] !== $type) { if ($type !== null) { $output .= ' </optgroup>' . "\n"; } $output .= ' <optgroup label="' . $row['skill_type'] . '">' . "\n"; $type = $row['skill_type']; } $output .= ' <option value="' . $row['skill_name'] . '">' . $row['skill_name'] . '</option>' . "\n"; } if ($type == null) { return ''; } $output .= ' </optgroup>' . "\n"; $output .= ' </select>' . "\n"; $output .= '</form>' . "\n"; return $output; }
function do_block($page, $param1, $param2) { if (!mb_ereg('^(.+?)/\\d{4}-\\d{2}-\\d{2}', $page->getpagename(), $m)) { throw new PluginException('このページからは呼び出せません(1)', $this); } $home = $m[1]; $datelist = Plugin_blognavi_DateList::getinstance($home); $collist = Plugin_blognavi_ColumnList::getinstance($datelist); if ($datelist->isdatepage($page->getpagename())) { $prev = $datelist->getprev($page->getpagename()); $next = $datelist->getnext($page->getpagename()); } else { if ($collist->iscolumnpage($page->getpagename())) { $prev = $collist->getprev($page->getpagename()); $next = $collist->getnext($page->getpagename()); } else { throw new PluginException('このページからは呼び出せません(2)', $this); } } $str[] = '<div class="plugin_blognavi">'; if ($prev != null) { $str[] = '[' . makelink($prev, $this->prevmes) . ']'; } else { $str[] = '[' . htmlspecialchars($this->prevmes) . ']'; } if ($next != null) { $str[] = '[' . makelink($next, $this->nextmes) . ']'; } else { $str[] = '[' . htmlspecialchars($this->nextmes) . ']'; } $str[] = '[' . makelink($home, $this->homemes) . ']'; $str[] = '</div>'; return join("\n", $str); }
function table_services() { global $construct, $db, $lang; $form_search_services = $this->form_search_services(); $where = $form_search_services->db_data_where(); $table_services = new table(array('TABLE_NAME' => 'table_services', 'FORM_NAME' => 'table_services')); $table_services->db_data('services.title, nodes.name AS nodes__name, nodes.id AS nodes__id, ip_addresses.ip, nodes_services.url, nodes_services.info, nodes_services.date_in, nodes_services.status, IFNULL(nodes_services.protocol, services.protocol) AS protocol, IFNULL(nodes_services.port, services.port) AS port', 'nodes_services LEFT JOIN nodes on nodes_services.node_id = nodes.id LEFT JOIN services on nodes_services.service_id = services.id LEFT JOIN ip_addresses ON ip_addresses.id = nodes_services.ip_id', $where, '', "nodes_services.date_in DESC"); $table_services->db_data_search($form_search_services); foreach ((array) $table_services->data as $key => $value) { if ($key != 0) { if ($table_services->data[$key]['ip']) { $table_services->data[$key]['ip'] = long2ip($table_services->data[$key]['ip']); if ($table_services->data[$key]['protocol'] && $table_services->data[$key]['port']) { $table_services->data[$key]['ip'] .= ' (' . $lang['db']['nodes_services__protocol-' . $table_services->data[$key]['protocol']] . '/' . $table_services->data[$key]['port'] . ')'; } } $table_services->data[$key]['nodes__name'] .= " (#" . $table_services->data[$key]['nodes__id'] . ")"; $table_services->info['LINK']['nodes__name'][$key] = makelink(array("page" => "nodes", "node" => $table_services->data[$key]['nodes__id'])); $table_services->info['LINK']['services__title'][$key] = $table_services->data[$key]['url']; } } $table_services->db_data_translate('nodes_services__status'); $table_services->db_data_remove('nodes__id', 'nodes_services__id', 'url', 'protocol', 'port'); return $table_services; }
function do_block($page, $param1, $param2) { $prefix = trim($param1); $pattern = '^' . mb_ereg_quote($prefix) . '/(\\d{1,4})-(\\d{2})'; if (mb_ereg($pattern, $page->getpagename(), $m)) { $year = $m[1]; $month = $m[2]; } else { if (isset(Vars::$get['year']) && isset(Vars::$get['month'])) { $year = Vars::$get['year']; $month = Vars::$get['month']; } else { $year = date('Y'); $month = date('n'); } } $smarty = $this->getSmarty(); $day = 1; $last = date('t', mktime(0, 0, 0, $month, 1, $year)); while ($day <= $last) { $line = array_fill(0, 7, ' '); $d = date('w', mktime(0, 0, 0, $month, $day, $year)); for (; $d < 7 && $day <= $last; $d++, $day++) { $p = Page::getinstance(sprintf('%s/%04d-%02d-%02d', $prefix, $year, $month, $day)); $line[$d] = $p->isexist() ? makelink($p, $day) : $day; } $table[] = $line; } $smarty->assign('table', $table); $smarty->assign('year', $year); $smarty->assign('month', $month); $smarty->assign('prefix', $prefix); $smarty->assign('page', $page->getpagename()); return $smarty->fetch('blogcalendar.tpl.htm'); }
/** * Controls Output of the Guild Name Column * * @param array $row * @return string - Formatted output */ function guild_value($row, $field) { global $roster; if ($row['guild_id']) { return '<div style="display:none;">' . $row['guild_name'] . '</div><a href="' . makelink('guild-memberslist&a=g:' . $row['guild_id']) . '">' . $row['guild_name'] . '</a></div>'; } else { return '<div style="display:none;">' . $row['guild_name'] . '</div>' . $row['guild_name']; } }
function getCrumbsa($topic) { global $roster, $addon; $queryb = "SELECT \n\t\t`forums`.`title` as forum, \n\t\t`forums`.`forum_id` as forum_id \n\t\tFROM `" . $roster->db->table('forums', $addon['basename']) . "` forums " . "WHERE `forums`.`forum_id` = '" . $topic . "'; "; $resultsb = $roster->db->query($queryb); $row = $roster->db->fetch($resultsb); $loc = '<a href="' . makelink('guild-' . $addon['basename'] . '') . '">Forums</a> > <a href="' . makelink('guild-' . $addon['basename'] . '-forum&id=' . $row['forum_id']) . '">' . $row['forum'] . '</a>'; return $loc; }
/** * Format author's name & wrap it to links etc. */ function format_author($author) { global $page; if (isset($page['project'])) { // FIXME 'h' - use only if available return '<a href="' . makelink(array('a' => 'search', 'p' => $page['project'], 'h' => 'HEAD', 'st' => 'author', 's' => $author)) . '">' . htmlentities_wrapper($author) . '</a>'; } else { return htmlentities_wrapper($author); } }
function output() { if ($_SERVER['REQUEST_METHOD'] == 'POST' && method_exists($this, 'output_onpost_' . $_POST['form_name'])) { return call_user_func(array($this, 'output_onpost_' . $_POST['form_name'])); } global $construct; $this->tpl['link_ranges_search'] = makelink(array("page" => "ranges", "subpage" => "search")); $this->tpl['link_ranges_allocation'] = makelink(array("page" => "ranges", "subpage" => "allocation")); $this->tpl['table_areas'] = $construct->table($this->table_areas(), __FILE__); return template($this->tpl, __FILE__); }
function _eventList() { global $roster, $addon; $events = $this->_getGuildEvents(); $roster->tpl->assign_vars(array('START_BORDER' => border('syellow', 'start'), 'STOP_BORDER' => border('syellow', 'end'), 'FORMLINK' => makelink())); foreach ($events as $event) { $roster->tpl->assign_block_vars('body_row', array('EVENTID' => $event->id, 'EVENTNAME' => $event->eventName, 'DDS' => $event->damageDealtSum, 'HDS' => $event->healingDoneSum, 'DTS' => $event->damageTakenSum, 'HTS' => $event->healingTakenSum, 'DRUIDICON' => $roster->config['img_url'] . 'class/druid_icon.jpg', 'HUNTERICON' => $roster->config['img_url'] . 'class/hunter_icon.jpg', 'MAGEICON' => $roster->config['img_url'] . 'class/mage_icon.jpg', 'PALADINICON' => $roster->config['img_url'] . 'class/paladin_icon.jpg', 'PRIESTICON' => $roster->config['img_url'] . 'class/priest_icon.jpg', 'ROGUEICON' => $roster->config['img_url'] . 'class/rogue_icon.jpg', 'SHAMANICON' => $roster->config['img_url'] . 'class/shaman_icon.jpg', 'WARLOCKICON' => $roster->config['img_url'] . 'class/warlock_icon.jpg', 'WARRIORICON' => $roster->config['img_url'] . 'class/warrior_icon.jpg', 'DRUIDCOUNT' => isset($event->memberClasses['DRUID']) ? $event->memberClasses['DRUID'] : 0, 'HUNTERCOUNT' => isset($event->memberClasses['HUNTER']) ? $event->memberClasses['HUNTER'] : 0, 'MAGECOUNT' => isset($event->memberClasses['MAGE']) ? $event->memberClasses['MAGE'] : 0, 'PALADINCOUNT' => isset($event->memberClasses['PALADIN']) ? $event->memberClasses['PALADIN'] : 0, 'PRIESTCOUNT' => isset($event->memberClasses['PRIEST']) ? $event->memberClasses['PRIEST'] : 0, 'ROGUECOUNT' => isset($event->memberClasses['ROGUE']) ? $event->memberClasses['ROGUE'] : 0, 'SHAMANCOUNT' => isset($event->memberClasses['SHAMAN']) ? $event->memberClasses['SHAMAN'] : 0, 'WARLOCKCOUNT' => isset($event->memberClasses['WARLOCK']) ? $event->memberClasses['WARLOCK'] : 0, 'WARRIORCOUNT' => isset($event->memberClasses['WARRIOR']) ? $event->memberClasses['WARRIOR'] : 0)); } $roster->tpl->set_filenames(array('eventListBody' => $addon['basename'] . '/assessment.view.eventlist.body.html')); $roster->tpl->display('eventListBody'); }
function output_onpost_form_services() { global $construct, $main, $db; $form_services = $this->form_services(); $service = get('service'); $ret = TRUE; $ret = $form_services->db_set(array(), "services", "id", get('service')); if ($ret) { $main->message->set_fromlang('info', 'insert_success', makelink(array("page" => "admin", "subpage" => "services"))); } else { $main->message->set_fromlang('error', 'generic'); } }
function output_onpost_table_services() { global $db, $main; $ret = TRUE; foreach ((array) $_POST['id'] as $key => $value) { $ret = $ret && $db->del("services", "id = '" . $value . "'"); } if ($ret) { $main->message->set_fromlang('info', 'delete_success', makelink("", TRUE)); } else { $main->message->set_fromlang('error', 'generic'); } }
function output_onpost_form_ipaddr() { global $construct, $main, $db; $form_ipaddr = $this->form_ipaddr(); $ipaddr = get('ipaddr'); $ret = TRUE; $_POST['ip_addresses__ip'] = ip2long($_POST['ip_addresses__ip']); $ret = $form_ipaddr->db_set(array('node_id' => intval(get('node'))), "ip_addresses", "id", $ipaddr); if ($ret) { $main->message->set_fromlang('info', 'insert_success', makelink(array("page" => "mynodes", "node" => get('node')))); } else { $main->message->set_fromlang('error', 'generic'); } }
function output_onpost_form_services() { global $construct, $main, $db; $form_services = $this->form_services(); $service = get('service'); $ret = TRUE; $_POST['nodes_services__url'] = url_fix($_POST['nodes_services__url']); $ret = $form_services->db_set(array(), "nodes_services", "id", $service); if ($ret) { $main->message->set_fromlang('info', 'insert_success', makelink(array("page" => "mynodes", "node" => $_POST['nodes_services__node_id']))); } else { $main->message->set_fromlang('error', 'generic'); } }
function output() { if ($_SERVER['REQUEST_METHOD'] == 'POST' && method_exists($this, 'output_onpost_' . $_POST['form_name'])) { return call_user_func(array($this, 'output_onpost_' . $_POST['form_name'])); } global $construct; $this->tpl['link_ranges_search'] = makelink(array("page" => "ranges", "subpage" => "search")); $this->tpl['link_ranges_allocation'] = makelink(array("page" => "ranges", "subpage" => "allocation")); $form_search_ranges = $this->form_search_ranges(); //if ($form_search_ranges->data[0]['value'] != '') $form_search_ranges->data[0]['value'] = correct_ip($form_search_ranges->data[0]['value']); $this->tpl['form_search_ranges'] = $construct->form($form_search_ranges, __FILE__); $this->tpl['table_ranges'] = $construct->table($this->table_ip_ranges(), __FILE__); return template($this->tpl, __FILE__); }
function db_data_pickup($data_field, $subpage, $values, $multi = FALSE) { for ($i = 0; $i < count($this->data); $i++) { if ($data_field == str_replace("__", ".", $this->data[$i]['fullField'])) { $this->data[$i]['Type'] = 'pickup' . ($multi == FALSE ? '' : "_multi"); $this->data[$i]['Pickup_url'] = makelink(array("page" => "pickup", "subpage" => $subpage, "object" => $this->info['FORM_NAME'] . ".elements['" . str_replace(".", "__", $data_field) . ($multi == FALSE ? '' : "[]") . "']")); if ($multi == FALSE) { $this->data[$i]['Type_Pickup'] = $values[0]; } else { $this->data[$i]['Type_Pickup'] = $values; } break; } } }
function output_onpost_form_region() { global $construct, $main, $db; $form_region = $this->form_region(); $region = get('region'); $ret = TRUE; $_POST['regions__ip_start'] = ip2long($_POST['regions__ip_start']); $_POST['regions__ip_end'] = ip2long($_POST['regions__ip_end']); $ret = $form_region->db_set(array(), "regions", "id", get('region')); if ($ret) { $main->message->set_fromlang('info', 'insert_success', makelink(array("page" => "admin", "subpage" => "regions"))); } else { $main->message->set_fromlang('error', 'generic'); } }
function output_onpost_table_areas() { global $db, $main; $ret = TRUE; foreach ((array) $_POST['id'] as $key => $value) { $ret = $ret && $db->del("areas", "id = '" . $value . "'"); } if ($ret) { log_admin_action(get('area'), "areas#" . get('id'), "delete_success"); #@# $main->message->set_fromlang('info', 'delete_success', makelink("", TRUE)); } else { $main->message->set_fromlang('error', 'generic'); } }
function output_onpost_form_community() { global $construct, $main, $db; $form_community = $this->form_community(); $community = get('community'); $ret = TRUE; $_POST['communities__ns1'] = ip2long($_POST['communities__ns1']); $_POST['communities__ns2'] = ip2long($_POST['communities__ns2']); $ret = $form_community->db_set(array(), "communities", "id", get('community')); if ($ret) { $main->message->set_fromlang('info', 'insert_success', makelink(array("page" => "admin", "subpage" => "communities"))); } else { $main->message->set_fromlang('error', 'generic'); } }
function make_interval_select($current) { $rows = array(); $sql = "select seconds, name from intervals order by seconds"; $result = do_query($sql); while ($row = mysqli_fetch_array($result)) { $row['link'] = makelink("interval", $row['seconds']); if ($row['seconds'] == $current) { $row['selected'] = "selected"; } else { $row['selected'] = ""; } array_push($rows, $row); } return $rows; }
function do_block($page, $param1, $param2) { $db = DataBase::getinstance(); $query = "SELECT pagename FROM allpage"; $query .= " WHERE pagename LIKE ':%' OR pagename LIKE '%/:%"; $query .= " ORDER BY pagename ASC"; $result = $db->query($query); $list = $db->fetchsinglearray($result); if ($list == array()) { return ''; } natsort($list); foreach ($list as $pagename) { $link[] = '<li>' . makelink($pagename) . '</li>'; } return "<ul>\n" . join("\n", $link) . "\n</ul>\n"; }
function mini_members_list() { global $roster; // Get the scope select data $query = 'SELECT `members`.`member_id`, `members`.`name`, `members`.`class`, `members`.`classid`, `members`.`level`, `members`.`guild_title`, `members`.`guild_rank`, ' . '`players`.`race`, `players`.`raceid`, `players`.`sex`, `players`.`sexid` ' . 'FROM `' . $roster->db->table('members') . '` AS members ' . 'LEFT JOIN `' . $roster->db->table('players') . '` AS players ON `members`.`member_id` = `players`.`member_id` ' . 'WHERE `members`.`guild_id` = "' . $roster->data['guild_id'] . '" ' . 'ORDER BY `members`.`level` DESC, `members`.`name` ASC'; $result = $roster->db->query($query); if (!$result) { trigger_error($roster->db->error()); return false; } while ($data = $roster->db->fetch($result, SQL_ASSOC)) { $roster->tpl->assign_block_vars('mini_memberslist', array('ID' => $data['member_id'], 'NAME' => $data['name'], 'CLASS' => $data['class'], 'CLASS_ID' => $data['classid'], 'CLASS_EN' => isset($roster->locale->wordings['enUS']['id_to_class'][$data['classid']]) ? strtolower(str_replace(' ', '', $roster->locale->wordings['enUS']['id_to_class'][$data['classid']])) : '', 'GUILD_NAME' => $roster->data['guild_name'], 'LEVEL' => $data['level'], 'TITLE' => $data['guild_title'], 'RANK' => $data['guild_rank'], 'RACE' => $data['race'], 'RACE_ID' => $data['raceid'], 'RACE_EN' => $data['raceid'] != '' && $data['raceid'] != 0 ? strtolower(str_replace(' ', '', $roster->locale->wordings['enUS']['id_to_race'][$data['raceid']])) : '', 'SEX' => $data['sex'], 'SEX_ID' => $data['sexid'], 'U_LINK' => $data['race'] != '' ? makelink('&a=c:' . $data['member_id'], true) : false, 'S_SELECTED' => $data['member_id'] == $roster->data['member_id'] ? true : false)); } $roster->tpl->assign_vars(array('S_MINI_MEMBERSLIST' => $roster->db->num_rows() > 1 ? true : false, 'GUILD_NAME' => $roster->data['guild_name'])); $roster->db->free_result($result); return true; }
function output_onpost_form_nameserver() { global $construct, $main, $db; $form_nameserver = $this->form_nameserver(); $nameserver = get('nameserver'); if (get('nameserver') == 'add') { $_POST['dns_nameservers__ip'] = ip2long($_POST['dns_nameservers__ip']); } $f['node_id'] = intval(get('node')); $ret = TRUE; $ret = $form_nameserver->db_set($f, "dns_nameservers", "id", $nameserver); if ($ret) { $main->message->set_fromlang('info', get('zone') == 'add' ? 'request_dnsnameserver_success' : 'edit_success', makelink(array("page" => "mynodes", "node" => intval(get('node'))))); } else { $main->message->set_fromlang('error', 'generic'); } }
/** * Routine to check for installation or upgrade */ public static function checkVersion() { global $db, $user; $swversion->major = EXPONENT_VERSION_MAJOR; $swversion->minor = EXPONENT_VERSION_MINOR; $swversion->revision = EXPONENT_VERSION_REVISION; $swversion->type = EXPONENT_VERSION_TYPE; $swversion->iteration = EXPONENT_VERSION_ITERATION; $swversion->builddate = EXPONENT_VERSION_BUILDDATE; // check database version against installed software version if ($db->havedb) { if ($user->isAdmin()) { $dbversion = $db->selectObject('version', 1); if (empty($dbversion)) { $dbversion->major = 0; $dbversion->minor = 0; $dbversion->revision = 0; $dbversion->type = ''; $dbversion->iteration = ''; } // check if software version is newer than database version if (self::compareVersion($dbversion, $swversion)) { $oldvers = $dbversion->major . '.' . $dbversion->minor . '.' . $dbversion->revision . ($dbversion->type ? $dbversion->type : '') . ($dbversion->iteration ? $dbversion->iteration : ''); $newvers = $swversion->major . '.' . $swversion->minor . '.' . $swversion->revision . ($swversion->type ? $swversion->type : '') . ($swversion->iteration ? $swversion->iteration : ''); flash('message', gt('The database requires upgrading from') . ' v' . $oldvers . ' ' . gt('to') . ' v' . $newvers . '<br><a href="' . makelink(array("controller" => "administration", "action" => "install_exponent")) . '">' . gt('Click here to Upgrade your website') . '</a>'); } } } else { // database is unavailable, so show us as being offline $template = new standalonetemplate('_maintenance'); $template->assign("db_down", true); $template->output(); exit; } // check if online version is newer than installed software version, but only once per session if ($user->isAdmin()) { if (!expSession::is_set('update-check')) { $onlineVer = self::getOnlineVersion(); expSession::set('update-check', '1'); if (self::compareVersion($swversion, $onlineVer)) { $newvers = $onlineVer->major . '.' . $onlineVer->minor . '.' . $onlineVer->revision . ($onlineVer->type ? $onlineVer->type : '') . ($onlineVer->iteration ? $onlineVer->iteration : ''); flash('message', gt('A newer version of Exponent is available') . ': v' . $newvers . ' ' . gt('was released') . ' ' . expDateTime::format_date($onlineVer->builddate) . '<br><a href="https://github.com/exponentcms/exponent-cms/downloads" target="_blank">' . gt('Click here to see available Downloads') . '</a>'); } } } }
function output() { global $main, $db, $geocalc, $srtm; $main->header->hide = TRUE; $main->menu->hide = TRUE; $main->footer->hide = TRUE; $this->tpl['a_node'] = isset($_POST['a_node']) ? $_POST['a_node'] : get('a_node'); if ($this->tpl['a_node'] != '') { $a_node_data = $db->get('id, name, latitude, longitude, elevation', 'nodes', "id = '" . $this->tpl['a_node'] . "'"); $a_node_data = $a_node_data[0]; $this->tpl['a_node_output'] = $a_node_data['name'] . ' (#' . $a_node_data['id'] . ')'; } $this->tpl['b_node'] = isset($_POST['b_node']) ? $_POST['b_node'] : get('b_node'); if ($this->tpl['b_node'] != '') { $b_node_data = $db->get('id, name, latitude, longitude, elevation', 'nodes', "id = '" . $this->tpl['b_node'] . "'"); $b_node_data = $b_node_data[0]; $this->tpl['b_node_output'] = $b_node_data['name'] . ' (#' . $b_node_data['id'] . ')'; } if ($this->tpl['a_node'] != '' && $this->tpl['b_node'] != '') { $this->tpl['a_node_azimuth'] = $geocalc->GCAzimuth($a_node_data['latitude'], $a_node_data['longitude'], $b_node_data['latitude'], $b_node_data['longitude']); $this->tpl['b_node_azimuth'] = $geocalc->GCAzimuth($b_node_data['latitude'], $b_node_data['longitude'], $a_node_data['latitude'], $a_node_data['longitude']); $this->tpl['a_node_geo_elevation'] = $srtm->get_elevation($a_node_data['latitude'], $a_node_data['longitude']); $this->tpl['b_node_geo_elevation'] = $srtm->get_elevation($b_node_data['latitude'], $b_node_data['longitude']); $this->tpl['a_node_elevation'] = $a_node_data['elevation']; $this->tpl['b_node_elevation'] = $b_node_data['elevation']; $a_node_total_elevation = $this->tpl['a_node_geo_elevation'] + $this->tpl['a_node_elevation']; $b_node_total_elevation = $this->tpl['b_node_geo_elevation'] + $this->tpl['b_node_elevation']; $this->tpl['distance'] = $geocalc->GCDistance($a_node_data['latitude'], $a_node_data['longitude'], $b_node_data['latitude'], $b_node_data['longitude']); $this->tpl['a_node_tilt'] = rad2deg(atan(($b_node_total_elevation - $a_node_total_elevation) / ($this->tpl['distance'] * 1000))); $this->tpl['b_node_tilt'] = rad2deg(atan(($a_node_total_elevation - $b_node_total_elevation) / ($this->tpl['distance'] * 1000))); $this->tpl['distance'] = sqrt(pow($this->tpl['distance'] * 1000, 2) + pow(abs($a_node_total_elevation - $b_node_total_elevation), 2)) / 1000; $this->tpl['gearth'] = makelink(array("page" => "gearth", "subpage" => "download", "node" => get('a_node'), "node2" => get('b_node'), "show_p2p" => "1", "show_aps" => "1", "show_clients" => "1", "show_unlinked" => "1", "show_links_p2p" => "1", "show_links_client" => "1")); $this->tpl['frequency'] = isset($_POST['frequency']) ? (int) $_POST['frequency'] : null; if ($this->tpl['frequency'] <= 0) { $this->tpl['frequency'] = 2450; } $frequency = $this->tpl['frequency'] * 1000000; $c = 299792.458; // light speed in km $this->tpl['fsl'] = 20 * log10(4 * pi() * $this->tpl['distance'] * ($frequency / $c)); $this->tpl['plot_image'] = makelink(array("page" => "nodes", "subpage" => "plot", "a_node" => $this->tpl['a_node'], "b_node" => $this->tpl['b_node'], "frequency" => isset($_POST['frequency']) ? $_POST['frequency'] : null)); } $this->tpl['hidden_qs'] = get_qs(); return template($this->tpl, __FILE__); }