} // Insert first entry... // First Entry Data $title = 'Welcome!'; $comment = '<img src="./theme/images/loggix_icon.png" alt="Loggix" />' . "\n\n" . 'This is the first entry.'; $excerpt = ''; $postDate = gmdate('Y-m-d H:i:s', time() + $config['tz'] * 3600); $modDate = gmdate('Y-m-d H:i:s', time() + $config['tz'] * 3600); $draft = '0'; // First Entry SQL $firstEntrySql = 'INSERT INTO ' . LOG_TABLE . '(' . 'title, ' . 'comment, ' . 'excerpt, ' . 'date, ' . 'mod, ' . 'draft' . ') ' . 'VALUES' . '(' . "'" . $title . "', " . "'" . $comment . "', " . "'" . $excerpt . "', " . "'" . $postDate . "', " . "'" . $modDate . "', " . "'" . $draft . "'" . ')'; $firstEntryRes = $app->db->query($firstEntrySql); // Get the new entry ID. $getNewEntryIdSql = 'SELECT MAX(id) FROM ' . LOG_TABLE; $getNewEntryIdRes = $app->db->query($getNewEntryIdSql); $id = $getNewEntryIdRes->fetchColumn(); // Add the new entry tag $addTagNameSql = 'INSERT INTO ' . LOG_TAG_TABLE . '(tag_name) ' . 'VALUES' . "('Untagged')"; $addTagNameRes = $app->db->query($addTagNameSql); $app->addTag(LOG_TAG_MAP_TABLE, $id); // ---------------------------------------------- $addDownloadsTagNameSql = 'INSERT INTO ' . DOWNLOADS_TAG_TABLE . '(tag_name) ' . 'VALUES' . "('Untagged')"; $addDownloadsTagNameRes = $app->db->query($addDownloadsTagNameSql); $app->addTag(DOWNLOADS_TAG_MAP_TABLE, '0'); header('Location: ../index.php'); } else { header('Location: ../index.php'); } } else { header('Location: ../index.php'); }
// 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. header('Location: ./drafts.php'); exit; } else { // If the entry status is public, move to published page. if (class_exists('Loggix_Module_Trackback')) { $tb = new Loggix_Module_Trackback(); $tb->sendTrackback($id); } header('Location: ../index.php?id=' . urlencode($id)); exit;