From 3e70a2b85b7bf96f037327cf3d4e0e8f886ff584 Mon Sep 17 00:00:00 2001 From: prashant Date: Tue, 24 Feb 2015 11:35:58 +0530 Subject: added references non aicte comment interface --- tbc_comments.module | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/tbc_comments.module b/tbc_comments.module index 768e0fd..7183536 100755 --- a/tbc_comments.module +++ b/tbc_comments.module @@ -47,7 +47,7 @@ $page_content .= ""; $query= db_query(" - SELECT pe.book as book, pe.author as author, pe.publisher as publisher, pe.year as year, pe.id as pe_id, pe.pLike, pe.pDislike, po.approval_date as approval_date, po.reason + SELECT pe.book as book, pe.author as author, pe.publisher as publisher, pe.year as year, pe.id as pe_id, pe.pLike, pe.pDislike, po.approval_date as approval_date, po.reason, po.reference FROM {textbook_companion_preference} pe LEFT JOIN {textbook_companion_proposal} po ON pe.proposal_id = po.id WHERE po.proposal_status = 0 AND pe.approval_status = 0 AND po.proposal_type = 1 ORDER BY pe.id DESC "); @@ -65,7 +65,7 @@ $page_content .= "