function loadMessage($n, &$message) { $message = new message(); $query = "SELECT * FROM ss_tickets ORDER BY tic_date DESC"; $result = mysql_query($query); $num = mysql_numrows($result); if ($num >= $n) { $message->subject = mysql_result($result, $n, "tic_subject"); $message->message = mysql_result($result, $n, "tic_message"); $message->from = loadUsername(mysql_result($result, $n, "tic_usr_id")); } //mark message as read //$query = "UPDATE ss_messages SET msg_read = 1 WHERE msg_usr_id = '".$userID."' "; //$query .= "AND msg_subject = '".$message->subject."' AND msg_message = '".$message->message."'"; //mysql_query($query); }
} updateRequestFlag($_POST["request_id"], $flag); header('Location: admin.php'); } $pageTitle = "View Request"; //$javascript = "calendar.js"; require 'includes/adminHeader.php'; $reqID = $HTTP_GET_VARS["req"]; $request = loadRequest($reqID); ?> <table style="margin:16px"> <tr> <td>From</td> <td><?php echo loadUsername($request->from); ?> </td> </tr> <tr> <td>Type</td> <td><?php echo intToType($request->type); ?> </td> </tr> <tr> <td>Start</td> <td><?php echo $request->dateStart; ?>
<img src="images/xmark.gif.png" /> <?php } } } ?> <input type="hidden" id="request<?php echo $i; ?> " name="request<?php echo $i; ?> " /> </td> <td><?php echo loadUsername($requests[$i]->from); ?> </td> <td><?php echo intToType($requests[$i]->type); ?> </td> <td><?php echo $requests[$i]->dateStart; ?> </td> <td style="border-right:solid 1px #CDDEEE;"><?php echo $requests[$i]->dateEnd; ?> </td> </tr>