Changeset 1017 for trunk/bp-activity.php

Timestamp:

02/04/2009 12:29:21 AM (16 years ago)

Author:

matt

Message:

Minor cleanups, mods, and todos.

File:

• trunk/bp-activity.php (modified) (4 diffs)

trunk/bp-activity.php

@@ -36 +36 @@
                 id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                 item_id int(11) NOT NULL,
-                secondary_item_id int(11),
+                secondary_item_id int(11) NOT NULL,
                 user_id int(11) NOT NULL,
                 component_name varchar(75) NOT NULL,
@@ -52 +52 @@
                 id int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
                 item_id int(11) NOT NULL,
-                secondary_item_id int(11),
+                secondary_item_id int(11) NOT NULL,
                 content longtext NOT NULL,
                 primary_link varchar(150) NOT NULL,
@@ -152 +152 @@
     if ( $bp['current_userid'] ) {
         /* Check to see if the current user has their activity table set up. If not, set them up. */
-        if ( !$wpdb->get_var("show tables like '%" . $bp['activity']['table_name_current_user'] . "%'") || get_usermeta( $bp['current_userid'], 'bp-activity-db-version' ) < BP_ACTIVITY_VERSION  )
+        if ( !$wpdb->get_var("SHOW TABLES LIKE '%" . $bp['activity']['table_name_current_user'] . "%'") || get_usermeta( $bp['current_userid'], 'bp-activity-db-version' ) < BP_ACTIVITY_VERSION  )
             bp_activity_user_install();
     }
@@ -158 +158 @@
     if ( is_site_admin() && $current_blog->blog_id == 1 ) {
         /* Check to see if the site wide activity table is set up. */
-        if ( !$wpdb->get_var("show tables like '%" . $bp['activity']['table_name_sitewide'] . "%'") || get_site_option( 'bp-activity-db-version' ) < BP_ACTIVITY_VERSION  )
+        if ( !$wpdb->get_var("SHOW TABLES LIKE '%" . $bp['activity']['table_name_sitewide'] . "%'") || get_site_option( 'bp-activity-db-version' ) < BP_ACTIVITY_VERSION  )
             bp_activity_sitewide_install();
     }