s2class_upgrade

The Subscribe2 s2class upgrade class.

Defined (1)

The class is defined in the following location(s).

/classes/class-s2-upgrade.php  
  1. class s2class_upgrade { 
  2.     function upgrade_core() { 
  3.         // let's take the time to double check data for registered users 
  4.         global $mysubscribe2; 
  5.         if ( version_compare($mysubscribe2->wp_release, '3.5', '<') ) { 
  6.             global $wpdb; 
  7.             $users = $wpdb->get_col($wpdb->prepare("SELECT ID from $wpdb->users WHERE ID NOT IN (SELECT user_id FROM $wpdb->usermeta WHERE meta_key=%s)", $mysubscribe2->get_usermeta_keyname('s2_format'))); 
  8.             if ( !empty($users) ) { 
  9.                 foreach ($users as $user_ID) { 
  10.                     $mysubscribe2->register($user_ID); 
  11.                 } 
  12.             } 
  13.         } else { 
  14.             $args = array( 
  15.                 'meta_query' => array( 
  16.                     array('key' => $mysubscribe2->get_usermeta_keyname('s2_format'), 'compare' => 'NOT EXISTS') 
  17.  ) 
  18.  ); 
  19.  
  20.             $user_query = new WP_User_Query( $args ); 
  21.             $users = $user_query->get_results(); 
  22.             if ( !empty($users) ) { 
  23.                 foreach ($users as $user) { 
  24.                     $mysubscribe2->register($user->ID); 
  25.                 } 
  26.             } 
  27.         } 
  28.         // let's make sure that the 's2_authors' key exists on every site for all Registered Users too 
  29.         $this->upgrade70(); 
  30.     } // end upgrade_core() 
  31.  
  32.     function upgrade23() { 
  33.         global $mysubscribe2, $wpdb; 
  34.  
  35.         // include upgrade-functions for maybe_add_column; 
  36.         if ( !function_exists('maybe_add_column') ) { 
  37.             require_once(ABSPATH . 'wp-admin/install-helper.php'); 
  38.         } 
  39.         $date = date('Y-m-d'); 
  40.         maybe_add_column($mysubscribe2->public, 'date', "ALTER TABLE $mysubscribe2->public ADD date DATE DEFAULT '$date' NOT NULL AFTER active"); 
  41.  
  42.         // update the options table to serialized format 
  43.         $old_options = $wpdb->get_col("SELECT option_name from $wpdb->options where option_name LIKE 's2%' AND option_name != 's2_future_posts'"); 
  44.  
  45.         if ( !empty($old_options) ) { 
  46.             foreach ( $old_options as $option ) { 
  47.                 $value = get_option($option); 
  48.                 $option_array = substr($option, 3); 
  49.                 $mysubscribe2->subscribe2_options[$option_array] = $value; 
  50.                 delete_option($option); 
  51.             } 
  52.         } 
  53.     } // end upgrade23() 
  54.  
  55.     function upgrade51() { 
  56.         global $mysubscribe2; 
  57.  
  58.         // include upgrade-functions for maybe_add_column; 
  59.         if ( !function_exists('maybe_add_column') ) { 
  60.             require_once(ABSPATH . 'wp-admin/install-helper.php'); 
  61.         } 
  62.         maybe_add_column($mysubscribe2->public, 'ip', "ALTER TABLE $mysubscribe2->public ADD ip char(64) DEFAULT 'admin' NOT NULL AFTER date"); 
  63.     } // end upgrade51() 
  64.  
  65.     function upgrade56() { 
  66.         global $mysubscribe2; 
  67.         // correct autoformat to upgrade from pre 5.6 
  68.         if ( $mysubscribe2->subscribe2_options['autoformat'] == 'text' ) { 
  69.             $mysubscribe2->subscribe2_options['autoformat'] = 'excerpt'; 
  70.         } 
  71.         if ( $mysubscribe2->subscribe2_options['autoformat'] == 'full' ) { 
  72.             $mysubscribe2->subscribe2_options['autoformat'] = 'post'; 
  73.         } 
  74.     } // end upgrade56() 
  75.  
  76.     function upgrade59() { 
  77.         global $mysubscribe2, $wpdb; 
  78.         // ensure existing public subscriber emails are all sanitized 
  79.         $confirmed = $mysubscribe2->get_public(); 
  80.         $unconfirmed = $mysubscribe2->get_public(0); 
  81.         $public_subscribers = array_merge((array)$confirmed, (array)$unconfirmed); 
  82.  
  83.         foreach ( $public_subscribers as $email ) { 
  84.             $new_email = $mysubscribe2->sanitize_email($email); 
  85.             if ( $email !== $new_email ) { 
  86.                 $wpdb->get_results($wpdb->prepare("UPDATE $mysubscribe2->public SET email=%s WHERE CAST(email as binary)=%s", $new_email, $email)); 
  87.             } 
  88.         } 
  89.     } // end upgrade59() 
  90.  
  91.     function upgrade64() { 
  92.         global $mysubscribe2; 
  93.         // change old CAPITALISED keywords to those in {PARENTHESES}; since version 6.4 
  94.         $keywords = array('BLOGNAME', 'BLOGLINK', 'TITLE', 'POST', 'POSTTIME', 'TABLE', 'TABLELINKS', 'PERMALINK', 'TINYLINK', 'DATE', 'TIME', 'MYNAME', 'EMAIL', 'AUTHORNAME', 'LINK', 'CATS', 'TAGS', 'COUNT', 'ACTION'); 
  95.         $keyword = implode('|', $keywords); 
  96.         $regex = '/(?<!\{)\b('.$keyword.')\b(?!\{)/xm'; 
  97.         $replace = '{\1}'; 
  98.         $mysubscribe2->subscribe2_options['mailtext'] = preg_replace($regex, $replace, $mysubscribe2->subscribe2_options['mailtext']); 
  99.         $mysubscribe2->subscribe2_options['notification_subject'] = preg_replace($regex, $replace, $mysubscribe2->subscribe2_options['notification_subject']); 
  100.         $mysubscribe2->subscribe2_options['confirm_email'] = preg_replace($regex, $replace, $mysubscribe2->subscribe2_options['confirm_email']); 
  101.         $mysubscribe2->subscribe2_options['confirm_subject'] = preg_replace($regex, $replace, $mysubscribe2->subscribe2_options['confirm_subject']); 
  102.         $mysubscribe2->subscribe2_options['remind_email'] = preg_replace($regex, $replace, $mysubscribe2->subscribe2_options['remind_email']); 
  103.         $mysubscribe2->subscribe2_options['remind_subject'] = preg_replace($regex, $replace, $mysubscribe2->subscribe2_options['remind_subject']); 
  104.  
  105.         if ( version_compare($mysubscribe2->wp_release, '3.5', '<') ) { 
  106.             $users = $mysubscribe2->get_all_registered('ID'); 
  107.             foreach ( $users as $user_ID ) { 
  108.                 $check_format = get_user_meta($user_ID, $mysubscribe2->get_usermeta_keyname('s2_format'), true); 
  109.                 // if user is already registered update format remove 's2_excerpt' field and update 's2_format' 
  110.                 if ( 'html' == $check_format ) { 
  111.                     delete_user_meta($user_ID, 's2_excerpt'); 
  112.                 } elseif ( 'text' == $check_format ) { 
  113.                     update_user_meta($user_ID, $mysubscribe2->get_usermeta_keyname('s2_format'), get_user_meta($user_ID, 's2_excerpt')); 
  114.                     delete_user_meta($user_ID, 's2_excerpt'); 
  115.                 } 
  116.                 $subscribed = get_user_meta($user_ID, $mysubscribe2->get_usermeta_keyname('s2_subscribed'), true); 
  117.                 if ( strstr($subscribed, '-1') ) { 
  118.                     // make sure we remove '-1' from any settings 
  119.                     $old_cats = explode(', ', $subscribed); 
  120.                     $pos = array_search('-1', $old_cats); 
  121.                     unset($old_cats[$pos]); 
  122.                     $cats = implode(', ', $old_cats); 
  123.                     update_user_meta($user_ID, $mysubscribe2->get_usermeta_keyname('s2_subscribed'), $cats); 
  124.                 } 
  125.             } 
  126.         } else { 
  127.             $args = array( 
  128.                 'relation' => 'AND',  
  129.                 'meta_query' => array( 
  130.                     array('key' => $mysubscribe2->get_usermeta_keyname('s2_format'),  
  131.                     'value' => 'html') 
  132.  ),  
  133.                 'meta_query' => array( 
  134.                     array('key' => 's2_excerpt',  
  135.                     'compare' => 'EXISTS') 
  136.  ) 
  137.  ); 
  138.  
  139.             $user_query = new WP_User_Query( $args ); 
  140.             $users = $user_query->get_results(); 
  141.             if ( !empty($users) ) { 
  142.                 foreach ($users as $user) { 
  143.                     delete_user_meta($user->ID, 's2_excerpt'); 
  144.                 } 
  145.             } 
  146.  
  147.             $args = array( 
  148.                 'relation' => 'AND',  
  149.                 'meta_query' => array( 
  150.                     array('key' => $mysubscribe2->get_usermeta_keyname('s2_format'),  
  151.                     'value' => 'text') 
  152.  ),  
  153.                 'meta_query' => array( 
  154.                     array('key' => 's2_excerpt',  
  155.                     'compare' => 'EXISTS') 
  156.  ) 
  157.  ); 
  158.  
  159.             $user_query = new WP_User_Query( $args ); 
  160.             $users = $user_query->get_results(); 
  161.             if ( !empty($users) ) { 
  162.                 foreach ($users as $user) { 
  163.                     update_user_meta($user->ID, $mysubscribe2->get_usermeta_keyname('s2_format'), get_user_meta($user->ID, 's2_excerpt')); 
  164.                     delete_user_meta($user->ID, 's2_excerpt'); 
  165.                 } 
  166.             } 
  167.  
  168.             $args = array( 
  169.                 'meta_query' => array( 
  170.                     array('key' => $mysubscribe2->get_usermeta_keyname('s2_subscribed'),  
  171.                     'value' => '-1',  
  172.                     'compare' => 'LIKE') 
  173.  ) 
  174.  ); 
  175.  
  176.             $user_query = new WP_User_Query( $args ); 
  177.             $users = $user_query->get_results(); 
  178.             if ( !empty($users) ) { 
  179.                 foreach ($users as $user) { 
  180.                     $subscribed = get_user_meta($user->ID, $mysubscribe2->get_usermeta_keyname('s2_subscribed'), true); 
  181.                     $old_cats = explode(', ', $subscribed); 
  182.                     $pos = array_search('-1', $old_cats); 
  183.                     unset($old_cats[$pos]); 
  184.                     $cats = implode(', ', $old_cats); 
  185.                     update_user_meta($user->ID, $mysubscribe2->get_usermeta_keyname('s2_subscribed'), $cats); 
  186.                 } 
  187.             } 
  188.         } 
  189.  
  190.         // upgrade old wpmu user meta data to new 
  191.         if ( $mysubscribe2->s2_mu === true ) { 
  192.             global $s2class_multisite, $wpdb; 
  193.             $s2class_multisite->namechange_subscribe2_widget(); 
  194.             // loop through all users 
  195.             foreach ( $users as $user_ID ) { 
  196.                 // get categories which the user is subscribed to (old ones) 
  197.                 $categories = get_user_meta($user_ID, 's2_subscribed', true); 
  198.                 $categories = explode(', ', $categories); 
  199.                 $format = get_user_meta($user_ID, 's2_format', true); 
  200.                 $autosub = get_user_meta($user_ID, 's2_autosub', true); 
  201.  
  202.                 // load blogs of user (only if we need them) 
  203.                 $blogs = array(); 
  204.                 if ( count($categories) > 0 && !in_array('-1', $categories) ) { 
  205.                     $blogs = get_blogs_of_user($user_ID, true); 
  206.                 } 
  207.  
  208.                 foreach ( $blogs as $blog ) { 
  209.                     switch_to_blog($blog->userblog_id); 
  210.  
  211.                     $blog_categories = (array)$wpdb->get_col("SELECT term_id FROM $wpdb->term_taxonomy WHERE taxonomy = 'category'"); 
  212.                     $subscribed_categories = array_intersect($categories, $blog_categories); 
  213.                     if ( !empty($subscribed_categories) ) { 
  214.                         foreach ( $subscribed_categories as $subscribed_category ) { 
  215.                             update_user_meta($user_ID, $mysubscribe2->get_usermeta_keyname('s2_cat') . $subscribed_category, $subscribed_category); 
  216.                         } 
  217.                         update_user_meta($user_ID, $mysubscribe2->get_usermeta_keyname('s2_subscribed'), implode(', ', $subscribed_categories)); 
  218.                     } 
  219.                     if ( !empty($format) ) { 
  220.                         update_user_meta($user_ID, $mysubscribe2->get_usermeta_keyname('s2_format'), $format); 
  221.                     } 
  222.                     if ( !empty($autosub) ) { 
  223.                         update_user_meta($user_ID, $mysubscribe2->get_usermeta_keyname('s2_autosub'), $autosub); 
  224.                     } 
  225.                     restore_current_blog(); 
  226.                 } 
  227.  
  228.                 // delete old user meta keys 
  229.                 delete_user_meta($user_ID, 's2_subscribed'); 
  230.                 delete_user_meta($user_ID, 's2_format'); 
  231.                 delete_user_meta($user_ID, 's2_autosub'); 
  232.                 foreach ( $categories as $cat ) { 
  233.                     delete_user_meta($user_ID, 's2_cat' . $cat); 
  234.                 } 
  235.             } 
  236.         } 
  237.     } // end upgrade64() 
  238.  
  239.     function upgrade70() { 
  240.         global $mysubscribe2; 
  241.         if ( version_compare($mysubscribe2->wp_release, '3.5', '<') ) { 
  242.             $users = $wpdb->get_col($wpdb->prepare("SELECT ID from $wpdb->users WHERE ID NOT IN (SELECT user_id from $wpdb->usermeta WHERE meta_key=%s", $mysubscribe2->get_usermeta_keyname('s2_authors'))); 
  243.             foreach ( $users as $user_ID ) { 
  244.                 $check_authors = get_user_meta($user_ID, $mysubscribe2->get_usermeta_keyname('s2_authors'), true); 
  245.                 if ( empty($check_authors) ) { 
  246.                     update_user_meta($user_ID, $mysubscribe2->get_usermeta_keyname('s2_authors'), ''); 
  247.                 } 
  248.             } 
  249.         } else { 
  250.             $args = array( 
  251.                 'meta_query' => array( 
  252.                     array('key' => $mysubscribe2->get_usermeta_keyname('s2_authors'), 'compare' => 'NOT EXISTS') 
  253.  ) 
  254.  ); 
  255.  
  256.             $user_query = new WP_User_Query( $args ); 
  257.             $users = $user_query->get_results(); 
  258.             if ( !empty($users) ) { 
  259.                 foreach ($users as $user) { 
  260.                     update_user_meta($user->ID, $mysubscribe2->get_usermeta_keyname('s2_authors'), ''); 
  261.                 } 
  262.             } 
  263.         } 
  264.     } // end upgrade70() 
  265.  
  266.     function upgrade85() { 
  267.         global $mysubscribe2, $wpdb; 
  268.  
  269.         // include upgrade-functions for maybe_add_column; 
  270.         if ( !function_exists('maybe_add_column') ) { 
  271.             require_once(ABSPATH . 'wp-admin/install-helper.php'); 
  272.         } 
  273.         maybe_add_column($mysubscribe2->public, 'time', "ALTER TABLE $mysubscribe2->public ADD time TIME DEFAULT '00:00:00' NOT NULL AFTER date"); 
  274.  
  275.         // update postmeta field to a protected name, from version 8.5 
  276.         $wpdb->query( "UPDATE $wpdb->postmeta SET meta_key = '_s2mail' WHERE meta_key = 's2mail'" ); 
  277.     } // end upgrade85() 
  278.  
  279.     function upgrade86() { 
  280.         global $mysubscribe2, $wpdb; 
  281.  
  282.         // include upgrade-functions for maybe_add_column; 
  283.         if ( !function_exists('maybe_add_column') ) { 
  284.             require_once(ABSPATH . 'wp-admin/install-helper.php'); 
  285.         } 
  286.         maybe_add_column($mysubscribe2->public, 'conf_date', "ALTER TABLE $mysubscribe2->public ADD conf_date DATE AFTER ip"); 
  287.         maybe_add_column($mysubscribe2->public, 'conf_time', "ALTER TABLE $mysubscribe2->public ADD conf_time TIME AFTER conf_date"); 
  288.         maybe_add_column($mysubscribe2->public, 'conf_ip', "ALTER TABLE $mysubscribe2->public ADD conf_ip char(64) AFTER conf_time"); 
  289.  
  290.         // remove unnecessary table data 
  291.         $wpdb->query( "DELETE FROM $wpdb->usermeta WHERE meta_key = 's2_cat'" ); 
  292.  
  293.         $sql = "SELECT ID FROM $wpdb->users INNER JOIN $wpdb->usermeta ON ( $wpdb->users.ID = $wpdb->usermeta.user_id) WHERE ( $wpdb->usermeta.meta_key = '" . $mysubscribe2->get_usermeta_keyname('s2_subscribed') . "' AND $wpdb->usermeta.meta_value LIKE ', %' )"; 
  294.         $users = $wpdb->get_results($sql); 
  295.         foreach ( $users as $user ) { 
  296.             // make sure we remove leading ', ' from this setting 
  297.             $subscribed = get_user_meta($user->ID, $mysubscribe2->get_usermeta_keyname('s2_subscribed'), true); 
  298.             $old_cats = explode(', ', $subscribed); 
  299.             unset($old_cats[0]); 
  300.             $cats = implode(', ', $old_cats); 
  301.             update_user_meta($user->ID, $mysubscribe2->get_usermeta_keyname('s2_subscribed'), $cats); 
  302.         } 
  303.     } // end upgrade86() 
  304.  
  305.     function upgrade88() { 
  306.         // to ensure compulsory category collects all users we need there to be s2_subscribed meta-keys for all users 
  307.         global $mysubscribe2; 
  308.  
  309.         if ( version_compare($mysubscribe2->wp_release, '3.5', '<') ) { 
  310.             $all_registered = $mysubscribe2->get_all_registered('ID'); 
  311.             if ( !empty($all_registered) ) { 
  312.                 foreach ( $all_registered as $user_ID ) { 
  313.                     $check_subscribed = get_user_meta($user_ID, $mysubscribe2->get_usermeta_keyname('s2_subscribed'), true); 
  314.                     if ( empty($check_subscribed) ) { 
  315.                         update_user_meta($user_ID, $mysubscribe2->get_usermeta_keyname('s2_subscribed'), ''); 
  316.                     } 
  317.                 } 
  318.             } 
  319.         } else { 
  320.             $args = array( 
  321.                 'meta_query' => array( 
  322.                     array('key' => $mysubscribe2->get_usermeta_keyname('s2_subscribed'), 'compare' => 'NOT EXISTS') 
  323.  ) 
  324.  ); 
  325.  
  326.             $user_query = new WP_User_Query( $args ); 
  327.             $users = $user_query->get_results(); 
  328.             if ( !empty($users) ) { 
  329.                 foreach ($users as $user) { 
  330.                     update_user_meta($user->ID, $mysubscribe2->get_usermeta_keyname('s2_subscribed'), ''); 
  331.                 } 
  332.             } 
  333.         } 
  334.  
  335.         // check the time column again as the upgrade86() function contained a bug 
  336.         // include upgrade-functions for maybe_add_column; 
  337.         if ( !function_exists('maybe_add_column') ) { 
  338.             require_once(ABSPATH . 'wp-admin/install-helper.php'); 
  339.         } 
  340.         maybe_add_column($mysubscribe2->public, 'time', "ALTER TABLE $mysubscribe2->public ADD time TIME DEFAULT '00:00:00' NOT NULL AFTER date"); 
  341.     } // end upgrade88() 
  342.  
  343.     function upgrade100() { 
  344.         global $mysubscribe2; 
  345.         if ( $mysubscribe2->subscribe2_options['email_freq'] != 'never' ) { 
  346.             $mysubscribe2->subscribe2_options['last_s2cron'] = ''; 
  347.             unset($mysubscribe2->subscribe2_options['previous_s2cron']); 
  348.         } 
  349.     } // end upgrade100() 
  350. }