"; echo ""; echo ""; echo ""; while($row=mysql_fetch_array($query)) { echo ""; echo ""; } //echo ""; echo ""; echo "
Select the authors of the publication: ".$papertitle."
"; echo utf8_decode($row["surname"]); echo ", "; echo utf8_decode($row["name"]); echo "
"; } ?> ".$row2["number"].""; } $query2=mysql_query('select MAX(priority) as maxprior from publications'); $row2 = mysql_fetch_array($query2); $maxprior = (int)$row2["maxprior"]+10; $peopleoptions=createPeopleOptions(-1); echo ""; echo ""; /* echo "
"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
"; echo ""; echo "title:
"; echo "type:"; echo $typeoptions; echo "status:"; echo $statusoptions; echo "priority:"; echo "
journal:volume:number:year:pages:
conference:location:
supervisor:".$peopleoptions."date:
"; echo "msc-class:arxiv: link:"; echo "
"; echo "project:"; echo "
start date: end date:"; echo "type:"; echo "
"; */ while($row=mysql_fetch_array($query)) { $id=$row["id"]; $supportid=$row["supportid"]; //$sqlstring="select id, surname, name from people where id in (select authorid from peopub where pubid=$id)"; //$query2=mysql_query($sqlstring); //$row2=mysql_fetch_array($query2); //$query3=mysql_query("select id, projectid, pubid from projpub where pubid=$id"); if($edit!=$row["id"]) { //echo ""; echo ""; } else { //echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $query3=mysql_query("select number from projects where id = $supportid"); $row3=mysql_fetch_array($query3); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
"; echo ""; echo ""; echo "
"; echo ""; echo ""; echo "
title:".utf8_decode($row["title"])."
"; echo "type:".LookupNameByID("pubtypes", "title", $row["typeid"])."status:".LookupNameByID("pubstatus", "title", $row["statusid"])."priority:".$row["priority"].""; echo ""; echo ""; echo ""; echo "
journal:".utf8_decode($row["journal"])."volume:".$row["volume"]."number:".$row["number"]."year:".$row["year"]."pages:".$row["pages"]."
conference:".utf8_decode($row["conference"])."location:".utf8_decode($row["location"])."
supervisor:"; $svid=$row["svid"]; if($svid!=0) echo LookupPeopleByID($svid); echo "date:".$row["pubdate"]."
"; echo "msc-class:".$row["msc"]."arxiv:".$row["arxiv"]."link:".$row["link"].""; echo ""; echo "
"; echo "file:"; echo "
"; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
"; echo "project:".$row3["number"].""; echo ""; echo ""; echo "
"; echo "authors:"; echo ""; echo "
"; echo ""; echo ""; $authorlist=""; $authorcount=0; $query3=mysql_query("select id, surname, name from people where id in (select authorid from peopub where pubid=".$row["id"].") order by surname"); while($row3=mysql_fetch_array($query3)) { $authorcount++; $authorlist.=utf8_decode($row3["surname"]).", ".utf8_decode($row3["name"]{0}).".; "; } echo $authorlist; echo ""; echo "
"; echo "
"; echo ""; echo ""; echo ""; echo "
"; echo ""; } } echo "
"; echo "
"; echo ""; echo ""; echo ""; echo ""; ////////////////////////////////// echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $query3=mysql_query('select id, number from projects where enddate > CURRENT_DATE() order by startdate DESC, number'); $optionpane=""; $projcount=0; while($row3=mysql_fetch_array($query3)) { $projcount++; $optionpane.=""; echo ""; echo ""; echo ""; echo ""; echo "
"; echo ""; echo ""; echo "title:
type:"; echo createOptionsByTable("typeid", "pubtypes", "title", $row["typeid"]); echo "status:"; echo createOptionsByTable("statusid", "pubstatus", "title", $row["statusid"]); echo "priority:"; echo ""; echo ""; echo ""; echo "
journal:volume:number:year:pages:
conference:location:
supervisor:".createPeopleOptions($row["svid"])."date:
"; echo "msc-class:arxiv:link:"; echo ""; echo "
"; echo "project:"; echo ""; echo ""; echo "
"; echo "
"; echo "
"; echo "authors:"; echo ""; echo ""; echo ""; $authorlist=""; $authorcount=0; $query3=mysql_query("select id, surname, name from people where id in (select authorid from peopub where pubid=".$row["id"].") order by surname"); while($row3=mysql_fetch_array($query3)) { $authorcount++; $authorlist.=utf8_decode($row3["surname"]).", ".utf8_decode($row3["name"]{0}).".; "; } echo $authorlist; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
"; } ?> "; echo ""; echo ""; echo ""; while($row=mysql_fetch_array($query)) { echo ""; echo ""; } echo ""; echo ""; echo "
Select the members for project ".$projectnumber.":
"; echo utf8_decode($row["surname"]); echo ", "; echo utf8_decode($row["name"]); echo "
"; } ?> "; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo "
"; echo "
"; echo ""; echo ""; echo "number:project title:
start date: end date:"; echo "type:
link:"; echo ""; echo "
final report:"; echo ""; echo "
"; while($row=mysql_fetch_array($query)) { $id=$row["id"]; $leaderid=$row["leaderid"]; $sqlstring="select surname, name from people where people.id = $leaderid"; $query2=mysql_query($sqlstring); $row2=mysql_fetch_array($query2); $leadername=utf8_decode($row2["name"]); $leadersurname=utf8_decode($row2["surname"]); if($edit!=$row["id"]) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $sqlstring="select id, name, surname from people where people.id in (select projpeo.memberid from projpeo where projpeo.projectid=$id) order by surname"; $query2=mysql_query($sqlstring); echo ""; $ind=0; echo ""; } echo "
"; echo ""; echo ""; echo "
"; echo ""; echo ""; echo "number:"; echo utf8_decode($row["number"]);echo "project title:"; echo utf8_decode($row["title"]); echo "
start date:"; echo utf8_decode($row["startdate"]); echo "end date:"; echo utf8_decode($row["enddate"]); echo "type:"; echo utf8_decode($row["type"]); echo "
link:"; echo utf8_decode($row["link"]); echo "
final report:"; echo utf8_decode($row["finalreport"]); echo "
project leader:"; echo $leadersurname; echo ", "; echo $leadername{0}; echo ".
members:"; while($row2=mysql_fetch_array($query2)) { if($ind==0) { } else { echo "
"; } $ind++; echo utf8_decode($row2["surname"]); echo ", "; echo utf8_decode($row2["name"]{0}); echo "."; echo "
"; } else { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; $sqlstring="select id, name, surname from people where people.id in (select projpeo.memberid from projpeo where projpeo.projectid=$id) order by surname"; $query2=mysql_query($sqlstring); echo ""; } echo ""; echo "$memberlist"; echo "
"; echo ""; echo ""; echo ""; echo "number:project title:
start date:end date: type:"; echo ""; echo "
link:"; echo ""; echo "
final report:"; echo ""; echo "
project leader:"; $ind=0; $memberlist=""; $optionlist=""; $memberlist.="
"; $memberlist .= ""; $memberlist .= ""; $memberlist .= ""; $memberlist .= ""; while($row2=mysql_fetch_array($query2) ) { $optionlist .= ""; if($ind==0) { //$memberlist.="members:"; } else { $memberlist.="
"; $memberlist.=""; } $ind++; $memberlist.= utf8_decode($row2["surname"]); $memberlist.= ", "; $memberlist.= utf8_decode($row2["name"]{0}); $memberlist.= "."; $memberlist.= "

"; } } echo ""; } ?> "; if($selectedid==-1) { $peopleoptions.="