?> " 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)); }