<?
/***************************************/
require("setup.php");
$smarty->assign("title","Publications list"); 
$smarty->assign("template","publ.tpl"); 
/***************************************/	
include "publication_db.inc";
publdb_connect($conn); 

//-------- books ------------------------- 
$publ_type = 'book';
$query="SELECT * FROM $publ_type, int_num WHERE int_num.publ_id=$publ_type.id AND int_num.publ_type='$publ_type' ORDER BY year DESC, int_num DESC";
$allresult=mysql_query($query,$conn) or die("Invalid SELECT query");
if(!mysql_num_rows($allresult)) $books = Array();
else {	
	while($allrow=mysql_fetch_assoc($allresult)) {
		unset($authors);
		$query="SELECT name, initial, surname, authornum
				FROM authors, author_id 
				WHERE authors.publ_type='$publ_type' AND authors.publ_id=".$allrow['id']." AND author_id.id=authors.author_id ORDER BY authornum ASC";
		$result=mysql_query($query) or die("Invalid SELECT query");
		while($row=mysql_fetch_assoc($result)) {
			$authors[$row['authornum']] = $row;
		}
		$books[$allrow['int_num']] = $allrow;
		$books[$allrow['int_num']]['authors'] = $authors;
	}
}
//-------- abstracts ---------------------
$publ_type = 'abstract';
$query="SELECT $publ_type.*, int_num.* FROM $publ_type, int_num, conferences WHERE int_num.publ_id=$publ_type.id AND int_num.publ_type='$publ_type' and $publ_type.conference_id=conferences.id ORDER BY YEAR(conferences.startdate) DESC, int_num DESC";
$allresult=mysql_query($query,$conn) or die("Invalid SELECT query");
if(!mysql_num_rows($allresult)) $abstracts = Array();
else {	
	while($allrow=mysql_fetch_assoc($allresult)) {
		unset($authors);
		$query="SELECT name, initial, surname, authornum 
				FROM authors, author_id 
				WHERE authors.publ_type='$publ_type' AND authors.publ_id=".$allrow['id']." AND author_id.id=authors.author_id ORDER BY authornum ASC";
		$result=mysql_query($query) or die("Invalid SELECT query");
		while($row=mysql_fetch_assoc($result)) {
			$authors[$row['authornum']] = $row;
		}
		$query="SELECT * FROM conferences WHERE id=$allrow[conference_id]";
		$confresult=mysql_query($query,$conn) or die("Invalid SELECT query");
		$conference = mysql_fetch_assoc($confresult);

		$abstracts[$allrow['int_num']] = $allrow;
		$abstracts[$allrow['int_num']]['authors'] = $authors;
		$abstracts[$allrow['int_num']]['conference'] = $conference;
	}
}
//-------- articles ----------------------
$publ_type = 'article';
$query="SELECT * FROM $publ_type, int_num WHERE int_num.publ_id=$publ_type.id AND int_num.publ_type='$publ_type' ORDER BY year DESC, int_num DESC";
$allresult=mysql_query($query,$conn) or die("Invalid SELECT query");
if(!mysql_num_rows($allresult)) $articles = Array();
else {	
	while($allrow=mysql_fetch_assoc($allresult)) {
		unset($authors);
		$query="SELECT name, initial, surname, authornum  
				FROM authors, author_id 
				WHERE authors.publ_type='$publ_type' AND authors.publ_id=".$allrow['id']." AND author_id.id=authors.author_id ORDER BY authornum ASC";
		$result=mysql_query($query) or die("Invalid SELECT query");
		while($row=mysql_fetch_assoc($result)) {
			$authors[$row['authornum']] = $row;
		}
		$query="SELECT journal FROM journal_id	WHERE id=$allrow[journal_id]";
		$result=mysql_query($query) or die("Invalid SELECT query");
		$row = mysql_fetch_assoc($result);
		$articles[$allrow['int_num']] = $allrow;
		$articles[$allrow['int_num']]['authors'] = $authors;
		$articles[$allrow['int_num']]['journal'] = $row['journal'];
	}
}	
$smarty->assign('books',$books);
$smarty->assign('abstracts',$abstracts);
$smarty->assign('articles',$articles);

/***************************************/	 
$smarty->display("index.tpl");
/***************************************/
?>