static function perform($terms)
{
$terms = Search::split_terms($terms);
$terms_db = Search::db_escape_terms($terms);
$terms_rx = Search::rx_escape_terms($terms);
$parts = array();
foreach ($terms_db as $term_db) {
array_push($parts, "(summary RLIKE '{$term_db}' OR title RLIKE '{$term_db}')");
}
$parts = implode(' AND ', $parts);
$conn = Persistence::get_database_object();
$sql = "SELECT id, title, summary, created FROM postmortems WHERE {$parts}";
$rows = array();
$stmt = $conn->prepare($sql);
$stmt->execute();
$timezone = getUserTimezone();
$tz = new DateTimeZone($timezone);
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$row['score'] = 0;
$row['created'] = new DateTime("@{$row['created']}");
$row['created']->setTimezone($tz);
$row['created'] = $row['created']->format('m/d/Y G:ia');
foreach ($terms_rx as $term_rx) {
$row['score'] += preg_match_all("/{$term_rx}/i", $row['summary'], $null);
$row['score'] += preg_match_all("/{$term_rx}/i", $row['title'], $null);
}
$rows[] = $row;
}
uasort($rows, 'Search::sort_results');
$conn = null;
return $rows;
}
$event = Postmortem::save_event($event);
$app->redirect('/events/' . $event["id"]);
});
$app->get('/events/:id', function ($id) use($app) {
$event = Postmortem::get_event($id);
if (is_null($event["id"])) {
echo "loooool";
$app->response->status(404);
return;
}
$page_title = sprintf("%s | Morgue", $event['title']);
$starttime = $event["starttime"];
$endtime = $event["endtime"];
$detect_time = $event["detecttime"];
$status_time = $event["statustime"];
$timezone = getUserTimezone();
$severity = $event["severity"];
$gcal = $event["gcal"];
$contact = $event["contact"];
$summary = $event["summary"];
$why_surprised = $event["why_surprised"];
$tz = new DateTimeZone($timezone);
$start_datetime = new DateTime("@{$starttime}");
$start_datetime->setTimezone($tz);
$end_datetime = new DateTime("@{$endtime}");
$end_datetime->setTimezone($tz);
if ($status_time) {
$status_datetime = new DateTime("@{$status_time}");
$status_datetime->setTimezone($tz);
} else {
$status_datetime = false;
<?php
////// HEADER //////
require_once 'phpInclude/header.php';
$userTimezone = getUserTimezone($_SESSION['LoginUserId']);
?>
<section class="midsection accountsection"><!-- // MID MAIN SECTION // -->
<div class="container">
<div class="row">
<div class="col-xs-12 col-sm-4 col-md-3">
<?php
require_once 'phpInclude/sidebar_expert_profile.php';
?>
</div>
<div class="col-xs-12 col-sm-8 col-md-9">
<section class="right_main"><!-- // RIGHT MAIN // -->
<ul class="breadcrumb">
<li><a href="javascript:void(0);">Home</a></li>
<li>My Sessions</li>
</ul>
<h2 class="accountheading"><small>My</small>Sessions</h2>
<div class="MysessionCont">
<ul class="session_tabs ">
<li><a href="<?php
echo $root;
?>
user_sessions.php?tab=schedule" class="<?php
if (empty($_GET['tab']) || isset($_GET['tab']) && $_GET['tab'] == 'schedule') {
echo 'active';
<div class="row-fluid">
<div class="span12">
<table class="table table-striped">
<thead>
<tr>
<th>Title</th>
<th>Start Time</th>
<th>End Time</th>
<th>Severity</th>
</tr>
</thead>
<?php
$tz = new DateTimeZone(getUserTimezone());
foreach ($events as $event) {
$start = new DateTime("@" . $event["starttime"]);
$start->setTimezone($tz);
$start = $start->format('m/d/Y G:ia');
$end = new DateTime("@" . $event["endtime"]);
$end->setTimezone($tz);
$end = $end->format('m/d/Y G:ia');
echo "<tr>";
echo "<td><a href=/events/{$event['id']}>{$event['title']}</a></td>";
echo "<td>{$start}</td>";
echo "<td>{$end}</td>";
echo "<td>{$event['severity']}</td>";
echo "</tr>";
}
?>
</table>
</div>
</div>
<div class="row-fluid">
<div class="offset1 span10">
<!-- Title -->
<div class="row-fluid">
<input class="input-headline editable" id="eventtitle" type="text"
value="<?php
echo $event["title"];
?>
" required disabled>
</div>
<!-- Small Print -->
<div class="row-fluid">
<i class="muted"><small>All times are currently shown in <?php
echo getUserTimezone();
?>
time.</small></i>
</div>
<div class="row-fluid">
<br/>
</div>
<!-- Time and Severity (in two columns) -->
<div class="row-fluid">
<!-- Editable Controls -->
<form class="form-horizontal">
<div class="span6">
<div class="control-group">
<label class="control-label" id="event-start-time">Start time: </label>
<div class="controls controls-row">
echo json_encode(array('status' => $status, 'result' => $tags));
exit;
} else {
if (isset($_POST['action']) && $_POST['action'] == 'submit_book_schedule_public') {
$session_id = "";
$error = array();
foreach ($_POST as $key => $value) {
if (!is_array($value)) {
$value = empty($value) ? '' : $value;
${$key} = mysql_real_escape_string(trim($value));
} else {
$value = empty($value) ? array() : $value;
${$key} = $value;
}
}
$userTimezone = getUserTimezone($user_id);
//exp_id
if (!isset($tag_selected)) {
$tag_selected = array();
}
if (!isset($language_selected)) {
$language_selected = array();
}
if (!isset($slot_selected)) {
$slot_selected = array();
}
//$tag_selected = (isset(($tag_selected)))?array():$tag_selected;
//$language_selected = (isset(($language_selected)))?array():$language_selected;
$sql = " INSERT INTO sessions SET user_id='" . $user_id . "',category_id='" . $category_id . "', tag_id='" . implode($tag_selected, ',') . "',language_id='" . implode($language_selected, ',') . "', type='request',duration='" . $duration . "',title='" . $title . "',description='" . $description . "',question='" . $question . "',other='" . $other . "',status='1',created='" . $date . "' ";
$query = mysql_query($sql);
if ($query) {
