Hi again, Here i am just finished updating the events page for Mccodes version 2!
Extremely simple stuff...
Screenshots:
events.php:<?php
include_once(DIRNAME(__FILE__) . '/globals.php');
echo "<h3>Your Events</h3><h4>Below are your 10 latest events/notifications involving yourself!</h4><br />";
$_GET['delete'] = abs((int) $_GET['delete']);
if ($_GET['delete']) {
$db->query("DELETE FROM events WHERE evID={$_GET['delete']} AND evUSER=$userid");
echo "<b>Success:</b> You have deleted your selected event.<br /><br />
<a href='index.php'>Home</a> | <a href='events.php'>Back</a>";
$h->endpage();
exit;
}
$q = $db->query("SELECT * FROM events WHERE evUSER=$userid ORDER BY evTIME DESC LIMIT 10;");
echo "<table width='85%' class='table' cellspacing='1'><tr><th width='25%'>Information</th><th>Event</th></tr>";
while ($r = $db->fetch_row($q)) {
echo "<tr><td><small> " . date('l, d M Y H:i:s', $r['evTIME']);
if (!$r['evREAD']) {
echo "<b>!</b>";
}
echo "<br />[<a href='events.php?delete={$r['evID']}'>Delete</a>]</small></td><td>{$r['evTEXT']}</td></tr>";
}
echo "</table>";
if ($ir['new_events'] > 0) {
$db->query("UPDATE events SET evREAD=1 WHERE evUSER=$userid");
$db->query("UPDATE users SET new_events=0 WHERE userid=$userid");
}
$h->endpage();
?>That's it enjoy!
