function create_post($authorname = '') { global $db, $tprefix, $tld, $install_folder; $today = date('Y-m-d H:m:s'); //========================================== //create entry in meta table $new_meta_id = get_new_meta_id(); echo 'new meta_id = ' . $new_meta_id . '<br>'; $meta_sql = "INSERT INTO `{$tprefix}" . "_meta` (`meta_id`,`path`,`meta_canonical`,`type`) VALUES ('{$new_meta_id}','{$tld}','checked','post')"; echo $meta_sql . '<br>'; //create entry in content table $new_post_id = get_latest_post_id(); echo 'new post_id = ' . $new_post_id . '<br>'; $content_sql = "INSERT INTO `{$tprefix}" . "_content` (`id`,`meta_id`,`date_posted`,`published`,`author`,`title`) \n\t\tVALUES ('{$new_post_id}', '{$new_meta_id}','{$today}' ,'N','{$authorname}','YOUR TITLE HERE')"; echo $content_sql . '<br>'; $db->query($meta_sql) or die('query failed'); $db->query($content_sql) or die('query failed'); //create entry in cat_post table //get the uncategorized cat_id $sql = "select `cat_id` from `{$tprefix}" . "_category` where `cat_label` = 'uncategorized'"; $result = $db->query($sql); $row = $result->fetch_assoc(); if (empty($row['cat_id'])) { echo 'uncategorized not available'; exit; } else { $cat_id = $row['cat_id']; } //create cat_post association $cat_post_sql = "insert into `{$tprefix}" . "_cat_post` (`cat_id`,`post_id`) VALUES ('" . $row['cat_id'] . "','" . $new_post_id . "')"; echo $cat_post_sql; $db->query($cat_post_sql); //========================================== return $new_post_id; }
<label><input type="radio" name="published" value="N" <?php if ($post['published'] == 'N') { echo "checked"; } else { echo ""; } ?> > Unpublish</label> </td> <td>Post Id<br/> <input type="text" readonly name="id" size ="6" maxlength="10" value="<?php if (!isset($editid)) { echo get_latest_post_id(); } else { echo $post['id']; } ?> "> <input type="hidden" name="meta_id" value="<?php echo $post['meta_id']; ?> " /> </td> <td>Date Posted<br/> <input type="text" name="date_posted" size ="19" maxlength="19" value="<?php if (!isset($editid)) { echo date('Y-m-d H:m:s');
require INC_DIR . 'bbcode.php'; define('REBUILD_SEARCH_ABORTED', 0); // when the user aborted the processing define('REBUILD_SEARCH_PROCESSED', 1); // when a batch of posts has been processed define('REBUILD_SEARCH_COMPLETED', 2); // when all the db posts have been processed // // Define initial vars // $def_post_limit = 50; $def_refresh_rate = 3; $def_time_limit = ($sys_time_limit = @ini_get('max_execution_time')) ? $sys_time_limit : 30; $last_session_data = get_rebuild_session_details('last', 'all'); $last_session_id = (int) $last_session_data['rebuild_session_id']; $max_post_id = get_latest_post_id(); $start_time = TIMENOW; $mode = (string) @$_REQUEST['mode']; // check if the user has choosen to stop processing if (isset($_REQUEST['cancel_button'])) { // update the rebuild_status if ($last_session_id) { DB()->query("\n\t\t\tUPDATE " . BB_SEARCH_REBUILD . " SET\n\t\t\t\trebuild_session_status = " . REBUILD_SEARCH_ABORTED . "\n\t\t\tWHERE rebuild_session_id = {$last_session_id}\n\t\t"); } bb_die(sprintf($lang['REBUILD_SEARCH_ABORTED'], $last_session_data['end_post_id']) . '<br /><br />' . sprintf($lang['CLICK_RETURN_REBUILD_SEARCH'], '<a href="admin_rebuild_search.php">', '</a>')); } // from which post to start processing $start = abs(intval(@$_REQUEST['start'])); // get the total number of posts in the db $total_posts = get_total_posts(); // clear the search tables and clear mode (delete or truncate)