$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() + $config['tz'] * 3600); $modDate = gmdate('Y-m-d H:i:s', time() + $config['tz'] * 3600); } // Upload Attachiments $app->sendAttachments(); // Insert an new entry $app->db->beginTransaction(); $sql = 'INSERT INTO ' . LOG_TABLE . ' ' . '(' . '`title`, ' . '`comment`, ' . '`excerpt`, ' . '`date`, ' . '`mod`, ' . '`draft`' . ') ' . 'VALUES ' . '(' . ':title, ' . ':comment, ' . ':excerpt, ' . ':date, ' . ':mod, ' . ':draft' . ')'; $sql = $app->setDelimitedIdentifier($sql); $stmt = $app->db->prepare($sql); $res = $stmt->execute(array(':title' => $title, ':comment' => $comment, ':excerpt' => $excerpt, ':date' => $postDate, ':mod' => $modDate, ':draft' => $draftStatus)); // Get the new entry ID. // $id = $app->db->lastInsertId(); $selectMaxSql = 'SELECT MAX(id) FROM ' . LOG_TABLE; $id = $app->db->query($selectMaxSql)->fetchColumn(); // Plugin action $app->plugin->doAction('after-new-entry-posted', $id); // Add tags $app->addTag(LOG_TAG_MAP_TABLE, $id); // echo var_dump($res); if (!empty($res)) { $app->db->commit(); if ($draftStatus == '1') { // If the entry is draft, move to draft page.
$resultView->assign($templateVars); $result = $resultView->render($pathToIndex . '/theme/' . $resultTemplate); } $title = !empty($_GET['t']) ? $app->setTitle(array('Tag', $item['keyword'])) : $app->setTitle($lang['archive']); // Title , Contents, Pager, and Results $item = array('title' => $title, 'contents' => $app->getArchives($sql), 'pager' => $app->getPager($totalItemsCount, $pageNumberToShow, $date, $expand), 'result' => $result); $getLastModifiedSql = $sql; } else { $e = new Loggix_Exception(); $item = $e->getArticleNotFoundMessage(); } // (2) Permalink } elseif (!empty($_GET['id'])) { $id = intval($_GET['id']); $getPermalinkSql = 'SELECT ' . '`id`, `title`, `comment`, `date`, `mod`, ' . '`draft`, `allow_comments`, `allow_pings` ' . 'FROM ' . LOG_TABLE . ' AS l ' . 'WHERE ' . "(l.id = '" . $id . "') AND (l.draft = '0')"; $getPermalinkSql = $app->setDelimitedIdentifier($getPermalinkSql); $stmt = $app->db->prepare($getPermalinkSql); if ($stmt->execute() == true) { $itemArray = $stmt->fetch(); $item = $app->setEntryItems($itemArray); $contentsView = new Loggix_View(); $templateVars = array('session_state' => $sessionState, 'module' => $module, 'item' => $item, 'lang' => $lang); $contentsView->assign($templateVars); $template = $pathToIndex . '/theme/permalink.html'; $titleDate = date($config['title_date_format'], strtotime($item['date'])); $item = array('title_date' => $titleDate, 'title' => $app->setTitle($item['title']), 'contents' => $app->plugin->applyFilters('permalink-view', $contentsView->render($template)), 'pager' => '', 'result' => ''); $getLastModifiedSql = $getPermalinkSql; } else { $e = new Loggix_Exception(); $item = $e->getFileNotFoundMessage(); }