From 493f60e320870df2535759a5f95645323ede1f57 Mon Sep 17 00:00:00 2001 From: prashantsinalkar Date: Mon, 22 May 2017 09:56:37 +0530 Subject: formated th code --- textbook_companion_fixer_edit_book_category.inc | 24 ++++++++++++------------ 1 file 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 .= "
  • $category_list_data->maincategory
    • "; $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( -- cgit