}
if (isset($_GET['id'])) {
$id = $_GET['id'];
$sql = "SELECT * FROM events WHERE event_id='{$id}';";
$result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
$event_name = $row['event_name'];
$event_date = $row['date'];
$event_stime = $row['start_time'];
$event_etime = $row['end_time'];
$event_desc = $row['desc'];
}
$event_date_mysql = $event_date;
$event_date = $event_date[5] . $event_date[6] . "/" . $event_date[8] . $event_date[9] . "/" . substr($event_date, 0, 4);
$event_stime = convert_12($event_stime);
$event_etime = convert_12($event_etime);
}
?>
<html>
<head>
<title><?php
echo $_SESSION['system_name'];
?>
Service Point Management System</title>
<link href="../style.css" type="text/css" rel="stylesheet">
<script type="text/javascript" src="../js/jquery-1.3.2.min.js"></script>
<script type="text/javascript" src="../js/jquery-ui-1.7.2.custom.min.js"></script>
<script type="text/javascript" src="../js/jquery.timePicker.js"></script>
<script type="text/javascript" src="../js/form-validation.js"></script>
<script type="text/javascript">
$(function() {
$month_id = date("m");
}
$month = date("F", mktime(0, 0, 0, $month_id, 1, 1926));
$prev_month_id = $month_id - 1;
$next_month_id = $month_id + 1;
$prev_month = date("F", mktime(0, 0, 0, $month_id - 1, 1, 1926));
$next_month = date("F", mktime(0, 0, 0, $month_id + 1, 1, 1926));
echo "\n<table width='100%'>\n\t<tr style='background-color: #eee;'>\n\t\t<td align='center' width='33%' style='padding: 10px;'><a href='?m={$prev_month_id}'><< {$prev_month}</a></td>\n\t\t<td align='center' width='33%'>{$month}, {$year}</td>\n\t\t<td align='center' width='33%'><a href='?m={$next_month_id}'>{$next_month} >></td>\n\t</tr>\n\t<tr>\n\t\t<td colspan='4'>";
$has_events = 0;
$sql = "SELECT * FROM events ORDER BY date ASC";
$result = mysql_query($sql);
while ($row = mysql_fetch_array($result)) {
$event_id = $row['event_id'];
$event_name = $row['event_name'];
$event_date = $row['date'];
$event_day = $event_date[8] . $event_date[9];
$event_day = date("jS", mktime(0, 0, 0, 1, $event_day, 1926));
$event_month = $event_date[5] . $event_date[6];
$event_year = substr($event_date, 0, 4);
$event_start_time = convert_12($row['start_time']);
$event_end_time = convert_12($row['end_time']);
$event_description = substr($row['desc'], 0, 300) . "...";
if ($year == $event_year && $month_id == $event_month) {
$has_events = 1;
echo "<br><div class='calendar_event'><div class='calendar_day'><span style='font-size: 35px; color: #bbb;'>{$event_day}</span></div><div style='float: left; width: 78%;'><h3><a href='display-event.php?id={$event_id}'>{$event_name}</a> <span style='font-weight: normal; font-size: 12px;'>({$event_start_time} - {$event_end_time})</span></h3><p>{$event_description}</p></div><div class='clear'></div></div>";
}
}
if (!$has_events) {
echo "<br><div class='calendar_event'>There are no events currently scheduled for this month.</div>";
}
echo "</td></tr></table>";
?>
- <?php
echo convert_12($event['end_time']);
?>
</span></h1>
<p><?php
echo $event['desc'];
?>
</p>
<h3>Opportunities for this event</h3>
<?php
while ($row = mysql_fetch_array($result1)) {
$opp_id = $row['opp_id'];
$opp_title = $row['title'];
$opp_start_time = convert_12($row['start_time']);
$opp_end_time = convert_12($row['end_time']);
$opp_desc = $row['desc'];
$opp_point_value = $row['value'];
$opp_slots_left = $row['slots'];
$user_id_opp = $_SESSION['user_id'];
$sql2 = "SELECT * FROM registration WHERE user_id='{$user_id_opp}' AND opp_id='{$opp_id}'";
$result = mysql_query($sql2) or die(mysql_error());
if (mysql_num_rows($result) > 0) {
$user_is_registered = 1;
} else {
$user_is_registered = 0;
}
?>
<div class="calendar_event">
<div style="float: left; width: 78%;">
<div style="float: left; border-right: 1px solid #eee; padding: 10px;">
}
if (isset($_GET['id'])) {
$id = $_GET['id'];
$sql = "SELECT * FROM opportunities WHERE opp_id='{$id}';";
$result = mysql_query($sql) or die(mysql_error());
while ($row = mysql_fetch_array($result)) {
$opp_name = $row['title'];
$event_id = $row['event_id'];
$opp_stime = $row['start_time'];
$opp_etime = $row['end_time'];
$opp_desc = $row['desc'];
$opp_value = $row['value'];
$opp_slots = $row['slots'];
}
$opp_stime = convert_12($opp_stime);
$opp_etime = convert_12($opp_etime);
}
?>
<html>
<head>
<title><?php
echo $_SESSION['system_name'];
?>
Service Point Management System</title>
<link href="../style.css" type="text/css" rel="stylesheet">
<script type="text/javascript" src="../js/jquery-1.3.2.min.js"></script>
<script type="text/javascript" src="../js/jquery-ui-1.7.2.custom.min.js"></script>
<script type="text/javascript" src="../js/jquery.timePicker.js"></script>
<script type="text/javascript" src="../js/form-validation.js"></script>
<script type="text/javascript">
$(function() {
} else {
if ($ampm == "PM") {
if (substr($time, 0, 2) != 12) {
$hour = substr($time, 0, 2) - 12;
} else {
$hour = substr($time, 0, 2);
}
}
}
return $hour . ":" . substr($time, 3, 2) . " " . $ampm;
}
$sql = "SELECT * FROM events WHERE (DATEDIFF(date,curdate()))=1;";
$result = mysql_query($sql) or die(mysql_error());
while ($upcoming_events = mysql_fetch_array($result)) {
$start_time = convert_12($upcoming_events['start_time']);
$end_time = convert_12($upcoming_events['end_time']);
$sql1 = "SELECT * FROM opportunities WHERE event_id='{$upcoming_events['event_id']}';";
$result1 = mysql_query($sql1) or die(mysql_error());
while ($upcoming_opportunities = mysql_fetch_array($result1)) {
$sql2 = "SELECT * FROM registration WHERE opp_id='{$upcoming_opportunities['opp_id']}' AND approved>0 AND reminder_sent = 0;";
$result2 = mysql_query($sql2) or die(mysql_error());
while ($registrants = mysql_fetch_array($result2)) {
$sql3 = "SELECT * FROM users WHERE user_id='{$registrants['user_id']}';";
$result3 = mysql_query($sql3) or die(mysql_error());
$registrant = mysql_fetch_array($result3);
$mail = new PHPMailer();
$mail->isSMTP();
//Enable SMTP debugging
// 0 = off (for production use)
// 1 = client messages
// 2 = client and server messages
