function get_messages($tl_id = NULL) { //if the user is an admin, return only messages from other admins if (check_app_admin($_SESSION['user_id'])) { $sql = "SELECT message,fname,lname,users.user_id FROM messages NATURAL JOIN users WHERE user_id in (SELECT user_id FROM app_admin)"; $result = $_SESSION['dbconn']->query($sql) or die("Error retrieving messages: " . $_SESSION['dbconn']->error); return $result; } else { if (!isset($tl_id)) { $tl_id = get_team_leader($_SESSION['user_id']); } $sql = "SELECT message,fname,lname,users.user_id FROM messages NATURAL JOIN users WHERE tl_id=" . $tl_id; $result = $_SESSION['dbconn']->query($sql) or die("Error retrieving messages: " . $_SESSION['dbconn']->error); return $result; } }
function draw_message_box() { $messages = get_messages(); while ($message = $messages->fetch_array()){ ?><div class="mssg_text"><b> <?php echo '<div class='; if ($message['user_id']==$_SESSION['user_id']) echo 'mssg-self'; else if ($message['user_id']==get_team_leader()) echo 'mssg-tl'; echo '>'; echo ucfirst($message['fname']).' '; echo ucfirst($message['lname']); echo '</div>'; ?></b> <?php echo '<BR>'.$message['message']; echo '<BR></div><P>'; } }