"Non-aicte books", "page callback" => "tbc_comments_all", "access arguments" => array("tbc comments"), "type" => MENU_NORMAL_ITEM ); $items["comments/ajax"] = array( "page callback" => "tbc_comments_ajax", "access callback" => TRUE, "type" => MENU_CALLBACK ); $items["comments/books/ajax"] = array( "page callback" => "tbc_comments_books_ajax", "access callback" => TRUE, "type" => MENU_CALLBACK ); $items["comments/books/all/ajax"] = array( "page callback" => "tbc_comments_books_all_ajax", "access callback" => TRUE, "type" => MENU_CALLBACK ); return $items; } function tbc_comments_init() { drupal_add_css(drupal_get_path("module", "tbc_comments") . "/css/tbc_comments_styles.css"); drupal_add_css(drupal_get_path("module", "tbc_comments") . "/css/tbc_comments.css"); drupal_add_js(drupal_get_path("module", "tbc_comments") . "/js/tbc_comment_ajax.js"); drupal_add_js(drupal_get_path("module", "tbc_comments") . "/js/jquery-1.4.1.min.js"); drupal_add_js(drupal_get_path("module", "tbc_comments") . "/js/jquery-1.2.6.min.js"); } function tbc_comments_perm() { return array( "tbc comments", ); } function tbc_comments_all($type, $id, $count){ $page_content = ""; $page_content .= "test"; $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 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.book ASC "); $res=$query; $countProduct=mysql_num_rows($res); $page_content .= $countProduct; $page_content .= "
"; $base_url = $GLOBALS['base_url']. '/sites/all/modules/tbc_comments/image/'; // $preference_q = 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 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.book ASC" ); $page_content .= "
    "; while ($preference_datas = db_fetch_object($res)) { $page_content .= "
  1. "; $page_content .= $preference_datas->book . " by " . $preference_datas->author . ", " . $preference_datas->publisher . ", " . $preference_datas->year. $preference_datas->pLike; $page_content .= "
    2. "; } $page_content .= "
"; // $page_content .= "
"; $base_url = $GLOBALS['base_url']. '/sites/all/modules/tbc_comments/image/'; if($countProduct > 0 ){ while ($preference_data = db_fetch_object($preference_q)) { $comment_query = db_query(" SELECT * FROM tbc_comments WHERE post_id = %d ORDER BY id DESC LIMIT 15 ", $preference_data->pe_id); $page_content .= ""; $page_content .= "
"; $page_content .= "
".$preference_data->book.$preference_data->pe_id.$preference_data->pLike."
"; $page_content .= "
".$preference_data->pLike."
"; $page_content .= "
".$preference_data->pDislike."
"; $page_content .= "comments"; $page_content .= "commentss
"; $page_content .= ""; // $page_content .= "
"; $page_content .= "
"; } }else{ $page_content .= "Data Not Found"; } $page_content .= "
"; // $page_content .= drupal_get_form("tbc_comments_book_form"); return $page_content; } function tbc_comments_ajax($type, $id, $count) { $data = ""; $type=$_POST['type']; $id=$_POST['id']; if($type=='like'){ $fieldName='pLike'; }elseif($type=='dislike'){ $fieldName='pDislike'; }else{ //die(); } $query= " update textbook_companion_preference set $fieldName=$fieldName+1 where id= %d "; $res= db_query($query, $id); $query= "select $fieldName from textbook_companion_preference where id= %d"; $res= db_query($query, $id); $result= db_fetch_array($res); //result= mysql_fetch_array($res); $count= $result[$fieldName]; $data = $count; echo $data; exit(); } // function tbc_comments_book_form(){ // $form = array(); // $form["name"] = array( // "#type" => "textfield", // "#title" => "Name", // "#description" => t("Please enter your name."), // ); // $form["email"] = array( // "#type" => "textfield", // "#title" => "Email", // "#description" => t("Please enter your valid email id."), // ); // $form["number"] = array( // "#type" => "textfield", // "#title" => "Number", // "#description" => t("Please enter your valid phone number."), // ); // $form["book"] = array( // "#type" => "select", // "#title" => "AICTE Book", // "#description" => t("Please select a book."), // "#options" => $books // ); // $form["comment"] = array( // "#type" => "textarea", // "#title" => "Any other comment?", // "#description" => t("Please enter your query (if any)") // ); // $form["submit"] = array( // "#type" => "submit", // "#value" => "Submit" // ); // return $form; // } // function tbc_comments_books_form(){ // $form = array(); // $form["name"] = array( // "#type" => "textfield", // "#title" => "Your Name", // "#description" => t("Please enter your name."), // "#size" => '50', // ); // $form["email"] = array( // "#type" => "textfield", // "#title" => "Your Email", // "#description" => t("Please enter your valid email id."), // "#size" => '50', // ); // $form["url"] = array( // '#type' => 'hidden', // "#title" => "Url", // "#description" => t("Please enter your valid phone number."), // '#attributes' => array('style'=>'font-weight: bold'), // ); // $form["body"] = array( // "#type" => "textarea", // "#title" => "Any other comment?", // "#description" => t("Please enter your query (if any)") // ); // $form["submit"] = array( // "#type" => "submit", // "#value" => "Submit", // ); // return $form; //} // // function tbc_comments_books_form_submit(){ // $v = $form_state["values"]; // $query = " // INSERT INTO tbc_comments // (name, email, url, body) // VALUES // ('%s', '%s', '%s', '%s') // "; // $result = db_query($query, // $v["name"], $v["email"], $v["url"], $v["body"] // ); // drupal_set_message("Thank you for comment.", "status"); // } // function tbc_comments_books_ajax($name,$mail,$comment,$id) { $base_url = $GLOBALS['base_url']. '/sites/all/modules/tbc_comments/image/'; $data = ""; if (!empty($_POST['name']) AND !empty($_POST['mail']) AND !empty($_POST['comment']) AND !empty($_POST['postid'])) { $name = mysql_real_escape_string($_POST['name']); $mail = mysql_real_escape_string($_POST['mail']); $comment = mysql_real_escape_string($_POST['comment']); $postId = mysql_real_escape_string($_POST['postid']); mysql_query("INSERT INTO tbc_comments (name, mail, comment, post_id) VALUES('{$name}', '{$mail}', '{$comment}', '{$postId}')"); } $data .= "
"; $data .= "
"; $data .= "avatar"; $data .= "
"; $data .= "
"; $data .= "

". $name ." said....

"; $data .= "

". $comment."

"; $data .= "
"; echo $data; exit(); // } function tbc_comments_books_all_ajax($id) { $data = ""; $base_url = $GLOBALS['base_url']. '/sites/all/modules/tbc_comments/image/'; $comment_query = db_query(" SELECT * FROM tbc_comments WHERE post_id = %s ORDER BY id DESC "); // $comment_result = db_query($comment_query, ); $data .= "

Comments.....

"; $data .= "
"; while ($comments_data = db_fetch_object($comment_query,$id)) { $data .= "
"; $data .= "
"; $data .= "avatar"; $data .= "
"; $data .= "
"; $data .= "

".$comments_data->name."said....

"; $data .= "

".$comments_data->comment."

"; $data .= "
"; } $data .= "
"; echo $data; exit(); // } ?>