| 1 | 
        
            562
         | 
        
            Ruebenwurz
         | 
        <?php
  | 
      
      
        | 2 | 
        
         | 
        
         | 
        
  | 
      
      
        | 3 | 
        
         | 
        
         | 
        // $Id$
  | 
      
      
        | 4 | 
        
         | 
        
         | 
        
  | 
      
      
        | 5 | 
        
         | 
        
         | 
        /*
  | 
      
      
        | 6 | 
        
         | 
        
         | 
        
  | 
      
      
        | 7 | 
        
         | 
        
         | 
         Website Baker Project <http://www.websitebaker.org/>
  | 
      
      
        | 8 | 
        
         | 
        
         | 
         Copyright (C) 2004-2008, Ryan Djurovich
  | 
      
      
        | 9 | 
        
         | 
        
         | 
        
  | 
      
      
        | 10 | 
        
         | 
        
         | 
         Website Baker is free software; you can redistribute it and/or modify
  | 
      
      
        | 11 | 
        
         | 
        
         | 
         it under the terms of the GNU General Public License as published by
  | 
      
      
        | 12 | 
        
         | 
        
         | 
         the Free Software Foundation; either version 2 of the License, or
  | 
      
      
        | 13 | 
        
         | 
        
         | 
         (at your option) any later version.
  | 
      
      
        | 14 | 
        
         | 
        
         | 
        
  | 
      
      
        | 15 | 
        
         | 
        
         | 
         Website Baker is distributed in the hope that it will be useful,
  | 
      
      
        | 16 | 
        
         | 
        
         | 
         but WITHOUT ANY WARRANTY; without even the implied warranty of
  | 
      
      
        | 17 | 
        
         | 
        
         | 
         MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  | 
      
      
        | 18 | 
        
         | 
        
         | 
         GNU General Public License for more details.
  | 
      
      
        | 19 | 
        
         | 
        
         | 
        
  | 
      
      
        | 20 | 
        
         | 
        
         | 
         You should have received a copy of the GNU General Public License
  | 
      
      
        | 21 | 
        
         | 
        
         | 
         along with Website Baker; if not, write to the Free Software
  | 
      
      
        | 22 | 
        
         | 
        
         | 
         Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
  | 
      
      
        | 23 | 
        
         | 
        
         | 
        
  | 
      
      
        | 24 | 
        
         | 
        
         | 
        */
  | 
      
      
        | 25 | 
        
         | 
        
         | 
        
  | 
      
      
        | 26 | 
        
         | 
        
         | 
        // Must include code to stop this file being access directly
  | 
      
      
        | 27 | 
        
         | 
        
         | 
        if(defined('WB_PATH') == false) { exit("Cannot access this file directly"); }
 | 
      
      
        | 28 | 
        
         | 
        
         | 
        
  | 
      
      
        | 29 | 
        
         | 
        
         | 
        // check if frontend.css file needs to be included into the <body></body> of view.php
  | 
      
      
        | 30 | 
        
         | 
        
         | 
        if((!function_exists('register_frontend_modfiles') || !defined('MOD_FRONTEND_CSS_REGISTERED')) &&  file_exists(WB_PATH .'/modules/news/frontend.css')) {
 | 
      
      
        | 31 | 
        
         | 
        
         | 
           echo '<style type="text/css">';
  | 
      
      
        | 32 | 
        
         | 
        
         | 
           include(WB_PATH .'/modules/news/frontend.css');
  | 
      
      
        | 33 | 
        
         | 
        
         | 
           echo "\n</style>\n";
  | 
      
      
        | 34 | 
        
         | 
        
         | 
        }
  | 
      
      
        | 35 | 
        
         | 
        
         | 
        
  | 
      
      
        | 36 | 
        
         | 
        
         | 
        // Check if there is a start point defined
  | 
      
      
        | 37 | 
        
         | 
        
         | 
        if(isset($_GET['p']) AND is_numeric($_GET['p']) AND $_GET['p'] >= 0) {
 | 
      
      
        | 38 | 
        
         | 
        
         | 
        	$position = $_GET['p'];
  | 
      
      
        | 39 | 
        
         | 
        
         | 
        } else {
 | 
      
      
        | 40 | 
        
         | 
        
         | 
        	$position = 0;
  | 
      
      
        | 41 | 
        
         | 
        
         | 
        }
  | 
      
      
        | 42 | 
        
         | 
        
         | 
        
  | 
      
      
        | 43 | 
        
         | 
        
         | 
        // Get user's username, display name, email, and id - needed for insertion into post info
  | 
      
      
        | 44 | 
        
         | 
        
         | 
        $users = array();
  | 
      
      
        | 45 | 
        
         | 
        
         | 
        $query_users = $database->query("SELECT user_id,username,display_name,email FROM ".TABLE_PREFIX."users");
 | 
      
      
        | 46 | 
        
         | 
        
         | 
        if($query_users->numRows() > 0) {
 | 
      
      
        | 47 | 
        
         | 
        
         | 
        	while($user = $query_users->fetchRow()) {
 | 
      
      
        | 48 | 
        
         | 
        
         | 
        		// Insert user info into users array
  | 
      
      
        | 49 | 
        
         | 
        
         | 
        		$user_id = $user['user_id'];
  | 
      
      
        | 50 | 
        
         | 
        
         | 
        		$users[$user_id]['username'] = $user['username'];
  | 
      
      
        | 51 | 
        
         | 
        
         | 
        		$users[$user_id]['display_name'] = $user['display_name'];
  | 
      
      
        | 52 | 
        
         | 
        
         | 
        		$users[$user_id]['email'] = $user['email'];
  | 
      
      
        | 53 | 
        
         | 
        
         | 
        	}
  | 
      
      
        | 54 | 
        
         | 
        
         | 
        }
  | 
      
      
        | 55 | 
        
         | 
        
         | 
        
  | 
      
      
        | 56 | 
        
         | 
        
         | 
        // Get groups (title, if they are active, and their image [if one has been uploaded])
  | 
      
      
        | 57 | 
        
         | 
        
         | 
        $groups[0]['title'] = '';
  | 
      
      
        | 58 | 
        
         | 
        
         | 
        $groups[0]['active'] = true;
  | 
      
      
        | 59 | 
        
         | 
        
         | 
        $groups[0]['image'] = '';
  | 
      
      
        | 60 | 
        
         | 
        
         | 
        $query_users = $database->query("SELECT group_id,title,active FROM ".TABLE_PREFIX."mod_news_groups WHERE section_id = '$section_id' ORDER BY position ASC");
 | 
      
      
        | 61 | 
        
         | 
        
         | 
        if($query_users->numRows() > 0) {
 | 
      
      
        | 62 | 
        
         | 
        
         | 
        	while($group = $query_users->fetchRow()) {
 | 
      
      
        | 63 | 
        
         | 
        
         | 
        		// Insert user info into users array
  | 
      
      
        | 64 | 
        
         | 
        
         | 
        		$group_id = $group['group_id'];
  | 
      
      
        | 65 | 
        
         | 
        
         | 
        		$groups[$group_id]['title'] = ($group['title']);
  | 
      
      
        | 66 | 
        
         | 
        
         | 
        		$groups[$group_id]['active'] = $group['active'];
  | 
      
      
        | 67 | 
        
         | 
        
         | 
        		if(file_exists(WB_PATH.MEDIA_DIRECTORY.'/.news/image'.$group_id.'.jpg')) {
 | 
      
      
        | 68 | 
        
         | 
        
         | 
        			$groups[$group_id]['image'] = WB_URL.MEDIA_DIRECTORY.'/.news/image'.$group_id.'.jpg';
  | 
      
      
        | 69 | 
        
         | 
        
         | 
        		} else {
 | 
      
      
        | 70 | 
        
         | 
        
         | 
        			$groups[$group_id]['image'] = '';
  | 
      
      
        | 71 | 
        
         | 
        
         | 
        		}
  | 
      
      
        | 72 | 
        
         | 
        
         | 
        	}
  | 
      
      
        | 73 | 
        
         | 
        
         | 
        }
  | 
      
      
        | 74 | 
        
         | 
        
         | 
        
  | 
      
      
        | 75 | 
        
         | 
        
         | 
        // Check if we should show the main page or a post itself
  | 
      
      
        | 76 | 
        
         | 
        
         | 
        if(!defined('POST_ID') OR !is_numeric(POST_ID)) {
 | 
      
      
        | 77 | 
        
         | 
        
         | 
        
  | 
      
      
        | 78 | 
        
         | 
        
         | 
        	// Check if we should only list posts from a certain group
  | 
      
      
        | 79 | 
        
         | 
        
         | 
        	if(isset($_GET['g']) AND is_numeric($_GET['g'])) {
 | 
      
      
        | 80 | 
        
         | 
        
         | 
        		$query_extra = " AND group_id = '".$_GET['g']."'";
  | 
      
      
        | 81 | 
        
         | 
        
         | 
        	} else {
 | 
      
      
        | 82 | 
        
         | 
        
         | 
        		$query_extra = '';
  | 
      
      
        | 83 | 
        
         | 
        
         | 
        	}
  | 
      
      
        | 84 | 
        
         | 
        
         | 
        
  | 
      
      
        | 85 | 
        
         | 
        
         | 
        	// Get settings
  | 
      
      
        | 86 | 
        
         | 
        
         | 
        	$query_settings = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_news_settings WHERE section_id = '$section_id'");
 | 
      
      
        | 87 | 
        
         | 
        
         | 
        	if($query_settings->numRows() > 0) {
 | 
      
      
        | 88 | 
        
         | 
        
         | 
        		$fetch_settings = $query_settings->fetchRow();
  | 
      
      
        | 89 | 
        
         | 
        
         | 
        		$setting_header = ($fetch_settings['header']);
  | 
      
      
        | 90 | 
        
         | 
        
         | 
        		$setting_post_loop = ($fetch_settings['post_loop']);
  | 
      
      
        | 91 | 
        
         | 
        
         | 
        		$setting_footer = ($fetch_settings['footer']);
  | 
      
      
        | 92 | 
        
         | 
        
         | 
        		$setting_posts_per_page = $fetch_settings['posts_per_page'];
  | 
      
      
        | 93 | 
        
         | 
        
         | 
        	} else {
 | 
      
      
        | 94 | 
        
         | 
        
         | 
        		$setting_header = '';
  | 
      
      
        | 95 | 
        
         | 
        
         | 
        		$setting_post_loop = '';
  | 
      
      
        | 96 | 
        
         | 
        
         | 
        		$setting_footer = '';
  | 
      
      
        | 97 | 
        
         | 
        
         | 
        		$setting_posts_per_page = '';
  | 
      
      
        | 98 | 
        
         | 
        
         | 
        	}
  | 
      
      
        | 99 | 
        
         | 
        
         | 
        
  | 
      
      
        | 100 | 
        
         | 
        
         | 
        	// Get total number of posts
  | 
      
      
        | 101 | 
        
         | 
        
         | 
        	$query_total_num = $database->query("SELECT post_id FROM ".TABLE_PREFIX."mod_news_posts WHERE section_id = '$section_id' AND active = '1' AND title != ''$query_extra");
 | 
      
      
        | 102 | 
        
         | 
        
         | 
        	$total_num = $query_total_num->numRows();
  | 
      
      
        | 103 | 
        
         | 
        
         | 
        
  | 
      
      
        | 104 | 
        
         | 
        
         | 
        	// Work-out if we need to add limit code to sql
  | 
      
      
        | 105 | 
        
         | 
        
         | 
        	if($setting_posts_per_page != 0) {
 | 
      
      
        | 106 | 
        
         | 
        
         | 
        		$limit_sql = " LIMIT $position,$setting_posts_per_page";
  | 
      
      
        | 107 | 
        
         | 
        
         | 
        	} else {
 | 
      
      
        | 108 | 
        
         | 
        
         | 
        		$limit_sql = "";
  | 
      
      
        | 109 | 
        
         | 
        
         | 
        	}
  | 
      
      
        | 110 | 
        
         | 
        
         | 
        
  | 
      
      
        | 111 | 
        
         | 
        
         | 
        	// Query posts (for this page)
  | 
      
      
        | 112 | 
        
         | 
        
         | 
        	$query_posts = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_news_posts WHERE section_id = '$section_id' AND active = '1' AND title != ''$query_extra ORDER BY position DESC".$limit_sql);
 | 
      
      
        | 113 | 
        
         | 
        
         | 
        	$num_posts = $query_posts->numRows();
  | 
      
      
        | 114 | 
        
         | 
        
         | 
        
  | 
      
      
        | 115 | 
        
         | 
        
         | 
        	// Create previous and next links
  | 
      
      
        | 116 | 
        
         | 
        
         | 
        	if($setting_posts_per_page != 0) {
 | 
      
      
        | 117 | 
        
         | 
        
         | 
        		if($position > 0) {
 | 
      
      
        | 118 | 
        
         | 
        
         | 
        			if(isset($_GET['g']) AND is_numeric($_GET['g'])) {
 | 
      
      
        | 119 | 
        
         | 
        
         | 
        				$pl_prepend = '<a href="?p='.($position-$setting_posts_per_page).'&g='.$_GET['g'].'"><< ';
  | 
      
      
        | 120 | 
        
         | 
        
         | 
        			} else {
 | 
      
      
        | 121 | 
        
         | 
        
         | 
        				$pl_prepend = '<a href="?p='.($position-$setting_posts_per_page).'"><< ';
  | 
      
      
        | 122 | 
        
         | 
        
         | 
        			}
  | 
      
      
        | 123 | 
        
         | 
        
         | 
        			$pl_append = '</a>';
  | 
      
      
        | 124 | 
        
         | 
        
         | 
        			$previous_link = $pl_prepend.$TEXT['PREVIOUS'].$pl_append;
  | 
      
      
        | 125 | 
        
         | 
        
         | 
        			$previous_page_link = $pl_prepend.$TEXT['PREVIOUS_PAGE'].$pl_append;
  | 
      
      
        | 126 | 
        
         | 
        
         | 
        		} else {
 | 
      
      
        | 127 | 
        
         | 
        
         | 
        			$previous_link = '';
  | 
      
      
        | 128 | 
        
         | 
        
         | 
        			$previous_page_link = '';
  | 
      
      
        | 129 | 
        
         | 
        
         | 
        		}
  | 
      
      
        | 130 | 
        
         | 
        
         | 
        		if($position+$setting_posts_per_page >= $total_num) {
 | 
      
      
        | 131 | 
        
         | 
        
         | 
        			$next_link = '';
  | 
      
      
        | 132 | 
        
         | 
        
         | 
        			$next_page_link = '';
  | 
      
      
        | 133 | 
        
         | 
        
         | 
        		} else {
 | 
      
      
        | 134 | 
        
         | 
        
         | 
        			if(isset($_GET['g']) AND is_numeric($_GET['g'])) {
 | 
      
      
        | 135 | 
        
         | 
        
         | 
        				$nl_prepend = '<a href="?p='.($position+$setting_posts_per_page).'&g='.$_GET['g'].'"> ';
  | 
      
      
        | 136 | 
        
         | 
        
         | 
        			} else {
 | 
      
      
        | 137 | 
        
         | 
        
         | 
        				$nl_prepend = '<a href="?p='.($position+$setting_posts_per_page).'"> ';
  | 
      
      
        | 138 | 
        
         | 
        
         | 
        			}
  | 
      
      
        | 139 | 
        
         | 
        
         | 
        			$nl_append = ' >></a>';
  | 
      
      
        | 140 | 
        
         | 
        
         | 
        			$next_link = $nl_prepend.$TEXT['NEXT'].$nl_append;
  | 
      
      
        | 141 | 
        
         | 
        
         | 
        			$next_page_link = $nl_prepend.$TEXT['NEXT_PAGE'].$nl_append;
  | 
      
      
        | 142 | 
        
         | 
        
         | 
        		}
  | 
      
      
        | 143 | 
        
         | 
        
         | 
        		if($position+$setting_posts_per_page > $total_num) {
 | 
      
      
        | 144 | 
        
         | 
        
         | 
        			$num_of = $position+$num_posts;
  | 
      
      
        | 145 | 
        
         | 
        
         | 
        		} else {
 | 
      
      
        | 146 | 
        
         | 
        
         | 
        			$num_of = $position+$setting_posts_per_page;
  | 
      
      
        | 147 | 
        
         | 
        
         | 
        		}
  | 
      
      
        | 148 | 
        
         | 
        
         | 
        		$out_of = ($position+1).'-'.$num_of.' '.strtolower($TEXT['OUT_OF']).' '.$total_num;
  | 
      
      
        | 149 | 
        
         | 
        
         | 
        		$of = ($position+1).'-'.$num_of.' '.strtolower($TEXT['OF']).' '.$total_num;
  | 
      
      
        | 150 | 
        
         | 
        
         | 
        		$display_previous_next_links = '';
  | 
      
      
        | 151 | 
        
         | 
        
         | 
        	} else {
 | 
      
      
        | 152 | 
        
         | 
        
         | 
        		$display_previous_next_links = 'none';
  | 
      
      
        | 153 | 
        
         | 
        
         | 
        	}
  | 
      
      
        | 154 | 
        
         | 
        
         | 
        
  | 
      
      
        | 155 | 
        
         | 
        
         | 
        	// Print header
  | 
      
      
        | 156 | 
        
         | 
        
         | 
        	if($display_previous_next_links == 'none') {
 | 
      
      
        | 157 | 
        
         | 
        
         | 
        		echo  str_replace(array('[NEXT_PAGE_LINK]','[NEXT_LINK]','[PREVIOUS_PAGE_LINK]','[PREVIOUS_LINK]','[OUT_OF]','[OF]','[DISPLAY_PREVIOUS_NEXT_LINKS]'), array('','','','','','', $display_previous_next_links), $setting_header);
 | 
      
      
        | 158 | 
        
         | 
        
         | 
        	} else {
 | 
      
      
        | 159 | 
        
         | 
        
         | 
        		echo str_replace(array('[NEXT_PAGE_LINK]','[NEXT_LINK]','[PREVIOUS_PAGE_LINK]','[PREVIOUS_LINK]','[OUT_OF]','[OF]','[DISPLAY_PREVIOUS_NEXT_LINKS]'), array($next_page_link, $next_link, $previous_page_link, $previous_link, $out_of, $of, $display_previous_next_links), $setting_header);
 | 
      
      
        | 160 | 
        
         | 
        
         | 
        	}
  | 
      
      
        | 161 | 
        
         | 
        
         | 
        
  | 
      
      
        | 162 | 
        
         | 
        
         | 
        	if($num_posts > 0) {
 | 
      
      
        | 163 | 
        
         | 
        
         | 
        		if($query_extra != '') {
 | 
      
      
        | 164 | 
        
         | 
        
         | 
        			?>
  | 
      
      
        | 165 | 
        
         | 
        
         | 
        			<div class="selected_group_title">
  | 
      
      
        | 166 | 
        
         | 
        
         | 
        				<?php echo '<a href="'.$_SERVER['PHP_SELF'].'">'.PAGE_TITLE.'</a> >> '.$groups[$_GET['g']]['title']; ?>
  | 
      
      
        | 167 | 
        
         | 
        
         | 
        			</div>
  | 
      
      
        | 168 | 
        
         | 
        
         | 
        			<?php
  | 
      
      
        | 169 | 
        
         | 
        
         | 
        		}
  | 
      
      
        | 170 | 
        
         | 
        
         | 
        		while($post = $query_posts->fetchRow()) {
 | 
      
      
        | 171 | 
        
         | 
        
         | 
        			if(isset($groups[$post['group_id']]['active']) AND $groups[$post['group_id']]['active'] != false) { // Make sure parent group is active
 | 
      
      
        | 172 | 
        
         | 
        
         | 
        				$uid = $post['posted_by']; // User who last modified the post
  | 
      
      
        | 173 | 
        
         | 
        
         | 
        				// Workout date and time of last modified post
  | 
      
      
        | 174 | 
        
         | 
        
         | 
        				$post_date = gmdate(DATE_FORMAT, $post['posted_when']+TIMEZONE);
  | 
      
      
        | 175 | 
        
         | 
        
         | 
        				$post_time = gmdate(TIME_FORMAT, $post['posted_when']+TIMEZONE);
  | 
      
      
        | 176 | 
        
         | 
        
         | 
        				$publ_date = date(DATE_FORMAT,$post['published_when']);
  | 
      
      
        | 177 | 
        
         | 
        
         | 
        				// Work-out the post link
  | 
      
      
        | 178 | 
        
         | 
        
         | 
        				$post_link = page_link($post['link']);
  | 
      
      
        | 179 | 
        
         | 
        
         | 
        				if(isset($_GET['p']) AND $position > 0) {
 | 
      
      
        | 180 | 
        
         | 
        
         | 
        					$post_link .= '?p='.$position;
  | 
      
      
        | 181 | 
        
         | 
        
         | 
        				}
  | 
      
      
        | 182 | 
        
         | 
        
         | 
        				if(isset($_GET['g']) AND is_numeric($_GET['g'])) {
 | 
      
      
        | 183 | 
        
         | 
        
         | 
        					if(isset($_GET['p']) AND $position > 0) { $post_link .= '&'; } else { $post_link .= '?'; }
 | 
      
      
        | 184 | 
        
         | 
        
         | 
        					$post_link .= 'g='.$_GET['g'];
  | 
      
      
        | 185 | 
        
         | 
        
         | 
        				}
  | 
      
      
        | 186 | 
        
         | 
        
         | 
        				// Get group id, title, and image
  | 
      
      
        | 187 | 
        
         | 
        
         | 
        				$group_id = $post['group_id'];
  | 
      
      
        | 188 | 
        
         | 
        
         | 
        				$group_title = $groups[$group_id]['title'];
  | 
      
      
        | 189 | 
        
         | 
        
         | 
        				$group_image = $groups[$group_id]['image'];
  | 
      
      
        | 190 | 
        
         | 
        
         | 
        				if($group_image == '') { $display_image = 'none'; } else { $display_image = ''; }
 | 
      
      
        | 191 | 
        
         | 
        
         | 
        				if($group_id == 0) { $display_group = 'none'; } else { $display_group = ''; }
 | 
      
      
        | 192 | 
        
         | 
        
         | 
        				// Replace [wblink--PAGE_ID--] with real link
  | 
      
      
        | 193 | 
        
         | 
        
         | 
        				$short = ($post['content_short']);
  | 
      
      
        | 194 | 
        
         | 
        
         | 
        				$wb->preprocess($short);
  | 
      
      
        | 195 | 
        
         | 
        
         | 
        				// Replace vars with values
  | 
      
      
        | 196 | 
        
         | 
        
         | 
        				$post_long_len = strlen($post['content_long']);
  | 
      
      
        | 197 | 
        
         | 
        
         | 
        				$vars = array('[PAGE_TITLE]', '[GROUP_ID]', '[GROUP_TITLE]', '[GROUP_IMAGE]', '[DISPLAY_GROUP]', '[DISPLAY_IMAGE]', '[TITLE]', '[SHORT]', '[LINK]', '[MODI_DATE]', '[MODI_TIME]', '[PUBLISHED_DATE]', '[USER_ID]', '[USERNAME]', '[DISPLAY_NAME]', '[EMAIL]', '[TEXT_READ_MORE]');
 | 
      
      
        | 198 | 
        
         | 
        
         | 
        				if(isset($users[$uid]['username']) AND $users[$uid]['username'] != '') {
 | 
      
      
        | 199 | 
        
         | 
        
         | 
        					if($post_long_len < 9) {
 | 
      
      
        | 200 | 
        
         | 
        
         | 
        						$values = array(PAGE_TITLE, $group_id, $group_title, $group_image, $display_group, $display_image, $post['title'], $short, $post_link, $post_date, $post_time, $publ_date, $uid, $users[$uid]['username'], $users[$uid]['display_name'], $users[$uid]['email'], '');
  | 
      
      
        | 201 | 
        
         | 
        
         | 
        					} else {
 | 
      
      
        | 202 | 
        
         | 
        
         | 
        						$values = array(PAGE_TITLE, $group_id, $group_title, $group_image, $display_group, $display_image, $post['title'], $short, $post_link, $post_date, $post_time, $publ_date, $uid, $users[$uid]['username'], $users[$uid]['display_name'], $users[$uid]['email'], $TEXT['READ_MORE']);
  | 
      
      
        | 203 | 
        
         | 
        
         | 
        					}
  | 
      
      
        | 204 | 
        
         | 
        
         | 
        				} else {
 | 
      
      
        | 205 | 
        
         | 
        
         | 
        					if($post_long_len < 9) {
 | 
      
      
        | 206 | 
        
         | 
        
         | 
        						$values = array(PAGE_TITLE, $group_id, $group_title, $group_image, $display_group, $display_image, $post['title'], $short, $post_link, $post_date, $post_time, $publ_date, '', '', '', '', '');
  | 
      
      
        | 207 | 
        
         | 
        
         | 
        					} else {
 | 
      
      
        | 208 | 
        
         | 
        
         | 
        						$values = array(PAGE_TITLE, $group_id, $group_title, $group_image, $display_group, $display_image, $post['title'], $short, $post_link, $post_date, $post_time, $publ_date, '', '', '', '', $TEXT['READ_MORE']);
  | 
      
      
        | 209 | 
        
         | 
        
         | 
        					}
  | 
      
      
        | 210 | 
        
         | 
        
         | 
        				}
  | 
      
      
        | 211 | 
        
         | 
        
         | 
        				echo str_replace($vars, $values, $setting_post_loop);
  | 
      
      
        | 212 | 
        
         | 
        
         | 
        			}
  | 
      
      
        | 213 | 
        
         | 
        
         | 
        		}
  | 
      
      
        | 214 | 
        
         | 
        
         | 
        	}
  | 
      
      
        | 215 | 
        
         | 
        
         | 
        
  | 
      
      
        | 216 | 
        
         | 
        
         | 
        	// Print footer
  | 
      
      
        | 217 | 
        
         | 
        
         | 
        	if($display_previous_next_links == 'none') {
 | 
      
      
        | 218 | 
        
         | 
        
         | 
        		echo  str_replace(array('[NEXT_PAGE_LINK]','[NEXT_LINK]','[PREVIOUS_PAGE_LINK]','[PREVIOUS_LINK]','[OUT_OF]','[OF]','[DISPLAY_PREVIOUS_NEXT_LINKS]'), array('','','','','','', $display_previous_next_links), $setting_footer);
 | 
      
      
        | 219 | 
        
         | 
        
         | 
        	} else {
 | 
      
      
        | 220 | 
        
         | 
        
         | 
        		echo str_replace(array('[NEXT_PAGE_LINK]','[NEXT_LINK]','[PREVIOUS_PAGE_LINK]','[PREVIOUS_LINK]','[OUT_OF]','[OF]','[DISPLAY_PREVIOUS_NEXT_LINKS]'), array($next_page_link, $next_link, $previous_page_link, $previous_link, $out_of, $of, $display_previous_next_links), $setting_footer);
 | 
      
      
        | 221 | 
        
         | 
        
         | 
        	}
  | 
      
      
        | 222 | 
        
         | 
        
         | 
        
  | 
      
      
        | 223 | 
        
         | 
        
         | 
        } elseif(defined('POST_ID') AND is_numeric(POST_ID)) {
 | 
      
      
        | 224 | 
        
         | 
        
         | 
        
  | 
      
      
        | 225 | 
        
         | 
        
         | 
        	// Get settings
  | 
      
      
        | 226 | 
        
         | 
        
         | 
        	$query_settings = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_news_settings WHERE section_id = '$section_id'");
 | 
      
      
        | 227 | 
        
         | 
        
         | 
        	if($query_settings->numRows() > 0) {
 | 
      
      
        | 228 | 
        
         | 
        
         | 
        		$fetch_settings = $query_settings->fetchRow();
  | 
      
      
        | 229 | 
        
         | 
        
         | 
        		$setting_post_header = ($fetch_settings['post_header']);
  | 
      
      
        | 230 | 
        
         | 
        
         | 
        		$setting_post_footer = ($fetch_settings['post_footer']);
  | 
      
      
        | 231 | 
        
         | 
        
         | 
        		$setting_comments_header = ($fetch_settings['comments_header']);
  | 
      
      
        | 232 | 
        
         | 
        
         | 
        		$setting_comments_loop = ($fetch_settings['comments_loop']);
  | 
      
      
        | 233 | 
        
         | 
        
         | 
        		$setting_comments_footer = ($fetch_settings['comments_footer']);
  | 
      
      
        | 234 | 
        
         | 
        
         | 
        	} else {
 | 
      
      
        | 235 | 
        
         | 
        
         | 
        		$setting_post_header = '';
  | 
      
      
        | 236 | 
        
         | 
        
         | 
        		$setting_post_footer = '';
  | 
      
      
        | 237 | 
        
         | 
        
         | 
        		$setting_comments_header = '';
  | 
      
      
        | 238 | 
        
         | 
        
         | 
        		$setting_comments_loop = '';
  | 
      
      
        | 239 | 
        
         | 
        
         | 
        		$setting_comments_footer = '';
  | 
      
      
        | 240 | 
        
         | 
        
         | 
        	}
  | 
      
      
        | 241 | 
        
         | 
        
         | 
        
  | 
      
      
        | 242 | 
        
         | 
        
         | 
        	// Get page info
  | 
      
      
        | 243 | 
        
         | 
        
         | 
        	$query_page = $database->query("SELECT link FROM ".TABLE_PREFIX."pages WHERE page_id = '".PAGE_ID."'");
 | 
      
      
        | 244 | 
        
         | 
        
         | 
        	if($query_page->numRows() > 0) {
 | 
      
      
        | 245 | 
        
         | 
        
         | 
        		$page = $query_page->fetchRow();
  | 
      
      
        | 246 | 
        
         | 
        
         | 
        		$page_link = page_link($page['link']);
  | 
      
      
        | 247 | 
        
         | 
        
         | 
        		if(isset($_GET['p']) AND $position > 0) {
 | 
      
      
        | 248 | 
        
         | 
        
         | 
        			$page_link .= '?p='.$_GET['p'];
  | 
      
      
        | 249 | 
        
         | 
        
         | 
        		}
  | 
      
      
        | 250 | 
        
         | 
        
         | 
        		if(isset($_GET['g']) AND is_numeric($_GET['g'])) {
 | 
      
      
        | 251 | 
        
         | 
        
         | 
        			if(isset($_GET['p']) AND $position > 0) { $page_link .= '&'; } else { $page_link .= '?'; }
 | 
      
      
        | 252 | 
        
         | 
        
         | 
        			$page_link .= 'g='.$_GET['g'];
  | 
      
      
        | 253 | 
        
         | 
        
         | 
        		}
  | 
      
      
        | 254 | 
        
         | 
        
         | 
        	} else {
 | 
      
      
        | 255 | 
        
         | 
        
         | 
        		exit('Page not found');
 | 
      
      
        | 256 | 
        
         | 
        
         | 
        	}
  | 
      
      
        | 257 | 
        
         | 
        
         | 
        
  | 
      
      
        | 258 | 
        
         | 
        
         | 
        	// Get post info
  | 
      
      
        | 259 | 
        
         | 
        
         | 
        	$query_post = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_news_posts WHERE post_id = '".POST_ID."' AND active = '1'");
 | 
      
      
        | 260 | 
        
         | 
        
         | 
        	if($query_post->numRows() > 0) {
 | 
      
      
        | 261 | 
        
         | 
        
         | 
        		$post = $query_post->fetchRow();
  | 
      
      
        | 262 | 
        
         | 
        
         | 
        		if(isset($groups[$post['group_id']]['active']) AND $groups[$post['group_id']]['active'] != false) { // Make sure parent group is active
 | 
      
      
        | 263 | 
        
         | 
        
         | 
        			$uid = $post['posted_by']; // User who last modified the post
  | 
      
      
        | 264 | 
        
         | 
        
         | 
        			// Workout date and time of last modified post
  | 
      
      
        | 265 | 
        
         | 
        
         | 
        			$post_date = gmdate(DATE_FORMAT, $post['posted_when']+TIMEZONE);
  | 
      
      
        | 266 | 
        
         | 
        
         | 
        			$post_time = gmdate(TIME_FORMAT, $post['posted_when']+TIMEZONE);
  | 
      
      
        | 267 | 
        
         | 
        
         | 
        			$publ_date = date(DATE_FORMAT,$post['published_when']);
  | 
      
      
        | 268 | 
        
         | 
        
         | 
        			// Get group id, title, and image
  | 
      
      
        | 269 | 
        
         | 
        
         | 
        			$group_id = $post['group_id'];
  | 
      
      
        | 270 | 
        
         | 
        
         | 
        			$group_title = $groups[$group_id]['title'];
  | 
      
      
        | 271 | 
        
         | 
        
         | 
        			$group_image = $groups[$group_id]['image'];
  | 
      
      
        | 272 | 
        
         | 
        
         | 
        			if($group_image == '') { $display_image = 'none'; } else { $display_image = ''; }
 | 
      
      
        | 273 | 
        
         | 
        
         | 
        			if($group_id == 0) { $display_group = 'none'; } else { $display_group = ''; }
 | 
      
      
        | 274 | 
        
         | 
        
         | 
        			$vars = array('[PAGE_TITLE]', '[GROUP_ID]', '[GROUP_TITLE]', '[GROUP_IMAGE]', '[DISPLAY_GROUP]', '[DISPLAY_IMAGE]', '[TITLE]', '[SHORT]', '[BACK]', '[MODI_DATE]', '[MODI_TIME]', '[PUBL_DATE]', '[USER_ID]', '[USERNAME]', '[DISPLAY_NAME]', '[EMAIL]');
 | 
      
      
        | 275 | 
        
         | 
        
         | 
        			$post_short=$post['content_short'];
  | 
      
      
        | 276 | 
        
         | 
        
         | 
        			$wb->preprocess($post_short);
  | 
      
      
        | 277 | 
        
         | 
        
         | 
        			if(isset($users[$uid]['username']) AND $users[$uid]['username'] != '') {
 | 
      
      
        | 278 | 
        
         | 
        
         | 
        				$values = array(PAGE_TITLE, $group_id, $group_title, $group_image, $display_group, $display_image, $post['title'], $post_short, $page_link, $post_date, $post_time, $publ_date, $uid, $users[$uid]['username'], $users[$uid]['display_name'], $users[$uid]['email']);
  | 
      
      
        | 279 | 
        
         | 
        
         | 
        			} else {
 | 
      
      
        | 280 | 
        
         | 
        
         | 
        				$values = array(PAGE_TITLE, $group_id, $group_title, $group_image, $display_group, $display_image, $post['title'], $post_short, $page_link, $post_date, $post_time, $publ_date, '', '', '', '');
  | 
      
      
        | 281 | 
        
         | 
        
         | 
        			}
  | 
      
      
        | 282 | 
        
         | 
        
         | 
        			$post_long = ($post['content_long']);
  | 
      
      
        | 283 | 
        
         | 
        
         | 
        		}
  | 
      
      
        | 284 | 
        
         | 
        
         | 
        	} else {
 | 
      
      
        | 285 | 
        
         | 
        
         | 
        		header("Location: ".WB_URL.PAGES_DIRECTORY."");
 | 
      
      
        | 286 | 
        
         | 
        
         | 
        		exit(0);
  | 
      
      
        | 287 | 
        
         | 
        
         | 
        	}
  | 
      
      
        | 288 | 
        
         | 
        
         | 
        
  | 
      
      
        | 289 | 
        
         | 
        
         | 
        	// Print post header
  | 
      
      
        | 290 | 
        
         | 
        
         | 
        	echo str_replace($vars, $values, $setting_post_header);
  | 
      
      
        | 291 | 
        
         | 
        
         | 
        
  | 
      
      
        | 292 | 
        
         | 
        
         | 
        	// Replace [wblink--PAGE_ID--] with real link
  | 
      
      
        | 293 | 
        
         | 
        
         | 
          	$wb->preprocess($post_long);
  | 
      
      
        | 294 | 
        
         | 
        
         | 
        	// Print long
  | 
      
      
        | 295 | 
        
         | 
        
         | 
        	echo $post_long;
  | 
      
      
        | 296 | 
        
         | 
        
         | 
        
  | 
      
      
        | 297 | 
        
         | 
        
         | 
        	// Print post footer
  | 
      
      
        | 298 | 
        
         | 
        
         | 
        	echo str_replace($vars, $values, $setting_post_footer);
  | 
      
      
        | 299 | 
        
         | 
        
         | 
        
  | 
      
      
        | 300 | 
        
         | 
        
         | 
        	// Show comments section if we have to
  | 
      
      
        | 301 | 
        
         | 
        
         | 
        	if($post['commenting'] == 'private' AND isset($admin) AND $admin->is_authenticated() == true OR $post['commenting'] == 'public') {
 | 
      
      
        | 302 | 
        
         | 
        
         | 
        
  | 
      
      
        | 303 | 
        
         | 
        
         | 
        		// Print comments header
  | 
      
      
        | 304 | 
        
         | 
        
         | 
        		echo str_replace('[ADD_COMMENT_URL]', WB_URL.'/modules/news/comment.php?id='.POST_ID, $setting_comments_header);
 | 
      
      
        | 305 | 
        
         | 
        
         | 
        
  | 
      
      
        | 306 | 
        
         | 
        
         | 
        		// Query for comments
  | 
      
      
        | 307 | 
        
         | 
        
         | 
        		$query_comments = $database->query("SELECT title,comment,commented_when,commented_by FROM ".TABLE_PREFIX."mod_news_comments WHERE post_id = '".POST_ID."' ORDER BY commented_when ASC");
 | 
      
      
        | 308 | 
        
         | 
        
         | 
        		if($query_comments->numRows() > 0) {
 | 
      
      
        | 309 | 
        
         | 
        
         | 
        			while($comment = $query_comments->fetchRow()) {
 | 
      
      
        | 310 | 
        
         | 
        
         | 
        				// Display Comments without slashes, but with new-line characters
  | 
      
      
        | 311 | 
        
         | 
        
         | 
        				$comment['comment'] = nl2br(($comment['comment']));
  | 
      
      
        | 312 | 
        
         | 
        
         | 
        				$comment['title'] = ($comment['title']);
  | 
      
      
        | 313 | 
        
         | 
        
         | 
        				// Print comments loop
  | 
      
      
        | 314 | 
        
         | 
        
         | 
        				$commented_date = gmdate(DATE_FORMAT, $comment['commented_when']+TIMEZONE);
  | 
      
      
        | 315 | 
        
         | 
        
         | 
        				$commented_time = gmdate(TIME_FORMAT, $comment['commented_when']+TIMEZONE);
  | 
      
      
        | 316 | 
        
         | 
        
         | 
        				$uid = $comment['commented_by'];
  | 
      
      
        | 317 | 
        
         | 
        
         | 
        				$vars = array('[TITLE]','[COMMENT]','[DATE]','[TIME]','[USER_ID]','[USERNAME]','[DISPLAY_NAME]', '[EMAIL]');
 | 
      
      
        | 318 | 
        
         | 
        
         | 
        				if(isset($users[$uid]['username']) AND $users[$uid]['username'] != '') {
 | 
      
      
        | 319 | 
        
         | 
        
         | 
        					$values = array(($comment['title']), ($comment['comment']), $commented_date, $commented_time, $uid, ($users[$uid]['username']), ($users[$uid]['display_name']), ($users[$uid]['email']));
  | 
      
      
        | 320 | 
        
         | 
        
         | 
        				} else {
 | 
      
      
        | 321 | 
        
         | 
        
         | 
        					$values = array(($comment['title']), ($comment['comment']), $commented_date, $commented_time, '0', strtolower($TEXT['UNKNOWN']), $TEXT['UNKNOWN'], '');
  | 
      
      
        | 322 | 
        
         | 
        
         | 
        				}
  | 
      
      
        | 323 | 
        
         | 
        
         | 
        				echo str_replace($vars, $values, $setting_comments_loop);
  | 
      
      
        | 324 | 
        
         | 
        
         | 
        			}
  | 
      
      
        | 325 | 
        
         | 
        
         | 
        		} else {
 | 
      
      
        | 326 | 
        
         | 
        
         | 
        			// Say no comments found
  | 
      
      
        | 327 | 
        
         | 
        
         | 
        			if(isset($TEXT['NONE_FOUND'])) {
 | 
      
      
        | 328 | 
        
         | 
        
         | 
        				echo $TEXT['NONE_FOUND'].'<br />';
  | 
      
      
        | 329 | 
        
         | 
        
         | 
        			} else {
 | 
      
      
        | 330 | 
        
         | 
        
         | 
        				echo 'None Found<br />';
  | 
      
      
        | 331 | 
        
         | 
        
         | 
        			}
  | 
      
      
        | 332 | 
        
         | 
        
         | 
        		}
  | 
      
      
        | 333 | 
        
         | 
        
         | 
        
  | 
      
      
        | 334 | 
        
         | 
        
         | 
        		// Print comments footer
  | 
      
      
        | 335 | 
        
         | 
        
         | 
        		echo str_replace('[ADD_COMMENT_URL]', WB_URL.'/modules/news/comment.php?id='.POST_ID, $setting_comments_footer);
 | 
      
      
        | 336 | 
        
         | 
        
         | 
        
  | 
      
      
        | 337 | 
        
         | 
        
         | 
        	}
  | 
      
      
        | 338 | 
        
         | 
        
         | 
        
  | 
      
      
        | 339 | 
        
         | 
        
         | 
        }
  | 
      
      
        | 340 | 
        
         | 
        
         | 
        
  | 
      
      
        | 341 | 
        
         | 
        
         | 
        ?>
  |