Context Navigation

Changeset 1369149

Timestamp:

03/11/2016 11:44:35 AM (10 years ago)

Author:

TrendMD

Message:

fixing article indexing

File:

-                      r1368317
+                      r1369149
         $Trendmd_Settings = new TrendMD_Settings();
-        self::add_trendmd_id_column();
+    }
 …
+    {
         global $wpdb;
         $sql = 'CREATE TABLE IF NOT EXISTS ' . $wpdb->prefix . 'trendmd_indexed_articles' . '(id mediumint(9) PRIMARY KEY);';
+        $sql = 'CREATE TABLE IF NOT EXISTS ' . $wpdb->prefix . 'trendmd_indexed_articles' . '(id mediumint(9) PRIMARY KEY, trendmd_id VARCHAR( 255 ) NOT NULL);';
         $wpdb->query($sql);
+        self::add_trendmd_id_column();
+    }
+    public static function add_trendmd_id_column(){
+        global $wpdb;
+        $altered_table = get_option('trendmd_added_id', array());
+        if (!$altered_table > 0) {
+            $sql = 'ALTER TABLE  ' . $wpdb->prefix . 'trendmd_indexed_articles ADD  `trendmd_id` VARCHAR( 255 ) NOT NULL;';
+            $wpdb->query($sql);
+            update_option('trendmd_added_id', 1);
+        }
+    }
+    }
     public static function deactivate_db()
 …
         $sql = 'DROP TABLE IF EXISTS ' . $wpdb->prefix . 'trendmd_indexed_articles;';
         $wpdb->query($sql);
-        update_option('trendmd_added_id', 0);
+    }

Note: See TracChangeset for help on using the changeset viewer.