Moved pingbacks to a seperate table

Because pingbacks just aren't comments, they shouldn't be stored in the comments table. So, a new table has been created for them and the blog post
view pages have been accomodated to show them at the bottom just like the related posts are shown.

2 files changed, 5 insertions, 8 deletions

@@ -176,12 +176,9 @@ if (!isset($noRightbar))
                         break;
                 }
 
-                if ($name != 'Pingback')
-                {
-                        $template->adds_block('TOP', array(     'USERNAME' => $name,
-                                                                'COUNT' => $count));
-                        $i++;
-                }
+                $template->adds_block('TOP', array(     'USERNAME' => $name,
+                                                        'COUNT' => $count));
+                $i++;
         }
 
         $gethits = "SELECT * FROM config WHERE name = \"hits\"";
@@ -166,12 +166,12 @@ function recalcPop($id)
         $popularity += ($getpost3['views']*2);
         $popularity += ($getpost3['rating']*5);
 
-        $getcomments = "SELECT COUNT(*) FROM comments WHERE page_id = \"updates-" . $id . "\" AND username <> \"Pingback\"";
+        $getcomments = "SELECT COUNT(*) FROM comments WHERE page_id = \"updates-" . $id . "\"";
         $getcomments2 = mysql_query($getcomments);
         $getcomments3 = mysql_fetch_array($getcomments2);
         $popularity += ($getcomments3[0] * 10);
 
-        $getpings = "SELECT COUNT(*) FROM comments WHERE page_id = \"updates-" . $id . "\" AND username = \"Pingback\"";
+        $getpings = "SELECT COUNT(*) FROM pingbacks WHERE post_id = " . $id;
         $getpings2 = mysql_query($getpings);
         $getpings3 = mysql_fetch_array($getpings2);
         $popularity += ($getpings3[0] * 25);