Changeset 181

Timestamp:

09/10/07 10:13:50 (2 years ago)

Author:

moensch

Message:

When payment is switched off, script does no longer check if all team members have paid (Fixes bug 1068)

Files:

• trunk/com_mls_tournaments/mls_tournaments.php (modified) (1 diff)

trunk/com_mls_tournaments/mls_tournaments.php

@@ -711 +711 @@
-                //this is a clan tournament, show select list to choose team to register
-                //show only teams of which I am leader
+                if($cnf_mls_tournaments["paid_register"] == 1) {
+                        $paidclause = " AND p.paid='1'";
+                } else {
+                        $paidclause = "";
+                }
+                
-                $database->setQuery( "SELECT t.*,COUNT(m.id) AS `members`,COUNT(IF(m.userid='".$my->id."',1,NULL)) AS `myclan`, COUNT(IF(m.leader='1' AND m.userid='".$my->id."',1,NULL)) AS `leader` FROM `#__mls_teams` AS `t`"
-                                                ."\n INNER JOIN `#__mls_teams_members` AS `m` ON m.teamid=t.id"
-                                                ."\n INNER JOIN `#__mls_events_participants` AS `p` ON p.userid=m.userid"
- AND p.paid='1'"
+".$paidclause
-                                                ."\n GROUP BY t.id" );
-                $teams = $database->loadObjectList();