*/ include("session.php"); if(file_exists($_SESSION['config']['lang'].'.php')) { include($_SESSION['config']['lang'].'.php'); } else { $_SESSION['error'] = "Language file missing...
"; } ?> <?php echo $_SESSION['config']['applicationname']; ?> > connect(); $db2 = new dbquery(); $db2->connect(); $couleur=0; if(empty($_SESSION['tablechoice'])) { $_SESSION['tablechoice'] = 'res_x'; } if(isset($_GET['id'])) { $s_id = $_GET['id']; } else { $s_id = ""; } $db->query("select i.ID, i.INFO, i.DATE, i.USER_ID, u.LASTNAME, u.FIRSTNAME from ".$_SESSION['tablename']['notes']." i inner join ".$_SESSION['tablename']['users']." u on i.USER_ID = u.USER_ID WHERE RECORD_ID = ".$s_id." AND ((i.ACCESS_SERVICES = 'all' AND i.ACCESS_USERS = 'all') OR (i.ACCESS_USERS = 'not' AND i.ACCESS_SERVICES LIKE '%".$_SESSION['user']['department']."%') OR (i.ACCESS_SERVICES = 'not' AND i.ACCESS_USERS LIKE '%".$_SESSION['user']['UserId']."%') OR (i.USER_ID ='".$_SESSION['user']['UserId']."')) ORDER BY DATE desc"); //$db->show(); //print_r($_SESSION['user']['[UserId']); ?> fetch_object()) { if($color == ' class="col"') { $color = ''; } else { $color = ' class="col"'; } ?> > USER_ID == $_SESSION['user']['UserId']) { if($_SESSION['config']['private_notes'] == "true") { $windowSize = '500, 700'; } else{ $windowSize = '500, 250'; } ?>
 
dateformat($res->DATE); ?> FIRSTNAME." ".$res->LASTNAME." "; ?> show($res->INFO)), 0, 40).'... > '._READ.''; ?>   '));" >