function displaySystemMessages()
{
//shows system messages, but only if they exist
$querystatement = "\n SELECT\n notes.id,\n notes.subject,\n notes.content,\n concat(users.firstname,' ',users.lastname) AS createdby,\n notes.creationdate\n FROM\n notes INNER JOIN users ON notes.createdby=users.id\n WHERE\n type='SM'\n ORDER BY\n importance DESC,\n notes.creationdate";
$queryresult = $this->db->query($querystatement);
if ($this->db->numRows($queryresult)) {
?>
<div class="box" id="systemMessageContainer">
<h2>System Messages</h2>
<?php
while ($therecord = $this->db->fetchArray($queryresult)) {
$therecord["content"] = str_replace("\n", "<br />", htmlQuotes($therecord["content"]));
?>
<h3 class="systemMessageLinks"><?php
echo htmlQuotes($therecord["subject"]);
?>
<span>[ <?php
echo htmlQuotes(formatFromSQLDateTime($therecord["creationdate"]));
?>
<?php
echo htmlQuotes($therecord["createdby"]);
?>
]</span></h3>
<div class="systemMessages">
<p><?php
echo $therecord["content"];
?>
</p>
</div>
<?php
}
//end while
?>
</div>
<?php
}
//endif
}
</p>
</fieldset>
<fieldset>
<legend>log in</legend>
<p class="big"><?php
$theform->showField("login");
?>
</p>
<p>
<label for="lastlogin" >last log in</label><br />
<input id="lastlogin" name="lastlogin" type="text" value="<?php
echo formatFromSQLDateTime($therecord["lastlogin"]);
?>
" size="32" maxlength="64" readonly="readonly" class="uneditable" />
</p>
<p><?php
$theform->showField("lastip");
?>
</p>
<p>
<label for="password">set new password</label><br />
<input id="password" name="password" type="password" size="32" maxlength="32" />
</p>
<p>
