function getObjectInfo($id, $language = null) { $info = new JCommentsObjectInfo(); $routerHelper = JPATH_SITE . '/components/com_joomleague/helpers/route.php'; if (is_file($routerHelper)) { require_once $routerHelper; $db = JFactory::getDBO(); $query = "SELECT m.id as matchid,\r\n\t\t\t\t\t\t\t\tt1.short_name t1name,\r\n\t\t\t\t\t\t\t\tt2.short_name t2name,\r\n\t\t\t\t\t\t\t\tm.projectteam1_id,\r\n\t\t\t\t\t\t\t\tm.projectteam2_id,\r\n\t\t\t\t\t\t\t\tm.team1_result,\r\n\t\t\t\t\t\t\t\tm.team2_result,\r\n\t\t\t\t\t\t\t\tm.modified_by,\r\n\t\t\t\t\t\t\t\tr.project_id,\r\n\t\t\t\t\t\t\t\tp.name as projectname" . " FROM #__joomleague_match as m" . " LEFT JOIN #__joomleague_round as r ON r.id=m.round_id" . " INNER JOIN #__joomleague_project_team AS pt1 ON m.projectteam1_id=pt1.id" . " INNER JOIN #__joomleague_project_team AS pt2 ON m.projectteam2_id=pt2.id" . " INNER JOIN #__joomleague_team AS t1 ON pt1.team_id=t1.id" . " INNER JOIN #__joomleague_team AS t2 ON pt2.team_id=t2.id" . " INNER JOIN #__joomleague_project AS p ON pt1.project_id=p.id" . " WHERE m.id = " . $id; $db->setQuery($query); $row = $db->loadObject(); if (!empty($row)) { $info->title = $row->projectname . " " . $row->t1name . " vs. " . $row->t2name; $info->userid = $row->modified_by; $info->link = JRoute::_(JoomleagueHelperRoute::getNextMatchRoute($row->project_id, $row->matchid)); } } return $info; }
</tr> <?php } ?> <!-- Next Match--> <?php if ($this->match->new_match_id > 0) { ?> <tr> <td colspan="3" > <span class="label"><?php echo JText::_('COM_JOOMLEAGUE_MATCHREPORT_NEW_MATCH'); ?> </span> <span><?php echo JHTML::link(JoomleagueHelperRoute::getNextMatchRoute($this->project->id, $this->match->new_match_id), $this->newmatchtext); ?> </span> </td> </tr> <?php } ?> <!-- Date --> <?php if ($this->config['show_match_date'] == 1) { if ($this->match->match_date > 0) { ?> <tr> <td colspan="3" >
function getScoreLink($game, $project) { if (isset($game->team1_result) || $game->alt_decision) { return JoomleagueHelperRoute::getMatchReportRoute($project->slug, $game->id); } else { return JoomleagueHelperRoute::getNextMatchRoute($project->slug, $game->id); } }
$link = JoomleagueHelperRoute::getNextMatchRoute($this->project->slug, $match->id) . '#comments'; } $viewComment = JHTML::link($link, $href_text); echo $viewComment; } else { $imgTitle = JText::_('COM_JOOMLEAGUE_TEAMPLAN_COMMENTS_COUNT_NOCOMMENT'); if ($this->config['show_comments_count'] == 1) { $href_text = JHTML::image(JURI::root() . 'media/com_joomleague/jl_images/discuss.gif', $imgTitle, array(' title' => $imgTitle, ' border' => 0, ' style' => 'vertical-align: middle')); } elseif ($this->config['show_comments_count'] == 2) { $href_text = '<span title="' . $imgTitle . '">(' . $count . ')</span>'; } //Link if (isset($match->team1_result)) { $link = JoomleagueHelperRoute::getMatchReportRoute($this->project->slug, $match->id) . '#comments'; } else { $link = JoomleagueHelperRoute::getNextMatchRoute($this->project->slug, $match->id) . '#comments'; } $viewComment = JHTML::link($link, $href_text); echo $viewComment; } ?> </td> <?php } ?> </tr> <?php if ($hasEvents) { ?> <!-- Show icon for editing events in edit mode --> <tr class="events <?php
case 2: // Link to Match report $title = str_replace("%TEAMHOME%", $this->teams[$result->projectteam1_id]->name, JText::_('COM_JOOMLEAGUE_FORCED_MATCH_REPORT_FORM')); $title = str_replace("%TEAMGUEST%", $this->teams[$result->projectteam2_id]->name, $title); break; default: break; } if ($result->cancel) { $picture = 'images/com_joomleague/database/events/' . $this->project->fs_sport_type_name . '/away.gif'; $title = $result->cancel_reason; $desc = JoomleagueHelper::getPictureThumb($picture, $title, 16, 16, 99); $match_result = JHTML::link($link, $desc); $new_match = ""; if ($result->new_match_id > 0) { $link = JoomleagueHelperRoute::getNextMatchRoute($this->project->id, $result->new_match_id); $picture = 'media/com_joomleague/jl_images/bullet_black.png'; $desc = JoomleagueHelper::getPictureThumb($picture, $title, 16, 16, 99); $new_match = JHTML::link($link, $desc); } $match_result .= $new_match; } else { $picture = 'media/com_joomleague/jl_images/bullet_black.png'; $desc = JoomleagueHelper::getPictureThumb($picture, $title, 16, 16, 99); $match_result = JHTML::link($link, $desc); } } } elseif ($e1 != "" && $e2 != "") { // result without match report if ($this->config['highlight_fav_team'] != 2 || !in_array($team_row->id, $this->favteams) && !in_array($team_col->id, $this->favteams)) { $resultStr = $e1 . $this->overallconfig['seperator'] . $e2 . $ResultType;
function formatMatches($rows, &$matches) { $newrows = array(); $teamnames = $this->xparams->get('team_names', 'short_name'); $teams = JoomleagueConnector::getTeamsFromMatches($rows); $teams[0] = new stdclass(); $teams[0]->name = $teams[0]->{$teamnames} = $teams[0]->logo_small = $teams[0]->logo_middle = $teams[0]->logo_big = ''; /* echo 'function formatMatches array teams<br>'; echo '<pre>'; print_r($teams); echo '</pre>'; */ /* echo 'function formatMatches array rows<br>'; echo '<pre>'; print_r($rows); echo '</pre>'; */ /* echo 'function formatMatches array matches<br>'; echo '<pre>'; print_r($matches); echo '</pre>'; */ foreach ($rows as $key => $row) { $newrows[$key]['type'] = 'jlm'; //$newrows[$key]['homepic'] = JoomleagueConnector::buildImage($teams[$row->matchpart1]); //$newrows[$key]['awaypic'] = JoomleagueConnector::buildImage($teams[$row->matchpart2]); $newrows[$key]['homepic'] = JoomleagueConnector::buildImage($teams[$row->projectteam1_id]); $newrows[$key]['awaypic'] = JoomleagueConnector::buildImage($teams[$row->projectteam2_id]); $newrows[$key]['date'] = $row->match_date; //$newrows[$key]['result'] = (!is_null($row->matchpart1_result)) ? $row->matchpart1_result . ':' . $row->matchpart2_result : '-:-'; $newrows[$key]['result'] = !is_null($row->team1_result) ? $row->team1_result . ':' . $row->team2_result : '-:-'; $newrows[$key]['headingtitle'] = parent::jl_utf8_convert($row->name . '-' . $row->roundname, 'iso-8859-1', 'utf-8'); //$newrows[$key]['homename'] = JoomleagueConnector::formatTeamName($teams[$row->matchpart1]); //$newrows[$key]['awayname'] = JoomleagueConnector::formatTeamName($teams[$row->matchpart2]); $newrows[$key]['homename'] = JoomleagueConnector::formatTeamName($teams[$row->projectteam1_id]); $newrows[$key]['awayname'] = JoomleagueConnector::formatTeamName($teams[$row->projectteam2_id]); $newrows[$key]['matchcode'] = $row->matchcode; $newrows[$key]['project_id'] = $row->project_id; // insert matchdetaillinks //$newrows[$key]['link'] = 'index.php?option=com_joomleague&view=nextmatch&p='.$row->project_id.'&mid='.$row->matchcode; $newrows[$key]['link'] = JoomleagueHelperRoute::getNextMatchRoute($row->project_id, $row->matchcode); $matches[] = $newrows[$key]; //parent::addTeam($row->matchpart1, parent::jl_utf8_convert ($teams[$row->matchpart1]->name, 'iso-8859-1', 'utf-8'), $newrows[$key]['homepic']); //parent::addTeam($row->matchpart2, parent::jl_utf8_convert ($teams[$row->matchpart2]->name, 'iso-8859-1', 'utf-8'),$newrows[$key]['awaypic']); parent::addTeam($row->projectteam1_id, parent::jl_utf8_convert($teams[$row->projectteam1_id]->name, 'iso-8859-1', 'utf-8'), $newrows[$key]['homepic']); parent::addTeam($row->projectteam2_id, parent::jl_utf8_convert($teams[$row->projectteam2_id]->name, 'iso-8859-1', 'utf-8'), $newrows[$key]['awaypic']); /* echo 'function formatMatches projectteam1_id<br>'; echo $row->projectteam1_id.'-'.$teams[$row->projectteam1_id]->name.'<br>'; echo $row->projectteam2_id.'-'.$teams[$row->projectteam2_id]->name.'<br>'; */ } return $newrows; }
function formatMatches($rows, &$matches) { $newrows = array(); $teamnames = $this->xparams->get('team_names', 'short_name'); $teams = JoomleagueConnector::getTeamsFromMatches($rows); $teams[0] = new stdclass(); $teams[0]->name = $teams[0]->{$teamnames} = $teams[0]->logo_small = $teams[0]->logo_middle = $teams[0]->logo_big = ''; foreach ($rows as $key => $row) { $newrows[$key]['type'] = 'jlm'; $newrows[$key]['homepic'] = JoomleagueConnector::buildImage($teams[$row->projectteam1_id]); $newrows[$key]['awaypic'] = JoomleagueConnector::buildImage($teams[$row->projectteam2_id]); $newrows[$key]['date'] = JoomleagueHelper::getMatchStartTimestamp($row); //$newrows[$key]['result'] = (!is_null($row->matchpart1_result)) ? $row->matchpart1_result . ':' . $row->matchpart2_result : '-:-'; $newrows[$key]['result'] = !is_null($row->team1_result) ? $row->team1_result . ':' . $row->team2_result : '-:-'; $newrows[$key]['headingtitle'] = parent::jl_utf8_convert($row->name . '-' . $row->roundname, 'iso-8859-1', 'utf-8'); $newrows[$key]['homename'] = JoomleagueConnector::formatTeamName($teams[$row->projectteam1_id]); $newrows[$key]['awayname'] = JoomleagueConnector::formatTeamName($teams[$row->projectteam2_id]); $newrows[$key]['matchcode'] = $row->matchcode; $newrows[$key]['project_id'] = $row->project_id; // insert matchdetaillinks $newrows[$key]['link'] = JoomleagueHelperRoute::getNextMatchRoute($row->project_id, $row->matchcode); $matches[] = $newrows[$key]; parent::addTeam($row->projectteam1_id, parent::jl_utf8_convert($teams[$row->projectteam1_id]->name, 'iso-8859-1', 'utf-8'), $newrows[$key]['homepic']); parent::addTeam($row->projectteam2_id, parent::jl_utf8_convert($teams[$row->projectteam2_id]->name, 'iso-8859-1', 'utf-8'), $newrows[$key]['awaypic']); } return $newrows; }