36 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
36 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> |
37 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> |
37 <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> |
38 |
38 |
39 <head> |
39 <head> |
40 <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> |
40 <meta http-equiv="content-type" content="text/html; charset=iso-8859-1" /> |
41 <link href="http://achilleus.rz-berlin.mpg.de/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/> |
41 <link href="/fhiiqm/css/db.css" rel="STYLESHEET" type="TEXT/CSS" media="screen"/> |
42 <link href="http://achilleus.rz-berlin.mpg.de/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/> |
42 <link href="/fhiiqm/css/db_print.css" rel="STYLESHEET" type="TEXT/CSS" media="print"/> |
43 |
43 |
44 <title>MA/O-Telefonliste</title> |
44 <title>MA/O-Telefonliste</title> |
45 </head> |
45 </head> |
46 |
46 |
47 <body onload="document.ffilter.filter.focus();"> |
47 <body onload="document.ffilter.filter.focus();"> |
109 $sql = "SELECT persknr, name, vorname, titel, abt_name, ag, telefon_nr, telefon_typ, public, sort, geb_ID, raum_nr, email, aktiv FROM v_tel_list_ag |
109 $sql = "SELECT persknr, name, vorname, titel, abt_name, ag, telefon_nr, telefon_typ, public, sort, geb_ID, raum_nr, email, aktiv FROM v_tel_list_ag |
110 WHERE 1=1"; |
110 WHERE 1=1"; |
111 else |
111 else |
112 // $sql = "SELECT persknr, name, vorname, titel, abt_name, telefon_nr, telefon_typ, public, sort, geb_ID, raum_nr, email, aktiv FROM v_tel_list_ma_raum"; |
112 // $sql = "SELECT persknr, name, vorname, titel, abt_name, telefon_nr, telefon_typ, public, sort, geb_ID, raum_nr, email, aktiv FROM v_tel_list_ma_raum"; |
113 $sql = "SELECT persknr, name, vorname, titel, abt_name, ag, telefon_nr, telefon_typ, public, sort, geb_ID, raum_nr, email, aktiv |
113 $sql = "SELECT persknr, name, vorname, titel, abt_name, ag, telefon_nr, telefon_typ, public, sort, geb_ID, raum_nr, email, aktiv |
114 FROM v_tel_list_ag WHERE aktiv > 0"; |
114 FROM v_tel_list_ag WHERE ABS(aktiv) > 0"; |
115 if ($filter) |
115 if ($filter) |
116 { |
116 { |
117 if ($fnum > 3) |
117 if ($fnum > 3) |
118 $wher = " AND " . $fieldf[$fnum] . " LIKE " . "'%$filter%'"; |
118 $wher = " AND " . $fieldf[$fnum] . " LIKE " . "'%$filter%'"; |
119 else |
119 else |
121 } |
121 } |
122 else $wher = ""; |
122 else $wher = ""; |
123 // intern/extern |
123 // intern/extern |
124 $ip=getenv("REMOTE_ADDR"); |
124 $ip=getenv("REMOTE_ADDR"); |
125 $ippart=explode(".",$ip); |
125 $ippart=explode(".",$ip); |
126 if (($ippart[0] == 141 && $ippart[1] == 14) || ($ippart[0] == 172 && $ippart[1] == 16)) |
126 if (($ippart[0] == 141 && $ippart[1] == 14) || ($ippart[0] == 172 && $ippart[1] >= 16 && $ippart[1] <= 31) || ($ippart[0] == 10 && $ippart[1] == 0)) |
127 $wip = ""; |
127 $wip = ""; |
128 else |
128 else |
129 $wip = " AND public=1 "; |
129 $wip = " AND public=1 "; |
130 |
130 |
131 if ($sort == 2) $so = "name COLLATE latin1_general_ci $dir, 1, 3, 5, 6"; |
131 if ($sort == 2) $so = "name COLLATE latin1_general_ci $dir, 1, 3, 5, 6"; |