function print_news_in_table()
{
require_once $_SERVER['DOCUMENT_ROOT'] . '/../connect_mysql.php';
$db = connect_to_database();
if ($statement = $db->prepare("SELECT `news_id`, `title_text`, `posted_time` FROM `news`")) {
$statement->execute();
$statement->store_result();
$statement->bind_result($news_id, $title_text, $posted_time);
?>
<h1>News List</h1>
<p class="body_paragraph"><a href="?action=admin&subaction=edit-news&item=-1">Create a new post</a></p>
<table>
<tr id="table-title-row">
<td>Title</td>
<td>Posted Time</td>
</tr>
<?php
while ($statement->fetch()) {
print_news_item($news_id, $title_text, $posted_time);
}
echo "</table>";
$statement->free_result();
$statement->close();
} else {
die('prepare() failed: ' . htmlspecialchars($db->error));
}
}
function emit_news($en_newspath, $lang_newspath, $oldnews)
{
global $top_dir;
// a little debugging
echo "<!-- in news/news-script.php: top_dir = {$top_dir} -->\n";
echo "<!-- lang-path: {$lang_newspath} ; en-path: {$en_newspath} -->\n";
# Be sure to define the following path to newsdirs
if (!$en_newspath) {
exit;
}
if (!$lang_newspath) {
exit;
}
// This is how many news items to display on the main page.
// Everything after this is displayed on the "oldnews" page.
$cutoff = 10;
$newsfiles = get_news($en_newspath, $lang_newspath);
if ($oldnews) {
$newsfile = array_slice($newsfiles, $cutoff, -1);
} else {
$newsfile = array_slice($newsfiles, 0, $cutoff);
}
// Output files to browser
$filecount = 0;
for (reset($newsfile); $key = key($newsfile); next($newsfile)) {
$fa = file($key);
$n = count($fa);
$anchor = generate_anchor($key);
print_news_item($fa, $n, $newsfile, $key, $anchor);
}
}
Ut nunc massa, posuere id tincidunt eget, finibus quis quam.
</p>
</div>
<div class="latest-news">
<h3 class="latest-news-title">Item Title</h3> <h5 class="date-time-title">HH:MM dd/mm/yyyy - HH:MM dd/mm/yyyy</h5>
<p class="body-paragraph">
Vivamus placerat metus eget nisl ultricies tempus.
Phasellus semper erat quis enim iaculis finibus.
Fusce ac dolor quis nisi tristique malesuada ut eu massa.
</p>
</div>
<div class="latest-news">
<h3 class="latest-news-title">Item Title</h3> <h5 class="date-time-title">HH:MM dd/mm/yyyy - HH:MM dd/mm/yyyy</h5>
<p class="body-paragraph">
Nulla orci tellus, dictum ac lobortis et, porta nec justo.
In ultrices magna a urna pulvinar, eget consequat quam scelerisque.
Duis eleifend mollis nulla, cursus elementum massa lobortis vel.
</p>
</div>
<?php
} else {
if ($_GET['subaction'] == "news" && isset($_GET['item'])) {
$item = $_GET['item'];
print_news_item($item);
}
if ($_GET['subaction'] == "news" && isset($_GET['page'])) {
$page_number = $_GET['page'];
echo "<h1>Latest News</h1>";
print_news_feed_page($page_number);
}
}
case 'Sidebar':
print_item_size(find_xml_value($item_xml, 'size'), 'mbtm');
print_sidebar_item($item_xml);
echo '</article>';
break;
case 'Pastors':
print_item_size(find_xml_value($item_xml, 'size'), 'pastors fadeIn cp_load mbtm');
if (class_exists('cp_album_class')) {
$cp_album_class = new cp_album_class();
$cp_album_class->print_pastor_item_item($item_xml);
}
echo '</article>';
break;
case 'News':
print_item_size(find_xml_value($item_xml, 'size'), 'mbtm latest-news-cp');
print_news_item($item_xml);
echo '</article>';
break;
case 'Our-Team':
print_item_size(find_xml_value($item_xml, 'size'), 'fadeIn cp_load mbtm our-team-cp');
if (class_exists('cp_team_class')) {
$cp_team_class = new cp_team_class();
$cp_team_class->print_team_item($item_xml);
}
echo '</article>';
break;
case 'Contact-Form':
print_item_size(find_xml_value($item_xml, 'size'), 'mt0 fadeIn cp_load mbtm');
print_contact_form($item_xml);
echo '</article>';
break;
