--- html/obavijest.php 2000/09/04 13:52:14 1.16 +++ html/obavijest.php 2002/01/25 14:47:46 1.21 @@ -4,6 +4,9 @@ include("inc/prava.inc"); include("inc/print_bool2.inc"); include("inc/bgcolor.inc"); +include("inc/show_bool.inc"); +include("inc/auth_pop3.inc"); +include("inc/sap_org_jed.inc"); if (isset($kontakt_osoba_id) && $what!="relogin") { $result = pg_Exec ($conn, "select ime,prezime,passwd,prava from kontakt_osobe where aktivna=true and id=$kontakt_osoba_id"); @@ -38,14 +41,12 @@ $result = pg_Exec ($conn, " select osobe.id as id,ime,prezime,tel,lokacije.naziv as lok,sifra, - org_jed.naziv as orgjed,org_pod_jed.pod_naziv as orgpodjed, lok_racunala as lokrac,objekt,kat,soba,z_rac,podesavanje, umrezavanje,shell from osobe where osobe.id=$id - and lokacija_id=lokacije.id and org_jed_id=org_jed.id - and org_pod_jed_id=org_pod_jed.pod_id - order by lokacije.naziv,org_jed.naziv + and lokacija_id=lokacije.id + order by lokacije.naziv "); if (pg_numrows($result) > 0) { @@ -59,10 +60,9 @@
Nema podataka o korisničkom računu"; } - +$server=3; $result = pg_Exec ($conn, "select racuni.login as login, - racuni.passwd as passwd,e_mail.alias as email - where racuni.osoba_id=$id and e_mail.osoba_id=$id"); + racuni.passwd as passwd,e_mail.alias as email, + racuni.id as racuni_id + where racuni.osoba_id=$id and e_mail.osoba_id=$id + and racuni.server_id=$server"); if (pg_numrows($result) > 0) { $row=pg_fetch_array($result,0); @@ -118,11 +140,44 @@ print "