Changeset 57

Timestamp:

05/05/2008 06:02:55 PM (18 years ago)

Author:

apeatling

Message:

Implemented component version control so that database tables can be updated when changes are made.

Location:

trunk

Files:

• bp-friends.php (modified) (1 diff)
• bp-groups.php (modified) (1 diff)
• bp-messages.php (modified) (4 diffs)
• bp-xprofile.php (modified) (3 diffs)

trunk/bp-friends.php

@@ -1 +1 @@
 <?php
+
+add_site_option('bp-friends-version', '0.1');
 
 /**************************************************************************

trunk/bp-groups.php

@@ -1 +1 @@
 <?php
+
+add_site_option('bp-groups-version', '0.1');
 
 $bp_groups_table_name = $wpdb->base_prefix . "bp_groups";

trunk/bp-messages.php

@@ -19 +19 @@
  **************************************************************************/
 
-function messages_install() {
+function messages_install( $version ) {
         global $wpdb, $bp_messages_table_name, $bp_messages_table_name_deleted;
 
-        $sql[0] = "CREATE TABLE ". $bp_messages_table_name ." (
+        $sql[] = "CREATE TABLE ". $bp_messages_table_name ." (
                                 id int(11) NOT NULL AUTO_INCREMENT,
                                 sender_id int(11) NOT NULL,
@@ -34 +34 @@
                            );";
         
-        $sql[1] = "CREATE TABLE ". $bp_messages_table_name_deleted ." (
+        $sql[] = "CREATE TABLE ". $bp_messages_table_name_deleted ." (
                                 id int(11) NOT NULL AUTO_INCREMENT,
                                 thread_id int(11) NOT NULL,
@@ -44 +44 @@
         require_once( ABSPATH . 'wp-admin/upgrade-functions.php' );
         dbDelta($sql);
+        
+        add_site_option('bp-messages-version', $version);
 }
 
@@ -72 +74 @@
         
         /* Need to check db tables exist, activate hook no-worky in mu-plugins folder. */
-        if ( $wpdb->get_var( "show tables like '%" . $bp_messages_table_name . "%'" ) == false )
-                messages_install();
+        if ( ( $wpdb->get_var( "show tables like '%" . $bp_messages_table_name . "%'" ) == false ) || ( get_site_option('bp-messages-version') < '0.2' ) )
+                messages_install('0.2');
 }
 add_action( 'admin_menu', 'messages_add_menu' );

trunk/bp-xprofile.php

@@ -22 +22 @@
  **************************************************************************/
 
-function xprofile_install() {
+function xprofile_install( $version ) {
         global $bp_xprofile_table_name_groups, $bp_xprofile_table_name_fields, $bp_xprofile_table_name_data;
 
@@ -62 +62 @@
         require_once( ABSPATH . 'wp-admin/upgrade-functions.php' );
         dbDelta($sql);
+
+        add_site_option('bp-xprofile-version', $version);
 }
 
@@ -92 +94 @@
         
         /* Need to check db tables exist, activate hook no-worky in mu-plugins folder. */
-        if ( $wpdb->get_var("show tables like '%" . $bp_xprofile_table_name . "%'") == false )
-                xprofile_install();
+        if ( ( $wpdb->get_var("show tables like '%" . $bp_xprofile_table_name . "%'") == false ) || ( get_site_option('bp-xprofile-version') < '0.2' )  )
+                xprofile_install('0.2');
 }
 add_action( 'admin_menu', 'xprofile_add_menu' );