<?php

// Smarty & PHP Variables
require_once('includes/smarty_include.php');

// User Tracking
include 'classes/pulse.php';

// Error Reporting
error_reporting(0);

switch ($_GET['section'])
{
default:
	if (isset($_GET['id']))
		{
			// PULL ARCHIVE ISSUE INFO
			$issue_id_query = "SELECT * FROM `" . $table_prefix ."_issues` WHERE id = " . $_GET['id'];
			$issue_id_result = $sqlManager->getResults($issue_id_query);
			$issue_id = $issue_id_result[0][0];
			
			// PULL ARCHIVE SNIPPET INFO
			$issue_info_query = "SELECT `id`,
										`issue_id`,
										`snippet_date`,
										`snippet_title`,
										`snippet_body`,
										`snippet_order` FROM `" . $table_prefix . "_snippets` WHERE issue_id = " . $issue_id . " ORDER BY `snippet_order` DESC;";
			$issue_info_result = $sqlManager->getResults($issue_info_query);
			$smarty-assign('issue_num',$issue_info_result[0][1]);
		}
	else
		{
			// PULL LATEST ISSUE DATE
			$issue_date_query = "SELECT MAX(`issue_date`) FROM `" . $table_prefix . "_issues` WHERE `active` = 1";
			$issue_date_result = $sqlManager->getResults($issue_date_query);
			$issue_date = $issue_date_result[0][0];
					
			// PULL LATEST ISSUE ID
			$issue_id_query = "SELECT `id`  FROM `" . $table_prefix . "_issues` WHERE issue_date = " . $issue_date;
			$issue_id_result = $sqlManager->getResults($issue_id_query);
			$issue_id = $issue_id_result[0][0];
			
			// PULL ALL INFO ABOUT THE LATEST ISSUE
			$issue_info_query  = "SELECT `id`,
										`issue_id`,
										`snippet_date`,
										`snippet_title`,
										`snippet_body`,
										`snippet_order` FROM `" . $table_prefix . "_snippets` WHERE issue_id = " . $issue_id . " ORDER BY `snippet_order` DESC;";
			$issue_info_result = $sqlManager->getResults($issue_info_query);
			$smarty->assign('issue_num',$issue_info_result[0][1]);
		}
		
	$smarty->assign('snippet',$issue_info_result);
	$smarty->assign('issue_date',$issue_date);
	break;
	
case 'subscribe':
	echo 'Subscribe';
break;

case 'archive':
	echo 'Archive';
break;

}

// DISPLAY THE BIG TEMPLATE, WITH WHATEVER SUB-TEMPLATE THAT WAS SELECTED FROM ALL THE SHIT ABOVE
$index_template = $template_name . '/index.tpl';
$smarty->display($index_template); 

?>