function shownews($id)
{
global $list_prefix, $NEWS, $MAIN;
$sql = "SELECT * FROM " . $list_prefix . "news WHERE id = '" . $id . "';";
$result = db_query($sql);
$rows = db_num_rows($result);
if ($rows != 0) {
$row = db_fetch_array($result);
$postedby = getuser($row['posted_by']);
//lets insert the prayerrequest into our working copy of this template.
$WORK = insert_into_template($NEWS, "{NEWSTITLE}", stripslashes($row['news_title']));
$WORK = insert_into_template($WORK, "{TEASER}", stripslashes($row['teaser']));
$WORK = insert_into_template($WORK, "{NEWSID}", $row['id']);
$WORK = insert_into_template($WORK, "{POSTEDBY}", $postedby);
$WORK = insert_into_template($WORK, "{BYLINE}", $row['byline']);
$WORK = insert_into_template($WORK, "{DATE}", date("m/d/Y", $row['date']));
$WORK = insert_into_template($WORK, "{CATEGORY}", getcatname($row['category']));
$WORK = insert_into_template($WORK, "{NEWS}", stripslashes($row['news']));
$i++;
//now lets add this request to the CONTENT.
$WORK = insert_into_template($MAIN, "{CONTENT}", $WORK);
$WORK = filltemplate($WORK, striphtml($row['news_title']));
printf("%s", striptemplate($WORK));
}
}
function getarticles($perpage)
{
global $list_prefix;
$ARTICLES = loadtmplate("articles.mod");
$CONTENT = "";
//lets calculate our query
$sql = "SELECT * FROM " . $list_prefix . "articles ORDER BY `date` DESC LIMIT 0," . $perpage . ";";
//now lets show the prayerlist entries.
$result = db_query($sql);
if ($result) {
$rows = db_num_rows($result);
} else {
$rows = 0;
}
if ($rows != 0) {
$j = 0;
while ($j < $rows) {
//lets fetch our prayer request from the database.
$row = db_fetch_array($result);
$postedby = getuser($row['posted_by']);
//lets insert the prayerrequest into our working copy of this template.
$WORK = insert_into_template($ARTICLES, "{ARTICLETITLE}", stripslashes($row['article_title']));
$WORK = insert_into_template($WORK, "{TEASER}", stripslashes($row['teaser']));
$WORK = insert_into_template($WORK, "{ARTICLEID}", $row['id']);
$WORK = insert_into_template($WORK, "{POSTEDBY}", $postedby);
$WORK = insert_into_template($WORK, "{BYLINE}", $row['byline']);
$WORK = insert_into_template($WORK, "{DATE}", date("m/d/Y", $row['date']));
$WORK = insert_into_template($WORK, "{CATEGORY}", getcatname($row['category']));
$j++;
//now lets add this request to the CONTENT.
$CONTENT .= $WORK;
}
} else {
$CONTENT .= "There are no active articles at this time.<BR>\r\n";
}
//when we output this lets make sure that the output is stripped of any template elements that are not used.
return striptemplate($CONTENT);
}
function shownews($category)
{
global $HTTP_GET_VARS, $NEWS, $list_prefix, $MAIN;
$CONTENT = "";
if (isset($HTTP_GET_VARS['perpage']) && is_numeric($HTTP_GET_VARS['perpage'])) {
$perpage = $HTTP_GET_VARS['perpage'];
} else {
$perpage = 3;
}
//lets see if the user has specified to show all requests on a single page.
if (isset($HTTP_GET_VARS['onepage'])) {
$onepage = 1;
} else {
$onepage = 0;
}
//lets see what page we are on
if (!isset($HTTP_GET_VARS['page']) || !is_numeric($HTTP_GET_VARS['page'])) {
$page = 1;
} else {
$page = $HTTP_GET_VARS['page'];
}
//lets calculate our start position for our query if needed.
$start = ($page - 1) * $perpage;
//lets calculate our query
$sql = "SELECT * FROM " . $list_prefix . "news";
if ($category != 0) {
$sql .= " WHERE category = '" . $category . "'";
}
if ($onepage == 0) {
$sql .= " ORDER BY `date` DESC LIMIT " . $start . "," . $perpage . ";";
} else {
$sql .= " ORDER BY `date` DESC;";
}
//now lets show the prayerlist entries.
$result = db_query($sql);
$rows = db_num_rows($result);
if ($rows != 0) {
$i = 0;
while ($i < $rows) {
//lets fetch our prayer request from the database.
$row = db_fetch_array($result);
$postedby = getuser($row['posted_by']);
//lets insert the prayerrequest into our working copy of this template.
$WORK = insert_into_template($NEWS, "{NEWSTITLE}", stripslashes($row['news_title']));
$WORK = insert_into_template($WORK, "{TEASER}", stripslashes($row['teaser']));
$WORK = insert_into_template($WORK, "{NEWSID}", $row['id']);
$WORK = insert_into_template($WORK, "{POSTEDBY}", $postedby);
$WORK = insert_into_template($WORK, "{BYLINE}", $row['byline']);
$WORK = insert_into_template($WORK, "{DATE}", date("m/d/Y", $row['date']));
$WORK = insert_into_template($WORK, "{CATEGORY}", getcatname($row['category']));
$i++;
//now lets add this request to the CONTENT.
$CONTENT .= $WORK;
}
$sql = "SELECT * FROM " . $list_prefix . "news;";
$result = db_query($sql);
$rows = db_num_rows($result);
$pages = ($rows - $rows % $perpage) / $perpage;
//this is the number of complete pages.
if ($rows % $perpage > 0) {
$pages++;
}
//this will take care of incomplete pages.
//lets list a previous page link if needed.
if ($pages > 1 && $onepage == 0) {
$i = 0;
if ($page != 1) {
$CONTENT .= "<a href='news.php?page" . ($page - 1) . "'>prev</a> \r\n";
}
//lets list all pages a user can click on.
while ($i < $pages) {
$i++;
if ($i != $page) {
$CONTENT .= "<a href='news.php?page=" . $i . "'>" . $i . "</a> \r\n";
} else {
$CONTENT .= $i . " ";
}
}
//lets create a next page link if needed
if ($page != $pages) {
$CONTENT .= "<a href='news.php?page=" . ($page + 1) . "'>next</a>\r\n";
}
$CONTENT .= "<div align=\"right\"><a href='news.php?onepage=1'>Show all requests on one page.</a></div><br />\r\n";
}
} else {
$CONTENT .= "There are no active news at this time.<BR>\r\n";
}
$WORK = insert_into_template($MAIN, "{CONTENT}", $CONTENT);
$WORK = filltemplate($WORK, "News");
//when we output this lets make sure that the output is stripped of any template elements that are not used.
printf("%s", striptemplate($WORK));
}
