[opw-web] Fix fullnames in participants list

[Owen Taylor <otaylor src gnome org>]

commit 9b0a6c48b9d8624c1a37c17f4fa62084d9b4a1dd
Author: Owen W. Taylor <otaylor fishsoup net>
Date:   Fri Apr 4 11:12:52 2014 -0400

    Fix fullnames in participants list

 modules/mod_view_participants.php |    4 ++--
 1 files changed, 2 insertions(+), 2 deletions(-)
---
diff --git a/modules/mod_view_participants.php b/modules/mod_view_participants.php
index 910f85b..5e6068b 100644
--- a/modules/mod_view_participants.php
+++ b/modules/mod_view_participants.php
@@ -15,13 +15,13 @@ $sql = "SELECT r.username, r.role AS role, " .
        "pr.id AS project_id, pr.title AS project_title, " .
        "pf.fullname " .
        "FROM {$db->prefix}roles r " .
+       "LEFT JOIN {$db->prefix}profiles pf " .
+       "ON r.username = pf.username ".
        "LEFT JOIN {$db->prefix}participants p " .
        "ON r.program_id = p.program_id " .
        "AND r.username = p.username " .
        "LEFT JOIN {$db->prefix}projects pr " .
        "ON p.project_id = pr.id ".
-       "LEFT JOIN {$db->prefix}profiles pf " .
-       "ON p.username = pf.username ".
        "WHERE r.program_id = {$program_id} " .
        "ORDER BY r.role, r.username";
 $list_data = $db->query($sql);