diff options
| author | prashantsinalkar | 2017-05-09 11:48:17 +0530 |
|---|---|---|
| committer | prashantsinalkar | 2019-09-01 22:13:10 +0530 |
| commit | cd93bb9cfce5d1bb3ed2cf9d04ebcace6851cd70 (patch) | |
| tree | 55411fbb3b7e5806896357c366edbd50254048da | |
| parent | c8b0bd4ef8f3eb26d006fcd792ce628ac0b5f14b (diff) | |
| download | r_tbc_fixer-cd93bb9cfce5d1bb3ed2cf9d04ebcace6851cd70.tar.gz r_tbc_fixer-cd93bb9cfce5d1bb3ed2cf9d04ebcace6851cd70.tar.bz2 r_tbc_fixer-cd93bb9cfce5d1bb3ed2cf9d04ebcace6851cd70.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( |