diff options
| author | Jayaram Pai | 2014-03-08 18:18:25 +0530 |
|---|---|---|
| committer | Jayaram Pai | 2014-03-08 18:18:25 +0530 |
| commit | 2ef25e3f3714051da18188a6026f4f08bb0ab24b (patch) | |
| tree | 96f2e6c04f20231506e89c644de09ce592e7aae6 /tbc_external_review.module | |
| parent | d93c8345d0c2869fb562b0153612f2728e73b832 (diff) | |
| download | tbc-external-review-2ef25e3f3714051da18188a6026f4f08bb0ab24b.tar.gz tbc-external-review-2ef25e3f3714051da18188a6026f4f08bb0ab24b.tar.bz2 tbc-external-review-2ef25e3f3714051da18188a6026f4f08bb0ab24b.zip | |
fixed manage_comments query
Diffstat (limited to 'tbc_external_review.module')
| -rwxr-xr-x | tbc_external_review.module | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/tbc_external_review.module b/tbc_external_review.module index 33aa738..3d0e745 100755 --- a/tbc_external_review.module +++ b/tbc_external_review.module @@ -933,7 +933,7 @@ } else { /* displaying the list of books */ $query = " - SELECT DISTINCT erc.preference_id, pre.book, pre.author, usr_con.name AS contributor, usr_ext.name AS reviewer, erd.mail + SELECT DISTINCT erc.preference_id, pre.book, pre.author, usr_con.name AS contributor, usr_ext.name AS reviewer, erd.sent FROM external_review_comments erc LEFT JOIN textbook_companion_preference pre ON erc.preference_id = pre.id LEFT JOIN textbook_companion_proposal pro ON pre.proposal_id = pro.id |