gistfile1.txt

	<div id="LeftBlogs">
 
 	<div id="BlogList">
     	<ul>
         	
         	<li class="<?php if(!empty($_GET['sort']) && $_GET['sort'] != 'date') { echo "un"; } ?>Highlighted round_10px"><a href="Blogs.php?sort=date">Date</a></li>
       
             <li class="<?php if($_GET['sort'] != 'popular') { echo "un"; } ?>Highlighted round_10px"><a href="Blogs.php?sort=popular">Most Popular</a></li>
            
         </ul>
     </div>
     
     
     
     <?php 


		
			if(!empty($_GET['subBlogSearch'])) {
				$query = "SELECT `id`, MATCH (`blogTitle`,`blogBody`) AGAINST ('" . mysql_real_escape_string($_GET['BlogSearch']) . "') AS `Relevance` FROM `cysticBlogs`  WHERE MATCH (`blogTitle`,`blogBody`) AGAINST ('" . mysql_real_escape_string($_GET['BlogSearch']) .  "') AND `status` != 'dead' ";
				
				if(empty($_GET['sort']) || $_GET['sort'] == 'date')  {
				$query .= "ORDER BY `Relevance` ASC ";
				
				}elseif($_GET['sort'] == 'popular') {
					$query .= "ORDER BY `Views` DESC ";
				
					
				
				}
				
			}else{
				$query = "SELECT `id` FROM `cysticBlogs` WHERE `status` != 'dead' ";
				if(!empty($_GET['cat']) && $_GET['cat'] != "All") {
					$query .= "&& `Category` = '" .  mysql_real_escape_string($_GET['cat']) . "' "; 
				}
				
				if(empty($_GET['sort']) || $_GET['sort'] == 'date') {
				$query .= "ORDER BY `date` DESC, `time` DESC ";
				
				}elseif($_GET['sort'] == 'popular') {
					$query .= "ORDER BY `Views` DESC ";
				}
			}
			
			
				
	
				
				//find out how many
				$request = mysql_query($query,$connection) or die(mysql_error());
				$totalBlogs = @mysql_num_rows($request);
				
				if(!empty($_GET['page'])) {
					$query .= "LIMIT " . mysql_real_escape_string($_GET['page']) . ",10" ;
				}else{
					$query .= "LIMIT 10" ;
					
				}
             $request = mysql_query($query,$connection) or die(mysql_error());
				
             while($result = mysql_fetch_array($request)) {
					
				
					$blog = new Blog($result['id']);
					$author = new User($blog->author);
					
					
					
					echo "<div class='future_mother_blog_archive_house'>";
					echo "<div id='future_blog_archive_body' class='round_10px'>";
				
					echo "<div class='all_name_pic round_10px'>";
					echo "<a href='" . $author->url() . "'>";
					echo "<img src='" . $author->img('mini') . "' border='0' />";
					echo "</a>";
					echo "<div class='AllBlogName_future'>";
					echo "<div class='written'>";
					echo "written by";
					echo "</div>";
					echo "<a href='" . $author->url() . "'>";
					echo strip_tags(stripslashes($author->first_name." ".$author->last_name));
					echo "</a>";
					echo "<div class='dateBlogArch'>";
					echo "on " . date("M d, Y",strtotime($blog->date));
					echo "</div>";
					echo "</div>";
					echo "</div>";
					echo "<div id='AllBlogArchiveTitle'>";
					echo "<div class='blogIcon'>";
					echo "<a href='" . $blog->url() . "'>";
					echo "<img src='styles/images/blogIcon.png' border='0'/>";
					echo "</a>";
					echo "</div>";
					echo "<a href='" . $blog->url() . "'>";
					if(strlen($blog->title) > 65) { echo substr(stripslashes(strip_tags($blog->title)),0,65) . "..."; }else{ echo stripslashes(strip_tags($blog->title)); }
					echo "</a>";
					echo "<div id='all_cat_future'>";
					echo $blog->category();
					echo "</div>";
					echo "</div>";
					echo "<div id='AllBlogArchiveStats'>";
					echo "<span class='AllBlogPipes'>";
					echo "<span class='AllBlogPipes'>";
					echo $blog->views;
					echo " Views ";
					echo "</span>";
					echo " &bull; ";
					echo "<span class='AllBlogPipes'>";
					echo " " . $blog->total_comments();
					echo " Comments ";
					echo "</span>";
					echo "</div>";
					echo "</div>";
					echo "<div class='future_blog_blurb'>";
					if(strlen($blog->body) > 300) { echo substr(stripslashes(strip_tags($blog->body)),0,300) . "..."; }else{ echo stripslashes(strip_tags($blog->body)); }
					echo "<br /><br />";
						?>
						<script src="http://connect.facebook.net/en_US/all.js#xfbml=1"></script><fb:like href="http://www.cysticlife.org/BlogProfile.php?id=<?php echo $blog->id; ?>" show_faces="true" width="400" font=""></fb:like>
						<?php
					echo "<div class='blurbLinks'>";
					echo "<a href='" . $blog->url() . "'><br />read more</a>";
					if($auth->id == $author->id) { echo " <a href='EditBlog.php?id=" . $blog->id . "'>edit</a> <a href='#' onclick='confirmation(\"BlogAllDeleteConfirm.php?id=" . $result['id'] ."\");'>delete</a>";}
					echo "</div>";
					echo "</div>";
					echo "</div>";
					
					}
			?>
					
				
     
     
     
     <div id="all_page_turn">
             <ul>
             
             	<?php if($totalBlogs > 10 && $_GET['page'] >= 10) { ?>
                 <li class="PreviousPageBlog round_10px">
                     <a href="Blogs.php?id=<?php echo $userID; ?>&cat=<?php echo $_GET['cat']; ?>&sort=<?php echo $_GET['sort']; ?>&page=<?php echo ($_GET['page'] - 10); ?>">Previous Page</a>
                 </li>
                 <?php } ?>
                 
                 <?php if($totalBlogs > 10 && $_GET['page'] < ($totalBlogs-10)) { ?>
                 <li class="NextPageBlog round_10px">
                     <a href="Blogs.php?id=<?php echo $userID; ?>&cat=<?php echo $_GET['cat']; ?>&sort=<?php echo $_GET['sort']; ?>&page=<?php echo ($_GET['page'] + 10); ?>">Next Page</a>
                 </li>
                 <?php } ?>
                 
             </ul>
     	</div>
         
</div>

<div id="RightBlogs">
		<div id="search_blogs_future" class="round_10px">
     	<form name="searchBlogs" action="Blogs.php" method="get">
         	<input type="text" name="BlogSearch" class="text" value="<?php if(empty($_GET['BlogSearch'])) { echo "Search Blogs"; }else{ echo $_GET['BlogSearch'];} ?>" onclick="clearify(this);" />
             <input type="submit" name="subBlogSearch" value="Search" />
         </form>
     </div>
     <div class='<?php if(empty($_GET['cat']) || $_GET['cat'] == "All") { echo "all_blog_cats_Highlighted"; }else{ echo "all_blog_cats_unHighlighted"; } ?> round_10px'>
         	<a href='Blogs.php?id=<?php echo $userID; ?>cat=All'>
             All
             </a>
         </div>
      
     <?php 
				 $query = "SELECT * FROM `cysticCategories_blogs` ORDER BY CategoryName ASC";
				 $request = mysql_query($query,$connection) or die(mysql_error());
				 while($result = mysql_fetch_array($request)) {
				 
				 	if(!empty($_GET['cat'])) { 
					
						if($_GET['cat'] == $result['id']) {
							$className = "all_blog_cats_Highlighted";
						}else{
							$className = "all_blog_cats_unHighlighted";
						}
					
					}else{
						
						$className = "all_blog_cats_unHighlighted";
						
					}
				 
					 echo "<div class='" . $className . " round_10px'>";
					 echo "<a href='Blogs.php?cat=".$result['id']."'>";
					 echo $result['CategoryName'];
					 echo "</a>";
					 echo "</div>";
				 
				 
			
				}
		
		
		?>
		
     <div id="most_all_future">
     	<div id="most_all_title" class="round_10px">
         	Top Bloggers
        	</div>
    <table>		
     	<tr>
			<?php
			$author_count = 0;
			$query = "SELECT `Author`,COUNT(`id`) FROM `cysticBlogs` WHERE `status` = 'active' GROUP BY `Author` ORDER BY COUNT(`id`) DESC LIMIT 8";
			$request = mysql_query($query,$connection);
			while($result = mysql_fetch_array($request)) {
				$author_count++;
				
				$author = new User($result['Author']);
			?>
         	<td class="topCommentPic round_10px">
					<a href="<?php echo $author->url(); ?>">
             		<img src="<?php echo $author->img('mini'); ?>" border="0" />
					</a>
                 <div class="topCommentName">
						<a href="<?php echo $author->url(); ?>">
                 		<?php echo $author->first_name; ?><br /><?php echo $author->last_name; ?>
						</a>
                 </div>
             </td>
				
			<?php
				if($author_count == 4) { echo "</tr><tr>"; $author_count = 0;}
			}
			if($author_count < 4) {
				for($author_count;$author_count<4;$author_count++) {
					echo "<td></td>";
				}
				echo "</tr>";
			}
			?>
		</tr>
      </table>
     </div>
     <div id="most_all_future">
     	<div id="most_all_title" class="round_10px">
         	Top Commenters
        	</div>
    		<table>
     		<tr>
         		<?php
					$author_count = 0;
					$query = "SELECT `userID`,(SELECT `Status` FROM `cysticUsers` WHERE `id` = `userID` LIMIT 1) AS `status`, COUNT(`id`) FROM `cysticBlogComments` WHERE `status` = 'active' GROUP BY `userID` ORDER BY COUNT(`id`) DESC LIMIT 8";
					$request = mysql_query($query,$connection);
					while($result = mysql_fetch_array($request)) {
						$commenter_count++;

						$commenter = new User($result['userID']);
					?>
		            	<td class="topCommentPic round_10px">
							<a href="<?php echo $commenter->url(); ?>">
		                		<img src="<?php echo $commenter->img('mini'); ?>" border="0" />
							</a>
		                    <div class="topCommentName">
								<a href="<?php echo $commenter->url(); ?>">
		                    		<?php echo $commenter->first_name; ?><br /><?php echo $commenter->last_name; ?>
								</a>
		                    </div>
		                </td>
					<?php
						if($commenter_count == 4) { echo "</tr><tr>"; $commenter_count = 0;}
					}
					if($commenter_count < 4) {
						for($commenter_count;$commenter_count<4;$commenter_count++) {
							echo "<td></td>";
						}
						echo "</tr>";
					}
					?>
				</tr>
      	</table>
    </div>
</div>