displayTop(5,0,"","",1);
?>
Patroni
mysql_server,$classpage->mysql_login,$classpage->mysql_pass);
@ $vyberdb = mysql_select_db($classpage->mysql_db);
$query_patroni = "SELECT id,
dpmz_patroni.jmeno as patron,
dpmz_patroni.email as patron_email,
dpmz_patroni.foto as patron_foto, dpmz_patroni.fotowidth as patron_fotowidth, dpmz_patroni.fotoheight as patron_fotoheight,
dpmz_patroni.pocetpatronu as pocetpatronu
FROM dpmz_patroni WHERE aktivni < 2";
if($get_patroni = mysql_query($query_patroni)) {
if( ($number_patroni = mysql_num_rows($get_patroni)) && ($number_patroni > 0) ) {
for($i = 0; $i < $number_patroni; $i++) {
$row = mysql_fetch_array($get_patroni);
$id = $row["id"];
$patron = $row["patron"];
$patron_email = $row["patron_email"];
$patron_foto = $row["patron_foto"];
$patron_fotowidth = $row["patron_fotowidth"];
$patron_fotoheight = $row["patron_fotoheight"];
$pocetpatronu = $row["pocetpatronu"];
echo "\n";
echo "
";
if(!($patron_foto == "")) echo "
![\"\"](\"images/patroni/".$patron_foto."_thumb.jpg\")
";
echo "
\n";
echo "
\n";
echo "
".$patron."
\n";
echo "
\n";
if(!($patron_email == "")) echo "| E-mail: | ".$patron_email." |
\n";
// podporovane organizace
$query_organizace = "SELECT nazev, uname
FROM dpmz_organizace, dpmz_patroni_organizace
WHERE dpmz_organizace.aktivni < 2
AND dpmz_patroni_organizace.patronid = ".$id."
AND dpmz_organizace.id = dpmz_patroni_organizace.orgid";
if($get_organizace = mysql_query($query_organizace)) {
if( ($number_organizace = mysql_num_rows($get_organizace)) && ($number_organizace > 0) ) {
echo "| Podporovan";
if($number_organizace < 2) echo "á";
else echo "é";
echo " organizace: | ";
for($o = 0; $o < $number_organizace; $o++) {
$row_org = mysql_fetch_array($get_organizace);
$nazev_org = $row_org["nazev"];
$uname_org = $row_org["uname"];
if($o > 0) echo "
\n";
echo "".$nazev_org."";
} // end for
echo " |
\n";
} // end number
} // end org res
echo "
\n";
echo "
\n";
echo "
\n";
echo "
Žádný patron.
\n";
} // end patroni res
else echo "Momentálně nemohu zobrazit přehled patronů. [GET id]
\n";
@ mysql_query($query_log);
$classpage -> displayBottom(); ?> ![\"\"](\"/images/patroni/".$patron_foto.".jpg\")
";
echo "