';
$data .= '';
while($row = mysql_fetch_object($result)) {
if($example_id == $row->id) $selected = "selected"; else $selected="";
$data .= "';
$chapter_id = $row->chapter_id;
}
$data .= '';
$data .= ' Download Example';
$elements["examples"] = $data;
/* retreving chapters */
$query = "
SELECT id, name, number, preference_id FROM textbook_companion_chapter
WHERE cloud_chapter_err_status=0 AND preference_id = (
SELECT preference_id FROM textbook_companion_chapter WHERE id = {$chapter_id}
)
ORDER BY number ASC
";
$result = mysql_query($query);
$data = '';
$data .= ' Download Chapter';
$elements["chapters"] = $data;
/* retreving books*/
$query = "
SELECT pre.id, pre.book, author, category FROM textbook_companion_preference pre
WHERE pre.approval_status=1 AND pre.category = (
SELECT category FROM textbook_companion_preference WHERE id = {$preference_id}
) AND cloud_pref_err_status=0 and pre.proposal_id IN (
SELECT id from textbook_companion_proposal where proposal_status=3
) ORDER BY pre.book ASC
";
$result = mysql_query($query);
$data = '';
$data .= ' Download Book';
$elements["books"] = $data;
$elements["category"] = $category_id;
/* retreving cloud_comments */
$query = "
SELECT id FROM scilab_cloud_comment WHERE example = {$example_id}
";
$result = mysql_query($query);
$elements["nos"] = mysql_num_rows($result);
/* retreving contributor details */
$book_id = $preference_id;
$output = "";
$query = "select * from textbook_companion_preference where id = {$book_id}";
$result = mysql_query($query);
$preference =mysql_fetch_array($result);
$query = "select * from textbook_companion_proposal where id = {$preference['proposal_id']}";
$result = mysql_query($query);
$proposal = mysql_fetch_array($result);
$output .= "Contributor: {$proposal['full_name']}
";
$output .= "Mentor: {$proposal['faculty']}
";
$output .= "Book Reviewer: {$proposal['reviewer']}
";
$output .= "College Name: {$proposal['university']}
";
$elements["contrib"] = $output;
return $elements;
}
?>