?>
" style="width: 100%; position: relative;">
<div id="tipsy-<?php
echo $round->getRoundId();
?>
" class="tipsy tipsy-n" style="visibility: hidden; display: block; opacity: 0.8;">
<div class="tipsy-arrow"></div>
<div class="tipsy-inner" id="tipsy-content-<?php
echo $round->getRoundId();
?>
"></div>
</div>
</div>
<?php
$eventArray = array();
$events = RoundTable::getInstance()->createQuery("r")->where("r.map_id = ?", $match->getMap()->getId())->andWhere("r.round_id = ?", $round->getRoundId())->orderBy("r.event_time ASC")->leftJoin("r.Kill pk")->execute();
foreach ($events as $event) {
$color = "#000";
$text = $event->getEventName();
if ($event->getEventName() == "round_start") {
$text = "Start of the round";
} elseif ($event->getEventName() == "kill") {
$color = "#F00";
$kill = $event->getKill();
if (!$kill) {
continue;
}
$text = $kill->getKillerName() . " has killed " . $kill->getKilledName() . " with " . $kill->getWeapon();
} elseif ($event->getEventName() == "round_end") {
$text = "End of the round";
} elseif ($event->getEventName() == "bomb_planting") {
public function executeExportEstats(sfWebRequest $request)
{
$mO = $this->getRoute()->getObject();
$stats = array();
$match = $mO->toArray();
unset($match['id'], $match['config_password'], $match['season_id'], $match['server_id'], $match['rules'], $match['team_a'], $match['team_b'], $match['config_authkey'], $match['current_map']);
$stats['match'] = $match;
foreach ($mO->getMaps() as $mapO) {
$map = $mapO->toArray();
unset($map['match_id'], $map['id']);
$stats['map'] = $map;
foreach ($mapO->getMapsScore() as $sO) {
$score = $sO->toArray();
unset($score['id'], $score['map_id']);
$stats['scores'][] = $score;
}
}
foreach ($mO->getPlayers() as $pO) {
$player = $pO->toArray();
unset($player['map_id'], $player['match_id'], $player['ip']);
$stats['players'][] = $player;
}
$heatmap = PlayersHeatmapTable::getInstance()->createQuery()->where("match_id = ?", $mO->getId())->orderBy("created_at ASC")->execute();
foreach ($heatmap as $hO) {
$data = $hO->toArray();
unset($data['id'], $data['match_id'], $data['map_id']);
$stats['heatmap'][] = $data;
}
$kills = PlayerKillTable::getInstance()->createQuery()->where("match_id = ?", $mO->getId())->orderBy("created_at ASC")->execute();
foreach ($kills as $hO) {
$data = $hO->toArray();
unset($data['match_id'], $data['map_id']);
$stats['kills'][] = $data;
}
$kills = RoundTable::getInstance()->createQuery()->where("match_id = ?", $mO->getId())->orderBy("created_at ASC")->execute();
foreach ($kills as $hO) {
$data = $hO->toArray();
unset($data['id'], $data['match_id'], $data['map_id']);
$stats['rounds'][] = $data;
}
$kills = RoundSummaryTable::getInstance()->createQuery()->where("match_id = ?", $mO->getId())->orderBy("created_at ASC")->execute();
foreach ($kills as $hO) {
$data = $hO->toArray();
unset($data['id'], $data['match_id'], $data['map_id']);
$stats['summary'][] = $data;
}
return $this->renderText(json_encode($stats));
}
