[opw-web] When listing contract approvals, show them only for the right program

[Owen Taylor <otaylor src gnome org>]

commit ab0e0de7f97b180f38dc8f80b0a93e75ddbbda2c
Author: Owen W. Taylor <otaylor fishsoup net>
Date:   Tue Nov 25 21:32:23 2014 -0500

    When listing contract approvals, show them only for the right program
    
    When a participant was accepted for one program, we'd show contract
    submission for programs where they were NOT accepted as well.

 modules/mod_user_profile.php |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)
---
diff --git a/modules/mod_user_profile.php b/modules/mod_user_profile.php
index 6ae3b9f..5e0f3ff 100644
--- a/modules/mod_user_profile.php
+++ b/modules/mod_user_profile.php
@@ -135,7 +135,7 @@ if ($action == 'view') {
                    "AND EXISTS (SELECT * from {$db->prefix}participants prt " .
                                "LEFT JOIN {$db->prefix}projects prj " .
                                "ON prt.project_id = prj.id " .
-                               "WHERE prt.username = r.username AND prj.is_accepted = 1) " .
+                               "WHERE prt.program_id = prg.id AND prt.username = r.username AND 
prj.is_accepted = 1) " .
                    "ORDER BY prg.id DESC";
             $program_data = $db->query($sql, $username);