function showNewsWComments()
{
require 'database.php';
$name = $_SESSION['userAccount'];
//show posted stories
$stmt = $mysqli->prepare("SELECT * FROM news WHERE poster=?");
if (!$stmt) {
printf("Query Prep Failed: %s\n", $mysqli->error);
exit;
}
$stmt->bind_param('s', $name);
$stmt->execute();
$result = $stmt->get_result();
echo "<table>\n\t\t\t<tr>\n\t\t\t<th>Previously Posted:</th>\n\t\t\t<th>Delete and Edit:</th>\n\t\t\t<th>News Links:</th>\n\t\t\t</tr>";
while ($row = $result->fetch_assoc()) {
$_SESSION['newsStory'] = $row['newsstory'];
echo "<tr>";
echo "<td>" . htmlentities($row['title']) . "</td>";
echo "<td>" . htmlentities($row['newsstory']) . "</td>";
echo "<td>" . '<a href="' . "http://" . htmlentities($row['links']) . '">' . htmlentities($row['links']) . ' </a>' . "</td>";
echo "<td>";
deleteStory($row['id']);
editStory($row['id']);
echo "</td>";
echo "</tr>";
}
$stmt->close();
echo "</table>";
showComments();
}
$date_finval = $date_debval;
}
$temp_new = mktime(substr($date_debval, 11, 2), substr($date_debval, 14, 2), 0, substr($date_debval, 5, 2), substr($date_debval, 8, 2), substr($date_debval, 0, 4));
$temp = time();
if ($temp > $temp_new) {
postStory("pub_immediate", $qid, $uid, $author, $subject, $hometext, $bodytext, $topic, $notes, $catid, $ihome, $members, $Mmembers, $date_debval, $date_finval, $epur);
} else {
postStory("pub_automated", $qid, $uid, $author, $subject, $hometext, $bodytext, $topic, $notes, $catid, $ihome, $members, $Mmembers, $date_debval, $date_finval, $epur);
}
break;
case "DeleteStory":
deleteStory($qid);
Header("Location: admin.php?op=submissions");
break;
case "EditStory":
editStory($sid);
break;
case "ChangeStory":
if (!$date_finval) {
if (strlen($fin_day) == 1) {
$fin_day = "0{$fin_day}";
}
if (strlen($fin_month) == 1) {
$fin_month = "0{$fin_month}";
}
$date_finval = "{$fin_year}-{$fin_month}-{$fin_day} {$fin_hour}:{$fin_min}:00";
}
changeStory($sid, $subject, $hometext, $bodytext, $topic, $notes, $catid, $ihome, $members, $Mmembers, $Cdate, $Csid, $date_finval, $epur, $theme);
break;
case "RemoveStory":
removeStory($sid, $ok);
