$sql_academic_calendar = "SELECT * FROM academic_calendar WHERE date_from >= '{$currentDate}' ORDER BY date_from ASC";
$restults_academic_calendar = mysql_query($sql_academic_calendar);
while ($row = mysql_fetch_assoc($restults_academic_calendar)) {
$upcomingArray[$upcomingCount]['date_from'] = $row['date_from'];
$upcomingArray[$upcomingCount]['date_to'] = $row['date_to'];
$upcomingArray[$upcomingCount]['title'] = $row['description'];
$upcomingArray[$upcomingCount]['url'] = NULL;
$upcomingArray[$upcomingCount]['semester'] = $row['semester'];
$upcomingArray[$upcomingCount]['type'] = NULL;
$upcomingCount++;
}
sort($upcomingArray);
if ($upcomingCount != 0) {
echo '<table style="padding-left:20px;padding-right:20px; margin-top:-15px">';
for ($c = 0; $c <= 2; $c++) {
list($mon, $day) = monthDay($upcomingArray[$c]['date_from']);
echo '<tr>';
echo '<td><div class="date_figure">' . $mon . '<br />' . $day . '</div></td>';
echo '<td valign="top"><div class="event_box_home"><strong><a ';
if (strlen($upcomingArray[$c]['url']) > 0) {
echo 'href="' . $upcomingArray[$c]['url'] . '">';
} elseif ($upcomingArray[$c]['url'] != NULL) {
echo 'href="?i=events&id=' . $row['ID'] . '">';
} elseif ($upcomingArray[$c]['url'] == NULL) {
echo '>';
}
echo ucwords($upcomingArray[$c]['title']) . '</a></strong><br />';
if ($upcomingArray[$c]['semester'] != NULL && strlen($upcomingArray[$c]['semester']) > 0) {
echo strtolower($upcomingArray[$c]['semester']);
} elseif ($upcomingArray[$c]['type'] != NULL && strlen($upcomingArray[$c]['type']) > 0) {
echo strtolower($upcomingArray[$c]['type']);
/**
* Get USER AGE
* return Age;
*/
public function getAge($show = "")
{
$this->setRquery("SELECT pDOBD,pDOBM,pDOBY FROM amistiPersonal WHERE userID=?", array($this->UID));
$res = $this->getRquery();
$id = $this->UID;
if (!$res[0]['pDOBD'] == NULL) {
$age = getUserAge($res[0]['pDOBD'], $res[0]['pDOBM'], $res[0]['pDOBY']);
$age .= " years";
$birthD .= addZero($res[0]['pDOBD']) . " " . numberToMonth($res[0]['pDOBM']);
$ageInfo = $this->UID == UID ? "Your age information:" : $this->uName . " age information:";
?>
<div class="pProfileICHeader"> Age Information:</div>
<?php
if ($this->UID == UID) {
//check if it same as cur user
?>
<div class="pProfileMenuShow">...</div>
<!--- menu -->
<div class="pProfileMenu">
<li id="ageEdit">Edit</li>
<li id="ageDelete">Delete</li>
</div>
<?php
}
?>
<div class="pProfileItem">
<table>
<tr><td>Date of Birth </td><td>: <?php
echo $birthD;
?>
</td></tr>
<tr><td> Age </td><td>: <?php
echo $age;
?>
</td></tr>
</table>
</div>
<?php
} else {
if ($this->UID == UID) {
if ($show == true) {
?>
<div class="pProfileICHeader"> Age:</div>
<div class="pProfileItem pProfileBack">
<table>
<tr><td> Day </td><td><?php
echo monthDay();
?>
</td></tr>
<tr><td>Month</td><td><?php
echo monthName();
?>
</td></tr>
<tr><td>Year</td><td><?php
echo ageYear();
?>
</td></tr>
<tr><td colspan="2">
<input type="submit" id="ageClear" value="Cancel">
<input type="submit" id="ageSave" value="Save">
</td></tr>
</table>
</div>
<?php
} else {
?>
<div class="pProfileICHeader"> Age:</div>
<div class="pProfileItem pGender">
<div class="addProfile" id="ageAdd"> Add Date of Birth</div>
</div>
<?php
}
} else {
?>
<div class="pProfileICHeader"> Age Information:</div>
<div class="pProfileItem pProfileItemNon">
<?php
echo $this->fName . " " . $this->sName . " has not updated age information.";
?>
</div>
<?php
}
}
}
list($mon, $day) = monthDay($row['date_from']);
echo '<tr>';
echo '<td><div class="date_figure">' . $mon . '<br />' . $day . '</div></td>';
echo '<td valign="top"><div class="event_box_home"><strong><a href="?i=events&id=' . $row['ID'] . '">' . ucwords($row['title']) . '</a></strong><br />' . ucwords($row['location']) . '</div></td>';
echo '</tr>';
$upcomingCount++;
if ($upcomingCount >= 3) {
break;
}
}
// academic calendar
$sql_academic_calendar = "SELECT * FROM academic_calendar WHERE date_from >= '{$currentDate}' ORDER BY date_from ASC LIMIT 3";
$restults_academic_calendar = mysql_query($sql_academic_calendar);
while ($row = mysql_fetch_assoc($restults_academic_calendar)) {
$nothing = FALSE;
list($mon, $day) = monthDay($row['date_from']);
echo '<tr>';
echo '<td><div class="date_figure">' . $mon . '<br />' . $day . '</div></td>';
echo '<td valign="top"><div class="event_box_home"><strong>' . ucwords($row['description']) . '</strong><br />' . strtolower($row['semester']) . '</div></td>';
echo '</tr>';
$upcomingCount++;
if ($upcomingCount >= 3) {
break;
}
}
echo '</table>';
if ($upcomingCount == 0) {
echo "There are currently no scheduled events.";
}
?>
</div>
