<?php
	function _list_all_certificates()
	{
		global $user;
                $uid1 = $user->uid;

                $query2 = db_query("SELECT * FROM {textbook_companion_proposal} WHERE proposal_status=3 AND uid=".$user->uid);
                $data2 = db_fetch_object($query2);
                if($data2->id)
                {
                        $search_rows = array();
                        global $output;
			$output = '';
                        $query3 = db_query("SELECT * FROM textbook_companion_preference WHERE approval_status=1 AND proposal_id=".$data2->id);

                        while ($search_data3 = db_fetch_object($query3))
                        {
  $search_rows[] = array($search_data3->isbn,$search_data3->book,$search_data3->author,l('Download Certificate', 'certificate/generate_pdf/'.$search_data3->id));
                        }
                        if ($search_rows)
                        {
                                $search_header = array('ISBN', 'Book Name', 'Author', 'Download Certificates');
                                $output = theme_table($search_header, $search_rows);
				return $output;
                        }
                        else
                        {
                                echo("Error");
				return '';
                        }
                }
                else
                {
                        $query3 = db_query("SELECT * FROM {textbook_companion_proposal} WHERE uid=".$user->uid);
	                $data3 = db_fetch_object($query2);
			var_dump($query3);
			die;
			if($data3)
			{
				drupal_set_message('<strong>Your book is still under Review!</strong>', 'status');	
				return '';
			}
			else
			{
				drupal_set_message('<strong>You need to propose a book <a href="/proposal">Book Proposal</a></strong>', 'status');
				return '';
			}
                }

}               
?>