<?php
include "include.php";
if ($posting) {
langTranslatePost('title,description');
$id = db_save('cal_events');
if (getOption('channels')) {
db_checkboxes('channels', 'cal_events_to_channels', 'event_id', 'channel_id', $id);
}
url_query_add(array("month" => $_POST['start_dateMonth'], "year" => $_POST['start_dateYear']));
}
if (!isset($_GET['month']) || !isset($_GET['year'])) {
url_query_add(array("month" => $_josh['month'], "year" => $_josh['year']));
}
echo drawTop();
echo drawNavigationCal($_GET['month'], $_GET['year']);
//get events
$result = db_query('SELECT
e.id,
DAY(e.start_date) startDay,
e.title' . langExt() . ' title,
t.color
FROM cal_events e
JOIN cal_events_types t ON e.type_id = t.id
' . getChannelsWhere('cal_events', 'e', 'event_id') . '
AND
MONTH(e.start_date) = ' . $_GET['month'] . ' AND
YEAR(e.start_date) = ' . $_GET['year']);
while ($r = db_fetch($result)) {
$events[$r['startDay']][$r['id']]['title'] = $r['title'];
$events[$r['startDay']][$r['id']]['color'] = $r['color'];
<?php
include 'include.php';
if ($posting) {
langTranslatePost('title,description');
$id = db_save('cal_events');
if (getOption('channels')) {
db_checkboxes('channels', 'cal_events_to_channels', 'event_id', 'channel_id', $id);
}
url_change('./event.php?id=' . $_GET['id']);
}
$e = db_grab('SELECT MONTH(e.start_date) month, YEAR(e.start_date) year FROM cal_events e WHERE e.id = ' . $_GET['id']);
echo drawTop();
echo drawNavigationCal($e['month'], $e['year'], true);
echo drawEventForm();
echo drawBottom();
<?php
include "include.php";
$e = db_grab("SELECT \n\t\te.title, \n\t\te.description, \n\t\te.startDate, \n\t\tISNULL(u.nickname, u.firstname) first,\n\t\tu.lastname last,\n\t\te.createdBy,\n\t\te.createdOn,\n\t\tt.color,\n\t\tt.description type,\n\t\tMONTH(e.startDate) month, \n\t\tYEAR(e.startDate) year\n\tFROM calendar_events e\n\tJOIN intranet_users u ON e.createdBy = u.userID\n\tJOIN calendar_events_types t ON e.typeID = t.id\n\tWHERE e.id = " . $_GET["id"]);
if (url_action("delete")) {
db_query("DELETE FROM calendar_events WHERE id = " . $_GET["id"]);
url_change("/cal/?month=" . $e["month"] . "&year=" . $e["year"]);
}
drawTop();
echo drawNavigationCal($e["month"], $e["year"], true);
?>
<table class="left" cellspacing="1">
<?php
if ($isAdmin) {
echo drawHeaderRow("Event Details", 2, "edit", "event_edit.php?id=" . $_GET["id"], "delete", url_query_add(array("action" => "delete"), false));
} elseif ($user["id"] == $e["createdBy"]) {
echo drawHeaderRow("Event Details", 2, "edit", "event_edit.php?id=" . $_GET["id"], "delete", url_query_add(array("action" => "delete"), false));
} else {
echo drawHeaderRow("Event Details", 2);
}
?>
<tr>
<td class="left">Title</td>
<td class="right" bgcolor="#ffffff"><b><?php
echo $e["title"];
?>
</b></td>
</tr>
<tr>
<td class="left">Type</td>
<td><span class="block" style="background-color:<?php
<?php
include "include.php";
if ($posting) {
$_POST["isActive"] = 1;
$id = db_enter("calendar_events", "title description *startDate typeID");
url_query_add(array("month" => $_POST["startDateMonth"], "year" => $_POST["startDateYear"]));
}
if (!isset($_GET["month"]) || !isset($_GET["year"])) {
url_query_add(array("month" => $_josh["month"], "year" => $_josh["year"]));
}
drawTop();
echo drawNavigationCal($_GET["month"], $_GET["year"]);
//get events
$result = db_query("SELECT \n\t\t\te.id,\n\t\t\tDAY(e.startDate) startDay,\n\t\t\te.title,\n\t\t\tt.color\n\t\tFROM calendar_events e\n\t\tJOIN calendar_events_types t ON e.typeID = t.id\n\t\tWHERE e.isActive = 1 AND \n\t\t\tMONTH(e.startDate) = {$_GET["month"]} AND\n\t\t\tYEAR(e.startDate) = " . $_GET["year"]);
while ($r = db_fetch($result)) {
$events[$r["startDay"]][$r["id"]]["title"] = $r["title"];
$events[$r["startDay"]][$r["id"]]["color"] = $r["color"];
}
//SET UP VARIABLES
$monthname = $_josh["months"][$_GET['month'] - 1];
$firstday = date("w", mktime(0, 0, 0, $_GET["month"], 1, $_GET["year"]));
$lastday = date("d", mktime(0, 0, 0, $_GET["month"] + 1, 0, $_GET["year"]));
$prevmonth = $_GET['month'] - 1;
$prevyear = $_GET['year'];
$nextmonth = $_GET['month'] + 1;
$nextyear = $_GET['year'];
if ($prevmonth == 0) {
$prevmonth = 12;
$prevyear = $_GET['year'] - 1;
} elseif ($nextmonth == 13) {
