if ($stage == "2" && $t == "n") { if (isset($_POST['publish'])) { $data = dbarray(dbquery( "SELECT ts.*, user_id,user_name FROM ".$db_prefix."submissions ts LEFT JOIN ".$db_prefix."users tu ON ts.submit_user=tu.user_id WHERE submit_id='$submit_id'" )); $news_subject = stripinput($_POST['news_subject']); $news_cat = isNum($_POST['news_cat']) ? $_POST['news_cat'] : "0"; $news_body = addslash($_POST['news_body']); $news_body2 = addslash($_POST['news_body2']); $news_breaks = ($_POST['news_breaks'] == "y") ? "y" : "n"; $result = dbquery("INSERT INTO ".$db_prefix."news (news_subject, news_cat, news_news, news_extended, news_breaks, news_name, news_datestamp, news_start, news_end, news_visibility, news_reads, news_allow_comments, news_allow_ratings) VALUES ('$news_subject', '$news_cat', '$news_body', '$news_body2', '$news_breaks', '".$data['user_id']."', '".time()."', '0', '0', '0', '0', '1', '1')"); $result = dbquery("DELETE FROM ".$db_prefix."submissions WHERE submit_id='$submit_id'"); opentable($locale['490']); echo "
".$locale['491']."

".$locale['402']."

".$locale['403']."

\n"; closetable(); } else if (isset($_POST['delete'])) { opentable($locale['492']); $result = dbquery("DELETE FROM ".$db_prefix."submissions WHERE submit_id='$submit_id'"); echo "
".$locale['493']."

".$locale['402']."

".$locale['403']."

\n"; closetable(); } else { if ($settings['tinymce_enabled'] == 1) echo "\n"; $data = dbarray(dbquery( "SELECT ts.*, user_id,user_name FROM ".$db_prefix."submissions ts LEFT JOIN ".$db_prefix."users tu ON ts.submit_user=tu.user_id WHERE submit_id='$submit_id'" )); $submit_criteria = unserialize($data['submit_criteria']); $news_subject = $submit_criteria['news_subject']; $news_cat = $submit_criteria['news_cat']; $news_body = phpentities(stripslashes($submit_criteria['news_body'])); $news_body2 = phpentities(stripslashes($submit_criteria['news_body2'])); $news_breaks = $submit_criteria['news_breaks']; $news_cat_opts = ""; $sel = ""; $result2 = dbquery("SELECT * FROM ".$db_prefix."news_cats ORDER BY news_cat_name"); if (dbrows($result2)) { while ($data2 = dbarray($result2)) { if (isset($news_cat)) $sel = ($news_cat == $data2['news_cat_id'] ? " selected" : ""); $news_cat_opts .= "\n"; } } opentable($locale['500']); echo "
".$locale['505']."
".$locale['506']."
".$locale['508']."
".$locale['508']."

".$locale['501']."".$data['user_name']."

".$locale['502']."
\n"; closetable(); } }