diff options
| author | prashantsinalkar | 2017-05-09 11:48:17 +0530 |
|---|---|---|
| committer | prashantsinalkar | 2017-05-09 11:48:17 +0530 |
| commit | 110d690d29c4c7ebce78827499f988c1fb5afd01 (patch) | |
| tree | a5cf7751d5251e41a21d94b7437777cadfe493f4 | |
| parent | 0778051b94c35eda0c88fa89a5b3fa6bc6a85f73 (diff) | |
| download | textbook_companion_fixer-110d690d29c4c7ebce78827499f988c1fb5afd01.tar.gz textbook_companion_fixer-110d690d29c4c7ebce78827499f988c1fb5afd01.tar.bz2 textbook_companion_fixer-110d690d29c4c7ebce78827499f988c1fb5afd01.zip | |
fixed book count
| -rw-r--r-- | textbook_companion_fixer_edit_book_category.inc | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/textbook_companion_fixer_edit_book_category.inc b/textbook_companion_fixer_edit_book_category.inc index 8efea2a..9dc7bc3 100644 --- a/textbook_companion_fixer_edit_book_category.inc +++ b/textbook_companion_fixer_edit_book_category.inc @@ -9,7 +9,7 @@ function textbook_companion_fixer_edit_book_proposal_all() /* get preference */ $preference_q = db_query("SELECT pe.id as pref_id, pe.book as book, pe.author as author,pe.category as existing_category, pe.publisher as publisher, pe.year as year, pe.id as pe_id, po.approval_date as approval_date FROM {textbook_companion_preference} pe LEFT JOIN {textbook_companion_proposal} po ON pe.proposal_id = po.id - WHERE po.proposal_status = 3 AND pe.approval_status = 1 ORDER BY pe.book ASC"); + WHERE po.proposal_status = 3 AND pe.approval_status = 1 AND pe.category>0 ORDER BY pe.book ASC"); while ($preference_data = $preference_q->fetchObject()) { $proposal_rows[] = array( |