if (!is_numeric($_GET["group"])) die("");
include("header.php");
if ($_GET["lang"] == "cz") {
?>
Publikace
$rok = 0;
$i=0;
/*$ceitec = "";
if (($_GET[group] == 31) OR ($_GET[group] == 32)) $ceitec = "AND skupina = ".$_GET[group];
$result=mysqli_query($conection,"SELECT publikace. * FROM publikace
WHERE
(
autor1 IN (SELECT id FROM zamestnanec WHERE skupina LIKE '%*$_GET[group]*%' )
OR autor2 IN (SELECT id FROM zamestnanec WHERE skupina LIKE '%*$_GET[group]*%')
OR autor3 IN (SELECT id FROM zamestnanec WHERE skupina LIKE '%*$_GET[group]*%')
)
AND
(
(
projekt IN (SELECT id FROM projekty WHERE skupina = $_GET[group] )
OR projekt2 IN (SELECT id FROM projekty WHERE skupina = $_GET[group] )
OR projekt3 IN (SELECT id FROM projekty WHERE skupina = $_GET[group] )
)
OR (projekt = 179 AND projekt2 = 179 AND projekt3 = 179 $ceitec)
)
ORDER BY rok DESC, autor1") or die(mysqli_error());*/
$result=mysqli_query($conection,"SELECT publikace.*, zamestnanec.prijmeni_bd AS prijmeni FROM publikace LEFT JOIN zamestnanec ON ( zamestnanec.id = publikace.autor1 ) WHERE publikace.skupina LIKE '%*$_GET[group]*%' ORDER BY rok DESC, prijmeni") or die(mysqli_error());
while ($row=mysqli_fetch_array($result))
{
if ($rok != $row["rok"]) {
if ($_GET["show"] != "all") {
if ($i==2) break;
}
?>
$rok = $row["rok"];
$i++;
}
?>
}
if ($_GET["show"] != "all") {?>
}?>
}
else {
?>
Publications
/*
$result=mysqli_query($conection,"SELECT publikace. * FROM publikace
WHERE autor1 IN (SELECT id FROM zamestnanec WHERE skupina LIKE '%*$_GET[group]*%')
OR autor2 IN (SELECT id FROM zamestnanec WHERE skupina LIKE '%*$_GET[group]*%')
OR autor3 IN (SELECT id FROM zamestnanec WHERE skupina LIKE '%*$_GET[group]*%')
ORDER BY rok DESC, autor1") or die(mysqli_error());
*/
$rok = 0;
$i=0;
/*if (($_GET[group] == 31) OR ($_GET[group] == 32)) $ceitec = "AND skupina = ".$_GET[group];
$result=mysqli_query($conection,"SELECT publikace. * FROM publikace
WHERE
(
autor1 IN (SELECT id FROM zamestnanec WHERE skupina LIKE '%*$_GET[group]*%')
OR autor2 IN (SELECT id FROM zamestnanec WHERE skupina LIKE '%*$_GET[group]*%')
OR autor3 IN (SELECT id FROM zamestnanec WHERE skupina LIKE '%*$_GET[group]*%')
)
AND
(
(
projekt IN (SELECT id FROM projekty WHERE skupina = $_GET[group] )
OR projekt2 IN (SELECT id FROM projekty WHERE skupina = $_GET[group] )
OR projekt3 IN (SELECT id FROM projekty WHERE skupina = $_GET[group] )
)
OR (projekt = 179 AND projekt2 = 179 AND projekt3 = 179 $ceitec)
)
ORDER BY rok DESC, autor1") or die(mysqli_error());*/
$result=mysqli_query($conection,"SELECT publikace.*, zamestnanec.prijmeni_bd AS prijmeni FROM publikace LEFT JOIN zamestnanec ON ( zamestnanec.id = publikace.autor1 ) WHERE publikace.skupina LIKE '%*$_GET[group]*%' ORDER BY rok DESC, prijmeni") or die(mysqli_error());
while ($row=mysqli_fetch_array($result))
{
if ($rok != $row["rok"]) {
if ($_GET["show"] != "all") {
if ($i==2) break;
}
?>
$rok = $row["rok"];
$i++;
}
?>
}
if ($_GET["show"] != "all") {?>
}?>
}
include("footer.php");
?>