From 1d9f883cd824f5f70adfcc9e4692e1ff7ba465eb Mon Sep 17 00:00:00 2001 From: Starla Insigna Date: Sun, 7 Dec 2008 19:29:33 -0500 Subject: Moved pingbacks up in layout They look better up there. :) --- pages/blog.php | 35 ++++++++++++++++++----------------- 1 file changed, 18 insertions(+), 17 deletions(-) diff --git a/pages/blog.php b/pages/blog.php index ab198a0..009326c 100755 --- a/pages/blog.php +++ b/pages/blog.php @@ -81,23 +81,20 @@ if (isset($_GET['post'])) } $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); + $getpings = "SELECT * FROM pingbacks WHERE post_id = " . $getpost3['id']; + $getpings2 = mysql_query($getpings); $i=0; - while ($getrelated3[$i] = mysql_fetch_array($getrelated2)) + while ($getpings3[$i] = mysql_fetch_array($getpings2)) { if ($i==0) { - $template = new FITemplate('related'); + $template = new FITemplate('pingbacks'); } - $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'])))); + $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++; } @@ -106,19 +103,23 @@ if (isset($_GET['post'])) $template->display(); } - $getpings = "SELECT * FROM pingbacks WHERE post_id = " . $getpost3['id']; - $getpings2 = mysql_query($getpings); + $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 ($getpings3[$i] = mysql_fetch_array($getpings2)) + while ($getrelated3[$i] = mysql_fetch_array($getrelated2)) { if ($i==0) { - $template = new FITemplate('pingbacks'); + $template = new FITemplate('related'); } - $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'])))); + $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++; } -- cgit 1.4.1