</td>
<td>
<?php
if ($this->acl == 1 && ($lists["jssa_editplayer"] == 1 or $lists["jssa_deleteplayers"])) {
echo $checked;
} elseif ($this->acl == 2) {
echo $checked;
}
?>
</td>
<td>
<?php
if ($row->photo && is_file('media/bearleague/' . $row->photo)) {
echo '<div class="team-embl" style="margin-right:8px;"><img class="team-embl player-ico" ' . getImgPop($row->photo, 1) . ' alt="" /></div><p class="player-name" style="display: table-cell;padding-left:7px;">';
} else {
echo '<img class="player-ico" src="' . JURI::base() . 'components/com_joomsport/img/ico/season-list-player-ico.gif" width="30" height="30" alt=""><p class="player-name">';
}
?>
<?php
echo '<a href="' . $link . '">' . $row->first_name . ' ' . $row->last_name . '</a>';
?>
</p>
</td>
</tr>
</td>
<td class="w50">
<?php
if ($this->acl == 1 && ($lists["jssa_editplayer"] == 1 or $lists["jssa_deleteplayers"])) {
echo $checked;
} elseif ($this->acl == 2) {
echo $checked;
}
?>
</td>
<td>
<?php
if ($row->photo && is_file('media/bearleague/' . $row->photo)) {
echo '<img class="img-thumbnail" ' . getImgPop($row->photo, 1) . ' alt="" />';
} else {
echo '<img class="img-thumbnail" src="' . JURI::base() . 'components/com_joomsport/img/ico/season-list-player-ico.gif" width="30" height="30" alt="">';
}
?>
<?php
echo '<a href="' . $link . '">' . $row->first_name . ' ' . $row->last_name . '</a>';
?>
</td>
</tr>
<?php
}
}
?>
<input type="text" disabled="true" name="betevents_points2[<?php
echo $match->mid;
?>
][<?php
echo $event->id;
?>
]"/>
<?php
}
?>
</td>
</tr>
<?php
}
?>
<?php
}
?>
<tr>
<td colspan="3">
<input type="hidden" name="bet_match[]" value="<?php
echo $match->mid;
?>
"/>
<input type="button" value="<?php
echo JText::_("BLFA_BET_SUBMIT_BET");
?>
" onClick="document.adminForm.task.value = 'bet_team_save';document.adminForm.submit();"/>
</td>
</tr>
</span>
</td>
<td class="text-right"><?php
echo $match->home;
?>
</td>
<td style="width:6%"><button type="button" class="btn btn-default"
data-toggle="tooltip" data-placement="bottom" title="" data-original-title="Tooltip on bottom">
<?php
if ($match->m_played == 1) {
echo $match->score1;
?>
: <?php
echo $match->score2;
if ($match->is_extra) {
echo '<span class="ET" title="' . JText::_('BLFA_TEAM_WON_ET') . '">' . JText::_('BL_RES_EXTRA') . '</span>';
}
} else {
?>
- : -
<?php
}
?>
</button>
</td>
<td class="text-left"><?php
echo $match->away;
?>
</td>
<?php
if ($lists["locven"]) {
<?php
if (count($list)) {
?>
<?php
foreach ($list as $player) {
?>
<div style="width:99%;overflow:hidden;"><?php
$defimg = modBlPlayersHelper::getPhoto($player);
$teams = modBlPlayersHelper::getTeamName($player, $params);
if ($is_width) {
echo '<div style="float:left;width:' . ($ph_width + 2) . 'px;height:' . ($ph_width + 12) . 'px;margin:0px 10px 0px 0px;">';
if ($defimg && is_file('media/bearleague/' . $defimg)) {
//echo '<img style="border:1px solid #aaa;" src="media/bearleague/'.$defimg.'" title="'.$player->e_name.'" height="'.$ph_width.'" />';
echo '<div class="team-embl" style="width:' . $ph_width . 'px;"><img ' . getImgPop($defimg, 5, $ph_width, $ph_width) . '></div>';
} else {
//echo " ";
echo '<div class="team-embl"><img class="player-ico" src="' . JURI::base() . 'components/com_joomsport/img/ico/season-list-player-ico.gif" width="30" height="30" alt=""></div>';
}
echo '</div>';
}
//else{
if ($player->e_img && is_file('media/bearleague/events/' . $player->e_img)) {
echo '<img src="media/bearleague/events/' . $player->e_img . '" title="' . $player->e_name . '" height="15" />';
}
//}
$link = "<a href='" . JRoute::_('index.php?option=com_joomsport&task=player&id=' . $player->id . '&sid=' . $s_id . '&Itemid=' . $cItemId) . "'>" . ($plname && $player->nick ? $player->nick : $player->name) . "</a>";
echo ' <strong>' . $player->cnt . '</strong> ' . $link;
if ($teams && $displ_team) {
echo $teams;
function getComments()
{
$this->_lists["usera"] = JFactory::getUser();
if ($this->getVer() >= '1.6') {
$query = "SELECT DISTINCT(c.id),c.*,IF(pl.nick <> '',pl.nick,p.name) as nick, p.id as usrid,pl.id as usrid,pl.def_img,CONCAT(pl.first_name,' ',pl.last_name) as plname" . " FROM `#__bl_comments` as c, #__users as p LEFT JOIN #__bl_players as pl ON p.id=pl.usr_id" . " WHERE c.match_id = " . $this->m_id . " AND c.user_id=p.id" . " ORDER BY c.date_time";
} else {
$query = "SELECT DISTINCT(c.id), c.*,IF(pl.nick <> '',pl.nick,p.name) as nick, IF(p.gid <> 25,'0','1') as gid, p.id as usrid,pl.id,pl.def_img,CONCAT(pl.first_name,' ',pl.last_name) as plname" . " FROM `#__bl_comments` as c, #__users as p LEFT JOIN #__bl_players as pl ON p.id=pl.usr_id" . " WHERE c.match_id = " . $this->m_id . " AND c.user_id=p.id" . " ORDER BY c.date_time";
}
$this->db->setQuery($query);
$this->_lists["comments"] = $this->db->loadObjectList();
$error = $this->db->getErrorMsg();
if ($error) {
return JError::raiseError(500, $error);
}
for ($j = 0; $j < count($this->_lists["comments"]); $j++) {
$player_comment = $this->_lists["comments"][$j];
$def_img = '';
if ($player_comment->id) {
if ($pl_id = $player_comment->usrid) {
$pl_image = $player_comment->def_img;
$query = "SELECT p.ph_name as name,p.id as id,p.ph_filename as filename FROM #__bl_assign_photos as ap, #__bl_photos as p WHERE ap.photo_id = p.id AND cat_type = 1 AND cat_id = " . $pl_id;
$this->db->setQuery($query);
$photos = $this->db->loadObjectList();
if ($pl_image) {
$query = "SELECT ph_filename FROM #__bl_photos as p WHERE p.id = " . $pl_image;
$this->db->setQuery($query);
$def_img = $this->db->loadResult();
} else {
if (isset($photos[0])) {
$def_img = $photos[0]->filename;
}
}
}
}
//$avatar = JURI::base()."components/com_joomsport/img/ico/season-list-player-ico.gif";
if (is_file('media/bearleague/' . $def_img)) {
//$avatar = JURI::base()."media/bearleague/".$def_img;
$avatar = getImgPop($def_img, 1);
$this->_lists["comments"][$j]->avatar = $avatar;
}
}
if ($this->getVer() >= '1.6') {
$query = "SELECT IF(m.group_id <> 8,'','1') as gid" . " FROM #__users as p, #__user_usergroup_map as m" . " WHERE m.user_id=p.id AND p.id=" . $this->_lists["usera"]->id;
} else {
$query = "SELECT IF(p.gid <> 25,'0','1') as gid" . " FROM #__users as p" . " WHERE p.id=" . $this->_lists["usera"]->id;
}
$this->db->setQuery($query);
$this->_lists["comments_adm"] = $this->db->loadResult();
$error = $this->db->getErrorMsg();
if ($error) {
return JError::raiseError(500, $error);
}
$query = "SELECT COUNT(*) FROM #__users as u, #__bl_feadmins as f WHERE f.user_id = u.id AND f.season_id='" . $this->s_id . "' AND u.id = '" . intval($this->_lists["usera"]->id) . "'";
$this->db->setQuery($query);
if ($this->db->loadResult()) {
$this->_lists["comments_adm"] = 1;
}
$error = $this->db->getErrorMsg();
if ($error) {
return JError::raiseError(500, $error);
}
}
</b>
<?php
if (@$lists["enbl_extra"] && $playoff_match->is_extra) {
$class_ext = $playoff_match->score1 > $playoff_match->score2 ? "extra-time-h" : "extra-time-g";
echo '<span class="' . $class_ext . '" title="' . JText::_('BLFA_TEAM_WON_ET') . '">' . JText::_('BL_RES_EXTRA') . '</span>';
}
?>
</a>
</td>
<td class="team-ico-a"><!-- -->
<?php
if (!$this->lists['t_single']) {
if ($playoff_match->emb2 && is_file('media/bearleague/' . $playoff_match->emb2)) {
echo '<div class="team-embl"><img ' . getImgPop($playoff_match->emb2, 1) . ' alt="' . $playoff_match->away . '" /></div>';
} else {
echo '<img class="player-ico" src="' . JURI::base() . 'components/com_joomsport/img/ico/players-ico.png" width="30" height="30" alt="">';
}
}
?>
</td>
<td class="team_a"><span><?php
echo $playoff_match->away;
?>
</span></td>
</tr>
echo htmlspecialchars($photos->name);
?>
" />
</td>
<td align="center">
<?php
$imgsize = getimagesize(JPATH_ROOT . '/media/bearleague/' . $photos->filename);
if ($imgsize[0] > 200) {
$width = 200;
} else {
$width = $imgsize[0];
}
?>
<a rel="lightbox-imgsport" href="<?php
echo getImgPop($photos->filename);
?>
" title="Image"><img src="<?php
echo JURI::base();
?>
media/bearleague/<?php
echo $photos->filename;
?>
" width="<?php
echo $width;
?>
" /></a>
</td>
</tr>
<?php
}
defined('_JEXEC') or die('Restricted access');
if (isset($this->message)) {
$this->display('message');
}
global $Itemid;
$Itemid = JRequest::getInt('Itemid');
echo $this->lists["panel"];
?>
<!-- <module middle> -->
<div class="module-middle solid">
<!-- <back box> -->
<?php
if ($this->lists['socbut']) {
?>
<div class="back dotted">
<div class="div_for_socbut">
<?php
echo $this->lists['socbut'];
?>
</div>
<div class="clear"></div>
</div>
<?php
}
?>
<!-- </back box> -->
<!-- <title box> -->
<div class="title-box">
<h2>
<td class="emblem_taway_<?php
echo $align_away_emblem;
?>
" <?php
echo $style_margin_emblem;
?>
> <!-- -->
<a <?php
echo $link_emblem_away_a;
?>
>
<?php
if ($match->emb2 && is_file('media/bearleague/' . $match->emb2) && $embl_is) {
//echo '<img src="'.JURI::base().'media/bearleague/'.$match->emb2.'" '.$tooltip_away.' width="'.$emblem_width.'" height="'.$emblem_height.'">';
echo '<img ' . getImgPop($match->emb2, 5, $emblem_height, $emblem_width) . ' ' . $tooltip_away . '>';
} else {
echo $single ? '<img class="player-ico" src="' . JURI::base() . 'components/com_joomsport/img/ico/season-list-player-ico.gif" width="30" height="30" alt="">' : '<img class="player-ico" src="' . JURI::base() . 'components/com_joomsport/img/ico/players-ico.png" width="30px" height="30px" style="max-width: none;" alt="">';
}
?>
</a>
</td>
<?php
}
?>
</tr>
<?php
break;
}
function getePanel($team, $reg, $sid, $cal = 0, $inv = 0, $tbl = 0)
{
$Itemid = JRequest::getInt('Itemid');
$team_reg = $this->getJS_Config('team_reg');
$link2 = JRoute::_('index.php?option=com_joomsport&view=seasonlist&limitstart=0&Itemid=' . $Itemid);
$kl = '<div class="module-header">';
$img_pop = explode("/", $this->getJS_Config('jsbrand_epanel_image'));
if ($this->getJS_Config('jsbrand_epanel_image') && is_file(JPATH_ROOT . $this->getJS_Config('jsbrand_epanel_image'))) {
if (count($img_pop) == 5) {
$kl .= '<a class="module-logo" href="' . $link2 . '" title="JoomSport"><img src="' . JURI::base() . $this->getJS_Config('jsbrand_epanel_image') . '" height="38" /></a>';
} else {
$kl .= '<a class="module-logo" href="' . $link2 . '" title="JoomSport"><img ' . getImgPop($img_pop[3], 5, 38, 53) . ' /></a>';
}
}
$kl .= '<ul class="module-menu">';
$query = "SELECT COUNT(*) FROM #__bl_moders WHERE tid= " . $inv;
$this->db->setQuery($query);
$is_moder = $this->db->loadResult();
if (isset($team[0])) {
//$link = JRoute::_('index.php?option=com_joomsport&view=edit_team&tid='.$team[0].'&controller=moder&Itemid='.$Itemid);
//$kl .= '<li><a href="'.$link.'" title="'.JText::_('BLFA_YTEAM').'"><span class="module-menu-manage-team">'.JText::_('BLFA_YTEAM').'</span></a></li>';
}
$tr = false;
$_users = JFactory::getUser();
$query = "Select * FROM #__bl_players WHERE usr_id=" . $_users->id;
$this->db->setQuery($query);
$usr = $this->db->loadObject();
$error = $this->db->getErrorMsg();
if ($error) {
return JError::raiseError(500, $error);
}
if (!$this->getJS_Config('player_reg') && $usr && $_users->id) {
$tr = true;
}
if ($this->getJS_Config('player_reg')) {
$tr = true;
}
if ($team_reg && ($tr || $this->getJS_Config('player_team_reg') == '0')) {
//$link = JRoute::_('index.php?option=com_joomsport&task=regteam&Itemid='.$Itemid);
//$kl .= '<li><a href="'.$link.'" title="'.JText::_('BLFA_NTEAM').'"><span class="module-menu-new-team">'.JText::_('BLFA_NTEAM').'</span></a></li>';
}
if ($cal && $sid > 0) {
$kl .= '<li><a href="' . JRoute::_('index.php?option=com_joomsport&task=calendar&sid=' . $sid . '&Itemid=' . $Itemid) . '" title="' . JText::_('BLFA_CALENDAR') . '"><span class="module-menu-calendar">' . JText::_('BLFA_CALENDAR') . '</span></a></li>';
}
if ($tbl && $sid > 0) {
$kl .= '<li><a href="' . JRoute::_('index.php?option=com_joomsport&task=table&sid=' . $sid . '&Itemid=' . $Itemid) . '" title="' . JText::_('BL_TAB_TBL') . '"><span class="module-menu-table">' . JText::_('BL_TAB_TBL') . '</span></a></li>';
}
if ($reg && $tr) {
$kl .= '<li><a href="' . JRoute::_('index.php?option=com_joomsport&task=join_season&sid=' . $sid . '&Itemid=' . $Itemid) . '" title="' . JText::_('BLFA_REGGG') . '"<span class="module-menu-join-season">' . JText::_('BLFA_REGGG') . '</span></a></li>';
}
if ($inv && $this->getJS_Config('esport_join_team') && $sid && $tr && $is_moder) {
$kl .= '<li><a href="' . JRoute::_('index.php?option=com_joomsport&task=jointeam&sid=' . $sid . '&tid=' . $inv . '&Itemid=' . $Itemid) . '" title="' . JText::_('BLFA_PLJOINTEAM') . '"><span class="module-menu-editor">' . JText::_('BLFA_PLJOINTEAM') . '</span></a></li>';
}
if ($this->getJS_Config('player_reg')) {
//$link = JRoute::_('index.php?option=com_joomsport&task=regplayer&Itemid='.$Itemid);
//$kl .= '<li><a href="'.$link.'" title="'.JText::_('BLFA_EDITFIPROF').'"><span class="module-menu-join"><!-- --></span></a><span class="twice-border"></span></li>';
}
$kl .= '</ul></div><div class="under-module-header"></div>';
return $kl;
}
;">
<td width="20"><?php
echo $n;
?>
</td>
<?php
if ($params->get('emblem_chk') == 1) {
?>
<td style="border-right:0px;">
<?php
if ($team['t_emblem'] && is_file('media/bearleague/' . $team['t_emblem'])) {
//echo '<img src="'.JURI::base().'media/bearleague/'.$team['t_emblem'].'" class="embl_in_tblmod">';
//print_r($team['t_emblem']);
echo '<div class="team-embl" style="margin-right:8px;"><img ' . getImgPop($team['t_emblem'], 1) . ' alt="' . $team['name'] . '" style="max-width: none;"/></div>';
} else {
echo '<div class="team-embl" style="margin-right:8px;">' . ($team['t_single'] ? '<img class="player-ico" src="' . JURI::base() . 'components/com_joomsport/img/ico/season-list-player-ico.gif" width="30" height="30" alt="">' : '<img class="player-ico" src="' . JURI::base() . 'components/com_joomsport/img/ico/players-ico.png" width="30px" height="30px" style="max-width: none;" alt="">') . '</div>';
}
?>
</td>
<?php
}
?>
<td width="80%" style="text-align:left;border-left:0px; padding:0px 10px;" nowrap='nowrap' class="blteamname<?php
echo $params->get('moduleclass_sfx');
?>
">
if ($this->lists["m_events_home"][$i]->minutes) {
echo $this->lists["m_events_home"][$i]->minutes . "'";
} else {
echo " ";
}
?>
</td>
<?php
} else {
echo '<td style="padding:0px" colspan="3"> </td>';
}
if (isset($this->lists["m_events_away"][$i])) {
echo '<td class="away_event" width="40%" style="padding-left:35px;">';
if (isset($this->lists["m_events_away"][$i]->e_img) && $this->lists["m_events_away"][$i]->e_img && is_file('media/bearleague/events/' . $this->lists["m_events_away"][$i]->e_img)) {
echo '<img ' . getImgPop($this->lists["m_events_away"][$i]->e_img, 6) . ' title="' . $this->lists["m_events_away"][$i]->e_name . '" alt="' . $this->lists["m_events_away"][$i]->e_name . '" />';
} else {
echo "<span class='js_event_name'>" . $this->lists["m_events_away"][$i]->e_name . "</span>";
}
if (!$this->lists['t_single']) {
echo " " . $this->lists["m_events_away"][$i]->p_name;
}
echo '</td>';
?>
<td class="away_event_count" width="5%">
<?php
if ($this->lists["m_events_away"][$i]->ecount) {
echo $this->lists["m_events_away"][$i]->ecount;
} else {
echo "0";
function playerEvents()
{
$seaslist = '';
if (count($this->seasplayed)) {
$seaslist = implode(',', $this->seasplayed);
}
$stat_array = array();
$query = "SELECT DISTINCT(ev.id),ev.* FROM #__bl_events as ev, #__bl_match_events as me, #__bl_match as m, #__bl_matchday as md" . " WHERE (ev.id = me.e_id OR (ev.sumev1 = me.e_id OR ev.sumev2 = me.e_id)) AND me.match_id = m.id" . " AND m.m_id=md.id " . ($this->s_id ? " AND md.s_id=" . $this->s_id : ($seaslist ? " AND md.s_id IN (" . $seaslist . ")" : "")) . " AND (ev.player_event = 1 OR ev.player_event = 2)" . " ORDER BY ev.ordering";
$this->db->setQuery($query);
$events = $seaslist || $this->s_id ? $this->db->loadObjectList() : array();
//print_r($events);
$error = $this->db->getErrorMsg();
if ($error) {
return JError::raiseError(500, $error);
}
// print_r($seaslist);
///////getTeams
$query = "SELECT team_id FROM #__bl_players_team as t WHERE t.player_id = '" . $this->player_id . "' " . ($this->s_id ? " AND t.season_id=" . $this->s_id : ($seaslist ? " AND t.season_id IN (" . $seaslist . ")" : "")) . "\n UNION \n SELECT s.t_id FROM #__bl_match_events as s JOIN #__bl_match as m ON m.id=s.match_id JOIN #__bl_matchday as md ON (m.m_id=md.id " . ($this->s_id ? " AND md.s_id=" . $this->s_id : ($seaslist ? " AND md.s_id IN (" . $seaslist . ")" : "")) . ")";
//print_r($query);
$this->db->setQuery($query);
$teams = $this->db->loadColumn();
$teamss = array();
if (count($teams)) {
$teamss = implode(',', $teams);
// $query .= " AND m.id NOT IN (".$midss.")";
if ($this->s_id == 0) {
$teamss .= ",''";
}
}
///////////////
$unbl_matchplayed = $this->getJS_Config('played_matches');
if ($unbl_matchplayed) {
//
$single = 1;
if ($this->s_id) {
$tourn = $this->getTournOpt($this->s_id);
$single = isset($tourn->t_single) ? $tourn->t_single : '';
}
//
$stat_array[0][0] = JText::_('BLFA_MATCHPLAYED');
$query = "SELECT COUNT(*) FROM #__bl_squard as s, #__bl_match as m, #__bl_matchday as md WHERE md.id=m.m_id " . ($this->s_id ? " AND md.s_id=" . $this->s_id : ($seaslist ? " AND md.s_id IN (" . $seaslist . ")" : '')) . " AND m.id=s.match_id AND m.m_played='1' AND s.mainsquard='1' AND s.player_id=" . $this->player_id;
$this->db->setQuery($query);
$gamepl = $this->s_id || $seaslist ? intval($this->db->loadResult()) : '';
$query = "SELECT m.id FROM #__bl_squard as s, #__bl_match as m, #__bl_matchday as md WHERE md.id=m.m_id " . ($this->s_id ? " AND md.s_id=" . $this->s_id : ($seaslist ? " AND md.s_id IN (" . $seaslist . ")" : "")) . " AND m.id=s.match_id AND m.m_played='1' AND s.mainsquard='1' AND s.player_id=" . $this->player_id;
$this->db->setQuery($query);
$mids = $this->db->loadColumn();
if ($this->s_id == -1) {
$single = 1;
}
if ($single) {
$this->s_id ? $this->seassingle : array_push($this->seassingle, -1);
// print_r($this->seassingle);
$query = "SELECT COUNT(*)" . " FROM #__bl_matchday as md, #__bl_match as m, #__bl_players as t1, #__bl_players as t2" . " WHERE m.m_id = md.id AND m.m_single = 1 AND m.published = 1 AND m.m_played='1' " . ($this->s_id < 0 ? " AND m.m_single = 1" : "") . " " . ($this->s_id ? "AND md.s_id=" . $this->s_id : (count($this->seassingle) ? " AND md.s_id IN (" . implode(',', $this->seassingle) . ")" : "")) . " AND m.team1_id = t1.id AND m.team2_id = t2.id " . ($this->player_id ? " AND (t1.id=" . $this->player_id . " OR t2.id=" . $this->player_id . ")" : "");
$this->db->setQuery($query);
$gamepl += count($this->seassingle) > 1 ? intval($this->db->loadResult()) : 0;
}
//print_r($this->s_id );
$query = "SELECT COUNT(DISTINCT(m.id)) FROM #__bl_subsin as s, #__bl_match as m, #__bl_matchday as md WHERE md.id=m.m_id " . ($this->s_id ? " AND md.s_id=" . $this->s_id : ($seaslist ? " AND md.s_id IN (" . $seaslist . ")" : "")) . " AND m.id=s.match_id AND m.m_played='1' AND s.player_in=" . $this->player_id;
if (count($mids)) {
$midss = implode(',', $mids);
$query .= " AND m.id NOT IN (" . $midss . ")";
}
$this->db->setQuery($query);
$gm = intval($this->db->loadResult());
$gamepl += $gm;
$stat_array[0][1] = $gamepl;
$stat_array[0][2] = ' ';
}
for ($j = 0; $j < count($events); $j++) {
$jn = $unbl_matchplayed ? $j + 1 : $j;
$stat_array[$jn][0] = $events[$j]->e_name;
$query_all = " FROM #__bl_match_events as me, #__bl_match as m, #__bl_matchday as md" . " WHERE me.e_id = " . $events[$j]->id . " AND me.player_id = " . $this->player_id . " " . (count($teamss) ? " AND me.t_id IN(" . $teamss . ")" : " AND me.t_id = ''") . " AND me.match_id = m.id AND m.m_played = 1 AND md.id=m.m_id " . ($this->s_id ? " AND md.s_id=" . $this->s_id : ($seaslist ? " AND md.s_id IN (" . $seaslist . ")" : ""));
//print_r($query_all);
if ($events[$j]->result_type == '1') {
$query = "SELECT AVG(me.ecount) " . $query_all;
$this->db->setQuery($query);
} else {
$query = "SELECT SUM(me.ecount) " . $query_all;
$this->db->setQuery($query);
}
$error = $this->db->getErrorMsg();
if ($error) {
return JError::raiseError(500, $error);
}
if ($events[$j]->player_event == '2') {
$this->db->setQuery("SELECT SUM(me.ecount) FROM #__bl_match_events as me, #__bl_match as m, #__bl_matchday as md WHERE (me.e_id = " . $events[$j]->sumev1 . " OR me.e_id = " . $events[$j]->sumev2 . ") AND me.player_id = " . $this->player_id . " AND me.match_id = m.id AND m.m_played = 1 AND md.id=m.m_id " . ($this->s_id ? "AND md.s_id=" . $this->s_id : ($seaslist ? " AND md.s_id IN (" . $seaslist . ")" : "")));
}
$stat_array[$jn][1] = floatval($this->db->loadResult());
$error = $this->db->getErrorMsg();
if ($error) {
return JError::raiseError(500, $error);
}
if (!$stat_array[$jn][1]) {
$stat_array[$jn][1] = 0;
}
$stat_array[$jn][2] = ' ';
if ($events[$j]->e_img && is_file('media/bearleague/events/' . $events[$j]->e_img)) {
// $stat_array[$jn][2] = '<img src="media/bearleague/events/'.$events[$j]->e_img.'" title="'.$events[$j]->e_name.'" height="20" />';
$stat_array[$jn][2] = '<img class="team-embl player-ico" ' . getImgPop($events[$j]->e_img, 6) . ' alt="' . $events[$j]->e_name . '" />';
}
}
$this->_lists["stat_array"] = $stat_array;
}
?>
"><i class="fa fa-print"></i><?php
echo JText::_("BLFA_PRINT");
?>
</a>
<h1><?php
echo $this->escape($this->ptitle);
?>
</h1>
</div>
<div class="itemDetails col-xs-12 col-lg-12">
<div class="well well-sm col-xs-12 col-sm-6 col-md-3 col-lg-2">
<?php
$tLogo = '';
if ($lists["curseas"]->logo && is_file('media/bearleague/' . $lists["curseas"]->logo)) {
$tLogo = "<img class='img-responsive img-thumbnail' " . getImgPop($lists["curseas"]->logo, 4) . " alt='" . $this->params->get('page_title') . "' />";
}
if ($lists['ext_fields'] || $tLogo) {
echo $tLogo;
echo $lists['ext_fields'];
}
?>
</div>
<p class="txt-cnt"></p>
</div>
<div class="itemTable col-xs-12 col-lg-12">
<!-- Nav tabs -->
<ul class="nav nav-tabs" role="tablist">
<?php
if ($lists['is_group_matches'] || !$lists['is_matches']) {
<?php
/*------------------------------------------------------------------------
# JoomSport Professional
# ------------------------------------------------------------------------
# BearDev development company
# Copyright (C) 2011 JoomSport.com. All Rights Reserved.
# @license - http://joomsport.com/news/license.html GNU/GPL
# Websites: http://www.JoomSport.com
# Technical Support: Forum - http://joomsport.com/helpdesk/
-------------------------------------------------------------------------*/
// no direct access
defined('_JEXEC') or die('Restricted access');
$Itemid = JRequest::getInt('Itemid');
echo $this->lists["panel"];
?>
<form action="" method="post" name="adminForm" id="adminForm">
<!-- <module middle> -->
<div class="module-middle solid">
<!-- <back box> -->
<!-- <div class="back dotted"><a href="#" title="Back">← Back</a></div> -->
<!-- </back box> -->
<!-- <title box> -->
<div class="title-box">
<h2><?php
echo $this->escape($this->ptitle);
?>
</h2>
function getPlEvents()
{
$Itemid = JRequest::getInt('Itemid');
$query = "SELECT DISTINCT(ev.id),ev.*" . " FROM #__bl_events as ev, #__bl_match_events as me, #__bl_match as m, #__bl_matchday as md" . " WHERE (ev.id = me.e_id OR (ev.sumev1 = me.e_id OR ev.sumev2 = me.e_id)) AND me.match_id = m.id" . " AND m.m_id=md.id " . ($this->s_id ? " AND md.s_id=" . $this->s_id : "") . " AND (ev.player_event = 1 OR ev.player_event = 2)" . " ORDER BY ev.ordering";
$this->db->setQuery($query);
$events = $this->db->loadObjectList();
$error = $this->db->getErrorMsg();
if ($error) {
return JError::raiseError(500, $error);
}
$arr_pllist = array();
for ($z = 0; $z < count($this->_lists["players"]); $z++) {
$arr_pllist[$z] = array();
//name
$arr_pllist[$z]["name"] = $this->selectPlayerName($this->_lists["players"][$z]);
//$this->_lists["players"][$z]->first_name." ".$this->_lists["players"][$z]->last_name;
$arr_pllist[$z]["id"] = $this->_lists["players"][$z]->id;
$query = "SELECT t.id,t.t_name FROM #__bl_teams as t, #__bl_players_team as p " . ($this->s_id ? ",#__bl_season_teams as pt" : "") . " WHERE p.team_id=t.id AND p.player_id=" . $this->_lists["players"][$z]->id . " " . ($this->s_id ? " AND pt.season_id=" . $this->s_id . " AND pt.team_id=t.id AND p.season_id=" . $this->s_id : "") . " ORDER BY t.t_name";
$this->db->setQuery($query);
$arr_pllist[$z]["teams"] = '';
$arr_pllist[$z]["sortteams"] = '';
$teamzar = $this->db->loadObjectList();
$error = $this->db->getErrorMsg();
if ($error) {
return JError::raiseError(500, $error);
}
if (count($teamzar)) {
foreach ($teamzar as $tmz) {
$link2 = JRoute::_("index.php?option=com_joomsport&task=team&tid=" . $tmz->id . "&sid=" . $this->s_id . "&Itemid=" . $Itemid);
$arr_pllist[$z]["teams"] .= '<a href="' . $link2 . '">' . $tmz->t_name . '</a> ';
$arr_pllist[$z]["sortteams"] .= $tmz->t_name;
}
}
//photos
$def_img2 = '';
if ($this->_lists["players"][$z]->def_img) {
$query = "SELECT ph_filename FROM #__bl_photos as p WHERE p.id = " . $this->_lists["players"][$z]->def_img;
$this->db->setQuery($query);
$def_img2 = $this->db->loadResult();
}
if (!$def_img2) {
$query = "SELECT p.ph_name as name,p.id as id,p.ph_filename as filename FROM #__bl_assign_photos as ap, #__bl_photos as p WHERE ap.photo_id = p.id AND cat_type = 1 AND cat_id = " . $this->_lists["players"][$z]->id;
$this->db->setQuery($query);
$photos2 = $this->db->loadObjectList();
if (isset($photos2[0])) {
$def_img2 = $photos2[0]->filename;
}
}
$arr_pllist[$z]['photo'] = $def_img2;
for ($j = 0; $j < count($events); $j++) {
//$this->_lists["players"][$z]->stat_array[$j][0] = $events[$j]->e_name;
$query_all = " FROM #__bl_match_events as me, #__bl_match as m, #__bl_matchday as md" . " WHERE me.e_id = " . $events[$j]->id . " AND me.player_id = " . $this->_lists["players"][$z]->id . " AND me.match_id = m.id AND m.m_played = 1 AND md.id=m.m_id AND md.s_id=" . $this->s_id;
if ($events[$j]->result_type == '1') {
$query = "SELECT AVG(me.ecount) " . $query_all;
} else {
$query = "SELECT SUM(me.ecount) " . $query_all;
}
if ($events[$j]->player_event == '2') {
$query = "SELECT SUM(me.ecount) FROM #__bl_match_events as me, #__bl_match as m, #__bl_matchday as md WHERE (me.e_id = " . $events[$j]->sumev1 . " OR me.e_id = " . $events[$j]->sumev2 . ") AND me.player_id = " . $this->_lists["players"][$z]->id . " AND me.match_id = m.id AND m.m_played = 1 AND md.id=m.m_id " . ($this->s_id ? "AND md.s_id=" . $this->s_id : "");
}
$this->db->setQuery($query);
$arr_pllist[$z][$events[$j]->id] = floatval($this->db->loadResult());
$error = $this->db->getErrorMsg();
if ($error) {
return JError::raiseError(500, $error);
}
if (!$arr_pllist[$z][$events[$j]->id]) {
$arr_pllist[$z][$events[$j]->id] = 0;
}
//$stat_array[$jn][2] = ' ';
if ($events[$j]->e_img && is_file('media/bearleague/events/' . $events[$j]->e_img)) {
// $events[$j]->e_imgth = '<img src="media/bearleague/events/'.$events[$j]->e_img.'" title="'.$events[$j]->e_name.'" height="20" />';
$events[$j]->e_imgth = '<img class="team-embl player-ico" ' . getImgPop($events[$j]->e_img, 6) . ' alt="' . $events[$j]->e_name . '" title="' . $events[$j]->e_name . '"/>';
}
}
}
if (count($arr_pllist)) {
$sort_arr = array();
foreach ($arr_pllist as $uniqid => $row) {
foreach ($row as $key => $value) {
$sort_arr[$key][$uniqid] = $value;
}
}
if (isset($sort_arr[$this->sortfield])) {
array_multisort($sort_arr[$this->sortfield], $this->sortdest ? SORT_DESC : SORT_ASC, $arr_pllist);
}
}
$this->_lists["players"] = $arr_pllist;
$this->_lists["events"] = $events;
}
$tbl_info .= $match->m_events_away[$j]->minutes . "’";
} else {
$tbl_info .= " ";
}
$tbl_info .= "</td>";
$tbl_info .= '<td class="away_event_count" width="20">';
if ($match->m_events_away[$j]->ecount) {
$tbl_info .= $match->m_events_away[$j]->ecount;
} else {
$tbl_info .= "0";
}
$tbl_info .= "</td>";
$tbl_info .= '<td class="away_event" width="42%">';
if ($match->m_events_away[$j]->e_img && is_file('media/bearleague/events/' . $match->m_events_away[$j]->e_img)) {
// $tbl_info .= '<img height="15" src="'.JURI::base().'media/bearleague/events/'.$match->m_events_away[$j]->e_img.'" title="'.$match->m_events_away[$j]->e_name.'" alt="'.$match->m_events_away[$j]->e_name.'" />';
$tbl_info .= '<img ' . getImgPop($match->m_events_away[$j]->e_img, 6) . ' title="' . $match->m_events_away[$j]->e_name . '" alt="' . $match->m_events_away[$j]->e_name . '" />';
} else {
$tbl_info .= $match->m_events_away[$j]->e_name;
}
if (!$this->lists['t_single']) {
$tbl_info .= " " . $match->m_events_away[$j]->p_name;
}
$tbl_info .= "</td>";
} else {
$tbl_info .= '<td style="padding:0px" width="10"> </td>';
$tbl_info .= '<td style="padding:0px" width="10"> </td>';
$tbl_info .= "<td style='padding:0px'> </td>";
}
$tbl_info .= '</tr>';
}
$tbl_info .= '</table></div>';
for ($j = 0; $j < count($this->lists["h_events"]); $j++) {
if ($this->lists["events"][$i]->e_name == $this->lists["h_events"][$j]->e_name) {
$this->lists["events"][$i]->h_ecount = $this->lists["h_events"][$j]->ecount;
}
}
}
for ($p = 0; $p < $how_rows; $p++) {
if ($p == 0) {
echo '</table><table class="season-list" style="margin-top:40px;" border="0" cellpadding="5" cellspacing="0" width="100%"><tr><th colspan="4" class="teams_stats"><h3>' . JText::_('BL_TBL_STAT') . '</h3></th></tr>';
}
echo '<tr class="' . ($p % 2 ? "gray" : "yellow") . '">';
echo "<td width='40%'>";
if (isset($this->lists["events"][$p])) {
if ($this->lists["events"][$p]->e_img && is_file('media/bearleague/events/' . $this->lists["events"][$p]->e_img)) {
// echo '<div style="float:left"><img height="20" src="'.JURI::base().'media/bearleague/events/'.$this->lists["events"][$p]->e_img.'" title="'.$this->lists["events"][$p]->e_name.'" alt="'.$this->lists["events"][$p]->e_name.'" /></div>';
echo '<div style="float:left"><img ' . getImgPop($this->lists["events"][$p]->e_img, 6) . ' title="' . $this->lists["events"][$p]->e_name . '" alt="' . $this->lists["events"][$p]->e_name . '" /></div>';
} else {
}
echo '<div style="float:left;padding:5px;">' . $this->lists["events"][$p]->e_name . "</div>";
} else {
echo " ";
}
echo "</td>";
echo "<td class='home_stats_minute' width='100'>";
echo $this->lists["events"][$p]->h_ecount;
echo "</td>";
echo "<td width='40%' style='padding-left:30px;'>";
echo "</td>";
echo "<td class='away_stats_minute' width='50'>";
echo $this->lists["events"][$p]->a_ecount;
echo "</td>";
