WordPress.org
Get WordPress

Plugin Directory

Changeset 1680273


Ignore:
Timestamp:
06/17/2017 09:56:58 AM (9 years ago)
Author:
vlastuin
Message:

Release 1.1.5 - See changelog

Location:
vevida-optimizer
Files:
6 edited
1 copied

Legend:

Unmodified
Added
Removed

  • vevida-optimizer/tags/1.1.5/plugins/convert.php

    r1517812 r1680273  
    7171            FROM information_schema.statistics
    7272            WHERE index_type = 'FULLTEXT'
    73             AND table_name = ".'$row->table_name');
     73            AND table_name = '$row->table_name'");
    7474    if ( $fulltextIndex ) {
    7575            continue;
    7676    }
    77         $wpdb->query("ALTER TABLE `{$row->table_name}` ENGINE=InnoDB");
     77        $wpdb->query("ALTER TABLE {$row->table_name} ENGINE=InnoDB");
    7878    }
    7979
    80     $indexResults = $wpdb->get_results("SHOW INDEXES FROM `{$wpdb->options}` WHERE Column_name='autoload'");
     80    $indexResults = $wpdb->get_results("SHOW INDEXES FROM {$wpdb->options} WHERE Column_name='autoload'");
    8181    if (!$indexResults) {
    82         $addedIndex = $wpdb->query("ALTER TABLE `{$wpdb->options}` ADD INDEX autoload(`autoload`)");
     82        $addedIndex = $wpdb->query("ALTER TABLE {$wpdb->options} ADD INDEX autoload(`autoload`)");
    8383        if (!$addedIndex) {
    8484            // ALTER TABLE returned an error

  • vevida-optimizer/tags/1.1.5/readme.txt

    r1585092 r1680273  
    1616== Description ==
    1717
    18 Installing WordPress is one thing, keeping it up to date is something else. Each
    19 week brings new bugs or potential attack scenarios that will make a WordPress
    20 website vulnerable to hacks. Enabling automatic updates for all or at least most
    21 parts of WordPress solves a large number of problems with irregularly maintained
    22 WordPress websites.
     18Installing WordPress is one thing, keeping it up to date is something else. Each week brings new bugs or potential attack scenarios that will make a WordPress website vulnerable to hacks. Enabling automatic updates for all or at least most parts of WordPress solves a large number of problems with irregularly maintained WordPress websites.
    2319 
    24 This plugin extends the automatic update feature already present in WordPress.
    25 The core updates can be switched on or off, themes and translations can be
    26 automatically updated, and the plugin updates can be configured on a per-plugin
    27 basis.
     20This plugin extends the automatic update feature already present in WordPress.  The core updates can be switched on or off, themes and translations can be automatically updated, and the plugin updates can be configured on a per-plugin basis.
    2821
    29 Many websites started originally with older versions of
    30 WordPress. Previously those installs used older versions of MySQL, when the
    31 default table format was MyISAM. Nowadays, modern versions of MySQL use the
    32 InnoDB format, which is currently enabled by default. Through this plugin
    33 the database tables can be optimized for those newer versions of MySQL,
    34 converting older MyISAM tables to InnoDB.
    35 This is required only once, and only when you have been using WordPress for a
    36 long time or with a hosting provider that has not actively kept its MySQL
    37 installations up to date.
     22Many websites started originally with older versions of WordPress. Previously those installs used older versions of MySQL, when the default table format was MyISAM. Nowadays, modern versions of MySQL use the InnoDB format, which is currently enabled by default. Through this plugin the database tables can be optimized for those newer versions of MySQL, converting older MyISAM tables to InnoDB.  This is required only once, and only when you have been using WordPress for a long time or with a hosting provider that has not actively kept its MySQL installations up to date.
    3823
    39 Vevida is a major webhosting provider based in The Netherlands. We have been
    40 hosting websites since 1997. We offer specialized WordPress hosting, which
    41 includes this plugin by default. This plugin is useful for all WordPress users,
    42 so we make the latest version of this plugin available in the WordPress
    43 repository. The source code is also freely available on GitHub.
     24Vevida is a major webhosting provider based in The Netherlands. We have been hosting websites since 1997. We offer specialized WordPress hosting, which includes this plugin by default. This plugin is useful for all WordPress users, so we make the latest version of this plugin available in the WordPress repository. The source code is also freely available on GitHub. 
    4425
    4526== Installation ==
    … …  
    50311. Optimize your MySQL database through 'Tools' -> 'Convert DB tables'
    5132
    52 Or login to WordPress. Go to Plugins -> Add New and search for Vevida. The search
    53 box is located at the top right of the page. Click Install and enjoy
    54 automatic updates.
     33Or login to WordPress. Go to Plugins -> Add New and search for Vevida. The search box is located at the top right of the page. Click Install and enjoy automatic updates.
    5534
    5635== Frequently Asked Questions ==
    … …  
    5837= How can I configure Auto-Updates? =
    5938
    60 Go to 'Dashboard' -> 'Update Settings'. The core updates can be switched on or
    61 off, themes and translations can be automatically updated, and individual plugin
    62 updates can also be configured.
     39Go to 'Dashboard' -> 'Update Settings'. The core updates can be switched on or off, themes and translations can be automatically updated, and individual plugin updates can also be configured.
    6340
    6441= Why would I use Auto-Updates? =
    6542
    66 Not updating your WordPress site regularly exposes your site and your hosting
    67 provider to bugs and other attack vectors that can enable an attacker to hack
    68 into your website. Keeping your WordPress website up-to-date is one of the key
    69 ingredients to keeping your website secure.
     43Not updating your WordPress site regularly exposes your site and your hosting provider to bugs and other attack vectors that can enable an attacker to hack into your website. Keeping your WordPress website up-to-date is one of the key ingredients to keeping your website secure.
    7044
    7145= Why would I not use Auto-Updates? =
    7246
    73 If you are an expert user of WordPress, and you are always available to test each
    74 and every new version of each and every plugin, theme and core update before deploying
    75 them to your server, then you don't need this plugin. However, the plugin offers
    76 a unique selection mechanism whereby only those parts you want to auto-update,
    77 will in fact auto-update.
     47If you are an expert user of WordPress, and you are always available to test each and every new version of each and every plugin, theme and core update before deploying them to your server, then you don't need this plugin. However, the plugin offers a unique selection mechanism whereby only those parts you want to auto-update, will in fact auto-update.
    7848
    7949= Why has this or that plugin not been updated yet? =
    8050
    81 First check whether automatic updates are enabled for the plugin in 'Dashboard'
    82 -> 'Update Settings'. If automatic updates are enabled, it can take up to 12
    83 hours for a plugin to actually update.
     51First check whether automatic updates are enabled for the plugin in 'Dashboard' -> 'Update Settings'. If automatic updates are enabled, it can take up to 12 hours for a plugin to actually update.
    8452
    8553= How can I optimize my database tables =
    8654
    87 Go to Tools -> Convert DB tables. This will launch the utility that converts
    88 MyISAM tables to InnoDB.
     55Go to Tools -> Convert DB tables. This will launch the utility that converts MyISAM tables to InnoDB.
    8956
    9057= Why would I convert my database tables? =
    9158
    92 Many older versions of MySQL used MyISAM tables by default. Nowadays InnoDB is
    93 used by recent versions of MySQL, and this is a much faster format. If you have
    94 created your WordPress site in the past on previous versions of MySQL, chances
    95 are that you still use MyISAM.
     59Many older versions of MySQL used MyISAM tables by default. Nowadays InnoDB is used by recent versions of MySQL, and this is a much faster format. If you have created your WordPress site in the past on previous versions of MySQL, chances are that you still use MyISAM.
    9660
    9761= Can I use this plugin on hosting platforms other than at vevida.com? =
    9862
    99 Of course you can, and we encourage you to use our plugin to keep your website
    100 up to date. That's why we made it available in the WordPress repository, and the
    101 source code is available on GitHub: https://github.com/vlastuin/vevida-optimizer
     63Of course you can, and we encourage you to use our plugin to keep your website up to date. That's why we made it available in the WordPress repository, and the source code is available on GitHub: https://github.com/vlastuin/vevida-optimizer
    10264
    10365== Screenshots ==
    … …  
    10668
    10769== Changelog ==
     70
     71= 1.1.5 =
     72Release date: June 17th 2017
     73* Fix: Table conversion bug solved
     74* Adapted readme.txt to new WordPress website
     75* Compatibility with WP 4.8
    10876
    10977= 1.1.4 =

  • vevida-optimizer/tags/1.1.5/vevida-optimizer.php

    r1517817 r1680273  
    44 * Plugin URI: https://wordpress.org/plugins/vevida-optimizer/
    55 * Description: Configure automatic updates for each WordPress component, and optimize the mySQL database tables.
    6  * Version: 1.1.4
     6 * Version: 1.1.5
    77 * Author: Jan Vlastuin, Jan Reilink
    88 * Author URI: http://vevida.hosting

  • vevida-optimizer/trunk/plugins/convert.php

    r1517812 r1680273  
    7171            FROM information_schema.statistics
    7272            WHERE index_type = 'FULLTEXT'
    73             AND table_name = ".'$row->table_name');
     73            AND table_name = '$row->table_name'");
    7474    if ( $fulltextIndex ) {
    7575            continue;
    7676    }
    77         $wpdb->query("ALTER TABLE `{$row->table_name}` ENGINE=InnoDB");
     77        $wpdb->query("ALTER TABLE {$row->table_name} ENGINE=InnoDB");
    7878    }
    7979
    80     $indexResults = $wpdb->get_results("SHOW INDEXES FROM `{$wpdb->options}` WHERE Column_name='autoload'");
     80    $indexResults = $wpdb->get_results("SHOW INDEXES FROM {$wpdb->options} WHERE Column_name='autoload'");
    8181    if (!$indexResults) {
    82         $addedIndex = $wpdb->query("ALTER TABLE `{$wpdb->options}` ADD INDEX autoload(`autoload`)");
     82        $addedIndex = $wpdb->query("ALTER TABLE {$wpdb->options} ADD INDEX autoload(`autoload`)");
    8383        if (!$addedIndex) {
    8484            // ALTER TABLE returned an error

  • vevida-optimizer/trunk/readme.txt

    r1585092 r1680273  
    1616== Description ==
    1717
    18 Installing WordPress is one thing, keeping it up to date is something else. Each
    19 week brings new bugs or potential attack scenarios that will make a WordPress
    20 website vulnerable to hacks. Enabling automatic updates for all or at least most
    21 parts of WordPress solves a large number of problems with irregularly maintained
    22 WordPress websites.
     18Installing WordPress is one thing, keeping it up to date is something else. Each week brings new bugs or potential attack scenarios that will make a WordPress website vulnerable to hacks. Enabling automatic updates for all or at least most parts of WordPress solves a large number of problems with irregularly maintained WordPress websites.
    2319 
    24 This plugin extends the automatic update feature already present in WordPress.
    25 The core updates can be switched on or off, themes and translations can be
    26 automatically updated, and the plugin updates can be configured on a per-plugin
    27 basis.
     20This plugin extends the automatic update feature already present in WordPress.  The core updates can be switched on or off, themes and translations can be automatically updated, and the plugin updates can be configured on a per-plugin basis.
    2821
    29 Many websites started originally with older versions of
    30 WordPress. Previously those installs used older versions of MySQL, when the
    31 default table format was MyISAM. Nowadays, modern versions of MySQL use the
    32 InnoDB format, which is currently enabled by default. Through this plugin
    33 the database tables can be optimized for those newer versions of MySQL,
    34 converting older MyISAM tables to InnoDB.
    35 This is required only once, and only when you have been using WordPress for a
    36 long time or with a hosting provider that has not actively kept its MySQL
    37 installations up to date.
     22Many websites started originally with older versions of WordPress. Previously those installs used older versions of MySQL, when the default table format was MyISAM. Nowadays, modern versions of MySQL use the InnoDB format, which is currently enabled by default. Through this plugin the database tables can be optimized for those newer versions of MySQL, converting older MyISAM tables to InnoDB.  This is required only once, and only when you have been using WordPress for a long time or with a hosting provider that has not actively kept its MySQL installations up to date.
    3823
    39 Vevida is a major webhosting provider based in The Netherlands. We have been
    40 hosting websites since 1997. We offer specialized WordPress hosting, which
    41 includes this plugin by default. This plugin is useful for all WordPress users,
    42 so we make the latest version of this plugin available in the WordPress
    43 repository. The source code is also freely available on GitHub.
     24Vevida is a major webhosting provider based in The Netherlands. We have been hosting websites since 1997. We offer specialized WordPress hosting, which includes this plugin by default. This plugin is useful for all WordPress users, so we make the latest version of this plugin available in the WordPress repository. The source code is also freely available on GitHub. 
    4425
    4526== Installation ==
    … …  
    50311. Optimize your MySQL database through 'Tools' -> 'Convert DB tables'
    5132
    52 Or login to WordPress. Go to Plugins -> Add New and search for Vevida. The search
    53 box is located at the top right of the page. Click Install and enjoy
    54 automatic updates.
     33Or login to WordPress. Go to Plugins -> Add New and search for Vevida. The search box is located at the top right of the page. Click Install and enjoy automatic updates.
    5534
    5635== Frequently Asked Questions ==
    … …  
    5837= How can I configure Auto-Updates? =
    5938
    60 Go to 'Dashboard' -> 'Update Settings'. The core updates can be switched on or
    61 off, themes and translations can be automatically updated, and individual plugin
    62 updates can also be configured.
     39Go to 'Dashboard' -> 'Update Settings'. The core updates can be switched on or off, themes and translations can be automatically updated, and individual plugin updates can also be configured.
    6340
    6441= Why would I use Auto-Updates? =
    6542
    66 Not updating your WordPress site regularly exposes your site and your hosting
    67 provider to bugs and other attack vectors that can enable an attacker to hack
    68 into your website. Keeping your WordPress website up-to-date is one of the key
    69 ingredients to keeping your website secure.
     43Not updating your WordPress site regularly exposes your site and your hosting provider to bugs and other attack vectors that can enable an attacker to hack into your website. Keeping your WordPress website up-to-date is one of the key ingredients to keeping your website secure.
    7044
    7145= Why would I not use Auto-Updates? =
    7246
    73 If you are an expert user of WordPress, and you are always available to test each
    74 and every new version of each and every plugin, theme and core update before deploying
    75 them to your server, then you don't need this plugin. However, the plugin offers
    76 a unique selection mechanism whereby only those parts you want to auto-update,
    77 will in fact auto-update.
     47If you are an expert user of WordPress, and you are always available to test each and every new version of each and every plugin, theme and core update before deploying them to your server, then you don't need this plugin. However, the plugin offers a unique selection mechanism whereby only those parts you want to auto-update, will in fact auto-update.
    7848
    7949= Why has this or that plugin not been updated yet? =
    8050
    81 First check whether automatic updates are enabled for the plugin in 'Dashboard'
    82 -> 'Update Settings'. If automatic updates are enabled, it can take up to 12
    83 hours for a plugin to actually update.
     51First check whether automatic updates are enabled for the plugin in 'Dashboard' -> 'Update Settings'. If automatic updates are enabled, it can take up to 12 hours for a plugin to actually update.
    8452
    8553= How can I optimize my database tables =
    8654
    87 Go to Tools -> Convert DB tables. This will launch the utility that converts
    88 MyISAM tables to InnoDB.
     55Go to Tools -> Convert DB tables. This will launch the utility that converts MyISAM tables to InnoDB.
    8956
    9057= Why would I convert my database tables? =
    9158
    92 Many older versions of MySQL used MyISAM tables by default. Nowadays InnoDB is
    93 used by recent versions of MySQL, and this is a much faster format. If you have
    94 created your WordPress site in the past on previous versions of MySQL, chances
    95 are that you still use MyISAM.
     59Many older versions of MySQL used MyISAM tables by default. Nowadays InnoDB is used by recent versions of MySQL, and this is a much faster format. If you have created your WordPress site in the past on previous versions of MySQL, chances are that you still use MyISAM.
    9660
    9761= Can I use this plugin on hosting platforms other than at vevida.com? =
    9862
    99 Of course you can, and we encourage you to use our plugin to keep your website
    100 up to date. That's why we made it available in the WordPress repository, and the
    101 source code is available on GitHub: https://github.com/vlastuin/vevida-optimizer
     63Of course you can, and we encourage you to use our plugin to keep your website up to date. That's why we made it available in the WordPress repository, and the source code is available on GitHub: https://github.com/vlastuin/vevida-optimizer
    10264
    10365== Screenshots ==
    … …  
    10668
    10769== Changelog ==
     70
     71= 1.1.5 =
     72Release date: June 17th 2017
     73* Fix: Table conversion bug solved
     74* Adapted readme.txt to new WordPress website
     75* Compatibility with WP 4.8
    10876
    10977= 1.1.4 =

  • vevida-optimizer/trunk/vevida-optimizer.php

    r1517817 r1680273  
    44 * Plugin URI: https://wordpress.org/plugins/vevida-optimizer/
    55 * Description: Configure automatic updates for each WordPress component, and optimize the mySQL database tables.
    6  * Version: 1.1.4
     6 * Version: 1.1.5
    77 * Author: Jan Vlastuin, Jan Reilink
    88 * Author URI: http://vevida.hosting
Note: See TracChangeset for help on using the changeset viewer.