adds_block('INTERNAL',array('exi'=>1)); $getpost = "SELECT * FROM updates WHERE slug = \"" . urldecode($_GET['post']) . "\""; $getpost2 = mysql_query($getpost); $getpost3 = mysql_fetch_array($getpost2); if ($getpost3['slug'] == urldecode($_GET['post'])) { updatePop($getpost3['id'],'views'); $title = stripslashes(htmlentities($getpost3['title'])) . ' - Blog Archive'; $getback = "SELECT * FROM updates WHERE id < " . $getpost3['id'] . " ORDER BY id DESC LIMIT 0,1"; $getback2 = mysql_query($getback); $getback3 = mysql_fetch_array($getback2); if (isset($getback3['title'])) { $template->adds_block('BACK', array( 'CODED' => $getback3['slug'], 'TITLE' => htmlentities($getback3['title']))); } $getnext = "SELECT * FROM updates WHERE id > " . $getpost3['id'] . " ORDER BY id ASC LIMIT 0,1"; $getnext2 = mysql_query($getnext); $getnext3 = mysql_fetch_array($getnext2); if (isset($getnext3['title'])) { $template->adds_block('NEXT', array( 'CODED' => $getnext3['slug'], 'TITLE' => htmlentities($getnext3['title']))); } $template->add_ref(0, 'POST', array( 'ID' => $getpost3['id'], 'YEARID' => ((date('Y',strtotime($getpost3['pubDate']))-2006) % 4), 'DATE' => date('F jS Y \a\\t g:i:s a',strtotime($getpost3['pubDate'])), 'MONTH' => date('M',strtotime($getpost3['pubDate'])), 'DAY' => date('d',strtotime($getpost3['pubDate'])), 'CODED' => $getpost3['slug'], 'TITLE' => htmlentities($getpost3['title']), 'AUTHOR' => $getpost3['author'], 'RATING' => $getpost3['rating'], 'TEXT' => parseText($getpost3['text']))); $tags = getTags($getpost3['id']); foreach ($tags as $tag) { $template->adds_ref_sub(0, 'TAGS', array('TAG' => $tag)); } $gettrack = "SELECT * FROM tracking WHERE ip = \"" . $_SERVER['REMOTE_ADDR'] . "\""; $gettrack2 = mysql_query($gettrack); $gettrack3 = mysql_fetch_array($gettrack2); $trackArr = explode(',',$gettrack3['rating']); if (($gettrack3['ip'] != $_SERVER['REMOTE_ADDR']) || (array_search($getpost3['id'],$trackArr) === FALSE)) { $template->adds_ref_sub(0, 'CANVOTE', array('exi'=>1)); } else { $template->adds_ref_sub(0, 'NOVOTE', array('exi'=>1)); } $template->display(); $getpings = "SELECT * FROM pingbacks WHERE post_id = " . $getpost3['id']; $getpings2 = mysql_query($getpings); $i=0; while ($getpings3[$i] = mysql_fetch_array($getpings2)) { if ($i==0) { $template = new FITemplate('pingbacks'); } $template->adds_block('PINGBACK', array( 'TITLE' => $getpings3[$i]['title'], 'URL' => htmlspecialchars($getpings3[$i]['url']), 'DATE' => date('F jS Y', strtotime($getpings3[$i]['pubDate'])))); $i++; } if ($i > 0) { $template->display(); } $page_id = 'updates-' . $getpost3['id']; include('includes/comments.php'); displayRelated($getpost3['title'], $getpost3['id']); } else { generateError('404'); } } else { $template = new FITemplate('archive'); if (isset($_GET['author'])) { $title = 'Author: ' . $_GET['author'] . ' - Blog Archive'; $template->add('HEADER', 'Posts by ' . $_GET['author']); $getposts = "SELECT * FROM updates AS u WHERE author = \"" . $_GET['author'] . "\" ORDER BY id DESC"; $getbio = "SELECT * FROM bio WHERE username = \"" . $_GET['author'] . "\""; $getbio2 = mysql_query($getbio); $getbio3 = mysql_fetch_array($getbio2); if ($getbio3['username'] == $_GET['author']) { $template->adds_block('BIO', array( 'TEXT' => $getbio3['text'], 'USERNAME' => $getbio3['username'], 'DATE' => date('F jS Y \a\\t g:i:s a',strtotime($getbio3['lastUpdated'])))); } } elseif (isset($_GET['tag'])) { $title = 'Tag: ' . $_GET['tag'] . ' - Blog Archive'; $template->add('HEADER', 'Posts tagged with ' . $_GET['tag']); $getposts = "SELECT * FROM updates AS u, tags AS t WHERE u.id = t.post_id AND t.post_type = \"published\" AND t.tag = \"" . $_GET['tag'] . "\" ORDER BY u.id DESC"; } else { $title = 'Blog Archive'; $template->add('HEADER', 'Blog Archive'); $getposts = "SELECT * FROM updates AS u ORDER BY id DESC"; } $getposts2 = mysql_query($getposts); $i=0; while ($getposts3[$i] = mysql_fetch_array($getposts2)) { if ((!isset($lastmonth)) || ($lastmonth != date('m-Y',strtotime($getposts3[$i]['pubDate'])))) { if (!isset($curID)) { $curID = 0; } else { $curID++; } $template->add_ref($curID, 'MONTH', array('TITLE' => date('F Y',strtotime($getposts3[$i]['pubDate'])))); $lastmonth = date('m-Y',strtotime($getposts3[$i]['pubDate'])); } $page_id = 'updates-' . $getposts3[$i]['id']; $getcomments = "SELECT * FROM comments WHERE page_id = \"" . $page_id . "\" ORDER BY posttime"; $getcomments2 = mysql_query($getcomments); $total_post=0; while ($getcomments3[$total_post] = mysql_fetch_array($getcomments2)) { $total_post++; } if ($total_post >= 2) { $plural = 's'; } if ($total_post == 0) { $comText = 'No Comments'; } elseif ($total_post == 1) { $comText = '1 Comment'; } else { $comText = $total_post . ' Comments'; } $template->adds_ref_sub($curID, 'SMALL',array( 'DATE' => date('m-d-Y',strtotime($getposts3[$i]['pubDate'])), 'CODED' => $getposts3[$i]['slug'], 'TITLE' => htmlentities($getposts3[$i]['title']))); $i++; } if ($i==0) { generateError('404'); } $template->display(); } ?>