function __construct()
{
$pid = $_GET['place_id'];
$pResult = getPlace($pid);
if ($pResult != null && mysqli_num_rows($pResult) > 0) {
$row = mysqli_fetch_assoc($pResult);
$this->id = $row["Place_ID"];
$this->title = $row["Title"];
$this->description = $row["Description"];
$this->address = $row["Address"];
$this->picture = "subpages/pictures/places/" . $row["picture"];
$this->category = $row["Cat_Type"];
}
$pResult = getRating($pid);
if ($pResult != null && mysqli_num_rows($pResult) > 0) {
$row = mysqli_fetch_assoc($pResult);
$this->rating = number_format($row["rating"], 1);
}
}
<?php
require 'init.php';
$c->add('main');
$c->assign('menu', $menu->output);
$tp = new template();
$tp->add('team-info');
$r = $mysql->getRow("select arena_team.*,arena_team_stats.* from arena_team,arena_team_stats where arena_team_stats.arenateamid = arena_team.arenateamid and name = '?1' and type = ?2", $_GET['name'], (int) $_GET['type'], 'char');
if (!$r) {
$_SYSTEM->error("Arena Team not found.");
}
$tp->assign('name', $r['name']);
$tp->assign('type', $r['type']);
$rank = getArenaRank($r['arenateamid']);
$place = getPlace($rank[1]);
$tp->assign('rank', $rank[0]);
$tp->assign('place', $place);
$tp->assign('rank_border', $rank[2]);
$tp->assign('wg', $r['games']);
$tp->assign('ww', $r['wins']);
$tp->assign('wl', $r['games'] - $r['wins']);
$tp->assign('wp', $r['games'] ? round($r['wins'] / $r['games'] * 100) : 0);
$tp->assign('wr', $r['rating']);
$tp->assign('sg', $r['played']);
$tp->assign('sw', $r['wins2']);
$tp->assign('sl', $r['played'] - $r['wins2']);
$tp->assign('sp', $r['played'] ? round($r['wins2'] / $r['played'] * 100) : 0);
$icon = getSmallArenaIcon($r);
$tp->assign('icon', $icon);
$m = $mysql->getRows("select arena_team_member.*,characters.name,characters.race,characters.class,?3 as level,?4 as gender,guild.name as gname from arena_team_member inner join characters on arena_team_member.guid= characters.guid left join guild on guild.guildid = ?2 where arena_team_member.arenateamid = ?1", $r['arenateamid'], SQL_template(CHAR_GUILD_OFFSET), SQL_template(CHAR_LEVEL_OFFSET), CHAR_GENDER_OFFSET, 'char');
if ($m) {
$leagueID = leagueHandler($_POST, $userID);
debug("User is {$userID} League is {$leagueID}");
$season = getSeason();
$app = JFactory::getApplication();
$teamDisplayName = getSingleton("fch_league_membership", "teamDisplayName", " WHERE userID = {$userID} and leagueID = {$leagueID} and season = \"{$season}\"");
debug("Team display Name: {$teamDisplayName}");
$menu =& JSite::getMenu();
$active = $menu->getActive();
$menuname = $active->params->get('page_heading');
echo $menuname;
$start = intval($_POST[paginationStart]);
debug("Pagination start {$start}");
if (!($start >= 0)) {
$start = 0;
}
$place = getPlace($userID, $leagueID);
getSuffix($place);
?>
<script>
jQuery(document).ready(function ()
{
jQuery('html').find('h1').html(" <h1 class=\"page-title\"><?php
echo $teamDisplayName;
?>
</h1>");
});
</script>
<?php
//echo displayResults(getReturnCode(0,"Notice: If you had a player on your roster who is no longer with his team, he has been removed."));
$totalPoints = getTotalPointsForUser($userID, $leagueID);
?>
background-image: url(\'' . $character->get_item_icon($i) . '\')">
<a class="staticTip gearFrame" onmouseover="setTipText(\'' . $_SYSTEM->htmlcode($character->item_tooltips[$i]) . '\')" href="javascript:void(0)">
<div class="upgradeBox"></div>
</a>
<div class="fly-horz">
<a class="upgrd" href="item-info.php?i=' . $character->items[$i] . '" target="_blank">More info</a>
</div>
</div>';
}
$tp->assign('bottomItems', $bottomItems);
// Arena
$types = array(2, 3, 5);
foreach ($types as $type) {
if ($character->arena_team[$type]['name']) {
$rank = getArenaRank($character->arena_team[$type]['arenateamid']);
$at .= '<li><div class="arenacontainer"><h4>' . $type . 'v' . $type . '</h4><em><span>Rating: ' . $character->arena_team[$type]['rating'] . '</span></em><div class="icon" style="background-image: url(\'images/icons/badges/arena/arena-' . $rank[0] . '.jpg\');">
<img border="0" src="images/badge-border-pvp-' . $rank[2] . '.gif"><div class="rank-num" id="arenarank' . $type . '_' . $type . '">
<div class="teamRank"> <br>
<p class="position">' . getPlace($rank[1]) . '</p>
</div></div></div></div></li>';
$at2 .= '<li><div><em><span><b><a href="team-info.php?Realm=' . $_SYSTEM->Realms[$_SYSTEM->Realm] . '&name=' . $character->arena_team[$type]['name'] . '&type=' . $type . '">' . $character->arena_team[$type]['name'] . '</a></b><br>Personal Rating: ' . $character->arena_team[$type]['rating'] . '<br></span></em></div></li>';
} else {
$at .= '<li><div class="arena-team-faded"><h4>' . $type . 'v' . $type . '</h4><em><span>No Arena Team</span></em></div></li>';
$at2 .= '<li><div><em><span></span></em></div></li>';
}
}
$tp->assign('arenacontent', $at);
$tp->assign('arenacontent2', $at2);
$c->assign('content', $tp->output);
$c->display();
$_SYSTEM->printFooter();
}
function getEventUrl($pdo, $event_id)
{
//$sql = "SELECT url FROM event WHERE id = 36";
$sql = "SELECT url FROM event WHERE id = :event_id";
$statement = $pdo->prepare($sql);
$statement->bindValue(':event_id', $event_id, PDO::PARAM_INT);
$statement->execute();
if ($rows = $statement->fetchAll(PDO::FETCH_ASSOC)) {
return $rows[0]['url'];
} else {
return false;
}
}
$event_place = getEventPlace($db, $place);
$fac_name = getPlace($db, $event_place);
$event_name = getEventName($db, $place);
//print $event_name;
$event_content = getEventContent($db, $place);
//print $event_content;
$event_url = getEventUrl($db, $place);
$image = getImage($db, $place);
?>
<!DOCTYPE html>
<html>
<head>
<title></title>
</head>
<body>
<h2>イベント名 :<?php
