Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
BCE Home cover_files	[ DIR ]	drwxr-sr-x	2012-03-12 06:07
BCE Introduction_files	[ DIR ]	drwxr-sr-x	2012-03-12 06:07
BCE RESOURCE AND SUPPORT_files	[ DIR ]	drwxr-sr-x	2012-03-12 06:08
BCE RULES AND REGULATIONS_files	[ DIR ]	drwxr-sr-x	2012-03-12 06:07
BCE THE LEARNING PROGRAMME_files	[ DIR ]	drwxr-sr-x	2012-03-12 06:08
SpryAssets	[ DIR ]	drwxr-sr-x	2013-02-14 22:54
ajax	[ DIR ]	drwxr-sr-x	2026-08-20 14:43
assignments	[ DIR ]	drwxr-sr-x	2022-03-07 13:03
docthumbs	[ DIR ]	drwxr-sr-x	2022-03-14 09:40
facilitators	[ DIR ]	drwxr-sr-x	2012-01-18 08:00
guidelines	[ DIR ]	drwxr-sr-x	2021-04-29 08:34
images	[ DIR ]	drwxr-sr-x	2023-04-18 07:54
includes	[ DIR ]	drwxr-sr-x	2024-02-23 09:41
lightbox	[ DIR ]	drwxr-sr-x	2012-07-02 08:44
pdf	[ DIR ]	drwxr-sr-x	2012-03-15 12:53
pdf-viewer	[ DIR ]	drwxr-sr-x	2025-02-20 13:18
visual-countdown-timer	[ DIR ]	drwxr-sr-x	2021-11-03 09:27
activities.php	6.49 KB	-rw-r--r--	2024-02-23 09:36
activityadd.php	7.44 KB	-rw-r--r--	2024-02-23 09:36
advisory.php	1.37 KB	-rw-r--r--	2024-02-23 09:36
assignmentadd.php	43.1 KB	-rw-r--r--	2026-08-19 12:45
assignmentinfo.php	2.96 KB	-rw-r--r--	2025-02-24 16:01
assignmentpack.php	4.66 KB	-rw-r--r--	2024-02-23 09:36
assignmentpdf.php	3.64 KB	-rw-r--r--	2024-02-23 09:36
assignments.php	14.04 KB	-rw-r--r--	2026-06-24 12:03
assigsummary.php	12.25 KB	-rw-r--r--	2025-04-14 08:46
calendar.js	13.28 KB	-rw-r--r--	2024-02-23 09:36
calendar.php	502 B	-rw-r--r--	2024-02-23 09:47
cceregister.php	22.5 KB	-rw-r--r--	2013-10-09 08:40
changedates.php	1.35 KB	-rw-r--r--	2024-02-23 09:36
contacts.php	4.87 KB	-rw-r--r--	2025-06-26 12:42
contacts_students.php	2.34 KB	-rw-r--r--	2024-02-27 11:36
details.php	9.24 KB	-rw-r--r--	2025-02-06 10:38
document-pdf-proxy.php	1.95 KB	-rw-r--r--	2025-06-27 10:14
document-view.php	7.35 KB	-rw-r--r--	2025-06-27 12:42
download_student_agreement.php	1.71 KB	-rw-r--r--	2026-03-16 11:53
evaluations.php	6.85 KB	-rw-r--r--	2024-02-23 09:36
exam.php	47.02 KB	-rw-r--r--	2026-08-25 07:11
examresults.php	3.01 KB	-rw-r--r--	2026-02-17 09:45
extension.php	11.33 KB	-rw-r--r--	2026-08-19 12:45
feedback.php	3.91 KB	-rw-r--r--	2024-02-23 09:36
feedbackmsgs.php	5.04 KB	-rw-r--r--	2024-03-25 10:07
file-download.php	343 B	-rw-r--r--	2026-06-24 12:03
forgotpwd.php	2.57 KB	-rw-r--r--	2024-02-23 09:36
gallery.php	1.75 KB	-rw-r--r--	2024-02-23 09:36
guideline-view.php	812 B	-rw-r--r--	2026-02-17 09:45
guideline.php	1 KB	-rw-r--r--	2026-02-17 09:45
guideline_intro.php	14.2 KB	-rw-r--r--	2024-02-23 09:36
guideline_notes.php	2.35 KB	-rw-r--r--	2024-02-23 09:36
guideline_programme.php	39.82 KB	-rw-r--r--	2024-02-23 09:36
guideline_resources.php	21.47 KB	-rw-r--r--	2024-02-23 09:36
guideline_rules.php	44.97 KB	-rw-r--r--	2024-02-23 09:36
inc_dashboard.php	28.4 KB	-rw-r--r--	2026-08-20 12:16
inc_footer.php	412 B	-rw-r--r--	2025-02-20 13:01
inc_footer_html.php	59 B	-rw-r--r--	2024-02-23 09:36
inc_functions.php	1.86 KB	-rw-r--r--	2026-06-24 12:03
inc_guidelinemenu.php	944 B	-rw-r--r--	2024-02-23 09:36
inc_header.php	2.46 KB	-rw-r--r--	2025-02-20 13:01
inc_header_html.php	1.34 KB	-rw-r--r--	2024-02-23 09:36
inc_shared.php	27.07 KB	-rw-r--r--	2026-08-19 12:45
inc_sidebar.php	9.54 KB	-rw-r--r--	2026-05-13 15:17
index.php	8.47 KB	-rw-r--r--	2026-06-02 08:33
library-old.php	8.46 KB	-rw-r--r--	2024-02-16 11:19
library-render.php	11.09 KB	-rw-r--r--	2026-04-29 07:23
library.php	474 B	-rw-r--r--	2024-02-25 11:44
login.php	2.79 KB	-rw-r--r--	2025-02-06 10:39
logout.php	129 B	-rw-r--r--	2024-02-23 09:36
markmessagesread.php	546 B	-rw-r--r--	2024-02-23 09:36
messages.php	4.14 KB	-rw-r--r--	2026-05-05 11:48
modcontact.php	26.51 KB	-rw-r--r--	2026-07-30 15:46
module.php	2.78 KB	-rw-r--r--	2024-02-23 09:36
notices.php	2.73 KB	-rw-r--r--	2024-02-23 09:36
password.php	2.52 KB	-rw-r--r--	2024-02-23 09:36
pdfthumb.php	230 B	-rw-r--r--	2024-02-23 09:36
php_errors.log	14.11 KB	-rw-r--r--	2026-08-21 08:24
phpinfo.php	17 B	-rw-r--r--	2025-06-09 13:16
popups.php	1.71 KB	-rw-r--r--	2024-02-23 09:36
profile.php	14.69 KB	-rw-r--r--	2026-03-16 11:53
profile_mentor.php	4.23 KB	-rw-r--r--	2024-02-23 09:36
progress_report.php	2.53 KB	-rw-r--r--	2026-05-13 15:17
readmessage.php	2.49 KB	-rw-r--r--	2026-05-19 07:04
recommended.php	5.94 KB	-rw-r--r--	2024-02-16 11:18
resources.php	4.14 KB	-rw-r--r--	2024-02-23 09:36
results.php	1.54 KB	-rw-r--r--	2024-02-23 09:36
saveexam.php	5.72 KB	-rw-r--r--	2025-11-19 09:45
sentmessages.php	1.66 KB	-rw-r--r--	2024-03-27 09:30
style.css	26.86 KB	-rw-r--r--	2025-02-20 13:04
submittedactivities.php	2.98 KB	-rw-r--r--	2024-02-23 09:36
submittedassignments.php	7.78 KB	-rw-r--r--	2026-06-24 12:03
templates.php	2.08 KB	-rw-r--r--	2024-02-23 09:36
timetable-render.php	2.27 KB	-rw-r--r--	2025-02-20 13:03
timetable.php	476 B	-rw-r--r--	2024-03-16 16:02
v3_feedback_form.php	2.52 KB	-rw-r--r--	2026-05-27 08:23
v3_feedback_submit.php	2.55 KB	-rw-r--r--	2026-05-27 08:23
videos.php	4.06 KB	-rw-r--r--	2024-02-23 09:36

Rename

<?php
include("inc_functions.php");

//ini_set('display_errors', 1);
//error_reporting(E_ALL);

if (!isset($_SESSION["StudentID"]) || empty($_SESSION["StudentID"]) || $_SESSION["StudentID"] == null)
    header("Location: /cesanet/login.php");

include_once($_SERVER['DOCUMENT_ROOT'] . "/cesanet/includes/html_begin.php");
?>
<h1> Messages Inbox</h1>
<?php
if (!CurrentStudent()) {
 echo "Only available to current students.";
 die();
}
include_once($_SERVER['DOCUMENT_ROOT'] . "/cesanet/includes/message_menu.php");
?>
Unread Messages:
<?php
$sql = "SELECT CCEMessages.* FROM CCEMessages, CCEMessagesSentTo
WHERE CCEMessages.CCEMessageID=CCEMessagesSentTo.CCEMessageID
AND CCEMessagesSentTo.SentType='Student'
AND CCEMessagesSentTo.SentID=" . $_SESSION["StudentID"] . "
AND CCEMessages.CCEMessageID NOT IN (SELECT CCEMessageID FROM CCEMessageLog WHERE ReadByType='Student' AND ReadByID=" . $_SESSION["StudentID"] . ")
AND CCEMessages.MessageSubject NOT LIKE 'Feedback on BCE Assignment %' 
AND CCEMessages.MessageSubject NOT LIKE 'CESAnet Assignment Submitted%' 
ORDER BY SentDateTime DESC";
$rec = mysql_query($sql);
if (mysql_num_rows($rec) == 0) {
 echo "You have no new messages.";
} else {
 ?>
 <table border="1" cellpadding="5" cellspacing="0" width="95%" align="center">
 <tr>
 <td>Subject</td>
 <td width="10%" nowrap>Date Sent</td>
 <td width="20%" nowrap>From</td>
 <td width="5%" nowrap>&nbsp;</td>
 </tr>
 <?php
 while ($row = mysql_fetch_assoc($rec)) {
 ?>
 <tr>
 <td><?php echo $row["MessageSubject"]; ?></td>
 <td width="10%" nowrap><?php echo date("Y-m-d H:i", strtotime($row["SentDateTime"])); ?></td>
 <td width="20%" nowrap><?php echo $row["SentByName"]; ?></td>
 <td width="5%" nowrap><a href="readmessage.php?id=<?php echo $row["CCEMessageID"]; ?>">Read Now</a></td>
 </tr>
 <?php
 }
 ?>
 </table>
 <?php
}
mysql_free_result($rec);
?>

Read Messages:
<?php
$sql = "SELECT CCEMessages.CCEMessageID, SentDateTime, SentByName, MessageSubject, MIN(ReadDateTime) AS DateRead
FROM CCEMessages, CCEMessagesSentTo, CCEMessageLog
WHERE CCEMessages.CCEMessageID=CCEMessagesSentTo.CCEMessageID
AND CCEMessages.CCEMessageID=CCEMessageLog.CCEMessageID
AND CCEMessagesSentTo.SentType='Student'
AND CCEMessagesSentTo.SentID=" . $_SESSION["StudentID"] . "
AND CCEMessageLog.ReadByType='Student'
AND CCEMessageLog.ReadByID=" . $_SESSION["StudentID"] . " 
AND CCEMessages.MessageSubject NOT LIKE 'Feedback on BCE Assignment %' 
AND CCEMessages.MessageSubject NOT LIKE 'CESAnet Assignment Submitted %' 
GROUP BY CCEMessages.CCEMessageID, SentDateTime, SentByName, MessageSubject
ORDER BY SentDateTime DESC";
$rec = mysql_query($sql);
if (mysql_num_rows($rec) == 0) {
 echo "You have no previous read messages.";
} else {
 ?>
 <table border="1" cellpadding="5" cellspacing="0" width="95%" align="center">
 <tr>
 <td>Subject</td>
 <td width="10%" nowrap>Date Read</td>
 <td width="10%" nowrap>Date Sent</td>
 <td width="20%" nowrap>From</td>
 <td width="5%" nowrap>&nbsp;</td></tr>
 <?php
 while ($row = mysql_fetch_assoc($rec)) {
 ?>
 <tr>
 <td><?php echo $row["MessageSubject"]; ?></td>
 <td width="10%" nowrap><?php echo date("Y-m-d H:i", strtotime($row["DateRead"])); ?></td>
 <td width="10%" nowrap><?php echo date("Y-m-d H:i", strtotime($row["SentDateTime"])); ?></td>
 <td width="20%" nowrap><?php echo $row["SentByName"]; ?></td>
 <td width="5%" nowrap><a href="readmessage.php?id=<?php echo $row["CCEMessageID"]; ?>">Read Now</a></td></tr>
 <?php
 }
 ?>
 </table>
 <?php
}
mysql_free_result($rec);

include_once($_SERVER['DOCUMENT_ROOT'] . "/cesanet/includes/html_end.php");