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($getpost3['title']) . ' - Blog Archive'; $getback = "SELECT * FROM updates WHERE id = " . ($getpost3['id']-1); $getback2 = mysql_query($getback); $getback3 = mysql_fetch_array($getback2); if (isset($getback3['title'])) { $template->adds_block('BACK', array( 'CODED' => $getback3['slug'], 'TITLE' => $getback3['title'])); } $getnext = "SELECT * FROM updates WHERE id = " . ($getpost3['id']+1); $getnext2 = mysql_query($getnext); $getnext3 = mysql_fetch_array($getnext2); if (isset($getnext3['title'])) { $template->adds_block('NEXT', array( 'CODED' => $getnext3['slug'], 'TITLE' => $getnext3['title'])); } $template->add_ref(0, 'POST', array( 'ID' => $getpost3['id'], 'YEARID' => ((date('Y',strtotime($getpost3['pubDate']))-2006) % 4), 'DATE' => date('F dS 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' => $getpost3['title'], 'AUTHOR' => $getpost3['author'], 'RATING' => $getpost3['rating'], 'TEXT' => parseBBCode($getpost3['text']))); $tags = getTags($getpost3['id']); foreach ($tags as $tag) { $template->adds_ref_sub(0, 'TAGS', array('TAG' => $tag)); } $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' => $getpings3[$i]['url'], 'DATE' => date('F d<\S\U\P>S Y', strtotime($getpings3[$i]['pubDate'])))); $i++; } if ($i > 0) { $template->display(); } $page_id = 'updates-' . $getpost3['id']; include('includes/comments.php'); $getrelated = "SELECT *, MATCH (title, text) AGAINST (\"" . addslashes($getpost3['title']) . "\") AS score FROM updates WHERE MATCH (title, text) AGAINST (\"" . addslashes($getpost3['title']) . "\") AND id <> " . $getpost3['id'] . " LIMIT 0,5"; $getrelated2 = mysql_query($getrelated); $i=0; while ($getrelated3[$i] = mysql_fetch_array($getrelated2)) { if ($i==0) { $template = new FITemplate('related'); } $template->adds_block('POST', array( 'TITLE' => $getrelated3[$i]['title'], 'CODED' => $getrelated3[$i]['slug'], 'AUTHOR' => $getrelated3[$i]['author'], 'DATE' => date('F d<\S\U\P>S Y',strtotime($getrelated3[$i]['pubDate'])))); $i++; } if ($i > 0) { $template->display(); } } else { generateError('404'); } } else { $template = new FITemplate('archive'); if (isset($_GET['author'])) { $title = 'Author: ' . $_GET['author'] . ' - Blog Archive'; $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 dS Y \a\\t g:i:s a',strtotime($getbio3['lastUpdated'])))); } } elseif (isset($_GET['tag'])) { $title = 'Tag: ' . $_GET['tag'] . ' - Blog Archive'; $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'; $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'])))); if ($curID == 0) { $template->adds_ref_sub($curID, 'BIGEND',array('exi'=>1)); } $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'; } if ($curID == 0) { $template->adds_ref_sub($curID, 'BIG',array( 'DATE' => date('m-d-Y',strtotime($getposts3[$i]['pubDate'])), 'CODED' => $getposts3[$i]['slug'], 'TITLE' => $getposts3[$i]['title'], 'ID' => $getposts3[$i]['id'], 'YEARID' => ((date('Y',strtotime($getposts3[$i]['pubDate']))-2006) % 4), 'MONTH' => date('M',strtotime($getposts3[$i]['pubDate'])), 'DAY' => date('d',strtotime($getposts3[$i]['pubDate'])), 'AUTHOR' => $getposts3[$i]['author'], 'PLURALCOMMENT' => (isset($plural) ? $plural : ''), 'COMMENTS' => $comText)); } else { $template->adds_ref_sub($curID, 'SMALL',array( 'DATE' => date('m-d-Y',strtotime($getposts3[$i]['pubDate'])), 'CODED' => $getposts3[$i]['slug'], 'TITLE' => $getposts3[$i]['title'])); } $i++; } if ($i==0) { generateError('404'); } $template->display(); } ?>