query_num_rowsDB(" SELECT id FROM ot_posts WHERE post_url = '" . addslashes($_POST['post_url']) . "' "); // Check in DB if($Double > 0) // Double? { $_POST['post_url'] = $_POST['post_url'] . "-" . ($Double + 1); // Add number at the end } // Check if user is allow to publish if( ! (defined("USER_LEVEL_ADMINISTRATOR") OR defined("USER_LEVEL_EDITOR")) && ($_POST['post_status'] == "gepubliceerd")) { $_POST['post_status'] = "klad"; } // We'll create the post in DB $DB->query_execDB(" INSERT INTO ot_posts SET id = 'NULL', post_title = '" . addslashes($_POST['post_title']) . "', post_content = '" . addslashes($_POST['post_content']) . "', post_author = '" . USER_ID . "', post_date = NOW(), post_modified = 'NULL', post_url = '" . $_POST['post_url'] . "', post_type = 'post', post_parent = 'NULL', post_status = '" . addslashes($_POST['post_status']) . "', post_comment_status = '" . addslashes($_POST['post_comment_status']) . "', post_comments = 0, post_views = 0 "); // We want to know which ID the post got $_POST['post_id'] = mysql_insert_id(); // Now we attach a category $Categories = $DB->query_fetchDB(" SELECT id FROM ot_categories ORDER BY id DESC "); if($Categories) // Are there categories? { for($i = 0; $i < count($Categories); $i++) { if(isset($_POST['post_category_' . $Categories[$i]['id']])) // This category? { $DB->query_execDB(" INSERT INTO ot_post2category SET id = 'NULL', post_id = '" . $_POST['post_id'] . "', category_id = '" . $Categories[$i]['id'] . "' "); // Link post to category } } } // Everything inserted, let's edit ! header("Location: post-edit.php?post=" . $_POST['post_id']); } else { header("Location: err-403.php"); // Error } } $PageTitle = " » Schrijven » Nieuw bericht"; // Set page title include("admin-header.php"); // Load header ?>