include "../include/siteaccess.phtml";
$pagetitle = "Search Results";
$pageheadline = $pagetitle;
include "../e136header.phtml";
include "../e136funcs.php";
$now = time();
mysql_connect("localhost","wwwpublic","");
mysql_select_db("e136");
if (strlen($s)):
/* $s = msql_regcase($s); */
$rule = " where ( publication.autor like '%$s%' or publication.title like '%$s%' ) ";
endif;
if (isset($ao) && $ao==1):
$rule = addAnd($rule, "publication.aodot=1");
endif;
if (isset($peer) && $peer=="J"):
$rule = addAnd($rule, "publication.peer='J'");
endif;
if (isset($j) && $j==1):
$rule = addAnd($rule, "publication.jahr=$jahr");
endif;
if (isset($j) && $j==2):
$rule = addAnd($rule, "publication.studjahr=$jahr");
endif;
$selects = "publication.id,publication.autor,publication.firstname,publication.title,publication.type,publication.jahr,publication.peer,publication.aodot,publication.url,publication.label";
$from = "publication";
if ($db==1):
$rule = addAnd($rule, "publication.type<>'V' and publication.type<>'D'");
endif;
if ($db==2):
$rule = addAnd($rule, "publication.type='J'");
endif;
if ($db==3):
$rule = addAnd($rule, "publication.type='B'");
endif;
if ($db==4):
$rule = addAnd($rule, "publication.type='V'");
/* $rule = addAnd($rule, "vortrag.ausland=0");
$rule = addAnd($rule, "publication.id=vortrag.id");
$from = "publication,vortrag"; */
endif;
if ($db==5):
$rule = addAnd($rule, "publication.type='V'");
$rule = addAnd($rule, "vortrag.beitrag=1");
$rule = addAnd($rule, "publication.id=vortrag.id");
$from = "publication,vortrag";
endif;
if ($db==6):
$rule = addAnd($rule, "publication.type='V'");
$rule = addAnd($rule, "vortrag.beitrag=2");
$rule = addAnd($rule, "publication.id=vortrag.id");
$from = "publication,vortrag";
endif;
if ($db==7):
$rule = addAnd($rule, "publication.type='V'");
$rule = addAnd($rule, "vortrag.beitrag=3");
$rule = addAnd($rule, "publication.id=vortrag.id");
$from = "publication,vortrag";
endif;
if ($db==8):
$rule = addAnd($rule, "publication.type='D'");
$rule = addAnd($rule, "diplom.diplom='Master'");
$rule = addAnd($rule, "publication.id=diplom.id");
$from = "publication,diplom";
endif;
if ($db==9):
$rule = addAnd($rule, "publication.type='D'");
$rule = addAnd($rule, "diplom.diplom='PhD'");
$rule = addAnd($rule, "publication.id=diplom.id");
$from = "publication,diplom";
endif;
$o = "publication.firstname,publication.title";
#echo "SELECT $selects FROM $from $rule ORDER BY $o";
$result = mysql_query("SELECT $selects FROM $from $rule ORDER BY $o");
$nhit = mysql_num_rows($result);
if ($l==1):
# $tmpfile=tempnam("/tmp","db");
$tmpfile="/tmp/db_$REMOTE_HOST";
$fm = fopen($tmpfile,"w");
echo "
Results are also written in LaTeX style to file:
";
echo "file://tph.tuwien.ac.at/tmp/mysql2latex.txt
";
endif;
$i=0;
echo "";
while ($i<$nhit): ?>
- [ echo $i+1?>]
if ($siteaccess): ?>
&db=publication">
endif?>
echo mysql_result($result,$i,"publication.autor")?>
if ($siteaccess): echo ""; endif?>
-
if (mysql_result($result,$i,"publication.url")!="NULL"): ?>
">
echo mysql_result($result,$i,"publication.title")?>
else: ?>
echo mysql_result($result,$i,"publication.title")?>
endif?>
if ($l==1):
$label=mysql_result($result,$i,"publication.label");
$autor=mysql_result($result,$i,"publication.autor");
$autor=reg_latex($autor);
fputs($fm, "\\item ");
if ($label=="NULL"):
fputs($fm, " ");
else:
fputs($fm, "\\label{$label} ");
endif;
fputs($fm, " $autor \\\\ \n");
endif;
/* if ($f=="l"); */
$art = mysql_result($result,$i,"publication.type");
$code = mysql_result($result,$i,"publication.id");
if ($art=="J"):
$subresult=mysql_query("select id,journal,volume,seitevon,seitebis from journal where id=$code");
endif;
if ($art=="B"):
$subresult=mysql_query("select id,booktit,editor,verlag,ort,seitevon,seitebis from book where id=$code");
endif;
if ($art=="V"):
$subresult=mysql_query("select id,konferenz,ort,land,tag,monat from vortrag where id=$code");
endif;
if ($art=="D"):
$subresult=mysql_query("select betreuer,diplom,tag,monat from diplom where id=$code");
endif;
$subnhit = mysql_num_rows($subresult);
if ($subnhit==0):
echo "There is no matching entry!!!";
endif?>
if ($art=="J"): ?>
echo mysql_result($subresult,0,"journal")?>,
echo mysql_result($subresult,0,"volume")?>,
echo mysql_result($subresult,0,"seitevon")?>-
echo mysql_result($subresult,0,"seitebis")?>,
( echo mysql_result($result,$i,"publication.jahr")?>)
if ($f=="l"): ?>
Type: Journal /
ao.Dot = echo mysql_result($result,$i,"publication.aodot")?> /
Peer Review = echo mysql_result($result,$i,"publication.peer")?>.
if ($l==1):
$title = mysql_result($result,$i,"publication.title");
$journal = mysql_result($subresult,0,"journal");
$volume = mysql_result($subresult,0,"volume");
$seitevon = mysql_result($subresult,0,"seitevon");
$seitebis = mysql_result($subresult,0,"seitebis");
$jahr = mysql_result($result,$i,"publication.jahr");
$title=reg_latex($title);
$journal=reg_latex($journal);
fputs($fm, " {\\it $title} \\\\ \n");
fputs($fm, " $journal {\\bf $volume}, $seitevon-$seitebis ($jahr) \n\n");
endif?>
endif?>
endif?>
if ($art=="B"): ?>
" echo mysql_result($subresult,0,"booktit")?>",
echo mysql_result($subresult,0,"editor")?>,
echo mysql_result($subresult,0,"verlag")?>,
echo mysql_result($subresult,0,"ort")?>
echo mysql_result($result,$i,"publication.jahr")?>,
p. echo mysql_result($subresult,0,"seitevon")?>-
p. echo mysql_result($subresult,0,"seitebis")?>
if ($f=="l"): ?>
Type: Buchbeitrag /
ao.Dot = echo mysql_result($result,$i,"publication.aodot")?> /
Peer Review = echo mysql_result($result,$i,"publication.peer")?>.
if ($l==1):
$title = mysql_result($result,$i,"publication.title");
$booktit = mysql_result($subresult,0,"booktit");
$editor = mysql_result($subresult,0,"editor");
$verlag = mysql_result($subresult,0,"verlag");
$ort = mysql_result($subresult,0,"ort");
$jahr = mysql_result($result,$i,"publication.jahr");
$seitevon = mysql_result($subresult,0,"seitevon");
$seitebis = mysql_result($subresult,0,"seitebis");
$title = reg_latex($title);
$booktit = reg_latex($booktit);
$editor = reg_latex($editor);
$verlag = reg_latex($verlag);
$ort = reg_latex($ort);
fputs($fm, " {\\it $title} \\\\ \n");
fputs($fm, " in {\\it $booktit}, \n");
fputs($fm, " ed. by $editor ($verlag, $ort $jahr), pp. $seitevon-$seitebis \n\n");
endif?>
endif?>
endif?>
if ($art=="V"): ?>
echo mysql_result($subresult,0,"konferenz")?>,
echo mysql_result($subresult,0,"ort")?>,
echo mysql_result($subresult,0,"land")?>,
echo mysql_result($subresult,0,"tag")?>.
echo mysql_result($subresult,0,"monat")?>
echo mysql_result($result,$i,"publication.jahr")?>.
if ($f=="l"): ?>
Type: Vortrag /
ao.Dot = echo mysql_result($result,$i,"publication.aodot")?>
if ($l==1):
$title = mysql_result($result,$i,"publication.title");
$konferenz = mysql_result($subresult,0,"konferenz");
$ort = mysql_result($subresult,0,"ort");
$land = mysql_result($subresult,0,"land");
$jahr = mysql_result($result,$i,"publication.jahr");
$tag = mysql_result($subresult,0,"tag");
$mmonat = mysql_result($subresult,0,"monat");
if ($mmonat=="JAN"): $monat=1; endif;
if ($mmonat=="FEB"): $monat=2; endif;
if ($mmonat=="MAR"): $monat=3; endif;
if ($mmonat=="APR"): $monat=4; endif;
if ($mmonat=="MAY"): $monat=5; endif;
if ($mmonat=="JUN"): $monat=6; endif;
if ($mmonat=="JUL"): $monat=7; endif;
if ($mmonat=="AUG"): $monat=8; endif;
if ($mmonat=="SEP"): $monat=9; endif;
if ($mmonat=="OCT"): $monat=10; endif;
if ($mmonat=="NOV"): $monat=11; endif;
if ($mmonat=="DEC"): $monat=12; endif;
$title = reg_latex($title);
$konferenz = reg_latex($konferenz);
$ort = reg_latex($ort);
$land = reg_latex($land);
fputs($fm, " {\\it $title} \\\\ \n");
fputs($fm, " $konferenz, $ort, ($land) \\\\ \n");
fputs($fm, " $tag.$monat.$jahr \n\n");
endif?>
endif?>
endif?>
if ($art=="D"): ?>
Betreuer: echo mysql_result($subresult,0,"betreuer")?>
echo mysql_result($subresult,0,"tag")?>.
echo mysql_result($subresult,0,"monat")?>
echo mysql_result($result,$i,"publication.jahr")?>
if ($f=="l"): ?>
Type:
if (mysql_result($subresult,0,"diplom")=="Master"): ?>
Diplomarbeit
else: ?>
Dissertation
endif?>
if ($l==1):
$title = mysql_result($result,$i,"publication.title");
$betreuer = mysql_result($subresult,0,"betreuer");
$jahr = mysql_result($result,$i,"publication.jahr");
$tag = mysql_result($subresult,0,"tag");
$mmonat = mysql_result($subresult,0,"monat");
if ($mmonat=="JAN"): $monat=1; endif;
if ($mmonat=="FEB"): $monat=2; endif;
if ($mmonat=="MAR"): $monat=3; endif;
if ($mmonat=="APR"): $monat=4; endif;
if ($mmonat=="MAY"): $monat=5; endif;
if ($mmonat=="JUN"): $monat=6; endif;
if ($mmonat=="JUL"): $monat=7; endif;
if ($mmonat=="AUG"): $monat=8; endif;
if ($mmonat=="SEP"): $monat=9; endif;
if ($mmonat=="OCT"): $monat=10; endif;
if ($mmonat=="NOV"): $monat=11; endif;
if ($mmonat=="DEC"): $monat=12; endif;
$betreuer = reg_latex($betreuer);
$title = reg_latex($title);
fputs($fm, " Betreuer: $betreuer \\\\ \n");
fputs($fm, " {\\it $title} \\\\ \n");
if (mysql_result($subresult,0,"diplom")=="Master"):
fputs($fm, " 2.Diplompr\\\"ufung: ");
else:
fputs($fm, " Rigorosum: ");
endif;
fputs($fm, " $tag.$monat.$jahr \n\n");
endif?>
endif?>
endif?>
if ($f=="l"):
echo " / ";
if (mysql_result($result,$i,"publication.label")=="NULL"):
echo "Kein Label!";
else:
echo "Label: ";
echo mysql_result($result,$i,"publication.label");
endif;
endif;
/* endif; */
echo "";
$i++;
endwhile?>
if ($l==1):
fclose($fm);
exec("cp $tmpfile /tmp/mysql2latex.txt");
unlink($tmpfile);
endif?>
include "../e136footer.phtml"?>
exit?>