'); if(!($Secus & 4)){ $size = GetImageSize("http://".$_SERVER['SERVER_NAME']."/".$arow["URLBig"]); $width= $size[0]; $height= $size[1]; //print('width='.$width.'Height='.$height); if($width){ print('

'); print(' '.$Vorname.' '.$Nachname.'

'); }else{ print('

'); } } print(" [ zurück ] "); print('

'.$Vorname.' '.$Nachname.'

'); print('

'.$Beschreibung.'

' ); if(($arow["homepage"]!=="") and !($Secus & 64)) { print('

Homepage: '.$arow["homepage"].''.'

'); } if(($arow["email"]!=="") and !($Secus & 32)) { print('

eMail: '.InsMail($arow["email"]).'

'); } if(($arow["TelFest"]!=="") and !($Secus & 8)) { print('

Telefon Festnetz: '.$arow["TelFest"].'

'); } if(($arow["TelFunk"]!=="") and !($Secus & 16)) { print('

Telefon mobil: '.$arow["TelFunk"].'

'); } print('

'); $query = "SELECT * FROM VerPerso WHERE Perso=".$numbr." order by eid desc;"; if(!($arowid = mysql_query($query))) die("error!".mysql_error()); $entriesCount = mysql_num_rows($arowid); // are there any entries? if (($arowid == 0) || (mysql_num_rows($arowid) == 0)) { // print("

keine Einträge

"); }else { print('

Veranstaltungen mit '.$Vorname.' '.$Nachname.' : '); mysql_data_seek($arowid, 0); $nr = 0; while ($nr < $entriesCount ) { if($arow = mysql_fetch_array($arowid)){ $Bquery = "SELECT Veranst . *, Ort.Name AS OName, Ort.Str, Ort.Nr FROM Veranst INNER JOIN Ort ON Ort.eid = Veranst.OrtEid WHERE Veranst.eid = ".$arow["Ver"].";"; $browid = mysql_query($Bquery); if ($browid) { $brow = mysql_fetch_array($browid); if($brow["Hide"] ==0){ print(' '); $Einmal = $brow["Beschr"]; $cquery = "SELECT Personen.eid, Personen.Vorname, Personen.Nachname FROM VerPerso JOIN Personen ON Personen.eid = VerPerso.Perso AND Personen.eid <> ".$numbr." WHERE VerPerso.Ver = ".$arow["Ver"].";"; $crowid = mysql_query($cquery); $centriesCount = mysql_num_rows($crowid); // are there any entries? if (($crowid == 0) || (mysql_num_rows($crowid) == 0)) { // print("

keine Einträge

"); }else { $Einmal = $Einmal."
Auch dabei: "; mysql_data_seek($crowid, 0); $cnr = 0; while ($cnr < $centriesCount ) { if($crow = mysql_fetch_array($crowid)){ $Einmal = $Einmal."".htmlentities($crow["Vorname"],NULL, "")." ".htmlentities($crow["Nachname"],NULL, "")." "; } $cnr++; } } $cquery = "SELECT * FROM Termine WHERE Ver=".$brow["eid"]." order by Von;"; $crowid = mysql_query($cquery); $centriesCount = mysql_num_rows($crowid); // are there any entries? if (($crowid == 0) || (mysql_num_rows($crowid) == 0)) { // print("

keine Einträge

"); }else { mysql_data_seek($crowid, 0); $cnr = 0; while ($cnr < $centriesCount ) { if($crow = mysql_fetch_array($crowid)){ print (' '); $Einmal = ""; } $cnr++; } } } } } $nr++; //print(' //'); } print('


'.$brow["Name"].'	'.$brow["OName"].' ( '.$brow["Str"].' '.$brow["Nr"].' )
'.$Einmal.'	'.TermForm($crow["Von"],$crow["Bis"]).'

'); } $query = "SELECT * FROM FotoPerso WHERE Perso=".$numbr." order by eid desc;"; $arowid = mysql_query($query); $entriesCount = mysql_num_rows($arowid); // are there any entries? if (($arowid == 0) || (mysql_num_rows($arowid) == 0)) { // print("

keine Einträge

"); }else { print('

Bilder von '.$Vorname.' '.$Nachname.' : '); mysql_data_seek($arowid, 0); $nr = 0; while ($nr < $entriesCount ) { if (0) break; if($arow = mysql_fetch_array($arowid)){ $Bquery = "select * from Fotos where eid = ".$arow["Foto"].";"; $browid = mysql_query($Bquery); if ($browid) { $brow = mysql_fetch_array($browid); $JFS = $brow["UrlBig"]; //$JFS = str_replace("upload/Pic/" , "upload/Pic/JFS" , $JFS ); print('

'); print('

'); } } $nr++; } print('

'); } $query = "SELECT * FROM avperso WHERE Perso=".$numbr." order by eid desc;"; $arowid = mysql_query($query); $entriesCount = mysql_num_rows($arowid); // are there any entries? if (($arowid == 0) || (mysql_num_rows($arowid) == 0)) { // print("

keine Einträge

"); }else { print('

Musik und Videos'); mysql_data_seek($arowid, 0); $nr = 0; while ($nr < $entriesCount ) { if (0) break; if($arow = mysql_fetch_array($arowid)){ $Bquery = "select * from media where eid = ".$arow["Media"].";"; $browid = mysql_query($Bquery); if ($browid) { $brow = mysql_fetch_array($browid); if($brow["Hide"] ==0){ print('

'); print(''.$brow["Titel"].'" rev="width: '.($brow["width"] + 55).'px; height: '.($brow["height"] + 64).'; scrolling: no;">

'.$brow["Interpret"].'

'.$brow["Titel"].'
'); }else{ print('http://img.youtube.com/vi/'.$brow["UrlMed"].'/2.jpg'); print('" style="width: 100px; height: 75px; ">
'.$brow["Interpret"].'

'.$brow["Titel"].'
'); } print('

'); } } } $nr++; } print('

'); } } else die("Ooops! Datenbankfehler !"); //print('

'); } /*------------------------ View Personen Entries ------------------------*/ function viewP() { // import global variables global $from, $entriesPerPage, $act, $Kat, $Arc, $Nombre, $scriptname, $entriesCount; // query the database if($Kat==0){ $query = "SELECT * FROM Personen WHERE NOT(Secu & 1) AND (Archiv = $Arc) order by Nachname;";} else{ $query = "SELECT * FROM Personen WHERE (NOT(Secu & 1)) AND (Archiv = $Arc) AND (Funktion & $Kat) order by Nachname;";} $arowid = mysql_query($query); $entriesCount = mysql_num_rows($arowid); //print($mysql_error); //print($query); // are there any entries? if (($arowid == 0) || (mysql_num_rows($arowid) == 0)) { print("

keine Einträge

"); } else { // calculate the entries from and to which we want to view $from = ($from) ? $from : 0; $to = min($from+$entriesPerPage-1, mysql_num_rows($arowid)-1); // Tell visitor which entries he is seeing $d_from = $from+1; $d_to = $to+1; //print("

".$Nombre." Einträge ".($entriesCount-$d_to+1).' - '.($entriesCount-$d_from+1)."

"); /////////////////////// // Next and Last Page Links print('

'.$Nombre.' Eintrag: '); // make sure we can selected newer entries $newfrom=0; while ( $newfrom < $from ) { $newto = min($newfrom+$entriesPerPage-1,$from-1); // print the link $d_newfrom = $newfrom+1; $d_newto = $newto+1; print("[ ".($d_newfrom)." - ".($d_newto)." ] "); $newfrom = $newto+1; } print("[ ".($d_from)." - ".($d_to)." ] "); // are there any older entries? $newto=$to; while ($newto < mysql_num_rows($arowid)-1) { // start and end? $newfrom = $newto+1; $newto = min(mysql_num_rows($arowid), $newfrom+$entriesPerPage)-1; // print the link $d_newfrom = $newfrom+1; $d_newto = $newto+1; print("[ ".($d_newfrom)." - ".($d_newto)." ] "); } print("

"); // Bogus request? This really should not happen - anyway. Don't want php3 errors on screen. if ($from < 0 || $from > mysql_num_rows($arowid)-1) { die('

Fehler

'); } // Seek to the first entry to be viewed mysql_data_seek($arowid, $from); $nr = 0; // read $entriesPerPage entries while ($nr < $entriesPerPage) { // is there such an entry? If not -> out of this loop (Well, this really should not happen... if (!$arow = mysql_fetch_array($arowid)) break; $currentNr = $entriesCount-$from-$nr; // Display entry with data from database viewSingleEntry($arow["Nachname"], $arow["Vorname"], $arow["URLSmall"], $arow["eid"], $arow["Secu"]); $nr++; } print('

'); } } /*------------------------ View Single Entry -------------------*/ function viewSingleEntry($Nachname, $Vorname, $URLSmall, $eid, $Secus) { global $scriptname, $Kat; $Nachname = htmlentities($Nachname,NULL, ""); $Vorname = htmlentities($Vorname,NULL, ""); ///////////////////////if(!($Secus & 2)){ // output data print('

'); if(!($Secus & 2)){ print('

'); } print(''.$Vorname.' '.$Nachname.''); print('

'); } /*------------------------ Open Database ------------------------*/ function openDatabase() { // import global variables global $db_host, $db_user, $db_pass, $db_db; // open database connection and select database mysql_connect($db_host,$db_user,$db_pass) || die("Kein Kontakt zu Datenbank"); mysql_select_db($db_db) || die("Kontakt zu Datenbank, aber Liste nicht da."); } /*------------------------ importVariables ------------------------*/ function importVariables() { global $act, $nextact, $from, $Kat, $Arc, $numbr; if (isset($_GET["act"])) $act = $_GET["act"]; if (isset($_GET["nextact"])) $nextact = $_GET["nextact"]; if (isset($_GET["from"])) $from = intval($_GET["from"]); if (isset($_GET["Kat"])) {$Kat = intval($_GET["Kat"]);} else {$Kat = 0;} if (isset($_GET["Arc"])) {$Arc = intval($_GET["Arc"]);} else {$Arc = 0;} if (isset($_GET["numbr"])) $numbr = intval($_GET["numbr"]); } /*------------------------ init Session ------------------------*/ function initSession() { global $from; if (!isset($_SESSION["act"])) $_SESSION["act"] = ""; if (!isset($_SESSION["nextact"])) $_SESSION["nextact"] = ""; if (!isset($_SESSION["from"])) { $_SESSION["from"] = "0"; } else $from = $_SESSION["from"]; if (!isset($_SESSION["numbr"])) $_SESSION["numbr"] = "0"; } /*------------------------ ------------------------*/ /*------------------------ Main ------------------------*/ /*------------------------ ------------------------*/ global $scriptname, $Funktionen, $Nombre, $Arc; // Start PHP Session; note ini_set("session.use_trans_sid", "1"); session_start(); // Turn off magic quotes set_magic_quotes_runtime(0); require("Jock/ThePage.inc"); require("Jock/php3guestrc.php"); // Get GET, POST, COOKIE Variables; init Session initSession(); importVariables(); $Nombre ="alle"; foreach ($Funktionen as $Key => $Funktiona) { $Po = pow(2,$Key); if($Kat & $Po) $Nombre =$Funktiona; } // Print page header print($pageHeader1); if($Arc ==0) { print($Nombre); } else { print('Archiv'); } print($pageHeader2); if($Arc ==0) { print('

Beteiligte '.$Nombre.'

'); } else { print('

Das Archiv. In den letzten Jahren waren dabei:

'); } print($pageHeader3); $scriptname = "Kuenstl.php"; $entriesPerPage = 18; openDatabase(); switch ($act) { // insert an Person entry case "Single" : Single(); break; // Personen listen default : viewP(); break; } print($pageFooter); $_SESSION["from"]= $from;