$templateVars = array('item' => $item, 'lang' => $lang);
$resultView->assign($templateVars);
$result = $resultView->render($pathToIndex . '/theme/' . $resultTemplate);
}
$title = !empty($_GET['c']) ? $app->setTitle(array($item['keyword'], $lang['archive'])) : $app->setTitle(array('Downloads', $lang['archive']));
// Title , Contents, Pager, and Results
$item = array('title' => $title, 'contents' => $app->getArchives($sql), 'pager' => $app->getPager($totalItemsCount, $pageNumberToShow, $date, $expand), 'result' => $result);
} else {
$e = new Loggix_Exception();
$item = $e->getArticleNotFoundMessage();
}
// (2) Permalink
} elseif (!empty($_GET['id'])) {
$id = intval($_GET['id']);
$getPermalinkSql = 'SELECT ' . '* ' . 'FROM ' . DOWNLOADS_META_TABLE . ' ' . 'WHERE ' . '(id = :id) AND (draft = :draft)';
$getPermalinkSql = $app->setDelimitedIdentifier($getPermalinkSql);
$stmt = $app->db->prepare($getPermalinkSql);
$stmt->execute(array(':id' => $id, ':draft' => 0));
$itemArray = $stmt->fetch();
if ($itemArray == true) {
$item = $stmt->fetch();
$item['title_date'] = date($config['title_date_format'], strtotime($item['file_date']));
$item = $app->setEntryItems($itemArray);
$permalinkTemplateFile = $pathToIndex . LM_Downloads::THEME_PATH . 'parmalink.html';
$contentsView = new Loggix_View($permalinkTemplateFile);
$contentsVars = array('session_state' => $sessionState, 'module' => $module, 'item' => $item, 'lang' => $lang);
$contentsView->assign($contentsVars);
$permalinkTitle = $app->setTitle(array('Downloads', $item['file_title']));
$item = array('title' => $permalinkTitle, 'contents' => $app->plugin->applyFilters('permalink-view', $contentsView->render()), 'pager' => '', 'result' => '');
} else {
$e = new Loggix_Exception();
if (isset($_POST['y'], $_POST['m'], $_POST['d'], $_POST['h'], $_POST['i'], $_POST['s'])) {
$Y = $_POST['y'];
$m = $_POST['m'];
$d = $_POST['d'];
$H = $_POST['h'];
$i = $_POST['i'];
$s = $_POST['s'];
$postDate = $Y . '-' . $m . '-' . $d . ' ' . $H . ':' . $i . ':' . $s;
$modDate = $Y . '-' . $m . '-' . $d . ' ' . $H . ':' . $i . ':' . $s;
} else {
$postDate = gmdate('Y-m-d H:i:s', time() + $cfg['tz'] * 3600);
$modDate = gmdate('Y-m-d H:i:s', time() + $cfg['tz'] * 3600);
}
$app->db->beginTransaction();
$sql = 'UPDATE ' . DOWNLOADS_META_TABLE . ' ' . 'SET ' . '`file_title` = :title, ' . '`file_comment` = :comment, ' . '`file_date` = :date, ' . '`file_mod` = :mod, ' . '`draft` = :draft ' . 'WHERE ' . 'id = :id';
$sql = $app->setDelimitedIdentifier($sql);
$stmt = $app->db->prepare($sql);
$res = $stmt->execute(array(':title' => $title, ':comment' => $comment, ':date' => $postDate, ':mod' => $modDate, ':draft' => $draft, ':id' => $id));
$app->addTag(DOWNLOADS_TAG_MAP_TABLE, $id);
if ($res) {
$app->sendDownloadableFile();
$app->db->commit();
$sql = 'SELECT ' . 'draft ' . 'FROM ' . DOWNLOADS_META_TABLE . ' ' . 'WHERE ' . 'id = :id';
$stmt = $app->db->prepare($sql);
$stmt->execute(array('id' => $id));
$item = $stmt->fetch();
if ($item['draft'] == '1') {
header('Location: ./drafts.php');
} else {
header('Location: ../index.php?id=' . $id);
}