Changeset 188 for trunk/com_mls_events/mls_events.php

Timestamp:

11/28/07 23:40:55 (2 years ago)

Author:

moensch

Message:

FMR 1019: Add ability to view past Events

Files:

• trunk/com_mls_events/mls_events.php (modified) (1 diff)

trunk/com_mls_events/mls_events.php

@@ -82 +82 @@
-        global $database,$my;
-        $row = new mosMLS_events($database);
+        if($_REQUEST["showpast"]) {
+                $cond = '';
+        } else {
+                $cond = ' AND e.end > NOW()';
+        }
-        $query = "SELECT e.*, COUNT(p.id) AS `usercount`, COUNT(IF(p.userid=".$my->id.",1,NULL)) AS `enrolled` FROM `#__mls_events` AS `e`"
-                        ."\n LEFT JOIN `#__mls_events_participants` AS `p` ON e.id=p.eventid"
- AND e.start > NOW()"
+".$cond
-                        ."\n GROUP BY e.id"
-                        ."\n ORDER BY e.start ASC";