<?php
	require_once('includes/connection.php'); 

	$tbl_name='articles';		//your table name
	// How many adjacent pages should be shown on each side?
	$adjacents = 3;
	$targetpage = 'index.php';
	

	/* 
	   First get total number of rows in data table. 
	   If you have a WHERE clause in your query, make sure you mirror it here for pages in subdirectories. Right now we are just
	   counting total records in the
	   articles table.
	*/
	$query = "SELECT COUNT(*) as num FROM $tbl_name";
	$total_pages = mysql_fetch_array(mysql_query($query))or die(mysql_error());
	$total_pages = $total_pages['num'];
	
	$path_info = $_SERVER['PATH_INFO'];
		
	require_once("scripts/pagination_setup_vars.php");//sets up the page variables for the pagination script
	
		$limit = 9;
	
	/* Get all data from the articles table. */
	$sql = "SELECT * FROM $tbl_name ORDER BY reported_date DESC LIMIT $start, $limit" or die(mysql_error());
	$result = mysql_query($sql);

	require_once("scripts/articles_array_root.php");//contains the articles while and page output arrays. 
	require_once("scripts/pagination.php");//contains the pagination script
	require_once("scripts/footer_root.php");//contains the footer script
	require_once("scripts/sightings_menu_root.php");//contains the sightings menu script

	
	////////////
	
	/*************** UNIQUE URL CREATOR  
	$sql = "SELECT sid, location FROM sightings";
	$result = mysql_query($sql);
	while ($row = mysql_fetch_assoc($result))
	{
		$url_title = $row['location'];
		$url_title = strtolower($url_title);
		$url_title = str_replace(' ', '-', $url_title);
		$url_title = preg_replace('/[^a-z0-9\-]/', '', $url_title);
		do {
			$url_title = preg_replace('/\-\-/', '-', $url_title);
		} while (strpos($url_title, '--') !== FALSE);
		
		$url_title = rtrim($url_title, '-');
		$url_title = ltrim($url_title, '-');
		
		$url_title = substr($url_title, 0, 100);
		$sql = "UPDATE sightings SET `url_title` = '".mysql_real_escape_string($url_title)."' WHERE sid = ".$row['sid']." LIMIT 1";
		$r = mysql_query($sql);
	}
	die; */
	
	///////////

	$uri_segments = explode('/', $path_info);
	
	// Special case for bad howTo URLS
	
	if (in_array('howTo', $uri_segments))
	{
		show404();
	}
	
	if (count($uri_segments))
	{
		$last_segment = end($uri_segments);
		
		if (in_array($uri_segments[1], array('cicadas101', 'general', 'missions', 'howto', 'projects', 'rss', 'species')))
		{
			$sql = "SELECT aid, catid FROM $tbl_name WHERE url_title = '".mysql_real_escape_string($uri_segments[2])."'";
			$result = mysql_query($sql);
			$arr = mysql_fetch_assoc($result);
			if (mysql_num_rows($result) == 0) show404();
			$FRIENDLY_ID = $arr['aid'];
			
			$sql = "SELECT catdir FROM `categories` WHERE `catid` = ". $arr['catid'];
			$result = mysql_query($sql);
			$arr2 = mysql_fetch_assoc($result);
			$category_url = $arr2['catdir'];
			
			include $category_url.'/'.$category_url.'_details_friendly.php';
			exit;
		}
		elseif (in_array($uri_segments[1], array('sightings')))
		{
			$sql = "SELECT sid, scid FROM `sightings` WHERE url_title = '".mysql_real_escape_string($uri_segments[3])."'";
			$result = mysql_query($sql);
			$arr = mysql_fetch_assoc($result);
			if (mysql_num_rows($result) == 0) 
			{
				//print_r($uri_segments);
				//header('Location: ../');
				//exit;
				show404();
			}
			$FRIENDLY_ID = $arr['sid'];
			
			$sql = "SELECT sidDir FROM `scategories` WHERE `scid` = ". $arr['scid'];
			$result = mysql_query($sql);
			$arr2 = mysql_fetch_assoc($result);
			$category_url = $arr2['sidDir']; 
			
			include 'sightings/'.$category_url.'/'.$category_url.'_sightings_friendly.php';
			exit;
		}
		elseif (in_array($uri_segments[1], array('videos', 'wavs')))
		{
			show404();
		}
		elseif (isset($uri_segments[1]) && $uri_segments[1] != 'index.php')
		{
			//die(var_dump($uri_segments));
			show404();
		}
	}
?>

<?php
function curPageURL() {
 $pageURL = 'http';
 if ($_SERVER["HTTPS"] == "on") {$pageURL .= "s";}
 $pageURL .= "://";
 if ($_SERVER["SERVER_PORT"] != "80") {
  $pageURL .= $_SERVER["SERVER_NAME"].":".$_SERVER["SERVER_PORT"].$_SERVER["REQUEST_URI"];
 } else {
  $pageURL .= $_SERVER["SERVER_NAME"].$_SERVER["REQUEST_URI"];
 }
 return $pageURL;
}
?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Welcome to Massachusetts Cicadas</title>
<meta name="description" content="Massachusetts Cicadas is your source for news and information on annual and periodical cicadas broods in Massachusetts, New England and the United States. Submit your sightings, read articles or watch cicada and cicada killer videos." />
<meta property="og:title" content="Massachusetts Cicadas" />
<meta property="og:type" content="website" />
<meta property="og:url" content="<?php echo curPageURL();  ?>" />
<meta property="og:image" content="" />
<meta property="og:site_name" content="Massachusetts Cicadas" />
<meta property="og:description" content="Massachusetts Cicadas is your source for news and information on annual and periodical cicadas broods in Massachusetts, New England and the United States. Submit your sightings, read articles or watch cicada and cicada killer videos." />
<meta property="fb:app_id" content="237538246387103" />
<meta property="og:phone_number" content="978-866-8532"/>
<link href="css/main.css" rel="stylesheet" type="text/css" media="screen"/>
<script src="js/jquery-1.4.2.js" type="text/javascript"></script>
<script src="js/scripts.js" type="text/javascript"></script>
<script src="js/main.js" type="text/javascript"></script>
<script src="js/map.js" type="text/javascript"></script>
<script src="scripts/AC_RunActiveContent.js" type="text/javascript"></script>
</head>
<body>
<div id="pageWrap">
  <div id="actions">
    <h2><em>Dedicated to the Study of the Cicadas of Massachusetts and New England</em></h2>
    <ul>
      <li><a href="about.php" title="About Massachusetts Cicadas" class="left"><span class="ab">About</span></a></li>
      <li><a href="contact.php" title="Contact Massachusetts Cicadas"><span class="em">Contact</span></a></li>
      <li><a href="faq.php" title="Frequently Asked Questions"><span class="fq">FAQ</span></a></li>
      <li><a href="links.php" title="View Links to Websites" class="right"><span class="lk">Links</span></a></li>
    </ul>
  </div>
  <!--/ actions div -->
  <div id="header"> <img src="images/pageElements/header.jpg" title="Welcome To Massachusetts Cicadas" alt="Welcome To Massachusetts Cicadas" />
    <ul id="mainNav">
      <li><a href ="/" class="selected"><span>Home</span></a></li>
      <li><a href ="cicadas101/"><span>Cicadas 101</span></a></li>
      <li><a href ="general/"><span>General Info</span></a></li>
      <li><a href ="howto/"><span>How To</span></a></li>
      <li><a href ="missions/"><span>Missions</span></a></li>
      <li><a href ="projects/"><span>Projects</span></a></li>
      <!--<li><a href ="#"><span>Species</span></a></li>-->
      <li><a href ="sightings/"><span>Sightings</span></a></li>
      <li><a href ="videos/"><span>Videos</span></a></li>
    </ul>
  </div>
  <!--/ header div-->
  <div id="divider">&nbsp;</div>
  <!--/ divider div-->
  <div id="mainContent">
    <h1 class="home">Latest Cicada News</h1>
    <!--Call the php content here-->
    <?php echo $blogPage; ?> <?php echo $pagination; ?> </div>
  <!--/ mainContent div-->
  <div id="rightColumn">
    <h3><span>Random Cicada Video</span></h3>
    <div id="flashHolder">
      <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0','width','280','height','345','id','flashHome','align','middle','src','flashHome','quality','high','bgcolor','#f8f8f8','name','flashHome','allowscriptaccess','sameDomain','allowfullscreen','true','pluginspage','http://www.macromedia.com/go/getflashplayer','movie','flashHome' ); //end AC code
</script><noscript><object classid="clsid:d27cdb6e-ae6d-11cf-96b8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=9,0,0,0" width="280" height="345" id="flashHome" align="middle">
        <param name="allowScriptAccess" value="sameDomain" />
        <param name="allowFullScreen" value="true" />
        <param name="movie" value="flashHome.swf" />
        <param name="quality" value="high" />
        <param name="bgcolor" value="#f8f8f8" />
        <embed src="flashHome.swf" quality="high" bgcolor="#f8f8f8" width="280" height="345" name="flashHome" align="middle" allowscriptaccess="sameDomain" allowfullscreen="true" type="application/x-shockwave-flash" pluginspage="http://www.macromedia.com/go/getflashplayer" />
        </embed>
      </object></noscript>
    </div>
    <!--/ flashHolder div-->
   <?php require_once('includes/reports.html'); ?>
    <!--/ reports div-->
    <?php require_once('includes/share.html'); ?>
    <!--/ sharing div -->
    <div id="sightings">
      <h3><span>Latest Sightings</span></h3>
      <ul>
        <?php echo $sMenu; ?>
      </ul>
    </div>
    <!--/ sightings div -->
   <?php require_once('includes/broodi.html'); ?>
    <?php require_once('includes/broodxix.html'); ?>
    <!--/ broodxix div-->
    <?php require_once('includes/galleries.html'); ?>
    <!--/ galleries div-->
  </div>
  <!--/ rightColumn div-->
  <?php
  require_once("includes/footer_html.php");
  ?>
  <!--/footer div-->
</div>
<!--/ pageWrap Div-->
</body>
</html>