Assembla home | Assembla project page
 

Changeset 100

Show
Ignore:
Timestamp:
11/01/06 01:32:29 (2 years ago)
Author:
moensch
Message:

This should fix the issues with the participants in the frontend. See: http://www.mylansite.org/index.php?option=com_joomlaboard&Itemid=2&func=view&id=379&catid=4

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/com_mls_events/mls_events.php

    r37 r100  
    191191                        $i++; 
    192192                } 
    193                 $cbsql1 = "\n,".substr($cbsql1,0,strlen($cbsql1) - 1)."\n"; 
    194                 $cbsql2 = "\n INNER JOIN `#__comprofiler` AS `cb` ON cb.id=u.id"; 
     193                if(count($cbfields)) { 
     194                        $cbsql1 = "\n,".substr($cbsql1,0,strlen($cbsql1) - 1)."\n"; 
     195                        $cbsql2 = "\n INNER JOIN `#__comprofiler` AS `cb` ON cb.id=u.id"; 
     196                } else { 
     197                        $cbsql1 = ""; 
     198                        $cbsql2 = ""; 
     199                } 
    195200        } else { 
    196201                $cbsql1 = ""; 
    …… 
    217222                ."\n FROM `#__mls_events_participants` AS `p`" 
    218223                ."\n INNER JOIN `#__mls_events` AS `e` ON e.id = p.eventid" 
     224                ."\n INNER JOIN `#__users` AS u ON u.id = p.userid" 
    219225                .$cbsql2 
    220                 ."\n INNER JOIN `#__users` AS u ON u.id = p.userid $where" 
     226                ."\n" . $where 
    221227                ."\n ORDER BY p.subscribed_time" 
    222228                ."\n LIMIT $pageNav->limitstart, $pageNav->limit";