Re: Total Games for Players

file: /components/com_joomsport/views/player/view.html.php

media/bearleague/events/symm.png : The picture for the played matches (as for events e.g. goals)

You should add this code BEFORE the line 120.

line 120: } => be careful before this...


line 123: //---language-----------//

Copy the following code!

/* played matches*/
$query = "SELECT count(*) as lineup,
concat(jos_bl_tournament.name,' - ',jos_bl_seasons.s_name) as tourn FROM
jos_bl_squard,
jos_bl_match,
jos_bl_matchday,
jos_bl_seasons,
jos_bl_tournament
Where jos_bl_squard.match_id=jos_bl_match.id
AND jos_bl_match.m_id=jos_bl_matchday.id
AND jos_bl_matchday.s_id=jos_bl_seasons.s_id
AND jos_bl_seasons.t_id=jos_bl_tournament.id
AND jos_bl_squard.player_id=".$player_id."
group by jos_bl_squard.player_id, jos_bl_seasons.s_id";
$db->setQuery($query);
$symm = $db->loadObjectList();
$num=count($events);
for($k=0;$k
$stat_array[$k+$num][0] = $symm[$k]->tourn;
$stat_array[$k+$num][1] = ": ".$symm[$k]->lineup;

$stat_array[$k+$num][2] = '';
}