Mgr. Dana Pánková

[insert_php]
$id=9;$rozvrh=“pankova“;
$sql = mysql_query(„SELECT * FROM ucitele WHERE id=$id ORDER BY prijmeni, jmeno“);
while($row = mysql_fetch_array($sql)){foreach( $row AS $key => $val ){$key = stripslashes( $val );}
$kategorie=$row[‚kategorie‘];
if($kategorie==1) $pozice=“učitel 1. stupně“;
if($kategorie==2) $pozice=“učitel 2. stupně“;
$trida=$row[‚trida‘];
if($trida<>„—-„){
$trida_url= strtolower(iconv(‚UTF-8‘, ‚ASCII//TRANSLIT‘, $trida));
$trida_url= str_replace(‚ ‚, ‚-‚, trim($trida_url));
$trida_url= str_replace(‚.‘, “, trim($trida_url));
$trida_url=“$trida„;
}
else $trida_url=$trida;
$prijmeni=$row[‚prijmeni‘];
$zastupujici=$row[‚zastupujici‘];
$funkce=$row[‚funkce‘];
$telefon=$row[‚telefon‘];
$skype=$row[‚skype‘];
if($skype<>„“) {
$telefon_skype=“telefon / skype“;
$url=“http://mystatus.skype.com/$skype.num“;
$ch = curl_init();
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_URL, $url);
$skype_status=curl_exec($ch);
curl_close($ch);
if($skype_status==“2″) $skype_link=“„;
if($skype_status==“3″) $skype_link=“„;
if($skype_status==“5“) $skype_link=‘‚;
if($skype_status==“1″) $skype_link=‘‚;
}
else $telefon_skype=“telefon“;
$konzultace=$row[‚konzultace‘];
$mail=$row[‚mail‘];
$patro=$row[‚kabinet_patro‘];
$dvere=$row[‚kabinet_dvere‘];
if($patro==0) $kabinet=“přízemí“;
if($patro>0) $kabinet=“$patro. patro“;
if($dvere>0) $kabinet=$kabinet.“, č. dv. $dvere“;
}
if($zastupujici>0) {
$sql = mysql_query(„SELECT * FROM ucitele WHERE id=’$zastupujici'“);
while($row = mysql_fetch_array($sql)){foreach( $row AS $key => $val ){$key = stripslashes( $val );}
$titulz=$row[‚titul‘];
$jmenoz=$row[‚jmeno‘];
$prijmeniz=$row[‚prijmeni‘];
$cele_jmenoz=$titulz.“ „.$jmenoz.“ „.$prijmeniz;
$urlz=$row[‚url‘];
if($urlz<>„“) $vloz_urlz=“$cele_jmenoz„; else $vloz_urlz=“$cele_jmenoz“;
}
}
if($vloz_urlz==““) $vloz_urlz=“—-„;
[/insert_php]