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>