From a61c5b71e219411958b5cf8dc22f3daad056a315 Mon Sep 17 00:00:00 2001
From: garvinhicking <garvinhicking>
Date: Fri, 9 Jun 2006 09:32:38 +0000
Subject: [PATCH] update index creation

---
 .../serendipity_event_statistics.php                | 13 ++++++++++---
 1 file changed, 10 insertions(+), 3 deletions(-)

diff --git a/plugins/serendipity_event_statistics/serendipity_event_statistics.php b/plugins/serendipity_event_statistics/serendipity_event_statistics.php
index 7e766da..69a8703 100644
--- a/plugins/serendipity_event_statistics/serendipity_event_statistics.php
+++ b/plugins/serendipity_event_statistics/serendipity_event_statistics.php
@@ -90,6 +90,9 @@ class serendipity_event_statistics extends serendipity_event
                     if (!is_array($tableChecker)){
                         $this->createTables();
                     }
+                    if ($this->get_config('db_indices_created', 'false') !== '1') {
+                        $this->updateTables();
+                    }
                     
                     //Unique visitors are beeing registered and counted here. Calling function below.
                     $sessionChecker = serendipity_db_query("SELECT count(sessID) FROM {$serendipity['dbPrefix']}visitors WHERE '".serendipity_db_escape_string(session_id())."' = sessID GROUP BY sessID", true);
@@ -643,6 +646,11 @@ class serendipity_event_statistics extends serendipity_event
         )";
         serendipity_db_schema_import($q);
         
+        $this->updateTables();
+    } //end of function createTables()
+
+
+    function updateTables() {
         //create indices
         $q   = "CREATE INDEX visitorses ON {$serendipity['dbPrefix']}visitors(sessID);";
         serendipity_db_schema_import($q);
@@ -650,9 +658,8 @@ class serendipity_event_statistics extends serendipity_event
         serendipity_db_schema_import($q);
         $q   = "CREATE INDEX visitortime ON {$serendipity['dbPrefix']}visitors(time);";
         serendipity_db_schema_import($q);
-
-    } //end of function createTables()
-
+        $this->set_config('db_indices_created', '1');
+    }
 
     function dropTables() {
         
-- 
2.39.5