addLocale("community.news"); $id = $input->FilterText($_GET['id']); $category = $input->stringToURL($input->HoloText($_GET['category'],true),true,false); $archive = $_GET['archive']; $pagenum = $_GET['pageNumber']; if(!isset($_GET['pageNumber'])){ $pagenum = 1; } if(!isset($id) || $id == ""){ $id = $db->result($db->query("SELECT MAX(id) AS count FROM ".PREFIX."news LIMIT 1")); } $news_row = $db->fetch_assoc($db->query("SELECT * FROM ".PREFIX."news WHERE id = '".$id."' LIMIT 1")); foreach ($news_row as &$value) { $value = $input->HoloText($value, true); } $page['id'] = "news"; $page['name'] = $lang->loc['pagename.news']." - ".$news_row['title']; $page['bodyid'] = "news"; $page['cat'] = "community"; require_once('./templates/community_header.php'); ?>

loc['pagename.news']; ?>

result($db->query("SELECT COUNT(*) FROM ".PREFIX."news")); $pages = ceil($count / 20); ?>
<< loc['older']; ?> 0){ ?>loc['newer']; ?> >>
query("SELECT * FROM ".PREFIX."news WHERE time > ".$time['stop']." ORDER BY id DESC"); if($db->num_rows($sql) > 0){ ?>

loc['today']; ?>

    fetch_assoc($sql)){ $row['title_safe'] = $input->stringToURL($input->HoloText($row['title'],true),true,true); ?>
  • " class="article-"> »
query("SELECT * FROM ".PREFIX."news WHERE time < ".$time['start']." AND time > ".$time['stop']." ORDER BY id DESC"); if($db->num_rows($sql) > 0){ ?>

loc['yesterday']; ?>

    fetch_assoc($sql)){ $row['title_safe'] = $input->stringToURL($input->HoloText($row['title'],true),true,true); ?>
  • " class="article-"> »
query("SELECT * FROM ".PREFIX."news WHERE time < ".$time['start']." AND time > ".$time['stop']." ORDER BY id DESC"); if($db->num_rows($sql) > 0){ ?>

loc['this.week']; ?>

    fetch_assoc($sql)){ $row['title_safe'] = $input->stringToURL($input->HoloText($row['title'],true),true,true); ?>
  • " class="article-"> »
query("SELECT * FROM ".PREFIX."news WHERE time < ".$time['start']." AND time > ".$time['stop']." ORDER BY id DESC"); if($db->num_rows($sql) > 0){ ?>

loc['last.week']; ?>

    fetch_assoc($sql)){ $row['title_safe'] = $input->stringToURL($input->HoloText($row['title'],true),true,true); ?>
  • " class="article-"> »
query("SELECT * FROM ".PREFIX."news WHERE time < ".$time['start']." AND time > ".$time['stop']." ORDER BY id DESC"); if($db->num_rows($sql) > 0){ ?>

loc['this.month']; ?>

    fetch_assoc($sql)){ $row['title_safe'] = $input->stringToURL($input->HoloText($row['title'],true),true,true); ?>
  • " class="article-"> »

loc['pagename.news']; ?>

loc['pagename.news']; ?>

    query("SELECT * FROM ".PREFIX."news WHERE categories LIKE '%".$category."%'"); while($row = $db->fetch_assoc($sql)){ $row['title_safe'] = $input->stringToURL($input->HoloText($row['title'],true),true,true); ?>
  • /in/category/" class="article-"> »
loc['more.news']; ?> »

loc['posted']." ".date('M j, Y',$news_row['time']); ?> stringToURL($input->HoloText($value,true),true,true)."\">".$value.", "; } $output = substr_replace($output,"",-2); ?>

-
1){ unset($images[0]); $output = ""; foreach($images as &$value){ $output = $output."\n"; } ?>
name != 'Guest'){ $posted_on = date("M j, Y g:i A"); $comment = strip_tags($input->FilterText($_POST['comment'])); if($comment == NULL){ $error_message = 'You have left a field empty.

'; }else{ mysql_query("INSERT INTO cms_news_comments (article, userid, comment, posted_on) VALUES ('".$news_row['id']."', '".$user->id."', '".$comment."', '".$posted_on."');"); $error_message = 'You have successfully left a comment.

'; } } ?>

Post Comment

name != 'Guest'){ echo $error_message; ?>


Comments ()

'; while($Comments = mysql_fetch_array($getComments)){ $getUserInfo = mysql_query("SELECT * FROM users WHERE id = '".$Comments['userid']."'"); $userInfo = mysql_fetch_array($getUserInfo); echo '
'; if($userInfo['rank'] > 5){ echo '
'; } if($userInfo['rank'] == 2){ echo '
'; } echo ' RE: '.$news_row['title'].'

'.$Comments['comment'].' Posted by '.$userInfo['name'].' on '.$Comments['posted_on'].'

'; } echo ''; } ?>