From fa8180ea3a41584943dd7464eb8c3cad769d8211 Mon Sep 17 00:00:00 2001
From: jhunkeler
Date: Sun, 17 Apr 2011 16:49:09 +0000
Subject: Jessus christ
git-svn-id: http://svn.3rd-infantry-division.org/testing/branches/Bayonet CMS v2.1@491 c5b2fb0a-d05d-0410-98c8-828840a80ff6
---
modules/index/index.php | 2 ++
modules/news/functions.php | 19 ++++++++++-----
modules/news/index.php | 42 +++++++++++++++++++++++++++++++++-
modules/rudi/includes/common.class.php | 4 ++--
modules/rudi/views/view.roster.php | 2 +-
5 files changed, 59 insertions(+), 10 deletions(-)
(limited to 'modules')
diff --git a/modules/index/index.php b/modules/index/index.php
index 9847cb5..54c8dbd 100644
--- a/modules/index/index.php
+++ b/modules/index/index.php
@@ -8,6 +8,8 @@
*
*/
+define('INDEX_MODULE', true);
+
$result = $db->Query("SELECT `dir_name` FROM `bayonet_modules` ORDER BY `weight` ASC");
$modules = $db->Fetch($result);
foreach($modules as $module)
diff --git a/modules/news/functions.php b/modules/news/functions.php
index 22952af..f3505df 100644
--- a/modules/news/functions.php
+++ b/modules/news/functions.php
@@ -127,7 +127,7 @@ function getNumOfComments($id){
* Function that gets the desired news from the database and returns it as an array
* @param id - (optional) news_id cooresponding to `bayonet_news`
*/
-function getNews($id = NULL){
+function getNews($id = NULL, $limit = NULL, $index = 0){
global $db;
$query = "SELECT n.news_id, n.title, n.message, n.date, n.category_id, u.username AS author, c.name AS catname, c.image AS catimage ".
@@ -138,11 +138,12 @@ function getNews($id = NULL){
$query = $query."WHERE n.news_id = '$id' ";
}else{
$query = $query."ORDER BY date DESC";
- if($limit !=NULL){
- $query = $query." LIMIT '$limit'";
- }
+ if($index > 0)
+ $query = $query." LIMIT $index, $limit";
+ else if($limit !=NULL)
+ $query = $query." LIMIT $limit";
}
-
+ decho($query);
$result = $db->Query($query);
$data = $db->Fetch($result);
@@ -159,6 +160,12 @@ function displayNews($data){
date_default_timezone_set("America/New_York");
+ if(empty($data)){
+ ReportError("Sorry, we found no news using these parameters.");
+ echo "
";
+ }
+
+
foreach($data as $news)
{
$numComments = getNumOfComments($news['news_id']);
@@ -235,7 +242,7 @@ function commentForm(){
echo "Guest";
}
?>
-
+