team small logo instead of team short name

User avatar
farzad123
.
Posts: 171
Joined: Thu Nov 29, 2007 9:18 pm

team small logo instead of team short name

Postby farzad123 » Sat Dec 29, 2007 8:29 pm

how to show team small logo instead of team short name in this module ? :)
Last edited by farzad123 on Fri Jan 18, 2008 12:19 pm, edited 1 time in total.
Joomla version : 1.5.26
Joomleague version: 1.6.0.9826ddb

User avatar
farzad123
.
Posts: 171
Joined: Thu Nov 29, 2007 9:18 pm

Re: team small logo instead of team short name

Postby farzad123 » Thu Jan 03, 2008 9:30 pm

no help?  :-[
Last edited by farzad123 on Fri Jan 11, 2008 11:16 am, edited 1 time in total.
Joomla version : 1.5.26
Joomleague version: 1.6.0.9826ddb

User avatar
farzad123
.
Posts: 171
Joined: Thu Nov 29, 2007 9:18 pm

Re: team small logo instead of team short name

Postby farzad123 » Fri Jan 11, 2008 11:17 am

how can i do this ?
Joomla version : 1.5.26
Joomleague version: 1.6.0.9826ddb

User avatar
farzad123
.
Posts: 171
Joined: Thu Nov 29, 2007 9:18 pm

Re: team small logo instead of team short name

Postby farzad123 » Tue Jan 15, 2008 8:52 pm

anybody there ?  ^-^
Joomla version : 1.5.26
Joomleague version: 1.6.0.9826ddb

User avatar
julienV
Joomleague Core Developer
Joomleague Core Developer
Posts: 2016
Joined: Tue Jun 19, 2007 9:27 am
Location: France
Contact:

Re: team small logo instead of team short name

Postby julienV » Wed Jan 16, 2008 1:56 am

in the php file:

Code: Select all

$query = sprintf("SELECT SUM(event_sum) AS value, p.firstname, p.lastname, t.short_name as team, c.logo_small as logo
            FROM #__joomleague_match_events AS me, #__joomleague_players AS p, #__joomleague_teams AS t, #__joomleague_playertool AS pt
            LEFT JOIN #__joomleague_clubs as c ON t.club_id=c.id
           WHERE me.player_id = p.id AND (...)

....

Code: Select all

  <tr class="<?php print $class;?>">
    <td align="right"><?php echo $row->value;?></td>
    <td> </td>
    <td align="left"><?php echo sprintf("%s %s <img src='%s'"/>,$row->firstname, $row->lastname, $mosConfig_live_site.'/'.$row->logo);?></td>
  </tr>


not tested whatsoever, hope you get the point
You can hire me, I'm a Joomla professional freelance developer.
Please contact me at jlv@jlv-solutions.com
NO PM, please use email !

User avatar
farzad123
.
Posts: 171
Joined: Thu Nov 29, 2007 9:18 pm

Re: team small logo instead of team short name

Postby farzad123 » Wed Jan 16, 2008 9:57 am

tanx julienV ,
it works . but a little bug . first Code is correct but second code is ture like this :

Code: Select all

<tr class="<?php print $class;?>">
    <td align="right"><?php echo $row->value;?></td>
    <td> </td>
    <td align="left"><?php echo sprintf("%s %s <img src='%s'",$row->firstname, $row->lastname, $mosConfig_live_site.'/'.$row->logo);?></td>
  </tr>


and one more question , how we can insert alt name for team logo .
for example when mouse over on the small logo it shows team long name .
my problem is its code ,
tanx alot again  :-*
Joomla version : 1.5.26
Joomleague version: 1.6.0.9826ddb

User avatar
julienV
Joomleague Core Developer
Joomleague Core Developer
Posts: 2016
Joined: Tue Jun 19, 2007 9:27 am
Location: France
Contact:

Re: team small logo instead of team short name

Postby julienV » Wed Jan 16, 2008 10:05 am

Code: Select all

<tr class="<?php print $class;?>">
    <td align="right"><?php echo $row->value;?></td>
    <td> </td>
    <td align="left"><?php echo sprintf("%s %s <img src='%s'  alt='%s'/>",$row->firstname, $row->lastname, $mosConfig_live_site.'/'.$row->logo, $row->team);?></td>
  </tr>
You can hire me, I'm a Joomla professional freelance developer.
Please contact me at jlv@jlv-solutions.com
NO PM, please use email !

User avatar
The-Lion
.
Posts: 27
Joined: Sat Aug 01, 2009 6:37 pm
Location: Breda
Contact:

Re: team small logo instead of team short name

Postby The-Lion » Mon Aug 03, 2009 8:43 pm

julienV wrote:in the php file:

Code: Select all

$query = sprintf("SELECT SUM(event_sum) AS value, p.firstname, p.lastname, t.short_name as team, c.logo_small as logo
            FROM #__joomleague_match_events AS me, #__joomleague_players AS p, #__joomleague_teams AS t, #__joomleague_playertool AS pt
            LEFT JOIN #__joomleague_clubs as c ON t.club_id=c.id
           WHERE me.player_id = p.id AND (...)


Where do I have to put this code? Or Which code do I have to replace?
:thx:
Joomla 1.5.20
Joomleague 0.93b
[url]http://www.theyellowarmy.nl[/url]


Return to “mod_joomleague_events_statistic”

Who is online

Users browsing this forum: No registered users and 2 guests

cron