From d568a1e9fd63c97eb86cd84a51bb6770747ec37c Mon Sep 17 00:00:00 2001
From: Bharat Mediratta <bharat@menalto.com>
Date: Sat, 17 Jan 2009 00:52:50 +0000
Subject: Implement relevance ranked boolean searching on a full text index of
 item and comment data.  Whew!

It's not pretty yet.  And you have to manually update the index
currently in admin/maintenance.  But it works.
---
 modules/comment/helpers/comment_installer.php |  3 +++
 modules/comment/helpers/comment_search.php    | 34 +++++++++++++++++++++++++++
 2 files changed, 37 insertions(+)
 create mode 100644 modules/comment/helpers/comment_search.php

(limited to 'modules/comment/helpers')

diff --git a/modules/comment/helpers/comment_installer.php b/modules/comment/helpers/comment_installer.php
index aba32566..651065f7 100644
--- a/modules/comment/helpers/comment_installer.php
+++ b/modules/comment/helpers/comment_installer.php
@@ -58,6 +58,9 @@ class comment_installer {
 
   static function uninstall() {
     $db = Database::instance();
+    $sql = "SELECT `item_id` FROM `comments`";
+    module::event("item_related_update_batch", $sql);
+
     $db->query("DROP TABLE IF EXISTS `comments`;");
     module::delete("comment");
   }
diff --git a/modules/comment/helpers/comment_search.php b/modules/comment/helpers/comment_search.php
new file mode 100644
index 00000000..79a0c4bc
--- /dev/null
+++ b/modules/comment/helpers/comment_search.php
@@ -0,0 +1,34 @@
+<?php defined("SYSPATH") or die("No direct script access.");
+/**
+ * Gallery - a web based photo album viewer and editor
+ * Copyright (C) 2000-2008 Bharat Mediratta
+ *
+ * This program is free software; you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation; either version 2 of the License, or (at
+ * your option) any later version.
+ *
+ * This program is distributed in the hope that it will be useful, but
+ * WITHOUT ANY WARRANTY; without even the implied warranty of
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
+ * General Public License for more details.
+ *
+ * You should have received a copy of the GNU General Public License
+ * along with this program; if not, write to the Free Software
+ * Foundation, Inc., 51 Franklin Street - Fifth Floor, Boston, MA  02110-1301, USA.
+ */
+
+class Comment_Search_Core {
+  static function item_index_data($item) {
+    $data = array();
+    foreach (Database::instance()
+             ->select("text")
+             ->from("comments")
+             ->where("item_id", $item->id)
+             ->get()
+             ->as_array() as $row) {
+      $data[] = $row->text;
+    }
+    return join(" ", $data);
+  }
+}
-- 
cgit v1.2.3