diff options
| author | prashantsinalkar | 2017-05-22 09:56:37 +0530 |
|---|---|---|
| committer | prashantsinalkar | 2019-09-01 22:13:11 +0530 |
| commit | 8b10fa6e0d8108adf26ff5016c7e74d2057e8f5f (patch) | |
| tree | aea8407c4b6cb3fd20315597ab8f5cd8a5817921 | |
| parent | a227f785878fdbf6159b7a05c3ae45d055c46d39 (diff) | |
| download | r_tbc_fixer-8b10fa6e0d8108adf26ff5016c7e74d2057e8f5f.tar.gz r_tbc_fixer-8b10fa6e0d8108adf26ff5016c7e74d2057e8f5f.tar.bz2 r_tbc_fixer-8b10fa6e0d8108adf26ff5016c7e74d2057e8f5f.zip | |
formated th code
| -rw-r--r-- | textbook_companion_fixer_edit_book_category.inc | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/textbook_companion_fixer_edit_book_category.inc b/textbook_companion_fixer_edit_book_category.inc index a4c421e..9c534a5 100644 --- a/textbook_companion_fixer_edit_book_category.inc +++ b/textbook_companion_fixer_edit_book_category.inc @@ -2,7 +2,7 @@ function textbook_companion_fixer_edit_book_proposal_all() { //get the book count - $result = db_query("SELECT COUNT( pe.book ) AS book_count 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 AND pe.category>0"); + $result = db_query("SELECT COUNT( pe.book ) AS book_count 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 AND pe.category>0"); $row = $result->fetchObject(); $book_count = $row->book_count; $i = 1; @@ -153,7 +153,7 @@ function textbook_companion_fixer_edit_book_category_ajax($item, $key) } //$_POST['action'] == "add" elseif ($_POST['action'] == "delete") { - $query_del1 = "DELETE FROM textbook_companion_book_main_subcategories + $query_del1 = "DELETE FROM {textbook_companion_book_main_subcategories} WHERE pref_id= :pref_id AND main_category= :main_category AND sub_category = :subcategory "; $args_del1 = array( @@ -186,7 +186,7 @@ WHERE pref_id= :pref_id AND main_category= :main_category AND sub_category = :su } //$_POST['action'] == "delete" elseif ($_POST['action'] == "delete-main-with-ub-category") { - $query_del2 = "DELETE FROM textbook_companion_book_main_subcategories + $query_del2 = "DELETE FROM {textbook_companion_book_main_subcategories} WHERE pref_id= :pref_id AND main_category= :main_category "; $args_del2 = array( @@ -269,9 +269,9 @@ function _tbc_fixer_list_of_new_category($pref_id) $category = ""; $main_category_query = " SELECT distinct(maincategory) - FROM list_of_category loc - LEFT JOIN textbook_companion_book_main_subcategories tcbms ON loc.category_id = tcbms.main_category - LEFT JOIN list_of_subcategory los ON los.subcategory_id = tcbms.sub_category + FROM {list_of_category} loc + LEFT JOIN {textbook_companion_book_main_subcategories} tcbms ON loc.category_id = tcbms.main_category + LEFT JOIN {list_of_subcategory} los ON los.subcategory_id = tcbms.sub_category WHERE tcbms.pref_id = :pref_id ORDER BY loc.category_id "; $args = array( @@ -284,9 +284,9 @@ function _tbc_fixer_list_of_new_category($pref_id) $category .= "<li>$category_list_data->maincategory</li>"; $sub_category_query = " SELECT DISTINCT (los.subcategory) - FROM list_of_category loc - LEFT JOIN textbook_companion_book_main_subcategories tcbms ON loc.category_id = tcbms.main_category - LEFT JOIN list_of_subcategory los ON los.subcategory_id = tcbms.sub_category + FROM {list_of_category} loc + LEFT JOIN {textbook_companion_book_main_subcategories} tcbms ON loc.category_id = tcbms.main_category + LEFT JOIN {list_of_subcategory} los ON los.subcategory_id = tcbms.sub_category WHERE tcbms.pref_id = :pref_id and maincategory = :maincategoryvalue "; $sub_args = array( @@ -307,10 +307,10 @@ function _tbc_fixer_list_of_ext_new_category($pref_id, $category_id) $category = ""; $query = " SELECT maincategory, los.subcategory as subcategory - FROM list_of_category loc - LEFT JOIN textbook_companion_book_main_subcategories tcbms + FROM {list_of_category} loc + LEFT JOIN {textbook_companion_book_main_subcategories} tcbms ON loc.category_id = tcbms.main_category - LEFT JOIN list_of_subcategory los ON los.subcategory_id = tcbms.sub_category + LEFT JOIN {list_of_subcategory} los ON los.subcategory_id = tcbms.sub_category WHERE tcbms.pref_id = :pref_id AND loc.category_id = :category_id "; $args = array( |