main

<?php

​

class WPML_ST_Upgrade_MO_Scanning implements IWPML_St_Upgrade_Command {

    /** @var wpdb $wpdb */

    private $wpdb;

​

    private static $sql = "

        CREATE TABLE `PREFIXicl_mo_files_domains` (

          `id` int(11) PRIMARY KEY NOT NULL AUTO_INCREMENT,

          `file_path` varchar(250) NOT NULL,

          `file_path_md5` varchar(32) NOT NULL,

          `domain` varchar(160) NOT NULL,

          `status` varchar(20) NOT NULL DEFAULT %s,

          `num_of_strings` int(11) NOT NULL DEFAULT '0',

          `last_modified` int(11) NOT NULL,

          `component_type` enum('plugin','theme','other') NOT NULL DEFAULT 'other',

          `component_id` varchar(100) DEFAULT NULL,

          UNIQUE KEY `file_path_md5_UNIQUE` (`file_path_md5`)

        )

    ";

​

    /**

     * @param wpdb $wpdb

     */

    public function __construct( wpdb $wpdb ) {

        $this->wpdb = $wpdb;

    }

​

​

    public function run() {

        return $this->create_table() && $this->add_mo_value_field_if_does_not_exist();

    }

​

    private function create_table() {

        $table_name = $this->wpdb->prefix . 'icl_mo_files_domains';

        $this->wpdb->query( "DROP TABLE IF EXISTS `{$table_name}`" );

​

        $sql = str_replace( 'PREFIX', $this->wpdb->prefix, self::$sql );

        $sql = $this->wpdb->prepare(

            $sql,

            array( WPML_ST_Translations_File_Entry::NOT_IMPORTED )

        );

​

        $sql .= $this->get_charset_collate();

​

        return false !== $this->wpdb->query( $sql );

    }

​

    private function add_mo_value_field_if_does_not_exist() {

        $result = true;

​

        $table_name = $this->wpdb->prefix . 'icl_string_translations';

        if ( 0 === count( $this->wpdb->get_results( "SHOW COLUMNS FROM `{$table_name}` LIKE 'mo_string'" ) ) ) {

            $sql = "

                ALTER TABLE {$table_name} 

                ADD COLUMN `mo_string` TEXT NULL DEFAULT NULL AFTER `value`;

            ";

​

            $result = false !== $this->wpdb->query( $sql );

        }

​

        return $result;

    }