Location: PHPKode > projects > NOLA > start.php
<? require_once('includes/main.php'); ?>
<?
        if (!MESSAGING_INSTANT_ON) { //if we check for messages on every page load anyhow, we don't need to check here
                $recordSet = &$conn->Execute("select count(*) from genmessage where readdate='0001-01-01 00:00:00' and userid=".sqlprep($userid));
                if (!$recordSet->EOF) if ($recordSet->fields[0]) {
                        echo '<center><table border="1"><tr><th colspan="3"><font size="+1">'.$recordSet->fields[0].'</font> new messages in your inbox.</th></tr><tr><th>Sender</th><th>Sent</th><th>Preview</th></tr>';
                        $recordSet2 = &$conn->Execute("select genuser.name, genmessage.entrydate, substring(genmessage.message from 1 for 30) as message, genmessage.id from genmessage,genuser where genuser.id=genmessage.sourceuserid and genmessage.readdate='0001-01-01 00:00:00' and genmessage.userid=".sqlprep($userid));
                        while (!$recordSet2->EOF) {
                                echo '<tr><td>'.$recordSet2->fields[0].'</td><td>'.$recordSet2->fields[1].'</td><td><a href="genmessage.php?messageid='.$recordSet2->fields[3].'">'.$recordSet2->fields[2].'</a></td></tr>';
                                $recordSet2->MoveNext();
                        };
                        echo '</table></center><br>';
                };
        };
        echo '<br>'.dynimagerollover('nolaabout.php', 'About This Software', 13, 'TAHOMA.TTF');
?>
<? require_once('includes/footer.php'); ?>
Return current item: NOLA