[oik] plugins.com

WordPress plugins and themes

  • Home
  • About
    • lazy shortcodes
    • smart shortcodes
    • oik base plugin
      • oik – donate
      • oik PayPal buttons
      • oik installation
      • oik Button Shortcode button
      • oik changelog
      • oik FAQ
      • oik plugins on SVN
      • oik plugins on GitHub
  • Plugins
    • oik base plugin
    • FREE oik plugins
    • WordPress plugins
    • Premium oik plugins
    • Bespoke oik plugins
  • Shortcodes
    • Shortcode examples
  • Blocks
    • Block examples
  • APIs
    • ALL action and filter hooks
  • Blog

OIK_innodb::convert_engine() – Convert tables from one engine to another

You appear to be a bot. Output may be restricted

Description

Convert tables from one engine to another

We assume that the WordPress user has the authority to alter tables

Usage

OIK_innodb::convert_engine( $from_engine, $to_engine );

Parameters

$from_engine
( string ) optional default: MyISAM –
$to_engine
( string ) optional default: INNODB –

Returns

void

Source

File name: oik-batch/class-oik-innodb.php
Lines:

1 to 12 of 12
  function convert_engine( $from_engine="MyISAM", $to_engine="INNODB" ) {
    global $wpdb;
    foreach ( $this->results as $result ) {
      if ( $from_engine == $result->engine ) {
        //$query = $wpdb->prepare( "ALTER TABLE %s engine=%s", DB_NAME . "." . $result->table_name, $to_engine );
        $query = sprintf( "ALTER TABLE %s engine=%s", $result->table_name, $to_engine );
        echo $query;
        echo PHP_EOL;
        $rows_affected = $wpdb->query( $query );
      }
    }
  }
 

 View on GitHub

Published: March 14, 2017 | Last updated: March 14, 2017

Information

Function name: OIK_innodb::convert_engine
Class ref: OIK_innodb
Plugin ref: oik-batch
Version: 1.0.0
Sourcefile: class-oik-innodb.php
File ref: class-oik-innodb.php
Deprecated?: No
API Letters: C,E,I,O

Recent plugin updates

sb-chart-block v0.3.0 sb-chart-block v0.3.0 now uses Chartjs v3.1.0. It also delivers two more Colour palettes. ...
sb-chart-block v0.2.0 sb-chart-block v0.2.0 has been updated for hosting on WordPress.org. The code now uses improved color palette selection using palette.json. ...
oik-weight-zone-shipping v0.2.4 oik-weight-zone-shipping v0.2.4 contains a fix to calculate a handling fee as a percentage of the total cart cost. ...
oik-types v2.0.0 oik-types v2.0.0 contains a fix for a problem noted with Gutenberg Navigation blocks. Existing menus were being loaded in the wrong order.  ...
oik-css v1.2.0 

Upgrade to oik-css v1.2.0 for PHP 8 support. Tested with WordPress 5.7

 ...

Plugins

  • All Plugins
  • oik base plugin
  • FREE oik plugins
  • WordPress plugins
  • Premium oik plugins

Themes

  • FREE themes
  • Bespoke themes
  • Premium themes

Blocks

  • All Blocks
  • Block examples
  • About Blocks

Shortcodes

  • All Shortcodes
  • Shortcode examples
  • About Shortcodes

Reference

  • About APIs
  • All APIs
  • All Classes
  • All Files
  • All Hooks

Support

  • Contact
  • Cookies policy
  • Get API key
  • Privacy
  • Request support
  • Sitemap
  • Stay informed
  • Terms and Conditions
oik-plugins
Email: [email protected]

Weight shipping plugins

Find out which cart weight shipping plugin you need for your WooCommerce site.
Which cart weight based plugin do I need?

Site:  www.oik-plugins.com
© Copyright oik-plugins 2011-2021. All rights reserved.


Website designed and developed by Herb Miller of Bobbing Wide
Proudly powered by WordPress and oik-plugins