header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: no-cache, must-revalidate");
header("Pragma: no-cache");
extract($_POST); extract($_GET); extract($_COOKIE);
if (!$what) { $what=1; }
$title[1]="Semestrální projekty - Semestral Projects";
$typ[1]="FLOOR(MOD(Typ,8) / 4)";
$title[2]="Semestrální práce - Semestral Theses";
$typ[2]="FLOOR(Typ / 8)";
$title[3]="Diplomové práce - Diploma Theses";
$typ[3]="MOD(Typ,2)";
$title[4]="Diplomové práce - Diploma Theses";
$typ[4]="MOD(Typ,2)";
$title[5]="Bakalářské práce - Batchelor Theses";
$typ[5]="FLOOR(((MOD(MOD(Typ,8),4))) / 2)";
/* SELECT command is composed from: $select1 $typ[$what] $select2 */
$select1="SELECT ID_temata,Tema, v1.first_name AS f1,v1.last_name AS l1,v1.title1 AS t11,v1.title2 AS t12,v2.first_name AS f2,v2.last_name AS l2,v2.title1 AS t21,v2.title2 AS t22 FROM Prace AS p LEFT JOIN sk5et9ci AS v1 ON (p.Vedouci1=v1.id) LEFT JOIN sk5et9ci AS v2 ON (p.Vedouci2=v2.id) Where Skupina='CMP' AND ";
$select2="AND (v1.last_name LIKE '%Svoboda%' OR v1.last_name LIKE '%Doubek%' OR v1.last_name LIKE '%Zimmermann%' OR v1.last_name LIKE '%Vlček%') ORDER BY Vedouci1,Tema";
$select=$select1.$typ[$what].$select2;
/*
$select[1]="SELECT * FROM SP Where Skupina='CMP' AND (Vedouci LIKE '%Svoboda%' OR Vedouci LIKE '%Doubek%' OR Vedouci LIKE '%Zimmermann%' OR Vedouci LIKE '%Vlček%' AND Vedouci NOT LIKE '%Matas%') AND TYPE = '2' ORDER BY Vedouci,Datum_vypsani";
$select[2]="SELECT * FROM SP WHERE Skupina='CMP' AND (Vedouci LIKE '%Svoboda%' OR Vedouci LIKE '%Doubek%' OR Vedouci LIKE '%Zimmermann%' OR Vedouci LIKE '%Vlček%' AND Vedouci NOT LIKE '%Matas%') AND TYPE='1' ORDER BY Vedouci, Datum_vypsani ";
$select[3]="SELECT * FROM Okruhy WHERE Skupina='CMP' AND (Vedouci LIKE '%Svoboda%' OR Vedouci LIKE '%Doubek%' OR Vedouci LIKE '%Zimmermann%' OR Vedouci LIKE '%Vlček%' AND Vedouci NOT LIKE '%Matas%') ORDER BY Vedouci,Datum_vypsani";
$select[4]="SELECT * FROM Temata WHERE Skupina='CMP' AND (Vedouci LIKE '%Svoboda%' OR Vedouci LIKE '%Doubek%' OR Vedouci LIKE '%Zimmermann%' OR Vedouci LIKE '%Vlček%' AND Vedouci NOT LIKE '%Matas%') ORDER BY Vedouci,Datum_vypsani";
$select[5]="SELECT * FROM BP WHERE Skupina='CMP' AND (Vedouci LIKE '%Svoboda%' OR Vedouci LIKE '%Doubek%' OR Vedouci LIKE '%Zimmermann%' OR Vedouci LIKE '%Vlček%' AND Vedouci NOT LIKE '%Matas%') ORDER BY Vedouci,Datum_vypsani";
$select[6]="SELECT * FROM Okruhy, Temata WHERE (Okruhy.Skupina='CMP' OR Temata.Skupina='CMP')";
*/
?>
Semestral Projects, Batchelor and Diploma Theses at CMP
echo $title[$what] ?>
if ($what==1){print "Semestrální projekty, 33SP
\n";}
if ($what==2){print "Semestrální práce, 33SEM
\n";}
if ($what==3){print "Tématické okruhy, 33DP
\n";}
if ($what==4){print "Rámcová témata, 33DP
\n";}
if ($what==5){print "Bakaláské projekty, 33BP
\n";}
?>
$sqlserver = "cyber.felk.cvut.cz";
$dbname="elf94ek";
$sqluser = "k333_user";
$sqlpassword = "2435";
$sql = mysql_connect($sqlserver,$sqluser,$sqlpassword);
mysql_select_db($dbname);
$result=mysql_query($select);
$rows = mysql_num_rows($result);
if ($rows) {
print "\n";
while ($row=mysql_fetch_array($result)) {
if ($row[l1]) {
$vedouci="$row[f1] $row[l1]";
if ($row[l2]) $vedouci.=", $row[f2] $row[l2]";
} else {
$vedouci=$row[Vedouci];
}
$vedouci=mb_convert_encoding($vedouci,"ISO-8859-2","UTF-8");
$nazev=mb_convert_encoding($row[Tema],"ISO-8859-2","UTF-8");
print "$vedouci | ";
print "$nazev |
\n";
}
print "
";
/*
} else {
while ($row=mysql_fetch_array($result)) {
$popis=ereg_replace("\n","
",$row[Popis]);
$pokyny=ereg_replace("\n","
",$row[Pokyny]);
print "\n\n";
print "Název: | $row[Tema] | \n";
print "
---|
Vedoucí: | $row[Vedouci] | \n";
if ($what>3) { print "
---|
Oponent: | $row[Oponent] | \n";}
print "
---|
Popis: | $popis | \n";
if ($what>3) {print "
---|
Pokyny k vypracování: | $pokyny | \n";
print "
---|
Doporučená literatura: | $row[Literatura] | \n";
print "
---|
Forma realizace: | $row[Realizace] | \n";
}
print "
---|
Datum vypsání: | $row[Datum_vypsani] | \n";
print "
---|
\n";
}
print "\n";
}*/
} else {
print "Database is empty\n";
}
mysql_free_result($result);
mysql_close($sql);
?>