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